My rough math for number of vaccines Utah needs to be giving each day was 15,000. Unfortunately https://coronavirus-dashboard.utah.gov/#vaccines only provides the total number of vaccines that have been given. While that is helpful, it isn’t enough to determine if the pace is sufficient to get it to everyone who wants it by 1 September 2021. For that we need daily numbers, and to track that trend over time ( they do this for covid-19 cases and deaths ).
I decided to solve that problem myself with a simple spreadsheet. I’m noting the total for each day and comparing it to the previous day to come up with the daily numbers. There are daily numbers for both the vaccinations given and the vaccine doses that have been received.
To make it easy to tell which days are over and under the 15,000 target I’ve applied condition formatting. Pink for days with less than 15,000 and green for days with more than 15,000. Nothing fancy, but it is effective at communicating the data in a glance.
Unfortunately I wasn’t able to find the total doses shipped for December 18th, 19th, 20th, 24th, 25th, and 31st; and January 1st and 3rd. Those are noted by an asterisk next to them and on those days I used the previous known value.
The 2nd of January is the only day over 15,000 – at 16,174, but that covers multiple days due to the New Year’s Day holiday. Today the daily number was 7,568 vaccinations, our highest single day number so far. Unfortunately is only half of my estimated minimum of 15,000 per day that we’ll need to get it out to everyone by 1 September 2021.
Honestly, I’d rather they targeted a minimum of 25,000 vaccinations per day. I realize that supply would need to keep up with that as well, which has other challenges.
A read-only version of the spreadsheet is publicly available at https://docs.google.com/spreadsheets/d/e/2PACX-1vRLswt3xO8ckCQktr6RbAwWtGeu3ujqUK0LYLe97hE-vwxNFmtzWJSVDnVLwstYij7O5igCJmFDVMAt/pubhtml#.