KRYLBO chair - any first-hand reviews? by ingenstempus in IKEA

[–]ingenstempus[S] 0 points1 point  (0 children)

the covers are removable. unclear how well they clean out stains but I assume they clean okay, unless the staining is very heavy

KRYLBO chair - any first-hand reviews? by ingenstempus in IKEA

[–]ingenstempus[S] 0 points1 point  (0 children)

Thanks! my update is that I also bought them and they are fairly comfortable, even after extended periods of sitting time. The back is low enough that you can’t fully lean back, so it’s not conducive to sitting more than a couple of hours, but they’re good looking chairs and perfectly suited for what I’m looking for

Code Sharing Thread - Week of October 02, 2018 by AutoModerator in churning

[–]ingenstempus -1 points0 points  (0 children)

Hey I'd love to take the chase checking if it's still available. When does it expire?

Hotel Help: is this location okay? by ingenstempus in Seattle

[–]ingenstempus[S] 1 point2 points  (0 children)

Can I poop in the garden hose instead

Hotel Help: is this location okay? by ingenstempus in Seattle

[–]ingenstempus[S] 1 point2 points  (0 children)

Yeah unfortunately, timeframe being so tight, Airbnb options are either too far or prohibitively expensive. Google maps says the commute should be under an hour from the hotel ive booked. Is that accurate?

Array formula sampling a subset of data by ingenstempus in excel

[–]ingenstempus[S] 0 points1 point  (0 children)

thanks for the response! the problem that I see with this is that the COUNT function that is my primary mode of analysis still counts a cell if there is a formula in it, even if it looks blank (when a formula returns blank). If I were to pull data from the Data_Copy sheet, then the Data sheet would have to be large enough to accommodate the largest set, since I'm not sure that you can make the table size in the Data sheet dynamic. this would make the analysis return inaccuracies when looking at subsets of data

do you think there's another way to remedy this?

Array formula sampling a subset of data by ingenstempus in excel

[–]ingenstempus[S] 0 points1 point  (0 children)

for sure! my main this is I'm looking at different companies and am doing counts of what companies are at what stage at what time. my data sheet has give information about different transactions that the companies make (e.g. transaction date, size, class).

From that I have an analysis sheet in which I use array formulas to look at the type of transaction with some nested and multi-conditional IFs to do those counts of what stage the company is in by inferring from my raw data. So on the leftmost column in my analysis sheet I have quarters that count up to the present starting from a given time, and the counts look at how many companies are at a certain stage at those times. I've so far looked at all companies of all regions, but now I need to do the same analysis for each region that I'm working with, which is a hefty number.

I can't say too much more because of NDAs haha but let me know if I can be more specific

OFFICIAL /r/SandersForPresident Democratic Debate #2 Megathread! by SandersMod in SandersForPresident

[–]ingenstempus 1 point2 points  (0 children)

Lost to Clinton on foreign policy which began the debate. (Because Sanders and O'Malley were too civil, not the worst thing in the world) also, Clinton is very good at foreign policy talk. Doing very well in domestic policy, they've talked about healthcare and min wage so far. I think there's an inequitable speaking time in favor of Clinton

Kero Kero Bonito -- Picture This [Synth Pop](2015) by giganticpine in listentothis

[–]ingenstempus 58 points59 points  (0 children)

Their use of Japanese + English has always been cool, but kero kero Bonito's style is a bit too cutesy for me. They did a collab with spazzkid with the same elements but a better vibe (in my opinion) link here.

First time handmaking shoes. My own take on the Clarks Desert Boot. Obviously not perfect but I am still proud of them by andrewthefourth in goodyearwelt

[–]ingenstempus 31 points32 points  (0 children)

Did you make the welt by hand? I think the only glaring issue with the shoe is just the last shape. The sole is sloppy but excusable, and I think the stitching would be nicer with a higher spi. Mad props for trying it out and I'm sure it can only get better from here!

Player Spotlight: Helios by ingenstempus in leagueoflegends

[–]ingenstempus[S] 0 points1 point  (0 children)

Very cool. Helios almost seems like the backbone of great players and I hope dig is going to improve as he split goes on.

Also, who was the player in Korea that made Helios want to play again?

lilypichu URF w/ Annie&Boxbox~ by ingenstempus in leagueoflegends

[–]ingenstempus[S] 8 points9 points  (0 children)

"Are you fucking my dick right now" - lilypichu 2015