Guides

[center]~[url=http://flightrising.com/main.php?p=mb&board=gde&id=1019645&pid=1019645&page=1#2704149]Changelog[/url]~[url=http://flightrising.com/main.php?p=mb&board=gde&id=1019645&pid=1019645&page=1#2704093]Column Descriptions[/url]~[/center] I am totally not up for writing a description right now, but the super-featureful hoard organizer I've been working on for the past month or so is finally ready to release. It's awesome, trust me - the problem is there are too many features that want describing! To get it, go [url=https://docs.google.com/spreadsheet/ccc?key=0Ag19aSRKlYOMdGZaaVJ4bUxlNDYzN1pnYmg4S3o5YXc&usp=sharing#gid=25]here[/url] and select 'make a copy' under 'file'. (You can also download it, but I haven't tested it on anything but Google.) Using it should be pretty self-explanatory, but I'll include a list of what everything means in the second post. The main thing to keep in mind when using it is that everything you're typing in should go to the left of the first grey line on whatever sheet you're working with; things to the right of that first line are calculated from other things and shouldn't be edited directly. It also has some hidden sheets that can be added to any page that you can edit the html of - for example, a tumblr page, like [url=http://dawntime-clan.tumblr.com/hoard]mine[/url] - to share a list of the items that you have for sale or are looking to buy. The first step in doing that is to enable web publishing, under File>Publish to the Web. Click 'Start Publishing' in the box that comes up, and a url will appear near the bottom of that box. It will look something like this: [code]https://docs.google.com/spreadsheet/pub?key=0Ag19aSRKlYOMdGZaaVJ4bUxlNDYzN1pnYmg4S3o5YXc&output=html[/code] Copy the 'key' bit - 0Ag19aSRKlYOMdGZaaVJ4bUxlNDYzN1pnYmg4S3o5YXc in my example - into a text file, then get the html code from [url=http://pastebin.com/zK1FZ0fM]here[/url] and replace each of the seven 'YourKeyHere' bits with your key, and copy the whole thing into the html of your web page.

For all sheets, the only things you should edit are to the left of the first grey bar. Anything to the right of that is calculated automatically.


Treasure: The amount of treasure that you currently have.
Gems: The number of gems that you currently have.
Lair Size: How many dragons can your lair hold?
Nests: How many nests do you currently have?


Item: An item you are selling.
Number in AH: How many of that item you are selling.
(Note: You may enter the same item more than once, for example if you have several stacks in the AH and want to list each one on its own line.)


Converted insect/meat/seafood/plant pts: How many converted points of these food types do you currently have?
Convert these insects/meat/seafood/plants: A recommendation of what items you should convert into food points, based on your settings. Often comes just short of your conversion goals.


Item: The name of the item for this row.
ID: The ID number of the item for this row - keeps the items in the same order as they appear in your hoard.
Hoard: How many of this item is in your hoard. (For items that don't stack.)
Stacks: How many full stacks of this item are in your hoard.
Part. Stack: How many of this item are in partial stacks in your hoard. (You may enter math in this column, for example '=10+15' if you have one partial stack with ten items in it and another with fifteen.)
Save: How many of this item would you like to save, for collection purposes.
Collect: Set this to 'yes' if you are collecting this item in general, to stop it from being marked to sell.
Hide Available: Hide this item from the 'available' section of your shared lists.
Hide Wishlist: Hide this item from the 'wanted' section of your shared lists.
LE?: Is the item limited edition? (This column may be filled in with any data.)
AH Value: How much treasure is this item selling for in the auction house?
Auto Sell: How much treasure would you get for selling this item directly from your hoard?
Type: What type of food points does this item give when it is converted?
Pts: How many food points does this item give when it is converted?
--
Used: How many of this item are your dragons wearing or holding?
In AH: How many of this item do you have listed in the auction house?
Pending Trade: How many of this item are you prepared to receive from Swipp?
Swipp Material: Does Swipp accept this item in trade for other items?
Collecting: How many of this item are you trying to collect to trade to Swipp?
Total Get: How many of this item are you trying to collect, in total?
--
Total Count: How many of this item do you own, in total?
Use: How many of this item should you use, or sell to others for use? (E.g. selling food according to its point value.)
AH Sell: How many of this item should you sell in the auction house, or according to its auction house value?
Auto Sell: How many of this item should you sell directly from your hoard?
Get: How many of this item should you buy or receive in trade?
Insect Pts: How many insect food points is your collection of this item worth?
Seafood Pts: How many seafood points is your collection of this item worth?
Meat Pts: How many meat food points is your collection of this item worth?
Plant Pts: How many plant food points is your collection of this item worth?
Total Value: How much treasure is your collection of this item worth?
Treasure: How much treasure should you expect to get from selling your collection of this item?


Make Trade: How many of this item do you want to receive from Swipp?
(The 'want' column shows how many of each item you want to get overall; it may be better to get these items from other sources besides Swipp.)


Dragon Name: The name of the dragon for this row.
ID#: The ID number of the dragon. (Optional)
Breed: The current breed of the dragon.
Primary Wanted: The primary scroll you plan to buy for this dragon, if any.
Secondary Wanted: The secondary scroll you plan to buy for this dragon, if any.
Tertiary Wanted: The tertiary scroll you plan to buy for this dragon, if any.
Breed Wanted: The breed change scroll you plan to buy for this dragon, if any.
Scatter?: Select 'yes' to indicate that this dragon will be scatterscrolled.
Rename?: Select 'yes' to indicate that this dragon will be renamed with a name change scroll.
Familiar: This dragon's familiar. (Leave blank if this dragon does not usually have a familiar equipped.)
Skin: The skin or accent worn by this dragon.
Apparel: The apparel items worn by this dragon.
(The smaller columns next to the Familiar, Skin, and Apparel columns will turn red if the entered item is not found in the relevant portion of the hoard, usually indicating a typo.)


Dragon Breeds: A list of every dragon type that exists in the game.
Food Type: The preferred food of each dragon type. (Whichever food type is listed first in the dragon's information.)
Primary Genes: A list of all the primary genes that exist in the game.
Secondary Genes: A list of all the secondary genes that exist in the game.
Tertiary Genes: A list of all the tertiary genes that exist in the game.
Food/day: How many food points each dragon eats per day due to normal hunger.
Lair Size: A list of possible lair sizes.
Cost to upgrade: The price in treasure to expand from a particular lair size to the next one.
Nests: A list of possible numbers of nests.
Cost to upgrade: The price in treasure to get an additional nest.


Item: The item you can receive from Swipp.
Component: The items that you trade to Swipp.
# For Trade: The amount of each component item that Swipp wants.
Wanted: The number of trades of this type that you want to make.
Collected: The number of trades of this type that you can make with the items you own.
# To Get: How many of this component you need to collect to do all the trades of this type that you want to, in total.
# Owned: How many of this component you already own.

Extra post for good luck. Let me know if you find any bugs please. [center][b]Changelog:[/b][/center] [LIST] [*]1/4/14: Added Coatl dragon and breed change item, fixed a bug in the AH Sell and Auto Sell columns for familiars and apparel. New AH Sell code (both tabs; paste this into the top row and then copy-paste from there to the others): [code]=if(and(if(S2="",0,S2)>if(Q2="",0,Q2),E2="No",I2>J2),if(S2-Q2>C2+M2,if(C2+M2=0,"",C2+M2),S2-Q2),"")[/code] New Auto Sell code (both tabs; paste this into the top row and then copy-paste from there to the others): [code]=if(and(if(S2="",0,S2)>if(Q2="",0,Q2),E2="No",I2C2+M2,if(C2+M2=0,"",C2+M2),S2-Q2),"")[/code] [*]1/8/14 Added corsages, mire skins and the chests they come in. [*]1/17/14 Added leis; added placeholders for the boreal skins and chests; added the golden bantam fangar. [*]1/21/14 Added cardinal and blue tang hippogriffs and related items; updated crates to proper names. [*]1/23/14 Added new bracer/greave apparel and fangar familiar; added autosell information to flower items; re-hid 'Wanted Things Calc' sheet (this was not supposed to be visible; I will be adding a nicely formatted one at some point instead); updated spined/maned cobra Swipp trades [*]1/24/14 Changed boreal skins to correct names; added autosell info to various items [/LIST]

@AdeleneDawner

Whoa, this is very helpful! Thank you for sharing :D

I looked over the Materials and Other tabs and the Painted Clay Pot (id#1165) is a material, not a trinket (it's listed between the Ancestral Incense and Wispy Foxtail in the hoard).

@Maki

Glad you like it! :D

And, huh. Not sure how I missed that with the pot - probably because the things above and below it are recolors of the same image and they're both Other. It's all fixed now, at any rate; thanks for telling me. ^^

@AdeleneDawner I noticed you don't have Skycats listed as Limited Edition. Just thought you'd like to know. ^_^

@Fara Got it, thanks!

*busily transferring over all my data*
YAY SPREADSHEET OMG YAAAAY

question: on the "Swipp Plans" tab, am I supposed to put the number I want in the yellow tab to the left of the grey line, or in the "want" column to the right of the line?

@AdeleneDawner It's missing the Infectionist's Armband. I think it should be near the Searing Armband? [item=Infectionist's Armband] [item=Searing Armband] Edit: Yeah, it's #927.