Spreadsheet: 218884d1362598736-vlookup-create-price-list-from-dropdown-bar-roofing
Sheet: Sheet2

 |  |  |  |  |  |  |  |  |  |  |  |  | 2013-01-15 00:00:00
 | Qty | Item | U/M | Description | Price |  |  |  |  | GL | ES | Vendor | Notes | Link
GAF TIMBERLINE PRESTIQUE HD LIFETIME / ARCHITECTURAL SHINGLES / 3 BUNDLES PER SQUARE |  |  |  |  | Store | Homeowner | Contractor | Premier | COST |  |  |  | Formerly called Timberline Prestique 30 | http://www.gaf.com/Roofing/Residential/Products/Shingles/Timberline/High_Definition
 |  | 0799 | EA | TIMBERLINE PRESTIQUE BARKWOOD | 35.5 | 35.5 | 33.73 | 31.95 | 27.1667 |  |  | Seven D
 |  | 0799 | EA | TIMBERLINE PRESTIQUE BISCAYNE BLUE | 36.5 | 36.5 | 34.73 | 32.95 | 28.1667 |  |  | Seven D
 |  | GAFTP30B | EA | TIMBERLINE PRESTIQUE BLACK | 31.65 | 31.65 | 30.07 | 28.49 | 25.757 | X | X | Seven D | "Charcoal"
 |  | GAFTP30FH | EA | TIMBERLINE PRESTIQUE FOX HOLLOW | 35.5 | 35.5 | 33.73 | 31.95 | 26.7626 | X | X | Seven D | "[NAME]"
 |  | 0799 | EA | TIMBERLINE PRESTIQUE HICKORY | 35.5 | 35.5 | 33.73 | 31.95 | 27.1667 |  |  | Seven D
 |  | GAFTPHG | EA | TIMBERLINE PRESTIQUE HUNTER GREEN | 35.5 | 35.5 | 33.73 | 31.95 | 27.1666 | X | X | Seven D
 |  | 0799 | EA | TIMBERLINE PRESTIQUE MISSION BROWN | 35.5 | 35.5 | 33.73 | 31.95 | 27.167 |  |  | Seven D
 |  | GAFTP30OG | EA | TIMBERLINE PRESTIQUE OYSTER GRAY | 35.5 | 35.5 | 33.73 | 31.95 | 25.7169 | X | X | Seven D
 |  | 0799 |  | TIMBERLINE PRESTIQUE PATRIOT RED | 36.5 | 36.5 | 34.73 | 32.95 | 28.1667 |  |  | Seven D
 |  | [NAME] | EA | TIMBERLINE PRESTIQUE PEWTER | 31.65 | 31.65 | 33.73 | 31.95 | 25.6356 | X | X | Seven D | "Pewter Gray"
 |  | GAFTP30SW | EA | TIMBERLINE PRESTIQUE SHAKEWOOD | 35.5 | 35.5 | 33.73 | 31.95 | 27.157 | X | X | Seven D
 |  | 0799 | EA | TIMBERLINE PRESTIQUE SLATE | 35.5 | 35.5 | 33.73 | 31.95 | 27.1667 |  |  | Seven D
 |  | GAFTP30WW | EA | TIMBERLINE PRESTIQUE WEATHERED | 35.5 | 35.5 | 33.73 | 31.95 | 26.8244 | X | X | Seven D | "Weathered Wood"
 |  | 0799 | EA | TIMBERLINE PRESTIQUE WILLIAMSBURG SLATE | 35.5 | 35.5 | 33.73 | 31.95 | 27.1667 |  |  | Seven D
GAF HIP & RIDGE SHINGLES |  |  |  |  |  |  |  |  |  |  |  |  |  | http://www.gaf.com/Roofing/Residential/Products/Ridge_Cap_Shingles/Seal_A_Ridge
 |  | 0799 | EA | HIP & RIDGE BARKWOOD | 52 | 52 | 49.4 | 46.8 | 40 |  |  | Seven D | Seal-A-Ridge
 |  | 0799 | EA | HIP & RIDGE BISCAYNE BLUE | 61 | 61 | 58 | 55.95 | 47 |  |  | Seven D | TimberTex
 |  | GAFHRB | EA | HIP & RIDGE CHARCOAL | 52 | 52 | 49.4 | 46.8 | 40 | X | X | Seven D | Seal-A-Ridge
 |  | GAFHRFH | EA | HIP & RIDGE FOX HOLLOW GRAY | 51.3 | 51.3 | 48.74 | 46.17 | 40 | X | X | Seven D | Seal-A-Ridge
 |  | 0799 | EA | HIP & RIDGE HICKORY | 52 | 52 | 49.4 | 46.8 | 40 |  |  | Seven D | Seal-A-Ridge
 |  | GAFHRHR | EA | HIP & RIDGE HUNTER GREEN | 51.3 | 51.3 | 48.74 | 46.17 | 45 | X | X | Seven D | Seal-A-Ridge
 |  | 0799 | EA | HIP & RIDGE MISSION BROWN | 52 | 52 | 49.4 | 46.8 | 40 |  |  | Seven D | Seal-A-Ridge
 |  | GAFHROG | EA | HIP & RIDGE OYSTER GRAY | 51.3 | 51.3 | 48.74 | 46.17 | 40.0486 | X | X | Seven D | Seal-A-Ridge
 |  | 0799 | EA | HIP & RIDGE PATRIOT RED | 61 | 61 | 58 | 55.95 | 47 |  |  | Seven D | TimberTex
 |  | GAFHRP | EA | HIP & RIDGE PEWTER GRAY | 51.3 | 51.3 | 48.74 | 46.17 | 40 | X | X | Seven D | Seal-A-Ridge
 |  | GAFHRSW | EA | HIP & RIDGE SHAKEWOOD | 52 | 52 | 49.4 | 46.8 | 40 | X | X | Seven D | Seal-A-Ridge
 |  | 0799 | EA | HIP & RIDGE SLATE | 52 | 52 | 49.4 | 46.8 | 40 |  |  | Seven D | Seal-A-Ridge
 |  | GAFHRWW | EA | HIP & RIDGE WEATHERED WOOD | 52 | 52 | 49.4 | 46.8 | 40 | X | X | Seven D | Seal-A-Ridge
 |  | 0799 | EA | HIP & RIDGE WILLIAMSBURG SLAT | 52 | 52 | 49.4 | 46.8 | 40 |  |  | Seven D | Seal-A-Ridge
GAF ROYAL SOVEREIGN / 3-TAB SHINGLES |  |  |  |  |  |  |  |  |  |  |  |  |  | http://www.gaf.com/Roofing/Residential/Products/Shingles/3_Tab/Royal_Sovereign
 |  | 0799 | EA | GAF ROYAL SOVEREIGN AUTUMN BROWN | 30.75 | 30.75 | 29.21 | 27.68 | 24.1667 |  |  | Seven D
 |  | GAFSB | EA | GAF ROYAL SOVEREIGN CHARCOAL | 30.75 | 30.75 | 29.21 | 27.68 | 24.1667 | X | X | Seven D
 |  | GAFSBR | EA | GAF ROYAL SOVEREIGN BROWN | 30.75 | 30.75 | 29.21 | 27.68 | 24.2209 | X | X | Seven D
 |  | [NAME] | EA | GAF ROYAL SOVEREIGN CEDAR | 30.75 | 30.75 | 29.21 | 27.68 | 24.2664 | X | X | Seven D | "Golden Cedar"
 |  | GAFSG | EA | GAF ROYAL SOVEREIGN GRAY | 30.75 | 30.75 | 29.21 | 27.68 | 24.5063 | X | X | Seven D | "Weathered Gray"
 |  | GAFSS | EA | GAF ROYAL SOVEREIGN SILVER | 30.75 | 30.75 | 29.21 | 27.68 | 24.6548 | X | X | Seven D | "Silver Lining"
 |  | 0799 | EA | GAF ROYAL SOVEREIGN SLATE | 30.75 | 30.75 | 29.21 | 27.68 | 24.1667 |  |  | Seven D
 |  | 0799 | EA | GAF ROYAL SOVEREIGN WEATHERED GRAY | 30.75 | 30.75 | 29.21 | 27.68 | 24.1667 |  |  | Seven D
 |  | GAFSW | EA | GAF ROYAL SOVEREIGN WHITE | 30.75 | 30.75 | 29.21 | 27.68 | 23.4986 | X | X | Seven D
STARTER SHINGLES
 |  | GAFPROSTART | EA | PRE-CUT STARTER STRIP SHINGLE | 44.74 | 43.71 | 41.97 | 40.27 | 33.9841 | X | X | Seven D | GAF ProStart; 120.33 lf/per bundle | http://www.gaf.com/Roofing/Residential/Products/Starter_Strip_Shingles/ProStart
ICE & WATER SHIELD
 |  | GRACE | EA | GRACE ICE & WATER 2 SQ ROLL | 142.5 | 139.65 | 138.23 | 131.1 | 101.0264 | X | X | Boise |  | http://www.na.graceconstruction.com/underlayments/download/GIWS-060U-GIWS_1.pdf
 |  | ICE2 | EA | ICE GARD RIDGLASS 3X66'8" 2 SQ ROLL | 62.59 | 59.46 | 57.58 | 56.33 | 37.12 | X | X | Dewitt | Dewitts [NAME] 67 | https://www.dewittproducts.com/products/966-Roof-Shield-67/7/91
UNDERLAYMENT
 |  | 15F | EA | FELT 15# 432 SF | 19.75 | 19.36 | 18.76 | 18.17 | 14.98 | X | X | Emery | Warrior Roofing | http://www.warriorroofing.com/portfolio/warrior-roofing-15w-3/
 |  | 30F | EA | FELT 30# 200 SF | 19.75 | 19.36 | 18.76 | 18.17 | 15.091 | X | X | Emery | Warrior Roofing | http://www.warriorroofing.com/portfolio/warrior-roofing-30w-2/
 |  | SYNFELT | EA | SYNTHETIC UNDERLAYMENT 400 SQ/FT | 46.75 | 45.82 | 44.41 | 43.01 | 35.5 | X | X | Emery | [NAME] | http://www.grip-rite.com/us/en/products/roofing-products/synthetic-roofing-underlayment/synthetic-roofing-underlayment
 |  | 0799 | EA | GRACE TRI-FLEX 30 / 10 SQ ROLL | 166.83 | 162.55 | 158.48 | 150.95 | 126.79 |  |  | Huttig |  | http://www.na.graceconstruction.com/underlayments/download/UL-146E_TriFlex.pdf
DRIP EDGE
 |  | DEA5W | EA | WHITE ALUM DRIP EDGE 5"X10' | 4.92 | 4.65 | 4.43 | 4.26 | 3.402 | X | X | Amerimax
 |  | DEA8B | EA | BROWN 8"X10' DRIP EDGE ALUM | 8.15 | 7.71 | 7.34 | 7.06 | 5.061 | X | X | Amerimax
 |  | DEA8M | EA | MILL FINISH DRIP EDGE 8"X10' | 8.22 | 7.78 | 7.4 | 7.12 | 4.3643 | X | X | Amerimax
 |  | DEA8W | EA | WHITE 8"X10' DRIP EDGE ALUM | 8.22 | 7.78 | 7.4 | 7.12 | 5.061 | X | X | Amerimax
 |  | DEG | EA | GALVANIZED DRIP EDGE 8"X10' | 6.29 | 5.95 | 5.66 | 5.45 | 3.666 | X | X | Amerimax
 |  | COPPERDE | EA | 8"X10' COPPER DRIP EDGE | 73.25 | 69.59 | 67.39 | 65.93 | 35.0653 | X | X | Lamb & Ritchie
RIDGE VENT
 |  | HOGVENT | EA | RIDG20'X10.5" X 10.5" | 39.99 | 37.99 | 35.99 | 33.99 | 21.5558 |  | X | Amerimax | RoofSaver
FLASHING
 |  | ORG6194930 | EA |  |  |  |  |  |  |  | X