Install Steam
login
|
language
简体中文 (Simplified Chinese)
繁體中文 (Traditional Chinese)
日本語 (Japanese)
한국어 (Korean)
ไทย (Thai)
Български (Bulgarian)
Čeština (Czech)
Dansk (Danish)
Deutsch (German)
Español - España (Spanish - Spain)
Español - Latinoamérica (Spanish - Latin America)
Ελληνικά (Greek)
Français (French)
Italiano (Italian)
Bahasa Indonesia (Indonesian)
Magyar (Hungarian)
Nederlands (Dutch)
Norsk (Norwegian)
Polski (Polish)
Português (Portuguese - Portugal)
Português - Brasil (Portuguese - Brazil)
Română (Romanian)
Русский (Russian)
Suomi (Finnish)
Svenska (Swedish)
Türkçe (Turkish)
Tiếng Việt (Vietnamese)
Українська (Ukrainian)
Report a translation problem
This will replace all the tabs in the document with nothing (essentially deleting all the tabs in the entire document). Save the txt then import into Excel. This will prevent the issues outlined below, with odd quotes and alignment issues.
Excel apparently doesn't ignore tab use inside of documents. Hopefully this helps. I'll eventually update the guide to include this information and step.
I'll write up a detailed document on how this works and how to determine those variables.
I can use that to calculate any new ship price based on it's stats.
As for getting the stats, I take the average stat, ie average frigate shield, then multiply by -0.15/0.15 to get a range to use for new ships of that class. 15% plus/minus of the average of that class of ship.
That was merely my method, which mostly works, and then make small changes after that, basically fine tune after the auto generation is done. It will help get a solid starting point.
With that, I would see what it looks like first. Otherwise, I can share my process on how I created my own version, that way you can adapt it into whatever format/code that works best for you.
I can give you my formulas, instead of an Excel document. I basically created a formula for each ship class. So you just pick the class and the formula does the rest.
I tried to write my own, but it's just not really fitting to all the scenarios, still working on it, trying to incorporate more factors in to the price calculation, but if you'd have anything that fits to the system it would be great.
Here's my calculation sheet: https://jsbin.com/zabijik/edit?js,output
(I'm not familiar with excel, so it's a very simple js)