I got distracted and wrote a Excel spreadsheet - using the NIST database from calczaf - in which you can type an element and it will give you the L-value. Or more useful you can type an L-value and it will give you the x-ray and list the adjacent x-rays - useful for checking interferences - when you don't have the L-value book to hand. I've uploaded in case its any use to anyone. Minimum intensity x-rays listed 0.5-1%.
The l-values are in pretty good agreement with JEOL published values usually within 0.02-4 mm. I presume the not complete agreement is due to not enough decimals within the 2d values for the crystals - values taken from Jeol L-value book.
2d
TAP 25.757
PET 8.742
LIF 4.0267
Quote from: Ben Buse on July 02, 2015, 01:15:05 AM
I got distracted and wrote a Excel spreadsheet - using the NIST database from calczaf - in which you can type an element and it will give you the L-value. Or more useful you can type an L-value and it will give you the x-ray and list the adjacent x-rays - useful for checking interferences - when you don't have the L-value book to hand. I've uploaded in case its any use to anyone. Minimum intensity x-rays listed 0.5-1%.
Hi Ben,
Very nice.
This spreadsheet is complemented by the CalcZAF X-Ray | Calculate Spectrometer Position menu dialog which includes refractive index effects for spectrometer positions as described here:
http://smf.probesoftware.com/index.php?topic=375.msg1979#msg1979
Quote from: Ben Buse on July 02, 2015, 01:15:05 AM
The l-values are in pretty good agreement with Jeol published values usually within 0.02-4 mm. I presume the not complete agreement is due to not enough decimals within the 2d values for the crystals - values taken from JEOL L-value book.
The reason for the discrepancy is that JEOL is not using the NIST table as a starting point.
Quote from: Ben Buse on July 02, 2015, 01:15:05 AM
I got distracted and wrote a Excel spreadsheet - using the NIST database from calczaf...
Hi Ben,
Feel free to also post (attach) the .xlsm file. That is the Excel file that contains the actual macro code.
john
I just realised a better way of doing the same thing. I just discovered excel can filter tables.
Using the filter function you can specify the element of interest, or L-value range etc...
In the screen shot attached I have a filter for LIF between 124-144 mm. AND Z bettween 5-26.
I've also added a field where you specify x-ray of interest (Fe Ka1) and xtal (LIF) [the green box] - and it calculates the difference in L-value between interfering element and the element of interest
Ben
Just updated "Lvale Table complete.xlsx" complete table from calczaf and LDE's
(https://smf.probesoftware.com/gallery/453_23_03_17_1_56_03.png)
Modify spreadsheet to include all lines (not just intensity >1%).
This has all >0.1%. Excited by 25kV beam. Between 0.5 and 90 Angstrom. All higher orders upto XX.