{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":9,"comments":1,"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":31,"n_cols":266,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["Meeting","Race Number","Race Name","Distance","Prize Money","Class","Apprentice Claim","Time","Date","Tab Number","Form","Last Finish pos","Last-1 Finish pos","Last-2 Finish pos","Last-3 Finish pos","Horse","BP","Weight","odds","Wrat","Trat","Starts","Wins","Places","win%","Place%","Class Change","Field Strength","Distance Change","Average Prizemoney","Days Since Last Start","Course Wins","Course Places","Course Starts","Distance Wins","Distance Places","Distance Starts","Course/Dist Wins","Course/Dist Places","Course/Dist Starts","Good Wins","Good Places","Good Starts","Dead Wins","Dead Places","Dead Starts","Slow Wins","Slow Places","Slow Starts","Heavy Wins","Heavy Places","Heavy Starts","Wizard Panel","Timeform Panel","Best Form Panel","Recent Form Panel","Distance Panel","Class Panel","Concensus Panel","Concensus Points","Trainer"," age","sex","Jockey","Allowance","Espd","Pace","Impact Form","Impact Fit","Impact Dist","ATPG Age","ATPG Trainer","RFS","1Up Wins","1Up Places","1Up Starts","2Up Wins","2Up Places","2Up Starts","3Up Wins","3Up Places","3Up Starts","4Up Wins","4Up Places","4Up Starts","5Up Wins","5Up Places","5Up Starts","6Up Wins","6Up Places","6Up Starts","7+Up Wins","7+Up Places","7+Up Starts","Cur RFS Wins","Cur RFS Places","Cur RFS Starts","Cur RFS Date1","Cur RFS Base1","Cur RFS WFA1","Cur RFS Date2","Cur RFS Base2","Cur RFS WFA2","Cur RFS Date3","Cur RFS Base3","Cur RFS WFA3","Cur Peak","Cur Peak Date","Last Peak","Last Peak Date","Prev Peak","Prev Peak Date","Dist Peak","Dist Peak Date","Wet Peak","Wet Peak Date","Win Distances","Sim Company Wins","Sim Company Places","Sim Company Starts","Strong Company Wins","Strong Company Places","Strong Company Starts","Last Base Rating","Last WFA Rating","Last Date","Last Finish Pos","Last-1 Base Rating","Last-1 WFA Rating","Last-1 Date","Last-1 Finish Pos","Last-2 Base Rating","Last-2 WFA Rating","Last-2 Date","Last-2 Finish Pos","Last-3 Base Rating","Last-3 WFA Rating","Last-3 Date","Last-3 Finish Pos","Last-4 Base Rating","Last-4 WFA Rating","Last-4 Date","Last-4 Finish Pos","Last-5 Base Rating","Last-5 WFA Rating","Last-5 Date","Last-5 Finish Pos","Last-6 Base Rating","Last-6 WFA Rating","Last-6 Date","Last-6 Finish Pos","Last-7 Base Rating","Last-7 WFA Rating","Last-7 Date","Last-7 Finish Pos","Last Win Base Rating","Last Win WFA Rating","Last Win Date","Last Win-1 Base Rating","Last Win-1 WFA Rating","Last Win-1 Date","Last Win-2 Base Rating","Last Win-2 WFA Rating","Last Win-2 Date","Last Win-3 Base Rating","Last Win-3 WFA Rating","Last Win-3 Date","Last Win-4 Base Rating","Last Win-4 WFA Rating","Last Win-4 Date","Last Win-5 Base Rating","Last Win-5 WFA Rating","Last Win-5 Date","Joc Loc12m Wins","Joc Loc12m Places","Joc Loc12m Starts","Joc Ovrl12m Wins","Joc Ovrl12m Places","Joc Ovrl12m Starts","Joc/Horse Wins","Joc/Horse Places","Joc/Horse Starts","Trn Loc12m Wins","Trn Loc12m Places","Trn Loc12m Starts","Trn Loc5y Wins","Trn Loc5y Places","Trn Loc5y Starts","Trn Ovrl12m Wins","Trn Ovrl12m Places","Trn Ovrl12m Starts","Joc/Trn Wins","Joc/Trn Places","Joc/Trn Starts","Last Dist","Last Margin","Last Weight","Last-1 Dist","Last-1 Margin","Last-1 Weight","Last-2 Dist","Last-2 Margin","Last-2 Weight","Last-3 Dist","Last-3 Margin","Last-3 Weight","Last Crse","Last Class","Last-1 Crse","Last-1 Class","Last-2 Crse","Last-2 Class","Last-3 Crse","Last-3 Class","Sire","Dam","G Sire","Trainer Location","Course Peak","Course Peak Date","Last SP","Last-1 SP","Last-2 SP","Last-3 SP","TAB","A/Odds","%",null,null,"Final","Wrat","Trat","Wizard Panel","Wizard Panel","Timeform Panel","Timeform Panel","Best Form Panel","Best Form Panel","Recent Form Panel","Recent Form Panel","Distance Panel","Distance Panel","Class Panel","Class Panel","Wz points","TF Points","BF Points","RF Points","Dis Points","Cls Points","Concensus Panel","Concensus Points","win Rank","win%","Pl Rank","Place%","Pl Rank","Place%","Wrat","Trat","B/O","sheet order","age/sex"]
[{"$nulls":224},"Notes",{"$nulls":4},"A/Odds Adjusted","Adjusted","Adjusted","Adjusted",null,"Adjusted",null,"Adjusted",null,"Adjusted",null,"Adjusted",null,"Adjusted",{"$nulls":7},"Adjusted",null,"Adjusted",null,"Adjusted",null,"Adjusted",null,{"$f":"100-(MAX(IY3:IY22))","v":0},{"$f":"100-(MAX(IZ3:IZ22))","v":0}]
["MILDURA",5,"MILDURA CUP SEP 1 HCP (58)",1000,15000,"R-58","No Claim","01.55 pm","2013-07-01",1,"'226x",6,2,2,null,"LIMBO DANCER",13,60,6.5,99,96,27,3,12,11,44,"eq",-4,"dn",1589,108,0,0,3,2,6,14,0,0,2,2,8,15,1,3,11,0,1,1,0,0,0,2,2,1,0,4,6,3,7,"S T LANYON",6,"G","J. R. Todd",null,"G2","O2",1.07,0.92,1.05,"A","E",1,0,2,3,0,3,3,2,0,3,0,0,3,1,1,3,0,2,3,0,4,9,0,2,3,"2012-09-22",34,34,"2012-01-01",34,34,"2011-04-08",31.5,32.5,null,null,37,"2013-02-18",34.5,"2012-02-28",34.5,"2012-02-28",31.5,"2012-12-16","975 1000 1400",1,8,14,1,2,8,29,29,"2013-03-15",6,37,37,"2013-02-18",2,33.5,33.5,"2013-02-01",2,31.5,31.5,"2012-12-16",3,33,33,"2012-11-20",2,32.5,32.5,"2012-10-27",5,37,37,"2012-10-20",1,31.5,31.5,"2012-10-08",2,34.5,34.5,"2012-02-28",31.5,32,"2011-06-12",{"$nulls":12},7,15,66,44,113,495,0,0,0,2,3,16,4,19,62,7,9,34,0,0,0,1200,5,60,1115,0.3,59.5,1000,1.5,54.5,1106,2.1,57,"SHIL","R-58","BENA","R-58","ALBY","CL3","BENA","R-58","LORD TED","STORM KITTEN","PRINCE OF BIRDS (USA)","DENILIQUIN",null,null,4.2,4,7,6,1,{"$f":"S3","v":6.5},{"$f":"IF(HR3>0,100/HR3,0)","v":15.384615384615385},{"$f":"IF(HQ3>0,HR3,0)","v":6.5},{"$f":"IF(HT3>0,100/HT3,0)","v":15.384615384615385},{"$f":"IF(HU3>0,100/HU3*$HU$23/$HS$23,\"\")","v":6.5},{"$f":"IF(IY3>=1,SUM(IY3,$IY$2),0)","v":99},{"$f":"IF(IZ3>=1,SUM(IZ3,$IZ$2),0)","v":96},{"$f":"IF(ISNUMBER(HZ3),RANK(HZ3,$HZ$3:$HZ$22,1),\"\")","v":2},{"$f":"IF(AND(HQ3>=1,BA3>=1),BA3,\"\")","v":2},{"$f":"IF(ISNUMBER(IB3),RANK(IB3,$IB$3:$IB$22,1),\"\")","v":2},{"$f":"IF(AND(HQ3>=1,BB3>=1),BB3,\"\")","v":2},{"$f":"IF(ISNUMBER(ID3),RANK(ID3,$ID$3:$ID$22,1),\"\")","v":1},{"$f":"IF(AND(HQ3>=1,BC3>=1),BC3,\"\")","v":1},{"$f":"IF(ISNUMBER(IF3),RANK(IF3,$IF$3:$IF$22,1),\"\")","v":""},{"$f":"IF(AND(HQ3>=1,BD3>=1),BD3,\"\")","v":""},{"$f":"IF(ISNUMBER(IH3),RANK(IH3,$IH$3:$IH$22,1),\"\")","v":4},{"$f":"IF(AND(HQ3>=1,BE3>=1),BE3,\"\")","v":4},{"$f":"IF(ISNUMBER(IJ3),RANK(IJ3,$IJ$3:$IJ$22,1),\"\")","v":6},{"$f":"IF(AND(HQ3>=1,BF3>=1),BF3,\"\")","v":6},{"$f":"IF(HY3=\"\",\"\",IF(HY3=1,3,IF(HY3=2,2,IF(HY3=3,1,\"\"))))","v":2},{"$f":"IF(IA3=\"\",\"\",IF(IA3=1,3,IF(IA3=2,2,IF(IA3=3,1,\"\"))))","v":2},{"$f":"IF(IC3=\"\",\"\",IF(IC3=1,3,IF(IC3=2,2,IF(IC3=3,1,\"\"))))","v":3},{"$f":"IF(IE3=\"\",\"\",IF(IE3=1,3,IF(IE3=2,2,IF(IE3=3,1,\"\"))))","v":""},{"$f":"IF(IG3=\"\",\"\",IF(IG3=1,3,IF(IG3=2,2,IF(IG3=3,1,\"\"))))","v":""},{"$f":"IF(II3=\"\",\"\",IF(II3=1,3,IF(II3=2,2,IF(II3=3,1,\"\"))))","v":""},{"$f":"IF(ISNUMBER(IR3),RANK(IR3,$IR$3:$IR$22,0),\"\")","v":3},{"$f":"IF(SUM(IK3:IP3)>=1,SUM(IK3:IP3),\"\")","v":7},{"$f":"IF(ISNUMBER(IT3),RANK(IT3,$IT$3:$IT$22,0),\"\")","v":7},{"$f":"IF(AND(HQ3>=1,Y3>=1),Y3,\"\")","v":11},{"$f":"IF(ISNUMBER(IV3),RANK(IV3,$IV$3:$IV$22,0),\"\")","v":1},{"$f":"IF(AND(HQ3>=1,Z3>=1),Z3,\"\")","v":44},{"$f":"IF(ISNUMBER(IX3),RANK(IX3,$IX$3:$IX$22,0),\"\")","v":8},{"$f":"IF(AND(HQ3>=1,AD3>=1),AD3,\"\")","v":1589},{"$f":"IF(AND(HQ3>=1,T3>=1),T3,\"\")","v":99},{"$f":"IF(AND(HQ3>=1,U3>=1),U3,\"\")","v":96},3,"A",{"$f":"BJ3&BK3","v":"6G"},"A",1,1]
["MILDURA",5,"MILDURA CUP SEP 1 HCP (58)",1000,15000,"R-58","No Claim","01.55 pm","2013-07-01",2,"'4445",5,4,4,4,"IN SPIRIT",3,59.5,7,94,93,23,2,6,9,26,"eq",-4.5,"dn",1417,14,2,3,8,1,5,11,1,3,5,2,2,10,0,4,11,0,0,2,0,0,0,3,3,4,1,1,2,1,10,"NATHAN HOBSON",4,"G","M. Pegus",null,"M5","O4",1.1299999999999999,1.0900000000000001,0.96,"A","D",7,0,1,3,0,2,3,1,0,2,0,0,2,0,0,2,0,1,2,1,2,9,1,2,9,"2012-08-13",26.5,30,{"$nulls":6},35,"2013-03-30",36,"2012-11-06",28,"2011-12-20",35,"2013-03-30",32,"2013-06-17","1008 1200",1,2,11,0,2,7,32,32,"2013-06-17",5,29.5,29.5,"2013-06-09",4,32.5,33,"2013-04-25",4,31.5,32,"2013-04-08",4,34,35,"2013-03-30",2,31.5,32.5,"2013-03-15",4,31.5,33.5,"2012-12-26",5,30.5,32.5,"2012-12-07",4,33.5,36,"2012-11-06",29.5,33.5,"2012-07-02",{"$nulls":12},21,21,100,44,73,273,0,0,3,2,6,22,4,13,41,3,8,33,0,0,4,1200,2.9,60,975,3.5,58,1200,2.8,58,1000,2.2999999999999998,58,"ECHA","R-58","SHIL","R-62","SHIL","R-62","MILD","R-62","KEEP THE FAITH","SPIRIT OF TUDOR","SNIPPETS","SWAN HILL",36,"2012-11-06",7,13,8,6,2,{"$f":"S4","v":7},14.285714285714286,{"$f":"IF(HQ4>0,HR4,0)","v":7},14.285714285714286,{"$f":"IF(HU4>0,100/HU4*$HU$23/$HS$23,\"\")","v":6.9999999999999991},{"$f":"IF(IY4>=1,SUM(IY4,$IY$2),0)","v":94},{"$f":"IF(IZ4>=1,SUM(IZ4,$IZ$2),0)","v":93},{"$f":"IF(ISNUMBER(HZ4),RANK(HZ4,$HZ$3:$HZ$22,1),\"\")","v":3},{"$f":"IF(AND(HQ4>=1,BA4>=1),BA4,\"\")","v":3},{"$f":"IF(ISNUMBER(IB4),RANK(IB4,$IB$3:$IB$22,1),\"\")","v":3},{"$f":"IF(AND(HQ4>=1,BB4>=1),BB4,\"\")","v":3},{"$f":"IF(ISNUMBER(ID4),RANK(ID4,$ID$3:$ID$22,1),\"\")","v":4},{"$f":"IF(AND(HQ4>=1,BC4>=1),BC4,\"\")","v":4},{"$f":"IF(ISNUMBER(IF4),RANK(IF4,$IF$3:$IF$22,1),\"\")","v":1},{"$f":"IF(AND(HQ4>=1,BD4>=1),BD4,\"\")","v":1},{"$f":"IF(ISNUMBER(IH4),RANK(IH4,$IH$3:$IH$17,1),\"\")","v":1},{"$f":"IF(AND(HQ4>=1,BE4>=1),BE4,\"\")","v":1},{"$f":"IF(ISNUMBER(IJ4),RANK(IJ4,$IJ$3:$IJ$22,1),\"\")","v":2},{"$f":"IF(AND(HQ4>=1,BF4>=1),BF4,\"\")","v":2},{"$f":"IF(HY4=\"\",\"\",IF(HY4=1,3,IF(HY4=2,2,IF(HY4=3,1,\"\"))))","v":1},{"$f":"IF(IA4=\"\",\"\",IF(IA4=1,3,IF(IA4=2,2,IF(IA4=3,1,\"\"))))","v":1},{"$f":"IF(IC4=\"\",\"\",IF(IC4=1,3,IF(IC4=2,2,IF(IC4=3,1,\"\"))))","v":""},{"$f":"IF(IE4=\"\",\"\",IF(IE4=1,3,IF(IE4=2,2,IF(IE4=3,1,\"\"))))","v":3},{"$f":"IF(IG4=\"\",\"\",IF(IG4=1,3,IF(IG4=2,2,IF(IG4=3,1,\"\"))))","v":3},{"$f":"IF(II4=\"\",\"\",IF(II4=1,3,IF(II4=2,2,IF(II4=3,1,\"\"))))","v":2},{"$f":"IF(ISNUMBER(IR4),RANK(IR4,$IR$3:$IR$22,0),\"\")","v":1},{"$f":"IF(SUM(IK4:IP4)>=1,SUM(IK4:IP4),\"\")","v":10},{"$f":"IF(ISNUMBER(IT4),RANK(IT4,$IT$3:$IT$22,0),\"\")","v":11},{"$f":"IF(AND(HQ4>=1,Y4>=1),Y4,\"\")","v":9},{"$f":"IF(ISNUMBER(IV4),RANK(IV4,$IV$3:$IV$22,0),\"\")","v":6},{"$f":"IF(AND(HQ4>=1,Z4>=1),Z4,\"\")","v":26},{"$f":"IF(ISNUMBER(IX4),RANK(IX4,$IX$3:$IX$22,0),\"\")","v":9},{"$f":"IF(AND(HQ4>=1,AD4>=1),AD4,\"\")","v":1417},{"$f":"IF(AND(HQ4>=1,T4>=1),T4,\"\")","v":94},{"$f":"IF(AND(HQ4>=1,U4>=1),U4,\"\")","v":93},1,"B",{"$f":"BJ4&BK4","v":"4G"},"B",2,2]
["MILDURA",5,"MILDURA CUP SEP 1 HCP (58)",1000,15000,"R-58","No Claim","01.55 pm","2013-07-01",3,"'800x",0,0,8,null,"ANOPINION",2,59,26,76,71,9,1,1,11,11,"eq",-5.5,"dn",1278,199,0,0,0,0,1,2,0,0,0,0,0,0,1,1,9,0,0,0,0,0,0,9,11,7,0,9,7,null,null,"FRANK CONLAN",4,"G","Brodie Loy","a0.0","M5","B7",1,0.92,1.05,"A","na",1,0,1,3,0,0,2,1,0,1,0,0,1,0,0,1,0,0,1,0,0,0,0,1,3,"2012-09-09",30,33,"2011-11-09",21.5,30.5,"2011-06-05",10,22.5,null,null,35,"2012-10-15",30.5,"2011-11-09",33,"2012-09-09",null,null,1300,0,0,1,0,0,2,8,10,"2012-12-14",10,16,18,"2012-11-25",11,21.5,24,"2012-11-06",8,32.5,35,"2012-10-15",1,27.5,30.5,"2012-09-30",7,30,33,"2012-09-09",3,13,21,"2011-12-22",7,21.5,30.5,"2011-11-09",7,{"$nulls":18},17,33,146,43,56,291,0,0,0,0,1,1,1,1,4,2,1,10,0,0,0,1314,25,57,1612,15,59,1412,9.4,57.5,1300,3.5,55.5,"PAKM","R-58","KILM","R-62","ECHA","R-62","ECHA","MAIDEN","PINS","MELODY D'AMOUR (NZ)","CENTAINE","KYNETON",null,null,12,10,6.5,21,3,26,3.8461538461538463,26,3.8461538461538463,26,76,71,9,9,11,11,7,7,"","",9,9,7,7,"","","","","","","","",7,11,13,11,11,1278,76,71,null,null,"4G","C",3]
["MILDURA",5,"MILDURA CUP SEP 1 HCP (58)",1000,15000,"R-58","No Claim","01.55 pm","2013-07-01",4,"'165x",5,6,1,null,"DE GREEN D'OR",9,59,6,100,100,3,1,0,33,0,"eq",-4,"eq",4100,167,0,0,0,1,0,3,0,0,0,0,0,1,1,0,2,0,0,0,0,0,0,1,1,6,0,2,3,2,9,"R K POST",4,"G","K. Post",null,"M4","M5",1.1200000000000001,0.92,1.05,"A","B",1,1,0,1,0,0,1,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,"2012-12-09",35,37,{"$nulls":8},37,"2013-01-15",null,null,37,"2013-01-15",null,null,900,0,0,1,0,0,1,35.5,37,"2013-01-15",5,22.5,24.5,"2012-12-30",6,35,37,"2012-12-09",1,{"$nulls":38},13,32,131,19,46,207,1,0,2,4,12,48,31,59,272,4,14,70,4,7,43,1000,2.2999999999999998,59.5,1000,11,58,900,0.4,58,null,null,null,"WNBL","R-58","NARA","R-65","MTGR","MAIDEN",null,null,"GREEN PERFUME (USA)","DEE D'OR","DIEU D'OR","MT GAMBIER",null,null,17,5.5,8,null,4,6,16.666666666666668,6,16.666666666666668,6,100,100,1,1,1,1,6,6,"","",2,2,3,3,3,3,"","",2,1,2,9,1,33,"","",1,4100,100,100,2,"C","4G","D",4]
["MILDURA",5,"MILDURA CUP SEP 1 HCP (58)",1000,15000,"R-58","No Claim","01.55 pm","2013-07-01",5,"'3344",4,4,3,3,"REGAL RUBEN",11,59,16,83,79,43,4,16,9,37,"eq",-5,"eq",1679,12,1,2,5,2,3,11,1,0,1,4,14,33,0,1,6,0,1,3,0,0,1,7,7,3,2,6,1,null,null,"B A MURRAY",6,"G","J. Lyon",null,"G3","O3",1.03,1.1000000000000001,1.05,"A","C",6,0,3,6,1,3,6,0,5,6,1,1,6,1,1,6,1,1,3,0,2,10,1,1,3,"2012-02-10",21,21,"2011-06-11",34,34.5,"2010-05-08",30,35.5,35.5,"2013-04-28",33,"2012-10-19",31.5,"2012-04-29",33,"2012-10-19",null,null,"1100 (2) 1200 1300",1,5,11,2,8,26,29.5,29.5,"2013-06-19",4,30.5,30.5,"2013-05-12",4,35.5,35.5,"2013-04-28",3,34.5,34.5,"2013-04-08",3,31.5,31.5,"2013-02-23",2,31,31,"2012-12-07",3,27.5,27.5,"2012-11-06",5,31,31,"2012-10-27",2,33,33,"2012-10-19",33,34,"2011-05-07",30,35.5,"2010-05-08",25.5,31,"2010-05-01",{"$nulls":6},5,13,64,45,92,439,0,0,0,2,5,17,9,11,65,3,7,21,0,0,0,1050,3.6,57.5,1200,3.6,59.5,1200,0.5,59.5,1200,0.4,57.5,"BLVA","R-62","PAUG","R-61","PAUG","R-61","MILD","R-58","SEQUALO","DISCORD","GILDED TIME (USA)","BROKEN HILL",34.5,"2013-04-08",26,5.5,5.5,4,5,16,6.25,16,6.25,16,83,79,7,7,7,7,3,3,2,2,6,6,1,1,"","",1,2,"",3,4,6,11,9,4,37,7,1679,83,79,4,"D","6G"]
["MILDURA",5,"MILDURA CUP SEP 1 HCP (58)",1000,15000,"R-58","No Claim","01.55 pm","2013-07-01",6,"'66x6",6,6,6,null,"TOUGH LOVE",7,59,31,73,73,8,1,1,13,13,"eq",-5.5,"dn",2163,11,0,0,0,1,0,6,0,0,0,0,0,1,1,0,3,0,1,3,0,0,1,10,9,10,6,5,13,null,null,"R S MCDONALD",4,"H","Ms Michelle Payne",null,"F2","O2",1,0.97,1.05,"A","na",2,0,0,3,1,0,2,0,1,2,0,0,1,0,0,0,0,0,0,0,0,0,1,0,2,"2012-10-07",28.5,31,"2011-12-02",29.5,38,null,null,null,24,"2013-06-20",36,"2012-08-31",40.5,"2011-12-19",38,"2011-12-02",40.5,"2011-12-19",1008,0,1,3,0,0,3,24,24,"2013-06-20",6,29.5,32,"2012-10-13",6,28.5,31,"2012-10-07",6,32.5,36,"2012-08-31",10,29.5,37,"2012-01-08",8,32.5,40.5,"2011-12-19",2,29.5,38,"2011-12-02",1,21,30,"2011-11-17",4,{"$nulls":18},3,15,47,27,82,262,0,0,0,0,0,7,2,3,21,8,9,53,0,0,1,1100,8.5,57.5,1175,3.8,58,1000,6.3,59,1000,4.2,59.5,"BALT","R-62","MANG","R-62","BARN","R-62","GEET","R-62","BLACK HAWK (GB)","CYBELE","RUSTIC AMBER (IRE)","CAULFIELD",null,null,13,3.7,7.5,10,6,31,3.225806451612903,31,3.225806451612903,31.000000000000004,73,73,10,10,9,9,10,10,6,6,5,5,13,13,"","","","","","","","",4,13,12,13,3,2163,73,73,null,null,"4H"]
["MILDURA",5,"MILDURA CUP SEP 1 HCP (58)",1000,15000,"R-58","No Claim","01.55 pm","2013-07-01",7,"'x690",0,9,6,null,"DE LADY ROYALE",10,58,81,64,63,10,2,2,20,20,"dn",-9,"dn",2140,14,0,0,0,2,2,9,0,0,0,1,0,4,1,0,3,0,1,2,0,1,1,13,13,15,5,13,15,null,null,"M T LEONARD",6,"M","Jacob Rule",null,"G4","O4",0.94,1.1399999999999999,1.02,"B","na",4,0,1,3,0,1,3,1,0,2,1,0,1,0,0,1,0,0,0,0,0,0,1,0,1,"2010-12-04",38.5,41,{"$nulls":6},31,"2013-05-14",35,"2011-04-29",41,"2010-12-04",41,"2010-12-04",37.5,"2010-11-01","1100 (2)",0,0,1,0,0,5,27,27,"2013-06-17",10,29,29,"2013-05-26",9,31,31,"2013-05-14",6,28.5,29.5,"2011-05-13",12,34,35,"2011-04-29",9,27,29.5,"2010-12-18",10,38.5,41,"2010-12-04",1,37.5,40,"2010-11-19",1,{"$nulls":18},22,16,105,40,50,300,0,0,0,0,0,0,1,1,3,0,0,0,0,0,0,1100,7.6,54,1000,6.6,57.5,1000,5.2,56,1000,7.3,57.5,"ECHA","R-68","CRAN","R-62","GEET","R-68","GEET","FM-68","DELAGO BROM","COUNTY ROYALE","COUNTY","BALLARAT",null,null,31,51,51,12,7,81,1.2345679012345678,81,1.2345679012345678,81,64,63,13,13,13,13,15,15,5,5,13,13,15,15,"","","","","","","","",2,20,9,20,4,2140,64,63,null,null,"6M"]
["MILDURA",5,"MILDURA CUP SEP 1 HCP (58)",1000,15000,"R-58","No Claim","01.55 pm","2013-07-01",8,"'2209",9,0,2,2,"HALO DOT COM",4,58,13,84,80,33,3,14,9,42,"eq",-6,"dn",1409,43,0,0,1,2,7,18,0,0,0,2,2,6,0,9,16,1,1,7,0,2,4,6,6,5,8,8,5,null,null,"R D DANIEL",6,"M","J. Keating",null,"G3","O3",0.94,1.02,1.02,"B","A",9,1,1,5,0,4,4,0,2,4,1,2,4,0,2,4,1,1,3,0,2,9,0,0,2,"2012-07-16",22,22,"2011-07-03",29.5,30,null,null,null,35,"2013-03-16",34,"2012-07-07",34.5,"2011-04-16",34,"2012-04-01",34.5,"2011-04-16","900 1100 1200",1,3,9,1,3,9,16,16,"2013-05-19",9,19,19,"2013-05-02",10,32.5,32.5,"2013-04-25",2,31,31,"2013-03-23",2,35,35,"2013-03-16",1,31.5,31.5,"2013-03-09",3,26,26,"2013-02-21",3,32.5,32.5,"2013-02-03",1,33,34,"2011-05-20",{"$nulls":15},1,7,34,8,32,135,0,0,0,7,16,47,25,46,244,17,29,107,0,0,2,1200,14,57.5,1400,15,54,1200,3,57,1200,2.5,55.5,"MTGR","FM-65","WNBL","FM-82","AVCA","R-62","EDEN","R-68","HALO HOMEWRECKER (USA)","COMAAGE","AT TALAQ (USA)","HAMILTON",22,"2012-07-16",7,41,5.5,2.5,8,13,7.6923076923076925,13,7.6923076923076925,13,84,80,6,6,6,6,5,5,8,8,8,8,5,5,"","","","","","","","",11,9,2,42,10,1409,84,80,null,null,"6M"]
["MILDURA",5,"MILDURA CUP SEP 1 HCP (58)",1000,15000,"R-58","No Claim","01.55 pm","2013-07-01",9,"'381x",1,8,3,null,"HOLLY CAN DO",6,58,11,87,87,11,1,1,9,9,"up",-1,"eq",1136,206,1,0,4,1,1,7,1,0,3,1,0,4,0,1,7,0,0,0,0,0,0,5,5,13,0,12,12,null,null,"T E MATTHEWS",5,"M","Ms H. Mc Kechnie",null,"G2","O2",1.22,0.89,1.05,"B","na",1,0,0,2,0,1,2,0,0,2,1,0,2,0,0,1,0,0,1,0,0,1,0,0,2,"2012-10-29",27,27,"2012-02-14",22.5,24.5,{"$nulls":5},32.5,"2012-12-07",29.5,"2012-05-19",32.5,"2012-12-07",null,null,1000,0,0,0,0,0,0,32.5,32.5,"2012-12-07",1,24.5,24.5,"2012-12-02",8,24,24,"2012-11-20",3,27,27,"2012-10-29",5,15.5,16,"2012-06-25",14,25.5,26,"2012-06-18",4,28.5,29,"2012-06-08",5,28.5,29.5,"2012-05-19",7,{"$nulls":18},28,46,214,58,100,455,0,0,1,1,0,3,2,0,17,1,0,3,0,0,0,1000,0.2,56.5,1200,6,56.5,1009,6.8,56,975,4,56.5,"MILD","MAIDEN","SHIL","MAIDEN","ECHA","FM-MDN","SHIL","MAIDEN","ALL CHATTER (USA)","ANN MARY (NZ)","GLEAM MACHINE (USA)","SWAN HILL",32.5,"2012-12-07",7,13,31,13,9,11,9.0909090909090917,11,9.0909090909090917,10.999999999999996,87,87,5,5,5,5,13,13,"","",12,12,12,12,"","","","","","","","",11,9,14,9,12,1136,87,87,null,null,"5M"]
["MILDURA",5,"MILDURA CUP SEP 1 HCP (58)",1000,15000,"R-58","No Claim","01.55 pm","2013-07-01",10,"'x608",8,0,6,null,"JULIA JEAN",8,58,126,62,61,23,3,6,13,26,"eq",-5.5,"dn",1961,23,3,3,11,2,5,20,2,2,9,1,2,6,2,2,13,0,2,3,0,0,1,14,15,11,3,11,14,null,null,"J K CASTLEMAN",6,"M","Ms C. Puls",null,"M4","M5",0.83,1.1299999999999999,1.02,"B","E",4,1,2,7,1,0,5,0,2,4,1,0,1,0,0,1,0,1,1,0,1,4,1,0,1,"2011-04-03",35.5,36.5,{"$nulls":6},32,"2013-04-08",30,"2012-10-19",37,"2012-04-16",37,"2012-04-16",null,null,"1000 (2) 1200",2,1,9,0,2,8,27,27,"2013-06-08",8,10.5,10.5,"2013-04-30",14,32,32,"2013-04-08",6,28.5,28.5,"2012-10-29",6,30,30,"2012-10-19",8,37,37,"2012-04-16",1,26,26,"2011-08-29",9,36,36,"2011-08-15",4,35.5,36.5,"2011-04-03",32,37,"2010-06-21",{"$nulls":12},6,14,85,9,30,186,0,0,0,0,3,24,11,41,193,1,4,28,0,0,0,1200,6.8,57,1100,19,57.5,1000,2.5,56.5,975,6.7,55,"SHIL","R-62","WNBL","R-62","MILD","R-62","SHIL","BM-72","DOLPHIN STREET (FR)","LUST FOR SPRING","MUSTIN LAKE (USA)","MILDURA",37,"2012-04-16",26,31,6,8,10,126,0.79365079365079361,126,0.79365079365079361,126,62,61,14,14,15,15,11,11,3,3,11,11,14,14,"","","",1,"","",6,1,4,13,6,26,5,1961,62,61,null,null,"6M"]
["MILDURA",5,"MILDURA CUP SEP 1 HCP (58)",1000,15000,"R-58","No Claim","01.55 pm","2013-07-01",11,"'15x9",9,5,1,null,"MAGNUS BELLE",15,58,8.5,90,88,8,1,3,13,38,"eq",-5,"eq",2375,22,1,0,1,1,3,7,1,0,1,1,1,3,0,2,5,0,0,0,0,0,0,4,4,12,7,3,4,null,null,"D K WEIR",3,"F","D. Yendall",null,"F1","O1",0.71,0.74,0.88,"D","A",2,0,1,2,0,0,1,0,0,1,0,1,1,0,1,1,1,0,1,0,0,1,0,0,1,"2012-09-07",24,30,{"$nulls":6},19.5,"2013-06-09",36.5,"2012-10-08",null,null,36.5,"2012-10-08",null,null,1000,0,0,1,0,0,1,19,19.5,"2013-06-09",9,29,34,"2012-11-06",5,30,35.5,"2012-10-19",1,31,36.5,"2012-10-08",3,29,35,"2012-09-30",2,28,34,"2012-09-15",5,24,30,"2012-09-07",5,22.5,29,"2012-08-13",3,{"$nulls":18},27,33,116,151,230,853,0,1,2,28,46,153,125,189,711,192,350,1225,65,95,309,975,12,57,1009,5,54,1000,6,51,1000,1.1000000000000001,57,"SHIL","R-62","ECHA","R-68","MILD","MAIDEN","DOND","3F-MDN","MAGNUS","MARTHA","HIGH YIELD (USA)","BALLARAT",35.5,"2012-10-19",7,5,1.4,4.2,11,8.5,11.764705882352942,8.5,11.764705882352942,8.5,90,88,4,4,4,4,12,12,7,7,3,3,4,4,"","","","",1,"",6,1,4,13,3,38,2,2375,90,88,null,null,"3F"]
["MILDURA",5,"MILDURA CUP SEP 1 HCP (58)",1000,15000,"R-58","No Claim","01.55 pm","2013-07-01",12,"'8008",8,0,0,8,"SEULAMONT",14,58.5,51,68,70,27,3,6,11,22,"eq",-4.5,"dn",852,7,0,1,1,0,0,2,0,0,0,1,4,12,2,2,13,0,0,2,0,0,0,12,12,2,4,15,8,null,null,"C V KELLY",5,"G","Jordan Childs","a0.0","M7","M7",1.02,1.02,0.96,"A","D",14,0,1,4,1,0,3,0,0,3,0,1,3,0,0,2,2,0,2,0,4,10,0,0,0,{"$nulls":9},38,"2012-10-07",38.5,"2012-06-18",34,"2011-04-04",25.5,"2013-04-30",32.5,"2011-05-29","1200 1284 1300",2,1,9,0,4,7,24.5,24.5,"2013-06-24",8,26.5,26.5,"2013-06-08",12,25.5,25.5,"2013-04-30",11,25.5,25.5,"2013-03-25",8,22.5,22.5,"2013-03-16",6,30,30,"2013-01-26",3,36,36,"2013-01-10",3,36,36,"2012-12-26",1,38,38,"2012-10-07",34,35,"2012-04-25",{"$nulls":12},4,8,21,34,70,281,0,0,0,3,9,43,19,44,197,8,21,85,1,1,2,1200,6.5,56,1200,7.5,58,1100,8.8000000000000007,58.5,1350,9,59,"ECHA","R-58","SHIL","R-62","WNBL","R-62","DOND","R-62","SEUL AMOUR (NZ)","COSSACK ANTHEM","COSSACK WARRIOR","SWAN HILL",38.5,"2012-06-18",26,41,101,21,12,51,1.9607843137254901,51,1.9607843137254901,51,68,70,12,12,12,12,2,2,4,4,15,15,8,8,"","",2,"","","",5,2,7,11,8,22,14,852,68,70,null,null,"5G"]
["MILDURA",5,"MILDURA CUP SEP 1 HCP (58)",1000,15000,"R-58","No Claim","01.55 pm","2013-07-01",13,"'2510",0,1,5,2,"COUNT CYCLONE",5,58.5,21,79,78,45,5,9,11,20,"eq",-4.5,"eq",958,45,0,0,3,5,9,41,0,0,3,4,4,24,1,3,14,0,1,3,0,1,4,8,8,9,9,10,10,null,null,"A R COFFEY",7,"G","H. Coffey","a0.0","G3","M4",1.17,0.87,1.02,"C","A",11,0,1,6,0,1,6,0,1,6,1,1,5,1,1,5,1,0,3,2,4,14,0,1,1,"2011-12-10",26,26,{"$nulls":6},32.5,"2013-04-25",31,"2011-10-10",31,"2011-01-25",32.5,"2013-04-25",18.5,"2011-11-27","900 (2) 975 1000 (2)",1,2,12,2,2,23,14.5,14.5,"2013-05-17",12,32.5,32.5,"2013-04-25",1,23,23,"2013-02-23",5,28,28,"2013-01-01",2,23.5,23.5,"2012-12-26",6,32.5,32.5,"2012-12-08",1,20,20,"2012-11-06",4,27.5,27.5,"2012-11-03",4,30.5,30.5,"2011-11-19",37.5,41,"2009-09-01",32,36,"2009-08-04",{"$nulls":9},16,43,147,49,98,415,1,3,7,7,18,69,53,82,387,12,31,116,5,19,66,1000,15,58.5,975,4.8,55,1000,5.5,52.5,1000,3,55,"GEET","R-58","SHIL","R-58","BALD","BM-55","BRBT","R-58","VISCOUNT","PRINCESS TINKABELL","ZEDITAVE","SWAN HILL",31,"2011-06-20",5,13,4.5,11,13,21,4.7619047619047619,21,4.7619047619047619,21,79,78,8,8,8,8,9,9,9,9,10,10,10,10,"","","","","","","","",7,11,9,20,13,958,79,78,null,null,"7G"]
["MILDURA",5,"MILDURA CUP SEP 1 HCP (58)",1000,15000,"R-58","No Claim","01.55 pm","2013-07-01",14,"'837x",7,3,8,null,"ARTISTIC",12,58,41,70,72,22,3,4,14,18,"eq",-3.5,"eq",1895,67,0,1,2,2,2,7,0,0,0,2,4,14,1,0,5,0,0,1,0,0,2,11,10,8,0,7,9,null,null,"C V KELLY",5,"G",null,null,"G4","M4",0.97,0.92,1.05,"A","D",1,1,1,4,0,0,3,1,1,2,0,1,2,0,0,2,1,0,2,0,1,7,1,1,4,"2012-09-29",32,32,"2012-02-23",36.5,38,"2011-01-28",36.5,44,null,null,35,"2012-11-24",39.5,"2012-05-01",39.5,"2012-05-01",37.5,"2012-06-24","1000 1100 1250",1,0,5,1,4,15,23.5,23.5,"2013-04-25",7,21.5,21.5,"2013-03-16",3,31,31,"2013-02-23",8,26,26,"2013-01-18",8,32.5,32.5,"2012-12-26",6,30.5,30.5,"2012-12-07",5,35,35,"2012-11-24",1,33,33,"2012-11-17",4,38.5,39.5,"2012-05-01",36.5,44,"2011-01-28",{"$nulls":12},0,0,0,0,0,0,0,0,0,3,9,43,19,44,197,8,21,85,0,0,0,975,8.8000000000000007,58.5,1400,8.5,52,1400,3,52,1109,7.4,54.5,"SHIL","R-58","BHIL","BM-64","BALD","BM-70","STAW","R-68","SHAMARDAL (USA)","SPLASH OF COLOUR (NZ)","FUSAICHI PEGASUS (USA)","SWAN HILL",38.5,"2012-05-20",12,6,17,31,14,41,2.4390243902439024,41,2.4390243902439024,40.999999999999993,70,72,11,11,10,10,8,8,"","",7,7,9,9,"","","","","","","","",3,14,11,18,6,1895,70,72,null,null,"5G"]
["MILDURA",5,"MILDURA CUP SEP 1 HCP (58)",1000,15000,"R-58","No Claim","01.55 pm","2013-07-01",15,"'685x",5,8,6,null,"REGAL MONTY",1,54.5,151,60,62,13,1,4,8,31,"eq",-5,"eq",846,187,0,0,0,1,3,11,0,0,0,1,2,4,0,1,8,0,1,1,0,0,0,15,14,14,0,14,11,null,null,"KAYE EDWARDS",6,"M",null,null,"F1","F1",0.79,0.67,1.05,"B","E",1,0,1,3,0,2,3,1,0,2,0,1,2,0,0,2,0,0,1,0,0,0,0,1,3,"2012-10-07",23,23,"2012-04-07",28.5,28.5,"2011-10-30",29.5,29.5,null,null,30.5,"2012-12-26",37,"2012-05-20",33,"2012-05-06",37,"2012-05-20",1100,0,2,4,0,0,4,30.5,30.5,"2012-12-26",5,28,28,"2012-11-11",8,29,29,"2012-11-03",6,30.5,30.5,"2012-10-21",2,23,23,"2012-10-07",8,21,21,"2012-06-27",11,30.5,30.5,"2012-05-31",7,37,37,"2012-05-20",2,33,33,"2012-05-06",{"$nulls":15},0,0,0,0,0,0,0,0,0,1,3,15,2,8,37,1,3,22,0,0,0,1000,4.3,55,1100,5.4,54,1100,6.6,55,1000,3.5,54.5,"PENS","R-62","PENO","R-65","MORT","R-68","NARA","R-61","REGAL SHOT","MONTENIQUE","NOALCOHOLIC (FR)","CASTERTON",null,null,15,11,11,10,15,151,0.66225165562913912,151,0.66225165562913912,151,60,62,15,15,14,14,14,14,"","",14,14,11,11,"","","","","","","","",15,8,5,31,15,846,60,62,null,null,"6M"]
[{"$nulls":224},16,0,0,0,0,"",0,0,"","","","","","","","",null,"","","","","","","","","","","","","","","","","","","",null,null,""]
[{"$nulls":224},17,{"$f":"W27","v":0},0,0,0,"",0,0,"","","","","","","","",null,"","","","","","","","","","","","","","","","","","","",null,null,""]
[{"$nulls":224},18,{"$f":"T28","v":0},0,0,0,"",0,0,"","","","","","","","",null,"","","","","","","","","","","","","","","","","","","",null,null,""]
[{"$nulls":224},19,{"$f":"T29","v":0},0,0,0,"",0,0,"","","","","","","","",null,"","","","","","","","","","","","","","","","","","","",null,null,""]
[{"$nulls":224},20,0,0,0,0,"",0,0,"","","","","","","","",null,"","","","","","","","","","","","","","","","","","","",null,null,""]
[{"$nulls":226},{"$f":"SUM(HS3:HS22)","v":100.05906311672146},null,{"$f":"SUM(HU3:HU22)","v":100.05906311672146},{"$nulls":31},"will have to put here B/O manually as for equals cause problems"]
[{"$nulls":260},"This will be the trigger that says on the next page \"Copy the info from this line\""]
[]
[]
[{"$nulls":57},"c"]
[]
[]
["We delete from cell A3 across to HQ leaving HQ and down. We then copy the race from the csv files from A to HP and paste in at A3."]
["When we delete a TAB# in col HQ then the following columns all adjust accordingly.   Then we have transfer the info to sheet 2 , saying if col JA =1-4 (or E1,E2,E3) then copy the data into the relevant col for the sheet. Instead of col S (T,U etc) the data will transfer from (the adjusted columns)  HV to JA. "]

{"sheet":"Sheet2","index":1,"n_rows":175,"n_cols":49,"rows_kept":175,"cut":false,"hidden":false,"merged":[]}
["DATE","DAY","TRACK","CODE","WK","GDSH","DIST","F/SZ","TYPE","P/M","GRADE","SEQ","=<$6","OP/F","F/Y/N","RACE","TAB.","SKY","B/F","R/F","DIST","CLS","T/RAT","MENT","W/RAT","B/OV","PNTS","FAV","W-PL","BO3","VIC/T","SYD/T","CNT/BEST","PLC/DIV","WIZ *","OPEN","T/FLUC","S/PR","OV/SA/UN","EA/SA/ST","ST-5","R.T.C.","BARR","AGE","DAYS","A.P.I","W%","PL%","RACES"]
["AUTO","DROP","AUTO","AUTO","FILL","DROP","AUTO","AUTO","AUTO","AUTO","DROP","FILL","DROP","DROP","DROP","AUTO"]
[{"$f":"Sheet1!I3","v":"2013-07-01"},"MONDAY ",{"$f":"Sheet1!A3","v":"MILDURA"},{"$f":"VLOOKUP($C$3,$I$64:$J$200,2,FALSE)","v":"VC"},"18","H9",{"$f":"Sheet1!D3","v":1000},{"$f":"COUNT(Sheet1!HY3:HY22)","v":15},{"$f":"Sheet1!F3","v":"R-58"},{"$f":"Sheet1!E3/1000","v":15},"FAIR",1419,5,"3M","YES",{"$f":"Sheet1!B3","v":5},"1",1,1,1,2,1,1,{"$f":"COUNTIF(R3:W3,\"=1\")","v":5},"100","1","17","1","1ST",2.2999999999999998,2.2999999999999998,2.2999999999999998,2.2999999999999998,1.2,1.9,2.4,2.4,"EASE","3432","5","1","4H","14","2",null,"1",{"$f":"IF(SUMPRODUCT(($C$2:$C2=C3)*($L$2:$L2=L3))>1,0,1)","v":1}]
["AUTO","AUTO","AUTO","AUTO","AUTO","AUTO","AUTO","AUTO","AUTO","AUTO","AUTO","AUTO","AUTO","AUTO","AUTO","AUTO","AUTO","AUTO","AUTO","AUTO","AUTO","AUTO","AUTO","AUTO","AUTO","AUTO","AUTO"]
["DATE","DAY","TRACK","CODE","WK","GDSH","DIST","F/SZ","TYPE","P/M","A/F/P","SEQ","=<$6","OP/F","F/Y/N","RACE","TAB.","SKY","B/F","R/F","DIST","CLS","T/RAT","MENT","W/RAT","B/OV","PNTS","FAV","W-PL","B/DIV","VIC/T","SYD/T","CNT/BEST","PLC/DIV","OPEN","T/FLUC","S/PR","F/E/S","ST-5","R.T.C.","BARR","AGE","DAYS","A.P.I","W%","PL%","RACES"]
[{"$f":"$A$3","v":"2013-07-01"},{"$f":"IF($B$3=\"\",\"\",$B$3)","v":"MONDAY "},{"$f":"IF($C$3=\"\",\"\",$C$3)","v":"MILDURA"},{"$f":"IF($D$3=\"\",\"\",$D$3)","v":"VC"},{"$f":"IF($E$3=\"\",\"\",$E$3)","v":"18"},{"$f":"IF($F$3=\"\",\"\",$F$3)","v":"H9"},{"$f":"IF($G$3=\"\",\"\",$G$3)","v":1000},{"$f":"IF($H$3=\"\",\"\",$H$3)","v":15},{"$f":"IF($I$3=\"\",\"\",$I$3)","v":"R-58"},{"$f":"IF($J$3=\"\",\"\",$J$3)","v":15},{"$f":"IF($K$3=\"\",\"\",$K$3)","v":"FAIR"},{"$f":"$L$3","v":1419},{"$f":"IF($M$3=\"\",\"\",$M$3)","v":5},{"$f":"IF($N$3=\"\",\"\",$N$3)","v":"3M"},{"$f":"IF($O$3=\"\",\"\",$O$3)","v":"YES"},{"$f":"IF($P$3=\"\",\"\",$P$3)","v":5},{"$f":"IFERROR(INDEX(Sheet1!$J$3:$J$22,MATCH(Sheet1!$JD$3,Sheet1!$JB$3:$JB$22,0),1),\"\")","v":1},{"$f":"IF(SUMPRODUCT((Sheet1!$HY$3:$HY$22<=4)*(Sheet1!JD3:$JD$22=A))=0,\"\",SUMPRODUCT((Sheet1!$HY$3:$HY$22<=4)*(Sheet1!$JB$3:$JB$22=A)*(Sheet1!$HY$3:$HY$22)))","v":{"$error":"#NAME?"}},{"$f":"(IF($E$7=Q6,1,IF($E$8=Q6,2,\"\")))","v":""},{"$f":"(IF($F$7=Q6,1,IF($F$8=Q6,2,\"\")))","v":""},{"$f":"(IF($G$7=Q6,1,IF($G$8=Q6,2,\"\")))","v":""},{"$f":"(IF($H$7=Q6,1,IF($H$8=Q6,2,\"\")))","v":""},{"$f":"(IF($I$7=Q6,1,IF($I$8=Q6,2,\"\")))","v":""},{"$f":"COUNTIF(R6:W6,\"=1\")","v":0},"100",{"$f":"$AA$7","v":{"$error":"#REF!"}},{"$f":"IF(MATCH(Q6,#REF!,0),#REF!)","v":{"$error":"#REF!"}},"1","1ST",2.2999999999999998,2.2999999999999998,2.2999999999999998,2.2999999999999998,1.2,1.9,2.4,2.4,"EASE","3432","5","1","4H","14","2",null,"1",{"$f":"IF(SUMPRODUCT(($C$2:$C2=C6)*($L$2:$L2=L6))>1,0,1)","v":1}]
[{"$f":"$A$3","v":"2013-07-01"},{"$f":"IF($B$3=\"\",\"\",$B$3)","v":"MONDAY "},{"$f":"IF($C$3=\"\",\"\",$C$3)","v":"MILDURA"},{"$f":"IF($D$3=\"\",\"\",$D$3)","v":"VC"},{"$f":"IF($E$3=\"\",\"\",$E$3)","v":"18"},{"$f":"IF($F$3=\"\",\"\",$F$3)","v":"H9"},{"$f":"IF($G$3=\"\",\"\",$G$3)","v":1000},{"$f":"IF($H$3=\"\",\"\",$H$3)","v":15},{"$f":"IF($I$3=\"\",\"\",$I$3)","v":"R-58"},{"$f":"IF($J$3=\"\",\"\",$J$3)","v":15},{"$f":"IF($K$3=\"\",\"\",$K$3)","v":"FAIR"},{"$f":"$L$3","v":1419},{"$f":"IF($M$3=\"\",\"\",$M$3)","v":5},{"$f":"IF($N$3=\"\",\"\",$N$3)","v":"3M"},{"$f":"IF($O$3=\"\",\"\",$O$3)","v":"YES"},{"$f":"IF($P$3=\"\",\"\",$P$3)","v":5},{"$f":"IFERROR(INDEX(Sheet1!$J$3:$J$22,MATCH(Sheet1!$JD$4,Sheet1!$JB$3:$JB$22,0),1),\"\")","v":2},{"$f":"IFERROR(INDEX(Sheet1!$HY$3:$HY$22,MATCH(Sheet1!$JD$4,Sheet1!$JB$3:$JB$22,0),1),\"\")","v":3},{"$f":"(IF($E$7=Q7,1,IF($E$8=Q7,2,\"\")))","v":""},{"$f":"(IF($F$7=Q7,1,IF($F$8=Q7,2,\"\")))","v":""},{"$f":"(IF($G$7=Q7,1,IF($G$8=Q7,2,\"\")))","v":""},{"$f":"(IF($H$7=Q7,1,IF($H$8=Q7,2,\"\")))","v":""},{"$f":"(IF($I$7=Q7,1,IF($I$8=Q7,2,\"\")))","v":""},{"$f":"COUNTIF(R7:W7,\"=1\")","v":0},null,{"$f":"$AA$8","v":{"$error":"#REF!"}},{"$f":"IF(MATCH(Q7,#REF!,0),#REF!)","v":{"$error":"#REF!"}},{"$nulls":19},{"$f":"IF(SUMPRODUCT(($C$2:$C3=C7)*($L$2:$L3=L7))>1,0,1)","v":1},null,{"$f":"IF(SUMPRODUCT(($C$7:$C7=C7)*($L$7:$L7=L7))>1,0,1)","v":1}]
["2013-07-01","MONDAY ","MILDURA","VC","18","H9",1000,15,"R-58",15,"FAIR",1419,5,"3M","YES",5,{"$f":"IFERROR(INDEX(Sheet1!$J$3:$J$22,MATCH(Sheet1!$JD$5,Sheet1!$JB$3:$JB$22,0),1),\"\")","v":4},{"$f":"IFERROR(INDEX(Sheet1!$HY$3:$HY$22,MATCH(Sheet1!$JD$5,Sheet1!$JB$3:$JB$22,0),1),\"\")","v":1},{"$f":"(IF($E$7=Q8,1,IF($E$8=Q8,2,\"\")))","v":""},{"$f":"(IF($F$7=Q8,1,IF($F$8=Q8,2,\"\")))","v":""},{"$f":"(IF($G$7=Q8,1,IF($G$8=Q8,2,\"\")))","v":""},{"$f":"(IF($H$7=Q8,1,IF($H$8=Q8,2,\"\")))","v":""},{"$f":"(IF($I$7=Q8,1,IF($I$8=Q8,2,\"\")))","v":""},{"$f":"COUNTIF(R8:W8,\"=1\")","v":1},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(MATCH(Q8,#REF!,0),#REF!)","v":{"$error":"#REF!"}},{"$nulls":19},{"$f":"IF(SUMPRODUCT(($C$2:$C4=C8)*($L$2:$L4=L8))>1,0,1)","v":1},"1",{"$f":"IF(SUMPRODUCT(($C$7:$C8=C8)*($L$7:$L8=L8))>1,0,1)","v":0}]
["2013-07-01","MONDAY ","MILDURA","VC","18","H9",1000,15,"R-58",15,"FAIR",1419,5,"3M","YES",5,{"$f":"IFERROR(INDEX(Sheet1!$J$3:$J$22,MATCH(Sheet1!$JD$6,Sheet1!$JB$3:$JB$22,0),1),\"\")","v":5},{"$f":"IFERROR(INDEX(Sheet1!$HY$3:$HY$22,MATCH(Sheet1!$JD$6,Sheet1!$JB$3:$JB$22,0),1),\"\")","v":7},{"$f":"(IF($E$7=Q9,1,IF($E$8=Q9,2,\"\")))","v":""},{"$f":"(IF($F$7=Q9,1,IF($F$8=Q9,2,\"\")))","v":""},{"$f":"(IF($G$7=Q9,1,IF($G$8=Q9,2,\"\")))","v":""},{"$f":"(IF($H$7=Q9,1,IF($H$8=Q9,2,\"\")))","v":""},{"$f":"(IF($I$7=Q9,1,IF($I$8=Q9,2,\"\")))","v":""},{"$f":"COUNTIF(R9:W9,\"=1\")","v":0},null,{"$f":"$AA$10","v":0},{"$f":"IF(MATCH(Q9,#REF!,0),#REF!)","v":{"$error":"#REF!"}},{"$nulls":19},{"$f":"IF(SUMPRODUCT(($C$2:$C5=C9)*($L$2:$L5=L9))>1,0,1)","v":1},null,{"$f":"IF(SUMPRODUCT(($C$7:$C9=C9)*($L$7:$L9=L9))>1,0,1)","v":0}]
[]
[]
[{"$nulls":16},"  This will read IF !1,IE3 has any value in then enter the TAB #"]
[]
["All col will read MatchQ3 !1 J3:j23 then !1col I3 etc"]
[]
[{"$nulls":15},"`"]
{"$rows_empty":47}
[{"$nulls":8},"PORT LINCOLN","AC"]
[{"$nulls":8},"CLARE","AC"]
[{"$nulls":8},"MOUNT GAMBIER","AC"]
[{"$nulls":8},"BORDERTOWN","AC"]
[{"$nulls":8},"OAKBANK","AC"]
[{"$nulls":8},"NARACOORTE","AC"]
[{"$nulls":8},"PENOLA","AC"]
[{"$nulls":8},"KANGAROO ISLAND","AC"]
[{"$nulls":8},"MORPHETTVILLE","AM"]
[{"$nulls":8},"MORPHETTVILLE PARKS","AM"]
[{"$nulls":8},"MURRAY BRIDGE","AP"]
[{"$nulls":8},"BALAKLAVA","AP"]
[{"$nulls":8},"GAWLER","AP"]
[{"$nulls":8},"STRATHALBYN","AP"]
[{"$nulls":8},"TOWNSVILLE","QC"]
[{"$nulls":8},"ROCKHAMPTON","QC"]
[{"$nulls":8},"MACKAY","QC"]
[{"$nulls":8},"BEAUDESERT","QC"]
[{"$nulls":8},"YEPPOON","QC"]
[{"$nulls":8},"EAGLE FARM","QM"]
[{"$nulls":8},"DOOMBEN","QM"]
[{"$nulls":8},"GOLD COAST","QP"]
[{"$nulls":8},"SUNSHINE COAST","QP"]
[{"$nulls":8},"IPSWICH","QP"]
[{"$nulls":8},"SUNSHINE COAST CUSH","QP"]
[{"$nulls":8},"TOOWOOMBA CUSH","QP"]
[{"$nulls":8},"GUNNEDAH","SC"]
[{"$nulls":8},"WAGGA","SC"]
[{"$nulls":8},"QUEANBEYAN","SC"]
[{"$nulls":8},"TAREE","SC"]
[{"$nulls":8},"CESSNOCK","SC"]
[{"$nulls":8},"LISMORE","SC"]
[{"$nulls":8},"MUDGEE","SC"]
[{"$nulls":8},"NOWRA","SC"]
[{"$nulls":8},"BALLINA","SC"]
[{"$nulls":8},"ALBURY","SC"]
[{"$nulls":8},"ARMIDALE","SC"]
[{"$nulls":8},"NARROMINE","SC"]
[{"$nulls":8},"GOULBURN","SC"]
[{"$nulls":8},"SCONE","SC"]
[{"$nulls":8},"MURWILLUMBAH","SC"]
[{"$nulls":8},"BATHURST","SC"]
[{"$nulls":8},"PORT MACQUARIE","SC"]
[{"$nulls":8},"DUBBO","SC"]
[{"$nulls":8},"ORANGE","SC"]
[{"$nulls":8},"MOREE","SC"]
[{"$nulls":8},"COFFS HARBOUR","SC"]
[{"$nulls":8},"COROWA","SC"]
[{"$nulls":8},"WARREN","SC"]
[{"$nulls":8},"SAPPHIRE COAST","SC"]
[{"$nulls":8},"PARKES","SC"]
[{"$nulls":8},"GILGANDRA","SC"]
[{"$nulls":8},"MORUYA","SC"]
[{"$nulls":8},"GLEN INNES","SC"]
[{"$nulls":8},"COWRA","SC"]
[{"$nulls":8},"COONAMBLE","SC"]
[{"$nulls":8},"BROKEN HILL","SC"]
[{"$nulls":8},"CASINO","SC"]
[{"$nulls":8},"WALCHA","SC"]
[{"$nulls":8},"COONABARABRAN","SC"]
[{"$nulls":8},"MUSWELLBROOK","SC"]
[{"$nulls":8},"GRAFTON","SC"]
[{"$nulls":8},"WELLINGTON","SC"]
[{"$nulls":8},"KEMPSEY","SC"]
[{"$nulls":8},"ROSEHILL","SM"]
[{"$nulls":8},"CANTERBURY","SM"]
[{"$nulls":8},"WARWICK FARM","SM"]
[{"$nulls":8},"HAWKESBURY","SP"]
[{"$nulls":8},"KEMBLA GRANGE","SP"]
[{"$nulls":8},"GOSFORD","SP"]
[{"$nulls":8},"NEWCASTLE","SP"]
[{"$nulls":8},"HAWKESBURY INNER","SP"]
[{"$nulls":8},"WYONG","SP"]
[{"$nulls":8},"WODONGA","VC"]
[{"$nulls":8},"ARARAT","VC"]
[{"$nulls":8},"MILDURA","VC"]
[{"$nulls":8},"TATURA","VC"]
[{"$nulls":8},"TRARALGON","VC"]
[{"$nulls":8},"TERANG","VC"]
[{"$nulls":8},"STAWELL","VC"]
[{"$nulls":8},"BAIRNSDALE","VC"]
[{"$nulls":8},"WANGARATTA","VC"]
[{"$nulls":8},"COLAC","VC"]
[{"$nulls":8},"HORSHAM","VC"]
[{"$nulls":8},"STONY CREEK","VC"]
[{"$nulls":8},"ECHUCA","VC"]
[{"$nulls":8},"ARARAT","VC"]
[{"$nulls":8},"STAWELL","VC"]
[{"$nulls":8},"CAMPERDOWN","VC"]
[{"$nulls":8},"MURTOA","VC"]
[{"$nulls":8},"DONALD","VC"]
[{"$nulls":8},"EDENHOPE","VC"]
[{"$nulls":8},"MOONEE VALLEY","VM"]
[{"$nulls":8},"SANDOWN HILLSIDE","VM"]
[{"$nulls":8},"FLEMINGTON","VM"]
[{"$nulls":8},"CAULFIELD","VM"]
[{"$nulls":8},"SANDOWN LAKESIDE","VM"]
[{"$nulls":8},"KYNETON","VP"]
[{"$nulls":8},"SWAN HILL","VP"]
[{"$nulls":8},"SALE","VP"]
[{"$nulls":8},"WARRNAMBOOL","VP"]
[{"$nulls":8},"MORNINGTON","VP"]
[{"$nulls":8},"GEELONG SYTHENTIC","VP"]
[{"$nulls":8},"WERRIBEE","VP"]
[{"$nulls":8},"BENDIGO","VP"]
[{"$nulls":8},"PAKENHAM","VP"]
[{"$nulls":8},"KILMORE","VP"]
[{"$nulls":8},"MORNINGTON","VP"]
[{"$nulls":8},"BENALLA","VP"]
[{"$nulls":8},"SEYMOUR","VP"]
[{"$nulls":8},"BALLARAT","VP"]
[{"$nulls":8},"YARRA VALLEY","VP"]

{"sheet":"Sheet3","index":2,"n_rows":113,"n_cols":19,"rows_kept":113,"cut":false,"hidden":false,"merged":[]}
["DAY",null,"TRACK",null,null,null,"F/SZ",null,"A/G/P",null,"F/Y/N",null,"GDSH",null,"=<$6",null,"OP/F",null,"RACE"]
["MONDAY ",null,"PORT LINCOLN",null,null,null,1,null,"FAIR",null,"YES",null,"DEAD",null,1,null,"1L",null,1]
["TUESDAY",null,"CLARE",null,null,null,2,null,"AVER",null,"NO",null,"D1",null,2,null,"1M",null,2]
["WEDNESDAY",null,"MOUNT GAMBIER",null,null,null,3,null,"GOOD",null,null,null,"D2",null,3,null,"2L",null,3]
["THURSDAY",null,"BORDERTOWN",null,null,null,4,{"$nulls":5},"D3",null,4,null,"2M",null,4]
["FRIDAY",null,"OAKBANK",null,null,null,5,{"$nulls":5},"D4",null,5,null,"3L",null,5]
["SATURDAY",null,"NARACOORTE",null,null,null,6,{"$nulls":5},"D5",null,6,null,"3M",null,6]
["SUNDAY",null,"PENOLA",null,null,null,7,{"$nulls":5},"D6",null,7,null,"4L",null,7]
[null,null,"KANGAROO ISLAND",null,null,null,8,{"$nulls":5},"GOOD",null,8,null,"4M",null,8]
[null,null,"MORPHETTVILLE",null,null,null,9,{"$nulls":5},"G1",null,null,null,"5L",null,9]
[null,null,"MORPHETTVILLE PARKS",null,null,null,10,{"$nulls":5},"G2",null,null,null,"5M",null,10]
[null,null,"MURRAY BRIDGE",null,null,null,11,{"$nulls":5},"G3",null,null,null,"6L"]
[null,null,"BALAKLAVA",null,null,null,12,{"$nulls":5},"G4",null,null,null,"6M"]
[null,null,"GAWLER",null,null,null,13,{"$nulls":5},"HEAVY"]
[null,null,"STRATHALBYN",null,null,null,14,{"$nulls":5},"H7"]
[null,null,"TOWNSVILLE",null,null,null,15,{"$nulls":5},"H8"]
[null,null,"ROCKHAMPTON",null,null,null,16,{"$nulls":5},"H9"]
[null,null,"MACKAY",null,null,null,17,{"$nulls":5},"H10"]
[null,null,"BEAUDESERT",null,null,null,18,{"$nulls":5},"SLOW"]
[null,null,"YEPPOON",null,null,null,19,{"$nulls":5},"S3"]
[null,null,"EAGLE FARM",null,null,null,20,{"$nulls":5},"S4"]
[null,null,"DOOMBEN",null,null,null,21,{"$nulls":5},"S5"]
[null,null,"GOLD COAST",null,null,null,22,{"$nulls":5},"S6"]
[null,null,"SUNSHINE COAST",null,null,null,23,{"$nulls":5},"S7"]
[null,null,"IPSWICH",null,null,null,24,{"$nulls":5},"S8"]
[null,null,"SUNSHINE COAST CUSH",{"$nulls":9},"S9"]
[null,null,"TOOWOOMBA CUSH",{"$nulls":9},"S10"]
[null,null,"GUNNEDAH"]
[null,null,"WAGGA"]
[null,null,"QUEANBEYAN"]
[null,null,"TAREE"]
[null,null,"CESSNOCK"]
[null,null,"LISMORE"]
[null,null,"MUDGEE"]
[null,null,"NOWRA"]
[null,null,"BALLINA"]
[null,null,"ALBURY"]
[null,null,"ARMIDALE"]
[null,null,"NARROMINE"]
[null,null,"GOULBURN"]
[null,null,"SCONE"]
[null,null,"MURWILLUMBAH"]
[null,null,"BATHURST"]
[null,null,"PORT MACQUARIE"]
[null,null,"DUBBO"]
[null,null,"ORANGE"]
[null,null,"MOREE"]
[null,null,"COFFS HARBOUR"]
[null,null,"COROWA"]
[null,null,"WARREN"]
[null,null,"SAPPHIRE COAST"]
[null,null,"PARKES"]
[null,null,"GILGANDRA"]
[null,null,"MORUYA"]
[null,null,"GLEN INNES"]
[null,null,"COWRA"]
[null,null,"COONAMBLE"]
[null,null,"BROKEN HILL"]
[null,null,"CASINO"]
[null,null,"WALCHA"]
[null,null,"COONABARABRAN"]
[null,null,"MUSWELLBROOK"]
[null,null,"GRAFTON"]
[null,null,"WELLINGTON"]
[null,null,"KEMPSEY"]
[null,null,"ROSEHILL"]
[null,null,"CANTERBURY"]
[null,null,"WARWICK FARM"]
[null,null,"HAWKESBURY"]
[null,null,"KEMBLA GRANGE"]
[null,null,"GOSFORD"]
[null,null,"NEWCASTLE"]
[null,null,"HAWKESBURY INNER"]
[null,null,"WYONG"]
[null,null,"WODONGA"]
[null,null,"ARARAT"]
[null,null,"MILDURA"]
[null,null,"TATURA"]
[null,null,"TRARALGON"]
[null,null,"TERANG"]
[null,null,"STAWELL"]
[null,null,"BAIRNSDALE"]
[null,null,"WANGARATTA"]
[null,null,"COLAC"]
[null,null,"HORSHAM"]
[null,null,"STONY CREEK"]
[null,null,"ECHUCA"]
[null,null,"ARARAT"]
[null,null,"STAWELL"]
[null,null,"CAMPERDOWN"]
[null,null,"MURTOA"]
[null,null,"DONALD"]
[null,null,"EDENHOPE"]
[null,null,"MOONEE VALLEY"]
[null,null,"SANDOWN HILLSIDE"]
[null,null,"FLEMINGTON"]
[null,null,"CAULFIELD"]
[null,null,"SANDOWN LAKESIDE"]
[null,null,"KYNETON"]
[null,null,"SWAN HILL"]
[null,null,"SALE"]
[null,null,"WARRNAMBOOL"]
[null,null,"MORNINGTON"]
[null,null,"GEELONG SYTHENTIC"]
[null,null,"WERRIBEE"]
[null,null,"BENDIGO"]
[null,null,"PAKENHAM"]
[null,null,"KILMORE"]
[null,null,"MORNINGTON"]
[null,null,"BENALLA"]
[null,null,"SEYMOUR"]
[null,null,"BALLARAT"]
[null,null,"YARRA VALLEY"]