(http://i.imgur.com/fzQVs.png)
(http://i.imgur.com/iD7LZ.jpg)
This suite is a dynamic Excel sheet with a variety of tools in it to help you balance your ship mods. Once you input your mod's ship_data, the graphs and tools will automatically calculate a mystical Fleetpoint Combat Score for each ship along with other useful data values available throughout the suite.
Simply input your mod's ship_data by pasting it in the mod ship data section starting at row 163 and everything is ready to go!
As you edit your ship's values, the graphs will update on the fly, allowing you to better tune your ships with vanilla ones.
The Fleetpoint Combat Score takes the following attributes into account:
fleetpts, hitpoints, armor rating, max flux, flux dissipation, ordinance, max speed, acceleration, deceleration, max turn, turn acceleration, shield upkeep, shield efficiency, cargo size, hangar size
Current Tools:
Relative Ship Comparison Tool
Spoiler
This tool allows you to compare up to four ships simultaneously by some of the game's most critical attributes.
(http://i.imgur.com/0N8Y7.jpg)
Spoiler
For every ship, the suite determines its combat effectiveness per cost of fleetpoints, called the Fleetpoint Combat Value. This is a great tool to quickly modify a ship's stats to bring its Fleetpoint Combat Value in line with a corresponding vanilla ship.
(http://i.imgur.com/o7sfB.jpg)
Spoiler
Calculates a ship's recommended value based on magic math and compares that with its current base value.
Changelog:
BalanceSuite 5000 v1.6
-Fixed shield efficiency calculation to interpret shield values correctly
-Replaced trendlines with fleetpoint lines to better communicate that you're comparing ships of similar fleetpoint value and not the mod against vanilla as a whole
-Added notes column to explain ship outliers
/////////////////////////////////
BalanceSuite 5000 v1.5
-Increased accuracy of recommended price for carriers and ships with large hangars
-Added price checker colors to recommended price special stats column to ease mass correcting of prices
/////////////////////////////////
BalanceSuite 5000 v1.4
-Agility and Cargo are now taken into account when calculating the combat value and recommended base value
-Recommended base value adjusted to be more accurate per fleetpoint
-Added Relative Balance Checker tool to compare fleetpoint-adjusted combat value side by side in the ship comparison tool
/////////////////////////////////
BalanceSuite 5000 v1.3
-Integrated Recommended Base Value into Price Checker Tool cell U85
/////////////////////////////////
BalanceSuite 5000 v1.2
-Added Recommended Base Value in Special Stats area
-Hangar bay size beyond 25 is taken into consideration when calculating the aggregate score
/////////////////////////////////
BalanceSuite 5000 v1.1
-Integrated Shield balancing, now computes in aggregate score
-Changed the Combat-Fleetpoint Performance Graph to now take fleetpoints into consideration.
Note: you may need Excel 2007+ and/or the XYChartLabler addon (http://www.appspro.com/Utilities/ChartLabeler.htm) to view graph ship labels.
In hopes that it will generate community pressure to keep mods vanilla-balanced, this seal is available to balanced mods using the BalanceSuite 5000.
FLAUNT YOUR BALANCING, SUPPORT A CAUSE:
_____________________________________________
(http://i.imgur.com/F215u.png) (http://fractalsoftworks.com/forum/index.php?topic=2382.msg31058#msg31058)
Forum code:
[url=http://fractalsoftworks.com/forum/index.php?topic=2382.msg31058#msg31058][img]http://i.imgur.com/F215u.png[/img][/url]
Download BalanceSuite 5000 v1.6
http://dl.dropbox.com/u/66999462/BalanceSUITE_v1.6.xlsx
BalanceSuite v1.1 posted
BalanceSuite v1.1
-Integrated Shield balancing, now computes in aggregate score
-Changed the Combat-Fleetpoint Performance Graph to now take fleetpoints into consideration.
I'm working on a recommended base value (price) tool, but it's a *** to work out. This thing is like 85% bad math.
BalanceSuite v1.2 posted.
BalanceSuite v1.2
-Added Recommended Price feature in Special Stats area
-Hangar bay size beyond 25 is taken into consideration when calculating the aggregate score
This is very useful, thanks for your work on this.
Thanks!
BalanceSuite v1.3 posted!
Changelog:
BalanceSuite v1.3
-Integrated Recommended Base Value into Price Checker for the Ship Comparison Tool
-Added Fleetpoint Combat Value comparison for The Ship Comparison Tool
The price recommendations should become more accurate as I account for more ship attributes, but I can only get so close if they were chosen arbitrarily and not based on a formula. It's more of a ballpark figure. Honestly, playing the game and seeing some of these makes me think that a few of the vanilla ships are in need of a price changes...like the Onslaught :o
BalanceSuite v1.4 is live!
Changelog:
BalanceSuite v1.4
-Agility and Cargo are now taken into account when calculating the combat value and recommended base value
-Recommended base value adjusted to be more accurate per fleetpoint
-Added Relative Balance Checker tool to compare fleetpoint-adjusted combat value side by side in the ship comparison tool
it seems like something simple to compare speeds and price is missing?
Both speed and price comparisons have been in since v1.0. If you're referring to the recommended price, it's easier said than done. This is currently the price recomendation formula to get it as accurate (or inaccurate) as it is:
=MROUND(IF(AND($AG100<14, $AG100>10),((($AZ100)^1.18*($AG100)^2.3/(($AG100)*2))/2.1),((IF($AG100<17,MROUND(IF($AG100>9,(($AZ100)^1.1*($AG100)^2.42/(($AG100)*2))/2.1,(($AZ100)^1.105*($AG100)^2.24/(($AG100)*1.27))/1.8),1),MROUND(IF($AG100<18,(($AZ100)^1.14*($AG100)^2.4/(($AG100)*2))/2,(($AZ100)^1.15*($AG100)^2.4/(($AG100)*2))/1),1))+IF($AA100>25,($AA100-25)^3,0))+(IF($W100>30,$W100*7,$W100*2.5)))),100)
BalanceSuite v1.5
-Increased accuracy of recommended price for carriers and ships with large hangars
-Added price checker colors to recommended price special stats column to ease mass correcting of prices
The problem is that some things (like the background of the ship, and the way the attributes work together) can't be accounted for with formulae.
Still, this gets you 95% of the way to a properly balanced mod. So thumbs up.
I completely agree, there are many factors that need to be taken into account that a tool just can't 1, 2, 3, bam, magically balance for. Ship size, weapon mounts, weapons, weapon arcs, etc. My hopes are that this tool will give modders ballpark figures to help avoid cases where modded ships are overwhelmingly OP.
Added BalanceSuite 5000 seal to the front page for mods with vanilla-balanced ships in hopes that it will generate community pressure to keep mods balanced. Flaunt your balancing, support a cause.
(http://i.imgur.com/F215u.png)
[url=http://fractalsoftworks.com/forum/index.php?topic=2382.msg31058#msg31058][img]http://i.imgur.com/F215u.png[/img][/url]
BalanceSuite 5000 v1.6
-Fixed shield efficiency calculation to interpret shield values correctly
-Replaced trendlines with fleetpoint lines to better communicate that you're comparing ships of similar fleetpoint value and not the mod against vanilla as a whole
-Added notes column to explain ship outliers