Spreadsheet: 107616d1304725422-performing-multiple-vlookups-new-spreadsheet
Sheet: WorkSheet

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WORK SHEET |  |  |  | DATE |  | CUSTOMER NAME |  |  |  | CUSTOMER EMAIL |  | PHONE # |  |  | SALES REP |  | INVOICE #
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | VALID APRIL 30 - MAY 1 |  |  |  | 2011-05-06 19:42:57 |  |  |  |  |  |  |  |  |  |  | [NAME]
 | Series ULTRA | # | W | H | sq' | BAY BOW | BAY BOW MULL PRICE | BASE PRICE | OP | OP PRICE | GLASS | GLASS PRICE | OBS | OBS PRICE | WG | WDGRAIN PRICE | BM | BM PRICE | DWR | DWR PRICE | SHAPES | SHAPE PRICE | COLOURS | COLOUR PRICE | GRILLS | SQ' | GRILL PRICE | DOORS |  | DOOR LIST | PATIO DOORS |  | PATIO PRICING | LABOUR | LABOUR PRICE | LABOUR EXTRAS | LABOUR EXTRA PRICE | OTHER LIST |  | LIST
A | 3003F | 1 | 60 | 60 | 25 |  | 0 | 1898.75 |  | 0 | U | 0 |  | 0 |  | 0 |  | 0 |  | 0 | - | 0 | - | 0 |  |  | 0 | DUC | - | 0 | RYL | - | 0 | - | 0 | - | 0 |  |  | 1898.75
B |  |  |  |  |  |  | 0 | 0 |  | 0 | U | #N/A |  | 0 |  | 0 |  | 0 |  | 0 | - | 0 | - | 0 |  |  | 0 | DUC | - | 0 | RYL | - | 0 | - | 0 | - | 0 |  |  | 0
C |  |  |  |  |  |  | 0 | 0 |  | 0 | U | #N/A |  | 0 |  | 0 |  | 0 |  | 0 | - | 0 | - | 0 |  |  | 0 | DUC | - | 0 | RYL | - | 0 | - | 0 | - | 0 |  |  | 0
D |  |  |  |  |  |  | 0 | 0 |  | 0 | U | #N/A |  | 0 |  | 0 |  | 0 |  | 0 | - | 0 | - | 0 |  |  | 0 | DUC | - | 0 | RYL | - | 0 | - | 0 | - | 0 |  |  | 0
E |  |  |  |  |  |  | 0 | 0 |  | 0 | U | #N/A |  | 0 |  | 0 |  | 0 |  | 0 | - | 0 | - | 0 |  |  | 0 | DUC | - | 0 | RYL | - | 0 | - | 0 | - | 0 |  |  | 0
F |  |  |  |  |  |  | 0 | 0 |  | 0 | U | #N/A |  | 0 |  | 0 |  | 0 |  | 0 | - | 0 | - | 0 |  |  | 0 | DUC | - | 0 | RYL | - | 0 | - | 0 | - | 0 |  |  | 0
G |  |  |  |  |  |  | 0 | 0 |  | 0 | U | #N/A |  | 0 |  | 0 |  | 0 |  | 0 | - | 0 | - | 0 |  |  | 0 | DUC | - | 0 | RYL | - | 0 | - | 0 | - | 0 |  |  | 0
H |  |  |  |  |  |  | 0 | 0 |  | 0 | U | #N/A |  | 0 |  | 0 |  | 0 |  | 0 | - | 0 | - | 0 |  |  | 0 | DUC | - | 0 | RYL | - | 0 | - | 0 | - | 0 |  |  | 0
I |  |  |  |  |  |  | 0 | 0 |  | 0 | U | #N/A |  | 0 |  | 0 |  | 0 |  | 0 | - | 0 | - | 0 |  |  | 0 | DUC | - | 0 | RYL | - | 0 | - | 0 | - | 0 |  |  | 0
J |  |  |  |  |  |  | 0 | 0 |  | 0 | U | #N/A |  | 0 |  | 0 |  | 0 |  | 0 | - | 0 | - | 0 |  |  | 0 | DUC | - | 0 | RYL | - | 0 | - | 0 | - | 0 |  |  | 0
2A |  |  |  |  |  |  | 0 | 0 |  | 0 | U | #N/A |  | 0 |  | 0 |  | 0 |  | 0 | - | 0 | - | 0 |  |  | 0 | DUC | - | 0 | RYL | - | 0 | - | 0 | - | 0 |  |  | 0
2B |  |  |  |  |  |  | 0 | 0 |  | 0 | U | #N/A |  | 0 |  | 0 |  | 0 |  | 0 | - | 0 | - | 0 |  |  | 0 | DUC | - | 0 | RYL | - | 0 | - | 0 | - | 0 |  |  | 0
2C |  |  |  |  |  |  | 0 | 0 |  | 0 | U | #N/A |  | 0 |  | 0 |  | 0 |  | 0 | - | 0 | - | 0 |  |  | 0 | DUC | - | 0 | RYL | - | 0 | - | 0 | - | 0 |  |  | 0
2D |  |  |  |  |  |  | 0 | 0 |  | 0 | U | #N/A |  | 0 |  | 0 |  | 0 |  | 0 | - | 0 | - | 0 |  |  | 0 | DUC | - | 0 | RYL | - | 0 | - | 0 | - | 0 |  |  | 0
2E |  |  |  |  |  |  | 0 | 0 |  | 0 | U | #N/A |  | 0 |  | 0 |  | 0 |  | 0 | - | 0 | - | 0 |  |  | 0 | DUC | - | 0 | RYL | - | 0 | - | 0 | - | 0 |  |  | 0
2F |  |  |  |  |  |  | 0 | 0 |  | 0 | U | #N/A |  | 0 |  | 0 |  | 0 |  | 0 | - | 0 | - | 0 |  |  | 0 | DUC | - | 0 | RYL | - | 0 | - | 0 | - | 0 |  |  | 0
2G |  |  |  |  |  |  | 0 | 0 |  | 0 | U | #N/A |  | 0 |  | 0 |  | 0 |  | 0 | - | 0 | - | 0 |  |  | 0 | DUC | - | 0 | RYL | - | 0 | - | 0 | - | 0 |  |  | 0
2H |  |  |  |  |  |  | 0 | 0 |  | 0 | U | #N/A |  | 0 |  | 0 |  | 0 |  | 0 | - | 0 | - | 0 |  |  | 0 | DUC | - | 0 | RYL | - | 0 | - | 0 | - | 0 |  |  | 0
2I |  |  |  |  |  |  | 0 | 0 |  | 0 | U | #N/A |  | 0 |  | 0 |  | 0 |  | 0 | - | 0 | - | 0 |  |  | 0 | DUC | - | 0 | RYL | - | 0 | - | 0 | - | 0 |  |  | 0
2J |  |  |  |  | #N/A |  | 0 | 0 |  | 0 | U | #N/A |  | 0 |  | 0 |  | 0 |  | 0 | - | 0 | - | 0 |  |  | 0 | DUC | - | 0 | RYL | - | 0 | - | 0 | - | 0 |  |  | 0
 | CATEGORY |  |  | OPTIONS |  |  |  |  |  |  |  |  |  |  |  |  | # |  | SQ' |  | TOTAL | options total | FINANCE OPTIONS |  |  |  |  | Y/N | WINDOW LIST |  | 1898.75 |  |  | NET WINDOW(s) |  |  |  | 996.60640625
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | AMOUNT FINANCED |  | 0 |  |  |  | OPTIONS |  | 0 |  |  | NET WINDOW GRILLS |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | ADDITIONAL DEPOSIT |  | 0 |  |  |  | OTHER LIST |  | 0 |  |  | NET DOOR(s) |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | BALANCED FINANCED |  | 0 |  |  |  | TOTAL LIST |  | 1898.75 |  |  | NET PATIO DOOR(s) |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  | N | SUPPLY ONLY |  | 0 |  |  | NET ITEM / $ LABOUR
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 4.99% MONTHLY |  | 0 |  |  |  | INSTALLED LIST |  | 1898.75 |  |  | SUBTOTAL |  |  |  | 996.60640625
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 4.99% BIWEEKLY |  | 0 |  |  |  |  |  |  |  |  | TOTAL LABOUR |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0% 12 MONTHS |  |  |  |  | 0.35 | DISCOUNT |  | 1234.1875 |  |  | TOTAL LABOUR EXTRAS |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 DOWN 10K + |  |  |  |  | N | FREE PAINT ? |  | 1049.059375
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | N/A |  | 0 |  |  |  | CASH |  | 996.60640625 |  |  | SUB TOTAL |  |  |  | 996.60640625
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | N/A |  | 0 |  |  |  | DISCOUNT |  |  |  |  | H.S.T |  |  |  | 129.5588328125
 | NOTES: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | SUB TOTAL |  | 996.60640625 |  |  | SUB TOTAL |  |  |  | 1126.1652390625
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | COST ADJUSTMENT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GRAND TOTAL |  |  |  | 1126.1652390625