• Log InLog In
  • Register
Liquid`
Team Liquid Liquipedia
EDT 18:43
CEST 00:43
KST 07:43
  • 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
[ASL19] Finals Recap: Standing Tall10HomeStory Cup 27 - Info & Preview18Classic wins Code S Season 2 (2025)16Code S RO4 & Finals Preview: herO, Rogue, Classic, GuMiho0TL Team Map Contest #5: Presented by Monster Energy6
Community News
Firefly given lifetime ban by ESIC following match-fixing investigation11$25,000 Streamerzone StarCraft Pro Series announced6Weekly Cups (June 30 - July 6): Classic Doubles6[BSL20] Non-Korean Championship 4x BSL + 4x China9Flash Announces Hiatus From ASL66
StarCraft 2
General
The SCII GOAT: A statistical Evaluation Firefly given lifetime ban by ESIC following match-fixing investigation TL Team Map Contest #4: Winners Weekly Cups (June 30 - July 6): Classic Doubles The GOAT ranking of GOAT rankings
Tourneys
$25,000 Streamerzone StarCraft Pro Series announced FEL Cracov 2025 (July 27) - $8000 live event Sparkling Tuna Cup - Weekly Open Tournament RSL: Revival, a new crowdfunded tournament series WardiTV Mondays
Strategy
How did i lose this ZvP, whats the proper response Simple Questions Simple Answers
Custom Maps
[UMS] Zillion Zerglings
External Content
Mutation # 481 Fear and Lava Mutation # 480 Moths to the Flame Mutation # 479 Worn Out Welcome Mutation # 478 Instant Karma
Brood War
General
BGH Auto Balance -> http://bghmmr.eu/ ASL20 Preliminary Maps [G] Progamer Settings [ASL19] Finals Recap: Standing Tall SC uni coach streams logging into betting site
Tourneys
[Megathread] Daily Proleagues [BSL20] Non-Korean Championship 4x BSL + 4x China [BSL20] Grand Finals - Sunday 20:00 CET CSL Xiamen International Invitational
Strategy
Simple Questions, Simple Answers I am doing this better than progamers do.
Other Games
General Games
Nintendo Switch Thread Stormgate/Frost Giant Megathread Path of Exile What do you want from future RTS games? Beyond All Reason
Dota 2
Official 'what is Dota anymore' discussion
League of Legends
Positive Thoughts on Setting Up a Dual-Caliber FX
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 Russo-Ukrainian War Thread Summer Games Done Quick 2025! Stop Killing Games - European Citizens Initiative
Fan Clubs
SKT1 Classic Fan Club! Maru Fan Club
Media & Entertainment
Anime Discussion Thread [Manga] One Piece [\m/] Heavy Metal Thread
Sports
Formula 1 Discussion 2024 - 2025 Football Thread 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
momentary artworks from des…
tankgirl
Culture Clash in Video Games…
TrAiDoS
from making sc maps to makin…
Husyelt
StarCraft improvement
iopq
Customize Sidebar...

Website Feedback

Closed Threads



Active: 579 users

Upgrade Spreadsheet - # of Attacks to Kill

Forum Index > SC2 General
Post a Reply
1 2 Next All
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.
1 2 Next All
Please log in or register to reply.
Live Events Refresh
Next event in 1h 18m
[ Submit Event ]
Live Streams
Refresh
StarCraft 2
ZombieGrub172
JuggernautJason102
ProTech78
StarCraft: Brood War
Artosis 597
NaDa 59
LuMiX 1
League of Legends
Grubby3581
Counter-Strike
Fnx 1732
taco 1517
fl0m1364
Stewie2K900
sgares95
Super Smash Bros
Liquid`Ken56
Heroes of the Storm
Khaldor139
Other Games
summit1g9622
C9.Mang0279
Maynarde126
Sick59
Organizations
Other Games
gamesdonequick49594
BasetradeTV92
StarCraft 2
Blizzard YouTube
StarCraft: Brood War
BSLTrovo
sctven
[ Show 20 non-featured ]
StarCraft 2
• HeavenSC 40
• davetesta29
• RyuSc2 23
• Kozan
• sooper7s
• Migwel
• AfreecaTV YouTube
• LaughNgamezSOOP
• intothetv
• IndyKCrew
StarCraft: Brood War
• Eskiya23 28
• STPLYoutube
• ZZZeroYoutube
• BSLYoutube
Dota 2
• masondota22599
League of Legends
• Jankos2326
• TFBlade776
Other Games
• imaqtpie1818
• Scarra771
• Shiphtur459
Upcoming Events
Replay Cast
1h 18m
RSL Revival
11h 18m
ByuN vs SHIN
Clem vs Reynor
OSC
14h 18m
Replay Cast
1d 1h
RSL Revival
1d 11h
Classic vs Cure
FEL
1d 17h
OSC
1d 21h
RSL Revival
2 days
FEL
2 days
FEL
2 days
[ Show More ]
CSO Cup
2 days
BSL20 Non-Korean Champi…
2 days
Bonyth vs QiaoGege
Dewalt vs Fengzi
Hawk vs Zhanhun
Sziky vs Mihu
Mihu vs QiaoGege
Zhanhun vs Sziky
Fengzi vs Hawk
Sparkling Tuna Cup
3 days
RSL Revival
3 days
FEL
3 days
BSL20 Non-Korean Champi…
3 days
Bonyth vs Dewalt
QiaoGege vs Dewalt
Hawk vs Bonyth
Sziky vs Fengzi
Mihu vs Zhanhun
QiaoGege vs Zhanhun
Fengzi vs Mihu
Replay Cast
5 days
Liquipedia Results

Completed

Proleague 2025-07-07
HSC XXVII
Heroes 10 EU

Ongoing

JPL Season 2
BSL 2v2 Season 3
Acropolis #3
KCM Race Survival 2025 Season 2
CSL 17: 2025 SUMMER
Copa Latinoamericana 4
Jiahua Invitational
Championship of Russia 2025
RSL Revival: Season 1
Murky Cup #2
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
CCT Season 2 Global Finals
IEM Melbourne 2025

Upcoming

2025 ACS Season 2: Qualifier
CSLPRO Last Chance 2025
CSL Xiamen Invitational
CSL Xiamen Invitational: ShowMatche
2025 ACS Season 2
CSLPRO Chat StarLAN 3
K-Championship
uThermal 2v2 Main Event
SEL Season 2 Championship
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.