1/ Did you know that you can import an Excel spreadsheet schedule into Google Calendar?
This thread is designed for new chief residents or any folks who schedule conferences/events and want to convert a spreadsheet into individual calendar events.
2/ During my time as a @uclaimchiefs we shared a google calendar to track tasks during the week. We also scheduled conferences via shared spreadsheets.
Importing the spreadsheet allowed me to view what conference was scheduled without constantly referencing the spreadsheet.
3/ To start we’ll need a basic spreadsheet to schedule events.
For this tweetorial we’ll use an example of a Noon Conference spreadsheet and include “Day", “Date", “Title", “Speaker", and “Notes" as headers though for this spreadsheet the headers are not critical.
4/ Fun Excel fact: you can autofill weekday days/dates by selecting and dragging the green square in the lower right corner and selecting the appropriate fill.
5/ Ok, now that we have some fantastic conferences planned, we will need to create another sheet at the bottom of the workbook.
This will be what we import so it is essential that the headers appear as follows: Subject, Start Date, Start Time, End Date, End Time, All Day Event
6/ We can now populate the data of this sheet with our other sheet. You’ll notice that these is no speaker field.
To overcome this I combine the Title and Speaker fields from the schedule sheet with the concatenate function.
=CONCATENATE(Schedule!C2," - ", Schedule!D2)
7/ We can then fill across the row as shown below.
The start/end date will simply be = to the appropriate date cell on the schedule. As this is an hour long event we will mark All Day Event as false. We can then drag and fill down the columns to automatically file the data.
8/ Now that we have our completed spreadsheet we will need to copy it to a new separate Excel document. We will then save that new document as a .csv file.
9/ Once we have the .csv file we'll import it to Google Calendar by selecting Settings > Import & export. We’ll then select the file and the appropriate calendar.
*It’s critical to pick the right calendar as you have to manually delete events if you pick the wrong one.
10/ Click Import and *voila!* we have individual conferences which we can copy to our personal calendar, etc.
You can also convert this .csv file to a .ics file for Apple or Outlook calendars using online converters.
11/ And, that’s it! Obviously this is pretty niche/not for everyone but I thought I’d share in case it helps someone to automate what can be a burdensome administrative task.
12/ Here is the Google Calendar help page which highlights some of the other fields that you can add when importing .csv files. You could use the “Description” field to add a Zoom link or other helpful information.
This thread is designed for new chiefs residents (and faculty!) on a topic I got very little coaching on before my chief resident year: Email Management.
2/
My transition to chief year was abrupt. I went from being a decent doctor to a crappy administrator overnight. In this new role I went from receiving a few junk emails/day to hundreds of emails at all hours. The following tips are strategies that helped me survive my inbox.
3/
1️⃣ Set boundaries.
It's easy to be on your email 24 h/day- but it's okay not to be.
Unless I was chief on call I tried not reply to email past 6pm as that is family time. I also limited checking on weekends and vacation. Setting Do-Not-Disturb and downtime can be helpful.
1/ Why are hypodermic needles and IV catheters referenced by gauge numbers?
And why does the needle diameter get smaller as the gauge number increases?
Let's explore the obscure history of IV sizing in the following #histmed#tweetorial.
2/ The gauge numbers on modern hypodermic needles are adapted from the Birmingham Wire Gauge (BWG), a system developed during the Industrial Revolution in the early 1800s to standardize the British cottage industry of iron and steel wire manufacturing.
3/ As early as the 1200s wire was made through the process of wire-drawing, which involved pulling iron rods through a conical hole in a draw-plate or gauge.
The resultant wires could then be drawn through successively smaller diameter gauges to produce thinner wire.
3/ BNP is a hormone secreted in response to ventricular wall stretch. It binds to natriuretic peptide receptor A (NPR-A) which ⬆️ cGMP in various tissues to exert MANY effects including:
⬆️ Natriuresis
⬇️ RAAS
⬇️ sympathetic tone
& so much more!
1/ "Who feels comfortable evaluating a tracheostomy?"
Today on the wards we talked trachs. Though we see patients with trachs regularly I find it is a topic that few learners are comfortable with.
The following 🧵 is my "Hospitalists' Guide to Tracheostomies"
2/
Where are trachs placed anatomically?
Trachs are placed between the cricoid cartilage and the sternal notch around the 2nd to 4th tracheal ring. These can be placed surgically or percutaneously at the bedside.
3/ Anatomy of a Trach
When evaluating a trach, I find it helpful to consider the following:
🔹 Diameter - Is there an inner cannula or single lumen?
🔹 Length - Is it regular size or an Extended Length Trach (XLT)?
🔹 Cuffed or cuffless?
🔹 Fenestrations present?
I occasionally hear atelectasis listed in the differential diagnosis for early post-op fever (EPF) but this idea has never made much physiologic sense to me.
Let's explore this question in the following #tweetorial.
2/ Like many US medical students, I first learned this central dogma of post-op fever on my surgical clerkship through the perpetuation of a rather cumbersome and inelegant mnemonic involving the letter W.
3/
Despite its ubiquity, however, there is little published evidence to support this idea. One of the largest systematic reviews on the topic found that in 7 of 8 studies there was no significant association between atelectasis and early post-op fever.
1/ Why are EKG waves named starting with the letter P? What happened to letters A through O?
I’m guessing you’ve probably never wondered this, but if you’re curious, here’s a brief historical #medthread / #tweetorial on how the EKG waves got the names they did.
2/ The first electrical tracings of the heart were obtained in 1887 by A.D. Waller, a British physiologist and physician, who used a Lippmann capillary electrometer to capture the tracings.
3/ As a physiologist, Waller labelled the two waves on his initial tracing V1 & V2 based on their site of anatomic origin- the ventricle. He would continue, often rather adamantly, to refer to the electrical waves as A, V1, & V2 throughout his career.