Excel Closure Comps Example

Excel Closure Comps Example - BP Total Billable Payroll...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
FIELD NOTES SURVEY: (Name of survey here) SURVEYOR: (Your name here) # CW Field Meas. Meas. Crew Oper. # Describe operation Angle Distance Minutes (dec.) (ft) (sample not the same values as lecture -- you can erase these after seeing the system) 1 Setup SW conc mon 1 15 2 Backsight reference azimuth line to SE I.P. 0 300 3 3 Taped five house sides 5 10 4 Sideshot to house corner 330 125 1.25 5 Foresight NW I.P. 275.4 220 2.2 6 Setup NW IP 1 15 7 Backsight SW CM 0 225 2.25 8 Foresight to SE IP 300.2 340 3.4 9 Setup SE IP 1 15 10 Backsight NW IP 0 340 3.4 11 Foresight SW CM 320.5 300 3 Total Minutes 70.5
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Time and BE Cost Calculations Total Field Crew Minutes 70.5 (copied from FIELD NOTE sheet) FCH Field Crew Hours 1.175 Billable Payroll per member PC=FCH*Salary 23.5 INSTR = FCH*Salary 14.1 ROD = FCH*Salary 10.575 COMP/DRAFT=FCH*Sal/2 11.75 PROJ SURV = FCH*Sal/3 23.5 OWNER=FCH*Sal/10 11.75
Background image of page 2
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: BP Total Billable Payroll 95.175 =1.0 BP (add column) OVH Overhead 142.763 =1.5*BP BE Brkeven Cost (BP+OVH=2.5BP) 237.938 =2.5*BP (going fishing amount) Control Figure Coordinate and Closure Comps Control Figure NW IP SE IP SW CM 10,000N/10,000E Ref Az SE IP to SW CM = 270 Point Az In CW ang. Az Out Dist Out N E SW CM 270 275.4 365.4 220 10000 10000 NW IP 365.4 300.2 125.6 340 10219 10021 SE IP 125.6 320.5 266.1 300 10021 10297 Perim 860 10001 9997.85 should be 10000/10000 Err Clos. 0.69724-2.1472 Lin. Error Closure 2.25756 Ratio Closure 1: 380.942 OK by protractor and scale should be 1/200 or better If not, remeasure control figure angles and distances adding additional operations to field notes....
View Full Document

This note was uploaded on 10/17/2011 for the course SUR 4430 taught by Professor Staff during the Spring '08 term at University of Florida.

Page1 / 3

Excel Closure Comps Example - BP Total Billable Payroll...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online