|
The Fool posted:Are these five categories a known list that will never/rarely change? The categories will be the same across all cost codes and will never change. For example, labor is one, equipment is another. In the pivot table, I need there to be cost codes in rows, and then under that in the hierarchy, the categories in rows. If there's nothing in the category for that cost code I will show it with a value of zero. 22 Eargesplitten fucked around with this message at 20:20 on Aug 9, 2017 |
#
?
Aug 9, 2017 20:17
|
|
|
|
| # ? May 31, 2024 09:41 |
|
|
Must it be a pivot table? Because if not, create a static list of all the cost codes and use SUMIF() or something to emulate a pivot table but without all the dynamic-ness you get with one.
|
|
#
?
Aug 9, 2017 20:32
|
|
|
That might have been best to do from the beginning, but I don't think I have the time anymore. I actually got a request Thursday (my first draft was due Monday) saying "can we do it with this specific software we never told you we wanted you to use and that you have no experience with?" That's probably the next step, but I'm supposed to get it done like this and I don't think I have the time to redo it completely. Especially since they want me to get seven of the drat things done in one workday.
|
|
#
?
Aug 9, 2017 21:05
|
|
|
22 Eargesplitten posted:That might have been best to do from the beginning, but I don't think I have the time anymore. I actually got a request Thursday (my first draft was due Monday) saying "can we do it with this specific software we never told you we wanted you to use and that you have no experience with?" Would something like this work? 
|
|
#
?
Aug 9, 2017 21:21
|
|
|
Yes, that's exactly what I need.
|
|
#
?
Aug 9, 2017 21:24
|
|
|
22 Eargesplitten posted:Yes, that's exactly what I need. Turn on PowerPivot, if you're not using it already. Create an extra table that is just your category codes  Add this table and your main data table to the powerpivot data model. (just select your table, click PowerPivot, then "Add to Data Model") Create a pivot table from the excel data model. Setup your pivot table so that you are using the fields you need from your data, but the category code list you created.  It's going to prompt you to create a relationship between the tables, I just let it do it automatically. You'll still be missing your categories with no data, but otherwise everything should look right. Go to PivotTable Options Under Display, Check the box that says "Show items with no data on rows" Under Layout & Format "For empty cells show:" should be checked and set to zero. Now you should see rows with your 0 data categories. In my screenshot, the field format is set to Accounting. This is all in Excel 2016. No idea where/if the options exist in other versions of Excel.
|
|
#
?
Aug 9, 2017 21:37
|
|
|
I was in the bathroom and the consultant was in the next stall. He kept his phone on the floor right in front of the toilet. 
|
|
#
?
Aug 9, 2017 21:41
|
|
|
The Fool posted:Turn on PowerPivot, if you're not using it already.
|
|
#
?
Aug 9, 2017 21:43
|
|
|
Dick Trauma posted:I was in the bathroom and the consultant was in the next stall. Did you piss on it? "Accidentally?"
|
|
#
?
Aug 9, 2017 22:19
|
|
|
I mean fer Christ's sake it's in the splashdown zone in a public bathroom. Who in their right mind thinks "I need a place to put my phone down. How about right here on the floor where people piss all day every day?" I just got back from my first visit with the therapist. She's within walking distance so I notified the executive assistants that I would be gone for an hour and off I went. It was a positive experience. Unlike the last time I tried therapy years ago this one asked me some basic questions about my background and my past. I did my best to be honest and open about the last 40+ years of personal horseshit so she has the best chance to help me. This is my time slot now so we'll see how it goes. With a $13 copay there's not much to lose.
|
|
#
?
Aug 9, 2017 23:13
|
|
|
Dick Trauma posted:I mean fer Christ's sake it's in the splashdown zone in a public bathroom. Who in their right mind thinks "I need a place to put my phone down. How about right here on the floor where people piss all day every day?" Here's a happy thought to get you through the day: no matter how bad you feel, no matter how disrespectful your colleagues are, at least you aren't talking on a piss-soaked phone. You can PayPal me the $13.
|
|
#
?
Aug 9, 2017 23:27
|
|
|
devmd01 posted:gently caress servicenow and the team that is driving all of the ITIL bullshit I have to deal with. ServiceNow is the actual real life devil.
|
|
#
?
Aug 9, 2017 23:28
|
|
|
Dick Trauma posted:I mean fer Christ's sake it's in the splashdown zone in a public bathroom.
|
|
#
?
Aug 9, 2017 23:33
|
|
|
Dick Trauma posted:I was in the bathroom and the consultant was in the next stall. For more I worked at a place where the splashdown zone was pretty saturated around the urinals and the toilets in the men's john. There was one NOC guy who used to go into the bathroom in his socks and if you used the urinal or stall after him you could see the negative space in the dampness where his socks had soaked up some splash. I'd see the guy walking around the office in his socks and I would want to do physical harm to him for not caring that he had literal piss of dozen's of men soaking up into the bottoms of his socks. Some loving people, man. Why do they have to be so gross?
|
|
#
?
Aug 9, 2017 23:59
|
|
|
NewFatMike posted:ServiceNow is the actual real life devil. I cannot disagree, but I haven't decided which portion of it is most evil: the core product, or how our own people set it up for us. There may be multiple devils in play.
|
|
#
?
Aug 10, 2017 00:38
|
|
|
NewFatMike posted:ServiceNow is the actual real life devil. If its setup correctly it is probably the best ticketing system out there, but good loving luck getting it to that point.
|
|
#
?
Aug 10, 2017 00:46
|
|
|
Ask me how I just received a timely reminder that "sh" in config mode in IOS autocompletes to "shutdown" and isn't in fact the show command.
|
|
#
?
Aug 10, 2017 01:05
|
|
|
Thanks Ants posted:Ask me how I just received a timely reminder that "sh" in config mode in IOS autocompletes to "shutdown" and isn't in fact the show command. How did you receive a timely reminder that "sh" in config mode in IOS autocompletes to "shutdown"?
|
|
#
?
Aug 10, 2017 01:08
|
|
|
I'm glad you asked. I shutdown a switch port and kicked myself out. Yes I should probably have configured a reload timer. Don't do stuff when you're tired.
|
|
#
?
Aug 10, 2017 01:09
|
|
|
Thanks Ants posted:Don't do stuff ftfy with a shoutout to one of my current customers who sent me a dump list of every single object they have in AWS when I asked them for a discussion of their architecture that will be involved in a major launch in two weeks.
|
|
#
?
Aug 10, 2017 01:12
|
|
Hawzy posted:If its setup correctly it is probably the best ticketing system out there, but good loving luck getting it to that point. You need a literal team to manage it 100% of the time and big league organizational backing. If you're under 10k as an organization don't use it.
|
|
|
#
?
Aug 10, 2017 01:13
|
|
|
milk milk lemonade posted:You need a literal team to manage it 100% of the time and big league organizational backing. If you're under 10k as an organization don't use it. I'm on my 2nd job working with ServiceNow. I own and manage the tool at my new org. Everything you guys have said is true. It takes a dedicated team and a deep understanding of process and user experience. Most people don't give a poo poo so you have to make it simple. One technique for end users is layer a nice looking front end to make them think it's something other than servicenow. It sure pays well though.
|
|
#
?
Aug 10, 2017 02:37
|
|
|
Elizabethan Error posted:i hate to break this to you, but it's likely the entire bathroom is coated in a fine layer of piss already. Let's bring it further. Think about farts. People fart all day, you smell their farts, etc. Farts are aerosolised poo. When you smell farts, you're breathing in their poo. Someone else's poo is INSIDE OF YOU. :scax:
|
|
#
?
Aug 10, 2017 02:45
|
|
|
The Fool posted:Turn on PowerPivot, if you're not using it already. Thanks, that's really thorough. I was looking into PowerPivot when my boss finally called me back and we decided to just break each budget line into five lines with one category each. I'll keep that bookmarked for the future, though.
|
|
#
?
Aug 10, 2017 03:21
|
|
|
Volmarias posted:Let's bring it further. That's about the equivalent of saying mucus is saliva because they both came out your mouth.
|
|
#
?
Aug 10, 2017 03:40
|
|
|
oh rly posted:I'm on my 2nd job working with ServiceNow. I own and manage the tool at my new org. We actual use it for my department and it was a steaming pile until we finally hired a consultant that does nothing but ServiceNOW. It's now better than what the rest of the company is suffering with (Salesforce with some kind of IT extensions shoe horned in). Of course, we were coming from an ancient install of Clarify, so anything would look the like the shiny, prefect future to us. We're happy with it but it cost a lot of money to get happy with it. Plus a metric ton of automation behind the scenes helps.
|
|
#
?
Aug 10, 2017 05:30
|
|
|
Bit of an anti-poo poo pissing you off post but related so gently caress it. We homebrewed our own ticketing system, intranet, workflow management, internal news, task management et cetera. Everyone, from PMs to Sales to Helpdesk and SysAdmins get tasks which indicate what they need to accomplish and by when. Anyone can create a task and assign it to anyone else, so whenever someone would normally create a ticket they can just create a task, put it in our systems queue, and then any systems employee can pull that task to their own personal workflow, or managers can assign tasks to people. There's subtasks which can be assigned to different people built into the system too. We use google hangouts to communicate with everyone, it's great. The only time I've ever sent an email, whether as a contractor, intern, or employee was to communicate with a third party and when I was documenting Stupidest Corporate Spy. The only time I get emails is for automated poo poo, task notification, and when I signed my contracts. The whole thing works super well, it looks super slick, it performs... okayish. It also lets you search users and has a seating map which is extraordinarily convenient for me, since all of our helpdesk work is internal. I shudder to think of the cost, and the whole company is built around. No real way to implement this sorta thing unless you're doing it from the ground up in a fairly small environment though. Still, I'm dreading the ticketing systems that await me in future careers. The pizza lunches every wednesday and the open bar boat cruise tomorrow night add to the appeal too. Downside is that lol you will never get out of the office by 5.
|
|
#
?
Aug 10, 2017 06:27
|
|
Cat Army
|
The Iron Rose posted:Downside is that lol you will never get out of the office by 5. Allocate tasks to others automatically at 5. Then disappear!
|
|
#
?
Aug 10, 2017 12:33
|
|
|
NewFatMike posted:ServiceNow is the actual real life devil. Goddamnit. We just switched to ServiceNow.
|
|
#
?
Aug 10, 2017 13:24
|
|
|
This doesn't piss me off, but it does irk me: former military using military-only jargon (in this case, network names) in a non-military work environment. One of our field engineers wanted to configure a system to display the military network names instead of their non-military analogues, and got pissy when I--who is both the primary user and was not in the military--said I didn't know what she was talking about and made the programmers change it. BRB GOTTA GO HIT THE HEAD HobbitGrease fucked around with this message at 13:34 on Aug 10, 2017 |
|
#
?
Aug 10, 2017 13:32
|
|
|
RadicalR posted:Goddamnit. We just switched to ServiceNow. You can use it out of the box, but it's going to be absolutely awful.
|
|
#
?
Aug 10, 2017 13:59
|
|
|
Motherfucker. We're giving her the laptop without wiping it. My manager is going to go through it and delete anything company related. I insisted on not touching that machine ever, so I'm in the clear. But man we're never going to employ this person again, just wipe it and have done with it.
|
|
#
?
Aug 10, 2017 14:55
|
|
|
Pissing others off: Today I accidentally deleted my own workstation from the domain. Oops.
|
|
#
?
Aug 10, 2017 15:16
|
|
|
Thanks Ants posted:Ask me how I just received a timely reminder that "sh" in config mode in IOS autocompletes to "shutdown" and isn't in fact the show command. I thought IOS didn't autocomplete ambiguous shortcuts. Well, sounds like you may have saved me the same fate.
|
|
#
?
Aug 10, 2017 16:25
|
|
|
EVERY time I watch a live Cisco product demonstration or informational webex, they have audio problems and their slides don't work. Every. drat. Time.
|
|
#
?
Aug 10, 2017 16:46
|
|
|
The Iron Rose posted:Motherfucker. We're giving her the laptop without wiping it. Hands up who thinks your manager will empty the recycle bin and secure wipe the free space? Anyone?
|
|
#
?
Aug 10, 2017 16:47
|
|
|
Seems like I never see the same problem twice. So I have to start from square one everyday and there are times I just can't deliver on a fix. I feel like I'm just disappointing everyone and wasting everyone's time.
|
|
#
?
Aug 10, 2017 19:14
|
|
|
Crabby old hag who calls customers that are late in payment to get them to collect. She is never happy and always the most miserable person to interact with. She insists on stopping by my office whenever she goes to the bathroom (so 2-3 times a day). What's the grey circle? where is there a grey circle? in the user list! which user list? The directory! what directory? The one on the phone? What other directory would I be talking about! It's custom! What's custom? Whatever they set it to but what does it mean? Ask the person, they can make it do anything That's not helpful, thanks for nothing.Well gently caress you too! That list bit is what gets me, she loves ending with that poo poo, and I have no idea how she holds a job because I've heard her end poo poo with that to the CEO, CFO, and HR, they are aware and usually just roll their eyes. I assume it's because she actually gets people to pay up. She also loves to go on long rants about nothing and end with with "Just thought you should know!" and is something benign like the a random website had a 404 but refreshing it resolved the problem, of course she will tell you everything she did up to that point and take 40 minutes to get to the point.
|
|
#
?
Aug 10, 2017 19:22
|
|
|
skooma512 posted:Seems like I never see the same problem twice. So I have to start from square one everyday and there are times I just can't deliver on a fix. I feel like I'm just disappointing everyone and wasting everyone's time. How long have you been doing this work? Although I still see new problems there are repeat ones that are evergreen, and repeat problems that last through a product cycle, like Office 2010 fixes that are no longer useful for later versions, or Windows 7 tricks that fall by the wayside for 8/10.
|
|
#
?
Aug 10, 2017 19:27
|
|
|
|
| # ? May 31, 2024 09:41 |
|
|
skooma512 posted:Seems like I never see the same problem twice. So I have to start from square one everyday and there are times I just can't deliver on a fix. I feel like I'm just disappointing everyone and wasting everyone's time. This sort of sounds great to me. My days can get full with the same old poo poo so often; it can get pretty tedious. If you're newer at the role/company though, I could understand it feeling a little overwhelming while you play catch up.
|
|
#
?
Aug 10, 2017 19:51
|
|