New Excel Blood Bowl League Management Tool

Tim · Post by **Tim** » Wed Feb 26, 2003 2:53 pm

The Supernumerate Halfling Scribe
&nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp is proud to present
The Halfling Scribe's Excel League Management Sheet

- Team Management with for all official races with all stats for position players
- Automatic TR calculation
- League Management of up to 32 Teams
- Automatic Top-N Team and Player Stats
...

to try it out, go here:
http://bloodbowl.bei.t-online.de/scribe/

redlizard · Post by **redlizard** » Wed Feb 26, 2003 6:02 pm

Very very cool!

Raven_Talons · Post by **Raven_Talons** » Wed Feb 26, 2003 8:16 pm

it is very good quailty. It's very easy to learn

Raven_Talons · Post by **Raven_Talons** » Wed Feb 26, 2003 8:43 pm

I am having trouble with the match results anyone help

Tim · Post by **Tim** » Wed Feb 26, 2003 9:52 pm

specifiy: trouble

1. both teams must have a maintained teamsheet
2. column D and E select both teams via drop box (may have to scroll upwards in the dropbox)
3. Touchdowns for go into column F, TD against into H, step over G, a dash will be entered automatically.
4. Same for casulties in I and K
5. Gate is just for statistics

Here's an example from our leagues current season (21 games played):
http://bloodbowl.bei.t-online.de/bb-liga-2003-01.xls (large file >1 MB)

ZanzerTem · Post by **ZanzerTem** » Wed Feb 26, 2003 10:27 pm

How do you modify the contents of the Race box? I want to add some experimental teams (ogres, Rotters, ect), but can't figure it out.

Marcus · Post by **Marcus** » Wed Feb 26, 2003 11:16 pm

Tim: if you are the chap responsible for the Scribe, big up respect. Was used heavily back in my OLBBL days.

Post by **Dave** » Wed Feb 26, 2003 11:22 pm

loading ... loading ... loading ... loading ...

Yes !!

looks pretty cool.

I'll find out about it tomorrow

Raven_Talons · Post by **Raven_Talons** » Wed Feb 26, 2003 11:36 pm

Well when I put numbers in they dont show up and it never shows who wins or not

Tim · Post by **Tim** » Thu Feb 27, 2003 9:28 am

@Bloodbasher:
The race database is in a hidden sheet called database. You'll have to expand this and then update the names used for accessing this data from the team sheets.
Afterwards, go to team template and add some rows of formulas into hidden column AD, then change the validation list for E4.
Repeat this for all team sheets or recopy them from the template.

Be warned! This sheet is VERY complex, if you are not an Excel expert you better not change too much or it might not work properly anymore.

@Marcus:
Yes that's me, thank you! The proggie is still downloadable a bit lower on the same page.

lyannou · Post by **lyannou** » Thu Feb 27, 2003 10:05 am

Dwarf troll slayer skills are wrong there have also frenzy and dauntless

Tim · Post by **Tim** » Thu Feb 27, 2003 10:24 am

Thanks, i'll correct that.

lyannou · Post by **lyannou** » Thu Feb 27, 2003 10:34 am

there is also a little mistake on goblin team: it's not "orge" but "ogre"

Tim · Post by **Tim** » Thu Feb 27, 2003 11:03 am

Seems that GW has poisoned me

compare http://www.talkbloodbowl.com/phpBB2/vie ... php?t=4909

Another easy fix. this evening

ZanzerTem · Post by **ZanzerTem** » Thu Feb 27, 2003 3:18 pm

Thanks for pointing out the hidden columns. Didnt notice them.

Also, in cell AD25 you have the formula =IF(Database!A25<>"",Database!A25,"") which is linked to no data (cell A25 in Database is blank) Not sure if you cared, but thought I'd let you know =)