Spread Sheet Review - Air Pressure Crumple Zone

Hi, I’m looking for someone to review the attached Excel spreadsheet rectifying any false assumptions. The calculations are for an AIR Cushioning system being used as a Crumple Zone for a Crash Proof Vehicle. The math is fundamental and the presentation simple but what Im trying to do is near impossible. My apologies for my amateur math skills but I cannot trust myself with Pressure Formulas using Kinetic Energy. The attached spreadsheet is laid out in the manner useful to see the significant data. I know that I’m in way over my head but that’s inventing. So I need your help. The first Milestone, $50.00, easy money. How much Kinetic Energy it takes to compress an airspring from 12 to 2 inches with a diameter of 9 inches at 1 atmosphere (14.6 PSIA) and how does that match up with the KE required to stop a Vehicle in ten inches. Let’s say 1500 lb vehicle at 22MPH @ 32,000 joules. It’s that simple. That’s all that is really needed for the first milestone. However, what I’m really looking for is the pulse of -ke over the elapse time .026s in the scenario of a car crash. Obviously, the Kinetic Energy is converted to potential energy in the manner of PSI rising as the volume compresses.. Once the parameters of the compressed volume are ascertained we can calculate the necessary flowrate to discharge or sequestration of the pressurized volume preventing the vehicle from any excessive recoil. You will get a good idea of the project at [login to view URL] . Be sure to turn up the sound on the Epic Fail video on the test page. And the build page shows some Drop Test videos along with a story about the crumple cans I used last test. Basically, I used the same math technique and I nailed it! Possible components: Truck Air Spring, 2” Solenoid Air valve, Pressure relief valve, Air Sequestering Reservoir, Check Valve. (see Spreadsheet) Purpose: the crumple zone is to protect the vehicle and allow time for the rotation of the occupant’s head to transit below the axis of rotation (23deg) at which time the heavy mass load that is hanging straight down will get a kick from the exhausted crumple zone. AND Most Importantly there can be no substantial recoil. Basic Plan: At least Two Air Springs to compress and convert the Kinetic energy of a collision resulting in an increase of PSIA. Force value can be adjusted by increasing initial PSI settings to stiffen up the bumper to accommodate for various speeds. At full compression of the airspring stroke a gforce sensor using an Arduino Microcontroller will trigger a Solenoid Air Valve large enough to discharge the compressed volume and decreases the PSI in microseconds. Current calculation indicates the air spring is too stiff even at 1 atmosphere. An Air Sequestering Reservoir with check valves has been included into the calculation and all is solved. Sequestering mitigates the need of a high flowrate and drastically changed the discharge danger priority and fail rate. So I am good to go! Just the one looming question, How muck Ke does it take to compress said volume over time? My spreadsheet is a hack job, which offers proof that need help. Thank You for any assistance you may offer, Ed Dooner