{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Informations employés","Calculateur de paie","Fiches de paie individuelles"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Informations employés","index":0,"n_rows":7,"n_cols":13,"rows_kept":7,"merged":[[1,0,1,12],[2,0,2,5]]}
[]
["Informations employés"]
["[Nom de l’entreprise]"]
["Référence employé","Nom de l’employé","Salaire horaire","Statut d’imposition","Taxe nationale","Taxe régionale","Impôt fédéral sur le revenu (basé sur \nla taxe nationale)","Cotisations sécurité sociale","Contribution d’assurance santé","Total des taxes perçues","Déduction assurance","Autres déductions normales","Total des déductions \nnormales (taxes exclues)"]
[1,"Jesper Aaberg",{"v":10,"d":"10.00 €"},1,4,{"v":0.023,"d":"2.30%"},{"v":0.28,"d":"28.00%"},{"v":0.063,"d":"6.30%"},{"v":0.0145,"d":"1.45%"},{"$f":"Tableau1[[#This Row],[Taxe régionale]]+Tableau1[[#This Row],[Impôt fédéral sur le revenu (basé sur \nla taxe nationale)]]+Tableau1[[#This Row],[Cotisations sécurité sociale]]+Tableau1[[#This Row],[Contribution d’assurance santé]]","v":{"v":0.38050000000000006,"d":"38.05%"}},{"v":20,"d":"20.00 €"},{"v":40,"d":"40.00 €"},{"$f":"Tableau1[[#This Row],[Déduction assurance]]+Tableau1[[#This Row],[Autres déductions normales]]","v":{"v":60,"d":"60.00 €"}}]
[2,"Wilson Pais",{"v":13,"d":"13.00 €"},1,4,{"v":0.023,"d":"2.30%"},{"v":0.28,"d":"28.00%"},{"v":0.063,"d":"6.30%"},{"v":0.0145,"d":"1.45%"},{"$f":"Tableau1[[#This Row],[Taxe régionale]]+Tableau1[[#This Row],[Impôt fédéral sur le revenu (basé sur \nla taxe nationale)]]+Tableau1[[#This Row],[Cotisations sécurité sociale]]+Tableau1[[#This Row],[Contribution d’assurance santé]]","v":{"v":0.38050000000000006,"d":"38.05%"}},{"v":20,"d":"20.00 €"},{"v":52,"d":"52.00 €"},{"$f":"Tableau1[[#This Row],[Déduction assurance]]+Tableau1[[#This Row],[Autres déductions normales]]","v":{"v":72,"d":"72.00 €"}}]
[3,"Kathie Flood",{"v":10,"d":"10.00 €"},1,4,{"v":0.023,"d":"2.30%"},{"v":0.28,"d":"28.00%"},{"v":0.063,"d":"6.30%"},{"v":0.0145,"d":"1.45%"},{"$f":"Tableau1[[#This Row],[Taxe régionale]]+Tableau1[[#This Row],[Impôt fédéral sur le revenu (basé sur \nla taxe nationale)]]+Tableau1[[#This Row],[Cotisations sécurité sociale]]+Tableau1[[#This Row],[Contribution d’assurance santé]]","v":{"v":0.38050000000000006,"d":"38.05%"}},{"v":20,"d":"20.00 €"},0,{"$f":"Tableau1[[#This Row],[Déduction assurance]]+Tableau1[[#This Row],[Autres déductions normales]]","v":{"v":20,"d":"20.00 €"}}]

{"sheet":"Calculateur de paie","index":1,"n_rows":7,"n_cols":11,"rows_kept":7,"merged":[[0,0,1,8],[2,0,2,5]]}
["Calculateur de paie"]
[{"$nulls":9},"Fin période :",{"v":45688,"d":"4568800.00%"}]
[{"$f":"'Informations employés'!$A$3","v":"[Nom de l’entreprise]"}]
["Référence employé","Nom de l’employé","Heures normales \nde travail","Heures de congés","Heures d’arrêt maladie","Heures supplémentaires","Taux heures sup.","Salaire brut","Taxes et déductions ","Autres déductions","Salaire net"]
[1,{"$f":"VLOOKUP(A5,Tableau1[],2,FALSE)","v":"Jesper Aaberg"},{"v":50,"d":"50.00"},{"v":5,"d":"5.00"},{"v":1,"d":"1.00"},null,null,{"$f":"(VLOOKUP(A5,Tableau1[],3,FALSE)*(Tableau2[[#This Row],[Heures normales \nde travail]]+Tableau2[[#This Row],[Heures de congés]]+Tableau2[[#This Row],[Heures d’arrêt maladie]])+Tableau2[[#This Row],[Heures supplémentaires]]*Tableau2[[#This Row],[Taux heures sup.]])","v":{"v":560,"d":"560.00 €"}},{"$f":"VLOOKUP(A5,Tableau1[],10,FALSE)*Tableau2[[#This Row],[Salaire brut]]+Tableau1[[#This Row],[Total des déductions \nnormales (taxes exclues)]]","v":{"v":273.08000000000004,"d":"273.08 €"}},{"v":20,"d":"20.00 €"},{"$f":"Tableau2[[#This Row],[Salaire brut]]-Tableau2[[#This Row],[Taxes et déductions ]]-Tableau2[[#This Row],[Autres déductions]]","v":{"v":266.91999999999996,"d":"266.92 €"}}]
[2,{"$f":"VLOOKUP(A6,Tableau1[],2,FALSE)","v":"Wilson Pais"},{"v":40,"d":"40.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,null,{"$f":"(VLOOKUP(A6,Tableau1[],3,FALSE)*(Tableau2[[#This Row],[Heures normales \nde travail]]+Tableau2[[#This Row],[Heures de congés]]+Tableau2[[#This Row],[Heures d’arrêt maladie]])+Tableau2[[#This Row],[Heures supplémentaires]]*Tableau2[[#This Row],[Taux heures sup.]])","v":{"v":520,"d":"520.00 €"}},{"$f":"VLOOKUP(A6,Tableau1[],10,FALSE)*Tableau2[[#This Row],[Salaire brut]]+Tableau1[[#This Row],[Total des déductions \nnormales (taxes exclues)]]","v":{"v":269.86,"d":"269.86 €"}},{"v":52,"d":"52.00 €"},{"$f":"Tableau2[[#This Row],[Salaire brut]]-Tableau2[[#This Row],[Taxes et déductions ]]-Tableau2[[#This Row],[Autres déductions]]","v":{"v":198.14,"d":"198.14 €"}}]
[3,{"$f":"VLOOKUP(A7,Tableau1[],2,FALSE)","v":"Kathie Flood"},{"v":52,"d":"52.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":2,"d":"2.00"},{"v":20,"d":"20.00 €"},{"$f":"(VLOOKUP(A7,Tableau1[],3,FALSE)*(Tableau2[[#This Row],[Heures normales \nde travail]]+Tableau2[[#This Row],[Heures de congés]]+Tableau2[[#This Row],[Heures d’arrêt maladie]])+Tableau2[[#This Row],[Heures supplémentaires]]*Tableau2[[#This Row],[Taux heures sup.]])","v":{"v":560,"d":"560.00 €"}},{"$f":"VLOOKUP(A7,Tableau1[],10,FALSE)*Tableau2[[#This Row],[Salaire brut]]+Tableau1[[#This Row],[Total des déductions \nnormales (taxes exclues)]]","v":{"v":233.08000000000004,"d":"233.08 €"}},{"v":20,"d":"20.00 €"},{"$f":"Tableau2[[#This Row],[Salaire brut]]-Tableau2[[#This Row],[Taxes et déductions ]]-Tableau2[[#This Row],[Autres déductions]]","v":{"v":306.91999999999996,"d":"306.92 €"}}]

{"sheet":"Fiches de paie individuelles","index":2,"n_rows":48,"n_cols":8,"rows_kept":48,"merged":[[1,2,1,7],[13,2,13,7],[25,2,25,7],[38,2,38,7]]}
[]
[null,null,{"$f":"('Informations employés'!$A$3)","v":"[Nom de l’entreprise]"}]
[null,null,"Période :",{"$f":"'Calculateur de paie'!$K$2","v":{"v":45688,"d":"4568800.00%"}},"Nom de l’employé",{"$f":"IFERROR(VLOOKUP(H3,Tableau1[],2),\"\")","v":"Jesper Aaberg"},"Référence employé",1]
[]
[null,null,"Statut d’imposition",{"$f":"IFERROR(VLOOKUP(H3,Tableau1[],4),\"\")","v":1},"Taxe nationale",{"$f":"IFERROR(VLOOKUP(H3,Tableau1[],5,FALSE),\"\")","v":4},"Heures de travail",{"$f":"IFERROR(VLOOKUP(H3,Tableau2[],3,FALSE),\"\")","v":50}]
[null,null,"Taux horaire",{"$f":"IFERROR(VLOOKUP(H3,Tableau1[],3,FALSE),\"\")","v":{"v":10,"d":"10.00 €"}},"Taux heures sup.",{"$f":"IFERROR(VLOOKUP(H3,Tableau2[],7,FALSE),\"\")","v":0},"Heures d’arrêt maladie",{"$f":"IFERROR(VLOOKUP(H3,Tableau2[],5,FALSE),\"\")","v":1}]
[null,null,"Cotisations sécurité sociale ",{"$f":"IFERROR(IFERROR(VLOOKUP(H3,Tableau1[],8,FALSE),\"\")*H9,\"\")","v":{"v":35.28,"d":"35.28 €"}},"Impôt fédéral sur le revenu ",{"$f":"IFERROR(IFERROR(VLOOKUP(H3,Tableau1[],7,FALSE),\"\")*H9,\"\")","v":{"v":156.8,"d":"156.80 €"}},"Heures de congés",{"$f":"IFERROR(VLOOKUP(H3,Tableau2[],4,FALSE),\"\")","v":5}]
[null,null,"Contribution au titre de la sécurité sociale ",{"$f":"IFERROR(IFERROR(VLOOKUP(H3,Tableau1[],9,FALSE),\"\")*H9,\"\")","v":{"v":8.120000000000001,"d":"8.12 €"}},"Taxe régionale ",{"$f":"IFERROR(IFERROR(VLOOKUP(H3,Tableau1[],6,FALSE),\"\")*H9,\"\")","v":{"v":12.879999999999999,"d":"12.88 €"}},"Heures supplémentaires",{"$f":"IFERROR(VLOOKUP(H3,Tableau2[],6,FALSE),\"\")","v":0}]
[null,null,"Déduction assurance",{"$f":"IFERROR(VLOOKUP(H3,Tableau1[],11,FALSE),\"\")","v":{"v":20,"d":"20.00 €"}},"Autres déductions normales",{"$f":"IFERROR(VLOOKUP(H3,Tableau1[],12,FALSE),\"\")","v":{"v":40,"d":"40.00 €"}},"Salaire brut",{"$f":"IFERROR(VLOOKUP(H3,Tableau2[],8,FALSE),\"\")","v":{"v":560,"d":"560.00 €"}}]
[null,null,"Total des taxes et déductions normales ",{"$f":"IFERROR(SUM(F7:F9)+SUM(D7:D9),\"\")","v":{"v":273.08000000000004,"d":"273.08 €"}},"Autres déductions",{"$f":"IFERROR(VLOOKUP(H3,Tableau2[],10,FALSE),\"\")","v":{"v":20,"d":"20.00 €"}},"Total des taxes et déductions ",{"$f":"IFERROR(IFERROR(VLOOKUP(H3,Tableau2[],9,FALSE),\"\")+F10,\"\")","v":{"v":293.08000000000004,"d":"293.08 €"}}]
[{"$nulls":6},"Salaire net",{"$f":"IFERROR(VLOOKUP(H3,Tableau2[],11,FALSE),\"\")","v":{"v":266.91999999999996,"d":"266.92 €"}}]
[]
[]
[null,null,{"$f":"('Informations employés'!$A$3)","v":"[Nom de l’entreprise]"}]
[null,null,"Période :",{"$f":"'Calculateur de paie'!$K$2","v":{"v":45688,"d":"4568800.00%"}},"Nom de l’employé",{"$f":"IFERROR(VLOOKUP(H15,Tableau1[],2),\"\")","v":"Wilson Pais"},"Référence employé",2]
[]
[null,null,"Statut d’imposition",{"$f":"IFERROR(VLOOKUP(H15,Tableau1[],4),\"\")","v":1},"Taxe nationale",{"$f":"IFERROR(VLOOKUP(H15,Tableau1[],5,FALSE),\"\")","v":4},"Heures de travail",{"$f":"IFERROR(VLOOKUP(H15,Tableau2[],3,FALSE),\"\")","v":40}]
[null,null,"Taux horaire",{"$f":"IFERROR(VLOOKUP(H15,Tableau1[],3,FALSE),\"\")","v":{"v":13,"d":"13.00 €"}},"Taux heures sup.",{"$f":"IFERROR(VLOOKUP(H15,Tableau2[],7,FALSE),\"\")","v":0},"Heures d’arrêt maladie",{"$f":"IFERROR(VLOOKUP(H15,Tableau2[],5,FALSE),\"\")","v":0}]
[null,null,"Cotisations sécurité sociale ",{"$f":"IFERROR(IFERROR(VLOOKUP(H15,Tableau1[],8,FALSE),\"\")*H21,\"\")","v":{"v":32.76,"d":"32.76 €"}},"Impôt fédéral sur le revenu ",{"$f":"IFERROR(IFERROR(VLOOKUP(H15,Tableau1[],7,FALSE),\"\")*H21,\"\")","v":{"v":145.60000000000002,"d":"145.60 €"}},"Heures de congés",{"$f":"IFERROR(VLOOKUP(H15,Tableau2[],4,FALSE),\"\")","v":0}]
[null,null,"Contribution au titre de la sécurité sociale ",{"$f":"IFERROR(IFERROR(VLOOKUP(H15,Tableau1[],9,FALSE),\"\")*H21,\"\")","v":{"v":7.54,"d":"7.54 €"}},"Taxe régionale ",{"$f":"IFERROR(IFERROR(VLOOKUP(H15,Tableau1[],6,FALSE),\"\")*H21,\"\")","v":{"v":11.959999999999999,"d":"11.96 €"}},"Heures supplémentaires",{"$f":"IFERROR(VLOOKUP(H15,Tableau2[],6,FALSE),\"\")","v":0}]
[null,null,"Déduction assurance",{"$f":"IFERROR(VLOOKUP(H15,Tableau1[],11,FALSE),\"\")","v":{"v":20,"d":"20.00 €"}},"Autres déductions normales",{"$f":"IFERROR(VLOOKUP(H15,Tableau1[],12,FALSE),\"\")","v":{"v":52,"d":"52.00 €"}},"Salaire brut",{"$f":"IFERROR(VLOOKUP(H15,Tableau2[],8,FALSE),\"\")","v":{"v":520,"d":"520.00 €"}}]
[null,null,"Total des taxes et déductions normales ",{"$f":"IFERROR(SUM(F19:F21)+SUM(D19:D21),\"\")","v":{"v":269.86,"d":"269.86 €"}},"Autres déductions",{"$f":"IFERROR(VLOOKUP(H15,Tableau2[],10,FALSE),\"\")","v":{"v":52,"d":"52.00 €"}},"Total des taxes et déductions ",{"$f":"IFERROR(IFERROR(VLOOKUP(H15,Tableau2[],9,FALSE),\"\")+F22,\"\")","v":{"v":321.86,"d":"321.86 €"}}]
[{"$nulls":6},"Salaire net",{"$f":"IFERROR(VLOOKUP(H15,Tableau2[],11,FALSE),\"\")","v":{"v":198.14,"d":"198.14 €"}}]
[]
[]
[null,null,{"$f":"('Informations employés'!$A$3)","v":"[Nom de l’entreprise]"}]
[null,null,"Période :",{"$f":"'Calculateur de paie'!$K$2","v":{"v":45688,"d":"4568800.00%"}},"Nom de l’employé",{"$f":"IFERROR(VLOOKUP(H27,Tableau1[],2),\"\")","v":"Kathie Flood"},"Référence employé",3]
[]
[null,null,"Statut d’imposition",{"$f":"IFERROR(VLOOKUP(H27,Tableau1[],4),\"\")","v":1},"Taxe nationale",{"$f":"IFERROR(VLOOKUP(H27,Tableau1[],5,FALSE),\"\")","v":4},"Heures de travail",{"$f":"IFERROR(VLOOKUP(H27,Tableau2[],3,FALSE),\"\")","v":52}]
[null,null,"Taux horaire",{"$f":"IFERROR(VLOOKUP(H27,Tableau1[],3,FALSE),\"\")","v":{"v":10,"d":"10.00 €"}},"Taux heures sup.",{"$f":"IFERROR(VLOOKUP(H27,Tableau2[],7,FALSE),\"\")","v":{"v":20,"d":"20.00 €"}},"Heures d’arrêt maladie",{"$f":"IFERROR(VLOOKUP(H27,Tableau2[],5,FALSE),\"\")","v":0}]
[null,null,"Cotisations sécurité sociale ",{"$f":"IFERROR(IFERROR(VLOOKUP(H27,Tableau1[],8,FALSE),\"\")*H33,\"\")","v":{"v":35.28,"d":"35.28 €"}},"Impôt fédéral sur le revenu ",{"$f":"IFERROR(IFERROR(VLOOKUP(H27,Tableau1[],7,FALSE),\"\")*H33,\"\")","v":{"v":156.8,"d":"156.80 €"}},"Heures de congés",{"$f":"IFERROR(VLOOKUP(H27,Tableau2[],4,FALSE),\"\")","v":0}]
[null,null,"Contribution au titre de la sécurité sociale ",{"$f":"IFERROR(IFERROR(VLOOKUP(H27,Tableau1[],9,FALSE),\"\")*H33,\"\")","v":{"v":8.120000000000001,"d":"8.12 €"}},"Taxe régionale ",{"$f":"IFERROR(IFERROR(VLOOKUP(H27,Tableau1[],6,FALSE),\"\")*H33,\"\")","v":{"v":12.879999999999999,"d":"12.88 €"}},"Heures supplémentaires",{"$f":"IFERROR(VLOOKUP(H27,Tableau2[],6,FALSE),\"\")","v":2}]
[null,null,"Déduction assurance",{"$f":"IFERROR(VLOOKUP(H27,Tableau1[],11,FALSE),\"\")","v":{"v":20,"d":"20.00 €"}},"Autres déductions normales",{"$f":"IFERROR(VLOOKUP(H27,Tableau1[],12,FALSE),\"\")","v":0},"Salaire brut",{"$f":"IFERROR(VLOOKUP(H27,Tableau2[],8,FALSE),\"\")","v":{"v":560,"d":"560.00 €"}}]
[null,null,"Total des taxes et déductions normales ",{"$f":"IFERROR(SUM(F31:F33)+SUM(D31:D33),\"\")","v":{"v":233.08,"d":"233.08 €"}},"Autres déductions",{"$f":"IFERROR(VLOOKUP(H27,Tableau2[],10,FALSE),\"\")","v":{"v":20,"d":"20.00 €"}},"Total des taxes et déductions ",{"$f":"IFERROR(IFERROR(VLOOKUP(H27,Tableau2[],9,FALSE),\"\")+F34,\"\")","v":{"v":253.08000000000004,"d":"253.08 €"}}]
[{"$nulls":6},"Salaire net",{"$f":"IFERROR(VLOOKUP(H27,Tableau2[],11,FALSE),\"\")","v":{"v":306.91999999999996,"d":"306.92 €"}}]
[]
[]
[]
[null,null,{"$f":"('Informations employés'!$A$3)","v":"[Nom de l’entreprise]"}]
[null,null,"Période :",{"$f":"'Calculateur de paie'!$K$2","v":{"v":45688,"d":"4568800.00%"}},"Nom de l’employé",{"$f":"IFERROR(VLOOKUP(H40,Tableau1[],2),\"\")","v":""},"Référence employé"]
[]
[null,null,"Statut d’imposition",{"$f":"IFERROR(VLOOKUP(H40,Tableau1[],4),\"\")","v":""},"Taxe nationale",{"$f":"IFERROR(VLOOKUP(H40,Tableau1[],5,FALSE),\"\")","v":""},"Heures de travail",{"$f":"IFERROR(VLOOKUP(H40,Tableau2[],3,FALSE),\"\")","v":""}]
[null,null,"Taux horaire",{"$f":"IFERROR(VLOOKUP(H40,Tableau1[],3,FALSE),\"\")","v":""},"Taux heures sup.",{"$f":"IFERROR(VLOOKUP(H40,Tableau2[],7,FALSE),\"\")","v":""},"Heures d’arrêt maladie",{"$f":"IFERROR(VLOOKUP(H40,Tableau2[],5,FALSE),\"\")","v":""}]
[null,null,"Cotisations sécurité sociale ",{"$f":"IFERROR(IFERROR(VLOOKUP(H40,Tableau1[],8,FALSE),\"\")*H46,\"\")","v":""},"Impôt fédéral sur le revenu ",{"$f":"IFERROR(IFERROR(VLOOKUP(H40,Tableau1[],7,FALSE),\"\")*H46,\"\")","v":""},"Heures de congés",{"$f":"IFERROR(VLOOKUP(H40,Tableau2[],4,FALSE),\"\")","v":""}]
[null,null,"Contribution au titre de la sécurité sociale ",{"$f":"IFERROR(IFERROR(VLOOKUP(H40,Tableau1[],9,FALSE),\"\")*H46,\"\")","v":""},"Taxe régionale ",{"$f":"IFERROR(IFERROR(VLOOKUP(H40,Tableau1[],6,FALSE),\"\")*H46,\"\")","v":""},"Heures supplémentaires",{"$f":"IFERROR(VLOOKUP(H40,Tableau2[],6,FALSE),\"\")","v":""}]
[null,null,"Déduction assurance",{"$f":"IFERROR(VLOOKUP(H40,Tableau1[],11,FALSE),\"\")","v":""},"Autres déductions normales",{"$f":"IFERROR(VLOOKUP(H40,Tableau1[],12,FALSE),\"\")","v":""},"Salaire brut",{"$f":"IFERROR(VLOOKUP(H40,Tableau2[],8,FALSE),\"\")","v":""}]
[null,null,"Total des taxes et déductions normales ",{"$f":"IFERROR(SUM(F44:F46)+SUM(D44:D46),\"\")","v":0},"Autres déductions",{"$f":"IFERROR(VLOOKUP(H40,Tableau2[],10,FALSE),\"\")","v":""},"Total des taxes et déductions ",{"$f":"IFERROR(IFERROR(VLOOKUP(H40,Tableau2[],9,FALSE),\"\")+F47,\"\")","v":""}]
[{"$nulls":6},"Salaire net",{"$f":"IFERROR(VLOOKUP(H40,Tableau2[],11,FALSE),\"\")","v":""}]