+ Reply to Thread
Results 1 to 7 of 7

mathematical and calculation formula for angles

  1. #1
    Registered User
    Join Date
    08-27-2007
    MS-Off Ver
    microsoft office professional plus 2019
    Posts
    39

    mathematical and calculation formula for angles

    i have a problem at present. i have 2 problems.
    the 1st problem is i do not know the mathematical calculation or theory to work out what i need to know and therefore i have no idea how to write a formula for excel either.

    i will describe my issues and hope someone may be able to help.

    i have a block. length is 100mm and width is 50mm
    i have measured the block in all 4 corners to find the thickness of the block
    top left corner is 4.75mm
    top right corner is 4.77mm
    bottom left corner is 3.86mm
    bottom right corner is 3.89mm

    i would like to try and find out the angle differences accross the block
    so i would like to know what the angle is between the top left hand corner and the bottom left hand corner, the angle difference between the top right hand corner and the bottom right hand corner and i would also like to know what the angle difference is across the whole length of the block.

    if someone could help me with this it would be fantastic

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,803

    Re: mathematical and calculation formula for angles

    the 1st problem is i do not know the mathematical calculation or theory to work out what i need to know and therefore i have no idea how to write a formula for excel either.
    I can appreciate this problem. Since I find that I must first understand the math before I can hope to program the spreadsheet, I will first suggest some math/geometry/trigonometry tutorials:

    http://www.purplemath.com/modules/rghtprob.htm Perhaps the most important take away from this one is that the best first step in solving these problems will probably be a simple sketch of the problem. A quick sketch, labeling the knowns and unkowns will be useful in identifying the trigonometric/geometric relationships between the knowns and unkowns. If we assume that the sides of your box are rectangles, this might also include adding diagonals to make right triangles and so on.

    Since I expect basic trig will come into play, here's a quick look at the basic trig ratios: http://www.math-only-math.com/basic-...ic-ratios.html Each of these has an excel function associated with it http://office.microsoft.com/en-us/ex...944.aspx?CTT=1 Recognize that Excel (like almost all programming languages) deals with angles in radians, so you may need to dust off your recollection of the relationship between degrees and radians (and how to use the degrees() and radians() functions).

    Should be a fun (because I am just evil enough to think that math is fun) (devil smiley here) exercise and an opportunity to recall the math/geometry/trig you learned way back in high school.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Forum Expert
    Join Date
    05-01-2014
    Location
    California, US
    MS-Off Ver
    Excel 2010
    Posts
    1,795

    Re: mathematical and calculation formula for angles

    Quote Originally Posted by maestro_uk View Post
    i have a block. length is 100mm and width is 50mm
    i have measured the block in all 4 corners to find the thickness of the block
    top left corner is 4.75mm
    top right corner is 4.77mm
    bottom left corner is 3.86mm
    bottom right corner is 3.89mm

    i would like to try and find out the angle differences accross the block
    so i would like to know what the angle is between the top left hand corner and the bottom left hand corner, the angle difference between the top right hand corner and the bottom right hand corner and i would also like to know what the angle difference is across the whole length of the block.

    I find that "Dr Math" http://mathforum.org/dr.math/ask is very good about answering questions like this.

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: mathematical and calculation formula for angles

    A
    B
    C
    D
    1
    Height
    100
    2
    Width
    50
    3
    Corner Thicknesses
    4.75
    4.77
    4
    3.86
    3.89
    5
    Angles [deg]
    6
    TL to TR
    0.023
    B6: =DEGREES(ATAN(C3-B3)/B$2)
    7
    BL to BR
    0.034
    B7: =DEGREES(ATAN(C4-B4)/B$2)
    8
    9
    TL to BL
    -0.417
    B9: =DEGREES(ATAN(B4-B3)/B$1)
    10
    TR to BR
    -0.413
    B10: =DEGREES(ATAN(C4-C3)/B$1)
    11
    12
    TL to BR
    -0.364
    B12: =DEGREES(ATAN(C4-B3)/SQRT(B2^2+B1^2))


    Note that the top of the block is not flat.
    Last edited by shg; 08-09-2014 at 03:24 PM.
    Entia non sunt multiplicanda sine necessitate

  5. #5
    Forum Expert Crooza's Avatar
    Join Date
    10-19-2013
    Location
    Hunter Valley, Australia
    MS-Off Ver
    Excel 2003 /7/10
    Posts
    2,082

    Re: mathematical and calculation formula for angles

    Only thing to add to shg's post above is that the angle he gave you across the diagonal from BL to TR will be smaller than the angle across the diagonal if you took it from TL to BR due to the greater difference between the hieghts. His formula is still right of course you just need to decide which difference in Heights you require - the greatest difference for the greatest angle or the smallest difference for the smallest angle

  6. #6
    Registered User
    Join Date
    08-27-2007
    MS-Off Ver
    microsoft office professional plus 2019
    Posts
    39

    Re: mathematical and calculation formula for angles

    thanks for all the replies.

    i will take a look at some of the maths links as i do need to refresh my maths

    i will also look at shg's answer to see if i can reproduce this with some answers someone has given me now on paper also.

    but overall a big thank you to everyone who has replied in this forum.

    once again a big thank you

  7. #7
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: mathematical and calculation formula for angles

    You're welcome.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 03-05-2013, 03:42 PM
  2. Finding the Mathematical formula
    By CParnell in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-23-2010, 06:43 PM
  3. mathematical formula of rate
    By mich in forum Excel General
    Replies: 5
    Last Post: 07-12-2006, 05:54 AM
  4. [SOLVED] IS there a mathematical formula for NORMSINV?
    By SyBorg in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-19-2006, 01:55 PM
  5. Re: Please help with an excel mathematical formula
    By EduardoDon in forum Excel General
    Replies: 1
    Last Post: 08-04-2005, 01:23 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1