Spreadsheet: 149997d1334242080-countif-using-two-criteria-master_nov_temp
Sheet: November 2011

 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-11-01 00:00:00
2011-11-01 00:00:00 |  |  |  |  |  |  |  |  |  | Weekly Totals by Return Date |  |  |  | 2011-11-01 00:00:00
Total Value Of Mechanical Estimates Submitted To Date |  |  |  |  |  |  |  |  |  | 2011-11-04 00:00:00 |  |  |  | 2011-11-30 00:00:00
Total Value Of Mechanical Orders Received To Date
Current Mechanical Success Rate
Total Value Of Electrical Estimates Submitted To Date
Total Value Of Electrical Orders Received To Date
Current Electrical Success Rate
Total Value Of M & E Estimates Submitted inc Prelims |  |  |  |  |  |  |  |  |  | Pending
Total Value Of M & E Orders Received inc Prelims |  |  |  |  |  |  |  |  |  | Won
Current Mechanical & Electrical Success Rate |  |  |  |  |  |  |  |  |  | Lost
Total  No. of Estimates |  |  |  |  |  |  | Av estimate value
Total No. Won
Ratio of won against estimated                               1 in |  |  |  |  |  |  | Av estimate won value
Total  No. of Estimates Excluding Pending & Estimating
Total No. Won
Ratio of won against estimated                               1 in
Est. | Office | Business | Estimators | Received | Return | Client | Project | Project Start | Project Length | £ M (&P?) | £ E | £ M&E Total | £ Total inc Prelim | Comm. | Action | Outcome | Order Value | Order Value | Order Value | Order Value WON | Pending Value
No. | Quoting | Unit | (M/E) | Date | Date |  |  | Date | Days |  |  |  |  |  |  | W/L/P | M&P | E | Panel Shop | Total | Total
 |  |  |  |  |  |  |  |  |  | 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 |  | 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 | 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
 |  |  |  |  |  |  |  |  |  | 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 |  | 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 | 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