Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 28
Default 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.

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 176
Default 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 =----
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
How rectify the DATA Error [47 OF 94 33 F4 55] Bhaskar Excel Discussion (Misc queries) 1 July 11th 07 04:20 PM
CODE given: Please help to rectify the error Thulasiram[_2_] Excel Programming 5 January 14th 07 05:36 AM
Convert point coordinates - pixel coordinates Zorro[_3_] Excel Programming 1 June 1st 06 03:26 AM
Simple way to convert UTM ED50 coordinates to decimal coordinates? Dan[_38_] Excel Programming 8 July 11th 04 04:54 PM
Converting MouseDown Coordinates to Chart Point Coordinates Steve[_50_] Excel Programming 3 December 2nd 03 06:48 PM


All times are GMT +1. The time now is 01:08 PM.

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

About Us

"It's about Microsoft Excel"