The Halfling Scribe is back to manage your league ...

However you play online - Java, Vassal, Email, Cyanide etc - talk about it here.
This is also the place for discussing the various tools for managing leagues, teams and so on.

Moderator: TFF Mods

Tim
Da Tulip Champ II
Posts: 3458
Joined: Wed Oct 16, 2002 4:18 pm
Location: Heidelberg, Germany
Contact:

The Halfling Scribe is back to manage your league ...

Post by Tim »

... and he learned some new rules and tricks ;)

For those who haven't heard of it, the Supernumerate Halfling Scribe League Manager is an Excel Workbook that manages Blood Bowl leagues of up to 25 teams.

Newest version is 4.0 with the following new features:

- Ruleset switchable between LRB 5 and LRB 6 (latest version as posted by Galak) ruleset
- New BBRC endorsed teamlists and starplayers included (new teamlists also available as experimental in LRB5 ruleset)
- New overview sheet
- Seasonal data ranges for team stats
- Extraordinary skill gains supported (Chaos cup mutations, Fan Favorite, etc.)
- Gate stats splitted between teams
- Several minor fixes

You can find the new version for download here:
http://bbowl.gmxhome.de/scribe/

If you have questions or find errors, please let me know here.

Link to discussion of old version (for reference only):

Reason: ''
Image
"In NUFFLE we trust!" - Retired Inquisitor of Nuffle.
Father of the Halfling Scribe
Admin of the Kurpfalz Cup
User avatar
lunchmoney
Legend
Legend
Posts: 8859
Joined: Wed Dec 10, 2008 2:59 pm
Location: The Dark Future

Re: The Halfling Scribe is back to manage your league ...

Post by lunchmoney »

awesome. i had updated the database for lrb5+ for my league, wasnt looking forward to doing it again. thanks tim :)

Reason: ''
Hired Goon for the NAF (rep for South West England)
Image
lunchmoneybb@gmail.com

TOs! You do not need multiple copies of rosters. It's a waste of paper.
Bribe level: good coffee.
#FlingNation find me on page 95
adamcarl
Experienced
Experienced
Posts: 105
Joined: Mon Mar 30, 2009 6:06 am
Location: Sweden

Re: The Halfling Scribe is back to manage your league ...

Post by adamcarl »

Thanks a million Tim

Reason: ''
Commissionner of Vassunda Blood Bowl League.
User avatar
lunchmoney
Legend
Legend
Posts: 8859
Joined: Wed Dec 10, 2008 2:59 pm
Location: The Dark Future

Re: The Halfling Scribe is back to manage your league ...

Post by lunchmoney »

Dont know whats causing the problem, but if i add more team sheets and save it, it crashes when i open the file again.

Reason: ''
Hired Goon for the NAF (rep for South West England)
Image
lunchmoneybb@gmail.com

TOs! You do not need multiple copies of rosters. It's a waste of paper.
Bribe level: good coffee.
#FlingNation find me on page 95
Tim
Da Tulip Champ II
Posts: 3458
Joined: Wed Oct 16, 2002 4:18 pm
Location: Heidelberg, Germany
Contact:

Re: The Halfling Scribe is back to manage your league ...

Post by Tim »

i've heard that quite some times now with other versions of the sheet and never got to reproduce the effect on my computers. My guess is that it's a memory issue somehow.

Can you send the file that crashes on your PC when opening to my email? Then i can check if i can reproduce the effect this time.

If you have Office 2007, i've created a version without backwards compatibility (.XLSB format), that uses only 6% (!!!) of the file size. You'll find it on my website in the same archive as the .XLS.

Reason: ''
Image
"In NUFFLE we trust!" - Retired Inquisitor of Nuffle.
Father of the Halfling Scribe
Admin of the Kurpfalz Cup
User avatar
lunchmoney
Legend
Legend
Posts: 8859
Joined: Wed Dec 10, 2008 2:59 pm
Location: The Dark Future

Re: The Halfling Scribe is back to manage your league ...

Post by lunchmoney »

cant open file at work. we aint all that modern here. :)

i'll try it at home later.
thanks for getting on it quickly though 8)

Reason: ''
Hired Goon for the NAF (rep for South West England)
Image
lunchmoneybb@gmail.com

TOs! You do not need multiple copies of rosters. It's a waste of paper.
Bribe level: good coffee.
#FlingNation find me on page 95
Tim
Da Tulip Champ II
Posts: 3458
Joined: Wed Oct 16, 2002 4:18 pm
Location: Heidelberg, Germany
Contact:

Re: The Halfling Scribe is back to manage your league ...

Post by Tim »

I also found a small error that causes compatibility error messages to occur during saving ... :evil:

All teamsheets have an unused data validation in cell Z25 that causes this error. Please either delete that data validaiton in your version or redownload V4.01 (i'll upload it up tonight).

Edit: V4.01 available on website.

Reason: ''
Image
"In NUFFLE we trust!" - Retired Inquisitor of Nuffle.
Father of the Halfling Scribe
Admin of the Kurpfalz Cup
User avatar
lunchmoney
Legend
Legend
Posts: 8859
Joined: Wed Dec 10, 2008 2:59 pm
Location: The Dark Future

Re: The Halfling Scribe is back to manage your league ...

Post by lunchmoney »

one of the joys of win7. if a program crashes too often it starts searching for updates. after i made the cook book/office excel crash for the 5th time i was offered some updates. this appears to have solved the issue i had.
thanks to Tim for getting in contact.

Reason: ''
Hired Goon for the NAF (rep for South West England)
Image
lunchmoneybb@gmail.com

TOs! You do not need multiple copies of rosters. It's a waste of paper.
Bribe level: good coffee.
#FlingNation find me on page 95
Tim
Da Tulip Champ II
Posts: 3458
Joined: Wed Oct 16, 2002 4:18 pm
Location: Heidelberg, Germany
Contact:

Re: The Halfling Scribe is back to manage your league ...

Post by Tim »

V4.02 released with a minor fix fix in the league scoring calculation (scoring based on touchdowns scored was not working).

While i was at it, i added some new calculation options to create custom league ranking systems. It will now handle all kinds of touchdown and/or casualty based bonus points. ?!?

.XLSB for Excel 2007 is removed from download. Use "Save as" in Excel 2007 to create it.

Reason: ''
Image
"In NUFFLE we trust!" - Retired Inquisitor of Nuffle.
Father of the Halfling Scribe
Admin of the Kurpfalz Cup
User avatar
Funksultan
Veteran
Veteran
Posts: 167
Joined: Thu Jul 05, 2007 2:27 pm

Re: The Halfling Scribe is back to manage your league ...

Post by Funksultan »

Tim, you rock. I'm sure you already knew that, but still.... there it is again.

No donation page, so what figs are ya looking for?

D

Reason: ''
Tim
Da Tulip Champ II
Posts: 3458
Joined: Wed Oct 16, 2002 4:18 pm
Location: Heidelberg, Germany
Contact:

Re: The Halfling Scribe is back to manage your league ...

Post by Tim »

Thanks alot, glad you like it. I have some fun in maintaining the sheet and enjoy contributing to the community, so I'm not looking for any kind of compensation.

If you want to donate, you can always give a few bugs to charity on behalf of the Halfling Scribe. In Haiti, for example, i'd say they need every $.

Reason: ''
Image
"In NUFFLE we trust!" - Retired Inquisitor of Nuffle.
Father of the Halfling Scribe
Admin of the Kurpfalz Cup
User avatar
Funksultan
Veteran
Veteran
Posts: 167
Joined: Thu Jul 05, 2007 2:27 pm

Re: The Halfling Scribe is back to manage your league ...

Post by Funksultan »

Haiti it is!

On another note... have you contemplated an option to print a single-page roster for a team yet? (ideally this being the page they play with and provide a copy for their opponent to peruse...).

That's all it seems to be lacking, but either way, it's still great.

D

Reason: ''
polecat89
Rookie
Rookie
Posts: 8
Joined: Tue Mar 15, 2005 3:06 am

Re: The Halfling Scribe is back to manage your league ...

Post by polecat89 »

Hey Tim, great job on this as always. I had a request though. I saw on the forum topic for the old version that you could make a 50 team version. Would it be possible for you to make a 48 team version? I'm comfortable with editing the database, but have a feeling I would really mess this up if I tried to do it myself.

Reason: ''
User avatar
Insane_Prophet
Star Player
Star Player
Posts: 662
Joined: Fri Mar 19, 2010 11:43 pm
Location: London

Re: The Halfling Scribe is back to manage your league ...

Post by Insane_Prophet »

Is the value for Extraordinary skills supposed to be added to a players TV automatically? A Wight in our league has gained the Fan Favourite skill and I've entered 30,000 into the value column (AG) but this doesn't seem to have updated the value in column S.

Reason: ''
Hellboy
Rookie
Rookie
Posts: 5
Joined: Thu Jun 25, 2009 4:51 pm

Re: The Halfling Scribe is back to manage your league ...

Post by Hellboy »

Hi Tim,
I've just discovered your amazing excel file! I'm planning on using it for the new league that kicks off next month.
But I've noticed - while testing/messing around - it didn't change the teamvalue when one player would misses the next game? Is there a special code I should put in the injury field?
Thanx for replying!

Reason: ''
Post Reply