Spreadsheet: 105942d1303216776-index-indirect-match-help-projbudg
Sheet: ResourcePlan

 |  |  |  | [NAME]? | Rate | 2011 |  |  |  |  |  |  |  |  | 2012 |  |  | Y1 | Y1 | 2012 |  |  |  |  |  |  |  |  | 2013 |  |  | Y2 | Y2 | 2013 |  |  |  |  |  |  |  |  | 2014 |  |  | Y3 | Y3
 |  |  |  |  |  | A | M | J | J | A | S | O | N | D | J | F | M | TOTAL | TOTAL | A | M | J | J | A | S | O | N | D | J | F | M | TOTAL | TOTAL | A | M | J | J | A | S | O | N | D | J | F | M | TOTAL | TOTAL | TOTAL | TOTAL
Project | Type | Priority | Resource |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DAYS | COST |  |  |  |  |  |  |  |  |  |  |  |  | DAYS | COST |  |  |  |  |  |  |  |  |  |  |  |  | DAYS | COST | DAYS | COST
 |  |  | .
Online Forms | Web | H | .
 |  |  | WBC - BDO1 |  |  | 2 | 2 | 2 |  |  | 1 |  |  | 1 |  |  | 1
 |  |  | WBC - BDO2 |  |  | 2 | 2 | 2 |  |  | 1 |  |  | 1 |  |  | 1
 |  |  | WBC - BDO3 |  |  | 2 | 2 | 2 |  |  | 1 |  |  | 1 |  |  | 1
 |  |  | WBC - BDO4 |  |  | 5 | 5 | 2 |  |  | 1 |  |  | 1 |  |  | 1
 |  |  | WBC - BDO5 |  |  | 2 | 2 | 2 |  |  | 1 |  |  | 1 |  |  | 1
 |  |  | WBC - PM1 |  |  | 2 | 2 | 2 | 5 | 5 | 5 | 3 | 3 | 3 | 3 | 3 | 3
 |  |  | WBC - Infrastructure1 |  |  |  | 10 | 5 |  |  |  |  |  | 10 | 20
 |  |  | WBC - Webmaster |  |  | 2 | 2 | 10 | 10 | 10 | 5 | 5 | 2 | 2 | 2 | 2 | 2
 |  |  | WBC - Web Developer1 |  |  |  |  | 2 | 10 | 10 | 10 | 10 | 10 | 5 | 5 | 2 | 2
 |  |  | WBC - Web Developer2 |  |  |  |  | 2 | 10 | 10 | 10 | 2 | 2 | 2 | 2 | 2 | 2
 |  |  | .
Online Authentication | Web | H | .
 |  |  | WBC - BDO1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 | 2
 |  |  | WBC - BDO2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 | 2
 |  |  | WBC - BDO3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 | 2
 |  |  | WBC - BDO4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 | 2
 |  |  | WBC - BDO5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 | 2
 |  |  | WBC - PM1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
 |  |  | WBC - Infrastructure1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 | 2 | 2 | 1
 |  |  | WBC - Security/Networks1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 | 2
 |  |  | WBC - Webmaster |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 | 2 | 2 | 2 | 2 | 5 | 1
 |  |  | WBC - Web Developer1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 | 2 | 2 | 5 | 5 | 5 | 1
 |  |  | WBC - Web Developer2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 | 2 | 2 | 5 | 5 | 5 | 1
 |  |  | Supplier1 - PM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 | 2
 |  |  | Supplier2 - PM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 | 2
 |  |  | Supplier3 - PM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 | 2
 |  |  | Supplier4 - PM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 | 2
 |  |  | Supplier5 - PM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 | 2
 |  |  | .
Website Upgrade | Web | H | .
 |  |  | WBC - PM2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
 |  |  | WBC - Infrastructure1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 | 2 | 2
 |  |  | WBC - Infrastructure2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 | 2 | 2
 |  |  | WBC - Security/Networks1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 | 2
 |  |  | WBC - Webmaster |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 5 | 5 | 5 | 2 | 2
 |  |  | WBC - Web Developer1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 15 | 10 | 10 | 5 | 2
 |  |  | WBC - Web Developer2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 10 | 10 | 10 | 2 | 2
 |  |  | .
 |  |  | .
 |  |  | .
SAN Replacement | Inf | H | .
 |  |  | WBC - PM3 |  |  |  | 2 | 4 | 4 | 4 | 2 | 2 | 1 | 1
 |  |  | WBC - Infrastructure1 |  |  |  | 5 | 10 | 10 | 10 | 10 | 5 | 1
 |  |  | WBC - Infrastructure2 |  |  |  |  | 5 | 5 | 5 | 5 | 5 | 1
 |  |  | WBC - Infrastructure3 |  |  |  |  | 5 | 5 | 5 | 5 | 5 | 1
 |  |  | WBC - Security/Networks2 |  |  |  |  | 2 | 2 | 2
 |  |  | Supplier6 - PM |  |  |  |  | 2 | 15 | 5 | 2 | 2
 |  |  | .
 |  |  | .
 |  |  | .
Server replacement | Inf | H | .
 |  |  | WBC - PM3 |  |  |  |  |  |  |  | 2 | 4 | 4 | 4 | 4 | 4 | 2 |  |  | 2
 |  |  | WBC - Infrastructure1 |  |  |  |  |  |  |  |  | 2 | 2 | 5 | 10 | 10 | 10 |  |  | 5
 |  |  | WBC - Infrastructure2 |  |  |  |  |  |  |  |  |  |  |  | 10 | 10 | 10
 |  |  | WBC - Infrastructure3 |  |  |  |  |  |  |  |  |  |  |  | 10 | 10 | 10
 |  |  | WBC - Security/Networks1 |  |  |  |  |  |  |  |  |  |  | 2 | 2 | 2 | 2
 |  |  | Supplier7 - PM |  |  |  |  |  |  |  |  | 1 | 2 | 2 | 2 | 2
 |  |  | Supplier7 - Other |  |  |  |  |  |  |  |  |  | 1 | 2 | 5 | 10 | 5
 |  |  | .
 |  |  | .
 |  |  | .
Replacement tape drives | Inf | H | .
 |  |  | WBC - PM3 |  |  |  |  | 2 | 2 | 2 | 2 | 2
 |  |  | WBC - Infrastructure1 |  |  |  |  | 1 | 4 | 10 | 4 | 1
 |  |  | WBC - Infrastructure2 |  |  |  |  |  | 1 | 5 | 5 | 1
 |  |  | Supplier8 - PM |  |  |  |  |  | 1 | 2 | 1 | 1
 |  |  | Supplier8 - Other |  |  |  |  |  |  | 4 | 2 | 1
 |  |  | .
 |  |  | .
 |  |  | .
 |  |  | .
 |  |  | .
 |  |  | .
Network Refresh | NW | H | .
 |  |  | WBC - PM2 |  |  |  | 2 | 4 | 4 | 5 | 5 | 5 | 5 | 5 | 2 | 2
 |  |  | WBC - Security/Networks1 |  |  |  | 2 | 2 | 5 | 2 | 5 | 10 | 10 | 10 | 5 | 2 | 2
 |  |  | WBC - Security/Networks2 |  |  |  |  |  |  | 2 | 5 | 10 | 10 | 10 | 5 | 2 | 2
 |  |  | WBC - Telecomms1 |  |  |  |  |  |  | 2 | 5 | 5 | 5 | 5 | 3 | 2 | 1
 |  |  | WBC - Telecomms2 |  |  |  |  |  |  | 2 | 2 | 2 | 3 | 3 | 2 | 2 | 1
 |  |  | Consultant1 |  |  |  |  |  | 1 |  |  | 1 |  |  | 1 |  | 2
 |  |  | Supplier9 - PM |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  | Supplier9 - Other |  |  |  |  |  |  | 2 | 4 | 10 | 5 | 5 | 2 | 1 | 1
 |  |  | .
 |  |  | .
[NAME] | NW | M | .
 |  |  | WBC - PM2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 | 2 |  |  | 5 | 5 | 5 | 5 | 5 | 5 | 2 | 2 | 2
 |  |  | WBC - Telecomms1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 | 2 |  |  | 5 | 10 | 10 | 10 | 10 | 10 | 5 | 2 | 2
 |  |  | WBC - Telecomms2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 | 2 |  |  | 5 | 5 | 5 | 5 | 10 | 10 | 5 | 5 | 2
 |  |  | Consultant1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  | 2 |  |  | 2 |  |  | 2 |  | 2
 |  |  | Consultant2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  | 1 |  |  | 1 |  |  | 1 | 1
 |  |  | Other1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 10 | 10 | 10 | 10 | 5 | 5 | 1 | 1
 |  |  | Other2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 5 | 5
 |  |  | .
 |  |  | .
 |  |  | .
Disaster Recovery | Inf | H | .
 |  |  | WBC - BDO4 |  |  |  |  |  |  |  | 2 | 2 | 2 | 2 | 2 | 2 | 2
 |  |  | WBC - BDO5 |  |  |  |  |  |  |  | 2 | 2 | 2 | 2 | 2 | 2 | 2
 |  |  | WBC - PM1 |  |  |  |  |  |  |  | 2 | 5 | 5 | 5 | 5 | 5 | 5
 |  |  | WBC - Infrastructure1 |  |  |  |  |  |  |  |  |  | 2 | 5 | 10 | 5 | 2
 |  |  | WBC - Infrastructure2 |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  | WBC - Security/Networks1 |  |  |  |  |  |  |  |  |  | 2 | 5 | 5 | 5 | 2
 |  |  | WBC - Security/Networks2 |  |  |  |  |  |  |  |  |  |  |  | 10
 |  |  | Other3 |  |  |  |  |  |  |  |  |  | 2 | 2 | 2 | 2 | 2
 |  |  | Other4 |  |  |  |  |  |  |  |  |  |  | 2 | 2 | 2 | 2
 |  |  | .
Internal Business Processes | App | M | .
 |  |  | WBC - BDO3 |  |  |  |  |  | 2 | 2 | 2 | 2 | 2 | 2
 |  |  | WBC - PM2 |  |  |  |  |  | 2 | 4 | 4 | 4 | 2 | 1
 |  |  | WBC - Webmaster |  |  |  |  |  | 2 | 2 | 5 | 5 | 5 | 2
 |  |  | WBC - Web Developer1 |  |  |  |  |  |  | 5 | 20 | 20 | 20 | 5
 |  |  | Consultant3 |  |  |  |  |  |  | 2 | 2 | 2 | 2 | 2
 |  |  | Consultant4 |  |  |  |  |  |  | 2 | 2 | 2 | 2 | 2
 |  |  | Other5 |  |  |  |  |  |  | 2 |  | 2 |  | 2
 |  |  | Other6 |  |  |  |  |  |  |  | 2 |  | 2
 |  |  | .
 |  |  | .
Application1 | App | L | .
 |  |  | WBC - BDO4 |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 | 2 |  |  | 2 | 2 | 2 | 2 | 2
 |  |  | WBC - PM1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  | 4 | 5 | 5 | 5 | 4
 |  |  | WBC - Webmaster |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  | 5 | 5 | 5 | 2 | 2
 |  |  | WBC - Web Developer1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 10 | 10 | 5
 |  |  | Supplier2 - PM |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  | 1 | 1 | 1 | 1 | 1
 |  |  | Supplier2 - Other |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  | 5 | 10 | 10 | 10 | 5
 |  |  | Other7 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | 2 |  | 2
 |  |  | .
 |  |  | .
 |  |  | .
 |  |  | .
 |  |  | Totals
 |  |  | Extra Hardware/Software
 |  |  | Total Int Resource Days
 |  |  | Total Ext Resource Days