{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Fallbesprechung","Kapazität"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Fallbesprechung","index":0,"n_rows":218,"n_cols":11,"rows_kept":218,"merged":[[0,4,0,7]]}
[{"$nulls":4},"Fallbesprechung Übersichtstabelle"]
[null,"Betreuer","Heim","Whg","Klient","bei Insel seit:","be-sprochen am","2.","3.","4."]
[]
[null,"Platzhalter"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59,{"$nulls":9},"Michael schon bestellt, wird aber noch von Stefanie bearbeitet"]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]
[99]
[100]
[101]
[102]
[103]
[104]
[105]
[106]
[107]
[108]
[109]
[110]
[111]
[112]
[113]
[114]
[115]
[116]
[117]
[118]
[119]
[120]
[121]
[122]
[123]
[124]
[125]
[126]
[127]
[128]
[129]
[130]
[131]
[132]
[133]
[134]
[135]
[136]
[137]
[138]
[139]
[140]
[141]
[142]
[143]
[144]
[145]
[146]
[147]
[148]
[149]
[150]
[151]
[152]
[153]
[154]
[155]
[156]
[157]
[158]
[159]
[160]
[161]
[162]
[163]
[164]
[165]
[166]
[167]
[168]
[169]
[170]
[171]
[172]
[173]
[174]
[175]
[176]
[177]
[178]
[179]
[180]
[181]
[182]
[183]
[184]
[185]
[186]
[187]
[188]
[189]
[190]
[191]
[192]
[193]
[194]
[195]
[196]
[197]
[198]
[199]
[200]
[201]
[202]
[203]
[204]
[205]
[206]
[207]
[208]
[209]
[210]
[211]
[null,null,{"$f":"SUM(C4:C215)","v":0},{"$f":"SUM(D4:D215)","v":0},"   "]
[]
[{"$nulls":3},{"$f":"C216+D216","v":0},null,null,"2017-01-03"]

{"sheet":"Kapazität","index":1,"n_rows":23,"n_cols":8,"rows_kept":23,"merged":[[20,4,20,7],[21,4,21,7],[22,4,22,7]]}
[]
[]
[null,"Betreuer","Anzahl der aktuellen Betreuungen","davon im Heim","davon in Wohnung","Anzahl der Betreuungen in Warteschleife","Sollzahl zu führender Betreuungen","freie Kapazität"]
[null,null,{"$f":"+SUM(D4:E4)+SUMIF(Fallbesprechung!$B$5:$B$1122,B4,Fallbesprechung!$B$5:$B$1122)+SUMIF(Fallbesprechung!$B$5:$B$1122,B4,Fallbesprechung!$B$5:$B$1122)","v":0},{"$f":"SUMIF(Fallbesprechung!$B$4:$B$1122,B4,Fallbesprechung!$C$4:$C$1122)","v":0},{"$f":"SUMIF(Fallbesprechung!$B$4:$B$1122,B4,Fallbesprechung!$D$4:$D$1122)","v":0},0,{"v":0,"d":"0.0"},{"$f":"+G4-C4-F4","v":{"v":0,"d":"0.0"}}]
[null,null,{"$f":"+SUM(D5:E5)+SUMIF(Fallbesprechung!$B$5:$B$1122,B5,Fallbesprechung!$B$5:$B$1122)+SUMIF(Fallbesprechung!$B$5:$B$1122,B5,Fallbesprechung!$B$5:$B$1122)","v":0},{"$f":"SUMIF(Fallbesprechung!$B$4:$B$1122,B5,Fallbesprechung!$C$4:$C$1122)","v":0},{"$f":"SUMIF(Fallbesprechung!$B$4:$B$1122,B5,Fallbesprechung!$D$4:$D$1122)","v":0},0,{"v":0,"d":"0.0"},{"v":0,"d":"0.0"}]
[null,null,{"$f":"+SUM(D6:E6)+SUMIF(Fallbesprechung!$B$5:$B$1122,B6,Fallbesprechung!$B$5:$B$1122)+SUMIF(Fallbesprechung!$B$5:$B$1122,B6,Fallbesprechung!$B$5:$B$1122)","v":0},{"$f":"SUMIF(Fallbesprechung!$B$4:$B$1122,B6,Fallbesprechung!$C$4:$C$1122)","v":0},{"$f":"SUMIF(Fallbesprechung!$B$4:$B$1122,B6,Fallbesprechung!$D$4:$D$1122)","v":0},0,{"v":0,"d":"0.0"},{"v":0,"d":"0.0"}]
[null,null,{"$f":"+SUM(D7:E7)+SUMIF(Fallbesprechung!$B$5:$B$1122,B7,Fallbesprechung!$B$5:$B$1122)+SUMIF(Fallbesprechung!$B$5:$B$1122,B7,Fallbesprechung!$B$5:$B$1122)","v":0},{"$f":"SUMIF(Fallbesprechung!$B$4:$B$1122,B7,Fallbesprechung!$C$4:$C$1122)","v":0},{"$f":"SUMIF(Fallbesprechung!$B$4:$B$1122,B7,Fallbesprechung!$D$4:$D$1122)","v":0},0,{"v":0,"d":"0.0"},{"v":0,"d":"0.0"}]
[null,null,{"$f":"+SUM(D8:E8)+SUMIF(Fallbesprechung!$B$5:$B$1122,B8,Fallbesprechung!$B$5:$B$1122)+SUMIF(Fallbesprechung!$B$5:$B$1122,B8,Fallbesprechung!$B$5:$B$1122)","v":0},{"$f":"SUMIF(Fallbesprechung!$B$4:$B$1122,B8,Fallbesprechung!$C$4:$C$1122)","v":0},{"$f":"SUMIF(Fallbesprechung!$B$4:$B$1122,B8,Fallbesprechung!$D$4:$D$1122)","v":0},0,{"v":0,"d":"0.0"},{"v":0,"d":"0.0"}]
[null,null,{"$f":"+SUM(D9:E9)+SUMIF(Fallbesprechung!$B$5:$B$1122,B9,Fallbesprechung!$B$5:$B$1122)+SUMIF(Fallbesprechung!$B$5:$B$1122,B9,Fallbesprechung!$B$5:$B$1122)","v":0},{"$f":"SUMIF(Fallbesprechung!$B$4:$B$1122,B9,Fallbesprechung!$C$4:$C$1122)","v":0},{"$f":"SUMIF(Fallbesprechung!$B$4:$B$1122,B9,Fallbesprechung!$D$4:$D$1122)","v":0},0,{"v":0,"d":"0.0"},{"v":0,"d":"0.0"}]
[null,null,{"$f":"+SUM(D10:E10)+SUMIF(Fallbesprechung!$B$5:$B$1122,B10,Fallbesprechung!$B$5:$B$1122)+SUMIF(Fallbesprechung!$B$5:$B$1122,B10,Fallbesprechung!$B$5:$B$1122)","v":0},{"$f":"SUMIF(Fallbesprechung!$B$4:$B$1122,B10,Fallbesprechung!$C$4:$C$1122)","v":0},{"$f":"SUMIF(Fallbesprechung!$B$4:$B$1122,B10,Fallbesprechung!$D$4:$D$1122)","v":0},0,{"v":0,"d":"0.0"},{"v":0,"d":"0.0"}]
[null,null,{"$f":"+SUM(D11:E11)+SUMIF(Fallbesprechung!$B$5:$B$1122,B11,Fallbesprechung!$B$5:$B$1122)+SUMIF(Fallbesprechung!$B$5:$B$1122,B11,Fallbesprechung!$B$5:$B$1122)","v":0},{"$f":"SUMIF(Fallbesprechung!$B$4:$B$1122,B11,Fallbesprechung!$C$4:$C$1122)","v":0},{"$f":"SUMIF(Fallbesprechung!$B$4:$B$1122,B11,Fallbesprechung!$D$4:$D$1122)","v":0},0,{"v":0,"d":"0.0"},{"$f":"+G11-C11-F11","v":{"v":0,"d":"0.0"}}]
[null,null,{"$f":"+SUM(D12:E12)+SUMIF(Fallbesprechung!$B$5:$B$1122,B12,Fallbesprechung!$B$5:$B$1122)+SUMIF(Fallbesprechung!$B$5:$B$1122,B12,Fallbesprechung!$B$5:$B$1122)","v":0},{"$f":"SUMIF(Fallbesprechung!$B$4:$B$1122,B12,Fallbesprechung!$C$4:$C$1122)","v":0},{"$f":"SUMIF(Fallbesprechung!$B$4:$B$1122,B12,Fallbesprechung!$D$4:$D$1122)","v":0},0,{"v":0,"d":"0.0"},{"v":0,"d":"0.0"}]
[null,"Summe",{"$f":"+SUM(C4:C12)","v":0},{"$f":"+SUM(D4:D12)","v":0},{"$f":"+SUM(E4:E12)","v":0},{"$f":"+SUM(F4:F12)","v":0},{"v":0,"d":"0.0"},{"$f":"SUMIF(H4:H12,\">0\")","v":0}]
[]
[]
[null,"Bitte nur die Sollzahl der zu führenden Betreuungen und die Betreuungen in der Warteschleife als Zahl eintragen"]
[null,"Alle anderen Felder sind mit Formeln versehen und werden automatisch berechnet"]
[]
[]
[]
[{"$nulls":4},"Zur Berechnung der zu übernehmenden Betreuungen:"]
[{"$nulls":4},"Vollzeitstelle = 39 Stunden = 50 Betreuungen. "]
[{"$nulls":4},"Nach Dreisatz zu berechnen"]