Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Defined Function - reformulated repost of an earlier question
I've done a bit of research and now believe that - as Allan
recommended - a UDF apporach would be a more reasonable alternative to writing long convoluted formulae. As such, my question is as follows... I need to develop a method of scheduling many employees based say, a drop-down menu choice of possible schedules. Based on a start date and a known working day rotation, a rolling schedule can be displayed well into the future. The possible days when an employee could be working and then off is as follows and where working days are shown followed by a dash and then the number of days off... 10-4 10-1-10-8 (In this schedule, after 10 days of work, the employee takes a one day break and returns for 10 more working days followed by 8 days off) 20-8 21-7 14-7 14-14 5-2 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Defined Function - reformulated repost of an earlier question
On Sep 1, 9:30*am, Scott wrote:
I've done a bit of research and now believe that - as Allan recommended - a UDF apporach would be a more reasonable alternative to writing long convoluted formulae. As such, my question is as follows... I need to develop a method of scheduling many employees based say, a drop-down menu choice of possible schedules. Based on a start date and a known working day rotation, a rolling schedule can be displayed well into the future. The possible days when an employee could be working and then off is as follows and where working days are shown followed by a dash and then the number *of days off... 10-4 10-1-10-8 (In this schedule, after 10 days of work, the employee takes a one day break and returns for 10 more working days followed by 8 days off) 20-8 21-7 14-7 14-14 5-2 From your description, I can't tell what you want and I don't see the prior so.. "If desired, send your file to dguillett @gmail.com I will only look if: 1. You send a copy of this message on an inserted sheet 2. You give me the newsgroup and the subject line 3. You send a clear explanation of what you want 4. You send before/after examples and expected results." |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2003: Having trouble with conditional formatting with custom user function (Repost) | Excel Worksheet Functions | |||
2003: Having trouble with conditional formatting with custom user function (Repost) | Excel Programming | |||
creating a user defined function - question on input method | Excel Programming | |||
variable scope question in user-defined function | Excel Programming | |||
Question-user defined function | Excel Programming |