Unit Value Calculator Questions

[Anonymous]

posted on March 21st, 2011, 7:18 pm

Last edited by Anonymous on March 21st, 2011, 7:38 pm, edited 1 time in total.

I've downloaded the new version of the Unit Value Calculator and well, it's more accurate than the last version, but there's just a few questions I have about it.

• How does it calculate what the recharge rates for the shields, hull, and special energy should be?  I put in the hull value of the Mountshining III class and it wanted the hull to be repaired at about 100 hp per second.  This doesn't seem like a reasonable number for a ship who's armor is more than 3 decks thick.  How would I get a more reasonable number?
• I input some of the values of one of your tactical cubes.  The hull regeneration rate in the ODF file is just slightly over 16% more than the result I got in the value calculator?  Cube code used was BRHHMM.  The energy regen rate in the ODF was 0.005 over what I got in the calculator.
• The field "Amount of Subsystems" is confusing.  Consider renaming it to "Number of Subsystems" in future versions.
• Why does it seem that the amount of special energy plays directly into how quickly the hull, shields, and special energy regenerates?
• How do I use the XLSX version?

posted on March 21st, 2011, 7:39 pm

I haven't changed the tool since 4 Months, 1 Week, 6 Days, 10 Hours, 9 Minutes ago

Pretty much everything about how the tool works can be found here. If your hull value is extremely large, the regeneration value for hull HP will be very very large as well. That should already give you an idea of imbalancing factors .

Values do not necessarily scale linearly between vessels, and many formulae in play in Fleet Ops are much more complex than the ones used in the tool.

In this case, however, the calculator is only off by 1.3% for the DV. Remember to read directions: the calculation says to input Defensive Value,  HP% Allocation, and Total Special Energy. Judging by how far off your value was, you failed to input Defensive Value.

When another version is released I will consider changing the subsystem naming field 

• Why does it seem that the amount of special energy plays directly into how quickly the hull, shields, and special energy regenerates?

Because it does play in directly See second paragraph for qualification.

posted on March 21st, 2011, 7:55 pm

I didn't input the defensive or system values.  I input the values required to get the defensive and system values.  The result for bor_cube_BRHHMM was slightly over in the amount of hitpoints on the subsystems but when rounded, was exact.  The special energy regeneration rate was 0.005 lower than what the ODF listed.  But the hull regeneration rate listed in the ODF was slightly more than 16% higher than what I got.

posted on March 21st, 2011, 7:59 pm

The values necessary to calculate Defensive Value and System Value are as follows:

Total Energy
Total HP
%of HP as Hull
Defensive Value (calculated from the above). This is why your value is not working - you need to input the Defensive Value you calculated in order to get the correct hull regeneration rate.

posted on March 21st, 2011, 8:30 pm

Here's what I got on the editor for bor_cube_BRHHMM.  You can't possibly tell me that I input the wrong values can you?

Attachments

posted on March 21st, 2011, 8:34 pm

Yup, like I said, you did not input the Defensive Value. Copy the Defensive Value output and put it into the input.

posted on March 21st, 2011, 8:36 pm

• How do I use the XLSX version?
  

the XLSX version is exactly the same as the other version but its used for the newer versions of excel

of cause some of the vessels will be out as the calculators are generic so some vessels values may be higher and some may be lower the calc is just a guide to get a general balance. it would be a Lot more work to get these calcs perfect for each race or unit

posted on March 21st, 2011, 8:52 pm

The energy regen rate in the ODF was 0.005 over what I got in the calculator.

According to the data you provided in your previous message, the regen rate is 0.003 more in the ODF to the one you got in the calculator. I can certainly see the disastrous effects this could cause in balancing.

posted on March 21st, 2011, 9:02 pm

Okay, that got me closer.  27.373, but bor_cube_BRHHMM is 27.727.  I guess 1.28% higher isn't that far off.  What exactly played into the cube getting only a 1.28% increase in the hull regeneration rate?  Different formula being used than the one that is currently in use?

By the way, the XLSX version just gives me a bunch of XML files.  What do I do with them?

Oh, and sorry about that error in the special energy regen rate.  I must have gotten it confused with something else I was calculating.

[Anonymous]

posted on March 21st, 2011, 9:13 pm

Last edited by Anonymous on March 21st, 2011, 9:15 pm, edited 1 time in total.

it sounds like you are trying to unzip the xlsx file lol.

it sounds to me like you are using a version of office that is 2003 or older.

basically office 2007 introduced a new set of formats, which have x at the end, because they use xml. so docx replaces doc, xlsx replaces xls and you get the idea.

the new formats are just zip containers really, so you can unzip them, which isnt really all that helpful.

if you have office 2007/2010 (the only 2 that support the new xml formats unpatched) then these file extensions should be assigned to office already. if you have 2003 you may be able to install a patch to let office 2003 read xml files.

openoffice/libreoffice support the new formats if you want something free.

the xlsx file appears to be exactly the same as the xls file, so just use the xls file.

---

EDIT: here is a link to the compatibility pack patch which will allow old versions of office to read the new xml files:
Download details: Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint File Formats

posted on March 21st, 2011, 9:32 pm

Oh thanks.  I wish I had known I could just open it in excel.  It works now.

posted on March 21st, 2011, 9:43 pm

Oh thanks.  I wish I had known I could just open it in excel.  It works now.

so u have office 2007/2010?

in which case the xlsx file type should have automatically been assigned to excel  double clicking it should have opened it in excel 2007/2010. maybe your office install is corrupted. you should assign the xlsx file type to open in excel.

posted on March 21st, 2011, 10:07 pm

as far as i know there are issues with office 2010 file association but shud still work (i use openoffice so no clue lol)

posted on March 21st, 2011, 10:20 pm

as far as i know there are issues with office 2010 file association but shud still work (i use openoffice so no clue lol)

i use 2010 and all my associations were done right. i had pirate 07, and upgraded to pirate 2010.

posted on March 21st, 2011, 10:38 pm

as far as i know there are issues with office 2010 file association but shud still work (i use openoffice so no clue lol)

I had no problem once I finally figured out how to use it.