The more time & effort you invest upfront, the more time you save down the road
All too often I work with clients who inherit spreadsheets with haphazardly arranged data. Sometimes I can actually feel the anxiety of the person who created the spreadsheet because of how erratically and inconsistently the data is structured and formatted.
This kind of information vomit is extremely problematic, because once the structure and layout of the data has been established in a spreadsheet, it takes a lot of time, effort, and expertise to clean up and restructure. This is especially true when data is entered inconsistently, with no discernible pattern.
Take the example of entering a First Name and Last Name
If every name was entered consistently into a single column, it would be very easy to clean up thousands or even millions of rows of data. Text to Columns could separate “Smith, John” into 2 separate columns (1 for “Smith” and 1 for “John”).
However, if the data were sometimes entered as “John Smith” and other times entered as “Smith John” with no comma, it is impossible for Excel to determine how to clean this up.
That is why taking steps early to organize the structure and format of your data can save you hours or even weeks of extra work depending on the scope of your project.
The same is true for public health
There was an egregious number of missed opportunities to nip COVID-19 (Coronavirus) in the bud. If nothing else, early quarantines in Wuhan, China could have been implemented on a relatively small scale to contain the virus.
Instead, shit has already hit the fan. At the time of this post, millions are quarantined, travel has been dramatically restricted, the stock market is in free fall, and thousands have already died.
In the spirit of problem solving, below is a letter from one of the first molecular virologists in the world to work on coronaviruses.
Please help spread the word by sharing this letter…
Subject: What I am doing for the upcoming COVID-19 (coronavirus) pandemic
Dear Colleagues, as some of you may recall, when I was a professor of pathology at the University of California San Diego, I was one of the first molecular virologists in the world to work on coronaviruses (the 1970s). I was the first to demonstrate the number of genes the virus contained. Since then, I have kept up with the coronavirus field and its multiple clinical transfers into the human population (e.g., SARS, MERS), from different animal sources.
The current projections for its expansion in the US are only probable, due to continued insufficient worldwide data, but it is most likely to be widespread in the US by mid to late March and April.
Here is what I have done and the precautions that I take and will take. These are the same precautions I currently use during our influenza seasons, except for the mask and gloves.:
1) NO HANDSHAKING! Use a fist bump, slight bow, elbow bump, etc.
2) Use ONLY your knuckle to touch light switches. elevator buttons, etc.. Lift the gasoline dispenser with a paper towel or use a disposable glove.
3) Open doors with your closed fist or hip – do not grasp the handle with your hand, unless there is no other way to open the door. Especially important on bathroom and post office/commercial doors.
4) Use disinfectant wipes at the stores when they are available, including wiping the handle and child seat in grocery carts.
5) Wash your hands with soap for 10-20 seconds and/or use a greater than 60% alcohol-based hand sanitizer whenever you return home from ANY activity that involves locations where other people have been.
6) Keep a bottle of sanitizer available at each of your home’s entrances. AND in your car for use after getting gas or touching other contaminated objects when you can’t immediately wash your hands.
7) If possible, cough or sneeze into a disposable tissue and discard. Use your elbow only if you have to. The clothing on your elbow will contain infectious virus that can be passed on for up to a week or more!
What I have stocked in preparation for the pandemic spread to the US:
1) Latex or nitrile latex disposable gloves for use when going shopping, using the gasoline pump, and all other outside activity when you come in contact with contaminated areas.
Note: This virus is spread in large droplets by coughing and sneezing. This means that the air will not infect you! BUT all the surfaces where these droplets land are infectious for about a week on average – everything that is associated with infected people will be contaminated and potentially infectious. The virus is on surfaces and you will not be infected unless your unprotected face is directly coughed or sneezed upon. This virus only has cell receptors for lung cells (it only infects your lungs) The only way for the virus to infect you is through your nose or mouth via your hands or an infected cough or sneeze onto or into your nose or mouth.
2) Stock up now with disposable surgical masks and use them to prevent you from touching your nose and/or mouth (We touch our nose/mouth 90X/day without knowing it!). This is the only way this virus can infect you – it is lung-specific. The mask will not prevent the virus in a direct sneeze from getting into your nose or mouth – it is only to keep you from touching your nose or mouth.
3) Stock up now with hand sanitizers and latex/nitrile gloves (get the appropriate sizes for your family). The hand sanitizers must be alcohol-based and greater than 60% alcohol to be effective.
4) Stock up now with zinc lozenges. These lozenges have been proven to be effective in blocking coronavirus (and most other viruses) from multiplying in your throat and nasopharynx. Use as directed several times each day when you begin to feel ANY “cold-like” symptoms beginning. It is best to lie down and let the lozenge dissolve in the back of your throat and nasopharynx. Cold-Eeze lozenges is one brand available, but there are other brands available.
I, as many others do, hope that this pandemic will be reasonably contained, BUT I personally do not think it will be. Humans have never seen this snake-associated virus before and have no internal defense against it. Tremendous worldwide efforts are being made to understand the molecular and clinical virology of this virus. Unbelievable molecular knowledge about the genomics, structure, and virulence of this virus has already been achieved. BUT, there will be NO drugs or vaccines available this year to protect us or limit the infection within us. Only symptomatic support is available.
I hope these personal thoughts will be helpful during this potentially catastrophic pandemic. You are welcome to share this email. Good luck to all of us! Jim
James Robb, MD FCAP
The Silver Lining
Despite our current reactive predicament, it’s not too late to take some proactive precautions.
Just because we missed the biggest opportunity to prevent this disease from turning into a pandemic, does not mean that it’s too late to minimize the spread of the disease, and to plan for contingencies in case it does.
Will these proactive precautions today have the same impact as early quarantines in Wuhan, China? Of course not. But, if we fail to take proactive steps now, if we bury our heads in the sand and hope the situation simply resolves itself, the result will be undeniably worse.
In other words, the more we remain reactive, the more mops we are going to need.
Do you agree with my assessment and emphasis on proactivity? Also, feel free to share an example of a time you failed to catch a problem at the onset, and how you handled it. The more we share, the more we can all learn from each other’s experiences.
If you haven’t already, I invite you to sign up for my email list by creating a free ExcelShir account. You’ll get Shir words of wisdom pertaining to Excel, business strategies, and other life lessons delivered straight to your inbox. Looking forward to having you join the ExcelShir community!