Hay Day database

i know for uniformity sake, you want to record all the timing of product in minutes, but word of advice, if you want to share with people, it is easier to make the time in hours and minutes as co related to in game timing... Hayday does list production time by hrs and minutes... This will makes it easier for someone thats bad at math needing to calculate how many hours is 1440 minutes (i have seriously come upon people like that not knowing how many hours are X minutes) but just want a quick look at the info...

I also keep a spreadsheet of few types regarding this game, one of them is where i keep a plot of the ingredient usage.

I did a X-axis are the production machines and Y-axis are the ingredients used in each type of machine. I find it interesting to see how some items are only used for one machine exclusively... I think that really helps if supercell keeps something like that and to let people see which ingredients are the least under utilised.

I also personally have one for myself like how the other dude in your OP mentioned listing increments by lots. I have long ago notice how as you increased the item by selling in bulk, the price differs in that if 1 butter sells for 82g 2 butter should be 164 but instead sells for 165 at max price...

@ meonhoc i find the xp awarded from boat crates are variable and hence not worth recording.
my own spreadsheet does record default price per unit for each product and most profitable to make...
Although i am in need of someone to tell me the default and max price per unit of all the new products and produce...

I also want to know what level does egg sushi, blt salad and seafood salad are unlocked.

Quote:

---

Originally Posted by mzmflo

i know for uniformity sake, you want to record all the timing of product in minutes, but word of advice, if you want to share with people, it is easier to make the time in hours and minutes as co related to in game timing... Hayday does list production time by hrs and minutes... This will makes it easier for someone thats bad at math needing to calculate how many hours is 1440 minutes (i have seriously come upon people like that not knowing how many hours are X minutes) but just want a quick look at the info...

---

What I understand is the table collect only raw data for further calculations purpose. The final results will be in human readable format on the website. Based on what info you need, you can always compute it from the raw data.

Quote:

---

I also personally have one for myself like how the other dude in your OP mentioned listing increments by lots. I have long ago notice how as you increased the item by selling in bulk, the price differs in that if 1 butter sells for 82g 2 butter should be 164 but instead sells for 165 at max price...

---

The OP points out a very interesting point (in formula):
10 milk sell at 324.
4 milk sell at (324/10)*4 round down to lower number which is 129,6 rounded to 129. Same formula for 7 milks or 3 milks.
(= ROUNDDOWN(number,decimal))

EDIT: I can't believe it, another spreadsheet from Aug 2012 points out the formula for unit price:
Max Price = Default Price * 3.6, then rounddown to lower number. Testes with all available products. Still applicable!


Default price is another parameter which is a unit price. 10 items at default price = 10*default price

Quote:

---

@ meonhoc i find the xp awarded from boat crates are variable and hence not worth recording.
my own spreadsheet does record default price per unit for each product and most profitable to make...
Although i am in need of someone to tell me the default and max price per unit of all the new products and produce...

I also want to know what level does egg sushi, blt salad and seafood salad are unlocked.

---

XP and coins for boat order are fixed, they get multiplied by the amount asked. I get records for all of them except cacao (still looking). While coin is less interesting (used to predict how much visitor pays), XP helps me decided whether I keep a product for boat or truck order. Example: 1 lobster soup on boat gives 303 XP, if I get a truck order with 650+ XP asking for 2 lobster soup and some common items, I'll do truck orders.

I saw a boat asking for egg sushi and BLT salad at level 63. BLT salad is either 62 or 63. We can only wait for people info or monitoring other's boat order.

Quote:

---

Originally Posted by meonhoc

Thank you for clarifying your intention. The difference with other spreadsheets was not clear in the original post. I thought you had difficulties collecting info. My point is you have infos floating around, even new ingredients are being discussed on the forum.

Features request (what's I'm currently have on my own spreadsheet):
- profit if make from your own stock
- profit if buy ingredients (1, 2, 3, 4...)
- total production time if ingredient production time is included
- ration price/time where time is either total production time or production time
- how much visitor pay
- how many XP points if used to fill boat
- how many diamonds needed to speed up/replace an ingredient
- what is the default price
- the most profitable product on each machine


Advance features :
- how to use product efficiently (how many boat points vs how many XP vs how many coins...in different uses)
- if I get a discount for my friends, what is the optimize price?

---

I was gonna put in some of the above info, but didn't think to go into that much detail. But maybe I will now!

Quote:

---

Originally Posted by Grumbul

I think it would be helpful to have the boat order information available...

---

Yep, I plan to put this info in as well.

Quote:

---

Originally Posted by mzmflo

i know for uniformity sake, you want to record all the timing of product in minutes, but word of advice, if you want to share with people, it is easier to make the time in hours and minutes as co related to in game timing... Hayday does list production time by hrs and minutes... This will makes it easier for someone thats bad at math needing to calculate how many hours is 1440 minutes (i have seriously come upon people like that not knowing how many hours are X minutes) but just want a quick look at the info...

I also keep a spreadsheet of few types regarding this game, one of them is where i keep a plot of the ingredient usage.

I did a X-axis are the production machines and Y-axis are the ingredients used in each type of machine. I find it interesting to see how some items are only used for one machine exclusively... I think that really helps if supercell keeps something like that and to let people see which ingredients are the least under utilised.

I also personally have one for myself like how the other dude in your OP mentioned listing increments by lots. I have long ago notice how as you increased the item by selling in bulk, the price differs in that if 1 butter sells for 82g 2 butter should be 164 but instead sells for 165 at max price...

@ meonhoc i find the xp awarded from boat crates are variable and hence not worth recording.
my own spreadsheet does record default price per unit for each product and most profitable to make...
Although i am in need of someone to tell me the default and max price per unit of all the new products and produce...

I also want to know what level does egg sushi, blt salad and seafood salad are unlocked.

---

meonhoc pretty much explains it in the above post. The raw info is what I need most right now.

Quote:

---

Originally Posted by meonhoc

... XP and coins for boat order are fixed, they get multiplied by the amount asked. I get records for all of them except cacao (still looking). While coin is less interesting (used to predict how much visitor pays), XP helps me decided whether I keep a product for boat or truck order. Example: 1 lobster soup on boat gives 303 XP, if I get a truck order with 650+ XP asking for 2 lobster soup and some common items, I'll do truck orders.

I saw a boat asking for egg sushi and BLT salad at level 63. BLT salad is either 62 or 63. We can only wait for people info or monitoring other's boat order.

---

I hadn't thought about the boat exp and coins... We'll have to see if people are willing to fill in that info on the spreadsheet. I'll make columns for them and we'll see how much info we get.

Very helpful!