A while ago I was searching around looking for new alter arts for making proxies in deck testing. In doing so, I found a site where they had a mass download of 1,000+ alternate art cards up to RTR or GTC. Since I have started on Cockatrice and was looking to update some of these to use the alternate art. I have been searching for a while and have been unsuccessful in locating any place that would have an updated mass download for current altered cards and was hoping someone might know a place to get such a thing.
I know there are ton's here but I was just looking for a whole set of the newest digital alters put together without having to sift through the whole thread. Any help with this would be appreciated!
A couple of questions as the playing/casting area has been a bit of a grey area in our group.
If Prototype Portal was to imprint Golem Heart then copy mutliple times would you gain life each time for the copy of golem heart for each golem heart currently in play?
Now kinda the same for door of destinies... If i was copy a myr and have door of destinies on the battlefield would each copy from prototype portal give door a destinies a counter?
Thanks Killpoo! This worked perfect for the colorless... to get the 0 if no number I just added as a sum which makes everything work as expected! Thanks again. Havent had a chance to try out the p/t yet but when I do Ill let you know. Hopefully I can finish this template out soon to share for everyone.
Heres what I changed it to just in case anyone else may be looking:
=SUM((=SPLIT(<range>;CONCATENATE(SPLIT(<range>; "0123456789")))))
I'm also looking to possibly do the same with the power and toughness (7/7) and have this split up into different cells such as the cast cost in order to manipulate that as well.
Any help on the numbers would be greatly appreciated!!!
Thank you for the responses this has been very helpful!
@Killpoo I have tried the formula and this works great but not sure what should be done for the colorless as this is only represented by numbers. Otherwise all color combinations are working perfectly.
What would I alter in order to get the colorless added?
@Mogg I was unable to get the formula to work... I might not be using/altering this correctly. Thank you for the reply though.
I have been working on building out a Google Spreadsheet to help build and keep track of my decks. In this process I have been attempting to find a way to convert the cards casting cost to a number format in adjacent cells.
I have shared an example of the conversion I'm looking to do.
I hoping to use these numbers to then run them through a simple calculation to display charts and graphs. I have searched all over and have yet to find anything that looks close to what I'm attempting.
Awesome... Mint user... this worked perfectly! THANK YOU!
I know there are ton's here but I was just looking for a whole set of the newest digital alters put together without having to sift through the whole thread. Any help with this would be appreciated!
If Prototype Portal was to imprint Golem Heart then copy mutliple times would you gain life each time for the copy of golem heart for each golem heart currently in play?
Now kinda the same for door of destinies... If i was copy a myr and have door of destinies on the battlefield would each copy from prototype portal give door a destinies a counter?
Any input would be greatly appreciated!
Deck Builder Spreadsheet:
https://docs.google.com/spreadsheet/ccc?key=0Aml8Io6FWk0ndFR0ektPVVdTejJYbUdLZmdGSGFDNHc&usp=drive_web#gid=2
This is still fairly manual but have found that using the AutoCard Anywhere Extension Has been a HUGE help in deck building and finding card prices.
AutoCard Anywhere:
https://chrome.google.com/webstore/detail/autocardanywhere/eobkhgkgoejnjaiofdmphhkemmomfabg?hl=en
Heres what I changed it to just in case anyone else may be looking:
=SUM((=SPLIT(<range>;CONCATENATE(SPLIT(<range>; "0123456789")))))
http://www.reddit.com/tb/1sfqz9
Any help on the numbers would be greatly appreciated!!!
@Killpoo I have tried the formula and this works great but not sure what should be done for the colorless as this is only represented by numbers. Otherwise all color combinations are working perfectly.
What would I alter in order to get the colorless added?
@Mogg I was unable to get the formula to work... I might not be using/altering this correctly. Thank you for the reply though.
I have shared an example of the conversion I'm looking to do.
https://docs.google.com/spreadsheet/ccc?key=0Aml8Io6FWk0ndFR0ektPVVdTejJYbUdLZmdGSGFDNHc&usp=drive_web#gid=0
I hoping to use these numbers to then run them through a simple calculation to display charts and graphs. I have searched all over and have yet to find anything that looks close to what I'm attempting.
Any help would be greatly appreciated.