Hostname: page-component-74656f9884-rdgjk Total loading time: 0 Render date: 2026-11-08T10:49:13.822Z Has data issue: false hasContentIssue false

Managing workflow in treatment planning using standard spreadsheet software

Published online by Cambridge University Press:  01 December 2008

J. Vaarkamp*
Affiliation:
Radiation Physics Department, Princess Royal Hospital, Hull and East Yorkshire Hospitals NHS Trust, Hull, UK
C.S. Hamilton
Affiliation:
Radiotherapy Department, Princess Royal Hospital, Hull and East Yorkshire Hospitals NHS Trust, Hull, UK
M. Escreet
Affiliation:
Radiation Physics Department, Princess Royal Hospital, Hull and East Yorkshire Hospitals NHS Trust, Hull, UK
C. Percy
Affiliation:
Radiation Physics Department, Princess Royal Hospital, Hull and East Yorkshire Hospitals NHS Trust, Hull, UK
*
Correspondence to: J. Vaarkamp, Radiation Physics Department, Princess Royal Hospital, Saltshouse Road, Hull, East Yorkshire, HU8 9HE, UK. E-mail: jvaarkamp@hotmail.com
Rights & Permissions [Opens in a new window]

Abstract

Aims: Recent years have seen an expansion of UK radiotherapy treatment capacity with a drive to reduce radiotherapy waiting times. Consequently, the time available for planning patients is decreasing. In this context, management of treatment planning workflow in the Princess Royal Hospital is described and monthly planning times are presented from September 2003 onwards.

Materials and Methods: After patients are imaged, patient name, unit number and appointments are available to the planning spreadsheet via a link to the radiotherapy information system. The planning spreadsheet is in descending order of appointment date. Treatment planning staff select the first available task, taking account of individual competencies. At plan completion, the patient record is moved to the completed list.

Results: Since September 2003, patient numbers through treatment planning steadily increased from around 90 a month to about 130 currently. Planning times decreased from 11 to 7 workdays.

Conclusions: Workflow through treatment planning is indirectly managed and the approach allows for day-to-day staffing fluctuations and competency levels. There is instant information on planning status for all patients throughout the department, building up a record as part of the work process. Bottlenecks and staff training needs can be analysed by reviewing the historic patient workload.

Information

Type
Original Article
Copyright
Copyright © Cambridge University Press 2008
Figure 0

Figure 1. Anonymised screenshot of the layout and data collected in the treatment planning patient list.

Figure 1

Figure 2. Macro menu with macros available to manipulate the treatment planning patient list. There is macros for displaying specific sublists, sorting, adding and removing patients from the list and insert various dates.

Figure 2

Figure 3. Window for the user to approve the patient information to be inserted from the radiotherapy database into the treatment planning patient list.

Figure 3

Figure 4. Example of the display showing how many patients need to be finished on each day for the coming weeks. The graph is used to identify busy periods so that the need for extra help or postponing patients can be flagged up in a timely fashion.

Figure 4

Figure 5. Average total planning time (in workdays) for patients coming into treatment planning between September 2004 and August 2007. Also shown for the same period is the planning time (in workdays) after subtracting the wait for oncologist input.

Figure 5

Figure 6. Number of patients coming into treatment planning each month for the period between September 2004 and August 2007.

Figure 6

Figure 7. Frequency distribution of the relative contributions to total planning time of one oncologist (No. 2), all oncologists and planning staff for all patients between September 2004 and August 2007, excluding same day simulator/calculation cases and delays over 25 days.