{"text_format":"2","workbook":"xlsx","n_sheets":5,"sheets":["sheet1","spare code","Sheet3","sheet4","Sheet5"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":4,"comments":2,"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":148,"n_cols":16,"rows_kept":148,"cut":false,"hidden":false,"merged":[]}
["CODE",{"$f":"Sheet3!B1","v":23},{"$f":"Sheet3!C1","v":2},{"$f":"Sheet3!D1","v":2013},"win price","place price","rating","day","month","year","venue","distance","race number","code"]
[{"$nulls":4},{"$f":"COUNTA(A2:A833)","v":136}]
["23February2013Eagle Farm1#1","GREY COUNTESS",58,1,3.5,1.5,100,23,"February",2013,"Eagle Farm",1200,1,"2013-02-23T12:11:00",12,"Slow6"]
["23February2013Eagle Farm1#2","CONVOY",57.5,2,19.7,4.0999999999999996,87,23,"February",2013,"Eagle Farm",1200,1,"2013-02-23T12:11:00",8,"Slow6"]
["23February2013Eagle Farm1#3","FASTA THAN LIGHT",57.5,3,17.5,4.3,94,23,"February",2013,"Eagle Farm",1200,1,"2013-02-23T12:11:00",3,"Slow6"]
["23February2013Eagle Farm1#4","GOING GOING GONE",57.5,4,2.9,1.4,99,23,"February",2013,"Eagle Farm",1200,1,"2013-02-23T12:11:00",4,"Slow6"]
["23February2013Eagle Farm1#5","TIP TOP TIGER",57.5,5,1638.35,1638.35,94,23,"February",2013,"Eagle Farm",1200,1,"2013-02-23T12:11:00",6,"Slow6"]
["23February2013Eagle Farm1#6","GULLY COMMAND",56.5,6,52,14.3,87,23,"February",2013,"Eagle Farm",1200,1,"2013-02-23T12:11:00",2,"Slow6"]
["23February2013Eagle Farm1#7","IN A HUFF",56.5,7,9.6999999999999993,2.6,90,23,"February",2013,"Eagle Farm",1200,1,"2013-02-23T12:11:00",10,"Slow6"]
["23February2013Eagle Farm1#8","VOODOO BLUE MAGIC",56.5,8,13.2,2.9,93,23,"February",2013,"Eagle Farm",1200,1,"2013-02-23T12:11:00",1,"Slow6"]
["23February2013Eagle Farm1#9","YINDU",56.5,9,11.3,3.2,94,23,"February",2013,"Eagle Farm",1200,1,"2013-02-23T12:11:00",11,"Slow6"]
["23February2013Eagle Farm1#10","NICKED AND COURT",56,10,8,2.4,92,23,"February",2013,"Eagle Farm",1200,1,"2013-02-23T12:11:00",9,"Slow6"]
["23February2013Eagle Farm1#11","GREAT TOUCH",55.5,11,1638.35,1638.35,94,23,"February",2013,"Eagle Farm",1200,1,"2013-02-23T12:11:00",5,"Slow6"]
["23February2013Eagle Farm1#12","SPOOKY BEACH",55.5,12,1638.35,1638.35,88,23,"February",2013,"Eagle Farm",1200,1,"2013-02-23T12:11:00",13,"Slow6"]
["23February2013Eagle Farm1#13","CHALCOCITE",54,13,29.7,5.9,87,23,"February",2013,"Eagle Farm",1200,1,"2013-02-23T12:11:00",7,"Slow6"]
[]
["23February2013Eagle Farm2#1","KAR MA TE",62,1,28.1,7.8,79,23,"February",2013,"Eagle Farm",1300,2,"2013-02-23T12:50:00",10,"Slow6"]
["23February2013Eagle Farm2#2","DIENEKES",59,2,19.3,7.1,88,23,"February",2013,"Eagle Farm",1300,2,"2013-02-23T12:50:00",8,"Slow6"]
["23February2013Eagle Farm2#3","CAELLUM",58.5,3,16.3,5.2,89,23,"February",2013,"Eagle Farm",1300,2,"2013-02-23T12:50:00",11,"Slow6"]
["23February2013Eagle Farm2#4","TRISKELE",58,4,12.5,3.8,91,23,"February",2013,"Eagle Farm",1300,2,"2013-02-23T12:50:00",3,"Slow6"]
["23February2013Eagle Farm2#5","BIG CHANCE",57,5,12.4,4.0999999999999996,90,23,"February",2013,"Eagle Farm",1300,2,"2013-02-23T12:50:00",5,"Slow6"]
["23February2013Eagle Farm2#6","ALCANCIA",55.5,6,4.2,2.1,100,23,"February",2013,"Eagle Farm",1300,2,"2013-02-23T12:50:00",1,"Slow6"]
["23February2013Eagle Farm2#7","THAT'S KARMA",55.5,7,5.5,1.5,100,23,"February",2013,"Eagle Farm",1300,2,"2013-02-23T12:50:00",9,"Slow6"]
["23February2013Eagle Farm2#8","ACCIDENTAL",55,8,6.1,1.9,95,23,"February",2013,"Eagle Farm",1300,2,"2013-02-23T12:50:00",6,"Slow6"]
["23February2013Eagle Farm2#9","EDITAVE",55,9,13.7,4.5,92,23,"February",2013,"Eagle Farm",1300,2,"2013-02-23T12:50:00",7,"Slow6"]
["23February2013Eagle Farm2#10","NAYNAY",54.5,10,20.2,4.5999999999999996,92,23,"February",2013,"Eagle Farm",1300,2,"2013-02-23T12:50:00",2,"Slow6"]
["23February2013Eagle Farm2#11","HOLD ME TIGHT",54,11,6.2,2.1,88,23,"February",2013,"Eagle Farm",1300,2,"2013-02-23T12:50:00",4,"Slow6"]
[]
["23February2013Eagle Farm3#1","CHART",59,1,10.3,2.9,90,23,"February",2013,"Eagle Farm",1300,3,"2013-02-23T13:30:00",8,"Slow6"]
["23February2013Eagle Farm3#2","STRADON",59,2,1638.35,1638.35,94,23,"February",2013,"Eagle Farm",1300,3,"2013-02-23T13:30:00",6,"Slow6"]
["23February2013Eagle Farm3#3","MULE FORTY SIX",58,3,28.3,8.3000000000000007,90,23,"February",2013,"Eagle Farm",1300,3,"2013-02-23T13:30:00",2,"Slow6"]
["23February2013Eagle Farm3#4","RUN WITH ME",57.5,4,7.2,2.1,95,23,"February",2013,"Eagle Farm",1300,3,"2013-02-23T13:30:00",5,"Slow6"]
["23February2013Eagle Farm3#5","IN A STORM",57,5,8.3000000000000007,2.2999999999999998,94,23,"February",2013,"Eagle Farm",1300,3,"2013-02-23T13:30:00",9,"Slow6"]
["23February2013Eagle Farm3#6","PICAWINNER",55.5,6,5.9,1.8,91,23,"February",2013,"Eagle Farm",1300,3,"2013-02-23T13:30:00",10,"Slow6"]
["23February2013Eagle Farm3#7","TICKET TO DREAM",55.5,7,6.8,2.1,100,23,"February",2013,"Eagle Farm",1300,3,"2013-02-23T13:30:00",4,"Slow6"]
["23February2013Eagle Farm3#8","DANRHO",55,8,3.3,1.6,98,23,"February",2013,"Eagle Farm",1300,3,"2013-02-23T13:30:00",7,"Slow6"]
["23February2013Eagle Farm3#9","SKY EFFORT",55,9,10.8,3.5,97,23,"February",2013,"Eagle Farm",1300,3,"2013-02-23T13:30:00",3,"Slow6"]
["23February2013Eagle Farm3#10","DOMINI",54,10,13.7,4.3,89,23,"February",2013,"Eagle Farm",1300,3,"2013-02-23T13:30:00",1,"Slow6"]
[]
["23February2013Eagle Farm4#1","I'LLBETRICKED",59,1,19.3,4.2,91,23,"February",2013,"Eagle Farm",1500,4,"2013-02-23T14:10:00",3,"Slow6"]
["23February2013Eagle Farm4#2","CYCLONE AL",57.5,2,1638.35,1638.35,93,23,"February",2013,"Eagle Farm",1500,4,"2013-02-23T14:10:00",4,"Slow6"]
["23February2013Eagle Farm4#3","EPIC TERRA",57.5,3,8.1,1.9,93,23,"February",2013,"Eagle Farm",1500,4,"2013-02-23T14:10:00",8,"Slow6"]
["23February2013Eagle Farm4#4","LONGSHOREMAN",57.5,4,1.6,1,100,23,"February",2013,"Eagle Farm",1500,4,"2013-02-23T14:10:00",7,"Slow6"]
["23February2013Eagle Farm4#5","TOKAMAK",57.5,5,17.5,4.4000000000000004,98,23,"February",2013,"Eagle Farm",1500,4,"2013-02-23T14:10:00",6,"Slow6"]
["23February2013Eagle Farm4#6","JAM FANCY",56,6,19.3,4.2,94,23,"February",2013,"Eagle Farm",1500,4,"2013-02-23T14:10:00",2,"Slow6"]
["23February2013Eagle Farm4#7","PELLEGRINI",56,7,13.8,3.2,95,23,"February",2013,"Eagle Farm",1500,4,"2013-02-23T14:10:00",9,"Slow6"]
["23February2013Eagle Farm4#8","BLACK CASH",54.5,8,7.4,1.6,96,23,"February",2013,"Eagle Farm",1500,4,"2013-02-23T14:10:00",10,"Slow6"]
["23February2013Eagle Farm4#9","CONGO",54.5,9,1638.35,1638.35,99,23,"February",2013,"Eagle Farm",1500,4,"2013-02-23T14:10:00",1,"Slow6"]
["23February2013Eagle Farm4#10","FAITH NO MORE",54.5,10,17,3.7,95,23,"February",2013,"Eagle Farm",1500,4,"2013-02-23T14:10:00",5,"Slow6"]
[]
["23February2013Eagle Farm5#1","KARANJA",59,1,11.7,3.5,95,23,"February",2013,"Eagle Farm",1500,5,"2013-02-23T14:50:00",4,"Slow6"]
["23February2013Eagle Farm5#2","BINGO ROSE",57.5,2,1638.35,1638.35,97,23,"February",2013,"Eagle Farm",1500,5,"2013-02-23T14:50:00",3,"Slow6"]
["23February2013Eagle Farm5#3","WHITESAILS",57.5,3,5.4,2.4,97,23,"February",2013,"Eagle Farm",1500,5,"2013-02-23T14:50:00",10,"Slow6"]
["23February2013Eagle Farm5#4","AMINUTEMORE",56,4,19.2,5.7,93,23,"February",2013,"Eagle Farm",1500,5,"2013-02-23T14:50:00",7,"Slow6"]
["23February2013Eagle Farm5#5","DIVINE CITY",56,5,5.5,2,96,23,"February",2013,"Eagle Farm",1500,5,"2013-02-23T14:50:00",6,"Slow6"]
["23February2013Eagle Farm5#6","BEVICO GIRL",54.5,6,3.9,1.2,99,23,"February",2013,"Eagle Farm",1500,5,"2013-02-23T14:50:00",11,"Slow6"]
["23February2013Eagle Farm5#7","CROATIAN QUALITY",54.5,7,23.9,7.6,92,23,"February",2013,"Eagle Farm",1500,5,"2013-02-23T14:50:00",2,"Slow6"]
["23February2013Eagle Farm5#8","GOTTA BE LUCKY",54.5,8,9.1999999999999993,2.7,91,23,"February",2013,"Eagle Farm",1500,5,"2013-02-23T14:50:00",8,"Slow6"]
["23February2013Eagle Farm5#9","LADY OSCAR",54.5,9,33.9,7.7,90,23,"February",2013,"Eagle Farm",1500,5,"2013-02-23T14:50:00",5,"Slow6"]
["23February2013Eagle Farm5#10","SWEET LITTLE FILLY",54.5,10,1638.35,1638.35,98,23,"February",2013,"Eagle Farm",1500,5,"2013-02-23T14:50:00",1,"Slow6"]
["23February2013Eagle Farm5#11","TANZINA",54.5,11,10.1,3,93,23,"February",2013,"Eagle Farm",1500,5,"2013-02-23T14:50:00",9,"Slow6"]
["23February2013Eagle Farm5#12","WRITE CHEEK",54.5,12,7.2,2.6,100,23,"February",2013,"Eagle Farm",1500,5,"2013-02-23T14:50:00",12,"Slow6"]
[]
["23February2013Eagle Farm6#1","FUNTANTES",58,1,12.4,4.2,100,23,"February",2013,"Eagle Farm",1200,6,"2013-02-23T15:30:00",9,"Slow6"]
["23February2013Eagle Farm6#2","RIVER LAD",57.5,2,10.4,2.6,94,23,"February",2013,"Eagle Farm",1200,6,"2013-02-23T15:30:00",6,"Slow6"]
["23February2013Eagle Farm6#3","THE SIXTIES",57.5,3,8.8000000000000007,2.1,100,23,"February",2013,"Eagle Farm",1200,6,"2013-02-23T15:30:00",5,"Slow6"]
["23February2013Eagle Farm6#4","TOMBOY",56,4,19.2,3.5,86,23,"February",2013,"Eagle Farm",1200,6,"2013-02-23T15:30:00",12,"Slow6"]
["23February2013Eagle Farm6#5","BETTER THAN READY",56,5,2.4,2.2999999999999998,100,23,"February",2013,"Eagle Farm",1200,6,"2013-02-23T15:30:00",3,"Slow6"]
["23February2013Eagle Farm6#6","WAR ENDS",56,6,32.6,7.8,90,23,"February",2013,"Eagle Farm",1200,6,"2013-02-23T15:30:00",11,"Slow6"]
["23February2013Eagle Farm6#7","CRAIGLEA FALCON",56,7,14.6,3.1,92,23,"February",2013,"Eagle Farm",1200,6,"2013-02-23T15:30:00",2,"Slow6"]
["23February2013Eagle Farm6#8","TRANSPORTER",56,8,16.7,4.0999999999999996,90,23,"February",2013,"Eagle Farm",1200,6,"2013-02-23T15:30:00",7,"Slow6"]
["23February2013Eagle Farm6#9","JOINT CHIEFS",56,9,26.8,6.2,87,23,"February",2013,"Eagle Farm",1200,6,"2013-02-23T15:30:00",13,"Slow6"]
["23February2013Eagle Farm6#10","JUGAHLATION",56,10,17,4.4000000000000004,96,23,"February",2013,"Eagle Farm",1200,6,"2013-02-23T15:30:00",10,"Slow6"]
["23February2013Eagle Farm6#11","WHITLAM",56,11,1638.35,1638.35,99,23,"February",2013,"Eagle Farm",1200,6,"2013-02-23T15:30:00",1,"Slow6"]
["23February2013Eagle Farm6#12","I'M COOL",56,12,6.2,1.5,94,23,"February",2013,"Eagle Farm",1200,6,"2013-02-23T15:30:00",4,"Slow6"]
["23February2013Eagle Farm6#13","SILVER SCHOLAR",56,13,1638.35,1638.35,88,23,"February",2013,"Eagle Farm",1200,6,"2013-02-23T15:30:00",14,"Slow6"]
["23February2013Eagle Farm6#14","FITNESS FANATIC",56,14,1638.35,1638.35,87,23,"February",2013,"Eagle Farm",1200,6,"2013-02-23T15:30:00",8,"Slow6"]
[]
["23February2013Eagle Farm7#1","SILVER BULLION",62,1,10,4,98,23,"February",2013,"Eagle Farm",1000,7,"2013-02-23T16:10:00",1,"Slow6"]
["23February2013Eagle Farm7#2","TAHITIAN BLACK",59.5,2,1638.35,1638.35,99,23,"February",2013,"Eagle Farm",1000,7,"2013-02-23T16:10:00",13,"Slow6"]
["23February2013Eagle Farm7#3","MR FAVULOUS",59,3,10.1,3.2,97,23,"February",2013,"Eagle Farm",1000,7,"2013-02-23T16:10:00",14,"Slow6"]
["23February2013Eagle Farm7#4","FRISCO LIGHTS",58.5,4,17.600000000000001,4.9000000000000004,95,23,"February",2013,"Eagle Farm",1000,7,"2013-02-23T16:10:00",9,"Slow6"]
["23February2013Eagle Farm7#5","IMPALA",58,5,17.100000000000001,4.8,94,23,"February",2013,"Eagle Farm",1000,7,"2013-02-23T16:10:00",3,"Slow6"]
["23February2013Eagle Farm7#6","LEEALAN",58,6,5,1.7,98,23,"February",2013,"Eagle Farm",1000,7,"2013-02-23T16:10:00",4,"Slow6"]
["23February2013Eagle Farm7#7","POWER OF ED",57,7,15.6,4.7,96,23,"February",2013,"Eagle Farm",1000,7,"2013-02-23T16:10:00",2,"Slow6"]
["23February2013Eagle Farm7#8","HOLLYWEIRD",56.5,8,1638.35,1638.35,98,23,"February",2013,"Eagle Farm",1000,7,"2013-02-23T16:10:00",8,"Slow6"]
["23February2013Eagle Farm7#9","PURE PURRFECTION",56.5,9,8.6,3.6,99,23,"February",2013,"Eagle Farm",1000,7,"2013-02-23T16:10:00",12,"Slow6"]
["23February2013Eagle Farm7#10","CHANDRA",56,10,23.4,6.8,87,23,"February",2013,"Eagle Farm",1000,7,"2013-02-23T16:10:00",11,"Slow6"]
["23February2013Eagle Farm7#11","TIME TO PLUNDER",55.5,11,4.5999999999999996,1.9,100,23,"February",2013,"Eagle Farm",1000,7,"2013-02-23T16:10:00",7,"Slow6"]
["23February2013Eagle Farm7#12","HUCKLEBERRY DANE",55,12,17.5,4.7,94,23,"February",2013,"Eagle Farm",1000,7,"2013-02-23T16:10:00",5,"Slow6"]
["23February2013Eagle Farm7#13","DEVILS MELODY",54,13,10.8,2.8,96,23,"February",2013,"Eagle Farm",1000,7,"2013-02-23T16:10:00",6,"Slow6"]
["23February2013Eagle Farm7#14","PATAPINDA",54,14,14.3,4.0999999999999996,96,23,"February",2013,"Eagle Farm",1000,7,"2013-02-23T16:10:00",10,"Slow6"]
[]
["23February2013Eagle Farm8#1","GENERAL JACKSON",59,1,15.5,4.8,91,23,"February",2013,"Eagle Farm",1000,8,"2013-02-23T16:50:00",10,"Slow6"]
["23February2013Eagle Farm8#2","TOM'S LUCK",57.5,2,8.6999999999999993,2.7,95,23,"February",2013,"Eagle Farm",1000,8,"2013-02-23T16:50:00",3,"Slow6"]
["23February2013Eagle Farm8#3","CALDETES",57,3,11.3,3.9,95,23,"February",2013,"Eagle Farm",1000,8,"2013-02-23T16:50:00",4,"Slow6"]
["23February2013Eagle Farm8#4","KUCHINSKAYA",57,4,5.8,2.4,100,23,"February",2013,"Eagle Farm",1000,8,"2013-02-23T16:50:00",7,"Slow6"]
["23February2013Eagle Farm8#5","RIDDLE ME THIS",55.5,5,17.600000000000001,5.6,88,23,"February",2013,"Eagle Farm",1000,8,"2013-02-23T16:50:00",1,"Slow6"]
["23February2013Eagle Farm8#6","AUCHENFLOWER",55,6,18.899999999999999,4.8,92,23,"February",2013,"Eagle Farm",1000,8,"2013-02-23T16:50:00",12,"Slow6"]
["23February2013Eagle Farm8#7","TIGER DIMEJAN",54.5,7,10,4.3,91,23,"February",2013,"Eagle Farm",1000,8,"2013-02-23T16:50:00",15,"Slow6"]
["23February2013Eagle Farm8#8","WARHOGG",54.5,8,1638.35,1638.35,86,23,"February",2013,"Eagle Farm",1000,8,"2013-02-23T16:50:00",14,"Slow6"]
["23February2013Eagle Farm8#9","MISHANI SINNER",54,9,6.9,2,94,23,"February",2013,"Eagle Farm",1000,8,"2013-02-23T16:50:00",2,"Slow6"]
["23February2013Eagle Farm8#10","PALAIS COURT",54,10,10.3,3.9,91,23,"February",2013,"Eagle Farm",1000,8,"2013-02-23T16:50:00",8,"Slow6"]
["23February2013Eagle Farm8#11","LITA",54,11,1638.35,1638.35,93,23,"February",2013,"Eagle Farm",1000,8,"2013-02-23T16:50:00",21,"Slow6"]
["23February2013Eagle Farm8#12","LITTLE FAVOURS",54,12,23.2,7,88,23,"February",2013,"Eagle Farm",1000,8,"2013-02-23T16:50:00",11,"Slow6"]
["23February2013Eagle Farm8#13","PERFECT GLORY",54,13,1638.35,1638.35,92,23,"February",2013,"Eagle Farm",1000,8,"2013-02-23T16:50:00",16,"Slow6"]
["23February2013Eagle Farm8#14","SHEEZA MYZZILE",54,14,1638.35,1638.35,88,23,"February",2013,"Eagle Farm",1000,8,"2013-02-23T16:50:00",19,"Slow6"]
["23February2013Eagle Farm8#15","THE RIGHT ONE",54,15,1638.35,1638.35,91,23,"February",2013,"Eagle Farm",1000,8,"2013-02-23T16:50:00",6,"Slow6"]
["23February2013Eagle Farm8#16","COUNTY COMMANDS",54,16,13.7,4.8,89,23,"February",2013,"Eagle Farm",1000,8,"2013-02-23T16:50:00",20,"Slow6"]
["23February2013Eagle Farm8#17","RARE RUBY",54,17,8.8000000000000007,2.8,89,23,"February",2013,"Eagle Farm",1000,8,"2013-02-23T16:50:00",9,"Slow6"]
["23February2013Eagle Farm8#18","BULLET ONE",54.5,18,33.1,9.4,89,23,"February",2013,"Eagle Farm",1000,8,"2013-02-23T16:50:00",13,"Slow6"]
["23February2013Eagle Farm8#19","BUDDY ROCKS",54,19,1638.3,1638.3,88,23,"February",2013,"Eagle Farm",1000,8,"2013-02-23T16:50:00",17,"Slow6"]
["23February2013Eagle Farm8#20","POLLAXE",54,20,41.1,11,88,23,"February",2013,"Eagle Farm",1000,8,"2013-02-23T16:50:00",5,"Slow6"]
["23February2013Eagle Farm8#21","SAMMY LOU",54,21,1638.35,1638.35,83,23,"February",2013,"Eagle Farm",1000,8,"2013-02-23T16:50:00",18,"Slow6"]
[]
["23February2013Warwick Farm1#1","BID SPOTTER",60.5,1,16.3,8.4,92,23,"February",2013,"Warwick Farm",2200,1,"2013-02-23T11:27:00",3,"Slow7"]
["23February2013Warwick Farm1#2","THUBIAAN",58,2,12.9,6.8,90,23,"February",2013,"Warwick Farm",2200,1,"2013-02-23T11:27:00",4,"Slow7"]
["23February2013Warwick Farm1#3","MARDEN",56,3,3.9,1.2,98,23,"February",2013,"Warwick Farm",2200,1,"2013-02-23T11:27:00",1,"Slow7"]
["23February2013Warwick Farm1#4","PLANETARIUM",54.5,4,4.3,2.6,98,23,"February",2013,"Warwick Farm",2200,1,"2013-02-23T11:27:00",5,"Slow7"]
["23February2013Warwick Farm1#5","SINDARIN",54,5,3.8,2.7,100,23,"February",2013,"Warwick Farm",2200,1,"2013-02-23T11:27:00",7,"Slow7"]
["23February2013Warwick Farm1#6","AGENT BAUER",54,6,6.1,3.5,96,23,"February",2013,"Warwick Farm",2200,1,"2013-02-23T11:27:00",6,"Slow7"]
["23February2013Warwick Farm1#7","NOW I SEE",54,7,7.9,3.8,91,23,"February",2013,"Warwick Farm",2200,1,"2013-02-23T11:27:00",2,"Slow7"]
[]
["23February2013Warwick Farm2#1","NINTH LEGION",60.5,1,1638.3,1638.3,91,23,"February",2013,"Warwick Farm",1400,2,"2013-02-23T12:02:00",1,"Heavy9"]
["23February2013Warwick Farm2#2","TURNLEY",59,2,5.0999999999999996,2.8,90,23,"February",2013,"Warwick Farm",1400,2,"2013-02-23T12:02:00",9,"Heavy9"]
["23February2013Warwick Farm2#3","ZIN ZAN EDDIE",58.5,3,9.8000000000000007,3.4,86,23,"February",2013,"Warwick Farm",1400,2,"2013-02-23T12:02:00",7,"Heavy9"]
["23February2013Warwick Farm2#4","KNOYDART",57,4,1.9,1.5,100,23,"February",2013,"Warwick Farm",1400,2,"2013-02-23T12:02:00",8,"Heavy9"]
["23February2013Warwick Farm2#5","GOLD EPONA",56.5,5,10.1,2.7,87,23,"February",2013,"Warwick Farm",1400,2,"2013-02-23T12:02:00",6,"Heavy9"]
["23February2013Warwick Farm2#6","DIAMOND DRILLE",54.5,6,4.5,2,92,23,"February",2013,"Warwick Farm",1400,2,"2013-02-23T12:02:00",2,"Heavy9"]
["23February2013Warwick Farm2#7","LANSDOWNE ROAD",54.5,7,23.7,5.8,95,23,"February",2013,"Warwick Farm",1400,2,"2013-02-23T12:02:00",3,"Heavy9"]
["23February2013Warwick Farm2#8","SONG AND LAUGHTER",54,8,1638.3,1638.3,87,23,"February",2013,"Warwick Farm",1400,2,"2013-02-23T12:02:00",5,"Heavy9"]
["23February2013Warwick Farm2#9","EXCITED PRINCE",54,9,1638.35,1638.35,86,23,"February",2013,"Warwick Farm",1400,2,"2013-02-23T12:02:00",4,"Heavy9"]
[]
["23February2013Warwick Farm3#1","MARSEILLE ROULETTE",58,1,9.1,2.9,99,23,"February",2013,"Warwick Farm",1200,3,"2013-02-23T12:40:00",11,"Heavy9"]
["23February2013Warwick Farm3#2","ROCKFORD",58,2,8.5,2.1,93,23,"February",2013,"Warwick Farm",1200,3,"2013-02-23T12:40:00",2,"Heavy9"]
["23February2013Warwick Farm3#3","GOOD JOB BRO",57,3,5.7,1.7,100,23,"February",2013,"Warwick Farm",1200,3,"2013-02-23T12:40:00",15,"Heavy9"]
["23February2013Warwick Farm3#4","CALMING INFLUENCE",56,4,3.6,2.2000000000000002,98,23,"February",2013,"Warwick Farm",1200,3,"2013-02-23T12:40:00",5,"Heavy9"]
["23February2013Warwick Farm3#5","CHAMPOLLION",56,5,18.8,6.5,89,23,"February",2013,"Warwick Farm",1200,3,"2013-02-23T12:40:00",1,"Heavy9"]
["23February2013Warwick Farm3#6","CHILLY PREDICTION",56,6,1638.35,1638.35,87,23,"February",2013,"Warwick Farm",1200,3,"2013-02-23T12:40:00",6,"Heavy9"]
["23February2013Warwick Farm3#7","MR JACKMAN",56,7,7.6,2.1,94,23,"February",2013,"Warwick Farm",1200,3,"2013-02-23T12:40:00",3,"Heavy9"]
["23February2013Warwick Farm3#8","NORTHERN JEWEL",56,8,9.8000000000000007,2.8,97,23,"February",2013,"Warwick Farm",1200,3,"2013-02-23T12:40:00",8,"Heavy9"]
["23February2013Warwick Farm3#9","PARFURI",56,9,12.9,3.8,90,23,"February",2013,"Warwick Farm",1200,3,"2013-02-23T12:40:00",14,"Heavy9"]
["23February2013Warwick Farm3#10","TEO",56,10,1638.35,1638.35,92,23,"February",2013,"Warwick Farm",1200,3,"2013-02-23T12:40:00",7,"Heavy9"]
["23February2013Warwick Farm3#11","SENIOR COUNCIL",55,11,31.1,7,90,23,"February",2013,"Warwick Farm",1200,3,"2013-02-23T12:40:00",9,"Heavy9"]
["23February2013Warwick Farm3#12","SNITZEL'S JEWEL",54.5,12,1638.35,1638.35,95,23,"February",2013,"Warwick Farm",1200,3,"2013-02-23T12:40:00",13,"Heavy9"]
["23February2013Warwick Farm3#13","ALL THAT I AM",54,13,14.8,4.7,89,23,"February",2013,"Warwick Farm",1200,3,"2013-02-23T12:40:00",12,"Heavy9"]
["23February2013Warwick Farm3#14","JUST A BLUR",54,14,1638.3,1638.3,86,23,"February",2013,"Warwick Farm",1200,3,"2013-02-23T12:40:00",4,"Heavy9"]
["23February2013Warwick Farm3#15","SOVEREIGN BID",55,15,31.6,8.4,88,23,"February",2013,"Warwick Farm",1200,3,"2013-02-23T12:40:00",10,"Heavy9"]

{"sheet":"spare code","index":1,"n_rows":66,"n_cols":28,"rows_kept":66,"cut":false,"hidden":false,"merged":[]}
[null,null,"cnow = ActiveCell.Offset(x, 0).Value",{"$nulls":6},"FORMAT:","<POSITIVE>;<NEGATIVE>;<ZERO>;<TEXT>"]
[{"$nulls":9},1111111]
[null,null,"Sub mkdata()",{"$nulls":6},111]
[null,null,"'"]
[null,null,"' mkdata Macro",{"$nulls":7},"          ' multiply 3 rankings col ba/53"]
[null,null,"' organise data to use filter",{"$nulls":7},"                 "]
[null,null,"'",{"$nulls":7},"            datainarray(x, 53) = \"=AS\" & x + 2 & \"*AR\" & x + 2 & \"*AN\" & x + 2"]
[null,null,"'Application.ScreenUpdating = False"]
[null,null,"Application.Calculation = xlCalculationManual",{"$nulls":7}," NUMBER OF LS PLACES"]
[{"$nulls":10},"           "]
[null,null,"'",{"$nulls":7},"              datainarray(y, 23) = \"=COUNTIF(V\" & y1 + 2 & \":V\" & y2 + 1 & \",1)\" + \"+COUNTIF(V\" & y1 + 2 & \":V\" & y2 + 1 & \",2)\" + \"+COUNTIF(V\" & y1 + 2 & \":V\" & y2 + 1 & \",3)\""]
[null,null,"    Application.Goto Reference:=\"R3C1\""]
[null,null,"    Range(\"a3\").Select",{"$nulls":7},"   ' multiply 3 rankings col ba/53"]
[null,null,"eliminate:",{"$nulls":7},"                 "]
[null,null,"For x = 1 To 1500",{"$nulls":7},"            datainarray(x, 53) = \"=AS\" & x + 2 & \"*AR\" & x + 2 & \"*AN\" & x + 2"]
[null,null,"c = ActiveCell.Offset(x, 0).Value"]
[null,null,"d = ActiveCell.Offset(x + 3, 0).Value"]
[null,null,"'MsgBox c",{"$nulls":7},"new macro"]
[null,null,"'lender = ActiveCell.Offset(0, 2).Value",{"$nulls":7},"    Range(\"h3\").Select"]
[null,null,"'MsgBox lender",{"$nulls":7},"for x = 1 to 400"]
[null,null,"'If c = \"TOTAL:\" Then x = x - 1",{"$nulls":7},"horsename = ActiveCell.Offset(x, 0).Value"]
[]
[null,null,"'If c = \"TOTAL:\" Then ActiveCell.Offset(x, 0).EntireRow.Delete",{"$nulls":7},"ActiveCell.Offset(0, 9).Value = lastrow1"]
[null,null,"'If c = \"TOTAL:\" Then ActiveCell.Offset(x + 1, 0).EntireRow.Delete",{"$nulls":7},"Range(\"A3:CH\" & lastrow1).Select"]
[{"$nulls":10}," Selection.Copy"]
[null,null,"'If c = \"TOTAL:\" Then x = x - 1",{"$nulls":7},"Range(Selection, Selection.End(xlDown)).Select",{"$nulls":16},{"$f":"X26/W26","v":{"$error":"#DIV/0!"}}]
[{"$nulls":10},"    ActiveCell.Range(\"A4:GZ\" & lastrow1).Select",{"$nulls":16},{"$error":"#DIV/0!"}]
[null,null,"If c = \"\" Then ActiveCell.Offset(x, 0).Value = \".\"",{"$nulls":7},"    Selection.Copy",{"$nulls":16},{"$error":"#DIV/0!"}]
[null,null,"'If c = \"\" Then x = x - 1",{"$nulls":24},{"$error":"#DIV/0!"}]
[null,null,"'If c = \"\" And d = \"\" Then End",{"$nulls":24},{"$error":"#DIV/0!"}]
[{"$nulls":8},"=IF($M$1=7,VLOOKUP(IF(IF(M4=\"\",\"\",UPPER(LEFT(M4, LEN(M4)-1)))=\"\",\"\",VLOOKUP(IF(M4=\"\",\"\",UPPER(LEFT(M4, LEN(M4)-1))),$AW$2:$AZ$196,4,FALSE)),$AK$4:$AQ$8,4,FALSE),VLOOKUP(IF(IF(M4=\"\",\"\",UPPER(LEFT(M4, LEN(M4)-1)))=\"\",\"\",VLOOKUP(IF(M4=\"\",\"\",UPPER(LEFT(M4, LEN(M4)-1))),$AW$2:$AZ$196,4,FALSE)),$AK$4:$AQ$8,6,FALSE))",{"$nulls":18},{"$error":"#DIV/0!"}]
[{"$nulls":27},{"$error":"#DIV/0!"}]
[{"$nulls":27},{"$error":"#DIV/0!"}]
[null,null,"'If d = \"\" Then Selection.EntireRow.Delete",{"$nulls":24},{"$error":"#DIV/0!"}]
[{"$nulls":27},{"$error":"#DIV/0!"}]
[]
[null,null,"Next x"]
[{"$nulls":12},"Range(\"A3:E13\").Select"]
[{"$nulls":12},"    Range(Selection, Selection.End(xlToRight)).Select"]
[null,null,"    ActiveSheet.Range(\"$A$2:$AW$1503\").AutoFilter Field:=9, Criteria1:=\">=28\", _",{"$nulls":9},"    Range(\"A3:Q13\").Select"]
[null,null,"        Operator:=xlAnd",{"$nulls":9},"    Selection.Copy"]
[null,null,"    ActiveSheet.Range(\"$A$2:$AW$1503\").AutoFilter Field:=10, Criteria1:=\"<=2.5\" _",{"$nulls":9},"    Sheets(\"Sheet1\").Select"]
[null,null,"        , Operator:=xlAnd",{"$nulls":9},"    Range(\"L26\").Select"]
[null,null,"    ActiveSheet.Range(\"$A$2:$AW$1503\").AutoFilter Field:=17, Criteria1:=\">=2\", _",{"$nulls":9},"    ActiveSheet.Paste"]
[null,null,"        Operator:=xlAnd, Criteria2:=\"<=8\""]
[]
[null,null,"End Sub"]
[]
[null,null,"ws1.Range(\"A3:GZ\" & lastrow1) = datainarray"]
[null,null,"  "]
[null,null,"    "]
[null,null," "]
[null,null," Set runnerList19 = xmldoc.SelectNodes(\"//Race\")"]
[null,null,"        Set Meeting = runnerList6.Item(0)"]
[null,null,"        Set raced = Meeting.Attributes.getNamedItem(\"TrackDesc\")"]
[null,null,"        If Not raced Is Nothing Then"]
[null,null,"        Sheet3.Cells(i + 3, 16) = raced.Text"]
[null,null,"        End If"]
[]
[]
[null,null,"range(\"q151:w\" & x + ns1).Select"]
[null,null,"    Selection.ClearContents"]
[null,null,"Range(\"h22\").Value = \"=COUNTA(L23:L120)\""]
[null,null," counter = Range(\"h22\").Value"]
[null,null," b2 = counter"]
[null,null," b1 = b2"]

{"sheet":"Sheet3","index":2,"n_rows":19,"n_cols":37,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["code",23,2,2013,8,"SR",1,{"$nulls":10},{"$f":"COUNTA(R3:R100)","v":17},{"$nulls":4},{"$f":"COUNTA(A3:A30)","v":7},null,null,null,{"$f":"COUNTA(#REF!)","v":1},null,null,null,"http://tatts.com/pagedata/racing/2012/8/16/QR.xml",{"$nulls":5},"http://tatts.com/pagedata/racing/2012/8/16/QR1.xml"]
[1,"horse name","weight","tab number","odds w","odds PL","unitab rating","day","month","year","track code","distance","race num","code","date","tracdesc","spare","meeting LIST","track","hirace","type","type","start race",null,null,null,"meeting LIST",{"$nulls":9},"http://tatts.com/pagedata/racing/2012/9/2/CS3.xml"]
[{"$f":"H3&I3&J3&K3&M3&\"#\"&D3","v":"23February2013Warwick Farm4#1"},"APPEARANCE",59.5,1,4.5,2.2999999999999998,93,23,"February",2013,"Warwick Farm",1200,4,"2013-02-23T13:20:00",2,"Heavy9",null,"BR","Eagle Farm",8,"R","BR",1]
["23February2013Warwick Farm4#2","NOCTURNELLE",56,2,5.2,2.1,95,23,"February",2013,"Warwick Farm",1200,4,"2013-02-23T13:20:00",8,"Heavy9",null,"SR","Warwick Farm",8,"R","SR",1]
["23February2013Warwick Farm4#3","COLORADO CLAIRE",54.5,3,6.3,2.2000000000000002,100,23,"February",2013,"Warwick Farm",1200,4,"2013-02-23T13:20:00",3,"Heavy9",null,"MR","Caulfield",9,"R","MR",1]
["23February2013Warwick Farm4#4","SHE'S CLEAN",54,4,3.9,1.3,97,23,"February",2013,"Warwick Farm",1200,4,"2013-02-23T13:20:00",5,"Heavy9",null,"QR","Gold Coast",8,"R","QR",1]
["23February2013Warwick Farm4#5","CALIFORNIA STORM",54,5,13.3,3.4,92,23,"February",2013,"Warwick Farm",1200,4,"2013-02-23T13:20:00",6,"Heavy9",null,"NR","Gosford",8,"R","NR",1]
["23February2013Warwick Farm4#6","MICKELBERG",54,6,12,3.3,92,23,"February",2013,"Warwick Farm",1200,4,"2013-02-23T13:20:00",4,"Heavy9",null,"VR","Wodonga",7,"R","VR",1]
["23February2013Warwick Farm4#7","IN TOP GEAR",54,7,16.2,3.3,87,23,"February",2013,"Warwick Farm",1200,4,"2013-02-23T13:20:00",7,"Heavy9",null,"AR","Morphettville",8,"R","AR",1]
[null,"BELLA ROSSIE",54,8,7.9,1.8,90,23,"February",2013,"Warwick Farm",1200,4,null,1,null,null,"PR","Ascot",8,"R","PR",1]
[{"$nulls":17},"FR","Geraldton",6,"R","FR",1]
[{"$nulls":17},"ER","Toowoomba",7,"R","ER",1]
[{"$nulls":17},"BS","Newcastle",2,"R","BS",1]
[{"$nulls":17},"NS","Otaki",8,"R","NS",1]
[{"$nulls":17},"AS","Kenilworth",7,"R","AS",1]
[{"$nulls":17},"CS","Kempton Park",3,"R","CS",1]
[{"$nulls":17},"ES","Lingfield",3,"R","ES",1]
[{"$nulls":17},"ZS","Matamata",10,"R","ZS",1]
[{"$nulls":17},"TS","Turffontein",8,"R","TS",1]

{"sheet":"sheet4","index":3,"n_rows":2,"n_cols":14,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[null,20,10,2011,null,null,{"$f":"COUNTA(A2:A2)","v":1}]
["date code","placing",3,"tab number",5,"win div","place divi","day","month","year","track code","race number","distance","code"]

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