Wednesday, July 17, 2024

Requests for Rocket Engine Estimator Spreadsheet

I have seen multiple requests for my rocket engine performance estimator spreadsheet.  These requests are usually comments left on the “Rocket Engine Calculations” article posted here on “exrocketman” 1 October 2022.  That spreadsheet was “liqrockets.xls”,  and the recommended worksheet in it was “allin1des”. 

I have since reworked that spreadsheet analysis in a new Excel file named “liquid rockets.xlsx”,  with the worksheet “r noz alt”,  which includes the propellant data library worksheet from the older file,  plus an isentropic compressible flow worksheet for finding expansion Mach number and pressure ratio for a given expansion area ratio.   

This newer spreadsheet is the one I now recommend.  It comes as an Excel file,  plus a user manual as a pdf document,  and a png file into which you paste a data block generated by the spreadsheet,  for data reporting purposes.

There are 3 ways you can obtain this set of 3 files:  (1) contact me by email and I can email them to you,  (2) you can go the New Mars forums at newmars.com/forums/,  and go to the Meta New Mars section,  and to the thread titled “GW Johnson postings and @exrocketman1 youtube videos”,  with the links in post #298 of that thread,  or (3) try to use the direct link below.  These are free downloads.  You need to download the Excel spreadsheet file to make it work.  It has multiple worksheets.

Direct link to engine performance spreadsheet:

https://www.dropbox.com/scl/fi/mcmgvky9p1xukj6m6nmqo/20240330-liquid-rockets.xlsx?rlkey=zypo0wegrzzhtudesw1fiqvjk&dl=0

Direct link to user manual for spreadsheet:

https://www.dropbox.com/scl/fi/z01cwbeqesk8fnhy83o0n/20240330-User-manual-liquid-rockets.pdf?rlkey=xuoyzafq4og2tyiev3hnhpi33&dl=0

Direct link to the data reporting form:

https://www.dropbox.com/scl/fi/9scws7nh485qs9xaqfwi3/20240330-engine-sizing-report.png?rlkey=pynvmgdkohwb0gixlvrnwb7fi&dl=0

This is what that data reporting form looks like:


This is a png file created in the old 2-D Windows “Paint” utility.  You cut out the example data block,  and paste in the one you created with the spreadsheet.  Then adjust the headings above the engine sketch to match what you need.

I do recommend that you visit the New Mars forums and take a look around.  You should consider joining the forums and participating.  If you would like to join,  send an email request to newmarsmember@gmail.com

 

PS -- I verified the links,  they work.
 

No comments:

Post a Comment