{"text_format":"3","workbook":"xlsx","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,"defined_names":4},"read":"whole","date_system":"1904"}

{"sheet":"Contents","index":0,"n_rows":16,"n_cols":3,"rows_kept":16}
[]
[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":16,"rows_kept":37}
["Template for M/M/s Queueing Model"]
[]
[null,null,"Data",null,null,"Results"]
[null,"l =",9,"(mean arrival rate)",null,"L =",{"$f":"IF(G10<1,G5+C4/C5,NA())","v":{"$error":"#NAME?"}}]
[null,"m =",5.3,"(mean service rate)",null,"Lq =",{"$f":"IF(G10<1,C4*C5*((C4/C5)^C6)/(FACT(C6-1)*(C6*C5-C4)^2/G12),NA())","v":{"$error":"#NAME?"}}]
[null,"s =",3,"(# servers)",{"$nulls":5},"P0 =",0.16609892355906797,"P3 =",0.09958336179222729,"P1 =",0.11029411764705876,{"$f":"K6*O6*M10","v":8.1753291895304912E-4}]
[{"$nulls":5},"W =",{"$f":"IF(G10<1,G4/C4,NA())","v":{"$error":"#NAME?"}},null,null,"P1 =",0.2820547758550211,"P4 =",0.08147729601182234,"P1 =",0.11029411764706,{"$f":"K7*M9*O7","v":1.6967664355629513E-3}]
[null,"Pr(W > t) =",{"$f":"IF((C6-1-C4/C5)=0,EXP(-C5*C9)*(1+G12*((C4/C5)^C6)/(FACT(C6)*(1-G10))*C5*C9),EXP(-C5*C9)*(1+G12*((C4/C5)^C6)/(FACT(C6)*(1-G10))*(1-EXP(-C5*C9*(C6-1-C4/C5)))/(C6-1-C4/C5)))","v":{"$error":"#NAME?"}},null,null,"Wq =",{"$f":"IF(G10<1,G5/C4,NA())","v":{"$error":"#NAME?"}},null,null,"P2 =",0.23948047006558396,"P5 =",0.06666324219149102,"P1 =",0.11029411764706,{"$f":"K8*O8*M8","v":1.7607953576596663E-3}]
[null,"when t =",1,null,{"$f":"IF(G10>=1,\"Model invalid because:\",\"\")","v":""},{"$nulls":4},"P3 =",0.13555498305599092,"P6 =",0.05454265270212902,"P1 =",0.11029411764706,{"$f":"K9*O9*M7","v":1.2181603103305866E-3}]
[{"$nulls":4},{"$f":"IF(G10>=1,\"   r   >=   1\",\"\")","v":""},"r =",{"$f":"C4/(C6*C5)","v":0.5660377358490567},null,null,"P4 =",0.07672923569207032,"P7 =",0.04462580675628738,"P1 =",0.11029411764706,{"$f":"K10*O10*M6","v":0.000842752415951978}]
[null,"Prob(Wq > t) =",{"$f":"(1-SUM(OFFSET(G12,0,0,C6,1)))*EXP(-C6*C5*(1-G10)*C12)","v":{"$error":"#NAME?"}},{"$nulls":12},{"$f":"SUM(P6:P10)","v":0.006336007438458231}]
[0,"when t =",1,null,null,"P0 =",{"$f":"IF(G10<1,1/(sumxpf(C4/C5,0,C6-1)+((C4/C5)^C6)/(FACT(C6)*(1-C4/(C6*C5)))),NA())","v":{"$error":"#NAME?"}}]
[1,{"$nulls":4},"P1 =",{"$f":"IF(G10<1,IF($C$6=1,(1-$G$10)*$G$10^ROW(G1),IF($C$6>=ROW(G1),(($C$4/$C$5)^ROW(G1))*$G$12/FACT(ROW(G1)),(($C$4/$C$5)^ROW(G1))*$G$12/(FACT($C$6)*($C$6^(ROW(G1)-$C$6))))),NA())","v":{"$error":"#NAME?"}},null,null,0.7658321060382917,0.5,0.09090909090909091,{"$f":"J13+K13+L13","v":1.3567411969473824},{"$f":"M13*60","v":81.40447181684294}]
[2,{"$nulls":4},"P2 =",{"$f":"IF(G11<1,IF($C$6=1,(1-$G$10)*$G$10^ROW(G2),IF($C$6>=ROW(G2),(($C$4/$C$5)^ROW(G2))*$G$12/FACT(ROW(G2)),(($C$4/$C$5)^ROW(G2))*$G$12/(FACT($C$6)*($C$6^(ROW(G2)-$C$6))))),NA())","v":{"$error":"#NAME?"}}]
[3,{"$nulls":4},"P3 =",{"$f":"IF(G12<1,IF($C$6=1,(1-$G$10)*$G$10^ROW(G3),IF($C$6>=ROW(G3),(($C$4/$C$5)^ROW(G3))*$G$12/FACT(ROW(G3)),(($C$4/$C$5)^ROW(G3))*$G$12/(FACT($C$6)*($C$6^(ROW(G3)-$C$6))))),NA())","v":{"$error":"#NAME?"}}]
[4,{"$nulls":4},"P4 =",{"$error":"#NAME?"}]
[5,{"$nulls":4},"P5 =",{"$error":"#NAME?"}]
[6,{"$nulls":4},"P6 =",{"$error":"#NAME?"}]
[7,{"$nulls":4},"P7 =",{"$error":"#NAME?"}]
[8,{"$nulls":4},"P8 =",{"$error":"#NAME?"}]
[9,{"$nulls":4},"P9 =",{"$error":"#NAME?"}]
[10,{"$nulls":4},"P10 =",{"$error":"#NAME?"}]
[11,{"$nulls":4},"P11 =",{"$error":"#NAME?"}]
[12,{"$nulls":4},"P12 =",{"$error":"#NAME?"}]
[13,{"$nulls":4},"P13 =",{"$error":"#NAME?"}]
[14,{"$nulls":4},"P14 =",{"$error":"#NAME?"}]
[15,{"$nulls":4},"P15 =",{"$error":"#NAME?"}]
[16,{"$nulls":4},"P16 =",{"$error":"#NAME?"}]
[17,{"$nulls":4},"P17 =",{"$f":"IF(G26<1,IF($C$6=1,(1-$G$10)*$G$10^ROW(G17),IF($C$6>=ROW(G17),(($C$4/$C$5)^ROW(G17))*$G$12/FACT(ROW(G17)),(($C$4/$C$5)^ROW(G17))*$G$12/(FACT($C$6)*($C$6^(ROW(G17)-$C$6))))),NA())","v":{"$error":"#NAME?"}}]
[18,{"$nulls":4},"P18 =",{"$f":"IF(G27<1,IF($C$6=1,(1-$G$10)*$G$10^ROW(G18),IF($C$6>=ROW(G18),(($C$4/$C$5)^ROW(G18))*$G$12/FACT(ROW(G18)),(($C$4/$C$5)^ROW(G18))*$G$12/(FACT($C$6)*($C$6^(ROW(G18)-$C$6))))),NA())","v":{"$error":"#NAME?"}}]
[19,{"$nulls":4},"P19 =",{"$f":"IF(G28<1,IF($C$6=1,(1-$G$10)*$G$10^ROW(G19),IF($C$6>=ROW(G19),(($C$4/$C$5)^ROW(G19))*$G$12/FACT(ROW(G19)),(($C$4/$C$5)^ROW(G19))*$G$12/(FACT($C$6)*($C$6^(ROW(G19)-$C$6))))),NA())","v":{"$error":"#NAME?"}}]
[20,{"$nulls":4},"P20 =",{"$error":"#NAME?"}]
[21,{"$nulls":4},"P21 =",{"$error":"#NAME?"}]
[22,{"$nulls":4},"P22 =",{"$error":"#NAME?"}]
[23,{"$nulls":4},"P23 =",{"$error":"#NAME?"}]
[24,{"$nulls":4},"P24 =",{"$error":"#NAME?"}]
[25,{"$nulls":4},"P25 =",{"$error":"#NAME?"}]

{"sheet":"Finite Queue","index":2,"n_rows":37,"n_cols":7,"rows_kept":37}
["Template for M/M/s Finite Queue Model"]
[]
[null,null,"Data",null,null,"Results"]
[null,"l =",3,"(mean arrival rate)",null,"L =",{"$f":"sumnarray(G12:G37,0,MIN(C6,C7)-1,0)+G5+MIN(C6,C7)*(1-sumarray(G12:G37,0,MIN(C6,C7)-1))","v":2}]
[null,"m =",3,"(mean service rate)",null,"Lq =",{"$f":"IF(G10=1,sumnarray(G12:G37,C6,C7,C6),G12*((C4/C5)^MIN(C6,C7))*G10/(FACT(MIN(C6,C7))*(1-G10)^2)*(1-(G10^(C7-MIN(C6,C7)))-(C7-MIN(C6,C7))*(G10^(C7-MIN(C6,C7)))*(1-G10)))","v":1.2000000000000002}]
[null,"s =",1,"(# servers)"]
[null,"K =",4,"(max customers)",null,"W =",{"$f":"G4/(C4*(1-(((C4/C5)^C7)/(FACT(MIN(C6,C7))*MIN(C6,C7)^(C7-MIN(C6,C7)))*G12)))","v":0.8333333333333333}]
[{"$nulls":5},"Wq =",{"$f":"G5/(C4*(1-(((C4/C5)^C7)/(FACT(MIN(C6,C7))*MIN(C6,C7)^(C7-MIN(C6,C7)))*G12)))","v":0.5}]
[]
[{"$nulls":5},"r =",{"$f":"C4/(MIN(C6,C7)*C5)","v":1}]
[]
[{"$nulls":5},"P0 =",{"$f":"IF(C7>=C6+1,1/(1+(sumxpf(C4/C5,1,C6)+((C4/C5)^C6)/FACT(C6)*sumxp(C4/(C6*C5),C6+1,C7))),1/(1+sumxpf(C4/C5,1,MIN(C6,C7))))","v":0.2}]
[{"$nulls":5},"P1 =",{"$f":"IF(ROW(G1)>$C$7,0,IF(ROW(G1)>=MIN($C$6,$C$7),(($C$4/$C$5)^ROW(G1))/(FACT(MIN($C$6,$C$7))*(MIN($C$6,$C$7)^(ROW(G1)-MIN($C$6,$C$7))))*$G$12,(($C$4/$C$5)^ROW(G1))/FACT(ROW(G1))*$G$12))","v":0.2}]
[{"$nulls":5},"P2 =",{"$f":"IF(ROW(G2)>$C$7,0,IF(ROW(G2)>=MIN($C$6,$C$7),(($C$4/$C$5)^ROW(G2))/(FACT(MIN($C$6,$C$7))*(MIN($C$6,$C$7)^(ROW(G2)-MIN($C$6,$C$7))))*$G$12,(($C$4/$C$5)^ROW(G2))/FACT(ROW(G2))*$G$12))","v":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}
["Template for M/M/s Finite Calling Population Model"]
[]
[null,null,"Data",null,null,"Results"]
[null,"l =",0.2,"(exponential parameter)",null,"L =",{"$f":"sumnarray(G13:G38,0,MIN(C6,C7)-1,0)+G5+MIN(C6,C7)*(1-sumarray(G13:G38,0,MIN(C6,C7)-1))","v":1.4243391066545126}]
[null,"m =",1,"(mean service rate)",null,"Lq =",{"$f":"sumnarray(G13:G38,MIN(C6,C7),C7,MIN(C6,C7))","v":0.7092069279854148}]
[null,"s =",1,"(# servers)"]
[null,"N =",5,"(size of population)",null,"W =",{"$f":"G4/(C4*(C7-G4))","v":1.9917144678138947}]
[{"$nulls":5},"Wq =",{"$f":"G5/(C4*(C7-G4))","v":0.9917144678138944}]
[]
[{"$nulls":5},"r =",{"$f":"C4*C7/(C6*C5)","v":1}]
[{"$nulls":5},"l-bar =",{"$f":"C4*(C7-G4)","v":0.7151321786690975}]
[]
[0,{"$nulls":4},"P0 =",{"$f":"1/(finitepop(C4/C5,MIN(C6,C7),C7))","v":0.28486782133090244}]
[1,{"$nulls":4},"P1 =",{"$f":"IF(ROW(G1)<=MIN($C$6,$C$7),FACT($C$7)*(($C$4/$C$5)^ROW(G1))*$G$13/(FACT($C$7-ROW(G1))*FACT(ROW(G1))),IF(ROW(G1)<=$C$7,FACT($C$7)*(($C$4/$C$5)^ROW(G1))*$G$13/(FACT($C$7-ROW(G1))*FACT($C$6)*($C$6^(ROW(G1)-$C$6))),0))","v":0.28486782133090244}]
[2,{"$nulls":4},"P2 =",{"$f":"IF(ROW(G2)<=MIN($C$6,$C$7),FACT($C$7)*(($C$4/$C$5)^ROW(G2))*$G$13/(FACT($C$7-ROW(G2))*FACT(ROW(G2))),IF(ROW(G2)<=$C$7,FACT($C$7)*(($C$4/$C$5)^ROW(G2))*$G$13/(FACT($C$7-ROW(G2))*FACT($C$6)*($C$6^(ROW(G2)-$C$6))),0))","v":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}
["Template for M/G/1 Queueing Model"]
[]
[null,null,"Data",null,null,"Results"]
[null,"l =",9,"(mean arrival rate)",null,"L =",{"$f":"IF(G10<1,G5+C4*C5,NA())","v":9.000000000000004}]
[null,"1/m =",0.1,"(expected service time)",null,"Lq =",{"$f":"IF(G10<1,((C4^2)*(C6^2)+(G10^2))/(2*(1-G10)),NA())","v":8.100000000000003}]
[null,"s =",0.1,"(standard deviation)"]
[null,"s =",1,"(# servers)",null,"W =",{"$f":"IF(G10<1,G4/C4,NA())","v":1.0000000000000004}]
[{"$nulls":5},"Wq =",{"$f":"IF(G10<1,G5/C4,NA())","v":0.9000000000000004}]
[]
[{"$nulls":3},{"$f":"IF(G10>=1,\"Model invalid because:\",\"\")","v":""},null,"r =",{"$f":"C4*C5","v":0.9}]
[{"$nulls":3},{"$f":"IF(G10>=1,\"   r   >=   1\",\"\")","v":""}]
[{"$nulls":5},"P0 =",{"$f":"IF(G10<1,1-G10,NA())","v":0.09999999999999998}]

{"sheet":"M|D|1","index":5,"n_rows":12,"n_cols":7,"rows_kept":12}
["Template for M/D/1 Queueing Model"]
[]
[null,null,"Data",null,null,"Results"]
[null,"l =",9,"(mean arrival rate)",null,"L =",{"$f":"IF(G10<1,G5+C4/C5,NA())","v":4.950000000000002}]
[null,"m =",10,"(mean service rate)",null,"Lq =",{"$f":"IF(G10<1,(G10^2)/(2*(1-G10)),NA())","v":4.050000000000002}]
[null,"s =",1,"(# servers)"]
[{"$nulls":5},"W =",{"$f":"IF(G10<1,G4/C4,NA())","v":0.5500000000000003}]
[{"$nulls":5},"Wq =",{"$f":"IF(G10<1,G5/C4,NA())","v":0.4500000000000002}]
[]
[{"$nulls":3},{"$f":"IF(G10>=1,\"Model invalid because:\",\"\")","v":""},null,"r =",{"$f":"C4/C5","v":0.9}]
[{"$nulls":3},{"$f":"IF(G10>=1,\"   r   >=   1\",\"\")","v":""}]
[{"$nulls":5},"P0 =",{"$f":"IF(G10<1,1-G10,NA())","v":0.09999999999999998}]

{"sheet":"M|E|1","index":6,"n_rows":12,"n_cols":7,"rows_kept":12}
["Template for M/E/1 Queueing Model"]
[]
[null,null,"Data",null,null,"Results"]
[null,"l =",9,"(mean arrival rate)",null,"L =",{"$f":"IF(G10<1,G5+C4/C5,NA())","v":6.975000000000002}]
[null,"m =",10,"(mean service rate)",null,"Lq =",{"$f":"IF(G10<1,(C6+1)/(2*C6)*(G10^2)/(1-G10),NA())","v":6.075000000000002}]
[null,"k =",2,"(shape parameter)"]
[null,"s =",1,"(# servers)",null,"W =",{"$f":"IF(G10<1,G4/C4,NA())","v":0.7750000000000002}]
[{"$nulls":5},"Wq =",{"$f":"IF(G10<1,G5/C4,NA())","v":0.6750000000000003}]
[]
[{"$nulls":3},{"$f":"IF(G10>=1,\"Model invalid because:\",\"\")","v":""},null,"r =",{"$f":"C4/C5","v":0.9}]
[{"$nulls":3},{"$f":"IF(G10>=1,\"   r   >=   1\",\"\")","v":""}]
[{"$nulls":5},"P0 =",{"$f":"IF(G10<1,1-G10,NA())","v":0.09999999999999998}]

{"sheet":"Nonpreemptive Priorities","index":7,"n_rows":17,"n_cols":8,"rows_kept":17}
["Template for M/M/s Nonpreemptive Priorities Queueing Model"]
[]
[]
[null,"N =",4,"(# of priority classes)"]
[null,"m =",11,"(mean service rate)"]
[null,"s =",1,"(# servers)"]
[]
[]
[null,null,"li","L","Lq","W","Wq"]
[null,{"$f":"IF($C$4>=1,\"Priority Class 1\",\"\")","v":"Priority Class 1"},{"$f":"0.05*10","v":0.5},{"$f":"IF(C4>=1,F10*C10,\"\")","v":0.08874458874458874},{"$f":"IF(C4>=1,G10*C10,\"\")","v":0.04329004329004328},{"$f":"IF(C4>=1,1/((FACT(C6)*((C5*C6)-C15)/((C15/C5)^C6)*sumxpf(C15/C5,0,C6-1)+C5*C6)*(1-C10/(C5*C6)))+1/C5,\"\")","v":0.17748917748917747},{"$f":"IF(C4>=1,F10-1/C5,\"\")","v":0.08658008658008656}]
[null,{"$f":"IF($C$4>=2,\"Priority Class 2\",\"\")","v":"Priority Class 2"},{"$f":"0.2*10","v":2},{"$f":"IF(C4>=2,F11*C11,\"\")","v":0.40590781767252354},{"$f":"IF(C4>=2,G11*C11,\"\")","v":0.22408963585434172},{"$f":"IF(C4>=2,1/((FACT(C6)*((C5*C6)-C15)/((C15/C5)^C6)*sumxpf(C15/C5,0,C6-1)+C5*C6)*(1-C10/(C5*C6))*(1-SUM(C10:C11)/(C5*C6)))+1/C5,\"\")","v":0.20295390883626177},{"$f":"IF(C4>=2,F11-1/C5,\"\")","v":0.11204481792717086}]
[null,{"$f":"IF($C$4>=3,\"Priority Class 3\",\"\")","v":"Priority Class 3"},{"$f":"0.3*10","v":3},{"$f":"IF(C4>=3,F12*C12,\"\")","v":0.9144385026737968},{"$f":"IF(C4>=3,G12*C12,\"\")","v":0.6417112299465241},{"$f":"IF(C4>=3,1/((FACT(C6)*((C5*C6)-C15)/((C15/C5)^C6)*sumxpf(C15/C5,0,C6-1)+C5*C6)*(1-SUM(C10:C11)/(C5*C6))*(1-SUM(C10:C12)/(C5*C6)))+1/C5,\"\")","v":0.3048128342245989},{"$f":"IF(C4>=3,F12-1/C5,\"\")","v":0.21390374331550802}]
[null,{"$f":"IF($C$4>=4,\"Priority Class 4\",\"\")","v":"Priority Class 4"},{"$f":"0.45*10","v":4.5},{"$f":"IF(C4>=4,F13*C13,\"\")","v":8.590909090909088},{"$f":"IF(C4>=4,G13*C13,\"\")","v":8.18181818181818},{"$f":"IF(C4>=4,1/((FACT(C6)*((C5*C6)-C15)/((C15/C5)^C6)*sumxpf(C15/C5,0,C6-1)+C5*C6)*(1-SUM(C10:C12)/(C5*C6))*(1-SUM(C10:C13)/(C5*C6)))+1/C5,\"\")","v":1.9090909090909085},{"$f":"IF(C4>=4,F13-1/C5,\"\")","v":1.8181818181818177}]
[null,{"$f":"IF($C$4>=5,\"Priority Class 5\",\"\")","v":""},null,{"$f":"IF(C4>=5,F14*C14,\"\")","v":""},{"$f":"IF(C4>=5,G14*C14,\"\")","v":""},{"$f":"IF(C4>=5,1/((FACT(C6)*((C5*C6)-C15)/((C15/C5)^C6)*sumxpf(C15/C5,0,C6-1)+C5*C6)*(1-SUM(C10:C13)/(C5*C6))*(1-SUM(C10:C14)/(C5*C6)))+1/C5,\"\")","v":""},{"$f":"IF(C4>=5,F14-1/C5,\"\")","v":""}]
[null,"l =",{"$f":"C16*C5*C6","v":10}]
[null,"r =",{"$f":"IF(C4=1,C10/(C6*C5),IF(C4=2,SUM(C10:C11)/(C5*C6),IF(C4=3,SUM(C10:C12)/(C6*C5),IF(C4=4,SUM(C10:C13)/(C5*C6),IF(C4=5,SUM(C10:C14)/(C5*C6))))))","v":0.9090909090909091},null,{"$f":"IF(C16>=1,\"Model invalid because:\",\"\")","v":""}]
[{"$nulls":4},{"$f":"IF(C16>=1,\"   r   >=   1\",\"\")","v":""},null,null,{"$f":"SUM(D10:D13)","v":9.999999999999996}]

{"sheet":"Preemptive Priorities","index":8,"n_rows":17,"n_cols":8,"rows_kept":17}
["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,{"$f":"IF($C$4>=1,\"Priority Class 1\",\"\")","v":"Priority Class 1"},1,{"$f":"IF(C4>=1,F10*C10,\"\")","v":0.14285714285714285},{"$f":"IF(C4>=1,G10*C10,\"\")","v":0.01785714285714285},{"$f":"IF(C4>=1,1/C5/(1-C10/C5),\"\")","v":0.14285714285714285},{"$f":"IF(C4>=1,F10-1/C5,\"\")","v":0.01785714285714285},{"$f":"(1-C10/(C5*C6))","v":0.875}]
[null,{"$f":"IF($C$4>=2,\"Priority Class 2\",\"\")","v":"Priority Class 2"},1,{"$f":"IF(C4>=2,F11*C11,\"\")","v":0.19047619047619047},{"$f":"IF(C4>=2,G11*C11,\"\")","v":0.06547619047619047},{"$f":"IF(C4>=2,1/C5/((1-C10/C5)*(1-SUM(C10:C11)/C5)),\"\")","v":0.19047619047619047},{"$f":"IF(C4>=2,F11-1/C5,\"\")","v":0.06547619047619047},{"$f":"(1-SUM(C10:C11)/(C5*C6))","v":0.75}]
[null,{"$f":"IF($C$4>=3,\"Priority Class 3\",\"\")","v":"Priority Class 3"},1,{"$f":"IF(C4>=3,F12*C12,\"\")","v":0.26666666666666666},{"$f":"IF(C4>=3,G12*C12,\"\")","v":0.14166666666666666},{"$f":"IF(C4>=3,1/C5/((1-SUM(C10:C11)/C5)*(1-SUM(C10:C12)/C5)),\"\")","v":0.26666666666666666},{"$f":"IF(C4>=3,F12-1/C5,\"\")","v":0.14166666666666666},{"$f":"(1-SUM(C10:C12)/(C5*C6))","v":0.625}]
[null,{"$f":"IF($C$4>=4,\"Priority Class 4\",\"\")","v":""},null,{"$f":"IF(C4>=4,F13*C13,\"\")","v":""},{"$f":"IF(C4>=4,G13*C13,\"\")","v":""},{"$f":"IF(C4>=4,1/C5/((1-SUM(C10:C12)/C5)*(1-SUM(C10:C13)/C5)),\"\")","v":""},{"$f":"IF(C4>=4,F13-1/C5,\"\")","v":""},{"$f":"(1-SUM(C10:C13)/(C5*C6))","v":0.625}]
[null,{"$f":"IF($C$4>=5,\"Priority Class 5\",\"\")","v":""},null,{"$f":"IF(C4>=5,F14*C14,\"\")","v":""},{"$f":"IF(C4>=5,G14*C14,\"\")","v":""},{"$f":"IF(C4>=5,1/C5/((1-SUM(C10:C13)/C5)*(1-SUM(C10:C14)/C5)),\"\")","v":""},{"$f":"IF(C4>=5,F14-1/C5,\"\")","v":""},{"$f":"(1-SUM(C10:C14)/(C5*C6))","v":0.625}]
[null,"l =",{"$f":"C16*C5","v":3}]
[null,"r =",{"$f":"IF(C4=1,C10/C5,IF(C4=2,SUM(C10:C11)/C5,IF(C4=3,SUM(C10:C12)/C5,IF(C4=4,SUM(C10:C13)/C5,IF(C4=5,SUM(C10:C14)/C5)))))","v":0.375},null,{"$f":"IF(C16>=1,\"Model invalid because:\",\"\")","v":""}]
[{"$nulls":4},{"$f":"IF(C16>=1,\"   r   >=   1\",\"\")","v":""}]

{"sheet":"Sheet1","index":9,"n_rows":53,"n_cols":16,"rows_kept":53}
[]
[]
[{"$nulls":7},"p0",{"$f":"1/(1+SUM(F5:F52))","v":0.2996965743482713}]
[{"$nulls":5},"cn","n",null,"pn",null,"npn"]
[{"$nulls":4},"p1",{"$f":"((9/11)^G5)/((FACT(G5))^0.2)","v":0.8181818181818182},1,null,{"$f":"F5*$I$3","v":0.24520628810313108},null,{"$f":"G5*I5","v":0.24520628810313108}]
[{"$nulls":4},"p2",{"$f":"((9/11)^G6)/((FACT(G6))^0.2)","v":0.5827652531155872},2,null,{"$f":"F6*$I$3","v":0.17465275000794472},null,{"$f":"G6*I6","v":0.34930550001588945}]
[{"$nulls":4},"p3",0.38275354589367494,3,null,0.11470992652398822,null,0.34412977957196467]
[{"$nulls":4},"p4",0.23733240970976227,4,null,0.07112771017183615,null,0.2845108406873446]
[{"$nulls":4},"p5",0.1407384851639388,5,null,0.04217884188259746,null,0.2108942094129873]
[{"$nulls":4},"p6",0.08046971188968437,6,null,0.02411649699213076,null,0.14469898195278458]
[{"$nulls":4},"p7",0.044613126797434836,7,null,0.013370401272156284,null,0.09359280890509399]
[{"$nulls":4},"p8",0.024082107436443876,8,null,7.2173251017892594E-3,null,0.057738600814314076]
[{"$nulls":4},"p9",0.01269684482734118,9,null,0.00380520089978572,null,0.03424680809807148]
[{"$nulls":4},"p10",6.5545915872569456E-3,10,null,1.9643886449529045E-3,null,0.019643886449529045]
[{"$nulls":4},"p11",0.003319838242901092,11,null,9.9494414878784142E-4,null,0.010944385636666255]
[{"$nulls":4},"p12",0.001652458260955435,12,null,4.9523608006184563E-4,null,0.005942832960742148]
[{"$nulls":4},"p13",8.0945302867949142E-4,13,null,2.4259029979107659E-4,null,3.1536738972839954E-3]
[{"$nulls":4},"p14",3.9067522371895319E-4,14,null,1.1708402623131477E-4,null,1.6391763672384068E-3]
[{"$nulls":4},"p15",1.8597194876787587E-4,15,null,5.573515597060461E-5,null,8.3602733955906916E-4]
[{"$nulls":4},"p16",8.7392320210330331E-5,16,null,2.6191178991383195E-5,null,4.1905886386213112E-4]
[{"$nulls":4},"p17",4.057264394630942E-5,17,null,1.2159482402961059E-5,null,0.000206711200850338]
[{"$nulls":4},"p18",1.8622099079966652E-5,18,null,5.5809793014401e-06,null,1.0045762742592181E-4]
[{"$nulls":4},"p19",8.4552749982145326E-6,19,null,2.5340169521374809E-6,null,4.8146322090612139E-5]
[{"$nulls":4},"p20",3.7998947028441245E-6,20,null,1.1388154253265265E-6,null,2.277630850653053E-5]
[{"$nulls":4},"p21",1.6911320784253803E-6,21,null,5.0682649067455853E-7,null,1.064335630416573E-5]
[{"$nulls":4},"p22",7.45663380960865e-07,22,null,2.2347276089092123E-7,null,4.9164007396002671E-6]
[{"$nulls":4},"p23",3.2587202005307462E-7,23,null,{"$f":"F27*$I$3","v":9.7662728085857627E-8},null,2.2462427459747254E-6]
[{"$nulls":4},"p24",1.4120648704266287E-7,24,null,4.2319100442439622E-8,null,1.0156584106185509E-6]
[{"$nulls":4},"p25",6.0689906898502e-08,25,null,1.8188557194996569E-8,null,4.5471392987491424E-7]
[{"$nulls":4},"p26",2.5880438232270567E-8,26,null,7.756278680843519E-9,null,2.016632457019315E-7]
[{"$nulls":4},"p27",1.0953393687746964E-8,27,null,3.2826945657057434E-9,null,8.8632753274055076E-8]
[{"$nulls":4},"p28",4.6022151253186994E-9,28,null,1.3792681074718143E-9,null,3.86195070092108e-08]
[{"$nulls":4},"p29",1.9201587695799773E-9,29,null,5.754650054479108e-10,null,1.6688485157989415E-8]
[{"$nulls":4},"p30",7.957244696746065e-10,30,null,2.3847589768657443E-10,null,7.1542769305972327E-9]
[{"$nulls":4},"p31",3.2759721343311053E-10,31,null,9.81797626319427e-11,null,3.043572641590224E-9]
[{"$nulls":4},"p32",1.3401704185899952E-10,32,null,4.016444834943103e-11,null,1.2852623471817931E-9]
[{"$nulls":4},"p33",5.448877745243999E-11,33,null,1.633009994292159e-11,null,5.388932981164125e-10]
[{"$nulls":4},"p34",2.2022220399139177E-11,34,null,6.599984013164631e-12,null,2.2439945644759745E-10]
[{"$nulls":4},"p35",8.849063675249434e-12,35,null,2.652034069661979e-12,null,9.282119243816925e-11]
[{"$nulls":4},"p36",3.5357914743927297E-12,36,null,1.0596645924853244E-12,null,3.8147925329471676E-11]
[{"$nulls":4},"p37",1.4050640555306332E-12,37,null,4.2109288418241997E-13,null,1.5580436714749538E-11]
[{"$nulls":4},"p38",5.553787116891085e-13,38,null,1.6644509735918203E-13,null,6.324913699648917e-12]
[{"$nulls":4},"p39",2.183866727404432e-13,39,null,6.544973770362783e-14,null,2.5525397704414854E-12]
[{"$nulls":4},"p40",8.544053470751674e-14,40,null,2.5606235562327345E-14,null,1.0242494224930937E-12]
[{"$nulls":4},"p41",3.326266259968283e-14,41,null,9.968706034827308e-15,null,4.0871694742791966E-13]
[{"$nulls":4},"p42",1.2887152766561695E-14,42,null,3.8622355372413876E-15,null,1.6221389256413827E-13]
[{"$nulls":4},"p43",4.969504748481453e-15,43,null,1.489343549327359E-15,null,6.404177262107643e-14]
[{"$nulls":4},"p44",1.9075344889192914E-15,44,null,5.716815517802921e-16,null,2.5153988278332853E-14]
[{"$nulls":4},"p45",7.289197548297858e-16,45,null,2.1845475349726858E-16,null,9.830463907377086e-15,{"$nulls":3},"L",{"$f":"SUM(K5:K52)","v":1.8073005849149892}]
[{"$nulls":4},"p46",2.773179482379096e-16,46,null,8.311123909219273e-17,null,3.823116998240866e-15,{"$nulls":3},"L/lambda",{"$f":"P49/9","v":0.20081117610166546}]
[{"$nulls":4},"p47",1.050529448465166E-16,47,null,3.148400769569891e-17,null,1.4797483616978487E-15,{"$nulls":4},{"$f":"P50*60","v":12.048670566099927}]
[{"$nulls":4},"p48",3.9628698368492867E-17,48,null,1.187658514691824e-17,null,5.700760870520755e-16]
[{"$nulls":14},"W-Wo,3",{"$f":"0.5*60-P51","v":17.95132943390007}]

{"sheet":"Module1","index":10,"n_rows":0,"n_cols":0,"rows_kept":0,"hidden":true}