coordinated of excel ad autocad

[dimasa]

Hello everyone,
I saw the tread at the link http://www.cad3d.it/forum1/threads/42502-creazione-di-un-blocco-su-coordinate-impostate-in-excelI have seen both the excel file, with reference to the page http://www.myengineeringworld.net/ both the other proposal with the excel file "creating blocks from excel.zip"

I don't understand aerophotogrammetry and coordinates, but I need to insert blocks into an aerophotogrammetry by taking this from the site of the geometries college.
I have coordinates provided to me on excel that refer to a particular point of the municipality, of the type "37.32825547985700 14.74298718055500" and at that point I should insert a block,
if I insert these coordinates in both files, they end up from anywhere other than the aerophotogrammetry plant.
Actually the point where I should place the block is located at the autocad coordinates "18790,2153 162658,3043" there is a formula to make them match?

or should I transfer the blocks, fix two certain points and then with a "alline" command align the blocks to the aerophotogrammetry?

Am I wrong with importing aerophotogrammetrics?

for the file "creating blocks from excel.zip" as well as the same problem of the coordinates, I would like to know if there is the possibility to use dynamic blocks allowing you to use the different display states, as well as give the necessary info to the attributes. .
I hope I've been clear, and that someone can help me, say hello

 

[Shape]

of aerofotogrammetrie I do not understand anything either, but of autocad yes.
geometries that matter if they are not georeferentiate (i.e. they take all or the same point as origin) it is difficult to shoot them randomly and hope they fall into the right place.

I think if the points of the excel fiel are right, try to put two of them and see the deviation that they have compared to the aerophotogrammetry and see the displacement and align the aerofotogrammetrie.
Then it should all come back.

be careful that the coordinates are really x and y and not other coordinate systems that are used in these fields.

 

[PlannerRoad]

......I would like that I do not understand of aerophotogrammetry and coordinates, but I need to insert blocks in an aerophotogrammetry taking this from the site of the college of geometries.
I have coordinates provided to me on excel that refer to a particular point of the municipality, of the type "37.32825547985700 14.74298718055500" and at that point I should insert a block,
if I insert these coordinates in both files, they end up from anywhere other than the aerophotogrammetry plant.
Actually the point where I should place the block is located at the autocad coordinates "18790,2153 162658,3043" there is a formula to make them match?

or should I transfer the blocks, fix two certain points and then with a "alline" command align the blocks to the aerophotogrammetry?

Am I wrong with importing aerophotogrammetrics? ....

the planephotogrammetrics to "overtake" must have the same coordinate system. if the systems are different these go "converted", of course knowing from what system of reference parts.

 

[Tristan]

I have some coordinates provided to me on excel that refer to a particular point of the municipality, of the type "37.32825547985700 14.74298718055500" and in that point I should insert a block, if I insert these coordinates in both files, they go to end from all the other part regarding the plan of the aerofotogrammetry. Actually the point where I should place the block is located at the autocad coordinates "18790,2153 162658,3043" there is a formula to make them match?

the first are most likely in latlong (magari detected with a palmarino gps); The second ones are, perhaps, in cassini-soldner.
we are talking about a geographical system vs projected system. So let it lose line...the two information without a conversion and reprojection will never match.