{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Datasheet","Fill Handle","copy paste","keyboard shortcut"," paste special","Fixed cell reference","without formatting","VBA","keyboard"," paste special (2)","Fill Handle (2)","after text"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":"Datasheet","index":0,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Product Order Sheet"]
[]
[null,"Product","Order","Unit Cost($)"]
[null,"Radio",1000,50]
[null,"Television",2000,150]
[null,"Mobile",3000,100]
[null,"Light Bulb",800,20]
[null,"Chair",2000,50]
[null,"Bed",5000,80]

{"sheet":"Fill Handle","index":1,"n_rows":16,"n_cols":13,"rows_kept":16,"cut":false,"hidden":false,"merged":[[7,9,7,12],[2,1,2,4]]}
[]
[]
[null,"Product Order Sheet"]
[]
[null,"Product","Order","Unit Cost($)","Total Cost($)"]
[null,"Radio",1000,50,{"$f":"D6*C6","v":50000}]
[null,"Television",2000,150,300000]
[null,"Mobile",3000,100,300000,null,null,null,null,"Practice  Sheet"]
[null,"Light Bulb",800,20,16000]
[null,"Chair",2000,50,100000,null,null,null,null,"Product","Order","Unit Cost","Total Cost"]
[null,"Bed",5000,80,400000,null,null,null,null,"Radio",1000,50]
[null,null,null,null,null,null,null,null,null,"Television",2000,150]
[null,null,null,null,null,null,null,null,null,"Mobile",3000,100]
[null,null,null,null,null,null,null,null,null,"Light Bulb",800,20]
[null,null,null,null,null,null,null,null,null,"Chair",2000,50]
[null,null,null,null,null,null,null,null,null,"Bed",5000,80]

{"sheet":"copy paste","index":2,"n_rows":16,"n_cols":13,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,1,2,4],[7,9,7,12]]}
[]
[]
[null,"Product Order Sheet"]
[]
[null,"Product","Order","Unit Cost($)","Total Cost($)"]
[null,"Radio",1000,50,{"$f":"D6*C6","v":50000}]
[null,"Television",2000,150,300000]
[null,"Mobile",3000,100,300000,null,null,null,null,"Practice  Sheet"]
[null,"Light Bulb",800,20,16000]
[null,"Chair",2000,50,100000,null,null,null,null,"Product","Order","Unit Cost","Total Cost"]
[null,"Bed",5000,80,400000,null,null,null,null,"Radio",1000,50]
[null,null,null,null,null,null,null,null,null,"Television",2000,150]
[null,null,null,null,null,null,null,null,null,"Mobile",3000,100]
[null,null,null,null,null,null,null,null,null,"Light Bulb",800,20]
[null,null,null,null,null,null,null,null,null,"Chair",2000,50]
[null,null,null,null,null,null,null,null,null,"Bed",5000,80]

{"sheet":"keyboard shortcut","index":3,"n_rows":16,"n_cols":13,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,1,2,4],[7,9,7,12]]}
[]
[]
[null,"Product Order Sheet"]
[]
[null,"Product","Order","Unit Cost($)","Total Cost($)"]
[null,"Radio",1000,50,{"$f":"D6*C6","v":50000}]
[null,"Television",2000,150,300000]
[null,"Mobile",3000,100,300000,null,null,null,null,"Practice  Sheet"]
[null,"Light Bulb",800,20,16000]
[null,"Chair",2000,50,100000,null,null,null,null,"Product","Order","Unit Cost","Total Cost"]
[null,"Bed",5000,80,400000,null,null,null,null,"Radio",1000,50]
[null,null,null,null,null,null,null,null,null,"Television",2000,150]
[null,null,null,null,null,null,null,null,null,"Mobile",3000,100]
[null,null,null,null,null,null,null,null,null,"Light Bulb",800,20]
[null,null,null,null,null,null,null,null,null,"Chair",2000,50]
[null,null,null,null,null,null,null,null,null,"Bed",5000,80]

{"sheet":" paste special","index":4,"n_rows":16,"n_cols":13,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,1,2,4],[7,9,7,12]]}
[]
[]
[null,"Product Order Sheet"]
[]
[null,"Product","Order","Unit Cost($)","Total Cost($)"]
[null,"Radio",1000,50,{"$f":"D6*C6","v":50000}]
[null,"Television",2000,150,300000]
[null,"Mobile",3000,100,300000,null,null,null,null,"Practice  Sheet"]
[null,"Light Bulb",800,20,16000]
[null,"Chair",2000,50,100000,null,null,null,null,"Product","Order","Unit Cost","Total Cost"]
[null,"Bed",5000,80,400000,null,null,null,null,"Radio",1000,50]
[null,null,null,null,null,null,null,null,null,"Television",2000,150]
[null,null,null,null,null,null,null,null,null,"Mobile",3000,100]
[null,null,null,null,null,null,null,null,null,"Light Bulb",800,20]
[null,null,null,null,null,null,null,null,null,"Chair",2000,50]
[null,null,null,null,null,null,null,null,null,"Bed",5000,80]

{"sheet":"Fixed cell reference","index":5,"n_rows":13,"n_cols":14,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,5],[2,9,2,13]]}
[]
[]
[null,"Product Order Sheet",null,null,null,null,null,null,null,"Practice Sheet"]
[]
[null,"Product","Order","Unit Cost($)","Previous Total Cost($)","Present Total Cost($)",null,null,null,"Product","Order","Unit Cost($)","Previous Total Cost($)","Present Total Cost($)"]
[null,"Radio",1000,50,{"$f":"D6*C6","v":50000},{"$f":"C6*(D6+$C$13*D6)","v":52500},null,null,null,"Radio",1000,50,{"$f":"L6*K6","v":50000}]
[null,"Television",2000,150,300000,{"$f":"C7*(D7+$C$13*D7)","v":315000},null,null,null,"Television",2000,150,300000]
[null,"Mobile",3000,100,300000,315000,null,null,null,"Mobile",3000,100,300000]
[null,"Light Bulb",800,20,16000,16800,null,null,null,"Light Bulb",800,20,16000]
[null,"Chair",2000,50,100000,105000,null,null,null,"Chair",2000,50,100000]
[null,"Bed",5000,80,400000,420000,null,null,null,"Bed",5000,80,400000]
[]
[null,"Cost Increase",0.05,null,null,null,null,null,null,"Cost Increase",0.05]

{"sheet":"without formatting","index":6,"n_rows":16,"n_cols":13,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,1,2,4],[7,9,7,12]]}
[]
[]
[null,"Product Order Sheet"]
[]
[null,"Product","Order","Unit Cost($)","Total Cost($)"]
[null,"Radio",1000,50,{"$f":"D6*C6","v":50000}]
[null,"Television",2000,150,{"$f":"D7*C7","v":300000}]
[null,"Mobile",3000,100,300000,null,null,null,null,"Practice  Sheet"]
[null,"Light Bulb",800,20,16000]
[null,"Chair",2000,50,100000,null,null,null,null,"Product","Order","Unit Cost","Total Cost"]
[null,"Bed",5000,80,400000,null,null,null,null,"Radio",1000,50,{"$f":"K11*L11","v":50000}]
[null,null,null,null,null,null,null,null,null,"Television",2000,150]
[null,null,null,null,null,null,null,null,null,"Mobile",3000,100]
[null,null,null,null,null,null,null,null,null,"Light Bulb",800,20]
[null,null,null,null,null,null,null,null,null,"Chair",2000,50]
[null,null,null,null,null,null,null,null,null,"Bed",5000,80]

{"sheet":"VBA","index":7,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,4],[2,7,2,10]]}
[]
[]
[null,"Product Order Sheet",null,null,null,null,null,"Practice Sheet"]
[]
[null,"Product","Order","Demand (1st Quarter)","Demand (2nd Quarter)",null,null,"Product","Order","Demand (1st Quarter)","Demand (2nd Quarter)"]
[null,"Radio",1000,{"$f":"C6+500","v":1500},2000,null,null,"Radio",1000,1500]
[null,"Television",2000,2500,3000,null,null,"Television",2000,2500]
[null,"Mobile",3000,3500,4000,null,null,"Mobile",3000,3500]
[null,"Light Bulb",800,1300,1800,null,null,"Light Bulb",800,1300]
[null,"Chair",2000,2500,3000,null,null,"Chair",2000,2500]
[null,"Bed",5000,5500,6000,null,null,"Bed",5000,5500]

{"sheet":"keyboard","index":8,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,4],[2,7,2,10]]}
[]
[]
[null,"Product Order Sheet",null,null,null,null,null,"Practice Sheet"]
[]
[null,"Product","Order","Demand (1st Quarter)","Demand (2nd Quarter)",null,null,"Product","Order","Demand (1st Quarter)","Demand (2nd Quarter)"]
[null,"Radio",1000,{"$f":"C6+500","v":1500},{"$f":"D6+500","v":2000},null,null,"Radio",1000]
[null,"Television",2000,{"$f":"C7+500","v":2500},3000,null,null,"Television",2000]
[null,"Mobile",3000,3500,4000,null,null,"Mobile",3000]
[null,"Light Bulb",800,1300,1800,null,null,"Light Bulb",800]
[null,"Chair",2000,2500,3000,null,null,"Chair",2000]
[null,"Bed",5000,5500,6000,null,null,"Bed",5000]

{"sheet":" paste special (2)","index":9,"n_rows":16,"n_cols":13,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,1,2,4],[7,9,7,12]]}
[]
[]
[null,"Copy Fomulas of Entire Column from One Sheet to Another"]
[]
[null,"Product","Order","Unit Cost($)","Total Cost($)"]
[null,"Radio",50000,50,{"$f":"D6*C6","v":2500000}]
[null,"Television",2000,150,300000]
[null,"Mobile",3000,100,300000,null,null,null,null,"Practice  Sheet"]
[null,"Light Bulb",800,20,16000]
[null,"Chair",2000,50,100000,null,null,null,null,"Product","Order","Unit Cost","Total Cost"]
[null,"Bed",5000,80,400000,null,null,null,null,"Radio",1000,50]
[null,null,null,null,null,null,null,null,null,"Television",2000,150]
[null,null,null,null,null,null,null,null,null,"Mobile",3000,100]
[null,null,null,null,null,null,null,null,null,"Light Bulb",800,20]
[null,null,null,null,null,null,null,null,null,"Chair",2000,50]
[null,null,null,null,null,null,null,null,null,"Bed",5000,80]

{"sheet":"Fill Handle (2)","index":10,"n_rows":16,"n_cols":13,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,1,2,4],[7,9,7,12]]}
[]
[]
[null,"Product Order Sheet"]
[]
[null,"Product","Order","Unit Cost($)","Total Cost($)"]
[null,"Radio",1000,50,{"$f":"D6*C6","v":50000}]
[null,"Television",2000,150,300000]
[null,"Mobile",3000,100,300000,null,null,null,null,"Practice  Sheet"]
[null,"Light Bulb",800,20,16000]
[null,"Chair",2000,50,100000,null,null,null,null,"Product","Order","Unit Cost","Total Cost"]
[null,"Bed",5000,80,400000,null,null,null,null,"Radio",1000,50]
[null,null,null,null,null,null,null,null,null,"Television",2000,150]
[null,null,null,null,null,null,null,null,null,"Mobile",3000,100]
[null,null,null,null,null,null,null,null,null,"Light Bulb",800,20]
[null,null,null,null,null,null,null,null,null,"Chair",2000,50]
[null,null,null,null,null,null,null,null,null,"Bed",5000,80]

{"sheet":"after text","index":11,"n_rows":13,"n_cols":9,"rows_kept":13,"cut":false,"hidden":true,"merged":[[2,1,2,3],[4,6,4,8]]}
[]
[]
[null,"Add Comma Between Names"]
[]
[null,"Product","Seller Names","Names with Comma",null,null,"Practice Sheet"]
[null,"Radio","Robin David",{"$f":"SUBSTITUTE(C6,\" \",\",\")","v":"Robin,David"}]
[null,"Television","Luke Liam","Luke,Liam",null,null,"Product","Seller Names","Names with Comma"]
[null,"Mobile","John Lewis ","John,Lewis,",null,null,"Radio","Robin David"]
[null,"Light Bulb","Nick Joseph","Nick,Joseph",null,null,"Television","Luke Liam"]
[null,"Chair","Hugo Oliver","Hugo,Oliver",null,null,"Mobile","John Lewis "]
[null,"Bed","Jessica Rebecca","Jessica,Rebecca",null,null,"Light Bulb","Nick Joseph"]
[null,null,null,null,null,null,"Chair","Hugo Oliver"]
[null,null,null,null,null,null,"Bed","Jessica Rebecca"]