Guides

@shizuyue added, thanks for the heads up :D

Hello everyone! It's been a while. I have a few updates and a new sheet for you today! [LIST] [*] First things first, I changed my username very slightly (Hexephra > Hexephre). This should be reflected on all sheets. [*] I updated all my banner images on the thread, so let me know if anything looks wrong. [*] I converted the pinglist into a [url=https://docs.google.com/spreadsheets/d/1ux8DnBB4k1jLnRoZAtVlb44KOsX6XoQfYm0dHtS7ZLs/edit#gid=33729681]self-editable spreadsheet[/url]! (The irony caught up with me of having a non-spreadsheet pinglist for a spreadsheet thread.) You can now add/remove yourself as you please. I'm always happy to help though! [*] I've now published the [b]lair sheet template[/b]! See below for details. [/LIST] Thanks for your continued interest and support! [center][img]http://i.imgur.com/0W1f8oQ.png[/img][/center] [center][img]https://i.imgur.com/TYg5bDB.png[/img][/center] Based off my own lair sheet, which I've been using and tweaking for years, this sheet has many features: [LIST] [*] List all your dragons and their flight, level, gender, breed, eye type, gene, and colour for easy reference [*] Access each dragon's page directly from the list [*] Keep track of each dragon's art and have it generated into a code you can easily paste into their bio [*] View a census showing how many dragons you have of each gender, flight, gene, eye type, and colour [*] Search your dragons based on flight, level, gender, breed, eye type, gene, and colour [/LIST] [center][url=https://docs.google.com/spreadsheets/d/1yS4SsfzNMXrdcnQYlSMPJrUZxby9znpO04RLSvL8lRc/edit#gid=917798511][img]https://i.imgur.com/ypixCir.png[/img][/url] Don't forget to make a copy![/center] [center][img]https://i.imgur.com/KpbWLEL.png[/img] [img]https://i.imgur.com/Jmi2zuJ.png[/img] [img]https://i.imgur.com/SBSKmjI.png[/img] [img]https://i.imgur.com/uOX4qZX.png[/img][/center] [center][img]http://i.imgur.com/0W1f8oQ.png[/img][/center] [b]General pinglist:[/b] @chocoapple @Moondragon007 @nm8426 @catmashiin @MysteryCorgi @aredshroom @Stargirl8686 @CartelSaide @Ellapinky @SisterofWar @shizuyue[br]

[center][emoji=pink star] [size=4][b]A call for help![/b][/size] [emoji=pink star][/center] [b]The project: [/b]I've been using a spreadsheet to track my hibernal den tasks, and with a little work I think it could be useful for a lot of people! The main feature is that it makes links to each item's AH listing (T and G separately), and I'm tracking the LAH for each. This is what it looks like right now: (I've been lazy with the images lol) [img]https://i.imgur.com/iHlRc3l.png[/img] Since I'm only using it for my own purposes right now, I'm only tracking items I actively need, but if it had every item on it people could use it as a quick reference. Once the sheet is all set up, it would be available for anyone to make a copy and track their own unlocks. Items they no longer need would be greyed out. Columns could be added with the task name and info on where to get each item. As well as any other info that seems useful! [b]The obstacle:[/b] I don't have enough time on my hands (or, frankly, interest lol) to format and input all the data myself. @Serpenthyne has an incredibly useful guide [url=http://www1.flightrising.com/forums/gde/2628040]here[/url] from which the data can be fetched! If you're interested in helping out, drop me a line and I'll give you edit access to the sheet so you can input things. Alternately, if you can format the text in such a way that I can simply copy/paste it into the sheet, that would work just as well! [br][center][img]http://i.imgur.com/0W1f8oQ.png[/img][/center][br][br][b]General pinglist:[/b] @chocoapple @Moondragon007 @nm8426 @catmashiin @MysteryCorgi @aredshroom @Stargirl8686 @CartelSaide @Ellapinky @SisterofWar @shizuyue @lilbluecat @Prophecy

Ohhh, I could definitely use a sheet like that. I don't really have the time to help input the data at the moment though. :<

@Hexephre

@spottedkind has a guide with AH buy links that you might find useful for helping finish this!

I'll definitely have to take a look at your lair spreadsheet, I've been meaning to get something set up to keep better track of my lair. Otherwise, I can help out with filling out the Den tasks spreadsheet!

@Serpenthyne Oh, that's a very helpful link, thanks! In particular the spreadsheet by glacevoleur will be great for copy-pasting. I'll PM you the edit link to my sheet. :)

Let me know if you have any questions about the lair sheet if you do check it out!

@Hexephre
Are you still looking for help with this? Let me know!

@MysteryCorgi I am, yes! I'll DM you the sheet link.

[center][img]https://i.imgur.com/ViV7hyh.png[/img][/center] The [b]Hibernal Den Unlock Tracker[/b] lets you see all the items you'll need to unlock your hibernal den slots! Features: [LIST] [*]Mark each task as active, unlocked, or future. [*]Write down how many of each item you have. [*]Automatic colour coding based on both of the above! [*]Auto-generated links to the AH in T and G for quick access. [*]Auto-generated item codes for easy copy-pasting. [*]You can make note of each item's LAH as well as its MP price if it has one. [/LIST] Thanks to @Serpenthyne and @MysteryCorgi for helping with data entry! Thanks to @glacevoleur for their spreadsheet with item names! [center][url=https://docs.google.com/spreadsheets/d/1NeUQv9zM3br7pgJghLhQXA0NLIBGhkg3iEIbuZoKWsc/edit#gid=2089695028][img]https://i.imgur.com/ypixCir.png[/img][/url] Don't forget to make a copy![/center] [img]https://i.imgur.com/hJPCjDe.png[/img] [b]ETA:[/b] If you're already partway through unlocking your slots, here's a quick way to get your sheet up to date: [LIST=1] [*]Mark all active tasks "active" and write down how many of each item you have for them. [*]In column D ("Status"), select all cells up to the latest active task. [*]press ctrl+F or cmd+F to bring up the "find" panel in the top right, then click the "..." on the side. [*]In "find" enter "future" and in "replace with" enter "unlocked". Then hit "replace all." [*]Click the triangle next to the "Status" header, then "Sort A --> Z". [/LIST] Let me know if you need help with this process! [br][center][img]http://i.imgur.com/0W1f8oQ.png[/img][/center][br][br][b]General pinglist:[/b] @chocoapple @Moondragon007 @nm8426 @catmashiin @MysteryCorgi @aredshroom @Stargirl8686 @CartelSaide @Ellapinky @SisterofWar @shizuyue @lilbluecat @Prophecy @Harana

@Hexephre The timing of this sheet's release couldn't have been better, now that we have 10 tasks to keep track of. Thank you for making it. And thank you @Serpenthyne and @MysteryCorgi for entering the data, and @glacevoleur for the spreadsheet with item names! [emoji=familiar heart] [emoji=familiar heart]