Auto Racing Score Sheets

[theKarlOS]

I am the timing and scoring offical for a racetrack and want to
automatically calculate points for each event. Most of the work is
done, but I am having difficulty mapping individual heat race points to
the appropriate section of the score sheet.

I use named ranges and cell names that correspond.

Here is an example:

B Heat Results B Heat Points A Heat Results A Heat Points
28 8 23 10
44 7 15 9
13 6 65 8
71 5 9 7
47 4 33 6

Range Names: BHeatResults, BHeatPoints, etc...
Cell Names: BHeat1, BHeat2, (these are for finishing position) BHeatP1,
BHeatP2, (these are for points) etc...

My "Totals" score sheet is based on the finishing order of the night's
main event and is set up like this:

Car Number Time In Heat Points Main Points TOTAL
33 50
9 48
65 46
15 44
23 42
47 40
71 38
13 36
44 34
28 32

I've got the running totals for the night and season working fine. How
do I "map" the heat points dynamically to this matrix based on
finishing order?

Any help is greatly appreciated.

theKarlOS

 

[Don Guillett]

Having been an SCCA Formula Ford road race driver many years ago, I will try
to help if you send me a workbook with what you have done and a complete
detailed explanation of what you want.

Is this for some kind of round e round racing?

 

[theKarlOS]

Don,

Thanks for the assist. Yeah, this is for short track racing, multipl
classes, some transponder results, some manual results. The goal is t
transcribe all results (manual or electronic) to the correspondin
score sheet for the class to automatically calculate points for th
night's event. These results will then be transferred to a curren
totals/standings sheet for print and the web.

The sheet I've attached is extremely preliminary, but should give you
good idea of what we are trying to accomplish. Just started the proces
last week, so these sheets are incomplete as we were using them as
test.

Thanx again,

Karl
Montana Raceway Park
Kalispell, Montan

+-------------------------------------------------------------------
|Filename: 7-22-06.zip
|Download: http://www.excelforum.com/attachment.php?postid=5128
+-------------------------------------------------------------------

 

[Don Guillett]

I don't get the php files. If desired, send direct to my email address.
Invalid Attachment specified. If you followed a valid link, please notify
the administrator

 

[Biff]

Don,

To download attached files from Excelforum you have to download while on the
site.

If you click the "View this thread" link you'll be taken to the site and
then you can download the file.

Biff

 

[RagDyeR]

A lot of folks know about that Biff, and some (most) refuse to go that
course!
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

Don,

To download attached files from Excelforum you have to download while on the
site.

If you click the "View this thread" link you'll be taken to the site and
then you can download the file.

Biff

 

[Don Guillett]

Biff, Thanks for the info. I have often wondered how to do this.