Queuing Theory
- Thread starter rfear
- Start date
Anyone tried applying this in MSAccess ?I am currently using an add-in to excel, ( Queueing Toolpak 4.0 : http://www.business.ualberta.ca/aingolfsson/QTP/ ) to analyse the work arriving and leaving a department. From this I can calculate the level of service plus various other queuing variables, like resource utilisation.
Up to now my analysis has required converting data from an access database into excel and applying the toolpak, I want to use the original data and bin excel to save me time.
Bearing in mind the owner of the access database knows nothing about queuing theory so anything I do needs to be simple ( as far as the user is concerned ).
Up to now my analysis has required converting data from an access database into excel and applying the toolpak, I want to use the original data and bin excel to save me time.
Bearing in mind the owner of the access database knows nothing about queuing theory so anything I do needs to be simple ( as far as the user is concerned ).
jwhite
Software Developer
- Local time
- Yesterday, 23:31
- Joined
- Sep 24, 2006
- Messages
- 141
A thought... Why don't you ask Armann directly if it is compatible with MS Access????? I believe he would give you the best answer. And if the DB Owner (usually NOT a user) knows nothing about the Queuing Theory, why not teach him/her?
- Local time
- Yesterday, 22:31
- Joined
- Feb 28, 2001
- Messages
- 30,498
Mathematically, either Access or Excel have all the math support tools you need to do a queue analysis. In the sense that your formulas for the analysis will not use anything that could not be quickly implemented in Access or Excel. The worst item you ever run into is a probability distribution computation, which can be implemented as a telescoped or programmed power series. It's all just statistics. Though it has been a while since I played with it, I don't recall anything that wouldn't be available in any standard math library on any language you could name.
Agree with Doc Man. I recently wrote a database that tracked trouble cause and resolution. Queuing theory was incorporated to provide performance measurement feedback. Another subset of the application was to provide root cause analysis, forecasting theory and apply those algorithms for predictions.
Our current plan is to periodically optimize the algorithms based on analysis of collected data since each piece of equipment has its own MTBF rate which is influenced by other local variables. For the implementation of queuing portion, we started by using standard classroom formulas and storage in arrays. As we began getting more detailed in the development, we found ourselves writing to temp tables and such. We verified our algorithms and the mathematics with MatLab and Maple just to be sure (the formula design was in Matlab). It started out as a proof-of-concept but it will work. This application has only been in production for 8 months so can't attest to longevity.
-dK
Our current plan is to periodically optimize the algorithms based on analysis of collected data since each piece of equipment has its own MTBF rate which is influenced by other local variables. For the implementation of queuing portion, we started by using standard classroom formulas and storage in arrays. As we began getting more detailed in the development, we found ourselves writing to temp tables and such. We verified our algorithms and the mathematics with MatLab and Maple just to be sure (the formula design was in Matlab). It started out as a proof-of-concept but it will work. This application has only been in production for 8 months so can't attest to longevity.
-dK
