Guides

[quote name="Darkfrost" date="2017-08-08 20:40:51" ] tbh keeping track of all my sub-clans is why I made the spreadsheet in the first place. Also because I realized it'd probably be 500 more years until FR implements them as a site feature (if they do at all). Turn your dreams into spreadsheets and all that. [/quote] [b]Disclaimer:[/b] This spreadsheet was originally shared on [b]August 8th, 2017[/b]. Lair Tabs were released as part of the Lair Revamp on [url=https://www1.flightrising.com/forums/ann/2627065][b]February 7th, 2019[/b][/url]. Enjoy this relic from a time long gone by :p ----- [img]https://orig05.deviantart.net/a22c/f/2017/217/8/2/00_header_by_yamithedragon-dbix96v.png[/img] Have you ever wanted Lair Tabs? Something to organize your dragons besides what page of your lair they're on? Do you want to assert your dominance over machines by making them do all the work for you? Are you fond of things that are easy to use and update? If you answered yes to any of these questions, then boy, do I have the spreadsheet for you! [center][size=5][url=https://docs.google.com/spreadsheets/d/1LhlObBFN3yhSOBdU9v2mCNb6p0YfJdQ8FkQbCmdVHVc/edit?usp=sharing]Introducing Lair Tab Simulator 2000 (version 2.1)[/url][/size][/center] It's here! It's free! It's flexible! It was created for Lore and Non-Lore, big and small Clans alike, and lets you organize your dragons into as many different Lair Tabs as you want! You can make 6 lair tabs for 300 dragons, 100 of which are just images of cheese! I don't know why you'd do this, but you can. [b]Things to know about this spreadsheet[/b] [LIST] [*] By default, this spreadsheet can handle up to 300 dragon - the Lair Tabs included are named after how many dragons they can handle. You can import Lair Tabs of different sizes (5-300 dragons), or upgrade your sheet to be able to handle up to 500 dragons over at the [url=http://www1.flightrising.com/forums/gde/2251920#post_28768373]Fix-It Sheet [/url] [*] You're free to rename your Lair Tabs to whatever you want, but please don't rename any of the other sheets [*] On the Lair Tabs themselves, don't edit anything on or below row 9 (all the important formulas start down there) [*] Sometimes when you change stuff it may take a few seconds to update (especially for Options and bigger lair tabs) [/LIST] [b]Version 2.1[/b] [LIST] [*] The Options sheet now includes a Clan Population Counter - simply select a group and it'll tell you how many residents that group has. [*] The way Lair Tabs work has been modified and optimized. The biggest lair tabs can now show up to 300 dragons (upped from 204), the smallest up to 5. [*] Fully compatible with version 2.0 [/LIST] To update your options sheet from 2.0, follow the instructions [url=http://www1.flightrising.com/forums/gde/2251920/9#post_31466217]in this post[/url]. [b]Version 2.0[/b] [LIST] [*] Dragons can now be added to 10 or less groups (upped from 3) [*] Custom Elements and Genders can now easily be added, removed or modified on the Options sheet [*] IDs containing a # will now work [*] Re-organized and optimized the Data and Lair Tab sheets [/LIST] If you want to update from version 1, you can use [url=https://docs.google.com/spreadsheets/d/1adrgQFZpKzjMjOp09gd9aRvtINEnK4bKKV2-hjrAP6g/edit?usp=sharing]this spreadsheet[/url] and have it re-organize your Dragon Info sheet to fit the new format (though you'll have to re-add your Lair Tabs manually). [center]About | [url=http://www1.flightrising.com/forums/gde/2251920#post_28768371]FAQ[/url] | [url=http://www1.flightrising.com/forums/gde/2251920#post_28768373]Fix-It Sheet[/url] | [url=http://www1.flightrising.com/forums/gde/2251920#post_28768374]Spread the Word[/url] | [url=http://www1.flightrising.com/forums/gde/2251920#post_28768376]Custom Banners[/url][/center]

[img]https://orig12.deviantart.net/8da0/f/2017/217/e/9/01_by_yamithedragon-dbixx1q.png[/img] If you have a question that's not answered here, feel free to ping me with it! [size=4][b]How can I use this?[/b][/size] You'll need a Gmail account to use it - on the spreadsheet itself, select File -> Make a Copy. [size=4][b]How do I get my dragons to show up?[/b][/size] First you need to assign your dragons to a lair group in the dragon info tab, then select the group to be shown in any of your lair tabs. [size=4][b]How do I create a new lair tab?[/b][/size] Simply duplicate an existing lair tab and select another group for it to display. That's it, that's all you need to do. [img]http://fs1.directupload.net/images/180126/86r2o7rx.png[/img] [size=4][b]Can Lair Tabs hold more than 100 Dragons?[/b][/size] Yes! Simply head over to the [url=http://www1.flightrising.com/forums/gde/2251920#post_28768373]Fix-It Sheet[/url] and grab a bigger Lair Tab. The regular sheet doesn't include the 200 Dragon Tabs because duplicating them takes a lot longer. [size=4][b]Can I add a dragon to more than 10 Lair Groups?[/b][/size] Yes, though you'll need to copy their information (ID, Name, etc), then select the other lair groups you want them to be in. [size=4][b]How do I add familiars to the spreadsheet?[/b][/size] 1. Set the "Type" field to "Familiar" 2. In the ID field, enter that Familiar's Item ID To find its Item-ID, right-click on an image of the familiar and select "open image in new tab". This should give you an URL like this - the number before ".png" is its Item ID. http://flightrising[i].[/i]com/images/cms/familiar/[b]1174[/b].png [size=4][b]What about adding Items, Scries or Outfits?[/b][/size] Right-click and select copy image address on an item on your choice, then paste it into the Custom Image field. Same goes for Dragons from the Scrying Workshop or the Dressing Room. [size=4][b]Can I sort my dragons by breed?[/b][/size] Since by default you don't tell the spreadsheet what breed your dragons are, there currently is no "Sort by Breed" option - however, you can type their breed into the "Sort" field, then select "Info Sort" on the Lair Tab, and it will sort the dragons by breed. [size=4][b]What do all the extra Elements/Genders look like?[/b][/size] [b]Genders: [/b] [img]https://orig12.deviantart.net/b430/f/2017/220/4/7/523_by_yamithedragon-dbjdddo.png[/img] [b]Elements:[/b] [img]https://orig09.deviantart.net/9f43/f/2017/220/f/d/522_by_yamithedragon-dbjddd0.png[/img] [size=4][b]How does this work?[/b][/size] There's a (by default hidden) sheet called Data that imports stuff from the Dragon Info and Options sheet and does some math to turn it into what you later see (i.e. one column contains the dragon's images, another the Icons for their gender, then one for their element). The Lair Tab sheets have a bunch of hidden columns to the side where they import stuff from the Data sheet if it matches the selected group, then sort it after whatever criteria you've selected. Last but not least, it puts everything in the right place by referencing the double-sorted data. For version 2, I've added a new hidden sheet, called ccData, that now handles Lair Groups, Elements and Genders. It references the Options sheet to import custom elements/genders, and is in turn referenced by Data for showing elemental and gender images. [center][url=http://www1.flightrising.com/forums/gde/2251920#post_2251920]About[/url] | FAQ | [url=http://www1.flightrising.com/forums/gde/2251920#post_28768373]Fix-It Sheet[/url] | [url=http://www1.flightrising.com/forums/gde/2251920#post_28768374]Spread the Word[/url] | [url=http://www1.flightrising.com/forums/gde/2251920#post_28768376]Custom Banners[/url][/center]

[img]https://orig03.deviantart.net/72b7/f/2017/218/b/b/02_by_yamithedragon-dbj1qvn.png[/img] Seeing how this is a spreadsheet and not an implemented site feature, there is unfortunately the possibility of it breaking. It's not necessarily a [i]big[/i] possibility, but just in case I've added some spreadsheets and how-to's for fixing it. Or, if your spreadsheet is working fine and you just want more dragons, or lair tabs of different sizes, you'll likely find these spreadsheets useful as well. [center][size=5]Spreadsheet for more Lair Tabs[/size] (make sure to pick the version that corresponds with how many lair groups per dragon you have) [url=https://docs.google.com/spreadsheets/d/12a4jbFqLfHq03cVzlB9cDZu2tK6VHmf_yvM68_qVYyk/edit?usp=sharing][b]version 2[/b][/url] (up to 10 lair groups per dragon) [img]http://fs1.directupload.net/images/180126/qb7flx7p.png[/img] [url=https://docs.google.com/spreadsheets/d/1WIM8egpxK0oUj3jejRQuInQeztGMSa8ewJJgY1r0T-k/edit?usp=sharing][b]version 1[/b][/url] (up to 3 lair groups per dragon) [img]http://fs5.directupload.net/images/170808/skab3zjk.png[/img][/center] Lair Tabs come in a variety of sizes, both with 5 and 6 dragons per row. If you want one, all you need to do is copy one to your spreadsheet, and it will work. Simply select what group you want it to show, if you want it sorted, select a banner, and have fun! [b]Should new Lair Tabs not instantly work for you:[/b] First of all, make sure you're using the right version. 1. Make sure none of the sheets (except Lair Tabs) have been renamed to something else. If they have, rename them back and try again. 2. Look at your other lair tabs. If none of them are showing anything despite a group being selected, try replacing your Data sheet (instructions are below). If only their elements/genders aren't working, try replacing your ccData sheet (again, instructions are below) 3. If you've done both 1 and 2 and it's still not working, ping me! I can try taking a look at your sheet to try and figure out what's wrong. [center][size=5]Spreadsheet to replace your Data sheet[/size] (make sure to pick the version that corresponds with how many lair groups per dragon you have) [url=https://docs.google.com/spreadsheets/d/1AyuGq8HfkSrK1NZvYov47OJjQusTAuYcxdjtgQRpbcM/edit?usp=sharing][b]version 2[/b][/url] (up to 10 lair groups per dragon) [url=https://docs.google.com/spreadsheets/d/1WeoTof-hwpz_k-_T09ukRDKhNGC9HYmVYGavdUoes3M/edit?usp=sharing][b]version 1[/b][/url] (up to 3 lair groups per dragon) By default, the Data sheet can handle up to 300 dragons, but you can upgrade it for up to 500 dragons per spreadsheet. If you have 500 dragons and still need more, consider making a second spreadsheet and moving some of your dragons over to it. [center][url=http://www1.flightrising.com/forums/gde/2251920#post_2251920]About[/url] | [url=http://www1.flightrising.com/forums/gde/2251920#post_28768371]FAQ[/url] | Fix-It Sheet | [url=http://www1.flightrising.com/forums/gde/2251920#post_28768374]Spread the Word[/url] | [url=http://www1.flightrising.com/forums/gde/2251920#post_28768376]Custom Banners[/url][/center]

[img]https://orig09.deviantart.net/8983/f/2017/220/c/e/04_by_yamithedragon-dbjchy6.png[/img] If you like this spreadsheet and would like to spread the word about it, you could add one of these to your signature: [img]https://orig09.deviantart.net/0548/f/2017/220/1/3/spread_the_word_01_by_yamithedragon-dbjcpq5.png[/img] 71 x 90 px [code][url=http://www1.flightrising.com/forums/gde/2251920][img]https://orig09.deviantart.net/0548/f/2017/220/1/3/spread_the_word_01_by_yamithedragon-dbjcpq5.png[/img] [/url][/code] [img]https://orig09.deviantart.net/b997/f/2017/220/4/2/spread_the_word_02_by_yamithedragon-dbjcppp.png[/img] 100 x 87 px [code][url=http://www1.flightrising.com/forums/gde/2251920][img]https://orig09.deviantart.net/b997/f/2017/220/4/2/spread_the_word_02_by_yamithedragon-dbjcppp.png[/img] [/url][/code] [img]https://orig06.deviantart.net/b907/f/2017/220/4/4/spread_the_word_03_by_yamithedragon-dbjcppk.png[/img] 80 x 80 px [code][url=http://www1.flightrising.com/forums/gde/2251920][img]https://orig06.deviantart.net/b907/f/2017/220/4/4/spread_the_word_03_by_yamithedragon-dbjcppk.png[/img] [/url][/code] [center][url=http://www1.flightrising.com/forums/gde/2251920#post_2251920]About[/url] | [url=http://www1.flightrising.com/forums/gde/2251920#post_28768371]FAQ[/url] | [url=http://www1.flightrising.com/forums/gde/2251920#post_28768373]Fix-It Sheet[/url] | Spread the Word | [url=http://www1.flightrising.com/forums/gde/2251920#post_28768376]Custom Banners[/url][/center]

[img]https://orig15.deviantart.net/05e2/f/2017/220/a/6/03_by_yamithedragon-dbjcd3k.png[/img] Here you can find some Free-to-use Custom Banners, which you can use for your Lair Tabs. If you'd like to make your own, there's plenty of sites with images that are free to use and modify, such as [url=https://unsplash.com]Unsplash[/url], [url=https://pixabay.com]Pixabay[/url] or [url=http://backgrounds.mysitemyway.com]backgroundsETC[/url]. Also, know that the minimum size for it to display on your default lair tab is 647 x 158 px If you aren't happy with the position of these images, I recommend changing the horizontal and vertical alignment to adjust what part of the image is visible [img]https://orig00.deviantart.net/a7b1/f/2017/220/6/d/519_by_yamithedragon-dbjd1ww.png[/img] [center][img]https://orig14.deviantart.net/dd68/f/2017/216/2/5/custom_banner_01_by_yamithedragon-dbiw0st.png[/img] [b]Underwater Bubbles[/b] [url=https://unsplash.com/photos/BRkikoNP0KQ]Original Photograph by Sime Basioli[/url] [img]https://orig12.deviantart.net/4512/f/2017/216/3/2/custom_banner_03_by_yamithedragon-dbiw0t3.png[/img] [b]Library[/b] [url=https://unsplash.com/photos/He8-FZl-o10]Original Photograph by Hieu Vu Minh[/url] [img]https://orig08.deviantart.net/9869/f/2017/220/e/2/custom_banner_04_by_yamithedragon-dbjbyyu.png[/img] [b]Snowy Mountain[/b] [url=https://unsplash.com/photos/F3ePNdQb_Lg]Original Photograph by Samuel Zeller[/url] [img]https://orig11.deviantart.net/94ba/f/2017/220/a/0/custom_banner_04_by_yamithedragon-dbjc0uk.png[/img] [b]Lots of Lightning[/b] [url=https://unsplash.com/photos/NcTQ602gKLI]Original Photograph by Clinton Naik[/url] [img]https://orig14.deviantart.net/cedf/f/2017/220/d/c/custom_banner_06_by_yamithedragon-dbjc1yq.png[/img] [b]Starry Night Sky[/b] [url=https://unsplash.com/photos/ln5drpv_ImI]Original Photograph by Vincentiu Solomon[/url] [img]https://orig11.deviantart.net/5b2d/f/2017/220/8/3/custom_banner_08_by_yamithedragon-dbjc3wg.png[/img] [b]Waterfall[/b] [url=https://unsplash.com/photos/jeXkw2HR1SU]Original Photograph by Julia Caesar[/url] [center][url=http://www1.flightrising.com/forums/gde/2251920#post_2251920]About[/url] | [url=http://www1.flightrising.com/forums/gde/2251920#post_28768371]FAQ[/url] | [url=http://www1.flightrising.com/forums/gde/2251920#post_28768373]Fix-It Sheet[/url] | [url=http://www1.flightrising.com/forums/gde/2251920#post_28768374]Spread the Word[/url] | Custom Banners[/center]

How to:

Add custom elements (v1 only)



(this will likely be expanded upon in the future)

reserved just in case

Pinglist for future updates:

-removed-

@Darkfrost

Ahh yay!!!! Can't wait to try this out when I get home

Yesssss~! I'm happy to see it up and running ^^