Stoddard_Bridge_ControlSheet.xlsx

XLSX spreadsheet 39 KB Posted Mar 30, 2022

Attached to: ID FS ERFO 2017(1)-29(1), Stoddard Bridge Federal contract opportunity
Solicitation number: 69056719B000031
Issued by: Department of Transportation Federal Highway Administration

About this file

Written by GovTribe AI · Dec 28, 2023

This document contains survey control point data and related details for the Stoddard Bridge project. The file provides state plane and geographic coordinates, elevations, and descriptions for five survey control points used to establish horizontal and vertical control for the project. It also lists the federal solicitation number and project name for the Stoddard Bridge ID FS ERFO 2017(1)-29(1) opportunity through the Department of Transportation Federal Highway Administration. The survey control data sheet is intended to transfer point information from an Excel source file to plan sheets for the bridge project.

View the file

Other files for this federal contract opportunity

Other files attached to ID FS ERFO 2017(1)-29(1), Stoddard Bridge, newest first.
File	Type	Posted
BidSum_Stoddard_5.3.2022.pdf	PDF	May 3, 2022
QA_04-29-2022.pdf	PDF	Apr 29, 2022
QA_04-28-2022.pdf	PDF	Apr 28, 2022
Amendment 3_Stoddard Bridge.pdf	PDF	Apr 27, 2022
QA_04-27-2022.pdf	PDF	Apr 27, 2022
QA2_04-27-2022.pdf	PDF	Apr 27, 2022
QA2_04-25-2022.pdf	PDF	Apr 27, 2022
Amendment 2_Stoddard Bridge.pdf	PDF	Apr 25, 2022
QA_04-25-2022.pdf	PDF	Apr 25, 2022
QA_04-19-2022.pdf	PDF	Apr 19, 2022
QA_04-18-2022.pdf	PDF	Apr 18, 2022
Amendment 1_Stoddard Bridge.pdf	PDF	Apr 13, 2022
QA2_04-12-2022.pdf	PDF	Apr 13, 2022
GR 06-21 ID FS ERFO 2017(1)-29(1) Final.pdf	PDF	Apr 12, 2022
EW_Calc_Report_20210510.pdf	PDF	Mar 30, 2022
Stoddard_HA_Report_20210510.pdf	PDF	Mar 30, 2022
Stoddard Full Set - Plans - Signed.pdf	PDF	Mar 30, 2022
IFB_Stoddard Bridge.pdf	PDF	Mar 30, 2022
Stoddard_Bridge_TSL_Hydraulics_Report.pdf	PDF	Mar 30, 2022
Stoddard_VA_Report_20210510.pdf	PDF	Mar 30, 2022
ID USFS Stoddard Pack Suspension - 2010.pdf	PDF	Mar 30, 2022
FS ERFO 2017(1)-29(1)_XS_20210510.pdf	PDF	Mar 30, 2022

Show all 22

On GovTribe

Work with this file on GovTribe

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:	ID	Note: If there is more than one project number, use <ALT><ENTER> to insert page break for additional lines.
	Project:	FS ERFO 2017(1)-29(1)
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	5	rows w/data	OK - no spaces in data
Max. row/table	40	5	data rows	Warnings:
		40	rows/table
			PROJECT : Stoddard Bridge

DATE OF FIELD WORK : May 2018 DATE OF FINAL ADJUSTMENT : May 2018

PROJECT UNITS : US SURVEY FOOT

COORDINATE SYSTEM :Idaho Central SPCS NAD83 2011

EPOCH DATE : 2010.0000

VERTICAL DATUM :Orthometric Elevations based on the NAVD88 GEOID12b

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\Idaho\Stoddard_Bridge\Control\[Stoddard_Bridge_ControlSheet.xlsx]Sheet

Reference:

Time

8-Aug-2019 2:35 PM

Begin Column:

PROJECT : Stoddard Bridge DATE OF FIELD WORK : May 2018 DATE OF FINAL ADJUSTMENT : May 2018 PROJECT UNITS : US SURVEY FOOT COORDINATE SYSTEM :Idaho Central SPCS NAD83 2011

						STATE PLANE COORDINATES			GEO COORDINATES
	3.0				POINT
NUMBER	NORTH	EAST	ELEVATION	LATITUDE	LONGITUDE	ELLIPSOID
HEIGHT	COMBINED
FACTOR	DESCRIPTION		NOTE:
					SPB1	1323735.159	1484847.739	3074.538	45°17'48.579872"N	114°36'16.375910"W	3028.9339	0.99983031	5/8" IR w/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.
					SPB2	1323571.286	1485038.610	3042.065	45°17'46.976060"N	114°36'13.688635"W	2996.4643	0.99983179	5/8" IR w/FHWA Alum Cap
					SPB3	1323688.426	1484961.659	3081.493	45°17'48.126902"N	114°36'14.777372"W	3035.8894	0.99982993	5/8" IR w/FHWA Alum Cap
					SPB4	1323232.170	1485090.399	3029.140	45°17'43.631740"N	114°36'12.928645"W	2983.5395	0.99983239	5/8" IR w/FHWA Alum Cap
					SPB5	1323435.001	1484594.656	3064.475	45°17'45.597615"N	114°36'19.884740"W	3018.8745	0.99983088	5/8" IR w/FHWA Alum 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
					0	0.000	0.000	0.000			0	0	0

PROJECT : Stoddard Bridge DATE OF FIELD WORK : May 2018 DATE OF FINAL ADJUSTMENT : May 2018

PROJECT UNITS : US SURVEY FOOT

COORDINATE SYSTEM :Idaho Central SPCS NAD83 2011

		STATE PLANE COORDINATES			GEO COORDINATES
	POINT
NUMBER	NORTH	EAST	ELEVATION	LATITUDE	LONGITUDE	ELLIPSOID
HEIGHT	COMBINED
FACTOR	DESCRIPTION
	SPB1	1323735.159	1484847.739	3074.538	45°17'48.579872"N	114°36'16.375910"W	3028.934	0.99983031	5/8" IR w/FHWA Alum Cap
	SPB2	1323571.286	1485038.610	3042.065	45°17'46.976060"N	114°36'13.688635"W	2996.464	0.99983179	5/8" IR w/FHWA Alum Cap
	SPB3	1323688.426	1484961.659	3081.493	45°17'48.126902"N	114°36'14.777372"W	3035.889	0.99982993	5/8" IR w/FHWA Alum Cap
	SPB4	1323232.170	1485090.399	3029.140	45°17'43.631740"N	114°36'12.928645"W	2983.540	0.99983239	5/8" IR w/FHWA Alum Cap
	SPB5	1323435.001	1484594.656	3064.475	45°17'45.597615"N	114°36'19.884740"W	3018.875	0.99983088	5/8" IR w/FHWA Alum Cap

File details come from the government source that posted it. Updated Mar 30, 2022.