Wednesday, 8 May 2013

Scores - New Format

The old points model was a bee-atch to update....took me forever.
So I have flipped things around for v2 and am using my trusty pivot table skills to make life easier..!!

So....new look, new format, some new data, but.....still the same old fools biking!!

Same Old Chart...but 'automated' ..!!! (Did I mention that I love Excel)
So....in 1, 2,3 we have Labrico, Missile, Husky.....




Single Ride Report...(also Automated)
Example: Les Plans du Saleve
Shows the attendance bonus as new news!! (Every 5 = 1 additional, Every 10 = 2 Additional)





The 'Totals' Table (Automated!!!)



The History of Points Per Ride (Not Automated.........Joke)!!

2 comments:

  1. Well done again Mr Ref ! THANKS.

    ReplyDelete
  2. Excellent, I have never been that high in the ranking! Well done ref!

    ReplyDelete