Barry Farmz Here -- Comprehensive data driven farming guide

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

Barry Farmz Here: Summary – Google Docs Spreadsheet Link

If you wish to contribute data, I moved the instructions and invitation to reply#3 in this thread

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!

80 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?
What is the best level to farm backpacks?
Can someone tell me about season 2 item/xp/recruit drop statistics?
Can't believe I've been wasting my time on 5,8
Where is the best place(s) for farming in Season 2?
ATLANTIS RISES - Optimum Levels For Loot
Season 2 Missions Advice (Enemies, Bosses and Special Stages)
Superfast leveling up
Troops and Backpack farming
Where to farm in the most efficient way in season 2
Season 2 stats
Mai's Guide to Efficient Farming – List of best lvls to farm monster, different resources, wanted missions and XP
Best place to spend auto-win tickets?
Season 2 farming with new set of rules
Frustration killing the game. 8-7 nerfed, materials & ascension mats not dropping
Holy chest
Calling all farmers
:trident: Atlantis Rises – FAQ & Discussion – Next Sep 26, 2019
:trident: End of an Era: Atlantis Season 2 Final Stages Releasing — FAQ & Discussion
[No changes to backpacks/swords: Developer response post #19] Getting less backpacks recently (post v20)
Dropping rates of items has decreased- Constantly running out of Bones, Iron, Oil
[Comparison] Speed recruit farming or Comparing Recruits per Autoplay hour for AR+2.6-9N, s1-8-7, s1-7-7, Recruits I & II quest ( Updated 2019-May-27 )
Atlantis hero, coins
Need help with war material? Where is the best place to farm Hardwood Lumber?
List of ascension material on where to get it easier
Mai's Guide to Efficient Farming – List of best lvls to farm monster, different resources, wanted missions and XP
Mai's Guide to Efficient Farming – List of best lvls to farm monster, different resources, wanted missions and XP
Where do I get 2 star troops?
S2 Dragons
Atlantis Rises - What's your farming strategy?
Season 2 special stages question
Where to farm mana potion ingreduents?
Daily level
New player, having some issues with blue and red. Your advice?
Need Tall Boots 4/22/19
Best level to farm oil for antidotes?
What is the best level to farm backpacks?
[Stronghold 21, Game design] Iron bottle neck- cause and iron farming
Game idea for stages
Atlantis hero, coins
Recruits, Atlantis rising, VIP pass loot tickets and It's Raining Loot Tickets!- Coin rate is unknown- Updated with best Kits/ Backpack stages
Recruit farming
Where's a great stage to farm leather strips?
Need help with war material? Where is the best place to farm Hardwood Lumber?
Who to levelup from my first 10X Summon?
Max all four training camps or keep using two for training 1* and 2*?
Returning Player
:trident: Atlantis Rises – FAQ & Discussion – Next Sep 26, 2019
Season 2 experience chart
:test_tube: The Beta Beat (v21) [NOW RELEASED] – Sharing the Big Picture on What's Going on in Beta (an experiment)
Troops? Where?
Season 2 Avatar Missions
What's your favorite season 2 place to farm? Season 2 Farming Guide? [MASTER]
Thoughts of changing Atlantis schedule and duration [Schedule has been UPDATED]
Why aren't more people on the forum? (Poll)
If you could change 1 thing in the game, what would it be? And why/how?
Which building to convert/upgrade after SH21 and SH22?
Where to spend loot ticket in Season 2
Stuck On Season 1 Province 22
:trident: Atlantis Rises – FAQ & Discussion – Next Sep 26, 2019
:star2: Memento 5 Events
Keep Atlantis Rising going until Season 3!
Game Stats needed (heroes, powers, monsters etc.)

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

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:

  • Best is by my Line ID: barrywuzhere
  • I’m also on discord, although I don’t claim to understand discord enough to give you a contact link. I’m on the 7DD server as well as a couple others, and go by Barry Wuz Here there as well
  • You can go to the data entry spreadsheet directly (link below in option #1 ) and request access directly; it will get to my email. I’d rather not publish my email here in this forum, and don’t recommend you publish yours here either.

I could use your help doing any of these:

  1. Contribute your own farming runs to the project, entering them yourself in this data entry specific version of the spreadsheet. (It is pretty simple if you’ve ever operated a spreadsheet) NOTE: Don’t use this version to figure out where to farm. It only holds partial data that will get updated into the main sheet regularly.
  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.

As I type this, Atlantis Rises is happening with the enhanced farming during it; I’m collecting data for this separately and I’ll figure out how to put it to good use later, after I’m done madly farming for backpacks these three days, in time to share before it returns next month

4 Likes

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?

7 Likes

Thanks for all of your hard work!!!

4 Likes

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:

11 Likes

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

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

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

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.

5 Likes

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

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.

3 Likes

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

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

1 Like

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

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.

5 Likes

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.

3 Likes

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

1 Like

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

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

Cookie Settings