c3g units still missing

[superb...@msn.com]

I put the info for the missing c3g units into the google spreadsheet for missing c3g units any they still aren't in the battleplan database.

[Jay Cain (Mythacle)]

Thanks for entering the data in the spreadsheet. I thought you were still working on it since I saw a number units with some empty fields (specifically Universe and  Planet). If you can fill those fields in I'll be sure to move the new units into the database as soon as possible.

(I apologize for the delayed response. We're in the midst of some big life changes, including packing to move to New England.)

[superb...@msn.com]

whoops! sorry about the missing fields I'll enter those as soon as possible, good luck on the move to New England!

[Jay Cain (Mythacle)]

On Tuesday, July 16, 2013 3:02:01 AM UTC-5, superb...@msn.com wrote:

whoops! sorry about the missing fields I'll enter those as soon as possible, good luck on the move to New England!

We're still en route to our new home (and it'll still be a couple more weeks), but I've been able to do some work on our C3G import script, and fed it the data from the spreadsheet. The script has a number of normalizations (e.g. spacing, capitalization) and integrity checks. These are issues it reported:

### "Black Tarantula (Carlos Lamuerto)" is missing its description for "Healer X"
### "Black Tarantula (Carlos Lamuerto)" is missing its description for "Eye Blast Special Attack"
### "Black Tarantula (Carlos Lamuerto)" is missing its description for "Close Combat Expert"
### "Black Tarantula (Carlos Lamuerto)" is missing its description for "Superstrength"
### "Bulldozer (Henry Camp)" is missing its description for "The Wrecking Crew 14"
### "Bulldozer (Henry Camp)" is missing its description for "Charging Headbutt"
### "Bulldozer (Henry Camp)" is missing its description for "Superstrength"
### "Crimson Dynamo (Gennady Gavrilov)" is missing its description for "Electrical Blast Special Attack"
### "Crimson Dynamo (Gennady Gavrilov)" is missing its description for "Armor Piercing Rocket Launcher Special Attack"
### "Crimson Dynamo (Gennady Gavrilov)" is missing its description for "Superstrength"
### "Enchantress (Amora)" is missing its description for "Enchantment"
### "Enchantress (Amora)" is missing its description for "Soul Swap"
### "Enchantress (Amora)" is missing its description for "Magical Defense"
### "Executioner (Skurge)" is missing its description for "Axe Slash Teleportation"
### "Executioner (Skurge)" is missing its description for "Giant Killer"
### "Firebrand (Gary Gilbert)" is missing its description for "Dual Flamethrowers Special Attack"
### "Firebrand (Gary Gilbert)" is missing its description for "Lava Resistant"
### "Gorgon (Tomi Shishido)" is missing its description for "Godkiller Special Attack"
### "Gorgon (Tomi Shishido)" is missing its description for "Stone Gaze"
### "Gorgon (Tomi Shishido)" is missing its description for "Precognitive Strike 12"
### "Grey Gargoyle (Paul Pierre Duval)" is missing its description for "Hand of Stone"
### "Grey Gargoyle (Paul Pierre Duval)" is missing its description for "Tough"
### "Grey Gargoyle (Paul Pierre Duval)" is missing its description for "Superstrength"
### "Iron Monger (Obadiah Stane)" is missing its description for "Turbo Boost"
### "Iron Monger (Obadiah Stane)" is missing its description for "Imposing Presence"
### "Iron Monger (Obadiah Stane)" is missing its description for "Air-To-Surface Missiles Special Attack"
### "Iron Patriot (Norman Osborn)" is missing its description for "Chaotic Leadership"
### "Iron Patriot (Norman Osborn)" is missing its description for "Double Attack"
### "Iron Patriot (Norman Osborn)" is missing its description for "Master Motivator"
### "Living Laser (Arthur Parks)" is missing its description for "Intangibility"
### "Living Laser (Arthur Parks)" is missing its description for "Sensory Assault"
### "Living Laser (Arthur Parks)" is missing its description for "Laser Barrage Special Attack"
### "Mentallo (Marvin Flumm)" is missing its description for "Psycho-Helmet"
### "Mentallo (Marvin Flumm)" is missing its description for "Telepathic Suggestion"
### "Mentallo (Marvin Flumm)" is missing its description for "Mental Shield"
### "Meteorite (Karla Sofen)" is missing its description for "Manipulation"
### "Meteorite (Karla Sofen)" is missing its description for "Intangibility"
### "Meteorite (Karla Sofen)" is missing its description for "Blinding Light"
### "Mister Hyde (Calvin Zabo)" is missing its description for "Blind Rage"
### "Mister Hyde (Calvin Zabo)" is missing its description for "Healing Factor"
### "Piledriver (Brian Philip Callusky)" is missing its description for "The Wrecking Crew 14"
### "Piledriver (Brian Philip Callusky)" is missing its description for "Pounding Fists"
### "Piledriver (Brian Philip Callusky)" is missing its description for "Superstrength"
### "Purple Man (Zebediah Killgrave)" is missing its description for "Phantom Walk"
### "Purple Man (Zebediah Killgrave)" is missing its description for "Pheromone Control 14"
### "Purple Man (Zebediah Killgrave)" is missing its description for "Reactive Mind Control 10"
### "Quicksilver (Pietro Maximoff)" is missing its description for "Superspeed"
### "Quicksilver (Pietro Maximoff)" is missing its description for "Whirlwind Vortex Special Attack"
### "Radioactive Man (Chen Lu)" is missing its description for "Radiation Blast Special Attack"
### "Radioactive Man (Chen Lu)" is missing its description for "Controlled Emissions 13"
### "Spawn (Al Simmons)" is missing its description for "K7-Leetha Chain Grab"
### "Spawn (Al Simmons)" is missing its description for "Heavy Machine Gun Special Attack"
### "Spawn (Al Simmons)" is missing its description for "Necroplasm Life Force"
### "Spectre (Jim Corrigan)" is missing its description for "Spirit of Vengeance"
### "Spectre (Jim Corrigan)" is missing its description for "Withering Gaze"
### "Spectre (Jim Corrigan)" is missing its description for "Intangibility"
### "Spectre (Jim Corrigan)" is missing its description for "Superstrength"
### "Stilt-Man (Wilbur Day)" is missing its description for "High Stepping"
### "Stilt-Man (Wilbur Day)" is missing its description for "The Bigger They Are . . ."
### "Stilt-Man (Wilbur Day)" is missing its description for ". . . the Harder They Fall"
### "Swordsman (Jacques Duquesne)" is missing its description for "Swordplay"
### "Swordsman (Jacques Duquesne)" is missing its description for "Makluan Sword Special Attack"
### "Swordsman (Jacques Duquesne)" is missing its description for "Counter Strike"
### "Thunderball (Eliot Franklin)" is missing its description for "The Wrecking Crew 14"
### "Thunderball (Eliot Franklin)" is missing its description for "Ball And Chain Slam Special Attack"
### "Thunderball (Eliot Franklin)" is missing its description for "Superstrength"
### "Tiger Shark (Todd Arliss)" is missing its description for "Water Strength 1"
### "Tiger Shark (Todd Arliss)" is missing its description for "Water Leap"
### "Tiger Shark (Todd Arliss)" is missing its description for "Water Suit"
### "Titanium Man (Boris Bullski)" is missing its description for "Cloaking System"
### "Titanium Man (Boris Bullski)" is missing its description for "Tractor Beam"
### "Titanium Man (Boris Bullski)" is missing its description for "Magnetic Flux Rings"
### "Typhoid Mary (Mary Walker)" is missing its description for "Dissociative Identity Disorder"
### "Typhoid Mary (Mary Walker)" is missing its description for "Pyrokinesis 14"
### "Whirlwind (David Cannon)" is missing its description for "Tornado Force Winds"
### "Whirlwind (David Cannon)" is missing its description for "Whirlwind Barrage Special Attack"
### "Wrecker (Dirk Garthwaite)" is missing its description for "The Wrecking Crew 10"
### "Wrecker (Dirk Garthwaite)" is missing its description for "Crowbar Throw"
### "Wrecker (Dirk Garthwaite)" is missing its description for "Crowbar Demolition"
### "Wong" is missing its special powers
### "Ms. Marvel (Carol Danvers)" is missing its description for "The Best Defensesuper Strength"

Most of these are simply due to the name in the Special Powers sheet being different than the name in the Units sheet. For example, in the Units sheet there is "Black Tarantula (Carlos Lamuerto)", but in the Special Powers sheet, it's just "Black Tarantula", so the script isn't able to match them.

If you can work on these issues, I'll run it through the script again. I appreciate your work on this, and I'm know many other C3G fans will be grateful to you as well.

[Jay Cain (Mythacle)]

Almost done! Only one issue left:

### "Titanium Man (Boris Bullski)" is missing its description for "Tractor Beam"

I checked the Special Powers sheet. Looks like there's a row for it, but the "Special Powers" and "Description" columns are empty.