On the other board you all frequent, a gentleman had posted Word documents of race sheets.

I thought about doing them in Excel so the host has minimal work to do if they don't have a fully automated setup (ie. Trakmate).

I've attached a very rough spreadsheet that I'd like feedback on, even if to say I am wasting my time or it's been done already.

I'm trying to have a main sheet with driver info entered, then use the appropriate tab that corresponds to number of racers.

With more work, it should only need the number of laps to be entered and then will keep a running total, and leaderboard. Final laps input will set the standings for that race. I can even add columns for time, average lap, median, races run, etc. Anything Excel can calc, I can add to it.

Also, add drop down menus for race type and other info wanted.

Thoughts?

(use the 6 racer tab as I entered in 6 people already. input lap numbers to see it flow thru).

I have a different program than most run, we don't rotate lanes. Instead we time qualify, then randomly draw lanes for three sets of heats. Points are awarded in those heats and then those cars are arranged by points. As you progress through the mains the car with fast time in that main gets lane choice, second fastest, etc. One car transfers to the next main by winning. We've had cars come from as far back as the H main to win the show.
I have written my own EXCEL sheet for this program that sorts cars two ways; by heat points and by time. Pretty much by the time the heats are done the mains are set...automatically. This after 22 years of manually running this program.