Guides

1155

March 27, 2015 13:45:53

Greetings!

And welcome to the Lair Spreadsheet hub.
It's taken much time to polish and optimise it, but it will be completely free to use.
Just follow the link and save your own copy!

Now you might be thinking ''So, what does this thing Do?'' - and I will explain~

• Has a special tab that automatically works out the costs of projects
• It will give you an overview of the breed distribution in your lair
• Lets you keep track of how much food your lair eats per day
• Shows you what the most common colours are in your lair
• Neatly shows you what genes your lair has in percentages
• All FR colours are coded in

And more!

A FAQ is posted below, and a short FAQ can be found on the spreadsheet itself.

Again, this spreadsheet is free to use, but treasure-tips are always welcome *winks*

Last edited on Aug 10, 2015 17:38:01 by Bubonica

[center] [b][color=indigo][size=5]FAQ[/size][/color] [color=blue]Q: I love the spreadsheet, but I don't have the patience to fill it all in myself. Is there an automated way to do this?[/color] [color=indigo]A: I'm afraid not. But you don't have to enter them all! I can enter the data for you for a fee, though~ [/color] [color=blue]Q: The food calculation is too high! [/color] [color=indigo]A: You're absolutely right. FR has a food "tick" every 8 hours. I erred on the safe side so that you always have enough to feed your dragons![/color] [color=blue]Q: Will you add this and that?[/color] [color=indigo]A: If you have any constructive feedback or ideas on how to add new features and improve the spreadsheet, I'd be more than happy to hear it! Drop me a message or leave a post here, and I'll be sure to read it. [color=blue]Q: On the projects page, what do I do if I don't want to change the gene? Do I leave the cell blank?[/color] [color=indigo]A: No! Just enter "-" (without the quotation marks!) in the cell instead. It will be counted as a null value, so it won't tally up in the total cost. [color=blue]Q: Can you make me a custom code to do {x}?[/color] [color=indigo]A: Send me a PM! Providing it is feasable, I can write you a custom formula. [color=blue]Q: Do you have a ping list for updates and fixes? [color=indigo]A: Absolutely. Just reply to the thread that you'd like to be added and I'll see to it~[/color] [color=blue]Q: How does the Pairs and Hatchling Goals tab work? [color=indigo]A: It’s fairly simple. In the top bar, you will see a few options, and you fill in the appropriate boxes below. This tab can be deleted if you don’t need it! It’s mainly to keep track of pairs and is more tailored towards breeders who are breeding dragons to get a specific outcome and want to keep track of this. More to be added as questions are asked! [/color][/b] [img]http://i985.photobucket.com/albums/ae332/kirisch/oeuy_zpsjqfya0pb.png[/img][/center]

Bubonica

1155

March 27, 2015 13:46:01

FAQ

Q: I love the spreadsheet, but I don't have the patience to fill it all in myself. Is there an automated way to do this?
A: I'm afraid not. But you don't have to enter them all!
I can enter the data for you for a fee, though~

Q: The food calculation is too high!
A: You're absolutely right. FR has a food "tick" every 8 hours. I erred on the safe side so that you always have enough to feed your dragons!

Q: Will you add this and that?
A: If you have any constructive feedback or ideas on how to add new features and improve the spreadsheet, I'd be more than happy to hear it! Drop me a message or leave a post here, and I'll be sure to read it.

Q: On the projects page, what do I do if I don't want to change the gene? Do I leave the cell blank?
A: No! Just enter "-" (without the quotation marks!) in the cell instead. It will be counted as a null value, so it won't tally up in the total cost.

Q: Can you make me a custom code to do {x}?
A: Send me a PM! Providing it is feasable, I can write you a custom formula.

Q: Do you have a ping list for updates and fixes?
A: Absolutely. Just reply to the thread that you'd like to be added and I'll see to it~

Q: How does the Pairs and Hatchling Goals tab work?
A: It’s fairly simple. In the top bar, you will see a few options, and you fill in the appropriate boxes below. This tab can be deleted if you don’t need it! It’s mainly to keep track of pairs and is more tailored towards breeders who are breeding dragons to get a specific outcome and want to keep track of this.

More to be added as questions are asked!

Last edited on Jun 28, 2015 18:04:59 by Bubonica

[center][img]http://i985.photobucket.com/albums/ae332/kirisch/leifhoewgt_zpsmwbnitxo.png[/img] [b][color=indigo] A massive thanks to @fortytwo , @Troya , @Daftedly , @Seawings , @rgr320 and @zucchi for proofreading and helping me out! Updates and Fixes ping list; {updated 27/07, apologies for any double pings!}[/color][/b] [size=1] @Keestal @DeepflowManah @warriorjames @mcshizzle @mes3 @Rosemund @Rynne @Andi @ChibiNova @Hailey @B1ueFlame @Pseudoscience @skyarising @Kriten @Hailey @TCTLG @9r7g5h @StrykeSlammerII @Kellendraysia @kansasboys @kh180 @wretchedrabbit @AquilaFuga @MythsFlight @Rose6060 @Celestia912 @Gan @AristaHolmes @KittyAoba @Rhyfel @Loulybob @Sangam @RaveLegend @Itazu @flybeatRemix @MissMadhat @sunflic @BlueChimera @Sammyken @Thunderwalker @CrimsonMoon @sakurasake @marropo @Pity @steamworkBlue @SteelFeather84 @Arishawke @Aurai @Stac93 @Yukiira @veniroth2117@Jenavir @InkZylorn @aliena @Siscily @ChaoticBlade @Cyanea @Aurialle @swiftnordicwind @LordRaoZesseria @RainbowMoonDust [/size] [img]http://i985.photobucket.com/albums/ae332/kirisch/oeuy_zpsjqfya0pb.png[/img][/center]

Bubonica

1155

March 27, 2015 13:46:09

A massive thanks to @fortytwo , @Troya , @Daftedly , @Seawings , @rgr320 and @zucchi for proofreading and helping me out!

Updates and Fixes ping list;
{updated 27/07, apologies for any double pings!}

@Keestal @DeepflowManah @warriorjames @mcshizzle @mes3 @Rosemund @Rynne @Andi @ChibiNova @Hailey @B1ueFlame @Pseudoscience @skyarising @Kriten @Hailey @TCTLG @9r7g5h @StrykeSlammerII @Kellendraysia @kansasboys @kh180 @wretchedrabbit @AquilaFuga @MythsFlight @Rose6060 @Celestia912 @Gan @AristaHolmes @KittyAoba @Rhyfel @Loulybob @Sangam @RaveLegend @Itazu @flybeatRemix @MissMadhat @sunflic @BlueChimera @Sammyken @Thunderwalker @CrimsonMoon @sakurasake @marropo @Pity @steamworkBlue @SteelFeather84 @Arishawke @Aurai @Stac93 @Yukiira @veniroth2117@Jenavir @InkZylorn @aliena @Siscily @ChaoticBlade @Cyanea @Aurialle @swiftnordicwind @LordRaoZesseria @RainbowMoonDust

Last edited on Aug 08, 2015 11:12:14 by Bubonica

[center][img]http://i985.photobucket.com/albums/ae332/kirisch/FR/Div_zpse6470ad5.png[/img] [b][color=orange][size=4] Upcoming Features [/size][/color][color=indigo] • To be added as things are requested! [/color][color=orange][size=4] Upcoming Fixes [/size][/color][color=indigo] • Currently no bugs that I'm aware of! [/color][color=orange][size=4] Recent Updates [/size][/color][color=indigo] • Added Piebald and Paint, Some minor bugfixes [/color][color=orange][size=4] Version 3 [/size][/color][color=indigo] • More visually appealing and clear • Dragons marked as Projects automatically appear on the Projects tab • Level graphs • Added Pairs and Hatchling Goals tab • Various fixes • Fixed the Projects tab to no longer display a wall of #N/A when there is no data entered[/color] [img]http://i985.photobucket.com/albums/ae332/kirisch/FR/Div_zpse6470ad5.png[/img] [color=orange][size=4] How to update your sheets: [/size][/color] I will go with the method that is easiest for most people; Ye Olde Ctrl+C Ctrl+V [color=violet]Step 1:[/color] Follow the link and save another copy of the spreadsheet [color=violet]Step 2:[/color] Go to the ''Lair'' Tab of your old spreadsheet that has all the data [color=violet]Step 3:[/color] Select the columns - Simply click on column A, hold shift, and click on the end column. Example: I haven't changed any of the columns. Therefore I want to copy the data of all columns A-Q. I click column A, hold shift, and click on column Q, which will select all columns. [color=violet]Step 4:[/color] Copy the data (CTRL C) Go to the same corresponding sheet on the fresh copy you just saved, and paste your data (CTRL V) Do this with every sheet you entered data in, and you're all set! It takes a minute at most. [/b] [img]http://i985.photobucket.com/albums/ae332/kirisch/FR/Div_zpse6470ad5.png[/img] [b][color=orange][size=4] How to make your own custom columns and dropdown menus [/size][/color] [url=https://youtu.be/eLS_SU_RsVs][color=violet]Click here[/color][/url] I made a short, 20 second video that shows you how to customise your own columns. Rather than make a very long and possibly vague how-to here, a visual guide is much more efficient! I can also make a video on how to make your own charts, if there is enough demand for it~ [/center]

Bubonica

1155

March 27, 2015 13:59:54

Upcoming Features

• To be added as things are requested!

Upcoming Fixes

• Currently no bugs that I'm aware of!

Recent Updates

• Added Piebald and Paint, Some minor bugfixes

Version 3

• More visually appealing and clear
• Dragons marked as Projects automatically appear on the Projects tab
• Level graphs
• Added Pairs and Hatchling Goals tab
• Various fixes
• Fixed the Projects tab to no longer display a wall of #N/A when there is no data entered

How to update your sheets:

I will go with the method that is easiest for most people; Ye Olde Ctrl+C Ctrl+V

Step 1:
Follow the link and save another copy of the spreadsheet
Step 2:
Go to the ''Lair'' Tab of your old spreadsheet that has all the data
Step 3:
Select the columns - Simply click on column A, hold shift, and click on the end column.
Example: I haven't changed any of the columns. Therefore I want to copy the data of all columns A-Q.
I click column A, hold shift, and click on column Q, which will select all columns.
Step 4:
Copy the data (CTRL C)
Go to the same corresponding sheet on the fresh copy you just saved, and paste your data (CTRL V)

Do this with every sheet you entered data in, and you're all set! It takes a minute at most.

How to make your own custom columns and dropdown menus

Click here

I made a short, 20 second video that shows you how to customise your own columns. Rather than make a very long and possibly vague how-to here, a visual guide is much more efficient!

I can also make a video on how to make your own charts, if there is enough demand for it~

Last edited on Aug 10, 2015 17:46:08 by Bubonica

It looks so beautiful.

fortytwo

84

366

797

March 27, 2015 14:00:53

It looks so beautiful.

just had a look at this, and its really well made!
may have to use it *-*
i got a suggestion for something you could put in it
for the "lair" tab, i think it would be a good idea to add a "exalted" column, so a record of dragons which have been exalted is kept (but their stats don't appear on the "____charts" tabs)

KyloRen

465

1147

3521

March 27, 2015 14:06:34

just had a look at this, and its really well made!
may have to use it *-*
i got a suggestion for something you could put in it
for the "lair" tab, i think it would be a good idea to add a "exalted" column, so a record of dragons which have been exalted is kept (but their stats don't appear on the "____charts" tabs)

@Padawan

Thank you for the suggestion! I'll add to the Upcoming Features tab~

Bubonica