• Log InLog In
  • Register
Liquid`
Team Liquid Liquipedia
EDT 03:42
CEST 09:42
KST 16:42
  • 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
Power Rank - Esports World Cup 202556RSL Season 1 - Final Week9[ASL19] Finals Recap: Standing Tall15HomeStory Cup 27 - Info & Preview18Classic wins Code S Season 2 (2025)16
Community News
BSL Team Wars - Bonyth, Dewalt, Hawk & Sziky teams9Weekly Cups (July 14-20): Final Check-up0Esports World Cup 2025 - Brackets Revealed19Weekly Cups (July 7-13): Classic continues to roll8Team TLMC #5 - Submission re-extension4
StarCraft 2
General
The GOAT ranking of GOAT rankings Power Rank - Esports World Cup 2025 What tournaments are world championships? RSL Revival patreon money discussion thread Jim claims he and Firefly were involved in match-fixing
Tourneys
Esports World Cup 2025 FEL Cracov 2025 (July 27) - $8000 live event Master Swan Open (Global Bronze-Master 2) Sparkling Tuna Cup - Weekly Open Tournament Sea Duckling Open (Global, Bronze-Diamond)
Strategy
How did i lose this ZvP, whats the proper response
Custom Maps
External Content
Mutation #239 Bad Weather Mutation # 483 Kill Bot Wars Mutation # 482 Wheel of Misfortune Mutation # 481 Fear and Lava
Brood War
General
BSL Team Wars - Bonyth, Dewalt, Hawk & Sziky teams BW General Discussion [Update] ShieldBattery: 2025 Redesign BGH Auto Balance -> http://bghmmr.eu/ Ginuda's JaeDong Interview Series
Tourneys
[Megathread] Daily Proleagues CSL Xiamen International Invitational [CSLPRO] It's CSLAN Season! - Last Chance [BSL 2v2] ProLeague Season 3 - Friday 21:00 CET
Strategy
Does 1 second matter in StarCraft? [G] Mineral Boosting Simple Questions, Simple Answers
Other Games
General Games
Stormgate/Frost Giant Megathread Nintendo Switch Thread [MMORPG] Tree of Savior (Successor of Ragnarok) Path of Exile CCLP - Command & Conquer League Project
Dota 2
Official 'what is Dota anymore' discussion
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 Vanilla Mini Mafia
Community
General
US Politics Mega-thread Things Aren’t Peaceful in Palestine Post Pic of your Favorite Food! Russo-Ukrainian War Thread The Games Industry And ATVI
Fan Clubs
SKT1 Classic Fan Club!
Media & Entertainment
[\m/] Heavy Metal Thread Anime Discussion Thread Movie Discussion! [Manga] One Piece Korean Music Discussion
Sports
Formula 1 Discussion 2024 - 2025 Football Thread TeamLiquid Health and Fitness Initiative For 2023 NBA General Discussion
World Cup 2022
Tech Support
Installation of Windows 10 suck at "just a moment" Computer Build, Upgrade & Buying Resource Thread
TL Community
The Automated Ban List
Blogs
Ping To Win? Pings And Their…
TrAiDoS
momentary artworks from des…
tankgirl
from making sc maps to makin…
Husyelt
StarCraft improvement
iopq
Socialism Anyone?
GreenHorizons
Customize Sidebar...

Website Feedback

Closed Threads



Active: 781 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 18m
[ Submit Event ]
Live Streams
Refresh
StarCraft 2
Livibee 250
Creator 93
ProTech85
StarCraft: Brood War
Nal_rA 6963
ToSsGirL 412
Zeus 200
Larva 200
Backho 89
JulyZerg 81
Dewaltoss 79
NotJumperer 20
Britney 0
Dota 2
XaKoH 844
XcaliburYe194
Fuzer 114
Counter-Strike
Stewie2K1177
Other Games
summit1g8760
hungrybox339
Organizations
StarCraft: Brood War
UltimateBattle 65
Other Games
BasetradeTV38
StarCraft 2
Blizzard YouTube
StarCraft: Brood War
BSLTrovo
sctven
[ Show 12 non-featured ]
StarCraft 2
• Sammyuel 42
• AfreecaTV YouTube
• intothetv
• Kozan
• IndyKCrew
• LaughNgamezSOOP
• Migwel
• sooper7s
StarCraft: Brood War
• BSLYoutube
• STPLYoutube
• ZZZeroYoutube
League of Legends
• Stunt732
Upcoming Events
Esports World Cup
3h 18m
Serral vs Cure
Solar vs Classic
OSC
6h 18m
CranKy Ducklings
1d 2h
BSL20 Non-Korean Champi…
1d 6h
CSO Cup
1d 8h
BSL20 Non-Korean Champi…
1d 10h
Bonyth vs Sziky
Dewalt vs Hawk
Hawk vs QiaoGege
Sziky vs Dewalt
Mihu vs Bonyth
Zhanhun vs QiaoGege
QiaoGege vs Fengzi
FEL
2 days
BSL20 Non-Korean Champi…
2 days
BSL20 Non-Korean Champi…
2 days
Bonyth vs Zhanhun
Dewalt vs Mihu
Hawk vs Sziky
Sziky vs QiaoGege
Mihu vs Hawk
Zhanhun vs Dewalt
Fengzi vs Bonyth
Sparkling Tuna Cup
4 days
[ Show More ]
Online Event
4 days
uThermal 2v2 Circuit
5 days
The PondCast
6 days
Replay Cast
6 days
Liquipedia Results

Completed

CSL Xiamen Invitational
Championship of Russia 2025
Murky Cup #2

Ongoing

Copa Latinoamericana 4
Jiahua Invitational
BSL20 Non-Korean Championship
Esports World Cup 2025
CC Div. A S7
Underdog Cup #2
IEM Cologne 2025
FISSURE Playground #1
BLAST.tv Austin Major 2025
ESL Impact League Season 7
IEM Dallas 2025
PGL Astana 2025
Asian Champions League '25

Upcoming

CSLPRO Last Chance 2025
ASL Season 20: Qualifier #1
ASL Season 20: Qualifier #2
ASL Season 20
CSLPRO Chat StarLAN 3
BSL Season 21
RSL Revival: Season 2
Maestros of the Game
SEL Season 2 Championship
uThermal 2v2 Main Event
FEL Cracov 2025
HCC Europe
ESL Pro League S22
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
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.