Excel Report Data Fields
DC Export to Excel
The DC Export worksheet contains a dosimeter report’s exported data from DoseControl. (Excel template is provided by GEX in the installation folder.). DoseControl exports data to the DC Export tab in the Excel template.
Fields alway exported by DoseControl (yellow highlight)
Custom report header fields (if any) export by DoseControl (blue highlight). Report headers are exported in sequential order.
Data always exported
DoseControl exports data to the DC Export tab in the Excel template.This table describes the data always exported for a report:
FIELD NAME: | DESCRIPTION: |
Report ID: | Unique name/identifier of the report, entered at new report creation |
Rpt Version: | Version number of the report |
Pathway: | Irradiation pathway for report, selected from configured Pathways |
DSM Batch: | Dosimeter batch ID (from Calibration configuration) |
Status: | Status of report, processed or incomplete |
Last Edited by: | Username that is logged in at the time of most recent report activity |
Last Edited date: | Date of most recent report activity |
Last Edited time UTC: | Time of most recent report activity, in UTC |
Export Date: | Date of report export activity |
Export Time UTC: | Time of report export activity, in UTC |
Cal Start Date | Start date of the dosimeter batch calibration for the report |
Cal End Date | End date of the dosimeter batch calibration for the report |
Minimum (Corrected) Dose | Minimum dose of all measured dosimeters in the report. Corrected dose = Dose * Correction Factor of the Calibration (if any). |
Maximum (Corrected) Dose | Maximum dose of all measured dosimeters in the report. Corrected dose = Dose * Correction Factor of the Calibration (if any). |
Min Dose Spec | Minimum dose specification for the process. (This is a special value field only used in Reference Dosimetry reports. It will be empty if the field is not used in the report.) |
Max Dose Spec | Maximum dose specification for the process. (This is a special value field only used in Reference Dosimetry reports. It will be empty if the field is not used in the report.) |
Ref Min Ratio | Ref:Min Ratio for the process. (This is a special value field only used in Reference Dosimetry reports. It will be empty if the field is not used in the report.) |
Ref Max Ratio | Ref:Max Ratio for the process. (This is a special value field only used in Reference Dosimetry reports. It will be empty if the field is not used in the report.) |
Comments | Report comments |
Dosimeter ID | Dosimeter ID number, serial number |
Position: | Dosimeter position (reference, description) |
ToteID: | Tote ID/Carrier number |
A0 | Background absorbance measurement (usually 0) |
Ai-1 | Absorbance measurement of dosimeter replicate 1. (If you are using 1 dosimeter per pouch, you have 1 dosimeter “replicate”. The dosimeter’s measured absorbance is Ai-1.) |
Ai-2 | Absorbance measurement of dosimeter replicate 2. (If you are using 2 dosimeters per pouch, you have 2 dosimeter “replicates”. The dosimeter’s measured absorbance is Ai-1 and Ai-2.) |
Ai-3 | Absorbance measurement of dosimeter replicate 3. (If you are using 4 dosimeters per pouch, you have 4 dosimeter “replicates”. The dosimeter’s measured absorbance is Ai-1, Ai-2, Ai-3, Ai-4.) |
Ai-4 | Absorbance measurement of dosimeter replicate 4. (If you are using 4 dosimeters per pouch, you have 4 dosimeter “replicates”. The dosimeter’s measured absorbance is Ai-1, Ai-2, Ai-3, Ai-4.) |
Thickness | Dosimeter thickness (from Batches configuration) |
Response | Calculated response value R=(Ai-A0)/t (Ai is the average of all the dosimeter replicates) |
Dose | Measured dose (dose measured by the spectrophotometer) |
Correction factor | Correction factor (from Calibration configuration) |
Corrected dose: | Dosimeter reading’s corrected dose. Corrected Dose = Dose * Correction Factor (from the calibration, if any). |
Calibration ID: | Calibration ID (from Calibration configuration, laboratory provided cal ID) |
Inst ID: | Spectrophotometer (Reader) name |
Inst SN | Spectrophotometer (Reader) serial number |
WL (nm) | Spectrophotometer set wavelength for measurement (from Calibration configuration) |
DSM Measured Date Time UTC | The datetime stamp for the dosimeter measurement |
Cal Dose Range | The min/max dose range for the dosimeter batch Calibration |
Rereads | Number of rereads for this dosimeter ID. Original meaurement is “1”. Reread measurement is “2”. Next reread measurement is a “3”. |
Report header data exported
The additional report header data fields section of DC Export is called the Report Headers (as configured by the Admin in Report Headers setup). Upon export to Excel, these fields will populate in the same sequence configured in the Report Header setup.
