Guides

[center][font=Century Gothic][color=#0B5394][size=6][b]Jousama's Gene Project Tracker[/b][/size][/color][/font][/center] [size=2][center][color=#0B5394][b]Intro[/b][/color] | [url=http://www1.flightrising.com/forums/gde/2445049#post_33360836]Sheet Contents[/url] | [url=http://www1.flightrising.com/forums/gde/2445049#post_33360855]FAQ[/url][/center][/size] [size=3]Gene Projects? Delightful suffering for the whole clan. Spreadsheets? One of the best tools to getting those projects Sorted Out. Although there are several different Gene Project spreadsheets and aids floating around, I couldn't find one that had all the fiddly bits that I wanted from a project spreadsheet. So... I decided to throw mine into the mix. The Gallery tab is inspired by @Myndris' [b][url=http://www1.flightrising.com/forums/gde/2389697]Scry Saver[/url][/b], but tweaked to include genes. Aspects of this was also inspired by @Siscily's [b][url=http://www1.flightrising.com/forums/gde/2020862]Super Lair Tool[/url][/b], which is an amazing collaboration in itself. This thread also uses [url=http://flightrising.com/main.php?dragon=2177898]osiem[/url]'s dividers. [/size] [url=http://flightrising.com/main.php?dragon=2177898][img]https://dl.dropboxusercontent.com/s/lh460zuyxcuwcuq/watermid.png[/img][/url] [center][url=https://docs.google.com/spreadsheets/d/1kHUShoqG2VMhtRR2_SEjlr41RYLZBv8VqWM5-DcR6Lc/edit?usp=sharing][font=Century Gothic][color=#0B5394][size=5][b]LINK TO SPREADSHEET IN USE[/b][/size][/color][/font][/url][/center] [center][url=https://docs.google.com/spreadsheets/d/1LZmSD6M_ELNzchDNsSEIzL6zVjjNhyi8TEaAjc1HxB4/edit?usp=sharing][font=Century Gothic][color=#0B5394][size=5][b]LINK TO BLANK SPREADSHEET[/b][/size][/color][/font][/url][/center] [color=#0B5394][b]HOW TO USE[/b][/color] [LIST] [*] [b]File > Make a copy...[/b] [*] Save to your own account. [*] Fill in your gene projects. [*] (optional) Cry over how much they'll cost. [/LIST] [url=http://flightrising.com/main.php?dragon=2177898][img]https://dl.dropboxusercontent.com/s/lh460zuyxcuwcuq/watermid.png[/img][/url] [quote=Update Pinglist][center] [size=2]@/Limelight, @/Raedeshe, @/ThisIsGospel, @/SoulOfChaos, @/Auries, @/Hyleoroi, @/Rafikii, @/Carolynmbp, @/Kelpsi, @/kveikur, @/Jonquilla, @/Shadowdawn199, @/LordMalak, @/humanityxpeople, @/hume, @/Neroli, @/Pachirisu, @/Atavan. @/Hyacindy, @/Tserin, @/Kunikida, @/Galaxius, @/EnglishRose, @/MotherOfBeardies, @/Icefire55, @/WickedPixie, @/Cassiopeia, @/CrownedLadybug, @/CosmicHurricane, @/moonstrucksmorns, @/counterklock, @/wardmir, @/Trackerkitsune, @/MermaidCove, @/Anjoulas, @/bubbaberriboo, @/Felawnie, @/Teletraan You can also subscribe to the thread's pinglist widget! I'll do my best to ensure pings don't get doubled-up on, regardless of whichever way you choose to receive updates. Please let me know if you'd wish to be taken off the pinglist at any point! [center][pinglist=12727][/center][/quote] [url=http://flightrising.com/main.php?dragon=2177898][img]https://dl.dropboxusercontent.com/s/lh460zuyxcuwcuq/watermid.png[/img][/url] [center][size=3][color=#0B5394][b]UPDATE LOG[/b][/color][/size][/center] [color=#990000][b]04/04/24[/b][/color] - [b]Button[/b] [emoji=special eyes] has been added to the sheet! The Ancient expansion of [b]Orb[/b] and [b]Weaver[/b] have also been updated, along with festival genes [b]Mistral[/b] and [b]Trickmurk[/b]. [b]24/02/2024[/b] - The [b]Undertide[/b] [emoji=undertide star] gene expansion has been added along with adjustments to certain genes to take Ancient Gene Parchments into account. [b]14/02/2024[/b] - [b]Love[/b] and [b]Affection[/b] [emoji=familiar heart] have been added along with festival genes [b]Rockbreaker[/b] and [b]Crystalline[/b]. [b]23/11/2023[/b] - [b]Auraboas[/b] [emoji=auraboa star size=1] have been added to the sheet! Other genes that have been added in the interim like [b]Riot[/b] and [b]Wish[/b] have also been updated. [b]18/08/2023[/b] - Ancient Genes that are offered by [b]Glass & Gloss[/b] have been updated according to their new requirements. Baldwin recipes and Swipp trades for their modern counterparts have also been updated. [b]02/08/2023[/b] - [b]Cinder[/b] and [b]Blaze[/b] are available for all! [b]Thundercrack[/b] [emoji=lightning rune size=1] was also added. [b]21/07/2023[/b] - The new Ancient breed, [b]Sandsurges[/b] have been added! [b]Brightshine[/b] [emoji=light rune size=1], [b]Polkadot[/b], [b]Firebreather[/b], and [b]Carnivore[/b] should also be up as well. [b]22/03/2023[/b] - The new Ancient breed, [b]Aethers[/b] have been added! [b]12/01/2023[/b] - Veilspun gene expansion added! [b]05/01/2023[/b] - Tiny bug fix for [b]Total Cost of Gems[/b]. [b]03/01/2023[/b] - A bunch of changes in one go! [LIST] [*] [i]Genes Wanted[/i] ==> [i]Items Wanted[/i] [*] Scroll counts added to Wanted overview. [*] Scrolls of Eternal Youth, Maturity, and Silhouette Scrolls can now be indicated on each scry. [*] Fixed a couple of minor pricing and coding errors. [*] Genes updated to [b]Fern/Paisley[/b] [/LIST] [b]16/10/2021[/b] - [b]Ribbon[/b] and [b]Eel[/b] have been added! [b]21/08/2021[/b] - [b]Flaunt[/b] and [b]Flare[/b] have been added! Also, a silly misprice for the modern Blend gene has been fixed. [b]16/06/2021[/b] - [b]Obelisks[/b] have been added! NEW BREED NEW BREED NEW BREED [b]09/05/2021[/b] - The new [b]Eye Types[/b] have been added! Due to the changing mechanics, I've also updated the formulae and data for them. Genes have also been updated [b]15/11/2020[/b] - [b]Veilspuns[/b] have been added! I've also gone through the [b]Genes Wanted[/b] tab to add more rows for future genes and formula-locked the coding so you can extend them yourself without worrying about breaking the coding. [b]07/11/2020[/b] - [b]Swirl/Marbled[/b], [b]Stitched/Patchwork[/b], [b]Keel[/b], [b]Glowtail[/b] and [b]Braids (Gaoler)[/b] should be added! [b]12/11/2019[/b] - [b]Banescales[/b], [b]Veined[/b], [b]Fade/Blend[/b] and [b]Slime/Sludge[/b] added! Math error for ancient gene costs with 2nd place dom discount fixed. [b]09/06/2019[/b] - [b]Gaolers[/b], [b]Laced[/b] and [b]Edged[/b] added! AH prices changed to read "Fluctuating" instead of a numerical value. [b]08/01/2019[/b] - [b]Constellation[/b] and [b]Peacock[/b] added! Genes Wanted tab has been expanded so new genes aren't cut off. [b]23/10/2018[/b] - [b]Ringlets, Lionfish, Noxtide[/b] and [b]Dark Sclera[/b] added! [b]Data[/b] section now imports from a different sheet. [b]10/08/2018[/b] - [b]Starmap[/b] and [b]Constellation[/b] added! New [b]Genes Wanted[/b] section also created! [b]24/06/2018[/b] - Just a couple quick bug fixes + added a bit of code to ensure wanted genes still populate without a 'Favorite Scry' selected. [b]14/06/2018[/b] - [b][color=#990000]Complete overhaul![/color][/b] Restructured and streamlined everything. Changes include: [LIST] [*] Code tweaked to include the new eyes. [*] Viewing capabilities for multiple scries. [*] Took out the dragon level count. [*] Lists locations of genes, as well as additional materials required (for Baldwin/Swipp genes). [*] Checkboxes! [*] A project overview tab with per-page cost evaluation. [/LIST] [b]28/5/2018[/b] - Fixed a couple code bugs that messed with the image previewer for some scries. [b]27/5/2018[/b] - Spreadsheet Launch!

[size=2][center][url=http://www1.flightrising.com/forums/gde/2445049#post_2445049]Intro[/url] | [color=#0B5394][b]Sheet Contents[/b][/color] | [url=http://www1.flightrising.com/forums/gde/2445049#post_33360855]FAQ[/url][/center][/size] [center][font=Century Gothic][color=#0B5394][size=5][b][u]Sheet Contents[/u][/b][/size][/color][/font][/center] [color=#0B5394][size=4][b]OVERVIEW TAB[/b][/size][/color] [center][img]https://imgur.com/4RBQMrK.png[/img][/center] [center][color=#0B5394][b][u]Instructions[/u][/b][/color][/center] [LIST] [*]None.[/LIST] [color=#0B5394][b]Contains:[/b][/color] [LIST] [*]How-to-use [*]A quick cost reference for every project. [*]Per-page cost evaluation. [*]Total number of projects. [*]Total cost. [/LIST] [url=http://flightrising.com/main.php?dragon=33220557][img]https://dl.dropboxusercontent.com/s/lh460zuyxcuwcuq/watermid.png[/img][/url] [color=#0B5394][size=4][b]GENES WANTED TAB[/b][/size][/color] [center][img]https://i.imgur.com/hosN0vJ.png[/img][/center] [center][color=#0B5394][b][u]Instructions[/u][/b][/color][/center] [LIST] [*]Fill in the [b]Scroll[/b] and [b]Discount[/b] cells to get automatic price checks for your wanted gene/breeds.[/LIST] [color=#0B5394][b]Contains:[/b][/color] [LIST] [*]A count of the scrolls needed of each type. [*]Bulk-purchase price calculation functionality. [/LIST] [url=http://flightrising.com/main.php?dragon=33220557][img]https://dl.dropboxusercontent.com/s/lh460zuyxcuwcuq/watermid.png[/img][/url] [color=#0B5394][size=4][b]PROJECT TABS[/b][/size][/color] [center][img]https://i.imgur.com/GV3ALNv.png[/img][/center] [center][color=#0B5394][b][u]Instructions[/u][/b][/color][/center] [LIST] [*][b]Only edit[/b] the light orange cells, checkboxes and drop-down cells. Everything else is automated. [*][b]Dom Discount[/b] can be toggled between [b]None[/b], [b]1st[/b] and [b]2nd[/b]. [*][b]T:G ratio[/b] can be adjusted for your needs. Currency conversion is also available. [*][b]No. of Projects[/b], [b]Treasure Cost[/b] and [b]Gem Cost[/b] are all automatically calculated. [*]Dragons from the [b]DragonScries[/b] tab automatically populate the drop-down lists. [*]Select your scries where relevant. [*]Use of Silhouette Scrolls can be marked by the dropdown question [i]"Silhouetted?"[/i] under [b]Gender[/b]. [*]The [b]top row[/b] of checkboxes are to be marked off as you complete each project. [*]The [b]bottom row[/b] of checkboxes toggle between AH Prices and standard prices for non-MP genes. It is also used to mark Youth/Maturity scrolls, or Vial of Scattersights for the Age and Eye criteria. [/LIST] [color=#0B5394][b]Contains:[/b][/color] [LIST] [*][b]Total Number[/b] of Projects [*][b]Total Cost[/b] of Projects (Changes based on the Dom Discount selected). [*][b]T:G Ratio[/b] and [b]Conversion Tool[/b]. [*]Per-dragon [b]summary of cost and expenditure.[/b] [*][b]Requirements[/b] to obtain each part of the project (such as Baldwin Mats, Swipp items etc.). [*][b]Comparison[/b] between alternate scries. [/LIST] [url=http://flightrising.com/main.php?dragon=33220557][img]https://dl.dropboxusercontent.com/s/lh460zuyxcuwcuq/watermid.png[/img][/url] [color=#0B5394][size=4][b]DRAGONSCRIES TAB[/b][/size][/color] [center][img]https://imgur.com/jbAkIT8.png[/img][/center] [center][color=#0B5394][b][u][size=4]Instructions[/size][/u][/b][/color][/center] [LIST] [*]Fill in your [b]dragons[/b], their [b]ID numbers[/b], [b]current scries*[/b] and [b]planned scries*[/b]. [*]Data will auto-populate from the scry links. [b]DO NOT[/b] touch the cells on the right. [/LIST] [b]*[/b] - To get a scry link, right click the image of your dragon in the Scrying Workshop and select [b]Copy image address[/b]. [size=4][color=#0B5394][b]Contains:[/b][/color] [LIST] [*][b]Dragons[/b] [*]Textual overview of planned scries. [/LIST] [url=http://flightrising.com/main.php?dragon=33220557][img]https://dl.dropboxusercontent.com/s/lh460zuyxcuwcuq/watermid.png[/img][/url] [color=#0B5394][size=4][b](Hidden) DATA TAB[/b][/size][/color] [center][color=#0B5394][b][u]Instructions[/u][/b][/color][/center] [LIST] [*]Do [b]NOT[/b] touch this unless you're adding new genes or adjusting AH Prices.[/LIST] [color=#0B5394][b]Contains:[/b][/color] [LIST] [*][b]Most[/b] of the reference stuff that makes the fancy code work.

[size=2][center][url=http://www1.flightrising.com/forums/gde/2445049#post_2445049]Intro[/url] | [url=http://www1.flightrising.com/forums/gde/2445049#post_33360836]Sheet Contents[/url] | [color=#0B5394][b]FAQ[/b][/color][/center][/size] [center][font=Century Gothic][color=#0B5394][size=5][b][u]Frequently Asked Questions[/u][/b][/size][/color][/font][/center] [color=#0B5394][size=4][b][/b][/size][/color] [center]None yet.[/center] [url=http://flightrising.com/main.php?dragon=33220557][img]https://dl.dropboxusercontent.com/s/lh460zuyxcuwcuq/watermid.png[/img][/url] Pinging @Limelight, @Raedeshe, @ThisIsGospel, @SoulOfChaos, @Auries and @Hyleoroi because they were kind enough to basically beta test this when I first threw this together. I am subscribed to this thread, so don't worry about pinging me. You're free to post!

@SoulOfChaos

That's what the Instructions and colour-coding is for. :P

@SoulOfChaos Yep, the fodder counter is new!

yassssssssssssssssssssssssss

@Jousama

Very neat little spreadsheet, really like it! One thing I noticed was that I followed all the steps, selected the drop down in the gallery and it only shows me the scry, not what the dragon looks like currently. Why might this be?

@Rafikii Thank you!

Hmm... Is your dragon not an 8-digit? That is one possibility, where the code didn't work because the ID wasn't the right number of digits. ^^;

If that's not the case, try making sure your dragon's ID is properly entered.

If both of those suggestions don't work, please drop me a link to your copy of the spreadsheet so I can figure out why!

@Jousama

Hmmm, all are 8 digits and the numbers are correct so I'm a bit stumped. Sadly I'm pretty inept when it comes to spreadsheet coding.

What I am going to quickly do is cross reference your sheet to mine and see if i can find out what's the difference, if that doesn't work I'll pm you the link ^^

EDIT: Ok so I might have figured it out. When i first got the sheet i backspaced all the examples (helpful i know) and I'm presuming that cleared the code for the ID. Going to redownload the spreadsheet again and be more careful this time.

@Rafikii

I'm glad you found a solution! If you run into any more problems, just let me know.