I don't know anything about that spreadsheet, but it depends on the promo and the ariline even more than on what elite level you area.

The reason: Most airlines are miles/$ proportional to the points earning (with the ratio being the same as you'll later get in converting points to miles), so with that said, especially if you get an elite bonus, it usually makes more sense to earn points first and convert to miles later.

But it's all different for Southwest, because Southwest earns a flat 600 RR 2.0 points for a stay, independent of the length or cost of the stay.

Then the promos make it way more complicated. RIght now, you may be able to earn cat 1-4 free night certs (one for every 2 stays, up to a max of 3) if you earn points, but there's no miles promo (until July 1). How do you value a free night cert? (No one else can value it for you, since it depends on how you'll use it!) Then starting July 1, it's triple miles (starting with your second miles earning stay). So it's still proportional to spend with other airlines, and now 1800 RR 2.0 points per stay (regardless of stay length or cost) with Southwest.

Southwest points are easier to value because their value is more-or-less fixed. 600 RR 2.0 points is worth $10 WGA redemption, so 1800 RR 2.0 points is worth $30 WGA redemption. A free night cert is almost certain to be worth more than $60, and so until you've maxed out the free night cert the points are probably the way better value (but because of the free night certs, not because of the points themsleves!). After that, it's harder to see how to get $30 value out of the points you earn on a cheap suburban one-night stay, but is that the kind of stays you do, or do you do week-long stays at expensive properties?

Marriott points are harder to value, because again it depends on how you'll redeem them. (There's in particular a giant redemption difference depending on whether you can make use of the stay-plus-miles redemption "packages" or not.)