{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Sheet1","index":0,"n_rows":32,"n_cols":4,"rows_kept":32,"merged":[[31,0,31,11]],"flags":["formulas_cached_only"]}
["Day","Date","Product","Move"]
["2012-01-01","D1","C1","Empty"]
["2012-01-01","D1","C2","Empty"]
["2012-01-01","D1","C3","Purchase"]
["2012-01-01","D1","C4","Empty"]
["2012-01-01","D1","C3","Empty"]
["2012-02-01","D2","C1","Stuffed"]
["2012-02-01","D2","C5","Empty"]
["2012-02-01","D2","C3","Stuffed"]
["2012-02-01","D2","C6","Empty"]
["2012-03-01","D3","C7","Empty"]
["2012-03-01","D3","C2","Stuffed"]
["2012-03-01","D3","C1","OnMove"]
["2012-03-01","D3","C4","Stuffed"]
["2012-03-01","D3","C6","Stuffed"]
["2012-03-01","D3","C8","Empty"]
["2012-04-01","D4","C2","DropOff"]
["2012-04-01","D4","C3","DropOff"]
["2012-04-01","D4","C9","Empty"]
["2012-04-01","D4","C4","Discharge"]
[]
[]
["Output Expected"]
["Day","total","inventory"]
["2012-01-01",4,4,"4 new, 1 repeated"]
["2012-02-01",4,6,"2 repeated products not counted as it is already calculated in previous day"]
["2012-03-01",6,8,"4 repeated products not counted as it is already calculated in previous day's (C2,C1,C4 on Day1, C6on Day2)"]
["2012-04-01",4,8,"2 released products not counted as these are DropOff on this day and & 1 repeated product not counted"]
[]
[]
["Note : Calculate distinct Products As On Date basis"]
["Eg: on Day 1st 4 products introduced, so the total is 4, on Day 2nd 4 products work done but from that only 2 are newly introduced remaining 2 are from yesterday so it should calculate\n4+2=6, on Day 3 there 6 products works done but from that only 2 are newly introduced remaing 4 are from previous days records so the value is 4+2+2=8"]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}