Spreadsheet: 45230d1244015825-if-statement-displaying-a-cell-that-corresponds-to-another-cell-nearly
Sheet: Estimate

 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 0
 |  |  |  | [NAME] |  |  |  |  |  | Cost |  | Sell |  |  |  |  | Totals
 |  |  |  | ENQ Number: |  |  | Labour (Per Hour): |  |  |  |  |  |  |  | Hours |  | Work Expenses |  |  |  | 0
 |  |  |  | Proposal Date: | 2009-06-03 00:00:00
 |  |  |  | Salesman: |  |  | Commissioning (Per Hour): |  |  |  |  |  |  |  | Hours |  | Total Hours Sold |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Hours Cost |  |  |  | 0
 |  |  |  |  |  |  | Congestion Charge (P/Day, P/Vehicle): |  |  |  |  |  |  |  | Days |  | Total  Material Cost |  |  |  | 0
 | Address To Send Proposal (If [NAME]. To Site) |  |  | Site Address |  |  |  |  |  |  |  |  |  |  |  |  | Total Costs to |  |  |  | 0
 | Contact Name: |  |  | Contact Name: |  |  | Travel (Per Hour): |  |  |  |  |  |  |  | Hours
 | Company Name: |  |  | Company Name: |  |  |  |  |  |  |  |  |  |  |  |  | Total  Material Sell |  |  |  | 0
 |  |  |  |  |  |  | Engineer Parking (P/Day, P/Vehicle): |  |  |  |  |  |  |  | Days |  | Total  Hours Sell |  |  |  | 0
 | Address: |  |  | Address: |  |  |  |  |  |  |  |  |  |  |  |  | Total Sub Labour Sell |  |  |  | 0
 |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | Unit/s |  | Total Sub Materials Sell |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Travel Sell |  |  |  | 0
 |  |  |  |  |  |  | Classic Redcare Monitoring |  |  |  |  |  |  |  | Unit/s |  | Parking Sell |  |  |  | 0
 | Post Code: |  |  | Postcode: |  |  |  |  |  |  |  |  |  |  |  |  | Congestion Charge Sell |  |  |  | 0
 | Home Telephone Number: |  |  | Home Telephone Number: |  |  | Redcare GSM Monitoring |  |  |  |  |  |  |  | Unit/s
 | Work Telephone Number: |  |  | Work Telephone Number: |  |  |  |  |  |  |  |  |  |  |  |  | Material [NAME] |  |  |  | #N/A
 | Fax Number: |  |  | Fax Number: |  |  | Maintainence | Value | Hours |  | Additional Markups/Rates |  |  |  |  |  | [NAME] |  |  |  | #N/A
 | Mobile Telephone Number: |  |  | Mobile Telephone Number: |  |  | Standard | 1000 | 10 |  | Sub-Contract Labour |  |  |  |  |  | Installation Target Profit |  |  |  | 0
 | [NAME]: |  |  | [NAME]:
 |  |  |  |  |  |  | Silver | 1200 | 12 |  | Sub-Contract Material |  |  |  |  |  | Project Sell Total |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Opportunity Selling Price |  |  |  | 0
 |  |  |  |  |  |  | Gold | 1400 | 14 |  | Work Expenses Rate
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | VAT @15% |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Project Grand Total |  |  |  | 0
 | Equipment Description |  |  |  |  |  |  | System Type |  | Product Reference |  |  | Quantity |  |  | Material Unit Cost |  | Material Total Cost |  | Material Unit Sell |  |  | Individual [NAME] | Material Total Sell
 | dddd |  |  |  |  |  |  | CCTV |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CCTV-1
 | ddee |  |  |  |  |  |  | CCTV |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CCTV-2
 | pppe |  |  |  |  |  |  | CCTV |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CCTV-3
 | pppe |  |  |  |  |  |  | CCTV |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CCTV-4
 | pppe |  |  |  |  |  |  | CCTV |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CCTV-5
 | Sub Contractor |  | Description |  |  |  |  |  |  | Labour Cost |  |  | Material Cost |  |  | Labour Margin |  | Materials Margin |  |  |  |  |  |  |  |  |  | Labour Margin | Materials Margin
 |  | Labour |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | Material |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | Labour |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | Material |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | Labour |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | Material |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Revision: May 2009 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Location: M:\Cash4w\Templates\SpreadSheets
 | Figures for transfer to c4w | Hours |  | Cost | Value
 | Main system
 | - Quoted | 0 |  | 0 | 0
 | - Accepted
 | Signalling equipment
 | - Quoted | 0 |  | 0 | 0
 | - Accepted
 | Options
 | - Quoted | 0 |  | 0 | 0
 | - Accepted
 | Monitoring
 | - Quoted | 0 |  | 0 | 0
 | - Accepted
 | Maintenance
 | - Quoted | 0 |  | 0 | 1000
 | - Accepted
 | Service Premium
 | - Quoted | 0 |  | 0 | 0
 | - Accepted