With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Monday, March 23, 2015
yogi_Select Specified Number Of Card Nos and Corresponding Characters for 'X-Men Card Dice Game'
Google Spreadsheet Post #1928 Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MIwww.energyefficientbuild.com. Mar 23, 2015 question by Kaleb Captain:
I attempting to create an automated way to draft random characters in an X-Men card/dice game. You can see my headway on sheet 'RandomCharacters' where I generate a list of random characters. However, multiple characters exist for each character type (see below).
The Insect World
The Best There Is
Not Very Nice
Scent of Murder
So now on sheet 'UniqueCharacters' I am trying to constrain the list to unique character types (column B). For example, if "Angel - Air Transport" has been drafted then I want "Angel - Inspiring" as well as any other "Angel" characters to be excluded.
Current Output (undesirable duplicate characters):
Angel - Air Transport (1)
Angel - Inpiring (2)
Black Panther - Wakanda Chief (38)
Cable - Time Traveler (99)
Captain America - "Follow Me!" (69)
Captain America - Special Ops (40)
Cyclops - Optic Blast (4)
Falcon - Samuel Wilson (42)
Any help would be greatly appreciated! Be forewarned, I am much more a script kitty than a mathematician, so thanks for your patience as well.