dek
09-14-2010, 08:14 PM
Hi,
Overview
I am looking to populate capacity values in the date range (column H: to end date range) for each asset type.
Sample Workbook
The attached sample workbook (excel 2003) outlines the target result (based on individual cell input by me) for the capacity values.
Goal:
I have a list of 100 assets to monitor (sample workbook shows 6).
I am trying to manage the capacity up to 6 months out (sample workbook shows 1 month only).
I wish to remove the manual process of inputting the values through a VBA process if possible.
Workbook Definitions:
The capacity value is the "shifts" value
The capacity value is populated from the "roster" type using the date range (start and end date).
The roster definitions are:
14/7C - working continuously (every day)
14/7NC - working 14 days, 7 days off (non continuous)
5/2NC - working 5 days, 2 days off (non continuous).
Help appreciated.
Overview
I am looking to populate capacity values in the date range (column H: to end date range) for each asset type.
Sample Workbook
The attached sample workbook (excel 2003) outlines the target result (based on individual cell input by me) for the capacity values.
Goal:
I have a list of 100 assets to monitor (sample workbook shows 6).
I am trying to manage the capacity up to 6 months out (sample workbook shows 1 month only).
I wish to remove the manual process of inputting the values through a VBA process if possible.
Workbook Definitions:
The capacity value is the "shifts" value
The capacity value is populated from the "roster" type using the date range (start and end date).
The roster definitions are:
14/7C - working continuously (every day)
14/7NC - working 14 days, 7 days off (non continuous)
5/2NC - working 5 days, 2 days off (non continuous).
Help appreciated.