{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Person 1"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":1,"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":"Person 1","index":0,"n_rows":97,"n_cols":25,"rows_kept":97,"cut":false,"hidden":false,"merged":[[58,2,58,3],[59,4,59,7],[100,0,100,2],[46,2,46,3],[47,2,47,3],[71,2,71,3],[72,2,72,3],[96,0,96,1],[71,0,71,1],[46,0,46,1],[47,0,47,1],[51,0,51,5],[52,0,52,1],[52,2,52,3],[53,0,53,1],[53,2,53,3],[41,0,41,1],[42,0,42,1],[43,0,43,1],[44,0,44,1],[45,0,45,1],[41,2,41,3],[42,2,42,3],[43,2,43,3],[44,2,44,3],[45,2,45,3],[0,0,2,8],[18,0,18,1],[14,0,14,1],[15,0,15,4],[17,0,17,1],[17,2,17,4],[6,2,6,4],[7,2,7,4],[8,2,8,4],[16,2,16,4],[48,4,48,7],[91,0,91,8],[79,0,79,2],[87,0,87,2],[90,0,90,2],[72,0,72,1],[51,6,51,7],[55,0,55,1],[55,2,55,3],[56,0,56,1],[56,2,56,3],[57,0,57,1],[57,2,57,3],[58,0,58,1],[54,0,54,1],[54,2,54,3],[40,0,40,5],[18,2,18,4],[12,5,12,6],[14,5,14,6],[16,5,16,6],[18,5,18,6],[13,2,13,4],[13,5,13,6],[13,0,13,1],[17,5,17,6],[22,0,22,7],[21,0,21,7],[23,0,23,7],[40,6,40,7],[12,2,12,4],[14,2,14,4],[28,4,28,7],[26,0,26,7],[27,0,27,7],[24,0,24,7],[25,0,25,7],[62,0,62,7],[63,0,63,7],[64,0,64,7],[65,0,65,7],[66,0,66,7],[37,4,37,7],[35,0,35,7],[36,0,36,7],[32,0,32,7],[33,0,33,7],[34,0,34,7]]}
["Abrechnungsformular für stationäre Kindesschutzmassnahmen"]
[]
[]
[]
["Zeitgleich ambulante und stationäre Kindesschutzmassnahme vorhanden:"]
[]
["Gemeinde"]
["Jahr"]
["Zeitraum"]
[]
[]
["Kind  / Jugendliche/r"]
["Name",null,"Vorname",null,null,"Geburtsdatum (TT.MM.JJJJ)"]
[]
[]
["Eltern (Inhaber/innen der elterlichen Sorge)"]
["Name",null,"Vorname",null,null,"Strasse / Nr.",null,"PLZ","Ort"]
[]
[]
[]
["Leistungen Dritter"]
["Monatliches Einkommen des Kindes",null,null,null,null,null,null,null,"Betrag "]
["Beschreibung",null,null,null,null,null,null,null,"(Fr.)"]
["Einnahmen aus Renten/Taggeldern/Versicherungen/Beihilfen"]
["Kinder- / Ausbildungszulagen"]
["Unterhaltsbeiträge und Alimente"]
["Stipendien"]
["Sonstige periodische Einnahmen des Kindes (bitte bei Bedarf eintragen)"]
[null,null,null,null,"Total Leistungen Dritter (an Massnahmekosten anzurechnen)",null,null,null,{"$f":"SUM(I24:I28)","v":0}]
[]
["Wurden im betreffenden Abrechnungsquartal rückwirkend Leistungen Dritter ausbezahlt (bspw. IV, EL, etc.)?",null,null,null,null,null,null,null,null,null,null,false]
[]
["Rückwirkend ausbezahlte Leistungen Dritter (für die gesamte Dauer der stationären Kindesschutzmassnahmen)",null,null,null,null,null,null,null,"Betrag "]
["Beschreibung",null,null,null,null,null,null,null,"(Fr.)"]
[]
[]
[]
[null,null,null,null,"Total rückwirkend ausbezahlte Leistungen Dritter                             (an Massnahmekosten anzurechnen)",null,null,null,{"$f":"SUM(I35:I37)","v":0}]
[]
["Kosten für stationäre Kindesschutzmassnahmen"]
["Institution ",null,null,null,null,null,"Aufenthaltsdauer (im Quartal)",null,"Betrag"]
["Name",null,"Strasse",null,"PLZ","Ort","von (TT.MM.JJJJ)","bis (TT.MM.JJJJ)","(Fr.)",null,null,"Eff. Tage","Diff. Anfangsmonat","Tage Anfangsmonat","Diff. Endmonat","Tage Endmonat","Max. Tage","Betrag",null,"Monatsangabe","Monatsangabe","Monatsangabe","Zahlenwert","Zahlenwert","Zahlenwert"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK(G43),ISBLANK(H43)),\"\",_xlfn.DAYS(H43,G43)+1)","v":""},{"$f":"IF(OR(ISBLANK(G43),ISBLANK(H43)),\"\",IF(DAY(G43)<>1,DAY(G43),1))","v":""},{"$f":"IF(OR(ISBLANK(G43),ISBLANK(H43)),\"\",DAY(DATE(YEAR(G43),MONTH(G43)+1,0)))","v":""},{"$f":"IF(OR(ISBLANK(G43),ISBLANK(H43)),\"\",IF(DAY(H43)<>DAY(DATE(YEAR(H43),MONTH(H43)+1,0)),DAY(DATE(YEAR(H43),MONTH(H43)+1,0))-DAY(H43),0))","v":""},{"$f":"IF(OR(ISBLANK(G43),ISBLANK(H43)),\"\",DAY(DATE(YEAR(H43),MONTH(H43)+1,0)))","v":""},{"$f":"IF(OR(ISBLANK(G43),ISBLANK(H43)),\"\",SUM(_xlfn.DAYS(H43,G43),M43,O43))","v":""},{"$f":"IFERROR(IF(AND($I$29<>0,I43<>\"\",ISERROR(IF(MONTH(H43)-MONTH(G43)=0,$I$29/Q43*L43,IF(MONTH(H43)-MONTH(G43)=1,($I$29/N43*(N43-M43+1))+($I$29/P43*(P43-O43)),($I$29*(MONTH(H43)-MONTH(G43)-1))+($I$29/N43*(N43-M43+1))+($I$29/P43*(P43-O43)))))),\"Überprüfen!\",IF(MONTH(H43)-MONTH(G43)=0,$I$29/Q43*L43,IF(MONTH(H43)-MONTH(G43)=1,($I$29/N43*(N43-M43+1))+($I$29/P43*(P43-O43)),($I$29*(MONTH(H43)-MONTH(G43)-1))+($I$29/N43*(N43-M43+1))+($I$29/P43*(P43-O43))))),\"\")","v":""},null,{"$f":"IF(TEXT(G43,\"MM.JJJJ\")=\"01.1900\",\"\",TEXT(G43,\"MM.JJJJ\"))","v":""},{"$f":"IFERROR(TEXT(IF(DATEDIF(DATE(RIGHT(T43,4),LEFT(T43,2),1),DATE(RIGHT(V43,4),LEFT(V43,2),1),\"m\")=2,EDATE(DATE(RIGHT(T43,4),LEFT(T43,2),1),1),\"\"),\"MM.JJJJ\"),\"\")","v":""},{"$f":"IF(TEXT(H43,\"MM.JJJJ\")=\"01.1900\",\"\",TEXT(H43,\"MM.JJJJ\"))","v":""},{"$f":"IFERROR(DATEVALUE(T43),\"\")","v":""},{"$f":"IFERROR(DATEVALUE(U43),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK(G44),ISBLANK(H44)),\"\",_xlfn.DAYS(H44,G44)+1)","v":""},{"$f":"IF(OR(ISBLANK(G44),ISBLANK(H44)),\"\",IF(DAY(G44)<>1,DAY(G44),1))","v":""},{"$f":"IF(OR(ISBLANK(G44),ISBLANK(H44)),\"\",DAY(DATE(YEAR(G44),MONTH(G44)+1,0)))","v":""},{"$f":"IF(OR(ISBLANK(G44),ISBLANK(H44)),\"\",IF(DAY(H44)<>DAY(DATE(YEAR(H44),MONTH(H44)+1,0)),DAY(DATE(YEAR(H44),MONTH(H44)+1,0))-DAY(H44),0))","v":""},{"$f":"IF(OR(ISBLANK(G44),ISBLANK(H44)),\"\",DAY(DATE(YEAR(H44),MONTH(H44)+1,0)))","v":""},{"$f":"IF(OR(ISBLANK(G44),ISBLANK(H44)),\"\",SUM(_xlfn.DAYS(H44,G44),M44,O44))","v":""},"",null,{"$f":"IF(TEXT(G44,\"MM.JJJJ\")=\"01.1900\",\"\",TEXT(G44,\"MM.JJJJ\"))","v":""},{"$f":"IFERROR(TEXT(IF(DATEDIF(DATE(RIGHT(T44,4),LEFT(T44,2),1),DATE(RIGHT(V44,4),LEFT(V44,2),1),\"m\")=2,EDATE(DATE(RIGHT(T44,4),LEFT(T44,2),1),1),\"\"),\"MM.JJJJ\"),\"\")","v":""},{"$f":"IF(TEXT(H44,\"MM.JJJJ\")=\"01.1900\",\"\",TEXT(H44,\"MM.JJJJ\"))","v":""},{"$f":"IFERROR(DATEVALUE(T44),\"\")","v":""},"",{"$f":"IFERROR(DATEVALUE(V44),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","",{"$f":"IFERROR(IF(AND($I$29<>0,I45<>\"\",ISERROR(IF(MONTH(H45)-MONTH(G45)=0,$I$29/Q45*L45,IF(MONTH(H45)-MONTH(G45)=1,($I$29/N45*(N45-M45+1))+($I$29/P45*(P45-O45)),($I$29*(MONTH(H45)-MONTH(G45)-1))+($I$29/N45*(N45-M45+1))+($I$29/P45*(P45-O45)))))),\"Überprüfen!\",IF(MONTH(H45)-MONTH(G45)=0,$I$29/Q45*L45,IF(MONTH(H45)-MONTH(G45)=1,($I$29/N45*(N45-M45+1))+($I$29/P45*(P45-O45)),($I$29*(MONTH(H45)-MONTH(G45)-1))+($I$29/N45*(N45-M45+1))+($I$29/P45*(P45-O45))))),\"\")","v":""},null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","",{"$f":"IFERROR(IF(AND($I$29<>0,I46<>\"\",ISERROR(IF(MONTH(H46)-MONTH(G46)=0,$I$29/Q46*L46,IF(MONTH(H46)-MONTH(G46)=1,($I$29/N46*(N46-M46+1))+($I$29/P46*(P46-O46)),($I$29*(MONTH(H46)-MONTH(G46)-1))+($I$29/N46*(N46-M46+1))+($I$29/P46*(P46-O46)))))),\"Überprüfen!\",IF(MONTH(H46)-MONTH(G46)=0,$I$29/Q46*L46,IF(MONTH(H46)-MONTH(G46)=1,($I$29/N46*(N46-M46+1))+($I$29/P46*(P46-O46)),($I$29*(MONTH(H46)-MONTH(G46)-1))+($I$29/N46*(N46-M46+1))+($I$29/P46*(P46-O46))))),\"\")","v":""},null,{"$f":"IF(TEXT(G46,\"MM.JJJJ\")=\"01.1900\",\"\",TEXT(G46,\"MM.JJJJ\"))","v":""},"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",null,{"$f":"IF(TEXT(G47,\"MM.JJJJ\")=\"01.1900\",\"\",TEXT(G47,\"MM.JJJJ\"))","v":""},"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",null,"","","","","",""]
[null,null,null,null,"Gesamtkosten für stationäre Kindesschutzmassnahmen",null,null,null,{"$f":"SUM(I43:I48)","v":0},null,null,"Von-Datum","Bis-Datum",null,null,null,null,null,null,{"$f":"IF(TEXT(G54,\"MM.JJJJ\")=\"01.1900\",\"\",TEXT(G54,\"MM.JJJJ\"))","v":""},"",{"$f":"IF(TEXT(H54,\"MM.JJJJ\")=\"01.1900\",\"\",TEXT(H54,\"MM.JJJJ\"))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(G43),\"\",G43)","v":""},{"$f":"IF(ISBLANK(H43),\"\",H43)","v":""},null,null,null,null,null,null,{"$f":"IF(TEXT(G55,\"MM.JJJJ\")=\"01.1900\",\"\",TEXT(G55,\"MM.JJJJ\"))","v":""},"",{"$f":"IF(TEXT(H55,\"MM.JJJJ\")=\"01.1900\",\"\",TEXT(H55,\"MM.JJJJ\"))","v":""},"","",""]
["Kosten für ambulante Kindesschutzmassnahmen",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(G44),\"\",G44)","v":""},"",null,null,null,null,null,null,"","","","","",""]
["Institution ",null,null,null,null,null,"Massnahmedauer (im Quartal)",null,"Betrag",null,null,"","",null,null,null,null,null,null,"","","","","",""]
["Name",null,"Strasse",null,"PLZ","Ort","von (TT.MM.JJJJ)","bis (TT.MM.JJJJ)","(Fr.)",null,null,"","",null,null,null,null,null,null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(G48),\"\",G48)","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(G54),\"\",G54)","v":""},{"$f":"IF(ISBLANK(H54),\"\",H54)","v":""},null,null,null,null,null,null,null,null,null,"Anzahl Monate"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(G55),\"\",G55)","v":""},"",null,null,null,null,null,null,null,null,null,{"$f":"SUM(1/COUNTIF(W43:Y54,W43:Y54))-1","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,"Gesamtkosten für ambulante Kindesschutzmassnahmen",null,null,null,{"$f":"SUM(I54:I59)","v":0},null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,"",""]
["Berechnung Nettokosten"]
["Gesamtkosten für stationäre Kindesschutzmassnahmen",null,null,null,null,null,null,null,{"$f":"I49","v":0},null,null,"Anzahl einzigartige Tage"]
["Gesamtkosten für ambulante Kindesschutzmassnahmen",null,null,null,null,null,null,null,{"$f":"I60","v":0},null,null,0]
["Total Leistungen Dritter",null,null,null,null,null,null,null,{"$f":"IF(OR(R43=\"Überprüfen!\",R44=\"Überprüfen!\",R45=\"Überprüfen!\",R46=\"Überprüfen!\",R47=\"Überprüfen!\",R48=\"Überprüfen!\"),\"Überprüfen!\",SUM(R43:R48,I38))","v":0},"- Bitte Aufenthaltsdauer unter \"Kosten für stationäre Kindesschutzmassnahmen\" korrekt erfassen"]
["An den interkommunalen Pool weiter zu verrechnender Anteil (95 % Gesamtkosten Kindesschutzmassnahmen)",null,null,null,null,null,null,null,{"$f":"IF(AND(IF(I65=\"Überprüfen!\",\"Überprüfen!\",0.95*(I63+I64-I65))<0,L31=TRUE),IF(I65=\"Überprüfen!\",\"Überprüfen!\",0.95*(I63+I64-I65)),IF(AND(IF(I65=\"Überprüfen!\",\"Überprüfen!\",0.95*(I63+I64-I65))<0,L31=FALSE),0,IF(I65=\"Überprüfen!\",\"Überprüfen!\",0.95*(I63+I64-I65))))","v":0}]
["Bei der Gemeinde verbleibender Anteil (5 % Gesamtkosten Kindesschutzmassnahmen)",null,null,null,null,null,null,null,{"$f":"IF(AND(IF(I66=\"Überprüfen!\",\"Überprüfen!\",0.05*(I63+I64-I65))<0,L31=TRUE),IF(I66=\"Überprüfen!\",\"Überprüfen!\",0.05*(I63+I64-I65)),IF(AND(IF(I66=\"Überprüfen!\",\"Überprüfen!\",0.05*(I63+I64-I65))<0,L31=FALSE),0,IF(I66=\"Überprüfen!\",\"Überprüfen!\",0.05*(I63+I64-I65))))","v":0}]
[]
["Elternbeitrag (im betreffenden Quartal effektiv geleistet)"]
[]
[]
["Von den Eltern bezahlt ",null,"Von der Gemeinde bevorschusst",null,"Elternbeitrag (Fr.)","Für Abrech-nungsperiode geschuldeter Elternbeitrag (Fr.)","Effektiv geleisteter Elternbeitrag (Fr.)","Anteil zugunsten Gemeinde (20 %) (Fr.)","Anteil zugunsten interkommunaler Pool (80 %) \n(Fr.) "]
[null,null,null,null,0,{"$f":"IF(OR(E73=5,E73=10),E73*L64,E73*W57)","v":0},0,{"$f":"0.2*G73","v":0},{"$f":"0.8*G73","v":0},{"$f":"L64*5","v":0},"-> Sofern Alimente gezahlt werden: Der in der Zelle E73 angegebene Elternbeitrag ist kleiner als der minimale Elternbeitrag von Fr. 5.-! Bitte 5 in die Zelle E73 eintragen!"]
[null,null,null,null,"Total",{"$f":"SUM(F73:F73)","v":0},{"$f":"SUM(G73:G73)","v":0},{"$f":"SUM(H73:H73)","v":0},{"$f":"SUM(I73:I73)","v":0},{"$f":"L64*10","v":0},"-> Sofern keine Alimente gezahlt werden: Der in der Zelle E73 angegebene Elternbeitrag ist kleiner als der minimale Elternbeitrag von Fr. 10.-! Bitte 10 in der Zelle E73 eintragen!"]
[]
["*Gemäss Art. 63a Abs. 4 EGzZGB beteiligen sich die Inhaber der elterlichen Sorge mit mindestens Fr. 10.- pro Tag."]
[]
["Gesamtbetrag zu Gunsten Gemeinde",null,null,null,null,null,null,null,{"$f":"IFERROR(IF(AND(I66-I74<0,L31=TRUE),I66-I74,IF(AND(I66-I74<0,L31=FALSE),0,I66-I74)),0)","v":0},"- Übersteigen die Einnahmen die Kosten für Kindesschutzmassnahmen, ist keine Abrechnung über den interkommunalen Pool notwendig."]
[]
["Beilagen"]
["- Verfügung Kindesschutzmassnahmen"]
["- Abrechnungen der leistungserbringenden Institution/en"]
["- Berechnung Elternbeitrag"]
["- Nachweis der geleisteten Elternbeiträge (Kontoauszug)"]
["- Leistungsentscheid bzw. Verfügung Sozialhilfe"]
["- Nachweis über Alimente"]
[]
["Einreichefrist"]
["30. April, 31. Juli, 31. Oktober und 31. Januar"]
[]
["Form der Einreichung"]
["Die Abrechnung und die zugehörigen Dokumente sind elektronisch via die pCloud (sicherer Zugang) einzureichen. Bitte melden Sie sich, damit wir Ihnen den Zugang einrichten können. "]
[]
[]
[]
[]
["Ort / Datum",null,null,null,null,"Unterschrift Gemeinde"]