The LiquidLegends Lounge - Page 589

On September 24 2015 04:02 MoonBear wrote:

I don't know precisely what you're trying to do. But a general principle is that rather than creating a massive set of nested IF functions, try and instead identify the key states that matter. Set those as their own variables (or column variable, idk how your model works).

A technique I like to do is not even touch Excel and just draw out what I'm trying to do on a piece of paper as a flowchart. That flowchart represents the bajillion IFs you're trying to do. Then figure out if there are ways to simplify that flowchart such as removing redundencies, or definining states of the world where X+Y+Z are all true as one variable or something. (It feels a bit like linear network optimisation problems you do by hand sort of?)

Also some aspects might be easier if you use INDEX, MATCH, OFFSET, and named arrays. It also removes a lot of restrictions of LOOKUPS (needing the variable to be on the left is a big one for example and also means you can be more flexible with your primary key).

On September 24 2015 04:18 jcarlsoniv wrote:
Well, I did a ton of distance calculations in a few different ways, and I wanted to scan through and return the column header where the value matched the look up value. It's a bit tough to explain without going into too much detail, but I'm erring on the side of caution there.

On September 24 2015 04:18 Numy wrote:
Do you know the reason for that? Our trains here are a bit shit and jerky but dam that's crazy levels. Can't imagine sleeping through that, it's like a mini earthquake every couple of seconds.

On September 24 2015 03:50 Ketara wrote:
Burmese trains are interesting by the way. They bounce.

I've been on trains in 13 different countries, and I've never seen a train bounce before today.

On September 24 2015 04:24 MoonBear wrote:

Create 3 tabs. First tab contains the primary calculations. Second tab is used as a dummy for generating TRUE/FALSE checks on the entire columns in the first tab. The TRUE/FALSE states can be used to output the column header. If your first tab is just calculations, then the checks in the second tab can be in matching columns (i.e. Column A in tab 2 checks Column A in tab 1) which means if a third party uses your work it's all neat and tidy for them to grok. It also makes outputting the column super easy cause it's literally the exact same position.

Third tab is the general results tab and the front-end stuff you can show to people and can also be used as an input tab which feeds into the variables used in the calculations useed in the first tab.

On September 24 2015 05:21 jcarlsoniv wrote:
Not saying you're wrong, but at first glance, it doesn't seem like that'll work for me. Although I do have to keep my data in a way that can be consumed as an Excel data provider in BusinessObjects.

I'd show you if I could lol

On September 24 2015 05:12 Frudgey wrote:
MoonBear how did you become so smart? Did you worship the dark Pokemon gods and they gave you infinite knowledge?

Speaking of Pokemon, I picked up Alpha Sapphire (again). I went for Mudkip as my starter (named him Grimmles) and called myself Dr. Acula. Not sure of who I want for my final party, but I'm thinking of throwing in a Raltz and a Aron in there and seeing what happens. The Aggron will be dropped for a Tyranitar when I get the chance to get my hands on a Larvitar. (Hope I picked the right version to get Larvitar...)

Don't know what I'm going to fill in for my other three slots of my party though.

On September 24 2015 02:55 Gahlo wrote:
Anybody else interested in having LT do a episode by episode review of sense8?

On September 24 2015 05:12 Frudgey wrote:
MoonBear how did you become so smart? Did you worship the dark Pokemon gods and they gave you infinite knowledge?

Speaking of Pokemon, I picked up Alpha Sapphire (again). I went for Mudkip as my starter (named him Grimmles) and called myself Dr. Acula. Not sure of who I want for my final party, but I'm thinking of throwing in a Raltz and a Aron in there and seeing what happens. The Aggron will be dropped for a Tyranitar when I get the chance to get my hands on a Larvitar. (Hope I picked the right version to get Larvitar...)

Don't know what I'm going to fill in for my other three slots of my party though.

On September 24 2015 05:12 Frudgey wrote:
MoonBear how did you become so smart? Did you worship the dark Pokemon gods and they gave you infinite knowledge?

Speaking of Pokemon, I picked up Alpha Sapphire (again). I went for Mudkip as my starter (named him Grimmles) and called myself Dr. Acula. Not sure of who I want for my final party, but I'm thinking of throwing in a Raltz and a Aron in there and seeing what happens. The Aggron will be dropped for a Tyranitar when I get the chance to get my hands on a Larvitar. (Hope I picked the right version to get Larvitar...)

Don't know what I'm going to fill in for my other three slots of my party though.

On September 24 2015 05:30 MoonBear wrote:

I think I have a spare Larvitar I have lying around with egg moves too. I can replace Stealth Rocks with Earthquake since you likely don't need that. Gimme your Friend Code (I'll also add it to the OP). We can trade some time later this week.

Larvitar is Pokemon Y exclusive btw so no you won't find them in Hoenn.

On September 24 2015 05:48 Gahlo wrote:

Flygon is always nice if you have the patience to get past the mess that is Trapinch. Gyarados and Sharpedo are pluses, due to Gyarados' strength and Sharpedo's increased surf speed, but by choosing your starter correctly they aren't incredible pickups. Breloom is pretty cool. I've always been a fan Manetric in general, but he has added value in Water Region: Extra Water edition.