{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["M-M-c","facto","M-M-m-inf","M-M-m-b"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"facto","index":1,"reason":"part_missing"},{"sheet":"M-M-m-inf","index":2,"reason":"part_missing"},{"sheet":"M-M-m-b","index":3,"reason":"part_missing"}],"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":"1904"}

{"sheet":"M-M-c","index":0,"n_rows":32,"n_cols":9,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Model 4 (M/M/s Queue):"]
[null,"Multiple servers,  Infinite population, Poisson arrival, FCFS, Exponential service time, Unlimited waiting room"]
[null,"Yellow cells need user inputed values"]
["Inputs"]
[null,"Units of time","month"]
[null,"Arrival rate - R",7]
[null,"Service rate - Rp",10]
[null,"Number of identical servers - c",1]
[]
["Outputs"]
[null,"Direct outputs from inputs"]
[null,"Mean time between arrivals- Ta",{"$f":"1/C6","v":0.14285714285714285}]
[null,"Mean time per service - Tp",{"$f":"1/C7","v":0.1}]
[null,"Traffic intensity - U",{"$f":"C6/C7/C8","v":0.7}]
[]
["Summary measures",null,null,7,8,9]
[null,"Average utilization rate of server - U",{"$f":"C6/C7/C8","v":0.7},0.7,0.8,0.9]
[null,"Average number of customers waiting in line Ii",{"$f":"(C6/C7)^(C8+1)/C8/FACT(C8)/(1-C6/C7/C8)^2 *C22","v":1.6333333333333329},1.6333333333333329,3.2000000000000015,8.1000000000000032]
[null,"Average number of customers in system I",{"$f":"C18+C6/C7","v":2.333333333333333},2.333333333333333,4.0000000000000018,9.0000000000000036]
[null,"Average time waiting in line Ti",{"$f":"C18/C6","v":0.23333333333333325},0.23333333333333325,0.40000000000000019,0.90000000000000036,{"$f":"D20*30","v":6.9999999999999973},{"$f":"E20*30","v":12.000000000000005},{"$f":"F20*30","v":27.000000000000011}]
[null,"Average time in system - T",{"$f":"C19/C6","v":0.33333333333333331},0.33333333333333331,0.50000000000000022,1.0000000000000004,{"$f":"D21*30","v":10},{"$f":"E21*30","v":15.000000000000007},30.000000000000014]
[null,"Probability of no customers in system (P0)",{"$f":"P0inf(C8,C6/C7)","v":0.30000000000000004},0.30000000000000004,0.19999999999999996,9.9999999999999978E-2]
[null,"Probability that all servers are busy",{"$f":"(C8*C14)^C8/factorial(C8)/(1-C14)*C22","v":0.70000000000000007},0.70000000000000007,0.8,0.9]
[null,"Probability that at least one server is idle",{"$f":"1-C23","v":0.29999999999999993},0.29999999999999993,0.19999999999999996,9.9999999999999978E-2]
[]
[null,"Distribution of number of customers in system"]
[null,"n (customers)","P(n in system)"]
[null,0,{"$f":"IF(B28=0,C22,IF(B28<C8+1,(C8*C14)^B28/factorial(B28)*C22, (C8*C14)^B28/factorial(C8)/C8^(B28-C8)*C22))","v":0.30000000000000004}]
[]
[null,"Distribution of time in queue"]
[null,"t (time in queue)","P(wait > t)"]
[null,0,{"$f":"C23*EXP(-C8*C7*(1-C14)*B32)","v":0.70000000000000007}]