Game in the Brain

https://youtu.be/34TRvvWkijg

Here’s a concise, blog-friendly write-up of where you are with the Mongoose Traveller 2E macro, how folks can use it today, and what’s still on your to-do list. Feel free to tweak tone or call out anything I’ve misunderstood or missed.

---

How to Use the Macro Today

• Define your range
  • In the top-left corner of your sheet enter the cell range (e.g. A10:L80).
  • This tells the script which rows to scan for DT, cost, etc.
• Trigger recalculations
  • Whenever you paste in a new table (or add/remove rows), re-paste an existing row or option to force the sheet to recalc.
• Cargo, Docks & Hangars
  • It adds up all DT up to the “CARGO” section and then includes any Docks/Hangars.
  • Note: it does not dive into the contents of Cargo or vessels—just their container DT.
• Dynamic dropdown workflow
  1. Go to the “Dynamic Dropdown” sheet.
  2. Pick your Section → Component → Option.
  3. Copy-paste the Option name and Qty back into your main sheet to trigger the formula.
• SOP for building new ships
  • Start by duplicating a template ship row-for-row.
  • Then update Options & Qty via copy-paste to recalc.
  • After “Cargo,” list your Docks/Hangars and then immediately list the vessels they hold. The macro tags those vessels in column P automatically.

---

Progress So Far

• Core DT & cost calculations (up through Cargo) are working.
• Dock/Hangar DT aggregation is in place.
• Dynamic dropdowns populating main sheet and driving recalcs.
• SOP documented for “copy-existing → edit → recalc.”

---

What Remains to Be Done

Feature / Section	Status	Notes / Action Items
Merged-cell “Summary” block	Incomplete	Pull key ship stats into merged rows at top (e.g. Name, TL, DT, Cost, Jump, Thrust, DVB).
Empty Cost vs Total Cost	Pending	Empty Cost = macro should exclude vessel/cargo contents; then compute total including them.
Jump & Thrust stats	Pending	Extract Jump Range; M-Thrust; R-Thrust; compute Delta-V Budget from full reaction-fuel tank.
Module & DT×Qty listing	Partial	Bridges, Sensors OK; still need staterooms, berths, cabins, common areas, seating.
Systems list	Pending	Populate a simple comma-separated list of installed systems.
Cargo contents & vessel list	Partial	Macro tags vessels; need to list cargo items and vessels in summary.
Capacity tracking	Pending	Cargo cap/used/left; dock & hangar cap/used/left; room cap/used/left.
Cost & crew estimates	Pending	Maintenance cost (0.1% of Empty Cost); min. crew & salaries; estimated monthly cost (2 jumps/mo).
Availability & break-even metrics	Pending	Cargo & accommodation availability; half-month break-even per cargo and per room.

---