Spreadsheet: 104069d1301686467-inserting-static-date-when-value-is-zero-allocation-template
Sheet: 1 allocation dsl 

 | [NAME] |  |  |  | MEN WORKING = | 0 |  | DATE | 2011-04-01 00:00:00 |  | NOTES:
Men | Names | ADJ   + | ADJ  - | hours needed | [NAME] | WON | Client | CVI/MCR      NO | DSL REF NUMBER | Erect Dism | Actual hours | Hours  spent | % | hours left/ +/- | ongoing
0 |  |  |  | 0 |  |  |  |  |  | . |  |  | #N/A | 0 | .
 |  |  |  |  |  |  |  |  |  | . |  |  | #N/A | 0 | .
 |  |  |  |  |  |  |  |  |  | . |  |  | #N/A | 0 | .
 |  |  |  |  |  |  |  |  |  | . |  |  | #N/A | 0 | .
 |  |  |  |  |  |  |  |  |  | . |  |  | #N/A | 0 | .
 |  |  |  |  |  |  |  |  |  | . |  |  | #N/A | 0 | .
 |  |  |  |  |  |  |  |  |  | . |  |  | #N/A | 0 | .
 |  |  |  |  |  |  |  |  |  | . |  |  | #N/A | 0 | .
 |  |  |  |  |  |  |  |  |  | NEEDED | TOTAL | TOTAL
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
0 |  |  |  | 0 |  |  |  |  |  | . |  |  | #N/A | 0 | .
 |  |  |  |  |  |  |  |  |  | . |  |  | #N/A | 0 | .
 |  |  |  |  |  |  |  |  |  | . |  |  | #N/A | 0 | .
 |  |  |  |  |  |  |  |  |  | . |  |  | #N/A | 0 | .
 |  |  |  |  |  |  |  |  |  | . |  |  | #N/A | 0 | .
 |  |  |  |  |  |  |  |  |  | . |  |  | #N/A | 0 | .
 |  |  |  |  |  |  |  |  |  | . |  |  | #N/A | 0 | .
 |  |  |  |  |  |  |  |  |  | . |  |  | #N/A | 0 | .
 |  |  |  |  |  |  |  |  |  | NEEDED | TOTAL | TOTAL
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
0 |  |  |  | 0 |  |  |  |  |  | . |  |  | #N/A | 0 | .
 |  |  |  |  |  |  |  |  |  | . |  |  | #N/A | 0 | .
 |  |  |  |  |  |  |  |  |  | . |  |  | #N/A | 0 | .
 |  |  |  |  |  |  |  |  |  | . |  |  | #N/A | 0 | .
 |  |  |  |  |  |  |  |  |  | . |  |  | #N/A | 0 | .
 |  |  |  |  |  |  |  |  |  | . |  |  | #N/A | 0 | .
 |  |  |  |  |  |  |  |  |  | . |  |  | #N/A | 0 | .
 |  |  |  |  |  |  |  |  |  | . |  |  | #N/A | 0 | .
 |  |  |  |  |  |  |  |  |  | NEEDED | TOTAL | TOTAL
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
0 |  |  |  | 0 |  |  |  |  |  | . |  |  |  |  | .
 |  |  |  |  |  |  |  |  |  | . |  |  |  |  | .
 |  |  |  |  |  |  |  |  |  | . |  |  |  |  | .
 |  |  |  |  |  |  |  |  |  | . |  |  |  |  | .
 |  |  |  |  |  |  |  |  |  | . |  |  |  |  | .
 |  |  |  |  |  |  |  |  |  | . |  |  |  |  | .
 |  |  |  |  |  |  |  |  |  | . |  |  |  |  | .
 |  |  |  |  |  |  |  |  |  | . |  |  |  |  | .
 |  |  |  |  |  |  |  |  |  | NEEDED | TOTAL | TOTAL
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
3 |  |  |  | 22.8 |  |  |  |  |  | . |  |  |  |  | . | 0 |  |  |  | 0 |  |  |  |  |  | . |  |  |  |  | . | 0 |  |  |  | 0 |  |  |  |  |  | . |  |  |  |  | . | 0 |  |  |  | 0 |  |  |  |  |  | . |  |  |  |  | . | 0 |  |  |  | 0 |  |  |  |  |  | . |  |  |  |  | . | 0 |  |  |  | 0 |  |  |  |  |  | . |  |  |  |  | . | 0 |  |  |  | 0 |  |  |  |  |  | . |  |  |  |  | . | 0 |  |  |  | 0 |  |  |  |  |  | . |  |  |  |  | . | 0 |  |  |  | 0 |  |  |  |  |  | . |  |  |  |  | . | 0 |  |  |  | 0 |  |  |  |  |  | . |  |  |  |  | . | 0 |  |  |  | 0 |  |  |  |  |  | . |  |  |  |  | . | 0 |  |  |  | 0 |  |  |  |  |  | . |  |  |  |  | . | 0 |  |  |  | 0 |  |  |  |  |  | . |  |  |  |  | . | 0 |  |  |  | 0 |  |  |  |  |  | . |  |  |  |  | . | 0 |  |  |  | 0 |  |  |  |  |  | . |  |  |  |  | . | 0 |  |  |  | 0 |  |  |  |  |  | . |  |  |  |  | .
 |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | .
 |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | .
 |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | .
 |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | .
 |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | .
 |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | .
 |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | .
 |  |  |  |  |  |  |  |  |  | NEEDED | TOTAL | TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  | NEEDED | TOTAL | TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  | NEEDED | TOTAL | TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  | NEEDED | TOTAL | TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  | NEEDED | TOTAL | TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  | NEEDED | TOTAL | TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  | NEEDED | TOTAL | TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  | NEEDED | TOTAL | TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  | NEEDED | TOTAL | TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  | NEEDED | TOTAL | TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  | NEEDED | TOTAL | TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  | NEEDED | TOTAL | TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  | NEEDED | TOTAL | TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  | NEEDED | TOTAL | TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  | NEEDED | TOTAL | TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  | NEEDED | TOTAL | TOTAL
 |  |  |  |  |  |  |  |  |  | 22.8 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0