Control Point Table.xlsx
XLSX spreadsheet 48 KB Posted
- Solicitation number
- 69056723B000010
About this file
This document contains a federal contract opportunity for highway construction services. The Oregon Department of Transportation is soliciting bids for a project on OR Route 58 between the Coast Fork Willamette River and Lower Salt Creek. The work includes resurfacing and bridge repairs along 35.88 miles of highway. There is also a 0.11 mile optional section. The contract is a firm fixed price agreement to be awarded through a sealed bid process. The estimated value is between $15-20 million. Interested vendors must register in the System for Award Management to view the full solicitation documents and details. The Federal Highway Administration is the sponsoring federal agency. Bids are due by the date specified in the solicitation.
View the file
Other files
Show all 34
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: | OR | Note: If there is more than one project number, use <ALT><ENTER> to insert page break for additional lines. | |
| Project: | DOT 18(1) | ||
| NPS PMIS / |
Drawing No:
| Designed by: | Dan Lautzenheiser | |||
| Date: | 1/1904 | |||
| Checked by: | ||||
| Date: | 1/1904 | |||
| First sheet #: | D.7 | 1.0 | ||
| Title block text: | SURVEY CONTROL TABLE | |||
| Show Totals? | TRUE | |||
| Data location: | Page 1 | Worksheet found | ||
| Data begins in col: | A | |||
| Min. rows/table | 5 | 3.0 | ||
| Base sheet name: | Sheet | 14 | rows w/data | OK - no spaces in data |
| Max. row/table | 40 | 14 | data rows | Warnings: |
| 40 | rows/table | |||
| PROJECT : OR DOT 18(1) |
DATE OF FIELD WORK : 09/10 2019
DATE OF FINAL ADJUSTMENT : October 2019
PROJECT UNITS : INTERNATIONAL FEET
COORDINATE SYSTEM : Modified State Plane (Ground) System
EPOCH DATE : 2010
VERTICAL DATUM : NAVD88 based on Geoid 03
GPK FILE DATED November 2019
| 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.7 | 3 | 7 | OK | |
| Sheet (2) | Undefined | FALSE | 7 | ||
| Sheet (3) | Undefined | FALSE | 7 | ||
| Sheet (4) | Undefined | FALSE | 7 | ||
| Sheet (5) | Undefined | FALSE | 7 | ||
| Sheet (6) | Undefined | FALSE | 7 | ||
| Sheet (7) | Undefined | FALSE | 7 | ||
| Sheet (8) | Undefined | FALSE | 7 | ||
| Sheet (9) | Undefined | FALSE | 7 | ||
| Sheet (10) | Undefined | FALSE | 7 | ||
| Sheet (11) | Undefined | FALSE | 7 | ||
| Sheet (12) | Undefined | FALSE | 7 | ||
| Sheet (13) | Undefined | FALSE | 7 | ||
| Sheet (14) | Undefined | FALSE | 7 | ||
| Sheet (15) | Undefined | FALSE | 7 | ||
| Sheet (16) | Undefined | FALSE | 7 | ||
| Sheet (17) | Undefined | FALSE | 7 | ||
| Sheet (18) | Undefined | FALSE | 7 | ||
| Sheet (19) | Undefined | FALSE | 7 | ||
| Sheet (20) | Undefined | FALSE | 7 | ||
| Total Sheets: | 1 | 0 | sheets missing |
Revised: 15 June 2015
Sheet
| Sheet Information | ||||||||||||
| Sheet num: | D.7 | Filename | 0 | |||||||||
| Sheet name: | Sheet | F:\6926.002 OR58 Retrofit Bridge Final Design\Docs\Excel\[Control Point Table.xlsx]Sheet | ||||||||||
| Reference: | Time | |||||||||||
| 5-Aug-2021 11:25 AM | ||||||||||||
| Begin Column: | A | B | C | D | E | F | G | H | I |
PROJECT : OR DOT 18(1)
DATE OF FIELD WORK : 09/10 2019
DATE OF FINAL ADJUSTMENT : October 2019 PROJECT UNITS : INTERNATIONAL FEET COORDINATE SYSTEM : Modified State Plane (Ground) System
EPOCH DATE : 2010
VERTICAL DATUM : NAVD88 based on Geoid 03 GPK FILE DATED November 2019
| STATE PLANE COORDINATES | GEO COORDINATES | ||||||||||||||
| 3.0 | POINT | ||||||||||||||
| NUMBER | NORTH | EAST | ELEVATION | LATITUDE | LONGITUDE | ELLIPSOID | |||||||||
| HEIGHT | COMBINED | ||||||||||||||
| FACTOR | DESCRIPTION | NOTE: | |||||||||||||
| BRIDGE 05286 COAST FORK | 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. | |||||||||||||
| 19101 | 53804.890 | 70744.060 | 496.820 | N43°58'58.52307" | W122°58'19.73874" | 419.83 | 0.9999756402 | 2.5IN AC WFLHD 19101 | |||||||
| 19102 | 53602.540 | 71272.120 | 498.580 | N43°58'56.67959" | W122°58'12.43823" | 421.58 | 0.9999754287 | 2.5IN AC WFLHD 19102 | |||||||
| 19103 | 53271.000 | 71764.180 | 503.110 | N43°58'53.55023" | W122°58'05.57795" | 426.11 | 0.9999749966 | 2.5IN AC WFLHD 19103 | |||||||
| 19104 | 52796.450 | 72422.660 | 501.760 | N43°58'49.05742" | W122°57'56.38526" | 424.76 | 0.9999747512 | 2.5IN AC WFLHD 19104 | |||||||
| 19105 | 52544.240 | 72954.160 | 500.940 | N43°58'46.72231" | W122°57'49.01822" | 423.92 | 0.9999746305 | 2.5IN AC WFLHD 19105 | |||||||
| 19106 | 52175.080 | 73405.810 | 497.660 | N43°58'43.20949" | W122°57'42.69576" | 420.65 | 0.9999745448 | 2.5IN AC WFLHD 19106 | |||||||
| BRIDGE 07894 BARNARD | |||||||||||||||
| 19141 | 64248.600 | 188962.000 | 1081.000 | N43°44'45.00391" | W122°30'58.58572" | 1006.25 | 0.9998972475 | 2.5IN AC WFLHD 19141 | |||||||
| 19142 | 64399.000 | 189518.710 | 1088.580 | N43°44'46.62102" | W122°30'51.05364" | 1013.76 | 0.9998969677 | 2.5IN AC WFLHD 19142 | |||||||
| 19143 | 64525.320 | 190124.830 | 1092.440 | N43°44'48.01196" | W122°30'42.84069" | 1017.68 | 0.9998968486 | 2.5IN AC WFLHD 19143 | |||||||
| 19144 | 64729.000 | 190715.430 | 1093.190 | N43°44'50.16283" | W122°30'34.86422" | 1018.43 | 0.9998969181 | 2.5IN AC WFLHD 19144 | |||||||
| 19145 | 64910.110 | 191280.550 | 1094.760 | N43°44'52.08471" | W122°30'27.22734" | 1020.01 | 0.9998969368 | 2.5IN AC WFLHD 19145 | |||||||
| 19146 | 64947.610 | 191792.420 | 1094.660 | N43°44'52.57601" | W122°30'20.26856" | 1019.91 | 0.9998969659 | 2.5IN AC WFLHD 19146 | |||||||
| 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 : OR DOT 18(1)
DATE OF FIELD WORK : 09/10 2019
DATE OF FINAL ADJUSTMENT : October 2019
PROJECT UNITS : INTERNATIONAL FEET
COORDINATE SYSTEM : Modified State Plane (Ground) System
EPOCH DATE : 2010
VERTICAL DATUM : NAVD88 based on Geoid 03
GPK FILE DATED November 2019
| STATE PLANE COORDINATES | GEO COORDINATES | ||||||||
| POINT | |||||||||
| NUMBER | NORTH | EAST | ELEVATION | LATITUDE | LONGITUDE | ELLIPSOID | |||
| HEIGHT | COMBINED | ||||||||
| FACTOR | DESCRIPTION | ||||||||
| BRIDGE 05286 COAST FORK | |||||||||
| 19101 | 53804.89 | 70744.06 | 496.82 | N43°58'58.52307" | W122°58'19.73874" | 419.83 | 0.9999756402 | 2.5IN AC WFLHD 19101 | |
| 19102 | 53602.54 | 71272.12 | 498.58 | N43°58'56.67959" | W122°58'12.43823" | 421.58 | 0.9999754287 | 2.5IN AC WFLHD 19102 | |
| 19103 | 53271 | 71764.18 | 503.11 | N43°58'53.55023" | W122°58'05.57795" | 426.11 | 0.9999749966 | 2.5IN AC WFLHD 19103 | |
| 19104 | 52796.45 | 72422.66 | 501.76 | N43°58'49.05742" | W122°57'56.38526" | 424.76 | 0.9999747512 | 2.5IN AC WFLHD 19104 | |
| 19105 | 52544.24 | 72954.16 | 500.94 | N43°58'46.72231" | W122°57'49.01822" | 423.92 | 0.9999746305 | 2.5IN AC WFLHD 19105 | |
| 19106 | 52175.08 | 73405.81 | 497.66 | N43°58'43.20949" | W122°57'42.69576" | 420.65 | 0.9999745448 | 2.5IN AC WFLHD 19106 | |
| BRIDGE 07894 BARNARD | |||||||||
| 19141 | 64248.6 | 188962 | 1081 | N43°44'45.00391" | W122°30'58.58572" | 1006.25 | 0.9998972475 | 2.5IN AC WFLHD 19141 | |
| 19142 | 64399 | 189518.71 | 1088.58 | N43°44'46.62102" | W122°30'51.05364" | 1013.76 | 0.9998969677 | 2.5IN AC WFLHD 19142 | |
| 19143 | 64525.32 | 190124.83 | 1092.44 | N43°44'48.01196" | W122°30'42.84069" | 1017.68 | 0.9998968486 | 2.5IN AC WFLHD 19143 | |
| 19144 | 64729 | 190715.43 | 1093.19 | N43°44'50.16283" | W122°30'34.86422" | 1018.43 | 0.9998969181 | 2.5IN AC WFLHD 19144 | |
| 19145 | 64910.11 | 191280.55 | 1094.76 | N43°44'52.08471" | W122°30'27.22734" | 1020.01 | 0.9998969368 | 2.5IN AC WFLHD 19145 | |
| 19146 | 64947.61 | 191792.42 | 1094.66 | N43°44'52.57601" | W122°30'20.26856" | 1019.91 | 0.9998969659 | 2.5IN AC WFLHD 19146 |
File details come from the government source that posted it. Updated .