Spreadsheet: 43886d1242514462-if-statement-problem-estimate2
Sheet: Estimate

 |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 0
 |  |  |  | [NAME] |  |  |  |  | Cost |  | Value | Quantity |  |  |  | Totals
 |  |  |  | ENQ Number: |  |  | Labour (Per Hour): |  |  |  |  |  |  | Hours |  | Total  Hours Sold |  |  |  | 0
 |  |  |  | Proposal Date: | 2009-05-16 00:00:00 |  |  |  |  |  |  |  |  |  |  | Total  Hours Cost |  |  |  | 0
 |  |  |  | Salesman: |  |  | Commissioning (Per Hour): |  |  |  |  |  |  | Hours |  | Total  Hours Value |  |  |  | 0
 |  |  |  |  |  |  | Congestion Charge (P/Day, P/Vehicle): |  |  |  |  |  |  | Days |  | Total  Material Cost |  |  |  | 0
 | Address To Send Proposal (If [NAME]. To Site) |  |  | Site Address |  |  |  |  |  |  |  |  |  |  |  | Total  Material Sell |  |  |  | 0
 | Contact Name: |  |  | Contact Name: |  |  | Travel (Per Hour): |  |  |  |  |  |  | Hours
 | Company Name: |  |  | Company Name:
 |  |  |  |  |  |  | Engineer Parking (P/Day, P/Vehicle): |  |  |  |  |  |  | Days |  | Total Sub Labour Sell |  |  |  | 0
 | Address: |  |  | Address: |  |  |  |  |  |  |  |  |  |  |  | Total Sub Materials Sell |  |  |  | 0
 |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | Unit/s |  | Total Travel Time & Parking Sell |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Congestion Charge |  |  |  | 0
 |  |  |  |  |  |  | Classic Redcare Monitoring |  |  |  |  |  |  | Unit/s
 | Post Code: |  |  | Postcode: |  |  |  |  |  |  |  |  |  |  |  | Overall [NAME] |  |  |  | #N/A
 | Home Telephone Number: |  |  | Home Telephone Number: |  |  | Redcare GSM Monitoring |  |  |  |  |  |  | Unit/s
 | Work Telephone Number: |  |  | Work Telephone Number: |  |  |  |  |  |  |  |  |  |  |  | Project Sell Total |  |  |  | 0
 | Fax Number: |  |  | Fax Number: |  |  | Maintainence |  |  | Additional Markups/Rates |  |  |  |  |  | Opportunity Selling Price |  |  |  | 0
 | Mobile Telephone Number: |  |  | Mobile Telephone Number: |  |  | Standard |  |  | Sub-Contract Labour
 | [NAME]: |  |  | [NAME]: |  |  | Silver |  |  | Sub-Contract Material |  |  |  |  |  | VAT @15% |  |  |  | 0
 |  |  |  |  |  |  | Gold |  |  | Works Expenses Rate |  |  |  |  |  | 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 |  | d
 | Test |  |  |  |  |  |  | IAS | 1234 |  |  | 1 |  |  | 20 |  |  |  |  |  |  |  |  |  |  | [NAME]
 | [NAME] |  |  |  |  |  |  | IAS | 1235 |  |  | 1 |  |  | 34 |  |  |  |  |  |  |  |  |  |  | IAS-2
 | TEst2 |  |  |  |  |  |  | IAS | 1236 |  |  | 1 |  |  | 35 |  |  |  |  |  |  |  |  |  |  | IAS-3
 | yesy3 |  |  |  |  |  |  | IAS | 1237 |  |  | 1 |  |  | 45 |  |  |  |  |  |  |  |  |  |  | IAS-4
 | test4 |  |  |  |  |  |  | AC | 1238 |  |  | 1 |  |  | 54 |  |  |  |  |  |  |  |  |  |  | AC-1
 | test5 |  |  |  |  |  |  | AC | 1239 |  |  | 1 |  |  | 56 |  |  |  |  |  |  |  |  |  |  | AC-2
 | test5 |  |  |  |  |  |  | AC | 1240 |  |  | 1 |  |  | 67 |  |  |  |  |  |  |  |  |  |  | AC-3
 | 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 | 0
 | - Accepted
 | Service Premium
 | - Quoted | 0 |  | 0 | 0
 | - Accepted