{"text_format":"2","workbook":"xls","n_sheets":4,"sheets":["Résultats 2021","Dépenses Fonctionnement","Recettes Fonctionnement","Investissement"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Résultats 2021","index":0,"n_rows":33,"n_cols":4,"rows_kept":33,"cut":false,"hidden":false,"merged":[[19,0,19,2],[20,0,20,1],[21,0,21,1],[22,0,22,1],[25,0,25,2],[26,0,26,2],[12,0,12,2],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[17,0,17,1],[5,0,5,2],[6,0,6,1],[7,0,7,1],[8,0,8,1],[9,0,9,1],[10,0,10,1]],"flags":["formulas_cached_only"]}
["Budget Primitif 2022"]
["10900 - Commune de ST JULIA"]
["Budget principal"]
["Résultats et affectation"]
[]
["Investissement"]
[" Excédent 2021 : ",null,34004.57]
["Déficit 2021 :",null,0]
["Résultats antérieurs :",null,-11073.69]
["Excédent général (à reprendre en 2022) :",null,22930.879999999997]
["Déficit général (à reprendre en 2022) :",null,false]
[]
["Fonctionnement"]
[" Excédent 2021 : ",null,20006.37]
["Déficit 2021 :",null,0]
["Résultats antérieurs :",null,173394.84]
["Excédent général (à reprendre en 2022) :",null,193401.21]
["Déficit général (à reprendre en 2022) :",null,false]
[]
["Restes à réaliser 2021"]
["Recettes RAR",null,0]
["Dépenses RAR",null,123700]
["Solde RAR",null,-123700]
[]
["Affectation sur exercice 2022 :"]
["1068 - Affectation en investissement (pour couvrir le déficit et les RAR) :",null,null,100769.12]
["002 - Reprise du solde en fonctionnement :",null,null,92632.09]
[]
[null,null,"Pour information minimum à affecter en investissement :",100769.12]
[]
[null,"Résultat de clôture 2021 Investissement :",22930.879999999997]
[null,"Résultat de clôture 2021 Fonctionnement :",193401.21]
[null,"Résultat de clôture 2021 toutes sections :",216332.09]

{"sheet":"Dépenses Fonctionnement","index":1,"n_rows":51,"n_cols":7,"rows_kept":51,"cut":false,"hidden":false,"merged":[[46,4,46,5],[48,4,48,5],[50,4,50,5]],"flags":["formulas_cached_only"]}
["011","CHARGES A CARACTERE GENERAL",84324.93,null,"012","CHARGES DE PERSONNEL",99465]
[6042,"achats prestation service",null,null,6332,"cotisation FNAL",65]
[60611,"eau assainissement",1000,null,6336,"cotisation centre gestion",1300]
[60612,"énergie électricité",6500,null,6338,"cotisations autres",200]
[60621,"combustible",10000,null,6411,"personnel titulaire",60000]
[60622,"carburant",2500,null,6413,"personnel non titulaire",5000]
[60623,"alimentation",200,null,64168,"Emplois d'insertion"]
[60624,null,null,null,6451,"cotisation urssaf",7500]
[60628,null,3000,null,6453,"cotisation caisse retraite",14500]
[60631,"produits d'entretien",500,null,6454,"assedic",350]
[60632,"petit matériel",3000,null,6455,"cotisation assurance personnel",6000]
[60636,"vêtement travail",250,null,6456,"FNC",3000]
[6064,"fournitures administratives",1300,null,6474,null,850]
[6068,null,null,null,6475,"médecine travail",400]
[611,"prestations de services",null,null,6478,null,300]
[6135,"locations",1500]
[61521,"entretien terrain",null,null,65,"AUTRES CHARGES DE GESTION",169339.16]
[61522,"entretien bâtiment",14574.93,null,6531,"indemnités",20000]
[61523,"entretien voirie",10000,null,6532,"frais de missions"]
[61524,"entretien bois et forêt",null,null,6533,"cotisation retraite",900]
[61551,"entretien matériel roulant",1000,null,6535,"formation",200]
[61558,"entretien biens mobiliers",5000,null,6541,"créances irrécouvrables"]
[6156,"maintenance",3200,null,65548,"organisme rgpt",100000]
[6161,"assurance",6000,null,6558,"autres contributions"]
[6168,null,1200,null,65736,"subvention ccas",5500]
[6182,"documentation générale",300,null,6521,"déficit lotissement",36739.16]
[6184,null,1000,null,6574,"subvention association",6000]
[6218,"personnel extérieur",2500]
[6226,"honoraires",null,null,66,"CHARGES FINANCIERES",4000]
[6228,null,800,null,6611,"intérêts",4000]
[6231,"annonces insertions"]
[6232,"fêtes cérémonies",1000,null,67,"CHARGES EXCEPTIONNELLES",1000]
[6238,"divers",null,null,673,null,1000]
[627,"Frais bancaires",500]
[6257,"réceptions",1600,null,"014","ATTENUATION DE PRODUITS",19450]
[6261,"affranchissement",700,null,"739211","Attribution compensation"]
[6262,"téléphone",3000,null,"739221","FNGIR",17450]
[6281,"concours cotisations",200,null,"739223","FPIC",2000]
[6283,null,500,null,"73928","Autres prélèvements"]
[62876,"remboursement CC (actes ADS)"]
[63512,"taxe foncière",1500,null,"O42","Transferts entre section",0]
[{"$nulls":4},68,"dotations aux amortissements"]
[]
[null,"Réserves : ",0,null,"023","VIREMENT SECTION INVESTISSEMENT",0]
[{"$nulls":4},"OO2","Déficit antérieur reporté",0]
[]
[{"$nulls":4},"TOTAL DES DEPENSES",null,377579.08999999997]
[]
[{"$nulls":4},"TOTAL DES RECETTES (pour information) ",null,377579.08999999997]
[]
[{"$nulls":4},"Contrôle Équilibre (RECETTES – DEPENSES)",null,0]

{"sheet":"Recettes Fonctionnement","index":2,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[[14,0,14,2],[19,4,19,5]],"flags":["formulas_cached_only"]}
[70,"PRODUITS GESTION COURANTE",23400,null,75,"AUTRES PRODUITS GESTION",8600]
[70311,"concession cimetière",0,null,752,"locations",8600]
[70323,"redevance occupation domaine public",1200,null,758,"produits divers"]
[70611]
[706811,null,200,null,"013","ATTENUATIONS DE CHARGES",0]
[70878,"remb frais autres redevables",22000,null,6419,"remboursement sur rémunération"]
[{"$nulls":4},6459,"remboursement sur charges"]
[]
[73,"IMPOTS ET TAXES",185127,null,76,"PRODUITS FINANCIERS",0]
[73111,"Impôts locaux",171313,null,762,"parts sociales"]
[73112,"CVAE"]
[73211,"Attribution compensation",5894]
[73223,"FPIC",7920,null,77,"OPERATIONS EXCEPTIONNELLES"]
[7381,"taxe additionnelle droits mutation"]
[{"$nulls":4},"OO2","EXCEDENT ANTERIEUR REPORTE",92632.09]
[74,"DOTATIONS PARTICIPATIONS",67820]
[7411,"DGF",37765,null,"O42","Transfert entre sections",0]
[74121,"DSR",11834,null,777,"Reprise subventions"]
[74127,"Dotation Nationale péréquation",1344]
[742,"Dotation élus locaux",4550,null,"TOTAL DES RECETTES",null,377579.08999999997]
[744,"FCTVA",0]
[7482,"Compensation taxe droit de mutation",9000]
[74832,"fonds départemental TP"]
[74833,"compensation TP"]
[74834,"compensation TF",3327]
[74835,"compensation TH"]

{"sheet":"Investissement","index":3,"n_rows":29,"n_cols":9,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,0,0,3],[0,5,0,8]],"flags":["formulas_cached_only"]}
["Dépenses",{"$nulls":4},"Recettes"]
["Nature","RAR","Mesures nouvelles","Budget ",null,"Nature","RAR","Mesures nouvelles","Budget "]
["001 - déficit 2021",null,null,0,null,"001 – excédent 2021",null,null,22930.879999999997]
["Emprunts (capital)",null,null,13500,null,"Affectation résultat 2021 (TR 1068)",null,null,100769.12]
[{"$nulls":5},"021 - Autofinancement"]
["Caution",null,null,500,null,"Caution",null,null,500]
[{"$nulls":5},"FCTVA",null,null,2000]
[{"$nulls":5},"Taxe aménagement",null,null,4000]
[{"$nulls":5},"Emprunts"]
[]
["CHAPITRES / PROGRAMMES 2022",123700,50400,174100,null,"Subventions",0,57900,57900]
["138 – Mare",98700,null,98700,null,"138 – Mare",null,41000,41000]
["141 – Aménagement espaces jeux",24500,null,24500,null,"141 – Aménagement espaces jeux",null,10200,10200]
["143 – Mobilier divers",500,null,500,null,"143 – Mobilier divers",null,null,0]
["144 – Matériels techniques",null,2000,2000,null,"144 – Matériels techniques",null,null,0]
["145 – Informatique",null,1500,1500,null,"145 – Informatique",null,null,0]
["146 – Travaux bâtiments",null,16000,16000,null,"146 – Travaux bâtiments",null,6700,6700]
["147 – Aménagement jardins partagés",null,10000,10000,null,"147 – Aménagement jardins partagés",null,null,0]
["148 – Frais études Bâtiments locatifs",null,10000,10000,null,"148 – Frais études Bâtiments locatifs",null,null,0]
["Divers",null,10900,10900]
[]
[{"$nulls":5},"024 – cessions"]
[]
["Transfert entre sections -  040",0,0,0,null,"Transfert entre sections -  040",null,null,0]
["Reprises subventions 13911** ",{"$nulls":4},"Amortissements 28*** ",null,null,0]
[]
["Total des dépenses",123700,50400,188100,null,"Total des recettes",null,null,188100]
[]
[{"$nulls":5},"Contrôle Équilibre (RECETTES – DEPENSES)",null,null,0]