Spreadsheet: 886523d1736538026-auto-populate-cell-after-selecting-multiple-drop-down-lists-field-quote-
Sheet: ALUMINUM FENCE

Panels
Aluminum panels | Item ID | Retail | Contractor Cost | [NAME]
100A48 RES 3 RAIL 48 X 6 BLK | FA1FENCE-1100-0348 | 104.767008
200A54 RES 3 RAIL 54 X 6 BLK | FA1FENCE-1200-0154 | 112.215522
200A DBL PUNCH 3 RAIL 54 X 6 | FA1FENCE-120A-0154 | 112.22
300C54 RES 3 RAIL 54 X 6 BLK | FA1FENCE-2300-0154 | 112.215522
400A48 COM 2 RAIL 48 X 6 BLK | FA1FENCE-6400-0448 | 110.348703
Gates
100 series walk gates | Item ID | Retail | Contractor Cost | [NAME]
100A48 RES FLAT GATE 48 X 3 BL | FA1GATE-0110-0643 | 300.304572
100A48 RES FLAT GATE 48 X 4 BL | FA1GATE-0110-0744 | 329.92977
100A48 RES FLAT GATE 48 X 5 BL | FA1GATE-0110-0845 | 359.564349
100A48 RES [NAME] 48 X 3 BL | FA1GATE-0110-0943 | 427.135692
100A48 RES [NAME] 48 X 4 BL | FA1GATE-0110-0944 | 456.601413
100A48 RES [NAME] 48 X 5 BL | FA1GATE-0110-1045 | 486.067134
100 series DBL drive gates | Item ID | Retail | Contractor Cost | [NAME]
100A48 RES SWOOP 48 X 8 BLK | FA1GATE-0110-1158 | 999.010833
100A48 RES SWOOP 48 X 12 BLK | FA1GATE-0110-1251 | 1090.91649
100A48 RES CONTEMP 48 X 12 BLK | FA1GATE-0110-1312 | 1090.91649
100A48 RES CONTEMP 48 X 8 BLK | FA1GATE-0110-1358 | 999.010833
200 series walk gates | Item ID | Retail | Contractor Cost | [NAME]
200A54 RES FLAT GATE 54 X 3 BL | FA1GATE-0120-0153 | 309.300951
200A54 RES FLAT GATE 54 X 4 BL | FA1GATE-0120-0254 | 340.71792
200A54 RES FLAT GATE 54 X 5 BL | FA1GATE-0120-0355 | 372.172413
200A53 RES [NAME] 54 X 3 BL | FA1GATE-0120-0356 | 436.366596
200A54 RES [NAME] 54 X 4 BL | FA1GATE-0120-0454 | 467.614707
200A54 RES [NAME] 54 X 5 BL | FA1GATE-0120-0555 | 498.909723
200 series DBL drive gates | Item ID | Retail | Contractor Cost | [NAME]
200A54 RES SWOOP 54 X 8 BLK | FA1GATE-0120-1158 | 1025.821731
200A54 RES SWOOP 54 X 12 BLK | FA1GATE-0120-1251 | 1122.305316
200A54 RES CONTEMP 54 X 12 BLK | FA1GATE-0120-1312 | 1122.305316
200A54 RES CONTEMP 54" X 8 BLK | FA1GATE-0120-1358 | 1025.821731
300 series walk gates | Item ID | Retail | Contractor Cost | [NAME]
300C54 RES FLAT GATE 54 X 3 BL | FA1GATE-0230-0153 | 309.300951
300C54 RES FLAT GATE 54 X 4 BL | FA1GATE-0230-0254 | 340.71792
300C54 RES FLAT GATE 54 X 5 BL | FA1GATE-0230-0355 | 372.172413
300C53 RES [NAME] 54 X 3 BL | FA1GATE-0230-0356 | 436.366596
300C54 RES [NAME] 54 X 4 BL | FA1GATE-0230-0454 | 467.614707
300C54 RES [NAME] 54 X 5 BL | FA1GATE-0230-0555 | 498.909723
300 series DBL drive gates | Item ID | Retail | Contractor Cost | [NAME]
300C54 RES SWOOP 54 X 8 BLK | FA1GATE-0230-1158 | 1025.821731
300C54 RES SWOOP 54 X 12 BLK | FA1GATE-0230-1251 | 1122.305316
300C54 RES CONTEMP 54 X 12 BLK | FA1GATE-0230-1312 | 1122.305316
300C54 RES CONTEMP 54 X 8 BLK | FA1GATE-0230-1358 | 1025.821731
400 series comm. walk gates | Item ID | Retail | Contractor Cost | [NAME]
400A48 COM FLAT GATE 48 X 3 BL | FA1GATE-0640-0643 | 380.859219
400A48 COM FLAT GATE 48 X 4 BL | FA1GATE-0640-0744 | 408.692646
400A48 COM FLAT GATE 48 X 5 BL | FA1GATE-0640-0845 | 429.152607
400A48 COM ARCH GATE 48 X3  BL | FA1GATE-0640-0943 | 506.133093
400A48 COM ARCH GATE 48 X 4 BL | FA1GATE-0640-0944 | 534.782667
400A48 COM ARCH GATE 48 X 5 BL | FA1GATE-0640-1045 | 555.889917
Posts
100 series post | Item ID | Retail | Contractor Cost | [NAME]
2 X 6' 100 RES LINE POST BLK | FA1POST-011P-HLPO | 36.107469
2 X 6' 100 RES CORNER PO BLK | FA1POST-011P-ICPO | 36.107469
2 X 6' 100 RES END POST BLK | FA1POST-011P-JEPO | 36.107469
2 X 6' 100 RES GATE END PO BLK | FA1POST-011P-KGEP | 61.079691
200/300 series post | Item ID | Retail | Contractor Cost | [NAME]
2 X 7 200/300 RES LINE BLK | FA1POST-01RP-ALPO | 38.762292
2 X 7 200/300 RES CORNER BLK | FA1POST-01RP-BCPO | 38.762292
2 X 7 200/300 RES END BLK | FA1POST-01RP-CEPO | 38.762292
2 X 7 200/300 RES GATE END BLK | FA1POST-01RP-DGEP | 68.256156
400 series post | Item ID | Retail | Contractor Cost | [NAME]
2 X 6 400 COM LINE BLK | FA1POST-04CP-HLPO | 36.107469
2 X 6 400 COM CORNER BLK | FA1POST-04CP-ICPO | 36.107469
2 X 6 400 COM END BLK | FA1POST-04CP-JEPO | 36.107469
2 X 6 400 COM GATE END BLK | FA1POST-04CP-KGEP | 61.079691
Blank & flanged post | Item ID | Retail | Contractor Cost | [NAME]
2 X 7 X .125" GATE BLANK BLK | FA1POST-05BP-EGBP | 68.256156
2 X 7 X .062" BLANK POST BLK | FA1POST-05BP-MBQO | 41.501544
2 X 8 X .062" BLANK POST BLK | FA1POST-05BP-NBGP | 47.120763
2 X 8 X .125" GATE BLANK BLK | FA1POST-05BP-OBGP | 87.749874
2 X 58"POST WITH WELDED FLANGE | FA1POST-05BP-SWBF | 85.151337
2.5 X 8 .125 BLANK BLK | FA1POSTXL-03PO-0110 | 101.36
4 X 8 .125 BLANK BLK | FA1POSTXL-03PO-0148 | 166.73
Hardware
Gate hardware | Item ID | Retail | Contractor Cost | [NAME]
[NAME] SET BLK | HHINGE-2ALM-08AH | 74.99
9" SAFETECH MAGNETIC POOL | HLATCH-2ALM-0109 | 82.53
10" AQUA LATCH BLK | HLATCH-2ALM-01A9 | 93.62
19" SAFETECH MAGNETIC POOL | HLATCH-2ALM-0219 | 84.17
20" AQUA LATCH BLK | HLATCH-2ALM-02A9 | 112.66
[NAME] SIDE LOCK | HLATCH-2ALM-05ML | 50.67
Accessories
Aluminum accessories | Item ID | Retail | Contractor Cost | [NAME]
RES WALL FLUSH MOUNT BLK | HMALUM-1ALM-01RW | 5.544
RES BALL SWIVEL BRACKET BLK | HMALUM-1ALM-03RB | 11.0985
COMM WALL FLUSH MOUNT BLK | HMALUM-1ALM-04CW | 5.544
COMM BALL SWIVEL MOUNT BLK | [NAME] | 11.0985
2" BALL CAP BLK | HMALUM-1ALM-08PB | 11.0985
2 1/2" STD POST CAP BLK | [NAME] | 6.84411
2 1/2" BALL POST CAP BLK | HMALUM-1ALM-10PB | 13.314
SCREW (1) INCLUDED HEX 1" BLK | HMALUM-1ALM-11AS | 0 | 0 | 0
TOUCH UP SPRAY PAINT BLK | HMALUM-1ALM-12SP | 14.427
TOUCH UP PEN BLK | HMALUM-1ALM-13PP | 8.8725
2" POST TRIM (2 PIECE) BLK | HMALUM-1ALM-14PT | 14.427
 |  |  | White Contractor Cost | White Contractor Retail
 |  |  | White Contractor Cost | White Contractor Retail
 |  |  | White Contractor Cost | White Contractor Retail
 |  |  | White Contractor Cost | White Contractor Retail
 |  |  | White Contractor Cost | White Contractor Retail