"Dan McGarigle" wrote:
Well, now I need two more solutions
I'll summarize of all of the formulas in the document.
F10, kappa: =TAN( PI()/2 - PI()/C10 )
H10, theta: =DEGREES( ATAN( SQRT( (2*E10/D10)^2 + F10^2 ) ) )
J10, phi: =DEGREES( ATAN( 2*E10 / (D10*F10) ) )
K10, tau:
=DEGREES( ATAN( 1 / ( TAN(RADIANS(J10)) * COS(RADIANS(H10)) ) ) )
L10, b: =SQRT( E10^2 + (D10*F10/2)^2 )
M10, 90-tau: =DEGREES( PI()/2 - RADIANS(K10) )
N10, r from a: =D10 / ( 2 * SIN( PI()/C10 ) )
O10, r: 2
P10, a from r: =2 * O10 *SIN( PI()/C10 )
"90-tau" is the complement of tau ("t sub c"). The formula can be
simplified significantly, namely:
M10, 90-tau: =90 - K10
FYI, the function ATAN(y/x) can be replace by ATAN2(x,y). That can be
confusing. But the tau formula might be easier to read by using ATAN2:
K10, tau:
=DEGREES( ATAN2( TAN(RADIANS(J10)) * COS(RADIANS(H10)), 1) )
"r from a" computes the radius "r" of a circle that circumscribes the
pyramid face base "a".
Alternatively, if you fill in "r" in O10, "a from r" computes the face base
"a" of a pyramid that is circumscribed by the circle of radius "r".
----- original message -----
"Dan McGarigle" wrote in message
...
Dear JoeU2004
Well, now I need two more solutions which are
1) The equation # 4 regarding tau = tan-1( 1 / tan(Phi)*(cos(Theta)))
is giving me fits.
My best attempt to do it in Excel is
=DEGREES(ATAN((1/(TAN(J10)*COS(H10)))))
where J10 = 73.9, and H10 = 80.90.
But that statement in Excel gives me the result of -5.6630
and not the correct result of 61.29.
and
2) The Saw Angle equation in Figure 3 regarding (Tau sub C = ( pi /
2 ) -
Tau )
is one that I can't even approach yet. My attempt with
=DEGREES((PI()/2)-Tau) of course doesn't work.
Can you help me get these last two into Excel from the document at
http://pages.swcp.com/awa/images/pdf%20files/Angle.pdf
Many thanks for any advise or help.
Dan
"JoeU2004" wrote:
"Dan McGarigle" wrote:
3. I got this and other formulas from the pdf at
http://pages.swcp.com/awa/images/pdf%20files/Angle.pdf
[....]
4. Given n(number of sides)=6 in Cell C10,
a(length of a base leg)=2 in Cell D10,
and h(height of the pyramid)=6 in Cell E10,
then the Excel statement
=DEGREES(ATAN((2*E10)*(D10*F10))) is not giving the predicted value of
73.90
I presume that F10 is k (kappa), a constant that is dependent on the
number
of sides, namely:
=TAN( PI()/2 - PI()/C10 )
Then phi, the angle the face triangle makes from the horizontal plane of
the
pyramid base, is:
=DEGREES( ATAN( 2*E10 / D10 / F10 ) )
or if you prefer:
=DEGREES( ATAN( 2*E10 / (D10*F10) ) )
----- original message -----
"Dan McGarigle" wrote in message
...
September 7, 2009 11:30PM PST
Dear JoeU2004
There are 4 replies in this note, from least to most significant, which
are -
1. I can't use the Microsoft news server because my ISP doesn't support
news
groups ( i.e. they (Time Warner Road Runner) don't provide any NNTP
server.
so the help at the cpearson site is no help to me.
2. In answer to your well taken point, the formula is used to calculate
the
"base-to-a-side" angle in degrees, as part of a set of formulas that
calculate the wood cut bevel cut and side-cutting angles for the sides
of
a
wood
pyramid of "h=height", and "a=length of a leg of the base of a
pyramid",
for
a pyramid of "X number of sides".
I am something of a cabinet maker and the capability to easily
calculate
all
the angles and lengths for a pyramid that can have any number of sides
is
quite a good thing for me.
PS My use of the word "times" is indicative of a multiplication such as
(three "times" four equals twelve).
3. I got this and other formulas from the pdf at
http://pages.swcp.com/awa/images/pdf%20files/Angle.pdf
I have been referring to 'Formula # 2' in that document,
which gives the graphic representation of the equation.
4. Given n(number of sides)=6 in Cell C10,
a(length of a base leg)=2 in Cell D10,
and h(height of the pyramid)=6 in Cell E10,
then the Excel statement
=DEGREES(ATAN((2*E10)*(D10*F10))) is not giving the predicted value of
73.90
degrees and I am stumped by that.
Can you help in any way with this ?
Thanks !!
Dan
"JoeU2004" wrote:
"Dan McGarigle" wrote:
Can you please tell me the steps to access the Microsoft news server
?
Does the following help?
http://www.cpearson.com/excel/HintsA...roupUsers.aspx
----- original message -----
"Dan McGarigle" wrote in
message
...
Dear JoeU2004
I have tried to use Internet Explorer 6 to access the "you can post
to
the
MSnews server directly" by using the URL
"http://msnews.microsoft.com/"
but I get only an error message that says "Cannot connect to the
server".
Can you please tell me the steps to access the Microsoft news server
?
Thanks !
Dan
"JoeU2004" wrote:
"Dan McGarigle" wrote:
How do I post a question that needs to show an equation that
won't
be
visually coherent when viewed by this text composer/viewer.
You appear to be using the MS Discussion Groups web interface. To
my
knowledge, you cannot post attachments. I believe you are limited
to
text
in your postings.
If you can use Outlook Express (Windows Mail in Vista) or Outlook
(I
believe), you can post to the MSnews server directly. Then you can
add
attachments. I presume the attachments, and maybe even the entire
posting,
are not visible to experts who use MSDG or Google Groups.
(Surprisingly,
some do.) But I think the majority of knowledgable people access
the
MSnews
server directly. There should be sufficient critical mass for you
to
get
some helpful responses.
But what is it about your "equation" (formula?) that makes you
think
it
cannot be viewed "coherently" in a text-only article?
Perhaps a viable alternative would be to copy-and-paste the formula
from
the
Formula Bar, and for anything that is not "coherent" in English
text,
perhaps you could just explain them, if they are relevant to your
question.
In fact, if they are not relevant to your question, perhaps you
could
reduce
your problem to a formula that __can__ be posted "coherently" in
English
text without any special work.
If you do not get any satisfactory suggestions, as a last resort,
you
can
send your Excel workbook to me with an explanation in email. If
nothing
else, I might be able to find a way for you to post the salient
information
in a text-only article. Send the workbook to joeu2004 "at"
hotmail.com.
PS: Other knowledgable people in these forums know how to post
"attachments" to public web sites; then you can put the URL into a
text-only
posting here. One of those people might be a better choice than I
to
help
you one-on-one. That's why I would consider myself a "last
resort".
----- original message -----
"Dan McGarigle" wrote in
message
...
Dear Excel
How do I post a question that needs to show an equation that
won't
be
visually coherent when viewed by this text composer/viewer.
Can I send a .jpg that shows the equation to someone ?
Thanks !
Dan