Monthly Archives: February 2012

Vaccinations WORK and are extremely safe. All informed “debate” is over, Vaccinate your children!

Posted on by
Reply

Whilst researching the status of polio in India I ran across a US website ranting about the (almost entirely imaginary) “dangers” associated with vaccines.

Sad to see so many in the USA still so persistent with their opposition to the obvious, while in India vaccine programs have run into some problems when poorly informed local leaders and traditional medicine practioners scare people away from the greatest medical innovations in all of human history – Vaccines.

[note – I’m not informed enough to talk about about the new  and politically controversial cervical cancer vaccine many believe should be mandatory for girls – here I’m talking about the old vaccines like DPT and Polio, tried and true, that have been used for decades]

Vaccinations have saved *hundreds of millions* of lives outright and spared *hundreds of millions* more from dramatic reductions in the quality of life.  Like any broadly applied remedy, Vaccine complications have caused a few deaths and a very tiny number of complications.   Only a narrow and irrational approach focuses ONLY on risks and ignores the massive benefits.

Vaccination math is overwhelmingly supportive of vaccines, yet ignored by the folks in the very vocal and active  anti-vaccine crowd, who simply refuse to do the math, choosing instead to point to imaginary or “one in a million” risks as if they these outweigh the 999,999 in a million benefits.

I wrote a comment over at the site I bumped into just now:

Sorry to see sites like this that discourage people from the “no brainer” that is vaccination of children.  Usually the misunderstandings come from the fact that you will have a very, very, very tiny number of complications with anything that touches billions of lives. This is NOT a reason to fear vaccines irrationally, as far too many do both in USA and developing world.  Leaving your children unvaccinated places them at hundreds of times the risk of a vaccinated person. You also put others at greater risks.  Ironically this would NOT be an issue if vaccines had not been such an incredible success because people would see the affects of polio, smallpox, and other diseases all around them. We don’t see that because we use vaccines.

———————

One MINOR caveat here to the above.   There is a point in time when vaccination success may lead to a total regional eradication of a disease.  At that time the (tiny, tiny) risks of vaccinating can wind up being greater than the (nearly zero) risk of contracting the eradicated disease.   This happened with smallpox in the USA and it’s why we no longer vaccinate for smallpox.    This fact hardly undermines the importance of vaccines or supports the “anti vaccine” crowd’s imaginary complications  (e.g. autism), but it’s important to keep it in mind when doing vaccine math.

Retirement, History, and Google Spreadsheets

Posted on by
4

I’m working hard on our Retirement website and upcoming retirement blog project called “Retire USA” and wound up having a heck of a time with some data conversions, so I want to outline that process here in case others have the same troubles.

Process ONE – copying records from a Google Docs Spreadsheet to an Open Office “ODS” format spreadsheet:   This sure seemed non-trivial unless I missed something or had data glitches buried in the sheets.   I could NOT complete direct cut and pastes from Google docs to my Open Office “ODS” spreadsheet so….

What DID WORK was this:

1.  Save Google spreadsheet in CSV format within Google Docs

2.  Import that CSV sheet to Open Office and save in ODS format.

3.  Cut and paste between the two Open Office spreadsheets.   IMPORTANT:  When pasting, select ONLY the upper left cell as if you are going to paste everything into that single cell.

 Process TWO – Merge two cells into a new single cell containing contents of BOTH original cells.     In my case I wanted a new combined field name.

Update – review the “DATA/Text to Columns” and the related “Concatenate” functions within Open Office.

Again, I’m not an expert so there may be easy ways to do it, but this did not seem to work directly in Google Docs spreadsheet.    Merge cells is an option, but it only preserved ONE of the cells.    However in Open Office you can celect “Merge Cells” and it should immediately prompt you to include contents of BOTH cells.   Unfortunately I had to merge about 8000 cells and since there seemed to be no bulk process I created a keystroke macro and did them (pretty quickly) manually because I was not clever enough to get a macro that would run this process by itself.

FYI note that you may want to keep your old fields (cells) as well as have the new combined field.   In that case simply make copies of the columns so you have extra ones to combine.

The reason I needed this was to create a CityCategory field name that will work well with our Retirement website.   One painful alternative to this little merge routine would have been to type the extra word into five thousand records!