{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Saisie","Paramètres"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":383,"comments":1,"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":"Saisie","index":0,"n_rows":64,"n_cols":9,"rows_kept":64,"cut":false,"hidden":false,"merged":[[0,2,1,2],[54,0,60,0],[54,1,54,8],[63,2,63,8],[45,1,45,8],[2,1,3,1],[4,1,4,8],[8,1,8,8],[16,1,16,8],[24,1,24,8],[32,1,32,8]]}
[null,null,0,null,null,"Intervenant"]
[null,null,null,null,null,null,null,"Semaine"]
[null,"Date",{"$f":"iso_from_semaine","v":""},{"$f":"IF(jour1=\"\",\"\",jour1+1)","v":""},{"$f":"IF(jour2=\"\",\"\",jour2+1)","v":""},{"$f":"IF(jour3=\"\",\"\",jour3+1)","v":""},{"$f":"IF(jour4=\"\",\"\",jour4+1)","v":""},{"$f":"IF(jour5=\"\",\"\",jour5+1)","v":""},{"$f":"IF(jour6=\"\",\"\",jour6+1)","v":""}]
[null,null,"LUNDI","MARDI","MERCREDI","JEUDI","VENDREDI","SAMEDI","DIMANCHE"]
[null,"INFORMATIONS"]
[null,"Type d'horaires*","","","","","","",""]
[null,"Lieu de départ","",{"$f":"lieu_fin_journee_precedent","v":""},"","","","",""]
[null,"Lieu fin de journée",{"$f":"m3_position_finale","v":""},{"$f":"m3_position_finale","v":""},{"$f":"m3_position_finale","v":""},{"$f":"m3_position_finale","v":""},{"$f":"m3_position_finale","v":""},{"$f":"m3_position_finale","v":""},{"$f":"m3_position_finale","v":""}]
[null,"MISSION 1 / TRAJET 1"]
[null,"Lieu d'arrivée (si trajet)"]
[null,"n° OF"]
[null,"Intervention"]
[null,"Mode de transport"]
[null,"Type de trajet"]
[null,"Heures d'entrée "]
[null,"Heures de sortie "]
[{"$f":"IF(COUNTIF(C18:I24,\"<>\")>0,\"x\",\"\")","v":""},"MISSION 2 / TRAJET 2"]
[null,"Lieu d'arrivée (si trajet)"]
[null,"n° OF"]
[null,"Intervention"]
[null,"Mode de transport"]
[null,"Type de trajet"]
[null,"Heures d'entrée "]
[null,"Heures de sortie "]
[{"$f":"IF(COUNTIF(C26:I32,\"<>\")>0,\"x\",\"\")","v":""},"MISSION 3 / TRAJET 3"]
[null,"Lieu d'arrivée (si trajet)"]
[null,"n° OF"]
[null,"Intervention"]
[null,"Mode de transport"]
[null,"Type de trajet"]
[null,"Heures d'entrée "]
[null,"Heures de sortie "]
[null,"SUIVI D'INTERVENTION"]
[null,"Choix Heures ZC"]
[null,"Heures ZC"]
[null,"Choix Port HV ou TEV"]
[null,"Port HV ou TEV"]
[null,"Choix Auto Prime Panier",{"$f":"IF(nuit<>0,FALSE,IF(OR(IFERROR(MATCH(lieu_depart,{0,\"\",\"???\",\"LA VOULTE\",\"CRUAS\",\"TRICASTIN\",\"SAINT ALBAN\",\"FRAMATOME ROMANS\",\"MARCOULE\"},0),0)=0,IFERROR(MATCH(m1_lieu_arrivee,{0,\"\",\"???\",\"LA VOULTE\",\"CRUAS\",\"TRICASTIN\",\"SAINT ALBAN\",\"FRAMATOME ROMANS\",\"MARCOULE\"},0),0)=0,IFERROR(MATCH(m2_lieu_arrivee,{0,\"\",\"???\",\"LA VOULTE\",\"CRUAS\",\"TRICASTIN\",\"SAINT ALBAN\",\"FRAMATOME ROMANS\",\"MARCOULE\"},0),0)=0,IFERROR(MATCH(m3_lieu_arrivee,{0,\"\",\"???\",\"CRUAS\",\"LA VOULTE\",\"TRICASTIN\",\"SAINT ALBAN\",\"FRAMATOME ROMANS\",\"MARCOULE\"},0),0)=0),TRUE,FALSE))","v":false},{"$f":"IF(nuit<>0,FALSE,IF(OR(IFERROR(MATCH(lieu_depart,{0,\"\",\"???\",\"LA VOULTE\",\"CRUAS\",\"TRICASTIN\",\"SAINT ALBAN\",\"FRAMATOME ROMANS\",\"MARCOULE\"},0),0)=0,IFERROR(MATCH(m1_lieu_arrivee,{0,\"\",\"???\",\"LA VOULTE\",\"CRUAS\",\"TRICASTIN\",\"SAINT ALBAN\",\"FRAMATOME ROMANS\",\"MARCOULE\"},0),0)=0,IFERROR(MATCH(m2_lieu_arrivee,{0,\"\",\"???\",\"LA VOULTE\",\"CRUAS\",\"TRICASTIN\",\"SAINT ALBAN\",\"FRAMATOME ROMANS\",\"MARCOULE\"},0),0)=0,IFERROR(MATCH(m3_lieu_arrivee,{0,\"\",\"???\",\"CRUAS\",\"LA VOULTE\",\"TRICASTIN\",\"SAINT ALBAN\",\"FRAMATOME ROMANS\",\"MARCOULE\"},0),0)=0),TRUE,FALSE))","v":false},{"$f":"IF(nuit<>0,FALSE,IF(OR(IFERROR(MATCH(lieu_depart,{0,\"\",\"???\",\"LA VOULTE\",\"CRUAS\",\"TRICASTIN\",\"SAINT ALBAN\",\"FRAMATOME ROMANS\",\"MARCOULE\"},0),0)=0,IFERROR(MATCH(m1_lieu_arrivee,{0,\"\",\"???\",\"LA VOULTE\",\"CRUAS\",\"TRICASTIN\",\"SAINT ALBAN\",\"FRAMATOME ROMANS\",\"MARCOULE\"},0),0)=0,IFERROR(MATCH(m2_lieu_arrivee,{0,\"\",\"???\",\"LA VOULTE\",\"CRUAS\",\"TRICASTIN\",\"SAINT ALBAN\",\"FRAMATOME ROMANS\",\"MARCOULE\"},0),0)=0,IFERROR(MATCH(m3_lieu_arrivee,{0,\"\",\"???\",\"CRUAS\",\"LA VOULTE\",\"TRICASTIN\",\"SAINT ALBAN\",\"FRAMATOME ROMANS\",\"MARCOULE\"},0),0)=0),TRUE,FALSE))","v":false},{"$f":"IF(nuit<>0,FALSE,IF(OR(IFERROR(MATCH(lieu_depart,{0,\"\",\"???\",\"LA VOULTE\",\"CRUAS\",\"TRICASTIN\",\"SAINT ALBAN\",\"FRAMATOME ROMANS\",\"MARCOULE\"},0),0)=0,IFERROR(MATCH(m1_lieu_arrivee,{0,\"\",\"???\",\"LA VOULTE\",\"CRUAS\",\"TRICASTIN\",\"SAINT ALBAN\",\"FRAMATOME ROMANS\",\"MARCOULE\"},0),0)=0,IFERROR(MATCH(m2_lieu_arrivee,{0,\"\",\"???\",\"LA VOULTE\",\"CRUAS\",\"TRICASTIN\",\"SAINT ALBAN\",\"FRAMATOME ROMANS\",\"MARCOULE\"},0),0)=0,IFERROR(MATCH(m3_lieu_arrivee,{0,\"\",\"???\",\"CRUAS\",\"LA VOULTE\",\"TRICASTIN\",\"SAINT ALBAN\",\"FRAMATOME ROMANS\",\"MARCOULE\"},0),0)=0),TRUE,FALSE))","v":false},{"$f":"IF(nuit<>0,FALSE,IF(OR(IFERROR(MATCH(lieu_depart,{0,\"\",\"???\",\"LA VOULTE\",\"CRUAS\",\"TRICASTIN\",\"SAINT ALBAN\",\"FRAMATOME ROMANS\",\"MARCOULE\"},0),0)=0,IFERROR(MATCH(m1_lieu_arrivee,{0,\"\",\"???\",\"LA VOULTE\",\"CRUAS\",\"TRICASTIN\",\"SAINT ALBAN\",\"FRAMATOME ROMANS\",\"MARCOULE\"},0),0)=0,IFERROR(MATCH(m2_lieu_arrivee,{0,\"\",\"???\",\"LA VOULTE\",\"CRUAS\",\"TRICASTIN\",\"SAINT ALBAN\",\"FRAMATOME ROMANS\",\"MARCOULE\"},0),0)=0,IFERROR(MATCH(m3_lieu_arrivee,{0,\"\",\"???\",\"CRUAS\",\"LA VOULTE\",\"TRICASTIN\",\"SAINT ALBAN\",\"FRAMATOME ROMANS\",\"MARCOULE\"},0),0)=0),TRUE,FALSE))","v":false},{"$f":"IF(nuit<>0,FALSE,IF(OR(IFERROR(MATCH(lieu_depart,{0,\"\",\"???\",\"LA VOULTE\",\"CRUAS\",\"TRICASTIN\",\"SAINT ALBAN\",\"FRAMATOME ROMANS\",\"MARCOULE\"},0),0)=0,IFERROR(MATCH(m1_lieu_arrivee,{0,\"\",\"???\",\"LA VOULTE\",\"CRUAS\",\"TRICASTIN\",\"SAINT ALBAN\",\"FRAMATOME ROMANS\",\"MARCOULE\"},0),0)=0,IFERROR(MATCH(m2_lieu_arrivee,{0,\"\",\"???\",\"LA VOULTE\",\"CRUAS\",\"TRICASTIN\",\"SAINT ALBAN\",\"FRAMATOME ROMANS\",\"MARCOULE\"},0),0)=0,IFERROR(MATCH(m3_lieu_arrivee,{0,\"\",\"???\",\"CRUAS\",\"LA VOULTE\",\"TRICASTIN\",\"SAINT ALBAN\",\"FRAMATOME ROMANS\",\"MARCOULE\"},0),0)=0),TRUE,FALSE))","v":false},{"$f":"IF(nuit<>0,FALSE,IF(OR(IFERROR(MATCH(lieu_depart,{0,\"\",\"???\",\"LA VOULTE\",\"CRUAS\",\"TRICASTIN\",\"SAINT ALBAN\",\"FRAMATOME ROMANS\",\"MARCOULE\"},0),0)=0,IFERROR(MATCH(m1_lieu_arrivee,{0,\"\",\"???\",\"LA VOULTE\",\"CRUAS\",\"TRICASTIN\",\"SAINT ALBAN\",\"FRAMATOME ROMANS\",\"MARCOULE\"},0),0)=0,IFERROR(MATCH(m2_lieu_arrivee,{0,\"\",\"???\",\"LA VOULTE\",\"CRUAS\",\"TRICASTIN\",\"SAINT ALBAN\",\"FRAMATOME ROMANS\",\"MARCOULE\"},0),0)=0,IFERROR(MATCH(m3_lieu_arrivee,{0,\"\",\"???\",\"CRUAS\",\"LA VOULTE\",\"TRICASTIN\",\"SAINT ALBAN\",\"FRAMATOME ROMANS\",\"MARCOULE\"},0),0)=0),TRUE,FALSE))","v":false}]
[null,"Choix Annuler Prime Panier",false,false,false,false,false,false,false]
[null,"Choix Final Prime Panier",{"$f":"AND(choix_auto_prime_panier,NOT(choix_annuler_prime_panier))","v":false},false,false,false,false,false,false]
[null,"Prime Panier"]
[null,"Annuler Prime Panier"]
[null,"Ralentissements"]
[null,"Temps d'attente"]
[null,"Précision (si besoin)"]
[null,"FORFAIT DE DEPLACEMENT"]
[null,"Choix Auto Nuit",{"$f":"IF(m3_position_finale=\"\",FALSE,IF(m3_position_finale=\"LA VOULTE\",FALSE,TRUE))","v":false},{"$f":"IF(m3_position_finale=\"\",FALSE,IF(m3_position_finale=\"LA VOULTE\",FALSE,TRUE))","v":false},{"$f":"IF(m3_position_finale=\"\",FALSE,IF(m3_position_finale=\"LA VOULTE\",FALSE,TRUE))","v":false},{"$f":"IF(m3_position_finale=\"\",FALSE,IF(m3_position_finale=\"LA VOULTE\",FALSE,TRUE))","v":false},{"$f":"IF(m3_position_finale=\"\",FALSE,IF(m3_position_finale=\"LA VOULTE\",FALSE,TRUE))","v":false},{"$f":"IF(m3_position_finale=\"\",FALSE,IF(m3_position_finale=\"LA VOULTE\",FALSE,TRUE))","v":false},{"$f":"IF(m3_position_finale=\"\",FALSE,IF(m3_position_finale=\"LA VOULTE\",FALSE,TRUE))","v":false}]
[null,"Choix Annuler Nuit",false,false,false,false,false,false,false]
[null,"Choix Final Nuit",{"$f":"AND(choix_auto_nuit,NOT(choix_annuler_nuit))","v":false},false,false,false,false,false,false]
[null,"Nuit",{"$f":"IF(choix_final_nuit=TRUE,52,0)","v":0},0,0,0,0,0,0]
[null,"Annuler Nuit"]
[null,"Choix repas"]
[null,"Repas",{"$f":"IF(C$52=1,0,IF(C$52=2,20,IF(C$52=3,40-IF(choix_final_prime_panier=TRUE,20,0),0)))","v":0},0,0,0,0,0,0]
[null,"Total",{"$f":"nuit+repas","v":0},0,0,0,0,0,0]
[null,"REMBOURSEMENT FRAIS REEL"]
[null,"SNCF / RATP"]
[null,"Taxis / Parking"]
[null,"Hôtel"]
[null,"Restaurant"]
[null,"Autoroute"]
[null,"Gazole VU TTC"]
[null,"Gazole VT TTC "]
[null,"Divers frais généraux"]
[null,"Signature"]

{"sheet":"Paramètres","index":1,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
["Salarié","cd_pers","prenom","nom",null,"Type d'horaires",null,"Lieu"]
["        41 - Arnaud RUER",41,"Arnaud","RUER",null,"JOURNEE",null,"BELLEVILLE"]
["        64 - Benjamin CHEVENNEMENT",64,"Benjamin","CHEVENNEMENT",null,"EQUIPE (MATIN)",null,"BUGEY"]
["       644 - Damien BRES",644,"Damien","BRES",null,"EQUIPE (APRES-MIDI)",null,"CATTENOM"]
["        72 - Florent CAILLET",72,"Florent","CAILLET",null,null,null,"CHINON"]
["       649 - Guillaume SERRE",649,"Guillaume","SERRE",null,null,null,"CHOOZ"]
["       648 - Hulrich KUSZ",648,"Hulrich","KUSZ",null,"Type de transport",null,"CIVAUX"]
["        49 - Jean-Christophe ROCHE",49,"Jean-Christophe","ROCHE",null,"VOITURE",null,"CRUAS"]
["         6 - Laurent CHAIBI",6,"Laurent","CHAIBI",null,"TRAIN",null,"DAMPIERRE"]
["       637 - Maxime ROUBY",637,"Maxime","ROUBY",null,null,null,"FESSENHEIM"]
["       651 - MICKAEL PIMBERT",651,"MICKAEL","PIMBERT",null,null,null,"FLAMANVILLE"]
["       650 - Patrice BLANCHARD",650,"Patrice","BLANCHARD",null,"Type de trajet",null,"FRAMATOME ROMANS"]
["       609 - Rémy CHOUPEAU",609,"Rémy","CHOUPEAU",null,"ALLER SIMPLE",null,"GOLFECH "]
["       642 - Samy GUECHI",642,"Samy","GUECHI",null,"ALLER-RETOUR",null,"GRAVELINES"]
["       647 - Tom POTIER BUCHE",647,"Tom","POTIER BUCHE",null,null,null,"LA VOULTE"]
["       646 - William LEDUC",646,"William","LEDUC",null,null,null,"LE BLAYAIS"]
[null,null,null,null,null,null,null,"MARCOULE"]
[null,null,null,null,null,null,null,"NOGENT SUR SEINE"]
[null,null,null,null,null,null,null,"PALUEL"]
[null,null,null,null,null,null,null,"PENLY"]
[null,null,null,null,null,null,null,"SAINT  LAURENT "]
[null,null,null,null,null,null,null,"SAINT ALBAN"]
[null,null,null,null,null,null,null,"TRICASTIN"]