Guides

[center][img]https://media.discordapp.net/attachments/815737314243379245/1076661852064452638/dsfs.png[/img] [i]art by can of weirdness on TH[/i] [rule][center] [i]I apologize for this intro idk how to write intros[/i] So I have had people ask me to make some sheets from my Hatchery sheets. And then I began making a census sheet... and so I guess I'll toss all of them onto here. [b]Notes:[/b] I know not everything is explained as clearly as it could be. I'm going to try to write up tutorials when I'm able to, but I'm stuck with the "help i coded this and know how it works but can't explain how it works" type of brain soup. All sheets have/will have a YouTube tutorial in them ASAP. So are these things relatively complete? Yes. But things may have escaped my sheets soup as I was taking the original sheets and making them into templates. Also note that tutorials may or may not show my own personal version (the original version) of the sheet. I may or may not slap in tutorials for the templates. [rule][center] [b]Please don’t hesitate to ask questions or point out any bugs. I am subbed so there’s no need to ping![/b] [b]Please direct people to this thread if they ask about the sheet! I would prefer credit to remain intact/to be credited as well.[/b] I do take suggestions and all. [rule][center][b]Table of Contents[/b] [url=https://www1.flightrising.com/forums/gde/3212807#post_53496763]Lair Census/Tracker[/url] [url=https://www1.flightrising.com/forums/gde/3212807#post_53496841]Hatchery Pinglist/Coder Companions[/url] [url=https://www1.flightrising.com/forums/gde/3212807#post_53496950]Standalone Sales Coder[/url] [url=https://www1.flightrising.com/forums/gde/3212807#post_53496950]Project & WL Coder/Tracker[/url] [rule] ~~~~~~ [pinglist=3732] [pinglist=3738]

[center][size=6][b]Lair Sheet/Census Whatcamacallit[/b][/size] [img]https://media.discordapp.net/attachments/815737314243379245/1076650605331890336/Screenshot_20230218_034320.png[/img] This is based on [i]multiple[/i] lair sheets out there. A big thank you to anyone who has a super lair sheet, etc. because it's very likely I referenced yours in some way or another for what to put into here. [b]Current Version:[/b] 0.2a (11/29/23) [b]Please refer to the Dev Log tab for any updates/fixes I've made with the template, or ask to be on the pinglist![/b] [b][url=https://docs.google.com/spreadsheets/d/1UKx3ruNCxtVnh_p68EbwQ494n3iAnvchZdglyj-aOiI/edit?usp=sharing][size=5]Spreadsheet Here[/size][/url][/b] This thing is the result of 12+ hours of my sheet soup of a brain going ham. [b]Features:[/b] - Grabs most things just from a copy/paste of the dragon's page stuff - Customizable Pronouns/Gender/etc. ranges - Colors for genes - Stats and stuff for the curious - Charts go brrrr with stats and all - helps you realize you may just indeed have too many dragons :) [b]Upcoming[/b] - Reimplementing least/most frequent genes - the original code was messy so I'm going to redo it. [b]Instructions[/b] (this is also on the first tab) 1. Manual input name and ID of the dragon in cells G2 and I2 2. Copy everything in the Physical Attributes box, from "Measurements" to the end of the eye type name. 3. Paste into the red columns (do not ctrl+shift+v, just ctrl+v) 4. Head back to your dragon. Switch from "Physical Attributes" to "Battle Stats" in the box right below your dragon's image. 5. Copy from the "Level # <breed>" in the Battle Stats box to the end of the offspring list. CTRL+V (NO SHIFT) into the yellow column on the sheet (Y) 6. Copy the green row above (starts at AA2) 7. CTRL+SHIFT+V into the Dragons tab in the next available row. Remember to do this in the second (name) column, as the first column is a formula. This sheet is currently not optimized for mobile due to the lack of ctrl+shift+v functionality on mobile, I apologize. [b]Help & Resources[/b] [url=https://docs.google.com/spreadsheets/d/1ovhOb_KcqijwhTmkxkhoYcXVjksGHW2SAAXyn26sPKM/edit?usp=sharing]My Sheet for Reference[/url] YouTube Video will be made ASAP. The original one was made before I made coding updates

[center][size=6][b]Hatchery Pinglist & Sales Coder Companions[/b][/size] [img]https://media.discordapp.net/attachments/815737314243379245/1076654264753066004/image.png[/img] I coded my original hatchery coder about a year ago. This template is taken from the revamped version of the original (what I use today). [b]You need to use both sheets in order for them to work properly.[/b] If you just want a simple coder, that will be on the following post. [b]Current Version:[/b] 0.1 [b][url=https://docs.google.com/spreadsheets/d/17wzJRnT_kqtAyY2LTC3oxwziJ_E6W813Sp3hCSp6oJ0/edit?usp=sharing][size=5]Coder Spreadsheet Here[/size][/url][/b] [url=https://docs.google.com/spreadsheets/d/1Y9cr6tqok9cw83as7ZcWI9eFPrltZ5r9TWcJ4ym5NkU/edit?usp=sharing][size=5][b]Pinglist Spreadsheet Here[/size][/b][/url] Again, you need BOTH sheets. [b]Features:[/b] - Automated "Pair Guide" in the Pinglist Sheet - Autocodes Sales Posts & Additions to a Main Page Sales Post - Pinglist Generator - Pretty quick to use once you get a hang of it, but I am biased [b]Instructions[/b] - Make copies of both sheets - Fill out the Setup tab of both sheets. This is extremely important. - Add your pairs to the Pair List tab of the Coder sheet. [b]Note that it is not recommended to change tab names due to how stuff pulls from/to the other sheet[/b] [i]Also be sure to sort the sheet how I do it in the tutorial! Select all of column A in Pair List minus the header row (first row) and go to data -> sort sheet-> A-Z by column a[/i] - Tutorials are made in the Coder sheet's Setup tab for posting sales posts/etc. according to how I do it with my hatchery. - Setup and Affiliates tabs may be hidden if desired ^ better instructions will be made asap. please ask me if you have any questions and I'll try my best to answer. [b]A note that these two are subject to have some issues, as they weren't originally made to be templates. Please let me know if you find any issues and I'll try to fix em asap! Many of these errors can't be found with my own sheet or even the template, especially if they're only in the template and can't be found unless theres x number of pairs or people on the sheets.[/b] This sheet can work on mobile with the exception of some difficulty when adding new pairs. Make sure you're pasting values only on mobile by double clicking the cell you want to paste in. [b]Help & Resources[/b] [url=https://docs.google.com/spreadsheets/d/1RwiuqAjxb67T7r7fE2wTVb2jEMt8m_MeD0sIoOuXuAc/edit?usp=sharing]My Pinglist for Reference[/url] [url=https://docs.google.com/spreadsheets/d/1m_MsGlncd6RDwLIJNzptgwqes0EsrWedHd_RocYapCA/edit?usp=sharing]My Coder for Reference[/url] [url=https://youtu.be/P_YDG9_1JME]Adding a Pair[/url] (no audio tutorial) [url=https://youtu.be/L1Zt-z1ij10]Making a Sales Post[/url] (no audio tutorial) ^ both of the above do not have text and are just me slapping stuff into my sheet/hatchery. There are points where I type in important things, though. [b]Known Issues[/b] - check colors/genes combining columns in coder. they work sometimes. but not others.

[center][size=6][b]Standalone Sales Coder[/b][/size] [img]https://media.discordapp.net/attachments/815737314243379245/1076657802682056790/image.png[/img] This is a simplified version of the above and is just the coder for the sales chunk. It does not have pairs/etc. and is honestly just for a quick sales format. [b]Current Version:[/b] 0.1 [b][url=https://docs.google.com/spreadsheets/d/171PljhlyqBSK_NTJYre9yeJMPow_O6oWMTdYGYVisfs/edit?usp=sharing][size=5][b]Spreadsheet Here[/size][/b][/url] [b]Features:[/b] - Allows you to code up a sales format for each dragon and grab em all together in a way. [b]Instructions[/b] - Should be fairly simple to use -> Anything not needed has been deleted, so make sure you're filling out each part completely. This sheet can work on mobile. Make sure you're pasting values only on mobile by double clicking the cell you want to paste in. [b]Help & Resources[/b] [url=https://youtu.be/NZ0kg809nI8]YouTube Tutorial[/url] (no audio)

[center][b][size=5]Project & WL Coder & Organizer Spreadsheet [/b][/size] [img]https://media.discordapp.net/attachments/815737314243379245/1076659102597521498/image.png[/img] The basic instructions are on the first tab of the sheet, as well as the few cases where you need to use an alternative name for a gene (the Basic trio). Ofc, you can change or delete the Dipper and Gloxinia rows - they’re just an example. The main goal for this was to have a sheet that auto coded a thing I can slap into a dragon bio, so it looks somewhat like this: [color=transparent]Iota[/color][br][columns][url=https://www1.flightrising.com/dragon/46194605][img]http://flightrising.com/rendern/portraits/461947/46194605p.png[/img][/url][nextcol][item=primary gene: Iridescent][item=Glitterfreeze Halo] [/columns] [color=transparent]Baby Menace[/color][br][columns][url=https://www1.flightrising.com/dragon/82832245][img]http://flightrising.com/rendern/portraits/828323/82832245p.png[/img][/url][nextcol][item=secondary gene: Saddle (undertide)][item=tertiary gene: Tentacles (undertide)][item=vial of glowing sight] [/columns] I will update the genes from my master copy, which should (given that the tab isn’t touched) import into the “stuff” tab in the template. The sheet will spit out modern genes if you don’t input the breed into the breed column too. (NOTE: If you are changing a modern into an ancient breed, pls put the ancient it's turning into as the breed into the breed column. Same if you're turning an ancient to a modern) Automated price tab and new calculator w/ a scry image/current image toggle too <3 [rule][center] [b][size=5][url=https://docs.google.com/spreadsheets/d/1lSsURsk3ex09PXtTvv1C6Fj9vq317nSE6iIIALinSyk/edit?usp=sharing]Spreadsheet Here[/url][/b][/size] Last Updated: 12/11/2023 Version: 0.5 [b]Note as of 12/11:[/b] With the new code update for ancient genes, I decided to not recode every single gene to what it is now. Instead, I've tossed in an extra column or two and added some code to spit out the new gene stuff. [i]This is why the cost tab does not seem to be updated! But don't fear - the sheet's pulling the new gene names from a different column[/i]. I do enjoy the parentheses for sorting reasons, after all. [b]Code will spit out with the new gene names, even if parts of the sheet do not visually reflect this.[/b] this sheet can work with mobile to my knowledge [b]Resources[/b] [url= https://docs.google.com/spreadsheets/d/1HFY7Sq5a6QpP3yaaSX0ODTkMFrIcGuSCuTXyZzx1a9g/edit]my copy for reference[/url] [b]Upcoming Features:[/b] - Gene Location Lookup (my apologies that this is formatted differently than the other posts - i took this from my original project sheet thread)

I am aware of a few bugs with the census and the hatchery sheets. I'm hammering them out bit by bit, but none of them are 150% sheet-breaking to my immediate knowledge.

If anyone else finds a bug, lmk!

(the big one is something with how the census counts subspecies in the stats tab and I think the issue is that it's counting dragons that are in the sheet with the subspecies dropdown blank. But i'm still testing this little part.)

Census sheet also has length/wingspan/etc stuff. (not me originally meaning to put this into there but didn't... despite having it already broken up and ready)

One, I love this sheet, it's absolutely wonderful! Two, I don't think that the length/wing-span/weight is being grabbed when I copy the dragon info from its page. I can see that its in the red column, but its not being added into the info in the green row. I dunno if maybe Im doing something wrong, but in case its a bug, I thought you'd like to know!

Also, the "random dragon" in the stat sheet, at least for me, is changing the photo just fine, but the name doesn't change.

@veilmochi oh huh I must've accidentally deleted the code in those rows omg. Everything should be fixed now, thank you for bringing that to my attention!

(The random dragon part was missing an updated part of the code whoops. That's fixed too!)


@Helixstorm I don't know if you're copy was made before/after this problem but thought you might like a ping just in case.

@AlphaSnowdust it works perfect now! Thank you!

@AlphaSnowdust Hi, sorry to be a bother again! I'm using the WS Coder and Pinglist, but the Code doesn't have a gene tab like how your example does.