|
|
Post by pezzarinho17 on May 10, 2016 10:19:21 GMT -5
Hello all fellow team managers!
As we are preparing to head into Season 2 of GRL, things are going to become a lot more intense with multiple cars, drivers, series and disciplines available. A lot of managers (myself included) have been keeping a track of all their teams progress via the team profile page they set up at the beginning, and whilst this doesn't replace the need to keep your page up to date for the admins, I have come up with something to help keep a closer track of your progresses.
I have attached a copy of the spreadsheet which you are all free to use, and it may just make this seem a little less daunting in the future! Originally I was going to leave it blank, but the spreadsheet is actually filled in currently with my own teams information so that you can see how each sheet was intended to be used. There is no security on it so you are also free to change anything on there you don't like, it is your assistant!
I don't see why there would be any problems, however at the time of posting this, Ricardo Lionheart has yet to give the form a once over to check everything is acceptable. Therefore there may be changes ahead. I also intend to put some notes on each sheet to highlight how certain columns are worked out etc.
I hope this is as useful to others as it has already been for me!
GRL Team Managers Template.xlsx (52.33 KB) |
|
maikoheart
•
WRA Administration
Posts: 643
Likes: 514
Gender: Female
|
Post by maikoheart on May 10, 2016 10:36:22 GMT -5
Great stuff! Will totallly utlize this come season 2. There's a lot to keep track of and sometimes the team profile isn't really to my liking when lining out results and data.
|
|
Formidable
•
WRA Administration
Posts: 618
Likes: 570
Gender: Male
|
Post by Formidable on May 10, 2016 11:45:16 GMT -5
Hello all fellow team managers!
As we are preparing to head into Season 2 of GRL, things are going to become a lot more intense with multiple cars, drivers, series and disciplines available. A lot of managers (myself included) have been keeping a track of all their teams progress via the team profile page they set up at the beginning, and whilst this doesn't replace the need to keep your page up to date for the admins, I have come up with something to help keep a closer track of your progresses.
I have attached a copy of the spreadsheet which you are all free to use, and it may just make this seem a little less daunting in the future! Originally I was going to leave it blank, but the spreadsheet is actually filled in currently with my own teams information so that you can see how each sheet was intended to be used. There is no security on it so you are also free to change anything on there you don't like, it is your assistant!
I don't see why there would be any problems, however at the time of posting this, Ricardo Lionheart has yet to give the form a once over to check everything is acceptable. Therefore there may be changes ahead. I also intend to put some notes on each sheet to highlight how certain columns are worked out etc.
I hope this is as useful to others as it has already been for me! This'll be quite handy! Thank you for making this! |
|
|
|
Post by pezzarinho17 on May 10, 2016 16:47:40 GMT -5
Glad it will help out! My own version has a duplicate finance sheet where I can post future buys and likely incomes, again all about planning ahead and making sure I sign the right drivers for the right cars. Can just do that direct on finance section without saving as an alternative!
|
|
aarror
•
Member
Posts: 292
Likes: 364
Gender: Male
|
Post by aarror on May 10, 2016 20:56:18 GMT -5
Thank you, this is awesome! Will make it so much easier to keep track of things once we start moving into multiple categories.
|
|
|
|
Post by B.K.Glover on May 10, 2016 21:05:37 GMT -5
Excel's a wonderful tool, isn't it. Looks good.
|
|
|
|
Post by RnTheAndrian on May 10, 2016 21:32:54 GMT -5
Nice one! Thank you very much!
|
|
|
|
Post by pezzarinho17 on May 20, 2016 7:28:57 GMT -5
I have updated the Spreadsheet today, a couple of tweaks here and there. The biggest update is the driver stats page, where you can now put in your drivers 4 attribute scores, and the spreadsheet will automatically calculate their overall experience level and from that then also show how much their hiring cost will be. For those who have already made their own team spreadsheets, the easiest thing to do will be to copy the formula into your own sheets rather than starting everything else again!
|
|
