MTU has this wonderful explanation of the differences in physics between open/closed conical and cylindical bore instruments. Try some of the equations out in grapher or an equivalent!
Open cylindrical bore (e.g. panpipes):
Closed conical bore (e.g. saxophone):
where n is the harmonic e.g. 1, 2, 3, 4 etc. in both cases.