{"text_format":"3","workbook":"xls","n_sheets":11,"sheets":["Contents","M|M|s","Finite Queue","Finite Calling Population","M|G|1","M|D|1","M|E|1","Nonpreemptive Priorities","Preemptive Priorities","Sheet1","Module1"],"not_rendered":{"charts":3,"macros":1,"external_links":1,"defined_names":9},"unopened":[{"sheet":"Module1","index":10,"reason":"not_a_worksheet"}],"read":"whole","date_system":"1904","formulas":"cached_only"}

{"sheet":"Contents","index":0,"n_rows":16,"n_cols":3,"rows_kept":16,"flags":["formulas_cached_only"]}
[]
[null,null,"Ch. 17 - Queueing Theory"]
[]
[]
[null,"Contents:"]
[null,null,"Template for M/M/s Model"]
[null,null,"Template for M/M/s Finite Queue Model"]
[null,null,"Template for M/M/s Finite Calling Population Model"]
[null,null,"Template for M/G/1 Model"]
[null,null,"Template for M/D/1 Model"]
[null,null,"Template for M/E/1 Model"]
[null,null,"Template for M/M/s Nonpreemptive Priorities Model"]
[null,null,"Template for M/M/s Preemptive Priorities Model"]
[]
[]
[null,"Click on the tab below to select the worksheet of your choice."]

{"sheet":"M|M|s","index":1,"n_rows":37,"n_cols":7,"rows_kept":37,"flags":["formulas_cached_only"]}
["Template for M/M/s Queueing Model"]
[]
[null,null,"Data",null,null,"Results"]
[null,"l =",60,"(mean arrival rate)",null,"L =",2.888888888888889]
[null,"m =",30,"(mean service rate)",null,"Lq =",0.8888888888888888]
[null,"s =",3,"(# servers)"]
[{"$nulls":5},"W =",0.04814814814814815]
[null,"Pr(W > t) =",1.341259292200425e-12,null,null,"Wq =",0.014814814814814814]
[null,"when t =",1,null,""]
[{"$nulls":4},"","r =",0.6666666666666666]
[null,"Prob(Wq > t) =",4.158943541706729e-14]
[0,"when t =",1,null,null,"P0 =",0.1111111111111111]
[1,{"$nulls":4},"P1 =",0.2222222222222222]
[2,{"$nulls":4},"P2 =",0.2222222222222222]
[3,{"$nulls":4},"P3 =",0.14814814814814814]
[4,{"$nulls":4},"P4 =",0.09876543209876543]
[5,{"$nulls":4},"P5 =",0.06584362139917695]
[6,{"$nulls":4},"P6 =",0.0438957475994513]
[7,{"$nulls":4},"P7 =",0.029263831732967534]
[8,{"$nulls":4},"P8 =",0.01950922115531169]
[9,{"$nulls":4},"P9 =",0.01300614743687446]
[10,{"$nulls":4},"P10 =",0.008670764957916306]
[11,{"$nulls":4},"P11 =",0.0057805099719442045]
[12,{"$nulls":4},"P12 =",0.0038536733146294693]
[13,{"$nulls":4},"P13 =",0.002569115543086313]
[14,{"$nulls":4},"P14 =",0.0017127436953908754]
[15,{"$nulls":4},"P15 =",0.0011418291302605836]
[16,{"$nulls":4},"P16 =",0.0007612194201737224]
[17,{"$nulls":4},"P17 =",0.0005074796134491483]
[18,{"$nulls":4},"P18 =",0.00033831974229943216]
[19,{"$nulls":4},"P19 =",0.0002255464948662881]
[20,{"$nulls":4},"P20 =",0.00015036432991085875]
[21,{"$nulls":4},"P21 =",0.00010024288660723916]
[22,{"$nulls":4},"P22 =",6.682859107149277e-05]
[23,{"$nulls":4},"P23 =",4.455239404766185e-05]
[24,{"$nulls":4},"P24 =",2.9701596031774567e-05]
[25,{"$nulls":4},"P25 =",1.9801064021183045e-05]

{"sheet":"Finite Queue","index":2,"n_rows":37,"n_cols":7,"rows_kept":37,"flags":["formulas_cached_only"]}
["Template for M/M/s Finite Queue Model"]
[]
[null,null,"Data",null,null,"Results"]
[null,"l =",3,"(mean arrival rate)",null,"L =",2]
[null,"m =",3,"(mean service rate)",null,"Lq =",1.2000000000000002]
[null,"s =",1,"(# servers)"]
[null,"K =",4,"(max customers)",null,"W =",0.8333333333333333]
[{"$nulls":5},"Wq =",0.5]
[]
[{"$nulls":5},"r =",1]
[]
[{"$nulls":5},"P0 =",0.2]
[{"$nulls":5},"P1 =",0.2]
[{"$nulls":5},"P2 =",0.2]
[{"$nulls":5},"P3 =",0.2]
[{"$nulls":5},"P4 =",0.2]
[{"$nulls":5},"P5 =",0]
[{"$nulls":5},"P6 =",0]
[{"$nulls":5},"P7 =",0]
[{"$nulls":5},"P8 =",0]
[{"$nulls":5},"P9 =",0]
[{"$nulls":5},"P10 =",0]
[{"$nulls":5},"P11 =",0]
[{"$nulls":5},"P12 =",0]
[{"$nulls":5},"P13 =",0]
[{"$nulls":5},"P14 =",0]
[{"$nulls":5},"P15 =",0]
[{"$nulls":5},"P16 =",0]
[{"$nulls":5},"P17 =",0]
[{"$nulls":5},"P18 =",0]
[{"$nulls":5},"P19 =",0]
[{"$nulls":5},"P20 =",0]
[{"$nulls":5},"P21 =",0]
[{"$nulls":5},"P22 =",0]
[{"$nulls":5},"P23 =",0]
[{"$nulls":5},"P24 =",0]
[{"$nulls":5},"P25 =",0]

{"sheet":"Finite Calling Population","index":3,"n_rows":38,"n_cols":7,"rows_kept":38,"flags":["formulas_cached_only"]}
["Template for M/M/s Finite Calling Population Model"]
[]
[null,null,"Data",null,null,"Results"]
[null,"l =",0.2,"(exponential parameter)",null,"L =",1.4243391066545126]
[null,"m =",1,"(mean service rate)",null,"Lq =",0.7092069279854148]
[null,"s =",1,"(# servers)"]
[null,"N =",5,"(size of population)",null,"W =",1.9917144678138947]
[{"$nulls":5},"Wq =",0.9917144678138944]
[]
[{"$nulls":5},"r =",1]
[{"$nulls":5},"l-bar =",0.7151321786690975]
[]
[0,{"$nulls":4},"P0 =",0.28486782133090244]
[1,{"$nulls":4},"P1 =",0.28486782133090244]
[2,{"$nulls":4},"P2 =",0.227894257064722]
[3,{"$nulls":4},"P3 =",0.13673655423883319]
[4,{"$nulls":4},"P4 =",0.05469462169553329]
[5,{"$nulls":4},"P5 =",0.01093892433910666]
[6,{"$nulls":4},"P6 =",0]
[7,{"$nulls":4},"P7 =",0]
[8,{"$nulls":4},"P8 =",0]
[9,{"$nulls":4},"P9 =",0]
[10,{"$nulls":4},"P10 =",0]
[11,{"$nulls":4},"P11 =",0]
[12,{"$nulls":4},"P12 =",0]
[13,{"$nulls":4},"P13 =",0]
[14,{"$nulls":4},"P14 =",0]
[15,{"$nulls":4},"P15 =",0]
[16,{"$nulls":4},"P16 =",0]
[17,{"$nulls":4},"P17 =",0]
[18,{"$nulls":4},"P18 =",0]
[19,{"$nulls":4},"P19 =",0]
[20,{"$nulls":4},"P20 =",0]
[21,{"$nulls":4},"P21 =",0]
[22,{"$nulls":4},"P22 =",0]
[23,{"$nulls":4},"P23 =",0]
[24,{"$nulls":4},"P24 =",0]
[25,{"$nulls":4},"P25 =",0]

{"sheet":"M|G|1","index":4,"n_rows":12,"n_cols":7,"rows_kept":12,"flags":["formulas_cached_only"]}
["Template for M/G/1 Queueing Model"]
[]
[null,null,"Data",null,null,"Results"]
[null,"l =",3,"(mean arrival rate)",null,"L =",1.1625000000000003]
[null,"1/m =",0.2,"(expected service time)",null,"Lq =",0.5625000000000002]
[null,"s =",0.1,"(standard deviation)"]
[null,"s =",1,"(# servers)",null,"W =",0.3875000000000001]
[{"$nulls":5},"Wq =",0.18750000000000008]
[]
[{"$nulls":3},"",null,"r =",0.6000000000000001]
[{"$nulls":3},""]
[{"$nulls":5},"P0 =",0.3999999999999999]

{"sheet":"M|D|1","index":5,"n_rows":12,"n_cols":7,"rows_kept":12,"flags":["formulas_cached_only"]}
["Template for M/D/1 Queueing Model"]
[]
[null,null,"Data",null,null,"Results"]
[null,"l =",20,"(mean arrival rate)",null,"L =",1.333333333333333]
[null,"m =",30,"(mean service rate)",null,"Lq =",0.6666666666666665]
[null,"s =",1,"(# servers)"]
[{"$nulls":5},"W =",0.06666666666666665]
[{"$nulls":5},"Wq =",0.033333333333333326]
[]
[{"$nulls":3},"",null,"r =",0.6666666666666666]
[{"$nulls":3},""]
[{"$nulls":5},"P0 =",0.33333333333333337]

{"sheet":"M|E|1","index":6,"n_rows":12,"n_cols":7,"rows_kept":12,"flags":["formulas_cached_only"]}
["Template for M/E/1 Queueing Model"]
[]
[null,null,"Data",null,null,"Results"]
[null,"l =",1,"(mean arrival rate)",null,"L =",1]
[null,"m =",2,"(mean service rate)",null,"Lq =",0.5]
[null,"k =",1,"(shape parameter)"]
[null,"s =",1,"(# servers)",null,"W =",1]
[{"$nulls":5},"Wq =",0.5]
[]
[{"$nulls":3},"",null,"r =",0.5]
[{"$nulls":3},""]
[{"$nulls":5},"P0 =",0.5]

{"sheet":"Nonpreemptive Priorities","index":7,"n_rows":17,"n_cols":7,"rows_kept":17,"flags":["formulas_cached_only"]}
["Template for M/M/s Nonpreemptive Priorities Queueing Model"]
[]
[]
[null,"N =",2,"(# of priority classes)"]
[null,"m =",4,"(mean service rate)"]
[null,"s =",1,"(# servers)"]
[]
[]
[null,null,"li","L","Lq","W","Wq"]
[null,"Priority Class 1",1,0.5,0.25,0.5,0.25]
[null,"Priority Class 2",2,2.5,2,1.25,1]
[null,"",null,"","","",""]
[null,"",null,"","","",""]
[null,"",null,"","","",""]
[null,"l =",3]
[null,"r =",0.75,null,""]
[{"$nulls":4},""]

{"sheet":"Preemptive Priorities","index":8,"n_rows":17,"n_cols":8,"rows_kept":17,"flags":["formulas_cached_only"]}
["Template for M/M/s Preemptive Priorities Queueing Model"]
[]
[]
[null,"N =",3,"(# of priority classes)"]
[null,"m =",8,"(mean service rate)"]
[null,"s =",1,"(# servers)"]
[]
[]
[null,null,"li","L","Lq","W","Wq"]
[null,"Priority Class 1",1,0.14285714285714285,0.01785714285714285,0.14285714285714285,0.01785714285714285,0.875]
[null,"Priority Class 2",1,0.19047619047619047,0.06547619047619047,0.19047619047619047,0.06547619047619047,0.75]
[null,"Priority Class 3",1,0.26666666666666666,0.14166666666666666,0.26666666666666666,0.14166666666666666,0.625]
[null,"",null,"","","","",0.625]
[null,"",null,"","","","",0.625]
[null,"l =",3]
[null,"r =",0.375,null,""]
[{"$nulls":4},""]

{"sheet":"Sheet1","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}