{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Datasheet","subtotal","sumif","sumifs","VBA","cell color","count colored cell"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"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":"subtotal","index":1,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,4],[12,1,12,3],[13,1,13,3],[14,1,14,3]]}
[]
[]
[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]
[]
[null,"Colored ltem Cost",null,null,{"$f":"SUBTOTAL(9,E6:E11)","v":430}]
[null,"Total Cost",null,null,830]
[null,"Percentage",null,null,{"$f":"E13/E14","v":0.51807228915662651}]

{"sheet":"sumif","index":2,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[12,1,12,4],[13,1,13,4],[14,1,14,4],[2,1,2,5]]}
[]
[]
[null,"Product Order Sheet"]
[]
[null,"Product","Order","Unit Cost","Total Cost","Color Code"]
[null,"Radio",1,50,{"$f":"D6*C6","v":50},{"$f":"Colorcode","v":{"$error":"#NAME?"}}]
[null,"Television",1,150,{"$f":"D7*C7","v":150},{"$f":"Colorcode","v":{"$error":"#NAME?"}}]
[null,"Mobile",2,100,200,{"$f":"Colorcode","v":{"$error":"#NAME?"}}]
[null,"Light Bulb",2,20,40,{"$f":"Colorcode","v":{"$error":"#NAME?"}}]
[null,"Chair",3,50,150,{"$f":"Colorcode","v":{"$error":"#NAME?"}}]
[null,"Bed",3,80,240,{"$f":"Colorcode","v":{"$error":"#NAME?"}}]
[]
[null,"Colored ltem Cost",null,null,null,{"$f":"SUMIF(F6:F11,F7,E6:E11)","v":830}]
[null,"Total Cost",null,null,null,{"$f":"SUM(E6:E11)","v":830}]
[null,"Percentage",null,null,null,{"$f":"F13/F14","v":1}]

{"sheet":"sumifs","index":3,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[14,1,14,4],[2,1,2,5],[12,1,12,4],[13,1,13,4]]}
[]
[]
[null,"Product Order Sheet"]
[]
[null,"Product","Order","Unit Cost","Total Cost","Color Code"]
[null,"Radio",1,50,{"$f":"D6*C6","v":50},{"$f":"Colorcode","v":{"$error":"#NAME?"}}]
[null,"Television",1,150,{"$f":"D7*C7","v":150},{"$f":"Colorcode","v":{"$error":"#NAME?"}}]
[null,"Mobile",2,100,200,{"$f":"Colorcode","v":{"$error":"#NAME?"}}]
[null,"Light Bulb",2,20,40,{"$f":"Colorcode","v":{"$error":"#NAME?"}}]
[null,"Chair",3,50,150,{"$f":"Colorcode","v":{"$error":"#NAME?"}}]
[null,"Bed",3,80,240,{"$f":"Colorcode","v":{"$error":"#NAME?"}}]
[]
[null,"Colored ltem Cost",null,null,null,{"$f":"SUMIFS(E6:E11,F6:F11,F7)","v":830}]
[null,"Total Cost",null,null,null,{"$f":"SUM(E6:E11)","v":830}]
[null,"Percentage",null,null,null,{"$f":"F13/F14","v":1}]

{"sheet":"VBA","index":4,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,4],[12,1,12,3],[13,1,13,3],[14,1,14,3]]}
[]
[]
[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]
[]
[null,"Colored ltem Cost",null,null,{"$f":"Sumcolor(E7,E6:E11)","v":{"$error":"#NAME?"}}]
[null,"Total Cost",null,null,830]
[null,"Percentage",null,null,{"$f":"E13/E14","v":{"$error":"#NAME?"}}]

{"sheet":"cell color","index":5,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Excel Cell Color Formula"]
[]
[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":"count colored cell","index":6,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,4],[12,1,12,3]]}
[]
[]
[null,"Count Colored Cells"]
[]
[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]
[]
[null,"No of Colored Cells",null,null,{"$f":"SUBTOTAL(3,E6:E11)","v":3}]