{"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":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":"Blad1","index":0,"n_rows":57,"n_cols":22,"rows_kept":57,"cut":false,"hidden":false,"merged":[[4,2,4,3],[3,2,3,3],[13,0,13,3]]}
[]
[]
[null,null,null,"Meeruren"]
[null,null,"Vul de blauwe velden"]
[]
[null,null,"Bruto salaris"]
[null,null,"Aantal contracturen per week",null,"Gemiddeld aantal uren extra",{"$f":"D11/((_xlfn.DAYS(D10,D9))/7)","v":0},"nieuw aantal uren",{"$f":"IF((D7+F7)>38,38,D7+F7)","v":0}]
[null,null,"Salarisbetaling per"]
[null,null,"Startdatum gewerkte meeruren","2022-01-01",{"$f":"IF(ISBLANK(D9),\"\",IF(YEAR(D9)<2018,\"LET OP! jaartal moet minimaal 2018 zijn\",\"\"))","v":""},{"$f":"YEAR(D9)","v":2022}]
[null,null,"Einddatum gewerkte meeruren","2022-12-31",{"$f":"IF(YEAR(D10)<>YEAR(D9),\"LET OP! jaartal moet hetzelfde zijn als begin periode\",\"\")","v":""}]
[null,null,"Aantal gewerkte meeruren"]
[]
[null,null,null,"Berekening"]
[{"$f":"IF(OR(ISBLANK(D9),ISBLANK(D10)),\"Geef onderstaand salaris en uren door via het Inzendportaal.nl\",(CONCATENATE(\"Geef onderstaand salaris en uren van \", TEXT( D9,\"d-m-jjjj\"),\" tot en met \",TEXT( D10,\"d-m-jjjj\"),\" door via Inzendportaal.nl\")))","v":"Geef onderstaand salaris en uren van 1-1-2022 tot en met 31-12-2022 door via Inzendportaal.nl"}]
[null,null,null,null,"Premie per maand","Premie per 4-weken"]
[null,null,"Salaris inclusief meeruren",{"$f":"IF(ISBLANK(D6),\"\",IF(ISBLANK(D7),\"\",IF(ISBLANK(D9),\"\",ROUND(D6/D7*H7,2))))","v":""},{"$f":"IF((((IF((38/D17*D16*12.96)>(VLOOKUP(F9,A38:C42,3,FALSE)),(VLOOKUP(F9,A38:C42,3,FALSE)),(38/D17*D16*12.96)))-(VLOOKUP(F9,A38:B42,2,FALSE)))*(VLOOKUP(F9,A38:D42,4,FALSE))/12/38*D17)<0,0,(((IF((38/D17*D16*12.96)>(VLOOKUP(F9,A38:C42,3,FALSE)),(VLOOKUP(F9,A38:C42,3,FALSE)),(38/D17*D16*12.96)))-(VLOOKUP(F9,A38:B42,2,FALSE)))*(VLOOKUP(F9,A38:D42,4,FALSE))/12/38*D17))","v":{"$error":"#VALUE!"}},{"$f":"IF((((IF((38/D17*D16*14.09)>(VLOOKUP(F9,A38:C42,3,FALSE)),(VLOOKUP(F9,A38:C42,3,FALSE)),(38/D17*D16*14.09)))-(VLOOKUP(F9,A38:B42,2,FALSE)))*(VLOOKUP(F9,A38:D42,4,FALSE))/13/38*D17)<0,0,(((IF((38/D17*D16*14.09)>(VLOOKUP(F9,A38:C42,3,FALSE)),(VLOOKUP(F9,A38:C42,3,FALSE)),(38/D17*D16*14.09)))-(VLOOKUP(F9,A38:B42,2,FALSE)))*(VLOOKUP(F9,A38:D42,4,FALSE))/13/38*D17))","v":{"$error":"#VALUE!"}},{"$f":"(VLOOKUP(F9,A38:B42,2,FALSE))","v":14802},{"$f":"(VLOOKUP(F9,A38:C42,3,FALSE))","v":81010},{"$f":"(VLOOKUP(F9,A38:D42,4,FALSE))","v":0.27979999999999999},{"$f":"(VLOOKUP(F9,A38:F42,6,FALSE))","v":0.3674}]
[null,null,"Aantal uren inclusief meeruren",{"$f":"IF(ISBLANK(D6),\"\",IF(ISBLANK(D7),\"\",IF(ISBLANK(D9),\"\",ROUND(H7,2))))","v":""}]
[]
[null,null,null,"Pensioenpremie"]
[]
[null,null,{"$f":"IF(D8=A31,A34,A35)","v":"Pensioenpremie per 4-weken"},{"$f":"IF(ISBLANK(D8),\"\",IF(ISBLANK(D9),\"\",IF(D8=A32,F16,E16)))","v":""}]
[null,null,"Maximale inhouding werknemer",{"$f":"IF(D21=\"\",\"\",D21*(VLOOKUP(F9,A38:F42,6,FALSE)))","v":""}]
[null,null,"Opleidingsfonds"]
[null,null,"Sociaal fonds"]
[null,null,"Private aanvulling WW en WGA"]
[]
[]
[]
[]
[]
["maand"]
["4-weken"]
[]
["Pensioenpremie per maand"]
["Pensioenpremie per 4-weken"]
[]
[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"]
[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 Scheepstuiges",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) Metaalbewerkignsbedrijf",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) Takstations 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)."]