{"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"]
["14900 – Lotissement ST JULIA"]
["Budget principal"]
["Résultats et affectation"]
[]
["Investissement"]
[" Excédent 2021 : ",null,0]
["Déficit 2021 :",null,35789.85]
["Résultats antérieurs :",null,-72529.01]
["Excédent général (à reprendre en 2022) :",null,false]
["Déficit général (à reprendre en 2022) :",null,-36739.159999999996]
[]
["Fonctionnement"]
[" Excédent 2021 : ",null,0]
["Déficit 2021 :",null,3210.15]
["Résultats antérieurs :",null,-3210.15]
["Excédent général (à reprendre en 2022) :",null,false]
["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,0]
[]
[null,null,"Pour information minimum à affecter en investissement :",0]
[]
[null,"Résultat de clôture 2021 Investissement :",-36739.159999999996]
[null,"Résultat de clôture 2021 Fonctionnement :",0]
[null,"Résultat de clôture 2021 toutes sections :",-36739.159999999996]

{"sheet":"Fonctionnement","index":1,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[[14,0,14,1],[14,4,14,5],[16,0,16,1]],"flags":["formulas_cached_only"]}
["011","CHARGES A CARACTERE GENERAL",0,null,70,"PRODUITS GESTION COURANTE",0]
[605,"Travaux (voies – réseaux)",0,null,7015,"Vente terrain Mur"]
[]
[]
[66,"CHARGES FINANCIERES",0]
[6611,"intérêts",null,null,75,"AUTRES PRODUITS GESTION",36739.16]
[{"$nulls":4},7552,"Prise en charge déficit par budget principal",36739.16]
[]
["O42","Transferts entre section",36739.16]
[71355,"variation stocks de terrains",36739.16,null,"O42","Transfert entre sections",0]
[{"$nulls":4},71355,"variation stocks de terrains",0]
["023","VIREMENT SECTION INVESTISSEMENT",0]
["OO2","Déficit antérieur reporté",0,null,"OO2","EXCEDENT ANTERIEUR REPORTE",false]
[]
["TOTAL DES DEPENSES",null,36739.16,null,"TOTAL DES RECETTES",null,36739.16]
[]
["Contrôle Équilibre (RECETTES – DEPENSES)",null,0]

{"sheet":"Investissement","index":2,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,0,1],[0,3,0,4],[16,2,16,3]],"flags":["formulas_cached_only"]}
["Dépenses",null,null,"Recettes"]
["Nature","Budget ",null,"Nature","Budget "]
["001 - déficit 2021",36739.159999999996,null,"001 – excédent 2021",false]
["Emprunts",null,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",0,null,"Subventions",0]
[]
[]
["Transfert entre sections -  040",0,null,"Transfert entre sections -  040",36739.16]
["Stocks terrains – 3555",0,null,"Stocks terrains – 3555",36739.16]
[]
["Total des dépenses",36739.159999999996,null,"Total des recettes",36739.16]
[]
[null,null,"Contrôle Équilibre (RECETTES – DEPENSES)",null,0]