About Excel Dosimetry Reports
About the DC Export to Excel Template
When the user clicks the Excel icon on the report summary screen, DoseControl exports the report data to the DC Export tab of the Excel.xlsx file.
GEX provides a starter Excel Template provided by GEX (DC Export to Excel.xlsx file) with your installation files.
DC Export tab - this tab cannot be deleted! Data is exported to this tab.
Your Report tabs - Various Report Types (different reports that you have setup under “Report Types” have cells that link to the cells in the DC Export tab. GEX provide standard Excel report templates (see section below), but you can alter or delete these report tabs as needed.
Do not delete the DC Export tab in the Excel template file. DoseControl exports report data into this tab.
Customize your Excel Report Template
DoseControl exports report data into Microsoft Excel format, and the data can be used in a variety of ways.
Step 1: Use the starter Excel Template provided by GEX (DC Export to Excel.xlsx file with your installation files)
Step 2: Setup a Report Type (Setup → Report Types). Use the “Standard 1 Pack PDF” exporter type (or any PDF exporter type), enter a report name, and setup the report header fields.
Step 3: Edit the Excel Template (DC Export to Excel.xlsx), and rename it. Use linked cells in Excel to build your dosimetry report template’s layout and data, and it is completely customizable. You will link the relevant exported data in the Excel report’s DC Export tab to your report’s tab.
How to customize Excel report templates.
Learn more about the DC Export fields
Step 4: When you finish customizing your Excel template .xlsx, save it. Next, upload the DC Export to Excel Template into DoseControl to use for your dosimetry reports. For detailed instructions, go to How to use Excel report format in DoseControl.
Standard Excel Report Header Templates
GEX provides generic reports in Excel format (DC Export to Excel.xlsx file with your installation files). The Application Admin can quickly configure a standard report header in DoseControl.
MS Excel templates (ready to use from GEX) |
Dosimeter Measurement – report for measuring dosimeter absorbance and dose for routine dosimetry.
Beam Energy – ebeam testing, 10MeV Riso wedge Beam Scan Uniformity - ebeam testing DoseMap (30) – dose map report for 30 dosimeters DoseMap (85) – dose map report for 85 dosimeters DoseMap (135) – dose map report for 135 dosimeters Ebeam – Dosimeter Batch Calibration Gamma – Dosimeter Batch Calibration |