Hello to everyone, It is the first post.
I am want to transpose these equations to excel formulas:
http://img135.imageshack.us/img135/9701/15460340.jpg
I want to Calculate the T(To/T), P(Po/P),ρ(ρο/ρ) and A for a range of M
γ=1.4 and M is a range of numbers on a column(B5-B20)
=(1+((1.4-1)/2)*(B5)^2) this is for the first equation.
=((1+((1.4-1)/2)*(B5)^2))^((1.4)/(1.4-1)) 2nd
=((D5)/C5) 3rd
=(1/B5^2)*((2)/(1.4+1)*(1+(1.4-1)/2*B5^2))^((1.4+1)/(1.4-1)) 4th
I am sure that something is wrong on my equations so if anyone can help me to check them and give the correct ones i will appreciate it.
Cheers
Bookmarks