{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Using NotePad","Using 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":"Using NotePad","index":0,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Yearly Revenue Per Unit"]
[]
[null,"Unit",2020,2021,"Total","Formula",null,"Formula as Text"]
[null,"BW502",16901,13408,{"$f":"SUM(C5:D5)","v":30309},{"$f":"_xlfn.FORMULATEXT(E5)","v":"=SUM(C5:D5)"},null,"=SUM(C5:D5)"]
[null,"BW503",10084,16786,{"$f":"SUM(C6:D6)","v":26870},{"$f":"_xlfn.FORMULATEXT(E6)","v":"=SUM(C6:D6)"},null,"=SUM(C6:D6)"]
[null,"BW504",11221,19127,30348,"=SUM(C7:D7)",null,"=SUM(C7:D7)"]
[null,"BW505",16509,10423,26932,"=SUM(C8:D8)",null,"=SUM(C8:D8)"]
[null,"BW506",10070,14255,24325,"=SUM(C9:D9)",null,"=SUM(C9:D9)"]
[null,"BW507",19182,19410,38592,"=SUM(C10:D10)",null,"=SUM(C10:D10)"]
[null,"BW508",14499,13733,28232,"=SUM(C11:D11)",null,"=SUM(C11:D11)"]
[null,"BW509",9816,8056,17872,{"$f":"_xlfn.FORMULATEXT(E12)","v":"=SUM(C12:D12)"},null,"=SUM(C12:D12)"]

{"sheet":"Using VBA","index":1,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Yearly Revenue Per Unit"]
[]
[null,"Unit",2020,2021,"Total"]
[null,"BW502",16901,13408,{"$f":"SUM(C5:D5)","v":30309},"SUM(C5:D5)"]
[null,"BW503",10084,16786,{"$f":"SUM(C6:D6)","v":26870},"SUM(C6:D6)"]
[null,"BW504",11221,19127,30348,"SUM(C7:D7)"]
[null,"BW505",16509,10423,26932,"SUM(C8:D8)"]
[null,"BW506",10070,14255,24325,"SUM(C9:D9)"]
[null,"BW507",19182,19410,38592,"SUM(C10:D10)"]
[null,"BW508",14499,13733,28232,"SUM(C11:D11)"]
[null,"BW509",9816,8056,17872,"SUM(C12:D12)"]