Hay Day Database site

Hello everyone!

I've been working on a database driven web site for Hay Day. It's still fairly rough, but it's getting there. My goal for the site is to have several lists containing several lists of information. Currently, when you first visit the site, you will see the item with a small picture, sales price, production time, xp among other things.

As we all get enjoyment out of different things and thus play differently, I'd like some input as to what you consider important information you'd like to see. My current plans are for the following lists:

Essentails - a list of most commonly used information we can see at a glance.
Income - I guess I should name this "Financials" which will contain information about cost, profit, profit per minute and any other suggestions that ppl want.
Production - List of production information such as cost, time, etc.

Please note the lists are there, but do nothing yet. You can also drill down by clicking on the image to see more detailed information about a certain product.

So what information do you find important? What information would like to see?

P.S.
Please help gather information on this Google spreadsheet! I use this info to import to the database which drives the site! Thanks to meonhoc for providing some information to help!

Almost miss this thread :(.

EDIT: Updated on 27 March: add new products from Smoothie update
Edit2: list no longer updated here. PM me if interested. I keep my website up to date.

Up to date (Nov 30th 2013) list of Price & XP from Boat order/Default Price/Time in Minutes/Exp when Collecting, including some changes made by Supercell from their Winter update. This is the content of a CSV file (can be import in Google Docs or open with Excel).

Code:

ID Processing Building Unlock Level Name Time Min Order Price Order Exp Exp Collect Instant Complete Order Value Default Price 1 Animal 44 Lobster Tail 20 8 7 2 2 4 5 1 Animal 32 Goat Milk 60 14 13 3 4 6 9 1 Animal 16 Wool 240 21 19 5 7 10 14 1 Animal 10 Bacon 360 24 22 5 8 11 15 1 Animal 27 Fish Fillet 120 21 16 11 15 1 Animal 6 Milk 480 28 25 6 10 13 18 1 Animal 1 Egg 360 104 100 11 11 27 56 2 Crop 34 Strawberry 2 2 1 1 1 1 1 2 Crop 30 Tomato 5 2 2 1 1 1 2 2 Crop 25 Chili Pepper 20 5 3 2 2 2 3 2 Crop 35 Potato 30 6 4 3 3 3 4 2 Crop 58 Lettuce 10 3 3 2 2 2 2 2 Crop 15 Pumpkin 120 10 8 5 5 5 7 2 Crop 13 Indigo 180 12 9 6 6 6 9 2 Crop 56 Rice 240 14 11 7 7 7 10 2 Crop 7 Sugarcane 360 17 13 8 8 8 12 2 Crop 5 Soybean 480 19 14 10 10 10 14 2 Crop 9 Carrot 220 14 10 7 7 7 10 2 Crop 2 Corn 45 7 5 3 3 3 5 2 Crop 1 Wheat 210 13 10 7 7 7 9 3 Fruit 66 Lemon 1020 22 15 7 7 11 3 Fruit 57 Olives 1080 26 17 9 9 13 3 Fruit 36 Cacao 1680 40 26 13 13 19 3 Fruit 26 Blackberry 1440 47 32 16 16 23 3 Fruit 22 Cherry 2040 49 33 16 16 24 3 Fruit 42 Coffee Beans 1440 37 25 12 12 18 3 Fruit 19 Raspberry 1440 50 34 17 17 23 3 Fruit 15 Apple 1800 55 36 18 18 26 4 Expansion 5 Barn Silo 8 75 4 Expansion 22 Land Fishing 8 112 5 Tools 5 Shovel 30 10 30 5 Tools 5 TNT 20 7 20 5 Tools 5 Saw 15 5 15 5 Tools 5 Axe 10 4 10 5 Tools 5 Dynamite 7 3 7 6 Feed Mill 1 Chicken Feed 5 1 1 2 2 6 Feed Mill 6 Cow Feed 10 2 1 3 4 6 Feed Mill 10 Pig Feed 20 2 2 3 4 6 Feed Mill 16 Sheep Feed 30 3 3 3 4 6 Feed Mill 32 Goat Feed 40 3 3 3 4 7 Bakery 45 Frutti di Mare Pizza 5 11 11 3 1 4 6 7 Bakery 39 Potato Bread 30 36 35 8 3 13 20 7 Bakery 26 Blackberry Muffin 60 54 52 13 4 19 29 7 Bakery 37 Spicy Pizza 45 72 69 17 3 27 39 7 Bakery 33 Pizza 45 117 112 27 3 44 63 7 Bakery 19 Raspberry Muffin 15 98 94 23 2 34 53 7 Bakery 10 Cookie 15 117 112 27 2 41 63 7 Bakery 7 Corn Bread 45 147 142 34 3 53 79 7 Bakery 2 Bread 15 208 200 32 2 64 112 8 Dairy 32 Goat Cheese 20 25 24 6 2 8 14 8 Dairy 12 Cheese 30 44 42 10 3 15 23 8 Dairy 9 Butter 60 64 61 15 4 22 34 8 Dairy 6 Cream 90 83 80 19 5 31 45 9 Sugar Mill 18 Syrup 20 16 16 4 2 5 9 9 Sugar Mill 13 White Sugar 40 27 26 6 3 9 14 9 Sugar Mill 7 Brown Sugar 90 47 45 11 5 17 25 10 Popcorn Pot 44 Chocolate Popcorn 30 17 17 4 3 5 9 10 Popcorn Pot 16 Buttered Popcorn 60 65 62 15 4 21 35 10 Popcorn Pot 25 Chili Popcorn 120 63 61 15 5 21 34 10 Popcorn Pot 8 Popcorn 150 127 122 29 8 43 69 11 Barbecue Grill 35 Baked Potato 30 56 54 13 3 22 30 11 Barbecue Grill 41 Fish and Chips 60 104 100 24 4 40 56 11 Barbecue Grill 27 Fish Burger 120 93 90 22 5 36 50 11 Barbecue Grill 11 Bacon and Eggs 120 116 112 27 5 42 63 11 Barbecue Grill 18 Hamburger 90 62 59 14 5 21 33 11 Barbecue Grill 30 Roasted Tomatoes 35 155 149 36 3 54 83 11 Barbecue Grill 9 Pancake 90 126 121 29 5 48 68 12 Pie Oven 67 Lemon Pie 60 42 40 10 4 16 23 12 Pie Oven 36 Casserole 120 82 79 19 5 29 44 12 Pie Oven 39 Shepherds Pie 180 114 110 26 6 42 61 12 Pie Oven 28 Apple Pie 150 140 135 32 6 50 75 12 Pie Oven 28 Fish Pie 120 117 113 27 5 44 63 12 Pie Oven 18 Bacon Pie 90 114 110 26 5 42 62 12 Pie Oven 34 Feta Pie 120 189 182 39 5 69 102 12 Pie Oven 15 Pumpkin Pie 100 146 140 31 5 55 78 12 Pie Oven 14 Carrot Pie 135 229 221 53 5 82 124 13 Loom 48 Red Scarf 120 77 74 18 5 27 42 13 Loom 20 Blue Sweater 60 57 55 13 4 31 31 13 Loom 17 Sweater 180 108 104 22 6 33 58 13 Loom 19 Blue Woolly Hat 150 148 143 34 6 54 80 14 Cake Oven 68 Lemon Cake 90 86 83 20 5 24 46 14 Cake Oven 36 Chocolate Cake 60 132 127 31 4 49 71 14 Cake Oven 35 Strawberry Cake 180 112 108 26 6 36 61 14 Cake Oven 38 Potato Feta Cake 240 146 140 34 7 48 79 14 Cake Oven 24 Cheesecake 180 163 156 38 6 54 88 14 Cake Oven 23 Red Berry Cake 120 165 159 38 5 57 89 14 Cake Oven 23 Cream Cake 120 159 153 32 5 59 86 14 Cake Oven 21 Carrot Cake 150 462 444 107 6 167 249 15 Mine 24 Platinum Ore 5 5 7 15 Mine 24 Gold Ore 4 4 5 15 Mine 24 Silver Ore 3 3 4 16 Smelter 25 Platinum Bar 480 61 59 14 10 19 33 16 Smelter 25 Gold Bar 960 90 87 21 13 28 49 16 Smelter 24 Silver Bar 720 76 73 18 12 24 41 17 Juice Press 30 Cherry Juice 30 24 23 6 3 9 13 17 Juice Press 34 Berry Juice 120 66 64 15 5 23 36 17 Juice Press 32 Tomato Juice 150 111 107 26 6 40 60 17 Juice Press 28 Apple Juice 90 84 81 19 5 29 45 17 Juice Press 26 Carrot Juice 180 106 102 24 6 38 57 19 Ice Cream Maker 33 Cherry Popsicle 120 89 85 20 5 28 48 19 Ice Cream Maker 39 Chocolate Ice Cream 180 181 174 42 6 55 98 19 Ice Cream Maker 34 Strawberry Ice Cream 240 171 165 40 6 60 92 19 Ice Cream Maker 29 Vanilla Ice Cream 150 176 170 41 6 61 95 20 Jam Maker 37 Blackberry Jam 360 113 109 24 8 35 61 20 Jam Maker 38 Cherry Jam 420 129 124 28 9 42 70 20 Jam Maker 50 Strawberry Jam 480 201 194 46 10 73 108 20 Jam Maker 36 Raspberry Jam 420 173 167 39 9 60 93 20 Jam Maker 35 Apple Jam 450 140 134 32 8 39 75 21 Jeweler 38 Bracelet 120 118 50 5 67 118 21 Jeweler 39 Necklace 180 169 72 6 96 169 21 Jeweler 40 Diamond Ring 240 196 84 7 112 196 22 Coffee Kiosk 45 Caffé Mocha 5 128 123 29 1 46 69 22 Coffee Kiosk 47 Hot Chocolate 10 114 109 26 2 41 61 22 Coffee Kiosk 46 Raspberry Mocha 15 151 145 19 2 101 81 22 Coffee Kiosk 42 Espresso 30 134 128 16 3 92 72 22 Coffee Kiosk 43 Caffé Latte 25 139 133 32 3 50 75 23 Soup Kitchen 46 Lobster Soup 150 315 303 40 6 90 170 23 Soup Kitchen 47 Tomato Soup 90 247 237 57 5 88 133 23 Soup Kitchen 53 Fish Soup 180 154 148 35 6 57 83 25 Candy Machine 51 Caramel Apple 120 66 31 5 82 71 25 Candy Machine 52 Toffee 90 45 21 5 30 49 25 Candy Machine 54 Chocolate 1200 119 55 15 80 128 25 Candy Machine 57 Lollipop 720 88 41 12 62 95 25 Candy Machine 60 Jelly Beans 1440 122 81 16 119 190 26 Sauce Maker 66 Lemon Curd 180 80 77 19 6 25 43 26 Sauce Maker 62 Mayonnaise 45 144 138 33 3 54 77 26 Sauce Maker 58 Olive Oil 15 190 183 44 2 72 102 26 Sauce Maker 54 Soy Sauce 25 194 187 45 3 71 105 27 Sushi Bar 59 Lobster Sushi 60 253 243 58 4 85 136 27 Sushi Bar 63 Egg Sushi 60 329 316 76 4 101 177 27 Sushi Bar 56 Sushi Roll 120 285 274 66 5 96 153 28 Salad Bar 64 Seafood Salad 90 384 369 89 5 143 207 28 Salad Bar 58 Feta Salad 105 373 359 86 5 139 201 28 Salad Bar 62 BLT Salad 120 394 379 91 5 136 212 29 Sandwich Bar 65 Bacon Toast 40 274 264 63 3 102 148 29 Sandwich Bar 66 Egg Sandwich 100 333 321 77 5 126 180 29 Sandwich Bar 61 Veggie Bagel 80 300 289 69 4 113 162 30 Smoothie Mixer 64 Berry Smoothie 75 283 272 65 4 109 152 30 Smoothie Mixer 66 Green Smoothie 45 166 160 38 3 63 89 30 Smoothie Mixer 70 Yogurt Smoothie 60 181 174 42 4 65 97

I also find out from a previous long lost spreadsheet that Max Price = Default Price *3.6. Therefore you don't need raw data for the columns MaxPrice and MaxPrice10 anymore.

This site is awesome! As a new player it will help me out A LOT :)

Quote:

Originally Posted by meonhoc

Almost miss this thread :(.

Up to date (Nov 30th 2013) list of Price & XP from Boat order/Default Price/Time in Minutes/Exp when Collecting, including some changes made by Supercell from their Winter update. This is the content of a CSV file (can be import in Google Docs or open with Excel).

I also find out from a previous long lost spreadsheet that Max Price = Default Price *3.6. Therefore you don't need raw data for the columns MaxPrice and MaxPrice10 anymore.

Thanks for all the info you've provided! What's the DumbValue column for?

I saw the MaxPrice formula in your signature earlier today. This should make things a lot easier. I suppose this should have been obvious from the start by looking at wheat going for 1 coin default price and 36 for 10 at max price!

Quote:

Originally Posted by Zurrgle

This site is awesome! As a new player it will help me out A LOT :)

Glad you like it!

DumbValue is Default Price.

Glad to help. I'll update here when I detect changes from supercell. They don't always let us know.

This is all on hay day wiki aint it?

Quote:

Originally Posted by Mac300010

This is all on hay day wiki aint it?

Yes, most of it is. But it's not in a tabulated form that's easy to read everything in one view. Not to mention it's a pain to change/add values. If I want to get the profit per minute on all items, I can put in a formula and it'll do them all. In the wiki, you would have to go in and edit every single page and add the value. If Supercell changes the way it calculates something, ppl would have to go to every item page and edit the values.

Quote:

Originally Posted by meonhoc

Code:

ProcessingBuilding,UnlockLevel,Name,TimeMin,OrderPrice,OrderExp,ExpCollect,DumbValue Animal,1,Egg,20,8,7,2,5 Animal,6,Milk,60,14,13,3,9 Animal,10,Bacon,240,21,19,5,14 Animal,16,Wool,360,24,22,5,15 Animal,27,Fish Fillet,,21,,,15 Animal,32,Goat Milk,480,28,25,6,18 Animal,44,Lobster Tail,360,104,,11,56 Bakery,2,Bread,5,11,11,3,6 Bakery,7,Corn Bread,30,36,35,8,20 Bakery,10,Cookie,60,54,52,13,29 Bakery,19,Raspberry Muffin,45,72,69,17,39 Bakery,26,Blackberry Muffin,45,117,112,27,63 Bakery,33,Pizza,15,98,94,23,53 Bakery,37,Spicy Pizza,15,117,112,27,63 Bakery,39,Potato Bread,45,147,142,39,79 Bakery,45,Frutti di Mare Pizza,15,208,200,32,112 Barbecue_Grill,9,Pancake,30,56,54,13,30 Barbecue_Grill,11,Bacon and Eggs,60,104,100,24,56 Barbecue_Grill,18,Hamburger,120,93,90,22,50 Barbecue_Grill,27,Fish Burger,120,116,112,27,63 Barbecue_Grill,30,Roasted Tomatoes,90,62,59,14,33 Barbecue_Grill,35,Baked Potato,35,155,149,36,83 Barbecue_Grill,41,Fish and Chips,90,126,121,29,68 Cake_Oven,21,Carrot Cake,90,86,83,16,46 Cake_Oven,23,Red Berry Cake,60,132,127,31,71 Cake_Oven,23,Cream Cake,180,112,108,26,61 Cake_Oven,24,Cheesecake,240,146,140,34,79 Cake_Oven,35,Strawberry Cake,180,163,156,38,88 Cake_Oven,36,Chocolate Cake,120,165,159,38,89 Cake_Oven,38,Potato Feta Cake,120,159,153,32,86 Candy_Machine,51,Caramel Apple,120,66,,31,71 Candy_Machine,52,Toffee,90,45,,21,49 Candy_Machine,54,Chocolate,1200,119,,55,128 Candy_Machine,57,Lollipop,720,88,,41,95 Candy_Machine,60,Jelly Beans,1440,122,,81,190 Coffee_Kiosk,42,Espresso,5,128,123,29,69 Coffee_Kiosk,43,Caffé Latte,10,114,109,26,61 Coffee_Kiosk,45,Caffé Mocha,15,151,145,19,81 Coffee_Kiosk,46,Raspberry Mocha,30,134,128,16,72 Coffee_Kiosk,47,Hot Chocolate,25,139,133,32,75 Crop,1,Wheat,2,2,1,1,1 Crop,2,Corn,5,2,2,1,2 Crop,5,Soybean,20,5,3,2,3 Crop,7,Sugarcane,30,6,4,3,4 Crop,9,Carrot,10,3,3,2,2 Crop,13,Indigo,120,10,8,5,7 Crop,15,Pumpkin,180,12,9,6,9 Crop,25,Chilli Pepper,240,14,11,7,10 Crop,30,Tomato,360,17,13,8,12 Crop,34,Strawberry,480,19,14,10,14 Crop,35,Potato,220,14,10,7,10 Crop,56,Rice,45,7,5,3,5 Crop,58,Lettuce,210,13,10,7,9 Dairy,6,Cream,20,25,24,6,14 Dairy,9,Butter,30,44,42,10,23 Dairy,12,Cheese,60,64,61,15,34 Dairy,32,Goat Cheese,90,83,80,19,45 Expansion,5,Barn_Silo,,,,,75 Expansion,22,Land_Fishing,,,,,112 Feed_Mill,1,Chicken Feed,5,,,1,2 Feed_Mill,6,Cow Feed,10,,,2,4 Feed_Mill,10,Pig Feed,20,,,2,4 Feed_Mill,16,Sheep Feed,30,,,3,4 Feed_Mill,32,Goat Feed,40,,,3,4 Fruit,15,Apple,,22,15,7,11 Fruit,19,Raspberry,,26,17,9,13 Fruit,22,Cherry,,40,26,13,19 Fruit,26,Blackberry,,47,32,16,23 Fruit,36,Cacao,,49,33,16,24 Fruit,42,Coffee Beans,,37,25,12,18 Fruit,57,Olives,,50,34,17,23 Ice_Cream_Maker,29,Vanilla Ice Cream,120,89,85,20,48 Ice_Cream_Maker,33,Cherry Popsicle,180,181,174,42,98 Ice_Cream_Maker,34,Strawberry Ice Cream,240,171,165,40,92 Ice_Cream_Maker,39,Chocolate Ice Cream,150,176,170,41,95 Jam_Maker,35,Apple Jam,360,113,109,24,61 Jam_Maker,36,Raspberry Jam,420,129,124,28,70 Jam_Maker,37,Blackberry Jam,480,201,194,46,108 Jam_Maker,38,Cherry Jam,420,173,167,39,93 Jam_Maker,50,Strawberry Jam,450,140,134,32,75 Jeweler,38,Bracelet,120,,,50,118 Jeweler,39,Necklace,180,,,72,169 Jeweler,40,Diamond Ring,240,,,84,196 Juice_Press,26,Carrot Juice,30,24,23,6,13 Juice_Press,28,Apple Juice,120,66,64,15,36 Juice_Press,30,Cherry Juice,150,111,107,26,60 Juice_Press,32,Tomato Juice,90,84,81,19,45 Juice_Press,34,Berry Juice,180,106,102,24,57 Loom,17,Sweater,120,77,74,18,42 Loom,19,Blue Woolly Hat,60,57,55,13,31 Loom,20,Blue Sweater,180,108,104,22,58 Loom,48,Red Scarf,150,148,143,34,80 Mine,24,Silver Ore,,,,3,4 Mine,24,Gold Ore,,,,4,5 Mine,24,Platinum Ore,,,,5,7 Pie_Oven,14,Carrot Pie,60,42,40,10,23 Pie_Oven,15,Pumpkin Pie,120,82,79,19,44 Pie_Oven,18,Bacon Pie,180,114,110,26,61 Pie_Oven,28,Apple Pie,150,140,135,32,75 Pie_Oven,28,Fish Pie,120,117,113,27,63 Pie_Oven,34,Feta Pie,90,114,110,26,62 Pie_Oven,36,Casserole,120,189,182,39,102 Pie_Oven,39,Shepherds Pie,100,146,140,31,78 Popcorn_Pot,8,Popcorn,30,17,17,4,9 Popcorn_Pot,16,Buttered Popcorn,60,65,62,15,35 Popcorn_Pot,25,Chilli Popcorn,120,63,61,15,34 Popcorn_Pot,44,Chocolate Popcorn,150,127,122,29,69 Salad_Bar,58,Feta Salad,90,384,369,89,207 Salad_Bar,62,BLT Salad,105,373,359,86,201 Salad_Bar,64,Seafood Salad,120,394,379,91,212 Sauce_Maker,54,Soy Sauce,180,80,77,19,43 Sauce_Maker,58,Olive Oil,45,144,138,33,77 Sauce_Maker,62,Mayonnaise,15,190,183,44,102 Smelter,24,Silver Bar,480,61,59,14,33 Smelter,25,Platinum Bar,960,90,87,21,49 Smelter,25,Gold Bar,720,76,73,18,41 Soup_Kitchen,46,Lobster Soup,150,315,303,40,170 Soup_Kitchen,47,Tomato Soup,90,247,237,57,133 Soup_Kitchen,53,Fish Soup,180,154,148,35,83 Sugar_Mill,7,Brown Sugar,20,16,16,4,9 Sugar_Mill,13,White Sugar,40,27,26,6,14 Sugar_Mill,18,Syrup,90,47,45,11,25 Sushi_Bar,56,Sushi Roll,60,253,243,58,136 Sushi_Bar,59,Lobster Sushi,60,329,316,76,177 Sushi_Bar,63,Egg Sushi,120,285,274,66,153 Tools,5,Axe,,10,,,10 Tools,5,Saw,,15,,,15 Tools,5,Dynamite,,7,,,7 Tools,5,TNT,,20,,,20 Tools,5,Shovel,,30,,,30

btw, am I right to assume OrderPrice and OrderExp are for boat orders and exp?
I've found some differences in our data... you have carrot cake CollectExp at 16 and I have it at 20 which I got from the wikia.

Quote:

Originally Posted by NeoTurtle

btw, am I right to assume OrderPrice and OrderExp are for boat orders and exp?
I've found some differences in our data... you have carrot cake CollectExp at 16 and I have it at 20 which I got from the wikia.

You are right for OrderPrice & OrderXP.

20xp is correct for carrot cake. I retrieve CollectXP from an old source and did not verify all info. Could you make a list of all diff value, I'll recheck in my game as I already unlock all products?

Boat Request Quantities

Hi Neoturtle,

Nice site, very helpful!

I have been tracking boat request quantities for a while now, it has become a obsession :o:D

Below my TOTAL quantities per boat, plus on which level the boat docked.

Hope this helps?

Code:

Product,Total Quantity Product,Hay Day Level Apple,36,52 Apple Jam,12,90 Apple Juice,12,56 Apple Pie,8,62 Bacon,28,70 Bacon And Egg,9,62 Baked Potato,8,88 Berry Juice,9,70 Blackberry,18,53 Blackberry Jam,6,79 Blackberry Muffin,9,32 Blue Sweater,9,45 Blue Woolly Hat,16,60 Bread,63,51 Brown Sugar,36,70 Butter,20,72 Buttered Popcorn,16,71 Cacao,16,52 Caffé Latte,8,64 Caffé Mocha,8,71 Carrot,136,81 Carrot Cake,12,50 Carrot Juice,28,58 Carrot Pie,16,55 Casserole,6,55 Cheese,12,71 Cheesecake,8,57 Cherry,20,71 Cherry Jam,8,63 Cherry Juice,9,60 Cherry Popsicle,6,52 Chili Pepper,36,52 Chili Popcorn,12,63 Chocolate Cake,6,70 Chocolate Ice Cream,8,88 Chocolate Popcorn,8,52 Coffee Bean,24,53 Cookie,12,76 Corn,260,70 Corn Bread,20,53 Cream,33,83 Cream Cake,8,65 Egg,63,47 Egg Sushi,4,63 Espresso,8,68 Feta Pie,8,60 Feta Salad,3,59 Fish And Chips,8,79 Fish Burger,8,49 Fish Pie,8,49 Fish Soup,6,54 Goat Cheese,12,71 Goat Milk,24,80 Hamburger,9,49 Hot Chocolate,8,79 Indigo,52,54 Lobster Soup,6,48 Lobster Sushi,4,72 Mayonnaise,6,80 Milk,44,50 Olive Oil,8,68 Pancake,12,57 Pizza,9,61 Popcorn,52,70 Potato,36,60 Potato Bread,8,79 Potato Feta Cake,8,63 Pumpkin,44,52 Pumpkin Pie,12,56 Raspberry,28,54 Raspberry Jam,9,61 Raspberry Mocha,8,57 Raspberry Muffin,12,54 Red Berry Cake,8,70 Red Scarf,8,68 Roasted Tomatoes,16,63 Seafood Salad,4,81 Shepherds Pie,8,53 Soy Sauce,12,61 Soybean,123,63 Spicy Pizza,9,70 Strawberry,36,60 Strawberry Cake,8,76 Strawberry Ice Cream,6,60 Strawberry Jam,8,60 Sugarcane,81,52 Sushi Roll,4,64 Sweater,12,71 Syrup,12,57 Tomato,33,52 Tomato Juice,12,57 Tomato Soup,4,80 Vanilla Ice Cream,9,58 Wheat,236,66 White Sugar,20,71 Wool,24,52

Quote:

Originally Posted by NachtKoningin

Hi Neoturtle,

Nice site, very helpful!

I have been tracking boat request quantities for a while now, it has become a obsession :o:D

Below my TOTAL quantities per boat, plus on which level the boat docked.

Hope this helps?

Code:

Product,Total Quantity Product,Hay Day Level Apple,36,52 Apple Jam,12,90 Apple Juice,12,56 Apple Pie,8,62 Bacon,28,70 Bacon And Egg,9,62 Baked Potato,8,88 Berry Juice,9,70 Blackberry,18,53 Blackberry Jam,6,79 Blackberry Muffin,9,32 Blue Sweater,9,45 Blue Woolly Hat,16,60 Bread,63,51 Brown Sugar,36,70 Butter,20,72 Buttered Popcorn,16,71 Cacao,16,52 Caffé Latte,8,64 Caffé Mocha,8,71 Carrot,136,81 Carrot Cake,12,50 Carrot Juice,28,58 Carrot Pie,16,55 Casserole,6,55 Cheese,12,71 Cheesecake,8,57 Cherry,20,71 Cherry Jam,8,63 Cherry Juice,9,60 Cherry Popsicle,6,52 Chili Pepper,36,52 Chili Popcorn,12,63 Chocolate Cake,6,70 Chocolate Ice Cream,8,88 Chocolate Popcorn,8,52 Coffee Bean,24,53 Cookie,12,76 Corn,260,70 Corn Bread,20,53 Cream,33,83 Cream Cake,8,65 Egg,63,47 Egg Sushi,4,63 Espresso,8,68 Feta Pie,8,60 Feta Salad,3,59 Fish And Chips,8,79 Fish Burger,8,49 Fish Pie,8,49 Fish Soup,6,54 Goat Cheese,12,71 Goat Milk,24,80 Hamburger,9,49 Hot Chocolate,8,79 Indigo,52,54 Lobster Soup,6,48 Lobster Sushi,4,72 Mayonnaise,6,80 Milk,44,50 Olive Oil,8,68 Pancake,12,57 Pizza,9,61 Popcorn,52,70 Potato,36,60 Potato Bread,8,79 Potato Feta Cake,8,63 Pumpkin,44,52 Pumpkin Pie,12,56 Raspberry,28,54 Raspberry Jam,9,61 Raspberry Mocha,8,57 Raspberry Muffin,12,54 Red Berry Cake,8,70 Red Scarf,8,68 Roasted Tomatoes,16,63 Seafood Salad,4,81 Shepherds Pie,8,53 Soy Sauce,12,61 Soybean,123,63 Spicy Pizza,9,70 Strawberry,36,60 Strawberry Cake,8,76 Strawberry Ice Cream,6,60 Strawberry Jam,8,60 Sugarcane,81,52 Sushi Roll,4,64 Sweater,12,71 Syrup,12,57 Tomato,33,52 Tomato Juice,12,57 Tomato Soup,4,80 Vanilla Ice Cream,9,58 Wheat,236,66 White Sugar,20,71 Wool,24,52

Hi! Thanks for contributing that information, but I'm not sure how I can use that data. There's already a thread called "Guide Book" listing that in a per crate format which I think is more useful. How do you use that data and how useful do you find it? Maybe I'm just not seeing it.

Does anyone know if there's a correlation between 3-4 crates and items required? Such as (using cheese as example):

3 crates of cheese required - 4 cheese required
4 crates of cheese required - 3 cheese required

Could it be:
3 crates of cheese required - 3 cheese required
4 crates of cheese required - 4 cheese required

Basically, is it random or - if 3 crates, ask for 4. If 4 crates, ask for 3.

Just Cuirous

Quote:

Originally Posted by meonhoc

Almost miss this thread :(.

Up to date (Nov 30th 2013) list of Price & XP from Boat order/Default Price/Time in Minutes/Exp when Collecting, including some changes made by Supercell from their Winter update. This is the content of a CSV file (can be import in Google Docs or open with Excel).

Code:

ProcessingBuilding,UnlockLevel,Name,TimeMin,OrderPrice,OrderExp,ExpCollect,DumbValue Animal,1,Egg,20,8,7,2,5 Animal,6,Milk,60,14,13,3,9 Animal,10,Bacon,240,21,19,5,14 Animal,16,Wool,360,24,22,5,15 Animal,27,Fish Fillet,,21,,,15 Animal,32,Goat Milk,480,28,25,6,18 Animal,44,Lobster Tail,360,104,,11,56 Bakery,2,Bread,5,11,11,3,6 Bakery,7,Corn Bread,30,36,35,8,20 Bakery,10,Cookie,60,54,52,13,29 Bakery,19,Raspberry Muffin,45,72,69,17,39 Bakery,26,Blackberry Muffin,45,117,112,27,63 Bakery,33,Pizza,15,98,94,23,53 Bakery,37,Spicy Pizza,15,117,112,27,63 Bakery,39,Potato Bread,45,147,142,39,79 Bakery,45,Frutti di Mare Pizza,15,208,200,32,112 Barbecue_Grill,9,Pancake,30,56,54,13,30 Barbecue_Grill,11,Bacon and Eggs,60,104,100,24,56 Barbecue_Grill,18,Hamburger,120,93,90,22,50 Barbecue_Grill,27,Fish Burger,120,116,112,27,63 Barbecue_Grill,30,Roasted Tomatoes,90,62,59,14,33 Barbecue_Grill,35,Baked Potato,35,155,149,36,83 Barbecue_Grill,41,Fish and Chips,90,126,121,29,68 Cake_Oven,21,Carrot Cake,90,86,83,16,46 Cake_Oven,23,Red Berry Cake,60,132,127,31,71 Cake_Oven,23,Cream Cake,180,112,108,26,61 Cake_Oven,24,Cheesecake,240,146,140,34,79 Cake_Oven,35,Strawberry Cake,180,163,156,38,88 Cake_Oven,36,Chocolate Cake,120,165,159,38,89 Cake_Oven,38,Potato Feta Cake,120,159,153,32,86 Candy_Machine,51,Caramel Apple,120,66,,31,71 Candy_Machine,52,Toffee,90,45,,21,49 Candy_Machine,54,Chocolate,1200,119,,55,128 Candy_Machine,57,Lollipop,720,88,,41,95 Candy_Machine,60,Jelly Beans,1440,122,,81,190 Coffee_Kiosk,42,Espresso,5,128,123,29,69 Coffee_Kiosk,43,Caffé Latte,10,114,109,26,61 Coffee_Kiosk,45,Caffé Mocha,15,151,145,19,81 Coffee_Kiosk,46,Raspberry Mocha,30,134,128,16,72 Coffee_Kiosk,47,Hot Chocolate,25,139,133,32,75 Crop,1,Wheat,2,2,1,1,1 Crop,2,Corn,5,2,2,1,2 Crop,5,Soybean,20,5,3,2,3 Crop,7,Sugarcane,30,6,4,3,4 Crop,9,Carrot,10,3,3,2,2 Crop,13,Indigo,120,10,8,5,7 Crop,15,Pumpkin,180,12,9,6,9 Crop,25,Chilli Pepper,240,14,11,7,10 Crop,30,Tomato,360,17,13,8,12 Crop,34,Strawberry,480,19,14,10,14 Crop,35,Potato,220,14,10,7,10 Crop,56,Rice,45,7,5,3,5 Crop,58,Lettuce,210,13,10,7,9 Dairy,6,Cream,20,25,24,6,14 Dairy,9,Butter,30,44,42,10,23 Dairy,12,Cheese,60,64,61,15,34 Dairy,32,Goat Cheese,90,83,80,19,45 Expansion,5,Barn_Silo,,,,,75 Expansion,22,Land_Fishing,,,,,112 Feed_Mill,1,Chicken Feed,5,,,1,2 Feed_Mill,6,Cow Feed,10,,,2,4 Feed_Mill,10,Pig Feed,20,,,2,4 Feed_Mill,16,Sheep Feed,30,,,3,4 Feed_Mill,32,Goat Feed,40,,,3,4 Fruit,15,Apple,,22,15,7,11 Fruit,19,Raspberry,,26,17,9,13 Fruit,22,Cherry,,40,26,13,19 Fruit,26,Blackberry,,47,32,16,23 Fruit,36,Cacao,,49,33,16,24 Fruit,42,Coffee Beans,,37,25,12,18 Fruit,57,Olives,,50,34,17,23 Ice_Cream_Maker,29,Vanilla Ice Cream,120,89,85,20,48 Ice_Cream_Maker,33,Cherry Popsicle,180,181,174,42,98 Ice_Cream_Maker,34,Strawberry Ice Cream,240,171,165,40,92 Ice_Cream_Maker,39,Chocolate Ice Cream,150,176,170,41,95 Jam_Maker,35,Apple Jam,360,113,109,24,61 Jam_Maker,36,Raspberry Jam,420,129,124,28,70 Jam_Maker,37,Blackberry Jam,480,201,194,46,108 Jam_Maker,38,Cherry Jam,420,173,167,39,93 Jam_Maker,50,Strawberry Jam,450,140,134,32,75 Jeweler,38,Bracelet,120,,,50,118 Jeweler,39,Necklace,180,,,72,169 Jeweler,40,Diamond Ring,240,,,84,196 Juice_Press,26,Carrot Juice,30,24,23,6,13 Juice_Press,28,Apple Juice,120,66,64,15,36 Juice_Press,30,Cherry Juice,150,111,107,26,60 Juice_Press,32,Tomato Juice,90,84,81,19,45 Juice_Press,34,Berry Juice,180,106,102,24,57 Loom,17,Sweater,120,77,74,18,42 Loom,19,Blue Woolly Hat,60,57,55,13,31 Loom,20,Blue Sweater,180,108,104,22,58 Loom,48,Red Scarf,150,148,143,34,80 Mine,24,Silver Ore,,,,3,4 Mine,24,Gold Ore,,,,4,5 Mine,24,Platinum Ore,,,,5,7 Pie_Oven,14,Carrot Pie,60,42,40,10,23 Pie_Oven,15,Pumpkin Pie,120,82,79,19,44 Pie_Oven,18,Bacon Pie,180,114,110,26,61 Pie_Oven,28,Apple Pie,150,140,135,32,75 Pie_Oven,28,Fish Pie,120,117,113,27,63 Pie_Oven,34,Feta Pie,90,114,110,26,62 Pie_Oven,36,Casserole,120,189,182,39,102 Pie_Oven,39,Shepherds Pie,100,146,140,31,78 Popcorn_Pot,8,Popcorn,30,17,17,4,9 Popcorn_Pot,16,Buttered Popcorn,60,65,62,15,35 Popcorn_Pot,25,Chilli Popcorn,120,63,61,15,34 Popcorn_Pot,44,Chocolate Popcorn,150,127,122,29,69 Salad_Bar,58,Feta Salad,90,384,369,89,207 Salad_Bar,62,BLT Salad,105,373,359,86,201 Salad_Bar,64,Seafood Salad,120,394,379,91,212 Sauce_Maker,54,Soy Sauce,180,80,77,19,43 Sauce_Maker,58,Olive Oil,45,144,138,33,77 Sauce_Maker,62,Mayonnaise,15,190,183,44,102 Smelter,24,Silver Bar,480,61,59,14,33 Smelter,25,Platinum Bar,960,90,87,21,49 Smelter,25,Gold Bar,720,76,73,18,41 Soup_Kitchen,46,Lobster Soup,150,315,303,40,170 Soup_Kitchen,47,Tomato Soup,90,247,237,57,133 Soup_Kitchen,53,Fish Soup,180,154,148,35,83 Sugar_Mill,7,Brown Sugar,20,16,16,4,9 Sugar_Mill,13,White Sugar,40,27,26,6,14 Sugar_Mill,18,Syrup,90,47,45,11,25 Sushi_Bar,56,Sushi Roll,60,253,243,58,136 Sushi_Bar,59,Lobster Sushi,60,329,316,76,177 Sushi_Bar,63,Egg Sushi,120,285,274,66,153 Tools,5,Axe,,10,,,10 Tools,5,Saw,,15,,,15 Tools,5,Dynamite,,7,,,7 Tools,5,TNT,,20,,,20 Tools,5,Shovel,,30,,,30

I also find out from a previous long lost spreadsheet that Max Price = Default Price *3.6. Therefore you don't need raw data for the columns MaxPrice and MaxPrice10 anymore.

I'm just curious how you manage to get the numbers on the csv file. I try it and still unable to read it because it was encrypted.

Quote:

Originally Posted by 13tops

I'm just curious how you manage to get the numbers on the csv file. I try it and still unable to read it because it was encrypted.

Oops, I thought I had answered this a while back. You can just copy and past the data into notepad and save it with a csv extension and open it in Excel.

Thanks for your hard work!

Quote:

Originally Posted by E157eka

Thanks for your hard work!

You're welcome!

If anyone has information on the new Sandwich machine, please post or update the Google spreadsheet!
https://docs.google.com/spreadsheet/...=sharing#gid=8

Bumping so a neighbor can see this thread.

I fully support this idea! I think we need a website (not just a bunch of blogs or forums) to keep an easily accessed library of all the knowledge posted here!

I don't know of anyone who posts to GameFAQS about this game, so a website would be AMAZING for everyone - newbies or veterans!

Quote:

Originally Posted by NeoTurtle

Bumping so a neighbor can see this thread.

time for an update

Turtle, this is a great database! Are you still compiling data? Wish I could help with the new lemon trees, etc. but I am not that high a level yet.

Thanks for your work.

Glad I found this!

I was thinking about starting a data thread, compiling the cost of producing an item compared to the profit so that I could find the most efficient method for increasing my income. This is extremely helpful so I am very glad I found it! You really have saved me a lot of work. :) Are you still working on the site?

First of all, my compliments for the info provided. Very useful for a noob like me.

I have one suggestion though:

Instead of coins per minute value (which reflects the max cost of the ingridients?), I think an information on actual profit per minute would be much better. You would just have to subtract the max value of the ingredients from the max sell price of the item.

It would be very useful in determining what to produce (best profit per minute) or if you wanna establish if you are better off buying the ingredients in the market or producing them.

Nice initiative! I've started adding some more data since a lot of new stuff like the Town isn't included. I've also added a base-price and max-price column so we can later on include xp and coins per hour for items, to calculate which is best.

Please help me add data! :) The link is once again: https://docs.google.com/a/milenco.ne...=sharing#gid=8