{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Bid Worksheet","UNIT CODES","RENTALS"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Bid Worksheet","index":0,"n_rows":310,"n_cols":11,"rows_kept":310}
[null,"BID #  06-19-010 ","SQ FT",null,null,"SQ FT cost",{"$f":"(H305/D1)","v":{"$error":"#DIV/0!"}}]
[null,"Bid Worksheet: Main St Bld D"]
[]
[null,"Description","Quantity","Trade Price","Unit","Labor","Unit","Total Material","Total Hours","Vendor"]
[1,"U1",67,{"v":0,"d":"$0.00"},"E",0.65,"E",{"$f":"VLOOKUP(E5,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D5)*(C5)","v":{"v":0,"d":"$0.00"}},{"$f":"VLOOKUP(G5,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F5)*(C5)","v":{"v":43.550000000000004,"d":"43.55"}}]
[2,"U2",52,{"v":0,"d":"$0.00"},"E",0.65,"E",{"$f":"VLOOKUP(E6,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D6)*(C6)","v":{"v":0,"d":"$0.00"}},{"$f":"VLOOKUP(G6,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F6)*(C6)","v":{"v":33.800000000000004,"d":"33.80"}}]
[3,"U3",21,{"v":0,"d":"$0.00"},"E",0.65,"E",{"$f":"VLOOKUP(E7,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D7)*(C7)","v":{"v":0,"d":"$0.00"}},{"$f":"VLOOKUP(G7,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F7)*(C7)","v":13.65}]
[4,"U4",102,{"v":0,"d":"$0.00"},"C",22,"C",{"$f":"VLOOKUP(E8,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D8)*(C8)","v":{"v":0,"d":"$0.00"}},{"$f":"VLOOKUP(G8,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F8)*(C8)","v":22.44}]
[5,"U5",79,{"v":0,"d":"$0.00"},"E",0.75,"E",{"$f":"VLOOKUP(E9,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D9)*(C9)","v":{"v":0,"d":"$0.00"}},{"$f":"VLOOKUP(G9,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F9)*(C9)","v":59.25}]
[6,"U6",63,{"v":0,"d":"$0.00"},"E",0.65,"E",{"$f":"VLOOKUP(E10,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D10)*(C10)","v":{"v":0,"d":"$0.00"}},{"$f":"VLOOKUP(G10,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F10)*(C10)","v":40.95}]
[7,"U7",86,{"v":0,"d":"$0.00"},"E",0.65,"E",{"$f":"VLOOKUP(E11,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D11)*(C11)","v":{"v":0,"d":"$0.00"}},{"$f":"VLOOKUP(G11,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F11)*(C11)","v":{"v":55.9,"d":"55.90"}}]
[8,"U8",78,{"v":0,"d":"$0.00"},"E",0.65,"E",{"$f":"VLOOKUP(E12,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D12)*(C12)","v":{"v":0,"d":"$0.00"}},{"$f":"VLOOKUP(G12,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F12)*(C12)","v":{"v":50.7,"d":"50.70"}}]
[9,"U9",45,{"v":0,"d":"$0.00"},"E",0.65,"E",{"$f":"VLOOKUP(E13,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D13)*(C13)","v":{"v":0,"d":"$0.00"}},{"$f":"VLOOKUP(G13,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F13)*(C13)","v":29.25}]
[10,"U11",4,{"v":0,"d":"$0.00"},"E",0.65,"E",{"$f":"VLOOKUP(E14,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D14)*(C14)","v":{"v":0,"d":"$0.00"}},{"$f":"VLOOKUP(G14,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F14)*(C14)","v":{"v":2.6,"d":"2.60"}}]
[11,"A1",95,{"v":0,"d":"$0.00"},"E",0.65,"E",{"$f":"VLOOKUP(E15,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D15)*(C15)","v":{"v":0,"d":"$0.00"}},{"$f":"VLOOKUP(G15,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F15)*(C15)","v":61.75}]
[12,"B1",44,{"v":0,"d":"$0.00"},"E",0.75,"E",{"$f":"VLOOKUP(E16,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D16)*(C16)","v":{"v":0,"d":"$0.00"}},{"$f":"VLOOKUP(G16,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F16)*(C16)","v":{"v":33,"d":"33.00"}}]
[13,"C1",16,{"v":0,"d":"$0.00"},"E",0.75,"E",{"$f":"VLOOKUP(E17,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D17)*(C17)","v":{"v":0,"d":"$0.00"}},{"$f":"VLOOKUP(G17,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F17)*(C17)","v":{"v":12,"d":"12.00"}}]
[14,"D1",46,{"v":0,"d":"$0.00"},"E",0.45,"E",{"$f":"VLOOKUP(E18,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D18)*(C18)","v":{"v":0,"d":"$0.00"}},{"$f":"VLOOKUP(G18,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F18)*(C18)","v":{"v":20.7,"d":"20.70"}}]
[15,"X1",23,{"v":90,"d":"$90.00"},"E",0.35,"E",{"$f":"VLOOKUP(E19,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D19)*(C19)","v":{"v":2070,"d":"$2,070.00"}},{"$f":"VLOOKUP(G19,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F19)*(C19)","v":{"v":8.049999999999999,"d":"8.05"}}]
[16,"Panel A",27,{"v":0,"d":"$0.00"},"E",3,"E",{"$f":"VLOOKUP(E20,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D20)*(C20)","v":{"v":0,"d":"$0.00"}},{"$f":"VLOOKUP(G20,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F20)*(C20)","v":{"v":81,"d":"81.00"}}]
[17,"Panel B",16,{"v":0,"d":"$0.00"},"E",3,"E",{"$f":"VLOOKUP(E21,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D21)*(C21)","v":{"v":0,"d":"$0.00"}},{"$f":"VLOOKUP(G21,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F21)*(C21)","v":{"v":48,"d":"48.00"}}]
[18,"Panel D",2,{"v":0,"d":"$0.00"},"E",3,"E",{"$f":"VLOOKUP(E22,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D22)*(C22)","v":{"v":0,"d":"$0.00"}},{"$f":"VLOOKUP(G22,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F22)*(C22)","v":{"v":6,"d":"6.00"}}]
[19,"Panel HP1D",1,{"v":0,"d":"$0.00"},"E",5.5,"E",{"$f":"VLOOKUP(E23,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D23)*(C23)","v":{"v":0,"d":"$0.00"}},{"$f":"VLOOKUP(G23,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F23)*(C23)","v":{"v":5.5,"d":"5.50"}}]
[20,"600A MLO",1,{"v":0,"d":"$0.00"},"E",7,"E",{"$f":"VLOOKUP(E24,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D24)*(C24)","v":{"v":0,"d":"$0.00"}},{"$f":"VLOOKUP(G24,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F24)*(C24)","v":{"v":7,"d":"7.00"}}]
[21,"MSB",1,{"v":0,"d":"$0.00"},"E",48,"E",{"$f":"VLOOKUP(E25,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D25)*(C25)","v":{"v":0,"d":"$0.00"}},{"$f":"VLOOKUP(G25,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F25)*(C25)","v":{"v":48,"d":"48.00"}}]
[22,"  1/2\" CONDUIT - EMT",{"v":3175,"d":"3,175"},{"v":40.56,"d":"$40.56"},"C",2.78,"C",{"$f":"VLOOKUP(E26,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D26)*(C26)","v":{"v":1287.78,"d":"$1,287.78"}},{"$f":"VLOOKUP(G26,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F26)*(C26)","v":{"v":88.265,"d":"88.27"}}]
[23,"  3/4\" CONDUIT - EMT",{"v":1680,"d":"1,680"},{"v":71.87,"d":"$71.87"},"C",3.2,"C",{"$f":"VLOOKUP(E27,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D27)*(C27)","v":{"v":1207.416,"d":"$1,207.42"}},{"$f":"VLOOKUP(G27,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F27)*(C27)","v":53.76}]
[24,"1\"     CONDUIT - EMT",15,{"v":123.6,"d":"$123.60"},"C",4.05,"C",{"$f":"VLOOKUP(E28,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D28)*(C28)","v":{"v":18.54,"d":"$18.54"}},{"$f":"VLOOKUP(G28,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F28)*(C28)","v":{"v":0.6075,"d":"0.61"}}]
[25,"1 1/4\" CONDUIT - EMT",40,{"v":200.62,"d":"$200.62"},"C",4.7,"C",{"$f":"VLOOKUP(E29,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D29)*(C29)","v":{"v":80.248,"d":"$80.25"}},{"$f":"VLOOKUP(G29,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F29)*(C29)","v":1.88}]
[26,"1 1/2\" CONDUIT - EMT",100,{"v":245.95,"d":"$245.95"},"C",5.92,"C",{"$f":"VLOOKUP(E30,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D30)*(C30)","v":{"v":245.95,"d":"$245.95"}},{"$f":"VLOOKUP(G30,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F30)*(C30)","v":5.92}]
[27,"2\"     CONDUIT - EMT",{"v":1540,"d":"1,540"},{"v":287.75,"d":"$287.75"},"C",6.8,"C",{"$f":"VLOOKUP(E31,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D31)*(C31)","v":{"v":4431.35,"d":"$4,431.35"}},{"$f":"VLOOKUP(G31,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F31)*(C31)","v":{"v":104.72000000000001,"d":"104.72"}}]
[28,"3 1/2\" CONDUIT - EMT",60,{"v":732.34,"d":"$732.34"},"C",11.4,"C",{"$f":"VLOOKUP(E32,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D32)*(C32)","v":{"v":439.404,"d":"$439.40"}},{"$f":"VLOOKUP(G32,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F32)*(C32)","v":6.84}]
[29,"1 1/4\" ELBOW 90 DEG - EMT",2,{"v":361.17,"d":"$361.17"},"C",30,"C",{"$f":"VLOOKUP(E33,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D33)*(C33)","v":{"v":7.223400000000001,"d":"$7.22"}},{"$f":"VLOOKUP(G33,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F33)*(C33)","v":{"v":0.6,"d":"0.60"}}]
[30,"1 1/2\" ELBOW 90 DEG - EMT",2,{"v":437.27,"d":"$437.27"},"C",40,"C",{"$f":"VLOOKUP(E34,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D34)*(C34)","v":{"v":8.7454,"d":"$8.75"}},{"$f":"VLOOKUP(G34,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F34)*(C34)","v":{"v":0.8,"d":"0.80"}}]
[31,"2\"     ELBOW 90 DEG - EMT",30,{"v":648.1,"d":"$648.10"},"C",45,"C",{"$f":"VLOOKUP(E35,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D35)*(C35)","v":{"v":194.43000000000004,"d":"$194.43"}},{"$f":"VLOOKUP(G35,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F35)*(C35)","v":{"v":13.5,"d":"13.50"}}]
[32,"3 1/2\" X 24\" RAD ELBOW 90 DEG - EMT",10,{"v":90,"d":"$90.00"},"E",70,"C",{"$f":"VLOOKUP(E36,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D36)*(C36)","v":{"v":900,"d":"$900.00"}},{"$f":"VLOOKUP(G36,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F36)*(C36)","v":{"v":7.000000000000001,"d":"7.00"}}]
[33,"  1/2\" CONN SS STL - EMT",395,{"v":18.83,"d":"$18.83"},"C",8,"C",{"$f":"VLOOKUP(E37,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D37)*(C37)","v":{"v":74.3785,"d":"$74.38"}},{"$f":"VLOOKUP(G37,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F37)*(C37)","v":{"v":31.6,"d":"31.60"}}]
[34,"  3/4\" CONN SS STL - EMT",214,{"v":31.06,"d":"$31.06"},"C",10,"C",{"$f":"VLOOKUP(E38,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D38)*(C38)","v":{"v":66.4684,"d":"$66.47"}},{"$f":"VLOOKUP(G38,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F38)*(C38)","v":{"v":21.400000000000002,"d":"21.40"}}]
[35,"1 1/4\" CONN SS STL - EMT",2,{"v":137.23,"d":"$137.23"},"C",14,"C",{"$f":"VLOOKUP(E39,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D39)*(C39)","v":{"v":2.7445999999999997,"d":"$2.74"}},{"$f":"VLOOKUP(G39,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F39)*(C39)","v":0.28}]
[36,"1 1/2\" CONN SS STL - EMT",6,{"v":197.96,"d":"$197.96"},"C",17,"C",{"$f":"VLOOKUP(E40,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D40)*(C40)","v":{"v":11.877600000000001,"d":"$11.88"}},{"$f":"VLOOKUP(G40,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F40)*(C40)","v":1.02}]
[37,"2\"     CONN SS STL - EMT",60,{"v":283.79,"d":"$283.79"},"C",20,"C",{"$f":"VLOOKUP(E41,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D41)*(C41)","v":{"v":170.27400000000003,"d":"$170.27"}},{"$f":"VLOOKUP(G41,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F41)*(C41)","v":{"v":12,"d":"12.00"}}]
[38,"  1/2\" COUPLING SS STL - EMT",310,{"v":20.16,"d":"$20.16"},"C",3.2,"C",{"$f":"VLOOKUP(E42,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D42)*(C42)","v":{"v":62.496,"d":"$62.50"}},{"$f":"VLOOKUP(G42,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F42)*(C42)","v":9.92}]
[39,"  3/4\" COUPLING SS STL - EMT",167,{"v":31.16,"d":"$31.16"},"C",4,"C",{"$f":"VLOOKUP(E43,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D43)*(C43)","v":{"v":52.0372,"d":"$52.04"}},{"$f":"VLOOKUP(G43,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F43)*(C43)","v":6.68}]
[40,"1 1/4\" COUPLING SS STL - EMT",8,{"v":160.85,"d":"$160.85"},"C",6.5,"C",{"$f":"VLOOKUP(E44,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D44)*(C44)","v":{"v":12.868,"d":"$12.87"}},{"$f":"VLOOKUP(G44,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F44)*(C44)","v":0.52}]
[41,"1 1/2\" COUPLING SS STL - EMT",14,{"v":233.44,"d":"$233.44"},"C",8,"C",{"$f":"VLOOKUP(E45,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D45)*(C45)","v":{"v":32.6816,"d":"$32.68"}},{"$f":"VLOOKUP(G45,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F45)*(C45)","v":1.12}]
[42,"2\"     COUPLING SS STL - EMT",214,{"v":312.97,"d":"$312.97"},"C",9.5,"C",{"$f":"VLOOKUP(E46,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D46)*(C46)","v":{"v":669.7558,"d":"$669.76"}},{"$f":"VLOOKUP(G46,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F46)*(C46)","v":{"v":20.330000000000002,"d":"20.33"}}]
[43,"1\"     CONN COMP STL - EMT",3,{"v":105.81,"d":"$105.81"},"C",15.6,"C",{"$f":"VLOOKUP(E47,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D47)*(C47)","v":{"v":3.1743,"d":"$3.17"}},{"$f":"VLOOKUP(G47,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F47)*(C47)","v":{"v":0.46799999999999997,"d":"0.47"}}]
[44,"3 1/2\" CONN COMP STL - EMT",10,{"v":23.01,"d":"$23.01"},"E",41.6,"C",{"$f":"VLOOKUP(E48,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D48)*(C48)","v":{"v":230.10000000000002,"d":"$230.10"}},{"$f":"VLOOKUP(G48,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F48)*(C48)","v":4.16}]
[45,"3 1/2\" COUPLING COMP STL - EMT",20,{"v":1441.37,"d":"$1,441.37"},"C",36,"C",{"$f":"VLOOKUP(E49,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D49)*(C49)","v":{"v":288.274,"d":"$288.27"}},{"$f":"VLOOKUP(G49,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F49)*(C49)","v":{"v":7.199999999999999,"d":"7.20"}}]
[46,"1 1/2\" TYPE LB STD CONDUIT BODY - EMT - ALUM",2,{"v":2192.35,"d":"$2,192.35"},"C",1,"E",{"$f":"VLOOKUP(E50,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D50)*(C50)","v":{"v":43.847,"d":"$43.85"}},{"$f":"VLOOKUP(G50,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F50)*(C50)","v":{"v":2,"d":"2.00"}}]
[47,"2\"     TYPE LB STD CONDUIT BODY - EMT - ALUM",1,{"v":2527.83,"d":"$2,527.83"},"C",1.3,"E",{"$f":"VLOOKUP(E51,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D51)*(C51)","v":{"v":25.2783,"d":"$25.28"}},{"$f":"VLOOKUP(G51,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F51)*(C51)","v":{"v":1.3,"d":"1.30"}}]
[48,"  3/4\" CONDUIT - RMC - GALV",300,{"v":193.42,"d":"$193.42"},"C",5,"C",{"$f":"VLOOKUP(E52,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D52)*(C52)","v":{"v":580.26,"d":"$580.26"}},{"$f":"VLOOKUP(G52,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F52)*(C52)","v":{"v":15,"d":"15.00"}}]
[49,"1\"     CONDUIT - RMC - GALV",18,{"v":308.22,"d":"$308.22"},"C",6.2,"C",{"$f":"VLOOKUP(E53,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D53)*(C53)","v":{"v":55.479600000000005,"d":"$55.48"}},{"$f":"VLOOKUP(G53,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F53)*(C53)","v":{"v":1.116,"d":"1.12"}}]
[50,"1 1/4\" CONDUIT - RMC - GALV",5,{"v":452.87,"d":"$452.87"},"C",7.3,"C",{"$f":"VLOOKUP(E54,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D54)*(C54)","v":{"v":22.6435,"d":"$22.64"}},{"$f":"VLOOKUP(G54,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F54)*(C54)","v":{"v":0.365,"d":"0.37"}}]
[51,"4\"     CONDUIT - RMC - GALV",45,{"v":1852.27,"d":"$1,852.27"},"C",24.5,"C",{"$f":"VLOOKUP(E55,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D55)*(C55)","v":{"v":833.5215000000001,"d":"$833.52"}},{"$f":"VLOOKUP(G55,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F55)*(C55)","v":{"v":11.025,"d":"11.03"}}]
[52,"1\"     COUPLING - RMC - GALV",12,{"v":192.78,"d":"$192.78"},"C",0,"C",{"$f":"VLOOKUP(E56,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D56)*(C56)","v":{"v":23.1336,"d":"$23.13"}},{"$f":"VLOOKUP(G56,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F56)*(C56)","v":{"v":0,"d":"0.00"}}]
[53,"4\"     COUPLING - RMC - GALV",54,{"v":2202.03,"d":"$2,202.03"},"C",0,"C",{"$f":"VLOOKUP(E57,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D57)*(C57)","v":{"v":1189.0962000000002,"d":"$1,189.10"}},{"$f":"VLOOKUP(G57,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F57)*(C57)","v":{"v":0,"d":"0.00"}}]
[54,"1\"     ELBOW 90 DEG - RMC - GALV",6,{"v":824.82,"d":"$824.82"},"C",32,"C",{"$f":"VLOOKUP(E58,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D58)*(C58)","v":{"v":49.489200000000004,"d":"$49.49"}},{"$f":"VLOOKUP(G58,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F58)*(C58)","v":1.92}]
[55,"4    x 36\" RAD ELBOW 90 DEG - RMC - GALV",18,{"v":199,"d":"$199.00"},"E",194,"C",{"$f":"VLOOKUP(E59,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D59)*(C59)","v":{"v":3582,"d":"$3,582.00"}},{"$f":"VLOOKUP(G59,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F59)*(C59)","v":34.92}]
[56,"  3/4x 6\"     NIPPLE - RMC - GALV",48,{"v":204.22,"d":"$204.22"},"C",19.5,"C",{"$f":"VLOOKUP(E60,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D60)*(C60)","v":{"v":98.02560000000001,"d":"$98.03"}},{"$f":"VLOOKUP(G60,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F60)*(C60)","v":9.36}]
[57,"  3/4x 12\"    NIPPLE - RMC - GALV",1,{"v":454.76,"d":"$454.76"},"C",19.5,"C",{"$f":"VLOOKUP(E61,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D61)*(C61)","v":{"v":4.5476,"d":"$4.55"}},{"$f":"VLOOKUP(G61,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F61)*(C61)","v":{"v":0.195,"d":"0.20"}}]
[58,"1 1/4x 6\"     NIPPLE - RMC - GALV",1,{"v":387.72,"d":"$387.72"},"C",26,"C",{"$f":"VLOOKUP(E62,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D62)*(C62)","v":{"v":3.8772,"d":"$3.88"}},{"$f":"VLOOKUP(G62,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F62)*(C62)","v":0.26}]
[59,"  3/4\" CONN THRD HUB INSUL W/ GRD LUG  MALL STG2",49,{"v":1846.61,"d":"$1,846.61"},"C",27.2,"C",{"$f":"VLOOKUP(E63,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D63)*(C63)","v":{"v":904.8389000000001,"d":"$904.84"}},{"$f":"VLOOKUP(G63,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F63)*(C63)","v":{"v":13.328000000000001,"d":"13.33"}}]
[60,"1 1/4\" CONN THRD HUB INSUL W/ GRD LUG -  MALL STG4",2,{"v":2815.65,"d":"$2,815.65"},"C",37.6,"C",{"$f":"VLOOKUP(E64,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D64)*(C64)","v":{"v":56.313,"d":"$56.31"}},{"$f":"VLOOKUP(G64,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F64)*(C64)","v":{"v":0.752,"d":"0.75"}}]
[61,"  3/4\" TYPE LB FORM 7 CONDUIT BODY W/ CVR & GSKT - RMC ",101,{"v":19.01,"d":"$19.01"},"E",0.33,"E",{"$f":"VLOOKUP(E65,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D65)*(C65)","v":{"v":1920.0100000000002,"d":"$1,920.01"}},{"$f":"VLOOKUP(G65,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F65)*(C65)","v":33.33}]
[62,"1 1/4\" TYPE LB FORM 7 CONDUIT BODY W/ CVR & GSKT - RMC",2,{"v":31.35,"d":"$31.35"},"E",0.82,"E",{"$f":"VLOOKUP(E66,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D66)*(C66)","v":{"v":62.7,"d":"$62.70"}},{"$f":"VLOOKUP(G66,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F66)*(C66)","v":1.64}]
[63,"  3/4\" TYPE T  FORM 7 CONDUIT BODY W/ CVR & GSKT - RMC ",3,{"v":19.02,"d":"$19.02"},"E",0.68,"E",{"$f":"VLOOKUP(E67,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D67)*(C67)","v":{"v":57.06,"d":"$57.06"}},{"$f":"VLOOKUP(G67,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F67)*(C67)","v":2.04}]
[64,"  3/4\" LOCKNUT - STEEL",4,{"v":21.6,"d":"$21.60"},"C",2.3,"C",{"$f":"VLOOKUP(E68,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D68)*(C68)","v":{"v":0.8640000000000001,"d":"$0.86"}},{"$f":"VLOOKUP(G68,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F68)*(C68)","v":{"v":0.092,"d":"0.09"}}]
[65,"2\"     BUSHING - PLASTIC",58,{"v":50.7,"d":"$50.70"},"C",5.8,"C",{"$f":"VLOOKUP(E69,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D69)*(C69)","v":{"v":29.406,"d":"$29.41"}},{"$f":"VLOOKUP(G69,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F69)*(C69)","v":{"v":3.364,"d":"3.36"}}]
[66,"3 1/2\" BUSHING - PLASTIC",10,{"v":147.25,"d":"$147.25"},"C",9.4,"C",{"$f":"VLOOKUP(E70,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D70)*(C70)","v":{"v":14.725,"d":"$14.73"}},{"$f":"VLOOKUP(G70,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F70)*(C70)","v":0.94}]
[67,"1\"     BUSHING GRDG INSUL 150 DEG - MALL",3,{"v":573,"d":"$573.00"},"C",3.6,"C",{"$f":"VLOOKUP(E71,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D71)*(C71)","v":{"v":17.19,"d":"$17.19"}},{"$f":"VLOOKUP(G71,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F71)*(C71)","v":{"v":0.10800000000000001,"d":"0.11"}}]
[68,"4\"     BUSHING GRDG INSUL 150 DEG - STEEL",18,{"v":2311.25,"d":"$2,311.25"},"C",15.2,"C",{"$f":"VLOOKUP(E72,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D72)*(C72)","v":{"v":416.02500000000003,"d":"$416.03"}},{"$f":"VLOOKUP(G72,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F72)*(C72)","v":{"v":2.7359999999999998,"d":"2.74"}}]
[69,"  1/2\" 1-H STRAP - RMC - STEEL",54,{"v":0.17,"d":"$0.17"},"E",4.9,"C",{"$f":"VLOOKUP(E73,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D73)*(C73)","v":{"v":9.180000000000001,"d":"$9.18"}},{"$f":"VLOOKUP(G73,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F73)*(C73)","v":{"v":2.646,"d":"2.65"}}]
[70,"  3/4\" 1-H STRAP - RMC - STEEL",336,{"v":0.26,"d":"$0.26"},"E",5.4,"C",{"$f":"VLOOKUP(E74,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D74)*(C74)","v":{"v":87.36,"d":"$87.36"}},{"$f":"VLOOKUP(G74,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F74)*(C74)","v":{"v":18.144000000000002,"d":"18.14"}}]
[71,"1 1/4\" 1-H STRAP - RMC - STEEL",7,{"v":0.84,"d":"$0.84"},"E",7,"C",{"$f":"VLOOKUP(E75,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D75)*(C75)","v":{"v":5.88,"d":"$5.88"}},{"$f":"VLOOKUP(G75,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F75)*(C75)","v":{"v":0.49000000000000005,"d":"0.49"}}]
[72,"  1/2\" 1-H STRAP - EMT - STEEL",598,{"v":12,"d":"$12.00"},"C",4.9,"C",{"$f":"VLOOKUP(E76,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D76)*(C76)","v":{"v":71.75999999999999,"d":"$71.76"}},{"$f":"VLOOKUP(G76,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F76)*(C76)","v":{"v":29.302,"d":"29.30"}}]
[73,"  3/4\" 1-H STRAP - EMT - STEEL",158,{"v":14.85,"d":"$14.85"},"C",5.4,"C",{"$f":"VLOOKUP(E77,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D77)*(C77)","v":{"v":23.462999999999997,"d":"$23.46"}},{"$f":"VLOOKUP(G77,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F77)*(C77)","v":{"v":8.532000000000002,"d":"8.53"}}]
[74,"1 1/4\" 1-H STRAP - EMT - STEEL",0,{"v":59.49,"d":"$59.49"},"C",0,"C",{"$f":"VLOOKUP(E78,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D78)*(C78)","v":{"v":0,"d":"$0.00"}},{"$f":"VLOOKUP(G78,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F78)*(C78)","v":{"v":0,"d":"0.00"}}]
[75,"1 1/2\" 1-H STRAP - EMT - STEEL",10,{"v":85.53,"d":"$85.53"},"C",7.8,"C",{"$f":"VLOOKUP(E79,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D79)*(C79)","v":{"v":8.553,"d":"$8.55"}},{"$f":"VLOOKUP(G79,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F79)*(C79)","v":0.78}]
[76,"2\"     1-H STRAP - EMT - STEEL",157,{"v":125.07,"d":"$125.07"},"C",9.2,"C",{"$f":"VLOOKUP(E80,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D80)*(C80)","v":{"v":196.35989999999998,"d":"$196.36"}},{"$f":"VLOOKUP(G80,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F80)*(C80)","v":{"v":14.443999999999999,"d":"14.44"}}]
[77,"  3/4\" 2-PC CONDUIT STRUT CLAMP",12,{"v":1.69,"d":"$1.69"},"E",5.1,"C",{"$f":"VLOOKUP(E81,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D81)*(C81)","v":{"v":20.28,"d":"$20.28"}},{"$f":"VLOOKUP(G81,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F81)*(C81)","v":{"v":0.612,"d":"0.61"}}]
[78,"1\"     2-PC CONDUIT STRUT CLAMP",6,{"v":1.78,"d":"$1.78"},"E",5.6,"C",{"$f":"VLOOKUP(E82,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D82)*(C82)","v":{"v":10.68,"d":"$10.68"}},{"$f":"VLOOKUP(G82,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F82)*(C82)","v":{"v":0.33599999999999997,"d":"0.34"}}]
[79,"  1/2\" SPRING STL CONDUIT CLAMP W/ BOLT",12,{"v":0.48,"d":"$0.48"},"E",5.5,"C",{"$f":"VLOOKUP(E83,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D83)*(C83)","v":{"v":5.76,"d":"$5.76"}},{"$f":"VLOOKUP(G83,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F83)*(C83)","v":0.66}]
[80,"  1/2\" CONDUIT SUPPORT FOR ROD OR FLNG",361,{"v":0.43,"d":"$0.43"},"E",4.6,"C",{"$f":"VLOOKUP(E84,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D84)*(C84)","v":{"v":155.23,"d":"$155.23"}},{"$f":"VLOOKUP(G84,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F84)*(C84)","v":{"v":16.605999999999998,"d":"16.61"}}]
[81,"1/2 OR 3/4\" SNAP CLOSE CLIP - SIDE MNT TO MTL STUD SUPPORT",124,{"v":1.44,"d":"$1.44"},"E",7.2,"C",{"$f":"VLOOKUP(E85,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D85)*(C85)","v":{"v":178.56,"d":"$178.56"}},{"$f":"VLOOKUP(G85,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F85)*(C85)","v":{"v":8.928,"d":"8.93"}}]
[82,"  1/2\" FLEX - STEEL",12,{"v":46.7,"d":"$46.70"},"C",3,"C",{"$f":"VLOOKUP(E86,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D86)*(C86)","v":{"v":5.604,"d":"$5.60"}},{"$f":"VLOOKUP(G86,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F86)*(C86)","v":0.36}]
[83,"  3/4\" FLEX - STEEL",159,{"v":63.53,"d":"$63.53"},"C",3.9,"C",{"$f":"VLOOKUP(E87,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D87)*(C87)","v":{"v":101.0127,"d":"$101.01"}},{"$f":"VLOOKUP(G87,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F87)*(C87)","v":{"v":6.201,"d":"6.20"}}]
[84,"  1/2\" CONN FLEX DC SQUEEZE STRAIGHT",8,{"v":47.45,"d":"$47.45"},"C",10,"C",{"$f":"VLOOKUP(E88,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D88)*(C88)","v":{"v":3.7960000000000003,"d":"$3.80"}},{"$f":"VLOOKUP(G88,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F88)*(C88)","v":{"v":0.8,"d":"0.80"}}]
[85,"  3/4\" CONN FLEX DC SQUEEZE STRAIGHT",69,{"v":80.41,"d":"$80.41"},"C",10,"C",{"$f":"VLOOKUP(E89,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D89)*(C89)","v":{"v":55.4829,"d":"$55.48"}},{"$f":"VLOOKUP(G89,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F89)*(C89)","v":{"v":6.9,"d":"6.90"}}]
[86,"1\"     FLEX NM RACEWAY - ENT - BLU",{"v":5500,"d":"5,500"},{"v":71,"d":"$71.00"},"C",2,"C",{"$f":"VLOOKUP(E90,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D90)*(C90)","v":{"v":3905,"d":"$3,905.00"}},{"$f":"VLOOKUP(G90,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F90)*(C90)","v":{"v":110,"d":"110.00"}}]
[87,"  1/2\" FLEX - LIQUIDTIGHT METALLIC - GRAY",12,{"v":54.59,"d":"$54.59"},"C",3.9,"C",{"$f":"VLOOKUP(E91,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D91)*(C91)","v":{"v":6.550800000000001,"d":"$6.55"}},{"$f":"VLOOKUP(G91,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F91)*(C91)","v":{"v":0.46799999999999997,"d":"0.47"}}]
[88,"  3/4\" FLEX - LIQUIDTIGHT METALLIC - GRAY",298,{"v":68.93,"d":"$68.93"},"C",4.95,"C",{"$f":"VLOOKUP(E92,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D92)*(C92)","v":{"v":205.41140000000004,"d":"$205.41"}},{"$f":"VLOOKUP(G92,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F92)*(C92)","v":{"v":14.751000000000001,"d":"14.75"}}]
[89,"1 1/4\" FLEX - LIQUIDTIGHT METALLIC - GRAY",6,{"v":145.75,"d":"$145.75"},"C",8.9,"C",{"$f":"VLOOKUP(E93,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D93)*(C93)","v":{"v":8.745000000000001,"d":"$8.75"}},{"$f":"VLOOKUP(G93,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F93)*(C93)","v":{"v":0.534,"d":"0.53"}}]
[90,"2\"     FLEX - LIQUIDTIGHT METALLIC - GRAY",4,{"v":274.32,"d":"$274.32"},"C",15.8,"C",{"$f":"VLOOKUP(E94,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D94)*(C94)","v":{"v":10.9728,"d":"$10.97"}},{"$f":"VLOOKUP(G94,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F94)*(C94)","v":{"v":0.632,"d":"0.63"}}]
[91,"  1/2\" CONN STRAIGHT - LIQUIDTIGHT DIECAST",8,{"v":214.4,"d":"$214.40"},"C",15,"C",{"$f":"VLOOKUP(E95,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D95)*(C95)","v":{"v":17.152,"d":"$17.15"}},{"$f":"VLOOKUP(G95,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F95)*(C95)","v":{"v":1.2,"d":"1.20"}}]
[92,"  3/4\" CONN STRAIGHT - LIQUIDTIGHT DIECAST",146,{"v":551.54,"d":"$551.54"},"C",17,"C",{"$f":"VLOOKUP(E96,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D96)*(C96)","v":{"v":805.2484,"d":"$805.25"}},{"$f":"VLOOKUP(G96,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F96)*(C96)","v":24.82}]
[93,"1 1/4\" CONN STRAIGHT - LIQUIDTIGHT DIECAST",3,{"v":969.19,"d":"$969.19"},"C",20,"C",{"$f":"VLOOKUP(E97,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D97)*(C97)","v":{"v":29.0757,"d":"$29.08"}},{"$f":"VLOOKUP(G97,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F97)*(C97)","v":{"v":0.6000000000000001,"d":"0.60"}}]
[94,"2\"     CONN STRAIGHT - LIQUIDTIGHT DIECAST",2,{"v":2265.86,"d":"$2,265.86"},"C",30,"C",{"$f":"VLOOKUP(E98,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D98)*(C98)","v":{"v":45.31720000000001,"d":"$45.32"}},{"$f":"VLOOKUP(G98,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F98)*(C98)","v":{"v":0.6,"d":"0.60"}}]
[95,"1 1/4\" CONN 90 DEG - LIQUIDTIGHT DIECAST",1,{"v":1729.52,"d":"$1,729.52"},"C",20,"C",{"$f":"VLOOKUP(E99,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D99)*(C99)","v":{"v":17.2952,"d":"$17.30"}},{"$f":"VLOOKUP(G99,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F99)*(C99)","v":{"v":0.2,"d":"0.20"}}]
[96,"  3/4\" CONN STRAIGHT INSUL - LIQUIDTIGHT DIECAST",52,{"v":317.52,"d":"$317.52"},"C",17,"C",{"$f":"VLOOKUP(E100,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D100)*(C100)","v":{"v":165.1104,"d":"$165.11"}},{"$f":"VLOOKUP(G100,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F100)*(C100)","v":8.84}]
[97,"1\"     CONDUIT - PVC40",60,{"v":34.64,"d":"$34.64"},"C",4.4,"C",{"$f":"VLOOKUP(E101,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D101)*(C101)","v":{"v":20.784,"d":"$20.78"}},{"$f":"VLOOKUP(G101,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F101)*(C101)","v":2.64}]
[98,"4\"     CONDUIT - PVC40",250,{"v":193.37,"d":"$193.37"},"C",14.5,"C",{"$f":"VLOOKUP(E102,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D102)*(C102)","v":{"v":483.42500000000007,"d":"$483.43"}},{"$f":"VLOOKUP(G102,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F102)*(C102)","v":36.25}]
[99,"1\"     ELBOW 90 DEG - PVC40",6,{"v":97.97,"d":"$97.97"},"C",22,"C",{"$f":"VLOOKUP(E103,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D103)*(C103)","v":{"v":5.8782,"d":"$5.88"}},{"$f":"VLOOKUP(G103,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F103)*(C103)","v":1.32}]
[100,"4    x 36\" RAD ELBOW 90 DEG - PVC80",8,{"v":118,"d":"$118.00"},"E",120,"C",{"$f":"VLOOKUP(E104,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D104)*(C104)","v":{"v":944,"d":"$944.00"}},{"$f":"VLOOKUP(G104,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F104)*(C104)","v":{"v":9.6,"d":"9.60"}}]
[101,"4\"     COUPLING - PVC",24,{"v":312.1,"d":"$312.10"},"C",0,"C",{"$f":"VLOOKUP(E105,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D105)*(C105)","v":{"v":74.90400000000001,"d":"$74.90"}},{"$f":"VLOOKUP(G105,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F105)*(C105)","v":{"v":0,"d":"0.00"}}]
[102,"1\"     ADAPTER FEM - PVC",9,{"v":51.15,"d":"$51.15"},"C",12,"C",{"$f":"VLOOKUP(E106,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D106)*(C106)","v":{"v":4.6034999999999995,"d":"$4.60"}},{"$f":"VLOOKUP(G106,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F106)*(C106)","v":1.08}]
[103,"4\"     ADAPTER FEM - PVC",18,{"v":368.03,"d":"$368.03"},"C",40,"C",{"$f":"VLOOKUP(E107,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D107)*(C107)","v":{"v":66.2454,"d":"$66.25"}},{"$f":"VLOOKUP(G107,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F107)*(C107)","v":{"v":7.2,"d":"7.20"}}]
[104,"1\"     END CAP - PVC",3,{"v":0.73,"d":"$0.73"},"E",4,"C",{"$f":"VLOOKUP(E108,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D108)*(C108)","v":{"v":2.19,"d":"$2.19"}},{"$f":"VLOOKUP(G108,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F108)*(C108)","v":0.12}]
[105,"#12 THHN BLACK",{"v":11500,"d":"11,500"},{"v":120.68,"d":"$120.68"},"M",5.15,"M",{"$f":"VLOOKUP(E109,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D109)*(C109)","v":{"v":1387.8200000000002,"d":"$1,387.82"}},{"$f":"VLOOKUP(G109,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F109)*(C109)","v":{"v":59.225,"d":"59.23"}}]
[106,"#10 THHN BLACK",{"v":15500,"d":"15,500"},{"v":184.56,"d":"$184.56"},"M",5.65,"M",{"$f":"VLOOKUP(E110,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D110)*(C110)","v":{"v":2860.68,"d":"$2,860.68"}},{"$f":"VLOOKUP(G110,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F110)*(C110)","v":{"v":87.575,"d":"87.58"}}]
[107,"# 4 THHN BLACK",160,{"v":676.12,"d":"$676.12"},"M",10.2,"M",{"$f":"VLOOKUP(E111,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D111)*(C111)","v":{"v":108.17920000000001,"d":"$108.18"}},{"$f":"VLOOKUP(G111,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F111)*(C111)","v":{"v":1.632,"d":"1.63"}}]
[108,"#1/0 THHN BLACK",280,{"v":1642.78,"d":"$1,642.78"},"M",14.2,"M",{"$f":"VLOOKUP(E112,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D112)*(C112)","v":{"v":459.97839999999997,"d":"$459.98"}},{"$f":"VLOOKUP(G112,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F112)*(C112)","v":{"v":3.9759999999999995,"d":"3.98"}}]
[109,"#350 THHN BLACK",368,{"v":5299.88,"d":"$5,299.88"},"M",31.5,"M",{"$f":"VLOOKUP(E113,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D113)*(C113)","v":{"v":1950.35584,"d":"$1,950.36"}},{"$f":"VLOOKUP(G113,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F113)*(C113)","v":{"v":11.592,"d":"11.59"}}]
[110,"# 6 THHN BLACK",310,{"v":432.81,"d":"$432.81"},"M",8.9,"M",{"$f":"VLOOKUP(E114,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D114)*(C114)","v":{"v":134.1711,"d":"$134.17"}},{"$f":"VLOOKUP(G114,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F114)*(C114)","v":{"v":2.759,"d":"2.76"}}]
[111,"# 2 THHN BLACK",35,{"v":1067.43,"d":"$1,067.43"},"M",12.4,"M",{"$f":"VLOOKUP(E115,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D115)*(C115)","v":{"v":37.36005,"d":"$37.36"}},{"$f":"VLOOKUP(G115,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F115)*(C115)","v":{"v":0.43400000000000005,"d":"0.43"}}]
[112,"# 1 THHN BLack",370,{"v":1341.79,"d":"$1,341.79"},"M",13.5,"M",{"$f":"VLOOKUP(E116,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D116)*(C116)","v":{"v":496.4623,"d":"$496.46"}},{"$f":"VLOOKUP(G116,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F116)*(C116)","v":{"v":4.995,"d":"5.00"}}]
[113,"#250 MCM THHN BLACK",240,{"v":3774.31,"d":"$3,774.31"},"M",24.2,"M",{"$f":"VLOOKUP(E117,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D117)*(C117)","v":{"v":905.8344,"d":"$905.83"}},{"$f":"VLOOKUP(G117,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F117)*(C117)","v":{"v":5.808,"d":"5.81"}}]
[114,"#500 MCM THHN BLACK",132,{"v":7617.97,"d":"$7,617.97"},"M",38.8,"M",{"$f":"VLOOKUP(E118,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D118)*(C118)","v":{"v":1005.5720400000001,"d":"$1,005.57"}},{"$f":"VLOOKUP(G118,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F118)*(C118)","v":{"v":5.1216,"d":"5.12"}}]
[115,"#600 MCM THHN BLACK",{"v":1050,"d":"1,050"},{"v":9674.84,"d":"$9,674.84"},"M",45,"M",{"$f":"VLOOKUP(E119,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D119)*(C119)","v":{"v":10158.582,"d":"$10,158.58"}},{"$f":"VLOOKUP(G119,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F119)*(C119)","v":47.25}]
[116,"#12/2C SOLID CABLE MC - STL ARMOR",{"v":1675,"d":"1,675"},{"v":440.37,"d":"$440.37"},"M",17.4,"M",{"$f":"VLOOKUP(E120,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D120)*(C120)","v":{"v":737.6197500000001,"d":"$737.62"}},{"$f":"VLOOKUP(G120,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F120)*(C120)","v":{"v":29.145,"d":"29.15"}}]
[117,"#10/2C SOLID CABLE MC - STL ARMOR",583,{"v":939.76,"d":"$939.76"},"M",21,"M",{"$f":"VLOOKUP(E121,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D121)*(C121)","v":{"v":547.88008,"d":"$547.88"}},{"$f":"VLOOKUP(G121,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F121)*(C121)","v":{"v":12.243,"d":"12.24"}}]
[118,"#12/3C SOLID CABLE MC - STL ARMOR",{"v":3415,"d":"3,415"},{"v":746.86,"d":"$746.86"},"M",19,"M",{"$f":"VLOOKUP(E122,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D122)*(C122)","v":{"v":2550.5269000000003,"d":"$2,550.53"}},{"$f":"VLOOKUP(G122,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F122)*(C122)","v":{"v":64.885,"d":"64.89"}}]
[119,"SER 3C # 2 - CU",{"v":5400,"d":"5,400"},{"v":1.5,"d":"$1.50"},"E",70,"M",{"$f":"VLOOKUP(E123,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D123)*(C123)","v":{"v":8100,"d":"$8,100.00"}},{"$f":"VLOOKUP(G123,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F123)*(C123)","v":{"v":378.00000000000006,"d":"378.00"}}]
[120,"#12/2C CORD - SOW",360,{"v":769.34,"d":"$769.34"},"M",26.4,"M",{"$f":"VLOOKUP(E124,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D124)*(C124)","v":{"v":276.9624,"d":"$276.96"}},{"$f":"VLOOKUP(G124,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F124)*(C124)","v":{"v":9.504,"d":"9.50"}}]
[121,"#14/2C NM-B",{"v":4704,"d":"4,704"},{"v":184.39,"d":"$184.39"},"M",13.5,"M",{"$f":"VLOOKUP(E125,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D125)*(C125)","v":{"v":867.37056,"d":"$867.37"}},{"$f":"VLOOKUP(G125,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F125)*(C125)","v":{"v":63.504,"d":"63.50"}}]
[122,"#12/2C NM-B",{"v":42000,"d":"42,000"},{"v":273.13,"d":"$273.13"},"M",14,"M",{"$f":"VLOOKUP(E126,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D126)*(C126)","v":{"v":11471.46,"d":"$11,471.46"}},{"$f":"VLOOKUP(G126,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F126)*(C126)","v":{"v":588,"d":"588.00"}}]
[123,"#14/3C NM-B",{"v":2592,"d":"2,592"},{"v":262.86,"d":"$262.86"},"M",16.5,"M",{"$f":"VLOOKUP(E127,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D127)*(C127)","v":{"v":681.3331200000001,"d":"$681.33"}},{"$f":"VLOOKUP(G127,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F127)*(C127)","v":{"v":42.768,"d":"42.77"}}]
[124,"#12/3C NM-B",{"v":1260,"d":"1,260"},{"v":401.15,"d":"$401.15"},"M",18.6,"M",{"$f":"VLOOKUP(E128,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D128)*(C128)","v":{"v":505.449,"d":"$505.45"}},{"$f":"VLOOKUP(G128,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F128)*(C128)","v":{"v":23.436000000000003,"d":"23.44"}}]
[125,"#10/3C NM-B",{"v":1827,"d":"1,827"},{"v":635.27,"d":"$635.27"},"M",22.8,"M",{"$f":"VLOOKUP(E129,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D129)*(C129)","v":{"v":1160.63829,"d":"$1,160.64"}},{"$f":"VLOOKUP(G129,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F129)*(C129)","v":{"v":41.6556,"d":"41.66"}}]
[126,"CAT 6 CABLE",{"v":1050,"d":"1,050"},{"v":50,"d":"$50.00"},"M",7.2,"M",{"$f":"VLOOKUP(E130,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D130)*(C130)","v":{"v":52.5,"d":"$52.50"}},{"$f":"VLOOKUP(G130,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F130)*(C130)","v":{"v":7.5600000000000005,"d":"7.56"}}]
[127,"3/8\" CONN SADDLEGRIP DC FOR FLEX / AC-90 / MC",624,{"v":48.23,"d":"$48.23"},"C",6,"C",{"$f":"VLOOKUP(E131,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D131)*(C131)","v":{"v":300.9552,"d":"$300.96"}},{"$f":"VLOOKUP(G131,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F131)*(C131)","v":37.44}]
[128,"1/2\" CONN SADDLEGRIP DC FOR FLEX / AC-90 / MC",164,{"v":1.6,"d":"$1.60"},"E",9,"C",{"$f":"VLOOKUP(E132,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D132)*(C132)","v":{"v":262.40000000000003,"d":"$262.40"}},{"$f":"VLOOKUP(G132,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F132)*(C132)","v":14.76}]
[129,"1/2\" CONN 2-SCREW STRAP TYPE DC FOR NMC",{"v":3372,"d":"3,372"},{"v":0.5,"d":"$0.50"},"E",9,"C",{"$f":"VLOOKUP(E133,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D133)*(C133)","v":{"v":1686,"d":"$1,686.00"}},{"$f":"VLOOKUP(G133,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F133)*(C133)","v":{"v":303.47999999999996,"d":"303.48"}}]
[130,"1 1/2\" CONN 2-SCREW STRAP TYPE DC FOR ROUND NMC",90,{"v":186,"d":"$186.00"},"C",23,"C",{"$f":"VLOOKUP(E134,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D134)*(C134)","v":{"v":167.4,"d":"$167.40"}},{"$f":"VLOOKUP(G134,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F134)*(C134)","v":{"v":20.7,"d":"20.70"}}]
[131,"#12/2C CORD CONN - SO -   3/4\" HUB",120,{"v":4.1,"d":"$4.10"},"E",43,"C",{"$f":"VLOOKUP(E135,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D135)*(C135)","v":{"v":491.99999999999994,"d":"$492.00"}},{"$f":"VLOOKUP(G135,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F135)*(C135)","v":{"v":51.6,"d":"51.60"}}]
[132,"1-H STRAP #14/2 & #12/2",42,{"v":19.12,"d":"$19.12"},"C",4.6,"C",{"$f":"VLOOKUP(E136,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D136)*(C136)","v":{"v":8.0304,"d":"$8.03"}},{"$f":"VLOOKUP(G136,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F136)*(C136)","v":{"v":1.932,"d":"1.93"}}]
[133,"1-H STRAP #14/3 & #12/3",361,{"v":20.33,"d":"$20.33"},"C",4.6,"C",{"$f":"VLOOKUP(E137,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D137)*(C137)","v":{"v":73.39129999999999,"d":"$73.39"}},{"$f":"VLOOKUP(G137,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F137)*(C137)","v":{"v":16.605999999999998,"d":"16.61"}}]
[134,"1-H STRAP #12/4 & #10/2 & #10/3",89,{"v":10.8,"d":"$10.80"},"C",4.6,"C",{"$f":"VLOOKUP(E138,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D138)*(C138)","v":{"v":9.612000000000002,"d":"$9.61"}},{"$f":"VLOOKUP(G138,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F138)*(C138)","v":{"v":4.094,"d":"4.09"}}]
[135,"1-H CABLE STRAP",88,{"v":0.1,"d":"$0.10"},"E",2,"C",{"$f":"VLOOKUP(E139,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D139)*(C139)","v":{"v":8.8,"d":"$8.80"}},{"$f":"VLOOKUP(G139,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F139)*(C139)","v":1.76}]
[136,"1\"     ROMEX STAPLE",{"v":20000,"d":"20,000"},{"v":1,"d":"$1.00"},"C",1,"C",{"$f":"VLOOKUP(E140,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D140)*(C140)","v":{"v":200,"d":"$200.00"}},{"$f":"VLOOKUP(G140,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F140)*(C140)","v":{"v":200,"d":"200.00"}}]
[137,"SER 2/3 STAPLE ",572,{"v":7,"d":"$7.00"},"C",0.05,"E",{"$f":"VLOOKUP(E141,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D141)*(C141)","v":{"v":40.040000000000006,"d":"$40.04"}},{"$f":"VLOOKUP(G141,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F141)*(C141)","v":{"v":28.6,"d":"28.60"}}]
[138,"COMPRESSION LUG - CU W/ 1-  9/32\" HOLE - # 6 CU WIRE",16,{"v":3,"d":"$3.00"},"E",13,"C",{"$f":"VLOOKUP(E142,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D142)*(C142)","v":{"v":48,"d":"$48.00"}},{"$f":"VLOOKUP(G142,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F142)*(C142)","v":2.08}]
[139,"WIRE CONN YEL",{"v":5529,"d":"5,529"},{"v":9.42,"d":"$9.42"},"C",2,"C",{"$f":"VLOOKUP(E143,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D143)*(C143)","v":{"v":520.8318,"d":"$520.83"}},{"$f":"VLOOKUP(G143,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F143)*(C143)","v":110.58}]
[140,"WIRE CONN RED",{"v":13592,"d":"13,592"},{"v":11.52,"d":"$11.52"},"C",2,"C",{"$f":"VLOOKUP(E144,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D144)*(C144)","v":{"v":1565.7984,"d":"$1,565.80"}},{"$f":"VLOOKUP(G144,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F144)*(C144)","v":{"v":271.84000000000003,"d":"271.84"}}]
[141,"  1/8\" POLYTWINE",426,{"v":30,"d":"$30.00"},"M",3,"M",{"$f":"VLOOKUP(E145,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D145)*(C145)","v":{"v":12.78,"d":"$12.78"}},{"$f":"VLOOKUP(G145,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F145)*(C145)","v":{"v":1.278,"d":"1.28"}}]
[142,"SILICONE SEALANT (TUBE)",49,{"v":6.58,"d":"$6.58"},"E",1.5,"E",{"$f":"VLOOKUP(E146,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D146)*(C146)","v":{"v":322.42,"d":"$322.42"}},{"$f":"VLOOKUP(G146,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F146)*(C146)","v":{"v":73.5,"d":"73.50"}}]
[143,"4x 1 1/2\" OCT BOX 1/2\" KO",3,{"v":88.74,"d":"$88.74"},"C",22,"C",{"$f":"VLOOKUP(E147,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D147)*(C147)","v":{"v":2.6622,"d":"$2.66"}},{"$f":"VLOOKUP(G147,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F147)*(C147)","v":0.66}]
[144,"4x 1 1/2\" OCT BOX COMB KO",23,{"v":1.75,"d":"$1.75"},"E",22,"C",{"$f":"VLOOKUP(E148,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D148)*(C148)","v":{"v":40.25,"d":"$40.25"}},{"$f":"VLOOKUP(G148,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F148)*(C148)","v":5.06}]
[145,"4x 1 1/2\" OCT BOX 1/2\" KO W/ RCSD SIDE BRKT",79,{"v":1.31,"d":"$1.31"},"E",22,"C",{"$f":"VLOOKUP(E149,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D149)*(C149)","v":{"v":103.49000000000001,"d":"$103.49"}},{"$f":"VLOOKUP(G149,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F149)*(C149)","v":17.38}]
[146,"4x 1 1/2\" OCT BOX 1/2\" KO W/ BAR HNGR",550,{"v":14.44,"d":"$14.44"},"E",22,"C",{"$f":"VLOOKUP(E150,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D150)*(C150)","v":{"v":7942,"d":"$7,942.00"}},{"$f":"VLOOKUP(G150,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F150)*(C150)","v":{"v":121,"d":"121.00"}}]
[147,"4x 1 1/2\" OCT BOX AC-90 CLAMP W/ BAR HNGR",38,{"v":1.71,"d":"$1.71"},"E",22,"C",{"$f":"VLOOKUP(E151,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D151)*(C151)","v":{"v":64.98,"d":"$64.98"}},{"$f":"VLOOKUP(G151,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F151)*(C151)","v":8.36}]
[148,"4x 1 1/2\" SQ BOX COMB KO",217,{"v":64.87,"d":"$64.87"},"C",23,"C",{"$f":"VLOOKUP(E152,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D152)*(C152)","v":{"v":140.76790000000003,"d":"$140.77"}},{"$f":"VLOOKUP(G152,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F152)*(C152)","v":{"v":49.910000000000004,"d":"49.91"}}]
[149,"4x 1 1/2\" SQ BOX COMB KO W/ FLUSH SIDE MNT BRKT",61,{"v":7.15,"d":"$7.15"},"E",23,"C",{"$f":"VLOOKUP(E153,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D153)*(C153)","v":{"v":436.15000000000003,"d":"$436.15"}},{"$f":"VLOOKUP(G153,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F153)*(C153)","v":{"v":14.030000000000001,"d":"14.03"}}]
[150,"4x 1 1/2\" SQ BOX COMB KO W/ FLUSH MTL STUD BRKT",110,{"v":114.28,"d":"$114.28"},"C",23,"C",{"$f":"VLOOKUP(E154,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D154)*(C154)","v":{"v":125.708,"d":"$125.71"}},{"$f":"VLOOKUP(G154,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F154)*(C154)","v":{"v":25.3,"d":"25.30"}}]
[151,"4x 2 1/8\" SQ BOX COMB KO",183,{"v":107.6,"d":"$107.60"},"C",23,"C",{"$f":"VLOOKUP(E155,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D155)*(C155)","v":{"v":196.90800000000002,"d":"$196.91"}},{"$f":"VLOOKUP(G155,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F155)*(C155)","v":42.09}]
[152,"4\" SQ 1G PLSTR RING 5/8\" RISE",129,{"v":1.21,"d":"$1.21"},"E",2.5,"C",{"$f":"VLOOKUP(E156,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D156)*(C156)","v":{"v":156.09,"d":"$156.09"}},{"$f":"VLOOKUP(G156,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F156)*(C156)","v":{"v":3.225,"d":"3.23"}}]
[153,"4x 2 1/8\" SQ BOX  Large Capacity W up to 2\" KO",2,{"v":9.21,"d":"$9.21"},"E",23,"C",{"$f":"VLOOKUP(E157,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D157)*(C157)","v":{"v":18.42,"d":"$18.42"}},{"$f":"VLOOKUP(G157,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F157)*(C157)","v":0.46}]
[154,"4\" SQ BLANK COVER",{"v":3546,"d":"3,546"},{"v":27.19,"d":"$27.19"},"C",2.5,"C",{"$f":"VLOOKUP(E158,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D158)*(C158)","v":{"v":964.1574,"d":"$964.16"}},{"$f":"VLOOKUP(G158,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F158)*(C158)","v":88.65}]
[155,"4 11/16x 1 1/2\" SQ BOX COMB KO",2,{"v":2.84,"d":"$2.84"},"E",25,"C",{"$f":"VLOOKUP(E159,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D159)*(C159)","v":{"v":5.68,"d":"$5.68"}},{"$f":"VLOOKUP(G159,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F159)*(C159)","v":{"v":0.5,"d":"0.50"}}]
[156,"4 11/16x 2 1/8\" SQ BOX COMB KO",26,{"v":2.43,"d":"$2.43"},"E",25,"C",{"$f":"VLOOKUP(E160,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D160)*(C160)","v":{"v":63.18000000000001,"d":"$63.18"}},{"$f":"VLOOKUP(G160,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F160)*(C160)","v":{"v":6.5,"d":"6.50"}}]
[157,"4 11/16x 2 1/8\" SQ BOX 1\" KO",18,{"v":245.42,"d":"$245.42"},"C",25,"C",{"$f":"VLOOKUP(E161,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D161)*(C161)","v":{"v":44.175599999999996,"d":"$44.18"}},{"$f":"VLOOKUP(G161,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F161)*(C161)","v":{"v":4.5,"d":"4.50"}}]
[158,"4 11/16\" SQ BLANK COVER",22,{"v":62.1,"d":"$62.10"},"C",2.5,"C",{"$f":"VLOOKUP(E162,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D162)*(C162)","v":{"v":13.661999999999999,"d":"$13.66"}},{"$f":"VLOOKUP(G162,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F162)*(C162)","v":0.55}]
[159,"4 11/16\" SQ 1G PLSTR RING 5/8\" RISE",2,{"v":1.05,"d":"$1.05"},"C",2.5,"C",{"$f":"VLOOKUP(E163,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D163)*(C163)","v":{"v":0.021,"d":"$0.02"}},{"$f":"VLOOKUP(G163,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F163)*(C163)","v":0.05}]
[160,"4 11/16\" SQ 2G PLSTR RING 5/8\" RISE",9,{"v":3,"d":"$3.00"},"E",2.5,"C",{"$f":"VLOOKUP(E164,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D164)*(C164)","v":{"v":27,"d":"$27.00"}},{"$f":"VLOOKUP(G164,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F164)*(C164)","v":{"v":0.225,"d":"0.23"}}]
[161,"4x 1 1/2\" OCT BOX NMC CLAMP W/ RCSD FLAT BRKT",67,{"v":3.1,"d":"$3.10"},"C",22,"C",{"$f":"VLOOKUP(E165,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D165)*(C165)","v":{"v":2.0770000000000004,"d":"$2.08"}},{"$f":"VLOOKUP(G165,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F165)*(C165)","v":14.74}]
[162,"4x 1 1/2\" OCT BOX NMC CLAMP W/ BAR HNGR",45,{"v":2.84,"d":"$2.84"},"E",22,"C",{"$f":"VLOOKUP(E166,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D166)*(C166)","v":{"v":127.8,"d":"$127.80"}},{"$f":"VLOOKUP(G166,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F166)*(C166)","v":{"v":9.9,"d":"9.90"}}]
[163,"1G NM DEV BOX 3 3/8\" DEEP W/ NAILS - 22.5ci",65,{"v":0.75,"d":"$0.75"},"C",22,"C",{"$f":"VLOOKUP(E167,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D167)*(C167)","v":{"v":0.4875,"d":"$0.49"}},{"$f":"VLOOKUP(G167,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F167)*(C167)","v":{"v":14.3,"d":"14.30"}}]
[164,"1G NM DEV BOX 3 3/8\" DEEP W/ DEVICE QUICK CONNECT",{"v":1388,"d":"1,388"},{"v":0.5,"d":"$0.50"},"E",22,"C",{"$f":"VLOOKUP(E168,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D168)*(C168)","v":{"v":694,"d":"$694.00"}},{"$f":"VLOOKUP(G168,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F168)*(C168)","v":305.36}]
[165,"1G NM BOX 2 3/4\" DEEP SIDE BRKT W/ DEVICE QUICK CONNECT",167,{"v":0.5,"d":"$0.50"},"E",22,"C",{"$f":"VLOOKUP(E169,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D169)*(C169)","v":{"v":83.5,"d":"$83.50"}},{"$f":"VLOOKUP(G169,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F169)*(C169)","v":36.74}]
[166,"2G NM BOX 2 7/8\" DEEP SIDE BRKT W/ DEVICE QUICK CONNECT",141,{"v":1,"d":"$1.00"},"E",22,"C",{"$f":"VLOOKUP(E170,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D170)*(C170)","v":{"v":141,"d":"$141.00"}},{"$f":"VLOOKUP(G170,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F170)*(C170)","v":31.02}]
[167,"3G NM BOX 3\"     DEEP SIDE BRKT W/ DEVICE QUICK CONNECT",104,{"v":2.37,"d":"$2.37"},"E",26,"C",{"$f":"VLOOKUP(E171,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D171)*(C171)","v":{"v":246.48000000000002,"d":"$246.48"}},{"$f":"VLOOKUP(G171,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F171)*(C171)","v":27.04}]
[168,"4x 1 1/2\" SQ NM BOX SIDE BRKT",{"v":3111,"d":"3,111"},{"v":2.53,"d":"$2.53"},"E",22,"C",{"$f":"VLOOKUP(E172,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D172)*(C172)","v":{"v":7870.829999999999,"d":"$7,870.83"}},{"$f":"VLOOKUP(G172,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F172)*(C172)","v":684.42}]
[169,"4x 2 1/8\" RND NM BOX + GRD",42,{"v":2,"d":"$2.00"},"E",22,"C",{"$f":"VLOOKUP(E173,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D173)*(C173)","v":{"v":84,"d":"$84.00"}},{"$f":"VLOOKUP(G173,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F173)*(C173)","v":9.24}]
[170,"1G 2\"D DC ALUM BOX W/ LUGS & 3x   3/4\" HUBS GRY",2,{"v":473.53,"d":"$473.53"},"C",0.35,"E",{"$f":"VLOOKUP(E174,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D174)*(C174)","v":{"v":9.4706,"d":"$9.47"}},{"$f":"VLOOKUP(G174,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F174)*(C174)","v":{"v":0.7,"d":"0.70"}}]
[171,"2G ALUM DB Box WP Switch COVER GRY",2,{"v":15,"d":"$15.00"},"E",0.07,"E",{"$f":"VLOOKUP(E175,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D175)*(C175)","v":{"v":30,"d":"$30.00"}},{"$f":"VLOOKUP(G175,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F175)*(C175)","v":0.14}]
[172,"GROUND SCREW W/ INSUL #12 LEAD",76,{"v":385.64,"d":"$385.64"},"M",3,"C",{"$f":"VLOOKUP(E176,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D176)*(C176)","v":{"v":29.308639999999997,"d":"$29.31"}},{"$f":"VLOOKUP(G176,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F176)*(C176)","v":2.28}]
[173,"21\" Vented Structured Media Panel",69,{"v":30,"d":"$30.00"},"E",1,"E",{"$f":"VLOOKUP(E177,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D177)*(C177)","v":{"v":2070,"d":"$2,070.00"}},{"$f":"VLOOKUP(G177,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F177)*(C177)","v":{"v":69,"d":"69.00"}}]
[174,"  3/4\"x 10' GALV GRD ROD",8,{"v":40,"d":"$40.00"},"E",1,"E",{"$f":"VLOOKUP(E178,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D178)*(C178)","v":{"v":320,"d":"$320.00"}},{"$f":"VLOOKUP(G178,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F178)*(C178)","v":{"v":8,"d":"8.00"}}]
[175,"BURNDY GAR114C 1/2\" Rod TO #4 STR ",8,{"v":35,"d":"$35.00"},"E",0.35,"E",{"$f":"VLOOKUP(E179,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D179)*(C179)","v":{"v":280,"d":"$280.00"}},{"$f":"VLOOKUP(G179,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F179)*(C179)","v":{"v":2.8,"d":"2.80"}}]
[176,"Grn Buss Gr 1/4\" X 2\" X 15\"  Erico  EGBA14215TES",12,{"v":120,"d":"$120.00"},"E",1,"E",{"$f":"VLOOKUP(E180,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D180)*(C180)","v":{"v":1440,"d":"$1,440.00"}},{"$f":"VLOOKUP(G180,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F180)*(C180)","v":{"v":12,"d":"12.00"}}]
[177,"Polymar Hand Hole W Cover ",2,{"v":210,"d":"$210.00"},"E",2.5,"E",{"$f":"VLOOKUP(E181,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D181)*(C181)","v":{"v":420,"d":"$420.00"}},{"$f":"VLOOKUP(G181,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F181)*(C181)","v":{"v":5,"d":"5.00"}}]
[178,"1 5/8x 1 5/8x 12G STRUT SLOTTED HOLE GALV",506,{"v":3.18,"d":"$3.18"},"E",10,"C",{"$f":"VLOOKUP(E182,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D182)*(C182)","v":{"v":1609.0800000000002,"d":"$1,609.08"}},{"$f":"VLOOKUP(G182,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F182)*(C182)","v":{"v":50.6,"d":"50.60"}}]
[179,"#8x   3/4 F/H SELF-TAP SCREW",2,{"v":0,"d":"$0.00"},"C",2.6,"C",{"$f":"VLOOKUP(E183,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D183)*(C183)","v":{"v":0,"d":"$0.00"}},{"$f":"VLOOKUP(G183,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F183)*(C183)","v":{"v":0.052000000000000005,"d":"0.05"}}]
[180,"#10x 1     P/H SELF-TAP SCREW",{"v":2090,"d":"2,090"},{"v":0,"d":"$0.00"},"C",3,"C",{"$f":"VLOOKUP(E184,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D184)*(C184)","v":{"v":0,"d":"$0.00"}},{"$f":"VLOOKUP(G184,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F184)*(C184)","v":{"v":62.699999999999996,"d":"62.70"}}]
[181,"#10x   3/4 WOOD SCREW",84,{"v":0,"d":"$0.00"},"C",2.8,"C",{"$f":"VLOOKUP(E185,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D185)*(C185)","v":{"v":0,"d":"$0.00"}},{"$f":"VLOOKUP(G185,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F185)*(C185)","v":{"v":2.352,"d":"2.35"}}]
[182,"#10x 1     WOOD SCREW",132,{"v":0,"d":"$0.00"},"C",3,"C",{"$f":"VLOOKUP(E186,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D186)*(C186)","v":{"v":0,"d":"$0.00"}},{"$f":"VLOOKUP(G186,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F186)*(C186)","v":3.96}]
[183,"#8x   1/2 WAFER HEAD SHEET MTL SCREW",248,{"v":0,"d":"$0.00"},"C",1.5,"C",{"$f":"VLOOKUP(E187,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D187)*(C187)","v":{"v":0,"d":"$0.00"}},{"$f":"VLOOKUP(G187,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F187)*(C187)","v":{"v":3.7199999999999998,"d":"3.72"}}]
[184,"BEAM CLAMP FOR 1/2-13 ROD OR STRUT END TO 1\" FLNG",12,{"v":5,"d":"$5.00"},"E",10,"C",{"$f":"VLOOKUP(E188,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D188)*(C188)","v":{"v":60,"d":"$60.00"}},{"$f":"VLOOKUP(G188,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F188)*(C188)","v":{"v":1.2000000000000002,"d":"1.20"}}]
[185,"Misc Hardware",658,{"v":1,"d":"$1.00"},"E",0.01,"E",{"$f":"VLOOKUP(E189,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D189)*(C189)","v":{"v":658,"d":"$658.00"}},{"$f":"VLOOKUP(G189,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F189)*(C189)","v":6.58}]
[186,"4' X8' X 3/4\" Plywood Fire Rated",8,{"v":48,"d":"$48.00"},"E",0.33,"E",{"$f":"VLOOKUP(E190,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D190)*(C190)","v":{"v":384,"d":"$384.00"}},{"$f":"VLOOKUP(G190,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F190)*(C190)","v":2.64}]
[187,"1G TGL SWITCH PLATE - PLASTIC IVY",270,{"v":0.4,"d":"$0.40"},"E",3,"C",{"$f":"VLOOKUP(E191,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D191)*(C191)","v":{"v":108,"d":"$108.00"}},{"$f":"VLOOKUP(G191,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F191)*(C191)","v":{"v":8.1,"d":"8.10"}}]
[188,"2G TGL SWITCH PLATE - PLASTIC IVY",141,{"v":0.77,"d":"$0.77"},"E",4.5,"C",{"$f":"VLOOKUP(E192,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D192)*(C192)","v":{"v":108.57000000000001,"d":"$108.57"}},{"$f":"VLOOKUP(G192,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F192)*(C192)","v":{"v":6.345,"d":"6.35"}}]
[189,"3G TGL SWITCH PLATE - PLASTIC IVY",104,{"v":2.31,"d":"$2.31"},"E",6,"C",{"$f":"VLOOKUP(E193,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D193)*(C193)","v":{"v":240.24,"d":"$240.24"}},{"$f":"VLOOKUP(G193,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F193)*(C193)","v":6.24}]
[190,"1G SINGLE REC PLATE - PLASTIC IVY",1,{"v":0.64,"d":"$0.64"},"E",3,"C",{"$f":"VLOOKUP(E194,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D194)*(C194)","v":{"v":0.64,"d":"$0.64"}},{"$f":"VLOOKUP(G194,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F194)*(C194)","v":0.03}]
[191,"1G DUPLEX REC PLATE - PLASTIC IVY",{"v":1308,"d":"1,308"},{"v":0.35,"d":"$0.35"},"E",2.7,"C",{"$f":"VLOOKUP(E195,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D195)*(C195)","v":{"v":457.79999999999995,"d":"$457.80"}},{"$f":"VLOOKUP(G195,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F195)*(C195)","v":{"v":35.316,"d":"35.32"}}]
[192,"2G DUPLEX REC PLATE - PLASTIC IVY",9,{"v":0.67,"d":"$0.67"},"E",3.9,"C",{"$f":"VLOOKUP(E196,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D196)*(C196)","v":{"v":6.03,"d":"$6.03"}},{"$f":"VLOOKUP(G196,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F196)*(C196)","v":{"v":0.351,"d":"0.35"}}]
[193,"1G DECORATOR PLATE - PLASTIC IVY",4,{"v":0.7,"d":"$0.70"},"E",3,"C",{"$f":"VLOOKUP(E197,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D197)*(C197)","v":{"v":2.8,"d":"$2.80"}},{"$f":"VLOOKUP(G197,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F197)*(C197)","v":0.12}]
[194,"1G UNIV WP-IN-USE PLATE - DEVICE MNT VERT/HORZ - CLEAR",35,{"v":49.51,"d":"$49.51"},"E",6,"C",{"$f":"VLOOKUP(E198,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D198)*(C198)","v":{"v":1732.85,"d":"$1,732.85"}},{"$f":"VLOOKUP(G198,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F198)*(C198)","v":{"v":2.1,"d":"2.10"}}]
[195,"Meatal cover W 1/2\" KO",67,{"v":2.38,"d":"$2.38"},"E",3,"C",{"$f":"VLOOKUP(E199,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D199)*(C199)","v":{"v":159.45999999999998,"d":"$159.46"}},{"$f":"VLOOKUP(G199,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F199)*(C199)","v":2.01}]
[196,"20A  S/P SW - TOGGLE ",593,{"v":3,"d":"$3.00"},"E",14,"C",{"$f":"VLOOKUP(E200,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D200)*(C200)","v":{"v":1779,"d":"$1,779.00"}},{"$f":"VLOOKUP(G200,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F200)*(C200)","v":{"v":83.02000000000001,"d":"83.02"}}]
[197,"20A 120-277V 3/W SW - TOGGLE IVY (SG)",328,{"v":5,"d":"$5.00"},"E",20,"C",{"$f":"VLOOKUP(E201,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D201)*(C201)","v":{"v":1640,"d":"$1,640.00"}},{"$f":"VLOOKUP(G201,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F201)*(C201)","v":{"v":65.60000000000001,"d":"65.60"}}]
[198,"20A 120-277V 4/W SW - TOGGLE IVY (SG)",11,{"v":5.26,"d":"$5.26"},"E",22,"C",{"$f":"VLOOKUP(E202,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D202)*(C202)","v":{"v":57.86,"d":"$57.86"}},{"$f":"VLOOKUP(G202,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F202)*(C202)","v":2.42}]
[199,"120/277V WALL OCC SWITCH  IVY",4,{"v":40,"d":"$40.00"},"E",0.35,"E",{"$f":"VLOOKUP(E203,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D203)*(C203)","v":{"v":160,"d":"$160.00"}},{"$f":"VLOOKUP(G203,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F203)*(C203)","v":{"v":1.4,"d":"1.40"}}]
[200,"1G DECORATOR PLATE IVY",4,{"v":120,"d":"$120.00"},"C",2.5,"C",{"$f":"VLOOKUP(E204,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D204)*(C204)","v":{"v":4.8,"d":"$4.80"}},{"$f":"VLOOKUP(G204,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F204)*(C204)","v":{"v":0.1,"d":"0.10"}}]
[201,"CiEILING 24V WPIR  OCC SENSOR",3,{"v":75,"d":"$75.00"},"E",0.6,"E",{"$f":"VLOOKUP(E205,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D205)*(C205)","v":{"v":225,"d":"$225.00"}},{"$f":"VLOOKUP(G205,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F205)*(C205)","v":{"v":1.7999999999999998,"d":"1.80"}}]
[202,"20A 125V 3W SGL REC - BRN (SG)",1,{"v":2.66,"d":"$2.66"},"E",20,"C",{"$f":"VLOOKUP(E206,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D206)*(C206)","v":{"v":2.66,"d":"$2.66"}},{"$f":"VLOOKUP(G206,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F206)*(C206)","v":{"v":0.2,"d":"0.20"}}]
[203,"30A 250V 4W 1PH REC (GP-DRYER)",22,{"v":6.5,"d":"$6.50"},"E",35,"C",{"$f":"VLOOKUP(E207,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D207)*(C207)","v":{"v":143,"d":"$143.00"}},{"$f":"VLOOKUP(G207,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F207)*(C207)","v":{"v":7.700000000000001,"d":"7.70"}}]
[204,"20A 125V DUP REC - IVY (SG)",69,{"v":2.66,"d":"$2.66"},"E",20,"C",{"$f":"VLOOKUP(E208,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D208)*(C208)","v":{"v":183.54000000000002,"d":"$183.54"}},{"$f":"VLOOKUP(G208,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F208)*(C208)","v":{"v":13.8,"d":"13.80"}}]
[205,"20A 125V DUP REC - IVY (CS)",646,{"v":2.66,"d":"$2.66"},"E",15,"C",{"$f":"VLOOKUP(E209,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D209)*(C209)","v":{"v":1718.3600000000001,"d":"$1,718.36"}},{"$f":"VLOOKUP(G209,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F209)*(C209)","v":{"v":96.89999999999999,"d":"96.90"}}]
[206,"20A 125V DUP REC - GFCI IVY (SG)",542,{"v":15.98,"d":"$15.98"},"C",25,"C",{"$f":"VLOOKUP(E210,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D210)*(C210)","v":{"v":86.6116,"d":"$86.61"}},{"$f":"VLOOKUP(G210,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F210)*(C210)","v":{"v":135.5,"d":"135.50"}}]
[207,"Combo TV & Recpticle",108,{"v":35,"d":"$35.00"},"E",0.5,"E",{"$f":"VLOOKUP(E211,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D211)*(C211)","v":{"v":3780,"d":"$3,780.00"}},{"$f":"VLOOKUP(G211,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F211)*(C211)","v":{"v":54,"d":"54.00"}}]
[208,"LABOR F/A DETECTOR - Combo Carbon Monoxide & Smoke Detector W Intregal Sounder",45,{"v":0,"d":"$0.00"},"E",0.5,"E",{"$f":"VLOOKUP(E212,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D212)*(C212)","v":{"v":0,"d":"$0.00"}},{"$f":"VLOOKUP(G212,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F212)*(C212)","v":{"v":22.5,"d":"22.50"}}]
[209,"LABOR F/A SMOKE ALARM - 120V",42,{"v":0,"d":"$0.00"},"E",0.4,"E",{"$f":"VLOOKUP(E213,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D213)*(C213)","v":{"v":0,"d":"$0.00"}},{"$f":"VLOOKUP(G213,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F213)*(C213)","v":{"v":16.8,"d":"16.80"}}]
[210,"F/A CONTROL PANEL -  4 ZONE",2,{"v":0,"d":"$0.00"},"E",5,"E",{"$f":"VLOOKUP(E214,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D214)*(C214)","v":{"v":0,"d":"$0.00"}},{"$f":"VLOOKUP(G214,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F214)*(C214)","v":{"v":10,"d":"10.00"}}]
[211,"2P MOTOR SWITCH TGL OP 2x 3/4\" HUB - NEMA  4",2,{"v":40,"d":"$40.00"},"E",1.3,"E",{"$f":"VLOOKUP(E215,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D215)*(C215)","v":{"v":80,"d":"$80.00"}},{"$f":"VLOOKUP(G215,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F215)*(C215)","v":{"v":2.6,"d":"2.60"}}]
[212,"24HR SPST 120V TIME SW",2,{"v":170,"d":"$170.00"},"E",1.5,"E",{"$f":"VLOOKUP(E216,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D216)*(C216)","v":{"v":340,"d":"$340.00"}},{"$f":"VLOOKUP(G216,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F216)*(C216)","v":{"v":3,"d":"3.00"}}]
[213,"SWBD RECEIVING AND UNLOAD",1,{"v":0,"d":"$0.00"},"E",2,"E",{"$f":"VLOOKUP(E217,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D217)*(C217)","v":{"v":0,"d":"$0.00"}},{"$f":"VLOOKUP(G217,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F217)*(C217)","v":{"v":2,"d":"2.00"}}]
[214,"SWBD PUT INTO PLACE",1,{"v":0,"d":"$0.00"},"E",6,"E",{"$f":"VLOOKUP(E218,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D218)*(C218)","v":{"v":0,"d":"$0.00"}},{"$f":"VLOOKUP(G218,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F218)*(C218)","v":{"v":6,"d":"6.00"}}]
[215,"BPB RECEIVING AND UNLOAD",46,{"v":0,"d":"$0.00"},"E",4,"E",{"$f":"VLOOKUP(E219,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D219)*(C219)","v":{"v":0,"d":"$0.00"}},{"$f":"VLOOKUP(G219,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F219)*(C219)","v":{"v":184,"d":"184.00"}}]
[216,"BPB PUT INTO PLACE",46,{"v":0,"d":"$0.00"},"E",8,"E",{"$f":"VLOOKUP(E220,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D220)*(C220)","v":{"v":0,"d":"$0.00"}},{"$f":"VLOOKUP(G220,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F220)*(C220)","v":{"v":368,"d":"368.00"}}]
[217,"30A 250V DSN SW FUSIBLE - NEMA  1",1,{"v":11.5,"d":"$11.50"},"E",1.1,"E",{"$f":"VLOOKUP(E221,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D221)*(C221)","v":{"v":11.5,"d":"$11.50"}},{"$f":"VLOOKUP(G221,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F221)*(C221)","v":{"v":1.1,"d":"1.10"}}]
[218,"30A 250V DSN SW FUSIBLE - NEMA  3R",48,{"v":11.5,"d":"$11.50"},"E",1.2,"E",{"$f":"VLOOKUP(E222,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D222)*(C222)","v":{"v":552,"d":"$552.00"}},{"$f":"VLOOKUP(G222,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F222)*(C222)","v":{"v":57.599999999999994,"d":"57.60"}}]
[219,"100A 250V DSN SW FUSIBLE - NEMA  3R",1,{"v":217.69,"d":"$217.69"},"E",2.1,"E",{"$f":"VLOOKUP(E223,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D223)*(C223)","v":{"v":217.69,"d":"$217.69"}},{"$f":"VLOOKUP(G223,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F223)*(C223)","v":{"v":2.1,"d":"2.10"}}]
[220,"200A 250V DSN SW FUSIBLE - NEMA  1",1,{"v":419.53,"d":"$419.53"},"E",3.1,"E",{"$f":"VLOOKUP(E224,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D224)*(C224)","v":{"v":419.53,"d":"$419.53"}},{"$f":"VLOOKUP(G224,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F224)*(C224)","v":{"v":3.1,"d":"3.10"}}]
[221,"30A FUSE 250V TIME DELAY CLASS RK1",98,{"v":3.14,"d":"$3.14"},"E",0.04,"E",{"$f":"VLOOKUP(E225,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D225)*(C225)","v":{"v":307.72,"d":"$307.72"}},{"$f":"VLOOKUP(G225,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F225)*(C225)","v":3.92}]
[222,"100A FUSE 250V TIME DELAY CLASS RK1",2,{"v":50,"d":"$50.00"},"E",0.05,"E",{"$f":"VLOOKUP(E226,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D226)*(C226)","v":{"v":100,"d":"$100.00"}},{"$f":"VLOOKUP(G226,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F226)*(C226)","v":{"v":0.1,"d":"0.10"}}]
[223,"200A FUSE 250V TIME DELAY CLASS RK1",2,{"v":110,"d":"$110.00"},"E",0.1,"E",{"$f":"VLOOKUP(E227,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D227)*(C227)","v":{"v":220,"d":"$220.00"}},{"$f":"VLOOKUP(G227,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F227)*(C227)","v":{"v":0.2,"d":"0.20"}}]
[224,"METER SECTION  RECEIVING AND UNLOAD",1,{"v":0,"d":"$0.00"},"E",4,"E",{"$f":"VLOOKUP(E228,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D228)*(C228)","v":{"v":0,"d":"$0.00"}},{"$f":"VLOOKUP(G228,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F228)*(C228)","v":{"v":4,"d":"4.00"}}]
[225,"METER SECTION PUT INTO PLACE",1,{"v":0,"d":"$0.00"},"E",8,"E",{"$f":"VLOOKUP(E229,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D229)*(C229)","v":{"v":0,"d":"$0.00"}},{"$f":"VLOOKUP(G229,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F229)*(C229)","v":{"v":8,"d":"8.00"}}]
[226,"#12 WIRE POWER TERM",150,{"v":0.8,"d":"$0.80"},"E",0.09,"E",{"$f":"VLOOKUP(E230,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D230)*(C230)","v":{"v":120,"d":"$120.00"}},{"$f":"VLOOKUP(G230,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F230)*(C230)","v":{"v":13.5,"d":"13.50"}}]
[227,"# 6 WIRE POWER TERM",2,{"v":1.25,"d":"$1.25"},"E",0.17,"E",{"$f":"VLOOKUP(E231,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D231)*(C231)","v":{"v":2.5,"d":"$2.50"}},{"$f":"VLOOKUP(G231,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F231)*(C231)","v":0.34}]
[228,"# 4 WIRE POWER TERM",6,{"v":1.25,"d":"$1.25"},"E",0.21,"E",{"$f":"VLOOKUP(E232,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D232)*(C232)","v":{"v":7.5,"d":"$7.50"}},{"$f":"VLOOKUP(G232,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F232)*(C232)","v":1.26}]
[229,"# 2 WIRE POWER TERM",2,{"v":1,"d":"$1.00"},"E",0.25,"E",{"$f":"VLOOKUP(E233,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D233)*(C233)","v":{"v":2,"d":"$2.00"}},{"$f":"VLOOKUP(G233,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F233)*(C233)","v":{"v":0.5,"d":"0.50"}}]
[230,"# 1 WIRE POWER TERM",12,{"v":1,"d":"$1.00"},"E",0.29,"E",{"$f":"VLOOKUP(E234,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D234)*(C234)","v":{"v":12,"d":"$12.00"}},{"$f":"VLOOKUP(G234,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F234)*(C234)","v":{"v":3.4799999999999995,"d":"3.48"}}]
[231,"#1/0 WIRE POWER TERM",6,{"v":1,"d":"$1.00"},"E",0.32,"E",{"$f":"VLOOKUP(E235,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D235)*(C235)","v":{"v":6,"d":"$6.00"}},{"$f":"VLOOKUP(G235,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F235)*(C235)","v":1.92}]
[232,"#250 WIRE POWER TERM",18,{"v":1,"d":"$1.00"},"E",0.47,"E",{"$f":"VLOOKUP(E236,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D236)*(C236)","v":{"v":18,"d":"$18.00"}},{"$f":"VLOOKUP(G236,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F236)*(C236)","v":{"v":8.459999999999999,"d":"8.46"}}]
[233,"#350 WIRE POWER TERM",32,{"v":1,"d":"$1.00"},"E",0.54,"E",{"$f":"VLOOKUP(E237,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D237)*(C237)","v":{"v":32,"d":"$32.00"}},{"$f":"VLOOKUP(G237,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F237)*(C237)","v":17.28}]
[234,"#500 WIRE POWER TERM",8,{"v":1,"d":"$1.00"},"E",0.63,"E",{"$f":"VLOOKUP(E238,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D238)*(C238)","v":{"v":8,"d":"$8.00"}},{"$f":"VLOOKUP(G238,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F238)*(C238)","v":5.04}]
[235,"#600 WIRE POWER TERM",54,{"v":1,"d":"$1.00"},"E",0.7,"E",{"$f":"VLOOKUP(E239,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D239)*(C239)","v":{"v":54,"d":"$54.00"}},{"$f":"VLOOKUP(G239,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F239)*(C239)","v":{"v":37.8,"d":"37.80"}}]
[236,"WIRE TERM UP To #10",288,{"v":1,"d":"$1.00"},"E",0.11,"E",{"$f":"VLOOKUP(E240,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D240)*(C240)","v":{"v":288,"d":"$288.00"}},{"$f":"VLOOKUP(G240,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F240)*(C240)","v":31.68}]
[237,"WIRE TERM #8 TO #1",6,{"v":1,"d":"$1.00"},"E",0.29,"E",{"$f":"VLOOKUP(E241,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D241)*(C241)","v":{"v":6,"d":"$6.00"}},{"$f":"VLOOKUP(G241,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F241)*(C241)","v":{"v":1.7399999999999998,"d":"1.74"}}]
[238,"Cat 5 Terms",126,{"v":0.5,"d":"$0.50"},"E",0.25,"E",{"$f":"VLOOKUP(E242,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D242)*(C242)","v":{"v":63,"d":"$63.00"}},{"$f":"VLOOKUP(G242,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F242)*(C242)","v":{"v":31.5,"d":"31.50"}}]
[239," INVERTER",1,{"v":0,"d":"$0.00"},"E",0.5,"E",{"$f":"VLOOKUP(E243,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D243)*(C243)","v":{"v":0,"d":"$0.00"}},{"$f":"VLOOKUP(G243,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F243)*(C243)","v":{"v":0.5,"d":"0.50"}}]
[240,"TRENCH (12\"x 3' DEEP)",60,{"v":0,"d":"$0.00"},"E",6,"C",{"$f":"VLOOKUP(E244,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D244)*(C244)","v":{"v":0,"d":"$0.00"}},{"$f":"VLOOKUP(G244,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F244)*(C244)","v":{"v":3.5999999999999996,"d":"3.60"}}]
[241,"TRENCH (36\"x 3' DEEP)",50,{"v":0,"d":"$0.00"},"E",6,"C",{"$f":"VLOOKUP(E245,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D245)*(C245)","v":{"v":0,"d":"$0.00"}},{"$f":"VLOOKUP(G245,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F245)*(C245)","v":{"v":3,"d":"3.00"}}]
[242,"BACKFILL (CUBIC YARD)",110,{"v":0,"d":"$0.00"},"E",5,"C",{"$f":"VLOOKUP(E246,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D246)*(C246)","v":{"v":0,"d":"$0.00"}},{"$f":"VLOOKUP(G246,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F246)*(C246)","v":{"v":5.5,"d":"5.50"}}]
[243,"1\" DIAM CORE 4\" THICK WALL",48,{"v":0,"d":"$0.00"},"E",1.5,"E",{"$f":"VLOOKUP(E247,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D247)*(C247)","v":{"v":0,"d":"$0.00"}},{"$f":"VLOOKUP(G247,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F247)*(C247)","v":{"v":72,"d":"72.00"}}]
[244,"2\" DIAM CORE 6\" THICK WALL",1,{"v":0,"d":"$0.00"},"E",1.5,"E",{"$f":"VLOOKUP(E248,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D248)*(C248)","v":{"v":0,"d":"$0.00"}},{"$f":"VLOOKUP(G248,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F248)*(C248)","v":{"v":1.5,"d":"1.50"}}]
[245,"Fire Alarm Instalation",1,{"v":0,"d":"$0.00"},"E",250,"E",{"$f":"VLOOKUP(E249,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D249)*(C249)","v":{"v":0,"d":"$0.00"}},{"$f":"VLOOKUP(G249,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F249)*(C249)","v":{"v":250,"d":"250.00"}}]
[246,{"$nulls":3},"E",null,"E",{"$f":"VLOOKUP(E250,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D250)*(C250)","v":{"v":0,"d":"$0.00"}},{"$f":"VLOOKUP(G250,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F250)*(C250)","v":{"v":0,"d":"0.00"}}]
[247,{"$nulls":3},"E",null,"E",{"$f":"VLOOKUP(E251,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D251)*(C251)","v":{"v":0,"d":"$0.00"}},{"$f":"VLOOKUP(G251,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F251)*(C251)","v":{"v":0,"d":"0.00"}}]
[248,{"$nulls":3},"E",null,"E",{"$f":"VLOOKUP(E252,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D252)*(C252)","v":{"v":0,"d":"$0.00"}},{"$f":"VLOOKUP(G252,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F252)*(C252)","v":{"v":0,"d":"0.00"}}]
[null,"Quoted Materials",{"$nulls":7},"Vendor"]
[1,"Lighting Quote (by Others)",null,null,"E",4,"E",{"$f":"VLOOKUP(E254,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D254)*(C254)","v":{"v":0,"d":"$0.00"}},{"$f":"VLOOKUP(G254,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F254)*(C254)","v":{"v":0,"d":"0.00"}}]
[2,"Gear Quote ",1,{"v":54100,"d":"$54,100.00"},"E",4,"E",{"$f":"VLOOKUP(E255,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D255)*(C255)","v":{"v":54100,"d":"$54,100.00"}},{"$f":"VLOOKUP(G255,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F255)*(C255)","v":{"v":4,"d":"4.00"}}]
[3,{"$nulls":3},"E",null,"E",{"$f":"VLOOKUP(E256,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(D256)*(C256)","v":{"v":0,"d":"$0.00"}},{"$f":"VLOOKUP(G256,'UNIT CODES'!$A$2:$B$5,2,FALSE)*(F256)*(C256)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},"Bulk Material",null,{"$f":"SUM(H5:H252)","v":{"v":124860.61046999997,"d":"$124,860.61"}},{"$f":"SUM(I5:I256)","v":{"v":7654.991700000003,"d":"7,654.99"}}]
[{"$nulls":5},"Markup",{"v":0.15,"d":"15%"},{"$f":"SUM(H257)*G258","v":{"v":18729.091570499993,"d":"$18,729.09"}},{"$f":"SUM(D266+D269)","v":{"v":8037.741285000004,"d":"8,037.74"}},"Job man-hours"]
[{"$nulls":5},"Quoted Material",null,{"$f":"SUM(H254:H256)","v":{"v":54100,"d":"$54,100.00"}},2,"Number of men on job"]
[{"$nulls":5},"Markup",{"v":0.1,"d":"10%"},{"$f":"SUM(H259)*G260","v":{"v":5410,"d":"$5,410.00"}},1,"number of trucks"]
[{"$nulls":5},"SUB Total",null,{"$f":"SUM(H257:H260)","v":{"v":203099.70204049995,"d":"$203,099.70"}},{"$f":"SUM(I258/I259/10)/I260","v":{"v":401.8870642500002,"d":"401.89"}},"Truck days"]
[{"$nulls":5},"Tax",{"v":0.09,"d":"9.0%"},{"$f":"SUM(G262*H261)","v":{"v":18278.973183644994,"d":"$18,278.97"}},0," Round trip Miles"]
[{"$nulls":5},"Total Material",null,{"$f":"SUM(H261:H262)","v":{"v":221378.67522414494,"d":"$221,378.68"}},{"v":2.5,"d":"$2.50"},"Estimated fuel Cost per gallon"]
[{"$nulls":8},12,"Estimated miles per gallon"]
[null,"Direct Labor",null,"Man Hours",null,"Rate",null,"Total",{"$f":"SUM(I262/I264)*I263*I261","v":{"v":0,"d":"$0.00"}},"Truck fuel Cost"]
[null,"Composite Labor Rate",null,{"$f":"SUM(I257)","v":{"v":7654.991700000003,"d":"7,654.99"}},null,{"v":34,"d":"$34.00"},null,{"$f":"SUM(F266*D266)","v":{"v":260269.7178000001,"d":"$260,269.72"}},null,"Suppliers & Subcontractors","Quote"]
[{"$nulls":8},"LIGHTING","Elliott Supply"]
[null,"Indirect Labor","%","% of MH",null,"Rate",null,"Total",null,"Midstate Supply"]
[null,"Project Manager",{"v":0.05,"d":"5%"},{"$f":"SUM(C269*I257)","v":{"v":382.7495850000002,"d":"382.75"}},null,{"v":45,"d":"$45.00"},null,{"$f":"SUM(F269*D269)","v":{"v":17223.731325000008,"d":"$17,223.73"}},null,"Teche Electric"]
[{"$nulls":8},"GEAR","Elliott Supply"]
[null,"Incidental Labor",null,"Man Hours",null,"Rate",null,"Total",null,"Midstate Supply"]
[null,"Travel Time",{"$nulls":3},{"v":34,"d":"$34.00"},null,{"$f":"SUM(F272*D272)","v":{"v":0,"d":"$0.00"}},null,"Teche Electric"]
[]
[null,"Sub Contractor",null,"Quote",null,null,"Markup","Total","Fire Alarm"]
[null,"Fire Alarm",null,{"v":3400,"d":"$3,400.00"},null,null,{"v":0.1,"d":"10%"},{"$f":"SUM(G275*D275)+D275","v":{"v":3740,"d":"$3,740.00"}}]
[null,"Voice Data",null,{"v":0,"d":"$0.00"},null,null,{"v":0.1,"d":"10%"},{"$f":"SUM(G276*D276)+D276","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":3},{"v":0,"d":"$0.00"},null,null,{"v":0.1,"d":"10%"},{"$f":"SUM(G277*D277)+D277","v":{"v":0,"d":"$0.00"}},"Voice Data"]
[{"$nulls":3},{"v":0,"d":"$0.00"},null,null,{"v":0.1,"d":"10%"},{"$f":"SUM(G278*D278)+D278","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":7},{"$f":"SUM(H275:H278)","v":{"v":3740,"d":"$3,740.00"}}]
[{"$nulls":8},"Acceptance"]
[null,"General Expenses","QTY",null,null,"Cost",null,"Total"]
[null,"Permit",1,null,null,{"v":1500,"d":"$1,500.00"},null,{"$f":"SUM(F282*C282)","v":{"v":1500,"d":"$1,500.00"}}]
[null,"Temporary Power",1,null,null,{"v":500,"d":"$500.00"},null,{"$f":"SUM(F283*C283)","v":{"v":500,"d":"$500.00"}},"Access"]
[null,"Site Gas",1,null,null,{"$f":"SUM(I265+I294)","v":{"v":0,"d":"$0.00"}},null,{"$f":"SUM(F284*C284)","v":{"v":0,"d":"$0.00"}}]
[null,"Rental Equipment Transportation ",0,null,null,{"v":200,"d":"$200.00"},null,{"$f":"SUM(F285*C285)","v":{"v":0,"d":"$0.00"}}]
[null,null,0,null,null,{"v":0,"d":"$0.00"},null,{"$f":"SUM(F286*C286)","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":5},"Total",null,{"$f":"SUM(H282:H286)","v":{"v":2000,"d":"$2,000.00"}}]
[]
[null,"Equipment","QTY","Cost",null,"Sub Total","%","Total"]
[null,"Excavator By The Week",2,{"v":690,"d":"$690.00"},null,{"$f":"SUM(C290*D290)","v":{"v":1380,"d":"$1,380.00"}},{"v":0.1,"d":"10%"},{"$f":"SUM(G290*F290)+F290","v":{"v":1518,"d":"$1,518.00"}},{"v":0,"d":"$0.00"},"Fuel"]
[null,"Packer By The Week",2,{"v":300,"d":"$300.00"},null,{"$f":"SUM(C291*D291)","v":{"v":600,"d":"$600.00"}},{"v":0.1,"d":"10%"},{"$f":"SUM(G291*F291)+F291","v":{"v":660,"d":"$660.00"}},{"v":0,"d":"$0.00"},"Fuel"]
[null,"Forklift By The",{"$nulls":3},{"$f":"SUM(C292*D292)","v":{"v":0,"d":"$0.00"}},{"v":0.1,"d":"10%"},{"$f":"SUM(G292*F292)+F292","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},"Fuel"]
[null,"Man lift By The",{"$nulls":3},{"$f":"SUM(C293*D293)","v":{"v":0,"d":"$0.00"}},{"v":0.1,"d":"10%"},{"$f":"SUM(G293*F293)+F293","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},"Fuel"]
[{"$nulls":7},{"$f":"SUM(H290:H293)","v":{"v":2178,"d":"$2,178.00"}},{"$f":"SUM(I290:I293)","v":{"v":0,"d":"$0.00"}},"Estimated Equipment Fuel cost"]
[]
[]
[null,"Total Material",{"$nulls":5},{"$f":"SUM(H263)","v":{"v":221378.67522414494,"d":"$221,378.68"}}]
[null,"Direct Labor",{"$nulls":5},{"$f":"SUM(H266)","v":{"v":260269.7178000001,"d":"$260,269.72"}}]
[null,"Indirect Labor",{"$nulls":5},{"$f":"SUM(H269)","v":{"v":17223.731325000008,"d":"$17,223.73"}}]
[null,"Incidental Labor",{"$nulls":5},{"$f":"SUM(H272)","v":{"v":0,"d":"$0.00"}}]
[null,"Sub Contractor",{"$nulls":5},{"$f":"SUM(H279)","v":{"v":3740,"d":"$3,740.00"}}]
[null,"General Expenses",{"$nulls":5},{"$f":"SUM(H287)","v":{"v":2000,"d":"$2,000.00"}}]
[null,"Equipment",{"$nulls":5},{"$f":"SUM(H294)","v":{"v":2178,"d":"$2,178.00"}}]
[null,"Estimate"]
[{"$nulls":5},"Total Job",null,{"$f":"SUM(H297:H304)","v":{"v":506790.12434914504,"d":"$506,790.12"}}]
[]
[1,"Light Fixtures By Others. We Supply Emergency Fixtures. We supply Lighting Controls Limited to standard switches, dimmers, and Occ sensors. No Electronic control systems.   "]
[2,"Fire Alarm was quoted parts only Contractor must be lisceed to to do the instaltion labor that is included. 250 Hrs was allowed for this work. Voice data equipment and instalation is not inclded in this estimate "]
[3,"Alternate to Deduct work at trash shute. Deduct $200.00   "]
[4,"Unit Price for Air Switch for GD. ADD $100.00 Per Unit"]

{"sheet":"UNIT CODES","index":1,"n_rows":4,"n_cols":2,"rows_kept":4}
["UNIT CODES","VALUES"]
["E",1]
["C",0.01]
["M",1E-3]

{"sheet":"RENTALS","index":2,"n_rows":15,"n_cols":5,"rows_kept":15}
[]
[null,"RENTALS"]
[null,null,"Daily ","Weekly","Monthly "]
[null,"Excavators",{"v":230,"d":"$230.00"},{"v":690,"d":"$690.00"},{"v":1980,"d":"$1,980.00"}]
[null,"Trencher",{"v":155,"d":"$155.00"},{"v":620,"d":"$620.00"},{"v":1740,"d":"$1,740.00"}]
[null,"Bobcat",{"v":180,"d":"$180.00"},{"v":540,"d":"$540.00"},{"v":1620,"d":"$1,620.00"}]
[null,"Auger Attachment",{"v":100,"d":"$100.00"},{"v":300,"d":"$300.00"},{"v":900,"d":"$900.00"}]
[null,"Packer",{"v":75,"d":"$75.00"},{"v":300,"d":"$300.00"},{"v":900,"d":"$900.00"}]
[null,"Slab Saw ",{"v":75,"d":"$75.00"},{"v":300,"d":"$300.00"},{"v":900,"d":"$900.00"}]
[null,"Breaker",{"v":120,"d":"$120.00"},{"v":480,"d":"$480.00"},{"v":1440,"d":"$1,440.00"}]
[null,"Core Drill",{"v":80,"d":"$80.00"},{"v":320,"d":"$320.00"}]
[null,"Sizzor Narrow",{"v":135,"d":"$135.00"},{"v":405,"d":"$405.00"},{"v":1125,"d":"$1,125.00"}]
[null,"Sizzor All Terain",{"v":250,"d":"$250.00"},{"v":750,"d":"$750.00"},{"v":2000,"d":"$2,000.00"}]
[null,"40' Manlift",{"v":250,"d":"$250.00"},{"v":750,"d":"$750.00"},{"v":2115,"d":"$2,115.00"}]
[null,"Reach Forklift",{"v":360,"d":"$360.00"},{"v":1080,"d":"$1,080.00"},{"v":3150,"d":"$3,150.00"}]