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

Black fabric | Item ID | RETAIL | Contractor Cost | [NAME]
4' X 50' ROLL BLK VINYL 2 X 9 | FC101-0129-0145 | 189.43
5' X 50' ROLL BLK VINYL 2 X 9 | FC101-0129-0255 | 251.62
6' X 50' ROLL BLK VINYL 2 X 9 | FC101-0129-0366 | 314.13
Black pipe | Item ID | RETAIL | Contractor Cost | [NAME]
1 3/8" X 21' SWG RAIL | FC102-0238-0121 | 39.77
1 5/8" X 6' POST 16Ga .065 | FC102-0558-0206 | 17.77
1 5/8" X 7' POST 16Ga .065 | FC102-0558-0307 | 21.3
1 5/8" X 8' POST 16Ga (.065) | FC102-0558-0408 | 24.7
2" X 6' POST 16Ga (.065) | FC102-0820-0206 | 19.64
2" X 7' POST 16Ga (.065) | FC102-0820-0307 | 24.24
2" X 8' POST 16Ga (.065) | FC102-0820-0408 | 27.42
2 1/2" X 9 SCQ 20 | FC102-0925-0409 | 62.19
Black gates | Item ID | RETAIL | Contractor Cost | [NAME]
GATE 4'h X 3' | FC101A | 157.82
GATE 4'h X 4' | FC101B | 180.37
GATE 4'h X 5' | FC101C | 202.91
GATE 5'h X 3' | FC101D | 182.14
GATE 5'h X 4' | FC101E | 202.91
GATE 5'h X 5' | FC101F | 225.45
GATE 6'h X 4' | [NAME] | 225.46
GATE 6'h X 5' | FC101H | 248
Gate hardware | Item ID | RETAIL | Contractor Cost | [NAME]
AUTO(PIVOT) LATCH 1 3/8  X 2 | FC104-01LA-03AL | 51.26
AUTO (PIVOT)LATCH 1 3/8 X1 3/8 | FC104-01LA-04AL | 65.03
GATE CLOSER (CLAW/STA-KLOS) | FC104-02HG-09GC | 48.3
GATE FRAME HINGE 1 3/8" FEMALE | FC104-02HG-09TF | 3.78
GATE POST HINGE 2" MALE | FC104-02HG-09UP | 4.11
GRAVITY HINGES 1 WAY SWING | FC104-02HG-09VG | 38.06
BOLT 3/8" X 2 GATE FRAME | FC104-02HG-12GF | 0.89
BOLT 3/8 "X 2 1/2" HINGE | FC104-02HG-13GP | 0.99
DROP ROD ONLY 36" | FC104-03DR-10DR | 27.16
DROP ROD EZ LATCH 42" LOCK | FC104-03DR-11DR | 43.26
1 3/8" COLLAR SET (2 PC) | FC104A-01LA-010A | 3.43
2" FORK ONLY (NO COLLAR) | FC104A-01LA-010B | 8.56
1 3/8" FORK ONLY (NO COLLAR) | FC104A-01LA-010C | 3.83
2 1/2" FORK ONLY (NO COLLAR) | FC104A-01LA-010E | 4.24
GATE POST HINGE 2 1/2" MALE | FC104A-02HG-010F | 5.98
Chain link hardwar | Item ID | RETAIL | Contractor Cost | [NAME]
TENSION BAR 4' ST 3/16" X 5/8" | FC105-01HB-01AB | 5.51
TENSION BAR 5' ST 3/16" X 5/8" | FC105-01HB-01BB | 6.51
BOLT 5/16 X 1 1/4 (100PCS) BK | FC105-01HB-02TC | 37
POST CAP 2" (DOME)BLACK | FC105-01HB-03PC | 1.72
POST CAP 1 5/8 X 1 3/8 LINE | FC105-01HB-04PC | 2.18
POST CAP 2" TO 1 3/8" LINE | FC105-01HB-05AE | 3.1
RAIL END 1 3/8" | FC105-01HB-05RE | 1.95
BRACE BAND 2" | FC105-01HB-06RE | 1.77
TENSION BAND 2" BLACK | FC105-01HB-07TB | 1.35
[NAME] 6 1/2" (BAGS OF 100) | FC105-01HB-08FT | 19.76
[NAME] 8 1/4" (BAGS OF 100) | FC105-01HB-09FT | 23.59
TENSION WIRE 9 GA.240' BLACK | FC105-01HB-10TW | 56.25
HOG RING ALUM BLACK | FC105-01HB-11SW | 17.55
EZ POST ANCHOR 1 5/8" GALV. | FC105-01HB-12EZ | 10.05
EZ POST ANCHOR 2" GALVANIZED | FC105-01HB-13EZ | 10.05
BOULEVARD CL SET 1 5/8 X 1 3/8 | FC106-01HB-01BC | 4.9
[NAME] 2 1/2" BLACK | FC106-01HB-01BE | 1.72
BRACE BAND 2 1/2" BLACK | FC106-01HB-01BF | 1.89
POST CAP 2 1/2" (DOME)BLACK | FC106-01HB-01BG | 4.24
CARRIAGE BOLT 3" BLACK | FC106-01HB-01BH | 0.91
SLEEVE CONNECTOR 1 3/8 | FC106-01HB-01SL | 3.28
2" X 1 5/8" LOOP CAP BLK | FC106-01HB-04LC | 10.5
1 5/8" FLOOR FLANGE | FC106-01HB-05F1 | 32.8
2" FLOOR FLANGE | FC106-01HB-05F2 | 32.1
TENSION BAR 6' ST 3/16" X 5/8" | FC106-01HB-05TB | 8.2