Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default matrix to mirror a point

Does anyone know of a generic matrix to mirror a point (x,y) about a line? I
can do this about the normal Cartesian axis but I would like to do it about a
user defined line (defined by 2 points).
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,393
Default matrix to mirror a point

Hi Paul,
I have done this in a very naive way:
1) translate the line so one point is at origin; use same translation on P
2) rotate the line by theta so it aligns with y-axis; use same rotation on P
3) generate the mirror of P (x of m = -x of p, y of m = y of p)
4) rotate everything by minus theta
5) translate by reverse amount of step 1
Hey presto, I have the old line and point plus the mirror of P
Send me private message and I will forward the file
Then you can do it in a more sophisticated way!
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Paul Jolley" wrote in message
...
Does anyone know of a generic matrix to mirror a point (x,y) about a line?
I
can do this about the normal Cartesian axis but I would like to do it
about a
user defined line (defined by 2 points).



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 947
Default matrix to mirror a point

... mirror a point (x,y) about a line? I
...I would like to do it about a user defined line (defined by 2 points).


Hi. If I understand your "mirror" point, is there anything here that can
help?
http://mathworld.wolfram.com/Point-L...mensional.html

What I'm thinking is that you know your perpendicular vector v (9), and you
can just double the distance given in (11).
The equation (11) appears to be correct, but I can only do it if I project r
onto v, and not v onto r as I believe it's written.
Note that the Determinate version in (13) is missing an implied {1,1,1} as
the third argument.
--
HTH :)
Dana DeLouis


"Paul Jolley" wrote in message
...
Does anyone know of a generic matrix to mirror a point (x,y) about a line?
I
can do this about the normal Cartesian axis but I would like to do it
about a
user defined line (defined by 2 points).



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mirror Image Printing (JSF) Joseph Ferraro Excel Discussion (Misc queries) 5 May 11th 07 06:36 PM
I need more general XY point to point plotting than XY scatter in spazminator Charts and Charting in Excel 12 December 19th 05 05:00 PM
Mirror spreadsheet? Rykar2 Excel Discussion (Misc queries) 4 November 12th 05 03:50 AM
Mirror Image nicol28 Excel Worksheet Functions 0 July 26th 05 01:19 AM
2 mirror files with :1 and :2 - why? DJR Excel Discussion (Misc queries) 3 March 21st 05 06:05 PM


All times are GMT +1. The time now is 11:12 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"