AI Assistant
Notifications
Clear all

Global to Local Coordinate excel sheet

4 Posts
4 Users
0 Reactions
1,308 Views
Silversabre
(@silversabre)
Posts: 42
Free
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
 

Anyone have a excel spreadsheet that can covert global to a local coordinate grid? I have a calculator program for doing this but i'm losing faith in the ability of this calculator and would like an excel program as a back check.

I'm in the UK and work on 'stakeout' so if setting out anything on a grid or square prefer to convert to an appropriate local grid, makes my life alot easier when setting out alone too


 
Posted : June 4, 2011 1:23 pm
Martin F
(@martin-f)
Posts: 219
Free
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
 

> ... global to a local coordinate grid?

Assuming you're talking about grids that are parallel, do you wish to do simple rotate-scale-translate?
While it's not a spreadsheet, Copan will do that for you (and a lot more other cogo stuff), it can import/export CSV files, and it's free.


 
Posted : June 4, 2011 4:59 pm
Cliff Mugnier
(@cliff-mugnier)
Posts: 1220
Free
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
 

If you Google AUSLIG - Australian Land Information Group, I believe you will find a number of geodetic EXCEL programs that do quite similar things, if not exactly what you're looking for.

I think they have changed the name of their government agency, but it's still easy to find with Google.


 
Posted : June 6, 2011 2:16 pm
tim-reed
(@tim-reed)
Posts: 104
Free
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 have one in excel that an intern wrote for me years ago. It works with transverse mercator projections only. You can define a TM though anywhere on the planet.


 
Posted : June 6, 2011 5:56 pm