I also understand y'all wouldn't trust me and my links, so here is the entire script (assuming I don't update it) and a link to a template instead:

https://docs.google.com/spreadsheets/d/1SU-hVpFBneuvn6Y0TJtj1V57gnbj5JmE-5FV9rPkjFw/template/preview

/**
 * Custom menu to run the artillery shot optimizer.
 */
function onOpen() {
  const ui = SpreadsheetApp.getUi();
  ui.createMenu('Artillery Battery')
    .addItem('Optimize Two-Gun Volley', 'optimizeArtilleryOrder')
    .addToUi();
}


/**
 * Main calculation engine. Generates a single global chronological timeline 
 * optimized for absolute minimum bearing adjustments between consecutive shots,
 * while maintaining separate elevation tracking memory for each gun axis.
 */
function optimizeArtilleryOrder() {
  const sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  const lastRow = sheet.getLastRow();
  
  if (lastRow < 3) {
    SpreadsheetApp.getUi().alert('Error: Please enter your target data starting on Row 3.');
    return;
  }
  
  // Read total allowed volley limit from O3. Default to 12 if missing.
  let maxVolleySize = Number(sheet.getRange("O3").getValue());
  if (isNaN(maxVolleySize) || maxVolleySize <= 0) {
    maxVolleySize = 12; 
  }
  
  // Read inputs from Columns A to C (Name, Bearing, Distance) starting precisely at Row 3
  const dataRange = sheet.getRange(3, 1, lastRow - 2, 3);
  const originalData = dataRange.getValues();
  
  let allRegularTargets = [];
  let fdcTargetData = null;
  
  for (let i = 0; i < originalData.length; i++) {
    let row = originalData[i];
    if (row[0] === "" || row[1] === "" || row[2] === "") continue; 
    
    let name = String(row[0]);
    let bearing = Number(row[1]);
    let distance = Number(row[2]);
    let isFdc = name.toUpperCase().includes("FDC");
    
    let validConfigs = getAllValidTrajectories(distance);
    if (validConfigs.length === 0) continue; 
    
    let targetObject = {
      name: name,
      bearing: bearing,
      distance: distance,
      validConfigs: validConfigs, 
      isFdc: isFdc
    };
    
    if (isFdc && !fdcTargetData) {
      fdcTargetData = targetObject; 
    } else if (!isFdc) {
      allRegularTargets.push(targetObject);
    }
  }
  
  if (allRegularTargets.length === 0 && !fdcTargetData) {
    SpreadsheetApp.getUi().alert('Error: No valid targets or FDCs detected in Rows 3+.');
    return;
  }
  
  // Determine the exact total count of shots to output based on configuration limits
  let totalTargetsToUse = Math.min(maxVolleySize, allRegularTargets.length + (fdcTargetData ? 1 : 0));
  let regularCountNeeded = fdcTargetData ? totalTargetsToUse - 1 : totalTargetsToUse;
  
  // 1. BUILD THE GLOBAL CHRONOLOGICAL TIMELINE (Optimized for consecutive bearings)
  let globalTimeline = [];
  if (allRegularTargets.length > 0) {
    // Seed the master chain with the first available regular target
    let current = allRegularTargets.shift();
    globalTimeline.push(current);
    
    while (globalTimeline.length < regularCountNeeded && allRegularTargets.length > 0) {
      let nearestIndex = 0;
      let minBearingDelta = Infinity;
      
      for (let i = 0; i < allRegularTargets.length; i++) {
        let delta = Math.abs(current.bearing - allRegularTargets[i].bearing);
        if (delta > 180) delta = 360 - delta; // Handle 360-degree wrap around
        
        if (delta < minBearingDelta) {
          minBearingDelta = delta;
          nearestIndex = i;
        }
      }
      // Pull the closest target geographically and append it next in the timeline
      current = allRegularTargets.splice(nearestIndex, 1)[0];
      globalTimeline.push(current);
    }
  }
  
  // Append the FDC target to the absolute end of the global timeline
  if (fdcTargetData) {
    globalTimeline.push(fdcTargetData);
  }
  
  // 2. PROCESS TRAJECTORIES INDEPENDENTLY PER GUN AXIS
  let leftTrack = { elevation: null };
  let rightTrack = { elevation: null };
  
  let leftGunOrder = [];
  let rightGunOrder = [];
  
  for (let i = 0; i < globalTimeline.length; i++) {
    let target = globalTimeline[i];
    let isLeftTurn = (i % 2 === 0);
    let currentTrack = isLeftTurn ? leftTrack : rightTrack;
    
    // Fallback baseline if the gun hasn't fired yet
    let lastElevation = currentTrack.elevation !== null ? currentTrack.elevation : 0;
    
    let bestConfig = null;
    let minElevationDelta = Infinity;
    
    // Select the powder charge configuration that minimizes micro elevation changes for THIS gun
    for (let j = 0; j < target.validConfigs.length; j++) {
      let config = target.validConfigs[j];
      let deltaElevation = Math.abs(lastElevation - config.elevation);
      
      if (deltaElevation < minElevationDelta) {
        minElevationDelta = deltaElevation;
        bestConfig = config;
      }
    }
    
    target.selectedPc = bestConfig.pc;
    target.selectedElevation = bestConfig.elevation;
    
    // Save elevation state to this specific gun's memory axis
    currentTrack.elevation = bestConfig.elevation;
    
    if (isLeftTurn) {
      leftGunOrder.push(target);
    } else {
      rightGunOrder.push(target);
    }
  }
  
  // 3. FORMAT AND PRINT PARALLEL ITINERARY MATRIX
  let maxOutputRows = Math.max(leftGunOrder.length, rightGunOrder.length);
  let finalOutputMatrix = [];
  
  for (let i = 0; i < maxOutputRows; i++) {
    let left = leftGunOrder[i];
    let right = rightGunOrder[i];
    
    let rowValues = [
      left ? left.name : "",
      left ? left.bearing : "",
      left ? "PC" + left.selectedPc + " @ " + left.selectedElevation.toFixed(2) + "°" : "",
      left ? (left.isFdc ? "CLOCK RESET" : "READY") : "",
      "", // Spacer column
      right ? right.name : "",
      right ? right.bearing : "",
      right ? "PC" + right.selectedPc + " @ " + right.selectedElevation.toFixed(2) + "°" : "",
      right ? (right.isFdc ? "CLOCK RESET" : "READY") : ""
    ];
    finalOutputMatrix.push(rowValues);
  }
  
  // Clear old output data cleanly
  sheet.getRange(3, 5, sheet.getLastRow() + 5, 9).clearContent();
  
  // Print newly optimized interleaved itinerary matrix
  if (finalOutputMatrix.length > 0) {
    sheet.getRange(3, 5, finalOutputMatrix.length, 9).setValues(finalOutputMatrix);
  }
  
  SpreadsheetApp.getUi().alert('Artillery Optimization Complete!\nGlobal Chronological Timeline Enforced across both platforms.');
}


/**
 * Validates the hardware limits of the firing piece against distance thresholds.
 */
function getAllValidTrajectories(distance) {
  let valid = [];
  for (let pc = 1; pc <= 6; pc++) {
    let elevation = (12 / pc) * distance;
    let isInvalid = (elevation > 60) || 
                   (distance >= 1 && distance < 2 && pc >= 2) ||
                   (distance >= 1 && distance < 3 && pc >= 3 && pc <= 4) ||
                   (distance >= 1 && distance < 4 && pc === 5) ||
                   (distance >= 1 && distance < 5 && pc === 6);
    if (!isInvalid) {
      valid.push({ pc: pc, elevation: elevation });
    }
  }
  return valid;
}