{"text_format":"1","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,"images":0,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Module1","index":10,"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":"Contents","index":0,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[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,"cut":false,"hidden":false,"merged":[]}
["Template for M/M/s Queueing Model"]
[]
[null,null,"Data",null,null,"Results"]
[null,"l =",60,"(mean arrival rate)",null,"L =",{"$f":"IF(G10<1,G5+C4/C5,NA())","v":2.8888888888888888}]
[null,"m =",30,"(mean service rate)",null,"Lq =",{"$f":"IF(G10<1,C4*C5*((C4/C5)^C6)/(FACT(C6-1)*(C6*C5-C4)^2/G12),NA())","v":0.88888888888888884}]
[null,"s =",3,"(# servers)"]
[null,null,null,null,null,"W =",{"$f":"IF(G10<1,G4/C4,NA())","v":4.8148148148148148E-2}]
[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":1.341259292200425E-12},null,null,"Wq =",{"$f":"IF(G10<1,G5/C4,NA())","v":1.4814814814814814E-2}]
[null,"when t =",1,null,{"$f":"IF(G10>=1,\"Model invalid because:\",\"\")","v":""}]
[null,null,null,null,{"$f":"IF(G10>=1,\"   r   >=   1\",\"\")","v":""},"r =",{"$f":"C4/(C6*C5)","v":0.66666666666666663}]
[null,"Prob(Wq > t) =",{"$f":"(1-SUM(OFFSET(G12,0,0,C6,1)))*EXP(-C6*C5*(1-G10)*C12)","v":4.1589435417067293E-14}]
[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":0.1111111111111111}]
[1,null,null,null,null,"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":0.22222222222222221}]
[2,null,null,null,null,"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":0.22222222222222221}]
[3,null,null,null,null,"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":0.14814814814814814}]
[4,null,null,null,null,"P4 =",9.8765432098765427E-2]
[5,null,null,null,null,"P5 =",6.5843621399176946E-2]
[6,null,null,null,null,"P6 =",4.38957475994513E-2]
[7,null,null,null,null,"P7 =",2.9263831732967534E-2]
[8,null,null,null,null,"P8 =",1.9509221155311691E-2]
[9,null,null,null,null,"P9 =",1.3006147436874459E-2]
[10,null,null,null,null,"P10 =",8.6707649579163062E-3]
[11,null,null,null,null,"P11 =",5.7805099719442045E-3]
[12,null,null,null,null,"P12 =",3.8536733146294693E-3]
[13,null,null,null,null,"P13 =",2.5691155430863132E-3]
[14,null,null,null,null,"P14 =",1.7127436953908754E-3]
[15,null,null,null,null,"P15 =",1.1418291302605836E-3]
[16,null,null,null,null,"P16 =",7.6121942017372236E-4]
[17,null,null,null,null,"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":5.0747961344914827E-4}]
[18,null,null,null,null,"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":3.3831974229943216E-4}]
[19,null,null,null,null,"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":2.2554649486628811E-4}]
[20,null,null,null,null,"P20 =",1.5036432991085875E-4]
[21,null,null,null,null,"P21 =",1.0024288660723916E-4]
[22,null,null,null,null,"P22 =",6.6828591071492767E-5]
[23,null,null,null,null,"P23 =",4.4552394047661847E-5]
[24,null,null,null,null,"P24 =",2.9701596031774567E-5]
[25,null,null,null,null,"P25 =",1.9801064021183045E-5]

{"sheet":"Finite Queue","index":2,"n_rows":37,"n_cols":7,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["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.83333333333333326}]
[null,null,null,null,null,"Wq =",{"$f":"G5/(C4*(1-(((C4/C5)^C7)/(FACT(MIN(C6,C7))*MIN(C6,C7)^(C7-MIN(C6,C7)))*G12)))","v":0.5}]
[]
[null,null,null,null,null,"r =",{"$f":"C4/(MIN(C6,C7)*C5)","v":1}]
[]
[null,null,null,null,null,"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}]
[null,null,null,null,null,"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}]
[null,null,null,null,null,"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}]
[null,null,null,null,null,"P3 =",0.2]
[null,null,null,null,null,"P4 =",0.2]
[null,null,null,null,null,"P5 =",0]
[null,null,null,null,null,"P6 =",0]
[null,null,null,null,null,"P7 =",0]
[null,null,null,null,null,"P8 =",0]
[null,null,null,null,null,"P9 =",0]
[null,null,null,null,null,"P10 =",0]
[null,null,null,null,null,"P11 =",0]
[null,null,null,null,null,"P12 =",0]
[null,null,null,null,null,"P13 =",0]
[null,null,null,null,null,"P14 =",0]
[null,null,null,null,null,"P15 =",0]
[null,null,null,null,null,"P16 =",0]
[null,null,null,null,null,"P17 =",0]
[null,null,null,null,null,"P18 =",0]
[null,null,null,null,null,"P19 =",0]
[null,null,null,null,null,"P20 =",0]
[null,null,null,null,null,"P21 =",0]
[null,null,null,null,null,"P22 =",0]
[null,null,null,null,null,"P23 =",0]
[null,null,null,null,null,"P24 =",0]
[null,null,null,null,null,"P25 =",0]

{"sheet":"Finite Calling Population","index":3,"n_rows":38,"n_cols":7,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["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.70920692798541485}]
[null,"s =",1,"(# servers)"]
[null,"N =",5,"(size of population)",null,"W =",{"$f":"G4/(C4*(C7-G4))","v":1.9917144678138947}]
[null,null,null,null,null,"Wq =",{"$f":"G5/(C4*(C7-G4))","v":0.99171446781389438}]
[]
[null,null,null,null,null,"r =",{"$f":"C4*C7/(C6*C5)","v":1}]
[null,null,null,null,null,"l-bar =",{"$f":"C4*(C7-G4)","v":0.71513217866909751}]
[]
[0,null,null,null,null,"P0 =",{"$f":"1/(finitepop(C4/C5,MIN(C6,C7),C7))","v":0.28486782133090244}]
[1,null,null,null,null,"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,null,null,null,null,"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.22789425706472199}]
[3,null,null,null,null,"P3 =",0.13673655423883319]
[4,null,null,null,null,"P4 =",5.469462169553329E-2]
[5,null,null,null,null,"P5 =",1.093892433910666E-2]
[6,null,null,null,null,"P6 =",0]
[7,null,null,null,null,"P7 =",0]
[8,null,null,null,null,"P8 =",0]
[9,null,null,null,null,"P9 =",0]
[10,null,null,null,null,"P10 =",0]
[11,null,null,null,null,"P11 =",0]
[12,null,null,null,null,"P12 =",0]
[13,null,null,null,null,"P13 =",0]
[14,null,null,null,null,"P14 =",0]
[15,null,null,null,null,"P15 =",0]
[16,null,null,null,null,"P16 =",0]
[17,null,null,null,null,"P17 =",0]
[18,null,null,null,null,"P18 =",0]
[19,null,null,null,null,"P19 =",0]
[20,null,null,null,null,"P20 =",0]
[21,null,null,null,null,"P21 =",0]
[22,null,null,null,null,"P22 =",0]
[23,null,null,null,null,"P23 =",0]
[24,null,null,null,null,"P24 =",0]
[25,null,null,null,null,"P25 =",0]

{"sheet":"M|G|1","index":4,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Template for M/G/1 Queueing Model"]
[]
[null,null,"Data",null,null,"Results"]
[null,"l =",3,"(mean arrival rate)",null,"L =",{"$f":"IF(G10<1,G5+C4*C5,NA())","v":1.1625000000000005}]
[null,"1/m =",0.2,"(expected service time)",null,"Lq =",{"$f":"IF(G10<1,((C4^2)*(C6^2)+(G10^2))/(2*(1-G10)),NA())","v":0.56250000000000033}]
[null,"s =",0.1,"(standard deviation)"]
[null,"s =",1,"(# servers)",null,"W =",{"$f":"IF(G10<1,G4/C4,NA())","v":0.38750000000000018}]
[null,null,null,null,null,"Wq =",{"$f":"IF(G10<1,G5/C4,NA())","v":0.18750000000000011}]
[]
[null,null,null,{"$f":"IF(G10>=1,\"Model invalid because:\",\"\")","v":""},null,"r =",{"$f":"C4*C5","v":0.60000000000000009}]
[null,null,null,{"$f":"IF(G10>=1,\"   r   >=   1\",\"\")","v":""}]
[null,null,null,null,null,"P0 =",{"$f":"IF(G10<1,1-G10,NA())","v":0.39999999999999991}]

{"sheet":"M|D|1","index":5,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Template for M/D/1 Queueing Model"]
[]
[null,null,"Data",null,null,"Results"]
[null,"l =",20,"(mean arrival rate)",null,"L =",{"$f":"IF(G10<1,G5+C4/C5,NA())","v":1.333333333333333}]
[null,"m =",30,"(mean service rate)",null,"Lq =",{"$f":"IF(G10<1,(G10^2)/(2*(1-G10)),NA())","v":0.66666666666666652}]
[null,"s =",1,"(# servers)"]
[null,null,null,null,null,"W =",{"$f":"IF(G10<1,G4/C4,NA())","v":6.6666666666666652E-2}]
[null,null,null,null,null,"Wq =",{"$f":"IF(G10<1,G5/C4,NA())","v":3.3333333333333326E-2}]
[]
[null,null,null,{"$f":"IF(G10>=1,\"Model invalid because:\",\"\")","v":""},null,"r =",{"$f":"C4/C5","v":0.66666666666666663}]
[null,null,null,{"$f":"IF(G10>=1,\"   r   >=   1\",\"\")","v":""}]
[null,null,null,null,null,"P0 =",{"$f":"IF(G10<1,1-G10,NA())","v":0.33333333333333337}]

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

{"sheet":"Nonpreemptive Priorities","index":7,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["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,{"$f":"IF($C$4>=1,\"Priority Class 1\",\"\")","v":"Priority Class 1"},1,{"$f":"IF(C4>=1,F10*C10,\"\")","v":0.5},{"$f":"IF(C4>=1,G10*C10,\"\")","v":0.25},{"$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.5},{"$f":"IF(C4>=1,F10-1/C5,\"\")","v":0.25}]
[null,{"$f":"IF($C$4>=2,\"Priority Class 2\",\"\")","v":"Priority Class 2"},2,{"$f":"IF(C4>=2,F11*C11,\"\")","v":2.5},{"$f":"IF(C4>=2,G11*C11,\"\")","v":2},{"$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":1.25},{"$f":"IF(C4>=2,F11-1/C5,\"\")","v":1}]
[null,{"$f":"IF($C$4>=3,\"Priority Class 3\",\"\")","v":""},null,{"$f":"IF(C4>=3,F12*C12,\"\")","v":""},{"$f":"IF(C4>=3,G12*C12,\"\")","v":""},{"$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":""},{"$f":"IF(C4>=3,F12-1/C5,\"\")","v":""}]
[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/((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":""},{"$f":"IF(C4>=4,F13-1/C5,\"\")","v":""}]
[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":3}]
[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.75},null,{"$f":"IF(C16>=1,\"Model invalid because:\",\"\")","v":""}]
[null,null,null,null,{"$f":"IF(C16>=1,\"   r   >=   1\",\"\")","v":""}]

{"sheet":"Preemptive Priorities","index":8,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["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":1.7857142857142849E-2},{"$f":"IF(C4>=1,1/C5/(1-C10/C5),\"\")","v":0.14285714285714285},{"$f":"IF(C4>=1,F10-1/C5,\"\")","v":1.7857142857142849E-2},{"$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":6.5476190476190466E-2},{"$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":6.5476190476190466E-2},{"$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":""}]
[null,null,null,null,{"$f":"IF(C16>=1,\"   r   >=   1\",\"\")","v":""}]

{"sheet":"Sheet1","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}