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:
| Field | Spreadsheet source | Meaning |
|---|---|---|
| Total mass | B2 | Wet mass, metric tons |
| Dry mass | B3 | Dry mass, metric tons |
| Mass ratio | B4 = B2 / B3 | Wet/dry mass ratio |
| Exhaust velocity | B5 | Exhaust velocity, m/s |
| Total delta-v | B6 = B5 * LN(B4) | Total available delta-v, m/s |
| Total delta-v | B7 = B6 / 1000 | Total available delta-v, km/s |
Max acceleration (A_max) | E16 = E12 / B2 * 1000 | Maximum acceleration at full mass, m/s^2 |
| Max thrust | E12 = 2 * E14 / E13 | Thrust the generator can deliver, MN |
| Drive power | E14 = E8 / 0.3 | Drive power, MW; generator output E8 divided by 0.3, because most of the drive radiation is directed outward |
| Generator output | E8 = E9 * E10 | Generator 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 * 3600Delta-v
delta_v_m_s = exhaust_velocity_m_s * ln(total_mass_t / dry_mass_t)
delta_v_km_s = delta_v_m_s / 1000Maximum 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 / 1000000000Pure 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_sIf 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_sIf 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_MThis value is useful because it shows whether a ship can cross a given theater under continuous acceleration, or whether it must coast.