Helper notes for calculating warship propulsion and transit values from dd.xlsx.

The spreadsheet contains several transit blocks. The most useful card-level profiles use the ship’s own delta-v budget and two accelerations: a typical transfer at 10 m/s^2 and a rush transfer at the ship’s maximum acceleration (A_max).

Cards show both because a static card cannot know which regime matters at a given moment. The old 15 m/s^2 “tactical” value (G17) was only a design target set for as many ships as possible; it is no longer used on cards.

Source Cells

Per ship sheet:

FieldSpreadsheet sourceMeaning
Total massB2Wet mass, metric tons
Dry massB3Dry mass, metric tons
Mass ratioB4 = B2 / B3Wet/dry mass ratio
Exhaust velocityB5Exhaust velocity, m/s
Total delta-vB6 = B5 * LN(B4)Total available delta-v, m/s
Total delta-vB7 = B6 / 1000Total available delta-v, km/s
Max acceleration (A_max)E16 = E12 / B2 * 1000Maximum acceleration at full mass, m/s^2
Max thrustE12 = 2 * E14 / E13Thrust the generator can deliver, MN
Drive powerE14 = E8 / 0.3Drive power, MW; generator output E8 divided by 0.3, because most of the drive radiation is directed outward
Generator outputE8 = E9 * E10Generator volume times power density, MW (E10 = 2000 * EXP(0.6 * LOG10(E9)), so output scales favourably with volume)

G17 / G18 / G22 (a 15 m/s^2 design target and the thrust/power it would need) are not card data: for several ships the generator cannot reach that target, and for others it exceeds it.

The older visible transit blocks use fixed, scenario-level acceleration values and are useful as examples, but less useful as card data because they do not depend strongly on each ship.

Constants

AU_M = 149597870691
REFERENCE_DISTANCE_AU = 5
REFERENCE_DISTANCE_M = REFERENCE_DISTANCE_AU * AU_M
BURN_COAST_BURN_TOTAL_BURN_H = 50
BURN_COAST_BURN_HALF_BURN_S = 25 * 3600

Delta-v

delta_v_m_s = exhaust_velocity_m_s * ln(total_mass_t / dry_mass_t)
delta_v_km_s = delta_v_m_s / 1000

Maximum Thrust And Power

Taken directly from the sheet (E12, E14, E16), not derived from a chosen acceleration:

drive_power_MW = generator_output_MW / 0.3
thrust_MN = 2 * drive_power_MW / exhaust_velocity_m_s
max_acceleration_m_s2 = thrust_MN * 1000 / total_mass_t
drive_power_PW = drive_power_MW / 1000000000

Pure Brachistochrone / Flip-And-Burn Profile

Use a symmetric accelerate/decelerate transfer over a reference distance, accelerating for the first half and decelerating for the second half.

required_dv_m_s = 2 * sqrt(reference_distance_m * acceleration_m_s2)
total_time_s = 2 * sqrt(reference_distance_m / acceleration_m_s2)
burn_time_s = total_time_s
coast_time_s = 0
peak_velocity_m_s = sqrt(reference_distance_m * acceleration_m_s2)
delta_v_reserve_m_s = delta_v_m_s - required_dv_m_s

If delta_v_reserve_m_s is negative, the ship cannot fly this pure brachistochrone profile at the chosen acceleration without exceeding its delta-v budget.

Fixed-Burn Burn-Coast-Burn Profile

For a fixed total burn duration of 50 h, split into 25 h acceleration and 25 h deceleration:

burn_time_each_s = 25 * 3600
burn_time_total_s = 2 * burn_time_each_s
delta_v_used_m_s = 2 * acceleration_m_s2 * burn_time_each_s
peak_velocity_m_s = acceleration_m_s2 * burn_time_each_s
burn_distance_m = acceleration_m_s2 * burn_time_each_s^2
coast_distance_m = reference_distance_m - burn_distance_m
coast_time_s = coast_distance_m / peak_velocity_m_s
total_time_s = burn_time_total_s + coast_time_s
delta_v_reserve_m_s = delta_v_m_s - delta_v_used_m_s

If coast_distance_m is negative, the fixed burn is too long for that distance at the selected acceleration. If delta_v_reserve_m_s is negative, the ship does not have enough delta-v for the profile.

Maximum Flip-and-Burn Range

This is the maximum distance the ship can cover using a pure accelerate/decelerate profile at the chosen acceleration (10 m/s^2 or A_max) without coasting:

max_flip_burn_distance_m = (delta_v_m_s / 2)^2 / acceleration_m_s2
max_flip_burn_distance_au = max_flip_burn_distance_m / AU_M

This value is useful because it shows whether a ship can cross a given theater under continuous acceleration, or whether it must coast.