{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Présentat°","Budget Prév. 2018","BASE GESTIONNAIRES EAJE"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":7,"comments":1,"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":"Présentat°","index":0,"n_rows":26,"n_cols":1,"rows_kept":26,"cut":false,"hidden":false,"merged":[[1,0,1,15],[25,0,25,15],[2,0,2,15],[4,0,5,15]]}
[]
["Bienvenue sur la page d'accueil des documents EAJE"]
["dès l'apparition de cette feuille cliquer sur OK"]
[]
["Il vous suffit de cliquer sur les icônes ci-dessous (une petite main apparaîtra) vous pourrez ainsi remplir votre budget prévisionnel 2018 actualisé."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Pour permettre une meilleure identification de vos documents, vous devez mettre impérativement votre n° de dossier (dit n° SIAS)."]

{"sheet":"Budget Prév. 2018","index":1,"n_rows":54,"n_cols":9,"rows_kept":54,"cut":false,"hidden":false,"merged":[[4,0,6,1],[31,8,32,8],[19,0,19,2],[31,6,36,6],[21,8,22,8],[8,2,8,7],[21,6,22,6],[14,7,14,8],[44,1,46,1],[43,0,43,2],[21,7,22,7],[21,0,22,0],[21,1,22,1],[21,2,22,2],[21,5,22,5],[48,0,48,2],[49,0,49,2],[50,0,50,1],[51,0,51,2],[53,0,53,1]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Budget Prévisionnel 2018 actualisé"]
[]
[]
[null,null,null,null,null,null,"N° sias :","merci de selectionner votre n° de dossier SIAS"]
[null,null,null,null,null,null,"Equipement :",{"$f":"IF($H$12<>\"\",VLOOKUP($H$12,TABLEIDENTIF,5,FALSE),\"\")","v":0}]
[null,null,null,null,null,null,"Ville :",{"$f":"IF($H$12<>\"\",VLOOKUP($H$12,TABLEIDENTIF,8,FALSE),\"\")","v":0}]
[null,null,null,null,null,null,"Gestionnaire :",{"$f":"IF($H$12<>\"\",VLOOKUP($H$12,TABLEIDENTIF,3,FALSE),\"\")","v":0}]
[null,null,null,null,null,null,"Code postal :",{"$f":"IF($H$12<>\"\",VLOOKUP($H$12,TABLEIDENTIF,7,FALSE),\"\")","v":0}]
[null,null,null,null,null,null,"Activité :",{"$f":"IF($H$12<>\"\",VLOOKUP($H$12,TABLEIDENTIF,6,FALSE),\"\")","v":0}]
["Courriel :","gestion.actionsociale@caftours.cnafmail.fr",null,null,null,null,"Corbeille S@fir :","Prèv PSO"]
[]
[]
[]
["Numéro compte","CHARGES DE FONCTIONNEMENT","Prévisions 2018",null,null,null,"Numéro compte","PRODUITS DE FONCTIONNEMENT","Prévisions 2018"]
[]
[60,"ACHATS",null,null,null,null,70623,"Prestations de Service CAF"]
[61,"SERVICES EXTERIEURS",null,null,null,null,70624,"Fonds d'accompagement Caf Touraine"]
[62,"AUTRES SERVICES EXTERIEURS",null,null,null,null,70641,"Participations familiales y compris les majorations "]
[63," IMPOTS TAXES ET VERSEMENTS ASSIMILES",null,null,null,null,70642,"Participations familiales non déductibles de la PSU"]
[64," CHARGES DE PERSONNEL",null,null,null,null,741,"Subvention d’exploitation Etat"]
[66,"CHARGES FINANCIERES",null,null,null,null,742,"Prestations de Service Conseil Régional"]
[67,"CHARGES EXCEPTIONNELLES",null,null,null,null,7430,"Subvention d’exploitation Conseil Général "]
[68,"Dotation aux amortissements",null,null,null,null,7431,"Prestations de Service Conseil Général"]
[68,"Dotation aux provisions (retraite, licenciement, litiges et autres)",null,null,null,null,744,"Subvention d’exploitation Commune de :"]
[68,"TOTAL DOTATIONS AUX AMORTISSEMENTS ET PROVISIONS",{"$f":"SUM(C31+C32)","v":0}]
[69,"IMPOT SUR LES BENEFICES"]
[65,"CHARGES INDIRECTES \n(pour les collectivités locales) "]
[86,"CHARGES SUPPLETIVES \n(pour les associations)"]
[null,"TOTAL DES CHARGES",{"$f":"SUM(C34:C36,C24:C32)","v":0}]
[null,"EXCEDENT DE L’EXERCICE",{"$f":"IF(I51>C37,I51-C37,\"\")","v":""},null,null,null,7451,"Prestations de Service MSA "]
[null,"TOTAL POUR BALANCE ",{"$f":"SUM(C37:C38)","v":0},null,null,null,7452,"Subvention de fonctionnement CAF Touraine"]
[null,null,null,null,null,null,746,"Subvention d’exploitation Communauté de Communes de :"]
["A",null,null,null,null,null,747,"Subvention exploitation entreprises \n(pour les entreprises de crèche)"]
["Le",null,null,null,null,null,748,"Autres Subventions dont Fonds Européens"]
[null,null,null,null,null,null,75,"Cotisations des adhérents "]
["Signature, qualité du signataire et cachet OBLIGATOIRES \n(uniquement si retour en papier) :",null,null,null,null,null,75,"Autres revenus (y compris les participations liées à des sorties exceptionnelles ou évènements festifs….lotos) "]
[null,null,null,null,null,null,75,"TOTAL AUTRES PRODUITS DE  GESTION COURANTE",{"$f":"SUM(I43:I44)","v":0}]
[null,null,null,null,null,null,76,"PRODUITS FINANCIERS"]
[null,null,null,null,null,null,77," PRODUITS EXCEPTIONNELS"]
[null,null,null,null,null,null,78,"REPRISE S/PROVISION P/RISQUES & CHARGES"]
["Informations complémentaires destinées aux entreprises :",null,null,null,null,null,79,"TRANSFERT DE CHARGES"]
["\n- Si Subvention Exploitation Entreprise, veuillez indiquer le nombre de places réservées\n pour chaque entreprise.",null,null,null,null,null,87,"CONTRE PARTIE DES CHARGES SUPPLETIVES\n(pour les associations)",{"$f":"$C$36","v":0}]
["Êtes-vous assujettis à la TVA",null,null,null,null,null,null,"TOTAL DES PRODUITS",{"$f":"SUM(I46:I50,I24:I44)","v":0}]
["si oui, veuillez fournir l'attestation CERFA CA3 relative à l'assujettissement à la TVA.",null,null,null,null,null,null,"DEFICIT DE L’EXERCICE",{"$f":"IF(C37>I51,C37-I51,\"\")","v":""}]
[null,null,null,null,null,null,null,"TOTAL POUR BALANCE ",{"$f":"SUM(I51:I52)","v":0}]
["Commentaires :"]

{"sheet":"BASE GESTIONNAIRES EAJE","index":2,"n_rows":85,"n_cols":8,"rows_kept":85,"cut":false,"hidden":true,"merged":[]}
["NUMERO DOSSIER","NUMERO GESTIONNAIRE","RAISON SOCIALE GESTIONNAIRE","NUMERO EQUIPEMENT","NOM EQUIPEMENT","ACTIVITE EQUIPEMENT","CODE POSTAL ETABLISSEMENT OU EQUIPEMENT","NOM COMMUNE ETABLISSEMENT OU EQUIPEMENT"]
["merci de selectionner votre n° de dossier SIAS"]
[200100002,null,"MAIRIE DE CHAMBRAY LES TOURS",null,"Ets Acc Col L'Ile aux Trésors","Multi_accueil","37170","CHAMBRAY LES TOURS"]
[200100123,null,"ASSOC CAMILLE CLAUDEL LA VILLE AUX DAMES ",null,"Ets Acc Col Berlingot","Multi_accueil","37700","VILLE AUX DAMES"]
[200100127,null,"MAIRIE DE TOURS ",null,"Ets Acc Col Europe Chateaubria","Multi_accueil","37100","TOURS"]
[200100137,null,"ASSOC COCCINELLE",null,"Ets Acc Col Coccinelle","Multi_accueil","37220","L ILE BOUCHARD"]
[200200002,null,"CHRU DE TOURS",null,"Ets Acc Fam CHRU de Tours","Crèche familiale","37044","TOURS"]
[200200004,null,"ASSOC POM CASSIS ",null,"Ets Acc Col Pom Cassis","Multi_accueil","37100","TOURS"]
[200200005,null,"ASSOC RIBAMBELLE",null,"Ets Acc Col La Ribambelle","Multi_accueil","37200","TOURS"]
[200200013,null,"MAIRIE DE TOURS ",null,"Ets Acc Col Ctre vie Sanitas","Multi_accueil","37000","TOURS"]
[200200014,null,"MAIRIE DE TOURS ",null,"Ets Acc Col Rochepinard","Halte garderie","37000","TOURS"]
[200200017,null,"MAIRIE DE TOURS ",null,"Ets Acc Col des Fontaines","Halte garderie","37200","TOURS"]
[200200019,null,"ASSOC CRECHE ET HALTE GARDERIE GRAINES DE SOLEIL ",null,"Ets Acc Col Graine de Soleil","Multi_accueil","37390","METTRAY"]
[200200025,null,"MAIRIE DE TOURS ",null,"Ets Acc Col Charles Boutard","Crèche collective","37000","TOURS"]
[200200029,null,"MAIRIE DE TOURS ",null,"Ets Acc Col Giraudeau","Crèche collective","37000","TOURS"]
[200200031,null,"MAIRIE DE TOURS ",null,"Ets Acc Col Des Halles","Halte garderie","37000","TOURS"]
[200200032,null,"MAIRIE DE TOURS ",null,"Ets Acc Col des Tanneurs","Multi_accueil","37000","TOURS"]
[200200040,null,"MAIRIE DE LA RICHE ",null,"Ets Acc Fam La Riche","Crèche familiale","37520","LA RICHE"]
[200200042,null,"ASSOC HAGARI HALTE GARDERIE CARAMEL",null,"Ets Acc Col Caramel","Multi_accueil","37120","RICHELIEU"]
[200200069,null,"ASSOC LE JARDIN DE LA CIGOGNE",null,"Ets Acc Col Jardin la Cigogne","Multi_accueil","37100","TOURS"]
[200200070,null,"MAIRIE DE ST AVERTIN ",null,"Ets Acc Col La Courte Echelle","Crèche collective","37550","SAINT AVERTIN"]
[200200072,null,"MAIRIE DE CHAMBRAY LES TOURS",null,"Ets Acc Col Au P'tit Bonheur","Crèche collective","37170","CHAMBRAY LES TOURS"]
[200200073,null,"MAIRIE DE CHAMBRAY LES TOURS",null,"Ets Acc Col Les P'tits Pieds","Crèche collective","37170","CHAMBRAY LES TOURS"]
[200200074,null,"MAIRIE DE CHAMBRAY LES TOURS",null,"Ets Acc Col L'Ile aux Trésors","Crèche collective","37172","CHAMBRAY LES TOURS"]
[200200076,null,"ASSOC MINI RELAIS ",null,"Ets Acc Col Mini Relais","Multi_accueil","37000","TOURS"]
[200200077,null,"MAIRIE DE TOURS ",null,"Ets Acc Col des Fontaines","Crèche collective","37200","TOURS"]
[200200082,null,"MAIRIE DE TOURS ",null,"Ets Acc Col Grécourt","Crèche collective","37000","TOURS"]
[200200083,null,"MAIRIE DE TOURS ",null,"Ets Acc Col Heurteloup","Crèche collective","37000","TOURS"]
[200200085,null,"GRAMLIPETTES",null,"Ets Acc Col Galipette","Multi_accueil","37140","BOURGUEIL"]
[200200090,null,"ASSOC VOYAGEURS 37",null,"Ets Acc Col Tikni-Tikno","Halte garderie","37210","PARCAY MESLAY"]
[200200096,null,"ASSOC MINI MOUSSE ",null,"Ets Acc Col Mini Mousse","Multi_accueil","37000","TOURS"]
[200200098,null,"MAIRIE DE TOURS ",null,"Ets Acc Col Tonnelé","Crèche collective","37000","TOURS"]
[200200100,null,"MAIRIE DE TOURS ",null,"Ets Acc Col P Louis Courier","Crèche collective","37000","TOURS"]
[200200102,null,"MAIRIE DE TOURS",null,"Ets Acc Col Leccia","Crèche collective","37000","TOURS"]
[200200103,null,"MAIRIE DE ST PIERRE DES CORPS ",null,"Ets Acc Fam St Pierre ds Corps","Crèche familiale","37700","SAINT PIERRE DES CORPS"]
[200200114,null,"MAIRIE DE FONDETTES ",null,"Ets Acc Col La Poupardière","Crèche collective","37230","FONDETTES"]
[200200126,null,"MAIRIE DE TOURS ",null,"Ets Acc Fam Monconseil","Crèche familiale","37100","TOURS"]
[200200142,null,"MAIRIE DE ST AVERTIN ",null,"Ets Acc Fam  La Farandole","Multi_accueil","37551","SAINT AVERTIN"]
[200200148,null,"MAIRIE DE BALLAN MIRE ",null,"Ets Acc Fam Ballan Miré","Crèche familiale","37510","BALLAN MIRE"]
[200200185,null,"ASSOC TOURANGELLE DES CENTRES SOCIAUX ",null,"Ets Acc Col Goutzi Rabière","Halte garderie","37300","JOUE LES TOURS"]
[200200242,null,"MAIRIE DE FONDETTES ",null,"Ets Acc Col La Dorlotine","Multi_accueil","37230","FONDETTES"]
[200300300,null,"MAIRIE DE ST CYR SUR LOIRE ",null,"Ets Acc Col Pirouette St Cyr","Multi_accueil","37540","SAINT CYR SUR LOIRE"]
[200300378,null,"ASSOC FAMILLES RURALES STE MAURE ",null,"Ets Acc Col Pirouettes","Multi_accueil","37800","SAINTE MAURE DE TOURAINE"]
[200300445,null,"COMMUNAUTE DE CNES DU VAL D AMBOISE ",null,"Ets Acc Col Les Bouts d'Chou","Crèche collective","37400","AMBOISE"]
[200300481,null,"MAIRIE DE LUYNES ",null,"Ets Acc Col Les P'tits Loups","Multi_accueil","37230","LUYNES"]
[200300520,null,"MAIRIE DE TOURS",null,"Ets Acc Col Charles Boutard","Multi_accueil","37000","TOURS"]
[200400184,null,"MAIRIE DE ST CYR SUR LOIRE ",null,"Ets Acc Col La Souris Verte","Multi_accueil","37540","SAINT CYR SUR LOIRE"]
[200500013,null,"MAIRIE DE LA RICHE ",null,"Ets Acc Col Maison de Enfance","Multi_accueil","37520","LA RICHE"]
[200500014,null,"MAIRIE DE ST PIERRE DES CORPS ",null,"Ets Acc Col Pataploum","Multi_accueil","37700","SAINT PIERRE DES CORPS"]
[200500218,null,"MAIRIE DE ROCHECORBON",null,"Ets Acc Col La Terrasse","Multi_accueil","37210","ROCHECORBON"]
[200500222,null,"MAIRIE DE TOURS ",null,"Ets Acc Col Toulouse Lautrec","Multi_accueil","37200","TOURS"]
[200500232,null,"MAIRIE DE TOURS",null,"Ets Acc Col Hallebardier","Multi_accueil","37000","TOURS"]
[200600059,null,"MAIRIE DE ST AVERTIN ",null,"Ets Acc Col Trampoline","Multi_accueil","37550","SAINT AVERTIN"]
[200600150,null,"MAIRIE DE CHAMBRAY LES TOURS ",null,"Ets Acc Col Au Fil de l'Eau","Multi_accueil","37170","CHAMBRAY LES TOURS"]
[200700001,null,"ASSOC CENTRE SOCIO CULTUREL DE BLERE ",null,"Ets Acc Col Ctre socio culture","Multi_accueil","37150","BLERE"]
[200700057,null,"MAIRIE DE LA MEMBROLLE SUR CHOISILLE ",null,"Ets Acc Col Petites Frimousses","Multi_accueil","37390","MEMBROLLE SUR CHOISILLE"]
[200700073,null,"MUTUALITE FRANCAISE CENTRE - VAL DE LOIRE ",null,"Ets Acc Col Maison de l'éveil","Multi_accueil","37260","MONTS"]
[200700074,null,"MUTUALITE FRANCAISE CENTRE - VAL DE LOIRE ",null,"Ets Acc Col Les Lutins","Multi_accueil","37320","ESVRES"]
[200700075,null,"MUTUALITE FRANCAISE CENTRE - VAL DE LOIRE ",null,"Ets Acc Col Les petits mousses","Multi_accueil","37250","MONTBAZON"]
[200700076,null,"MUTUALITE FRANCAISE CENTRE - VAL DE LOIRE ",null,"Ets Acc Col Petits Malins","Multi_accueil","37250","VEIGNE"]
[200700344,null,"ASSOC ACHIL ACEPP",null,"Ets Acc Col Bidibulles","Multi_accueil","37340","AMBILLOU"]
[200700345,null,"ASSOC ACHIL ACEPP",null,"Ets Acc Col Pom de Reinette","Multi_accueil","37330","SOUVIGNE"]
[200800024,null,"ASSOC CISPEO PETITE ENFANCE ",null,"Ets Acc Col Confetti","Multi_accueil","37000","TOURS"]
[200800025,null,"ASSOC CISPEO PETITE ENFANCE ",null,"Ets Acc Col Jardin d'Alice","Multi_accueil","37000","TOURS"]
[200800275,null,"COMMUAUTE DE CNES DU CASTELRENAUDAIS ",null,"Ets Acc Col Le Martin Pêcheur","Multi_accueil","37110","CHATEAU RENAULT"]
[200800276,null,"COMMUAUTE DE CNES DU CASTELRENAUDAIS ",null,"Ets Acc Fam Martin Pêcheur","Crèche familiale","37110","CHATEAU RENAULT"]
[200800365,null,"MUTUALITE FRANCAISE CENTRE - VAL DE LOIRE ",null,"Ets Acc Col 1 2 3 SOLEIL","Multi_accueil","37260","MONTS"]
[200800366,null,"MUTUALITE FRANCAISE CENTRE - VAL DE LOIRE ",null,"Ets Acc Col La Passerelle","Multi_accueil","37250","VEIGNE"]
[200800401,null,"SOLUTIONS CRECHE SARL ",null,"Ets Acc Col Melba","Multi_accueil","37550","SAINT AVERTIN"]
[200900016,null,"ASSOC CISPEO PETITE ENFANCE ",null,"Ets Acc Col Bout'Chou Service","Multi_accueil","37000","TOURS"]
[200900431,null,"COMMUNAUTE DE CNES DU VAL D AMBOISE ",null,"Ets Acc Col Vilvent","Multi_accueil","37530","NAZELLES NEGRON"]
[200900517,null,"MAIRIE DE BALLAN MIRE ",null,"Ets Acc Col Brin de Malice","Multi_accueil","37510","BALLAN MIRE"]
[201000282,null,"ASSOC DOUCE LUNE ",null,"Ets Acc Col Douce Lune","Multi_accueil","37000","TOURS"]
[201100003,null,"MAIRIE DE ST AVERTIN ",null,"Ets Acc Col Tom Pouce","Multi_accueil","37550","SAINT AVERTIN"]
[201100206,null,"SAS PEOPLE AND BABY",null,"Ets Acc Col Tournicoti","Multi_accueil","37100","TOURS"]
[201100332,null,"ASSOC ENFANCE POUR TOUS",null,"Ets Acc Col Les Lucioles","Multi_accueil","37270","ATHEE SUR CHER"]
[201300058,null,"MUTUALITE FRANCAISE CENTRE - VAL DE LOIRE ",null,"Ets Acc Col La Boîte à Malice","Micro Crèche","37320","ESVRES"]
[201300059,null,"MUTUALITE FRANCAISE CENTRE - VAL DE LOIRE ",null,"Ets Acc Col Atouts Petits","Multi_accueil","37380","MONNAIE"]
[201700186,null,"COMMUNAUTE DE CNES TOURAINE EST VALLEES",null,"Ets Acc Col Suzanne Lacorre","Multi_accueil",37270,"MONTLOUIS SUR LOIRE"]
[201700187,null,"COMMUNAUTE DE CNES TOURAINE EST VALLEES",null,"Ets Acc Col La Souris Verte","Multi_accueil",37270,"VERETZ"]
[201700188,null,"COMMUNAUTE DE CNES TOURAINE EST VALLEES ",null,"Ets Acc Col Les P'tits Mousses","Multi_accueil",37270,"LARCAY"]
[201700189,null,"COMMUNAUTE DE CNES TOURAINE EST VALLEES ",null,"Ets Acc Col l'Ilôt Calin","Multi_accueil",37270,"AZAY SUR CHER "]
[201700190,null,"COMMUNAUTE DE CNES TOURAINE OUEST VAL DE LOIRE ",null,"Ets Acc Col Les Petits Princes","Multi_accueil",37130,"LANGEAIS"]
[201800058,null,"MAIRIE DE ST PIERRE DES CORPS ",null,"Ets Acc Col La Farandole","Multi_accueil","37700","SAINT PIERRE DES CORPS"]
[201800184,null,"ASSOC USAGERS CENTRE SOCIAL GIRAUDEAU ",null,"Ets Acc Col Sitarine","Multi_accueil","37000","TOURS"]