Monday, December 17, 2007

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."

Saturday, December 1, 2007

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?