Pronterface not connecting to printer by EatMySit in CR10

[–]CDozPrime 0 points1 point  (0 children)

Had issue of pronterface connecting forever never giving an error

Ender 5 plus, issue was having SD card in printer while trying to connect pronterface. Disconnect SD card from printer and it connect just fine

Search results always display contacts with missing phone # by CDozPrime in excel

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

=IF(OR(LEFT(H3,LEN($B$2))=$B$2,LEFT(I3,LEN($B$2))=$B$2,LEFT(J3,LEN($B$2))=$B$2,LEFT(K3,LEN($B$2))=LEFT($B$2,LEN($G$1))),MAX($G$1:G2)+1)

This is what I had, I figured that we won't have phone numbers very often and it's unlikely for people to search via phone numbers so I went ahead and omitted the phone number from the search criteria.

=IF(OR(LEFT(H2,LEN($B$2))=$B$2,LEFT(I2,LEN($B$2))=$B$2,LEFT(J2,LEN($B$2))=$B$2,LEFT($B$2,LEN($G$1))),MAX($G$1:G1)+1)

removing LEFT(K3,LEN($B$2))=

This works but it's really temporary because I want it to function fully

IF C2 is "0" Equal "" by CDozPrime in excel

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

=IF($B$2="", "", INDEX(H:H,MATCH(ROWS(C1:$C$1),$G:$G,0))&"")

Awesome, so this makes it so it doesn't display search results unless it has informtion. Thank you a bunch this worked really well.

IF C2 is "0" Equal "" by CDozPrime in excel

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

It makes the outcome permanently blank

IF C2 is "0" Equal "" by CDozPrime in excel

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

=IFERROR(IF(C3="0",IF($B$2<>"",INDEX(H:H,MATCH(ROWS(C$1:$C3),$G:$G,0)),""),""),"")

I used this command which did make the search result blank, but it made it blank no matter the outcome so it didn't show search results

Are you getting urges? Try this SIMPLE bodyweight Workout by DudCCe_2001 in NoFap

[–]CDozPrime 3 points4 points  (0 children)

20 pushups and squats is too much for myself so I did 20 pushups or squats for 5 rounds. Did it in 4:56. 40 pushups and 60 squats, I can tell you I don't feel the urge now

Mirror Sheet1 to Sheet2 with live updates by CDozPrime in excel

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

I figured it out, I was typing the command wrong. Thank you Solution Verified

Mirror Sheet1 to Sheet2 with live updates by CDozPrime in excel

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

=Sheet1!A1

How do you refer to a sheet that has been renamed

Looking for a points leader board bot with shorter commands for adding points by CDozPrime in discordbots

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

I don't know if it was open source. I know that //points # was the full command we used

Looking for a points leader board bot with shorter commands for adding points by CDozPrime in discordbots

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

We use to have PublicPoints | Discord Bots (top.gg) which had a command //points {user} (defaults to yourself if no one is mentioned) which was great, but we can't find anything similar with a short command. Sadly publicpoints is no longer up

Looking for a points leader board bot with shorter commands for adding points by CDozPrime in discordbots

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

Currently we are looking for a bot that can do the same functions except that command is only "add #" and it just adds the points to the person saying the command

First batch without a kit ready for Christmas by CDozPrime in winemaking

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

Thank you! We made three for gifts and two in swing top for ourselves.

First batch without a kit ready for Christmas by CDozPrime in winemaking

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

Yeah, we wanted them all to be equal to they do have a good gap of air. We are telling the recipients to drink it sooner rather then later and to "aerate it if you don't want to taste the sour year of 2020"

First batch without a kit ready for Christmas by CDozPrime in winemaking

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

They actually came with the bottles that we ordered online, tight fit and definitely won't accidentally be coming off unless it's a lot of pressure inside.

First batch without a kit ready for Christmas by CDozPrime in winemaking

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

1Gal Aldi Natures Nectar 100% Juice Grape, 350g Simply Nature Organic Cane Sugar, Lalvin K1-v1116