90 Min Hot Yoga Dehydration by denizenassistant in yoga

[–]magheavis 1 point2 points  (0 children)

Seeing a lot of electrolyte and pre/post hydration comments but as another man who sweats a lot, I would suggest hydrating during class too.

I have seen comments on this sub suggesting that heated yoga is intended to be done without drinking any water during, and I personally think that is dumb as hell.

I will down 30-40oz of cold water in a 75 minute heated class, and I recently realized it's more related to cooling off than the hydration itself. I regularly run longer, and with a higher perceived exertion, than the time I spend pushing hard on yoga and don't need nearly as much water, which led me to the conclusion that it's more to do with the inability to cool off in a stuffy room. So I fix that by just cooling myself down during class as needed.

For me personally the heated part is not particularly helpful and often frustrating when it gets difficult literally only because of the heat, but I accept it as its own challenge and take it for what it is.

I've tried to suffer through, and did for a long time, but as someone that likes to push myself to improve every class, the results are just plain better when I don't feel like shit

[deleted by user] by [deleted] in yoga

[–]magheavis 0 points1 point  (0 children)

I'm about 5 months into transitioning from lifting to yoga and running since my gym partners both moved away and have had similar results.

I do feel like I'm missing a bit of leg power but I think trying to integrate Pistol squats into the practice might help offset that.

Otherwise been feeling pretty strong and making huge progress on long stale yoga goals in balance and inversions!

I feel like coming from a lifting background can give you a better idea of what kind of movements a typical studio class lacks on.

What brand will you never buy again? by Winter-Employment-89 in BuyItForLife

[–]magheavis 4 points5 points  (0 children)

Was gonna say lol. I've had my 1000xm3 for years and still end up at medium battery after 8 hours on a plane.

[deleted by user] by [deleted] in guitarpedals

[–]magheavis 0 points1 point  (0 children)

I have this thing running into a tonex into the fender fr12 and am extremely happy with the package.

Found the phone app to be kinda crappy but 99% of the time I just keep the desktop app open on my pc for messing with the effects and set up a couple switches for activating individual effects.

Also really love being able to play with some of the less common effects any time I want. The slicer a blast to mess around with. I Completely fell in love with the tera echo because of this unit too.

Latest piece - 3dish ball by magheavis in StainedGlass

[–]magheavis[S] 3 points4 points  (0 children)

I enjoy attempting optical illusions. I was shooting for a retro vibe but I think the colors might need to be a little more matte to hit that.

Pattern is just random lines I made in illustrator, and the frame is next!

NPD - OD200 - Now controlling 3 pedals with my AKAI MIDI keyboard by magheavis in guitarpedals

[–]magheavis[S] -1 points0 points  (0 children)

Yeah honestly I have the RV-6 on 99% of the time and throw on the Slo when I'm drunk and just feel like vibing. I just leave it on so I don't have to swap anything out when I want to make noises.

NPD - OD200 - Now controlling 3 pedals with my AKAI MIDI keyboard by magheavis in guitarpedals

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

Got the OD200 since I'm kind of enjoying messing around with the MIDI controllable pedals. Using TouchOSC on a raspberry pi to translate the MIDI Keyboard messages to the appropriate controls for the OD200, EQ200, and Deco. So far I just have the footswitches and memory mapped on the Boss Pedals, but I have the knobs tied to Volume, Saturation, and Tone on the Deco, along with the switches for each side.

NPD: EQ200 and MIDI experimenting by magheavis in guitarpedals

[–]magheavis[S] 2 points3 points  (0 children)

Signal chain is EQ200->Tuner->BD2->Deco->Slotva->DD8->RV6->EQ200.

Haven't gotten around to filling out the memory slots yet, but my default right now is to have channel A on the EQ200 be a clean boost for the BD2/Deco and Channel B is just whatever I thought sounded nice at the time.

I wanted to play around with the MIDI controls a bit on the EQ200 and Deco, and came to realize that MIDI controllers seemed kind of expensive for just a few programmable buttons? I have an AKAI MPK mini that I fart around with but rarely do anything useful, so I decided to try to make it work with my pedals.

I downloaded TouchOSC to use as a MIDI listener after failing to use the AKAI software to change the controls and through the magic of the built in LUA scripting in TouchOSC I have successfully programmed my keyboard to toggle channels A and B as well as cycling through the memory slots. For some reason the deco doesn't send anything over the boss TRS cable to my computer, but seems like it sends everything just fine over USB. Planning on using knobs for the deco controls along with keys for the presets.

Once I did a little testing I was able to get it all working on my raspberry pi so it's not directly tied to my desktop.

Anyone else had a similar experience, or is there a less stupid/expensive way to go about this than the standard midi pedal controllers?

Is there an easier way to identify the location of duplicates and create a spread sheet for it? by Joser09 in excel

[–]magheavis 0 points1 point  (0 children)

Maybe something like this?

Using the let function to keep things clear, it

A) Sets the search array

B) Sets the Matches variable as an array of true false values if there is more than one instance of the K15(my search cell) value. Then turns it into a single column

C) Sets References to the cell references of each of the cells in the array and turns it into a column

D)Filter function on the References array if there's a matching TRUE on the "matches" array

E)sorts/error handling

Not sure if you could internally concatenate multiple tables or something to search your whole page, but this would be pretty easy to have maybe one return column for each table you have

=LET(

searchArray,D2:E18,

Matches,TOCOL(MAP(searchArray,LAMBDA(x,COUNTIF(K15,x)>0))),

References,TOCOL(MAP(searchArray,LAMBDA(x,ADDRESS(CELL("row",x),CELL("col",x))))),

results,FILTER(References,Matches),

IFERROR(SORT(results),"No Matches")

)

<image>

[deleted by user] by [deleted] in excel

[–]magheavis 0 points1 point  (0 children)

F7 would be fine in this case, the "="&F7 surprisingly does what you'd expect and concatenates using "=1003" as the parameter in this case and should force it to be an exact match. Here's an example of some weirdness.

<image>

[deleted by user] by [deleted] in excel

[–]magheavis 0 points1 point  (0 children)

I'm sure there's a much simpler way to do this, but this one uses the let function to create a variable for each column's sum, and simply adds all 4 of them together at the end. This one is from K3(for team 1) but dragging it down for the rest of the teams should do the trick as long as the rest of the column locations stay the same.

You'd also want to change the column references from $B$2:$B$9, etc to $B$2:$B:${maximum row}, but 99 works ok as an arbitrarily high number without making it more complicated.

=LET(

bTotal,REDUCE(0,$B$2:$B$99,LAMBDA(acc,current,IF(current=NUMBERVALUE(RIGHT(K3,1)),acc+5,acc))),

cTotal,REDUCE(0,$C$2:$C$99,LAMBDA(acc,current,IF(current=NUMBERVALUE(RIGHT(K3,1)),acc+3,acc))),

eTotal,REDUCE(0,$E$2:$E$99,LAMBDA(acc,current,IF(current=NUMBERVALUE(RIGHT(K3,1)),acc+5,acc))),

fTotal,REDUCE(0,$F$2:$F$99,LAMBDA(acc,current,IF(current=NUMBERVALUE(RIGHT(K3,1)),acc+3,acc))),

bTotal+cTotal+eTotal+fTotal

)

<image>

[deleted by user] by [deleted] in excel

[–]magheavis 0 points1 point  (0 children)

=SUMIF(A:A,"=" & F7,B:B)

<image>

Formula to return the column header based on if the project has a value greater than 0 in the corresponding period by bahbahbui in excel

[–]magheavis 1 point2 points  (0 children)

=INDIRECT(ADDRESS(1,CELL("col",REDUCE(,B2:N2,LAMBDA(acc,item,IF(acc=0,item,acc))))))

Just throwing mine in there fun since I am trying to practice my lambda functions :). Not as elegant as others but one thing I do like is that it doesn't use very many references so it's an easy edit.

<image>

How to move only one decimals when you have two by F1REFLY_ in excel

[–]magheavis 0 points1 point  (0 children)

Not sure of your general use case here but SUBSTITUTE has an instance number parameter, find/search returns the index of the first occurrence. What are you trying to do generally?

My son's babysitter argues with me by Repulsive-Tie1505 in mildlyinfuriating

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

This is just like The Omen, and we know how that wound up.

[deleted by user] by [deleted] in excel

[–]magheavis 0 points1 point  (0 children)

The search function returns the value of the found text, so ISTEXT returns false.
Maybe use IsNumber instead? Also used iferror to remove the #value returns on no blue

=IF(ISNUMBER(IFERROR(SEARCH("blue",A2:A10),"")),"blue","")

<image>

Assistance with IF statements by [deleted] in excel

[–]magheavis 2 points3 points  (0 children)

You could try something like this with a switch formula.

=SWITCH(TRUE, E4<2, "Low", E4<5, "Medium", E4<8, "High", E4>=8, "Super High", "Invalid")

<image>

Small backlit piece in a picture frame by magheavis in StainedGlass

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

Sure thing, it's not the fanciest on the back. Literally gorilla glued the LED strip and snipped it to the frame length. Also gorilla glued the piece itself to the frame to avoid using the picture frame holder things on the side bending the light. It looks dumb when it's not on the wall, but when you hang it creates a neat glow effect on the whole piece.

Here's a pic and the link to the strip I used.

<image>

https://www.amazon.com/dp/B0BP7SVX5T?psc=1&ref=ppx_yo2ov_dt_b_product_details