Here is another one that works similar to the spreadsheet by Radek:

https://www.researchgate.net/publication/331716635_X-Y_Coordinate_Transformation_Spreadsheet_from_Kuehn_Froese_2010_Tephra_from_Ice

Best regards,

- Steve




On 5/6/21 6:55 AM, Michallik Radoslaw (GTK) wrote:
>
> Hi there,
>
> I’ve made an excel sheet that converts different coordinates with the help of two references.
>
> Unfortunately it does not account for the change in z-direction.
>
> This sheet is made for 4 samples.
>
> It is important to use the same sample code for the references and further down for the individual spots (see red names in excel), otherwise it will not show the result. You fill the new references from the new instrument into the corresponding green fields.
>
> What this excel does is basically checking if the references have been rotated and then converting that rotation into a matrix, with which it recalculates the individual point positions. Then it compares, which “shifting vectors” for ref1 and ref2 are the same within a small error, and shows this results in the START-tab. I included a little coordinate system to check that all went fine. The margin of error for the shift-vector can be adjusted in the “calculation”-tab (I marked it yellow).
>
> To get around the problem to recognize whether the rotation was larger than 180 degrees I had to implement a second calculation, which is basically the first+180 for the matrix.
>
> This sheet works fine for all sorts of coordinate system conversion (JEOL to CAMECA and other SEM instruments like Hitachi, etc.) and for both round mounts and thin/thick sections, regardless of clockwise or anticlockwise rotation.
>
> I know this is not what you want, but maybe it helps the one or another user out there. 😊
>
> If you have any questions, do not hesitate to email me.
>
> Kind regards and greetings from the cold North!
>
> -Radek
>
> *Radoslaw Michallik*
>
> Researcher
>
> Circular Economy Solutions
>
> Geological Survey of Finland GTK
>
> Vuorimiehentie 2K, FI-02150 Espoo, Finland
>
> Tel. +358 29 503 0345, +358 50 340 9701
>
> [log in to unmask] <mailto:[log in to unmask]>
>
> www.gtk.fi <http://www.gtk.fi/> I @GTK.fi <https://twitter.com/GTK_FI>​
>
> The Geological Survey of Finland provides solutions for more sustainable growth.
>
> /For Earth and for Us./
>
> 42013601469558
>
> *From:*JEOL-Focused Probe Users List <[log in to unmask]> *On Behalf Of *John Spratt
> *Sent:* 06 May 2021 10:55
> *To:* [log in to unmask]
> *Subject:* [PROBEUSERS] Position file (*.pos) flags
>
> Hi All, I am currently setting up a workflow which will generate a JEOL microprobe software (EPMA JXA_8530F+)  *.pos file so that I can import analysis points from an external source (similar to that produced by the specimen navigator software), this works fine apart from one thing. I would like to set the auto focus to "on" for each point and set the spot size to a particular size. Are there any flags that can be set within the *.pos file to do this. The alternative is to drive to each point and manually set this for each point, which in a 400 point file will be tedious. (I would also be interested in other options available that can be set within this file format). Please note I am only running the supplied JEOL software.
>
> Thanks John Spratt
>
> **** JEOL Probe Users Listserver
>
> Moderator: Anette von der Handt, [log in to unmask] <mailto:[log in to unmask]>, Electron Microprobe Lab, University of Minnesota
>
> Post a message: send your message to [log in to unmask] <mailto:[log in to unmask]>
>
> Unsubscribe: send "SIGNOFF PROBEUSERS" to [log in to unmask] <mailto:[log in to unmask]>
>
> On-line help and FAQ: http://probelab.geo.umn.edu/jeoluserlist.html <http://probelab.geo.umn.edu/jeoluserlist.html>
>
> *
>
> **** JEOL Probe Users Listserver
>
> Moderator: Anette von der Handt, [log in to unmask] <mailto:[log in to unmask]>, Electron Microprobe Lab, University of Minnesota
>
> Post a message: send your message to [log in to unmask] <mailto:[log in to unmask]>
>
> Unsubscribe: send "SIGNOFF PROBEUSERS" to [log in to unmask] <mailto:[log in to unmask]>
>
> On-line help and FAQ: http://probelab.geo.umn.edu/jeoluserlist.html <http://probelab.geo.umn.edu/jeoluserlist.html>
>
> *
>
-- 

----------------
Dr. Stephen C. Kuehn
Associate Professor
Manager, Electron Microprobe Facility & Tephra Lab
Science building, Room 106

Concord University
1000 Vermillion St
PO Box 1000, Campus Box F20
Athens, WV 24712-1000

[log in to unmask]  [log in to unmask]
304-384-6322

http://academics.concord.edu/sckuehn/
http://academics.concord.edu/microanalysis/
https://www.researchgate.net/profile/Stephen_Kuehn
ORCID ID orcid.org/0000-0002-2918-980X
ResearcherID A-4946-2016


****
JEOL Probe Users Listserver

Moderator: Anette von der Handt, [log in to unmask],
Electron Microprobe Lab, University of Minnesota

Post a message: send your message to [log in to unmask]

Unsubscribe: send "SIGNOFF PROBEUSERS" to [log in to unmask]

On-line help and FAQ: http://probelab.geo.umn.edu/jeoluserlist.html

*