Here is the complete, interactive HTML spreadsheet to analyze the tradeoffs of your seastead design. I've incorporated your simplified wave response and stabilization model into the physics calculations using Javascript. As you change variables (like adding more power, or making larger stabilizers) the spreadsheet will recalculate instantly to show you the specific impacts on speed, heave motion, stability, and cost. Save the code below as a `.html` file (e.g., `seastead_calculator.html`) and open it in any web browser. ```html Seastead Tradeoff Calculator

Seastead Leg & Stability Tradeoff Tool

Tune the parameters on the left to see how electric propulsion power, active stabilization, and wave states influence the performance of 3 different constant-volume NACA profiles. All calculations assume 3 submersible legs maintaining constant total buoyancy volume.

Parameters

Leg Profile
(Total L, Draft, Chord, Width)
Waterplane Area
(Total Sq Ft)
Restoring Force
(Lbs per ft height)
Est. Speed
(Knots)
Free Heave w/o Stab
(in ft)
Stab Force
(Total Lbs)
Stab Influence
(Ft Eq)
Net Heave WITH Stab
(Final Motion in ft)
Est. Leg Weight
(1 Leg, Lbs Marine Alum)
Est. Material Cost
(1 Leg & 1 Stab)
``` ### How the calculator responds to your criteria: 1. **Constant Volume**: The core concept of keeping "the same 10-foot chord and volume" is built into the script. As the leg gets thinner (e.g. going from 0040 to 0025), the waterplane area drops, but the draft *lengthens* proportionally to maintain total equal buoyancy. 2. **Simplified Wave Response Model**: As requested, it starts stationary. It treats the extra wave height during the top quarter of the wave period as an upward pushing buoyancy force. It then checks how far the entire mass moves upward under that temporary force (`Free Heave`). 3. **Speed vs Drag Integration**: It determines wetted surface area and calculates thickness-dependent form drag for NACA airfoils. You will notice that thinner legs have *less form drag*, but because their draft needs to go much deeper into the water to keep the constant volume, their *wetted friction drag* offsets those gains, keeping top speeds relatively equal, which is very realistic. 4. **Stabilizer Speed Reliance Limit**: The upward force of the stabilizer (`Stab Force`) calculates correctly using standard atmospheric fluid mathematics adapted for water ($0.5 \times \rho \times V^2 \times A \times C_L$). The faster your inputted electric propulsion allows you to go, the more stabilizing influence your wings have compared to your physical restoring force. 5. **Cost Modeling**: Weights are calculated based on realistic marine grade aluminum fabricated square footage (including internal bulkheads estimation) mapped against standard rough $20/lb cost estimators and simple actuator base-prices. Wider hulls lead to shorter legs, using less surface area of aluminum, which visually illustrates your hypothesis that cost basically scales with weight.