TL;DR Here is a spreadsheet to help you account for mech quirks and weapon modules in your build stats. Download it and enjoy! Document Link Everyone can agree that Smurfy's is wonderful and probably the only thing that has kept some of us sane when building mechs. There is one thing that has not been implemented yet, and that is the effect of quirks, modules, and fast fire on your mech's stats. Sometimes it is very helpful to know if adding a cooldown module is actually beneficial to your goal. Other times it's hard to wrap your head around all the quirks for a mech and how they impact different weapon systems. Keep in mind, I have streamlined most of the process of making a build using this spreadsheet, but the quirks are still entirely manual entry. Once you type the name of a mech into the title section, the bottom will automatically show all of the mech's weapon quirks. You simply have to manually add those quirk percentages to their appropriate weapons and weapon types. Another note, I made this for myself for a simple go-to when creating new builds and comparing stats. It is rough, there is little optimization, and I've only made it functional for up to THREE weapon types per mech (I typically never run more than that on a mech, so I cut it off there). Feel free to download the file and change however you'd like! Re-upload to your unit's google drive and compare new builds for CW and Competitive. Do whatever! Also, if you have any questions about the formulas, notice any errors (all quirks were manually input), or have any recommendations or suggestions please don't hesitate to bring it up here. Again, this is a very rough spreadsheet I was using for personal comparisons, but I know some will find it useful.
Damn, this is great. I'll download that and test to see if I find any problem. (edit: snif, seems it works with Excel only)
Will play around with it later. Have to admit my module usage entirely depends on the role and combat style I'll use for the mech and as I prefer a pressure approach when fighting so cool down on everything is rarely good. Idealised stats rarely mean anything in game but in fairness I use certain stats to give me a comparative picture between weapon loadouts. I just have to bear in mind the variability of missiles, lasers and clan UAC's.
You should be able to download, then re-upload to your own Google Docs. Works just fine in Google Docs for me...
We can download allright, but I think the formulas are slightly different on OpenOffice, LibreOffice or whatever, so it doesn't work.
I'm using OpenOffice - if I download the Excel version everything is fine for me - for some strange reason the openoffice file doesnt work correctly.
If I'm not wrong, Li Song's Mech Lab does apply the quirks to your mech stats. This is really useful for omnimechs where different pods will give different quirk
It sure does! however it's a bit more of a FULL mechlab with constraints and the UI keeps you from doing simplistic, pure data, side-by-side comparison. I don't have control over fine tuning of values and a full view of all variables and their effects. I can simply plug a couple numbers into my spreadsheet and have everything I need without dealing with a UI, layout, loading/saving mechs, etc. Beep-Boop-Bop done. Also, this is an easy way for me capture/share such comparisons. Lastly, Li Song is an actual application that must be installed. Can't use that at work and requires others to instal it and learn how to use it. Excel (and Google Spreadsheets) are compatible on any platform. It also makes it available for use on work computers as it's simply an .xls file. I'm also working on a new sheet for a more direct comparison of only the final, out-the-door, mech stats that matter for comparison (overall max/sus DPS, Heat efficiency, Alpha, Average range, etc) all listed in a row for each build for immediate comparison of ~50 builds at once. All of the automated formulas allow me to link all these stats back to the user's initial inputs. No need to mess with equations and formulas, it's all automated. This allows me to work on things like a automated build rating system that accounts for: Alpha, Max DPS, Sustained DPS, Damage potential before overheat, heat efficiency, average range, etc. Then I can adjust the rating formula to prioritize attributes. For example: Alpha and Max DPS matters more at longer ranges. Sustained DPS matters more for close ranges where you are have less chance to cooldown. My plan is to refine this formula to allow use input to what he/she wants. Want to compare all the mechs based on their long-range capability, simply adjust where you allocate "points" into a Long-Range box. Now the formula will put much heavier weight on Longer average range, Max DPS, etc. There are still some variables that I need to include in this formula that are tough like: hardpoint location rating (are they high mounted and better for peeking? or are they low mounted and usable only by exposing your mech?) this also lead me to a survivability rating based on STD/XL engine, Hitbox sizes, overall mech size, speed, armor/structure points (will have to include more quirks here). and so on. Don't get me wrong, Li Song's mechlab is awesome. It's simply redundant for me because Smurfy's allows me to build a LEGAL mech, and this spreadsheet allows me to see all the true/meaningful stats and how they compare to other builds in just a few seconds. Here is a sneak peak at the new sheet i've been working on. As you can see, there are almost 50 mech builds with all their stats parametric to your inputs on the "mech building" sheet. As soon as you make a change to a build, this sheet updates. You can sort by any stat or create your own personal preference rating system to sort by. Complete user control albeit more advanced and detailed than most people would be interested in. At some point, none of this data matters and is made completely irrelevant due to pilot skill and RNG.
Yes I guess they both serve different purposes. I was trying to reconfigure my stormcrow with the latest nerfs and have to figure out which omipods to swap to get the most optimal quirk. That said I needed to first build legal mechs, then copy their values to your spreadsheet for comparison. Knowing that Li-Song's mechlab export to xml, it would be useful to write a google script to import mechs into your spreadsheet.
