Single Post Permalink
Member Oct 12th, 2021 Posts: 49 Pixpets: 1 Pixdex: 84 | 1 Year ago Aug 27th, 2022 - 7:54 AM Nr. 1 #45216 3So I'm going for a living Colordex of all (normal) Pixpets. Maybe I'll do vivids in the future, but... Probably only gonna happen if Egg trading becomes a thing. Pixpaldex is also on hold until we get Color Rerolls, if ever. So for now, just regular old Pixpets. I had a spreadsheet on GDrive, but I've gotten more and more uncomfortable with using Drive lately, so I've been considering moving my stuff to physical storage and back up. I realized I really hadn't updated it in a while (bc I haven't been playing much due to Life), I figured hey, why not remake it in Excel and actually learn conditional formatting, since I'd been coloring the table manually for ages. It was not easy. Excel is really stupid and has some limitations that just baffle me. Did you know it doesn't have checkboxes? Or at least, not easy ones. There's some sort of Developer tab trick that I just bypassed because it wasn't worth it when I could just put an "x" in to convey the same thing. So yea, here's the result. The Color Key is probably pretty self explanitory. Now if only I could figure out how to get it to automatically filter out the species that are done and notate that on another sheet lol. You might ask why the species are listed multiple times. Well, in a table (which was the easiest thing to use for this data), you actually can't combine any cells for some reason. So if I wanted to filter out Drax since I'm done with them, it would only filter out Sanel and not Honor and Nia if I didn't have "Drax" in all three rows. It's very dumb. But yea like, I'm in college to be an accountant. And granted, that's definitely not the same as THIS, but I still learned a lot about Conditional Formatting, AND functions, how tables work, etc etc, both from doing this sheet and from doing other sheets for other games I play. I really should stop ending up spending 2/3rds of a day doing this, though, I really get wrapped up in it. |
Register
Not Registered Yet?
Join for free
Join for free
Recent Activity
by Starburst-The-Hebi (10 Days ago
May 3rd, 2024 - 1:14 AM
)Pixpet Sponsor Support
Our Previous/Current Super Sponsors Sponsor Get your own Sponsor Banner on Pixpet (Rules) + 100 Pixpet Ticket Coupons/Month for Item Commissions! Super Sponsor Get your own Sponsor Banner on Pixpet (Rules) + Your Own Pixpet after 6 months support (not consecutive) on this tier! (Rules) |
---|
Totodile2064 Super Sponsor for 41 Months |
bgyoshi Super Sponsor for 33 Months |
Chicken_Raptor Super Sponsor for 16 Months |
Dusk Super Sponsor for 15 Months |
Tybaxel Super Sponsor for 6 Months |
Sherrice Super Sponsor for 6 Months |
Ignis Super Sponsor for 6 Months |
Takkju Super Sponsor for 5 Months |
Phoenix Super Sponsor for 4 Months |
Kookaburra Super Sponsor for 2 Months |
Isegard Super Sponsor for 1 Month |
Pixpet Chat
[jak]dacrowe a... Acura Amu Artie Astrokitty b... BeasRabbit Brandon Brettney π Brisingr12 c... Cactuskate Calixita ππΊπ Captain Owlin Carpo (ign: CarpoPyronite ) Charzea cisee citrine ckolb CorgisaurusRex Crackomint DCSA [M.Cat] Demm Dynosaur e... Ellix Emrys Ethan Fandramon GD ghost™ | rythec Hikari horse (CyberneticCaballus) hunter-z Imp Press issa Pando! [PandosHere] Iségard ivnthglxygd Ixen jaguar Jinxie Jyxxie Kino_Kari Komodo KyoVyrkai Latimer LAV Leonidas (DraconisLeonidas) Li0nless lil plant Longicaudatus lophius (monkfishlover) lorang luna (ign Aigis) maggicked MayuriTheTyrogue Melia NACHOLINE Nicol (Uri) nomadic dragon PauMol PearlyGirl Pinkapop polysaccharined (it/its) primerose Psicose PuppyToast Queen of Nightmares Queenie RainbowFox68 redfailhawk sen ShadowXeldron (Dragon0307) Shinmetsu Silver SirLeonidus (Syn) skykitten (bunny), ace attorney Skylark Starflower Snipe Snær Sokyran Soulmates4Ever Spamton Starfire Dragon Steveni Tagir The Puzzlemaster theBurnt TheEverlurker Tiffanbrill TsuKira Visionwire Will WolfDragonPlasma Zen00 Zombie PigeonPun πππUendoπππ πTangledPsycho17π π³π²
Log in to join!
6 Users Online (Last 15 Minutes)
Welcome our newest user: OutOfToon
Most Users Online: 126 on Mar 19th, 2019 - 7:07 PM
Forum Stats: Total 45314 Posts in 2835 Topics.
Early Adopter Patreon Supporter Sponsor Super Sponsor Site Artist Discord Moderator Forum Moderator Forum Super Moderator Game Moderator Game Super Moderator Administrator