ID_FLAP_ID_NF17(1)_control-points.xlsx

XLSX spreadsheet 38 KB Posted Aug 21, 2024

Attached to: ID FLAP IDAHO NF17(1), Mt. Idaho Grade Road Rehabilitation
Solicitation number: 69056724B000014
Issued by: Department of Transportation Federal Highway Administration

About this file

Written by GovTribe AI · Aug 22, 2024

This document appears to be a survey control point list in Microsoft Excel format related to the federal contract opportunity "ID FLAP IDAHO NF17(1), Mt. Idaho Grade Road Rehabilitation". The Excel file contains information about survey control points, including their state plane coordinates, geographic coordinates, elevations, and descriptions. The contract opportunity is for a construction project involving the rehabilitation of the Mt. Idaho Grade Road, issued by the Department of Transportation Federal Highway Administration. The solicitation is offered as full and open competition with a Price Evaluation Factor for HUBZone Small businesses.

View the file

Other files

File	Type	Posted
Bid Tabs_ID FLAP IDAHO NF17(1).pdf	PDF	Oct 9, 2024
BidSum_ID FLAP IDAHO NF17(1).pdf	PDF	Oct 8, 2024
QA 10-08-24.pdf	PDF	Oct 8, 2024
QA 10-7-24.pdf	PDF	Oct 7, 2024
Amendment A001.pdf	PDF	Aug 22, 2024
ID_FLAP_ID_NF17(1)_FINAL_GEO_MEMO.pdf	PDF	Aug 21, 2024
ID_FLAP_ID_NF17(1)_clearing-limits-subex-section.xlsx	XLSX spreadsheet	Aug 21, 2024
ID_FLAP_ID_NF17(1)_proposed-MAIN 01-VERTICAL.pdf	PDF	Aug 21, 2024
ID_FLAP_ID_NF17(1)_superelevation.pdf	PDF	Aug 21, 2024
ID_FLAP_ID_NF17(1)_XYZ-superelevation-section.xlsx	XLSX spreadsheet	Aug 21, 2024
Physical Data.zip	ZIP file	Aug 21, 2024
ID_FLAP_ID_NF17(1)_staking-notes-superelevation-section.xlsx	XLSX spreadsheet	Aug 21, 2024
ID_FLAP_ID_NF17(1)_staking-notes-subex-section.xlsx	XLSX spreadsheet	Aug 21, 2024
ID_FLAP_ID_NF17(1)_proposed-MAIN 01-HORIZONTAL.pdf	PDF	Aug 21, 2024
ID_FLAP_ID_NF17(1)_plans.pdf	PDF	Aug 21, 2024
ID_FLAP_ID_NF17(1)_XYZ_subex_section.xlsxv.xlsx	XLSX spreadsheet	Aug 21, 2024
ID_FLAP_ID_NF17(1)_XS.pdf	PDF	Aug 21, 2024
ID_FLAP_ID_NF17(1)_clearing-limits-superelevation-section.xlsx	XLSX spreadsheet	Aug 21, 2024
ID_FLAP_ID_NF17(1)_Earthwork-Subex-Section.pdf	PDF	Aug 21, 2024
ID_FLAP_ID_NF17(1)_Earthwork-Superelevation-Section.pdf	PDF	Aug 21, 2024
IFB_69056724B000014_ID FLAP IDAHO NF17(1).pdf	PDF	Aug 21, 2024

Show all 21

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

Survey Control Sheet
	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.
Project:	ID FLAP IDAHO NF17(1)	Note: If there is more than one project number, use <ALT><ENTER> to insert page break for additional lines.
NPS PMIS No.	NPS PMIS No.	Note: NPS fields do not appear on the sheet unless additional text is added.
NPS Drwg No.	NPS Drwg No.
First sheet #:	D.1	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	10	rows w/data	OK - no spaces in data
Max. row/table	35	10	data rows	Warnings:
		35	rows/table
			PROJECT : Mt Idaho grade road rehabilitation

DATE OF FIELD WORK :August 2022 DATE OF FINAL ADJUSTMENT : August 2022

COORDINATE SYSTEM : Idaho West SPCS NAD83 2011Idaho West SPCS NAD83 2011 VERTICAL DATUM : Orthometric elevations based on the NAVD88 GEOID12b

EPOCH DATE : 2010.000

CADD SYSTEM COORDINATE SYSTEM : ID83/2011-WF NSRS11(NAD83/2011) Idaho, West Zone, US Foot

PROJECT UNITS : US SURVEY FOOT

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

Revised: 20 September 2023

Sheet

Sheet Information

Sheet num:

D.1

Filename

Sheet name:

Sheet

C:\MyFiles\Projects_2024\Idaho\Mt_Idaho\Controlsheet\[Mt_Idaho_control sheet.xlsx]Sheet

Reference:

Time

20-Mar-2024 8:20 AM

Begin Column:

C:\MyFiles\Projects_2024\Idaho\Mt_Idaho\Controlsheet\[Mt_Idaho_control sheet.xlsx]Sheet
	PROJECT : Mt Idaho grade road rehabilitation

DATE OF FIELD WORK :August 2022 DATE OF FINAL ADJUSTMENT : August 2022

PROJECT UNITS : US SURVEY FOOT COORDINATE SYSTEM : Idaho West SPCS NAD83 2011Idaho West SPCS NAD83 2011 VERTICAL DATUM : Orthometric elevations based on the NAVD88 GEOID12b

EPOCH DATE : 2010.000

CADD SYSTEM COORDINATE SYSTEM : ID83/2011-WF NSRS11(NAD83/2011) Idaho, West Zone, US Foot

						STATE PLANE COORDINATES			GEO COORDINATES
	3.0				POINT
NUMBER	NORTH	EAST	ORTHOMETRIC ELEVATION	LATITUDE	LONGITUDE	ELLIPSOID
HEIGHT	COMBINED
FACTOR	DESCRIPTION		NOTE:
					2001	1549734.159	2553264.141	3260.317	45°55'04.640519"N	116°01'50.005996"W	3207.5152	0.9997859207	fhwa alum cap	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.
					2002	1549635.211	2553724.918	3232.958	45°55'03.679590"N	116°01'43.483381"W	3180.1584	0.9997871526	fhwa alum cap
					2003	1547809.260	2556623.623	2997.139	45°54'45.750557"N	116°01'02.394592"W	2944.3878	0.9997979545	fhwa alum cap
					2004	1547340.931	2556938.694	2967.990	45°54'41.137300"N	116°00'57.916209"W	2915.2586	0.9997992971	fhwa alum cap
					2005	1547262.512	2552104.250	2630.425	45°54'40.198203"N	116°02'06.287778"W	2577.7033	0.9998161957	fhwa alum cap
					2006	1546812.515	2551791.850	2590.057	45°54'35.744491"N	116°02'10.683315"W	2537.3495	0.9998181752	fhwa alum cap
					2007	1543110.668	2551215.351	2355.438	45°53'59.176886"N	116°02'18.647412"W	2302.8284	0.9998294744	fhwa alum cap
					2008	1542151.687	2550754.877	2293.392	45°53'49.692688"N	116°02'25.109377"W	2240.8166	0.9998325141	fhwa alum cap
					2009	1539241.304	2551772.337	2025.828	45°53'20.995683"N	116°02'10.575082"W	1973.341	0.9998451211	fhwa alum cap
					2010	1539957.609	2550951.680	1995.820	45°53'28.038311"N	116°02'22.214067"W	1943.3163	0.9998466928	fhwa alum cap
					0	0.000	0.000	0.000	0	0	0	0	0
					0	0.000	0.000	0.000	0	0	0	0	0
					0	0.000	0.000	0.000	0	0	0	0	0
					0	0.000	0.000	0.000	0	0	0	0	0
					0	0.000	0.000	0.000	0	0	0	0	0
					0	0.000	0.000	0.000	0	0	0	0	0
					0	0.000	0.000	0.000	0	0	0	0	0
					0	0.000	0.000	0.000	0	0	0	0	0
					0	0.000	0.000	0.000	0	0	0	0	0
					0	0.000	0.000	0.000	0	0	0	0	0
					0	0.000	0.000	0.000	0	0	0	0	0
					0	0.000	0.000	0.000	0	0	0	0	0
					0	0.000	0.000	0.000	0	0	0	0	0
					0	0.000	0.000	0.000	0	0	0	0	0
					0	0.000	0.000	0.000	0	0	0	0	0
					0	0.000	0.000	0.000	0	0	0	0	0
					0	0.000	0.000	0.000	0	0	0	0	0
					0	0.000	0.000	0.000	0	0	0	0	0
					0	0.000	0.000	0.000	0	0	0	0	0
					0	0.000	0.000	0.000	0	0	0	0	0
					0	0.000	0.000	0.000	0	0	0	0	0
					0	0.000	0.000	0.000	0	0	0	0	0
					0	0.000	0.000	0.000	0	0	0	0	0
					0	0.000	0.000	0.000			0	0	0
					0	0.000	0.000	0.000			0	0	0

20-Mar-2024 8:20 AM

PROJECT : Mt Idaho grade road rehabilitation DATE OF FIELD WORK :August 2022 DATE OF FINAL ADJUSTMENT : August 2022

COORDINATE SYSTEM : Idaho West SPCS NAD83 2011Idaho West SPCS NAD83 2011 VERTICAL DATUM : Orthometric elevations based on the NAVD88 GEOID12b

EPOCH DATE : 2010.000

CADD SYSTEM COORDINATE SYSTEM : ID83/2011-WF NSRS11(NAD83/2011) Idaho, West Zone, US Foot

PROJECT UNITS : US SURVEY FOOT

		STATE PLANE COORDINATES			GEO COORDINATES
	POINT
NUMBER	NORTH	EAST	ELEVATION	LATITUDE	LONGITUDE	ELLIPSOID
HEIGHT	COMBINED
FACTOR	DESCRIPTION
	2001	1549734.159	2553264.141	3260.317	45°55'04.640519"N	116°01'50.005996"W	3207.515	0.99978592	fhwa alum cap
	2002	1549635.211	2553724.918	3232.958	45°55'03.679590"N	116°01'43.483381"W	3180.158	0.99978715	fhwa alum cap
	2003	1547809.260	2556623.623	2997.139	45°54'45.750557"N	116°01'02.394592"W	2944.388	0.99979795	fhwa alum cap
	2004	1547340.931	2556938.694	2967.990	45°54'41.137300"N	116°00'57.916209"W	2915.259	0.99979930	fhwa alum cap
	2005	1547262.512	2552104.250	2630.425	45°54'40.198203"N	116°02'06.287778"W	2577.703	0.99981620	fhwa alum cap
	2006	1546812.515	2551791.850	2590.057	45°54'35.744491"N	116°02'10.683315"W	2537.350	0.99981818	fhwa alum cap
	2007	1543110.668	2551215.351	2355.438	45°53'59.176886"N	116°02'18.647412"W	2302.828	0.99982947	fhwa alum cap
	2008	1542151.687	2550754.877	2293.392	45°53'49.692688"N	116°02'25.109377"W	2240.817	0.99983251	fhwa alum cap
	2009	1539241.304	2551772.337	2025.828	45°53'20.995683"N	116°02'10.575082"W	1973.341	0.9998451211	fhwa alum cap
	2010	1539957.609	2550951.68	1995.82	45°53'28.038311"N	116°02'22.214067"W	1943.3163	0.9998466928	fhwa alum cap

File details come from the government source that posted it. Updated Aug 21, 2024.