CRP Excel Team Sheet

General Discussion, Not necessarily related to Bloodbowl
Post Reply
User avatar
Virral
2011 Legend
2011 Legend
Posts: 12996
Joined: Wed Aug 15, 2007 7:08 pm
BB League: ACTBBL
Favourite Race: Necromantic
Location: Canberra

CRP Excel Team Sheet

Post by Virral »

I've been meaning to do this for a while now, but finally got around to updating the LRB5 Excel Teamsheet to CRP. I can't take credit for the creation of this teamsheet in any way shape or form, I just tweaked the stats so it's correct for CRP.

I've done my best to make all the necessary changes to prices, added the new stars and the three extra teams. I think they're all correct, and I've done some testing, but I can't guarantee it's perfect. So if you spot a mistake, post here and I'll fix it ASAP and upload a new version.

Personally I use these spreadsheets all the time for planning and printing tournament rosters, so hopefully others will also find it helpful. There is a read me file included for information on how it works, but it's all pretty straight forward. The only thing I think that won't be immediately obvious is that you need to put a * next to a doubles skill, so it adds the extra 10k in value.
Nothing to see here!

User avatar
Greyhound
2011 Legend
2011 Legend
Posts: 5126
Joined: Thu Mar 11, 2010 8:37 pm
BB League: MBBL
Favourite Race: Lizardmen
Location: Melbourne

CRP Excel Team Sheet

Post by Greyhound »

I really need to grow up, I smiled when I saw the Ass Coaches...
Hexoatl Missionaries
Image
Scrub since 2011

someone2040
Chaos Warrior
Chaos Warrior
Posts: 518
Joined: Thu May 08, 2008 6:11 pm
BB League: CCKUP
Favourite Race: Lizardmen
Location: South Australia

CRP Excel Team Sheet

Post by someone2040 »

Just wondering, but is there any reason you made this when there's already a LRB 6 / CRP version of ArosBB sheet? Or just didn't realise there was one already out there?

Link
--Someone2040--
CCKUP S2(3rd-Lizards), S3(1st-Khemri), S4(3rd-ProElf), S5(1st-Chaos Dwarf), S6(3rd-Lizards), S7(4th-Humans)
Shrike 2008(Last-Orcs), 2009(2nd-Khemri), 2010(6th-Lizards), 2011(8th-Chaos Dwarf), 2012(9th-Humans)
Current team : Hartmann's Heroes

User avatar
Virral
2011 Legend
2011 Legend
Posts: 12996
Joined: Wed Aug 15, 2007 7:08 pm
BB League: ACTBBL
Favourite Race: Necromantic
Location: Canberra

CRP Excel Team Sheet

Post by Virral »

I had no idea it was out there *shrug*
Nothing to see here!

someone2040
Chaos Warrior
Chaos Warrior
Posts: 518
Joined: Thu May 08, 2008 6:11 pm
BB League: CCKUP
Favourite Race: Lizardmen
Location: South Australia

CRP Excel Team Sheet

Post by someone2040 »

Fair enough.
--Someone2040--
CCKUP S2(3rd-Lizards), S3(1st-Khemri), S4(3rd-ProElf), S5(1st-Chaos Dwarf), S6(3rd-Lizards), S7(4th-Humans)
Shrike 2008(Last-Orcs), 2009(2nd-Khemri), 2010(6th-Lizards), 2011(8th-Chaos Dwarf), 2012(9th-Humans)
Current team : Hartmann's Heroes

User avatar
Virral
2011 Legend
2011 Legend
Posts: 12996
Joined: Wed Aug 15, 2007 7:08 pm
BB League: ACTBBL
Favourite Race: Necromantic
Location: Canberra

CRP Excel Team Sheet

Post by Virral »

Eh I think I like "my" one better to be honest, not a fan of the way you add upgrades to a player. There is such a thing as too much automation, I'm happier just typing them in since it gives you a bit more control.

Plus I notice he's now put password protection on it, which is a bit of a shame since it means people can't use it to set up their own personal version. I know some people who format them so they can be printed out in team colours etc, but to do that you need to be able to unprotect it.
Nothing to see here!

User avatar
frogbear
2011 Legend
2011 Legend
Posts: 1771
Joined: Thu Nov 08, 2007 2:52 am
Favourite Race: Norse
Location: SE Suburbs Victoria

Re: CRP Excel Team Sheet

Post by frogbear »

Virral wrote:Plus I notice he's now put password protection on it, which is a bit of a shame since it means people can't use it to set up their own personal version. I know some people who format them so they can be printed out in team colours etc, but to do that you need to be able to unprotect it.
I believe I can get it unlocked if people really want that....
www.bloodbowl.net.au

Cancon 2008 - 18th Place
Cancon 2009 - 9th Place
Conquest 2009 - 10th Place
Ausbowl Star Player 2010

User avatar
murishido
2011 Legend
2011 Legend
Posts: 351
Joined: Tue Jun 01, 2010 5:53 pm
BB League: SLOBB
Favourite Race: Slaan
Location: Newtown

Re: CRP Excel Team Sheet

Post by murishido »

You could also just cut and paste into another sheet with the colours and formating of your preference.

Carbrawn
2011 Legend
2011 Legend
Posts: 317
Joined: Wed Sep 12, 2007 3:01 am
BB League: ACTBBL
Favourite Race: Chaos
Location: Canberra
Contact:

Re: CRP Excel Team Sheet

Post by Carbrawn »

I've kept our league one current in two versions, this one is for tournaments with the inducements summarised
http://southernvalley.bloodbowlleague.c ... roster.xls. The password is blank to let people do their own colour schemes, its just there to stop the formulas being deleted accidently.

User avatar
redcard
2011 Legend
2011 Legend
Posts: 3665
Joined: Sat Mar 22, 2008 10:04 pm
BB League: SLOBB
Location: lane cove

Re: CRP Excel Team Sheet

Post by redcard »

Ok a bit of thread necromancy

Has anyone updated their spreadsheets for the new rules yet ?

Carbrawn
2011 Legend
2011 Legend
Posts: 317
Joined: Wed Sep 12, 2007 3:01 am
BB League: ACTBBL
Favourite Race: Chaos
Location: Canberra
Contact:

Re: CRP Excel Team Sheet

Post by Carbrawn »

Not yet, I don't have a copy of the updated rules but as soon as I do I'll be on it.

Post Reply