{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Schakeltool HvB 2020","Productcodelijst (seg 3)","Productcodelijst segment 2"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":36,"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":"Schakeltool HvB 2020","index":0,"n_rows":30,"n_cols":24,"rows_kept":30,"cut":false,"hidden":false,"merged":[[1,1,1,4],[15,5,15,16],[1,9,1,12],[5,1,5,6],[1,15,1,16],[1,5,2,7],[4,15,4,16],[5,9,5,11],[7,1,7,2],[2,9,2,11],[3,9,3,11],[15,1,15,2],[2,1,2,2],[3,3,3,4],[4,3,4,4],[12,1,12,6],[0,2,0,6],[34,16,54,18],[29,9,29,10],[16,11,16,12],[26,16,28,17],[22,11,22,12],[23,11,23,12],[17,11,17,12],[18,11,18,12],[19,11,19,12],[20,11,20,12],[21,11,21,12],[24,1,24,15],[14,1,14,17],[26,9,26,12],[27,9,27,10],[25,1,52,8],[16,21,16,22],[25,15,54,15],[28,9,28,10],[30,9,56,12],[17,2,17,3],[18,2,18,3],[21,2,21,3],[22,2,22,3],[23,2,23,3],[16,2,16,3],[19,2,19,3],[20,2,20,3],[8,3,8,4],[9,3,9,4],[10,3,10,4],[11,3,11,4],[4,9,4,11],[7,3,7,4]]}
[null,null,"Schakeltool HvB 2020"]
[null,"Jeugdhulp Arrangement",null,null,null,null,null,null,null,"Controle vragen"]
[null,"Aanvraag",null,null,null,null,null,null,null,"Vragen",null,null,"Stap 1.\nJa / Nee"]
[null,"Stap 1.\nKies Arrangement","Stap 2.\nKies Intensiteit","Stap 3.\nNaam zorgaanbieder",null,"Stap 4.\nStartdatum","Stap 5.\nEinddatum","Arrangement contractwaarde",null,"Is één van de afgegeven toewijzingen een landelijk gecontracteerd product?"]
[null,null,null,null,null,null,null,{"$f":"IF(B5=\"\",\"\",IF(C5=\"\",\"\",INDEX('Productcodelijst segment 2'!C6:K14,MATCH('Schakeltool HvB 2020'!B5,'Productcodelijst segment 2'!$B$6:$B$14,0),MATCH(C5,'Productcodelijst segment 2'!C5:K5,0))))","v":""},null,"Is er een eerdere beschikking op grond van de Jeugdwet afgegeven die nu nog loopt?"]
[null,"Subtotaal Contractwaarden arrangement",null,null,null,null,null,{"$f":"SUBTOTAL(9,H5)","v":0},null,"Zet je (jeugd)hulp in op school of zet je (jeugd)hulp in in plaats van school?"]
[]
[null,"PGB"]
[null,"Stap 1.\nSelecteer type product","Stap 2.\nProduct","Stap 3.\nNaam aanbieder",null,"Stap 4.\nStart toewijzing","Stap5.\nEinddatum","PGB contractwaarde"]
[]
[]
[]
[null,"Subtotaal PGB",null,null,null,null,null,{"$f":"SUM(H10:H12)","v":0}]
[]
[null,"Jeugdhulp - Overige producten"]
[null,"Jeugdhulp",null,null,"Norm","Aanvraag"]
[null,"Stap 1.\nSelecteer type jeugdhulp","Stap 2.\nKies Product",null,"Bandbreedte gekozen product","Stap 3.\nVolume","Eenheid","Frequentie","Tarief per eenheid","Stap 4.\nStart toewijzing","Stap 5.\nEinde toewijzing","Stap 6.\nAanbieder",null,"Volume * Eenheid","Frequentiefactor","Totaal volume binnen geldigheidstermijn","Totale contractwaarde","Reden inzet schakelteam",null,null,"Als product samenhangt met HLOG","Hulpkolommen",null,"Als HLOG > 3 = schakelteam"]
[{"$f":"IF(OR(C18= \"Z992 - ZZP GGZ verblijfscomponent \", C18= \"Z993 - ZZP VG&LG \",C18= \"Z994 - ZZP ZG verblijfscomponent \"),1,FALSE)","v":false},null,null,null,{"$f":"IF(C18=\"\",\"\",INDEX('Productcodelijst (seg 3)'!$I$3:$I$157,MATCH(C18,'Productcodelijst (seg 3)'!$C$3:$C$121,0)))","v":""},null,{"$f":"IF(C18=\"\",\"\",INDEX('Productcodelijst (seg 3)'!$G$3:$G$131,MATCH(C18,'Productcodelijst (seg 3)'!$C$3:$C$121,0)))","v":""},{"$f":"IF(C18=\"\",\"\",INDEX('Productcodelijst (seg 3)'!$F$3:$F$123,MATCH(C18,'Productcodelijst (seg 3)'!$C$3:$C$121,0)))","v":""},{"$f":"IF(C18=\"\",\"\",INDEX('Productcodelijst (seg 3)'!$H$3:$H$139,MATCH(C18,'Productcodelijst (seg 3)'!$C$3:$C$121,0)))","v":""},null,null,null,null,{"$f":"IF(F18=\"\",\"\",F18*INDEX('Productcodelijst (seg 3)'!$H$3:$H$120,MATCH('Schakeltool HvB 2020'!C18,'Productcodelijst (seg 3)'!$C$3:$C$120,0)))","v":""},{"$f":"(IF(H18=\"\",\"\",\nROUND(IF(K18=\"\",\"\",\n\nIF(H18=\"totaal over periode\",1,\nIF(H18=\"per week\",DATEDIF(J18,K18,\"D\")/7,\nIF(H18=\"per maand\",DATEDIF(J18,K18,\"M\")+1,\nIF(H18=\"per etmaal\",INDEX(P:P,MATCH(1,U:U,0),\n\nIF(H18=\"per dag\",DATEDIF(J18,K18,\"D\")+1,\nIF(H18=\"per dagdeel\",DATEDIF(J18,K18,\"D\")/6,\n)))))))),0)))","v":""},{"$f":"IF(F18=\"\",\"\",IF(O18=\"\",\"\",ROUND(F18*O18,0)))","v":""},{"$f":"IF(C18=\"\",\"\",\nIF(F18=\"\",\"Voer volume in!\",\nIF(J18=\"\",\"Voer start toewijzing in!\",\nIF(K18=\"\",\"Voer einde toewijzing in!\",N18*O18\n))))","v":""},{"$f":"IF(Q18=\"\",\"\",\nIF(Q18=\"Voer start toewijzing in!\",\"\",\nIF(Q18=\"Voer einde toewijzing in!\",\"\",\nIF(Q18=\"Voer volume in!\",\"\",\nIF(Q18>50000,\"Contractwaarde >€50.000,-\",\nIF(VLOOKUP(C18,'Productcodelijst (seg 3)'!$C$3:$J$120,8,0)<F18,\"Afgegeven volume boven norm\",\n\"Toewijzing akkoord\"))))))","v":""},null,null,{"$f":"IF(OR(C18= \"Z911 - Toeslag ZZP MFC \",\nC18= \"Z912 - Toeslag ZZP observatie \",\nC18= \"Z978 - Toeslag ZZP woonzorg GHZ kind \",\nC18= \"Z979 - Toeslag ZZP woonzorg GHZ jeugd \",\nC18=\"Z993 - ZZP VG&LG \",\nC18=\"Z994 - ZZP ZG verblijfscomponent \",\nC18=\"Z996 - ZZP V&V verblijf niet-geïndiceerd \",\nC18= \"Z992 - ZZP GGZ verblijfscomponent \"),1,FALSE)","v":false},{"$f":"IF(OR(C18= \"Z513 - ZZP 1LVG incl. BH incl. DB \",\nC18= \"Z523 - ZZP 2LVG incl. BH incl. DB \",\nC18= \"Z533 - ZZP 3LVG incl. BH incl. DB \",\nC18= \"Z543 - ZZP 4 LVG incl. BH incl. DB \",\nC18= \"Z553 - ZZP 5LVG incl. BH incl. DB \"),1,FALSE)","v":false},{"$f":"IF(AND(V18=1,F18>5),1,FALSE)","v":false},{"$f":"IF(AND(C18=\"HLOG - begeleiding i.v.m. logeren \",F18>3),1,0)","v":0}]
[{"$f":"IF(OR(C19= \"Z992 - ZZP GGZ verblijfscomponent \", C19= \"Z993 - ZZP VG&LG \",C19= \"Z994 - ZZP ZG verblijfscomponent \"),1,FALSE)","v":false},null,null,null,{"$f":"IF(C19=\"\",\"\",INDEX('Productcodelijst (seg 3)'!$I$3:$I$157,MATCH(C19,'Productcodelijst (seg 3)'!$C$3:$C$121,0)))","v":""},null,{"$f":"IF(C19=\"\",\"\",INDEX('Productcodelijst (seg 3)'!$G$3:$G$131,MATCH(C19,'Productcodelijst (seg 3)'!$C$3:$C$121,0)))","v":""},{"$f":"IF(C19=\"\",\"\",INDEX('Productcodelijst (seg 3)'!$F$3:$F$123,MATCH(C19,'Productcodelijst (seg 3)'!$C$3:$C$121,0)))","v":""},{"$f":"IF(C19=\"\",\"\",INDEX('Productcodelijst (seg 3)'!$H$3:$H$139,MATCH(C19,'Productcodelijst (seg 3)'!$C$3:$C$121,0)))","v":""},null,null,null,null,{"$f":"IF(F19=\"\",\"\",F19*INDEX('Productcodelijst (seg 3)'!$H$3:$H$120,MATCH('Schakeltool HvB 2020'!C19,'Productcodelijst (seg 3)'!$C$3:$C$120,0)))","v":""},{"$f":"(IF(H19=\"\",\"\",\nROUND(IF(K19=\"\",\"\",\n\nIF(H19=\"totaal over periode\",1,\nIF(H19=\"per week\",DATEDIF(J19,K19,\"D\")/7,\nIF(H19=\"per maand\",DATEDIF(J19,K19,\"M\")+1,\nIF(H19=\"per etmaal\",INDEX(P:P,MATCH(1,U:U,0),\n\nIF(H19=\"per dag\",DATEDIF(J19,K19,\"D\")+1,\nIF(H19=\"per dagdeel\",DATEDIF(J19,K19,\"D\")/6,\n)))))))),0)))","v":""},{"$f":"IF(F19=\"\",\"\",IF(O19=\"\",\"\",ROUND(F19*O19,0)))","v":""},{"$f":"IF(C19=\"\",\"\",\nIF(F19=\"\",\"Voer volume in!\",\nIF(J19=\"\",\"Voer start toewijzing in!\",\nIF(K19=\"\",\"Voer einde toewijzing in!\",N19*O19\n))))","v":""},{"$f":"IF(Q19=\"\",\"\",\nIF(Q19=\"Voer start toewijzing in!\",\"\",\nIF(Q19=\"Voer einde toewijzing in!\",\"\",\nIF(Q19=\"Voer volume in!\",\"\",\nIF(Q19>50000,\"Contractwaarde >€50.000,-\",\nIF(VLOOKUP(C19,'Productcodelijst (seg 3)'!$C$3:$J$120,8,0)<F19,\"Afgegeven volume boven norm\",\n\"Toewijzing akkoord\"))))))","v":""},null,null,{"$f":"IF(OR(C19= \"Z911 - Toeslag ZZP MFC \",\nC19= \"Z912 - Toeslag ZZP observatie \",\nC19= \"Z978 - Toeslag ZZP woonzorg GHZ kind \",\nC19= \"Z979 - Toeslag ZZP woonzorg GHZ jeugd \",\nC19=\"Z993 - ZZP VG&LG \",\nC19=\"Z994 - ZZP ZG verblijfscomponent \",\nC19=\"Z996 - ZZP V&V verblijf niet-geïndiceerd \",\nC19= \"Z992 - ZZP GGZ verblijfscomponent \"),1,FALSE)","v":false},{"$f":"IF(OR(C19= \"Z513 - ZZP 1LVG incl. BH incl. DB \",\nC19= \"Z523 - ZZP 2LVG incl. BH incl. DB \",\nC19=\"Z993 - ZZP VG&LG \",\nC19= \"Z533 - ZZP 3LVG incl. BH incl. DB \",\nC19= \"Z543 - ZZP 4 LVG incl. BH incl. DB \",\nC19= \"Z553 - ZZP 5LVG incl. BH incl. DB \"),1,FALSE)","v":false},{"$f":"IF(AND(V19=1,F19>5),1,FALSE)","v":false},{"$f":"IF(AND(C19=\"HLOG - begeleiding i.v.m. logeren \",F19>3),1,0)","v":0}]
[false,null,null,null,{"$f":"IF(C20=\"\",\"\",INDEX('Productcodelijst (seg 3)'!$I$3:$I$157,MATCH(C20,'Productcodelijst (seg 3)'!$C$3:$C$121,0)))","v":""},null,{"$f":"IF(C20=\"\",\"\",INDEX('Productcodelijst (seg 3)'!$G$3:$G$131,MATCH(C20,'Productcodelijst (seg 3)'!$C$3:$C$121,0)))","v":""},{"$f":"IF(C20=\"\",\"\",INDEX('Productcodelijst (seg 3)'!$F$3:$F$123,MATCH(C20,'Productcodelijst (seg 3)'!$C$3:$C$121,0)))","v":""},{"$f":"IF(C20=\"\",\"\",INDEX('Productcodelijst (seg 3)'!$H$3:$H$139,MATCH(C20,'Productcodelijst (seg 3)'!$C$3:$C$121,0)))","v":""},null,null,null,null,{"$f":"IF(F20=\"\",\"\",F20*INDEX('Productcodelijst (seg 3)'!$H$3:$H$120,MATCH('Schakeltool HvB 2020'!C20,'Productcodelijst (seg 3)'!$C$3:$C$120,0)))","v":""},"","","",{"$f":"IF(Q20=\"\",\"\",\nIF(Q20=\"Voer start toewijzing in!\",\"\",\nIF(Q20=\"Voer einde toewijzing in!\",\"\",\nIF(Q20=\"Voer volume in!\",\"\",\nIF(Q20>50000,\"Contractwaarde >€50.000,-\",\nIF(VLOOKUP(C20,'Productcodelijst (seg 3)'!$C$3:$J$120,8,0)<F20,\"Afgegeven volume boven norm\",\n\"Toewijzing akkoord\"))))))","v":""},null,null,false,false,false,0]
[false,null,null,null,{"$f":"IF(C21=\"\",\"\",INDEX('Productcodelijst (seg 3)'!$I$3:$I$157,MATCH(C21,'Productcodelijst (seg 3)'!$C$3:$C$121,0)))","v":""},null,{"$f":"IF(C21=\"\",\"\",INDEX('Productcodelijst (seg 3)'!$G$3:$G$131,MATCH(C21,'Productcodelijst (seg 3)'!$C$3:$C$121,0)))","v":""},{"$f":"IF(C21=\"\",\"\",INDEX('Productcodelijst (seg 3)'!$F$3:$F$123,MATCH(C21,'Productcodelijst (seg 3)'!$C$3:$C$121,0)))","v":""},{"$f":"IF(C21=\"\",\"\",INDEX('Productcodelijst (seg 3)'!$H$3:$H$139,MATCH(C21,'Productcodelijst (seg 3)'!$C$3:$C$121,0)))","v":""},null,null,null,null,{"$f":"IF(F21=\"\",\"\",F21*INDEX('Productcodelijst (seg 3)'!$H$3:$H$120,MATCH('Schakeltool HvB 2020'!C21,'Productcodelijst (seg 3)'!$C$3:$C$120,0)))","v":""},"","","",{"$f":"IF(Q21=\"\",\"\",\nIF(Q21=\"Voer start toewijzing in!\",\"\",\nIF(Q21=\"Voer einde toewijzing in!\",\"\",\nIF(Q21=\"Voer volume in!\",\"\",\nIF(Q21>50000,\"Contractwaarde >€50.000,-\",\nIF(VLOOKUP(C21,'Productcodelijst (seg 3)'!$C$3:$J$120,8,0)<F21,\"Afgegeven volume boven norm\",\n\"Toewijzing akkoord\"))))))","v":""},null,null,false,false,false,0]
[false,null,null,null,{"$f":"IF(C22=\"\",\"\",INDEX('Productcodelijst (seg 3)'!$I$3:$I$157,MATCH(C22,'Productcodelijst (seg 3)'!$C$3:$C$121,0)))","v":""},null,{"$f":"IF(C22=\"\",\"\",INDEX('Productcodelijst (seg 3)'!$G$3:$G$131,MATCH(C22,'Productcodelijst (seg 3)'!$C$3:$C$121,0)))","v":""},{"$f":"IF(C22=\"\",\"\",INDEX('Productcodelijst (seg 3)'!$F$3:$F$123,MATCH(C22,'Productcodelijst (seg 3)'!$C$3:$C$121,0)))","v":""},{"$f":"IF(C22=\"\",\"\",INDEX('Productcodelijst (seg 3)'!$H$3:$H$139,MATCH(C22,'Productcodelijst (seg 3)'!$C$3:$C$121,0)))","v":""},null,null,null,null,{"$f":"IF(F22=\"\",\"\",F22*INDEX('Productcodelijst (seg 3)'!$H$3:$H$120,MATCH('Schakeltool HvB 2020'!C22,'Productcodelijst (seg 3)'!$C$3:$C$120,0)))","v":""},"","","",{"$f":"IF(Q22=\"\",\"\",\nIF(Q22=\"Voer start toewijzing in!\",\"\",\nIF(Q22=\"Voer einde toewijzing in!\",\"\",\nIF(Q22=\"Voer volume in!\",\"\",\nIF(Q22>50000,\"Contractwaarde >€50.000,-\",\nIF(VLOOKUP(C22,'Productcodelijst (seg 3)'!$C$3:$J$120,8,0)<F22,\"Afgegeven volume boven norm\",\n\"Toewijzing akkoord\"))))))","v":""},null,null,false,false,false,0]
[false,null,null,null,{"$f":"IF(C23=\"\",\"\",INDEX('Productcodelijst (seg 3)'!$I$3:$I$157,MATCH(C23,'Productcodelijst (seg 3)'!$C$3:$C$121,0)))","v":""},null,{"$f":"IF(C23=\"\",\"\",INDEX('Productcodelijst (seg 3)'!$G$3:$G$131,MATCH(C23,'Productcodelijst (seg 3)'!$C$3:$C$121,0)))","v":""},{"$f":"IF(C23=\"\",\"\",INDEX('Productcodelijst (seg 3)'!$F$3:$F$123,MATCH(C23,'Productcodelijst (seg 3)'!$C$3:$C$121,0)))","v":""},{"$f":"IF(C23=\"\",\"\",INDEX('Productcodelijst (seg 3)'!$H$3:$H$139,MATCH(C23,'Productcodelijst (seg 3)'!$C$3:$C$121,0)))","v":""},null,null,null,null,{"$f":"IF(F23=\"\",\"\",F23*INDEX('Productcodelijst (seg 3)'!$H$3:$H$120,MATCH('Schakeltool HvB 2020'!C23,'Productcodelijst (seg 3)'!$C$3:$C$120,0)))","v":""},"","",{"$f":"IF(C23=\"\",\"\",\nIF(F23=\"\",\"Voer volume in!\",\nIF(J23=\"\",\"Voer start toewijzing in!\",\nIF(K23=\"\",\"Voer einde toewijzing in!\",N23*O23\n))))","v":""},{"$f":"IF(Q23=\"\",\"\",\nIF(Q23=\"Voer start toewijzing in!\",\"\",\nIF(Q23=\"Voer einde toewijzing in!\",\"\",\nIF(Q23=\"Voer volume in!\",\"\",\nIF(Q23>50000,\"Contractwaarde >€50.000,-\",\nIF(VLOOKUP(C23,'Productcodelijst (seg 3)'!$C$3:$J$120,8,0)<F23,\"Afgegeven volume boven norm\",\n\"Toewijzing akkoord\"))))))","v":""},null,null,false,false,false,0]
[false,null,null,null,{"$f":"IF(C24=\"\",\"\",INDEX('Productcodelijst (seg 3)'!$I$3:$I$157,MATCH(C24,'Productcodelijst (seg 3)'!$C$3:$C$121,0)))","v":""},null,{"$f":"IF(C24=\"\",\"\",INDEX('Productcodelijst (seg 3)'!$G$3:$G$131,MATCH(C24,'Productcodelijst (seg 3)'!$C$3:$C$121,0)))","v":""},{"$f":"IF(C24=\"\",\"\",INDEX('Productcodelijst (seg 3)'!$F$3:$F$123,MATCH(C24,'Productcodelijst (seg 3)'!$C$3:$C$121,0)))","v":""},{"$f":"IF(C24=\"\",\"\",INDEX('Productcodelijst (seg 3)'!$H$3:$H$139,MATCH(C24,'Productcodelijst (seg 3)'!$C$3:$C$121,0)))","v":""},null,null,null,null,{"$f":"IF(F24=\"\",\"\",F24*INDEX('Productcodelijst (seg 3)'!$H$3:$H$120,MATCH('Schakeltool HvB 2020'!C24,'Productcodelijst (seg 3)'!$C$3:$C$120,0)))","v":""},"","",{"$f":"IF(C24=\"\",\"\",\nIF(F24=\"\",\"Voer volume in!\",\nIF(J24=\"\",\"Voer start toewijzing in!\",\nIF(K24=\"\",\"Voer einde toewijzing in!\",N24*O24\n))))","v":""},{"$f":"IF(Q24=\"\",\"\",\nIF(Q24=\"Voer start toewijzing in!\",\"\",\nIF(Q24=\"Voer einde toewijzing in!\",\"\",\nIF(Q24=\"Voer volume in!\",\"\",\nIF(Q24>50000,\"Contractwaarde >€50.000,-\",\nIF(VLOOKUP(C24,'Productcodelijst (seg 3)'!$C$3:$J$120,8,0)<F24,\"Afgegeven volume boven norm\",\n\"Toewijzing akkoord\"))))))","v":""},null,null,false,false,false,0]
[null,"Subtotaal contractwaarden overige producten",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,$Q$18:$Q$24)","v":0},null,null,null,false,false,false,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(C:C, \"Z993 - ZZP VG&LG \")","v":0}]
[null,null,null,null,null,null,null,null,null,"Totale aanvraag",null,null,null,null,null,null,{"$f":"IF($M$4=\"\",\"Vul controle vraag in\",\n\nIF($C$5=\"intensiteit D\",\"Verstuur naar Schakelteam, zij maken met jou een afspraak om de casus te bespreken\",\nIF($C$5=\"intensiteit E\",\"Verstuur naar Schakelteam, zij maken met jou een afspraak om de casus te bespreken\",\nIF($C$5=\"intensiteit F\",\"Verstuur naar Schakelteam, zij maken met jou een afspraak om de casus te bespreken\",\nIF($C$5=\"intensiteit G\",\"Verstuur naar Schakelteam, zij maken met jou een afspraak om de casus te bespreken\",\nIF($M$6=\"Ja\",\"Verstuur naar Schakelteam, zij maken met jou een afspraak om de casus te bespreken\",\n\nIF(AND($C$5=\"intensiteit A\",DATEDIF($E$5,$F$5,\"D\")<60,DATEDIF($E$5,$F$5,\"D\")>=1),\"Verstuur naar Schakelteam, zij maken met jou een afspraak om de casus te bespreken\",\nIF(AND($C$5=\"intensiteit B\",DATEDIF($E$5,$F$5,\"D\")<120,DATEDIF($E$5,$F$5,\"D\")>=1),\"Verstuur naar Schakelteam, zij maken met jou een afspraak om de casus te bespreken\",\nIF(AND($C$5=\"intensiteit C\",DATEDIF($E$5,$F$5,\"D\")<180,DATEDIF($E$5,$F$5,\"D\")>=1),\"Verstuur naar Schakelteam, zij maken met jou een afspraak om de casus te bespreken\",\nIF(AND($C$5=\"intensiteit D\",DATEDIF($E$5,$F$5,\"D\")<300,DATEDIF($E$5,$F$5,\"D\")>=1),\"Verstuur naar Schakelteam, zij maken met jou een afspraak om de casus te bespreken\",\n\nIF(AND($H$6=\"\",$R$25=\"\",$H$13>49999),\"Toewijzingen zijn akkoord\",\n\n\nIF(AND($H$6>0,COUNTIF(B18:B24,\"verblijf GGZ\")>0,COUNTIF(F18:F24,\">\"&1)),\"Verstuur naar Schakelteam, zij maken met jou een afspraak om de casus te bespreken\",\nIF(AND($H$6>0,COUNTIF(B18:B24,\"verblijf (JOH)\")>0,COUNTIF(F18:F24,\">\"&1)),\"Verstuur naar Schakelteam, zij maken met jou een afspraak om de casus te bespreken\",\nIF(AND($H$6>0,COUNTIF(B18:B24,\"Verblijf (LVB)\")>0,COUNTIF(F18:F24,\">\"&1)),\"Verstuur naar Schakelteam, zij maken met jou een afspraak om de casus te bespreken\",\nIF(AND($H$6>0,COUNTIF(B18:B24,\"Pleegzorg\")>0,COUNTIF(F18:F24,\">\"&1)),\"Verstuur naar Schakelteam, zij maken met jou een afspraak om de casus te bespreken\",\n\nIF(COUNTIF(W18:W25,\">\"&0),\"Verstuur naar Schakelteam, zij maken met jou een afspraak om de casus te bespreken\",\n\nIF(COUNTIF(X18:X25,\">\"&0),\"Verstuur naar Schakelteam, zij maken met jou een afspraak om de casus te bespreken\",\n\n\nIF(AND(COUNTIF($R$18:$R$24,\"Afgegeven volume boven norm\")<1,$M$30<50000,\nCOUNTIF($M$4,\"Ja\")<1),\n\n\n\n\"Toewijzingen zijn akkoord\",\"Verstuur naar Schakelteam, zij maken met jou een afspraak om de casus te bespreken\"))))))))))))))))))","v":"Vul controle vraag in"}]
[null,null,null,null,null,null,null,null,null,"Subtotaal PGB & overige producten",null,null,{"$f":"SUM(Q25+H13)","v":0}]
[null,null,null,null,null,null,null,null,null,"Subtotaal arrangement",null,null,{"$f":"H6","v":0}]
[null,null,null,null,null,null,null,null,null,"Totaal",null,null,{"$f":"SUM(M28:M29)","v":0}]

{"sheet":"Productcodelijst (seg 3)","index":1,"n_rows":101,"n_cols":25,"rows_kept":101,"cut":false,"hidden":true,"merged":[[72,1,92,1],[93,1,99,1],[2,0,56,0],[8,1,11,1],[12,1,13,1],[2,1,7,1],[48,1,54,1],[55,1,56,1],[38,1,47,1],[15,1,37,1],[57,1,70,1]]}
[null,null,"Productcodelijst segment 3"]
["Zorgvorm","Type Jeugdzorg","Omschrijving prestatie","Omschrijving prestatie","Prestatie code","Frequentie","Eenheid","Tarief 2020","Bandbreedte","Controle indicator","Opmerking"]
[null,"Jeugd ziekenhuis ADHD +","Gedragsproblemen/licht ambulant/kindergeneeskunde overige pediatrie (ADHD+)",null,6025,"totaal over periode","stuks",290.78858700000001,"n.v.t.","n.v.t."]
[null,null,"Gedragsproblemen/ ambulant middel-dag/kindergeneeskunde overige pediatrie (ADHD+)",null,6008,"totaal over periode","stuks",798.04,"n.v.t.","n.v.t."]
[null,null,"Diagnosen psychisch/gedrag overig/licht ambulant/kindergeneeskunde psychosociaal",null,6013,"totaal over periode","stuks",342.45520199999999,"n.v.t.","n.v.t."]
[null,null,"Diagnosen psychisch/gedrag overig/ poli>6-dag>1/ kindergeneeskunde psychosociaal",null,6004,"totaal over periode","stuks",1444.1257620000001,"n.v.t.","n.v.t."]
[null,null,"Diagnosen psychisch/gedrag overig/ ambulant middel-dag=1/met activiteiten psychosociaal specifiek/kindergeneeskunde",null,6029,"totaal over periode","stuks",1124.5360049999999,"n.v.t.","n.v.t."]
[null,null,"Diagnosen psychisch/gedrag overig/ ambulant middel-dag=1/zonder activiteiten psychosociaal specifiek/kindergeneeskunde",null,6030,"totaal over periode","stuks",802.31388300000003,"n.v.t.","n.v.t."]
[null,"Omschrijving prestatie - Dyslexie","Diagnostiek -  volledig traject",null,"0D001 ","totaal over periode","stuks",970.64072099999998,"n.v.t.","n.v.t.",null,null,null,"Jeugd ziekenhuis ADHD +","Dyslexie","Pleegzorg","Dagbehandeling Dagcentrum Vroegtijdige interventie JLVG","Verblijf (LVB)","Verblijf GGZ","Verblijf (JOH)","Vervoer","Beschermd wonen","Crisis","Medicatiecontrole","Frequenties (gevoelig voor hoofdletters en spaties!)"]
[null,null,"Diagnostiek - tarief per uur  ","*dit geldt als traject voortijdig wordt beindigd. Declaratie uren kan uiteraard maximaal tarief volledig traject bedragen.","0D002","per week","uur",92.906999999999996,"n.v.t.","n.v.t.",null,null,null,"Gedragsproblemen/licht ambulant/kindergeneeskunde overige pediatrie (ADHD+)","Diagnostiek -  volledig traject","24-uurs pleegzorg","Dagbehandeling Dagcentrum Vroegtijdige interventieJLVG","Z414 - ZZP 1VG excl. DB ","Deelprestatie verblijf A (Lichte verzorgingsgraad)- Regulier incl. NHC Regulier ","Behandelgroep kamer training ","Lopend vervoer ","Begeleid Zelfstandig Wonen ","Crisisinterventie ambulant ","Medicatiecontrole","per week"]
[null,null,"Behandeling dyslexie (max) 48 sessies ",null,"0D003 ","totaal over periode","stuks",92.906999999999996,"n.v.t.","n.v.t.",null,null,null,"Gedragsproblemen/ ambulant middel-dag/kindergeneeskunde overige pediatrie (ADHD+)","Diagnostiek - tarief per uur  ","Deeltijd pleegzorg",null,"Z415 - ZZP 1VG incl. DB ","Deelprestatie verblijf B (Beperkte verzorgingsgraad)- Regulier incl. NHC Regulier ","Behandelgroep gezinshuis ","Rolstoel / individueel vervoer ","Begeleid Zelfstandig Wonen + Dagbesteding Intensiteit 1 ","Crisisinterventie ambulant crisisdienst ",null,"totaal over periode"]
[null,null,"Behandeling dyslexie (verlenging max) 12 sessies ",null,"0D004","totaal over periode","stuks",92.906999999999996,"n.v.t.","n.v.t.",null,null,null,"Diagnosen psychisch/gedrag overig/licht ambulant/kindergeneeskunde psychosociaal","Behandeling dyslexie (max) 48 sessies ",null,null,"Z424 - ZZP 2VG excl. DB ","Deelprestatie verblijf C (Matige verzorgingsgraad)- Regulier incl. NHC Regulier ","Behandelgroep fasehuis ",null,"Begeleid Zelfstandig Wonen + Dagbesteding Intensiteit 2 ","Crisispleegzorg deeltijd ",null,"per maand"]
[null,"Omschrijving prestatie - Pleegzorg","24-uurs pleegzorg",null,"43A24","per week","dag",43.304985000000002,"n.v.t.","n.v.t.",null,null,null,"Diagnosen psychisch/gedrag overig/ poli>6-dag>1/ kindergeneeskunde psychosociaal","Behandeling dyslexie (verlenging max) 12 sessies ",null,null,"Z425 - ZZP 2VG incl. DB ","Deelprestatie verblijf D (Gemiddelde verzorgingsgraad)- Regulier incl. NHC Regulier ","Behandelgroep ",null,"Ondersteunend Wonen 1 ","Crisispleegzorg voltijd ",null,"per etmaal"]
[null,null,"Deeltijd pleegzorg",null,"43A23","per week","dag",43.304985000000002,"n.v.t.","n.v.t.",null,null,null,"Diagnosen psychisch/gedrag overig/ ambulant middel-dag=1/met activiteiten psychosociaal specifiek/kindergeneeskunde",null,null,null,"Z430 - ZZP 3VG excl. BH excl. DB ","Deelprestatie verblijf E (Intensieve verzorgingsgraad)- Regulier incl. NHC Regulier ","Behandelgroep zwaar ",null,"Ondersteunend Wonen 1 + Dagbesteding Intensiteit 1 ","Crisisinterventie Verblijf ",null,"per dag"]
[null,"Dagbehandeling Dagcentrum Vroegtijdige interventie JLVG","Dagbehandeling Dagcentrum Vroegtijdige interventieJLVG",null,"OD891","per week","dagdeel",213.149304,"n.v.t.","n.v.t.",null,null,null,"Diagnosen psychisch/gedrag overig/ ambulant middel-dag=1/zonder activiteiten psychosociaal specifiek/kindergeneeskunde",null,null,null,"Z431 - ZZP 3VG excl. BH incl. DB ","Deelprestatie verblijf F (Extra intensieve verzorgingsgraad)- Regulier incl. NHC Regulier ","Behandelgroep tienermoeder en kind(eren) (integrale prijs) ",null,"Ondersteunend Wonen 1 + Dagbesteding Intensiteit 2 ","Crisisinterventie verblijf F ",null,"per dagdeel"]
[null,"Omschrijving prestatie - Verblijf (LVB)","Z414 - ZZP 1VG excl. DB ",null,"44A35 ","per week","dag ",89.417826000000005,"n.v.t.","n.v.t.",null,null,null,null,null,null,null,"Z432 - ZZP 3VG incl. BH ecl. DB ","Deelprestatie verblijf G (Zeer intensieve verzorgingsgraad)- Regulier incl. NHC Regulier ","Verblijf 24-uur observatie traject opvoedingsperspectief moeder en kinder(en) (integrale prijs) ",null,"Ondersteunend Wonen 1 + Huisvesting ","Crisisinterventie behandeling bij verblijf "]
[null,null,"Z415 - ZZP 1VG incl. DB ",null,"44A38 ","per week","dag ",131.215653,"n.v.t.","n.v.t.",null,null,null,null,null,null,null,"Z433 - ZZP 3VG incl. BG incl. DB ","Opslag component NHC PMU t.o.v. NHC regulier (geldend t/m deelprest. G) ",null,null,"Ondersteunend Wonen 1 + Verpleging en Verzorging "]
[null,null,"Z424 - ZZP 2VG excl. DB ",null,"44A36 ","per week","dag ",105.800427,"n.v.t.","n.v.t.",null,null,null,null,null,null,null,"Z513 - ZZP 1LVG incl. BH incl. DB ","Opslag component NHC beveiligingsniveau 2 t.o.v. NHC regulier (geldend t/m deelprest. G) ",null,null,"Ondersteunend Wonen 1 + Dagbesteding Intensiteit 1 + Huisvesting "]
[null,null,"Z425 - ZZP 2VG incl. DB ",null,"44A39 ","per week","dag ",147.608577,"n.v.t.","n.v.t.",null,null,null,null,null,null,null,"Z523 - ZZP 2LVG incl. BH incl. DB ","Opslag component NHC beveiligingsniveau 3 t.o.v. NHC regulier ",null,null,"Ondersteunend Wonen 1 + Dagbesteding Intensiteit 2 + Huisvesting "]
[null,null,"Z430 - ZZP 3VG excl. BH excl. DB ",null,"44A37 ","per week","dag ",119.664216,"n.v.t.","n.v.t.",null,null,null,null,null,null,null,"Z533 - ZZP 3LVG incl. BH incl. DB ",null,null,null,"Ondersteunend Wonen 1 + Dagbesteding Intensiteit 1 + Verpleging en verzorging "]
[null,null,"Z431 - ZZP 3VG excl. BH incl. DB ",null,"44A40 ","per week","dag ",161.48268899999999,"n.v.t.","n.v.t.",null,null,null,null,null,null,null,"Z543 - ZZP 4 LVG incl. BH incl. DB ",null,null,null,"Ondersteunend Wonen 1 + Dagbesteding Intensiteit 2 + Verpleging en verzorging "]
[null,null,"Z432 - ZZP 3VG incl. BH ecl. DB ",null,"43A51 ","per week","dag ",134.86999500000002,"n.v.t.","n.v.t.",null,null,null,null,null,null,null,"Z553 - ZZP 5LVG incl. BH incl. DB ",null,null,null,"Ondersteunend Wonen 1 + Dagbesteding Intensiteit 1 + Huisvesting + Verpleging en verzorging "]
[null,null,"Z433 - ZZP 3VG incl. BG incl. DB ",null,"43A52 ","per week","dag ",176.688468,"n.v.t.","n.v.t.",null,null,null,null,null,null,null,"Z911 - Toeslag ZZP MFC ",null,null,null,"Ondersteunend Wonen 1 + Dagbesteding Intensiteit 2 + Huisvesting + Verpleging en verzorging "]
[null,null,"Z513 - ZZP 1LVG incl. BH incl. DB ",null,"43A53 ","per week","dag ",168.29586900000001,"n.v.t.","n.v.t.",null,null,null,null,null,null,null,"Z912 - Toeslag ZZP observatie ",null,null,null,"Ondersteunend Wonen 2"]
[null,null,"Z523 - ZZP 2LVG incl. BH incl. DB ",null,"43A54 ","per week","dag ",207.12067199999998,"n.v.t.","n.v.t.",null,null,null,null,null,null,null,"Z978 - Toeslag ZZP woonzorg GHZ kind ",null,null,null,"Ondersteunend Wonen 2 + Dagbesteding Intensiteit 1 "]
[null,null,"Z533 - ZZP 3LVG incl. BH incl. DB ",null,"43A55 ","per week","dag ",257.81692500000003,"n.v.t.","n.v.t.",null,null,null,null,null,null,null,"Z979 - Toeslag ZZP woonzorg GHZ jeugd ",null,null,null,"Ondersteunend Wonen 2 + Dagbesteding Intensiteit 2 "]
[null,null,"Z543 - ZZP 4 LVG incl. BH incl. DB ",null,"43A56 ","per week","dag ",295.51652099999995,"n.v.t.","n.v.t.",null,null,null,null,null,null,null,"Z992 - ZZP GGZ verblijfscomponent ",null,null,null,"Ondersteunend Wonen 2 + Huisvesting "]
[null,null,"Z553 - ZZP 5LVG incl. BH incl. DB ",null,"43A57 ","per week","dag ",294.360345,"n.v.t.","n.v.t.",null,null,null,null,null,null,null,"Z993 - ZZP VG&LG ",null,null,null,"Ondersteunend Wonen 2 + Verpleging en Verzorging "]
[null,null,"Z911 - Toeslag ZZP MFC ",null,"45A58 ","per week","dag ",31.763870999999998,"n.v.t.","n.v.t.",null,null,null,null,null,null,null,"Z994 - ZZP ZG verblijfscomponent ",null,null,null,"Ondersteunend Wonen 2 + Dagbesteding Intensiteit 1 + Huisvesting "]
[null,null,"Z912 - Toeslag ZZP observatie ",null,"45A59 ","per week","dag ",81.603314999999995,"n.v.t.","n.v.t.",null,null,null,null,null,null,null,"Z996 - ZZP V&V verblijf niet-geïndiceerd ",null,null,null,"Ondersteunend Wonen 2 + Dagbesteding Intensiteit 2 + Huisvesting "]
[null,null,"Z978 - Toeslag ZZP woonzorg GHZ kind ",null,"45A60 ","per week","dag ",31.990976999999997,"n.v.t.","n.v.t.",null,null,null,null,null,null,null,"HLOG - begeleiding i.v.m. logeren ",null,null,null,"Ondersteunend Wonen 2 + Dagbesteding Intensiteit 1 + Verpleging en verzorging "]
[null,null,"Z979 - Toeslag ZZP woonzorg GHZ jeugd ",null,"45A61 ","per week","dag ",19.489823999999999,"n.v.t.","n.v.t.",null,null,null,null,null,null,null,"Verblijf ZGVIS excl. BH excl. DB ",null,null,null,"Ondersteunend Wonen 2 + Dagbesteding Intensiteit 2 + Verpleging en verzorging "]
[null,null,"Z992 - ZZP GGZ verblijfscomponent ",null,"44A42 ","per maand","etmaal",23.009967,"n.v.t.","n.v.t.",null,null,null,null,null,null,null,null,null,null,null,"Ondersteunend Wonen 2 + Dagbesteding Intensiteit 1 + Huisvesting + Verpleging en verzorging "]
[null,null,"Z993 - ZZP VG&LG ",null,"44A43 ","per maand","etmaal",27.118521000000001,"n.v.t.","n.v.t.",null,null,null,null,null,null,null,null,null,null,null,"Ondersteunend Wonen 2 + Dagbesteding Intensiteit 2 + Huisvesting + Verpleging en verzorging "]
[null,null,"Z994 - ZZP ZG verblijfscomponent ",null,"44A44 ","per week","dag ",27.675962999999999,"n.v.t.","n.v.t.",null,null,null,null,null,null,null,null,null,null,null,"Beschermd Wonen "]
[null,null,"Z996 - ZZP V&V verblijf niet-geïndiceerd ",null,"44A41 ","per week","dag ",35.789841000000003,"n.v.t.","n.v.t.",null,null,null,null,null,null,null,null,null,null,null,"Beschermd Wonen + Dagbesteding Intensiteit 1 "]
[null,null,"HLOG - begeleiding i.v.m. logeren ",null,"0HLOG ","per etmaal","uur",54.742868999999999,"n.v.t.","n.v.t.",null,null,null,null,null,null,null,null,null,null,null,"Beschermd Wonen + Dagbesteding Intensiteit 2 "]
[null,null,"Verblijf ZGVIS excl. BH excl. DB ",null,44840,"per week","dag",207.12067199999998,"n.v.t.","n.v.t.",null,null,null,null,null,null,null,null,null,null,null,"Beschermd Wonen + Huisvesting "]
[null,"Verblijf GGZ","Deelprestatie verblijf A (Lichte verzorgingsgraad)- Regulier incl. NHC Regulier ",null,54009,"per week","dag ",144.66652199999999,"n.v.t.","n.v.t.",null,null,null,null,null,null,null,null,null,null,null,"Beschermd Wonen + Verpleging en Verzorging "]
[null,null,"Deelprestatie verblijf B (Beperkte verzorgingsgraad)- Regulier incl. NHC Regulier ",null,54010,"per week","dag ",189.716094,"n.v.t.","n.v.t.",null,null,null,null,null,null,null,null,null,null,null,"Beschermd Wonen + Dagbesteding Intensiteit 1 + Huisvesting "]
[null,null,"Deelprestatie verblijf C (Matige verzorgingsgraad)- Regulier incl. NHC Regulier ",null,54011,"per week","dag ",262.80293399999999,"n.v.t.","n.v.t.",null,null,null,null,null,null,null,null,null,null,null,"Beschermd Wonen + Dagbesteding Intensiteit 2 + Huisvesting "]
[null,null,"Deelprestatie verblijf D (Gemiddelde verzorgingsgraad)- Regulier incl. NHC Regulier ",null,54012,"per week","dag ",276.11960400000004,"n.v.t.","n.v.t.",null,null,null,null,null,null,null,null,null,null,null,"Beschermd Wonen + Dagbesteding Intensiteit 1 + Verpleging en verzorging "]
[null,null,"Deelprestatie verblijf E (Intensieve verzorgingsgraad)- Regulier incl. NHC Regulier ",null,54013,"per week","dag ",354.32665200000002,"n.v.t.","n.v.t.",null,null,null,null,null,null,null,null,null,null,null,"Beschermd Wonen + Dagbesteding Intensiteit 2 + Verpleging en verzorging "]
[null,null,"Deelprestatie verblijf F (Extra intensieve verzorgingsgraad)- Regulier incl. NHC Regulier ",null,54014,"per week","dag ",396.85741200000001,"n.v.t.","n.v.t.",null,null,null,null,null,null,null,null,null,null,null,"Beschermd Wonen + Dagbesteding Intensiteit 1 + Huisvesting + Verpleging en verzorging "]
[null,null,"Deelprestatie verblijf G (Zeer intensieve verzorgingsgraad)- Regulier incl. NHC Regulier ",null,54015,"per week","dag ",536.24888099999998,"n.v.t.","n.v.t.",null,null,null,null,null,null,null,null,null,null,null,"Beschermd Wonen + Dagbesteding Intensiteit 2 + Huisvesting + Verpleging en verzorging "]
[null,null,"Opslag component NHC PMU t.o.v. NHC regulier (geldend t/m deelprest. G) ",null,52322,"per week","dag ",6.6067200000000001,"n.v.t.","n.v.t."]
[null,null,"Opslag component NHC beveiligingsniveau 2 t.o.v. NHC regulier (geldend t/m deelprest. G) ",null,52323,"per week","dag ",7.6596659999999996,"n.v.t.","n.v.t."]
[null,null,"Opslag component NHC beveiligingsniveau 3 t.o.v. NHC regulier ",null,52324,"per week","dag ",22.390587,"n.v.t.","n.v.t."]
[null,"Omschrijving prestatie - verblijf (JOH)","Behandelgroep kamer training ",null,1701,"per week","dag ",92.783124000000001,"1-7 dagen per week",7]
[null,null,"Behandelgroep gezinshuis ",null,"43A10 ","per week","dag ",158.36514299999999,"1-7 dagen per week",7]
[null,null,"Behandelgroep fasehuis ",null,1704,"per week","dag ",158.36514299999999,"1-7 dagen per week",7]
[null,null,"Behandelgroep ",null,1705,"per week","dag ",205.43802299999999,"1-7 dagen per week",7]
[null,null,"Behandelgroep zwaar ",null,1707,"per week","dag ",222.08902199999997,"1-7 dagen per week",7]
[null,null,"Behandelgroep tienermoeder en kind(eren) (integrale prijs) ",null,1706,"per week","dag ",322.44922800000001,"n.v.t.","n.v.t."]
[null,null,"Verblijf 24-uur observatie traject opvoedingsperspectief moeder en kinder(en) (integrale prijs) ",null,43905,"per week","dag ",347.90574599999997,"n.v.t.","n.v.t."]
[null,"Vervoer","Lopend vervoer ",null,42900,"per week","per etmaal",15.278040000000001,"n.v.t.","n.v.t."]
[null,null,"Rolstoel / individueel vervoer ",null,42901,"per week","per etmaal",19.500147000000002,"n.v.t.","n.v.t."]
[null,"Beschermd wonen ","Begeleid Zelfstandig Wonen ",null,"44Z01 ","per week","per etmaal",76.069999999999993,"n.v.t.","n.v.t."]
[null,null,"Begeleid Zelfstandig Wonen + Dagbesteding Intensiteit 1 ",null,"44Z02 ","per week","per etmaal",96.75,"n.v.t.","n.v.t."]
[null,null,"Begeleid Zelfstandig Wonen + Dagbesteding Intensiteit 2 ",null,"44Z03 ","per week","per etmaal",120.37,"n.v.t.","n.v.t."]
[null,null,"Ondersteunend Wonen 1 ",null,"44Z04 ","per week","per etmaal",109.02,"n.v.t.","n.v.t."]
[null,null,"Ondersteunend Wonen 1 + Dagbesteding Intensiteit 1 ",null,"44Z05 ","per week","per etmaal",129.69999999999999,"n.v.t.","n.v.t."]
[null,null,"Ondersteunend Wonen 1 + Dagbesteding Intensiteit 2 ",null,"44Z06 ","per week","per etmaal",153.32,"n.v.t.","n.v.t."]
[null,null,"Ondersteunend Wonen 1 + Huisvesting ",null,"44Z07 ","per week","per etmaal",140.09,"n.v.t.","n.v.t."]
[null,null,"Ondersteunend Wonen 1 + Verpleging en Verzorging ",null,"44Z08 ","per week","per etmaal",176.27,"n.v.t.","n.v.t."]
[null,null,"Ondersteunend Wonen 1 + Dagbesteding Intensiteit 1 + Huisvesting ",null,"44Z09 ","per week","per etmaal",160.77000000000001,"n.v.t.","n.v.t."]
[null,null,"Ondersteunend Wonen 1 + Dagbesteding Intensiteit 2 + Huisvesting ",null,"44Z10 ","per week","per etmaal",184.39,"n.v.t.","n.v.t."]
[null,null,"Ondersteunend Wonen 1 + Dagbesteding Intensiteit 1 + Verpleging en verzorging ",null,"44Z11 ","per week","per etmaal",196.95,"n.v.t.","n.v.t."]
[null,null,"Ondersteunend Wonen 1 + Dagbesteding Intensiteit 2 + Verpleging en verzorging ",null,"44Z12 ","per week","per etmaal",220.57,"n.v.t.","n.v.t."]
[null,null,"Ondersteunend Wonen 1 + Dagbesteding Intensiteit 1 + Huisvesting + Verpleging en verzorging ",null,"44Z13 ","per week","per etmaal",228.02,"n.v.t.","n.v.t."]
[null,null,"Ondersteunend Wonen 1 + Dagbesteding Intensiteit 2 + Huisvesting + Verpleging en verzorging ",null,"44Z14 ","per week","per etmaal",251.64,"n.v.t.","n.v.t."]
[null,null,"Ondersteunend Wonen 2",null,"44Z15 ","per week","per etmaal",132.66,"n.v.t.","n.v.t."]
[null,"Beschermd wonen 2","Ondersteunend Wonen 2 + Dagbesteding Intensiteit 1 ",null,"44Z16 ","per week","per etmaal",153.34,"n.v.t.","n.v.t."]
[null,null,"Ondersteunend Wonen 2 + Dagbesteding Intensiteit 2 ",null,"44Z17 ","per week","per etmaal",176.96,"n.v.t.","n.v.t."]
[null,null,"Ondersteunend Wonen 2 + Huisvesting ",null,"44Z18 ","per week","per etmaal",163.72999999999999,"n.v.t.","n.v.t."]
[null,null,"Ondersteunend Wonen 2 + Verpleging en Verzorging ",null,"44Z19 ","per week","per etmaal",199.91,"n.v.t.","n.v.t."]
[null,null,"Ondersteunend Wonen 2 + Dagbesteding Intensiteit 1 + Huisvesting ",null,"44Z20 ","per week","per etmaal",184.41,"n.v.t.","n.v.t."]
[null,null,"Ondersteunend Wonen 2 + Dagbesteding Intensiteit 2 + Huisvesting ",null,"44Z21 ","per week","per etmaal",208.03,"n.v.t.","n.v.t."]
[null,null,"Ondersteunend Wonen 2 + Dagbesteding Intensiteit 1 + Verpleging en verzorging ",null,"44Z22 ","per week","per etmaal",220.59,"n.v.t.","n.v.t."]
[null,null,"Ondersteunend Wonen 2 + Dagbesteding Intensiteit 2 + Verpleging en verzorging ",null,"44Z23 ","per week","per etmaal",244.21,"n.v.t.","n.v.t."]
[null,null,"Ondersteunend Wonen 2 + Dagbesteding Intensiteit 1 + Huisvesting + Verpleging en verzorging ",null,"44Z24 ","per week","per etmaal",251.66,"n.v.t.","n.v.t."]
[null,null,"Ondersteunend Wonen 2 + Dagbesteding Intensiteit 2 + Huisvesting + Verpleging en verzorging ",null,"44Z25 ","per week","per etmaal",275.27999999999997,"n.v.t.","n.v.t."]
[null,null,"Beschermd Wonen ",null,"44Z26 ","per week","per etmaal",174.74,"n.v.t.","n.v.t."]
[null,null,"Beschermd Wonen + Dagbesteding Intensiteit 1 ",null,"44Z27 ","per week","per etmaal",195.42,"n.v.t.","n.v.t."]
[null,null,"Beschermd Wonen + Dagbesteding Intensiteit 2 ",null,"44Z28 ","per week","per etmaal",219.04,"n.v.t.","n.v.t."]
[null,null,"Beschermd Wonen + Huisvesting ",null,"44Z29 ","per week","per etmaal",205.81,"n.v.t.","n.v.t."]
[null,null,"Beschermd Wonen + Verpleging en Verzorging ",null,"44Z30 ","per week","per etmaal",241.99,"n.v.t.","n.v.t."]
[null,null,"Beschermd Wonen + Dagbesteding Intensiteit 1 + Huisvesting ",null,"44Z31 ","per week","per etmaal",226.49,"n.v.t.","n.v.t."]
[null,null,"Beschermd Wonen + Dagbesteding Intensiteit 2 + Huisvesting ",null,"44Z32 ","per week","per etmaal",250.11,"n.v.t.","n.v.t."]
[null,null,"Beschermd Wonen + Dagbesteding Intensiteit 1 + Verpleging en verzorging ",null,"44Z33 ","per week","per etmaal",262.67,"n.v.t.","n.v.t."]
[null,null,"Beschermd Wonen + Dagbesteding Intensiteit 2 + Verpleging en verzorging ",null,"44Z34 ","per week","per etmaal",286.29000000000002,"n.v.t.","n.v.t."]
[null,null,"Beschermd Wonen + Dagbesteding Intensiteit 1 + Huisvesting + Verpleging en verzorging ",null,"44Z35 ","per week","per etmaal",293.74,"n.v.t.","n.v.t."]
[null,null,"Beschermd Wonen + Dagbesteding Intensiteit 2 + Huisvesting + Verpleging en verzorging ",null,"44Z36 ","per week","per etmaal",317.36,"n.v.t.","n.v.t."]
[null,"Crisis","Crisisinterventie ambulant ",null,46001,"per week","uur",126.97,"n.v.t.","n.v.t."]
[null,null,"Crisisinterventie ambulant crisisdienst ",null,46002,"per week","uur",169.11,"n.v.t.","n.v.t."]
[null,null,"Crisispleegzorg deeltijd ",null,46003,"per week","etmaal",43.3,"n.v.t.","n.v.t."]
[null,null,"Crisispleegzorg voltijd ",null,46004,"per week","etmaal",43.3,"n.v.t.","n.v.t."]
[null,null,"Crisisinterventie Verblijf ",null,46005,"per week","etmaal",281.82,"n.v.t.","n.v.t."]
[null,null,"Crisisinterventie verblijf F ",null,46006,"per week","etmaal",396.86,"n.v.t.","n.v.t."]
[null,null,"Crisisinterventie behandeling bij verblijf ",null,46007,"per week","uur",110.87,"n.v.t.","n.v.t."]
[null,"Medicatiecontrole","Medicatiecontrole",null,"54MED","totaal over periode","stuks",120,"n.v.t.","n.v.t."]

{"sheet":"Productcodelijst segment 2","index":2,"n_rows":40,"n_cols":11,"rows_kept":40,"cut":false,"hidden":true,"merged":[[0,0,3,3],[0,4,3,9]]}
["productcodelijst segment 2"]
[]
[]
[]
[null,null,"intensiteit A","intensiteit B","intensiteit C","intensiteit D","intensiteit E","Intensiteit F","intensiteit G","intensiteit H*","intensiteit I*"]
["Arrangement 1 - Behoefte aan het verbeteren van het psychosociaal functioneren ontstaan door problematische relatie ouders Behoefte aan het vergroten van specifieke opvoedingsvaardigheden ouders vanwege problemen jeugdige. ","Arrangement 1",513.4,1995.1,4976.7,8865.2000000000007,14102.9,21754.7,34505.199999999997,553.70000000000005,3071.7]
["Arrangement 2 - Behoefte aan het vergroten van specifieke opvoedingsvaardigheden ouders vanwege problemen jeugdige. ","Arrangement 2",1029.9000000000001,2432.1999999999998,4825.1000000000004,8865.2000000000007,14102.9,21754.7,34505.199999999997,553.70000000000005,3071.7]
["Arrangement 3 - Behoefte aan vergroten van specifieke opvoedingsvaardigheden van ouders met een ziekte, lichamelijke- of verstandelijke beperking. ","Arrangement 3",513.4,1995.1,4976.7,8865.2000000000007,14102.9,21754.7,34505.199999999997,553.70000000000005,3071.7]
["Arrangement 4 - Behoefte aan verbeteren van functioneren jeugdige met psychi(atri)sche en/of ontwikkelingsstoornis, en het vergroten van specifieke opvoedvaardigheden voor ouders met psychi(atri)sche problematiek. ","Arrangement 4",825.2,2937,5478.4,8865.2000000000007,14102.9,21754.7,34505.199999999997,2090.6,6417.2]
["Arrangement 5 - Behoefte aan verbeteren van functioneren jeugdige met psychiatrische en/of ontwikkelingsstoornis, eventueel in combinatie met somatische stoornis. ","Arrangement 5",1038.4000000000001,2945.6,5846.5,8865.2000000000007,14102.9,21754.7,34505.199999999997,2090.6,6417.2]
["Arrangement 6 - Behoefte aan verbeteren functioneren van jeugdige en ouders, in een gezinssituatie met multi-problem kenmerken en zorgdragen voor de veiligheid van de jeugdige(n). ","Arrangement 6",1044.8,2945.6,5846.5,8865.2000000000007,14102.9,21754.7,34505.199999999997,2090.6,6417.2]
["Arrangement 7 - Behoefte aan verbeteren van functioneren jeugdige met een verstandelijke beperking en/of ondersteuning van ouders hierbij. ","Arrangement 7",941.9,3000.7,5659.8,8865.2000000000007,14102.9,21754.7,34505.199999999997,553.70000000000005,3071.7]
["Arrangement 8 - Behoefte aan verbeteren van functioneren jeugdige met een verstandelijke beperking i.c.m. ontwikkelings- en gedragsproblematiek en/of ondersteuning van ouders hierbij. ","Arrangement 8",941.9,3000.7,5659.8,8865.2000000000007,14102.9,21754.7,34505.199999999997,553.70000000000005,3071.7]
["Arrangement 9 - Behoefte aan verbeteren van functioneren jeugdige met een lichamelijke beperking en/of niet aangeboren hersenletsel en/of ondersteuning van ouders hierbij. ","Arrangement 9",941.9,3000.7,5659.8,8865.2000000000007,14102.9,21754.7,34505.199999999997,553.70000000000005,3071.7]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Controlevraag 2","Controlevraag 1"]
["Is er een eerdere beschikking afgegeven? ","Ja"]
["Ja","Nee"]
["Nee"]
[]
[]
["Datumverschil < 2 maanden"]
[]
["Controle vraag 3"]
["Ja"]
["Nee"]
[]
[]
["Keuzemenu PGB vraag 1"]
["Formeel PGB"]
["Informeel"]