Notifications
Clear all

(Cool) Analytic Geometry For Surveyors

7 Posts
6 Users
0 Reactions
2 Views
(@scott-zelenak)
Posts: 600
Registered
Topic starter
 

Not that cool and geometry often find themselves in the same blurb.
But, as part of one project I began a spin off project which eventually morphed into something more than I intended, which lead to (in my opinion, at least) some cool geometry.
These are formulae I've cribbed and cropped from a number of now forgotten sources over more decades than I care to admit. I wish I could attribute properly, but I was less concerned with those notions early in my career.
I'm not particularly adept at Excel logic statements, so I'd expect some improvements could be made.
The logic statements will be in black cells with white text.
I'm now returning to my previously scheduled project, but I'd be indebted to anyone who could suggest improvements.

Attached files

SURVEY ANALYTIC GEOMETRY V_1.0.xlsx (47.7 KB) 

 
Posted : 04/09/2017 11:16 am
(@rj-schneider)
Posts: 2784
Registered
 

That is a cool project. It prompted me to go and purchase Excel 2016. Previously only had Apple's 'Numbers' software, which seems odd to work with.

 
Posted : 04/09/2017 5:35 pm
(@jim-frame)
Posts: 7277
 

R.J. Schneider, post: 445048, member: 409 wrote: It prompted me to go and purchase Excel 2016.

Note that LibreOffice (free) includes Calc, which is an Excel clone for all practical purposes. It's worked well for me for the year or so that I've been using it.

 
Posted : 05/09/2017 12:23 am
(@crashbox)
Posts: 542
Registered
 

Jim Frame, post: 445097, member: 10 wrote: Note that LibreOffice (free) includes Calc, which is an Excel clone for all practical purposes. It's worked well for me for the year or so that I've been using it.

I've used the LibreOffice suite for a few years now including Calc, and it has worked quite well for me also. Sure can't beat the cost of $0.00, either...

 
Posted : 05/09/2017 3:17 am
 jaro
(@jaro)
Posts: 1721
Registered
 

Really cool spreadsheet but mine is missing the Resection sheet. Was that deleted?

Thanks,
James

 
Posted : 05/09/2017 3:28 am
(@scott-zelenak)
Posts: 600
Registered
Topic starter
 

I'm still arranging the resection sheet.
But I'll post it when I'm done.

It suffers from resorting to the cotangent function twice.

 
Posted : 05/09/2017 4:25 am
(@mlschumann)
Posts: 132
Registered
 

Scott,
Wondering if "conversation" message I sent a while back went through? I've done logic analysis, in response to your post of September 4, in which you may have an interest. MLSchumann

 
Posted : 13/10/2017 7:53 am