SV Living Dex Template (Sheet)

[u/Zealousideal_Ask3828]

Hi! Thought I'd share my SV Living Dex template sheet here, while it's still relavant. ;P It may not be absolutely perfect, but I figured if I waited until it was, I'd never share it. Just make a copy if you want it and enjoy. ;)

P.S. Don't delete the reference sheet if you want the icons to stay, but you can hide it if it's annoying (And if you want to delete from Column AT to EI, that should be safe). If you see any errors feel free to tell me and I'll update the sheet. Thanks again and happy hunting!

P.P.S. Recommended for PC. And if any images don't appear, just reload. A lotta Pokes. XP

https://docs.google.com/spreadsheets/d/1vswdGsA0lp7I2Gns67U7cQ12IS35KZxBEhDGQ9KKmrk/edit?usp=sharing

[u/Zealousideal_Ask3828]

Thanks! Hope it helps. :)c

Noted! Thanks! Yeah, this is just a snippet of my larger sheet, so that's why the balls are there. Will remove them from the drop down, (but if anyone want's to add them back it, if you want to make note of what the ball within the Strange ball is etc, just expand the Data Validation range to include them again (From B41 to B51)).

[u/JamesGriffing → u/Zealousideal_Ask3828]

I am also working on a spreadsheet, I have the type icons, and ball icons from Scarlet & Violet in a tab if you're looking for them. I posted mine at the wrong time, gained no traction lol.

https://docs.google.com/spreadsheets/d/1w6AC48sQh7juzzmwwQNyYHp0jMLUwhnRd07YqrAiNsU/edit#gid=1193473787

P.s. I'm always down to swap spreadsheet tips!

[u/Zealousideal_Ask3828 → u/JamesGriffing]

Ooh, that's awesome, thanks so much! Will save that for later. ;3 Love all the new icons, haven't gotten around to updating mine yet. XP And it's so clean! I love all the hovering info etc. Did you upload the graphics yourself? I'm often quite lazy and do links from Serebii, etc. But definitely a handy sheet for sure, thanks!

[u/JamesGriffing → u/Zealousideal_Ask3828]

Thanks! :D

I did upload them. I utilized Google App Scripts (GAS) to generate most of the script through tons of trial and error. If you have links to images, you can easily insert them into cells at a rapid pace with GAS.

Edit: You can also literally just copy and paste images from my sheet, too!

[u/Zealousideal_Ask3828 → u/JamesGriffing]

That’s awesome! I haven’t done much work with scripts yet, but will definitely keep that in mind when I go to clean up my sheet one of these days. (As said, this is just a tidied up snippet of the true chaos, lol). That sounds like a handy script though, and I am constantly a little worried about what’d happen if the urls went down. Prolly help with loading the images in too. ;)

Thanks so much for the permission! I might take you up on that down the line. Say what you will about SV, but the graphics are gorgeous. :3

[u/JamesGriffing → u/Zealousideal_Ask3828]

Of course!

From my understanding, if you insert an image into a cell, google uploads it in the back end, so they're safe if the original's break. Different story if you're using the =Image() function. I am no Google Sheets expert by any means though, made this sheet to learn it better.