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.
Download
Order a Peak Flow
Do you need a peak flow meter? Order one on Amazon today!
https://amzn.to/3WKRvuD
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.
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. Alternativly, you can download the unlocked version here: https://lee-t.com/downloads/peak-flow-meter-unlocked-version/ Hope you find this useful.
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
Hi Robin,
I locked the file down (to help people less computer literate to manage the data/chart) without pressing something wrong.
You can download an unlocked version here: https://lee-t.com/downloads/peak-flow-meter-unlocked-version/
Hi
What’s the chanced of getting a version of the spreadsheet that’s not password protected?
Cheers
D
Hi D, You can download the unlocked version from here: https://lee-t.com/downloads/peak-flow-meter-unlocked-version/
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
Kim, make sure that you are adding the time as HH:MM which should resolve the issue.
HiLee,
I think your test diary is just what I need as I’ve been asked to keep arecord for the next month or so could you kinldy send me an unlocked version?
Many thanks,
Colin.
Hi Colin,
The existing download is for 2 weeks (this is usually the standard time a GP etc would ask you to complete for).
You can use that twice, (i.e. 4 weeks) or if you require an unlocked version you can download from here: https://lee-t.com/downloads/peak-flow-meter-unlocked-version/
Is it possible to adapt the spreadsheet to indicate what the dirurnal variation is?
Hi James, Sure, I’ve made an adjustment here: https://lee-t.com/downloads/peak-flow-with-variation/
Hi
I can’t see how you are calculating diurnal variation in peak flow as Icant see the calculation that you have used. To calculate diurnal Peak Flow variation the following calculation can be used:
AvgDailyVariability = 100 * (HighestPEF – LowestPEF) / HighestPEF
Thanks James, you can find an updated file here:
https://lee-t.com/downloads/peak-flow-with-variation/
The variation is calculated on by the following formula =MAX(E2:G2) – MIN(E2:G2)
Hi
You kindly updated your Peak Flow Spreadsheet to incorporate variability. However, I think in your modified spreadsheet you are just calculating the variation between the three PEF blows for the morning (am) and the variation of the three PEF blows for the afternoon (pm).
What I wanted is average daily variability, not variation between three blows. To calculate Average Daily variability, which is a percentage (%), the following equation is used:
AvgDailyVariability = 100 * (HighestPEF – LowestPEF) / HighestPEF
As in patients with asthma a they may have a higher PEF in the morning and a lower PED in the afternoon, so that is why we want to calculate the daily variability between the highest PEF in the morning and the highest PEF in the afternoon.
Can you modify the spreadsheet to do this?
Cheers,
James
Hi James,
Can we use =VAR.P(E2:G2) here? (As the example top row)?
If you had 3 results, say 320, 325, 330 – What is the expected % Variation?