dena01048_controlsheet.xlsx

XLSX spreadsheet 140 KB Posted Apr 7, 2021

Attached to: AK NPS DENA 10(47) & 10(48), REPAIR TWO DENALI PARK ROAD BRIDGES AND CULVERT REPLACEMENT MP 52 & ROCKFALL MITIGATION MP 52. 9, National Park Service, park, Denali Borough, Alaska.
Solicitation number: 69056718B000028
Issued by: Department of Transportation Federal Highway Administration

About this file

Written by GovTribe AI · Dec 28, 2023

This document contains a federal contract opportunity and related survey control sheet for a project with the National Park Service in Denali Borough, Alaska. The contract opportunity involves repairing two bridges on the Denali Park Road at mileposts 23 and 61, replacing a concrete box culvert at milepost 52, and conducting rockfall mitigation including scaling, installing dowels and bolts at milepost 52.9. The total project length is 0.3 miles. The tentative completion date is fall 2020. The estimated price range for the work is $2 million to $3 million. The control sheet provides state plane and geospatial coordinates and elevations for survey control points related to the project.

View the file

Other files

File	Type	Posted
BidSum.pdf	PDF	May 10, 2021
QA 5-May-21.pdf	PDF	May 5, 2021
Amendment A004.pdf	PDF	May 4, 2021
QA 4-May-21.pdf	PDF	May 4, 2021
REVISED GR 02-21 Toklat Bluffs Report_Rev2 final signed.pdf	PDF	May 4, 2021
Amendment A003.pdf	PDF	May 4, 2021
QA 3-May-21.pdf	PDF	May 3, 2021
Amendment A002.pdf	PDF	Apr 27, 2021
QA 22-Apr-21.pdf	PDF	Apr 22, 2021
QA _4-20-2021.pdf	PDF	Apr 20, 2021
Attention Contractors 2 .docx	DOCX document	Apr 19, 2021
Amendment A001.pdf	PDF	Apr 19, 2021
9830-007P Bridge Safety Inspection.pdf	PDF	Apr 7, 2021
Attention Contractors.docx	DOCX document	Apr 7, 2021
dena01048_Vertical Profile_Bugstuffer Channel.pdf	PDF	Apr 7, 2021
dena01048_Horizontal Alignment_BL1(Bugstuffer).pdf	PDF	Apr 7, 2021
IFB 69056718B000028.pdf	PDF	Apr 7, 2021
dena01048_SWPPP.pdf	PDF	Apr 7, 2021
dena01048_Horizontal Alignment_BL2(Toklat Bluffs).pdf	PDF	Apr 7, 2021
dena01048_Horizontal_Alignment_Bugstuffer Channel.pdf	PDF	Apr 7, 2021
dena01048_Vertical Profile_BL1(Bugstuffer).pdf	PDF	Apr 7, 2021
GM 54-20.pdf	PDF	Apr 7, 2021
Plans 69056718B000028.pdf	PDF	Apr 7, 2021
9830-013P Bridge Safety Inspection.pdf	PDF	Apr 7, 2021
Hydraulics Handoff Memo.pdf	PDF	Apr 7, 2021
GR 02-21.pdf	PDF	Apr 7, 2021
9830-015P Existing Bridge Plans .pdf	PDF	Apr 7, 2021
dena01048_Vertical Profile_BL2(Toklat Bluffs).pdf	PDF	Apr 7, 2021
9830-007P Existing Bridge Plans.pdf	PDF	Apr 7, 2021
9830-015P Bridge Safety Inspection.pdf	PDF	Apr 7, 2021

Show all 30

On GovTribe

Work with this file

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

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Information

	Information
1.	This file transfers the Survey Control point list (in Excel format) to an Excel plan sheet. Open the point list files in Excel. Select the tab at the bottom of the worksheet and drag it to this spreadsheet. It will become a new tab. Place the name of this tab in the "Data Location" block below. The Survey Control point list will appear.
2.	If extra sheets are needed, copy the original plan sheet by holding the left mouse button on the worksheet's tab (below) and hold the <CTRL>key. A mini sheet with a plus sign should appear. Drag this and drop it to the desired location.

	Common Sheet Information
	Insert the following values. They will appear on every sheet.
	State:	AK	Note: If there is more than one project number, use <ALT><ENTER> to insert page break for additional lines.
	Project:	NPS DENA 10(47)&10(48)
NPS PMIS /

Drawing No:

Designed by:	WFLHD Survey
Date:	1/1904
Checked by:	WFLHD Survey
Date:	1/1904
First sheet #:	D.5	1.0
Title block text:	SURVEY CONTROL
Show Totals?	TRUE
Data location:	Page 1	Worksheet found
Data begins in col:	A
Min. rows/table	5	3.0
Base sheet name:	Sheet	6	rows w/data	OK - no spaces in data
Max. row/table	40	6	data rows	Warnings:
		40	rows/table
			PROJECT : Culvert Replacement MP52 rockfall mitigation MP 52.9

PROJECT UNITS : US Survey Foot

COORDINATE SYSTEM : Alaska zone 4 SPCS NAD83 (2011) VERTICAL DATUM : Orthometric elevations based on the NAVD88 GEOID12b

EPOCH DATE : 2010.000

Sheet Names
Input the names of the worksheets in the order you would like the sheets numbered.
	Worksheet Name	Sheet	Header row	Sheet Number	Notes
	Sheet	D.5	3	5	OK
	Sheet (2)	Undefined	FALSE	5
	Sheet (3)	Undefined	FALSE	5
	Sheet (4)	Undefined	FALSE	5
	Sheet (5)	Undefined	FALSE	5
	Sheet (6)	Undefined	FALSE	5
	Sheet (7)	Undefined	FALSE	5
	Sheet (8)	Undefined	FALSE	5
	Sheet (9)	Undefined	FALSE	5
	Sheet (10)	Undefined	FALSE	5
	Sheet (11)	Undefined	FALSE	5
	Sheet (12)	Undefined	FALSE	5
	Sheet (13)	Undefined	FALSE	5
	Sheet (14)	Undefined	FALSE	5
	Sheet (15)	Undefined	FALSE	5
	Sheet (16)	Undefined	FALSE	5
	Sheet (17)	Undefined	FALSE	5
	Sheet (18)	Undefined	FALSE	5
	Sheet (19)	Undefined	FALSE	5
	Sheet (20)	Undefined	FALSE	5
	Total Sheets:	1	0	sheets missing

Revised: 15 June 2015

Sheet

Sheet Information

Sheet num:

D.5

Filename

Sheet name:

Sheet

C:\MyFiles\Projects_2021\Alaska\Bugstuffer\[AK_NPS_DENA_10(48)_controlsheet.xlsx]Sheet

Reference:

Time

28-Jan-2021 8:44 AM

Begin Column:

PROJECT : Culvert Replacement MP52 rockfall mitigation MP 52.9 PROJECT UNITS : US Survey Foot COORDINATE SYSTEM : Alaska zone 4 SPCS NAD83 (2011)

						STATE PLANE COORDINATES			GEO COORDINATES
	3.0				POINT
NUMBER	NORTH	EAST	ELEVATION	LATITUDE	LONGITUDE	ELLIPSOID
HEIGHT	COMBINED
FACTOR	DESCRIPTION		NOTE:
					7001	3476913.029	1641257.729	3249.839	63°30'53.928784"N	149°59'41.458221"W	3297.2768	0.99974281	0	1.	To precisely check distances between points as measured on the ground, inverse the state plane coordinates and divide the computed distance by a mean combined factor of the two points.
					9001	3476777.224	1641447.551	3243.081	63°30'52.591652"N	149°59'37.273753"W	3290.522	0.99974313	0
					BUG1	3475849.084	1643747.283	3320.377	63°30'43.449628"N	149°58'46.581809"W	3367.8504	0.99973946	5/8" IR w/fhwa alum cap
					BUG2	3475975.210	1643428.928	3295.384	63°30'44.692258"N	149°58'53.598651"W	3342.8546	0.99974065	5/8" IR w/fhwa alum cap
					STONY	3455943.228	1603386.804	3935.483	63°27'26.841808"N	150°13'34.710259"W	3982.8192	0.9997117	5/8" IR w/fhwa alum cap
					Y125	3474436.939	1632261.283	3162.047	63°30'29.521317"N	150°02'59.748262"W	3209.4717	0.99974707	Brass Cap
					0	0.000	0.000	0.000			0	0	0
					0	0.000	0.000	0.000			0	0	0
					0	0.000	0.000	0.000			0	0	0
					0	0.000	0.000	0.000			0	0	0
					0	0.000	0.000	0.000			0	0	0
					0	0.000	0.000	0.000			0	0	0
					0	0.000	0.000	0.000			0	0	0
					0	0.000	0.000	0.000			0	0	0
					0	0.000	0.000	0.000			0	0	0
					0	0.000	0.000	0.000			0	0	0
					0	0.000	0.000	0.000			0	0	0
					0	0.000	0.000	0.000			0	0	0
					0	0.000	0.000	0.000			0	0	0
					0	0.000	0.000	0.000			0	0	0
					0	0.000	0.000	0.000			0	0	0
					0	0.000	0.000	0.000			0	0	0
					0	0.000	0.000	0.000			0	0	0
					0	0.000	0.000	0.000			0	0	0
					0	0.000	0.000	0.000			0	0	0
					0	0.000	0.000	0.000			0	0	0
					0	0.000	0.000	0.000			0	0	0
					0	0.000	0.000	0.000			0	0	0
					0	0.000	0.000	0.000			0	0	0
					0	0.000	0.000	0.000			0	0	0
					0	0.000	0.000	0.000			0	0	0
					0	0.000	0.000	0.000			0	0	0
					0	0.000	0.000	0.000			0	0	0
					0	0.000	0.000	0.000			0	0	0
					0	0.000	0.000	0.000			0	0	0
					0	0.000	0.000	0.000			0	0	0
					0	0.000	0.000	0.000			0	0	0
					0	0.000	0.000	0.000			0	0	0
					0	0.000	0.000	0.000			0	0	0
					0	0.000	0.000	0.000			0	0	0

PROJECT : Culvert Replacement MP52 rockfall mitigation MP 52.9 PROJECT UNITS : US Survey Foot

COORDINATE SYSTEM : Alaska zone 4 SPCS NAD83 (2011)

		STATE PLANE COORDINATES			GEO COORDINATES
	POINT
NUMBER	NORTH	EAST	ELEVATION	LATITUDE	LONGITUDE	ELLIPSOID
HEIGHT	COMBINED
FACTOR	DESCRIPTION
	7001	3476913.029	1641257.729	3249.839	63°30'53.928784"N	149°59'41.458221"W	3297.277	0.99974281
	9001	3476777.224	1641447.551	3243.081	63°30'52.591652"N	149°59'37.273753"W	3290.522	0.99974313
	BUG1	3475849.084	1643747.283	3320.377	63°30'43.449628"N	149°58'46.581809"W	3367.850	0.99973946	5/8" IR w/fhwa alum cap
	BUG2	3475975.210	1643428.928	3295.384	63°30'44.692258"N	149°58'53.598651"W	3342.855	0.99974065	5/8" IR w/fhwa alum cap
	STONY	3455943.228	1603386.804	3935.483	63°27'26.841808"N	150°13'34.710259"W	3982.819	0.99971170	5/8" IR w/fhwa alum cap
	Y125	3474436.939	1632261.283	3162.047	63°30'29.521317"N	150°02'59.748262"W	3209.472	0.99974707	Brass Cap

image1.jpeg

File details come from the government source that posted it. Updated Apr 7, 2021.