{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Compte de résultat","Bilan"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"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":"Compte de résultat","index":0,"n_rows":37,"n_cols":10,"rows_kept":37,"cut":false,"hidden":false,"merged":[[1,0,1,4],[1,5,1,9],[0,0,0,9],[19,4,20,4]]}
["Compte de résultat 2018"]
["Charges (Dépenses)",null,null,null,null,"Produits (Recettes)"]
[null,2016,2017,2018,"Prév 2019",null,2016,2017,2018,"Prév 2019"]
["Achat marchandises",{"$f":"245+15+824.22","v":1084.22},371,5168,2000,"Ventes (œuvres, livres, cartes...)",1172.5,586,5583,3000]
["Vataion de stock",null,null,null,null,"Adhésions",3373,2404,3598,4204]
["Eau électricité",{"$f":"120.6+275.4","v":396},{"$f":"417+478","v":895},771,null,"Locations oeuvres",9193,7937,7945,8000]
["Founitures entretien et petit équipement",{"$f":"664.93+74","v":738.93},{"$f":"493","v":493},{"$f":"1399+439","v":1838},1800,"Autres activités (dont médiations)",{"$f":"1196+215+1853+675+2469+3137.6+1802","v":11347.6},7340,{"$f":"31515-I6-I5","v":19972},9000]
["Fournitures administratives",1209.77,969,490,null,"Total chiffre d'affaires",{"$f":"SUM(G4:G7)","v":25086.1},{"$f":"SUM(H4:H7)","v":18267},{"$f":"SUM(I4:I7)","v":37098},{"$f":"SUM(J4:J7)","v":24204}]
["Achats Animations",{"$f":"39.95+4365.3+900+500+200+3063.36","v":9068.61},5445,{"$f":"64.76+2662+481.32+2843.38+2523.88","v":8575.34}]
["Com. sur location artothèque",5624.65,5533,5886,14100,"Production immobilisée"]
["Autres prestations de service",null,null,597,null,"Subventions :"]
["Location matériel",540,90,274,null,"Conseil régional",6000,6000,6000,6000]
["Convention d'occupation des locaux",2400,2400,2400,2400,"Conseil général 64",14400,14400,17466,16566]
["Entretien Biens immobiliers mobiliers",null,786,1793,200,"Communauté de commune de Nay",8000,8000,10000,10000]
["Assurance",675.33,1197,685,700,"Commune de Nay",1000,1000,1250,1000]
["Documentation",2.2000000000000002,null,null,70,"Autres subventions"]
["Commission/ventes",null,null,null,null,"Total subventions",{"$f":"SUM(G12:G16)","v":29400},{"$f":"SUM(H12:H16)","v":29400},{"$f":"SUM(I12:I16)","v":34716},{"$f":"SUM(J12:J16)","v":33566}]
["Honoraires expert comptable",2544,2596,2900,2900]
["Publicité communication",{"$f":"1600+3753.65+719.05","v":6072.7},{"$f":"1400+2703+769+61","v":4933},6299,8000,"Aide à l'emploi",6964.33]
["Frais transport artistes et œuvres",{"$f":"1409+177.4","v":1586.4},{"$f":"900+388","v":1288},{"$f":"1240+382","v":1622},4100]
["Frais de déplacement, réception",{"$f":"941.14+456.2+1087.99","v":2485.33},{"$f":"1198+761","v":1959},{"$f":"984+410+4948.38+673","v":7015.38},null,"Dons divers",300,3905,6650,4000]
["Frais télécommunication et postaux",{"$f":"27.59+154.44+2770.19","v":2952.2200000000003},1513,1760,null,"Total aides et dons",{"$f":"SUM(G19:G21)","v":7264.33},{"$f":"SUM(H19:H21)","v":3905},{"$f":"SUM(I19:I21)","v":6650},{"$f":"SUM(J19:J21)","v":4000}]
["Services bancaires",166.11,156,216,200]
["Total achats et charges externes",{"$f":"SUM(B4:B23)","v":37546.470000000008},30624,{"$f":"SUM(D4:D23)","v":48289.719999999994},{"$f":"SUM(E4:E23)","v":36470},"Autres produits",null,null,900]
["Impôts et taxes (dont form prof)",340,{"$f":"348+132+259","v":739},372,400]
["Salaires et cotisations sociales",{"$f":"22222.69","v":22222.69},{"$f":"18909+2986","v":21895},{"$f":"20070+3961","v":24031},25800]
["Amortissements",1091.25,1117,1956,1500,"Total produit divers",{"$f":"SUM(G24:G26)","v":0},{"$f":"SUM(H24:H26)","v":0},900,0]
["Total impôts, salaires et amort.",{"$f":"SUM(B25:B27)","v":23653.94},23751,{"$f":"SUM(D25:D27)","v":26359},{"$f":"SUM(E25:E27)","v":27700}]
[null,null,null,null,null,"Total  produits d'exploitation",{"$f":"G22+G17+G10+G8+G27","v":61750.43},51572,{"$f":"I22+I17+I10+I8+I27","v":79364},{"$f":"J22+J17+J10+J8+J27","v":61770}]
["Total charges d'exploitation",{"$f":"B24+B28","v":61200.41},54375,{"$f":"D24+D28","v":74648.72},{"$f":"E28+E24","v":64170}]
["Charges financières",null,null,null,null,"Produits financiers (livret A)",29.76,79,46,50]
[]
["Charges exceptionnelles",{"$f":"0.06+170","v":170.06},81,null,null,"Produits exceptionnels",{"$f":"1.6+30","v":31.6},515,154]
["Engagements à réaliser sur dons",null,3905,1576,null,"Reprise des fonds dédiés",null,null,3905]
["Total charges",{"$f":"B30+B31+B32+B33+B34","v":61370.47},{"$f":"C30+C31+C32+C33+C34","v":58361},{"$f":"D30+D31+D32+D33+D34","v":76224.72},{"$f":"E30+E31+E32+E33+E34","v":64170},"Total Produits",{"$f":"G29+G30+G31+G32+G33+G34","v":61811.79},52166,{"$f":"I29+I30+I31+I32+I33+I34","v":83469},{"$f":"J29+J30+J31+J32+J33+J34","v":61820}]
[]
["Bénéfice ou perte",{"$f":"G35-B35","v":441.31999999999971},{"$f":"H35-C35","v":-6195},{"$f":"I35-D35","v":7244.2799999999988},{"$f":"J35-E35","v":-2350}]

{"sheet":"Bilan","index":1,"n_rows":31,"n_cols":21,"rows_kept":31,"cut":false,"hidden":false,"merged":[[4,5,4,7],[4,8,4,10],[4,11,4,13],[4,2,4,4],[3,1,3,17]]}
[]
[]
[]
[null,"Bilan 2018"]
[null,null,2016,null,null,2017,null,null,2018,null,null,2013,null,null,null,2016,2017,2018,2013]
[null,null,"Brut","Amort","Net","Brut","Amort","Net","Brut","Amort","Net","Brut","Amort","Net"]
[null,"Logiciels",109,109,0,109,109,{"$f":"F7-G7","v":0},109,109,{"$f":"I7-J7","v":0},109,109,0,"Fonds associatifs",3002.41,3002,3002,3002]
[null,"Investissement de création",{"$f":"5745.3+135","v":5880.3},null,{"$f":"C8-D8","v":5880.3},{"$f":"5745+135","v":5880},null,5880,5880,null,{"$f":"I8-J8","v":5880}]
[null,"Site internet",null,null,{"$f":"C9-D9","v":0},1820,null,{"$f":"F9-G9","v":1820},1820,603,1217,4658,null,{"$f":"L9-M9","v":4658},"Autres réserves",13029.65,13030,13030,13030]
[null,"Total immobilisations incorporelles",{"$f":"SUM(C7:C9)","v":5989.3},109,5880.3,{"$f":"SUM(F7:F9)","v":7809},109,7700,{"$f":"SUM(I7:I9)","v":7809},{"$f":"SUM(J7:J9)","v":712},7097,4767,109,4658]
[null,"Aménagements divers",6674.79,2491.2399999999998,{"$f":"C11-D11","v":4183.55},6675,3408,{"$f":"F11-G11","v":3267},11917,4627,{"$f":"I11-J11","v":7290},4265,209,4056,"Report à nouveau créditeur",10797.22,11238,5045,6478]
[null,"Matériel de bureau et info",927.92,927.92,{"$f":"C12-D12","v":0},928,928,{"$f":"F12-G12","v":0},928,928,{"$f":"I12-J12","v":0},928,517,411,"Résultat de l'exercice",441,-6193,7243,1500]
[null,"Mobilier",1138.2,706.43,431.7700000000001,1138,906,232,1781,1040,741,1138,106,1032,"Total Fonds propres",{"$f":"SUM(P7:P12)","v":27270.28},{"$f":"SUM(Q7:Q12)","v":21077},{"$f":"SUM(R7:R12)","v":28320}]
[null,"Total immobilisations corporelles",{"$f":"SUM(C11:C13)","v":8740.91},4125.59,4615.3200000000006,{"$f":"SUM(F11:F13)","v":8741},5242,3499,{"$f":"SUM(I11:I13)","v":14626},{"$f":"SUM(J11:J13)","v":6595},8031,6331,832,5499,"Fonds sur dons manuels",1500,5405,3076,633]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S7:S14)","v":24643}]
[null,"Stocks et encours",null,null,200,null,null,200,null,null,200,null,null,200,"Total fonds dédiés",{"$f":"P14+P15","v":1500},{"$f":"Q14+Q15","v":5405},3076]
[null,"Total stocks",null,null,{"$f":"E16","v":200},null,null,{"$f":"H16","v":200},null,null,{"$f":"K16","v":200},null,null,{"$f":"N16","v":200},"Dettes fournisseurs",1944,3840,2802,3640]
[null,"Subvention à recevoir région",null,null,1800,null,null,1800,null,null,1800,null,null,1800]
[null,"Subvention à recevoir département",null,null,null,null,null,null,null,null,4320,null,null,6000,"Dettes fiscales et sociales",6448,6436,4795,5797]
[null,"Subvention à recevoir Com Com Nay",null,null,1600,null,null,1600,null,null,2000]
[null,"Produits à recevoir ( dont part. Kdo artistes)",null,null,4990.2,null,null,{"$f":"2605+79","v":2684},null,null,2780,null,null,2628]
[null,"Total créances",null,null,{"$f":"SUM(E18:E21)","v":8390.2000000000007},null,null,{"$f":"SUM(H18:H21)","v":6084},null,null,{"$f":"SUM(K18:K21)","v":10900},null,null,{"$f":"SUM(N18:N21)","v":10428},"Autres dettes",1622,1960,428,346]
[]
[null,"Banque CIC",null,null,9031.33,null,null,9742,null,null,10316,null,null,3861,"Produits constatés d'avance",680,372,2264,420]
[null,"Livret A",null,null,10576.54,null,null,10577,null,null,4201,null,null,8588,"Adhésions payées d'avance",380,114,489,324]
[null,"Caisse",null,null,465.23,null,null,716,null,null,736,null,null,26]
[null,"Total disponibilités",null,null,{"$f":"SUM(E24:E26)","v":20073.100000000002},null,null,{"$f":"SUM(H24:H26)","v":21035},null,null,15253,null,null,{"$f":"SUM(N24:N26)","v":12475},"Total dettes et PCA",{"$f":"SUM(P17:P26)","v":11074},{"$f":"SUM(Q17:Q26)","v":12722},{"$f":"SUM(R17:R26)","v":10778},{"$f":"SUM(S17:S26)","v":10527}]
[null,"charges constatées d'avance",null,null,685,null,null,686,null,null,693,null,null,1910]
[null,"Total Charges constatées d'avance",null,null,{"$f":"E28","v":685},null,null,{"$f":"H28","v":686},null,null,{"$f":"K28","v":693},null,null,{"$f":"N28","v":1910}]
[]
[null,"TOTAL ACTIF",{"$f":"C10+C14+C17+C22+C27+C29","v":14730.21},4234.59,39843.919999999998,{"$f":"F10+F14+F17+F22+F27+F29","v":16550},5351,39204,{"$f":"I10+I14+I17+I22+I27+I29","v":22435},7307,42174,11098,941,35170,"TOTAL PASSIF",{"$f":"P13+P16+P27","v":39844.28},{"$f":"Q13+Q16+Q27","v":39204},{"$f":"R13+R16+R27","v":42174},{"$f":"S27+S15","v":35170},null,{"$f":"H31-Q31","v":0}]