There's been a lot discussion recently in Excelmale on wanting to test for Free E2 and the relatively high cost of this test. There are online calculators which calculate an estimate of Free T based on Total T, SHBG and Albumin. However there doesn't appear to be an online calculator for estimating Free E2.

I researched the topic and found an article from 2010 by Norman Mazer, Ph.D, who created an Excel spreadsheet for calculating Free T, Free E2, Free DHT and others. The first tab in the spreadsheet is titled "user interface" and you input there the values of Total T, Total E2, Albumin and SHBG and the spreadsheet calculates the Free values.

I modified the spreadsheet slightly to make it more user friendly - changed the titles, highlighted the fields to be inputed in Blue and the results in green, and added ability to input data in nmol/L and pmol/L units and to auto convert these units. You can download the modified spreadsheet .

Enjoy!

[Moderator's note: The original links are dead, so I have attached a copy of the spreadsheet.]

I researched the topic and found an article from 2010 by Norman Mazer, Ph.D, who created an Excel spreadsheet for calculating Free T, Free E2, Free DHT and others. The first tab in the spreadsheet is titled "user interface" and you input there the values of Total T, Total E2, Albumin and SHBG and the spreadsheet calculates the Free values.

I modified the spreadsheet slightly to make it more user friendly - changed the titles, highlighted the fields to be inputed in Blue and the results in green, and added ability to input data in nmol/L and pmol/L units and to auto convert these units. You can download the modified spreadsheet .

Enjoy!

[Moderator's note: The original links are dead, so I have attached a copy of the spreadsheet.]

#### Attachments

Last edited by a moderator: