New Excel Blood Bowl League Management Tool

phil · Post by **phil** » Thu Feb 27, 2003 3:37 pm

is there a way to export/import team sheets into this at all? especially the export side?

good work, definitely...

Tim · Post by **Tim** » Thu Feb 27, 2003 3:56 pm

Phil,

what export formats do you think of?
ASC is no problem with Excels export functions.
HTML is possible via the Web Publish function, but the exported HTML files are (wonder why?) very Microsoftish and very large. I have defined print areas for all useful sheets, so if you just publish those you can get an working but clumpsy webpage for your league. Exporting a single team sheet is quite easy though and the results are acceptable.

Copy+Pasting the table to frontpage (

) gives something like a raw table format.

Cheers,
Tim.

phil · Post by **phil** » Thu Feb 27, 2003 4:15 pm

i was referring to an export to a format that can be used with the pbem client specifically, like what milo's team tracker is able to do... or an import from the same... those two features would make this app pretty much perfect in my esteem

Tim · Post by **Tim** » Thu Feb 27, 2003 4:21 pm

Hmm ... that would need some serious VB programming (not my field of expertise).

Maybe someone else wants to add this feature?

phil · Post by **phil** » Thu Feb 27, 2003 4:31 pm

the export code wouldn't be too tough to do, but i can't imagine finding the free time in my already overwhelming schedule to sort out the regular experssions needed to handle an import feature... didn't milo threaten to share his teamtracker with someone who wanted to carry on the design? perhaps these two could be merged by a cunning coder?

ZanzerTem · Post by **ZanzerTem** » Thu Feb 27, 2003 4:34 pm

Since I don't use PBeM, this team tracker is spot on

It must have taken a long time to do. Good job!

ZanzerTem · Post by **ZanzerTem** » Thu Feb 27, 2003 4:43 pm

A side note:

You might want to rezise row 5 on the Pairings sheet to 30 pixels. The team rating does not fit in it currently, and only shows a # instead.

Indigo · Post by **Indigo** » Thu Feb 27, 2003 4:44 pm

heh this rocks - I'm now going to transfer my entire league across to it!

on work's time of course

Tim · Post by **Tim** » Thu Feb 27, 2003 4:46 pm

Actually it was much less work than working out all the stats based on paper team sheets once.

And it was fun ... i really love that matrix formula feature of Excel.

tchatter · Post by **tchatter** » Thu Feb 27, 2003 4:47 pm

Actually I have 3 spreadsheets each unique for my 3 leagues.

And it is VERY EASY to import rosters. But very difficult to export them out of Excel because of the crappy xml and all the bloat that MS adds.

Here is what I do, I use the tool to update the roster, any money changes, player adds etc... I use the tool. I export the roster and upload it to my site. Then my Excel spreadsheet uses the data import function to link to that data on the Web, hence my spreadsheet updates from the web using a macro. I then have a sheet that is for game reports where I enter gate info, win/loss, cas's etc. That sheet is the ONLY place I ever input info, everything else is a macro. The macros update the league leaders, standings, etc.

Eventually I hope to be able to completely automate it by bringing in the pbemstat.log as well and pulling all the stats from that. I have a seperate spreadsheet that does this now...but need to work on tieing the two together.

The problem is that none of these are general enough to be used by anyone (except the stat one), they are tailored specifically to the REBBL, REBBL challenge league, and the skaven league. I am currently working on a 32 team version for the TRUBBL.

Indigo · Post by **Indigo** » Thu Feb 27, 2003 4:52 pm

bummer, spoke too soon - we are using the Ogre, Necromantic and Khemri teams but they aren't supported - are there any plans to release a modified version, or can I do it myself?

Tim · Post by **Tim** » Thu Feb 27, 2003 5:12 pm

Deal: you mail me the *most* official team lists of those, i'll pump up the database. I excluded the nonofficial teams because their roster is not finalized yet (and we do not use them).

Maybe i add star players as well on day.

Indigo · Post by **Indigo** » Thu Feb 27, 2003 5:38 pm

s'ok - since noone plays c. dwarf in our league I swapped them for the necro team

mate, this program is brill and saves me sooo much time!

ZanzerTem · Post by **ZanzerTem** » Thu Feb 27, 2003 6:34 pm

Its easy to add any unofficial teams. Once Tim said "variables" and pointed out that some of the columns are hidden, I pulled a "Doh!" Homer style.

You only really need *decent* knowledge of Excel, because the formulas are already written. If you know how to backtrack to find the root problem, you should have no problems.

This is a great tool btw

ZanzerTem · Post by **ZanzerTem** » Thu Feb 27, 2003 6:37 pm

You really should put a link to this in your posts as a signature! People will find it easier, and know you made it. I didn't realize it was yours until you posted it