Input original conditions (CFM1, SP1, BHP1) and a new RPM. Let Excel calculate all three new values instantly. Lock the original values with $ references.
You can find pre-built Excel tools and manuals from these reputable engineering and industry sources: ASHRAE 62.1 Ventilation Calculation Excel Sheet (xls) #HVAC hvac design calculations excel
Excel excels at handling the repetitive yet formulaic nature of heat gain calculations. The most common manual method is the CLTD/CLF/SCL (Cooling Load Temperature Difference / Cooling Load Factor / Solar Cooling Load) method. Input original conditions (CFM1, SP1, BHP1) and a new RPM
Excel can compute essential air properties if you input dry-bulb and wet-bulb or RH. Input original conditions (CFM1