This is a shout out to those who do the jobs that no one else will do, and they do it with heart.
Excel sheets are a bane to every clinician, and thus they avoid it and words like data entry, cross tabulation, data fidelity, etc. like the plague. However, one cannot escape data. The unfortunate reality, is that many decisions we make in life are made based off previous data (decisions we have made, etc.) and a little bit of data fidelity goes a long way.
In a hospital, life and death decisions are made off GOOD quality data. This is the key word, as often the data is entered by people who are overworked and the quality can be questionable. Many assumptions are made even while entering data which is unfortunate as it affects the whole machine. Here are 2 small stories, one with a good example of why we need to thank the people who do this job with passion and another with an example of what happens when you put someone who is overworked and underpaid on the job.
Story 1: Excel with heart
Cancer treatment has made great strides and now that we have more survivors, we are learning about all the side-effects our medicines have caused. To study that however, one has to do the dreaded data entry and cross checking to make sure we are accurately documenting side effects. It is a very tiring and cumbersome process.
One girl that I work closely with as a trainee has been essential for many successful projects, expressed an interest to learn statistics. As always, this has to be taken with a grain of salt as to learn stats takes a lot of patience. At the time, we had an interest in long term survivor cardiotoxicity. It was a relatively simple project, but did require her to go over 400 patients data briefly. However she surprised me when she not only did her own literature search, identified other variables of interest, and cross checked the whole database! Her statement was a testament to her interest.
“I want to understand what I am looking at and make sure the data is accurate.”
” I love Excel.”
To understand why this is important, 95% of any work is to make sure the data is in good shape and 5% is to actually do the analysis. Most people I have met in life, are not willing to do the first part and only want a quick, sloppy answer to make a quick publication. But here was a person willing to go the extra step and may not even be first author on a publication but did the job because she loved it. These are people who deserve to be taught and hopefully I will be up to the mark.
Story 2: Overworked, tired and now I have to do what?!
Doctors are often overworked and have little time for themselves. In addition to that, at large academic institutions, a large amount of pressure is generated to do research, publish as a first author, and do all the scut work of the bosses. In India, its a different culture as many residents will actually prepare their attending’s presentations, book chapters, etc.
This is a story of an overworked resident with an attending who could care less about her data.
As always, I am most popular when it is time to submit abstracts. And its always the last week before submission. (Side note: I was guilty of this also)
“Sir can I sit with you today?”
” Siirrrrrr please help me, I don’t know what my attending wants ”
” Sir, what is a univariate and multivariate analysis.”
And attendings
” I know that this is significant, if you just divide it like this and this” (thats not how statistics are meant to be)
More on attendings and statistics later.
Back to the story:
There is this dataset with patients who expired unfortunately from seizures in our hospital. As with many things, the data was collected after a significant amount of events happened to help us better define WHAT was it that caused such significant mortality.
And as always it was 2 overworked and significantly stressed out (p value <0.05) residents who collected this data at the wee hours of the night. One resident had almost no exposure to excel let alone statistics and when it came to abstract submission, she HAND CALCULATED the demographic data (I have a picture of this for proof).
Her attending, as like many, didn't concentrate on each individual data points with her but rather said in a very blase manner, "Do this, this and this."
As an aside, attendings here are also overworked in different administrative tasks and clinical work, so equally overloaded.
3 days before submission, she came for the data analysis part. This is a little bit of griping, but cleaning up an excel sheet for data analysis, though not difficult, is time consuming and ANNOYING. And as with most retrospective data from residents, there is only one thing we can say after analysis. "This data is suggestive of this, but more data is needed collected in a PROSPECTIVE manner."
The data cleaning, analysis and graph generation done, I get a little peace after finishing 2 other projects.
At Friday 10 PM, (abstract submission midnight) my consciousness makes the hands send a text to this girl. "Everything over?"
A frantic phone call comes, "Sirrrrrrrrrrrrr, please help me. No one has looked at my abstract and I cannot reach my attending. I don't know if what I have written is ok."
The abstract comes like a septic patient ready to konk off. After resuscitation, intubation, and pressor support, the abstract is sent back for submission.
Abstract life saved.
To this day, there is no blame or anger, just laughter. I will forever remember "SIRRRRRRRR" (its like a Masai baby ululating).