{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["stock","demand","chart"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":1,"pivot_tables":1},"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":"stock","index":0,"n_rows":6,"n_cols":10,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Material ","StockQty","DemandQty","Delta",null,"show","2years",null,"today",{"$f":"TODAY()","v":"2017-05-11"}]
[111,3000,{"$f":"SUMIF(demand!$A$3:$A$41,stock!A2,demand!D3:$D$41)","v":4472.083333333333},{"$f":"B2-C2","v":-1472.083333333333}]
[222,1000,{"$f":"SUMIF(demand!$A$3:$A$41,stock!A3,demand!D4:$D$41)","v":602},{"$f":"B3-C3","v":398}]
[333,1500,{"$f":"SUMIF(demand!$A$3:$A$41,stock!A4,demand!D5:$D$41)","v":329},1171]
[444,10,{"$f":"SUMIF(demand!$A$3:$A$41,stock!A5,demand!D6:$D$41)","v":0},10]
[555,200,{"$f":"SUMIF(demand!$A$3:$A$41,stock!A6,demand!D7:$D$41)","v":0},200]

{"sheet":"demand","index":1,"n_rows":41,"n_cols":17,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["Material","Plant","Name","Demand","StartDate","Duration","EndDate","ConsumptionPerDay","DemandToDate","DemandToDateCumulative","DaysTillOutOfStock","QtyRequired","StockEndDate","Duration2","StockExceededLine","RunOutOfStockOn","RunOutOfStockInDays"]
[111,"*","stock",3000,{"$f":"TODAY()","v":"2017-05-11"},79,{"$f":"E2+F2","v":"2017-07-29"},null,null,{"$f":"SUBTOTAL(4,J3:J47)","v":4045.75},0,{"$f":"J2-D2","v":1045.75},{"$f":"E2+F2","v":"2017-07-29"},{"$f":"SUBTOTAL(4,G3:G47)-M2","v":221}]
[111,"Plant1","unknown",330,"2017-01-01",100,{"$f":"E3+F3","v":"2017-04-11"},{"$f":"D3/F3","v":3.3},{"$f":"IF(E3>TODAY(),D3,IF((((E3+F3-TODAY())/F3)*D3)<0,0,((E3+F3-TODAY())/F3)*D3))","v":0},{"$f":"I3","v":0},{"$f":"ROUNDUP((J3-$D$2)/H3,0)","v":-910}," ",null," ",{"$f":"IF(J3>$D$2,E3,0)","v":"00:00:00"},{"$f":"O3-K3","v":"1902-06-28"},{"$f":"P3-$E$2","v":-41956}]
[111,"Plant1","A-03",328.75,{"$f":"TODAY()+1","v":"2017-05-12"},10,"2017-05-22",32.875,328.75,{"$f":"IF(A4=A3,I4+J3,I4)","v":328.75},-82," ",null," ","00:00:00","1900-03-22",-42784]
[111,"Plant2","A-01",285.41666666666669,"2017-05-12",10,"2017-05-22",28.541666666666668,285.41666666666669,{"$f":"IF(A5=A4,I5+J4,I5)","v":614.16666666666674},-84," ",null," ","00:00:00","1900-03-24",-42782]
[111,"Plant2","A-06",462.08333333333331,"2017-05-12",10,"2017-05-22",46.208333333333329,462.08333333333331,1076.25,-42," ",null," ","00:00:00","1900-02-11",-42824]
[111,"Plant2","ABC-12",316.66666666666669,"2017-05-12",10,"2017-05-22",31.666666666666668,316.66666666666669,1392.9166666666667,-51," ",null," ","00:00:00","1900-02-20",-42815]
[111,"Plant2","ABC-15",378.33333333333331,"2017-05-12",10,"2017-05-22",37.833333333333329,378.33333333333331,1771.25,-33," ",null," ","00:00:00","1900-02-02",-42833]
[111,"Plant2","ZXY-01",266.66666666666669,"2017-05-12",10,"2017-05-22",26.666666666666668,266.66666666666669,2037.9166666666667,-37," ",null," ","00:00:00","1900-02-06",-42829]
[111,"Plant2","B-01",356.25,"2017-05-18",54,"2017-07-11",6.5972222222222223,356.25,2394.166666666667,-92," ",null," ","00:00:00","1900-04-01",-42774]
[111,"Plant2","A-02",283.33333333333331,"2017-04-07",100,"2017-07-16",2.833333333333333,187,2581.166666666667,-148," ",null," ","00:00:00","1900-05-27",-42718]
[111,"Plant1","CCC-2",56.25,"2017-07-11",21,"2017-08-01",2.6785714285714284,56.25,2637.416666666667,-136," ",null," ","00:00:00","1900-05-15",-42730]
[111,"Plant2","ABC-14",375,"2017-08-01",64,"2017-10-04",5.859375,375,3012.416666666667,3," ",null," ","2017-08-01","2017-07-29",{"$f":"P13-$E$2","v":79}]
[111,"Plant2","ABC-16",404.16666666666669,"2017-10-17",69,"2017-12-25",5.8574879227053147,404.16666666666669,3416.5833333333335,72," ",null," ","2017-10-17","2017-08-06",{"$f":"P14-$E$2","v":87}]
[111,"Plant2","unknown",300,"2017-08-01",150,"2017-12-29",2,300,3716.5833333333335,359," ",null," ","2017-08-01","2016-08-07",-277]
[111,"Plant1","A-04",329.16666666666669,"2017-12-25",72,"2018-03-07",4.5717592592592595,329.16666666666669,4045.75,229," "," "," ","2017-12-25","2017-05-10",-1]
[222,"Plant2","A-02",40,"2017-04-07",41,{"$f":"E17+F17","v":"2017-05-18"},0.97560975609756095,6.8292682926829276,6.8292682926829276,-3068," "," "," ","00:00:00","1908-05-25",-39798]
[222,"Plant1","A-06",80,{"$f":"TODAY()+1","v":"2017-05-12"},10,"2017-05-22",8,80,86.829268292682926,-365," "," "," ","00:00:00","1900-12-30",-42501]
[222,"Plant2","A-01",40,"2017-05-12",10,"2017-05-22",4,40,126.82926829268293,-719," "," "," ","00:00:00","1901-12-19",-42147]
[222,"Plant2","A-03",40,"2017-05-12",10,"2017-05-22",4,40,166.82926829268291,-709," "," "," ","00:00:00","1901-12-09",-42157]
[222,"Plant2","ABC-12",40,"2017-05-12",10,"2017-05-22",4,40,206.82926829268291,-699," "," "," ","00:00:00","1901-11-29",-42167]
[222,"Plant2","ABC-15",80,"2017-05-12",10,"2017-05-22",8,80,286.82926829268291,-340," "," "," ","00:00:00","1900-12-05",-42526]
[222,"Plant2","ZXY-01",40,"2017-05-12",10,"2017-05-22",4,40,326.82926829268291,-669," "," "," ","00:00:00","1901-10-30",-42197]
[222,"Plant2","B-01",80,"2017-05-18",54,"2017-07-11",1.4814814814814814,80,406.82926829268291,-1751," "," "," ","00:00:00","1904-10-16",-41115]
[222,"Plant1","CCC-2",1,"2017-07-11",21,"2017-08-01",4.7619047619047616E-2,1,407.82926829268291,-54436," "," "," ","00:00:00","2049-01-13",11570]
[222,"Plant1","ABC-14",80,"2017-08-01",64,"2017-10-04",1.25,80,487.82926829268291,-2010," "," "," ",{"$f":"IF(J26>$D$2,E26,0)","v":"00:00:00"},"1905-07-02",-40856]
[222,"Plant1","ABC-16",80,"2017-10-17",69,"2017-12-25",1.1594202898550725,80,567.82926829268285,-2098," "," "," ","00:00:00","1905-09-28",-40768]
[222,"Plant2","A-04",40,"2017-12-25",72,"2018-03-07",0.55555555555555558,40,607.82926829268285,-4306," "," "," ","00:00:00","1911-10-15",-38560]
[333,"Plant1","ABC-12",1,{"$f":"TODAY()+1","v":"2017-05-12"},10,"2017-05-22",0.1,{"$f":"IF(E29>TODAY(),D29,IF((((E29+F29-TODAY())/F29)*D29)<0,0,((E29+F29-TODAY())/F29)*D29))","v":1},1,-29990," ",null," ","00:00:00","1982-02-08",-12876]
[333,"Plant2","A-01",2,{"$f":"TODAY()+1","v":"2017-05-12"},10,"2017-05-22",0.2,2,3,-14985," ",null," ","00:00:00","1941-01-09",-27881]
[333,"Plant2","A-03",2,{"$f":"TODAY()+1","v":"2017-05-12"},10,"2017-05-22",0.2,2,5,-14975," ",null," ","00:00:00","1940-12-30",-27891]
[333,"Plant2","ABC-15",2,{"$f":"TODAY()+1","v":"2017-05-12"},10,"2017-05-22",0.2,2,7,-14965," ",null," ","00:00:00","1940-12-20",-27901]
[333,"Plant2","ZXY-01",8,{"$f":"TODAY()+1","v":"2017-05-12"},10,"2017-05-22",0.8,8,15,-3732," ",null," ","00:00:00","1910-03-20",-39134]
[333,"Plant2","CCC-2",2,"2017-07-11",21,"2017-08-01",9.5238095238095233E-2,2,17,-31322," ",null," ","00:00:00","1985-10-02",-11544]
[333,"Plant1","ABC-14",5,"2017-08-01",64,"2017-10-04",7.8125E-2,5,22,-38119," ",null," ","00:00:00","2004-05-12",-4747]
[333,"Plant1","A-02",100,"2017-04-07",200,"2017-10-24",0.5,83,105,-5790," "," "," ","00:00:00","1915-11-07",-37076]
[333,"Plant1","A-06",100,"2017-04-07",200,"2017-10-24",0.5,83,188,-5624," ",null," ","00:00:00","1915-05-25",-37242]
[333,"Plant2","ABC-16",6,"2017-10-17",69,"2017-12-25",8.6956521739130432E-2,6,194,-32269," ",null," ","00:00:00","1988-05-06",-10597]
[333,"Plant2","A-04",2,"2017-12-25",72,"2018-03-07",2.7777777777777776E-2,2,196,-100944," ",null," ","00:00:00","2176-05-15",58078]
[333,"Plant1","A-06",100,"2017-12-01",100,"2018-03-11",1,100,296,-2704," ",null," ","00:00:00","1907-05-27",-40162]
[333,"Plant2","B-01",2,"2018-05-18",54,"2018-07-11",3.7037037037037035E-2,2,298,-72954," ",null," ","00:00:00","2099-09-26",30088]

{"sheet":"chart","index":2,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Material",111]
[]
["Row Labels","Name","StartDate","Duration","Duration2","QtyRequired","Sum of Demand"]
["Plant1","A-03","2017-05-12",10," "," ",328.75]
[null,"A-04","2017-12-25",72," "," ",329.16666666666669]
[null,"CCC-2","2017-07-11",21," "," ",56.25]
[null,"unknown","2017-01-01",100," "," ",330]
["Plant2","A-01","2017-05-12",10," "," ",285.41666666666669]
[null,"A-02","2017-04-07",100," "," ",283.33333333333331]
[null,"A-06","2017-05-12",10," "," ",462.08333333333331]
[null,"ABC-12","2017-05-12",10," "," ",316.66666666666669]
[null,"ABC-14","2017-08-01",64," "," ",375]
[null,"ABC-15","2017-05-12",10," "," ",378.33333333333331]
[null,"ABC-16","2017-10-17",69," "," ",404.16666666666669]
[null,"B-01","2017-05-18",54," "," ",356.25]
[null,"unknown","2017-08-01",150," "," ",300]
[null,"ZXY-01","2017-05-12",10," "," ",266.66666666666669]
["*","stock","2017-05-11",79,221,1045.75,3000]