Spreadsheet: 96449d1295863663-copying-formula-example
Sheet: Volumes

 |  |  |  |  |  |  |  | 2011-01-24 00:00:00
Date |  | Day | Week | Code | Total | Outwards | Inwards
 |  |  |  |  |  |  |  | KVI REF NO.
 |  |  |  |  |  |  |  | LPM - SMV
 |  |  |  |  |  |  |  | Team
2010-10-04 00:00:00 | 40455FORECAST VOLUME | Monday | 1 | 1Mo | 0 | 0 | 0 | FORECAST VOLUME
 |  |  |  |  | 0 | 0 | 0 | FORECAST HOURS
 | 40455ACTUAL VOLUME |  |  |  | 0 | 0 | 0 | ACTUAL VOLUME
 |  |  |  |  | 0 | 0 | 0 | ACTUAL HOURS
 |  |  |  |  |  |  |  | % VARIANCE
2010-10-05 00:00:00 | 40456FORECAST VOLUME | Tuesday | 1 | 1Tu | 0 | 0 | 0 | FORECAST VOLUME
 |  |  |  |  | 0 | 1 | 0 | FORECAST HOURS
 | 40456ACTUAL VOLUME |  |  |  | 0 | 0 | 0 | ACTUAL VOLUME
 |  |  |  |  | 0 | 0 | 0 | ACTUAL HOURS
 |  |  |  |  |  |  |  | % VARIANCE
2010-10-06 00:00:00 | 40457FORECAST VOLUME | Wednesday | 1 | 1We | 0 | 0 | 0 | FORECAST VOLUME
 |  |  |  |  | 0 | 2 | 0 | FORECAST HOURS
 | 40457ACTUAL VOLUME |  |  |  | 0 | 0 | 0 | ACTUAL VOLUME
 |  |  |  |  | 0 | 0 | 0 | ACTUAL HOURS
 |  |  |  |  |  |  |  | % VARIANCE
2010-10-07 00:00:00 | 40458FORECAST VOLUME | Thursday | 1 | 1Th | 0 | 0 | 0 | FORECAST VOLUME
 |  |  |  |  | 0 | 3 | 0 | FORECAST HOURS
 | 40458ACTUAL VOLUME |  |  |  | 0 | 0 | 0 | ACTUAL VOLUME
 |  |  |  |  | 0 | 0 | 0 | ACTUAL HOURS
 |  |  |  |  |  |  |  | % VARIANCE
2010-10-08 00:00:00 | 40459FORECAST VOLUME | Friday | 1 | 1Fr | 0 | 0 | 0 | FORECAST VOLUME
 |  |  |  |  | 0 | 4 | 0 | FORECAST HOURS
 | 40459ACTUAL VOLUME |  |  |  | 0 | 0 | 0 | ACTUAL VOLUME
 |  |  |  |  | 0 | 0 | 0 | ACTUAL HOURS
 |  |  |  |  |  |  |  | % VARIANCE
Weekly |  |  |  |  |  |  |  | WEEKLY FORECAST VOLUME
 |  |  |  |  |  |  |  | WEEKLY ACTUAL VOLUME
 |  |  |  |  |  |  |  | WEEKLY [NAME]
2010-10-11 00:00:00 | 40462FORECAST VOLUME | Monday | 2 | 2Mo | 0 | 0 | 0 | FORECAST VOLUME
 |  |  |  |  | 0 | 5 | 0 | FORECAST HOURS
 | 40462ACTUAL VOLUME |  |  |  | 0 | 0 | 0 | ACTUAL VOLUME
 |  |  |  |  | 0 | 0 | 0 | ACTUAL HOURS
 |  |  |  |  |  |  |  | % VARIANCE
2010-10-12 00:00:00 | 40463FORECAST VOLUME | Tuesday | 2 | 2Tu | 0 | 0 | 0 | FORECAST VOLUME
 |  |  |  |  | 0 | 0 | 0 | FORECAST HOURS
 | 40463ACTUAL VOLUME |  |  |  | 0 | 0 | 0 | ACTUAL VOLUME
 |  |  |  |  | 0 | 0 | 0 | ACTUAL HOURS
 |  |  |  |  |  |  |  | % VARIANCE
2010-10-13 00:00:00 | 40464FORECAST VOLUME | Wednesday | 2 | 2We | 0 | 0 | 0 | FORECAST VOLUME
 |  |  |  |  | 0 | 0 | 0 | FORECAST HOURS
 | 40464ACTUAL VOLUME |  |  |  | 0 | 0 | 0 | ACTUAL VOLUME
 |  |  |  |  | 0 | 0 | 0 | ACTUAL HOURS
 |  |  |  |  |  |  |  | % VARIANCE
2010-10-14 00:00:00 | 40465FORECAST VOLUME | Thursday | 2 | 2Th | 0 | 0 | 0 | FORECAST VOLUME
 |  |  |  |  | 0 | 0 | 0 | FORECAST HOURS
 | 40465ACTUAL VOLUME |  |  |  | 0 | 0 | 0 | ACTUAL VOLUME
 |  |  |  |  | 0 | 0 | 0 | ACTUAL HOURS
 |  |  |  |  |  |  |  | % VARIANCE
2010-10-15 00:00:00 | 40466FORECAST VOLUME | Friday | 2 | 2Fr | 0 | 0 | 0 | FORECAST VOLUME
 |  |  |  |  | 0 | 0 | 0 | FORECAST HOURS
 | 40466ACTUAL VOLUME |  |  |  | 0 | 0 | 0 | ACTUAL VOLUME
 |  |  |  |  | 0 | 0 | 0 | ACTUAL HOURS
 |  |  |  |  |  |  |  | % VARIANCE
Weekly |  |  |  |  |  |  |  | WEEKLY FORECAST VOLUME
 |  |  |  |  |  |  |  | WEEKLY ACTUAL VOLUME
 |  |  |  |  |  |  |  | WEEKLY [NAME]
2010-10-18 00:00:00 | 40469FORECAST VOLUME | Monday | 3 | 3Mo | 0 | 0 | 0 | FORECAST VOLUME
 |  |  |  |  | 0 | 0 | 0 | FORECAST HOURS
 | 40469ACTUAL VOLUME |  |  |  | 0 | 0 | 0 | ACTUAL VOLUME
 |  |  |  |  | 0 | 0 | 0 | ACTUAL HOURS
 |  |  |  |  |  |  |  | % VARIANCE
2010-10-19 00:00:00 | 40470FORECAST VOLUME | Tuesday | 3 | 3Tu | 0 | 0 | 0 | FORECAST VOLUME
 |  |  |  |  | 0 | 0 | 0 | FORECAST HOURS
 | 40470ACTUAL VOLUME |  |  |  | 0 | 0 | 0 | ACTUAL VOLUME
 |  |  |  |  | 0 | 0 | 0 | ACTUAL HOURS
 |  |  |  |  |  |  |  | % VARIANCE
2010-10-20 00:00:00 | 40471FORECAST VOLUME | Wednesday | 3 | 3We | 0 | 0 | 0 | FORECAST VOLUME
 |  |  |  |  | 0 | 0 | 0 | FORECAST HOURS
 | 40471ACTUAL VOLUME |  |  |  | 0 | 0 | 0 | ACTUAL VOLUME
 |  |  |  |  | 0 | 0 | 0 | ACTUAL HOURS
 |  |  |  |  |  |  |  | % VARIANCE
2010-10-21 00:00:00 | 40472FORECAST VOLUME | Thursday | 3 | 3Th | 0 | 0 | 0 | FORECAST VOLUME
 |  |  |  |  | 0 | 0 | 0 | FORECAST HOURS
 | 40472ACTUAL VOLUME |  |  |  | 0 | 0 | 0 | ACTUAL VOLUME
 |  |  |  |  | 0 | 0 | 0 | ACTUAL HOURS
 |  |  |  |  |  |  |  | % VARIANCE
2010-10-22 00:00:00 | 40473FORECAST VOLUME | Friday | 3 | 3Fr | 0 | 0 | 0 | FORECAST VOLUME
 |  |  |  |  | 0 | 0 | 0 | FORECAST HOURS
 | 40473ACTUAL VOLUME |  |  |  | 0 | 0 | 0 | ACTUAL VOLUME
 |  |  |  |  | 0 | 0 | 0 | ACTUAL HOURS
 |  |  |  |  |  |  |  | % VARIANCE
Weekly |  |  |  |  |  |  |  | WEEKLY FORECAST VOLUME
 |  |  |  |  |  |  |  | WEEKLY ACTUAL VOLUME
 |  |  |  |  |  |  |  | WEEKLY [NAME]