There's quite a bit of overlap between these two script files. Other than the population files, they both share the same lookups. Therefore, it makes sense to me to combine the files so that the trends data and SMR data are produced from running the same script. This would also increase the level of automation.
I'm also wondering whether or not we can add the excel script to this too, although that might be a bit excessive. Worth thinking about though. It is possible to knit an Rmarkdown document from an external script so we could in theory run the entire publication, including word output from the one script.
There's quite a bit of overlap between these two script files. Other than the population files, they both share the same lookups. Therefore, it makes sense to me to combine the files so that the trends data and SMR data are produced from running the same script. This would also increase the level of automation.
I'm also wondering whether or not we can add the excel script to this too, although that might be a bit excessive. Worth thinking about though. It is possible to knit an Rmarkdown document from an external script so we could in theory run the entire publication, including word output from the one script.