{"text_format":"2","workbook":"xls","n_sheets":5,"sheets":["Transactional data","Item information","Orders to receive","Orders to ship","Bill of materials"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":2,"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","formulas":"cached_only"}

{"sheet":"Transactional data","index":0,"n_rows":699,"n_cols":5,"rows_kept":699,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Date","Item code","Quantity Sold","On hand  remaining","Price per unit"]
["2015-01-01","B05465-R",73,110,12.98]
["2015-02-01","B05465-R",73,110,12.98]
["2015-03-01","B05465-R",82,123,13.97]
["2015-04-01","B05465-R",143,215,13.97]
["2015-05-01","B05465-R",192,288,12.98]
["2015-06-01","B05465-R",213,320,13.97]
["2015-07-01","B05465-R",217,326,12.98]
["2015-08-01","B05465-R",173,260,13.97]
["2015-09-01","B05465-R",127,191,12.98]
["2015-10-01","B05465-R",106,159,12.98]
["2015-11-01","B05465-R",106,159,13.97]
["2015-12-01","B05465-R",192,288,13.97]
["2016-01-01","B05465-R",109,164,13.97]
["2016-02-01","B05465-R",81,122,13.97]
["2016-03-01","B05465-R",89,134,13.97]
["2016-04-01","B05465-R",160,240,15.95]
["2016-05-01","B05465-R",198,297,15.95]
["2016-06-01","B05465-R",206,309,15.95]
["2016-07-01","B05465-R",224,336,14.96]
["2016-08-01","B05465-R",160,240,15.95]
["2016-09-01","B05465-R",127,191,14.96]
["2016-10-01","B05465-R",99,149,15.95]
["2016-11-01","B05465-R",112,168,14.96]
["2016-12-01","B05465-R",177,266,15.95]
["2015-01-01",50046,55,83,8.91]
["2015-02-01",50046,58,87,7.92]
["2015-03-01",50046,62,93,7.92]
["2015-04-01",50046,63,95,8.91]
["2015-05-01",50046,71,107,7.92]
["2015-06-01",50046,69,104,7.92]
["2015-07-01",50046,74,111,7.92]
["2015-08-01",50046,73,110,7.92]
["2015-09-01",50046,66,99,8.91]
["2015-10-01",50046,70,105,8.91]
["2015-11-01",50046,71,107,8.91]
["2015-12-01",50046,93,140,8.91]
["2016-01-01",50046,61,92,8.91]
["2016-02-01",50046,58,87,8.91]
["2016-03-01",50046,63,95,8.91]
["2016-04-01",50046,65,98,8.91]
["2016-05-01",50046,72,108,8.91]
["2016-06-01",50046,69,104,8.91]
["2016-07-01",50046,74,111,8.91]
["2016-08-01",50046,70,105,8.91]
["2016-09-01",50046,68,102,8.91]
["2016-10-01",50046,71,107,8.91]
["2016-11-01",50046,69,104,8.91]
["2016-12-01",50046,94,141,8.91]
["2015-01-01","05-T48",400,600,5.94]
["2015-02-01","05-T48",400,600,5.94]
["2015-03-01","05-T48",414,621,5.94]
["2015-04-01","05-T48",400,600,5.94]
["2015-05-01","05-T48",417,626,5.94]
["2015-06-01","05-T48",400,600,5.94]
["2015-07-01","05-T48",406,609,5.94]
["2015-08-01","05-T48",403,605,5.94]
["2015-09-01","05-T48",398,597,5.94]
["2015-10-01","05-T48",416,624,5.94]
["2015-11-01","05-T48",396,594,5.94]
["2015-12-01","05-T48",462,693,5.94]
["2016-01-01","05-T48",413,620,5.94]
["2016-02-01","05-T48",397,596,5.94]
["2016-03-01","05-T48",431,647,5.94]
["2016-04-01","05-T48",422,633,6.93]
["2016-05-01","05-T48",423,635,6.93]
["2016-06-01","05-T48",421,632,6.93]
["2016-07-01","05-T48",416,624,6.93]
["2016-08-01","05-T48",412,618,6.93]
["2016-09-01","05-T48",414,621,6.93]
["2016-10-01","05-T48",429,644,6.93]
["2016-11-01","05-T48",415,623,6.93]
["2016-12-01","05-T48",481,722,6.93]
["2015-01-01","46689-PC",36,54,471.9]
["2015-02-01","46689-PC",36,54,509.96]
["2015-03-01","46689-PC",37,56,448.91]
["2015-04-01","46689-PC",34,51,485.98]
["2015-05-01","46689-PC",34,51,490.93]
["2015-06-01","46689-PC",36,54,460.9]
["2015-07-01","46689-PC",37,56,451.99]
["2015-08-01","46689-PC",37,56,495.99]
["2015-09-01","46689-PC",34,51,485.98]
["2015-10-01","46689-PC",35,53,451.99]
["2015-11-01","46689-PC",42,63,466.95]
["2015-12-01","46689-PC",58,87,473]
["2016-01-01","46689-PC",35,53,426.91]
["2016-02-01","46689-PC",34,51,425.92]
["2016-03-01","46689-PC",36,54,444.95]
["2016-04-01","46689-PC",34,51,420.97]
["2016-05-01","46689-PC",32,48,404.91]
["2016-06-01","46689-PC",34,51,435.93]
["2016-07-01","46689-PC",33,50,424.93]
["2016-08-01","46689-PC",34,51,436.92]
["2016-09-01","46689-PC",34,51,421.96]
["2016-10-01","46689-PC",34,51,440.99]
["2016-11-01","46689-PC",43,65,408.98]
["2016-12-01","46689-PC",60,90,394.9]
["2015-01-01","C1020",20,20,4.95]
["2015-02-01","C1020",20,20,4.95]
["2015-03-01","C1020",19,23,4.95]
["2015-04-01","C1020",18,26,4.95]
["2015-05-01","C1020",18,27,4.95]
["2015-06-01","C1020",18,27,4.95]
["2015-07-01","C1020",19,29,4.95]
["2015-08-01","C1020",18,27,4.95]
["2015-09-01","C1020",17,26,4.95]
["2015-10-01","C1020",17,26,4.95]
["2015-11-01","C1020",16,20,4.95]
["2015-12-01","C1020",17,17,4.95]
["2016-01-01","C1020",15,17,4.95]
["2016-02-01","C1020",14,17,4.95]
["2016-03-01","C1020",13,20,4.95]
["2016-04-01","C1020",14,21,4.95]
["2016-05-01","C1020",14,21,4.95]
["2016-06-01","C1020",14,24,5.94]
["2016-07-01","C1020",14,24,5.94]
["2016-08-01","C1020",14,23,5.94]
["2016-09-01","C1020",14,21,5.94]
["2016-10-01","C1020",13,20,5.94]
["2016-11-01","C1020",11,17,5.94]
["2016-12-01","C1020",10,15,5.94]
["2015-01-01","002661-1",82,241,1.98]
["2015-02-01","002661-1",93,148,1.98]
["2015-03-01","002661-1",106,243,1.98]
["2015-04-01","002661-1",109,648,1.98]
["2015-05-01","002661-1",173,475,1.98]
["2015-06-01","002661-1",179,296,1.98]
["2015-07-01","002661-1",164,372,1.98]
["2015-08-01","002661-1",202,469,2.97]
["2015-09-01","002661-1",131,338,2.97]
["2015-10-01","002661-1",127,211,2.97]
["2015-11-01","002661-1",125,86,2.97]
["2015-12-01","002661-1",86,0,2.97]
["2016-01-01","002661-1",0,0,2.97]
["2016-02-01","002661-1",0,0,2.97]
["2016-03-01","002661-1",82,298,2.97]
["2016-04-01","002661-1",101,197,2.97]
["2016-05-01","002661-1",167,270,2.97]
["2016-06-01","002661-1",155,591,2.97]
["2016-07-01","002661-1",183,408,2.97]
["2016-08-01","002661-1",204,204,2.97]
["2016-09-01","002661-1",140,424,2.97]
["2016-10-01","002661-1",159,265,2.97]
["2016-11-01","002661-1",121,144,2.97]
["2016-12-01","002661-1",98,46,2.97]
["2015-01-01","1866-MB",32,47,200.97]
["2015-02-01","1866-MB",32,47,211.97]
["2015-03-01","1866-MB",69,103,220]
["2015-04-01","1866-MB",50,75,201.96]
["2015-05-01","1866-MB",38,56,216.92]
["2015-06-01","1866-MB",13,19,224.95]
["2015-07-01","1866-MB",112,168,225.94]
["2015-08-01","1866-MB",19,28,202.95]
["2015-09-01","1866-MB",44,66,212.96]
["2015-10-01","1866-MB",32,47,206.91]
["2015-11-01","1866-MB",28,10,210.98]
["2015-12-01","1866-MB",38,56,227.92]
["2016-01-01","1866-MB",25,38,221.98]
["2016-02-01","1866-MB",32,47,213.95]
["2016-03-01","1866-MB",69,104,213.95]
["2016-04-01","1866-MB",50,75,218.9]
["2016-05-01","1866-MB",38,56,226.93]
["2016-06-01","1866-MB",13,19,211.97]
["2016-07-01","1866-MB",69,103,212.96]
["2016-08-01","1866-MB",44,66,204.93]
["2016-09-01","1866-MB",56,84,202.95]
["2016-10-01","1866-MB",13,19,221.98]
["2016-10-10","1866-MB",19,0,221.98]
["2016-10-17","1866-MB",0,38,221.98]
["2016-11-01","1866-MB",25,45,209.99]
["2016-12-01","1866-MB",25,30,211.97]
["2015-01-01","562156-01",0,2,380.93]
["2015-02-01","562156-01",1,0,412.94]
["2015-03-01","562156-01",0,0,382.91]
["2015-04-01","562156-01",0,0,372.9]
["2015-05-01","562156-01",0,0,400.95]
["2015-06-01","562156-01",0,0,368.94]
["2015-07-01","562156-01",0,0,359.92]
["2015-08-01","562156-01",1,1,394.9]
["2015-09-01","562156-01",0,0,376.97]
["2015-10-01","562156-01",0,0,374]
["2015-11-01","562156-01",0,0,374]
["2015-12-01","562156-01",0,0,366.96]
["2016-01-01","562156-01",0,0,447.92]
["2016-02-01","562156-01",0,1,403.92]
["2016-03-01","562156-01",0,1,425.92]
["2016-04-01","562156-01",1,0,413.93]
["2016-05-01","562156-01",0,1,404.91]
["2016-06-01","562156-01",0,1,423.94]
["2016-07-01","562156-01",0,1,437.91]
["2016-08-01","562156-01",0,1,454.96]
["2016-09-01","562156-01",0,1,458.92]
["2016-10-01","562156-01",0,1,416.9]
["2016-11-01","562156-01",1,0,435.93]
["2016-12-01","562156-01",0,1,441.98]
["2015-01-01","L2010",10,15,1.98]
["2015-02-01","L2010",10,15,1.98]
["2015-03-01","L2010",11,17,1.98]
["2015-04-01","L2010",16,17,1.98]
["2015-05-01","L2010",22,15,1.98]
["2015-06-01","L2010",25,15,1.98]
["2015-07-01","L2010",17,17,1.98]
["2015-08-01","L2010",13,15,1.98]
["2015-09-01","L2010",15,17,1.98]
["2015-10-01","L2010",14,18,1.98]
["2015-11-01","L2010",12,29,1.98]
["2015-12-01","L2010",11,50,1.98]
["2016-01-01","L2010",9,14,1.98]
["2016-02-01","L2010",10,15,1.98]
["2016-03-01","L2010",12,18,1.98]
["2016-04-01","L2010",14,17,1.98]
["2016-05-01","L2010",23,18,1.98]
["2016-06-01","L2010",27,18,1.98]
["2016-07-01","L2010",17,18,1.98]
["2016-08-01","L2010",18,18,1.98]
["2016-09-01","L2010",16,18,1.98]
["2016-10-01","L2010",14,21,1.98]
["2016-11-01","L2010",12,36,2.97]
["2016-12-01","L2010",10,54,2.97]
["2015-01-01",120565,27,41,1.98]
["2015-02-01",120565,48,72,1.98]
["2015-03-01",120565,31,47,1.98]
["2015-04-01",120565,0,0,1.98]
["2015-05-01",120565,14,21,1.98]
["2015-06-01",120565,24,36,1.98]
["2015-07-01",120565,18,27,1.98]
["2015-08-01",120565,26,39,1.98]
["2015-09-01",120565,29,44,1.98]
["2015-10-01",120565,22,33,1.98]
["2015-11-01",120565,52,78,1.98]
["2015-12-01",120565,70,105,1.98]
["2016-01-01",120565,48,72,1.98]
["2016-02-01",120565,54,81,1.98]
["2016-03-01",120565,18,27,1.98]
["2016-04-01",120565,33,50,1.98]
["2016-05-01",120565,32,48,1.98]
["2016-06-01",120565,20,30,1.98]
["2016-07-01",120565,43,65,1.98]
["2016-08-01",120565,25,38,1.98]
["2016-09-01",120565,36,54,1.98]
["2016-10-01",120565,42,63,1.98]
["2016-11-01",120565,69,104,1.98]
["2016-12-01",120565,86,129,1.98]
["2015-01-01","H2510",163,1057,0.99]
["2015-02-01","H2510",178,879,0.99]
["2015-03-01","H2510",168,711,0.99]
["2015-04-01","H2510",196,515,0.99]
["2015-05-01","H2510",315,1200,0.99]
["2015-06-01","H2510",194,1006,0.99]
["2015-07-01","H2510",145,861,0.99]
["2015-08-01","H2510",145,716,0.99]
["2015-09-01","H2510",164,552,0.99]
["2015-10-01","H2510",168,384,0.99]
["2015-11-01","H2510",171,213,0.99]
["2015-12-01","H2510",165,1248,0.99]
["2016-01-01","H2510",186,1062,0.99]
["2016-02-01","H2510",208,854,0.99]
["2016-03-01","H2510",185,669,0.99]
["2016-04-01","H2510",201,468,0.99]
["2016-05-01","H2510",337,1331,0.99]
["2016-06-01","H2510",227,1104,0.99]
["2016-07-01","H2510",139,965,0.99]
["2016-08-01","H2510",151,814,0.99]
["2016-09-01","H2510",180,634,0.99]
["2016-10-01","H2510",171,463,0.99]
["2016-11-01","H2510",204,259,0.99]
["2016-12-01","H2510",190,69,0.99]
["2015-01-01","565405 Beatles L",40,60,8.91]
["2015-02-01","565405 Beatles L",40,60,8.91]
["2015-03-01","565405 Beatles L",65,98,8.91]
["2015-04-01","565405 Beatles L",20,30,8.91]
["2015-05-01","565405 Beatles L",93,139,11]
["2015-06-01","565405 Beatles L",53,79,9.9]
["2015-07-01","565405 Beatles L",93,139,11]
["2015-08-01","565405 Beatles L",60,90,11]
["2015-09-01","565405 Beatles L",68,102,11]
["2015-10-01","565405 Beatles L",200,300,11]
["2015-11-01","565405 Beatles L",95,143,11]
["2015-12-01","565405 Beatles L",40,60,9.9]
["2016-01-01","565405 Beatles L",120,180,11]
["2016-02-01","565405 Beatles L",45,68,9.9]
["2016-03-01","565405 Beatles L",125,188,9.9]
["2016-04-01","565405 Beatles L",148,222,11]
["2016-05-01","565405 Beatles L",88,132,11]
["2016-06-01","565405 Beatles L",108,162,11]
["2016-07-01","565405 Beatles L",173,259,11]
["2016-08-01","565405 Beatles L",238,357,11]
["2016-09-01","565405 Beatles L",268,402,11]
["2016-10-01","565405 Beatles L",378,567,11]
["2016-11-01","565405 Beatles L",260,1402,11]
["2015-01-01","565405 Beatles M",23,34,8.91]
["2015-02-01","565405 Beatles M",23,34,8.91]
["2015-03-01","565405 Beatles M",33,49,8.91]
["2015-04-01","565405 Beatles M",48,72,8.91]
["2015-05-01","565405 Beatles M",118,177,11]
["2015-06-01","565405 Beatles M",88,132,9.9]
["2015-07-01","565405 Beatles M",78,117,11]
["2015-08-01","565405 Beatles M",108,162,9.9]
["2015-09-01","565405 Beatles M",18,27,9.9]
["2015-10-01","565405 Beatles M",193,289,9.9]
["2015-11-01","565405 Beatles M",140,210,9.9]
["2015-12-01","565405 Beatles M",53,79,9.9]
["2016-01-01","565405 Beatles M",38,57,9.9]
["2016-02-01","565405 Beatles M",70,105,11]
["2016-03-01","565405 Beatles M",70,105,9.9]
["2016-04-01","565405 Beatles M",45,68,11]
["2016-05-01","565405 Beatles M",108,162,11]
["2016-06-01","565405 Beatles M",63,94,11]
["2016-07-01","565405 Beatles M",108,162,11]
["2016-08-01","565405 Beatles M",245,368,11]
["2016-09-01","565405 Beatles M",195,293,11]
["2016-10-01","565405 Beatles M",388,582,11]
["2016-11-01","565405 Beatles M",53,980,11]
["2015-01-01","565405 Beatles S",38,57,8.91]
["2015-02-01","565405 Beatles S",38,57,8.91]
["2015-03-01","565405 Beatles S",23,34,8.91]
["2015-04-01","565405 Beatles S",55,83,8.91]
["2015-05-01","565405 Beatles S",68,102,11]
["2015-06-01","565405 Beatles S",60,90,11]
["2015-07-01","565405 Beatles S",53,79,11]
["2015-08-01","565405 Beatles S",83,124,11]
["2015-09-01","565405 Beatles S",3,4,11]
["2015-10-01","565405 Beatles S",145,218,9.9]
["2015-11-01","565405 Beatles S",135,203,11]
["2015-12-01","565405 Beatles S",63,94,9.9]
["2016-01-01","565405 Beatles S",35,53,9.9]
["2016-02-01","565405 Beatles S",23,34,9.9]
["2016-03-01","565405 Beatles S",75,113,11]
["2016-04-01","565405 Beatles S",103,154,11]
["2016-05-01","565405 Beatles S",28,42,11]
["2016-06-01","565405 Beatles S",33,49,11]
["2016-07-01","565405 Beatles S",48,72,11]
["2016-08-01","565405 Beatles S",153,229,11]
["2016-09-01","565405 Beatles S",108,162,11]
["2016-10-01","565405 Beatles S",290,435,11]
["2016-11-01","565405 Beatles S",118,1256,11]
["2015-01-01","565405 Beatles XL",35,53,8.91]
["2015-02-01","565405 Beatles XL",35,53,8.91]
["2015-03-01","565405 Beatles XL",75,113,8.91]
["2015-04-01","565405 Beatles XL",25,38,8.91]
["2015-05-01","565405 Beatles XL",103,154,9.9]
["2015-06-01","565405 Beatles XL",38,57,11]
["2015-07-01","565405 Beatles XL",70,105,11]
["2015-08-01","565405 Beatles XL",73,109,11]
["2015-09-01","565405 Beatles XL",55,83,9.9]
["2015-10-01","565405 Beatles XL",190,285,11]
["2015-11-01","565405 Beatles XL",103,154,11]
["2015-12-01","565405 Beatles XL",73,109,11]
["2016-01-01","565405 Beatles XL",83,124,9.9]
["2016-02-01","565405 Beatles XL",43,64,11]
["2016-03-01","565405 Beatles XL",55,83,11]
["2016-04-01","565405 Beatles XL",195,293,9.9]
["2016-05-01","565405 Beatles XL",75,113,11]
["2016-06-01","565405 Beatles XL",133,199,11]
["2016-07-01","565405 Beatles XL",198,297,11]
["2016-08-01","565405 Beatles XL",220,330,11]
["2016-09-01","565405 Beatles XL",83,124,11]
["2016-10-01","565405 Beatles XL",340,510,11]
["2016-11-01","565405 Beatles XL",223,1560,11]
["2015-01-01","45645-RP",1,0,609.95]
["2015-02-01","45645-RP",0,0,554.95]
["2015-03-01","45645-RP",0,0,618.97]
["2015-04-01","45645-RP",0,0,599.94]
["2015-05-01","45645-RP",0,0,627.99]
["2015-06-01","45645-RP",0,3,552.97]
["2015-07-01","45645-RP",1,2,625.9]
["2015-08-01","45645-RP",0,2,557.92]
["2015-09-01","45645-RP",0,2,575.96]
["2015-10-01","45645-RP",0,2,553.96]
["2015-11-01","45645-RP",0,2,625.9]
["2015-12-01","45645-RP",0,2,579.92]
["2016-01-01","45645-RP",0,2,553.96]
["2016-02-01","45645-RP",0,2,588.94]
["2016-03-01","45645-RP",1,1,583.99]
["2016-04-01","45645-RP",0,1,556.93]
["2016-05-01","45645-RP",0,1,598.95]
["2016-06-01","45645-RP",0,1,617.98]
["2016-07-01","45645-RP",0,1,555.94]
["2016-08-01","45645-RP",0,1,627]
["2016-09-01","45645-RP",0,1,580.91]
["2016-10-01","45645-RP",1,0,624.91]
["2016-11-01","45645-RP",0,0,594]
["2016-12-01","45645-RP",0,0,617.98]
["2015-01-01","111565-02",19,28,664.95]
["2015-02-01","111565-02",19,28,598.95]
["2015-03-01","111565-02",7,35,658.9]
["2015-04-01","111565-02",19,28,578.93]
["2015-05-01","111565-02",32,47,640.97]
["2015-06-01","111565-02",25,38,609.95]
["2015-07-01","111565-02",63,94,578.93]
["2015-08-01","111565-02",32,47,599.94]
["2015-09-01","111565-02",19,28,616]
["2015-10-01","111565-02",25,38,586.96]
["2015-11-01","111565-02",0,0,632.94]
["2015-12-01","111565-02",0,0,598.95]
["2016-01-01","111565-02",25,60,599.94]
["2016-02-01","111565-02",75,80,642.95]
["2016-03-01","111565-02",75,80,616]
["2016-04-01","111565-02",56,84,620.95]
["2016-05-01","111565-02",56,84,625.9]
["2016-06-01","111565-02",87,131,662.97]
["2016-07-01","111565-02",50,75,653.95]
["2016-08-01","111565-02",56,84,649]
["2016-09-01","111565-02",38,56,601.92]
["2016-10-01","111565-02",19,28,616.99]
["2016-11-01","111565-02",25,38,651.97]
["2016-12-01","111565-02",33,49,645.92]
["2015-01-01","S01521-K",0,null,0]
["2015-02-01","S01521-K",0,null,0]
["2015-03-01","S01521-K",0,null,0]
["2015-04-01","S01521-K",0,null,0]
["2015-05-01","S01521-K",0,null,0]
["2015-06-01","S01521-K",0,null,0]
["2015-07-01","S01521-K",0,null,0]
["2015-08-01","S01521-K",0,null,0]
["2015-09-01","S01521-K",0,null,0]
["2015-10-01","S01521-K",0,null,0]
["2015-11-01","S01521-K",0,null,0]
["2015-12-01","S01521-K",0,null,0]
["2016-01-01","S01521-K",0,null,0]
["2016-02-01","S01521-K",0,null,0]
["2016-03-01","S01521-K",0,null,0]
["2016-04-01","S01521-K",0,null,0]
["2016-05-01","S01521-K",0,null,0]
["2016-06-01","S01521-K",0,null,0]
["2016-07-01","S01521-K",0,null,0]
["2016-08-01","S01521-K",0,null,0]
["2016-09-01","S01521-K",0,null,0]
["2016-10-01","S01521-K",3,5,9.9]
["2016-11-01","S01521-K",9,14,11]
["2016-12-01","S01521-K",14,21,9.9]
["2015-01-01","004662 Blue",0,null,0]
["2015-02-01","004662 Blue",0,null,0]
["2015-03-01","004662 Blue",0,null,0]
["2015-04-01","004662 Blue",0,null,0]
["2015-05-01","004662 Blue",0,null,0]
["2015-06-01","004662 Blue",0,null,0]
["2015-07-01","004662 Blue",0,null,0]
["2015-08-01","004662 Blue",0,null,0]
["2015-09-01","004662 Blue",0,null,0]
["2015-10-01","004662 Blue",0,null,0]
["2015-11-01","004662 Blue",0,null,0]
["2015-12-01","004662 Blue",0,null,0]
["2016-01-01","004662 Blue",0,null,0]
["2016-02-01","004662 Blue",0,null,0]
["2016-03-01","004662 Blue",0,null,0]
["2016-04-01","004662 Blue",0,null,0]
["2016-05-01","004662 Blue",34,200,24.97]
["2016-06-01","004662 Blue",34,166,25.96]
["2016-07-01","004662 Blue",29,132,23.98]
["2016-08-01","004662 Blue",25,103,24.97]
["2016-09-01","004662 Blue",26,78,23.98]
["2016-10-01","004662 Blue",23,52,23.98]
["2016-11-01","004662 Blue",19,29,25.96]
["2016-12-01","004662 Blue",18,10,26.95]
["2015-01-01","004652 Blue",70,516,20.9]
["2015-02-01","004652 Blue",70,446,20.9]
["2015-03-01","004652 Blue",103,343,22]
["2015-04-01","004652 Blue",133,210,20.9]
["2015-05-01","004652 Blue",136,74,22]
["2015-06-01","004652 Blue",154,846,19.91]
["2015-07-01","004652 Blue",122,724,22]
["2015-08-01","004652 Blue",115,609,22]
["2015-09-01","004652 Blue",121,488,20.9]
["2015-10-01","004652 Blue",105,383,22]
["2015-11-01","004652 Blue",86,297,22]
["2015-12-01","004652 Blue",84,213,22]
["2016-01-01","004652 Blue",73,140,19.91]
["2016-02-01","004652 Blue",96,44,20.9]
["2016-03-01","004652 Blue",44,0,20.9]
["2016-04-01","004652 Blue",158,1662,23.98]
["2016-05-01","004652 Blue",154,1431,23.98]
["2016-06-01","004652 Blue",155,1276,23.98]
["2016-07-01","004652 Blue",135,1073,23.98]
["2016-08-01","004652 Blue",113,903,23.98]
["2016-09-01","004652 Blue",119,724,23.98]
["2016-10-01","004652 Blue",108,562,26.95]
["2016-11-01","004652 Blue",88,430,24.97]
["2016-12-01","004652 Blue",82,307,26.95]
["2015-01-01","89654-T",21,32,268.95]
["2015-02-01","89654-T",21,32,237.93]
["2015-03-01","89654-T",36,54,242.99]
["2015-04-01","89654-T",24,36,238.92]
["2015-05-01","89654-T",15,23,253]
["2015-06-01","89654-T",33,50,256.96]
["2015-07-01","89654-T",9,14,268.95]
["2015-08-01","89654-T",12,18,250.91]
["2015-09-01","89654-T",24,36,258.94]
["2015-10-01","89654-T",18,27,235.95]
["2015-11-01","89654-T",3,5,244.97]
["2015-12-01","89654-T",24,36,250.91]
["2016-01-01","89654-T",18,27,266.97]
["2016-02-01","89654-T",24,36,268.95]
["2016-03-01","89654-T",36,54,253.99]
["2016-04-01","89654-T",27,41,250.91]
["2016-05-01","89654-T",24,36,264.99]
["2016-06-01","89654-T",12,18,260.92]
["2016-07-01","89654-T",18,27,250.91]
["2016-08-01","89654-T",33,50,253.99]
["2016-09-01","89654-T",24,36,253]
["2016-10-01","89654-T",30,45,256.96]
["2016-11-01","89654-T",33,50,250.91]
["2016-12-01","89654-T",27,41,266.97]
["2015-01-01",56213,21,32,3.96]
["2015-02-01",56213,36,54,3.96]
["2015-03-01",56213,16,24,3.96]
["2015-04-01",56213,17,26,3.96]
["2015-05-01",56213,12,18,3.96]
["2015-06-01",56213,12,18,3.96]
["2015-07-01",56213,5,8,3.96]
["2015-08-01",56213,14,21,3.96]
["2015-09-01",56213,12,18,3.96]
["2015-10-01",56213,12,18,3.96]
["2015-11-01",56213,33,50,3.96]
["2015-12-01",56213,44,66,3.96]
["2016-01-01",56213,31,47,3.96]
["2016-02-01",56213,24,36,3.96]
["2016-03-01",56213,16,24,3.96]
["2016-04-01",56213,9,14,3.96]
["2016-05-01",56213,8,12,3.96]
["2016-06-01",56213,6,9,3.96]
["2016-07-01",56213,7,11,3.96]
["2016-08-01",56213,13,20,3.96]
["2016-09-01",56213,10,15,3.96]
["2016-10-01",56213,16,24,3.96]
["2016-11-01",56213,23,35,4.95]
["2016-12-01",56213,31,47,4.95]
["2015-01-01","VB2166 150",0,null,0]
["2015-02-01","VB2166 150",0,null,0]
["2015-03-01","VB2166 150",0,null,0]
["2015-04-01","VB2166 150",0,null,0]
["2015-05-01","VB2166 150",0,null,0]
["2015-06-01","VB2166 150",0,null,0]
["2015-07-01","VB2166 150",0,null,0]
["2015-08-01","VB2166 150",0,null,0]
["2015-09-01","VB2166 150",0,null,0]
["2015-10-01","VB2166 150",0,null,0]
["2015-11-01","VB2166 150",0,null,0]
["2015-12-01","VB2166 150",0,null,0]
["2016-01-01","VB2166 150",0,null,0]
["2016-02-01","VB2166 150",0,null,0]
["2016-03-01","VB2166 150",0,null,0]
["2016-04-01","VB2166 150",0,null,0]
["2016-05-01","VB2166 150",0,null,0]
["2016-06-01","VB2166 150",0,null,0]
["2016-07-01","VB2166 150",0,null,0]
["2016-08-01","VB2166 150",0,null,0]
["2016-09-01","VB2166 150",0,null,0]
["2016-10-01","VB2166 150",20,30,15.95]
["2016-11-01","VB2166 150",30,45,15.95]
["2016-12-01","VB2166 150",36,54,16.94]
["2015-01-01","VR2156 200",333,500,20.9]
["2015-02-01","VR2156 200",333,500,19.91]
["2015-03-01","VR2156 200",343,515,20.9]
["2015-04-01","VR2156 200",331,497,18.92]
["2015-05-01","VR2156 200",345,518,18.92]
["2015-06-01","VR2156 200",329,494,18.92]
["2015-07-01","VR2156 200",336,504,19.91]
["2015-08-01","VR2156 200",332,498,18.92]
["2015-09-01","VR2156 200",331,497,19.91]
["2015-10-01","VR2156 200",348,522,20.9]
["2015-11-01","VR2156 200",328,492,20.9]
["2015-12-01","VR2156 200",381,572,20.9]
["2016-01-01","VR2156 200",346,519,20.9]
["2016-02-01","VR2156 200",330,495,22]
["2016-03-01","VR2156 200",358,537,22]
["2016-04-01","VR2156 200",353,530,19.91]
["2016-05-01","VR2156 200",351,527,20.9]
["2016-06-01","VR2156 200",347,521,20.9]
["2016-07-01","VR2156 200",348,522,22]
["2016-08-01","VR2156 200",341,512,19.91]
["2016-09-01","VR2156 200",345,518,20.9]
["2016-10-01","VR2156 200",359,539,22]
["2016-11-01","VR2156 200",346,519,22]
["2016-12-01","VR2156 200",393,590,20.9]
["2015-01-01","56645 Figure Skates",24,36,81.95]
["2015-02-01","56645 Figure Skates",24,36,84.92]
["2015-03-01","56645 Figure Skates",27,40,68.97]
["2015-04-01","56645 Figure Skates",25,37,69.96]
["2015-05-01","56645 Figure Skates",26,39,78.98]
["2015-06-01","56645 Figure Skates",24,36,77]
["2015-07-01","56645 Figure Skates",25,38,75.9]
["2015-08-01","56645 Figure Skates",25,37,75.9]
["2015-09-01","56645 Figure Skates",25,37,78.98]
["2015-10-01","56645 Figure Skates",29,43,84.92]
["2015-11-01","56645 Figure Skates",45,67,89.98]
["2015-12-01","56645 Figure Skates",72,107,89.98]
["2016-01-01","56645 Figure Skates",26,39,91.96]
["2016-02-01","56645 Figure Skates",26,38,88.99]
["2016-03-01","56645 Figure Skates",28,42,88]
["2016-04-01","56645 Figure Skates",28,42,92.95]
["2016-05-01","56645 Figure Skates",28,41,88.99]
["2016-06-01","56645 Figure Skates",27,40,84.92]
["2016-07-01","56645 Figure Skates",28,41,88]
["2016-08-01","56645 Figure Skates",26,39,86.9]
["2016-09-01","56645 Figure Skates",28,42,88.99]
["2016-10-01","56645 Figure Skates",31,47,82.94]
["2016-11-01","56645 Figure Skates",46,69,84.92]
["2016-12-01","56645 Figure Skates",76,114,88.99]
["2015-01-01","016543 Purple",0,null,0]
["2015-02-01","016543 Purple",0,null,0]
["2015-03-01","016543 Purple",0,null,0]
["2015-04-01","016543 Purple",0,null,0]
["2015-05-01","016543 Purple",0,null,0]
["2015-06-01","016543 Purple",0,null,0]
["2015-07-01","016543 Purple",0,null,0]
["2015-08-01","016543 Purple",0,null,0]
["2015-09-01","016543 Purple",0,null,0]
["2015-10-01","016543 Purple",0,null,0]
["2015-11-01","016543 Purple",0,null,0]
["2015-12-01","016543 Purple",0,null,0]
["2016-01-01","016543 Purple",0,null,0]
["2016-02-01","016543 Purple",0,null,0]
["2016-03-01","016543 Purple",0,null,0]
["2016-04-01","016543 Purple",0,null,0]
["2016-05-01","016543 Purple",0,null,0]
["2016-06-01","016543 Purple",0,null,0]
["2016-07-01","016543 Purple",0,null,0]
["2016-08-01","016543 Purple",0,null,0]
["2016-09-01","016543 Purple",219,2000,88]
["2016-10-01","016543 Purple",272,1782,89.98]
["2016-11-01","016543 Purple",327,1510,81.95]
["2016-12-01","016543 Purple",247,1183,89.98]
["2015-01-01","016542 Yellow",256,3265,80.96]
["2015-02-01","016542 Yellow",256,3009,75.9]
["2015-03-01","016542 Yellow",246,2753,80.96]
["2015-04-01","016542 Yellow",225,2508,73.92]
["2015-05-01","016542 Yellow",185,2284,74.91]
["2015-06-01","016542 Yellow",188,2099,82.94]
["2015-07-01","016542 Yellow",228,1911,77.99]
["2015-08-01","016542 Yellow",240,1684,81.95]
["2015-09-01","016542 Yellow",456,7444,73.92]
["2015-10-01","016542 Yellow",664,6989,91.96]
["2015-11-01","016542 Yellow",660,6325,84.92]
["2015-12-01","016542 Yellow",526,5665,88.99]
["2016-01-01","016542 Yellow",352,5140,88]
["2016-02-01","016542 Yellow",248,4789,84.92]
["2016-03-01","016542 Yellow",273,4541,80.96]
["2016-04-01","016542 Yellow",202,4269,84.92]
["2016-05-01","016542 Yellow",186,4067,83.93]
["2016-06-01","016542 Yellow",142,3881,90.97]
["2016-07-01","016542 Yellow",140,3740,89.98]
["2016-08-01","016542 Yellow",212,3600,80.96]
["2016-09-01","016542 Yellow",440,3389,84.92]
["2016-10-01","016542 Yellow",649,2950,85.91]
["2016-11-01","016542 Yellow",611,2301,89.98]
["2016-12-01","016542 Yellow",473,1690,88]
["2015-01-01","056329 N PW",0,null,0]
["2015-02-01","056329 N PW",0,null,0]
["2015-03-01","056329 N PW",0,null,0]
["2015-04-01","056329 N PW",0,null,0]
["2015-05-01","056329 N PW",0,null,0]
["2015-06-01","056329 N PW",0,null,0]
["2015-07-01","056329 N PW",0,null,0]
["2015-08-01","056329 N PW",0,null,0]
["2015-09-01","056329 N PW",0,null,0]
["2015-10-01","056329 N PW",0,null,0]
["2015-11-01","056329 N PW",0,null,0]
["2015-12-01","056329 N PW",0,null,0]
["2016-01-01","056329 N PW",0,null,0]
["2016-02-01","056329 N PW",0,null,0]
["2016-03-01","056329 N PW",0,null,0]
["2016-04-01","056329 N PW",0,null,0]
["2016-05-01","056329 N PW",0,null,0]
["2016-06-01","056329 N PW",0,null,0]
["2016-07-01","056329 N PW",0,null,0]
["2016-08-01","056329 N PW",0,null,0]
["2016-09-01","056329 N PW",0,null,0]
["2016-10-01","056329 N PW",0,null,0]
["2016-11-01","056329 N PW",89,414,36]
["2016-12-01","056329 N PW",90,257,41]
["2015-01-01","056329 PU PW",98,547,40]
["2015-02-01","056329 PU PW",95,387,36]
["2015-03-01","056329 PU PW",109,215,35]
["2015-04-01","056329 PU PW",102,300,38]
["2015-05-01","056329 PU PW",112,117,36]
["2015-06-01","056329 PU PW",124,160,38]
["2015-07-01","056329 PU PW",123,394,40]
["2015-08-01","056329 PU PW",127,185,38]
["2015-09-01","056329 PU PW",108,352,39]
["2015-10-01","056329 PU PW",103,177,35]
["2015-11-01","056329 PU PW",104,244,37]
["2015-12-01","056329 PU PW",98,77,38]
["2016-01-01","056329 PU PW",108,144,35]
["2016-02-01","056329 PU PW",118,284,37]
["2016-03-01","056329 PU PW",159,286,37]
["2016-04-01","056329 PU PW",165,527,39]
["2016-05-01","056329 PU PW",180,237,38]
["2016-06-01","056329 PU PW",195,172,37]
["2016-07-01","056329 PU PW",201,200,38]
["2016-08-01","056329 PU PW",204,212,38]
["2016-09-01","056329 PU PW",174,262,37]
["2016-10-01","056329 PU PW",165,341,40]
["2016-11-01","056329 PU PW",159,360,39]
["2016-12-01","056329 PU PW",148,106,39]
["2016-12-01","565405 Beatles L",209,1092,11]
["2016-12-01","565405 Beatles M",169,811,11]
["2016-12-01","565405 Beatles S",75,1181,11]
["2016-12-01","565405 Beatles XL",104,1456,11]

{"sheet":"Item information","index":1,"n_rows":37,"n_cols":8,"rows_kept":37,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Industry","Group","Item code","Description","Purchace price","Shelf life","Balance value","Supplier code"]
["Consumer goods","Sporting goods","B05465-R","Basketball 29.5 (size 7) [seasonal model]",11.99,null,11.99,3850]
["Food/Beverages","Alcoholic Beverages",50046,"Brut Cava 750ml [seasonal model]",7.79,null,7.92,3948]
["Pharmacies","Pharmacies","05-T48","Cold & Flu Tablets [seasonal model]",2.99,null,2.97,1012]
["Consumer goods","Electronics ","46689-PC","Computer  [seasonal model]",448,null,440,3850]
["Consumer goods","Building materials and equipments","C1020","Concrete block [trend model]",3.6900000000000004,null,3.96,3850]
["Food/Beverages","Alcoholic Beverages","002661-1","Dark Beer can 473 ml[zeroes are lost sales]",1.79,null,1.98,3948]
["Consumer goods","Furniture","1866-MB","Desk [stockout days]",198.99,null,195.91,3850]
["Consumer goods","Furniture","562156-01","Dining Table Modern [intermittent model]",358.99,null,355.96,3850]
["Consumer goods","Building materials and equipments","L2010","Lumber  [seasonal model]",0.49,null,0.99,3850]
["Food/Beverages","Chocolate",120565,"Milk Chocolate bar 200g [seasonal model]",1.09,3,1.98,5080]
["Consumer goods","Building materials and equipments","H2510","Nails [seasonal model]",0.05000000000000002,null,0.99,3850]
["Fashion","T-Shirts","565405 Beatles L","One Style L [excessive invetory]",7.49,null,7.92,4008]
["Fashion","T-Shirts","565405 Beatles M","One Style M [excessive invetory]",7.49,null,7.92,4008]
["Fashion","T-Shirts","565405 Beatles S","One Style S [excessive invetory]",7.49,null,7.92,4008]
["Fashion","T-Shirts","565405 Beatles XL","One Style XL [excessive invetory]",7.49,null,7.92,4008]
["Consumer goods","Electronics ","45645-RP","Radio player Silver [inactive model]",489.19,null,479.93,3850]
["Consumer goods","Furniture","111565-02","Sofa Modern [seasonal model]",578,null,572.99,3850]
["Consumer goods","Sporting goods","S01521-K","Sporting goods #2 [new product, top-down model]",0,null,0,3850]
["Fashion","Clothing Summer Style","004662 Blue","Swimwear #2 new[new product, use model from...]",0,null,0,4008]
["Fashion","Clothing Summer Style","004652 Blue","Swimwear [seasonal model]",18.49,null,18.92,4008]
["Consumer goods","Electronics ","89654-T","Toaster [constant level model]",234.59,null,231.99,3850]
["Food/Beverages","Chocolate",56213,"Truffles  30 g [seasonal model]",3.69,3,3.96,5080]
["Pharmacies","Pharmacies","VB2166 150","Vital Blue 150 g Vitamins new [new product, top-down model]",0,null,0,1012]
["Pharmacies","Pharmacies","VR2156 200","Vital Reds 200g Vitamins [seasonal model]",15.420000000000002,null,15.95,1012]
["Consumer goods","Sporting goods","56645 Figure Skates","White Women Figure Skates [seasonal model]",78.99,null,77.99,3850]
["Fashion","Clothing Winter Style","016543 Purple","Winter Coat #2[new product, use model from...]",0,null,0,4008]
["Fashion","Clothing Winter Style","016542 Yellow","Winter Coat [excessive invetory]",72.4,null,71.94,4008]
["Food/Beverages","Water","056329 N PW","Bottle water #2 new 500 ml [new product, use model from...]",0,null,0,3940]
["Food/Beverages","Water","056329 PU PW","Bottle water 500 ml [seasonal model]",22.68,null,22,3940]
["Fashion","T-Shirts","565405 Beatles L","One Style L [excessive invetory]",9.29,null,9.9,4008]
["Fashion","T-Shirts","565405 Beatles M","One Style M [excessive invetory]",9.29,null,9.9,4008]
["Fashion","T-Shirts","565405 Beatles S","One Style S [excessive invetory]",9.29,null,9.9,4008]
["Fashion","T-Shirts","565405 Beatles XL","One Style XL [excessive invetory]",9.29,null,9.9,4008]
[]
[]
[{"$nulls":5},"s"]

{"sheet":"Orders to receive","index":2,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Item code","Delivery date","Qt"]
["565405 Beatles L","2017-01-15",600]
["565405 Beatles M","2017-01-01",300]
["565405 Beatles M","2017-03-01",300]
["565405 Beatles M","2017-02-01",300]
["565405 Beatles S","2017-01-15",200]
["565405 Beatles XL","2017-01-15",200]

{"sheet":"Orders to ship","index":3,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Item code","Date","Qt"]
["565405 Beatles L","2017-01-15",4]
["565405 Beatles M","2017-01-01",7]
["565405 Beatles M","2017-03-01",10]
["565405 Beatles M","2017-02-01",30]
["565405 Beatles S","2017-01-15",10]
["565405 Beatles XL","2017-01-15",2]

{"sheet":"Bill of materials","index":4,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Assembled item's code","Qty","Material code"]
["1866-MB",200,"1866-MB-RO"]
["1866-MB",50,"1866-MB-TWG"]
["1866-MB",100,"1866-MB-WB"]
["1866-MB",50,"1866-MB-OB"]
["1866-MB",50,"1866-MB-R"]
["1866-MB",50,"1866-MB-CW"]