{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Calculator","Intructions"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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":"Calculator","index":0,"n_rows":32,"n_cols":58,"rows_kept":32,"cut":false,"hidden":false,"merged":[[30,9,30,11],[2,12,2,18],[4,16,4,17],[16,9,16,11],[18,9,18,11],[20,9,20,11],[24,9,24,11],[28,9,28,11],[26,9,26,11],[22,9,22,11],[8,9,8,11],[10,9,10,11],[12,9,12,11],[14,9,14,11]]}
[]
[{"$nulls":24},"Flat Stake",null,null,"Split Stake",null,null,"Saver Dutch Stake",{"$nulls":5},"Dutch Profit",{"$nulls":5},"Lay Flat Stake",null,null,"Lay Split Stake",null,null,"Lay Liability",null,null,"Lay Payout",null,null,null,{"$f":"(1-($V$5/100))","v":1}]
[{"$nulls":12},"Saver/Dutch Calculator"]
[]
[{"$nulls":9},"Payout/Outlay/Return",null,100,null,null,null,"Bet Type","Saver Dutch Bet",null,null,"Betfair Commission",null,0,"%",null,{"$f":"IF($Q$5=\"Flat Stake\",$L$5,0)","v":0},null,null,{"$f":"IF($Q$5=\"Split Stake\",$L$5,0)","v":0},null,null,{"$f":"IF($Q$5=\"Saver Dutch Bet\",$L$5,0)","v":100},{"$nulls":5},{"$f":"IF($Q$5=\"Dutch Profit\",$L$5,0)","v":0},{"$nulls":5},{"$f":"IF($Q$5=\"Lay Flat Stake\",$L$5,0)","v":0},null,null,{"$f":"IF($Q$5=\"Lay Split Stake\",$L$5,0)","v":0},null,null,{"$f":"IF($Q$5=\"Lay Liability\",$L$5,0)","v":0},null,null,{"$f":"IF($Q$5=\"Lay Payout\",$L$5,0)","v":0}]
[]
[{"$nulls":9},"No Runner",null,null,null,"Saver",null,"Price",null,"Stake",null,"Return/Liability",null,"Profit/loss",null,null,{"$f":"SUM(Y9:Y31)","v":0},null,null,{"$f":"SUM(AB9:AB31)","v":0},{"$f":"COUNT(P9:P31)","v":4},null,{"$f":"$L$5-SUM(AE9:AE31)","v":100},{"$f":"SUM(AF9:AF31)","v":0.72820457766135605},{"$nulls":4},{"$f":"SUM(AM9:AM31)","v":0},{"$f":"SUM(AL9:AL31)","v":0},{"$f":"1-AL7","v":1},{"$f":"(AL7/AM7)+1","v":1},{"$nulls":14},"Price","Bet","Return","Profit"]
[]
[{"$nulls":9},5,{"$nulls":5},3.65,null,{"$f":"BD9","v":37.62302670763134},null,{"$f":"BE9","v":137.32404748285438},null,{"$f":"BF9","v":37.324047482854382},null,null,{"$f":"IF($BC9=\"\",\"\",IF(Y$5=0,0,$L$5))","v":0},{"$f":"IF(Y9=\"\",\"\",IF(Y$5=0,0,P9*Y9))","v":0},{"$f":"IF(Z9=\"\",\"\",IF(Y$5=0,0,(Z9-$Y$7)*$BD$2))","v":0},{"$f":"IF($BC9=\"\",\"\",IF(AB$5=0,0,$L$5/$AC$7))","v":0},{"$f":"IF($BC9=\"\",\"\",IF(AB$5=0,0,AB9*$BC9))","v":0},{"$f":"IF($BC9=\"\",\"\",IF(AB$5=0,0,(AC9-$AB$7)*$BD$2))","v":0},{"$f":"IF($BC9=\"\",\"\",IF($AE$5=0,0,IF(N9<>\"\",$L$5/$BC9,0)))","v":0},{"$f":"IF(AE9=\"\",\"\",IF(AE9=0,IF($AE$5=0,0,1/$BC9),0))","v":0.27397260273972601},{"$f":"IF($BC9=\"\",\"\",IF(AE$5=0,0,IF(ISERROR((AF9/$AF$7)*$AE$7),0,AF9/$AF$7)*$AE$7))","v":37.62302670763134},{"$f":"IF($BC9=\"\",\"\",IF(AE$5=0,0,IF(AE9=0,AG9*$BC9,AE9*$BC9)))","v":137.32404748285438},{"$f":"IF($BC9=\"\",\"\",IF(AE$5=0,0,IF(AE9=0,(AH9-$AE$5)*$BD$2,AH9-$AE$5)))","v":37.324047482854382},null,null,{"$f":"IF(BC9=\"\",\"\",IF($AK$5=0,0,1/$BC9))","v":0},{"$f":"IF($BC9=\"\",\"\",IF(AK$5=0,0,IF(ISERROR((AL9*$L$5)*$AN$7),0,(AL9*$L$5)*$AN$7)))","v":0},{"$f":"IF($BC9=\"\",\"\",IF(AK$5=0,0,AM9*$BC9))","v":0},{"$f":"IF($BC9=\"\",\"\",IF(AK$5=0,0,(AN9-$AK$7)*$BD$2))","v":0},null,{"$f":"IF($BC9=\"\",\"\",IF(AQ$5=0,0,$L$5))","v":0},{"$f":"IF(AQ9=\"\",\"\",IF(AQ$5=0,0,BC9*AQ9-AQ9))","v":0},{"$f":"IF(BC9=\"\",\"\",IF(AQ$5=0,0,0-(BC9*AQ9)+SUM($AQ$9:$AQ$31)))","v":0},{"$f":"IF($BC9=\"\",\"\",IF(AT$5=0,0,$L$5/$AC$7))","v":0},{"$f":"IF(AT9=\"\",\"\",IF(AT$5=0,0,BC9*AT9-AT9))","v":0},{"$f":"IF(BC9=\"\",\"\",IF(AT$5=0,0,0-(BC9*AT9)+SUM($AT$9:$AT$31)))","v":0},{"$f":"IF($BC9=\"\",\"\",IF(AW$5=0,0,$AW$5/(BC9-1)))","v":0},{"$f":"IF(AW9=\"\",\"\",IF(AW$5=0,0,AW9*BC9-AW9))","v":0},{"$f":"IF(BC9=\"\",\"\",IF(AW$5=0,0,0-(AW9*BC9)+SUM($AW$9:$AW$31)))","v":0},{"$f":"IF($BC9=\"\",\"\",IF(AZ$5=0,0,$L$5/$BC9))","v":0},{"$f":"IF(AZ9=\"\",\"\",IF(AZ$5=0,0,BC9*AZ9-AZ9))","v":0},{"$f":"IF(BC9=\"\",\"\",IF(AZ$5=0,0,0-(AZ9*BC9)+SUM($AZ$9:$AZ$31)))","v":0},{"$f":"IF(P9=\"\",\"\",P9)","v":3.65},{"$f":"IF(P9=\"\",\"\",Y9+AB9+AE9+AG9+AM9+AQ9+AT9+AW9+AZ9)","v":37.62302670763134},{"$f":"IF(P9=\"\",\"\",Z9+AC9+AH9+AN9+AR9+AU9+AX9+BA9)","v":137.32404748285438},{"$f":"IF($P9=\"\",\"\",AA9+AD9+AI9+AO9+AS9+AV9+AY9+BB9)","v":37.324047482854382}]
[{"$nulls":24},{"$f":"IF($BC10=\"\",\"\",IF(Y$5=0,0,$L$5))","v":""},{"$f":"IF(Y10=\"\",\"\",IF(Y$5=0,0,P10*Y10))","v":""},{"$f":"IF(Z10=\"\",\"\",IF(Y$5=0,0,(Z10-$Y$7)*$BD$2))","v":""},{"$f":"IF($BC10=\"\",\"\",IF(AB$5=0,0,$L$5/$AC$7))","v":""},{"$f":"IF($BC10=\"\",\"\",IF(AB$5=0,0,AB10*$BC10))","v":""},{"$f":"IF($BC10=\"\",\"\",IF(AB$5=0,0,(AC10-$AB$7)*$BD$2))","v":""},{"$f":"IF($BC10=\"\",\"\",IF($AE$5=0,0,IF(N10<>\"\",$L$5/$BC10,0)))","v":""},{"$f":"IF(AE10=\"\",\"\",IF(AE10=0,IF($AE$5=0,0,1/$BC10),0))","v":""},{"$f":"IF($BC10=\"\",\"\",IF(AE$5=0,0,IF(ISERROR((AF10/$AF$7)*$AE$7),0,AF10/$AF$7)*$AE$7))","v":""},{"$f":"IF($BC10=\"\",\"\",IF(AE$5=0,0,IF(AE10=0,AG10*$BC10,AE10*$BC10)))","v":""},{"$f":"IF($BC10=\"\",\"\",IF(AE$5=0,0,IF(AE10=0,(AH10-$AE$5)*$BD$2,AH10-$AE$5)))","v":""},null,null,{"$f":"IF(BC10=\"\",\"\",IF($AK$5=0,0,1/$BC10))","v":""},{"$f":"IF($BC10=\"\",\"\",IF(AK$5=0,0,IF(ISERROR((AL10*$L$5)*$AN$7),0,(AL10*$L$5)*$AN$7)))","v":""},{"$f":"IF($BC10=\"\",\"\",IF(AK$5=0,0,AM10*$BC10))","v":""},{"$f":"IF($BC10=\"\",\"\",IF(AK$5=0,0,(AN10-$AK$7)*$BD$2))","v":""},null,{"$f":"IF($BC10=\"\",\"\",IF(AQ$5=0,0,$L$5))","v":""},{"$f":"IF(AQ10=\"\",\"\",IF(AQ$5=0,0,BC10*AQ10-AQ10))","v":""},{"$f":"IF(BC10=\"\",\"\",IF(AQ$5=0,0,0-(BC10*AQ10)+SUM($AQ$9:$AQ$31)))","v":""},{"$f":"IF($BC10=\"\",\"\",IF(AT$5=0,0,$L$5/$AC$7))","v":""},{"$f":"IF(AT10=\"\",\"\",IF(AT$5=0,0,BC10*AT10-AT10))","v":""},{"$f":"IF(BC10=\"\",\"\",IF(AT$5=0,0,0-(BC10*AT10)+SUM($AT$9:$AT$31)))","v":""},{"$f":"IF($BC10=\"\",\"\",IF(AW$5=0,0,$AW$5/(BC10-1)))","v":""},{"$f":"IF(AW10=\"\",\"\",IF(AW$5=0,0,AW10*BC10-AW10))","v":""},{"$f":"IF(BC10=\"\",\"\",IF(AW$5=0,0,0-(AW10*BC10)+SUM($AW$9:$AW$31)))","v":""},{"$f":"IF($BC10=\"\",\"\",IF(AZ$5=0,0,$L$5/$BC10))","v":""},{"$f":"IF(AZ10=\"\",\"\",IF(AZ$5=0,0,BC10*AZ10-AZ10))","v":""},{"$f":"IF(BC10=\"\",\"\",IF(AZ$5=0,0,0-(AZ10*BC10)+SUM($AZ$9:$AZ$31)))","v":""},{"$f":"IF(P10=\"\",\"\",P10)","v":""},{"$f":"IF(P10=\"\",\"\",Y10+AB10+AE10+AG10+AM10+AQ10+AT10+AW10+AZ10)","v":""},{"$f":"IF(P10=\"\",\"\",Z10+AC10+AH10+AN10+AR10+AU10+AX10+BA10)","v":""},{"$f":"IF($P10=\"\",\"\",AA10+AD10+AI10+AO10+AS10+AV10+AY10+BB10)","v":""}]
[{"$nulls":9},15,{"$nulls":5},5.5,null,{"$f":"BD11","v":24.968008633246257},null,{"$f":"BE11","v":137.32404748285441},null,{"$f":"BF11","v":37.324047482854411},null,null,0,0,0,0,0,0,0,0.18181818181818182,24.968008633246257,137.32404748285441,37.324047482854411,null,null,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,5.5,24.968008633246257,137.32404748285441,37.324047482854411]
[{"$nulls":24},"","","","","","","","","","","",null,null,"","","","",null,"","","","","","","","","","","","","","","",""]
[{"$nulls":9},7,{"$nulls":5},5.8,null,{"$f":"BD13","v":23.676559910836971},null,{"$f":"BE13","v":137.32404748285444},null,{"$f":"BF13","v":37.324047482854439},null,null,0,0,0,0,0,0,0,0.17241379310344829,23.676559910836971,137.32404748285444,37.324047482854439,null,null,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,5.8,23.676559910836971,137.32404748285444,37.324047482854439]
[{"$nulls":24},"","","","","","","","","","","",null,null,"","","","",null,"","","","","","","","","","","","","","","",""]
[{"$nulls":9},6,{"$nulls":5},10,null,{"$f":"BD15","v":13.732404748285443},null,{"$f":"BE15","v":137.32404748285444},null,{"$f":"BF15","v":37.324047482854439},null,null,0,0,0,0,0,0,0,0.1,13.732404748285443,137.32404748285444,37.324047482854439,null,null,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,10,13.732404748285443,137.32404748285444,37.324047482854439]
[{"$nulls":24},"","","","","","","","","","","",null,null,"","","","",null,"","","","","","","","","","","","","","","",""]
[{"$nulls":9},1,{"$nulls":7},{"$f":"BD17","v":""},null,{"$f":"BE17","v":""},null,{"$f":"BF17","v":""},null,null,"","","","","","","","","","","",null,null,"","","","",null,"","","","","","","","","","","","","","","",""]
[{"$nulls":24},"","","","","","","","","","","",null,null,"","","","",null,"","","","","","","","","","","","","","","",""]
[{"$nulls":17},{"$f":"BD19","v":""},null,{"$f":"BE19","v":""},null,{"$f":"BF19","v":""},null,null,"","","","","","","","","","","",null,null,"","","","",null,"","","","","","","","","","","","","","","",""]
[{"$nulls":24},"","","","","","","","","","","",null,null,"","","","",null,"","","","","","","","","","","","","","","",""]
[{"$nulls":17},{"$f":"BD21","v":""},null,{"$f":"BE21","v":""},null,{"$f":"BF21","v":""},null,null,"","","","","","","","","","","",null,null,"","","","",null,"","","","","","","","","","","","","","","",""]
[{"$nulls":24},"","","","","","","","","","","",null,null,"","","","",null,"","","","","","","","","","","","","","","",""]
[{"$nulls":17},{"$f":"BD23","v":""},null,{"$f":"BE23","v":""},null,{"$f":"BF23","v":""},null,null,"","","","","","","","","","","",null,null,"","","","",null,"","","","","","","","","","","","","","","",""]
[{"$nulls":24},"","","","","","","","","","","",null,null,"","","","",null,"","","","","","","","","","","","","","","",""]
[{"$nulls":17},{"$f":"BD25","v":""},null,{"$f":"BE25","v":""},null,{"$f":"BF25","v":""},null,null,"","","","","","","","","","","",null,null,"","","","",null,"","","","","","","","","","","","","","","",""]
[{"$nulls":24},"","","","","","","","","","","",null,null,"","","","",null,"","","","","","","","","","","","","","","",""]
[{"$nulls":17},{"$f":"BD27","v":""},null,{"$f":"BE27","v":""},null,{"$f":"BF27","v":""},null,null,"","","","","","","","","","","",null,null,"","","","",null,"","","","","","","","","","","","","","","",""]
[{"$nulls":24},"","","","","","","","","","","",null,null,"","","","",null,"","","","","","","","","","","","","","","",""]
[{"$nulls":17},{"$f":"BD29","v":""},null,{"$f":"BE29","v":""},null,{"$f":"BF29","v":""},null,null,"","","","","","","","","","","",null,null,"","","","",null,"","","","","","","","","","","","","","","",""]
[{"$nulls":19},{"$f":"BE30","v":""},{"$nulls":4},"","","","","","","","","","","",null,null,"","","","",null,"","","","","","","","","","","","","","","",""]
[{"$nulls":17},{"$f":"BD31","v":""},null,{"$f":"IF(P31=\"\",\"\",P31*R31)","v":""},null,{"$f":"BF31","v":""},null,null,"","","","","","","","","","","",null,null,"","","","",null,"","","","","","","","","","","","","","","",""]
[{"$nulls":24},"","","","","","","","","","","",null,null,"","","","",null,"","","","","","","","","","","",""]

{"sheet":"Intructions","index":1,"n_rows":11,"n_cols":13,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[{"$nulls":12},"1 Only type in the grey boxes."]
[{"$nulls":12},"2 Use the drop down box to select the bet type."]
[{"$nulls":12},"3 the saver bet only works on the \"Saver Dutch bet\""]
[{"$nulls":12},"4 All the formulas are in the hidden cells on the right."]
[{"$nulls":12},"5 if you use bookies set commisssion to 0.0"]