OfficeHelp - Office Tutorials & Software Solutions
Search:
 
Advanced Search

 
Get FREE PC TIPS every month:

More Information Here

Most Popular

What's available for:
Calendars
Privacy & Security
Excel
Outlook
Word
PowerPoint
Internet Explorer
Others


Get all OfficeHelp.Biz CALENDARS at once!

Interested in more than one of our Microsoft® Excel® Calendars? Don't want the hassle of paying per purchase? Want to SAVE TIME AND MONEY?


Other Contents
Design Chart Templates for Microsoft® Excel®
Automatically update hundreds of PowerPoint slides from Excel in minutes
Quickly and easily generate your own Org Charts in Excel
Easily make your own home and office calendars for Microsoft® Excel®!
Calendar Templates with Holidays (USA / UK / Australia / Canada) for Excel
Make stylish Planner Calendars - CUSTOM Version
Calendar Templates 2007 with Holidays for Excel
Make stylish Planner Calendars - ADVANCED Version
All TEMPLATES at once!
Make stylish Planner Calendars
Make stylish Planner Calendars - BASIC Version
Calendar Plan - Year Planner Template
How long the wait?

How to Buy
How safe it is to buy
Privacy Policy
Contact Us

RSS Feed OfficeHelp.Biz RSS Feed
Home Calendars Bundles Macros PC Tips Templates Newsletter Contact Us

Specializing in Advanced Spreadsheet & Office Macro Solutions.


Content Type Application Author Price
Macro Microsoft Excel OfficeHelp 0.95 USD

Queue Servicing Calculator - Version 1.00

Tested on Microsoft Excel Versions: 2000 (9.0), XP (10.0) - should work on any version from Office 97

(How to Buy)

 
Forecast waiting times, dimension the number of "processors" for the expected "customers", for both service of manufacturing processes.


Do you work on a service running waiting queues? 

Calculates the average waiting times and people (or item) processing times based on some input estimates. Can be used to make service capacity simulations or to measure the service throughput on any service or process demanding waiting queues.

Really easy to use, just fill in the values in the Input Cells and check the results on the Output area, immediately. Change the inputs to see the effect of each change. It uses a mathematical formulae and a lookup table to calculate the output values based on the inputs given.

Queue Servicing Calculator Screen Shot

Screen Shot from the Excel File (Click to Enlarge)

What does it do?

Using as input the 

  • Number of Servers (like service desks);
  • Service rate (customers served by time unit);
  • Arrival rate (customer arrival rate to the end of the queue);

This Excel file will calculate the following:

  • Utilization factor: % of the service capacity being used. Systems are usually considered stressed when they breach the 80% utilization level;
  • Mean number of "customers "in the system: total number of "customers" waiting and being served;
  • Mean number of waiting "customers": number of "customers" waiting to be served
  • Mean waiting time, on the selected unit;

Note that the word "customers" may be people or products waiting processing by the system, which may be a service or manufacturing or any other form of process. The time unit may be freely selected.

Results are immediate and displayed as soon as any input value changes. The excel document is pre-formatted for printing, pressing the print button is all it's need to print the results.

Are there limitations?

Only one. The calculations use a lockup table that has intervals of values. Input values have therefore to be approximated to the nearest table value and so results are approximate, not absolute. But, unless you require a high level of precision, in which case this is not the software for the job, the results should be close enough. 

For this reason, the number of servers inputted is limited to: 1, 2, 3, 4, 5 and 10. The input cell is formatted so that only valid values will be accepted.

Are there security implications? 

No. Technically, there is no macro code in this file, only a specially prepared Excel sheet with formulas to calculate its Outputs from the values you input. For a general overview of Macro security issues, read this article.

Simulation Tip:

To make really useful simulations, change just one input value each time. Register (the easiest way is printing) the output values, then change one (and just one) of the input values to get the new results. Register them again. Compare the effect of each change, to assess the impact of each input variable on the processing capacity of your system. You'll get a good idea on what's need to be done to improve capacity or reduce waiting time and what is the consequences of changes on each of the input parameters.

What do I get after purchase?

After payment at PayPal, you will get to a confirmation page with a link to download a XLS file containing a Microsoft® Excel file. Click on this link and save the file to your own hard drive. Just open it with Excel every time you want to use it.

Losing sales? Still guessing how long you customers will wait? Spending hundreds on specialized software you don't know how to use?

This easy to use Excel macro will calculate waiting times and service capacity. No need to learn new software skills. Start now by using one of the BUY NOW buttons.

(How to Buy)


Get FREE PC TIPS every month:

 


Queue Servicing Calculator - Version 1.00

Tested on Microsoft Excel Versions: 2000 (9.0), XP (10.0) - should work on any version from Office 97

(How to Buy)

Back
Other Contents  

00052- Design Chart Templates for Microsoft® Excel® Microsoft Excel Templates
The easiest way to create design charts. Check the samples, enter your own data and watch as your charts update. Multiple different charts from the same data, with many automatic calculations made for you. No code, macros, formulas or other complicated stuff. Just fill in YOUR data and watch the charts update automatically.
 
00054- Automatic Copy/Paste for Microsoft PowerPoint® Microsoft Excel Macro
Automatically update hundreds of Microsoft PowerPoint® slides, charts and tables from Excel in minutes. With the click on a button. Easily configure the updates you need. Copy from multiple Excel files. Resize and place pasted charts & tables – or just keep their original size & position.
 
00051- Organization Chart Maker for Microsoft® Excel® Microsoft Excel Macro
Quickly and easily generate your own organization charts from a plain list of data with Organization Chart Maker for Microsoft® Excel®. Apply colors and formats. Integrate external data from ERP or HR management systems like or Microsoft® Dynamics Navision, SAP®, PeopleSoft®, Oracle®, etc. Chart Stock & Portfolio listings, team members planning & company ownership charts.
 
00037- Traditional Calendars for Excel Microsoft Excel Macro
Easily generate annual and monthly Traditional & Planning calendars you can print and distribute, based only in Microsoft® Excel®. Five different formats available. Use special colors for special days or events, like holidays or meetings. Automatic event legend. Configurable background and font colors. Optional calendar background image. Traditional, Academic and Fiscal years. Imports data from Microsoft ® Outlook®.
 
00047- Calendar Templates 2014 with Holidays (USA / UK / Australia / Canada) for Excel Microsoft Excel Templates
Yearly, Monthly and Weekly Calendar templates (2 each) for Microsoft® Excel®. Includes versions with Holidays for the USA, UK, Australia and Canada.
 
00044- Custom GANTT Charts for Microsoft® Excel® Microsoft Excel Macro
Generate CUSTOM Project style calendar plans with the EXCLUSIVE option to customize our COPYRIGHT messages to create YOUR own REBRANDED Edition. Includes all ADVANCED Edition features plus the REBRANDING option. Distribute CORPORATE versions to your staff.
 
00027- Get all OfficeHelp.Biz CALENDARS at once! Microsoft Excel Bundles
Interested in more than one of our Microsoft® Excel® Calendars? Don't want the hassle of paying per purchase? Want to SAVE TIME AND MONEY?
 
00046- Calendar Templates 2007 with Holidays for Excel Microsoft Excel Templates
Yearly, Monthly and Weekly Calendar templates (2 each) for 2007 in Excel. Include USA Holidays.
 
00002- Calendar Plan Generator - ADVANCED Edition Microsoft Excel Macro
Generate ADVANCED Project style calendar plans, just by entering the tasks and associated data like its name and the starting and end date. Use different colors and select a deadline terminator for each task. Indent each task to its level or sub-level. Change, save and email the resulting calendar as any other regular Microsoft® Excel® file. Includes ADVANCED features like EXTRA plan types, detail filtering, optional fields, extra information of task bars, full customization and Microsoft® Outlook® integration.
 
00040- Get all OfficeHelp.Biz TEMPLATES at once! Microsoft Excel Bundles
Interested in more than one of our Templates, including all Excel Calendar Templates? Don't want the hassle of paying per purchase? Want to SAVE TIME AND MONEY?
 
00036- Calendar Plan Generator - Source Code Edition Microsoft Excel Macro
Generate Project style calendar plans (weekly only), just by entering the tasks and associated data like it's name and the starting and end date. Use different colors and select a deadline terminator for each task. Indent each task to its level or sub-level. Change, save and email the resulting calendar as any other regular Microsoft® Excel file. SOURCE CODE available for changes for VBA Macro developers.
 
00043- Calendar Plan Generator - BASIC Edition Microsoft Excel Macro
Easily generate Project style calendar plans, just by entering the tasks and associated data like it's name and the starting and end date. Use different colors and select a deadline terminator for each task. Indent each task to its level or sub-level. Change, save and email the resulting calendar as any other regular Microsoft® Excel file. The SIMPLEST edition, just ONE button to use!
 
00028- Calendar Plan - Year Planner Template Microsoft Excel Templates
Create pretty yearlong planning calendars in minutes. Save time and effort. Ready to use calendar template! Really useful to set yearlong event like general meetings, special groups, holidays and all other long-term schedules. Regular Excel file, sample included.
 
00001- Queue Servicing Calculator Microsoft Excel Macro
Calculates the average waiting times and people (or item) processing times based on some input estimates. Can be used to make service capacity simulations or to measure the service throughput on any service or process demanding waiting queues.
 

Privacy Policy How to Buy How safe is it to Buy? RSS Feed Contact Us

(c) 2004 - 2024 OfficeHelp.Biz