You filter spam; and that's censorship. So you'll either end up with a mired cesspool of spam or very strict censorship to reduce legal liability risks.
You're meant to add additional records as rows! (Excel supports only 16,384 columns, but 1,048,576 rows.)
Actually, this was a pet peeve of mine: Especially in the early days of COVID, just about every official or unofficial data source was an absolute shitshow:
- Transposed data (new entries in columns)
- Pretty printed dates (instead of ISO 8601 or Excel format, or... anything even vaguely parseable by computer).
- US date formats mixed in with non-US date formats.
- Each day in a separate file, often with as little as 100 bytes per file. Thousands upon thousands of files.
- Random comments or annotations in numeric fields (preventing graphing the data).
We don't all need to be data scientists, or machine learning wizards, or quantum computing gods.
But come on. This is the most basic, data entry clerk level Excel 101 stuff. Trivial, basic stuff.
Put rows in rows.
Don't mix random notes into columns you might want to sum or graph.
Oh, I saw excel files that contained screen shots of other excel files over cells containing data. Comments where in text fields, if you were lucky, or again screen shots, from word.
And then the same people wondered why things based on this file didn't work.
They seem to have hit the row limit, not the column limit. They were using Excel to collate the data coming in from different test centres: when one of the CSVs was loaded in, the row limit was exceeded and Excel cut off the extra rows without the operator realising (I'm going off reporting by Alex Hearn at The Guardian here, and he's normally pretty good)
lets assume that local centers people do save them in rows, which is the most logical thing to do. But probably the software where they copy/paste them requires the data in columns, so maybe they transposed the data without realizing that it was truncated to max size.
Or else it wouldn't explain why it took so many days to realize that they couldn't add more columns.
Which means the US is undercounting C19 fatalities? Since lockdowns cut the flu season short; stopped all school shootings and most firearm deaths; cut traffic accidents etc
I don’t think lockdowns cut the flu season short - how would they stop flu but not COVID in March? School shootings are not an appreciable cause of excess death, firearm deaths are mostly suicides which probably went up not down, similar to overdose deaths.
More starkly, visits to the ER for strokes and heart attacks plummeted during lockdown. But there weren’t actually fewer strokes and heart attacks. Many of those people just died at home.
In short, no one can say how many of excess deaths were COVID vs lockdown deaths, but it certainly isn’t the case that the “lockdown”‘category is actually a net negative.
> Although they were in common use, the terms "master" and "slave" do not appear anymore in current versions of the ATA specifications, or any current documentation. Since ATA-2 the two devices are referred to as "Device 0" and "Device 1", respectively. This is more appropriate since the two devices have always operated, since the earliest ATA specification, as equal peers on the cable, with neither having control or priority over the other.
> It is a common myth that the controller on the master drive assumes control over the slave drive, or that the master drive may claim priority of communication over the other device on the same ATA interface. In fact, the drivers in the host operating system perform the necessary arbitration and serialization, and each drive's onboard controller operates independently of the other.
> While it may have remained in colloquial use, the PC industry has not used ATA master/slave terminology in many years.
