{"text_format":"2","workbook":"xlsx","n_sheets":15,"sheets":["Macro-commandes","Coordonnées","Résultats","Ordinaire GE","Extraordinaire GE","DO fonctions","RO fonctions","DE fonctions","RE fonctions","Actif","Passif","Charges","Produits","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 des Comptes",null,null,"Administration communale de",{"$nulls":5},"SOMME-LEUZE",{"$nulls":5},"Code INS",null,91120]
[{"$nulls":15},"Exercice:",null,{"$f":"N27","v":2022}]
["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  des  C O M P T E S"]
[]
[]
[]
[{"$nulls":4},"Module informatisé de publication des comptes 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 compte par le conseil:",{"$nulls":6},"17/04/2023"]
[]
["Date d'approbation de la Tutelle:",{"$nulls":6},"13/07/2023"]
[]
["Type document:",{"$nulls":6},"Compte",null,null,null,"Exercice:",null,2022]
[]
["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:"]
["Tél:"]
["Fax:"]
["Email:"]

{"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 des Comptes"},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":2022}]
[{"$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":"Compte"},null,null,{"$f":"Coordonnées!$H$27","v":"Compte"},null,null,{"$f":"Coordonnées!$H$27","v":"Compte"},null,null,{"$f":"Coordonnées!$H$27","v":"Compte"},null,null,{"$f":"Coordonnées!$H$27","v":"Compte"}]
["Exercices:",{"$nulls":6},{"$f":"K8-1","v":2018},null,null,{"$f":"N8-1","v":2019},null,null,{"$f":"Q8-1","v":2020},null,null,{"$f":"T8-1","v":2021},null,null,{"$f":"R2","v":2022}]
["Résultats  Exercice Propre*",{"$nulls":6},{"$f":"'Ordinaire GE'!H26-'Ordinaire GE'!H15","v":606.27999999932945},null,null,{"$f":"'Ordinaire GE'!K26-'Ordinaire GE'!K15","v":-161493.14999999944},null,null,{"$f":"'Ordinaire GE'!N26-'Ordinaire GE'!N15","v":-341055.69000000134},null,null,{"$f":"'Ordinaire GE'!Q26-'Ordinaire GE'!Q15","v":164898.83000000101},null,null,{"$f":"'Ordinaire GE'!T26-'Ordinaire GE'!T15","v":-194697.13000000082}]
["Résultat global*                              (avec exercices antérieurs et prélèvements)",{"$nulls":6},{"$f":"'Ordinaire GE'!H29-'Ordinaire GE'!H18","v":563105.82999999914},null,null,{"$f":"'Ordinaire GE'!K29-'Ordinaire GE'!K18","v":503901.67000000086},null,null,{"$f":"'Ordinaire GE'!N29-'Ordinaire GE'!N18","v":183908.54999999888},null,null,{"$f":"'Ordinaire GE'!Q29-'Ordinaire GE'!Q18","v":229820.74000000115},null,null,{"$f":"'Ordinaire GE'!T29-'Ordinaire GE'!T18","v":328210.8599999994}]
["* 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 des Comptes"},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":2022}]
[{"$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":"Compte"},null,null,{"$f":"Coordonnées!$H$27","v":"Compte"},null,null,{"$f":"Coordonnées!$H$27","v":"Compte"},null,null,{"$f":"Coordonnées!$H$27","v":"Compte"},null,null,{"$f":"Coordonnées!$H$27","v":"Compte"}]
[{"$nulls":7},"Dépenses ordinaires (engagements actés aux comptes)"]
["Exercices:",{"$nulls":6},{"$f":"K9-1","v":2018},null,null,{"$f":"N9-1","v":2019},null,null,{"$f":"Q9-1","v":2020},null,null,{"$f":"T9-1","v":2021},null,null,{"$f":"R2","v":2022}]
["Personnel",{"$nulls":6},2816309.23,5512664.2599999998,5512664.2599999998,2856691.08,5512664.2599999998,5512664.2599999998,3001783.19,5512664.2599999998,5512664.2599999998,3154245.87,5512664.2599999998,5512664.2599999998,3413020.64,5512664.2599999998,5512664.2599999998]
["Fonctionnement",{"$nulls":6},1438969.26,2726342.74,2726342.74,1535033.16,2726342.74,2726342.74,1428644.99,2726342.74,2726342.74,1533670.34,2726342.74,2726342.74,1728688.43,2726342.74,2726342.74]
["Transferts",{"$nulls":6},1625561.36,4264832.04,4264832.04,1721062.01,4264832.04,4264832.04,1721696.81,4264832.04,4264832.04,1680801.44,4264832.04,4264832.04,1779660.64,4264832.04,4264832.04]
["Dette",{"$nulls":6},757151.57,41563.69,41563.69,834052.04,41563.69,41563.69,862623.62,41563.69,41563.69,865100.19,41563.69,41563.69,929997.45,41563.69,41563.69]
["Prélèvements (hors 060)",{"$nulls":6},427000,0,0,381000,0,0,550000,0,0,0,0,0,380000,0,0]
["Total (exercice propre)*",{"$nulls":6},{"$f":"SUM(H10:H14)","v":7064991.4200000009},null,null,{"$f":"SUM(K10:K14)","v":7327838.29},null,null,{"$f":"SUM(N10:N14)","v":7564748.6100000003},null,null,{"$f":"SUM(Q10:Q14)","v":7233817.8399999999},null,null,{"$f":"SUM(T10:T14)","v":8231367.1600000001}]
["Exercices antérieurs",{"$nulls":6},112824.13,1521059.02,2351270.66,84160.25,1659060.83,1521059.02,168107.83,2230351.92,1659060.83,220568.35,2351270.66,2230351.92,11736.43,2351270.66,2230351.92]
["Prélèvements",{"$nulls":6},0,1192323.53,824300.6,0,4295659.8600000003,1192323.53,0,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":7177815.5500000007},null,null,{"$f":"SUM(K15:K17)","v":7411998.54},null,null,{"$f":"SUM(N15:N17)","v":7732856.4400000004},null,null,{"$f":"SUM(Q15:Q17)","v":7454386.1899999995},null,null,{"$f":"SUM(T15:T17)","v":8243103.5899999999}]
["* Montant arrondi à l'euro"]
[{"$nulls":7},"Recettes ordinaires (Droits actés aux comptes)"]
["Exercices:",{"$nulls":6},{"$f":"K21-1","v":2018},null,null,{"$f":"N21-1","v":2019},null,null,{"$f":"Q21-1","v":2020},null,null,{"$f":"T21-1","v":2021},null,null,{"$f":"R2","v":2022}]
["Prestation",{"$nulls":6},652733.86,373432.17,697745.74,494383.17,373432.17,697745.74,362440.81,373432.17,697745.74,447053.58,373432.17,697745.74,499570.96,373432.17,697745.74]
["Transferts",{"$nulls":6},6381282.29,12728583.199999999,13240574.68,6640378.8200000003,12728583.199999999,13240574.68,6829807.5599999996,12728583.199999999,13240574.68,6900026.6100000003,12728583.199999999,13240574.68,7504615.9299999997,12728583.199999999,13240574.68]
["Dette",{"$nulls":6},31581.55,548784.99,408005.67,31583.15,548784.99,408005.67,31444.55,548784.99,408005.67,51636.480000000003,548784.99,408005.67,32483.14,548784.99,408005.67]
["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":7065597.7000000002},null,null,{"$f":"SUM(K22:K25)","v":7166345.1400000006},null,null,{"$f":"SUM(N22:N25)","v":7223692.919999999},null,null,{"$f":"SUM(Q22:Q25)","v":7398716.6700000009},null,null,{"$f":"SUM(T22:T25)","v":8036670.0299999993}]
["Exercices antérieurs",{"$nulls":6},675323.68,6001218.2883333303,5811470.0833333302,749555.07,6001218.2883333303,5811470.0833333302,693072.07,6001218.2883333303,5811470.0833333302,285490.26,6001218.2883333303,5811470.0833333302,534644.42000000004,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":7740921.3799999999},null,null,{"$f":"SUM(K26:K28)","v":7915900.2100000009},null,null,{"$f":"SUM(N26:N28)","v":7916764.9899999993},null,null,{"$f":"SUM(Q26:Q28)","v":7684206.9300000006},null,null,{"$f":"SUM(T26:T28)","v":8571314.4499999993}]
["* 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 des Comptes"},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":2022}]
[{"$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":"Compte"},null,null,{"$f":"Coordonnées!$H$27","v":"Compte"},null,null,{"$f":"Coordonnées!$H$27","v":"Compte"},null,null,{"$f":"Coordonnées!$H$27","v":"Compte"},null,null,{"$f":"Coordonnées!$H$27","v":"Compte"}]
[{"$nulls":7},"Dépenses extraordinaires (engagements actés aux comptes)"]
["Exercices:",{"$nulls":6},{"$f":"K9-1","v":2018},null,null,{"$f":"N9-1","v":2019},null,null,{"$f":"Q9-1","v":2020},null,null,{"$f":"T9-1","v":2021},null,null,{"$f":"R2","v":2022}]
["Transferts",{"$nulls":6},0,5512664.2599999998,5512664.2599999998,96276.58,5512664.2599999998,5512664.2599999998,19529.63,5512664.2599999998,5512664.2599999998,0,5512664.2599999998,5512664.2599999998,0,5512664.2599999998,5512664.2599999998]
["Investissements",{"$nulls":6},2466591.88,2726342.74,2726342.74,531478.89,2726342.74,2726342.74,789309.24,2726342.74,2726342.74,1962611.54,2726342.74,2726342.74,1452881.46,2726342.74,2726342.74]
["Dette",{"$nulls":6},23118.61,4264832.04,4264832.04,81243.61,4264832.04,4264832.04,23118.61,4264832.04,4264832.04,23118.61,4264832.04,4264832.04,23118.61,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":2489710.4899999998},null,null,{"$f":"SUM(K10:K14)","v":708999.08},null,null,{"$f":"SUM(N10:N14)","v":831957.48},null,null,{"$f":"SUM(Q10:Q14)","v":1985730.1500000001},null,null,{"$f":"SUM(T10:T14)","v":1476000.07}]
["Exercices antérieurs",{"$nulls":6},894328.94,1521059.02,2351270.66,2193854.7799999998,1659060.83,1521059.02,674035.14,2230351.92,1659060.83,1223999.6399999999,2351270.66,2230351.92,1379828.07,2351270.66,2230351.92]
["Prélèvements",{"$nulls":6},349124.75,1192323.53,824300.6,742537.07,4295659.8600000003,1192323.53,199992.55,1045347.08,4295659.8600000003,75075.97,824300.6,1045347.08,1073436.8,824300.6,1045347.08]
["Total général*",{"$nulls":6},{"$f":"SUM(H15:H17)","v":3733164.1799999997},null,null,{"$f":"SUM(K15:K17)","v":3645390.9299999997},null,null,{"$f":"SUM(N15:N17)","v":1705985.1700000002},null,null,{"$f":"SUM(Q15:Q17)","v":3284805.7600000002},null,null,{"$f":"SUM(T15:T17)","v":3929264.9400000004}]
["* Montant arrondi à l'euro"]
[{"$nulls":7},"Recettes extraordinaires (Droits actés aux comptes)"]
["Exercices:",{"$nulls":6},{"$f":"K21-1","v":2018},null,null,{"$f":"N21-1","v":2019},null,null,{"$f":"Q21-1","v":2020},null,null,{"$f":"T21-1","v":2021},null,null,{"$f":"R2","v":2022}]
["Transferts",{"$nulls":6},854826.77,373432.17,697745.74,712474.26,365967.42,373432.17,94712.6,414709.37,365967.42,194009.34,697745.74,414709.37,1006908.59,557211.56000000006,577850.16]
["Investissements",{"$nulls":6},19950,12728583.199999999,13240574.68,41875,12120371.99,12728583.199999999,26649.759999999998,12941517.73,12120371.99,14838.97,13240574.68,12941517.73,119542.76,13289626.9983333,13396094.2633333]
["Dette",{"$nulls":6},79650.820000000007,548784.99,408005.67,912459.29,536819.05000000005,548784.99,0,344975.81,536819.05000000005,2042032.96,408005.67,344975.81,0,128208.38666666699,26303.796666666702]
["Prélèvements",{"$nulls":6},0,0,0,0,0,0,0,0,0,2062.81,0,0,0,0,0]
["Total (exercice propre)*",{"$nulls":6},{"$f":"SUM(H22:H25)","v":954427.59000000008},null,null,{"$f":"SUM(K22:K25)","v":1666808.55},null,null,{"$f":"SUM(N22:N25)","v":121362.36},null,null,{"$f":"SUM(Q22:Q25)","v":2252944.08},null,null,{"$f":"SUM(T22:T25)","v":1126451.3499999999}]
["Exercices antérieurs",{"$nulls":6},806629,null,null,992009.41,10122961.629999999,6628334.5600000005,203779.20000000001,6248838.1500000004,10122961.629999999,0,6834216,6248838.1500000004,1062085.3500000001,6001218.2883333303,5811470.0833333302]
["Prélèvements",{"$nulls":6},711811.78,0,0,416244.84,0,0,111276.83,0,0,734897.16,0,0,78453.990000000005,0,0]
["Total général*",{"$nulls":6},{"$f":"SUM(H26:H28)","v":2472868.37},null,null,{"$f":"SUM(K26:K28)","v":3075062.8},null,null,{"$f":"SUM(N26:N28)","v":436418.39},null,null,{"$f":"SUM(Q26:Q28)","v":2987841.24},null,null,{"$f":"SUM(T26:T28)","v":2266990.6900000004}]
["* 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 des Comptes"},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":2022}]
[{"$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":"Compte"},{"$f":"Coordonnées!$H$27","v":"Compte"},{"$f":"Coordonnées!$H$27","v":"Compte"},{"$f":"Coordonnées!$H$27","v":"Compte"},{"$f":"Coordonnées!$H$27","v":"Compte"}]
[{"$nulls":4},{"$f":"F7-1","v":2018},{"$f":"G7-1","v":2019},{"$f":"H7-1","v":2020},{"$f":"I7-1","v":2021},{"$f":"J2","v":2022}]
["0 Recettes et dépenses générales",null,null,null,46448.88,43453.11,41977.46,39626.74,43498.45]
["1 Administration générale",null,null,null,1774152.74,1771207.47,1871738.23,1931230.17,2475764.46]
["3 Sécurité",null,null,null,726728.5,933355,703464.75,674196.27,674196.27]
["4 Voiries-communications",null,null,null,1856107.14,1581623.59,2173167.9500000002,1704779.09,1864372.13]
["5 Industrie - commerce",null,null,null,39487.040000000001,55045.98,47709.87,46200.66,50848.480000000003]
["6 Sylviculture- Agriculture",null,null,null,16928.900000000001,27922.45,28090.87,14794.6,14247.55]
["70>75 Enseignement",null,null,null,762324.42,793113.5,727904.9,760718.54,931158.12]
["76>77 Culture et sports",null,null,null,339393.78,381794.29,357801.36,435241.45,431786.89]
["78 Radio, télévision, presse",null,null,null,0,0,0,0,0]
["79 Culte",null,null,null,92999.69,95089.48,97400.53,95703.15,75715.17]
["80>86 Action Sociale ",null,null,null,714238.43,983791.17,747629.35,775638.05,895901.37]
["87 Santé publique et hygiène",null,null,null,562550.39,516226.43,619129.27,621982.63,631328.17000000004]
["90>92 Logement",null,null,null,127123.69,138710.53,142229.73000000001,127206.46,136052.81]
["93 Aménagement du territoire",null,null,null,6507.82,6505.29,6504.34,6500.03,6497.29]

{"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 des Comptes"},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":2022}]
[{"$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":"Compte"},{"$f":"Coordonnées!$H$27","v":"Compte"},{"$f":"Coordonnées!$H$27","v":"Compte"},{"$f":"Coordonnées!$H$27","v":"Compte"},{"$f":"Coordonnées!$H$27","v":"Compte"}]
[{"$nulls":4},{"$f":"F7-1","v":2018},{"$f":"G7-1","v":2019},{"$f":"H7-1","v":2020},{"$f":"I7-1","v":2021},{"$f":"J2","v":2022}]
["0 Recettes et dépenses générales",null,null,null,5857170.7199999997,6118410.0199999996,6187152.5099999998,5842477.4000000004,7076424.1200000001]
["1 Administration générale",null,null,null,380886.6,383723.36,411258.37,449597.25,224067.5]
["3 Sécurité",null,null,null,0,0,6000,6038.47,6352.81]
["4 Voiries-communications",null,null,null,215823.55,268993.36,274260.65000000002,295322.34000000003,103410.24000000001]
["5 Industrie - commerce",null,null,null,197310.48,114294.6,115976.97,135334.69,120405.98]
["6 Sylviculture- Agriculture",null,null,null,307889.57,233588.76,103624.52,126067.79,163658.29999999999]
["70>75 Enseignement",null,null,null,466611.93,470190.4,470648.89,482724.82,350921.98]
["76>77 Culture et sports",null,null,null,145853.4,115718.99,156699.22,199649.75,180512.29]
["78 Radio, télévision, presse",null,null,null,0,0,0,0,0]
["79 Culte",null,null,null,1358.78,0,3894.04,0,4957.96]
["80>86 Action Sociale ",null,null,null,39932.720000000001,35059.769999999997,0,0,0]
["87 Santé publique et hygiène",null,null,null,35528.879999999997,31800.73,35810.400000000001,56249.07,20320.61]
["90>92 Logement",null,null,null,41179.199999999997,34324.449999999997,57531.11,70475.649999999994,30000]
["93 Aménagement du territoire",null,null,null,7500,7500,7500,7500,5878.46]

{"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 des Comptes"},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":2022}]
[{"$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":"Compte"},{"$f":"Coordonnées!$H$27","v":"Compte"},{"$f":"Coordonnées!$H$27","v":"Compte"},{"$f":"Coordonnées!$H$27","v":"Compte"},{"$f":"Coordonnées!$H$27","v":"Compte"}]
[{"$nulls":4},{"$f":"F7-1","v":2018},{"$f":"G7-1","v":2019},{"$f":"H7-1","v":2020},{"$f":"I7-1","v":2021},{"$f":"J2","v":2022}]
["0 Recettes et dépenses générales",null,null,null,349124.75,838813.65,199992.55,979870.16,1073436.8]
["1 Administration générale",null,null,null,10008.74,98616.74,44634.71,63585.2,606618.31999999995]
["3 Sécurité",null,null,null,0,0,0,0,0]
["4 Voiries-communications",null,null,null,1532440.53,154860.35,642721.82999999996,1476632.18,723932.47]
["5 Industrie - commerce",null,null,null,0,13800,16980.009999999998,5564.2,0]
["6 Sylviculture- Agriculture",null,null,null,10661.48,2098.8000000000002,734.58,7072.36,0]
["70>75 Enseignement",null,null,null,56150.15,33244.67,5163.8,70001.13,32925.08]
["76>77 Culture et sports",null,null,null,765135.93,55588.12,0,281264,76319.820000000007]
["78 Radio, télévision, presse",null,null,null,0,0,0,0,0]
["79 Culte",null,null,null,34108.379999999997,52726.96,63482.11,51855.32,2658.98]
["80>86 Action Sociale ",null,null,null,0,0,0,0,0]
["87 Santé publique et hygiène",null,null,null,46965.279999999999,86519.679999999993,46003.11,23118.61,27583.29]
["90>92 Logement",null,null,null,34240,115267.18,12237.33,6637.15,5962.11]
["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 des Comptes"},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":2022}]
[{"$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":"Compte"},{"$f":"Coordonnées!$H$27","v":"Compte"},{"$f":"Coordonnées!$H$27","v":"Compte"},{"$f":"Coordonnées!$H$27","v":"Compte"},{"$f":"Coordonnées!$H$27","v":"Compte"}]
[{"$nulls":4},{"$f":"F7-1","v":2018},{"$f":"G7-1","v":2019},{"$f":"H7-1","v":2020},{"$f":"I7-1","v":2021},{"$f":"J2","v":2022}]
["0 Recettes et dépenses générales",null,null,null,1633224.2,2094461.25,315056.03000000003,734897.16,1826866.98]
["1 Administration générale",null,null,null,74404.759999999995,34800,0,142645.20000000001,85625.4]
["3 Sécurité",null,null,null,0,0,0,0,0]
["4 Voiries-communications",null,null,null,205671.16,625176.68999999994,26520,1703409.65,282294.44]
["5 Industrie - commerce",null,null,null,0,13800,0,16980.009999999998,0]
["6 Sylviculture- Agriculture",null,null,null,0,0,0,5500,0]
["70>75 Enseignement",null,null,null,10000,26267.26,0,14427.7,36414.51]
["76>77 Culture et sports",null,null,null,527777.82999999996,250000,0,251022.45,0]
["78 Radio, télévision, presse",null,null,null,0,0,0,0,0]
["79 Culte",null,null,null,0,25482.6,38463.89,57342.07,0]
["80>86 Action Sociale ",null,null,null,0,0,0,0,0]
["87 Santé publique et hygiène",null,null,null,0,0,7500,59745,0]
["90>92 Logement",null,null,null,21790.42,5075,48878.47,1872,35789.360000000001]
["93 Aménagement du territoire",null,null,null,0,0,0,0,0]

{"sheet":"Actif","index":9,"n_rows":66,"n_cols":9,"rows_kept":66,"cut":false,"hidden":false,"merged":[[21,2,21,3],[0,2,1,2],[0,0,1,1],[2,0,2,4],[5,4,7,4],[0,6,0,7],[1,6,1,7],[2,6,2,7],[5,7,7,8],[5,5,7,6],[14,5,14,6],[15,5,15,6],[16,5,16,6],[17,5,17,6],[18,5,18,6],[19,5,19,6],[9,5,9,6],[0,3,1,5],[4,4,4,5],[11,5,11,6],[12,5,12,6],[13,5,13,6],[20,7,20,8],[21,7,21,8],[28,5,28,6],[29,5,29,6],[30,5,30,6],[31,5,31,6],[20,5,20,6],[21,5,21,6],[22,5,22,6],[23,5,23,6],[24,5,24,6],[25,5,25,6],[65,5,65,6],[14,7,14,8],[15,7,15,8],[16,7,16,8],[17,7,17,8],[18,7,18,8],[19,7,19,8],[56,5,56,6],[57,5,57,6],[58,5,58,6],[59,5,59,6],[60,5,60,6],[61,5,61,6],[50,5,50,6],[51,5,51,6],[52,5,52,6],[53,5,53,6],[54,5,54,6],[55,5,55,6],[44,5,44,6],[45,5,45,6],[46,5,46,6],[47,5,47,6],[48,5,48,6],[22,7,22,8],[23,7,23,8],[24,7,24,8],[25,7,25,8],[62,5,62,6],[63,5,63,6],[64,5,64,6],[49,5,49,6],[38,5,38,6],[39,5,39,6],[40,5,40,6],[41,5,41,6],[42,5,42,6],[43,5,43,6],[32,5,32,6],[33,5,33,6],[34,5,34,6],[35,5,35,6],[36,5,36,6],[37,5,37,6],[26,5,26,6],[27,5,27,6],[32,7,32,8],[33,7,33,8],[34,7,34,8],[35,7,35,8],[36,7,36,8],[37,7,37,8],[26,7,26,8],[27,7,27,8],[28,7,28,8],[29,7,29,8],[30,7,30,8],[31,7,31,8],[60,7,60,8],[61,7,61,8],[57,7,57,8],[58,7,58,8],[38,7,38,8],[39,7,39,8],[40,7,40,8],[41,7,41,8],[42,7,42,8],[43,7,43,8],[65,7,65,8],[8,7,8,8],[9,7,9,8],[10,7,10,8],[11,7,11,8],[12,7,12,8],[13,7,13,8],[59,7,59,8],[50,7,50,8],[51,7,51,8],[52,7,52,8],[62,7,62,8],[44,7,44,8],[45,7,45,8],[46,7,46,8],[47,7,47,8],[48,7,48,8],[49,7,49,8],[63,7,63,8],[64,7,64,8],[53,7,53,8],[54,7,54,8],[55,7,55,8],[56,7,56,8]]}
[{"$f":"Coordonnées!A1","v":"Synthèse des Comptes"},null,{"$f":"Coordonnées!D1","v":"Administration communale de"},{"$f":"Coordonnées!J1","v":"SOMME-LEUZE"},null,null,{"$f":"Coordonnées!P1","v":"Code INS"},null,{"$f":"Coordonnées!R1","v":91120}]
[{"$nulls":6},{"$f":"Coordonnées!P2","v":"Exercice:"},null,{"$f":"Coordonnées!R2","v":2022}]
[{"$f":"Coordonnées!A3","v":"Modèle officiel généré par l'application eComptes © SPW Intérieur et Action Sociale"},{"$nulls":5},{"$f":"Coordonnées!P3","v":"Version:"},null,{"$f":"Coordonnées!R3","v":1}]
[]
[]
["B I L A N ",null,null,null,"Codes",{"$f":"I2","v":2022},null,{"$f":"F6-1","v":2021}]
[]
[null,null,"A C T I F"]
[]
["ACTIFS IMMOBILISES",null,null,null,"21/28",{"$f":"F12+F14+F29+F35+F39","v":33618582.32},null,{"$f":"H12+H14+H29+H35+H39","v":32151106.779999997}]
[]
["I . ","Immobilisations incorporelles",null,null,21,5926.7,null,0]
[]
["II. ","Immobilisations corporelles",null,null,"22/26",{"$f":"SUM(F16:F27)","v":30874646.380000003},null,{"$f":"SUM(H16:H27)","v":29821889.909999996}]
[null,"Patrimoine immobilier"]
[null,"A.","Terres et terrains non bâtis ...............................................................................",null,220,4845085.16,null,4572537.46]
[null,"B.","Constructions et leurs terrains ...........................................................................",null,221,13636800.58,null,13031988.67]
[null,"C.","Voiries .........................................................................................................................",null,223,10226595.76,null,8053921.5499999998]
[null,"D.","Ouvrages d'art .............................................................................................................",null,224,154620.89000000001,null,162986.4]
[null,"E.","Cours et plans d'eau ......................................................................",null,226,0,null,0]
[null,"Patrimoine mobilier"]
[null,"F.","Mobilier, matériel, équipements et signalisation routière.............................................................",null,"230/3",506012.44,null,618680.9]
[null,"G.","Patrimoine artistique et mobilier divers .................................................................",null,234,0,null,0]
[null,"Autres immobilisations corporelles"]
[null,"H.","Immobilisations en cours d'exécution ...................................................................",null,24,1505531.55,null,3381774.93]
[null,"I.","Droits réels d'emphythéoses et superficies..................................................... .................................. ....................",null,261,0,null,0]
[null,"J.","Immobilisations en location-financement .............................................. ............................",null,"262/3",0,null,0]
[]
["III.","Subsides d'investissements accordés ",null,null,25,{"$f":"SUM(F30:F33)","v":11458.66},null,{"$f":"SUM(H30:H33)","v":15521.33}]
[null,"A.","Aux entreprises privées ..................................................................................... .....................",null,251,0,null,0]
[null,"B.","Aux ménages, ASBL et autres organismes ............................................... ........................",null,252,4666.6499999999996,null,5333.32]
[null,"C.","A l'Autorité supérieure......................................................................................... .....................",null,254,0,null,0]
[null,"D.","Aux autres pouvoirs publics ................................................................ ...................................",null,256,6792.01,null,10188.01]
[]
["IV.","Promesses de subsides à recevoir, prêts ",null,null,27,{"$f":"SUM(F36:F37)","v":1510030.6},null,{"$f":"SUM(H36:H37)","v":1120294.17}]
[null,"A.","Promesse de subsides à recevoir.................................................. ......................................",null,"270/4",1511850.56,null,1122114.1299999999]
[null,"B.","Prêts accordés ............................................................................ .............................................",null,275,-1819.96,null,-1819.96]
[]
["V.","Immobilisations financières",null,null,28,{"$f":"SUM(F40:F41)","v":1216519.98},null,{"$f":"SUM(H40:H41)","v":1193401.3700000001}]
[null,"A.","Participations et titres à revenus fixes ................................................................",null,"282/5",1215844.98,null,1192726.3700000001]
[null,"B.","Cautionnements versés à plus d'un an .............................................................",null,288,675,null,675]
[]
["ACTIFS CIRCULANTS",null,null,null,"30/58",{"$f":"F45+F47+F57+F59","v":4383958.8199999994},null,{"$f":"H45+H47+H57+H59","v":4518247.4499999993}]
[]
["VI. ","Stocks",null,null,301,0,null,0]
[]
["VII.","Créances à un an au plus",null,null,"40/42",{"$f":"F48+F49","v":760392.64},null,{"$f":"H48+H49","v":1750894.3499999999}]
[null,"A.","Débiteurs ................................................................................................................................................",null,40,94559.09,null,93054.32]
[null,"B.","Autres créances......................................................................................................................................",null,"41/42",{"$f":"SUM(F50:F55)","v":665833.55000000005},null,{"$f":"SUM(H50:H55)","v":1657840.0299999998}]
[null,null,"1. T.V.A. et taxes additionnelles ..........................................................................................................",null,"411/2",282515.94,null,342842.21]
[null,null,"2. Subsides, dons et legs et emprunts .............................................................................................",null,413,280934.76,null,1211174.44]
[null,null,"3. Intérêts, dividendes et ristournes ..................................................................................................",null,415,7373.66,null,6671.8]
[null,null,"4. Créances diverses  ..........................................................................................................................",null,"416/8",4528.97,null,4931.91]
[null,"C.","Récupérations des remboursements d'emprunts.........................................................................",null,4251,80300.179999999993,null,80219.67]
[null,"D.","Récupération des prêts........................................................................................................................",null,"425/8",10180.040000000001,null,12000]
[]
["VIII.","Opérations pour compte de tiers",null,null,"48/A",0,null,0]
[]
["IX.","Comptes financiers",null,null,"55/58",{"$f":"SUM(F60:F62)","v":3623566.1799999997},null,{"$f":"SUM(H60:H62)","v":2767353.0999999996}]
[null,"A.","Placements de trésorerie à un an au plus ......................................................................................",null,553,2750597.11,null,2158449.3199999998]
[null,"B.","Valeurs disponibles ..............................................................................................................................",null,55,872969.07,null,740187.28]
[null,"C.","Paiements en cours..............................................................................................................................",null,"56/8",0,null,-131283.5]
[]
["X.","Comptes de régularisation et d'attente ",null,null,"49/A",0,null,0]
[]
[null,null,"TOTAL DE L'ACTIF   ",null,"21/58",{"$f":"F10+F43+F64","v":38002541.140000001},null,{"$f":"H10+H43+H64","v":36669354.229999997}]

{"sheet":"Passif","index":10,"n_rows":57,"n_cols":9,"rows_kept":57,"cut":false,"hidden":false,"merged":[[46,7,46,8],[47,7,47,8],[48,7,48,8],[49,7,49,8],[56,7,56,8],[50,7,50,8],[51,7,51,8],[52,7,52,8],[53,7,53,8],[54,7,54,8],[55,7,55,8],[37,7,37,8],[38,7,38,8],[39,7,39,8],[40,7,40,8],[41,7,41,8],[42,7,42,8],[43,7,43,8],[44,7,44,8],[45,7,45,8],[28,7,28,8],[29,7,29,8],[30,7,30,8],[31,7,31,8],[32,7,32,8],[33,7,33,8],[34,7,34,8],[35,7,35,8],[36,7,36,8],[53,5,53,6],[54,5,54,6],[55,5,55,6],[56,5,56,6],[8,7,8,8],[9,7,9,8],[10,7,10,8],[11,7,11,8],[12,7,12,8],[13,7,13,8],[14,7,14,8],[15,7,15,8],[16,7,16,8],[17,7,17,8],[18,7,18,8],[19,7,19,8],[20,7,20,8],[21,7,21,8],[22,7,22,8],[23,7,23,8],[24,7,24,8],[25,7,25,8],[26,7,26,8],[27,7,27,8],[44,5,44,6],[45,5,45,6],[46,5,46,6],[47,5,47,6],[48,5,48,6],[49,5,49,6],[50,5,50,6],[51,5,51,6],[52,5,52,6],[35,5,35,6],[36,5,36,6],[37,5,37,6],[38,5,38,6],[39,5,39,6],[40,5,40,6],[41,5,41,6],[42,5,42,6],[43,5,43,6],[26,5,26,6],[27,5,27,6],[28,5,28,6],[29,5,29,6],[30,5,30,6],[31,5,31,6],[32,5,32,6],[33,5,33,6],[34,5,34,6],[17,5,17,6],[18,5,18,6],[19,5,19,6],[20,5,20,6],[21,5,21,6],[22,5,22,6],[23,5,23,6],[24,5,24,6],[25,5,25,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[11,5,11,6],[12,5,12,6],[13,5,13,6],[14,5,14,6],[15,5,15,6],[16,5,16,6],[0,0,1,1],[0,2,1,2],[2,0,2,4],[5,4,7,4],[0,6,0,7],[1,6,1,7],[2,6,2,7],[0,3,1,5],[5,7,7,8],[5,5,7,6]]}
[{"$f":"Coordonnées!A1","v":"Synthèse des Comptes"},null,{"$f":"Coordonnées!D1","v":"Administration communale de"},{"$f":"Coordonnées!J1","v":"SOMME-LEUZE"},null,null,{"$f":"Coordonnées!P1","v":"Code INS"},null,{"$f":"Coordonnées!R1","v":91120}]
[{"$nulls":6},{"$f":"Coordonnées!P2","v":"Exercice:"},null,{"$f":"Coordonnées!R2","v":2022}]
[{"$f":"Coordonnées!A3","v":"Modèle officiel généré par l'application eComptes © SPW Intérieur et Action Sociale"},{"$nulls":5},{"$f":"Coordonnées!P3","v":"Version:"},null,{"$f":"Coordonnées!R3","v":1}]
[]
[]
[null,null,"B I L A N ",null,"Codes",{"$f":"I2","v":2022},null,{"$f":"F6-1","v":2021}]
[]
[null,null,"P A S S I F"]
[]
[null,null,"FONDS PROPRES",null,"10/16",{"$f":"F12+F14+F16+F21+F25+F31","v":29681190.560000002},null,{"$f":"H12+H14+H16+H21+H25+H31","v":27650382.629999999}]
[]
["I'.","Capital ",null,null,10,6918449.2000000002,null,6918449.2000000002]
[]
["II'.","Résultats capitalisés",null,null,12,8354935.2400000002,null,7673366.9699999997]
[]
["III'.","Résultats reportés",null,null,13,{"$f":"SUM(F17:F19)","v":1504397.6},null,{"$f":"SUM(H17:H19)","v":2081568.55}]
[null,"A'.","Des exercices antérieurs...............................................................................................",null,1301,-65112.24,null,681568.27]
[null,"B'.","De l'exercice précédent...............................................................................................",null,1302,1465112.52,null,-65112.24]
[null,"C'.","Du dernier exercice.....................................................................................................",null,1303,104397.32,null,1465112.52]
[]
["IV'.","Réserves  ",null,null,14,{"$f":"SUM(F22:F23)","v":1706578.94},null,{"$f":"SUM(H22:H23)","v":711596.13}]
[null,"A'.","Fonds de réserve ordinaire.......................................................................................",null,14104,577601.59,null,577601.59]
[null,"B'.","Fonds de réserve extraordinaire.................................................................................",null,14105,1128977.3500000001,null,133994.54]
[]
["V'.","Subsides d'investissement, dons et legs reçus ",null,null,15,{"$f":"SUM(F26:F29)","v":8770816.1799999997},null,{"$f":"SUM(H26:H29)","v":8219388.3799999999}]
[null,"A'.","Des entreprises privées  .............................................................................................",null,151,44959.17,null,0]
[null,"B'.","Des ménages, des A.S.B.L. et autres organismes  .......................................................",null,152,54171.74,null,54477.88]
[null,"C'.","De l'Autorité supérieure  ..............................................................................................",null,154,8284150.4299999997,null,7739281]
[null,"D'.","Des autres pouvoirs publics   .....................................................................................",null,156,387534.84,null,425629.5]
[]
["VI'.","Provisions pour risques et charges  ",null,null,16,2426013.4,null,2046013.4]
[]
["DETTES",null,null,null,"17/49",{"$f":"F35+F44+F53","v":8190128.9799999995},null,{"$f":"H35+H44+H53","v":8732237.4800000004}]
[]
["VII'.","Dettes à plus d'un an ",null,null,17,{"$f":"SUM(F36:F42)","v":6609804.3099999996},null,{"$f":"SUM(H36:H42)","v":7462575.2200000007}]
[null,"A'.","Emprunts à charge de la commune ......................................................",null,"171/5",5927482.3099999996,null,6716004.9800000004]
[null,"B'.","Emprunts à charge de l'Autorité supérieure............................................",null,1714,682322,null,746570.23999999999]
[null,"C'.","Emprunts à charge de tiers..................................................................",null,172,0,null,0]
[null,"D'.","Dettes de location-financement............................................................",null,174,0,null,0]
[null,"E'.","Emprunts publics ...............................................................................",null,176,0,null,0]
[null,"F'.","Dettes diverses  à plus d'un an.............................................................",null,177,0,null,0]
[null,"G'.","Garanties reçues à plus d'un an............................................................",null,178,0,null,0]
[]
["VIII'.","Dettes à un an au plus",null,null,"43/6",{"$f":"F45+SUM(F49:F51)","v":1569671.06},null,{"$f":"H45+SUM(H49:H51)","v":1269433.6499999999}]
[null,"A'.","Dettes financières................................................................................",null,43,{"$f":"SUM(F46:F48)","v":993051.41},null,{"$f":"SUM(H46:H48)","v":923714.96}]
[null,null,"1'. Remboursements d'emprunts ..........................................................",null,435,959999.66,null,897698.2]
[null,null,"2'. Charges financières des emprunts ...................................................",null,436,33051.75,null,26016.76]
[null,null,"3'. Dettes sur comptes-courants...........................................................",null,433,0,null,0]
[null,"B'.","Dettes commerciales ..........................................................................",null,44,322139.58,null,284816.78999999998]
[null,"C'.","Dettes fiscales, salariales et sociales  ................................................................................................",null,45,237450.47,null,53422.67]
[null,"D'.","Dettes diverses ..................................................................................",null,"464/7",17029.599999999999,null,7479.23]
[]
["IX'.","Opérations pour compte de tiers",null,null,"48/P",10653.61,null,228.61]
[]
["X'.","Comptes de régularisation et d'attente  ",null,null,"49/P",131221.6,null,286734.12]
[]
[null,null,"TOTAL DU PASSIF   ",null,"10/49",{"$f":"F10+F33+F55","v":38002541.140000001},null,{"$f":"H10+H33+H55","v":36669354.229999997}]

{"sheet":"Charges","index":11,"n_rows":65,"n_cols":9,"rows_kept":65,"cut":false,"hidden":false,"merged":[[61,7,61,8],[62,7,62,8],[63,7,63,8],[64,7,64,8],[55,7,55,8],[56,7,56,8],[57,7,57,8],[58,7,58,8],[59,7,59,8],[48,7,48,8],[49,7,49,8],[50,7,50,8],[51,7,51,8],[52,7,52,8],[53,7,53,8],[60,7,60,8],[54,7,54,8],[39,7,39,8],[40,7,40,8],[41,7,41,8],[42,7,42,8],[43,7,43,8],[44,7,44,8],[45,7,45,8],[46,7,46,8],[47,7,47,8],[30,7,30,8],[31,7,31,8],[32,7,32,8],[33,7,33,8],[34,7,34,8],[35,7,35,8],[36,7,36,8],[37,7,37,8],[38,7,38,8],[64,5,64,6],[7,7,7,8],[8,7,8,8],[9,7,9,8],[10,7,10,8],[11,7,11,8],[12,7,12,8],[13,7,13,8],[14,7,14,8],[15,7,15,8],[16,7,16,8],[17,7,17,8],[18,7,18,8],[19,7,19,8],[20,7,20,8],[21,7,21,8],[22,7,22,8],[23,7,23,8],[24,7,24,8],[25,7,25,8],[26,7,26,8],[27,7,27,8],[28,7,28,8],[29,7,29,8],[55,5,55,6],[56,5,56,6],[57,5,57,6],[58,5,58,6],[59,5,59,6],[60,5,60,6],[61,5,61,6],[62,5,62,6],[63,5,63,6],[46,5,46,6],[47,5,47,6],[48,5,48,6],[49,5,49,6],[50,5,50,6],[51,5,51,6],[52,5,52,6],[53,5,53,6],[54,5,54,6],[37,5,37,6],[38,5,38,6],[39,5,39,6],[40,5,40,6],[41,5,41,6],[42,5,42,6],[43,5,43,6],[44,5,44,6],[45,5,45,6],[28,5,28,6],[29,5,29,6],[30,5,30,6],[31,5,31,6],[32,5,32,6],[33,5,33,6],[34,5,34,6],[35,5,35,6],[36,5,36,6],[19,5,19,6],[20,5,20,6],[21,5,21,6],[22,5,22,6],[23,5,23,6],[24,5,24,6],[25,5,25,6],[26,5,26,6],[27,5,27,6],[4,4,6,4],[0,6,0,7],[1,6,1,7],[2,6,2,7],[0,3,1,5],[4,5,6,6],[4,7,6,8],[50,1,51,3],[2,0,2,4],[0,0,1,1],[0,2,1,2],[22,1,23,3],[7,5,7,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[11,5,11,6],[12,5,12,6],[13,5,13,6],[14,5,14,6],[15,5,15,6],[16,5,16,6],[17,5,17,6],[18,5,18,6]]}
[{"$f":"Coordonnées!A1","v":"Synthèse des Comptes"},null,{"$f":"Coordonnées!D1","v":"Administration communale de"},{"$f":"Coordonnées!J1","v":"SOMME-LEUZE"},null,null,{"$f":"Coordonnées!P1","v":"Code INS"},null,{"$f":"Coordonnées!R1","v":91120}]
[{"$nulls":6},{"$f":"Coordonnées!P2","v":"Exercice:"},null,{"$f":"Coordonnées!R2","v":2022}]
[{"$f":"Coordonnées!A3","v":"Modèle officiel généré par l'application eComptes © SPW Intérieur et Action Sociale"},{"$nulls":5},{"$f":"Coordonnées!P3","v":"Version:"},null,{"$f":"Coordonnées!R3","v":1}]
[]
[{"$nulls":4},"Codes",{"$f":"I2","v":2022},null,{"$f":"F5-1","v":2021}]
[null,null,"COMPTE DE RESULTATS"]
[]
["I. ","Charges courantes",null,null," "]
[null,"A.","Achats de matières ..............................................................................................",null,60,911488.27,null,800280.97]
[null,"B.","Services et biens d'exploitation .........................................................................",null,61,817443.32,null,734260.01]
[null,"C.","Frais de personnel ..............................................................................................",null,62,3404821.7,null,3288054.73]
[null,"D.","Subsides d'exploitation accordés ...................................................................",null,63,1770374.06,null,1741306.99]
[null,"E.","Remboursements des emprunts ...................................................................",null,64,793723.91,null,736225.69]
[null,"F.","Charges financières",null,65,{"$f":"SUM(F15:F17)","v":136513.75},null,{"$f":"SUM(H15:H17)","v":129055.86}]
[null," ","a.  Charges financières des emprunts ...........................................................",null,"651/6",136273.54,null,128786.1]
[null,null,"b.  Charges financières diverses ....................................................................",null,657,0,null,88.4]
[null,null,"c.  Frais de la gestion financière .....................................................................",null,658,240.21,null,181.36]
[]
["II.","Sous-total  (charges courantes)",null,null,"60/65",{"$f":"SUM(F9:F14)","v":7834365.0099999998},null,{"$f":"SUM(H9:H14)","v":7429184.2500000009}]
[]
["III.","Boni courant (II' - II)",null,null," ",{"$f":"IF(Charges!F19<Produits!F19,Produits!F19-Charges!F19,0)","v":427274.73999999929},null,{"$f":"IF(Charges!H19<Produits!H19,Produits!H19-Charges!H19,0)","v":0}]
[]
["IV.","Charges résultant de la variation normale des valeurs de bilan, redressements et provisions",null,null,""]
[]
[null,"A.","Dotations aux amortissements .........................................................................",null,660,1484610.46,null,1084879.1200000001]
[null,"B.","Réductions annuelles de valeurs .....................................................................",null,661,0,null,0]
[null,"C.","Réductions et variations des stocks ...............................................................",null,"662/4",0,null,0]
[null,"D.","Redressement des récupérations des "]
[null,null,"remboursements d'emprunts ...........................................................................",null,665,64183.72,null,64120.12]
[null,"E.","Provisions pour risques et charges ...............................................................",null,666,380000,null,0]
[null,"F.","Dotations aux amortissements des subsides ",null," "]
[null,null,"d'investissement accordés ...............................................................................",null,667,4062.67,null,4062.66]
[]
["V.","Sous-total (charges non décaissées)",null,null,66,{"$f":"SUM(F25:F32)","v":1932856.8499999999},null,{"$f":"SUM(H25:H32)","v":1153061.9000000001}]
[]
["VI.","Total des charges d'exploitation (II + V)",null,null,"60/66",{"$f":"F19+F34","v":9767221.8599999994},null,{"$f":"H19+H34","v":8582246.1500000004}]
[]
["VII.","Boni d'exploitation (VI' - VI)",null,null," ",{"$f":"IF(Charges!F36<Produits!F33,Produits!F33-Charges!F36,0)","v":954506.01999999955},null,{"$f":"IF(Charges!H36<Produits!H33,Produits!H33-Charges!H36,0)","v":749098.91999999993}]
[]
["VIII.","Charges exceptionnelles"]
[null,"A.","Du service ordinaire ............................................................................................",null,671,6260.83,null,4782.46]
[null,"B.","Du service extraordinaire ..................................................................................",null,672,1819.96,null,5564.2]
[null,"C.","Charges exceptionnelles non budgétées .....................................................",null,673,0,null,0]
[null,null,"Sous-total (charges exceptionnelles)",null,67,{"$f":"SUM(F41:F43)","v":8080.79},null,{"$f":"SUM(H41:H43)","v":10346.66}]
[]
["IX.","Dotations aux réserves"]
[null,"A.","Du service ordinaire .........................................................................................",null,685,0,null,0]
[null,"B.","Du service extraordinaire ................................................................................",null,686,1073436.8,null,75075.97]
[null,null,"Sous-total des dotations aux réserves",null,68,{"$f":"SUM(F47:F48)","v":1073436.8},null,{"$f":"SUM(H47:H48)","v":75075.97}]
[]
["X.","Total des charges exceptionnelles et des dotations aux réserves (VIII + IX)"]
[{"$nulls":4},"67/68",{"$f":"F44+F49","v":1081517.5900000001},null,{"$f":"H44+H49","v":85422.63}]
[]
["XI.","Boni exceptionnel  (X' - X)",null,null,null,{"$f":"IF(Charges!F52<Produits!F51,Produits!F51-Charges!F52,0)","v":0},null,{"$f":"IF(Charges!H52<Produits!H51,Produits!H51-Charges!H52,0)","v":716013.6}]
[]
["XII.","Total des charges (VI + X)",null,null,null,{"$f":"F36+F52","v":10848739.449999999},null,{"$f":"H36+H52","v":8667668.7800000012}]
[]
["XIII.","Boni de l'exercice (XII' - XII)",null,null,null,{"$f":"IF(Charges!F56<Produits!F55,Produits!F55-Charges!F56,0)","v":104397.3200000003},null,{"$f":"IF(Charges!H56<Produits!H55,Produits!H55-Charges!H56,0)","v":1465112.5199999996}]
[]
["XIV.","Affectation des bonis (XIII)"]
[null,"A.","Boni d'exploitation à reporter au bilan ............................................................",null,69201,954506.02,null,749098.92]
[null,"B.","Boni exceptionnel à reporter au bilan .............................................................",null,69202,0,null,716013.6]
[null,null,"Sous-total (affectation des résultats)",null,69,{"$f":"SUM(F61:F62)","v":954506.02},null,{"$f":"SUM(H61:H62)","v":1465112.52}]
[]
["XV.","Contrôle de balance (XII + XIV = XV')",null,null,null,{"$f":"F56+F63","v":11803245.469999999},null,{"$f":"H56+H63","v":10132781.300000001}]

{"sheet":"Produits","index":12,"n_rows":65,"n_cols":9,"rows_kept":65,"cut":false,"hidden":false,"merged":[[63,7,63,8],[64,7,64,8],[56,7,56,8],[57,7,57,8],[58,7,58,8],[59,7,59,8],[60,7,60,8],[61,7,61,8],[48,7,48,8],[49,7,49,8],[50,7,50,8],[51,7,51,8],[52,7,52,8],[53,7,53,8],[54,7,54,8],[55,7,55,8],[62,7,62,8],[39,7,39,8],[40,7,40,8],[41,7,41,8],[42,7,42,8],[43,7,43,8],[44,7,44,8],[45,7,45,8],[46,7,46,8],[47,7,47,8],[30,7,30,8],[31,7,31,8],[32,7,32,8],[33,7,33,8],[34,7,34,8],[35,7,35,8],[36,7,36,8],[37,7,37,8],[38,7,38,8],[64,5,64,6],[7,7,7,8],[8,7,8,8],[9,7,9,8],[10,7,10,8],[11,7,11,8],[12,7,12,8],[13,7,13,8],[14,7,14,8],[15,7,15,8],[16,7,16,8],[17,7,17,8],[18,7,18,8],[19,7,19,8],[20,7,20,8],[21,7,21,8],[22,7,22,8],[23,7,23,8],[24,7,24,8],[25,7,25,8],[26,7,26,8],[27,7,27,8],[28,7,28,8],[29,7,29,8],[55,5,55,6],[56,5,56,6],[57,5,57,6],[58,5,58,6],[59,5,59,6],[60,5,60,6],[61,5,61,6],[62,5,62,6],[63,5,63,6],[46,5,46,6],[47,5,47,6],[48,5,48,6],[49,5,49,6],[50,5,50,6],[51,5,51,6],[52,5,52,6],[53,5,53,6],[54,5,54,6],[37,5,37,6],[38,5,38,6],[39,5,39,6],[40,5,40,6],[41,5,41,6],[42,5,42,6],[43,5,43,6],[44,5,44,6],[45,5,45,6],[28,5,28,6],[29,5,29,6],[30,5,30,6],[31,5,31,6],[32,5,32,6],[33,5,33,6],[34,5,34,6],[35,5,35,6],[36,5,36,6],[19,5,19,6],[20,5,20,6],[21,5,21,6],[22,5,22,6],[23,5,23,6],[24,5,24,6],[25,5,25,6],[26,5,26,6],[27,5,27,6],[22,1,23,3],[27,2,27,3],[0,0,1,1],[0,2,1,2],[2,0,2,4],[4,4,6,4],[1,6,1,7],[2,6,2,7],[0,3,1,5],[4,5,6,6],[4,7,6,8],[7,5,7,6],[0,6,0,7],[8,5,8,6],[9,5,9,6],[10,5,10,6],[11,5,11,6],[12,5,12,6],[13,5,13,6],[14,5,14,6],[15,5,15,6],[16,5,16,6],[17,5,17,6],[18,5,18,6]]}
[{"$f":"Coordonnées!A1","v":"Synthèse des Comptes"},null,{"$f":"Coordonnées!D1","v":"Administration communale de"},{"$f":"Coordonnées!J1","v":"SOMME-LEUZE"},null,null,{"$f":"Coordonnées!P1","v":"Code INS"},null,{"$f":"Coordonnées!R1","v":91120}]
[{"$nulls":6},{"$f":"Coordonnées!P2","v":"Exercice:"},null,{"$f":"Coordonnées!R2","v":2022}]
[{"$f":"Coordonnées!A3","v":"Modèle officiel généré par l'application eComptes © SPW Intérieur et Action Sociale"},{"$nulls":5},{"$f":"Coordonnées!P3","v":"Version:"},null,{"$f":"Coordonnées!R3","v":1}]
[]
[{"$nulls":4},"Codes",{"$f":"I2","v":2022},null,{"$f":"F5-1","v":2021}]
["COMPTE DE RESULTATS"]
[]
["I'. ","Produits courants",null,null," "]
[null,"A'.","Produits de la fiscalité ..........................................................................",null,70,4022686.75,null,3525760.24]
[null,"B'.","Produits d'exploitation .........................................................................",null,71,491577.97,null,431133.56]
[null,"C'.","Subsides d'exploitation reçus et récupérations de "]
[null,null,"charges de personnel ...........................................................................",null,"72/73",3621893.54,null,3264363.98]
[null,"D'.","Récupération des remboursements d'emprunts .......................................",null,74,64183.72,null,64120.12]
[null,"E'.","Produits financiers",null,75,{"$f":"SUM(F16:F17)","v":61297.770000000004},null,{"$f":"SUM(H16:H17)","v":82035.38}]
[null," ","a'.  Récupération des charges financières des "]
[null,null,"      emprunts et des prêts accordés ......................................................................",null,"751/5",28814.63,null,30398.9]
[null,null,"b'   Produits financiers divers ................................................................",null,"754/7",32483.14,null,51636.480000000003]
[]
["II'.","Sous-total  (produits courants)",null,null,"70/75",{"$f":"SUM(F9:F14)","v":8261639.7499999991},null,{"$f":"SUM(H9:H14)","v":7367413.2800000003}]
[]
["III'.","Mali courant (II - II')",null,null," ",{"$f":"IF(Charges!F19>Produits!F19,Charges!F19-Produits!F19,0)","v":0},null,{"$f":"IF(Charges!H19>Produits!H19,Charges!H19-Produits!H19,0)","v":61770.970000000671}]
[]
["IV'.","Produits résultant de la variation normale des valeurs de bilan, redressements, travaux internes",null,null,""]
[]
[null,"A'.","Plus-values annuelles ..........................................................................",null,761,1210883.43,null,677380.61]
[null,"B'.","Variations des stocks ..........................................................................",null,764,0,null,0]
[null,"C'.","Redressement des cptes des remb. des emprunts ...........",null,765,793723.91,null,736225.69]
[null,"D'.","Réductions des subsides d'investissement, des dons et legs obtenus ..................................................................",null,767,455480.79,null,550325.49]
[null,"E'.","Travaux internes passés à l'immobilisé ...................................................",null,769,0,null,0]
[]
["V'.","Sous-total (produits non encaissés)",null,null,76,{"$f":"SUM(F25:F29)","v":2460088.13},null,{"$f":"SUM(H25:H29)","v":1963931.7899999998}]
[]
["VI'.","Total des produits d'exploitation (II' + V')",null,null,"70/76",{"$f":"F19+F31","v":10721727.879999999},null,{"$f":"H19+H31","v":9331345.0700000003}]
[]
["VII'.","Mali d'exploitation (VI - VI')",null,null," ",{"$f":"IF(Charges!F36>Produits!F33,Charges!F36-Produits!F33,0)","v":0},null,{"$f":"IF(Charges!H36>Produits!H33,Charges!H36-Produits!H33,0)","v":0}]
[]
["VIII'.","Produits exceptionnels"]
[null,"A'.","Du service ordinaire .............................................................................",null,771,59434.48,null,44073.09]
[null,"B'.","Du service extraordinaire .......................................................................",null,772,93520.42,null,14838.97]
[null,"C'.","Produits exceptionnels non budgétés ................................................",null,773,0,null,5564.2]
[]
[null,null,"Sous-total (produits exceptionnels)",null,77,{"$f":"SUM(F38:F40)","v":152954.9},null,{"$f":"SUM(H38:H40)","v":64476.259999999995}]
[]
["IX'.","Prélèvements sur les réserves"]
[null,"A'.","Du service ordinaire .............................................................................",null,785,0,null,0]
[null,"B'.","Du service extraordinaire .......................................................................",null,786,78453.990000000005,null,736959.97]
[]
[null,null,"Sous-total des prélèvements sur réserves",null,78,{"$f":"SUM(F45:F46)","v":78453.990000000005},null,{"$f":"SUM(H45:H46)","v":736959.97}]
[]
["X'.","Total des produits exceptionnels et des"]
[null,"prélèvements sur réserves (VIII' + IX')",null,null,"77/78",{"$f":"F42+F48","v":231408.89},null,{"$f":"H42+H48","v":801436.23}]
[]
["XI'.","Mali exceptionnel  (X - X')",null,null,null,{"$f":"IF(Charges!F52>Produits!F51,Charges!F52-Produits!F51,0)","v":850108.70000000007},null,{"$f":"IF(Charges!H52>Produits!H51,Charges!H52-Produits!H51,0)","v":0}]
[]
["XII'.","Total des produits (VI' + X')",null,null,null,{"$f":"F33+F51","v":10953136.77},null,{"$f":"H33+H51","v":10132781.300000001}]
[]
["XIII'.","Mali de l'exercice (XII - XII')",null,null,null,{"$f":"IF(Charges!F56>Produits!F55,Charges!F56-Produits!F55,0)","v":0},null,{"$f":"IF(Charges!H56>Produits!H55,Charges!H56-Produits!H55,0)","v":0}]
[]
["XIV'.","Affectation des malis (XIII')"]
[null,"A'.","Mali d'exploitation à reporter au bilan .....................................................",null,79201,0,null,0]
[null,"B'.","Mali exceptionnel à reporter au bilan ......................................................",null,79202,850108.7,null,0]
[]
[null,null,"Sous-total (affectation des résultats)",null,79,{"$f":"SUM(F60:F61)","v":850108.7},null,{"$f":"SUM(H60:H61)","v":0}]
[]
["XV'.","Contrôle de balance (XII' + XIV' = XV)",null,null,null,{"$f":"F55+F63","v":11803245.469999999},null,{"$f":"H55+H63","v":10132781.300000001}]

{"sheet":"Commentaires","index":13,"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 des Comptes"},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":2022}]
[{"$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":14,"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 des Comptes"},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":2022}]
[{"$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 … )"]