I'm trying (yet again) to stop biting my nails. I've done it since 5th grade or so, and I'm now 40. As I'm starting to travel for work and get pulled into meetings with more important people, I'd like to look like a well groomed adult, not a twitchy nervous mess with his hands in his mouth all the time.
I think the longest I've gone has been about a month or two tops. I bought a fidget spinner like the cool kids have, hoping that might help give my hands something to do at work instead of wind up in my mouth.
Yesterday (Day One) was easy, I worked from home. Today is day two - I forgot to bring in the spinner and our internet is nearly nonexistent for some reason. It's like a cruel, cruel test.
I chew on coffee stirers because I have an insatiable oral fixation, it's why i was a chain smoker for years. Relatedly i also have terrible TMJ, but i figure that's better than lung cancer so i shall continue to chew.
Sleep on
0
Options
CambiataCommander ShepardThe likes of which even GAWD has never seenRegistered Userregular
I switched from biting my nails to just clipping them real short whenever they got long enough to bite. Works for me? Some people at work get annoyed at the clipping sound, though.
"If you divide the whole world into just enemies and friends, you'll end up destroying everything" --Nausicaa of the Valley of Wind
I have a stressball at my office that I faff about with instead of biting my nails. Its a jolly coloured globe and a good distraction.
Everyone wants to play with it, and they may
except you one colleague, because you are the source of my stress.
You're sure your coworkers wash their hands?
+1
Options
David_TA fashion yes-man is no good to me.Copenhagen, DenmarkRegistered Userregular
I have a stress ball at work that's flesh colored and has a nipple glued on.
I did not purchase this, it was bequeathed to me by my former boss who brought six of them back from Spain once and loved telling the story of how she was allowed to keep them as carry-on luggage after the airport steward spent five minutes playing with them and then told her colleague "No no, these are fine".
When I had stressful days, my boss would ask "Want a tit?" and then throw one at me.
I'm trying (yet again) to stop biting my nails. I've done it since 5th grade or so, and I'm now 40. As I'm starting to travel for work and get pulled into meetings with more important people, I'd like to look like a well groomed adult, not a twitchy nervous mess with his hands in his mouth all the time.
I think the longest I've gone has been about a month or two tops. I bought a fidget spinner like the cool kids have, hoping that might help give my hands something to do at work instead of wind up in my mouth.
Yesterday (Day One) was easy, I worked from home. Today is day two - I forgot to bring in the spinner and our internet is nearly nonexistent for some reason. It's like a cruel, cruel test.
I chew on coffee stirers because I have an insatiable oral fixation, it's why i was a chain smoker for years. Relatedly i also have terrible TMJ, but i figure that's better than lung cancer so i shall continue to chew.
oh jeez is that what I've got? Occasionally it'll feel like my jaw is just out of place, like the part where the upper and lower jaw meet slid past each other, and it'll click a bunch until it finally rights itself a few minutes later.
Relatedly, since starting my job I've noticed (and started trying to consciously avoid) that I clench my teeth, especially when I'm tired or driving, which certainly isn't helping that.
so, it becomes like flossing. Don't want the dentist to give you a lecture.
This doesn't seem to stop me.
In work-related news it's kind of slow here so I'm hacking together an Excel sheet with some formulas I haven't used before. I won't lie, it's basically intended for a video game to keep track of what materials I'll need to make something and how many, with some true/false checkboxes to count/not count certain cells. Of course, because of how CountIfs work I can't just grab the whole range. There might be a simple way to do it but the only way I can make this abomination work is by stitching together a CountIfs for each row like:
This counts the number of times "Gold Keeper" appears in each column, does not count rows where TRUE appears in a cell at the end of each row, and sums the total in another cell. Still a work in progress but I'm learning more and googling for help when I get stuck on something, so it's engaging.
Wait. What is this arbitration agreement for? A new contract? Are they buying you out instead of laying you off? Are you in some dispute with the company?
Anything that says no collective bargaining gets a huge no from me. And you can't talk bad about them after you leave? Sounds a bit suspicious.
Nope this just showed up outta nowhere for everyone to sign. I got a hold of everyone I could to say hey I don't fully understand this but you don't HAVE to sign. We have thirty days from receiving the agreement to call a number to opt out.
I'm inclined to do so since the reasons I could see to need to take legal action involve being ordered to do something that results in CBP violations and other federal shenanigans.
call that fucking number right now and opt out, and tell anyone you care about at work to do the same
they are doing this explicitly to fuck you over
there is literally no explanation for this behavior other than, "we plan to, or are worried that one of our managers will, break the law. When that happens, we want to ensure that you don't go blabbing to any courts about it."
Your arbitration agreement almost certainly sets the venue for the arbitration across the country, (to make it harder for you to go to the hearing) in a jurisdiction friendly to corporate malfeasance, (Delaware usually) and prevents you from accessing all your normal remedies should they (probably inevitably) fuck you over.
Ask yourself if this is the sort of contract a ferengi would have you sign.
Are they a good ferengi or a bad one?
Hah "good" Ferengi
Yeah I called up the outer posts about it and talked with some of the walking posts. One of them was totally surprised you could opt out. Another one just took it from the supervisor and started signing. I told her to stop signing that and asked her to explain it to me. She shrugged.
Doesn't help the boss, when handing them out said, "You must read and sign this." Then when one of them called him to ask about it.
"Oh yeah, that's totally normal. All companies do that. I signed it. Just go ahead and sign it."
The fact that you signed it is a good reason not to. You are a bumbling fool who has largely turned Base into a babysitter.
Yeah, my parents tried to put some bad-tasting nail stuff on my fingernails. Just led to me biting and spitting.
My mom bought me the one with cayenne pepper in it and put it in my stocking. I took offense and put it all over the ends of her Virginia Slim Menthols and on the rim of her Caffeine Free Diet Pepsi cans.
+12
Options
Donovan PuppyfuckerA dagger in the dark isworth a thousand swords in the morningRegistered Userregular
Shadow didn't know how to send photos to other people. Not "didn't know how to attach photos to an email" but literally did not realize she can utilize email for that very task.
In the meanwhile I'm wrestling with this formula because I'm fully caught up on my work and my boss knows it and I do not envy her at all.
Well I haven't even gotten a call for an interview from the 45k a year data entry job, but I did get offered a sort of promotion at work. Its in the fraud department on overnights (9p-7a) work 4 off 3 with alternating weekends. I was told there will be a raise involved but they can't/won't tell me how much yet because it has to get approved. Hopefully its enough I can quit my second job.
I'm still out of there if the data entry place calls. Also I finally got all my grad school stuff in, cost me $75 to apply and get all the transcripts but hopefully its worth it.
Finished up a fourth round interview with the first company that I think went well. I answered a hypothetical question in such a way as to possibly improve their real product.
Also heard back from another, more preferable company, also in Vancouver. They're in North Van so I'd need to figure out living there, but heck, I'm in. Sounds like a better culture, less restrictive noncompete, and an industry I'm more interested in.
+8
Options
WeaverWho are you?What do you want?Registered Userregular
Had a red bull when I came in, then my cohort bought me a cold brew so I'm running around everywhere being super productive.
StragintDo Not GiftAlways DeclinesRegistered Userregular
Are there jobs that don't require a degree where I don't have to deal with customers?
PSN: Reaper_Stragint, Steam: DoublePitstoChesty
What is the point of being alive if you don't at least try to do something remarkable? ~ Mario Novak
I never fear death or dyin', I only fear never trying.
0
Options
JedocIn the scupperswith the staggers and jagsRegistered Userregular
Retail night stocking is always a sector needing labor. If you're handy with a socket wrench and willing to relocate to a rural area, you can make surprisingly good money monitoring and servicing central irrigation systems. No farmer with money to spare wants to hump gear boxes into corn fields on foot if they can pay someone else to do it. Mining is always a possibility, now that Donald Trump has single-handedly saved coal. If you like audiobooks, truck driving is a pretty good option, although you're going to want to cash in and get out before self-driving trucks take over. If you're an energetic hustler, you can make pretty good cash in freelance writing, although the market tends to ebb and flow based on the latest Google algorithm.
Are there jobs that don't require a degree where I don't have to deal with customers?
If you mean non-retail, yes.
If you mean never having to deal with clientele . . . yes. But even not dealing with customers, you're always going to have stupid shitty people shitting in your life and making ever moment a living hell.
These jobs can still suck a lot. Quite a lot. Or they can be okay, it really depends. I usedto do landscaping construction and it wasnt so bad. Didnt pay all that much though
0
Options
StragintDo Not GiftAlways DeclinesRegistered Userregular
I am definitely open to ideas.
I work at a credit card company in their collections department on the outbound calling team. I like working for the company and I like the people I work with. Lots if benefits and I moved up pretty fast.
The card members though. They can be so frustrating and unreasonable. So entitled. I hate dealing with them and today was especially awful.
I want to find a new job but I just don't really know where to start.
PSN: Reaper_Stragint, Steam: DoublePitstoChesty
What is the point of being alive if you don't at least try to do something remarkable? ~ Mario Novak
I never fear death or dyin', I only fear never trying.
0
Options
MrMonroepassed outon the floor nowRegistered Userregular
so, it becomes like flossing. Don't want the dentist to give you a lecture.
This doesn't seem to stop me.
In work-related news it's kind of slow here so I'm hacking together an Excel sheet with some formulas I haven't used before. I won't lie, it's basically intended for a video game to keep track of what materials I'll need to make something and how many, with some true/false checkboxes to count/not count certain cells. Of course, because of how CountIfs work I can't just grab the whole range. There might be a simple way to do it but the only way I can make this abomination work is by stitching together a CountIfs for each row like:
This counts the number of times "Gold Keeper" appears in each column, does not count rows where TRUE appears in a cell at the end of each row, and sums the total in another cell. Still a work in progress but I'm learning more and googling for help when I get stuck on something, so it's engaging.
That's basically the accepted use of countifs. The way you might get cleaner code is by rearranging how you're holding the original data. It sounds like you have a group of recipes with a list of ingredients... if you want an order form and a grocery list, you could build an array out of the recipes and use =sumproduct:
the code for the Gold Keeper grocery list count is
I work at a credit card company in their collections department on the outbound calling team. I like working for the company and I like the people I work with. Lots if benefits and I moved up pretty fast.
The card members though. They can be so frustrating and unreasonable. So entitled. I hate dealing with them and today was especially awful.
I want to find a new job but I just don't really know where to start.
If your interested in manufacturing support (Purchasing/inventory control/scheduling etc...) Looks into the APICS classes. probably about $2000/$3000 to get certified (If you are a quick learner and don't need to take the classes it is MUCH cheaper, just study the books). any place worth its salt will look highly on that cert. CPIM is another good one to get.
Pay is decent, and if you can learn about MRP/ERP systems at the same time and maybe how to do crystal reports you will become a god at most places.
I had hoped that the place I applied to recently would have given me some kind of notification that they went with someone else, but I guess that was too much effort. Spirit of aloha my ass.
so, it becomes like flossing. Don't want the dentist to give you a lecture.
This doesn't seem to stop me.
In work-related news it's kind of slow here so I'm hacking together an Excel sheet with some formulas I haven't used before. I won't lie, it's basically intended for a video game to keep track of what materials I'll need to make something and how many, with some true/false checkboxes to count/not count certain cells. Of course, because of how CountIfs work I can't just grab the whole range. There might be a simple way to do it but the only way I can make this abomination work is by stitching together a CountIfs for each row like:
This counts the number of times "Gold Keeper" appears in each column, does not count rows where TRUE appears in a cell at the end of each row, and sums the total in another cell. Still a work in progress but I'm learning more and googling for help when I get stuck on something, so it's engaging.
That's basically the accepted use of countifs. The way you might get cleaner code is by rearranging how you're holding the original data. It sounds like you have a group of recipes with a list of ingredients... if you want an order form and a grocery list, you could build an array out of the recipes and use =sumproduct:
the code for the Gold Keeper grocery list count is
=SUMPRODUCT(B2:B4,B9:B11)
I was considering that but both the list of recipes and the materials are far too massive. I basically have seven columns in the table itself and two for the materials+formula. One for the name of the thing I intend to craft, five slots to put whatever materials are needed to craft it, then the checkbox I click on when I've made the indicated item. Off to the side I have the long-ass list of materials and next to each one is the formula that sums up how often it appears in the array. When I click the checkbox, meaning the recipe was made, the formula stops counting the items in that row.
I don't have the file on this computer but it looks a bit like this. Only with more recipes and a complete list of the many many materials. This also lets me determine when each recipe is done so I'm not just gathering a bunch of materials and then not remembering what I was going to do with them.
Eventual goal is to get all the material lists into their own sheet and then make a "clean" list, because I'm doing one tab per element.
I have a bad habit of cutting my nails with scissors or wire cutters
But I cut them real short
Ugh in the last week we have lost 5+ people at work so which my manager says do I know of anyone dependable? to which I had to say the only person I know of I tell them they are bat shit crazy to work here
To which she looked horrified and said just tell them you are lying and ask them to come down
I will think about it
0
Options
MrMonroepassed outon the floor nowRegistered Userregular
so, it becomes like flossing. Don't want the dentist to give you a lecture.
This doesn't seem to stop me.
In work-related news it's kind of slow here so I'm hacking together an Excel sheet with some formulas I haven't used before. I won't lie, it's basically intended for a video game to keep track of what materials I'll need to make something and how many, with some true/false checkboxes to count/not count certain cells. Of course, because of how CountIfs work I can't just grab the whole range. There might be a simple way to do it but the only way I can make this abomination work is by stitching together a CountIfs for each row like:
This counts the number of times "Gold Keeper" appears in each column, does not count rows where TRUE appears in a cell at the end of each row, and sums the total in another cell. Still a work in progress but I'm learning more and googling for help when I get stuck on something, so it's engaging.
That's basically the accepted use of countifs. The way you might get cleaner code is by rearranging how you're holding the original data. It sounds like you have a group of recipes with a list of ingredients... if you want an order form and a grocery list, you could build an array out of the recipes and use =sumproduct:
the code for the Gold Keeper grocery list count is
=SUMPRODUCT(B2:B4,B9:B11)
I was considering that but both the list of recipes and the materials are far too massive. I basically have seven columns in the table itself and two for the materials+formula. One for the name of the thing I intend to craft, five slots to put whatever materials are needed to craft it, then the checkbox I click on when I've made the indicated item. Off to the side I have the long-ass list of materials and next to each one is the formula that sums up how often it appears in the array. When I click the checkbox, meaning the recipe was made, the formula stops counting the items in that row.
I don't have the file on this computer but it looks a bit like this. Only with more recipes and a complete list of the many many materials. This also lets me determine when each recipe is done so I'm not just gathering a bunch of materials and then not remembering what I was going to do with them.
Eventual goal is to get all the material lists into their own sheet and then make a "clean" list, because I'm doing one tab per element.
Well, if you're married to columns for Nth ingredient of the recipe rather than columns for the Nth ingredient in the master list, big ol' concatenated countifs are the way to go. It's just not a great data structure. (doesn't handle recipes larger than max(N), handles recipes shorter than max(N) poorly, text is much more storage intensive than numbers, and, as you've found, you have to parse everything with wonky string functions rather than doing math on your columns)
I have a bad habit of cutting my nails with scissors or wire cutters
But I cut them real short
Ugh in the last week we have lost 5+ people at work so which my manager says do I know of anyone dependable? to which I had to say the only person I know of I tell them they are bat shit crazy to work here
To which she looked horrified and said just tell them you are lying and ask them to come down
I will think about it
No one deserves to work in your private Hell, not even you.
Speaking of faxes I remember the cold rage I felt when the following or similar exchange would take place at least once a month with multiple different companies:
Customer: Hi could you please fax this (important thing) to (number) at (company)?
Me: Sure:
Fax machine: ring ring Hello? Hello? Hello? Why does this phone make this strange sound?
Me: *rage builds* *Calls number from regular phone* "Hi that is a fax machine, do not answer the fax machine, it is not for answering."
Person: Oh! OK!
Fax machine: ring ring ring Hello? Hello?
I'm trying (yet again) to stop biting my nails. I've done it since 5th grade or so, and I'm now 40. As I'm starting to travel for work and get pulled into meetings with more important people, I'd like to look like a well groomed adult, not a twitchy nervous mess with his hands in his mouth all the time.
I think the longest I've gone has been about a month or two tops. I bought a fidget spinner like the cool kids have, hoping that might help give my hands something to do at work instead of wind up in my mouth.
Yesterday (Day One) was easy, I worked from home. Today is day two - I forgot to bring in the spinner and our internet is nearly nonexistent for some reason. It's like a cruel, cruel test.
Since we got a new phone contract when someone is on the phone and somebody calls him and he doesn’t pick up the second call within 5 seconds all phones on the floor ring once. It’s really great.
Also somebody please kill six billion organ grinders and topple their hurdy gurdies.
I tore a nail a few weeks ago at work
I just bit down on it and tore the rest off in front of people
They were still talking about it last week when I was making fun of how my coyote used to trim her nails by herself
0
Options
Brovid Hasselsmof[Growling historic on the fury road]Registered Userregular
A person here knows someone who was killed in the Manchester attack. I can't really even imagine processing that.
Posts
I chew on coffee stirers because I have an insatiable oral fixation, it's why i was a chain smoker for years. Relatedly i also have terrible TMJ, but i figure that's better than lung cancer so i shall continue to chew.
Everyone wants to play with it, and they may
except you one colleague, because you are the source of my stress.
Was always ripping them too short and fuck that hurt
You could get manicures. The people that do your nails will get mad if you gnaw at them.
so, it becomes like flossing. Don't want the dentist to give you a lecture.
You're sure your coworkers wash their hands?
I did not purchase this, it was bequeathed to me by my former boss who brought six of them back from Spain once and loved telling the story of how she was allowed to keep them as carry-on luggage after the airport steward spent five minutes playing with them and then told her colleague "No no, these are fine".
When I had stressful days, my boss would ask "Want a tit?" and then throw one at me.
Yes, I follow them into the bathroom and watch intently.
oh jeez is that what I've got? Occasionally it'll feel like my jaw is just out of place, like the part where the upper and lower jaw meet slid past each other, and it'll click a bunch until it finally rights itself a few minutes later.
Relatedly, since starting my job I've noticed (and started trying to consciously avoid) that I clench my teeth, especially when I'm tired or driving, which certainly isn't helping that.
I mean if I did it a little it wouldn't be a big deal
but often times I'll chew those fuckers up, and it's gross
This doesn't seem to stop me.
In work-related news it's kind of slow here so I'm hacking together an Excel sheet with some formulas I haven't used before. I won't lie, it's basically intended for a video game to keep track of what materials I'll need to make something and how many, with some true/false checkboxes to count/not count certain cells. Of course, because of how CountIfs work I can't just grab the whole range. There might be a simple way to do it but the only way I can make this abomination work is by stitching together a CountIfs for each row like:
This counts the number of times "Gold Keeper" appears in each column, does not count rows where TRUE appears in a cell at the end of each row, and sums the total in another cell. Still a work in progress but I'm learning more and googling for help when I get stuck on something, so it's engaging.
Hah "good" Ferengi
Yeah I called up the outer posts about it and talked with some of the walking posts. One of them was totally surprised you could opt out. Another one just took it from the supervisor and started signing. I told her to stop signing that and asked her to explain it to me. She shrugged.
Doesn't help the boss, when handing them out said, "You must read and sign this." Then when one of them called him to ask about it.
"Oh yeah, that's totally normal. All companies do that. I signed it. Just go ahead and sign it."
The fact that you signed it is a good reason not to. You are a bumbling fool who has largely turned Base into a babysitter.
My mom bought me the one with cayenne pepper in it and put it in my stocking. I took offense and put it all over the ends of her Virginia Slim Menthols and on the rim of her Caffeine Free Diet Pepsi cans.
I was a truck mechanic and I still bite my nails. That bitter nail polish you can buy? Fucking worthless.
Interview tomorrow at 9 am.
Steam Me
In the meanwhile I'm wrestling with this formula because I'm fully caught up on my work and my boss knows it and I do not envy her at all.
I'm still out of there if the data entry place calls. Also I finally got all my grad school stuff in, cost me $75 to apply and get all the transcripts but hopefully its worth it.
Also heard back from another, more preferable company, also in Vancouver. They're in North Van so I'd need to figure out living there, but heck, I'm in. Sounds like a better culture, less restrictive noncompete, and an industry I'm more interested in.
What is the point of being alive if you don't at least try to do something remarkable? ~ Mario Novak
I never fear death or dyin', I only fear never trying.
If you mean non-retail, yes.
If you mean never having to deal with clientele . . . yes. But even not dealing with customers, you're always going to have stupid shitty people shitting in your life and making ever moment a living hell.
I had a tough day.
Factory jobs
Manual labour
These jobs can still suck a lot. Quite a lot. Or they can be okay, it really depends. I usedto do landscaping construction and it wasnt so bad. Didnt pay all that much though
I work at a credit card company in their collections department on the outbound calling team. I like working for the company and I like the people I work with. Lots if benefits and I moved up pretty fast.
The card members though. They can be so frustrating and unreasonable. So entitled. I hate dealing with them and today was especially awful.
I want to find a new job but I just don't really know where to start.
What is the point of being alive if you don't at least try to do something remarkable? ~ Mario Novak
I never fear death or dyin', I only fear never trying.
That's basically the accepted use of countifs. The way you might get cleaner code is by rearranging how you're holding the original data. It sounds like you have a group of recipes with a list of ingredients... if you want an order form and a grocery list, you could build an array out of the recipes and use =sumproduct:
the code for the Gold Keeper grocery list count is
If your interested in manufacturing support (Purchasing/inventory control/scheduling etc...) Looks into the APICS classes. probably about $2000/$3000 to get certified (If you are a quick learner and don't need to take the classes it is MUCH cheaper, just study the books). any place worth its salt will look highly on that cert. CPIM is another good one to get.
Pay is decent, and if you can learn about MRP/ERP systems at the same time and maybe how to do crystal reports you will become a god at most places.
Origin ID: Discgolfer27
Untappd ID: Discgolfer1981
I was considering that but both the list of recipes and the materials are far too massive. I basically have seven columns in the table itself and two for the materials+formula. One for the name of the thing I intend to craft, five slots to put whatever materials are needed to craft it, then the checkbox I click on when I've made the indicated item. Off to the side I have the long-ass list of materials and next to each one is the formula that sums up how often it appears in the array. When I click the checkbox, meaning the recipe was made, the formula stops counting the items in that row.
I don't have the file on this computer but it looks a bit like this. Only with more recipes and a complete list of the many many materials. This also lets me determine when each recipe is done so I'm not just gathering a bunch of materials and then not remembering what I was going to do with them.
Eventual goal is to get all the material lists into their own sheet and then make a "clean" list, because I'm doing one tab per element.
But I cut them real short
Ugh in the last week we have lost 5+ people at work so which my manager says do I know of anyone dependable? to which I had to say the only person I know of I tell them they are bat shit crazy to work here
To which she looked horrified and said just tell them you are lying and ask them to come down
I will think about it
Well, if you're married to columns for Nth ingredient of the recipe rather than columns for the Nth ingredient in the master list, big ol' concatenated countifs are the way to go. It's just not a great data structure. (doesn't handle recipes larger than max(N), handles recipes shorter than max(N) poorly, text is much more storage intensive than numbers, and, as you've found, you have to parse everything with wonky string functions rather than doing math on your columns)
No one deserves to work in your private Hell, not even you.
Customer: Hi could you please fax this (important thing) to (number) at (company)?
Me: Sure:
Fax machine: ring ring Hello? Hello? Hello? Why does this phone make this strange sound?
Me: *rage builds* *Calls number from regular phone* "Hi that is a fax machine, do not answer the fax machine, it is not for answering."
Person: Oh! OK!
Fax machine: ring ring ring Hello? Hello?
Damn I still get angry just thinking about it.
STEAM
Put some nail cutters on your key ring.
Also somebody please kill six billion organ grinders and topple their hurdy gurdies.
I just bit down on it and tore the rest off in front of people
They were still talking about it last week when I was making fun of how my coyote used to trim her nails by herself