excel - Land Surveyor Forum - Land Surveyors United - Global Surveying Community2024-03-29T01:06:45Zhttps://landsurveyorsunited.com/forum/topics/feed/tag/excelThe Excel Resection by Angles Computationhttps://landsurveyorsunited.com/forum/topics/the-excel-resection-by-angles-computation2023-06-02T19:10:30.000Z2023-06-02T19:10:30.000ZRichard Petteyhttps://landsurveyorsunited.com/surveyors/RichardPettey<div><p><span style="font-size:14pt;">The Excel Resection by Angles Computation is a surveying calculation method used to determine the coordinates of an unknown point (station) by measuring angles and distances from three or more known points (reference objects or ROs) with known coordinates.</span></p><p><span style="font-size:14pt;"><a href="https://app.spaceli.io/space/1XWFzgT89VxHnJLNCVlbEIov3s3Ht015d/page/1GLOY13AvIiVPlhN1JqSJsCK3fAzwGoC5ds-_rYsZNmY"><img class="align-center" src="{{#staticFileLink}}11289436699,RESIZE_710x{{/staticFileLink}}" alt="The Excel Resection by Angles Computation" /></a></span></p><p><span style="font-size:14pt;">The input data required for this computation include the measured azimuth, the known coordinates of the reference objects (ROs), and the angles observed between the ROs and the unknown point (station).</span></p><p><span style="font-size:14pt;">The computation involves several steps, including converting the measured azimuth to a computed bearing, calculating the interior angles between the ROs and the unknown point, and applying trigonometric functions to determine the unknown point's coordinates.</span></p><p><span style="font-size:14pt;">The computation is performed using an Excel spreadsheet, which simplifies the calculations and allows for easy manipulation of the input data and results.</span></p><p><span style="font-size:14pt;">It is important to note that the known RO coordinates must be entered or observed in a clockwise direction to ensure the correct computation of the interior angles.</span></p><p> </p><div class="embed-container"><iframe style="border:0;"></iframe></div></div>Area Calculation for Road Works Spreadsheethttps://landsurveyorsunited.com/forum/topics/area-calculation-for-road-works-spreadsheet2020-05-04T05:45:58.000Z2020-05-04T05:45:58.000ZSalama Shurrabhttps://landsurveyorsunited.com/surveyors/SalamaShurrab<div><p><a href="{{#staticFileLink}}4708635078,original{{/staticFileLink}}">Common shapes Area calculation with tabname &Trunc Function.xlsm</a></p><p> </p><p>Common shapes areas that can be used in road works to calculate the area of executed works.</p><p> </p><p>Don't hesitate to contact for update.</p><p> </p><p>Thanks</p></div>Survey Checklisthttps://landsurveyorsunited.com/forum/topics/survey-checklist2011-01-30T23:17:01.000Z2011-01-30T23:17:01.000ZJaybirdhttps://landsurveyorsunited.com/surveyors/Jaybird<div><p><a href="{{#staticFileLink}}1200616675,original{{/staticFileLink}}" target="_self"><img class="align-right" src="{{#staticFileLink}}1200616675,original{{/staticFileLink}}" width="32" /></a>The following document is a Surveying Checklist for use in the field.  You can find in in excel format, to download in PDF form below.  Enjoy!</p>
<p> </p>
<p> </p>
<p> </p>
<p><a target="_self"><img class="align-full" src="{{#staticFileLink}}1200616894,original{{/staticFileLink}}" alt="land survey checklist" width="100%" /></a></p>
<p> </p>
<p> </p>
<p>Feel free to modify this checklist and share new variations below in the comments.</p>
<p><strong>TIP:</strong> Simply import the form into your Google Documents and change what you like according to other needs, then "Publish As HTML" under "Share button". Take the code provided and embed it below in the HTML Editor.</p>
<p> </p>
<p><a href="{{#staticFileLink}}1578541912,original{{/staticFileLink}}" target="_blank" rel="noopener">Download SurveyChecklist.pdf</a></p>
<iframe src="https://docs.google.com/viewer?url={{#staticFileLink}}1578541912,original{{/staticFileLink}}&embedded=true" frameborder="0" height="500px" width="100%"></iframe>
</div>