*MASSIVE UPDATE* Spreadsheet for Which Furnishings are Sold Where

Rainwhisper

***REGARDING MORROWIND***

I haven't had the time to update the spreadsheet to include the new Morrowind furnishings. It may be a few weeks before I do. In the interim, if anyone wants to volunteer to do so, I'd welcome the help.

***UPDATE***

All Crown Store items have been added, and integrated with the General Furnishings list, so you can now see which items are available for both in-game and crown store purchase. (There's even a handy ratio auto-computed to let you know what the gold-to-crowns ratio is for the item. If it's a really high number, it's probably a (relatively) good deal on the crown store.

This should now be every purchasable, non-crafted item in the game. This information was not scraped from the client. I went to each vendor, and entered it by hand. You can sort by racial style, cost, where it can be purchased, and item category, so you can now list every tree in the game, or every piece of Argonian furniture. You can also sort to exclude the items that are only available on the crown store.

I've also added some achievement furnishings I was missing.

Note: In some cases, the categories are my own, not ZeniMax's. I wanted to easily be able to sort to keep like items together.

Please do let me know what you think.

***END UPDATE***

As I spent more time with housing, I found myself wanting to have an easy way to answer questions like:

- What are all the different banners in the game, and where can I find them?
- What are the items for completing the quests in each zone?
- What are the different types of trees, and where can I find them?
- Which general furnishings are for sale from which vendors?

I didn't see that anyone had made a sortable spreadsheet with that information, so I did. I started with the great achievement information on Delita's site, since I couldn't see the achievements I had already earned. I then visited each vendor in each zone and typed up the relevant information.

You should be able to sort the spreadsheet by item type, cost, name, zone, etc. There's one worksheet for achievement furnishings, which are unique (except for in the capitals) and one worksheet for general goods, some of which are unique.

I used my own categories. Achievement furnishings are generally: lights, crystals, thrones, banners, undercroft, curios, totems, or statues. Curios are small enough to go on a shelf. Totems are freestanding, but not as large as statues. The categories I assigned the general furnishings should be self-explanatory.

It looks like it would cost roughly 1.3 million gold to get all the faction achievement furnishings, and another million for all the others. As a PvE player with only a couple hundred k, I found this rather disappointing, especially since I really want to get a full set of banners.

Here's a link to the spreadsheet as an Excel File.

Here's a link to the Google Doc
(The Excel file will be updated before the Google Doc, and will always be the most current version.)

I hope it's useful.

Rainwhisper

If folks think it will be useful, I'll add the Crown Store furnishings.

KimberlyannKitsuragi

Bravo!!

nooblybear

I uploaded a copy to Google spreadsheets as I don't have anything that can read XLS files on this computer.

Qyrk

Hello, awesome job!! Have you included the crafting furnishings? (I.e. from clothier etc.). I can't seem to find it.

S1ipperyJim

Great job!

Rainwhisper

Qyrk wrote: »

Hello, awesome job!! Have you included the crafting furnishings? (I.e. from clothier etc.). I can't seem to find it.

I haven't, but I can certainly add a tab for that. Thanks for the suggestion.

Rainwhisper

nooblybear wrote: »

I uploaded a copy to Google spreadsheets as I don't have anything that can read XLS files on this computer.

Great idea! I should make an official one that i update. Thanks!

Rainwhisper

@nooblybear - I've added a link to a Google Doc version as well. Thanks for thinking of that!

LadyLavina

I had horrible flashbacks to Eve Online when I saw the thread title, but that doc is actually super useful. Greatly appreciated.

Rainwhisper

LadyLavina wrote: »

I had horrible flashbacks to Eve Online when I saw the thread title, but that doc is actually super useful. Greatly appreciated.

I wrestled with trying to come up with a title that conveyed the functionality without conveying clunkiness .

Qyrk

Rainwhisper wrote: »

Qyrk wrote: »

Hello, awesome job!! Have you included the crafting furnishings? (I.e. from clothier etc.). I can't seem to find it.

I haven't, but I can certainly add a tab for that. Thanks for the suggestion.

However you think it fits that'll be good. Correct me if I'm wrong, but the ones from the crafters tend to usually be related to crafting achievements .

Will definitely be bookmarking this.

Rainwhisper

Qyrk wrote: »

However you think it fits that'll be good. Correct me if I'm wrong, but the ones from the crafters tend to usually be related to crafting achievements .

Will definitely be bookmarking this.

I added it to the Achievement's Page. I just set the zone to - Z-Crafting so they would sort, together, at the bottom.

Thanks again for the suggestion. I'm sorry for the omission!

Rainwhisper

Incidentally, the answer is, "There are 66 different trees."

MakoFore

give this man a cookie!

seriously well done and thank you

Llogwey

great info @Rainwhisper
I also have made tables (not google docs though) along with several other data and pictures on http://eso-styles.com. I hope it can help too you have both furnitures and recipes info there

Rainwhisper

@Llogwey - Clearly you and I think alike!

Obviously I need to do Crown Store and Crafted/Recipes next. I wasn't sure where to get the recipe data, but it looks like you have that all covered. If I can find an easy way to put that on a worksheet, and in a way that isn't redundant with your excellent work, I'll do that.

Thanks for your hard work!

Rainwhisper

Are the Crown Store options sufficiently well-organized that there's no need for a spreadsheet?

Kesstryl

I love that you made a spreadsheet of what the merchants sell, and most useful to me is what cities they are in, thank you!

AzraelKrieg

And bookmarked for future reference. Cheers

MarrazzMist

Thanks, google doc is easy and fast to check for quick reference

ADarklore

Thank you for your hard work!! Very much appreciated!!

Freeman

appreciate this!

CasNation

Oh thank god...I jumped on the PTS to play with housing for the first time (so I didn't spend my real resources) and was surprised at how hard it was to find what I wanted. Thanks!

kenneth.friisb16_ESO

Ah, finally found this thread again after losing it. Now I've made sure it's bookmarked

Grymmoire

nooblybear wrote: »

I uploaded a copy to Google spreadsheets as I don't have anything that can read XLS files on this computer.

Try LibreOffice, it's free and opens XLS as well as other different formats.

Rainwhisper

Crown Store Items are coming along. Just a few hundred more to enter...

Qyrk

I also want to mention, how about the achievement furnishings in outlaw refuge and dark brotherhood sanctuary?

AlienatedGoat

Thanks for this!

Rainwhisper

Qyrk wrote: »

I also want to mention, how about the achievement furnishings in outlaw refuge and dark brotherhood sanctuary?

Added to the latest version. Please take a look and let me know what you think!

Rainwhisper

Also, notice that the Sturdy Crabapple is a really good deal right now.