Skip to content

Home

Jump to bottom
Ellen Wasbø edited this page Jan 7, 2021 · 16 revisions

getSiemensQC will read out values from Siemens QC reports into exportable table to study trends. Acceptable reports are

  • CT constancy
  • CT daily QC
  • PET daily QC

To locate the reports on the Siemens scanner: Options -> File Browser... and locate H:\SiteData\ConstancyReports (or maybe QualityReports for older machines). Export the files to memory-stick.

Only English and Norwegian files are accepted, but other languages might quite easily be added. Send me a note by adding a new "Issue" to this project.

Currently verified files from:

PET:

  • Biograph mCT (Software version VG60A to VG62B)

CT:

  • SOMATOM Definition AS
  • SOMATOM Definition Flash (2012B(?) to VA48A)
  • SOMATOM Definition Edge (VA48A, + PET VG60A to VG62B)
  • SOMATOM Drive (VB20A)
  • SOMATOM Force (VB20A)
  • Symbia T2 (2007E>VA60A to VA60C)
  • Symbia Intevo (VC50>VB22A)

Please tell if you know the list is longer or if you know of versions not working.

To read the content of the reports there are two options:

Alternative 1 (if you have a few files) - Open a PDF file, then mark and copy the text (Ctrl+A, Ctrl+C). Then press the "Read from clipboard" button to get the numbers into a column. Repeat for all reports.

Alternative 2 (if you have many files) - Convert the PDF files to text and press "Read from txt files (automated). Due to hospital IT service issues with installing exe files I made my own converter through Excel macro. This Excel file can be found in the ExcelTemplates folder ('convertPDFToTXT.xlsm'). This is not a very robust solution. You will need to keep your hands off the keyboard during the process of converting as it uses short-keys and if the focus is interrupted you might get crap out.

Eventually the table of results can be exported to clipboard and pasted into for example Excel. I have provided an Excel template-file for CT controls (both daily and constancy) and one for PET controls where the data can be pasted into the table and a lot of diagrams are plotted in a separate sheet.

From version 1.1 it is also possible to append text-files. The address to the text file is configured from the File menu so that results will be appended to the file with the correct Serial Number of the scanner. This txt file can be used for autoupdating Excel or Power BI reports.

See some screenshots here

Clone this wiki locally