Managing Hair Growth Data

**Shastrix** · November 3rd, 2009, 03:44 PM

Whenever I remember I like to measure the length of my hair. Up until now I have been storing the info on my iPhone, but today I thought I'd put it into Excel. It then struck me that I could do interesting things in Excel and thus my "Hair Spreadsheet" was born. I thought I'd share, in case anyone else was interested in collating their own "hair stats":

There are four versions to suit the various date and unit preferences; one for those who use metric and "dd/mm/yyyy" dates, one for those who use imperial and "dd/mm/yyyy" dates, one for those who use metric and "yyyy-mm-dd" dates, and one for those who use imperial and "mm/dd/yyyy". I have included some sample screenshots below (you can click to see a larger image).

Main Page

Graph displaying growth and goals

Alternative Methods page

Terminal Length Calculations page

To summarise; you first stick in your vital stats (the length you need to be to arrive at APL, BSL, Classic etc) then whenever you measure you input the date and length - you only have to edit the green shaded columns. The spreadsheet then tells you what your change from your last measurement was, what the mean rate of growth is (per day, week, month, year), how much your hair needs to grow to reach your various goals, predicts how long this will take in days, months and years, and tells you the estimated date you will reach your goal. It also estimates, plots a graph of hair growth; estimates, using two methods, your terminal length, and helps you calculate the diameter of your hair.

See the later posts by me for up-to-date information about the spreadsheet

Current Version:

Metric/Imperial and "dd/mm/yyyy" Version 1.5.0:
Click here to download Excel file.

Imperial/Metric and "dd/mm/yyyy" Version 1.5.0:
Click here to download Excel file.

Metric/Imperial and "yyyy-mm-dd" Version 1.5.0:
Click here to download Excel file.

Imperial/Metric and "mm/dd/yyyy" Version 1.5.0:
Click here to download Excel file.

The file is in an .xls format so should be compatible with all Excel versions. It is only a beta so if you spot any mistakes please tell me. There is no charge, and feel free to edit and improve as you see fit.

Hope some of you enjoy!

Last version
Metric/Imperial and "dd/mm/yyyy" Version 1.4.4: Click here to download Excel file.
Imperial/Metric and "dd/mm/yyyy" Version 1.4.4: Click here to download Excel file.
Metric/Imperial and "yyyy-mm-dd" Version 1.4.4: Click here to download Excel file.
Imperial/Metric and "mm/dd/yyyy" Version 1.4.4: Click here to download Excel file.

**florenonite** · November 3rd, 2009, 03:51 PM

This looks brilliant! Thanks for sharing

**missjessiecakes** · November 3rd, 2009, 03:52 PM

Oh this is soooooo Cool!

**Heidi_234** · November 3rd, 2009, 03:55 PM

Great mind think alike.

But I like the goal ETA part. Thanks for sharing, I'm sure many would find it most useful!

**23_seconds** · November 3rd, 2009, 03:57 PM

Very cool, thanks for sharing.

**Vrushali** · November 3rd, 2009, 03:57 PM

Thats Awesome!!!!

**Shastrix** · November 3rd, 2009, 04:07 PM

Originally Posted by Heidi_234

Great mind think alike.

But I like the goal ETA part. Thanks for sharing, I'm sure many would find it most useful!

After viewing your spreadsheet I have added a "change from last measurement" column. If anyone has downloaded the spreadsheet before this post they will need to re-download to get the new version.

**Hiriel** · November 3rd, 2009, 04:57 PM

Too awesome. The nerd approves!

(Gah, I'll become obsessive with the measuring now. Imagine I came here without any specific plans to grow my hair any longer...)

**Arriens** · November 3rd, 2009, 05:49 PM

I am amazed by your "Time Until Goal is Reached" formula.

Well done.

15 years to go for floor lenght.

**missjessiecakes** · November 3rd, 2009, 05:54 PM

I am obsessed. Very Very Obsessed. My dearest boyfriend said to tell you that he is glaring.

I Cant measure my own hair properly so he has to do it. But it is so amazing. Thank you ever so much. <3