• Log InLog In
  • Register
Liquid`
Team Liquid Liquipedia
EDT 22:32
CEST 04:32
KST 11:32
  • 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
RSL Season 1 - Final Week6[ASL19] Finals Recap: Standing Tall12HomeStory Cup 27 - Info & Preview18Classic wins Code S Season 2 (2025)16Code S RO4 & Finals Preview: herO, Rogue, Classic, GuMiho0
Community News
Team TLMC #5 - Submission extension0Firefly given lifetime ban by ESIC following match-fixing investigation17$25,000 Streamerzone StarCraft Pro Series announced7Weekly Cups (June 30 - July 6): Classic Doubles7[BSL20] Non-Korean Championship 4x BSL + 4x China11
StarCraft 2
General
Team TLMC #5 - Submission extension TL Team Map Contest #5: Presented by Monster Energy RSL Revival patreon money discussion thread The GOAT ranking of GOAT rankings Weekly Cups (June 30 - July 6): Classic Doubles
Tourneys
$5,100+ SEL Season 2 Championship (SC: Evo) WardiTV Mondays RSL: Revival, a new crowdfunded tournament series Sparkling Tuna Cup - Weekly Open Tournament FEL Cracov 2025 (July 27) - $8000 live event
Strategy
How did i lose this ZvP, whats the proper response Simple Questions Simple Answers
Custom Maps
External Content
Mutation # 482 Wheel of Misfortune Mutation # 481 Fear and Lava Mutation # 480 Moths to the Flame Mutation # 479 Worn Out Welcome
Brood War
General
A cwal.gg Extension - Easily keep track of anyone Flash Announces Hiatus From ASL [Guide] MyStarcraft BW General Discussion [ASL19] Finals Recap: Standing Tall
Tourneys
[BSL20] Non-Korean Championship 4x BSL + 4x China [Megathread] Daily Proleagues 2025 ACS Season 2 Qualifier Small VOD Thread 2.0
Strategy
Simple Questions, Simple Answers I am doing this better than progamers do.
Other Games
General Games
Stormgate/Frost Giant Megathread Path of Exile CCLP - Command & Conquer League Project The PlayStation 5 Nintendo Switch Thread
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 Summer Games Done Quick 2025! Russo-Ukrainian War Thread Things Aren’t Peaceful in Palestine The Accidental Video Game Porn Archive
Fan Clubs
SKT1 Classic Fan Club! Maru Fan Club
Media & Entertainment
Movie Discussion! [Manga] One Piece Anime Discussion Thread [\m/] Heavy Metal Thread
Sports
2024 - 2025 Football Thread Formula 1 Discussion NBA General Discussion TeamLiquid Health and Fitness Initiative For 2023 NHL Playoffs 2024
World Cup 2022
Tech Support
Computer Build, Upgrade & Buying Resource Thread
TL Community
The Automated Ban List
Blogs
Men Take Risks, Women Win Ga…
TrAiDoS
momentary artworks from des…
tankgirl
from making sc maps to makin…
Husyelt
StarCraft improvement
iopq
Trip to the Zoo
micronesia
Customize Sidebar...

Website Feedback

Closed Threads



Active: 500 users

Upgrade Spreadsheet - # of Attacks to Kill

Forum Index > SC2 General
Post a Reply
Normal
paul415
Profile Joined August 2010
United States25 Posts
Last Edited: 2011-03-24 20:57:01
August 26 2010 06:12 GMT
#1
Purpose: To determine the number of hits required for one unit to kill another. This is great for general informative purposes in addition to theorycrafting which upgrades are more valuable than others.

Current Version: 13
Date: March 24, 2011

Download Link:
http://min.us/mvjhrP#2

For those with older versions of Excel:
http://min.us/mvjhrP#1

Online Link* (not fully tested):
http://tiny.cc/UpgradeSpreadsheet13

*Note: You will not be able to update this spreadsheet with your own upgrade values.
If you would like to test your own values, you'll need to go to File->Make a copy...

Changes in version 13:
Updated for Patch 1.3.0
Infestor attack speed adjusted to 4 seconds.
Infestor damage increased by +30% vs. armored units.

How to Use:
Depending on which race you want to attack, go to the appropriate tab (Attacking Protoss, Attacking Terran, or Attacking Zerg).
The units listed on the left are the attackers while the units at the top are the defenders.
The numbers within the graphs are the number of hits required for the attacker to kill the defender.

Comments? Questions? Suggestions? Bugs? Giggles? Please feel free to let me know!
Dance.
Profile Blog Joined July 2010
United States389 Posts
August 26 2010 06:15 GMT
#2
Looks good! Thanks for sharing this
It is what it is...
xelgand
Profile Joined August 2010
Spain5 Posts
August 26 2010 07:09 GMT
#3
It's nice.
I would suggest you to upload it to gDocs and publish it so anyone can use it without having to download it.
Zombies are a dead end for evolution.
Birkses
Profile Joined August 2010
Australia24 Posts
August 26 2010 08:34 GMT
#4
Looks useful
paul415
Profile Joined August 2010
United States25 Posts
August 26 2010 19:17 GMT
#5
On August 26 2010 16:09 xelgand wrote:
It's nice.
I would suggest you to upload it to gDocs and publish it so anyone can use it without having to download it.


Done.

I also updated it to v6.
MangoTango
Profile Blog Joined June 2010
United States3670 Posts
Last Edited: 2010-08-26 19:21:06
August 26 2010 19:20 GMT
#6
For those with older versions of XLS, use the Compatibility pack: http://office.microsoft.com/en-us/support/microsoft-office-compatibility-pack-for-word-excel-and-powerpoint-2007-file-formats-HA010168676.aspx
"One fish, two fish, red fish, BLUE TANK!" - Artosis
Al Bundy
Profile Joined April 2010
7257 Posts
August 26 2010 19:25 GMT
#7
Very interesting. Day[9] was talking about that in one of his most recents dailies. Thank you very much
o choro é livre
FreezerJumps
Profile Joined May 2010
Canada653 Posts
August 26 2010 19:28 GMT
#8
Nice, apparently DTs can kill banshees in 4 hits. Now we know.
ta2
Profile Joined July 2010
125 Posts
August 26 2010 19:36 GMT
#9
Very cool. Are the numbers for carriers correct, though? According to the spreadsheet in the DPS page they do twice as much as a BC.
SuperDrols
Profile Joined August 2010
4 Posts
August 26 2010 19:38 GMT
#10
On August 27 2010 04:28 FreezerJumps wrote:
Nice, apparently DTs can kill banshees in 4 hits. Now we know.

that changes the whole game up
For the Swarm
Carl_Sagan
Profile Joined March 2010
United States226 Posts
August 26 2010 19:41 GMT
#11
It takes 89 banelings to kill a planetary fortress? Either I'm reading it wrong, or....
Zeak
Profile Joined August 2010
United States19 Posts
August 26 2010 20:01 GMT
#12
On August 27 2010 04:38 SuperDrols wrote:
Show nested quote +
On August 27 2010 04:28 FreezerJumps wrote:
Nice, apparently DTs can kill banshees in 4 hits. Now we know.

that changes the whole game up


Same with Banelings. Damn, why didn't I do this earlier?!

lol...it's interesting to know, but maybe modify it to point out when one unit actually can't attack another? No biggie though...except for the people unaware that banelings and dt's and such can't fly...
Don't worry about it =D
Spyridon
Profile Joined April 2010
United States997 Posts
Last Edited: 2010-08-26 20:23:29
August 26 2010 20:10 GMT
#13
I dont have excel and it doesnt seem the downloadable excel viewer, or the online viewer lets you change the upgrade levels..

Is there any workaround for this?
Iggyhopper
Profile Joined July 2010
United States259 Posts
August 26 2010 21:27 GMT
#14
Nice job!
paul415
Profile Joined August 2010
United States25 Posts
August 26 2010 21:35 GMT
#15
On August 27 2010 05:10 Spyridon wrote:
I dont have excel and it doesnt seem the downloadable excel viewer, or the online viewer lets you change the upgrade levels..

Is there any workaround for this?


The quick and easy fix would be to log into Google docs, go to file, then select Make a copy...

This will may a copy of the spreadsheet to your Google account so that you can update the upgrade levels yourself.
paul415
Profile Joined August 2010
United States25 Posts
September 21 2010 19:36 GMT
#16
Updated for Patch 1.1
Noxie
Profile Blog Joined April 2010
United States2227 Posts
September 21 2010 20:10 GMT
#17
Awesome job man, thanks for the 1.1 update fast as well!
Bumblebees
Profile Joined August 2010
United States328 Posts
September 21 2010 20:34 GMT
#18
It takes 275 attacks for a zergling to kill a battlecruiser.

You learn something new every day.
caneras
Profile Blog Joined August 2010
433 Posts
September 22 2010 02:08 GMT
#19
This is awesome! I wish there was some sort of simulator that could figure out how many of unit A it would take to kill however many of unit B. But hey, this is still so helpful.
panther1389
Profile Joined April 2010
United States42 Posts
September 22 2010 05:15 GMT
#20
On September 22 2010 11:08 caneras wrote:
This is awesome! I wish there was some sort of simulator that could figure out how many of unit A it would take to kill however many of unit B. But hey, this is still so helpful.

well actually there is....i present to you......the unit tester. i'm too lazy to look for a link but just look it up and download it...it's super handy.
paul415
Profile Joined August 2010
United States25 Posts
October 14 2010 21:14 GMT
#21
Updated for Patch 1.1.2
paul415
Profile Joined August 2010
United States25 Posts
January 25 2011 23:12 GMT
#22
I received a PM request to update this to the latest 1.2.0 patch.

Done.

p.s. To be honest, I didn't think people were still using this spreadsheet. I was pleasantly surprised.
Normal
Please log in or register to reply.
Live Events Refresh
Next event in 8h 28m
[ Submit Event ]
Live Streams
Refresh
StarCraft 2
Nina 198
RuFF_SC2 186
NeuroSwarm 144
StarCraft: Brood War
Artosis 903
NaDa 87
Icarus 9
LuMiX 5
Dota 2
monkeys_forever635
League of Legends
febbydoto17
Counter-Strike
Stewie2K801
Super Smash Bros
hungrybox804
Heroes of the Storm
Khaldor167
Other Games
summit1g17335
JimRising 816
shahzam720
WinterStarcraft357
Maynarde205
ViBE192
Livibee60
ROOTCatZ11
Organizations
Other Games
gamesdonequick5382
StarCraft 2
Blizzard YouTube
StarCraft: Brood War
BSLTrovo
sctven
[ Show 17 non-featured ]
StarCraft 2
• Berry_CruncH354
• davetesta45
• Sammyuel 27
• gosughost_ 26
• Migwel
• AfreecaTV YouTube
• sooper7s
• intothetv
• Kozan
• IndyKCrew
• LaughNgamezSOOP
StarCraft: Brood War
• STPLYoutube
• ZZZeroYoutube
• BSLYoutube
League of Legends
• Doublelift6393
• Rush1450
Other Games
• Scarra1993
Upcoming Events
Wardi Open
8h 28m
Replay Cast
1d 7h
WardiTV European League
1d 13h
PiGosaur Monday
1d 21h
uThermal 2v2 Circuit
2 days
Replay Cast
2 days
The PondCast
3 days
Replay Cast
3 days
Epic.LAN
4 days
CranKy Ducklings
5 days
[ Show More ]
Epic.LAN
5 days
BSL20 Non-Korean Champi…
5 days
Bonyth vs Sziky
Dewalt vs Hawk
Hawk vs QiaoGege
Sziky vs Dewalt
Mihu vs Bonyth
Zhanhun vs QiaoGege
QiaoGege vs Fengzi
Sparkling Tuna Cup
6 days
Online Event
6 days
BSL20 Non-Korean Champi…
6 days
Bonyth vs Zhanhun
Dewalt vs Mihu
Hawk vs Sziky
Sziky vs QiaoGege
Mihu vs Hawk
Zhanhun vs Dewalt
Fengzi vs Bonyth
Liquipedia Results

Completed

2025 ACS Season 2: Qualifier
RSL Revival: Season 1
Murky Cup #2

Ongoing

JPL Season 2
BSL 2v2 Season 3
Copa Latinoamericana 4
Jiahua Invitational
BSL20 Non-Korean Championship
Championship of Russia 2025
BLAST.tv Austin Major 2025
ESL Impact League Season 7
IEM Dallas 2025
PGL Astana 2025
Asian Champions League '25
BLAST Rivals Spring 2025
MESA Nomadic Masters

Upcoming

CSL Xiamen Invitational
CSL Xiamen Invitational: ShowMatche
2025 ACS Season 2
CSLPRO Last Chance 2025
CSLPRO Chat StarLAN 3
BSL Season 21
K-Championship
RSL Revival: Season 2
SEL Season 2 Championship
uThermal 2v2 Main Event
FEL Cracov 2025
Esports World Cup 2025
Underdog Cup #2
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
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.