{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Courier_Load"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Courier_Load","index":0,"n_rows":14,"n_cols":66,"rows_kept":14,"cut":false,"hidden":false,"merged":[[7,63,7,64],[7,51,7,52],[7,53,7,54],[7,55,7,56],[7,57,7,58],[7,59,7,60],[7,61,7,62],[7,49,7,50],[7,27,7,28],[7,29,7,30],[7,31,7,32],[7,33,7,34],[7,35,7,36],[7,37,7,38],[7,39,7,40],[7,41,7,42],[7,43,7,44],[7,45,7,46],[7,47,7,48],[7,25,7,26],[7,3,7,4],[7,5,7,6],[7,7,7,8],[7,9,7,10],[7,11,7,12],[7,13,7,14],[7,15,7,16],[7,17,7,18],[7,19,7,20],[7,21,7,22],[7,23,7,24]]}
[]
[]
[]
[null,null,"after running macro columns hide but dates are not autofit as I tried to autofit dates whole columns will get unhidden. Please check this issue. "]
[]
[]
[]
[null,null,"Avg","2015-03-01",null,"2015-03-02",null,"2015-03-03",null,"2015-03-04",null,"2015-03-05",null,"2015-03-06",null,"2015-03-07",null,"2015-03-08",null,"2015-03-09",null,"2015-03-10",null,"2015-03-11",null,"2015-03-12",null,"2015-03-13",null,"2015-03-14",null,"2015-03-15",null,"2015-03-16",null,"2015-03-17",null,"2015-03-18",null,"2015-03-19",null,"2015-03-20",null,"2015-03-21",null,"2015-03-22",null,"2015-03-23",null,"2015-03-24",null,"2015-03-25",null,"2015-03-26",null,"2015-03-27",null,"2015-03-28",null,"2015-03-29",null,"2015-03-30",null,"2015-03-31"]
[null,"Courier name ","Orders","Orders","%","Orders","%","Orders","%","Orders","%","Orders","%","Orders","%","Orders","%","Orders","%","Orders","%","Orders","%","Orders","%","Orders","%","Orders","%","Orders","%","Orders","%","Orders","%","Orders","%","Orders","%","Orders","%","Orders","%","Orders","%","Orders","%","Orders","%","Orders","%","Orders","%","Orders","%","Orders","%","Orders","%","Orders","%","Orders","%","Orders","%","Total orders "]
[null,"a",{"$f":"SUMPRODUCT(IF(MOD(COLUMN(D10:BM10),2)=0,D10:BM10,0))/(COUNT(D10:BM10)/2)","v":35007.727272727272},19772,0.28651750521678648,48860,0.27765938705809479,38149,0.26450664577367622,36622,0.27280989272943978,36325,0.27241570674346055,11119,0.25595635459588867,46385,0.26606514968136424,20291,0.28869602333357047,49916,0.27573178074473431,38838,0.29760463441173313,38808,{"$f":"IFERROR(X10/#REF!,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(IF(MOD(COLUMN(D10:AU10),2)<>0,D10:AU10,0))","v":2.7579630802887487}]
[null,"b",{"$f":"SUMPRODUCT(IF(MOD(COLUMN(D11:BM11),2)=0,D11:BM11,0))/(COUNT(D11:BM11)/2)","v":25868.18181818182},14579,0.21126536053790865,39647,0.22530416943700951,28751,0.19934547622844542,27114,0.20198152562574492,26985,0.20237131029517638,10236,0.23562993485417003,35384,0.20296322639485595,13512,0.19224585615707476,39220,0.21664797741823225,26177,0.20058696418445696,22945,{"$f":"IFERROR(X11/#REF!,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(IF(MOD(COLUMN(D11:AU11),2)<>0,D11:AU11,0))","v":2.0883418011330748}]
[null,"c",{"$f":"SUMPRODUCT(IF(MOD(COLUMN(D12:BM12),2)=0,D12:BM12,0))/(COUNT(D12:BM12)/2)","v":19566.727272727272},9598,0.13908532344076049,28143,0.15992976115382648,21249,0.14733025023053936,20624,0.1536352800953516,20631,0.15472012239020877,7504,0.17274003821274833,28130,0.16135415889914362,10221,0.14542220957530055,29715,0.16414315780170247,20702,0.15863358415962975,18717,{"$f":"IFERROR(X12/#REF!,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(IF(MOD(COLUMN(D12:AU12),2)<>0,D12:AU12,0))","v":1.5569938859592114}]
[null,"d",{"$f":"SUMPRODUCT(IF(MOD(COLUMN(D13:BM13),2)=0,D13:BM13,0))/(COUNT(D13:BM13)/2)","v":12968.363636363636},5454,7.9034314862044985E-2,19269,0.10950099732342261,15318,0.10620757555797458,13109,9.7653456495828364E-2,11916,8.9362850971922245E-2,5246,0.12076149259915747,17429,9.9973040719984863E-2,6504,9.25375257878637E-2,21510,0.11881942871662865,13962,0.10698686610166894,12935,{"$f":"IFERROR(X13/#REF!,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(IF(MOD(COLUMN(D13:AU13),2)<>0,D13:AU13,0))","v":1.0208375491364963}]
[null,"d",{"$f":"SUMPRODUCT(IF(MOD(COLUMN(D14:BM14),2)=0,D14:BM14,0))/(COUNT(D14:BM14)/2)","v":4727.636363636364},3161,4.5806283329469046E-2,6647,3.7773269459172247E-2,5627,3.9014886255694152E-2,4940,3.6799761620977353E-2,4704,3.5277177825773935E-2,2030,4.673004765083677E-2,6032,3.4599654691775124E-2,3118,4.4362239453652981E-2,6972,3.8512740911777539E-2,4530,3.4712111691774836E-2,4243,{"$f":"IFERROR(X14/#REF!,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(IF(MOD(COLUMN(D14:AU14),2)<>0,D14:AU14,0))","v":0.39358817289090398}]