Archive for the SPREADSHEETS! Category

Pokémon Conquest Spreadsheet

Posted in Pokémon, SPREADSHEETS! with tags on 07/25/2012 by izzicality

I made a really thorough spreadsheet documenting everything I’ve acquired and everything I need to acquire in Pokémon Conquest, using Numbers on my native computer, but I just finished “importing” it to a Google Docs for general viewing.

Access it here. Comments within the document should explain how I labeled things.

Besides keeping track of my own game completion, it’s also a very good resource for things like stats, locations and evolution requirements.
I got all of my information from http://wiki.grovyle.net/ranse/ (translating as needed, of course), so I’m 93.14% certain of its authenticity (so, Ninety-Pi percent) …Of course, I’ll always edit as needed.

This post brought to you by my prodigious love of spreadsheets!

Again with the Spreadsheets

Posted in Pokémon, SPREADSHEETS! with tags on 04/10/2011 by izzicality

Once again I have a Pokédex going on a spreadsheet, but this time it’s to keep track of my collection in the 5th Generation. I’m also keeping tabs on the various Pokédexes of my 4th Generation games: Pearl, Platinum, and SoulSilver. While I have Diamond, it’s Japanese and I never beat the Elite 4, thus I don’t have a National dex to work on. It can’t see the event Pokémon I’ve traded to it, so I don’t feel the need to complete it. I got really close to at least seeing every Pokémon in Platinum, though, so I still want to complete it.

In the same vein, I have Pokémon Black, but I’ll only be working on filling the National dex in White. My copy of Black has the advantage of having everything evolved on it (since I worked so hard for information to transcribe over to my fauxkédex), so I can trade evolutions over to White without having to raise my own creatures again / waste elemental stones for dex completion. It also had Zekrom / Tornadus / Snivy-family.

As of this typing, I’m at a meager 207 obtained in White. I’ve been trying to pull focus back onto my SoulSilver team. I have another spreadsheet going of my likely team, their natures, roles, EVs, move sets, weaknesses, and coverage, because I’m starting to have an addiction to spreadsheets, I think. That one is going to stay on Numbers, though.

This Pokédex spreadsheet has been exported as an Excel file from my Numbers program and imported into Google Docs. Numbers has the list presented as a set of check boxes I can click on or off at will, but Excel strips that down to TRUE/FALSE when I export it. I’m just very visual, so I don’t like that as much. The Excel at my office can take those values and output an equivalent graphic, but it’s Excel 97 and I’m sure Google Docs doesn’t have that sort of functionality at all, so.

I’m spending hours and hours making pretty spreadsheets at work with dynamically updating information and formulas, too. Pretty soon I’m going to have to make a spreadsheets tag. SPREADSHEETS.

(anyway, the permanent link for this new spreadsheet is http://tinyurl.com/gen5dex .)

Future possible updates:

— Finishing putting all of the names in.

— Adding locations in-game for whatever I’m missing, or who I need to trade with (of who I know has things: friends and my own other games)

— A sheet that can be edited (if it’s possible to protect one sheet and let another be editable on the same doc) where people can add Friend Codes and possible Trading Opportunities. For the record though, I’m not going to trade any of my event-only or one-time Pokémon willy-nilly over wi-fi.

UPDATE: I haven’t been playing much anymore, and Nintendo/TPC/whatever are being pretty slow about releasing those Gen.5 Event guys… I almost missed out on some C-Gear skins because I forgot to keep up with Bulbanews! (I missed out on actually MEETING my Leafeon I played that stupid game to unlock, too. But I played the Dream World so many times and never saw it, so whatever.) I updated the spreadsheet with my current standings, because I apparently got like 30 more things since I had first published it. Well, I usually start playing again around this time of year, so we’ll see!

Much Ado about Pokémon Black

Posted in Pokémon, SPREADSHEETS! with tags on 09/22/2010 by izzicality

I’ve been playing Pokémon Black almost nonstop (except to sleep, work, and raid) since Monday. My initial plan to do a Blind Let’s Play (where I just take screenshots of every second of gameplay) got thrown aside when I decided that I’d rather see the game with my eyes than through a camera lens with bad exposure. Instead, I am still blindly playing (no referencing GameFAQs, Serebii, or Bulbapedia for anything that wasn’t covered pre-release) and compiling everything I learn into a Google Docs spreadsheet. I’m somewhat amateurly translating as I go, as well.

Things I am putting in my “Fauxkédex” as I come across them:

The entirety of the Isshudex: Number, Name, Species, Type(s), Weight/Height, Entry. I probably will not bother to add in locations, very daunting and I don’t actually know if time of day factors into availability yet.

I’m romanizing the names myself, so very few of these will have Pokémon Company’s registered romanizations until I’m done with the dex in-game and weed through Bulbapedia for them.

Evolution Info: What level, or required item, etc.

Abilties: This includes the abilities that the creatures I catch myself have, and also whatI learned from Pre-release info for a few creatures.

I’m inputing both original Japanese text (very very slowly) and either a romanization or a (bad) translation for everything except Abilities (I might add that in later, I just didn’t have the time to go through them today when I started this). American names for abilities are in ().

I may eventually add in a column for American Pokémon name ideas. I’m bad at coming up with my own, but there’s a select few I have thought of.

This won’t have move lists or Game Plot things or item lists, because I’m sidetracking myself enough from the game as is to bother trying to translate game text.

Look at my progress here: http://www.tinyurl.com/fauxkedex