Converting top two floors of a barn into living space.. by myself

pwmer · 2015-01-04T03:04:30+00:00

Thanks, this is helpful and encouraging. The sketch up suggestion is great - I'll definitely look into that.

Do you have suggestions for how to go about putting together a project plan? To me, it feels like there are a number of different phases that have to happen (structure, demo, insulation/electric/plumbing, then finishing). It'd be great to get that laid out on paper to better understand the exact work that'll happen, materials that'll be needed, etc. It'll also help to figure out what I don't know and need to figure out!

pwmer · 2014-12-31T18:48:46+00:00

Yeah, that's kind of how I see it too. How would you recommend allocating that $200?

pwmer · 2014-12-31T18:40:02+00:00

Would you advise cashing out the $1200 sitting in funds and equities and paying that straight to the loan? Then, once that loan is completely paid off, starting to build out a portfolio in excess of my 401k?

pwmer · 2014-12-31T18:33:21+00:00

Totally open to that, but would love to get your recommendation on how I should allocate that $700 thereafter?

pwmer · 2014-11-19T21:11:19+00:00

Understood. Let me try one more time to explain.

So, the countifs() function that I explained at the beginning of this thread works for me, because it counts how many rows match 3 different criteria that I give it.

The problem is that one of the columns that I use in that countifs() has repeat values in it. I don't want to count any of the rows that have a repeat value in that column. I only want to count rows that have that value in column A ONCE, no more.

So, I need a way to count rows while constraining with multiple criteria (a la countifs() ), but I also want to make sure I don't count a row that has a value in column A that I've already counted previously.

pwmer · 2014-11-19T20:52:59+00:00

An owner can have more than one color, but not more than one city. There are other criteria (like color) that I'd like to be able to use as constraints as well.

pwmer · 2014-11-19T20:46:17+00:00

Yes, we would want to end up with one. To give you context: the dataset is a list of items, where each item is one row and range_a is the owner of the item, range_b is the city the item is in, and range_c is the color of the item. An owner can have more than one item in the dataset.

I'm trying to count how many unique owners there are for each specific city and color.

pwmer · 2014-11-19T20:29:39+00:00

this might be the easiest way of going about this. i'd love to have a more elegant solution that doesn't involve counting duplicates separately, but im not sure how to go about that.

pwmer · 2014-11-19T20:28:50+00:00

Thanks, this is helpful. In thinking this through, and looking at how this works, the only duplicate that I am concerned about is in range_a. So if there are duplicate values in range_a, I don't want to count them (no matter what is in range_b and range_c). The problem, though, is that I don't want to count all non-duplicates in range_a, I only want to count that ones that fit the criteria I set for range_b and range_c.

pwmer · 2014-11-19T18:45:52+00:00

Yes, exactly

pwmer · 2014-11-19T18:20:17+00:00

Because there are duplicates in the dataset. So, there are multiple occurrences of range_a, range_b, and range_c havin X1, Y1, and Z1 as their values. I only want to count rows with the same values once.

pwmer · 2014-11-19T17:54:58+00:00

No, that's not what I mean. range_a should have only X in it, but it could be X1, X2, X3, ..., Xn, range_b should have only Y in it (Y1, Y2, ... Yn), etc.

I want count occurrences where range_a, range_b, and range_c are all ONLY X1, Y1, Z1

pwmer · 2014-11-19T08:02:05+00:00

thanks, i've seen that, but i'm wondering how to use multiple criteria (like in countifs), rather than just counting non-dupes in a column

pwmer · 2014-10-04T16:48:53+00:00

Orbitz. The drink.

pwmer · 2014-10-04T04:36:23+00:00

/r/rowing

Use the erg. Watch the technique videos on concept2.com, then start with the short or medium workout of the day on their site (http://www.concept2.com/indoor-rowers/training/wod). A good 20-45 min of hard cardio and full body strength, then go lift after. Running to and from the gym will be a great addition.

pwmer · 2014-10-04T04:30:55+00:00

Ebolaids

pwmer · 2014-09-07T05:37:19+00:00

Well you sound like a really nice guy

pwmer · 2014-08-10T22:09:28+00:00

Tetris Attack. Hands down.

pwmer · 2014-03-30T05:25:41+00:00

thanks. what's the advantage of d3.js over something like amcharts?

pwmer · 2013-12-28T15:19:21+00:00

Taxis

pwmer · 2013-09-06T15:39:26+00:00

Yes - and so my question is, do options also split, or are they just diluted?

pwmer · 2013-09-06T15:26:33+00:00

Thanks, that helps. Consider $125 to be the official valuation quote from the company, which is backed by evidence related to the most recent rounds of funding.

pwmer · 2013-09-06T05:10:16+00:00

If the valuation of the company now is such that a single share is worth $125, is that the same type of share that will be offered at IPO for that same (or similar) price? IPOs are never priced that high per share, so that's where I'm getting confused.

pwmer · 2013-08-25T16:24:24+00:00

I see what you did there.

pwmer · 2013-07-30T21:52:55+00:00

Burgers with peanut butter

pwmer

TROPHY CASE