{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Welcome","Input","Monthly Summary (output)"],"not_rendered":{"images":1,"macros":1,"defined_names":1,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"Welcome","index":0,"n_rows":9,"n_cols":1,"rows_kept":9}
[1]
[]
[]
[]
[]
[]
[]
["Read the post at:"]
["https://wmfexcel.com/?p=18272"]

{"sheet":"Input","index":1,"n_rows":104,"n_cols":3,"rows_kept":104}
["Date","Item","Quantity"]
["2020-01-04","A",14]
["2020-01-05","B",48]
["2020-01-05","A",51]
["2020-01-06","A",20]
["2020-01-07","A",87]
["2020-01-09","B",10]
["2020-01-12","B",24]
["2020-01-13","A",83]
["2020-01-13","A",29]
["2020-01-15","A",16]
["2020-01-15","B",73]
["2020-01-16","B",72]
["2020-01-16","A",87]
["2020-01-17","A",51]
["2020-01-19","A",5]
["2020-01-19","A",7]
["2020-01-19","B",79]
["2020-01-20","A",33]
["2020-01-21","A",35]
["2020-01-21","A",11]
["2020-01-21","B",75]
["2020-01-22","B",69]
["2020-01-22","A",30]
["2020-01-23","A",95]
["2020-01-24","A",42]
["2020-01-25","B",72]
["2020-01-25","A",26]
["2020-01-26","B",36]
["2020-01-29","B",68]
["2020-02-02","A",84]
["2020-02-02","A",67]
["2020-02-04","B",11]
["2020-02-05","A",10]
["2020-02-05","B",46]
["2020-02-06","A",35]
["2020-02-10","A",10]
["2020-02-10","A",62]
["2020-02-10","B",9]
["2020-02-11","B",2]
["2020-02-13","A",80]
["2020-02-14","B",72]
["2020-02-14","A",48]
["2020-02-14","A",9]
["2020-02-15","A",23]
["2020-02-15","B",80]
["2020-02-15","B",80]
["2020-02-16","B",28]
["2020-02-18","A",30]
["2020-02-18","B",39]
["2020-02-18","A",34]
["2020-02-21","A",72]
["2020-02-22","A",8]
["2020-02-23","A",11]
["2020-02-24","B",51]
["2020-02-26","B",61]
["2020-02-26","B",45]
["2020-02-26","A",5]
["2020-02-27","B",76]
["2020-02-28","A",4]
["2020-02-28","A",13]
["2020-02-29","A",31]
["2020-02-29","B",63]
["2020-02-29","A",63]
["2020-03-01","B",44]
["2020-03-03","A",10]
["2020-03-05","B",27]
["2020-03-05","A",96]
["2020-03-06","B",10]
["2020-03-07","B",85]
["2020-03-07","A",57]
["2020-03-08","A",14]
["2020-03-09","B",30]
["2020-03-12","B",89]
["2020-03-12","B",60]
["2020-03-12","A",9]
["2020-03-13","A",48]
["2020-03-13","A",69]
["2020-03-13","A",1]
["2020-03-14","B",14]
["2020-03-14","B",69]
["2020-03-14","B",73]
["2020-03-15","A",29]
["2020-03-15","A",74]
["2020-03-15","B",66]
["2020-03-15","A",38]
["2020-03-16","B",14]
["2020-03-17","A",2]
["2020-03-17","A",86]
["2020-03-18","B",75]
["2020-03-20","A",7]
["2020-03-20","B",11]
["2020-03-21","B",42]
["2020-03-22","B",32]
["2020-03-22","B",46]
["2020-03-23","B",3]
["2020-03-23","B",24]
["2020-03-23","A",43]
["2020-03-26","B",44]
["2020-03-29","B",91]
["2020-03-30","A",40]
["2020-04-01","A",100]
["2020-04-10","A",120]
["2020-04-10","B",200]

{"sheet":"Monthly Summary (output)","index":2,"n_rows":27,"n_cols":4,"rows_kept":27}
[]
[]
[]
[]
[]
["Sum of Quantity","Product"]
["Date","A","B","Grand Total"]
["2020-01-04",14,null,14]
["2020-01-05",51,48,99]
["2020-01-06",20,null,20]
["2020-01-07",87,null,87]
["2020-01-09",null,10,10]
["2020-01-12",null,24,24]
["2020-01-13",112,null,112]
["2020-01-15",16,73,89]
["2020-01-16",87,72,159]
["2020-01-17",51,null,51]
["2020-01-19",12,79,91]
["2020-01-20",33,null,33]
["2020-01-21",46,75,121]
["2020-01-22",30,69,99]
["2020-01-23",95,null,95]
["2020-01-24",42,null,42]
["2020-01-25",26,72,98]
["2020-01-26",null,36,36]
["2020-01-29",null,68,68]
["Grand Total",722,626,1348]