The BIG Chef Spreadsheet of Foods

The BIG Chef Spreadsheet of Foods

in Crafting

Posted by: Ravoc.5904

Ravoc.5904

The BIG Chef Spreadsheet of Foods

in Crafting

Posted by: TravisTrout.6803

TravisTrout.6803

Extremely cool of you to put this together, thank you.

The BIG Chef Spreadsheet of Foods

in Crafting

Posted by: Ravoc.5904

Ravoc.5904

I figure if anything it’s nice for people to have a reference – both for buyers and for crafters. I have a little more advanced version of this sheet that does all the calculations for costs, and amounts that can be crafted based on inputs of what the current price of ingredients cost and how many you actually have on hand, but it’s too big for Google Docs to handle. The apx prices on here are based on current values so they will obviously change… but it at least gives people an idea of which foods are more expensive than others.

There is one minor flaw in the sheet – it does not take in to account what happens when a single craft of a subcomponent results in multiple items. The assumption is that the ingredients listed will make at least 1 of each subcomponent, so the costs are a little higher in some cases. (ie. When you are making a food like a Bowl of Hearty Poultry Soup, one of the components required is Bowl of Herbed Poultry Stock – which you get 3 of per craft. Essentially, if you are only making one Bowl of Hearty Poultry Soup you will have 2 Bowl’s of Herbed Poultry Stock left over.)

The BIG Chef Spreadsheet of Foods

in Crafting

Posted by: hipnotode.7134

hipnotode.7134

This is awesome. Great resource all told.
I made similar things for leveling my Weaponsmithing, but nowhere near as well as this.
Well done.

The BIG Chef Spreadsheet of Foods

in Crafting

Posted by: Portal Master.9146

Portal Master.9146

Nice and professional. Thanks for the resource.

The BIG Chef Spreadsheet of Foods

in Crafting

Posted by: Katz.5143

Katz.5143

I have been waiting for just such a list! You are officially my hero now. Thanks.

It’s a kitten conspiracy. Kittens gonna be kittens. All is vain!

The BIG Chef Spreadsheet of Foods

in Crafting

Posted by: wormdrink.8409

wormdrink.8409

Wow, from one Cook to another, this is amazing. +1!

The BIG Chef Spreadsheet of Foods

in Crafting

Posted by: Witch of Doom.5739

Witch of Doom.5739

Wow, this must have been a ton of work, thanks!

The BIG Chef Spreadsheet of Foods

in Crafting

Posted by: Pandemoniac.4739

Pandemoniac.4739

This is awesome – I love being able to sort the dishes by stats. Thanks for the all the work you put into it.

Don’t ever think you know what’s right for the other person.
He might start thinking he knows what’s right for you.
—Paul Williams

The BIG Chef Spreadsheet of Foods

in Crafting

Posted by: CHOAM.7852

CHOAM.7852

Much appreciated.

The BIG Chef Spreadsheet of Foods

in Crafting

Posted by: Ravoc.5904

Ravoc.5904

Thanks everyone. :-) I’m glad you’re getting some use out of it!

Now I’m getting to the point of doing dyes and feasts. I’m not sure if I want to integrate them into this sheet or do a separate table. It’s already pretty big…

The BIG Chef Spreadsheet of Foods

in Crafting

Posted by: CHOAM.7852

CHOAM.7852

Either way works, I’d just filter by type in Excel after downloading it

The BIG Chef Spreadsheet of Foods

in Crafting

Posted by: Phenona.9457

Phenona.9457

Thank you! I just really started getting into cooking and this will make it so much easier!

Phenona-Ranger, Somaina-Mes, Shaleo-Theif, Chrytheena-Ele, Milphina-Engi, Purpleppleater Yum- Mes.
Running [Lost] in IoJ

The BIG Chef Spreadsheet of Foods

in Crafting

Posted by: mystressmegs.4750

mystressmegs.4750

Holy cow.. You put some time into that.

I love spreadsheets … lol Nice .. Thx for doing this.

The BIG Chef Spreadsheet of Foods

in Crafting

Posted by: Ravoc.5904

Ravoc.5904

I just changed a couple of things on the spreadsheet.

1. Made the font a little smaller
2. Split the stat values and stat types into different columns (so they can be sorted in the correct order)
3. A few other minor changes (moved the required level column, renamed a couple of things, etc.)

I should clarify as well, this spreadsheet only shows the foods that are consumable. Any chef recipes that are component-only are not on here. (and dyes and feasts) I think I’m going to put in another tab with all the recipes.

The BIG Chef Spreadsheet of Foods

in Crafting

Posted by: Stobor.8041

Stobor.8041

What is the purpose of this thing ? Wiki chief recipes are a lot easier to use and allow you to find things faster.

The BIG Chef Spreadsheet of Foods

in Crafting

Posted by: CHOAM.7852

CHOAM.7852

What is the purpose of this thing ? Wiki chief recipes are a lot easier to use and allow you to find things faster.

This allows me to sort by effect better than I can locate the information through the wiki

The BIG Chef Spreadsheet of Foods

in Crafting

Posted by: BGirlRhapsody.8539

BGirlRhapsody.8539

Marvellous work! What a great resource! <3

The BIG Chef Spreadsheet of Foods

in Crafting

Posted by: Pandemoniac.4739

Pandemoniac.4739

What is the purpose of this thing ? Wiki chief recipes are a lot easier to use and allow you to find things faster.

This allows me to sort by effect better than I can locate the information through the wiki

Also, you can use it to get the complete ingredients for a recipe, so you have some idea of the true cost to make it. It’s most useful not as a reference for finding recipes, but as a way of tracking recipes once you’ve discovered them.

Now all we need to do is hook it up to gw2spidy.com and get real time prices in there If things were slower at work I’d try to figure it out.

Don’t ever think you know what’s right for the other person.
He might start thinking he knows what’s right for you.
—Paul Williams

The BIG Chef Spreadsheet of Foods

in Crafting

Posted by: Ravoc.5904

Ravoc.5904

What is the purpose of this thing ? Wiki chief recipes are a lot easier to use and allow you to find things faster.

This allows me to sort by effect better than I can locate the information through the wiki

Also, you can use it to get the complete ingredients for a recipe, so you have some idea of the true cost to make it. It’s most useful not as a reference for finding recipes, but as a way of tracking recipes once you’ve discovered them.

Now all we need to do is hook it up to gw2spidy.com and get real time prices in there If things were slower at work I’d try to figure it out.

That… is an excellent idea. Let me see what I can do.

The BIG Chef Spreadsheet of Foods

in Crafting

Posted by: Ravoc.5904

Ravoc.5904

Is there another GW2 forum that people are using? This one doesn’t exactly scream awesome…