STO Fleet Cost and Value V2.1
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEF
1
Star Trek Online Fleet Cost and Value Calculator
2
by @daBelgrave
3
4
The latest available version (V2.1) comes from:
5
http://bit.ly/STOFleetValue
6
7
8
Introduction
9
Using the Fleet Advancement System is a costly and time-consuming endeavor. This spreadsheet should help you figure out the costs you can expect as your fleet grows, and show how much you've already spent.
10
11
How to Use
12
1.The first thing you need to do if you want to use this spreadsheet is to make your own copy of it. To do this, select File -> Make a copy. Keep in mind, your copy will not be updated when I make updates to this spreadsheet.
13
2.Input your fleet's current XP values and note which upgrades and addons you've done on the Starbase and other Fleet Holding sheets (yellow values in white boxes). Everything else is automatically calculated from that, and summarized on the Overview sheet.
14
15
Notes
16
1.Costs and values provided are only estimates. It is practically impossible to know the exact amounts spent on fleet holdings. Value changes as the values of game currencies fluctuate. To calculate fleet value, I convert all inputs to the equivilent amount of dilithium, and calculate alternate values based on how dilithium exchanges into the other currencies.
17
2.Fleet Holding subsection XP values include the subsection tier upgrade costs as well. That is why I do not provide a way to input what subsection upgrades you've completed.
18
3.To view the data used in the calculations, take a look at the hidden sheets. View -> Hidden Sheets.
19
4.There is no way to calculate how much of a discount the Dilithium Mine gives a fleet without tracking every single project. I may try to tackle calculating potential discount values at a later time.
20
5.Time costs shown are not necessarily cumulative since multiple projects can be running at the same time.
21
22
Disclaimer
23
I am not responsible for unscrupulous fleet leaders using this spreadsheet to calculate their fleet's worth, kicking out existing members, and attempting to sell the fleet.
24
25
Still Missing
26
27
28
Change Log
29
V2.2- Added the Starbase Science T5 project info.
30
- Added Winter 2014 Starbase special project.
31
32
33
V2.1Adjustments for Season 9.5.
34
- Multiplied inputs for Particle Trace inputs by 5.
35
- Particle Trace values now match those for Data Samples.
36
- Internally, these are still called Data Samples and Particle Traces. Yes, I'm pulling a "Cryptic" and being too lazy to update things internally and merge the inputs. :-)
37
- You can read the Season 9.5 Patch Notes at:
38
http://sto-forum.perfectworld.com/showthread.php?t=1166951
39
40
V2.0Major revamp to include adding the Spire holding.
41
- Optimized the way the spreadsheet calculates the xp obtained and the costs for each tier.
42
- Assumes all add-on projects are completed during the tier they unlock. The xp gained from these is removed from the needed xp from normal projects during that tier. Are you confused yet? Basically, this means that costs shown are more indicative of what a normal fleet would expect, not necessarily a fleet trying to optimize development of a single track.
43
- If you really want to, you can see how the cost might change if you only ran certain other projects. However, the sheets with the xp calculations where you can choose these are hidden by default to prevent clutter.
44
- Costs are no longer provided for amounts greater than the max xp needed to max out a track.
45
- Improved the estimate of how many resources are needed to complete the fleet holdings.
46
- Completion estimates are now provided for individual holdings too.
47
- Completion percentages are now based on max xp per track. It is assumed all unlocked upgrades will also be completed, so the actual status of those is ignored.
48
- Provision costs are being removed from the primary cost calculations. Although the projects can earn your fleet xp, it becomes a moot point once you reach T5 in a track.
49
- Changed the value calculations to use the EC-Zen conversion rates instead of Dilithium-Zen. The rate is more stable and not prone to as many fluctuations.
50
- Removed Time from the total worth calculations since you can run multiple projects at a time.
51
52
V1.5Added the final Dilithium Mine Limited-Time upgrade.
53
- Discovered and corrected a slight calculation error on the Embassy and Dilithium Mine pages that refused to calculate above a certain amount of xp.
54
55
V1.4Added the latest Dilithium Mine Limited-Time upgrade.
56
- Corrected a minor problem in the calculation to determine the worth of a project. It was negating time rather than adding time.
57
58
V1.3Added Dilithium Mine information as provided by STOWiki.
59
*The spreadsheet cannot yet calculate revised cost/worth values based on discounts from the Mine.
60
- Updated or corrected several small issues discovered in other parts of the spreadsheet.
61
62
V1.2Altered 'Overview' sheet to calculate completion stats on the minimum requirements to get max tier and standard upgrades.
63
- Added individual provision costs to the 'Overview' sheet.
64
- Discovered and corrected an error in the way provision costs were calculated.
65
66
V1.1Removed XP awards from Starbase Add-On cost values to improve the accuracy of the starbase cost/value calculations. Embassy Add-Ons do not provide XP, so those did not need altered.
67
68
V1.0Initial Version - Thank you STOWiki for most of the data.
69
Loading...