{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Blad1"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":0,"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":"Blad1","index":0,"n_rows":46,"n_cols":26,"rows_kept":46,"cut":false,"hidden":false,"merged":[[14,4,14,7]]}
[]
[null,null,null,"2000-01-01","Geboortedatum",null,null,"Afwijkende periodes"]
[null,null,null,2023,"Jaar"]
[null,null,null,"Ja","Pensioenpremie"]
[null,null,null,"Geen","Sociaal fonds"]
[null,null,null,"Geen","Opleidingsfonds"]
[null,null,null,"Ja","Private aanvulling WW en WGA"]
[]
[null,null,null,"Uurloon","Uren","fulltime jaarloon","Franchise","Max salaris","Pensioengrondslag fulltime","Pensioenpremie %","Pensioenpremie","Pensioenpremie % werkgever","Pensioenpremie werkgever","Pensioenpremie % werknemer","Pensioenpremie werknemer","VPL %","VPL premie","Max salaris WWM","Grondslag WWM","WWM %","Premie WWM","Grondslag sociaal en O&O fonds","Percentage O&O fonds","Premie O&O","Percentage sociaal fonds","Premie sociaal fonds"]
[{"$f":"IF(E10>494,494,E10)/13","v":10},{"$f":"A10*D10*56.36/12.96","v":434.8765432098765},"1e kwartaal",10,130,{"$f":"IF(ISBLANK(E10),0,B10*12.96/ROUND(A10,2)*38)","v":21416.799999999999},{"$f":"VLOOKUP($D$3,$A$23:$B$28,2,0)","v":16322},{"$f":"VLOOKUP($D$3,$A$23:$C$28,3,0)","v":86202},{"$f":"ROUNDUP((IF(F10>H10,H10-G10,IF(F10-G10<0,0,F10-G10))),0)","v":5095},{"$f":"VLOOKUP($D$3,$A$23:$D$28,4,0)","v":0.27979999999999999},{"$f":"IF($D$4=$A$45,(I10*J10*(IF(E10>494,494,E10))/4/38/13),0)","v":93.788223684210521},{"$f":"VLOOKUP($D$3,$A$23:$E$28,5,0)","v":0.63260000000000005},{"$f":"K10*L10","v":59.330430302631584},{"$f":"VLOOKUP($D$3,$A$23:$F$28,6,0)","v":0.3674},{"$f":"K10*N10","v":34.457793381578945},{"$f":"VLOOKUP($D$3,$A$23:$G$28,7,0)","v":0},{"$f":"I10*P10/4","v":0},{"$f":"VLOOKUP($D$3,$A$23:$H$28,8,0)","v":0},{"$f":"ROUNDUP((IF(F10>R10,R10,F10)),0)","v":0},{"$f":"IF(ISBLANK($D$7),0,IF($D$7=$A$46,0,IF($D$3=2019,0,VLOOKUP($D$3,$A$23:$I$28,9,0))))","v":0},{"$f":"S10*T10*(IF(E10>494,494,E10))/494/4","v":0},{"$f":"ROUNDUP((IF(F10>H10,H10,F10)),0)","v":21417},{"$f":"IF(ISBLANK($D$6),0,IF($D$3=$B$29,VLOOKUP($D$6,$A$30:$G$37,3,0),(IF($D$3=$D$29,VLOOKUP($D$6,$A$30:$G$37,4,0),(IF($D$3=$E$29,VLOOKUP($D$6,$A$30:$G$37,5,0),(IF($D$3=$F$29,VLOOKUP($D$6,$A$30:$G$37,6,0),(IF($D$3=$G$29,VLOOKUP($D$6,$A$30:$G$37,7,0)))))))))))","v":false},{"$f":"V10*W10*(IF(E10>494,494,E10))/494/4","v":0},{"$f":"IF(AND(D3=E29,D5=A42),0,(IF(ISBLANK($D$5),0,IF($D$3=$B$29,VLOOKUP($D$5,$A$38:$G$42,3,0),(IF($D$3=$D$29,VLOOKUP($D$5,$A$38:$G$42,4,0),(IF($D$3=$E$29,VLOOKUP($D$5,$A$38:$G$42,5,0),(IF($D$3=$F$29,VLOOKUP($D$5,$A$38:$G$42,6,0),(IF($D$3=$G$29,VLOOKUP($D$5,$A$38:$G$42,7,0)))))))))))))","v":false},{"$f":"V10*Y10*(IF(E10>494,494,E10))/494/4","v":0}]
[{"$f":"IF(E11>494,494,E11)/13","v":0},{"$f":"A11*D11*56.36/12.96","v":0},"2e kwartaal",null,null,{"$f":"IF(ISBLANK(E11),0,B11*12.96/ROUND(A11,2)*38)","v":0},{"$f":"VLOOKUP($D$3,$A$23:$B$28,2,0)","v":16322},{"$f":"VLOOKUP($D$3,$A$23:$C$28,3,0)","v":86202},{"$f":"ROUNDUP((IF(F11>H11,H11-G11,IF(F11-G11<0,0,F11-G11))),0)","v":0},{"$f":"VLOOKUP($D$3,$A$23:$D$28,4,0)","v":0.27979999999999999},{"$f":"IF($D$4=$A$45,(I11*J11*(IF(E11>494,494,E11))/4/38/13),0)","v":0},{"$f":"VLOOKUP($D$3,$A$23:$E$28,5,0)","v":0.63260000000000005},{"$f":"K11*L11","v":0},{"$f":"VLOOKUP($D$3,$A$23:$F$28,6,0)","v":0.3674},{"$f":"K11*N11","v":0},{"$f":"VLOOKUP($D$3,$A$23:$G$28,7,0)","v":0},{"$f":"I11*P11/4","v":0},{"$f":"VLOOKUP($D$3,$A$23:$H$28,8,0)","v":0},{"$f":"ROUNDUP((IF(F11>R11,R11,F11)),0)","v":0},{"$f":"IF(ISBLANK($D$7),0,IF($D$7=$A$46,0,IF($D$3=2019,0,VLOOKUP($D$3,$A$23:$I$28,9,0))))","v":0},{"$f":"S11*T11*(IF(E11>494,494,E11))/494/4","v":0},{"$f":"ROUNDUP((IF(F11>H11,H11,F11)),0)","v":0},{"$f":"IF(ISBLANK($D$6),0,IF($D$3=$B$29,VLOOKUP($D$6,$A$30:$G$37,2,0),(IF($D$3=$D$29,VLOOKUP($D$6,$A$30:$G$37,4,0),(IF($D$3=$E$29,VLOOKUP($D$6,$A$30:$G$37,5,0),(IF($D$3=$F$29,VLOOKUP($D$6,$A$30:$G$37,6,0),(IF($D$3=$G$29,VLOOKUP($D$6,$A$30:$G$37,7,0)))))))))))","v":false},{"$f":"V11*W11*(IF(E11>494,494,E11))/494/4","v":0},{"$f":"IF(AND(D3=E29,D5=A42),0,(IF(ISBLANK($D$5),0,IF($D$3=$B$29,VLOOKUP($D$5,$A$38:$G$42,2,0),(IF($D$3=$D$29,VLOOKUP($D$5,$A$38:$G$42,4,0),(IF($D$3=$E$29,VLOOKUP($D$5,$A$38:$G$42,5,0),(IF($D$3=$F$29,VLOOKUP($D$5,$A$38:$G$42,6,0),(IF($D$3=$G$29,VLOOKUP($D$5,$A$38:$G$42,7,0)))))))))))))","v":false},{"$f":"V11*Y11*(IF(E11>494,494,E11))/494/4","v":0}]
[{"$f":"IF(E12>494,494,E12)/13","v":0},{"$f":"A12*D12*56.36/12.96","v":0},"3e kwartaal",null,null,0,16322,86202,{"$f":"ROUNDUP((IF(F12>H12,H12-G12,IF(F12-G12<0,0,F12-G12))),0)","v":0},0.27979999999999999,{"$f":"IF($D$4=$A$45,(I12*J12*(IF(E12>494,494,E12))/4/38/13),0)","v":0},0.63260000000000005,{"$f":"K12*L12","v":0},0.3674,0,0,0,0,0,0,{"$f":"S12*T12*(IF(E12>494,494,E12))/494/4","v":0},0,{"$f":"IF(ISBLANK($D$6),0,IF($D$3=$B$29,VLOOKUP($D$6,$A$30:$G$37,2,0),(IF($D$3=$D$29,VLOOKUP($D$6,$A$30:$G$37,4,0),(IF($D$3=$E$29,VLOOKUP($D$6,$A$30:$G$37,5,0),(IF($D$3=$F$29,VLOOKUP($D$6,$A$30:$G$37,6,0),(IF($D$3=$G$29,VLOOKUP($D$6,$A$30:$G$37,7,0)))))))))))","v":false},0,{"$f":"IF(ISBLANK($D$5),0,IF($D$3=$B$29,VLOOKUP($D$5,$A$38:$G$42,2,0),(IF($D$3=$D$29,VLOOKUP($D$5,$A$38:$G$42,4,0),(IF($D$3=$E$29,VLOOKUP($D$5,$A$38:$G$42,5,0),(IF($D$3=$F$29,VLOOKUP($D$5,$A$38:$G$42,6,0),(IF($D$3=$G$29,VLOOKUP($D$5,$A$38:$G$42,7,0)))))))))))","v":false},0]
[{"$f":"IF(E13>494,494,E13)/13","v":0},{"$f":"A13*D13*56.36/12.96","v":0},"4e kwartaal",null,null,0,16322,86202,{"$f":"ROUNDUP((IF(F13>H13,H13-G13,IF(F13-G13<0,0,F13-G13))),0)","v":0},0.27979999999999999,{"$f":"IF($D$4=$A$45,(I13*J13*(IF(E13>494,494,E13))/4/38/13),0)","v":0},0.63260000000000005,{"$f":"K13*L13","v":0},0.3674,0,0,0,0,{"$f":"ROUNDUP((IF(F13>R13,R13,F13)),0)","v":0},0,0,{"$f":"ROUNDUP((IF(F13>H13,H13,F13)),0)","v":0},{"$f":"IF(ISBLANK($D$6),0,IF($D$3=$B$29,VLOOKUP($D$6,$A$30:$G$37,2,0),(IF($D$3=$D$29,VLOOKUP($D$6,$A$30:$G$37,4,0),(IF($D$3=$E$29,VLOOKUP($D$6,$A$30:$G$37,5,0),(IF($D$3=$F$29,VLOOKUP($D$6,$A$30:$G$37,6,0),(IF($D$3=$G$29,VLOOKUP($D$6,$A$30:$G$37,7,0)))))))))))","v":false},{"$f":"V13*W13*(IF(E13>494,494,E13))/494/4","v":0},{"$f":"IF(ISBLANK($D$5),0,IF($D$3=$B$29,VLOOKUP($D$5,$A$38:$G$42,2,0),(IF($D$3=$D$29,VLOOKUP($D$5,$A$38:$G$42,4,0),(IF($D$3=$E$29,VLOOKUP($D$5,$A$38:$G$42,5,0),(IF($D$3=$F$29,VLOOKUP($D$5,$A$38:$G$42,6,0),(IF($D$3=$G$29,VLOOKUP($D$5,$A$38:$G$42,7,0)))))))))))","v":false},{"$f":"V13*Y13*(IF(E13>494,494,E13))/494/4","v":0}]
[]
[null,null,null,null,"Pensioenpremie",null,null,null,"Premie"]
[null,"Op de factuur","Salaris","Uren per week","Totaal","Werkgever","Werknemer","VPL","O&O","Sociaalfonds","SWWM"]
[null,"1e kwartaal",{"$f":"B10","v":434.8765432098765},{"$f":"ROUND(A10,2)","v":10},{"$f":"K10","v":93.788223684210521},{"$f":"M10","v":59.330430302631584},{"$f":"O10","v":34.457793381578945},{"$f":"Q10","v":0},{"$f":"X10","v":0},{"$f":"Z10","v":0},{"$f":"U10","v":0},{"$f":"IF((H10/4/494)>=D10,\"\",\"Let op! er is geen rekening gehouden met eventuele excedent premie\")","v":""}]
[null,"2e kwartaal",{"$f":"B11","v":0},{"$f":"ROUND(A11,2)","v":0},{"$f":"K11","v":0},{"$f":"M11","v":0},{"$f":"O11","v":0},{"$f":"Q11","v":0},{"$f":"X11","v":0},{"$f":"Z11","v":0},{"$f":"U11","v":0},{"$f":"IF((H11/4/494)>=D11,\"\",\"Let op! er is geen rekening gehouden met eventuele excedent premie\")","v":""}]
[null,"3e kwartaal",0,0,{"$f":"K12","v":0},0,{"$f":"O12","v":0},0,0,0,{"$f":"IF(D3=2022,0,U12)","v":0},""]
[null,"4e kwartaal",0,0,0,0,{"$f":"O13","v":0},0,0,{"$f":"Z13","v":0},{"$f":"IF(D3=2022,0,U13)","v":0},""]
[]
[null,"Franchise","Max salaris","Pensioenpremie %","Pensioenpremie werkgever","Pensioenpremie werknemer","VPL","WWM max salaris","WWM",null,"OOGZ","OASZS","OOI","OOM","OOC","OOTW","SFMvT","SFMvT-A","SFTW","Wij Techniek","SFM"]
[2023,16322,86202,0.27979999999999999,0.63260000000000005,0.3674]
[2022,14802,81010,0.27979999999999999,0.63260000000000005,0.3674,null,59706,2E-3,"Premie van 01-01-2022 t/m 30-06-2022: 0,2% tot een maximumsalaris van € 59.706.",5.0000000000000001E-3,null,9.4000000000000004E-3,6.2500000000000003E-3,5.0000000000000001E-3,null,9.4999999999999998E-3,7.0000000000000001E-3,3.0000000000000001E-3,8.5000000000000006E-3,2E-3,"* Deze premies gelden van 01-04-2022. In de periode van 01-01-2022 t/m 31-03-2022 is de premie 0%."]
[2021,14554,79719,0.27979999999999999,0.63260000000000005,0.3674,null,58311,4.0000000000000001E-3,null,5.0000000000000001E-3,null,7.0000000000000001E-3,6.2500000000000003E-3,5.0000000000000001E-3,null,9.4999999999999998E-3,7.0000000000000001E-3,3.0000000000000001E-3,8.5000000000000006E-3,2E-3]
[2020,14554,78348,0.222,0.53700000000000003,0.46300000000000002,5.7799999999999997E-2,57232,4.0000000000000001E-3,null,5.0000000000000001E-3,2E-3,7.0000000000000001E-3,6.2500000000000003E-3,5.0000000000000001E-3,null,7.0000000000000001E-3,4.4999999999999997E-3,1.2E-2,8.5000000000000006E-3,2E-3,"* Premiepercentage van januari t/m juni 2020 is 0,00%. Vanaf 1 juli 2020: 1,2%. Er wordt vanaf 01-01-2020 géén premie in\nrekening gebracht voor het O&O fonds Tankstations en Wasbedrijven (OOTW)."]
[2019,14554,74327,0.222,0.53700000000000003,0.46300000000000002,5.7799999999999997E-2,55927,3.0000000000000001E-3,"Premie vanaf 1-7-2019: 0,3% tot maximumsalaris van 55.927 euro",5.0000000000000001E-3,2E-3,7.0000000000000001E-3,6.2500000000000003E-3,5.0000000000000001E-3,3.0000000000000001E-3,7.0000000000000001E-3,4.4999999999999997E-3,3.0000000000000001E-3,0.01,2E-3]
[2018,14704,73711,0.22600000000000001,0.53700000000000003,0.46300000000000002,5.8799999999999998E-2,null,null,null,5.0000000000000001E-3,2E-3,7.0000000000000001E-3,6.2500000000000003E-3,5.0000000000000001E-3,3.0000000000000001E-3,7.0000000000000001E-3,4.4999999999999997E-3,3.0000000000000001E-3,0.01,2E-3]
[null,2022,"2022-2",2021,2020,2019,2018]
["Geen"]
["(OASZS) Scheepsbenodigdhedenhandelaren, Zeilmakers en Scheepstuigers",0,0,0,2E-3,2E-3,2E-3]
["(OOC) Carrosseriebedrijf",5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3]
["(OOGZ) Goud en Zilver",5.0000000000000001E-3,0,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3]
["(OOI) Isolatiebedrijf",9.4000000000000004E-3,0,7.0000000000000001E-3,7.0000000000000001E-3,7.0000000000000001E-3,7.0000000000000001E-3]
["(OOM) Metaalbewerkingsbedrijf",6.2500000000000003E-3,0,6.2500000000000003E-3,6.2500000000000003E-3,6.2500000000000003E-3,6.2500000000000003E-3]
["(OOTW) Tankstations en Wasbedrijven",0,0,0,0,3.0000000000000001E-3,3.0000000000000001E-3]
["(Wij Techniek) Technisch installatiebedrijf",8.5000000000000006E-3,0,8.5000000000000006E-3,8.5000000000000006E-3,0.01,0.01]
["Geen"]
["(SFM) Sociaal Fonds Metaal en Technische Bedrijfstakken",2E-3,0,2E-3,2E-3,2E-3,2E-3]
["(SFMVT) Motorvoertuigen- en Tweewielerbedrijf",9.4999999999999998E-3,null,9.4999999999999998E-3,7.0000000000000001E-3,7.0000000000000001E-3,7.0000000000000001E-3]
["(SFMVT-A) Motorvoertuigen- en Tweewielerbedrijf",7.0000000000000001E-3,null,7.0000000000000001E-3,4.4999999999999997E-3,4.4999999999999997E-3,4.4999999999999997E-3]
["(SFTW) Tankstations en Wasbedrijven",3.0000000000000001E-3,null,3.0000000000000001E-3,1.2E-2,3.0000000000000001E-3,3.0000000000000001E-3]
[null,"* Deze premies gelden van 01-04-2022. In de periode van 01-01-2022 t/m 31-03-2022 is de premie 0%.",null,null,"* Premiepercentage van januari t/m juni 2020 is 0,00%. Vanaf 1 juli 2020: 1,2%. Er wordt vanaf 01-01-2020 géén premie in\nrekening gebracht voor het O&O fonds Tankstations en Wasbedrijven (OOTW)."]
[]
["Ja"]
["Nee"]