Blog Day 107: Wednesday 08 July 2020
First up a bit of a mea culpa from me. The other day I may have been a little critical of some of the people on the locked down public housing towers for complaining about running out of supplies, particularly prescription medicines after only 24 hours. Well, I have been rightly castigated by one of my more reasonable and balanced readers who has pointed out that some of the people living in these towers may have issues that prevent them from having large supplies of their medication on hand. Apparently some people have to attend a pharmacy regularly if not daily for their medication. Therefore I apologize if I have misjudged any of these people. (I am not apologizing for my criticism of the people who were complaining about the quality and quantity of the pies and sausage rolls that they got).
A little bit more about the virus testing I undertook yesterday. Although it took me two hours to be tested I must admit that the process was handled very efficiently and professionally. The medical staff were friendly and polite, well as polite as they could be while shoving stick with a bit of cotton wool up your nose and the traffic management was extremely well handled.
For this lock down period I have decided to provide the daily corona virus figures by way of a spreadsheet. This will allow for comparison of the figures on a day to day basis. The other reason for doing it this way is that I like doing spreadsheets.
The spreadsheet idea isn't working as well as I would like, Blogger is not particularly spreadsheet friendly, however I will persist and see how we go.
The day to day figures don't always reconcile to the previous day's figures and as you could imagine as an accountant this is causing me some grief. I think that it is as a result of re classification of previous stats and also a matter of timing through the day when the figures are collated. As at 1.00pm the Commonwealth and State sites are still showing yesterday's figures. There are even discrepancies between what DD announced this morning and what is now appearing in the press.
Anyway, hopefully the figures below will give us all some idea of what is happening day to day in this new lock down period.
The spreadsheet idea isn't working as well as I would like, Blogger is not particularly spreadsheet friendly, however I will persist and see how we go.
The day to day figures don't always reconcile to the previous day's figures and as you could imagine as an accountant this is causing me some grief. I think that it is as a result of re classification of previous stats and also a matter of timing through the day when the figures are collated. As at 1.00pm the Commonwealth and State sites are still showing yesterday's figures. There are even discrepancies between what DD announced this morning and what is now appearing in the press.
Anyway, hopefully the figures below will give us all some idea of what is happening day to day in this new lock down period.
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Victorians are still not going to be allowed in to Tassie even when other States might be. Waiting for further info from Mr Gutwein on Friday. Probably some direct flights to other States but I think most will be from Hobart, not that I would be planning to go anywhere in the near future.
ReplyDeleteStay safe you Victorians.
I don't think that we are going anywhere for some time..
DeleteLove a good spreadsheet
ReplyDeleteA good spreadsheet is a work of art.
DeleteCan you do a spreadsheet on the different LGA's and map where the growth is actually taking place. For example -
ReplyDeleteCases
LGA name 7-Jul 8-Jul Increase
Hume (C) 116 131 15
Wyndham (C) 69 84 15
Melbourne (C) 68 82 14
You can get the data here: https://app.powerbi.com/view?r=eyJrIjoiODBmMmE3NWQtZWNlNC00OWRkLTk1NjYtMjM2YTY1MjI2NzdjIiwidCI6ImMwZTA2MDFmLTBmYWMtNDQ5Yy05Yzg4LWExMDRjNGViOWYyOCJ9
What I'm seeing is that this is a very localised outbreak in certain LGAs. You look at active cases and really the problem areas are Hume, Wyndham and Melbourne - with Moonee Valley not far behind. No where else has had an increase of more than 3 cases (Active) iun those two days.
The one thing that was concerning for me was the 41 cases in hospital in Vic as of today, and 7 in ICU. With lockdown only now, you'd expect the peak in numbers to be in the next 10days, and hospitalisations in 3-4 weeks. I guess that's why we have a 6 week lockdown.
I will see if I can fit it in to my busy schedule. The movement in hospitalisations and ICU admissions will be interesting over the next couple of weeks.
Delete