{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["tableau 28 CB BI 2019","tableau 29 CG BI 2019","tableau 30 destinations BI 2019","tableau 31 exécution BI 2019","tableau 32 CG CF2019","tableau 33 investissement","tableau 34 fonctionnement","tableau 35 recettes","tableau 36 dépenses dirigeants"],"not_rendered":{"charts":8,"images":1,"macros":0,"external_links":0,"defined_names":3,"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":"tableau 28 CB BI 2019","index":0,"n_rows":30,"n_cols":11,"rows_kept":30,"cut":false,"hidden":false,"merged":[[2,0,2,10],[3,0,5,0],[3,1,3,2],[3,3,3,4],[3,5,3,6],[3,7,3,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],[28,7,28,10],[4,9,4,10],[13,0,13,10],[14,0,15,0],[14,1,14,2],[14,3,14,4],[14,5,14,6],[14,7,14,10]]}
["Le budget 2019 en comptabilité budgétaire"]
[]
["DEPENSES"]
[null,"CF 2018",null,"BI 2019\nvoté le 29 novembre 2018",null,"BR 2019\nvoté le 28 novembre 2019",null,"CF 2019"]
[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",140250087.79999998,140250087.79999998,142040311.44,142040311.44,142517311.44,142517311.44,140922264.92000002,140922264.92000002,{"$f":"+H8/F8","v":0.98880805072812861},{"$f":"+I8/G8","v":0.98880805072812861}]
["Fonctionnement",53801614.439999983,50641611.630000003,49632996.866000004,50528220.866000004,48894280.106000006,49768101.726000004,48545727.859999992,49383935.82,{"$f":"+H9/F9","v":0.99287130835663451},0.99228088087194799]
["Investissement",35643844.669999994,32534781.439999983,52211884.629999995,51985598.579999998,37039562.529999994,35828364.489999995,35853044.559999987,34420845.729999989,0.96796619914074333,0.96071495922196348]
[]
["TOTAL DES DEPENSES - AE (A) CP (B)",{"$f":"SUM(B8:B11)","v":229695546.90999994},{"$f":"SUM(C8:C11)","v":223426480.86999995},243885192.93599999,244554130.88599998,228451154.07600001,228113777.65600002,225321037.33999997,224727046.47,{"$f":"+H12/F12","v":0.98629852955367991},{"$f":"+I12/G12","v":0.98515332471014849}]
[]
["RECETTES"]
[null,{"$f":"+B4","v":"CF 2018"},null,{"$f":"D4","v":"BI 2019\nvoté le 29 novembre 2018"},null,{"$f":"F4","v":"BR 2019\nvoté le 28 novembre 2019"},null,{"$f":"H4","v":"CF 2019"}]
[null,null,"Montants",null,"Montants",null,"Montants",null,"Montants",null,"Taux de réalisation"]
["Recettes globalisées",null,{"$f":"SUM(C18:C20)","v":213551261.86000001},null,{"$f":"SUM(E18:E20)","v":215746335},null,{"$f":"SUM(G18:G20)","v":213130049.09999999},null,{"$f":"SUM(I18:I20)","v":213208703.43999997},null,{"$f":"+I17/G17","v":1.0003690438787591}]
["Subvention pour charges de service public",null,178712862,null,181363385,null,181840385,null,181840385,null,{"$f":"+I18/G18","v":1}]
["Autres financements de l'Etat",null,22741740,null,22741740,null,20049240,null,20899240,null,1.0423956219786885]
["Recettes propres",null,12096659.860000016,null,11641210,null,11240424.1,null,10469078.43999997,null,0.93137753049726746]
[]
["Recettes fléchées*",null,{"$f":"SUM(C23:C25)","v":12951423.179999998},null,{"$f":"SUM(E23:E25)","v":16913766.259999998},null,{"$f":"SUM(G23:G25)","v":7592540.4000000004},null,{"$f":"SUM(I23:I25)","v":7754162.4899999993},null,{"$f":"+I22/G22","v":1.0212869581833242}]
["Financements de l'Etat fléchés",null,599711.63,null,791700,null,791700,null,656591.96,null,0.82934439813060501]
["Autres financements publics fléchés",null,5949147.8500000006,null,1329641.26,null,1083482.3999999999,null,841695.38,null,0.77684268798459488]
["Recettes propres fléchées",null,6402563.6999999974,null,14792425,null,5717358,null,6255875.1499999994,null,1.0941898600717324]
[]
["TOTAL DES RECETTES (C)",null,{"$f":"C17+C22","v":226502685.04000002},null,{"$f":"E17+E22","v":232660101.25999999},null,{"$f":"G17+G22","v":220722589.5},null,{"$f":"I17+I22","v":220962865.92999998},null,{"$f":"+I27/G27","v":1.0010885901191366}]
[]
["SOLDE BUDGETAIRE","BI 2018 après BR2",null,{"$f":"D15","v":"BI 2019\nvoté le 29 novembre 2018"},null,{"$f":"F4","v":"BR 2019\nvoté le 28 novembre 2019"},null,{"$f":"H4","v":"CF 2019"}]
["Abondement ou prélèvement sur la trésorerie",null,{"$f":"+C27-C12","v":3076204.1700000763},null,{"$f":"+E27-E12","v":-11894029.625999987},null,{"$f":"+G27-G12","v":-7391188.1560000181},null,{"$f":"+I27-I12","v":-3764180.5400000215}]

{"sheet":"tableau 29 CG BI 2019","index":1,"n_rows":24,"n_cols":2,"rows_kept":24,"cut":false,"hidden":false,"merged":[[16,0,16,1],[22,0,22,1]]}
["Le budget 2019 en comptabilité générale"]
[]
[]
[null,2019]
["CHARGES D'EXPLOITATION",{"$f":"SUM(B6:B8)","v":247241532.30599999}]
["Personnel",142040311.44]
["Autres charges de fonctionnement",49301220.865999997]
["Charges calculées",55900000]
[]
["RECETTES DE FONCTIONNEMENT",{"$f":"SUM(B11:B13)","v":247912666.58000001}]
["Subvention pour charge de service public",181363385]
["Autres ressources",13399281.580000013]
["Recettes calculées",53150000]
[]
["Résultat patrimonial",{"$f":"+B10-B5","v":671134.27400001884}]
["CAF",{"$f":"+B11+B12-B6-B7","v":3421134.2740000188}]
[]
["DEPENSES D'INVESTISSEMENT",51985598.579999998]
[]
["RECETTES D'INVESTISSEMENT",{"$f":"SUM(B21:B22)","v":37897434.68}]
["Dotation en fonds propres",23216740]
["Autres ressources",14680694.68]
[]
["PRELEVEMENT SUR LE FONDS DE ROULEMENT",{"$f":"B20-B18+B16","v":-10667029.62599998}]

{"sheet":"tableau 30 destinations BI 2019","index":2,"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 2019 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",991803.09203347471,null,195730.1,344295.09,null,204308.08,416543.33,null,{"$f":"+C5+E5+H5","v":1391841.2720334749},{"$f":"+C5+F5+I5","v":1752641.5120334749},null,null,"CP",null,null,null,null,"CP"]
[null,"Richelieu et annexes",167899.26595168037,null,291920.99,378395.76,null,149580.03,50421.68,null,{"$f":"+C6+E6+H6","v":609400.28595168039},{"$f":"+C6+F6+I6","v":596716.70595168043},null,null,"Personnel",{"$f":"+C57","v":140922264.92000002},null,null,null,"Patrimoine immobilier",{"$f":"+L14","v":16757845.01983754}]
[null,"François Mitterrand",558977.29036424728,null,78040.740000000005,96319.640000000014,null,5820902.1500000013,4283000.1400000006,null,6457920.1803642483,4938297.070364248,null,null,"Fonctionnement",{"$f":"+F57","v":49383935.82},null,null,null,"Patrimoine collections",{"$f":"+L24","v":85194321.404593527}]
[null,"Bussy",51277.389303889664,null,0,0,null,0,86458.49,null,51277.389303889664,137735.87930388967,null,null,"Investissement",{"$f":"+I57","v":34420845.730000004},null,null,null,"Diffusion valorisation",{"$f":"+L41","v":58301919.288046829}]
[null,"Arsenal",47762.858140176213,null,0,0,null,193083.45,185043.68,null,240846.30814017623,232806.53814017621,null,null,null,null,null,null,null,"Fonctions support",{"$f":"+L55","v":64472960.757522136}]
[null,"Bibliothèque musée de l'Opéra",30685.713253161528,null,0,0,null,0,0,null,30685.713253161528,30685.713253161528]
[null,"Sablé",12256.902458101276,null,47436.51,30592.3,null,827.18000000000006,118090.2,null,60520.59245810128,160939.40245810128]
[null,"Boulevard St Michel",7069.0228864230685,null,13079.86,13403.4,null,28340.82,76103.95,null,48489.702886423067,96576.372886423065]
[null,"Multisites",77451.555446383223,null,6105868.1100000003,6424379.1700000018,null,2765510.74,2309615.1,null,8948830.4054463841,8811445.8254463859]
["Total Patrimoine immobilier",null,{"$f":"SUM(C5:C13)","v":1945183.0898375376},null,{"$f":"SUM(E5:E13)","v":6732076.3100000005},7287385.3600000022,null,9162552.450000003,7525276.5700000003,null,17839811.849837538,16757845.01983754]
["Patrimoine collections","Dépôt légal ",5431521.0979058258,null,301983.42,286183.42,null,1364644.74,1182469.82,null,{"$f":"+C15+E15+H15","v":7098149.257905826},{"$f":"+C15+F15+I15","v":6900174.337905826}]
[null,"Pôles associés",1014953.2428739327,null,1245425.1599999999,1211429.4099999999,null,116961.65,80315.600000000006,null,2377340.0528739323,2306698.2528739325]
[null,"Acquisitions",8721070.3184149172,null,2665248.85,2675393.9099999997,null,6546886.2300000014,6259136.1800000006,null,17933205.398414917,17655600.408414919]
[null,"Constitution des collections numériques",5781002.160690709,null,447524.67,522040.01,null,2816956.33,2580085.8299999996,null,9045483.1606907099,8883128.0006907079]
[null,"Restauration/conservation",15633081.175444197,null,2039362.6300000001,2617720.4300000002,null,659407.75,724172.48,null,18331851.555444196,18974974.085444197]
[null,"Sûreté des collections",2468208.8820275185,null,63865,63865,null,0,0,null,2532073.8820275185,2532073.8820275185]
[null,"Stockage des collections physiques",2073204.7504341942,null,368533.58999999997,562733.28,null,642485.53,372827.68999999994,null,3084223.8704341939,3008765.720434194]
[null,"Catalogage hors informatique",19849430.645681661,null,21246.5,21246.5,null,202275.96,174467.11,null,20072953.105681662,20045144.25568166]
[null,"SIBIB/SINUM pour conservation",1998908.081120559,null,320959.33,238606.27,null,2307169.6800000002,2650248.11,null,4627037.0911205597,4887762.4611205589]
["Total Patrimoine collections",null,{"$f":"SUM(C15:C23)","v":62971380.354593523},null,{"$f":"SUM(E15:E23)","v":7474149.1499999994},8199218.2299999995,null,14656787.870000001,14023722.819999998,null,85102317.374593511,85194321.404593527]
["Diffusion et valorisation","Accueil",3054808.9087978709,null,348258.27,295117.78999999998,null,90910.94,113657.58,null,{"$f":"+C25+E25+H25","v":3493978.1187978708},{"$f":"+C25+F25+I25","v":3463584.278797871}]
[null,"Mise à disposition des collections physiques",10261942.480209539,null,1218881.8,1238990.0899999999,null,409333.56,578555.78,null,11890157.84020954,12079488.350209538]
[null,"Exception handicap",267415.06178841728,null,0,0,null,134525.75,107536.55,null,401940.81178841728,374951.61178841727]
[null,"Education artistique et cultutelle",null,null,1829,null,null,null,null,null,{"$f":"+C28+E28+H28","v":1829},{"$f":"+C28+F28+I28","v":0}]
[null,"Services à distance",5614585.4137371713,null,421518.75000000006,384855.26000000007,null,2083977.12,2179343.4700000002,null,8120081.2837371714,8178784.1437371708]
[null,"Reproduction",4452984.9114590799,null,85868.28,109222.48,null,166662.88,166662.88,null,4705516.0714590801,4728870.2714590803]
[null,"Éditions et produits dérivés",1951766.6096727732,null,853015.31,825486.37,null,766596.03999999992,427815.6,null,3571377.9596727733,3205068.5796727734]
[null,"Expositions",3223989.9274199698,null,1784747.6800000002,1647396.94,null,381106.58,256314.64,null,5389844.1874199696,5127701.507419969]
[null,"Manifestations",1929047.033855499,null,330548.84999999998,298829.26,null,73262.06,73262.06,null,2332857.9438554989,2301138.3538554991]
[null,"Actions pédagogiques et éducatives",1036068.402247511,null,22359.98,38959.81,null,0,0,null,1058428.3822475111,1075028.2122475109]
[null,"Formation professionnelle",667565.11436647386,null,11450.22,11797.92,null,0,0,null,679015.33436647383,679363.0343664739]
[null,"Recherche scientifique",2083646.4444998943,null,167596.43,148634.34,null,12976.579999999998,11277.4,null,2264219.4544998943,2243558.1844998943]
[null,"Activités internationales",986874.95609527151,null,126137.01000000001,79262.23000000001,null,34709,0,null,1147720.9660952715,1066137.1860952715]
[null,"SIBIB/SINUM pour communication",2218669.1772920648,null,205842.07,175121.52,null,1642744.99,1723086.03,null,4067256.2372920644,4116876.7272920646]
[null,"Service public sur place",8863368.8466052953,null,0,0,null,0,0,null,8863368.8466052953,8863368.8466052953]
[null,"Participation à la filiale",null,null,0,0,null,798000,798000,null,798000,798000]
["Total Diffusion et valorisation",null,{"$f":"SUM(C25:C40)","v":46612733.288046829},null,{"$f":"SUM(E25:E40)","v":5578053.6499999994},{"$f":"SUM(F25:F40)","v":5253674.0099999988},null,{"$f":"SUM(H25:H40)","v":6594805.5},{"$f":"SUM(I25:I40)","v":6435511.9900000002},null,{"$f":"SUM(K25:K40)","v":58785592.43804682},{"$f":"SUM(L25:L40)","v":58301919.288046829}]
["Fonctions support","Sécurité et sûreté",2272165.3766342169,null,8747823.5399999991,8762608.6699999999,null,5045.58,89952.8,null,{"$f":"+C42+E42+H42","v":11025034.496634217},{"$f":"+C42+F42+I42","v":11124726.846634217}]
[null,"Logistique / exploitation",4879891.555327001,null,12315445.27,12280738.399999997,null,84760.19,424567.3,null,17280097.015327003,17585197.255326997]
[null,"Locations immobilières et charges",340727.70233677188,null,154238.57,32406.81,null,0,0,null,494966.27233677189,373134.51233677188]
[null,"Pilotage stratégie",3930174.9240282951,null,324450.33999999997,349209.85,null,355584.76,260483.63,null,4610210.0240282947,4539868.4040282946]
[null,"Frais de mission",106645.74083501256,null,169654.44999999995,169087.28,null,0,0,null,276300.19083501253,275733.02083501255]
[null,"Communication",1675646.1401070396,null,828576.64000000013,873552.63000000024,null,278925.96999999997,181513.37,null,2783148.7501070397,2730712.1401070398]
[null,"Dépenses relatives au personnel",5284584.9345000004,null,964718.44000000006,880352.65,null,1021112.18,961724.71000000008,null,7270415.5545000006,7126662.2945000008]
[null,"Informatique transverse",null,null,4323179.42,4487181.28,null,1787372.86,1467034.0000000002,null,6110552.2800000003,5954215.2800000003]
[null,"Informatique bureautique",1843556.4129530606,null,95727.83,18904.419999999998,null,1487154.8299999998,2773005.86,null,3426439.0729530603,4635466.6929530604]
[null,"Documentation",75494.487069545634,null,203207.54000000004,199402.57,null,0,0,null,278702.0270695457,274897.05706954561]
[null,"Charges financières",null,null,208681.27,203135.63,null,1050,1050,null,209731.27,204185.63]
[null,"Gestion administrative",8984080.9137311913,null,331330.11000000004,292662.60000000003,null,417892.37,277002.68,null,9733303.3937311899,9553746.1937311906]
[null,"Personnel",null,null,94415.43,94415.43,null,0,0,null,94415.43,94415.43]
["Total Fonctions support",null,{"$f":"SUM(C42:C54)","v":29392968.187522136},null,{"$f":"SUM(E42:E54)","v":28761448.849999998},{"$f":"SUM(F42:F54)","v":28643658.219999999},null,5438898.7400000002,6436334.3499999996,null,63593315.777522147,64472960.757522136]
[]
["Total charges décaissables",null,{"$f":"C14+C24+C41+C55","v":140922264.92000002},null,{"$f":"E14+E24+E41+E55","v":48545727.959999993},{"$f":"F14+F24+F41+F55","v":49383935.82},null,{"$f":"H14+H24+H41+H55","v":35853044.560000002},{"$f":"I14+I24+I41+I55","v":34420845.730000004},null,{"$f":"K14+K24+K41+K55","v":225321037.44000003},{"$f":"L14+L24+L41+L55","v":224727046.47000003}]

{"sheet":"tableau 31 exécution BI 2019","index":3,"n_rows":8,"n_cols":9,"rows_kept":8,"cut":false,"hidden":false,"merged":[[4,1,4,2],[4,3,4,4],[4,5,4,6],[4,7,4,8],[2,0,3,0],[2,1,2,2],[2,3,2,4],[2,5,2,6],[2,7,2,8]]}
["L’exécution du budget 2019"]
[]
["Taux de consommation des crédits",2016,null,2017,null,2018,null,2019]
[null,"AE","CP","AE","CP","AE","CP","AE","CP"]
["Personnel ",{"$f":"134716539/136052591","v":0.99017988565906845},null,{"$f":"138774891/139273730","v":0.99641828362032092},null,{"$f":"140250088/140508214","v":0.99816291167148419},null,0.98880805072812861]
["Fonctionnement ",{"$f":"50303118/52631436","v":0.95576183784915159},{"$f":"47752993/50128917","v":0.95260372371499669},{"$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]
["Total compte de résultat",{"$f":"185019657/188684027","v":0.980579331179952},{"$f":"182469532/186181508","v":0.98006259569022292},{"$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]
["Investissement",{"$f":"38144975/38977667","v":0.97863668956892669},{"$f":"36050664/45362599","v":0.7947221895288672},{"$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]

{"sheet":"tableau 32 CG CF2019","index":4,"n_rows":51,"n_cols":5,"rows_kept":51,"cut":false,"hidden":false,"merged":[[15,0,15,4],[21,0,21,4]]}
["Le compte financier 2019 en comptabilité générale"]
[]
[null,"2016",2017,2018,2019]
["CHARGES D'EXPLOITATION",{"$f":"SUM(B5:B7)","v":231376454},{"$f":"SUM(C5:C7)","v":246224263},{"$f":"SUM(D5:D7)","v":242108673},240663194.72999999]
["Personnel",134317363,137768349.06999999,139386825,141067602.53999999]
["Autres charges de fonctionnement",47383860,52629602.930000007,49616553,48458249.379999995]
["Charges calculées",49675231,55826311,53105295,51137342.810000002]
[]
["RECETTES DE FONCTIONNEMENT",{"$f":"SUM(B10:B12)","v":234266444.29999998},{"$f":"SUM(C10:C12)","v":247924281.36000001},242117758.05000001,244733267.44]
["Subvention pour charge de service public",176446229,183582589,178712862,181840385]
["Autres ressources",11108085.299999982,10529051.360000014,13313559.050000012,11894349.439999998]
["Recettes calculées",46712130,53812641,50091337,50998533]
[]
["Résultat patrimonial",{"$f":"+B9-B4","v":2889990.2999999821},1700018.3600000143,{"$f":"+D9-D4","v":9085.0500000119209},{"$f":"+E9-E4","v":4070072.7100000083}]
["CAF",{"$f":"+B10+B11-B5-B6","v":5853091.2999999821},3713688.3600000143,{"$f":"+D10+D11-D5-D6","v":3023043.0500000119},{"$f":"+E10+E11-E5-E6","v":4208882.5200000107}]
[]
["DEPENSES D'INVESTISSEMENT",39811138,37253844,32642010,39879308.340000004]
[]
["RECETTES D'INVESTISSEMENT",33990752,35468642,33728072,32748099.960000001]
["Dotation en fonds propres",21560000,24462933,23216740,21374240]
["Autres ressources",{"$f":"+B19-B20","v":12430752},{"$f":"+C19-C20","v":11005709},10511332,7783840]
[]
["PRELEVEMENT SUR LE FONDS DE ROULEMENT",{"$f":"B19-B17+B15","v":32705.299999982119},{"$f":"C19-C17+C15","v":1928486.3600000143},{"$f":"D19-D17+D15","v":4109105.0500000119},{"$f":"E19-E17+E15","v":-2922325.859999992}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"CF 2016","CF 2017","CF2018","CF2019"]
["Résultat",2889990.2999999821,1700018.3600000143,9085.0500000119209,4070072.7100000083]
["CAF",5853091.2999999821,3713688.3600000143,3023043.0500000119,4208882.5200000107]

{"sheet":"tableau 33 investissement","index":5,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Le compte financier 2019 : principaux postes en investissement"]
[]
["Postes d'investissement en CP","CF 2016","CF 2017","CF 2018","CF 2019"]
["Travaux",8121695.4600000009,7505524.160000002,10617413.529999997,8496352.209999999]
["Informatique",11052918.519999996,8012280.21,7963431.5199999996,13371738.68]
["Acquisitions",9179016.8900000025,7171136.0700000022,7480792.9100000011,6259136.1799999997]
["Numérisation des collections",5885884.7800000012,6939769.3000000007,3202189.55,2437310.2999999998]
["Autres",1811148.35,4517128.5199999996,3270953.9300000006,3856308.36]
[null,{"$f":"SUM(B4:B8)","v":36050664},{"$f":"SUM(C4:C8)","v":34145838.260000005},{"$f":"SUM(D4:D8)","v":32534781.439999998},{"$f":"SUM(E4:E8)","v":34420845.730000004}]

{"sheet":"tableau 34 fonctionnement","index":6,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Le compte financier 2019 : principaux postes en fonctionnement"]
[]
[]
["Postes de fonctionnement en CP","CF 2016","CF 2017","CF 2018","CF 2019"]
["Exploitation technique / Sûreté Sécurité",26592247.989999995,29580548.059999999,28546080.960000001,28996399.710000005]
["Informatique",6376458.0400000019,5366608.67,5636742.209999999,6295639.0900000008]
["Collections (Acquisitions, conservation)",5736506.4100000001,5373472.04,4904227.57,6137818.9300000006]
["Difusion culturelle",2986578.5,2832869.9500000007,2663840.85,2741647.91]
["Communication",993012.32999999984,1385653.7199999997,1327217.7,1357993.1100000003]
["Pôles associés",1670436.5399999998,1977141.45,1856334.5199999998,1211429.4099999999]
["Action internationale, études et recherche",769147.78,823645.64999999991,1025060.49,589491.25]
["Charges financières et administratives",818225.08000000007,673233.73,748309.23,528205.04]
["Dépenses relatives au personnel",1641538.6099999989,1354735.1300000001,1590761.43,1339766.1400000001]
["Autres",168841.38999999998,368648.14,319448.39,185545.23]
[null,{"$f":"SUM(B5:B14)","v":47752992.669999994},{"$f":"SUM(C5:C14)","v":49736556.539999999},{"$f":"SUM(D5:D14)","v":48618023.350000009},{"$f":"SUM(E5:E14)","v":49383935.819999993}]

{"sheet":"tableau 35 recettes","index":7,"n_rows":18,"n_cols":16,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,"Le compte financier 2019  : recettes"]
[]
[null,"Détail des recettes par origines ",null,null,null,null,null,null,null,"Subventions Etat",{"$f":"+F7","v":203240487.75999999}]
[null,null,null,null,null,null,null,null,null,"Autres ressources",{"$f":"+F18-K3","v":17722378.179999977}]
[null,"Recettes en GBCP",null,"CF 2017","CF 2018","CF 2019"]
[]
[null,"Subventions d'Etat",null,205233422,202056902,203240487.75999999,null,null,null,null,null,null,null,"CF 2017","CF 2018","CF 20019"]
[null,"Autres subventions",null,6829378.5099999998,6126118.4699999997,1259715.8799999999,null,null,null,"Autres subventions",{"$f":"+F8","v":1259715.8799999999},null,"Subventions Etat",{"$f":"+D7/D18","v":0.89700115230545197},{"$f":"+E7/E18","v":0.8920728774774439},{"$f":"+F7/F18","v":0.91979476685094996}]
[null,"Mécénat et parrainage",null,2010044.66,2688580.7500000005,2983445.51,null,null,null,"Mécénat et parrainage",2983445.51,null,"Autres ressources",{"$f":"1-N8","v":0.10299884769454803},{"$f":"1-O8","v":0.1079271225225561},{"$f":"1-P8","v":8.0205233149050037E-2}]
[null,"Billetterie (dont accès au salles de lecture et expositions)",null,1569950.7000000002,1712806.7500000002,2138802.92,null,null,null,"Billetterie",2138802.92]
[null,"Coproduction, tournées et itinérances de spéctacles et d'exposition",null,55868.07,55790.549999999996,47611,null,null,null,"Itinérance expositions",47611]
[null,"Activités commerciales (dont éditions et mise à dispo. infrastructures informatiques)",null,769721.03999999992,738886.75000000023,1810528.64,null,null,null,"Activités commerciales",1810528.64]
[null,"Valorisation du domaine",null,4922067.2300000004,6604052.9100000001,3794485.36,null,null,null,"Valorisation du domaine",3794485.36]
[null,"Valorisation des collections (dont reproduction et partenariats de numérisation)",null,2004793.6999999997,1814072.3099999991,1320756.6800000002,null,null,null,"Valorisation des collections ",1320756.6800000002]
[null,"Activités d'enseignement",null,121533.85,62806.559999999998,88829.5,null,null,null,"Activités d'enseignement",88829.5]
[null,"Recettes diverses",null,{"$f":"5281858.88+869","v":5282727.88},4642667.9899999984,4278202.6900000004,null,null,null,"Recettes diverses",4278202.6900000004]
[]
[null,"Total recettes",null,{"$f":"SUM(D7:D16)","v":228799507.63999993},{"$f":"SUM(E7:E16)","v":226502685.04000002},{"$f":"SUM(F7:F16)","v":220962865.93999997}]

{"sheet":"tableau 36 dépenses dirigeants","index":8,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Le suivi des dépenses dirigeants"]
[]
[null,2017,2018,2019]
["1. Frais de réception et de représentation","10 692","5 941","3 314"]
["2. Déplacements (missions et taxis)","20 020","32 664","18 129"]
["3. Autre","3 166","31 571",213]
["3.1 Formations","3 166","2 047",213]
["3.2 Véhicule de direction",null,30524]