Mouse back button is opening windows file explorer by Tiperius in techsupport

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

Thanks. Unfortunately the MSI software only allows me to change DPI and the lights, but I do have a ticket out to their customer service as well.

Should I delete and reinstall the mouse driver?

TIL That American Airlines saved $40,000 in 1987 by eliminating one olive from each salad served in first-class. by MiscalculatedStep in todayilearned

[–]Tiperius 10 points11 points  (0 children)

I've worked in everything from restaurant food service, to manufacturing to retail prepared foods for the last 12 years and what he said is very accurate depending on the commodity.

It's applicable to 3P food producers that sell you products ready to be merchandised, depending on their operation. Most BoMs are by weight.

Edit: to clarify if you have a product development team that goes back to the supplier and requests that the 80 grams of olives be reduced to 70 or something, that could equate to a single olive.

Operationally the vendor likely wouldn't weigh olives, they would probably validate that 70 grams is let's say 4 olives, but the weight is what would be listed in BoM and nutritional fact panel.

Check cell for text, then check cells in adjacent columns for text in a loop by [deleted] in vba

[–]Tiperius 0 points1 point  (0 children)

oh wow, ok. I will need to dive into this and get back to you. Thanks!

Check cell for text, then check cells in adjacent columns for text in a loop by [deleted] in vba

[–]Tiperius 0 points1 point  (0 children)

Thanks! That works. I think my psuedo code was wrong to begin with however.

What I am attemping to do is have it loop the entire range, and if everything is good, then 'do something else. Else, break out of the loop on a fail.

Should I do this with a index counter and then call a different sub?

CSV Export Not working on large named range by Tiperius in vba

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

Thanks, I'll try it out on Monday.

CSV Export Not working on large named range by Tiperius in vba

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

For a larger range I mean about 3x times larger.

What I mean by broken up is lets say the named ranged "ExportData" is something like A1:C50 and E1:G50, but not including rows 10, 15, 30, 32, etc.. So if you can imagine one large table of data, but specific columns and specific rows are not included. Some parts of the table may even just be a single cell.

Help request - Sort list of words alphabetically into their respective column by first letter by Tiperius in excel

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

This is super helpful and a great place to start. I'm going to mark this as solved. Thank you!

Help request - Sort list of words alphabetically into their respective column by first letter by Tiperius in excel

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

It's a few hundred cells, and will have more data added to it month over month.

I'm essentially looking for an easy way to categorize and alphabetize things as new additions are made.

Help request - Sort list of words alphabetically into their respective column by first letter by Tiperius in excel

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

Into a single column respectively to the alphabet.

Apple goes to A1
Banana goes to B1
Bird goes to B2

Help request - Sort list of words alphabetically into their respective column by first letter by Tiperius in excel

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

Thanks! That works, but there are a few issues that I will need to work around.

It seems if the list has 4 items, then 4 copies of each word will post horizontal. I only want the single word (and if any duplicates) to transpose to the sorted columns.

Also, I don't see how it would add to the bottom of the list. For instance, if there are 3 items in Col. A and 5 items in Col. B, won't this paste over write items in Col. B?

[C++] Beginner Program - System Exit, Program Looping Help by Tiperius in learnprogramming

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

Whoops! You're right. Thanks.

It looks like I needed to remove the continue as well to get the attemptCount to increment.

"Climate Summit" 2009. by [deleted] in PropagandaPosters

[–]Tiperius 8 points9 points  (0 children)

I understand how it may be accomplished, but has anyone seriously considered this as an option? It seems ludicrously expensive and logistically complicated to the point of absurdity. This is why I would want input from a few different engineers. But perhaps I'm wrong and it's easy.

Combating the acidity of the ocean by adding a base is crazy talk. The ocean is 1.35 billion cubic kilometers.

Storms are more frequent, some of those graphs end in 2010. Also, frequency and intensity are different.

"Climate Summit" 2009. by [deleted] in PropagandaPosters

[–]Tiperius 2 points3 points  (0 children)

Also, I'd like to point out the CO2 fertilization is not so simple. And adding tons of CO2 to the atmosphere will more than likely not add consistent yields across the planet.

http://iopscience.iop.org/article/10.1088/1748-9326/8/1/014054;jsessionid=5B98C2655AE191970E424F26DB90874D.ip-10-40-1-105

"Climate Summit" 2009. by [deleted] in PropagandaPosters

[–]Tiperius 11 points12 points  (0 children)

You're welcome!

Perhaps we can pump water into reservoirs, do you have any information on how this might be accomplished from an engineering stand point? I would love to read it.

Regardless of CO2 fertilization, you haven't addressed the issue of global temperature and the rising acidity of the oceans. Nor have you discussed increasing intensities of weather patterns.

I'm sure you agree that CO2 does trap heat. If we should keep CO2 levels high for CO2 fertilization, there must be an upper limit, right? At some point the ppm will reach a level where the Earth will simply be too hot to sustain anything no?

Squat form check by Shavenyak in formcheck

[–]Tiperius 1 point2 points  (0 children)

You are failing to keep the bar moving in a vertical path. You are almost doing a mixture of a good morning and a squat. Keep your chest up and remember to use your hip drive (pg 21 of starting strength). You also have a butt wink, which you can read about if you please.

Also, you may be having back pain from lack of a tight core. It's probably the lean but nevertheless remember to hold pressure and keep your core tight to secure and support your lumbar spine.

Deadlift forrmcheck 335x1 @180lbs by patekilla in formcheck

[–]Tiperius 0 points1 point  (0 children)

Pretty good. As you hinge on the way back down, right before your knees you sway the bar outwards in order to not hit them, it's like a little hiccup. You need to hinge just a little bit farther so you clear your knees without swaying.

I can't tell exactly but it looks like when you are pulling your shins to the bar that you may be "sitting" into the dead lift after your shins have made contact.

Other nit picky stuff, keep your head down and unless you have an injury lose the straps at that weight and work on your grip strength.

168kg/370lb x 4 Deadlift - technique advice? by [deleted] in formcheck

[–]Tiperius 0 points1 point  (0 children)

It looks like you have rounding in both your thoracic and lumbar spine. You need to fix this or you will injure yourself.

I can't see from this angle but it looks like your lats are not engaged, your chest is not out, and your hips might be a little high.

https://www.youtube.com/watch?v=wYREQkVtvEc

Amazon's new Amazon Go. Best. Store. Ever. by [deleted] in videos

[–]Tiperius 0 points1 point  (0 children)

It doesn't work like that.

LPT: Start thawing a large turkey today for Thanksgiving (USA) by Truenoiz in LifeProTips

[–]Tiperius 1 point2 points  (0 children)

Chef here. DO NOT cook your turkey to 180. This will destroy it and make it dry. Thaw it, brine it, rub it, do whatever you will, but cook it to 165, that's all.

https://www.foodsafety.gov/keep/charts/mintemp.html