LinkBack URL
About LinkBacks
I want to simulate queuing system with priorities.can anybody help me how to define customers entertime .if one or more customer are in que,customer will make desicion(probability 50%) to buy apriority ticket so he will be the first one in que.
I want to simulate queuing system with priorities.can anybody help me how to define customers entertime .if one or more customer are in que,customer will make desicion(probability 50%) to buy apriority ticket so he will be the first one in que.
sorry mate i have no idea what you mean, perhaps a sample workbook with some input and expected output would be a start
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
i dont want you to solve this problem this is the problem
http://aksup.ir/images/vpafwvo0ml248hanwrsw.jpg
Last edited by bampoor; 08-02-2010 at 11:00 AM.
ok ive seen that and it means absolutely nothing to me, we can help you fix a problem with excel functions but i havent the faintest idea how to do that model
Is this a homework assignment? If so, you're welcome to ask questions when you get stuck on a specific problem, but we won't do your homework for you.
cheers
yes this is my homework but i have worked on it but there is some problem on enter and exit time after buying tickets lets look it.
Last edited by teylyn; 08-03-2010 at 08:09 AM. Reason: removed quote
Well, for a start, column B appears to be 4 minutes + (between 0 and 6 minutes), shouldn't it be 8+-2?
CC
If you feel really indebted please consider a donation to charity. My preferred charity is ActionAid but there are plenty of worthy alternatives.
yes it was my fault....but i have no idea about column k&l
Last edited by teylyn; 08-03-2010 at 08:07 AM. Reason: removed quote
Moving along... should the first entry in column C be ~8 minutes past midnight, or another time?
we must solve this problem for 6 hours its not important from 10am or another time!!!
Last edited by teylyn; 08-03-2010 at 08:07 AM. Reason: removed quote
bampoor, please stop quoting whole posts. It's just clutter and creates clean-up work for the moderators. Use the Quick Reply box or the "Post Reply" button, NOT the Quote button to reply. Thanks.
Last edited by teylyn; 08-03-2010 at 08:18 AM.
A valid point...
Moving along...
If someone buys a queue-jump ticket wouldn't that affect the start time of anyone else behind them?
Does your model accomodate there ever being more than one person in the queue?
if someone buys ticket it must affect the start time of anyone behind,the point is here how can i change it for example if customer 4 buys ticket,start time of customer 3 or maybe 2 must be change(it cant happen in this problem) so we must check how many customers are in the queue and then change?
so can i change k3 by writing formula in k5??
I would suggest that as your other columnds rely on column D that the logic in column K ought to be incorporated into column D - just an idea.
you mean i must have one start time?i have to think about but it must be harder!!!
can i change k3 by writing formula in k5??have you any idea?
I agree (that does make it harder), but how can someone start if the person behind them has bought a queue-jump ticket? The start time must be affected by the queue...
To be honest, what I don't understand is the incredibly low statistical probability of a queue building up enough for anyone to buy a queue-jump ticket anyway - with one punter in the show, you'd need two waiting - one queuing whilst another arrived - before you could get a queue-jump (your logic is not quite right there) - if the queue is only one person, he's not going to buy a queue-jump ticket!
You've made a very good and logical start, keep going and upload your next example when you've had a chance ot do a bit more.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks