PDA

View Full Version : Updated Spreadsheet



cwmw
06-14-11, 04:28 AM
Hi Everyone,
I was recently browsing the posted spreadsheets of exp/hr and $$$/hr for bakery and restaurant and I realised that many of them aren't updated to include the new items every week~

Thus I compiled one for personal use ~ and I hoped to share it with any of you who find it useful ~

https://spreadsheets.google.com/spre...hl=en_US#gid=1

The same normal constraints apply ~ i.e. :
1. Not taking account of the few seconds it takes to click for brownies/french toast, so its probably somewhat inaccurate
2. I also did the calculations on the assumption that all the food cooked will be sold, obviously if you are very very short of money, the best thing to do is to cook something with the highest individual sale price e.g. cappuccino, which sells for $10 each or roast chicken which sells for $8 each.:p

Anyway I really hope this helps you!!!
I hope to be able to update this excel spreadsheet weekly to give the best information possible. ! :D

Another thing for restaurant story only~ As I am only Lv 46 on my restaurant I have been unable to access statistics for any of the recipes at higher levels e.g. tiramisu, smores, lamb rack. I would greatly appreciate it if anyone would be able to post that information for me and I would gladly incorporate it into the document!!!! Thanks!!!:D

moratorro
06-14-11, 06:41 AM
When you write down a link you should write it between code, like this:

http://www.fileserve.com/file/mPhskqH/Restaurant_Story.rar otherwise it doesn't work.
That is my personal sheet: it's updated with a column where you can find level for every recipe (useful for lower levels)
Only missing data are Minestrone Soup - Smores - Stuffed mushrooms (Level 70 and 75) because I'm only at level 33.
Enjoy!

cwmw
06-14-11, 06:47 AM
https://spreadsheets.google.com/spreadsheet/ccc?key=0Auit1a1KGrhTdGU5NEw4dVBSVEUtLTh0TV9ONGRQQ nc&hl=en_US#gid=1

Sorry~ that's the link :)

cwmw
06-14-11, 06:48 AM
https://spreadsheets.google.com/spreadsheet/ccc?key=0Auit1a1KGrhTdGU5NEw4dVBSVEUtLTh0TV9ONGRQQ nc&hl=en_US#gid=1

john8472
06-15-11, 01:12 AM
Thanks a lot, very usefull

nmishii
06-15-11, 07:13 PM
cwmw, this is what is missing from your spreadsheet. I am on Level 75 and can cook all. But other than Smores at L75 and Minestrone Soup at L70 (I was at L69 when they became available), I don't know the level you can cook them.

Hrs Servings XP Cost Sales
Stove Chicken Salad 0.5 450 24 300 900
Stove Minestrone Soup 5 1500 80 1750 6000
Grill Portabello Mushroom 1 750 33 500 1500
Oven Rack of Lamb 16 2600 196 2400 10400
Oven Smores 4 1325 76 1600 5300
Stove Stuffed Mushrooms 24 2700 240 2700 13100
Oven Tiramisu 12 2400 118 2400 9600

nmishii
06-15-11, 07:16 PM
cwmw, this is what is missing from your spreadsheet. I am on Level 75 and can cook all. But other than Smores at L75 and Minestrone Soup at L70 (I was at L69 when they became available), I don't know the level you can cook them.

Hrs Servings XP Cost Sales
Stove Chicken Salad 0.5 450 24 300 900
Stove Minestrone Soup 5 1500 80 1750 6000
Grill Portabello Mushroom 1 750 33 500 1500
Oven Rack of Lamb 16 2600 196 2400 10400
Oven Smores 4 1325 76 1600 5300
Stove Stuffed Mushrooms 24 2700 240 2700 13100
Oven Tiramisu 12 2400 118 2400 9600

Oh, the formatting got lost when I hit Post Quick Reply. The first row is the heading, and there is no heading over the appliance or the dish. Let me know if you want it resent a little more readable.

cwmw
06-15-11, 07:44 PM
thanks so much!!! i'll update it now :)

cwmw
06-15-11, 07:56 PM
Updated : Now has every restaurant recipe released as of 16/6/11

kimmy42
06-17-11, 11:31 AM
Creme puffs:

1 day, 2125 plates, 1750 cost, 8500 profit, 170 xp


Chicken Alfredo:

2 hours, 625 plates, 800 cost, 2500 profit, 43 xp

kimmy42
06-17-11, 12:02 PM
Tapioca Pudding:

3 hours, 1350 plates, 1650 cost, 5400 profit, 35 xp

White Peach Tea:

1 hour, 675 plates, 880 cost, 2700 profit, 29xp

cwmw
06-18-11, 12:33 AM
Just Updated 18/6/11 With Alfredo Chicken and also Creme Puff :) Have Fun!!!

cwmw
06-24-11, 08:27 PM
Could someone please post stats for the hotdog and the mango delight? I haven't received updates yet~ THANKS!

cwmw
06-24-11, 08:43 PM
Also~ if this post is useful to you guys i'd really really appreciate it if you guys left a message :( its really discouraging when i dont see any responses, i dont know if you guys find it useful or not, cos if its not i probably wont bother updating every week

jovenal
06-24-11, 09:00 PM
Could someone please post stats for the hotdog and the mango delight? I haven't received updates yet~ THANKS!

Gourmet Hot Dog : 1 hour, 275 plates, 350 cost, 1100 profit and 35 xp

Mango Delight: 5 hours, 1025 plates, 1200 cost, 4100 profit and 57 xp

cwmw
06-24-11, 09:06 PM
Gourmet Hot Dog : 1 hour, 275 plates, 350 cost, 1100 profit and 35 xp

Mango Delight: 5 hours, 1025 plates, 1200 cost, 4100 profit and 57 xp


THANKYOU !!! Updated 25/6/11 With Hotdog and Mango Delight


https://spreadsheets.google.com/spreadsheet/ccc?key=0Auit1a1KGrhTdGU5NEw4dVBSVEUtLTh0TV9ONGRQQ nc&hl=en_US#gid=1

cwmw
06-29-11, 04:15 AM
https://spreadsheets.google.com/spreadsheet/ccc?key=0Auit1a1KGrhTdGU5NEw4dVBSVEUtLTh0TV9ONGRQQ nc&hl=en_US#gid=1

Updated spreadsheet with the drinks machine details :) still waiting for bakery ice cream machine details

ChezKat14
06-30-11, 12:02 AM
to cwmw: keep updating it! it's really useful and good to look at the recipes that I haven't unlocked yet :)

cwmw
06-30-11, 12:42 AM
https://spreadsheets.google.com/spreadsheet/ccc?key=0Auit1a1KGrhTdGU5NEw4dVBSVEUtLTh0TV9ONGRQQ nc&hl=en_US#gid=1

Updated spreadsheet with the ice cream machine details :) good luck everyone!!!!!!!!!!!!!! :o

cwmw
07-01-11, 12:03 PM
https://spreadsheets.google.com/spreadsheet/ccc?key=0Auit1a1KGrhTdGU5NEw4dVBSVEUtLTh0TV9ONGRQQ nc&hl=en_US#gid=1

Updated spreadsheet with the Berry Pie and Celebration trifle!!!!! omg they are so cute >w< :o

cwmw
07-01-11, 12:12 PM
Updated again with grilled corn too :)

cwmw
07-08-11, 11:11 AM
https://spreadsheets.google.com/spreadsheet/ccc?key=0Auit1a1KGrhTdGU5NEw4dVBSVEUtLTh0TV9ONGRQQ nc&hl=en_US#gid=1

Updated spreadsheet with the Curry and Strawberry Crepe!!!!!!!!!!!!!!!!!!!!!!!

vidaa2
07-21-11, 03:04 AM
the RS "Stuffed Mushrooms" 240 xp is correct?

nmishii
07-21-11, 08:52 AM
the RS "Stuffed Mushrooms" 240 xp is correct?

Yes, 240 xp for stuffed mushrooms is correct.

CandyNEFC
07-21-11, 10:45 AM
Wow!!! This is AMAZING!!! Thanks! Does anytime know if it's available for CC, NC and FS?

di1975
08-13-11, 07:32 PM
This is great! Still updating?

tartaros
08-14-11, 12:47 AM
A couple questions about the spreadsheet. Why are the items that are listed in the game as taking a day down as 22 hrs instead of 24? And the two day items 46 hrs instead of 48? Also, droiders just got ice cream and drink machines so that part matches up, except for the lemon-lime soda which just isn't here. It isn't grayed out as though I haven't reached the level and it isn't available. Is this a real item that apple people can make?

And are you still updating the spreadsheets?

di1975
08-14-11, 09:04 AM
I don't know if he/she is still updating but I do know that 1 day is actually 22 hours to the game. 2 days is 46 hours. Lemon lime soda is new I believe so might not be on there.

If I get a chance, I might update this....

scrappybug
08-14-11, 09:41 AM
wow this is awesome!! thanks!

LanokaHarbor
08-14-11, 04:02 PM
Incredible. You read my mind. Thanks for this spreadsheet and doing this work for us!

tartaros
08-14-11, 06:48 PM
yeah after i posted i noticed that. which is confusing because that doesnt seem to be true across all the games, but definitely in BS and RS.....weird much?

3squares
08-15-11, 07:01 PM
what does the "experience" column signify? Is this the level needed to be able to cook a given dish?

Thanx

di1975
08-15-11, 09:47 PM
3squares: experience is the total experience earned for cooking the dish and serving it. Exp per serving is one of the colored columns.