{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Guide","OGE->LIB","Regles","Budget","Anomalie"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":15,"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":"Guide","index":0,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
["ATTENTION"]
[1,"Ne pas changer le nom du fichier"]
[2,"Le traitement ne fonctionne pas si la fonction filtre automatique est activiée dans le fichier source : désactivier la fonction filtre automatique (Données / Filtre / Filtre automatique) dans le fichier MINX. I e : tant que le PC est sous Office 2000, les fitres auto doivent etre désactivés dans fichier source récupéré en automatique de MINX. ceci ne sera plus à faire en Office XP"]
[3,"L'année affichée sera celle de l'intercalaire budget (cellule B1)"]
[4,"Le mois affiché en \"REALISATION A FIN :\" sera celui choisi dans la fenêtre de lancement du traitement"]
[5,"Le nom du fichier ainsi que de ses onglets ne doivent pas être modifiés"]

{"sheet":"OGE->LIB","index":1,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":false,"merged":[[19,0,19,1]]}
["Direction","Section","Libellé",null,"Emplacement des\nfichiers après éclatement","W:\\1-BUDGETS\\2021\\Frais de fonctionnement"]
["0100"," ","DG",null,null,"exemple: c:\\mesDocuments\\"]
["0101",null,"DBD"]
["02xx",null,"DPE"]
["02xx","0200","DIR"]
["02xx","0201","PJT"]
["02xx","0202","DE"]
["02xx","0204","STE"]
["04xx",null,"DI"]
["04xx","0411","ETA"]
["04xx","0413","INFO"]
["04xx","0402","MET"]
["04xx","0403","APPROS"]
["04xx","0401","SAV"]
["04xx","0404","PROD"]
["0500",null,"DRH"]
["0600",null,"DAF"]
["0700",null,"DIR"]
["Fin"]
["Regroupement d'OGE",null,null,"Ne pas mettre le zéro devant le numéro d'OGE"]
["DE","SUR"]
["0201","0200",null,"permet de faire des regroupements d' OGE de section ou de direction sans section sur les états "]
["0201","0200",null," ex : 500 sur 100"]
["0202","0200",null,"  600 SUR 100"]
["0204","0200"]
["0300","0100"]
["Fin"]

{"sheet":"Regles","index":2,"n_rows":209,"n_cols":3,"rows_kept":209,"cut":false,"hidden":false,"merged":[[18,0,18,1]]}
["OGE",null,"Les OGE sont compris entre x<= et >=x"]
[0,999]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Fin"]
["COMPTES",null,"Les comptes sont compris entre x<= et x>="]
[600000,620000]
[621500,628900]
[645800,651000]
[]
["Fin"]
["Regroupement de compte"]
["DE","SUR"]
[6161,6160]
[6162,6160]
[6163,6160]
[6167,6160]
[6212,6226]
[6242,6241]
[6248,6241]
[6110,6041]
[6155,6135]
[6236,6064]
[6271,6278]
[6225,6226]
[6255,6251]
[6228,6226]
[6026,6021]
[6166,6117]
[6164,6160]
[6168,6160]
[6122,6061]
[6021,6020]
[6024,6020]
[6170,6117]
["Fin"]
[]
[]
[" "," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["fuims78a"]

{"sheet":"Budget","index":3,"n_rows":49,"n_cols":21,"rows_kept":49,"cut":false,"hidden":false,"merged":[[2,12,2,15],[2,4,2,9]]}
["Budget ",2021]
[]
[null,null,null,null,"Section DI",null,null,null,null,null,null,null,"Section DDP"]
["N° Cptes","LIBELLES","DG","DI","ETA","APPROS","INFO","MET","SAV","PROD","DPE","DBD","DIR","PJT","DE","STE","DAF","DC","DRH","Fin",3]
[6020,"Matières cons, petits outillages, emballages",null,{"$f":"SUM(E5:J5)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C5:S5)-D5","v":0},{"$f":"T5/12*$U$4","v":0}]
[6041,"Achats d'études et de services",47000,{"$f":"SUM(E6:J6)","v":24000},4000,null,20000,null,null,null,10000,null,null,null,null,null,null,null,null,81000,{"$f":"T6/12*$U$4","v":20250}]
[6050,"Achats de composants",null,6000,2000,null,4000,null,null,null,5000,null,null,null,null,null,null,null,null,11000,2750]
[6051,"Achats mat et equipements incorpores",null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[6061,"Fournitures non stockables",8000,52000,52000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60000,15000]
[6063,"Fourni. entretien petits matériels",null,15000,12000,null,3000,null,null,null,6000,null,null,null,null,null,null,null,null,21000,5250]
[6064,"Fournitures administratives",null,37000,19000,null,18000,null,null,null,null,null,null,null,null,null,null,null,2000,39000,9750]
[6068,"Autres matières et fournitures",null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[6084,"Frais accessoires s/ achats",null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[6111,"Travaux informatique",null,83000,3000,null,80000,null,null,null,null,null,null,null,null,null,null,null,null,83000,20750]
[6112,"Impression reproduction",null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[6114,"Travaux de traduction",null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[6116,"Nettoyage et gardiennage",null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[6117,"Prestations générales diverses",null,163500,160000,3500,null,null,null,null,null,null,null,null,null,null,null,null,null,163500,40875]
[6132,"Location immobilière",null,462000,462000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,462000,115500]
[6135,"Location mobilière",50000,76000,45000,null,31000,null,null,null,1000,null,null,null,null,null,null,null,null,127000,31750]
[6151,"Entretien des bâtiments",null,1000,1000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1000,250]
[6152,"Entretien sur bien immobilier",null,3000,3000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3000,750]
[6153,"Entretien du materiel automobile",null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[6154,"Entretien des mach. et mat.",null,5000,null,null,null,5000,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C24:S24)-D24","v":5000},1250]
[6156,"Maintenance",null,224000,null,null,224000,null,null,null,2000,null,null,null,null,null,null,null,1000,227000,56750]
[6160,"Assurances",null,26000,26000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26000,6500]
[6180,"Documentations",5000,7500,2000,5500,null,null,null,null,null,null,null,null,null,null,null,null,null,12500,3125]
[6185,"Frais colloques salons",null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[6226,"Honoraires",70000,0,null,null,null,null,null,null,30000,null,null,null,null,null,46000,null,22000,168000,42000]
[6227,"Frais d'actes et de contentieux",null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[6231,"Annonces et insertions",7000,3000,3000,null,null,null,null,null,null,null,null,null,null,null,1000,null,2000,13000,3250]
[6234,"Cadeaux à la clientèle",null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[6236,"Catalogues, imprimés",null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[6238,"Divers (Dons, Pourboires)",2000,0,null,null,null,null,null,null,null,null,null,null,null,null,2000,null,4000,8000,2000]
[6241,"Transports divers",null,8000,8000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8000,2000]
[6251,"Voyages déplacements",20000,33000,{"$f":"2000+5000","v":7000},26000,null,null,null,null,10000,null,null,null,null,null,1000,null,null,64000,16000]
[6252,"Titres de transport",null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[6257,"Invitations receptions",8000,0,null,null,null,null,null,null,1000,null,null,null,null,null,null,null,null,9000,2250]
[6260,"Frais postaux",null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[6265,"Frais de télécommunication",null,121000,121000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,121000,30250]
[6278,"Services bancaires",null,0,null,null,null,null,null,null,null,null,null,null,null,null,10000,null,null,10000,2500]
[6281,"Concours divers Cotisations",8000,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8000,2000]
[6284,"Frais de recrutement",null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19000,19000,4750]
[6458,"Cotisations autres organismes",null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C44:S44)-D44","v":0},0]
["XXXX",null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
["Fin",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(T5:T45)","v":1750000},437500]
[]
[]
[null,"TOTAL",{"$f":"SUM(C5:C45)","v":225000},{"$f":"SUM(D5:D45)","v":1350000},930000,35000,380000,5000,0,0,65000,0,0,0,0,0,60000,0,50000,{"$f":"SUM(T5:T45)","v":1750000}]

{"sheet":"Anomalie","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[[0,1,1,1]]}