Spreadsheet: 133492d1324420578-excel-2007-n-a-error-for-if-statement-with-vlookup-formula-test2-tristar-price-sheet
Sheet: GLASS PRICING

PRICECALCULATER |  |  |  |  |  |  |  |  |  | GLASSPRICES |  |  |  |  |  | FABPRICES
1.PROFIT |  | Mark up: |  | 3 | Margin: |  |  |  |  | Annealed:  1 sqft minimum Tempered:  3 sqft minimum Price includes special order fee Standard Tint= grey, bronze, green  [NAME] | Anneal | Temp | Anneal IG | Temp IG |  |  |  | Thickness 1/8" to 1/4" | Thickness 3/8" | Thickness 1/2"
 |  | W | x | H | SqFt |  | SqFt Price | Ext. Price |  | 3/32" Clear |  |  |  |  |  | Holes
 |  | (Round to next even number) |  | (Round to next even number) |  |  | (Input from chart at right) |  |  | 1/8" Clear |  |  |  |  |  | 1/4", 3/8", 7/16", 1/2"
2.BASE |  |  |  |  |  |  |  |  |  | 1/8" Standard Tint |  |  |  |  |  | 9/16", 5/8", 3/4", 7/8", 13/16", 1"
 |  | 10 | x | 20 |  |  | 50 |  |  | 1/8" Greylite #31
 |  |  |  |  |  |  |  |  |  | 1/8" Sungate 500 |  |  |  |  |  | 1 1/4", 1 1/2", 2", 1 3/4"
 |  |  |  |  |  |  |  |  |  | 1/8" Standard Tint/Sungate 500 |  |  |  |  |  | 2 1/4", 2 1/2"
3.MUNTIN |  |  |  |  |  |  |  |  |  | 1/8" Solar Ban 60 |  | Quote | Quote | Quote |  | 3", 4"
 |  |  |  |  |  |  | 0 |  |  | 5/32" Clear
 |  |  |  |  |  |  |  |  |  | 5/32" P 516 (Pat 62) |  |  |  |  |  | Flat Polishing
 |  |  |  |  |  |  |  |  |  | 5/32" Niagra (Rain) |  |  |  |  |  | Minimum
 |  |  |  |  |  |  |  |  |  | 5/32" Spraylite (S/R)
4.FAB |  | Holes | 0 | Mail Slots | 0 |  |  |  |  | 5/32" Reeded |  |  |  | Quote |  | Mitres
 |  | Notches | 0 | Single Rec | 0 |  |  |  |  | 3/16" Clear |  |  |  |  |  | 22 1/2°
 |  | Mitres | 0 | Double Rec | 0 |  |  |  |  | 3/16" Standard Tint |  |  |  |  |  | 45°
 |  | Flat Polish | 0.15 |  |  |  | TOTAL |  |  | 3/16" Sungate 500 |  |  |  |  |  | Custom ($25.00 Set up)
 |  |  |  |  |  |  |  |  |  | 3/16" Standard Tint/Sungate 500
 |  |  |  |  |  |  |  |  |  | 3/16" Solar Ban 60 |  |  | Quote | Quote |  | Notches
 |  |  |  |  |  |  |  |  |  | 3/16" P 516 (Pat 62)
 |  |  |  |  |  |  |  |  |  | 3/16" Niagra (Rain) |  |  |  |  |  | Mail Slots
 |  |  |  |  |  |  |  |  |  | 3/16" Spraylite (S/R)
 |  |  |  |  |  |  |  |  |  | 3/16" Glue Chip |  |  |  |  |  | Single Recepts |  |  | N/A | N/A
 |  |  |  |  |  |  |  |  |  | 1/4" Clear
 |  |  |  |  |  |  |  |  |  | 1/4" Standard Tint |  |  |  |  |  | Double Recepts |  |  | N/A | N/A
 |  |  |  |  |  |  |  |  |  | 1/4" Blue |  |  | Quote | Quote
 |  |  |  |  |  |  |  |  |  | 1/4" Greylite #14
 |  |  |  |  |  |  |  |  |  | 1/4" Sungate 500
 |  |  |  |  |  |  |  |  |  | 1/4" Standard Tint/Sungate 500
 |  |  |  |  |  |  |  |  |  | 1/4" Solar Ban 60, SN 68 |  |  | Quote | Quote
 |  |  |  |  |  |  |  |  |  | 1/4" Standard Reflective Tint |  |  | Quote | Quote
 |  |  |  |  |  |  |  |  |  | 1/4" Reeded |  |  | Quote | Quote
 |  |  |  |  |  |  |  |  |  | 1/4" Mirrorpane |  |  | Quote | Quote
 |  |  |  |  |  |  |  |  |  | 1/4" Diamond Wire |  |  | Quote | Quote
 |  |  |  |  |  |  |  |  |  | 1/4" Clear Laminated |  |  | Quote | Quote
 |  |  |  |  |  |  |  |  |  | 3/8" Clear |  |  | Quote | Quote
 |  |  |  |  |  |  |  |  |  | 3/8" Rain | Quote |  | Quote | Quote
 |  |  |  |  |  |  |  |  |  | 3/8" Shower Guard
 |  |  |  |  |  |  |  |  |  | 3/8" [NAME]
 |  |  |  |  |  |  |  |  |  | 1/2" Clear |  |  | Quote | Quote
 |  |  |  |  |  |  |  |  |  | 1/2" Satin
 |  |  |  |  |  |  |  |  |  | Prices updated as of July 12, 2011