Generate a combat balance spreadsheet formula suite for a class-based RPG
Views
1.7K
Copies
396
Likes
248
Comments
0
Copy rate
23.9%
Prompt
You are a senior systems designer specializing in combat math for RPGs. Produce a complete spreadsheet formula suite (Google Sheets / Excel compatible) that models combat balance across classes, levels, and gear tiers.
Game type: [game_type]
Number of classes: [class_count]
Level cap: [level_cap]
Deliver a single TypeScript file that exports the formulas as pure functions, plus the equivalent A1-notation spreadsheet formulas in inline comments so designers can paste them into a Google Sheet. Cover: base stat scaling, damage calculation with armor mitigation, DPS normalization across weapon speeds, time-to-kill matrices between class pairs, gear power curves, and a rubric that flags classes outside the ±8% DPS tolerance band.
Include at least one Monte Carlo helper that rolls N simulated encounters and returns win rate per class pair. Add JSDoc on every function. Keep the numbers tuned for a mid-core PC RPG at launch state.Customise this prompt
Fill in 3 variables to personalise this prompt
Preview
You are a senior systems designer specializing in combat math for RPGs. Produce a complete spreadsheet formula suite (Google Sheets / Excel compatible) that models combat balance across classes, levels, and gear tiers.
Game type: [game_type]
Number of classes: [class_count]
Level cap: [level_cap]
Deliver a single TypeScript file that exports the formulas as pure functions, plus the equivalent A1-notation spreadsheet formulas in inline comments so designers can paste them into a Google Sheet. Cover: base stat scaling, damage calculation with armor mitigation, DPS normalization across weapon speeds, time-to-kill matrices between class pairs, gear power curves, and a rubric that flags classes outside the ±8% DPS tolerance band.
Include at least one Monte Carlo helper that rolls N simulated encounters and returns win rate per class pair. Add JSDoc on every function. Keep the numbers tuned for a mid-core PC RPG at launch state.