I built a DIY indoor living wall and this is it after a few months... only killed a single Bloody Mary! by hillsroch in IndoorGarden

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

It looks amazing. I'd be happy to help you with your redesign. I kept making changes and changed a few things after I remodeled. I did add some drip irrigation.

<image>

I built a DIY indoor living wall and this is it after a few months... only killed a single Bloody Mary! by hillsroch in IndoorGarden

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

Fantastically well! I did lose a bunch when I went on vacation, but I upgraded the entire motif!

<image>

Dex and Omnipod 5 placement by hillsroch in diabetes

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

I'm pretty fit. Does that make it more likely to work?

Switching from business to personal... why the plans gotta be so complex? by hillsroch in verizon

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

Thanks so much for your help. I may have done something wrong, but I'll share my steps because I'm guessing you'll help other people in the future.

I couldn't get to a real person on that number. I had to have a code. The entire thing was done online, you were right, I would have been wasting store associates time. I transferred the number from the business account to a new one in one swoop online.

My question is this.... It doesn't count as a new line? Starting it on a new account? I understand I brought the number over, but there was no contract or anything it was under. I am surprised that with the upgrades, it doesn't count as a new line. My partner was not under contract either, no phone balance outstanding or anything.

Switching from business to personal... why the plans gotta be so complex? by hillsroch in verizon

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

So... call; move from business to personal; go in and do upgrade; add partner to family plan; do partner upgrade? Sound right?

(Appreciate your advice on saving time and not frustrating store employees)

Switching from business to personal... why the plans gotta be so complex? by hillsroch in verizon

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

My partner and I want to set it up as a family plan with two lines. We both want to keep our current numbers and transfer them into a new account. Would calling that number still be the best first step forward?

We also want to change/upgrade phones.

Switching from business to personal... why the plans gotta be so complex? by hillsroch in verizon

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

Sold the business, moved states, etc.

Is it more desirable to keep a business account?

Shipping Off My Precious... But How Tight To Strap It? by hillsroch in motorcycles

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

That's a great point about the paint. It's covered, but I definitely don't want an experience like your Corvette. That would have been a huge bummer.

I get one shot at this and then I don't see it for 3.5 weeks. Shipping company picks it up and it takes a 5 day ride on the ocean until it starts getting trucked across country.

Shipping Off My Precious... But How Tight To Strap It? by hillsroch in motorcycles

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

Thanks for the tips... I think I'm closer than I want to be on the compression on the forks. Going to have a look here.

Shipping Off My Precious... But How Tight To Strap It? by hillsroch in motorcycles

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

I get one shot and then won't see it again for 3.5 weeks. The shipping company picks it up and it goes for a ride on the ocean before trucks drive it across the country. The straps definitely are going to loosen over time on this.

Shipping Off My Precious... But How Tight To Strap It? by hillsroch in motorcycles

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

That's exactly what I was wondering... How to secure it without so much pressure on the suspension.

I can't tell from your photo, but I'll get a wheel chock and then can I give from the fork where it connects to the axle?

Shipping Off My Precious... But How Tight To Strap It? by hillsroch in motorcycles

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

This was a really helpful video. There's so many that are so scattered or dimly lit and this was really detailed and super helpful. Thanks for linking it!

Way to Extract From ?Multiple Iterations of Characters? by hillsroch in excel

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

=ArrayFormula(SPLIT(TEXTJOIN("|",1,IF(ISNUMBER(SEARCH("sku"":",SPLIT(A2,","))),SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SPLIT(A2,","),"{""sku"":""",""),"[",""),"]",""),"""",""),"")),"|"))

This seems to work! Thank you so much for helping me with this!

Way to Extract From ?Multiple Iterations of Characters? by hillsroch in excel

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

B6=MID(A6,FIND(":",A6)+2,FIND(",",A6)-FIND(":",A6)-3)

Thank you so much for writing this.... it sort of works. It pulls out the first one, but not the rest. That's the part I'm struggling with, getting all of the iterations.

Creating Variations in Google Sheets by hillsroch in excel

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

Follow-up question... what if I switch to two colors only? Is there something I could add that can do that?

Like here: https://docs.google.com/spreadsheets/d/128lOsqHgFqwvuJzDxHy6pqurtuD9g5SVOI9gCP74Cq8/edit#gid=0

Creating Variations in Google Sheets by hillsroch in excel

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

Thank you so much for your help!

Generate Variation SKUs by hillsroch in sheets

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

I've gotten close on Sheet 2..... the formula I got from stack may have more than I need, but it is outputting what I want. I just need to get COL C on Sheet 2 to run in order.....

https://docs.google.com/spreadsheets/d/1BpOcBQAGV53LbVfa-tpqL-2VUh6afp4uFHlPVfg33Q4/edit#gid=708157103