fauniera said:
Thanks for all the work, Armchair. Have to say, though, that the sheets are a bit too complicated for me. Is the first place i've got
here a good thing or a bad thing?
Is there an easy way to find out how many "earnings" (points scored) i have?
That first place is essentially because your riders have earned very few CQ points this season. Your much lower ranking in the table I initially published is because most of your riders have done relatively few races (only one has more than 8 racedays under his belt, 9 of them have not turned a pedal in anger yet as far as my sources showed.)
The scores for each rider in the spreadsheet reflect whatever you put in column B.
If in B2 you enter =C2, and copy that to the bottom of column B, then row 235 will give the total of the initial score of your riders. (This is your potential highest score at the beginning of the year if all your men rode 20+ days each and still failed to garner a single point between them)
If in B2 you enter =D2, and copy that to the bottom of column B, then row 235 will give the total of the current(ish) CQ score of your riders. (You want this to be low)
If in B2 you enter =E2, and copy that to the bottom of column B, then row 235 will give the total of the difference between the price of your riders and their scores. You want this to be high, but if the only reason it is high is because they haven't raced much, your team will still not benefit from it)
If in B2 you enter =F2, and copy that to the bottom of column B, then row 235 will give the total of the days raced by your riders. (This will be almost entirely meaningless, and besides, once a rider has 20 or more in this column, I won't bother updating it, as it is irrelevant whether it is 21 or 91)
If in B2 you enter =G2, and copy that to the bottom of column B, then row 235 will give the total of the effective game score of your riders. This is the ranking I will be publishing each month.
If in B2 you enter your bank account details, please PM me a copy.
Its very early in the season to say how any team is doing. To take a popular pick as an example, Alois Kankovsky had 426 points by the end of last year, and right now he has 0. You might think that makes him a great pick, but last year he had no points until May, and only 33 before mid-September, so any current rankings should be taken with a large grain of salt.