{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Results","Instructions"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"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":45,"n_cols":27,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["KemG (AUS) 21st May - 11:10 R3 1200m Mdn",{"$nulls":4},"Horse Racing\\AUS\\KemG (AUS) 21st May",null,"BFSP","Y",{"$nulls":13},"Start/Stop","Stop",null,"LAYSP","MANUAL"]
["Last updated:",40684.479291087962,"11:30:10","-00:20:10","In Play","Closed",null,"Balance:",83.39,null,"Exposure:",0,"Trans:",0,null,"Refresh rate:",null,null,null,{"$f":"IF(U3=U2,1,0)","v":0},{"$f":"IF(AA1=\"MANUAL\",\"\",COUNT(X5:X45))","v":""}]
["Total matched:",0,null,"Winners",1,"NR",1,"Turn IP","Y",66,"IR Delay",1,"Market id",100333821,"Comm:",5,null,null,null,0,{"$f":"COUNTA(U5:U45)","v":0},null,"Liability",30,null,"Max Odds",1000]
["Selection name","Back Odds 3",null,"Back Odds 2",null,"Back Odds 1",null,"Lay Odds 1",null,"Lay Odds 2",null,"Lay Odds 3",null,"Reduction factor","Last price matched","Total amount matched","Trigger","Odds","Stake","Bet ref","Bet time","Avg matched odds","Matched stake","Profit / Loss","SP","Lay Amount","Profit/Loss"]
["1. Benzema",0,0,0,0,0,0,0,0,0,0,0,0,10,150,6742.74,{"$f":"IF(P5=\"\",\"\",IF($X$1=\"Start\",$Z$1,\"\"))","v":""},{"$f":"IF(P5=\"\",\"\",$AA$3)","v":1000},{"$f":"IF(R5=\"\",\"\",$X$3)","v":30},null,null,0,0,0,14.25,{"$f":"IF(Y5=\"\",\"\",$X$3/(Y5-1))","v":2.2641509433962264},{"$f":"IF(Z5=\"\",\"\",IF(0-30+SUM($Z$5:$Z$45)-Z5>0,0-30+SUM($Z$5:$Z$45)-Z5*0.95,0-30+SUM($Z$5:$Z$45)-Z5))","v":5.8424764568893668}]
["2. General Sorriso",0,0,0,0,0,0,0,0,0,0,0,0,27.8,6.2,18634.57,{"$f":"IF(P6=\"\",\"\",IF($X$1=\"Start\",$Z$1,\"\"))","v":""},{"$f":"IF(P6=\"\",\"\",$AA$3)","v":1000},{"$f":"IF(R6=\"\",\"\",$X$3)","v":30},null,null,0,0,0,4.3,{"$f":"IF(Y6=\"\",\"\",$X$3/(Y6-1))","v":9.0909090909090917},{"$f":"IF(Z6=\"\",\"\",IF(0-30+SUM($Z$5:$Z$45)-Z6>0,0-30+SUM($Z$5:$Z$45)-Z6*0.95,0-30+SUM($Z$5:$Z$45)-Z6))","v":-1.0974892377933099}]
["3. Hakuna Shaka",0,0,0,0,0,0,0,0,0,0,0,0,4.2,11,2014.25,"",1000,30,null,null,0,0,0,24,1.3043478260869565,6.7542894183331734]
["4. Impend",0,0,0,0,0,0,0,0,0,0,0,0,1.3,590,298.35000000000002,"",1000,30,null,null,0,0,0,189.89,0.15882259516120495,7.8425383877126373]
["6. Piccolo Benito",0,0,0,0,0,0,0,0,0,0,0,0,0.7,330,567.86,"",1000,30,null,null,0,0,0,148.44,0.20347259902333154,7.8001208840436167]
["7. Another Emma",0,0,0,0,0,0,0,0,0,0,0,0,1.1000000000000001,75,469.11,"",1000,30,null,null,0,0,0,75,0.40540540540540543,7.6082847179806468]
["9. Bleue Pepite",0,0,0,0,0,0,0,0,0,0,0,0,20.399999999999999,4.9000000000000004,10350.969999999999,"",1000,30,null,null,0,0,0,4.9000000000000004,7.6923076923076916,0.68572754542347525]
["10. Recorrido",0,0,0,0,0,0,0,0,0,0,0,0,25,1.01,60300.38,"",1000,30,null,null,0,0,0,3.17,13.824884792626728,-5.8314649395109459]
["11. Trion",0,0,0,0,0,0,0,0,0,0,0,0,5.6,160,5027.3599999999997,"",1000,30,null,null,0,0,0,14.02,2.3041474654377883,5.8044797609498833]
["12. Wychette",0,0,0,0,0,0,0,0,0,0,0,0,3.8,46,1825.95,"",1000,30,null,null,0,0,0,41.27,0.74497144276136074,7.2856969824924889]
[{"$nulls":16},"","","",{"$nulls":6},"",""]
[{"$nulls":16},"","","",{"$nulls":6},"",""]
[{"$nulls":16},"","","",{"$nulls":6},"",""]
[{"$nulls":16},"","","",{"$nulls":6},"",""]
[{"$nulls":16},"","","",{"$nulls":6},"",""]
[{"$nulls":16},"","","",{"$nulls":6},"",""]
[{"$nulls":16},"","","",{"$nulls":6},"",""]
[{"$nulls":16},"","","",{"$nulls":6},"",""]
[{"$nulls":16},"","","",{"$nulls":6},"",""]
[{"$nulls":16},"","","",{"$nulls":6},"",""]
[{"$nulls":16},"","","",{"$nulls":6},"",""]
[{"$nulls":16},"","","",{"$nulls":6},"",""]
[{"$nulls":16},"","","",{"$nulls":6},"",""]
[{"$nulls":16},"","","",{"$nulls":6},"",""]
[{"$nulls":16},"","","",{"$nulls":6},"",""]
[{"$nulls":16},"","","",{"$nulls":6},"",""]
[{"$nulls":16},"","","",{"$nulls":6},"",""]
[{"$nulls":16},"","","",{"$nulls":6},"",""]
[{"$nulls":16},"","","",{"$nulls":6},"",""]
[{"$nulls":16},"","","",{"$nulls":6},"",""]
[{"$nulls":16},"","","",{"$nulls":6},"",""]
[{"$nulls":16},"","","",{"$nulls":6},"",""]
[{"$nulls":16},"","","",{"$nulls":6},"",""]
[{"$nulls":16},"","","",{"$nulls":6},"",""]
[{"$nulls":16},"","","",{"$nulls":6},"",""]
[{"$nulls":16},"","","",{"$nulls":6},"",""]
[{"$nulls":16},"","","",{"$nulls":6},"",""]
[{"$nulls":16},"","","",{"$nulls":6},"",""]
[{"$nulls":16},"","","",{"$nulls":6},"",""]
[{"$nulls":16},"","","",{"$nulls":6},"",""]
[{"$nulls":16},"","","",{"$nulls":6},"",""]

{"sheet":"Results","index":1,"n_rows":1,"n_cols":6,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Bet ref","Selection name","Bet type","Amount","Average Odds","Result"]

{"sheet":"Instructions","index":2,"n_rows":30,"n_cols":10,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[{"$nulls":9},"Instructions"]
[{"$nulls":9},"Open the sheet and set Start/Stop to \"Stop\""]
[{"$nulls":9},"If you set to \"AUTO\" the sheet will lay in each race auto as soon as you switch to start, manual lets you choose the races. "]
[{"$nulls":9},"Set your liabilty then set max odds you will accept or set to 1000 to lay all runners"]
[]
[{"$nulls":9},"Open Gruss and load the races in to the quickpick list"]
[{"$nulls":9},"Click the excel tab at top and select \"Log Current Prices\""]
[{"$nulls":9},"Workbook name = \"LAYSP.xlsm\""]
[{"$nulls":9},"Worksheet name = \"Sheet1\""]
[{"$nulls":9},"Top left hand cell = \"A1\""]
[]
[{"$nulls":9},"Check mark these boxes"]
[{"$nulls":9},"Enable trigger betting"]
[{"$nulls":9},"show balance"]
[{"$nulls":9},"log bet results"]
[{"$nulls":9},"Results worksheet = \"Results\""]
[]
[{"$nulls":9},"Check mark these boxes"]
[{"$nulls":9},"clear bet refs on suto select market"]
[{"$nulls":9},"clear bet refs on maual select market"]
[{"$nulls":9},"In the Additional Columns check mark \"SP\""]
[{"$nulls":9},"Press \"OK\""]
[]
[{"$nulls":9},"When you go back to the sheet and set to start it will lay all at SP, if set to auto "]
[{"$nulls":9},"when all have been layed it will move in to the next race and continue untill all races are done."]