{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Différents taux","Etat de frais de déplacement","Frais de déplacement","Paramètres"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":9,"comments":2,"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":"Différents taux","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Etat de frais de déplacement","index":1,"n_rows":41,"n_cols":25,"rows_kept":41,"cut":false,"hidden":false,"merged":[[3,14,3,15],[3,10,3,11],[7,7,7,8],[3,7,3,8],[4,7,4,8],[5,7,5,8],[4,17,5,17],[4,14,4,15],[4,5,4,6],[4,10,4,11],[4,12,4,13],[5,3,5,6],[5,14,5,15],[5,10,5,11],[6,21,7,21],[9,17,10,17],[9,15,9,16],[2,19,3,20],[9,19,10,19],[2,21,3,21],[2,15,2,16],[7,14,7,15],[9,21,9,24],[9,20,10,20],[2,10,2,14],[6,19,7,20],[6,14,6,15],[7,12,7,13],[3,16,3,17],[9,9,9,10],[27,3,27,4],[19,3,19,4],[6,3,6,6],[7,3,7,6],[6,12,6,13],[7,10,7,11],[6,10,6,11],[9,7,9,8],[6,7,6,8],[9,11,9,12],[2,0,7,0],[2,3,2,6],[18,3,18,4],[15,3,15,4],[34,15,35,16],[34,12,34,14],[35,12,35,14],[34,7,35,8],[32,0,32,8],[29,3,29,4],[20,3,20,4],[23,3,23,4],[13,3,13,4],[21,3,21,4],[14,3,14,4],[26,3,26,4],[0,1,0,17],[2,1,2,2],[3,1,3,2],[4,1,4,2],[22,3,22,4],[3,12,3,13],[9,13,9,14],[5,12,5,13],[11,3,11,4],[2,7,2,9],[6,1,6,2],[7,1,7,2],[9,5,9,6],[3,3,3,6],[4,3,4,4],[5,1,5,2],[38,2,38,3],[38,7,38,9],[38,4,38,6],[34,9,35,9],[34,3,35,5],[40,0,40,17],[32,9,32,17],[30,3,30,4],[16,3,16,4],[17,3,17,4],[24,3,24,4],[25,3,25,4],[34,2,35,2],[38,0,38,1],[36,15,36,16],[28,3,28,4],[38,10,38,11],[37,4,37,6],[37,0,37,3],[34,0,35,1],[37,7,37,10],[9,0,10,0],[9,1,10,1],[10,3,10,4],[9,2,9,4],[12,3,12,4]]}
[null,"Remplir l'état sous EXCEL en utilisant les cellules de couleur jaune clair. - Un formulaire complet et correctement renseigné sera traité d'autant plus rapidement.\nRéférences : NDS-19-PF-246 vB du 21/12/2019. Convention collective nationale 9200-19-DCC-GRH-001 applicable au 1/1/2019. Domaines fonctionnels actualisés 2021.\nAide à la saisie: lire les commentaires de cellule (signalés par un petit triangle rouge en haut à droite de la cellule) ->\nPour saisir un nouvel état, pour que soit mis à jour le suivi des km parcourus (cellule J6) et des repas indemnisés (cellule J8) et vider les lignes de détail, cliquer sur ->"]
["DT Auvergne-Rhône-Alpes"]
["DEMANDEUR","NOM Prénom :",null,null,null,null,null,"ORDRE DE MISSION ANNUEL",null,null,"AUTORISATION D'UTILISER LE VÉHICULE PERSONNEL",null,null,null,null,"Date de la décision :",null,null,null,"Si autorisation, nombre de km VP en instance :",null,{"$f":"SUM(N12:N31)","v":0}]
[null,"Catégorie de personnel :",null,"Agent de droit public",null,null,null,"Date de la décision :",null,null,"Nombre de kilomètres autorisés :",null,null,null,"Véhicule utilisé :"]
[null,"Résid. fam./admin. :",null,null,null,null,null,"Plafond de km :",null,null,"Tranche kilométrique :",null,"≤ 2 000 km",null,"de 2 001 à 10 000 km",null,"> 10 000 km","Totaux"]
[null,"Service :",null,null,null,null,null,"Km parcourus :",null,null,"Taux :",null,{"$f":"IF(ISERROR(VLOOKUP($Q$4,Paramètres!$A$5:$D$9,2,FALSE)),\"\",VLOOKUP($Q$4,Paramètres!$A$5:$D$9,2,FALSE))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($Q$4,Paramètres!$A$5:$D$9,3,FALSE)),\"\",VLOOKUP($Q$4,Paramètres!$A$5:$D$9,3,FALSE))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($Q$4,Paramètres!$A$5:$D$9,4,FALSE)),\"\",VLOOKUP($Q$4,Paramètres!$A$5:$D$9,4,FALSE))","v":""}]
[null,"Code fournisseur SAP :",null,null,null,null,null,"Plafond de repas :",null,null,"Kilomètres parcourus :",null,null,null,null,null,null,{"$f":"IF(SUM(M7:Q7)=0,\"\",SUM(M7:Q7))","v":""},null,"Si autorisation, nombre de repas en instance :",null,{"$f":"SUM(K12:K31)","v":0}]
[null,"Cpte bancaire (IBAN) :",null,null,null,null,null,"Repas indemnisés :",null,null,"Indemnité :",null,{"$f":"IF(ISERROR(M6*M7),\"\",M6*M7)","v":""},null,{"$f":"IF(ISERROR(O6*O7),\"\",O6*O7)","v":""},null,{"$f":"IF(ISERROR(Q6*Q7),\"\",Q6*Q7)","v":""},{"$f":"SUM(M8:Q8)","v":0}]
[]
["Domaine\nfonctionnel","OM A/P","Déplacement",null,null,"Départ",null,"Retour",null,"Repas",null,"Nuitées",null,"Frais de transport",null,"Autres frais",null,"Total",null,"Montant repas","Montant nuitées","Montant indemnité km"]
[null,null,"Motif","Trajet effectué",null,"Date","Heure","Date","Heure","Taux","Nb","Taux","Nb","Km en VP","Tarif SNCF","Nature","Montant",null,null,null,null,"≤ 2 000 km","≤ 10 0000","> 10 000 km","Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(O12,Q12,T12:U12,Y12)=0,\"\",SUM(O12,Q12,T12:U12,Y12))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(J12,Paramètres!$A$13:$B$22,2,FALSE)),\"\",VLOOKUP(J12,Paramètres!$A$13:$B$22,2,FALSE)*K12)","v":""},{"$f":"IF(ISERROR(VLOOKUP(L12,Paramètres!$C$13:$D$22,2,FALSE)),\"\",VLOOKUP(L12,Paramètres!$C$13:$D$22,2,FALSE)*M12)","v":""},{"$f":"IF(N12<>\"\",IF((SUM($R$7,$N$12:N12)-N12)>2000,0,IF(AND(SUM($R$7,$N$12:N12)-N12=0,N12<=2000),N12,IF(SUM($R$7,$N$12)<2000,N12,2000-(SUM($R$7,$N$12:N12)-N12)))),\"\")","v":""},{"$f":"IF(N12<>\"\",IF((SUM($R$7,$N$12:N12)-N12)>10000,0,IF(SUM($R$7,$N$12:N12)<=2000,0,IF(SUM($R$7,$N$12:N12)>10000,10000-SUM($V$12:V12),SUM($N$12:N12)-SUM($V$12:V12)))),\"\")","v":""},{"$f":"IF(N12<>\"\",IF(SUM($N$12:N12)-SUM($V$12:W12)=0,0,SUM($N$12:N12)-SUM($V$12:W12)),\"\")","v":""},{"$f":"IF(ISERROR(SUM(V12*$M$6,W12*$O$6,X12*$Q$6)),\"\",SUM(V12*$M$6,W12*$O$6,X12*$Q$6))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(O13,Q13,T13:U13,Y13)=0,\"\",SUM(O13,Q13,T13:U13,Y13))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP(J13,Paramètres!$A$13:$B$22,2,FALSE)),\"\",VLOOKUP(J13,Paramètres!$A$13:$B$22,2,FALSE)*K13)","v":""},{"$f":"IF(ISERROR(VLOOKUP(L13,Paramètres!$C$13:$D$22,2,FALSE)),\"\",VLOOKUP(L13,Paramètres!$C$13:$D$22,2,FALSE)*M13)","v":""},{"$f":"IF(N13<>\"\",IF((SUM($R$7,$N$12:N13)-N13)>2000,0,IF(SUM($R$7,$N$12:N13)-N13=0,N13,IF(SUM($R$7,$N$12:N13)<2000,N13,2000-(SUM($R$7,$N$12:N13)-N13)))),\"\")","v":""},{"$f":"IF(N13<>\"\",IF((SUM($R$7,$N$12:N13)-N13)>10000,0,IF(SUM($R$7,$N$12:N13)<=2000,0,IF(SUM($R$7,$N$12:N13)>10000,10000-SUM($R$7,$V$12:V13,$W$12:W12),SUM($N$12:N13)-SUM($V$12:V13,$W$12:W12)))),\"\")","v":""},{"$f":"IF(N13<>\"\",IF(SUM($N$12:N13)-SUM($V$12:W13,$X$12:X12)=0,0,SUM($N$12:N13)-SUM($V$12:W13,$X$12:X12)),\"\")","v":""},{"$f":"IF(ISERROR(SUM(V13*$M$6,W13*$O$6,X13*$Q$6)),\"\",SUM(V13*$M$6,W13*$O$6,X13*$Q$6))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(ISERROR(VLOOKUP(J14,Paramètres!$A$13:$B$22,2,FALSE)),\"\",VLOOKUP(J14,Paramètres!$A$13:$B$22,2,FALSE)*K14)","v":""},{"$f":"IF(ISERROR(VLOOKUP(L14,Paramètres!$C$13:$D$22,2,FALSE)),\"\",VLOOKUP(L14,Paramètres!$C$13:$D$22,2,FALSE)*M14)","v":""},{"$f":"IF(N14<>\"\",IF((SUM($R$7,$N$12:N14)-N14)>2000,0,IF(SUM($R$7,$N$12:N14)-N14=0,N14,IF(SUM($R$7,$N$12:N14)<2000,N14,2000-(SUM($R$7,$N$12:N14)-N14)))),\"\")","v":""},{"$f":"IF(N14<>\"\",IF((SUM($R$7,$N$12:N14)-N14)>10000,0,IF(SUM($R$7,$N$12:N14)<=2000,0,IF(SUM($R$7,$N$12:N14)>10000,10000-SUM($R$7,$V$12:V14,$W$12:W13),SUM($N$12:N14)-SUM($V$12:V14,$W$12:W13)))),\"\")","v":""},{"$f":"IF(N14<>\"\",IF(SUM($N$12:N14)-SUM($V$12:W14,$X$12:X13)=0,0,SUM($N$12:N14)-SUM($V$12:W14,$X$12:X13)),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(ISERROR(VLOOKUP(J15,Paramètres!$A$13:$B$22,2,FALSE)),\"\",VLOOKUP(J15,Paramètres!$A$13:$B$22,2,FALSE)*K15)","v":""},{"$f":"IF(ISERROR(VLOOKUP(L15,Paramètres!$C$13:$D$22,2,FALSE)),\"\",VLOOKUP(L15,Paramètres!$C$13:$D$22,2,FALSE)*M15)","v":""},{"$f":"IF(N15<>\"\",IF((SUM($R$7,$N$12:N15)-N15)>2000,0,IF(SUM($R$7,$N$12:N15)-N15=0,N15,IF(SUM($R$7,$N$12:N15)<2000,N15,2000-(SUM($R$7,$N$12:N15)-N15)))),\"\")","v":""},{"$f":"IF(N15<>\"\",IF((SUM($R$7,$N$12:N15)-N15)>10000,0,IF(SUM($R$7,$N$12:N15)<=2000,0,IF(SUM($R$7,$N$12:N15)>10000,10000-SUM($R$7,$V$12:V15,$W$12:W14),SUM($N$12:N15)-SUM($V$12:V15,$W$12:W14)))),\"\")","v":""},{"$f":"IF(N15<>\"\",IF(SUM($N$12:N15)-SUM($V$12:W15,$X$12:X14)=0,0,SUM($N$12:N15)-SUM($V$12:W15,$X$12:X14)),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(ISERROR(VLOOKUP(J16,Paramètres!$A$13:$B$22,2,FALSE)),\"\",VLOOKUP(J16,Paramètres!$A$13:$B$22,2,FALSE)*K16)","v":""},{"$f":"IF(ISERROR(VLOOKUP(L16,Paramètres!$C$13:$D$22,2,FALSE)),\"\",VLOOKUP(L16,Paramètres!$C$13:$D$22,2,FALSE)*M16)","v":""},{"$f":"IF(N16<>\"\",IF((SUM($R$7,$N$12:N16)-N16)>2000,0,IF(SUM($R$7,$N$12:N16)-N16=0,N16,IF(SUM($R$7,$N$12:N16)<2000,N16,2000-(SUM($R$7,$N$12:N16)-N16)))),\"\")","v":""},{"$f":"IF(N16<>\"\",IF((SUM($R$7,$N$12:N16)-N16)>10000,0,IF(SUM($R$7,$N$12:N16)<=2000,0,IF(SUM($R$7,$N$12:N16)>10000,10000-SUM($R$7,$V$12:V16,$W$12:W15),SUM($N$12:N16)-SUM($V$12:V16,$W$12:W15)))),\"\")","v":""},{"$f":"IF(N16<>\"\",IF(SUM($N$12:N16)-SUM($V$12:W16,$X$12:X15)=0,0,SUM($N$12:N16)-SUM($V$12:W16,$X$12:X15)),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(ISERROR(VLOOKUP(J17,Paramètres!$A$13:$B$22,2,FALSE)),\"\",VLOOKUP(J17,Paramètres!$A$13:$B$22,2,FALSE)*K17)","v":""},{"$f":"IF(ISERROR(VLOOKUP(L17,Paramètres!$C$13:$D$22,2,FALSE)),\"\",VLOOKUP(L17,Paramètres!$C$13:$D$22,2,FALSE)*M17)","v":""},{"$f":"IF(N17<>\"\",IF((SUM($R$7,$N$12:N17)-N17)>2000,0,IF(SUM($R$7,$N$12:N17)-N17=0,N17,IF(SUM($R$7,$N$12:N17)<2000,N17,2000-(SUM($R$7,$N$12:N17)-N17)))),\"\")","v":""},{"$f":"IF(N17<>\"\",IF((SUM($R$7,$N$12:N17)-N17)>10000,0,IF(SUM($R$7,$N$12:N17)<=2000,0,IF(SUM($R$7,$N$12:N17)>10000,10000-SUM($R$7,$V$12:V17,$W$12:W16),SUM($N$12:N17)-SUM($V$12:V17,$W$12:W16)))),\"\")","v":""},{"$f":"IF(N17<>\"\",IF(SUM($N$12:N17)-SUM($V$12:W17,$X$12:X16)=0,0,SUM($N$12:N17)-SUM($V$12:W17,$X$12:X16)),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(ISERROR(VLOOKUP(J18,Paramètres!$A$13:$B$22,2,FALSE)),\"\",VLOOKUP(J18,Paramètres!$A$13:$B$22,2,FALSE)*K18)","v":""},{"$f":"IF(ISERROR(VLOOKUP(L18,Paramètres!$C$13:$D$22,2,FALSE)),\"\",VLOOKUP(L18,Paramètres!$C$13:$D$22,2,FALSE)*M18)","v":""},{"$f":"IF(N18<>\"\",IF((SUM($R$7,$N$12:N18)-N18)>2000,0,IF(SUM($R$7,$N$12:N18)-N18=0,N18,IF(SUM($R$7,$N$12:N18)<2000,N18,2000-(SUM($R$7,$N$12:N18)-N18)))),\"\")","v":""},{"$f":"IF(N18<>\"\",IF((SUM($R$7,$N$12:N18)-N18)>10000,0,IF(SUM($R$7,$N$12:N18)<=2000,0,IF(SUM($R$7,$N$12:N18)>10000,10000-SUM($R$7,$V$12:V18,$W$12:W17),SUM($N$12:N18)-SUM($V$12:V18,$W$12:W17)))),\"\")","v":""},{"$f":"IF(N18<>\"\",IF(SUM($N$12:N18)-SUM($V$12:W18,$X$12:X17)=0,0,SUM($N$12:N18)-SUM($V$12:W18,$X$12:X17)),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(ISERROR(VLOOKUP(J19,Paramètres!$A$13:$B$22,2,FALSE)),\"\",VLOOKUP(J19,Paramètres!$A$13:$B$22,2,FALSE)*K19)","v":""},{"$f":"IF(ISERROR(VLOOKUP(L19,Paramètres!$C$13:$D$22,2,FALSE)),\"\",VLOOKUP(L19,Paramètres!$C$13:$D$22,2,FALSE)*M19)","v":""},{"$f":"IF(N19<>\"\",IF((SUM($R$7,$N$12:N19)-N19)>2000,0,IF(SUM($R$7,$N$12:N19)-N19=0,N19,IF(SUM($R$7,$N$12:N19)<2000,N19,2000-(SUM($R$7,$N$12:N19)-N19)))),\"\")","v":""},{"$f":"IF(N19<>\"\",IF((SUM($R$7,$N$12:N19)-N19)>10000,0,IF(SUM($R$7,$N$12:N19)<=2000,0,IF(SUM($R$7,$N$12:N19)>10000,10000-SUM($R$7,$V$12:V19,$W$12:W18),SUM($N$12:N19)-SUM($V$12:V19,$W$12:W18)))),\"\")","v":""},{"$f":"IF(N19<>\"\",IF(SUM($N$12:N19)-SUM($V$12:W19,$X$12:X18)=0,0,SUM($N$12:N19)-SUM($V$12:W19,$X$12:X18)),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(ISERROR(VLOOKUP(J20,Paramètres!$A$13:$B$22,2,FALSE)),\"\",VLOOKUP(J20,Paramètres!$A$13:$B$22,2,FALSE)*K20)","v":""},{"$f":"IF(ISERROR(VLOOKUP(L20,Paramètres!$C$13:$D$22,2,FALSE)),\"\",VLOOKUP(L20,Paramètres!$C$13:$D$22,2,FALSE)*M20)","v":""},{"$f":"IF(N20<>\"\",IF((SUM($R$7,$N$12:N20)-N20)>2000,0,IF(SUM($R$7,$N$12:N20)-N20=0,N20,IF(SUM($R$7,$N$12:N20)<2000,N20,2000-(SUM($R$7,$N$12:N20)-N20)))),\"\")","v":""},{"$f":"IF(N20<>\"\",IF((SUM($R$7,$N$12:N20)-N20)>10000,0,IF(SUM($R$7,$N$12:N20)<=2000,0,IF(SUM($R$7,$N$12:N20)>10000,10000-SUM($R$7,$V$12:V20,$W$12:W19),SUM($N$12:N20)-SUM($V$12:V20,$W$12:W19)))),\"\")","v":""},{"$f":"IF(N20<>\"\",IF(SUM($N$12:N20)-SUM($V$12:W20,$X$12:X19)=0,0,SUM($N$12:N20)-SUM($V$12:W20,$X$12:X19)),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(ISERROR(VLOOKUP(J21,Paramètres!$A$13:$B$22,2,FALSE)),\"\",VLOOKUP(J21,Paramètres!$A$13:$B$22,2,FALSE)*K21)","v":""},{"$f":"IF(ISERROR(VLOOKUP(L21,Paramètres!$C$13:$D$22,2,FALSE)),\"\",VLOOKUP(L21,Paramètres!$C$13:$D$22,2,FALSE)*M21)","v":""},{"$f":"IF(N21<>\"\",IF((SUM($R$7,$N$12:N21)-N21)>2000,0,IF(SUM($R$7,$N$12:N21)-N21=0,N21,IF(SUM($R$7,$N$12:N21)<2000,N21,2000-(SUM($R$7,$N$12:N21)-N21)))),\"\")","v":""},{"$f":"IF(N21<>\"\",IF((SUM($R$7,$N$12:N21)-N21)>10000,0,IF(SUM($R$7,$N$12:N21)<=2000,0,IF(SUM($R$7,$N$12:N21)>10000,10000-SUM($R$7,$V$12:V21,$W$12:W20),SUM($N$12:N21)-SUM($V$12:V21,$W$12:W20)))),\"\")","v":""},{"$f":"IF(N21<>\"\",IF(SUM($N$12:N21)-SUM($V$12:W21,$X$12:X20)=0,0,SUM($N$12:N21)-SUM($V$12:W21,$X$12:X20)),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(ISERROR(VLOOKUP(J22,Paramètres!$A$13:$B$22,2,FALSE)),\"\",VLOOKUP(J22,Paramètres!$A$13:$B$22,2,FALSE)*K22)","v":""},{"$f":"IF(ISERROR(VLOOKUP(L22,Paramètres!$C$13:$D$22,2,FALSE)),\"\",VLOOKUP(L22,Paramètres!$C$13:$D$22,2,FALSE)*M22)","v":""},{"$f":"IF(N22<>\"\",IF((SUM($R$7,$N$12:N22)-N22)>2000,0,IF(SUM($R$7,$N$12:N22)-N22=0,N22,IF(SUM($R$7,$N$12:N22)<2000,N22,2000-(SUM($R$7,$N$12:N22)-N22)))),\"\")","v":""},{"$f":"IF(N22<>\"\",IF((SUM($R$7,$N$12:N22)-N22)>10000,0,IF(SUM($R$7,$N$12:N22)<=2000,0,IF(SUM($R$7,$N$12:N22)>10000,10000-SUM($R$7,$V$12:V22,$W$12:W21),SUM($N$12:N22)-SUM($V$12:V22,$W$12:W21)))),\"\")","v":""},{"$f":"IF(N22<>\"\",IF(SUM($N$12:N22)-SUM($V$12:W22,$X$12:X21)=0,0,SUM($N$12:N22)-SUM($V$12:W22,$X$12:X21)),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(ISERROR(VLOOKUP(J23,Paramètres!$A$13:$B$22,2,FALSE)),\"\",VLOOKUP(J23,Paramètres!$A$13:$B$22,2,FALSE)*K23)","v":""},{"$f":"IF(ISERROR(VLOOKUP(L23,Paramètres!$C$13:$D$22,2,FALSE)),\"\",VLOOKUP(L23,Paramètres!$C$13:$D$22,2,FALSE)*M23)","v":""},{"$f":"IF(N23<>\"\",IF((SUM($R$7,$N$12:N23)-N23)>2000,0,IF(SUM($R$7,$N$12:N23)-N23=0,N23,IF(SUM($R$7,$N$12:N23)<2000,N23,2000-(SUM($R$7,$N$12:N23)-N23)))),\"\")","v":""},{"$f":"IF(N23<>\"\",IF((SUM($R$7,$N$12:N23)-N23)>10000,0,IF(SUM($R$7,$N$12:N23)<=2000,0,IF(SUM($R$7,$N$12:N23)>10000,10000-SUM($R$7,$V$12:V23,$W$12:W22),SUM($N$12:N23)-SUM($V$12:V23,$W$12:W22)))),\"\")","v":""},{"$f":"IF(N23<>\"\",IF(SUM($N$12:N23)-SUM($V$12:W23,$X$12:X22)=0,0,SUM($N$12:N23)-SUM($V$12:W23,$X$12:X22)),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(ISERROR(VLOOKUP(J24,Paramètres!$A$13:$B$22,2,FALSE)),\"\",VLOOKUP(J24,Paramètres!$A$13:$B$22,2,FALSE)*K24)","v":""},{"$f":"IF(ISERROR(VLOOKUP(L24,Paramètres!$C$13:$D$22,2,FALSE)),\"\",VLOOKUP(L24,Paramètres!$C$13:$D$22,2,FALSE)*M24)","v":""},{"$f":"IF(N24<>\"\",IF((SUM($R$7,$N$12:N24)-N24)>2000,0,IF(SUM($R$7,$N$12:N24)-N24=0,N24,IF(SUM($R$7,$N$12:N24)<2000,N24,2000-(SUM($R$7,$N$12:N24)-N24)))),\"\")","v":""},{"$f":"IF(N24<>\"\",IF((SUM($R$7,$N$12:N24)-N24)>10000,0,IF(SUM($R$7,$N$12:N24)<=2000,0,IF(SUM($R$7,$N$12:N24)>10000,10000-SUM($R$7,$V$12:V24,$W$12:W23),SUM($N$12:N24)-SUM($V$12:V24,$W$12:W23)))),\"\")","v":""},{"$f":"IF(N24<>\"\",IF(SUM($N$12:N24)-SUM($V$12:W24,$X$12:X23)=0,0,SUM($N$12:N24)-SUM($V$12:W24,$X$12:X23)),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(ISERROR(VLOOKUP(J25,Paramètres!$A$13:$B$22,2,FALSE)),\"\",VLOOKUP(J25,Paramètres!$A$13:$B$22,2,FALSE)*K25)","v":""},{"$f":"IF(ISERROR(VLOOKUP(L25,Paramètres!$C$13:$D$22,2,FALSE)),\"\",VLOOKUP(L25,Paramètres!$C$13:$D$22,2,FALSE)*M25)","v":""},{"$f":"IF(N25<>\"\",IF((SUM($R$7,$N$12:N25)-N25)>2000,0,IF(SUM($R$7,$N$12:N25)-N25=0,N25,IF(SUM($R$7,$N$12:N25)<2000,N25,2000-(SUM($R$7,$N$12:N25)-N25)))),\"\")","v":""},{"$f":"IF(N25<>\"\",IF((SUM($R$7,$N$12:N25)-N25)>10000,0,IF(SUM($R$7,$N$12:N25)<=2000,0,IF(SUM($R$7,$N$12:N25)>10000,10000-SUM($R$7,$V$12:V25,$W$12:W24),SUM($N$12:N25)-SUM($V$12:V25,$W$12:W24)))),\"\")","v":""},{"$f":"IF(N25<>\"\",IF(SUM($N$12:N25)-SUM($V$12:W25,$X$12:X24)=0,0,SUM($N$12:N25)-SUM($V$12:W25,$X$12:X24)),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(ISERROR(VLOOKUP(J26,Paramètres!$A$13:$B$22,2,FALSE)),\"\",VLOOKUP(J26,Paramètres!$A$13:$B$22,2,FALSE)*K26)","v":""},{"$f":"IF(ISERROR(VLOOKUP(L26,Paramètres!$C$13:$D$22,2,FALSE)),\"\",VLOOKUP(L26,Paramètres!$C$13:$D$22,2,FALSE)*M26)","v":""},{"$f":"IF(N26<>\"\",IF((SUM($R$7,$N$12:N26)-N26)>2000,0,IF(SUM($R$7,$N$12:N26)-N26=0,N26,IF(SUM($R$7,$N$12:N26)<2000,N26,2000-(SUM($R$7,$N$12:N26)-N26)))),\"\")","v":""},{"$f":"IF(N26<>\"\",IF((SUM($R$7,$N$12:N26)-N26)>10000,0,IF(SUM($R$7,$N$12:N26)<=2000,0,IF(SUM($R$7,$N$12:N26)>10000,10000-SUM($R$7,$V$12:V26,$W$12:W25),SUM($N$12:N26)-SUM($V$12:V26,$W$12:W25)))),\"\")","v":""},{"$f":"IF(N26<>\"\",IF(SUM($N$12:N26)-SUM($V$12:W26,$X$12:X25)=0,0,SUM($N$12:N26)-SUM($V$12:W26,$X$12:X25)),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(ISERROR(VLOOKUP(J27,Paramètres!$A$13:$B$22,2,FALSE)),\"\",VLOOKUP(J27,Paramètres!$A$13:$B$22,2,FALSE)*K27)","v":""},{"$f":"IF(ISERROR(VLOOKUP(L27,Paramètres!$C$13:$D$22,2,FALSE)),\"\",VLOOKUP(L27,Paramètres!$C$13:$D$22,2,FALSE)*M27)","v":""},{"$f":"IF(N27<>\"\",IF((SUM($R$7,$N$12:N27)-N27)>2000,0,IF(SUM($R$7,$N$12:N27)-N27=0,N27,IF(SUM($R$7,$N$12:N27)<2000,N27,2000-(SUM($R$7,$N$12:N27)-N27)))),\"\")","v":""},{"$f":"IF(N27<>\"\",IF((SUM($R$7,$N$12:N27)-N27)>10000,0,IF(SUM($R$7,$N$12:N27)<=2000,0,IF(SUM($R$7,$N$12:N27)>10000,10000-SUM($R$7,$V$12:V27,$W$12:W26),SUM($N$12:N27)-SUM($V$12:V27,$W$12:W26)))),\"\")","v":""},{"$f":"IF(N27<>\"\",IF(SUM($N$12:N27)-SUM($V$12:W27,$X$12:X26)=0,0,SUM($N$12:N27)-SUM($V$12:W27,$X$12:X26)),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(ISERROR(VLOOKUP(J28,Paramètres!$A$13:$B$22,2,FALSE)),\"\",VLOOKUP(J28,Paramètres!$A$13:$B$22,2,FALSE)*K28)","v":""},{"$f":"IF(ISERROR(VLOOKUP(L28,Paramètres!$C$13:$D$22,2,FALSE)),\"\",VLOOKUP(L28,Paramètres!$C$13:$D$22,2,FALSE)*M28)","v":""},{"$f":"IF(N28<>\"\",IF((SUM($R$7,$N$12:N28)-N28)>2000,0,IF(SUM($R$7,$N$12:N28)-N28=0,N28,IF(SUM($R$7,$N$12:N28)<2000,N28,2000-(SUM($R$7,$N$12:N28)-N28)))),\"\")","v":""},{"$f":"IF(N28<>\"\",IF((SUM($R$7,$N$12:N28)-N28)>10000,0,IF(SUM($R$7,$N$12:N28)<=2000,0,IF(SUM($R$7,$N$12:N28)>10000,10000-SUM($R$7,$V$12:V28,$W$12:W27),SUM($N$12:N28)-SUM($V$12:V28,$W$12:W27)))),\"\")","v":""},{"$f":"IF(N28<>\"\",IF(SUM($N$12:N28)-SUM($V$12:W28,$X$12:X27)=0,0,SUM($N$12:N28)-SUM($V$12:W28,$X$12:X27)),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(ISERROR(VLOOKUP(J29,Paramètres!$A$13:$B$22,2,FALSE)),\"\",VLOOKUP(J29,Paramètres!$A$13:$B$22,2,FALSE)*K29)","v":""},{"$f":"IF(ISERROR(VLOOKUP(L29,Paramètres!$C$13:$D$22,2,FALSE)),\"\",VLOOKUP(L29,Paramètres!$C$13:$D$22,2,FALSE)*M29)","v":""},{"$f":"IF(N29<>\"\",IF((SUM($R$7,$N$12:N29)-N29)>2000,0,IF(SUM($R$7,$N$12:N29)-N29=0,N29,IF(SUM($R$7,$N$12:N29)<2000,N29,2000-(SUM($R$7,$N$12:N29)-N29)))),\"\")","v":""},{"$f":"IF(N29<>\"\",IF((SUM($R$7,$N$12:N29)-N29)>10000,0,IF(SUM($R$7,$N$12:N29)<=2000,0,IF(SUM($R$7,$N$12:N29)>10000,10000-SUM($R$7,$V$12:V29,$W$12:W28),SUM($N$12:N29)-SUM($V$12:V29,$W$12:W28)))),\"\")","v":""},{"$f":"IF(N29<>\"\",IF(SUM($N$12:N29)-SUM($V$12:W29,$X$12:X28)=0,0,SUM($N$12:N29)-SUM($V$12:W29,$X$12:X28)),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(ISERROR(VLOOKUP(J30,Paramètres!$A$13:$B$22,2,FALSE)),\"\",VLOOKUP(J30,Paramètres!$A$13:$B$22,2,FALSE)*K30)","v":""},{"$f":"IF(ISERROR(VLOOKUP(L30,Paramètres!$C$13:$D$22,2,FALSE)),\"\",VLOOKUP(L30,Paramètres!$C$13:$D$22,2,FALSE)*M30)","v":""},{"$f":"IF(N30<>\"\",IF((SUM($R$7,$N$12:N30)-N30)>2000,0,IF(SUM($R$7,$N$12:N30)-N30=0,N30,IF(SUM($R$7,$N$12:N30)<2000,N30,2000-(SUM($R$7,$N$12:N30)-N30)))),\"\")","v":""},{"$f":"IF(N30<>\"\",IF((SUM($R$7,$N$12:N30)-N30)>10000,0,IF(SUM($R$7,$N$12:N30)<=2000,0,IF(SUM($R$7,$N$12:N30)>10000,10000-SUM($R$7,$V$12:V30,$W$12:W29),SUM($N$12:N30)-SUM($V$12:V30,$W$12:W29)))),\"\")","v":""},{"$f":"IF(N30<>\"\",IF(SUM($N$12:N30)-SUM($V$12:W30,$X$12:X29)=0,0,SUM($N$12:N30)-SUM($V$12:W30,$X$12:X29)),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(ISERROR(VLOOKUP(J31,Paramètres!$A$13:$B$22,2,FALSE)),\"\",VLOOKUP(J31,Paramètres!$A$13:$B$22,2,FALSE)*K31)","v":""},{"$f":"IF(ISERROR(VLOOKUP(L31,Paramètres!$C$13:$D$22,2,FALSE)),\"\",VLOOKUP(L31,Paramètres!$C$13:$D$22,2,FALSE)*M31)","v":""},{"$f":"IF(N31<>\"\",IF((SUM($R$7,$N$12:N31)-N31)>2000,0,IF(SUM($R$7,$N$12:N31)-N31=0,N31,IF(SUM($R$7,$N$12:N31)<2000,N31,2000-(SUM($R$7,$N$12:N31)-N31)))),\"\")","v":""},{"$f":"IF(N31<>\"\",IF((SUM($R$7,$N$12:N31)-N31)>10000,0,IF(SUM($R$7,$N$12:N31)<=2000,0,IF(SUM($R$7,$N$12:N31)>10000,10000-SUM($R$7,$V$12:V31,$W$12:W30),SUM($N$12:N31)-SUM($V$12:V31,$W$12:W30)))),\"\")","v":""},{"$f":"IF(N31<>\"\",IF(SUM($N$12:N31)-SUM($V$12:W31,$X$12:X30)=0,0,SUM($N$12:N31)-SUM($V$12:W31,$X$12:X30)),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R12:R31)","v":0},null,{"$f":"IF(SUM(T12:T31)=0,\"\",SUM(T12:T31))","v":""},"","","","",""]
["Je soussigné, auteur du présent état, certifie son exactitude à tous égards et demande le réglement de la somme de  :",null,null,null,null,null,null,null,null,{"$f":"IF(R32>=1000,CHOOSE(INT(R32/1000),\"\",\"deux\",\"trois\",\"quatre\",\"cinq\",\"six\",\"sept\",\"huit\",\"neuf\",\"dix\",\"onze\",\"douze\",\"treize\",\"quartorze\",\"quinze\")&\" mille \",\"\")&IF(R32>=100,IF(INT((R32-(INT(R32/1000)*1000))/100)=0,\" \",CHOOSE(INT((R32-(INT(R32/1000)*1000))/100),\"\",\"deux\",\"trois\",\"quatre\",\"cinq\",\"six\",\"sept\",\"huit\",\"neuf\")&\" cent \"),\"\")&VLOOKUP(INT(R32-INT(R32/100)*100),Paramètres!M:N,2,FALSE)&\" euros\"&IF(R32-INT(R32)>0,\" et \"&VLOOKUP(ROUND((R32-INT(R32))*100,0),Paramètres!M:N,2,FALSE)&\" centimes.\",\"\")","v":"zéro euros"}]
[]
[" ",null,{"$f":"TODAY()","v":"2021-03-02"},"Signature du bénéficiaire",null,null,null," ",null,"Le",null,"Nom :",null,null,null,"Signature"]
[null,null,null,null,null,null,null,null,null,null,null,"Prénom :"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pour attestation de service fait."]
["IMPUTATION COMPTABLE DE LA DÉPENSE",null,null,null,"Comptabilité analytique",null,null,"Centre de coût :"]
["Comptabilité générale",null,"CHX-DEP : 625 610 00 :",null,{"$f":"IF(SUM(T32:U32)<>0,SUM(T32:U32),\"\")","v":""},null,null,"CHX-DEP : 625 112 00 :",null,null,{"$f":"IF(SUM(O12:O31,Q12:Q31,Y32)<>0,SUM(O12:O31,Q12:Q31,Y32),\"\")","v":""}]
[]
["ATTENTION : - joindre en les agrafant les justificatifs ORIGINAUX des dépenses engagées et les Ordres de Mission Ponctuels ou Annuels (l'OM Annuel n'est à joindre qu'au 1er remboursement de l'année) ;\n- Les frais de CARBURANT des véhicules administratifs ne sont pas des frais de déplacement."]

{"sheet":"Frais de déplacement","index":2,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Formulaire d'état de frais de déplacement :\n- Merci d'activer les macros en cliquant sur le bouton ci-dessus \"Activer le contenu\"."]

{"sheet":"Paramètres","index":3,"n_rows":196,"n_cols":27,"rows_kept":196,"cut":false,"hidden":true,"merged":[[1,14,6,14],[7,7,12,7],[0,10,0,11],[10,0,10,1],[10,2,10,3],[0,5,0,6],[1,7,6,7],[0,7,0,9]]}
["DT/DR","DT","Intitulé :","Méditerranée",null,"DOF utilisés pour les frais de déplacement (réF. MET_Définitions analytiques_2021)",null,"DOF à inclure dans la liste déroulante de saisie",null,null,"DOF inclus dans la liste déroulante de saisie",null,"NB","Alpha",null,"DT Auvergne-Rhône-Alpes","DT Bourgogne-Franche-Comté","DT Centre-Ouest-Aquitaine","DT Grand-Est","DT Midi-Méditerranée","DT Seine-Nord","DT Corse","DT Guyane","DT Martinique","DR Guadeloupe","DR La Réunion","Direction générale"]
[null,null,null,null,null,"1-FD99-GEFO","Gestion foncière","Indiquer dans cette zone les 8  domaines à proposer è","Z-FA49-AMDO","Autre étude et expertise",{"$f":"CONCATENATE(I2,\"/\",J2)","v":"Z-FA49-AMDO/Autre étude et expertise"},null,0,"zéro","Modification 2021 : Indiquer dans ces colonnes, les   domaines à proposer par DT è","1-FF99-SORE/Recherche & développement national","1-FA49-AMDO/Autre étude et expertise","1-FA49-AMDO/Autre étude et expertise","1-FA49-AMDO/Autre étude et expertise","1-FA49-AMDO/Autre étude et expertise","1-FA49-AMDO/Autre étude et expertise","1-FA49-AMDO/Autre étude et expertise","1-FA49-AMDO/Autre étude et expertise","1-FA49-AMDO/Autre étude et expertise","1-FA49-AMDO/Autre étude et expertise","1-FA49-AMDO/Autre étude et expertise","1-FA49-AMDO/Autre étude et expertise"]
[null,null,null,null,null,"1-FD99-GESU","Surveillance",null,"1-FD99-BOMA",{"$f":"VLOOKUP(I:I,F:G,2,FALSE)","v":"Martelage"},{"$f":"CONCATENATE(I3,\"/\",J3)","v":"1-FD99-BOMA/Martelage"},null,1,"un",null,"1-FF99-SORZ/Réseaux naturalistes nationaux","1-FD99-BOMA/Martelage","1-FD99-BOMA/Martelage","1-FD99-BOMA/Martelage","1-FD99-BOMA/Martelage","1-FD99-BOMA/Martelage","1-FD99-BOMA/Martelage","1-FD99-BOMA/Martelage","1-FD99-BOMA/Martelage","1-FD99-BOMA/Martelage","1-FD99-BOMA/Martelage","1-FD99-BOMA/Martelage"]
["Barème kilométrique à préciser","jusqu'à 2000 km","de 2001 à 10000 km","au delà de 10000 km",null,"1-FD99-GEPC","Chasse et pêche",null,"1-FF99-GESU","Surveillance","1-FF99-GESU/Surveillance",null,2,"deux",null,"2-CN60-ENDV/MIG Biodiversité","1-FF99-GESU/Surveillance","1-FF99-GESU/Surveillance","1-FF99-GESU/Surveillance","1-FF99-GESU/Surveillance","1-FF99-GESU/Surveillance","1-FF99-GESU/Surveillance","1-FF99-GESU/Surveillance","1-FF99-GESU/Surveillance","1-FF99-GESU/Surveillance","1-FF99-GESU/Surveillance","1-FF99-GESU/Surveillance"]
["PEF Voiture 5 CV et -",0.28999999999999998,0.36,0.21,null,"1-FD99-GECH","Licences dirigées chasse & pêche",null,"1-FF99-PNRN","RENECOFOR",{"$f":"CONCATENATE(I5,\"/\",J5)","v":"1-FF99-PNRN/RENECOFOR"},null,3,"trois",null,"8-SO10-FOTP/Formation tous personnels","2-CN20-INPA/Patrouilles incendie national","2-CN20-INPA/Patrouilles incendie national","2-CN20-INPA/Patrouilles incendie national","2-CN20-INPA/Patrouilles incendie national","2-CN20-INPA/Patrouilles incendie national","2-CN20-INPA/Patrouilles incendie national","2-CN20-INPA/Patrouilles incendie national","2-CN20-INPA/Patrouilles incendie national","2-CN20-INPA/Patrouilles incendie national","2-CN20-INPA/Patrouilles incendie national","2-CN20-INPA/Patrouilles incendie national"]
["PEF Voiture 6 et 7 CV",0.37,0.46,0.27,null,"1-FD99-GESA","Suivi de la mise en œuvre des aménagements et bilans de gestion ",null,"1-FF99-SORZ","Réseaux naturalistes nationaux","1-FF99-SORZ/Réseaux naturalistes nationaux",null,4,"quatre",null,"8-SO10-SYTP/Représentation tous personnels","2-CN30-LNDU/Gestion des dunes (agriculture)","2-CN30-LNDU/Gestion des dunes (agriculture)","2-CN30-LNDU/Gestion des dunes (agriculture)","2-CN30-LNDU/Gestion des dunes (agriculture)","2-CN30-LNDU/Gestion des dunes (agriculture)","2-CN30-LNDU/Gestion des dunes (agriculture)","2-CN30-LNDU/Gestion des dunes (agriculture)","2-CN30-LNDU/Gestion des dunes (agriculture)","2-CN30-LNDU/Gestion des dunes (agriculture)","2-CN30-LNDU/Gestion des dunes (agriculture)","2-CN30-LNDU/Gestion des dunes (agriculture)"]
["PEF Voiture 8 CV et +",0.41,0.5,0.28999999999999998,null,"1-FD99-AMDO","Autre étude et expertise",null,"2-CN20-INPA","Patrouilles incendie national","2-CN20-INPA/Patrouilles incendie national",null,5,"cinq",null,"8-SO30-STRA/Stratégie","2-CN40-ZDOM/MIG DOM","2-CN40-ZDOM/MIG DOM","2-CN40-ZDOM/MIG DOM","2-CN40-ZDOM/MIG DOM","2-CN40-ZDOM/MIG DOM","2-CN40-ZDOM/MIG DOM","2-CN40-ZDOM/MIG DOM","2-CN40-ZDOM/MIG DOM","2-CN40-ZDOM/MIG DOM","2-CN40-ZDOM/MIG DOM","2-CN40-ZDOM/MIG DOM"]
["CCN Indemnité petit déplacement",0.37,0.37,0.37,null,"1-FD99-BOMA","Martelage","Les trois colonnes suivantes ne sont plus utiles ( à maintenir pour la cohérence de l'ensemble) è","2-CN30-LNDU","Gestion des dunes (agriculture)","2-CN30-LNDU/Gestion des dunes (agriculture)",null,6,"six",null,"8-SO30-CMUN/Communication","2-CN60-ELAU/Autres MIG locales environnementales","2-CN60-ELAU/Autres MIG locales environnementales","2-CN60-ELAU/Autres MIG locales environnementales","2-CN60-ELAU/Autres MIG locales environnementales","2-CN60-ELAU/Autres MIG locales environnementales","2-CN60-ELAU/Autres MIG locales environnementales","2-CN60-ELAU/Autres MIG locales environnementales","2-CN60-ELAU/Autres MIG locales environnementales","2-CN60-ELAU/Autres MIG locales environnementales","2-CN60-ELAU/Autres MIG locales environnementales","2-CN60-ELAU/Autres MIG locales environnementales"]
["CCN Indemnité de covoiturage",{"$f":"B8*1.5","v":0.55499999999999994},{"$f":"C8*1.5","v":0.55499999999999994},0.55499999999999994,null,"1-FD99-BOCO","Commercialisation et mise en vente des bois",null,"2-CN40-ZDOM","MIG DOM","2-CN40-ZDOM/MIG DOM",null,7,"sept",null,"8-SO30-FICO/Finance - comptabilité","2-CN60-ENDV/MIG Biodiversité","2-CN60-ENDV/MIG Biodiversité","2-CN60-ENDV/MIG Biodiversité","2-CN60-ENDV/MIG Biodiversité","2-CN60-ENDV/MIG Biodiversité","2-CN60-ENDV/MIG Biodiversité","2-CN60-ENDV/MIG Biodiversité","2-CN60-ENDV/MIG Biodiversité","2-CN60-ENDV/MIG Biodiversité","2-CN60-ENDV/MIG Biodiversité","2-CN60-ENDV/MIG Biodiversité"]
[null,null,null,null,null,"1-FD99-BOSC","Suivi des coupes",null,"2-CN60-ELAU","Autres MIG locales environnementales","2-CN60-ELAU/Autres MIG locales environnementales",null,8,"huit",null,"8-SO20-IMSG/Immobilier - services généraux","3-CL99-SEAS/Assistance technique","3-CL99-SEAS/Assistance technique","3-CL99-SEAS/Assistance technique","3-CL99-SEAS/Assistance technique","3-CL99-SEAS/Assistance technique","3-CL99-SEAS/Assistance technique","3-CL99-SEAS/Assistance technique","3-CL99-SEAS/Assistance technique","3-CL99-SEAS/Assistance technique","3-CL99-SEAS/Assistance technique","3-CL99-SEAS/Assistance technique"]
["Taux de repas à préciser",null,"Taux de nuitées à préciser",null,null,"1-FD99-EXBO","Exploitation des bois",null,"2-CN60-ENDV","MIG Biodiversité","2-CN60-ENDV/MIG Biodiversité",null,9,"neuf",null,"8-SO20-AGSI/Système d'information","3-CZ99-SODE/Soutien activités concurrentielles","3-CZ99-SODE/Soutien activités concurrentielles","3-CZ99-SODE/Soutien activités concurrentielles","3-CZ99-SODE/Soutien activités concurrentielles","3-CZ99-SODE/Soutien activités concurrentielles","3-CZ99-SODE/Soutien activités concurrentielles","3-CZ99-SODE/Soutien activités concurrentielles","3-CZ99-SODE/Soutien activités concurrentielles","3-CZ99-SODE/Soutien activités concurrentielles","3-CZ99-SODE/Soutien activités concurrentielles","3-CZ99-SODE/Soutien activités concurrentielles"]
["Libellé","Taux","Libellé","Taux",null,"1-FD99-EXTP","Transport des bois",null,"2-CN70-PNSA","MIG Santé des forêts / Direction générale","2-CN70-PNSA/MIG Santé des forêts / Direction générale",null,10,"dix",null,"8-SO10-REHU/Ressources humaines","8-SO10-FOTP/Formation tous personnels","8-SO10-FOTP/Formation tous personnels","8-SO10-FOTP/Formation tous personnels","8-SO10-FOTP/Formation tous personnels","8-SO10-FOTP/Formation tous personnels","8-SO10-FOTP/Formation tous personnels","8-SO10-FOTP/Formation tous personnels","8-SO10-FOTP/Formation tous personnels","8-SO10-FOTP/Formation tous personnels","8-SO10-FOTP/Formation tous personnels","8-SO10-FOTP/Formation tous personnels"]
["Tournée PEF 14,00 €",14,"PEF : Paris 110 €",110,null,"1-FD99-TRRE","Travaux de régénération",null,"3-CL99-SEAS","Assistance technique",{"$f":"CONCATENATE(I13,\"/\",J13)","v":"3-CL99-SEAS/Assistance technique"},null,11,"onze",null,"Z-OUT9-PEFA/Personnels fonctionnaires & assimilés","8-SO10-SYTP/Représentation tous personnels","8-SO10-SYTP/Représentation tous personnels","8-SO10-SYTP/Représentation tous personnels","8-SO10-SYTP/Représentation tous personnels","8-SO10-SYTP/Représentation tous personnels","8-SO10-SYTP/Représentation tous personnels","8-SO10-SYTP/Représentation tous personnels","8-SO10-SYTP/Représentation tous personnels","8-SO10-SYTP/Représentation tous personnels","8-SO10-SYTP/Représentation tous personnels","8-SO10-SYTP/Représentation tous personnels"]
["Mission PEF 17,50 €",17.5,"PEF : communes > 200 000 hab 90 €",90,null,"1-FD99-TRPE","Autres travaux sur peuplement",null,"3-CZ99-SODE","Soutien activités concurrentielles","3-CZ99-SODE/Soutien activités concurrentielles",null,12,"douze",null,null,"8-SO30-STRA/Stratégie","8-SO30-STRA/Stratégie","8-SO30-STRA/Stratégie","8-SO30-STRA/Stratégie","8-SO30-STRA/Stratégie","8-SO30-STRA/Stratégie","8-SO30-STRA/Stratégie","8-SO30-STRA/Stratégie","8-SO30-STRA/Stratégie","8-SO30-STRA/Stratégie","8-SO30-STRA/Stratégie"]
[null,null,"PEF : autres communes 70 €",70,null,"1-FD99-TRIC","Travaux de création infrastructure",null,"8-SO10-FOTP","Formation tous personnels","8-SO10-FOTP/Formation tous personnels",null,13,"treize",null,null,"8-SO30-CMUN/Communication","8-SO30-CMUN/Communication","8-SO30-CMUN/Communication","8-SO30-CMUN/Communication","8-SO30-CMUN/Communication","8-SO30-CMUN/Communication","8-SO30-CMUN/Communication","8-SO30-CMUN/Communication","8-SO30-CMUN/Communication","8-SO30-CMUN/Communication","8-SO30-CMUN/Communication"]
[null,null,"PEF : handicapé 120 €",120,null,"1-FD99-TRIN","Autres travaux sur infrastructure",null,"8-SO10-SYTP","Représentation tous personnels","8-SO10-SYTP/Représentation tous personnels",null,14,"quatorze",null,null,"8-SO30-JURI/Juridique","8-SO30-JURI/Juridique","8-SO30-JURI/Juridique","8-SO30-JURI/Juridique","8-SO30-JURI/Juridique","8-SO30-JURI/Juridique","8-SO30-JURI/Juridique","8-SO30-JURI/Juridique","8-SO30-JURI/Juridique","8-SO30-JURI/Juridique","8-SO30-JURI/Juridique"]
["Repas CCN 2 MG 7,30 € sans justificatif",{"$f":"2*$B$23","v":7.3},"CCN communes > 100 000 hab 20 MG 73 €",{"$f":"20*$B$23","v":73},null,"1-FD99-ENEQ","Travaux environnementaux - Investissement",null,"8-SO30-STRA","Stratégie","8-SO30-STRA/Stratégie",null,15,"quinze",null,null,"8-SO30-FICO/Finance - comptabilité","8-SO30-FICO/Finance - comptabilité","8-SO30-FICO/Finance - comptabilité","8-SO30-FICO/Finance - comptabilité","8-SO30-FICO/Finance - comptabilité","8-SO30-FICO/Finance - comptabilité","8-SO30-FICO/Finance - comptabilité","8-SO30-FICO/Finance - comptabilité","8-SO30-FICO/Finance - comptabilité","8-SO30-FICO/Finance - comptabilité","8-SO30-FICO/Finance - comptabilité"]
["Repas CCN 5 MG 18,25 € avec justificatif",{"$f":"5*$B$23","v":18.25},"CCN : autres communes 18 MG 65,70 €",{"$f":"18*$B$23","v":65.7},null,"1-FD99-ENEN","Travaux environnementaux - Entretien",null,"8-SO30-CMUN","Communication","8-SO30-CMUN/Communication",null,16,"seize",null,null,"8-SO20-IMSG/Immobilier - services généraux","8-SO20-IMSG/Immobilier - services généraux","8-SO20-IMSG/Immobilier - services généraux","8-SO20-IMSG/Immobilier - services généraux","8-SO20-IMSG/Immobilier - services généraux","8-SO20-IMSG/Immobilier - services généraux","8-SO20-IMSG/Immobilier - services généraux","8-SO20-IMSG/Immobilier - services généraux","8-SO20-IMSG/Immobilier - services généraux","8-SO20-IMSG/Immobilier - services généraux","8-SO20-IMSG/Immobilier - services généraux"]
[null,null,"CCN : nuitée sommaire + repas 20 MG 73 €",{"$f":"20*$B$23","v":73},null,"1-FD99-TOEQ","Travaux touristiques - Equipement",null,"8-SO30-JURI","Juridique","8-SO30-JURI/Juridique",null,17,"dix-sept",null,null,"8-SO20-AGSI/Système d'information","8-SO20-AGSI/Système d'information","8-SO20-AGSI/Système d'information","8-SO20-AGSI/Système d'information","8-SO20-AGSI/Système d'information","8-SO20-AGSI/Système d'information","8-SO20-AGSI/Système d'information","8-SO20-AGSI/Système d'information","8-SO20-AGSI/Système d'information","8-SO20-AGSI/Système d'information","8-SO20-AGSI/Système d'information"]
["Repas RP 2 MG 7,30 € midi sans justificatif",{"$f":"2*$B$23","v":7.3},"RP : Paris 25 MG 91,25 €",{"$f":"25*$B$23","v":91.25},null,"1-FD99-TOEN","Travaux touristiques - Entretien",null,"8-SO30-FICO","Finance - comptabilité","8-SO30-FICO/Finance - comptabilité",null,18,"dix-huit",null,null,"8-SO10-REHU/Ressources humaines","8-SO10-REHU/Ressources humaines","8-SO10-REHU/Ressources humaines","8-SO10-REHU/Ressources humaines","8-SO10-REHU/Ressources humaines","8-SO10-REHU/Ressources humaines","8-SO10-REHU/Ressources humaines","8-SO10-REHU/Ressources humaines","8-SO10-REHU/Ressources humaines","8-SO10-REHU/Ressources humaines","8-SO10-REHU/Ressources humaines"]
["Repas RP 5 MG 18,25 € ",{"$f":"5*$B$23","v":18.25},"RP : communes > 100 000 hab 20 MG 73 €",{"$f":"20*$B$23","v":73},null,"1-FD99-TOPA","Tourisme patrimonial",null,"8-SO20-IMSG","Immobilier - services généraux","8-SO20-IMSG/Immobilier - services généraux",null,19,"dix-neuf",null,null,"Z-OUT9-PEFA/Personnels fonctionnaires & assimilés","Z-OUT9-PEFA/Personnels fonctionnaires & assimilés","Z-OUT9-PEFA/Personnels fonctionnaires & assimilés","Z-OUT9-PEFA/Personnels fonctionnaires & assimilés","Z-OUT9-PEFA/Personnels fonctionnaires & assimilés","Z-OUT9-PEFA/Personnels fonctionnaires & assimilés","Z-OUT9-PEFA/Personnels fonctionnaires & assimilés","Z-OUT9-PEFA/Personnels fonctionnaires & assimilés","Z-OUT9-PEFA/Personnels fonctionnaires & assimilés","Z-OUT9-PEFA/Personnels fonctionnaires & assimilés","Z-OUT9-PEFA/Personnels fonctionnaires & assimilés"]
["Dîner RP à Paris 7 MG 25,55 € ",{"$f":"7*$B$23","v":25.55},"RP : autres communes 18 MG 65,70 €",{"$f":"18*$B$23","v":65.7},null,"1-FD99-TOES","Espace Rambouillet",null,"8-SO20-AGSI","Système d'information","8-SO20-AGSI/Système d'information",null,20,"vingt"]
["Montant MG 2019",3.65,null,null,null,"1-FD99-ASIA","Information, accueil du public et communication",null,"8-SO10-REHU","Ressources humaines","8-SO10-REHU/Ressources humaines",null,21,"vingt et un"]
[null,null,null,null,null,"1-FD99-PNSA","Santé des Forets",null,"Z-OUT9-PEFA","Personnels fonctionnaires & assimilés","Z-OUT9-PEFA/Personnels fonctionnaires & assimilés",null,22,"vingt-deux"]
[null,null,null,null,null,"1-FD99-PNRN","RENECOFOR",null,null,null,null,null,23,"vingt-trois"]
[null,null,null,null,null,"1-FD99-TOCA","Ecole de la campagne",null,null,null,null,null,24,"vingt-quatre"]
[null,null,null,null,null,"1-FD99-MUBO","Bois domaniaux",null,null,null,null,null,25,"vingt-cinq"]
[null,null,null,null,null,"1-FD99-MUCH","Chasse et pêche",null,null,null,null,null,26,"vingt-six"]
[null,null,null,null,null,"1-FD99-MUCO","Concessions",null,null,null,null,null,27,"vingt-sept"]
[null,null,null,null,null,"1-FD99-MUXX","Produits ONF",null,null,null,null,null,28,"vingt-huit"]
[null,null,null,null,null,"1-FD83-TRRE","Plan de relance : travaux de régénération",null,null,null,null,null,29,"vingt-neuf"]
[null,null,null,null,null,"1-FD83-TRPE","Autres travaux sur peuplement",null,null,null,null,null,30,"trente"]
[null,null,null,null,null,"1-FD83-TRIC","Travaux de création infrastructure",null,null,null,null,null,31,"trente et un"]
[null,null,null,null,null,"1-FD83-TRIN","Autres travaux sur infrastructure",null,null,null,null,null,32,"trente-deux"]
[null,null,null,null,null,"1-FA49-GEFO","Gestion foncière",null,null,null,null,null,33,"trente-trois"]
[null,null,null,null,null,"1-FA49-GESU","Surveillance",null,null,null,null,null,34,"trente-quatre"]
[null,null,null,null,null,"1-FA49-GEPC","Chasse et pêche",null,null,null,null,null,35,"trente-cinq"]
[null,null,null,null,null,"1-FA49-GESA","Suivi de la mise en œuvre des aménagements et bilans de gestion ",null,null,null,null,null,36,"trente-six"]
[null,null,null,null,null,"1-FA49-AMDO","Autre étude et expertise",null,null,null,null,null,37,"trente-sept"]
[null,null,null,null,null,"1-FA49-BOMA","Martelage",null,null,null,null,null,38,"trente-huit"]
[null,null,null,null,null,"1-FA49-BOCO","Commercialisation et mise en vente des bois",null,null,null,null,null,39,"trente-neuf"]
[null,null,null,null,null,"1-FA49-BOSC","Suivi des coupes",null,null,null,null,null,40,"quarante"]
[null,null,null,null,null,"1-FA49-EXBO","Exploitation des bois",null,null,null,null,null,41,"quarante et un"]
[null,null,null,null,null,"1-FA49-EXTP","Transport des bois",null,null,null,null,null,42,"quarante-deux"]
[null,null,null,null,null,"1-FA49-TRRE","Travaux de régénération",null,null,null,null,null,43,"quarante-trois"]
[null,null,null,null,null,"1-FA49-TRPE","Autres travaux sur peuplement",null,null,null,null,null,44,"quarante-quatre"]
[null,null,null,null,null,"1-FA49-TRIC","Travaux de création infrastructure",null,null,null,null,null,45,"quarante-cinq"]
[null,null,null,null,null,"1-FA49-TRIN","Autres travaux sur infrastructure",null,null,null,null,null,46,"quarante-six"]
[null,null,null,null,null,"1-FA49-ENEQ","Travaux environnementaux - Investissement",null,null,null,null,null,47,"quarante-sept"]
[null,null,null,null,null,"1-FA49-ENEN","Travaux environnementaux - Entretien",null,null,null,null,null,48,"quarante-huit"]
[null,null,null,null,null,"1-FA49-TOEQ","Travaux touristiques - Equipement",null,null,null,null,null,49,"quarante-neuf"]
[null,null,null,null,null,"1-FA49-TOEN","Travaux touristiques - Entretien",null,null,null,null,null,50,"cinquante"]
[null,null,null,null,null,"1-FA49-ASIA","Information, accueil du public et communication",null,null,null,null,null,51,"cinquante et un"]
[null,null,null,null,null,"1-FA49-MUBO","Bois domaniaux",null,null,null,null,null,52,"cinquante-deux"]
[null,null,null,null,null,"1-FA49-MUCH","Chasse et pêche",null,null,null,null,null,53,"cinquante-trois"]
[null,null,null,null,null,"1-FA49-MUCO","Concessions",null,null,null,null,null,54,"cinquante-quatre"]
[null,null,null,null,null,"1-FA49-MUZZ","Autres produits du domaine",null,null,null,null,null,55,"cinquante-cinq"]
[null,null,null,null,null,"1-FA99-GEFO","Gestion foncière",null,null,null,null,null,56,"cinquante-six"]
[null,null,null,null,null,"1-FA99-GESU","Surveillance",null,null,null,null,null,57,"cinquante-sept"]
[null,null,null,null,null,"1-FA99-GEPC","Chasse et pêche",null,null,null,null,null,58,"cinquante-huit"]
[null,null,null,null,null,"1-FA99-GESA","Suivi de la mise en œuvre des aménagements et bilans de gestion ",null,null,null,null,null,59,"cinquante-neuf"]
[null,null,null,null,null,"1-FA99-AMDO","Autre étude et expertise",null,null,null,null,null,60,"soixante"]
[null,null,null,null,null,"1-FA99-BOMA","Martelage",null,null,null,null,null,61,"soixante et un"]
[null,null,null,null,null,"1-FA99-BOCO","Commercialisation et mise en vente des bois",null,null,null,null,null,62,"soixante-deux"]
[null,null,null,null,null,"1-FA99-BOSC","Suivi des coupes",null,null,null,null,null,63,"soixante-trois"]
[null,null,null,null,null,"1-FA99-EXBO","Exploitation des bois",null,null,null,null,null,64,"soixante-quatre"]
[null,null,null,null,null,"1-FA99-EXTP","Transport des bois",null,null,null,null,null,65,"soixante-cinq"]
[null,null,null,null,null,"1-FA99-TRRE","Travaux de régénération",null,null,null,null,null,66,"soixante-six"]
[null,null,null,null,null,"1-FA99-TRPE","Autres travaux sur peuplement",null,null,null,null,null,67,"soixante-sept"]
[null,null,null,null,null,"1-FA99-TRIC","Travaux de création infrastructure",null,null,null,null,null,68,"soixante-huit"]
[null,null,null,null,null,"1-FA99-TRIN","Autres travaux sur infrastructure",null,null,null,null,null,69,"soixante-neuf"]
[null,null,null,null,null,"1-FA99-ENEQ","Travaux environnementaux - Investissement",null,null,null,null,null,70,"soixante-dix"]
[null,null,null,null,null,"1-FA99-ENEN","Travaux environnementaux - Entretien",null,null,null,null,null,71,"soixante et onze"]
[null,null,null,null,null,"1-FA99-TOEQ","Travaux touristiques - Equipement",null,null,null,null,null,72,"soixante-douze"]
[null,null,null,null,null,"1-FA99-TOEN","Travaux touristiques - Entretien",null,null,null,null,null,73,"soixante-treize"]
[null,null,null,null,null,"1-FA99-ASIA","Information, accueil du public et communication",null,null,null,null,null,74,"soixante-quatorze"]
[null,null,null,null,null,"1-FA99-MUBO","Bois domaniaux",null,null,null,null,null,75,"soixante-quinze"]
[null,null,null,null,null,"1-FA99-MUCH","Chasse et pêche",null,null,null,null,null,76,"soixante-seize"]
[null,null,null,null,null,"1-FA99-MUCO","Concessions",null,null,null,null,null,77,"soixante dix-sept"]
[null,null,null,null,null,"1-FA99-MUZZ","Autres produits du domaine",null,null,null,null,null,78,"soixante dix-huit"]
[null,null,null,null,null,"1-FC99-GEFO","Gestion foncière",null,null,null,null,null,79,"soixante dix-neuf"]
[null,null,null,null,null,"1-FC99-GESU","Surveillance",null,null,null,null,null,80,"quatre-vingts"]
[null,null,null,null,null,"1-FC99-GEPC","Chasse et pêche",null,null,null,null,null,81,"quatre-vingt-un"]
[null,null,null,null,null,"1-FC99-GESA","Suivi de la mise en œuvre des aménagements et bilans de gestion ",null,null,null,null,null,82,"quatre-vingt-deux"]
[null,null,null,null,null,"1-FC99-AMDO","Autre étude et expertise",null,null,null,null,null,83,"quatre-vingt-trois"]
[null,null,null,null,null,"1-FC99-BOMA","Martelage",null,null,null,null,null,84,"quatre-vingt-quatre"]
[null,null,null,null,null,"1-FC99-BOCO","Commercialisation et mise en vente des bois",null,null,null,null,null,85,"quatre-vingt-cinq"]
[null,null,null,null,null,"1-FC99-BOSC","Suivi des coupes",null,null,null,null,null,86,"quatre-vingt-six"]
[null,null,null,null,null,"1-FC99-BOEG","Exploitation groupée",null,null,null,null,null,87,"quatre-vingt-sept"]
[null,null,null,null,null,"1-FC99-PNSA","Santé des Forets",null,null,null,null,null,88,"quatre-vingt-huit"]
[null,null,null,null,null,"1-FC99-ASIA","Information, éducation et communication auprès du public ",null,null,null,null,null,89,"quatre-vingt-neuf"]
[null,null,null,null,null,"1-FC99-RECU","Relations clients et usagers",null,null,null,null,null,90,"quatre-vingt-dix"]
[null,null,null,null,null,"1-FC99-MUGA","Frais de garderie",null,null,null,null,null,91,"quatre-vingt-onze"]
[null,null,null,null,null,"1-FC99-MUCP","Versement compensateur",null,null,null,null,null,92,"quatre-vingt-douze"]
[null,null,null,null,null,"1-FC01-GEFO","Gestion foncière",null,null,null,null,null,93,"quatre-vingt-treize"]
[null,null,null,null,null,"1-FC01-GESU","Surveillance",null,null,null,null,null,94,"quatre-vingt-quatorze"]
[null,null,null,null,null,"1-FC01-GEPC","Chasse et pêche",null,null,null,null,null,95,"quatre-vingt-quinze"]
[null,null,null,null,null,"1-FC01-GESA","Suivi de la mise en œuvre des aménagements et bilans de gestion ",null,null,null,null,null,96,"quatre-vingt-seize"]
[null,null,null,null,null,"1-FC01-AMDO","Autre étude et expertise",null,null,null,null,null,97,"quatre-vingt-dix-sept"]
[null,null,null,null,null,"1-FC01-BOMA","Martelage",null,null,null,null,null,98,"quatre-vingt-dix-huit"]
[null,null,null,null,null,"1-FC01-BOCO","Commercialisation et mise en vente des bois",null,null,null,null,null,99,"quatre-vingt-dix-neuf"]
[null,null,null,null,null,"1-FC01-BOSC","Suivi des coupes"]
[null,null,null,null,null,"1-FC01-BOEG","Exploitation groupée"]
[null,null,null,null,null,"1-FC01-ASIA","Information et accueil du public"]
[null,null,null,null,null,"1-FC01-RECU","Relations clients et usagers"]
[null,null,null,null,null,"1-FC01-MUGA","Frais de garderie"]
[null,null,null,null,null,"1-FF99-GESU","Surveillance"]
[null,null,null,null,null,"1-FF99-ASIE","Instruction des dossiers de l'Etat "]
[null,null,null,null,null,"1-FF99-AMAE","Elaboration des aménagements"]
[null,null,null,null,null,"1-FF99-AMDO","Autre étude et expertise"]
[null,null,null,null,null,"1-FF99-BOCO","Commercialisation et mise en vente des bois    "]
[null,null,null,null,null,"1-FF99-PNRN","RENECOFOR"]
[null,null,null,null,null,"1-FF99-PNSA","Santé des Forets"]
[null,null,null,null,null,"1-FF99-ETUD","Etudes particulières     "]
[null,null,null,null,null,"1-FF99-SORE","Recherche & développement national"]
[null,null,null,null,null,"1-FF99-SORZ","Réseaux naturalistes nationaux"]
[null,null,null,null,null,"1-FF99-SOPT","Developement technique"]
[null,null,null,null,null,"1-FF99-PLAU","Conventions phytosanitaires"]
[null,null,null,null,null,"2-PX09-87PC","87 Surveillance feux forêts"]
[null,null,null,null,null,"2-PX09-EURO","Autres projets européens"]
[null,null,null,null,null,"2-IN99-INCH","Exécution de chantier d'insertion"]
[null,null,null,null,null,"2-IN99-INCA","Encadrement de chantiers d'insertion"]
[null,null,null,null,null,"2-CN10-MNRT","Restauration des terrains (agriculture)"]
[null,null,null,null,null,"2-CN10-MNTX","Travaux RTM "]
[null,null,null,null,null,"2-CN10-MLAU","Autres locales RTM"]
[null,null,null,null,null,"2-CN20-INAP","APFM"]
[null,null,null,null,null,"2-CN20-INPA","Patrouilles incendie national"]
[null,null,null,null,null,"2-CN20-IZAU","Conventions zonales incendie"]
[null,null,null,null,null,"2-CN20-ILPA","Patrouilles incendie local"]
[null,null,null,null,null,"2-CN20-ILAU","Autres conventions locales incendie"]
[null,null,null,null,null,"2-CN30-LNDU","Gestion des dunes (agriculture)"]
[null,null,null,null,null,"2-CN30-LNTX","Travaux dune"]
[null,null,null,null,null,"2-CN30-LLAU","Autres conventions locales littoral"]
[null,null,null,null,null,"2-CN40-ZDOM","MIG DOM"]
[null,null,null,null,null,"2-CN60-ENVE","Vergers à graines"]
[null,null,null,null,null,"2-CN60-ENAB","MIG Arboretum des Barres "]
[null,null,null,null,null,"2-CN60-ENDV","MIG Biodiversité"]
[null,null,null,null,null,"2-CN60-PPIN","Pépinières de l'Etat"]
[null,null,null,null,null,"2-CN60-ELRN","Gestion de réserve naturelle nationale"]
[null,null,null,null,null,"2-CN60-ELCL","Gestion de forêt du CELRL"]
[null,null,null,null,null,"2-CN60-ELAU","Autres MIG locales environnementales"]
[null,null,null,null,null,"2-CN60-AV","Actions forestières locales "]
[null,null,null,null,null,"2-CN70-SNPP","Sanitaire National Peste Porcine"]
[null,null,null,null,null,"2-CN70-PNSA","MIG Santé des forêts / Direction générale"]
[null,null,null,null,null,"2-CN80-RNCA","Avalanche EPA CLPA"]
[null,null,null,null,null,"2-CN80-RNRM","Risque Naturel Risque Montagne"]
[null,null,null,null,null,"2-CN80-RNSU","Risque submersion marine"]
[null,null,null,null,null,"2-CN80-RNIC","Appui méthodologique prévention DFCI"]
[null,null,null,null,null,"2-CN80-RLAU","Risques naturels local hors DFCI"]
[null,null,null,null,null,"3-CZ99-SODE","Soutien activités concurrentielles"]
[null,null,null,null,null,"3-CP01-FIDI","Divers produits finis"]
[null,null,null,null,null,"3-CP01-OEBO","Exploitation des bois"]
[null,null,null,null,null,"3-CP01-OETR","Travaux patrimoniaux"]
[null,null,null,null,null,"3-CP01-EXDI","Diverses études & expertises"]
[null,null,null,null,null,"3-CP01-SEBO","Assistance technique pour exploitation"]
[null,null,null,null,null,"3-CP01-SEAS","Assistance technique hors exploitation"]
[null,null,null,null,null,"3-CP01-SEOE","Maîtrise d'œuvre sur infrastructure"]
[null,null,null,null,null,"3-CP01-SEDI","Diverses prestations de service"]
[null,null,null,null,null,"3-CP83-EXDI","Diverses études & expertises"]
[null,null,null,null,null,"3-CP83-OETR","Travaux patrimoniaux"]
[null,null,null,null,null,"3-CP83-SEDI","Diverses prestations de service"]
[null,null,null,null,null,"3-CP83-SEAS","Assistance technique hors exploitation"]
[null,null,null,null,null,"3-CP83-FIDI","Divers produits finis"]
[null,null,null,null,null,"3-CP99-FIDI","Divers produits finis"]
[null,null,null,null,null,"3-CP99-OEBO","Exploitation des bois"]
[null,null,null,null,null,"3-CP99-OETR","Travaux patrimoniaux"]
[null,null,null,null,null,"3-CP99-EXDI","Diverses études & expertises"]
[null,null,null,null,null,"3-CP99-SEBO","Assistance technique pour exploitation"]
[null,null,null,null,null,"3-CP99-SEAS","Assistance technique hors exploitation"]
[null,null,null,null,null,"3-CP99-SEOE","Maîtrise d'œuvre"]
[null,null,null,null,null,"3-CP99-SEDI","Diverses prestations de service"]
[null,null,null,null,null,"3-CL20-MCEN","Mesure compensatoire"]
[null,null,null,null,null,"3-CL99-FIDI","Divers produits finis"]
[null,null,null,null,null,"3-CL99-OEDI","Divers travaux"]
[null,null,null,null,null,"3-CL99-EXDI","Diverses études & expertises"]
[null,null,null,null,null,"3-CL99-SEAS","Assistance technique"]
[null,null,null,null,null,"3-CL99-SEOE","Maîtrise d'œuvre"]
[null,null,null,null,null,"3-CL99-SEVI","Animation nature (Visites pédagogiques)"]
[null,null,null,null,null,"3-CL99-SEDI","Diverses prestations de service"]
[null,null,null,null,null,"8-SO10-REHU","Ressources humaines"]
[null,null,null,null,null,"8-SO10-SYTP","Représentation tous personnels"]
[null,null,null,null,null,"8-SO10-FOTP","Formation tous personnels"]
[null,null,null,null,null,"8-SO20-IMSG","Immobilier - services généraux"]
[null,null,null,null,null,"8-SO20-AGSI","Système d'information"]
[null,null,null,null,null,"8-SO30-STRA","Stratégie"]
[null,null,null,null,null,"8-SO30-CMUN","Communication"]
[null,null,null,null,null,"8-SO30-JURI","Juridique"]
[null,null,null,null,null,"8-SO30-FICO","Finance - comptabilité"]
[null,null,null,null,null,"8-SO30-PILO","Pilotage"]
[null,null,null,null,null,"9-TR99-ATEL","Atelier bois"]
[null,null,null,null,null,"9-TR99-PPIN","Pépinières"]
[null,null,null,null,null,"Z-OUT2-PROF","Ouvriers forestiers"]
[null,null,null,null,null,"Z-OUT2-PROT","Ouvriers tuilés"]
[null,null,null,null,null,"Z-OUT2-PRAI","Emplois aidés"]
[null,null,null,null,null,"Z-OUT2-PRST","Stagiaires et apprentis"]
[null,null,null,null,null,"Z-OUT9-PEFA","Personnels fonctionnaires & assimilés"]