ptonsparky
Tom
- Occupation
- EC - retired
What is the Cos of 49?
My spreadsheet returns .301, but my example gives .6560.
My spreadsheet returns .301, but my example gives .6560.
COSINE
- Thread starter ptonsparky
- Start date
- Status
ptonsparky
Tom
- Occupation
- EC - retired
Thank you.
Believe it or not, I was one step away. Even had the Angle calculator up to convert degrees to radians, just before I decided to have a bowl of Cheerios.
Believe it or not, I was one step away. Even had the Angle calculator up to convert degrees to radians, just before I decided to have a bowl of Cheerios.
ptonsparky
Tom
- Occupation
- EC - retired
I bought a Bosch laser GLM 50C a year or so ago. Put it away so I wouldn't lose it. Needed it for the last two months, found it yesterday, now that I don't. Downloaded the app for it and started playing. HS Batman!
Nicest thing so far is its ability to send each measurement along with the angle of it to your phone.
Nicest thing so far is its ability to send each measurement along with the angle of it to your phone.
Carultch
Senior Member
- Location
- Massachusetts
Excel defaults to using radians as the units for the trig functions, as does Google Calculator. Most of the time, if you don't have a configuration setting that enables you to select this, your calculator will default to using radians. The preferred angle unit in mathematics, because of its elegant calculus.
I like how Google Calculator will enable you to type cos(49 degrees) to get your result. Or the reverse, "arccos(0.4) in degrees". You can even type in other angle units, as long as you specify them, and it will interpret it correctly. All you need to know, is to specify the units in the syntax.
With Excel, you need to know something about radians in the first place to even know how to get any trig function to take in degrees as the input. You would need to type in cos(radians(49)) to get the cosine of 49 degrees, and degrees(acos(0.4)) for the reverse. Either that, or you'd multiply your input by pi()/180 for trig, and your output by 180/pi() for inverse trig.
If it were my choice for how to improve Excel's syntax, I would recommended an optional second parameter to these functions, that takes in a string input to specify the angle unit. It would still default to radians, but would enable you to override this default with the syntax of cos(49, "deg").
I like how Google Calculator will enable you to type cos(49 degrees) to get your result. Or the reverse, "arccos(0.4) in degrees". You can even type in other angle units, as long as you specify them, and it will interpret it correctly. All you need to know, is to specify the units in the syntax.
With Excel, you need to know something about radians in the first place to even know how to get any trig function to take in degrees as the input. You would need to type in cos(radians(49)) to get the cosine of 49 degrees, and degrees(acos(0.4)) for the reverse. Either that, or you'd multiply your input by pi()/180 for trig, and your output by 180/pi() for inverse trig.
If it were my choice for how to improve Excel's syntax, I would recommended an optional second parameter to these functions, that takes in a string input to specify the angle unit. It would still default to radians, but would enable you to override this default with the syntax of cos(49, "deg").
ptonsparky
Tom
- Occupation
- EC - retired
I had the SS convert 49 to radians, then used that result.
The laser does all the work for you if you ‘click‘ in the correct order.
I wanted to check it.
Close enough.
The laser does all the work for you if you ‘click‘ in the correct order.
I wanted to check it.
Close enough.
When I make a spreadsheet I generally like degrees because it seems like the people I send them to like to use degrees.
On this spreadsheet l lock the cell with the formula =(49)*180/PI() and type “Degrees” either above that cell or beside it to avoid confusion.
I have used the DEGREES(49) function some also.
Some understand 45 degrees better than .785 rads
Carultch
Senior Member
- Location
- Massachusetts
DEGREES(49) does the reverse of what the OP is intending. As does (49)*180/PI(). These both translate 49 radians to degrees.
I'm well aware that most people probably understand degrees more than radians. Even having worked with plenty of applications where radians have the advantage, I still think in degrees.
I usually express radians when using power factor calcs. This is a section of a whole project :
| Power factor | |||||||||||
| ISK pf | (pu) | 0,740 | 0,740 | 0,740 | 0,740 | 0,740 | 0,740 | 0,740 | 0,740 | 0,740 | |
| ISK kW | (kW) | 336 | 321 | 299 | 270 | 234 | 189 | 135 | 72 | 0 | |
| ISK kVAr | (kVAr) | 305 | 292 | 272 | 245 | 212 | 171 | 123 | 66 | 0 | |
| Motor pf | (pu) | 0,646 | 0,699 | 0,744 | 0,781 | 0,810 | 0,834 | 0,852 | 0,865 | 0,875 | |
| Motor kW | (kW) | 1371 | 1487 | 1610 | 1737 | 1871 | 2011 | 2157 | 2310 | 2469 | |
| Motor kVAr | (kVAr) | 1620 | 1521 | 1445 | 1390 | 1353 | 1333 | 1328 | 1339 | 1366 | |
| PFC | (kVAr) | 1400 | 1400 | 1400 | 1400 | 1400 | 1400 | 1400 | 1400 | 1400 | |
| Total Supply kW | (kW) | 1035 | 1166 | 1310 | 1467 | 1638 | 1822 | 2022 | 2237 | 2469 | |
| Total kVAr | (kVAr) | 526 | 412 | 317 | 236 | 165 | 104 | 51 | 5 | -34 | |
| Total Supply kVA | (kVA) | 1179 | 1254 | 1364 | 1500 | 1658 | 1835 | 2030 | 2241 | 2469 | |
| Overall fund p.f | (pu) | 0,878 | 0,930 | 0,960 | 0,978 | 0,987 | 0,993 | 0,996 | 0,998 | 1,000 |
- Status