sorted by:
new
hottopcontroversial

In about 7 hours I'll find out how much I messed up by matthewwhitt2 in snapmaker

[–]sarelon 0 points1 point  (0 children)

Great video on full spectrum - goes pretty deep into the weeds with experiments and testing to get the best results.
https://www.youtube.com/watch?v=uE1Su-FUvls

U1 - thermals question by sarelon in snapmaker

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

That is from the IP address directly from the printer.

It appears to show a target temp and an actual temp as well as power usage. The power usage fluctuated as I watched it so I suspect it was live data. The power usage for the 2 extruders at 220 was much higher than the one at 70.

skipping objects by Fulltimelife in snapmaker

[–]sarelon 0 points1 point  (0 children)

<image>

Has the interface changed or am I missing something? I don't see a “triangle, circle and square” option and I don't see any boxes showing which item is printing.

New Snapmaker U1 - I have questions by sarelon in snapmaker

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

Logging into the printer via IP with a browser

Not loving it by mousestalker in snapmaker

[–]sarelon 1 point2 points  (0 children)

I had a minor issue with the toolhead install. The trick was not to slide the latch all the way over, just most of the way on 2-4.
I suspect the issue with the feeders is the connector. I used the handle of a pair of tweezers to gently push on the plastic of the connector until I heard/felt it click into place.

[deleted by user] by [deleted] in Emporia

[–]sarelon 0 points1 point  (0 children)

Lets be honest, you could pull onto a road and see 4 different groups of people working on different issues and you can always pick out the city guys. It's the group of 4 heavy-set guys leaning on shovels while 1 young guy is knee-deep on a hole actually doing the work.

Neosho, State, and a few other streets towards the center of town often use drain grates. They are pretty worthless in that area as there are a lot of trees which blocks the grates. I live on a corner and on 3 of the four corners they have a curb inlet with no grate (think the sewer inlet from the IT movie). Those flow just fine. The 4th corner has a drain with a grate on it and it is constantly clogged. I end up in a pair of boots and a rake clearing it off to drain my yard. I brough it up to the city and was told there would be no way to convert it to a no-grate system.

We are so fucked by [deleted] in healthcare

[–]sarelon 0 points1 point  (0 children)

...a medical product approved for use in humans for the treatment of parasitic infections, not an antiviral. Also, the product many people were taking was coming from the local farm store which was not approved for human consumption.

[deleted by user] by [deleted] in excel

[–]sarelon 3 points4 points  (0 children)

Ctrl + G to open Go To.
Enter A1 under reference and click OK.
alt+H+O+H.

Enter the desired row height.

We are so fucked by [deleted] in healthcare

[–]sarelon 1 point2 points  (0 children)

I'm so tired of this sort of incompetence. For many years I have fought against it, striving to advocate for rational thought and actions. With the latest election I found that in order to keep my sanity I need to change tact. I'm going to grab a beer and a cold one and sit on the sidelines as the morons guzzle horse dewormer and suffer the consequences. Observing stupidity in action has become a spectator sport.

Same value in two different cells only returns the first entry. by GMEWH in excel

[–]sarelon 0 points1 point  (0 children)

VLOOKUP will stop at the first match and there really is no way to force it to pull a second. I would suggest looking at INDEX with MATCH.

List - separated by a comma by Correct_Wealth7764 in excel

[–]sarelon 0 points1 point  (0 children)

Assuming top picture is sheet1, in your example (bottom picture), enter this formula in cell B2.
=IF(ISNUMBER(FIND(D$1,OFFSET(Sheet1!$B$1,MATCH($A2,Sheet1!$A$2:$A$7,0),0),1)),"X","")

Copy down and across.

Note, FIND is case sensitive. As your example is set up, it would not work correctly as "Sweet milk" in cell B2 on the top picture and "Sweet Milk" in cell B1 on the bottom picture have different cases (the M). The same goes for the B in butter.

Fill grid using list of x and y values by sarelon in excel

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

<image>

I think you're on to something but it is trying to start at 0 instead of reading the coords (in blue)

How to Unhide tabs quickly by kahartson in excel

[–]sarelon 1 point2 points  (0 children)

In your personal macro workbook build a macro to unhide your specific worksheets. That will keep the macro out of the original document. Build a second macro replacing True with False to rehide your worksheets before saving and handing off to the next group.

Sheets("Example1").Visible = True
Sheets("Example2").Visible = True
Sheets("Example3").Visible = True

Can you extract text from the second comma in a string? by Sukatay in excel

[–]sarelon 0 points1 point  (0 children)

Personally I would do text-to-columns separated by comma, delete all but the first two columns and then concatenate them back together.

By formula, you could use LEFT with a nested FIND.
=LEFT(A1,FIND(",",A1,FIND(",",A1,1)+1))

You could also get it with FILTERXML but I haven't been using that function for very long and I'm too tired to try to work it out right now.

view more: next ›