I GOT THE PAYOUTS, BUT I NEED AN ACTUAL SPREADSHEET TO FIGURE FROM...
I PRAY YOU CAN HELP...THIS ALL NEED TO BE AUTOMATED AS THE TIMES CHANGE EACH TIME.
1 - TIME - COL G
2 - RESULTS - COL H (SB 1D 2D 3D 4D 5D - DEPENDS ON WHERE THE TIME FALLS
3 - PLACING - COL I (1ST-5TH PER "D")
OPEN FINALS-ADEL, IA
DRAW FIRST NAME LAST NAME DISTRICT NBHA # HORSE TIME RESULTS POINTS PAYOUT
1.000 1D 1st 1D 1.000 1.499
1.300 1D 2nd 2D 1.500 1.999
1.500 1D 2nd 3D 2.000 2.499
1.800 2D 2nd 4D 2.500 2.999
2.000 2D 3rd 5D 3.000 8.000
THANKS FOR ANY HELP!