TTC - Thoughts on BTT Draft

Discuss our latest podcast about Magic: The Gathering.
User avatar
Scrumpmonkey
Posts: 4
Joined: 27 Sep 2013, 13:57
First Video: Informational Presentation

Re: TTC - Thoughts on BTT Draft

Postby Scrumpmonkey » 03 Apr 2014, 10:05

Behold the Mighty Final Boss of Microsoft Excel 2010!

Image

Had to be Eldrazi because then i could search it up/ cast if for less with my Eye of Ugin :P
Image
Qegixar
Posts: 2
Joined: 28 Mar 2014, 20:19
First Video: Friday Nights - Rotation

Re: TTC - Thoughts on BTT Draft

Postby Qegixar » 03 Apr 2014, 18:17

undecided44 wrote:
sorry to be explaining the joke here, but are you sure you'll get what you want from your formula? The different argument order between the old =sumif(...) and the new =sumifs(...) is making me wonder about your intent...

sumif([criteria] range, criteria, [sum range]) would give you power equal to the sum of the power of all creatures not named $VI$65536,
while sumifs(sum range, criteria range 1, criteria 1, [criteria range 2], [criteria 2],...) would give you 0 because the text cells in the range Creature:Name count for 0 in the sum

the way you have it is funnier, but much less of a challenge


You are absolutely right! I initially was using SUMIFS, but the formula was to long, so I changed it, but I must have forgotten to cut the 'S' off of the formula name.
ineon
Posts: 5
Joined: 04 Apr 2014, 02:12
First Video: I've got the money have you got the stuf

Re: TTC - Thoughts on BTT Draft

Postby ineon » 04 Apr 2014, 02:23

Title: Excel
Casting Cost: GGG6
Type: Exponential Creature
P/T: 1/65536
Rules text: Hexproof, Vigalance, Cannot be sacrificed, Excel must block if able.
Whenever Excel gains trample it immediately looses trample.
For every Dickbutt creature token on the battlefield halve Excels toughness.
For every Dickbutt creature token on the battlefield double Excels power.
You cannot loose while Excel is on the battlefield, nor can your opponent win.
If Excel ever leave the battlefield then you immediately loose.

----------------------

Strategy to beat it: You have to create sufficiently many Dickbutt creature tokens to lower its toughness to enough to beat it in combat. All the while you are pumping its power.
CommiePuddin
Posts: 14
Joined: 28 Feb 2014, 11:05
First Video: Friday Nights: Untap

Re: TTC - Thoughts on BTT Draft

Postby CommiePuddin » 04 Apr 2014, 09:53

Too much text!

Clippy, Office Assistant
6

Legendary Artifact Creature - Cleric

Shroud

Any time an opponent casts a spell or activates an ability, you may play Clippy, Office Assistant from your hand without paying its mana cost.

Players cannot cast spells or activate abilities as long as Clippy, Office Assistant is on the battlefield.

{4}: Return Clippy, Office Assistant to its owner's hand. Any player may activate this ability.

"It looks like you're trying to summon a Giant!"

2/3
User avatar
WP&P
Posts: 132
Joined: 29 Mar 2014, 19:00
First Video: Friday Nights
Location: Ohio
Contact:

Re: TTC - Thoughts on BTT Draft

Postby WP&P » 05 Apr 2014, 05:38

Allright, I don't remember which recent video it was that featured Kathleen doing a decent Stig intro, so I'm just gonna post this here. Also, I like Clippy (above) or rather I really don't like Clippy, but I can say that if he is the boss, I *have* beaten him.

"Some say,
His Chromanticore modern deck still features four-of Gray Merchant,
and he is never hurt by playing a shock land untapped!
All we know is,
He's called The Stig."
What do model railroading and Magic: The Gathering have in common?
I don't have enough time or money for either!

http://wpandp.com/Home/the-rest/borderlands-a-custom-mtg-set/eclipse-an-expansion-for-borderlands/
Vantar
Posts: 2
Joined: 28 Jan 2011, 19:03
First Video: Pictodicks

Re: TTC - Thoughts on BTT Draft

Postby Vantar » 08 Apr 2014, 12:30

Final something that combines my love of M:TG, LRR and Excel
I am a Microsoft Office Specialist exam proctor. Proof:
Click to Expand
Image

Part of that job includes training people for the Microsoft Office World Championships
The macros section of the exam is one of the parts that I see the most people struggle with. To that end I created:
Image

also Excel already has a final boss.
Cell range X97:L97 - selecting this range and running the chart wizard in Excel 97 would open a flight sim where you could unlock the developer credits
undecided44
Posts: 19
Joined: 06 May 2009, 10:23

Re: TTC - Thoughts on BTT Draft

Postby undecided44 » 08 Apr 2014, 20:24

Vantar wrote:-snip-
Final something that combines my love of M:TG, LRR and Excel
I am a Microsoft Office Specialist exam proctor.
-snip-


Way way way off topic, but Vantar I have an design requirement you could probably help me address, or at least point me toward a decent resource, can I PM with a professional question?
building on Uno's Minecraft server as ff4ede (pronounced as an exaggerated version of forty).
Vantar
Posts: 2
Joined: 28 Jan 2011, 19:03
First Video: Pictodicks

Re: TTC - Thoughts on BTT Draft

Postby Vantar » 09 Apr 2014, 06:01

undecided44 wrote:Way way way off topic, but Vantar I have an design requirement you could probably help me address, or at least point me toward a decent resource, can I PM with a professional question?


Of course, I will watch my inbox

Return to “TapTapConcede”



Who is online

Users browsing this forum: No registered users and 3 guests