{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Explanation","Report","Summary"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":20,"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":"Explanation","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Report","index":1,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Multiple Server Queueing Simulation"]
[]
["Inputs",null,null,null,"Time between arrivals (min)","Probaility","Lbound","Ubound"]
["Time Unit","minutes",null,null,1,0.18,0,{"$f":"F4+G4","v":0.18}]
["Customer Arrival Rate",{"$f":"LOOKUP(RAND(),G4:G8,E4:E8)","v":5},"customers/minutes",null,2,0.2,{"$f":"H4","v":0.18},{"$f":"F5+G5","v":0.38}]
["Mean Service Time",{"$f":"LOOKUP(RAND(),G11:G14,E11:E14)","v":7},"minutes/customer",null,3,0.22,{"$f":"H5","v":0.38},{"$f":"F6+G6","v":0.6}]
["Number of Servers",3,null,null,4,0.25,{"$f":"H6","v":0.6},{"$f":"F7+G7","v":0.85}]
["Maximum allowed in queue",10,null,null,5,0.15,{"$f":"H7","v":0.85},{"$f":"F8+G8","v":1}]
["Simulation run time",200,"minutes"]
["Number of Iterations",2,null,null,"Service Time (mins)","Probability","Lbound","Ubound"]
[null,null,null,null,4,0.25,0,{"$f":"F11+G11","v":0.25}]
[null,null,null,null,5,0.25,{"$f":"H11","v":0.25},{"$f":"F12+G12","v":0.5}]
[null,null,null,null,6,0.25,{"$f":"H12","v":0.5},{"$f":"F13+G13","v":0.75}]
["Time last customer leaves",234.2099609375,null,null,7,0.25,{"$f":"H13","v":0.75},{"$f":"F14+G14","v":1}]
[]
["Metrics"]
["Average Time in Queue per Customer",19.059841156005859]
["Maximum Time in Queue of all Customers",36.837699890136719]
["Average Number of Customers in Queue",8.9517202377319336]
["Maximum Number in Queue",10,null,null,"Measure of System Congestion"]
[null,null,null,null,"Traffic Intensity",{"$f":"ArrivalRate/(nServers/MeanServiceTime)","v":11.666666666666668}]
["Percentage of Time Servers are Busy",0.96759170293807983]
[]
["Number of Customers Processed",110]
["Number of Customers Turned Away",840]
["Percentage of Customers Turned Away",{"$f":"nLost/(nLost+NServed)","v":0.88421052631578945}]
[null,0]

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