Spreadsheet: 160787d1339190216-count-the-number-of-populated-cells-in-column-n-based-on-data-in-column-d-june-202012-20doc-1-
Sheet: INPUT

 |  |  |  |  |  |  | 2012-06-01 00:00:00
 |  | RETAIL
 |  | DATE | SP | MGR | TYPE | CUSTOMER | TAXED | ORD NUM | MODEL | SPEC/DOORS | METAL | RATE | VB | GAP | SMART | TYRE | P/F | TOTAL F&I | TOTAL |  | VIEW POINT |  | ACC | FAXED | PAID | FIN CO |  | FILE RET |  |  | COST PRICE |  | 2Y OP | 3Y OP | 2Y AQ | 3YAQ | 4Y AQ | 2Y CP | 3Y CP | OTHER | PAYMENT |  | NOTES / NCM
 | 1 | 2012-05-07 00:00:00 | SO | MF | 1B | BAMBER |  | E9788 | FIESTA | 1.4 EDGE 5DR AUTO | 429.13 |  |  |  | 128.17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CASH
 | 2 | 2012-05-06 00:00:00 | SO | MF | 1B | MATHESON |  | F0265 | KUGA | 2.0 TDCI TIT X MAN | 1592.26 |  | 50 | 212.49 |  |  |  |  |  |  |  |  | ACC |  |  | FCE |  |  |  |  |  |  |  |  | Y |  |  |  |  |  | 112.52
 | 3 | 2012-06-02 00:00:00 | SO | CG | 1B | [NAME] |  |  | FIESTA | 1.25 60PS EDGE 5 DOOR | 33.04 |  | 189.9 | 180.83 |  |  |  |  |  |  |  |  | ACC |  |  | FCE |  |  |  |  |  |  |  |  | Y |  |  |  |  |  | 427.35 |  | TRANS FROM GLASGOW
 | 4 | 2012-06-04 00:00:00 | SO | CG | 1B | PORTER |  | A7365 | S-MAX | 2.0TDCI TITANIUM | -1224.56 |  | 230.36 | 212.49 | 128.17 |  | 135.83 |  |  |  |  |  | ACC | 2012-06-08 00:00:00 |  | FCE |  |  |  |  | 20397.71 |  |  |  |  |  |  | Y
 | 5 | 2012-06-05 00:00:00 | SO | CG | 1B | MOSS |  |  | FIESTA | 1.25 60PS EDGE 3 DOOR | -228.62 |  | 179.9 |  |  |  | 135.8 |  |  |  |  |  | ACC | 2012-06-08 00:00:00 |  | FCE |  |  |  |  | 8754.74 |  | Y |  |  |  |  |  |  |  | 85.7
 | 6 | 2012-06-05 00:00:00 | OTHER | CG | 1B | HOPKINS |  | [NAME] | FIESTA | 1.25 60PS EDGE 5DR | -214.45 |  | 173.88 | 180.83 |  |  |  |  |  |  |  |  | ACC | 2012-06-06 00:00:00 |  | FCE |  |  |  |  | 9356.3 |  |  | Y |  |  |  |  |  |  | 146.95 |  | PASSED TO EMMA 6/6/12
 | 7 | 2012-06-06 00:00:00 | BB | CG | 1B | ROSE |  | F0013 | FIESTA | 1.25 ZETEC 5DR | -216.66 |  |  | 180.83 |  |  |  |  |  |  |  |  |  |  |  | CASH |  |  |  |  | 10439.11 |  |  |  |  |  |  |  |  | CASH
 | 8 | 2012-06-07 00:00:00 | SO | MF | 1B | WHYMARK |  |  | FIESTA | 1.25 60PS EDGE 5 DR | -314.45 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CASH |  |  |  |  |  |  |  |  |  |  |  |  |  | CASH |  |  | CAR FROM MANCHESTER ETA 23/6
 | 9 | 2012-06-07 00:00:00 | RH | MF | 1B | PEET
 | 10 | 2012-06-07 00:00:00 | BB | MF | 1B | DUFFELL
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
 | 21
 | 22
 | 23
 | 24
 | 25
 | 26
 | 27
 | 28
 | 29
 | 30
 | 31
 | 32
 | 33
 | 34
 | 35
 | 36
 | 37
 | 38
 | 39
 | 40
 | 41
 | 42
 | 43
 | 44
 | 45
 | 46
 | 47
 | 48
 | 49
 | 50
 | 51
 | 52
 | 53
 | 54
 | 55
 | 56
 | 57
 | 58
 | 59
 | 60
 | 60 | 03.05.12 | RH |  | 1B | ARMSTRONG | 2012-05-31 00:00:00 |  | KA | 1.2 EDGE 3DR | -86.74 |  | 114 |  |  |  |  |  |  |  |  |  | ACC |  |  | FCE |  |  |  |  |  |  | Y |  |  |  |  |  |  |  | 66.87
 | 62 | 28.5.12 | RH |  | 1B | CLEMENTS | 2012-05-31 00:00:00 |  | KA | 1.2 EDGE 3DR | -231.32 |  |  | 180.83 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y |  |  |  |  |  |  | CASH
 | 63 | 2012-05-19 00:00:00 | [NAME] |  | 1B | O WATSON | 2012-05-31 00:00:00 |  | FIESTA | 1.4 EDGE 5DR | -353.34 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CASH
 | 64 | 2012-05-19 00:00:00 | [NAME] |  | 1B | J WATSON | 2012-05-31 00:00:00 |  | FIESTA | 1.4 EDGE 5DR | -353 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CASH
 | 65 | 30.5.12 | [NAME] |  | 1B | HOUGH | 2012-05-31 00:00:00 |  | KA | 1.2 ZETEC 3DR | -438.65 |  | 148.73 | 180.83 |  |  |  |  |  |  |  |  | ACC |  |  | FCE
 |  |  |  |  |  |  |  |  |  | TOTALS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y
 |  | EMPS
 |  | DATE | SP | MGR | TYPE | CUSTOMER | TAXED | ORD NUM | MODEL | SPEC/DOORS | METAL | RATE | VB | GAP | SMART | TYR | P/F | TOTAL F&I | TOTAL |  | VIEW POINT |  | ACC | FAXED | PAID | FIN CO |  | FILE RET |  |  | COST Price |  | 2Y OP | 3Y OP | 2Y AQ | 3YAQ | 4Y AQ |  | CP | OTHER | PAYMENT |  | NOTES / NCM
 | 1 | 08.05.12 | [NAME] |  | 4C | RICHARDSON | 2012-05-31 00:00:00 |  | KUGA
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10 | 30.5.12 | BB |  | 4C | DOHERTY | 2012-05-31 00:00:00 |  | FIESTA |  | -196.1 |  | 205 |  |  |  |  |  |  |  |  |  | ACC |  |  | FCE |  |  |  |  |  |  |  | Y |  |  |  |  |  |  | 195.8
 |  |  |  |  |  |  |  |  |  | TOTALS
 |  | MOTABILITY
 |  | DATE | SP | MGR | MOB | CUSTOMER | TAXED | ORD NUM | MODEL | SPEC/DOORS | PROFIT | DISC | BONUS |  |  |  | P/F |  | TOTAL |  | VIEW POINT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NOTES / NCM
 | 1 |  | RH |  | 1W | [NAME] |  |  | CMAX |  | 350 | -100
 | 2 |  | RH |  | 1W | RAINFORD |  |  | FOCUS |  | 350 | -100
 | 3 |  | RH |  | 1W | [NAME] |  |  | MONDEO |  | 350 | -100
 | 4 |  | RH |  | 1W | GRAHAM |  |  | FOCUS |  | 350 | -105
 | 5 |  | RH |  | 1W | COOK |  |  | FOCUS |  | 350
 | 6 |  | RH |  | 1W | RILEY |  |  | FOCUS |  | 350 | -100
 | 7 |  | RH |  | 1W | STRATFORD |  |  | FOCUS |  | 350 | -195
 | 8 |  | RH |  | 1W | SWAN |  |  | FOCUS |  | 350
 | 9 |  | RH |  | 1W | TAYLOR |  |  | C-MAX |  | 350
 | 10 |  | RH |  | 1W | SCOTT |  |  | C-MAX |  | 350
 | 11 |  | RH |  | 1W | MOLYNEUX |  |  | MONDEO |  | 350 | -300
 | 12 |  | RH |  | 1W | MURPHEY |  |  | S-MAX |  | 350 | -300
 | 13 |  | RH |  | 1W | KERANS |  |  | FOCUS |  | 350 | -260
 | 14 |  | RH |  | 1W | ECCLES |  |  | FIESTA |  | 350
 | 15 |  | RH |  | 1W | DUTTON |  |  | S-MAX |  | 350 | -825 | 500
 | 16 |  | RH |  | 1W | DEVONPORT |  |  | FOCUS |  | 350
 | 17 |  | RH |  | 1W | DOLAN |  |  | S-MAX |  | 350 | -1525 | 1500
 | 18 |  | RH |  | 1W | SAYERS |  |  | S-MAX |  | 350
 | 19 |  | RH |  | 1W | CARR |  |  | C-MAX |  | 350
 | 20 |  | RH |  | 1W | KRAMER |  |  | GALAXY |  | 350 | -350
 | 21 |  | RH |  | 1W | GALAGHER |  |  | S-MAX |  | 350
 | 22 |  | SO |  | 1W | LAVERTY |  |  | FOCUS
 | 23
 | 24
 | 25
 | 26
 | 27
 | 28
 | 29
 | 30
 |  |  |  |  |  |  |  |  |  |  |  |  | DOC PROFIT |  |  |  |  |  |  |  |  | VIEWPOINT AVERAGE