{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["28. Tableau des AUBU","29. budget 2020 par destination","30. Poste Investissement","31 Postes Fonctionnement","32. Recettes par origines","33. Situation patrimoniale","34. Exécution du budget","35. dépenses dirigeants"],"not_rendered":{"charts":8,"images":1,"macros":0,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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":"28. Tableau des AUBU","index":0,"n_rows":30,"n_cols":11,"rows_kept":30,"cut":false,"hidden":false,"merged":[[2,0,2,10],[13,0,13,10],[3,7,3,10],[14,7,14,10],[3,0,5,0],[3,1,3,2],[3,3,3,4],[3,5,3,6],[14,0,15,0],[28,7,28,10],[4,1,4,2],[4,3,4,4],[4,5,4,6],[4,7,4,8],[28,1,28,2],[28,3,28,4],[28,5,28,6],[14,1,14,2],[14,3,14,4],[14,5,14,6],[4,9,4,10]]}
["Tableau des autorisations budgétaires"]
[]
["DEPENSES"]
[null,"CF 2019",null,"BI 2020\nvoté le 28 novembre 2019",null,"BR 2020\nvoté le 26 novembre 2020",null,"CF 2020"]
[null,"Montants",null,"Montants",null,"Montants",null,"Montants",null,"taux de réalisation"]
[null,"AE","CP","AE","CP","AE","CP","AE","CP","AE","CP"]
[]
["Personnel",140922264.92000002,140922264.92000002,143781760,143781760,144588972,144588972,144409864.20999998,144409864.20999998,{"$f":"+H8/F8","v":0.99876126244261543},{"$f":"+I8/G8","v":0.99876126244261543}]
["Fonctionnement",48545727.859999992,49383935.82,55186491.039999999,52490307.389999986,51280363.399999999,49422051.209999986,47779569.650000021,44656859.06000001,{"$f":"+H9/F9","v":0.93173227493157784},{"$f":"+I9/G9","v":0.90358165973823856}]
["Investissement",35853044.559999987,34420845.729999989,58795120.579999998,51793088.579999998,46753042.140000001,38727152.890000001,42597287.349999994,37896175.700000003,0.91111263353610716,0.97854277611472518]
[]
["TOTAL DES DEPENSES - AE (A) CP (B)",{"$f":"SUM(B8:B11)","v":225321037.33999997},{"$f":"SUM(C8:C11)","v":224727046.47},257763371.62,248065155.96999997,242622377.54000002,232738176.09999996,234786721.21000001,226962898.96999997,{"$f":"+H12/F12","v":0.96770431314107375},{"$f":"+I12/G12","v":0.97518551865114489}]
[]
["RECETTES"]
[null,{"$f":"+B4","v":"CF 2019"},null,{"$f":"D4","v":"BI 2020\nvoté le 28 novembre 2019"},null,{"$f":"F4","v":"BR 2020\nvoté le 26 novembre 2020"},null,{"$f":"H4","v":"CF 2020"}]
[null,null,"Montants",null,"Montants",null,"Montants",null,"Montants",null,"Taux de réalisation"]
["Recettes globalisées",null,{"$f":"SUM(C18:C20)","v":213208703.43999997},null,{"$f":"SUM(E18:E20)","v":216664303},null,{"$f":"SUM(G18:G20)","v":215304900.28999999},null,{"$f":"SUM(I18:I20)","v":215964457.96000004},null,{"$f":"+I17/G17","v":1.0030633658087282}]
["Subvention pour charges de service public",null,181840385,null,183232611,null,184039823,null,184537094,null,{"$f":"+I18/G18","v":1.0027019749959225}]
["Autres financements de l'Etat",null,20899240,null,22737392,null,22737392,null,23112392,null,1.0164926566775996]
["Recettes propres",null,10469078.43999997,null,10694300,null,8527685.2899999991,null,8314971.9600000232,null,0.97505614680112385]
[]
["Recettes fléchées*",null,{"$f":"SUM(C23:C25)","v":7754162.4899999993},null,{"$f":"SUM(E23:E25)","v":16424732.860000001},null,{"$f":"SUM(G23:G25)","v":5827254.6400000006},null,{"$f":"SUM(I23:I25)","v":6409085.9000000004},null,{"$f":"+I22/G22","v":1.0998465479792385}]
["Financements de l'Etat fléchés",null,656591.96,null,50000,null,182859.16999999998,null,463722.35,null,2.5359534881406276]
["Autres financements publics fléchés",null,841695.38,null,1920828.8,null,570200.07000000007,null,630446.99,null,1.105659264475362]
["Recettes propres fléchées",null,6255875.1499999994,null,14453904.060000001,null,5074195.4000000004,null,5314916.5600000005,null,1.0474402621546659]
[]
["TOTAL DES RECETTES (C)",null,{"$f":"C17+C22","v":220962865.92999998},null,{"$f":"E17+E22","v":233089035.86000001},null,{"$f":"G17+G22","v":221132154.93000001},null,{"$f":"I17+I22","v":222373543.86000004},null,{"$f":"+I27/G27","v":1.0056137875126889}]
[]
["SOLDE BUDGETAIRE",{"$f":"B15","v":"CF 2019"},null,{"$f":"D15","v":"BI 2020\nvoté le 28 novembre 2019"},null,{"$f":"F4","v":"BR 2020\nvoté le 26 novembre 2020"},null,{"$f":"H4","v":"CF 2020"}]
["Abondement ou prélèvement sur la trésorerie",null,{"$f":"+C27-C12","v":-3764180.5400000215},null,{"$f":"+E27-E12","v":-14976120.109999955},null,{"$f":"+G27-G12","v":-11606021.169999957},null,{"$f":"+I27-I12","v":-4589355.1099999249}]

{"sheet":"29. budget 2020 par destination","index":1,"n_rows":57,"n_cols":21,"rows_kept":57,"cut":false,"hidden":false,"merged":[[2,7,2,8],[2,10,2,11],[4,0,12,0],[14,0,22,0],[41,0,53,0],[2,0,3,0],[24,0,39,0],[2,1,3,1],[2,4,2,5]]}
[" Le budget 2020 par destinations (rang 1 & 2) - en AE & CP"]
[]
["Dest 1","Destination de niveau 2","Personnel",null,"Fonctionnement",null,null,"Investissement",null,null,"TOTAL"]
[null,null,"AE=CP",null,"AE","CP",null,"AE","CP",null,"AE","CP"]
["Patrimoine immobilier","Projet Richelieu",1017609.1732910353,null,438195.82999999996,339723.24000000011,null,8225022.9399999995,7698713.1600000001,null,{"$f":"+C5+E5+H5","v":9680827.9432910345},{"$f":"+C5+F5+I5","v":9056045.5732910354},null,null,"CP",null,null,null,null,"CP"]
[null,"Richelieu et annexes",172267.89732118978,null,313467.07,302308.23,null,11664.92,4948.09,null,497399.8873211898,479524.21732118976,null,null,"Personnel",{"$f":"+C57","v":144409864.21000004},null,null,null,"Patrimoine immobilier",{"$f":"+L14","v":22510894.488048755}]
[null,"François Mitterrand",573521.52146428905,null,83372.239999999991,75184.45,null,7918977.1900000004,3794702.7800000003,null,8575870.9514642898,4443408.7514642896,null,null,"Fonctionnement",{"$f":"+F57","v":44656859.060000002},null,null,null,"Patrimoine collections",{"$f":"+L24","v":83172066.921598852}]
[null,"Bussy",52611.59413313523,null,0,0,null,0,1654.1000000000001,null,52611.59413313523,54265.694133135228,null,null,"Investissement",{"$f":"+I57","v":37896175.700000003},null,null,null,"Diffusion valorisation",{"$f":"+L41","v":57806289.785224348}]
[null,"Arsenal",49005.617119412316,null,0,0,null,81272.56,227347.72999999998,null,130278.17711941231,276353.34711941227,null,null,null,null,null,null,null,"Fonctions support",{"$f":"+L55","v":63473647.775128067}]
[null,"Bibliothèque musée de l'Opéra",31484.135859440888,null,6292.36,null,null,null,null,null,37776.495859440889,31484.135859440888]
[null,"Sablé",12575.819210166697,null,44979.31,56302.81,null,0,757.57,null,57555.129210166691,69636.199210166698]
[null,"Boulevard St Michel",7252.9543345944694,null,2196.85,1183.79,null,150511.79999999999,13387.8,null,159961.60433459445,21824.54433459447]
[null,"Multisites",79466.795315494644,null,5873439.0099999998,5519107.5599999996,null,2237122.96,2479777.67,null,8190028.7653154945,8078352.0253154943]
["Total Patrimoine immobilier",null,{"$f":"SUM(C5:C13)","v":1995795.5080487588},null,{"$f":"SUM(E5:E13)","v":6761942.6699999999},6293810.0800000001,null,18624572.370000001,14221288.900000002,null,27382310.548048757,22510894.488048755]
["Patrimoine collections","Dépôt légal ",5572845.7982728444,null,335159.87,311159.87,null,466183.64999999997,770246.75,null,{"$f":"+C15+E15+H15","v":6374189.3182728449},{"$f":"+C15+F15+I15","v":6654252.4182728445}]
[null,"Pôles associés",1041361.6762299213,null,1312147.46,1276276.8900000001,null,98040.19,78880.98,null,2451549.3262299211,2396519.5462299213]
[null,"Acquisitions",8947986.9827181976,null,2267772.33,2010771.74,null,6517312.9800000014,6418995.9499999993,null,17733072.292718198,17377754.672718197]
[null,"Constitution des collections numériques",5931420.1344873495,null,225638.1,125449.38,null,2513815.2100000004,1872221.99,null,8670873.4444873501,7929091.5044873497]
[null,"Restauration/conservation",16039843.935471909,null,2169532.52,1855807.2400000005,null,542366.89999999991,544354.65,null,18751743.355471909,18440005.825471908]
[null,"Sûreté des collections",2532430.0963813104,null,10414.879999999999,10414.879999999999,null,0,0,null,2542844.9763813103,2542844.9763813103]
[null,"Stockage des collections physiques",2127148.210263073,null,316225.15000000002,444029.69,null,271913.67,600844.65999999992,null,2715287.0302630728,3172022.5602630731]
[null,"Catalogage hors informatique",20365900.118577283,null,0,0,null,74194.16,228519.41,null,20440094.278577283,20594419.528577283]
[null,"SIBIB/SINUM pour conservation",2050918.3891969637,null,308736.92000000004,248032.84,null,2025805.7300000002,1766204.6600000001,null,4385461.0391969644,4065155.889196964]
["Total Patrimoine collections",null,{"$f":"SUM(C15:C23)","v":64609855.341598853},null,{"$f":"SUM(E15:E23)","v":6945627.2300000004},6281942.5300000003,null,12509632.490000002,12280269.050000001,null,84065115.061598867,83172066.921598852]
["Diffusion et valorisation","Accueil",3134293.0801620972,null,260260.66999999998,283210.08,null,31721.46,65949.350000000006,null,{"$f":"+C25+E25+H25","v":3426275.2101620971},{"$f":"+C25+F25+I25","v":3483452.5101620974}]
[null,"Mise à disposition des collections physiques",10528951.651316019,null,1305579.1299999999,1409459.28,null,714326.04,663680.64,null,12548856.821316019,12602091.571316019]
[null,"Exception handicap",274373.03043102217,null,0,0,null,168701.2,126583.53,null,443074.23043102218,400956.5604310222]
[null,"Education artistique et cultutelle",null,null,165238.66,146530.51,null,5095.08,5095.08,null,{"$f":"+C28+E28+H28","v":170333.74},{"$f":"+C28+F28+I28","v":151625.59}]
[null,"Services à distance",5760673.33035916,null,345455,407567.61000000004,null,1642727.5899999999,1742054.38,null,7748855.9203591598,7910295.3203591602]
[null,"Reproduction",4568848.7269551568,null,88656.18,76060.92,null,132675.24,14079.74,null,4790180.1469551567,4658989.3869551569]
[null,"Éditions et produits dérivés",2002550.3268537128,null,839415.01,770868.19,null,342840.15,408800.03,null,3184805.4868537127,3182218.5468537128]
[null,"Expositions",3307876.080537295,null,945176.53999999992,837495.49,null,848295.01,343573.88,null,5101347.6305372948,4488945.4505372951]
[null,"Manifestations",1979239.6022243535,null,199963.94,191152.22000000003,null,168132.5,168132.5,null,2347336.0422243536,2338524.3222243534]
[null,"Actions pédagogiques et éducatives",1063026.238527263,null,0,0,null,2546.6,2546.6,null,1065572.8385272631,1065572.8385272631]
[null,"Formation professionnelle",684934.73110232549,null,7344.86,5086.6099999999997,null,0,0,null,692279.59110232547,690021.34110232547]
[null,"Recherche scientifique",2137861.5905210129,null,177937.29,157242.57,null,0,1613.51,null,2315798.8805210129,2296717.6705210125]
[null,"Activités internationales",1012552.8104119292,null,69989.27,67869.259999999995,null,464.34,35173.339999999997,null,1083006.4204119293,1115595.4104119292]
[null,"SIBIB/SINUM pour communication",2276397.5283455537,null,260860.38999999998,190146.41999999998,null,2694567.2100000004,1860751.29,null,5231825.1283455547,4327295.2383455541]
[null,"Service public sur place",9093988.0274774469,null,null,null,null,null,null,null,9093988.0274774469,9093988.0274774469]
[null,"Participation à la filiale",0,null,0,0,null,0,0,null,0,0]
["Total Diffusion et valorisation",null,{"$f":"SUM(C25:C40)","v":47825566.755224347},null,{"$f":"SUM(E25:E40)","v":4665876.9399999985},{"$f":"SUM(F25:F40)","v":4542689.16},null,{"$f":"SUM(H25:H40)","v":6752092.4199999999},{"$f":"SUM(I25:I40)","v":5438033.8699999992},null,{"$f":"SUM(K25:K40)","v":59243536.115224347},{"$f":"SUM(L25:L40)","v":57806289.785224348}]
["Fonctions support","Sécurité et sûreté",2331285.6645331173,null,9405160.6500000004,8532017.0099999998,null,64227.8,39126.949999999997,null,{"$f":"+C42+E42+H42","v":11800674.114533119},{"$f":"+C42+F42+I42","v":10902429.624533117}]
[null,"Logistique / exploitation",5006863.2082855124,null,12689889.699999999,12151652.289999999,null,295321.09999999998,842204.32,null,17992074.008285515,18000719.81828551]
[null,"Locations immobilières et charges",349593.21893359639,null,345573.39999999997,439639.63,null,0,0,null,695166.61893359642,789232.8489335964]
[null,"Pilotage stratégie",4032435.5584834241,null,235797.3,243880.1,null,195609.32,267223.52,null,4463842.1784834247,4543539.1784834247]
[null,"Frais de mission",109420.59471061251,null,50731.55,49202.55,null,0,0,null,160152.14471061251,158623.14471061251]
[null,"Communication",1719245.3795103594,null,342113.26,357728.61,null,177566.88,344998.85,null,2238925.5195103595,2421972.8395103593]
[null,"Dépenses relatives au personnel",7274770.9332801197,null,694255.98,601749.04999999993,null,378756.01,591736.75,null,8347782.9232801199,8468256.7332801186]
[null,"Informatique transverse",0,null,4199956.3100000005,4137914.45,null,1337826.6099999999,1933284.67,null,5537782.9199999999,6071199.1200000001]
[null,"Informatique bureautique",1891524.5701182312,null,304515.44,146353.82,null,1798956.0499999998,1520070.96,null,3994996.060118231,3557949.350118231]
[null,"Documentation",77458.805272889978,null,186271.72999999998,193385.57,null,0,0,null,263730.53527288995,270844.37527288997]
[null,"Charges financières",0,null,198943.34,196437.84999999995,null,80,80,null,199023.34,196517.84999999995]
[null,"Gestion administrative",7186048.6720002107,null,606412.76,379646.14999999997,null,462646.3,417857.86,null,8255107.7320002103,7983552.6820002114]
[null,"Personnel",0,null,146501.38999999998,108810.20999999999,null,0,0,null,146501.38999999998,108810.20999999999]
["Total Fonctions support",null,{"$f":"SUM(C42:C54)","v":29978646.605128072},null,{"$f":"SUM(E42:E54)","v":29406122.81000001},{"$f":"SUM(F42:F54)","v":27538417.289999999},null,4710990.0699999994,5956583.8799999999,null,64095759.485128082,63473647.775128067]
[]
["Total charges décaissables",null,{"$f":"C14+C24+C41+C55","v":144409864.21000004},null,{"$f":"E14+E24+E41+E55","v":47779569.650000006},{"$f":"F14+F24+F41+F55","v":44656859.060000002},null,{"$f":"H14+H24+H41+H55","v":42597287.350000001},{"$f":"I14+I24+I41+I55","v":37896175.700000003},null,{"$f":"K14+K24+K41+K55","v":234786721.21000007},{"$f":"L14+L24+L41+L55","v":226962898.97000003}]

{"sheet":"30. Poste Investissement","index":2,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Postes d'investissement en CP","CF 2017","CF 2018","CF 2019","CF 2020"]
["Travaux",7505524.160000002,10617413.529999997,8496352.209999999,15506359.239999996]
["Informatique",8012280.21,7963431.5199999996,13371738.68,11486845.529999999]
["Acquisitions",7171136.0700000022,7480792.9100000011,6259136.1799999997,6418995.9499999993]
["Numérisation des collections",6939769.3000000007,3202189.55,2437310.2999999998,1846597.51]
["Autres",4517128.5199999996,3270953.9300000006,3856308.36,2637377.4699999997]
[null,{"$f":"SUM(B4:B8)","v":34145838.260000005},{"$f":"SUM(C4:C8)","v":32534781.439999998},{"$f":"SUM(D4:D8)","v":34420845.730000004},{"$f":"SUM(E4:E8)","v":37896175.699999996}]

{"sheet":"31 Postes Fonctionnement","index":3,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Postes de fonctionnement en CP","CF 2017","CF 2018","CF 2019","CF 2020"]
["Exploitation technique / Sûreté Sécurité",29580548.059999999,28546080.960000001,28996399.710000005,26725667.800000001]
["Informatique",5366608.67,5636742.209999999,6295639.0900000008,6328952.1000000015]
["Collections (Acquisitions, conservation)",5373472.04,4904227.57,6137818.9300000006,4183117.6]
["Difusion culturelle",2832869.9500000007,2663840.85,2741647.91,2075818.4500000002]
["Communication",1385653.7199999997,1327217.7,1357993.1100000003,620643.11]
["Pôles associés",1977141.45,1856334.5199999998,1211429.4099999999,1276276.8900000001]
["Action internationale, études et recherche",823645.64999999991,1025060.49,589491.25,470278.97000000003]
["Charges financières et administratives",673233.73,748309.23,528205.04,1273124.94]
["Dépenses relatives au personnel",1354735.1300000001,1590761.43,1339766.1400000001,1496934.3900000001]
["Autres",368648.14,319448.39,185545.23,206044.81000000003]
[null,{"$f":"SUM(B4:B13)","v":49736556.539999999},{"$f":"SUM(C4:C13)","v":48618023.350000009},{"$f":"SUM(D4:D13)","v":49383935.819999993},{"$f":"SUM(E4:E13)","v":44656859.060000002}]

{"sheet":"32. Recettes par origines","index":4,"n_rows":17,"n_cols":16,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Détail des recettes par origines ",null,null,null,null,null,null,null,"Subventions Etat",{"$f":"+F6","v":208044349.18000001}]
[null,null,null,null,null,null,null,null,null,"Autres ressources",{"$f":"+F17-K2","v":14329194.680000007}]
[null,"Recettes en GBCP",null,"CF 2018","CF 2019","CF 2020"]
[]
[null,"Subventions d'Etat",null,202056902,203240487.75999999,208044349.18000001,null,null,null,null,null,null,null,"CF 2018","CF 2019","CF 2020"]
[null,"Autres subventions",null,6126118.4699999997,1259715.8799999999,851368.98,null,null,null,"Autres subventions",{"$f":"+F7","v":851368.98},null,"Subventions Etat",{"$f":"+D6/D17","v":0.8920728774774439},{"$f":"+E6/E17","v":0.91979476685094996},{"$f":"+F6/F17","v":0.9355625024844626}]
[null,"Mécénat et parrainage",null,2688580.7500000005,2983445.51,2719341.66,null,null,null,"Mécénat et parrainage",2719341.66,null,"Autres ressources",{"$f":"1-N7","v":0.1079271225225561},{"$f":"1-O7","v":8.0205233149050037E-2},{"$f":"1-P7","v":6.4437497515537401E-2}]
[null,"Billetterie (dont accès au salles de lecture et expositions)",null,1712806.7500000002,2138802.92,1340641.5,null,null,null,"Billetterie",1340641.5]
[null,"Coproduction, tournées et itinérances de spéctacles et d'exposition",null,55790.549999999996,47611,61914.27,null,null,null,"Itinérance expositions",61914.27]
[null,"Activités commerciales (dont éditions et mise à dispo. infrastructures informatiques)",null,738886.75000000023,1810528.64,1348252.02,null,null,null,"Activités commerciales",1348252.02]
[null,"Valorisation du domaine",null,6604052.9100000001,3794485.36,3469788.3800000008,null,null,null,"Valorisation du domaine",3469788.3800000008]
[null,"Valorisation des collections (dont reproduction et partenariats de numérisation)",null,1814072.3099999991,1320756.6800000002,993492.71,null,null,null,"Valorisation des collections ",993492.71]
[null,"Activités d'enseignement",null,62806.559999999998,88829.5,30353.949999999997,null,null,null,"Activités d'enseignement",30353.949999999997]
[null,"Recettes diverses",null,4642667.9899999984,4278202.6900000004,3514041.21,null,null,null,"Recettes diverses",3514041.21]
[]
[null,"Total recettes",null,{"$f":"SUM(D6:D15)","v":226502685.04000002},{"$f":"SUM(E6:E15)","v":220962865.93999997},{"$f":"SUM(F6:F15)","v":222373543.86000001}]

{"sheet":"33. Situation patrimoniale","index":5,"n_rows":49,"n_cols":13,"rows_kept":49,"cut":false,"hidden":false,"merged":[[15,0,15,4],[21,0,21,4],[41,0,41,4],[47,0,47,4],[37,0,37,4]]}
["Situation patrimoniale - Comptabilité générale"]
[]
[null,2017,2018,2019,2020]
["CHARGES D'EXPLOITATION",{"$f":"SUM(B5:B7)","v":246224263},{"$f":"SUM(C5:C7)","v":242108673},{"$f":"SUM(D5:D7)","v":240663194.72999999},241677741.99000001]
["Personnel",137768349.06999999,139386825,141067602.53999999,144511107.59]
["Autres charges de fonctionnement",52629602.930000007,49616553,48458249.379999995,44656043.039999992]
["Charges calculées",55826311,53105295,51137342.810000002,52510591.359999999]
[]
["RECETTES DE FONCTIONNEMENT",{"$f":"SUM(B10:B12)","v":247924281.36000001},{"$f":"SUM(C10:C12)","v":242117758.05000001},{"$f":"SUM(D10:D12)","v":244733267.44},{"$f":"SUM(E10:E12)","v":242319899.41999996}]
["Subvention pour charge de service public",183582589,178712862,181840385,185015050.11000001]
["Autres ressources",10529051.360000014,13313559.050000012,11894349.439999998,8950991.6999999601]
["Recettes calculées",53812641,50091337,50998533,48353857.609999999]
[]
["Résultat patrimonial",{"$f":"+B9-B4","v":1700018.3600000143},9085.0500000119209,{"$f":"+D9-D4","v":4070072.7100000083},{"$f":"+E9-E4","v":642157.42999994755}]
["CAF",{"$f":"+B10+B11-B5-B6","v":3713688.3600000143},3023043.0500000119,{"$f":"+D10+D11-D5-D6","v":4208882.5200000107},{"$f":"+E10+E11-E5-E6","v":4798891.1799999774}]
[]
["DEPENSES D'INVESTISSEMENT",37253844,32642010,39879308.340000004,49263107.780000001]
[]
["RECETTES D'INVESTISSEMENT",35468642,33728072,32748099.960000001,{"$f":"SUM(E20:E21)","v":38999617.270000003}]
["Dotation en fonds propres",24462933,23216740,21374240,34486575.270000003]
["Autres ressources",{"$f":"+B19-B20","v":11005709},10511332,7783840,4513042]
[]
["PRELEVEMENT SUR LE FONDS DE ROULEMENT",{"$f":"B19-B17+B15","v":1928486.3600000143},{"$f":"C19-C17+C15","v":4109105.0500000119},{"$f":"D19-D17+D15","v":-2922325.859999992},{"$f":"E19-E17+E15","v":-5464599.3300000206}]
[]
[]
["Situation patrimoniale - Comptabilité générale"]
[null,null,null,null,null,null,null,null,null,"CF 2017","CF2018","CF2019","CF2020"]
[null,2017,2018,2019,2020,null,null,null,"Résultat",{"$f":"+B41","v":1700018.3600000143},{"$f":"+C41","v":9085.0500000119209},{"$f":"+D41","v":4070072.7100000083},{"$f":"+E41","v":642157.42999997735}]
["CHARGES D'EXPLOITATION",{"$f":"SUM(B30:B31)","v":190397952},189003378,189525851.91999999,{"$f":"SUM(E30:E31)","v":189167150.63},null,null,null,"CAF",{"$f":"+B37","v":3713688.3600000143},{"$f":"+C37","v":3023043.0500000119},{"$f":"+D37","v":4208882.5200000107},{"$f":"+E37","v":4798891.1799999774}]
["Personnel",137768349.06999999,139386825,141067602.53999999,144511107.59]
["Autres charges de fonctionnement",52629602.930000007,49616553,{"$f":"99595592.19-D39","v":48458249.379999995},44656043.039999992]
[]
["RECETTES DE FONCTIONNEMENT",{"$f":"SUM(B34:B40)","v":307464280.72000003},242117758.05000001,244733267.44,244733267.44]
["Subvention pour charge de service public",183582589,178712862,181840385,185015050.11000001]
["Autres ressources",10529051.360000014,13313559.050000012,11894349.439999998,8950991.6999999601]
[]
["CAF",{"$f":"+B34+B35-B30-B31","v":3713688.3600000143},{"$f":"+C34+C35-C30-C31","v":3023043.0500000119},{"$f":"+D34+D35-D30-D31","v":4208882.5200000107},{"$f":"+E34+E35-E30-E31","v":4798891.1799999774}]
[]
["Charges calculées",{"$f":"55829311-3000","v":55826311},53105295,51137342.810000002,52510591.359999999]
["Recettes calculées",{"$f":"53815640-2999","v":53812641},50091337,50998533,48353857.609999999]
["Résultat patrimonial",{"$f":"+B37-B39+B40","v":1700018.3600000143},{"$f":"+C37-C39+C40","v":9085.0500000119209},4070072.7100000083,642157.42999997735]
[]
["DEPENSES D'INVESTISSEMENT",37253844,32642010,39879308.340000004,49263107.780000001]
[]
["RECETTES D'INVESTISSEMENT",35468642,33728072,32748099.960000001,{"$f":"SUM(E46:E47)","v":38999617.270000003}]
["Dotation en fonds propres",24462933,23216740,21374240,34486575.270000003]
["Autres ressources",{"$f":"+B45-B46","v":11005709},{"$f":"+C45-C46","v":10511332},7783840,4513042]
[]
["PRELEVEMENT SUR LE FONDS DE ROULEMENT",{"$f":"B45-B43+B37","v":1928486.3600000143},{"$f":"C45-C43+C37","v":4109105.0500000119},{"$f":"D45-D43+D37","v":-2922325.859999992},{"$f":"E45-E43+E37","v":-5464599.3300000206}]

{"sheet":"34. Exécution du budget","index":6,"n_rows":8,"n_cols":9,"rows_kept":8,"cut":false,"hidden":false,"merged":[[2,7,2,8],[4,7,4,8],[2,0,3,0],[2,5,2,6],[4,5,4,6],[2,3,2,4],[2,1,2,2]]}
["Tableau 34 : L’exécution du budget"]
[]
["Taux de consommation des crédits",2017,null,2018,null,2019,null,2020]
[null,"AE","CP","AE","CP","AE","CP","AE","CP"]
["Personnel ",{"$f":"138774891/139273730","v":0.99641828362032092},null,{"$f":"140250088/140508214","v":0.99816291167148419},null,0.98880805072812861,null,0.99880000000000002]
["Fonctionnement ",{"$f":"49755301/51798368","v":0.96055730945036721},{"$f":"49736557/52180619","v":0.95316149852496002},{"$f":"53801614/55587261","v":0.96787668671064764},{"$f":"50641612/54373144","v":0.93137178162807732},0.99287130835663451,0.99228088087194799,0.93169999999999997,0.90359999999999996]
["Total compte de résultat",{"$f":"188530192/191072098","v":0.9866966133380709},{"$f":"188511447/191454349","v":0.98462870122631685},{"$f":"194051702/196095475","v":0.98957766363553268},{"$f":"190891700/194881358","v":0.97952775965364525},0.98984597144665132,0.98970690291368413,0.98119999999999996,0.97450000000000003]
["Investissement",{"$f":"33460463/35045345","v":0.95477624774417258},{"$f":"34145838/38017509","v":0.89816084478338654},{"$f":"35643845/36754489","v":0.96978208566578084},{"$f":"32534781/36688605","v":0.8867816315174698},0.96796619914074333,0.96071495922196348,0.91110000000000002,0.97850000000000004]

{"sheet":"35. dépenses dirigeants","index":7,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Le suivi des dépenses dirigeants"]
[]
[null,2017,2018,2019,2020]
["1. Frais de réception et de représentation",10692,5941,3314,1683]
["2. Déplacements (missions et taxis)",20020,32664,18129,7496]
["3. Autre",3166,31571,213,0]
["3.1 Formations",3166,2047,213,0]
["3.2 Véhicule de direction",null,30524]