{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Page 1 (Intro)","Page 2 (Renseignements)","Page 3 (Budget)","Page 4 (Grilles)","Page 5 (Synthese)","Donnees"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":80,"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":"Page 1 (Intro)","index":0,"n_rows":26,"n_cols":11,"rows_kept":26,"cut":false,"hidden":false,"merged":[[25,1,25,9],[0,4,0,9],[3,1,3,9],[7,1,7,9],[9,1,9,9],[11,1,11,9],[17,1,17,9],[18,1,18,9],[19,1,19,9],[20,1,20,9],[23,1,23,9],[24,1,24,9]]}
[null,null,null,null,"CENTRE DE RECHERCHE DE PEDAGOGIE ACTIVE DENIS COUTROT"]
[null,"Madame, Monsieur,"]
[]
[null,"Les renseignements que vous allez saisir dans ce questionnaire vous permettront de vous donner une estimation des frais annuels (scolarité, restauration, fournitures pédagogiques, accueil au centre de loisirs) afin que vous puissiez voir l'impact sur votre budget."]
[null,null,null,null,null,null,null,null,null,null," "]
[null,"Pour avoir une estimation la plus précise possible, veillez à bien saisir toutes les informations demandées."]
[]
[null,"Les montants des différents frais de l'année scolaire 2024/2025 ne sont pas encore fixés. Le Conseil d'Administration votera les augmentation en avril/mai 2025 après la validation du budget prévionnel. Dans ce fichier de simulation, l'augmentation par rapport à l'année scolaire 2023/2024 a été estimée à 3,0 %."]
[]
[null,"Cette estimation ne présage pas des frais réels que vous aurez à payer si vous inscrivez un ou plusieurs enfants à l'École Nouvelle d'Antony."]
[]
[null,"Le montant réel sera fonction du calcul effectué au début de l'année scolaire et qui dépendra de vos ressources et de vos charges saisies dans le portail famille (système en ligne) à cette période ainsi que des justificatifs fournis. Si les justificatifs ne sont pas transmis (par choix ou omission), c'est le montant le plus élevé de la scolarité qui sera appliqué."]
[]
[null,null,null,null,null,null,null,"Pour le Conseil d’Administration"]
[null,null,null,null,null,null,null,"Le (la) Trésorier (ière) du CRPA"]
[]
[]
[null,"Précisions :"]
[null,"Le quotient familial (QF), qui détermine le montant de la scolarité de l'École et le coût à l'heure du Centre de Loisirs, n'utilise pas les mêmes règles de calcul du nombre de parts que celles de l'Administration Fiscale."]
[null,"Pour la restauration scolaire, trois possibilités :\n- L'enfant est externe, il prend son repas à la maison. Il est récupéré à la sortie des cours et ramené avant le début des cours.\n- L'enfant est demi-pensionnaire, il prend le repas du traiteur. Le coût comprend la surveillance du temps de midi et le prix du repas du traiteur {voir onglet 'Page 4 (Grilles)'}.\n- L'enfant amène le repas de la maison. Le coût comprend uniquement le prix de la surveillance du temps de midi."]
[null,"Le Centre de Loisirs (CLAE) est facturé à l'unité (~ 1 heure) ; le coût de l'unité est variable suivant le QF (5 niveaux). Les factures sont indépendantes de celle de l'École (scolarité, restauration et founitures pédagogiques). Elles sont établies, en fin de période scolaire, avec un coût à la semaine intégrant des réductions qui augmentent en fonction de la fréquentation.\nIl y a 5 périodes scolaires : \n       1-  De la rentrée aux vacances de Toussaint (7 semaines)\n       2-  Du retour des vacances de la Toussaint aux vacances de Noël (6 à 7 semaines)\n       3-  De janvier aux vacances d'hiver (5 à 7 semaines) \n       4-  Du retour des vacances d'hiver aux vacances de printemps (5 à 7 semaines)\n       5-  Du retour des vacances de printemps aux vacances d'été (7 à 9 semaines).\nL'onglet 'Page 4 (Grilles)' donne le prix de l'unité en fonction du QF et vous précise le pourcentage de réduction en fonction de la fréquentation (nombre d'unités par semaine)."]
[]
[]
[null," CRPA - 4-6 Avenue d’Alembert – 92160 ANTONY "]
[null,"Téléphone 01 43 50 13 83 - Mél : inscription@ecolenouvelle.fr"]
[null," SIRET 785 272 071 00016 - APE 801 Z "]

{"sheet":"Page 2 (Renseignements)","index":1,"n_rows":45,"n_cols":9,"rows_kept":45,"cut":false,"hidden":false,"merged":[[42,1,42,9],[44,1,44,9],[36,5,36,8],[0,3,0,9],[15,5,15,8],[2,2,2,8],[3,2,3,8],[24,5,24,8],[5,2,5,8],[7,2,7,8],[17,1,17,8],[26,1,26,8]]}
[null,null,null,"CENTRE DE RECHERCHE DE PEDAGOGIE ACTIVE\nDENIS COUTROT"]
[]
[null,null,"ÉCOLE NOUVELLE D'ANTONY"]
[null,null,"4-6 Avenue d'ALEMBERT\n92160 ANTONY"]
[]
[null,null,{"$f":"\"Année Scolaire \"&AnSN1","v":"Année Scolaire 2024/2025"}]
[]
[null,null,"ÉLÉMENTS POUR LE CALCUL DU NOMBE DE PARTS"]
[]
[]
[null,null,"Quel est le nombre d'adultes au sein du foyer :",null,null,null,null,{"$f":"IF(AND(NbAdulte=\"\",NbEnfant>0,NbEnfENA>0),\"Saisie à effectuer !\",\"\")","v":""}]
[null,null,"La famille est-elle monoparentale (1/2 part en plus)",null,null,null,null,{"$f":"IF(AND(NbAdulte>0,FamilleMonoP=\"\"),\"Saisie à effectuer !\",\"\")","v":""}]
[null,null,"Combien d'enfant(s) dans la famille : ",null,null,null,null,{"$f":"IF(AND(NbAdulte>0,NbEnfant=\"\"),\"Saisie à effectuer !\",\"\")","v":""}]
[null,null,"Combien d'enfant(s) fréquenteront l'École Nouvelle d'Antony :",null,null,null,null,{"$f":"IF(AND(NbEnfant<>\"\",NbEnfENA=\"\"),\"Saisie à effectuer !\",IF(NbEnfENA>NbEnfant,\"Erreur de saisie !!!\",\"\"))","v":""}]
[null,null,"Y-a-t-il au sein de la famille un enfant handicapé (1/2 part en plus)",null,null,null,null,{"$f":"IF(AND(NbAdulte>0,EnfMDPH=\"\",NbEnfant>0),\"Saisie à effectuer !\",\"\")","v":""}]
[]
[]
[null,"ÉLÉMENTS POUR LE COÛT DE LA RESTAURATION"]
[]
[]
[null,null,{"$f":"\"Quel est le nombre d'enfant(s) présent(s) sur le temps méridien :\"","v":"Quel est le nombre d'enfant(s) présent(s) sur le temps méridien :"},null,null,null,null,{"$f":"IF(NbEnfENA<NbEnfTm,\"Erreur de saisie !!!\",\"\")","v":""}]
[null,null,{"$f":"\"Par déduction, nombre d'enfant\"&IF(NbEnfENA-NbEnfTm>1,\"s externes\",\" externe\")&\" (Repas pris à la maison) :\"","v":"Par déduction, nombre d'enfant externe (Repas pris à la maison) :"},null,null,null,null,{"$f":"IF(NbEnfENA=\"\",\"\",IF(NbEnfTm=\"\",\"\",IF(NbEnfENA-NbEnfTm<0,\"Nbre incohérent !!\",\"\")))","v":""},{"$f":"IF(NbEnfENA=\"\",\"\",IF(NbEnfTm=\"\",\"\",NbEnfENA-NbEnfTm))","v":""}]
[null,null,"Quel est le nombre d'enfant(s) prenant le repas du traiteur :",null,null,null,null,{"$f":"IF(AND(NbEnfTm>0,NbEnfRepas=\"\"),\"Saisie à effectuer !\",IF(NbEnfRepas>NbEnfTm,\"Erreur de saisie !!!\",\"\"))","v":""}]
[null,null,"Par déduction, nombre d'enfant(s) amenant leur repas de la maison) :",null,null,null,null,{"$f":"IF(NbEnfENA=\"\",\"\",IF(NbEnfTm=\"\",\"\",IF(NbEnfTm-NbEnfRepas<0,\"Nbre incohérent !!\",\"\")))","v":""},{"$f":"IF(NbEnfENA=\"\",\"\",IF(NbEnfTm=\"\",\"\",IF(NbEnfTm-NbEnfRepas<0,\"\",NbEnfTm-NbEnfRepas)))","v":""}]
[]
[]
[null,"ÉLÉMENTS POUR LE COÛT DU CENTRE DE LOISIRS"]
[]
[]
[null,null,{"$f":"IF(NbEnfENA>1,\"Les enfants fréquenteront-ils\",\"L'enfant fréquentera t-il\")&\" le Centre de Loisirs ?\"","v":"L'enfant fréquentera t-il le Centre de Loisirs ?"}]
[null,null,{"$f":"IF(NbEnfENA=0,IF(CacCLAE=TRUE,\"Manque la saisie du nombre d'enfant(s) qui fréquentera à l'École !!\",\"\"),IF(CacCLAE=FALSE,\"Pas de fréquentation du Centre de Loisirs\",\"En moyenne sur une semaine, \"&IF(NbEnfCL>1,\"chaque \",\"l'\")&\"enfant fréquentera le Centre de Loisirs :\"))","v":""}]
[null,null,"- Nombre de matin (1 unité) [sur 5 jours - de 8 h à 9 h avant la classe] :",null,null,null,null,{"$f":"IF(NbEnfENA=\"\",\"\",IF(AND(NbEnfCL>=1,I32=\"\",CacCLAE=TRUE),\"Saisie à effectuer !\",\"\"))","v":""}]
[null,null,"- Nombre de soir (2 unités) [sur 4 jours - de 16 h 15 à 18 h 20] :",null,null,null,null,{"$f":"IF(NbEnfENA=\"\",\"\",IF(AND(NbEnfCL>=1,I33=\"\",CacCLAE=TRUE),\"Saisie à effectuer !\",\"\"))","v":""}]
[null,null,"- Le mercredi midi (2 unités) [de 12 h à 13 h 30 après la classe] :",null,null,null,null,{"$f":"IF(NbEnfENA=\"\",\"\",IF(AND(NbEnfCL>=1,I34=\"\",CacCLAE=TRUE),\"Saisie à effectuer !\",\"\"))","v":""}]
[null,null,"    * Le repas du traiteur sera-t-il pris le midi ? ('non' = repas maison)",null,null,null,null,{"$f":"IF(NbEnfENA=\"\",\"\",IF(AND(NbEnfCL>=1,I35=\"\",CacCLAE=TRUE),\"Saisie à effectuer !\",\"\"))","v":""}]
[null,null,"- Le mercredi après-midi (5 unités) [de 13 h 30 à 18 h 20] :",null,null,null,null,{"$f":"IF(NbEnfENA=\"\",\"\",IF(AND(NbEnfCL>=1,I36=\"\",CacCLAE=TRUE),\"Saisie à effectuer !\",\"\"))","v":""}]
[]
[null,null,null,null,null,null,null,"Nombre d'unités à la semaine (par enfant) : ",{"$f":"IF(AND(I32=0,I33=0,I34=0,I36=0),\"---\",SUM(I32*1,I33*2,I34*2,I36*5))","v":"---"}]
[]
[]
[]
[null," CRPA - 4-6 Avenue d’Alembert – 92160 ANTONY "]
[null,"Téléphone 01 43 50 13 83 - Mél : inscription@ecolenouvelle.fr"]
[]
[null," SIRET 785 272 071 00016 - APE 801 Z "]

{"sheet":"Page 3 (Budget)","index":2,"n_rows":52,"n_cols":10,"rows_kept":52,"cut":false,"hidden":false,"merged":[[28,2,28,9],[0,3,0,9],[3,2,3,9],[8,2,8,9],[51,2,51,10]]}
[null,null,null,"CENTRE DE RECHERCHE DE PEDAGOGIE ACTIVE\nDENIS COUTROT"]
[]
[]
[null,null,"NOMBRE DE PARTS CALCULÉ ET BUDGET"]
[]
[null,null,null,"Nombre de Part Calculé : ",null,{"$f":"NbPart","v":""},null,null,"Ressources moins Charges : ",{"$f":"IF(ValForm=0,\"\",IF(TotalA=\"---\",\"Saisie Ress. !\",IF(TotalB=\"---\",\"Saisie Char. !\",IF(TotalA-TotalB<0,\"Erreur Saisie !\",TotalA-TotalB))))","v":""}]
[]
[]
[null,null,"A- RESSOURCES DE LA FAMILLE"]
[]
[null,null,null,null,null,null,null,"1er Responsable","2è Responsable","Autre Personne"]
[]
[]
[null,null,"  (Pour chaque personne mentionnée dans la famille)"]
[null,null,{"$f":"\"1- REVENU IMPOSABLE DE L'ANNÉE \"&LEFT(AnSN,4)-1","v":"1- REVENU IMPOSABLE DE L'ANNÉE 2022"}]
[null,null,{"$f":"\"   Tel que mentionné sur l'avis d'imposition du foyer établi en \"&LEFT(AnSN1,4)-1","v":"   Tel que mentionné sur l'avis d'imposition du foyer établi en 2023"}]
[null,null,"2- ALLOCATIONS FAMILIALES"]
[null,null,"   Versées par la CAF aux familles avec 2 enfants (fonction des ressources)"]
[null,null,"3- SUPPLÉMENT FAMILIAL"]
[null,null,"   Versé à un agent public qui a un enfant de moins de 20 ans."]
[null,null,"4- ALLOCATIONS DIVERSES"]
[null,null,"   Reçues de la part de votre employeur ou autre prestataire."]
[null,null,"5- PENSIONS"]
[null,null,"   Autres que celles figurant dans le reveu imposable…"]
[]
[null,null,null,null,null,null,null,null,"TOTAL A",{"$f":"IF(ValForm=0,\"---\",IF(SUM(H13:J25)=0,\"---\",SUM(H13:J25)))","v":"---"}]
[]
[]
[null,null,"B- CHARGES DE LA FAMILLE"]
[]
[null,null,null,null,null,null,null,"1er Responsable","2è Responsable","Autre Personne"]
[]
[]
[null,null,"  (Pour chaque personne mentionnée dans la famille)"]
[null,null,{"$f":"\"6- IMPÔT SUR LE REVENU NET \"&LEFT(AnSN,4)-1","v":"6- IMPÔT SUR LE REVENU NET 2022"}]
[null,null,{"$f":"\"   Tel que mentionné sur l'avis d'imposition \"&LEFT(AnSN,4)","v":"   Tel que mentionné sur l'avis d'imposition 2023"}]
[null,null,"7- FRAIS DE GARDE DES ENFANTS"]
[null,null,{"$f":"\"   Montant retenu sur l'avis d'imposition \"&LEFT(AnSN,4)","v":"   Montant retenu sur l'avis d'imposition 2023"}]
[null,null,"8- PENSIONS ALIMENTAIRES"]
[null,null,"   Versées à votre conjoint en cas de divorce ou de séparation."]
[null,null,"9- FRAIS DE SCOLARITÉ PAYES A L'ECOLE NOUVELLE"]
[null,null,{"$f":"\"   Montant de la scolarité payé en \"&AnSN","v":"   Montant de la scolarité payé en 2023/2024"}]
[null,null,{"$f":"\"   Déduction faite lors de la 2ème année scolaire.\"","v":"   Déduction faite lors de la 2ème année scolaire."}]
[]
[null,null,null,null,null,null,null,null,"TOTAL B",{"$f":"IF(ValForm=0,\"---\",IF(COUNTA(H35:J43)=0,\"---\",SUM(H35:J44)))","v":"---"}]
[]
[]
[]
[]
[]
[null,null," CRPA - 4-6 Avenue d’Alembert – 92160 ANTONY "]
[null,null,"Téléphone 01 43 50 13 83 - Mél : inscription@ecolenouvelle.fr"]

{"sheet":"Page 4 (Grilles)","index":3,"n_rows":43,"n_cols":12,"rows_kept":43,"cut":false,"hidden":false,"merged":[[42,1,42,10],[35,1,35,10],[37,6,37,7],[38,6,38,7],[25,2,25,7],[26,2,26,7],[27,2,27,7],[28,2,28,10],[30,1,30,10],[32,6,32,7],[33,6,33,7],[22,4,22,5],[23,4,23,5],[24,4,24,5],[22,2,22,3],[23,2,23,3],[24,2,24,3],[23,6,23,7],[22,6,22,7],[11,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[17,2,17,3],[18,2,18,3],[19,2,19,3],[20,2,20,3],[21,2,21,3],[20,4,20,5],[21,4,21,5],[20,6,20,7],[14,6,14,7],[11,4,11,7],[15,6,15,7],[21,6,21,7],[16,4,16,5],[17,4,17,5],[18,4,18,5],[19,4,19,5],[18,6,18,7],[19,6,19,7],[16,6,16,7],[17,6,17,7],[12,6,12,7],[13,4,13,5],[12,4,12,5],[11,8,11,10],[13,6,13,7],[24,6,24,7],[5,5,5,6],[0,3,0,10],[2,1,2,10],[3,1,3,10],[4,1,4,10],[5,1,6,3],[5,7,6,7],[6,8,6,9],[5,8,5,9],[5,10,6,10],[14,4,14,5],[15,4,15,5],[6,5,6,6]]}
[null,null,null,"CENTRE DE RECHERCHE DE PEDAGOGIE ACTIVE\nDENIS COUTROT"]
[]
[null,"GRILLE DES FRAIS DE SCOLARITE"]
[null,"A L'ÉCOLE NOUVELLE D'ANTONY"]
[]
[null,"Quotient Familial (QF) =  ",null,null,null,"TOTAL A - TOTAL B",null,{"$f":"IF(ValResCha=1,\"=\",\"\")","v":""},{"$f":"IF(ValResCha=1,TotalA&\" (A)\"&\" - \"&TotalB&\" (B)\",\"\")","v":""},null,{"$f":"IF(ValResCha=1,\" = \"&QF,\"\")","v":""}]
[null,null,null,null,null,"Nombre de Parts",null,null,{"$f":"IF(ValResCha=1,NbPart&\" (Nombre de Parts)\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ValResCha=1,\"Tranche (à confirmer) : \"&Tranche&\"  \",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ValResCha=1,\"Tarif de la scolarité annuelle (à confirmer) pour \"&NbEnfENA&\" Enfant\"&IF(NbEnfENA>1,\"s\",\"\")&\" : \"&ROUND(CoutSco*CoeffSco,0)&\" €   \",\" \")","v":" "}]
[]
[null,{"$f":"\"ESTIMATION  : ANNÉE SCOLAIRE \"&AnSN1","v":"ESTIMATION  : ANNÉE SCOLAIRE 2024/2025"}]
[null,null,"TRANCHE",null,"QUOTIENT FAMILIAL (QF)",null,null,null,"TARIF",null,null," "]
[null,null,null,null,"Mini",null,"Maxi",null,"(Annuel)","(En 3 Fois)","(En 10 Fois)"]
[null,null,"A",null,{"$f":"Donnees!Q28","v":" De 1 €   "},null,{"$f":"Donnees!R28","v":4685},null,{"$f":"ROUND(J14*3,0)","v":585},{"$f":"Donnees!T28","v":195},{"$f":"ROUND(3*J14/10,1)","v":58.5}]
[null,null,"B",null,{"$f":"Donnees!Q29","v":4686},null,{"$f":"Donnees!R29","v":5691},null,{"$f":"ROUND(J15*3,0)","v":834},{"$f":"Donnees!T29","v":278},{"$f":"ROUND(3*J15/10,1)","v":83.4}]
[null,null,"C",null,{"$f":"Donnees!Q30","v":5692},null,{"$f":"Donnees!R30","v":6837},null,1116,{"$f":"Donnees!T30","v":372},111.6]
[null,null,"D",null,{"$f":"Donnees!Q31","v":6838},null,{"$f":"Donnees!R31","v":7984},null,1398,{"$f":"Donnees!T31","v":466},139.80000000000001]
[null,null,"E",null,{"$f":"Donnees!Q32","v":7985},null,{"$f":"Donnees!R32","v":9117},null,1701,{"$f":"Donnees!T32","v":567},170.1]
[null,null,"F",null,{"$f":"Donnees!Q33","v":9118},null,{"$f":"Donnees!R33","v":10740},null,1980,{"$f":"Donnees!T33","v":660},198]
[null,null,"G",null,{"$f":"Donnees!Q34","v":10741},null,{"$f":"Donnees!R34","v":12483},null,2355,{"$f":"Donnees!T34","v":785},235.5]
[null,null,"H",null,{"$f":"Donnees!Q35","v":12484},null,{"$f":"Donnees!R35","v":14597},null,2637,{"$f":"Donnees!T35","v":879},263.7]
[null,null,"I",null,{"$f":"Donnees!Q36","v":14598},null,{"$f":"Donnees!R36","v":17050},null,2991,{"$f":"Donnees!T36","v":997},299.10000000000002]
[null,null,"J",null,{"$f":"Donnees!Q37","v":17051},null,{"$f":"Donnees!R37","v":20070},null,3396,{"$f":"Donnees!T37","v":1132},339.6]
[null,null,"K",null,{"$f":"Donnees!Q38","v":20071},null,{"$f":"Donnees!R38","v":23421},null,3708,{"$f":"Donnees!T38","v":1236},370.8]
[null,null,"L",null,{"$f":"Donnees!Q39","v":"Plus de 23 421 €"},null,null,null,4128,{"$f":"Donnees!T39","v":1376},412.8]
[null,null," Prix de la Restauration Scolaire",null,null,null,null,null,1314,{"$f":"Donnees!T40","v":438},131.4]
[null,null," Ou de la Surveillance du Repas uniquement",null,null,null,null,null,606,{"$f":"Donnees!T41","v":202},60.6]
[null,null," Fournitures Pédagogiques",null,null,null,null,null,63,{"$f":"Donnees!T42","v":21},6.3]
[null,null,"Nota : Le prix de la scolarité indiqué pour les QF A à L est le coût pour un enfant inscrit à l’École. Pour deux enfants inscrits à l’École, le prix de la scolarité pour le 2ème enfant est réduit de 20 %. Pour trois enfants ou plus, le prix de la scolarité est réduit de 30 % par enfant à partir du 3ème."]
[]
[null,"MONTANT DE L'UNITE DU CENTRE DE LOISIRS EN FONCTION DU QF"]
[]
[null,null,null,"REPAS",null,"QF : A","QF : B à D",null,"QF : E à H","QF I à K","QF : L"]
[null,null,null,{"$f":"PrixRepasCL","v":4.8500000000000005},null,{"$f":"Donnees!B74","v":2.73},{"$f":"Donnees!C74","v":2.79},null,{"$f":"Donnees!F74","v":2.85},{"$f":"Donnees!J74","v":2.91},{"$f":"Donnees!M74","v":2.97}]
[]
[null,"REDUCTION : FONCTION DES UNITES CONSOMMEES A LA SEMAINE"]
[]
[null,null,null,null,null,"1 à 4",5,null,"6 à 11","12 à 16","17 à 20"]
[null,null,null,null,null,"----",{"$f":"Donnees!L55","v":0.19},null,{"$f":"Donnees!L56","v":0.23},{"$f":"Donnees!L61","v":0.3},{"$f":"Donnees!L66","v":0.36}]
[]
[]
[null," CRPA - 4-6 Avenue d’Alembert – 92160 ANTONY "]
[null,"Téléphone 01 43 50 13 83 - Mél : inscription@ecolenouvelle.fr"]

{"sheet":"Page 5 (Synthese)","index":4,"n_rows":49,"n_cols":11,"rows_kept":49,"cut":false,"hidden":false,"merged":[[48,1,48,10],[0,3,0,10],[2,1,2,10],[3,1,3,10],[4,1,4,10],[13,8,14,8],[13,9,14,9],[13,10,14,10],[24,8,25,8],[24,9,25,9],[24,10,25,10],[39,9,40,9],[39,10,40,10]]}
[null,null,null,"CENTRE DE RECHERCHE DE PEDAGOGIE ACTIVE\nDENIS COUTROT"]
[]
[null,"ESTIMATION DU MONTANT ANNUEL DES FRAIS LIÉS"]
[null,"A LA SCOLARISATION A L'ÉCOLE NOUVELLE D'ANTONY"]
[]
[]
[null,"SYNTHESE DES RENSEIGNEMENTS"]
[null,null,{"$f":"IF(ValResCha=0,\"\",\"- Famille\"&IF(FamilleMonoP=\"Oui\",\" monoparentale\",\"\")&\" composée de \"&NbAdulte&IF(NbAdulte>1,\" adultes\",\" adulte\")&\" et de \"&NbEnfant&IF(NbEnfant>1,\" enfants\",\" enfant\")&IF(EnfMDPH=\"Oui\",\" dont un enfant est handicapé.\",\".\"))","v":""}]
[null,null,{"$f":"IF(ValResCha=0,\"\",\"- \"&NbEnfENA&\" enfant\"&IF(NbEnfENA>1,\"s seront scolarisés\",\" sera scolarisé\")&\" à l'École Nouvelle d'Antony.\")","v":""}]
[]
[null,"AU NIVEAU DE LA SCOLARITÉ"]
[null,null,{"$f":"IF(ValResCha=0,\"\",\"- Nombre de parts calculé : \"&NbPart)","v":""}]
[null,null,{"$f":"IF(ValResCha=0,\"\",\"- Ressources de la famille : \"&TotalA&\" € - Charges de la famille : \"&TotalB&\" € - 'Budget' : \"&TotalA-TotalB&\" €.\")","v":""}]
[null,null,{"$f":"IF(ValResCha=0,\"\",\"- Quotient Familial = \"&ROUND((TotalA-TotalB)/NbPart,0)&\" €, d'où Tranche QF = \"&Donnees!D14)","v":""},null,null,null,null,null,"Annuel","En 3 Fois","En 10 Fois"]
[]
[null,null,{"$f":"IF(ValResCha=0,\"\",\"* Fournitures Pédagogiques : \")","v":""},null,null,null,null,null,{"$f":"IF(ValResCha=0,\"\",FourPeda*NbEnfENA)","v":""},{"$f":"IF(ValResCha=0,\"\",I16/3)","v":""},{"$f":"IF(ValResCha=0,\"\",I16/10)","v":""}]
[null,null,{"$f":"IF(ValResCha=0,\"\",\"* Scolarité du 1er enfant :\")","v":""},null,null,null,null,null,{"$f":"IF(ValResCha=0,\"\",CoutSco)","v":""},{"$f":"IF(ValResCha=0,\"\",I17/3)","v":""},{"$f":"IF(ValResCha=0,\"\",I17/10)","v":""}]
[null,null,{"$f":"IF(ValResCha=0,\"\",IF(NbEnfENA<=1,\"\",\"* Scolarité du 2ème enfant (20% de réduction) :\"))","v":""},null,null,null,null,null,{"$f":"IF($C18<>\"\",ROUND(I17*0.8,0),\"\")","v":""},{"$f":"IF($C18<>\"\",ROUND(J17*0.8,0),\"\")","v":""},{"$f":"IF($C18<>\"\",I18/10,\"\")","v":""}]
[null,null,{"$f":"IF(ValResCha=0,\"\",IF(NbEnfENA<=2,\"\",\"* Scolarité du 3ème enfant (30% de réduction) :\"))","v":""},null,null,null,null,null,{"$f":"IF($C19<>\"\",ROUND(I17*0.7,0),\"\")","v":""},{"$f":"IF($C19<>\"\",ROUND(J17*0.7,0),\"\")","v":""},{"$f":"IF($C19<>\"\",I19/10,\"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(ValResCha=1,SUM(I16:I19),\"\")","v":""},{"$f":"IF(ValResCha=1,SUM(J16:J19),\"\")","v":""},{"$f":"IF(ValResCha=1,SUM(K16:K19),\"\")","v":""}]
[]
[null,"AU NIVEAU DE LA RESTAURATION SCOLAIRE"]
[null,null,{"$f":"IF(ValResCha=0,\"\",\"- Nombre d'enfants externes : \"&NbEnfExt)","v":""}]
[null,null,{"$f":"IF(ValResCha=0,\"\",\"- Nombre d'enfant\"&IF(NbEnfRepas>1,\"s\",\"\")&\" demi-pensionnaire\"&IF(NbEnfRepas>1,\"s\",\"\")&\" (repas du traiteur) : \"&NbEnfRepas)","v":""}]
[null,null,{"$f":"IF(ValResCha=0,\"\",\"- Nombre d'enfant\"&IF(NbEnfRepasM>1,\"s\",\"\")&\" amenant leur repas : \"&NbEnfRepasM)","v":""},null,null,null,null,null,"Annuel","En 3 Fois","En 10 Fois"]
[]
[null,null,{"$f":"IF(ValResCha=0,\"\",\"* Frais demi-pensionnaires (repas du traiteur) : \")","v":""},null,null,null,null,null,{"$f":"IF(ValResCha=0,\"\",IF(NbEnfRepas=0,\"---\",Donnees!S40*NbEnfRepas))","v":""},{"$f":"IF(ValResCha=0,\"\",IF(I27=\"---\",\"---\",I27/3))","v":""},{"$f":"IF(ValResCha=0,\"\",IF(I27=\"---\",\"---\",I27/10))","v":""}]
[null,null,{"$f":"IF(ValResCha=0,\"\",\"* Frais de surveillance (repas de la maison) : \")","v":""},null,null,null,null,null,{"$f":"IF(ValResCha=0,\"\",IF(OR(NbEnfRepasM=0,NbEnfRepasM=\"---\"),\"---\",Donnees!S41*NbEnfRepasM))","v":""},{"$f":"IF(ValResCha=0,\"\",IF(I28=\"---\",\"---\",I28/3))","v":""},{"$f":"IF(ValResCha=0,\"\",IF(I28=\"---\",\"---\",I28/10))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(ValResCha=1,SUM(I27:I28),\"\")","v":""},{"$f":"IF(ValResCha=1,SUM(J27:J28),\"\")","v":""},{"$f":"IF(ValResCha=1,SUM(K27:K28),\"\")","v":""}]
[]
[null,"BUDGET ANNUEL POUR L'ECOLE"]
[null,null,null,null,null,null,null,null,"Annuel","En 3 Fois","En 10 Fois"]
[null,null,null,null,null,null,null,null,{"$f":"IF(ValResCha=0,\"\",I29+I20)","v":""},{"$f":"IF(ValResCha=0,\"\",J29+J20)","v":""},{"$f":"IF(ValResCha=0,\"\",K29+K20)","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(ValResCha=0,\"\",\"Paiement par chèque ou virement bancaire en Octobre \"&LEFT(AnSN1,4)&\", Janvier et Avril \"&RIGHT(AnSN1,4)&\".\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ValResCha=0,\"\",\"Paiement par prélèvement automatique (le 8 du mois) entre Octobre \"&LEFT(AnSN1,4)&\" et Juillet \"&RIGHT(AnSN1,4)&\".\")","v":""}]
[]
[null,"BUDGET ANNUEL POUR LE CENTRE DE LOISIRS"]
[null,null,{"$f":"IF(ValResCha=0,\"\",IF(NbEnfCL=0,\"Pas de Fréquentation du Centre de Loisirs\",\"- Nombre d'enfant\"&(IF(NbEnfCL>1,\"s\",\"\")&\" fréquentant le Centre de Loisirs : \"&NbEnfCL&\" - Prix de l'unité lié au QF : \"&TEXT(PxUFam,\"#,00\")&\" €.\")))","v":""}]
[null,null,{"$f":"IF(ValResCha=0,\"\",IF(NbEnfCL=0,\"\",\"- Unité\"&IF(NbUSem>1,\"s consommées\",\" consommée\")&\" sur une semaine [par enfant] : \"&NbUSem&\" - Réduction : \"&PourCentReduc*100&\" %.\"))","v":""}]
[null,null,{"$f":"IF(ValResCha=0,\"\",IF(NbEnfCL=0,\"\",IF(RepasCL=\"Non\",\"- Pas de repas du traiteur pris au Centre de Loisirs.\",\"- Repas du traiteur pris au Centre de Loisirs.\")))","v":""},null,null,null,null,null,null,"Repas","Présence"]
[]
[null,null,{"$f":"IF(ValResCha=0,\"\",IF(NbEnfCL=0,\"\",\"* Coût de Septembre à Décembre \"&LEFT(AnSN1,4)&\" [2 périodes - 7+7 semaines] :\"))","v":""},null,null,null,null,null,null,{"$f":"IF(ValResCha=0,\"\",IF(RepasCL=\"Oui\",14*PrixRepasCL*NbEnfCL,\"---\"))","v":""},{"$f":"IF(ValResCha=0,\"\",IF(NbEnfCL>0,NbUSem*NbEnfCL*14*PxUFam*(1-PourCentReduc),\"---\"))","v":""}]
[null,null,{"$f":"IF(ValResCha=0,\"\",IF(NbEnfCL=0,\"\",\"* Coût de Janvier à Avril \"&RIGHT(AnSN1,4)&\" [2 périodes - 7+6 semaines] :\"))","v":""},null,null,null,null,null,null,{"$f":"IF(ValResCha=0,\"\",IF(RepasCL=\"Oui\",13*NbEnfCL*PrixRepasCL,\"---\"))","v":""},{"$f":"IF(ValResCha=0,\"\",IF(NbEnfCL>0,NbUSem*NbEnfCL*13*PxUFam*(1-PourCentReduc),\"---\"))","v":""}]
[null,null,{"$f":"IF(ValResCha=0,\"\",IF(NbEnfCL=0,\"\",\"* Coût d'Avril à Juillet \"&RIGHT(AnSN1,4)&\" [1 période - 9 semaines] :\"))","v":""},null,null,null,null,null,null,{"$f":"IF(ValResCha=0,\"\",IF(RepasCL=\"Oui\",9*NbEnfCL*PrixRepasCL,\"---\"))","v":""},{"$f":"IF(ValResCha=0,\"\",IF(NbEnfCL>0,NbUSem*NbEnfCL*9*PxUFam*(1-PourCentReduc),\"---\"))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ValResCha=0,\"\",IF(J45>0,\"Budget Total Annuel Prévisionnel : \",\"Budget Annuel Prévisionnel : \"))","v":""},{"$f":"IF(ValResCha=0,\"\",IF(J45<>0,J45+K45,\"\"))","v":""},{"$f":"IF(ValResCha=1,SUM(J42:J44),\"\")","v":""},{"$f":"IF(ValResCha=1,SUM(K42:K44),\"\")","v":""}]
[]
[]
[null," CRPA - 4-6 Avenue d’Alembert – 92160 ANTONY "]
[null,"Téléphone 01 43 50 13 83 - Mél : inscription@ecolenouvelle.fr"]

{"sheet":"Donnees","index":5,"n_rows":103,"n_cols":25,"rows_kept":103,"cut":false,"hidden":true,"merged":[[52,1,52,2],[52,3,52,4],[53,3,53,4],[61,3,61,4],[52,9,52,10],[52,11,52,12],[53,11,53,12],[61,11,61,12],[66,11,66,12],[54,11,54,12],[55,11,55,12],[56,11,56,12],[57,11,57,12],[60,11,60,12],[66,3,66,4],[55,3,55,4],[56,3,56,4],[57,3,57,4],[54,3,54,4],[58,11,58,12],[62,3,62,4],[60,3,60,4],[58,3,58,4],[63,3,63,4],[6,3,6,4],[13,3,13,4],[14,3,14,4],[16,3,16,4],[7,3,7,4],[8,3,8,4],[10,3,10,4],[11,3,11,4],[12,3,12,4],[1,22,1,23],[0,24,1,24],[2,6,2,9],[3,6,3,9],[0,17,1,17],[2,3,2,4],[3,3,3,4],[4,3,4,4],[5,3,5,4],[25,16,25,17],[25,18,25,20],[25,10,25,12],[39,15,39,17],[5,12,5,14],[0,15,1,15],[25,15,26,15],[28,7,28,8],[29,7,29,8],[25,7,25,9],[26,7,26,8],[27,7,27,8],[1,20,2,21],[10,17,16,19],[41,15,41,17],[45,18,45,20],[45,15,46,15],[45,16,45,17],[42,15,42,17],[40,15,40,17],[30,7,30,8],[31,7,31,8],[32,7,32,8],[33,7,33,8],[34,7,34,8],[35,7,35,8],[36,7,36,8],[37,7,37,8],[38,7,38,8],[100,15,100,17],[101,15,101,17],[75,6,77,12],[102,15,102,17],[82,15,82,17],[85,15,86,15],[85,16,85,17],[85,18,85,20],[99,15,99,17],[79,15,79,17],[80,15,80,17],[81,15,81,17],[65,15,66,15],[65,16,65,17],[65,18,65,20],[59,15,59,17],[60,15,60,17],[61,15,61,17],[62,15,62,17],[67,11,67,12],[68,11,68,12],[63,11,63,12],[64,11,64,12],[65,11,65,12],[59,11,59,12],[62,11,62,12],[67,3,67,4],[68,3,68,4],[17,3,17,4],[31,5,31,6],[32,5,32,6],[33,5,33,6],[34,5,34,6],[35,5,35,6],[36,5,36,6],[37,5,37,6],[38,5,38,6],[21,3,21,4],[18,3,18,4],[22,3,22,4],[25,5,26,6],[28,5,28,6],[29,5,29,6],[30,5,30,6],[27,5,27,6],[19,3,19,4],[20,3,20,4],[64,3,64,4],[65,3,65,4],[59,3,59,4]]}
["Données Récupérées des SAISIES dans les FEUILLES",null,null,null,null,null,null,null,null,"(Fichier et Macros : Version du 07/11/2023)",null,null,null,null,null,{"$f":"AnSN","v":"2023/2024"},null,{"$f":"AnSN1","v":"2024/2025"},null,null,null,null,null,null,"% Aug. Sur 1 an"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W35/W23-1","v":2.8308036129993441E-2},"Variation Indice Insee (Contrat API)\n{Connus au 1er Septembre}",null,"Indice 1762316"]
["Nb. d'Enfants à l'ENA : ",null,null,{"$f":"NbEnfENA","v":0},null,null,"Cellule sur fond Jaune = Saisie",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,102.94,"2021-01-01"]
["Coeff. Coût Scolarité",null,null,{"$f":"CHOOSE(NbEnfENA,1,1.8,2.5,3.2)","v":{"$error":"#VALUE!"}},null,null,"Cellule sur Fond Bleu = Calcul",null,null,null,null,null,null,null,"Indice INSEE Cantines (001762316)",{"$f":"W23","v":107.39},"(09/2022)",{"$f":"W35","v":110.43},"(09/2023)","INSEE Indice Cantine (Contrat API)",null,null,99.2,"2021-02-01"]
["Nombre Enfants :",null,null,{"$f":"IF(NbEnfant<>\"\",NbEnfant,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,99.27,"2021-03-01"]
["Nombre Adultes",null,null,{"$f":"NbAdulte","v":0},null,null,"Formulaire Valide ??",null,null,{"$f":"IF(AND(NbEnfant>0,NbAdulte>0,NbEnfENA>0,EnfMDPH<>\"\",FamilleMonoP<>\"\",NbEnfTm<>\"\",NbEnfRepas<>\"\"),1,0)","v":0},"(0 = Non)",null,"Prix du Repas : ",null,null,4.7699999999999996,"(Par Jour)",{"$f":"ROUNDUP((P6*R4/P4),2)","v":4.91},"(Par Jour)",null,null,null,99.42,"2021-04-01"]
["Dont Enfant Handicap",null,null,{"$f":"IF(EnfMDPH<>\"\",EnfMDPH,\"\")","v":""},null,null,"Saisie Complète CLAE ??",null,null,{"$f":"IF(AND('Page 2 (Renseignements)'!I32<>\"\",'Page 2 (Renseignements)'!I33<>\"\",'Page 2 (Renseignements)'!I34<>\"\",RepasCL<>\"\",'Page 2 (Renseignements)'!I36<>\"\",ValForm=1),1,0)","v":0},"(0 = Non)",null,null,null,"Prix du Pain : ",null,"(Par Jour)",null,"(Par Jour)",null,null,null,99.28,"2021-05-01"]
["Adulte Isolé",null,null,{"$f":"IF(FamilleMonoP<>\"\",FamilleMonoP,\"\")","v":""},null,null,"Case à Cocher CLAE :",null,null,false,"(VRAI=Cochée)",null,null,null,"Total --> ",{"$f":"SUM(P6:P7)","v":4.7699999999999996},null,{"$f":"SUM(R6:R7)","v":4.91},"(Repas sur 36 semaines et 4 jours / semaine)",null,null,null,99.48,"2021-06-01"]
["Nombre de Part",null,null,{"$f":"IF(ValForm=1,NbEnfant+NbAdulte+IF(EnfMDPH=\"Oui\",0.5,0)+IF(FamilleMonoP=\"Oui\",0.5,0),\"\")","v":""},null,null,"Saisie Ress./Charges :",null,null,{"$f":"IF(ValForm=0,0,IF(OR(TotalA=\"---\",TotalB=\"---\"),0,IF(TotalA-TotalB<=0,0,1)))","v":0},"(0 = Non)",null,null,null,"Prix Restauration :",{"$f":"ROUNDUP(P8*36*4,0)","v":687},"(Par Année)",{"$f":"ROUNDUP($R$8*36*4,0)*$U$11","v":708},"(Par Année)",null,null,null,99.43,"2021-07-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attention : ",null,null,null,null,99.57,"2021-08-01"]
["Total Ressources",null,null,{"$f":"TotalA","v":"---"},null,null,null,null,null,null,null,null,null,null,"Prix Restauration ",{"$f":"P9/3","v":229},"(En 3 Fois)","Si montant ci-dessus (par année) est forcé à 0 (cellule U11 à droite égale = 0) , indexation prix du repas (avec pain) sur Indice INSEE (cellule P19 = Coût de la vie) pour Année scolaire N+1 sinon prise en compte indice INSEE des cantines (contrat API).",null,null,1,null,105.02,"2021-09-01"]
["Total Charges",null,null,{"$f":"TotalB","v":"---"},null,null,null,null,null,null,null,null,null,null,"Prix Restauration ",{"$f":"ROUND(P11*3/10,1)","v":68.7},"(En 10 Fois)",null,null,null,null,null,105.19,"2021-10-01"]
["QF =",null,null,{"$f":"IF(AND(ValForm=1,ValResCha=1),ROUND((TotalA-TotalB)/NbPart,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,105.33,"2021-11-01"]
["Tranche = ",null,null,{"$f":"IF(ISERROR(MATCH(D13-1,R28:R39,1))=TRUE,\"A\",CHAR(MATCH(D13-1,R28:R39,1)+65))","v":"A"},null,null,null,null,null,null,null,null,null,null,"Prix Surveillance : ",{"$f":"196*3","v":588},"(Par Année)",null,null,null,null,null,105.31,"2021-12-01"]
["Scolarité = ",null,null,{"$f":"IF(ISERROR(MATCH(D13-1,R28:R39,1))=TRUE,S28,VLOOKUP(Tranche,P28:S39,4,0))","v":585},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,105.53,"2022-01-01",{"$f":"W15/W3-1","v":2.5160287546143412E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Surveillance & Repas",{"$f":"ROUND((P14+P9)/3,0)","v":425},"(En 3 Fois)",null,null,null,null,null,105.39,"2022-02-01",{"$f":"W16/W4-1","v":6.2399193548386966E-2}]
[{"$f":"\"Unité CLAE (\"&AnSN&\")\"","v":"Unité CLAE (2023/2024)"},null,null,{"$f":"Uclae","v":2.75},null,"QF=E",null,null,null,null,null,null,null,null,"Surveillance & Repas",{"$f":"ROUND(P16*3/10,1)","v":127.5},"(En 10 Fois)",null,null,null,null,null,105.76,"2022-03-01",6.537725395386329E-2]
[{"$f":"\"Unité CLAE (\"&AnSN1&\")\"","v":"Unité CLAE (2024/2025)"},null,null,{"$f":"F74","v":2.85},null,"QF=E",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,105.71,"2022-04-01",6.326694830014068E-2]
[{"$f":"\"Unité CLAE Famille : \"","v":"Unité CLAE Famille : "},null,null,{"$f":"HLOOKUP(Tranche,TabQF,2,0)","v":2.73},null,null,null,null,null,null,null,null,null,null,"Variation Taux INSEE IPC 6537535 (Prix à la consommation) ",3,"(en %)",null,null,null,null,null,105.74,"2022-05-01",6.5068493150684859E-2]
["Nb Enfants au CLAE",null,null,{"$f":"NbEnfCL","v":0},null,null,null,null,null,null,null,null,null,null,"(Sur un an, au mois de Avril --> Voir RI)",null,null,null,null,null,null,null,105.71,"2022-06-01",6.262565339766768E-2]
["Moyenne Unités / Semaine",null,null,{"$f":"IF(NbUSem<>\"\",NbUSem,\"\")","v":"---"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,105.95,"2022-07-01",6.5573770491803129E-2]
["Repas pris au CLAE",null,null,{"$f":"PxRepasCL","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,106.07,"2022-08-01",{"$f":"W22/W10-1","v":6.5280707040273223E-2}]
["Réduction CLAE",null,null,{"$f":"IF(NbUSem<=4,VLOOKUP(4,TabReduc,2,1),VLOOKUP(NbUSem,TabReduc,2,1))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,107.39,"2022-09-01",{"$f":"W23/W11-1","v":2.2567130070462849E-2}]
[null,null,null,null,null,null,null,null,"ANNÉE SCOLAIRE (N) ","2023/2024",null,null,null,null,null,null,"ANNÉE SCOLAIRE (N+1) ",{"$f":"LEFT(J24,4)+1&\"/\"&RIGHT(J24,4)+1","v":"2024/2025"},null,null,null,null,107.7,"2022-10-01",2.3861583800741659E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,107.7,"2022-11-01",2.2500712047849758E-2]
[null,null,null,null,null,"TRANCHE",null,"QUOTIENT FAMILIAL (QF)",null,null,"TARIF",null,null,null,null,"TRANCHE","QUOTIENT FAMILIAL (QF)",null,"TARIF UN (1) ENFANT",null,null,null,107.74,"2022-12-01",2.3074731744373578E-2]
[null,null,null,null,null,null,null,"Mini",null,"Maxi","(Annuel)","(En 3 F.)","(En 10 F.)",null,null,null,"Mini","Maxi","(Annuel)","(En 3 Fois)","(En 10 Fois)",null,108.51,"2023-01-01",{"$f":"W27/W15-1","v":2.8238415616412382E-2}]
[null,null,null,null,null,"A",null," De 1 €   ",null,4549,{"$f":"L28*3","v":567},189,{"$f":"ROUND(L28*3/10,1)","v":56.7},null,null,"A"," De 1 €   ",{"$f":"ROUND(J28*(1+Taux_INSEE/100),0)","v":4685},{"$f":"ROUND(T28*3,0)","v":585},{"$f":"ROUND(L28*(1+Taux_INSEE/100),0)","v":195},{"$f":"ROUND(T28*3/10,1)","v":58.5},null,108.57,"2023-02-01",{"$f":"W28/W16-1","v":3.017364076288076E-2}]
[null,null,null,null,null,"B",null,{"$f":"J28+1","v":4550},null,5525,{"$f":"L29*3","v":810},270,81,null,null,"B",{"$f":"R28+1","v":4686},5691,{"$f":"ROUND(T29*3,0)","v":834},278,{"$f":"ROUND(T29*3/10,1)","v":83.4},null,108.66,"2023-03-01",2.7420574886535487E-2]
[null,null,null,null,null,"C",null,5526,null,6638,{"$f":"L30*3","v":1083},361,108.3,null,null,"C",{"$f":"R29+1","v":5692},6837,1116,372,111.6,null,108.77,"2023-04-01",2.8947119477816585E-2]
[null,null,null,null,null,"D",null,6639,null,7751,{"$f":"L31*3","v":1356},452,135.6,null,null,"D",6838,7984,1398,466,139.80000000000001,null,108.92,"2023-05-01",3.0073765840741506E-2]
[null,null,null,null,null,"E",null,7752,null,8851,{"$f":"L32*3","v":1650},550,165,null,null,"E",7985,9117,1701,567,170.1,null,109.12,"2023-06-01",3.2258064516129226E-2]
[null,null,null,null,null,"F",null,8852,null,10427,{"$f":"L33*3","v":1923},641,192.3,null,null,"F",9118,10740,1980,660,198,null,109.26,"2023-07-01",3.1241151486550267E-2]
[null,null,null,null,null,"G",null,10428,null,12119,2286,762,228.6,null,null,"G",10741,12483,2355,785,235.5,null,109.55,"2023-08-01",{"$f":"W34/W22-1","v":3.2808522673706042E-2}]
[null,null,null,null,null,"H",null,12120,null,14172,2559,853,255.9,null,null,"H",12484,14597,2637,879,263.7,null,110.43,"2023-09-01",{"$f":"W35/W23-1","v":2.8308036129993441E-2}]
[null,null,null,null,null,"I",null,14173,null,16553,2904,968,290.39999999999998,null,null,"I",14598,17050,2991,997,299.10000000000002]
[null,null,null,null,null,"J",null,16554,null,19485,3297,1099,329.7,null,null,"J",17051,20070,3396,1132,339.6]
[null,null,null,null,null,"K",null,19486,null,22739,3600,1200,360,null,null,"K",20071,23421,3708,1236,370.8]
[null,null,null,null,null,"L",null,{"$f":"\"> \"&J38&\" €\"","v":"> 22739 €"},null,null,4008,1336,400.8,null,null,"L",{"$f":"\"Plus de \"&TEXT(R38,\"## ##0\")&\" €\"","v":"Plus de 23 421 €"},null,4128,1376,412.8]
[null,null,null,null,null,"Prix de la restauration scolaire",null,null,null,null,{"$f":"L40*3","v":1275},{"$f":"ROUNDUP(P11+P14/3,2)","v":425},127.5,null,null,"Prix de la restauration scolaire",null,null,{"$f":"ROUND(T40*3,0)","v":1314},{"$f":"IF($R$9=0,ROUND(L40*(1+Taux_INSEE/100),0),ROUNDUP(R8*36*4/3+T41,0))","v":438},{"$f":"ROUND(T40*3/10,1)","v":131.4}]
[null,null,null,null,null,"Ou de la Surveillance du Repas seule",null,null,null,null,{"$f":"L41*3","v":588},{"$f":"P14/3","v":196},58.8,null,null,"Ou de la Surveillance du Repas seule",null,null,606,{"$f":"ROUNDUP(L41*(1+Taux_INSEE/100),0)","v":202},60.6]
[null,null,null,null,null,"Fournitures Pédagogiques",null,null,null,null,{"$f":"L42*3","v":60},20,6,null,null,"Fournitures Pédagogiques",null,null,63,{"$f":"ROUNDUP(L42*(1+Taux_INSEE/100),0)","v":21},6.3]
[null,null,null,null,null,"Prix de la restauration scolaire (seule)",null,null,null,null,{"$f":"L43*3","v":687},{"$f":"L40-L41","v":229},{"$f":"M40-M41","v":68.7},null,null,"Prix de la restauration scolaire (seule)",null,null,{"$f":"ROUND(T43*3,0)","v":708},{"$f":"T40-T41","v":236},{"$f":"U40-U41","v":70.800000000000011}]
[]
[]
[null,null,null,null,null,null,null,null,"TARIFS CLAE - ANNEE SCOLAIRE (N)",{"$f":"AnSN","v":"2023/2024"},null,null,null,null,null,"TRANCHE","QUOTIENT FAMILIAL (QF)",null,"TARIF DEUX (2) ENFANTS"]
[null,null,null,null,null,null,null,null,null,null,null,"Ecart",0.05,null,null,null,"Mini","Maxi","(Annuel)","(En 3 Fois)","(En 10 Fois)"]
[null,"A","B","C","D","E","F","G","H","I","J","K","L",null,null,"A"," De 1 €   ",{"$f":"R28","v":4685},{"$f":"ROUND(T48*3,0)","v":1053},{"$f":"ROUND(T28*(100%+80%),0)","v":351},{"$f":"ROUND(T48*3/10,1)","v":105.3}]
[null,{"$f":"C49-Ecart","v":2.6500000000000004},{"$f":"D49","v":2.7},{"$f":"E49","v":2.7},{"$f":"F49-Ecart","v":2.7},2.75,{"$f":"F49","v":2.75},{"$f":"G49","v":2.75},{"$f":"H49","v":2.75},{"$f":"I49+Ecart","v":2.8},{"$f":"J49","v":2.8},{"$f":"K49","v":2.8},{"$f":"L49+Ecart","v":2.8499999999999996},null,null,"B",{"$f":"R48+1","v":4686},{"$f":"R29","v":5691},{"$f":"ROUND(T49*3,0)","v":1500},{"$f":"ROUND(T29*(100%+80%),0)","v":500},{"$f":"ROUND(T49*3/10,1)","v":150}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C",{"$f":"R49+1","v":5692},6837,2010,670,201]
[null,null,null,"% DE REDUCTION ",{"$f":"AnSN","v":"2023/2024"},null,null,"REPAS MERCREDI",null,null,"% DE REDUCTION ",{"$f":"AnSN1","v":"2024/2025"},null,null,null,"D",6838,7984,2517,839,251.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E",7985,9117,3063,1021,306.3]
[null,"Unités",null,"Réduc.",null,null,null,{"$f":"AnSN","v":"2023/2024"},null,"Unités",null,"Réduc.",null,null,null,"F",9118,10740,3564,1188,356.4]
[null,0,4,0,null,null,null,4.6900000000000004,null,{"$f":"B54","v":0},{"$f":"C54","v":4},{"$f":"D54","v":0},null,null,null,"G",10741,12483,4239,1413,423.9]
[null,5,5,0.19,null,null,null,null,null,5,5,0.19,null,null,null,"H",12484,14597,4746,1582,474.6]
[null,6,6,0.23,null,null,null,{"$f":"AnSN1","v":"2024/2025"},null,6,6,0.23,null,null,null,"I",14598,17050,5385,1795,538.5]
[null,6,7,0.23,null,null,null,{"$f":"MROUND(H54*(100+Taux_INSEE)/100,0.05)","v":4.8500000000000005},null,6,7,0.23,null,null,null,"J",17051,20070,6114,2038,611.4]
[null,6,8,0.23,null,null,null,null,null,6,8,0.23,null,null,null,"K",20071,23421,6675,2225,667.5]
[null,6,9,0.23,null,null,null,null,null,6,9,0.23,null,null,null,"L",{"$f":"\"Plus de \"&TEXT(R58,\"## ##0\")&\" €\"","v":"Plus de 23 421 €"},null,7431,2477,743.1]
[null,6,11,0.23,null,null,null,null,null,6,11,{"$f":"D60","v":0.23},null,null,null,"Prix de la restauration scolaire",null,null,2628,{"$f":"T40*2","v":876},{"$f":"ROUND(T60*3/10,1)","v":262.8}]
[null,12,12,0.23,null,null,null,null,null,12,12,0.3,null,null,null,"Ou de la Surveillance du Repas seule",null,null,1212,{"$f":"T41*2","v":404},{"$f":"ROUND(T61*3/10,1)","v":121.2}]
[null,12,13,0.28999999999999998,null,null,null,null,null,12,13,0.3,null,null,null,"Fournitures Pédagogiques",null,null,126,{"$f":"T42*2","v":42},{"$f":"ROUND(T62*3/10,1)","v":12.6}]
[null,12,14,0.28999999999999998,null,null,null,null,null,12,14,0.3,null,null,null,"Prix de la restauration scolaire (seule)",null,null,1416,{"$f":"T43*2","v":472},{"$f":"U60-U61","v":141.60000000000002}]
[null,12,15,0.28999999999999998,null,null,null,null,null,{"$f":"B64","v":12},15,0.3]
[null,12,16,0.28999999999999998,null,null,null,null,null,12,16,0.3]
[null,17,17,0.34,null,null,null,null,null,17,17,0.36,null,null,null,"TRANCHE","QUOTIENT FAMILIAL (QF)",null,"TARIF TROIS (3) ENFANTS"]
[null,17,18,0.34,null,null,null,null,null,17,18,0.36,null,null,null,null,"Mini","Maxi","(Annuel)","(En 3 Fois)","(En 10 Fois)"]
[null,17,19,0.34,null,null,null,null,null,17,19,0.36,null,null,null,"A"," De 1 €   ",{"$f":"R48","v":4685},{"$f":"ROUND(T68*3,0)","v":2634},{"$f":"ROUND(T48*(1+80%+70%),0)","v":878},{"$f":"ROUND(T68*3/10,1)","v":263.39999999999998}]
[null,17,20,0.34,null,null,null,null,null,17,20,0.36,null,null,null,"B",{"$f":"R68+1","v":4686},{"$f":"R49","v":5691},{"$f":"ROUND(T69*3,0)","v":2700},{"$f":"ROUND(T49*1.8,0)","v":900},{"$f":"ROUND(T69*3/10,1)","v":270}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C",{"$f":"R69+1","v":5692},6837,3618,1206,361.8]
[null,null,null,null,null,null,null,null,"TARIFS CLAE - ANNEE SCOLAIRE (N+1) ",{"$f":"AnSN1","v":"2024/2025"},null,null,null,null,null,"D",6838,7984,4530,1510,453]
[null,null,null,null,null,null,null,null,null,null,null,"Ecart",{"$f":"ROUNDUP(Ecart*(100+Taux_INSEE)/100,3)*0+0.06","v":0.06},null,null,"E",7985,9117,5514,1838,551.4]
[null,"A","B","C","D","E","F","G","H","I","J","K","L",null,null,"F",9118,10740,6414,2138,641.4]
[null,{"$f":"C74-Ecart1","v":2.73},{"$f":"D74","v":2.79},{"$f":"E74","v":2.79},{"$f":"F74-Ecart1","v":2.79},{"$f":"IF(F76>0,F76,MROUND(F75,0.05))","v":2.85},{"$f":"F74","v":2.85},{"$f":"G74","v":2.85},{"$f":"H74","v":2.85},{"$f":"I74+Ecart1","v":2.91},{"$f":"J74","v":2.91},{"$f":"K74","v":2.91},{"$f":"L74+Ecart1","v":2.97},null,null,"G",10741,12483,7629,2543,762.9]
[null,null,null,null,"Calcul avec Taux INSEE : ",{"$f":"ROUNDUP(Uclae*(100+Taux_INSEE)/100,2)","v":2.84},null,null,null,null,null,null,null,null,null,"H",12484,14597,8544,2848,854.4]
[null,null,null,null,null,null,"<== saisir un montant arrondi {en + ou -} en cellule F76. Dans ce cas, c'est la valeur de cette cellule qui est prise en compte en F74 ou laisser le calcul de la cellule F74 en ne saisissant rien en F76.",null,null,null,null,null,null,null,null,"I",14598,17050,9693,3231,969.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"J",17051,20070,11004,3668,1100.4000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"K",20071,23421,12015,4005,1201.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L",{"$f":"\"Plus de \"&TEXT(R78,\"## ##0\")&\" €\"","v":"Plus de 23 421 €"},null,13377,4459,1337.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Prix de la restauration scolaire",null,null,3942,{"$f":"T40*3","v":1314},{"$f":"ROUND(T80*3/10,1)","v":394.2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ou de la Surveillance du Repas seule",null,null,1818,{"$f":"T41*3","v":606},{"$f":"ROUND(T81*3/10,1)","v":181.8}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fournitures Pédagogiques",null,null,189,{"$f":"T42*3","v":63},{"$f":"ROUND(T82*3/10,1)","v":18.899999999999999}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Prix de la restauration scolaire (seule)",null,null,2124,{"$f":"T43*3","v":708},{"$f":"U80-U81","v":212.39999999999998}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TRANCHE","QUOTIENT FAMILIAL (QF)",null,"TARIF QUATRE (4) ENFANTS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mini","Maxi","(Annuel)","(En 3 Fois)","(En 10 Fois)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A"," De 1 €   ",{"$f":"R68","v":4685},{"$f":"ROUND(T88*3,0)","v":8430},{"$f":"ROUND(T68*(1+80%+70%+70%),0)","v":2810},{"$f":"ROUND(T88*3/10,1)","v":843}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B",{"$f":"R88+1","v":4686},{"$f":"R69","v":5691},{"$f":"ROUND(T89*3,0)","v":8640},{"$f":"ROUND(T69*(1+80%+70%+70%),0)","v":2880},{"$f":"ROUND(T89*3/10,1)","v":864}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C",{"$f":"R89+1","v":5692},6837,11577,3859,1157.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D",6838,7984,14496,4832,1449.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E",7985,9117,17646,5882,1764.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F",9118,10740,20526,6842,2052.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G",10741,12483,24414,8138,2441.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"H",12484,14597,27342,9114,2734.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"I",14598,17050,31017,10339,3101.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"J",17051,20070,35214,11738,3521.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"K",20071,23421,38448,12816,3844.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L",{"$f":"\"+ de \"&TEXT(R98,\"## ##0\")&\" €\"","v":"+ de 23 421 €"},null,42807,14269,4280.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Prix de la restauration scolaire",null,null,5256,{"$f":"T40*4","v":1752},{"$f":"ROUND(T100*3/10,1)","v":525.6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ou de la Surveillance du Repas seule",null,null,2424,{"$f":"T41*4","v":808},{"$f":"ROUND(T101*3/10,1)","v":242.4}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fournitures Pédagogiques",null,null,252,{"$f":"T42*4","v":84},{"$f":"ROUND(T102*3/10,1)","v":25.2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Prix de la restauration scolaire (seule)",null,null,2832,{"$f":"T43*4","v":944},{"$f":"U100-U101","v":283.20000000000005}]