Thank you so much Dimma!
It works, and is ever so much easier than copy-pasting all of that data by hand and sorting it into the correct columns. I really truly appreciate this.
Cheers,
--Riia
******************************************
Dr. Riia M. Chmielowski
Senior Research Engineer/Laboratory Manager
Laser-Ablation ICP-MS Laboratory, LTU
SE-971 87 Luleå, Sweden
www.ltu.se/LaserICPMS
Hours: Mon-Thurs 07:30-12:30 or by appointment
Email: [log in to unmask]
Phone: +46 (0)920 492033
Mobile: +46 72 539 07 76
Fax: +46-920-491199
LTU Room: F833
http://ltu-se.academia.edu/RiiaChmielowski
*****************************************
________________________________________
From: Dmitry Dolivo-Dobrovolsky <[log in to unmask]>
Sent: Friday, November 15, 2019 20:36
To: Metamorphic Studies Group; Riia Chmielowski
Subject: {Spam?} Re: script for pulling SEM wt% data out of Word docs?
Dear Riia
and all interested in this topic,
This is an example of more advanced Excel VBA version of the program for processing multiple (say, hundreds) MS Word documents containing tables with microprobe analyses. This program combines all data on Wt% of oxides or elements and creates a single transposed table. Commented open source.
Cheers,
Dima DD
Понедельник, 11 ноября 2019, 17:56 +03:00 от Riia Chmielowski <[log in to unmask]>:
Greetings,
I have been using a desktop SEM recently that exports the "spectrum details" as a Word document which contains an image showing the location of each recorded spectrum, another image showing the various peaks observed, and a table with the summary of the results.
I have been using copy-paste to take the numbers from the table into a spreadsheet so that I can make graphs showing the reported wt% of each element for all of the various phases in a sample that I looked at in a session, and all of the various samples for all of the sessions. I am finding that step to be the most time-consuming part of the project, and I can't help but think that it would be much faster if there were a script that could read all of the Word docs and pull the data from each table into either a spreadsheet or a database, labelled with the name of the source file, so that I could jump right to the part about looking at how the various results plot on the graphs.
However, before I approach programming friends to see if any would be willing to help me create such a script, I thought I would ask here: Do any of you already have such a script (or app or other program) that you might be willing to share? What do you do when you want to graph this sort of data?
Thanks,
--Riia, who understands that these numbers are semi-quantitative at best, but it would still be nice to see how the same phases from different samples compare to one another
******************************************
Dr. Riia M. Chmielowski
Senior Research Engineer/Laboratory Manager
Laser-Ablation ICP-MS Laboratory, LTU
SE-971 87 Luleå, Sweden
www.ltu.se/LaserICPMS<http://www.ltu.se/LaserICPMS>
Hours: Mon-Thurs 07:30-12:30 or by appointment
Email: [log in to unmask]<[log in to unmask]>
Phone: +46 (0)920 492033
Mobile: +46 72 539 07 76
Fax: +46-920-491199
LTU Room: F833
http://ltu-se.academia.edu/RiiaChmielowski
*****************************************
########################################################################
To unsubscribe from the GEO-METAMORPHISM list, click the following link:
https://www.jiscmail.ac.uk/cgi-bin/webadmin?SUBED1=GEO-METAMORPHISM&A=1
Dmitry Dolivo-Dobrovolsky
e-mail:
[log in to unmask]<mailto:[log in to unmask]>
[log in to unmask]<mailto:[log in to unmask]>
www:
http://www.dimadd.ru
http://ipgg.ru/staff/dolivo-dobrovolsky-dv
########################################################################
To unsubscribe from the GEO-METAMORPHISM list, click the following link:
https://www.jiscmail.ac.uk/cgi-bin/webadmin?SUBED1=GEO-METAMORPHISM&A=1
