{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Septembre 2018 (5)","Septembre","Récapitulatif Annuel","Formules","ESSAI V1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":5,"comments":3,"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":"Septembre 2018 (5)","index":0,"n_rows":48,"n_cols":9,"rows_kept":48,"cut":false,"hidden":true,"merged":[[43,2,43,3],[44,2,44,3],[46,2,46,5],[47,2,47,5],[47,12,48,15],[13,7,14,7],[13,8,14,8],[21,11,21,13],[40,3,40,4],[40,5,42,7],[41,3,41,4],[11,0,11,1],[11,2,11,3],[12,0,12,1],[12,2,12,6],[13,0,14,0],[13,1,14,1],[13,2,14,4],[13,5,14,5],[13,6,14,6],[8,0,8,1],[8,2,8,3],[8,4,8,5],[8,6,8,8],[9,0,9,1],[9,2,9,3],[9,4,11,6],[9,7,11,8],[10,0,10,1],[10,2,10,3],[6,0,6,1],[6,2,6,3],[6,4,6,5],[6,6,6,8],[7,0,7,1],[7,2,7,3],[7,4,7,5],[7,6,7,8],[4,0,4,1],[4,2,4,3],[4,4,4,5],[4,6,4,8],[5,0,5,1],[5,2,5,3],[5,4,5,5],[5,6,5,8],[0,0,0,3],[0,4,0,8],[1,0,2,3],[1,4,2,8],[3,0,3,3],[3,4,3,8]]}
["NOM/PRENOM ENFANT A CHARGE",null,null,null,"MOIS"]
["…. BRUNEL"]
[]
["EMPLOYEUR",null,null,null,"SALARIE"]
["Nom:",null,"BRUNEL Samuel",null,"Nom:",null,"VIALLETEL Nathalie"]
["Adresse:",null,"22 rue des Bordets 63720 ENNEZAT",null,"Adresse:",null,"25 rue des Blés d'or 63720 ENNEZAT"]
["N° URSSAF/ PAJE :",null,null,null,"N° de sécurité sociale",null,"2720843040010 46"]
["Date de début de contrat :",null,"1er Septembre 2018",null,"N° Salarié",null,134691]
["Total Heures Moyens",null,190,null,"Emploi occupé",null,"Assistante maternelle agréée"]
["Total Heures Réels",null,{"$f":"SUM(B16:B46)","v":0},null,"Convention Collective des Assistantes\nmaternelles du Particulier Employeur",null,null,"Code 8891A"]
["Nombre Jours Moyens",null,"20j"]
["Nombres Jours Réels",null,{"$f":"COUNTIF(B15:B46,\">0\")","v":0}]
["Congés payés",null,"Du ……….. Au ………..",null,null,null,null,"NET","BRUT"]
["JOURS","HEURES","Salaire de Base sur une mensualisation de",null,null,190,null,599.44000000000005,{"$f":"(H20*100)/76.64","v":782.15031315240094}]
[]
["2018-09-01","/"]
["2018-09-02","/","Heures supplémentaires",null,"x",3.48,null,{"$f":"F17*D17","v":0}]
["2018-09-03",null,"Réduction jour d'absence",null,"x",30.56,null,{"$f":"D18*F18","v":0}]
["2018-09-04",null,"ou heure d'absence",null,"x",2.9,null,{"$f":"D19*F19","v":0}]
["2018-09-05",null,"Net à Verser",1,null,null,null,{"$f":"(H14+H17)-H18-H19","v":599.44000000000005}]
["2018-09-06"]
["2018-09-07",null,"Calcul des Cotisations Salariales"]
["2018-09-08","/",null,null,"BASE","TAUX"]
["2018-09-09","/","CSG non imposable",null,{"$f":"(I14*98.25)/100","v":768.46268267223388},5.0999999999999996,null,{"$f":"(E24*F24)/100","v":39.191596816283926}]
["2018-09-10",null,"CSG +RDS imposable",null,{"$f":"(I14*98.25)/100","v":768.46268267223388},2.9,null,22.285417797494784]
["2018-09-11",null,"Sécurité Sociale",null,{"$f":"I14","v":782.15031315240094},8.0500000000000007,null,62.963100208768282]
["2018-09-12",null,"Chômage",null,{"$f":"I14","v":782.15031315240094},2.4,null,18.771607515657621]
["2018-09-13",null,"AGFF",null,{"$f":"I14","v":782.15031315240094},0.8,null,6.2572025052192082]
["2018-09-14",null,"IRCEM (retraite cpl)",null,{"$f":"I14","v":782.15031315240094},3.1,null,24.246659707724429]
["2018-09-15","/","Prévoyance",null,{"$f":"I14","v":782.15031315240094},1.1499999999999999,null,{"$f":"E30*(F30/100)","v":8.9947286012526106}]
["2018-09-16","/","Total des Cotisations Salariales",null,null,null,null,{"$f":"SUM(H24:H30)","v":182.71031315240083}]
["2018-09-17"]
["2018-09-18",null,"Calcul des Indemnités"]
["2018-09-19",null,"Indemnités nourriture",0,"x",3,null,{"$f":"D34*F34","v":0}]
["2018-09-20",null,"Indemnités entretien (-9h)",{"$f":"COUNTIF(B16:B47,\">0\")","v":0},"x",3.01,null,{"$f":"D35*F35","v":0}]
["2018-09-21",null,"Indemnités de rupture",{"$f":"1/120","v":8.3333333333333332E-3},"x",null,null,{"$f":"(D36)*F36","v":0}]
["2018-09-22","/","Total des Indemnités",2,null,null,null,{"$f":"H34+H35+H36","v":0}]
["2018-09-23","/"]
["2018-09-24",null,"Net à Payer","1+2",null,null,null,{"$f":"H20+H37","v":599.44000000000005}]
["2018-09-25"]
["2018-09-26",null,"Date du Paiement ",null,null,"Signature"]
["2018-09-27",null,"Moyen de Paiement"]
["2018-09-28"]
["2018-09-29","/","NET IMPOSABLE (sans indemnités)",null,null,null,{"$f":"H20","v":599.44000000000005}]
["2018-09-30","/","NET IMPOSABLE (avec indemnités)",null,null,null,{"$f":"H39","v":599.44000000000005}]
[]
[null,null,"CUMUL ANNUEL NET IMPOSABLE (sans indemnités)"]
[null,null,"CUMUL ANNUEL NET IMPOSABLE (avec indemnités)"]

{"sheet":"Septembre","index":1,"n_rows":46,"n_cols":25,"rows_kept":46,"cut":false,"hidden":false,"merged":[[5,5,5,6],[39,0,39,1],[39,2,39,3],[39,6,40,7],[39,8,40,8],[40,4,40,5],[35,4,37,7],[5,7,5,8],[0,0,1,4],[0,5,1,8],[2,0,2,4],[2,5,2,8],[3,0,3,1],[3,2,3,4],[3,5,3,6],[3,7,3,8],[5,2,5,4],[6,5,6,6],[6,7,6,8],[7,0,7,1],[7,5,7,6],[7,7,7,8],[4,0,4,1],[4,2,4,4],[4,5,4,6],[4,7,4,8],[5,0,5,1],[8,0,8,1],[8,5,10,7],[8,8,10,8],[9,0,9,1],[10,0,10,1],[11,0,11,1],[11,2,11,4],[11,5,11,6],[12,0,13,1],[12,2,13,4],[12,5,13,5],[12,6,13,6],[12,8,13,8],[12,7,13,7],[32,0,32,1],[35,2,37,3],[14,0,14,1],[14,2,14,8],[15,2,15,3],[16,2,16,3],[17,2,17,3],[18,5,19,6],[35,8,36,8],[38,2,38,3],[39,4,39,5],[41,2,41,6],[42,2,42,7],[43,2,43,7],[20,0,20,1],[20,2,20,7],[26,0,26,1],[29,5,29,7],[30,2,30,7],[5,20,6,20],[5,19,6,19],[44,2,44,7],[45,0,47,8],[15,0,15,1],[21,0,21,1],[27,0,27,1],[33,0,33,1],[34,6,34,7],[38,0,38,1],[5,18,6,18],[7,18,8,24],[18,13,18,15],[0,12,1,16],[6,12,7,14],[6,15,7,16],[5,24,6,24],[5,23,6,23],[5,22,6,22],[5,21,6,21]]}
["LOUISE BRUNEL",null,null,null,null,"SEPTEMBRE 2018",null,null,null,null,null,null,"HORAIRE DE GARDE"]
[]
["EMPLOYEUR",null,null,null,null,"SALARIE",null,null,null,null,null,null,"Lundi","Mardi","Mercredi","Jeudi","Vendredi",null,null,"Semaine","Lundi","Mardi","Mercredi","Jeudi","Vendredi"]
["Nom:",null,"BRUNEL Samuel",null,null,"Nom:",null,"VIALLETEL Nathalie",null,null,null,null,"07h30-18h","07h30-18h","7h30-17h","07h30-17h30","07h30-17h30",null,null,41,10.5,10.5,9.5,10,10]
["Adresse:",null,"22 rue des Bordets\n63720 ENNEZAT",null,null,"Adresse:",null,"25 rue des Blés d'or\n63720 ENNEZAT",null,null,null,null,10.5,10.5,9.5,10,10,null,"Nombre",4]
["N° URSSAF/ PAJE :",null,null,null,null,"N° de sécurité sociale",null,"2720843040010 46",null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"T5*T4","v":164},0,0,0,0,0]
["Début de contrat :",null,"1er Septembre 2018",null,null,"N° Salarié",null,134691,null,null,null,null,"JOUR GARDE PREVU",null,null,"TEMPS GARDE"]
["Heures Prévues",null,{"$f":"S8","v":164},"Jours Congés",{"$f":"B18+B24+B30+B36+B42","v":0},"Emploi occupé",null,"Assistante maternelle agréée",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(T6:Y7)","v":164}]
["Heures Réelles",null,{"$f":"IF(ISBLANK(I40),0,(B17+B23+B29+B35+B41))","v":82},"Jours Absences",{"$f":"B19+B25+B31+B37+B43","v":0},"Convention Collective des Assistantes\nmaternelles du Particulier Employeur",null,null,"Code 8891A",null,null,null,"Date mois","JNG","Jour Ouvré","Semaine","Mois"]
["Jours Gardes Prévus",null,{"$f":"O10","v":16},"Heures Absences",{"$f":"B20+B26+B32+B38+B44","v":0},null,null,null,null,null,null,null,"2018-09-01","2018-09-05",{"$f":"NETWORKDAYS(M10,M11,N10:N13)","v":16},41,164]
["Jours Gardes Réels",null,{"$f":"IF(ISBLANK(I40),0,A17+A23+A29+A35+A41)","v":8},null,null,null,null,null,null,null,null,null,"2018-09-30","2018-09-10"]
["Congés payés",null,null,null,null,null,null,"Brut","Net",null,null,null,null,"2018-09-19"]
["SEMAINE DE GARDE",null,"Mensualisation de Base prévue dans le contrat*",null,null,164,"52 semaines",691.12,533.34,null,null,null,null,"2018-09-28"]
[]
["Semaine 36",null,"*41h00/semaine"]
["03/09/2018 au 09/09/2018",null,"Heures supplémentaires",null,0,"x",3.6,null,{"$f":"E16*G16","v":0}]
[4,41,"Réduction Jour d'Absence",null,{"$f":"B19+B25+B31+B42","v":0},"x",0,null,{"$f":"E17*G17","v":0}]
["CP",0,"ou Heure d'Absence",null,{"$f":"B20+B26+B32+B38+B43","v":0},"x",3,null,{"$f":"E18*G18","v":0}]
["Jours Absences",0,null,null,null,"Net à verser (1)",null,"NET",{"$f":"(I13+I16)-I17-I18","v":533.34},null,null,null,null,"A remplir début de mois"]
["Heures Absences",0,null,null,null,null,null,"BRUT",{"$f":"(I19*100)/76.64","v":695.90292275574109}]
["Semaine 37",null,"Calcul des Cotisations Salariales"]
["10/09/2018 au 16/09/2018",null,null,null,null,"BASE","TAUX"]
[4,41,"CSG non imposable",null,null,{"$f":"(H13*98.25)/100","v":679.02539999999999},6.8,null,{"$f":"(F23*G23)/100","v":46.173727199999995}]
["CP",0,"CSG +RDS imposable",null,null,{"$f":"(H13*98.25)/100","v":679.02539999999999},2.4,null,16.2966096]
["Jours Absences",0,"Sécurité Sociale",null,null,{"$f":"H13","v":691.12},8.0500000000000007,null,55.635160000000006]
["Heures Absences",0,"Chômage",null,null,{"$f":"H13","v":691.12},0.95,null,6.5656399999999993]
["Semaine 38",null,"AGFF",null,null,{"$f":"H13","v":691.12},0.8,null,5.5289600000000005]
["17/09/2018 au 23/09/2018",null,"IRCEM (retraite cpl)",null,null,{"$f":"H13","v":691.12},3.1,null,21.424720000000001]
[null,null,"Prévoyance",null,null,{"$f":"H13","v":691.12},1.1499999999999999,null,{"$f":"F29*(G29/100)","v":7.9478799999999996}]
["CP",0,null,null,null,"Total des cotisations salariales",null,null,{"$f":"SUM(I23:I29)","v":159.57269680000002}]
["Jours Absences",0,"Calcul des Indemnités"]
["Heures Absences",0,"Indemnités nourriture",null,0,"x",3,null,{"$f":"E32*G32","v":0}]
["Semaine 39",null,"Indemnités entretien",null,{"$f":"C11","v":8},"x",3.54,null,{"$f":"E33*G33","v":28.32}]
["24/09/2018 au 30/09/2018",null,"Indemnités de rupture",null,0,"x",{"$f":"1/120","v":8.3333333333333332E-3},null,{"$f":"(G34)*E34","v":0}]
[null,null,null,null,null,null,"Net à verser (2)",null,{"$f":"I32+I33+I34","v":28.32}]
["CP",0,"Observations",null,"Adaptation Août 2018 de 15h00\nsoit",null,null,null,"Net à verser (3)"]
["Jours Absences",0]
["Heures Absences",0,null,null,null,null,null,null,{"$f":"15*3","v":45}]
[null,null,"Net à payer (1+2+3)",null,null,"=>",null,null,{"$f":"I35+I19+I38","v":606.66000000000008}]
[null,null,"Date du Paiement ",null,null,null,"Signature",null,"f"]
[null,null,"Moyen de Paiement",null,"Chèque"]
[null,null,"NET IMPOSABLE (sans indemnités)",null,null,null,null,null,{"$f":"I19+I38","v":578.34}]
[null,null,"NET IMPOSABLE (avec indemnités)",null,null,null,null,null,{"$f":"I39","v":606.66000000000008}]
[null,null,"CUMUL ANNUEL NET IMPOSABLE (sans indemnités)",null,null,null,null,null,{"$f":"IF(I39<>0,I42,\"…€\")","v":578.34}]
[null,null,"CUMUL ANNUEL NET IMPOSABLE (avec indemnités)",null,null,null,null,null,{"$f":"IF(I39<>0,I43,\"…€\")","v":606.66000000000008}]
["Conservez ce bulletin de salaire sans limitation de durée. La loi 91. 1406 du 31/12/1991 ainsi que le décret n°  92. 660  du 13/07/1992 suppriment l'obligation des cotisations patronales.Taux en vigueur au 01 / 01 / 2017\n"]

{"sheet":"Récapitulatif Annuel","index":2,"n_rows":33,"n_cols":14,"rows_kept":33,"cut":false,"hidden":false,"merged":[[31,0,31,4],[32,0,32,4],[25,0,25,7],[31,5,31,7],[32,5,32,7],[30,0,30,7],[26,7,27,7],[26,6,27,6],[26,1,27,1],[26,2,26,3],[28,0,29,0],[28,1,29,1],[28,2,29,2],[28,3,29,3],[28,4,29,4],[28,5,29,5],[28,6,29,6],[28,7,29,7],[11,7,12,7],[11,6,12,6],[11,4,11,5],[11,1,12,1],[26,4,26,5],[11,2,11,3],[36,2,36,3],[4,0,4,1],[4,6,4,7],[1,11,1,12],[1,13,1,14],[2,11,2,12],[2,13,2,14],[7,4,7,5],[4,2,4,3],[4,4,4,5],[5,4,5,5],[0,0,1,3],[0,4,1,7],[2,0,2,3],[2,4,2,7],[3,0,3,1],[3,2,3,3],[3,4,3,5],[3,6,3,7],[9,0,9,1],[9,2,9,3],[10,0,10,1],[5,0,5,1],[5,2,5,3],[5,6,5,7],[6,0,6,1],[6,2,6,3],[6,4,6,5],[6,6,6,7],[10,2,10,3],[11,0,12,0],[26,0,27,0],[7,0,7,1],[7,2,7,3],[7,6,7,7],[8,0,8,1],[8,2,8,3],[8,4,10,6],[8,7,10,7]]}
["LOUISE BRUNEL",null,null,null,"RÉCAPITULATIF 2018"]
[null,null,null,null,null,null,null,null,null,null,null,"Date",null,{"$f":"TODAY()","v":"2018-09-13"}]
["EMPLOYEUR",null,null,null,"SALARIE",null,null,null,null,null,null,"Heure",null,{"$f":"NOW()","v":43356.010589814818}]
["Nom:",null,"BRUNEL Samuel",null,"Nom:",null,"VIALLETEL Nathalie"]
["Adresse:",null,"22 rue des Bordets\n63720 ENNEZAT",null,"Adresse:",null,"25 rue des Blés d'or\n63720 ENNEZAT"]
["N° URSSAF/ PAJE :",null,null,null,"N° de sécurité sociale",null,"2720843040010 46"]
["Date de début de contrat :",null,"1er Septembre 2018",null,"N° Salarié",null,134691]
["Total Heures Prévues",null,null,null,"Emploi occupé",null,"Assistante maternelle agréée"]
["Total Heures Réelles",null,null,null,"Convention Collective des Assistantes\nmaternelles du Particulier Employeur",null,null,"Code 8891A"]
["Nombre Jours Ouvrés"]
["Nombre Jours Réels"]
["Mois","Total jour","Total heure",null,"Absence",null,"CP","Salaire versé"]
[null,null,"Normal","Supp","Heure","Jour"]
["Janvier",{"$f":"IFERROR(IF(INDIRECT($A$14&\"!D39\")<>0,INDIRECT($A14&\"!C11\"),\"/\"),\"\")","v":""},{"$f":"IFERROR(IF(INDIRECT($A$14&\"!D39\")<>0,INDIRECT($A14&\"!C9\"),\"/\"),\"\")","v":""},{"$f":"IFERROR(IF(INDIRECT($A$14&\"!D39\")<>0,INDIRECT($A14&\"!D16\"),\"/\"),\"\")","v":""},"",{"$f":"IFERROR(IF(INDIRECT($A$14&\"!D39\")<>0,INDIRECT($A14&\"!D17\"),\"/\"),\"\")","v":""},{"$f":"IFERROR(IF(INDIRECT($A$14&\"!D39\")<>0,INDIRECT($A14&\"!B46\"),\"/\"),\"\")","v":""},{"$f":"IFERROR(IF(INDIRECT($A$14&\"!D39\")<>0,INDIRECT($A14&\"!G36\"),\"/\"),\"\")","v":""}]
["Février","","","","","","",""]
["Mars","","","","","","",""]
["Avril","","","","","","",""]
["Mai","","","","","","",""]
["Juin","","","","","","",""]
["Juillet","","","","","","",""]
["Aôut","","","","","","",""]
["Septembre","","","","","","",""]
["Octobre","","","","","","",""]
["Novembre","","","","","","",""]
["Décembre","","","","","","",""]
["ANNUEL"]
["Année","Total jour","Total heure",null,"Absence",null,"CP","Salaire versé"]
[null,null,"Normal","Supp","Heure","Jour"]
["2019",{"$f":"SUM(B14:B25)","v":0},0,0,0,0,0,0]
[]
["CUMUL ANNUEL NET IMPOSABLE"]
["CUMUL ANNUEL NET IMPOSABLE (sans indemnités)"]
["CUMUL ANNUEL NET IMPOSABLE (avec indemnités)"]

{"sheet":"Formules","index":3,"n_rows":63,"n_cols":3,"rows_kept":63,"cut":false,"hidden":false,"merged":[[62,2,66,5],[0,1,0,3],[54,2,58,5]]}
["Férié de l'année"]
["2019-01-01"]
["2019-04-22"]
["2019-05-01"]
["2019-05-08"]
["2019-05-30"]
["2019-06-10"]
["2019-07-14"]
["2019-08-15"]
["2019-11-01"]
["2019-11-11"]
["2019-12-25"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Etirer plage jours férié dans formule \"F\""]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Selectionner cellule a reprendre référence puis se servire de la fontion Remplacer en haute dans barre de tache"]

{"sheet":"ESSAI V1","index":4,"n_rows":46,"n_cols":48,"rows_kept":46,"cut":false,"hidden":false,"merged":[[0,0,1,4],[0,5,1,8],[0,35,1,39],[2,0,2,4],[2,5,2,8],[3,0,3,1],[3,2,3,4],[3,5,3,6],[3,7,3,8],[4,0,4,1],[4,2,4,4],[4,5,4,6],[4,7,4,8],[5,0,5,1],[5,2,5,4],[5,5,5,6],[5,7,5,8],[7,5,7,6],[7,7,7,8],[7,41,8,47],[8,0,8,1],[5,41,6,41],[5,42,6,42],[5,43,6,43],[5,44,6,44],[5,45,6,45],[5,46,6,46],[9,0,9,1],[10,0,10,1],[11,0,11,1],[11,5,11,6],[5,47,6,47],[6,5,6,6],[6,7,6,8],[6,35,7,37],[6,38,7,39],[7,0,7,1],[12,0,13,1],[12,2,13,4],[12,5,13,5],[12,6,13,6],[12,7,13,7],[12,8,13,8],[14,42,14,44],[20,2,20,7],[14,2,14,8],[15,2,15,3],[16,2,16,3],[17,2,17,3],[29,5,29,7],[30,2,30,7],[34,6,34,7],[2,14,3,16],[13,18,13,19],[13,24,13,27],[5,20,9,24],[18,5,19,6],[8,5,10,7],[8,8,10,8],[35,2,37,3],[35,4,37,7],[35,8,36,8],[38,2,38,3],[39,2,39,3],[39,4,39,5],[39,6,40,7],[39,8,40,8],[40,4,40,5],[41,2,41,6],[42,2,42,7],[43,2,43,7],[44,2,44,7],[45,0,47,8]]}
[null,null,null,null,null,"SEPTEMBRE 2018",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HORAIRE DE GARDE"]
[]
["EMPLOYEUR",null,null,null,null,"SALARIE",null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2018-09-13"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lundi","Mardi","Mercredi","Jeudi","Vendredi",null,null,"Semaine","Lundi","Mardi","Mercredi","Jeudi","Vendredi"]
["Nom:",null,null,null,null,"Nom:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"07h30-18h","07h30-18h","7h30-17h","07h30-17h30","07h30-17h30",null,null,41,10.5,10.5,9.5,10,10]
["Adresse:",null,null,null,null,"Adresse:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10.5,10.5,9.5,10,10,null,"Nombre",4]
["N° URSSAF/ PAJE :",null,null,null,null,"N° de sécurité sociale",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calcul du nombre d'heure pour semaine incomplète",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"AQ5*AQ4","v":164},0,0,0,0,0]
["Début de contrat :",null,null,null,null,"N° Salarié",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JOUR GARDE PREVU",null,null,"TEMPS GARDE"]
["Heures Prévues",null,{"$f":"AP8","v":164},"Congés Payés",{"$f":"COUNTIF(B15:B45,\"CP\")","v":0},"Emploi occupé",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AQ6:AV7)","v":164}]
["Heures Réelles",null,null,"Jours Absences",{"$f":"COUNTIF(B16:B46,\"JA\")","v":0},"Convention Collective des Assistantes\nmaternelles du Particulier Employeur",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date mois","JNG","Jour Ouvré","Semaine","Mois"]
["Jours Gardes Prévus",null,{"$f":"AL10","v":16},"Heures Absences",{"$f":"COUNTIF(B17:B47,\"HA\")","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-09-01","2018-09-05",{"$f":"NETWORKDAYS(AJ10,AJ11,AK10:AK13)","v":16},41,164]
["Jours Gardes Réels",null,{"$f":"COUNTIFS(N15:N45,\">1\")","v":16},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-09-30","2018-09-10"]
["Congés payés",null,{"$f":"IF(ISBLANK(D12),\"\",\"Du\")","v":""},null,{"$f":"IF(ISBLANK(F12),\"\",\"Au\")","v":""},null,null,"Brut","Net",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-09-19"]
["SEMAINE DE GARDE",null,"Mensualisation de Base prévue dans le contrat*",null,null,164,"52 semaines",691.12,533.34,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-09-28"]
[null,null,null,null,null,null,null,null,null,null,"Chiffre jour","Cal JNG","Horaire",1,2,3,"1+2+3","Avant date","N° sem",null,"Chiffre jour",null,null,null,"Calcul jour semaine"]
["2018-09-01",{"$f":"R15","v":"WE"},"*41h00/semaine",null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(A15),\"\",WEEKDAY(A15,2))","v":6},{"$f":"IF(ISNA(MATCH(A15,$AK$10:$AK$15,0)),\"\",\"JNG\")","v":""},{"$f":"IF(K15=6,\"\",IF(K15=7,\"\",IF(K15=1,10.5,IF(K15=2,10.5,IF(K15=3,9.5,IF(K15=4,10,IF(K15=5,10,)))))))","v":""},{"$f":"IF(L15=\"JNG\",\"\",M15)","v":""},{"$f":"L15","v":""},{"$f":"IF(ISBLANK(A15),\"\",IF(AND(N15=\"\",O15=\"\"),\"WE\",\"\"))","v":"WE"},{"$f":"IF(A15<>0,N15&O15&P15,\"\")","v":"WE"},{"$f":"IF(A15<=$O$3,Q15,\"\")","v":"WE"},{"$f":"IF(ISBLANK(A15),\"\",WEEKNUM(A15,2))","v":35},{"$f":"IF(A15>0,S15,\"\")","v":35},{"$f":"INDEX(K15:K45,MATCH(T15,T15:T45,0))","v":6},null,null,null,{"$f":"IF(Z15=7,41,\"\")","v":""},{"$f":"IF(AA16>AA15,COUNTIF($T$15:$T$45,AA15),\"\")","v":2},{"$f":"AB15","v":35},{"$f":"WEEKNUM(AJ10,2)","v":35},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A remplir début de mois"]
["2018-09-02",{"$f":"R16","v":"WE"},"Heures supplémentaires",null,0,"x",3.6,null,{"$f":"E16*G16","v":0},null,{"$f":"IF(ISBLANK(A16),\"\",WEEKDAY(A16,2))","v":7},"","",{"$f":"IF(L16=\"JNG\",\"\",M16)","v":""},{"$f":"L16","v":""},{"$f":"IF(ISBLANK(A16),\"\",IF(AND(N16=\"\",O16=\"\"),\"WE\",\"\"))","v":"WE"},"WE",{"$f":"IF(A16<=$O$3,Q16,\"\")","v":"WE"},{"$f":"IF(ISBLANK(A16),\"\",WEEKNUM(A16,2))","v":35},{"$f":"IF(A16>0,S16,\"\")","v":35},{"$f":"INDEX(K16:K46,MATCH(T16,T16:T46,0))","v":7},null,null,null,41,7,{"$f":"IF(AA15<$AB$16,AA15+1,\"\")","v":36},{"$f":"WEEKNUM(AJ11,2)","v":39}]
["2018-09-03","10,5","Réduction Jour d'Absence",null,{"$f":"E9","v":0},"x",0,null,{"$f":"E17*G17","v":0},null,1,"",10.5,10.5,"","","10,5","10,5",36,36,1,null,null,null,41,7,37]
["2018-09-04","10,5","ou Heure d'Absence",null,{"$f":"E10","v":0},"x",3,null,{"$f":"E18*G18","v":0},null,2,"",10.5,10.5,"","","10,5","10,5",36,36,2,null,null,null,41,7,38]
["2018-09-05","JNG",null,null,null,"Net à verser (1)",null,"NET",{"$f":"(I13+I16)-I17-I18","v":533.34},null,3,"JNG",9.5,"","JNG","","JNG","JNG",36,36,3,null,null,null,41,7,39]
["2018-09-06","10",null,null,null,null,null,"BRUT",{"$f":"(I19*100)/76.64","v":695.90292275574109},null,4,"",10,10,"","","10","10",36,36,4,null,null,null,"","",""]
["2018-09-07","10","Calcul des Cotisations Salariales",null,null,null,null,null,null,null,5,"",10,10,"","","10","10",36,36,5,null,null,null,"",{"$f":"IF(AG17>AA21,COUNTIF($T$15:$T$45,AA21),\"\")","v":""},""]
["2018-09-08","WE",null,null,null,"BASE","TAUX",null,null,null,6,"","","","","WE","WE","WE",36,36,6]
["2018-09-09","WE","CSG non imposable",null,null,{"$f":"(H13*98.25)/100","v":679.02539999999999},6.8,null,{"$f":"(F23*G23)/100","v":46.173727199999995},null,7,"","","","","WE","WE","WE",36,36,7]
["2018-09-10","JNG","CSG +RDS imposable",null,null,{"$f":"(H13*98.25)/100","v":679.02539999999999},2.4,null,16.2966096,null,1,"JNG",10.5,"","JNG","","JNG","JNG",37,37,1]
["2018-09-11","10,5","Sécurité Sociale",null,null,{"$f":"H13","v":691.12},8.0500000000000007,null,55.635160000000006,null,2,"",10.5,10.5,"","","10,5","10,5",37,37,2]
["2018-09-12","9,5","Chômage",null,null,{"$f":"H13","v":691.12},0.95,null,6.5656399999999993,null,3,"",9.5,9.5,"","","9,5","9,5",37,37,3]
["2018-09-13","10","AGFF",null,null,{"$f":"H13","v":691.12},0.8,null,5.5289600000000005,null,4,"",10,10,"","","10","10",37,37,4]
["2018-09-14","","IRCEM (retraite cpl)",null,null,{"$f":"H13","v":691.12},3.1,null,21.424720000000001,null,5,"",10,10,"","","10","",37,37,5]
["2018-09-15","","Prévoyance",null,null,{"$f":"H13","v":691.12},1.1499999999999999,null,{"$f":"F29*(G29/100)","v":7.9478799999999996},null,6,"","","","","WE","WE","",37,37,6]
["2018-09-16","",null,null,null,"Total des cotisations salariales",null,null,{"$f":"SUM(I23:I29)","v":159.57269680000002},null,7,"","","","","WE","WE","",37,37,7]
["2018-09-17","","Calcul des Indemnités",null,null,null,null,null,null,null,1,"",10.5,10.5,"","","10,5","",38,38,1]
["2018-09-18","","Indemnités nourriture",null,0,"x",3,null,{"$f":"E32*G32","v":0},null,2,"",10.5,10.5,"","","10,5","",38,38,2]
["2018-09-19","","Indemnités entretien",null,{"$f":"C11","v":16},"x",3.54,null,{"$f":"E33*G33","v":56.64},null,3,"JNG",9.5,"","JNG","","JNG","",38,38,3]
["2018-09-20","","Indemnités de rupture",null,0,"x",{"$f":"1/120","v":8.3333333333333332E-3},null,{"$f":"(G34)*E34","v":0},null,4,"",10,10,"","","10","",38,38,4]
["2018-09-21","",null,null,null,null,"Net à verser (2)",null,{"$f":"I32+I33+I34","v":56.64},null,5,"",10,10,"","","10","",38,38,5]
["2018-09-22","","Observations",null,"Adaptation Août 2018 de 15h00\nsoit",null,null,null,"Net à verser (3)",null,6,"","","","","WE","WE","",38,38,6]
["2018-09-23","",null,null,null,null,null,null,null,null,7,"","","","","WE","WE","",38,38,7]
["2018-09-24",null,null,null,null,null,null,null,{"$f":"15*3","v":45},null,1,"",10.5,10.5,"","","10,5","",39,39,1]
["2018-09-25",null,"Net à payer (1+2+3)",null,null,"=>",null,null,{"$f":"I35+I19+I38","v":634.98},null,2,"",10.5,10.5,"","","10,5","",39,39,2]
["2018-09-26",null,"Date du Paiement ",null,null,null,"Signature",null,"f",null,3,"",9.5,9.5,"","","9,5","",39,39,3]
["2018-09-27",null,"Moyen de Paiement",null,"Chèque",null,null,null,null,null,4,"",10,10,"","","10","",39,39,4]
["2018-09-28","","NET IMPOSABLE (sans indemnités)",null,null,null,null,null,{"$f":"I19+I38","v":578.34},null,5,"JNG",10,"","JNG","","JNG","",39,39,5]
["2018-09-29","","NET IMPOSABLE (avec indemnités)",null,null,null,null,null,{"$f":"I39","v":634.98},null,6,"","","","","WE","WE","",39,39,6]
["2018-09-30","","CUMUL ANNUEL NET IMPOSABLE (sans indemnités)",null,null,null,null,null,{"$f":"IF(I39<>0,I42,\"…€\")","v":578.34},null,7,"","","","","WE","WE","",39,39,7]
[null,"","CUMUL ANNUEL NET IMPOSABLE (avec indemnités)",null,null,null,null,null,{"$f":"IF(I39<>0,I43,\"…€\")","v":634.98},null,"","",{"$f":"IF(K45=6,\"\",IF(K45=7,\"\",IF(K45=1,10.5,IF(K45=2,10.5,IF(K45=3,9.5,IF(K45=4,10,IF(K45=5,10,\"\")))))))","v":""},{"$f":"IF(L45=\"JNG\",\"\",M45)","v":""},"","","","","","",""]
["Conservez ce bulletin de salaire sans limitation de durée. La loi 91. 1406 du 31/12/1991 ainsi que le décret n°  92. 660  du 13/07/1992 suppriment l'obligation des cotisations patronales.Taux en vigueur au 01 / 01 / 2017\n"]