Excel discrete event simulation - Part 1

Closed

I want to create a 10 station linear process simulation in which the process runs for a certain number of intervals. The process gets a certain amount of customer transactions as inputs and these pass through the process steps and become final output to the customer.

At the setup stage, the user can fill in the input boxes at the start of the simulation.

Input parameters at each station

(inputs can be made by the user in boxes that accept numerical inputs and/or drop downs selections that user can choose from)

1. Station name

2. Number of people

3. Reject Rate (to the previous station): what percentage of the output from the previous stage has to go back to the previous stage for rework.

4. Processing Time + distribution (how much time in interval units does it take to process a transaction by a person on this station)

5. Transaction Discharge pattern: After work is finished it goes into the output queue. The transaction discharge pattern is how it will flow from the output queue of this station to the input queue of the next station

Output at each station (Updated every interval)

1. Amount in input queue

2. WIP (how many are people working on)

3. Output Queue (how many are finished processing but are not yet gone into the input queue of the next station)

4. Defects (how many cases were rejected and came back from the next stage)

5. Idle time

Overall Customer input

Pattern of arrival from the customer (after how many intervals do new transactions come from the customer. What distribution do they follow?

Customer Output

1. Graphical display of output to the customer every interval

2. Graphical display of the average time an application spends in the system from the time the customer puts it in the queue to hen it goes back to the customer

I also need a timer that is updated every interval and goes on till the end of the simulation run time

At the setup stage, the user will fill in all the setup parameters and also:

Simulation Run time: how long will the simulation run

Updating interval: after how long will the simulation show an update (so if a simulation runs for 100 seconds, and updating interval is 10 seconds, then every 10 units the graph and data will upload)

The user control once the simulation is set up will be to:

Run

Pause and modify the parameters

Continue

Reset (create new process parameters)

I want to be clear that:

1. I will own the source code of the file

2. This is only part 1 of the project and I wlll work with you to create future versions with more features

3. The programmer must be experienced in Excel, VBA and should have experience doing Excel based applications using object oriented approach..

4. WE ABSOLUTELY NEED TO HAVE A GREAT LOOKING GUI, FOR THE INPUTS, OUTPUTS, CHARTS ETC. EVERYTHING MUST LOOK VERY NEAT, GRAPHICAL AND VISUAL

If I select you, then I will also work with you to refine the scope and also the exact deliverables from this project

Skills: Excel, Mathematics, Visual Basic, Visual Basic for Apps

See more: discrete event simulation excel, discrete event simulation using excel, vba discrete event simulation, discrete simulation excel, excel discrete event simulation, run discrete event simulation excel, excel discrete, visual work flow, vba excel programmer, programmer excel vba, part of graph, part of a graph, need of excel programmer, i need a vba programmer, how to create graph, how to create a graph, how do you graph data, graph part, create a linear graph, work flow charts, what is vba in excel, excel vba or, excel vba long, excel 2013 vba, end vba

Project ID: #4630365

18 freelancers are bidding on average $197 for this job

samitXI

Kindly check your inbox. Thanks

$206 USD in 2 days
(62 Reviews)
5.9
northwolves

Not very sure what you need.Provide more details to see if I can help you.

$150 USD in 5 days
(49 Reviews)
5.0
DenisSmolentsev

Hello! I will do this with interest and pleasure. Let me propose you all the best of my experience with Excel and VBA. Thanks!

$277 USD in 7 days
(47 Reviews)
4.8
bchandra1955

Professional engineer here, ..................................

$184 USD in 7 days
(16 Reviews)
4.0
ioanaprof

Excel and VBA expert at your service.

$222 USD in 10 days
(17 Reviews)
3.8
eduardoaguilarh

HI, i can do it

$200 USD in 5 days
(2 Reviews)
3.2
drevak

Dear friend, I have a great deal of experience in simulation using different types of software. Could you kindly check your PM.

$200 USD in 10 days
(2 Reviews)
3.0
JScottArnold

Good afternoon- I am a statistical and analytical consultant with years of experience working with Excel tools in VBA. I have created both a lobby simulation tool and a basketball simulation tool, the latter being focu More

$250 USD in 7 days
(1 Review)
2.8
ankurb43

I have excel VBA programming experience with 6+ years and strong foundation of mathematics. Have solved similar problems in the past

$250 USD in 3 days
(1 Review)
2.8
vaibhav585

Hi I am interested in this work lets discuss on this work in detail

$114 USD in 5 days
(5 Reviews)
2.5
ednriu

Sir, I have experience in VBA projects. You can be sure glad after I set You the final result.

$277 USD in 7 days
(3 Reviews)
2.5
domenicoF79

It's look a nice project. I'll glad work on for you. Please check me PM.

$170 USD in 14 days
(1 Review)
0.0
MonjoyNath

sir , i m a Statistics department student & very expert .

$50 USD in 5 days
(0 Reviews)
0.0
Flipn77

I have 8 years of VBA experience from working in the federal government. This project sounds enjoyable because there is a technical aspect, yet it is visually oriented. I have an idea in mind of how to lay out both t More

$150 USD in 3 days
(0 Reviews)
0.0
ihsconsult

Hi, I am very experienced with Excel and VBA, having developed applications and projects that specifically deal with process control, as this one does. Please, contact me and we will get the program developed per yo More

$333 USD in 7 days
(1 Review)
2.4
madhusudan1026

Hi I am working as a data scientist and proficient in VBA, MS-Office tools. And ready to work and deliver in time

$66 USD in 7 days
(0 Reviews)
0.0
Amzathkhan

Hi, Nice project.. I can do this.. Plz, check your PM..

$277 USD in 3 days
(0 Reviews)
0.0
sansri7680vw

I am an expert in VBA and can work on OO programming. I have created a regression testing tool in VBA which even got me an award in the company I am working in. So I would be the best option if you need a mix of excell More

$155 USD in 10 days
(0 Reviews)
0.0
pmayans

I'm new to Freelancer.com but I'm a Systems Engineer and I have so many years in Excel / VBA expertise. I hope you can give me the oportunity to start offering my services to the Freelancer.com comunity. I like your pr More

$130 USD in 5 days
(0 Reviews)
0.0