Posts Overview
Pixpets made me learn more about how excel works than college has (1 Post and 32 Views) | |
---|---|
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
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 aly Amu Astrokitty Beebs (Bee) BR1CO12 Brettney π Brisingr12 c... c... Cactuskate Carpo (ign: CarpoPyronite ) ckolb DarylSun Draxi Dynosaur ECDMDragon Fandomzzz1234 Fandramon Fren Derg Gabe GD Hikari issa Pando! [PandosHere] Iségard ivnthglxygd jaguar Jyxxie Kino_Kari Komodo KyoVyrkai LAV Lazywolfy Leonidas (DraconisLeonidas) lil plant lucien luna (ign Aigis) Macheeba Mage Yoshi maggicked Melia Mew Moonlightelf Nat Nicol (Uri) Ozanthium PearlyGirl Pinkapop primerose Psicose PuppyToast Queen of Nightmares Queenie Rachel the Raichu Rainbow is an artist RainbowFox68 Rexsaurus sen ShadowXeldron (Dragon0307) Shpee Silly Silver skykitten (bunny), ace attorney Skylark Starflower Snake Snær SomeRandomMightyena Soulmates4Ever Steveni Tagir Tiffanbrill TwistedGate Valdus Aetherius Will WolfDragonPlasma Zen00 Zetta π^^Niji_Crab^^π« πππUendoπππ πTangledPsycho17π π³π²
Log in to join!
4 Users Online (Last 15 Minutes)
Welcome our newest user: Ommomasouppe
Most Users Online: 126 on Mar 19th, 2019 - 7:07 PM
Forum Stats: Total 45302 Posts in 2831 Topics.
Early Adopter Patreon Supporter Sponsor Super Sponsor Site Artist Discord Moderator Forum Moderator Forum Super Moderator Game Moderator Game Super Moderator Administrator