{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["OPITA","Pivot22"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":1},"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":"OPITA","index":0,"n_rows":5,"n_cols":56,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["ISELL_ORDER_NUMBER","PICK_ID","ORDER_METHOD","HANDOUT_AREA","ARTICLES","PACKAGES","WEIGHT","VOLUME","ORDERED_QTY","PICKED_QTY","OPEN_PICK_QTY","CHECKED_QTY","PICK_AREA","ACTUAL_ORDER_STATUS","DATE_OF_PAYMENT","TIME_OF_PAYMENT","PAID","STARTED","PICKING","WAIT_FOR_MERGE","PICKED","CHECK_STARTED","CHECKED","COMPLETED","CANCELLED","NOT_HANDED_OUT","PICKED_WITH_RDT","CHECK_WITH_SCAN_REQUESTED","REASON_WHY_NOT_RDT","NR_OUT_OF_STOCK","SAC_NO","FORCE_CHECK_ACTIVATED","SEND_BACK","FORCE_PICK_ACTIVATED","CHECKED_STARTED_WITH_RDT","CHECKED_WITH_RDT","COMPLETED_WITH_RDT","USER_PICKING","USER_CHECKING","USER_HANDED_OUT","SERVICE_PROVIDER_UNICODE","CUT_OFF_DATE","CUT_OFF_TIME","COMPLETED_BEFORE_CUT_OFF","SERVICE_DATE","SERVICE_WINDOW","DELIVERY_METHOD","SER+LOG WT Goal","LOG WT Goal","Сигнал","Overstock","До CoT","До WT sm2","До WT sm1","До WT sm0","Для стат"]
[100996639,69839,"INTERNET","Collect 1",1,1,20.260000000000002,9.1619999999999993E-2,1,1,0,1,"Full Serve internal","Checked","2019-05-24","21:35:42","21:35:42","21:42:43","21:44:14",null,"21:44:47","21:46:16","21:46:22",null,null,null,"R","Y",null,0,"","Disable","N","Not forced","W62","W62",null,"IRKHA2","MAGIN",null,"","","","","","","",{"$f":"IF(AND(D2=\"Customer 1\",M2=\"Full Serve internal\"),IF(AND(W2-P2>0,#REF!+#REF!*E2>=W2-P2),\"Y\",\"N\"),IF(AND(D2=\"Customer 1\",M2=\"Self Serve\"),IF(AND(W2-P2>0,#REF!+#REF!*E2>=W2-P2),\"Y\",\"N\"),IF(AND(D2=\"Customer 1\",M2=\"Markethall\"),IF(AND(W2-P2>0,#REF!+#REF!*E2>=W2-P2),\"Y\",\"N\"),\"\")))","v":""},{"$f":"IF(AND(D2=\"Customer 1\",M2=\"Full Serve internal\"),IF(AND(U2-P2>0,#REF!+#REF!*E2>=U2-P2),\"Y\",\"N\"),IF(AND(D2=\"Customer 1\",M2=\"Self Serve\"),IF(AND(U2-P2>0,#REF!+#REF!*E2>=U2-P2),\"Y\",\"N\"),IF(AND(D2=\"Customer 1\",M2=\"Markethall\"),IF(AND(U2-P2>0,#REF!+#REF!*E2>=U2-P2),\"Y\",\"N\"),\"\")))","v":""},{"$f":"IF(AND(D2=\"Customer 1\",M2=\"Full Serve internal\",N2=\"Not Started\"),soundme(),\"нет\")","v":"нет"},{"$f":"IF(AD2>0,\"1\",\"\")","v":""},{"$f":"IF(D2=\"Transport 1\",IF(AND(AP2+AQ2-NOW()>=0,AP2+AQ2-NOW()<=0.083333),AP2+AQ2-NOW(),\"\"),\"\")","v":""},{"$f":"IF(AND(D2=\"Customer 1\",M2=\"Full Serve internal\",OR(N2=\"Not Started\",N2=\"Picking\",N2=\"Started\",N2=\"Picked\")),#REF!+(#REF!*E2)+P2,\"\")","v":""},{"$f":"IF(AND(D2=\"Customer 1\",M2=\"Self Serve\",OR(N2=\"Not Started\",N2=\"Picking\",N2=\"Started\",N2=\"Picked\")),#REF!+(#REF!*E2)+P2,\"\")","v":""},{"$f":"IF(AND(D2=\"Customer 1\",M2=\"Markethall\",OR(N2=\"Not Started\",N2=\"Picking\",N2=\"Started\",N2=\"Picked\")),#REF!+(#REF!*E2)+P2,\"\")","v":""},{"$f":"IF(O2=TODAY(),\"1\",\"\")","v":""}]
[101030506,70150,"INTERNET","Collect 1",1,1,38.841999999999999,7.8650999999999999E-2,1,1,0,1,"Full Serve internal","Checked","2019-05-26","19:16:08","19:16:08","19:27:33","19:28:45",null,"19:30:43","19:33:06","19:33:19",null,null,null,"R","Y",null,0,"","Disable","N","Not forced","W62","W62",null,"RONIK4","MAAIN3",null,"","","","","","","",{"$f":"IF(AND(D3=\"Customer 1\",M3=\"Full Serve internal\"),IF(AND(W3-P3>0,#REF!+#REF!*E3>=W3-P3),\"Y\",\"N\"),IF(AND(D3=\"Customer 1\",M3=\"Self Serve\"),IF(AND(W3-P3>0,#REF!+#REF!*E3>=W3-P3),\"Y\",\"N\"),IF(AND(D3=\"Customer 1\",M3=\"Markethall\"),IF(AND(W3-P3>0,#REF!+#REF!*E3>=W3-P3),\"Y\",\"N\"),\"\")))","v":""},{"$f":"IF(AND(D3=\"Customer 1\",M3=\"Full Serve internal\"),IF(AND(U3-P3>0,#REF!+#REF!*E3>=U3-P3),\"Y\",\"N\"),IF(AND(D3=\"Customer 1\",M3=\"Self Serve\"),IF(AND(U3-P3>0,#REF!+#REF!*E3>=U3-P3),\"Y\",\"N\"),IF(AND(D3=\"Customer 1\",M3=\"Markethall\"),IF(AND(U3-P3>0,#REF!+#REF!*E3>=U3-P3),\"Y\",\"N\"),\"\")))","v":""},{"$f":"IF(AND(D3=\"Customer 1\",M3=\"Full Serve internal\",N3=\"Not Started\"),soundme(),\"нет\")","v":"нет"},"","",{"$f":"IF(AND(D3=\"Customer 1\",M3=\"Full Serve internal\",OR(N3=\"Not Started\",N3=\"Picking\",N3=\"Started\",N3=\"Picked\")),#REF!+(#REF!*E3)+P3,\"\")","v":""},{"$f":"IF(AND(D3=\"Customer 1\",M3=\"Self Serve\",OR(N3=\"Not Started\",N3=\"Picking\",N3=\"Started\",N3=\"Picked\")),#REF!+(#REF!*E3)+P3,\"\")","v":""},{"$f":"IF(AND(D3=\"Customer 1\",M3=\"Markethall\",OR(N3=\"Not Started\",N3=\"Picking\",N3=\"Started\",N3=\"Picked\")),#REF!+(#REF!*E3)+P3,\"\")","v":""},""]
[101036913,70208,"INTERNET","Collect 1",1,4,57.04,0.14006399999999999,4,4,0,4,"Self Serve","Completed","2019-05-27","12:16:20","12:16:20","12:16:39","12:18:38",null,"12:19:17","12:22:33","12:22:41","13:05:25",null,null,"R","Y",null,0,"","Disable","N","Not forced","W62","W62","W62","DAMAK11","MAZAG9","MAZAG9","","","","","","","",{"$f":"IF(AND(D4=\"Customer 1\",M4=\"Full Serve internal\"),IF(AND(W4-P4>0,#REF!+#REF!*E4>=W4-P4),\"Y\",\"N\"),IF(AND(D4=\"Customer 1\",M4=\"Self Serve\"),IF(AND(W4-P4>0,#REF!+#REF!*E4>=W4-P4),\"Y\",\"N\"),IF(AND(D4=\"Customer 1\",M4=\"Markethall\"),IF(AND(W4-P4>0,#REF!+#REF!*E4>=W4-P4),\"Y\",\"N\"),\"\")))","v":""},{"$f":"IF(AND(D4=\"Customer 1\",M4=\"Full Serve internal\"),IF(AND(U4-P4>0,#REF!+#REF!*E4>=U4-P4),\"Y\",\"N\"),IF(AND(D4=\"Customer 1\",M4=\"Self Serve\"),IF(AND(U4-P4>0,#REF!+#REF!*E4>=U4-P4),\"Y\",\"N\"),IF(AND(D4=\"Customer 1\",M4=\"Markethall\"),IF(AND(U4-P4>0,#REF!+#REF!*E4>=U4-P4),\"Y\",\"N\"),\"\")))","v":""},{"$f":"IF(AND(D4=\"Customer 1\",M4=\"Full Serve internal\",N4=\"Not Started\"),soundme(),\"нет\")","v":"нет"},"","",{"$f":"IF(AND(D4=\"Customer 1\",M4=\"Full Serve internal\",OR(N4=\"Not Started\",N4=\"Picking\",N4=\"Started\",N4=\"Picked\")),#REF!+(#REF!*E4)+P4,\"\")","v":""},{"$f":"IF(AND(D4=\"Customer 1\",M4=\"Self Serve\",OR(N4=\"Not Started\",N4=\"Picking\",N4=\"Started\",N4=\"Picked\")),#REF!+(#REF!*E4)+P4,\"\")","v":""},{"$f":"IF(AND(D4=\"Customer 1\",M4=\"Markethall\",OR(N4=\"Not Started\",N4=\"Picking\",N4=\"Started\",N4=\"Picked\")),#REF!+(#REF!*E4)+P4,\"\")","v":""},""]
[101042868,70249,"INTERNET","Collect 1",8,17,37.646000000000001,0.210757,17,17,0,17,"Self Serve","Checked","2019-05-27","16:55:11","16:55:11","16:55:32","16:55:38",null,"18:02:36","18:03:49","18:05:12",null,null,null,"R","Y",null,0,"","Disable","N","Not forced","W62","W62",null,"DEDUB3","MAGIN",null,"","","","","","","",{"$f":"IF(AND(D5=\"Customer 1\",M5=\"Full Serve internal\"),IF(AND(W5-P5>0,#REF!+#REF!*E5>=W5-P5),\"Y\",\"N\"),IF(AND(D5=\"Customer 1\",M5=\"Self Serve\"),IF(AND(W5-P5>0,#REF!+#REF!*E5>=W5-P5),\"Y\",\"N\"),IF(AND(D5=\"Customer 1\",M5=\"Markethall\"),IF(AND(W5-P5>0,#REF!+#REF!*E5>=W5-P5),\"Y\",\"N\"),\"\")))","v":""},{"$f":"IF(AND(D5=\"Customer 1\",M5=\"Full Serve internal\"),IF(AND(U5-P5>0,#REF!+#REF!*E5>=U5-P5),\"Y\",\"N\"),IF(AND(D5=\"Customer 1\",M5=\"Self Serve\"),IF(AND(U5-P5>0,#REF!+#REF!*E5>=U5-P5),\"Y\",\"N\"),IF(AND(D5=\"Customer 1\",M5=\"Markethall\"),IF(AND(U5-P5>0,#REF!+#REF!*E5>=U5-P5),\"Y\",\"N\"),\"\")))","v":""},{"$f":"IF(AND(D5=\"Customer 1\",M5=\"Full Serve internal\",N5=\"Not Started\"),soundme(),\"нет\")","v":"нет"},"","",{"$f":"IF(AND(D5=\"Customer 1\",M5=\"Full Serve internal\",OR(N5=\"Not Started\",N5=\"Picking\",N5=\"Started\",N5=\"Picked\")),#REF!+(#REF!*E5)+P5,\"\")","v":""},{"$f":"IF(AND(D5=\"Customer 1\",M5=\"Self Serve\",OR(N5=\"Not Started\",N5=\"Picking\",N5=\"Started\",N5=\"Picked\")),#REF!+(#REF!*E5)+P5,\"\")","v":""},{"$f":"IF(AND(D5=\"Customer 1\",M5=\"Markethall\",OR(N5=\"Not Started\",N5=\"Picking\",N5=\"Started\",N5=\"Picked\")),#REF!+(#REF!*E5)+P5,\"\")","v":""},""]

{"sheet":"Pivot22","index":1,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,15,2,17],[2,1,3,3],[2,5,6,7],[2,9,4,12]]}
[]
[]
[null,"Логистический WT FS"]
[]
[null,"HANDOUT_AREA","Customer 1"]
[null,"PICK_AREA","Full Serve internal"]
[]
[null,"Количество по полю PICK_ID","Названия столбцов"]
[null,"Названия строк","N","Y"]
[null,"TIKAI3",0.5,0.5]
[null,"IRKHA2",1,0]
[null,"Общий итог",0.66666666666666663,0.33333333333333331]