AI Assistant
Notifications
Clear all

Excel Degree Mode

14 Posts
9 Users
0 Reactions
916 Views
Martin Paquette
(@martin-paquette)
Posts: 25
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
 

Hey, All,
My Quixotic project is to convince Microsoft (or any other spreadsheet maker) to add degree mode and all the standard related features to Excel, as you can find on any scientific calculator, like DMS to DEG. There are some good tricks and workarounds, but, come on, they should have added these features 20 years ago. I think it's because nobody is asking for them.


 
Posted : March 25, 2012 11:02 pm
SurveySEAK
(@surveyseak)
Posts: 4
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
 

I completely agree! I cannot believe they didn't add this function many many years ago!! I've seen where somebody wrote up some kind of subroutine for this, but it was so complicated I didn't want to spend the time and effort. Also, you have to convert all degrees to rads in order to get the sine, cosine and tangent! Has nobody at Microsoft studied geometry? I'm amazed at this.

I'll help the effort if I can.


 
Posted : March 26, 2012 12:27 am
jimcox
(@jimcox)
Posts: 2102
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
 

I wrote a free add-in that gives you the surveyor functionality of an HP41 in your spreadsheets.

I haven't updated it for the very latest Excel macro language, but I think it still works

Let me know if you want a copy...


 
Posted : March 26, 2012 2:08 am
Mark R
(@mark-r)
Posts: 302
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
 

I agree. Nice to see you posting Martin.


 
Posted : March 26, 2012 4:51 am
Mark R
(@mark-r)
Posts: 302
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
 

I would like a copy. My e-mail is in my profile. Have a great week all.


 
Posted : March 26, 2012 4:53 am

Geezer
(@geezer)
Posts: 218
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,

cud u snd me a copy 2??

thx,
geezer


 
Posted : March 26, 2012 11:16 am
spledeus
(@spledeus)
Posts: 2757
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
 

i'd like a copy too please

spledeus at c4 dot net

thanks


 
Posted : March 26, 2012 11:43 am
Martin Paquette
(@martin-paquette)
Posts: 25
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
 

Jim, Sounds like you've got a hot item there. Yes, I want a copy, too!


 
Posted : March 26, 2012 12:43 pm
jimcox
(@jimcox)
Posts: 2102
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
 

Happy to send you a copy - but I need your address ....


 
Posted : March 26, 2012 4:11 pm
ashton
(@ashton)
Posts: 566
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
 

Excel Degree MODE?

It seems to me that Excel has very few modes. I think one of the few is whether to follow the Windows version of date calculations, which incorrectly treats 1900 as a leap year, or the Macintosh version, which considers the date to be in 1904. Calculators don't usually receive data from people other than the owner, but spreadsheets are exchanged all the time. It isn't obvious how to create a mode that still allows exchange of spreadsheets among a fairly wide community.


 
Posted : March 27, 2012 11:12 am

amdomag
(@amdomag)
Posts: 654
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
 

Yes, I agree. This is the reason why I wrote an Excel add-in to handle angle value conversion.


 
Posted : March 28, 2012 10:17 am
amdomag
(@amdomag)
Posts: 654
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
 

This application is for local to grid transformation.


 
Posted : March 28, 2012 10:18 am
Ralph Perez
(@ralph-perez)
Posts: 1262
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
 

> Yes, I agree. This is the reason why I wrote an Excel add-in to handle angle value conversion.
>
>

Good Job:good:


 
Posted : March 28, 2012 11:14 am
amdomag
(@amdomag)
Posts: 654
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
 

Thank you Ralph.. 🙂


 
Posted : March 28, 2012 8:11 pm