Spell Draft Format Spreadsheet

Go down

Spell Draft Format Spreadsheet

Post by pg.ski_anderson on March 10th 2014, 9:48 am

Since Privateer Press has published the Spelldraft format, I've made a Google Docs spreadsheet for card generation.  It doesn't have all the spells populated, but you can see the functionality and I've been using it to gen cards with no problems.

If anyone wants to help add data to the spreadsheet, let me know and I'll grant you write access.

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

The way you use the Pack Generator sheet:
1.  We need to force Google to generate a new list of random numbers.  What I do is select the top most current random number (cell B4) and highlight the other random number cells.  I then Fill Down (control-D).  It will gen new numbers.

2.  Highlight the new random numbers.  Copy them.  Go to cell D4 under the word "Pack".  Paste Special (not just normal Paste!) and choose to paste the values.  The spell names should change.

3.  Look at the Cards page.  Any of the random spells that doesn't has data can be modified in the first tab.

Scott

pg.ski_anderson

Posts : 11
Join date : 2014-03-10
Age : 43
Location : Cincinnati, OH

http://c-o-g-s.blogspot.com/

Back to top Go down

Re: Spell Draft Format Spreadsheet

Post by eChad on March 10th 2014, 10:30 am

The easiest way to force the random numbers to refresh is to highlight cell B4, and press CTRL-R.

However, neither method work unless you have the rights to edit the document, since you're actually changing values.

So if anyone wants to do this, you'll need to first make a copy of the spreadsheet.

eChad

Posts : 70
Join date : 2014-03-10

Back to top Go down

Re: Spell Draft Format Spreadsheet

Post by milothewise on March 10th 2014, 11:16 am

Scott, I'd be happy to fill in spell info instead of doing my homework. You can share it to nick.a.andrews@gmail.com if you're so inclined. 

Has anyone figured out how to do this without duplicating cards? Alternatively, we could just print them ALL, but that sounds awful.
avatar
milothewise

Posts : 106
Join date : 2014-03-10

Back to top Go down

Re: Spell Draft Format Spreadsheet

Post by pg.ski_anderson on March 10th 2014, 11:37 am

I've been trying to track down how other games do fake online drafts for Magic and other games.  There has to be some algorithm that could be used to determine packs (usually based on rarity, but we can strip that).

Of course I could also implement a simple counter for each card somehow.  If a card gets generated for a pack, a counter would increment and that number would be less likely to come up in the future.

I'd probably have to refresh my Visual Basis knowledge to do that though, and that's effort.

I'll add you as an editor, Nick.

pg.ski_anderson

Posts : 11
Join date : 2014-03-10
Age : 43
Location : Cincinnati, OH

http://c-o-g-s.blogspot.com/

Back to top Go down

Re: Spell Draft Format Spreadsheet

Post by milothewise on March 11th 2014, 10:30 am

Cryx spells are all in.
avatar
milothewise

Posts : 106
Join date : 2014-03-10

Back to top Go down

Re: Spell Draft Format Spreadsheet

Post by eChad on March 11th 2014, 10:40 am

I would do Troll spells if you want.

eChad

Posts : 70
Join date : 2014-03-10

Back to top Go down

Re: Spell Draft Format Spreadsheet

Post by DanS on March 11th 2014, 11:04 am

Smilekdan@gmail.com to share if you want me to do Khador...and others.
avatar
DanS

Posts : 105
Join date : 2014-03-10
Age : 36
Location : Right Behind You!

Back to top Go down

Re: Spell Draft Format Spreadsheet

Post by pg.ski_anderson on March 11th 2014, 1:17 pm

Here is something that was just shared with me:

https://docs.google.com/spreadsheets/d/1W97WYnXJCL6qjW8yJ5-D1DQA7v0cV8jZw03wN7ubeQk/edit?usp=sharing

It contains all the spells and the data.  However, it's not the format that I was using.  I'm not sure if it's better to take that data and re-format it for our spreadsheet... or make a new random pack generator using that data as it stands.

pg.ski_anderson

Posts : 11
Join date : 2014-03-10
Age : 43
Location : Cincinnati, OH

http://c-o-g-s.blogspot.com/

Back to top Go down

Re: Spell Draft Format Spreadsheet

Post by milothewise on March 11th 2014, 2:45 pm

It'll take longer to reformat this one than it will to add spell information to yours, I think. And it needs reformatting - aside from looking up spells, this wouldn't do us much good as is.
avatar
milothewise

Posts : 106
Join date : 2014-03-10

Back to top Go down

Re: Spell Draft Format Spreadsheet

Post by eChad on March 12th 2014, 10:28 am

Does it need reformatting?  The columns are all in the same order.  Just need to add a column for # for the vlookups to work, and add animi.

The only other thing it's missing is the column that says who has the spell, but we don't really need that if we don't need to look up the spells anyway.

eChad

Posts : 70
Join date : 2014-03-10

Back to top Go down

Re: Spell Draft Format Spreadsheet

Post by milothewise on March 12th 2014, 10:40 am

I just meant that printing it out as is would give you 1" strips of paper, which are less good than 3x4 cards.
avatar
milothewise

Posts : 106
Join date : 2014-03-10

Back to top Go down

Re: Spell Draft Format Spreadsheet

Post by eChad on March 12th 2014, 10:42 am

That what the Cards tab is for that Scott made.  You have one tab that is just data, then another tab that has the formatting of the cards.  One more tab does the random calculations, and the cards tab uses vlookups with those numbers to pull the spell data and put it in a card format.

eChad

Posts : 70
Join date : 2014-03-10

Back to top Go down

Re: Spell Draft Format Spreadsheet

Post by eChad on March 12th 2014, 11:02 am

In fact, I'm going to have this done within an hour.  We'll just need to fill in the animus information and we'll be done.

Will post here when it's ready.

eChad

Posts : 70
Join date : 2014-03-10

Back to top Go down

Re: Spell Draft Format Spreadsheet

Post by pg.ski_anderson on March 12th 2014, 11:33 am

Then all we need is someone to run an event.

pg.ski_anderson

Posts : 11
Join date : 2014-03-10
Age : 43
Location : Cincinnati, OH

http://c-o-g-s.blogspot.com/

Back to top Go down

Re: Spell Draft Format Spreadsheet

Post by eChad on March 12th 2014, 11:42 am

Okay - done.

I made a completely new sheet so as not to risk ruining any work we've already done.  So you will need permissions to this new sheet to edit it.  Give me your email address if you would like for me to give permissions - either on here or a Facebook message.

https://docs.google.com/spreadsheets/d/1R1HUD1iP92k0cZ7QaXk1swVEu0TZVDFsGC3zrXT6jVI/edit?usp=sharing

Still missing some spells.  All of the spells that need information populated are at the bottom and highlighted in yellow.

They currently are:
Blinding LightIssyria
Blood ThornBethayne
Coercer ProtectorAfflictor
Disruption FieldNemo1
FlagellationAmon
HarvestMorvahna1
Hot ShotSyntherion, Bart
Impending DoomButcher3
Irresistable ForceRiphorn
Lightning TendrilsKrueger1
Manifest DestinyThagrosh2
Mosh PitBorka
Murder of CrowsOld Witch
Nonokrion BrandFiona
PhantasmShae
Playing GodAbyslonia
RedlineDurgen
RegrowthMorvahna1
RestorationMorvahna1
Roots of the EarthBaldur2
Sands of FateMohsar
SentryStrakhov
Soul SlaveHexeris1
Spirit DoorKaya1
Star-CrossedCalandra
SunburstBlaize
Swamp PitBarnabas
Telgesh MarkFiona
Temporal BarrierNemo1
True PathVindictus, Aurora
Wind BlastVlad2, Grayle

eChad

Posts : 70
Join date : 2014-03-10

Back to top Go down

Re: Spell Draft Format Spreadsheet

Post by eChad on March 12th 2014, 11:50 am

As for the event... We could draft online and then meet up for games.  I wouldn't mind facilitating.

I'll make a post to get a list of commitments later.

eChad

Posts : 70
Join date : 2014-03-10

Back to top Go down

Re: Spell Draft Format Spreadsheet

Post by eChad on March 12th 2014, 12:12 pm

Also need to know if the following are animi or spells:

Bear Hands
Coerced Protector
Despoiler
Haunting Melody
Irresistible Force
Pig Farm
Pigpen
Serpent Strike
Spirit Shift
Stonehold
Submerge

eChad

Posts : 70
Join date : 2014-03-10

Back to top Go down

Re: Spell Draft Format Spreadsheet

Post by DanS on March 12th 2014, 3:12 pm

Stonehold:  Spell ~ Brun Cragback
Bear Hands: Animus ~ Lug
Haunting Melody : Spell ~ Dahlia Hallyr
Mist Walker: Spell ~ Dahlia Hallyr
Serpent Strike : Animus ~ Skarath
Pigpen: Spell ~ Rorsh
Pig Farm: Animus ~ Brine
Submerge: Animus ~ Snapjaw
avatar
DanS

Posts : 105
Join date : 2014-03-10
Age : 36
Location : Right Behind You!

Back to top Go down

Re: Spell Draft Format Spreadsheet

Post by eChad on March 12th 2014, 3:27 pm

Updated!  Weird - I didn't have Mist Walker in the list at all.

eChad

Posts : 70
Join date : 2014-03-10

Back to top Go down

Re: Spell Draft Format Spreadsheet

Post by Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum