MSD Chemstation reported decimal places

[surfergirl19uk]

Hi all,

I have tried doing a search and haven't found exactly what I'm looking for, but apologies if this has already been covered.

I'm running MSD Chemstation version D.01.02.16 and need to change the Enhanced Data Analysis from exporting 2 decimal places into its CSV files and onto the printouts to giving us 3 decimal places - can anyone tell me how I'd do this please? I should point out (fromseeing other topics on here) that I am looking at the number of decimal places reported in the concentration result once quantitated, rather than the masses).
I've seen a suggestion to change from using µg/mL to mg/mL, which I could do, but this would mean more changes to our LIMS system than I'd like to make! Someone on site previously changed another system to report 3 decimal places, but she has now left!
I have tried the instructions for editing epa.mac for Enviroquant but that didn't seem to work.

Many thanks,

Steph

[tlahren]

which CSV file are you working with for your LIMS system? are you using the Quant.csv file that is created by the QT command?

[surfergirl19uk]

Hi,

it's the Quant.csv generated from the File>Export Data to CSV File option, with multiple data files going into the same csv file.

Steph

[tlahren]

I believe the Quant.csv is created with the macro C:\MSDChem\msmacros\csv.mac. You will have to edit the format in here.

You probably know this song-and-dance already but you look for places where it says "format" and it will have a generic list of the columns "peak number, name, area (or repsonse), Amount, etc.
Look for the #.## in the Amount column and change it to #.### in all places for Amount. This should do the trick.

We had the same problem with our Import to LIMS, but I haven't edited it in a long time so I'm sorry if I've left anything out. You can try me with more questions though if you need.

Hope it helps.

[tlahren]

Also, you can use the QT,,"C" command in a custom tool to export your EPA quant results to the Quant.csv file instead of going to File/Export to CSV. You can also use it in the "DOLIST" to create the Quant.csv files for multiple files at once. However, if you are exporting multiple files at once this probably won't save you much time. It's just nice to have it in the custom tool bar.

Just for information.

[surfergirl19uk]

Hi,

thanks very much for that, that worked perfectly (after a bit of trial and error with getting all of the instances changed!).

Steph