ExcelOptics
What is ExcelOptics ?
ExcelOptics is a set of two excel sheets which allows the computation
of linear transport of ultrarelativistic charged particles. It allows the computation
and optimization of beamlines including :
- transfer matrices;
- beta function;
- phase advance;
- dispersion function; &
- beam sizes and divergences.
For circular type lattices , it computes :
- tunes;
- emittances;
- damping times;
- chromaticities;
- bunch length;
- energy spread;
- resonance excitation; &
- lifetimes.
Some tracking can be done using a DLL (PC) or a Shared Library (Mac) included
in the distribution.
Strength of ExcelOptics
- The source is transparent.
- The computation can be easily customized by the user.
- Optimization of the lattice over one or several arbitrary user-defined parameters
with several constraints is made using the Excel solver.
This is probably the the most astonishing feature that is absent from most
other optics codes. One can design a ring lattice and optimize the sextupole
with imposed chromaticities as well as with a minimisation of the systematic
sextupolar type resonance in a very short time and flexible way.
Weakness of ExcelOptics
- It is yet another optics code and there are many others on the market.
- At present the user interface for tracking is quite poor.
- If you are not already a user of Microsoft Excel then forget about ExcelOptics.
- There is no cell protection preventing the user from accidentally removing
some important computation.
Required Configuration
You need one of the following two configurations :
- PC under windows 9x/Me/NT4/2000/Xp with Microsoft Excel Version older than
97
- A Mac under MacOS9.x with Microsoft Excel Version older than 99. Most of
it should work under MacOSX but this has not been tested.
Download
You can Download ExcelOptics Here,
Have a look at the "Readme.txt" file.
If you like this code or you want to give me some feedback, send me an e-mail
to P. Elleaume, ESRF
