ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   geo rectify coordinates in vba (https://www.excelbanter.com/excel-programming/395450-geo-rectify-coordinates-vba.html)

paul[_17_]

geo rectify coordinates in vba
 

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.


Dave D-C[_3_]

geo rectify coordinates in vba
 
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 =----


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com