{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["User Input","Calculations","Lists"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":1,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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":"User Input","index":0,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,2,0,11],[2,1,2,4],[9,1,9,5]]}
[null,null,"Western Cape Water Supply System - Dam Draw Down Estimator"]
[]
[null,"Water Usage"]
[null,"CCT Savings",0.45,{"$f":"AVERAGE(Calculations!O3:O54)","v":476.57126738385494},"Ml/d"]
[null,"Other Municipalities Savings",0.45,{"$f":"AVERAGE(Calculations!P3:P54)","v":52.952363042650582},"Ml/d"]
[null,"Agricultural Savings",0.6,{"$f":"AVERAGE(Calculations!Q3:Q54)","v":157.77673839501782},"Ml/d"]
[null,"Evaporation Losses","Normal",{"$f":"AVERAGE(Calculations!R3:R54)","v":141.79471856230879},"Ml/d"]
[]
[]
[null,"User Defined Augmentation Projects"]
[null,"Augmentation 1",null,"Ml/d","starting"]
[null,"Augmentation 2",null,"Ml/d","starting"]
[null,"Augmentation 3",null,"Ml/d","starting"]

{"sheet":"Calculations","index":1,"n_rows":54,"n_cols":25,"rows_kept":54,"cut":false,"hidden":false,"merged":[[0,2,1,2],[0,3,0,4],[0,21,1,21],[0,23,1,23],[0,24,1,24],[0,6,0,9],[0,10,0,13],[0,14,0,17],[0,18,1,18],[0,19,1,19],[0,20,1,20]]}
["Date:",null,"Week","Actual Storage",null,null,"Baseline Unrestricted Demand (Ml/d)",null,null,null,"User Change - Savings",null,null,null,"User Change - Demand (Ml/d)",null,null,null,"User -Augmentation (Ml/d)","Inflow (Ml/d)","Storage (MCM)","Storage (%)",null,"DSL (%)","Day Zero (%)"]
[{"$f":"TODAY()-1","v":"2018-01-23"},null,null,"MCM","%",null,"CCT","Other M","Agric","Evap","CCT","Other M","Agric","Evap","CCT","Other M","Agric","Evap"]
[null,null,"2017-11-05",339.59699999999998,0.37733,null,891.65518767114122,99.072798630126726,287.22222222222234,260.67844651643998,{"$f":"'User Input'!$C$4","v":0.45},{"$f":"'User Input'!$C$5","v":0.45},{"$f":"'User Input'!$C$6","v":0.6},{"$f":"IF('User Input'!$C$7=\"Normal\",1, IF('User Input'!$C$7=\"Low\",0.8,1.2))","v":1},{"$f":"(1-K3)*G3","v":490.41035321912773},{"$f":"(1-L3)*H3","v":54.490039246569701},114.88888888888894,{"$f":"N3*J3","v":260.67844651643998},{"$f":"IF(C3>='User Input'!$F$11,'User Input'!$C$11,0)+IF(C3>='User Input'!$F$12,'User Input'!$C$12,0)+IF(C3>='User Input'!$F$13,'User Input'!$C$13,0)","v":0},0,null,null,null,0.1,0.13500000000000001]
[null,null,{"$f":"C3+7","v":"2017-11-12"},330.86720399999996,0.36763022666666662,null,891.65518767114122,99.072798630126726,287.22222222222234,260.67844651643998,{"$f":"'User Input'!$C$4","v":0.45},{"$f":"'User Input'!$C$5","v":0.45},{"$f":"'User Input'!$C$6","v":0.6},{"$f":"IF('User Input'!$C$7=\"Normal\",1, IF('User Input'!$C$7=\"Low\",0.8,1.2))","v":1},{"$f":"(1-K4)*G4","v":490.41035321912773},54.490039246569701,114.88888888888894,{"$f":"N4*J4","v":260.67844651643998},{"$f":"IF(C4>='User Input'!$F$11,'User Input'!$C$11,0)+IF(C4>='User Input'!$F$12,'User Input'!$C$12,0)+IF(C4>='User Input'!$F$13,'User Input'!$C$13,0)","v":0},0,null,null,null,0.1,0.13500000000000001]
[null,null,{"$f":"C4+7","v":"2017-11-19"},325.27300000000002,0.36141444444444448,null,891.65518767114122,99.072798630126726,287.22222222222234,260.67844651643998,{"$f":"'User Input'!$C$4","v":0.45},{"$f":"'User Input'!$C$5","v":0.45},{"$f":"'User Input'!$C$6","v":0.6},{"$f":"IF('User Input'!$C$7=\"Normal\",1, IF('User Input'!$C$7=\"Low\",0.8,1.2))","v":1},490.41035321912773,54.490039246569701,114.88888888888894,260.67844651643998,{"$f":"IF(C5>='User Input'!$F$11,'User Input'!$C$11,0)+IF(C5>='User Input'!$F$12,'User Input'!$C$12,0)+IF(C5>='User Input'!$F$13,'User Input'!$C$13,0)","v":0},0,null,null,null,0.1,0.13500000000000001]
[null,null,"2017-11-26",324.5634,0.360626,null,891.65518767114122,99.072798630126726,287.22222222222234,260.67844651643998,{"$f":"'User Input'!$C$4","v":0.45},{"$f":"'User Input'!$C$5","v":0.45},{"$f":"'User Input'!$C$6","v":0.6},{"$f":"IF('User Input'!$C$7=\"Normal\",1, IF('User Input'!$C$7=\"Low\",0.8,1.2))","v":1},490.41035321912773,54.490039246569701,114.88888888888894,260.67844651643998,{"$f":"IF(C6>='User Input'!$F$11,'User Input'!$C$11,0)+IF(C6>='User Input'!$F$12,'User Input'!$C$12,0)+IF(C6>='User Input'!$F$13,'User Input'!$C$13,0)","v":0},0,null,null,null,0.1,0.13500000000000001]
[null,null,"2017-12-03",315.48007799999999,0.35053341999999998,null,932.28164863420818,103.58684984824538,769.35483870967698,285.72956260646345,{"$f":"'User Input'!$C$4","v":0.45},{"$f":"'User Input'!$C$5","v":0.45},{"$f":"'User Input'!$C$6","v":0.6},{"$f":"IF('User Input'!$C$7=\"Normal\",1, IF('User Input'!$C$7=\"Low\",0.8,1.2))","v":1},512.75490674881451,56.972767416534964,307.7419354838708,285.72956260646345,{"$f":"IF(C7>='User Input'!$F$11,'User Input'!$C$11,0)+IF(C7>='User Input'!$F$12,'User Input'!$C$12,0)+IF(C7>='User Input'!$F$13,'User Input'!$C$13,0)","v":0},0,null,null,null,0.1,0.13500000000000001]
[null,null,"2017-12-10",306.83,0.34092222222222218,null,932.28164863420818,103.58684984824538,769.35483870967698,285.72956260646345,{"$f":"'User Input'!$C$4","v":0.45},{"$f":"'User Input'!$C$5","v":0.45},{"$f":"'User Input'!$C$6","v":0.6},{"$f":"IF('User Input'!$C$7=\"Normal\",1, IF('User Input'!$C$7=\"Low\",0.8,1.2))","v":1},{"$f":"(1-K8)*G8","v":512.75490674881451},56.972767416534964,307.7419354838708,285.72956260646345,{"$f":"IF(C8>='User Input'!$F$11,'User Input'!$C$11,0)+IF(C8>='User Input'!$F$12,'User Input'!$C$12,0)+IF(C8>='User Input'!$F$13,'User Input'!$C$13,0)","v":0},0,null,null,null,0.1,0.13500000000000001]
[null,null,"2017-12-17",296.77843200000007,0.32975381333333342,null,932.28164863420818,103.58684984824538,769.35483870967698,285.72956260646345,{"$f":"'User Input'!$C$4","v":0.45},{"$f":"'User Input'!$C$5","v":0.45},{"$f":"'User Input'!$C$6","v":0.6},{"$f":"IF('User Input'!$C$7=\"Normal\",1, IF('User Input'!$C$7=\"Low\",0.8,1.2))","v":1},512.75490674881451,56.972767416534964,307.7419354838708,285.72956260646345,{"$f":"IF(C9>='User Input'!$F$11,'User Input'!$C$11,0)+IF(C9>='User Input'!$F$12,'User Input'!$C$12,0)+IF(C9>='User Input'!$F$13,'User Input'!$C$13,0)","v":0},0,null,null,null,0.1,0.13500000000000001]
[null,null,"2017-12-24",287.35118299999999,0.31927909222222223,null,932.28164863420818,103.58684984824538,769.35483870967698,285.72956260646345,{"$f":"'User Input'!$C$4","v":0.45},{"$f":"'User Input'!$C$5","v":0.45},{"$f":"'User Input'!$C$6","v":0.6},{"$f":"IF('User Input'!$C$7=\"Normal\",1, IF('User Input'!$C$7=\"Low\",0.8,1.2))","v":1},{"$f":"(1-K10)*G10","v":512.75490674881451},56.972767416534964,307.7419354838708,285.72956260646345,{"$f":"IF(C10>='User Input'!$F$11,'User Input'!$C$11,0)+IF(C10>='User Input'!$F$12,'User Input'!$C$12,0)+IF(C10>='User Input'!$F$13,'User Input'!$C$13,0)","v":0},0,null,null,null,0.1,0.13500000000000001]
[null,null,"2017-12-31",278.88379900000001,0.30987088777777777,null,932.28164863420818,103.58684984824538,769.35483870967698,285.72956260646345,{"$f":"'User Input'!$C$4","v":0.45},{"$f":"'User Input'!$C$5","v":0.45},{"$f":"'User Input'!$C$6","v":0.6},{"$f":"IF('User Input'!$C$7=\"Normal\",1, IF('User Input'!$C$7=\"Low\",0.8,1.2))","v":1},512.75490674881451,56.972767416534964,307.7419354838708,285.72956260646345,{"$f":"IF(C11>='User Input'!$F$11,'User Input'!$C$11,0)+IF(C11>='User Input'!$F$12,'User Input'!$C$12,0)+IF(C11>='User Input'!$F$13,'User Input'!$C$13,0)","v":0},0,null,null,null,0.1,0.13500000000000001]
[null,null,"2018-01-07",267.06299999999999,0.29673666666666665,null,932.28164863420818,103.58684984824538,1015.0537634408601,281.54960788102062,{"$f":"'User Input'!$C$4","v":0.45},{"$f":"'User Input'!$C$5","v":0.45},{"$f":"'User Input'!$C$6","v":0.6},{"$f":"IF('User Input'!$C$7=\"Normal\",1, IF('User Input'!$C$7=\"Low\",0.8,1.2))","v":1},512.75490674881451,56.972767416534964,406.02150537634407,281.54960788102062,{"$f":"IF(C12>='User Input'!$F$11,'User Input'!$C$11,0)+IF(C12>='User Input'!$F$12,'User Input'!$C$12,0)+IF(C12>='User Input'!$F$13,'User Input'!$C$13,0)","v":0},0,null,null,null,0.1,0.13500000000000001]
[null,null,"2018-01-14",257.71501499999999,0.28635001666666665,null,932.28164863420818,103.58684984824538,1015.0537634408601,281.54960788102062,{"$f":"'User Input'!$C$4","v":0.45},{"$f":"'User Input'!$C$5","v":0.45},{"$f":"'User Input'!$C$6","v":0.6},{"$f":"IF('User Input'!$C$7=\"Normal\",1, IF('User Input'!$C$7=\"Low\",0.8,1.2))","v":1},512.75490674881451,56.972767416534964,406.02150537634407,281.54960788102062,{"$f":"IF(C13>='User Input'!$F$11,'User Input'!$C$11,0)+IF(C13>='User Input'!$F$12,'User Input'!$C$12,0)+IF(C13>='User Input'!$F$13,'User Input'!$C$13,0)","v":0},0,null,null,null,0.1,0.13500000000000001]
[null,null,"2018-01-21",244.78874700000003,0.27198749666666672,null,932.28164863420818,103.58684984824538,1015.0537634408601,281.54960788102062,{"$f":"'User Input'!$C$4","v":0.45},{"$f":"'User Input'!$C$5","v":0.45},{"$f":"'User Input'!$C$6","v":0.6},{"$f":"IF('User Input'!$C$7=\"Normal\",1, IF('User Input'!$C$7=\"Low\",0.8,1.2))","v":1},512.75490674881451,56.972767416534964,406.02150537634407,281.54960788102062,{"$f":"IF(C14>='User Input'!$F$11,'User Input'!$C$11,0)+IF(C14>='User Input'!$F$12,'User Input'!$C$12,0)+IF(C14>='User Input'!$F$13,'User Input'!$C$13,0)","v":0},0,{"$f":"D14","v":244.78874700000003},{"$f":"U14/900","v":0.27198749666666672},null,0.1,0.13500000000000001]
[null,null,"2018-01-28",null,null,null,932.28164863420818,103.58684984824538,1015.0537634408601,281.54960788102062,{"$f":"'User Input'!$C$4","v":0.45},{"$f":"'User Input'!$C$5","v":0.45},{"$f":"'User Input'!$C$6","v":0.6},{"$f":"IF('User Input'!$C$7=\"Normal\",1, IF('User Input'!$C$7=\"Low\",0.8,1.2))","v":1},512.75490674881451,56.972767416534964,406.02150537634407,281.54960788102062,{"$f":"IF(C15>='User Input'!$F$11,'User Input'!$C$11,0)+IF(C15>='User Input'!$F$12,'User Input'!$C$12,0)+IF(C15>='User Input'!$F$13,'User Input'!$C$13,0)","v":0},0,{"$f":"U14+(S15+T15)*7/1000-(O15+P15+Q15+R15)*7/1000","v":235.98765548804104},0.26220850609782337,null,0.1,0.13500000000000001]
[null,null,"2018-02-04",null,null,null,985.70280671876048,109.52253407986223,1063.3597883597859,241.15416659168304,{"$f":"'User Input'!$C$4","v":0.45},{"$f":"'User Input'!$C$5","v":0.45},{"$f":"'User Input'!$C$6","v":0.6},{"$f":"IF('User Input'!$C$7=\"Normal\",1, IF('User Input'!$C$7=\"Low\",0.8,1.2))","v":1},542.13654369531832,60.23739374392423,425.34391534391438,241.15416659168304,{"$f":"IF(C16>='User Input'!$F$11,'User Input'!$C$11,0)+IF(C16>='User Input'!$F$12,'User Input'!$C$12,0)+IF(C16>='User Input'!$F$13,'User Input'!$C$13,0)","v":0},0,{"$f":"U15+(S16+T16)*7/1000-(O16+P16+Q16+R16)*7/1000","v":227.10555135241717},0.25233950150268575,null,0.1,0.13500000000000001]
[null,null,"2018-02-11",null,null,null,985.70280671876048,109.52253407986223,1063.3597883597859,241.15416659168304,{"$f":"'User Input'!$C$4","v":0.45},{"$f":"'User Input'!$C$5","v":0.45},{"$f":"'User Input'!$C$6","v":0.6},{"$f":"IF('User Input'!$C$7=\"Normal\",1, IF('User Input'!$C$7=\"Low\",0.8,1.2))","v":1},542.13654369531832,60.23739374392423,425.34391534391438,241.15416659168304,{"$f":"IF(C17>='User Input'!$F$11,'User Input'!$C$11,0)+IF(C17>='User Input'!$F$12,'User Input'!$C$12,0)+IF(C17>='User Input'!$F$13,'User Input'!$C$13,0)","v":0},0,218.22344721679329,0.2424704969075481,null,0.1,0.13500000000000001]
[null,null,"2018-02-18",null,null,null,985.70280671876048,109.52253407986223,1063.3597883597859,241.15416659168304,{"$f":"'User Input'!$C$4","v":0.45},{"$f":"'User Input'!$C$5","v":0.45},{"$f":"'User Input'!$C$6","v":0.6},{"$f":"IF('User Input'!$C$7=\"Normal\",1, IF('User Input'!$C$7=\"Low\",0.8,1.2))","v":1},542.13654369531832,60.23739374392423,425.34391534391438,241.15416659168304,{"$f":"IF(C18>='User Input'!$F$11,'User Input'!$C$11,0)+IF(C18>='User Input'!$F$12,'User Input'!$C$12,0)+IF(C18>='User Input'!$F$13,'User Input'!$C$13,0)","v":0},0,209.34134308116941,0.23260149231241045,null,0.1,0.13500000000000001]
[null,null,"2018-02-25",null,null,null,985.70280671876048,109.52253407986223,1063.3597883597859,241.15416659168304,{"$f":"'User Input'!$C$4","v":0.45},{"$f":"'User Input'!$C$5","v":0.45},{"$f":"'User Input'!$C$6","v":0.6},{"$f":"IF('User Input'!$C$7=\"Normal\",1, IF('User Input'!$C$7=\"Low\",0.8,1.2))","v":1},542.13654369531832,60.23739374392423,425.34391534391438,241.15416659168304,{"$f":"IF(C19>='User Input'!$F$11,'User Input'!$C$11,0)+IF(C19>='User Input'!$F$12,'User Input'!$C$12,0)+IF(C19>='User Input'!$F$13,'User Input'!$C$13,0)","v":0},0,200.45923894554554,0.22273248771727283,null,0.1,0.13500000000000001]
[null,null,"2018-03-04",null,null,null,904.58178888666259,100.5090876540736,878.55436081242499,168.67321776956172,{"$f":"'User Input'!$C$4","v":0.45},{"$f":"'User Input'!$C$5","v":0.45},{"$f":"'User Input'!$C$6","v":0.6},{"$f":"IF('User Input'!$C$7=\"Normal\",1, IF('User Input'!$C$7=\"Low\",0.8,1.2))","v":1},497.51998388766447,55.279998209740484,351.42174432497001,168.67321776956172,{"$f":"IF(C20>='User Input'!$F$11,'User Input'!$C$11,0)+IF(C20>='User Input'!$F$12,'User Input'!$C$12,0)+IF(C20>='User Input'!$F$13,'User Input'!$C$13,0)","v":0},0,192.94897433620199,0.21438774926244664,null,0.1,0.13500000000000001]
[null,null,"2018-03-11",null,null,null,904.58178888666259,100.5090876540736,878.55436081242499,168.67321776956172,{"$f":"'User Input'!$C$4","v":0.45},{"$f":"'User Input'!$C$5","v":0.45},{"$f":"'User Input'!$C$6","v":0.6},{"$f":"IF('User Input'!$C$7=\"Normal\",1, IF('User Input'!$C$7=\"Low\",0.8,1.2))","v":1},497.51998388766447,55.279998209740484,351.42174432497001,168.67321776956172,{"$f":"IF(C21>='User Input'!$F$11,'User Input'!$C$11,0)+IF(C21>='User Input'!$F$12,'User Input'!$C$12,0)+IF(C21>='User Input'!$F$13,'User Input'!$C$13,0)","v":0},0,185.43870972685843,0.20604301080762047,null,0.1,0.13500000000000001]
[null,null,"2018-03-18",null,null,null,904.58178888666259,100.5090876540736,878.55436081242499,168.67321776956172,{"$f":"'User Input'!$C$4","v":0.45},{"$f":"'User Input'!$C$5","v":0.45},{"$f":"'User Input'!$C$6","v":0.6},{"$f":"IF('User Input'!$C$7=\"Normal\",1, IF('User Input'!$C$7=\"Low\",0.8,1.2))","v":1},497.51998388766447,55.279998209740484,351.42174432497001,168.67321776956172,{"$f":"IF(C22>='User Input'!$F$11,'User Input'!$C$11,0)+IF(C22>='User Input'!$F$12,'User Input'!$C$12,0)+IF(C22>='User Input'!$F$13,'User Input'!$C$13,0)","v":0},0,177.92844511751488,0.1976982723527943,null,0.1,0.13500000000000001]
[null,null,"2018-03-25",null,null,null,904.58178888666259,100.5090876540736,878.55436081242499,168.67321776956172,{"$f":"'User Input'!$C$4","v":0.45},{"$f":"'User Input'!$C$5","v":0.45},{"$f":"'User Input'!$C$6","v":0.6},{"$f":"IF('User Input'!$C$7=\"Normal\",1, IF('User Input'!$C$7=\"Low\",0.8,1.2))","v":1},497.51998388766447,55.279998209740484,351.42174432497001,168.67321776956172,{"$f":"IF(C23>='User Input'!$F$11,'User Input'!$C$11,0)+IF(C23>='User Input'!$F$12,'User Input'!$C$12,0)+IF(C23>='User Input'!$F$13,'User Input'!$C$13,0)","v":0},4.7619047619047619,{"$f":"U22+(S23+T23)*7/1000-(O23+P23+Q23+R23)*7/1000","v":170.45151384150466},0.18939057093500519,null,0.1,0.13500000000000001]
[null,null,"2018-04-01",null,null,null,877.34359346824283,97.482621496471438,484.69135802469134,99.828728904701535,{"$f":"'User Input'!$C$4","v":0.45},{"$f":"'User Input'!$C$5","v":0.45},{"$f":"'User Input'!$C$6","v":0.6},{"$f":"IF('User Input'!$C$7=\"Normal\",1, IF('User Input'!$C$7=\"Low\",0.8,1.2))","v":1},482.5389764075336,53.615441823059292,193.87654320987656,99.828728904701535,{"$f":"IF(C24>='User Input'!$F$11,'User Input'!$C$11,0)+IF(C24>='User Input'!$F$12,'User Input'!$C$12,0)+IF(C24>='User Input'!$F$13,'User Input'!$C$13,0)","v":0},33.333333333333336,164.87582934242178,0.1831953659360242,null,0.1,0.13500000000000001]
[null,null,"2018-04-08",null,null,null,877.34359346824283,97.482621496471438,484.69135802469134,99.828728904701535,{"$f":"'User Input'!$C$4","v":0.45},{"$f":"'User Input'!$C$5","v":0.45},{"$f":"'User Input'!$C$6","v":0.6},{"$f":"IF('User Input'!$C$7=\"Normal\",1, IF('User Input'!$C$7=\"Low\",0.8,1.2))","v":1},482.5389764075336,53.615441823059292,193.87654320987656,99.828728904701535,{"$f":"IF(C25>='User Input'!$F$11,'User Input'!$C$11,0)+IF(C25>='User Input'!$F$12,'User Input'!$C$12,0)+IF(C25>='User Input'!$F$13,'User Input'!$C$13,0)","v":0},33.333333333333336,159.3001448433389,{"$f":"U25/900","v":0.17700016093704321},null,0.1,0.13500000000000001]
[null,null,"2018-04-15",null,null,null,877.34359346824283,97.482621496471438,484.69135802469134,99.828728904701535,{"$f":"'User Input'!$C$4","v":0.45},{"$f":"'User Input'!$C$5","v":0.45},{"$f":"'User Input'!$C$6","v":0.6},{"$f":"IF('User Input'!$C$7=\"Normal\",1, IF('User Input'!$C$7=\"Low\",0.8,1.2))","v":1},482.5389764075336,53.615441823059292,193.87654320987656,99.828728904701535,{"$f":"IF(C26>='User Input'!$F$11,'User Input'!$C$11,0)+IF(C26>='User Input'!$F$12,'User Input'!$C$12,0)+IF(C26>='User Input'!$F$13,'User Input'!$C$13,0)","v":0},33.333333333333336,153.72446034425602,{"$f":"U26/900","v":0.17080495593806225},null,0.1,0.13500000000000001]
[null,null,"2018-04-22",null,null,null,877.34359346824283,97.482621496471438,484.69135802469134,99.828728904701535,{"$f":"'User Input'!$C$4","v":0.45},{"$f":"'User Input'!$C$5","v":0.45},{"$f":"'User Input'!$C$6","v":0.6},{"$f":"IF('User Input'!$C$7=\"Normal\",1, IF('User Input'!$C$7=\"Low\",0.8,1.2))","v":1},482.5389764075336,53.615441823059292,193.87654320987656,99.828728904701535,{"$f":"IF(C27>='User Input'!$F$11,'User Input'!$C$11,0)+IF(C27>='User Input'!$F$12,'User Input'!$C$12,0)+IF(C27>='User Input'!$F$13,'User Input'!$C$13,0)","v":0},33.333333333333336,148.14877584517313,0.16460975093908126,null,0.1,0.13500000000000001]
[null,null,"2018-04-29",null,null,null,877.34359346824283,97.482621496471438,484.69135802469134,99.828728904701535,{"$f":"'User Input'!$C$4","v":0.45},{"$f":"'User Input'!$C$5","v":0.45},{"$f":"'User Input'!$C$6","v":0.6},{"$f":"IF('User Input'!$C$7=\"Normal\",1, IF('User Input'!$C$7=\"Low\",0.8,1.2))","v":1},482.5389764075336,53.615441823059292,193.87654320987656,99.828728904701535,{"$f":"IF(C28>='User Input'!$F$11,'User Input'!$C$11,0)+IF(C28>='User Input'!$F$12,'User Input'!$C$12,0)+IF(C28>='User Input'!$F$13,'User Input'!$C$13,0)","v":0},198.31029185867897,143.72793005576767,0.15969770006196407,null,0.1,0.13500000000000001]
[null,null,"2018-05-06",null,null,null,821.48220964402583,91.275801071558362,54.599761051373946,48.837507742513871,{"$f":"'User Input'!$C$4","v":0.45},{"$f":"'User Input'!$C$5","v":0.45},{"$f":"'User Input'!$C$6","v":0.6},{"$f":"IF('User Input'!$C$7=\"Normal\",1, IF('User Input'!$C$7=\"Low\",0.8,1.2))","v":1},451.81521530421423,50.201690589357106,21.83990442054958,48.837507742513871,{"$f":"IF(C29>='User Input'!$F$11,'User Input'!$C$11,0)+IF(C29>='User Input'!$F$12,'User Input'!$C$12,0)+IF(C29>='User Input'!$F$13,'User Input'!$C$13,0)","v":0},225.80645161290323,141.29971499066156,0.15699968332295727,null,0.1,0.13500000000000001]
[null,null,"2018-05-13",null,null,null,821.48220964402583,91.275801071558362,54.599761051373946,48.837507742513871,{"$f":"'User Input'!$C$4","v":0.45},{"$f":"'User Input'!$C$5","v":0.45},{"$f":"'User Input'!$C$6","v":0.6},{"$f":"IF('User Input'!$C$7=\"Normal\",1, IF('User Input'!$C$7=\"Low\",0.8,1.2))","v":1},451.81521530421423,50.201690589357106,21.83990442054958,48.837507742513871,{"$f":"IF(C30>='User Input'!$F$11,'User Input'!$C$11,0)+IF(C30>='User Input'!$F$12,'User Input'!$C$12,0)+IF(C30>='User Input'!$F$13,'User Input'!$C$13,0)","v":0},225.80645161290323,138.87149992555544,0.1543016665839505,null,0.1,0.13500000000000001]
[null,null,"2018-05-20",null,null,null,821.48220964402583,91.275801071558362,54.599761051373946,48.837507742513871,{"$f":"'User Input'!$C$4","v":0.45},{"$f":"'User Input'!$C$5","v":0.45},{"$f":"'User Input'!$C$6","v":0.6},{"$f":"IF('User Input'!$C$7=\"Normal\",1, IF('User Input'!$C$7=\"Low\",0.8,1.2))","v":1},451.81521530421423,50.201690589357106,21.83990442054958,48.837507742513871,{"$f":"IF(C31>='User Input'!$F$11,'User Input'!$C$11,0)+IF(C31>='User Input'!$F$12,'User Input'!$C$12,0)+IF(C31>='User Input'!$F$13,'User Input'!$C$13,0)","v":0},225.80645161290323,136.44328486044932,0.15160364984494371,null,0.1,0.13500000000000001]
[null,null,"2018-05-27",null,null,null,821.48220964402583,91.275801071558362,54.599761051373946,48.837507742513871,{"$f":"'User Input'!$C$4","v":0.45},{"$f":"'User Input'!$C$5","v":0.45},{"$f":"'User Input'!$C$6","v":0.6},{"$f":"IF('User Input'!$C$7=\"Normal\",1, IF('User Input'!$C$7=\"Low\",0.8,1.2))","v":1},451.81521530421423,50.201690589357106,21.83990442054958,48.837507742513871,{"$f":"IF(C32>='User Input'!$F$11,'User Input'!$C$11,0)+IF(C32>='User Input'!$F$12,'User Input'!$C$12,0)+IF(C32>='User Input'!$F$13,'User Input'!$C$13,0)","v":0},271.88940092165899,134.33765044050449,0.14926405604500498,null,0.1,0.13500000000000001]
[null,null,"2018-06-03",null,null,null,805.78562245375008,89.531735828194428,28.209876543209877,33.612257202341219,{"$f":"'User Input'!$C$4","v":0.45},{"$f":"'User Input'!$C$5","v":0.45},{"$f":"'User Input'!$C$6","v":0.6},{"$f":"IF('User Input'!$C$7=\"Normal\",1, IF('User Input'!$C$7=\"Low\",0.8,1.2))","v":1},443.18209234956259,49.242454705506937,11.283950617283951,33.612257202341219,{"$f":"IF(C33>='User Input'!$F$11,'User Input'!$C$11,0)+IF(C33>='User Input'!$F$12,'User Input'!$C$12,0)+IF(C33>='User Input'!$F$13,'User Input'!$C$13,0)","v":0},333.33333333333331,132.90973848971498,0.14767748721079443,null,0.1,0.13500000000000001]
[null,null,"2018-06-10",null,null,null,805.78562245375008,89.531735828194428,28.209876543209877,33.612257202341219,{"$f":"'User Input'!$C$4","v":0.45},{"$f":"'User Input'!$C$5","v":0.45},{"$f":"'User Input'!$C$6","v":0.6},{"$f":"IF('User Input'!$C$7=\"Normal\",1, IF('User Input'!$C$7=\"Low\",0.8,1.2))","v":1},443.18209234956259,49.242454705506937,11.283950617283951,33.612257202341219,{"$f":"IF(C34>='User Input'!$F$11,'User Input'!$C$11,0)+IF(C34>='User Input'!$F$12,'User Input'!$C$12,0)+IF(C34>='User Input'!$F$13,'User Input'!$C$13,0)","v":0},333.33333333333331,131.48182653892547,0.14609091837658386,null,0.1,0.13500000000000001]
[null,null,"2018-06-17",null,null,null,805.78562245375008,89.531735828194428,28.209876543209877,33.612257202341219,{"$f":"'User Input'!$C$4","v":0.45},{"$f":"'User Input'!$C$5","v":0.45},{"$f":"'User Input'!$C$6","v":0.6},{"$f":"IF('User Input'!$C$7=\"Normal\",1, IF('User Input'!$C$7=\"Low\",0.8,1.2))","v":1},443.18209234956259,49.242454705506937,11.283950617283951,33.612257202341219,{"$f":"IF(C35>='User Input'!$F$11,'User Input'!$C$11,0)+IF(C35>='User Input'!$F$12,'User Input'!$C$12,0)+IF(C35>='User Input'!$F$13,'User Input'!$C$13,0)","v":0},333.33333333333331,130.05391458813597,0.14450434954237329,null,0.1,0.13500000000000001]
[null,null,"2018-06-24",null,null,null,805.78562245375008,89.531735828194428,28.209876543209877,33.612257202341219,{"$f":"'User Input'!$C$4","v":0.45},{"$f":"'User Input'!$C$5","v":0.45},{"$f":"'User Input'!$C$6","v":0.6},{"$f":"IF('User Input'!$C$7=\"Normal\",1, IF('User Input'!$C$7=\"Low\",0.8,1.2))","v":1},443.18209234956259,49.242454705506937,11.283950617283951,33.612257202341219,{"$f":"IF(C36>='User Input'!$F$11,'User Input'!$C$11,0)+IF(C36>='User Input'!$F$12,'User Input'!$C$12,0)+IF(C36>='User Input'!$F$13,'User Input'!$C$13,0)","v":0},442.39631336405529,129.3894434975615,0.1437660483306239,null,0.1,0.13500000000000001]
[null,null,"2018-07-01",null,null,null,779.93242002270756,86.659157780300802,27.299880525686973,28.449717830206762,{"$f":"'User Input'!$C$4","v":0.45},{"$f":"'User Input'!$C$5","v":0.45},{"$f":"'User Input'!$C$6","v":0.6},{"$f":"IF('User Input'!$C$7=\"Normal\",1, IF('User Input'!$C$7=\"Low\",0.8,1.2))","v":1},428.96283101248918,47.662536779165443,10.91995221027479,28.449717830206762,{"$f":"IF(C37>='User Input'!$F$11,'User Input'!$C$11,0)+IF(C37>='User Input'!$F$12,'User Input'!$C$12,0)+IF(C37>='User Input'!$F$13,'User Input'!$C$13,0)","v":0},1096.7741935483871,133.45489758757526,0.14828321954175028,null,0.1,0.13500000000000001]
[null,null,"2018-07-08",null,null,null,779.93242002270756,86.659157780300802,27.299880525686973,28.449717830206762,{"$f":"'User Input'!$C$4","v":0.45},{"$f":"'User Input'!$C$5","v":0.45},{"$f":"'User Input'!$C$6","v":0.6},{"$f":"IF('User Input'!$C$7=\"Normal\",1, IF('User Input'!$C$7=\"Low\",0.8,1.2))","v":1},428.96283101248918,47.662536779165443,10.91995221027479,28.449717830206762,{"$f":"IF(C38>='User Input'!$F$11,'User Input'!$C$11,0)+IF(C38>='User Input'!$F$12,'User Input'!$C$12,0)+IF(C38>='User Input'!$F$13,'User Input'!$C$13,0)","v":0},1096.7741935483871,137.52035167758902,0.15280039075287669,null,0.1,0.13500000000000001]
[null,null,"2018-07-15",null,null,null,779.93242002270756,86.659157780300802,27.299880525686973,28.449717830206762,{"$f":"'User Input'!$C$4","v":0.45},{"$f":"'User Input'!$C$5","v":0.45},{"$f":"'User Input'!$C$6","v":0.6},{"$f":"IF('User Input'!$C$7=\"Normal\",1, IF('User Input'!$C$7=\"Low\",0.8,1.2))","v":1},428.96283101248918,47.662536779165443,10.91995221027479,28.449717830206762,{"$f":"IF(C39>='User Input'!$F$11,'User Input'!$C$11,0)+IF(C39>='User Input'!$F$12,'User Input'!$C$12,0)+IF(C39>='User Input'!$F$13,'User Input'!$C$13,0)","v":0},1096.7741935483871,141.58580576760278,0.15731756196400309,null,0.1,0.13500000000000001]
[null,null,"2018-07-22",null,null,null,779.93242002270756,86.659157780300802,27.299880525686973,28.449717830206762,{"$f":"'User Input'!$C$4","v":0.45},{"$f":"'User Input'!$C$5","v":0.45},{"$f":"'User Input'!$C$6","v":0.6},{"$f":"IF('User Input'!$C$7=\"Normal\",1, IF('User Input'!$C$7=\"Low\",0.8,1.2))","v":1},428.96283101248918,47.662536779165443,10.91995221027479,28.449717830206762,{"$f":"IF(C40>='User Input'!$F$11,'User Input'!$C$11,0)+IF(C40>='User Input'!$F$12,'User Input'!$C$12,0)+IF(C40>='User Input'!$F$13,'User Input'!$C$13,0)","v":0},1096.7741935483871,145.65125985761654,0.16183473317512947,null,0.1,0.13500000000000001]
[null,null,"2018-07-29",null,null,null,779.93242002270756,86.659157780300802,27.299880525686973,28.449717830206762,{"$f":"'User Input'!$C$4","v":0.45},{"$f":"'User Input'!$C$5","v":0.45},{"$f":"'User Input'!$C$6","v":0.6},{"$f":"IF('User Input'!$C$7=\"Normal\",1, IF('User Input'!$C$7=\"Low\",0.8,1.2))","v":1},428.96283101248918,47.662536779165443,10.91995221027479,28.449717830206762,{"$f":"IF(C41>='User Input'!$F$11,'User Input'!$C$11,0)+IF(C41>='User Input'!$F$12,'User Input'!$C$12,0)+IF(C41>='User Input'!$F$13,'User Input'!$C$13,0)","v":0},1880.1843317972348,155.20058491537222,0.17244509435041358,null,0.1,0.13500000000000001]
[null,null,"2018-08-05",null,null,null,793.78234989648024,88.198038877386693,27.299880525686973,45.155430071322932,{"$f":"'User Input'!$C$4","v":0.45},{"$f":"'User Input'!$C$5","v":0.45},{"$f":"'User Input'!$C$6","v":0.6},{"$f":"IF('User Input'!$C$7=\"Normal\",1, IF('User Input'!$C$7=\"Low\",0.8,1.2))","v":1},436.5802924430642,48.508921382562683,10.91995221027479,45.155430071322932,{"$f":"IF(C42>='User Input'!$F$11,'User Input'!$C$11,0)+IF(C42>='User Input'!$F$12,'User Input'!$C$12,0)+IF(C42>='User Input'!$F$13,'User Input'!$C$13,0)","v":0},2193.5483870967741,166.76727145229904,0.18529696828033226,null,0.1,0.13500000000000001]
[null,null,"2018-08-12",null,null,null,793.78234989648024,88.198038877386693,27.299880525686973,45.155430071322932,{"$f":"'User Input'!$C$4","v":0.45},{"$f":"'User Input'!$C$5","v":0.45},{"$f":"'User Input'!$C$6","v":0.6},{"$f":"IF('User Input'!$C$7=\"Normal\",1, IF('User Input'!$C$7=\"Low\",0.8,1.2))","v":1},436.5802924430642,48.508921382562683,10.91995221027479,45.155430071322932,{"$f":"IF(C43>='User Input'!$F$11,'User Input'!$C$11,0)+IF(C43>='User Input'!$F$12,'User Input'!$C$12,0)+IF(C43>='User Input'!$F$13,'User Input'!$C$13,0)","v":0},2193.5483870967741,178.33395798922587,0.19814884221025097,null,0.1,0.13500000000000001]
[null,null,"2018-08-19",null,null,null,793.78234989648024,88.198038877386693,27.299880525686973,45.155430071322932,{"$f":"'User Input'!$C$4","v":0.45},{"$f":"'User Input'!$C$5","v":0.45},{"$f":"'User Input'!$C$6","v":0.6},{"$f":"IF('User Input'!$C$7=\"Normal\",1, IF('User Input'!$C$7=\"Low\",0.8,1.2))","v":1},436.5802924430642,48.508921382562683,10.91995221027479,45.155430071322932,{"$f":"IF(C44>='User Input'!$F$11,'User Input'!$C$11,0)+IF(C44>='User Input'!$F$12,'User Input'!$C$12,0)+IF(C44>='User Input'!$F$13,'User Input'!$C$13,0)","v":0},2193.5483870967741,189.90064452615269,0.21100071614016966,null,0.1,0.13500000000000001]
[null,null,"2018-08-26",null,null,null,793.78234989648024,88.198038877386693,27.299880525686973,45.155430071322932,{"$f":"'User Input'!$C$4","v":0.45},{"$f":"'User Input'!$C$5","v":0.45},{"$f":"'User Input'!$C$6","v":0.6},{"$f":"IF('User Input'!$C$7=\"Normal\",1, IF('User Input'!$C$7=\"Low\",0.8,1.2))","v":1},436.5802924430642,48.508921382562683,10.91995221027479,45.155430071322932,{"$f":"IF(C45>='User Input'!$F$11,'User Input'!$C$11,0)+IF(C45>='User Input'!$F$12,'User Input'!$C$12,0)+IF(C45>='User Input'!$F$13,'User Input'!$C$13,0)","v":0},2385.8678955453147,202.8135676222193,0.22534840846913254,null,0.1,0.13500000000000001]
[null,null,"2018-09-02",null,null,null,834.40881085954709,92.712090095505232,28.209876543209877,80.398190666028469,{"$f":"'User Input'!$C$4","v":0.45},{"$f":"'User Input'!$C$5","v":0.45},{"$f":"'User Input'!$C$6","v":0.6},{"$f":"IF('User Input'!$C$7=\"Normal\",1, IF('User Input'!$C$7=\"Low\",0.8,1.2))","v":1},458.92484597275092,50.991649552527882,11.283950617283951,80.398190666028469,{"$f":"IF(C46>='User Input'!$F$11,'User Input'!$C$11,0)+IF(C46>='User Input'!$F$12,'User Input'!$C$12,0)+IF(C46>='User Input'!$F$13,'User Input'!$C$13,0)","v":0},2866.6666666666665,218.66904383122582,0.24296560425691757,null,0.1,0.13500000000000001]
[null,null,"2018-09-09",null,null,null,834.40881085954709,92.712090095505232,28.209876543209877,80.398190666028469,{"$f":"'User Input'!$C$4","v":0.45},{"$f":"'User Input'!$C$5","v":0.45},{"$f":"'User Input'!$C$6","v":0.6},{"$f":"IF('User Input'!$C$7=\"Normal\",1, IF('User Input'!$C$7=\"Low\",0.8,1.2))","v":1},458.92484597275092,50.991649552527882,11.283950617283951,80.398190666028469,{"$f":"IF(C47>='User Input'!$F$11,'User Input'!$C$11,0)+IF(C47>='User Input'!$F$12,'User Input'!$C$12,0)+IF(C47>='User Input'!$F$13,'User Input'!$C$13,0)","v":0},2866.6666666666665,234.52452004023235,0.26058280004470263,null,0.1,0.13500000000000001]
[null,null,"2018-09-16",null,null,null,834.40881085954709,92.712090095505232,28.209876543209877,80.398190666028469,{"$f":"'User Input'!$C$4","v":0.45},{"$f":"'User Input'!$C$5","v":0.45},{"$f":"'User Input'!$C$6","v":0.6},{"$f":"IF('User Input'!$C$7=\"Normal\",1, IF('User Input'!$C$7=\"Low\",0.8,1.2))","v":1},458.92484597275092,50.991649552527882,11.283950617283951,80.398190666028469,{"$f":"IF(C48>='User Input'!$F$11,'User Input'!$C$11,0)+IF(C48>='User Input'!$F$12,'User Input'!$C$12,0)+IF(C48>='User Input'!$F$13,'User Input'!$C$13,0)","v":0},2866.6666666666665,250.37999624923887,0.27819999583248761,null,0.1,0.13500000000000001]
[null,null,"2018-09-23",null,null,null,834.40881085954709,92.712090095505232,28.209876543209877,80.398190666028469,{"$f":"'User Input'!$C$4","v":0.45},{"$f":"'User Input'!$C$5","v":0.45},{"$f":"'User Input'!$C$6","v":0.6},{"$f":"IF('User Input'!$C$7=\"Normal\",1, IF('User Input'!$C$7=\"Low\",0.8,1.2))","v":1},458.92484597275092,50.991649552527882,11.283950617283951,80.398190666028469,{"$f":"IF(C49>='User Input'!$F$11,'User Input'!$C$11,0)+IF(C49>='User Input'!$F$12,'User Input'!$C$12,0)+IF(C49>='User Input'!$F$13,'User Input'!$C$13,0)","v":0},2866.6666666666665,266.2354724582454,0.29581719162027265,null,0.1,0.13500000000000001]
[null,null,"2018-09-30",null,null,null,834.40881085954709,92.712090095505232,28.209876543209877,80.398190666028469,{"$f":"'User Input'!$C$4","v":0.45},{"$f":"'User Input'!$C$5","v":0.45},{"$f":"'User Input'!$C$6","v":0.6},{"$f":"IF('User Input'!$C$7=\"Normal\",1, IF('User Input'!$C$7=\"Low\",0.8,1.2))","v":1},458.92484597275092,50.991649552527882,11.283950617283951,80.398190666028469,{"$f":"IF(C50>='User Input'!$F$11,'User Input'!$C$11,0)+IF(C50>='User Input'!$F$12,'User Input'!$C$12,0)+IF(C50>='User Input'!$F$13,'User Input'!$C$13,0)","v":0},1838.7096774193546,274.89524974252072,0.30543916638057855,null,0.1,0.13500000000000001]
[null,null,"2018-10-07",null,null,null,849.18206939157142,94.353563265730145,136.49940262843486,145.66295752588061,{"$f":"'User Input'!$C$4","v":0.45},{"$f":"'User Input'!$C$5","v":0.45},{"$f":"'User Input'!$C$6","v":0.6},{"$f":"IF('User Input'!$C$7=\"Normal\",1, IF('User Input'!$C$7=\"Low\",0.8,1.2))","v":1},467.05013816536433,51.894459796151587,54.599761051373946,145.66295752588061,{"$f":"IF(C51>='User Input'!$F$11,'User Input'!$C$11,0)+IF(C51>='User Input'!$F$12,'User Input'!$C$12,0)+IF(C51>='User Input'!$F$13,'User Input'!$C$13,0)","v":0},1838.7096774193546,282.73176626868479,0.31414640696520535,null,0.1,0.13500000000000001]
[null,null,"2018-10-14",null,null,null,849.18206939157142,94.353563265730145,136.49940262843486,145.66295752588061,{"$f":"'User Input'!$C$4","v":0.45},{"$f":"'User Input'!$C$5","v":0.45},{"$f":"'User Input'!$C$6","v":0.6},{"$f":"IF('User Input'!$C$7=\"Normal\",1, IF('User Input'!$C$7=\"Low\",0.8,1.2))","v":1},467.05013816536433,51.894459796151587,54.599761051373946,145.66295752588061,{"$f":"IF(C52>='User Input'!$F$11,'User Input'!$C$11,0)+IF(C52>='User Input'!$F$12,'User Input'!$C$12,0)+IF(C52>='User Input'!$F$13,'User Input'!$C$13,0)","v":0},1838.7096774193546,290.56828279484887,0.32285364754983209,null,0.1,0.13500000000000001]
[null,null,"2018-10-21",null,null,null,849.18206939157142,94.353563265730145,136.49940262843486,145.66295752588061,{"$f":"'User Input'!$C$4","v":0.45},{"$f":"'User Input'!$C$5","v":0.45},{"$f":"'User Input'!$C$6","v":0.6},{"$f":"IF('User Input'!$C$7=\"Normal\",1, IF('User Input'!$C$7=\"Low\",0.8,1.2))","v":1},467.05013816536433,51.894459796151587,54.599761051373946,145.66295752588061,{"$f":"IF(C53>='User Input'!$F$11,'User Input'!$C$11,0)+IF(C53>='User Input'!$F$12,'User Input'!$C$12,0)+IF(C53>='User Input'!$F$13,'User Input'!$C$13,0)","v":0},1838.7096774193546,298.40479932101294,0.33156088813445883,null,0.1,0.13500000000000001]
[null,null,"2018-10-28",null,null,null,849.18206939157142,94.353563265730145,136.49940262843486,145.66295752588061,{"$f":"'User Input'!$C$4","v":0.45},{"$f":"'User Input'!$C$5","v":0.45},{"$f":"'User Input'!$C$6","v":0.6},{"$f":"IF('User Input'!$C$7=\"Normal\",1, IF('User Input'!$C$7=\"Low\",0.8,1.2))","v":1},467.05013816536433,51.894459796151587,54.599761051373946,145.66295752588061,{"$f":"IF(C54>='User Input'!$F$11,'User Input'!$C$11,0)+IF(C54>='User Input'!$F$12,'User Input'!$C$12,0)+IF(C54>='User Input'!$F$13,'User Input'!$C$13,0)","v":0},1838.7096774193546,306.24131584717702,0.34026812871908557,null,0.1,0.13500000000000001]

{"sheet":"Lists","index":2,"n_rows":24,"n_cols":5,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[0.2,0.25,"Low","2017-12-31","Yes"]
[0.25,0.3,"Normal",{"$f":"EOMONTH(D1,1)","v":"2018-01-31"},"No"]
[0.3,0.35,"High",{"$f":"EOMONTH(D2,1)","v":"2018-02-28"}]
[0.35,0.4,null,"2018-03-31"]
[0.4,0.45,null,"2018-04-30"]
[0.45,0.5,null,"2018-05-31"]
[0.5,0.55000000000000004,null,"2018-06-30"]
[null,0.6,null,"2018-07-31"]
[null,0.65,null,"2018-08-31"]
[null,0.7,null,"2018-09-30"]
[null,null,null,"2018-10-31"]
[null,null,null,"2018-11-30"]
[null,null,null,"2018-12-31"]
[null,null,null,"2019-01-31"]
[null,null,null,"2019-02-28"]
[null,null,null,"2019-03-31"]
[null,null,null,"2019-04-30"]
[null,null,null,"2019-05-31"]
[null,null,null,"2019-06-30"]
[null,null,null,"2019-07-31"]
[null,null,null,"2019-08-31"]
[null,null,null,"2019-09-30"]
[null,null,null,"2019-10-31"]
[null,null,null,"2019-11-30"]