{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Rapport","Parametres","Listes"],"not_rendered":{"charts":0,"images":23,"macros":1,"external_links":0,"defined_names":35,"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":"Rapport","index":0,"n_rows":195,"n_cols":26,"rows_kept":195,"cut":false,"hidden":false,"merged":[[52,22,52,25],[51,12,51,16],[52,17,52,21],[53,7,53,11],[126,4,126,6],[127,4,127,6],[124,7,124,11],[125,7,125,11],[126,7,126,11],[127,7,127,11],[125,17,125,21],[126,17,126,21],[127,17,127,21],[125,22,125,25],[126,22,126,25],[127,22,127,25],[121,22,121,25],[122,22,122,25],[123,22,123,25],[124,22,124,25],[124,17,124,21],[110,0,110,9],[113,11,113,22],[112,23,112,25],[39,22,39,25],[40,22,40,25],[41,22,42,25],[43,22,43,25],[39,7,39,11],[40,7,40,11],[41,7,42,11],[41,12,42,16],[39,12,39,16],[131,22,131,25],[132,7,132,11],[132,22,132,25],[128,7,128,11],[129,7,129,11],[130,7,130,11],[131,7,131,11],[130,12,130,16],[131,12,131,16],[132,12,132,16],[131,17,131,21],[132,17,132,21],[128,17,128,21],[128,12,128,16],[129,12,129,16],[130,22,130,25],[129,17,129,21],[130,17,130,21],[128,22,128,25],[129,22,129,25],[165,0,165,1],[134,1,134,25],[135,0,135,25],[136,0,136,2],[133,14,133,25],[133,11,133,13],[133,1,133,10],[166,0,166,25],[137,0,137,25],[131,0,131,3],[130,0,130,3],[129,0,129,3],[120,22,120,25],[119,4,119,6],[129,4,129,6],[130,4,130,6],[131,4,131,6],[132,4,132,6],[120,17,120,21],[120,0,120,3],[132,0,132,3],[128,4,128,6],[123,4,123,6],[128,0,128,3],[122,0,122,3],[119,17,119,21],[119,22,119,25],[120,4,120,6],[121,4,121,6],[120,7,120,11],[119,7,119,11],[119,12,119,16],[121,7,121,11],[124,0,124,3],[125,0,125,3],[126,0,126,3],[127,0,127,3],[123,0,123,3],[115,11,116,13],[115,23,116,23],[114,11,114,22],[112,0,112,9],[112,11,112,22],[116,14,116,22],[116,5,116,9],[120,12,120,16],[121,12,121,16],[122,4,122,6],[122,7,122,11],[122,12,122,16],[123,12,123,16],[124,12,124,16],[125,12,125,16],[126,12,126,16],[127,12,127,16],[124,4,124,6],[125,4,125,6],[111,11,111,25],[111,0,111,9],[114,5,114,9],[115,5,115,9],[121,0,121,3],[119,0,119,3],[118,0,118,25],[115,0,115,4],[116,0,116,4],[113,0,113,9],[114,0,114,4],[115,14,115,22],[113,23,113,25],[114,23,114,25],[115,24,116,25],[10,10,10,21],[10,6,10,9],[7,1,7,5],[12,21,12,24],[12,12,12,14],[12,15,12,16],[8,23,8,25],[12,17,12,19],[109,19,109,23],[109,24,109,25],[13,5,13,9],[7,10,7,21],[9,1,9,5],[10,1,10,5],[8,10,8,21],[8,1,8,5],[6,6,8,9],[10,23,10,25],[14,24,14,25],[15,24,19,25],[17,13,17,20],[16,13,16,20],[51,17,51,21],[51,22,51,25],[108,19,108,23],[108,24,108,25],[106,11,106,14],[106,15,106,18],[106,19,106,23],[106,24,106,25],[13,24,13,25],[20,0,20,4],[38,0,38,3],[36,0,36,25],[23,5,23,9],[25,0,25,25],[22,10,22,12],[22,13,22,20],[20,10,20,12],[13,21,13,23],[13,0,13,4],[38,7,38,11],[38,22,38,25],[38,17,38,21],[54,17,54,21],[55,17,55,21],[54,22,54,25],[55,22,55,25],[102,11,102,14],[102,15,102,18],[102,19,102,23],[102,24,102,25],[103,11,103,14],[103,15,103,18],[103,19,103,23],[103,24,103,25],[104,11,104,14],[104,15,104,18],[104,19,104,23],[104,24,104,25],[99,11,99,14],[99,15,99,18],[99,19,99,23],[99,24,99,25],[100,11,100,14],[100,15,100,18],[100,19,100,23],[100,24,100,25],[101,11,101,14],[101,15,101,18],[101,19,101,23],[101,24,101,25],[96,19,96,23],[96,24,96,25],[97,11,97,14],[97,15,97,18],[97,19,97,23],[97,24,97,25],[98,11,98,14],[98,15,98,18],[98,19,98,23],[98,24,98,25],[94,0,94,1],[95,0,95,1],[94,2,94,3],[95,2,95,3],[96,4,96,5],[96,6,96,7],[96,0,96,1],[96,2,96,3],[81,6,81,7],[85,4,85,5],[86,4,86,5],[87,4,87,5],[88,2,89,7],[82,2,82,3],[94,4,94,5],[84,4,84,5],[82,6,82,7],[86,6,86,7],[81,4,81,5],[82,4,82,5],[81,0,81,1],[82,0,82,1],[83,0,83,1],[86,2,86,3],[102,1,102,2],[102,3,102,4],[97,2,97,3],[98,0,98,9],[100,5,102,6],[100,7,102,9],[100,1,101,4],[97,0,97,1],[100,0,102,0],[97,4,97,5],[97,6,97,7],[99,0,99,9],[95,4,95,5],[95,6,95,7],[94,6,94,7],[91,4,91,5],[92,4,92,5],[63,0,63,1],[64,0,64,1],[66,18,66,22],[65,0,65,1],[66,0,66,1],[79,9,79,11],[79,12,79,15],[76,9,76,11],[76,12,76,15],[76,16,76,19],[78,20,78,21],[76,20,76,21],[77,20,77,21],[77,9,77,11],[77,12,77,15],[77,16,77,19],[78,9,78,11],[76,22,76,24],[63,23,63,25],[66,6,66,7],[67,6,67,7],[68,6,68,7],[69,6,69,7],[79,0,79,1],[65,2,65,3],[67,0,67,1],[68,0,68,1],[69,0,69,1],[66,2,66,3],[67,2,67,3],[69,2,69,3],[66,4,66,5],[67,4,67,5],[68,4,68,5],[69,4,69,5],[68,2,68,3],[70,2,70,3],[71,2,71,3],[72,2,72,3],[73,2,73,3],[70,4,70,5],[77,0,77,1],[78,0,78,1],[91,0,91,1],[92,0,92,1],[85,0,85,1],[86,0,86,1],[87,0,87,1],[88,0,89,1],[90,0,90,1],[65,4,65,5],[63,2,63,3],[64,2,64,3],[73,0,73,1],[74,0,74,1],[75,0,75,1],[76,0,76,1],[70,0,70,1],[71,0,71,1],[72,0,72,1],[71,4,71,5],[72,4,72,5],[73,4,73,5],[74,4,74,5],[74,2,74,3],[75,2,75,3],[83,2,83,3],[76,2,76,3],[77,2,77,3],[84,2,84,3],[85,2,85,3],[80,0,80,1],[84,0,84,1],[77,22,77,24],[78,22,78,24],[74,9,75,11],[74,12,75,15],[80,6,80,7],[80,16,80,19],[79,22,79,24],[73,6,73,7],[74,6,74,7],[75,20,75,21],[78,6,78,7],[80,12,80,15],[78,12,78,15],[78,16,78,19],[80,20,80,21],[79,20,79,21],[75,6,75,7],[77,6,77,7],[80,9,80,11],[76,6,76,7],[79,6,79,7],[88,24,88,25],[83,20,84,23],[85,24,85,25],[86,24,86,25],[83,24,84,25],[88,20,88,23],[86,20,86,23],[81,16,81,19],[81,20,81,24],[38,12,38,16],[50,0,50,1],[50,4,50,5],[43,7,43,11],[43,12,43,16],[87,6,87,7],[89,9,89,15],[88,9,88,15],[81,9,81,15],[83,6,83,7],[84,6,84,7],[83,4,83,5],[79,4,79,5],[80,4,80,5],[75,4,75,5],[76,4,76,5],[72,6,72,7],[77,4,77,5],[78,4,78,5],[87,2,87,3],[78,2,78,3],[79,2,79,3],[80,2,80,3],[81,2,81,3],[71,23,71,25],[74,20,74,25],[62,0,62,1],[18,5,18,9],[33,18,33,24],[19,13,19,20],[37,12,37,16],[20,24,23,25],[33,3,33,16],[21,0,21,4],[19,0,19,4],[19,5,19,9],[37,7,37,11],[19,10,19,12],[37,1,37,3],[56,22,56,25],[37,4,37,6],[38,4,38,6],[52,0,52,3],[51,4,51,6],[51,7,51,11],[52,7,52,11],[18,13,18,20],[20,5,20,9],[62,2,62,3],[39,4,39,6],[1,5,1,25],[3,0,3,5],[2,24,2,25],[5,1,5,5],[5,10,5,21],[1,0,2,4],[2,5,2,16],[2,17,2,23],[3,22,3,25],[6,1,6,5],[18,0,18,4],[17,0,17,4],[37,22,37,25],[37,17,37,21],[6,23,6,25],[4,23,4,25],[3,6,3,21],[4,1,4,5],[4,10,4,21],[6,10,6,21],[52,4,52,6],[52,12,52,16],[4,6,4,9],[5,6,5,9],[15,5,15,9],[31,3,32,16],[23,0,23,4],[23,10,23,12],[21,13,21,20],[20,13,20,20],[21,10,21,12],[23,13,23,20],[13,10,13,12],[17,10,17,12],[14,10,14,12],[12,0,12,2],[13,13,13,20],[16,0,16,4],[15,10,15,12],[15,13,15,20],[14,13,14,20],[14,0,14,4],[15,0,15,4],[14,5,14,9],[16,10,16,12],[16,5,16,9],[17,5,17,9],[40,4,40,6],[41,4,42,6],[43,4,43,6],[44,7,44,11],[57,0,57,2],[58,0,58,2],[54,7,54,11],[55,7,55,11],[53,0,53,3],[51,0,51,3],[22,5,22,9],[50,6,50,9],[21,5,21,9],[18,10,18,12],[46,0,46,5],[44,0,44,3],[42,0,42,3],[22,0,22,4],[43,0,43,3],[41,0,41,3],[29,0,29,25],[40,0,40,3],[39,0,39,3],[60,9,60,25],[53,4,53,6],[53,12,53,16],[53,22,53,25],[56,17,56,21],[54,4,54,6],[55,4,55,6],[56,4,56,6],[56,7,56,11],[54,12,54,16],[55,12,55,16],[53,17,53,21],[57,3,57,25],[58,3,58,25],[56,12,56,16],[95,11,95,25],[96,11,96,14],[96,15,96,18],[61,2,61,3],[61,4,61,5],[61,18,61,22],[54,0,54,3],[59,0,59,10],[55,0,55,3],[62,23,62,25],[63,6,63,7],[74,16,75,19],[65,14,65,17],[67,14,67,17],[66,14,66,17],[70,14,70,17],[70,6,70,7],[71,6,71,7],[67,9,67,13],[68,9,68,13],[64,9,64,13],[65,9,65,13],[66,9,66,13],[65,6,65,7],[94,21,94,25],[94,9,94,20],[93,9,93,20],[93,21,93,25],[90,20,90,23],[91,20,91,23],[92,20,92,23],[90,24,90,25],[91,24,91,25],[92,9,92,15],[61,6,61,7],[59,11,59,19],[64,6,64,7],[64,14,64,17],[64,18,64,22],[62,4,62,5],[62,18,62,22],[89,16,89,19],[87,20,87,23],[85,6,85,7],[63,9,63,13],[61,23,61,25],[68,14,68,17],[75,22,75,24],[71,14,71,17],[70,9,70,13],[69,14,69,17],[60,0,60,7],[59,20,59,25],[64,4,64,5],[63,4,63,5],[61,0,61,1],[63,18,63,22],[62,6,62,7],[63,14,63,17],[62,14,62,17],[61,9,61,13],[62,9,62,13],[71,18,71,22],[73,9,73,25],[72,23,72,25],[92,24,92,25],[65,18,65,22],[61,14,61,17],[79,16,79,19],[72,18,72,22],[71,9,71,13],[69,9,69,13],[70,18,70,22],[70,23,70,25],[69,18,69,22],[69,23,69,25],[68,18,68,22],[67,18,67,22],[65,23,65,25],[66,23,66,25],[67,23,67,25],[68,23,68,25],[93,0,93,1],[93,2,93,3],[93,4,93,5],[93,6,93,7],[86,16,86,19],[87,16,87,19],[80,22,80,24],[82,9,82,25],[88,16,88,19],[87,24,87,25],[87,9,87,15],[83,16,84,19],[92,2,92,3],[92,6,92,7],[89,20,89,23],[90,2,90,3],[90,4,90,5],[91,2,91,3],[92,16,92,19],[90,16,90,19],[91,16,91,19],[89,24,89,25],[91,6,91,7],[90,6,90,7],[194,3,194,6],[194,10,194,25],[105,7,105,9],[106,7,106,9],[107,7,107,9],[108,7,108,9],[105,5,105,6],[108,5,108,6],[106,5,106,6],[107,5,107,6],[123,7,123,11],[121,17,121,21],[122,17,122,21],[123,17,123,21],[105,11,105,14],[105,15,105,18],[105,19,105,23],[105,24,105,25],[107,11,107,14],[107,15,107,18],[107,19,107,23],[107,24,107,25],[108,11,108,14],[108,15,108,18],[103,5,103,6],[104,5,104,6],[103,7,103,9],[104,7,104,9],[107,3,107,4],[108,3,108,4],[105,1,105,2],[106,1,106,2],[107,1,107,2],[108,1,108,2],[105,3,105,4],[106,3,106,4],[103,1,103,2],[104,1,104,2],[103,3,103,4],[104,3,104,4],[0,0,0,25],[90,9,90,15],[91,9,91,15],[83,9,84,15],[85,9,85,15],[86,9,86,15],[85,20,85,23],[85,16,85,19],[64,23,64,25],[41,17,42,21],[48,7,48,11],[56,0,56,3],[43,17,43,21],[48,1,48,2],[44,4,44,6],[39,17,39,21],[48,12,48,25],[46,6,46,25],[44,12,44,16],[44,17,44,21],[44,22,44,25],[47,0,47,25],[40,12,40,16],[40,17,40,21]]}
[]
[null,null,null,null,null,"DEMANDE D'AIDE FINANCIERE - FSL                                               MAISON DE LA MÉTROPOLE | 1 place du Parlement de Metz | 57011 Metz Cedex 1                                              demandefsl@eurometropolemetz.eu "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date de la demande :"]
["ORGANISME DEMANDEUR",null,null,null,null,null,"BENEFICIAIRE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q.F."]
["Nom - Qualité : ",null,null,null,null,null,"Nom :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(QF>QFBas,ISERROR(QF),QF=0),\"p\",\"þ\")","v":"p"},{"$f":"CONCATENATE(\"< ou = à \",409.99,\" €\")","v":"< ou = à 409,99 €"}]
["Service : ",null,null,null,null,null,"Prénom :"]
["Adresse : ",null,null,null,null,null,"Adresse :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISERROR(QF),QF<QFMoyen1,QF>QFMoyen2),\"p\",\"þ\")","v":"p"},{"$f":"CONCATENATE(\"de \",410,\" à \",674.99,\" €\")","v":"de 410 à 674,99 €"}]
[]
["Téléphone : ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISERROR(QF),QF<QFHaut1,QF>QFHaut2),\"p\",\"þ\")","v":"p"},{"$f":"CONCATENATE(\"de \",675,\" à \",821,\" €\")","v":"de 675 à 821 €"}]
["Mail:"]
["Nom du cadre : ",null,null,null,null,null,"N°allocataire :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISERROR(QF),QF<=QFHaut2),\"p\",\"þ\")","v":"p"},"Autres"]
[]
["COMPOSITION FAMILIALE",null,null,null,null,null,null,null,null,null,null,null,"Enfants :",null,null,{"$f":"COUNTIF(F16:J24,\"Enfant\")","v":0},null,"Majeurs :",null,null,{"$f":"SUM(V16:V24)","v":0},"Mineurs :",null,null,null,{"$f":"SUM(X16:X24)","v":0}]
["Nom - Prénom",null,null,null,null,"Parenté",null,null,null,null,"Date de\nnaissance",null,null,"Situation",null,null,null,null,null,null,null,"Mineur",null,null,"Personnes\nsupplém. :"]
[{"$f":"CONCATENATE(K5,\" \",K6)","v":" "},null,null,null,null,"Demandeur",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(DateRef<>\"\",IF(DATEDIF(K15,DateRef,\"y\")<18,\"ü\",\"\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(DateRef=\"\",F16=\"\",K16=\"\"),0,IF(AND(F16=\"Enfant\",DATEDIF(K16,DateRef,\"y\")>=18),1,0))","v":0},"",{"$f":"IF(OR(DateRef=\"\",F16=\"\",K16=\"\"),0,IF(AND(F16=\"Enfant\",DATEDIF(K16,DateRef,\"y\")<18),1,0))","v":0},"Nb total de\npersonnes\nau foyer :"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",0,{"$f":"SUM(COUNTA(K5,A16:E24),Y15)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",0]
[]
["STATUT MATRIMONIAL"]
[]
[]
[]
["LOGEMENT"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"nombre de pièces (F…) :"]
[]
[]
["PROPOSITION D'AIDE"]
[null,"Fournitures",null,null,"Electricité",null,null,"Gaz",null,null,null,null,"Autres fournitures",null,null,null,null,"Eau",null,null,null,null,"Téléphone"]
["Aides déjà versées par le dispositif"]
["Montant facture"]
["Montant de l'aide sollicitée"]
["Mt demandé à un autre dispositif (lequel)"]
[]
["Participation globale du ménage"]
["Nombre de versements"]
[]
["MOTIVATION DE LA DEMANDE ET AVIS DU CADRE :"]
[]
["Date : ",null,null,null,null,null,null,"Nom - signature : ",null,null,null,null,{"$f":"IF(Cadre=\"\",\"\",Cadre)","v":""}]
[]
["DECISION COMMISSION",null,null,null,"Date : "]
["AIDES ACCORDEES",null,null,null,"Electricité",null,null,"Gaz",null,null,null,null,"Autres fournitures",null,null,null,null,"Eau",null,null,null,null,"Téléphone"]
["AIDE DU FSL"]
["NON VALEUR (*)"]
["REMISE DES FRAIS"]
["ð Solde restant dû par le ménage"]
["ECHEANCIER :"]
[" REJET (MOTIF) :   "]
["OBSERVATIONS : "]
[{"$f":"CONCATENATE(\"Bénéficiaire : \",IF($K$5=\"\",\"\",CONCATENATE($K$5,\" \",$K$6)))","v":"Bénéficiaire : "},null,null,null,null,null,null,null,null,null,null,"SITUATION FINANCIERE MOIS DE : "]
["I. RESSOURCES",null,null,null,null,null,null,null,null,"II. CHARGES MENSUELLES"]
["RESSOURCES MENS.",null,"MONTANT",null,"BENEFICIAIRE",null,"(1)",null,null,"NATURE",null,null,null,null,"MONTANT\nMENSUEL",null,null,null,"NATURE",null,null,null,null,"MONTANT\nMENSUEL"]
["Salaire",null,null,null,null,null,null,null,null,"Loyer résiduel",null,null,null,null,null,null,null,null,"Pension alimentaire"]
["Salaire conjoint",null,null,null,null,null,null,null,null,"Accession à la propriété"]
["R.S.A.",null,null,null,null,null,null,null,null,"Électricité"]
["Allocation chômage",null,null,null,null,null,null,null,null,"Eau"]
["Indemnité de stage",null,null,null,null,null,null,null,null,"Chauffage"]
["Indemnité de maladie",null,null,null,null,null,null,null,null,"Téléphone"]
["Indemnité AT",null,null,null,null,null,null,null,null,"Impôts"]
["Indemnité maternité",null,null,null,null,null,null,null,null,"Taxe"]
["Pension de retraite",null,null,null,null,null,null,null,null,"Assurance"]
["Pension d'invalidité",null,null,null,null,null,null,null,null,"TOTAL ",null,null,null,null,{"$f":"SUM(O63:R71)","v":0},null,null,null,"TOTAL",null,null,null,null,{"$f":"SUM(X63:Z71)","v":0}]
["Pension de réversion",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL 1",null,null,null,null,{"$f":"SUM($O$72,$X$72)","v":0}]
["Rente AT",null,null,null,null,null,null,null,null,"CREDITS"]
["Retraite complémentaire",null,null,null,null,null,null,null,null,"NATURE",null,null,"ORGANISME",null,null,null,"MONTANT\nTOTAL",null,null,null,"REMBOURS. MENSUEL"]
["Prest. minimum vieillesse",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Début",null,"Fin",null,null,"Montant"]
["AAH et complément"]
["Allocations familiales"]
["Complément familial"]
["Alloc.soutien familial"]
["Alloc.de base"]
["Compl.lib.choix mod.garde.",null,null,null,null,null,null,null,null,"TOTAL",null,null,null,null,null,null,{"$f":"SUM(Q77:T81)","v":0},null,null,null,"TOTAL 2",null,null,null,null,{"$f":"SUM(Z77:Z81)","v":0}]
["Compl.libre choix d'act.",null,null,null,null,null,null,null,null,"DETTES (à détailler)"]
["API",null,null,null,null,null,null,null,null,"MOTIFS",null,null,null,null,null,null,"MONTANTS",null,null,null,"PERSONNE\nCONCERNEE",null,null,null,"REMBOURS.\nMENSUEL"]
["Allocation différentielle"]
["Bourses scolaires"]
["Pension Alimentaire"]
["Solidarité familiale"]
["Total des ressources\nprises en compte",null,{"$f":"SUM(C63:D88)","v":0}]
[]
["Alloc. Logement"]
["APL"]
["Alloc.Educ.Enf.Handicapé",null,null,null,null,null,null,null,null,"TOTAL",null,null,null,null,null,null,{"$f":"SUM(Q86:T92)","v":0},null,null,null,"TOTAL 3",null,null,null,{"$f":"SUM(Y86:Z92)","v":0}]
["Alloc. Comp. Tierce Pers.",null,null,null,null,null,null,null,null,"CHARGES = TOTAL 1+2+3 :",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Total1,Total2,Total3)","v":0}]
["Prest. Comp. Handicap",null,null,null,null,null,null,null,null,"RESSOURCES PRISES EN COMPTE - CHARGES :",null,null,null,null,null,null,null,null,null,null,null,{"$f":"TotalRessourcesPEC-Total123","v":0}]
["Alloc. Pers. Autonomie",null,null,null,null,null,null,null,null,null,null,"FACTURES PONCTUELLES DU MOIS (à détailler)"]
["Alloc. Rentrée Scolaire",null,null,null,null,null,null,null,null,null,null,"NATURE",null,null,null,"MONTANT",null,null,null,"NATURE",null,null,null,null,"MONTANT"]
["Prime Naiss. Adoption"]
["(1) Renseignez avec un \"x\" si les justificatifs sont vus par le travailleur social"]
["AIDES FINANCIERES PONCTUELLES DES 3 DERNIERS MOIS"]
["ORGANISMES","MONTANT",null,null,null,"MOTIFS",null,"DATE D'ATTRI-BUTION"]
[]
[null,"SOLLICITE",null,"ATTRIBUE"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"TOTAL",null,null,null,{"$f":"SUM(P98:S108)","v":0},null,null,null,"TOTAL",null,null,null,null,{"$f":"SUM(Y98:Z108)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL 4",null,null,null,null,{"$f":"SUM(P109,Y109)","v":0}]
["QUOTIENT FAMILIAL :"]
["QF = total des ressources prises en compte - pension alim. versée",null,null,null,null,null,null,null,null,null,null,"CALCUL DU QUOTIENT FAMILIAL :"]
["Nombre de parts",null,null,null,null,null,null,null,null,null,null,"Total ressources prises en compte :",null,null,null,null,null,null,null,null,null,null,null,{"$f":"TotalRessourcesPEC","v":0}]
["NOMBRE DE PARTS :",null,null,null,null,null,null,null,null,null,null,"Montant de la pension alimentaire versée :",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(SUMIF($J$63:$N$71,\"Pension alimentaire\",$O$63:$R$71),SUMIF($S$63:$W$71,\"Pension alimentaire\",$X$63:$Z$71))","v":0}]
["1 personne isolée",null,null,null,null,{"$f":"Part1Pers","v":1.4},null,null,null,null,null,"Nb de personnes entrant dans  le calcul du QF :",null,null,null,null,null,null,null,null,null,null,null,{"$f":"NbPersonnes","v":0}]
["2 personnes",null,null,null,null,{"$f":"Part2Pers","v":1.8},null,null,null,null,null,"QF =",null,null,{"$f":"CONCATENATE(IF(TotalRessourcesPEC=0,\"\",TotalRessourcesPEC),IF(X114=0,\"\",CONCATENATE(\" - \",TotalPensAlim)))","v":""},null,null,null,null,null,null,null,null,"=",{"$f":"IF(AND(TotalRessourcesPEC<>0,NbPersonnes=0),\"nb parts ?\",ROUND((TotalRessourcesPEC-TotalPensAlim)/IF(NbPersonnes=1,Part1Pers,IF(NbPersonnes=2,Part2Pers,(Part2Pers+((NbPersonnes-2)*PartPersSup)))),0))","v":0}]
["par personne à charge supplémentaire",null,null,null,null,{"$f":"PartPersSup","v":0.5},null,null,null,null,null,null,null,null,{"$f":"IF(NbPersonnes=0,\"\",IF(NbPersonnes=1,CONCATENATE(\"nb parts = \",Part1Pers),IF(NbPersonnes=2,CONCATENATE(\"nb parts = \",Part2Pers),CONCATENATE(\"nb parts = \",(Part2Pers+((NbPersonnes-2)*PartPersSup))))))","v":""}]
[]
[{"$f":"CONCATENATE(\"DETAIL DES AIDES ATTRIBUEES DEPUIS LE DEBUT DE L'ANNEE\",IF($Y$3=\"\",\"\",CONCATENATE(\" \",YEAR($Y$3))))","v":"DETAIL DES AIDES ATTRIBUEES DEPUIS LE DEBUT DE L'ANNEE"}]
["Mois",null,null,null,"Electricité",null,null,"Gaz",null,null,null,null,"Autres fournitures",null,null,null,null,"Eau",null,null,null,null,"Téléphone"]
[{"$f":"CONCATENATE(\"Janvier\",IF(YEAR(DateRef)=1900,\"\",CONCATENATE(\" \",YEAR(DateRef))))","v":"Janvier"}]
[{"$f":"CONCATENATE(\"Février\",IF(YEAR(DateRef)=1900,\"\",CONCATENATE(\" \",YEAR(DateRef))))","v":"Février"}]
[{"$f":"CONCATENATE(\"Mars\",IF(YEAR(DateRef)=1900,\"\",CONCATENATE(\" \",YEAR(DateRef))))","v":"Mars"}]
[{"$f":"CONCATENATE(\"Avril\",IF(YEAR(DateRef)=1900,\"\",CONCATENATE(\" \",YEAR(DateRef))))","v":"Avril"}]
[{"$f":"CONCATENATE(\"Mai\",IF(YEAR(DateRef)=1900,\"\",CONCATENATE(\" \",YEAR(DateRef))))","v":"Mai"}]
[{"$f":"CONCATENATE(\"Juin\",IF(YEAR(DateRef)=1900,\"\",CONCATENATE(\" \",YEAR(DateRef))))","v":"Juin"}]
[{"$f":"CONCATENATE(\"Juillet\",IF(YEAR(DateRef)=1900,\"\",CONCATENATE(\" \",YEAR(DateRef))))","v":"Juillet"}]
[{"$f":"CONCATENATE(\"Août\",IF(YEAR(DateRef)=1900,\"\",CONCATENATE(\" \",YEAR(DateRef))))","v":"Août"}]
[{"$f":"CONCATENATE(\"Septembre\",IF(YEAR(DateRef)=1900,\"\",CONCATENATE(\" \",YEAR(DateRef))))","v":"Septembre"}]
[{"$f":"CONCATENATE(\"Octobre\",IF(YEAR(DateRef)=1900,\"\",CONCATENATE(\" \",YEAR(DateRef))))","v":"Octobre"}]
[{"$f":"CONCATENATE(\"Novembre\",IF(YEAR(DateRef)=1900,\"\",CONCATENATE(\" \",YEAR(DateRef))))","v":"Novembre"}]
[{"$f":"CONCATENATE(\"Décembre\",IF(YEAR(DateRef)=1900,\"\",CONCATENATE(\" \",YEAR(DateRef))))","v":"Décembre"}]
[{"$f":"CONCATENATE(\"Total de l'année\",IF(YEAR(DateRef)=1900,\"\",CONCATENATE(\" \",YEAR(DateRef))))","v":"Total de l'année"},null,null,null,{"$f":"SUM(E121:G132)","v":0},null,null,{"$f":"SUM(H121:L132)","v":0},null,null,null,null,{"$f":"SUM(M121:Q132)","v":0},null,null,null,null,{"$f":"SUM(R121:V132)","v":0},null,null,null,null,{"$f":"SUM(W121:Z132)","v":0}]
["NOM : ",{"$f":"IF($K$5=\"\",\"\",$K$5)","v":""},null,null,null,null,null,null,null,null,null,"Prénom : ",null,null,{"$f":"IF(K6=\"\",\"\",K6)","v":""}]
["Adresse : ",{"$f":"CONCATENATE(Rapport!$K$7,IF(Rapport!$K$8<>\"\",\" \",\"\"),Rapport!$K$8,IF(Rapport!$K$9<>\"\",\" \",\"\"),Rapport!$K$9)","v":""}]
["EXPOSE DE LA SITUATION"]
["PROBLEMATIQUE"]
["(caractériser la situation, ce qui génère la ou les difficultés et nécessite un plan d'aide)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["PLAN D'AIDE"]
["(présenter l'approche globale du traitement de la situation)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"CONCATENATE(\"Date : \",IF(DateRef=\"\",\"\",CONCATENATE(,TEXT(DATE(YEAR(DateRef),MONTH(DateRef),DAY(DateRef)),\"jj/MM/aaaa\"))))","v":"Date : "},null,null,null,null,null,null,{"$f":"CONCATENATE(\"Signature : \",IF(AS=\"\",\"\",AS))","v":"Signature : "}]

{"sheet":"Parametres","index":1,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":true,"merged":[[0,0,0,1],[5,0,5,3]]}
["Nombre de parts"]
["1 personne",1.4,null,null,null,1.4]
["2 personnes",1.8,null,null,null,1.8]
["Par personne à charge supplémentaire",0.5,null,null,null,0.5]
[]
["Tranches - quotient familial"]
["QF bas : < ou égal à",401,null,null,null,401]
["QF moyen : de",{"$f":"QFBas+1","v":402},"à",659,null,659]
["QF haut : de",{"$f":"QFMoyen2+1","v":660},"à",803,null,803]

{"sheet":"Listes","index":2,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
["Ressources PEC","Ressources non PEC","Charges mensuelles","Parenté","Situation","Fournitures"]
["AAH et complément","Alloc. Logement","Loyer résiduel","Conjoint","A la recherche d'un emploi","Alloc. Logement"]
["Alloc.de base","APL","Loyer","Enfant","Etudiant","APL"]
["Alloc.soutien familial","Alloc.Educ.Enf.Handicapé","Accession à la propriété","Autre","Inactif","Alloc.Educ.Enf.Handicapé"]
["Allocation chômage","Alloc. Comp. Tierce Pers.","Garage",null,"Retraité","Autres fournitures"]
["Allocation différentielle","Prest. Comp. Handicap","Charges locatives",null,"Salarié","Eau"]
["Allocations familiales","Alloc. Pers. Autonomie","Électricité",null,"Scolarisé","Alloc. Pers. Autonomie"]
["API","Alloc. Rentrée Scolaire","Gaz",null,"Autre"]
["Bourses scolaires","Prime Naiss. Adoption","Fioul"]
["Compl.lib.choix mod.garde.",null,"Charbon coke"]
["Compl.libre choix d'act.",null,"Bois"]
["Complément familial",null,"Eau"]
["Indemnité AT",null,"Téléphone fixe"]
["Indemnité de maladie",null,"Téléphone mobile"]
["Indemnité de stage",null,"Impôts sur le revenu"]
["Indemnité maternité",null,"Taxe hab. red. audio"]
["Pension Alimentaire",null,"Taxe foncière"]
["Pension de retraite",null,"Ordures ménagères"]
["Pension de réversion",null,"Assurance auto."]
["Pension d'invalidité",null,"Assurance 2 roues"]
["Prest. minimum vieillesse",null,"Assurance habitation"]
["R.S.A.",null,"Assurance scolaire"]
["Rente AT",null,"Cantine scolaire"]
["Retraite complémentaire",null,"Frais de scolarité"]
["Salaire",null,"Frais de garde"]
["Salaire conjoint",null,"Pension alimentaire"]
["Solidarité familiale",null,"Mutuelle santé"]