I've made some (hopefully!) final edits to the excel templates based on the comments from Lucinda listed below. Only change I didn't make was to remove "Other" from specialty dropdown. To do this I would need to take out of lookup list which would mean it would never appear should data exist in future.
Table 1:
The title on the first chart reads “Hospital Standardised Mortality Ratios in” because the cells are merged and are hiding “Scotland”
Should the funnel legend have capitals for SMR?
I can’t remember if this was something that existed previously but it might be nice to have a line somewhere explaining that the table gives the order of the points and orange/red squares represent the outliers – not necessary but might be nice in the future.
Table 2:
The footnote on 2A re NHS Board figures not equalling sum of hospitals reads the nicest I think but it isn’t copied for the other sheets (or the sheets in Table 3)
“Other” is still included in the Specialty chart dropdown.
Table 3:
Lanarkshire and GGC are missing – should be easy to fix by updating codes in the lookup.
Golden Jubilee is in the population drop down.
The footnotes on both sheets say “data as at 17 Feb 2548”!!!
I've made some (hopefully!) final edits to the excel templates based on the comments from Lucinda listed below. Only change I didn't make was to remove "Other" from specialty dropdown. To do this I would need to take out of lookup list which would mean it would never appear should data exist in future.
Table 1:
Table 2:
Table 3: