ABCDEFGHIJKLMNOPQRSTUV
1
Instructions: 1. Make a personal copy by going to File -> Make a copy...
2. Enter amount of tech points needed for upgrades as marked in cell C-3

That's it! You don't need to enter any other data (the rest of the sheet is a big reference table). Optional: you can enter the current Dil/Zen exhcange rate in cell J-3 for a cost reference.
2
Enter # of TP needed for next upgrade:Type of upgradeDilithium Cost:EC Cost to Craft:EC Cost to buy from Vendor:How much Zen is that much Dil?if the Dil/Zen Exchange Rate is:Brought to you by @Mighty_BOB_cnc
3
1,536,000# of Basics:768537,6005,760,0007,680,0003,090174URL to link back to this spreadsheet:
4
This does NOT take into account TP overflow!# of Improved:308292,6004,620,0001,682http://bit.ly/STOUpgradeTable
5
Listed Dilithium costs assume that you never# of Superior:120129,0001,800,000742Any cell that has a black triangle in the top-right corner contains a Note that you can read by hovering your cursor over it. Reading these is a good idea.
6
"Skip" any of the crafting or upgrade timers, or # of Experimental:120226,2001,800,0001,300
7
crit tech upgrade application (reduces costs).See also: http://bit.ly/STOCurrencyExchange
8
Bold+Red values are extrapolations based on the cost formulae. All others are direct observations.Upgrades last verified with the November 13th (2014) Holodeck patch; version: ST.45.20141019a.20
9
=========================SPACE GEAR=========================
10
Cost Multipliers:x1x1.2x1.4x1.6x1.8x2x2.324x2.656x2.988x3.32x1.862x2.128x2.394x2.66
11

Weapons, Shields, Engines, Deflectors, Warp/Singularity Cores
(includes Fleet gear, Lockbox weapons, Rep store weapons, & crafted gear)		Reputation Space SetsLobi, Episode set rewards, & Misc space gear
12
CommonUncommonRareVery RareUltra RareEpicMore MultipliersRareVery RareUltra RareEpicLobi Rare GearEpisode Sets & MiscMisc URMisc Epic
13
TP from Mk I to Mk II100120140160180200232266299332186213239266
14
TP from Mk II to Mk III200240280320360400x2465531598664372426479532
15
TP to Mk IV400480560640720800x29301,0621,1951,3287458519581,064
16
TP to Mk V8009601,1201,2801,4401,600x21,8592,1252,3902,6561,4901,7031,9152,128
17
TP to Mk VI1,5001,8002,1002,4002,7003,000x1.8753,4863,9844,4824,9802,7933,1923,5913,990
18
TP to Mk VII3,0003,6004,2004,8005,4006,000x26,9727,9688,9649,9605,5866,3847,1827,980
19
TP to Mk VIII6,0007,2008,4009,60010,80012,000x213,94415,93617,92819,92011,17212,76814,36415,960
20
TP to Mk IX12,00014,40016,80019,20021,60024,000x227,88831,87235,85639,84022,34425,53628,72831,920
21
TP to Mk X18,00021,60025,20028,80032,40036,000x1.541,83247,80853,78459,76033,51638,30443,09247,880
22
TP to Mk XI24,00028,80033,60038,40043,20048,000x1.3333355,77663,74471,71279,68044,68851,07257,45663,840
23
TP to Mk XII30,00036,00042,00048,00054,00060,000x1.2569,72079,68089,64099,60055,86063,84071,82079,800
24
TP to Mk XIII40,00048,00056,00064,00072,00080,000x1.3333392,960106,240119,520132,80074,48085,12095,760106,400
25
TP to Mk XIV80,00096,000112,000128,000144,000160,000x2185,920212,480239,040265,600148,960170,240191,520212,800
26
TP to try a Rarity Increase:120,000144,000168,000192,000216,000x1.5278,880318,720358,560223,440255,360287,280
27
Chance to increase rarity:40%20%10%5%2.5%10%5%2.50%10%5%2.5%
28
Max possible # of failed rarity upgrades at Mk XIV:24919399193991939
29
Statistical average # of Mk XIV Rarity Increase trials:1.722.51043.660215685.2935845867.6091130473.660215685.2935845867.6091130473.660215685.2935845867.609113047
30
31
NOTE: Directed Energy Distribution Manifold and Prefire Chamber consoles do not conform to the prices of ANY console upgrades. I'm not sure if this is a bug or by design due to their nature of improving multiple damage types.
32
http://sto-forum.perfectworld.com/showthread.php?p=19348701#post19348701
33

Tac/Sci/Eng Consoles (Includes Fleet consoles & Dyson consoles from rep boxes, and crafted consoles)Reputation Universal ConsolesLobi Universal Consoles
34
CommonUncommonRareVery RareUltra RareEpicVery RareUltra RareRareVery RareUltra Rare
35
TP from Mk I to Mk II32384552586474859610660687785
36
TP from Mk II to Mk III657891104117130151173194216121138156173
37
TP to Mk IV130156182208234260302345388432242277311346
38
TP to Mk V260312364416468520604691777863484553622692
39
TP to Mk VI4875846827798779741,1321,2931,4551,6179071,0361,1661,295
40
TP to Mk VII9751,1701,3651,5601,7551,9502,2662,5902,9133,2371,8152,0752,3342,594
41
TP to Mk VIII1,9502,3402,7303,1203,5103,9004,5325,1795,8276,4743,6314,1504,6685,187
42
TP to Mk IX3,9004,6805,4606,2407,0207,8009,06410,35811,65312,9487,2628,2999,33710,374
43
TP to Mk X5,8507,0208,1909,36010,53011,70013,59515,53817,48019,42210,89312,44914,00515,561
44
TP to Mk XI7,8009,36010,92012,48014,04015,60018,12720,71723,30625,89614,52416,59818,67320,748
45
TP to Mk XII9,75011,70013,65015,60017,55019,50022,65925,89629,13332,37018,15520,74823,34225,935
46
TP to Mk XIII13,00015,60018,20020,80023,40026,00030,21234,52838,84443,16024,20627,66431,12234,580
47
TP to Mk XIV26,00031,20036,40041,60046,80052,00060,42469,05677,68886,32048,41255,32862,24469,160
48
TP to try a Rarity Increase:39,00046,80054,60062,40070,200103,584116,53272,61882,99293,366
49
Chance to increase rarity:40%20%10%5%2.5%5%2.50%10%5%2.5%
50
Max possible # of failed rarity upgrades at Mk XIV:2491939193991939
51
Statistical average # of Mk XIV Rarity Increase trials:1.722.51043.660215685.2935845867.6091130475.2935845867.6091130473.660215685.2935845867.609113047
52
53
54

=========================GROUND GEAR=========================
55
Cost Multipliers:x1x1.2x1.4x1.6x1.8x2x2.324x2.656x2.988x3.32x1.596x1.862x2.1282.394
56

Armor, Shields, Weapons (includes Fleet/Lobi/Crafted gear and Lockbox/Rep store weapons)
Reputation Ground SetsNanopulse weapons (they don't match any other category)
57
CommonUncommonRareVery RareUltra RareEpicRareVery RareUltra RareEpicUncommonRareVery RareUltra Rare
58
TP from Mk I to Mk II667993106119132153175197219105123140158
59
TP from Mk II to Mk III134161187215242268311356400445214250285321
60
TP to Mk IV266319373425479532618706795883425495566637
61
TP to Mk V5346417478559621,0681,2411,4181,5961,7738529941,1361,278
62
TP to Mk VI1,0001,2001,4001,6001,8002,0002,3242,6562,9883,3201,5961,8622,1282,394
63
TP to Mk VII2,0012,4012,8023,2013,6024,0024,6505,3155,9796,6433,1943,7264,2584,790
64
TP to Mk VIII4,0024,8025,6036,4037,2048,0049,30110,62911,95813,2876,3877,4528,5169,581
65
TP to Mk IX8,0049,60511,20512,80714,40716,00818,60121,25923,91626,57312,77414,90317,03319,162
66
TP to Mk X12,00614,40716,80919,20921,61124,01227,90231,88835,87439,86019,16222,35525,54928,742
67
TP to Mk XI16,00819,21022,41125,61328,81432,01637,20342,51747,83253,14725,54929,80734,06538,323
68
TP to Mk XII20,01024,01228,01432,01636,01840,02046,50353,14759,79066,43331,93637,25942,58147,904
69
TP to Mk XIII26,68032,01637,35242,68848,02453,36062,00470,86279,72088,57842,58149,67856,77563,872
70
TP to Mk XIV53,36064,03274,70485,37696,048106,720124,009141,724159,440177,15585,16399,356113,550127,744
71
TP to try a Rarity Increase:80,04096,048112,056128,064144,072186,013212,586239,160127,743149,035170,325191,616
72
Chance to increase rarity:40%20%10%5%2.5%10%5%2.5%20%10%5%2.5%
73
Max possible # of failed rarity upgrades at Mk XIV:249193991939491939
74
Statistical average # of Mk XIV Rarity Increase trials:1.722.51043.660215685.2935845867.6091130473.660215685.2935845867.6091130472.51043.660215685.2935845867.609113047
75
76
77
The bonus mod for an item at Epic (Gold) quality is a unique special mod that doesn't otherwise appear, generally more powerful than other mods. These are:Informational post by Dev: jheinig
78
Space Shield: [Cp/Rg] Combined capacity/regen boosthttp://sto-forum.perfectworld.com/showthread.php?p=19265431#post19265431
79
Space Impulse Engine: [Drv2] Overcharged driver coil, double coil bonusOfficial Tribble Feedback thread for Gear Upgrades:
80
Space Deflector: [SS/SI] Interlaced integrity, structural integrity/shield systems combined bonushttp://sto-forum.perfectworld.com/showthread.php?t=1224081
81
Space Weapon: [Ac/Dm]: Bonus accuracy/damage comboI don't like the Rarity upgrade process once you've already reached XIV, a cost analysis by Bob:
82
Ground Shield: [Cap2] Double capacity bonushttp://sto-forum.perfectworld.com/showthread.php?p=19379591#post19379591
83
Ground Armor: [ResAll/HP] Bonus HP and bonus resist all damage
84
Ground Weapon: [Dm/CrH] Bonus damage and critical chance combo
85
86
Great upgrade calculator to take gear to Mk XIV (no rarity increase) + material costs by @hadouhou
87
https://docs.google.com/spreadsheets/d/1nMdeAodkcs7Lzqd4xLcp6OWs6UrcnnAnywpwWGrlxTc/edit?pli=1#gid=885824117
88
Super awesome cost calculator for crafting tech upgrades (and general R&D tracking) by @daBelgrave
89
https://docs.google.com/spreadsheets/d/1CmfFLcknQ7W0RptMr1Dx51Oqom1m2PyvCCHAqbMdl1I/edit#gid=1065093074
90
Other upgrade research including detailed timer and dilithium costs by @spencerb96
91
https://docs.google.com/spreadsheets/d/1JU8ciOpp5kbplvwFanr7ast9THnAwC3LywmYHZREMx0/edit?pli=1#gid=0
92
Simple upgrade table with less visual clutter by @qziqza (also includes Starship Skill Point Effects Table)
93
http://bit.ly/1x3BGMT
94
95
96
97
98
99
100