{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["query","Commande","Priorités","Validation"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":7,"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":"query","index":0,"n_rows":14,"n_cols":16,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Order Type","Customer Name","Customer P.O. #","Pyrotek P.O. #","R&D Customer Ref. #","Point Of Contact","Sales Engineer","Part Number","Shipment Qty.","Scheduled Ship Date","Actual Ship Date","Delivery Date","Urgency Level","Status","Item Type","Path"]
["Test Samples Order","Nissan Mexicana",null,null,"EH.1901","Andrew Carlson","Edgar Hernandez","HR",12000,null,null,null,"Normal","Tooling Fabricated","Élément ","sites/pm/products/rigidglasweve/Lists/Gretzky Orders"]
["Test Samples Order","VW Braunschweig",null,null,null,"Spencer Bishop","Peter Petroschke","P048-1531X-21",200,null,null,null,"Normal","Order Placed","Élément ","sites/pm/products/rigidglasweve/Lists/Gretzky Orders"]
["Production Order","Superior Chihuahua, MX",null,"PO 46366","9311.31","Spencer Bishop","Edgar Juarez","P048-16611S-27",5000,"2019-05-08",null,null,"Normal","Ready to Ship","Élément ","sites/pm/products/rigidglasweve/Lists/Gretzky Orders"]
["Production Order","Superior Chihuahua, MX",null,"PO 46366","9311.31","Spencer Bishop","Edgar Juarez","P048-16613S-27",5000,"2019-05-08",null,null,"Normal","Ready to Ship","Élément ","sites/pm/products/rigidglasweve/Lists/Gretzky Orders"]
["Test Samples Order","Brembo Czech",null,null,null,"Chad Billmire","Petr Křešťák","P048-1502XS-17",200,"2019-05-15",null,null,"Normal","Tooling Fabricated","Élément ","sites/pm/products/rigidglasweve/Lists/Gretzky Orders"]
["Test Samples Order","Maxion Turkey",null,null,null,"Spencer Bishop","Cihan Türkay","P048-1",1000,"2019-05-15",null,null,"Normal","Order Placed","Élément ","sites/pm/products/rigidglasweve/Lists/Gretzky Orders"]
["Test Samples Order","Prime TJ",null,null,null,"Spencer Bishop","Dave Griffith","P048-3",2,"2019-05-15",null,null,"Normal","Order Placed","Élément ","sites/pm/products/rigidglasweve/Lists/Gretzky Orders"]
["Production Order","Duro Cast, Somonauk, IL","3135","PO 250353","9388.2","Chad Billmire","Paul Carlstrom","P048-25054",1000,"2019-05-16",null,null,"Normal","Order Placed","Élément ","sites/pm/products/rigidglasweve/Lists/Gretzky Orders"]
["Production Order","Chassix / Benton Harbor","P602329-00","PO 248160","9379.28","Chad Billmire","Shaun Fisher","P048-16814-30",153000,"2019-05-31",null,null,"Normal","Tooling Fabricated","Élément ","sites/pm/products/rigidglasweve/Lists/Gretzky Orders"]
["Production Order","Superior Poland",null,"3PS19-00983","9310.12","Andrew Carlson","Pawel Szypula","P048-14311S-17",100000,"2019-06-05",null,null,"Normal","Tooling Fabricated","Élément ","sites/pm/products/rigidglasweve/Lists/Gretzky Orders"]
["Production Order","Superior Poland",null,"3PS19-00983","9310.12","Andrew Carlson","Pawel Szypula","P048-15911S-20",30000,"2019-06-05",null,null,"Normal","Tooling Fabricated","Élément ","sites/pm/products/rigidglasweve/Lists/Gretzky Orders"]
["Production Order","Superior Poland",null,"3PS19-00983","9310.12","Andrew Carlson","Pawel Szypula","P048-14911S-21",180000,"2019-06-05",null,null,"Normal","Tooling Fabricated","Élément ","sites/pm/products/rigidglasweve/Lists/Gretzky Orders"]
["Production Order","Superior Poland",null,"3PS19-00983","9310.12","Andrew Carlson","Pawel Szypula","P048-15011S-23",250000,"2019-06-05",null,null,"Normal","Tooling Fabricated","Élément ","sites/pm/products/rigidglasweve/Lists/Gretzky Orders"]

{"sheet":"Commande","index":1,"n_rows":13,"n_cols":14,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,13]]}
["Commandes"]
["Colonne1",1,2,3,4,5,6,7,8,9,10,11,12,13]
["Statut:",{"$f":"query!$A$2","v":"Test Samples Order"},{"$f":"query!$A$3","v":"Test Samples Order"},{"$f":"query!$A$4","v":"Production Order"},{"$f":"query!$A$5","v":"Production Order"},{"$f":"query!$A$6","v":"Test Samples Order"},{"$f":"query!$A$7","v":"Test Samples Order"},{"$f":"query!$A$8","v":"Test Samples Order"},{"$f":"query!$A$9","v":"Production Order"},{"$f":"query!$A$10","v":"Production Order"},{"$f":"query!$A$11","v":"Production Order"},{"$f":"query!$A$12","v":"Production Order"},{"$f":"query!$A$13","v":"Production Order"},{"$f":"query!$A$14","v":"Production Order"}]
["Client:",{"$f":"query!$B$2","v":"Nissan Mexicana"},{"$f":"query!$B$3","v":"VW Braunschweig"},{"$f":"query!$B$4","v":"Superior Chihuahua, MX"},{"$f":"query!$B$5","v":"Superior Chihuahua, MX"},{"$f":"query!$B$6","v":"Brembo Czech"},{"$f":"query!$B$7","v":"Maxion Turkey"},{"$f":"query!$B$8","v":"Prime TJ"},{"$f":"query!$B$9","v":"Duro Cast, Somonauk, IL"},{"$f":"query!$B$10","v":"Chassix / Benton Harbor"},{"$f":"query!$B$11","v":"Superior Poland"},{"$f":"query!$B$12","v":"Superior Poland"},{"$f":"query!$B$13","v":"Superior Poland"},{"$f":"query!$B$14","v":"Superior Poland"}]
["# de pièce:",{"$f":"query!$H$2","v":"HR"},{"$f":"query!$H$3","v":"P048-1531X-21"},{"$f":"query!$H$4","v":"P048-16611S-27"},{"$f":"query!$H$5","v":"P048-16613S-27"},{"$f":"query!$H$6","v":"P048-1502XS-17"},{"$f":"query!$H$7","v":"P048-1"},{"$f":"query!$H$8","v":"P048-3"},{"$f":"query!$H$9","v":"P048-25054"},{"$f":"query!$H$10","v":"P048-16814-30"},{"$f":"query!$H$11","v":"P048-14311S-17"},{"$f":"query!$H$12","v":"P048-15911S-20"},{"$f":"query!$H$13","v":"P048-14911S-21"},{"$f":"query!$H$14","v":"P048-15011S-23"}]
["Type:",{"$f":"IF(ISBLANK(B5),\"\",VLOOKUP((MID(B5,6,1)+0),Type,2,))","v":{"$error":"#VALUE!"}},"LPC","LPC","LPC","LPC","LPC",{"$error":"#N/A"},{"$f":"IF(ISBLANK(I5),\"\",VLOOKUP((MID(I5,6,1)+0),Type,2,))","v":"SPC"},"LPC","LPC","LPC","LPC","LPC"]
["Tissu:",{"$f":"IF(ISBLANK(B5),\"\",IF(MID(B5,10,1)=\"X\",\"Indéterminé\",VLOOKUP((MID(B5,10,1)+0),Weave_Style,2,)))","v":{"$error":"#VALUE!"}},"Indéterminé","34L","40L","Indéterminé",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF(ISBLANK(I5),\"\",IF(MID(I5,10,1)=\"X\",\"Indéterminé\",VLOOKUP((MID(I5,10,1)+0),Weave_Style,2,)))","v":"43L2"},"43L2","34L","34L","34L","34L"]
["Broché:",{"$f":"IF(ISBLANK(B5),\"\",IF(MID(B5,11,1)=\"S\",\"Oui\",\"Non\"))","v":"Non"},{"$f":"IF(ISBLANK(C5),\"\",IF(MID(C5,11,1)=\"S\",\"Oui\",\"Non\"))","v":"Non"},"Oui","Oui","Oui","Non","Non",{"$f":"IF(ISBLANK(I5),\"\",IF(MID(I5,11,1)=\"S\",\"Oui\",\"Non\"))","v":"Non"},"Non","Oui","Oui","Oui","Oui"]
["Quantité:",{"$f":"query!$I$2","v":12000},{"$f":"query!$I$3","v":200},{"$f":"query!$I$4","v":5000},{"$f":"query!$I$5","v":5000},{"$f":"query!$I$6","v":200},{"$f":"query!$I$7","v":1000},{"$f":"query!$I$8","v":2},{"$f":"query!$I$9","v":1000},{"$f":"query!$I$10","v":153000},{"$f":"query!$I$11","v":100000},{"$f":"query!$I$12","v":30000},{"$f":"query!$I$13","v":180000},{"$f":"query!$I$14","v":250000}]
["Échéance:",{"$f":"query!$J$2","v":"00:00:00"},{"$f":"query!$J$3","v":"00:00:00"},{"$f":"query!$J$4","v":"2019-05-08"},{"$f":"query!$J$5","v":"2019-05-08"},{"$f":"query!$J$6","v":"2019-05-15"},{"$f":"query!$J$7","v":"2019-05-15"},{"$f":"query!$J$8","v":"2019-05-15"},{"$f":"query!$J$9","v":"2019-05-16"},{"$f":"query!$J$10","v":"2019-05-31"},{"$f":"query!$J$11","v":"2019-06-05"},{"$f":"query!$J$12","v":"2019-06-05"},{"$f":"query!$J$13","v":"2019-06-05"},{"$f":"query!$J$14","v":"2019-06-05"}]
["Presse:"]
["Coupons"]
["Inventaire:"]

{"sheet":"Priorités","index":2,"n_rows":6,"n_cols":5,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,1],[1,2,1,3],[1,4,1,5]]}
["Priorités"]
["Jour",null,"Soir",null,"Nuit"]
["Hélène",null,"Pascal",null,"Gaétan"]
["Mario",null,"Benoît",null,"Cédrick"]
["Stéphane",null,"Nathalie",null,"Paige"]
["David"]

{"sheet":"Validation","index":3,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,1],[0,3,0,4]]}
["Tissus",null,null,"Type",null,null,"Presse"]
["#","Weave Style",null,1,"LPC",null,1]
[null,null,null,2,"SPC",null,2]
[1,"34L",null,null,null,null,3]
[2,"36L",null,null,null,null,4]
[3,"40L",null,null,null,null,5]
[4,"43L2",null,null,null,null,6]
[5,"55P",null,null,null,null,7]
[0,"Autre",null,null,null,null,8]
["X","Indéterminé",null,null,null,null,9]
[null,null,null,null,null,null,10]