Group:  Microsoft Excel ยป microsoft.public.excel.worksheet.functions
Thread: Trig functions

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

Trig functions
Kokopeelle 30.09.2006 03:41:01
I have been studing the early formation fo trig tables by Ptolemy abotu
100-200Ad. I now would like to know the methodolgy tht ecel uses for
calculating these functions. I'm not interested in the detailed code, just
the general methods.

Can anyone help?
--
rk koko pele
RE: Trig functions
paul 30.09.2006 06:58:01
the excel functions for trig are
COS
ACOS
ACOSH
COSH
SIN
ASIN
SINH
ASINH
TAN
ATAN
TANH
ATANH
RADIANS
DEGREES
excel works in radians by default so the radians and degree function are
there to swap back and forth
--
paul
paul.shepherd[ at ]nospamparadise.net.nz
remove nospam for email addy!



"Kokopeelle" wrote:

[Quoted Text]
> I have been studing the early formation fo trig tables by Ptolemy abotu
> 100-200Ad. I now would like to know the methodolgy tht ecel uses for
> calculating these functions. I'm not interested in the detailed code, just
> the general methods.
>
> Can anyone help?
> --
> rk koko pele
Re: Trig functions
"Bernard Liengme" <bliengme[ at ]stfx.TRUENORTH.ca> 30.09.2006 18:11:40
My bet is that Excel uses a series expansion
sin(x) = x -x^3/3! + x^5/5! - x^7/7! ...

Google on binomial, Taylor and Maclaurin series to learn more (or read a
math textbook)
best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Kokopeelle" <Kokopeelle[ at ]discussions.microsoft.com> wrote in message
news:AB9D0C9D-AAA9-4789-A588-AB6B7342DBD5[ at ]microsoft.com...
[Quoted Text]
>I have been studing the early formation fo trig tables by Ptolemy abotu
> 100-200Ad. I now would like to know the methodolgy tht ecel uses for
> calculating these functions. I'm not interested in the detailed code,
> just
> the general methods.
>
> Can anyone help?
> --
> rk koko pele


Re: Trig functions
"Dana DeLouis" <ddelouis[ at ]bellsouth.net> 30.09.2006 19:58:51
My guess would be some version of the "CORDIC algorithm."
One of many search hits:
http://www.dspguru.com/info/faqs/cordic2.htm (See 2.1)

http://www.andraka.com/cordic.htm
etc..
--
Dana DeLouis
Windows XP & Office 2003


"Bernard Liengme" <bliengme[ at ]stfx.TRUENORTH.ca> wrote in message
news:%23lV4hvL5GHA.940[ at ]TK2MSFTNGP03.phx.gbl...
[Quoted Text]
> My bet is that Excel uses a series expansion
> sin(x) = x -x^3/3! + x^5/5! - x^7/7! ...
>
> Google on binomial, Taylor and Maclaurin series to learn more (or read a
> math textbook)
> best wishes
>
> --
> Bernard V Liengme
> www.stfx.ca/people/bliengme
> remove caps from email
>
> "Kokopeelle" <Kokopeelle[ at ]discussions.microsoft.com> wrote in message
> news:AB9D0C9D-AAA9-4789-A588-AB6B7342DBD5[ at ]microsoft.com...
>>I have been studing the early formation fo trig tables by Ptolemy abotu
>> 100-200Ad. I now would like to know the methodolgy tht ecel uses for
>> calculating these functions. I'm not interested in the detailed code,
>> just
>> the general methods.
>>
>> Can anyone help?
>> --
>> rk koko pele
>
>


Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net