Peak Flow Test Diary – Excel Template

Time to read: 4 mins

After a recent visit to the doctors, I was asked to take a peak flow test and record my results. I was provided a link to the “Asthma” website to fill in a “Peak Flow Diary” but meant I had to print it out and find a pen, so I decided to make one within excel, I mean, why not?

So if you have to do a Peak Flow Test Diary then please see below my excel template download below:

What is a peak flow test diary?

In short, it measures how quickly you can blow our air from your lungs, the lower the reading the less air you have been able to blow out. The chart is able to detect and see how your asthma is or isn’t doing.

A “normal” reading on a peak flow is between 400 and 700 liters per minute.

8 Replies to “Peak Flow Test Diary – Excel Template”

  1. Great sheet and will be very useful, but how do I edit it as the dates cannot be changed, the sheet is protected and requires a password.

    1. Hi Rob,
      In Cell C2, you will see that this date is highlighted in a light blue, you can enter the start date and then the rest of the dates will update accordingly. Hope you find this useful.

  2. Hi lee,
    Is there an easy way to edit the chart to monitor more than 14 days please?
    The chart is great by the way and my son now enjoys doing his peak flow test as he can use the chart at the end.
    Thanks Robin

    1. Hi Robin,
      I locked the file down (to help people less computer literate to manage the data/chart) without pressing something wrong.
      I’d be happy to make an adjustment for you and send it across – if you want to email me.

  3. Hi

    What’s the chanced of getting a version of the spreadsheet that’s not password protected?

    Cheers
    D

  4. Hi Lee

    Please could you let me know how i can get column D (time) t work as it keeps returning to 00.00 when ever i add the time

    1. Kim, make sure that you are adding the time as HH:MM which should resolve the issue.

Leave a Reply

Your email address will not be published.