{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Dataset","SUM","AVERAGE","WEIGHTED","EXPONENTIAL","VBA","OFFSET"],"not_rendered":{"charts":0,"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":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Monthly Sales Data of Amigo Super Store"]
[]
[null,"Day","Date","Sales "]
[null,"1st","2023-01-01",3089]
[null,"2nd","2023-01-02",2643]
[null,"3rd","2023-01-03",2895]
[null,"4th","2023-01-04",2165]
[null,"5th","2023-01-05",2214]
[null,"6th","2023-01-06",3265]
[null,"7th","2023-01-07",3526]
[null,"8th","2023-01-08",2315]
[null,"9th","2023-01-09",3469]
[null,"10th","2023-01-10",3154]
[null,"11th","2023-01-11",2354]
[null,"12th","2023-01-12",3265]

{"sheet":"SUM","index":1,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Monthly Sales Data of Amigo Super Store"]
[]
[null,"Day","Date","Sales ","7-Day Moving Average"]
[null,"1st","2023-01-01",3089]
[null,"2nd","2023-01-02",2643]
[null,"3rd","2023-01-03",2895]
[null,"4th","2023-01-04",2165]
[null,"5th","2023-01-05",2214]
[null,"6th","2023-01-06",3265]
[null,"7th","2023-01-07",3526,{"$f":"SUM(D6:D12)/7","v":2828.1428571428573}]
[null,"8th","2023-01-08",2315,{"$f":"SUM(D7:D13)/7","v":2717.5714285714284}]
[null,"9th","2023-01-09",3469,2835.5714285714284]
[null,"10th","2023-01-10",3154,2872.5714285714284]
[null,"11th","2023-01-11",2354,2899.5714285714284]
[null,"12th","2023-01-12",3265,3049.7142857142858]

{"sheet":"AVERAGE","index":2,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Monthly Sales Data of Amigo Super Store"]
[]
[null,"Day","Date","Sales ","7-Day Moving Average"]
[null,"1st","2023-01-01",3089]
[null,"2nd","2023-01-02",2643]
[null,"3rd","2023-01-03",2895]
[null,"4th","2023-01-04",2165]
[null,"5th","2023-01-05",2214]
[null,"6th","2023-01-06",3265]
[null,"7th","2023-01-07",3526,{"$f":"AVERAGE(D6:D12)","v":2828.1428571428573}]
[null,"8th","2023-01-08",2315,{"$f":"AVERAGE(D7:D13)","v":2717.5714285714284}]
[null,"9th","2023-01-09",3469,2835.5714285714284]
[null,"10th","2023-01-10",3154,2872.5714285714284]
[null,"11th","2023-01-11",2354,2899.5714285714284]
[null,"12th","2023-01-12",3265,3049.7142857142858]

{"sheet":"WEIGHTED","index":3,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Monthly Sales Data of Amigo Super Store"]
[]
[null,"Day","Date","Sales ","7-Day Moving Average",null,"Day","Weight"]
[null,"1st","2023-01-01",3089,null,null,"1st",0.1]
[null,"2nd","2023-01-02",2643,null,null,"2nd",0.1]
[null,"3rd","2023-01-03",2895,null,null,"3rd",0.15]
[null,"4th","2023-01-04",2165,null,null,"4th",0.15]
[null,"5th","2023-01-05",2214,null,null,"5th",0.15]
[null,"6th","2023-01-06",3265,null,null,"6th",0.15]
[null,"7th","2023-01-07",3526,{"$f":"D6*$H$6+D7*$H$7+D8*$H$8+D9*$H$9+D10*$H$10+D11*$H$11+D12*$H$12","v":2859.25},null,"7th",0.2]
[null,"8th","2023-01-08",2315,{"$f":"D7*$H$6+D8*$H$7+D9*$H$8+D10*$H$9+D11*$H$10+D12*$H$11+D13*$H$12","v":2692.2999999999997}]
[null,"9th","2023-01-09",3469,2897.8]
[null,"10th","2023-01-10",3154,2954.9500000000003]
[null,"11th","2023-01-11",2354,2888.3]
[null,"12th","2023-01-12",3265,3025.8999999999996]

{"sheet":"EXPONENTIAL","index":4,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Monthly Sales Data of Amigo Super Store"]
[]
[null,"Day","Date","Sales ","7-Day Moving Average"]
[null,"1st","2023-01-01",3089,3089]
[null,"2nd","2023-01-02",2643,{"$f":"(D7-E6)*(2/8)+E6","v":2977.5}]
[null,"3rd","2023-01-03",2895,{"$f":"(D8-E7)*(2/8)+E7","v":2956.875}]
[null,"4th","2023-01-04",2165,2758.90625]
[null,"5th","2023-01-05",2214,2622.6796875]
[null,"6th","2023-01-06",3265,2783.259765625]
[null,"7th","2023-01-07",3526,2968.94482421875]
[null,"8th","2023-01-08",2315,2805.4586181640625]
[null,"9th","2023-01-09",3469,2971.3439636230469]
[null,"10th","2023-01-10",3154,3017.0079727172852]
[null,"11th","2023-01-11",2354,2851.2559795379639]
[null,"12th","2023-01-12",3265,2954.6919846534729]

{"sheet":"VBA","index":5,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Monthly Sales Data of Amigo Super Store"]
[]
[null,"Day","Date","Sales ","7-Day Moving Average"]
[null,"1st","2023-01-01",3089]
[null,"2nd","2023-01-02",2643]
[null,"3rd","2023-01-03",2895]
[null,"4th","2023-01-04",2165]
[null,"5th","2023-01-05",2214]
[null,"6th","2023-01-06",3265]
[null,"7th","2023-01-07",3526,{"$f":"AVERAGE(D6:D12)","v":2828.1428571428573}]
[null,"8th","2023-01-08",2315,{"$f":"AVERAGE(D7:D13)","v":2717.5714285714284}]
[null,"9th","2023-01-09",3469,2835.5714285714284]
[null,"10th","2023-01-10",3154,2872.5714285714284]
[null,"11th","2023-01-11",2354,2899.5714285714284]
[null,"12th","2023-01-12",3265,3049.7142857142858]

{"sheet":"OFFSET","index":6,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[[2,1,2,6],[18,2,18,5]]}
[]
[]
[null,"Monthly Sales Data of Amigo Super Store"]
[]
[null,"Month","Date","Sales","Month","Date","Sales"]
[null,"1st","2021-01-01",3089,"13th","2022-01-01",2315]
[null,"2nd","2021-02-01",2643,"14th","2022-02-01",3469]
[null,"3rd","2021-03-01",2895,"15th","2022-03-01",3154]
[null,"4th","2021-04-01",2165,"16th","2022-04-01",3265]
[null,"5th","2021-05-01",2214,"17th","2022-05-01",3526]
[null,"6th","2021-06-01",3265,"18th","2022-06-01",3089]
[null,"7th","2021-07-01",3526,"19th","2022-07-01",2643]
[null,"8th","2021-08-01",2315,"20th","2022-08-01",2895]
[null,"9th","2021-09-01",3469,"21st","2022-09-01",2354]
[null,"10th","2021-10-01",3154,"22nd","2022-10-01",2643]
[null,"11th","2021-11-01",2354,"23rd","2022-11-01"]
[null,"12th","2021-12-01",3265,"24th","2022-12-01"]
[]
[null,null,"Average for last 12 months",null,null,null,{"$f":"AVERAGE(OFFSET(D6,COUNT(D6:D17,G6:G17)-12,0,12,1))","v":2809.5}]