Talk Fantasy Football

Hi there, I've been told that all the elven teams and the dwarf team (but not the chaos dwarves) recieve a free team re-roll when creating the team? is this true? I can vaguely remember something along these lines from the 3rd edition release of the game (perhaps it was in deathzone?) but I can find no mention of it in the LRB.

The reason I ask is that I am creating a teamsheet in excel for our local league and I need to know if I need the code to automatically give these teams the free re-roll when you create the team.

No they dont get a free reroll anymore.

It was a speciel rule at some time. I think it was from a Citadell journall.

Poul

ah well, I'd written the code already

anyone want the teamsheet? I will upload it when I'm done (I think its better than the one on the GW site...)

It was a rule introduced in the BB magazine 1.
But it is not used anymore.


Asmodan

Starfish, have you also checked out the teamsheet from http://www.arosbb.dk/default.asp?p=dl ?
tell me what you think of it...

yeah, thats pretty much what I was aiming for, my hat off to you sir! not familiar with some of the fields in it (are they specific things for your league? I'm talking about L2 and M2, I think I can guess that V2 is jsut for show)

and if it produced a clone roster on another sheet that was a 'B&W printer friendly' version (i.e. no shading, just to save ink) that'd be perfect. I'd merged more cells myself and I don't like the way you type in 10 and the 000 gp are in the next cell along.

I was still working on the automatic player entry, but I see you've locked the spreadsheet (and not used the same password as me )

Thanks for the reply

I probably should have written some sort of manual on how to use it. All the blue and "blue-ish" areas are for manual fill-in, the rest will done automatically.
In the column called"M" you can write an M for miss next match. In the column called "N" you enter the number of nigglings for the player.
And yes, "kills" are just for show, to keep track of how many of the cas that were kills.

The small "ma", "av" and so on, you can enter "1" or "-1" when a player decreases or increses that particular stat.

About the tresury's "000 gp" being in the next cell, you are right, but I coulndt think of a better way, since you (as the think is coded to it) only have to write the thousands of you treasury in the cell before that. but then again, if one knows that only the blu(ish) cell are for editing, then perhaps it's ok.

As for the print-shading-thing, I was hoping that your printer could be setup to ignore background-shadings?

Thanks again for the comments, I will keep them in mind

ok, I get the M and N fields now

for the cells that use 'gp' as a currency I right click the cell then go to 'format cells', choose the number tab and change the type to a custom type like this: #,##0 \gp

now if you type in '50000' it will display as: '50,000 gp'

hope this helps.