Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() i want to write a VBA commands to place the two raw coordinates into the array Coord(2) and the four correction parameters into the array M(2,2) can anyone help?? p.s. the brackets are supposed to be one whole bracket around each of the two coordinates) In order to georectify a point given as x,y coordinates the points are represented by a vector ( 107.046) ( 450.234) the points are multiplied by a correction matrix ( 1034 205) ( -205 1086) and a translation vector added to the result. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
paul wrote:
i want to write a VBA commands to place the two raw coordinates into the array Coord(2) and the four correction parameters into the array M(2,2) can anyone help?? p.s. the brackets are supposed to be one whole bracket around each of the two coordinates) In order to georectify a point given as x,y coordinates the points are represented by a vector ( 107.046) ( 450.234) the points are multiplied by a correction matrix ( 1034 205) ( -205 1086) and a translation vector added to the result. On the sheet you can use MMULT and maybe MINVERSE; in VBA code you can use arrays and subroutines. AT what step do you have a question? ----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups ----= East and West-Coast Server Farms - Total Privacy via Encryption =---- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How rectify the DATA Error [47 OF 94 33 F4 55] | Excel Discussion (Misc queries) | |||
CODE given: Please help to rectify the error | Excel Programming | |||
Convert point coordinates - pixel coordinates | Excel Programming | |||
Simple way to convert UTM ED50 coordinates to decimal coordinates? | Excel Programming | |||
Converting MouseDown Coordinates to Chart Point Coordinates | Excel Programming |