id-ef-nezpr2019-1-1_control-points.xlsx

XLSX spreadsheet 36 KB Posted

Attached to
ID ERFO NEZPR 117 2019-1(1), Nez Perce-Clearwater 2019 Repairs
Solicitation number
69056723B000004
Issued by

About this file

This document contains a survey control point list and related federal contract opportunity details. The survey control point list is provided in Excel format and contains coordinate and description data for control points to be used on a project. The related federal contract opportunity is solicitation number 69056723B000004 from the Department of Transportation Federal Highway Administration for repairs on ID ERFO NEZPR 117 2019-1(1) in Nez Perce-Clearwater. The solicitation seeks survey and construction services to complete repairs and includes details on response dates and award timing.

View the file

Other files

Show all 12

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

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:IDNote: If there is more than one project number, use <ALT><ENTER> to insert page break for additional lines.
Project:ERFO FS NEZPR117_2019-1(1)
NPS PMIS /

Drawing No:

Designed by:A. Designer
Date:1/1904
Checked by:D. Checker
Date:1/1904
First sheet #:D.101.0
Title block text:SURVEY CONTROL
Show Totals?TRUE
Data location:Assumed DataWorksheet found
Data begins in col:A
Min. rows/table53.0
Base sheet name:Sheet7rows w/dataOK - No spaces in data
Max. row/table3610data rowsWarnings: Empty lines found within data set
36rows/table
PROJECT :Nez Perce 2019 ERFO

DATE OF FIELD WORK :Multiple entries

PROJECT UNITS : US survey foot COORDINATE SYSTEM : Assumed (scaled to resemble Idaho West State Plane) VERTICAL DATUM : Assumed

Sheet Names
Input the names of the worksheets in the order you would like the sheets numbered.
Worksheet NameSheetHeader1 rowHeader2 rowSheet NumberNotes
SheetD.103FALSE10OK
Sheet (2)UndefinedFALSEFALSE10
Sheet (3)UndefinedFALSEFALSE10
Sheet (4)UndefinedFALSEFALSE10
Sheet (5)UndefinedFALSEFALSE10
Sheet (6)UndefinedFALSEFALSE10
Sheet (7)UndefinedFALSEFALSE10
Sheet (8)UndefinedFALSEFALSE10
Sheet (9)UndefinedFALSEFALSE10
Sheet (10)UndefinedFALSEFALSE10
Sheet (11)UndefinedFALSEFALSE10
Sheet (12)UndefinedFALSEFALSE10
Sheet (13)UndefinedFALSEFALSE10
Sheet (14)UndefinedFALSEFALSE10
Sheet (15)UndefinedFALSEFALSE10
Sheet (16)UndefinedFALSEFALSE10
Sheet (17)UndefinedFALSEFALSE10
Sheet (18)UndefinedFALSEFALSE10
Sheet (19)UndefinedFALSEFALSE10
Sheet (20)UndefinedFALSEFALSE10
Total Sheets:10sheets missing

Revised: 15 June 2015

Sheet

Sheet Information
Sheet num:D.10Filename
Sheet name:SheetC:\MyFiles\Projects_2023\Idaho\Nez_Perce_ERFO\control\[Nez_Perce_2019_erfo_controlsheet.xlsx]Sheet
Reference:Time
10-Apr-2023 10:04 AM
Begin Column:ABCDEABCDE

PROJECT :Nez Perce 2019 ERFO DATE OF FIELD WORK :Multiple entries PROJECT UNITS : US survey foot

PROJECT COORDINATES
3.0POINT
NUMBERNORTHEASTELEVATIONDESCRIPTIONFALSE
Peasley FSR 469 mp.8
11516586.4662608702.5123216.209JUB cap
21516278.4912608561.4103190.000JUB cap
Peasley FSR 469 mp 2.8
501526452.6032610741.9893691.918JUB cap
511526108.8542610740.0543681.000JUB cap
Slate Creek FSR 354 mp 13.6
CP11444432.4162546688.9084129.000JUB cap
CP21444633.3632546586.5204157.902JUB cap
CP31444673.7842546626.5654163.340JUB cap
00.0000.0000.0000
00.0000.0000.0000
00.0000.0000.0000
00.0000.0000.0000
00.0000.0000.0000
00.0000.0000.0000
00.0000.0000.0000
00.0000.0000.0000
00.0000.0000.0000
00.0000.0000.0000
00.0000.0000.0000
00.0000.0000.0000
00.0000.0000.0000
00.0000.0000.0000
00.0000.0000.0000
00.0000.0000.0000
00.0000.0000.0000
00.0000.0000.0000
00.0000.0000.0000
00.0000.0000.0000
00.0000.0000.0000
00.0000.0000.0000
00.0000.0000.0000
00.0000.0000.0000
00.0000.0000.0000
00.0000.0000.0000

Assumed Data PROJECT :Nez Perce 2019 ERFO DATE OF FIELD WORK :Multiple entries

PROJECT UNITS : US survey foot

PROJECT COORDINATES
POINT
NUMBERNORTHEASTELEVATIONDESCRIPTION
Peasley 469 0.8
11516586.4662608702.5123216.209JUB cap
21516278.4912608561.4103190.000JUB cap
Peasley 469 2.8
501526452.6032610741.9893691.918JUB cap
511526108.8542610740.0543681.000JUB cap
Slate creek 354 13.6
CP11444432.4162546688.9084129.000JUB cap
CP21444633.3632546586.5204157.902JUB cap
CP31444673.7842546626.5654163.340JUB cap

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