ahhill
Hi. This is quite a picky question, but maybe someone can help.
I have series of results out put to a file along with their respective errors, e.g.
3.80569 0.00037 9.54133 0.00115 138.18998 0.03175 87.96881 0.79130
3.81175 0.00103 9.57763 0.00430 139.15734 0.09783 92.03177 0.67083
3.81350 0.00112 9.56008 0.00505 139.03005 0.10975 91.14934 3.19837
3.81156 0.00110 9.55533 0.00481 138.81939 0.10634 86.96109 4.51236
Now, ideally I would like to attach the error to the last significant figure, and have it in parenthesis. e.g. 3.9189(3) is ± 3.9189 ± 0.0003 and 29(3) is 29 ±3. If the first significant figure of the e.s.d. is 1, then two significant figures should be used in the error. e.g. 4.20057(17) is 4.20057 ± 0.00017 and 52.7(14) is 52.7 ± 1.4.
The final result should look like this...
3.8057(4) 9.5413(12) 138.19(3) 88.0(8)
3.8118(10) 9.578(4) 139.16(10) 92.0(7)
3.8135(11) 9.560(5) 139.03(11) 91(3)
3.8116(11) 9.555(5) 138.82(11) 87(5)
Does anyone have some clever tricks to force the number of significant figures inthe topas output to get what I want?
Thanks
Adrian
alancoelho
The format sequence %V output two digit errors and there's no way of outputting just one digit.
Can I ask the reason for just one digit; isn't the usual to output two digits.
mfisch
Adrian,
I once wrote an excel sheet for this. Contact me by email and I will send it to you.
Regards,
Martin
@ Alan: ESD's of e.g. atomic coordinates, lattice parameters etc. are usually formatted as Adrian showed.
Edit: Sry, my file is the other way round, I used it for importing ShelX CIF's into Excel. It may give you an idea...
ahhill
Thanks Alan.
The reason I wanted the format as I did was that is they way I have been taught...
The number of significant figures in the experimental uncertainty is limited to one or (when the experimental uncertainty is small, e.g., ± 0.15) to two significant figures. You should not use more than two significant digits when stating the experimental uncertainty.
I'll work with %V.