ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   In theory Excel vba work out a roster by itself (https://www.excelbanter.com/excel-programming/290472-theory-excel-vba-work-out-roster-itself.html)

Max Bialystock

In theory Excel vba work out a roster by itself
 
In theory, if Excel vba was given enough instructions could it work out a
roster by itself?

Say Monday through Friday, five employees, 2 full time, 2 part timer and one
casual.




Frank Kabel

In theory Excel vba work out a roster by itself
 
Hi Max
IMO in theory yes it could. You can program your restrictions and
'roster assignment algorithmn'. Though doing this for a large number of
employees and shift types would be an *interesting* work ;-)

Frank

Max Bialystock wrote:
In theory, if Excel vba was given enough instructions could it work
out a roster by itself?

Say Monday through Friday, five employees, 2 full time, 2 part timer
and one casual.




Tom Ogilvy

In theory Excel vba work out a roster by itself
 
http://www.shiftschedules.com/

also check out Tony Rice's

www.Production-Scheduling.com


there may be something there as well.

--
Regards,
Tom Ogilvy


"Max Bialystock" wrote in message
...
In theory, if Excel vba was given enough instructions could it work out a
roster by itself?

Say Monday through Friday, five employees, 2 full time, 2 part timer and

one
casual.






KJTFS[_93_]

In theory Excel vba work out a roster by itself
 
Yes almost anything is possible, but can you/anyone program it that i
the question.

Keith
www.kjtfs.co

--
Message posted from http://www.ExcelForum.com



All times are GMT +1. The time now is 06:57 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com