|
| Site Partners: | SpotterGuides | Veloce Books |
| Related Sites: | Your Link Here |
|
|
|||||||||
|
||||||||||
|
|
|||||||||
|
||||||||||
|
|
24 Nov 2003, 06:45 (Ref:792656)
|
#1 | |
|
Racer
Join Date: Oct 2003
Posts: 330
 |
V8 Supercar 2003 Championship Points Calc
Einstein my butt. Basic maths maybe...
Here is a link to an Excel spreadsheet everyone can use to work out the various combinations of points scores to prophecise the 2003 V8 Supercar Champion from the 3 leading contenders, Ambrose, Murphy, Skaife. While the winner is likely to be from the first two, it's interesting to note what Skaife needs if both front-runners have bad days. Simply open the sheet in Excel, plug in the drivers positions for Race 1 and Race 2, and their round total, champ total and adjusted champ total will be shown. Valid values are 1-33, and DNF. Anything will make it barf. Put in position 34+ and expect negative scores, it's not something I bothered handling because if either driver finishes in that area in a race their championship is screwed anyway. Note that for each driver, any round score less than their current worst round yields them an adjusted champ total equal to their current unadjusted total. Have fun. Excel Points Calc PS. This assumes equal points for Race 1 and Race 2. In previous rounds, the length of a race has not affected the points split (ie, last round in NZ) so I'm assuming this is correct. |
|
|
|
|
24 Nov 2003, 06:55 (Ref:792658)
|
#2 | ||
|
Veteran
Join Date: Jul 2002
Posts: 1,994
|
Great Job and no wonder skaife is taking up his tittle hopes with Ambrose in 13th and Murf in 9th he's a shoe in.
|
||
|
|
__________________
Succes is a result of judgment,that is inturn a result of experience that has come from instances of bad judgment. "Montoya made some last minute changes to his suspension but it seemed to effect it's handling"-Classic
|
|
24 Nov 2003, 07:08 (Ref:792668)
|
#3 | |
|
Racer
Join Date: Oct 2003
Posts: 330
|
Oops, I meant, anything ELSE will make it barf, otherwise DNF and 1-33 is fine.
Last edited by Venom XR; 24 Nov 2003 at 07:10. |
|
|
|
|
|
25 Nov 2003, 03:41 (Ref:793523)
|
#4 | |
|
Racer
Join Date: Oct 2003
Posts: 330
|
Slightly updated. If anyone uses it, let me know.
|
|
|
|
|
|
25 Nov 2003, 06:41 (Ref:793588)
|
#5 | ||
|
Veteran
Join Date: Dec 2002
Posts: 594
|
Great Job Venom, how about a version using the adjusted points totals factored in?
|
||
|
|
__________________
Motorsport is dead...........
|
|
25 Nov 2003, 07:32 (Ref:793610)
|
#6 | |
|
Racer
Join Date: Oct 2003
Posts: 330
|
What do you mean? The adjusted points total is shown at the end based on the worst of 13 rounds. At the end of round 13, the adjusted total they have now is meaningless.
|
|
|
|
|
|
25 Nov 2003, 10:58 (Ref:793818)
|
#7 | ||
|
Veteran
Join Date: Dec 2002
Posts: 594
|
Ahh I see now, my screen isn't wide enough
|
||
|
|
__________________
Motorsport is dead...........
|
 |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| V8 Supercar Championship | nickyf1 | Virtual Racers | 110 | 14 Mar 2006 16:25 |
| V8 Supercar Championship Series Teams Championship | buza | Australasian Touring Cars. | 4 | 28 Apr 2005 21:06 |
| 2003 points system Vs 2002 points system | LucaBadoer | Formula One | 38 | 26 May 2003 11:17 |
| 2003 supercar champ | moffman | Australasian Touring Cars. | 42 | 12 Feb 2003 13:30 |
| 2003 V8 Supercar Championship | Amaroo Park | Australasian Touring Cars. | 23 | 20 Jan 2003 21:01 |
Linear Mode
