Guides

@Erayidil No problem, glad you're finding it useful ^-^

Could I be added to the pinglist?

@GlamFelix Absolutely ^-^

[center][img]https://flightrising.com/dropbox/updates/lettingyourfamiliarsplaywithsharpthings.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 Warrior's Way guys! The new Grand Exchange sure is exciting. :D New apparel has been updated, but there's also a bigger thing I want to let you guys know about. Namely, the "Sets" tab has been a bit of a giant mess up until this point and I have FINALLY fixed it all. So here are the steps to follow for those not familiar enough with spreadsheets to fix their own tabs. I hope they're clear but feel free to ask for clarification on anything. [LIST] [*][u]Step 1 - Copy paste the entire tab over from the blank version to your version [/u] Do NOT just copy tab, as this may mess up some of the references to other tabs? (I think? Have not tested granted) Instead, ctrl-A twice (because of the grid setup, the first time will only select on section) on both sheets and then ctrl-C, ctrl-V everything over. NOTE: It will take a hot second as the sheet is quite large. Just let it sit. [*][u]Step 2 - Realign the cells[/u] Everything will be sitting at the bottom of their cells. To fix this, keep selecting all and center align it all. More specifically, you're looking for this dropdown and setting it to this icon. [img]https://i.imgur.com/nctIEDW.png[/img] [*][u]Step 3 - Update the custom formatting[/u] Now this is the most important step. You're going to look at the top bar for Format -> Conditional Formatting. Then you're going to check the rules for each column that requires formatting. These are the columns that are counting your apparel and change from red to green. More specifically C-E, I-K, O-Q, and U-W. Some rules are gonna pop up on the sides, but the ranges might be very messy (I say might because I have no idea when this problem started so yours might be fine?) so we're going to fix that. The rules themselves should be fine, but here's the part you wanna look at. [center][img]https://i.imgur.com/u98vg24.png[/img][/center] Make sure the ranges are correct for both the green and the red rules. If there's any other ranges there, delete/edit them. The only thing you have to adjust between columns is the letters. Other than that, sometimes the red rules aren't bolded. If you want to be consistent you can bold them all. If a rule is missing, copy paste from a different column but MAKE SURE to make a new rule per column. It WON'T WORK if you try to shove them all into one rule. [/LIST] That's all, hopefully that all made sense. Have a great day! [/size] [rule] [center] @SisterofWar @SilverDeath @Mnkn10 @Rainbeetle @BottledLightning @TypeFull @Apology @mzvalkyrie @BeingOfSalt @beckyh2112 @DarknessFalls @almosteverything @Kweh @Mewpasaurus @Erayidil @GlamFelix [/center]

[center][img]https://flightrising.com/dropbox/updates/ff2022.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 Flameforger's Festival! Sheet has been updated :D [/size] [rule] [center] @SisterofWar @SilverDeath @Mnkn10 @Rainbeetle @BottledLightning @TypeFull @Apology @mzvalkyrie @BeingOfSalt @beckyh2112 @DarknessFalls @almosteverything @Kweh @Mewpasaurus @Erayidil @GlamFelix [/center]

This sheet is so helpful, thank you for keeping it updated! I've just come back from a big hiatus and it's so useful to track down what new sets I'm missing.

[center][img]https://flightrising.com/dropbox/updates/itsreallymoreofapirateweek.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 pirate apparel! That's exciting, which should come as no surprise if you understand the reference that is my username lol. Don't forget to check out the Grand Exchange and spend those shinies you've been digging up. Also, check out the Sets tab to add a section for the new sailor's apparel. [/size] [rule] [center] @SisterofWar @SilverDeath @Mnkn10 @Rainbeetle @BottledLightning @TypeFull @Apology @mzvalkyrie @BeingOfSalt @beckyh2112 @DarknessFalls @almosteverything @Kweh @Mewpasaurus @Erayidil @GlamFelix [/center]

[center][img]https://www1.flightrising.com/static/cms/media/starfall2022.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 Starfall Celebration! I'll be honest, I completely forgot that was today lol. But damn the skins look really good this year. I know I say this every time but I actually bought some of the skins right away this time, which almost never happens. [/size] [rule] [center] @SisterofWar @SilverDeath @Mnkn10 @Rainbeetle @BottledLightning @TypeFull @Apology @mzvalkyrie @BeingOfSalt @beckyh2112 @DarknessFalls @almosteverything @Kweh @Mewpasaurus @Erayidil @GlamFelix [/center]

thanks for the update!! you are always so fast, I really appreciate it :D

Not sure if you have been told this one, but I found a typo!

Item ID: 43499
Row: 3383
Marshlerker's Cape should be Marshlurker's Drape

(: Hope it was of some help