• Log InLog In
  • Register
Liquid`
Team Liquid Liquipedia
EDT 16:10
CEST 22:10
KST 05:10
  • 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 TLMC #5: Vote to Decide Ladder Maps!0[ASL20] Ro8 Preview Pt1: Mile High15Team TLMC #5 - Finalists & Open Tournaments2[ASL20] Ro16 Preview Pt2: Turbulence10Classic Games #3: Rogue vs Serral at BlizzCon10
Community News
Artosis vs Ret Showmatch3Classic wins RSL Revival Season 20Weekly Cups (Sept 15-21): herO Goes For Four2SC2 5.0.15 PTR Patch Notes + Sept 22nd update257BSL 2025 Warsaw LAN + Legends Showmatch4
StarCraft 2
General
Storm change is a essentially a strict buff on PTR SC2 5.0.15 PTR Patch Notes + Sept 22nd update Code S RO4 & Finals Preview - Cure, Dark, Maru, Creator Why Storm Should NOT Be Nerfed – A Core Part of Pr Classic wins RSL Revival Season 2
Tourneys
Sparkling Tuna Cup - Weekly Open Tournament Prome's Evo #1 - Solar vs Classic (SC: Evo) Monday Nights Weeklies RSL: Revival, a new crowdfunded tournament series SC2's Safe House 2 - October 18 & 19
Strategy
Custom Maps
External Content
Mutation # 492 Get Out More Mutation # 491 Night Drive Mutation # 490 Masters of Midnight Mutation # 489 Bannable Offense
Brood War
General
BW General Discussion Artosis vs Ret Showmatch Whose hotkey signature is this? [ASL20] Ro8 Preview Pt1: Mile High BGH Auto Balance -> http://bghmmr.eu/
Tourneys
[Megathread] Daily Proleagues [ASL20] Ro8 Day 2 [ASL20] Ro8 Day 1 [ASL20] Ro16 Group D
Strategy
Simple Questions, Simple Answers Muta micro map competition
Other Games
General Games
Stormgate/Frost Giant Megathread Nintendo Switch Thread Liquipedia App: Now Covering SC2 and Brood War! Path of Exile Borderlands 3
Dota 2
Official 'what is Dota anymore' discussion LiquidDota to reintegrate into TL.net
League of Legends
Heroes of the Storm
Simple Questions, Simple Answers Heroes of the Storm 2.0
Hearthstone
Heroes of StarCraft mini-set
TL Mafia
TL Mafia Community Thread
Community
General
US Politics Mega-thread Russo-Ukrainian War Thread Things Aren’t Peaceful in Palestine The Big Programming Thread UK Politics Mega-thread
Fan Clubs
The Happy Fan Club!
Media & Entertainment
Movie Discussion! [Manga] One Piece Anime Discussion Thread
Sports
2024 - 2026 Football Thread TeamLiquid Health and Fitness Initiative For 2023 Formula 1 Discussion MLB/Baseball 2023
World Cup 2022
Tech Support
Linksys AE2500 USB WIFI keeps disconnecting Computer Build, Upgrade & Buying Resource Thread High temperatures on bridge(s)
TL Community
BarCraft in Tokyo Japan for ASL Season5 Final The Automated Ban List
Blogs
[AI] JoCo is Eminem for com…
Peanutsc
Try to reverse getting fired …
Garnet
[ASL20] Players bad at pi…
pullarius1
Too Many LANs? Tournament Ov…
TrAiDoS
Customize Sidebar...

Website Feedback

Closed Threads



Active: 1743 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 3h 50m
[ Submit Event ]
Live Streams
Refresh
StarCraft 2
UpATreeSC 182
IndyStarCraft 172
JuggernautJason149
NeuroSwarm 98
ForJumy 54
StarCraft: Brood War
Mini 196
ggaemo 190
firebathero 145
Dewaltoss 68
NaDa 13
Dota 2
Dendi1863
Counter-Strike
ScreaM1379
pashabiceps432
Stewie2K261
byalli214
Foxcn113
Heroes of the Storm
Khaldor227
Other Games
Grubby2709
B2W.Neo315
C9.Mang095
Trikslyr65
Sick54
OptimusSC24
Organizations
Other Games
BasetradeTV42
StarCraft 2
angryscii 33
Blizzard YouTube
StarCraft: Brood War
BSLTrovo
sctven
[ Show 15 non-featured ]
StarCraft 2
• davetesta27
• Reevou 15
• AfreecaTV YouTube
• intothetv
• Kozan
• IndyKCrew
• LaughNgamezSOOP
• Migwel
• sooper7s
StarCraft: Brood War
• BSLYoutube
• STPLYoutube
• ZZZeroYoutube
League of Legends
• TFBlade725
• Shiphtur331
Other Games
• imaqtpie1658
Upcoming Events
PiGosaur Monday
3h 50m
LiuLi Cup
14h 50m
OSC
18h 50m
The PondCast
1d 13h
CranKy Ducklings
2 days
Maestros of the Game
3 days
Serral vs herO
Clem vs Reynor
[BSL 2025] Weekly
3 days
[BSL 2025] Weekly
3 days
BSL Team Wars
4 days
Wardi Open
5 days
[ Show More ]
Sparkling Tuna Cup
6 days
Liquipedia Results

Completed

2025 Chongqing Offline CUP
RSL Revival: Season 2
HCC Europe

Ongoing

BSL 20 Team Wars
KCM Race Survival 2025 Season 3
BSL 21 Points
ASL Season 20
CSL 2025 AUTUMN (S18)
Maestros of the Game
StarSeries Fall 2025
FISSURE Playground #2
BLAST Open Fall 2025
BLAST Open Fall Qual
Esports World Cup 2025
BLAST Bounty Fall 2025
BLAST Bounty Fall Qual
IEM Cologne 2025
FISSURE Playground #1

Upcoming

IPSL Winter 2025-26
SC4ALL: Brood War
BSL 21 Team A
BSL Season 21
RSL Revival: Season 3
Stellar Fest
SC4ALL: StarCraft II
EC S1
ESL Impact League Season 8
SL Budapest Major 2025
BLAST Rivals Fall 2025
IEM Chengdu 2025
PGL Masters Bucharest 2025
Thunderpick World Champ.
CS Asia Championships 2025
ESL Pro League S22
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 © 2025 TLnet. All Rights Reserved.