{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Synthèse","Subventions 2017","Subs 2016 sans demande 2017","Subs 2016 avec demandes 2017","Nouvelles demandes","Feuil2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Synthèse","index":0,"n_rows":26,"n_cols":10,"rows_kept":26,"cut":false,"hidden":false,"merged":[[25,0,26,9],[0,0,2,9],[11,4,11,5],[12,2,12,7],[16,0,17,0],[16,1,17,1],[18,0,19,0],[18,1,19,1],[19,3,19,4],[20,4,20,5],[24,0,24,9],[4,0,6,6],[4,7,6,9],[19,6,19,7],[13,2,13,7]]}
["Commission Sport - Vie Associative"]
[]
[]
[]
["SYNTHÈSE SUBVENTIONS AUX ASSOCIATIONS",null,null,null,null,null,null,2017]
[]
[]
[]
["Associations locales","Associations extérieures","Sub 2013","Sub 2014","Sub 2015","Sub 2016","Demande 2017","Solde de banque ass. locales","Solde de banque ass. extérieures1","Proposition 2017"]
[{"$f":"COUNTA('Subventions 2017'!C2:C60)","v":52},{"$f":"COUNTA('Subventions 2017'!D2:D60)","v":7},{"$f":"SUM('Subventions 2017'!E61)","v":86362},{"$f":"SUM('Subventions 2017'!F61)","v":103430},{"$f":"SUM('Subventions 2017'!G61)","v":94550},{"$f":"SUM('Subventions 2017'!H61)","v":105056.5},{"$f":"SUM('Subventions 2017'!I61)","v":45720},{"$f":"SUM('Subventions 2017'!J61)","v":195047.20999999996},{"$f":"SUM('Subventions 2017'!K61)","v":34363.81},{"$f":"SUM('Subventions 2017'!L61)","v":0}]
[]
[]
[null,null,"VARIATION PROPOSITION 2017 / SUBVENTION 2016 :",null,null,null,null,null,{"$f":"J10-F10","v":-105056.5}]
[null,null,"VARIATION DEMANDE 2017 / PROPOSITION 2017 :",null,null,null,null,null,{"$f":"J10-G10","v":-45720}]
[]
["Récapitulatif des membres des associations",null,null,{"$f":"\"Subventions exceptionnelles \"&(H5-1)","v":"Subventions exceptionnelles 2016"},null,null,{"$f":"\"Subventions exceptionnelles \"&(H5)","v":"Subventions exceptionnelles 2017"}]
["Total adhérents2",{"$f":"SUM('Subventions 2017'!N62)","v":1231},null,"- ","Biennale",3076.5,"- "]
[null,null,null,"- ","Châtelaine",2000,"- "]
["Total ROC3",{"$f":"SUM('Subventions 2017'!O62)","v":376},null,"- ","Croix Rouge",5000,"- "]
[null,null,null,"TOTAL :",null,{"$f":"SUM(F17:F19)","v":10076.5},"TOTAL :",null,{"$f":"I17-I18-I19","v":0}]
[null,null,null,null,null,null,"Soit",{"$f":"SUM(I20-F20)","v":-10076.5},{"$f":"\"par rapport à\" &\" \"&(H5)","v":"par rapport à 2017"}]
[]
[]
["1 Le solde des associations extérieures ne représente pas la réalité. En effet, les fédérations ou unions présentent des soldes supérieurs de plusieurs centaines de milliers d'€."]
["2 Prend en compte l'ensemble des membres des associations ayant fait une demande de subvention en 2016."]
["3 Toutes les associations n'ayant pas nécessairement complétée la partie concernant les adhérents de la ville. il est à noter qu'il manque des rochechouartais. Aussi, les habitants étant très investis dans les associations, une personne a pu être compter plusieurs fois (dans chacune des associations pour laquelle elle adhère)."]

{"sheet":"Subventions 2017","index":1,"n_rows":64,"n_cols":15,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
["Type de demande","Catégorie","Associations locales","Associations extérieures","Sub 2013","Sub 2014","Sub 2015","Sub 2016","Demande 2017","Solde de banque ass. locales","Solde de banque ass. extérieures","Proposition 2017","Avis de la Commision","Total adhérents","Adhérents ROC"]
["Associations subventionnées en 2016 avec demandes 2017","Animation","Comité des fêtes",null,12000,17000,16500,16500,15500,16900,null,null,null,8,5]
["Associations subventionnées en 2016 sans demande 2017","Divers",null,"Transports Éducatifs de l'Enseignement Public (Adateep)",200,null,300,300]
["Associations subventionnées en 2016 avec demandes 2017","Animation","Association des Collectionneurs",null,1000,1500,1200,1200,1000,5562.79,null,null,null,23,5]
["Associations subventionnées en 2016 sans demande 2017","Animation","Comité de Jumelage",null,4200,4000,4000,4000]
["Associations subventionnées en 2016 sans demande 2017","Animation","La Brêche",null,null,1500,1400,1400]
["Associations subventionnées en 2016 sans demande 2017","Animation","La Gerbe",null,500,500,300,800]
["Associations subventionnées en 2016 avec demandes 2017","Animation","Tout en Art",null,null,1000,1500,300,400,1401.2,null,null,null,20,2]
["Associations subventionnées en 2016 avec demandes 2017","Culture","Amis Ecole de Musique et Danse",null,null,1400,200,200,200,7556.41,null,null,null,54,40]
["Associations subventionnées en 2016 sans demande 2017","Culture","Cantique",null,300,300,200,200]
["Associations subventionnées en 2016 sans demande 2017","Culture","Chorale Philomèle",null,300,300,200,0]
["Nouvelles demandes","Culture","Faites des Livres",null,null,null,null,null,1500,31813,null,null,null,30]
["Associations subventionnées en 2016 avec demandes 2017","Culture","Graine d'Art",null,null,300,300,200,400,744.29,null,null,null,107,4]
["Associations subventionnées en 2016 avec demandes 2017","Culture","Interlingua",null,300,300,200,300,500,157.24,null,null,null,21,14]
["Associations subventionnées en 2016 sans demande 2017","Culture","La Châtelaine",null,2000,2000,1500,3500]
["Associations subventionnées en 2016 sans demande 2017","Culture","Learning Together",null,300,500,300,300]
["Associations subventionnées en 2016 sans demande 2017","Culture","Météorythmes",null,200,200,200,200]
["Associations subventionnées en 2016 sans demande 2017","Culture","Olympes",null,8700,8700,8600,8900]
["Associations subventionnées en 2016 sans demande 2017","Culture","OT",null,null,3820,null,3076.5]
["Associations subventionnées en 2016 sans demande 2017","Culture","Pierre de Lune",null,null,null,null,250]
["Associations subventionnées en 2016 sans demande 2017","Culture","Arts Loisirs Créations",null,400,400,300,300]
["Associations subventionnées en 2016 avec demandes 2017","Divers","ACPG (Anciens Combattants - CATM)",null,200,200,100,100,100,2056,null,null,null,30]
["Associations subventionnées en 2016 sans demande 2017","Divers","Amicale des Personnels",null,8000,9840,7500,7500]
["Associations subventionnées en 2016 avec demandes 2017","Divers","Club Amitié & Loisirs",null,500,500,300,300,500,5547.86,null,null,null,70,70]
["Associations subventionnées en 2016 avec demandes 2017","Divers","Coopérative Scolaire - Collège",null,700,1200,500,500,500,10713.52]
["Associations subventionnées en 2016 avec demandes 2017","Divers","Coopérative Scolaire - Ecole Elémentaire",null,9922,8970,9500,8970,2770,23055.34,null,null,"+ classe de neige"]
["Associations subventionnées en 2016 avec demandes 2017","Divers","Coopérative Scolaire - Ecole Maternelle",null,1090,1000,1000,1000,1000,4698.62,null,null,null,96]
["Associations subventionnées en 2016 sans demande 2017","Divers","Fédération des Chasseurs (ACCA)",null,500,500,300,300]
["Associations subventionnées en 2016 sans demande 2017","Divers","Les Amis des Fleurs",null,400,400,300,300]
["Associations subventionnées en 2016 sans demande 2017","Divers","Moto Club Les Vasions",null,null,300,200,200,250,4828.59,null,null,null,54,6]
["Associations subventionnées en 2016 avec demandes 2017","Divers","FNATH - Personne handicapées, victimes du travail",null,400,400,300,200,200,3714]
["Nouvelles demandes","Divers","Rucher Municipal",null,null,null,null,null,2000,null,null,null,null,null,14]
["Associations subventionnées en 2016 sans demande 2017","Divers",null,"PEP 87 (Pupilles)",150,150,50,50]
["Associations subventionnées en 2016 avec demandes 2017","Santé","Association des Donneurs de Sang",null,700,700,700,700,700,1802.76]
["Associations subventionnées en 2016 sans demande 2017","Santé","Vie Libre",null,150,150,100,100]
["Associations subventionnées en 2016 sans demande 2017","Solidarité - Prévention","Ligue des Droits de l'Homme",null,300,300,200,200]
["Associations subventionnées en 2016 sans demande 2017","Solidarité - Prévention","Secours Catholique",null,1200,1200,1000,1000]
["Associations subventionnées en 2016 sans demande 2017","Solidarité - Prévention","Secours Populaire Français",null,1200,1200,1000,1000]
["Associations subventionnées en 2016 avec demandes 2017","Solidarité - Prévention",null,"ASAPH (ancien ESAT Les Seilles)",1300,1300,1000,1000,1000,null,21353.040000000001,null,null,62,12]
["Nouvelles demandes","Solidarité - Prévention",null,"Planning Familial",null,null,null,0,200,null,9935.27]
["Associations subventionnées en 2016 sans demande 2017","Solidarité - Prévention",null,"Pouce Travail",150,150,150,150]
["Associations subventionnées en 2016 avec demandes 2017","Solidarité - Prévention",null,"Prévention Routière 87",200,200,100,100,200,null,3075.5,null,null,null,8]
["Associations subventionnées en 2016 sans demande 2017","Solidarité - Prévention",null,"Service de portage de repas Croix Rouge ",null,0,0,5000]
["Associations subventionnées en 2016 avec demandes 2017","Sport","Association sportive du Collège",null,700,700,500,500,500,980,null,null,null,74,44]
["Associations subventionnées en 2016 sans demande 2017","Sport","Ball Trap Club",null,300,400,300,300]
["Associations subventionnées en 2016 sans demande 2017","Sport","Gym Bien-Être",null,200,200,150,200]
["Associations subventionnées en 2016 sans demande 2017","Sport","La Truite",null,0,800,600,600]
["Associations subventionnées en 2016 sans demande 2017","Sport","Leg Hand",null,0,0,null,0]
["Associations subventionnées en 2016 avec demandes 2017","Sport","Pétanque Populaire",null,600,600,800,800,800,8437.59,null,null,null,71]
["Associations subventionnées en 2016 sans demande 2017","Sport","Quad ROMC",null,1500,2500,500,2000]
["Associations subventionnées en 2016 avec demandes 2017","Sport","Handball",null,12000,12000,12000,12000,12000,43839,null,null,null,398,84]
["Associations subventionnées en 2016 sans demande 2017","Sport","Athlétisme",null,500,600,900,700]
["Associations subventionnées en 2016 sans demande 2017","Sport","Cyclo",null,800,800,5900,5600]
["Associations subventionnées en 2016 avec demandes 2017","Sport","Danse de salon",null,400,400,300,300,300,5866,null,null,null,45]
["Associations subventionnées en 2016 sans demande 2017","Sport","Football",null,3000,3500,3000,3560]
["Associations subventionnées en 2016 sans demande 2017","Sport","Gym",null,500,500,null,0]
["Associations subventionnées en 2016 sans demande 2017","Sport","Judo",null,4500,4500,4500,4500]
["Associations subventionnées en 2016 avec demandes 2017","Sport","Omnisports",null,1000,1000,1200,1200,1200,null,null,null,null,15,15]
["Associations subventionnées en 2016 avec demandes 2017","Sport","Tennis",null,2500,2100,2000,1800,2000,15373,null,null,null,53,53]
["Associations subventionnées en 2016 sans demande 2017","Sport","Volley Ball",null,400,450,400,400]
[null,null,null,null,{"$f":"SUM(E2:E60)","v":86362},103430,94550,105056.5,{"$f":"SUM(I2:I60)","v":45720},195047.20999999996,34363.81,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N2:N61)","v":1231},{"$f":"SUM(O2:O61)","v":376}]
[null,null,"Total asso. Locales","Total asso. Extérieures"]
[null,null,{"$f":"COUNTA(C2:C60)","v":52},{"$f":"COUNTA(D2:D60)","v":7}]

{"sheet":"Subs 2016 sans demande 2017","index":2,"n_rows":41,"n_cols":14,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,0,2,13],[4,0,4,13]]}
[{"$f":"Synthèse!A1","v":"Commission Sport - Vie Associative"}]
[]
[]
[null,{"$f":"COUNTA(B7:B200)","v":31},{"$f":"COUNTA(C7:C200)","v":4},{"$f":"SUM(D7:D200)","v":40850},{"$f":"SUM(E7:E200)","v":50660},44350,56886.5,250,4828.59,0,0,null,{"$f":"SUM(M7:M200)","v":54},{"$f":"SUM(N7:N200)","v":6}]
[{"$f":"Feuil2!A2","v":"Associations subventionnées en 2016 sans demande 2017"}]
[{"$f":"'Subventions 2017'!B1","v":"Catégorie"},{"$f":"'Subventions 2017'!C1","v":"Associations locales"},{"$f":"'Subventions 2017'!D1","v":"Associations extérieures"},{"$f":"'Subventions 2017'!E1","v":"Sub 2013"},{"$f":"'Subventions 2017'!F1","v":"Sub 2014"},{"$f":"'Subventions 2017'!G1","v":"Sub 2015"},{"$f":"'Subventions 2017'!H1","v":"Sub 2016"},{"$f":"'Subventions 2017'!I1","v":"Demande 2017"},{"$f":"'Subventions 2017'!J1","v":"Solde de banque ass. locales"},{"$f":"'Subventions 2017'!K1","v":"Solde de banque ass. extérieures"},{"$f":"'Subventions 2017'!L1","v":"Proposition 2017"},{"$f":"'Subventions 2017'!M1","v":"Avis de la Commision"},{"$f":"'Subventions 2017'!N1","v":"Total adhérents"},{"$f":"'Subventions 2017'!O1","v":"Adhérents ROC"}]
["Divers",null,"Transports Éducatifs de l'Enseignement Public (Adateep)",200,null,300,300]
["Animation","Comité de Jumelage",null,4200,4000,4000,4000]
["Animation","La Brêche",null,null,1500,1400,1400]
["Animation","La Gerbe",null,500,500,300,800]
["Culture","Cantique",null,300,300,200,200]
["Culture","Chorale Philomèle",null,300,300,200,0]
["Culture","La Châtelaine",null,2000,2000,1500,3500]
["Culture","Learning Together",null,300,500,300,300]
["Culture","Météorythmes",null,200,200,200,200]
["Culture","Olympes",null,8700,8700,8600,8900]
["Culture","OT",null,null,3820,null,3076.5]
["Culture","Pierre de Lune",null,null,null,null,250]
["Culture","Arts Loisirs Créations",null,400,400,300,300]
["Divers","Amicale des Personnels",null,8000,9840,7500,7500]
["Divers","Fédération des Chasseurs (ACCA)",null,500,500,300,300]
["Divers","Les Amis des Fleurs",null,400,400,300,300]
["Divers","Moto Club Les Vasions",null,null,300,200,200,250,4828.59,null,null,null,54,6]
["Divers",null,"PEP 87 (Pupilles)",150,150,50,50]
["Santé","Vie Libre",null,150,150,100,100]
["Solidarité - Prévention","Ligue des Droits de l'Homme",null,300,300,200,200]
["Solidarité - Prévention","Secours Catholique",null,1200,1200,1000,1000]
["Solidarité - Prévention","Secours Populaire Français",null,1200,1200,1000,1000]
["Solidarité - Prévention",null,"Pouce Travail",150,150,150,150]
["Solidarité - Prévention",null,"Service de portage de repas Croix Rouge ",null,0,0,5000]
["Sport","Ball Trap Club",null,300,400,300,300]
["Sport","Gym Bien-Être",null,200,200,150,200]
["Sport","La Truite",null,0,800,600,600]
["Sport","Leg Hand",null,0,0,null,0]
["Sport","Quad ROMC",null,1500,2500,500,2000]
["Sport","Athlétisme",null,500,600,900,700]
["Sport","Cyclo",null,800,800,5900,5600]
["Sport","Football",null,3000,3500,3000,3560]
["Sport","Gym",null,500,500,null,0]
["Sport","Judo",null,4500,4500,4500,4500]
["Sport","Volley Ball",null,400,450,400,400]

{"sheet":"Subs 2016 avec demandes 2017","index":3,"n_rows":27,"n_cols":14,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,2,13],[4,0,4,13]]}
[{"$f":"Synthèse!A1","v":"Commission Sport - Vie Associative"}]
[]
[]
[null,{"$f":"COUNTA(B7:B200)","v":19},{"$f":"COUNTA(C7:C200)","v":2},{"$f":"SUM(D7:D200)","v":45512},{"$f":"SUM(E7:E200)","v":52770},50200,48170,41770,158405.62,24428.54,0,null,{"$f":"SUM(M7:M200)","v":1147},{"$f":"SUM(N7:N200)","v":356}]
[{"$f":"Feuil2!A1","v":"Associations subventionnées en 2016 avec demandes 2017"}]
[{"$f":"'Subventions 2017'!B1","v":"Catégorie"},{"$f":"'Subventions 2017'!C1","v":"Associations locales"},{"$f":"'Subventions 2017'!D1","v":"Associations extérieures"},{"$f":"'Subventions 2017'!E1","v":"Sub 2013"},{"$f":"'Subventions 2017'!F1","v":"Sub 2014"},{"$f":"'Subventions 2017'!G1","v":"Sub 2015"},{"$f":"'Subventions 2017'!H1","v":"Sub 2016"},{"$f":"'Subventions 2017'!I1","v":"Demande 2017"},{"$f":"'Subventions 2017'!J1","v":"Solde de banque ass. locales"},{"$f":"'Subventions 2017'!K1","v":"Solde de banque ass. extérieures"},{"$f":"'Subventions 2017'!L1","v":"Proposition 2017"},{"$f":"'Subventions 2017'!M1","v":"Avis de la Commision"},{"$f":"'Subventions 2017'!N1","v":"Total adhérents"},{"$f":"'Subventions 2017'!O1","v":"Adhérents ROC"}]
["Animation","Comité des fêtes",null,12000,17000,16500,16500,15500,16900,null,null,null,8,5]
["Animation","Association des Collectionneurs",null,1000,1500,1200,1200,1000,5562.79,null,null,null,23,5]
["Animation","Tout en Art",null,null,1000,1500,300,400,1401.2,null,null,null,20,2]
["Culture","Amis Ecole de Musique et Danse",null,null,1400,200,200,200,7556.41,null,null,null,54,40]
["Culture","Graine d'Art",null,null,300,300,200,400,744.29,null,null,null,107,4]
["Culture","Interlingua",null,300,300,200,300,500,157.24,null,null,null,21,14]
["Divers","ACPG (Anciens Combattants - CATM)",null,200,200,100,100,100,2056,null,null,null,30]
["Divers","Club Amitié & Loisirs",null,500,500,300,300,500,5547.86,null,null,null,70,70]
["Divers","Coopérative Scolaire - Collège",null,700,1200,500,500,500,10713.52]
["Divers","Coopérative Scolaire - Ecole Elémentaire",null,9922,8970,9500,8970,2770,23055.34,null,null,"+ classe de neige"]
["Divers","Coopérative Scolaire - Ecole Maternelle",null,1090,1000,1000,1000,1000,4698.62,null,null,null,96]
["Divers","FNATH - Personne handicapées, victimes du travail",null,400,400,300,200,200,3714]
["Santé","Association des Donneurs de Sang",null,700,700,700,700,700,1802.76]
["Solidarité - Prévention",null,"ASAPH (ancien ESAT Les Seilles)",1300,1300,1000,1000,1000,null,21353.040000000001,null,null,62,12]
["Solidarité - Prévention",null,"Prévention Routière 87",200,200,100,100,200,null,3075.5,null,null,null,8]
["Sport","Association sportive du Collège",null,700,700,500,500,500,980,null,null,null,74,44]
["Sport","Pétanque Populaire",null,600,600,800,800,800,8437.59,null,null,null,71]
["Sport","Handball",null,12000,12000,12000,12000,12000,43839,null,null,null,398,84]
["Sport","Danse de salon",null,400,400,300,300,300,5866,null,null,null,45]
["Sport","Omnisports",null,1000,1000,1200,1200,1200,null,null,null,null,15,15]
["Sport","Tennis",null,2500,2100,2000,1800,2000,15373,null,null,null,53,53]

{"sheet":"Nouvelles demandes","index":4,"n_rows":7,"n_cols":14,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,1,2,12],[4,1,4,12]]}
[null,{"$f":"Synthèse!A1","v":"Commission Sport - Vie Associative"}]
[]
[]
[null,{"$f":"COUNTA(B7:B200)","v":0},{"$f":"COUNTA(C7:C200)","v":1},{"$f":"SUM(D7:D200)","v":0},{"$f":"SUM(E7:E200)","v":0},0,0,200,0,9935.27,0,null,{"$f":"SUM(M7:M200)","v":0},{"$f":"SUM(N7:N200)","v":0}]
[null,{"$f":"Feuil2!A3","v":"Nouvelles demandes"}]
[{"$f":"'Subventions 2017'!B1","v":"Catégorie"},{"$f":"'Subventions 2017'!C1","v":"Associations locales"},{"$f":"'Subventions 2017'!D1","v":"Associations extérieures"},{"$f":"'Subventions 2017'!E1","v":"Sub 2013"},{"$f":"'Subventions 2017'!F1","v":"Sub 2014"},{"$f":"'Subventions 2017'!G1","v":"Sub 2015"},{"$f":"'Subventions 2017'!H1","v":"Sub 2016"},{"$f":"'Subventions 2017'!I1","v":"Demande 2017"},{"$f":"'Subventions 2017'!J1","v":"Solde de banque ass. locales"},{"$f":"'Subventions 2017'!K1","v":"Solde de banque ass. extérieures"},{"$f":"'Subventions 2017'!L1","v":"Proposition 2017"},{"$f":"'Subventions 2017'!M1","v":"Avis de la Commision"},{"$f":"'Subventions 2017'!N1","v":"Total adhérents"},{"$f":"'Subventions 2017'!O1","v":"Adhérents ROC"}]
["Solidarité - Prévention",null,"Planning Familial",null,null,null,0,200,null,9935.27]

{"sheet":"Feuil2","index":5,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Associations subventionnées en 2016 avec demandes 2017"]
["Associations subventionnées en 2016 sans demande 2017"]
["Nouvelles demandes"]