Excel Fomula Help - CFM/ft into L/S/M

[Puzzled]

TL;DR Summary

Excel Fomula Help Please

Hello,

I am struggling to create a formula in excel that coverts CFM per linear foot to liters per second per linear meter.

Thank you for your valued help.

 

[DaveE]

You just need to multiply by the unit conversion factors. Google can help. Also this site https://www.convertunits.com/

1 CFM = 28.316847 l/min
1 min = 60 seconds
1 ft = 0.3048 m

also 1 CFM = 1 ft³/min
and 1 litre = 0.001 m³ if you prefer

so $1 \frac{ft^3} {ft⋅min} = 1 \frac{ft^2} {min} = 1 \frac{ft^2} {min}⋅(\frac{0.3048⋅m} {ft})^2⋅( \frac{1⋅min} {60⋅ sec})⋅( \frac{1⋅litre}{0.001⋅m^3}) = \frac{0.3048^2}{60⋅0.001} \frac{litre}{m⋅sec} = 1.548 \frac{litre}{m⋅sec}$

notice that the terms in the parentheses are all equal to 1, i.e. $( \frac{1⋅min} {60⋅sec} )= 1$. So you can think of unit conversion as just multiplying by 1 several times combined with a judicious choice of how you represent 1 to cancel the units you don't want and add in the ones you do. But each time you have to make sure the units match up to always equal 1. You can't multiply by $(\frac{1⋅m} {ft})$ because 1 meter isn't the same as 1 foot; $(\frac{1⋅m} {ft}) = 3.281$ not 1.