I hope the ToolPak has few bugs, but as with any software, I am certain that it has
some. Please e-mail me at Armann.Ingolfsson@UAlberta.ca
if you think you have found a bug, or if you have suggestions for improving the ToolPak.
If you discover a new bug I will list it below and eventually I will also fix it, I hope! I might also offer to buy you a cup of
coffee if we ever meet. Oh, and you also get a free copy of the ToolPak---but then
you get that regardless of whether you find a bug or not.
The
Template 2 June 2014.xlsx Excel workbook illustrates
the use of the QTP 4.0 functions. QTP 4.0 must be loaded for the template
to work. Tested with Excel 2010.
The
vbaExample 2 June 2014.xlsm Excel workbook illustrates how QTP 4.0 functions can be called
from VBA code. Tested with Excel 2010.
Tip for international users: The QTP help file assumes that arguments to
an Excel function are separated by commas, for example, QTPMMS_L(A1,A2,A3), as
is the case when US or Canadian settings are used in Excel. In other
countries, a different argument separator might be used, for example a
semicolon, as in QTPMMS_L(A1;A2;A3).
Graduate-level textbook on queueing theory: Gross, D., J. F. Shortle, J.
M. Thompson, C. M. Harris. 2008. Fundamentals of Queueing
Theory, 4th Edition, John Wiley & Sons.
Whitt, W. 1993. Approximations for the GI/G/m Queue. Production and
Operations Management2(2): 114-161.
Equation 2.24 is used for QTPGGS_Wq. QTPGGS_W, QTPGGS_Lq, and QTPGGS_L are
then determined from QTPGGS_W = QTPGGS_Wq + 1/(Service Rate), QTPGGS_Lq =
(Arrival Rate) * QTPGGS_Wq, and QTPGGS_L = (Arrival Rate) * QTPGGS_W.
Whitt, W. 2004. A Diffusion Approximations for the G/GI/n/m Queue.
Operations Research52(6): 922-941.
Equations 1.1, 4.8, and 4.12 are used for QTPGGS_PrWait.
If you have developed teaching materials that use QTP 4.0 that you are
willing to share or if you have tips on how to use it, then e-mail me at Armann.Ingolfsson@UAlberta.ca
to have them listed here.