It's getting better so far, though I think the sustained DPS result is a bit complicated since it is a combination of firing weapons at certain intervals and delays in order to reach the ideal number (such as firing 1 ER PPC 9 times then 2 ER PPCs on the 10th shot in order to achieve heat neutrality. I am not sure if this can be better represented by some other means.
Can you perhaps mark each weapon with a DPS : Heat Efficiency rating? Once flagged, it might be possible to list down which weapons can be used to fill out the Heat Per Second maximum of the mech by listing down weapons by DPS : Heat Efficiency rating (from highest to lowest heat first) and eliminating options to lower HPS weapons to fill out the rest. I haven't done any hard math on it yet though, but it might be possible to do it this way and list down which weapons can be used to achieve ideal sustained DPS.
Also I think the numbers should adjust for the efficiencies and perhaps add a checkbox to add/remove efficiency effects. I'm more interested in seeing DPS differences when Basic 1x and Basic 2x are applied.
Edit:
To better explain what I mean, I'll post an image of my edited version of Ohmwrecker's sheet where I've added values that I use to build mechs.
You can see that the two values DPS / HPS and HPS are the ones I am referring two when calculating what weapons are determined for sustained DPS.
Now just as an example we have this
Atlas K
It has a Gauss Rifle, 2x Large Laser, Medium Laser, and Small Laser and cooling is 3.40 heat per second.
Gauss Rifle - 15 DPS/HPS, 0.25 HPS
Large Laser - 0.98 DPS/HPS, 2.15 HPS
Medium Laser - 0.94 DPS/HPS, 1.33 HPS
Small Laser - 1.13 DPS/HPS, 0.89 HPS
So the main priority for heat efficient weapons would be DPS/HPS and HPS is the value that is checked if it fits within the HPS dissipation of the mech. If it does not fit, it is discarded and then the next most heat efficient weapon available is tried out in the forumla (which in this case would be the Large Laser).
HPS Dissipation - 3.40
Pass #1 - Gauss Rifle (highest tier) 0.25 / 3.40 (accepted), Total Sustained DPS: 3.75
Pass #2 - Small Laser (second highest tier) 1.14 / 3.40 (accepted), Total Sustained DPS: 4.75
Pass #3 - Large Laser (third highest tier) 3.29 / 3.40 (accepted), Total Sustained DPS: 6.87
Pass #4 - Large Laser (third highest tier) 5.44 / 3.40 (rejected), Total Sustained DPS: 6.87
Pass #5 - Medium Laser (fourth highest tier) 4.62 / 3.40 (rejected), Total Sustained DPS: 6.87
So it will list down:
Total Sustained DPS: 6.87
Weapons for Sustained DPS:
- Gauss Rifle
- Small Laser
- Large Laser
I don't know if my logic there is correct or efficient, but that was the method I was thinking of to determine which weapons to list down for sustained DPS. This way, players will know that they can always fire these three weapons without ever overheating.
A later modification can be to add the map temperature values since these will affect HPS disspiation?
Edit #2:
I am also wondering why the Small Laser is listed as 1.00 DPS. Shouldn't it be 1.33? Come to think of it I should probably adjust the formula on this excel sheet. Anyway, despite the numbers, you get the idea.
( I think the cooldown times on my sheet are outdated)
Edited by Elizander, 02 March 2013 - 10:08 PM.