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