## Thursday, December 29, 2022

### Cepheus Engine Ship Stats: Removing Tables and Using Formulas

In Cepheus Engine Ship Creation the following Are Tables that Should be converted to Simple formulas.

1. Hulls Cost and Dtons.
2. MDrives, JDrives and Power Plants.
3. Bridges and Cockpits.
4. Computers
5. RANGES for both Sensors and Combat.
Simple Averages can be used to Calculate how the tables work out.
1. Hulls. Get the Cost/DTON. So average is about 60,000 per dton. With prices going as high as 100k/dton. Since we are going to make these Non-Gravitic the prices should be as low as 1/10 or 1/3. Let’s have a conservative 1/3 or 20,000Cr per dton (which is equal to 10 mass ton capacity and 15 cubic meter volume).
2. MDrives and JDrives - this is a fun and simple puzzle. How do I get the correlations of the data which should be something I could do as part of my job and a gamer. The simple solution I though of was the Performance ratio. Begin with the Performance per Ship Dtons and Dtons of Component. Ok.
1. Q: What are the relationships? A: I want Performance is related to its Dtons of Component = Per/Comp.Dtons. So I get the performance per Comp.Dtons.
2. But now I have a new problem - the performance should go down per shipdtons. (Performance/CompDtons)/ShipDtons.
3.  I arrive at the Performance per Component Dtons per ship Dtons. But I cannot use that.  I need a relative Value to work with not just straight Dtons of Component. I need % of the ship. (Dtons/Ship). I cannot work with 0.1 Jump/Accel per comp.DT/ship.DT
4. I have to isolate the Component Dtons % of the Ship. Component Dtons / ShipDtons / performance. I arrive at a Performance of 1 = 2.5% of the Ship’s Dtons of Components. Round Dtons of Component Up.
5. So a Performance 1 Ship would be 1-2.5% of their Dtons for MDrive. And 5-12.5% for JDrive.
3. So the Maneuver Drives (and there for Reaction Drives) will be 2% per Dtons of Ship per Unit of Performance: Acceleration. To get Thrust just get multiply Ship Dtons by 10 mass Tons and multiply this by 9.8M/s^2 and Acceleration. A 100Dton Ship at Accel 4 = 100dtons x 10 mass tons x 9.8 x 4 = 39.2 MN of thrust. So a 100Dton ship with Acceleration of 4 has 8% of their Dtons in M/RDrives. Or 8Tons. Averaged out thats 2M/dton of MDrive. For Reaction Drives thats 1/10 for 0.2M.  In CE Tables its average about 2.1M/dton
4. The Jump drives is 5x as much at 10% of Ships Hull per Jump level at 2M.  In CE Tables its 1.7M/dton. Keep it Simple round off. So a Jump 1 capable courier is 10dtons.
5. Power Plants are purely for Jump Drives and Energy Equipment. A Powerplant can support X Dtons of Jump Drive and High Energy Components equal x2 their Dtons. 10dtons of Jump requires 5dtons of Power Plants. For Non-High Powered Components, a dton of power plant  supports 10dtons. So the same power plant can maintain 50dtons of components.
1. TL determine Days, Weeks, and Months of Power.
6. Bridges and Cockpits should be simpler. Minimum 1 dton which can fit 1 person with computers, controls and sensors. Needs 5% of the ship. At only 2% DM-1 for checks. Double at 10% of the ship DM+1. At 100,000Cr per dton of controls. There is enough Life support in the Controls for 1 person per dton.
7. 5Dtons per Turret. As a 4 dton = 1 40ft container or 2Dtons = a 20ft Container. You can imagine a Turret is an extruding 20ft container bump on the ship. Maximum of 10% of the ship.
8.  Axis Mounted Weapons and Simple Launch bays - launch bays have enough reaction mass to push the object out or mechanical push systems that eject the object out.  Imagine launching a 10 or so missiles without any delta V except the delta v to move it away from the ship. Then its reaction drives kicks. Axis Mounted weapons - imagine a 60m diameter spin gravity with a Mass Driver attached along the circumference - launching missiles or projectiles.
9. Computers being DATA CENTERS with HVac, power supplies and protection, shielding and hardening and redundancy. as 1DTON = 15 cubic meters and a micro data center unit is easily just 2.0 cubic meters.
10. Range Combat and Sensors

Javascript/Google App script is needed for the Drop Downs.  That took about 2 nights. And even after figuring it out I had a lot to think about - like how to order the information.
You will notice 3 Qty. The first quantity is a reference quantity typically Number of UNITS or the Dtons of the ship.
I had to watch "Learn Google Spreedsheet" to review IFS (many ifs) and OR() and AND() functions. Then I had to google how to create NESTED quotes. so I need to add a certain number of quotes that I don't full understand even if I made it work. Trial and Error - using the feedback of it working. I think we get overloaded and we cant understand it anymore and rely purely on the black box - not knowing how it works but knowing If I do X then Y is the outcome.

So I need to make these all manageable. Like instead of EVERY battery and TL power Plant looks an Index Match.

This is my first try - I later realized I should use an Index Match for this. That is another mental ORDERING of how this will all lookalike.

Creating a Table for this is hard.

Next I have to have a Column that Simplifies all the text.
I'm still studying the Orbital period. I learned  Mu or mu (µ) and its gravitational constant and mass. My problem is that there is a lot of PREREQUISITE knowledge when mike aben is talking - like having to remember everything in the previous Videos in his kerbal.

I will have to have to use a WORKAROUND - particularly Circumference and ΔV - that the ship is orbiting at the Speed of its ΔV and it takes X hours per orbit.
in ΔV every Position is an ORBIT.
A % of Orbit Time (possible to have more than 100% orbit) = Orbital Period per leg of the trip.
so I add up all the Orbital periods until I'm at my destination.
https://deltavmap.github.io/?system=Solar&origin=LEO&destination=LMarsO

so ifts 4 months to get to Mars at 6kms. Spending 24kms would be probably 1 month.