{"text_format":"2","workbook":"xlsx","n_sheets":11,"sheets":["Macro-commandes","Coordonnées","Résultats","Ordinaire GE","Extraordinaire GE","DO fonctions","RO fonctions","DE fonctions","RE fonctions","Commentaires","Glossaire"],"not_rendered":{"charts":4,"images":2,"macros":0,"external_links":0,"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"}

{"sheet":"Macro-commandes","index":0,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,"Administration communale de:"]
[]
["Gestion informatique du document.","Commandes :"]
[]
["Cliquez sur la commande>>>"]
[]
[null,null,"Enregistré"]

{"sheet":"Coordonnées","index":1,"n_rows":37,"n_cols":18,"rows_kept":37,"cut":false,"hidden":false,"merged":[[22,0,22,6],[22,7,22,9],[6,4,9,14],[2,15,2,16],[0,9,1,14],[0,3,1,8],[0,0,1,2],[10,4,10,14],[19,7,19,16],[31,7,31,16],[28,7,28,16],[30,7,30,16],[26,7,26,9],[0,17,0,18],[1,17,1,18],[0,15,0,16],[1,15,1,16],[2,17,2,18],[24,7,24,9],[20,7,20,16],[16,7,16,16],[18,7,18,16],[29,7,29,16],[26,0,26,6],[18,0,18,6],[16,0,16,6],[14,0,14,6],[36,7,36,16],[28,0,28,6],[29,0,29,6],[30,0,30,6],[31,0,31,6],[33,0,33,6],[36,0,36,6],[34,7,34,16],[35,0,35,6],[35,7,35,16],[34,0,34,6],[24,0,24,6]]}
["Synthèse du Budget",null,null,"Administration communale de",{"$nulls":5},"SOMME-LEUZE",{"$nulls":5},"Code INS",null,91120]
[{"$nulls":15},"Exercice:",null,{"$f":"N27","v":2023}]
["Modèle officiel généré par l'application eComptes © SPW Intérieur et Action Sociale",{"$nulls":14},"Version:",null,1]
[]
[]
[]
[{"$nulls":4},"S Y N T H È S E  du  B U D G E T\r\nI N I T I A L"]
[]
[]
[]
[{"$nulls":4},"Module informatisé de publication des budgets annuels"]
[]
[]
[]
[]
[]
["Commune de :",{"$nulls":6},"SOMME-LEUZE"]
[]
["Adresse de l'administration:",{"$nulls":6},"Rue du Centre, 1"]
[{"$nulls":7},"5377 BAILLONVILLE"]
[{"$nulls":7},"sommeleuze.be"]
[]
["Date d’arrêt du budget par le conseil:",{"$nulls":6},"19/12/2022"]
[]
["Date d'approbation de la Tutelle:",{"$nulls":6},"23/01/2023"]
[]
["Type document:",{"$nulls":6},"Budget",null,null,null,"Exercice:",null,2023]
[]
["Directeur Général:",{"$nulls":6},"Isabelle PICARD "]
["Tél:",{"$nulls":6},"086 32 21 22"]
["Fax:",{"$nulls":6},"086 32 33 38"]
["Email:",{"$nulls":6},"isabelle.picard@sommeleuze.be"]
[]
["Directeur Financier:",{"$nulls":6},"Anne-Catherine GOFFIN"]
["Tél:",{"$nulls":6},"086 32 02 58"]
["Fax:",{"$nulls":6},"086 32 33 38"]
["Email:",{"$nulls":6},"annecatherine.goffin@sommeleuze.be"]

{"sheet":"Résultats","index":2,"n_rows":11,"n_cols":20,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,15,1,16],[1,17,1,18],[0,0,1,2],[0,3,1,8],[0,9,1,14],[0,15,0,16],[0,17,0,18],[2,15,2,16],[2,17,2,18],[8,7,8,9],[9,7,9,9],[7,10,7,12],[8,10,8,12],[9,16,9,18],[5,7,5,21],[6,19,6,21],[7,19,7,21],[8,19,8,21],[9,19,9,21],[9,10,9,12],[8,13,8,15],[9,13,9,15],[7,16,7,18],[8,16,8,18],[8,0,8,6],[7,7,7,9],[9,0,9,6],[7,0,7,6],[6,16,6,18],[6,13,6,15],[6,10,6,12],[6,7,6,9],[7,13,7,15]]}
[{"$f":"Coordonnées!A1","v":"Synthèse du Budget"},null,null,{"$f":"Coordonnées!D1","v":"Administration communale de"},{"$nulls":5},{"$f":"Coordonnées!J1","v":"SOMME-LEUZE"},{"$nulls":5},{"$f":"Coordonnées!P1","v":"Code INS"},null,{"$f":"Coordonnées!R1","v":91120}]
[{"$nulls":15},{"$f":"Coordonnées!P2","v":"Exercice:"},null,{"$f":"Coordonnées!R2","v":2023}]
[{"$f":"Coordonnées!A3","v":"Modèle officiel généré par l'application eComptes © SPW Intérieur et Action Sociale"},{"$nulls":14},{"$f":"Coordonnées!P3","v":"Version:"},null,{"$f":"Coordonnées!R3","v":1}]
[]
[]
[{"$nulls":7},"Evolution du résultat budgétaire ordinaire"]
[{"$nulls":7},{"$f":"Coordonnées!$H$27","v":"Budget"},null,null,{"$f":"Coordonnées!$H$27","v":"Budget"},null,null,{"$f":"Coordonnées!$H$27","v":"Budget"},null,null,{"$f":"Coordonnées!$H$27","v":"Budget"},null,null,{"$f":"Coordonnées!$H$27","v":"Budget"}]
["Exercices:",{"$nulls":6},{"$f":"K8-1","v":2019},null,null,{"$f":"N8-1","v":2020},null,null,{"$f":"Q8-1","v":2021},null,null,{"$f":"T8-1","v":2022},null,null,{"$f":"R2","v":2023}]
["Résultats  Exercice Propre*",{"$nulls":6},{"$f":"'Ordinaire GE'!H26-'Ordinaire GE'!H15","v":220.18000000156462},null,null,{"$f":"'Ordinaire GE'!K26-'Ordinaire GE'!K15","v":17553.979999999516},null,null,{"$f":"'Ordinaire GE'!N26-'Ordinaire GE'!N15","v":21423.94000000041},null,null,{"$f":"'Ordinaire GE'!Q26-'Ordinaire GE'!Q15","v":359.35000000055879},null,null,{"$f":"'Ordinaire GE'!T26-'Ordinaire GE'!T15","v":7691.0100000016391}]
["Résultat global*                              (avec exercices antérieurs et prélèvements)",{"$nulls":6},{"$f":"'Ordinaire GE'!H29-'Ordinaire GE'!H18","v":609360.09000000171},null,null,{"$f":"'Ordinaire GE'!K29-'Ordinaire GE'!K18","v":625303.3599999994},null,null,{"$f":"'Ordinaire GE'!N29-'Ordinaire GE'!N18","v":501544.8200000003},null,null,{"$f":"'Ordinaire GE'!Q29-'Ordinaire GE'!Q18","v":122778.1400000006},null,null,{"$f":"'Ordinaire GE'!T29-'Ordinaire GE'!T18","v":595468.20000000112}]
["* Montant arrondi à l'euro"]

{"sheet":"Ordinaire GE","index":3,"n_rows":30,"n_cols":22,"rows_kept":30,"cut":false,"hidden":false,"merged":[[27,0,27,6],[27,7,27,9],[27,10,27,12],[27,13,27,15],[27,16,27,18],[27,19,27,21],[28,0,28,6],[28,7,28,9],[28,10,28,12],[28,13,28,15],[28,16,28,18],[28,19,28,21],[25,0,25,6],[25,7,25,9],[25,10,25,12],[25,13,25,15],[25,16,25,18],[25,19,25,21],[26,0,26,6],[26,7,26,9],[26,10,26,12],[26,13,26,15],[26,16,26,18],[26,19,26,21],[23,0,23,6],[23,7,23,9],[23,10,23,12],[23,13,23,15],[23,16,23,18],[23,19,23,21],[24,0,24,6],[24,7,24,9],[24,10,24,12],[24,13,24,15],[24,16,24,18],[24,19,24,21],[21,0,21,6],[21,7,21,9],[21,10,21,12],[21,13,21,15],[21,16,21,18],[21,19,21,21],[22,0,22,6],[22,7,22,9],[22,10,22,12],[22,13,22,15],[22,16,22,18],[22,19,22,21],[19,7,19,21],[17,0,17,6],[17,7,17,9],[17,10,17,12],[17,13,17,15],[17,16,17,18],[17,19,17,21],[20,0,20,6],[20,7,20,9],[20,10,20,12],[20,13,20,15],[20,16,20,18],[20,19,20,21],[15,0,15,6],[15,7,15,9],[15,10,15,12],[15,13,15,15],[15,16,15,18],[15,19,15,21],[16,0,16,6],[16,7,16,9],[16,10,16,12],[16,13,16,15],[16,16,16,18],[16,19,16,21],[13,0,13,6],[13,7,13,9],[13,10,13,12],[13,13,13,15],[13,16,13,18],[13,19,13,21],[14,0,14,6],[14,7,14,9],[14,10,14,12],[14,13,14,15],[14,16,14,18],[14,19,14,21],[11,0,11,6],[11,7,11,9],[11,10,11,12],[11,13,11,15],[11,16,11,18],[11,19,11,21],[12,0,12,6],[12,7,12,9],[12,10,12,12],[12,13,12,15],[12,16,12,18],[12,19,12,21],[9,0,9,6],[9,7,9,9],[9,10,9,12],[9,13,9,15],[9,16,9,18],[9,19,9,21],[10,0,10,6],[10,7,10,9],[10,10,10,12],[10,13,10,15],[10,16,10,18],[10,19,10,21],[5,7,5,21],[6,7,6,9],[6,10,6,12],[6,13,6,15],[6,16,6,18],[6,19,6,21],[7,7,7,21],[8,0,8,6],[8,7,8,9],[8,10,8,12],[8,13,8,15],[8,16,8,18],[8,19,8,21],[0,0,1,2],[0,3,1,8],[0,9,1,14],[0,15,0,16],[0,17,0,18],[1,15,1,16],[1,17,1,18],[2,15,2,16],[2,17,2,18]]}
[{"$f":"Coordonnées!A1","v":"Synthèse du Budget"},null,null,{"$f":"Coordonnées!D1","v":"Administration communale de"},{"$nulls":5},{"$f":"Coordonnées!J1","v":"SOMME-LEUZE"},{"$nulls":5},{"$f":"Coordonnées!P1","v":"Code INS"},null,{"$f":"Coordonnées!R1","v":91120}]
[{"$nulls":15},{"$f":"Coordonnées!P2","v":"Exercice:"},null,{"$f":"Coordonnées!R2","v":2023}]
[{"$f":"Coordonnées!A3","v":"Modèle officiel généré par l'application eComptes © SPW Intérieur et Action Sociale"},{"$nulls":14},{"$f":"Coordonnées!P3","v":"Version:"},null,{"$f":"Coordonnées!R3","v":1}]
[]
[]
[{"$nulls":7},"Ventilation économique des dépenses et des recettes ordinaires"]
[{"$nulls":7},{"$f":"Coordonnées!$H$27","v":"Budget"},null,null,{"$f":"Coordonnées!$H$27","v":"Budget"},null,null,{"$f":"Coordonnées!$H$27","v":"Budget"},null,null,{"$f":"Coordonnées!$H$27","v":"Budget"},null,null,{"$f":"Coordonnées!$H$27","v":"Budget"}]
[{"$nulls":7},"Dépenses ordinaires (Prévisions)"]
["Exercices:",{"$nulls":6},{"$f":"K9-1","v":2019},null,null,{"$f":"N9-1","v":2020},null,null,{"$f":"Q9-1","v":2021},null,null,{"$f":"T9-1","v":2022},null,null,{"$f":"R2","v":2023}]
["Personnel",{"$nulls":6},3070907.89,5512664.2599999998,5512664.2599999998,3198912.12,5512664.2599999998,5512664.2599999998,3431703.7,5512664.2599999998,5512664.2599999998,3543363.19,5512664.2599999998,5512664.2599999998,3995124.1,5512664.2599999998,5512664.2599999998]
["Fonctionnement",{"$nulls":6},1647147.13,2726342.74,2726342.74,1682647.37,2726342.74,2726342.74,1810193.63,2726342.74,2726342.74,1897227.06,2726342.74,2726342.74,2020621.22,2726342.74,2726342.74]
["Transferts",{"$nulls":6},1714842.94,4264832.04,4264832.04,1833772.05,4264832.04,4264832.04,1693574.59,4264832.04,4264832.04,1786188.24,4264832.04,4264832.04,1912787.6,4264832.04,4264832.04]
["Dette",{"$nulls":6},850573.66,41563.69,41563.69,900773,41563.69,41563.69,876895.43,41563.69,41563.69,996432.55,41563.69,41563.69,983436.43,41563.69,41563.69]
["Prélèvements (hors 060)",{"$nulls":6},5000,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total (exercice propre)*",{"$nulls":6},{"$f":"SUM(H10:H14)","v":7288471.6199999992},null,null,{"$f":"SUM(K10:K14)","v":7616104.54},null,null,{"$f":"SUM(N10:N14)","v":7812367.3499999996},null,null,{"$f":"SUM(Q10:Q14)","v":8223211.04},null,null,{"$f":"SUM(T10:T14)","v":8911969.3499999996}]
["Exercices antérieurs",{"$nulls":6},0,1521059.02,2351270.66,40000,1659060.83,1521059.02,0,2230351.92,1659060.83,0,2351270.66,2230351.92,12943.83,2351270.66,2230351.92]
["Prélèvements",{"$nulls":6},0,1192323.53,824300.6,0,4295659.8600000003,1192323.53,15000,1045347.08,4295659.8600000003,0,824300.6,1045347.08,0,824300.6,1045347.08]
["Total général*",{"$nulls":6},{"$f":"SUM(H15:H17)","v":7288471.6199999992},null,null,{"$f":"SUM(K15:K17)","v":7656104.54},null,null,{"$f":"SUM(N15:N17)","v":7827367.3499999996},null,null,{"$f":"SUM(Q15:Q17)","v":8223211.04},null,null,{"$f":"SUM(T15:T17)","v":8924913.1799999997}]
["* Montant arrondi à l'euro"]
[{"$nulls":7},"Recettes ordinaires (Prévisions)"]
["Exercices:",{"$nulls":6},{"$f":"K21-1","v":2019},null,null,{"$f":"N21-1","v":2020},null,null,{"$f":"Q21-1","v":2021},null,null,{"$f":"T21-1","v":2022},null,null,{"$f":"R2","v":2023}]
["Prestation",{"$nulls":6},396813.27,373432.17,697745.74,381171.48,373432.17,697745.74,409037.64,373432.17,697745.74,425019.15,373432.17,697745.74,374857.64,373432.17,697745.74]
["Transferts",{"$nulls":6},6499203.7000000002,12728583.199999999,13240574.68,6660988.3600000003,12728583.199999999,13240574.68,6793478.8200000003,12728583.199999999,13240574.68,7037276.4100000001,12728583.199999999,13240574.68,8443527.8900000006,12728583.199999999,13240574.68]
["Dette",{"$nulls":6},35674.83,548784.99,408005.67,31498.68,548784.99,408005.67,31274.83,548784.99,408005.67,31274.83,548784.99,408005.67,31274.83,548784.99,408005.67]
["Prélèvements",{"$nulls":6},357000,0,0,560000,0,0,600000,0,0,730000,0,0,70000,0,0]
["Total (exercice propre)*",{"$nulls":6},{"$f":"SUM(H22:H25)","v":7288691.8000000007},null,null,{"$f":"SUM(K22:K25)","v":7633658.5199999996},null,null,{"$f":"SUM(N22:N25)","v":7833791.29},null,null,{"$f":"SUM(Q22:Q25)","v":8223570.3900000006},null,null,{"$f":"SUM(T22:T25)","v":8919660.3600000013}]
["Exercices antérieurs",{"$nulls":6},609139.91,6001218.2883333303,5811470.0833333302,647749.38,6001218.2883333303,5811470.0833333302,495120.88,6001218.2883333303,5811470.0833333302,122418.79,6001218.2883333303,5811470.0833333302,600721.02,6001218.2883333303,5811470.0833333302]
["Prélèvements",{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total général*",{"$nulls":6},{"$f":"SUM(H26:H28)","v":7897831.7100000009},null,null,{"$f":"SUM(K26:K28)","v":8281407.8999999994},null,null,{"$f":"SUM(N26:N28)","v":8328912.1699999999},null,null,{"$f":"SUM(Q26:Q28)","v":8345989.1800000006},null,null,{"$f":"SUM(T26:T28)","v":9520381.3800000008}]
["* Montant arrondi à l'euro"]

{"sheet":"Extraordinaire GE","index":4,"n_rows":30,"n_cols":22,"rows_kept":30,"cut":false,"hidden":false,"merged":[[27,0,27,6],[27,7,27,9],[27,10,27,12],[27,13,27,15],[27,16,27,18],[27,19,27,21],[28,0,28,6],[28,7,28,9],[28,10,28,12],[28,13,28,15],[28,16,28,18],[28,19,28,21],[25,0,25,6],[25,7,25,9],[25,10,25,12],[25,13,25,15],[25,16,25,18],[25,19,25,21],[26,0,26,6],[26,7,26,9],[26,10,26,12],[26,13,26,15],[26,16,26,18],[26,19,26,21],[23,0,23,6],[23,7,23,9],[23,10,23,12],[23,13,23,15],[23,16,23,18],[23,19,23,21],[24,0,24,6],[24,7,24,9],[24,10,24,12],[24,13,24,15],[24,16,24,18],[24,19,24,21],[21,0,21,6],[21,7,21,9],[21,10,21,12],[21,13,21,15],[21,16,21,18],[21,19,21,21],[22,0,22,6],[22,7,22,9],[22,10,22,12],[22,13,22,15],[22,16,22,18],[22,19,22,21],[17,0,17,6],[17,7,17,9],[17,10,17,12],[17,13,17,15],[17,16,17,18],[17,19,17,21],[19,7,19,21],[20,0,20,6],[20,7,20,9],[20,10,20,12],[20,13,20,15],[20,16,20,18],[20,19,20,21],[15,0,15,6],[15,7,15,9],[15,10,15,12],[15,13,15,15],[15,16,15,18],[15,19,15,21],[16,0,16,6],[16,7,16,9],[16,10,16,12],[16,13,16,15],[16,16,16,18],[16,19,16,21],[13,0,13,6],[13,7,13,9],[13,10,13,12],[13,13,13,15],[13,16,13,18],[13,19,13,21],[14,0,14,6],[14,7,14,9],[14,10,14,12],[14,13,14,15],[14,16,14,18],[14,19,14,21],[11,0,11,6],[11,7,11,9],[11,10,11,12],[11,13,11,15],[11,16,11,18],[11,19,11,21],[12,0,12,6],[12,7,12,9],[12,10,12,12],[12,13,12,15],[12,16,12,18],[12,19,12,21],[9,0,9,6],[9,7,9,9],[9,10,9,12],[9,13,9,15],[9,16,9,18],[9,19,9,21],[10,0,10,6],[10,7,10,9],[10,10,10,12],[10,13,10,15],[10,16,10,18],[10,19,10,21],[5,7,5,21],[6,7,6,9],[6,10,6,12],[6,13,6,15],[6,16,6,18],[6,19,6,21],[7,7,7,21],[8,0,8,6],[8,7,8,9],[8,10,8,12],[8,13,8,15],[8,16,8,18],[8,19,8,21],[0,0,1,2],[0,3,1,8],[0,9,1,14],[0,15,0,16],[0,17,0,18],[1,15,1,16],[1,17,1,18],[2,15,2,16],[2,17,2,18]]}
[{"$f":"Coordonnées!A1","v":"Synthèse du Budget"},null,null,{"$f":"Coordonnées!D1","v":"Administration communale de"},{"$nulls":5},{"$f":"Coordonnées!J1","v":"SOMME-LEUZE"},{"$nulls":5},{"$f":"Coordonnées!P1","v":"Code INS"},null,{"$f":"Coordonnées!R1","v":91120}]
[{"$nulls":15},{"$f":"Coordonnées!P2","v":"Exercice:"},null,{"$f":"Coordonnées!R2","v":2023}]
[{"$f":"Coordonnées!A3","v":"Modèle officiel généré par l'application eComptes © SPW Intérieur et Action Sociale"},{"$nulls":14},{"$f":"Coordonnées!P3","v":"Version:"},null,{"$f":"Coordonnées!R3","v":1}]
[]
[]
[{"$nulls":7},"Ventilation économique des dépenses et des recettes extraordinaires"]
[{"$nulls":7},{"$f":"Coordonnées!$H$27","v":"Budget"},null,null,{"$f":"Coordonnées!$H$27","v":"Budget"},null,null,{"$f":"Coordonnées!$H$27","v":"Budget"},null,null,{"$f":"Coordonnées!$H$27","v":"Budget"},null,null,{"$f":"Coordonnées!$H$27","v":"Budget"}]
[{"$nulls":7},"Dépenses extraordinaires (Prévisions)"]
["Exercices:",{"$nulls":6},{"$f":"K9-1","v":2019},null,null,{"$f":"N9-1","v":2020},null,null,{"$f":"Q9-1","v":2021},null,null,{"$f":"T9-1","v":2022},null,null,{"$f":"R2","v":2023}]
["Transferts",{"$nulls":6},0,5512664.2599999998,5512664.2599999998,0,5512664.2599999998,5512664.2599999998,0,5512664.2599999998,5512664.2599999998,0,5512664.2599999998,5512664.2599999998,0,5512664.2599999998,5512664.2599999998]
["Investissements",{"$nulls":6},1155746.67,2726342.74,2726342.74,2566233.35,2726342.74,2726342.74,2351750.92,2726342.74,2726342.74,2437820,2726342.74,2726342.74,2163480,2726342.74,2726342.74]
["Dette",{"$nulls":6},23118.61,4264832.04,4264832.04,23118.61,4264832.04,4264832.04,23118.61,4264832.04,4264832.04,23118.61,4264832.04,4264832.04,27548.51,4264832.04,4264832.04]
["Prélèvements",{"$nulls":6},0,41563.69,41563.69,0,41563.69,41563.69,0,41563.69,41563.69,0,41563.69,41563.69,0,41563.69,41563.69]
[{"$nulls":7},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total (exercice propre)*",{"$nulls":6},{"$f":"SUM(H10:H14)","v":1178865.28},null,null,{"$f":"SUM(K10:K14)","v":2589351.96},null,null,{"$f":"SUM(N10:N14)","v":2374869.5299999998},null,null,{"$f":"SUM(Q10:Q14)","v":2460938.61},null,null,{"$f":"SUM(T10:T14)","v":2191028.5099999998}]
["Exercices antérieurs",{"$nulls":6},0,1521059.02,2351270.66,0,1659060.83,1521059.02,0,2230351.92,1659060.83,7715.23,2351270.66,2230351.92,5.59,2351270.66,2230351.92]
["Prélèvements",{"$nulls":6},0,1192323.53,824300.6,69151.58,4295659.8600000003,1192323.53,6000,1045347.08,4295659.8600000003,8000,824300.6,1045347.08,0,824300.6,1045347.08]
["Total général*",{"$nulls":6},{"$f":"SUM(H15:H17)","v":1178865.28},null,null,{"$f":"SUM(K15:K17)","v":2658503.54},null,null,{"$f":"SUM(N15:N17)","v":2380869.5299999998},null,null,{"$f":"SUM(Q15:Q17)","v":2476653.84},null,null,{"$f":"SUM(T15:T17)","v":2191034.0999999996}]
["* Montant arrondi à l'euro"]
[{"$nulls":7},"Recettes extraordinaires (Prévisions)"]
["Exercices:",{"$nulls":6},{"$f":"K21-1","v":2019},null,null,{"$f":"N21-1","v":2020},null,null,{"$f":"Q21-1","v":2021},null,null,{"$f":"T21-1","v":2022},null,null,{"$f":"R2","v":2023}]
["Transferts",{"$nulls":6},184670.29,373432.17,697745.74,268286.68,365967.42,373432.17,273886.68,414709.37,365967.42,1278000,697745.74,414709.37,881880,557211.56000000006,577850.16]
["Investissements",{"$nulls":6},0,12728583.199999999,13240574.68,0,12120371.99,12728583.199999999,6000,12941517.73,12120371.99,8000,13240574.68,12941517.73,0,13289626.9983333,13396094.2633333]
["Dette",{"$nulls":6},795029.71,548784.99,408005.67,1509516.42,536819.05000000005,548784.99,1396862.99,344975.81,536819.05000000005,1140653.8400000001,408005.67,344975.81,1208118.6100000001,128208.38666666699,26303.796666666702]
["Prélèvements",{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total (exercice propre)*",{"$nulls":6},{"$f":"SUM(H22:H25)","v":979700},null,null,{"$f":"SUM(K22:K25)","v":1777803.0999999999},null,null,{"$f":"SUM(N22:N25)","v":1676749.67},null,null,{"$f":"SUM(Q22:Q25)","v":2426653.84},null,null,{"$f":"SUM(T22:T25)","v":2089998.61}]
["Exercices antérieurs",{"$nulls":6},0,null,null,39875,10122961.629999999,6628334.5600000005,0,6248838.1500000004,10122961.629999999,0,6834216,6248838.1500000004,0,6001218.2883333303,5811470.0833333302]
["Prélèvements",{"$nulls":6},199165.28,0,0,840825.44,0,0,704119.86,0,0,50000,0,0,101035.49,0,0]
["Total général*",{"$nulls":6},{"$f":"SUM(H26:H28)","v":1178865.28},null,null,{"$f":"SUM(K26:K28)","v":2658503.54},null,null,{"$f":"SUM(N26:N28)","v":2380869.5299999998},null,null,{"$f":"SUM(Q26:Q28)","v":2476653.84},null,null,{"$f":"SUM(T26:T28)","v":2191034.1}]
["* Montant arrondi à l'euro"]

{"sheet":"DO fonctions","index":5,"n_rows":21,"n_cols":10,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,1,2],[7,0,7,3],[8,0,8,3],[0,6,1,7],[0,4,1,5],[3,4,3,8],[12,0,12,3],[14,0,14,3],[15,0,15,3],[20,0,20,3],[4,4,4,8],[18,0,18,3],[19,0,19,3],[16,0,16,3],[17,0,17,3],[13,0,13,3],[9,0,9,3],[10,0,10,3],[11,0,11,3]]}
[{"$f":"Coordonnées!A1","v":"Synthèse du Budget"},null,null,null,"Administration communale de:",null,{"$f":"Coordonnées!J1","v":"SOMME-LEUZE"},null,"Code INS:",{"$f":"Coordonnées!R1","v":91120}]
[{"$nulls":8},"Exercice:",{"$f":"Coordonnées!R2","v":2023}]
[{"$f":"Coordonnées!A3","v":"Modèle officiel généré par l'application eComptes © SPW Intérieur et Action Sociale"},{"$nulls":7},"version:",{"$f":"Coordonnées!R3","v":1}]
[{"$nulls":4},"Ventilation fonctionnelle"]
[{"$nulls":4},"Evolution des dépenses ordinaires (exercice propre)"]
[{"$nulls":4},{"$f":"Coordonnées!$H$27","v":"Budget"},{"$f":"Coordonnées!$H$27","v":"Budget"},{"$f":"Coordonnées!$H$27","v":"Budget"},{"$f":"Coordonnées!$H$27","v":"Budget"},{"$f":"Coordonnées!$H$27","v":"Budget"}]
[{"$nulls":4},{"$f":"F7-1","v":2019},{"$f":"G7-1","v":2020},{"$f":"H7-1","v":2021},{"$f":"I7-1","v":2022},{"$f":"J2","v":2023}]
["0 Recettes et dépenses générales",null,null,null,51200,42400,60200,57400,46850]
["1 Administration générale",null,null,null,1859804.91,1943845.9,2103058.08,2165845.19,2412233.08]
["3 Sécurité",null,null,null,740516.95,763701.7,675896.27,675896.27,683782.61]
["4 Voiries-communications",null,null,null,1696327.06,1843807.95,1837423.32,2017458.83,2106867.08]
["5 Industrie - commerce",null,null,null,46995.51,48327.74,56782.47,51600.92,54308.2]
["6 Sylviculture- Agriculture",null,null,null,23375.43,19121.84,16827.46,15280,16930]
["70>75 Enseignement",null,null,null,838012.74,846904.53,885896.17,947018.52,1046141.8]
["76>77 Culture et sports",null,null,null,395018.29,453149.37,512233.36,507482.82,590353.02]
["78 Radio, télévision, presse",null,null,null,0,0,0,0,0]
["79 Culte",null,null,null,105165.1,98502.98,102498.76,77193.740000000005,83661.509999999995]
["80>86 Action Sociale ",null,null,null,780626.58,792847.69,777670.37,896793.82,1006675]
["87 Santé publique et hygiène",null,null,null,596694.15,608956.49,660246.35,667892.18999999994,711533.8]
["90>92 Logement",null,null,null,148229.60999999999,148034.01,132134.71,136851.45000000001,146138.79]
["93 Aménagement du territoire",null,null,null,6505.29,6504.34,6500.03,6497.29,6494.46]

{"sheet":"RO fonctions","index":6,"n_rows":21,"n_cols":10,"rows_kept":21,"cut":false,"hidden":false,"merged":[[16,0,16,3],[17,0,17,3],[18,0,18,3],[19,0,19,3],[20,0,20,3],[15,0,15,3],[0,0,1,2],[3,4,3,8],[4,4,4,8],[7,0,7,3],[8,0,8,3],[9,0,9,3],[0,6,1,7],[0,4,1,5],[10,0,10,3],[11,0,11,3],[12,0,12,3],[13,0,13,3],[14,0,14,3]]}
[{"$f":"Coordonnées!A1","v":"Synthèse du Budget"},null,null,null,"Administration communale de:",null,{"$f":"Coordonnées!J1","v":"SOMME-LEUZE"},null,"Code INS:",{"$f":"Coordonnées!R1","v":91120}]
[{"$nulls":8},"Exercice:",{"$f":"Coordonnées!R2","v":2023}]
[{"$f":"Coordonnées!A3","v":"Modèle officiel généré par l'application eComptes © SPW Intérieur et Action Sociale"},{"$nulls":7},"version:",{"$f":"Coordonnées!R3","v":1}]
[{"$nulls":4},"Ventilation fonctionnelle"]
[{"$nulls":4},"Evolution des recettes ordinaires (exercice propre)"]
[{"$nulls":4},{"$f":"Coordonnées!$H$27","v":"Budget"},{"$f":"Coordonnées!$H$27","v":"Budget"},{"$f":"Coordonnées!$H$27","v":"Budget"},{"$f":"Coordonnées!$H$27","v":"Budget"},{"$f":"Coordonnées!$H$27","v":"Budget"}]
[{"$nulls":4},{"$f":"F7-1","v":2019},{"$f":"G7-1","v":2020},{"$f":"H7-1","v":2021},{"$f":"I7-1","v":2022},{"$f":"J2","v":2023}]
["0 Recettes et dépenses générales",null,null,null,5908436.2800000003,6167170.1900000004,6100013.9900000002,6566967,8466824.4600000009]
["1 Administration générale",null,null,null,363658.1,402000.97,422533.38,189289.13,197519.01]
["3 Sécurité",null,null,null,0,170000,6000,6050,76500]
["4 Voiries-communications",null,null,null,620787.79,233509.54,840442.33,561350.37,84459.56]
["5 Industrie - commerce",null,null,null,115652.36,114282.12,114258.27,115035.17,120386.3]
["6 Sylviculture- Agriculture",null,null,null,147258.44,121656.71,127653.73,152095,71252.61]
["70>75 Enseignement",null,null,null,419765.58,467907.28,479450.6,294047.06,318079.17]
["76>77 Culture et sports",null,null,null,146641.47,141141.47,136155.81,159050.04999999999,140910.26999999999]
["78 Radio, télévision, presse",null,null,null,0,0,0,0,0]
["79 Culte",null,null,null,0,0,0,0,0]
["80>86 Action Sociale ",null,null,null,57873.919999999998,370000,0,230000,0]
["87 Santé publique et hygiène",null,null,null,43871.37,33881.370000000003,32848.660000000003,11050,9950]
["90>92 Logement",null,null,null,66446.399999999994,52358.25,62055.4,53555.4,29000]
["93 Aménagement du territoire",null,null,null,7440,7500,7500,7500,5500]

{"sheet":"DE fonctions","index":7,"n_rows":21,"n_cols":10,"rows_kept":21,"cut":false,"hidden":false,"merged":[[16,0,16,3],[17,0,17,3],[18,0,18,3],[19,0,19,3],[20,0,20,3],[15,0,15,3],[0,0,1,2],[3,4,3,8],[4,4,4,8],[7,0,7,3],[8,0,8,3],[9,0,9,3],[0,6,1,7],[0,4,1,5],[10,0,10,3],[11,0,11,3],[12,0,12,3],[13,0,13,3],[14,0,14,3]]}
[{"$f":"Coordonnées!A1","v":"Synthèse du Budget"},null,null,null,"Administration communale de:",null,{"$f":"Coordonnées!J1","v":"SOMME-LEUZE"},null,"Code INS:",{"$f":"Coordonnées!R1","v":91120}]
[{"$nulls":8},"Exercice:",{"$f":"Coordonnées!R2","v":2023}]
[{"$f":"Coordonnées!A3","v":"Modèle officiel généré par l'application eComptes © SPW Intérieur et Action Sociale"},{"$nulls":7},"version:",{"$f":"Coordonnées!R3","v":1}]
[{"$nulls":4},"Ventilation fonctionnelle"]
[{"$nulls":4},"Evolution des dépenses extraordinaires (exercice propre)"]
[{"$nulls":4},{"$f":"Coordonnées!$H$27","v":"Budget"},{"$f":"Coordonnées!$H$27","v":"Budget"},{"$f":"Coordonnées!$H$27","v":"Budget"},{"$f":"Coordonnées!$H$27","v":"Budget"},{"$f":"Coordonnées!$H$27","v":"Budget"}]
[{"$nulls":4},{"$f":"F7-1","v":2019},{"$f":"G7-1","v":2020},{"$f":"H7-1","v":2021},{"$f":"I7-1","v":2022},{"$f":"J2","v":2023}]
["0 Recettes et dépenses générales",null,null,null,0,69151.58,6000,8000,0]
["1 Administration générale",null,null,null,93000,98000,80000,571000,55000]
["3 Sécurité",null,null,null,0,0,0,0,0]
["4 Voiries-communications",null,null,null,466000,2020733.35,1838750.92,420820,559700]
["5 Industrie - commerce",null,null,null,15946.67,0,0,3000,2900]
["6 Sylviculture- Agriculture",null,null,null,10000,10000,10000,5000,5000]
["70>75 Enseignement",null,null,null,42800,11500,39500,23500,54880]
["76>77 Culture et sports",null,null,null,335000,327500,342500,923500,1042500]
["78 Radio, télévision, presse",null,null,null,0,0,0,0,0]
["79 Culte",null,null,null,122000,75000,0,410000,418500]
["80>86 Action Sociale ",null,null,null,0,0,0,0,4340]
["87 Santé publique et hygiène",null,null,null,88118.61,40618.61,58118.61,89118.61,38118.61]
["90>92 Logement",null,null,null,6000,6000,6000,15000,10089.9]
["93 Aménagement du territoire",null,null,null,0,0,0,0,0]

{"sheet":"RE fonctions","index":8,"n_rows":21,"n_cols":10,"rows_kept":21,"cut":false,"hidden":false,"merged":[[16,0,16,3],[17,0,17,3],[18,0,18,3],[19,0,19,3],[20,0,20,3],[15,0,15,3],[0,0,1,2],[3,4,3,8],[4,4,4,8],[7,0,7,3],[8,0,8,3],[9,0,9,3],[0,6,1,7],[0,4,1,5],[10,0,10,3],[11,0,11,3],[12,0,12,3],[13,0,13,3],[14,0,14,3]]}
[{"$f":"Coordonnées!A1","v":"Synthèse du Budget"},null,null,null,"Administration communale de:",null,{"$f":"Coordonnées!J1","v":"SOMME-LEUZE"},null,"Code INS:",{"$f":"Coordonnées!R1","v":91120}]
[{"$nulls":8},"Exercice:",{"$f":"Coordonnées!R2","v":2023}]
[{"$f":"Coordonnées!A3","v":"Modèle officiel généré par l'application eComptes © SPW Intérieur et Action Sociale"},{"$nulls":7},"version:",{"$f":"Coordonnées!R3","v":1}]
[{"$nulls":4},"Ventilation fonctionnelle"]
[{"$nulls":4},"Evolution des recettes extraordinaires (exercice propre)"]
[{"$nulls":4},{"$f":"Coordonnées!$H$27","v":"Budget"},{"$f":"Coordonnées!$H$27","v":"Budget"},{"$f":"Coordonnées!$H$27","v":"Budget"},{"$f":"Coordonnées!$H$27","v":"Budget"},{"$f":"Coordonnées!$H$27","v":"Budget"}]
[{"$nulls":4},{"$f":"F7-1","v":2019},{"$f":"G7-1","v":2020},{"$f":"H7-1","v":2021},{"$f":"I7-1","v":2022},{"$f":"J2","v":2023}]
["0 Recettes et dépenses générales",null,null,null,199165.28,880700.44,704119.86,50000,101035.49]
["1 Administration générale",null,null,null,80000,93000,50000,566000,53000]
["3 Sécurité",null,null,null,0,0,0,0,0]
["4 Voiries-communications",null,null,null,413000,1287303.1000000001,1212249.67,413820,537000]
["5 Industrie - commerce",null,null,null,0,0,0,0,0]
["6 Sylviculture- Agriculture",null,null,null,0,0,0,0,0]
["70>75 Enseignement",null,null,null,4200,0,28000,11500,37880]
["76>77 Culture et sports",null,null,null,320000,327500,342500,917500,1010000]
["78 Radio, télévision, presse",null,null,null,0,0,0,0,0]
["79 Culte",null,null,null,105000,70000,0,417715.23,410000]
["80>86 Action Sociale ",null,null,null,0,0,0,0,0]
["87 Santé publique et hygiène",null,null,null,57500,0,35000,83118.61,38118.61]
["90>92 Logement",null,null,null,0,0,9000,17000,4000]
["93 Aménagement du territoire",null,null,null,0,0,0,0,0]

{"sheet":"Commentaires","index":9,"n_rows":6,"n_cols":18,"rows_kept":6,"cut":false,"hidden":false,"merged":[[42,1,42,17],[48,1,48,17],[49,1,49,17],[43,1,43,17],[44,1,44,17],[45,1,45,17],[46,1,46,17],[47,1,47,17],[37,1,37,17],[38,1,38,17],[39,1,39,17],[40,1,40,17],[41,1,41,17],[32,1,32,17],[33,1,33,17],[34,1,34,17],[35,1,35,17],[36,1,36,17],[27,1,27,17],[28,1,28,17],[29,1,29,17],[30,1,30,17],[31,1,31,17],[22,1,22,17],[23,1,23,17],[24,1,24,17],[25,1,25,17],[26,1,26,17],[17,1,17,17],[18,1,18,17],[19,1,19,17],[20,1,20,17],[21,1,21,17],[12,1,12,17],[13,1,13,17],[14,1,14,17],[15,1,15,17],[16,1,16,17],[7,1,7,17],[8,1,8,17],[9,1,9,17],[10,1,10,17],[11,1,11,17],[2,15,2,16],[2,17,2,18],[0,0,1,2],[0,3,1,8],[0,9,1,14],[0,15,0,16],[0,17,0,18],[1,15,1,16],[1,17,1,18]]}
[{"$f":"Coordonnées!A1","v":"Synthèse du Budget"},null,null,{"$f":"Coordonnées!D1","v":"Administration communale de"},{"$nulls":5},{"$f":"Coordonnées!J1","v":"SOMME-LEUZE"},{"$nulls":5},{"$f":"Coordonnées!P1","v":"Code INS"},null,{"$f":"Coordonnées!R1","v":91120}]
[{"$nulls":15},{"$f":"Coordonnées!P2","v":"Exercice:"},null,{"$f":"Coordonnées!R2","v":2023}]
[{"$f":"Coordonnées!A3","v":"Modèle officiel généré par l'application eComptes © SPW Intérieur et Action Sociale"},{"$nulls":14},{"$f":"Coordonnées!P3","v":"Version:"},null,{"$f":"Coordonnées!R3","v":1}]
[]
[]
["Commentaires"]

{"sheet":"Glossaire","index":10,"n_rows":18,"n_cols":18,"rows_kept":18,"cut":false,"hidden":false,"merged":[[16,5,16,18],[17,5,17,18],[16,0,16,4],[17,0,17,4],[8,5,8,18],[9,5,9,18],[10,5,10,18],[11,5,11,18],[12,5,12,18],[13,5,13,18],[14,5,14,18],[15,5,15,18],[15,0,15,4],[8,0,8,4],[9,0,9,4],[10,0,10,4],[11,0,11,4],[12,0,12,4],[13,0,13,4],[14,0,14,4],[2,15,2,16],[2,17,2,18],[0,0,1,2],[0,3,1,8],[0,9,1,14],[0,15,0,16],[0,17,0,18],[1,15,1,16],[1,17,1,18]]}
[{"$f":"Coordonnées!A1","v":"Synthèse du Budget"},null,null,{"$f":"Coordonnées!D1","v":"Administration communale de"},{"$nulls":5},{"$f":"Coordonnées!J1","v":"SOMME-LEUZE"},{"$nulls":5},{"$f":"Coordonnées!P1","v":"Code INS"},null,{"$f":"Coordonnées!R1","v":91120}]
[{"$nulls":15},{"$f":"Coordonnées!P2","v":"Exercice:"},null,{"$f":"Coordonnées!R2","v":2023}]
[{"$f":"Coordonnées!A3","v":"Modèle officiel généré par l'application eComptes © SPW Intérieur et Action Sociale"},{"$nulls":14},{"$f":"Coordonnées!P3","v":"Version:"},null,{"$f":"Coordonnées!R3","v":1}]
[]
[]
["Glossaire"]
[]
["Termes",{"$nulls":4},"Définitions:"]
["Exercice propre",{"$nulls":4},"L'exercice du document allant du 1er janvier au 31 décembre"]
["Exercices antérieurs",{"$nulls":4},"Les opérations antérieures à l'exercice propre"]
["Résultat global",{"$nulls":4},"Le boni ou le mali de l'exercice propre cumulé avec celui des exercices antérieurs"]
["Dépenses de transfert",{"$nulls":4},"Dépenses effectuées à destination de tiers à la commune (d'autres institutions, organismes, ménages ..)"]
["Recettes de transfert",{"$nulls":4},"Recettes en provenance de tiers ( subsides, taxes, … )"]
["Recettes de prestation",{"$nulls":4},"Recettes découlant de services payants rendus par la commune, de locations, de droits d'entrée …"]
["Dépenses de prélèvements",{"$nulls":4},"Sommes prélevées sur les excédents budgétaires par la commune pour alimenter des fonds de réserves ordinaires ou extraordinaires (pour financer des dépenses d'investissement sur fonds propres  ) ou des provisions ( pour faire face à des charges futures importantes )"]
["Recettes de prélèvements",{"$nulls":4},"Utilisation des fonds de réserve et des provisions (constitués au moyen des dépenses de prélèvement)"]
["Ordinaire",{"$nulls":4},"Les recettes et dépenses nécessaires au fonctionnement de la commune (taxes, subventions , salaires,électricité,fournitures,…)"]
["Extraordinaire",{"$nulls":4},"Les dépenses et leurs moyens de financement afférentes aux investissements ( travaux importants, rénovations, achat de matériel et de véhicules etc … )"]