{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Average Percentage Change ","Using Formula","Percent Format","VBA"],"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":"Average Percentage Change ","index":0,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[11,1,11,2]]}
[]
[null,"Average Percentage Change in Excel"]
[]
[null,"Month","Sales Volume","Monthly Percentage Change"]
[null,"January",531]
[null,"February",506,{"$f":"(C6-C5)/C5","v":-4.7080979284369114E-2}]
[null,"March",577,{"$f":"(C7-C6)/C6","v":0.14031620553359683}]
[null,"April",588,1.9064124783362217E-2]
[null,"May",447,-0.23979591836734693]
[null,"June",528,0.18120805369127516]
[]
[null,"Average Percentage Change",null,{"$f":"SUM(D6:D10)/COUNT(D6:D10)","v":1.0742297271303635E-2}]

{"sheet":"Using Formula","index":1,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[11,1,11,2]]}
[]
[null,"Average Percentage Change Using Formula"]
[]
[null,"Month","Sales Volume","Monthly Percentage Change"]
[null,"January",531]
[null,"February",506,-4.71]
[null,"March",577,14.03]
[null,"April",588,1.91]
[null,"May",447,-23.98]
[null,"June",528,18.12]
[]
[null,"Average Percentage Change",null,{"$f":"SUM(D6:D10)/COUNT(D6:D10)","v":1.0740000000000003}]

{"sheet":"Percent Format","index":2,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[11,1,11,2]]}
[]
[null,"Average Percentage Change Using Percent Format"]
[]
[null,"Month","Sales Volume","Monthly Percentage Change"]
[null,"January",531]
[null,"February",506,{"$f":"(C6-C5)/C5","v":-4.7080979284369114E-2}]
[null,"March",577,{"$f":"(C7-C6)/C6","v":0.14031620553359683}]
[null,"April",588,1.9064124783362217E-2]
[null,"May",447,-0.23979591836734693]
[null,"June",528,0.18120805369127516]
[]
[null,"Average Percentage Change",null,{"$f":"SUM(D6:D10)/COUNT(D6:D10)","v":1.0742297271303635E-2}]

{"sheet":"VBA","index":3,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[11,1,11,2]]}
[]
[null,"Average Percentage Change Using VBA"]
[]
[null,"Month","Sales Volume","Monthly Percentage Change"]
[null,"January",531]
[null,"February",506,-4.71]
[null,"March",577,14.03]
[null,"April",588,1.91]
[null,"May",447,-23.98]
[null,"June",528,18.12]
[]
[null,"Average Percentage Change",null,1.07]