a monster spreadsheet to use in clinical visits

categories: spreadsheet

Frankenstein

Here are some screenshots of individual components of the Frankenstein spreadsheet.

Below is the opening sheet which has the terms/warning information. opening sheet

The next sheet (sheet ‘a’) has the list of patients and all of the patient specific information. Below are the demographic items at the left side. demographics

Below is a video demonstration of the entry of the demographic information.

As you move to the right, there are spots for lab entry. Below is a selection of some of these labs. lab entry

The labs are connected to the next sheet (sheet ‘b’) and these are set up with normals. The normals that are already there should be considered with caution because they are almost certainly not the exact normal ranges for the patients you’re dealing with. Below is a selection of the existing (not entirely correct) lab normals. lab normals

Back to the main sheet (sheet ‘a’) and you move to the right and you’ll see some of the calculated items.

The first calculated item is the corrected calcium. This is seen in the screenshot below. corrected calcium

The next item is the APRI (AST to Platelet Ratio Index) and interpretation. This is seen in the screenshot below. APRI

The next item moving right is the ANI (ALD/NAFLD Index) and interpretation. This is seen in the screenshot below. APRI

Moving further to the right is the ASCVD (Atherosclerotic Cardiovascular Disease) Risk calculation. It is seen in the screenshot below. ASCVD Risk

Below is a video of the calculation of the APRI and ASCVD risk.







Downloads

The most current version of the excel spreadsheet is here

All versions are below.
February 7, 2024
details about this update are at this post about removing message box warning clutter
January 21, 2024
details about this update are at this post about lifetime ASCVD risk, this post about 10-year ASCVD risk, and this post about custom functions in general.
December 23, 2023
this was the starting point.