Resource Management - Formula for various different schedules
I'm using smartsheet for resource management and the sheet links to our smartsheet resource tool.
In RM smartsheet, we have different resources on different schedules e.g:
- Some work 7 hours a day
- Some work part time (4 hours a day)
- Some work 4 days a week at 8 hours and 7 hours (Fridays off)
We have been using a set formula to determine the allocation % of reach resource which is incorrect as it doesn't take into account of the different scenarios and people have been complaining that the planned hours that RM smartsheet is suggesting is wrong, as they should be.
=Hours@row / (Duration@row * 8). - This assumes everyone is full time and working 8 hours a day.
The sheet below is what I use to push the resources through to RM smartsheet. We're trying to figure the best way to set each project up so it takes into account of the different above scenarios, and that the allocation will be accurate, which means RM smartsheets will suggest the current planned hours
Does anybody have any suggestions please?
Example of planned hours in RM smartsheet.