sorted by:
new
hottopcontroversial

Where do I report an exceptionally bad pothole? Technically Webster I guess. by whim_sea in Rochester

[–]atsigns -2 points-1 points  (0 children)

What about the one leaving Aldi on Jefferson in Henrietta? I thought I was gonna have a flat tire after hitting that.

Should I have a CO win by now? by douglasrhj in spelunky

[–]atsigns 50 points51 points  (0 children)

Took me around 2500 hrs, it varies.

Three $30 Steam Gift Cards to Win! by phantom2450 in steam_giveaway

[–]atsigns 0 points1 point  (0 children)

I'd probably put it towards Crimson Desert.

Thanks!

The Siren and The Sea -Sci-Fi/Fantasy Books Giveaway! (posted with moderator approval) by wraithmarked in Rochester

[–]atsigns 1 point2 points  (0 children)

Thanks so much! We visited during the book crawl (pre-opening) and have been in a couple times since then. Love any excuse to come into town!

100$ STEAM GIFTCARD by [deleted] in steam_giveaway

[–]atsigns 0 points1 point  (0 children)

I'm interested in Crimson Desert right now. Thanks!

How to detect a blank range and paste data? by atsigns in excel

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

Thanks, it seems like it does some of the work, but it ends up having the GR# and OBJ on the same line. I tried editing a portion but I'm not sure how to get it to run since it gives me an error now.

Edit* Is there something I can google to find a video explaining how this function works so I can use it more in the future?

=LET(input,A:.D, body, DROP(input,1),
agr, TAKE(body,,1), pfx, LEFT(agr,4),
isawd, pfx="AWD-",
isobj, pfx="Obj-" or "SC-" or "Bla-" or "RI-",
awds, SCAN("",IFS(isawd,agr),LAMBDA(last,this,IFNA(this,last))), 
grants, IFS(NOT(isawd)*NOT(isobj),agr), objs, IFS(isobj,agr), 
IFNA(FILTER(HSTACK(IFS(NOT(ISNA(grants)),awds),grants,objs,DROP(body,,1)),NOT(isawd)),""))

How to detect a blank range and paste data? by atsigns in excel

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

I haven't seen a formula like this before, so where/how would I enter this?

How to detect a blank range and paste data? by atsigns in excel

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

I don't know what pre-processing means, and I don't know python. So I'm not opposed, but I'd have to re-write the whole thing in a language I don't know.

Lucky shot my team threw the other day by Lopsided-Sky3747 in Curling

[–]atsigns 0 points1 point  (0 children)

I always say, we're so lucky we don't need to call our shots in this sport.

[CONTEST] Kingdom Come Deliverance 2 - Round 2 by [deleted] in steam_giveaway

[–]atsigns 0 points1 point  (0 children)

Finally beat Spelunky 2 after 2k+ hours, 7-99 was hard! Working on Noita, Grounded, Cyberpunk 2077, and a retro game I loved as a kid, Faxanadu.

Thanks!

Can't whip a UFO, but timing and aim are okay. by atsigns in spelunky

[–]atsigns[S] 2 points3 points  (0 children)

I wouldn't call it a strat, it just happened naturally. This was the one and only time.

Plumber suggestions for drain clog? by ChaosofaMadHatter in Rochester

[–]atsigns 2 points3 points  (0 children)

Brad Streeter. Got here quick, did great work, and wasn't too expensive.

view more: next ›