Here are some questions that people have been asking recently, as they use Gooroo Planner for covid and post-covid planning.
What ‘past period’ should we use to measure demand?
The pre-covid period is probably still the best reference baseline for demand, for instance 01-Mar-2019 to 29-Feb-2020. (Remembering that the period covered by your activity and additions uploads needs to be at least 54 weeks long to capture a full year of seasonality.)
Can we use a short covid-era period to measure demand?
Yes. If people want to explore alternative demand scenarios then you could use a different period, for instance April to June 2020 if you wanted to assume that demand was at shutdown levels.
When you are using short data periods, you will almost certainly want to remove seasonal variation by setting all 106 seasonality variables to the same number (for example by updating your dataset with this high level assumptions file, selecting ‘Overwrite’, and adapted for the HeadType values you are using).
Can we assume increases or decreases in demand?
We can only deliver so much activity during covid – can I model that?
Yes. Use FutActiv (Activity in future period: where a fixed activity scenario is being modelled) to specify the exact amount of activity you intend to do.
The easiest way is often to download a report from the Report Manager, keep all the header fields you are using (e.g. HeadType, HeadSpec), delete all the other columns, and create a new column with the title FutActiv. You can then put all your plans into that column.
This method creates a kind of exceptions table: more here.
What if our activity assumption is a fraction of pre-covid activity?
This is easy to do. Download a report from the Report Manager, open it in Excel, delete all the columns apart from the headers you are using and ResActPastRate, rename ResActPastRate as FutActiv, and paste-multiply all the numbers by 0.8.
What if our activity assumption is urgent activity only?
Same as above, except you will use ResPriDemand instead of ResActPastRate.
There is a subtlety however, depending on how you think an urgent-only outpatient service will affect the demand for admitted elective care. If you reduce to urgent-only outpatients, then only a proportion of those might convert to admitted patients. So you may want to run the urgent-only outpatients model first, and then download that report and repeat the step above for the admitted patients if you want those outpatients to carry on converting at the historic conversion rate.
How can I plan to recover to the pre-covid waiting list size?
You can use the statistical field TgtWL (target list size) to specify the waiting list size you want for each service. Or you can amend your high level assumptions table to automatically use a list size that is already loaded: -1 = start of future period, -2 = end of past period, -3 = start of past period. You will also want to change the target waiting time (e.g. in your high level assumptions table) to a high value (e.g. 99) to stop that kicking in.
Finally, remember to choose the activity scenario to match waiting list targets, when creating your report.
Can we exclude P5 and P6 patients (who don’t want to come to hospital for the foreseeable future)?
You could mark those patients as suspended in your waiting list snapshot files, by setting SuspendFlag = 1. They will then be excluded from the waiting list, but will carry on being included when demand is measured.
The question is: should you? I would argue not. Those patients are going to be treated one day (otherwise they would be completely removed from the waiting list) and you will want to include them in your post-covid recovery plan. You may get in a tangle if you exclude them in one model, and then try to add them back in again to model the recovery.
It would probably be easier to leave all those patients in the data as usual, and then – after you have created your planning model – assume that (say) only 80% of the projected waiting list size will be active at the end of March (or whenever).
I have a different question…
Then drop us a line!