{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Dataset","Clear Contents","Go To Special","VBA Code","Clear Content Keep Formatting"],"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":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Cost Breakdown of Widget Production"]
[]
[null,"Week","Unit Production","Per Unit Cost","Total Cost"]
[null,1,27,130,{"$f":"C5*D5","v":3510}]
[null,2,29,125,{"$f":"C6*D6","v":3625}]
[null,3,25,140,3500]
[null,4,21,135,{"$f":"C8*D8","v":2835}]
[null,5,32,132,{"$f":"C9*D9","v":4224}]
[null,6,28,137,3836]
[]
[null,"Total",{"$f":"SUM(C5:C10)","v":162},null,{"$f":"SUM(E5:E10)","v":21530}]

{"sheet":"Clear Contents","index":1,"n_rows":12,"n_cols":15,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,14]]}
[]
[null,"Utilizing Clear Contents Option",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Week","Unit Production","Per Unit Cost","Total Cost",null,null,null,null,null,null,"Week","Unit Production","Per Unit Cost","Total Cost"]
[null,null,null,null,{"$f":"C5*D5","v":0},null,null,null,null,null,null,1,27,130,{"$f":"M5*N5","v":3510}]
[null,null,null,null,{"$f":"C6*D6","v":0},null,null,null,null,null,null,2,29,125,{"$f":"M6*N6","v":3625}]
[null,null,null,null,0,null,null,null,null,null,null,3,25,140,3500]
[null,null,null,null,{"$f":"C8*D8","v":0},null,null,null,null,null,null,4,21,135,{"$f":"M8*N8","v":2835}]
[null,null,null,null,{"$f":"C9*D9","v":0},null,null,null,null,null,null,5,32,132,{"$f":"M9*N9","v":4224}]
[null,null,null,null,0,null,null,null,null,null,null,6,28,137,3836]
[]
[null,"Total",{"$f":"SUM(C5:C10)","v":0},null,{"$f":"SUM(E5:E10)","v":0},null,null,null,null,null,null,"Total",{"$f":"SUM(M5:M10)","v":162},null,{"$f":"SUM(O5:O10)","v":21530}]

{"sheet":"Go To Special","index":2,"n_rows":12,"n_cols":15,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,14]]}
[]
[null,"Using Go To Special Feature",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Week","Unit Production","Per Unit Cost","Total Cost",null,null,null,null,null,null,"Week","Unit Production","Per Unit Cost","Total Cost"]
[null,null,null,null,{"$f":"C5*D5","v":0},null,null,null,null,null,null,1,27,130,{"$f":"M5*N5","v":3510}]
[null,null,null,null,{"$f":"C6*D6","v":0},null,null,null,null,null,null,2,29,125,{"$f":"M6*N6","v":3625}]
[null,null,null,null,0,null,null,null,null,null,null,3,25,140,3500]
[null,null,null,null,{"$f":"C8*D8","v":0},null,null,null,null,null,null,4,21,135,{"$f":"M8*N8","v":2835}]
[null,null,null,null,{"$f":"C9*D9","v":0},null,null,null,null,null,null,5,32,132,{"$f":"M9*N9","v":4224}]
[null,null,null,null,0,null,null,null,null,null,null,6,28,137,3836]
[]
[null,"Total",{"$f":"SUM(C5:C10)","v":0},null,{"$f":"SUM(E5:E10)","v":0},null,null,null,null,null,null,"Total",{"$f":"SUM(M5:M10)","v":162},null,{"$f":"SUM(O5:O10)","v":21530}]

{"sheet":"VBA Code","index":3,"n_rows":12,"n_cols":15,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,14]]}
[]
[null,"Applying VBA Code",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Week","Unit Production","Per Unit Cost","Total Cost",null,null,null,null,null,null,"Week","Unit Production","Per Unit Cost","Total Cost"]
[null,1,null,null,{"$f":"C5*D5","v":0},null,null,null,null,null,null,1,27,130,{"$f":"M5*N5","v":3510}]
[null,2,null,null,{"$f":"C6*D6","v":0},null,null,null,null,null,null,2,29,125,{"$f":"M6*N6","v":3625}]
[null,3,null,null,0,null,null,null,null,null,null,3,25,140,3500]
[null,4,null,null,{"$f":"C8*D8","v":0},null,null,null,null,null,null,4,21,135,{"$f":"M8*N8","v":2835}]
[null,5,null,null,{"$f":"C9*D9","v":0},null,null,null,null,null,null,5,32,132,{"$f":"M9*N9","v":4224}]
[null,6,null,null,0,null,null,null,null,null,null,6,28,137,3836]
[]
[null,"Total",{"$f":"SUM(C5:C10)","v":0},null,{"$f":"SUM(E5:E10)","v":0},null,null,null,null,null,null,"Total",{"$f":"SUM(M5:M10)","v":162},null,{"$f":"SUM(O5:O10)","v":21530}]

{"sheet":"Clear Content Keep Formatting","index":4,"n_rows":12,"n_cols":15,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,14]]}
[]
[null,"Clearing Contents Without Deleting Formatting",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Week","Unit Production","Per Unit Cost","Total Cost",null,null,null,null,null,null,"Week","Unit Production","Per Unit Cost","Total Cost"]
[null,null,null,null,null,null,null,null,null,null,null,1,27,130,{"$f":"M5*N5","v":3510}]
[null,null,null,null,null,null,null,null,null,null,null,2,29,125,{"$f":"M6*N6","v":3625}]
[null,null,null,null,null,null,null,null,null,null,null,3,25,140,3500]
[null,null,null,null,null,null,null,null,null,null,null,4,21,135,{"$f":"M8*N8","v":2835}]
[null,null,null,null,null,null,null,null,null,null,null,5,32,132,{"$f":"M9*N9","v":4224}]
[null,null,null,null,null,null,null,null,null,null,null,6,28,137,3836]
[]
[null,"Total",null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(M5:M10)","v":162},null,{"$f":"SUM(O5:O10)","v":21530}]