ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Resource Scheduling/loading (https://www.excelbanter.com/excel-worksheet-functions/192178-resource-scheduling-loading.html)

Imti

Resource Scheduling/loading
 
Hi,

I am looking for tool to manage work loading of my department. I
created a sheet using lookups and pivotgraph but its difficult to
manage.
I have different skilled set of employees and they can be assigned
work based on there skills, availability (i.e. excluding Leave,
training etc) and project delivery time.

Functionality I am after,
- Individual employee loading.
- Groupwise skill loading (Skill-1, 4 number of people what is there
load.)
- Overall department loading.

Thanks

Imti

Resource Scheduling/loading
 
On Jun 22, 6:16 pm, Imti wrote:
Hi,

I am looking for tool to manage work loading of my department. I
created a sheet using lookups and pivotgraph but its difficult to
manage.
I have different skilled set of employees and they can be assigned
work based on there skills, availability (i.e. excluding Leave,
training etc) and project delivery time.

Functionality I am after,
- Individual employee loading.
- Groupwise skill loading (Skill-1, 4 number of people what is there
load.)
- Overall department loading.

Thanks


Additional requirement;
- Loading to be on week basis and not like timesheet entry (hourly
basis).


All times are GMT +1. The time now is 10:11 AM.

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