5 replies to this topic

[MustrumRidcully]

I created a Mech Loadout Heat Efficiency Calculator via Excel and uploaded it as Google Docs Spreadsheet. You can acquire it with this link: https://docs.google....c1NDM0xuS05zM0E

You cannot edit it online, you must download it as Excel or Open Document Sheet and open on your computer with the appopriate software. At least the conversion from and to Excel and Google Doc worked so far for me.

Here's a screenshot of the relevant part:




At the top, you can first select the "rules" on how heat sinks operate - The values are preset to how things work right now, but you can adapt (let's just hope they are not making things even more complicated!)

In the next table, you can select how many single or double heat sinks you have. (Don't mix them, the sheet isn't prepared to handle that - you'll get unrealistic figures since the heat capacity will likely be added twice)

Then, in the first colored table, you can choose the weapons you wish to equip on a mech. You can also select on the most right column whether the weapon is actually to fire or not - this allows you to test different firing configurations.

And finally, at the bottom, you can see the results - how much DPS your current build theoretically generates, the amount of heat it generates per second, and how much heat it gains after substracting your heat dissipation, and finally, how long you can fire at the listed DPS before your mech will overheat.

Below that, it calculates the damage you can deliver until the shutdown, and to compare the damage you can deliver after 10 or 20 seconds of continuous firing.

This should give you somewhat of a hint on how "hot" your mech runs. My advice would be to try to find a build that doesn't overheat in the 10-20 second range, and then try to to optimize your damage output.


For now, the range listings and the recycle time are unused - I may use them later to give you damage estimates by range. For now, you may want to use them to decide what weapon groupings are to be used.


Not shown on this table is the table for the individual weapons. THis is pretty much the same data you may find in Ohmwrecker's charts. If weapon stats change, you can manually edit things. ANd for the theorycrafters out there, you can also use this to see how theoretical changes would affect a mech loadout.

Edited by MustrumRidcully, 20 November 2012 - 04:09 AM.

[MustrumRidcully]

Huh... Since I've seen this now: http://mwomercs.com/...3-updated-1119/

I might be able to understand why no one cares for this one.

[Calmon]

Just as a note: we're unable to change any value in your spreadsheet so its not really useable

[MustrumRidcully]

Calmon, on 20 November 2012 - 03:46 AM, said:

Just as a note: we're unable to change any value in your spreadsheet so its not really useable

Yes, you need to download it as excel or open document. If I open it up for editing on Google Docs, different users would conflict, as far as I know. But I tested the download functions and it worked.

Edited by MustrumRidcully, 20 November 2012 - 04:09 AM.

[Asatruer]

I copied to to my Google Docs and that looks like it works, at first I thought it was broken because selecting a different weapon did not update all of the stats, but then I realized I need to set it "Fire Weapon" to true to get those stats to update. The other spreadsheet tool you linked I have not been able to get to work with Google Docs at all yet, so cannot compare which is better other than the obvious, I can get your's to work.

[MustrumRidcully]

Asatruer, on 20 November 2012 - 05:02 PM, said:

I copied to to my Google Docs and that looks like it works, at first I thought it was broken because selecting a different weapon did not update all of the stats, but then I realized I need to set it "Fire Weapon" to true to get those stats to update. The other spreadsheet tool you linked I have not been able to get to work with Google Docs at all yet, so cannot compare which is better other than the obvious, I can get your's to work.

I believe the other tool is a bit more complex and may use some more "proprietiary" elements of Excel that Google Docs doesn't (yet) support. But it definitely can do more than my tool can. You can actually build your mech completely in 3dworld's version.

Though I believe mine is easier to tinker with. You have all the formulaes in there, and the weapons table is also right there. If you want an excel-based mech build program, mine won't give you that. If you just want to tweak weapon loadouts... Mine will do.

Edited by MustrumRidcully, 21 November 2012 - 02:12 AM.