Abstract: The calculation of the shock tube parameter by Excel is introduced, the work was done with one dimension inviscid simulation. In the calculation, the driver gases were H₂, He, Ar and their mixtures, and the experimental gases were N₂ and Ar. Additionally, the double diaphragm effect of the main diaphragm was considered, respectively obtained the operation parameters matching relationship, the best length ratio of driving section and driven section, the maximum test time under tailored interface condition.The study showed that, the parameter of the shock tube could be calculated by the software of Excel, the results could be shown in the designed table obviously, and they could be further processed to be a curve figure. The primary calculation results indicated that, compared to the ideal gas model, the shockwave was weaker and the test time was shorter with the real gas model. And the shockwave was strengthened by the diaphragm breaking with deflating gas between diaphragms.

Key words: Excel, shock tube, tailored interface, diaphragm