{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["GlobalCost","WaitCost"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"GlobalCost","index":0,"n_rows":38,"n_cols":13,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["2017-05-13",null,"Hillier & Lieberman, 2005, 8.th ed., p 814-816",null,null,null,null,null,"With Visual Basic",null,null,null,"*"]
["03Mar2008","Queues",null,"\"Acme Machine Shop\"",null,null,null,"See \"WaitCost\"",null,null,null,null,"*"]
["Cs =",23,"$ / server / hour",null,"a =",9.5,"customers / hour",null,null,null,"Global cost",null,"*"]
["Cw =",17,"$ / hour",null,"m =",4.8,"customers / hour",null,null,null,null,null,"*"]
["s ? ",null,null,null,null,null,null,null,null,null,"Min:",null,"*"]
[null,null,"p0iQ","p0iS",null,null,null,"L","E(ServC)","E(WaitC)",{"$f":"MIN(K9:K12)","v":116.97366443474371},null,"*"]
[null,null,"(sy)s/","(sum)",null,null,null,null,"E(SC) =","E(WC) =","EG(C) =",null,"*"]
["s","y","[s!(1-y)] ","S","p0",null,"Lq","L","Css","CwL","Css + CwL",null,"*"]
[2,{"$f":"$F$3/(A9*$F$4)","v":0.98958333333333337},{"$f":"(A9*B9)^A9/(FACT(A9)*(1-B9))","v":188.02083333333402},{"$f":"1+summation(A9*B9,A9-1)","v":2.979166666666667},{"$f":"1/(C9+D9)","v":5.2356020942408189E-3},null,{"$f":"$E9*$A9^$A9*$B9^($A9+1)/(FACT($A9)*(1-$B9)^2)","v":93.518215532286547},{"$f":"$G9+$A9*$B9","v":95.497382198953218},{"$f":"$B$3*$A9","v":46},{"$f":"$B$4*$H9","v":1623.4554973822046},{"$f":"$I9+$J9","v":1669.4554973822046},null,"*"]
[{"$f":"A9+1","v":3},0.65972222222222232,3.7971894486961477,{"$f":"1+summation(A10*B10,A10-1)","v":4.9377170138888893},0.11448319501569759,null,{"$f":"$E10*$A10^$A10*$B10^($A10+1)/(FACT($A10)*(1-$B10)^2)","v":0.84281359420061019},{"$f":"$G10+$A10*$B10","v":2.821980260867277},69,{"$f":"$B$4*$H10","v":47.973664434743711},116.97366443474371,null,"*"]
[4,0.49479166666666669,1.2654579670447135,{"$f":"1+summation(A11*B11,A11-1)","v":6.2298162012924383},0.13341740109045977,null,0.16535299741722301,2.1445196640838899,92,36.456834289426126,128.45683428942613,null,"*"]
[5,0.39583333333333331,0.41886476890506558,{"$f":"1+summation(A12*B12,A12-1)","v":6.8691361117264851},0.13721183852455074,null,3.7654858470961283E-2,2.0168215251376278,115,34.285965927339674,149.28596592733967,null,"*"]
[6,0.32986111111111116,0.12456524593409514,{"$f":"1+summation(A13*B13,A13-1)","v":7.1222002429399662},0.13799259842688399,null,8.4609470788202887E-3,1.9876276137454874,138,33.789669433673282,171.78966943367328,null,"*"]
[7,0.28273809523809523,3.2905483290134152E-2,{"$f":"1+summation(A14*B14,A14-1)","v":7.2056762584444085},0.13814860917221269,null,1.7919312917584838E-3,1.980958597958425,161,33.676296165293223,194.67629616529322,null,"*"]
[8,0.24739583333333334,7.7583934742917063E-3,{"$f":"1+summation(A15*B15,A15-1)","v":7.2292781080662021},0.13817810643723263,null,3.5240073124878201E-4,1.9795190673979155,184,33.651824145764564,217.65182414576458,null,"*"]
[40,4.9479166666666664E-2,9.3258410335986443E-37,{"$f":"1+summation(A16*B16,A16-1)","v":7.2367098801496024},{"$f":"EXP(-$F$3/$F$4)","v":0.13818434296267892},null,{"$f":"$E16*$A16^$A16*$B16^($A16+1)/(FACT($A16)*(1-$B16)^2)","v":6.7082244110252596E-39},{"$f":"$G16+$A16*$B16","v":1.9791666666666665},920,{"$f":"$B$4*$H16","v":33.645833333333329},953.64583333333337,null,"*"]
[null,null,null,null,null,null,null,null,null,null,null,null,"*"]
["Example",null,null,null,null,null,null,null,null,null,null,null,"*"]
["s =",{"$f":"A14","v":7},"y =",{"$f":"B14","v":0.28273809523809523},null,null,null,null,null,null,null,null,"*"]
["s y =",{"$f":"B19*D19","v":1.9791666666666665},null,null,null,null,null,null,null,null,null,null,"*"]
["S =",{"$f":"1+summation(B20,A14-1)","v":7.2056762584444085},"USER DEFINED",null,null,null,null,null,null,null,null,null,"*"]
["See DEVELOPER / Visual Basic",null,null,null,null,null,null,null,null,null,null,null,"*"]
["instead of tableau below",null,null,null,null,null,null,null,null,null,null,null,"*"]
[null,null,null,null,null,null,null,null,null,null,null,null,"*"]
[null,null,null,null,null,null,null,null,null,null,null,null,"*"]
[null,null,null,null,null,null,null,null,null,null,null,null,"*"]
[null,null,null,null,null,null,null,null,null,null,null,null,"*"]
["TABLEAU","n =",0,{"$f":"C28+1","v":1},2,3,4,5,6,7,"S",null,"*"]
[null,"S0s-1[(sy)n/n!] :",{"$f":"($A9*$B9)^C$28/FACT(C$28)","v":1},1.9791666666666667,null,null,null,null,null,null,{"$f":"SUM(C29:J29)","v":2.979166666666667},null,"*"]
[null,null,1,1.979166666666667,{"$f":"($A10*$B10)^E$28/FACT(E$28)","v":1.9585503472222228},null,null,null,null,null,{"$f":"SUM(C30:J30)","v":4.9377170138888893},null,"*"]
[null,null,1,1.9791666666666667,1.9585503472222223,{"$f":"($A11*$B11)^F$28/FACT(F$28)","v":1.2920991874035495},null,null,null,null,6.2298162012924383,null,"*"]
[null,null,1,1.9791666666666665,1.9585503472222219,{"$f":"($A12*$B12)^F$28/FACT(F$28)","v":1.292099187403549},{"$f":"($A12*$B12)^G$28/FACT(G$28)","v":0.63931991043404768},null,null,null,6.8691361117264851,null,"*"]
[null,null,1,1.979166666666667,1.9585503472222228,{"$f":"($A13*$B13)^F$28/FACT(F$28)","v":1.2920991874035499},{"$f":"($A13*$B13)^G$28/FACT(G$28)","v":0.63931991043404823},{"$f":"($A13*$B13)^H$28/FACT(H$28)","v":0.25306413121347743},null,null,7.1222002429399653,null,"*"]
[null,null,1,1.9791666666666665,1.9585503472222219,{"$f":"($A14*$B14)^F$28/FACT(F$28)","v":1.292099187403549},{"$f":"($A14*$B14)^G$28/FACT(G$28)","v":0.63931991043404768},{"$f":"($A14*$B14)^H$28/FACT(H$28)","v":0.25306413121347721},{"$f":"($A14*$B14)^I$28/FACT(I$28)","v":8.3476015504445597E-2},null,7.2056762584444085,null,"*"]
[null,null,1,1.9791666666666667,1.9585503472222223,{"$f":"($A15*$B15)^F$28/FACT(F$28)","v":1.2920991874035495},{"$f":"($A15*$B15)^G$28/FACT(G$28)","v":0.6393199104340479},{"$f":"($A15*$B15)^H$28/FACT(H$28)","v":0.25306413121347732},{"$f":"($A15*$B15)^I$28/FACT(I$28)","v":8.3476015504445639E-2},{"$f":"($A15*$B15)^J$28/FACT(J$28)","v":2.3601849621792667E-2},7.2292781080662021,null,"*"]
[null,null,null,null,null,null,null,null,null,null,null,null,"*"]
[]
["*","*","*","*","*","*","*","*","*","*","*","*"]

{"sheet":"WaitCost","index":1,"n_rows":25,"n_cols":11,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["03Mar2008",null,"Hillier & Lieberman, 2005, 8.th ed., p 814-816",null,null,null,null,"See the corresponding course webpage, possibly:"]
["Queues",null,"\"Acme Machine Shop\"",null,null,null,null,"http://web.ist.utl.pt/~mcasquilho/compute/or/Fx-queues.php"]
["Cs =",23,"$ / server / hour",null,"a =",9.5,"customers / hour",null,null,"Wait cost"]
["Cw =",17,"$ / hour",null,"m =",4.8,"customers / hour",null,null,"Smaller ($):",{"$f":"K9-GlobalCost!K9","v":-79.166666666666515}]
["s ? ",null,null,null,null,null,null,null,null,"Min:",{"$f":"MIN(K9:K12)","v":37.806997768077032}]
[null,null,"p0iQ","p0iS",null,null,null,null,"E(ServC)","E(WaitC)"]
[null,null,"(sy)s/","(sum)",null,"Idle =",null,null,"E(SC) =","E(WC) =","EW(C) ="]
["s","y","[s!(1-y)] ","S","p0","s(1 - y)","Lq",null,"CsIdle","CwLq","... + ..."]
[2,{"$f":"$F$3/(A9*$F$4)","v":0.98958333333333337},{"$f":"(A9*B9)^A9/(FACT(A9)*(1-B9))","v":188.02083333333402},{"$f":"K19","v":2.979166666666667},{"$f":"1/(C9+D9)","v":5.2356020942408189E-3},{"$f":"$A9*(1-$B9)","v":2.0833333333333259E-2},{"$f":"$E9*$A9^$A9*$B9^($A9+1)/(FACT($A9)*(1-$B9)^2)","v":93.518215532286547},null,{"$f":"$B$3*$F9","v":0.47916666666666496},{"$f":"$B$4*$G9","v":1589.8096640488714},{"$f":"$I9+$J9","v":1590.2888307155381}]
[{"$f":"A9+1","v":3},0.65972222222222232,3.7971894486961477,4.9377170138888893,0.11448319501569759,{"$f":"$A10*(1-$B10)","v":1.020833333333333},0.84281359420061019,null,{"$f":"$B$3*$F10","v":23.479166666666661},{"$f":"$B$4*$G10","v":14.327831101410373},37.806997768077032]
[4,0.49479166666666669,1.2654579670447135,6.2298162012924383,0.13341740109045977,2.020833333333333,0.16535299741722301,null,46.479166666666657,{"$f":"$B$4*$G11","v":2.8110009560927911},49.290167622759448]
[5,0.39583333333333331,0.41886476890506558,6.8691361117264851,0.13721183852455074,3.0208333333333339,3.7654858470961283E-2,null,69.479166666666686,0.64013259400634182,70.119299260673031]
[6,0.32986111111111116,0.12456524593409514,7.1222002429399653,0.13799259842688402,4.020833333333333,8.4609470788202905E-3,null,92.479166666666657,0.14383610033994493,92.623002767006597]
[7,0.28273809523809523,3.2905483290134152E-2,7.2056762584444085,0.13814860917221269,5.020833333333333,1.7919312917584838E-3,null,115.47916666666666,3.0462831959894222E-2,115.50962949862655]
[8,0.24739583333333334,7.7583934742917063E-3,7.2292781080662021,0.13817810643723263,6.020833333333333,3.5240073124878201E-4,null,138.47916666666666,5.9908124312292943E-3,138.48515747909789]
[40,4.9479166666666664E-2,9.3258410335986443E-37,{"$f":"EXP($F$3/$F$4)","v":7.236709880149605},{"$f":"EXP(-$F$3/$F$4)","v":0.13818434296267892},38.020833333333336,6.7082244110252596E-39,null,874.47916666666674,1.1403981498742941E-37,874.47916666666674]
[]
[null,"n =",0,{"$f":"C18+1","v":1},2,3,4,5,6,7]
[null,"S0s-1[(sy)n/n!] :",{"$f":"($A9*$B9)^C$18/FACT(C$18)","v":1},1.9791666666666667,null,null,null,null,null,null,{"$f":"SUM(C19:J19)","v":2.979166666666667}]
[null,null,1,1.979166666666667,{"$f":"($A10*$B10)^E$18/FACT(E$18)","v":1.9585503472222228},null,null,null,null,null,4.9377170138888893]
[null,null,1,1.9791666666666667,1.9585503472222223,{"$f":"($A11*$B11)^F$18/FACT(F$18)","v":1.2920991874035495},null,null,null,null,6.2298162012924383]
[null,null,1,1.9791666666666665,1.9585503472222219,{"$f":"($A12*$B12)^F$18/FACT(F$18)","v":1.292099187403549},{"$f":"($A12*$B12)^G$18/FACT(G$18)","v":0.63931991043404768},null,null,null,6.8691361117264851]
[null,null,1,1.979166666666667,1.9585503472222228,{"$f":"($A13*$B13)^F$18/FACT(F$18)","v":1.2920991874035499},{"$f":"($A13*$B13)^G$18/FACT(G$18)","v":0.63931991043404823},{"$f":"($A13*$B13)^H$18/FACT(H$18)","v":0.25306413121347743},null,null,7.1222002429399653]
[null,null,1,1.9791666666666665,1.9585503472222219,{"$f":"($A14*$B14)^F$18/FACT(F$18)","v":1.292099187403549},{"$f":"($A14*$B14)^G$18/FACT(G$18)","v":0.63931991043404768},{"$f":"($A14*$B14)^H$18/FACT(H$18)","v":0.25306413121347721},{"$f":"($A14*$B14)^I$18/FACT(I$18)","v":8.3476015504445597E-2},null,7.2056762584444085]
[null,null,1,1.9791666666666667,1.9585503472222223,{"$f":"($A15*$B15)^F$18/FACT(F$18)","v":1.2920991874035495},{"$f":"($A15*$B15)^G$18/FACT(G$18)","v":0.6393199104340479},{"$f":"($A15*$B15)^H$18/FACT(H$18)","v":0.25306413121347732},{"$f":"($A15*$B15)^I$18/FACT(I$18)","v":8.3476015504445639E-2},{"$f":"($A15*$B15)^J$18/FACT(J$18)","v":2.3601849621792667E-2},7.2292781080662021]