{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Datasheet","Method 1","Method 2","Method 3","Method 4","Method 5","Method 6"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Product Order Sheet"]
[]
[null,"Product","Order","Unit Cost","Total Cost"]
[null,"Radio",1,50,{"$f":"D6*C6","v":50}]
[null,"Television",1,150,{"$f":"D7*C7","v":150}]
[null,"Mobile",2,100,200]
[null,"Light Bulb",2,20,40]
[null,"Chair",3,50,150]
[null,"Bed",3,80,240]

{"sheet":"Method 1","index":1,"n_rows":18,"n_cols":13,"rows_kept":18,"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",1,50,{"$f":"D6*C6","v":50}]
[null,"Television",1,150,{"$f":"D7*C7","v":150}]
[null,"Mobile",2,100,200,null,null,null,null,"Practice  Sheet"]
[null,"Light Bulb",2,20,40]
[null,"Chair",3,50,150,null,null,null,null,"Product","Order","Unit Cost","Total Cost"]
[null,"Bed",3,80,240,null,null,null,null,"Radio",1,50,{"$f":"L11*K11","v":50}]
[null,null,null,null,null,null,null,null,null,"Television",1,150,{"$f":"L12*K12","v":150}]
[null,"Last Column Data",{"$f":"LOOKUP(2,1/(E:E<>\"\"),E:E)","v":240},null,null,null,null,null,null,"Mobile",2,100,200]
[null,null,null,null,null,null,null,null,null,"Light Bulb",2,20,40]
[null,null,null,null,null,null,null,null,null,"Chair",3,50,150]
[null,null,null,null,null,null,null,null,null,"Bed",3,80,240]
[]
[null,null,null,null,null,null,null,null,null,"Last Column Data"]

{"sheet":"Method 2","index":2,"n_rows":18,"n_cols":13,"rows_kept":18,"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",1,50,{"$f":"D6*C6","v":50}]
[null,"Television",1,150,{"$f":"D7*C7","v":150}]
[null,"Mobile",2,100,200,null,null,null,null,"Practice  Sheet"]
[null,"Light Bulb",2,20,40]
[null,"Chair",3,50,150,null,null,null,null,"Product","Order","Unit Cost","Total Cost"]
[null,"Bed",3,80,240,null,null,null,null,"Radio",1,50,{"$f":"L11*K11","v":50}]
[null,null,null,null,null,null,null,null,null,"Television",1,150,{"$f":"L12*K12","v":150}]
[null,"Last Column Data",{"$f":"INDEX(E6:E11,COUNT(E6:E11))","v":240},null,null,null,null,null,null,"Mobile",2,100,200]
[null,null,null,null,null,null,null,null,null,"Light Bulb",2,20,40]
[null,null,null,null,null,null,null,null,null,"Chair",3,50,150]
[null,null,null,null,null,null,null,null,null,"Bed",3,80,240]
[]
[null,null,null,null,null,null,null,null,null,"Last Column Data"]

{"sheet":"Method 3","index":3,"n_rows":19,"n_cols":13,"rows_kept":19,"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",1,50,{"$f":"D6*C6","v":50}]
[null,"Television",1,150,{"$f":"D7*C7","v":150}]
[null,"Mobile",2,100,200,null,null,null,null,"Practice  Sheet"]
[null,"Light Bulb",2,20,40]
[null,"Chair",3,50,150,null,null,null,null,"Product","Order","Unit Cost","Total Cost"]
[null,"Bed",3,80,240,null,null,null,null,"Radio",1,50,{"$f":"L11*K11","v":50}]
[null,null,null,null,null,null,null,null,null,"Television",1,150,{"$f":"L12*K12","v":150}]
[null,"Last Column ",{"$f":"MIN(COLUMN(B6:E11))+COLUMNS(B6:E11)-2","v":4},null,null,null,null,null,null,"Mobile",2,100,200]
[null,"Last Column Data",{"$f":"INDEX(B6:E11,6,C13)","v":240},null,null,null,null,null,null,"Light Bulb",2,20,40]
[null,null,null,null,null,null,null,null,null,"Chair",3,50,150]
[null,null,null,null,null,null,null,null,null,"Bed",3,80,240]
[]
[null,null,null,null,null,null,null,null,null,"Last Column "]
[null,null,null,null,null,null,null,null,null,"Last Column Data"]

{"sheet":"Method 4","index":4,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Product Order Sheet"]
[]
[null,"Product","Order","Unit Cost","Total Cost"]
[null,"Radio",1,50,{"$f":"D6*C6","v":50}]
[null,"Television",1,150,{"$f":"D7*C7","v":150}]
[null,"Mobile",2,100,200]
[null,"Light Bulb",2,20,40]
[null,"Chair",3,50,150]
[null,"Bed",3,80,240]

{"sheet":"Method 5","index":5,"n_rows":16,"n_cols":13,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,1,2,4],[7,9,7,12]]}
[]
[]
[null,"Find Last Row with Data"]
[]
[null,"Product","Order","Unit Cost","Total Cost"]
[null,"Radio",1,50,{"$f":"D6*C6","v":50}]
[null,"Television",1,150,{"$f":"D7*C7","v":150}]
[null,"Mobile",2,100,200,null,null,null,null,"Practice  Sheet"]
[null,"Light Bulb",2,20,40]
[null,"Chair",3,50,150,null,null,null,null,"Product","Order","Unit Cost","Total Cost"]
[null,"Bed",3,80,240,null,null,null,null,"Radio",1,50,{"$f":"L11*K11","v":50}]
[null,null,null,null,null,null,null,null,null,"Television",1,150,{"$f":"L12*K12","v":150}]
[null,"Last Row",{"$f":"MAX((B5:E11<>\"\")*(ROW(B5:E11)))","v":11},null,null,null,null,null,null,"Mobile",2,100,200]
[null,null,null,null,null,null,null,null,null,"Light Bulb",2,20,40]
[null,null,null,null,null,null,null,null,null,"Chair",3,50,150]
[null,null,null,null,null,null,null,null,null,"Bed",3,80,240]

{"sheet":"Method 6","index":6,"n_rows":16,"n_cols":12,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,1,2,4],[7,8,7,11]]}
[]
[]
[null,"Find Last Cell with Data"]
[]
[null,"Product","Order","Unit Cost","Total Cost"]
[null,"Radio",1,50,{"$f":"D6*C6","v":50}]
[null,"Television",1,150,{"$f":"D7*C7","v":150}]
[null,"Mobile",2,100,200,null,null,null,"Practice Sheet"]
[null,"Light Bulb",2,20,40]
[null,"Chair",3,50,150,null,null,null,"Product","Order","Unit Cost","Total Cost"]
[null,"Bed",3,80,240,null,null,null,"Radio",1,50,{"$f":"K11*J11","v":50}]
[null,null,null,null,null,null,null,null,"Television",1,150,{"$f":"K12*J12","v":150}]
[null,null,null,null,null,null,null,null,"Mobile",2,100,200]
[null,null,null,null,null,null,null,null,"Light Bulb",2,20,40]
[null,null,null,null,null,null,null,null,"Chair",3,50,150]
[null,null,null,null,null,null,null,null,"Bed",3,80,240]