{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Eingabe","Tabelle1","Tabelle2","Tabelle3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":"Eingabe","index":0,"n_rows":6,"n_cols":19,"rows_kept":6,"cut":false,"hidden":false,"merged":[[3,1,3,5],[3,8,3,12]]}
["Berechnung Ferienbelegung"]
[]
[]
[null,"Basisbelegung",null,null,null,null,null,null,"Ferienbelegung",null,null,null,null,null,"Differenz"]
["Name Kind","Mo","Di","Mi","Do","Fr","Total",null,"Mo","Di","Mi","Do","Fr","Total",null,"Anz. Wochen Betreuung pro Jahr","Anz. benötigte Wochen Ferienbetreuung","Ferienbetreuung in Belegungsprozent","Vertraglich vereinbarte Belegung"]
[null,0,0,0,0,0,{"$f":"(B6+C6+D6+E6+F6)","v":0}," ",0,0,0,0,0,{"$f":"(I6+J6+K6+L6+M6)","v":0},{"$f":"N6-G6","v":0},47,0,{"$f":"O6/P6*Q6","v":0},{"$f":"G6+R6","v":0}]

{"sheet":"Tabelle1","index":1,"n_rows":19,"n_cols":23,"rows_kept":19,"cut":false,"hidden":false,"merged":[[18,0,21,22],[1,15,4,15],[4,1,4,5],[4,8,4,12],[1,1,2,14]]}
[null,"Berechnung der Ferienbelegung / Berechnungsprinzip und Beispiele"]
[null,"Prinzip: Differenz zur Basisbelegung : (230:5=) 46  = Zusatz pro Woche mal betroffene Ferienwochen = Belegungszusatz  (gerundet)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Zusatz% pro  beanspruchte Ferienwoche   "]
[]
[]
[null,"Basisbelegung",null,null,null,null,null,null,"Ferienbelegung",null,null,null,null,null,"Differenz"]
["Name Kind","Mo","Di","Mi","Do","Fr","Total",null,"Mo","Di","Mi","Do","Fr","Total",null,"1W","2W","3W","4W","5W","6W","7W","8W"]
["Kevin Muster",50,70,70,null,null,{"$f":"(B7+C7+D7+E7+F7)/5","v":38},null,100,100,100,null,null,{"$f":"(I7+J7+K7+L7+M7)/5","v":60},{"$f":"N7-G7","v":22},{"$f":"O7/46","v":0.47826086956521741},{"$f":"P7*2","v":0.95652173913043481},{"$f":"P7*3","v":1.4347826086956523},{"$f":"P7*4","v":1.9130434782608696},{"$f":"P7*5","v":2.3913043478260869},{"$f":"P7*6","v":2.8695652173913047},{"$f":"P7*7","v":3.347826086956522},{"$f":"P7*8","v":3.8260869565217392}]
["Zoe Beispiel",70,20,null,70,70,{"$f":"(B8+C8+D8+E8+F8)/5","v":46},null,100,100,null,100,100,{"$f":"(I8+J8+K8+L8+M8)/5","v":80},34,{"$f":"O8/46","v":0.73913043478260865},{"$f":"P8*2","v":1.4782608695652173},{"$f":"P8*3","v":2.2173913043478262},{"$f":"P8*4","v":2.9565217391304346},{"$f":"P8*5","v":3.695652173913043},{"$f":"P8*6","v":4.4347826086956523},{"$f":"P8*7","v":5.1739130434782608},{"$f":"P8*8","v":5.9130434782608692}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,{"$f":"O9/46","v":0},0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
["Spezialfall",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Tanja Austritt1",50,50,70,20,null,38,null,100,100,100,100,null,80,{"$f":"N15-G15","v":42},{"$f":"O15/28","v":1.5},3,4.5,6,7.5,9,10.5,12]
[null,null,null,null,null,null,0,null,null,null,null,null,null,0,{"$f":"N16-G16","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,0,{"$f":"N17-G17","v":0},0,0,0,0,0,0,0,0]
[]
["1 Spezialfall: Tanja tritt Mitte Sommerferien, d.h. vor den Betriebsferien aus. Die zusätzliche Ferienbetreuung braucht sie während der Sportferien, den Frühlingsferien sowie während der 3 Wochen Sommerferien, d.h. während insgesamt 6 Wochen; Da sie austritt, bezieht sich die Ferienbelegung auf die Anzahl noch beanspruchter Wochen, im Falle von Tanja auf 28 statt auf 46 Wochen; die Belegungsdifferenz wird demnach durch 28 geteilt, es resultieren 1,5% Zusatzbelegung pro beanspruchte Ferienwoche, d.h. 9% zusätzlich für die 6 Wochen.     "]

{"sheet":"Tabelle2","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Tabelle3","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}