{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","PEEWEE","Payout","Sheet1"],"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":"PEEWEE","index":1,"n_rows":94,"n_cols":14,"rows_kept":94,"cut":false,"hidden":false,"merged":[]}
[null,null,"2012-10-07","PEEWEE",null,null,1,{"$f":"MIN(E3:F353)","v":23.417000000000002},{"$f":"+H1+G1","v":24.417000000000002},{"$f":"+I1+G1","v":25.417000000000002}]
["NO.","NO","NAME","HORSE","Run 1","Run 2","Time","D1","D2","D3","D1","D2","D3","Payout"]
[1,1,"TRACE LIZOTKE","DAISY BOY",48.445," ",{"$f":"MIN(E3:F3)","v":48.445},{"$f":"IF(G3<I$1,G3,0)","v":0},{"$f":"IF(H3=0,IF(G3<J$1,G3,0),0)","v":0},{"$f":"IF(G3>J$1,G3,0)","v":48.445}]
[2,2,"ALLEY BUECKERT","ROCKER",64.498000000000005,null,{"$f":"MIN(E4:F4)","v":64.498000000000005},{"$f":"IF(G4<I$1,G4,0)","v":0},{"$f":"IF(H4=0,IF(G4<J$1,G4,0),0)","v":0},{"$f":"IF(G4>J$1,G4,0)","v":64.498000000000005}]
[3,3,"KATE CSABAY","SU ENTRY",31.672000000000001,null,31.672000000000001,0,0,31.672000000000001]
[4,4,"JAXXY PEPPER","PENNY",58.664000000000001,null,58.664000000000001,0,0,58.664000000000001]
[5,5,"HANNA LEITCH","SMOKEN SANTANA",40.984999999999999,null,40.984999999999999,0,0,40.984999999999999]
[6,6,"LAURA WILSON","BRACE",26.503,null,26.503,0,0,26.503]
[7,7,"MONTANA FOGLE","JERRY",24.9,null,24.9,0,24.9,0]
[8,8,"KELLY CHOLACH","SHEBA",24.285,null,24.285,24.285,0,0]
[9,9,"KYAN HARDING","WYLIE",23.417000000000002,null,23.417000000000002,23.417000000000002,0,0]
[10,10,"LEVI MCPHEE","SLY SUNDAY",47.579000000000001,null,47.579000000000001,0,0,47.579000000000001]
[11,11,"DENVER LEITCH","STAR",38.539000000000001,null,38.539000000000001,0,0,38.539000000000001]
[12,12,"ZOE BUECKERT","ROCKER",47.1,null,47.1,0,0,47.1]
[13,13,"KATE BEIERBACK","SILVER THE WONDER HORSE",59.689,null,59.689,0,0,59.689]
[14,14,"ELLY GROVER","ROCKY",50,null,50,0,0,50]
[15,15,null,null,null,null,0,0,0,0]
[16,16,null,null,null,null,0,0,0,0]
[17,17,null,null,null,null,0,0,0,0]
[18,18,null,null,null,null,0,0,0,0]
[19,19,null,null,null,null,0,0,0,0]
[20,20,null,null,null,null,0,0,0,0]
[21,21,null,null,null,null,0,0,0,0]
[22,22,null,null,null,null,0,0,0,0]
[23,23,null,null,null,null,0,0,0,0]
[24,24,null,null,null,null,0,0,0,0]
[25,25,null,null,null,null,0,0,0,0]
[26,26,null,null,null,null,0,0,0,0]
[27,27,null,null,null,null,0,0,0,0]
[28,28,null,null,null,null,0,0,0,0]
[29,29,null,null,null,null,0,0,0,0]
[30,30,null,null,null,null,0,0,0,0]
[31,31,null,null,null,null,0,0,0,0]
[32,32,null,null,null,null,0,0,0,0]
[33,33,null,null,null,null,0,0,0,0]
[34,34,null,null,null,null,0,0,0,0]
[35,35,null,null,null,null,0,0,0,0]
[36,36,null,null,null,null,0,0,0,0]
[37,37,null,null,null,null,0,0,0,0]
[38,38,null,null,null,null,0,0,0,0]
[39,39,null,null,null,null,0,0,0,0]
[40,40,null,null,null,null,0,0,0,0]
[41,41,null,null,null,null,0,0,0,0]
[42,42,null,null,null,null,0,0,0,0]
[43,43,null,null,null,null,0,0,0,0]
[44,44,null,null,null,null,0,0,0,0]
[45,45,null,null,null,null,0,0,0,0]
[46,46,null,null,null,null,0,0,0,0]
[47,47,null,null,null,null,0,0,0,0]
[48,48,null,null,null,null,0,0,0,0]
[49,49,null,null,null,null,0,0,0,0]
[50,50,null,null,null,null,0,0,0,0]
[51,51,null,null,null,null,0,0,0,0]
[52,52,null,null,null,null,0,0,0,0]
[53,53,null,null,null,null,0,0,0,0]
[54,54,null,null,null,null,0,0,0,0]
[55,55,null,null,null,null,0,0,0,0]
[56,56,null,null,null,null,0,0,0,0]
[57,57,null,null,null,null,0,0,0,0]
[58,58,null,null,null,null,0,0,0,0]
[59,59,null,null,null,null,{"$f":"MIN(E61:F61)","v":0},{"$f":"IF(G61<I$1,G61,0)","v":0},{"$f":"IF(H61=0,IF(G61<J$1,G61,0),0)","v":0},{"$f":"IF(G61>J$1,G61,0)","v":0}]
[60,60,null,null,null,null,0,0,0,0]
[61,61,null,null,null,null,0,0,0,0]
[62,62,null,null,null,null,0,0,0,0]
[63,63,null,null,null,null,0,0,0,0]
[64,64,null,null,null,null,0,0,0,0]
[65,65,null,null,null,null,0,0,0,0]
[66,66,null,null,null,null,0,0,0,0]
[67,67,null,null,null,null,0,0,0,0]
[68,68,null,null,null,null,0,0,0,0]
[69,69,null,null,null,null,0,0,0,0]
[70,70,null,null,null,null,0,0,0,0]
[71,71,null,null,null,null,0,0,0,0]
[72,72,null,null,null,null,0,0,0,0]
[73,73,null,null,null,null,0,0,0,0]
[74,74,null,null,null,null,0,0,0,0]
[75,75,null,null,null,null,0,0,0,0]
[76,76,null,null,null,null,0,0,0,0]
[77,77,null,null,null,null,0,0,0,0]
[78,78,null,null,null,null,0,0,0,0]
[79,79,null,null,null,null,0,0,0,0]
[80,80,null,null,null,null,0,0,0,0]
[81,81,null,null,null,null,0,0,0,0]
[82,82,null,null,null,null,0,0,0,0]
[83,83,null,null,null,null,0,0,0,0]
[84,84,null,null,null,null,0,0,0,0]
[85,85,null,null,null,null,0,0,0,0]
[86,86,null,null,null,null,0,0,0,0]
[87,87,null,null,null,null,0,0,0,0]
[88,88,null,null,null,null,0,0,0,0]
[89,89,null,null,null,null,0,0,0,0]
[90,90,null,null,null,null,0,0,0,0]
[91,91,null,null,null,null,{"$f":"MIN(E93:F93)","v":0},{"$f":"IF(G93<I$1,G93,0)","v":0},{"$f":"IF(H93=0,IF(G93<J$1,G93,0),0)","v":0},0]
[92,92,null,null,null,null,{"$f":"MIN(E94:F94)","v":0},{"$f":"IF(G94<I$1,G94,0)","v":0},{"$f":"IF(H94=0,IF(G94<J$1,G94,0),0)","v":0},0]

{"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}]

{"sheet":"Sheet1","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}