{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Dataset","Order Data","Filter and Subtotal","GET CELL"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Colorfunction in Excel"]
[]
[]
["Order No.","Customer Name","Order Code","Order Quantity"]
[1001,"Alex Farguson","X230N",150,null,null,"Order Delivered"]
[1002,"Jhon Stuart","XL410F",200,null,null,"Order in Delivery"]
[1003,"Harold Finch","S210N",120]
[1004,"Joe Root","M370F",550]
[1005,"Tom Maccancy","X480SF",200]
[1006,"Peter Hanberg","M180N",340]
[1007,"Steven Mills","L500SF",480]
[]
[]
[]
[null,"Number of Customer","Total Quantity"]
["Order Delivered"]
["Order in Delivery"]

{"sheet":"Order Data","index":1,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Colorfunction in Excel"]
[]
[]
["Order No.","Customer Name","Order Code","Order Quantity"]
[1001,"Alex Farguson","X230N",150,null,null,"Order Delivered"]
[1002,"Jhon Stuart","XL410F",200,null,null,"Order in Delivery"]
[1003,"Harold Finch","S210N",120]
[1004,"Joe Root","M370F",550]
[1005,"Tom Maccancy","X480SF",200]
[1006,"Peter Hanberg","M180N",340]
[1007,"Steven Mills","L500SF",480]
[]
[]
[]
[null,"Number of Customer","Total Quantity"]
["Order Delivered",{"$f":"ColorFunction(F5,$D$5:$D$11,FALSE)","v":4},{"$f":"ColorFunction(F5,$D$5:$D$11,TRUE)","v":1380}]
["Order in Delivery",{"$f":"ColorFunction(F6,$D$5:$D$11,FALSE)","v":3},{"$f":"ColorFunction(F6,$D$5:$D$11,TRUE)","v":660}]

{"sheet":"Filter and Subtotal","index":2,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Colorfunction in Excel"]
[]
[]
["Order No.","Customer Name","Order Code","Order Quantity"]
[1001,"Alex Farguson","X230N",150,null,null,"Order Delivered"]
[1002,"Jhon Stuart","XL410F",200,null,null,"Order in Delivery"]
[1003,"Harold Finch","S210N",120]
[1004,"Joe Root","M370F",550]
[1005,"Tom Maccancy","X480SF",200]
[1006,"Peter Hanberg","M180N",340]
[1007,"Steven Mills","L500SF",480]
[]
[]
[]
["Total Number",{"$f":"SUBTOTAL(2,D5:D11)","v":4}]
["Total Quantity",{"$f":"SUBTOTAL(9,D5:D11)","v":1380}]

{"sheet":"GET CELL","index":3,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Colorfunction in Excel"]
[]
[]
["Order No.","Customer Name","Order Code","Order Quantity","Color Code"]
[1001,"Alex Farguson","X230N",150,{"$f":"Color","v":50},null,null,"Order Delivered"]
[1002,"Jhon Stuart","XL410F",200,{"$f":"Color","v":50},null,null,"Order in Delivery"]
[1003,"Harold Finch","S210N",120,{"$f":"Color","v":40}]
[1004,"Joe Root","M370F",550,{"$f":"Color","v":50}]
[1005,"Tom Maccancy","X480SF",200,{"$f":"Color","v":40}]
[1006,"Peter Hanberg","M180N",340,{"$f":"Color","v":40}]
[1007,"Steven Mills","L500SF",480,{"$f":"Color","v":50}]
[]
[]
[]
[null,"Number of Customer","Total Quantity"]
["Order Delivered",{"$f":"COUNTIF($E$5:$E$11,50)","v":4},{"$f":"SUMIF(E5:E11,50,D5:D11)","v":1380}]
["Order in Delivery",{"$f":"COUNTIF(E5:E11,40)","v":3},{"$f":"SUMIF(E5:E11,40,D5:D11)","v":660}]