Helper cells 4 6 2 04% 6% 2% 0%

Total Tool 1 Tool 2 Tool 3

Ongoing 11 2 3 0

5 Priority 5 0 0 0 04 Priority 4 0 0 0 03 Priority 3 0 0 0 02 Priority 2 0 0 0 01 Priority 1 11 2 3 0

% used 4% 6% 2% 0%Used 11 2 3 0

Capacity 276 32 128 64

Owner Date enter Project NaDue Date Priority # of parts Tool 1 Tool 2 Tool 3A 1/2/2011 1 12 xB 1/1/2012 1 3 xC 1 1 xC-2 1 2C-3 1 1 xd 3/4/2012 1 6

0 19 helper cells 0 00% 19% 100% 0% 0%

Total Tool 5 Total Tool 1 Tool 2

0 6 Finished Projects 14 0 0

0 0 0% Priority 5 0 0 00 0 0% Priority 4 0 0 00 0 0% Priority 3 0 0 00 0 0% Priority 2 0 0 00 6 ||||||||||||||||||||||||||| 100% Priority 1 14 0 0

0% 19% % 100% 0% 0%0 6

20 32

Tool 4 Tool 5 Finish datePast due?1/1/2011 No

YesYes

x 2/2/2012 YesYes

x Yes

This sheet shows a simple layout for resource management among 5 tools with different capacity. Pankaj Rathi rathpankajj @ gmail. com

At the top of the sheet, the green columns (conditional formatting) show the utilization of 5 tools). On the left are the ongoing projects and to the right are the finished projects showing history. In columns K and V, % of various priorities are shown as a horizontal bar with the percentages in columns M and X. These bar charts are expected to priority management and can be a metric of their usage. For example, of we do not see a particulare priority used at all then there is a good reason to drop it :)

The sheet is protected without password

Instructions for use:Data must be entered only in cells A118:K5000 cells. If additional rows/cells are required then add them within this range and not outside to preserve the formulae.Do not allocate a project to multiple tools since it will cause error in calculation. Instead, split the project in different lines to allocate it to different tools. If a project is over or under allocated to tools then the tool cells will turn redInput as many fields as possible for the best outcome. Seek input from project managers for the priority , due date and preference for the tool used. Provide a due date based on resources availableIf a project is past due then the row will turn orangeIf a project is finished (only idicated by input finish date) then the row will have 'hashed' markingThe orange filled cells are for capacity input for each tool

86 14 086% 14% 0%

Tool 3 Total Tool 5

12 2 0

0 0 0 0%0 0 0 0%0 0 0 0%0 0 0 0%

12 2 0 ||||||||||||||||||||||||||||| 100%86% 14% 0%

This sheet shows a simple layout for resource management among 5 tools with different capacity. Pankaj Rathi rathpankajj @ gmail. com

At the top of the sheet, the green columns (conditional formatting) show the utilization of 5 tools). On the left are the ongoing projects and to the right are the finished projects showing history. In columns K and V, % of various priorities are shown as a horizontal bar with the percentages in columns M and X. These bar charts are expected to priority management and can be a metric of their usage. For example, of we do not see a particulare priority used at all then there is a good reason to drop it :)

The sheet is protected without password

Instructions for use:Data must be entered only in cells A118:K5000 cells. If additional rows/cells are required then add them within this range and not outside to preserve the formulae.Do not allocate a project to multiple tools since it will cause error in calculation. Instead, split the project in different lines to allocate it to different tools. If a project is over or under allocated to tools then the tool cells will turn redInput as many fields as possible for the best outcome. Seek input from project managers for the priority , due date and preference for the tool used. Provide a due date based on resources availableIf a project is past due then the row will turn orangeIf a project is finished (only idicated by input finish date) then the row will have 'hashed' markingThe orange filled cells are for capacity input for each tool