{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["Résultats 2021","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"]
["25900 – Assainissement ST JULIA"]
["Budget principal"]
["Résultats et affectation"]
[]
["Investissement"]
[" Excédent 2021 : ",null,0]
["Déficit 2021 :",null,-1321.46]
["Résultats antérieurs :",null,8111.63]
["Excédent général (à reprendre en 2022) :",null,6790.17]
["Déficit général (à reprendre en 2022) :",null,false]
[]
["Fonctionnement"]
[" Excédent 2021 : ",null,0]
["Déficit 2021 :",null,-1537.78]
["Résultats antérieurs :",null,4071.1]
["Excédent général (à reprendre en 2022) :",null,2533.3199999999997]
["Déficit général (à reprendre en 2022) :",null,false]
[]
["Restes à réaliser 2021"]
["Recettes RAR",null,0]
["Dépenses RAR",null,0]
["Solde RAR",null,0]
[]
["Affectation sur exercice 2022 :"]
["1068 - Affectation en investissement (pour couvrir le déficit et les RAR) :",null,null,0]
["002 - Reprise du solde en fonctionnement :",null,null,4071.1]
[]
[null,null,"Pour information minimum à affecter en investissement :",0]
[]
[null,"Résultat de clôture 2021 Investissement :",6790.17]
[null,"Résultat de clôture 2021 Fonctionnement :",2533.3199999999997]
[null,"Résultat de clôture 2021 toutes sections :",9323.49]

{"sheet":"Fonctionnement","index":1,"n_rows":34,"n_cols":7,"rows_kept":34,"cut":false,"hidden":false,"merged":[[4,4,5,6],[9,4,9,6],[31,0,31,1],[33,0,33,1],[33,4,33,5]],"flags":["formulas_cached_only"]}
["011","CHARGES A CARACTERE GENERAL",3600,null,70,"PRODUITS GESTION COURANTE",32829.5]
[6061,null,2700,null,70611,null,24100]
[6063,null,500,null,706121,null,2729.5]
[61558,null,null,null,70613,"Branchements",6000]
[6262,null,100]
[627,null,300]
[{"$nulls":4},73,"IMPOTS ET TAXES",0]
["012","CHARGES DE PERSONNEL",0]
[]
[]
[65,"AUTRES CHARGES DE GESTION",100,null,74,"DOTATIONS PARTICIPATIONS",4375]
[6541,null,100,null,741,null,2608]
[{"$nulls":4},747,null,1767]
[]
[66,"CHARGES FINANCIERES",15772.72]
[6611,"intérêts",15772.72,null,75,"AUTRES PRODUITS GESTION",0]
[]
[67,"CHARGES EXCEPTIONNELLES",100]
[673,null,100]
[{"$nulls":4},"013","ATTENUATIONS DE CHARGES",0]
["014","ATTENUATION DE PRODUITS",2729.5]
[706129,null,2729.5]
[]
["O42","Transferts entre section",34064.76,null,76,"PRODUITS FINANCIERS",0]
[68,"dotations aux amortissements",34064.76]
[]
["023","VIREMENT SECTION INVESTISSEMENT",0,null,77,"OPERATIONS EXCEPTIONNELLES",0]
["OO2","Déficit antérieur reporté",0]
[{"$nulls":4},"O42","Transfert entre sections",16689.16]
[null,"Réserves : ",null,null,777,"Reprise subventions",16689.16]
[]
["TOTAL DES DEPENSES",null,56366.98,null,"OO2","EXCEDENT ANTERIEUR REPORTE",2533.3199999999997]
[]
["Contrôle Équilibre (RECETTES – DEPENSES)",null,60,null,"TOTAL DES RECETTES",null,56426.98]

{"sheet":"Investissement","index":2,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,0,0,1],[0,3,0,4],[19,2,19,3]],"flags":["formulas_cached_only"]}
["Dépenses",null,null,"Recettes"]
["Nature","Budget ",null,"Nature","Budget "]
["001 - déficit 2021",0,null,"001 – excédent 2021",6790.17]
["Emprunts (capital)",18998.17,null,"Affectation résultat 2021 (TR 1068)",0]
[null,null,null,"021 - Autofinancement",0]
[null,null,null,"Emprunts"]
[null,null,null,"FCTVA"]
[]
[]
["CHAPITRES / PROGRAMMES 2022",5167.6,null,"Subventions",0]
["Divers (compte 2315)",5167.6]
[]
[]
[]
["Transfert entre sections -  040",16689.16,null,"Transfert entre sections -  040",34064.76]
["Reprises subventions 13911** ",16689.16,null,"Amortissements 28*** ",34064.76]
[]
["Total des dépenses",40854.92999999999,null,"Total des recettes",40854.93]
[]
[null,null,"Contrôle Équilibre (RECETTES – DEPENSES)",null,0]