View previous topic :: View next topic |
Author |
Message |
primus96
Joined: 13 Nov 2003 Posts: 225 Location: Yorkshire, United Kingdom
|
Posted: Tue Jun 01, 2004 1:13 pm Post subject: |
|
|
I have just been roasting my little grey cells with the formulae below
Excel: =TAN(RADIANS(B/2))*(A*2)
Lotus 1-2-3: @TAN(@DEGTORAD(B/2))*(A*2)
In the spreadsheet 'A' is the focal length in mm and 'B' is the angle of view in degrees.
You need two rows and four columns, the formula is in the third and the output is in the fourth.
You format the fourth cloumn to be a number without any decimal places. |
|
Back to top |
|
 |
Nick
Joined: 16 Oct 2002 Posts: 494
|
Posted: Tue Jun 01, 2004 8:28 pm Post subject: |
|
|
Quote: |
On 2004-06-01 06:09, RichS wrote:
[
And remember, spreadsheet calculate in radians, not degrees!
|
What I did was add a constant. This way the user can input degrees and the formula still gets radians. Just one constant to add
0.0174532925
Nick |
|
Back to top |
|
 |
Dave
Joined: 05 Dec 2003 Posts: 78 Location: Canada
|
Posted: Tue Jun 01, 2004 9:44 pm Post subject: |
|
|
Hey, I'm such a Neanderthal, I still have a slide rule, too. Only mine's a Pickett: 100% stainless steel. Pickett slide rules went to the moon, you know. (Along with Has***blad and Tang).
I don't know if you guys know this, so shout at me if I'm stating the obvious-- I just discovered this a little while ago. You can use Google as a calculator, and it does trig functions too. I think it defaults to radians, but if you key in, for example, tan(45 degrees), you'll get the right answer.
Radians. Hell, I can't even remember when I last thought about radians. |
|
Back to top |
|
 |
Dave
Joined: 05 Dec 2003 Posts: 78 Location: Canada
|
Posted: Wed Jun 02, 2004 1:44 am Post subject: |
|
|
And another thing, while I'm thinking about it. "Eurynar" is a hell of a name for a lens, isn't it? Sounds like something you'd find in the men's room, in Japan. |
|
Back to top |
|
 |
glennfromwy
Joined: 29 Nov 2001 Posts: 903 Location: S.W. Wyoming
|
Posted: Wed Jun 02, 2004 7:11 pm Post subject: |
|
|
No, Dave - Japan is an Asian country. Eurynars are found in France.
_________________ Glenn
"Wyoming - Where everybody is somebody else's weirdo" |
|
Back to top |
|
 |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
|