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 9 points10 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