{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sommaire","MAQUETTE","Aide"],"not_rendered":{"charts":0,"images":5,"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":"Sommaire","index":0,"n_rows":32,"n_cols":17,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[{"$f":"C4","v":"2018-06-01"},null,2018,null,"1.Selectionnez une année"]
[{"$f":"A2+1","v":"2018-06-02"}]
[{"$f":"A3+1","v":"2018-06-03"},null,"2018-06-01",null,"2.Selectionnez un mois"]
["2018-06-04"]
["2018-06-05"]
["2018-06-06",null,null,null,"3.Lancez la création"]
["2018-06-07"]
["2018-06-08"]
["2018-06-09"]
["2018-06-10"]
["2018-06-11"]
["2018-06-12"]
["2018-06-13"]
["2018-06-14"]
["2018-06-15"]
["2018-06-16"]
["2018-06-17"]
["2018-06-18",null,null,null,{"$f":"IFERROR(VLOOKUP($C$2,Sommaire!$E$21:$Q$32,2,FALSE),0)","v":"2018-01-01"},{"$f":"IFERROR(VLOOKUP($C$2,Sommaire!$E$21:$Q$32,3,FALSE),0)","v":"2018-02-01"},{"$f":"IFERROR(VLOOKUP($C$2,Sommaire!$E$21:$Q$32,4,FALSE),0)","v":"2018-03-01"},{"$f":"IFERROR(VLOOKUP($C$2,Sommaire!$E$21:$Q$32,5,FALSE),0)","v":"2018-04-01"},{"$f":"IFERROR(VLOOKUP($C$2,Sommaire!$E$21:$Q$32,6,FALSE),0)","v":"2018-05-01"},{"$f":"IFERROR(VLOOKUP($C$2,Sommaire!$E$21:$Q$32,7,FALSE),0)","v":"2018-06-01"},{"$f":"IFERROR(VLOOKUP($C$2,Sommaire!$E$21:$Q$32,8,FALSE),0)","v":"2018-07-01"},{"$f":"IFERROR(VLOOKUP($C$2,Sommaire!$E$21:$Q$32,9,FALSE),0)","v":"2018-08-01"},{"$f":"IFERROR(VLOOKUP($C$2,Sommaire!$E$21:$Q$32,10,FALSE),0)","v":"2018-09-01"},{"$f":"IFERROR(VLOOKUP($C$2,Sommaire!$E$21:$Q$32,11,FALSE),0)","v":"2018-10-01"},{"$f":"IFERROR(VLOOKUP($C$2,Sommaire!$E$21:$Q$32,12,FALSE),0)","v":"2018-11-01"},{"$f":"IFERROR(VLOOKUP($C$2,Sommaire!$E$21:$Q$32,13,FALSE),0)","v":"2018-12-01"}]
["2018-06-19"]
["2018-06-20",null,null,null,2017,"2017-01-01","2017-02-01","2017-03-01","2017-04-01","2017-05-01","2017-06-01","2017-07-01","2017-08-01","2017-09-01","2017-10-01","2017-11-01","2017-12-01"]
["2018-06-21",null,null,null,2018,"2018-01-01","2018-02-01","2018-03-01","2018-04-01","2018-05-01","2018-06-01","2018-07-01","2018-08-01","2018-09-01","2018-10-01","2018-11-01","2018-12-01"]
["2018-06-22",null,null,null,2019,"2019-01-01","2019-02-01","2019-03-01","2019-04-01","2019-05-01","2019-06-01","2019-07-01","2019-08-01","2019-09-01","2019-10-01","2019-11-01","2019-12-01"]
["2018-06-23",null,null,null,2020,"2020-01-01","2020-02-01","2020-03-01","2020-04-01","2020-05-01","2020-06-01","2020-07-01","2020-08-01","2020-09-01","2020-10-01","2020-11-01","2020-12-01"]
["2018-06-24",null,null,null,2021,"2021-01-01","2021-02-01","2021-03-01","2021-04-01","2021-05-01","2021-06-01","2021-07-01","2021-08-01","2021-09-01","2021-10-01","2021-11-01","2021-12-01"]
["2018-06-25",null,null,null,2022,"2022-01-01","2022-02-01","2022-03-01","2022-04-01","2022-05-01","2022-06-01","2022-07-01","2022-08-01","2022-09-01","2022-10-01","2022-11-01","2022-12-01"]
["2018-06-26",null,null,null,2023,"2023-01-01","2023-02-01","2023-03-01","2023-04-01","2023-05-01","2023-06-01","2023-07-01","2023-08-01","2023-09-01","2023-10-01","2023-11-01","2023-12-01"]
["2018-06-27",null,null,null,2024,"2024-01-01","2024-02-01","2024-03-01","2024-04-01","2024-05-01","2024-06-01","2024-07-01","2024-08-01","2024-09-01","2024-10-01","2024-11-01","2024-12-01"]
["2018-06-28",null,null,null,2025,"2025-01-01","2025-02-01","2025-03-01","2025-04-01","2025-05-01","2025-06-01","2025-07-01","2025-08-01","2025-09-01","2025-10-01","2025-11-01","2025-12-01"]
[{"$f":"A29+1","v":"2018-06-29"},null,null,null,2026,"2026-01-01","2026-02-01","2026-03-01","2026-04-01","2026-05-01","2026-06-01","2026-07-01","2026-08-01","2026-09-01","2026-10-01","2026-11-01","2026-12-01"]
["2018-06-30",null,null,null,2027,"2027-01-01","2027-02-01","2027-03-01","2027-04-01","2027-05-01","2027-06-01","2027-07-01","2027-08-01","2027-09-01","2027-10-01","2027-11-01","2027-12-01"]
["2018-07-01",null,null,null,2028,"2028-01-01","2028-02-01","2028-03-01","2028-04-01","2028-05-01","2028-06-01","2028-07-01","2028-08-01","2028-09-01","2028-10-01","2028-11-01","2028-12-01"]

{"sheet":"MAQUETTE","index":1,"n_rows":41,"n_cols":11,"rows_kept":41,"cut":false,"hidden":false,"merged":[[40,0,40,1],[0,2,0,10],[2,0,2,1],[14,0,14,1],[24,0,24,1],[38,0,38,1]]}
["Journée Postale :",null,"BRIEF QUOTIDIEN PIC- DOIC /DRIC"]
["PIC","DOIC","ATA","% Restes Lettre Départ (Prio + LV)\nà la coupure","% Restes Lettre Arrivée Prio à la coupure\nhors volumineux","Taux de flashage ouverture SILOE dans les délais  ","Stocks CI TA+TD DLT J","Stocks RFX TA+TD","% Distribution Pilotée","% Mode Forcé ","Dysfonctionnements, anomalies, risques majeurs"]
["NOMINAL",null,0,"0,5% - 1%","0,5% - 1%",0.96499999999999997,"LOCAL","LOCAL",0.12,"50% - 70%"]
["LOGNES PIC","IDF/NE"]
["BOIS DARCY 78 28 PIC","IDF/NE"]
["PARIS SUD PIC","IDF/NE"]
["VILLENEUVE PIC","IDF/NE"]
["PARIS NORD PIC","IDF/NE"]
["DIJON LONGVIC PIC","IDF/NE"]
["MEUSE CHAMP ARD PIC","IDF/NE"]
["LORRAINE PIC","IDF/NE"]
["LILLE PIC","IDF/NE"]
["STRASBOURG EUROP PIC","IDF/NE"]
["ROYE PIC","IDF/NE"]
["S/TOTAL DOIC",null,{"$f":"SUM(C4:C14)","v":0},null,null,null,{"$f":"SUM(G4:G14)","v":0},{"$f":"SUM(H4:H14)","v":0}]
["BASSE NORMANDIE PIC","OUEST"]
["BOURGES CTC","OUEST"]
["BREST PIC","OUEST"]
["RENNES ARMORIQUE PIC","OUEST"]
["VAL DE LOIRE PIC","OUEST"]
["NANTES ATLANTIQ PIC","OUEST"]
["LOIRET PIC","OUEST"]
["ANGERS PIC","OUEST"]
["ROUEN PIC","OUEST"]
["S/TOTAL DOIC",null,{"$f":"SUM(C16:C24)","v":0},null,null,null,{"$f":"SUM(G16:G24)","v":0},{"$f":"SUM(H16:H24)","v":0}]
["NICE PIC","SUD O/SUD"]
["VITROLLES PIC","SUD O/SUD"]
["VALLEE DU RHONE PIC","SUD O/SUD"]
["LANGUEDOC PIC","SUD O/SUD"]
["ISERE PIC","SUD O/SUD"]
["ST PRIEST PIC","SUD O/SUD"]
["HAUTE SAVOIE PIC","SUD O/SUD"]
["TOULON PIC","SUD O/SUD"]
["MIDI PYRENEES PIC","SUD O/SUD"]
["BORDEAUX PIC","SUD O/SUD"]
["AUVERGNE PIC","SUD O/SUD"]
["POITIERS PIC","SUD O/SUD"]
["LIMOGES CTC","SUD O/SUD"]
["S/TOTAL DOIC",null,{"$f":"SUM(C26:C38)","v":0},null,null,null,{"$f":"SUM(G26:G38)","v":0},{"$f":"SUM(H26:H38)","v":0}]
[]
["TOTAL DRIC",null,{"$f":"+C39+C25+C15","v":0},null,null,null,{"$f":"+G39+G25+G15","v":0},{"$f":"+H39+H25+H15","v":0}]

{"sheet":"Aide","index":2,"n_rows":29,"n_cols":3,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,null,"1.Inserrer votre maquette"]
[null,null,"L'onglet doit imperativement etre renommé \"MAQUETTE\""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"2.Choisissez dabord l'année puis le mois à l'aide des 2 listes déroulantes"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"3.Lancer la création des onglets correspondant au dates du mois selectionné"]