Spreadsheet calculations of absorbed dose to water for photons and electrons according to established dosimetry protocols

Abstract

The calculation of absorbed dose to water according to a Code of Practice demands a strict adherence to the rules and data of the protocol. To ease the calculations and to avoid computational and methodological errors, we have developed a number of spreadsheets to perform the calculations in accordance with an established dosimetry protocol—in our case those of the International Atomic Energy Agency (IAEA) and the Institution of Physics and Engineering in Medicine and Biology (IPEMB). The spreadsheets are implemented as Microsoft Excel V5.0 worksheets. Only a limited selection of dosimetry equipment is used for calibration, which is performed according to only one of the methods allowed by the protocol. This voluntary limitation of equipment and methods is reflected in a spreadsheet that is beam-specific, compact, focused, and very practical. There are four main spreadsheets: high-energy photons (IAEA), high-energy electrons (IAEA), medium energy X rays (IPEMB), and low-energy X rays (IPEMB). The sheets allow the input of setup and measured data, but tabulated data and formulas are protected. Parameter values are copied from the protocols, and the relevant value is found by linear interpolation. Once the spreadsheets are drawn up correctly and thoroughly checked, protocol calculations are performed easily and accurately. The spreadsheets presented are tailored to suit our specific needs but can easily be modified to conform to the practices of any other institution. They are not intended as “cookbooks” but need to be filled in by a radiation physicist with the input data checked by a second professional. The same method is also used for calculating the Reference Air Kerma Rate of brachytherapy sources.