Barry Farmz Here: Master
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
Welcome to E&P farming data collection project by Barry Wuz Here, "Barry Farmz Here", master sheet. If you came here looking to figure out where to do your farming, your best bet is to go to my summary sheet (link immediately below), although the green summary tabs of this sheet are the source for that data. Either way, if you just want to know where to farm, stop reading this page; it is all about the guts of this spreadsheet, overly geeky, and probably poorly edited, and most importantly, NOT intended to be a readable source of information about where to farm. You've been warned!
I'm testing a link; it should go the same place.
February 22, 2019: Direct Data entry in this sheet is CLOSED. Please zip over to the Data Entry sheet!
Check whether Atlantis Rises is active for sorting10/24/2019 7:00:0010/26/2019 19:00:0010/22/2019 5:39:24FALSE
(This row is the start of the importable/replicated part of the readme tab that makes it into other sheets in the family)I will write something more informative here. Someday. Really. As an introduction; there's a lot of crap I've already written....probably too much but perhaps not all the right stuff.
Barry Farmz Here is actually an extended family Google Sheets, not just one. Here are the public/published family members:
Barry Farmz Here: Master
This is the master spreadsheet, and it does most of the calculations. Wherever possible, data here gets imported by other sheets in this project. Including this section of notes in the readme tab!
Barry Farmz Here: Data Entry
It is pretty well polished up and in live use now.
Barry Farmz Here: Summary
Testing the bitly short link in case somebody asks me in game chat.
The "Family" has a few cousins that are useful, but I don't care to share with the public. I'm not saying don't look at them, but you've been warned that they are for some kind of relatively specialized purpose, and most people won't be interested in them, and likely won't make heads or tails of them either.
BFH: S2 Mission Calcluations (Old, not kept up to date)
Depricated, no longer updated -- Calculates WE needed to complete all the S2 missions per level, and ranks levels for each mission. (Doesn't take into account that the mob monsters in the boss level are fixed/known instead of 50/50 random. (I'm going to move this into the archived shit I don't use category sometime, but I referenced the sheet link in this cell somewhere and I don't want to bother finding that and breaking it just now)
BFH: Atlantis Rising re-calc
Takes all the "normal" data and adjusts it to match what will (or at least should as I understand it!) happen during the Atlantis Arising farming boost conditions.
BFH: Chests and Missions
Calculates WE needed to fill monster / elemental chests per level, and ranks levels for each mission. Does a quick-and-dirty version for Atlantis Rises, and also now has S2 Mission monster counting included as well. The results make it onto the summary sheet.
BFH: Custom Calculations
This imports pre-calculated data from the main sheet, as a starting point for custom calculations. I'll try to keep it up to date enough to work. It pulls in Levels, Provinces, Items, Level Counts, and Province Counts. The Level Stats, Province Stats, and summary pages are replicated from the main sheet.
BFH: More Statistics
This sheet imports the synthetic data from the master sheet and performs some statistical tests to measure how well the synthetic data matches the collected data, and other random analysis I did to figure out how things worked, along with a some graphs. NOTE: All the actual synthetic data calculations are done outside this sheet.
BFH: Farming XP Calculations
Work in progress, goal is to calculate daily feeder XP is generated from any level after you run your training camps in any of a bunch of different possible configurations.
BFH: Manual Data AggregationThis is the master archive for all raw, non-consolidated data, and I do a bit of sorting and copy/paste-values to make full lists of data sorted by season or filtering out multiple runs as needed. I tried to make sheets that would automatically generate this, but they kept blowing up instead of calculating successfully so this one is my current/active version.
Spreadsheet conventions and general organizational notes; if you are trying to figure out how I made this spreadsheet work, this is a good place to start reading. If you just want to know where to farm or are here to do data entry, this is a good place to stop!
Expanding functions like importrange(), transpose(), filter(), etc. are color coded Magenta like this cell should be. I do this because they "break" if you put any data or forumla in the area they are expanding into, which is easy to do accidentally, even if you do know where they are.
They often drive a lot of computation/calculation, so I've used "Switches" that disable/enable these functions are color coded red/green, using conditional formatting and data validation, like this:OnOff
Master sheet live switch status:Consolidation on HoldNote: I use other copies of this sheet for consolidation in my current process. I'm 90% sure this version is kinda broken. Look in the Import / Data Entry versions for a working consolidator.
There are a lot of sheets here, and I've tried to color code them. In some sheets in this project, there are tabs that are imported from another sheet, so that I don't have to keep data up-to-date in two different places which generally drives me nuts. If a sheet is locked, it probably is one that only has formatting and an inputrange() function to do that. (If I'm smart I might hide some of those sheets)
Blue tabs are where data that gets used elsewhere is entered.
Data (Live) is the beginning, with farming data entered here. If you are a data monkey, this is what you are looking for.
Levels, Provinces, and Items contain data which doesn't change much, other than the need to put in things like level XP when new provinces open up.
Green tabs are output summaries / reports, intended to be readable/useful.
Orange tabs are pure calculations, with (very limited) empahsis on formatting, readability and reducing visual clutter. (I used to have some in purple too; I confuse myself that way)
Level Counts adds up all the data for each level, and has a little bit of filtering; Synthetic Counts is a drop-in replacement sheet with synthetic numbers instead of raw numbers.
Aggregated Levels generates province-wide averages from the level data in Level Counts, plus a bunch of other aggregation categories because I discovered that they were easy to calculate. Easily half of them aren't particularly useful, but I left them there as a way to check if there were statistically valid groupings among them. Synth Rates uses the (most useful) aggregated categories to generate better long-term farming rates for each level, and Synth Sort is a way of figuring out which level I want to use as a "poster child" when there are a bunch of levels that are tied for best in a particular item. Level Stats does a second pass of filtering, and a few more calcs and pulls in results from Level Counts. (It has more-or-less been superceded by Aggregated Levels / Synth Rates, but I'm keeping it around since I had some output/summary sheets that pull from it)
Summary and Level Summary pull in results (without the rest of the crap) and format them to display/publish.
Data Considation (and its output sheet) I use to turn all the data from a level into (effectively) a pair of loot ticket runs, one with monster counts, one without, to cut down on the number of calculations needed. At the same time, it replicates any levels which fail the error checking and didn't make it into the count, so they can be fixed later or continue to be ignored....but aren't just "lost". (They are purple) Those sheets aren't used and might not be up to date in this version. The ones in the Data Entry sheet and the Import Consolidation sheet are used regularly and kept up to date.
Archive and working import sheets:These sheets are ones that I use myself as part of my data import process, which (so far) I haven't involved anybody else in. How the process works is that I have a funnel of sheets that import datasets and generate consolidated datasets ... and between sheets what I do is a copy-paste-values to make a sheet with that (date stamped) dataset, which then goes into the next stage. Consolidated data gets funneled into the master SS; full non-consolidated data gets sent into the separate data aggregation SS, to be used for any analysis that cannot operate on consolidated data.
Dataset Consolidation archive:
This version has all my imported datasets as separate sheets. The main function is to make a single merged consolidated dataset from the (already consolidated) individual project datasets. I'm thinking of taking the non-consolidated sheets out of it.
Import Beirmeister's Data
Import Pois1's Data
Import Jakob's Data
Jakob's export sheet (target for above)
My Copy of HDM, as I imported it on 1/19/19
Import HDM, Single row levels that might be problem children....Still need to do that one!
Import HDM, S1
Import HDM, S2 Normal
Import HDM, S2 Hard
Work in progress calculation sheetsThese are various sheets that I started on and either they haven't been finished enough for prime time (as in no results are in my main summary sheet yet), or perhaps they've been totally abandoned.
BFH: Big Data Calcs (Static Copy)
This does calcs on a static copy of the big aggregated data generated by the no calcs aggregation version
Extra (Related) Google Sheets that I use less often; if they are mine, they are probably out of date if I haven't needed them lately.
HDM's Farming Guide:
CJM's E&P Data
I'm a horrible data packrat and I saved a bunch of things at various points during this project. I doubt any of these are useful anymore, but I'm keeping links here in case I need them for some stupid reason. Or maybe I went housecleaning and deleted them all, and the links won't work. Feel free to look for them, but don't expect anything useful or usable. You've been warned! (Note: my working name for this project early on was "One Sheet to Rule them All" which seemed funny at the time but was pretty unwieldy!
My out of date mutli-sheet import
My Copy of HDM, before Provinces 12-15 were added; I was using this dataset when I stopped working on the import sheets; they are probably semi-broken unless re-pointed at this one, or fixed to deal with more levels.
Archived copy of what I went live with and opened up for data entry. (at least that is what it is supposed to be!
Archived copy before my final import, "just in case"
One Sheet to Archive them All (V2) Live data is limited to HDM data.
One Sheet to Archive them All (Old version)
BFH: Synthetic Farming Calculations (Old version)
Taking the data from the farming project and using patterns I've seen in how loot drops, so I can create better farming drop rates than what I have from (in some cases) very limited samples.
Another graphs thingie I built.
BFH: Graphs & Calcs
Working name; version for Beir's graphs :)
BFH: Full Dataset Aggregation
(Now depricated/ignored; it is too big and sheets blows up instead of finishing re-calulations too often) This version collects all the various datasets into one monster, it can handle 18k rows right now. It currently does some calculations. I mostly gave up and split it into an aggregation sheet and a calculation sheet instead.
BFH: Big Data Aggregation (No Calcs)
(Now depricated/ignored; it is too big and sheets blows up instead of finishing re-calulations too often) This is the master archive for all raw, non-consolidated data, and it generates a single flat sheet with all of it in one place from all the various individual sub-sets of data. Unfortunately, it seems to be big enough to make google sheets fail half the time.
=importrange() sheet list. (Adding rows between this and row 10 will break all the sheets that use this list. Don't! If you move the rows around in this range, that's much safer...Sheet URL if not master (Be smart, point it at the cell in the list of sheets way up top!)Range
Level metadata (Code, Name, WE, XP, Province, etc.) A bunch of stuff specific to missions and the BFF stuff is now depricated and might or might not be removed yet.
Province metadata sheet
Old Synth Data
Item metadata sheetItems!1:35
Live Data sheet (Use if you are replicating/channging the counts sheets)
Data (Live)!A3:AS4000
Level counts: Data driven in Col C, Synthetic in Col E; See AR version a couple rows down
Level Counts!1:81
Synthetic Counts!1:81
Province counts sheet (Depricated, replaced by Aggregated and Synth sheets)
Province Counts!1:78
S2 Levels to farm
Placeholder for Extended level metadata; I ended up not using it, as all the extended data was only needed in one sheet so it got moved into that sheet instead.
Atlantis Rising
Atlantis Rising!1:54
AR Counts!1:80