Showing posts with label Cafe Nippon useful Spreadsheet. Show all posts
Showing posts with label Cafe Nippon useful Spreadsheet. Show all posts

Friday, 1 June 2012

Tables and Decoration

I finally put myself together and converted the tables below from 大盛りグルメ食堂.

A few things about Tables and Decoration we must mention :
  • Special Guests ( Gourmet Reporter, Masked reviewer... etc. ) would only take Counters.
  • Some Clientele that come in couples, would only take 2 seat Tables even if there are Sofas available.
  • Each ❤ gives 2 points to Store Popularity ( shown in Menu > View Info > Store Info )





Sunday, 27 May 2012

Best Ingredients for Developing Dishes?

Edit: Updated some of the values. ( 4 Nov 2012 )

Maybe if I were a good programmer -- but I'm not. Plus I don't think I can be bothered to use my human eyes and brain to sort this out by hand. *sigh*

Maybe Lazycat can do it? He is the best person at solving this sort of problem using his programming code. Let's ask him! I linked him the Ingredient Effects and anxiously waited for his reply. "No problem." OMG, he said yes.

I was too excited to sit still so I left to do the dishes. Within an hour, I got the result and the code itself!

Here's what I requested for :

A list of Ingredient combinations that would only give positive effect on the dish to be developed.

With a bit of editing, I came up with two tables.
  1. Aged Cheese is not involved
  2. Aged Cheese is involved
Aged Cheese is the only Ingredient that would give all the attributes a plus. However it can be difficult to get. You might want to save it till your Dish is nearly perfect.

Before you say IT DOES NOT WORK, please read the explanation after the Tables.

Table 1. Aged Cheese not involved


Table 2. Aged Cheese involved


Okay, Let's explain.

Why does it not work sometimes? It gets tricky when the Dish in development is close to perfect. Have a look at the pictures below. We can see, when the same Ingredients are put in different orders, we get different results because it follows two rules:

  1. Whenever the attribute is over 100, it's set to 100
  2. 1st Ingredient first. -- The game actually adds up the Ingredient 1's attributes to the Dish first, calculates it, and then adds the 2nd Ingredient's up.

Take P 1, Brain Up attribute as an example:
     Top-Class Pork does +22 to Brain Up, but Gold Ice Cream is already 100, so it's set to 100, then Gold Flakes does -11, so the final result is 89.

Let's look at P 2 Brain Up attribute:
     Gold Flakes does -11, to Gold Ice Cream's 100 -- that's 89. Then Top-Class Pork's +22 brings it over 100, so we get 100 as a result.

P 1. Top-Class Pork 1st, Gold Flakes 2nd

P 2. Gold Flakes 1st, Top-Class Pork 2nd

That's why, with Table 1, when your Dishes are close to perfect, you might not get the result you expect. However, with Table 2, as long as Aged Cheese is the second Ingredient, you can expect the attributes buffed up.

Tips and facts:

- Aged Cheese and Green Onion are the only two ingredients having no negative effects.


And of course, if the result is still not as expected after you've finished reading this, it is probably just me having some typos.  :p  Please do let me know. Thank you.

Many thanks to Lazycat again for being so amazing.  :D


Seebs made a really cool applet to help us find the best possible combination based on the ingredients we have, with this tool there is no need for guess work anymore.
"... lets you enter a dish's current stats, select the ingredients you have, and it'll tell you which combination gives the largest boost to stats." - Seebs
Here's a link to it : The Cool Seebs Applet  ( Thank you, Seebs! )

Have fun cooking!

- Enna

Friday, 25 May 2012

Price/Taste/Appeal Caps

No matter how many expensive Ingredients you throw in to develop a dish, there is a maximum Price, Taste, Appeal for each Dish. This table below shows you what the limits are.

Again, I used the data from 大盛りグルメ食堂, translated and edited with some extra features. You can click the links on the bottom of the table to sort by Dish Name, Rank, Price, or Monthly Cost.


Tuesday, 22 May 2012

How to Get New Clientele

Yay! My Cafe Diablo 3 finally finished. Who would have thought I am still playing this game.  :p

Remember I was trying to finish a project? I was trying to complete this table for Clientele.

Some Clienteles come right from the start of the game, some take efforts to bring them in. Most of them after a while ( when they reach 30 points ish ), they would give out a planning proposal. If you run the plan, in most cases would bring you a new customer.

If Condition A meets first, you get a popped out message, saying so and so can now come to the restaurant.
If Condition B meets first, the new Clientele will start coming in quietly.
We just need either Condition A or B to get a new customer.

The fastest way to get new Clienteles is to run those Plans as soon as you get them.

Some Condition As are left blank because I haven't worked out what they are. It could be food or other events.

Enjoy the table! :D :D :D  ( Time to play some real Diablo 3 for me! )



Thank you, MoonBeagle, for the professional advice on how to make my spreadsheet more readable. <3

Thursday, 17 May 2012

Treasure Chests

The first time I played Cafe Nippon ( Cafeteria Nipponica ), I often had trouble getting enough fund to do Treasure Hunts. April was almost always a bad month since we pay the staff in March. I haven't had any trouble since the second time I started the game though. I decided to only serve my most expensive dish unless I am after something special.

Treasure Hunts happens on Month 1, 4, 7, 10 every year.

Food Info helps finding chests.
  • Food Info Lv1 equipped : 1.5 people
  • Food Info Lv2 equipped : 2    people
  • Food Info Lv3 equipped:  3    people
Take Local Woods as an example :
If you send one person with Food Info Lv3 equipped, that is all you need to discover a chest there.


Heavenly Hills > Kario Island > Chest #6 is unlocked when Heavenly Hills reaches ranking #1.

The info used in the table above is from  大盛りグルメ食堂. Translated and edited by Enna.

For info about what Ingredients you can get from Treasure Hunts, please click ( here ).

Friday, 11 May 2012

Treasure Hunt for Ingredients

I never have the patience to wait until Pumpkin Products finds all the routes to all the suppliers. I prefer taking all my staff out and treasure hunt for the ingredients, like Tasty Fish, Gold Flakes..etc. However it was always a little based on luck, since I have a nickname, Goldfish. ( I am very forgetful. -.- )

Thanks again to the Japanese Wiki ( 大盛りグルメ食堂 ). I managed to collect all the info and now we know exactly where things are. Please do let me know if there is any mistakes. Thank you. =D

Thursday, 10 May 2012

Ingredients and the Numbers

Edit 21 Sep 2012
Thanks to Seebs pointing out some errors in the previous Ingredient Effects Spreadsheet. It's now re-checked and updated. ( Some values are different from 大盛りグルメ食堂 but this spreadsheet is re-done based on our English Version Cafeteria Nipponica. )

I knew each ingredient has different effects on dishes. But someone actually worked out and recorded all those little numbers. I am pretty sure some people would be interested to know them all. I translated ( and guessed ) the table from the Japanese Wiki Site ( 大盛りグルメ食堂 ). Now we know how to develop dishes better.  :D

H : Health Up
B : Brain Up
T : Texture
Ar : Aroma
Ap : Appearance
V : Volume
R : Rarity
C : Charisma

You can also use the tabs on the bottom of the spreadsheet to view the info sorted in different ways. The previous spreadsheet is still kept just in case that's the one you prefer. ( use the little " < " or " > " to scroll left and right )

If you are looking for the ingredient combinations that would only give positive results, please click Here.


Thanks to MoonBeagle for helping me making the table.  ^_^

Job List

Just when I thought I had completed most of this game, I found out there are more jobs available today. Here's the list of all the jobs. Oh dear, looks like more time is needed to get them all.

I have been trying to get Ray Coffer to get the highest of everything since he is one of the first staff. He has become a 5-Star Chef. He's working on the Floor area at the moment, being a Roller Skater. It's so cute the way he moves about in the restaurant. Serena Lam is another staff that works for me right from day one. She has also finished all the training in the kitchen. At the moment she is playing the violin, being a Musician, on the Floor area.

To read about how to power leveling your staff, please click Here.

Edit : Just thought a picture would explain how the jobs are linked to each other better. Click the picture to view it in the original size. (15 Aug 2012)

Cafe Nippon Job Path
Cafe Nippon Job Path




















Monday, 7 May 2012

Cafeteria Nipponica Recipes

View the Recipes in different orders by clicking the tabs on the bottom of the spreadsheet.

Check out the newly added Cafe Nippon Page. ( A collection of useful links and FAQs )

Frequently used spreadsheets :






I want your spreadsheets! - You can have them. I'm glad you found them useful. The combined spreadsheets are sorted in its original order.

Cafe Nippon Spreadsheet - Public Edit Version - Since everyone wants to view the info differently, I've prepared this for everyone to edit. It is a separate copy of the spreadsheet above. Feel free to play with it. Have fun!

Enna will be extra happy if you can leave a comment here to encourage her to do more.  :)  Enjoy!