"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