{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Start","A","B","C","D","E","F","G","H","I","J","K","Erläuterungen"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":17,"comments":12,"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":"Start","index":0,"n_rows":68,"n_cols":20,"rows_kept":68,"cut":false,"hidden":false,"merged":[[47,6,47,9],[47,10,47,11],[48,6,48,9],[48,10,48,11],[50,6,50,9],[50,10,50,11],[39,6,39,9],[39,10,39,11],[40,6,40,9],[40,10,40,11],[46,6,46,9],[46,10,46,11],[36,6,36,9],[36,10,36,11],[37,6,37,9],[37,10,37,11],[38,6,38,9],[38,10,38,11],[33,6,33,9],[33,10,33,11],[34,6,34,9],[34,10,34,11],[35,6,35,9],[35,10,35,11],[30,6,30,9],[30,10,30,11],[31,6,31,9],[31,10,31,11],[32,6,32,9],[32,10,32,11],[25,10,25,11],[26,6,26,9],[26,10,26,11],[27,6,27,9],[27,10,27,11],[7,6,7,7],[7,8,7,9],[8,6,8,7],[8,8,8,9],[11,10,11,11],[0,6,0,9],[2,2,2,5],[2,10,2,11],[6,6,6,9],[4,2,4,3],[4,4,4,5],[4,10,4,11],[21,5,22,5],[21,6,22,9],[21,10,22,11],[11,0,11,2],[13,0,13,2],[15,0,15,2],[19,0,19,2],[21,0,21,1],[21,2,21,4],[17,0,17,2],[17,6,17,9],[56,1,56,2],[52,6,52,9],[52,10,52,11],[23,6,23,9],[23,10,23,11],[49,6,49,9],[49,10,49,11],[51,6,51,9],[51,10,51,11],[24,10,24,11],[24,6,24,9],[28,6,28,9],[28,10,28,11],[29,6,29,9],[29,10,29,11],[25,6,25,9]]}
[null,null,null,null,null,"Einrichtung:",null,null,null,null,null,null,null,null,null,null,"Monat","Jahr","Mo","A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-01-01",2019,"Di","B"]
[null,"Klient/in:",null,null,null,null,null,"Wohnort:",null,null,null,null,null,null,null,null,"2014-02-01",2020,"Mi","C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-03-01",2021,"Do"]
[null,"Monat/Jahr: ","Monat",null,"Jahr",null,null,"Bezugsbetreuer/in:",null,null,null,null,null,null,null,null,"2014-04-01",2022,"Fr"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"60/15","2014-05-01",2023,"Sa"]
[null,"FLS laut Bescheid:",null,null,null,null,"Bewilligungszeitraum",null,null,null,null,null,null,null,null,"48/12","2014-06-01",2024,"So"]
[null,null,null,null,null,null,"von",null,"bis",null,null,"rechnerische Tage:",null,null,null,null,"2014-07-01",2025]
["Fachleistungsstunde bitte wählen",null,null,null,"60/15",null,null,null,null,null,null,{"$f":"I9-G9+1","v":1},null,null,null,null,"2014-08-01",2026]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-09-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-10-01"]
["Wöchentlich bewilligte\ndirekte Betreuung:",null,null,null,null,null,{"$f":"I12/60","v":0},"Std.",{"$f":"IF(E9=\"60/15\",C7*60,C7*48)","v":0},"Minuten","Einsatzpauschalen laut Vergütungsvereinbarung",null,null,null,null,null,"2014-11-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-12-01"]
["Zeit-Pool  insgesamt                                     -  direkte Betreuung:",null,null,null,{"$f":"ROUND(IF(E9=\"60/15\",I14/60,I14/48),2)","v":0},"FLS",{"$f":"ROUND(G12/7*L9,2)","v":0},"Std.",{"$f":"G14*60","v":0},"Minuten","Pauschale A"]
[]
["Bisher geleistete Zeit     (inkl. Abrechnungsmonat):",null,null,null,{"$f":"ROUND(IF(E9=\"60/15\",I16/60,I16/48),2)","v":0},"FLS",{"$f":"ROUND(I16/60,2)","v":0},"Std.",{"$f":"D57","v":0},"Minuten","Pauschale B"]
[]
["ggf. Veränderungen\n(+ / -):",null,null,null,null,"FLS","(z. B. Abzüge wg. Krankenhausaufenthalten, Zuschläge wg. akuten Krisen)",null,null,null,"Pauschale C"]
[]
["Verbleibende FLS                         - direkte Betreuung:",null,null,null,{"$f":"E14-E16+E18","v":0},"FLS",{"$f":"ROUND(I20/60,2)","v":0},"Std.",{"$f":"IF(E9=\"60/15\",E20*60,E20*48)","v":0},"Minuten","Vergütung je FLS"]
[]
["Zeit",null,"direkte Betreuung",null,null,"EP","Art des Kontaktes",null,null,null,"Bemerkungen"]
["Tag","Datum","von","bis","Min"]
[null,null,null,null,{"$f":"IF(OR(C24=\"\",D24=\"\"),\"\",MOD(D24-C24,1)*24*60)","v":""}]
[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,""]
[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,""]
[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,""]
[null,null,null,null,""]
[null,null,null,null,""]
[]
[]
[null,null,null,null,null,null,null,"Rechnungsbetrag"]
[null,"Summe (Min)",null,{"$f":"SUM(E24:E53)","v":0}]
[null,null,"FLS",{"$f":"ROUND(IF(E9=\"60/15\",D57/75,D57/60),2)","v":0},null,null,null,{"$f":"D58*L20","v":0},null,"FLS"]
[null,null,null,null,null,null,null,{"$f":"D60*L14+D62*L16+D64*L18","v":0},null,"Einsatzpauschalen"]
[null,null,"Anzahl Einsatzpauschale A",{"$f":"COUNTIFS($F$24:$F$53,\"A\")","v":0},null,null,null,{"$f":"SUM(H58:H59)","v":0},null,"Summe"]
[]
[null,null,"Anzahl Einsatzpauschale B",{"$f":"COUNTIFS($F$24:$F$53,\"B\")","v":0}]
[]
[null,null,"Anzahl Einsatzpauschale C",{"$f":"COUNTIFS($F$24:$F$53,\"C\")","v":0}]
[]
[]
[null,null,null,null,null,null,null,"_____________________________",null,null,"________________________________"]
[null,null,null,null,null,null,null,"Datum, Unterschrift Klient/in ",null,null,"Datum, Unterschrift Mitarbeiter/in"]

{"sheet":"A","index":1,"n_rows":68,"n_cols":20,"rows_kept":68,"cut":false,"hidden":false,"merged":[[24,10,24,11],[25,10,25,11],[26,10,26,11],[27,10,27,11],[28,10,28,11],[24,6,24,9],[25,6,25,9],[26,6,26,9],[27,6,27,9],[28,6,28,9],[47,6,47,9],[47,10,47,11],[48,6,48,9],[48,10,48,11],[50,6,50,9],[50,10,50,11],[44,6,44,9],[44,10,44,11],[45,6,45,9],[45,10,45,11],[46,6,46,9],[46,10,46,11],[41,6,41,9],[41,10,41,11],[42,6,42,9],[42,10,42,11],[43,6,43,9],[43,10,43,11],[38,6,38,9],[38,10,38,11],[39,6,39,9],[39,10,39,11],[40,6,40,9],[40,10,40,11],[35,6,35,9],[35,10,35,11],[36,6,36,9],[36,10,36,11],[37,6,37,9],[37,10,37,11],[30,10,30,11],[31,6,31,9],[31,10,31,11],[32,6,32,9],[32,10,32,11],[21,5,22,5],[21,6,22,9],[21,10,22,11],[11,0,11,2],[13,0,13,2],[15,0,15,2],[19,0,19,2],[21,0,21,1],[21,2,21,4],[17,0,17,2],[17,6,17,9],[7,6,7,7],[7,8,7,9],[8,6,8,7],[8,8,8,9],[11,10,11,11],[0,6,0,9],[2,10,2,11],[6,6,6,9],[4,2,4,3],[4,4,4,5],[2,2,2,5],[4,10,4,11],[56,1,56,2],[52,6,52,9],[52,10,52,11],[23,6,23,9],[23,10,23,11],[49,6,49,9],[49,10,49,11],[51,6,51,9],[51,10,51,11],[29,10,29,11],[29,6,29,9],[33,6,33,9],[33,10,33,11],[34,6,34,9],[34,10,34,11],[30,6,30,9]]}
[null,null,null,null,null,"Einrichtung:",{"$f":"Start!G1","v":0},null,null,null,null,null,null,null,null,null,"Monat","Jahr","Mo","A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-01-01",2013,"Di","B"]
[null,"Klient/in:",{"$f":"Start!C3","v":0},null,null,null,null,null,null,"Wohnort:",{"$f":"Start!K3","v":0},null,null,null,null,null,"2014-02-01",2014,"Mi","C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-03-01",2015,"Do"]
[null,"Monat/Jahr: ",{"$f":"DATE(YEAR(Start!C5),MONTH(Start!C5)+1,DAY(Start!C5))","v":{"$error":"#VALUE!"}},null,{"$f":"IF(Start!C5=A!Q14,Start!E5+1,Start!E5)","v":"Jahr"},null,null,null,null,"Bezugsbetreuer/in:",{"$f":"Start!K5","v":0},null,null,null,null,null,"2014-04-01",2016,"Fr"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"60/15","2014-05-01",2017,"Sa"]
[null,"FLS laut Bescheid:",{"$f":"Start!C7","v":0},null,null,null,"Bewilligungszeitraum",null,null,null,null,null,null,null,null,"48/12","2014-06-01",2018,"So"]
[null,null,null,null,null,null,"von",null,"bis",null,null,"rechnerische Tage:",null,null,null,null,"2014-07-01"]
["Fachleistungsstunde bitte wählen",null,null,null,{"$f":"Start!E9","v":"60/15"},null,{"$f":"Start!G9","v":"00:00:00"},null,{"$f":"Start!I9","v":"00:00:00"},null,null,{"$f":"I9-G9+1","v":1},null,null,null,null,"2014-08-01"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-09-01"]
["Wöchentlich bewilligte\ndirekte Betreuung:",null,null,null,null,null,{"$f":"I12/60","v":0},"Std.",{"$f":"IF(E9=\"60/15\",C7*60,C7*48)","v":0},"Minuten","Einsatzpauschalen laut Vergütungsvereinbarung",null,null,null,null,null,"2014-10-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-11-01"]
["Zeit-Pool  insgesamt                                     -  direkte Betreuung:",null,null,null,{"$f":"ROUND(IF(E9=\"60/15\",I14/60,I14/48),2)","v":0},"FLS",{"$f":"ROUND(G12/7*L9,2)","v":0},"Std.",{"$f":"G14*60","v":0},"Minuten","Pauschale A",{"$f":"Start!L14","v":0},null,null,null,null,"2014-12-01"]
[]
["Bisher geleistete Zeit     (inkl. Abrechnungsmonat):",null,null,null,{"$f":"ROUND(IF(E9=\"60/15\",I16/60,I16/48),2)","v":0},"FLS",{"$f":"ROUND(I16/60,2)","v":0},"Std.",{"$f":"D57+(Start!I14-Start!I20)","v":0},"Minuten","Pauschale B",{"$f":"Start!L16","v":0}]
[]
["ggf. Veränderungen\n(+ / -):",null,null,null,null,"FLS","(z. B. Abzüge wg. Krankenhausaufenthalten, Zuschläge wg. akuten Krisen)",null,null,null,"Pauschale C",{"$f":"Start!L18","v":0}]
[]
["Verbleibende FLS                         - direkte Betreuung:",null,null,null,{"$f":"E14-E16+E18","v":0},"FLS",{"$f":"ROUND(I20/60,2)","v":0},"Std.",{"$f":"IF(E9=\"60/15\",E20*60,E20*48)","v":0},"Minuten","Vergütung je FLS",{"$f":"Start!L20","v":0}]
[]
["Zeit",null,"direkte Betreuung",null,null,"EP","Art des Kontaktes",null,null,null,"Bemerkungen"]
["Tag","Datum","von","bis","Min"]
[null,null,null,null,{"$f":"IF(OR(C24=\"\",D24=\"\"),\"\",MOD(D24-C24,1)*24*60)","v":""}]
[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,""]
[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,""]
[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,""]
[null,null,null,null,""]
[null,null,null,null,""]
[]
[]
[null,null,null,null,null,null,null,"Rechnungsbetrag"]
[null,"Summe (Min)",null,{"$f":"SUM(E24:E53)","v":0}]
[null,null,"FLS",{"$f":"ROUND(IF(E9=\"60/15\",D57/75,D57/60),2)","v":0},null,null,null,{"$f":"D58*L20","v":0},null,"FLS"]
[null,null,null,null,null,null,null,{"$f":"D60*L14+D62*L16+D64*L18","v":0},null,"Einsatzpauschalen"]
[null,null,"Anzahl Einsatzpauschale A",{"$f":"COUNTIFS(F24:F53,\"A\")","v":0},null,null,null,{"$f":"SUM(H58:H59)","v":0},null,"Summe"]
[]
[null,null,"Anzahl Einsatzpauschale B",{"$f":"COUNTIFS(F24:F53,\"B\")","v":0}]
[]
[null,null,"Anzahl Einsatzpauschale C",{"$f":"COUNTIFS(F24:F53,\"c\")","v":0}]
[]
[null,null,null,null,null,null,null,"_____________________________",null,null,"________________________________"]
[]
[null,null,null,null,null,null,null,"Datum, Unterschrift Klient/in ",null,null,"Datum, Unterschrift Mitarbeiter/in"]

{"sheet":"B","index":2,"n_rows":68,"n_cols":20,"rows_kept":68,"cut":false,"hidden":false,"merged":[[44,6,44,9],[44,10,44,11],[45,6,45,9],[45,10,45,11],[46,6,46,9],[46,10,46,11],[52,6,52,9],[52,10,52,11],[47,6,47,9],[47,10,47,11],[48,6,48,9],[48,10,48,11],[49,6,49,9],[49,10,49,11],[50,6,50,9],[50,10,50,11],[51,6,51,9],[51,10,51,11],[36,6,36,9],[36,10,36,11],[37,6,37,9],[37,10,37,11],[43,6,43,9],[43,10,43,11],[38,6,38,9],[38,10,38,11],[39,6,39,9],[39,10,39,11],[40,6,40,9],[40,10,40,11],[41,6,41,9],[41,10,41,11],[42,6,42,9],[42,10,42,11],[32,10,32,11],[23,6,23,9],[23,10,23,11],[35,6,35,9],[35,10,35,11],[24,6,24,9],[25,6,25,9],[26,6,26,9],[27,6,27,9],[28,6,28,9],[24,10,24,11],[25,10,25,11],[26,10,26,11],[27,10,27,11],[28,10,28,11],[7,6,7,7],[7,8,7,9],[8,6,8,7],[8,8,8,9],[11,10,11,11],[0,6,0,9],[2,10,2,11],[6,6,6,9],[4,2,4,3],[4,4,4,5],[2,2,2,5],[4,10,4,11],[11,0,11,2],[13,0,13,2],[15,0,15,2],[19,0,19,2],[21,0,21,1],[21,2,21,4],[17,0,17,2],[17,6,17,9],[56,1,56,2],[21,5,22,5],[21,6,22,9],[21,10,22,11],[29,10,29,11],[29,6,29,9],[33,6,33,9],[33,10,33,11],[34,6,34,9],[34,10,34,11],[30,6,30,9],[30,10,30,11],[31,6,31,9],[31,10,31,11],[32,6,32,9]]}
[null,null,null,null,null,"Einrichtung:",{"$f":"Start!G1","v":0},null,null,null,null,null,null,null,null,null,"Monat","Jahr","Mo","A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-01-01",2013,"Di","B"]
[null,"Klient/in:",{"$f":"Start!C3","v":0},null,null,null,null,null,null,"Wohnort:",{"$f":"Start!K3","v":0},null,null,null,null,null,"2014-02-01",2014,"Mi","C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-03-01",2015,"Do"]
[null,"Monat/Jahr: ",{"$f":"DATE(YEAR(A!C5),MONTH(A!C5)+1,DAY(A!C5))","v":{"$error":"#VALUE!"}},null,{"$f":"IF(A!C5=B!Q14,A!E5+1,A!E5)","v":{"$error":"#VALUE!"}},null,null,null,null,"Bezugsbetreuer/in:",{"$f":"Start!K5","v":0},null,null,null,null,null,"2014-04-01",2016,"Fr"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"60/15","2014-05-01",2017,"Sa"]
[null,"FLS laut Bescheid:",{"$f":"Start!C7","v":0},null,null,null,"Bewilligungszeitraum",null,null,null,null,null,null,null,null,"48/12","2014-06-01",2018,"So"]
[null,null,null,null,null,null,"von",null,"bis",null,null,"rechnerische Tage:",null,null,null,null,"2014-07-01"]
["Fachleistungsstunde bitte wählen",null,null,null,{"$f":"Start!E9","v":"60/15"},null,{"$f":"Start!G9","v":"00:00:00"},null,{"$f":"Start!I9","v":"00:00:00"},null,null,{"$f":"I9-G9+1","v":1},null,null,null,null,"2014-08-01"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-09-01"]
["Wöchentlich bewilligte\ndirekte Betreuung:",null,null,null,null,null,{"$f":"I12/60","v":0},"Std.",{"$f":"IF(E9=\"60/15\",C7*60,C7*48)","v":0},"Minuten","Einsatzpauschalen laut Vergütungsvereinbarung",null,null,null,null,null,"2014-10-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-11-01"]
["Zeit-Pool  insgesamt                                     -  direkte Betreuung:",null,null,null,{"$f":"ROUND(IF(E9=\"60/15\",I14/60,I14/48),2)","v":0},"FLS",{"$f":"ROUND(G12/7*L9,2)","v":0},"Std.",{"$f":"G14*60","v":0},"Minuten","Pauschale A",{"$f":"Start!L14","v":0},null,null,null,null,"2014-12-01"]
[]
["Bisher geleistete Zeit     (inkl. Abrechnungsmonat):",null,null,null,{"$f":"ROUND(IF(E9=\"60/15\",I16/60,I16/48),2)","v":0},"FLS",{"$f":"ROUND(I16/60,2)","v":0},"Std.",{"$f":"D57+(A!I14-A!I20)","v":0},"Minuten","Pauschale B",{"$f":"Start!L16","v":0}]
[]
["ggf. Veränderungen\n(+ / -):",null,null,null,null,"FLS","(z. B. Abzüge wg. Krankenhausaufenthalten, Zuschläge wg. akuten Krisen)",null,null,null,"Pauschale C",{"$f":"Start!L18","v":0}]
[]
["Verbleibende FLS                         - direkte Betreuung:",null,null,null,{"$f":"E14-E16+E18","v":0},"FLS",{"$f":"ROUND(I20/60,2)","v":0},"Std.",{"$f":"IF(E9=\"60/15\",E20*60,E20*48)","v":0},"Minuten","Vergütung je FLS",{"$f":"Start!L20","v":0}]
[]
["Zeit",null,"direkte Betreuung",null,null,"EP","Art des Kontaktes",null,null,null,"Bemerkungen"]
["Tag","Datum","von","bis","Min"]
[null,null,null,null,{"$f":"IF(OR(C24=\"\",D24=\"\"),\"\",MOD(D24-C24,1)*24*60)","v":""}]
[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,""]
[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,""]
[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,""]
[null,null,null,null,""]
[null,null,null,null,""]
[]
[]
[null,null,null,null,null,null,null,"Rechnungsbetrag"]
[null,"Summe (Min)",null,{"$f":"SUM(E24:E53)","v":0}]
[null,null,"FLS",{"$f":"ROUND(IF(E9=\"60/15\",D57/75,D57/60),2)","v":0},null,null,null,{"$f":"D58*L20","v":0},null,"FLS"]
[null,null,null,null,null,null,null,{"$f":"D60*L14+D62*L16+D64*L18","v":0},null,"Einsatzpauschalen"]
[null,null,"Anzahl Einsatzpauschale A",{"$f":"COUNTIFS(F24:F53,\"A\")","v":0},null,null,null,{"$f":"SUM(H58:H59)","v":0},null,"Summe"]
[]
[null,null,"Anzahl Einsatzpauschale B",{"$f":"COUNTIFS(F24:F53,\"B\")","v":0}]
[]
[null,null,"Anzahl Einsatzpauschale C",{"$f":"COUNTIFS(F24:F53,\"c\")","v":0}]
[]
[null,null,null,null,null,null,null,"_____________________________",null,null,"________________________________"]
[]
[null,null,null,null,null,null,null,"Datum, Unterschrift Klient/in ",null,null,"Datum, Unterschrift Mitarbeiter/in"]

{"sheet":"C","index":3,"n_rows":68,"n_cols":20,"rows_kept":68,"cut":false,"hidden":false,"merged":[[44,6,44,9],[44,10,44,11],[45,6,45,9],[45,10,45,11],[46,6,46,9],[46,10,46,11],[52,6,52,9],[52,10,52,11],[47,6,47,9],[47,10,47,11],[48,6,48,9],[48,10,48,11],[49,6,49,9],[49,10,49,11],[50,6,50,9],[50,10,50,11],[51,6,51,9],[51,10,51,11],[36,6,36,9],[36,10,36,11],[37,6,37,9],[37,10,37,11],[43,6,43,9],[43,10,43,11],[38,6,38,9],[38,10,38,11],[39,6,39,9],[39,10,39,11],[40,6,40,9],[40,10,40,11],[41,6,41,9],[41,10,41,11],[42,6,42,9],[42,10,42,11],[32,10,32,11],[23,6,23,9],[23,10,23,11],[35,6,35,9],[35,10,35,11],[24,6,24,9],[25,6,25,9],[26,6,26,9],[27,6,27,9],[28,6,28,9],[24,10,24,11],[25,10,25,11],[26,10,26,11],[27,10,27,11],[28,10,28,11],[7,6,7,7],[7,8,7,9],[8,6,8,7],[8,8,8,9],[11,10,11,11],[0,6,0,9],[2,10,2,11],[6,6,6,9],[4,2,4,3],[4,4,4,5],[2,2,2,5],[4,10,4,11],[11,0,11,2],[13,0,13,2],[15,0,15,2],[19,0,19,2],[21,0,21,1],[21,2,21,4],[17,0,17,2],[17,6,17,9],[56,1,56,2],[21,5,22,5],[21,6,22,9],[21,10,22,11],[29,10,29,11],[29,6,29,9],[33,6,33,9],[33,10,33,11],[34,6,34,9],[34,10,34,11],[30,6,30,9],[30,10,30,11],[31,6,31,9],[31,10,31,11],[32,6,32,9]]}
[null,null,null,null,null,"Einrichtung:",{"$f":"Start!G1","v":0},null,null,null,null,null,null,null,null,null,"Monat","Jahr","Mo","A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-01-01",2013,"Di","B"]
[null,"Klient/in:",{"$f":"Start!C3","v":0},null,null,null,null,null,null,"Wohnort:",{"$f":"Start!K3","v":0},null,null,null,null,null,"2014-02-01",2014,"Mi","C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-03-01",2015,"Do"]
[null,"Monat/Jahr: ",{"$f":"DATE(YEAR(B!C5),MONTH(B!C5)+1,DAY(B!C5))","v":{"$error":"#VALUE!"}},null,{"$f":"IF(B!C5='C'!Q14,B!E5+1,B!E5)","v":{"$error":"#VALUE!"}},null,null,null,null,"Bezugsbetreuer/in:",{"$f":"Start!K5","v":0},null,null,null,null,null,"2014-04-01",2016,"Fr"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"60/15","2014-05-01",2017,"Sa"]
[null,"FLS laut Bescheid:",{"$f":"Start!C7","v":0},null,null,null,"Bewilligungszeitraum",null,null,null,null,null,null,null,null,"48/12","2014-06-01",2018,"So"]
[null,null,null,null,null,null,"von",null,"bis",null,null,"rechnerische Tage:",null,null,null,null,"2014-07-01"]
["Fachleistungsstunde bitte wählen",null,null,null,{"$f":"Start!E9","v":"60/15"},null,{"$f":"Start!G9","v":"00:00:00"},null,{"$f":"Start!I9","v":"00:00:00"},null,null,{"$f":"I9-G9+1","v":1},null,null,null,null,"2014-08-01"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-09-01"]
["Wöchentlich bewilligte\ndirekte Betreuung:",null,null,null,null,null,{"$f":"I12/60","v":0},"Std.",{"$f":"IF(E9=\"60/15\",C7*60,C7*48)","v":0},"Minuten","Einsatzpauschalen laut Vergütungsvereinbarung",null,null,null,null,null,"2014-10-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-11-01"]
["Zeit-Pool  insgesamt                                     -  direkte Betreuung:",null,null,null,{"$f":"ROUND(IF(E9=\"60/15\",I14/60,I14/48),2)","v":0},"FLS",{"$f":"ROUND(G12/7*L9,2)","v":0},"Std.",{"$f":"G14*60","v":0},"Minuten","Pauschale A",{"$f":"Start!L14","v":0},null,null,null,null,"2014-12-01"]
[]
["Bisher geleistete Zeit     (inkl. Abrechnungsmonat):",null,null,null,{"$f":"ROUND(IF(E9=\"60/15\",I16/60,I16/48),2)","v":0},"FLS",{"$f":"ROUND(I16/60,2)","v":0},"Std.",{"$f":"D57+(B!I14-B!I20)","v":0},"Minuten","Pauschale B",{"$f":"Start!L16","v":0}]
[]
["ggf. Veränderungen\n(+ / -):",null,null,null,null,"FLS","(z. B. Abzüge wg. Krankenhausaufenthalten, Zuschläge wg. akuten Krisen)",null,null,null,"Pauschale C",{"$f":"Start!L18","v":0}]
[]
["Verbleibende FLS                         - direkte Betreuung:",null,null,null,{"$f":"E14-E16+E18","v":0},"FLS",{"$f":"ROUND(I20/60,2)","v":0},"Std.",{"$f":"IF(E9=\"60/15\",E20*60,E20*48)","v":0},"Minuten","Vergütung je FLS",{"$f":"Start!L20","v":0}]
[]
["Zeit",null,"direkte Betreuung",null,null,"EP","Art des Kontaktes",null,null,null,"Bemerkungen"]
["Tag","Datum","von","bis","Min"]
[null,null,null,null,{"$f":"IF(OR(C24=\"\",D24=\"\"),\"\",MOD(D24-C24,1)*24*60)","v":""}]
[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,""]
[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,""]
[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,""]
[null,null,null,null,""]
[null,null,null,null,""]
[]
[]
[null,null,null,null,null,null,null,"Rechnungsbetrag"]
[null,"Summe (Min)",null,{"$f":"SUM(E24:E53)","v":0}]
[null,null,"FLS",{"$f":"ROUND(IF(E9=\"60/15\",D57/75,D57/60),2)","v":0},null,null,null,{"$f":"D58*L20","v":0},null,"FLS"]
[null,null,null,null,null,null,null,{"$f":"D60*L14+D62*L16+D64*L18","v":0},null,"Einsatzpauschalen"]
[null,null,"Anzahl Einsatzpauschale A",{"$f":"COUNTIFS(F24:F53,\"A\")","v":0},null,null,null,{"$f":"SUM(H58:H59)","v":0},null,"Summe"]
[]
[null,null,"Anzahl Einsatzpauschale B",{"$f":"COUNTIFS(F24:F53,\"B\")","v":0}]
[]
[null,null,"Anzahl Einsatzpauschale C",{"$f":"COUNTIFS(F24:F53,\"c\")","v":0}]
[]
[null,null,null,null,null,null,null,"_____________________________",null,null,"________________________________"]
[]
[null,null,null,null,null,null,null,"Datum, Unterschrift Klient/in ",null,null,"Datum, Unterschrift Mitarbeiter/in"]

{"sheet":"D","index":4,"n_rows":68,"n_cols":20,"rows_kept":68,"cut":false,"hidden":false,"merged":[[44,6,44,9],[44,10,44,11],[45,6,45,9],[45,10,45,11],[46,6,46,9],[46,10,46,11],[52,6,52,9],[52,10,52,11],[47,6,47,9],[47,10,47,11],[48,6,48,9],[48,10,48,11],[49,6,49,9],[49,10,49,11],[50,6,50,9],[50,10,50,11],[51,6,51,9],[51,10,51,11],[36,6,36,9],[36,10,36,11],[37,6,37,9],[37,10,37,11],[43,6,43,9],[43,10,43,11],[38,6,38,9],[38,10,38,11],[39,6,39,9],[39,10,39,11],[40,6,40,9],[40,10,40,11],[41,6,41,9],[41,10,41,11],[42,6,42,9],[42,10,42,11],[32,10,32,11],[23,6,23,9],[23,10,23,11],[35,6,35,9],[35,10,35,11],[24,6,24,9],[25,6,25,9],[26,6,26,9],[27,6,27,9],[28,6,28,9],[24,10,24,11],[25,10,25,11],[26,10,26,11],[27,10,27,11],[28,10,28,11],[7,6,7,7],[7,8,7,9],[8,6,8,7],[8,8,8,9],[11,10,11,11],[0,6,0,9],[2,10,2,11],[6,6,6,9],[4,2,4,3],[4,4,4,5],[2,2,2,5],[4,10,4,11],[11,0,11,2],[13,0,13,2],[15,0,15,2],[19,0,19,2],[21,0,21,1],[21,2,21,4],[17,0,17,2],[17,6,17,9],[56,1,56,2],[21,5,22,5],[21,6,22,9],[21,10,22,11],[29,10,29,11],[29,6,29,9],[33,6,33,9],[33,10,33,11],[34,6,34,9],[34,10,34,11],[30,6,30,9],[30,10,30,11],[31,6,31,9],[31,10,31,11],[32,6,32,9]]}
[null,null,null,null,null,"Einrichtung:",{"$f":"Start!G1","v":0},null,null,null,null,null,null,null,null,null,"Monat","Jahr","Mo","A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-01-01",2013,"Di","B"]
[null,"Klient/in:",{"$f":"Start!C3","v":0},null,null,null,null,null,null,"Wohnort:",{"$f":"Start!K3","v":0},null,null,null,null,null,"2014-02-01",2014,"Mi","C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-03-01",2015,"Do"]
[null,"Monat/Jahr: ",{"$f":"DATE(YEAR('C'!C5),MONTH('C'!C5)+1,DAY('C'!C5))","v":{"$error":"#VALUE!"}},null,{"$f":"IF('C'!C5=D!Q14,'C'!E5+1,'C'!E5)","v":{"$error":"#VALUE!"}},null,null,null,null,"Bezugsbetreuer/in:",{"$f":"Start!K5","v":0},null,null,null,null,null,"2014-04-01",2016,"Fr"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"60/15","2014-05-01",2017,"Sa"]
[null,"FLS laut Bescheid:",{"$f":"Start!C7","v":0},null,null,null,"Bewilligungszeitraum",null,null,null,null,null,null,null,null,"48/12","2014-06-01",2018,"So"]
[null,null,null,null,null,null,"von",null,"bis",null,null,"rechnerische Tage:",null,null,null,null,"2014-07-01"]
["Fachleistungsstunde bitte wählen",null,null,null,{"$f":"Start!E9","v":"60/15"},null,{"$f":"Start!G9","v":"00:00:00"},null,{"$f":"Start!I9","v":"00:00:00"},null,null,{"$f":"I9-G9+1","v":1},null,null,null,null,"2014-08-01"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-09-01"]
["Wöchentlich bewilligte\ndirekte Betreuung:",null,null,null,null,null,{"$f":"I12/60","v":0},"Std.",{"$f":"IF(E9=\"60/15\",C7*60,C7*48)","v":0},"Minuten","Einsatzpauschalen laut Vergütungsvereinbarung",null,null,null,null,null,"2014-10-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-11-01"]
["Zeit-Pool  insgesamt                                     -  direkte Betreuung:",null,null,null,{"$f":"ROUND(IF(E9=\"60/15\",I14/60,I14/48),2)","v":0},"FLS",{"$f":"ROUND(G12/7*L9,2)","v":0},"Std.",{"$f":"G14*60","v":0},"Minuten","Pauschale A",{"$f":"Start!L14","v":0},null,null,null,null,"2014-12-01"]
[]
["Bisher geleistete Zeit     (inkl. Abrechnungsmonat):",null,null,null,{"$f":"ROUND(IF(E9=\"60/15\",I16/60,I16/48),2)","v":0},"FLS",{"$f":"ROUND(I16/60,2)","v":0},"Std.",{"$f":"D57+('C'!I14-'C'!I20)","v":0},"Minuten","Pauschale B",{"$f":"Start!L16","v":0}]
[]
["ggf. Veränderungen\n(+ / -):",null,null,null,null,"FLS","(z. B. Abzüge wg. Krankenhausaufenthalten, Zuschläge wg. akuten Krisen)",null,null,null,"Pauschale C",{"$f":"Start!L18","v":0}]
[]
["Verbleibende FLS                         - direkte Betreuung:",null,null,null,{"$f":"E14-E16+E18","v":0},"FLS",{"$f":"ROUND(I20/60,2)","v":0},"Std.",{"$f":"IF(E9=\"60/15\",E20*60,E20*48)","v":0},"Minuten","Vergütung je FLS",{"$f":"Start!L20","v":0}]
[]
["Zeit",null,"direkte Betreuung",null,null,"EP","Art des Kontaktes",null,null,null,"Bemerkungen"]
["Tag","Datum","von","bis","Min"]
[null,null,null,null,{"$f":"IF(OR(C24=\"\",D24=\"\"),\"\",MOD(D24-C24,1)*24*60)","v":""}]
[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,""]
[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,""]
[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,""]
[null,null,null,null,""]
[null,null,null,null,""]
[]
[]
[null,null,null,null,null,null,null,"Rechnungsbetrag"]
[null,"Summe (Min)",null,{"$f":"SUM(E24:E53)","v":0}]
[null,null,"FLS",{"$f":"ROUND(IF(E9=\"60/15\",D57/75,D57/60),2)","v":0},null,null,null,{"$f":"D58*L20","v":0},null,"FLS"]
[null,null,null,null,null,null,null,{"$f":"D60*L14+D62*L16+D64*L18","v":0},null,"Einsatzpauschalen"]
[null,null,"Anzahl Einsatzpauschale A",{"$f":"COUNTIFS(F24:F53,\"A\")","v":0},null,null,null,{"$f":"SUM(H58:H59)","v":0},null,"Summe"]
[]
[null,null,"Anzahl Einsatzpauschale B",{"$f":"COUNTIFS(F24:F53,\"B\")","v":0}]
[]
[null,null,"Anzahl Einsatzpauschale C",{"$f":"COUNTIFS(F24:F53,\"c\")","v":0}]
[]
[null,null,null,null,null,null,null,"_____________________________",null,null,"________________________________"]
[]
[null,null,null,null,null,null,null,"Datum, Unterschrift Klient/in ",null,null,"Datum, Unterschrift Mitarbeiter/in"]

{"sheet":"E","index":5,"n_rows":68,"n_cols":20,"rows_kept":68,"cut":false,"hidden":false,"merged":[[44,6,44,9],[44,10,44,11],[45,6,45,9],[45,10,45,11],[46,6,46,9],[46,10,46,11],[52,6,52,9],[52,10,52,11],[47,6,47,9],[47,10,47,11],[48,6,48,9],[48,10,48,11],[49,6,49,9],[49,10,49,11],[50,6,50,9],[50,10,50,11],[51,6,51,9],[51,10,51,11],[36,6,36,9],[36,10,36,11],[37,6,37,9],[37,10,37,11],[43,6,43,9],[43,10,43,11],[38,6,38,9],[38,10,38,11],[39,6,39,9],[39,10,39,11],[40,6,40,9],[40,10,40,11],[41,6,41,9],[41,10,41,11],[42,6,42,9],[42,10,42,11],[32,10,32,11],[23,6,23,9],[23,10,23,11],[35,6,35,9],[35,10,35,11],[24,6,24,9],[25,6,25,9],[26,6,26,9],[27,6,27,9],[28,6,28,9],[24,10,24,11],[25,10,25,11],[26,10,26,11],[27,10,27,11],[28,10,28,11],[7,6,7,7],[7,8,7,9],[8,6,8,7],[8,8,8,9],[11,10,11,11],[0,6,0,9],[2,10,2,11],[6,6,6,9],[4,2,4,3],[4,4,4,5],[2,2,2,5],[4,10,4,11],[11,0,11,2],[13,0,13,2],[15,0,15,2],[19,0,19,2],[21,0,21,1],[21,2,21,4],[17,0,17,2],[17,6,17,9],[56,1,56,2],[21,5,22,5],[21,6,22,9],[21,10,22,11],[29,10,29,11],[29,6,29,9],[33,6,33,9],[33,10,33,11],[34,6,34,9],[34,10,34,11],[30,6,30,9],[30,10,30,11],[31,6,31,9],[31,10,31,11],[32,6,32,9]]}
[null,null,null,null,null,"Einrichtung:",{"$f":"Start!G1","v":0},null,null,null,null,null,null,null,null,null,"Monat","Jahr","Mo","A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-01-01",2013,"Di","B"]
[null,"Klient/in:",{"$f":"Start!C3","v":0},null,null,null,null,null,null,"Wohnort:",{"$f":"Start!K3","v":0},null,null,null,null,null,"2014-02-01",2014,"Mi","C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-03-01",2015,"Do"]
[null,"Monat/Jahr: ",{"$f":"DATE(YEAR(D!C5),MONTH(D!C5)+1,DAY(D!C5))","v":{"$error":"#VALUE!"}},null,{"$f":"IF(D!C5=E!Q14,D!E5+1,D!E5)","v":{"$error":"#VALUE!"}},null,null,null,null,"Bezugsbetreuer/in:",{"$f":"Start!K5","v":0},null,null,null,null,null,"2014-04-01",2016,"Fr"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"60/15","2014-05-01",2017,"Sa"]
[null,"FLS laut Bescheid:",{"$f":"Start!C7","v":0},null,null,null,"Bewilligungszeitraum",null,null,null,null,null,null,null,null,"48/12","2014-06-01",2018,"So"]
[null,null,null,null,null,null,"von",null,"bis",null,null,"rechnerische Tage:",null,null,null,null,"2014-07-01"]
["Fachleistungsstunde bitte wählen",null,null,null,{"$f":"Start!E9","v":"60/15"},null,{"$f":"Start!G9","v":"00:00:00"},null,{"$f":"Start!I9","v":"00:00:00"},null,null,{"$f":"I9-G9+1","v":1},null,null,null,null,"2014-08-01"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-09-01"]
["Wöchentlich bewilligte\ndirekte Betreuung:",null,null,null,null,null,{"$f":"I12/60","v":0},"Std.",{"$f":"IF(E9=\"60/15\",C7*60,C7*48)","v":0},"Minuten","Einsatzpauschalen laut Vergütungsvereinbarung",null,null,null,null,null,"2014-10-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-11-01"]
["Zeit-Pool  insgesamt                                     -  direkte Betreuung:",null,null,null,{"$f":"ROUND(IF(E9=\"60/15\",I14/60,I14/48),2)","v":0},"FLS",{"$f":"ROUND(G12/7*L9,2)","v":0},"Std.",{"$f":"G14*60","v":0},"Minuten","Pauschale A",{"$f":"Start!L14","v":0},null,null,null,null,"2014-12-01"]
[]
["Bisher geleistete Zeit     (inkl. Abrechnungsmonat):",null,null,null,{"$f":"ROUND(IF(E9=\"60/15\",I16/60,I16/48),2)","v":0},"FLS",{"$f":"ROUND(I16/60,2)","v":0},"Std.",{"$f":"D57+(D!I14-D!I20)","v":0},"Minuten","Pauschale B",{"$f":"Start!L16","v":0}]
[]
["ggf. Veränderungen\n(+ / -):",null,null,null,null,"FLS","(z. B. Abzüge wg. Krankenhausaufenthalten, Zuschläge wg. akuten Krisen)",null,null,null,"Pauschale C",{"$f":"Start!L18","v":0}]
[]
["Verbleibende FLS                         - direkte Betreuung:",null,null,null,{"$f":"E14-E16+E18","v":0},"FLS",{"$f":"ROUND(I20/60,2)","v":0},"Std.",{"$f":"IF(E9=\"60/15\",E20*60,E20*48)","v":0},"Minuten","Vergütung je FLS",{"$f":"Start!L20","v":0}]
[]
["Zeit",null,"direkte Betreuung",null,null,"EP","Art des Kontaktes",null,null,null,"Bemerkungen"]
["Tag","Datum","von","bis","Min"]
[null,null,null,null,{"$f":"IF(OR(C24=\"\",D24=\"\"),\"\",MOD(D24-C24,1)*24*60)","v":""}]
[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,""]
[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,""]
[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,""]
[null,null,null,null,""]
[null,null,null,null,""]
[]
[]
[null,null,null,null,null,null,null,"Rechnungsbetrag"]
[null,"Summe (Min)",null,{"$f":"SUM(E24:E53)","v":0}]
[null,null,"FLS",{"$f":"ROUND(IF(E9=\"60/15\",D57/75,D57/60),2)","v":0},null,null,null,{"$f":"D58*L20","v":0},null,"FLS"]
[null,null,null,null,null,null,null,{"$f":"D60*L14+D62*L16+D64*L18","v":0},null,"Einsatzpauschalen"]
[null,null,"Anzahl Einsatzpauschale A",{"$f":"COUNTIFS(F24:F53,\"A\")","v":0},null,null,null,{"$f":"SUM(H58:H59)","v":0},null,"Summe"]
[]
[null,null,"Anzahl Einsatzpauschale B",{"$f":"COUNTIFS(F24:F53,\"B\")","v":0}]
[]
[null,null,"Anzahl Einsatzpauschale C",{"$f":"COUNTIFS(F24:F53,\"c\")","v":0}]
[]
[null,null,null,null,null,null,null,"_____________________________",null,null,"________________________________"]
[]
[null,null,null,null,null,null,null,"Datum, Unterschrift Klient/in ",null,null,"Datum, Unterschrift Mitarbeiter/in"]

{"sheet":"F","index":6,"n_rows":68,"n_cols":20,"rows_kept":68,"cut":false,"hidden":false,"merged":[[44,6,44,9],[44,10,44,11],[45,6,45,9],[45,10,45,11],[46,6,46,9],[46,10,46,11],[52,6,52,9],[52,10,52,11],[47,6,47,9],[47,10,47,11],[48,6,48,9],[48,10,48,11],[49,6,49,9],[49,10,49,11],[50,6,50,9],[50,10,50,11],[51,6,51,9],[51,10,51,11],[36,6,36,9],[36,10,36,11],[37,6,37,9],[37,10,37,11],[43,6,43,9],[43,10,43,11],[38,6,38,9],[38,10,38,11],[39,6,39,9],[39,10,39,11],[40,6,40,9],[40,10,40,11],[41,6,41,9],[41,10,41,11],[42,6,42,9],[42,10,42,11],[32,10,32,11],[23,6,23,9],[23,10,23,11],[35,6,35,9],[35,10,35,11],[24,6,24,9],[25,6,25,9],[26,6,26,9],[27,6,27,9],[28,6,28,9],[24,10,24,11],[25,10,25,11],[26,10,26,11],[27,10,27,11],[28,10,28,11],[7,6,7,7],[7,8,7,9],[8,6,8,7],[8,8,8,9],[11,10,11,11],[0,6,0,9],[2,10,2,11],[6,6,6,9],[4,2,4,3],[4,4,4,5],[2,2,2,5],[4,10,4,11],[11,0,11,2],[13,0,13,2],[15,0,15,2],[19,0,19,2],[21,0,21,1],[21,2,21,4],[17,0,17,2],[17,6,17,9],[56,1,56,2],[21,5,22,5],[21,6,22,9],[21,10,22,11],[29,10,29,11],[29,6,29,9],[33,6,33,9],[33,10,33,11],[34,6,34,9],[34,10,34,11],[30,6,30,9],[30,10,30,11],[31,6,31,9],[31,10,31,11],[32,6,32,9]]}
[null,null,null,null,null,"Einrichtung:",{"$f":"Start!G1","v":0},null,null,null,null,null,null,null,null,null,"Monat","Jahr","Mo","A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-01-01",2013,"Di","B"]
[null,"Klient/in:",{"$f":"Start!C3","v":0},null,null,null,null,null,null,"Wohnort:",{"$f":"Start!K3","v":0},null,null,null,null,null,"2014-02-01",2014,"Mi","C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-03-01",2015,"Do"]
[null,"Monat/Jahr: ",{"$f":"DATE(YEAR(E!C5),MONTH(E!C5)+1,DAY(E!C5))","v":{"$error":"#VALUE!"}},null,{"$f":"IF(E!C5=F!Q14,E!E5+1,E!E5)","v":{"$error":"#VALUE!"}},null,null,null,null,"Bezugsbetreuer/in:",{"$f":"Start!K5","v":0},null,null,null,null,null,"2014-04-01",2016,"Fr"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"60/15","2014-05-01",2017,"Sa"]
[null,"FLS laut Bescheid:",{"$f":"Start!C7","v":0},null,null,null,"Bewilligungszeitraum",null,null,null,null,null,null,null,null,"48/12","2014-06-01",2018,"So"]
[null,null,null,null,null,null,"von",null,"bis",null,null,"rechnerische Tage:",null,null,null,null,"2014-07-01"]
["Fachleistungsstunde bitte wählen",null,null,null,{"$f":"Start!E9","v":"60/15"},null,{"$f":"Start!G9","v":"00:00:00"},null,{"$f":"Start!I9","v":"00:00:00"},null,null,{"$f":"I9-G9+1","v":1},null,null,null,null,"2014-08-01"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-09-01"]
["Wöchentlich bewilligte\ndirekte Betreuung:",null,null,null,null,null,{"$f":"I12/60","v":0},"Std.",{"$f":"IF(E9=\"60/15\",C7*60,C7*48)","v":0},"Minuten","Einsatzpauschalen laut Vergütungsvereinbarung",null,null,null,null,null,"2014-10-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-11-01"]
["Zeit-Pool  insgesamt                                     -  direkte Betreuung:",null,null,null,{"$f":"ROUND(IF(E9=\"60/15\",I14/60,I14/48),2)","v":0},"FLS",{"$f":"ROUND(G12/7*L9,2)","v":0},"Std.",{"$f":"G14*60","v":0},"Minuten","Pauschale A",{"$f":"Start!L14","v":0},null,null,null,null,"2014-12-01"]
[]
["Bisher geleistete Zeit     (inkl. Abrechnungsmonat):",null,null,null,{"$f":"ROUND(IF(E9=\"60/15\",I16/60,I16/48),2)","v":0},"FLS",{"$f":"ROUND(I16/60,2)","v":0},"Std.",{"$f":"D57+(E!I14-E!I20)","v":0},"Minuten","Pauschale B",{"$f":"Start!L16","v":0}]
[]
["ggf. Veränderungen\n(+ / -):",null,null,null,null,"FLS","(z. B. Abzüge wg. Krankenhausaufenthalten, Zuschläge wg. akuten Krisen)",null,null,null,"Pauschale C",{"$f":"Start!L18","v":0}]
[]
["Verbleibende FLS                         - direkte Betreuung:",null,null,null,{"$f":"E14-E16+E18","v":0},"FLS",{"$f":"ROUND(I20/60,2)","v":0},"Std.",{"$f":"IF(E9=\"60/15\",E20*60,E20*48)","v":0},"Minuten","Vergütung je FLS",{"$f":"Start!L20","v":0}]
[]
["Zeit",null,"direkte Betreuung",null,null,"EP","Art des Kontaktes",null,null,null,"Bemerkungen"]
["Tag","Datum","von","bis","Min"]
[null,null,null,null,{"$f":"IF(OR(C24=\"\",D24=\"\"),\"\",MOD(D24-C24,1)*24*60)","v":""}]
[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,""]
[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,""]
[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,""]
[null,null,null,null,""]
[null,null,null,null,""]
[]
[]
[null,null,null,null,null,null,null,"Rechnungsbetrag"]
[null,"Summe (Min)",null,{"$f":"SUM(E24:E53)","v":0}]
[null,null,"FLS",{"$f":"ROUND(IF(E9=\"60/15\",D57/75,D57/60),2)","v":0},null,null,null,{"$f":"D58*L20","v":0},null,"FLS"]
[null,null,null,null,null,null,null,{"$f":"D60*L14+D62*L16+D64*L18","v":0},null,"Einsatzpauschalen"]
[null,null,"Anzahl Einsatzpauschale A",{"$f":"COUNTIFS(F24:F53,\"A\")","v":0},null,null,null,{"$f":"SUM(H58:H59)","v":0},null,"Summe"]
[]
[null,null,"Anzahl Einsatzpauschale B",{"$f":"COUNTIFS(F24:F53,\"B\")","v":0}]
[]
[null,null,"Anzahl Einsatzpauschale C",{"$f":"COUNTIFS(F24:F53,\"c\")","v":0}]
[]
[null,null,null,null,null,null,null,"_____________________________",null,null,"________________________________"]
[]
[null,null,null,null,null,null,null,"Datum, Unterschrift Klient/in ",null,null,"Datum, Unterschrift Mitarbeiter/in"]

{"sheet":"G","index":7,"n_rows":68,"n_cols":20,"rows_kept":68,"cut":false,"hidden":false,"merged":[[44,6,44,9],[44,10,44,11],[45,6,45,9],[45,10,45,11],[46,6,46,9],[46,10,46,11],[52,6,52,9],[52,10,52,11],[47,6,47,9],[47,10,47,11],[48,6,48,9],[48,10,48,11],[49,6,49,9],[49,10,49,11],[50,6,50,9],[50,10,50,11],[51,6,51,9],[51,10,51,11],[36,6,36,9],[36,10,36,11],[37,6,37,9],[37,10,37,11],[43,6,43,9],[43,10,43,11],[38,6,38,9],[38,10,38,11],[39,6,39,9],[39,10,39,11],[40,6,40,9],[40,10,40,11],[41,6,41,9],[41,10,41,11],[42,6,42,9],[42,10,42,11],[32,10,32,11],[23,6,23,9],[23,10,23,11],[35,6,35,9],[35,10,35,11],[24,6,24,9],[25,6,25,9],[26,6,26,9],[27,6,27,9],[28,6,28,9],[24,10,24,11],[25,10,25,11],[26,10,26,11],[27,10,27,11],[28,10,28,11],[7,6,7,7],[7,8,7,9],[8,6,8,7],[8,8,8,9],[11,10,11,11],[0,6,0,9],[2,10,2,11],[6,6,6,9],[4,2,4,3],[4,4,4,5],[2,2,2,5],[4,10,4,11],[11,0,11,2],[13,0,13,2],[15,0,15,2],[19,0,19,2],[21,0,21,1],[21,2,21,4],[17,0,17,2],[17,6,17,9],[56,1,56,2],[21,5,22,5],[21,6,22,9],[21,10,22,11],[29,10,29,11],[29,6,29,9],[33,6,33,9],[33,10,33,11],[34,6,34,9],[34,10,34,11],[30,6,30,9],[30,10,30,11],[31,6,31,9],[31,10,31,11],[32,6,32,9]]}
[null,null,null,null,null,"Einrichtung:",{"$f":"Start!G1","v":0},null,null,null,null,null,null,null,null,null,"Monat","Jahr","Mo","A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-01-01",2013,"Di","B"]
[null,"Klient/in:",{"$f":"Start!C3","v":0},null,null,null,null,null,null,"Wohnort:",{"$f":"Start!K3","v":0},null,null,null,null,null,"2014-02-01",2014,"Mi","C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-03-01",2015,"Do"]
[null,"Monat/Jahr: ",{"$f":"DATE(YEAR(F!C5),MONTH(F!C5)+1,DAY(F!C5))","v":{"$error":"#VALUE!"}},null,{"$f":"IF(F!C5=G!Q14,F!E5+1,F!E5)","v":{"$error":"#VALUE!"}},null,null,null,null,"Bezugsbetreuer/in:",{"$f":"Start!K5","v":0},null,null,null,null,null,"2014-04-01",2016,"Fr"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"60/15","2014-05-01",2017,"Sa"]
[null,"FLS laut Bescheid:",{"$f":"Start!C7","v":0},null,null,null,"Bewilligungszeitraum",null,null,null,null,null,null,null,null,"48/12","2014-06-01",2018,"So"]
[null,null,null,null,null,null,"von",null,"bis",null,null,"rechnerische Tage:",null,null,null,null,"2014-07-01"]
["Fachleistungsstunde bitte wählen",null,null,null,{"$f":"Start!E9","v":"60/15"},null,{"$f":"Start!G9","v":"00:00:00"},null,{"$f":"Start!I9","v":"00:00:00"},null,null,{"$f":"I9-G9+1","v":1},null,null,null,null,"2014-08-01"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-09-01"]
["Wöchentlich bewilligte\ndirekte Betreuung:",null,null,null,null,null,{"$f":"I12/60","v":0},"Std.",{"$f":"IF(E9=\"60/15\",C7*60,C7*48)","v":0},"Minuten","Einsatzpauschalen laut Vergütungsvereinbarung",null,null,null,null,null,"2014-10-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-11-01"]
["Zeit-Pool  insgesamt                                     -  direkte Betreuung:",null,null,null,{"$f":"ROUND(IF(E9=\"60/15\",I14/60,I14/48),2)","v":0},"FLS",{"$f":"ROUND(G12/7*L9,2)","v":0},"Std.",{"$f":"G14*60","v":0},"Minuten","Pauschale A",{"$f":"Start!L14","v":0},null,null,null,null,"2014-12-01"]
[]
["Bisher geleistete Zeit     (inkl. Abrechnungsmonat):",null,null,null,{"$f":"ROUND(IF(E9=\"60/15\",I16/60,I16/48),2)","v":0},"FLS",{"$f":"ROUND(I16/60,2)","v":0},"Std.",{"$f":"D57+(F!I14-F!I20)","v":0},"Minuten","Pauschale B",{"$f":"Start!L16","v":0}]
[]
["ggf. Veränderungen\n(+ / -):",null,null,null,null,"FLS","(z. B. Abzüge wg. Krankenhausaufenthalten, Zuschläge wg. akuten Krisen)",null,null,null,"Pauschale C",{"$f":"Start!L18","v":0}]
[]
["Verbleibende FLS                         - direkte Betreuung:",null,null,null,{"$f":"E14-E16+E18","v":0},"FLS",{"$f":"ROUND(I20/60,2)","v":0},"Std.",{"$f":"IF(E9=\"60/15\",E20*60,E20*48)","v":0},"Minuten","Vergütung je FLS",{"$f":"Start!L20","v":0}]
[]
["Zeit",null,"direkte Betreuung",null,null,"EP","Art des Kontaktes",null,null,null,"Bemerkungen"]
["Tag","Datum","von","bis","Min"]
[null,null,null,null,{"$f":"IF(OR(C24=\"\",D24=\"\"),\"\",MOD(D24-C24,1)*24*60)","v":""}]
[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,""]
[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,""]
[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,""]
[null,null,null,null,""]
[null,null,null,null,""]
[]
[]
[null,null,null,null,null,null,null,"Rechnungsbetrag"]
[null,"Summe (Min)",null,{"$f":"SUM(E24:E53)","v":0}]
[null,null,"FLS",{"$f":"ROUND(IF(E9=\"60/15\",D57/75,D57/60),2)","v":0},null,null,null,{"$f":"D58*L20","v":0},null,"FLS"]
[null,null,null,null,null,null,null,{"$f":"D60*L14+D62*L16+D64*L18","v":0},null,"Einsatzpauschalen"]
[null,null,"Anzahl Einsatzpauschale A",{"$f":"COUNTIFS(F24:F53,\"A\")","v":0},null,null,null,{"$f":"SUM(H58:H59)","v":0},null,"Summe"]
[]
[null,null,"Anzahl Einsatzpauschale B",{"$f":"COUNTIFS(F24:F53,\"B\")","v":0}]
[]
[null,null,"Anzahl Einsatzpauschale C",{"$f":"COUNTIFS(F24:F53,\"c\")","v":0}]
[]
[null,null,null,null,null,null,null,"_____________________________",null,null,"________________________________"]
[]
[null,null,null,null,null,null,null,"Datum, Unterschrift Klient/in ",null,null,"Datum, Unterschrift Mitarbeiter/in"]

{"sheet":"H","index":8,"n_rows":68,"n_cols":20,"rows_kept":68,"cut":false,"hidden":false,"merged":[[44,6,44,9],[44,10,44,11],[45,6,45,9],[45,10,45,11],[46,6,46,9],[46,10,46,11],[52,6,52,9],[52,10,52,11],[47,6,47,9],[47,10,47,11],[48,6,48,9],[48,10,48,11],[49,6,49,9],[49,10,49,11],[50,6,50,9],[50,10,50,11],[51,6,51,9],[51,10,51,11],[36,6,36,9],[36,10,36,11],[37,6,37,9],[37,10,37,11],[43,6,43,9],[43,10,43,11],[38,6,38,9],[38,10,38,11],[39,6,39,9],[39,10,39,11],[40,6,40,9],[40,10,40,11],[41,6,41,9],[41,10,41,11],[42,6,42,9],[42,10,42,11],[32,10,32,11],[23,6,23,9],[23,10,23,11],[35,6,35,9],[35,10,35,11],[24,6,24,9],[25,6,25,9],[26,6,26,9],[27,6,27,9],[28,6,28,9],[24,10,24,11],[25,10,25,11],[26,10,26,11],[27,10,27,11],[28,10,28,11],[7,6,7,7],[7,8,7,9],[8,6,8,7],[8,8,8,9],[11,10,11,11],[0,6,0,9],[2,10,2,11],[6,6,6,9],[4,2,4,3],[4,4,4,5],[2,2,2,5],[4,10,4,11],[11,0,11,2],[13,0,13,2],[15,0,15,2],[19,0,19,2],[21,0,21,1],[21,2,21,4],[17,0,17,2],[17,6,17,9],[56,1,56,2],[21,5,22,5],[21,6,22,9],[21,10,22,11],[29,10,29,11],[29,6,29,9],[33,6,33,9],[33,10,33,11],[34,6,34,9],[34,10,34,11],[30,6,30,9],[30,10,30,11],[31,6,31,9],[31,10,31,11],[32,6,32,9]]}
[null,null,null,null,null,"Einrichtung:",{"$f":"Start!G1","v":0},null,null,null,null,null,null,null,null,null,"Monat","Jahr","Mo","A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-01-01",2013,"Di","B"]
[null,"Klient/in:",{"$f":"Start!C3","v":0},null,null,null,null,null,null,"Wohnort:",{"$f":"Start!K3","v":0},null,null,null,null,null,"2014-02-01",2014,"Mi","C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-03-01",2015,"Do"]
[null,"Monat/Jahr: ",{"$f":"DATE(YEAR(G!C5),MONTH(G!C5)+1,DAY(G!C5))","v":{"$error":"#VALUE!"}},null,{"$f":"IF(G!C5=H!Q14,G!E5+1,G!E5)","v":{"$error":"#VALUE!"}},null,null,null,null,"Bezugsbetreuer/in:",{"$f":"Start!K5","v":0},null,null,null,null,null,"2014-04-01",2016,"Fr"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"60/15","2014-05-01",2017,"Sa"]
[null,"FLS laut Bescheid:",{"$f":"Start!C7","v":0},null,null,null,"Bewilligungszeitraum",null,null,null,null,null,null,null,null,"48/12","2014-06-01",2018,"So"]
[null,null,null,null,null,null,"von",null,"bis",null,null,"rechnerische Tage:",null,null,null,null,"2014-07-01"]
["Fachleistungsstunde bitte wählen",null,null,null,{"$f":"Start!E9","v":"60/15"},null,{"$f":"Start!G9","v":"00:00:00"},null,{"$f":"Start!I9","v":"00:00:00"},null,null,{"$f":"I9-G9+1","v":1},null,null,null,null,"2014-08-01"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-09-01"]
["Wöchentlich bewilligte\ndirekte Betreuung:",null,null,null,null,null,{"$f":"I12/60","v":0},"Std.",{"$f":"IF(E9=\"60/15\",C7*60,C7*48)","v":0},"Minuten","Einsatzpauschalen laut Vergütungsvereinbarung",null,null,null,null,null,"2014-10-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-11-01"]
["Zeit-Pool  insgesamt                                     -  direkte Betreuung:",null,null,null,{"$f":"ROUND(IF(E9=\"60/15\",I14/60,I14/48),2)","v":0},"FLS",{"$f":"ROUND(G12/7*L9,2)","v":0},"Std.",{"$f":"G14*60","v":0},"Minuten","Pauschale A",{"$f":"Start!L14","v":0},null,null,null,null,"2014-12-01"]
[]
["Bisher geleistete Zeit     (inkl. Abrechnungsmonat):",null,null,null,{"$f":"ROUND(IF(E9=\"60/15\",I16/60,I16/48),2)","v":0},"FLS",{"$f":"ROUND(I16/60,2)","v":0},"Std.",{"$f":"D57+(G!I14-G!I20)","v":0},"Minuten","Pauschale B",{"$f":"Start!L16","v":0}]
[]
["ggf. Veränderungen\n(+ / -):",null,null,null,null,"FLS","(z. B. Abzüge wg. Krankenhausaufenthalten, Zuschläge wg. akuten Krisen)",null,null,null,"Pauschale C",{"$f":"Start!L18","v":0}]
[]
["Verbleibende FLS                         - direkte Betreuung:",null,null,null,{"$f":"E14-E16+E18","v":0},"FLS",{"$f":"ROUND(I20/60,2)","v":0},"Std.",{"$f":"IF(E9=\"60/15\",E20*60,E20*48)","v":0},"Minuten","Vergütung je FLS",{"$f":"Start!L20","v":0}]
[]
["Zeit",null,"direkte Betreuung",null,null,"EP","Art des Kontaktes",null,null,null,"Bemerkungen"]
["Tag","Datum","von","bis","Min"]
[null,null,null,null,{"$f":"IF(OR(C24=\"\",D24=\"\"),\"\",MOD(D24-C24,1)*24*60)","v":""}]
[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,""]
[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,""]
[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,""]
[null,null,null,null,""]
[null,null,null,null,""]
[]
[]
[null,null,null,null,null,null,null,"Rechnungsbetrag"]
[null,"Summe (Min)",null,{"$f":"SUM(E24:E53)","v":0}]
[null,null,"FLS",{"$f":"ROUND(IF(E9=\"60/15\",D57/75,D57/60),2)","v":0},null,null,null,{"$f":"D58*L20","v":0},null,"FLS"]
[null,null,null,null,null,null,null,{"$f":"D60*L14+D62*L16+D64*L18","v":0},null,"Einsatzpauschalen"]
[null,null,"Anzahl Einsatzpauschale A",{"$f":"COUNTIFS(F24:F53,\"A\")","v":0},null,null,null,{"$f":"SUM(H58:H59)","v":0},null,"Summe"]
[]
[null,null,"Anzahl Einsatzpauschale B",{"$f":"COUNTIFS(F24:F53,\"B\")","v":0}]
[]
[null,null,"Anzahl Einsatzpauschale C",{"$f":"COUNTIFS(F24:F53,\"c\")","v":0}]
[]
[null,null,null,null,null,null,null,"_____________________________",null,null,"________________________________"]
[]
[null,null,null,null,null,null,null,"Datum, Unterschrift Klient/in ",null,null,"Datum, Unterschrift Mitarbeiter/in"]

{"sheet":"I","index":9,"n_rows":68,"n_cols":20,"rows_kept":68,"cut":false,"hidden":false,"merged":[[44,6,44,9],[44,10,44,11],[45,6,45,9],[45,10,45,11],[46,6,46,9],[46,10,46,11],[52,6,52,9],[52,10,52,11],[47,6,47,9],[47,10,47,11],[48,6,48,9],[48,10,48,11],[49,6,49,9],[49,10,49,11],[50,6,50,9],[50,10,50,11],[51,6,51,9],[51,10,51,11],[36,6,36,9],[36,10,36,11],[37,6,37,9],[37,10,37,11],[43,6,43,9],[43,10,43,11],[38,6,38,9],[38,10,38,11],[39,6,39,9],[39,10,39,11],[40,6,40,9],[40,10,40,11],[41,6,41,9],[41,10,41,11],[42,6,42,9],[42,10,42,11],[32,10,32,11],[23,6,23,9],[23,10,23,11],[35,6,35,9],[35,10,35,11],[24,6,24,9],[25,6,25,9],[26,6,26,9],[27,6,27,9],[28,6,28,9],[24,10,24,11],[25,10,25,11],[26,10,26,11],[27,10,27,11],[28,10,28,11],[7,6,7,7],[7,8,7,9],[8,6,8,7],[8,8,8,9],[11,10,11,11],[0,6,0,9],[2,10,2,11],[6,6,6,9],[4,2,4,3],[4,4,4,5],[2,2,2,5],[4,10,4,11],[11,0,11,2],[13,0,13,2],[15,0,15,2],[19,0,19,2],[21,0,21,1],[21,2,21,4],[17,0,17,2],[17,6,17,9],[56,1,56,2],[21,5,22,5],[21,6,22,9],[21,10,22,11],[29,10,29,11],[29,6,29,9],[33,6,33,9],[33,10,33,11],[34,6,34,9],[34,10,34,11],[30,6,30,9],[30,10,30,11],[31,6,31,9],[31,10,31,11],[32,6,32,9]]}
[null,null,null,null,null,"Einrichtung:",{"$f":"Start!G1","v":0},null,null,null,null,null,null,null,null,null,"Monat","Jahr","Mo","A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-01-01",2013,"Di","B"]
[null,"Klient/in:",{"$f":"Start!C3","v":0},null,null,null,null,null,null,"Wohnort:",{"$f":"Start!K3","v":0},null,null,null,null,null,"2014-02-01",2014,"Mi","C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-03-01",2015,"Do"]
[null,"Monat/Jahr: ",{"$f":"DATE(YEAR(H!C5),MONTH(H!C5)+1,DAY(H!C5))","v":{"$error":"#VALUE!"}},null,{"$f":"IF(H!C5=I!Q14,H!E5+1,H!E5)","v":{"$error":"#VALUE!"}},null,null,null,null,"Bezugsbetreuer/in:",{"$f":"Start!K5","v":0},null,null,null,null,null,"2014-04-01",2016,"Fr"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"60/15","2014-05-01",2017,"Sa"]
[null,"FLS laut Bescheid:",{"$f":"Start!C7","v":0},null,null,null,"Bewilligungszeitraum",null,null,null,null,null,null,null,null,"48/12","2014-06-01",2018,"So"]
[null,null,null,null,null,null,"von",null,"bis",null,null,"rechnerische Tage:",null,null,null,null,"2014-07-01"]
["Fachleistungsstunde bitte wählen",null,null,null,{"$f":"Start!E9","v":"60/15"},null,{"$f":"Start!G9","v":"00:00:00"},null,{"$f":"Start!I9","v":"00:00:00"},null,null,{"$f":"I9-G9+1","v":1},null,null,null,null,"2014-08-01"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-09-01"]
["Wöchentlich bewilligte\ndirekte Betreuung:",null,null,null,null,null,{"$f":"I12/60","v":0},"Std.",{"$f":"IF(E9=\"60/15\",C7*60,C7*48)","v":0},"Minuten","Einsatzpauschalen laut Vergütungsvereinbarung",null,null,null,null,null,"2014-10-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-11-01"]
["Zeit-Pool  insgesamt                                     -  direkte Betreuung:",null,null,null,{"$f":"ROUND(IF(E9=\"60/15\",I14/60,I14/48),2)","v":0},"FLS",{"$f":"ROUND(G12/7*L9,2)","v":0},"Std.",{"$f":"G14*60","v":0},"Minuten","Pauschale A",{"$f":"Start!L14","v":0},null,null,null,null,"2014-12-01"]
[]
["Bisher geleistete Zeit     (inkl. Abrechnungsmonat):",null,null,null,{"$f":"ROUND(IF(E9=\"60/15\",I16/60,I16/48),2)","v":0},"FLS",{"$f":"ROUND(I16/60,2)","v":0},"Std.",{"$f":"D57+(H!I14-H!I20)","v":0},"Minuten","Pauschale B",{"$f":"Start!L16","v":0}]
[]
["ggf. Veränderungen\n(+ / -):",null,null,null,null,"FLS","(z. B. Abzüge wg. Krankenhausaufenthalten, Zuschläge wg. akuten Krisen)",null,null,null,"Pauschale C",{"$f":"Start!L18","v":0}]
[]
["Verbleibende FLS                         - direkte Betreuung:",null,null,null,{"$f":"E14-E16+E18","v":0},"FLS",{"$f":"ROUND(I20/60,2)","v":0},"Std.",{"$f":"IF(E9=\"60/15\",E20*60,E20*48)","v":0},"Minuten","Vergütung je FLS",{"$f":"Start!L20","v":0}]
[]
["Zeit",null,"direkte Betreuung",null,null,"EP","Art des Kontaktes",null,null,null,"Bemerkungen"]
["Tag","Datum","von","bis","Min"]
[null,null,null,null,{"$f":"IF(OR(C24=\"\",D24=\"\"),\"\",MOD(D24-C24,1)*24*60)","v":""}]
[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,""]
[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,""]
[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,""]
[null,null,null,null,""]
[null,null,null,null,""]
[]
[]
[null,null,null,null,null,null,null,"Rechnungsbetrag"]
[null,"Summe (Min)",null,{"$f":"SUM(E24:E53)","v":0}]
[null,null,"FLS",{"$f":"ROUND(IF(E9=\"60/15\",D57/75,D57/60),2)","v":0},null,null,null,{"$f":"D58*L20","v":0},null,"FLS"]
[null,null,null,null,null,null,null,{"$f":"D60*L14+D62*L16+D64*L18","v":0},null,"Einsatzpauschalen"]
[null,null,"Anzahl Einsatzpauschale A",{"$f":"COUNTIFS(F24:F53,\"A\")","v":0},null,null,null,{"$f":"SUM(H58:H59)","v":0},null,"Summe"]
[]
[null,null,"Anzahl Einsatzpauschale B",{"$f":"COUNTIFS(F24:F53,\"B\")","v":0}]
[]
[null,null,"Anzahl Einsatzpauschale C",{"$f":"COUNTIFS(F24:F53,\"c\")","v":0}]
[]
[null,null,null,null,null,null,null,"_____________________________",null,null,"________________________________"]
[]
[null,null,null,null,null,null,null,"Datum, Unterschrift Klient/in ",null,null,"Datum, Unterschrift Mitarbeiter/in"]

{"sheet":"J","index":10,"n_rows":68,"n_cols":20,"rows_kept":68,"cut":false,"hidden":false,"merged":[[44,6,44,9],[44,10,44,11],[45,6,45,9],[45,10,45,11],[46,6,46,9],[46,10,46,11],[52,6,52,9],[52,10,52,11],[47,6,47,9],[47,10,47,11],[48,6,48,9],[48,10,48,11],[49,6,49,9],[49,10,49,11],[50,6,50,9],[50,10,50,11],[51,6,51,9],[51,10,51,11],[36,6,36,9],[36,10,36,11],[37,6,37,9],[37,10,37,11],[43,6,43,9],[43,10,43,11],[38,6,38,9],[38,10,38,11],[39,6,39,9],[39,10,39,11],[40,6,40,9],[40,10,40,11],[41,6,41,9],[41,10,41,11],[42,6,42,9],[42,10,42,11],[32,10,32,11],[23,6,23,9],[23,10,23,11],[35,6,35,9],[35,10,35,11],[24,6,24,9],[25,6,25,9],[26,6,26,9],[27,6,27,9],[28,6,28,9],[24,10,24,11],[25,10,25,11],[26,10,26,11],[27,10,27,11],[28,10,28,11],[7,6,7,7],[7,8,7,9],[8,6,8,7],[8,8,8,9],[11,10,11,11],[0,6,0,9],[2,10,2,11],[6,6,6,9],[4,2,4,3],[4,4,4,5],[2,2,2,5],[4,10,4,11],[11,0,11,2],[13,0,13,2],[15,0,15,2],[19,0,19,2],[21,0,21,1],[21,2,21,4],[17,0,17,2],[17,6,17,9],[56,1,56,2],[21,5,22,5],[21,6,22,9],[21,10,22,11],[29,10,29,11],[29,6,29,9],[33,6,33,9],[33,10,33,11],[34,6,34,9],[34,10,34,11],[30,6,30,9],[30,10,30,11],[31,6,31,9],[31,10,31,11],[32,6,32,9]]}
[null,null,null,null,null,"Einrichtung:",{"$f":"Start!G1","v":0},null,null,null,null,null,null,null,null,null,"Monat","Jahr","Mo","A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-01-01",2013,"Di","B"]
[null,"Klient/in:",{"$f":"Start!C3","v":0},null,null,null,null,null,null,"Wohnort:",{"$f":"Start!K3","v":0},null,null,null,null,null,"2014-02-01",2014,"Mi","C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-03-01",2015,"Do"]
[null,"Monat/Jahr: ",{"$f":"DATE(YEAR(I!C5),MONTH(I!C5)+1,DAY(I!C5))","v":{"$error":"#VALUE!"}},null,{"$f":"IF(I!C5=J!Q14,I!E5+1,I!E5)","v":{"$error":"#VALUE!"}},null,null,null,null,"Bezugsbetreuer/in:",{"$f":"Start!K5","v":0},null,null,null,null,null,"2014-04-01",2016,"Fr"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"60/15","2014-05-01",2017,"Sa"]
[null,"FLS laut Bescheid:",{"$f":"Start!C7","v":0},null,null,null,"Bewilligungszeitraum",null,null,null,null,null,null,null,null,"48/12","2014-06-01",2018,"So"]
[null,null,null,null,null,null,"von",null,"bis",null,null,"rechnerische Tage:",null,null,null,null,"2014-07-01"]
["Fachleistungsstunde bitte wählen",null,null,null,{"$f":"Start!E9","v":"60/15"},null,{"$f":"Start!G9","v":"00:00:00"},null,{"$f":"Start!I9","v":"00:00:00"},null,null,{"$f":"I9-G9+1","v":1},null,null,null,null,"2014-08-01"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-09-01"]
["Wöchentlich bewilligte\ndirekte Betreuung:",null,null,null,null,null,{"$f":"I12/60","v":0},"Std.",{"$f":"IF(E9=\"60/15\",C7*60,C7*48)","v":0},"Minuten","Einsatzpauschalen laut Vergütungsvereinbarung",null,null,null,null,null,"2014-10-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-11-01"]
["Zeit-Pool  insgesamt                                     -  direkte Betreuung:",null,null,null,{"$f":"ROUND(IF(E9=\"60/15\",I14/60,I14/48),2)","v":0},"FLS",{"$f":"ROUND(G12/7*L9,2)","v":0},"Std.",{"$f":"G14*60","v":0},"Minuten","Pauschale A",{"$f":"Start!L14","v":0},null,null,null,null,"2014-12-01"]
[]
["Bisher geleistete Zeit     (inkl. Abrechnungsmonat):",null,null,null,{"$f":"ROUND(IF(E9=\"60/15\",I16/60,I16/48),2)","v":0},"FLS",{"$f":"ROUND(I16/60,2)","v":0},"Std.",{"$f":"D57+(I!I14-I!I20)","v":0},"Minuten","Pauschale B",{"$f":"Start!L16","v":0}]
[]
["ggf. Veränderungen\n(+ / -):",null,null,null,null,"FLS","(z. B. Abzüge wg. Krankenhausaufenthalten, Zuschläge wg. akuten Krisen)",null,null,null,"Pauschale C",{"$f":"Start!L18","v":0}]
[]
["Verbleibende FLS                         - direkte Betreuung:",null,null,null,{"$f":"E14-E16+E18","v":0},"FLS",{"$f":"ROUND(I20/60,2)","v":0},"Std.",{"$f":"IF(E9=\"60/15\",E20*60,E20*48)","v":0},"Minuten","Vergütung je FLS",{"$f":"Start!L20","v":0}]
[]
["Zeit",null,"direkte Betreuung",null,null,"EP","Art des Kontaktes",null,null,null,"Bemerkungen"]
["Tag","Datum","von","bis","Min"]
[null,null,null,null,{"$f":"IF(OR(C24=\"\",D24=\"\"),\"\",MOD(D24-C24,1)*24*60)","v":""}]
[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,""]
[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,""]
[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,""]
[null,null,null,null,""]
[null,null,null,null,""]
[]
[]
[null,null,null,null,null,null,null,"Rechnungsbetrag"]
[null,"Summe (Min)",null,{"$f":"SUM(E24:E53)","v":0}]
[null,null,"FLS",{"$f":"ROUND(IF(E9=\"60/15\",D57/75,D57/60),2)","v":0},null,null,null,{"$f":"D58*L20","v":0},null,"FLS"]
[null,null,null,null,null,null,null,{"$f":"D60*L14+D62*L16+D64*L18","v":0},null,"Einsatzpauschalen"]
[null,null,"Anzahl Einsatzpauschale A",{"$f":"COUNTIFS(F24:F53,\"A\")","v":0},null,null,null,{"$f":"SUM(H58:H59)","v":0},null,"Summe"]
[]
[null,null,"Anzahl Einsatzpauschale B",{"$f":"COUNTIFS(F24:F53,\"B\")","v":0}]
[]
[null,null,"Anzahl Einsatzpauschale C",{"$f":"COUNTIFS(F24:F53,\"c\")","v":0}]
[]
[null,null,null,null,null,null,null,"_____________________________",null,null,"________________________________"]
[]
[null,null,null,null,null,null,null,"Datum, Unterschrift Klient/in ",null,null,"Datum, Unterschrift Mitarbeiter/in"]

{"sheet":"K","index":11,"n_rows":68,"n_cols":20,"rows_kept":68,"cut":false,"hidden":false,"merged":[[44,6,44,9],[44,10,44,11],[45,6,45,9],[45,10,45,11],[46,6,46,9],[46,10,46,11],[52,6,52,9],[52,10,52,11],[47,6,47,9],[47,10,47,11],[48,6,48,9],[48,10,48,11],[49,6,49,9],[49,10,49,11],[50,6,50,9],[50,10,50,11],[51,6,51,9],[51,10,51,11],[36,6,36,9],[36,10,36,11],[37,6,37,9],[37,10,37,11],[43,6,43,9],[43,10,43,11],[38,6,38,9],[38,10,38,11],[39,6,39,9],[39,10,39,11],[40,6,40,9],[40,10,40,11],[41,6,41,9],[41,10,41,11],[42,6,42,9],[42,10,42,11],[32,10,32,11],[23,6,23,9],[23,10,23,11],[35,6,35,9],[35,10,35,11],[24,6,24,9],[25,6,25,9],[26,6,26,9],[27,6,27,9],[28,6,28,9],[24,10,24,11],[25,10,25,11],[26,10,26,11],[27,10,27,11],[28,10,28,11],[7,6,7,7],[7,8,7,9],[8,6,8,7],[8,8,8,9],[11,10,11,11],[0,6,0,9],[2,10,2,11],[6,6,6,9],[4,2,4,3],[4,4,4,5],[2,2,2,5],[4,10,4,11],[11,0,11,2],[13,0,13,2],[15,0,15,2],[19,0,19,2],[21,0,21,1],[21,2,21,4],[17,0,17,2],[17,6,17,9],[56,1,56,2],[21,5,22,5],[21,6,22,9],[21,10,22,11],[29,10,29,11],[29,6,29,9],[33,6,33,9],[33,10,33,11],[34,6,34,9],[34,10,34,11],[30,6,30,9],[30,10,30,11],[31,6,31,9],[31,10,31,11],[32,6,32,9]]}
[null,null,null,null,null,"Einrichtung:",{"$f":"Start!G1","v":0},null,null,null,null,null,null,null,null,null,"Monat","Jahr","Mo","A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-01-01",2013,"Di","B"]
[null,"Klient/in:",{"$f":"Start!C3","v":0},null,null,null,null,null,null,"Wohnort:",{"$f":"Start!K3","v":0},null,null,null,null,null,"2014-02-01",2014,"Mi","C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-03-01",2015,"Do"]
[null,"Monat/Jahr: ",{"$f":"DATE(YEAR(J!C5),MONTH(J!C5)+1,DAY(J!C5))","v":{"$error":"#VALUE!"}},null,{"$f":"IF(J!C5=K!Q14,J!E5+1,J!E5)","v":{"$error":"#VALUE!"}},null,null,null,null,"Bezugsbetreuer/in:",{"$f":"Start!K5","v":0},null,null,null,null,null,"2014-04-01",2016,"Fr"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"60/15","2014-05-01",2017,"Sa"]
[null,"FLS laut Bescheid:",{"$f":"Start!C7","v":0},null,null,null,"Bewilligungszeitraum",null,null,null,null,null,null,null,null,"48/12","2014-06-01",2018,"So"]
[null,null,null,null,null,null,"von",null,"bis",null,null,"rechnerische Tage:",null,null,null,null,"2014-07-01"]
["Fachleistungsstunde bitte wählen",null,null,null,{"$f":"Start!E9","v":"60/15"},null,{"$f":"Start!G9","v":"00:00:00"},null,{"$f":"Start!I9","v":"00:00:00"},null,null,{"$f":"I9-G9+1","v":1},null,null,null,null,"2014-08-01"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-09-01"]
["Wöchentlich bewilligte\ndirekte Betreuung:",null,null,null,null,null,{"$f":"I12/60","v":0},"Std.",{"$f":"IF(E9=\"60/15\",C7*60,C7*48)","v":0},"Minuten","Einsatzpauschalen laut Vergütungsvereinbarung",null,null,null,null,null,"2014-10-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-11-01"]
["Zeit-Pool  insgesamt                                     -  direkte Betreuung:",null,null,null,{"$f":"ROUND(IF(E9=\"60/15\",I14/60,I14/48),2)","v":0},"FLS",{"$f":"ROUND(G12/7*L9,2)","v":0},"Std.",{"$f":"G14*60","v":0},"Minuten","Pauschale A",{"$f":"Start!L14","v":0},null,null,null,null,"2014-12-01"]
[]
["Bisher geleistete Zeit     (inkl. Abrechnungsmonat):",null,null,null,{"$f":"ROUND(IF(E9=\"60/15\",I16/60,I16/48),2)","v":0},"FLS",{"$f":"ROUND(I16/60,2)","v":0},"Std.",{"$f":"D57+(J!I14-J!I20)","v":0},"Minuten","Pauschale B",{"$f":"Start!L16","v":0}]
[]
["ggf. Veränderungen\n(+ / -):",null,null,null,null,"FLS","(z. B. Abzüge wg. Krankenhausaufenthalten, Zuschläge wg. akuten Krisen)",null,null,null,"Pauschale C",{"$f":"Start!L18","v":0}]
[]
["Verbleibende FLS                         - direkte Betreuung:",null,null,null,{"$f":"E14-E16+E18","v":0},"FLS",{"$f":"ROUND(I20/60,2)","v":0},"Std.",{"$f":"IF(E9=\"60/15\",E20*60,E20*48)","v":0},"Minuten","Vergütung je FLS",{"$f":"Start!L20","v":0}]
[]
["Zeit",null,"direkte Betreuung",null,null,"EP","Art des Kontaktes",null,null,null,"Bemerkungen"]
["Tag","Datum","von","bis","Min"]
[null,null,null,null,{"$f":"IF(OR(C24=\"\",D24=\"\"),\"\",MOD(D24-C24,1)*24*60)","v":""}]
[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,""]
[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,""]
[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,""]
[null,null,null,null,""]
[null,null,null,null,""]
[]
[]
[null,null,null,null,null,null,null,"Rechnungsbetrag"]
[null,"Summe (Min)",null,{"$f":"SUM(E24:E53)","v":0}]
[null,null,"FLS",{"$f":"ROUND(IF(E9=\"60/15\",D57/75,D57/60),2)","v":0},null,null,null,{"$f":"D58*L20","v":0},null,"FLS"]
[null,null,null,null,null,null,null,{"$f":"D60*L14+D62*L16+D64*L18","v":0},null,"Einsatzpauschalen"]
[null,null,"Anzahl Einsatzpauschale A",{"$f":"COUNTIFS(F24:F53,\"A\")","v":0},null,null,null,{"$f":"SUM(H58:H59)","v":0},null,"Summe"]
[]
[null,null,"Anzahl Einsatzpauschale B",{"$f":"COUNTIFS(F24:F53,\"B\")","v":0}]
[]
[null,null,"Anzahl Einsatzpauschale C",{"$f":"COUNTIFS(F24:F53,\"c\")","v":0}]
[]
[null,null,null,null,null,null,null,"_____________________________",null,null,"________________________________"]
[]
[null,null,null,null,null,null,null,"Datum, Unterschrift Klient/in ",null,null,"Datum, Unterschrift Mitarbeiter/in"]

{"sheet":"Erläuterungen","index":12,"n_rows":25,"n_cols":1,"rows_kept":25,"cut":false,"hidden":false,"merged":[[23,0,23,5],[24,0,24,5],[1,0,1,5],[3,0,3,5],[2,0,2,5],[7,0,7,5],[10,0,10,5],[8,0,8,5],[9,0,9,5],[4,0,4,5],[6,0,6,5],[20,0,20,5],[22,0,22,5],[5,0,5,5],[19,0,19,5],[21,0,21,5],[11,0,11,5],[12,0,12,5],[15,0,15,5],[18,0,18,5],[13,0,13,5],[14,0,14,5],[17,0,17,5],[16,0,16,5]]}
["Erläuterungen"]
[]
["Die Blätter der Arbeitsmappe sind schreibgeschützt."]
[]
["Es können nur farblich gekennzeichnete Felder ausgewählt werden."]
[]
["Eintragungen sind nur in den farblich gekennzeichneten Feldern notwendig und möglich."]
[]
["Die Eintragungen beginnen im Tabellenblatt \"Start\". Die Grundangaben (Zeilen 1 bis 19) werden in die übrigen Tabellenblätter übertragen."]
[]
["In der Datei ist ein Makro hinterlegt. Es bewirkt folgendes: Sobald im Tabellenblatt \"Start\" der Monat des Beginns der Bewilligung eingetragen wurde, werden Namen der Tabellenblätter automatisch umbenannt. Dies funktioniert nur einmal."]
[]
["Sobald das korrekte Jahr ausgewählt wird, wird dies ebenfalls in die übrigen Tabellenblätter übertragen, auch der Jahreswechsel wird errechnet."]
[]
["Das Datum in dem Format \"TT.MM.JJJJ\" angeben."]
[]
["Falls erforderlich bitte FLS angeben, die wegen Krankenhausaufenthalten abgezogen werden müssen oder die wegen akuten Mehrbedarf zusätzlich bewilligt wurden. Bitte ggf. mit negativem Vorzeichen angeben."]
[]
["Die Uhrzeit (Beginn und Ende) in dem Format \"hh:mm\" angeben."]
[]
["Für den Fall, dass nur eine oder zwei Einsatzpauschalen vereinbart sind, die entsprechenden Felder bitte leer lassen."]
[]
["In der Spalte \"EP\" ggf. den entsprechenden Buchstaben der Einsatzpauschale eintragen."]
[]
["Falls in Zellen #### angezeigt wird, kann die Schriftgröße verkleinert werden, damit die Zahl lesbar dargestellt wird. Anmerkung: Trotz Darstellung von #### wird im Hintergrund mit Zahlen gerechnet!"]