{"text_format":"2","workbook":"xlsx","n_sheets":8,"sheets":["Basisgegevens","Dyslexie - 45A45","Dyslexie - 45A64","Toelichting","Bruto-netto en pensioen","Overzicht bouwstenen","Invulblad CAO","Pensioenpremie CAO"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":29,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Basisgegevens","index":0,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Naam organisatie:"]
[null,"Naam:"]
[null,"Eigen verklaring:","Met het invullen en opsturen van de kostprijs-gegevens voor bouwstenen jeugdhulp verklaar ik dat deze informatie te goeder trouw realistisch is ingevuld."]
[]
[null,"Datum:"]
[]
[]
[null,"Deze rekentool bevat de ambulante bouwstenen dyslexie die worden uitgevraagd voor het kostprijsonderzoek voor Zuid-Drenthe."]
[null,"Vult u graag de rekentool in voor alle bouwstenen die uw organisatie levert in Zuid-Drenthe, elk op het corresponderende tabblad."]

{"sheet":"Dyslexie - 45A45","index":1,"n_rows":40,"n_cols":21,"rows_kept":40,"cut":false,"hidden":false,"merged":[[40,0,42,14],[4,5,4,6],[4,7,4,8],[4,9,4,10],[4,11,4,12],[4,13,4,14],[33,18,33,19],[2,5,2,12],[34,13,34,14],[36,5,36,6],[34,5,34,6],[34,7,34,8],[34,9,34,10],[34,11,34,12]]}
["De groene vensters dienen gevuld te worden met de gegevens van de organisatie."]
["De sheet 'Toelichting' bevat noodzakelijke informatie voor het invullen van de groene vensters. Lees deze dus rustig door alvorens de groene vensters in te vullen. "]
["Bouwsteen:",{"$nulls":4},"Dyslexie - Diagnostiek (45A45) TRAJECT"]
[]
["CAO",null,"Vast component of cao afgeleid",null,null,"CAO WAOJ",null,"CAO WAOJ",null,"CAO WAOJ",null,"CAO Sociaal Werk",null,"CAO Jeugdzorg",{"$nulls":4},"Tariefstelling ZZP'er"]
["LOONKOSTEN PER UUR",{"$nulls":17},"Loonkosten per uur"]
["Ingezette functiewerkgroep en bijbehorend maandsalaris",{"$nulls":4},"FWG 20 - 5",1982.03,"FWG 30 - 8",2256,"FWG 25 - 7",2118,"Schaal 3 - 8",2193,"Schaal 3 - 7",2151.92]
["Bruto uurloon ",{"$nulls":5},{"$f":"G7/156","v":12.705320512820512},null,{"$f":"I7/156","v":14.461538461538462},null,{"$f":"K7/156","v":13.576923076923077},null,{"$f":"M7/156","v":14.057692307692308},null,{"$f":"O7/156","v":13.794358974358975}]
["Vakantietoeslag",null,"Ja",null,null,{"$f":"IF(F5<>\"\",8%,\"\")","v":0.08},{"$f":"F9*G8","v":1.0164256410256409},{"$f":"IF(H5<>\"\",8%,\"\")","v":0.08},{"$f":"H9*I8","v":1.1569230769230769},{"$f":"IF(J5<>\"\",8%,\"\")","v":0.08},{"$f":"J9*K8","v":1.0861538461538462},{"$f":"IF(L5<>\"\",8%,\"\")","v":0.08},{"$f":"L9*M8","v":1.1246153846153848},{"$f":"IF(N5<>\"\",8%,\"\")","v":0.08},{"$f":"O8*N9","v":1.103548717948718}]
["Bruto uurloon incl. vakantietoeslag",{"$nulls":5},{"$f":"G8+G9","v":13.721746153846153},null,{"$f":"I8+I9","v":15.618461538461538},null,{"$f":"K8+K9","v":14.663076923076924},null,{"$f":"M8+M9","v":15.182307692307694},null,{"$f":"O8+O9","v":14.897907692307692}]
["Eindejaarsuitkering ",null,"Ja",null,null,{"$f":"VLOOKUP(F5,Toelichting!$A$39:$C$44,2,0)","v":0},{"$f":"F11*G8","v":0},{"$f":"VLOOKUP(H5,Toelichting!$A$39:$C$44,2,0)","v":0},{"$f":"H11*I8","v":0},{"$f":"VLOOKUP(J5,Toelichting!$A$39:$C$44,2,0)","v":0},{"$f":"J11*K8","v":0},{"$f":"VLOOKUP(L5,Toelichting!$A$39:$C$44,2,0)","v":8.3000000000000004E-2},{"$f":"L11*M8","v":1.1667884615384616},{"$f":"VLOOKUP(N5,Toelichting!$A$39:$C$44,2,0)","v":8.3000000000000004E-2},{"$f":"N11*O8","v":1.144931794871795}]
["Onregelmatigheidstoeslag over bruto uurloon incl. vakantietoeslag",{"$nulls":4},0.01,{"$f":"F12*G10","v":0.13721746153846154},0.01,{"$f":"H12*I10","v":0.15618461538461539},0.01,{"$f":"J12*K10","v":0.14663076923076923},0.01,{"$f":"L12*M10","v":0.15182307692307695},0.01,{"$f":"N12*O10","v":0.14897907692307694}]
["Totaal bruto uurloon",null,null,null,{"$f":"SUM(E$9:E$11)","v":0},null,{"$f":"SUM(G$10:G$12)","v":13.858963615384615},null,{"$f":"SUM(I$10:I$12)","v":15.774646153846154},null,{"$f":"SUM(K$10:K$12)","v":14.809707692307693},null,{"$f":"SUM(M$10:M$12)","v":16.500919230769231},null,{"$f":"SUM(O$10:O$12)","v":16.191818564102565}]
["totale sociale lasten",{"$nulls":4},0.1739,null,0.1739,null,0.1739,null,0.1739,null,0.1739]
["werkgeversdeel OP",{"$nulls":4},{"$f":"(((G13*1878)-Toelichting!$B$46)*Toelichting!$B$47/(G13*1878))*0.5","v":6.140258187745877E-2},null,{"$f":"(((I13*1878)-Toelichting!$B$46)*Toelichting!$B$47/(I13*1878))*0.5","v":6.8215086151852664E-2},null,{"$f":"(((K13*1878)-Toelichting!$B$46)*Toelichting!$B$47/(K13*1878))*0.5","v":6.5003887799140528E-2},null,{"$f":"(((M13*1878)-Toelichting!$B$46)*Toelichting!$B$47/(M13*1878))*0.5","v":7.0384317182305631E-2},null,{"$f":"(((O13*1878)-Toelichting!$B$46)*Toelichting!$B$47/(O13*1878))*0.5","v":6.9484882142828858E-2}]
["werkgeversdeel AP",{"$nulls":4},{"$f":"IF(0.5*0.6%*((1878*G13-Toelichting!$B$48)/(1878*G13))>0,0.5*0.6%*((1878*G13-Toelichting!$B$48)/(1878*G13)),0)","v":5.8636502977076922E-4},null,{"$f":"IF(0.5*0.6%*((1878*I13-Toelichting!$B$48)/(1878*I13))>0,0.5*0.6%*((1878*I13-Toelichting!$B$48)/(1878*I13)),0)","v":8.7947831558358059E-4},null,{"$f":"IF(0.5*0.6%*((1878*K13-Toelichting!$B$48)/(1878*K13))>0,0.5*0.6%*((1878*K13-Toelichting!$B$48)/(1878*K13)),0)","v":7.413140131995083E-4},null,{"$f":"IF(0.5*0.6%*((1878*M13-Toelichting!$B$48)/(1878*M13))>0,0.5*0.6%*((1878*M13-Toelichting!$B$48)/(1878*M13)),0)","v":9.728111649166916E-4},null,{"$f":"IF(0.5*0.6%*((1878*O13-Toelichting!$B$48)/(1878*O13))>0,0.5*0.6%*((1878*O13-Toelichting!$B$48)/(1878*O13)),0)","v":9.3411227399824582E-4}]
["Totale pensioenpremies en sociale lasten ",{"$nulls":4},{"$f":"F14+F15+F16","v":0.23588894690722956},{"$f":"F17*G13","v":3.2691763324586876},{"$f":"H14+H15+H16","v":0.24299456446743625},{"$f":"H17*I13","v":3.8331532717817645},{"$f":"J14+J15+J16","v":0.23964520181234003},{"$f":"J17*K13","v":3.5490753887048418},{"$f":"L14+L15+L16","v":0.24525712834722233},{"$f":"L17*M13","v":4.0469680656279188},{"$f":"N14+N15+N16","v":0.24431899441682711},{"$f":"N17*O8","v":3.3702239132401193}]
["Brutoloon inclusief pensioenpremies en sociale lasten",{"$nulls":5},{"$f":"G13+G17","v":17.128139947843302},null,{"$f":"I13+I17","v":19.607799425627917},null,{"$f":"K13+K17","v":18.358783081012536},null,{"$f":"M13+M17","v":20.54788729639715},null,{"$f":"O13+O17","v":19.562042477342686},null,null,null,"Bruto Uurloon",null,20]
["Overig personeelskosten zorgverleners",{"$nulls":17},"Overige kosten ZZP-hulpverlening"]
["Verlof",null,"Ja",null,null,{"$f":"VLOOKUP(F5,Toelichting!$A$39:$C$44,3,0)","v":9.5899999999999999E-2},null,{"$f":"VLOOKUP(H5,Toelichting!$A$39:$C$44,3,0)","v":9.5899999999999999E-2},null,{"$f":"VLOOKUP(J5,Toelichting!$A$39:$C$44,3,0)","v":9.5899999999999999E-2},null,{"$f":"VLOOKUP(L5,Toelichting!$A$39:$C$44,3,0)","v":0.107},null,{"$f":"VLOOKUP(N5,Toelichting!$A$39:$C$44,3,0)","v":0.1065}]
["Scholing",null,"Ja",null,null,{"$f":"IF(F5=\"CAO Jeugdzorg\",1.5%,2%)","v":0.02},null,{"$f":"IF(H5=\"CAO Jeugdzorg\",1.5%,2%)","v":0.02},null,{"$f":"IF(J5=\"CAO Jeugdzorg\",1.5%,2%)","v":0.02},null,{"$f":"IF(L5=\"CAO Jeugdzorg\",1.5%,2%)","v":0.02},null,{"$f":"IF(N5=\"CAO Jeugdzorg\",1.5%,2%)","v":1.4999999999999999E-2}]
["Ziekteverzuim",null,"Nee",null,null,6.7000000000000004E-2,null,{"$f":"F22","v":6.7000000000000004E-2},null,{"$f":"F22","v":6.7000000000000004E-2},null,{"$f":"F22","v":6.7000000000000004E-2},null,{"$f":"F22","v":6.7000000000000004E-2}]
["Wel gewerkte, niet declarabele activiteiten",{"$nulls":4},0.01,null,0.01,null,0.01,null,0.01,null,0.01,{"$nulls":4},"Wel gewerkte, niet declarabele activiteiten",0.01]
["Opslag Bruto/Netto calculatie",{"$nulls":4},{"$f":"SUM(F20:F23)","v":0.19290000000000002},{"$f":"G18/(1-F24)-G18","v":4.0936912352112174},{"$f":"SUM(H20:H23)","v":0.19290000000000002},{"$f":"I18/(1-H24)-I18","v":4.6863393745553559},{"$f":"SUM(J20:J23)","v":0.19290000000000002},{"$f":"K18/(1-J24)-K18","v":4.3878196708305275},{"$f":"SUM(L20:L23)","v":0.20400000000000001},{"$f":"M18/(1-L24)-M18","v":5.2660414679208749},{"$f":"SUM(N20:N23)","v":0.19850000000000001},{"$f":"O18/(1-N24)-O18","v":4.8447478874017769},null,null,null,"Opslag Bruto/Netto calculatie",{"$f":"SUM(T23)","v":0.01},{"$f":"U18/(1-T23)-U18","v":0.20202020202020066}]
["Reiskosten cliënt naar cliënt",null,"Ja",null,null,null,0.5,null,0.5,null,0.5,null,0.5,null,0.5,null,null,null,"Reiskosten cliënt naar cliënt",null,0.5]
["Totaal overige personeelskosten zorgverleners",{"$nulls":5},{"$f":"SUM(G$24:G$25)","v":4.5936912352112174},null,{"$f":"SUM(I$24:I$25)","v":5.1863393745553559},null,{"$f":"SUM(K$24:K$25)","v":4.8878196708305275},null,{"$f":"SUM(M$24:M$25)","v":5.7660414679208749},null,{"$f":"SUM(O24:O25)","v":5.3447478874017769},null,null,null,"Totaal overige personeelskosten zzp'er",null,{"$f":"SUM(U24:U25)","v":0.70202020202020066}]
["Totale directe kostprijs per uur",{"$nulls":5},{"$f":"G26+G18","v":21.721831183054519},null,{"$f":"I18+I26","v":24.794138800183273},null,{"$f":"K18+K26","v":23.246602751843064},null,{"$f":"M18+M26","v":26.313928764318025},null,{"$f":"O18+O26","v":24.906790364744463},null,null,null,"Totale directe kostprijs per uur",null,{"$f":"U18+U26","v":20.702020202020201}]
[]
["Overhead ",{"$nulls":17},"Overhead "]
["Totaal overhead",{"$nulls":4},0.01,{"$f":"F30*G27","v":0.21721831183054519},0.01,{"$f":"H30*I27","v":0.24794138800183274},0.01,{"$f":"J30*K27","v":0.23246602751843065},0.01,{"$f":"L30*M27","v":0.26313928764318023},0.01,{"$f":"N30*O27","v":0.24906790364744463},null,null,null,"Totaal overhead",0.01,{"$f":"T30*U27","v":0.20702020202020202}]
["Risico-opslag",{"$nulls":17},"Risico-opslag"]
["Totale opslag voor risico / marge",{"$nulls":4},0.02,{"$f":"F32*G27","v":0.43443662366109037},0.02,{"$f":"H32*I27","v":0.49588277600366548},0.02,{"$f":"J32*K27","v":0.4649320550368613},0.02,{"$f":"L32*M27","v":0.52627857528636046},0.02,{"$f":"N32*O27","v":0.49813580729488927},null,null,null,"Totale opslag voor risico / marge",0.02,{"$f":"T32*U27","v":0.41404040404040404}]
["Ongewogen tarief per uur",{"$nulls":5},{"$f":"IF(F5<>\"\",SUM(G27+G30+G32),0)","v":22.373486118546154},null,{"$f":"IF(H5<>\"\",SUM(I27+I30+I32),0)","v":25.537962964188772},null,{"$f":"IF(J5<>\"\",SUM(K27+K30+K32),0)","v":23.944000834398356},null,{"$f":"IF(L5<>\"\",SUM(M27+M30+M32),0)","v":27.103346627247568},null,{"$f":"IF(N5<>\"\",SUM(O27+O30+O32),0)","v":25.653994075686796},{"$nulls":5},{"$f":"SUM(U27+U30+U32)","v":21.323080808080807}]
["Calculatie bij trajectprijs",{"$nulls":17},"Calculatie bij trajectprijs "]
["Te verwachten gemiddelde totaal in te zetten uren",{"$nulls":4},1,null,1,null,1,null,1,null,1,{"$nulls":4},"Te verwachten gemiddelde totaal in te zetten uren",1]
["Gewogen gemiddelde trajectprijs ",{"$nulls":13},{"$f":"F35*G33+H35*I33+J35*K33+L35*M33+N35*O33","v":124.61279062006764},{"$nulls":5},{"$f":"SUM(T35*U33)","v":21.323080808080807}]
["Gemiddelde duur van het traject in maanden",{"$nulls":4},4,{"$nulls":12},"Gemiddelde duur van het traject",4]
["Indexatie (wordt nader bepaald)",{"$nulls":13},0]
[]
["Opmerkingen"]

{"sheet":"Dyslexie - 45A64","index":2,"n_rows":40,"n_cols":21,"rows_kept":40,"cut":false,"hidden":false,"merged":[[36,5,36,6],[40,0,42,14],[33,18,33,19],[34,5,34,6],[34,7,34,8],[34,9,34,10],[34,11,34,12],[34,13,34,14],[4,13,4,14],[2,5,2,12],[4,5,4,6],[4,7,4,8],[4,9,4,10],[4,11,4,12]]}
["De groene vensters dienen gevuld te worden met de gegevens van de organisatie."]
["De sheet 'Toelichting' bevat noodzakelijke informatie voor het invullen van de groene vensters. Lees deze dus rustig door alvorens de groene vensters in te vullen. "]
["Bouwsteen:",{"$nulls":4},"Dyslexie - Behandeling (45A64) TRAJECT"]
[]
["CAO",null,"Vast component of cao afgeleid",null,null,"CAO WAOJ",null,"CAO WAOJ",null,"CAO WAOJ",null,"CAO Sociaal Werk",null,"CAO Jeugdzorg",{"$nulls":4},"Tariefstelling ZZP'er"]
["LOONKOSTEN PER UUR",{"$nulls":17},"Loonkosten per uur"]
["Ingezette functiewerkgroep en bijbehorend maandsalaris",{"$nulls":4},"FWG 20 - 5",1982.03,"FWG 30 - 8",2256,"FWG 25 - 7",2118,"Schaal 3 - 8",2193,"Schaal 3 - 7",2151.92]
["Bruto uurloon ",{"$nulls":5},{"$f":"G7/156","v":12.705320512820512},null,{"$f":"I7/156","v":14.461538461538462},null,{"$f":"K7/156","v":13.576923076923077},null,{"$f":"M7/156","v":14.057692307692308},null,{"$f":"O7/156","v":13.794358974358975}]
["Vakantietoeslag",null,"Ja",null,null,{"$f":"IF(F5<>\"\",8%,\"\")","v":0.08},{"$f":"F9*G8","v":1.0164256410256409},{"$f":"IF(H5<>\"\",8%,\"\")","v":0.08},{"$f":"H9*I8","v":1.1569230769230769},{"$f":"IF(J5<>\"\",8%,\"\")","v":0.08},{"$f":"J9*K8","v":1.0861538461538462},{"$f":"IF(L5<>\"\",8%,\"\")","v":0.08},{"$f":"L9*M8","v":1.1246153846153848},{"$f":"IF(N5<>\"\",8%,\"\")","v":0.08},{"$f":"O8*N9","v":1.103548717948718}]
["Bruto uurloon incl. vakantietoeslag",{"$nulls":5},{"$f":"G8+G9","v":13.721746153846153},null,{"$f":"I8+I9","v":15.618461538461538},null,{"$f":"K8+K9","v":14.663076923076924},null,{"$f":"M8+M9","v":15.182307692307694},null,{"$f":"O8+O9","v":14.897907692307692}]
["Eindejaarsuitkering ",null,"Ja",null,null,{"$f":"VLOOKUP(F5,Toelichting!$A$39:$C$44,2,0)","v":0},{"$f":"F11*G8","v":0},{"$f":"VLOOKUP(H5,Toelichting!$A$39:$C$44,2,0)","v":0},{"$f":"H11*I8","v":0},{"$f":"VLOOKUP(J5,Toelichting!$A$39:$C$44,2,0)","v":0},{"$f":"J11*K8","v":0},{"$f":"VLOOKUP(L5,Toelichting!$A$39:$C$44,2,0)","v":8.3000000000000004E-2},{"$f":"L11*M8","v":1.1667884615384616},{"$f":"VLOOKUP(N5,Toelichting!$A$39:$C$44,2,0)","v":8.3000000000000004E-2},{"$f":"N11*O8","v":1.144931794871795}]
["Onregelmatigheidstoeslag over bruto uurloon incl. vakantietoeslag",{"$nulls":4},0.01,{"$f":"F12*G10","v":0.13721746153846154},0.01,{"$f":"H12*I10","v":0.15618461538461539},0.01,{"$f":"J12*K10","v":0.14663076923076923},0.01,{"$f":"L12*M10","v":0.15182307692307695},0.01,{"$f":"N12*O10","v":0.14897907692307694}]
["Totaal bruto uurloon",null,null,null,{"$f":"SUM(E$9:E$11)","v":0},null,{"$f":"SUM(G$10:G$12)","v":13.858963615384615},null,{"$f":"SUM(I$10:I$12)","v":15.774646153846154},null,{"$f":"SUM(K$10:K$12)","v":14.809707692307693},null,{"$f":"SUM(M$10:M$12)","v":16.500919230769231},null,{"$f":"SUM(O$10:O$12)","v":16.191818564102565}]
["totale sociale lasten",{"$nulls":4},0.1739,null,0.1739,null,0.1739,null,0.1739,null,0.1739]
["werkgeversdeel OP",{"$nulls":4},{"$f":"(((G13*1878)-Toelichting!$B$46)*Toelichting!$B$47/(G13*1878))*0.5","v":6.140258187745877E-2},null,{"$f":"(((I13*1878)-Toelichting!$B$46)*Toelichting!$B$47/(I13*1878))*0.5","v":6.8215086151852664E-2},null,{"$f":"(((K13*1878)-Toelichting!$B$46)*Toelichting!$B$47/(K13*1878))*0.5","v":6.5003887799140528E-2},null,{"$f":"(((M13*1878)-Toelichting!$B$46)*Toelichting!$B$47/(M13*1878))*0.5","v":7.0384317182305631E-2},null,{"$f":"(((O13*1878)-Toelichting!$B$46)*Toelichting!$B$47/(O13*1878))*0.5","v":6.9484882142828858E-2}]
["werkgeversdeel AP",{"$nulls":4},{"$f":"IF(0.5*0.6%*((1878*G13-Toelichting!$B$48)/(1878*G13))>0,0.5*0.6%*((1878*G13-Toelichting!$B$48)/(1878*G13)),0)","v":5.8636502977076922E-4},null,{"$f":"IF(0.5*0.6%*((1878*I13-Toelichting!$B$48)/(1878*I13))>0,0.5*0.6%*((1878*I13-Toelichting!$B$48)/(1878*I13)),0)","v":8.7947831558358059E-4},null,{"$f":"IF(0.5*0.6%*((1878*K13-Toelichting!$B$48)/(1878*K13))>0,0.5*0.6%*((1878*K13-Toelichting!$B$48)/(1878*K13)),0)","v":7.413140131995083E-4},null,{"$f":"IF(0.5*0.6%*((1878*M13-Toelichting!$B$48)/(1878*M13))>0,0.5*0.6%*((1878*M13-Toelichting!$B$48)/(1878*M13)),0)","v":9.728111649166916E-4},null,{"$f":"IF(0.5*0.6%*((1878*O13-Toelichting!$B$48)/(1878*O13))>0,0.5*0.6%*((1878*O13-Toelichting!$B$48)/(1878*O13)),0)","v":9.3411227399824582E-4}]
["Totale pensioenpremies en sociale lasten ",{"$nulls":4},{"$f":"F14+F15+F16","v":0.23588894690722956},{"$f":"F17*G13","v":3.2691763324586876},{"$f":"H14+H15+H16","v":0.24299456446743625},{"$f":"H17*I13","v":3.8331532717817645},{"$f":"J14+J15+J16","v":0.23964520181234003},{"$f":"J17*K13","v":3.5490753887048418},{"$f":"L14+L15+L16","v":0.24525712834722233},{"$f":"L17*M13","v":4.0469680656279188},{"$f":"N14+N15+N16","v":0.24431899441682711},{"$f":"N17*O8","v":3.3702239132401193}]
["Brutoloon inclusief pensioenpremies en sociale lasten",{"$nulls":5},{"$f":"G13+G17","v":17.128139947843302},null,{"$f":"I13+I17","v":19.607799425627917},null,{"$f":"K13+K17","v":18.358783081012536},null,{"$f":"M13+M17","v":20.54788729639715},null,{"$f":"O13+O17","v":19.562042477342686},null,null,null,"Bruto Uurloon",null,20]
["Overig personeelskosten zorgverleners",{"$nulls":17},"Overige kosten ZZP-hulpverlening"]
["Verlof",null,"Ja",null,null,{"$f":"VLOOKUP(F5,Toelichting!$A$39:$C$44,3,0)","v":9.5899999999999999E-2},null,{"$f":"VLOOKUP(H5,Toelichting!$A$39:$C$44,3,0)","v":9.5899999999999999E-2},null,{"$f":"VLOOKUP(J5,Toelichting!$A$39:$C$44,3,0)","v":9.5899999999999999E-2},null,{"$f":"VLOOKUP(L5,Toelichting!$A$39:$C$44,3,0)","v":0.107},null,{"$f":"VLOOKUP(N5,Toelichting!$A$39:$C$44,3,0)","v":0.1065}]
["Scholing",null,"Ja",null,null,{"$f":"IF(F5=\"CAO Jeugdzorg\",1.5%,2%)","v":0.02},null,{"$f":"IF(H5=\"CAO Jeugdzorg\",1.5%,2%)","v":0.02},null,{"$f":"IF(J5=\"CAO Jeugdzorg\",1.5%,2%)","v":0.02},null,{"$f":"IF(L5=\"CAO Jeugdzorg\",1.5%,2%)","v":0.02},null,{"$f":"IF(N5=\"CAO Jeugdzorg\",1.5%,2%)","v":1.4999999999999999E-2}]
["Ziekteverzuim",null,"Nee",null,null,6.7000000000000004E-2,null,{"$f":"F22","v":6.7000000000000004E-2},null,{"$f":"F22","v":6.7000000000000004E-2},null,{"$f":"F22","v":6.7000000000000004E-2},null,{"$f":"F22","v":6.7000000000000004E-2}]
["Wel gewerkte, niet declarabele activiteiten",{"$nulls":4},0.01,null,0.01,null,0.01,null,0.01,null,0.01,{"$nulls":4},"Wel gewerkte, niet declarabele activiteiten",0.01]
["Opslag Bruto/Netto calculatie",{"$nulls":4},{"$f":"SUM(F20:F23)","v":0.19290000000000002},{"$f":"G18/(1-F24)-G18","v":4.0936912352112174},{"$f":"SUM(H20:H23)","v":0.19290000000000002},{"$f":"I18/(1-H24)-I18","v":4.6863393745553559},{"$f":"SUM(J20:J23)","v":0.19290000000000002},{"$f":"K18/(1-J24)-K18","v":4.3878196708305275},{"$f":"SUM(L20:L23)","v":0.20400000000000001},{"$f":"M18/(1-L24)-M18","v":5.2660414679208749},{"$f":"SUM(N20:N23)","v":0.19850000000000001},{"$f":"O18/(1-N24)-O18","v":4.8447478874017769},null,null,null,"Opslag Bruto/Netto calculatie",{"$f":"SUM(T23)","v":0.01},{"$f":"U18/(1-T23)-U18","v":0.20202020202020066}]
["Reiskosten cliënt naar cliënt",null,"Ja",null,null,null,0.5,null,0.5,null,0.5,null,0.5,null,0.5,null,null,null,"Reiskosten cliënt naar cliënt",null,0.5]
["Totaal overige personeelskosten zorgverleners",{"$nulls":5},{"$f":"SUM(G$24:G$25)","v":4.5936912352112174},null,{"$f":"SUM(I$24:I$25)","v":5.1863393745553559},null,{"$f":"SUM(K$24:K$25)","v":4.8878196708305275},null,{"$f":"SUM(M$24:M$25)","v":5.7660414679208749},null,{"$f":"SUM(O24:O25)","v":5.3447478874017769},null,null,null,"Totaal overige personeelskosten zzp'er",null,{"$f":"SUM(U24:U25)","v":0.70202020202020066}]
["Totale directe kostprijs per uur",{"$nulls":5},{"$f":"G26+G18","v":21.721831183054519},null,{"$f":"I18+I26","v":24.794138800183273},null,{"$f":"K18+K26","v":23.246602751843064},null,{"$f":"M18+M26","v":26.313928764318025},null,{"$f":"O18+O26","v":24.906790364744463},null,null,null,"Totale directe kostprijs per uur",null,{"$f":"U18+U26","v":20.702020202020201}]
[]
["Overhead ",{"$nulls":17},"Overhead "]
["Totaal overhead",{"$nulls":4},0.01,{"$f":"F30*G27","v":0.21721831183054519},0.01,{"$f":"H30*I27","v":0.24794138800183274},0.01,{"$f":"J30*K27","v":0.23246602751843065},0.01,{"$f":"L30*M27","v":0.26313928764318023},0.01,{"$f":"N30*O27","v":0.24906790364744463},null,null,null,"Totaal overhead",0.01,{"$f":"T30*U27","v":0.20702020202020202}]
["Risico-opslag",{"$nulls":17},"Risico-opslag"]
["Totale opslag voor risico / marge",{"$nulls":4},0.02,{"$f":"F32*G27","v":0.43443662366109037},0.02,{"$f":"H32*I27","v":0.49588277600366548},0.02,{"$f":"J32*K27","v":0.4649320550368613},0.02,{"$f":"L32*M27","v":0.52627857528636046},0.02,{"$f":"N32*O27","v":0.49813580729488927},null,null,null,"Totale opslag voor risico / marge",0.02,{"$f":"T32*U27","v":0.41404040404040404}]
["Ongewogen tarief per uur",{"$nulls":5},{"$f":"IF(F5<>\"\",SUM(G27+G30+G32),0)","v":22.373486118546154},null,{"$f":"IF(H5<>\"\",SUM(I27+I30+I32),0)","v":25.537962964188772},null,{"$f":"IF(J5<>\"\",SUM(K27+K30+K32),0)","v":23.944000834398356},null,{"$f":"IF(L5<>\"\",SUM(M27+M30+M32),0)","v":27.103346627247568},null,{"$f":"IF(N5<>\"\",SUM(O27+O30+O32),0)","v":25.653994075686796},{"$nulls":5},{"$f":"SUM(U27+U30+U32)","v":21.323080808080807}]
["Calculatie bij trajectprijs",{"$nulls":17},"Calculatie bij trajectprijs "]
["Te verwachten gemiddelde totaal in te zetten uren",{"$nulls":4},1,null,1,null,1,null,1,null,1,{"$nulls":4},"Te verwachten gemiddelde totaal in te zetten uren",1]
["Gewogen gemiddelde trajectprijs ",{"$nulls":13},{"$f":"F35*G33+H35*I33+J35*K33+L35*M33+N35*O33","v":124.61279062006764},{"$nulls":5},{"$f":"SUM(T35*U33)","v":21.323080808080807}]
["Gemiddelde duur van het traject in maanden",{"$nulls":4},4,{"$nulls":12},"Gemiddelde duur van het traject",4]
["Indexatie (wordt nader bepaald)",{"$nulls":13},0]
[]
["Opmerkingen"]

{"sheet":"Toelichting","index":3,"n_rows":48,"n_cols":3,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
["Deze sheet verschaft achterliggende informatie bij de factoren die samen de kostprijs per bouwsteen bepalen. "]
["Kostprijsfactor ","Toelichting"]
["CAO","Zes CAOs (Jeugdzorg, Gehandicaptenzorg, GGZ, Sociaal Werk en VVT; WAOJ) kunnen van toepassing zijn op de verschillende bouwstenen. Deze rij geeft de mogelijkheid om - middels een drop-down menu -  per bouwsteen aan te geven welke CAOs - en daarmee kostprijsfactoren - van toepassing zijn. "]
["Ingezette functiewerkgroep","In deze rij kunnen zorgaanbieders aangeven welke functiewerkgroep en trede zij per CAO in zullen zetten. "]
["Bruto uurloon","Het bruto uurloon hangt af van de positie in de salarisschaal binnen de van toepassing zijnde CAO. Vanuit het bruto fulltime maandsalaris zoals opgenomen in de CAOs wordt het uurtarief berekend. Hierbij wordt uitgegaan van een 36e urige werkwerkweek (1878 uren) op jaarbasis bij een fulltime positie, hetgeen neerkomt op 156 uren per maand."]
["Vakantietoeslag","Vanuit de CAOs vloeit voort dat de vakantietoeslag 8% van het feitelijk verdiende loont betreft. "]
["Eindejaarsuitkering","De eindejaarsuitkering is afhankelijk van de betreffende CAO. De percentages per 01-01-2019 bedragen:\nVVT: 8,33%\nGGZ: 8,33%\nJeugdzorg: 8,30%\nGHZ: 7,05%\nSociaal Werk: 8,30% \nWAOJ: het betreft hier een  winstuitkering van ten hoogste 8%. Aangezien dit percentage organisatie-afhankelijk is, vragen we zorgaanbieders hier zelf het gemiddelde percentage in te vullen. "]
["Totale pensioenpremies en sociale lasten","Het totale bedrag voor het werkgeversdeel van pensioenpremies en sociale lasten wordt berekend op een aparte sheet. Aldaar is tevens een uitleg per factor opgenomen.\nDe vooraf berekende percentages kunnen voor uw organisatie afwijken: overschrijf in dat geval de formules in de betreffende cellen met de realistische waardes."]
["Verlof","Het aantal verlofuren is afhankelijk van de CAO. Het aantal verlofuren bedraagt respectievelijk: \nVVT: 237,5\nGGZ: 201\nJeugdzorg: 200\nGHZ: 114 + een afhankelijk component. Een fictief totaal is daarom gebaseerd op de andere CAO's.\nSociaal Werk: 170 + een afhankelijk component. Een fictief totaal is daarom gebaseerd op de andere CAO's.\nHet veld verlof is standaard vooraf ingevuld, maar kan worden overschreven als er sprake is van extra bovenwettelijk verlof."]
["Scholing","Het percentage van de uren dat beschikbaar is voor scholing is afhankelijk van de CAO. De percentages bedragen:\nVVT: 2,0%\nGGZ: 2,0% (deze informatie mist uit de CAO en is gebaseerd op de andere CAO's)\nJeugdzorg: 1,5%\nGHZ: 2,0%\nSociaal Werk: 2,0% (deze informatie mist uit de CAO en is gebaseerd op de andere CAO's) \nWAOJ: 2,0% (deze informatie mist uit de CAO en is gebaseerd op de andere CAO's)\nHet veld scholing is standaard vooraf ingevuld, maar kan worden overschreven als er sprake is van extra extra scholingstijd."]
["Ziekteverzuim","Ziekteverzuim wisselt per organisatie.\nHet gemiddelde in de sector Jeugdhulp bedroeg over 2018 6,7% volgens het CBS. "]
["Cliëntgebonden tijd ","Onder cliëntgebonden tijd wordt verstaan: \nDirect cliëntgebonden tijd. Dit betreft de contacttijd die een professional aan een cliënt besteedt bij een activititeit: face to face contacttijd, telefonische contacttijd (ear to ear), elektronische contacttijd (bit-to-bit)                                                                                                                                       Indirect cliëntgebonden tijd: indirecte tijd die samenhangt met het uitvoeren van een direct cliëntgebonden activiteit, zoals een behandel-, begeleidings- of verplegingsactiviteit. Denk hierbij aan: het voorbereiden van een activiteit, verslaglegging en administratie in het kader van de activiteit, het opruimen van de speelkamer bij een behandelcontact met kleine kinderen, hersteltijd na een intensieve behandelsessie. De reistijd van cliënt naar cliënt valt hier tevens onder. "]
["Wel gewerkte, niet-declarabele activiteiten","Hieronder vallen onder andere het lezen van vakliteratuur, algemene vergaderingen en intervisiebijeenkomsten. Tevens moet hier de tijd voor no-shows in worden opgenomen, aangezien deze tijd niet gedeclareerd mag worden. De reistijd van cliënt naar cliënt aansluitend bij een no-show of overige indirect cliëntgebonden werkzaamheden die een zorgverlener in deze tijd oppakt (tevens voor andere cliënten), mogen wél gedeclareerd worden (en gelden dus niet als opslag voor niet-declarabele tijd bij een no-show)."]
["Onregelmatigheidstoeslag","Deze rij laat toe om een extra uitkering volgend uit onregelmatige diensten op te nemen middels een opslag over het bruto-uurloon inclusief vakantiegeld. "]
["Reiskosten cliënt naar cliënt","Zorgaanbieders kunnen hier de reiskosten van cliënt naar cliënt toeberekend per uur invullen. Onder deze reistijd valt niet de tijd die nodig is om op het terrein van de eigen organisatie de cliënt te bereiken, ook niet als de instelling op meerdere locaties werkt. Voor de op de lijst activiteiten en verrichtingen voorkomende categoriën pré-intake en algemeen indirecte tijd geldt dat er geen reistijd mag worden geregistreerd, maar alleen 'wel gewerkte - niet direct cliëntgebonden' tijd."]
["Overhead","Hieronder vallen de huisvestingskosten niet direct toe te rekenen aan cliënten, ICT-kosten, management kosten en andere algemene kosten en zakelijke lasten. In deze post moet ook het beschikbaarheidscomponent opgenomen worden. Er wordt gerekend met een percentage overhead over de totale directe kostprijs per uur.  Materiële cliëntgebonden kosten, zoals spreek- en behandelkamers, groepsgrootte, vallen hier voor dyslexie-bouwstenen ook onder. "]
["Risico-opslag ","Hier kunnen zorgaanbieders een percentage opnemen voor het risico.  "]
["Te verwachten gemiddelde totaal in te zetten uren","Vul voor elke relevante functie de totale verwachte inzet in uren in het hele traject in. "]
["Gemiddelde duur van het traject in maanden","Vul de gemiddelde duur van een traject in, in maanden."]
["Indexatie","Een passend indexatie-percentage wordt later bepaald."]
[]
["Als deze bouwsteen wordt geleverd door een ZZP'er - vul dan enkel de \"ZZP-kolom\" in."]
["Bruto-uurloon","Het uurloon waarin alle eventuele premies voor pensioenvoorziening, verzekeringen, en opslagen voor verlof, verzuim, scholing, en andere opslagen voor zover van toepassing zijn verdisconteerd."]
["Wel gewerkte, niet-declarabele activiteiten","Hieronder vallen onder andere het lezen van vakliteratuur, algemene vergaderingen, intervisiebijeenkomsten en bovenwettelijk verlof. Tevens moet hier de tijd voor no-shows in worden opgenomen, aangezien deze tijd niet gedeclareerd mag worden. "]
["Reiskosten cliënt naar cliënt","Zorgaanbieders kunnen hier de reiskosten van cliënt naar cliënt toeberekend per uur invullen. Onder deze reistijd valt niet de tijd die nodig is om op het terrein van de eigen organisatie de cliënt te bereiken, ook niet als de instelling op meerdere locaties werkt. Voor de op de lijst activiteiten en verrichtingen voorkomende categoriën pré-intake en algemeen indirecte tijd geldt dat er geen reistijd mag worden geregistreerd, maar alleen 'wel gewerkte - niet direct cliëntgebonden' tijd."]
["Overhead - niet cliëntgebonden kosten","Hieronder vallen de huisvestingskosten niet direct toe te rekenen aan cliënten, ICT-kosten, management kosten en andere algemene kosten en zakelijke lasten. In deze post moet ook het beschikbaarheidscomponent opgenomen worden. Er wordt gerekend met een percentage overhead over de totale directe kostprijs per uur."]
["Risico-opslag ","Hier kunnen zorgaanbieders een percentage opnemen voor het risico.  "]
["Te verwachten gemiddelde totaal in te zetten uren","Vul voor elke relevante functie de totale verwachte inzet in uren in het hele traject in. "]
["Gemiddelde duur van het traject in maanden","Vul de gemiddelde duur van een traject in, in maanden."]
[]
[]
["Hulp-tabellen:"]
[]
[]
[]
[]
["CAO"]
[null,"Percentage eindejaarsuitkering","Verlof"]
["CAO VVT",8.3299999999999999E-2,0.1265]
["CAO GGZ",8.3299999999999999E-2,0.1071]
["CAO Jeugdzorg",8.3000000000000004E-2,0.1065]
["CAO WAOJ",0,9.5899999999999999E-2]
["CAO Sociaal Werk",8.3000000000000004E-2,0.107]
["CAO GHZ",7.0499999999999993E-2,0.107]
[]
["OP-franchise",12426]
["OP % (werkgevers +werknemersdeel)",0.23499999999999999]
["AP franchise",20940]

{"sheet":"Bruto-netto en pensioen","index":4,"n_rows":39,"n_cols":17,"rows_kept":39,"cut":false,"hidden":false,"merged":[[2,9,2,10],[2,11,2,12],[0,0,0,8],[2,1,2,2],[2,3,2,4],[2,5,2,6],[2,7,2,8]]}
["Bruto-netto berekening"]
[{"$nulls":14},"Elementen sociale lasten"]
["Percentages per CAO","CAO VVT",null,"CAO GGZ",null,"CAO Jeugdzorg",null,"CAO GHZ",null,"CAO Sociaal Werk",null,"CAO WAOJ",null,null,"WGA / WIA (+ WKO)",6.7699999999999996E-2,"Het bedraagt hier de premie voor 2019, bestaande uit een basispremie (6,27%) en een verplichte bijdrage van de werkgever in kinderopvang (0,5%)"]
["Bruto uren",1,null,1,null,1,null,1,null,1,null,1,null,null,"WW",2.07E-2,"Het bedraagt hier de premie voor 2019"]
["Verlof",{"$f":"(237.5)/(36/7*365)","v":0.1265220700152207},{"$f":"B5/$B$9","v":0.16294354949367437},{"$f":"(201)/(36/7*365)","v":0.10707762557077624},{"$f":"D5/D9","v":0.13453274968876752},{"$f":"(200)/(36/7*365)","v":0.106544901065449},{"$f":"F5/F9","v":0.13293932649138931},0.107,{"$f":"H5/H9","v":0.13442211055276382},0.107,{"$f":"J5/J9","v":0.13442211055276382},{"$f":"(190)/(38/7*365)","v":9.5890410958904104E-2},{"$f":"L5/L9","v":0.11880717595342759},null,"Sectorfonds",4.7000000000000002E-3,"Het bedraagt hier de premie voor 2019, sector gezondheid"]
["Scholing",0.02,{"$f":"B6/$B$9","v":2.5757332214699322E-2},0.02,{"$f":"D6/D9","v":2.512807861990626E-2},1.4999999999999999E-2,{"$f":"F6/F9","v":1.8715958036752026E-2},0.02,{"$f":"H6/H9","v":2.5125628140703515E-2},0.02,{"$f":"J6/J9","v":2.5125628140703515E-2},0.02,{"$f":"L6/L9","v":2.4779782413143471E-2},null,"ZVW",6.9500000000000006E-2,"Het bedraagt hier de premie voor 2019"]
["Ziekteverzuim",6.7000000000000004E-2,{"$f":"B7/B9","v":8.6287062919242735E-2},6.7000000000000004E-2,{"$f":"D7/D9","v":8.4179063376685972E-2},6.7000000000000004E-2,{"$f":"F7/F9","v":8.3597945897492379E-2},6.7000000000000004E-2,{"$f":"H7/H9","v":8.4170854271356788E-2},6.7000000000000004E-2,{"$f":"J7/J9","v":8.4170854271356788E-2},6.7000000000000004E-2,{"$f":"L7/L9","v":8.3012271084030628E-2},null,"WHK",1.1299999999999999E-2,"Het landelijke percentage voor 2019 is door UWV/SZW vastgesteld op: 1,13% (WGA: 0,80% + Ziektewet Flex 0,33% = 1,13%)."]
["Wel gewerkte, niet-direct (cliëntgebonden) activiteit",0.01,{"$f":"B8/B9","v":1.2878666107349661E-2},0.01,{"$f":"D8/D9","v":1.256403930995313E-2},0.01,{"$f":"F8/F9","v":1.2477305357834685E-2},0.01,{"$f":"H8/H9","v":1.2562814070351758E-2},0.01,{"$f":"J8/J9","v":1.2562814070351758E-2},0.01,{"$f":"L8/L9","v":1.2389891206571736E-2},null,"WGA eigen risico; herverzekerd",0,"Het eigen risico is vastgesteld op 0%, waarbij ervan uit wordt gegaan dat het WGA volledig geregeld is via het UWV. "]
["Netto uren",{"$f":"B4-B5-B6-B7-B8","v":0.77647792998477927},null,{"$f":"D4-D5-D6-D7-D8","v":0.79592237442922364},null,{"$f":"F4-F5-F6-F7-F8","v":0.80145509893455102},null,{"$f":"H4-H5-H6-H7-H8","v":0.79600000000000004},null,{"$f":"J4-SUM(J5:J8)","v":0.79600000000000004},null,{"$f":"L4-(SUM(L5:L8))","v":0.80710958904109587},null,null,"Totaal Sociale lasten",{"$f":"SUM(P$3:P$8)","v":0.1739}]
[]
[]
["De netto berekening is gebaseerd op de aangegeven verplichte factoren (o.g.v. de CAO's en wetgeving)"]
["van improductiviteit. Deze verplichte factoren gelden evenzeer voor de (kosten van) vervanging gedurende verlof, scholing en ziekteverzuim.",{"$nulls":13},"Elementen pensioen - voorbeeld"]
["Dit is derhalve in de rekenpercentages meegenomen.",{"$nulls":14},"CAO VVT"]
[{"$nulls":14},"Fulltime salaris",{"$f":"'Dyslexie - 45A45'!G8*1878","v":23860.591923076921}]
["Nb. Een realistisch percentage voor niet-clientgebonden activiteiten moet in de rekensheet worden ingevuld.",{"$nulls":13},"Vakantietoeslag",{"$f":"P15*Q16","v":1908.8473538461537},0.08]
[{"$nulls":14},"Eindejaarsuitkering",{"$f":"P15*Q17","v":1987.5873071923074},8.3299999999999999E-2]
[{"$nulls":14},"Onregelmatigheidstoeslag",{"$f":"P15*Q18","v":238.60591923076922},0.01]
[{"$nulls":15},{"$f":"SUM(P15:P18)","v":27995.632503346154}]
[{"$nulls":15},"Premies PZW"]
[{"$nulls":14},"OP Premie vaststellen"]
[{"$nulls":14},"% (werkgevers +werknemersdeel)",0.23499999999999999]
[{"$nulls":14},"Franchise ",12426]
[{"$nulls":14},"Grondslag",{"$f":"P19-P23","v":15569.632503346154}]
[{"$nulls":14},"Premie (per jaar)",{"$f":"P24*P22","v":3658.863638286346}]
[]
[{"$nulls":14},"Werkgeversdeel OP (toe te passen %, na aftrek franchise)",{"$f":"(P25/P19)*0.5","v":6.5347043647772982E-2}]
[]
[{"$nulls":14},"AP Premie vaststellen"]
[{"$nulls":14},"% (werkgevers +werknemersdeel)",6.0000000000000001E-3]
[{"$nulls":14},"Franchise (= frachisebedrag pensioenfonds)",20940]
[{"$nulls":14},"Grondslag",{"$f":"P19-P31","v":7055.6325033461544}]
[{"$nulls":14},"Premie (per jaar)",{"$f":"P30*P32","v":42.333795020076927}]
[]
[{"$nulls":14},"Werkgeversdeel AP (toe te passen %, na aftrek franchise)",{"$f":"IF(((P33/P19)*0.5)>0,(P33/P19)*0.5,0)","v":7.5607856002212154E-4}]
[]
[{"$nulls":14},"Totaal Werkgeversdeel pensioen",{"$f":"P27+P35","v":6.6103122207795101E-2}]
[]
[{"$nulls":14},"Totaal pensioenpremies en sociale lasten",{"$f":"P9+P37","v":0.2400031222077951}]

{"sheet":"Overzicht bouwstenen","index":5,"n_rows":43,"n_cols":15,"rows_kept":43,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,6,1,9],[1,11,1,14]]}
[]
[null,"Ambulant",{"$nulls":4},"Daghulp en dagbesteding",{"$nulls":4},"Jeugdhulp met verblijf"]
[null,"Bouwsteen","interventie-niveau","code","eenheid",null,"Bouwsteen","interventie-niveau","code","eenheid",null,"Bouwsteen","interventie-niveau","code","eenheid"]
[null,"Meedoen en zelfredzaamheid","Licht","50A03","per uur",null,"Meedoen en zelfredzaamheid","Dagbesteding basis","41A19","dagdeel",null,"Meedoen en zelfredzaamheid","Verblijf basis","43A15","etmaal"]
[null,null,"Midden","50A04","per uur",null,null,"Dagbesteding basis intensief","41A20","dagdeel",null,null,"Verblijf specialistisch","43A16","etmaal"]
[null,null,"Zwaar","50A05","per uur",null,null,"Dagbesteding licht specialistisch","41A21","dagdeel",null,null,"Zelfstandigheidstraining","43A17","etmaal"]
[{"$nulls":7},"Dagbesteding intensief specialistisch","50A06","dagdeel",null,null,"Logeren basis","43A32","etmaal"]
[{"$nulls":12},"Logeren specialistisch","43A33","etmaal"]
[]
[null,"Gezond zijn","Licht","45A33","traject",null,"Gezond zijn","Dagbehandeling","41A08","dagdeel",null,"Gezond zijn","Verblijf basis","43A18","etmaal"]
[null,null,"Midden","45A34","per uur",{"$nulls":7},"Verblijf specialistisch","43A19","etmaal"]
[null,null,"Zwaar","45A35","per uur",{"$nulls":7},"Intramur. Behand. Verslaving jeugd","43A01","etmaal"]
[null,null,"Medicijncontrole","45A14","traject (jaar)",{"$nulls":7},"Pilot bouwsteen","43B16","etmaal"]
[null,null,"Fact","45A41","traject (maand)",{"$nulls":7},"Intramur. Behand. Verslaving gezin","43B10","etmaal"]
[null,null,"Vaktherapie","nieuw","per uur",{"$nulls":7},"intramuraal zeer specialistisch","43B19","etmaal"]
[null,null,"Plus IV5","45A37","per uur",{"$nulls":7},"8GZ Gezinsbehandeling","43B11","etmaal"]
[null,null,"Plus IV6","45A44","per uur"]
[]
[null,"Gezond opgroeien","Licht","45A21","traject",null,"Gezond opgroeien","Dagbehandeling","41B05","dagdeel",null,"Gezond opgroeien","Gastgezin","43B01","etmaal"]
[null,null,"Opvoedproblematiek a","45A22","traject (maand)",null,null,"KDC","41B06","dagdeel",null,null,"Gezinshuis","43A04","etmaal"]
[null,null,"Opvoedproblematiek b","45A25","traject (maand)",{"$nulls":7},"Time-out","43A21","etmaal"]
[null,null,"Echtscheidingsproblematiek","45A28","traject (maand)"]
[null,null,"Zwaar","45A23","traject (maand)"]
[]
[null,"Dyslexie","Diagnostiek","45A45","traject"]
[null,null,"Behandeling","45A64","traject (maand)"]
[]
[]
[]
[null,"In te vullen factoren","tabblad",null,null,null,"In te vullen factoren","tabblad",null,null,null,"In te vullen factoren","tabblad"]
[null,"1. CAO van in te zetten functie","Kostprijs Ambulant",null,null,null,"1. CAO van in te zetten functie","Kostprijs Daghulp",null,null,null,"1. CAO van in te zetten functie","Kostprijs Residentieel"]
[null,"2. Functie-werkgroep","Kostprijs Ambulant",null,null,null,"2. Functie-werkgroep","Kostprijs Daghulp",null,null,null,"2. Functie-werkgroep","Kostprijs Residentieel"]
[null,"3. Salaris bij (1) en (2)","Kostprijs Ambulant",null,null,null,"3. Salaris bij (1) en (2)","Kostprijs Daghulp",null,null,null,"3. Salaris bij (1) en (2)","Kostprijs Residentieel"]
[null,"4. Onregelmatigheidstoeslag","Kostprijs Ambulant",null,null,null,"4. Onregelmatigheidstoeslag","Kostprijs Daghulp",null,null,null,"4. Onregelmatigheidstoeslag","Kostprijs Residentieel"]
[null,"5. Reiskosten client-client","Kostprijs Ambulant",null,null,null,"5. Reiskosten client-client","Kostprijs Daghulp",null,null,null,"5. Reiskosten client-client","Kostprijs Residentieel"]
[null,"6. Overhead (niet clientgebonden)","Kostprijs Ambulant",null,null,null,"6. Overhead (niet clientgebonden)","Kostprijs Daghulp",null,null,null,"6. Overhead (niet clientgebonden)","Kostprijs Residentieel"]
[null,"7. Risico / Marge","Kostprijs Ambulant",null,null,null,"7. Risico / Marge","Kostprijs Daghulp",null,null,null,"7. Risico / Marge","Kostprijs Residentieel"]
[null,"8. Weging inzet (bij meerdere functies)","Kostprijs Ambulant",null,null,null,"8. Inzet per functie (per dagdeel)","Kostprijs Daghulp",null,null,null,"8. Inzet per functie (per etmaal per kind)","Kostprijs Residentieel"]
[null,"9. Inzet niet-clientgebonden tijd (%)","Kostprijs Ambulant",null,null,null,"9. Inzet niet-clientgebonden tijd (%)","Kostprijs Daghulp",null,null,null,"9. Inzet niet-clientgebonden tijd (%)","Kostprijs Residentieel"]
[{"$nulls":6},"10. Gemiddelde groepsgrootte","Kostprijs Daghulp",null,null,null,"10. Niet-gebouwgebonden kosten","Kostprijs Residentieel"]
[null,"Optioneel (bouwstenen met trajectprijs)",{"$nulls":4},"11. Niet-gebouwgebonden kosten","Kostprijs Daghulp",null,null,null,"11. Gebouwgebonden kosten","Kostprijs Residentieel"]
[null,"10. Totale inzet (uren) in hele traject","Kostprijs Ambulant",null,null,null,"12. Gebouwgebonden kosten","Kostprijs Daghulp"]
[null,"11. Gemiddelde duur traject (maanden)","Kostprijs Ambulant"]

{"sheet":"Invulblad CAO","index":6,"n_rows":55,"n_cols":13,"rows_kept":55,"cut":false,"hidden":true,"merged":[[2,9,2,10],[2,6,2,7],[3,6,3,7],[3,9,3,10],[54,6,54,7],[54,9,54,10]]}
["De groene vensters dienen gevuld te worden met de gegevens van de organisatie."]
[]
["Ondersteuningsvorm: benaming van gemeente",{"$nulls":5},"HH-1",null,null,"HH-2"]
["CAO keuze",{"$nulls":5},"VVT",null,null,"VVT",null,null,"[Datum CAO]"]
["FWG schaal",{"$nulls":5},"FWG10","FWG15",null,"FWG15","FWG20"]
["Periodiek",{"$nulls":5},3,7,null,7,4]
["Inzetmix per FWG schaal",{"$nulls":5},0.75,0.25,null,0.6,0.4]
[]
[null,null,"Vaste componenten of cao afgeleid",null,"%",{"$nulls":7},"Pas toe en leg uit"]
["LOONKOSTEN PER UUR"]
["Bruto uurloon cao",{"$nulls":5},{"$f":"VLOOKUP(G4&G5&G6,#REF!,6,0)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(G4&H5&H6,#REF!,6,0)","v":{"$error":"#REF!"}},null,{"$f":"VLOOKUP(J4&J5&J6,#REF!,6,0)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(J4&K5&K6,#REF!,6,0)","v":{"$error":"#REF!"}}]
["Vakantietoeslag (minimum cao bepaald 0,98)",null,"Ja",null,0.08,null,{"$f":"IF((G$11*$E12)>0.98,(G$11*$E12),0.98)","v":{"$error":"#REF!"}},{"$f":"IF((H$11*$E12)>0.98,(H$11*$E12),0.98)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"}]
["Eindejaarsuitkering (minimum cao bepaald (0,94)",null,"Ja",null,7.3999999999999996E-2,null,{"$f":"IF((G$11*$E13)>0.94,(G$11*$E13),0.94)","v":{"$error":"#REF!"}},{"$f":"IF((H$11*$E13)>0.94,(H$11*$E13),0.94)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"}]
["Totaal bruto uurloon",null,null,null,{"$f":"SUM(E12:E13)","v":0.154},null,{"$f":"SUM(G11:G13)","v":{"$error":"#REF!"}},{"$f":"SUM(H11:H13)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"}]
[]
["OP werkgeversdeel (zie werkblad \"Pensioenpremie)",null,"Ja",null,null,null,{"$f":"G$14*'Pensioenpremie CAO'!B$16","v":{"$error":"#REF!"}},{"$f":"H$14*'Pensioenpremie CAO'!C$16","v":{"$error":"#REF!"}},null,{"$f":"J$14*'Pensioenpremie CAO'!D$16","v":{"$error":"#REF!"}},{"$f":"K$14*'Pensioenpremie CAO'!E$16","v":{"$error":"#REF!"}}]
["AP werkgeversdeel (zie werkblad \"Pensioenpremie)",null,"Ja",null,null,null,{"$f":"G$14*'Pensioenpremie CAO'!B$24","v":{"$error":"#REF!"}},{"$f":"H$14*'Pensioenpremie CAO'!C$24","v":{"$error":"#REF!"}},null,{"$f":"J$14*'Pensioenpremie CAO'!D$24","v":{"$error":"#REF!"}},{"$f":"K$14*'Pensioenpremie CAO'!E$24","v":{"$error":"#REF!"}}]
["Totaal pensioenpremies",{"$nulls":5},{"$f":"SUM(G16:G17)","v":{"$error":"#REF!"}},{"$f":"SUM(H16:H17)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"}]
[]
["WGA / WIA (+ WKO)",null,"Ja",null,6.6600000000000006E-2,null,{"$f":"G$14*$E20","v":{"$error":"#REF!"}},{"$f":"H$14*$E20","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"}]
["WW",null,"Ja",null,2.64E-2,null,{"$f":"G$14*$E21","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"}]
["Sectorfonds",null,"Ja",null,9.4000000000000004E-3,null,{"$f":"G$14*$E22","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"}]
["ZVW",null,"Ja",null,6.6500000000000004E-2,null,{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"}]
["WHK",null,"Nee",null,9.1000000000000004E-3,null,{"$f":"G$14*$E24","v":{"$error":"#REF!"}},{"$f":"H$14*$E24","v":{"$error":"#REF!"}},null,{"$f":"J$14*$E24","v":{"$error":"#REF!"}},{"$f":"K$14*$E24","v":{"$error":"#REF!"}},null,"Beschikking belastingdienst"]
["WGA eigen risico; herverzekerd",null,"Nee",null,0,null,{"$f":"G$14*$E25","v":{"$error":"#REF!"}},{"$f":"H$14*$E25","v":{"$error":"#REF!"}},null,{"$f":"J$14*$E25","v":{"$error":"#REF!"}},{"$f":"K$14*$E25","v":{"$error":"#REF!"}},null,"Eigen risicodrager: keuze onderneming"]
["Totaal Sociale lasten",null,null,null,{"$f":"SUM(E20:E25)","v":0.17799999999999999},null,{"$f":"SUM(G20:G25)","v":{"$error":"#REF!"}},{"$f":"SUM(H20:H25)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"}]
[]
["Totaal te verlonen kosten per uur",{"$nulls":5},{"$f":"G14+G18+G26","v":{"$error":"#REF!"}},{"$f":"H14+H18+H26","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"}]
[]
["KOSTPRIJS PER UUR"]
[]
["Verlof",null,"Ja",null,0.13589999999999999,null,{"$f":"G$28*$E32","v":{"$error":"#REF!"}},{"$f":"H$28*$E32","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"}]
["Ziekteverzuim",null,"Nee",null,6.3399999999999998E-2,null,{"$f":"G$28*$E33","v":{"$error":"#REF!"}},{"$f":"H$28*$E33","v":{"$error":"#REF!"}},null,{"$f":"J$28*$E33","v":{"$error":"#REF!"}},{"$f":"K$28*$E33","v":{"$error":"#REF!"}},null,"Bron: Brancheviewer Vernet"]
["Scholing",null,"Ja",null,0.02,null,{"$f":"G$28*$E34","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"}]
["Kosten niet-werkbare uren claimrecht (verlof, ziekteverzuim, scholing)",null,null,null,{"$f":"SUM(E32:E34)","v":0.21929999999999997},null,{"$f":"SUM(G32:G34)","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"}]
[]
["SECUNDAIR TOE TE BEREKENEN KOSTEN PER UUR"]
[]
["Niet planbaar, wel te verlonen tijd",null,"Nee",null,2.5000000000000001E-2,null,{"$f":"$E39*G$28","v":{"$error":"#REF!"}},{"$f":"$E39*H$28","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"}]
["Indirect Clientgebonden tijd (%)",null,"Nee",null,2.5000000000000001E-2,null,{"$f":"$E40*G$28","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"},null,"Rapportage clientdossier, casus overleg"]
["Organisatiegebonden tijd (%)",null,"Nee",null,2.5000000000000001E-2,null,{"$f":"$E41*G$28","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"},null,"Overige administratie, team overleg"]
[]
["Eerste reis naar werk",null,"Nee",null,null,null,0.28000000000000003,0.28000000000000003,null,0.28000000000000003,0.28000000000000003,null,"Ter vergelijking: onderzoek PWC april 2017 invloed op tarief eerste reis naar werk 3,4% tov de hier gehanteerde 1,9% (€0,28)"]
["Reiskosten client naar client, toe te berekenen per uur",null,"Nee",null,null,null,0.2,0.2,null,0.2,0.2]
["Totaal reiskosten per uur",{"$nulls":5},{"$f":"SUM(G43:G44)","v":0.48000000000000004},{"$f":"SUM(H43:H44)","v":0.48000000000000004},null,0.48000000000000004,0.48000000000000004]
[]
["Overhead over alle bovenstaande posten",null,"Nee",null,0.15,null,{"$f":"$E47*(G$28+G$35+G$39+G$40+G$45)","v":{"$error":"#REF!"}},{"$f":"$E47*(H$28+H$35+H$39+H$40+H$45)","v":{"$error":"#REF!"}},null,{"$f":"$E47*(J$28+J$35+J$39+J$40+J$45)","v":{"$error":"#REF!"}},{"$f":"$E47*(K$28+K$35+K$39+K$40+K$45)","v":{"$error":"#REF!"}},null,"Toelichting"]
["Totale kosten per uur in te zetten medewerker",{"$nulls":5},{"$f":"G$28+G$35+G$39+G$40+G$45+G$47","v":{"$error":"#REF!"}},{"$f":"H$28+H$35+H$39+H$40+H$45+H$47","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"}]
[]
["Opslag voor additionele administratieve lasten",null,"Nee",null,0,null,{"$f":"$E50*G$48","v":{"$error":"#REF!"}},{"$f":"$E50*H$48","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},null,"Gemeentelijke eisen, inkoopkenmerken, extra accountantscontroles"]
["RISICO & MARGE",null,"Nee",null,0.05,null,{"$f":"$E51*G$48","v":{"$error":"#REF!"}},{"$f":"$E51*H$48","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"}]
[]
["Ongewogen tarief totaal",{"$nulls":5},{"$f":"G$48+G$51","v":{"$error":"#REF!"}},{"$f":"H$48+H$51","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"}]
[]
["Gewogen tarief",{"$nulls":5},{"$f":"(G53*G7)+(H53*H7)","v":{"$error":"#REF!"}},null,null,{"$f":"(J53*J7)+(K53*K7)","v":{"$error":"#REF!"}},null,null,"Tarief per ondersteuningsvorm met de gekozen FWG inzetmix"]

{"sheet":"Pensioenpremie CAO","index":7,"n_rows":26,"n_cols":5,"rows_kept":26,"cut":false,"hidden":true,"merged":[[0,0,0,4]]}
["Berekening pensioenpremie (VVT / VGN beide Pensioenfonds PZW)"]
[]
["Ondersteuningsvorm; benaming gemeente ",{"$f":"'Invulblad CAO'!G3","v":"HH-1"},{"$f":"'Invulblad CAO'!G3","v":"HH-1"},{"$f":"'Invulblad CAO'!J3","v":"HH-2"},{"$f":"'Invulblad CAO'!J3","v":"HH-2"}]
["Cao",{"$f":"'Invulblad CAO'!G4","v":"VVT"},{"$f":"'Invulblad CAO'!G4","v":"VVT"},{"$f":"'Invulblad CAO'!J4","v":"VVT"},{"$f":"'Invulblad CAO'!J4","v":"VVT"}]
["FWG",{"$f":"'Invulblad CAO'!G5","v":"FWG10"},{"$f":"'Invulblad CAO'!H5","v":"FWG15"},{"$f":"'Invulblad CAO'!J5","v":"FWG15"},{"$f":"'Invulblad CAO'!K5","v":"FWG20"}]
[]
["Totaal Bruto uurloon",{"$f":"'Invulblad CAO'!G14","v":{"$error":"#REF!"}},{"$f":"'Invulblad CAO'!H14","v":{"$error":"#REF!"}},{"$f":"'Invulblad CAO'!J14","v":{"$error":"#REF!"}},{"$f":"'Invulblad CAO'!K14","v":{"$error":"#REF!"}}]
["Fulltime salaris",{"$f":"B7*1878","v":{"$error":"#REF!"}},{"$f":"C7*1878","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
["OP Premie vaststellen"]
["% (werkgevers +werknemersdeel)",0.23499999999999999,0.23499999999999999,0.23499999999999999,0.23499999999999999]
["Franchise ",11829,11829,11829,11829]
["Grondslag",{"$f":"B8-B12","v":{"$error":"#REF!"}},{"$f":"C8-C12","v":{"$error":"#REF!"}},{"$f":"D8-D12","v":{"$error":"#REF!"}},{"$f":"E8-E12","v":{"$error":"#REF!"}}]
["Premie (per jaar)",{"$f":"B13*B11","v":{"$error":"#REF!"}},{"$f":"C13*C11","v":{"$error":"#REF!"}},{"$f":"D13*D11","v":{"$error":"#REF!"}},{"$f":"E13*E11","v":{"$error":"#REF!"}}]
[]
["Werkgeversdeel OP (toe te passen %, na aftrek franchise)",{"$f":"(B14/B8)*0.5","v":{"$error":"#REF!"}},{"$f":"(C14/C8)*0.5","v":{"$error":"#REF!"}},{"$f":"(D14/D8)*0.5","v":{"$error":"#REF!"}},{"$f":"(E14/E8)*0.5","v":{"$error":"#REF!"}}]
[]
["AP Premie vaststellen"]
["% (werkgevers +werknemersdeel)",5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3]
["Franchise (= frachisebedrag pensioenfonds)",20108,20108,20108,20108]
["Grondslag",{"$f":"B8-B20","v":{"$error":"#REF!"}},{"$f":"C8-C20","v":{"$error":"#REF!"}},{"$f":"D8-D20","v":{"$error":"#REF!"}},{"$f":"E8-E20","v":{"$error":"#REF!"}}]
["Premie (per jaar)",{"$f":"B19*B21","v":{"$error":"#REF!"}},{"$f":"C19*C21","v":{"$error":"#REF!"}},{"$f":"D19*D21","v":{"$error":"#REF!"}},{"$f":"E19*E21","v":{"$error":"#REF!"}}]
[]
["Werkgeversdeel AP (toe te passen %, na aftrek franchise)",{"$f":"(B22/B8)*0.5","v":{"$error":"#REF!"}},{"$f":"(C22/C8)*0.5","v":{"$error":"#REF!"}},{"$f":"(D22/D8)*0.5","v":{"$error":"#REF!"}},{"$f":"(E22/E8)*0.5","v":{"$error":"#REF!"}}]
[]
["Totaal Werkgeversdeel",{"$f":"B16+B24","v":{"$error":"#REF!"}},{"$f":"C16+C24","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]