id-ef-nezpr2019-1-1_control-points.xlsx
XLSX spreadsheet 36 KB Posted
- Solicitation number
- 69056723B000004
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: | ID | Note: 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.10 | 1.0 | ||
| Title block text: | SURVEY CONTROL | |||
| Show Totals? | TRUE | |||
| Data location: | Assumed Data | Worksheet found | ||
| Data begins in col: | A | |||
| Min. rows/table | 5 | 3.0 | ||
| Base sheet name: | Sheet | 7 | rows w/data | OK - No spaces in data |
| Max. row/table | 36 | 10 | data rows | Warnings: Empty lines found within data set |
| 36 | rows/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 Name | Sheet | Header1 row | Header2 row | Sheet Number | Notes |
| Sheet | D.10 | 3 | FALSE | 10 | OK |
| Sheet (2) | Undefined | FALSE | FALSE | 10 | |
| Sheet (3) | Undefined | FALSE | FALSE | 10 | |
| Sheet (4) | Undefined | FALSE | FALSE | 10 | |
| Sheet (5) | Undefined | FALSE | FALSE | 10 | |
| Sheet (6) | Undefined | FALSE | FALSE | 10 | |
| Sheet (7) | Undefined | FALSE | FALSE | 10 | |
| Sheet (8) | Undefined | FALSE | FALSE | 10 | |
| Sheet (9) | Undefined | FALSE | FALSE | 10 | |
| Sheet (10) | Undefined | FALSE | FALSE | 10 | |
| Sheet (11) | Undefined | FALSE | FALSE | 10 | |
| Sheet (12) | Undefined | FALSE | FALSE | 10 | |
| Sheet (13) | Undefined | FALSE | FALSE | 10 | |
| Sheet (14) | Undefined | FALSE | FALSE | 10 | |
| Sheet (15) | Undefined | FALSE | FALSE | 10 | |
| Sheet (16) | Undefined | FALSE | FALSE | 10 | |
| Sheet (17) | Undefined | FALSE | FALSE | 10 | |
| Sheet (18) | Undefined | FALSE | FALSE | 10 | |
| Sheet (19) | Undefined | FALSE | FALSE | 10 | |
| Sheet (20) | Undefined | FALSE | FALSE | 10 | |
| Total Sheets: | 1 | 0 | sheets missing |
Revised: 15 June 2015
Sheet
| Sheet Information | |||||||||||||
| Sheet num: | D.10 | Filename | |||||||||||
| Sheet name: | Sheet | C:\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: | A | B | C | D | E | A | B | C | D | E |
PROJECT :Nez Perce 2019 ERFO DATE OF FIELD WORK :Multiple entries PROJECT UNITS : US survey foot
| PROJECT COORDINATES | ||||||||||
| 3.0 | POINT | |||||||||
| NUMBER | NORTH | EAST | ELEVATION | DESCRIPTION | FALSE | |||||
| Peasley FSR 469 mp.8 | ||||||||||
| 1 | 1516586.466 | 2608702.512 | 3216.209 | JUB cap | ||||||
| 2 | 1516278.491 | 2608561.410 | 3190.000 | JUB cap | ||||||
| Peasley FSR 469 mp 2.8 | ||||||||||
| 50 | 1526452.603 | 2610741.989 | 3691.918 | JUB cap | ||||||
| 51 | 1526108.854 | 2610740.054 | 3681.000 | JUB cap | ||||||
| Slate Creek FSR 354 mp 13.6 | ||||||||||
| CP1 | 1444432.416 | 2546688.908 | 4129.000 | JUB cap | ||||||
| CP2 | 1444633.363 | 2546586.520 | 4157.902 | JUB cap | ||||||
| CP3 | 1444673.784 | 2546626.565 | 4163.340 | JUB cap | ||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | ||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | ||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | ||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | ||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | ||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | ||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | ||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | ||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | ||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | ||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | ||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | ||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | ||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | ||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | ||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | ||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | ||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | ||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | ||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | ||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | ||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | ||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | ||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | ||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | ||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 |
Assumed Data PROJECT :Nez Perce 2019 ERFO DATE OF FIELD WORK :Multiple entries
PROJECT UNITS : US survey foot
| PROJECT COORDINATES | |||||
| POINT | |||||
| NUMBER | NORTH | EAST | ELEVATION | DESCRIPTION | |
| Peasley 469 0.8 | |||||
| 1 | 1516586.466 | 2608702.512 | 3216.209 | JUB cap | |
| 2 | 1516278.491 | 2608561.410 | 3190.000 | JUB cap | |
| Peasley 469 2.8 | |||||
| 50 | 1526452.603 | 2610741.989 | 3691.918 | JUB cap | |
| 51 | 1526108.854 | 2610740.054 | 3681.000 | JUB cap | |
| Slate creek 354 13.6 | |||||
| CP1 | 1444432.416 | 2546688.908 | 4129.000 | JUB cap | |
| CP2 | 1444633.363 | 2546586.520 | 4157.902 | JUB cap | |
| CP3 | 1444673.784 | 2546626.565 | 4163.340 | JUB cap |
File details come from the government source that posted it. Updated .