{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Dataset","Arithmetic","SUM Function","AVERAGE","Weighted","exponential","last 3 months","Incomplete data","VBA","Comparison","Practice"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"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":"Dataset","index":0,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"\"XYZ\" Company"]
[]
[null,"Serial No.","Month","Year","Demand (KG)"]
[null,1,"January",2021,100]
[null,2,"February",2021,125]
[null,3,"March",2021,235]
[null,4,"April",2021,345]
[null,5,"May",2021,236]
[null,6,"June",2021,76]
[null,7,"July",2021,567]
[null,8,"August",2021,453]
[null,9,"September",2021,234]
[null,10,"October",2021,129]
[null,11,"November",2021,679]
[null,12,"December",2021,532]

{"sheet":"Arithmetic","index":1,"n_rows":19,"n_cols":13,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"Using Arithmetic Operator"]
[]
[null,"Serial No.","Month","Year","Demand (KG)","Moving Average"]
[null,1,"January",2021,100]
[null,2,"February",2021,125]
[null,3,"March",2021,235,{"$f":"(E6+E5+E4)/3","v":153.33333333333334}]
[null,4,"April",2021,345,{"$f":"(E7+E6+E5)/3","v":235}]
[null,5,"May",2021,236,272]
[null,6,"June",2021,76,219]
[null,7,"July",2021,567,293]
[null,8,"August",2021,453,365.33333333333331]
[null,9,"September",2021,234,418]
[null,10,"October",2021,129,272]
[null,11,"November",2021,679,347.33333333333331]
[null,12,"December",2021,532,446.66666666666669]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"",null,""]

{"sheet":"SUM Function","index":2,"n_rows":19,"n_cols":11,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"Using SUM Function"]
[]
[null,"Serial No.","Month","Year","Demand (KG)","Moving Average"]
[null,1,"January",2021,100]
[null,2,"February",2021,125]
[null,3,"March",2021,235,{"$f":"SUM(E4:E6)/3","v":153.33333333333334}]
[null,4,"April",2021,345,{"$f":"SUM(E5:E7)/3","v":235}]
[null,5,"May",2021,236,272]
[null,6,"June",2021,76,219]
[null,7,"July",2021,567,293]
[null,8,"August",2021,453,365.33333333333331]
[null,9,"September",2021,234,418]
[null,10,"October",2021,129,272]
[null,11,"November",2021,679,347.33333333333331]
[null,12,"December",2021,532,446.66666666666669]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"AVERAGE","index":3,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"Using AVERAGE Function"]
[]
[null,"Serial No.","Month","Year","Demand (KG)","Moving Average"]
[null,1,"January",2021,100]
[null,2,"February",2021,125]
[null,3,"March",2021,235,{"$f":"AVERAGE(E4:E6)","v":153.33333333333334}]
[null,4,"April",2021,345,{"$f":"AVERAGE(E5:E7)","v":235}]
[null,5,"May",2021,236,272]
[null,6,"June",2021,76,219]
[null,7,"July",2021,567,293]
[null,8,"August",2021,453,365.33333333333331]
[null,9,"September",2021,234,418]
[null,10,"October",2021,129,272]
[null,11,"November",2021,679,347.33333333333331]
[null,12,"December",2021,532,446.66666666666669]
[]
[]
[null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"Weighted","index":4,"n_rows":21,"n_cols":14,"rows_kept":21,"cut":false,"hidden":false,"merged":[[14,5,14,6],[13,5,13,6],[12,5,12,6],[11,5,11,6],[0,1,0,5],[2,5,2,6],[3,5,3,6],[5,5,5,6],[4,5,4,6],[10,5,10,6],[9,5,9,6],[8,5,8,6],[7,5,7,6],[6,5,6,6]]}
[null,"Weighted Moving Average"]
[null,"W1",0.2,"W2",0.4,"W3",0.6]
[null,"Serial No.","Month","Year","Demand (KG)","Moving Average"]
[null,1,"January",2021,100]
[null,2,"February",2021,125]
[null,3,"March",2021,235,{"$f":"E6*$G$2+E5*$E$2+E4*$C$2","v":211}]
[null,4,"April",2021,345,{"$f":"E7*$G$2+E6*$E$2+E5*$C$2","v":326}]
[null,5,"May",2021,236,326.60000000000002]
[null,6,"June",2021,76,209]
[null,7,"July",2021,567,417.79999999999995]
[null,8,"August",2021,453,513.80000000000007]
[null,9,"September",2021,234,435]
[null,10,"October",2021,129,261.60000000000002]
[null,11,"November",2021,679,505.8]
[null,12,"December",2021,532,{"$f":"E15*$G$2+E14*$E$2+E13*$C$2","v":616.59999999999991}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"exponential","index":5,"n_rows":21,"n_cols":14,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,1,0,6]]}
[null,"Exponential Moving Average"]
[]
[null,"Serial No.","Month","Year","Demand (KG)","Simple","Exponential"]
[null,1,"January",2021,100]
[null,2,"February",2021,125]
[null,3,"March",2021,235,{"$f":"AVERAGE(E4:E6)","v":153.33333333333334}]
[null,4,"April",2021,345,{"$f":"AVERAGE(E5:E7)","v":235},{"$f":"0.2*E6+(1-0.2)*F6","v":169.66666666666669}]
[null,5,"May",2021,236,272,{"$f":"0.2*E7+(1-0.2)*F7","v":257}]
[null,6,"June",2021,76,219,264.8]
[null,7,"July",2021,567,293,190.4]
[null,8,"August",2021,453,365.33333333333331,347.8]
[null,9,"September",2021,234,418,382.86666666666667]
[null,10,"October",2021,129,272,381.20000000000005]
[null,11,"November",2021,679,347.33333333333331,243.40000000000003]
[null,12,"December",2021,532,446.66666666666669,413.66666666666669]
[]
[]
[null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"last 3 months","index":6,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Moving Average for Last 3 Months"]
[]
[null,"Serial No.","Month","Year","Demand (KG)"]
[null,1,"January",2021,100,"Average"]
[null,2,"February",2021,125,{"$f":"AVERAGE(OFFSET(E4,COUNT(E4:E2000)-3,0,3,1))","v":446.66666666666669}]
[null,3,"March",2021,235]
[null,4,"April",2021,345,"Simple Average"]
[null,5,"May",2021,236,{"$f":"AVERAGE(E13:E15)","v":446.66666666666669}]
[null,6,"June",2021,76]
[null,7,"July",2021,567]
[null,8,"August",2021,453]
[null,9,"September",2021,234]
[null,10,"October",2021,129]
[null,11,"November",2021,679]
[null,12,"December",2021,532]

{"sheet":"Incomplete data","index":7,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"Using AVERAGE and OFFSET Function"]
[]
[null,"Serial No.","Month","Year","Demand (KG)","Moving Average"]
[null,1,"January",2021,100,{"$f":"AVERAGE(OFFSET(E4,0,0,-(MIN(ROW()-ROW($E$4)+1,3)),1))","v":100}]
[null,2,"February",2021,125,{"$f":"AVERAGE(OFFSET(E5,0,0,-(MIN(ROW()-ROW($E$4)+1,3)),1))","v":112.5}]
[null,3,"March",2021,235,153.33333333333334]
[null,4,"April",2021,345,235]
[null,5,"May",2021,236,272]
[null,6,"June",2021,76,219]
[null,7,"July",2021,567,293]
[null,8,"August",2021,453,365.33333333333331]
[null,9,"September",2021,234,418]
[null,10,"October",2021,129,272]
[null,11,"November",2021,679,347.33333333333331]
[null,12,"December",2021,532,446.66666666666669]
[]
[]
[null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"VBA","index":8,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"Using VBA Code"]
[]
[null,"Serial No.","Month","Year","Demand (KG)","Moving Average"]
[null,1,"January",2021,100]
[null,2,"February",2021,125]
[null,3,"March",2021,235,153.33333333333334]
[null,4,"April",2021,345,235]
[null,5,"May",2021,236,272]
[null,6,"June",2021,76,219]
[null,7,"July",2021,567,293]
[null,8,"August",2021,453,365.33333333333331]
[null,9,"September",2021,234,418]
[null,10,"October",2021,129,272]
[null,11,"November",2021,679,347.33333333333331]
[null,12,"December",2021,532,446.66666666666669]
[]
[]
[null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"Comparison","index":9,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"Comparison between SMA, WMA, EMA"]
[]
[null,"Month","Demand (KG)","Simple","Weighted","Exponential"]
[null,"January,2021",100]
[null,"February,2021",125]
[null,"March,2021",235,{"$f":"AVERAGE(C4:C6)","v":153.33333333333334},211]
[null,"April,2021",345,{"$f":"AVERAGE(C5:C7)","v":235},326,169.66666666666669]
[null,"May,2021",236,272,326.60000000000002,257]
[null,"June,2021",76,219,209,264.8]
[null,"July,2021",567,293,417.79999999999995,190.4]
[null,"August,2021",453,365.33333333333331,513.80000000000007,347.8]
[null,"September,2021",234,418,435,382.86666666666667]
[null,"October,2021",129,272,261.60000000000002,381.20000000000005]
[null,"November,2021",679,347.33333333333331,505.8,243.40000000000003]
[null,"December,2021",532,446.66666666666669,616.59999999999991,413.66666666666669]
[]
[]
[null,null,null,null,null,null,null,null,null,""]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"Practice","index":10,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Practice"]
[]
[null,"Serial No.","Month","Year","Demand (KG)"]
[null,1,"January",2021,100]
[null,2,"February",2021,125]
[null,3,"March",2021,235]
[null,4,"April",2021,345]
[null,5,"May",2021,236]
[null,6,"June",2021,76]
[null,7,"July",2021,567]
[null,8,"August",2021,453]
[null,9,"September",2021,234]
[null,10,"October",2021,129]
[null,11,"November",2021,679]
[null,12,"December",2021,532]