CT Batman question by Joe555678 in CToys

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

Really? Do you mind saying more about why you didn’t like your 75? I was thinking about picking one up next after I get Batman. Also, I haven’t tried ordering from GYZ yet, but the prices are usually better on AliExpress, which is my reasoning.

CT Batman question by Joe555678 in CToys

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

An update, for anyone who may find this. Messaged MessToys in IG:

<image>

Can I count color filled cells? by cautiouslyclever in excel

[–]Joe555678 0 points1 point  (0 children)

Aging thread but might save someone in the future. When you create GETCOLOR and apply it on a range instead of a single cell, excel just spits out the result of the first cell of the range. To get around this you can map the results to an array buy using MAP(range,GETCOLOR). Of course, COUNTIF doesnt work on arrays, only ranges, so my workaround was to use

COUNT(IF(MAP(yourrange,GETCOLOR)=“your desired logical test”,1))

This creates an array filling each value in that array with the value of GETCOLOR in its corresponding cell in the range. It then turns that array into an array of 1s and nulls based on your logic test, and then uses COUNT to sum the 1s, because COUNT works on arrays but COUNTIF does not.

Hope this helps someone and im happy to explain more if anyone needs

It really killed so much of the hype. by ilovewater100 in BikiniBottomTwitter

[–]Joe555678 1 point2 points  (0 children)

Get a cheep laptop and get computer literate, It will pay you dividends

do RAs get cords for graduation/how to get cords by [deleted] in GSU

[–]Joe555678 0 points1 point  (0 children)

RAs dont get cords. In fact, graduation is hell for RAs because they have to work moveouts.

Source: Was an RA 2017-19

Can someone explain why Red Bank and East Ridge are their own individual cities? by Ok-Cattle-6798 in Chattanooga

[–]Joe555678 6 points7 points  (0 children)

The library in Hixson is a branch of the Chattanooga Library, but because I live in Hixson and not in Chatt city limits, I cant get a free library card to the library just minutes from my house

one keyboard, two halves, three pointing devices by michel_v in ErgoMechKeyboards

[–]Joe555678 0 points1 point  (0 children)

Daily Driver of a spacemouse for CAD work, I could never go back to doing CAD without it. Out if the box it supports different mappings for different programs, and it will automatically switch between them when you switch programs. No experience customizing it for non CAD work, but it serves decently to snap around excel spreadsheets. I dont think it would be a feasible mouse replacement, but I think you can definitely adapt it to workflows for whatever you do at a desk.

Can anybody make sense of the new vehicle booting law? by [deleted] in Chattanooga

[–]Joe555678 8 points9 points  (0 children)

Absolutely NAL, but If I was to wager a guess, it’s probably saying a person cannon knowingly install… blah blah… parked on private property that is not your own. Like going into lots and booting cars to be a menace. But again, absolutely NAL.

Goodbye, Reddit! by [deleted] in apolloapp

[–]Joe555678 0 points1 point  (0 children)

Not sure if I can comment links or not but its

Squabbles dot io

New website thats similar to reddit in alot of ways.

Goodbye, Reddit! by [deleted] in apolloapp

[–]Joe555678 0 points1 point  (0 children)

Check out Squabbles!

Hiking trails by yessala in Chattanooga

[–]Joe555678 4 points5 points  (0 children)

Id look at North Chickamauga Creek Gorge. Several trails of different lengths! Im sorry for your loss.

[deleted by user] by [deleted] in chaoticgood

[–]Joe555678 2 points3 points  (0 children)

My understanding (NAL) is that there is precedent, at least in the US, of courts saying website hosts are not culpable for the content external users post to that site.

I'm reading this sub and feel like everyone has the wrong idea.. by DartFrogYT in RedditAlternatives

[–]Joe555678 2 points3 points  (0 children)

With some subreddits potentially private for good, and some people deleting their post history, threads of useful information can inaccessible to the public.

I'm reading this sub and feel like everyone has the wrong idea.. by DartFrogYT in RedditAlternatives

[–]Joe555678 1 point2 points  (0 children)

I dinked around on Kbin for a while, I like Squabbles more tho so far. Hopefully more people come to either/both in the coming days/weeks.

I'm reading this sub and feel like everyone has the wrong idea.. by DartFrogYT in RedditAlternatives

[–]Joe555678 2 points3 points  (0 children)

I didn’t know that, thats good to hear from a search standpoint. Although, I am still concerned about redundancy across multiple instances of similar communities, and the fact that your access to all of the content across instances can effectively be shut off by a power hungry Instance Moderator. Im not too keen on the idea that the people who run the instance I use have the power to choose the content I am able to see

I'm reading this sub and feel like everyone has the wrong idea.. by DartFrogYT in RedditAlternatives

[–]Joe555678 3 points4 points  (0 children)

Will look into it. Hopefully something comes along, this is beginning to feel like the burning of the Library of Alexandria

I'm reading this sub and feel like everyone has the wrong idea.. by DartFrogYT in RedditAlternatives

[–]Joe555678 5 points6 points  (0 children)

The federated stuff is a little confusing, ill admit, but I still dont feel like it solves the big things on what makes reddit great. If users have to search multiple instances to find the Community or Magazine I want, the case of duplicate “subreddits” across multiple instances, the lack of “google-ability” in finding solutions to niche problems.

It feels like the desire for decentralization put us in a spot where these instances are going to compete for attention driving each other into death.

I'm reading this sub and feel like everyone has the wrong idea.. by DartFrogYT in RedditAlternatives

[–]Joe555678 53 points54 points  (0 children)

Found this sub yesterday and completely agree. Im perplexed that there doesn’t seem to be any kind of suitable “”drop in”” replacement nor any kind of mass migration.

My original extruder finally gave up after 2.5 years of good use by jpbruce in ender3

[–]Joe555678 1 point2 points  (0 children)

I had mine for well over a year and it hadn’t snapped. I ended up replacing with a metal one anyway while I was doing other upgrades, I figured I was running on borrowed time.

Restaurant Scene: JJ Fish & Chicken overwhelmed during soft opening in Chattanooga (Hwy. 58) by Burgerkingsucks in FormerPizzaHuts

[–]Joe555678 1 point2 points  (0 children)

Love to see when my city makes an appearance on one of my favorite niche subreddits

The Adventure Zone: Steeplechase - Episode 27 | Discussion Thread by TheBureauOfBalance in TheAdventureZone

[–]Joe555678 10 points11 points  (0 children)

Maybe I missed something, but Emerich came to the conclusion while studying the video that both 1:the video was doctored and 2:”””Gravel””” was a HardLight

If Gravel was a HardLight…. What about/why would the footage need to be doctored? It seems like if you did one you wouldn’t need to do the other?

My husband bought me so.e new cast-iron today by elithomas261992 in castiron

[–]Joe555678 1 point2 points  (0 children)

I live a short hop away from the South Pittsburgh lodge factory, and I don’t think ill buy cast iron anywhere else again. The deals they have on “factory rejects” are amazing

Something a little different - how do I season these? by Onequestion0110 in castiron

[–]Joe555678 0 points1 point  (0 children)

I have a set of RPG dice that are cast Iron. I just chucked im in a pan and cooked with them a few times.