DATA INPUT SHEET |
Inventory Number |
|
|
|
|
|
|
|
|
Month Ending |
|
|
|
|
|
|
|
|
|
System Designation |
|
|
|
|
|
|
|
|
Name of Borrower |
|
|
|
|
|
|
|
|
Manager |
|
|
Date |
|
|
|
|
|
Board Officer |
|
|
Date |
|
|
|
|
|
Inspection Performed By |
|
|
|
|
|
|
Firm |
|
|
|
|
|
|
|
|
License Number |
|
|
|
|
|
|
|
|
|
740-C |
WORK ORDER |
Budget Item No. |
GROSS FUNDS REQUIRED |
DEDUCTIONS |
|
|
CODE |
Cost Of |
Cost Of |
SALVAGE RELATING TO |
Contributions |
LOAN FUNDS |
Code |
Code No. |
Year |
|
|
Construction: |
Removal: |
Improvements |
Retirements |
in Aid of |
SUBJECT |
Cat. |
Construc- |
Retire- |
|
Improvements |
or |
Without |
Construction |
TO ADVANCE |
|
tion |
ment |
|
or |
Replacements |
Replacement |
and Previous |
BY RUS |
|
|
|
|
Replacements |
|
|
Advances |
|
|
YYYY |
(1) |
(2) |
(3) |
(4) |
(5) |
(6) |
(7) |
(8) |
(9) |
|
|
|
|
|
DO NOT OVERWRITE FORMULAS IN COL. 9 |
|
|
|
|
|
|
User Input:
Enter W/O's in random order. Before Creating Form 219, press the Sort button. Do Not enter Minor projects on this form.
|
|
|
|
|
|
|
|
|
|
|
This column is calculated automatically with formulas included in each cell. Do not enter data in this column. This column will calculate automatically if a "Code Cat." is entered in Cokumn "A".
|
User Input:
Enter W/O's in random order. Before Creating Form 219, press the Sort button. Do Not enter Minor projects on this form.
|
|
|
|
|
|
|
|
|
|
|
This column is calculated automatically with formulas included in each cell. Do not enter data in this column. This column will calculate automatically if a "Code Cat." is entered in Cokumn "A".
|
User Input:
Enter W/O's in random order. Before Creating Form 219, press the Sort button. Do Not enter Minor projects on this form.
|
|
|
|
|
|
|
|
|
|
|
This column is calculated automatically with formulas included in each cell. Do not enter data in this column. This column will calculate automatically if a "Code Cat." is entered in Cokumn "A".
|
User Input:
Enter W/O's in random order. Before Creating Form 219, press the Sort button. Do Not enter Minor projects on this form.
|
|
|
|
|
|
|
|
|
|
|
This column is calculated automatically with formulas included in each cell. Do not enter data in this column. This column will calculate automatically if a "Code Cat." is entered in Cokumn "A".
|
User Input:
Enter W/O's in random order. Before Creating Form 219, press the Sort button. Do Not enter Minor projects on this form.
|
|
|
|
|
|
|
|
|
|
|
This column is calculated automatically with formulas included in each cell. Do not enter data in this column. This column will calculate automatically if a "Code Cat." is entered in Cokumn "A".
|
User Input:
Enter W/O's in random order. Before Creating Form 219, press the Sort button. Do Not enter Minor projects on this form.
|
|
|
|
|
|
|
|
|
|
|
This column is calculated automatically with formulas included in each cell. Do not enter data in this column. This column will calculate automatically if a "Code Cat." is entered in Cokumn "A".
|
User Input:
Enter W/O's in random order. Before Creating Form 219, press the Sort button. Do Not enter Minor projects on this form.
|
|
|
|
|
|
|
|
|
|
|
This column is calculated automatically with formulas included in each cell. Do not enter data in this column. This column will calculate automatically if a "Code Cat." is entered in Cokumn "A".
|
User Input:
Enter W/O's in random order. Before Creating Form 219, press the Sort button. Do Not enter Minor projects on this form.
|
|
|
|
|
|
|
|
|
|
|
This column is calculated automatically with formulas included in each cell. Do not enter data in this column. This column will calculate automatically if a "Code Cat." is entered in Cokumn "A".
|
User Input:
Enter W/O's in random order. Before Creating Form 219, press the Sort button. Do Not enter Minor projects on this form.
|
|
|
|
|
|
|
|
|
|
|
This column is calculated automatically with formulas included in each cell. Do not enter data in this column. This column will calculate automatically if a "Code Cat." is entered in Cokumn "A".
|
User Input:
Enter W/O's in random order. Before Creating Form 219, press the Sort button. Do Not enter Minor projects on this form.
|
|
|
|
|
|
|
|
|
|
|
This column is calculated automatically with formulas included in each cell. Do not enter data in this column. This column will calculate automatically if a "Code Cat." is entered in Cokumn "A".
|
User Input:
Enter W/O's in random order. Before Creating Form 219, press the Sort button. Do Not enter Minor projects on this form.
|
|
|
|
|
|
|
|
|
|
|
This column is calculated automatically with formulas included in each cell. Do not enter data in this column. This column will calculate automatically if a "Code Cat." is entered in Cokumn "A".
|
User Input:
Enter W/O's in random order. Before Creating Form 219, press the Sort button. Do Not enter Minor projects on this form.
|
|
|
|
|
|
|
|
|
|
|
This column is calculated automatically with formulas included in each cell. Do not enter data in this column. This column will calculate automatically if a "Code Cat." is entered in Cokumn "A".
|
User Input:
Enter W/O's in random order. Before Creating Form 219, press the Sort button. Do Not enter Minor projects on this form.
|
|
|
|
|
|
|
|
|
|
|
This column is calculated automatically with formulas included in each cell. Do not enter data in this column. This column will calculate automatically if a "Code Cat." is entered in Cokumn "A".
|
User Input:
Enter W/O's in random order. Before Creating Form 219, press the Sort button. Do Not enter Minor projects on this form.
|
|
|
|
|
|
|
|
|
|
|
This column is calculated automatically with formulas included in each cell. Do not enter data in this column. This column will calculate automatically if a "Code Cat." is entered in Cokumn "A".
|
User Input:
Enter W/O's in random order. Before Creating Form 219, press the Sort button. Do Not enter Minor projects on this form.
|
|
|
|
|
|
|
|
|
|
|
This column is calculated automatically with formulas included in each cell. Do not enter data in this column. This column will calculate automatically if a "Code Cat." is entered in Cokumn "A".
|
User Input:
Enter W/O's in random order. Before Creating Form 219, press the Sort button. Do Not enter Minor projects on this form.
|
|
|
|
|
|
|
|
|
|
|
This column is calculated automatically with formulas included in each cell. Do not enter data in this column. This column will calculate automatically if a "Code Cat." is entered in Cokumn "A".
|
User Input:
Enter W/O's in random order. Before Creating Form 219, press the Sort button. Do Not enter Minor projects on this form.
|
|
|
|
|
|
|
|
|
|
|
This column is calculated automatically with formulas included in each cell. Do not enter data in this column. This column will calculate automatically if a "Code Cat." is entered in Cokumn "A".
|
User Input:
Enter W/O's in random order. Before Creating Form 219, press the Sort button. Do Not enter Minor projects on this form.
|
|
|
|
|
|
|
|
|
|
|
This column is calculated automatically with formulas included in each cell. Do not enter data in this column. This column will calculate automatically if a "Code Cat." is entered in Cokumn "A".
|
User Input:
Enter W/O's in random order. Before Creating Form 219, press the Sort button. Do Not enter Minor projects on this form.
|
|
|
|
|
|
|
|
|
|
|
This column is calculated automatically with formulas included in each cell. Do not enter data in this column. This column will calculate automatically if a "Code Cat." is entered in Cokumn "A".
|
User Input:
Enter W/O's in random order. Before Creating Form 219, press the Sort button. Do Not enter Minor projects on this form.
|
|
|
|
|
|
|
|
|
|
|
This column is calculated automatically with formulas included in each cell. Do not enter data in this column. This column will calculate automatically if a "Code Cat." is entered in Cokumn "A".
|
User Input:
Enter W/O's in random order. Before Creating Form 219, press the Sort button. Do Not enter Minor projects on this form.
|
|
|
|
|
|
|
|
|
|
|
This column is calculated automatically with formulas included in each cell. Do not enter data in this column. This column will calculate automatically if a "Code Cat." is entered in Cokumn "A".
|
User Input:
Enter W/O's in random order. Before Creating Form 219, press the Sort button. Do Not enter Minor projects on this form.
|
|
|
|
|
|
|
|
|
|
|
This column is calculated automatically with formulas included in each cell. Do not enter data in this column. This column will calculate automatically if a "Code Cat." is entered in Cokumn "A".
|
User Input:
Enter W/O's in random order. Before Creating Form 219, press the Sort button. Do Not enter Minor projects on this form.
|
|
|
|
|
|
|
|
|
|
|
This column is calculated automatically with formulas included in each cell. Do not enter data in this column. This column will calculate automatically if a "Code Cat." is entered in Cokumn "A".
|
User Input:
Enter W/O's in random order. Before Creating Form 219, press the Sort button. Do Not enter Minor projects on this form.
|
|
|
|
|
|
|
|
|
|
|
This column is calculated automatically with formulas included in each cell. Do not enter data in this column. This column will calculate automatically if a "Code Cat." is entered in Cokumn "A".
|
User Input:
Enter W/O's in random order. Before Creating Form 219, press the Sort button. Do Not enter Minor projects on this form.
|
|
|
|
|
|
|
|
|
|
|
This column is calculated automatically with formulas included in each cell. Do not enter data in this column. This column will calculate automatically if a "Code Cat." is entered in Cokumn "A".
|
User Input:
Enter W/O's in random order. Before Creating Form 219, press the Sort button. Do Not enter Minor projects on this form.
|
|
|
|
|
|
|
|
|
|
|
This column is calculated automatically with formulas included in each cell. Do not enter data in this column. This column will calculate automatically if a "Code Cat." is entered in Cokumn "A".
|
User Input:
Enter W/O's in random order. Before Creating Form 219, press the Sort button. Do Not enter Minor projects on this form.
|
|
|
|
|
|
|
|
|
|
|
This column is calculated automatically with formulas included in each cell. Do not enter data in this column. This column will calculate automatically if a "Code Cat." is entered in Cokumn "A".
|
User Input:
Enter W/O's in random order. Before Creating Form 219, press the Sort button. Do Not enter Minor projects on this form.
|
|
|
|
|
|
|
|
|
|
|
This column is calculated automatically with formulas included in each cell. Do not enter data in this column. This column will calculate automatically if a "Code Cat." is entered in Cokumn "A".
|
User Input:
Enter W/O's in random order. Before Creating Form 219, press the Sort button. Do Not enter Minor projects on this form.
|
|
|
|
|
|
|
|
|
|
|
This column is calculated automatically with formulas included in each cell. Do not enter data in this column. This column will calculate automatically if a "Code Cat." is entered in Cokumn "A".
|
User Input:
Enter W/O's in random order. Before Creating Form 219, press the Sort button. Do Not enter Minor projects on this form.
|
|
|
|
|
|
|
|
|
|
|
This column is calculated automatically with formulas included in each cell. Do not enter data in this column. This column will calculate automatically if a "Code Cat." is entered in Cokumn "A".
|
User Input:
Enter W/O's in random order. Before Creating Form 219, press the Sort button. Do Not enter Minor projects on this form.
|
|
|
|
|
|
|
|
|
|
|
This column is calculated automatically with formulas included in each cell. Do not enter data in this column. This column will calculate automatically if a "Code Cat." is entered in Cokumn "A".
|
User Input:
Enter W/O's in random order. Before Creating Form 219, press the Sort button. Do Not enter Minor projects on this form.
|
|
|
|
|
|
|
|
|
|
|
This column is calculated automatically with formulas included in each cell. Do not enter data in this column. This column will calculate automatically if a "Code Cat." is entered in Cokumn "A".
|
User Input:
Enter W/O's in random order. Before Creating Form 219, press the Sort button. Do Not enter Minor projects on this form.
|
|
|
|
|
|
|
|
|
|
|
This column is calculated automatically with formulas included in each cell. Do not enter data in this column. This column will calculate automatically if a "Code Cat." is entered in Cokumn "A".
|
User Input:
Enter W/O's in random order. Before Creating Form 219, press the Sort button. Do Not enter Minor projects on this form.
|
|
|
|
|
|
|
|
|
|
|
This column is calculated automatically with formulas included in each cell. Do not enter data in this column. This column will calculate automatically if a "Code Cat." is entered in Cokumn "A".
|
User Input:
Enter W/O's in random order. Before Creating Form 219, press the Sort button. Do Not enter Minor projects on this form.
|
|
|
|
|
|
|
|
|
|
|
This column is calculated automatically with formulas included in each cell. Do not enter data in this column. This column will calculate automatically if a "Code Cat." is entered in Cokumn "A".
|
User Input:
Enter W/O's in random order. Before Creating Form 219, press the Sort button. Do Not enter Minor projects on this form.
|
|
|
|
|
|
|
|
|
|
|
This column is calculated automatically with formulas included in each cell. Do not enter data in this column. This column will calculate automatically if a "Code Cat." is entered in Cokumn "A".
|
User Input:
Enter W/O's in random order. Before Creating Form 219, press the Sort button. Do Not enter Minor projects on this form.
|
|
|
|
|
|
|
|
|
|
|
This column is calculated automatically with formulas included in each cell. Do not enter data in this column. This column will calculate automatically if a "Code Cat." is entered in Cokumn "A".
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|