At this point I'm convinced every team in microsoft hates the others and passive-aggressively makes things different and hard for no reason but to spite the other teams.
At this point I'm convinced every team in microsoft hates the others and passive-aggressively makes things different and hard for no reason but to spite the other teams.
At this point I'm convinced every team in microsoft hates the others and passive-aggressively makes things different and hard for no reason but to spite the other teams.
That's always been the joke.
It's funny that the apple one was literally Disney's official structure when Walt was around.
If I could get my boss to buy me the tiniest bit of excel training, my life would be so much easier
What are you trying to do?
I think I want to do a lookup, but I'm not even sure about that
One sheet has item numbers, total issues, some other crap I don't need, but does not have the item locations
I made another report that has item numbers and item locations and put it on sheet 2
I want to write a formula that fills a column one sheet one with the item locations from sheet 2
Yea that sounds like a vlookup. There are plenty of free tutorials on that. Ive found actual excel class lackluster because there is so much random functionality that nothing sticks unless you are actually trying to do a thing.
At this point I'm convinced every team in microsoft hates the others and passive-aggressively makes things different and hard for no reason but to spite the other teams.
Your theory fits the facts we have.
In slightly encouraging news on the 'Make V1m be the SME on this bullshit that he has no idea what it's about or shit I don't know' front, my ceaseless whining on the topic irritated my manager to arrange a teams call with a couple of guys who are familiar with the system (but not the specific policy type) and a database guy to "work through the process guide together to do a test run replicating last year's results" so that I will know how to do all the things and be the perfect SME forever for this.
We got to step 3/12 in the so-called "process guide" before system-knowing guy and database guy were all
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):
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.
Just start small and go from there. Honestly, got much better at Excel when I started using it to make auto-calculating character sheets for various RPGs and other games.
Oh, yeah, and as @webguy20 mentioned, you need to make sure your data is clean. Trailing spaces are Satan, Who Is the Devil.
Kane Red RobeMaster of MagicArcanusRegistered Userregular
edited February 28
Satan, Who Is the Devil.
Edit: Okay, this joke doesn't work because the forum seems to auto-trim leading and trailing spaces, dang.
Kane Red Robe on
+8
JedocIn the scupperswith the staggers and jagsRegistered Userregular
Oh dang, I think I forgot to post about the latest legislative fuckery coming down on libraries in Oklahoma.
Anyway, the bill is loosely modeled on school library bills that have passed in a handful of states already, notably Florida. All books need to be reviewed and shelved in separate sections based on a few different levels of age-appropriate content:
Print and nonprint materials and media
shall be designated with one of the following ratings:
1. “Elementary” means the content of the print or nonprint
material or media is suitable for children enrolled in grades prekindergarten through five in this state;
2. “Junior high” means the content of the print or nonprint
material or media may not include material unsuitable for a child
enrolled in grades six, seven, and eight in this state, and parents
and legal guardians are encouraged to provide guidance to their
children in selecting print and nonprint materials and media rated
“junior high”;
3. “Under 16” means the content of the print or nonprint
materials or media may not include material inappropriate for
children under the age of sixteen (16), and parents and legal
guardians are urged to provide guidance to their children in
selecting print and nonprint materials and media rated “under 16”;
and
4. “Juniors and seniors” means the content of the print or
nonprint material or media may include some material not suitable
for minors.
Kids are not allowed to read or check out books above their grade level without written parental authorization. So far, so fascist.
What makes this extra special Oklahoma dumb is this bit:
Beginning July 1, 2024, public libraries shall place print and nonprint materials and media designated as “juniors and seniors” in a section of the library accessible only to library staff. Print and nonprint materials and media designated as “juniors and seniors” shall only be available to an individual under the age of eighteen (18) if he or she has presented library staff with written consent from a parent or legal guardian.
So even if we're going by sane community standards rather than whatever the muppets at the Oklahoma Capitol can dream up, everything above YA needs to be in a staff-only area. You may be surprised to learn that this is physically impossible as well as cruel and dumb. Just can't happen in an existing library building. And then we, what, hand deliver all three million items we check out per year from the closed stacks except for the picture books?
Anyway, four years ago I'd have confidently said this was a dick-waving show bill designed to get voted down just so the dumbfuck representative from Muskogee could go back and make campaign ads about how he fought for the right to give handguns to fetuses or whatever. Now I think it's very likely that things are going to get extremely stupid around here before they get better.
+19
AthenorBattle Hardened OptimistThe Skies of HiigaraRegistered Userregular
edited February 28
First full TDD done.
Man, that felt so good. Like.. if my job just involved that - talking to people, getting a grasp on what they want, looking at the tech, seeing what it can do, and pointing the two towards each other... I'd be so much happier. No second guessing.
The developers were encouraged that they could start writing their pieces independently, even down to unit tests, and therefore everyone is able to work at full steam.
I'm now sitting here dreading getting told "nope, we're not going with that."
Just start small and go from there. Honestly, got much better at Excel when I started using it to make auto-calculating character sheets for various RPGs and other games.
Oh, yeah, and as @webguy20 mentioned, you need to make sure your data is clean. Trailing spaces are Satan, Who Is the Devil.
I had to do a lot of secret murders to sanctify the inputs I used to work with
No regrets. Life is cheap, clean data are precious.
Just start small and go from there. Honestly, got much better at Excel when I started using it to make auto-calculating character sheets for various RPGs and other games.
Oh, yeah, and as @webguy20 mentioned, you need to make sure your data is clean. Trailing spaces are Satan, Who Is the Devil.
I had to do a lot of secret murders to sanctify the inputs I used to work with
No regrets. Life is cheap, clean data are precious.
"We used to have a lot of problems with Jim in registration copying data from Excel into the system and causing errors due to weird whitespace."
"Huh. I didn't know there was anyone in registration named Jim."
"..."
KakodaimonosCode fondlerHelping the 1% get richerRegistered Userregular
Man, today has been fun. We've rolled out an internal release that changes our internal message format. Our data research team, in their infinite wisdom, has decided that even though they consume the internal message format, they won't integrate into our release schedule because "We need to be able to control our releases and do them on our own timeline."
So of course, they did not do a release this weekend. Even after multiple meetings, e-mails and alerts that we're changing our internal message format. So now all of their programs die a horrible death.
The one good thing is once the dust settled, our CTO told them that if they're going to be responsible for their own releases, they are responsible for making sure they upgrade when it's needed and any data loss is their responsibility and if they have to purchase it from external sources, it's coming from their budget.
More issues with the telework program today. Contacted IT and they remoted in, checked the VPN, and proceeded to use the "self-repair" function six times before giving up.
So now I gotta bring it in tomorrow and the rest of the day is sitting on the email client I can only open in browser
Man, today has been fun. We've rolled out an internal release that changes our internal message format. Our data research team, in their infinite wisdom, has decided that even though they consume the internal message format, they won't integrate into our release schedule because "We need to be able to control our releases and do them on our own timeline."
So of course, they did not do a release this weekend. Even after multiple meetings, e-mails and alerts that we're changing our internal message format. So now all of their programs die a horrible death.
The one good thing is once the dust settled, our CTO told them that if they're going to be responsible for their own releases, they are responsible for making sure they upgrade when it's needed and any data loss is their responsibility and if they have to purchase it from external sources, it's coming from their budget.
"Wait, no, we said we wanted to control our releases, not be responsible for them!"
Posts
Twitter:
It's funny that the apple one was literally Disney's official structure when Walt was around.
why does Disney have a morgue on the org chart??
what don't you?
Like he was going to trust somebody else to handle his body before it was frozen.
{Twitter, Everybody's doing it. }{Writing and Story Blog}
Sometimes, people die, even in the hap-hap-happiest place on Earth.
[/spolier][/spolier]
Steam: Elvenshae // PSN: Elvenshae // WotC: Elvenshae
Wilds of Aladrion: [https://forums.penny-arcade.com/discussion/comment/43159014/#Comment_43159014]Ellandryn[/url]
You need somewhere to dump the animators after Walt bled them dry.
It's necessary as they also have Police on the org chart.
Sounds like a question.
Mickey doesn't like questions.
What are you trying to do?
Origin ID: Discgolfer27
Untappd ID: Discgolfer1981
I think I want to do a lookup, but I'm not even sure about that
One sheet has item numbers, total issues, some other crap I don't need, but does not have the item locations
I made another report that has item numbers and item locations and put it on sheet 2
I want to write a formula that fills a column one sheet one with the item locations from sheet 2
Yea that sounds like a vlookup. There are plenty of free tutorials on that. Ive found actual excel class lackluster because there is so much random functionality that nothing sticks unless you are actually trying to do a thing.
Origin ID: Discgolfer27
Untappd ID: Discgolfer1981
ULTIMATE POWER
Edit:
Presumably given where its located in the chart it deals with deep archival storage of film or documents and not actual bodies.
lol
lmao
Lookups can be a pain in the ass for anybody first figuring them out, but once they click it’ll become a lot clearer.
Origin ID: Discgolfer27
Untappd ID: Discgolfer1981
I mean, he had the restaurants at the parks right there.
Brofist, friend.
http://www.fallout3nexus.com/downloads/file.php?id=16534
Your theory fits the facts we have.
In slightly encouraging news on the 'Make V1m be the SME on this bullshit that he has no idea what it's about or shit I don't know' front, my ceaseless whining on the topic irritated my manager to arrange a teams call with a couple of guys who are familiar with the system (but not the specific policy type) and a database guy to "work through the process guide together to do a test run replicating last year's results" so that I will know how to do all the things and be the perfect SME forever for this.
We got to step 3/12 in the so-called "process guide" before system-knowing guy and database guy were all
So we're, uh, pushing back.
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)
Steam: Elvenshae // PSN: Elvenshae // WotC: Elvenshae
Wilds of Aladrion: [https://forums.penny-arcade.com/discussion/comment/43159014/#Comment_43159014]Ellandryn[/url]
http://www.fallout3nexus.com/downloads/file.php?id=16534
I'll give it another try shortly
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.
Origin ID: Discgolfer27
Untappd ID: Discgolfer1981
Just start small and go from there. Honestly, got much better at Excel when I started using it to make auto-calculating character sheets for various RPGs and other games.
Oh, yeah, and as @webguy20 mentioned, you need to make sure your data is clean. Trailing spaces are Satan, Who Is the Devil.
Steam: Elvenshae // PSN: Elvenshae // WotC: Elvenshae
Wilds of Aladrion: [https://forums.penny-arcade.com/discussion/comment/43159014/#Comment_43159014]Ellandryn[/url]
Edit: Okay, this joke doesn't work because the forum seems to auto-trim leading and trailing spaces, dang.
Anyway, the bill is loosely modeled on school library bills that have passed in a handful of states already, notably Florida. All books need to be reviewed and shelved in separate sections based on a few different levels of age-appropriate content:
shall be designated with one of the following ratings:
1. “Elementary” means the content of the print or nonprint
material or media is suitable for children enrolled in grades prekindergarten through five in this state;
2. “Junior high” means the content of the print or nonprint
material or media may not include material unsuitable for a child
enrolled in grades six, seven, and eight in this state, and parents
and legal guardians are encouraged to provide guidance to their
children in selecting print and nonprint materials and media rated
“junior high”;
3. “Under 16” means the content of the print or nonprint
materials or media may not include material inappropriate for
children under the age of sixteen (16), and parents and legal
guardians are urged to provide guidance to their children in
selecting print and nonprint materials and media rated “under 16”;
and
4. “Juniors and seniors” means the content of the print or
nonprint material or media may include some material not suitable
for minors.
Kids are not allowed to read or check out books above their grade level without written parental authorization. So far, so fascist.
What makes this extra special Oklahoma dumb is this bit:
So even if we're going by sane community standards rather than whatever the muppets at the Oklahoma Capitol can dream up, everything above YA needs to be in a staff-only area. You may be surprised to learn that this is physically impossible as well as cruel and dumb. Just can't happen in an existing library building. And then we, what, hand deliver all three million items we check out per year from the closed stacks except for the picture books?
Anyway, four years ago I'd have confidently said this was a dick-waving show bill designed to get voted down just so the dumbfuck representative from Muskogee could go back and make campaign ads about how he fought for the right to give handguns to fetuses or whatever. Now I think it's very likely that things are going to get extremely stupid around here before they get better.
Man, that felt so good. Like.. if my job just involved that - talking to people, getting a grasp on what they want, looking at the tech, seeing what it can do, and pointing the two towards each other... I'd be so much happier. No second guessing.
The developers were encouraged that they could start writing their pieces independently, even down to unit tests, and therefore everyone is able to work at full steam.
I'm now sitting here dreading getting told "nope, we're not going with that."
I had to do a lot of secret murders to sanctify the inputs I used to work with
No regrets. Life is cheap, clean data are precious.
"We used to have a lot of problems with Jim in registration copying data from Excel into the system and causing errors due to weird whitespace."
"Huh. I didn't know there was anyone in registration named Jim."
"..."
3DS: 0473-8507-2652
Switch: SW-5185-4991-5118
PSN: AbEntropy
So of course, they did not do a release this weekend. Even after multiple meetings, e-mails and alerts that we're changing our internal message format. So now all of their programs die a horrible death.
The one good thing is once the dust settled, our CTO told them that if they're going to be responsible for their own releases, they are responsible for making sure they upgrade when it's needed and any data loss is their responsibility and if they have to purchase it from external sources, it's coming from their budget.
So now I gotta bring it in tomorrow and the rest of the day is sitting on the email client I can only open in browser
"Wait, no, we said we wanted to control our releases, not be responsible for them!"
Steam, Warframe: Megajoule