Home EN General Discussions & Questions

Join the official Goodgame Big Farm Discord today!Join our Big Farm Discord Server


Are you looking for a community of like-minded farmers to discuss your farming experience with? Look no further than the GoodGame Big Farm Discord Server!


Our server is the perfect place to connect with other farmers from around the world. Whether you're looking to chat about strategy, share tips and tricks, or just make new friends, our community has got you covered.


And that's not all - as a member of our Discord server, you'll also have access to exclusive giveaways and other special events. It's the perfect way to stay up to date on all the latest news and updates from GoodGame Studios.


So what are you waiting for? Join the GoodGame Big Farm Discord Server today and start connecting with fellow farmers from all over the world. Just click here to join the fun!

Please Test: Island Farm Interactive Calculation Spreadsheet

Do you want to quickly calculate how much fruit you need for the Island farm? Or how many hours it takes to generate 55,000 peacocks with four level one pens? Do you want to compare the cost value of different levels?

I started making a spreadsheet as a "follow along", but then I started consolidating data together into one place so I didn't have five browser tabs open. Then I started getting into making formulas to do some basic calculations for my personal use. I am a beginner, so the formulas are imperfect, and the layout was not preplanned! However, there are a few "generators" I've just created that I though players would like to Beta test.

______________________________________________________________________
SPREADSHEET NAME -- Island Farm 3: Pago Pago
WHERE: https://docs.google.com/spreadsheets/d/1gmakq2Ujj8AgHYSXuijFDUufNorTmT9tG5rzEmPDgDU/edit?usp=sharing

Sheet Name: DATA GENERATORS

Fruit Need Generator
Cell Start: E27
Tired of having to figure out how many mangos, bananas, coconuts, and oranges you need for drinks? Input the level of your Bar and totals are calculated automatically for each drink by chapter.

How Much More Fruit Needed?
Cell Start: K27
Already accumulated some stock and/or completed some of the drinks? Input your current inventory numbers, and the number of drinks runs you've completed. A total of remaining fruit to collect will be generated.

How Long?
Cell Start: J38
Trying to figure out how long it will take to grow 30000 oranges with five level 3 fields? Want to know how fast you can generate 9000 lemurs with two level 2 pens? Want to know how many hours it takes to produce 3 Tropic Star? Input your values and the time duration will be automatically generated.

UPDATE Dec. 2: Added more functionality to "How Long". Selections will now generate shell values, number of harvests, amount of dung/leaves produced, and amount of fertilizer/feed used for both SINGLE harvests and TOTAL harvests it takes to produce the desired amount.

UPDATE Dec. 5: Fixed ugly "error" messages, and added data areas that will calculate fruit needs based upon SINGLE drinks and also MULTIPLE drinks. These are "vanishing" areas, and only appear in the "How Long" generator if "Drinks" are selected in the "Select Type" field. I am rather proud of this update. A few bugs persist here and there.
___________________________________________________________________

There are more calculators highlighted in yellow throughout the sheet! Some of them may or may not be useful to you. I am just learning how to use IF statements and learned how to do a basic INDEX/MATCH today...so I am sure there are flaws. Again, these calculations were spontaneous and created over the course of 17 days, so they are not particularly orderly. As I learn or need to know information, I add more "stuff".

I think you have to download the sheet to play with the values right now (nothing is protected from change at the moment, so if you aren't familiar with formulas (especially messy beginner ones like mine) be careful what you change!

Feedback would be appreciated. If you see a glaring calculation error, please let me know!

UPDATE: Dec. 8 Ready for Testing...the DUNGERATOR! Area of Cell M87

Set for calculating how long it will take to generate dung and/or fertilizer based upon the level of the silo, and the number/level of the animal pens. I admit that the formula is "hacked up", but it seems to work and appears to produce reasonable approximations.

Yet again, I grossly underestimated the time it takes to produce fertilizer. This generator should help a little!
Post edited by Truth928 (US1) on

Comments

  • rhon (GB1)rhon (GB1) Guest, GB1 Posts: 1,542
    edited 03.12.2014
    Seems very useful indeed. Thanks

    I'm still experimenting with it to give any useful feedback right now though
  • Trippel (NL1)Trippel (NL1) Posts: 299
    edited 03.12.2014
    In my opinion you make the mistake to handle one task at the time. You should work on all task simultaneously, working ahead where its possible. For example, you need to harvest 789 times peacock (lvl1) in addition to the tasks, just to produce the dung needed for the fertilizer (silo lvl3). To feed the peacocks you need to harvest peanuts 1145 time (lvl 2 field) also in addition to the tasks. If you don't work ahead, you will find yourself out of room, workers,happiness or more important time.
    Just calculating the cost vs output is not that simple, an extra upgrade may turn out to be cheaper, but if this requires an extra house/deco/plot?
    Put the tasks in a timeline that suits your playtime, there is no use in building something extra to hurry a task if you have to wait to start the next because you dont have the ingredients in stock.
  • Truth928 (US1)Truth928 (US1) Posts: 35
    edited 04.12.2014
    I added new functioality to the "how long" generator. It will now also tell you how many harests it takes, and what the shell value is, and how much dung/leaves are generated. You can even input your inventory amount and see its shell worth and how long it took to produce.
  • RoriKang (US1)RoriKang (US1) Posts: 6
    edited 05.12.2014
    BTW, What is the Decoration Collection for?
  • Uncle WillyUncle Willy Posts: 261
    edited 05.12.2014
    Great "How Long" generator Truth. Like samty said, need more time to play with it to give any more feedback :-)

    RoriKang wrote: »
    BTW, What is the Decoration Collection for?

    from what I recall, GGS said the developers needed an easy place to see what decorations everyone had.
    Why? They didn't say. Probably to figure out how to get us to spend more gold lol
  • Truth928 (US1)Truth928 (US1) Posts: 35
    edited 08.12.2014
    NEW! The Dungerator... Find in area of Cell M87

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file