{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Dataset","Absolute Cell Reference","Adopting Find & Replace","Formula without Switching","Paste Special Option","Formula without Dragging","VBA","Copy and result as text"],"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":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null," Copying Formula Down Without Incrementing in Excel"]
[]
[null,"Name","Quantity","Variable Cost","Total Cost",null,"Fixed Cost"]
[null,"Whiskey ",100,30,{"$f":"C5*(G5+D5)","v":7000},null,40]
[null,"Champagne",112,20]
[null,"Wine",130,21]
[null,"Brandi",125,12]
[null,"Vodka",90,23]
[null,"Taquila",87,43]
[null,"Total"]

{"sheet":"Absolute Cell Reference","index":1,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Absolute Cell Reference Feature"]
[]
[null,"Name","Quantity","Variable Cost","Total Cost",null,"Fixed Cost"]
[null,"Whiskey ",100,30,{"$f":"C5*($G$5+D5)","v":7000},null,40]
[null,"Champagne",112,20,{"$f":"C6*($G$5+D6)","v":6720}]
[null,"Wine",130,21,7930]
[null,"Brandi",125,12,6500]
[null,"Vodka",90,23,5670]
[null,"Taquila",87,43,7221]
[null,"Total"]

{"sheet":"Adopting Find & Replace","index":2,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Adopting Find and Replace Option"]
[]
[null,"Name","Quantity","Variable Cost","Total Cost","Total Cost","Fixed Cost"]
[null,"Whiskey ",100,30,{"$f":"C5*($G$5+D5)","v":7000},{"$f":"C5*($G$5+D5)","v":7000},40]
[null,"Champagne",112,20,6720,6720]
[null,"Wine",130,21,7930,7930]
[null,"Brandi",125,12,6500,6500]
[null,"Vodka",90,23,5670,5670]
[null,"Taquila",87,43,7221,7221]
[null,"Total"]

{"sheet":"Formula without Switching","index":3,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Copying Formula Without Changing Reference"]
[]
[null,"Name","Quantity","Variable Cost","Total Cost","Total Price","Fixed Cost"]
[null,"Whiskey ",100,30,{"$f":"C5*($G$5+D5)","v":7000},{"$f":"C5*($G$5+D5)","v":7000},40]
[null,"Champagne",112,20,{"$f":"C6*($G$5+D6)","v":6720},6720]
[null,"Wine",130,21,7930,7930]
[null,"Brandi",125,12,6500,6500]
[null,"Vodka",90,23,5670,5670]
[null,"Taquila",87,43,7221,7221]
[null,"Total"]

{"sheet":"Paste Special Option","index":4,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Using Paste Special Option"]
[]
[null,"Name","Quantity","Variable Cost","Total Cost",null,"Fixed Cost"]
[null,"Whiskey ",100,30,{"$f":"C5*($G$5+D5)","v":7000},null,40]
[null,"Champagne",112,20,{"$f":"C6*($G$5+D6)","v":6720}]
[null,"Wine",130,21,7930]
[null,"Brandi",125,12,6500]
[null,"Vodka",90,23,5670]
[null,"Taquila",87,43,7221]
[null,"Total"]

{"sheet":"Formula without Dragging","index":5,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Excel Formula Without Dragging"]
[]
[null,"Name","Quantity","Variable Cost","Total Cost",null,"Fixed Cost"]
[null,"Whiskey ",100,30,{"$f":"C5*($G$5+D5)","v":7000},null,40]
[null,"Champagne",112,20,6720]
[null,"Wine",130,21,7930]
[null,"Brandi",125,12,6500]
[null,"Vodka",90,23,5670]
[null,"Taquila",87,43,7221]
[null,"Total"]

{"sheet":"VBA","index":6,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Copying Formula using VBA"]
[]
[null,"Name","Quantity","Variable Cost","Total Cost",null,"Fixed Cost"]
[null,"Whiskey ",100,30,7000,null,40,7000]
[null,"Champagne",112,20,{"$f":"C6*($G$5+D6)","v":6720},null,null,{"$f":"C6*($G$5+D6)","v":6720}]
[null,"Wine",130,21,7930,null,null,{"$f":"C7*($G$5+D7)","v":7930}]
[null,"Brandi",125,12,6500,null,null,{"$f":"C8*($G$5+D8)","v":6500}]
[null,"Vodka",90,23,5670,null,null,{"$f":"C9*($G$5+D9)","v":5670}]
[null,"Taquila",87,43,7221,null,null,{"$f":"C10*($G$5+D10)","v":7221}]
[null,"Total"]

{"sheet":"Copy and result as text","index":7,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Copying Formula and Result in Text"]
[]
[null,"Name","Quantity","Variable Cost","Total Cost",null,"Fixed Cost"]
[null,"Whiskey ",100,30,7000,null,40]
[null,"Champagne",112,20,{"$f":"C6*($G$5+D6)","v":6720}]
[null,"Wine",130,21,7930]
[null,"Brandi",125,12,6500]
[null,"Vodka",90,23,5670]
[null,"Taquila",87,43,7221]
[null,"Total"]