{"text_format":"2","workbook":"xlsx","n_sheets":10,"sheets":["Sheet1","Sheet2","Sheet3","Sheet4","Sheet5","Sheet6","Sheet7","Sheet8","Sheet9","Sheet10"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"comments":10,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Sheet1","index":0,"n_rows":59,"n_cols":58,"rows_kept":59,"cut":false,"hidden":false,"merged":[[4,19,4,37],[4,38,4,40],[2,1,2,3],[1,1,1,3],[3,1,3,3]]}
[null,"HELP"]
[null,"FORM Analysis v2.0"]
[null,"02-11-2012",{"$nulls":16},">",{"$nulls":19},"<"]
[null,"Moonee Valley",{"$nulls":43},"FORM"]
[null,"Result",{"$f":"\"F \"&COUNT(AM7:AM30)","v":"F 7"},"Race 1",{"$nulls":15},"Calculations -- hidden for cosmetic reasons",{"$nulls":18},{"$f":"B4&\" \"&D5","v":"Moonee Valley Race 1"},{"$nulls":5},"v","delete if scratched"]
[null,"3.5.6","TAB","Form",15,14,13,12,11,10,9,8,7,6,5,4,3,2,1,"Finish Pos","Points","score",{"$f":"E6","v":15},{"$f":"F6","v":14},13,12,11,10,9,8,7,6,{"$f":"O6","v":5},{"$f":"P6","v":4},{"$f":"Q6","v":3},{"$f":"R6","v":2},{"$f":"S6","v":1},"Top 4","Analysis","BM Price","Rank",null,null,">","No","Last 10","Horse","Trainer","Jockey","Wt","Bar",{"$nulls":5},"API","PP"]
[null,null,1,{"$f":"IF(AT7=\"\",\"\",AT7)","v":"2x"},{"$f":"IF(OR(E$6=\"\",$D7=\"\"),\"\",IF(LEN($D7)>=E$6,IF(LEFT(RIGHT($D7,E$6),1)=\"x\",\"\",IF(LEFT(RIGHT($D7,E$6),1)=\"0\",10,1*LEFT(RIGHT($D7,E$6),1))),\"\"))","v":""},"","","","","","","","","","","","",2,"",1,8,{"$f":"IF(D7=\"\",\"\",VLOOKUP(IF(E7=\"\",11,E7),T$7:U$17,2)+VLOOKUP(IF(F7=\"\",11,F7),T$7:U$17,2)+VLOOKUP(IF(G7=\"\",11,G7),T$7:U$17,2)+VLOOKUP(IF(H7=\"\",11,H7),T$7:U$17,2)+VLOOKUP(IF(I7=\"\",11,I7),T$7:U$17,2)+VLOOKUP(IF(J7=\"\",11,J7),T$7:U$17,2)+VLOOKUP(IF(K7=\"\",11,K7),T$7:U$17,2)+VLOOKUP(IF(L7=\"\",11,L7),T$7:U$17,2)+VLOOKUP(IF(M7=\"\",11,M7),T$7:U$17,2)+VLOOKUP(IF(N7=\"\",11,N7),T$7:U$17,2)+VLOOKUP(IF(O7=\"\",11,O7),T$7:U$17,2)+VLOOKUP(IF(P7=\"\",11,P7),T$7:U$17,2)+VLOOKUP(IF(Q7=\"\",11,Q7),T$7:U$17,2)+VLOOKUP(IF(R7=\"\",11,R7),T$7:U$17,2)+VLOOKUP(IF(S7=\"\",11,S7),T$7:U$17,2))","v":5},{"$f":"IF(E7=\"\",\"\",$U$32/W$6/E7)","v":""},"","","","","","","","","","","","",3.75,"",{"$f":"IF(AO7>4,\"\",1/(AL$32/VLOOKUP(AO7,T$7:U$11,2)))","v":0.14285714285714285},{"$f":"IF(V7=\"\",\"\",SUM(W7:AK7)+V7)","v":8.75},{"$f":"IF(AL7<>\"\",ROUND(1/AL7,1),IF(AL34=\"\",\"\",ROUND(AL34,1)))","v":7},{"$f":"IF(AM7=\"\",\"\",RANK(AM7,AM$7:AM$30))","v":3},null,null,1,1,"2x","Extra","Peter Snowden","G Boss ",58,3,{"$nulls":5},7,3.8]
[null,null,2,{"$f":"IF(AT8=\"\",\"\",AT8)","v":""},"","","","","","","","","","","","","","","",2,5,{"$f":"IF(D8=\"\",\"\",VLOOKUP(IF(E8=\"\",24,E8),T$7:U$17,2)+VLOOKUP(IF(F8=\"\",24,F8),T$7:U$17,2)+VLOOKUP(IF(G8=\"\",24,G8),T$7:U$17,2)+VLOOKUP(IF(H8=\"\",24,H8),T$7:U$17,2)+VLOOKUP(IF(I8=\"\",24,I8),T$7:U$17,2)+VLOOKUP(IF(J8=\"\",24,J8),T$7:U$17,2)+VLOOKUP(IF(K8=\"\",24,K8),T$7:U$17,2)+VLOOKUP(IF(L8=\"\",24,L8),T$7:U$17,2)+VLOOKUP(IF(M8=\"\",24,M8),T$7:U$17,2)+VLOOKUP(IF(N8=\"\",24,N8),T$7:U$17,2)+VLOOKUP(IF(O8=\"\",24,O8),T$7:U$17,2)+VLOOKUP(IF(P8=\"\",24,P8),T$7:U$17,2)+VLOOKUP(IF(Q8=\"\",24,Q8),T$7:U$17,2)+VLOOKUP(IF(R8=\"\",24,R8),T$7:U$17,2)+VLOOKUP(IF(S8=\"\",24,S8),T$7:U$17,2))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AO8>4,\"\",1/(AL$32/VLOOKUP(AO8,T$7:U$11,2)))","v":""},{"$f":"IF(V8=\"\",\"\",SUM(W8:AK8)+V8)","v":""},{"$f":"IF(AL8<>\"\",ROUND(1/AL8,1),IF(AL35=\"\",\"\",ROUND(AL35,1)))","v":""},{"$f":"IF(AM8=\"\",\"\",RANK(AM8,AM$7:AM$30))","v":""},null,null,2,2,null,"Flirt With Me","D Brideoake & D Feek","S W Arnold ",58,7,{"$nulls":5},0,6.5]
[null,9.9,3,"539x","","","","","","","","","","","",5,3,9,"",3,3,4.2,"","","","","","","","","","","",0.75,1.6666666666666667,0.83333333333333337,"",9.5238095238095233E-2,7.4500000000000011,{"$f":"IF(AL9<>\"\",ROUND(1/AL9,1),IF(AL36=\"\",\"\",ROUND(AL36,1)))","v":10.5},4,null,null,3,3,"539x","General Groove","L J Corstens","C Newitt ",58,5,{"$nulls":5},3.5,6.5]
[null,null,4,4,"","","","","","","","","","","","","","",4,4,2,2,"","","","","","","","","","","","","","",3.75,"",5.75,{"$f":"IF(AL10<>\"\",ROUND(1/AL10,1),IF(AL37=\"\",\"\",ROUND(AL37,1)))","v":23.8},7,null,null,4,4,4,"I'm Corleone","G Eurell","J Bowman ",58,9,{"$nulls":5},0.6,8.5]
[null,null,5,875,"","","","","","","","","","","","",8,7,5,5,1,1.8,"","","","","","","","","","","","",0.625,1.0714285714285714,3,"",6.496428571428571,{"$f":"IF(AL11<>\"\",ROUND(1/AL11,1),IF(AL38=\"\",\"\",ROUND(AL38,1)))","v":21.1},6,null,null,5,5,875,"Inkjet Sprinter","S A Dwyer","Nicholas Hall ",58,10,{"$nulls":5},0.3,26]
[null,null,6,2,"","","","","","","","","","","","","","",2,6,0.8,5,"","","","","","","","","","","","","","",7.5,0.23809523809523808,12.5,{"$f":"IF(AL12<>\"\",ROUND(1/AL12,1),IF(AL39=\"\",\"\",ROUND(AL39,1)))","v":4.2},2,null,null,6,6,2,"Jeepers Creepers","R E Laing","Ms S Wynne ",58,2,{"$nulls":5},3,16]
[null,null,7,"3x7","","","","","","","","","","","","",3,"",7,7,0.5,3.5,"","","","","","","","","","","","",1.6666666666666667,"",2.1428571428571428,"",7.3095238095238093,{"$f":"IF(AL13<>\"\",ROUND(1/AL13,1),IF(AL40=\"\",\"\",ROUND(AL40,1)))","v":18.7},5,null,null,7,7,"3x7","Real Boost","D J Roebuck","B Knobel ",58,1,{"$nulls":5},1.2,26]
[null,null,8,"","","","","","","","","","","","","","","","",8,0.3,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL14<>\"\",ROUND(1/AL14,1),IF(AL41=\"\",\"\",ROUND(AL41,1)))","v":""},"",null,null,8,8,null,"Shoalhaven","D A Hayes","M J Walker ",58,8,{"$nulls":5},0,21]
[null,null,9,22,"","","","","","","","","","","","","",2,2,9,0.2,10,"","","","","","","","","","","","","",3.75,7.5,0.38095238095238093,21.25,{"$f":"IF(AL15<>\"\",ROUND(1/AL15,1),IF(AL42=\"\",\"\",ROUND(AL42,1)))","v":2.6},1,null,null,9,9,22,"Sommelier Pete","G A Osborne","M Zahra ",58,6,{"$nulls":5},6.3,4.8]
[null,null,10,"","","","","","","","","","","","","","","","",10,0.1,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL16<>\"\",ROUND(1/AL16,1),IF(AL43=\"\",\"\",ROUND(AL43,1)))","v":""},"",null,null,10,10,null,"The Originator","M A Kavanagh","D Oliver ",58,4,{"$nulls":5},0,5.5]
[null,null,11,"","","","","","","","","","","","","","","","",11,0,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL17<>\"\",ROUND(1/AL17,1),IF(AL44=\"\",\"\",ROUND(AL44,1)))","v":""},"",null,null,11,11,null,"Wild Erp","M C Kent","P Mertens ",58,11,{"$nulls":5},2.2999999999999998,9]
[null,null,12,"","","","","","","","","","","","","","","","",12,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL18<>\"\",ROUND(1/AL18,1),IF(AL45=\"\",\"\",ROUND(AL45,1)))","v":""},"",null,null,12]
[null,null,13,"","","","","","","","","","","","","","","","",13,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL19<>\"\",ROUND(1/AL19,1),IF(AL46=\"\",\"\",ROUND(AL46,1)))","v":""},"",null,null,13]
[null,null,14,"","","","","","","","","","","","","","","","",14,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL20<>\"\",ROUND(1/AL20,1),IF(AL47=\"\",\"\",ROUND(AL47,1)))","v":""},"",null,null,14]
[null,null,15,"","","","","","","","","","","","","","","","",15,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL21<>\"\",ROUND(1/AL21,1),IF(AL48=\"\",\"\",ROUND(AL48,1)))","v":""},"",null,null,15]
[null,null,16,"","","","","","","","","","","","","","","",{"$f":"IF(OR(S$6=\"\",$D22=\"\"),\"\",IF(LEN($D22)>=S$6,IF(LEFT(RIGHT($D22,S$6),1)=\"x\",\"\",IF(LEFT(RIGHT($D22,S$6),1)=\"0\",10,1*LEFT(RIGHT($D22,S$6),1))),\"\"))","v":""},16,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL22<>\"\",ROUND(1/AL22,1),IF(AL49=\"\",\"\",ROUND(AL49,1)))","v":""},"",null,null,16]
[null,null,17,"",{"$f":"IF(OR(E$6=\"\",$D23=\"\"),\"\",IF(LEN($D23)>=E$6,IF(LEFT(RIGHT($D23,E$6),1)=\"x\",\"\",IF(LEFT(RIGHT($D23,E$6),1)=\"0\",10,1*LEFT(RIGHT($D23,E$6),1))),\"\"))","v":""},"","","","","","","","","","","","","","",17,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL23<>\"\",ROUND(1/AL23,1),IF(AL50=\"\",\"\",ROUND(AL50,1)))","v":""},"",null,null,17]
[null,null,18,"","","","","","","","","","","","","","","","",18,null,"",{"$f":"IF(E24=\"\",\"\",$U$32/W$6/E24)","v":""},"","","","","","","","","","","","","","","","",{"$f":"IF(AL24<>\"\",ROUND(1/AL24,1),IF(AL51=\"\",\"\",ROUND(AL51,1)))","v":""},"",null,null,18]
[null,null,19,"","","","","","","","","","","","","","","","",19,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL25<>\"\",ROUND(1/AL25,1),IF(AL52=\"\",\"\",ROUND(AL52,1)))","v":""},"",null,null,19]
[null,null,20,"","","","","","","","","","","","","","","","",20,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL26<>\"\",ROUND(1/AL26,1),IF(AL53=\"\",\"\",ROUND(AL53,1)))","v":""},"",null,null,20]
[null,null,21,"","","","","","","","","","","","","","","","",21,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL27<>\"\",ROUND(1/AL27,1),IF(AL54=\"\",\"\",ROUND(AL54,1)))","v":""},"",null,null,21]
[null,null,22,"","","","","","","","","","","","","","","","",22,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL28<>\"\",ROUND(1/AL28,1),IF(AL55=\"\",\"\",ROUND(AL55,1)))","v":""},"",null,null,22]
[null,null,23,"","","","","","","","","","","","","","","","",23,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL29<>\"\",ROUND(1/AL29,1),IF(AL56=\"\",\"\",ROUND(AL56,1)))","v":""},"",null,null,23]
[null,null,24,"","","","","","","","","","","","","","","","",24,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL30<>\"\",ROUND(1/AL30,1),IF(AL57=\"\",\"\",ROUND(AL57,1)))","v":""},"",null,null,24]
[{"$nulls":20},"weight",{"$nulls":16},{"$f":"SUM(AL7:AL30)","v":0.8571428571428571}]
[{"$nulls":20},15,{"$nulls":16},{"$f":"SUM(U7:U10)-4+U11*COUNT(AM7:AM30)","v":21}]
[{"$nulls":18},">",{"$nulls":17},{"$f":"(1-AL31)/AK59","v":7.3050465696718843E-3},null,"<"]
[{"$nulls":36},{"$f":"IF(AO7>4,AM7,\"\")","v":""},{"$f":"IF(AK34=\"\",\"\",1/(AK$33*AK34))","v":""}]
[{"$nulls":36},{"$f":"IF(AO8>4,AM8,\"\")","v":""},{"$f":"IF(AK35=\"\",\"\",1/(AK$33*AK35))","v":""}]
[{"$nulls":36},{"$f":"IF(AO9>4,AM9,\"\")","v":""},{"$f":"IF(AK36=\"\",\"\",1/(AK$33*AK36))","v":""}]
[{"$nulls":36},{"$f":"IF(AO10>4,AM10,\"\")","v":5.75},{"$f":"IF(AK37=\"\",\"\",1/(AK$33*AK37))","v":23.807246376811584}]
[{"$nulls":36},{"$f":"IF(AO11>4,AM11,\"\")","v":6.496428571428571},{"$f":"IF(AK38=\"\",\"\",1/(AK$33*AK38))","v":21.071834341213115}]
[{"$nulls":36},{"$f":"IF(AO12>4,AM12,\"\")","v":""},{"$f":"IF(AK39=\"\",\"\",1/(AK$33*AK39))","v":""}]
[{"$nulls":36},{"$f":"IF(AO13>4,AM13,\"\")","v":7.3095238095238093},{"$f":"IF(AK40=\"\",\"\",1/(AK$33*AK40))","v":18.727850162866446}]
[{"$nulls":36},{"$f":"IF(AO14>4,AM14,\"\")","v":""},{"$f":"IF(AK41=\"\",\"\",1/(AK$33*AK41))","v":""}]
[{"$nulls":36},{"$f":"IF(AO15>4,AM15,\"\")","v":""},{"$f":"IF(AK42=\"\",\"\",1/(AK$33*AK42))","v":""}]
[{"$nulls":36},{"$f":"IF(AO16>4,AM16,\"\")","v":""},{"$f":"IF(AK43=\"\",\"\",1/(AK$33*AK43))","v":""}]
[{"$nulls":36},{"$f":"IF(AO17>4,AM17,\"\")","v":""},{"$f":"IF(AK44=\"\",\"\",1/(AK$33*AK44))","v":""}]
[{"$nulls":36},{"$f":"IF(AO18>4,AM18,\"\")","v":""},{"$f":"IF(AK45=\"\",\"\",1/(AK$33*AK45))","v":""}]
[{"$nulls":36},{"$f":"IF(AO19>4,AM19,\"\")","v":""},{"$f":"IF(AK46=\"\",\"\",1/(AK$33*AK46))","v":""}]
[{"$nulls":36},{"$f":"IF(AO20>4,AM20,\"\")","v":""},{"$f":"IF(AK47=\"\",\"\",1/(AK$33*AK47))","v":""}]
[{"$nulls":36},{"$f":"IF(AO21>4,AM21,\"\")","v":""},{"$f":"IF(AK48=\"\",\"\",1/(AK$33*AK48))","v":""}]
[{"$nulls":36},{"$f":"IF(AO22>4,AM22,\"\")","v":""},{"$f":"IF(AK49=\"\",\"\",1/(AK$33*AK49))","v":""}]
[{"$nulls":36},{"$f":"IF(AO23>4,AM23,\"\")","v":""},{"$f":"IF(AK50=\"\",\"\",1/(AK$33*AK50))","v":""}]
[{"$nulls":36},{"$f":"IF(AO24>4,AM24,\"\")","v":""},{"$f":"IF(AK51=\"\",\"\",1/(AK$33*AK51))","v":""}]
[{"$nulls":36},{"$f":"IF(AO25>4,AM25,\"\")","v":""},{"$f":"IF(AK52=\"\",\"\",1/(AK$33*AK52))","v":""}]
[{"$nulls":36},{"$f":"IF(AO26>4,AM26,\"\")","v":""},{"$f":"IF(AK53=\"\",\"\",1/(AK$33*AK53))","v":""}]
[{"$nulls":36},{"$f":"IF(AO27>4,AM27,\"\")","v":""},{"$f":"IF(AK54=\"\",\"\",1/(AK$33*AK54))","v":""}]
[{"$nulls":36},{"$f":"IF(AO28>4,AM28,\"\")","v":""},{"$f":"IF(AK55=\"\",\"\",1/(AK$33*AK55))","v":""}]
[{"$nulls":36},{"$f":"IF(AO29>4,AM29,\"\")","v":""},{"$f":"IF(AK56=\"\",\"\",1/(AK$33*AK56))","v":""}]
[{"$nulls":36},{"$f":"IF(AO30>4,AM30,\"\")","v":""},{"$f":"IF(AK57=\"\",\"\",1/(AK$33*AK57))","v":""}]
[{"$nulls":36},{"$f":"IF(AO31>4,AM31,\"\")","v":""},{"$f":"IF(AK58=\"\",\"\",1/(AK$33*AK58))","v":""}]
[{"$nulls":36},{"$f":"SUM(AK35:AK58)","v":19.55595238095238}]

{"sheet":"Sheet2","index":1,"n_rows":59,"n_cols":58,"rows_kept":59,"cut":false,"hidden":false,"merged":[[4,19,4,37],[4,38,4,40],[2,1,2,3],[1,1,1,3],[3,1,3,3]]}
[null,"HELP"]
[null,"FORM Analysis v2.0"]
[null,"02-11-2012",{"$nulls":16},">",{"$nulls":19},"<"]
[null,"Moonee Valley",{"$nulls":43},"FORM"]
[null,"Result",{"$f":"\"F \"&COUNT(AM7:AM30)","v":"F 6"},"Race 2",{"$nulls":15},"Calculations -- hidden for cosmetic reasons",{"$nulls":18},{"$f":"B4&\" \"&D5","v":"Moonee Valley Race 2"},{"$nulls":5},"v","delete if scratched"]
[null,"5.6.1","TAB","Form",15,14,13,12,11,10,9,8,7,6,5,4,3,2,1,"Finish Pos","Points","score",{"$f":"E6","v":15},{"$f":"F6","v":14},13,12,11,10,9,8,7,6,{"$f":"O6","v":5},{"$f":"P6","v":4},{"$f":"Q6","v":3},{"$f":"R6","v":2},{"$f":"S6","v":1},"Top 4","Analysis","BM Price","Rank",null,null,">","No","Last 10","Horse","Trainer","Jockey","Wt","Bar",{"$nulls":5},"API","PP"]
[null,null,1,{"$f":"IF(AT7=\"\",\"\",AT7)","v":"3112130x047"},{"$f":"IF(OR(E$6=\"\",$D7=\"\"),\"\",IF(LEN($D7)>=E$6,IF(LEFT(RIGHT($D7,E$6),1)=\"x\",\"\",IF(LEFT(RIGHT($D7,E$6),1)=\"0\",10,1*LEFT(RIGHT($D7,E$6),1))),\"\"))","v":""},"","","",3,1,1,2,1,3,10,"",10,4,7,1,8,{"$f":"IF(D7=\"\",\"\",VLOOKUP(IF(E7=\"\",11,E7),T$7:U$17,2)+VLOOKUP(IF(F7=\"\",11,F7),T$7:U$17,2)+VLOOKUP(IF(G7=\"\",11,G7),T$7:U$17,2)+VLOOKUP(IF(H7=\"\",11,H7),T$7:U$17,2)+VLOOKUP(IF(I7=\"\",11,I7),T$7:U$17,2)+VLOOKUP(IF(J7=\"\",11,J7),T$7:U$17,2)+VLOOKUP(IF(K7=\"\",11,K7),T$7:U$17,2)+VLOOKUP(IF(L7=\"\",11,L7),T$7:U$17,2)+VLOOKUP(IF(M7=\"\",11,M7),T$7:U$17,2)+VLOOKUP(IF(N7=\"\",11,N7),T$7:U$17,2)+VLOOKUP(IF(O7=\"\",11,O7),T$7:U$17,2)+VLOOKUP(IF(P7=\"\",11,P7),T$7:U$17,2)+VLOOKUP(IF(Q7=\"\",11,Q7),T$7:U$17,2)+VLOOKUP(IF(R7=\"\",11,R7),T$7:U$17,2)+VLOOKUP(IF(S7=\"\",11,S7),T$7:U$17,2))","v":37.700000000000003},{"$f":"IF(E7=\"\",\"\",$U$32/W$6/E7)","v":""},"","","",0.45454545454545453,1.5,1.6666666666666667,0.9375,2.1428571428571428,0.83333333333333337,0.3,"",0.5,1.875,2.1428571428571428,{"$f":"IF(AO7>4,\"\",1/(AL$32/VLOOKUP(AO7,T$7:U$11,2)))","v":""},{"$f":"IF(V7=\"\",\"\",SUM(W7:AK7)+V7)","v":50.052759740259745},{"$f":"IF(AL7<>\"\",ROUND(1/AL7,1),IF(AL34=\"\",\"\",ROUND(AL34,1)))","v":8.8000000000000007},{"$f":"IF(AM7=\"\",\"\",RANK(AM7,AM$7:AM$30))","v":5},null,null,1,1,"3112130x047","Sensational Report","Ms D Wynne","Ms S Wynne ",60,5,{"$nulls":5},4.8,8]
[null,null,2,{"$f":"IF(AT8=\"\",\"\",AT8)","v":""},"","","","","","","","","","","","","","","",2,5,{"$f":"IF(D8=\"\",\"\",VLOOKUP(IF(E8=\"\",24,E8),T$7:U$17,2)+VLOOKUP(IF(F8=\"\",24,F8),T$7:U$17,2)+VLOOKUP(IF(G8=\"\",24,G8),T$7:U$17,2)+VLOOKUP(IF(H8=\"\",24,H8),T$7:U$17,2)+VLOOKUP(IF(I8=\"\",24,I8),T$7:U$17,2)+VLOOKUP(IF(J8=\"\",24,J8),T$7:U$17,2)+VLOOKUP(IF(K8=\"\",24,K8),T$7:U$17,2)+VLOOKUP(IF(L8=\"\",24,L8),T$7:U$17,2)+VLOOKUP(IF(M8=\"\",24,M8),T$7:U$17,2)+VLOOKUP(IF(N8=\"\",24,N8),T$7:U$17,2)+VLOOKUP(IF(O8=\"\",24,O8),T$7:U$17,2)+VLOOKUP(IF(P8=\"\",24,P8),T$7:U$17,2)+VLOOKUP(IF(Q8=\"\",24,Q8),T$7:U$17,2)+VLOOKUP(IF(R8=\"\",24,R8),T$7:U$17,2)+VLOOKUP(IF(S8=\"\",24,S8),T$7:U$17,2))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AO8>4,\"\",1/(AL$32/VLOOKUP(AO8,T$7:U$11,2)))","v":""},{"$f":"IF(V8=\"\",\"\",SUM(W8:AK8)+V8)","v":""},{"$f":"IF(AL8<>\"\",ROUND(1/AL8,1),IF(AL35=\"\",\"\",ROUND(AL35,1)))","v":""},{"$f":"IF(AM8=\"\",\"\",RANK(AM8,AM$7:AM$30))","v":""},null,null,2,2,null,"Barbie Dazzler","Ms L Bonella","Thomas Sadler (3kg) ","56.5 (53.5)",4,{"$nulls":5},3.9,6.5]
[null,null,3,"14425x1154","","","","","",1,4,4,2,5,"",1,1,5,4,3,3,37,"","","","","",1.5,0.41666666666666669,0.46875,1.0714285714285714,0.5,"",3.75,5,1.5,3.75,0.25,54.956845238095241,{"$f":"IF(AL9<>\"\",ROUND(1/AL9,1),IF(AL36=\"\",\"\",ROUND(AL36,1)))","v":4},2,null,null,3,3,"14425x1154","Outdoor","Anthony Freedman","S W Arnold ",56.5,6,{"$nulls":5},5.8,3.8]
[null,null,4,"9x622242516","","","","",9,"",6,2,2,2,4,2,5,1,6,4,2,32.799999999999997,"","","","",0.15151515151515149,"",0.27777777777777779,0.9375,1.0714285714285714,1.25,0.75,1.875,1,7.5,2.5,0.1,50.113221500721494,{"$f":"IF(AL10<>\"\",ROUND(1/AL10,1),IF(AL37=\"\",\"\",ROUND(AL37,1)))","v":10},4,null,null,4,4,"9x622242516","Tranquera","R D Griffiths","Damian Lane (1.5kg) ","55.5 (54)",3,{"$nulls":5},5.5,3.2]
[null,6,5,"21x421","","","","","","","","","",2,1,"",4,2,1,5,1,28,"","","","","","","","","",1.25,3,"",1.25,3.75,15,0.15,52.25,{"$f":"IF(AL11<>\"\",ROUND(1/AL11,1),IF(AL38=\"\",\"\",ROUND(AL38,1)))","v":6.7},3,null,null,5,5,"21x421","Hollywood","D T O'Brien","J Winks ",55,1,{"$nulls":5},6.1,4]
[null,null,6,"123x4721","","","","","","","",1,2,3,"",4,7,2,1,6,0.8,31.5,"","","","","","","",1.875,1.0714285714285714,0.83333333333333337,"",0.9375,0.7142857142857143,3.75,15,0.4,55.68154761904762,{"$f":"IF(AL12<>\"\",ROUND(1/AL12,1),IF(AL39=\"\",\"\",ROUND(AL39,1)))","v":2.5},1,null,null,6,6,"123x4721","Help","E Jusufovic","R J Myers (1.5kg) ","55 (53.5)",2,{"$nulls":5},3.2,13]
[null,null,7,"","","","","","","","","","","","","","","","",7,0.5,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL13<>\"\",ROUND(1/AL13,1),IF(AL40=\"\",\"\",ROUND(AL40,1)))","v":""},"",null,null,7,7,null,"Harlequin Manner","Ms D Smith",null,55,7,{"$nulls":5},3.3,13]
[null,null,8,"02x03641333","","","","",10,2,"",10,3,6,4,1,3,3,3,8,0.3,28,"","","","",0.13636363636363635,0.75,"",0.1875,0.7142857142857143,0.41666666666666669,0.75,3.75,1.6666666666666667,2.5,5,"",43.871482683982684,{"$f":"IF(AL14<>\"\",ROUND(1/AL14,1),IF(AL41=\"\",\"\",ROUND(AL41,1)))","v":10},6,null,null,8,8,"02x03641333","Prussian Dancer","Ms J Bird","Nicholas Hall ",55,8,{"$nulls":5},1.5,21]
[null,null,9,"","","","","","","","","","","","","","","","",9,0.2,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL15<>\"\",ROUND(1/AL15,1),IF(AL42=\"\",\"\",ROUND(AL42,1)))","v":""},"",null,null,9]
[null,null,10,"","","","","","","","","","","","","","","","",10,0.1,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL16<>\"\",ROUND(1/AL16,1),IF(AL43=\"\",\"\",ROUND(AL43,1)))","v":""},"",null,null,10]
[null,null,11,"","","","","","","","","","","","","","","","",11,0,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL17<>\"\",ROUND(1/AL17,1),IF(AL44=\"\",\"\",ROUND(AL44,1)))","v":""},"",null,null,11]
[null,null,12,"","","","","","","","","","","","","","","","",12,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL18<>\"\",ROUND(1/AL18,1),IF(AL45=\"\",\"\",ROUND(AL45,1)))","v":""},"",null,null,12]
[null,null,13,"","","","","","","","","","","","","","","","",13,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL19<>\"\",ROUND(1/AL19,1),IF(AL46=\"\",\"\",ROUND(AL46,1)))","v":""},"",null,null,13]
[null,null,14,"","","","","","","","","","","","","","","","",14,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL20<>\"\",ROUND(1/AL20,1),IF(AL47=\"\",\"\",ROUND(AL47,1)))","v":""},"",null,null,14]
[null,null,15,"","","","","","","","","","","","","","","","",15,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL21<>\"\",ROUND(1/AL21,1),IF(AL48=\"\",\"\",ROUND(AL48,1)))","v":""},"",null,null,15]
[null,null,16,"","","","","","","","","","","","","","","",{"$f":"IF(OR(S$6=\"\",$D22=\"\"),\"\",IF(LEN($D22)>=S$6,IF(LEFT(RIGHT($D22,S$6),1)=\"x\",\"\",IF(LEFT(RIGHT($D22,S$6),1)=\"0\",10,1*LEFT(RIGHT($D22,S$6),1))),\"\"))","v":""},16,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL22<>\"\",ROUND(1/AL22,1),IF(AL49=\"\",\"\",ROUND(AL49,1)))","v":""},"",null,null,16]
[null,null,17,"",{"$f":"IF(OR(E$6=\"\",$D23=\"\"),\"\",IF(LEN($D23)>=E$6,IF(LEFT(RIGHT($D23,E$6),1)=\"x\",\"\",IF(LEFT(RIGHT($D23,E$6),1)=\"0\",10,1*LEFT(RIGHT($D23,E$6),1))),\"\"))","v":""},"","","","","","","","","","","","","","",17,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL23<>\"\",ROUND(1/AL23,1),IF(AL50=\"\",\"\",ROUND(AL50,1)))","v":""},"",null,null,17]
[null,null,18,"","","","","","","","","","","","","","","","",18,null,"",{"$f":"IF(E24=\"\",\"\",$U$32/W$6/E24)","v":""},"","","","","","","","","","","","","","","","",{"$f":"IF(AL24<>\"\",ROUND(1/AL24,1),IF(AL51=\"\",\"\",ROUND(AL51,1)))","v":""},"",null,null,18]
[null,null,19,"","","","","","","","","","","","","","","","",19,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL25<>\"\",ROUND(1/AL25,1),IF(AL52=\"\",\"\",ROUND(AL52,1)))","v":""},"",null,null,19]
[null,null,20,"","","","","","","","","","","","","","","","",20,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL26<>\"\",ROUND(1/AL26,1),IF(AL53=\"\",\"\",ROUND(AL53,1)))","v":""},"",null,null,20]
[null,null,21,"","","","","","","","","","","","","","","","",21,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL27<>\"\",ROUND(1/AL27,1),IF(AL54=\"\",\"\",ROUND(AL54,1)))","v":""},"",null,null,21]
[null,null,22,"","","","","","","","","","","","","","","","",22,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL28<>\"\",ROUND(1/AL28,1),IF(AL55=\"\",\"\",ROUND(AL55,1)))","v":""},"",null,null,22]
[null,null,23,"","","","","","","","","","","","","","","","",23,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL29<>\"\",ROUND(1/AL29,1),IF(AL56=\"\",\"\",ROUND(AL56,1)))","v":""},"",null,null,23]
[null,null,24,"","","","","","","","","","","","","","","","",24,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL30<>\"\",ROUND(1/AL30,1),IF(AL57=\"\",\"\",ROUND(AL57,1)))","v":""},"",null,null,24]
[{"$nulls":20},"weight",{"$nulls":16},{"$f":"SUM(AL7:AL30)","v":0.9}]
[{"$nulls":20},15,{"$nulls":16},{"$f":"SUM(U7:U10)-4+U11*COUNT(AM7:AM30)","v":20}]
[{"$nulls":18},">",{"$nulls":17},{"$f":"(1-AL31)/AK59","v":2.279385010083318E-3},null,"<"]
[{"$nulls":36},{"$f":"IF(AO7>4,AM7,\"\")","v":50.052759740259745},{"$f":"IF(AK34=\"\",\"\",1/(AK$33*AK34))","v":8.7650477039919998}]
[{"$nulls":36},{"$f":"IF(AO8>4,AM8,\"\")","v":""},{"$f":"IF(AK35=\"\",\"\",1/(AK$33*AK35))","v":""}]
[{"$nulls":36},{"$f":"IF(AO9>4,AM9,\"\")","v":""},{"$f":"IF(AK36=\"\",\"\",1/(AK$33*AK36))","v":""}]
[{"$nulls":36},{"$f":"IF(AO10>4,AM10,\"\")","v":""},{"$f":"IF(AK37=\"\",\"\",1/(AK$33*AK37))","v":""}]
[{"$nulls":36},{"$f":"IF(AO11>4,AM11,\"\")","v":""},{"$f":"IF(AK38=\"\",\"\",1/(AK$33*AK38))","v":""}]
[{"$nulls":36},{"$f":"IF(AO12>4,AM12,\"\")","v":""},{"$f":"IF(AK39=\"\",\"\",1/(AK$33*AK39))","v":""}]
[{"$nulls":36},{"$f":"IF(AO13>4,AM13,\"\")","v":""},{"$f":"IF(AK40=\"\",\"\",1/(AK$33*AK40))","v":""}]
[{"$nulls":36},{"$f":"IF(AO14>4,AM14,\"\")","v":43.871482683982684},{"$f":"IF(AK41=\"\",\"\",1/(AK$33*AK41))","v":10.000000000000002}]
[{"$nulls":36},{"$f":"IF(AO15>4,AM15,\"\")","v":""},{"$f":"IF(AK42=\"\",\"\",1/(AK$33*AK42))","v":""}]
[{"$nulls":36},{"$f":"IF(AO16>4,AM16,\"\")","v":""},{"$f":"IF(AK43=\"\",\"\",1/(AK$33*AK43))","v":""}]
[{"$nulls":36},{"$f":"IF(AO17>4,AM17,\"\")","v":""},{"$f":"IF(AK44=\"\",\"\",1/(AK$33*AK44))","v":""}]
[{"$nulls":36},{"$f":"IF(AO18>4,AM18,\"\")","v":""},{"$f":"IF(AK45=\"\",\"\",1/(AK$33*AK45))","v":""}]
[{"$nulls":36},{"$f":"IF(AO19>4,AM19,\"\")","v":""},{"$f":"IF(AK46=\"\",\"\",1/(AK$33*AK46))","v":""}]
[{"$nulls":36},{"$f":"IF(AO20>4,AM20,\"\")","v":""},{"$f":"IF(AK47=\"\",\"\",1/(AK$33*AK47))","v":""}]
[{"$nulls":36},{"$f":"IF(AO21>4,AM21,\"\")","v":""},{"$f":"IF(AK48=\"\",\"\",1/(AK$33*AK48))","v":""}]
[{"$nulls":36},{"$f":"IF(AO22>4,AM22,\"\")","v":""},{"$f":"IF(AK49=\"\",\"\",1/(AK$33*AK49))","v":""}]
[{"$nulls":36},{"$f":"IF(AO23>4,AM23,\"\")","v":""},{"$f":"IF(AK50=\"\",\"\",1/(AK$33*AK50))","v":""}]
[{"$nulls":36},{"$f":"IF(AO24>4,AM24,\"\")","v":""},{"$f":"IF(AK51=\"\",\"\",1/(AK$33*AK51))","v":""}]
[{"$nulls":36},{"$f":"IF(AO25>4,AM25,\"\")","v":""},{"$f":"IF(AK52=\"\",\"\",1/(AK$33*AK52))","v":""}]
[{"$nulls":36},{"$f":"IF(AO26>4,AM26,\"\")","v":""},{"$f":"IF(AK53=\"\",\"\",1/(AK$33*AK53))","v":""}]
[{"$nulls":36},{"$f":"IF(AO27>4,AM27,\"\")","v":""},{"$f":"IF(AK54=\"\",\"\",1/(AK$33*AK54))","v":""}]
[{"$nulls":36},{"$f":"IF(AO28>4,AM28,\"\")","v":""},{"$f":"IF(AK55=\"\",\"\",1/(AK$33*AK55))","v":""}]
[{"$nulls":36},{"$f":"IF(AO29>4,AM29,\"\")","v":""},{"$f":"IF(AK56=\"\",\"\",1/(AK$33*AK56))","v":""}]
[{"$nulls":36},{"$f":"IF(AO30>4,AM30,\"\")","v":""},{"$f":"IF(AK57=\"\",\"\",1/(AK$33*AK57))","v":""}]
[{"$nulls":36},{"$f":"IF(AO31>4,AM31,\"\")","v":""},{"$f":"IF(AK58=\"\",\"\",1/(AK$33*AK58))","v":""}]
[{"$nulls":36},{"$f":"SUM(AK35:AK58)","v":43.871482683982684}]

{"sheet":"Sheet3","index":2,"n_rows":59,"n_cols":58,"rows_kept":59,"cut":false,"hidden":false,"merged":[[4,19,4,37],[4,38,4,40],[2,1,2,3],[1,1,1,3],[3,1,3,3]]}
[null,"HELP"]
[null,"FORM Analysis v2.0"]
[null,"02-11-2012",{"$nulls":16},">",{"$nulls":19},"<"]
[null,"Moonee Valley",{"$nulls":43},"FORM"]
[null,"Result",{"$f":"\"F \"&COUNT(AM7:AM30)","v":"F 7"},"Race 3",{"$nulls":15},"Calculations -- hidden for cosmetic reasons",{"$nulls":18},{"$f":"B4&\" \"&D5","v":"Moonee Valley Race 3"},{"$nulls":5},"v","delete if scratched"]
[null,"2.7.5","TAB","Form",15,14,13,12,11,10,9,8,7,6,5,4,3,2,1,"Finish Pos","Points","score",{"$f":"E6","v":15},{"$f":"F6","v":14},13,12,11,10,9,8,7,6,{"$f":"O6","v":5},{"$f":"P6","v":4},{"$f":"Q6","v":3},{"$f":"R6","v":2},{"$f":"S6","v":1},"Top 4","Analysis","BM Price","Rank",null,null,">","No","Last 10","Horse","Trainer","Jockey","Wt","Bar",{"$nulls":5},"API","PP"]
[null,null,1,{"$f":"IF(AT7=\"\",\"\",AT7)","v":22},{"$f":"IF(OR(E$6=\"\",$D7=\"\"),\"\",IF(LEN($D7)>=E$6,IF(LEFT(RIGHT($D7,E$6),1)=\"x\",\"\",IF(LEFT(RIGHT($D7,E$6),1)=\"0\",10,1*LEFT(RIGHT($D7,E$6),1))),\"\"))","v":""},"","","","","","","","","","","","",2,2,1,8,{"$f":"IF(D7=\"\",\"\",VLOOKUP(IF(E7=\"\",11,E7),T$7:U$17,2)+VLOOKUP(IF(F7=\"\",11,F7),T$7:U$17,2)+VLOOKUP(IF(G7=\"\",11,G7),T$7:U$17,2)+VLOOKUP(IF(H7=\"\",11,H7),T$7:U$17,2)+VLOOKUP(IF(I7=\"\",11,I7),T$7:U$17,2)+VLOOKUP(IF(J7=\"\",11,J7),T$7:U$17,2)+VLOOKUP(IF(K7=\"\",11,K7),T$7:U$17,2)+VLOOKUP(IF(L7=\"\",11,L7),T$7:U$17,2)+VLOOKUP(IF(M7=\"\",11,M7),T$7:U$17,2)+VLOOKUP(IF(N7=\"\",11,N7),T$7:U$17,2)+VLOOKUP(IF(O7=\"\",11,O7),T$7:U$17,2)+VLOOKUP(IF(P7=\"\",11,P7),T$7:U$17,2)+VLOOKUP(IF(Q7=\"\",11,Q7),T$7:U$17,2)+VLOOKUP(IF(R7=\"\",11,R7),T$7:U$17,2)+VLOOKUP(IF(S7=\"\",11,S7),T$7:U$17,2))","v":10},{"$f":"IF(E7=\"\",\"\",$U$32/W$6/E7)","v":""},"","","","","","","","","","","","",3.75,7.5,{"$f":"IF(AO7>4,\"\",1/(AL$32/VLOOKUP(AO7,T$7:U$11,2)))","v":0.23809523809523808},{"$f":"IF(V7=\"\",\"\",SUM(W7:AK7)+V7)","v":21.25},{"$f":"IF(AL7<>\"\",ROUND(1/AL7,1),IF(AL34=\"\",\"\",ROUND(AL34,1)))","v":4.2},{"$f":"IF(AM7=\"\",\"\",RANK(AM7,AM$7:AM$30))","v":2},null,null,1,1,22,"Dreaming The Dream","A & D Campbell","D Gauci ",58.5,10,{"$nulls":5},2.6,6]
[null,4.8,2,{"$f":"IF(AT8=\"\",\"\",AT8)","v":"266439x"},"","","","","","","","",2,6,6,4,3,9,"",2,5,{"$f":"IF(D8=\"\",\"\",VLOOKUP(IF(E8=\"\",24,E8),T$7:U$17,2)+VLOOKUP(IF(F8=\"\",24,F8),T$7:U$17,2)+VLOOKUP(IF(G8=\"\",24,G8),T$7:U$17,2)+VLOOKUP(IF(H8=\"\",24,H8),T$7:U$17,2)+VLOOKUP(IF(I8=\"\",24,I8),T$7:U$17,2)+VLOOKUP(IF(J8=\"\",24,J8),T$7:U$17,2)+VLOOKUP(IF(K8=\"\",24,K8),T$7:U$17,2)+VLOOKUP(IF(L8=\"\",24,L8),T$7:U$17,2)+VLOOKUP(IF(M8=\"\",24,M8),T$7:U$17,2)+VLOOKUP(IF(N8=\"\",24,N8),T$7:U$17,2)+VLOOKUP(IF(O8=\"\",24,O8),T$7:U$17,2)+VLOOKUP(IF(P8=\"\",24,P8),T$7:U$17,2)+VLOOKUP(IF(Q8=\"\",24,Q8),T$7:U$17,2)+VLOOKUP(IF(R8=\"\",24,R8),T$7:U$17,2)+VLOOKUP(IF(S8=\"\",24,S8),T$7:U$17,2))","v":11.799999999999999},"","","","","","","","",1.0714285714285714,0.41666666666666669,0.5,0.9375,1.6666666666666667,0.83333333333333337,"",{"$f":"IF(AO8>4,\"\",1/(AL$32/VLOOKUP(AO8,T$7:U$11,2)))","v":0.14285714285714285},{"$f":"IF(V8=\"\",\"\",SUM(W8:AK8)+V8)","v":17.225595238095238},{"$f":"IF(AL8<>\"\",ROUND(1/AL8,1),IF(AL35=\"\",\"\",ROUND(AL35,1)))","v":7},{"$f":"IF(AM8=\"\",\"\",RANK(AM8,AM$7:AM$30))","v":3},null,null,2,2,"266439x","Falconer","J B Cummings","S W Arnold ",58.5,4,{"$nulls":5},1.6,6]
[null,null,3,2,"","","","","","","","","","","","","","",2,3,3,5,"","","","","","","","","","","","","","",7.5,"",12.5,{"$f":"IF(AL9<>\"\",ROUND(1/AL9,1),IF(AL36=\"\",\"\",ROUND(AL36,1)))","v":13},5,null,null,3,3,2,"Gilgandra Jack","C J Davies","A Mc Cabe ",58.5,5,{"$nulls":5},3.4,11]
[null,null,4,3,"","","","","","","","","","","","","","",3,4,2,3,"","","","","","","","","","","","","","",5,"",8,{"$f":"IF(AL10<>\"\",ROUND(1/AL10,1),IF(AL37=\"\",\"\",ROUND(AL37,1)))","v":20.3},6,null,null,4,4,3,"God's Will","B L Jenkins","I Gundogdu ",58.5,11,{"$nulls":5},0.6,21]
[null,null,5,7,"","","","","","","","","","","","","","",7,5,1,0.5,"","","","","","","","","","","","","","",2.1428571428571428,"",2.6428571428571428,{"$f":"IF(AL11<>\"\",ROUND(1/AL11,1),IF(AL38=\"\",\"\",ROUND(AL38,1)))","v":61.3},7,null,null,5,5,7,"Hollywood Gothic","Todd Balfour","Nicholas Hall ",58.5,9,{"$nulls":5},1.2,3.5]
[null,null,6,"","","","","","","","","","","","","","","","",6,0.8,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL12<>\"\",ROUND(1/AL12,1),IF(AL39=\"\",\"\",ROUND(AL39,1)))","v":""},"",null,null,6,6,null,"Canto","Jason Warren","D Oliver ",57,7,{"$nulls":5},0,5]
[null,null,7,"","","","","","","","","","","","","","","","",7,0.5,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL13<>\"\",ROUND(1/AL13,1),IF(AL40=\"\",\"\",ROUND(AL40,1)))","v":""},"",null,null,7,7,null,"More Than A Song","D A Hayes","C Newitt ",57,6,{"$nulls":5},0,9]
[null,null,8,"","","","","","","","","","","","","","","","",8,0.3,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL14<>\"\",ROUND(1/AL14,1),IF(AL41=\"\",\"\",ROUND(AL41,1)))","v":""},"",null,null,8,8,null,"Red Hot Shot","B J McCarthy","J Mott ",57,2,{"$nulls":5},0,16]
[null,null,9,"226x0x","","","","","","","","","",2,2,6,"",10,"",9,0.2,10.9,"","","","","","","","","",1.25,1.5,0.625,"",0.75,"",9.5238095238095233E-2,15.025,{"$f":"IF(AL15<>\"\",ROUND(1/AL15,1),IF(AL42=\"\",\"\",ROUND(AL42,1)))","v":10.5},4,null,null,9,9,"226x0x","Lustful","R S McDonald","M Rodd ",56.5,3,{"$nulls":5},2.1,17]
[null,null,10,"09x4242323x2","","","",10,9,"",4,2,4,2,3,2,3,"",2,10,0.1,30.3,"","","",0.125,0.15151515151515149,"",0.41666666666666669,0.9375,0.5357142857142857,1.25,1,1.875,1.6666666666666667,"",7.5,0.38095238095238093,45.758062770562773,{"$f":"IF(AL16<>\"\",ROUND(1/AL16,1),IF(AL43=\"\",\"\",ROUND(AL43,1)))","v":2.6},1,null,null,10,10,"09x4242323x2","Manhattan Gold","C C Parry","B Higgins ",56.5,8,{"$nulls":5},1.3,11]
[null,null,11,"","","","","","","","","","","","","","","","",11,0,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL17<>\"\",ROUND(1/AL17,1),IF(AL44=\"\",\"\",ROUND(AL44,1)))","v":""},"",null,null,11,11,null,"La Fluorescent","D T O'Brien","M J Walker ",55,1,{"$nulls":5},0,9]
[null,null,12,"","","","","","","","","","","","","","","","",12,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL18<>\"\",ROUND(1/AL18,1),IF(AL45=\"\",\"\",ROUND(AL45,1)))","v":""},"",null,null,12]
[null,null,13,"","","","","","","","","","","","","","","","",13,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL19<>\"\",ROUND(1/AL19,1),IF(AL46=\"\",\"\",ROUND(AL46,1)))","v":""},"",null,null,13]
[null,null,14,"","","","","","","","","","","","","","","","",14,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL20<>\"\",ROUND(1/AL20,1),IF(AL47=\"\",\"\",ROUND(AL47,1)))","v":""},"",null,null,14]
[null,null,15,"","","","","","","","","","","","","","","","",15,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL21<>\"\",ROUND(1/AL21,1),IF(AL48=\"\",\"\",ROUND(AL48,1)))","v":""},"",null,null,15]
[null,null,16,"","","","","","","","","","","","","","","","",16,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL22<>\"\",ROUND(1/AL22,1),IF(AL49=\"\",\"\",ROUND(AL49,1)))","v":""},"",null,null,16]
[null,null,17,"",{"$f":"IF(OR(E$6=\"\",$D23=\"\"),\"\",IF(LEN($D23)>=E$6,IF(LEFT(RIGHT($D23,E$6),1)=\"x\",\"\",IF(LEFT(RIGHT($D23,E$6),1)=\"0\",10,1*LEFT(RIGHT($D23,E$6),1))),\"\"))","v":""},"","","","","","","","","","","","","","",17,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL23<>\"\",ROUND(1/AL23,1),IF(AL50=\"\",\"\",ROUND(AL50,1)))","v":""},"",null,null,17]
[null,null,18,"","","","","","","","","","","","","","","","",18,null,"",{"$f":"IF(E24=\"\",\"\",$U$32/W$6/E24)","v":""},"","","","","","","","","","","","","","","","",{"$f":"IF(AL24<>\"\",ROUND(1/AL24,1),IF(AL51=\"\",\"\",ROUND(AL51,1)))","v":""},"",null,null,18]
[null,null,19,"","","","","","","","","","","","","","","","",19,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL25<>\"\",ROUND(1/AL25,1),IF(AL52=\"\",\"\",ROUND(AL52,1)))","v":""},"",null,null,19]
[null,null,20,"","","","","","","","","","","","","","","","",20,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL26<>\"\",ROUND(1/AL26,1),IF(AL53=\"\",\"\",ROUND(AL53,1)))","v":""},"",null,null,20]
[null,null,21,"","","","","","","","","","","","","","","","",21,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL27<>\"\",ROUND(1/AL27,1),IF(AL54=\"\",\"\",ROUND(AL54,1)))","v":""},"",null,null,21]
[null,null,22,"","","","","","","","","","","","","","","","",22,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL28<>\"\",ROUND(1/AL28,1),IF(AL55=\"\",\"\",ROUND(AL55,1)))","v":""},"",null,null,22]
[null,null,23,"","","","","","","","","","","","","","","","",23,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL29<>\"\",ROUND(1/AL29,1),IF(AL56=\"\",\"\",ROUND(AL56,1)))","v":""},"",null,null,23]
[null,null,24,"","","","","","","","","","","","","","","","",24,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL30<>\"\",ROUND(1/AL30,1),IF(AL57=\"\",\"\",ROUND(AL57,1)))","v":""},"",null,null,24]
[{"$nulls":20},"weight",{"$nulls":16},{"$f":"SUM(AL7:AL30)","v":0.8571428571428571}]
[{"$nulls":20},15,{"$nulls":16},{"$f":"SUM(U7:U10)-4+U11*COUNT(AM7:AM30)","v":21}]
[{"$nulls":18},">",{"$nulls":17},{"$f":"(1-AL31)/AK59","v":6.1728395061728418E-3},null,"<"]
[{"$nulls":36},{"$f":"IF(AO7>4,AM7,\"\")","v":""},{"$f":"IF(AK34=\"\",\"\",1/(AK$33*AK34))","v":""}]
[{"$nulls":36},{"$f":"IF(AO8>4,AM8,\"\")","v":""},{"$f":"IF(AK35=\"\",\"\",1/(AK$33*AK35))","v":""}]
[{"$nulls":36},{"$f":"IF(AO9>4,AM9,\"\")","v":12.5},{"$f":"IF(AK36=\"\",\"\",1/(AK$33*AK36))","v":12.959999999999996}]
[{"$nulls":36},{"$f":"IF(AO10>4,AM10,\"\")","v":8},{"$f":"IF(AK37=\"\",\"\",1/(AK$33*AK37))","v":20.249999999999993}]
[{"$nulls":36},{"$f":"IF(AO11>4,AM11,\"\")","v":2.6428571428571428},{"$f":"IF(AK38=\"\",\"\",1/(AK$33*AK38))","v":61.297297297297277}]
[{"$nulls":36},{"$f":"IF(AO12>4,AM12,\"\")","v":""},{"$f":"IF(AK39=\"\",\"\",1/(AK$33*AK39))","v":""}]
[{"$nulls":36},{"$f":"IF(AO13>4,AM13,\"\")","v":""},{"$f":"IF(AK40=\"\",\"\",1/(AK$33*AK40))","v":""}]
[{"$nulls":36},{"$f":"IF(AO14>4,AM14,\"\")","v":""},{"$f":"IF(AK41=\"\",\"\",1/(AK$33*AK41))","v":""}]
[{"$nulls":36},{"$f":"IF(AO15>4,AM15,\"\")","v":""},{"$f":"IF(AK42=\"\",\"\",1/(AK$33*AK42))","v":""}]
[{"$nulls":36},{"$f":"IF(AO16>4,AM16,\"\")","v":""},{"$f":"IF(AK43=\"\",\"\",1/(AK$33*AK43))","v":""}]
[{"$nulls":36},{"$f":"IF(AO17>4,AM17,\"\")","v":""},{"$f":"IF(AK44=\"\",\"\",1/(AK$33*AK44))","v":""}]
[{"$nulls":36},{"$f":"IF(AO18>4,AM18,\"\")","v":""},{"$f":"IF(AK45=\"\",\"\",1/(AK$33*AK45))","v":""}]
[{"$nulls":36},{"$f":"IF(AO19>4,AM19,\"\")","v":""},{"$f":"IF(AK46=\"\",\"\",1/(AK$33*AK46))","v":""}]
[{"$nulls":36},{"$f":"IF(AO20>4,AM20,\"\")","v":""},{"$f":"IF(AK47=\"\",\"\",1/(AK$33*AK47))","v":""}]
[{"$nulls":36},{"$f":"IF(AO21>4,AM21,\"\")","v":""},{"$f":"IF(AK48=\"\",\"\",1/(AK$33*AK48))","v":""}]
[{"$nulls":36},{"$f":"IF(AO22>4,AM22,\"\")","v":""},{"$f":"IF(AK49=\"\",\"\",1/(AK$33*AK49))","v":""}]
[{"$nulls":36},{"$f":"IF(AO23>4,AM23,\"\")","v":""},{"$f":"IF(AK50=\"\",\"\",1/(AK$33*AK50))","v":""}]
[{"$nulls":36},{"$f":"IF(AO24>4,AM24,\"\")","v":""},{"$f":"IF(AK51=\"\",\"\",1/(AK$33*AK51))","v":""}]
[{"$nulls":36},{"$f":"IF(AO25>4,AM25,\"\")","v":""},{"$f":"IF(AK52=\"\",\"\",1/(AK$33*AK52))","v":""}]
[{"$nulls":36},{"$f":"IF(AO26>4,AM26,\"\")","v":""},{"$f":"IF(AK53=\"\",\"\",1/(AK$33*AK53))","v":""}]
[{"$nulls":36},{"$f":"IF(AO27>4,AM27,\"\")","v":""},{"$f":"IF(AK54=\"\",\"\",1/(AK$33*AK54))","v":""}]
[{"$nulls":36},{"$f":"IF(AO28>4,AM28,\"\")","v":""},{"$f":"IF(AK55=\"\",\"\",1/(AK$33*AK55))","v":""}]
[{"$nulls":36},{"$f":"IF(AO29>4,AM29,\"\")","v":""},{"$f":"IF(AK56=\"\",\"\",1/(AK$33*AK56))","v":""}]
[{"$nulls":36},{"$f":"IF(AO30>4,AM30,\"\")","v":""},{"$f":"IF(AK57=\"\",\"\",1/(AK$33*AK57))","v":""}]
[{"$nulls":36},{"$f":"IF(AO31>4,AM31,\"\")","v":""},{"$f":"IF(AK58=\"\",\"\",1/(AK$33*AK58))","v":""}]
[{"$nulls":36},{"$f":"SUM(AK35:AK58)","v":23.142857142857142}]

{"sheet":"Sheet4","index":3,"n_rows":59,"n_cols":58,"rows_kept":59,"cut":false,"hidden":false,"merged":[[4,19,4,37],[4,38,4,40],[2,1,2,3],[1,1,1,3],[3,1,3,3]]}
[null,"HELP"]
[null,"FORM Analysis v2.0"]
[null,"02-11-2012",{"$nulls":16},">",{"$nulls":19},"<"]
[null,"Moonee Valley",{"$nulls":43},"FORM"]
[null,"Result",{"$f":"\"F \"&COUNT(AM7:AM30)","v":"F 10"},"Race 4",{"$nulls":15},"Calculations -- hidden for cosmetic reasons",{"$nulls":18},{"$f":"B4&\" \"&D5","v":"Moonee Valley Race 4"},{"$nulls":5},"v","delete if scratched"]
[null,"8.7.9","TAB","Form",15,14,13,12,11,10,9,8,7,6,5,4,3,2,1,"Finish Pos","Points","score",{"$f":"E6","v":15},{"$f":"F6","v":14},13,12,11,10,9,8,7,6,{"$f":"O6","v":5},{"$f":"P6","v":4},{"$f":"Q6","v":3},{"$f":"R6","v":2},{"$f":"S6","v":1},"Top 4","Analysis","BM Price","Rank",null,null,">","No","Last 10","Horse","Trainer","Jockey","Wt","Bar",{"$nulls":5},"API","PP"]
[null,null,1,{"$f":"IF(AT7=\"\",\"\",AT7)","v":"58x725622x24"},{"$f":"IF(OR(E$6=\"\",$D7=\"\"),\"\",IF(LEN($D7)>=E$6,IF(LEFT(RIGHT($D7,E$6),1)=\"x\",\"\",IF(LEFT(RIGHT($D7,E$6),1)=\"0\",10,1*LEFT(RIGHT($D7,E$6),1))),\"\"))","v":""},"","",5,8,"",7,2,5,6,2,2,"",2,4,1,8,{"$f":"IF(D7=\"\",\"\",VLOOKUP(IF(E7=\"\",11,E7),T$7:U$17,2)+VLOOKUP(IF(F7=\"\",11,F7),T$7:U$17,2)+VLOOKUP(IF(G7=\"\",11,G7),T$7:U$17,2)+VLOOKUP(IF(H7=\"\",11,H7),T$7:U$17,2)+VLOOKUP(IF(I7=\"\",11,I7),T$7:U$17,2)+VLOOKUP(IF(J7=\"\",11,J7),T$7:U$17,2)+VLOOKUP(IF(K7=\"\",11,K7),T$7:U$17,2)+VLOOKUP(IF(L7=\"\",11,L7),T$7:U$17,2)+VLOOKUP(IF(M7=\"\",11,M7),T$7:U$17,2)+VLOOKUP(IF(N7=\"\",11,N7),T$7:U$17,2)+VLOOKUP(IF(O7=\"\",11,O7),T$7:U$17,2)+VLOOKUP(IF(P7=\"\",11,P7),T$7:U$17,2)+VLOOKUP(IF(Q7=\"\",11,Q7),T$7:U$17,2)+VLOOKUP(IF(R7=\"\",11,R7),T$7:U$17,2)+VLOOKUP(IF(S7=\"\",11,S7),T$7:U$17,2))","v":25.6},{"$f":"IF(E7=\"\",\"\",$U$32/W$6/E7)","v":""},"","",0.25,0.17045454545454544,"",0.23809523809523811,0.9375,0.42857142857142855,0.41666666666666669,1.5,1.875,"",3.75,3.75,{"$f":"IF(AO7>4,\"\",1/(AL$32/VLOOKUP(AO7,T$7:U$11,2)))","v":""},{"$f":"IF(V7=\"\",\"\",SUM(W7:AK7)+V7)","v":38.916287878787884},{"$f":"IF(AL7<>\"\",ROUND(1/AL7,1),IF(AL34=\"\",\"\",ROUND(AL34,1)))","v":16.100000000000001},{"$f":"IF(AM7=\"\",\"\",RANK(AM7,AM$7:AM$30))","v":7},null,null,1,1,"58x725622x24","Akzar","R J Blacker","A Mc Cabe (2kg) ","60 (58)",1,{"$nulls":5},7.2,4]
[null,null,2,{"$f":"IF(AT8=\"\",\"\",AT8)","v":"171x941x8631"},"","","",1,7,1,"",9,4,1,"",8,6,3,1,2,5,{"$f":"IF(D8=\"\",\"\",VLOOKUP(IF(E8=\"\",24,E8),T$7:U$17,2)+VLOOKUP(IF(F8=\"\",24,F8),T$7:U$17,2)+VLOOKUP(IF(G8=\"\",24,G8),T$7:U$17,2)+VLOOKUP(IF(H8=\"\",24,H8),T$7:U$17,2)+VLOOKUP(IF(I8=\"\",24,I8),T$7:U$17,2)+VLOOKUP(IF(J8=\"\",24,J8),T$7:U$17,2)+VLOOKUP(IF(K8=\"\",24,K8),T$7:U$17,2)+VLOOKUP(IF(L8=\"\",24,L8),T$7:U$17,2)+VLOOKUP(IF(M8=\"\",24,M8),T$7:U$17,2)+VLOOKUP(IF(N8=\"\",24,N8),T$7:U$17,2)+VLOOKUP(IF(O8=\"\",24,O8),T$7:U$17,2)+VLOOKUP(IF(P8=\"\",24,P8),T$7:U$17,2)+VLOOKUP(IF(Q8=\"\",24,Q8),T$7:U$17,2)+VLOOKUP(IF(R8=\"\",24,R8),T$7:U$17,2)+VLOOKUP(IF(S8=\"\",24,S8),T$7:U$17,2))","v":38.799999999999997},"","","",1.25,0.19480519480519479,1.5,"",0.20833333333333334,0.5357142857142857,2.5,"",0.46875,0.83333333333333337,2.5,15,{"$f":"IF(AO8>4,\"\",1/(AL$32/VLOOKUP(AO8,T$7:U$11,2)))","v":0.125},{"$f":"IF(V8=\"\",\"\",SUM(W8:AK8)+V8)","v":63.790936147186144},{"$f":"IF(AL8<>\"\",ROUND(1/AL8,1),IF(AL35=\"\",\"\",ROUND(AL35,1)))","v":8},{"$f":"IF(AM8=\"\",\"\",RANK(AM8,AM$7:AM$30))","v":3},null,null,2,2,"171x941x8631","Lethal Dealings","Luke Oliver","A Mallyon ",57.5,6,{"$nulls":5},3.5,8.5]
[null,null,3,"41x42127x699","","","",4,1,"",4,2,1,2,7,"",6,9,9,3,3,31.7,"","","",0.3125,1.3636363636363635,"",0.41666666666666669,0.9375,2.1428571428571428,1.25,0.42857142857142855,"",0.83333333333333337,0.83333333333333337,1.6666666666666667,"",41.885064935064932,{"$f":"IF(AL9<>\"\",ROUND(1/AL9,1),IF(AL36=\"\",\"\",ROUND(AL36,1)))","v":15},5,null,null,3,3,"41x42127x699","Barysh Quest","G S White","C Newitt ",57,4,{"$nulls":5},9.1999999999999993,5.5]
[null,null,4,"191x7069x700","","","",1,9,1,"",7,10,6,9,"",7,10,10,4,2,18.500000000000004,"","","",1.25,0.15151515151515149,1.5,"",0.26785714285714285,0.21428571428571427,0.41666666666666669,0.33333333333333331,"",0.7142857142857143,0.75,1.5,"",25.597943722943725,{"$f":"IF(AL10<>\"\",ROUND(1/AL10,1),IF(AL37=\"\",\"\",ROUND(AL37,1)))","v":24.5},9,null,null,4,4,"191x7069x700","Testas Double","K M Keys","Nicholas Hall ",56.5,9,{"$nulls":5},4.3,31]
[null,null,5,"131135x1820","","","","",1,3,1,1,3,5,"",1,8,2,10,5,1,44.4,"","","","",1.3636363636363635,0.5,1.6666666666666667,1.875,0.7142857142857143,0.5,"",3.75,0.625,3.75,1.5,8.3333333333333329E-2,60.644588744588745,{"$f":"IF(AL11<>\"\",ROUND(1/AL11,1),IF(AL38=\"\",\"\",ROUND(AL38,1)))","v":12},4,null,null,5,5,"131135x1820","Quick Shakes","S Morrish","D Oliver ",56,7,{"$nulls":5},2.9,11]
[null,null,6,"64470x85847","","","","",6,4,4,7,10,"",8,5,8,4,7,6,0.8,9.5,"","","","",0.22727272727272727,0.375,0.41666666666666669,0.26785714285714285,0.21428571428571427,"",0.375,0.75,0.625,1.875,2.1428571428571428,"",16.768939393939394,{"$f":"IF(AL12<>\"\",ROUND(1/AL12,1),IF(AL39=\"\",\"\",ROUND(AL39,1)))","v":37.4},10,null,null,6,6,"64470x85847","Sean Baile Mor","Todd Balfour","Dean Holland ",55,5,{"$nulls":5},4.5999999999999996,15]
[null,null,7,"2546x684210","","","","",2,5,4,6,"",6,8,4,2,1,10,7,0.5,25.000000000000004,"","","","",0.68181818181818177,0.3,0.41666666666666669,0.3125,"",0.41666666666666669,0.375,0.9375,2.5,7.5,1.5,"",39.94015151515152,{"$f":"IF(AL13<>\"\",ROUND(1/AL13,1),IF(AL40=\"\",\"\",ROUND(AL40,1)))","v":15.7},6,null,null,7,7,"2546x684210","Apres","C W McDonald","M J Walker ",55,2,{"$nulls":5},3.1,9]
[null,5.0999999999999996,8,3321163214,"","","","","",3,3,2,1,1,6,3,2,1,4,8,0.3,45.8,"","","","","",0.5,0.55555555555555558,0.9375,2.1428571428571428,2.5,0.5,1.25,2.5,7.5,3.75,0.33333333333333331,67.935912698412693,{"$f":"IF(AL14<>\"\",ROUND(1/AL14,1),IF(AL41=\"\",\"\",ROUND(AL41,1)))","v":3},1,null,null,8,8,3321163214,"Clang And Bang","D K Weir","Thomas Sadler (3kg) ","55 (52)",8,{"$nulls":5},3.4,4]
[null,null,9,"91758x41141","","","","",9,1,7,5,8,"",4,1,1,4,1,9,0.2,38,"","","","",0.15151515151515149,1.5,0.23809523809523811,0.375,0.26785714285714285,"",0.75,3.75,5,1.875,15,0.20833333333333334,66.907467532467535,{"$f":"IF(AL15<>\"\",ROUND(1/AL15,1),IF(AL42=\"\",\"\",ROUND(AL42,1)))","v":4.8},2,null,null,9,9,"91758x41141","Magic Pulse","Ms S Jaensch","Ms H Mc Kechnie ",55,11,{"$nulls":5},3,11]
[null,null,10,"0x5x35022364","","","",10,"",5,"",3,5,10,2,2,3,6,4,10,0.1,21,"","","",0.125,"",0.3,"",0.625,0.42857142857142855,0.25,1.5,1.875,1.6666666666666667,1.25,3.75,"",32.770238095238099,{"$f":"IF(AL16<>\"\",ROUND(1/AL16,1),IF(AL43=\"\",\"\",ROUND(AL43,1)))","v":19.2},8,null,null,10,10,"0x5x35022364","Eleuther","R J Besanko","P Mertens ",55,10,{"$nulls":5},4.4000000000000004,9]
[null,null,11,"","","","","","","","","","","","","","","","",11,0,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL17<>\"\",ROUND(1/AL17,1),IF(AL44=\"\",\"\",ROUND(AL44,1)))","v":""},"",null,null,11,11,null,"Boredom","S J Webb","G Boss ",55,3,{"$nulls":5},2.4,11]
[null,null,12,"","","","","","","","","","","","","","","","",12,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL18<>\"\",ROUND(1/AL18,1),IF(AL45=\"\",\"\",ROUND(AL45,1)))","v":""},"",null,null,12]
[null,null,13,"","","","","","","","","","","","","","","","",13,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL19<>\"\",ROUND(1/AL19,1),IF(AL46=\"\",\"\",ROUND(AL46,1)))","v":""},"",null,null,13]
[null,null,14,"","","","","","","","","","","","","","","","",14,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL20<>\"\",ROUND(1/AL20,1),IF(AL47=\"\",\"\",ROUND(AL47,1)))","v":""},"",null,null,14]
[null,null,15,"","","","","","","","","","","","","","","","",15,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL21<>\"\",ROUND(1/AL21,1),IF(AL48=\"\",\"\",ROUND(AL48,1)))","v":""},"",null,null,15]
[null,null,16,"","","","","","","","","","","","","","","","",16,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL22<>\"\",ROUND(1/AL22,1),IF(AL49=\"\",\"\",ROUND(AL49,1)))","v":""},"",null,null,16]
[null,null,17,"",{"$f":"IF(OR(E$6=\"\",$D23=\"\"),\"\",IF(LEN($D23)>=E$6,IF(LEFT(RIGHT($D23,E$6),1)=\"x\",\"\",IF(LEFT(RIGHT($D23,E$6),1)=\"0\",10,1*LEFT(RIGHT($D23,E$6),1))),\"\"))","v":""},"","","","","","","","","","","","","","",17,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL23<>\"\",ROUND(1/AL23,1),IF(AL50=\"\",\"\",ROUND(AL50,1)))","v":""},"",null,null,17]
[null,null,18,"","","","","","","","","","","","","","","","",18,null,"",{"$f":"IF(E24=\"\",\"\",$U$32/W$6/E24)","v":""},"","","","","","","","","","","","","","","","",{"$f":"IF(AL24<>\"\",ROUND(1/AL24,1),IF(AL51=\"\",\"\",ROUND(AL51,1)))","v":""},"",null,null,18]
[null,null,19,"","","","","","","","","","","","","","","","",19,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL25<>\"\",ROUND(1/AL25,1),IF(AL52=\"\",\"\",ROUND(AL52,1)))","v":""},"",null,null,19]
[null,null,20,"","","","","","","","","","","","","","","","",20,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL26<>\"\",ROUND(1/AL26,1),IF(AL53=\"\",\"\",ROUND(AL53,1)))","v":""},"",null,null,20]
[null,null,21,"","","","","","","","","","","","","","","","",21,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL27<>\"\",ROUND(1/AL27,1),IF(AL54=\"\",\"\",ROUND(AL54,1)))","v":""},"",null,null,21]
[null,null,22,"","","","","","","","","","","","","","","","",22,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL28<>\"\",ROUND(1/AL28,1),IF(AL55=\"\",\"\",ROUND(AL55,1)))","v":""},"",null,null,22]
[null,null,23,"","","","","","","","","","","","","","","","",23,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL29<>\"\",ROUND(1/AL29,1),IF(AL56=\"\",\"\",ROUND(AL56,1)))","v":""},"",null,null,23]
[null,null,24,"","","","","","","","","","","","","","","","",24,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL30<>\"\",ROUND(1/AL30,1),IF(AL57=\"\",\"\",ROUND(AL57,1)))","v":""},"",null,null,24]
[{"$nulls":20},"weight",{"$nulls":16},{"$f":"SUM(AL7:AL30)","v":0.75}]
[{"$nulls":20},15,{"$nulls":16},{"$f":"SUM(U7:U10)-4+U11*COUNT(AM7:AM30)","v":24}]
[{"$nulls":18},">",{"$nulls":17},{"$f":"(1-AL31)/AK59","v":1.5927387660204695E-3},null,"<"]
[{"$nulls":36},{"$f":"IF(AO7>4,AM7,\"\")","v":38.916287878787884},{"$f":"IF(AK34=\"\",\"\",1/(AK$33*AK34))","v":16.133330923157573}]
[{"$nulls":36},{"$f":"IF(AO8>4,AM8,\"\")","v":""},{"$f":"IF(AK35=\"\",\"\",1/(AK$33*AK35))","v":""}]
[{"$nulls":36},{"$f":"IF(AO9>4,AM9,\"\")","v":41.885064935064932},{"$f":"IF(AK36=\"\",\"\",1/(AK$33*AK36))","v":14.989814427235945}]
[{"$nulls":36},{"$f":"IF(AO10>4,AM10,\"\")","v":25.597943722943725},{"$f":"IF(AK37=\"\",\"\",1/(AK$33*AK37))","v":24.527335376810065}]
[{"$nulls":36},{"$f":"IF(AO11>4,AM11,\"\")","v":""},{"$f":"IF(AK38=\"\",\"\",1/(AK$33*AK38))","v":""}]
[{"$nulls":36},{"$f":"IF(AO12>4,AM12,\"\")","v":16.768939393939394},{"$f":"IF(AK39=\"\",\"\",1/(AK$33*AK39))","v":37.441208170641197}]
[{"$nulls":36},{"$f":"IF(AO13>4,AM13,\"\")","v":39.94015151515152},{"$f":"IF(AK40=\"\",\"\",1/(AK$33*AK40))","v":15.719753852490335}]
[{"$nulls":36},{"$f":"IF(AO14>4,AM14,\"\")","v":""},{"$f":"IF(AK41=\"\",\"\",1/(AK$33*AK41))","v":""}]
[{"$nulls":36},{"$f":"IF(AO15>4,AM15,\"\")","v":""},{"$f":"IF(AK42=\"\",\"\",1/(AK$33*AK42))","v":""}]
[{"$nulls":36},{"$f":"IF(AO16>4,AM16,\"\")","v":32.770238095238099},{"$f":"IF(AK43=\"\",\"\",1/(AK$33*AK43))","v":19.159133016509411}]
[{"$nulls":36},{"$f":"IF(AO17>4,AM17,\"\")","v":""},{"$f":"IF(AK44=\"\",\"\",1/(AK$33*AK44))","v":""}]
[{"$nulls":36},{"$f":"IF(AO18>4,AM18,\"\")","v":""},{"$f":"IF(AK45=\"\",\"\",1/(AK$33*AK45))","v":""}]
[{"$nulls":36},{"$f":"IF(AO19>4,AM19,\"\")","v":""},{"$f":"IF(AK46=\"\",\"\",1/(AK$33*AK46))","v":""}]
[{"$nulls":36},{"$f":"IF(AO20>4,AM20,\"\")","v":""},{"$f":"IF(AK47=\"\",\"\",1/(AK$33*AK47))","v":""}]
[{"$nulls":36},{"$f":"IF(AO21>4,AM21,\"\")","v":""},{"$f":"IF(AK48=\"\",\"\",1/(AK$33*AK48))","v":""}]
[{"$nulls":36},{"$f":"IF(AO22>4,AM22,\"\")","v":""},{"$f":"IF(AK49=\"\",\"\",1/(AK$33*AK49))","v":""}]
[{"$nulls":36},{"$f":"IF(AO23>4,AM23,\"\")","v":""},{"$f":"IF(AK50=\"\",\"\",1/(AK$33*AK50))","v":""}]
[{"$nulls":36},{"$f":"IF(AO24>4,AM24,\"\")","v":""},{"$f":"IF(AK51=\"\",\"\",1/(AK$33*AK51))","v":""}]
[{"$nulls":36},{"$f":"IF(AO25>4,AM25,\"\")","v":""},{"$f":"IF(AK52=\"\",\"\",1/(AK$33*AK52))","v":""}]
[{"$nulls":36},{"$f":"IF(AO26>4,AM26,\"\")","v":""},{"$f":"IF(AK53=\"\",\"\",1/(AK$33*AK53))","v":""}]
[{"$nulls":36},{"$f":"IF(AO27>4,AM27,\"\")","v":""},{"$f":"IF(AK54=\"\",\"\",1/(AK$33*AK54))","v":""}]
[{"$nulls":36},{"$f":"IF(AO28>4,AM28,\"\")","v":""},{"$f":"IF(AK55=\"\",\"\",1/(AK$33*AK55))","v":""}]
[{"$nulls":36},{"$f":"IF(AO29>4,AM29,\"\")","v":""},{"$f":"IF(AK56=\"\",\"\",1/(AK$33*AK56))","v":""}]
[{"$nulls":36},{"$f":"IF(AO30>4,AM30,\"\")","v":""},{"$f":"IF(AK57=\"\",\"\",1/(AK$33*AK57))","v":""}]
[{"$nulls":36},{"$f":"IF(AO31>4,AM31,\"\")","v":""},{"$f":"IF(AK58=\"\",\"\",1/(AK$33*AK58))","v":""}]
[{"$nulls":36},{"$f":"SUM(AK35:AK58)","v":156.96233766233769}]

{"sheet":"Sheet5","index":4,"n_rows":59,"n_cols":58,"rows_kept":59,"cut":false,"hidden":false,"merged":[[4,19,4,37],[4,38,4,40],[2,1,2,3],[1,1,1,3],[3,1,3,3]]}
[null,"HELP"]
[null,"FORM Analysis v2.0"]
[null,"02-11-2012",{"$nulls":16},">",{"$nulls":19},"<"]
[null,"Moonee Valley",{"$nulls":43},"FORM"]
[null,"Result",{"$f":"\"F \"&COUNT(AM7:AM30)","v":"F 12"},"Race 5",{"$nulls":15},"Calculations -- hidden for cosmetic reasons",{"$nulls":18},{"$f":"B4&\" \"&D5","v":"Moonee Valley Race 5"},{"$nulls":5},"v","delete if scratched"]
[null,"3.6.11","TAB","Form",15,14,13,12,11,10,9,8,7,6,5,4,3,2,1,"Finish Pos","Points","score",{"$f":"E6","v":15},{"$f":"F6","v":14},13,12,11,10,9,8,7,6,{"$f":"O6","v":5},{"$f":"P6","v":4},{"$f":"Q6","v":3},{"$f":"R6","v":2},{"$f":"S6","v":1},"Top 4","Analysis","BM Price","Rank",null,null,">","No","Last 10","Horse","Trainer","Jockey","Wt","Bar",{"$nulls":5},"API","PP"]
[null,null,1,{"$f":"IF(AT7=\"\",\"\",AT7)","v":""},{"$f":"IF(OR(E$6=\"\",$D7=\"\"),\"\",IF(LEN($D7)>=E$6,IF(LEFT(RIGHT($D7,E$6),1)=\"x\",\"\",IF(LEFT(RIGHT($D7,E$6),1)=\"0\",10,1*LEFT(RIGHT($D7,E$6),1))),\"\"))","v":""},"","","","","","","","","","","","","","",1,8,{"$f":"IF(D7=\"\",\"\",VLOOKUP(IF(E7=\"\",11,E7),T$7:U$17,2)+VLOOKUP(IF(F7=\"\",11,F7),T$7:U$17,2)+VLOOKUP(IF(G7=\"\",11,G7),T$7:U$17,2)+VLOOKUP(IF(H7=\"\",11,H7),T$7:U$17,2)+VLOOKUP(IF(I7=\"\",11,I7),T$7:U$17,2)+VLOOKUP(IF(J7=\"\",11,J7),T$7:U$17,2)+VLOOKUP(IF(K7=\"\",11,K7),T$7:U$17,2)+VLOOKUP(IF(L7=\"\",11,L7),T$7:U$17,2)+VLOOKUP(IF(M7=\"\",11,M7),T$7:U$17,2)+VLOOKUP(IF(N7=\"\",11,N7),T$7:U$17,2)+VLOOKUP(IF(O7=\"\",11,O7),T$7:U$17,2)+VLOOKUP(IF(P7=\"\",11,P7),T$7:U$17,2)+VLOOKUP(IF(Q7=\"\",11,Q7),T$7:U$17,2)+VLOOKUP(IF(R7=\"\",11,R7),T$7:U$17,2)+VLOOKUP(IF(S7=\"\",11,S7),T$7:U$17,2))","v":""},{"$f":"IF(E7=\"\",\"\",$U$32/W$6/E7)","v":""},"","","","","","","","","","","","","","",{"$f":"IF(AO7>4,\"\",1/(AL$32/VLOOKUP(AO7,T$7:U$11,2)))","v":""},{"$f":"IF(V7=\"\",\"\",SUM(W7:AK7)+V7)","v":""},{"$f":"IF(AL7<>\"\",ROUND(1/AL7,1),IF(AL34=\"\",\"\",ROUND(AL34,1)))","v":""},{"$f":"IF(AM7=\"\",\"\",RANK(AM7,AM$7:AM$30))","v":""},null,null,1,1,null,"Spirited Addition","D A Hayes","Thomas Sadler (3kg) ","60 (57)",14,{"$nulls":5},7,21]
[null,null,2,{"$f":"IF(AT8=\"\",\"\",AT8)","v":3519954652},"","","","","",3,5,1,9,9,5,4,6,5,2,2,5,{"$f":"IF(D8=\"\",\"\",VLOOKUP(IF(E8=\"\",24,E8),T$7:U$17,2)+VLOOKUP(IF(F8=\"\",24,F8),T$7:U$17,2)+VLOOKUP(IF(G8=\"\",24,G8),T$7:U$17,2)+VLOOKUP(IF(H8=\"\",24,H8),T$7:U$17,2)+VLOOKUP(IF(I8=\"\",24,I8),T$7:U$17,2)+VLOOKUP(IF(J8=\"\",24,J8),T$7:U$17,2)+VLOOKUP(IF(K8=\"\",24,K8),T$7:U$17,2)+VLOOKUP(IF(L8=\"\",24,L8),T$7:U$17,2)+VLOOKUP(IF(M8=\"\",24,M8),T$7:U$17,2)+VLOOKUP(IF(N8=\"\",24,N8),T$7:U$17,2)+VLOOKUP(IF(O8=\"\",24,O8),T$7:U$17,2)+VLOOKUP(IF(P8=\"\",24,P8),T$7:U$17,2)+VLOOKUP(IF(Q8=\"\",24,Q8),T$7:U$17,2)+VLOOKUP(IF(R8=\"\",24,R8),T$7:U$17,2)+VLOOKUP(IF(S8=\"\",24,S8),T$7:U$17,2))","v":22.2},"","","","","",0.5,0.33333333333333337,1.875,0.23809523809523808,0.27777777777777779,0.6,0.9375,0.83333333333333337,1.5,7.5,{"$f":"IF(AO8>4,\"\",1/(AL$32/VLOOKUP(AO8,T$7:U$11,2)))","v":""},{"$f":"IF(V8=\"\",\"\",SUM(W8:AK8)+V8)","v":36.795039682539681},{"$f":"IF(AL8<>\"\",ROUND(1/AL8,1),IF(AL35=\"\",\"\",ROUND(AL35,1)))","v":22.8},{"$f":"IF(AM8=\"\",\"\",RANK(AM8,AM$7:AM$30))","v":7},null,null,2,2,3519954652,"Locke's Choice","R T Cleaver","B Knobel (2kg) ","59.5 (57.5)",12,{"$nulls":5},3.2,21]
[null,4.4000000000000004,3,"1202x4469x1x1","","",1,2,10,2,"",4,4,6,9,"",1,"",1,3,3,39.1,"","",1.1538461538461537,0.625,0.13636363636363635,0.75,"",0.46875,0.5357142857142857,0.41666666666666669,0.33333333333333331,"",5,"",15,0.30769230769230771,63.519674075924073,{"$f":"IF(AL9<>\"\",ROUND(1/AL9,1),IF(AL36=\"\",\"\",ROUND(AL36,1)))","v":3.3},1,null,null,3,3,"1202x4469x1x1","Paaratte Pat","B J McCarthy","J Mott ",59,13,{"$nulls":5},6.7,4]
[null,null,4,"76x46734618","","","","",7,6,"",4,6,7,3,4,6,1,8,4,2,18.7,"","","","",0.19480519480519479,0.25,"",0.46875,0.35714285714285715,0.35714285714285715,1,0.9375,0.83333333333333337,7.5,1.875,"",32.473674242424238,{"$f":"IF(AL10<>\"\",ROUND(1/AL10,1),IF(AL37=\"\",\"\",ROUND(AL37,1)))","v":25.8},10,null,null,4,4,"76x46734618","Stratumsphere","L J Corstens","C Newitt ",59,4,{"$nulls":5},4.4000000000000004,8]
[null,null,5,"913214x","","","","","","","","",9,1,3,2,1,4,"",5,1,26.2,"","","","","","","","",0.23809523809523808,2.5,1,1.875,5,1.875,"","",38.688095238095237,{"$f":"IF(AL11<>\"\",ROUND(1/AL11,1),IF(AL38=\"\",\"\",ROUND(AL38,1)))","v":21.7},6,null,null,5,5,"913214x","Cyclone Andy","P Trotter","S W Arnold ",58,9,{"$nulls":5},15.4,5.5]
[null,null,6,"252781226x1","","","","",2,5,2,7,8,1,2,2,6,"",1,6,0.8,38.6,"","","","",0.68181818181818177,0.3,0.83333333333333337,0.26785714285714285,0.26785714285714285,2.5,1.5,1.875,0.83333333333333337,"",15,0.19230769230769229,62.659199134199135,{"$f":"IF(AL12<>\"\",ROUND(1/AL12,1),IF(AL39=\"\",\"\",ROUND(AL39,1)))","v":5.2},2,null,null,6,6,"252781226x1","Peninsula Dane","M P Hyland","D Oliver ",58,8,{"$nulls":5},5,8]
[null,null,7,"43x131","","","","","","","","","",4,3,"",1,3,1,7,0.5,24,"","","","","","","","","",0.625,1,"",5,2.5,15,0.11538461538461539,48.125,{"$f":"IF(AL13<>\"\",ROUND(1/AL13,1),IF(AL40=\"\",\"\",ROUND(AL40,1)))","v":8.6999999999999993},3,null,null,7,7,"43x131","Henwood","J D Sadler","M Rodd ",57.5,10,{"$nulls":5},7.4,5]
[null,null,8,"0x265763701","","","","",10,"",2,6,5,7,6,3,7,10,1,8,0.3,19.799999999999997,"","","","",0.13636363636363635,"",0.83333333333333337,0.3125,0.42857142857142855,0.35714285714285715,0.5,1.25,0.7142857142857143,0.75,15,"",40.082196969696966,{"$f":"IF(AL14<>\"\",ROUND(1/AL14,1),IF(AL41=\"\",\"\",ROUND(AL41,1)))","v":20.9},5,null,null,8,8,"0x265763701","Shiny And New","D K Weir","M Zahra ",57.5,1,{"$nulls":5},6.8,11]
[null,null,9,"4333314469x","","","","",4,3,3,3,3,1,4,4,6,9,"",9,0.2,27,"","","","",0.34090909090909088,0.5,0.55555555555555558,0.625,0.7142857142857143,2.5,0.75,0.9375,0.83333333333333337,0.83333333333333337,"","",35.58991702741703,{"$f":"IF(AL15<>\"\",ROUND(1/AL15,1),IF(AL42=\"\",\"\",ROUND(AL42,1)))","v":23.6},8,null,null,9,9,"4333314469x","Thebarwonprince","Ms G Johnstone","Nicholas Hall ",57.5,11,{"$nulls":5},2.2999999999999998,26]
[null,null,10,"773606x6503","","","","",7,7,3,6,10,6,"",6,5,10,3,10,0.1,10.599999999999998,"","","","",0.19480519480519479,0.21428571428571427,0.55555555555555558,0.3125,0.21428571428571427,0.41666666666666669,"",0.625,1,0.75,5,"",19.883098845598845,{"$f":"IF(AL16<>\"\",ROUND(1/AL16,1),IF(AL43=\"\",\"\",ROUND(AL43,1)))","v":42.2},12,null,null,10,10,"773606x6503","La Bella Roo","Peter Boynton","L Currie ",57,6,{"$nulls":5},4.0999999999999996,26]
[null,null,11,"30186x1","","","","","","","","",3,10,1,8,6,"",1,11,0,20.200000000000003,"","","","","","","","",0.7142857142857143,0.25,3,0.46875,0.83333333333333337,"",15,7.6923076923076927E-2,40.466369047619054,{"$f":"IF(AL17<>\"\",ROUND(1/AL17,1),IF(AL44=\"\",\"\",ROUND(AL44,1)))","v":13},4,null,null,11,11,"30186x1","Arkiboum","B F Cavanough","J Bowman ",56,3,{"$nulls":5},6.4,11]
[null,null,12,"90x18183368x","","","",9,10,"",1,8,1,8,3,3,6,8,"",12,null,24.000000000000004,"","","",0.1388888888888889,0.13636363636363635,"",1.6666666666666667,0.234375,2.1428571428571428,0.3125,1,1.25,0.83333333333333337,0.9375,"","",32.652484668109672,{"$f":"IF(AL18<>\"\",ROUND(1/AL18,1),IF(AL45=\"\",\"\",ROUND(AL45,1)))","v":25.7},9,null,null,12,12,"90x18183368x","Suvarna","J T O'Keefe","D Gauci ",55.5,15,{"$nulls":5},3,31]
[null,null,13,"14x8793850x0","","","",1,4,"",8,7,9,3,8,5,10,"",10,13,null,15.5,"","","",1.25,0.34090909090909088,"",0.20833333333333334,0.26785714285714285,0.23809523809523808,0.83333333333333337,0.375,0.75,0.5,"",1.5,"",21.763528138528137,{"$f":"IF(AL19<>\"\",ROUND(1/AL19,1),IF(AL46=\"\",\"\",ROUND(AL46,1)))","v":38.5},11,null,null,13,13,"14x8793850x0","Rockshaft","R W Smerdon",null,57,2,{"$nulls":5},8.6,51]
[null,null,14,"","","","","","","","","","","","","","","","",14,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL20<>\"\",ROUND(1/AL20,1),IF(AL47=\"\",\"\",ROUND(AL47,1)))","v":""},"",null,null,14,14,null,"The Counterfeiter","M W Laurie","J Noonan (1.5kg) ","57 (55.5)",5,{"$nulls":5},4.8,26]
[null,null,15,"","","","","","","","","","","","","","","","",15,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL21<>\"\",ROUND(1/AL21,1),IF(AL48=\"\",\"\",ROUND(AL48,1)))","v":""},"",null,null,15,15,null,"Grippet","P A Healey","P Mertens ",57,16,{"$nulls":5},5.0999999999999996,13]
[null,null,16,"","","","","","","","","","","","","","","","",16,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL22<>\"\",ROUND(1/AL22,1),IF(AL49=\"\",\"\",ROUND(AL49,1)))","v":""},"",null,null,16,16,null,"Raks McLaren","D R Jolly",null,55,7,{"$nulls":5},6.7,11]
[null,null,17,"",{"$f":"IF(OR(E$6=\"\",$D23=\"\"),\"\",IF(LEN($D23)>=E$6,IF(LEFT(RIGHT($D23,E$6),1)=\"x\",\"\",IF(LEFT(RIGHT($D23,E$6),1)=\"0\",10,1*LEFT(RIGHT($D23,E$6),1))),\"\"))","v":""},"","","","","","","","","","","","","","",17,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL23<>\"\",ROUND(1/AL23,1),IF(AL50=\"\",\"\",ROUND(AL50,1)))","v":""},"",null,null,17]
[null,null,18,"","","","","","","","","","","","","","","","",18,null,"",{"$f":"IF(E24=\"\",\"\",$U$32/W$6/E24)","v":""},"","","","","","","","","","","","","","","","",{"$f":"IF(AL24<>\"\",ROUND(1/AL24,1),IF(AL51=\"\",\"\",ROUND(AL51,1)))","v":""},"",null,null,18]
[null,null,19,"","","","","","","","","","","","","","","","",19,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL25<>\"\",ROUND(1/AL25,1),IF(AL52=\"\",\"\",ROUND(AL52,1)))","v":""},"",null,null,19]
[null,null,20,"","","","","","","","","","","","","","","","",20,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL26<>\"\",ROUND(1/AL26,1),IF(AL53=\"\",\"\",ROUND(AL53,1)))","v":""},"",null,null,20]
[null,null,21,"","","","","","","","","","","","","","","","",21,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL27<>\"\",ROUND(1/AL27,1),IF(AL54=\"\",\"\",ROUND(AL54,1)))","v":""},"",null,null,21]
[null,null,22,"","","","","","","","","","","","","","","","",22,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL28<>\"\",ROUND(1/AL28,1),IF(AL55=\"\",\"\",ROUND(AL55,1)))","v":""},"",null,null,22]
[null,null,23,"","","","","","","","","","","","","","","","",23,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL29<>\"\",ROUND(1/AL29,1),IF(AL56=\"\",\"\",ROUND(AL56,1)))","v":""},"",null,null,23]
[null,null,24,"","","","","","","","","","","","","","","","",24,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL30<>\"\",ROUND(1/AL30,1),IF(AL57=\"\",\"\",ROUND(AL57,1)))","v":""},"",null,null,24]
[{"$nulls":20},"weight",{"$nulls":16},{"$f":"SUM(AL7:AL30)","v":0.69230769230769229}]
[{"$nulls":20},15,{"$nulls":16},{"$f":"SUM(U7:U10)-4+U11*COUNT(AM7:AM30)","v":26}]
[{"$nulls":18},">",{"$nulls":17},{"$f":"(1-AL31)/AK59","v":1.1929385958997876E-3},null,"<"]
[{"$nulls":36},{"$f":"IF(AO7>4,AM7,\"\")","v":""},{"$f":"IF(AK34=\"\",\"\",1/(AK$33*AK34))","v":""}]
[{"$nulls":36},{"$f":"IF(AO8>4,AM8,\"\")","v":36.795039682539681},{"$f":"IF(AK35=\"\",\"\",1/(AK$33*AK35))","v":22.782041285258174}]
[{"$nulls":36},{"$f":"IF(AO9>4,AM9,\"\")","v":""},{"$f":"IF(AK36=\"\",\"\",1/(AK$33*AK36))","v":""}]
[{"$nulls":36},{"$f":"IF(AO10>4,AM10,\"\")","v":32.473674242424238},{"$f":"IF(AK37=\"\",\"\",1/(AK$33*AK37))","v":25.813713190643664}]
[{"$nulls":36},{"$f":"IF(AO11>4,AM11,\"\")","v":38.688095238095237},{"$f":"IF(AK38=\"\",\"\",1/(AK$33*AK38))","v":21.667288295829863}]
[{"$nulls":36},{"$f":"IF(AO12>4,AM12,\"\")","v":""},{"$f":"IF(AK39=\"\",\"\",1/(AK$33*AK39))","v":""}]
[{"$nulls":36},{"$f":"IF(AO13>4,AM13,\"\")","v":""},{"$f":"IF(AK40=\"\",\"\",1/(AK$33*AK40))","v":""}]
[{"$nulls":36},{"$f":"IF(AO14>4,AM14,\"\")","v":40.082196969696966},{"$f":"IF(AK41=\"\",\"\",1/(AK$33*AK41))","v":20.913676807039288}]
[{"$nulls":36},{"$f":"IF(AO15>4,AM15,\"\")","v":35.58991702741703},{"$f":"IF(AK42=\"\",\"\",1/(AK$33*AK42))","v":23.553471970574297}]
[{"$nulls":36},{"$f":"IF(AO16>4,AM16,\"\")","v":19.883098845598845},{"$f":"IF(AK43=\"\",\"\",1/(AK$33*AK43))","v":42.159731722396145}]
[{"$nulls":36},{"$f":"IF(AO17>4,AM17,\"\")","v":""},{"$f":"IF(AK44=\"\",\"\",1/(AK$33*AK44))","v":""}]
[{"$nulls":36},{"$f":"IF(AO18>4,AM18,\"\")","v":32.652484668109672},{"$f":"IF(AK45=\"\",\"\",1/(AK$33*AK45))","v":25.672353012664658}]
[{"$nulls":36},{"$f":"IF(AO19>4,AM19,\"\")","v":21.763528138528137},{"$f":"IF(AK46=\"\",\"\",1/(AK$33*AK46))","v":38.517013776656142}]
[{"$nulls":36},{"$f":"IF(AO20>4,AM20,\"\")","v":""},{"$f":"IF(AK47=\"\",\"\",1/(AK$33*AK47))","v":""}]
[{"$nulls":36},{"$f":"IF(AO21>4,AM21,\"\")","v":""},{"$f":"IF(AK48=\"\",\"\",1/(AK$33*AK48))","v":""}]
[{"$nulls":36},{"$f":"IF(AO22>4,AM22,\"\")","v":""},{"$f":"IF(AK49=\"\",\"\",1/(AK$33*AK49))","v":""}]
[{"$nulls":36},{"$f":"IF(AO23>4,AM23,\"\")","v":""},{"$f":"IF(AK50=\"\",\"\",1/(AK$33*AK50))","v":""}]
[{"$nulls":36},{"$f":"IF(AO24>4,AM24,\"\")","v":""},{"$f":"IF(AK51=\"\",\"\",1/(AK$33*AK51))","v":""}]
[{"$nulls":36},{"$f":"IF(AO25>4,AM25,\"\")","v":""},{"$f":"IF(AK52=\"\",\"\",1/(AK$33*AK52))","v":""}]
[{"$nulls":36},{"$f":"IF(AO26>4,AM26,\"\")","v":""},{"$f":"IF(AK53=\"\",\"\",1/(AK$33*AK53))","v":""}]
[{"$nulls":36},{"$f":"IF(AO27>4,AM27,\"\")","v":""},{"$f":"IF(AK54=\"\",\"\",1/(AK$33*AK54))","v":""}]
[{"$nulls":36},{"$f":"IF(AO28>4,AM28,\"\")","v":""},{"$f":"IF(AK55=\"\",\"\",1/(AK$33*AK55))","v":""}]
[{"$nulls":36},{"$f":"IF(AO29>4,AM29,\"\")","v":""},{"$f":"IF(AK56=\"\",\"\",1/(AK$33*AK56))","v":""}]
[{"$nulls":36},{"$f":"IF(AO30>4,AM30,\"\")","v":""},{"$f":"IF(AK57=\"\",\"\",1/(AK$33*AK57))","v":""}]
[{"$nulls":36},{"$f":"IF(AO31>4,AM31,\"\")","v":""},{"$f":"IF(AK58=\"\",\"\",1/(AK$33*AK58))","v":""}]
[{"$nulls":36},{"$f":"SUM(AK35:AK58)","v":257.92803481240981}]

{"sheet":"Sheet6","index":5,"n_rows":59,"n_cols":58,"rows_kept":59,"cut":false,"hidden":false,"merged":[[4,19,4,37],[4,38,4,40],[2,1,2,3],[1,1,1,3],[3,1,3,3]]}
[null,"HELP"]
[null,"FORM Analysis v2.0"]
[null,"02-11-2012",{"$nulls":16},">",{"$nulls":19},"<"]
[null,"Moonee Valley",{"$nulls":43},"FORM"]
[null,"Result",{"$f":"\"F \"&COUNT(AM7:AM30)","v":"F 9"},"Race6",{"$nulls":15},"Calculations -- hidden for cosmetic reasons",{"$nulls":18},{"$f":"B4&\" \"&D5","v":"Moonee Valley Race6"},{"$nulls":5},"v","delete if scratched"]
[null,"5.8.9","TAB","Form",15,14,13,12,11,10,9,8,7,6,5,4,3,2,1,"Finish Pos","Points","score",{"$f":"E6","v":15},{"$f":"F6","v":14},13,12,11,10,9,8,7,6,{"$f":"O6","v":5},{"$f":"P6","v":4},{"$f":"Q6","v":3},{"$f":"R6","v":2},{"$f":"S6","v":1},"Top 4","Analysis","BM Price","Rank",null,null,">","No","Last 10","Horse","Trainer","Jockey","Wt","Bar",{"$nulls":5},"API","PP"]
[null,null,1,{"$f":"IF(AT7=\"\",\"\",AT7)","v":"2189x838x121"},{"$f":"IF(OR(E$6=\"\",$D7=\"\"),\"\",IF(LEN($D7)>=E$6,IF(LEFT(RIGHT($D7,E$6),1)=\"x\",\"\",IF(LEFT(RIGHT($D7,E$6),1)=\"0\",10,1*LEFT(RIGHT($D7,E$6),1))),\"\"))","v":""},"","",2,1,8,9,"",8,3,8,"",1,2,1,1,8,{"$f":"IF(D7=\"\",\"\",VLOOKUP(IF(E7=\"\",11,E7),T$7:U$17,2)+VLOOKUP(IF(F7=\"\",11,F7),T$7:U$17,2)+VLOOKUP(IF(G7=\"\",11,G7),T$7:U$17,2)+VLOOKUP(IF(H7=\"\",11,H7),T$7:U$17,2)+VLOOKUP(IF(I7=\"\",11,I7),T$7:U$17,2)+VLOOKUP(IF(J7=\"\",11,J7),T$7:U$17,2)+VLOOKUP(IF(K7=\"\",11,K7),T$7:U$17,2)+VLOOKUP(IF(L7=\"\",11,L7),T$7:U$17,2)+VLOOKUP(IF(M7=\"\",11,M7),T$7:U$17,2)+VLOOKUP(IF(N7=\"\",11,N7),T$7:U$17,2)+VLOOKUP(IF(O7=\"\",11,O7),T$7:U$17,2)+VLOOKUP(IF(P7=\"\",11,P7),T$7:U$17,2)+VLOOKUP(IF(Q7=\"\",11,Q7),T$7:U$17,2)+VLOOKUP(IF(R7=\"\",11,R7),T$7:U$17,2)+VLOOKUP(IF(S7=\"\",11,S7),T$7:U$17,2))","v":38.1},{"$f":"IF(E7=\"\",\"\",$U$32/W$6/E7)","v":""},"","",0.625,1.3636363636363635,0.1875,0.1851851851851852,"",0.26785714285714285,0.83333333333333337,0.375,"",5,3.75,15,{"$f":"IF(AO7>4,\"\",1/(AL$32/VLOOKUP(AO7,T$7:U$11,2)))","v":0.34782608695652173},{"$f":"IF(V7=\"\",\"\",SUM(W7:AK7)+V7)","v":65.687512025012026},{"$f":"IF(AL7<>\"\",ROUND(1/AL7,1),IF(AL34=\"\",\"\",ROUND(AL34,1)))","v":2.9},{"$f":"IF(AM7=\"\",\"\",RANK(AM7,AM$7:AM$30))","v":1},null,null,1,1,"2189x838x121","Sabres","Anthony Freedman","S W Arnold ",60,3,{"$nulls":5},8.5,3.5]
[null,null,2,{"$f":"IF(AT8=\"\",\"\",AT8)","v":"212117x5253x"},"","","",2,1,2,1,1,7,"",5,2,5,3,"",2,5,{"$f":"IF(D8=\"\",\"\",VLOOKUP(IF(E8=\"\",24,E8),T$7:U$17,2)+VLOOKUP(IF(F8=\"\",24,F8),T$7:U$17,2)+VLOOKUP(IF(G8=\"\",24,G8),T$7:U$17,2)+VLOOKUP(IF(H8=\"\",24,H8),T$7:U$17,2)+VLOOKUP(IF(I8=\"\",24,I8),T$7:U$17,2)+VLOOKUP(IF(J8=\"\",24,J8),T$7:U$17,2)+VLOOKUP(IF(K8=\"\",24,K8),T$7:U$17,2)+VLOOKUP(IF(L8=\"\",24,L8),T$7:U$17,2)+VLOOKUP(IF(M8=\"\",24,M8),T$7:U$17,2)+VLOOKUP(IF(N8=\"\",24,N8),T$7:U$17,2)+VLOOKUP(IF(O8=\"\",24,O8),T$7:U$17,2)+VLOOKUP(IF(P8=\"\",24,P8),T$7:U$17,2)+VLOOKUP(IF(Q8=\"\",24,Q8),T$7:U$17,2)+VLOOKUP(IF(R8=\"\",24,R8),T$7:U$17,2)+VLOOKUP(IF(S8=\"\",24,S8),T$7:U$17,2))","v":44.5},"","","",0.625,1.3636363636363635,0.75,1.6666666666666667,1.875,0.30612244897959184,"",0.6,1.875,1,2.5,"",{"$f":"IF(AO8>4,\"\",1/(AL$32/VLOOKUP(AO8,T$7:U$11,2)))","v":8.6956521739130432E-2},{"$f":"IF(V8=\"\",\"\",SUM(W8:AK8)+V8)","v":57.061425479282619},{"$f":"IF(AL8<>\"\",ROUND(1/AL8,1),IF(AL35=\"\",\"\",ROUND(AL35,1)))","v":11.5},{"$f":"IF(AM8=\"\",\"\",RANK(AM8,AM$7:AM$30))","v":4},null,null,2,2,"212117x5253x","Snitza","R G Hore-Lacy","C Newitt ",59.5,4,{"$nulls":5},6.9,15]
[null,null,3,"033x700900x0","","","",10,3,3,"",7,10,10,9,10,10,"",10,3,3,7.299999999999998,"","","",0.125,0.45454545454545453,0.5,"",0.26785714285714285,0.21428571428571427,0.25,0.33333333333333331,0.375,0.5,"",1.5,"",11.820021645021644,{"$f":"IF(AL9<>\"\",ROUND(1/AL9,1),IF(AL36=\"\",\"\",ROUND(AL36,1)))","v":66.400000000000006},9,null,null,3,3,"033x700900x0","Allanthus","B L Jenkins","B Wallace (3kg) ","59 (56)",10,{"$nulls":5},3.8,51]
[null,null,4,"213111080x","","","","","",2,1,3,1,1,1,10,8,10,"",4,2,40.5,"","","","","",0.75,1.6666666666666667,0.625,2.1428571428571428,2.5,3,0.375,0.625,0.75,"","",52.93452380952381,{"$f":"IF(AL10<>\"\",ROUND(1/AL10,1),IF(AL37=\"\",\"\",ROUND(AL37,1)))","v":14.8},5,null,null,4,4,"213111080x","Angelology","K T Myers","J Noonan (1.5kg) ","57 (55.5)",5,{"$nulls":5},1.8,7]
[null,13,5,5120646844,"","","","","",5,1,2,10,6,4,6,8,4,4,5,1,22,"","","","","",0.3,1.6666666666666667,0.9375,0.21428571428571427,0.41666666666666669,0.75,0.625,0.625,1.875,3.75,"",33.160119047619048,{"$f":"IF(AL11<>\"\",ROUND(1/AL11,1),IF(AL38=\"\",\"\",ROUND(AL38,1)))","v":23.7},7,null,null,5,5,5120646844,"Eight Cards","R T Cleaver","M J Walker ",57,6,{"$nulls":5},3.5,7]
[null,null,6,"","","","","","","","","","","","","","","","",6,0.8,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL12<>\"\",ROUND(1/AL12,1),IF(AL39=\"\",\"\",ROUND(AL39,1)))","v":""},"",null,null,6,6,null,"Grand Sunday","J D Sadler","M Rodd ",55,8,{"$nulls":5},2.1,7]
[null,null,7,"12x62313225","","","","",1,2,"",6,2,3,1,3,2,2,5,7,0.5,43.8,"","","","",1.3636363636363635,0.75,"",0.3125,1.0714285714285714,0.83333333333333337,3,1.25,2.5,3.75,3,0.21739130434782611,61.630898268398269,{"$f":"IF(AL13<>\"\",ROUND(1/AL13,1),IF(AL40=\"\",\"\",ROUND(AL40,1)))","v":4.5999999999999996},2,null,null,7,7,"12x62313225","Street Crier","M W Young","Dean Holland ",55,1,{"$nulls":5},3,3.8]
[null,null,8,"71978x33164","","","","",7,1,9,7,8,"",3,3,1,6,4,8,0.3,26.3,"","","","",0.19480519480519479,1.5,0.1851851851851852,0.26785714285714285,0.26785714285714285,"",1,1.25,5,1.25,3.75,"",40.965704665704664,{"$f":"IF(AL14<>\"\",ROUND(1/AL14,1),IF(AL41=\"\",\"\",ROUND(AL41,1)))","v":19.2},6,null,null,8,8,"71978x33164","Meteor Shower","Jackson Pallot","Ms R Williams (3kg) ","55 (52)",2,{"$nulls":5},2.5,15]
[null,null,9,"22122241x58","","","","",2,2,1,2,2,2,4,1,"",5,8,9,0.2,44.3,"","","","",0.68181818181818177,0.75,1.6666666666666667,0.9375,1.0714285714285714,1.25,0.75,3.75,"",1.5,1.875,0.13043478260869565,58.532413419913418,{"$f":"IF(AL15<>\"\",ROUND(1/AL15,1),IF(AL42=\"\",\"\",ROUND(AL42,1)))","v":7.7},3,null,null,9,9,"22122241x58","Northern Jet","L J Corstens","D Oliver ",55,9,{"$nulls":5},2.8,5.5]
[null,null,10,"6472302x355","","","","",6,4,7,2,3,10,2,"",3,5,5,10,0.1,21.4,"","","","",0.22727272727272727,0.375,0.23809523809523811,0.9375,0.7142857142857143,0.25,1.5,"",1.6666666666666667,1.5,3,"",31.808820346320346,{"$f":"IF(AL16<>\"\",ROUND(1/AL16,1),IF(AL43=\"\",\"\",ROUND(AL43,1)))","v":24.7},8,null,null,10,10,"6472302x355","Dangarway","Ms M Ballantine","L Currie ",55,7,{"$nulls":5},2.1,21]
[null,null,11,"","","","","","","","","","","","","","","","",11,0,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL17<>\"\",ROUND(1/AL17,1),IF(AL44=\"\",\"\",ROUND(AL44,1)))","v":""},"",null,null,11]
[null,null,12,"","","","","","","","","","","","","","","","",12,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL18<>\"\",ROUND(1/AL18,1),IF(AL45=\"\",\"\",ROUND(AL45,1)))","v":""},"",null,null,12]
[null,null,13,"","","","","","","","","","","","","","","","",13,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL19<>\"\",ROUND(1/AL19,1),IF(AL46=\"\",\"\",ROUND(AL46,1)))","v":""},"",null,null,13]
[null,null,14,"","","","","","","","","","","","","","","","",14,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL20<>\"\",ROUND(1/AL20,1),IF(AL47=\"\",\"\",ROUND(AL47,1)))","v":""},"",null,null,14]
[null,null,15,"","","","","","","","","","","","","","","","",15,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL21<>\"\",ROUND(1/AL21,1),IF(AL48=\"\",\"\",ROUND(AL48,1)))","v":""},"",null,null,15]
[null,null,16,"","","","","","","","","","","","","","","","",16,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL22<>\"\",ROUND(1/AL22,1),IF(AL49=\"\",\"\",ROUND(AL49,1)))","v":""},"",null,null,16]
[null,null,17,"",{"$f":"IF(OR(E$6=\"\",$D23=\"\"),\"\",IF(LEN($D23)>=E$6,IF(LEFT(RIGHT($D23,E$6),1)=\"x\",\"\",IF(LEFT(RIGHT($D23,E$6),1)=\"0\",10,1*LEFT(RIGHT($D23,E$6),1))),\"\"))","v":""},"","","","","","","","","","","","","","",17,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL23<>\"\",ROUND(1/AL23,1),IF(AL50=\"\",\"\",ROUND(AL50,1)))","v":""},"",null,null,17]
[null,null,18,"","","","","","","","","","","","","","","","",18,null,"",{"$f":"IF(E24=\"\",\"\",$U$32/W$6/E24)","v":""},"","","","","","","","","","","","","","","","",{"$f":"IF(AL24<>\"\",ROUND(1/AL24,1),IF(AL51=\"\",\"\",ROUND(AL51,1)))","v":""},"",null,null,18]
[null,null,19,"","","","","","","","","","","","","","","","",19,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL25<>\"\",ROUND(1/AL25,1),IF(AL52=\"\",\"\",ROUND(AL52,1)))","v":""},"",null,null,19]
[null,null,20,"","","","","","","","","","","","","","","","",20,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL26<>\"\",ROUND(1/AL26,1),IF(AL53=\"\",\"\",ROUND(AL53,1)))","v":""},"",null,null,20]
[null,null,21,"","","","","","","","","","","","","","","","",21,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL27<>\"\",ROUND(1/AL27,1),IF(AL54=\"\",\"\",ROUND(AL54,1)))","v":""},"",null,null,21]
[null,null,22,"","","","","","","","","","","","","","","","",22,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL28<>\"\",ROUND(1/AL28,1),IF(AL55=\"\",\"\",ROUND(AL55,1)))","v":""},"",null,null,22]
[null,null,23,"","","","","","","","","","","","","","","","",23,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL29<>\"\",ROUND(1/AL29,1),IF(AL56=\"\",\"\",ROUND(AL56,1)))","v":""},"",null,null,23]
[null,null,24,"","","","","","","","","","","","","","","","",24,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL30<>\"\",ROUND(1/AL30,1),IF(AL57=\"\",\"\",ROUND(AL57,1)))","v":""},"",null,null,24]
[{"$nulls":20},"weight",{"$nulls":16},{"$f":"SUM(AL7:AL30)","v":0.78260869565217395}]
[{"$nulls":20},15,{"$nulls":16},{"$f":"SUM(U7:U10)-4+U11*COUNT(AM7:AM30)","v":23}]
[{"$nulls":18},">",{"$nulls":17},{"$f":"(1-AL31)/AK59","v":1.2736090959630116E-3},null,"<"]
[{"$nulls":36},{"$f":"IF(AO7>4,AM7,\"\")","v":""},{"$f":"IF(AK34=\"\",\"\",1/(AK$33*AK34))","v":""}]
[{"$nulls":36},{"$f":"IF(AO8>4,AM8,\"\")","v":""},{"$f":"IF(AK35=\"\",\"\",1/(AK$33*AK35))","v":""}]
[{"$nulls":36},{"$f":"IF(AO9>4,AM9,\"\")","v":11.820021645021644},{"$f":"IF(AK36=\"\",\"\",1/(AK$33*AK36))","v":66.427143312040357}]
[{"$nulls":36},{"$f":"IF(AO10>4,AM10,\"\")","v":52.93452380952381},{"$f":"IF(AK37=\"\",\"\",1/(AK$33*AK37))","v":14.832857939566589}]
[{"$nulls":36},{"$f":"IF(AO11>4,AM11,\"\")","v":33.160119047619048},{"$f":"IF(AK38=\"\",\"\",1/(AK$33*AK38))","v":23.678149967970288}]
[{"$nulls":36},{"$f":"IF(AO12>4,AM12,\"\")","v":""},{"$f":"IF(AK39=\"\",\"\",1/(AK$33*AK39))","v":""}]
[{"$nulls":36},{"$f":"IF(AO13>4,AM13,\"\")","v":""},{"$f":"IF(AK40=\"\",\"\",1/(AK$33*AK40))","v":""}]
[{"$nulls":36},{"$f":"IF(AO14>4,AM14,\"\")","v":40.965704665704664},{"$f":"IF(AK41=\"\",\"\",1/(AK$33*AK41))","v":19.166526687934514}]
[{"$nulls":36},{"$f":"IF(AO15>4,AM15,\"\")","v":""},{"$f":"IF(AK42=\"\",\"\",1/(AK$33*AK42))","v":""}]
[{"$nulls":36},{"$f":"IF(AO16>4,AM16,\"\")","v":31.808820346320346},{"$f":"IF(AK43=\"\",\"\",1/(AK$33*AK43))","v":24.684042451643467}]
[{"$nulls":36},{"$f":"IF(AO17>4,AM17,\"\")","v":""},{"$f":"IF(AK44=\"\",\"\",1/(AK$33*AK44))","v":""}]
[{"$nulls":36},{"$f":"IF(AO18>4,AM18,\"\")","v":""},{"$f":"IF(AK45=\"\",\"\",1/(AK$33*AK45))","v":""}]
[{"$nulls":36},{"$f":"IF(AO19>4,AM19,\"\")","v":""},{"$f":"IF(AK46=\"\",\"\",1/(AK$33*AK46))","v":""}]
[{"$nulls":36},{"$f":"IF(AO20>4,AM20,\"\")","v":""},{"$f":"IF(AK47=\"\",\"\",1/(AK$33*AK47))","v":""}]
[{"$nulls":36},{"$f":"IF(AO21>4,AM21,\"\")","v":""},{"$f":"IF(AK48=\"\",\"\",1/(AK$33*AK48))","v":""}]
[{"$nulls":36},{"$f":"IF(AO22>4,AM22,\"\")","v":""},{"$f":"IF(AK49=\"\",\"\",1/(AK$33*AK49))","v":""}]
[{"$nulls":36},{"$f":"IF(AO23>4,AM23,\"\")","v":""},{"$f":"IF(AK50=\"\",\"\",1/(AK$33*AK50))","v":""}]
[{"$nulls":36},{"$f":"IF(AO24>4,AM24,\"\")","v":""},{"$f":"IF(AK51=\"\",\"\",1/(AK$33*AK51))","v":""}]
[{"$nulls":36},{"$f":"IF(AO25>4,AM25,\"\")","v":""},{"$f":"IF(AK52=\"\",\"\",1/(AK$33*AK52))","v":""}]
[{"$nulls":36},{"$f":"IF(AO26>4,AM26,\"\")","v":""},{"$f":"IF(AK53=\"\",\"\",1/(AK$33*AK53))","v":""}]
[{"$nulls":36},{"$f":"IF(AO27>4,AM27,\"\")","v":""},{"$f":"IF(AK54=\"\",\"\",1/(AK$33*AK54))","v":""}]
[{"$nulls":36},{"$f":"IF(AO28>4,AM28,\"\")","v":""},{"$f":"IF(AK55=\"\",\"\",1/(AK$33*AK55))","v":""}]
[{"$nulls":36},{"$f":"IF(AO29>4,AM29,\"\")","v":""},{"$f":"IF(AK56=\"\",\"\",1/(AK$33*AK56))","v":""}]
[{"$nulls":36},{"$f":"IF(AO30>4,AM30,\"\")","v":""},{"$f":"IF(AK57=\"\",\"\",1/(AK$33*AK57))","v":""}]
[{"$nulls":36},{"$f":"IF(AO31>4,AM31,\"\")","v":""},{"$f":"IF(AK58=\"\",\"\",1/(AK$33*AK58))","v":""}]
[{"$nulls":36},{"$f":"SUM(AK35:AK58)","v":170.68918951418951}]

{"sheet":"Sheet7","index":6,"n_rows":59,"n_cols":58,"rows_kept":59,"cut":false,"hidden":false,"merged":[[4,19,4,37],[4,38,4,40],[2,1,2,3],[1,1,1,3],[3,1,3,3]]}
[null,"HELP"]
[null,"FORM Analysis v2.0"]
[null,"02-11-2012",{"$nulls":16},">",{"$nulls":19},"<"]
[null,"Moonee Valley",{"$nulls":43},"FORM"]
[null,"Result",{"$f":"\"F \"&COUNT(AM7:AM30)","v":"F 10"},"Race7",{"$nulls":15},"Calculations -- hidden for cosmetic reasons",{"$nulls":18},{"$f":"B4&\" \"&D5","v":"Moonee Valley Race7"},{"$nulls":5},"v","delete if scratched"]
[null,"7.5.3","TAB","Form",15,14,13,12,11,10,9,8,7,6,5,4,3,2,1,"Finish Pos","Points","score",{"$f":"E6","v":15},{"$f":"F6","v":14},13,12,11,10,9,8,7,6,{"$f":"O6","v":5},{"$f":"P6","v":4},{"$f":"Q6","v":3},{"$f":"R6","v":2},{"$f":"S6","v":1},"Top 4","Analysis","BM Price","Rank",null,null,">","No","Last 10","Horse","Trainer","Jockey","Wt","Bar",{"$nulls":5},"API","PP"]
[null,null,1,{"$f":"IF(AT7=\"\",\"\",AT7)","v":"2189x838x121"},{"$f":"IF(OR(E$6=\"\",$D7=\"\"),\"\",IF(LEN($D7)>=E$6,IF(LEFT(RIGHT($D7,E$6),1)=\"x\",\"\",IF(LEFT(RIGHT($D7,E$6),1)=\"0\",10,1*LEFT(RIGHT($D7,E$6),1))),\"\"))","v":""},"","",2,1,8,9,"",8,3,8,"",1,2,1,1,8,{"$f":"IF(D7=\"\",\"\",VLOOKUP(IF(E7=\"\",11,E7),T$7:U$17,2)+VLOOKUP(IF(F7=\"\",11,F7),T$7:U$17,2)+VLOOKUP(IF(G7=\"\",11,G7),T$7:U$17,2)+VLOOKUP(IF(H7=\"\",11,H7),T$7:U$17,2)+VLOOKUP(IF(I7=\"\",11,I7),T$7:U$17,2)+VLOOKUP(IF(J7=\"\",11,J7),T$7:U$17,2)+VLOOKUP(IF(K7=\"\",11,K7),T$7:U$17,2)+VLOOKUP(IF(L7=\"\",11,L7),T$7:U$17,2)+VLOOKUP(IF(M7=\"\",11,M7),T$7:U$17,2)+VLOOKUP(IF(N7=\"\",11,N7),T$7:U$17,2)+VLOOKUP(IF(O7=\"\",11,O7),T$7:U$17,2)+VLOOKUP(IF(P7=\"\",11,P7),T$7:U$17,2)+VLOOKUP(IF(Q7=\"\",11,Q7),T$7:U$17,2)+VLOOKUP(IF(R7=\"\",11,R7),T$7:U$17,2)+VLOOKUP(IF(S7=\"\",11,S7),T$7:U$17,2))","v":38.1},{"$f":"IF(E7=\"\",\"\",$U$32/W$6/E7)","v":""},"","",0.625,1.3636363636363635,0.1875,0.1851851851851852,"",0.26785714285714285,0.83333333333333337,0.375,"",5,3.75,15,{"$f":"IF(AO7>4,\"\",1/(AL$32/VLOOKUP(AO7,T$7:U$11,2)))","v":0.33333333333333331},{"$f":"IF(V7=\"\",\"\",SUM(W7:AK7)+V7)","v":65.687512025012026},{"$f":"IF(AL7<>\"\",ROUND(1/AL7,1),IF(AL34=\"\",\"\",ROUND(AL34,1)))","v":3},{"$f":"IF(AM7=\"\",\"\",RANK(AM7,AM$7:AM$30))","v":1},null,null,1,1,"2189x838x121","Sabres","Anthony Freedman","S W Arnold ",60,3,{"$nulls":5},8.5,3.5]
[null,null,2,{"$f":"IF(AT8=\"\",\"\",AT8)","v":"212117x5253x"},"","","",2,1,2,1,1,7,"",5,2,5,3,"",2,5,{"$f":"IF(D8=\"\",\"\",VLOOKUP(IF(E8=\"\",24,E8),T$7:U$17,2)+VLOOKUP(IF(F8=\"\",24,F8),T$7:U$17,2)+VLOOKUP(IF(G8=\"\",24,G8),T$7:U$17,2)+VLOOKUP(IF(H8=\"\",24,H8),T$7:U$17,2)+VLOOKUP(IF(I8=\"\",24,I8),T$7:U$17,2)+VLOOKUP(IF(J8=\"\",24,J8),T$7:U$17,2)+VLOOKUP(IF(K8=\"\",24,K8),T$7:U$17,2)+VLOOKUP(IF(L8=\"\",24,L8),T$7:U$17,2)+VLOOKUP(IF(M8=\"\",24,M8),T$7:U$17,2)+VLOOKUP(IF(N8=\"\",24,N8),T$7:U$17,2)+VLOOKUP(IF(O8=\"\",24,O8),T$7:U$17,2)+VLOOKUP(IF(P8=\"\",24,P8),T$7:U$17,2)+VLOOKUP(IF(Q8=\"\",24,Q8),T$7:U$17,2)+VLOOKUP(IF(R8=\"\",24,R8),T$7:U$17,2)+VLOOKUP(IF(S8=\"\",24,S8),T$7:U$17,2))","v":44.5},"","","",0.625,1.3636363636363635,0.75,1.6666666666666667,1.875,0.30612244897959184,"",0.6,1.875,1,2.5,"",{"$f":"IF(AO8>4,\"\",1/(AL$32/VLOOKUP(AO8,T$7:U$11,2)))","v":8.3333333333333329E-2},{"$f":"IF(V8=\"\",\"\",SUM(W8:AK8)+V8)","v":57.061425479282619},{"$f":"IF(AL8<>\"\",ROUND(1/AL8,1),IF(AL35=\"\",\"\",ROUND(AL35,1)))","v":12},{"$f":"IF(AM8=\"\",\"\",RANK(AM8,AM$7:AM$30))","v":4},null,null,2,2,"212117x5253x","Snitza","R G Hore-Lacy","C Newitt ",59.5,4,{"$nulls":5},6.9,15]
[null,null,3,"033x700900x0","","","",10,3,3,"",7,10,10,9,10,10,"",10,3,3,7.299999999999998,"","","",0.125,0.45454545454545453,0.5,"",0.26785714285714285,0.21428571428571427,0.25,0.33333333333333331,0.375,0.5,"",1.5,"",11.820021645021644,{"$f":"IF(AL9<>\"\",ROUND(1/AL9,1),IF(AL36=\"\",\"\",ROUND(AL36,1)))","v":72.599999999999994},10,null,null,3,3,"033x700900x0","Allanthus","B L Jenkins","B Wallace (3kg) ","59 (56)",10,{"$nulls":5},3.8,51]
[null,null,4,"213111080x","","","","","",2,1,3,1,1,1,10,8,10,"",4,2,40.5,"","","","","",0.75,1.6666666666666667,0.625,2.1428571428571428,2.5,3,0.375,0.625,0.75,"","",52.93452380952381,{"$f":"IF(AL10<>\"\",ROUND(1/AL10,1),IF(AL37=\"\",\"\",ROUND(AL37,1)))","v":16.2},5,null,null,4,4,"213111080x","Angelology","K T Myers","J Noonan (1.5kg) ","57 (55.5)",5,{"$nulls":5},1.8,7]
[null,null,5,5120646844,"","","","","",5,1,2,10,6,4,6,8,4,4,5,1,22,"","","","","",0.3,1.6666666666666667,0.9375,0.21428571428571427,0.41666666666666669,0.75,0.625,0.625,1.875,3.75,"",33.160119047619048,{"$f":"IF(AL11<>\"\",ROUND(1/AL11,1),IF(AL38=\"\",\"\",ROUND(AL38,1)))","v":25.9},8,null,null,5,5,5120646844,"Eight Cards","R T Cleaver","M J Walker ",57,6,{"$nulls":5},3.5,7]
[null,null,6,"7x05x242115x8","","",7,"",10,5,"",2,4,2,1,1,5,"",8,6,0.8,30.900000000000002,"","",0.16483516483516483,"",0.13636363636363635,0.3,"",0.9375,0.5357142857142857,1.25,3,3.75,1,"",1.875,"",43.849413086913088,{"$f":"IF(AL12<>\"\",ROUND(1/AL12,1),IF(AL39=\"\",\"\",ROUND(AL39,1)))","v":19.600000000000001},6,null,null,6,6,"7x05x242115x8","Grand Sunday","J D Sadler","M Rodd ",55,8,{"$nulls":5},2.1,7]
[null,4.8,7,"12x62313225","","","","",1,2,"",6,2,3,1,3,2,2,5,7,0.5,43.8,"","","","",1.3636363636363635,0.75,"",0.3125,1.0714285714285714,0.83333333333333337,3,1.25,2.5,3.75,3,0.20833333333333334,61.630898268398269,{"$f":"IF(AL13<>\"\",ROUND(1/AL13,1),IF(AL40=\"\",\"\",ROUND(AL40,1)))","v":4.8},2,null,null,7,7,"12x62313225","Street Crier","M W Young","Dean Holland ",55,1,{"$nulls":5},3,3.8]
[null,null,8,"71978x33164","","","","",7,1,9,7,8,"",3,3,1,6,4,8,0.3,26.3,"","","","",0.19480519480519479,1.5,0.1851851851851852,0.26785714285714285,0.26785714285714285,"",1,1.25,5,1.25,3.75,"",40.965704665704664,{"$f":"IF(AL14<>\"\",ROUND(1/AL14,1),IF(AL41=\"\",\"\",ROUND(AL41,1)))","v":20.9},7,null,null,8,8,"71978x33164","Meteor Shower","Jackson Pallot","Ms R Williams (3kg) ","55 (52)",2,{"$nulls":5},2.5,15]
[null,null,9,"22122241x58","","","","",2,2,1,2,2,2,4,1,"",5,8,9,0.2,44.3,"","","","",0.68181818181818177,0.75,1.6666666666666667,0.9375,1.0714285714285714,1.25,0.75,3.75,"",1.5,1.875,0.125,58.532413419913418,{"$f":"IF(AL15<>\"\",ROUND(1/AL15,1),IF(AL42=\"\",\"\",ROUND(AL42,1)))","v":8},3,null,null,9,9,"22122241x58","Northern Jet","L J Corstens","D Oliver ",55,9,{"$nulls":5},2.8,5.5]
[null,null,10,"6472302x355","","","","",6,4,7,2,3,10,2,"",3,5,5,10,0.1,21.4,"","","","",0.22727272727272727,0.375,0.23809523809523811,0.9375,0.7142857142857143,0.25,1.5,"",1.6666666666666667,1.5,3,"",31.808820346320346,{"$f":"IF(AL16<>\"\",ROUND(1/AL16,1),IF(AL43=\"\",\"\",ROUND(AL43,1)))","v":27},9,null,null,10,10,"6472302x355","Dangarway","Ms M Ballantine","L Currie ",55,7,{"$nulls":5},2.1,21]
[null,null,11,"","","","","","","","","","","","","","","","",11,0,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL17<>\"\",ROUND(1/AL17,1),IF(AL44=\"\",\"\",ROUND(AL44,1)))","v":""},"",null,null,11]
[null,null,12,"","","","","","","","","","","","","","","","",12,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL18<>\"\",ROUND(1/AL18,1),IF(AL45=\"\",\"\",ROUND(AL45,1)))","v":""},"",null,null,12]
[null,null,13,"","","","","","","","","","","","","","","","",13,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL19<>\"\",ROUND(1/AL19,1),IF(AL46=\"\",\"\",ROUND(AL46,1)))","v":""},"",null,null,13]
[null,null,14,"","","","","","","","","","","","","","","","",14,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL20<>\"\",ROUND(1/AL20,1),IF(AL47=\"\",\"\",ROUND(AL47,1)))","v":""},"",null,null,14]
[null,null,15,"","","","","","","","","","","","","","","","",15,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL21<>\"\",ROUND(1/AL21,1),IF(AL48=\"\",\"\",ROUND(AL48,1)))","v":""},"",null,null,15]
[null,null,16,"","","","","","","","","","","","","","","","",16,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL22<>\"\",ROUND(1/AL22,1),IF(AL49=\"\",\"\",ROUND(AL49,1)))","v":""},"",null,null,16]
[null,null,17,"",{"$f":"IF(OR(E$6=\"\",$D23=\"\"),\"\",IF(LEN($D23)>=E$6,IF(LEFT(RIGHT($D23,E$6),1)=\"x\",\"\",IF(LEFT(RIGHT($D23,E$6),1)=\"0\",10,1*LEFT(RIGHT($D23,E$6),1))),\"\"))","v":""},"","","","","","","","","","","","","","",17,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL23<>\"\",ROUND(1/AL23,1),IF(AL50=\"\",\"\",ROUND(AL50,1)))","v":""},"",null,null,17]
[null,null,18,"","","","","","","","","","","","","","","","",18,null,"",{"$f":"IF(E24=\"\",\"\",$U$32/W$6/E24)","v":""},"","","","","","","","","","","","","","","","",{"$f":"IF(AL24<>\"\",ROUND(1/AL24,1),IF(AL51=\"\",\"\",ROUND(AL51,1)))","v":""},"",null,null,18]
[null,null,19,"","","","","","","","","","","","","","","","",19,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL25<>\"\",ROUND(1/AL25,1),IF(AL52=\"\",\"\",ROUND(AL52,1)))","v":""},"",null,null,19]
[null,null,20,"","","","","","","","","","","","","","","","",20,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL26<>\"\",ROUND(1/AL26,1),IF(AL53=\"\",\"\",ROUND(AL53,1)))","v":""},"",null,null,20]
[null,null,21,"","","","","","","","","","","","","","","","",21,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL27<>\"\",ROUND(1/AL27,1),IF(AL54=\"\",\"\",ROUND(AL54,1)))","v":""},"",null,null,21]
[null,null,22,"","","","","","","","","","","","","","","","",22,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL28<>\"\",ROUND(1/AL28,1),IF(AL55=\"\",\"\",ROUND(AL55,1)))","v":""},"",null,null,22]
[null,null,23,"","","","","","","","","","","","","","","","",23,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL29<>\"\",ROUND(1/AL29,1),IF(AL56=\"\",\"\",ROUND(AL56,1)))","v":""},"",null,null,23]
[null,null,24,"","","","","","","","","","","","","","","","",24,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL30<>\"\",ROUND(1/AL30,1),IF(AL57=\"\",\"\",ROUND(AL57,1)))","v":""},"",null,null,24]
[{"$nulls":20},"weight",{"$nulls":16},{"$f":"SUM(AL7:AL30)","v":0.75}]
[{"$nulls":20},15,{"$nulls":16},{"$f":"SUM(U7:U10)-4+U11*COUNT(AM7:AM30)","v":24}]
[{"$nulls":18},">",{"$nulls":17},{"$f":"(1-AL31)/AK59","v":1.1652914532347901E-3},null,"<"]
[{"$nulls":36},{"$f":"IF(AO7>4,AM7,\"\")","v":""},{"$f":"IF(AK34=\"\",\"\",1/(AK$33*AK34))","v":""}]
[{"$nulls":36},{"$f":"IF(AO8>4,AM8,\"\")","v":""},{"$f":"IF(AK35=\"\",\"\",1/(AK$33*AK35))","v":""}]
[{"$nulls":36},{"$f":"IF(AO9>4,AM9,\"\")","v":11.820021645021644},{"$f":"IF(AK36=\"\",\"\",1/(AK$33*AK36))","v":72.601763023492254}]
[{"$nulls":36},{"$f":"IF(AO10>4,AM10,\"\")","v":52.93452380952381},{"$f":"IF(AK37=\"\",\"\",1/(AK$33*AK37))","v":16.211620482170353}]
[{"$nulls":36},{"$f":"IF(AO11>4,AM11,\"\")","v":33.160119047619048},{"$f":"IF(AK38=\"\",\"\",1/(AK$33*AK38))","v":25.879111265314574}]
[{"$nulls":36},{"$f":"IF(AO12>4,AM12,\"\")","v":43.849413086913088},{"$f":"IF(AK39=\"\",\"\",1/(AK$33*AK39))","v":19.570487949370698}]
[{"$nulls":36},{"$f":"IF(AO13>4,AM13,\"\")","v":""},{"$f":"IF(AK40=\"\",\"\",1/(AK$33*AK40))","v":""}]
[{"$nulls":36},{"$f":"IF(AO14>4,AM14,\"\")","v":40.965704665704664},{"$f":"IF(AK41=\"\",\"\",1/(AK$33*AK41))","v":20.94811788073142}]
[{"$nulls":36},{"$f":"IF(AO15>4,AM15,\"\")","v":""},{"$f":"IF(AK42=\"\",\"\",1/(AK$33*AK42))","v":""}]
[{"$nulls":36},{"$f":"IF(AO16>4,AM16,\"\")","v":31.808820346320346},{"$f":"IF(AK43=\"\",\"\",1/(AK$33*AK43))","v":26.978504737403192}]
[{"$nulls":36},{"$f":"IF(AO17>4,AM17,\"\")","v":""},{"$f":"IF(AK44=\"\",\"\",1/(AK$33*AK44))","v":""}]
[{"$nulls":36},{"$f":"IF(AO18>4,AM18,\"\")","v":""},{"$f":"IF(AK45=\"\",\"\",1/(AK$33*AK45))","v":""}]
[{"$nulls":36},{"$f":"IF(AO19>4,AM19,\"\")","v":""},{"$f":"IF(AK46=\"\",\"\",1/(AK$33*AK46))","v":""}]
[{"$nulls":36},{"$f":"IF(AO20>4,AM20,\"\")","v":""},{"$f":"IF(AK47=\"\",\"\",1/(AK$33*AK47))","v":""}]
[{"$nulls":36},{"$f":"IF(AO21>4,AM21,\"\")","v":""},{"$f":"IF(AK48=\"\",\"\",1/(AK$33*AK48))","v":""}]
[{"$nulls":36},{"$f":"IF(AO22>4,AM22,\"\")","v":""},{"$f":"IF(AK49=\"\",\"\",1/(AK$33*AK49))","v":""}]
[{"$nulls":36},{"$f":"IF(AO23>4,AM23,\"\")","v":""},{"$f":"IF(AK50=\"\",\"\",1/(AK$33*AK50))","v":""}]
[{"$nulls":36},{"$f":"IF(AO24>4,AM24,\"\")","v":""},{"$f":"IF(AK51=\"\",\"\",1/(AK$33*AK51))","v":""}]
[{"$nulls":36},{"$f":"IF(AO25>4,AM25,\"\")","v":""},{"$f":"IF(AK52=\"\",\"\",1/(AK$33*AK52))","v":""}]
[{"$nulls":36},{"$f":"IF(AO26>4,AM26,\"\")","v":""},{"$f":"IF(AK53=\"\",\"\",1/(AK$33*AK53))","v":""}]
[{"$nulls":36},{"$f":"IF(AO27>4,AM27,\"\")","v":""},{"$f":"IF(AK54=\"\",\"\",1/(AK$33*AK54))","v":""}]
[{"$nulls":36},{"$f":"IF(AO28>4,AM28,\"\")","v":""},{"$f":"IF(AK55=\"\",\"\",1/(AK$33*AK55))","v":""}]
[{"$nulls":36},{"$f":"IF(AO29>4,AM29,\"\")","v":""},{"$f":"IF(AK56=\"\",\"\",1/(AK$33*AK56))","v":""}]
[{"$nulls":36},{"$f":"IF(AO30>4,AM30,\"\")","v":""},{"$f":"IF(AK57=\"\",\"\",1/(AK$33*AK57))","v":""}]
[{"$nulls":36},{"$f":"IF(AO31>4,AM31,\"\")","v":""},{"$f":"IF(AK58=\"\",\"\",1/(AK$33*AK58))","v":""}]
[{"$nulls":36},{"$f":"SUM(AK35:AK58)","v":214.53860260110261}]

{"sheet":"Sheet8","index":7,"n_rows":59,"n_cols":58,"rows_kept":59,"cut":false,"hidden":false,"merged":[[4,19,4,37],[4,38,4,40],[2,1,2,3],[1,1,1,3],[3,1,3,3]]}
[null,"HELP"]
[null,"FORM Analysis v2.0"]
[null,"02-11-2012",{"$nulls":16},">",{"$nulls":19},"<"]
[null,"Moonee Valley",{"$nulls":43},"FORM"]
[null,"Result",{"$f":"\"F \"&COUNT(AM7:AM30)","v":"F 11"},"Race 8",{"$nulls":15},"Calculations -- hidden for cosmetic reasons",{"$nulls":18},{"$f":"B4&\" \"&D5","v":"Moonee Valley Race 8"},{"$nulls":5},"v","delete if scratched"]
[null,"6.5.2","TAB","Form",15,14,13,12,11,10,9,8,7,6,5,4,3,2,1,"Finish Pos","Points","score",{"$f":"E6","v":15},{"$f":"F6","v":14},13,12,11,10,9,8,7,6,{"$f":"O6","v":5},{"$f":"P6","v":4},{"$f":"Q6","v":3},{"$f":"R6","v":2},{"$f":"S6","v":1},"Top 4","Analysis","BM Price","Rank",null,null,">","No","Last 10","Horse","Trainer","Jockey","Wt","Bar",{"$nulls":5},"API","PP"]
[null,null,1,{"$f":"IF(AT7=\"\",\"\",AT7)","v":"3503454x115"},{"$f":"IF(OR(E$6=\"\",$D7=\"\"),\"\",IF(LEN($D7)>=E$6,IF(LEFT(RIGHT($D7,E$6),1)=\"x\",\"\",IF(LEFT(RIGHT($D7,E$6),1)=\"0\",10,1*LEFT(RIGHT($D7,E$6),1))),\"\"))","v":""},"","","",3,5,10,3,4,5,4,"",1,1,5,1,8,{"$f":"IF(D7=\"\",\"\",VLOOKUP(IF(E7=\"\",11,E7),T$7:U$17,2)+VLOOKUP(IF(F7=\"\",11,F7),T$7:U$17,2)+VLOOKUP(IF(G7=\"\",11,G7),T$7:U$17,2)+VLOOKUP(IF(H7=\"\",11,H7),T$7:U$17,2)+VLOOKUP(IF(I7=\"\",11,I7),T$7:U$17,2)+VLOOKUP(IF(J7=\"\",11,J7),T$7:U$17,2)+VLOOKUP(IF(K7=\"\",11,K7),T$7:U$17,2)+VLOOKUP(IF(L7=\"\",11,L7),T$7:U$17,2)+VLOOKUP(IF(M7=\"\",11,M7),T$7:U$17,2)+VLOOKUP(IF(N7=\"\",11,N7),T$7:U$17,2)+VLOOKUP(IF(O7=\"\",11,O7),T$7:U$17,2)+VLOOKUP(IF(P7=\"\",11,P7),T$7:U$17,2)+VLOOKUP(IF(Q7=\"\",11,Q7),T$7:U$17,2)+VLOOKUP(IF(R7=\"\",11,R7),T$7:U$17,2)+VLOOKUP(IF(S7=\"\",11,S7),T$7:U$17,2))","v":29.1},{"$f":"IF(E7=\"\",\"\",$U$32/W$6/E7)","v":""},"","","",0.45454545454545453,0.3,0.16666666666666669,0.625,0.5357142857142857,0.5,0.75,"",5,7.5,3,{"$f":"IF(AO7>4,\"\",1/(AL$32/VLOOKUP(AO7,T$7:U$11,2)))","v":""},{"$f":"IF(V7=\"\",\"\",SUM(W7:AK7)+V7)","v":47.931926406926408},{"$f":"IF(AL7<>\"\",ROUND(1/AL7,1),IF(AL34=\"\",\"\",ROUND(AL34,1)))","v":18.899999999999999},{"$f":"IF(AM7=\"\",\"\",RANK(AM7,AM$7:AM$30))","v":7},null,null,1,1,"3503454x115","Florets","Anthony Freedman","B Wallace (3kg) ","59 (56)",1,{"$nulls":5},7.9,5.5]
[null,null,2,{"$f":"IF(AT8=\"\",\"\",AT8)","v":"213723x148x"},"","","","",2,1,3,7,2,3,"",1,4,8,"",2,5,{"$f":"IF(D8=\"\",\"\",VLOOKUP(IF(E8=\"\",24,E8),T$7:U$17,2)+VLOOKUP(IF(F8=\"\",24,F8),T$7:U$17,2)+VLOOKUP(IF(G8=\"\",24,G8),T$7:U$17,2)+VLOOKUP(IF(H8=\"\",24,H8),T$7:U$17,2)+VLOOKUP(IF(I8=\"\",24,I8),T$7:U$17,2)+VLOOKUP(IF(J8=\"\",24,J8),T$7:U$17,2)+VLOOKUP(IF(K8=\"\",24,K8),T$7:U$17,2)+VLOOKUP(IF(L8=\"\",24,L8),T$7:U$17,2)+VLOOKUP(IF(M8=\"\",24,M8),T$7:U$17,2)+VLOOKUP(IF(N8=\"\",24,N8),T$7:U$17,2)+VLOOKUP(IF(O8=\"\",24,O8),T$7:U$17,2)+VLOOKUP(IF(P8=\"\",24,P8),T$7:U$17,2)+VLOOKUP(IF(Q8=\"\",24,Q8),T$7:U$17,2)+VLOOKUP(IF(R8=\"\",24,R8),T$7:U$17,2)+VLOOKUP(IF(S8=\"\",24,S8),T$7:U$17,2))","v":34.799999999999997},"","","","",0.68181818181818177,1.5,0.55555555555555558,0.26785714285714285,1.0714285714285714,0.83333333333333337,"",3.75,1.25,0.9375,"",{"$f":"IF(AO8>4,\"\",1/(AL$32/VLOOKUP(AO8,T$7:U$11,2)))","v":""},{"$f":"IF(V8=\"\",\"\",SUM(W8:AK8)+V8)","v":45.647492784992778},{"$f":"IF(AL8<>\"\",ROUND(1/AL8,1),IF(AL35=\"\",\"\",ROUND(AL35,1)))","v":19.8},{"$f":"IF(AM8=\"\",\"\",RANK(AM8,AM$7:AM$30))","v":8},null,null,2,2,"213723x148x","Classic Elle","A J Vasil","J Bowman ",57,10,{"$nulls":5},7.8,4.8]
[null,null,3,"310x218x4942","","","",3,1,10,"",2,1,8,"",4,9,4,2,3,3,33.6,"","","",0.41666666666666669,1.3636363636363635,0.15,"",0.9375,2.1428571428571428,0.3125,"",0.9375,0.55555555555555558,1.875,7.5,"",49.791215728715727,{"$f":"IF(AL9<>\"\",ROUND(1/AL9,1),IF(AL36=\"\",\"\",ROUND(AL36,1)))","v":18.2},6,null,null,3,3,"310x218x4942","Diazling","Luke Oliver","J Mott ",56.5,4,{"$nulls":5},6.6]
[null,null,4,"23x21115","","","","","","","",2,3,"",2,1,1,1,5,4,2,38,"","","","","","","",0.9375,0.7142857142857143,"",1.5,3.75,5,7.5,3,0.32,60.401785714285715,{"$f":"IF(AL10<>\"\",ROUND(1/AL10,1),IF(AL37=\"\",\"\",ROUND(AL37,1)))","v":3.1},1,null,null,4,4,"23x21115","Our Mimi","Lloyd Kennewell","M Zahra ",56.5,2,{"$nulls":5},6.2,6]
[null,null,5,"1493x554x073","","","",1,4,9,3,"",5,5,4,"",10,7,3,5,1,20.8,"","","",1.25,0.34090909090909088,0.16666666666666666,0.55555555555555558,"",0.42857142857142855,0.5,0.75,"",0.5,1.0714285714285714,5,"",31.363131313131312,{"$f":"IF(AL11<>\"\",ROUND(1/AL11,1),IF(AL38=\"\",\"\",ROUND(AL38,1)))","v":28.9},11,null,null,5,5,"1493x554x073","And Rock","John McArdle","J Noonan (1.5kg) ","56 (54.5)",7,{"$nulls":5},9.1,8]
[null,6,6,"11421209x27","","","","",1,1,4,2,1,2,10,9,"",2,7,6,0.8,41.800000000000004,"","","","",1.3636363636363635,1.5,0.41666666666666669,0.9375,2.1428571428571428,1.25,0.3,0.41666666666666669,"",3.75,2.1428571428571428,0.12,56.020183982683989,{"$f":"IF(AL12<>\"\",ROUND(1/AL12,1),IF(AL39=\"\",\"\",ROUND(AL39,1)))","v":8.3000000000000007},3,null,null,6,6,"11421209x27","Lady Antebellum","L J Corstens","Nicholas Hall ",56,5,{"$nulls":5},8.4,6.5]
[null,null,7,"21x411","","","","","","","","","",2,1,"",4,1,1,7,0.5,31,"","","","","","","","","",1.25,3,"",1.25,7.5,15,0.2,59,{"$f":"IF(AL13<>\"\",ROUND(1/AL13,1),IF(AL40=\"\",\"\",ROUND(AL40,1)))","v":5},2,null,null,7,7,"21x411","Rose Of Lincoln","D R Jolly","M Neilson ",56,8,{"$nulls":5},6.2,6]
[null,null,8,"9x53137x21","","","","","",9,"",5,3,1,3,7,"",2,1,8,0.3,28.7,"","","","","",0.16666666666666666,"",0.375,0.7142857142857143,2.5,1,0.5357142857142857,"",3.75,15,"",52.741666666666667,{"$f":"IF(AL14<>\"\",ROUND(1/AL14,1),IF(AL41=\"\",\"\",ROUND(AL41,1)))","v":17.2},5,null,null,8,8,"9x53137x21","Aneto","M, W & J Hawkes","C Newitt ",55,3,{"$nulls":5},3.6,9]
[null,null,9,"61x420x33","","","","","","",6,1,"",4,2,10,"",3,3,9,0.2,21.9,"","","","","","",0.27777777777777779,1.875,"",0.625,1.5,0.375,"",2.5,5,"",34.052777777777777,{"$f":"IF(AL15<>\"\",ROUND(1/AL15,1),IF(AL42=\"\",\"\",ROUND(AL42,1)))","v":26.6},10,null,null,9,9,"61x420x33","Incredulous","S A Dwyer","M Rodd ",55,9,{"$nulls":5},3.5,13]
[null,null,10,"242x1","","","","","","","","","","",2,4,2,"",1,10,0.1,20,"","","","","","","","","","",1.5,0.9375,2.5,"",15,"",39.9375,{"$f":"IF(AL16<>\"\",ROUND(1/AL16,1),IF(AL43=\"\",\"\",ROUND(AL43,1)))","v":22.7},9,null,null,10,10,"242x1","More Than Smooth","M G Price","D Oliver ",55,11,{"$nulls":5},6.5,7]
[null,null,11,"5x3325x113","","","","","",5,"",3,3,2,5,"",1,1,3,11,0,32,"","","","","",0.3,"",0.625,0.7142857142857143,1.25,0.6,"",5,7.5,5,0.08,52.989285714285714,{"$f":"IF(AL17<>\"\",ROUND(1/AL17,1),IF(AL44=\"\",\"\",ROUND(AL44,1)))","v":12.5},4,null,null,11,11,"5x3325x113","Ombra Sierra","B & S Wilde","Thomas Sadler (3kg) ","55 (52)",6,{"$nulls":5},2.7,31]
[null,null,12,"","","","","","","","","","","","","","","","",12,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL18<>\"\",ROUND(1/AL18,1),IF(AL45=\"\",\"\",ROUND(AL45,1)))","v":""},"",null,null,12]
[null,null,13,"","","","","","","","","","","","","","","","",13,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL19<>\"\",ROUND(1/AL19,1),IF(AL46=\"\",\"\",ROUND(AL46,1)))","v":""},"",null,null,13]
[null,null,14,"","","","","","","","","","","","","","","","",14,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL20<>\"\",ROUND(1/AL20,1),IF(AL47=\"\",\"\",ROUND(AL47,1)))","v":""},"",null,null,14]
[null,null,15,"","","","","","","","","","","","","","","","",15,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL21<>\"\",ROUND(1/AL21,1),IF(AL48=\"\",\"\",ROUND(AL48,1)))","v":""},"",null,null,15]
[null,null,16,"","","","","","","","","","","","","","","","",16,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL22<>\"\",ROUND(1/AL22,1),IF(AL49=\"\",\"\",ROUND(AL49,1)))","v":""},"",null,null,16]
[null,null,17,"",{"$f":"IF(OR(E$6=\"\",$D23=\"\"),\"\",IF(LEN($D23)>=E$6,IF(LEFT(RIGHT($D23,E$6),1)=\"x\",\"\",IF(LEFT(RIGHT($D23,E$6),1)=\"0\",10,1*LEFT(RIGHT($D23,E$6),1))),\"\"))","v":""},"","","","","","","","","","","","","","",17,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL23<>\"\",ROUND(1/AL23,1),IF(AL50=\"\",\"\",ROUND(AL50,1)))","v":""},"",null,null,17]
[null,null,18,"","","","","","","","","","","","","","","","",18,null,"",{"$f":"IF(E24=\"\",\"\",$U$32/W$6/E24)","v":""},"","","","","","","","","","","","","","","","",{"$f":"IF(AL24<>\"\",ROUND(1/AL24,1),IF(AL51=\"\",\"\",ROUND(AL51,1)))","v":""},"",null,null,18]
[null,null,19,"","","","","","","","","","","","","","","","",19,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL25<>\"\",ROUND(1/AL25,1),IF(AL52=\"\",\"\",ROUND(AL52,1)))","v":""},"",null,null,19]
[null,null,20,"","","","","","","","","","","","","","","","",20,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL26<>\"\",ROUND(1/AL26,1),IF(AL53=\"\",\"\",ROUND(AL53,1)))","v":""},"",null,null,20]
[null,null,21,"","","","","","","","","","","","","","","","",21,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL27<>\"\",ROUND(1/AL27,1),IF(AL54=\"\",\"\",ROUND(AL54,1)))","v":""},"",null,null,21]
[null,null,22,"","","","","","","","","","","","","","","","",22,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL28<>\"\",ROUND(1/AL28,1),IF(AL55=\"\",\"\",ROUND(AL55,1)))","v":""},"",null,null,22]
[null,null,23,"","","","","","","","","","","","","","","","",23,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL29<>\"\",ROUND(1/AL29,1),IF(AL56=\"\",\"\",ROUND(AL56,1)))","v":""},"",null,null,23]
[null,null,24,"","","","","","","","","","","","","","","","",24,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL30<>\"\",ROUND(1/AL30,1),IF(AL57=\"\",\"\",ROUND(AL57,1)))","v":""},"",null,null,24]
[{"$nulls":20},"weight",{"$nulls":16},{"$f":"SUM(AL7:AL30)","v":0.72}]
[{"$nulls":20},15,{"$nulls":16},{"$f":"SUM(U7:U10)-4+U11*COUNT(AM7:AM30)","v":25}]
[{"$nulls":18},">",{"$nulls":17},{"$f":"(1-AL31)/AK59","v":1.1043893057676155E-3},null,"<"]
[{"$nulls":36},{"$f":"IF(AO7>4,AM7,\"\")","v":47.931926406926408},{"$f":"IF(AK34=\"\",\"\",1/(AK$33*AK34))","v":18.890911942108509}]
[{"$nulls":36},{"$f":"IF(AO8>4,AM8,\"\")","v":45.647492784992778},{"$f":"IF(AK35=\"\",\"\",1/(AK$33*AK35))","v":19.836309635532935}]
[{"$nulls":36},{"$f":"IF(AO9>4,AM9,\"\")","v":49.791215728715727},{"$f":"IF(AK36=\"\",\"\",1/(AK$33*AK36))","v":18.185492917110331}]
[{"$nulls":36},{"$f":"IF(AO10>4,AM10,\"\")","v":""},{"$f":"IF(AK37=\"\",\"\",1/(AK$33*AK37))","v":""}]
[{"$nulls":36},{"$f":"IF(AO11>4,AM11,\"\")","v":31.363131313131312},{"$f":"IF(AK38=\"\",\"\",1/(AK$33*AK38))","v":28.870771605313564}]
[{"$nulls":36},{"$f":"IF(AO12>4,AM12,\"\")","v":""},{"$f":"IF(AK39=\"\",\"\",1/(AK$33*AK39))","v":""}]
[{"$nulls":36},{"$f":"IF(AO13>4,AM13,\"\")","v":""},{"$f":"IF(AK40=\"\",\"\",1/(AK$33*AK40))","v":""}]
[{"$nulls":36},{"$f":"IF(AO14>4,AM14,\"\")","v":52.741666666666667},{"$f":"IF(AK41=\"\",\"\",1/(AK$33*AK41))","v":17.168168133396218}]
[{"$nulls":36},{"$f":"IF(AO15>4,AM15,\"\")","v":34.052777777777777},{"$f":"IF(AK42=\"\",\"\",1/(AK$33*AK42))","v":26.590424043461461}]
[{"$nulls":36},{"$f":"IF(AO16>4,AM16,\"\")","v":39.9375},{"$f":"IF(AK43=\"\",\"\",1/(AK$33*AK43))","v":22.672370603289444}]
[{"$nulls":36},{"$f":"IF(AO17>4,AM17,\"\")","v":""},{"$f":"IF(AK44=\"\",\"\",1/(AK$33*AK44))","v":""}]
[{"$nulls":36},{"$f":"IF(AO18>4,AM18,\"\")","v":""},{"$f":"IF(AK45=\"\",\"\",1/(AK$33*AK45))","v":""}]
[{"$nulls":36},{"$f":"IF(AO19>4,AM19,\"\")","v":""},{"$f":"IF(AK46=\"\",\"\",1/(AK$33*AK46))","v":""}]
[{"$nulls":36},{"$f":"IF(AO20>4,AM20,\"\")","v":""},{"$f":"IF(AK47=\"\",\"\",1/(AK$33*AK47))","v":""}]
[{"$nulls":36},{"$f":"IF(AO21>4,AM21,\"\")","v":""},{"$f":"IF(AK48=\"\",\"\",1/(AK$33*AK48))","v":""}]
[{"$nulls":36},{"$f":"IF(AO22>4,AM22,\"\")","v":""},{"$f":"IF(AK49=\"\",\"\",1/(AK$33*AK49))","v":""}]
[{"$nulls":36},{"$f":"IF(AO23>4,AM23,\"\")","v":""},{"$f":"IF(AK50=\"\",\"\",1/(AK$33*AK50))","v":""}]
[{"$nulls":36},{"$f":"IF(AO24>4,AM24,\"\")","v":""},{"$f":"IF(AK51=\"\",\"\",1/(AK$33*AK51))","v":""}]
[{"$nulls":36},{"$f":"IF(AO25>4,AM25,\"\")","v":""},{"$f":"IF(AK52=\"\",\"\",1/(AK$33*AK52))","v":""}]
[{"$nulls":36},{"$f":"IF(AO26>4,AM26,\"\")","v":""},{"$f":"IF(AK53=\"\",\"\",1/(AK$33*AK53))","v":""}]
[{"$nulls":36},{"$f":"IF(AO27>4,AM27,\"\")","v":""},{"$f":"IF(AK54=\"\",\"\",1/(AK$33*AK54))","v":""}]
[{"$nulls":36},{"$f":"IF(AO28>4,AM28,\"\")","v":""},{"$f":"IF(AK55=\"\",\"\",1/(AK$33*AK55))","v":""}]
[{"$nulls":36},{"$f":"IF(AO29>4,AM29,\"\")","v":""},{"$f":"IF(AK56=\"\",\"\",1/(AK$33*AK56))","v":""}]
[{"$nulls":36},{"$f":"IF(AO30>4,AM30,\"\")","v":""},{"$f":"IF(AK57=\"\",\"\",1/(AK$33*AK57))","v":""}]
[{"$nulls":36},{"$f":"IF(AO31>4,AM31,\"\")","v":""},{"$f":"IF(AK58=\"\",\"\",1/(AK$33*AK58))","v":""}]
[{"$nulls":36},{"$f":"SUM(AK35:AK58)","v":253.53378427128428}]

{"sheet":"Sheet9","index":8,"n_rows":59,"n_cols":46,"rows_kept":59,"cut":false,"hidden":false,"merged":[[4,19,4,37],[4,38,4,40],[2,1,2,3],[1,1,1,3],[3,1,3,3]]}
[null,"HELP"]
[null,"FORM Analysis v2.0"]
[null,"02-11-2012",{"$nulls":16},">",{"$nulls":19},"<"]
[null,"Moonee Valley",{"$nulls":43},"FORM"]
[null,"Result",{"$f":"\"F \"&COUNT(AM7:AM30)","v":"F 0"},"Race 9",{"$nulls":15},"Calculations -- hidden for cosmetic reasons",{"$nulls":18},{"$f":"B4&\" \"&D5","v":"Moonee Valley Race 9"},{"$nulls":5},"v","delete if scratched"]
[null,null,"TAB","Form",15,14,13,12,11,10,9,8,7,6,5,4,3,2,1,"Finish Pos","Points","score",{"$f":"E6","v":15},{"$f":"F6","v":14},13,12,11,10,9,8,7,6,{"$f":"O6","v":5},{"$f":"P6","v":4},{"$f":"Q6","v":3},{"$f":"R6","v":2},{"$f":"S6","v":1},"Top 4","Analysis","BM Price","Rank",null,null,">","TAB"]
[null,null,1,{"$f":"IF(AT7=\"\",\"\",AT7)","v":""},{"$f":"IF(OR(E$6=\"\",$D7=\"\"),\"\",IF(LEN($D7)>=E$6,IF(LEFT(RIGHT($D7,E$6),1)=\"x\",\"\",IF(LEFT(RIGHT($D7,E$6),1)=\"0\",10,1*LEFT(RIGHT($D7,E$6),1))),\"\"))","v":""},"","","","","","","","","","","","","","",1,8,{"$f":"IF(D7=\"\",\"\",VLOOKUP(IF(E7=\"\",11,E7),T$7:U$17,2)+VLOOKUP(IF(F7=\"\",11,F7),T$7:U$17,2)+VLOOKUP(IF(G7=\"\",11,G7),T$7:U$17,2)+VLOOKUP(IF(H7=\"\",11,H7),T$7:U$17,2)+VLOOKUP(IF(I7=\"\",11,I7),T$7:U$17,2)+VLOOKUP(IF(J7=\"\",11,J7),T$7:U$17,2)+VLOOKUP(IF(K7=\"\",11,K7),T$7:U$17,2)+VLOOKUP(IF(L7=\"\",11,L7),T$7:U$17,2)+VLOOKUP(IF(M7=\"\",11,M7),T$7:U$17,2)+VLOOKUP(IF(N7=\"\",11,N7),T$7:U$17,2)+VLOOKUP(IF(O7=\"\",11,O7),T$7:U$17,2)+VLOOKUP(IF(P7=\"\",11,P7),T$7:U$17,2)+VLOOKUP(IF(Q7=\"\",11,Q7),T$7:U$17,2)+VLOOKUP(IF(R7=\"\",11,R7),T$7:U$17,2)+VLOOKUP(IF(S7=\"\",11,S7),T$7:U$17,2))","v":""},{"$f":"IF(E7=\"\",\"\",$U$32/W$6/E7)","v":""},"","","","","","","","","","","","","","",{"$f":"IF(AO7>4,\"\",1/(AL$32/VLOOKUP(AO7,T$7:U$11,2)))","v":""},{"$f":"IF(V7=\"\",\"\",SUM(W7:AK7)+V7)","v":""},{"$f":"IF(AL7<>\"\",ROUND(1/AL7,1),IF(AL34=\"\",\"\",ROUND(AL34,1)))","v":""},{"$f":"IF(AM7=\"\",\"\",RANK(AM7,AM$7:AM$30))","v":""},null,null,1]
[null,null,2,{"$f":"IF(AT8=\"\",\"\",AT8)","v":""},"","","","","","","","","","","","","","","",2,5,{"$f":"IF(D8=\"\",\"\",VLOOKUP(IF(E8=\"\",24,E8),T$7:U$17,2)+VLOOKUP(IF(F8=\"\",24,F8),T$7:U$17,2)+VLOOKUP(IF(G8=\"\",24,G8),T$7:U$17,2)+VLOOKUP(IF(H8=\"\",24,H8),T$7:U$17,2)+VLOOKUP(IF(I8=\"\",24,I8),T$7:U$17,2)+VLOOKUP(IF(J8=\"\",24,J8),T$7:U$17,2)+VLOOKUP(IF(K8=\"\",24,K8),T$7:U$17,2)+VLOOKUP(IF(L8=\"\",24,L8),T$7:U$17,2)+VLOOKUP(IF(M8=\"\",24,M8),T$7:U$17,2)+VLOOKUP(IF(N8=\"\",24,N8),T$7:U$17,2)+VLOOKUP(IF(O8=\"\",24,O8),T$7:U$17,2)+VLOOKUP(IF(P8=\"\",24,P8),T$7:U$17,2)+VLOOKUP(IF(Q8=\"\",24,Q8),T$7:U$17,2)+VLOOKUP(IF(R8=\"\",24,R8),T$7:U$17,2)+VLOOKUP(IF(S8=\"\",24,S8),T$7:U$17,2))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AO8>4,\"\",1/(AL$32/VLOOKUP(AO8,T$7:U$11,2)))","v":""},{"$f":"IF(V8=\"\",\"\",SUM(W8:AK8)+V8)","v":""},{"$f":"IF(AL8<>\"\",ROUND(1/AL8,1),IF(AL35=\"\",\"\",ROUND(AL35,1)))","v":""},{"$f":"IF(AM8=\"\",\"\",RANK(AM8,AM$7:AM$30))","v":""},null,null,2]
[null,null,3,"","","","","","","","","","","","","","","","",3,3,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL9<>\"\",ROUND(1/AL9,1),IF(AL36=\"\",\"\",ROUND(AL36,1)))","v":""},"",null,null,3]
[null,null,4,"","","","","","","","","","","","","","","","",4,2,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL10<>\"\",ROUND(1/AL10,1),IF(AL37=\"\",\"\",ROUND(AL37,1)))","v":""},"",null,null,4]
[null,null,5,"","","","","","","","","","","","","","","","",5,1,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL11<>\"\",ROUND(1/AL11,1),IF(AL38=\"\",\"\",ROUND(AL38,1)))","v":""},"",null,null,5]
[null,null,6,"","","","","","","","","","","","","","","","",6,0.8,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL12<>\"\",ROUND(1/AL12,1),IF(AL39=\"\",\"\",ROUND(AL39,1)))","v":""},"",null,null,6]
[null,null,7,"","","","","","","","","","","","","","","","",7,0.5,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL13<>\"\",ROUND(1/AL13,1),IF(AL40=\"\",\"\",ROUND(AL40,1)))","v":""},"",null,null,7]
[null,null,8,"","","","","","","","","","","","","","","","",8,0.3,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL14<>\"\",ROUND(1/AL14,1),IF(AL41=\"\",\"\",ROUND(AL41,1)))","v":""},"",null,null,8]
[null,null,9,"","","","","","","","","","","","","","","","",9,0.2,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL15<>\"\",ROUND(1/AL15,1),IF(AL42=\"\",\"\",ROUND(AL42,1)))","v":""},"",null,null,9]
[null,null,10,"","","","","","","","","","","","","","","","",10,0.1,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL16<>\"\",ROUND(1/AL16,1),IF(AL43=\"\",\"\",ROUND(AL43,1)))","v":""},"",null,null,10]
[null,null,11,"","","","","","","","","","","","","","","","",11,0,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL17<>\"\",ROUND(1/AL17,1),IF(AL44=\"\",\"\",ROUND(AL44,1)))","v":""},"",null,null,11]
[null,null,12,"","","","","","","","","","","","","","","","",12,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL18<>\"\",ROUND(1/AL18,1),IF(AL45=\"\",\"\",ROUND(AL45,1)))","v":""},"",null,null,12]
[null,null,13,"","","","","","","","","","","","","","","","",13,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL19<>\"\",ROUND(1/AL19,1),IF(AL46=\"\",\"\",ROUND(AL46,1)))","v":""},"",null,null,13]
[null,null,14,"","","","","","","","","","","","","","","","",14,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL20<>\"\",ROUND(1/AL20,1),IF(AL47=\"\",\"\",ROUND(AL47,1)))","v":""},"",null,null,14]
[null,null,15,"","","","","","","","","","","","","","","","",15,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL21<>\"\",ROUND(1/AL21,1),IF(AL48=\"\",\"\",ROUND(AL48,1)))","v":""},"",null,null,15]
[null,null,16,"","","","","","","","","","","","","","","","",16,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL22<>\"\",ROUND(1/AL22,1),IF(AL49=\"\",\"\",ROUND(AL49,1)))","v":""},"",null,null,16]
[null,null,17,"",{"$f":"IF(OR(E$6=\"\",$D23=\"\"),\"\",IF(LEN($D23)>=E$6,IF(LEFT(RIGHT($D23,E$6),1)=\"x\",\"\",IF(LEFT(RIGHT($D23,E$6),1)=\"0\",10,1*LEFT(RIGHT($D23,E$6),1))),\"\"))","v":""},"","","","","","","","","","","","","","",17,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL23<>\"\",ROUND(1/AL23,1),IF(AL50=\"\",\"\",ROUND(AL50,1)))","v":""},"",null,null,17]
[null,null,18,"","","","","","","","","","","","","","","","",18,null,"",{"$f":"IF(E24=\"\",\"\",$U$32/W$6/E24)","v":""},"","","","","","","","","","","","","","","","",{"$f":"IF(AL24<>\"\",ROUND(1/AL24,1),IF(AL51=\"\",\"\",ROUND(AL51,1)))","v":""},"",null,null,18]
[null,null,19,"","","","","","","","","","","","","","","","",19,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL25<>\"\",ROUND(1/AL25,1),IF(AL52=\"\",\"\",ROUND(AL52,1)))","v":""},"",null,null,19]
[null,null,20,"","","","","","","","","","","","","","","","",20,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL26<>\"\",ROUND(1/AL26,1),IF(AL53=\"\",\"\",ROUND(AL53,1)))","v":""},"",null,null,20]
[null,null,21,"","","","","","","","","","","","","","","","",21,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL27<>\"\",ROUND(1/AL27,1),IF(AL54=\"\",\"\",ROUND(AL54,1)))","v":""},"",null,null,21]
[null,null,22,"","","","","","","","","","","","","","","","",22,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL28<>\"\",ROUND(1/AL28,1),IF(AL55=\"\",\"\",ROUND(AL55,1)))","v":""},"",null,null,22]
[null,null,23,"","","","","","","","","","","","","","","","",23,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL29<>\"\",ROUND(1/AL29,1),IF(AL56=\"\",\"\",ROUND(AL56,1)))","v":""},"",null,null,23]
[null,null,24,"","","","","","","","","","","","","","","","",24,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL30<>\"\",ROUND(1/AL30,1),IF(AL57=\"\",\"\",ROUND(AL57,1)))","v":""},"",null,null,24]
[{"$nulls":20},"weight",{"$nulls":16},{"$f":"SUM(AL7:AL30)","v":0}]
[{"$nulls":20},15,{"$nulls":16},{"$f":"SUM(U7:U10)-4+U11*COUNT(AM7:AM30)","v":14}]
[{"$nulls":18},">",{"$nulls":17},{"$f":"(1-AL31)/AK59","v":{"$error":"#DIV/0!"}},null,"<"]
[{"$nulls":36},{"$f":"IF(AO7>4,AM7,\"\")","v":""},{"$f":"IF(AK34=\"\",\"\",1/(AK$33*AK34))","v":""}]
[{"$nulls":36},{"$f":"IF(AO8>4,AM8,\"\")","v":""},{"$f":"IF(AK35=\"\",\"\",1/(AK$33*AK35))","v":""}]
[{"$nulls":36},{"$f":"IF(AO9>4,AM9,\"\")","v":""},{"$f":"IF(AK36=\"\",\"\",1/(AK$33*AK36))","v":""}]
[{"$nulls":36},{"$f":"IF(AO10>4,AM10,\"\")","v":""},{"$f":"IF(AK37=\"\",\"\",1/(AK$33*AK37))","v":""}]
[{"$nulls":36},{"$f":"IF(AO11>4,AM11,\"\")","v":""},{"$f":"IF(AK38=\"\",\"\",1/(AK$33*AK38))","v":""}]
[{"$nulls":36},{"$f":"IF(AO12>4,AM12,\"\")","v":""},{"$f":"IF(AK39=\"\",\"\",1/(AK$33*AK39))","v":""}]
[{"$nulls":36},{"$f":"IF(AO13>4,AM13,\"\")","v":""},{"$f":"IF(AK40=\"\",\"\",1/(AK$33*AK40))","v":""}]
[{"$nulls":36},{"$f":"IF(AO14>4,AM14,\"\")","v":""},{"$f":"IF(AK41=\"\",\"\",1/(AK$33*AK41))","v":""}]
[{"$nulls":36},{"$f":"IF(AO15>4,AM15,\"\")","v":""},{"$f":"IF(AK42=\"\",\"\",1/(AK$33*AK42))","v":""}]
[{"$nulls":36},{"$f":"IF(AO16>4,AM16,\"\")","v":""},{"$f":"IF(AK43=\"\",\"\",1/(AK$33*AK43))","v":""}]
[{"$nulls":36},{"$f":"IF(AO17>4,AM17,\"\")","v":""},{"$f":"IF(AK44=\"\",\"\",1/(AK$33*AK44))","v":""}]
[{"$nulls":36},{"$f":"IF(AO18>4,AM18,\"\")","v":""},{"$f":"IF(AK45=\"\",\"\",1/(AK$33*AK45))","v":""}]
[{"$nulls":36},{"$f":"IF(AO19>4,AM19,\"\")","v":""},{"$f":"IF(AK46=\"\",\"\",1/(AK$33*AK46))","v":""}]
[{"$nulls":36},{"$f":"IF(AO20>4,AM20,\"\")","v":""},{"$f":"IF(AK47=\"\",\"\",1/(AK$33*AK47))","v":""}]
[{"$nulls":36},{"$f":"IF(AO21>4,AM21,\"\")","v":""},{"$f":"IF(AK48=\"\",\"\",1/(AK$33*AK48))","v":""}]
[{"$nulls":36},{"$f":"IF(AO22>4,AM22,\"\")","v":""},{"$f":"IF(AK49=\"\",\"\",1/(AK$33*AK49))","v":""}]
[{"$nulls":36},{"$f":"IF(AO23>4,AM23,\"\")","v":""},{"$f":"IF(AK50=\"\",\"\",1/(AK$33*AK50))","v":""}]
[{"$nulls":36},{"$f":"IF(AO24>4,AM24,\"\")","v":""},{"$f":"IF(AK51=\"\",\"\",1/(AK$33*AK51))","v":""}]
[{"$nulls":36},{"$f":"IF(AO25>4,AM25,\"\")","v":""},{"$f":"IF(AK52=\"\",\"\",1/(AK$33*AK52))","v":""}]
[{"$nulls":36},{"$f":"IF(AO26>4,AM26,\"\")","v":""},{"$f":"IF(AK53=\"\",\"\",1/(AK$33*AK53))","v":""}]
[{"$nulls":36},{"$f":"IF(AO27>4,AM27,\"\")","v":""},{"$f":"IF(AK54=\"\",\"\",1/(AK$33*AK54))","v":""}]
[{"$nulls":36},{"$f":"IF(AO28>4,AM28,\"\")","v":""},{"$f":"IF(AK55=\"\",\"\",1/(AK$33*AK55))","v":""}]
[{"$nulls":36},{"$f":"IF(AO29>4,AM29,\"\")","v":""},{"$f":"IF(AK56=\"\",\"\",1/(AK$33*AK56))","v":""}]
[{"$nulls":36},{"$f":"IF(AO30>4,AM30,\"\")","v":""},{"$f":"IF(AK57=\"\",\"\",1/(AK$33*AK57))","v":""}]
[{"$nulls":36},{"$f":"IF(AO31>4,AM31,\"\")","v":""},{"$f":"IF(AK58=\"\",\"\",1/(AK$33*AK58))","v":""}]
[{"$nulls":36},{"$f":"SUM(AK35:AK58)","v":0}]

{"sheet":"Sheet10","index":9,"n_rows":59,"n_cols":46,"rows_kept":59,"cut":false,"hidden":false,"merged":[[4,19,4,37],[4,38,4,40],[2,1,2,3],[1,1,1,3],[3,1,3,3]]}
[null,"HELP"]
[null,"FORM Analysis v2.0"]
[null,"02-11-2012",{"$nulls":16},">",{"$nulls":19},"<"]
[null,"Moonee Valley",{"$nulls":43},"FORM"]
[null,"Result",{"$f":"\"F \"&COUNT(AM7:AM30)","v":"F 0"},"Race 10",{"$nulls":15},"Calculations -- hidden for cosmetic reasons",{"$nulls":18},{"$f":"B4&\" \"&D5","v":"Moonee Valley Race 10"},{"$nulls":5},"v","delete if scratched"]
[null,null,"TAB","Form",15,14,13,12,11,10,9,8,7,6,5,4,3,2,1,"Finish Pos","Points","score",{"$f":"E6","v":15},{"$f":"F6","v":14},13,12,11,10,9,8,7,6,{"$f":"O6","v":5},{"$f":"P6","v":4},{"$f":"Q6","v":3},{"$f":"R6","v":2},{"$f":"S6","v":1},"Top 4","Analysis","BM Price","Rank",null,null,">","TAB"]
[null,null,1,{"$f":"IF(AT7=\"\",\"\",AT7)","v":""},{"$f":"IF(OR(E$6=\"\",$D7=\"\"),\"\",IF(LEN($D7)>=E$6,IF(LEFT(RIGHT($D7,E$6),1)=\"x\",\"\",IF(LEFT(RIGHT($D7,E$6),1)=\"0\",10,1*LEFT(RIGHT($D7,E$6),1))),\"\"))","v":""},"","","","","","","","","","","","","","",1,8,{"$f":"IF(D7=\"\",\"\",VLOOKUP(IF(E7=\"\",11,E7),T$7:U$17,2)+VLOOKUP(IF(F7=\"\",11,F7),T$7:U$17,2)+VLOOKUP(IF(G7=\"\",11,G7),T$7:U$17,2)+VLOOKUP(IF(H7=\"\",11,H7),T$7:U$17,2)+VLOOKUP(IF(I7=\"\",11,I7),T$7:U$17,2)+VLOOKUP(IF(J7=\"\",11,J7),T$7:U$17,2)+VLOOKUP(IF(K7=\"\",11,K7),T$7:U$17,2)+VLOOKUP(IF(L7=\"\",11,L7),T$7:U$17,2)+VLOOKUP(IF(M7=\"\",11,M7),T$7:U$17,2)+VLOOKUP(IF(N7=\"\",11,N7),T$7:U$17,2)+VLOOKUP(IF(O7=\"\",11,O7),T$7:U$17,2)+VLOOKUP(IF(P7=\"\",11,P7),T$7:U$17,2)+VLOOKUP(IF(Q7=\"\",11,Q7),T$7:U$17,2)+VLOOKUP(IF(R7=\"\",11,R7),T$7:U$17,2)+VLOOKUP(IF(S7=\"\",11,S7),T$7:U$17,2))","v":""},{"$f":"IF(E7=\"\",\"\",$U$32/W$6/E7)","v":""},"","","","","","","","","","","","","","",{"$f":"IF(AO7>4,\"\",1/(AL$32/VLOOKUP(AO7,T$7:U$11,2)))","v":""},{"$f":"IF(V7=\"\",\"\",SUM(W7:AK7)+V7)","v":""},{"$f":"IF(AL7<>\"\",ROUND(1/AL7,1),IF(AL34=\"\",\"\",ROUND(AL34,1)))","v":""},{"$f":"IF(AM7=\"\",\"\",RANK(AM7,AM$7:AM$30))","v":""},null,null,1]
[null,null,2,{"$f":"IF(AT8=\"\",\"\",AT8)","v":""},"","","","","","","","","","","","","","","",2,5,{"$f":"IF(D8=\"\",\"\",VLOOKUP(IF(E8=\"\",24,E8),T$7:U$17,2)+VLOOKUP(IF(F8=\"\",24,F8),T$7:U$17,2)+VLOOKUP(IF(G8=\"\",24,G8),T$7:U$17,2)+VLOOKUP(IF(H8=\"\",24,H8),T$7:U$17,2)+VLOOKUP(IF(I8=\"\",24,I8),T$7:U$17,2)+VLOOKUP(IF(J8=\"\",24,J8),T$7:U$17,2)+VLOOKUP(IF(K8=\"\",24,K8),T$7:U$17,2)+VLOOKUP(IF(L8=\"\",24,L8),T$7:U$17,2)+VLOOKUP(IF(M8=\"\",24,M8),T$7:U$17,2)+VLOOKUP(IF(N8=\"\",24,N8),T$7:U$17,2)+VLOOKUP(IF(O8=\"\",24,O8),T$7:U$17,2)+VLOOKUP(IF(P8=\"\",24,P8),T$7:U$17,2)+VLOOKUP(IF(Q8=\"\",24,Q8),T$7:U$17,2)+VLOOKUP(IF(R8=\"\",24,R8),T$7:U$17,2)+VLOOKUP(IF(S8=\"\",24,S8),T$7:U$17,2))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AO8>4,\"\",1/(AL$32/VLOOKUP(AO8,T$7:U$11,2)))","v":""},{"$f":"IF(V8=\"\",\"\",SUM(W8:AK8)+V8)","v":""},{"$f":"IF(AL8<>\"\",ROUND(1/AL8,1),IF(AL35=\"\",\"\",ROUND(AL35,1)))","v":""},{"$f":"IF(AM8=\"\",\"\",RANK(AM8,AM$7:AM$30))","v":""},null,null,2]
[null,null,3,"","","","","","","","","","","","","","","","",3,3,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL9<>\"\",ROUND(1/AL9,1),IF(AL36=\"\",\"\",ROUND(AL36,1)))","v":""},"",null,null,3]
[null,null,4,"","","","","","","","","","","","","","","","",4,2,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL10<>\"\",ROUND(1/AL10,1),IF(AL37=\"\",\"\",ROUND(AL37,1)))","v":""},"",null,null,4]
[null,null,5,"","","","","","","","","","","","","","","","",5,1,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL11<>\"\",ROUND(1/AL11,1),IF(AL38=\"\",\"\",ROUND(AL38,1)))","v":""},"",null,null,5]
[null,null,6,"","","","","","","","","","","","","","","","",6,0.8,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL12<>\"\",ROUND(1/AL12,1),IF(AL39=\"\",\"\",ROUND(AL39,1)))","v":""},"",null,null,6]
[null,null,7,"","","","","","","","","","","","","","","","",7,0.5,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL13<>\"\",ROUND(1/AL13,1),IF(AL40=\"\",\"\",ROUND(AL40,1)))","v":""},"",null,null,7]
[null,null,8,"","","","","","","","","","","","","","","","",8,0.3,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL14<>\"\",ROUND(1/AL14,1),IF(AL41=\"\",\"\",ROUND(AL41,1)))","v":""},"",null,null,8]
[null,null,9,"","","","","","","","","","","","","","","","",9,0.2,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL15<>\"\",ROUND(1/AL15,1),IF(AL42=\"\",\"\",ROUND(AL42,1)))","v":""},"",null,null,9]
[null,null,10,"","","","","","","","","","","","","","","","",10,0.1,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL16<>\"\",ROUND(1/AL16,1),IF(AL43=\"\",\"\",ROUND(AL43,1)))","v":""},"",null,null,10]
[null,null,11,"","","","","","","","","","","","","","","","",11,0,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL17<>\"\",ROUND(1/AL17,1),IF(AL44=\"\",\"\",ROUND(AL44,1)))","v":""},"",null,null,11]
[null,null,12,"","","","","","","","","","","","","","","","",12,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL18<>\"\",ROUND(1/AL18,1),IF(AL45=\"\",\"\",ROUND(AL45,1)))","v":""},"",null,null,12]
[null,null,13,"","","","","","","","","","","","","","","","",13,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL19<>\"\",ROUND(1/AL19,1),IF(AL46=\"\",\"\",ROUND(AL46,1)))","v":""},"",null,null,13]
[null,null,14,"","","","","","","","","","","","","","","","",14,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL20<>\"\",ROUND(1/AL20,1),IF(AL47=\"\",\"\",ROUND(AL47,1)))","v":""},"",null,null,14]
[null,null,15,"","","","","","","","","","","","","","","","",15,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL21<>\"\",ROUND(1/AL21,1),IF(AL48=\"\",\"\",ROUND(AL48,1)))","v":""},"",null,null,15]
[null,null,16,"","","","","","","","","","","","","","","",{"$f":"IF(OR(S$6=\"\",$D22=\"\"),\"\",IF(LEN($D22)>=S$6,IF(LEFT(RIGHT($D22,S$6),1)=\"x\",\"\",IF(LEFT(RIGHT($D22,S$6),1)=\"0\",10,1*LEFT(RIGHT($D22,S$6),1))),\"\"))","v":""},16,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL22<>\"\",ROUND(1/AL22,1),IF(AL49=\"\",\"\",ROUND(AL49,1)))","v":""},"",null,null,16]
[null,null,17,"",{"$f":"IF(OR(E$6=\"\",$D23=\"\"),\"\",IF(LEN($D23)>=E$6,IF(LEFT(RIGHT($D23,E$6),1)=\"x\",\"\",IF(LEFT(RIGHT($D23,E$6),1)=\"0\",10,1*LEFT(RIGHT($D23,E$6),1))),\"\"))","v":""},"","","","","","","","","","","","","","",17,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL23<>\"\",ROUND(1/AL23,1),IF(AL50=\"\",\"\",ROUND(AL50,1)))","v":""},"",null,null,17]
[null,null,18,"","","","","","","","","","","","","","","","",18,null,"",{"$f":"IF(E24=\"\",\"\",$U$32/W$6/E24)","v":""},"","","","","","","","","","","","","","","","",{"$f":"IF(AL24<>\"\",ROUND(1/AL24,1),IF(AL51=\"\",\"\",ROUND(AL51,1)))","v":""},"",null,null,18]
[null,null,19,"","","","","","","","","","","","","","","","",19,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL25<>\"\",ROUND(1/AL25,1),IF(AL52=\"\",\"\",ROUND(AL52,1)))","v":""},"",null,null,19]
[null,null,20,"","","","","","","","","","","","","","","","",20,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL26<>\"\",ROUND(1/AL26,1),IF(AL53=\"\",\"\",ROUND(AL53,1)))","v":""},"",null,null,20]
[null,null,21,"","","","","","","","","","","","","","","","",21,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL27<>\"\",ROUND(1/AL27,1),IF(AL54=\"\",\"\",ROUND(AL54,1)))","v":""},"",null,null,21]
[null,null,22,"","","","","","","","","","","","","","","","",22,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL28<>\"\",ROUND(1/AL28,1),IF(AL55=\"\",\"\",ROUND(AL55,1)))","v":""},"",null,null,22]
[null,null,23,"","","","","","","","","","","","","","","","",23,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL29<>\"\",ROUND(1/AL29,1),IF(AL56=\"\",\"\",ROUND(AL56,1)))","v":""},"",null,null,23]
[null,null,24,"","","","","","","","","","","","","","","","",24,null,"","","","","","","","","","","","","","","","","","",{"$f":"IF(AL30<>\"\",ROUND(1/AL30,1),IF(AL57=\"\",\"\",ROUND(AL57,1)))","v":""},"",null,null,24]
[{"$nulls":20},"weight",{"$nulls":16},{"$f":"SUM(AL7:AL30)","v":0}]
[{"$nulls":20},15,{"$nulls":16},{"$f":"SUM(U7:U10)-4+U11*COUNT(AM7:AM30)","v":14}]
[{"$nulls":18},">",{"$nulls":17},{"$f":"(1-AL31)/AK59","v":{"$error":"#DIV/0!"}},null,"<"]
[{"$nulls":36},{"$f":"IF(AO7>4,AM7,\"\")","v":""},{"$f":"IF(AK34=\"\",\"\",1/(AK$33*AK34))","v":""}]
[{"$nulls":36},{"$f":"IF(AO8>4,AM8,\"\")","v":""},{"$f":"IF(AK35=\"\",\"\",1/(AK$33*AK35))","v":""}]
[{"$nulls":36},{"$f":"IF(AO9>4,AM9,\"\")","v":""},{"$f":"IF(AK36=\"\",\"\",1/(AK$33*AK36))","v":""}]
[{"$nulls":36},{"$f":"IF(AO10>4,AM10,\"\")","v":""},{"$f":"IF(AK37=\"\",\"\",1/(AK$33*AK37))","v":""}]
[{"$nulls":36},{"$f":"IF(AO11>4,AM11,\"\")","v":""},{"$f":"IF(AK38=\"\",\"\",1/(AK$33*AK38))","v":""}]
[{"$nulls":36},{"$f":"IF(AO12>4,AM12,\"\")","v":""},{"$f":"IF(AK39=\"\",\"\",1/(AK$33*AK39))","v":""}]
[{"$nulls":36},{"$f":"IF(AO13>4,AM13,\"\")","v":""},{"$f":"IF(AK40=\"\",\"\",1/(AK$33*AK40))","v":""}]
[{"$nulls":36},{"$f":"IF(AO14>4,AM14,\"\")","v":""},{"$f":"IF(AK41=\"\",\"\",1/(AK$33*AK41))","v":""}]
[{"$nulls":36},{"$f":"IF(AO15>4,AM15,\"\")","v":""},{"$f":"IF(AK42=\"\",\"\",1/(AK$33*AK42))","v":""}]
[{"$nulls":36},{"$f":"IF(AO16>4,AM16,\"\")","v":""},{"$f":"IF(AK43=\"\",\"\",1/(AK$33*AK43))","v":""}]
[{"$nulls":36},{"$f":"IF(AO17>4,AM17,\"\")","v":""},{"$f":"IF(AK44=\"\",\"\",1/(AK$33*AK44))","v":""}]
[{"$nulls":36},{"$f":"IF(AO18>4,AM18,\"\")","v":""},{"$f":"IF(AK45=\"\",\"\",1/(AK$33*AK45))","v":""}]
[{"$nulls":36},{"$f":"IF(AO19>4,AM19,\"\")","v":""},{"$f":"IF(AK46=\"\",\"\",1/(AK$33*AK46))","v":""}]
[{"$nulls":36},{"$f":"IF(AO20>4,AM20,\"\")","v":""},{"$f":"IF(AK47=\"\",\"\",1/(AK$33*AK47))","v":""}]
[{"$nulls":36},{"$f":"IF(AO21>4,AM21,\"\")","v":""},{"$f":"IF(AK48=\"\",\"\",1/(AK$33*AK48))","v":""}]
[{"$nulls":36},{"$f":"IF(AO22>4,AM22,\"\")","v":""},{"$f":"IF(AK49=\"\",\"\",1/(AK$33*AK49))","v":""}]
[{"$nulls":36},{"$f":"IF(AO23>4,AM23,\"\")","v":""},{"$f":"IF(AK50=\"\",\"\",1/(AK$33*AK50))","v":""}]
[{"$nulls":36},{"$f":"IF(AO24>4,AM24,\"\")","v":""},{"$f":"IF(AK51=\"\",\"\",1/(AK$33*AK51))","v":""}]
[{"$nulls":36},{"$f":"IF(AO25>4,AM25,\"\")","v":""},{"$f":"IF(AK52=\"\",\"\",1/(AK$33*AK52))","v":""}]
[{"$nulls":36},{"$f":"IF(AO26>4,AM26,\"\")","v":""},{"$f":"IF(AK53=\"\",\"\",1/(AK$33*AK53))","v":""}]
[{"$nulls":36},{"$f":"IF(AO27>4,AM27,\"\")","v":""},{"$f":"IF(AK54=\"\",\"\",1/(AK$33*AK54))","v":""}]
[{"$nulls":36},{"$f":"IF(AO28>4,AM28,\"\")","v":""},{"$f":"IF(AK55=\"\",\"\",1/(AK$33*AK55))","v":""}]
[{"$nulls":36},{"$f":"IF(AO29>4,AM29,\"\")","v":""},{"$f":"IF(AK56=\"\",\"\",1/(AK$33*AK56))","v":""}]
[{"$nulls":36},{"$f":"IF(AO30>4,AM30,\"\")","v":""},{"$f":"IF(AK57=\"\",\"\",1/(AK$33*AK57))","v":""}]
[{"$nulls":36},{"$f":"IF(AO31>4,AM31,\"\")","v":""},{"$f":"IF(AK58=\"\",\"\",1/(AK$33*AK58))","v":""}]
[{"$nulls":36},{"$f":"SUM(AK35:AK58)","v":0}]