***Updated Information In A Later Post***

I sat down and compared every Ice in the Game to every Ice Breaker in the game. I made some observations:

- There are 8 Sentries, 5 Barriers and Code gates, and 1 "None of the Above"; Namely, Data Mine. NBN Doesn't have any Barriers, but Weyland Consortium doesn't have any Code Gates.

- The highest number of Subroutines on a Sentry is 4 (Archer) (Average 1.875). The highest Strength on a Sentry is 6 (also Archer) (Average 3.125). Both Femme Fatale and Ninja will break Sentries at an average cost of 4.875 Credits.

- The highest number of Subroutines on a Barrier is 3 (Heimdall 1.0) (Average 1.8). The highest Strength on a Barrier is 7 (Hadrian's Wall) (Average 4.4). Note that while Battering Ram is slightly cheaper on average than Corroder, it costs 2MU, which is hefty.

- The highest number of Subroutines on a Code Gate is 2 (Enigma and Viktor 1.0) (Average 1.4). The highest Strength on a Code Gate is 7 (Cell Portal) (Average 4.2). Gordian Blade is the obvious choice here.

Note that this doesn't take into consideration any factors other than Subroutines, Strength, and full Credit Cost to totally pass the Ice. It doesn't consider Advancing Ices, Combos (Wyrm + Mimic), Viruses, Passing Subroutines with Actions, Encounter Abilities, or anything else. It's meant to help supplement your decision making, not necessarily make your decision for you, because there are more factors in play.

This is pretty much exactly the spreadsheet I was going to work on at work this weekend. But it's cut off. Thanks for the effort!

Just right click "View Image" and it'll show you the whole thing.

javascript:void(0);/*1349533813737*/

Well, aren't I n00by. Thank you.

That's pretty awesome. I loves me a numbers breakdown.

Any idea how The Personal Touch would affect the numbers?

Fantastic work. This is going to help with deck building a great deal.

Fantastic work. This is going to help with deck building a great deal.

Updated the list.

• Sentries cost on average 6 credits to break regardless of the Icebreaker being used.
• Ninja remains the most efficient Sentry Breaker, costing an average of 5 credits to break Sentries.
• Janus 1.0 is the expensive Ice, let alone Sentry to break in the game, currently, at an average of 16.6 credits to break.
• Barriers cost on average 5.5 credits to break. While Battering Ram is the most efficient Barrier Breaker at 3.9 credits to break Barriers, Corroder costs only 1 MU at at 4 credits average to break Barriers, remains the best Barrier Breaker.
• Special mention is Morning Star, which breaks 5 of the 7 Barriers in the game for 1 credit, but can't do anything about the other 2 without support.
• Heimdall 1.0 remains the most expensive Barrier to break, at an average of 10.6 credits to break.
• Code Gates cost an average of 5 credits to break.
• Gordian Blade remains the most efficient Code Gate breaker, at an average of 3.6 credits to break Code Gates.
• Cell Portal remains the most expensive Code Gate to break, at an average of 8.6 credits to break.

sexy update, thank you

Thank you, Frosty! You have given me a mental boner…

Frosty, maybe you should also post some graphs so we can see trends in how much each icebreakers spends to do its thing.

Looking forward to Snowball, Sensi and Sherlock 1.0 being added.

Is there an updated version of this spreadsheet? I will be eternally grateful if someone can post it!

I've been keeping a spreadsheet up to date with released cards. Hope it helps!

Why is Tollbooth 4 for Atman but 2 for Darwin?

Looks like I forgot about the 3 credits you have to lose in the calculations for Darwin and Yog.0 . Nice catch!

Thanks Yithian. That's awesome!

Poor Wyrm, relegated to only being used for traps in fairness, would be horrific trying to break everything with just Wyrm. Would be interesting to see how much it would cosy to Wyrm/Mimic, Wyrm/Morningstar or Wyrm/Yog.0 on normally out of reach ICE. I know people usually use Datasucker for this, I'm just curious how much it would cost for a rich Anarch to pull off and not need Datasucker charging runs

EDIT: Never mind, just added to the sheet... it's not as horrific as you might expect.

https://docs.google.com/spreadsheet/ccc?key=0AiJWRc3yrXRGdDctUm1YV1FrM2Q5LURIcGFmWll4aXc&usp=sharing

Yeah, I just didn't see anyone using Wyrm as a general-purpose breaker haha

But for completion's sake I can add it in

Thanks for adding these in, but your numbers for Wyrmic (Wyrm/Mimic) are off - Mimic is Str 3, not 5

Edit: actually I'm not sure exactly where it's gone wrong, as my numbers for Archer are the same as yours, but you definitely can't break Ichi 2.0 for 3 creds with this combo alone.

Also, Tollbooth should be costing 9 (pump and reduce, plus mandatory 3)

Well that's embarrassing...

I've fixed the threshold for Wyrm/Mimic to be 3 instead of 5 (I copied/pasted from the Wyrm/Morning Star formula and forgot to update that part) and that corrected the costs as far as I can tell.

I can't believe I forgot the extra 3 for Tollbooth again .

Thanks Yithian, you're a star

Only one weird data point I can see now is Viktor 1.0 - it's Yoggable by itself but for some reason it's coming out at 2 creds to break with Wyrm.0. Your formulae are a little over my head (I don't really know how MAX works), or I'd offer up a solution rather than just pointing out inconsistencies ^^

Seriously though, that's a hell of a project, and thanks for doing it. Are you planning to keep this updated with each datapack?

Edit: Tried this on excel and it seemed to work for the Yog.0 row:

=IF(C2<4,0,((2*C2)-4))

The value of 4 was reached by combining the Str of Yog.0 and Wyrm, as you need to pump Wyrm to (ICE Str - 1) then reduce ICE Str to (IC Str -3). Originally the forumula was

=IF(C2<4,0,(C2-1)+(C2-3))

but the above solution seemed more elegant

For Wyrm/Morning Star it'd be

=IF(C30<6,1,((2*C30)-6)+1)

and Wyrm/Mimic would be

=IF(C37<4,D37,((2*C37)-4)+D37)

Haven't tested all the numbers yet, but it seems to work so far. Once I finally got the number of brackets right

Also, to avoid skipping Tollbooth (and in case of future unavoidable costs) you could add an extra column called 'Additional cost' which could be added to the formula (simply as a +[field] so it auto-includes whenever adding a new breaker.

It turns out that most of the entries in the Yog.0 and Wyrm + Yog.0 columns were checking a row higher than they should have been! I've gone through and made sure that every cell is using the values for the ICE of the row it's in.

As for the extra cost column, if Tollbooth remains the only piece of ICE that robs the runner like that, I'll probably just stick with the current method. If another one comes out that has a similar effect though, I'll probably build that extra functionality in to make sure that it doesn't get skipped.

I'm definitely going to be keeping the spreadsheet updated as data packs are released (or at least, as they get spoiled haha); I pull it up whenever I'm deckbuilding to get an idea of how expensive my servers will be to run or how cheaply I can break in

Thanks for all the doublechecking of my data!