Bodo Mysliwietz
2010-11-19 17:43:12 UTC
Dear friends and users of complex gas chromatography
over a period of more than 2 years I have successively developed an
MS-Excel tool for complex GC systems such as
- 2-column serial (backflush)
- Series-parallel (detector splitting)
- [Serial-Parallel]-[series-parallel] with up to 3 detectors
Overview of the functionality of the three calculation sheets:
============================================
- Carrier gases: H2, He (**), Ar, N2
- Calculation of the typically middle linear velocity (more precisely,
the linear speed at half off column length)
- Consideration of the interface lengths and temperatures of the
detectors (all freely definable)
- Freely settable detector internal pressure (vacuum for MS to 250kPa
absolute)
- Freely settable atmospheric pressure in a range from 50kPa to 150kPa
(50hPa to 1500hPa, absolute)
- Calculation of column flow rates and linear velocities, taking into
account the pressures applied to unions/split devices by electronic
pressure regulators
- Calculation of the static back pressure (equilibrium) to the
respective unions/split devices
- Calculation of a "hypothetical column length" depending on the
software reference pressure (eg MS software usually calculates vs.
vacuum only), with the aim of the reliable calculation of the injection
port split ratio
- for each column, there is a graphical plot of the gradient of the
linear speed records along the column, additionally calculated the real
rate at 0.5% and 99.5% of column length, the (real) average linear
velocity and RSD based on the average.The calculations/graphics always
cover the total column length including interfaces and/or detector adaptor.
- ** Completely different from any software I know: when using quartz
columns (fused silica) and Helium as carrier gas at high temperatures,
the pressure drop, caused by Helium permeation, is calculated optionally
(the column wall thickness must be known). This loss is also taken into
account in the calculation of linear velocity, average pressures and
output streams.
- the backflush tool and detector splitting tool have got a prediction
table for temperature ramped analysis. This table supports the user to
set up pressure ramps for constant linear velocity or constant flow
mode, whereas the permeation loss, hypothetical column length (and
detector splitting ratio) os calculated for each of the 20 steps. Of
course, the same is calculatedfor constant pressure mode.
- additionally the back flush and split tool include a "flow-mode
wizard" of the necessary head pressure for a desired linear velocity or
column flow at initial temperature.
- Calculation Tools for the one-dimensional detector and
multi-dimensional GC calculate split ratios either in consideration of
the He-permeability **
- The tool takes into account the 1st. detector in the 1st GC and 2
detectors (split) on the 2nd GC. For all three detectors is the internal
pressure (as above) definable. Thus, 1 to 3 atmospheric detectors (eg,
FID) or 0 to 3 MS (or any other pressures) are calculated.
- in multi-dimensional tool once the rel. split ratio calculated at each
division connectors, but additionally the overall ratio of the injected
sample amount on each detector (Total Split) -> eg FID1 = 62.6%; FID2 =
34.6%, MS = 2.8% (total. 100% of the injected sample on the column) is
calculated.
Full screenshots and a 14-day trial version, with full functionality,
can be downloaded from my (german written) website:
http://www.labortechniker.de/BoGaChrom/BoGaChrom_detail.html
The Excel spreadsheet is incorporated in an encrypted executable file
(*exe). After a double click on the file, Excel will be launched and it
can be used as normal Excel application but calculation formulas cannot
be seen or modified. Changes like parameters or column dimension can be
stored in the exe-file.
The executable file does not make any changes (installations) on the HDD
or registry.
!!!Be aware that the tool is for free, not for commercial use and that I
don’t guarantee for its correctness somehow or other!!!
Excuse for my bad English.
over a period of more than 2 years I have successively developed an
MS-Excel tool for complex GC systems such as
- 2-column serial (backflush)
- Series-parallel (detector splitting)
- [Serial-Parallel]-[series-parallel] with up to 3 detectors
Overview of the functionality of the three calculation sheets:
============================================
- Carrier gases: H2, He (**), Ar, N2
- Calculation of the typically middle linear velocity (more precisely,
the linear speed at half off column length)
- Consideration of the interface lengths and temperatures of the
detectors (all freely definable)
- Freely settable detector internal pressure (vacuum for MS to 250kPa
absolute)
- Freely settable atmospheric pressure in a range from 50kPa to 150kPa
(50hPa to 1500hPa, absolute)
- Calculation of column flow rates and linear velocities, taking into
account the pressures applied to unions/split devices by electronic
pressure regulators
- Calculation of the static back pressure (equilibrium) to the
respective unions/split devices
- Calculation of a "hypothetical column length" depending on the
software reference pressure (eg MS software usually calculates vs.
vacuum only), with the aim of the reliable calculation of the injection
port split ratio
- for each column, there is a graphical plot of the gradient of the
linear speed records along the column, additionally calculated the real
rate at 0.5% and 99.5% of column length, the (real) average linear
velocity and RSD based on the average.The calculations/graphics always
cover the total column length including interfaces and/or detector adaptor.
- ** Completely different from any software I know: when using quartz
columns (fused silica) and Helium as carrier gas at high temperatures,
the pressure drop, caused by Helium permeation, is calculated optionally
(the column wall thickness must be known). This loss is also taken into
account in the calculation of linear velocity, average pressures and
output streams.
- the backflush tool and detector splitting tool have got a prediction
table for temperature ramped analysis. This table supports the user to
set up pressure ramps for constant linear velocity or constant flow
mode, whereas the permeation loss, hypothetical column length (and
detector splitting ratio) os calculated for each of the 20 steps. Of
course, the same is calculatedfor constant pressure mode.
- additionally the back flush and split tool include a "flow-mode
wizard" of the necessary head pressure for a desired linear velocity or
column flow at initial temperature.
- Calculation Tools for the one-dimensional detector and
multi-dimensional GC calculate split ratios either in consideration of
the He-permeability **
- The tool takes into account the 1st. detector in the 1st GC and 2
detectors (split) on the 2nd GC. For all three detectors is the internal
pressure (as above) definable. Thus, 1 to 3 atmospheric detectors (eg,
FID) or 0 to 3 MS (or any other pressures) are calculated.
- in multi-dimensional tool once the rel. split ratio calculated at each
division connectors, but additionally the overall ratio of the injected
sample amount on each detector (Total Split) -> eg FID1 = 62.6%; FID2 =
34.6%, MS = 2.8% (total. 100% of the injected sample on the column) is
calculated.
Full screenshots and a 14-day trial version, with full functionality,
can be downloaded from my (german written) website:
http://www.labortechniker.de/BoGaChrom/BoGaChrom_detail.html
The Excel spreadsheet is incorporated in an encrypted executable file
(*exe). After a double click on the file, Excel will be launched and it
can be used as normal Excel application but calculation formulas cannot
be seen or modified. Changes like parameters or column dimension can be
stored in the exe-file.
The executable file does not make any changes (installations) on the HDD
or registry.
!!!Be aware that the tool is for free, not for commercial use and that I
don’t guarantee for its correctness somehow or other!!!
Excuse for my bad English.
--
Glück Auf - Bodo Mysliwietz
----------------------------------------
http://www.labortechniker.de/
Glück Auf - Bodo Mysliwietz
----------------------------------------
http://www.labortechniker.de/