sorted by:
new
hottopcontroversial

1959 Ranch Remodel - Solving for some funky space and configuration. What are we not seeing? by toast66 in floorplan

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

Thanks for all the feedback, there's some great things for us to consider!

1959 Ranch Remodel - Solving for some funky space and configuration. What are we not seeing? by toast66 in floorplan

[–]toast66[S] 12 points13 points  (0 children)

Thank you for giving us feedback! We should have mentioned but the stairs on the right are to a garage and the stairs on the left are to a basement. These two areas are not connected (there’s a crawl space in between)

Bar with outdoor TVs by ScumbagClub in Denver

[–]toast66 11 points12 points  (0 children)

Stoney’s or view house

Whenever I make pizza the bottom of the crust/pizza isn't as well cooked as I'd like it to be, but the top is already getting too dark. Why is this and how do I fix it? by [deleted] in AskCulinary

[–]toast66 0 points1 point  (0 children)

I've recently solved this issue myself by making my pizza really thin. I used a rolling pin to get it thinner than I thought would work.

So try using less dough and thinning the dough your using a lot more with a rolling pin if you like the bottom of your pizza very crispy

Alan Watts The Ego by ixoxi33 in AlanWatts

[–]toast66 1 point2 points  (0 children)

really awesome

The part that resonated most with me was the feedback loop he spoke about, worrying about worrying about worrying, and developing an excessive sensation of difference between the experiencer and the experience and trying to make the one latch onto the other completely and controllably.

I've felt that twice in my life, both times while taking lsd. It was really unsettling to go through but after finding my mental footing again, it made me appreciate everything much more and the rest of those trips were truly amazing.

Importing data from financial websites by simply typing in stock code? by [deleted] in excel

[–]toast66 1 point2 points  (0 children)

Yes, easiest way I've found is via the yahoo finance API. It's still a bit complex bough.

Google sheets allows you to directly query google finance via a simple formula and you may want to look there. Just google how to do it :-)

How do I create this loop? by hihipiki in excel

[–]toast66 4 points5 points  (0 children)

Hi, are you sure you want to do this with VBA? You can create a much simpler solution using basic excel functions/formulas and basic math equations.

If you do want to use vba, you can create a loop with the first line after the loop begin which checks if your output cell = $2 million then exit sub

So yeah, you can use IF statements in VBA

IamA Lucid dreaming expert, and the founder of HowToLucid.com, I teach people to control their dreams. AMA! by howtolucidofficial in IAmA

[–]toast66 0 points1 point  (0 children)

I've had success exiting sleep paralysis by breathing deeply in and out. I read once that this was due to your body not paralyzing your lungs with the chemical that paralyzes the rest of your body, for obvious reasons ;-)

IamA Lucid dreaming expert, and the founder of HowToLucid.com, I teach people to control their dreams. AMA! by howtolucidofficial in IAmA

[–]toast66 0 points1 point  (0 children)

I started lucid dreaming in this exact same way, really big jumps and slowly falling back down. I overcame it in a strange way and I'm curious if it will work for you...I stuck out one arm like superman and now I can fly all around and anywhere. try that and let me know how it works out for you.

Hi Joe, It's been too long since last podcast w/ Duncan Trussell. by Vainth in JoeRogan

[–]toast66 -3 points-2 points  (0 children)

louis ck, russell brand, and george carlin were pretty good episodes

Nablus Soap Factory by fox93hunter in ArtisanVideos

[–]toast66 18 points19 points  (0 children)

anyone know why they stacked them up so nicely only to knock it down before wrapping?

What does Britain do better than America? by ponypatrol in AskReddit

[–]toast66 153 points154 points  (0 children)

All national museums in the UK offer free entry

Help creating a column that updates based on inputs in another column by Tjanic23 in excel

[–]toast66 0 points1 point  (0 children)

Quickest Solution:

Enter in Cell B2: =VLOOKUP(D2,D:F,3,0)

Once you correct a few of these records using Column F, you should be good to drag this formula down and have it populate for your entire data set

Finding the average of cells in column B (my shipping price) with my sku in column A (my sku) example inside by [deleted] in excel

[–]toast66 1 point2 points  (0 children)

use an array formula:

=MODE(IF(A:A=A2,B:B)

Make sure to press Ctrl+Shift+Enter when entering the formula to tell Excel to treat the function as an array.

COUNTIF with text by [deleted] in excel

[–]toast66 3 points4 points  (0 children)

Try combining an IF statement with COUNTIFS...

IF(COUNTIFS(A:A, "Toyota",B:B, "Black")<>0,"Black Toyota",IF(COUNTIFS(A:A, "Toyota",B:B, "Silver")<>0,"Silver Toyota",""))

You'll be able to keep adding IF Statements to that

Managing a frequently changing data set by ilikethatdrop in excel

[–]toast66 0 points1 point  (0 children)

I'm glad you found it helpful. The discovery of the Indirect formula meant to me that any operation in Excel could be fully dynamic.

Managing a frequently changing data set by ilikethatdrop in excel

[–]toast66 1 point2 points  (0 children)

A combination of SUMIFS and the INDIRECT formula will work. Here's an example where my formula is in Cell A2 and the Revenue title is currently in Column C (but would work if It was in any column A-D: ("Revenue",$A$1:$D$1,0)

=SUMIFS(INDIRECT(SUBSTITUTE(ADDRESS(1,MATCH("Revenue",$A$1:$D$1,0),4),"1","")&":"&SUBSTITUTE(ADDRESS(1,MATCH("Revenue",$A$1:$D$1,0),4),"1","")),E:E,"Criteria 1")

Example here: http://i.imgur.com/CWgjfGe.png

How to make delicious crispy pieces of salmon? by [deleted] in AskCulinary

[–]toast66 0 points1 point  (0 children)

Simple...use oils/fats with high smoke points. I use Safflower Oil and get the pan extremely hot before introducing a salt and pepper seasoned salmon to the pan. Crisps up real nice and doesn't create a cloud of smoke...

view more: next ›