Hello Spreadsheet Warriors! It's that time again. I have been tinkering and altering my spreadsheet template for a few months now and it's finally in a good state to share again! If you like numbers and enjoy comparing mech builds in great detail, this spreadsheet will be a quick tool for you to get ALL of the information you could possibly need. *So what is it exactly?* The BuildStats spreadsheet is a place to enter build data to display all of its stats: DPS, Sustained DPS, Heat Efficiency, and much more. You can input a mech's quirks or modules to see how these stats react. You can compare builds at an extremely detailed level. *Why use the BuildStats spreadsheet when we have LiSong's and Smurfy's?* While both of these are powerful tools, I like to have 100% control over the data and see how tweaking little things will compare. This spreadsheet allows you to factor quirks, modules, skills, ghost heat, and more on the fly and directly compare to any number of builds. Stats, side-by-side, so you can rationalize the differences and make educated decisions. *So what's new?* Updated quirks. Clan quirks do not automatically update based on the Variant you choose. PGI has made omnimechs a nightmare to track quirks, so you'll have to refer to the clan quirks tab or directly from smurfys, LiSong, or in-game to know what your clan quirks are exactly. Sorry! Added functional weapon graphs for Alpha, DPS, and Duration Damage at range. Added a Lead Distance tab so you can see how much lead is required to hit your target based on velocity, movement speed, and distance. You can also compare two weapons, such as Guass+PPC or AC5+PPC. Added a row for Ghost Heat that will indicate how much addition heat you will generate. You also have the choice to factor it in or not. Added stats for Damage per Heat and Damage per 0.25s burn time. Added quirk functionality for Heat Dissipation quirks. Added two Build Database tabs. They are a combination of personal builds and builds taken from [MetaMechs.com](http://metamechs.com/) Added a "Percentage Fired" variable that allows you to low the rate of fire for each weapon. This could give you more visibility of a mech's sustainable DPS for when it is heat-capped. And that's about it! I would recommend using the Excel version if you are able. Excel version has a macro button for clearing input data back to a "clean slate" as well as operating faster in-general. You can download the Excel version via this link: Excel Version You can access the Google Spreadsheet version via this link: Google Spreadsheets Version As always, I appreciate any feedback or recommendations and I will attempt to answer any questions you might have. I did not specifically create this spreadsheet to be a community tool and you can edit it in whatever way you'd like for your own needs! Happy mech building! -Sola Some picture of what it looks like: Mech Build Stats http://i.imgur.com/AWLMqUt.jpg Weapon Graphs http://i.imgur.com/0Sne06Q.jpg Lead Distance Calculation http://i.imgur.com/YNGYaDG.jpg Easy Stat Comparison http://i.imgur.com/a973nKQ.jpg
So...i just spent the last 3 hours playing with your sheet and all i can say is wow!!! This is going to be a staple for me now to compare builds across mech platforms and see how they compare. I'd 5 star this thread if i could.
Exactly. You can't actually *BUILD* the mech with the spreadsheet (yet ) but you can at least use it to make direct comparisons and see ALL of the stats of a build if you input all the right data. IMO it's more about understanding the difference between builds and minor changes rather than which build is the 'best'. In-game experience, skill, preference, map, hard-point placement, hitboxes, etc all have just as much importance in the end.
Loving this tool! It may be interesting to have a 'full alpha to overheat' calculator that rounds to integers. If you take the longest cooldown of the combined weapons for alpha, you have an alpha instance with cooldown time T and heat value H. The graph to solve for n is Code: n*H-[Dissipation Rate]*((n-1)*T)<[Heat Capacity] . The highest value n for which this is true, will not overheat you as long as you only do full alphas. This can then be rounded down to an integer with cell formatting I think.
Good idea, that would be more relevant than assuming everything is firing at max DPS. In reality you will be combining shots into an alpha regardless of individual weapon cooldown. I'll think about incorporating it into the latest version and give it a test run before the next update. On another note, I have created a new version for use with the Energy Draw system which is working fairly well. Mostly just to test things on the PTS. However I should be very helpful in the future if the Energy Draw system ever goes live.
