I get to have my first not fun conversation with an employee who was not happy with their annual raise.
Switch Animal Crossing Friend Code: SW-5107-9276-1030
Island Name: Felinefine
+2
JedocIn the scupperswith the staggers and jagsRegistered Userregular
Just notarized a mail-in ballot for the special election on recreational marijuana. The guy's shirt was covered with Grateful Dead bears, so I think I can pretty confidently add a "Yea" to the poll numbers.
Well, it looks like I'm a shoe-in for the team lead role barring me completely bombing my interview.
But it's fun because I'm only getting it due to the other guy getting fucked on technicalities since he quit and came back! I know, like actually know, both my boss and my boss's boss wanted him in one of the two roles and he would've beaten me out for it in the first go round. So much so, they delayed posting the second job because they know he's not eligible to bid on it now.
So, it's kinda like, cool, once again I am getting something not because I earned it or was the best person for the job, I was just second in line with the minimum check marks when they couldn't get who they really wanted.
Well, it looks like I'm a shoe-in for the team lead role barring me completely bombing my interview.
But it's fun because I'm only getting it due to the other guy getting fucked on technicalities since he quit and came back! I know, like actually know, both my boss and my boss's boss wanted him in one of the two roles and he would've beaten me out for it in the first go round. So much so, they delayed posting the second job because they know he's not eligible to bid on it now.
So, it's kinda like, cool, once again I am getting something not because I earned it or was the best person for the job, I was just second in line with the minimum check marks when they couldn't get who they really wanted.
So there's two roles, they really want this person for one of them, so they're holding posting the second for this person so they can get it later.
In the meantime you're a shoe-in for the one role, which, if this person had been eligible, would have been one of the two roles.
Unless there's some mysterious third person I fail to see how you're not one of the top two candidates so fuck it, get that job, get that paper.
Also this other person quit and came back while you put up with the suck. Does it blow for them that they have to wait for the job? Sure, but they made their choice, that's not your fault or problem. Fuck that.
When I started working after 08 there were a bunch of people who had left for better jobs before the great recession that came back and had to take positions behind me, greeny mc green sauce. Did that suck for them? Absolutely, but ain't shit I could have done about it so :shrug:
If this person is that good they'll get theirs eventually, in the meantime don't feel bad about yours after all the shit you've gone through.
Well, it looks like I'm a shoe-in for the team lead role barring me completely bombing my interview.
But it's fun because I'm only getting it due to the other guy getting fucked on technicalities since he quit and came back! I know, like actually know, both my boss and my boss's boss wanted him in one of the two roles and he would've beaten me out for it in the first go round. So much so, they delayed posting the second job because they know he's not eligible to bid on it now.
So, it's kinda like, cool, once again I am getting something not because I earned it or was the best person for the job, I was just second in line with the minimum check marks when they couldn't get who they really wanted.
If they didn't want you for the role they wouldn't offer it to you. Full stop.
Like Pellaeon said there are two positions available. It sounds like you'd be getting one of the two regardless of what the other person had done.
FFXIV: Agran Trask
+11
lonelyahavaCall me Ahava ~~She/Her~~Move to New ZealandRegistered Userregular
And just because they prefer this other guy, they're also likely management idiots that don't know what our who they have in you.
Just because they want one thing doesn't mean that is the good or right thing for the company or the department.
Don't let their short sighted wishes and wants get in the depths of your brain and your skill and your talent.
You are good at your job. Amazing even. You deserve the promotion. You will excel at it.
ShadowfireVermont, in the middle of nowhereRegistered Userregular
Jedoc, you can just push a couple shelves back against the wall and put up a pink rod with rainbow bead curtain. Big "adults only" sign with multicolored lights around it. Really lean into that VHS section design.
I wish I weren't an idiot, fuck, even trying to understand how to do what these helpful videos are telling me to do is frustrating me
Okay, so, VLOOKUPs simplified are ...
=VLOOKUP(what I'm looking for, the place I'm looking (the thing I'm looking for needs to be in the first column), what column has the info I care about, FALSE)
Your last part should always be FALSE unless you know what you're doing (it forces an exact match, which is the use case >98% of the time).
So, if you have a list of 20 names in column E on a spreadsheet, and you want to see if "Steve" is in the list, then ...
=VLOOKUP("Steve",$E$1:$E$20,1,FALSE)
... will show up as "Steve" if Steve is in the list and "#N/A" if it's not.
Once you've got that down, you can start expanding the use case. Instead of looking specifically for "Steve", maybe you want the value from the cell next to the formula (if the formula is written in cell B1, it would look like):
=VLOOKUP(A1, $E$1:$E$20,1,False)
Instead of just returning Steve maybe you want his address, which is the third column of data (First Name, Last Name, Street Address):
=VLOOKUP("Steve", $E$1:$G$20,3,False)
... or do both ...
=VLOOKUP(A1, $E$1:$G$20,3,False)
Without wanting to evangelize too much, I would really recommend using XLOOKUP instead, both because it's intended to replace VLOOKUP and I'm assuming VLOOKUP will be sunsetted at some point, and for simple ease of use and less chance of causing the universe to reboot, which has always been a problem with VLOOKUP.
=XLOOKUP(what I'm looking for, the place I'm looking, the place that has the data I want returned)
So if you have a list of 20 names in column E on a spreadsheet and you want to see if "Steve" is in the list then...
=XLOOKUP("Steve", $E$1:$E$20, $E$1:$E$20)
You just drag select E1 to E20 twice and that's it. You'll get Steve.
If you have a row of 20 names starting in column E, going to column N and you want to see if "Steve" is in the row...
=XLOOKUP("Steve", $E$1:$N$1, $E$1:$N$1)
There's no separate HLOOKUP required, as long as the return array matches the form of the lookup array, XLOOKUP will get you what you want.
If you have a list of names and addresses in column E and F and you want Steve's address, it's...
=XLOOKUP("Steve", $E$1:$E$20, $F$1:$F$20)
You don't have to worry about the lookup array encompassing the return array and how much you offset, if you want to look something up in E and return what's in F, the two arrays just have to be the same length (so 1 to 20 in both).
If you have a list of names, adresses, emails and job titles in E to H and you want the adress, email and job title returned, it's...
=XLOOKUP("Steve", $E$1:$E$20, $F$1:$H$20)
And that gives you an array spill of all three columns. As long as the two arrays are the same length, you can get as many columns back as you want.
Now, you can add in any of the optional extra commands as needed. Let's say you have a column E with first and last names in the same cell and you want a wildcard search for anyone with the first name Steve and if there's no one, you want it to return the message "We're Steveless, man, Steveless!".
"2" just means that wildcards, such as *, are used.
I've occasionally had data sets where the lookup value I was looking for was either in column A or in column B, and I've used the "if not found, then" part of XLOOKUP in A to do a nested XLOOKUP in B. You can also do a nested horizontal XLOOKUP in the return array to get the intersecting value of two lookups, replacing the INDEX/MATCH combo.
You can do a lot of nifty stuff in Excel these days.
+10
webguy20I spend too much time on the InternetRegistered Userregular
Well, it looks like I'm a shoe-in for the team lead role barring me completely bombing my interview.
But it's fun because I'm only getting it due to the other guy getting fucked on technicalities since he quit and came back! I know, like actually know, both my boss and my boss's boss wanted him in one of the two roles and he would've beaten me out for it in the first go round. So much so, they delayed posting the second job because they know he's not eligible to bid on it now.
So, it's kinda like, cool, once again I am getting something not because I earned it or was the best person for the job, I was just second in line with the minimum check marks when they couldn't get who they really wanted.
The only reason I have my job is because the guy that hired me fell off the wagon. It sucked. I was running cover for him for close to 6 months, he hired me and I thought I owed him.
I didn't "deserve" my job either, but who fuckin cares? They wouldn't hire you if they didn't think you could do it.
Talking with a coworker who I trust, they brought up maybe bringing up my issues with management since they certainly want to keep current staff.
Somehow I don't think a 29 year old bringing up management issues with a couple of boomers would go well. And by management issues of course I mean the "you're condescending and don't trust your staff and your snide comments aren't great."
My wife's hopes of getting remote status after we move were pretty diminished today, a coworker who is homebound for just a couple of weeks after foot surgery can't even get it.
Which increases my worrying about myself as well, even if my dept and position is different.
Well, it looks like I'm a shoe-in for the team lead role barring me completely bombing my interview.
But it's fun because I'm only getting it due to the other guy getting fucked on technicalities since he quit and came back! I know, like actually know, both my boss and my boss's boss wanted him in one of the two roles and he would've beaten me out for it in the first go round. So much so, they delayed posting the second job because they know he's not eligible to bid on it now.
So, it's kinda like, cool, once again I am getting something not because I earned it or was the best person for the job, I was just second in line with the minimum check marks when they couldn't get who they really wanted.
This is also true of every success ever, we just usually don't know who the "better" option was. For every olympic gold medallist in history, there's at least one other person out there who would have thrashed them if they'd only had the right opportunities.
If I could get my boss to buy me the tiniest bit of excel training, my life would be so much easier
Dude first I will grace you with one of my favorite Excel memes:
Second, as an older Excel nerd, I will spend an hour giving you a basics of Excel class on a googlemeet or something if you like. I love working in Excel and it makes me happy when people learn to use it.
Talking with a coworker who I trust, they brought up maybe bringing up my issues with management since they certainly want to keep current staff.
Somehow I don't think a 29 year old bringing up management issues with a couple of boomers would go well. And by management issues of course I mean the "you're condescending and don't trust your staff and your snide comments aren't great."
It's tough, like yeah, bringing up the issues with management would theoretically be the right thing to do, but it sounds like you're burnt out and over all of it, with one foot out the door, if not just one toe left in the door at best.
Trying to change your boss's behavior at this point via management would be a long haul, if you're not in for that then yeah I wouldn't bother either.
I only grogged VLOOKUP after receiving a spreadsheet from a colleague that had one, and me having a similar spreadsheet that needed one. Still took me a while to figure out how finicky it actually was, but I got there in the end. Just need to dick around until you get it right.
Use tables! If you have data in a table, use ctrl+t to turn it into an actual table. It creates a table with dynamic references so you can use formulas to reference columns in the table and it'll always include all the rows in the column even if you add/remove data. It's a lot easier to read, an XLOOKUP between two tables that looks for a value in the Article-column from the current table in the Article-column in Table1 and returns the price from the Price-column in Table1 looks like: =XLOOKUP([@Article];Table1[Article];Table1[Price];"Not found")
Plus you get colors and filters and autofilling formulas.
Sick of going through the "ribbon" to find the functions you use all the time? That little menu with the Save icon above it has an options menu, click the little arrow on the right and choose "Show below the ribbon" to move it below for more convenient access. Then right click any function you want and "Add to quick access toolbar" to add a shortcut that's always available whichever tab you're on.
Use & to concatenate data. =A1&A2 will concatenate the cells, no need to use a formula. Use F4 to cycle through locking references, if you can't use dynamic ones.
If you're unsure of a formula use the Formula tab to insert it, this gives you the excel formula wizard that explains every field. It's not always super easy to understand but it's usually better explained than trying to type it in by hand.
I used to teach myself Excel at work by creating random character sheet generators and seeing how intricate I could make the formulae before they started breaking, figuring out why it was breaking and how to fix it, seeing other stuff breaking, repeat ad infinitum.
I didn't have much else to do at the time but I did learn vlookup and hlookup in the process
If you keep getting errors, do a trim on the source columns. Maybe excel is better these days but in the part of you had hidden spaces at the end in a cell in one of the columns but not the other it would give a fail because they didn’t match correctly.
I was working with dirty data though, data directly out of the system shouldn’t have those problems hopefully.
If all of your entries have the same amount of spaces at the end, you can use:
=LEFT(A2,LEN(A2)-1)
where A2 has your data, and 1 is the number of blank spaces at the end. The LEFT function takes a cell and only uses the amount of digits your specify. In this case, we're using the LEN function to give us the length of a cell, then subtracting one. In this way, we trim off the last digit.
You can also use the RIGHT function and an IF statement to have your tool check to see if trimming is needed:
=IF(RIGHT(A2,1)=" ",LEFT(A2,LEN(A2)-1),A2)
The IF function allows you to do a check, then an action if the check passes, and another action if the check fails. In this case, our check is "Does the last digit of this cell equal a blank space?" If yes, we use our trim function. If no, no trimming is needed, so we just list the original value. =IF(check,if true, if false)
A trick now is if you copy your column with the trimming, you can paste as values over your original entries. Then you can delete the functions entirely.
One final thing to add is an IFERROR function so that if something causes the formula to return a #N/A, you can have it return something else. We're going to use double quotes with no space between them to return an empty cell if an error occurs. ""
In the last four workdays we have:
- almost been sideswiped by a bus
- almost rear ended someone deciding a last second U-turn across four lanes of traffic was a great idea
- couldn't leave our house because our weirdo neighbors were blocking our driveway.
In the last four workdays we have:
- almost been sideswiped by a bus
- almost rear ended someone deciding a last second U-turn across four lanes of traffic was a great idea
- couldn't leave our house because our weirdo neighbors were blocking our driveway.
Posts
Island Name: Felinefine
But it's fun because I'm only getting it due to the other guy getting fucked on technicalities since he quit and came back! I know, like actually know, both my boss and my boss's boss wanted him in one of the two roles and he would've beaten me out for it in the first go round. So much so, they delayed posting the second job because they know he's not eligible to bid on it now.
So, it's kinda like, cool, once again I am getting something not because I earned it or was the best person for the job, I was just second in line with the minimum check marks when they couldn't get who they really wanted.
Hmmmm
So there's two roles, they really want this person for one of them, so they're holding posting the second for this person so they can get it later.
In the meantime you're a shoe-in for the one role, which, if this person had been eligible, would have been one of the two roles.
Unless there's some mysterious third person I fail to see how you're not one of the top two candidates so fuck it, get that job, get that paper.
Also this other person quit and came back while you put up with the suck. Does it blow for them that they have to wait for the job? Sure, but they made their choice, that's not your fault or problem. Fuck that.
When I started working after 08 there were a bunch of people who had left for better jobs before the great recession that came back and had to take positions behind me, greeny mc green sauce. Did that suck for them? Absolutely, but ain't shit I could have done about it so :shrug:
If this person is that good they'll get theirs eventually, in the meantime don't feel bad about yours after all the shit you've gone through.
If they didn't want you for the role they wouldn't offer it to you. Full stop.
Like Pellaeon said there are two positions available. It sounds like you'd be getting one of the two regardless of what the other person had done.
Just because they want one thing doesn't mean that is the good or right thing for the company or the department.
Don't let their short sighted wishes and wants get in the depths of your brain and your skill and your talent.
You are good at your job. Amazing even. You deserve the promotion. You will excel at it.
Whether they want it or not.
Democrats Abroad! || Vote From Abroad
teehee
Steam: Elvenshae // PSN: Elvenshae // WotC: Elvenshae
Wilds of Aladrion: [https://forums.penny-arcade.com/discussion/comment/43159014/#Comment_43159014]Ellandryn[/url]
Without wanting to evangelize too much, I would really recommend using XLOOKUP instead, both because it's intended to replace VLOOKUP and I'm assuming VLOOKUP will be sunsetted at some point, and for simple ease of use and less chance of causing the universe to reboot, which has always been a problem with VLOOKUP.
=XLOOKUP(what I'm looking for, the place I'm looking, the place that has the data I want returned)
So if you have a list of 20 names in column E on a spreadsheet and you want to see if "Steve" is in the list then...
=XLOOKUP("Steve", $E$1:$E$20, $E$1:$E$20)
You just drag select E1 to E20 twice and that's it. You'll get Steve.
If you have a row of 20 names starting in column E, going to column N and you want to see if "Steve" is in the row...
=XLOOKUP("Steve", $E$1:$N$1, $E$1:$N$1)
There's no separate HLOOKUP required, as long as the return array matches the form of the lookup array, XLOOKUP will get you what you want.
If you have a list of names and addresses in column E and F and you want Steve's address, it's...
=XLOOKUP("Steve", $E$1:$E$20, $F$1:$F$20)
You don't have to worry about the lookup array encompassing the return array and how much you offset, if you want to look something up in E and return what's in F, the two arrays just have to be the same length (so 1 to 20 in both).
If you have a list of names, adresses, emails and job titles in E to H and you want the adress, email and job title returned, it's...
=XLOOKUP("Steve", $E$1:$E$20, $F$1:$H$20)
And that gives you an array spill of all three columns. As long as the two arrays are the same length, you can get as many columns back as you want.
Now, you can add in any of the optional extra commands as needed. Let's say you have a column E with first and last names in the same cell and you want a wildcard search for anyone with the first name Steve and if there's no one, you want it to return the message "We're Steveless, man, Steveless!".
=XLOOKUP("Steve*", $E$1:$E$20, $E$1:$E$20, "We're Steveless, man, Steveless!", 2)
"2" just means that wildcards, such as *, are used.
I've occasionally had data sets where the lookup value I was looking for was either in column A or in column B, and I've used the "if not found, then" part of XLOOKUP in A to do a nested XLOOKUP in B. You can also do a nested horizontal XLOOKUP in the return array to get the intersecting value of two lookups, replacing the INDEX/MATCH combo.
You can do a lot of nifty stuff in Excel these days.
Origin ID: Discgolfer27
Untappd ID: Discgolfer1981
Try not to blow up the universe, though.
The only reason I have my job is because the guy that hired me fell off the wagon. It sucked. I was running cover for him for close to 6 months, he hired me and I thought I owed him.
I didn't "deserve" my job either, but who fuckin cares? They wouldn't hire you if they didn't think you could do it.
Somehow I don't think a 29 year old bringing up management issues with a couple of boomers would go well. And by management issues of course I mean the "you're condescending and don't trust your staff and your snide comments aren't great."
Which increases my worrying about myself as well, even if my dept and position is different.
Windowns?
there was a gas leak
This is also true of every success ever, we just usually don't know who the "better" option was. For every olympic gold medallist in history, there's at least one other person out there who would have thrashed them if they'd only had the right opportunities.
Dude first I will grace you with one of my favorite Excel memes:
Second, as an older Excel nerd, I will spend an hour giving you a basics of Excel class on a googlemeet or something if you like. I love working in Excel and it makes me happy when people learn to use it.
Just let me know, I'm on PST time
It's tough, like yeah, bringing up the issues with management would theoretically be the right thing to do, but it sounds like you're burnt out and over all of it, with one foot out the door, if not just one toe left in the door at best.
Trying to change your boss's behavior at this point via management would be a long haul, if you're not in for that then yeah I wouldn't bother either.
Use tables! If you have data in a table, use ctrl+t to turn it into an actual table. It creates a table with dynamic references so you can use formulas to reference columns in the table and it'll always include all the rows in the column even if you add/remove data. It's a lot easier to read, an XLOOKUP between two tables that looks for a value in the Article-column from the current table in the Article-column in Table1 and returns the price from the Price-column in Table1 looks like: =XLOOKUP([@Article];Table1[Article];Table1[Price];"Not found")
Plus you get colors and filters and autofilling formulas.
Sick of going through the "ribbon" to find the functions you use all the time? That little menu with the Save icon above it has an options menu, click the little arrow on the right and choose "Show below the ribbon" to move it below for more convenient access. Then right click any function you want and "Add to quick access toolbar" to add a shortcut that's always available whichever tab you're on.
Use & to concatenate data. =A1&A2 will concatenate the cells, no need to use a formula. Use F4 to cycle through locking references, if you can't use dynamic ones.
If you're unsure of a formula use the Formula tab to insert it, this gives you the excel formula wizard that explains every field. It's not always super easy to understand but it's usually better explained than trying to type it in by hand.
I didn't have much else to do at the time but I did learn vlookup and hlookup in the process
The art on the wall.
I forgot about that...
http://www.fallout3nexus.com/downloads/file.php?id=16534
If all of your entries have the same amount of spaces at the end, you can use:
=LEFT(A2,LEN(A2)-1)
where A2 has your data, and 1 is the number of blank spaces at the end. The LEFT function takes a cell and only uses the amount of digits your specify. In this case, we're using the LEN function to give us the length of a cell, then subtracting one. In this way, we trim off the last digit.
You can also use the RIGHT function and an IF statement to have your tool check to see if trimming is needed:
=IF(RIGHT(A2,1)=" ",LEFT(A2,LEN(A2)-1),A2)
The IF function allows you to do a check, then an action if the check passes, and another action if the check fails. In this case, our check is "Does the last digit of this cell equal a blank space?" If yes, we use our trim function. If no, no trimming is needed, so we just list the original value. =IF(check,if true, if false)
A trick now is if you copy your column with the trimming, you can paste as values over your original entries. Then you can delete the functions entirely.
One final thing to add is an IFERROR function so that if something causes the formula to return a #N/A, you can have it return something else. We're going to use double quotes with no space between them to return an empty cell if an error occurs. ""
=IFERROR(IF(RIGHT(A2,1)=" ",LEFT(A2,LEN(A2)-1),A2),"")
Doug’s gonna report back in 8 hours and tell us that he’s seen the time knife and can now manipulate reality with pivot tables.
And we’ll say, “yeah, that’s excel, baby.”
Steam: Elvenshae // PSN: Elvenshae // WotC: Elvenshae
Wilds of Aladrion: [https://forums.penny-arcade.com/discussion/comment/43159014/#Comment_43159014]Ellandryn[/url]
- almost been sideswiped by a bus
- almost rear ended someone deciding a last second U-turn across four lanes of traffic was a great idea
- couldn't leave our house because our weirdo neighbors were blocking our driveway.
I want to work remote again.
sounds like you need a bazooka
I gotta be honest, I am definitely more concerned about "Army/Navy Coordinator"
I can provide a couple of Marshall 4×12 cabs if one is looking to go full Doof Wagon.
~ Buckaroo Banzai
i could never show my face on my christian minecraft server again if i did such a crime
sounds like you need a bazooka
(just testing my theory that this response works in reply to literally anything)
Like at least with no tip you can just assume the person is a thoughtless asshole in general, but a $2 tip is personal.