Guides

[center][img]https://flightrising.com/dropbox/banner_whistlewhileyouwork.png[/img] [/center] [rule] [center][url=https://docs.google.com/spreadsheets/d/16zdjBKW1SK6iCtZwsEwLUMlJUBMaWHjH_eRJP0AAlzg/edit?usp=sharing]Update Sheet[/url] | [url=https://docs.google.com/spreadsheets/d/1M5W8ZpLAVvioQ_1LMOyc1hx1dbdJY2HVO30-6gqys8E/edit?usp=sharing]Blank Sheet[/url][/center] [rule] [size=4] Big update today! We've got a new trading post event and a bunch of new items. Including a new set of dinosaur apparel! Don't forget to update the sets page too. [/size] [rule] [center] @SisterofWar @SilverDeath @Mnkn10 @Rainbeetle @BottledLightning @TypeFull @Apology @mzvalkyrie @BeingOfSalt @beckyh2112 [/center]

@SpiderQueen8 can I be added to the pinglist for updates? Thank you!! :D :D this is a super helpful document!!

@almosteverything Absolutely, I'm glad you're finding it useful :D

[center][img]https://flightrising.com/dropbox/updates/givemeallthechocolate.png[/img] [/center] [rule] [center][url=https://docs.google.com/spreadsheets/d/16zdjBKW1SK6iCtZwsEwLUMlJUBMaWHjH_eRJP0AAlzg/edit?usp=sharing]Update Sheet[/url] | [url=https://docs.google.com/spreadsheets/d/1M5W8ZpLAVvioQ_1LMOyc1hx1dbdJY2HVO30-6gqys8E/edit?usp=sharing]Blank Sheet[/url][/center] [rule] [size=4] Happy Valentine's Day everyone! Just one new piece of apparel today, hope everyone has a lovely day. Regardless of if you're spending today alone or with someone special. [/size] [rule] [center] @SisterofWar @SilverDeath @Mnkn10 @Rainbeetle @BottledLightning @TypeFull @Apology @mzvalkyrie @BeingOfSalt @beckyh2112 @DarknessFalls @almosteverything [/center]

[center][img]https://flightrising.com/dropbox/updates/blaaarrrrrrg.png[/img] [/center] [rule] [center][url=https://docs.google.com/spreadsheets/d/16zdjBKW1SK6iCtZwsEwLUMlJUBMaWHjH_eRJP0AAlzg/edit?usp=sharing]Update Sheet[/url] | [url=https://docs.google.com/spreadsheets/d/1M5W8ZpLAVvioQ_1LMOyc1hx1dbdJY2HVO30-6gqys8E/edit?usp=sharing]Blank Sheet[/url][/center] [rule] [size=4] Happy Trickmurk Circus! Hope everyone's having a great day today and good luck with gathering ^-^ [/size] [rule] [center] @SisterofWar @SilverDeath @Mnkn10 @Rainbeetle @BottledLightning @TypeFull @Apology @mzvalkyrie @BeingOfSalt @beckyh2112 @DarknessFalls @almosteverything [/center]

[center][img]https://flightrising.com/dropbox/updates/noodledad.png[/img] [/center] [rule] [center][url=https://docs.google.com/spreadsheets/d/16zdjBKW1SK6iCtZwsEwLUMlJUBMaWHjH_eRJP0AAlzg/edit?usp=sharing]Update Sheet[/url] | [url=https://docs.google.com/spreadsheets/d/1M5W8ZpLAVvioQ_1LMOyc1hx1dbdJY2HVO30-6gqys8E/edit?usp=sharing]Blank Sheet[/url][/center] [rule] [size=4] Happy Mistral Jamboree! I noticed that my own copy of the tracker didn't have top row frozen for some reason while the blank copy did. So in case you're like me and the top row disappears when you scroll, simply go to the appropriate tab, and then click on "View" --> "Freeze" --> "1 row" [/size] [rule] [center] @SisterofWar @SilverDeath @Mnkn10 @Rainbeetle @BottledLightning @TypeFull @Apology @mzvalkyrie @BeingOfSalt @beckyh2112 @DarknessFalls @almosteverything [/center]

@SpiderQueen8 Fantastic job on this! May I be added to the pinglist for updates, please?

@Kweh Thanks! Added :D

[center][img]https://flightrising.com/dropbox/updates/spontainiousbontany.png[/img] [/center] [rule] [center][url=https://docs.google.com/spreadsheets/d/16zdjBKW1SK6iCtZwsEwLUMlJUBMaWHjH_eRJP0AAlzg/edit?usp=sharing]Update Sheet[/url] | [url=https://docs.google.com/spreadsheets/d/1M5W8ZpLAVvioQ_1LMOyc1hx1dbdJY2HVO30-6gqys8E/edit?usp=sharing]Blank Sheet[/url][/center] [rule] [size=4] Look at that! New gardening apparel :D don't forget to claim your gift from Galore! As always with this sort of stuff, be sure to update the "Sets" page as well using the Blank Sheet. ctrl-F "Garden" to find the category quickly and then just copy paste the 4 new colors into your sheet. Have a great day! [/size] [rule] [center] @SisterofWar @SilverDeath @Mnkn10 @Rainbeetle @BottledLightning @TypeFull @Apology @mzvalkyrie @BeingOfSalt @beckyh2112 @DarknessFalls @almosteverything @Kweh [/center]

[center][img]https://flightrising.com/dropbox/updates/gothfish.png[/img] [/center] [rule] [center][url=https://docs.google.com/spreadsheets/d/16zdjBKW1SK6iCtZwsEwLUMlJUBMaWHjH_eRJP0AAlzg/edit?usp=sharing]Update Sheet[/url] | [url=https://docs.google.com/spreadsheets/d/1M5W8ZpLAVvioQ_1LMOyc1hx1dbdJY2HVO30-6gqys8E/edit?usp=sharing]Blank Sheet[/url][/center] [rule] [size=4] New dinosaur stuff which of course means updating the "Sets" page as well using the Blank Sheet. ctrl-F "Dinosaur" to find the category quickly and then just copy paste the 3 new colors into your sheet. Also some fixes real quick. The name "Moonstone Dinosaur Shoulder Guard" is apparently the longest apparel name so far so you'll have to expand the C column a little bit if you want it to fit nicely. Also, there is an error with the "Court" set in sets. The category of "Attendant" shows 8 instead of 7 because it is counting the "Celestial Attendant" apparel by mistake. Luckily it's an easy fix, just copy paste the following code into the cell where 8 is being displayed:[/size] [code]=countif('Apparel Tracker'!C3000:C,"*Attendant*")[/code] [size=4] Finally, the "Stats" page is glitching out again (I thought I'd already fixed this but guess not?) To fix it, go to the bottom of the sheet. On the left side of "Introduction" there should be a menu button that displays "All sheets" when you hover over it. Click on it and then click data. Ignore the "#N/A" in columns G and H but find them over in columns L and M. Click on them and hit enter twice to fix each of them. I don't know why this doesn't load properly sometimes but if it ever breaks just do this. Then you can hide the data page again if you want to. Have a great day! [/size] [rule] [center] @SisterofWar @SilverDeath @Mnkn10 @Rainbeetle @BottledLightning @TypeFull @Apology @mzvalkyrie @BeingOfSalt @beckyh2112 @DarknessFalls @almosteverything @Kweh [/center]