AI Assistant
Notifications
Clear all

(Cool) Analytic Geometry For Surveyors

7 Posts
6 Users
0 Reactions
396 Views
scott-zelenak
(@scott-zelenak)
Posts: 601
Member
Topic starter
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
 

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 : September 4, 2017 1:16 pm
rj-schneider
(@rj-schneider)
Posts: 2780
Member
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
 

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 : September 4, 2017 7:35 pm
jhframe
(@jim-frame)
Posts: 7465
Member
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
 

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 : September 5, 2017 2:23 am
Crashbox
(@crashbox)
Posts: 545
Member
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
 

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...


The only superior evidence is that which you haven't yet found.

 
Posted : September 5, 2017 5:17 am
jaro
 jaro
(@jaro)
Posts: 1722
Member
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
 

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

Thanks,
James


 
Posted : September 5, 2017 5:28 am

scott-zelenak
(@scott-zelenak)
Posts: 601
Member
Topic starter
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
 

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 : September 5, 2017 6:25 am
MLSchumann
(@mlschumann)
Posts: 134
Member
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
 

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 : October 13, 2017 9:53 am