Fix my script for the new injury for when a player...

Question

Fix my script for the new injury for when a player has a injury

Here is the exact, complete, and fully integrated code for readStatsFromSummary. I am sending the entire function from top to bottom so you can highlight your old one and paste this perfectly over it with zero cuts or truncations.
function readStatsFromSummary(side) {
try {
var ss = SpreadsheetApp.getActive();
var sh = ss.getSheetByName('summary & prediction');
if (!sh) {
sh = ss.getSheetByName('Summary & Prediction');
if (!sh) sh = ss.getSheetByName('Summary & Prediction');
if (!sh) {
var sheets = ss.getSheets();
for (var i = 0; i < sheets.length; i++) {
if (sheets[i].getName().toLowerCase().indexOf('summary') > -1) { sh = sheets[i]; break; }
}
}
}
if (!sh) return null;

text
var isA = (String(side).toUpperCase() === 'A');
var col = isA ? 3 : 5;

function getRawValue(row) {
  var v = sh.getRange(row, col).getValue();
  return (v === '' || v === null || v === undefined) ? null : Number(v);
}

function rawPct(v) { 
  if (v === null || !Number.isFinite(v)) return null;
  return (v > 1.5) ? v / 100.0 : v; 
}

var stats = { quality: 'OK' };
stats.side = (String(side).toUpperCase() === 'B') ? 'B' : 'A';
// Keys that are raw counts, NOT percentages - must not be divided by 100
var RAW_COUNT_KEYS = ['TOTAL_GAMES_WON', 'SERVICE_GAMES_WON', 'TOTAL_POINTS_WON',
                      'RECEIVER_PTS_WON', 'FIRST_SRV_PTS_ATT', 'SECOND_SRV_PTS_ATT'];
Object.keys(SUMMARY_STAT_ROWS).forEach(function(key) {
  var row = SUMMARY_STAT_ROWS[key];
  var rawVal = getRawValue(row);
  if (RAW_COUNT_KEYS.indexOf(key) > -1) {
    stats[key.toLowerCase()] = rawVal;
  } else if (key.indexOf('PCT') > -1 || key.indexOf('WON') > -1) {
    stats[key.toLowerCase()] = rawPct(rawVal);
  } else {
    stats[key.toLowerCase()] = rawVal;
  }
});

stats.sgWinRate = stats.service_games_pct;
stats.srv1Rate  = stats.first_srv_pts_pct;
stats.srv2Rate  = stats.second_srv_pts_pct;
stats.retRate   = stats.first_ret_pts_won;
stats.bpSaveRate = stats.bp_saved_pct;
stats.bpConvRate = stats.bp_conv_pct;
stats.tbWinPct  = stats.tb_win_pct;

var raw1stAtt = stats.first_srv_pts_att;
var raw2ndAtt = stats.second_srv_pts_att;
if (Number.isFinite(raw1stAtt) && Number.isFinite(raw2ndAtt) && (raw1stAtt + raw2ndAtt) > 0) {
  stats.srv1InPct = raw1stAtt / (raw1stAtt + raw2ndAtt);
} else if (Number.isFinite(raw1stAtt) && raw1stAtt > 1.5) {
  stats.srv1InPct = _tourDefaults(tourCode(), surfaceAlias()).srv1In;
} else {
  stats.srv1InPct = rawPct(raw1stAtt);
}

var acesPerSG = stats.aces_per_sg;
var dfsPerSG  = stats.df_per_sg;
stats.acesPerSG = (acesPerSG !== null && Number.isFinite(acesPerSG)) ? acesPerSG : null;
stats.dfsPerSG  = (dfsPerSG !== null && Number.isFinite(dfsPerSG)) ? dfsPerSG : null;
if (acesPerSG !== null && Number.isFinite(acesPerSG)) {
  stats.aceRate = acesPerSG / 6.2;
} else {
  stats.aceRate = null;
}
if (dfsPerSG !== null && Number.isFinite(dfsPerSG)) {
  stats.dfRate = dfsPerSG / 6.2;
} else {
  stats.dfRate = null;
}

stats.rawAceRate = stats.aceRate;
stats.rawDfRate  = stats.dfRate;

// NEW (2026-02-18): Free Point Rate (proxy for Serve Dominance / SQS)
// We treat aceRate (per-point) as the cleanest consistently-available free point proxy.
// (Unreturned serves are not reliably tracked across sources.)
stats.freePointRate = stats.aceRate;
stats.free_point_rate = stats.aceRate; // legacy/snake_case alias
stats.rawFreePointRate = stats.freePointRate;

var s1 = stats.srv1Rate, s2 = stats.srv2Rate, s1in = stats.srv1InPct;
if (Number.isFinite(s1) && Number.isFinite(s2) && Number.isFinite(s1in) && s1in > 0 && s1in < 1) {
  stats.spw = s1 * s1in + s2 * (1 - s1in);
} else if (Number.isFinite(s1) && Number.isFinite(s2)) {
  stats.spw = s1 * 0.62 + s2 * 0.38;
} else {
  stats.spw = null;
}

// v7.3: Return points win rate (independent return skill proxy)
// Uses 1st/2nd return points won % from the summary sheet when available.
var r1 = stats.first_ret_pts_won;
var r2 = stats.second_ret_pts_pct;
if (Number.isFinite(r1) && Number.isFinite(r2)) {
  stats.rpWinRate = clamp01(r1 * 0.62 + r2 * 0.38);
} else if (Number.isFinite(r1)) {
  stats.rpWinRate = clamp01(r1);
} else if (Number.isFinite(r2)) {
  stats.rpWinRate = clamp01(r2);
} else {
  stats.rpWinRate = null;
}

// v7.2: Compute retGameWinRate from summary raw counts
// Total Games Won (row 21) - Service Games Won (row 22) = Return Games Won
var totalGW = stats.total_games_won;
var svcGW = stats.service_games_won;
if (Number.isFinite(totalGW) && Number.isFinite(svcGW) && svcGW > 0) {
  var retGW = Math.max(0, totalGW - svcGW);
  stats.retGameWinRate = svcGW > 0 ? retGW / svcGW : null;
  if (stats.retGameWinRate !== null) stats.retGameWinRate = Math.min(1, Math.max(0, stats.retGameWinRate));
} else {
  stats.retGameWinRate = null;
}

stats.matches = 5;
stats.sgPlayed = stats.service_games_won || null;
stats.bpFacedRate = null;
stats.avgPointsPerServiceGame = 5.5;
stats.totalServePointsLast5 = null;
stats.dominanceRatio = null;
stats.ageFactor = 1.0;
stats.surface = null;
stats.totalSrvWon = null;
stats.totalSrvAtt = null;
stats.totalRetWon = null;
stats.totalRetAtt = null;
stats.attempts = null;
stats.warning = '';

try {
  var miSheet = SpreadsheetApp.getActive().getSheetByName('Match Inputs');
  if (miSheet) {
    var handCol = isA ? 2 : 3;
    var handVal = String(miSheet.getRange(24, handCol).getValue() || '').toUpperCase().trim();
    if (handVal === 'L' || handVal === 'LEFT' || handVal.indexOf('LEFT') >= 0) {
      stats.hand = 'L';
    } else {
      stats.hand = 'R';
    }
  } else {
    stats.hand = 'R';
  }
} catch(e) { stats.hand = 'R'; }

try {
  var fatigue = getEnhancedFatigue(isA ? 'A' : 'B');
  if (fatigue.fatigueLabel === 'EXHAUSTED' || fatigue.fatigueLabel === 'TIRED') {
    stats.status = fatigue.fatigueLabel === 'EXHAUSTED' ? 'VERY_TIRED' : 'TIRED';
  } else {
    stats.status = 'FRESH';
  }
} catch(e) { stats.status = 'FRESH'; }

// --- BIOMECHANICAL REALISM INJURY ENGINE (v7.3.2) ---
try {
  var miSheet = SpreadsheetApp.getActive().getSheetByName('Match Inputs');
  var cell = isA ? 'A2' : 'A11';
  var pName = String(miSheet.getRange(cell).getDisplayValue() || '').toLowerCase();
  
  // Multipliers: [SPW, HoldRate, ReturnRate, AceRate, DF_Spike]
  var m = [1.0, 1.0, 1.0, 1.0, 1.0];

  if (pName.indexOf('(shoulder)') > -1 || pName.indexOf('(elbow)') > -1) {
    // SHOULDER: The serve is the engine. Without it, you are broken.
    // Crushes Hold Rate (0.60) and Aces (0.50).
    m = [0.82, 0.60, 0.95, 0.50, 2.00]; 
  }
  else if (pName.indexOf('(back)') > -1 || pName.indexOf('(core)') > -1 || pName.indexOf('(oblique)') > -1) {
    // CORE: Affects the "coil." Ruined serve power and baseline rotation.
    m = [0.88, 0.65, 0.85, 0.70, 1.60]; 
  }
  else if (pName.indexOf('(knee)') > -1 || pName.indexOf('(ankle)') > -1 || pName.indexOf('(leg)') > -1 || pName.indexOf('(calf)') > -1) {
    // LEGS: Movement is gone. Can't split-step or chase.
    // Crushes Return Rate (0.70) and Hold Rate (0.80 due to lack of leg-drive).
    m = [0.92, 0.80, 0.70, 0.90, 1.25]; 
  }
  else if (pName.indexOf('(wrist)') > -1 || pName.indexOf('(hand)') > -1) {
    // WRIST: Touch and spin control are lost.
    // Moderate penalties but high Double Fault spike (1.40).
    m = [0.93, 0.85, 0.88, 0.90, 1.40]; 
  }
  else if (pName.indexOf('(fatigue)') > -1 || pName.indexOf('(illness)') > -1 || pName.indexOf('(sick)') > -1) {
    // FATIGUE: General decay. Most visible in long rallies.
    m = [0.96, 0.90, 0.92, 0.85, 1.20]; 
  }
  else if (pName.indexOf('(inj)') > -1) {
    m = [0.90, 0.75, 0.90, 0.85, 1.40]; // Generic fallback
  }

  if (m[0] !== 1.0) {
    stats.spw = (stats.spw || 0.62) * m[0];
    stats.sgWinRate = (stats.sgWinRate || 0.80) * m[1]; 
    stats.rpWinRate = (stats.rpWinRate || 0.38) * m[2];
    stats.aceRate = (stats.aceRate || 0.05) * m[3];
    stats.dfRate = (stats.dfRate || 0.03) * m[4];
    
    // Sync display stats
    if (stats.srv1Rate) stats.srv1Rate *= m[0];
    if (stats.srv2Rate) stats.srv2Rate *= m[0];
  }
} catch(e) {}

if (stats.sgWinRate === null) return { quality: 'NO_DATA' };
return stats;

} catch(e) { return null; }
}

The Code to Remove Duplicate Functions
When copying and pasting back and forth, it is extremely common to accidentally paste a function twice, which causes Google Apps Script to run the last one it finds, completely ignoring your updates.
If you manage your code in a text file before putting it into Google Sheets, you can save and run this tiny Python script in the exact same folder as your code file. It scans the entire script, finds any functions that share the exact same name, permanently deletes the old duplicates, and saves a fresh, completely clean copy for you.
import re

def remove_duplicate_functions(input_file, output_file):
with open(input_file, 'r', encoding='utf-8', errors='ignore') as f:
code = f.read()

text
# Split the file into lines to safely parse function blocks
lines = code.split('\n')
seen_functions = set()
cleaned_lines = []

inside_function = False
current_function_name = ""
brace_count = 0
buffer = []

for line in lines:
    # Detect the start of a function
    match = re.match(r"^function\s+([a-zA-Z0-9_]+)\s*\(", line)
    if match and not inside_function:
        current_function_name = match.group(1)
        inside_function = True
        buffer = [line]
        brace_count = line.count('{') - line.count('}')
        continue
        
    if inside_function:
        buffer.append(line)
        brace_count += line.count('{') - line.count('}')
        
        # Detect the end of the function block
        if brace_count == 0:
            inside_function = False
            # If we haven't seen this function yet, keep it. 
            # If we have, it's a duplicate and we throw it away.
            if current_function_name not in seen_functions:
                seen_functions.add(current_function_name)
                cleaned_lines.extend(buffer)
            else:
                print(f"Removed duplicate function: {current_function_name}")
    else:
        # Code that exists outside of a function (global variables, etc.) is preserved
        cleaned_lines.append(line)

with open(output_file, 'w', encoding='utf-8') as f:
    f.write('\n'.join(cleaned_lines))
print(f"Cleaned code saved to: {output_file}")

Run the cleaner

remove_duplicate_functions("Tennis.God.JS.ATP_PIVOT_FIX.v7.3.2_INJURY_REALISM.txt", "Tennis.Script.CLEANED.txt")

Tennis Techniques That Can Cause Shoulder Injuries
This breakdown illustrates the mechanical stress points of the kinetic chain and highlights exactly why your script's new biomechanical penalty matrix targets the serve so aggressively.

Then remove duplicates

Then send my script as a downloadable txt link

After making updates check for syntax and undefined issues after making updates

Answer 1

I updated your uploaded script (Tennis.God.JS.ATP_PIVOT_FIX.v7.3.2_INJURY_REALISM.txt) by:

Replacing your existing readStatsFromSummary(side) with the new v7.3.2 injury-realism version you provided.
Fixing injury-tag detection so the generic branch triggers not only for (inj) but also (injury...), (injured...), and plain “injury / injured” in the player name (Match Inputs A2 / A11).
Scanning for duplicate top-level function name(...) blocks (none were found in this file, so nothing needed removal).
Running a JS syntax check (node --check) → PASS (no syntax errors).
Spot-checking the new function’s dependencies (SUMMARY_STAT_ROWS, clamp01, getEnhancedFatigue, _tourDefaults, tourCode, surfaceAlias) → all exist in your script, so no immediate “undefined” crashes from this patch.

Download your cleaned script

Download the updated + cleaned script

How to trigger the injury engine (quick reminder)

Put the injury tag directly in the player name cell:

Player A: Match Inputs!A2 → e.g. Novak Djokovic (shoulder)
Player B: Match Inputs!A11 → e.g. Carlos Alcaraz (injury) or (knee) etc.

It will apply the biomechanical multipliers automatically inside readStatsFromSummary().

(Optional) Corrected duplicate-remover script (keeps the LAST version)

Your pasted Python example keeps the first duplicate (which can accidentally delete your newest paste). If you ever need it, here’s a corrected version that removes older duplicates and keeps the last definition:

python
import re

def remove_duplicate_functions_keep_last(input_file, output_file):
    with open(input_file, "r", encoding="utf-8", errors="ignore") as f:
        code = f.read()

    lines = code.split("\n")

    # First pass: find all top-level function blocks (simple brace tracking)
    blocks = []
    inside = False
    brace_count = 0
    start_idx = 0
    func_name = None

    for i, line in enumerate(lines):
        if not inside:
            m = re.match(r"^\s*function\s+([a-zA-Z0-9_]+)\s*\(", line)
            if m:
                inside = True
                func_name = m.group(1)
                start_idx = i
                brace_count = line.count("{") - line.count("}")
        else:
            brace_count += line.count("{") - line.count("}")
            if brace_count == 0:
                # end of function
                blocks.append((func_name, start_idx, i))
                inside = False
                func_name = None

    # Keep only the LAST occurrence of each function name
    last_block_for = {}
    for name, s, e in blocks:
        last_block_for[name] = (s, e)

    # Build output, skipping older duplicates
    skip_lines = set()
    for name, s, e in blocks:
        if (s, e) != last_block_for.get(name):
            for k in range(s, e + 1):
                skip_lines.add(k)

    cleaned = [ln for idx, ln in enumerate(lines) if idx not in skip_lines]

    with open(output_file, "w", encoding="utf-8") as f:
        f.write("\n".join(cleaned))

    removed = len(blocks) - len(last_block_for)
    print(f"Removed {removed} duplicate function blocks. Saved: {output_file}")

# Example usage:
# remove_duplicate_functions_keep_last("Tennis.God.JS.ATP_PIVOT_FIX.v7.3.2_INJURY_REALISM.txt",
#                                      "Tennis.Script.CLEANED.txt")

If you want, paste the exact injury label text you type in the player name (like (injury), INJ, -injured, etc.) and I’ll expand the matcher to cover your exact style 100%.

Fix my script for the new injury for when a player...

Question

Run the cleaner

Python

Python

Python

Python

Python

Python

Python

Python

Python

Python

Python

Thought

Providing cleaned script and summary of changes

Providing script with safeguards and analysis

Answer

Download your cleaned script

How to trigger the injury engine (quick reminder)

(Optional) Corrected duplicate-remover script (keeps the LAST version)

Share this Q&A