Topic: 2022 Lemons Results File
Hello Lemoners!
Like I did in 2021, I compiled the results of the 2022 Lemons races into one Excel file to pick apart and feed my analytical soul.
See the two links if you’re a data-nerd like me or might be interested in seeing how things turned out. The “HC” file is hard-coded so y’all can mess with the file without constantly breaking formulas and pivot tables. The other file includes everything if you are interested in seeing the formulas I used for determining the winners of each class and whatnot. Both files are read-only but you should be able to download them if you want to.
Disclosure that the files are only as good as the input data. I tried to correct misspellings and use common terms (“Chevrolet” versus “Chevy”) but I’m sure I missed a thing or ten (darn you “Camero” owners). This is all in fun anyway so take from it what you will.
Some highlights/insights from 2022:
-1,095,511 competition miles were driven (see the “Distance” sheet)
-#17 was the most popular car number, coincidentally it was used 17 times (for reasons unknown #181 was used 13 times) (see the “Team Numbers” sheet)
-The overall composition of the classes was roughly even: A class-31%, B class-39%, C class-25%, with 3% signing up, paying, but not starting (see the “Race Composition” sheet)
-The widest disparity between the winners of A class and C class was at Autobahn with the C class winner completing 80% of the A class winner’s laps (see the “Race Class Laps” sheet)
-The team fielding the most entrants was “Braking Bad Racing” (20) followed by “ONSET/Tetanus Racing” (15) (see the “Teams” sheet)
-BMW was the manufacturer with the most cars (283) and laps-driven (73,168). Also of note: Mazda and Ford also fielded a ton of cars and laps. Mazda had 228 cars with 55,507 laps and Ford had 257 cars and 55,441 laps (see the “Manufacturer Details” and “Manufacturer by Class” sheets)
-The manufactures with the most class trophies: A class-BMW (8 or 38%), B class-Toyota (3 or 14%), C class-Ford (5 or 24%) (see the “Manufacturer %” sheet)
-The most run model of car (I added up the differently-named as I could figure them) was the Mazda Miata (151) followed by the BMW E36 (100), Ford Mustang (91), BMW E30 (72), and Honda Civic (66) (see the “Model by Class” sheet)
-To see how the various models are represented overall versus several categories (Win %, Class wins, Top 10, by thirds) check out the “Model %” sheet
There are several other sheets to check out too.
Have fun!
Hard Coded - https://1drv.ms/x/s!AsQEf_u4ajkkhEij5ir … p?e=Ktc9XR [1drv.ms]
Full File - https://1drv.ms/x/s!AsQEf_u4ajkkhEZMqTYgfpqdGPGN [1drv.ms]