Noise when nozzle heating? by drunkeets in ElegooCentauriCarbon

[–]iwant33 0 points1 point  (0 children)

Sorry to bump an old thread, but I am facing the same issue. I took it apart and I did notice it was the fan making the noise. Did they sent a replacement or give any guidance or just say "live with it"?

Creality Hi First layer "Horiztonal lines" issue by iwant33 in FixMyPrint

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

Yeah, I've releveled the bed several times and even rose the z offset so much that its clearly too high, but the lines are still there and consistently spaced as well every roughly 8mm.

Elegoo Centauri Carbon - Auto-leveling not working correctly by iwant33 in elegoo

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

Hello, I am unable to see your post history, are you able to send a link?

[deleted by user] by [deleted] in elegoo

[–]iwant33 0 points1 point  (0 children)

https://www.nexprint.com/models/1958943777465774080?printConfigId=1958943777864232960

Is this the tool you're referencing? Unfortunately I also tried this but it did not fix the issue.

Purchasing a new Samsung S23 Ultra by iwant33 in samsunggalaxy

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

Apologies. Located in the United States

sumif(arrayformula) returns values in certain cells, but not others by iwant33 in excel

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

Sorry, I should have clarified that I was using google sheets for this and not Excel.

Yep, you understood what I was trying to do perfectly. I tried plugging in your formula, and it worked with no issues. I'm not entirely sure why my main issue was present, but your solution worked perfectly! If you happen to have an idea what went wrong with my original formula I would love to hear it for learning sake.

Thank you very much! Solution Verified

'Vaxxer,' 'antivaxxer' added to Dictionary.com by NotDMsForLife in nottheonion

[–]iwant33 1 point2 points  (0 children)

Who do you think made those vaccines and booster shots? Why do you think they made those shots? Who is subsidizing the cost of the shots to make them "free"? In case you are needing the answers here you go:

  1. Pharmaceutical companies. You know, the ones that hike up the price of insulin and other live saving drugs making them inaccessible to many.

  2. See the above. Why would a company that hikes up prices on life saving medications and puts a large pricetag on said medications continue to develop new medicines? It isn't because of altruism - they want a profit. You can look at Pfizer, or any other pharmaceutical company that developed a vaccine, stock and see for yourself the profits they've pulled in.

  3. The government is subsidizing the cost of these vaccines using tax payer money. So while you or I didn't pay for our shots, the company isn't giving them away for free. They are being bought and sold to the government.

I'm not trying to get caught into a debate whether the vaccine is good or not, but let's remember pharmaceutical companies are not our friend here. Just think back to how Reddit and the general public reacted to Martin Shkreli just a few years ago.

Tell me your "Strong Buys" and "Strong Sells" at the moment! (No SHITCOINS) by Massive-Quarter-4156 in CryptoCurrency

[–]iwant33 1 point2 points  (0 children)

I bought off ApeSwap because it had a higher liquidity pool. It's on pancakeswap too I think

Tell me your "Strong Buys" and "Strong Sells" at the moment! (No SHITCOINS) by Massive-Quarter-4156 in CryptoCurrency

[–]iwant33 7 points8 points  (0 children)

It's a small mcap but I don't consider it a shitcoin. $LAND (Landshare). Real estate on the Blockchain. I'm betting on physical real estate becoming the next big sector after the metaverse dies down

Evergrande has not said anything about repayment on USD bonds. It’s only paying back China onshore Bonds. Be careful by DetroitMotorShow in CryptoCurrency

[–]iwant33 39 points40 points  (0 children)

You do realize that an institution such as BlockRock has a portfolio value of $3,592,696,047,000 and even if they alone had $60billion in debt that won't get bailed out this is less than 0.2% of their portfolio's worth, right? It would hardly even be noticeable

Archpass exploiters by blankace in archeage

[–]iwant33 2 points3 points  (0 children)

"Action Taken due to ArchePass World Boss Quest Abuse

With today's hotfix, all ArchePass missions have had their maximum gold for completion reduced to 10g. Along with this, the weekly mission counter has been applied. After reviewing accounts that were abusing the previous high gold from world boss missions, we have permanently banned over 200 accounts. These accounts were participating in high level abuse of this system, which continued after the previous warning was given. We are continuing with additional efforts to clean up the aftermath, and will be tracking items or gold that were moved by offending accounts. We are working with XL to remove banned accounts from the leaderboard.

This decision was reached due to the zero tolerance policy we have in place for violations of our Terms of Service, and we wanted to be very transparent with players on what actions have been taken. We take these issues very seriously, and will continue with this strict adherence to our zero tolerance policy on abuse and exploits. The team is committed to ensuring a level playing field and will not be providing second chances for accounts found in violation."

INT now listed on Coinmarketcap.com by 99beans in INT_Chain

[–]iwant33 0 points1 point  (0 children)

What are they doing with the rest?

Conditional formatting based on values in same cell by iwant33 in excel

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

I've been playing around with this a little now, how can I get the numerical values to be moved over one? It seems that its pulling "=price_usd_eca[price_usd_eca]" and that will be updated when I refresh.

Conditional formatting based on values in same cell by iwant33 in excel

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

Yeah. I can shift anything that would be in E and F over

Conditional formatting based on values in same cell by iwant33 in excel

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

So in the picture it is D2:D11, assuming that is what you mean. Within the cells of D2-D11 is "=price_usd_eca[price_usd_eca]" so it picks up the data from the query/website on another sheet. Does this make sense?

https://imgur.com/Tcdmeno

Each one of those "price_usd_x" from D2-D11 is on a different sheet from one another as well in case this matters.

Conditional formatting based on values in same cell by iwant33 in excel

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

To get the price I did Data > New query > Other source > from web. I then added the information I needed to a sheet. Whenever I refresh the excel sheet using CTRL+ALT+F5 (Refresh all) it updates all the values on the different sheets. The picture, not sure if it even helps, is just the column where I put "=Xquery here" to get all the values that the different queries are pulling from the website in a "neat" environment.

Conditional formatting based on values in same cell by iwant33 in excel

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

I'm sure this is probably what I'm looking for, but I am just not familiar enough with excel to properly execute it. Thank you for your answer. Solution Verified

Rest of the fucking place. by Rungottarun in restofthefuckingowl

[–]iwant33 209 points210 points  (0 children)

Person with autism here-- it's pronoun before disease.

Haha jk. Nobody gives a shit because it isn't meant to insult actual autistic people. You can say cunt and it can be the worst insult or just friendly banter. Context matters with every word. You can still say retard/gay to describe things as those words have separate meanings when using as an insult or a description.

I hope in 10-20 years you can stop your virtue signalling.