{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Cells colored manually","In entire workbook","With conditional format"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Cells colored manually","index":0,"n_rows":25,"n_cols":12,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,0,0,3],[0,8,0,11]]}
["Cells colored manually",null,null,null,null,null,null,null,"Cells colored manually"]
["Order no.","Order date","Qty.","Delivery",null,null,null,null,"Order no.","Order date","Qty.","Delivery"]
[1234,"2013-10-20",1,"Past Due",null,null,null,null,1234,"2013-10-20",1,"Past Due"]
[1235,"2013-10-20",10,"Delivered",null,null,null,null,1235,"2013-10-20",11,"Delivered"]
[1236,"2013-10-18",1,"Past Due",null,null,null,null,1236,"2013-10-18",1,"Past Due"]
[1237,"2013-10-21",2,"Due in 3 Days",null,null,null,null,1237,"2013-10-21",2,"Due in 3 Days"]
[1238,"2013-10-22",5,"Delivered",null,null,null,null,1238,"2013-10-22",5,"Delivered"]
[1239,"2013-10-23",12,"Due in 5 Days",null,null,null,null,1239,"2013-10-23",12,"Due in 5 Days"]
[1240,"2013-10-16",4,"Past Due",null,null,null,null,1240,"2013-10-16",4,"Past Due"]
[1241,"2013-10-21",7,"Past Due",null,null,null,null,1241,"2013-10-21",7,"Past Due"]
[1242,"2013-10-23",6,"Due in 3 Days",null,null,null,null,1242,"2013-10-23",6,"Due in 3 Days"]
[1243,"2013-10-20",2,"Delivered",null,null,null,null,1243,"2013-10-20",2,"Delivered"]
[1244,"2013-10-19",8,"Delivered",null,null,null,null,1244,"2013-10-19",8,"Past Due"]
[1245,"2013-10-24",1,"Due in 7 Days",null,null,null,null,1245,"2013-10-24",2,"Due in 7 Days"]
[1246,"2013-10-26",2,"Past Due",null,null,null,null,1246,"2013-10-26",2,"Past Due"]
[null,null,null,null,"   "]
["Count by fill color:",null,null,null,null,null,null,null,"Count by font color:"]
["Past Due",{"$f":"CountCellsByColor(C3:C15,A18)","v":5},null,null,null,null,null,null,"Past Due",{"$f":"CountCellsByFontColor(K3:K15,I18)","v":5}]
["Due in",{"$f":"CountCellsByColor(C3:C15,A19)","v":4},null,null,null,null,null,null,"Due in",{"$f":"CountCellsByFontColor(K3:K15,I19)","v":5}]
["Delivered",{"$f":"CountCellsByColor(C3:C15,A20)","v":4},null,null,null,null,null,null,"Delivered",{"$f":"CountCellsByFontColor(K3:K15,I20)","v":3}]
[]
["Sum by fill color:",null,null,null,null,null,null,null,"Sum by font color:"]
["Past Due",{"$f":"SumCellsByColor(C3:C15,A23)","v":15},null,null,null,null,null,null,"Past Due",{"$f":"SumCellsByFontColor(K3:K15,I23)","v":16}]
["Due in",{"$f":"SumCellsByColor(C3:C15,A24)","v":21},null,null,null,null,null,null,"Due in",{"$f":"SumCellsByFontColor(K3:K15,I24)","v":29}]
["Delivered",{"$f":"SumCellsByColor(C3:C15,A25)","v":25},null,null,null,null,null,null,"Delivered",{"$f":"SumCellsByFontColor(K3:K15,I25)","v":18}]

{"sheet":"In entire workbook","index":1,"n_rows":25,"n_cols":4,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Cells colored manually"]
["Order no.","Order date","Qty.","Delivery"]
[1234,"2013-10-20",1,"Past Due"]
[1235,"2013-10-20",10,"Delivered"]
[1236,"2013-10-18",1,"Past Due"]
[1237,"2013-10-21",2,"Due in 3 Days"]
[1238,"2013-10-22",5,"Delivered"]
[1239,"2013-10-23",12,"Due in 5 Days"]
[1240,"2013-10-16",4,"Past Due"]
[1241,"2013-10-21",7,"Past Due"]
[1242,"2013-10-23",6,"Due in 3 Days"]
[1243,"2013-10-20",2,"Delivered"]
[1244,"2013-10-19",8,"Due in 3 Days"]
[1245,"2013-10-24",1,"Due in 7 Days"]
[1246,"2013-10-26",2,"Past Due"]
[]
["Count by fill color:"]
["Past Due",{"$f":"WbkCountCellsByColor(A18)","v":14}]
["Due in",{"$f":"WbkCountCellsByColor(A19)","v":13}]
["Delivered",{"$f":"WbkCountCellsByColor(A20)","v":11}]
[]
["Sum by fill color:"]
["Past Due",{"$f":"WbkSumCellsByColor(A23)","v":30}]
["Due in",{"$f":"WbkSumCellsByColor(A24)","v":50}]
["Delivered",{"$f":"WbkSumCellsByColor(A25)","v":42}]

{"sheet":"With conditional format","index":2,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Order no.","Order date","Part number","Qty.","Delivery"]
[1234,"2013-10-20",300377222,1,"Past Due"]
[1235,"2013-10-20",300378107,10,"Delivered"]
[1236,"2013-10-18",300444730,1,"Past Due"]
[1237,"2013-10-21",300452863,2,"Due in 3 Days"]
[1238,"2013-10-22",300448203,5,"Delivered"]
[1239,"2013-10-23",300388035,12,"Due in 5 Days"]
[1240,"2013-10-16",300486394,4,"Past Due"]
[1241,"2013-10-21",300486395,7,"Past Due"]
[1242,"2013-10-23",300444731,6,"Due in 3 Days"]
[1243,"2013-10-20",300482712,2,"Delivered"]
[1244,"2013-10-19",300452863,8,"Delivered"]
[1245,"2013-10-24",300448203,1,"Due in 7 Days"]
[1246,"2013-10-26",300388035,2,"Past Due"]