{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Anrufprognose","Bedarfsberechnung"],"not_rendered":{"charts":0,"images":0,"macros":1,"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":"Anrufprognose","index":0,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Stunde","Mo1","Mo2","Mo3","Mo4",null,null,"Mittelwert"]
[8,7,5,6,7,null,null,{"$f":"AVERAGE(B2:F2)","v":6.25}]
[{"$f":"A2+1","v":9},15,17,17,18,null,null,16.75]
[10,28,35,25,35,null,null,30.75]
[11,46,42,37,29,null,null,38.5]
[12,45,45,42,53,null,null,46.25]
[13,32,29,29,31,null,null,30.25]
[14,35,35,43,37,null,null,37.5]
[15,36,36,38,39,null,null,37.25]
[16,24,20,20,21,null,null,21.25]
[17,6,7,7,6,null,null,6.5]
[18,6,4,6,2,null,null,4.5]

{"sheet":"Bedarfsberechnung","index":1,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["ETS [sec]",600]
["c_S",0.5]
[null,null,null,null,null,"Erwartete Wartezeit in Abhängigkeit der Agentenzahl [sec]"]
[]
["Stunde","Lambda [h^-1]","Lambda [sec^-1]","a","N_min","EW( N_min )","EW( N_min+1 )","EW( N_min+2 )","EW( N_min+3 )"]
[{"$f":"Anrufprognose!A2","v":8},{"$f":"Anrufprognose!H2","v":6.25},{"$f":"B6/3600","v":1.736111111111111E-3},{"$f":"C6*$B$1","v":1.0416666666666665},{"$f":"ROUNDUP(D6,0)","v":2},{"$f":"(1+$B$2^2)/2*($D6/($E6+0))^(SQRT(2*($E6+1+0))-1)/(($E6+0)*(1-($D6/($E6+0))))*$B$1","v":152.01010125535691},{"$f":"(1+$B$2^2)/2*($D6/($E6+1))^(SQRT(2*($E6+1+1))-1)/(($E6+1)*(1-($D6/($E6+1))))*$B$1","v":27.68082093857285},{"$f":"(1+$B$2^2)/2*($D6/($E6+2))^(SQRT(2*($E6+1+2))-1)/(($E6+2)*(1-($D6/($E6+2))))*$B$1","v":6.9103144178551466},{"$f":"(1+$B$2^2)/2*($D6/($E6+3))^(SQRT(2*($E6+1+3))-1)/(($E6+3)*(1-($D6/($E6+3))))*$B$1","v":1.9855063064868519}]
[{"$f":"Anrufprognose!A3","v":9},{"$f":"Anrufprognose!H3","v":16.75},{"$f":"B7/3600","v":4.6527777777777774E-3},{"$f":"C7*$B$1","v":2.7916666666666665},{"$f":"ROUNDUP(D7,0)","v":3},{"$f":"(1+$B$2^2)/2*($D7/($E7+0))^(SQRT(2*($E7+1+0))-1)/(($E7+0)*(1-($D7/($E7+0))))*$B$1","v":1578.0475671615141},{"$f":"(1+$B$2^2)/2*($D7/($E7+1))^(SQRT(2*($E7+1+1))-1)/(($E7+1)*(1-($D7/($E7+1))))*$B$1","v":142.59505321976098},{"$f":"(1+$B$2^2)/2*($D7/($E7+2))^(SQRT(2*($E7+1+2))-1)/(($E7+2)*(1-($D7/($E7+2))))*$B$1","v":40.391189581458505},{"$f":"(1+$B$2^2)/2*($D7/($E7+3))^(SQRT(2*($E7+1+3))-1)/(($E7+3)*(1-($D7/($E7+3))))*$B$1","v":14.346064731559355}]
[{"$f":"Anrufprognose!A4","v":10},{"$f":"Anrufprognose!H4","v":30.75},8.5416666666666662E-3,5.125,6,278.18680802996477,78.490570335276942,30.780757267531381,13.697882489626972]
[{"$f":"Anrufprognose!A5","v":11},{"$f":"Anrufprognose!H5","v":38.5},1.0694444444444444E-2,6.4166666666666661,7,495.1636904761902,115.84495921119213,44.841420557526043,20.353351045913282]
[{"$f":"Anrufprognose!A6","v":12},{"$f":"Anrufprognose!H6","v":46.25},1.2847222222222222E-2,7.708333333333333,8,1139.8358060374644,169.53855812706161,62.620570304210247,28.476554724071359]
[{"$f":"Anrufprognose!A7","v":13},{"$f":"Anrufprognose!H7","v":30.25},8.4027777777777781E-3,5.041666666666667,6,242.83322029640408,71.543950501933281,28.365032133985572,12.667533757796276]
[{"$f":"Anrufprognose!A8","v":14},{"$f":"Anrufprognose!H8","v":37.5},1.0416666666666666E-2,6.25,7,355.89012390670575,96.238713630337955,38.445230685155529,17.648686925312553]
[{"$f":"Anrufprognose!A9","v":15},{"$f":"Anrufprognose!H9","v":37.25},1.0347222222222223E-2,6.2083333333333339,7,330.46073810163193,91.983684852706389,37.001990009367269,17.029146942604552]
[{"$f":"Anrufprognose!A10","v":16},{"$f":"Anrufprognose!H10","v":21.25},5.9027777777777776E-3,3.5416666666666665,4,628.88098119294386,109.93725517988501,35.950561499988737,14.044081757057381]
[{"$f":"Anrufprognose!A11","v":17},{"$f":"Anrufprognose!H11","v":6.5},1.8055555555555555E-3,1.0833333333333333,2,168.21598156194119,30.385277838978766,7.6293743669298282,2.2102372878060792]
[{"$f":"Anrufprognose!A12","v":18},{"$f":"Anrufprognose!H12","v":4.5},1.25E-3,0.75,1,1125,72.390895085368072,13.213745281358142,3.0915394899971118]