{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":68,"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":140871,"n_cols":29,"rows_kept":140871,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Dutching sheet for equal/unequal profits from 2 horses up to 9 horses - WIN ONLY BETS"]
[]
[null,null,null,4,"Runners","Odds","Req profit","Stake","Returns",{"$nulls":5},"2 RUNNERS",{"$nulls":10},"PROFIT",null,{"$f":"SUM(AB5:AB6)","v":0}]
[{"$nulls":4},"Horse 1",4,0,{"$f":"IF($D$4=2,AB5,IF($D$4=3,AB8,IF($D$4=4,AB12,IF($D$4=5,AB17,IF($D$4=6,AB23,IF($D$4=7,AB30,IF($D$4=8,AB38,IF($D$4=9,AB47))))))))","v":4.8979591836734695},{"$f":"IF(H5=\"\",\"\",H5*F5)","v":19.591836734693878},{"$nulls":5},{"$f":"F5","v":4},-1,{"$nulls":9},{"$f":"G5","v":0},null,{"$f":"MMULT(MINVERSE(O5:P6),Z5:Z6)","v":0},{"$f":"AB5*O5+AB5","v":0}]
[{"$nulls":4},"Horse 2",5,0,{"$f":"IF($D$4=2,AB6,IF($D$4=3,AB9,IF($D$4=4,AB13,IF($D$4=5,AB18,IF($D$4=6,AB24,IF($D$4=7,AB31,IF($D$4=8,AB39,IF($D$4=9,AB48))))))))","v":4.0816326530612246},{"$f":"IF(H6=\"\",\"\",H6*F6)","v":20.408163265306122},{"$nulls":5},-1,{"$f":"F6","v":5},{"$nulls":9},{"$f":"G6","v":0},null,0,{"$f":"AB6*P6+AB6","v":0}]
[{"$nulls":4},"Horse 3",7,0,{"$f":"IF($D$4=2,\"\",IF($D$4=3,AB10,IF($D$4=4,AB14,IF($D$4=5,AB19,IF($D$4=6,AB25,IF($D$4=7,AB32,IF($D$4=8,AB40,IF($D$4=9,AB49))))))))","v":3.0612244897959182},{"$f":"IF(H7=\"\",\"\",H7*F7)","v":21.428571428571427},{"$nulls":5},"3 RUNNERS",{"$nulls":10},"PROFIT",null,{"$f":"SUM(AB8:AB10)","v":0}]
[{"$nulls":4},"Horse 4",9,100,{"$f":"IF($D$4=2,\"\",IF($D$4=3,AB11,IF($D$4=4,AB15,IF($D$4=5,AB20,IF($D$4=6,AB26,IF($D$4=7,AB33,IF($D$4=8,AB41,IF($D$4=9,AB50))))))))","v":12.448979591836736},{"$f":"IF(H8=\"\",\"\",H8*F8)","v":112.04081632653062},{"$nulls":5},{"$f":"F5","v":4},-1,-1,{"$nulls":8},{"$f":"G5","v":0},null,{"$f":"MMULT(MINVERSE(O8:Q10),Z8:Z10)","v":0},{"$f":"AB8*O8+AB8","v":0}]
[{"$nulls":7},{"$f":"IF($D$4=2,\"\",IF($D$4=3,\"\",IF($D$4=4,\"\",IF($D$4=5,AB21,IF($D$4=6,AB27,IF($D$4=7,AB34,IF($D$4=8,AB42,IF($D$4=9,AB51))))))))","v":""},{"$f":"IF(H9=\"\",\"\",H9*F9+H9)","v":""},{"$nulls":5},-1,{"$f":"F6","v":5},-1,{"$nulls":8},{"$f":"G6","v":0},null,0,{"$f":"AB9*P9+AB9","v":0}]
[{"$nulls":7},{"$f":"IF($D$4=2,\"\",IF($D$4=3,\"\",IF($D$4=4,\"\",IF($D$4=5,\"\",IF($D$4=6,AB28,IF($D$4=7,AB35,IF($D$4=8,AB43,IF($D$4=9,AB52))))))))","v":""},"",{"$nulls":5},-1,-1,{"$f":"F7","v":7},{"$nulls":8},{"$f":"G7","v":0},null,0,{"$f":"AB10*Q10+AB10","v":0}]
[{"$nulls":7},{"$f":"IF($D$4=2,\"\",IF($D$4=3,\"\",IF($D$4=4,\"\",IF($D$4=5,\"\",IF($D$4=6,\"\",IF($D$4=7,AB36,IF($D$4=8,AB44,IF($D$4=9,AB53))))))))","v":""},"",{"$nulls":5},"4 RUNNERS",{"$nulls":10},"PROFIT",null,{"$f":"SUM(AB12:AB15)","v":24.489795918367349}]
[{"$nulls":7},{"$f":"IF($D$4=2,\"\",IF($D$4=3,\"\",IF($D$4=4,\"\",IF($D$4=5,\"\",IF($D$4=6,\"\",IF($D$4=7,\"\",IF($D$4=8,AB45,IF($D$4=9,AB54))))))))","v":""},"",{"$nulls":5},{"$f":"F5","v":4},-1,-1,-1,{"$nulls":7},{"$f":"G5","v":0},null,{"$f":"MMULT(MINVERSE(O12:R15),Z12:Z15)","v":4.8979591836734695},{"$f":"AB12*O12+AB12","v":24.489795918367349}]
[{"$nulls":7},{"$f":"IF($D$4=2,\"\",IF($D$4=3,\"\",IF($D$4=4,\"\",IF($D$4=5,\"\",IF($D$4=6,\"\",IF($D$4=7,\"\",IF($D$4=8,\"\",IF($D$4=9,AB55))))))))","v":""},"",{"$nulls":5},-1,{"$f":"F6","v":5},-1,-1,{"$nulls":7},{"$f":"G6","v":0},null,4.0816326530612246,{"$f":"AB13*P13+AB13","v":24.489795918367346}]
[{"$nulls":7},{"$f":"IF(D4=2,H5+H6,IF(D4=3,H5+H6+H7,IF(D4=4,H5+H6+H7+H8,IF(D4=5,H5+H6+H7+H8+H9,IF(D4=6,H5+H6+H7+H8+H9+H10,IF(D4=7,H5+H6+H7+H8+H9+H10+H11,IF(D4=8,H5+H6+H7+H8+H9+H10+H11+H12,IF(D4=9,H5+H6+H7+H8+H9+H10+H11+H12+H13))))))))","v":24.489795918367349},{"$nulls":6},-1,-1,{"$f":"F7","v":7},-1,{"$nulls":7},{"$f":"G7","v":0},null,3.0612244897959182,{"$f":"AB14*Q14+AB14","v":24.489795918367346}]
[{"$nulls":14},-1,-1,-1,{"$f":"F8","v":9},{"$nulls":7},{"$f":"G8","v":100},null,12.448979591836736,{"$f":"AB15*R15+AB15","v":124.48979591836735}]
[null,null,null,"Usage","In the table above, in the red cell type in the number of horses that you wish to dutch",{"$nulls":9},"5 RUNNERS",{"$nulls":10},"PROFIT",null,{"$f":"SUM(AB17:AB21)","v":-16.901408450704224}]
[{"$nulls":14},{"$f":"F5","v":4},-1,-1,-1,-1,{"$nulls":6},{"$f":"G5","v":0},null,{"$f":"MMULT(MINVERSE(O17:S21),Z17:Z21)","v":-3.3802816901408446},{"$f":"AB17*O17+AB17","v":-16.901408450704224}]
[{"$nulls":4},"In the dark grey column named 'Odds' type in the odds of each horse next to 'Horse1', 'Horse 2' etc,",{"$nulls":9},-1,{"$f":"F6","v":5},-1,-1,-1,{"$nulls":6},{"$f":"G6","v":0},null,-2.816901408450704,{"$f":"AB18*P18+AB18","v":-16.901408450704224}]
[{"$nulls":4},"down to the required number of horses .",{"$nulls":9},-1,-1,{"$f":"F7","v":7},-1,-1,{"$nulls":6},{"$f":"G7","v":0},null,-2.1126760563380285,{"$f":"AB19*Q19+AB19","v":-16.901408450704228}]
[{"$nulls":14},-1,-1,-1,{"$f":"F8","v":9},-1,{"$nulls":6},{"$f":"G8","v":100},null,8.3098591549295779,{"$f":"AB20*R20+AB20","v":83.09859154929579}]
[{"$nulls":4},"In the dark grey column named 'Req profit' type in your required profit for that particular runner,",{"$nulls":9},-1,-1,-1,-1,{"$f":"F9","v":0},{"$nulls":6},{"$f":"G9","v":0},null,-16.901408450704224,{"$f":"AB21*S21+AB21","v":-16.901408450704224}]
[{"$nulls":4},"down to the required number of horses .",{"$nulls":9},"6 RUNNERS",{"$nulls":10},"PROFIT",null,{"$f":"SUM(AB23:AB28)","v":-6.2827225130889994}]
[{"$nulls":4},"----------------------------------------------------------------------------------------------------------------------------",{"$nulls":9},{"$f":"F5","v":4},-1,-1,-1,-1,-1,{"$nulls":5},{"$f":"G5","v":0},null,{"$f":"MMULT(MINVERSE(O23:T28),Z23:Z28)","v":-1.2565445026178002},{"$f":"AB23*O23+AB23","v":-6.2827225130890003}]
[{"$nulls":4},"The table should auto calculate (press F9 to calculate if not)",{"$nulls":9},-1,{"$f":"F6","v":5},-1,-1,-1,-1,{"$nulls":5},0,null,-1.0471204188481669,{"$f":"AB24*P24+AB24","v":-6.2827225130890003}]
[{"$nulls":14},-1,-1,{"$f":"F7","v":7},-1,-1,-1,{"$nulls":5},0,null,-0.78534031413612504,{"$f":"AB25*Q25+AB25","v":-6.2827225130890003}]
[{"$nulls":4},"In the 'Stake' column, the stake required to dutch bet that particular horse will show",{"$nulls":9},-1,-1,-1,{"$f":"F8","v":9},-1,-1,{"$nulls":5},100,null,9.3717277486911019,{"$f":"AB26*R26+AB26","v":93.717277486911016}]
[{"$nulls":14},-1,-1,-1,-1,{"$f":"F9","v":0},-1,{"$nulls":5},0,null,-6.2827225130890048,{"$f":"AB27*S27+AB27","v":-6.2827225130890048}]
[{"$nulls":4},"In the 'Returns' column, the potential returns will show if that particular horse wins at the given odds ",{"$nulls":9},-1,-1,-1,-1,-1,{"$f":"F10","v":0},{"$nulls":5},0,null,-6.2827225130890048,{"$f":"AB28*T28+AB28","v":-6.2827225130890048}]
[{"$nulls":14},"7 RUNNERS",{"$nulls":10},"PROFIT",null,{"$f":"SUM(AB30:AB36)","v":-3.8585209003215386}]
[{"$nulls":4},"The green cell at the bottom of the 'Stake' column shows the total to be staked for the dutched bet.",{"$nulls":9},{"$f":"F5","v":4},-1,-1,-1,-1,-1,-1,{"$nulls":4},{"$f":"G5","v":0},null,{"$f":"MMULT(MINVERSE(O30:U36),Z30:Z36)","v":-0.77170418006430774},{"$f":"AB30*O30+AB30","v":-3.8585209003215386}]
[{"$nulls":14},-1,{"$f":"F6","v":5},-1,-1,-1,-1,-1,{"$nulls":4},0,null,-0.64308681672025658,{"$f":"AB31*P31+AB31","v":-3.8585209003215395}]
[{"$nulls":4},"You can use this sheet for dutched equal/unequal profits or saver bets if you want to bet on more",{"$nulls":9},-1,-1,{"$f":"F7","v":7},-1,-1,-1,-1,{"$nulls":4},0,null,-0.48231511254019227,{"$f":"AB32*Q32+AB32","v":-3.8585209003215382}]
[{"$nulls":4},"than one horse in a race.",{"$nulls":9},-1,-1,-1,{"$f":"F8","v":9},-1,-1,-1,{"$nulls":4},100,null,9.6141479099678477,{"$f":"AB33*R33+AB33","v":96.141479099678463}]
[{"$nulls":4},"----------------------------------------------------------------------------------------------------------------------------",{"$nulls":9},-1,-1,-1,-1,{"$f":"F9","v":0},-1,-1,{"$nulls":4},0,null,-3.858520900321543,{"$f":"AB34*S34+AB34","v":-3.858520900321543}]
[{"$nulls":4},"NB - If the stake and returns columns become red then the potential dutch bet",{"$nulls":9},-1,-1,-1,-1,-1,{"$f":"F10","v":0},-1,{"$nulls":4},0,null,-3.8585209003215439,{"$f":"AB35*T35+AB35","v":-3.8585209003215439}]
[{"$nulls":4},"WILL NOT SHOW A PROFIT given the odds being used, ",{"$nulls":9},-1,-1,-1,-1,-1,-1,{"$f":"F11","v":0},{"$nulls":4},0,null,-3.858520900321543,{"$f":"AB36*U36+AB36","v":-3.858520900321543}]
[{"$nulls":14},"8 RUNNERS",{"$nulls":10},"PROFIT",null,{"$f":"SUM(AB38:AB45)","v":-2.7842227378190243}]
[{"$nulls":4},"Certain combinations of odds create a '#NUM!' error, essentially the odds being used cancel each ",{"$nulls":9},{"$f":"F5","v":4},-1,-1,-1,-1,-1,-1,-1,null,null,null,{"$f":"G5","v":0},null,{"$f":"MMULT(MINVERSE(O38:V45),Z38:Z45)","v":-0.55684454756380486},{"$f":"AB38*O38+AB38","v":-2.7842227378190243}]
[{"$nulls":4},"other out and would not be profitable.",{"$nulls":9},-1,{"$f":"F6","v":5},-1,-1,-1,-1,-1,-1,null,null,null,0,null,-0.46403712296983729,{"$f":"AB39*P39+AB39","v":-2.7842227378190239}]
[{"$nulls":4},"----------------------------------------------------------------------------------------------------------------------------",{"$nulls":9},-1,-1,{"$f":"F7","v":7},-1,-1,-1,-1,-1,null,null,null,0,null,-0.34802784222737798,{"$f":"AB40*Q40+AB40","v":-2.7842227378190239}]
[null,null,null,"Do's and don'ts","Do make a backup of this sheet.",{"$nulls":9},-1,-1,-1,{"$f":"F8","v":9},-1,-1,-1,-1,null,null,null,100,null,9.7215777262180971,{"$f":"AB41*R41+AB41","v":97.215777262180978}]
[{"$nulls":4},"Do type in the name of the horses in the 'Runners' column (if required).",{"$nulls":9},-1,-1,-1,-1,{"$f":"F9","v":0},-1,-1,-1,null,null,null,0,null,-2.7842227378190247,{"$f":"AB42*S42+AB42","v":-2.7842227378190247}]
[{"$nulls":14},-1,-1,-1,-1,-1,{"$f":"F10","v":0},-1,-1,null,null,null,0,null,-2.7842227378190256,{"$f":"AB43*T43+AB43","v":-2.7842227378190256}]
[{"$nulls":4},"Don't alter formulas in the 'Stake' or 'Returns' columns or the formulas in the table on the",{"$nulls":9},-1,-1,-1,-1,-1,-1,{"$f":"F11","v":0},-1,null,null,null,0,null,-2.7842227378190252,{"$f":"AB44*U44+AB44","v":-2.7842227378190252}]
[{"$nulls":4},"right handside (they contain the nuts and bolts to make this sheet work)",{"$nulls":9},-1,-1,-1,-1,-1,-1,-1,{"$f":"F12","v":0},null,null,null,0,null,-2.7842227378190256,{"$f":"AB45*V45+AB45","v":-2.7842227378190256}]
[{"$nulls":14},"9 RUNNERS",{"$nulls":10},"PROFIT",null,{"$f":"SUM(AB47:AB55)","v":-2.1778584392014562}]
[{"$nulls":14},{"$f":"F5","v":4},-1,-1,-1,-1,-1,-1,-1,-1,null,null,{"$f":"G5","v":0},null,{"$f":"MMULT(MINVERSE(O47:W55),Z47:Z55)","v":-0.43557168784029093},{"$f":"AB47*O47+AB47","v":-2.1778584392014548}]
[{"$nulls":14},-1,{"$f":"F6","v":5},-1,-1,-1,-1,-1,-1,-1,null,null,0,null,-0.36297640653357605,{"$f":"AB48*P48+AB48","v":-2.1778584392014562}]
[{"$nulls":14},-1,-1,{"$f":"F7","v":7},-1,-1,-1,-1,-1,-1,null,null,0,null,-0.27223230490018185,{"$f":"AB49*Q49+AB49","v":-2.1778584392014548}]
[{"$nulls":14},-1,-1,-1,{"$f":"F8","v":9},-1,-1,-1,-1,-1,null,null,100,null,9.7822141560798528,{"$f":"AB50*R50+AB50","v":97.822141560798514}]
[{"$nulls":14},-1,-1,-1,-1,{"$f":"F9","v":0},-1,-1,-1,-1,null,null,0,null,-2.1778584392014517,{"$f":"AB51*S51+AB51","v":-2.1778584392014517}]
[{"$nulls":14},-1,-1,-1,-1,-1,{"$f":"F10","v":0},-1,-1,-1,null,null,0,null,-2.1778584392014513,{"$f":"AB52*T52+AB52","v":-2.1778584392014513}]
[{"$nulls":14},-1,-1,-1,-1,-1,-1,{"$f":"F11","v":0},-1,-1,null,null,0,null,-2.1778584392014517,{"$f":"AB53*U53+AB53","v":-2.1778584392014517}]
[{"$nulls":14},-1,-1,-1,-1,-1,-1,-1,{"$f":"F12","v":0},-1,null,null,0,null,-2.1778584392014522,{"$f":"AB54*V54+AB54","v":-2.1778584392014522}]
[{"$nulls":14},-1,-1,-1,-1,-1,-1,-1,-1,{"$f":"F13","v":0},null,null,0,null,-2.1778584392014522,{"$f":"AB55*W55+AB55","v":-2.1778584392014522}]
{"$rows_empty":140808}
["Copyright by Skylark2007/Skylark2009 - 2010 ©"]
["Copyright by Skylark2007/Skylark2009 - 2010 ©"," "]
["Copyright by Skylark2007/Skylark2009 - 2010 ©"," "]
["Copyright by Skylark2007/Skylark2009 - 2010 ©"," "]
["Copyright by Skylark2007/Skylark2009 - 2010 ©"," "]
["Copyright by Skylark2007/Skylark2009 - 2010 ©"," "]
["Copyright by Skylark2007/Skylark2009 - 2010 ©"," "]
["Copyright by Skylark2007/Skylark2009 - 2010 ©"]