Coronavirus Taiwan - Specific Developments May/June 2022

[finley]

@Andrew

Wait, are you making/translating these PDF files? I thought they were coming from the CDC itself.

There doesn’t seem to be an English version of this spreadsheet on the MOHW website. Strangely, despite having the government of Taiwan by the short and curlies, they’re apparently unable to find a few coins down the back of the sofa to pay for a translator. Or indeed to pay for someone who knows what they’re doing to compile all this information in a manner which can be auto-translated and analysed for patterns.

[MalcolmReynolds]

@Andrew

Wait, are you making/translating these PDF files? I thought they were coming from the CDC itself.

Here’s how it works.

1. The CDC/CECC created an Excel (crappy) database to track their death numbers/stats. I’ve got the master now. Ha, ha ha.

2. They then convert the day’s report, such as June 30, 2022 to a single day report in PDF format and post it to their website, unless someone fucks up and posts the master Excel database like yesterday! I’m still smiling. Right around the press conference time, from 14:00-14:30 usually. I copy that link and put it into my daily reports in case anyone wants to see the original in Mandarin. Below is yesterday’s original.

https://www.cdc.gov.tw/File/Get/H6dQnaCk0EoTii2w5CkqsQ

3. I download their PDF, convert it to Excel, adjust the columns, rows, margin, spacing, etc. Basically fix any of the fucked up shit that appears on a daily basis. No rhyme or reason or consistency to the mistakes I see. Can’t be one idiot working on this…has to be multiple people doing their own thing. That’s why the daily reports always look a little different from day to day. Sometimes they even post the exact age of the deaths, which is cool, but mostly it’s the 90s, 80s, crap. Oh…font and size varies too. Sometimes 10 point all the way to 18 point. No consistency at all. Soup to nuts.

4. Then I run it through my translator program that I wrote and translate it to English.

Sub MultiFindNReplace()
'Update 20140722
Dim Rng As Range
Dim InputRng As Range, ReplaceRng As Range
xTitleId = “Malcolm’s Translator”
Set InputRng = Application.Selection
Set InputRng = Application.InputBox("Original Range ", xTitleId, InputRng.Address, Type:=8)
Set ReplaceRng = Application.InputBox(“Replace Range :”, xTitleId, Type:=8)
Application.ScreenUpdating = False
For Each Rng In ReplaceRng.Columns(1).Cells
InputRng.Replace what:=Rng.Value, replacement:=Rng.Offset(0, 1).Value
Next
Application.ScreenUpdating = True
End Sub

5. Then I look for inconsistencies and added words to add to my termbase for the next time.

6. I then put the data into my own nice and consistent Excel spreadsheet for proper presentation.

I started doing this for my own interest and then it got a bit out of hand, so now I do the daily numbers…well…daily…

[Mithrandir]

Does the master file have a list of the number of deaths in ages 0-9 and 10-19 years old? I’m trying to get total numbers.

[MalcolmReynolds]

@Mithrandir

Does the master file have a list of the number of deaths in ages 0-9 and 10-19 years old? I’m trying to get total numbers.

It’s huge! Tell you what…I’ll send you a link so you can download it and look. It’s EXTENSIVE with thousands of lines…over 6K!

PM with download link sent.

Check the first tab. 總表(內參) “General table (internal reference)”

This is where most of the good shit is.