Hi,
I'm trying to set-up a spreadsheet to do compressible flow calculations based on Perry's (Adiabatic Flow with Friction in a Duct of Constant Cross Section) but I'm not sure which value I should use for the isentropic index k in equation 6-120 (easy to use k at inlet conditions but this will be different from the average). If I was dealing with air I would simply use 1.4 but I'm dealing with natural gas which seems to vary a lot more with conditions.
I have attached an extract outlining this approach, Example 8 is useful but this is for air. Any advice appreciated.