Guides

@aryaelaina

thanks!
i had a bad feeling last night that i hadnt fixed the AH departed import... thanks for letting me know!

i have some time today, so i'll work on getting a scry input set up, and i'll update those instructions.

@poistel @aryaelaina

okay, i've fixed the AH cards import from Departed, added the option to import dragons from scry urls to AH cards, and clarified dates.

if you want to get these updates, you'll need to grab a new copy of the sheet.

also, i just want to say thank you to you both for helping me squash these bugs. i know it's got to be irritating to have to get a new copy and import your data, but i really appreciate y'all!

@ivycrowned It works now, thank you! But I found another little problem. The symbols for the pair cards only work in bios and in the preview for forum posts but if you send the post they show up as ? as you can see here [center][columns][url=http://flightrising.com/main.php?dragon=52328634][img]http://flightrising.com/rendern/avatars/523287/52328634.png[/img][/url][url=http://flightrising.com/main.php?dragon=52167508][img]http://flightrising.com/rendern/avatars/521676/52167508.png[/img][/url][nextcol][color=transparent]...[nextcol][b]Puck x Motte[/b][br]Gaoler / Gaoler[br][br][color=#AAAAAA]Mosaic (Gaoler) / Mosaic (Gaoler)[br]Breakup (Gaoler) / Breakup (Gaoler)[br]Smoke (Gaoler) / Ghost (Gaoler)[/color][nextcol][color=transparent]...[nextcol][color=transparent].[br].[br].[br][/color][size=3][color=#c6ff00]?[/color][/size][br][size=3][color=#c6ff00]?[/color][/size][br][size=3][color=#c6ff00]?[/color][/size][/columns] [left]I copied this BBC code [url=http://flightrising.com/main.php?p=lair&id=439717&tab=dragon&did=52167508]from her bio[/url] and as you can see, there the stars work. This is the same for all of the symbols you can choose. This could be fixed by using this symbol •. As you can see here, when I replace the symbols from the sheet with the other dot it works just fine[/left] [center][columns][url=http://flightrising.com/main.php?dragon=52328634][img]http://flightrising.com/rendern/avatars/523287/52328634.png[/img][/url][url=http://flightrising.com/main.php?dragon=52167508][img]http://flightrising.com/rendern/avatars/521676/52167508.png[/img][/url][nextcol][color=transparent]...[nextcol][b]Puck x Motte[/b][br]Gaoler / Gaoler[br][br][color=#AAAAAA]Mosaic (Gaoler) / Mosaic (Gaoler)[br]Breakup (Gaoler) / Breakup (Gaoler)[br]Smoke (Gaoler) / Ghost (Gaoler)[/color][nextcol][color=transparent]...[nextcol][color=transparent].[br].[br].[br][/color][size=3][color=#c6ff00]•[/color][/size][br][size=3][color=#c6ff00]•[/color][/size][br][size=3][color=#c6ff00]•[/color][/size][/columns] [left]I could not figure out where I can add the symbol in your sheet. For pairs like my guys with only one possible color outcome it is easy to change in the code itself but maybe you could add the symbol to your list so it is easier for pairs with a wider color range :)[/left]

@AryaElaina

if you still have your copy of D's sheet from before, will the symbols show up if you generate the pair cards from there?

i didn't really do anything to the coding of the pair cards - just changed where they got their data from - so i'm trying to suss out what the problem is. it could be that the symbols aren't universal enough and FR isn't recognizing them -- like emojis used to do on non-apple devices.

just to clarify, are you saying the dot symbol currently available in the pair cards produces the "?" error, but the dot symbol you've copy-pasted in doesn't?

@ivycrowned

No they don't, they are also ?s.

I think that is the problem, though it is weird that they show up in bios and in the previews but not in the posted text.

Yes, thats right. But all symbols produce the ? error. The dot I used is the one Siscily uses in their Super Lair/Breeding Lab sheet.

I've also found a heart that works with FR: ♥

To bring some clarity here. The other symbols also never worked in D's sheet. Simply because FR doesn't support them. It's like with the familiar Sköll. The "ö" is not supported in the charset (which is stupid but well). Therefore you can't use the item= BBCode and also not search for it in the AH. It's a similar thing for the symbols. They're not part of the charset and are replaced by ? :> Some parts of FR use different charsets, so some symbols might work in places and not in others. As far as I know dragon bios also have a different charset and often support more symbols than the forum. And yes, the heart seems to be one of the very few symbols that are supported. To give you an example: Here a link to a dragon bio with the same card as below (ignore the fact that it's a bit broken) http://flightrising.com/main.php?dragon=51833520 [columns][center][url=http://flightrising.com/main.php?dragon=50371169][img]http://flightrising.com/rendern/avatars/503712/50371169.png[/img][/url][url=http://flightrising.com/main.php?dragon=14891119][img]http://flightrising.com/rendern/avatars/148912/14891119.png[/img][/url][br /][b][u]Malay x Innusha[/u][/b][br /]Nocturne[br /]100%[br /][color=transparent]++++++++++++++++++++++++++++++[/color][/center][nextcol]Prefered element(s): [emoji=ice rune][br /][br /][size=2]Ice - Shadow[/size][br /][size=1][color=#f0f2ff]?[/color][color=#e1e0ff]?[/color][color=#c8bdcd]?[/color][color=#bab9be]?[/color][color=#9c9c9e]?[/color][color=#808080]?[/color][color=#9394a9]?[/color][color=#535264]?[/color][color=#413d3e]?[/color][color=#4d484f]?[/color][color=#636268]?[/color][color=#545454]?[/color][color=#4a4945]?[/color][color=#332a25]?[/color][color=#333333]?[/color][color=#1d2225]?[/color][color=#242925]?[/color][color=#292b38]?[/color][color=#3a2e44]?[/color][/size][br /][br /][size=2]Lionfish - Ripple[/size][br /][size=1]CONCATENATE - FLIP[/size][br /][br /][size=2]Noxtide - Current[/size][br /][size=1]CONCATENATE - FLIP[/size][/columns][columns][center][b]Primary[/b][br /]Moon / Sky[br /][br /][br /][img]http://flightrising.com/dgen/preview/progeny?body=16&bodygene=25&breed=11&element=7&eyetype=1&gender=0&tert=2&tertgene=20&winggene=6&wings=2&auth=3bd5047db8c331ea934b154635f63b07aa3d34e6&dummyext=prev.png[/img][/center][nextcol][center][b]Secondary[/b][br /]White[br /]100%[br /][br /][img]http://flightrising.com/dgen/preview/progeny?body=11&bodygene=25&breed=11&element=7&eyetype=2&gender=0&tert=2&tertgene=5&winggene=6&wings=2&auth=36717168dede70d74093e36955beea5f7cba8f6e&dummyext=prev.png[/img][/center][nextcol][center][b]Tertiary[/b][br /]White[br /]100%[br /][br /][img]http://flightrising.com/dgen/preview/progeny?body=16&bodygene=5&breed=11&element=7&eyetype=1&gender=1&tert=2&tertgene=5&winggene=24&wings=2&auth=cd8ac2598779369c6353387dd82da6d54d9ff562&dummyext=prev.png[/img][/center][/columns]

Thanks Pingu!

That's what I was discovering from my googling. It looks like the ♥ symbol is the only one that will work in the forums. I've updated the sheet accordingly.

Arya, If you want to do a quick fix, you can either paste ♥ directly into the "Select Symbol" box or you can right click the box, click "Data Validation", and add ",♥" to the end of the list of items. The second option is better if you still want to use the other symbols in bios.

Yes, I have found even with D's pair cards I would have to go through and correct the symbols. I got to where I use the * at size 5.

*

_____

@ivycrowned

I just wanted to tell you I am LOVING everything you have done with this. While I loved D's tools, you have surpassed it. I know you put a to of hard work into this, and I thank you.

1 question. I know the pair workshop holds 5 pairs. I was not sure if I would be able to remove the pairs after I completed the PairKeeper. Would doing so mess up the Pairkeeper and Pair Cards?

@Endofighter ahh thank you so much!! Yes, the workshop is for active comparison and building pairs. It's self-contained in that while it references the Lair Data tab, the only tab that references [i]it[/i] is the hidden Pair Data sheet that contains all the calculations necessary for each Workshop pair to work. You can change the dragons in these pairs as much as you want. In contrast, the PairKeeper tab is meant to hold pairs indefinitely. This is the tab that the Pair Cards tab pulls from, so if you want to generate a pair card, this is where your dragons will need to be input. edit: also, i've just added the [size=5]*[/size] symbol to the pair cards. if you'd like to add this to your sheet, right click the "Select Symbol" cell, click "Data Validation" and add [b],*[/b] to the end of the list. Then, click the "Symbol Size" cell. Replace the formula in that cell with this: [quote]=IF(B26="?",1,IF(B26="*",5,3))[/quote]

@ivycrowned Thanks so much for this! I originally came on the forums looking for D's spreadsheets, not knowing they'd been deleted, and was glad to find yours (though sorry to hear about it). I was looking specifically for something that'd help me track my dragon sales from hatchery pairs, and this is perfect! Just the amount of data I want/need and adding dragons has been super easy. What is it about spreadsheets in FR that suddenly make them exciting and make me want to go "ooh, I can't wait to add new data"?? I swear, I don't feel this way about normal spreadsheets... [emoji=pearlcatcher winking size=2] Thank you again for all of your hard work and effort, I really appreciate it! It's a wonderful tool. [emoji=heart size=1]