Change Roster values

**Bloodywog** · 04-13-2012, 03:38 AM

Hi jastake

I was looking at this today. Firstly, if you remove the engine and the annual leave planner from RecLeav planner it runs a little faster. That is on my work computer.

Maybe we should not double up on sheets, we can remove the "Overtime" Sheet and change the OTSummary sheet to "Overtime". There's a lot of code going on, reduce corruption and keeps it simple. When I create a summary sheet for "overtime", a Lookup/Match/Index formula can be used to find the staffs name and date worked and insert it in the sheet. Do you agree?

I don't want you spending heaps of time and pulling your hair out to work out the code. Let me know.

**jaslake** · 04-13-2012, 09:18 AM

Hi Bloodywog
Removing the Overtime sheet will have negligible impact on file size and processing speed. Your file is large and processing speed diminished due to the hundreds of formulas and formatting (both conditional and otherwise) contained in your file. The process has to work for you, not for me. I'll work on the existing file for a bit today. Let me know how you wish to proceed.

**jaslake** · 04-13-2012, 10:23 AM

Hi Bloodywog
While you're pondering the future of this project play with the attached. A new Date Picker is incorporated that does not rely on the presence of the Microsoft Calendar Control. Also notice the Formulas in Roster2012 range A3:A14 which address this issue

modifying Employee names

Your Annual Leave Planner appears to not update properly. I've not worked on this at all so you'll need to look at it.
Let me know how you wish to proceed.