Spreadsheet: 269697d1381250037-multiple-logic-functions-in-one-cell-wip-calculator
Sheet: BN Reports

 | If entering data into BN numbers report by hand:
 |  | WIP Status: | WIP Adjustment Amount
Period 1 |  |  |  |  | Enter the amount showing on line #3 of the appropriate 'Profit Center' in the 'Profit Center" tab.
 |  |  |  |  | Enter this amount on line #3 of the 'Balance Sheet' in the 'Financial Data" tab. (Line 13 should be '0.00')
 |  |  |  |  | Enter this amount on line #13 of the 'Balance Sheet' in the 'Financial Data" tab. (Line 3 should be '0.00')
Period 2 |  |  |  |  | Enter the amount showing on line #3 of the appropriate 'Profit Center' in the 'Profit Center" tab.
 |  |  |  |  | Enter this amount on line #3 of the 'Balance Sheet' in the 'Financial Data" tab. (Line 13 should be '0.00')
 |  |  |  |  | Enter this amount on line #13 of the 'Balance Sheet' in the 'Financial Data" tab. (Line 3 should be '0.00')
Period 3 |  |  |  |  | Enter the amount showing on line #3 of the appropriate 'Profit Center' in the 'Profit Center" tab.
 |  |  |  |  | Enter this amount on line #3 of the 'Balance Sheet' in the 'Financial Data" tab. (Line 13 should be '0.00')
 |  |  |  |  | Enter this amount on line #13 of the 'Balance Sheet' in the 'Financial Data" tab. (Line 3 should be '0.00')
Period 4 |  |  |  |  | Enter the amount showing on line #3 of the appropriate 'Profit Center' in the 'Profit Center" tab.
 |  |  |  |  | Enter this amount on line #3 of the 'Balance Sheet' in the 'Financial Data" tab. (Line 13 should be '0.00')
 |  |  |  |  | Enter this amount on line #13 of the 'Balance Sheet' in the 'Financial Data" tab. (Line 3 should be '0.00')
Period 5 |  |  |  |  | Enter the amount showing on line #3 of the appropriate 'Profit Center' in the 'Profit Center" tab.
 |  |  |  |  | Enter this amount on line #3 of the 'Balance Sheet' in the 'Financial Data" tab. (Line 13 should be '0.00')
 |  |  |  |  | Enter this amount on line #13 of the 'Balance Sheet' in the 'Financial Data" tab. (Line 3 should be '0.00')
Period 6 |  |  |  |  | Enter the amount showing on line #3 of the appropriate 'Profit Center' in the 'Profit Center" tab.
 |  |  |  |  | Enter this amount on line #3 of the 'Balance Sheet' in the 'Financial Data" tab. (Line 13 should be '0.00')
 |  |  |  |  | Enter this amount on line #13 of the 'Balance Sheet' in the 'Financial Data" tab. (Line 3 should be '0.00')
Period 7 |  |  |  |  | Enter the amount showing on line #3 of the appropriate 'Profit Center' in the 'Profit Center" tab.
 |  |  |  |  | Enter this amount on line #3 of the 'Balance Sheet' in the 'Financial Data" tab. (Line 13 should be '0.00')
 |  |  |  |  | Enter this amount on line #13 of the 'Balance Sheet' in the 'Financial Data" tab. (Line 3 should be '0.00')
Period 8 |  |  |  |  | Enter the amount showing on line #3 of the appropriate 'Profit Center' in the 'Profit Center" tab.
 |  |  |  |  | Enter this amount on line #3 of the 'Balance Sheet' in the 'Financial Data" tab. (Line 13 should be '0.00')
 |  |  |  |  | Enter this amount on line #13 of the 'Balance Sheet' in the 'Financial Data" tab. (Line 3 should be '0.00')
Period 9 |  |  |  |  | Enter the amount showing on line #3 of the appropriate 'Profit Center' in the 'Profit Center" tab.
 |  |  |  |  | Enter this amount on line #3 of the 'Balance Sheet' in the 'Financial Data" tab. (Line 13 should be '0.00')
 |  |  |  |  | Enter this amount on line #13 of the 'Balance Sheet' in the 'Financial Data" tab. (Line 3 should be '0.00')
Period 10 |  |  |  |  | Enter the amount showing on line #3 of the appropriate 'Profit Center' in the 'Profit Center" tab.
 |  |  |  |  | Enter this amount on line #3 of the 'Balance Sheet' in the 'Financial Data" tab. (Line 13 should be '0.00')
 |  |  |  |  | Enter this amount on line #13 of the 'Balance Sheet' in the 'Financial Data" tab. (Line 3 should be '0.00')
Period 11 |  |  |  |  | Enter the amount showing on line #3 of the appropriate 'Profit Center' in the 'Profit Center" tab.
 |  |  |  |  | Enter this amount on line #3 of the 'Balance Sheet' in the 'Financial Data" tab. (Line 13 should be '0.00')
 |  |  |  |  | Enter this amount on line #13 of the 'Balance Sheet' in the 'Financial Data" tab. (Line 3 should be '0.00')
Period 12 |  |  |  |  | Enter the amount showing on line #3 of the appropriate 'Profit Center' in the 'Profit Center" tab.
 |  |  |  |  | Enter this amount on line #3 of the 'Balance Sheet' in the 'Financial Data" tab. (Line 13 should be '0.00')
 |  |  |  |  | Enter this amount on line #13 of the 'Balance Sheet' in the 'Financial Data" tab. (Line 3 should be '0.00')