Barry Farmz Here -- Comprehensive data driven farming guide

#1

This farming guide is my best effort to combine all the big farming data projects I could find. (Over 17,000 as of April 5th)

Barry Farmz Here: Summary – Google Docs Spreadsheet Link

You say you want to contribute to this project? Why thank you, I’m glad you offered! Please get in touch with me and I’ll set you up: You can reach me best by my Line ID: barrywuzhere (I don’t claim to understand discord well or check it often, but I’m in the 7DD chat and you can probably find me there)

I could use your help doing any of these:

  1. Contribute your own farming runs to the project, entering them yourself in the spreadsheet. (It is pretty simple if you’ve ever operated a spreadsheet)
  2. Upload your farming runs to a Line chat room, for later data entry
  3. Enter farming runs already collected in the line groups.
  4. If you are really good at spreadsheets and/or statistics, perhaps you can help me on some of the trickier/more subtle things about it.
  5. If you have already collected a lot (100+) of farming runs in your own spreadsheet, I would love to translate/import your data with you or for you; I’ve done a few versions of this already.

Credits: (To borrow and likely mutilate a quote, I could only see so far because I stood upon the shoulders of giants.)

Hotdamnmess’ Farming Guide is where I started working trying to work with farming from based on real collected data. I’d like to thank @hotdamnmess for all her work in getting almost 7000 farming runs recorded in that project. I would like to thank everybody else who has contributed level farming runs, data entry, and spreadsheet work on that project, who are probably too many for me to list if I could even try to find who you all were!

Several people have personally collected an amazing amount of farming data, and have shared their data with me, giving me thousands more data runs. Thank you for sharing your data with me, @Pois1, @Biermeister, @gregschen, and @PekaJ!

46 Likes
Mai's Guide to Efficient Farming – List of best lvls to farm monster, different resources, wanted missions and XP
Can't believe I've been wasting my time on 5,8
On Farming – is there somewhere better than 8-7?
Can someone tell me about season 2 item/xp/recruit drop statistics?
Can't believe I've been wasting my time on 5,8
What is the best level to farm backpacks?
Where is the best place(s) for farming in Season 2?
Dropping rates of items has decreased- Constantly running out of Bones, Iron, Oil
Mai's Guide to Efficient Farming – List of best lvls to farm monster, different resources, wanted missions and XP
Season 2 stats
:trident: End of an Era: Atlantis Season 2 Final Stages Releasing — FAQ & Discussion
Mai's Guide to Efficient Farming – List of best lvls to farm monster, different resources, wanted missions and XP
[No changes to backpacks/swords: Developer response post #19] Getting less backpacks recently (post v20)
Mai's Guide to Efficient Farming – List of best lvls to farm monster, different resources, wanted missions and XP
What is the best level to farm backpacks?
Need Tall Boots 4/22/19
Where do I get 2 star troops?
Need help with war material? Where is the best place to farm Hardwood Lumber?
Troops and Backpack farming
:trident: Atlantis Rises – FAQ & Discussion
Season 2 Missions Advice (Enemies, Bosses and Special Stages)
:test_tube: The Beta Beat (v21) [NOW RELEASED] – Sharing the Big Picture on What's Going on in Beta (an experiment)
Season 2 Avatar Missions
:trident: Atlantis Rises – FAQ & Discussion
Frustration killing the game. 8-7 nerfed, materials & ascension mats not dropping
Need help with war material? Where is the best place to farm Hardwood Lumber?
Best level to farm oil for antidotes?
Where to farm mana potion ingreduents?
#2

One of the things I want to do with this project is to let YOU (if you like spreadsheets) crunch the data, and do your own analysis of all my data. I’ve done some specific things to make it clean and easy to import the data.

Watch this space; when I have it cleaned up and properly packaged, I’ll provide a link here.

Yes, things like this. I did a moderate bit of database-style design in how I constructed this spreadsheet, and I’d be happy to point you to the place where the stats are filtered by a minimum run count.

I actually wanted to do something where the minimum run count varied based on what was statistically valid data for various things–10 runs seem more than sufficient for recruits, and 100 runs seem marginal for 4* crafting mats. (I don’t claim to actually understand proper thresholds here, just that lower drop rates need more samples!)

2 Likes
#3

20 more characters of watch this space

2 Likes
#4

This is a great idea to bring together the various data sets, well done!

Are there particular areas where you feel the data is thin? Is there good coverage of all of Season 2 so far through Province 18?

6 Likes
#5

Thanks for all of your hard work!!!

4 Likes
#6

All of you folks obviously put a huge amount of time into something that all of us can use that doesn’t cost any gems(Lol). Thank you so very much for such a valuable asset to enhance gameplay. This silver haired battler really appreciates it :+1:t3:

7 Likes
#7

There are very definitely thin spots, especially in the last two sets of provinces to open up.

In the collective upload of screenshots / data entry section, there is a LOT of data captured but not entered yet; I could use some data entry volunteers to catch up.

2 Likes
#8

Makes sense.

How does this intertwine with @hotdamnmess’s data collection at this point? Will the data continue to be shared between the projects, or are you essentially forking and diverging going forward?

2 Likes
#9

It’s nice to see something happening in the field. I tried to get some info on stages 16-18 lately, but couldn’t find any reliable data (all this while 19-21 are about to be released).

Keep up the good work, mate!

1 Like
#10

I started with all the data I could use in her project imported into mine. If she does continue to add data, I want to add those updates.

4 Likes
#11

I know that there are plenty of players who are excited to charge through new levels as soon as they open … I’d love to find a handful who are willing to capture and submit their results!

I’ve found that some things need a single sample (XP), some average out nicely with a small number (food, iron, recruits), and some have very low drop rates and need a lot of data. (4* crafting mats, heroes, troops)

2 Likes
#12

I typically do all of the new Atlantis levels pretty quickly. I could give you data from a single run of each stage if that’d be helpful.

2 Likes
#13

Yes, please! If I get 10 people to do that I’ll have a great start and be able to see what looks promising quickly!

5 Likes
#14

I don’t have much data as I don’t have tons of overflowing energy, but here are a few runs:

1 Like
#15

Even s1 has thin spots for item-specific loot data… in case anyone has some of that stashed away.

#16

I hope you back it up regularly…I had 30 supposedly tech savvy people update a spreadsheet and they kept messing it up. I ended up backing it up 3x a day to keep it safe.

4 Likes
#17

That’s a good point.

It might actually be worth having a separate sheet for data entry, or even use a form that posts data to a collection sheet.

2 Likes
#18

Are the drop rates per world energy point, or per stage run?

#19

I’m kinda paranoid about losing data … and I did make an entire separate sheet for data entry already–that is a great idea.

@KLinMayhem, All the results are drop rate per WE in the sheet, all the data entry is drop rate per farming run (or combined loot ticket run), and I do have a few oddball calculations that multiply it out for samples per farming run in there someplace

3 Likes
#20

Yeah, S1 results are thin in places … but it has been farmed for a long time, so I don’t expect to find any big surprises there. S2 still has new things to discover!

1 Like