A couple of years ago I build a spreadsheet for my last MVHR design. I've finally got round to making it more presentable, added some additional checks and - in preparation for a future project - have added a second section so that it calculates using PassivHaus guidelines & English Building Regs in parallel.

 

Since it may be useful there's a copy attached.

 

Mikes_MVHR_calculator_public_v2.xlsx

Fantastic, and good timing 😃

Nice spreadsheet

 

But it makes designing the MVHR overly complex.

Having just spotted an error in cells Q29 to Q34 (picking up the 'night' air volume of 15m³/hr per person instead of the 'day' value of 20m³/hr), here's version 2.1.

Mikes_MVHR_calculator_public_v2.1.xlsx