{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","FUTURITY","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":"FUTURITY","index":1,"n_rows":349,"n_cols":14,"rows_kept":349,"cut":false,"hidden":false,"merged":[]}
["NO.","NO","NAME","HORSE","Run 1","PL","Run 2","PL",0,"D1","D2","TOTAL","SHORT GO","FINAL"]
[" ",null,"FUTURITY (1)","OCTOBER, 2011",null,null,null,null,0,{"$f":"MIN(E79:G435)","v":0},{"$f":"+J2+I133","v":0}]
[3,40,"NANCY CSABAY","JESS LIKE FLYIN",17.646999999999998,null,17.963999999999999,null,0,{"$f":"IF(I55<K$5,I55,0)","v":0},{"$f":"IF(J3=0,IF(I55<L$5,I55,0),0)","v":0},{"$f":"SUM(E3+G3)","v":35.610999999999997},17.856000000000002,{"$f":"SUM(L3+M3)","v":53.466999999999999}]
[4,1,"*KIRSTY WHITE**","SMARTIE",17.866,null,17.922999999999998,null,0,0,{"$f":"IF(J4=0,IF(I4<L$5,I4,0),0)","v":0},{"$f":"SUM(E4+G4)","v":35.789000000000001},17.738,53.527000000000001]
[52,52,"KRYSTAL MOREN **","JC BONANZA TO A TEE",50,null,18.989000000000001,null,0,{"$f":"IF(I59<K$5,I59,0)","v":0},{"$f":"IF(J5=0,IF(I59<L$5,I59,0),0)","v":0},{"$f":"IF(I59>L$5,I59,0)","v":0},null,0]
[53,53,"*KAREEN WAREN","SHES REALLY KIDDIN",50,null,18.46,null,0,{"$f":"IF(I3<K$5,I3,0)","v":0},{"$f":"IF(J6=0,IF(I3<L$5,I3,0),0)","v":0},{"$f":"IF(I3>L$5,I3,0)","v":0},null,0]
[54,54,"TRACY GULICK**","BIG BAD BENNIE",19.759,null,50,null,0,{"$f":"IF(I4<K$5,I4,0)","v":0},{"$f":"IF(J7=0,IF(I4<L$5,I4,0),0)","v":0},{"$f":"IF(I4>L$5,I4,0)","v":0},null,0]
[55,55,"* LISA TRACH**","SARAH HAS CASH",50,null,18.097999999999999,null,0,{"$f":"IF(I60<K$5,I60,0)","v":0},{"$f":"IF(J8=0,IF(I60<L$5,I60,0),0)","v":0},{"$f":"IF(I60>L$5,I60,0)","v":0},null,0]
[56,56,"KRISTEN PFEFFERLE","PACKIN SOME FUEL",18.283999999999999,null,50,null,0,{"$f":"IF(I61<K$5,I61,0)","v":0},{"$f":"IF(J9=0,IF(I61<L$5,I61,0),0)","v":0},{"$f":"IF(I61>L$5,I61,0)","v":0},null,0]
[57,57,"JERRI LYNN CHEVALLIER**","PLATNIUM FRENCH FIRE",50,null,18.629000000000001,null,0,{"$f":"IF(I62<K$5,I62,0)","v":0},{"$f":"IF(J10=0,IF(I62<L$5,I62,0),0)","v":0},{"$f":"IF(I62>L$5,I62,0)","v":0},null,0]
[5,22,"JEANINE EDGE **","BULLYS RED TICKET",17.837,null,18.155000000000001,null,0,{"$f":"IF(I63<K$5,I63,0)","v":0},{"$f":"IF(J11=0,IF(I63<L$5,I63,0),0)","v":0},{"$f":"SUM(E11+G11)","v":35.992000000000004},17.893999999999998,53.886000000000003]
[7,18,"BAILEY WHYTE","REMINDMEATMIDNIGHT",18.047999999999998,null,18.103000000000002,null,0,{"$f":"IF(I64<K$5,I64,0)","v":0},{"$f":"IF(J12=0,IF(I64<L$5,I64,0),0)","v":0},36.150999999999996,17.753,53.903999999999996]
[6,2,"*KIM GERWATOSKI","SAILING ON A DREAM",18.056999999999999,null,17.992999999999999,null,0,{"$f":"IF(I65<K$5,I65,0)","v":0},{"$f":"IF(J13=0,IF(I65<L$5,I65,0),0)","v":0},36.049999999999997,17.97,54.019999999999996]
[8,27,"*WENDY YOUNG **","UNLEASHED TA FLY",18.135999999999999,null,18.065000000000001,null,0,{"$f":"IF(I66<K$5,I66,0)","v":0},{"$f":"IF(J14=0,IF(I66<L$5,I66,0),0)","v":0},36.201000000000001,17.881,54.082000000000001]
[10,24,"*VERONICA SWALES **","MONEYS FIRST KIT",18.542999999999999,null,17.8,null,0,{"$f":"IF(I67<K$5,I67,0)","v":0},{"$f":"IF(J15=0,IF(I67<L$5,I67,0),0)","v":0},36.343000000000004,17.800999999999998,54.144000000000005]
[2,26,"*RANDA NUGENT ","DR BRENDA",17.667000000000002,null,17.783999999999999,null,0,{"$f":"IF(I68<K$5,I68,0)","v":0},{"$f":"IF(J16=0,IF(I68<L$5,I68,0),0)","v":0},35.451000000000001,19.140999999999998,54.591999999999999]
[11,5,"RAYLEE EDWARDS","LITTLE SIS SUE",18.132999999999999,null,18.253,null,0,{"$f":"IF(I69<K$5,I69,0)","v":0},{"$f":"IF(J17=0,IF(I69<L$5,I69,0),0)","v":0},36.385999999999996,18.52,54.905999999999992]
[1,28,"KATIE GARTHWAITE","FIESTA ROYALE",17.574999999999999,null,17.667000000000002,null,0,{"$f":"IF(I70<K$5,I70,0)","v":0},{"$f":"IF(J18=0,IF(I70<L$5,I70,0),0)","v":0},35.242000000000004,50,85.242000000000004]
[9,50,"*WENDY PLAYFAIR","JB EYE",17.902999999999999,null,18.361999999999998,null,0,{"$f":"IF(I71<K$5,I71,0)","v":0},{"$f":"IF(J19=0,IF(I71<L$5,I71,0),0)","v":0},36.265000000000001,50,86.265000000000001]
[12,13,"*BERTINA OLAFSON **","ALIVE N SMASHING",18.399000000000001,null,18.053999999999998,null,0,{"$f":"IF(I72<K$5,I72,0)","v":0},{"$f":"IF(J20=0,IF(I72<L$5,I72,0),0)","v":0},36.453000000000003,50,86.453000000000003]
[13,37,"JANET PATRIQUIN","EYE ON HORTONS",18.213999999999999,null,18.323,null,0,{"$f":"IF(I75<K$5,I75,0)","v":0},{"$f":"IF(J21=0,IF(I75<L$5,I75,0),0)","v":0},{"$f":"SUM(E21+G21)","v":36.536999999999999},null,{"$f":"SUM(L21+M21)","v":36.536999999999999}]
[14,9,"*RANDA NUGENT","HOWES MAKIN A MILE",18.344999999999999,null,18.300999999999998,null,0,0,0,36.646000000000001,null,36.646000000000001]
[15,42,"*COULTER GOULD **","SQUIRRLEY",18.428000000000001,null,18.238,null,0,0,0,36.665999999999997,null,36.665999999999997]
[16,33,"CARMAN POZZOBON **","TIME TO BE TIPSY",18.210999999999999,null,18.475999999999999,null,0,0,0,36.686999999999998,null,36.686999999999998]
[17,10,"*DAWN GERTNER **","MS JETA PERKS",18.402000000000001,null,18.344999999999999,null,0,0,0,36.747,null,36.747]
[18,12,"BRANDY MCPHJEE ","SMART LITTLE SOMBERO",18.477,null,18.391999999999999,null,0,0,0,36.869,null,36.869]
[19,8,"DEANNA BUSCHERT","SR ONE FAST LADY",18.475000000000001,null,18.437999999999999,null,0,0,0,36.912999999999997,null,36.912999999999997]
[20,19,"RAYLEE EDWARDS","DEECATHLETE",18.399999999999999,null,18.523,null,0,0,0,36.923000000000002,null,36.923000000000002]
[21,39,"COLIN BALAN **","FLETCH N CARRY",18.792000000000002,null,18.331,null,0,0,0,37.123000000000005,null,37.123000000000005]
[22,46,"*RENE LECLERCQ **","THISCHICKSONAROLL",18.512,null,18.710999999999999,null,0,0,0,37.222999999999999,null,37.222999999999999]
[23,16,"SCOTT MESTON","SILK N TALENT",18.510999999999999,null,18.754999999999999,null,0,0,0,37.265999999999998,null,37.265999999999998]
[24,4,"*LUCY DEE ROY **","SR DISE A HORTON",18.949000000000002,null,18.632000000000001,null,0,0,0,37.581000000000003,null,37.581000000000003]
[25,34,"LORI RANKIN **","TRI STREAKINFORCASH",18.858000000000001,null,18.792000000000002,null,0,0,0,37.650000000000006,null,37.650000000000006]
[26,30,"RENEE RAE WILLIS","FISHIN IN THE DARK",18.373000000000001,null,19.309999999999999,null,0,0,0,37.683,null,37.683]
[27,51,"*COBY AUCLAIR","PUT THE GAS DOWN",19.013999999999999,null,19.033000000000001,null,0,0,0,38.046999999999997,null,38.046999999999997]
[28,29,"PATTY MOHNS **","TONI",18.795999999999999,null,19.263999999999999,null,0,0,0,38.06,null,38.06]
[29,21,"VERONICA DIBB **","GET CHARGIN PLAYBOY",19.024999999999999,null,19.341999999999999,null,0,0,0,38.366999999999997,null,38.366999999999997]
[30,6,"SHARYL MALIN","COSTS ALOTTA CASH",18.966000000000001,null,19.863,null,0,0,0,38.829000000000001,null,38.829000000000001]
[31,38,"*BERTINA OLAFSON **","SR CUTE BOOTPRINTS",19.338999999999999,null,20.323,null,0,0,0,39.661999999999999,null,39.661999999999999]
[32,11,"*SIERRA STONEY **","MR TROUBLES PLAIN",22.63,null,18.661999999999999,null,0,0,0,41.292000000000002,null,41.292000000000002]
[33,48,"LYNETTE BRODOWAY","BB PURE REED",50,null,17.584,null,0,0,0,67.584000000000003,null,67.584000000000003]
[34,17,"*JALAINE ANDERSON","KIDUAL OTE",50,null,17.887,null,0,0,0,67.887,null,67.887]
[35,35,"*SANDY STEWART **","KRK STRAW",17.904,null,50,null,0,0,0,67.903999999999996,null,67.903999999999996]
[36,43,"ELAINE BLACK","POSSIBLE ROCKSTAR",17.942,null,50,null,0,0,0,67.942000000000007,null,67.942000000000007]
[37,31,"ANGELA MASTAD","DAZZLES TIME",50,null,18.222999999999999,null,0,0,0,68.222999999999999,null,68.222999999999999]
[38,45,"RAYLEE EDWARDS","DEFINE FLAIR",18.324999999999999,null,50,null,0,0,0,68.325000000000003,null,68.325000000000003]
[39,3,"*RUSTY RAE QUAM","TINYS MIRACLE",50,null,18.488,null,0,0,0,68.488,null,68.488]
[40,7,"*JACQUELINE HOOVER","RARE SPLASHER",18.501999999999999,null,50,null,0,0,0,68.501999999999995,null,68.501999999999995]
[41,41,"*RUSTY RAE QUAM **","KN FABULOUS IN VEGAS",50,null,18.527000000000001,null,0,0,0,68.527000000000001,null,68.527000000000001]
[42,23,"*MERRY ANN STONEY **","ELANS FEIST",18.626999999999999,null,50,null,0,0,0,68.626999999999995,null,68.626999999999995]
[43,14,"*STACEY HANNAH **","WOODLANDSCLASSYCHIC",50,null,18.63,null,0,0,0,68.63,null,68.63]
[44,47,"*CHAD MULDOOM **","MOONS PRECIOUS FAME",50,null,18.690000000000001,null,0,0,0,68.69,null,68.69]
[45,25,"LINDSEY GARTNER","A COWGIRLS TOUCH",18.946999999999999,null,50,null,0,0,0,68.947000000000003,null,68.947000000000003]
[46,49,"JOANNA JAMES **","DUDES LAST ZANTASTIC",19.222000000000001,null,50,null,0,0,0,69.222000000000008,null,69.222000000000008]
[47,15,"*VICKI MADSON **","LIL BAG O STARS",50,null,19.882000000000001,null,0,0,0,69.882000000000005,null,69.882000000000005]
[48,20,"*DEE BUTTERFIELD **","THERMO DAWN",20.091000000000001,null,50,null,0,0,0,70.091000000000008,null,70.091000000000008]
[49,32,"SHANNON NELSON","TP CHARMED LEAGUE",50,null,22.509,null,0,0,0,72.509,null,72.509]
[50,36,"CRANNA ROBERTS **","BULLYS RED DOMINO",50,null,50,null,0,0,0,100,null,100]
[51,44,"*RANDA NUGENT**","DASHULATER",50,null,50,null,0,0,0,100,null,100]
[52,58,null,null,null,null,null,null,0,{"$f":"IF(I116<K$5,I116,0)","v":0},{"$f":"IF(J60=0,IF(I116<L$5,I116,0),0)","v":0},{"$f":"IF(I116>L$5,I116,0)","v":0},null,{"$f":"SUM(L60+M60)","v":0}]
[53,59,null,null,null,null,null,null,0,0,0,0,null,{"$f":"N67","v":0}]
[54,60,null,null,null,null,null,null,0,0,0,0]
[55,61,null,null,null,null,null,null,0,0,0,0]
[56,62,null,null,null,null,null,null,0,0,0,0]
[57,63,null,null,null,null,null,null,0,0,0,0]
[58,64,null,null,null,null,null,null,0,0,0,0]
[59,65,null,null,null,null,null,null,0,0,0,0]
[60,66,null,null,null,null,null,null,0,0,0,0]
[61,67,null,null,null,null,null,null,0,0,0,0]
[62,68,null,null,null,null,null,null,0,0,0,0]
[63,69,null,null,null,null,null,null,0,0,0,0]
[64,70,null,null,null,null,null,null,0,0,0,0]
[65,71,null,null,null,null,null,null,0,0,0,0]
[66,72,null,null,null,null,null,null,0,0,0,0]
[67,73,null,null,null,null,null,null,0,0,0,0]
[68,74,null,null,null,null,null,null,0,0,0,0]
[69,75,null,null,null,null,null,null,0,0,0,0]
[70,76,null,null,null,null,null,null,0,0,0,0]
[71,77,null,null,null,null,null,null,0,0,0,0]
[72,78,null,null,null,null,null,null,0,0,0,0]
[73,79,null,null,null,null,null,null,0,0,0,0]
[74,80,null,null,null,null,null,null,0,0,0,0]
[75,81,null,null,null,null,null,null,0,0,0,0]
[76,82,null,null,null,null,null,null,0,0,0,0]
[77,83,null,null,null,null,null,null,0,0,0,0]
[78,84,null,null,null,null,null,null,0,0,0,0]
[79,85,null,null,null,null,null,null,0,0,0,0]
[80,86,null,null,null,null,null,null,0,0,0,0]
[81,87,null,null,null,null,null,null,0,0,0,0]
[82,88,null,null,null,null,null,null,0,0,0,0]
[83,89,null,null,null,null,null,null,0,0,0,0]
[84,90,null,null,null,null,null,null,0,0,0,0]
[85,91,null,null,null,null,null,null,0,0,0,0]
[86,92,null,null,null,null,null,null,0,0,0,0]
[87,93,null,null,null,null,null,null,0,0,0,0]
[88,94,null,null,null,null,null,null,0,0,0,0]
[89,95,null,null,null,null,null,null,0,0,0,0]
[90,96,null,null,null,null,null,null,0,0,0,0]
[null,97,null,null,null,null,null,null,0,0,0,0]
[null,98,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,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}]