Table of Contents

• Online Help File
• Reporting of Bugs, Suggestions for Improvement, Errata
• Templates, Tips, and Other Resources
• References

Online Help File

Click here to access the online version of the help file.

Reporting of Bugs, Suggestions for improvement, Errata

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.

Bugs found in QTP 4.0: None, so far.

Templates, Tips, and Other Resources

• 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).

References

• Assumptions page in the help file
• 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.
• Ingolfsson, A., L. Tang.  2012.  Efficient and Reliable Computation of Birth-Death Process Performance Measures.  INFORMS Journal on Computing 24(1): 29-41. 
  Describes some of the algorithms used for the MMS functions in QTP.
• Whitt, W. 1993. Approximations for the GI/G/m Queue. Production and Operations Management 2(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 Research 52(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.

Address: http://queueingtoolpak.org/support.shtml
Last Update: 2 June 2014
Updated By: Armann.Ingolfsson@UAlberta.ca
©2003-14 Armann Ingolfsson