Talk Fantasy Football

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/

Very very cool!

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

I am having trouble with the match results anyone help

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)

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.

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

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

Yes !!

looks pretty cool.

I'll find out about it tomorrow

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

@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.

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

Thanks, i'll correct that.

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

Seems that GW has poisoned me

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

Another easy fix. this evening

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 =)