{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","DERBY","Payout"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[null,"Here's some quick instructions for the ss. You need to know a bit about Excel to run it. "]
[1,"First thing to do is keep a initial version of the spreadsheets with no entries so a clean copy. Do a 'File>Save as' and give the file another name like your jackpot's date and district. "]
[2,"The Payout tab is to help calculate the number of placings and the amount for each placing.  Just enter the # of entries for Open or Youth and the amount of the entry fee that is going into the payout. "]
[3,"In the Open tab, I have entered a random number formula in the No. column. Once all your entries are typed in then use the 'Data>sort' to sort based on the No. column. Make sure you cursor is in the cell A3 before you select Data>Sort and that once it is selected, all your entry info is selected for the sort. Don't miss a column or it will be a mess. That will give you a true random sort for the running order. Then you can replace those numbers in the No. column with 1,2,3, etc. "]
[4,"Enter the division time split based on size of pattern in the first row in the cell above the 'Time'. The ss will use these to calcualte the Division splits. "]
[5," Enter the times on the Run 1 and Run 2. If  a barrel is knocked or there is a no time, enter 'NT' in the Run 1 or Run 2. The spreadsheet will move the fastest time to the Time column. "]
[6,"As the times get entered, the fastest time will be moved to the cell in the first row above the D1 column and the D2 and D3 splits will be calculated based on the fastest time. "]
[7,"Can use the sort, same was as in #3 except on the Time column for the sort to get the placings. You will have to manually enter the placings and payout. Didn't get that far with this ss. "]

{"sheet":"DERBY","index":1,"n_rows":349,"n_cols":14,"rows_kept":349,"cut":false,"hidden":false,"merged":[]}
[" ",null,"DERBY","2011-10-11",null,null,null,null,0.7,{"$f":"MIN(E3:G359)","v":17.088000000000001},{"$f":"+J1+I1","v":17.788}]
["NO.","NO","NAME","HORSE","Run 1","PL","Run 2","PL","Time","D1","D2","TOTAL","SHORT GO","FINAL"]
[2,28,"*LACI SUITOR","SWIFT MACHINE",17.555,null,17.597000000000001,null,{"$f":"MIN(E3:G3)","v":17.555},{"$f":"IF(I3<K$1,I3,0)","v":17.555},{"$f":"IF(J3=0,IF(I3<L$1,I3,0),0)","v":0},{"$f":"SUM(E3+G3)","v":35.152000000000001},17.471,{"$f":"SUM(L3+M3)","v":52.623000000000005}]
[4,13,"*LYNETTE BRODOWAY","SR ROOT SIXTY SIX",17.698,null,17.649999999999999,null,{"$f":"MIN(E4:G4)","v":17.649999999999999},{"$f":"IF(I4<K$1,I4,0)","v":17.649999999999999},{"$f":"IF(J4=0,IF(I4<L$1,I4,0),0)","v":0},{"$f":"SUM(E4+G4)","v":35.347999999999999},17.353999999999999,{"$f":"SUM(L4+M4)","v":52.701999999999998}]
[5,24,"*SONDA MARKS","DELTAS FIRST CANDLE",17.863,null,17.513999999999999,null,{"$f":"MIN(E5:G5)","v":17.513999999999999},{"$f":"IF(I5<K$1,I5,0)","v":17.513999999999999},{"$f":"IF(J5=0,IF(I5<L$1,I5,0),0)","v":0},{"$f":"SUM(E5+G5)","v":35.376999999999995},17.395,{"$f":"SUM(L5+M5)","v":52.771999999999991}]
[3,58,"*BRAIDY HOWES","HOWES ON HER LINCOLN",17.547999999999998,null,17.673999999999999,null,{"$f":"MIN(E6:G6)","v":17.547999999999998},{"$f":"IF(I6<K$1,I6,0)","v":17.547999999999998},{"$f":"IF(J6=0,IF(I6<L$1,I6,0),0)","v":0},{"$f":"SUM(E6+G6)","v":35.221999999999994},17.616,{"$f":"SUM(L6+M6)","v":52.837999999999994}]
[6,55,"NANCY CSABAY","KATIES GOTA FAST ONE",17.760999999999999,null,17.666,null,{"$f":"MIN(E7:G7)","v":17.666},{"$f":"IF(I7<K$1,I7,0)","v":17.666},{"$f":"IF(J7=0,IF(I7<L$1,I7,0),0)","v":0},{"$f":"SUM(E7+G7)","v":35.427},17.617000000000001,{"$f":"SUM(L7+M7)","v":53.043999999999997}]
[9,6,"*LACEY STANTON","LOTSA COCKTAILS",17.687000000000001,null,17.975999999999999,null,{"$f":"MIN(E8:G8)","v":17.687000000000001},{"$f":"IF(I8<K$1,I8,0)","v":17.687000000000001},{"$f":"IF(J8=0,IF(I8<L$1,I8,0),0)","v":0},{"$f":"SUM(E8+G8)","v":35.662999999999997},17.398,{"$f":"SUM(L8+M8)","v":53.060999999999993}]
[7,56,"*KERI BABCOOK **","WINNING APROACH",17.469000000000001,null,18.030999999999999,null,{"$f":"MIN(E9:G9)","v":17.469000000000001},{"$f":"IF(I9<K$1,I9,0)","v":17.469000000000001},{"$f":"IF(J9=0,IF(I9<L$1,I9,0),0)","v":0},{"$f":"SUM(E9+G9)","v":35.5},17.704000000000001,{"$f":"SUM(L9+M9)","v":53.204000000000001}]
[10,18,"MAXINE MCKENNA","FEATURED JESS",17.975999999999999,null,17.811,null,{"$f":"MIN(E10:G10)","v":17.811},{"$f":"IF(I10<K$1,I10,0)","v":0},{"$f":"IF(J10=0,IF(I10<L$1,I10,0),0)","v":0},{"$f":"SUM(E10+G10)","v":35.786999999999999},17.443999999999999,{"$f":"SUM(L10+M10)","v":53.230999999999995}]
[1,3,"*BRAIDY HOWES","ROYALLY WICKED",17.571000000000002,null,17.088000000000001,null,{"$f":"MIN(E11:G11)","v":17.088000000000001},{"$f":"IF(I11<K$1,I11,0)","v":17.088000000000001},{"$f":"IF(J11=0,IF(I11<L$1,I11,0),0)","v":0},{"$f":"SUM(E11+G11)","v":34.659000000000006},50,{"$f":"SUM(L11+M11)","v":84.659000000000006}]
[8,35,"*KAYE STOESSER","HERBIE TWO",17.975000000000001,null,17.574000000000002,null,{"$f":"MIN(E12:G12)","v":17.574000000000002},{"$f":"IF(I12<K$1,I12,0)","v":17.574000000000002},{"$f":"IF(J12=0,IF(I12<L$1,I12,0),0)","v":0},{"$f":"SUM(E12+G12)","v":35.549000000000007},50,{"$f":"SUM(L12+M12)","v":85.549000000000007}]
[11,14,"*RYLEE MCKENNZIE**","MILLIOMAIRE PARADISE",17.997,null,17.902000000000001,null,{"$f":"MIN(E13:G13)","v":17.902000000000001},{"$f":"IF(I13<K$1,I13,0)","v":0},{"$f":"IF(J13=0,IF(I13<L$1,I13,0),0)","v":0},{"$f":"SUM(E13+G13)","v":35.899000000000001},50,{"$f":"SUM(L13+M13)","v":85.899000000000001}]
[12,26,"*KERRY MAYNES","BUGS EASY JUDGE",17.934000000000001,null,18.001999999999999,null,{"$f":"MIN(E14:G14)","v":17.934000000000001},{"$f":"IF(I14<K$1,I14,0)","v":0},{"$f":"IF(J14=0,IF(I14<L$1,I14,0),0)","v":0},{"$f":"SUM(E14+G14)","v":35.936},50,{"$f":"SUM(L14+M14)","v":85.936000000000007}]
[13,57,"*CASEY SIMPSON","PISTOLS LIL ROJA",18.045000000000002,null,17.942,null,{"$f":"MIN(E15:G15)","v":17.942},{"$f":"IF(I15<K$1,I15,0)","v":0},{"$f":"IF(J15=0,IF(I15<L$1,I15,0),0)","v":0},{"$f":"SUM(E15+G15)","v":35.987000000000002},null,{"$f":"SUM(L15+M15)","v":35.987000000000002}]
[14,30,"*BUFFY MORTON","BLUE EM OVER",18.015000000000001,null,17.998999999999999,null,17.998999999999999,0,0,36.013999999999996,null,36.013999999999996]
[15,33,"*BRAIDY HOWES","HOWES ALODED SHOTGUN",18.448,null,17.657,null,17.657,17.657,0,36.105000000000004,null,36.105000000000004]
[16,64,"*TRACY BECKMAN**","GRAB ME A CORONA",18.411000000000001,null,17.704000000000001,null,17.704000000000001,17.704000000000001,0,36.115000000000002,null,36.115000000000002]
[17,1,"TERRY WOODWARD**","SAQ COW BOY PINE",18.123000000000001,null,18.077999999999999,null,18.077999999999999,0,0,36.201000000000001,null,36.201000000000001]
[18,23,"TRACI MACDONALD **","COPY N PARADISE",18.265999999999998,null,17.969000000000001,null,17.969000000000001,0,0,36.234999999999999,null,36.234999999999999]
[19,61,"*KAREEN WARREN","THIS BULLY IS BACK",18.213000000000001,null,18.032,null,18.032,0,0,36.245000000000005,null,36.245000000000005]
[20,9,"*SHAYNA DODDS","MR BLEW BOON",18.369,null,17.928999999999998,null,17.928999999999998,0,0,36.298000000000002,null,36.298000000000002]
[21,62,"VAL NELSON**","WRANGLERS SLIDER",18.388999999999999,null,17.91,null,17.91,0,0,36.298999999999999,null,36.298999999999999]
[22,42,"*BUFFY MORTON","WHIZ N LEO",18.276,null,18.091000000000001,null,18.091000000000001,0,0,36.367000000000004,null,36.367000000000004]
[23,20,"CINDY BROCK**","TWO EYED SPOOK",18.036000000000001,null,18.381,null,18.036000000000001,0,0,36.417000000000002,null,36.417000000000002]
[24,36,"RAYLEE EDWARDS","EASY BUY SUE",17.885999999999999,null,18.707000000000001,null,17.885999999999999,0,0,36.593000000000004,null,36.593000000000004]
[25,31,"NANCY CSABAY","TWOTICKETSTOPARADISE",18.283999999999999,null,18.350000000000001,null,18.283999999999999,0,0,36.634,null,36.634]
[26,37,"*KARLA WALTZE **","STELLAR FEATURE",17.922000000000001,null,18.786999999999999,null,17.922000000000001,0,0,36.709000000000003,null,36.709000000000003]
[27,45,"*WANDA DENHAM **","STEELDUST TWISTER",18.439,null,18.274999999999999,null,18.274999999999999,0,0,36.713999999999999,null,36.713999999999999]
[28,21,"*SIMMONE FOWLER **","AVID RUBY ",18.408999999999999,null,18.329000000000001,null,18.329000000000001,0,0,36.738,null,36.738]
[29,51,"*SANDRA MAFFENBEIER **","TAKE TIME TO PLAY",18.202000000000002,null,18.690000000000001,null,18.202000000000002,0,0,36.892000000000003,null,36.892000000000003]
[30,60,"KIM BOYD **","JUST A SPECIAL CHICK",18.556000000000001,null,18.469000000000001,null,18.469000000000001,0,0,37.025000000000006,null,37.025000000000006]
[31,5,"*KAYLEA ARGENT **","VL DELIRIOUSLY DIALIN",18.521000000000001,null,18.558,null,18.521000000000001,0,0,37.079000000000001,null,37.079000000000001]
[32,47,"*FRAN JOHNSON **","PASSEM BUGS",18.46,null,18.632999999999999,null,18.46,0,0,37.093000000000004,null,37.093000000000004]
[33,7,"*NINA SMITH **","CLOUD GREY",18.416,null,18.806999999999999,null,{"$f":"MIN(E35:G35)","v":18.416},{"$f":"IF(I35<K$1,I35,0)","v":0},{"$f":"IF(J35=0,IF(I35<L$1,I35,0),0)","v":0},37.222999999999999,null,{"$f":"SUM(L35+M35)","v":37.222999999999999}]
[34,25,"*PAM VEER **","CLYMONA JD DANDY",18.614999999999998,null,18.641999999999999,null,18.614999999999998,0,0,37.256999999999998,null,37.256999999999998]
[35,32,"COLIN BALAN **","BLUE AHEAD OF THEM",18.922000000000001,null,18.355,null,18.355,0,0,37.277000000000001,null,37.277000000000001]
[36,54,"RAYLEE EDWARDS","GENERALY STREAKIN",19.018999999999998,null,18.273,null,18.273,0,0,37.292000000000002,null,37.292000000000002]
[37,16,"*LAUREEN RUSSELL**","IMA VEGAS SPECIAL",18.276,null,19.170999999999999,null,18.276,0,0,37.447000000000003,null,37.447000000000003]
[38,12,"MONICA KIPPERS **","SMOKIN LUCKY FIVE",18.931999999999999,null,19.010000000000002,null,18.931999999999999,0,0,37.942,null,37.942]
[39,11,"ROBIN HNUSHKA","AVIDS RAPID BUG",19.099,null,19.033000000000001,null,19.033000000000001,0,0,38.132000000000005,null,38.132000000000005]
[40,4,"JORDIE LIKE","DIAMOND CLASS ACT",19.018999999999998,null,19.190000000000001,null,19.018999999999998,0,0,38.209000000000003,null,38.209000000000003]
[41,41,"JACQUELINE STOJAN","TWO BITZ FRITZ",18.402999999999999,null,20.218,null,18.402999999999999,0,0,38.620999999999995,null,38.620999999999995]
[42,17,"*RANDA NUGENT **","WATCH KATIE RUNAWAY",22.007000000000001,null,18.5,null,18.5,0,0,40.507000000000005,null,40.507000000000005]
[43,38,"SHARYL MALIN","LEOS PASS EM CASH",25.77,null,21.375,null,21.375,0,0,47.144999999999996,null,47.144999999999996]
[44,52,"*KIM EATON","JUST  LITTLE MOON",50,null,50,null,50,0,0,{"$f":"IF(I46>L$1,I46,0)","v":50},null,50]
[45,50,"*RUSTY RAE QUAM","ROSA CALIENTE",50,null,17.579000000000001,null,17.579000000000001,17.579000000000001,0,{"$f":"SUM(E47+G47)","v":67.579000000000008},null,67.579000000000008]
[46,2,"*TARA MULDOON **","REVED AND RAPID",50,null,17.667999999999999,null,17.667999999999999,17.667999999999999,0,67.668000000000006,null,67.668000000000006]
[47,43,"*JACQUELINE HOOVER","SUNNY SAPPHIRE",50,null,17.731000000000002,null,17.731000000000002,17.731000000000002,0,67.730999999999995,null,67.730999999999995]
[48,44,"*LUCY DEE ROY","FAMOUS PICTURE",50,null,17.805,null,17.805,0,0,67.805000000000007,null,67.805000000000007]
[49,40,"NIKI MAKOFKA","FIRST START UNLEASHED",17.920999999999999,null,50,null,17.920999999999999,0,0,67.920999999999992,null,67.920999999999992]
[50,59,"*LANA BOHNET **","TOP POSSIBILITY",18.010000000000002,null,50,null,18.010000000000002,0,0,68.010000000000005,null,68.010000000000005]
[51,48,"KRYSTAL MOREN","PISTOLS CASH EFFORT",50,null,18.113,null,18.113,0,0,68.113,null,68.113]
[52,15,"JODI POBUDA","KN IMA BIG BEAR",18.164000000000001,null,50,null,18.164000000000001,0,0,68.164000000000001,null,68.164000000000001]
[53,49,"MAXINE MCKENNA","FELON",18.204999999999998,null,50,null,18.204999999999998,0,0,68.204999999999998,null,68.204999999999998]
[54,53,"*JACQUELINE STOJAN**","DASHING PANTHER",18.231000000000002,null,50,null,18.231000000000002,0,0,68.230999999999995,null,68.230999999999995]
[55,19,"*GINA SHANTZ","FAMOUS SAVANAH",50,null,18.375,null,18.375,0,0,68.375,null,68.375]
[56,63,"*ASHLEY ROY**","A RARE KEPT PROMISE",18.777000000000001,null,50,null,18.777000000000001,0,0,68.777000000000001,null,68.777000000000001]
[57,8,"*TAYLOR GARDNER","EQUINE EXCELLENCE",19.015000000000001,null,50,null,19.015000000000001,0,0,69.015000000000001,null,69.015000000000001]
[58,39,"*MELISSA BERTHIAUME","IN THE NIC OF TIME",50,null,19.414999999999999,null,19.414999999999999,0,0,69.414999999999992,null,69.414999999999992]
[59,27,"*DONNA BEIERBACH","KATIES MINE",50,null,23.885000000000002,null,23.885000000000002,0,0,73.885000000000005,null,73.885000000000005]
[60,10,"*DELANE PECK **","JUST HIGHONDIAMONS",50,null,50,null,50,0,0,100,null,100]
[61,22,"*BOBBIE ROBINSON **","DOCS SKIPPEN SAILS",50,null,50,null,50,0,0,100,null,100]
[62,29,"ABBIE GATTEY","CAUGHT ME A LENA",50,null,50,null,50,0,0,100,null,100]
[63,34,"KRISTY GILCHRIST","MONEYS SUPERMAN",50,null,50,null,50,0,0,100,null,100]
[64,46,"*RENIE SCHNTZLER **","RC PACKIN GOLD",50,null,50,null,50,0,0,100,null,100]
[65,65,null,null,null,null,null,null,{"$f":"MIN(E67:G67)","v":0},{"$f":"IF(I67<K$1,I67,0)","v":0},{"$f":"IF(J67=0,IF(I67<L$1,I67,0),0)","v":0},{"$f":"IF(I67>L$1,I67,0)","v":0}]
[66,66,null,null,null,null,null,null,0,0,0,0]
[67,67,null,null,null,null,null,null,0,0,0,0]
[68,68,null,null,null,null,null,null,0,0,0,0]
[69,69,null,null,null,null,null,null,0,0,0,0]
[70,70,null,null,null,null,null,null,0,0,0,0]
[71,71,null,null,null,null,null,null,0,0,0,0]
[72,72,null,null,null,null,null,null,0,0,0,0]
[73,73,null,null,null,null,null,null,0,0,0,0]
[74,74,null,null,null,null,null,null,0,0,0,0]
[75,75,null,null,null,null,null,null,0,0,0,0]
[76,76,null,null,null,null,null,null,0,0,0,0]
[77,77,null,null,null,null,null,null,0,0,0,0]
[78,78,null,null,null,null,null,null,0,0,0,0]
[79,79,null,null,null,null,null,null,0,0,0,0]
[80,80,null,null,null,null,null,null,0,0,0,0]
[81,81,null,null,null,null,null,null,0,0,0,0]
[82,82,null,null,null,null,null,null,0,0,0,0]
[83,83,null,null,null,null,null,null,0,0,0,0]
[84,84,null,null,null,null,null,null,0,0,0,0]
[85,85,null,null,null,null,null,null,0,0,0,0]
[86,86,null,null,null,null,null,null,0,0,0,0]
[87,87,null,null,null,null,null,null,0,0,0,0]
[88,88,null,null,null,null,null,null,0,0,0,0]
[89,89,null,null,null,null,null,null,0,0,0,0]
[90,90,null,null,null,null,null,null,0,0,0,0]
[91,91,null,null,null,null,null,null,0,0,0,0]
[92,92,null,null,null,null,null,null,0,0,0,0]
[93,93,null,null,null,null,null,null,0,0,0,0]
[94,94,null,null,null,null,null,null,0,0,0,0]
[95,95,null,null,null,null,null,null,0,0,0,0]
[96,96,null,null,null,null,null,null,0,0,0,0]
[null,97,null,null,null,null,null,null,0,{"$f":"IF(I99<K$1,I99,0)","v":0},{"$f":"IF(J99=0,IF(I99<L$1,I99,0),0)","v":0},0]
[null,98,null,null,null,null,null,null,0,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[254]
[255]
[256]
[257]
[258]
[259]
[260]
[261]
[262]
[263]
[264]
[265]
[266]
[267]
[268]
[269]
[270]
[271]
[272]
[273]
[274]
[275]
[276]
[277]
[278]
[279]
[280]
[281]
[282]
[283]
[284]
[285]
[286]
[287]
[288]
[289]
[290]
[291]
[292]
[293]
[294]
[295]
[296]
[297]
[298]
[299]

{"sheet":"Payout","index":2,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Open","Youth"]
["# of entries",51,25]
["EF to Jackpot",null,null,"*enter the amount of the EF that is going into the payout per entry. "]
["Total",{"$f":"+B3*B4","v":0},{"$f":"+C3*C4","v":0}]
["Added $",0,0,"*add in any added money"]
["Total Purse",{"$f":"+B6+B5","v":0},{"$f":"+C6+C5","v":0}]
[]
["Placing Per Div",null,null,"*caculates the # of placings and amount based on ABRA rule book"]
["first",{"$f":"IF(B7>1999.99,(B7*0.23)/3,IF(B3<10,B7/3,IF(B3<21,(B7*0.6)/3,IF(B3<31,(B7*0.45)/3,IF(B3<41,(B7*0.4)/3,IF(B3<51,(B7*0.34)/3,(B7*0.29)/3))))))","v":0},{"$f":"IF(C7>1999.99,(C7*0.23)/3,IF(C3<10,C7/3,IF(C3<21,(C7*0.6)/3,IF(C3<31,(C7*0.45)/3,IF(C3<41,(C7*0.4)/3,IF(C3<51,(C7*0.34)/3,(C7*0.29)/3))))))","v":0}]
["second ",{"$f":"IF(B7>1999.99,(B7*0.2)/3,IF(B3<10,0,IF(B3<21,(B7*0.4)/3,IF(B3<31,(B7*0.35)/3,IF(B3<41,(B7*0.3)/3,IF(B3<51,(B7*0.26)/3,(B7*0.24)/3))))))","v":0},{"$f":"IF(C7>1999.99,(C7*0.2)/3,IF(C3<10,0,IF(C3<21,(C7*0.4)/3,IF(C3<31,(C7*0.35)/3,IF(C3<41,(C7*0.3)/3,IF(C3<51,(C7*0.26)/3,(C7*0.24)/3))))))","v":0}]
["third",{"$f":"IF(B7>1999.99,(B7*0.17)/3,IF(B3<21,0,IF(B3<31,(B7*0.2)/3,IF(B3<41,(B7*0.2)/3,IF(B3<51,(B7*0.18)/3,(B7*0.19)/3)))))","v":0},{"$f":"IF(C7>1999.99,(C7*0.17)/3,IF(C3<21,0,IF(C3<31,(C7*0.2)/3,IF(C3<41,(C7*0.2)/3,IF(C3<51,(C7*0.18)/3,(C7*0.19)/3)))))","v":0}]
["fourth",{"$f":"IF(B7>1999.99,(B7*0.14)/3,IF(B3<31,0,IF(B3<41,(B7*0.1)/3,IF(B3<51,(B7*0.14)/3,(B7*0.14)/3))))","v":0},{"$f":"IF(C7>1999.99,(C7*0.14)/3,IF(C3<31,0,IF(C3<41,(C7*0.1)/3,IF(C3<51,(C7*0.14)/3,(C7*0.14)/3))))","v":0}]
["fifth",{"$f":"IF(B7>1999.99,(B7*0.11)/3,IF(B3<41,0,IF(B3<51,(B7*0.08)/3,(B7*0.09)/3)))","v":0},{"$f":"IF(C7>1999.99,(C7*0.11)/3,IF(C3<41,0,IF(C3<51,(C7*0.08)/3,(C7*0.09)/3)))","v":0}]
["sixth",{"$f":"IF(B7>1999.99,(B7*0.08)/3,IF(B3<51,0,(B7*0.05)/3))","v":0},{"$f":"IF(C7>1999.99,(C7*0.08)/3,IF(C3<51,0,(C7*0.05)/3))","v":0}]
["seventh ",{"$f":"IF( B7>1999.99,(B7*0.05)/3,0)","v":0},{"$f":"IF( C7>1999.99,(C7*0.05)/3,0)","v":0}]
["eighth",{"$f":"IF( B7>1999.99,(B7*0.02)/3,0)","v":0},{"$f":"IF( C7>1999.99,(C7*0.02)/3,0)","v":0}]
[]
["Total per Div",{"$f":"SUM(B10:B17)","v":0},{"$f":"SUM(C10:C15)","v":0}]
["Total Purse",{"$f":"+B19*3","v":0},{"$f":"+C19*3","v":0}]