M
Michael H.
I'm very fluent with VB / VBA however having some difficulty with the
statistics/logic.
I'm hoping someone here can point me in a direction to solve the
following...
I'm developing a model in excel to run simulations against. One
aspect involves randomly identifying ranges of days/dates within a 365
day calendar year.
Example:
Name Days Vacation
========= ===========
Employee 1 14
Employee 2 28
Employee 3 21
Based on the above I'm trying to generate a yearly work schedule that
identifies/applies random vacation days in the amounts specified in
the list. Ideally I'd like some way of weighting the randomization to
better reflect how vacation is taken (eg, in a 2 week block with an
occasional day here and there, rather than completely random.)
Using the data above as an example, I can easily create a list of 14
random yearly dates for Employee 1. The challenge I'm having creating
logic to randomize into blocks of days (eg, 5 consecutive days, 1 day,
1 day, 5 consecutive days, 3 consecutive days)
If anyone has any ideas/insight into the logic required I'd appreciate
hearing from you.
Thanks in advance.
- Michael
statistics/logic.
I'm hoping someone here can point me in a direction to solve the
following...
I'm developing a model in excel to run simulations against. One
aspect involves randomly identifying ranges of days/dates within a 365
day calendar year.
Example:
Name Days Vacation
========= ===========
Employee 1 14
Employee 2 28
Employee 3 21
Based on the above I'm trying to generate a yearly work schedule that
identifies/applies random vacation days in the amounts specified in
the list. Ideally I'd like some way of weighting the randomization to
better reflect how vacation is taken (eg, in a 2 week block with an
occasional day here and there, rather than completely random.)
Using the data above as an example, I can easily create a list of 14
random yearly dates for Employee 1. The challenge I'm having creating
logic to randomize into blocks of days (eg, 5 consecutive days, 1 day,
1 day, 5 consecutive days, 3 consecutive days)
If anyone has any ideas/insight into the logic required I'd appreciate
hearing from you.
Thanks in advance.
- Michael