Build a queueing analytics tool
$8-15 AUD / hour
We are developing a large scale medical practice.
The task required is to use excel to develop and analyse queueing lengths for a large multifaceted medical practice.
We have gone as far as we can with our limited knowledge of excel and need help to finish the writing of this programme which will use standard probability analysis to determine staff numbers, bottlenecks and queue lengths and time. This information will initially help the determination of the business case.
The successful candidate will need to complete the reception area queueing task to demonstrate capability. The successful candidate will then use a process flow chart provided by us to integrate up to another 7 separate steps to analyse queue lengths.
The attached excel spreadsheet contains an arrival time probability and a reception time probability using a random number generator. In this initial case we have a single service, multiple server queue. The initial task is to develop a macro that allows us to vary the number of servers and then show the queue lengths.
The complication then increases as we add multi-service and multi-server operations to the process flow.
We look forward to your input and interest in building this analytical tool for us.
Project ID: #17481035
About the project
Awarded to:
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered twenty four excel vba projects in the past one twenty days. Willing to take up your project. Thank you, Regards.
13 freelancers are bidding on average $23/hour for this job
Hello, I can help with you in your project Build a queueing analytics tool I have more than 5 years of experience in Data Processing, Excel, Mathematics, Statistical Analysis, Statistics. We have worked on severa More
Hello, Excel expert at your service. Please check my past reviews for your reference. Looking forward for your reply so that I can start with the implementation.
Hi I am a very experienced statistician, data scientist and academic writer. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several comp More
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards
I have a good hands on working with Advanced R and Python and BI tools and technologies, AI, Big Data. I have quite a good knowledge of DL/ML Algorithm , have also developed Dashboards and Web Application. My area of e More
hi! let me help you with your project. I am very interested and excited in building this tool and make it realized. I have created a tool but in Human Resource (Competency Development tool). thanks