Guides

Note to myself: Other item types changed to Apparel Pack. (Technically the first four do contain more than the apparel item, but there is no other category ~ And they DO contain apparel :P) [br /][columns]Cloudy Treasure Chest Fiendish Treasure Chest Clockwork Treasure Chest Gilded Treasure Chest [nextcol][color=transparent]++[/color][nextcol] Night Sky Bundle Truthy Pile of Metal Special Delivery Bundle Prismatic Bundle Pastel Lace Coffer Moonlight Lace Coffer [/columns] ----- These Marva Other items are now [u]Holiday Chest[/u]s [br /][columns] Marva's Amazing Reflection Marva's Astounding Reflection Marva's Extraordinary Reflection Marva's Fascinating Reflection Marva's Incredible Reflection Marva's Miraculous Reflection Marva's Outstanding Reflection Marva's Phenomenal Reflection Marva's Remarkable Reflection Marva's Terrific Reflection Marva's Fantastic Reflection [nextcol][color=transparent]++[/color][nextcol] Depleted Amazing Reflection Depleted Astounding Reflection Depleted Extraordinary Reflection Depleted Fascinating Reflection Depleted Fantastic Reflection Depleted Incredible Reflection Depleted Miraculous Reflection Depleted Outstanding Reflection Depleted Phenomenal Reflection Depleted Remarkable Reflection Depleted Terrific Reflection [/columns] ----- Some of these apparel sets were declared retired although my definition on the front page says otherwise. Cycled items (even if it takes YEARS) are not retired. And to top the cake with whipped cream, a ton of MP Gem prices were missing. >:c The table shows if and to what retirement and price was changed. If the name is [b]written in bold[/b] then it was also mentioned above and was changed to be an Apparel Pack. [br /][columns] [b]Item name[/b]----- Corsair's Seaspray Garb Ornate Battle Armor Goldslab Warrior Regalia Trickster's Motley Box o' Faeries Daredevil's Covers Masquerade Duds River Royalist Finery Desert Dynasty Finery Frustrating Menagerie [b]Night Sky Bundle[/b] Bard Costume Trunk Minstrel Costume Trunk Singer Costume Trunk Balladeer Costume Trunk Entertainer Trunk Aviator Gear Jewelry Box Box of Cynicism Container of Cool [b]Truthy Pile of Metal[/b] [b]Special Delivery Bundle[/b] [b]Prismatic Bundle[/b] Enchanter's Tatters Silver Sylvan Collection Crazy Cat Dragon Starter Kit Swashbuckler's Seaspray Garb Buccaneer's Seaspray Garb Privateer's Seaspray Garb Gossamer Flame Regalia [b]Pastel Lace Coffer[/b] [b]Moonlight Lace Coffer[/b] Lovely Seraph Jewelry Plum Plumes It's Wigs Heraldic Scale Trunk Prismatic Spool Polychromatic Armoire Spectral Fuchsia Trunk Vintage Starsilks [nextcol][color=transparent]++[/color][nextcol] [b]G price[/b]----- 648 285 450 210 540 405 270 700 700 648 1012 472 472 472 472 720 630 747 675 675 1012 774 1012 742 1125 675 648 648 648 945 733 733 - 648 540 855 675 1480 967 765 [nextcol][color=transparent]++[/color][nextcol] [b]Retirement[/b]----- Not retired Not retired Not retired Not retired - - - - - - Not retired - - - - - - Not retired - - - - - - - - - - - - - - Not retired - - - - - - - [/columns] These apparel packs are missing their autosell treasure price. [columns] [b]Item name[/b]----- Black Currant Plumes Cloudberry Plumes Pomegranate Plumes Mango Plumes [nextcol][color=transparent]++[/color][nextcol] [b]Treasure price[/b]----- 8800 8800 8800 8800 [/columns] ----- These apparel pieces autosell-cost 800t Duneglider Cape Firebreather Cape Gladewalker Cape Midnight Cape Twilight Cape Waverider Cape Winter Cape Woodsdrake Cape ----- The item with the ID 33697 is not [i]Classy Tail Spat[/i]. It is [i]Classy Cane[/i] The familiar Sköll is now Skoll :( Accent: Sentinal Mith (ID 27439) is supposed to be named Accent: Sentin[b][u]e[/u][/b]l Mith Those two fams were missing their gem price of 250g Rivermouth Flatbill Driftwood Baron ----- Fix for Sale-/Wishlist Gen -> Obtained through in the hidden code section The choice None wasn't really working. The block G7 to J11 was moved one down (so now G8 to J12). Mark the block and just pull it one down. If you only copy-paste it dependencies won't update. [quote name=G7] Gem MP [/quote] [quote name=J5] =IFERROR(IF($C$15="Apparel", JOIN("|", FILTER(INDIRECT(H5), INDIRECT(H5)>0, NOT(ISNUMBER(MATCH(INDIRECT(H5), SPLIT(JOIN("|", J7:J8), "|"), 0)))))), "") [/quote] [quote name=J6] =IFERROR(IF($C$15="Skins", IFERROR(JOIN("|", UNIQUE(FILTER(INDIRECT(D6), INDIRECT(D6)>0, INDIRECT(D9)=$W$14)))), IF($C$15="Apparel", JOIN("|", FILTER(INDIRECT(H6), INDIRECT(H6)>0, NOT(ISNUMBER(MATCH(INDIRECT(H6), SPLIT(JOIN("|", J7:J8), "|"), 0))))), JOIN("|", FILTER(INDIRECT(D6), INDIRECT(D6)>0, NOT(ISNUMBER(MATCH(INDIRECT(D6), SPLIT(JOIN("|", J7:J8), "|"), 0)))))))) [/quote] [quote name=J7] =IFERROR(JOIN("|", FILTER(INDIRECT(D6), INDIRECT(D6)>0, INDIRECT(D10)>0))) [/quote] [quote name=J15] =IFERROR(IFS(OR(W14="Unspecified", W14=""), "", C15="Skins", J6, W14= "Gem MP", J7, NOT(W14=""), INDEX(J6:J14, MATCH(W14, G6:G14, 0)))) [/quote] Also the row that calculates your Obtained through results needs an update. That's all cells from E28 to N28. Paste in the fix for E28, copy the cell, mark F28 to N28 and paste it. [quote name=E28] =IF($C$28, IF(AND($C$15="Skins"), IFERROR(JOIN("|", FILTER( SPLIT(INDIRECT(CONCAT(E$18,$D28)),"|", TRUE, FALSE), MATCH(SPLIT(INDIRECT(CONCAT($I$18,$D28)),"|", TRUE, FALSE),INDIRECT($D$9),0)))), IFERROR(JOIN("|", FILTER( SPLIT(INDIRECT(CONCAT(E$18,$D28)),"|", TRUE, FALSE), MATCH(SPLIT(INDIRECT(CONCAT($F$18,$D28)),"|", TRUE, FALSE),SPLIT($J$15,"|"),0)), IF(AND($C$15="Apparel", $W$14="None"), FILTER( SPLIT(INDIRECT(CONCAT(E$18,$D28)),"|", TRUE, FALSE), MATCH(SPLIT(INDIRECT(CONCAT($F$18,$D28)),"|", TRUE, FALSE),SPLIT($J$5,"|"),0)), ""))))) [/quote]

@kitc
You could simply say that you "completed" all the hib-den tasks by setting all the FALSE in column F to TRUE in the HibDen tab.

Hi! :)

Don't know if this has been corrected in the last update, but in the Food tab, item #22374 appears twice. Triad Moth is #22374 and Mustache Moth should be #22375.

Edit: Also found Ire Tweet should be #22393 (Sweet Songbird is #22392)

[center][img]https://flightrising.com/dropbox/banner_thankyouforsevenyears_anniversary.png[/img] [size=4][i][b]Update![/b][/i][/size][/center] [indent]It took a little bit longer to correct a ton of errors ~ I'm sure there are more but the more we correct the less should be left? right? D: So Scenes are new, which means new coding, changing of old one and additional columns \o/ So scenes are not just new items but also turn some codings upside down since they are technically a sort of skin for the background. You can only use one per dragon and need one for each therefore. On the other hand Vista need to applied to your account to be used by any numbers of dragons (and yourself), so you only need one ever ... As you might have noticed I sometimes use a post here and edit it when I find new errors to collect them until an update is due. I don't put any time stamps there but if you already applied all corrections until the newest edit time stamp then you can ignore the following wall of text/corrections. The first changes are need to be made in the [u]Dragons tab[/u]. Remember that you can't simply replace it by deleting and copying over a new version from the mastersheet as some other tabs depend on it. We need 4 new columns. Mark the 4 columns R to U (by clicking on the letters), rightclick and say add 4 new columns to the right. Now mark R to U again, copy, click on column letter (new) V and paste. The new ones should be as fat/slim and colored like the ones you copied. Headline for the V column is Scene and X is Vista Codes for the sanity check for each one (example row 3) [quote name=W3] =IF(OR(ISBLANK(V3),IFERROR(FILTER(Specialty!$E$3:$E, Specialty!$E$3:$E=V3, Specialty!$M$3:$M="Scene"),0)>0),"","!") [/quote] [quote name=Y3] =IF(OR(ISBLANK(V3),IFERROR(FILTER(Specialty!$E$3:$E, Specialty!$E$3:$E=V3, Specialty!$M$3:$M="Vista"),0)>0),"","!") [/quote] Now we need to adjust the [u]Specialty tab[/u]. This should be done after the Dragons changings. No new columns here, just adjustments. [LIST=1] [*]The dropdowns in column need the option for Scene by right marking all of them (or just the lower ones, up to you), right clicking, datavalidation (last point, my sheet is German so dunno if that is really what it is called) and add ,Scene to the list. Yes with the , to separate it from the others. [*]Add the new items, or at any later time. [*]New coding for column F (Needed / Used) example row 3 It will not count worn Vista as you can't exactly a single item like the scenes. [quote name=F3] =IFS(E3="", "", E3="Scroll of Renaming", COUNTIF(Dragons!$I$3:$I, "=Yes"), E3="Scroll of Eternal Youth", COUNTIF(Dragons!$J$3:$J, "=Yes"), E3="Tri-Color Scatterscroll", COUNTIF(Dragons!$O$3:$O, "=Yes"), E3="Vial of Scattersight", COUNTIF(Dragons!$P$3:$P, "=Yes"), M3="Breed Gene", COUNTIF(Dragons!$K$3:$K, SUBSTITUTE(E3, "Breed Change: ", "", 1)), M3="Prim. Gene", COUNTIF(Dragons!$L$3:$L, SUBSTITUTE(E3, "Primary Gene: ", "", 1)), M3="Sec. Gene", COUNTIF(Dragons!$M$3:$M, SUBSTITUTE(E3, "Secondary Gene: ", "", 1)), M3="Tert. Gene", COUNTIF(Dragons!$N$3:$N, SUBSTITUTE(E3, "Tertiary Gene: ", "", 1)), M3="Scene", COUNTIF(Dragons!$V$3:$V, $E3), NOT(E3=""), "") [/quote] [*]New coding for column R (Total Owned) example row 3 [quote name=R3] =SUM(MULTIPLY($G3,99),$H3,IF($M3="Scene", $F3, 0)) [/quote] [/LIST] ----- Before we talk error corrections a small ... announcement? I'm working on a small Addon collection. Tools that not everybody (if any) will find useful. You can add them to your sheet if you want or use the Addon sheet, the SHC (Super Hoard Companion). The SHC or the tools within will not work without a SHO. The SHCs purpose of outsourcing tools is to put less stress on the SHO which will then be a database only. But I will get to that once I'm done with it. They will usually don't get updates unless there is a bigger coding error. Addons that will be included and are currently worked on are: [LIST] [*]Sale/Wishlist Generator (not new, but it will be included) [*]Hoardercompanion (for people who want to track their obsessions) [*]BaldwinMatCounter (How many sludges, phosphors etc you need to 100& Baldwin) [*]SwapObtain (where you have to gather/grind to get material X for recipe/swap Y, SwapObtain needs a lot of manual input) [*]ApparelPackTracker (what items of a pack are missing/are in your hoard) [/LIST] I should be done around Light fest. If you have ideas for it or suggestion go ahead ~ ----- That was the new part, now for the loooong error correction and common sense adjustment part. Let's start with the smaller stuff [b]Food tab[/b] thanks to @Alithium8 :D Mustache Moth needs the ID 22375 Ire Tweet needs the ID 22393 ----- [b]Skins tab[/b] Accent: Sentinal Mith (ID 27439) is supposed to be named Accent: Sentin[u]e[/u]l Mith ----- [b]Familiars tab[/b] The familiar Sköll is now Skoll :( That actually upsets me. Those two fams were missing their gem price of 250 Rivermouth Flatbill Driftwood Baron ----- [b]Apparel tab[/b] The item with the ID 33697 is not Classy Tail Spat. It is Classy Cane These apparel pieces autosell-cost 800t Duneglider Cape Firebreather Cape Gladewalker Cape Midnight Cape Twilight Cape Waverider Cape Winter Cape Woodsdrake Cape ----- [b]Other tab[/b] types changed to Apparel Pack. (Technically the first four do contain more than the apparel item, but there is no other category ~ And they DO contain apparel :P) [br /][columns]Cloudy Treasure Chest Fiendish Treasure Chest Clockwork Treasure Chest Gilded Treasure Chest [nextcol][color=transparent]++[/color][nextcol] Night Sky Bundle Truthy Pile of Metal Special Delivery Bundle Prismatic Bundle Pastel Lace Coffer Moonlight Lace Coffer [/columns] ----- These Marva Other items are now [u]Holiday Chest[/u]s [br /][columns] Marva's Amazing Reflection Marva's Astounding Reflection Marva's Extraordinary Reflection Marva's Fascinating Reflection Marva's Incredible Reflection Marva's Miraculous Reflection Marva's Outstanding Reflection Marva's Phenomenal Reflection Marva's Remarkable Reflection Marva's Terrific Reflection Marva's Fantastic Reflection [nextcol][color=transparent]++[/color][nextcol] Depleted Amazing Reflection Depleted Astounding Reflection Depleted Extraordinary Reflection Depleted Fascinating Reflection Depleted Fantastic Reflection Depleted Incredible Reflection Depleted Miraculous Reflection Depleted Outstanding Reflection Depleted Phenomenal Reflection Depleted Remarkable Reflection Depleted Terrific Reflection [/columns] ----- Some of these apparel sets were declared retired although my definition on the front page says otherwise. Cycled items (even if it takes YEARS) are not retired. And to top the cake with whipped cream, a ton of MP Gem prices were missing. >:c The table shows if and to what retirement and price was changed. If the name is [b]written in bold[/b] then it was also mentioned above and was changed to be an Apparel Pack. An - means nothing was changed. [br /][columns] [b]Item name[/b]----- Corsair's Seaspray Garb Ornate Battle Armor Goldslab Warrior Regalia Trickster's Motley Box o' Faeries Daredevil's Covers Masquerade Duds River Royalist Finery Desert Dynasty Finery Frustrating Menagerie [b]Night Sky Bundle[/b] Bard Costume Trunk Minstrel Costume Trunk Singer Costume Trunk Balladeer Costume Trunk Entertainer Trunk Aviator Gear Jewelry Box Box of Cynicism Container of Cool [b]Truthy Pile of Metal[/b] [b]Special Delivery Bundle[/b] [b]Prismatic Bundle[/b] Enchanter's Tatters Silver Sylvan Collection Crazy Cat Dragon Starter Kit Swashbuckler's Seaspray Garb Buccaneer's Seaspray Garb Privateer's Seaspray Garb Gossamer Flame Regalia [b]Pastel Lace Coffer[/b] [b]Moonlight Lace Coffer[/b] Lovely Seraph Jewelry Plum Plumes It's Wigs Heraldic Scale Trunk Prismatic Spool Polychromatic Armoire Spectral Fuchsia Trunk Vintage Starsilks [nextcol][color=transparent]++[/color][nextcol] [b]G price[/b]----- 648 285 450 210 540 405 270 700 700 648 1012 472 472 472 472 720 630 747 675 675 1012 774 1012 742 1125 675 648 648 648 945 733 733 - 648 540 855 675 1480 967 765 [nextcol][color=transparent]++[/color][nextcol] [b]Retirement[/b]----- Not retired Not retired Not retired Not retired - - - - - - Not retired - - - - - - Not retired - - - - - - - - - - - - - - Not retired - - - - - - - [/columns] These apparel packs are missing their autosell treasure price. [columns] [b]Item name[/b]----- Black Currant Plumes Cloudberry Plumes Pomegranate Plumes Mango Plumes [nextcol][color=transparent]++[/color][nextcol] [b]Treasure price[/b]----- 8800 8800 8800 8800 [/columns] ----- Fix for Sale-/Wishlist Gen -> Obtained through in the hidden code section The choice None wasn't really working. The block G7 to J11 was moved one down (so now G8 to J12). Mark the block and just pull it one down. If you only copy-paste it dependencies won't update. [quote name=G7] Gem MP [/quote] [quote name=J5] =IFERROR(IF($C$15="Apparel", JOIN("|", FILTER(INDIRECT(H5), INDIRECT(H5)>0, NOT(ISNUMBER(MATCH(INDIRECT(H5), SPLIT(JOIN("|", J7:J8), "|"), 0)))))), "") [/quote] [quote name=J6] =IFERROR(IF($C$15="Skins", IFERROR(JOIN("|", UNIQUE(FILTER(INDIRECT(D6), INDIRECT(D6)>0, INDIRECT(D9)=$W$14)))), IF($C$15="Apparel", JOIN("|", FILTER(INDIRECT(H6), INDIRECT(H6)>0, NOT(ISNUMBER(MATCH(INDIRECT(H6), SPLIT(JOIN("|", J7:J8), "|"), 0))))), JOIN("|", FILTER(INDIRECT(D6), INDIRECT(D6)>0, NOT(ISNUMBER(MATCH(INDIRECT(D6), SPLIT(JOIN("|", J7:J8), "|"), 0)))))))) [/quote] [quote name=J7] =IFERROR(JOIN("|", FILTER(INDIRECT(D6), INDIRECT(D6)>0, INDIRECT(D10)>0))) [/quote] [quote name=J15] =IFERROR(IFS(OR(W14="Unspecified", W14=""), "", C15="Skins", J6, W14= "Gem MP", J7, NOT(W14=""), INDEX(J6:J14, MATCH(W14, G6:G14, 0)))) [/quote] Also the row that calculates your Obtained through results needs an update. That's all cells from E28 to N28. Paste in the fix for E28, copy the cell, mark F28 to N28 and paste it. [quote name=E28] =IF($C$28, IF(AND($C$15="Skins"), IFERROR(JOIN("|", FILTER( SPLIT(INDIRECT(CONCAT(E$18,$D28)),"|", TRUE, FALSE), MATCH(SPLIT(INDIRECT(CONCAT($I$18,$D28)),"|", TRUE, FALSE),INDIRECT($D$9),0)))), IFERROR(JOIN("|", FILTER( SPLIT(INDIRECT(CONCAT(E$18,$D28)),"|", TRUE, FALSE), MATCH(SPLIT(INDIRECT(CONCAT($F$18,$D28)),"|", TRUE, FALSE),SPLIT($J$15,"|"),0)), IF(AND($C$15="Apparel", $W$14="None"), FILTER( SPLIT(INDIRECT(CONCAT(E$18,$D28)),"|", TRUE, FALSE), MATCH(SPLIT(INDIRECT(CONCAT($F$18,$D28)),"|", TRUE, FALSE),SPLIT($J$5,"|"),0)), ""))))) [/quote] [center][b][url=https://docs.google.com/spreadsheets/d/171Mq8wqWVy9RXsFmnetXTeyShRDHz5bJ-l3KkfTN1vM/edit?usp=sharing]Quick link to the mastersheet.[/url][/b] Let us know if you stumble over any errors or typos. Suggestions are also appreciated :) [size=2]@Ethuiliel @Hawlucha @PureDark006 @Aurafur @Elaendorlien @Illyrael @Leopardmask @Calixita @Necessity4Fun @Lundlaeva @Aarresi @MamaDragon888 @rvnqn @SerenHaf @Sterlingstars @StarN1ght @TesserWings @BunnySox @mithrel @Sinuzaki @Windstrike @Neerafiki @voodoogirl360 @Cocatrics @chamilet @Alithium8[/size][/center]

Don't know if this is intentional or an error, but in FionasFeats tab. Row 58-65 seem to be a repeat of Row 50-57?

edit: I think the amount of treasure needed for the nest upgrades may be an error too. I currently have 3 nests and need 100kt to upgrade but in the sheet it says 25kt.

---

Sidenote; Thank you so much for taking up work of the sheet! When I first started FR, I found it fun to track all my stuff with the Hoard Organiser spreadsheet, and it really helped me learn alot about using/making sheets :>

Excited for the separate SHC tool. Please add me to the pinglist for updates!

@crowvidae Thanks! That sheet and another taught me how to code spreadsheets as well. :D I corrected both errors now :> There were a few more errors regarding such calculation for tabs, dragon slots, apparel slots etc. It accidentally looked up the price for the slot you have maximum. Like you have 10 apparel slots, then it falsely looked up the price for the tenth and not the eleventh D: So the following cells need an update: [quote name=K14] =IFERROR(SUM(FILTER(Settings!$N$2:$N,Settings!$M$2:$M=$E$14+5)),0) [/quote] [quote name=O14] =IFERROR(SUM(FILTER(Settings!$P$2:$P,Settings!$O$2:$O=$E$15+1)),0) [/quote] [quote name=K17] =IF(E17=5, "All unlocked", IFERROR(INDEX(Settings!$S$2:$S, MATCH(E17+1, Settings!$R$2:$R, 0)))) [/quote] [quote name=O20] =IFERROR(SUM(FILTER(Settings!$V$2:$V,Settings!$U$2:$U=$E$25+1)),0) [/quote] [quote name=K26] =IF(E27=20, "All unlocked", INDEX(Settings!$K$2:$K, MATCH(E27+1, Settings!$J$2:$J, 0))) [/quote] ----- Note to myself: Me genius forgot to add the scene recipes from Baldwin and Swipp >:c

[center][img]https://flightrising.com/dropbox/updates/bsj2020.png[/img] [size=4][i][b]Update![/b][/i][/size][/center] [indent]New stuff .. again! And Light Fest as well ... I'm not done with the SHC yet but probably at the end of the fest. The new gene was added to the tabs Specialty and the hidden Settings. The new fams were added to the Familiars tab and FionasFeats. Apparel to apparel. Chests to Other and so on. Also all the emblems are now considered Retired since the scenes will take the place of the reappearing item. Me genius forgot to add the scene recipes from Baldwin and Swipp last time >:c The apparel piece [i]Onyx Seraph Anklets[/i] was missing the s at the end. The following cells in the tab [b]Totals[/b] need an update:[/indent] [quote name=K14] =IFERROR(SUM(FILTER(Settings!$N$2:$N,Settings!$M$2:$M=$E$14+5)),0) [/quote] [quote name=O14] =IFERROR(SUM(FILTER(Settings!$P$2:$P,Settings!$O$2:$O=$E$15+1)),0) [/quote] [quote name=K17] =IF(E17=5, "All unlocked", IFERROR(INDEX(Settings!$S$2:$S, MATCH(E17+1, Settings!$R$2:$R, 0)))) [/quote] [quote name=O20] =IFERROR(SUM(FILTER(Settings!$V$2:$V,Settings!$U$2:$U=$E$25+1)),0) [/quote] [quote name=K26] =IF(E27=20, "All unlocked", INDEX(Settings!$K$2:$K, MATCH(E27+1, Settings!$J$2:$J, 0))) [/quote] [center][b][url=https://docs.google.com/spreadsheets/d/171Mq8wqWVy9RXsFmnetXTeyShRDHz5bJ-l3KkfTN1vM/edit?usp=sharing]Quick link to the mastersheet.[/url][/b] Let us know if you stumble over any errors or typos. Suggestions are also appreciated :) [size=2]@Ethuiliel @Hawlucha @PureDark006 @Aurafur @Elaendorlien @Illyrael @Leopardmask @Calixita @Necessity4Fun @Lundlaeva @Aarresi @MamaDragon888 @rvnqn @SerenHaf @Sterlingstars @StarN1ght @TesserWings @BunnySox @mithrel @Sinuzaki @Windstrike @Neerafiki @voodoogirl360 @Cocatrics @chamilet @Alithium8 @crowvidae[/size][/center]

Note to myself:
Other items type changed to Holiday Chest. They do contain a piece of apparel (or nothing in case of the depleted version) but are primarily holiday like all other Marva chests.
Marva's Marvelous Twine
Marva's Glorious Yarn
Marva's Stupendous Fiber
Marva's Astonishing Cord
Marva's Wondrous Thread
Marva's Depleted Twine
Marva's Depleted Yarn
Marva's Depleted Fiber
Marva's Depleted Cord
Marva's Depleted Thread

---

Typos in the Other tab:
Simple Pearly Jewelry was missing the first y.
Soldiscale Armor Heap must be changed to Solidscale Armor Heap
Deadeye's Leathers was missing the s at the end
It's Ornate Copper Jewelry and not Ornate Copper Jewelery
It's Ornate Gold Jewelry and not Ornate Gold Jewelery
It's Ornate Pearly Jewelry and not Ornate Pearly Jewelery
It's Ornate Iron Jewelry and not Ornate Iron Jewelery

Apparel:
Cobalt Filigree Wing Guard is without the s at the end

---

Some wrong IDs in the Other tab:
22633 - Contrast Aviator Gear
22634 - Navy Aviator Gear
22635 - Crimson Aviator Gear
22636 - Gold Aviator Gear
22637 - Emerald Aviator Gear
23162 - Gold Renaissance Box
23163 - Green Renaissance Box
23164 - Red Renaissance Box
23165 - White Renaissance Box
32286 - Obsidian Unicorn Magic
32290 - Scarlet Unicorn Magic
32294 - Seaweed Unicorn Magic
32298 - Sunrise Unicorn Magic