Spreadsheet: 149044d1333657741-can-the-colour-of-one-cell-be-determined-by-the-information-in-another-lastest-logs1
Sheet: Sheet2

NO: | TYPE | NAME | VEHICLE | REG NO | STK NO | CONV | OPT | VOLUME | COMM | % | TERM | VOL BON | GSP | G/T | G/PROFIT | S.G/SP | S.G/P | GIVE | COST | SOLD | TOTAL COST | SP | MBI PRO |  | NAME | REG NO | STK NO | SERVICE PLAN LETTER | FINANCE OFFER | GAP INFO | S/G OFFER | WARRANTY LETTER | NOTES
1 | USED | SMITH | FIESTA | EA10TYU | 23242 | SANT | YES | 10000 | 250 | 0.04 | 34 | 250 | 349 | B |  | 299 |  | 12S |  | 12S |  | 330
2 | USED |  | MONDEO |  |  | £ | NO
 |  | CAR
 |  | COMMERCIAL |  |  |  |  |  |  |  |  |  |  |  |  | GAP |  | S/GUARD |  |  |  |  |  | SALES
 |  | TOTAL
 |  |  |  |  |  |  | AVE PCP | AVE VOL | AVE COMM | AVE % |  | AVE V.B |  |  | AVE S/G PRO |  | AVE S/G PRO |  |  |  |  |  | AVE S/G PRO
 |  |  | CAR | COMM
 |  | CONTRACT HIRE | 1 |  |  |  |  |  |  |  |  |  |  |  | PEN |  | PEN |  |  |  |  |  | PEN
 |  | COURIER / CAB
NO: | TYPE OF CUSTOMER | NAME | VEHICLE | REG NO | STK NO | CONV | OPT | VOLUME | COMM | % | TERM | VOL BON | GSP | G/T | G/PROFIT | S.G/SP | S.G/P | GIVE | COST | SOLD | TOTAL COST | SP | MBI PRO
1 | EMPLOYEE | FRED | CONNECT |  |  | FCE | YES | 10000 | 500 | 0.04 | 36 | 250 | 299 | A |  | 299 |  | 12s |  | 12s |  | 330
2 | EMPLOYEE | MORRIS | FIESTA |  |  | £ |  |  |  |  |  |  | 399 | B |  | 299 |  | 12s |  | 12s |  | 330
3 | EMPLOYEE | WHITTING | FOCUS |  |  | FCE | YES | 7000 | 320 | 0.04 | 24 | 155 | 299 | A
4 | RETAIL | WEST | TRANSIT |  |  | £
 |  |  |  |  |  |  |  |  |  | 0.04
 |  |  |  |  |  |  |  |  |  | 0.04
 |  |  |  |  |  |  |  |  |  | 0.04
 |  |  |  |  |  |  |  |  |  | 0.04
 |  |  |  |  |  |  |  |  |  | 0.04
 |  |  |  |  |  |  |  |  |  | 0.04
 |  |  |  |  |  |  |  |  |  | 0.04
 |  |  |  |  |  |  |  |  |  | 0.04
 |  |  |  |  |  |  |  |  |  | 0.04
 |  |  |  |  |  |  |  |  |  | 0.04
 |  |  |  |  |  |  |  |  |  | 0.04
 |  |  |  |  |  |  |  |  |  | 0.04
 |  |  |  |  |  |  |  |  |  | 0.04
 |  |  |  |  |  |  |  |  |  | 0.04
 |  |  |  |  |  |  |  |  |  | 0.04
 |  |  |  |  |  |  |  |  |  | 0.04
 |  |  |  |  |  |  |  |  |  | 0.04
 |  |  |  |  |  |  |  |  |  | 0.04
 |  |  |  |  |  |  |  |  |  | 0.04
 |  |  |  |  |  |  |  |  |  | 0.04
 |  |  |  |  |  |  |  |  |  | 0.04
 |  |  |  |  |  |  |  |  |  | 0.04
 |  |  |  |  |  |  |  |  |  | 0.04
 |  |  |  |  |  |  |  |  |  | 0.04
 |  |  |  |  |  |  |  |  |  | 0.04
 |  |  |  |  |  |  |  |  |  | 0.04
 |  |  |  |  |  |  |  |  |  | 0.04
 |  |  |  |  |  |  |  |  |  | 0.04
 |  |  |  |  |  |  |  |  |  | 0.04
 |  |  |  |  |  |  |  |  |  | 0.04
 |  |  |  |  |  |  |  |  |  | 0.04
 |  |  |  |  |  |  |  |  |  | 0.04
 |  |  |  |  |  |  |  |  |  | 0.04
 |  |  |  |  |  |  |  |  |  | 0.04
 |  |  |  |  |  |  |  |  |  | 0.04
 |  |  |  |  |  |  |  |  |  | 0.04
 |  |  |  |  |  |  |  |  |  | 0.04
 |  |  |  |  |  |  |  |  |  | 0.04
 |  |  |  |  |  |  |  |  |  | 0.04
 |  |  |  |  |  |  |  |  |  | 0.04
 |  |  |  |  |  |  |  |  |  | 0.04
 |  |  |  |  |  |  |  |  |  | 0.04
 |  |  |  |  |  |  |  |  |  | 0.04
 |  |  |  |  |  |  |  |  |  | 0.04
 |  | NEW CAR
 |  | COMMERCIAL |  |  |  |  |  |  |  |  |  |  |  |  | GAP |  | S/GUARD |  |  |  |  |  | SALES
 |  | TOTAL
 |  |  |  |  |  |  | AVE PCP | AVE VOL | AVE COMM | AVE % |  | AVE V.B |  |  | AVE S/G PRO |  | AVE S/G PRO |  |  |  |  |  | AVE S/G PRO
 |  |  | CAR | COMM
 |  | CONTRACT HIRE |  |  |  |  |  |  |  |  |  |  |  |  | PEN |  | PEN |  |  |  |  |  | PEN
 |  | COURIER / CAB
 |  | NEW CAR
 |  | COMMERCIAL |  |  |  |  |  |  |  |  |  |  |  |  | GAP |  | S/GUARD |  |  |  |  |  | SALES
 |  | TOTAL
 |  |  |  |  |  |  | AVE PCP | AVE VOL | AVE COMM |  |  | AVE V.B |  |  | PEN |  | PEN |  |  |  |  |  | PEN
 |  |  | CAR | COMM
 |  | CONTRACT HIRE
 |  | COURIER / CAB