{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Informatie","Bestelformulier","Data voor export","Bestellen licenties","Vaste waarden","Import data"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":9,"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":"Informatie","index":0,"n_rows":29,"n_cols":3,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[null,"Informatie voor het bestellen van de tool \nSamenstelling arbeidsvoorwaarden en kostprijsberekening"]
[null,"Informatie"]
[null,"Het is noodzakelijk dat de macro's worden ingeschakeld. Als er een melding verschijnt dat de macro's zijn uitgeschakeld, schakel die dan in."]
[null,null,{"$f":"IF('Vaste waarden'!M4<>\"\",'Vaste waarden'!M4,\"\")","v":"De macro's zijn niet ingeschakeld. Daardoor werken de knoppen niet en zijn maar een beperkt aantal schermen zichtbaar."}]
[null,null,{"$f":"IF('Vaste waarden'!M5<>\"\",'Vaste waarden'!M5,\"\")","v":"Schakel de macro's in om de tool te gebruiken."}]
[null,"Stap 1 (per bedrijf):"]
[null,"Vul het bestelformulier in."]
[null,"Stap 2 (per gebruiker van de tool):"]
[null,"Iedere persoon moet vanaf zijn/haar systeem waarop de tool gebruikt gaat worden een licentie aanvragen op het tabblad \"Bestellen licenties\"."]
[null,"Klik als eerste aanvrager op de knop \"Licentie 1\" en vul in de pop-up die verschijnt het e-mailadres in. "]
[null,"Het e-mailadres en de gebruikersnaam verschijnen in het tabblad."]
[null,"Iedere volgende gebruiker van de tool herhaalt dit (vanaf zijn/haar eigen systeem) met een volgende knop \"Licentie\"."]
[null,"Is er een fout gemaakt bij het invoeren, kies dan de knop Delete licentie bij de onjuiste regel."]
[null,"Bestaat de organisatie uit meerdere labels met afzonderlijke bedrijfsnamen of domeinnamen, gebruik dan per bedrijfsonderdeel een bestelformulier."]
[null,"Stap 3:"]
[null,"Mail het bestelformulier naar: info@expertsinflex.nl"]
[]
[]
[null,"Disclaimer: "]
[null,"Hoewel Experts in Flex en de NBBU deze tool met de grootst mogelijke zorgvuldigheid hebben samengesteld,"]
[null,"zijn Experts in Flex en de NBBU niet verantwoordelijk voor de (combinatie van) informatie "]
[null,"die u invoert en/of de daaruit voortkomende berekeningen van deze tool. "]
[]
[null,"Copyright© Experts in Flex.  Experts in Flex is een handelsnaam van The art of Service B.V. KvK 31034908"]
[]
[]
[]
[null,"Oosthof 3"]
[null,"3925 SH  Scherpenzeel"]

{"sheet":"Bestelformulier","index":1,"n_rows":39,"n_cols":4,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[null,"Bestelformulier voor de tool \nSamenstelling arbeidsvoorwaarden en kostprijsberekening"]
[null,"Informatie"]
[null,"Dit is een multi-user tool. Per gebruiker wordt een licentie verstrekt. De licentievergoeding is inclusief gratis updates gedurende het gebruikersjaar."]
[null,"Voor NBBU-leden is de tool geheel gratis."]
[null,"Belangrijk voor NBBU-leden: Vul bij de bedrijfsgegevens de bedrijfsnaam in zoals is vastgelegd in het NBBU-ledenregister."]
[]
[null,"Licentievergoeding 2026 eerste licentie","€ 295,- excl. BTW"]
[null,"Introductiekorting eerste licentie","€ 100,-. U betaalt dus € 195,- excl. BTW"]
[null,"Elke volgende licentie","€ 95,- excl. BTW"]
[]
[null,"Per concern is slechts 1x de hogere vergoeding voor de eerste licentie verschuldigd. Vul bij meerdere bestelformulieren in concernverband hier de bedrijfsnaam in"]
[null,"waaronder de eerste licentievergoeding is geregistreerd."]
[null,null,null,{"$f":"IF(C13=\"onbekend\",\"Het is van belang dat u de macro's inschakelt\",\"\")","v":""}]
[null,"Bedrijfsgegevens"]
[null,"Bedrijfsnaam"]
[null,"Adres"]
[null,"Postcode + Plaats"]
[null,"E-mailadres voor de factuur"]
[null,"Telefoonnummer"]
[]
[null,"Contactpersoon"]
[null,"Voornaam"]
[null,"Achternaam"]
[null,"E-mailadres"]
[null,"Mobiel nummer"]
[]
[null,"Aanvullende informatie en verzending bestelformulier"]
[null,"Registreer de gebruikers voor de tool en stuur dit bestelformulier daarna naar:","info@expertsinflex.nl"]
[]
[null,"Disclaimer: "]
[null,"Hoewel Experts in Flex en de NBBU deze tool met de grootst mogelijke zorgvuldigheid hebben samengesteld,"]
[null,"zijn Experts in Flex en de NBBU niet verantwoordelijk voor de (combinatie van) informatie "]
[null,"die u invoert en/of de daaruit voortkomende berekeningen van deze tool. "]
[]
[null,"Copyright© Experts in Flex.  Experts in Flex is een handelsnaam van The art of Service B.V. KvK 31034908"]
[]
[]
[null,"Oosthof 3"]
[null,"3925 SH  Scherpenzeel"]

{"sheet":"Data voor export","index":2,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Tool kostprijs en gelijkwaardigheid"]
[{"$f":"#REF!","v":{"$error":"#REF!"}}]

{"sheet":"Bestellen licenties","index":3,"n_rows":23,"n_cols":28,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Kies vrije licentie",null,null,null,"E-mailadres","Foutmelding","Licentiecode","Melding mail komt al voor","Komt al voor?","afwijkende domeinnaam",null,"vind @","totale lengte","domeinnaam",null,null,null,null,null,null,null,null,null,"Gebruikersnaam","Foutmelding"]
[null,null,null,null,{"$f":"IF('Vaste waarden'!A4<>\"\",'Vaste waarden'!A4,\"\")","v":""},null,{"$f":"IF('Vaste waarden'!B4<>0,'Vaste waarden'!B4,\"\")","v":""},{"$f":"IF(I4<>\"niet dubbel\", \"Dit e-mailadres komt al voor. Kies ander mailadres.\",\"\")","v":"Dit e-mailadres komt al voor. Kies ander mailadres."},null,null,null,{"$f":"SEARCH(\"@\",E4)","v":{"$error":"#VALUE!"}},{"$f":"LEN(E4)","v":0},{"$f":"M4-L4","v":{"$error":"#VALUE!"}},{"$f":"RIGHT(E4,N4)","v":{"$error":"#VALUE!"}},null,null,{"$f":"TODAY()","v":45990},{"$f":"LEFT(E4,1)","v":""},{"$f":"IFERROR(VLOOKUP(S4,#REF!,2,FALSE),ROW(T4))","v":4},{"$f":"RIGHT(E4,N4+2)","v":{"$error":"#VALUE!"}},{"$f":"LEFT(U4,1)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(VLOOKUP(V4,#REF!,2,FALSE),ROW(W4))","v":4},{"$f":"IF('Vaste waarden'!C4<>\"\",'Vaste waarden'!C4,IF('Vaste waarden'!D4<>\"\",'Vaste waarden'!D4,\"\"))","v":""},{"$f":"IF(Z4<>\"niet dubbel\",AB4,\"\")","v":""},{"$f":"IF('Vaste waarden'!F4=AA4,\"niet dubbel\",AA4)","v":"niet dubbel"},{"$f":"IFERROR(VLOOKUP(X4,'Vaste waarden'!C$4:F$23,4,FALSE),\"niet dubbel\")","v":"niet dubbel"},{"$f":"CONCATENATE(\"Deze gebruikersnaam komt al voor bij licentie\",\" \",Z4)","v":"Deze gebruikersnaam komt al voor bij licentie niet dubbel"}]
[null,null,null,null,{"$f":"IF('Vaste waarden'!A5<>\"\",'Vaste waarden'!A5,\"\")","v":""},{"$f":"IF(J5<>\"\",J5,IF(H5<>\"\",H5,\"\"))","v":""},{"$f":"IF('Vaste waarden'!B5<>0,'Vaste waarden'!B5,\"\")","v":""},{"$f":"IF(I5<>\"niet dubbel\", \"Dit e-mailadres komt al voor. Kies ander mailadres.\",\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E5,'Vaste waarden'!A$4:A4,1,FALSE),\"niet dubbel\")","v":"niet dubbel"},{"$f":"IFERROR(IF(O5<>O$4,\"Kies e-mail met dezelfde domeinnaam als licentie 1.\",\"\"),\"\")","v":""},null,{"$error":"#VALUE!"},0,{"$f":"M5-L5","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,null,{"$f":"TODAY()","v":45990},"",{"$f":"IFERROR(VLOOKUP(S5,#REF!,2,FALSE),ROW(T5))","v":5},{"$error":"#VALUE!"},{"$f":"LEFT(U5,1)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(VLOOKUP(V5,#REF!,2,FALSE),ROW(W5))","v":5},{"$f":"IF('Vaste waarden'!C5<>\"\",'Vaste waarden'!C5,IF('Vaste waarden'!D5<>\"\",'Vaste waarden'!D5,\"\"))","v":""},"",{"$f":"IF('Vaste waarden'!F5=AA5,\"niet dubbel\",AA5)","v":"niet dubbel"},{"$f":"IFERROR(VLOOKUP(X5,'Vaste waarden'!C$4:F$23,4,FALSE),\"niet dubbel\")","v":"niet dubbel"},"Deze gebruikersnaam komt al voor bij licentie niet dubbel"]
[null,null,null,null,{"$f":"IF('Vaste waarden'!A6<>\"\",'Vaste waarden'!A6,\"\")","v":""},"",{"$f":"IF('Vaste waarden'!B6<>0,'Vaste waarden'!B6,\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(E6,'Vaste waarden'!A$4:A5,1,FALSE),\"niet dubbel\")","v":"niet dubbel"},{"$f":"IFERROR(IF(O6<>O$4,\"Domeinnaam wijkt af van licentie 1. Kies juiste e-mail.\",\"\"),\"\")","v":""},null,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,45990,"",{"$f":"IFERROR(VLOOKUP(S6,#REF!,2,FALSE),ROW(T6))","v":6},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IFERROR(VLOOKUP(V6,#REF!,2,FALSE),ROW(W6))","v":6},{"$f":"IF('Vaste waarden'!C6<>\"\",'Vaste waarden'!C6,IF('Vaste waarden'!D6<>\"\",'Vaste waarden'!D6,\"\"))","v":""},"",{"$f":"IF('Vaste waarden'!F6=AA6,\"niet dubbel\",AA6)","v":"niet dubbel"},{"$f":"IFERROR(VLOOKUP(X6,'Vaste waarden'!C$4:F$23,4,FALSE),\"niet dubbel\")","v":"niet dubbel"},"Deze gebruikersnaam komt al voor bij licentie niet dubbel"]
[null,null,null,null,{"$f":"IF('Vaste waarden'!A7<>\"\",'Vaste waarden'!A7,\"\")","v":""},"",{"$f":"IF('Vaste waarden'!B7<>0,'Vaste waarden'!B7,\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(E7,'Vaste waarden'!A$4:A6,1,FALSE),\"niet dubbel\")","v":"niet dubbel"},"",null,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,45990,"",{"$f":"IFERROR(VLOOKUP(S7,#REF!,2,FALSE),ROW(T7))","v":7},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IFERROR(VLOOKUP(V7,#REF!,2,FALSE),ROW(W7))","v":7},{"$f":"IF('Vaste waarden'!C7<>\"\",'Vaste waarden'!C7,IF('Vaste waarden'!D7<>\"\",'Vaste waarden'!D7,\"\"))","v":""},"",{"$f":"IF('Vaste waarden'!F7=AA7,\"niet dubbel\",AA7)","v":"niet dubbel"},{"$f":"IFERROR(VLOOKUP(X7,'Vaste waarden'!C$4:F$23,4,FALSE),\"niet dubbel\")","v":"niet dubbel"},"Deze gebruikersnaam komt al voor bij licentie niet dubbel"]
[null,null,null,null,{"$f":"IF('Vaste waarden'!A8<>\"\",'Vaste waarden'!A8,\"\")","v":""},"",{"$f":"IF('Vaste waarden'!B8<>0,'Vaste waarden'!B8,\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(E8,'Vaste waarden'!A$4:A7,1,FALSE),\"niet dubbel\")","v":"niet dubbel"},"",null,{"$error":"#VALUE!"},0,{"$f":"M8-L8","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,null,45990,"",{"$f":"IFERROR(VLOOKUP(S8,#REF!,2,FALSE),ROW(T8))","v":8},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IFERROR(VLOOKUP(V8,#REF!,2,FALSE),ROW(W8))","v":8},{"$f":"IF('Vaste waarden'!C8<>\"\",'Vaste waarden'!C8,IF('Vaste waarden'!D8<>\"\",'Vaste waarden'!D8,\"\"))","v":""},"",{"$f":"IF('Vaste waarden'!F8=AA8,\"niet dubbel\",AA8)","v":"niet dubbel"},{"$f":"IFERROR(VLOOKUP(X8,'Vaste waarden'!C$4:F$23,4,FALSE),\"niet dubbel\")","v":"niet dubbel"},"Deze gebruikersnaam komt al voor bij licentie niet dubbel"]
[null,null,null,null,{"$f":"IF('Vaste waarden'!A9<>\"\",'Vaste waarden'!A9,\"\")","v":""},{"$f":"IF(J9<>\"\",J9,IF(H9<>\"\",H9,\"\"))","v":""},{"$f":"IF('Vaste waarden'!B9<>0,'Vaste waarden'!B9,\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(E9,'Vaste waarden'!A$4:A8,1,FALSE),\"niet dubbel\")","v":"niet dubbel"},"",null,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,45990,"",{"$f":"IFERROR(VLOOKUP(S9,#REF!,2,FALSE),ROW(T9))","v":9},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IFERROR(VLOOKUP(V9,#REF!,2,FALSE),ROW(W9))","v":9},{"$f":"IF('Vaste waarden'!C9<>\"\",'Vaste waarden'!C9,IF('Vaste waarden'!D9<>\"\",'Vaste waarden'!D9,\"\"))","v":""},"",{"$f":"IF('Vaste waarden'!F9=AA9,\"niet dubbel\",AA9)","v":"niet dubbel"},{"$f":"IFERROR(VLOOKUP(X9,'Vaste waarden'!C$4:F$23,4,FALSE),\"niet dubbel\")","v":"niet dubbel"},"Deze gebruikersnaam komt al voor bij licentie niet dubbel"]
[null,null,null,null,{"$f":"IF('Vaste waarden'!A10<>\"\",'Vaste waarden'!A10,\"\")","v":""},"",{"$f":"IF('Vaste waarden'!B10<>0,'Vaste waarden'!B10,\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(E10,'Vaste waarden'!A$4:A9,1,FALSE),\"niet dubbel\")","v":"niet dubbel"},"",null,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,45990,"",{"$f":"IFERROR(VLOOKUP(S10,#REF!,2,FALSE),ROW(T10))","v":10},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IFERROR(VLOOKUP(V10,#REF!,2,FALSE),ROW(W10))","v":10},{"$f":"IF('Vaste waarden'!C10<>\"\",'Vaste waarden'!C10,IF('Vaste waarden'!D10<>\"\",'Vaste waarden'!D10,\"\"))","v":""},"",{"$f":"IF('Vaste waarden'!F10=AA10,\"niet dubbel\",AA10)","v":"niet dubbel"},{"$f":"IFERROR(VLOOKUP(X10,'Vaste waarden'!C$4:F$23,4,FALSE),\"niet dubbel\")","v":"niet dubbel"},"Deze gebruikersnaam komt al voor bij licentie niet dubbel"]
[null,null,null,null,{"$f":"IF('Vaste waarden'!A11<>\"\",'Vaste waarden'!A11,\"\")","v":""},"",{"$f":"IF('Vaste waarden'!B11<>0,'Vaste waarden'!B11,\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(E11,'Vaste waarden'!A$4:A10,1,FALSE),\"niet dubbel\")","v":"niet dubbel"},"",null,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,45990,"",{"$f":"IFERROR(VLOOKUP(S11,#REF!,2,FALSE),ROW(T11))","v":11},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IFERROR(VLOOKUP(V11,#REF!,2,FALSE),ROW(W11))","v":11},{"$f":"IF('Vaste waarden'!C11<>\"\",'Vaste waarden'!C11,IF('Vaste waarden'!D11<>\"\",'Vaste waarden'!D11,\"\"))","v":""},"",{"$f":"IF('Vaste waarden'!F11=AA11,\"niet dubbel\",AA11)","v":"niet dubbel"},{"$f":"IFERROR(VLOOKUP(X11,'Vaste waarden'!C$4:F$23,4,FALSE),\"niet dubbel\")","v":"niet dubbel"},"Deze gebruikersnaam komt al voor bij licentie niet dubbel"]
[null,null,null,null,{"$f":"IF('Vaste waarden'!A12<>\"\",'Vaste waarden'!A12,\"\")","v":""},"",{"$f":"IF('Vaste waarden'!B12<>0,'Vaste waarden'!B12,\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(E12,'Vaste waarden'!A$4:A11,1,FALSE),\"niet dubbel\")","v":"niet dubbel"},"",null,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,45990,"",{"$f":"IFERROR(VLOOKUP(S12,#REF!,2,FALSE),ROW(T12))","v":12},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IFERROR(VLOOKUP(V12,#REF!,2,FALSE),ROW(W12))","v":12},{"$f":"IF('Vaste waarden'!C12<>\"\",'Vaste waarden'!C12,IF('Vaste waarden'!D12<>\"\",'Vaste waarden'!D12,\"\"))","v":""},"",{"$f":"IF('Vaste waarden'!F12=AA12,\"niet dubbel\",AA12)","v":"niet dubbel"},{"$f":"IFERROR(VLOOKUP(X12,'Vaste waarden'!C$4:F$23,4,FALSE),\"niet dubbel\")","v":"niet dubbel"},"Deze gebruikersnaam komt al voor bij licentie niet dubbel"]
[null,null,null,null,{"$f":"IF('Vaste waarden'!A13<>\"\",'Vaste waarden'!A13,\"\")","v":""},"",{"$f":"IF('Vaste waarden'!B13<>0,'Vaste waarden'!B13,\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(E13,'Vaste waarden'!A$4:A12,1,FALSE),\"niet dubbel\")","v":"niet dubbel"},"",null,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,45990,"",{"$f":"IFERROR(VLOOKUP(S13,#REF!,2,FALSE),ROW(T13))","v":13},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IFERROR(VLOOKUP(V13,#REF!,2,FALSE),ROW(W13))","v":13},{"$f":"IF('Vaste waarden'!C13<>\"\",'Vaste waarden'!C13,IF('Vaste waarden'!D13<>\"\",'Vaste waarden'!D13,\"\"))","v":""},"",{"$f":"IF('Vaste waarden'!F13=AA13,\"niet dubbel\",AA13)","v":"niet dubbel"},{"$f":"IFERROR(VLOOKUP(X13,'Vaste waarden'!C$4:F$23,4,FALSE),\"niet dubbel\")","v":"niet dubbel"},"Deze gebruikersnaam komt al voor bij licentie niet dubbel"]
[null,null,null,null,{"$f":"IF('Vaste waarden'!A14<>\"\",'Vaste waarden'!A14,\"\")","v":""},"",{"$f":"IF('Vaste waarden'!B14<>0,'Vaste waarden'!B14,\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(E14,'Vaste waarden'!A$4:A13,1,FALSE),\"niet dubbel\")","v":"niet dubbel"},"",null,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,45990,"",{"$f":"IFERROR(VLOOKUP(S14,#REF!,2,FALSE),ROW(T14))","v":14},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IFERROR(VLOOKUP(V14,#REF!,2,FALSE),ROW(W14))","v":14},{"$f":"IF('Vaste waarden'!C14<>\"\",'Vaste waarden'!C14,IF('Vaste waarden'!D14<>\"\",'Vaste waarden'!D14,\"\"))","v":""},"",{"$f":"IF('Vaste waarden'!F14=AA14,\"niet dubbel\",AA14)","v":"niet dubbel"},{"$f":"IFERROR(VLOOKUP(X14,'Vaste waarden'!C$4:F$23,4,FALSE),\"niet dubbel\")","v":"niet dubbel"},"Deze gebruikersnaam komt al voor bij licentie niet dubbel"]
[null,null,null,null,{"$f":"IF('Vaste waarden'!A15<>\"\",'Vaste waarden'!A15,\"\")","v":""},"",{"$f":"IF('Vaste waarden'!B15<>0,'Vaste waarden'!B15,\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(E15,'Vaste waarden'!A$4:A14,1,FALSE),\"niet dubbel\")","v":"niet dubbel"},"",null,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,45990,"",{"$f":"IFERROR(VLOOKUP(S15,#REF!,2,FALSE),ROW(T15))","v":15},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IFERROR(VLOOKUP(V15,#REF!,2,FALSE),ROW(W15))","v":15},{"$f":"IF('Vaste waarden'!C15<>\"\",'Vaste waarden'!C15,IF('Vaste waarden'!D15<>\"\",'Vaste waarden'!D15,\"\"))","v":""},"",{"$f":"IF('Vaste waarden'!F15=AA15,\"niet dubbel\",AA15)","v":"niet dubbel"},{"$f":"IFERROR(VLOOKUP(X15,'Vaste waarden'!C$4:F$23,4,FALSE),\"niet dubbel\")","v":"niet dubbel"},"Deze gebruikersnaam komt al voor bij licentie niet dubbel"]
[null,null,null,null,{"$f":"IF('Vaste waarden'!A16<>\"\",'Vaste waarden'!A16,\"\")","v":""},"",{"$f":"IF('Vaste waarden'!B16<>0,'Vaste waarden'!B16,\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(E16,'Vaste waarden'!A$4:A15,1,FALSE),\"niet dubbel\")","v":"niet dubbel"},"",null,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,45990,"",{"$f":"IFERROR(VLOOKUP(S16,#REF!,2,FALSE),ROW(T16))","v":16},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IFERROR(VLOOKUP(V16,#REF!,2,FALSE),ROW(W16))","v":16},{"$f":"IF('Vaste waarden'!C16<>\"\",'Vaste waarden'!C16,IF('Vaste waarden'!D16<>\"\",'Vaste waarden'!D16,\"\"))","v":""},"",{"$f":"IF('Vaste waarden'!F16=AA16,\"niet dubbel\",AA16)","v":"niet dubbel"},{"$f":"IFERROR(VLOOKUP(X16,'Vaste waarden'!C$4:F$23,4,FALSE),\"niet dubbel\")","v":"niet dubbel"},"Deze gebruikersnaam komt al voor bij licentie niet dubbel"]
[null,null,null,null,{"$f":"IF('Vaste waarden'!A17<>\"\",'Vaste waarden'!A17,\"\")","v":""},"",{"$f":"IF('Vaste waarden'!B17<>0,'Vaste waarden'!B17,\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(E17,'Vaste waarden'!A$4:A16,1,FALSE),\"niet dubbel\")","v":"niet dubbel"},"",null,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,45990,"",{"$f":"IFERROR(VLOOKUP(S17,#REF!,2,FALSE),ROW(T17))","v":17},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IFERROR(VLOOKUP(V17,#REF!,2,FALSE),ROW(W17))","v":17},{"$f":"IF('Vaste waarden'!C17<>\"\",'Vaste waarden'!C17,IF('Vaste waarden'!D17<>\"\",'Vaste waarden'!D17,\"\"))","v":""},"",{"$f":"IF('Vaste waarden'!F17=AA17,\"niet dubbel\",AA17)","v":"niet dubbel"},{"$f":"IFERROR(VLOOKUP(X17,'Vaste waarden'!C$4:F$23,4,FALSE),\"niet dubbel\")","v":"niet dubbel"},"Deze gebruikersnaam komt al voor bij licentie niet dubbel"]
[null,null,null,null,{"$f":"IF('Vaste waarden'!A18<>\"\",'Vaste waarden'!A18,\"\")","v":""},"",{"$f":"IF('Vaste waarden'!B18<>0,'Vaste waarden'!B18,\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(E18,'Vaste waarden'!A$4:A17,1,FALSE),\"niet dubbel\")","v":"niet dubbel"},"",null,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,45990,"",{"$f":"IFERROR(VLOOKUP(S18,#REF!,2,FALSE),ROW(T18))","v":18},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IFERROR(VLOOKUP(V18,#REF!,2,FALSE),ROW(W18))","v":18},{"$f":"IF('Vaste waarden'!C18<>\"\",'Vaste waarden'!C18,IF('Vaste waarden'!D18<>\"\",'Vaste waarden'!D18,\"\"))","v":""},"",{"$f":"IF('Vaste waarden'!F18=AA18,\"niet dubbel\",AA18)","v":"niet dubbel"},{"$f":"IFERROR(VLOOKUP(X18,'Vaste waarden'!C$4:F$23,4,FALSE),\"niet dubbel\")","v":"niet dubbel"},"Deze gebruikersnaam komt al voor bij licentie niet dubbel"]
[null,null,null,null,{"$f":"IF('Vaste waarden'!A19<>\"\",'Vaste waarden'!A19,\"\")","v":""},"",{"$f":"IF('Vaste waarden'!B19<>0,'Vaste waarden'!B19,\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(E19,'Vaste waarden'!A$4:A18,1,FALSE),\"niet dubbel\")","v":"niet dubbel"},"",null,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,45990,"",{"$f":"IFERROR(VLOOKUP(S19,#REF!,2,FALSE),ROW(T19))","v":19},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IFERROR(VLOOKUP(V19,#REF!,2,FALSE),ROW(W19))","v":19},{"$f":"IF('Vaste waarden'!C19<>\"\",'Vaste waarden'!C19,IF('Vaste waarden'!D19<>\"\",'Vaste waarden'!D19,\"\"))","v":""},"",{"$f":"IF('Vaste waarden'!F19=AA19,\"niet dubbel\",AA19)","v":"niet dubbel"},{"$f":"IFERROR(VLOOKUP(X19,'Vaste waarden'!C$4:F$23,4,FALSE),\"niet dubbel\")","v":"niet dubbel"},"Deze gebruikersnaam komt al voor bij licentie niet dubbel"]
[null,null,null,null,{"$f":"IF('Vaste waarden'!A20<>\"\",'Vaste waarden'!A20,\"\")","v":""},"",{"$f":"IF('Vaste waarden'!B20<>0,'Vaste waarden'!B20,\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(E20,'Vaste waarden'!A$4:A19,1,FALSE),\"niet dubbel\")","v":"niet dubbel"},"",null,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,45990,"",{"$f":"IFERROR(VLOOKUP(S20,#REF!,2,FALSE),ROW(T20))","v":20},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IFERROR(VLOOKUP(V20,#REF!,2,FALSE),ROW(W20))","v":20},{"$f":"IF('Vaste waarden'!C20<>\"\",'Vaste waarden'!C20,IF('Vaste waarden'!D20<>\"\",'Vaste waarden'!D20,\"\"))","v":""},"",{"$f":"IF('Vaste waarden'!F20=AA20,\"niet dubbel\",AA20)","v":"niet dubbel"},{"$f":"IFERROR(VLOOKUP(X20,'Vaste waarden'!C$4:F$23,4,FALSE),\"niet dubbel\")","v":"niet dubbel"},"Deze gebruikersnaam komt al voor bij licentie niet dubbel"]
[null,null,null,null,{"$f":"IF('Vaste waarden'!A21<>\"\",'Vaste waarden'!A21,\"\")","v":""},"",{"$f":"IF('Vaste waarden'!B21<>0,'Vaste waarden'!B21,\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(E21,'Vaste waarden'!A$4:A20,1,FALSE),\"niet dubbel\")","v":"niet dubbel"},"",null,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,45990,"",{"$f":"IFERROR(VLOOKUP(S21,#REF!,2,FALSE),ROW(T21))","v":21},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IFERROR(VLOOKUP(V21,#REF!,2,FALSE),ROW(W21))","v":21},{"$f":"IF('Vaste waarden'!C21<>\"\",'Vaste waarden'!C21,IF('Vaste waarden'!D21<>\"\",'Vaste waarden'!D21,\"\"))","v":""},"",{"$f":"IF('Vaste waarden'!F21=AA21,\"niet dubbel\",AA21)","v":"niet dubbel"},{"$f":"IFERROR(VLOOKUP(X21,'Vaste waarden'!C$4:F$23,4,FALSE),\"niet dubbel\")","v":"niet dubbel"},"Deze gebruikersnaam komt al voor bij licentie niet dubbel"]
[null,null,null,null,{"$f":"IF('Vaste waarden'!A22<>\"\",'Vaste waarden'!A22,\"\")","v":""},"",{"$f":"IF('Vaste waarden'!B22<>0,'Vaste waarden'!B22,\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(E22,'Vaste waarden'!A$4:A21,1,FALSE),\"niet dubbel\")","v":"niet dubbel"},"",null,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,45990,"",{"$f":"IFERROR(VLOOKUP(S22,#REF!,2,FALSE),ROW(T22))","v":22},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IFERROR(VLOOKUP(V22,#REF!,2,FALSE),ROW(W22))","v":22},{"$f":"IF('Vaste waarden'!C22<>\"\",'Vaste waarden'!C22,IF('Vaste waarden'!D22<>\"\",'Vaste waarden'!D22,\"\"))","v":""},"",{"$f":"IF('Vaste waarden'!F22=AA22,\"niet dubbel\",AA22)","v":"niet dubbel"},{"$f":"IFERROR(VLOOKUP(X22,'Vaste waarden'!C$4:F$23,4,FALSE),\"niet dubbel\")","v":"niet dubbel"},"Deze gebruikersnaam komt al voor bij licentie niet dubbel"]
[null,null,null,null,{"$f":"IF('Vaste waarden'!A23<>\"\",'Vaste waarden'!A23,\"\")","v":""},"",{"$f":"IF('Vaste waarden'!B23<>0,'Vaste waarden'!B23,\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(E23,'Vaste waarden'!A$4:A22,1,FALSE),\"niet dubbel\")","v":"niet dubbel"},"",null,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,45990,"",{"$f":"IFERROR(VLOOKUP(S23,#REF!,2,FALSE),ROW(T23))","v":23},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IFERROR(VLOOKUP(V23,#REF!,2,FALSE),ROW(W23))","v":23},{"$f":"IF('Vaste waarden'!C23<>\"\",'Vaste waarden'!C23,IF('Vaste waarden'!D23<>\"\",'Vaste waarden'!D23,\"\"))","v":""},"",{"$f":"IF('Vaste waarden'!F23=AA23,\"niet dubbel\",AA23)","v":"niet dubbel"},{"$f":"IFERROR(VLOOKUP(X23,'Vaste waarden'!C$4:F$23,4,FALSE),\"niet dubbel\")","v":"niet dubbel"},"Deze gebruikersnaam komt al voor bij licentie niet dubbel"]

{"sheet":"Vaste waarden","index":4,"n_rows":32,"n_cols":13,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
["e-mailadres",null,"gebruikersnaam",null,null,"Licentienummer",null,"PW"]
[null,null,null,null,null,null,null,"pw2"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Wordt gevuld vanuit ThisWorkbook"]
[null,{"$f":"IF(C4<>\"\",C4,D4)","v":0},null,null,null,1,null,null,null,null,null,null,"De macro's zijn niet ingeschakeld. Daardoor werken de knoppen niet en zijn maar een beperkt aantal schermen zichtbaar."]
[null,0,null,null,null,2,null,null,null,null,null,null,"Schakel de macro's in om de tool te gebruiken."]
[null,0,null,null,null,3]
[null,0,null,null,null,4]
[null,0,null,null,null,5]
[null,0,null,null,null,6]
[null,0,null,null,null,7]
[null,0,null,null,null,8]
[null,0,null,null,null,9]
[null,0,null,null,null,10]
[null,0,null,null,null,11]
[null,0,null,null,null,12]
[null,0,null,null,null,13]
[null,0,null,null,null,14]
[null,0,null,null,null,15]
[null,0,null,null,null,16]
[null,0,null,null,null,17]
[null,0,null,null,null,18]
[null,0,null,null,null,19]
[null,0,null,null,null,20]
[null,"Vaste gebruikers (wij dus)"]
[null,"henkg"]
[null,"monie"]
[null,"hansscheers"]
[]
[]
[]
["Zoek","Naam","Adres","Plaats","E-mail","betalingstermijn","soort factuur "]
[null,{"$f":"Bestelformulier!C15","v":0},{"$f":"Bestelformulier!C16","v":0},{"$f":"Bestelformulier!C17","v":0},{"$f":"Bestelformulier!C18","v":0},14,"normaal"]

{"sheet":"Import data","index":5,"n_rows":1053,"n_cols":12,"rows_kept":1053,"cut":false,"hidden":true,"merged":[[5,2,5,5],[6,2,6,5],[9,2,9,4],[10,2,10,4],[12,6,12,9],[417,1,417,4],[418,1,418,4],[419,1,419,4],[420,1,420,4],[421,1,421,4],[422,1,422,4],[423,1,423,4],[424,1,424,4],[425,1,425,4],[426,1,426,4],[427,1,427,4],[505,2,505,5],[506,2,506,5],[509,2,509,5],[510,2,510,5],[512,6,512,7],[917,1,917,4],[918,1,918,4],[919,1,919,4],[920,1,920,4],[926,1,926,4],[927,1,927,4],[921,1,921,4],[922,1,922,4],[923,1,923,4],[924,1,924,4],[925,1,925,4]]}
["Tool kostprijs en gelijkwaardigheid"]
["Versie: …..."]
[]
[null,"Arbeidsvoorwaardenpakket zoals van toepassing bij de opdrachtgever",null,null,null,null,null,null,"Opmerkingen"]
[]
[null,"Naam opdrachtgever","Og"]
[null,"CAO opdrachtgever","Cao"]
[]
[]
[null,"Naam medewerker (optioneel)","naam mdw"]
[null,"Functie","Functie mdw"]
[null,"Komt deze functienaam voor in de cao/arb.vrw. van de opdrachtgever?",null,null,null,null,"Nee"]
[null,"Zo nee: wat is een vergelijkbare functie?",null,null,null,null,"Andere functie"]
[]
[null,"Functieschaal","A"]
[null,"Trede",1]
[]
[null,"Normale arbeidsduur (NAD)",38,"uur per week"]
[null,"Let op: soms zijn er keuzemogelijkheden voor de NAD, hier invullen welke"]
[null,"bij de opdrachtgever van toepassing is."]
[]
[null,"Loonelementen",null,null,null,null,null,null,"Opmerkingen"]
[null,"Bruto loon",2890,"per","maand"]
[null,"Berekenen uurloon:"]
[null,"Is er een eenduidige berekeningsmethodiek gedefinieerd om een maand-/periodeloon"]
[null,"om te rekenen naar een uurloon?",null,null,null,null,"Ja"]
[null,"Zo ja:"]
[null,"Bruto loon per maand delen door",null,170,"uur"]
[null,"Of bruto loon per maand vermenigvuldigen met",null,null,"%"]
[null,"Zo nee:"]
[null,"Uurloon wordt berekend d.m.v. de formule in art. 26 lid d van de uitzend-cao."]
[null,"Berekende uurloon",null,0]
[]
[null,"Door o.a. cao-verhogingen en periodieken kan het uurloon wijzigen. Vul hier de van toepassing zijnde uurlonen in bij de opdrachtgever:"]
[null,null,"Vanaf","Tot en met",null,"Bedrag"]
[null,"Uurloon 1","2026-01-01","2026-01-31",null,1]
[null,"Uurloon 2","2026-02-01","2026-02-28",null,2]
[null,"Uurloon 3","2026-03-01","2026-03-31",null,3]
[null,"Uurloon 4","2026-04-01","2026-04-30",null,4]
[null,"Uurloon 5","2026-05-01","2026-05-31",null,5]
[null,"Uurloon 6","2026-06-01","2026-06-30",null,6]
[]
[]
[null,"Vakantiebijslag",null,null,null,null,null,null,"Opmerkingen"]
[null,"Wat is het percentage vakantiebijslag bij de opdrachtgever?",null,null,null,null,8.33,"%","Fout: Reservering op meerdere plekken ingevuld."]
[]
[null,"Werkbare dagen",null,null,null,null,null,null,"Opmerkingen"]
[null,"Werkdagen",null,261]
[]
[null,"Uitgedrukt in dagen"]
[null,"Vakantiedagen",null,25,null,null,null,null,"Fout: Reservering op meerdere plekken ingevuld."]
[null,"Feestdagen",null,7,null,null,null,null,"Fout: Reservering op meerdere plekken ingevuld."]
[null,"ADV",null,13,null,null,null,null,"Fout: Reservering op meerdere plekken ingevuld."]
[null,"Seniorendagen",null,5,null,null,null,null,"Fout: Reservering op meerdere plekken ingevuld."]
[null,"Overige gegarandeerde dagen",null,2,null,null,null,null,"Fout: Reservering op meerdere plekken ingevuld."]
[]
[null,"Uitgedrukt in percentage",null,null,null,null,"In dagen"]
[null,"Vakantiedagen",null,2,"%",null,5.22,null,"Fout: Reservering op meerdere plekken ingevuld."]
[null,"Feestdagen",null,3,"%",null,7.83,null,"Fout: Reservering op meerdere plekken ingevuld."]
[null,"ADV",null,4,"%",null,10.44,null,"Fout: Reservering op meerdere plekken ingevuld."]
[null,"Seniorendagen",null,5,"%",null,13.05,null,"Fout: Reservering op meerdere plekken ingevuld."]
[null,"Overige gegarandeerde dagen",null,6,"%",null,15.66,null,"Fout: Reservering op meerdere plekken ingevuld."]
[]
[null,"Werkbare dagen",null,156.80000000000001]
[]
[null,"Directe uitbetaling reserveringen in een percentage",null,null,null,null,null,null,"Opmerkingen"]
[null,"In sommige situaties worden bij de opdrachtgever de reserveringen direct uitbetaald in een percentage.",null,null,null,null,null,null,"Voorbeeld: Horecao-cao"]
[null,"In dat geval worden niet het aantal werkbare dagen verminderd, maar wordt er extra geld uitbetaald."]
[null,"Veelal geldt dat uitsluitend voor de oproepkrachten."]
[null,"Is dat van toepassing?           In dat geval percentages hieronder invullen én hierboven geen reserveringen invullen."]
[]
[null,"Reserveringen die extra worden uitbetaald",null,null,null,"Vakantiebijslag over deze items?"]
[null,"Vakantiebijslag",null,1,"%",null,null,null,"Fout: Reservering op meerdere plekken ingevuld."]
[]
[null,"Vakantiedagen",null,2,"%",null,null,"%","Fout: Reservering op meerdere plekken ingevuld."]
[null,"Feestdagen",null,3,"%",null,null,"%","Fout: Reservering op meerdere plekken ingevuld."]
[null,"ADV",null,4,"%",null,null,"%","Fout: Reservering op meerdere plekken ingevuld."]
[null,"Seniorendagen",null,5,"%",null,null,"%","Fout: Reservering op meerdere plekken ingevuld."]
[null,"Overige gegarandeerde dagen",null,6,"%",null,null,"%","Fout: Reservering op meerdere plekken ingevuld."]
[]
[null,"Totaal",null,21,"%",null,0,"%"]
[]
[null,null,null,null,null,21,"%"]
[]
[]
[null,"Deze regels verbergen. Alleen tbv juiste berekening"]
[null,"Van toepassing zijnde vakantiebijslag",null,9.33,"%"]
[]
[]
[null,"Plekken ingevulde reserveringen",null,"regel 44 t/m 55",null,"regel 58 t/m 62","regel 73 t/m 79"]
[null,"Vakantiebijslag",null,1,null,null,1,null,2]
[]
[null,"Vakantiedagen",null,1,null,1,1,null,3]
[null,"Feestdagen",null,1,null,1,1,null,3]
[null,"ADV",null,1,null,1,1,null,3]
[null,"Seniorendagen",null,1,null,1,1,null,3]
[null,"Overige gegarandeerde dagen",null,1,null,1,1,null,3]
[]
[]
[]
[]
[]
[]
[null,"Vaste onvoorwaardelijke uitkeringen bij opdrachtgever (geen kostenvergoedingen)",null,null,null,null,null,null,null,null,null,"Toelichting"]
[]
[null,"Soort toeslagen (ook structureel overwerk)","Toeslag-percentage ","(gemiddeld) aantal uren op jaarbasis",null,"Toe te passen uurloon","Berekende toeslag",null,"Vakantiebijslag over de toeslag?","Bedrag extra vakantiebijslag"]
[]
[null,"Fysieke belasting",null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0,null,"Vrije keuze soort toeslag"]
[null,null,null,null,null,null,0,null,null,0,null,"Vrije keuze soort toeslag"]
[null,null,null,null,null,null,0,null,null,0,null,"Vrije keuze soort toeslag"]
[]
[null,"Totaal",null,null,null,null,0,null,null,0]
[]
[null,"Vaste onvoorwaardelijke uitkeringen in bedragen (op jaarbasis)",null,null,null,null,"Bedrag op jaarbasis",null,"Vakantiebijslag over deze bedragen?","Bedrag extra vakantiebijslag"]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[]
[null,"Totaal",null,null,null,null,0,null,null,0]
[]
[null,"Vaste eindejaarsuitkeringen / 13e maand / comp. PAWW etc.",null,"Percentage",null,"Grondslag","Bedrag op jaarbasis",null,"Vakantiebijslag over deze bedragen?","Bedrag extra vakantiebijslag"]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0]
[]
[null,"Totaal",null,null,null,null,0,null,null,0]
[]
[null,"Totaal generaal",null,null,null,null,0,null,null,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Variabele voorwaardelijke uitkeringen bij opdrachtgever (geen kostenvergoedingen)",null,null,null,null,null,null,null,null,null,"Toelichting"]
[]
[null,"Soort toeslagen (ook incidenteel overwerk)","Toeslag-percentage ","Aantal uren op jaarbasis",null,"Toe te passen uurloon","Berekende toeslag",null,"Vakantiebijslag over de toeslag?","Bedrag extra vakantiebijslag"]
[]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0,null,"Vrije keuze soort toeslag"]
[null,null,null,null,null,null,0,null,null,0,null,"Vrije keuze soort toeslag"]
[null,null,null,null,null,null,0,null,null,0,null,"Vrije keuze soort toeslag"]
[]
[null,"Totaal",null,null,null,null,0,null,null,0]
[]
[null,"Variabele voorwaardelijke uitkeringen in bedragen (op jaarbasis)",null,null,null,null,"Bedrag op jaarbasis",null,"Vakantiebijslag over deze bedragen?","Bedrag extra vakantiebijslag"]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[]
[null,"Totaal",null,null,null,null,0,null,null,0]
[]
[null,"Variabele voorwaardelijke uitkeringen (bijv. winstgerelateerde eindejaarsuitkering)",null,null,null,"Grondslag","Bedrag op jaarbasis",null,"Vakantiebijslag over deze bedragen?","Bedrag extra vakantiebijslag"]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[]
[null,"Totaal",null,null,null,null,0,null,null,0]
[]
[null,"Totaal generaal",null,null,null,null,0,null,null,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Vergoedingen en verstrekkingen bij opdrachtgever",null,null,null,null,null,null,null,null,null,"Toelichting"]
[null,"Dit kan (deels) bij de opdrachtgever zijn opgenomen in het IKB."]
[null,"Netto vergoedingen en verstrekkingen",null,"Bedragen",null,"Bedragen vast/onvoor- waardelijk","Is het een kosten-vergoeding?",null,"Bedragen variabel/voor- waardelijk"]
[null,null,null,null,null,null,null,null,null,null,null,"Vaste onvoorwaardelijke vergoedingen en verstrekkingen tellen"]
[null,null,null,null,null,null,null,null,null,null,null,"mee als Gebruikelijk loon, tenzij er sprake is van een kostenvergoeding."]
[null,null,null,null,null,null,null,null,null,null,null,"Daarom moet bij de vaste onvoorwaardelijke vergoedingen worden"]
[null,null,null,null,null,null,null,null,null,null,null,"vermeld of het een kostenvergoeding is of niet."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Totaal",null,0,null,0,null,null,0]
[]
[null,"Bruto vergoedingen en verstrekkingen",null,"Bedragen",null,"Bedragen vast/onvoor- waardelijk","Is het een kosten-vergoeding?",null,"Bedragen variabel/voor- waardelijk"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Totaal",null,0,null,0,null,null,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Regeling bij arbeidsongeschiktheid bij opdrachtgever"]
[]
[null,"Aantal wachtdagen"]
[]
[null,"Percentage doorbetaling bij arbeidsongeschiktheid:"]
[null,"Periode","Percentage"]
[null,null,null,"%"]
[null,null,null,"%"]
[null,null,null,"%"]
[null,null,null,"%"]
[null,null,null,"%"]
[null,null,null,"%"]
[]
[null,"Bijzonderheden"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Arbeidsvoorwaardenpakket zoals van toepassing bij jullie medewerker"]
[]
[null,"Naam opdrachtgever"]
[null,"CAO opdrachtgever"]
[]
[]
[null,"Naam medewerker"]
[null,"Functie"]
[null,"Komt deze functienaam voor in de cao/arb.vrw. van de opdrachtgever?"]
[null,"Zo nee: wat is een vergelijkbare functie?"]
[]
[null,"Functieschaal"]
[null,"Trede"]
[]
[null,"Normale arbeidsduur (NAD)",null,"uur per week"]
[]
[]
[]
[null,"Loonelementen"]
[null,"Bruto loon",null,"per"]
[null,"Berekenen uurloon:"]
[null,"Is er een eenduidige berekeningsmethodiek gedefinieerd om een maand-/periodeloon"]
[null,"om te rekenen naar een uurloon?",null,null,null,null,"Nee"]
[null,"Zo ja:"]
[null,"Bruto loon per  delen door",null,null,"uur"]
[null,"Of bruto loon per  vermenigvuldigen met",null,null,"%"]
[null,"Zo nee:"]
[null,"Uurloon wordt berekend d.m.v. de formule in art. 26 lid d van de uitzend-cao."]
[null,"Berekende uurloon"]
[]
[null,"Toegekende uurloon aan jullie medewerker"]
[null,null,"Vanaf","Tot en met",null,"Bedrag"]
[null,"Uurloon 1","2026-01-01","2026-12-31",null,18]
[null,"Uurloon 2"]
[null,"Uurloon 3"]
[null,"Uurloon 4"]
[null,"Uurloon 5"]
[null,"Uurloon 6"]
[]
[]
[null,"Vakantiebijslag"]
[null,"Welk percentage vakantiebijslag ontvangt jullie medewerker?",null,null,null,null,8,"%"]
[]
[null,"Werkbare dagen"]
[null,"Werkdagen",null,0]
[]
[null,"Aantal (verlof)dagen toegekend aan jullie medewerker:"]
[null,"Vakantiedagen",null,25]
[null,"Feestdagen",null,10]
[null,"ADV",null,13]
[null,"Seniorendagen",null,5]
[null,"Overige gegarandeerde dagen",null,6]
[]
[null,"Uitgedrukt in percentage",null,null,null,null,0]
[null,"Vakantiedagen",null,null,"%",null,0]
[null,"Feestdagen",null,null,"%",null,0]
[null,"ADV",null,null,"%",null,0]
[null,"Seniorendagen",null,null,"%",null,0]
[null,"Overige gegarandeerde dagen",null,null,"%",null,0]
[]
[null,"Werkbare dagen",null,-59]
[]
[null,"Berekening reserveringen in percentage van werkbare dagen"]
[null,"Vakantiedagen",null,0.15943877551020408]
[null,"Feestdagen",null,6.3775510204081634E-2]
[null,"ADV",null,8.2908163265306117E-2]
[null,"Seniorendagen",null,3.1887755102040817E-2]
[null,"Overige gegarandeerde dagen",null,3.8265306122448974E-2]
[]
[null,"Totaal",null,0.37627551020408168]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Vaste onvoorwaardelijke uitkeringen jullie medewerker (geen kostenvergoedingen) ",null,null,null,null,null,null,null,null,null,"Toelichting"]
[]
[null,"Soort toeslagen (ook structureel overwerk)","Toeslag-percentage ","(gemiddeld) aantal uren op jaarbasis",null,"Toe te passen uurloon","Berekende toeslag",null,"Vakantiebijslag over de toeslag?","Bedrag extra vakantiebijslag"]
[]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0,null,"Vrije keuze soort toeslag"]
[null,null,null,null,null,null,0,null,null,0,null,"Vrije keuze soort toeslag"]
[null,null,null,null,null,null,0,null,null,0,null,"Vrije keuze soort toeslag"]
[]
[null,"Totaal",null,null,null,null,0,null,null,0]
[]
[null,"Vaste onvoorwaardelijke uitkeringen in bedragen (op jaarbasis)",null,null,null,null,"Bedrag op jaarbasis",null,"Vakantiebijslag over deze bedragen?","Bedrag extra vakantiebijslag"]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[]
[null,"Totaal",null,null,null,null,0,null,null,0]
[]
[null,"Vaste eindejaarsuitkeringen / 13e maand / comp. PAWW etc.",null,"Percentage",null,"Grondslag","Bedrag op jaarbasis",null,"Vakantiebijslag over deze bedragen?","Bedrag extra vakantiebijslag"]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0]
[]
[null,"Totaal",null,null,null,null,0,null,null,0]
[]
[null,"Totaal generaal",null,null,null,null,0,null,null,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Variabele voorwaardelijke uitkeringen jullie medewerker (geen kostenvergoedingen)"]
[]
[null,"Soort toeslagen (ook incidenteel overwerk)","Toeslag-percentage ","Aantal uren op jaarbasis",null,"Toe te passen uurloon","Berekende toeslag",null,"Vakantiebijslag over de toeslag?","Bedrag extra vakantiebijslag"]
[]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,0,null,null,0,null,"Vrije keuze soort toeslag"]
[null,null,null,null,null,null,0,null,null,0,null,"Vrije keuze soort toeslag"]
[null,null,null,null,null,null,0,null,null,0,null,"Vrije keuze soort toeslag"]
[]
[null,"Totaal",null,null,null,null,0,null,null,0]
[]
[null,"Variabele voorwaardelijke uitkeringen in bedragen (op jaarbasis)",null,null,null,null,"Bedrag op jaarbasis",null,"Vakantiebijslag over deze bedragen?","Bedrag extra vakantiebijslag"]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[]
[null,"Totaal",null,null,null,null,0,null,null,0]
[]
[null,"Variabele voorwaardelijke uitkeringen (bijv. winstgerelateerde eindejaarsuitkering)",null,null,null,"Grondslag","Bedrag op jaarbasis",null,"Vakantiebijslag over deze bedragen?","Bedrag extra vakantiebijslag"]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[]
[null,"Totaal",null,null,null,null,0,null,null,0]
[]
[null,"Totaal generaal",null,null,null,null,0,null,null,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Vergoedingen en verstrekkingen jullie medewerker",null,null,null,null,null,null,null,null,null,"Toelichting"]
[]
[null,"Netto vergoedingen en verstrekkingen",null,null,null,"Bedragen vast/onvoor- waardelijk","Is het een kosten-vergoeding?",null,"Bedragen variabel/voor- waardelijk"]
[null,null,null,null,null,null,null,null,null,null,null,"Vaste onvoorwaardelijke vergoedingen en verstrekkingen tellen"]
[null,null,null,null,null,null,null,null,null,null,null,"mee als Gebruikelijk loon, tenzij er sprake is van een kostenvergoeding."]
[null,null,null,null,null,null,null,null,null,null,null,"Daarom moet bij de vaste onvoorwaardelijke vergoedingen worden"]
[null,null,null,null,null,null,null,null,null,null,null,"vermeld of het een kostenvergoeding is of niet."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Totaal",null,null,null,0,null,null,0]
[]
[null,"Bruto vergoedingen en verstrekkingen",null,null,null,"Bedragen vast/onvoor- waardelijk","Is het een kosten-vergoeding?",null,"Bedragen variabel/voor- waardelijk"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Totaal",null,null,null,0,null,null,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Regeling bij arbeidsongeschiktheid jullie medewerker"]
[]
[null,"Aantal wachtdagen"]
[]
[null,"Percentage doorbetaling bij arbeidsongeschiktheid:"]
[null,"Periode","Percentage"]
[null,null,null,"%"]
[null,null,null,"%"]
[null,null,null,"%"]
[null,null,null,"%"]
[null,null,null,"%"]
[null,null,null,"%"]
[]
[null,"Bijzonderheden"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Gelijkwaardigheid pensioenregeling"]
[]
[null,"Pensioenfonds opdrachtgever"]
[null,"ABP"]
[]
[null,"Werkgeverspremie pensioenfonds opdrachtgever"]
[null,0.20899999999999999]
[]
[null,"Het premiepercentage is hoger dan bij de StiPP. Er zal een berekening moeten worden gemaakt voor de (eventuele) compensatie."]
[]
[null,"Methode 1:"]
[null,"Premiepercentage opdrachtgever",0.20899999999999999]
[null,"Premiepercentage StiPP",0]
[]
[null,"Verschil",0.20899999999999999]
[]
[null,"Totale sv-loon",50000]
[null,"Totale franchise StiPP",10000]
[]
[null,"Pensioengrondslag",40000]
[]
[null,"Verschil",8360]
[]
[null,"Compensatie (x 0,853)",7131.08,null,"0,853 vanuit vaste waarden halen"]
[]
[]
[null,"Methode 2:",null,null,"Werkgevers percentage",null,"Bedrag grondslag","Bedrag franchise"]
[null,"Werkgeverspremie opdrachtgever",7942,null,0.20899999999999999,null,50000,12000]
[null,"Werkgeverspremie StiPP",0,null,0,null,50000,10000]
[]
[null,"Verschil",7942]
[]
[null,"Compensatie (x 0,853)",6774.5259999999998,null,"0,853 vanuit vaste waarden halen"]
[]
[null,"Methode 3:"]
[null,"Vrije methode van berekenen. Bedrag compensatie mag niet lager zijn dan van methode 2."]
[null,"Bedrag compensatie mag niet lager zijn dan van methode 2."]
[null,"Velden voor toelichting/berekening"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Definitieve bedrag compensatie hier invullen:"]
[null,null,1349.45,null,"Bedrag compensatie is lager dan bedrag van methode 2. Dat is niet toegestaan."]