Back

Guides

Community created guides, helpful strategies, and more.
TOPIC | [TOOL] Mega Projects Spreadsheet
@Galaxtea What exactly do you put in the "Project preview" and "Apparel preview" parts? Like, do you link the morphology/dressing room or?

Also, I think an example spreadsheet would make it easier for some people, I guess? I can usually figure things out on my own with Spreadsheets, but I'm guessing some people can't.

Thank you for reading this, either way!
@Galaxtea What exactly do you put in the "Project preview" and "Apparel preview" parts? Like, do you link the morphology/dressing room or?

Also, I think an example spreadsheet would make it easier for some people, I guess? I can usually figure things out on my own with Spreadsheets, but I'm guessing some people can't.

Thank you for reading this, either way!
Lion-Transparent-PNG-Clip-Art-Image-3.png source.gif
source.gif
giphy.gif
source.gif
source.gif
source.gif
source.gif
source.gif
source.gif
source.gif
source.gif
source.gif
@ScarletavaJad You would copy the link of the image itself from the Scry/Dressing Room! Hopefully that helps explain!

I had considered linking my personal spreadsheet as an example, though I've made some personal modifications and did not want to confuse anyone. Maybe I'll make a small duplicate to share as the example instead, thank you for the suggestion!
@ScarletavaJad You would copy the link of the image itself from the Scry/Dressing Room! Hopefully that helps explain!

I had considered linking my personal spreadsheet as an example, though I've made some personal modifications and did not want to confuse anyone. Maybe I'll make a small duplicate to share as the example instead, thank you for the suggestion!
*~*~*~*~*
Previously
Morichinatsu
*~*~*~*~*
FBJNgPs.png 8eLgwHU.png tuKAvP2.png 8a4I5lk.png FBJNgPs.png
I
VlDJnIY.png
polar
bears
and
jmrzRk7.pngs
The festival apparel has been added into the data sheet! I'll also be working on setting up an example spreadsheet soon [emoji=firework size=1]
The festival apparel has been added into the data sheet! I'll also be working on setting up an example spreadsheet soon
*~*~*~*~*
Previously
Morichinatsu
*~*~*~*~*
FBJNgPs.png 8eLgwHU.png tuKAvP2.png 8a4I5lk.png FBJNgPs.png
I
VlDJnIY.png
polar
bears
and
jmrzRk7.pngs
@Galaxtea I like @/ScarletavaJad's suggestion of an example spreadsheet!

And I have one of my own: you've done all this work on this spreadsheet, but your name isn't listed anywhere on it! You should give yourself credit! A link back to this thread on the Introduction tab would be super-helpful, too.

I also had a question - if I duplicated the Dragons sheet, then deleted all columns to the right of C, would that break the auto-update?

Reason being, I give all of my dragons names with meanings, which are currently listed in their bios. I want to go through all of my dragons' bios and "standardize" them to be more asthetically pleasing, and part of that is removing their name meanings, since for some (*cough*my custom progen*cough*), their name's meaning is quite lengthy, and to be honest, they're really more for me anyway. So I want to move them to my megasheet.
@Galaxtea I like @/ScarletavaJad's suggestion of an example spreadsheet!

And I have one of my own: you've done all this work on this spreadsheet, but your name isn't listed anywhere on it! You should give yourself credit! A link back to this thread on the Introduction tab would be super-helpful, too.

I also had a question - if I duplicated the Dragons sheet, then deleted all columns to the right of C, would that break the auto-update?

Reason being, I give all of my dragons names with meanings, which are currently listed in their bios. I want to go through all of my dragons' bios and "standardize" them to be more asthetically pleasing, and part of that is removing their name meanings, since for some (*cough*my custom progen*cough*), their name's meaning is quite lengthy, and to be honest, they're really more for me anyway. So I want to move them to my megasheet.




Projects
Wishlist
Bio Resources
Pixel art of a bonsai planter. Within the white tray are a few piles of sand. Atop the central pile of sand is a collection of red shells of various shapes. To its left is a large piece of weathered driftwood. To its right is a single column of stones, stacked like a cairn, and a dead redwood tree with two tops.*Pixel art of a widemouthed jar filled with sand. On the sand are four shells of different shapes. Tied around the jar’s mouth is a piece of twine with a sand dollar hanging from it.A medium-sized pixel book representing Vianne. It is a Mulberry book with a symmetric swirled design on its spine in Purple. At the top and bottom of the book’s spine are accents in Purple and Charcoal.A slim pixel book representing Zelophehad. On its spine is a column of geometric shapes in Black, Purple, and Stone.A slim pixel book representing Helen. The abstract angular shapes in Brown, Chocolate, and Blood on its spine evoke a cathedral.A slim pixel book representing Taalay. Large gold sparkles stand out against a Pink background. Vertical Blackberry lines frame the sparkles on the top and bottom of the book’s spine.A slim pixel book representing Reinier. On its spine is a wizard’s broom with Silver-colored bristles and a gnarled Phthalo handle on a background of Nightshade.A slim pixel book representing Judicael. On its spine is a column of geometric Gold flowers with Crimson centers on a background of desaturated Nightshade.A medium-sized pixel book representing Rhonwen. On its spine is a sword point-down in Black and White, wreathed in a spiral of and crowned with Red flames. The sword stands out on a field of White and a background of Platinum.A medium-sized pixel book representing Drake. Below a Stone plate of squiggly writing in Turquoise is a sun-and-ray design in Turquoise. Below that, running up both sides of the book’s spine, is a symmetrical series of angular triangles in Stone edged with Turquoise.A medium-sized pixel book representing Q. It is a Tomato book with interlocked spirals in Storm and Gold on its spine.A slim pixel book representing Keahi. It is an Orange book with artful slashes of Fire and Maroon on its spine.A medium-sized pixel book representing Aysu. On its spine is a fish floating below bubbles and above abstract writing that looks like seaweed on an Azure background. The bubbles are Teal and Caribbean. The fish is Caribbean with Teal stripes.A slim pixel book representing Cupid. On its spine, Purple petals drift between three Carmine roses on a background of Lavender.A slim pixel book representing Konani. On its spine, Caribbean petals drift between three Lavender roses on a background of Fern.A pixel book representing Haruna. The spine’s centerpiece features a spoon, fork, and knife in Carmine against a Seafoam background. Above the spine’s centerpiece are two sheaves of wheat in Seafoam against a White background. Below the spine’s centerpiece are vegetables in Carmine and Seafoam against a White background.A slim pixel book representing Mavuto. It is an Ice book with artful slashes of Purple and White on its spine.
@Galaxtea Thank you so much for this! I've been wanting to make something like this for a long time, but I'm admittedly not the best at making spreadsheets. I'm glad somebody beat me to the punch, though!
@Galaxtea Thank you so much for this! I've been wanting to make something like this for a long time, but I'm admittedly not the best at making spreadsheets. I'm glad somebody beat me to the punch, though!
BkLX97a.png
@Galaxtea I entered my apparel image for my Progen, but when I looked at the Apparel Projects sheet I only saw her name?

Thanks!

Edit: I figured it out, I was just missing some code!
@Galaxtea I entered my apparel image for my Progen, but when I looked at the Apparel Projects sheet I only saw her name?

Thanks!

Edit: I figured it out, I was just missing some code!
pro tips:
- if you add a message to a CR then decline it, the person who you're trading with CAN'T see the message - editing a post DOES NOT re-ping any pings in the post. you have to remove the pings, submit, then add them back in.
I don't know if you're still around, but I'd love a ping when you update with new genes! :)
I don't know if you're still around, but I'd love a ping when you update with new genes! :)
art of two hedgehogs with a green Nature symbol teacup, linking to the thread the badge was froma fake item ribbon with trans and rainbow flag colors linking to a thread with more ribbons/art of a traveling green Nature flight Spiral dragon linking to the artist
@MotherOfBeardies Hey there! All the latest apparel and genes should now be in, I really appreciate your patience [emoji=spiral happy size=1]
@MotherOfBeardies Hey there! All the latest apparel and genes should now be in, I really appreciate your patience
*~*~*~*~*
Previously
Morichinatsu
*~*~*~*~*
FBJNgPs.png 8eLgwHU.png tuKAvP2.png 8a4I5lk.png FBJNgPs.png
I
VlDJnIY.png
polar
bears
and
jmrzRk7.pngs
Oh neat, thanks so much! :)
Oh neat, thanks so much! :)
art of two hedgehogs with a green Nature symbol teacup, linking to the thread the badge was froma fake item ribbon with trans and rainbow flag colors linking to a thread with more ribbons/art of a traveling green Nature flight Spiral dragon linking to the artist
Both the Apparel and the Gene spreadsheets should be completely up to date as of now!
Both the Apparel and the Gene spreadsheets should be completely up to date as of now!
*~*~*~*~*
Previously
Morichinatsu
*~*~*~*~*
FBJNgPs.png 8eLgwHU.png tuKAvP2.png 8a4I5lk.png FBJNgPs.png
I
VlDJnIY.png
polar
bears
and
jmrzRk7.pngs