Note that you don’t have to turn the Excel macros on if you just want to look at the data. Macros are only necessary if you want to update the sheets with new data. (E.g. when pressing the buttons on the Buttons sheet.)
I found a bug and will have to start the tests all over from scratch.
This may take a while.
If anyone would like to assist, please lemme know.
Currently, the metric I am using is this:
Value1 = Time for Ship #1 to kill gimped Ship #2 Value2 = Time for Ship #2 to kill gimped Ship #1 Final rating = sqrt(Value2/Value1)
Actually, it’s 10 ships fighting 10 ships.
I like this metric since it is simple and gets the proportions right IMO.
However, what about ships like the Probe which has no attack capability? How should they be rated? More importantly, how should I rate the ships that attack them? I mean, A Battlecruiser can kill a Probe faster than a Scout. How should this fact be accounted for in the statistics?
Currently, I am ignoring them.
I just re-uploaded the spreadsheets with the bugs fixed.
There are still only half the number of spreadsheets as the final version will have.
The download link is in the first post.
The spreadsheets are completed and I am done with all four races.
Next, I am going to install the latest patch preview and do those ships as well.
I’ve examined the Patch 2.1 and Patch Preview .ship files, and it seems only these ships have been modified:
1 kus_cloakgenerator.ship 1 kus_defender.ship 1 kus_destroyer.ship 1 kus_gravwellgenerator.ship 0 kus_heavycorvette.ship 1 tai_cloakgenerator.ship 1 tai_defender.ship 1 tai_destroyer.ship 1 tai_gravwellgenerator.ship 0 tai_heavycorvette.ship 1 hgn_battlecruiser.ship 1 hgn_destroyer.ship 0 hgn_shipyard.ship 1 vgr_battlecruiser.ship 0 vgr_bomber.ship 0 vgr_carrier.ship 1 vgr_destroyer.ship 0 vgr_interceptor.ship 0 vgr_lasercorvette.ship 0 vgr_missilecorvette.ship
Further, the ones marked with 0 seem to only have cosmetic changes that don’t affect combat performance.
Am I correct, or are there other changes?
Never mind. The following .wepn files have been altered as well.
hgn_antishipbomblauncher.wepn hgn_battlecruiserturretedioncannon.wepn hgn_bigtorpedolauncher.wepn hgn_burstcannonburst.wepn hgn_clustertorpedolauncher.wepn hgn_ioncannonturret.wepn hgn_kineticautogun.wepn hgn_kineticburstcannon.wepn hgn_mshulldefensegun.wepn hgn_mshulldefensegun2.wepn hgn_mshulldefensegunside.wepn hgn_pulsar.wepn hgn_torpedolauncher.wepn hgn_vulcankineticturret.wepn hgn_vulcankineticturretlongrange.wepn hw1_bomber.wepn hw1_interceptor.wepn hw1_mothershipgun.wepn hw1_scout.wepn kus_assaultgun.wepn kus_hvcorvette1.wepn kus_hvcorvette2.wepn kus_ioncannon.wepn kus_ltcorvette.wepn kus_multigun1.wepn kus_multigun2.wepn tai_assaultgun1.wepn tai_assaultgun2.wepn tai_hvcorvette1.wepn tai_hvcorvette2.wepn tai_ioncannon.wepn tai_ltcorvette.wepn tai_multigun1.wepn tai_multigun2.wepn vgr_antishipbomblauncher.wepn vgr_bcforwardweapon.wepn vgr_concussionmissilelauncher.wepn vgr_flechettecannon.wepn vgr_flechettecannonassaultfrigatebottom.wepn vgr_flechettecannonassaultfrigateleft.wepn vgr_flechettecannonassaultfrigateright.wepn vgr_mediummissileburst.wepn vgr_vulcankineticturretlongrange.wepn
Since I don’t know which weapon belongs to which ship, I will just test all the ships again like I did the first time.
Does anyone know what the next patch version number will be?
The Patch Preview hasn’t been updated since July 5th. I’m starting to wonder if HWR support has ended. See this thread:
Yeah, I thought I scared them away because I kept asking them to add/fix new features.
Are there any charts/views anyone would be particularly interested in? Right now I have Min and Max columns, but can’t think of a good chart.
1.1.0 — 2016/08/14
• Gathered new stats based on the HWRM patch preview and put the two sets of
data in different subfolders.
• The “clc” table values are now based on the new “ExtraTime” statistics, which
include extrapolations of data beyond the default time-out value based on
current health percentages.
• The archive now includes Patch 2.1 and Patch Preview stats.
1.2.0 — 2016/08/16
• The “ExtraTime” column has been merged into “RoundTime” colummn.
• Four new “tim” sheets per workbook. These display the time in seconds it took
each ship to kill the other ships.
• The spreadsheets now also show how long it took attack capable ships to kill
non-attack capable ships. Before, these stats were omitted.
• New conditional formatting in some of the workbooks to show which values are
good and which are bad using color gradients.
1.3.0 — 2016/08/18
• All sheets now have conditional formatting applied to them.
• Added a checkbox to switch conditional formatting on and off.