+ Reply to Thread
Results 1 to 5 of 5

Bolt Pattern Rotation

  1. #1
    Registered User
    Join Date
    05-26-2015
    Location
    Indianapolis, Indiana
    MS-Off Ver
    2010
    Posts
    3

    Bolt Pattern Rotation

    Guys, I need to create a spreadsheet that takes the X and Y coordinates of a bolt pattern, rotates the pattern by an given angle and outputs the new X, Y values. Does anyone know the formula for this task?


    Thank you.

  2. #2
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,364

    Re: Bolt Pattern Rotation

    You seem to assume that everybody here is familiar with a bolt pattern, what it looks like, which cells it occupies, etc. Otherwise, you would include a sample file or at least a screen shot.

  3. #3
    Registered User
    Join Date
    05-26-2015
    Location
    Indianapolis, Indiana
    MS-Off Ver
    2010
    Posts
    3

    Re: Bolt Pattern Rotation

    Here is a photo of a similar scenario.

    1031_1.gif

  4. #4
    Registered User
    Join Date
    05-26-2015
    Location
    Indianapolis, Indiana
    MS-Off Ver
    2010
    Posts
    3

    Re: Bolt Pattern Rotation

    Here is the spreadsheet:

    Capture2.JPG

  5. #5
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    14,587

    Re: Bolt Pattern Rotation

    I would suggest that, before we get into the Excel programming, we start with some geometry from way back in secondary school.

    1) the Unit circle (IMO, one of the very key concepts to understanding these kind of problems) http://www.intmath.com/blog/mathemat...roduction-5166
    2) From the unit circle, we get to the concept of "polar coordinates".
    x=r*cos(t) -- y=r*sin(t) where r is the radius and t is the angle (in radians, since Excel and almost all other programming languages do trigonometry in radians).

    So, for each of your points, you can use basic algebra to get r and t for each point. It should be reasonably obvious, for this case that r is 3.0000. t for hole 1 is 0, t for hole 2 is pi/2, t for hole 3 is pi, t for hole 4 is 3pi/2. (if none of that is obvious, spend some time with the unit circle tutorial).

    Displacing/rotating around the center is a simple matter of adding the desired angle (remember that counterclockwise movement is positive and clockwise movement is negative -- again, refer to the unit circle tutorial for this convention) to t, then computing the new x and y for the new points. So, if we rotate CCW through pi/4 radians (45 deg), the new t for hole 1 is x=3*cos(t1+pi/4)=3*cos(0+pi/4), y=3*sin(t1+pi/4)=3*sin(0+pi/4).

    If you have any questions about Excel's implementation of the trig functions refer here: https://support.office.com/en-US/art...rs=en-US&ad=US
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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. shift rotation pattern
    By ashintoms in forum Excel General
    Replies: 0
    Last Post: 04-22-2015, 05:06 AM
  2. [SOLVED] Lookup and return rows based on pattern start and pattern end
    By JDI in forum Excel General
    Replies: 18
    Last Post: 11-16-2014, 11:44 PM
  3. Copy down hypertext cell range pattern & cell reference formula pattern
    By Underexcelling in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-10-2014, 03:23 AM
  4. Code for third party bolt ons
    By cmb80 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-02-2011, 05:56 AM

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