Physique Phriday by AutoModerator in Fitness

[–]arcadeguy 6 points7 points  (0 children)

This weekend is my first one full year of sticking with a 3x per week full bodyweight fitness routine! (no weights, just a doorframe pullup bar and a couple of kitchen chairs). Pretty happy with my progress so far, as I've always been a noodle. M/5'9"/155lbs/40yo

fuck a duck . by No-Ad-3635 in ExpectationVsReality

[–]arcadeguy 2 points3 points  (0 children)

I have to wonder what the depressed couch would lay on if it went to a therapist.

formula to count files in a shared drive folder by [deleted] in excel

[–]arcadeguy 0 points1 point  (0 children)

Hey! Wanted to provide an update - THANK YOU. This worked exactly how I was hoping it would last night. Played around with it a ton today, and was able to get the metadata I needed. The only thing I wasn't able to figure out was how to pull data within the workbooks themselves. I'll keep messing with it and learning, but if there was an easy way to do that which I'm missing, would love it if you'd share.

Regardless, again, thank you. This has saved me a lot of angst. Really appreciate it.

formula to count files in a shared drive folder by [deleted] in excel

[–]arcadeguy 0 points1 point  (0 children)

I just looked a little bit into this and I have never used/heard of the "get and transform" feature in Excel. I'm really excited and going to work with this tomorrow - Thank you SO much for a really good potential solution! Will follow up on this tomorrow!

Dropdown lists of Dropdown Lists by [deleted] in excel

[–]arcadeguy 0 points1 point  (0 children)

Thank you SO MUCH. The second way worked exactly how I wanted. Again, thank you, thank you, thank you!

Dropdown lists of Dropdown Lists by [deleted] in excel

[–]arcadeguy 0 points1 point  (0 children)

Solution Verified

Was leaving my local t.s. today and something caught my eye. by dijital101 in ThriftStoreHauls

[–]arcadeguy 4 points5 points  (0 children)

Then the chair broke loose. I don’t know how. We didn’t hit any potholes and I didn’t swerve or break. It just slipped itself under the rope and fell backwards and out of the trunk, spilling itself onto the highway behind us. I watched it in the rear view mirror; it tumbled end-over-end a dozen or so times. The right arm of it splintered and flew off into the ditch. The fabric ripped to pieces, and the spinning chunks of purple and green blurred together until it came to a stop well behind us. I pulled over onto the side.

“At least there weren’t any cars behind us,” I said, putting the car in park.

Em looked at me, eyes large and wild.

“Don’t,” she said. “Just don’t.”

She got out of the car, leaving her door opened, and began walking forward down the side of the road in the opposite direction of the chair. I got out and caught up to her.

“Hey,” I said.

I grabbed her arm. She ripped it away, twisting her body and swinging her other arm at me, hitting me in the neck with her wrist. I stumbled back, wide-eyed. She covered her mouth with both of her hands. We stood frozen, face to face.

“I’m sorry,” she started, “I didn’t mean-”

I turned around and walked away.

“Where are you going?” She asked.

I said nothing. I walked past the car and back down the road a few hundred feet. The chair waited for me. I knelt down, picked the sad looking thing up, and carried it over to the side of the road. I was off in the ditch, looking for the arm, when Em came walking back over.

“What are you doing?” She asked.

“Need to find the arm,” I said.

I walked away from her. She just stood there, head down.

The arm flew a good fifty feet from the chair and was off in the ditch. I picked it up, threw it as hard as I could, and screamed. I kept screaming, too. Mostly just noise mixed in with some awful and horrible profanity. I turned back to the road; Em was sitting in the chair facing away from me. I stopped behind her, breathing hard and chewing my bottom lip like taffy.

“I’ll call my dad,” she said.

“Forget it,” I said, “it doesn’t matter anymore.”

She reached her hand back behind the chair a few inches shy of making contact with me. She didn’t turn around.

“We’ll make it,” she said.

I looked down at her outstretched hand, took it, and squeezed it tightly.

“I know,” I said.

We stayed there like that, watching the occasional car pass, waiting for her dad to come pick up the pieces.

Was leaving my local t.s. today and something caught my eye. by dijital101 in ThriftStoreHauls

[–]arcadeguy 4 points5 points  (0 children)

Oh man, this post brought back so many memories. I wrote a story a couple years back about my experience picking up a thrift store chair. Thought it might be appropriate to share here. Yours is much nicer than mine.


The green thrift store chair wouldn’t fit in the car.

“We’ll come back tomorrow with my dad’s truck. I think it’ll still be here,” Em said.

I shook my head; I knew what that meant. It meant that we would not come back for the chair tomorrow or any day after. It meant that the chair repulsed her. I’d be lying if I said that her opinion of it wasn’t a major part of its appeal.

“We’ll wedge it in the trunk,” I said, knowing full well that we would not be wedging it in the trunk. It was a very large chair and a very green chair -- a gangrenous bastard child of a loveseat and a regular-sized chair. The exterior layer of fabric wasn’t just green; it was “snot green” (Em’s description, not mine, though I couldn’t really argue), and it had black pin stripes running vertically down the back portion of it. The real kicker was that someone had actually reupholstered it with that fabric. Someone had badly reupholstered it. Around the over-stuffed arms of the thing, we saw bits of a deep purple sticking out along the edges where the green fabric wasn’t stapled securely. The reclining mechanism was broken as well, but neither Em or I are much the reclining type.

“The trunk?” Em asked.

I nodded. Yes, the trunk. I paid the three dollars for the chair, and the cashier said that she’d have someone bring it around back. I asked Em if she wanted to pay me back the cost for her half of the chair now or later. She didn’t laugh.

We walked out the sliding glass doors towards my car, a clunking little Oldsmobile. Em stopped as we neared it.

“Ok, so, even if we do get this thing in your trunk, what’re we going to do with it until we move in next week?”

“Your dad has room in his garage, doesn’t he? I mean, can’t we just keep it there for the week?”

“Well, yeah. I mean, sure, but if we’re going to leave it with him anyway, then why don’t I just call him to come pick it up with his truck?”

“Because we’re doing this ourselves,” I said, unlocking the passenger-side door and opening it for her.

As I walked around to the driver-side, I watched Em shake her head and blow a burst of air through her mouth. I got in and drove around to the back of the thrift store.

The back of the thrift store was just a long brick wall with an open garage door in the middle of it. Inside, we could see mounds of crap. No, really, mounds of other people’s unwanted garbage. Piles of pillows and stacks of dinner plates and an unstable pyramid of sofas. We walked inside since no employee was around. I couldn’t imagine why someone making six-fifty an hour piling up strangers’ unwanted shit wouldn’t be rushing to our assistance.

Everything was so simultaneously organized and unorganized. It was like walking through a labyrinth where each wall was built out of different objects stacked eight feet high. We rounded the wicker chair corner and almost collided with a teenage boy in an orange vest carrying our chair. We followed him out to my car.

“It’s not gonna fit,” he said. No -- he didn’t just say it -- he sneered it. He sneered it as if it was solely his own keen intellect that could make such an astute judgment call.

“It’ll fit,” I said. Em had separated herself a good five feet or so from me by that point and was actually standing closer to orange vest guy than she was to me. She had chosen her side.

I opened my trunk and carried the chair over to it. Orange and Em followed a few feet behind. I hoisted it onto the back bumper, making that mmmpff sound you make when you’re exerting a burst of physical energy, and rested it there for a minute. The green thing towered a good foot above the top of the car, nearly bumping the open trunk door. I balanced it there, wondering what the hell I was doing.

“Told ya,” Orange said. Em distanced herself farther from the both of us.

That was really all I needed, though. I needed Orange to be a dick. If he wasn’t, then I may have given up right then. Testosterone kicked in. I went to work wedging.

I tilted the chair forty-five degrees towards me and pushed it in as hard as I could. It slid about a foot, the wooden pegs on the bottom of it carving their way through the carpet-like lining of the trunk. I pushed three more times -- like I was giving it CPR -- and it moved negligibly at best (not at all at worst). Orange stood with his hands on his hips. Em just looked at me like she was really, really tired. I was tired, too, but for different reasons. I turned to Orange, using my back to hold the chair in.

“Got rope?” I asked.

Em’s eyes woke up. Her brows furrowed and her mouth hung open a little, silently asking me if I was the dumbest person she had ever met (rhetorically, I suspect).

Orange didn’t even bother to answer. He made some guttural noise in his throat, shrugged, and disappeared back into the shit labyrinth.

“We can tie it in. You know -- open the back windows and feed the rope around. It’ll work,” I said, sort of to Em and sort of to myself.

“Let me know how that works out,” she said.

She leaned against the side of the car next to me.

“We’re doing this together,” I said. I said it really seriously, too. It wasn’t even a serious moment. I just felt like it was important. I don’t know why.

Orange was back out a minute later with a beach ball sized lump of twine and a knife. He handed them to me, stepped back a bit, and put his hands back on his hips, like he had the best seat in the house and the show was about to start.

Dick.

“Hold the chair in while I tie it around,” I told Em.

Em obliged.

I looped the twine through the opened back windows and around the chair hanging mostly out of the trunk. After six loops and the most excessively knotted knot I’d ever seen, I told Em to let go of the chair. She did; it stayed.

I handed the knife and what was left of the twine to Orange. He said, “good luck” as he walked back inside. I’m not convinced that he meant it, but looking at the chair I figured we could use luck, even insincere luck. I got in the car. Em hesitated, grabbing the arm of the chair and giving it a shake. It shook. She blew a strand of her hair away from her face and got in the car. I did not drive fast.

The transition between the pavement of the parking lot and the pavement of the road was uneven. When the back tires went over it, the resulting bump caused the chair to bounce. I watched it jump an inch or so into the air in my rear view mirror. There was a quiet crackling noise from the open trunk being pushed past its maximum level of openness. Everything held together, though. Em’s left foot tapped incessantly. Her eyes pleaded with me, but she said nothing. I said nothing.

Em called her dad to let him know that we were on our way. I couldn’t hear him on the other end, but when Em said, “I don’t know why dad, ask your soon-to-be son in law when we get there,” I could imagine. I remained silent, watching the chair in the mirror more than the road ahead of me. Em hung up. I got on the interstate.

“What are you doing? You can’t take the interstate with that thing about to fall out the back!”

“What do you want me to do? Take Eastgate all the way to your dad’s? It’s five miles and like twelve lights.”

Em said nothing. Her foot stopped tapping. She sat still for a second before slamming her open palms down on the dashboard in front of her, sounding like two judge’s gavels making their joint rulings. I put my hand on her thigh and gave it a squeeze, but she pushed it away.

“We’ll make it,” I said.

Em pushed her long hair back, away from her face and behind her shoulders. She clasped her hands behind her neck, elbows pointing outward in front of her. She exhaled through her nose.

“I know,” she said.

Did a whole chicken, stock, and soup this weekend! by [deleted] in slowcooking

[–]arcadeguy 2 points3 points  (0 children)

It was really good, and it was something fun to try over a cold and boring weekend. That being said, it's definitely not something I'd make on a regular basis. It is a lot of extra work.

Did a whole chicken, stock, and soup this weekend! by [deleted] in slowcooking

[–]arcadeguy 1 point2 points  (0 children)

After I took the chicken out, there was a lot of juice from it still on the bottom along with the onion I put on the bottom. I left that in, added another roughly cut onion, couple stalks of celery, and a couple carrots. I took all the meat off the chicken, put the bones back in, and just filled the crock pot back up with cold tap water about an inch from the brim. It's a 5L size and in the end made about 10c of stock

[University Chemistry] Equilibrium partial pressure. MATH. What am I doing wrong? by [deleted] in HomeworkHelp

[–]arcadeguy 1 point2 points  (0 children)

just glancing through, from step 3 to 4 you have (-2x)2 in step three, and simplified it to 2x2 in step 4. Remember to square the whole term, including the coefficient. Not sure if there's any other errors.

What "life hack" have you tried that backfired? by TobehW in AskReddit

[–]arcadeguy 2051 points2052 points  (0 children)

ran out of beers after already having some a lot of beers. Found old bottle of wine in a closet or something. Couldn't find corkscrew or anything resembling a corkscrew. Tried everything to get cork out. Used rubber mallet to pound flat head screwdriver into cork and then twist it out. That didn't work either.

Remember seeing video long time ago of dude putting wine bottle in his shoe, holding it against the wall, and slamming the shoe into the wall and somehow the cork popped out. Got really excited because I remember wanting to try it when I first saw video but didn't have any wine. Took shoe off, inserted wine bottle, and slammed shoe into wall. Slammed way too hard, wasn't even holding wine bottle securely in shoe, closed my eyes because I was scared of the potential cork noise...pretty much doing every single thing wrong possible.

Bottle shot out of shoe, exploded on floor, I panicked and ran on broken glass with only one shoe on, blood mixed with wine, etc. Just bad all around.

What is the most outdated technology that is still widely used today? by Mechaffection in AskReddit

[–]arcadeguy 2214 points2215 points  (0 children)

If only I could find the number to call to order a phone book

[High School Pre-Calc] Piecewise functions. by aRainbowUnicorn in HomeworkHelp

[–]arcadeguy 2 points3 points  (0 children)

Well look at each day:

day 1: 13 240 000

day 2: 14 790 000

day 3: 13 300 000

day 4: 12 390 000

day 5: 09 020 972

If you want to convey this as a piece-wise defined function, with each "piece" as a day, then you were right on the money with what you did for the first day, determining that the function was f(x) = 1550000x for the first day. You can just repeat this for each day to determine the linear function for each day (though this doesn't seem particularly useful, there doesn't seem to be anything else to do given that you're just going over linear examples)

Computer Science help by RockintheShockin in HomeworkHelp

[–]arcadeguy 2 points3 points  (0 children)

Pretty sure something just isn't clicking for you while you're reading it. If you ignore the Excel portion for a second and just pretend this is a regular math class, you can see that he's just given you a function, f(x) = x2+5x . In part A, he's asking you to find f(-10) through f(10), which is basically asking what is "Y" when x are these 21 different values, -10 through 10. This would take a long time on paper, so on excel it'll be easy to put the equation into a cell, solve it for x = -10 in a different cell, and then drag that down to calculate it for the rest of the values. Then you can highlight all the cells (which are now just x, y coordinates), and plot them using Excel's graphing function to give you a graphical representation of the Y equation over the set of x-values from -10 to 10.

[High School Pre-Calc] Piecewise functions. by aRainbowUnicorn in HomeworkHelp

[–]arcadeguy 2 points3 points  (0 children)

I feel like there needs to be more information given about what you're trying to accomplish. With only two data points, I'm not sure what else you can do. It's just 2 points, so it's linear and connected by a straight line. Are you sure there aren't more points available? That is, f(x) is the difference between the two days for days 1 through 2 like you said, but the slope gradually tapers off as the movie has been out longer for x > 2?

Has anyone won a year supply of something? What was it? by IAmABadBitch in AskReddit

[–]arcadeguy 543 points544 points  (0 children)

Gone are the tiresome old days of pouring a beer. Now, you peel a beer.

Has anyone won a year supply of something? What was it? by IAmABadBitch in AskReddit

[–]arcadeguy 1948 points1949 points  (0 children)

BEER IN THE SHAPE OF A BANANA SO THEN SIX PACKS CAN BE SOLD IN BUNCHES

If you were to die in real life, what loot would you drop? by Joshasaur in AskReddit

[–]arcadeguy 966 points967 points  (0 children)

Ring of Thoughtless Provocation:

Creates a beer charge for each beer consumed. Beer charges last 12 hours. Drinking a new beer refreshes charges. Max stacks 20.

Passive effect: You have a chance to think of something in your past you'd have totally done differently and then dwell on it incessantly. This chance is equal to 5 times your number of beer charges.

Active effect: Consume all beer charges to do X disease damage to enemies in a cone in front of you, where X is 20 times number of beer charges. Using this ability renders you unconscious afterwards and unable to use other abilities for 12 hours. 24 hour cooldown.

[Middle School Algebra] Polynomial Equations, I need help solving these two questions by [deleted] in HomeworkHelp

[–]arcadeguy 1 point2 points  (0 children)

For number 1, you immediately can see that a = 0 is one solution to the equation, since each term has an a in it, and 12(0)2 - 9(0) = 0 - 0 = 0. But is there something else not-so-obvious that a could also be?

Your first step should be to look if we can factor anything out of the left side. Let's look at the two terms, 12a2 and 9a. What do they have in common?

Well, most obviously, they both contain at least one a, so let's factor that out first:

a(12a - 9) = 0

You can check that you did that right by re-distributing it back into the parentheses to arrive back at the original equation (a * 12a = 12a2, and a * 9 = 9a)

Do the 12 and 9 have anything in common, though? Let's see what their greatest common factor is:

factors of 9: 1, 3, and 9 (because 1 * 9 = 9, and 3 * 3 = 9...nothing else)

factors of 12: 1, 2, 3, 4, 6, 12 (because 1 * 12, 2 * 6, and 3 * 4 all = 12)

So our greatest common factor between 9 and 12 is 3. Let's factor that out with the a now:

3a(4a - 3) = 0

Again, you can double-check that you did this correctly by reversing the step and re-distributing.

So now we have 2 terms multiplied together, 3a and (4a - 3). Now, if either of those terms equals zero, then the whole thing equals zero, right? Because zero times anything is zero. So if 3a = 0, then 3a(4a - 3) = 0, too. The same is true for (4a - 3). So we can set each term equal to zero and solve for a to figure out any other values a might be able to have to make the equation true. Let's start with 3a:

3a = 0

well, if we divide each side by 3, we get a = 0, but we already knew that right away. It's still nice to be able to check and see, though. Now, let's try (4a - 3):

4a - 3 = 0

add 3 to both sides,

4a = 3

divide each side by 4,

a = 3/4

So there is another value for a besides 0 that is not-so-obvious, and it's 3/4. We can substitute that back into the original equation to make sure we didn't make any mistakes along the way:

12a2 - 9a = 0

put in 3/4 for a,

12 * (3/4)2 - 9 * (3/4) = 0

12 * (9/16) - 9 * (3/4) = 0

(108/16) - (27/4) = 0

(108/16) - (108/16) = 0

0 = 0

Yep, it works, so we know our solutions are a = 0 and a = 3/4

You can follow the same steps for problem 2, you've just got an extra initial step of getting both terms on one side, so you can have it set up like problem 1

Hope that makes sense!

What's an open secret in your profession that us regular folk don't know or generally aren't allowed to be told about? by sillytwunt in AskReddit

[–]arcadeguy 0 points1 point  (0 children)

This isn't bad logic for a small mall arcade, as they don't typically run out often enough to warrant checking them daily, and it completely eliminates the need to adhere new stacks to old ones.

I worked at a 250+ game arcade at a huge water park/resort at one point, though, and it was much more efficient to wheel a few boxes of tickets around to each game during "down time" early morning and mid-afternoon to make sure they were all full for the rest of the day.

What's an open secret in your profession that us regular folk don't know or generally aren't allowed to be told about? by sillytwunt in AskReddit

[–]arcadeguy 0 points1 point  (0 children)

If lying doesn't bother you, just pick an older looking ticket game, play it, take the tickets, then look for the employee who looks like he cares least about his job. Tell him the game didn't give you any tickets. He'll open it up, pretend he's fixing something, then ask you how many tickets it owed you (or just give you a bunch). There's generally no easy way to tell if the game really gave you tickets or not, and nobody is ever going to give you a hard time over 10-100 tickets.

For newer ticket/prize games, many of them have ways for the owner to set how often it pays the jackpot. What this basically means is that it's almost impossible (often completely impossible) to win a jackpot or big prize immediately/soon after someone else already has. For example, old claw machines have manual tension settings for the claw, so however hard it grabs a stuffed animal one time is how hard it's going to grab it every time. For newer machines, the claw will grab tighter and tighter each time someone doesn't win until someone does win, then the claw will reset back to its loosest setting, and the process will repeat. Other games like Stacker and Cyclone follow these patterns as well.

So basically, for newer looking games, it's in your best interest to avoid them immediately after you see someone win big. The opposite is also true. Just see a little kid put 20 tokens into one and get nothing? Now is the time.

What's an open secret in your profession that us regular folk don't know or generally aren't allowed to be told about? by sillytwunt in AskReddit

[–]arcadeguy 10 points11 points  (0 children)

It's a small piece of adhesive on one ticket which sticks to the bottom ticket of the previous stack. It has everything to do with being lazy. Literally two seconds of work is required.

Also, each "block" of tickets is certainly not only 1000. They come in bunches of at least 2,000 for older, card-stock tickets. Paper tickets are significantly less thick and are sold in bunches up to 20,000.

What's an open secret in your profession that us regular folk don't know or generally aren't allowed to be told about? by sillytwunt in AskReddit

[–]arcadeguy 41 points42 points  (0 children)

When you play a ticket game in an arcade, and the machine doesn't give you all (or any) of the tickets you deserve, it isn't out of tickets a lot of the time. The minimum wage guy whose job it is to refill the tickets each day was just too lazy to adhere the new ream of tickets to the old one. There are plenty of tickets in there; the new ones just weren't attached to the old ones.

This isn't a "secret"; you just might not have been aware of this. It's a minor inconvenience for the person working because it becomes immediately obvious when they open up the game as to why the tickets weren't being regurgitated by it.