Back

Guides

Community created guides, helpful strategies, and more.
TOPIC | Automatic Project Tracking Sheet
1 2
[center][img]http://i1179.photobucket.com/albums/x400/isosDuke/Flight%20Rising/InFlight%20Raffles/cooltext117049248313401_zpsb72i8iqq.png[/img][/center] How many of you have project dragons? Wait, better question. How many of you have so many projects you can't keep them straight anymore? I used to keep track of my project on each dragon's profile, but then I would forget who needed and didn't need certain genes. I had a grand total of each gene on my profile, but that didn't help. Finally, I did something in the traditional lightning fashion and made a spreadsheet and decided it could be even better than manually filling in all the blanks. I made [url=https://docs.google.com/spreadsheets/d/12HUxML68G1o0RiTlhCEE5aQJVRTTmaawqbZtsT5k_j8/edit?usp=sharing]this beautiful spreadsheet[/url] and wanted to share it with everyone else that wants an easier way to track their projects! Now, it is locked (because it's the sheet I'm using to track my dragons), so to make your own copy, just right click the 'Project Tracking' tab and make your own to keep track of yours! I do plan on keeping this form up to date with all scroll changes to come so if you would like to be included on a ping list, I would be more than happy to keep you up to date on any changes made. Please feel free to leave any comments or suggestions! I'm always wanting to improve and all feedback is greatly appreciated! [b]Updates[/b] [list][*] March 16, 2015 - Updated gem cost of Wildclaw scrolls for price when returned to the gem marketplace [*] April 07, 2015 - Updated for Vipera and Hypnotic genes [*] April 16, 2015 - All new spreadsheet made for ease of future updating! [*] July 30, 2015 - Updated for Glimmer gene [*] August 08, 2015 - Updated for Piebald and Paint genes [*] August 31, 2015 - Updated for Peregrine gene [*] November 17, 2016 - Updated for all genes and scrolls released to date [/list] [b]Note[/b] [list][*] Scroll names are based on their original name. Secondary gene Eyespots is listed as 'eye spot' and under the 'Other' column you will have 'renaming, maturity, scatterscroll and eternal youth'. [*] Imperial and Nocturne scrolls are not listed for price as their prices vary upon user held auctions and auction house listings. Available prices are only for scrolls listed on the gem and treasure market place at their full price. [/list]
cooltext117049248313401_zpsb72i8iqq.png

How many of you have project dragons? Wait, better question. How many of you have so many projects you can't keep them straight anymore?

I used to keep track of my project on each dragon's profile, but then I would forget who needed and didn't need certain genes. I had a grand total of each gene on my profile, but that didn't help. Finally, I did something in the traditional lightning fashion and made a spreadsheet and decided it could be even better than manually filling in all the blanks.

I made this beautiful spreadsheet and wanted to share it with everyone else that wants an easier way to track their projects!

Now, it is locked (because it's the sheet I'm using to track my dragons), so to make your own copy, just right click the 'Project Tracking' tab and make your own to keep track of yours!

I do plan on keeping this form up to date with all scroll changes to come so if you would like to be included on a ping list, I would be more than happy to keep you up to date on any changes made.

Please feel free to leave any comments or suggestions! I'm always wanting to improve and all feedback is greatly appreciated!

Updates
  • March 16, 2015 - Updated gem cost of Wildclaw scrolls for price when returned to the gem marketplace
  • April 07, 2015 - Updated for Vipera and Hypnotic genes
  • April 16, 2015 - All new spreadsheet made for ease of future updating!
  • July 30, 2015 - Updated for Glimmer gene
  • August 08, 2015 - Updated for Piebald and Paint genes
  • August 31, 2015 - Updated for Peregrine gene
  • November 17, 2016 - Updated for all genes and scrolls released to date

Note
  • Scroll names are based on their original name. Secondary gene Eyespots is listed as 'eye spot' and under the 'Other' column you will have 'renaming, maturity, scatterscroll and eternal youth'.
  • Imperial and Nocturne scrolls are not listed for price as their prices vary upon user held auctions and auction house listings. Available prices are only for scrolls listed on the gem and treasure market place at their full price.

JWlblI8.png243.gif
@isosDuke Actually, I recommend doing Wildclaw gem prices because you could just wait it out and then buy it when it cycles in.
Also, how about an apparel list? I'd love to do the coding on that.
@isosDuke Actually, I recommend doing Wildclaw gem prices because you could just wait it out and then buy it when it cycles in.
Also, how about an apparel list? I'd love to do the coding on that.
o6FGGwX.pngGWb9eUn.png
ElKYM7J.pngjh3xPp0.png
mlHpBMC.png6mVFIuV.png
nWiQNX9.pngFObX7rS.png


x6q41j.png
...............................................................
8X2ZJTK.png
@Coolkid
Thanks for the idea with that! I did add the wildclaw scroll to the price update as well as a note just to say it's not available at the moment.

Hmmm, an apparel list could be nice! I don't know if I would have time (at least not right now for sure), but if anyone else wanted to make one that would be cool! There are guides that list all the apparel so they may be interested in having such a thing too!
@Coolkid
Thanks for the idea with that! I did add the wildclaw scroll to the price update as well as a note just to say it's not available at the moment.

Hmmm, an apparel list could be nice! I don't know if I would have time (at least not right now for sure), but if anyone else wanted to make one that would be cool! There are guides that list all the apparel so they may be interested in having such a thing too!
JWlblI8.png243.gif
This has been updated to reference Vipera and Hypnotic genes. I apologize for the delay.
This has been updated to reference Vipera and Hypnotic genes. I apologize for the delay.
JWlblI8.png243.gif
All new spreadsheet! It's much cleaner and easier to update than the last one (had some help from the wonderful spreadsheet master in Lightning fixing out the bugs). Spreadsheet 2.0 features: [list] [*] Instead of zeros, if you do not need a scroll that space will remain blank. [*] Now with commas! Duke loves commas! [*] Easier to update with future scrolls! [*] The formula can accommodate up to 140 dragons without you having to drag and drop the formula! [/list] Now that this one is done, I'm hoping that sometime in the future I can have a sheet for apparel. That may come out in pieces, there's a lot of apparel >.>
All new spreadsheet! It's much cleaner and easier to update than the last one (had some help from the wonderful spreadsheet master in Lightning fixing out the bugs).

Spreadsheet 2.0 features:
  • Instead of zeros, if you do not need a scroll that space will remain blank.
  • Now with commas! Duke loves commas!
  • Easier to update with future scrolls!
  • The formula can accommodate up to 140 dragons without you having to drag and drop the formula!

Now that this one is done, I'm hoping that sometime in the future I can have a sheet for apparel. That may come out in pieces, there's a lot of apparel >.>
JWlblI8.png243.gif
@isosDuke
oh man I think i love you a little
and by that i mean a lot
@isosDuke
oh man I think i love you a little
and by that i mean a lot
Taking a break from trick or treating!HJKXN.gif
@maidofbees
I'm glad you like it ^.^

Hopefully I'll be able to finish up the apparel part by early next week!
@maidofbees
I'm glad you like it ^.^

Hopefully I'll be able to finish up the apparel part by early next week!
JWlblI8.png243.gif
I apologize for not having the apparel side of the tracking sheet up. I am back to working on it though. I do have all areas regarding the apparel side locked, once completed I will unlock them.

Please let me know if you run into any issues using my spreadsheet or if you have any suggestions, comments or the like!

Thanks and I hope this helps you!
I apologize for not having the apparel side of the tracking sheet up. I am back to working on it though. I do have all areas regarding the apparel side locked, once completed I will unlock them.

Please let me know if you run into any issues using my spreadsheet or if you have any suggestions, comments or the like!

Thanks and I hope this helps you!
JWlblI8.png243.gif
Glimmer has been added to the spreadsheet!
Glimmer has been added to the spreadsheet!
JWlblI8.png243.gif
Piebald and Paint have been added to the spreadsheet!
Piebald and Paint have been added to the spreadsheet!
JWlblI8.png243.gif
1 2