{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Informatie over werknemers","Loonkostencalculator","Afzonderlijke loonstrookjes"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Informatie over werknemers","index":0,"n_rows":7,"n_cols":13,"rows_kept":7,"merged":[[1,0,1,12],[2,0,2,5]]}
[]
["Informatie over werknemers"]
["[Bedrijfsnaam]"]
["Werknemer-ID","Naam werknemer","Uurloon","Fiscale status","Overheidstoelage (W4)","Provinciale belasting","Inkomstenbelasting (percentage, gebaseerd op overheidstoelage)","Sociale zekerheidsbelasting","Medicare, Amerikaanse ziektekostenverzekering","Totaal ingehouden belasting","Verzekeringsaftrek","Andere gewone aftrek","Totale reguliere aftrek (exclusief belastingen)"]
[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":"Tabel1[[#This Row],[Provinciale belasting]]+Tabel1[[#This Row],[Inkomstenbelasting (percentage, gebaseerd op overheidstoelage)]]+Tabel1[[#This Row],[Sociale zekerheidsbelasting]]+Tabel1[[#This Row],[Medicare, Amerikaanse ziektekostenverzekering]]","v":{"v":0.38050000000000006,"d":"38.05%"}},{"v":20,"d":"€ 20.00"},{"v":40,"d":"€ 40.00"},{"$f":"Tabel1[[#This Row],[Verzekeringsaftrek]]+Tabel1[[#This Row],[Andere gewone aftrek]]","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":"Tabel1[[#This Row],[Provinciale belasting]]+Tabel1[[#This Row],[Inkomstenbelasting (percentage, gebaseerd op overheidstoelage)]]+Tabel1[[#This Row],[Sociale zekerheidsbelasting]]+Tabel1[[#This Row],[Medicare, Amerikaanse ziektekostenverzekering]]","v":{"v":0.38050000000000006,"d":"38.05%"}},{"v":20,"d":"€ 20.00"},{"v":52,"d":"€ 52.00"},{"$f":"Tabel1[[#This Row],[Verzekeringsaftrek]]+Tabel1[[#This Row],[Andere gewone aftrek]]","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":"Tabel1[[#This Row],[Provinciale belasting]]+Tabel1[[#This Row],[Inkomstenbelasting (percentage, gebaseerd op overheidstoelage)]]+Tabel1[[#This Row],[Sociale zekerheidsbelasting]]+Tabel1[[#This Row],[Medicare, Amerikaanse ziektekostenverzekering]]","v":{"v":0.38050000000000006,"d":"38.05%"}},{"v":20,"d":"€ 20.00"},0,{"$f":"Tabel1[[#This Row],[Verzekeringsaftrek]]+Tabel1[[#This Row],[Andere gewone aftrek]]","v":{"v":20,"d":"€ 20.00"}}]

{"sheet":"Loonkostencalculator","index":1,"n_rows":7,"n_cols":11,"rows_kept":7,"merged":[[0,0,1,8],[2,0,2,5]]}
["Loonkostencalculator"]
[{"$nulls":9},"Periode eindigend op:",{"v":45688,"d":"4568800.00%"}]
[{"$f":"'Informatie over werknemers'!$A$3","v":"[Bedrijfsnaam]"}]
["Werknemer-ID","Naam werknemer","Normale gewerkte uren","Vakantie-uren","Ziekteverlof","Overuren","Overurentarief","Brutosalaris","Belastingen en inhoudingen ","Overige inhoudingen","Nettosalaris"]
[1,{"$f":"VLOOKUP(A5,Tabel1[],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,Tabel1[],3,FALSE)*(Tabel2[[#This Row],[Normale gewerkte uren]]+Tabel2[[#This Row],[Vakantie-uren]]+Tabel2[[#This Row],[Ziekteverlof]])+Tabel2[[#This Row],[Overuren]]*Tabel2[[#This Row],[Overurentarief]])","v":{"v":560,"d":"€ 560.00"}},{"$f":"VLOOKUP(A5,Tabel1[],10,FALSE)*Tabel2[[#This Row],[Brutosalaris]]+Tabel1[[#This Row],[Totale reguliere aftrek (exclusief belastingen)]]","v":{"v":273.08000000000004,"d":"€ 273.08"}},{"v":20,"d":"€ 20.00"},{"$f":"Tabel2[[#This Row],[Brutosalaris]]-Tabel2[[#This Row],[Belastingen en inhoudingen ]]-Tabel2[[#This Row],[Overige inhoudingen]]","v":{"v":266.91999999999996,"d":"€ 266.92"}}]
[2,{"$f":"VLOOKUP(A6,Tabel1[],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,Tabel1[],3,FALSE)*(Tabel2[[#This Row],[Normale gewerkte uren]]+Tabel2[[#This Row],[Vakantie-uren]]+Tabel2[[#This Row],[Ziekteverlof]])+Tabel2[[#This Row],[Overuren]]*Tabel2[[#This Row],[Overurentarief]])","v":{"v":520,"d":"€ 520.00"}},{"$f":"VLOOKUP(A6,Tabel1[],10,FALSE)*Tabel2[[#This Row],[Brutosalaris]]+Tabel1[[#This Row],[Totale reguliere aftrek (exclusief belastingen)]]","v":{"v":269.86,"d":"€ 269.86"}},{"v":52,"d":"€ 52.00"},{"$f":"Tabel2[[#This Row],[Brutosalaris]]-Tabel2[[#This Row],[Belastingen en inhoudingen ]]-Tabel2[[#This Row],[Overige inhoudingen]]","v":{"v":198.14,"d":"€ 198.14"}}]
[3,{"$f":"VLOOKUP(A7,Tabel1[],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,Tabel1[],3,FALSE)*(Tabel2[[#This Row],[Normale gewerkte uren]]+Tabel2[[#This Row],[Vakantie-uren]]+Tabel2[[#This Row],[Ziekteverlof]])+Tabel2[[#This Row],[Overuren]]*Tabel2[[#This Row],[Overurentarief]])","v":{"v":560,"d":"€ 560.00"}},{"$f":"VLOOKUP(A7,Tabel1[],10,FALSE)*Tabel2[[#This Row],[Brutosalaris]]+Tabel1[[#This Row],[Totale reguliere aftrek (exclusief belastingen)]]","v":{"v":233.08000000000004,"d":"€ 233.08"}},{"v":20,"d":"€ 20.00"},{"$f":"Tabel2[[#This Row],[Brutosalaris]]-Tabel2[[#This Row],[Belastingen en inhoudingen ]]-Tabel2[[#This Row],[Overige inhoudingen]]","v":{"v":306.91999999999996,"d":"€ 306.92"}}]

{"sheet":"Afzonderlijke loonstrookjes","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":"('Informatie over werknemers'!$A$3)","v":"[Bedrijfsnaam]"}]
[null,null,"Periode:",{"$f":"Loonkostencalculator!$K$2","v":{"v":45688,"d":"4568800.00%"}},"Naam werknemer",{"$f":"IFERROR(VLOOKUP(H3,Tabel1[],2),\"\")","v":"Jesper Aaberg"},"Werknemer-ID",1]
[]
[null,null,"Fiscale status",{"$f":"IFERROR(VLOOKUP(H3,Tabel1[],4),\"\")","v":1},"Federale toelage (uit W-4)",{"$f":"IFERROR(VLOOKUP(H3,Tabel1[],5,FALSE),\"\")","v":4},"Gewerkte uren",{"$f":"IFERROR(VLOOKUP(H3,Tabel2[],3,FALSE),\"\")","v":50}]
[null,null,"Uurtarief",{"$f":"IFERROR(VLOOKUP(H3,Tabel1[],3,FALSE),\"\")","v":{"v":10,"d":"€ 10.00"}},"Overurentarief",{"$f":"IFERROR(VLOOKUP(H3,Tabel2[],7,FALSE),\"\")","v":0},"Ziekteverlof",{"$f":"IFERROR(VLOOKUP(H3,Tabel2[],5,FALSE),\"\")","v":1}]
[null,null,"Sociale zekerheidsbelasting",{"$f":"IFERROR(IFERROR(VLOOKUP(H3,Tabel1[],8,FALSE),\"\")*H9,\"\")","v":{"v":35.28,"d":"€ 35.28"}},"Federale inkomensbelasting ",{"$f":"IFERROR(IFERROR(VLOOKUP(H3,Tabel1[],7,FALSE),\"\")*H9,\"\")","v":{"v":156.8,"d":"€ 156.80"}},"Vakantie-uren",{"$f":"IFERROR(VLOOKUP(H3,Tabel2[],4,FALSE),\"\")","v":5}]
[null,null,"Zorgverzekeringsbelasting ",{"$f":"IFERROR(IFERROR(VLOOKUP(H3,Tabel1[],9,FALSE),\"\")*H9,\"\")","v":{"v":8.120000000000001,"d":"€ 8.12"}},"Provinciale belasting ",{"$f":"IFERROR(IFERROR(VLOOKUP(H3,Tabel1[],6,FALSE),\"\")*H9,\"\")","v":{"v":12.879999999999999,"d":"€ 12.88"}},"Overuren",{"$f":"IFERROR(VLOOKUP(H3,Tabel2[],6,FALSE),\"\")","v":0}]
[null,null,"Ingehouden verzekeringen",{"$f":"IFERROR(VLOOKUP(H3,Tabel1[],11,FALSE),\"\")","v":{"v":20,"d":"€ 20.00"}},"Andere gewone inhoudingen",{"$f":"IFERROR(VLOOKUP(H3,Tabel1[],12,FALSE),\"\")","v":{"v":40,"d":"€ 40.00"}},"Brutosalaris",{"$f":"IFERROR(VLOOKUP(H3,Tabel2[],8,FALSE),\"\")","v":{"v":560,"d":"€ 560.00"}}]
[null,null,"Totaal van belastingen en normale inhoudingen ",{"$f":"IFERROR(SUM(F7:F9)+SUM(D7:D9),\"\")","v":{"v":273.08000000000004,"d":"€ 273.08"}},"Overige inhoudingen",{"$f":"IFERROR(VLOOKUP(H3,Tabel2[],10,FALSE),\"\")","v":{"v":20,"d":"€ 20.00"}},"Totaal van belastingen en inhoudingen ",{"$f":"IFERROR(IFERROR(VLOOKUP(H3,Tabel2[],9,FALSE),\"\")+F10,\"\")","v":{"v":293.08000000000004,"d":"€ 293.08"}}]
[{"$nulls":6},"Nettosalaris",{"$f":"IFERROR(VLOOKUP(H3,Tabel2[],11,FALSE),\"\")","v":{"v":266.91999999999996,"d":"€ 266.92"}}]
[]
[]
[null,null,{"$f":"('Informatie over werknemers'!$A$3)","v":"[Bedrijfsnaam]"}]
[null,null,"Periode:",{"$f":"Loonkostencalculator!$K$2","v":{"v":45688,"d":"4568800.00%"}},"Naam werknemer",{"$f":"IFERROR(VLOOKUP(H15,Tabel1[],2),\"\")","v":"Wilson Pais"},"Werknemer-ID",2]
[]
[null,null,"Fiscale status",{"$f":"IFERROR(VLOOKUP(H15,Tabel1[],4),\"\")","v":1},"Federale toelage (uit W-4)",{"$f":"IFERROR(VLOOKUP(H15,Tabel1[],5,FALSE),\"\")","v":4},"Gewerkte uren",{"$f":"IFERROR(VLOOKUP(H15,Tabel2[],3,FALSE),\"\")","v":40}]
[null,null,"Uurtarief",{"$f":"IFERROR(VLOOKUP(H15,Tabel1[],3,FALSE),\"\")","v":{"v":13,"d":"€ 13.00"}},"Overurentarief",{"$f":"IFERROR(VLOOKUP(H15,Tabel2[],7,FALSE),\"\")","v":0},"Ziekteverlof",{"$f":"IFERROR(VLOOKUP(H15,Tabel2[],5,FALSE),\"\")","v":0}]
[null,null,"Sociale zekerheidsbelasting",{"$f":"IFERROR(IFERROR(VLOOKUP(H15,Tabel1[],8,FALSE),\"\")*H21,\"\")","v":{"v":32.76,"d":"€ 32.76"}},"Federale inkomensbelasting ",{"$f":"IFERROR(IFERROR(VLOOKUP(H15,Tabel1[],7,FALSE),\"\")*H21,\"\")","v":{"v":145.60000000000002,"d":"€ 145.60"}},"Vakantie-uren",{"$f":"IFERROR(VLOOKUP(H15,Tabel2[],4,FALSE),\"\")","v":0}]
[null,null,"Zorgverzekeringsbelasting ",{"$f":"IFERROR(IFERROR(VLOOKUP(H15,Tabel1[],9,FALSE),\"\")*H21,\"\")","v":{"v":7.54,"d":"€ 7.54"}},"Provinciale belasting ",{"$f":"IFERROR(IFERROR(VLOOKUP(H15,Tabel1[],6,FALSE),\"\")*H21,\"\")","v":{"v":11.959999999999999,"d":"€ 11.96"}},"Overuren",{"$f":"IFERROR(VLOOKUP(H15,Tabel2[],6,FALSE),\"\")","v":0}]
[null,null,"Ingehouden verzekeringen",{"$f":"IFERROR(VLOOKUP(H15,Tabel1[],11,FALSE),\"\")","v":{"v":20,"d":"€ 20.00"}},"Andere gewone inhoudingen",{"$f":"IFERROR(VLOOKUP(H15,Tabel1[],12,FALSE),\"\")","v":{"v":52,"d":"€ 52.00"}},"Brutosalaris",{"$f":"IFERROR(VLOOKUP(H15,Tabel2[],8,FALSE),\"\")","v":{"v":520,"d":"€ 520.00"}}]
[null,null,"Totaal van belastingen en normale inhoudingen ",{"$f":"IFERROR(SUM(F19:F21)+SUM(D19:D21),\"\")","v":{"v":269.86,"d":"€ 269.86"}},"Overige inhoudingen",{"$f":"IFERROR(VLOOKUP(H15,Tabel2[],10,FALSE),\"\")","v":{"v":52,"d":"€ 52.00"}},"Totaal van belastingen en inhoudingen ",{"$f":"IFERROR(IFERROR(VLOOKUP(H15,Tabel2[],9,FALSE),\"\")+F22,\"\")","v":{"v":321.86,"d":"€ 321.86"}}]
[{"$nulls":6},"Nettosalaris",{"$f":"IFERROR(VLOOKUP(H15,Tabel2[],11,FALSE),\"\")","v":{"v":198.14,"d":"€ 198.14"}}]
[]
[]
[null,null,{"$f":"('Informatie over werknemers'!$A$3)","v":"[Bedrijfsnaam]"}]
[null,null,"Periode:",{"$f":"Loonkostencalculator!$K$2","v":{"v":45688,"d":"4568800.00%"}},"Naam werknemer",{"$f":"IFERROR(VLOOKUP(H27,Tabel1[],2),\"\")","v":"Kathie Flood"},"Werknemer-ID",3]
[]
[null,null,"Fiscale status",{"$f":"IFERROR(VLOOKUP(H27,Tabel1[],4),\"\")","v":1},"Federale toelage (uit W-4)",{"$f":"IFERROR(VLOOKUP(H27,Tabel1[],5,FALSE),\"\")","v":4},"Gewerkte uren",{"$f":"IFERROR(VLOOKUP(H27,Tabel2[],3,FALSE),\"\")","v":52}]
[null,null,"Uurtarief",{"$f":"IFERROR(VLOOKUP(H27,Tabel1[],3,FALSE),\"\")","v":{"v":10,"d":"€ 10.00"}},"Overurentarief",{"$f":"IFERROR(VLOOKUP(H27,Tabel2[],7,FALSE),\"\")","v":{"v":20,"d":"€ 20.00"}},"Ziekteverlof",{"$f":"IFERROR(VLOOKUP(H27,Tabel2[],5,FALSE),\"\")","v":0}]
[null,null,"Sociale zekerheidsbelasting",{"$f":"IFERROR(IFERROR(VLOOKUP(H27,Tabel1[],8,FALSE),\"\")*H33,\"\")","v":{"v":35.28,"d":"€ 35.28"}},"Federale inkomensbelasting ",{"$f":"IFERROR(IFERROR(VLOOKUP(H27,Tabel1[],7,FALSE),\"\")*H33,\"\")","v":{"v":156.8,"d":"€ 156.80"}},"Vakantie-uren",{"$f":"IFERROR(VLOOKUP(H27,Tabel2[],4,FALSE),\"\")","v":0}]
[null,null,"Zorgverzekeringsbelasting ",{"$f":"IFERROR(IFERROR(VLOOKUP(H27,Tabel1[],9,FALSE),\"\")*H33,\"\")","v":{"v":8.120000000000001,"d":"€ 8.12"}},"Provinciale belasting ",{"$f":"IFERROR(IFERROR(VLOOKUP(H27,Tabel1[],6,FALSE),\"\")*H33,\"\")","v":{"v":12.879999999999999,"d":"€ 12.88"}},"Overuren",{"$f":"IFERROR(VLOOKUP(H27,Tabel2[],6,FALSE),\"\")","v":2}]
[null,null,"Ingehouden verzekeringen",{"$f":"IFERROR(VLOOKUP(H27,Tabel1[],11,FALSE),\"\")","v":{"v":20,"d":"€ 20.00"}},"Andere gewone inhoudingen",{"$f":"IFERROR(VLOOKUP(H27,Tabel1[],12,FALSE),\"\")","v":0},"Brutosalaris",{"$f":"IFERROR(VLOOKUP(H27,Tabel2[],8,FALSE),\"\")","v":{"v":560,"d":"€ 560.00"}}]
[null,null,"Totaal van belastingen en normale inhoudingen ",{"$f":"IFERROR(SUM(F31:F33)+SUM(D31:D33),\"\")","v":{"v":233.08,"d":"€ 233.08"}},"Overige inhoudingen",{"$f":"IFERROR(VLOOKUP(H27,Tabel2[],10,FALSE),\"\")","v":{"v":20,"d":"€ 20.00"}},"Totaal van belastingen en inhoudingen ",{"$f":"IFERROR(IFERROR(VLOOKUP(H27,Tabel2[],9,FALSE),\"\")+F34,\"\")","v":{"v":253.08000000000004,"d":"€ 253.08"}}]
[{"$nulls":6},"Nettosalaris",{"$f":"IFERROR(VLOOKUP(H27,Tabel2[],11,FALSE),\"\")","v":{"v":306.91999999999996,"d":"€ 306.92"}}]
[]
[]
[]
[null,null,{"$f":"('Informatie over werknemers'!$A$3)","v":"[Bedrijfsnaam]"}]
[null,null,"Periode:",{"$f":"Loonkostencalculator!$K$2","v":{"v":45688,"d":"4568800.00%"}},"Naam werknemer",{"$f":"IFERROR(VLOOKUP(H40,Tabel1[],2),\"\")","v":""},"Werknemer-ID"]
[]
[null,null,"Fiscale status",{"$f":"IFERROR(VLOOKUP(H40,Tabel1[],4),\"\")","v":""},"Federale toelage (uit W-4)",{"$f":"IFERROR(VLOOKUP(H40,Tabel1[],5,FALSE),\"\")","v":""},"Gewerkte uren",{"$f":"IFERROR(VLOOKUP(H40,Tabel2[],3,FALSE),\"\")","v":""}]
[null,null,"Uurtarief",{"$f":"IFERROR(VLOOKUP(H40,Tabel1[],3,FALSE),\"\")","v":""},"Overurentarief",{"$f":"IFERROR(VLOOKUP(H40,Tabel2[],7,FALSE),\"\")","v":""},"Ziekteverlof",{"$f":"IFERROR(VLOOKUP(H40,Tabel2[],5,FALSE),\"\")","v":""}]
[null,null,"Sociale zekerheidsbelasting",{"$f":"IFERROR(IFERROR(VLOOKUP(H40,Tabel1[],8,FALSE),\"\")*H46,\"\")","v":""},"Federale inkomensbelasting ",{"$f":"IFERROR(IFERROR(VLOOKUP(H40,Tabel1[],7,FALSE),\"\")*H46,\"\")","v":""},"Vakantie-uren",{"$f":"IFERROR(VLOOKUP(H40,Tabel2[],4,FALSE),\"\")","v":""}]
[null,null,"Zorgverzekeringsbelasting ",{"$f":"IFERROR(IFERROR(VLOOKUP(H40,Tabel1[],9,FALSE),\"\")*H46,\"\")","v":""},"Provinciale belasting ",{"$f":"IFERROR(IFERROR(VLOOKUP(H40,Tabel1[],6,FALSE),\"\")*H46,\"\")","v":""},"Overuren",{"$f":"IFERROR(VLOOKUP(H40,Tabel2[],6,FALSE),\"\")","v":""}]
[null,null,"Ingehouden verzekeringen",{"$f":"IFERROR(VLOOKUP(H40,Tabel1[],11,FALSE),\"\")","v":""},"Andere gewone inhoudingen",{"$f":"IFERROR(VLOOKUP(H40,Tabel1[],12,FALSE),\"\")","v":""},"Brutosalaris",{"$f":"IFERROR(VLOOKUP(H40,Tabel2[],8,FALSE),\"\")","v":""}]
[null,null,"Totaal van belastingen en normale inhoudingen ",{"$f":"IFERROR(SUM(F44:F46)+SUM(D44:D46),\"\")","v":0},"Overige inhoudingen",{"$f":"IFERROR(VLOOKUP(H40,Tabel2[],10,FALSE),\"\")","v":""},"Totaal van belastingen en inhoudingen ",{"$f":"IFERROR(IFERROR(VLOOKUP(H40,Tabel2[],9,FALSE),\"\")+F47,\"\")","v":""}]
[{"$nulls":6},"Nettosalaris",{"$f":"IFERROR(VLOOKUP(H40,Tabel2[],11,FALSE),\"\")","v":""}]