{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Datasheet","Mid function","Left+Mid+len","Left+right+len","text function","Format cells","VBA","fixed function","Substitute function","curreny format (after 3 digits)"],"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",10000,150,{"$f":"D6*C6","v":1500000}]
[null,"Television",20000,150,{"$f":"D7*C7","v":3000000}]
[null,"Mobile",30000,100,3000000]
[null,"Light Bulb",38000,30,1140000]
[null,"Chair",20000,50,1000000]
[null,"Bed",50000,80,4000000]

{"sheet":"Mid function","index":1,"n_rows":15,"n_cols":13,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,5],[6,8,6,12]]}
[]
[]
[null,"Product Order Sheet"]
[]
[null,"Product","Order","Unit Cost($)","Total Cost($)","Formatted Total Cost($)"]
[null,"Radio",10000,150,{"$f":"D6*C6","v":1500000},{"$f":"MID(E6,1,5)&\",\"&MID(E6,6,5)","v":"15000,00"}]
[null,"Television",20000,150,{"$f":"D7*C7","v":3000000},{"$f":"MID(E7,1,5)&\",\"&MID(E7,6,5)","v":"30000,00"},null,null,"Practice Sheet"]
[null,"Mobile",30000,100,3000000,"30000,00"]
[null,"Light Bulb",38000,30,1140000,"11400,00",null,null,"Product","Order","Unit Cost($)","Total Cost($)","Formatted Total Cost($)"]
[null,"Chair",20000,50,1000000,"10000,00",null,null,"Radio",1000,150,{"$f":"K10*J10","v":150000}]
[null,"Bed",50000,80,4000000,"40000,00",null,null,"Television",2000,150,{"$f":"K11*J11","v":300000}]
[null,null,null,null,null,null,null,null,"Mobile",3000,100,300000]
[null,null,null,null,null,null,null,null,"Light Bulb",3800,30,114000]
[null,null,null,null,null,null,null,null,"Chair",2000,50,100000]
[null,null,null,null,null,null,null,null,"Bed",5000,80,400000]

{"sheet":"Left+Mid+len","index":2,"n_rows":11,"n_cols":13,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,5],[2,8,2,12]]}
[]
[]
[null,"Product Order Sheet",null,null,null,null,null,null,"Practice Sheet"]
[]
[null,"Product","Order","Unit Cost($)","Total Cost($)","Formatted Total Cost($)",null,null,"Product","Order","Unit Cost($)","Total Cost($)","Formatted Total Cost($)"]
[null,"Radio",10000,150,{"$f":"D6*C6","v":1500000},{"$f":"LEFT(E6,5)&\",\"&MID(E6,6,LEN(E6)-5)","v":"15000,00"},null,null,"Radio",10000,150,{"$f":"K6*J6","v":1500000}]
[null,"Television",20000,150,{"$f":"D7*C7","v":3000000},{"$f":"LEFT(E7,5)&\",\"&MID(E7,6,LEN(E7)-5)","v":"30000,00"},null,null,"Television",20000,150,{"$f":"K7*J7","v":3000000}]
[null,"Mobile",30000,100,3000000,"30000,00",null,null,"Mobile",30000,100,3000000]
[null,"Light Bulb",38000,30,1140000,"11400,00",null,null,"Light Bulb",38000,30,1140000]
[null,"Chair",20000,50,1000000,"10000,00",null,null,"Chair",20000,50,1000000]
[null,"Bed",50000,80,4000000,"40000,00",null,null,"Bed",50000,80,4000000]

{"sheet":"Left+right+len","index":3,"n_rows":11,"n_cols":13,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,5],[2,8,2,12]]}
[]
[]
[null,"Product Order Sheet",null,null,null,null,null,null,"Practice Sheet"]
[]
[null,"Product","Order","Unit Cost($)","Total Cost($)","Formatted Total Cost($)",null,null,"Product","Order","Unit Cost($)","Total Cost($)","Formatted Total Cost($)"]
[null,"Radio",10000,150,{"$f":"D6*C6","v":1500000},{"$f":"LEFT(E6,5)&\",\"&RIGHT(E6,LEN(E6)-5)","v":"15000,00"},null,null,"Radio",10000,150,{"$f":"K6*J6","v":1500000}]
[null,"Television",20000,150,{"$f":"D7*C7","v":3000000},{"$f":"LEFT(E7,5)&\",\"&RIGHT(E7,LEN(E7)-5)","v":"30000,00"},null,null,"Television",20000,150,{"$f":"K7*J7","v":3000000}]
[null,"Mobile",30000,100,3000000,"30000,00",null,null,"Mobile",30000,100,3000000]
[null,"Light Bulb",38000,30,1140000,"11400,00",null,null,"Light Bulb",38000,30,1140000]
[null,"Chair",20000,50,1000000,"10000,00",null,null,"Chair",20000,50,1000000]
[null,"Bed",50000,80,4000000,"40000,00",null,null,"Bed",50000,80,4000000]

{"sheet":"text function","index":4,"n_rows":11,"n_cols":13,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,5],[2,8,2,12]]}
[]
[]
[null,"Product Order Sheet",null,null,null,null,null,null,"Practice Sheet"]
[]
[null,"Product","Order","Unit Cost($)","Total Cost($)","Formatted Total Cost($)",null,null,"Product","Order","Unit Cost($)","Total Cost($)","Formatted Total Cost($)"]
[null,"Radio",10000,150,{"$f":"D6*C6","v":1500000},{"$f":"TEXT(E6,\"00000\"\",\"\"00\")","v":"15000,00"},null,null,"Radio",10000,150,{"$f":"K6*J6","v":1500000}]
[null,"Television",20000,150,{"$f":"D7*C7","v":3000000},{"$f":"TEXT(E7,\"00000\"\",\"\"00\")","v":"30000,00"},null,null,"Television",20000,150,{"$f":"K7*J7","v":3000000}]
[null,"Mobile",30000,100,3000000,"30000,00",null,null,"Mobile",30000,100,3000000]
[null,"Light Bulb",38000,30,1140000,"11400,00",null,null,"Light Bulb",38000,30,1140000]
[null,"Chair",20000,50,1000000,"10000,00",null,null,"Chair",20000,50,1000000]
[null,"Bed",50000,80,4000000,"40000,00",null,null,"Bed",50000,80,4000000]

{"sheet":"Format cells","index":5,"n_rows":11,"n_cols":13,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,5],[2,8,2,12]]}
[]
[]
[null,"Product Order Sheet",null,null,null,null,null,null,"Practice Sheet"]
[]
[null,"Product","Order","Unit Cost($)","Total Cost($)","Formatted Total Cost($)",null,null,"Product","Order","Unit Cost($)","Total Cost($)","Formatted Total Cost($)"]
[null,"Radio",10000,150,{"$f":"D6*C6","v":1500000},1500000,null,null,"Radio",10000,150,{"$f":"K6*J6","v":1500000}]
[null,"Television",20000,150,{"$f":"D7*C7","v":3000000},3000000,null,null,"Television",20000,150,{"$f":"K7*J7","v":3000000}]
[null,"Mobile",30000,100,3000000,3000000,null,null,"Mobile",30000,100,3000000]
[null,"Light Bulb",38000,30,1140000,1140000,null,null,"Light Bulb",38000,30,1140000]
[null,"Chair",20000,50,1000000,1000000,null,null,"Chair",20000,50,1000000]
[null,"Bed",50000,80,4000000,4000000,null,null,"Bed",50000,80,4000000]

{"sheet":"VBA","index":6,"n_rows":15,"n_cols":13,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,5],[6,8,6,12]]}
[]
[]
[null,"Product Order Sheet"]
[]
[null,"Product","Order","Unit Cost($)","Total Cost($)","Formatted Total Cost($)"]
[null,"Radio",10000,150,{"$f":"D6*C6","v":1500000},{"$f":"TEXT(E6,\"00000\"\",\"\"00\")","v":"15000,00"}]
[null,"Television",20000,150,{"$f":"D7*C7","v":3000000},{"$f":"TEXT(E7,\"00000\"\",\"\"00\")","v":"30000,00"},null,null,"Practice Sheet"]
[null,"Mobile",30000,100,3000000,"30000,00"]
[null,"Light Bulb",38000,30,1140000,"11400,00",null,null,"Product","Order","Unit Cost($)","Total Cost($)","Formatted Total Cost($)"]
[null,"Chair",20000,50,1000000,"10000,00",null,null,"Radio",1000,150,{"$f":"K10*J10","v":150000}]
[null,"Bed",50000,80,4000000,"40000,00",null,null,"Television",2000,150,{"$f":"K11*J11","v":300000}]
[null,null,null,null,null,null,null,null,"Mobile",3000,100,300000]
[null,null,null,null,null,null,null,null,"Light Bulb",3800,30,114000]
[null,null,null,null,null,null,null,null,"Chair",2000,50,100000]
[null,null,null,null,null,null,null,null,"Bed",5000,80,400000]

{"sheet":"fixed function","index":7,"n_rows":16,"n_cols":14,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,1,2,5],[7,9,7,13]]}
[]
[]
[null,"Add Comma in Numbers "]
[]
[null,"Product","Order","Unit Cost($)","Total Cost($)","Formatted Total Cost($)"]
[null,"Radio",1000,50,{"$f":"D6*C6","v":50000},{"$f":"FIXED(E6,0)","v":"50,000"}]
[null,"Television",2000,150,{"$f":"D7*C7","v":300000},{"$f":"FIXED(E7,0)","v":"300,000"}]
[null,"Mobile",3000,100,300000,"300,000",null,null,null,"Practice Sheet"]
[null,"Light Bulb",800,20,16000,"16,000"]
[null,"Chair",2000,50,100000,"100,000",null,null,null,"Product","Order","Unit Cost($)","Total Cost($)","Formatted Total Cost($)"]
[null,"Bed",5000,80,400000,"400,000",null,null,null,"Radio",1000,50,{"$f":"L11*K11","v":50000}]
[null,"Total",null,null,{"$f":"SUBTOTAL(109,'Mid function'!$E$6:$E$11)","v":13640000},"13,640,000",null,null,null,"Television",2000,150,{"$f":"L12*K12","v":300000}]
[null,null,null,null,null,null,null,null,null,"Mobile",3000,100,300000]
[null,null,null,null,null,null,null,null,null,"Light Bulb",800,20,16000]
[null,null,null,null,null,null,null,null,null,"Chair",2000,50,100000]
[null,null,null,null,null,null,null,null,null,"Bed",5000,80,400000]

{"sheet":"Substitute function","index":8,"n_rows":13,"n_cols":9,"rows_kept":13,"cut":false,"hidden":false,"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","Rick Shawn",{"$f":"SUBSTITUTE(C6,\" \",\",\")","v":"Rick,Shawn"}]
[null,"Television","Luke Ricky","Luke,Ricky",null,null,"Product","Seller Names","Names with Comma"]
[null,"Mobile","John Neville ","John,Neville,",null,null,"Radio","Rick Shawn"]
[null,"Light Bulb","Nicholas Joseph","Nicholas,Joseph",null,null,"Television","Luke Ricky"]
[null,"Chair","Hazel Oliver","Hazel,Oliver",null,null,"Mobile","John Neville "]
[null,"Bed","Julia Rebecca","Julia,Rebecca",null,null,"Light Bulb","Nicholas Joseph"]
[null,null,null,null,null,null,"Chair","Hazel Oliver"]
[null,null,null,null,null,null,"Bed","Julia Rebecca"]

{"sheet":"curreny format (after 3 digits)","index":9,"n_rows":15,"n_cols":13,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,5],[6,8,6,12]]}
[]
[]
[null,"Put Comma After 3 Digits"]
[]
[null,"Product","Order","Unit Cost($)","Total Cost($)","Formatted Total Cost($)"]
[null,"Radio",10000,150,{"$f":"D6*C6","v":1500000},1500000]
[null,"Television",20000,150,{"$f":"D7*C7","v":3000000},3000000,null,null,"Practice Sheet"]
[null,"Mobile",30000,100,3000000,3000000]
[null,"Light Bulb",38000,30,1140000,1140000,null,null,"Product","Order","Unit Cost($)","Total Cost($)","Formatted Total Cost($)"]
[null,"Chair",20000,50,1000000,1000000,null,null,"Radio",1000,150,{"$f":"K10*J10","v":150000}]
[null,"Bed",50000,80,4000000,4000000,null,null,"Television",2000,150,{"$f":"K11*J11","v":300000}]
[null,null,null,null,null,null,null,null,"Mobile",3000,100,300000]
[null,null,null,null,null,null,null,null,"Light Bulb",3800,30,114000]
[null,null,null,null,null,null,null,null,"Chair",2000,50,100000]
[null,null,null,null,null,null,null,null,"Bed",5000,80,400000]