Pricing Worksheet.xlsx

XLSX spreadsheet 2 MB Posted

Attached to
FP ON-CALL TRAFFIC SIGNAL
Solicitation number
5400028143
Issued by
Richland County, South Carolina

About this file

I apologize, but the file you provided appears to be empty or incomplete. The filename is "Pricing Worksheet.xlsx", but there is no actual content within the file brackets. Without the specific details of the pricing worksheet, I cannot generate a meaningful summary. To provide an accurate analysis, I would need the actual content of the Excel spreadsheet, including pricing information, line items, quantities, unit prices, or other relevant contract details.

View the file

Other files

File Type Posted
Amend 3 New Spreadhseet.docx DOCX document
Revised Award Date.docx DOCX document
Amend #2 5400028143.docx DOCX document
Award Extension.docx DOCX document
Pricing Worksheet V3.xlsx XLSX spreadsheet
Amendment #1.docx DOCX document
Solicitation Document.pdf PDF

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Users

New UserAAAAA98765OKExiprationDate
Bener AmadoAmado563831/1/12
Stephanie AmellAmell56576
Mark AnthonyAnthony59504Now
Mark AttawayAttaway623203/19/25 14:36
Sid BacchusBacchus57042
Mike BagleyBagley34393
Michael BarbeeBarbee62948
Julie BarkerBarker60022
Al BarwickBarwick33373
Clint BeaverBeaver59194
Rob BedenbaughBedenbaugh54976
William C. BerryBerryWC19298
William K. BerryBerryWK53190
Kimberley BishopBishop57586
John BlackBlack55226
Arnold BlandingBlanding59859
Ronnie BlevinsBlevins49690
Barry BowersBowers46335
Joe BozardBozard49290
Jeremiah BradleyBradley44457
Timothy BrittBritt59679
Oliver BrownBrown62424
Daniel BurtonBurton62788
Shannon CallahanCallahan66716
Timothy CallenbackCallenback47680
Melissa CampbellCampbell50023
Bobby CassellCassell13363
John CobbCobb44371
David CookCookD53753
Joseph CookCookJ61729
Tony CooperCooper56550
Wayne CorleyCorley40415
Tucker CreedCreed65648
Rebecca CreightonCreighton46994
Perry CrockerCrocker46237
Efrem DantzlerDantzler50186
Scott DavenportDavenport39183
Brian DavisonDavison54836
Johnson DeanDean47055
Mark DeZurickDeZurick44489
Robert DickinsonDickinson52343
Brent DillonDillon55445
Brian DixDix63307
Tom DoddsDodds41154
Kelley DonkleDonkle56666
Kevin DuboseDubose62911
Kenneth EargleEargleK43725
Ramona EckroteEckrote58393
Timothy EdwardsEdwards41004
Charles EleazerEleazer48097
Wilson ElginElgin54470
Stephen EllisEllis62679
Tommy ElrodElrod46505
Mark EthridgeEthridge60250
Tony FallawFallaw54108
Cyndy Farr-StockmanFarr-Stockman43188
Keith FaulkFaulk49158
Wayne FeasterFeaster39978
Lee FloydFloyd44362
Simon ForbesForbes33437
Heather FordFord57187
Jim FrickFrick27748
Cary FrickFrick44226
Keith FrickFrick48034
Richard GadsdenGadsden55528
Dennis GarberGarber54473
Tim GemenskyGemensky63900
Rudolph GeraldGerald47085
Jeff GilmoreGilmore49272
Christopher GossettGossett52283
Christine GrahamGraham63407
Troy GreenGreen62580
Benjamin GreerGreer60635
Reuben GuyGuy54697
Christy HallHallC56298
Stephen HallHallS55061
Rob HamzyHamzy56667
Mike HannahHannah58452
John HardenHarden67111
Kevin HarringtonHarrington64537
Jennifer HastingHasting59217
Brian HeapeHeape64975
David HebertHebert54055
Timothy HendersonHenderson55331
James HendricksHendricks42591
Angela HicksHicks61700
William HinsonHinson50218
Andrew HoldenHolden44573
Curtis HooksHooks44918
Rob HoyleHoyle51558
Michael HumphriesHumphries64614
John HuskinsHuskins45828
Ron HutsonHutson36685
Rogers IdeozuIdeozu45176
Robbie IsgettIsgett56749
Melissa JacksonJacksonM62632
Yates JacksonJacksonY55836
Amy JamesJamesA60031
Mike JamesJamesM45276
Jim JohnannemannJohnannemann57734
Andy JohnsonJohnson51383
Charles JohnstonJohnstonC60123
Jason JohnstonJohnstonJ60132
Charles JonesJones45295
Bryan JonesJones51997
Adam JordanJordanA58009
Chris JordanJordanC53513
Jeff JordanJordanJ55041
Scott KeanKean65562
Jamie KendallKendall54471
D. KennerleyKennerly49145
Brian KeysKeys47053
Christopher KnightKnight56654
Terry KoonKoon43680
Patrick KooneKoone62719
Chris LacyLacy62969
Brad LathamLatham63493
Herbert LattenLatten55868
Bill LeeLee58260
Mark LesterLester49455
Tom LeyenLeyen61985
Vickie LindseyLindsey54489
Harriett LominickLominick66141
Dawn LonerLoner45209
Billy LybrandLybrand58431
Alan MatienzoMatienzo56328
John McCarterMcCarter52006
Kenneth McCrackenMcCracken46075
Casey McGradyMcGrady63180
Patrick McKenzieMcKenzie57114
Ben McKinneyMckinney65467
Kevin McLaughlinMcLaughlin51389
Phillip McMillanMcMillan29846
Mike MeetzeMeetze41870
Tony MelletteMellette44186
Michell MettsMetts50611
Ed MillerMillerE61282
J. P MillerMillerJ56463
Ryan MillerMillerR55923
George MorrowMorrow16829
Darlene NanceNance47111
Lee NeighborsNeighbors44050
Binh NguyenNguyen57693
Jimmy NoffzNoffz25939
Gregory OswaldOswald58707
Todd OswaldOswald58707
Barry PalmPalm35603
Shannon ParrisParris58138
Dipak PatelPatel49806
Glenn PatersonPaterson50237
Rob PerryPerry60154
Machael PetersonPeterson55240
Susan PhillipsPhillips54818
Jerry PhippsPhipps47265
H. PickeringPickering44041
David PilchPilch49046
Michael PopielarzPopielarz49451
Darrell PorterfieldPorterfield41392
James PorthPorth47459
James PostonPoston48729
Robert PrattPratt37314
Leah QuattlebaumQuattlebaum59126
Sherry QuinnQuinn62909
Pierre RambhareseRambharese62155
Mike RectorRector63813
Walter ReedReed54472
James ReeseReese42032
Brent RewisRewis60432
Brad ReynoldsReynolds62343
Clayton RichterRichter61611
Keith RiddleRiddle62396
Greg RikardRikard51961
Scott RilesRiles57526
David RisterRister55004
David RisterRister63089
Ronnie RobertsRoberts36895
Nathalia RodreguezRodreguez62856
David RogersRogers56846
Bill RussRuss36405
Phillip SandelSandel65972
Mike SawyerSawyer55861
Treasure ScarboroughScarborough46721
Clint ScovilleScoville50851
Jimmy SeaseSease33283
Cliff SellersSellers62117
Scott ShafferShaffer60388
Matthew ShealyShealy62057
Huley ShumpertShumpert46980
Art SingleySingley40479
Bryan SmithSmithB64595
Cranel SmithSmithC53469
Jason StillwellStillwell60296
Joe SturmSturm66406
Thomas TankTank61998
Jeffery TerryTerry62337
Patricia ThewThew55927
Tony ThompsonThompson65303
Jay ThompsonThompson67227
Jason ThompsonThompsonJa57961
John ThompsonThompsonJo64232
Lee TsiantisTsiantis52000
Dustin TurnerTurner53979
Kevin UlmerUlmer45286
Nathan UmbergerUmberger66893
Sherri WahdanWahdan56847
Nick WaitesWaites59930
Ann WardWard62484
Alex WeaverWeaver61185
K. WebberWebber54089
Bruce WellsWells63514
Shannon WelshWelsh55877
Brandon WigginsWiggins66817
Jeffery WilkesWilkes66693
Jeffery WilkesWilkes66693
Pam WilliamsWillaims61967
Loraine WilliamsWilliams57055
Gregory WilliamsWilliams60988
Randy WilliamsonWilliamson49129
Elisa WillisWillis66992
Kenneth WilsonWilson46689
Jo Ann WoodrumWoodrum46496
Will YarboroughYarborough56286
Randy YoungYoung55875

Carol's Quantities

NEW LINE ITEMPAY ITEMUNITESTIMATED QUANTITYMAX COSTDESCRIPTION, SPECIFICATION REFERENCE
103.1 MOBILIZATION, 103.2 MOBILIZATION OF MATERIAL
11031010EA40$ 200.00$ 8,000.00MOBILIZATION
29610021EA80$ 173.89$ 13,911.20MOBILIZATION OF MATERIAL PER WORK ORDER, 1-100 MILES BETWEEN LOCATION OF MATERIAL AND WORKSITE
39610022EA80$ 289.82$ 23,185.60MOBILIZATION OF MATERIAL PER WORK ORDER, 101-250 MILES BETWEEN LOCATION OF MATERIAL AND WORKSITE
49610023EA80$ 405.75$ 32,460.00MOBILIZATION OF MATERIAL PER WORK ORDER, 251+ MILES BETWEEN LOCATION OF MATERIAL AND WORKSITE
TRAFFIC CONTROL$ - 0
51071100EA400TBDTRAFFIC CONTROL PRIMARY ROAD PER WORK ORDER (10% OF COST OF WORK ORDER)
6-EA200TBDTRAFFIC CONTROL PRIMARY ROAD PER WORK ORDER (NIGHT WORK) (14% OF COST OF WORK ORDER)
675.1 ELECTRICAL CONDUIT$ - 0
76750181LF3,000$ 10.00$ 30,000.00FURNISH & INSTALL 1" ALUMINUM CONDUIT
86750182*LF3,000$ 12.00$ 36,000.00FURNISH & INSTALL 2" ALUMINUM CONDUIT
96750005LF3,000$ 12.52$ 37,560.00FURNISH & INSTALL 1.0" GALVANIZED RIGID CONDUIT
106750015LF2,000$ 15.02$ 30,040.00FURNISH & INSTALL 2.0" GALVANIZED RIGID CONDUIT
116750025LF2,000$ 18.79$ 37,580.00FURNISH & INSTALL 3.0" GALVANIZED RIGID CONDUIT
126750085LF1,000$ 20.81$ 20,810.00FURNISH & INSTALL 2.0" GALV. RIGID CONDUIT (BORED AND JACKED)
136750090LF1,000$ 20.00$ 20,000.00FURNISH & INSTALL 3.0" GALV. RIGID CONDUIT (BORED AND JACKED)
146750175LF1,000$ 8.00$ 8,000.00FURNISH & INSTALL 1.0" FLEX.GALV.STEEL CONDUIT (WEATHER TIGHT)
156750179LF1,000$ 10.00$ 10,000.00FURNISH & INSTALL 2.0" FLEX.GALV.STEEL CONDUIT (WEATHER TIGHT)
166750262LF300$ 25.68$ 7,704.00FURNISH & INSTALL ENCASED CONDUIT (2-2" PVC, SCHEDULE 40)
176750263LF300$ 31.10$ 9,330.00FURNISH & INSTALL ENCASED CONDUIT (3-2" PVC, SCHEDULE 40)
186750275LF2,400$ 6.47$ 15,528.00FURNISH & INSTALL 1.0" SCHEDULE 80 PVC CONDUIT
196750278LF8,000$ 7.30$ 58,400.00FURNISH & INSTALL 2.0" SCHEDULE 80 PVC CONDUIT
20675027CLF8,000$ 13.16$ 105,280.00FURNISH & INSTALL 3.0" SCHEDULE 80 PVC CONDUIT
21675027SLF3,000$ 9.00$ 27,000.00FURNISH & INSTALL 2.0" SCHEDULE 80 PVC CONDUIT (DIRECTION.BORED)
22675027VLF3,000$ 15.00$ 45,000.00FURNISH & INSTALL 3.0" SCHEDULE 80 PVC CONDUIT(DIRECTION.BORED)
23675027ZLF3,000$ 3.50$ 10,500.00FURNISH ADDITIONAL CONDUIT WITHIN DIRECTIONAL BORE
677.1 ELECTRICAL CABLE$ - 0
246770388LF24,000$ 1.57$ 37,680.00FURNISH & INSTALL NO. 14 COPPER WIRE, 4 CONDUCTOR (BLACK)
256770389LF50,000$ 1.68$ 84,000.00FURNISH & INSTALL NO. 14 COPPER WIRE, 4 CONDUCTOR (GRAY)
266770393LF64,000$ 2.19$ 140,160.00FURNISH & INSTALL NO. 14 COPPER WIRE, 8 CONDUCTOR (BLACK)
276770394LF32,000$ 2.26$ 72,320.00FURNISH & INSTALL NO. 14 COPPER WIRE, 8 CONDUCTOR (GRAY)
677.2 COMMUNICATIONS CABLE$ - 0
286770453LF1,000$ 1.26$ 1,260.00FURNISH AND INSTALL ELECTRICAL COMMUNICATIONS CABLE - OVERHEAD - 12 PAIR
296770463LF7,000$ 1.26$ 8,820.00FURNISH AND INSTALL ELECTRICAL COMMUNICATIONS CABLE - UNDERGROUND - 12 PAIR
677.3,4,5,6 FIBER OPTIC ITEMS$ - 0
306770470LF150,000$ 2.00$ 300,000.00FURNISH AND INSTALL FIBER OPTIC CABLE-SINGLE MODE
31677046DLF25000$ 2.45$ 61,250.00FURNISH & INSTALL SELF SUPPORTING FIBER OPTIC CABLE ‐ SINGLE MODE
326770476EA20$ 1,250.00$ 25,000.00FURNISH AND INSTALL FIBER OPTIC INTERCONNECT CENTER
336770482EA20$ 1,500.00$ 30,000.00FURNISH AND INSTALL FIBER OPTIC MODEM
346888080LF75,000$ 1.25$ 93,750.00INSTALL FIBER OPTIC CABLE (SINGLE MODE)
356888091EA20$ 104.33$ 2,086.60INSTALL FIBER OPTIC MODEM
366888092EA20$ 750.00$ 15,000.00INSTALL FIBER OPTIC INTERCONNECT CENTER
376888082EA750$ 1,507.06$ 1,130,295.00FURNISH AND INSTALL FACTORY TERMINATED PATCH PANEL
386888093EA50$ 900.00$ 45,000.00INSTALL FACTORY TERMINATED PATCH PANEL
396770486EA500$ 1,200.00$ 600,000.00FIBER OPTIC REPAIR SPLICE OH/UG
406886030LS10$ 800.00$ 8,000.00TRAINING BEING FIBER OPTIC
41-EA1200$ 25.00$ 30,000.00FIBER OPTIC FUSION SPLICING < 24 SPLICES
42-EA1000$ 18.00$ 18,000.00FIBER OPTIC FUSION SPLICING > 24 SPLICES
43-EA100$ 12.00$ 1,200.00FURNISH & INSTALL FIBER OPTIC JUMPER - SINGLE MODE, ST TO ST, 2 METER
44-EA250$ 12.00$ 3,000.00FURNISH & INSTALL FIBER OPTIC JUMPER - SINGLE MODE, ST TO LC, 2 METER
45-EA150$ 10.00$ 1,500.00LIGHT SOURCE POWER METER TESTING
46-EA100$ 5.50$ 550.00OPTICAL TIME DOMAIN REFLECTOMETER TESTING < 24 FIBERS
677.7 SPREAD SPECTRUM RADIO ASSEMBLY$ - 0
476886072EA150$ 180.00$ 27,000.00INSTALL RADIO ASSEMBLY WITH ANTENNA
678.1 DETECTOR LOOP$ - 0
486770413LF80,000$ 0.42$ 33,600.00FURNISH AND INSTALL NO. 14 COPPER WIRE, 1-CONDUCTOR FOR LOOP WIRE
496780495LF50,000$ 6.10$ 305,000.00SAWCUT FOR LOOP DETECTOR
50a677049CEA200$ 8,182.00$ 1,636,400.00FURNISH WIRELESS DETECTION SYSTEM W/O SENSORS (INC SETBACK DETECTION CAPABILITY FOR 2 DIRECTIONS
50b677049DEA100$ 9,744.50$ 974,450.00FURNISH WIRELESS DETECTION SYSTEM W/O SENSORS (INC SETBACK DETECTION CAPABILITY FOR 3 DIRECTIONS
50c677049EEA100$ 10,887.00$ 1,088,700.00FURNISH WIRELESS DETECTION SYSTEM W/O SENSORS (INC SETBACK DETECTION CAPABILITY FOR 4 DIRECTIONS
50d677049FEA200$ 5,477.00$ 1,095,400.00FURNISH WIRELESS DETECTION SYSTEM W/O SENSORS (w/o SETBACK DETECTION CAPABILITY)
50e677049GHR300$ 150.00$ 45,000.00FURNISH MANUFACTURER TECHNICIAN ASSISTANCE
506770494EA2500$ 595.00$ 1,487,500.00FURNISH & INSTALL FLUSH MOUNTED WIRELESS SENSOR
516887961EA100$ 125.00$ 12,500.00INSTALL FLUSH MOUNTED WIRELESS SENSOR
526887962EA25$ 75.00$ 1,875.00REMOVE FLUSH MOUNTED WIRELESS SENSOR
546887963EA15$ 750.00$ 11,250.00INSTALL WIRELESS REPEATER (2EA)/ANTENNA(1EA)
566887964EA15$ 450.00$ 6,750.00INSTALL RECEIVER
680.1 ELECTRIC SERVICE$ - 0
706800499EA120$ 626.26$ 75,151.20FURNISH AND INSTALL ELECTRICAL SERVICE FOR TRAFFIC SIGNAL (COMPLETE WITH RISER, METER, AND DISCONNECT SWITCH)
716770318LF6,000$ 1.88$ 11,280.00FURNISH AND INSTALL # 6 TRIPLEX ALUMINUM SERVICE WIRE
680.2 SPLICE BOX/JUNCTION BOX$ - 0
726800508EA25$ 220.00$ 5,500.00FURNISH AND INSTALL 12"W x 12"L x 12"D ELECTRICAL FLUSH UNDERGROUND ENCLOSURE - MinSBx - (STR.POLY.CONC) HD
736800518EA100$ 344.44$ 34,444.00FURNISH AND INSTALL 13"X24"X18"D.ELEC.FLUSH UNDGRD.ENCLOSURE-(STR.POLY.CONC.)HD
74680052CEA25$ 375.77$ 9,394.25FURNISH AND INSTALL 17"X30"X26"D.ELEC.FLUSH UNDGRD.ENCLOSURE-(STR.POLY.CONC.)HD
682.1,2 WOOD POLE, BACK GUYS$ - 0
756825020EA100$ 535.00$ 53,500.00FURNISH AND INSTALL 35’ WOOD POLE-CLASS II-CCA TREATED(0.60)
766825021EA10$ 800.00$ 8,000.00FURNISH AND INSTALL 40’ WOOD POLE-CLASS II-CCA TREATED(0.60)
776825045EA440$ 225.46$ 99,202.40FURNISH AND INSTALL 3/8" BACKGUY FOR WOOD POLE
786825046EA60$ 250.51$ 15,030.60FURNISH AND INSTALL 3/8" SIDEWALK GUY
796825047EA40$ 156.58$ 6,263.20FURNISH AND INSTALL 3/8" AERIAL GUY
80-EA150$ 375.77$ 56,365.50FURNISH AND INSTALL 35’ WOOD POLE- CLASS III- CCA TREATED
81-EA20$ 438.38$ 8,767.60FURNISH AND INSTALL 40’ WOOD POLE- CLASS III- CCA TREATED
682.3 STEEL CABLE$ - 0
826825090LF8,000$ 2.83$ 22,640.00FURNISH AND INSTALL 1/4" GALVANIZED STEEL CABLE
836825092LF64,000$ 3.75$ 240,000.00FURNISH AND INSTALL 3/8" GALVANIZED STEEL CABLE
682.4 PEDESTRIAN POLE AND BASE$ - 0
846825480EA50$ 295.00$ 14,750.00FURNISH & INSTALL 4' BREAK‐AWAY ALUMINUM PEDESTAL POLE AND BASE
856825484EA100$ 594.25$ 59,425.00FURNISH AND INSTALL 10' BREAK-AWAY ALUMINUM PEDESTAL POLE AND BASE
866888190EA30$ 250.00$ 7,500.00INSTALL 10’ PEDESTRIAN PEDESTAL POLE AND BASE
876825486EA35$ 200.00$ 7,000.00FURNISH & INSTALL ALUMINUM PEDESTAL POLE CONCRETE FOUNDATION
886888192EA25$ 50.00$ 1,250.00POWDERCOATING OPTION FOR 4' ALUMINUM PEDESTAL POLE
896888194EA25$ 75.00$ 1,875.00POWDERCOATING OPTION FOR 10' ALUMINUM PEDESTAL POLE
686.1 LED MODULES AND/OR POLYCARBONATE VEHICLE SIGNAL HEAD$ - 0
906865710EA300$ 871.10$ 261,330.00FURNISH AND INSTALL 12" 1-WAY-5 SECTION(R.Y.YA.G.GA)VEHICLE TRAFFIC SIGNAL
916865720EA150$ 684.49$ 102,673.50FURNISH AND INSTALL 12" 1-WAY-4 SECTION(RA+RA/YA.GA)VEHICHLE TRAFFIC SIGNAL
926865721EA150$ 695.46$ 104,319.00FURNISH AND INSTALL 12" 1-WAY-4 SECTION(R.Y.G.GA)VEHICLE TRAFFIC SIGNAL
936865731EA800$ 568.93$ 455,144.00FURNISH AND INSTALL 12" 1-WAY-3 SECTION(R.Y.G.)VEHICLE TRAFFIC SIGNAL
946865733EA150$ 528.68$ 79,302.00FURNISH AND INSTALL 12" 1-WAY-3 SECTION(RA.YA.GA.)VEHICLE TRAFFIC SIGNAL
956865734EA25$ 568.93$ 14,223.25FURNISH AND INSTALL 1 WAY -3 SECTION (R(12").Y(12").Y(8"))VEHICLE TRAFFIC SIGNAL
966865735EA25$ 679.95$ 16,998.75FURNISH AND INSTALL 12" 4-WAY-1 SECT.(R.Y.R.Y.)CLUST. MOUNT CAUTION HEAD
976865736EA50$ 205.00$ 10,250.00FURNISH AND INSTALL 12" 1-WAY-1 SECTION(RED)VEHICLE TRAFFIC SIGNAL
986865737EA50$ 205.00$ 10,250.00FURNISH AND INSTALL 12" 1-WAY-1 SECTION(YELLOW)VEHICLE TRAFFIC SIGNAL
996887900EA100$ 180.00$ 18,000.00INSTALL 12" 1-WAY-5 SECTION(R.Y.YA.G.GA)VEHICLE TRAFFIC SIGNAL
1006887901EA150$ 180.00$ 27,000.00INSTALL 1 WAY-4 SECTION (RA+RA.YA.GA) VEHICLE TRAFFIC SIGNAL
1016887902EA150$ 180.00$ 27,000.00INSTALL 1 WAY-4 SECTION (R.Y.G.GA) VEHICLE TRAFFIC SIGNAL
1026887903EA150$ 180.00$ 27,000.00INSTALL 1 WAY-3 SECTION (RA.YA.GA) VEHICLE TRAFFIC SIGNAL
1036887904EA800$ 180.00$ 144,000.00INSTALL 1 WAY-3 SECTION (R.Y.G) VEHICLE TRAFFIC SIGNAL
1046887905EA25$ 180.00$ 4,500.00INSTALL 1 WAY-1 SECTION (RA) VEHICLE TRAFFIC SIGNAL – (PER APPROACH)
1056887906EA25$ 180.00$ 4,500.00INSTALL 12" 1-WAY-1 SECTION (YA) VEHICLE TRAFFIC SIGNAL – (PER APPROACH)
1066887907EA25$ 180.00$ 4,500.00INSTALL 12" 1-WAY-1 SECTION (GA) VEHICLE TRAFFIC SIGNAL – (PER APPROACH)
1076887908EA25$ 180.00$ 4,500.00INSTALL 12" 1-WAY-1 SECTION (RED) VEHICLE TRAFFIC SIGNAL – (PER APPROACH)
1086887909EA25$ 180.00$ 4,500.00INSTALL 12" 1-WAY-1 SECTION (YELLOW) VEHICLE TRAFFIC SIGNAL – (PER APPROACH)
1096887910EA25$ 180.00$ 4,500.00INSTALL 1 WAY-1 SECTION (GREEN) VEHICLE TRAFFIC SIGNAL – (PER APPROACH)
1106887911EA10$ 250.51$ 2,505.10INSTALL 4 WAY-1 SECTION (R.Y.R.Y) CLUSTER MOUNT CAUTION HEAD
1116887912EA25$ 180.00$ 4,500.00INSTALL 1 WAY-3 SECT (R(12”).Y(12”).Y(8”)) VEHICLE TRAFFIC SIGNAL
1126887920EA1,500$ 40.57$ 60,855.00INSTALL LED MODULE
1136887930EA500$ 45.00$ 22,500.00INSTALL BACKPLATE W/ RETROREFL.BORDER FOR TRAFF. SIG.
1146865834EA1000$ 125.00$ 125,000.00FURNISH AND INSTALL BACKPLATE W/ RETROREFL.BORDERS FOR TRAFF. SIG.
1156865722EA150$ 684.49$ 102,673.50F&I - 12" 1-WAY-4 SECTION(RA.YA.YAF.GA)VEH TRAFFIC SIGNAL
1166887899EA150$ 180.00$ 27,000.00INSTALL 12" 1-WAY-4 SECTION(RA.YA.YAF.GA)VEHICLE TRAFF SIG
1176865723EA150$ 568.93$ 85,339.50F&I - 12" 1-WAY-3 SECTION(RA.YA.YAF)VEH TRAFFIC SIGNAL
1186887898EA150$ 180.00$ 27,000.00INSTALL 12" 1-WAY-3 SECTION(RA.YA.YAF)VEH TRAFFIC SIGNAL
686.3 PEDESTRIAN SIGNAL HEAD$ - 0
1196865783EA200$ 545.00$ 109,000.00FURNISH AND INSTALL 1-WAY-1SECT.(COUNTDOWN HAND/MAN EMBLEM)PED.SIG.HEAD
1206865788EA150$ 210.00$ 31,500.00FURNISH AND INSTALL PEDESTRIAN LED MODULE
121686578735$ 110.00$ 3,850.00FURNISH & INSTALL VISOR WITH ATTACHMENT SCREWS
1226887926EA15$ 30.00$ 450.00INSTALL VISOR WITH ATTACHMENT SCREWS
1236887925EA150$ 30.00$ 4,500.00INSTALL PEDESTRIAN LED MODULE – EACH
1246888320EA120$ 115.50$ 13,860.00INSTALL PEDESTRIAN SIGNAL HEAD
1256865840EA75$ 100.00$ 7,500.00FURNISH & INSTALL PEDESTRIAN TRAF. SIGNAL HEAD MOUNTING ASSEMBLY FOR POST TOP
1266865841EA75$ 85.00$ 6,375.00FURNISH & INSTALL PEDESTRIAN TRAF. SIGNAL HEAD MOUNTING ASSEMBLY FOR SIDE POLE
1276865842EA75$ 135.00$ 10,125.00FURNISH & INSTALL PED. TRAF. SIGNAL HEAD MOUNT. ASSEMBLY FOR DUAL POST TOP
1286865782EA75$ 500.00$ 37,500.00FURNISH & INSTALL 1‐WAY‐1SECT. PEDESTRIAN SIGNAL HEAD W/ HAND/MAN LED MODULE AND CLAMSHELL MOUNT FOR SIDE POLE (LEFT
1296865783EA75$ 515.00$ 38,625.00FURNISH & INSTALL 1‐WAY‐1SECT. PEDESTRIAN SIGNAL HEAD W/ HAND/MAN LED MODULE AND CLAMSHELL MOUNT FOR SIDE POLE (RIGHT)
1306865784EA75$ 575.00$ 43,125.00FURNISH & INSTALL 1‐WAY‐1SECT. PEDESTRIAN SIGNAL HEAD W/ HAND/MAN COUNTDOWN LED MODULE AND CLAMSHELL MOUNT FOR SIDE POLE (LEFT)
1316865785EA75$ 590.00$ 44,250.00FURNISH & INSTALL 1‐WAY‐1SECT. PEDESTRIAN SIGNAL HEAD W/ HAND/MAN COUNTDOWN LED MODULE AND CLAMSHELL MOUNT FOR SIDE POLE (RIGHT)
686.4 PEDESTRIAN PUSH BUTTON STATION ASSEMBLY W/ SIGN$ - 0
1326865791EA200$ 224.80$ 44,960.00FURNISH AND INSTALL PEDESTRIAN PUSH BUTTON STATION ASSEMBLY AND SIGN (R-10-3E)
1336888325EA240$ 50.00$ 12,000.00INSTALL PEDESTRIAN PUSH BUTTON STATION ASSEMBLY AND SIGN
1346865793EA75$ 125.00$ 9,375.00FURNISH & INSTALL PEDESTRIAN PUSH BUTTON MICROSWITCH TYPE STATION ASSEMBLY (9"x12") AND SIGN (R-10-3E)
1356865794EA75$ 155.00$ 11,625.00FURNISH & INSTALL PEDESTRIAN PUSH BUTTON MICROSWITCH TYPE STATION ASSEMBLY (9"x15") AND SIGN (R-10-3E)
1366865795EA75$ 100.00$ 7,500.00FURNISH & INSTALL PEDESTRIAN PUSH BUTTON MICROSWITCH TYPE
1376865796EA200$ 165.00$ 33,000.00FURNISH & INSTALL PEDESTRIAN PUSH BUTTON SOLID STATE WITH LIGHT AND TONE STATION ASSEMBLY (9"x12") AND SIGN (R-10-3E)
1386865797EA200$ 175.00$ 35,000.00FURNISH & INSTALL PEDESTRIAN PUSH BUTTON SOLID STATE WITH LIGHT AND TONE STATION ASSEMBLY (9"x15") AND SIGN (R-10-3E)
1396865798EA150$ 120.00$ 18,000.00FURNISH & INSTALL PEDESTRIAN PUSH BUTTON SOLID STATE WITH LIGHT AND TONE
686.5 SYMBOLIC LED BLANKOUT SIGN$ - 0
1406865820EA25$ 2,500.00$ 62,500.00FURNISH & INSTALL NO RIGHT/LEFT TURN SYMBOLIC LED BLANKOUT SIGN W/ SPAN WIRE MOUNTING
1416887928EA10$ 219.20$ 2,192.00INSTALL NO RIGHT/LEFT TURN SYMBOLIC LED BLANKOUT SIGN W/ SPAN WIRE MOUNTING
1426865821EA18$ 740.00$ 13,320.00FURNISH & INSTALL NO RIGHT/LEFT TURN SYMBOLIC LED MODULE EA
1436887927EA15$ 40.00$ 600.00INSTALL NO RIGHT/LEFT TURN SYMBOLIC LED MODULE
688.1 REMOVAL SALVAGE AND DISPOSAL OF EQUIPMENT AND MATERIALS$ - 0
1446885982EA150$ 500.00$ 75,000.00REMOVE FOUNDATION FOR STEEL STRAIN POLE – 18” BELOW GRADE
1456885990EA800$ 438.38$ 350,704.00REMOVAL, SALVAGE AND DISPOSAL OF EXISTING TRAFFIC SIGNAL EQUIP
688.2 TEMPORARY ADJUSTMENT OF TRAFFIC SIGNAL EQUIPMENT AND TIMINGS$ - 0
1466885992EA50$ 344.44$ 17,222.00TEMPORARY ADJUSTMENT OF TRAFFIC SIGNAL EQUIPMENT
1476885993EA150$ 325.00$ 48,750.00TEMPORARY TIMING ADJUSTMENT PER SITE VISIT
1486887933EA100$ 70.00$ 7,000.00INSTALL COMMUNICATION SERVICE FOR TRAFFIC SIGNAL
688.3 VIDEO DETECTION - LOOP EMULATION SYSTEM$ - 0
1496886040EA150$ 4,000.00$ 600,000.00FURNISH & INSTALL VIDEO DETECTION SYSTEM W/HARDWARE & LEAD‐IN
1506886041EA50$ 300.00$ 15,000.00INSTALL VIDEO DETECTION SYSTEM
688.5 STEEL STRAIN POLE AND FOUNDATION$ - 0
1516887940EA50$ 2,098.01$ 104,900.50INSTALL FOUNDATION FOR STEEL STRAIN POLE
1526888155EA50$ 350.00$ 17,500.00INSTALL STEEL STRAIN POLE ON EXISTING FOUNDATION
153682505AEA20$ 5,000.00$ 100,000.00FURNISH AND INSTALL 26' STEEL STRAIN POLE, POLE BANDS AND HARDWARE
154682505BEA100$ 5,200.00$ 520,000.00FURNISH AND INSTALL 28' STEEL STRAIN POLE, POLE BANDS AND HARDWARE
155682505DEA50$ 5,500.00$ 275,000.00FURNISH AND INSTALL 32' STEEL STRAIN POLE, POLE BANDS AND HARDWARE
1566825050EA15$ 5,200.00$ 78,000.00FURNISH & INSTALL 13" X 26' STEEL STRAIN POLE (POWDER COATED) AND FOUNDATION
1576825056EA15$ 5,400.00$ 81,000.00FURNISH & INSTALL 13" X 26' STEEL STRAIN POLE (POWDER COATED OVER GALVANIZED) AND FOUNDATION
1586825051EA15$ 5,700.00$ 85,500.00FURNISH & INSTALL 13" X 28' STEEL STRAIN POLE (POWDER COATED) AND FOUNDATION
1596825057EA15$ 5,300.00$ 79,500.00FURNISH & INSTALL 13" X 28' STEEL STRAIN POLE (POWDER COATED OVER GALVANIZED) AND FOUNDATION
1606825052EA15$ 5,500.00$ 82,500.00FURNISH & INSTALL 13" X 32' STEEL STRAIN POLE (POWDER COATED) AND FOUNDATION
1616825058EA15$ 5,800.00$ 87,000.00FURNISH & INSTALL 13" X 32' STEEL STRAIN POLE (POWDER COATED OVER GALVANIZED) AND FOUNDATION
688.6 CONCRETE STRAIN POLE$ - 0
1626825061EA15$ 3,811.05$ 57,165.75FURNISH AND INSTALL 35' CONCRETE STRAIN POLE
1636825062EA15$ 4,189.70$ 62,845.50FURNISH AND INSTALL 40' CONCRETE STRAIN POLE
1646825064EA10$ 4,471.10$ 44,711.00FURNISH AND INSTALL 45' CONCRETE STRAIN POLE
1656887945EA25$ 1,500.00$ 37,500.00INSTALL CONCRETE STRAIN POLE
688.7 CONTROLLER AND 332/336 CABINET$ - 0
1666845510EA25$ 6,000.00$ 150,000.00FURNISH & INSTALL CONTROLLER AND 336 CABINET ASSEMBLY ‐ POLE MOUNTED
1676845511EA50$ 8,587.88$ 429,394.00FURNISH & INSTALL CONTROLLER AND 332/336 CABINET ASSEMBLY ‐ BASE MOUNTED
1686845614EA100$ 475.00$ 47,500.00INSTALL 2070L CONTROLLER UNIT &/OR CONFLICT MONITOR IN EXISTING CABINET
1696888226EA75$ 187.88$ 14,091.00INSTALL CONTROLLER‐BASE MOUNTED CABINET ON EXISTING FOUNDATION
1706845520EA5$ 3,192.26$ 15,961.30FURNISH AND INSTALL 2070L LOCAL CONTROLLER* WITH SOFTWARE
1716887950EA50$ 125.25$ 6,262.50INSTALL PRE-FABRICATED CONCRETE CABINET FOUNDATION
1726887951EA150$ 850.00$ 127,500.00FURNISH AND INSTALL CONCRETE CABINET FOUNDATION
1736887952EA50$ 125.25$ 6,262.50INSTALL PREFORMED CABINET FOUNDATION
1746888220EA100$ 344.44$ 34,444.00INSTALL SCDOT SUPPLIED POLE MOUNTED CABINET ASSEMBLY** AND CONTROLLER
1756888225EA150$ 187.88$ 28,182.00INSTALL SCDOT SUPPLIED BASE MOUNTED CABINET ASSEMBLY** AND CONTROLLER
1769610201EA25$ 1,000.00$ 25,000.00RAILROAD LIABILITY INSURANCE
177HR300$ 187.50$ 56,250.00RAILROAD FLAGGING
1786845518EA50$ 5,700.00$ 285,000.00FURNISH AND INSTALL BATTERY BACK-UP INCLUDING FOUNDATION
1796888243EA50$ 500.00$ 25,000.00INSTALL BATTERY BACK-UP INCLUDING FOUNDATION
688.8 REMOTE SPLICE/FLASHER CABINET$ - 0
1806888245EA15$ 313.13$ 4,696.95INSTALL SPLICE/FLASH CABINET
1816845655EA25$ 410.00$ 10,250.00FURNISH & INSTALL SPLICE‐CABINET/FLASHER CABINET
688.9 SOLAR POWERED FLASHER ASSEMBLY$ - 0
1826865700EA50$ 3,653.33$ 182,666.50FURNISH & INSTALL SOLAR POWERED FLASHER ASSEMBLY ‐ SINGLE BEACON
1836865701EA50$ 4,000.00$ 200,000.00FURNISH & INSTALL SOLAR POWERED FLASHER ASSEMBLY ‐ DUAL BEACON
1846865702EA100$ 2,400.00$ 240,000.00FURNISH & INSTALL SOLAR POWERED FLASHER ASSEMBLY
1856887960EA150$ 347.78$ 52,167.00INSTALL SOLAR POWERED FLASHER ASSEMBLY
689.1 WORKING CREW WITH EQUIPMENT$ - 0
1866887990HR250$ 187.88$ 46,970.00WORKING CREW WITH EQUIPMENT (BUCKET TRUCK, LINE TRUCK/POLE TRAILER, FOREMAN VEHICLE). MAY SUBSTITUTE LINE TRUCK FOR BUCKET TRUCK, IF NECESSARY. MATERIALS SUPPLIED BY SCDOT. SIGNAL SHOP SUPERVISOR SHALL DESIGNATE ALL EMERGENCIES, PAY RATE TO BE 1 1/2 X DAY.
689.3 TRAFFIC SIGNAL SYSTEM TRAINING$ - 0
1876886020HR100$ 187.50$ 18,750.00TRAINING BEING SIGNAL RELATED SYSTEM TRAINING
690.1 STEEL POLE WITH MAST ARM$ - 0
1886865831EA150$ 250.00$ 37,500.00FURNISH & INSTALL VEHICLE TRAFFIC SIGNAL HEAD MOUNTING ASSEMBLY FOR MAST ARM
1896888110EA25$ 450.00$ 11,250.00INSTALL STREET LIGHT LUMINAIRE, INCLUDING MOUNTING HARDWARE
1906825110AEA10$ 5,000.00$ 50,000.00FURNISH 21' STEEL POLE WITH 26' MAST ARM (MOUNTING HARDWARE, ADAPTER PLATE INCLUDED, GALVANIZED, NON-DECORATIVE)
1916825130A10$ 5,500.00$ 55,000.00FURNISH 21' STEEL POLE WITH DUAL MASTS (BOTH 26' IN LENGTH), INCLUDING MOUNTING HARDWARE, ADAPTER PLATE INCLUDED, GALVANIZED, NON-DECORATIVE
192-EA300$ 200.00$ 60,000.00ADDED COST FOR EACH 2' INCREMENT UP TO 20'
193-300$ 300.00$ 90,000.00ADDED COST FOR EACH 2' INCREMENT > 20’
1946825120AEA10$ 6,500.00$ 65,000.00FURNISH 27' STEEL POLE WITH 26' MAST ARM (MOUNTING HARDWARE, ADAPTER PLATE INCLUDED, GALVANIZED, NON-DECORATIVE)
1956825310A10$ 7,000.00$ 70,000.00FURNISH 27' STEEL POLE WITH DUAL MASTS (BOTH 26' IN LENGTH), INCLUDING MOUNTING HARDWARE, ADAPTER PLATE INCLUDED, GALVANIZED, NON-DECORATIVE
1966888163EA20$ 1,200.00$ 24,000.00DESIGN MAST ARM FOUNDATION (DOES NOT INCLUDE SOIL BORING OR UTILITY CHECK)
1976888164EA10$ 800.00$ 8,000.00FURNISH & INSTALL DUAL LUMINAIRE INCLUDING LUMINAIRE ARMS AND ALL ASSOCIATED HARDWARE
1986888165EA10$ 400.00$ 4,000.00FURNISH & INSTALL SINGLE LUMINAIRE INCLUDING LUMINAIRE ARMS AND ALL ASSOCIATED HARDWARE
1996888166EA10$ 500.00$ 5,000.00POWDERCOATING PER MAST ARM OVER BASE
2006888167EA10$ 800.00$ 8,000.00POWDERCOATING PER MAST ARM OVER GALVANIZED
2016888168EA10$ 1,000.00$ 10,000.00DECORATIVE OPTION PER MAST ARM
2026888171EA10$ 1,800.00$ 18,000.00INSTALL STEEL POLE WITH MAST ARM WITHOUT FOUNDATION
2036888181EA10$ 2,000.00$ 20,000.00INSTALL STEEL POLE WITH TWIN MAST ARMS WITHOUT FOUNDATION
2046888173EA15$ 1,500.00$ 22,500.00SOIL BORING - UTILITY REVIEW FOR MAST ARM DESIGN PER SIGNAL QUADRANT (INCLUDES 1 SOIL BORING TEST/REPORT AND RED LINED PLAN INDICATING UTILITY LOCATIONS)
2056888174CY50$ 575.00$ 28,750.00INSTALL FOUNDATION FOR MAST ARM INCLUDING CONCRETE AND REBAR
206-EA10$ 850.00$ 8,500.00GALVANIZED FINISH PER MAST ARM
207-EA10$ 1,200.00$ 12,000.00ADAPTER PLATE PER MAST ARM
208-EA10$ 500.00$ 5,000.00MAST ARM SKIRT & BREAKAWAY COUPLINGS PER MAST ARM
2098090001AEA25$ 600.00$ 15,000.00RIGHT OF WAY SURVEY (PER TRAFFIC SIGNAL QUADRANT, APPROX 1/4 ACRE, INCLUDING DEED/PLAT RESEARCH)
Standard Drawing #720-901-02 (Pedestrian Ramps: General Notes & Definitions):$ - 0
2107204100SY150$ 50.00$ 7,500.00CONCRETE SIDEWALK 4" UNIFORM
2117203210LF3,000$ 21.19$ 63,570.00C&G - CONC.CURB & GUTTER(2'-0")VERT.
2127209000SY3,000$ 75.00$ 225,000.00Pedestrian Ramp Construction (includes Detectable Warning Surface; also includes curb & gutter, ramp partitions, etc)
2137206000SY3,000$ 75.00$ 225,000.00Concrete Median (for at-grade pass-through of raised medians)
2147209100SF2,000$ 16.00$ 32,000.00Surface Applied Detectable Warning (placed on existing ramp or on asphalt, not used in new ramp construction)
2152023000SY3,000$ 30.00$ 90,000.00Removal and Disposal of Existing Pavement (equal to area of new ramp, includes sidewalk, curb & gutter, etc)
2169614006SY3,000$ 75.16$ 225,480.00FULL DEPTH ASPHALT PAVING / PATCHING 6" UNIFORM
2172031000CY5,000$ 25.00$ 125,000.00UNCLASSIFIED EXCAVATION
Signing$ - 0
2186888130SF150$ 9.00$ 1,350.00INSTALL FLAT SHEET, TYPE III, FIXED SIZE & MESSAGE SIGN (SHOULDER MOUNTED)
2196888131SF150$ 11.00$ 1,650.00INSTALL FLAT SHEET, TYPE VIII OR IX, SIZE DETERMINED BY MESSAGE (OVERHEAD)
2206888132SF300$ 11.00$ 3,300.00INST.FL.SH.FIXMSG.SGN-MAST.MNT
2216513015EA75$ 150.00$ 11,250.00MOUNTING ASSEMBLY FOR F.S. SIGN ERCTD ON SPAN WIRE
2226513016EA75$ 180.00$ 13,500.00RELOCATION OF MOUNT.ASSEMBLY FOR FS.SIGN ON SPAN WIRE
2236513017EA75$ 150.00$ 11,250.00REMOVAL OF MOUNTING ASSEMBLY FOR FS.SIGN ON SPAN WIRE
2246513021EA75$ 250.00$ 18,750.00RELOCATION OF MOUNT.ASSEMBLY FOR FS.SIGN ON MAST ARM
2256513022EA75$ 200.00$ 15,000.00REMOVAL OF MOUNTING ASSEMBLY FOR FS.SIGN ON MAST ARM
2266510105SF75$ 22.00$ 1,650.00FURNISH AND INSTALL FLAT SHEET, TYPE III, FIXED SIZE & MESSAGE SIGN (SHOULDER MOUNTED)
2276510108SF75$ 25.00$ 1,875.00FURNISH AND INSTALL FLAT SHEET, TYPE VIII OR IX, SIZE DETERMINED BY MESSAGE (OVERHEAD)
2286513020EA25$ 250.00$ 6,250.00FURNISH & INSTALL MOUNTING ASSEMBLY FOR FLAT SHEET SIGN ERCTD ON MAST ARM
Markings$ - 0
2296250015LF1,500$ 0.87$ 1,305.008"WHITE SOLID LINES(CROSSWALK&CHANNELIZATION)FAST DRY PAINT
2306250010LF1,500$ 0.18$ 270.004" WHITE SOLID LINES (PVT. EDGE LINES)-FAST DRY PAINT
2316250110LF1,500$ 0.13$ 195.004" YELLOW SOLID LINE(PVT.EDGE&NO PASSING ZONE)-FAST DRY PAINT
2326250025LF1,500$ 2.36$ 3,540.0024" WHITE SOLID LINES (STOP/DIAGONAL LINES)-FAST DRY PAINT
2336250030LF25$ 31.88$ 797.00WHITE SINGLE ARROW (LEFT, STRAIGHT, RIGHT)-FAST DRY PAINT
2346250035EA25$ 41.04$ 1,026.00WHITE WORD MESSAGE "ONLY"-FAST DRY PAINT
2356250040EA25$ 40.37$ 1,009.25WHITE COMBINATION ARROW (STR.& RT.OR STR.& LT.)FAST DRY PAINT
2366271015LF1,500$ 2.76$ 4,140.008" WHITE SOLID LINES THERMOPLASTIC - 125 MIL.
2376271010LF1,500$ 0.58$ 870.004" WHITE SOLID LINES (PVT. EDGE LINES) THERMO.- 90 MIL.
2386271074LF1,500$ 0.51$ 765.004" YELLOW SOLID LINES (PVT.EDGE LINES) THERMO-90 MIL.
2396271025LF1,500$ 10.08$ 15,120.0024" WHITE SOLID LINES (STOP/DIAG LINES)-THERMO.-125 MIL
2406271030LF50$ 81.72$ 4,086.00WHITE SINGLE ARROWS (LT, STRGHT, RT) THERMO.-125 MIL.
2416271035EA25$ 123.70$ 3,092.50WHITE WORD MESSAGE "ONLY" -THERMOPLASTIC - 125 MIL.
2426271040EA25$ 104.85$ 2,621.25WHITE COMBINATION ARROWS(STR&RT.OR STR&LT)THERMO-125MIL
243-LF300$ 2.00$ 600.00REMOVAL OF STOP BAR MARKING
2446319505LF300$ 1.60$ 480.00REMOVAL OF PAVEMENT MARKINGS
Lighting$ - 0
2456651145EA10$ 3,500.00$ 35,000.00FURNISH & INSTALL SINGLE ALUMINUM LIGHT STANDARD – 35’- BREAKAWAY- W/O FDN (SGL.LIGHT STD.35'HT.AL.POLE-INCL TOP TENON MT. )
246-EA10$ 850.00$ 8,500.00INSTALL 35’ SPUN BRUSHED ALUMINUM POLE W/ LUMINAIRE ON EXISTING FDN
247-EA10$ 1,500.00$ 15,000.00FURNISH & INSTALL NEMA 4X STAINLESS STEEL ENCLOSURE FOR LIGHTING SYSTEM (W/O FDN)
248-HR10$ 50.00$ 500.00TROUBLESHOOT/REPAIR LIGHTING SYSTEM
249-EA25$ 200.00$ 5,000.00FURNISH & INSTALL PHOTOCELL
250-EA5$ 150.00$ 750.00INSTALL PHOTOCELL
251-LF10$ 100.00$ 1,000.00FURNISH & INSTALL GROUND ROD, INC COPPER WIRE & CLAMP
$ 19,786,208.25

SCDOT Traffic Signal Fixed Price On-Call Pricing Page &P &D

UserFormLists

CountiesType of WorkFunding
ABBEVILLEBike PathFederal
AIKENBridge PaintingState
ALLENDALEBridge Rehab.
ANDERSONBridge Replacement
BAMBERGChip Seal
BARNWELLClearing and Grubbing
BEAUFORTConcrete Repair
BERKELEYConstruct Sidewalk
CALHOUNCrack Seal
CHARLESTONCulvert Rehab.
CHEROKEEDrainage Improvements
CHESTERFence Repair
CHESTERFIELDFull Depth Patching
CLARENDONGrade, Drain, Bit. Surf.
COLLETONGrade, Drain, Pave
DARLINGTONGrade, Drain, Pave & Constr. Bridge
DILLONGuardrail Rehab.
DORCHESTERInstall ITS System
EDGEFIELDInterchange Improvements
FAIRFIELDIntersection Improvement
FLORENCEInterstate Rehab.
GEORGETOWNLandscaping
GREENVILLEMedian Cable Barrier
GREENWOODMilling & Paving
HAMPTONPavement Marking
HORRYPlacing Milled in Rumble Strips
JASPERReclaimation
KERSHAWRest Area Renovations
LANCASTERResurfacing
LAURENSSeeding
LEEShoulder Paving
LEXINGTONShoulder Widening
MCCORMICKSidewalk, Drainage
MARIONSigning
MARLBOROTraffic Engineering
NEWBERRYTraffic Signal System Installation
OCONEETraffic Signal Upgrade
ORANGEBURGWiden, Grading, Drainage, Paving
PICKENS
RICHLAND
SALUDA
SPARTANBURG
SUMTER
UNION
WILLIAMSBURG
YORK

Trendlines

$ 197.19Formulas for Caculating Power Trendline EquationFormulas for Calculating Logarithmic Trendline EquationFormulas for Calculating Exponential Trendline EquationFormulas for Calculating Linear Trendline Equation
QuantityLow BidLOG XLOG Ylogxlogylogx^2logx*logylogy^2Trendline y valueslnxyx^2xyy^2Trendline y valuesxlog yx ^2xyy ^2Trendline y valuesxyx^2xyy^2Trendline y values
2$ 580.000.30102999572.76342799360.30102999572.76342799360.09061905830.83187471697.6365342756462.09768744430.6931476468$ 580.000.4804536603402.0256351484336400484.297471395326.3630323837412.726064767340.4881811154399.650673558225804$ 1,160.00336400428.5824409449
3$ 504.540.47712125472.70289560290.47712125472.70289560290.22764469171.28960894147.30564464424.98993885631.0986130277$ 504.541.2069505845554.2942169721254560.6116450.21055856236.2236513094918.670953928338.7338356214397.22674102543504.549$ 1,513.62254560.6116425.4085325698
3$ 435.000.47712125472.6384892570.47712125472.6384892570.22764469171.25887930486.9616255591424.98993885631.0986130277$ 435.001.2069505845477.8966670291189225450.21055856236.0753501177918.226050353136.9098790525397.226741025434359$ 1,305.00189225425.4085325698
3$ 530.000.47712125472.72427586960.47712125472.72427586960.22764469171.29980992117.4216790137424.98993885631.0986130277$ 530.001.2069505845582.2649046562280900450.21055856236.272881226918.818643678139.3490388757397.226741025435309$ 1,590.00280900425.4085325698
3$ 512.500.47712125472.70969386970.47712125472.70969386970.22764469171.2928525397.3424408676424.98993885631.0986130277$ 512.501.2069505845563.0391766722262656.25450.21055856236.2393049079918.717914723738.9289257337397.22674102543512.59$ 1,537.50262656.25425.4085325698
6$ 205.550.77815125042.31291748110.77815125042.31291748110.60551936851.799799635.3495872745368.32323429331.7917606745$ 205.553.2104063145368.296406635442250.8025391.938596186265.32569289573631.954157374128.3630048192390.04279607066205.5536$ 1,233.3042250.8025415.8868074445
6$ 200.000.77815125042.30102999570.77815125042.30102999570.60551936851.79054936835.2947390409368.32323429331.7917606745$ 200.003.2104063145358.352134892140000391.938596186265.29832093053631.789925582928.0722046823390.0427960706620036$ 1,200.0040000415.8868074445
6$ 350.000.77815125042.54406804440.77815125042.54406804440.60551936851.97966972986.4722822143368.32323429331.7917606745$ 350.003.2104063145627.1162360613122500391.938596186265.85793709483635.14762256934.3154270071390.0427960706635036$ 2,100.00122500415.8868074445
$30.00$ 400.001.47712125472.60205999131.47712125472.60205999132.18188720113.84355811926.7707161985264.19364598263.4011996695$ 400.0011.56815919171360.4798677953160000256.6352896016305.9914685773900179.744057318635.8976957126337.056364366430400900$ 12,000.00160000339.7130064424
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!
ERROR:#NUM!ERROR:#NUM!

This is the start of the file's text. The full file is on GovTribe.

File details come from the government source that posted it. Updated .