[GUIDE] HWRM Ship vs. Ship Stats v1.3.0


#1

Download:

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.)


#2

I found a bug and will have to start the tests all over from scratch. :frowning:

This may take a while. :frowning:

If anyone would like to assist, please lemme know.


#3

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.


#4

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.


#5

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.


#6

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?

[edit]

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.


#7

Does anyone know what the next patch version number will be?


(Cloaked) #8

The Patch Preview hasn’t been updated since July 5th. I’m starting to wonder if HWR support has ended. See this thread:


#9

Yeah, I thought I scared them away because I kept asking them to add/fix new features. :anguished:


#10

Almost done.

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.


#11

Update.

CHANGE LOG

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.


#12

Update.

CHANGE LOG

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.


#13

Update.

CHANGE LOG

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.