North_of_moose_controlsheet.xlsx

XLSX spreadsheet 43 KB Posted Jan 24, 2019

Attached to: MT DOT 569 (3), North of Moose Creek North
Solicitation number: 69056718B000024
Issued by: Department of Transportation Federal Highway Administration

About this file

From the source

North of moose_controlsheet

View the file

Other files

File	Type	Posted
Bid_Opening_Summary.pdf	PDF	Mar 1, 2019
A003.pdf	PDF	Feb 25, 2019
A002.pdf	PDF	Feb 22, 2019
Q&A_02-22-19.pdf	PDF	Feb 22, 2019
Q&A_02-19-19.pdf	PDF	Feb 20, 2019
Q&A_02-14-19.pdf	PDF	Feb 15, 2019
Amendment_A001.pdf	PDF	Feb 14, 2019
Q&A_02-11-19.pdf	PDF	Feb 12, 2019
Q&A_02-07-19.pdf	PDF	Feb 8, 2019
Q&A_02-01-19.pdf	PDF	Feb 4, 2019
Q&A_01-28-19.pdf	PDF	Jan 31, 2019
Waterway_Hydraulics_Memo.pdf	PDF	Jan 24, 2019
Plan_Sheets_(R).pdf	PDF	Jan 24, 2019
mt-56903_XS_MAIN01(r2).pdf	PDF	Jan 24, 2019
MT_North_of_Moose_Creek_North_Pave_Memo_FINAL.pdf	PDF	Jan 24, 2019
mt-56903_XS_DETOUR01.pdf	PDF	Jan 24, 2019
SWPPP_MT_DOT_569(3)_North_of_Moose_Creek_North.pdf	PDF	Jan 24, 2019
California_Creek_Bridge_Inspection_Report.pdf	PDF	Jan 24, 2019
California_Creek_As-built.pdf	PDF	Jan 24, 2019
Attachment_2-_Site_Photographs.pdf	PDF	Jan 24, 2019
2016-04-25_Proj_002-490L_Bridge_Lead_Paint_Testing_Report_w_Attachments.pdf	PDF	Jan 24, 2019
2016-04-25_Proj_002-490_Bridge_Asbestos_Inspection_Report_wAtts.pdf	PDF	Jan 24, 2019
Attachment_2_-_LBP_Sample_Lab_Report.pdf	PDF	Jan 24, 2019
GM_31-17_North_Moose_Creek_Preliminary_Foundation_Recommendations__FINAL_1.pdf	PDF	Jan 24, 2019
GR_23-18_MT_DOT_569(3)_Final_Geotechnical_Report.pdf	PDF	Jan 24, 2019
GM18-18_Final_Bridge_Foundation_Recommendations_August_2018.pdf	PDF	Jan 24, 2019
GM19-17_North_Moose_Creek_Subsurface_Investigation_and_Prelim_Recomm_FINAL.pdf	PDF	Jan 24, 2019
California_Creek_Preliminary_Bridge_TS&L_Report.pdf	PDF	Jan 24, 2019
Attachment_1_-_Asbestos_Lab_Reports.pdf	PDF	Jan 24, 2019
mt-56903_Earthwork_MAIN01.pdf	PDF	Jan 24, 2019
Plan_Request_Form.pdf	PDF	Jan 24, 2019
IFB_Moose_Creek.pdf	PDF	Jan 24, 2019
Attachment_1-_Site_Photographs_Lead.pdf	PDF	Jan 24, 2019
mt-56903_Earthwork_DETOUR01.pdf	PDF	Jan 24, 2019
Prelim_Letter_Moose_Creek_North.pdf	PDF	Oct 30, 2018
PROJECT_DESCRIPTION_Moose_Creek.pdf	PDF	Oct 30, 2018
Preliminary_Plans.pdf	PDF	Oct 30, 2018

Show all 37

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:	MT	Note: If there is more than one project number, use <ALT><ENTER> to insert page break for additional lines.
	Project:	DOT 569(3)
NPS PMIS /

Drawing No:

Designed by:	WFLHD Survey
Date:	7/2016
Checked by:	WFLHD Survey
Date:	7/2016
First sheet #:	D.15	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	27	rows w/data	OK - no spaces in data
Max. row/table	40	27	data rows	Warnings:
		40	rows/table
			PROJECT :North of Moose Creek

DATE OF FIELD WORK :June 2016 DATE OF FINAL ADJUSTMENT :June 2016

PROJECT UNITS : International feet COORDINATE SYSTEM : Montana SPCS NAD83 1999

VERTICAL DATUM : NAVD88 based on Geoid99

GPK FILE DATED July 2016

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.15	3	15	OK
	Sheet (2)	Undefined	FALSE	15
	Sheet (3)	Undefined	FALSE	15
	Sheet (4)	Undefined	FALSE	15
	Sheet (5)	Undefined	FALSE	15
	Sheet (6)	Undefined	FALSE	15
	Sheet (7)	Undefined	FALSE	15
	Sheet (8)	Undefined	FALSE	15
	Sheet (9)	Undefined	FALSE	15
	Sheet (10)	Undefined	FALSE	15
	Sheet (11)	Undefined	FALSE	15
	Sheet (12)	Undefined	FALSE	15
	Sheet (13)	Undefined	FALSE	15
	Sheet (14)	Undefined	FALSE	15
	Sheet (15)	Undefined	FALSE	15
	Sheet (16)	Undefined	FALSE	15
	Sheet (17)	Undefined	FALSE	15
	Sheet (18)	Undefined	FALSE	15
	Sheet (19)	Undefined	FALSE	15
	Sheet (20)	Undefined	FALSE	15
	Total Sheets:	1	0	sheets missing

Revised: 15 June 2015

Sheet

Sheet Information

Sheet num:

D.15

Filename

Sheet name:

Sheet

c:\myfiles\pw_production\d0282702\[North of moose_controlsheet.xlsx]Sheet

Reference:

Time

10-Aug-2018 11:13 AM

Begin Column:

PROJECT :North of Moose Creek DATE OF FIELD WORK :June 2016 DATE OF FINAL ADJUSTMENT :June 2016 PROJECT UNITS : International feet COORDINATE SYSTEM : Montana SPCS NAD83 1999

VERTICAL DATUM : NAVD88 based on Geoid99 GPK FILE DATED July 2016

						STATE PLANE COORDINATES			GEO COORDINATES
	3.0				POINT
NUMBER	NORTH	EAST	ELEVATION	LATITUDE	LONGITUDE	ELLIPSOID
HEIGHT	COMBINED
FACTOR	DESCRIPTION		NOTE:
					16101	647063.416	1071692.046	6255.936	45°58'09.408855"N	113°01'46.388888"W	6215.934	0.99926006	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.
					16102	647779.774	1071903.795	6260.048	45°58'16.570896"N	113°01'43.849768"W	6220.0365	0.99925924	5/8" IR W/FHWA ALUM CAP
					16103	648417.325	1072348.451	6267.832	45°58'23.058950"N	113°01'37.964513"W	6227.8169	0.99925831	5/8" IR W/FHWA ALUM CAP
					16104	649346.861	1073036.443	6261.573	45°58'32.535882"N	113°01'28.821548"W	6221.5559	0.99925779	5/8" IR W/FHWA ALUM CAP
					16105	649791.373	1073355.177	6259.401	45°58'37.063199"N	113°01'24.594321"W	6219.3813	0.9992575	5/8" IR W/FHWA ALUM CAP
					16106	650130.868	1073791.044	6273.351	45°58'40.606334"N	113°01'18.642411"W	6233.3323	0.99925653	5/8" IR W/FHWA ALUM CAP
					16107	650424.286	1074308.627	6283.488	45°58'43.731024"N	113°01'11.504534"W	6243.4723	0.99925577	5/8" IR W/FHWA ALUM CAP
					16108	650720.637	1074916.901	6262.493	45°58'46.924741"N	113°01'03.084835"W	6222.4812	0.9992565	5/8" IR W/FHWA ALUM CAP
					16109	651180.241	1075609.000	6282.039	45°58'51.766150"N	113°00'53.582297"W	6242.0285	0.99925515	5/8" IR W/FHWA ALUM CAP
					16110	651489.278	1076262.508	6328.834	45°58'55.104688"N	113°00'44.529838"W	6288.8271	0.99925263	5/8" IR W/FHWA ALUM CAP
					16111	651759.712	1076824.869	6372.124	45°58'58.021820"N	113°00'36.742566"W	6332.1197	0.99925031	5/8" IR W/FHWA ALUM CAP
					16112	652232.161	1077353.829	6380.324	45°59'02.917213"N	113°00'29.555938"W	6340.3188	0.9992495	5/8" IR W/FHWA ALUM CAP
					16113	652901.022	1077811.434	6374.607	45°59'09.718840"N	113°00'23.503419"W	6334.5939	0.99924919	5/8" IR W/FHWA ALUM CAP
					16114	653688.493	1078292.586	6401.466	45°59'17.701050"N	113°00'17.192363"W	6361.4424	0.99924723	5/8" IR W/FHWA ALUM CAP
					16115	654414.222	1078789.093	6438.651	45°59'25.080764"N	113°00'10.624333"W	6398.6179	0.99924482	5/8" IR W/FHWA ALUM CAP
					16116	655045.186	1079197.836	6479.787	45°59'31.486636"N	113°00'05.238141"W	6439.7473	0.99924232	5/8" IR W/FHWA ALUM CAP
					16117	655487.981	1079492.360	6484.775	45°59'35.985466"N	113°00'01.349343"W	6444.7284	0.99924169	5/8" IR W/FHWA ALUM CAP
					16118	656467.329	1079973.531	6492.575	45°59'45.860512"N	112°59'55.157685"W	6452.5107	0.99924048	5/8" IR W/FHWA ALUM CAP
					16119	656869.120	1080437.720	6510.244	45°59'50.029472"N	112°59'48.840533"W	6470.1741	0.99923929	5/8" IR W/FHWA ALUM CAP
					16120	657364.065	1081188.478	6517.579	45°59'55.243679"N	112°59'38.525006"W	6477.5026	0.9992385	5/8" IR W/FHWA ALUM CAP
					16121	657848.223	1081755.521	6543.918	46°00'00.270338"N	112°59'30.803070"W	6503.833	0.99923682	5/8" IR W/FHWA ALUM CAP
					16122	658195.713	1082252.000	6554.226	46°00'03.917358"N	112°59'23.993503"W	6514.1338	0.99923602	5/8" IR W/FHWA ALUM CAP
					A15	642192.063	1070143.955	6157.295	45°57'20.657229"N	113°02'05.180453"W	6117.3636	0.99926904	MT DOT ALUM CAP
					A4909	648980.451	1072819.138	6275.393	45°58'28.824183"N	113°01'31.663078"W	6235.3763	0.99925745	MT DOT ALUM CAP
					E4909	646230.538	1071804.636	6257.382	45°58'01.241474"N	113°01'44.264514"W	6217.3987	0.99926071	MT DOT ALUM CAP
					F4909	645492.056	1071806.413	6227.172	45°57'53.956141"N	113°01'43.768315"W	6187.2038	0.99926278	MT DOT ALUM CAP
					H4909	643737.636	1071495.290	6193.947	45°57'36.508020"N	113°01'47.050777"W	6154.0097	0.9992659	MT DOT 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

PROJECT :North of Moose Creek DATE OF FIELD WORK :June 2016 DATE OF FINAL ADJUSTMENT :June 2016

PROJECT UNITS : International feet COORDINATE SYSTEM : Montana SPCS NAD83 1999

VERTICAL DATUM : NAVD88 based on Geoid99

GPK FILE DATED July 2016

		STATE PLANE COORDINATES			GEO COORDINATES
	POINT
NUMBER	NORTH	EAST	ELEVATION	LATITUDE	LONGITUDE	ELLIPSOID
HEIGHT	COMBINED
FACTOR	DESCRIPTION
	16101	647063.416	1071692.046	6255.936	45°58'09.408855"N	113°01'46.388888"W	6215.934	0.99926006	5/8" IR W/FHWA ALUM CAP
	16102	647779.774	1071903.795	6260.048	45°58'16.570896"N	113°01'43.849768"W	6220.037	0.99925924	5/8" IR W/FHWA ALUM CAP
	16103	648417.325	1072348.451	6267.832	45°58'23.058950"N	113°01'37.964513"W	6227.817	0.99925831	5/8" IR W/FHWA ALUM CAP
	16104	649346.861	1073036.443	6261.573	45°58'32.535882"N	113°01'28.821548"W	6221.556	0.99925779	5/8" IR W/FHWA ALUM CAP
	16105	649791.373	1073355.177	6259.401	45°58'37.063199"N	113°01'24.594321"W	6219.381	0.99925750	5/8" IR W/FHWA ALUM CAP
	16106	650130.868	1073791.044	6273.351	45°58'40.606334"N	113°01'18.642411"W	6233.332	0.99925653	5/8" IR W/FHWA ALUM CAP
	16107	650424.286	1074308.627	6283.488	45°58'43.731024"N	113°01'11.504534"W	6243.472	0.99925577	5/8" IR W/FHWA ALUM CAP
	16108	650720.637	1074916.901	6262.493	45°58'46.924741"N	113°01'03.084835"W	6222.481	0.99925650	5/8" IR W/FHWA ALUM CAP
	16109	651180.241	1075609.000	6282.039	45°58'51.766150"N	113°00'53.582297"W	6242.029	0.99925515	5/8" IR W/FHWA ALUM CAP
	16110	651489.278	1076262.508	6328.834	45°58'55.104688"N	113°00'44.529838"W	6288.827	0.99925263	5/8" IR W/FHWA ALUM CAP
	16111	651759.712	1076824.869	6372.124	45°58'58.021820"N	113°00'36.742566"W	6332.120	0.99925031	5/8" IR W/FHWA ALUM CAP
	16112	652232.161	1077353.829	6380.324	45°59'02.917213"N	113°00'29.555938"W	6340.319	0.99924950	5/8" IR W/FHWA ALUM CAP
	16113	652901.022	1077811.434	6374.607	45°59'09.718840"N	113°00'23.503419"W	6334.594	0.99924919	5/8" IR W/FHWA ALUM CAP
	16114	653688.493	1078292.586	6401.466	45°59'17.701050"N	113°00'17.192363"W	6361.442	0.99924723	5/8" IR W/FHWA ALUM CAP
	16115	654414.222	1078789.093	6438.651	45°59'25.080764"N	113°00'10.624333"W	6398.618	0.99924482	5/8" IR W/FHWA ALUM CAP
	16116	655045.186	1079197.836	6479.787	45°59'31.486636"N	113°00'05.238141"W	6439.747	0.99924232	5/8" IR W/FHWA ALUM CAP
	16117	655487.981	1079492.360	6484.775	45°59'35.985466"N	113°00'01.349343"W	6444.728	0.99924169	5/8" IR W/FHWA ALUM CAP
	16118	656467.329	1079973.531	6492.575	45°59'45.860512"N	112°59'55.157685"W	6452.511	0.99924048	5/8" IR W/FHWA ALUM CAP
	16119	656869.120	1080437.720	6510.244	45°59'50.029472"N	112°59'48.840533"W	6470.174	0.99923929	5/8" IR W/FHWA ALUM CAP
	16120	657364.065	1081188.478	6517.579	45°59'55.243679"N	112°59'38.525006"W	6477.503	0.99923850	5/8" IR W/FHWA ALUM CAP
	16121	657848.223	1081755.521	6543.918	46°00'00.270338"N	112°59'30.803070"W	6503.833	0.99923682	5/8" IR W/FHWA ALUM CAP
	16122	658195.713	1082252	6554.226	46°00'03.917358"N	112°59'23.993503"W	6514.1338	0.99923602	5/8" IR W/FHWA ALUM CAP
	A15	642192.063	1070143.955	6157.295	45°57'20.657229"N	113°02'05.180453"W	6117.3636	0.99926904	MT DOT ALUM CAP
	A4909	648980.451	1072819.138	6275.393	45°58'28.824183"N	113°01'31.663078"W	6235.3763	0.99925745	MT DOT ALUM CAP
	E4909	646230.538	1071804.636	6257.382	45°58'01.241474"N	113°01'44.264514"W	6217.3987	0.99926071	MT DOT ALUM CAP
	F4909	645492.056	1071806.413	6227.172	45°57'53.956141"N	113°01'43.768315"W	6187.2038	0.99926278	MT DOT ALUM CAP
	H4909	643737.636	1071495.29	6193.947	45°57'36.508020"N	113°01'47.050777"W	6154.0097	0.99926590	MT DOT ALUM CAP

File details come from the government source that posted it.