{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Product Order Record","ColorFunction","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":"Product Order Record","index":0,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Product Order Record"]
[]
[null,"Order No.","Customer Name","Order Code","Order Quantity"]
[null,1001,"Alex Farguson","X230N",150]
[null,1002,"Jhon Stuart","XL410F",200]
[null,1003,"Harold Finch","S210N",120]
[null,1004,"Joe Root","M370F",550]
[null,1005,"Tom Maccancy","X480SF",200]
[null,1006,"Peter Hanberg","M180N",340]
[null,1007,"Steven Mills","L500SF",480]
[]
[null,"Order Delivered"]
[null,"Order in Delivery"]

{"sheet":"ColorFunction","index":1,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,14]]}
[]
[null,"Applying ColorFunction",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Order No.","Customer Name","Order Code","Order Quantity",null,null,null,null,null,null,"Order No.","Customer Name","Order Code","Order Quantity"]
[null,1001,"Alex Farguson","X230N",150,null,null,null,null,null,null,1001,"Alex Farguson","X230N",150]
[null,1002,"Jhon Stuart","XL410F",200,null,null,null,null,null,null,1002,"Jhon Stuart","XL410F",200]
[null,1003,"Harold Finch","S210N",120,null,null,null,null,null,null,1003,"Harold Finch","S210N",120]
[null,1004,"Joe Root","M370F",550,null,null,null,null,null,null,1004,"Joe Root","M370F",550]
[null,1005,"Tom Maccancy","X480SF",200,null,null,null,null,null,null,1005,"Tom Maccancy","X480SF",200]
[null,1006,"Peter Hanberg","M180N",340,null,null,null,null,null,null,1006,"Peter Hanberg","M180N",340]
[null,1007,"Steven Mills","L500SF",480,null,null,null,null,null,null,1007,"Steven Mills","L500SF",480]
[]
[null,"Order Delivered",null,null,null,null,null,null,null,null,null,"Order Delivered"]
[null,"Order in Delivery",null,null,null,null,null,null,null,null,null,"Order in Delivery"]
[]
[null,"Status","Number of Customer","Total Quantity"]
[null,"Order Delivered",{"$f":"Color_Function(C13,$E$5:$E$11,FALSE)","v":4},{"$f":"Color_Function(C13,$E$5:$E$11,TRUE)","v":1380}]
[null,"Order in Delivery",{"$f":"Color_Function(C14,$E$5:$E$11,FALSE)","v":3},{"$f":"Color_Function(C14,$E$5:$E$11,TRUE)","v":660}]

{"sheet":"SUBTOTAL","index":2,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using SUBTOTAL Function"]
[]
[null,"Order No.","Customer Name","Order Code","Order Quantity"]
[null,1001,"Alex Farguson","X230N",150]
[null,1002,"Jhon Stuart","XL410F",200]
[null,1003,"Harold Finch","S210N",120]
[null,1004,"Joe Root","M370F",550]
[null,1005,"Tom Maccancy","X480SF",200]
[null,1006,"Peter Hanberg","M180N",340]
[null,1007,"Steven Mills","L500SF",480]
[]
[null,"Order Delivered"]
[null,"Order in Delivery"]
[]
[null,"Total Number",{"$f":"SUBTOTAL(2,E5:E11)","v":3}]
[null,"Total Quantity",{"$f":"SUBTOTAL(9,E5:E11)","v":660}]

{"sheet":"GET.CELL","index":3,"n_rows":18,"n_cols":16,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,12,1,15]]}
[]
[null,"Inserting GET.CELL Function",null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Order No.","Customer Name","Order Code","Order Quantity","Color Code",null,null,null,null,null,null,"Order No.","Customer Name","Order Code","Order Quantity"]
[null,1001,"Alex Farguson","X230N",150,{"$f":"Color","v":50},null,null,null,null,null,null,1001,"Alex Farguson","X230N",150]
[null,1002,"Jhon Stuart","XL410F",200,{"$f":"Color","v":50},null,null,null,null,null,null,1002,"Jhon Stuart","XL410F",200]
[null,1003,"Harold Finch","S210N",120,{"$f":"Color","v":40},null,null,null,null,null,null,1003,"Harold Finch","S210N",120]
[null,1004,"Joe Root","M370F",550,{"$f":"Color","v":50},null,null,null,null,null,null,1004,"Joe Root","M370F",550]
[null,1005,"Tom Maccancy","X480SF",200,{"$f":"Color","v":40},null,null,null,null,null,null,1005,"Tom Maccancy","X480SF",200]
[null,1006,"Peter Hanberg","M180N",340,{"$f":"Color","v":40},null,null,null,null,null,null,1006,"Peter Hanberg","M180N",340]
[null,1007,"Steven Mills","L500SF",480,{"$f":"Color","v":50},null,null,null,null,null,null,1007,"Steven Mills","L500SF",480]
[]
[null,"Order Delivered",null,null,null,null,null,null,null,null,null,null,"Order Delivered"]
[null,"Order in Delivery",null,null,null,null,null,null,null,null,null,null,"Order in Delivery"]
[]
[null,"Status","Number of Customer","Total Quantity"]
[null,"Order Delivered",{"$f":"COUNTIF($F$5:$F$11,50)","v":4},{"$f":"SUMIF($F$5:$F$11,50,$E$5:$E$11)","v":1380}]
[null,"Order in Delivery",{"$f":"COUNTIF($F$5:$F$11,40)","v":3},{"$f":"SUMIF($F$5:$F$11,40,$E$5:$E$11)","v":660}]