New & Improved Spreadsheets for the Advanced Chocolatier

Just as I was inspired, it appears I myself have become an inspiration. Please excuse me while I bask in the glow of admiration...Oops! Turns out the glow was just from my inflamed ego.
Seriously, Seona Dancing took my casual gaming help sheets and turned them into an advanced Chocolatier cost and profit analysis tool. She has added some great features to help bump up your score. Here is her description of the spreadsheets from her blog:
Ports & Ingredients - list of ports and ingredients that you can source there
Quests - list of quests and tasks you can expect and complete to advance
Ingredients - enter the cost(s) of ingredient(s) purchased here, update when necessary
Offer vs Cost - enter the shopkeeper's offer for your chocolates on the offer column. You can immediately see your margin and % margin, provided you've correctly entered your costs on the ingredients sheet.
Recipes - complete list of chocolate recipes and cost per recipe. Do not edit this sheet, unless there's an error or anomaly
If you have Microsoft Excel and would like to download any of our files, click here and click on "Files." If you don't have a Yahoo profile, you can sign up for free. You need a Yahoo profile to join the group.
If you don't have Excel and/or don't want a Yahoo profile, click here to view Seona Dancing's file. My original spreadsheets are here under the post appropriately titles "Chocolatier 2 Spreadsheets."

Suggestions for Spreadsheets

ptdgames wrote:
We need to update the spreadsheets with this info at some point:
price ranges for ingredients
cost range to make chocolates
price ranges for selling chocolates
separate the quests into: main quest line, side quests

I will more than likely work on the changes to the Quests, although probably not until sometime next week (my first priority is to reclaim the #1 All Time score). I'm not sure the others are necessary since the game now has most of these features. I may be persuaded to make one with the cost range of making the chocolates since the game doesn't have that feature (although that's a terrific idea for Chocolatier 3).

Suggestions? Comments? Requests?

Chocolatier 2 Spreadsheets

Inspired by MasterChief Aragon in the Chocolatier forum, I'm working on helpful spreadsheets for the fantastic Chocolatier 2: Secret Ingredients. Please let me know any additions needed, mistakes made, or any suggestions for any of the forms as they are a work in progress. Thanks and Enjoy!

Ingredients

IMHO, this is the most useful of the spreadsheets. It is set up so that you can search either by ingredient or by port. Availability of seasonal items is also listed. There are also a few hints at the bottom.

If you are printing this spreadsheet, you may want to use the print preview option on your browser first. Change the orientation to landscape and the scale to 100%. Otherwise, the print is teeny-tiny!

Click here for the Ingredients Spreadsheet

Secret Recipes

This is a list of all recipes created in the Chocolate Lab & their ingredients.

If you are printing this spreadsheet, you may want to use the print preview option on your browser first. Change the orientation to landscape and the scale to 100%. Otherwise, the print is teeny-tiny!

Click here for the Secret Recipes Spreadsheet

All Recipes

This is a list of where to find all of the recipes in the game. Unlike the original Chocolatier, you need a complete recipe book to win.

If you are this spreadsheet, you may want to use the print preview option on your browser first and change the scale to 100%. Otherwise, the print is teeny-tiny!

Click here for the All Recipes Spreadsheet

Quests

This is a description of most of the games quests. It lists the quest requirements, who requests it, and the outcome. There may be a few not listed. Please let me know if I'm missing any.

If you are printing this spreadsheet, you may want to use the print preview option on your browser first and change the scale to 100%. Otherwise, the print is teeny-tiny!

Click here for the Quests Spreadsheet