Usa Forum - TWD Australian 2010 LCQ Report - rec.games.trading-cards.jyhad

SteveHarris

6/15/2010 5:39:00 AM

Australian 2010 Last Chance Qualifier
Prince of Wales Hotel, Nundah, Brisbane, Australia
June 12, 2010
15 players
3R + Finals

Nick Miller
weenie animalism combat w/ Nana Buruku

Crypt [12 vampires]
------------------------------------------------------------

4x Nana Buruku 8 ANI POT PRE Guruhi:4
2x Stick 3 ANI !Nosferatu:4
1x Beetleman 4 ANI obf Nosferatu:4
1x Bobby Lemon 4 ANI pro Gangrel:3
1x Clarissa Steinburg 3 ani obf Nosferatu:3
1x Mouse 2 ani Nosferatu:3
1x Zip 2 ani Ravnos:3
1x Lisa Noble 1 ani Caitiff:3

Library [66 cards]
------------------------------------------------------------

Action [10]
1x Aranthebes, The Immortal
1x Army of Rats
8x Deep Song

Action Modifier [1]
1x Strange Day

Ally [1]
1x Carlton Van Wyk (Hunter)

Combat [20]
8x Aid from Bats
1x Canine Horde
6x Carrion Crows
2x High Ground
3x Taste of Vitae

Equipment [2]
1x IR Goggles
1x Laptop Computer

Master [23]
2x Animalism
1x Archon Investigation
6x Ashur Tablets
2x Dreams of the Sphinx
2x Fame
1x Giant's Blood
1x Haven Uncovered
2x Life in the City
1x Powerbase: Montreal
1x Sermon of Caine
1x Slum Hunting Ground
2x Tribute to the Master
1x Wider View

Reaction [7]
2x Delaying Tactics
3x Lost in Translation
2x On the Qui Vive

Retainer [2]
1x J. S. Simmons, Esq.
1x Tasha Morgan

It was a long and hard fought day with several time outs as the day
went by. The finals table saw Nick Miller (ANI ashur tablets) ->
Maile Walker (weenie for undead persistence) -> Matthew Prescott
(Baron possession turbo) -> Glenn Tyler (Blood Brothers rush/bloat) ->
Tim Smith (Lasombra bruise and bleed).

Right from the word go, the entire table was working against the turbo
deck, and no one really wanted to see it get up and running. Maile's
deck runs hard and fast, and only really goes in one direction -
forwards. It didn't take long before she had ousted both the turbo
deck and the blood brother's deck.

Nick had been wearing Maile down and could survive her combat by
pressing to end. Maile kept going forwards and wore down the Lasombra
deck. Then a well placed Fame rush on Maile meant she was ousted soon
after. By then Nick had enough momentum to keep going fowards and
eventually ousted Tim.

Congratulations to Nick for his victory!

11 Answers

JLGWhiz

3/17/2009 3:16:00 AM

There was nothing wrong with the first procedure that you posted, ecept the
line for the variable myRange. After reading your post again, it looks like
what you want to use is:

Set myRange = ActiveSheet.Range("b2:b" & rFound.Row)
myRange.EntireRow.Delete

This will delete rows 2 through the found row.

"Little Penny" wrote:

> Thank for yor reply. I tried the chages but it does not work. So I
> started over. I got the macro to find the value and select the the
> entire row above. How can i select all row up to row 2.
>
>
> Cells.Find(What:="Ground", After:=ActiveCell, LookIn:=xlValues, _
> LookAt:=xlWhole, SearchOrder:=xlByRows,
> SearchDirection:=xlNext, _
> MatchCase:=False, SearchFormat:=False).Activate
>
> ActiveCell.Offset(-1, 0).Select
>
> Selection.EntireRow.Select
>
>
> I need to select up to row 2
>
>
>
> Thanks
>
> On Mon, 16 Mar 2009 19:47:01 -0700, JLGWhiz
> <JLGWhiz@discussions.microsoft.com> wrote:
>
> >Hi Little Penny, did you not want this:
> >
> >Set myRange = ActiveSheet.Range("b" & rFound.Row _
> > & ":f" & myLastRow)
> >
> >to be more like this?:
> >
> >Set myRange = ActiveSheet.Range("b" & rFound.Row _
> > & ":f" & rFound.Row)
> >
> >
> >"Little Penny" wrote:
> >
> >> I want to find a value in colum "B" and delete all row above except
> >> the first row.
> >>
> >> I tried to adapt the code below without success.
> >>
> >>
> >>
> >> Option Explicit
> >>
> >> Sub delete_row_and_below()
> >>
> >> Dim rFound As Range
> >> Dim myRange As Range
> >> Dim myLastRow As Long
> >> Dim sName As String
> >>
> >> myLastRow = ActiveSheet.Cells(65000, 2).End(xlUp).Row
> >> Set myRange = ActiveSheet.Range("B1:B" & myLastRow)
> >> sName = "LI-HANDTMG"
> >>
> >> Set rFound = myRange.Find(What:=sName, _
> >> LookIn:=xlValues, _
> >> LookAt:=xlWhole, _
> >> MatchCase:=False)
> >>
> >> If rFound Is Nothing Then
> >> MsgBox sName & " was not found in Range."
> >> Else
> >> Set myRange = ActiveSheet.Range("b" & rFound.Row _
> >> & ":f" & myLastRow)
> >> myRange.EntireRow.Delete
> >> End If
> >>
> >>
> >> End Sub
> >>
> >>
> >>
> >> Thanks Little Penny
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
>

Little Penny

3/17/2009 3:54:00 AM

That worked

Thanks

On Mon, 16 Mar 2009 20:16:01 -0700, JLGWhiz
<JLGWhiz@discussions.microsoft.com> wrote:

>There was nothing wrong with the first procedure that you posted, ecept the
>line for the variable myRange. After reading your post again, it looks like
>what you want to use is:
>
>Set myRange = ActiveSheet.Range("b2:b" & rFound.Row)
>myRange.EntireRow.Delete
>
>This will delete rows 2 through the found row.
>
>
>"Little Penny" wrote:
>
>> Thank for yor reply. I tried the chages but it does not work. So I
>> started over. I got the macro to find the value and select the the
>> entire row above. How can i select all row up to row 2.
>>
>>
>> Cells.Find(What:="Ground", After:=ActiveCell, LookIn:=xlValues, _
>> LookAt:=xlWhole, SearchOrder:=xlByRows,
>> SearchDirection:=xlNext, _
>> MatchCase:=False, SearchFormat:=False).Activate
>>
>> ActiveCell.Offset(-1, 0).Select
>>
>> Selection.EntireRow.Select
>>
>>
>> I need to select up to row 2
>>
>>
>>
>> Thanks
>>
>> On Mon, 16 Mar 2009 19:47:01 -0700, JLGWhiz
>> <JLGWhiz@discussions.microsoft.com> wrote:
>>
>> >Hi Little Penny, did you not want this:
>> >
>> >Set myRange = ActiveSheet.Range("b" & rFound.Row _
>> > & ":f" & myLastRow)
>> >
>> >to be more like this?:
>> >
>> >Set myRange = ActiveSheet.Range("b" & rFound.Row _
>> > & ":f" & rFound.Row)
>> >
>> >
>> >"Little Penny" wrote:
>> >
>> >> I want to find a value in colum "B" and delete all row above except
>> >> the first row.
>> >>
>> >> I tried to adapt the code below without success.
>> >>
>> >>
>> >>
>> >> Option Explicit
>> >>
>> >> Sub delete_row_and_below()
>> >>
>> >> Dim rFound As Range
>> >> Dim myRange As Range
>> >> Dim myLastRow As Long
>> >> Dim sName As String
>> >>
>> >> myLastRow = ActiveSheet.Cells(65000, 2).End(xlUp).Row
>> >> Set myRange = ActiveSheet.Range("B1:B" & myLastRow)
>> >> sName = "LI-HANDTMG"
>> >>
>> >> Set rFound = myRange.Find(What:=sName, _
>> >> LookIn:=xlValues, _
>> >> LookAt:=xlWhole, _
>> >> MatchCase:=False)
>> >>
>> >> If rFound Is Nothing Then
>> >> MsgBox sName & " was not found in Range."
>> >> Else
>> >> Set myRange = ActiveSheet.Range("b" & rFound.Row _
>> >> & ":f" & myLastRow)
>> >> myRange.EntireRow.Delete
>> >> End If
>> >>
>> >>
>> >> End Sub
>> >>
>> >>
>> >>
>> >> Thanks Little Penny
>> >>
>> >>
>> >>
>> >>
>> >>
>> >>
>> >>
>> >>
>>

Kevin M.

6/15/2010 5:50:00 AM

SteveHarris wrote:
> It was a long and hard fought day with several time outs as the day
> went by. The finals table saw Nick Miller (ANI ashur tablets) ->
> Maile Walker (weenie for undead persistence) -> Matthew Prescott
> (Baron possession turbo) -> Glenn Tyler (Blood Brothers rush/bloat) ->
> Tim Smith (Lasombra bruise and bleed).

Any chance we can see the Baron possession deck?

Kevin M., Prince of Las Vegas
"Know your enemy and know yourself; in one-thousand battles
you shall never be in peril." -- Sun Tzu, *The Art of War*
"Contentment...Complacency...Catastrophe!" -- Joseph Chevalier
Please visit VTESville daily! http://vtesville.mymin...
Please bid on my auctions! http://shop.ebay.com/kjmer...

SteveHarris

6/15/2010 6:16:00 AM

> Any chance we can see the Baron possession deck?

Deck Name: Baron Turbo
Created By: Matt Prescott
Description:

Crypt: (15 cards, Min: 22, Max: 33, Avg: 6.93)
----------------------------------------------
1 Baron dom FOR NEC OBF THN9 Samedi
1 Agaitas AUS for NEC 6 Harbingers
of Skulls
1 Anisa Marianna Lopez aus FOR NEC QUI8 Harbingers
of Skulls
1 Bartholomew AUS dom MYT NEC obt8 Kiasyd
1 Carlotta Giovanni dom NEC obf POT7 Giovanni
1 Egothha AUS FOR NEC obf7 Harbingers
of Skulls
1 Enzo Giovanni ani DOM NEC pot tha8 Giovanni
1 Gillespi Giovanni aus DOM NEC POT7 Giovanni
1 Gisela Harden aus dem FOR NEC7 Harbingers
of Skulls
1 Isabel Giovanni DOM NEC pot 5 Giovanni
1 Kanimana Belghazi AUS DOM NEC pro7 Nagaraja
1 Le Dinh Tho aus dom NEC 5 Nagaraja
1 Mina Grotius cel FOR NEC 6 Harbingers
of Skulls
1 Pochtli cel dom NEC OBF POT8 Giovanni
1 Rafaele Giovanni cel NEC obf 6 Giovanni

Library: (64 cards)
-------------------
Master (21 cards)
6 Coroner`s Contact
1 Creepshow Casino
1 Dreams of the Sphinx
1 Barrens, The
1 Sudden Reversal
5 Villein
6 Vast Wealth

Action (16 cards)
8 Possession
8 Force of Will

Action Modifier (16 cards)
5 Call of the Hungry Dead
8 Daring the Dawn
4 Spying Mission

Equipment (1 cards)
1 Soul Gem of Etrius

Combo (9 cards)
2 Murmur of the False Will
7 Spectral Divination

SteveHarris

6/15/2010 6:27:00 AM

On Jun 15, 4:16 pm, SteveHarris <steveharris1...@gmail.com> wrote:
> > Any chance we can see the Baron possession deck?
>
> Deck Name: Baron Turbo
> Created By: Matt Prescott

What I should probably add in here is this was Matt's first standard
tournament he ever attended. Well done, I say!

Steve Harris
Prince of Brisbane

Shade

6/15/2010 10:51:00 AM

On Jun 15, 5:39 pm, SteveHarris <steveharris1...@gmail.com> wrote:
> Australian 2010 Last Chance Qualifier
> Prince of Wales Hotel, Nundah, Brisbane, Australia
> June 12, 2010
> 15 players
> 3R + Finals
>
> Nick Miller
> weenie animalism combat w/ Nana Buruku
>
> Congratulations to Nick for his victory!

Congrats Nick - didn't manage to see your desk on the day but like the
look of it.

Simon

Rehlow

6/15/2010 6:25:00 PM

On Jun 15, 1:16 am, SteveHarris <steveharris1...@gmail.com> wrote:
> > Any chance we can see the Baron possession deck?
>
> Deck Name: Baron Turbo
> Created By: Matt Prescott
> Description:
>
> Crypt: (15 cards, Min: 22, Max: 33, Avg: 6.93)
> ----------------------------------------------
> 1 Baron dom FOR NEC OBF THN9 Samedi
> 1 Agaitas AUS for NEC 6 Harbingers
> of Skulls
> 1 Anisa Marianna Lopez aus FOR NEC QUI8 Harbingers
> of Skulls
> 1 Bartholomew AUS dom MYT NEC obt8 Kiasyd
> 1 Carlotta Giovanni dom NEC obf POT7 Giovanni
> 1 Egothha AUS FOR NEC obf7 Harbingers
> of Skulls
> 1 Enzo Giovanni ani DOM NEC pot tha8 Giovanni
> 1 Gillespi Giovanni aus DOM NEC POT7 Giovanni
> 1 Gisela Harden aus dem FOR NEC7 Harbingers
> of Skulls
> 1 Isabel Giovanni DOM NEC pot 5 Giovanni
> 1 Kanimana Belghazi AUS DOM NEC pro7 Nagaraja
> 1 Le Dinh Tho aus dom NEC 5 Nagaraja
> 1 Mina Grotius cel FOR NEC 6 Harbingers
> of Skulls
> 1 Pochtli cel dom NEC OBF POT8 Giovanni
> 1 Rafaele Giovanni cel NEC obf 6 Giovanni
>
> Library: (64 cards)
> -------------------
> Master (21 cards)
> 6 Coroner`s Contact
> 1 Creepshow Casino
> 1 Dreams of the Sphinx
> 1 Barrens, The
> 1 Sudden Reversal
> 5 Villein
> 6 Vast Wealth
>

One third of the deck is masters. Surprised it doesn't jam up during
the turbo all the time. Even with Villein as trifles, they are dead
cards during the minion phase.

> Action (16 cards)
> 8 Possession
> 8 Force of Will
>

Surprised to see only 8 Possessions and a greater than 12 card crypt.

> Action Modifier (16 cards)
> 5 Call of the Hungry Dead
> 8 Daring the Dawn
> 4 Spying Mission
>
> Equipment (1 cards)
> 1 Soul Gem of Etrius
>
> Combo (9 cards)
> 2 Murmur of the False Will
> 7 Spectral Divination

Always happy to see Turbo Baron decks do well. Maybe it'll win next
time. Good luck.

Later,
~Rehlow

Nick M

6/16/2010 12:09:00 AM

On Jun 15, 8:51 pm, Shade <shad...@gmail.com> wrote:
> On Jun 15, 5:39 pm, SteveHarris <steveharris1...@gmail.com> wrote:
>
> > Australian 2010 Last Chance Qualifier
> > Prince of Wales Hotel, Nundah, Brisbane, Australia
> > June 12, 2010
> > 15 players
> > 3R + Finals
>
> > Nick Miller
> > weenie animalism combat w/ Nana Buruku
>
> > Congratulations to Nick for his victory!
>
> Congrats Nick - didn't manage to see your desk on the day but like the
> look of it.
>
> Simon

thanks Simon. I have played the deck for a while. It is solid. Just
didn't know how many Delaying Tactics to add on the day. Turned out
there were no vote decks and I discarded the DT's every time.

Nick

Alf

6/16/2010 7:44:00 AM

On 15 Jun., 20:24, Rehlow <newsgr...@rehlow.com> wrote:

> > Action (16 cards)
> > 8 Possession
> > 8 Force of Will
>
> Surprised to see only 8 Possessions and a greater than 12 card crypt.

Carlotta's special might help at some point, but a smaller crypt would
support a greater chance to get her out.

> > Equipment (1 cards)
> > 1 Soul Gem of Etrius

If the Gem is in your starting hand you have 1 shot at it (barring
Carlotta again) and Vast Wealth becomes worthless. Did you try playing
2 of these or was it never an issue?

> Always happy to see Turbo Baron decks do well.

Yeah, me too.

Cheers,
Alf

nebis

6/17/2010 8:23:00 AM

It is a bit master heavy, but the Coroners Contract/Vast Wealth/
Villein combo are needed to get out the Baron, with the soul gem, on 1
blood. If you don't get them early, the whole deck takes too long to
wind up. The Creepshow and Sudden were last minute additions after
suffering to intercept locations at the LCQ (and used to good effect
in the first game of the day). Barrens and Dreams are there to cycle
out the masters once your done setting up.

Possession/Spectral Divination, then Daring the dawn/Force of will is
the combo. Even numbers of the cards and 8 seemed about right for a
60(ish) card deck.

I had 2 soul gems in the LCQ but went to 1 for the Nats to make some
room for Creepshow and Sudden Reversal. It's back in again now after
nearly losing it in round 2.

All up, it was a bit clunky, realistically doing the turbo combo 2 or
3 times before stalling as you madly cycle for the card that will get
you going again. Still, I don't think that bleeding for 8+ per turn
was too shabby for my first crack at a standard tournament.
Appreciate the feedback, I'll pull the crypt back to 12, take out a
few masters and put in "the combo" 1 or 2 more times.

Always learning :)

Matt

rec.games.trading-cards.jyhad

TWD Australian 2010 LCQ Report

SteveHarris

JLGWhiz

Little Penny

Kevin M.

SteveHarris

SteveHarris

Shade

Rehlow

Nick M

Alf

nebis

x Login to ForumsZone