• Log InLog In
  • Register
Liquid`
Team Liquid Liquipedia
EDT 04:59
CEST 10:59
KST 17:59
  • Home
  • Forum
  • Calendar
  • Streams
  • Liquipedia
  • Features
  • Store
  • EPT
  • TL+
  • StarCraft 2
  • Brood War
  • Smash
  • Heroes
  • Counter-Strike
  • Overwatch
  • Liquibet
  • Fantasy StarCraft
  • TLPD
  • StarCraft 2
  • Brood War
  • Blogs
Forum Sidebar
Events/Features
News
Featured News
Team Liquid Map Contest #22 - The Finalists2[ASL21] Ro16 Preview Pt1: Fresh Flow9[ASL21] Ro24 Preview Pt2: News Flash10[ASL21] Ro24 Preview Pt1: New Chaos0Team Liquid Map Contest #22 - Presented by Monster Energy21
Community News
Weekly Cups (April 6-12): herO doubles, "Villains" prevail0MaNa leaves Team Liquid18$5,000 WardiTV TLMC tournament - Presented by Monster Energy5GSL CK: More events planned pending crowdfunding7Weekly Cups (Mar 30-Apr 5): herO, Clem, SHIN win0
StarCraft 2
General
Team Liquid Map Contest #22 - The Finalists Weekly Cups (April 6-12): herO doubles, "Villains" prevail MaNa leaves Team Liquid Blizzard Classic Cup @ BlizzCon 2026 - $100k prize pool Team Liquid Map Contest #22 - Presented by Monster Energy
Tourneys
SEL Doubles (SC Evo Bimonthly) Sparkling Tuna Cup - Weekly Open Tournament $5,000 WardiTV TLMC tournament - Presented by Monster Energy RSL Revival: Season 5 - Qualifiers and Main Event GSL CK: More events planned pending crowdfunding
Strategy
Custom Maps
[D]RTS in all its shapes and glory <3 [A] Nemrods 1/4 players [M] (2) Frigid Storage
External Content
Mutation # 521 Memorable Boss The PondCast: SC2 News & Results Mutation # 520 Moving Fees Mutation # 519 Inner Power
Brood War
General
[ASL21] Ro16 Preview Pt1: Fresh Flow BW General Discussion ASL21 Strategy, Pimpest Plays Discussions ASL21 General Discussion BGH Auto Balance -> http://bghmmr.eu/
Tourneys
[ASL21] Ro16 Group B [ASL21] Ro16 Group A [Megathread] Daily Proleagues Escore Tournament StarCraft Season 2
Strategy
Any training maps people recommend? Fighting Spirit mining rates Muta micro map competition What's the deal with APM & what's its true value
Other Games
General Games
Battle Aces/David Kim RTS Megathread Nintendo Switch Thread Stormgate/Frost Giant Megathread General RTS Discussion Thread Starcraft Tabletop Miniature Game
Dota 2
The Story of Wings Gaming Official 'what is Dota anymore' discussion
League of Legends
G2 just beat GenG in First stand
Heroes of the Storm
Simple Questions, Simple Answers Heroes of the Storm 2.0
Hearthstone
Deck construction bug Heroes of StarCraft mini-set
TL Mafia
Vanilla Mini Mafia Mafia Game Mode Feedback/Ideas TL Mafia Community Thread Five o'clock TL Mafia
Community
General
US Politics Mega-thread Russo-Ukrainian War Thread Canadian Politics Mega-thread European Politico-economics QA Mega-thread The China Politics Thread
Fan Clubs
The IdrA Fan Club
Media & Entertainment
[Req][Books] Good Fantasy/SciFi books [Manga] One Piece Movie Discussion!
Sports
2024 - 2026 Football Thread Formula 1 Discussion Cricket [SPORT] Tokyo Olympics 2021 Thread
World Cup 2022
Tech Support
[G] How to Block Livestream Ads
TL Community
The Automated Ban List
Blogs
lurker extra damage testi…
StaticNine
How Streamers Inspire Gamers…
TrAiDoS
Broowar part 2
qwaykee
Funny Nicknames
LUCKY_NOOB
Iranian anarchists: organize…
XenOsky
ASL S21 English Commentary…
namkraft
Customize Sidebar...

Website Feedback

Closed Threads



Active: 2741 users

TL Cost Efficiency Spreadsheet - Page 3

Forum Index > LoL General
Post a Reply
Prev 1 2 3 All
UniversalSnip
Profile Blog Joined July 2010
9871 Posts
September 04 2011 17:48 GMT
#41
yeah regen simply isn't calculated because the numbers come out as nonsense. There's a way but I don't know it. just have to eyeball the true value for now
"How fucking dare you defile the sanctity of DotA with your fucking casual plebian terminology? May the curse of Gaben and Volvo be upon you. le filthy casual."
barbsq
Profile Joined November 2009
United States5348 Posts
September 04 2011 19:20 GMT
#42
theres a whole bunch of 'circular dependance errors'
Look at this guy, constantly diluting himself! (╮°-°)╮┳━┳ ( ╯°□°)╯ ┻━┻
UniversalSnip
Profile Blog Joined July 2010
9871 Posts
Last Edited: 2011-09-04 20:07:57
September 04 2011 20:05 GMT
#43
suppose I should just disable public editing and give out keys to whoever asks so dyrus can't come in here and fuck it up

maybe i'll figure that out tonight
"How fucking dare you defile the sanctity of DotA with your fucking casual plebian terminology? May the curse of Gaben and Volvo be upon you. le filthy casual."
UniversalSnip
Profile Blog Joined July 2010
9871 Posts
September 06 2011 20:04 GMT
#44
You now have to be logged on to edit it, otherwise no editing restrictions... I can just ban someone who messes it up
"How fucking dare you defile the sanctity of DotA with your fucking casual plebian terminology? May the curse of Gaben and Volvo be upon you. le filthy casual."
redex777
Profile Joined May 2010
United States4 Posts
September 06 2011 22:51 GMT
#45
I can't edit this even when logged in to my google docs.

I just wanted to change Abyssal Scepter to say "Paying for 20 MR reduction aura" instead of penetration... they are different!

The only other item that has MR reduction is Malady and it is correctly stated in the shee

also here is a link if you want to invest some time figuring out how magic damage is calculated
Attakijing: "even though it is often incorrect, the way to improve your game seems to be to minimize blaming others and instead "trust no one" in solo queue like dyrus says, AKA realizing it is your fucking fault when you die."
crate
Profile Blog Joined May 2009
United States2474 Posts
September 07 2011 00:55 GMT
#46
If anyone really cares about regen or spellvamp being included I went ahead and uploaded my version of an item efficiency spreadsheet here. I had actually made this before this topic was created but figured it didn't really add much so I didn't bother to post it until now.

Main differences are that I valued items compared to the basic, low-tier items (longsword, amp tome, etc.) and obviously that I included regen and spellvamp (the latter based on Hextech Revolver, assuming that all the combine cost is the spellvamp cost). Also includes an efficiency column which is the actual cost divided by the effective cost (i.e. cost of all the priced stats) to make it a bit easier to compare the efficiency of items with different costs (e.g. it's really hard to compare Rod of Ages to stacking Doran's Rings on USnip's sheet because their base price difference is just so vast).

All items are sorted purely by name. Has no pretty colors.

Comparing to basic items instead of higher-tier single-stat items does adjust the price of AD compared to AP, as my sheet says a BF Sword is significantly more efficient than a Needlessly Large Rod (this is a result of Riot cutting the BF Sword cost a while back without changing its stats). Otherwise it's not a big deal, it just means that items are going to look more efficient in my sheet compared to USnip's.

I might have a few stats wrong (almost certainly some of the misc stuff is wrong, because I don't actually look at that very often myself) because I didn't update this for a while until this weekend; you can tell me if I have anything wrong and I'll probably get around to fixing it.

Won't be publicly editable because I don't want to have to reset it.
We did. You did. Yes we can. No. || http://crawl.akrasiac.org/scoring/players/crate.html || twitch.tv/crate3333
UniversalSnip
Profile Blog Joined July 2010
9871 Posts
Last Edited: 2011-09-07 03:20:40
September 07 2011 03:19 GMT
#47
crate, I'll add your sheet to the OP. I really do think wu thuong was smart not to include regen in the item calculations though because the results are completely meaningless. Look at how mindbogglingly efficient reverie, miracle, etc are when you calculate straight up off pendant/etc, if they were actually worth that much gold they'd be must build on everyone.

On September 07 2011 07:51 redex777 wrote:
I can't edit this even when logged in to my google docs.


ok well the the options are totally misleading than, lol

new setup: post here asking for permission to edit and I'll give it. Needs email address if you don't want crawlers to find it I guess you could PM it to me. fixed the scepter thing btw
"How fucking dare you defile the sanctity of DotA with your fucking casual plebian terminology? May the curse of Gaben and Volvo be upon you. le filthy casual."
crate
Profile Blog Joined May 2009
United States2474 Posts
September 07 2011 03:33 GMT
#48
Well the thing is, look at Archangel's staff with maxed out mana. Supposedly that's disgustingly cost effective as well ... but most of that is because you have an item that gives you 1400 fucking mana which 90% of the champs will never be able to use (so it's wasted). Or look at Rageblade and how it's like the most realistically imba item in the game at full stacks, and even if you can only get to 3 or so it rivals almost any other item this side of stacked up RoA/Bloodthirster ... but most champs can't effectively use all three stats so it's worth much less.

Probably the most useful way to look at these is to break down the items into how much each of their individual stats are worth (e.g. Bloodthirster is worth this much gold for the AD alone and this much for the lifesteal alone) but I'm too lazy to go make that myself at the moment. If you have that then you can decide how much a Gunblade is worth on Pantheon or a Triforce on Lee Sin or whatever.

It's not a problem unique to regen, which is why I think adding it in is just fine. I realize it's more extreme for regen than most stats (regen doesn't do much at all in quick teamfights) but if it bothers you well we have the spreadsheet you're maintaining to look at no-regen costs, which I can see the point of examining.
We did. You did. Yes we can. No. || http://crawl.akrasiac.org/scoring/players/crate.html || twitch.tv/crate3333
spinesheath
Profile Blog Joined June 2009
Germany8679 Posts
September 07 2011 08:46 GMT
#49
On September 07 2011 09:55 crate wrote:
this is a result of Riot cutting the BF Sword cost a while back without changing its stats

They reduced the AD on BF Sword to 45.
If you have a good reason to disagree with the above, please tell me. Thank you.
Slayer91
Profile Joined February 2006
Ireland23335 Posts
September 07 2011 10:40 GMT
#50
On September 07 2011 12:33 crate wrote:
Well the thing is, look at Archangel's staff with maxed out mana. Supposedly that's disgustingly cost effective as well ... but most of that is because you have an item that gives you 1400 fucking mana which 90% of the champs will never be able to use (so it's wasted). Or look at Rageblade and how it's like the most realistically imba item in the game at full stacks, and even if you can only get to 3 or so it rivals almost any other item this side of stacked up RoA/Bloodthirster ... but most champs can't effectively use all three stats so it's worth much less.

Probably the most useful way to look at these is to break down the items into how much each of their individual stats are worth (e.g. Bloodthirster is worth this much gold for the AD alone and this much for the lifesteal alone) but I'm too lazy to go make that myself at the moment. If you have that then you can decide how much a Gunblade is worth on Pantheon or a Triforce on Lee Sin or whatever.

It's not a problem unique to regen, which is why I think adding it in is just fine. I realize it's more extreme for regen than most stats (regen doesn't do much at all in quick teamfights) but if it bothers you well we have the spreadsheet you're maintaining to look at no-regen costs, which I can see the point of examining.


The reason they are cost effective is because of the fact that most people can't use all the stats to full potential. Riot isn't making OP items you know. There's a trade off for everything.

But yeah, this spreadsheet isn't that help ful at all most things you can work out yourself with run-->calc in 20 seconds for the most complicated items.
crate
Profile Blog Joined May 2009
United States2474 Posts
September 07 2011 10:47 GMT
#51
On September 07 2011 17:46 spinesheath wrote:
Show nested quote +
On September 07 2011 09:55 crate wrote:
this is a result of Riot cutting the BF Sword cost a while back without changing its stats

They reduced the AD on BF Sword to 45.

Oh, lol, nevermind then, I guess BF Sword was just always more efficient than NLR.
We did. You did. Yes we can. No. || http://crawl.akrasiac.org/scoring/players/crate.html || twitch.tv/crate3333
isleyofthenorth
Profile Blog Joined June 2009
Austria894 Posts
September 07 2011 12:14 GMT
#52
I agree with some people in this thread Hp5 hast to be integrated as well
UniversalSnip
Profile Blog Joined July 2010
9871 Posts
September 08 2011 01:31 GMT
#53
On September 07 2011 12:33 crate wrote:
Well the thing is, look at Archangel's staff with maxed out mana. Supposedly that's disgustingly cost effective as well ... but most of that is because you have an item that gives you 1400 fucking mana which 90% of the champs will never be able to use (so it's wasted). Or look at Rageblade and how it's like the most realistically imba item in the game at full stacks, and even if you can only get to 3 or so it rivals almost any other item this side of stacked up RoA/Bloodthirster ... but most champs can't effectively use all three stats so it's worth much less.

Probably the most useful way to look at these is to break down the items into how much each of their individual stats are worth (e.g. Bloodthirster is worth this much gold for the AD alone and this much for the lifesteal alone) but I'm too lazy to go make that myself at the moment. If you have that then you can decide how much a Gunblade is worth on Pantheon or a Triforce on Lee Sin or whatever.

It's not a problem unique to regen, which is why I think adding it in is just fine. I realize it's more extreme for regen than most stats (regen doesn't do much at all in quick teamfights) but if it bothers you well we have the spreadsheet you're maintaining to look at no-regen costs, which I can see the point of examining.


there's a limit to the information you can draw from these charts, when you reach these limits I think it's better to just let people draw their own conclusions about the items than include information that's actually misleading
"How fucking dare you defile the sanctity of DotA with your fucking casual plebian terminology? May the curse of Gaben and Volvo be upon you. le filthy casual."
crate
Profile Blog Joined May 2009
United States2474 Posts
September 08 2011 01:44 GMT
#54
I don't think including regen is misleading.
We did. You did. Yes we can. No. || http://crawl.akrasiac.org/scoring/players/crate.html || twitch.tv/crate3333
sylverfyre
Profile Joined May 2010
United States8298 Posts
September 08 2011 01:49 GMT
#55
On September 08 2011 10:44 crate wrote:
I don't think including regen is misleading.

Thing is, regen costs less the more you get of it, because the stat is only REALLY useful in the early game. You could say, for example, that FON or a stacked up Warmogs is like a billion times more efficient on HP regen than a Regrowth pendant, but that doesn't mean much at all.
UniversalSnip
Profile Blog Joined July 2010
9871 Posts
Last Edited: 2011-09-08 02:17:55
September 08 2011 02:17 GMT
#56
It seems unlikely to me that the whole philo tree is as efficient as calculating regen linearly indicates... not even getting into the other regen items
"How fucking dare you defile the sanctity of DotA with your fucking casual plebian terminology? May the curse of Gaben and Volvo be upon you. le filthy casual."
sylverfyre
Profile Joined May 2010
United States8298 Posts
September 08 2011 02:46 GMT
#57
On September 08 2011 11:17 UniversalSnip wrote:
It seems unlikely to me that the whole philo tree is as efficient as calculating regen linearly indicates... not even getting into the other regen items

Well, I guess it could be useful comparing Meki to FaerieCharm to Philo and same with health pendant/bead/philo crap - the early game stuff. And just ignore warmogs and FON and the other weird late game items that happen to have regen but are hard to place a value on that regen.
crate
Profile Blog Joined May 2009
United States2474 Posts
Last Edited: 2011-09-09 10:49:53
September 09 2011 10:47 GMT
#58
Updated my sheet. Now has some color in the efficiency column. Also new sheet 2 that breaks down what you're actually paying for on an item like I suggested would be helpful.

Bit of behind-the-scenes calculation adjustment as well but you won't notice that (other than it fixed the cost of CDR because apparently Kindlegem got a price increase or something when I wasn't looking, or I entered the data wrong in the first place).

Added the Dominion items as well though obviously those aren't particularly useful at the moment. Didn't add the Dominion items to the "on-hits as AD" section yet.
We did. You did. Yes we can. No. || http://crawl.akrasiac.org/scoring/players/crate.html || twitch.tv/crate3333
Bulldozer
Profile Joined October 2010
United States89 Posts
September 09 2011 13:05 GMT
#59
just a quick edit, youre not paying for just 15 apen on brutalizer, but also 10% CD.
Welcome to the Transformation; Welcome to Anniahliation
UniversalSnip
Profile Blog Joined July 2010
9871 Posts
September 10 2011 03:02 GMT
#60
CDR is actually included
"How fucking dare you defile the sanctity of DotA with your fucking casual plebian terminology? May the curse of Gaben and Volvo be upon you. le filthy casual."
Prev 1 2 3 All
Please log in or register to reply.
Live Events Refresh
Next event in 1h 1m
[ Submit Event ]
Live Streams
Refresh
StarCraft: Brood War
Jaedong 751
910 452
Tasteless 407
Pusan 289
Larva 206
Leta 156
Sharp 113
actioN 106
EffOrt 81
Killer 59
[ Show more ]
Hm[arnc] 56
Free 55
yabsab 43
scan(afreeca) 43
ToSsGirL 35
Shinee 29
zelot 19
Dota 2
XaKoH 672
XcaliburYe253
NeuroSwarm87
League of Legends
JimRising 546
Counter-Strike
Stewie2K1150
shoxiejesuss815
Super Smash Bros
Mew2King85
Other Games
Liquid`RaSZi632
Happy236
Organizations
Other Games
gamesdonequick537
Counter-Strike
PGL281
StarCraft 2
Blizzard YouTube
StarCraft: Brood War
BSLTrovo
sctven
[ Show 12 non-featured ]
StarCraft 2
• LUISG 21
• AfreecaTV YouTube
• intothetv
• Kozan
• IndyKCrew
• LaughNgamezSOOP
• Migwel
• sooper7s
StarCraft: Brood War
• BSLYoutube
• STPLYoutube
• ZZZeroYoutube
League of Legends
• Stunt525
Upcoming Events
Afreeca Starleague
1h 1m
Snow vs PianO
hero vs Rain
WardiTV Map Contest Tou…
1h 1m
GSL
3h 1m
PiGosaur Cup
15h 1m
CranKy Ducklings
1d
Kung Fu Cup
1d 3h
Replay Cast
1d 15h
The PondCast
2 days
WardiTV Map Contest Tou…
2 days
Replay Cast
2 days
[ Show More ]
Escore
3 days
WardiTV Map Contest Tou…
3 days
Korean StarCraft League
3 days
CranKy Ducklings
4 days
WardiTV Map Contest Tou…
4 days
IPSL
4 days
WolFix vs nOmaD
dxtr13 vs Razz
BSL
4 days
Sparkling Tuna Cup
5 days
WardiTV Map Contest Tou…
5 days
Ladder Legends
5 days
BSL
5 days
IPSL
5 days
JDConan vs TBD
Aegong vs rasowy
Replay Cast
5 days
Replay Cast
6 days
Wardi Open
6 days
Afreeca Starleague
6 days
Bisu vs Ample
Jaedong vs Flash
Monday Night Weeklies
6 days
RSL Revival
6 days
Liquipedia Results

Completed

Escore Tournament S2: W2
RSL Revival: Season 4
NationLESS Cup

Ongoing

BSL Season 22
ASL Season 21
CSL 2026 SPRING (S20)
IPSL Spring 2026
StarCraft2 Community Team League 2026 Spring
Nations Cup 2026
PGL Bucharest 2026
Stake Ranked Episode 1
BLAST Open Spring 2026
ESL Pro League S23 Finals
ESL Pro League S23 Stage 1&2
PGL Cluj-Napoca 2026
IEM Kraków 2026

Upcoming

Escore Tournament S2: W3
Acropolis #4
BSL 22 Non-Korean Championship
CSLAN 4
Kung Fu Cup 2026 Grand Finals
HSC XXIX
uThermal 2v2 2026 Main Event
RSL Revival: Season 5
WardiTV TLMC #16
IEM Cologne Major 2026
Stake Ranked Episode 2
CS Asia Championships 2026
Asian Champions League 2026
IEM Atlanta 2026
PGL Astana 2026
BLAST Rivals Spring 2026
CCT Season 3 Global Finals
IEM Rio 2026
TLPD

1. ByuN
2. TY
3. Dark
4. Solar
5. Stats
6. Nerchio
7. sOs
8. soO
9. INnoVation
10. Elazer
1. Rain
2. Flash
3. EffOrt
4. Last
5. Bisu
6. Soulkey
7. Mini
8. Sharp
Sidebar Settings...

Advertising | Privacy Policy | Terms Of Use | Contact Us

Original banner artwork: Jim Warren
The contents of this webpage are copyright © 2026 TLnet. All Rights Reserved.