Anyone have an app or Excel spreadsheet they use to keep track of utilization? We just switched systems and our new system doesn’t give us a real time balance of our utilization rate (cont)

Posting as :
works at
You are currently posting as works at

Plus, curious to know what others are using on their own to keep track. Please DM me if you’re willing to share :)

We use desktop analytics which can drill down to individual users and individual days, but also trends and averages computer usage and develops heat maps comparing both teams and users. The software buckets usage into general categories (core vs non core) and then sub categories of spreadsheets, communication, business apps, inactive/locked, personal, etc.

Im pretty sure it’s an in-house application, but companies like PEGA or others have good looking offerings which also combine RPA / automation learning capabilities.

Related Posts

Do all firms share utilization reports for all staff with everyone? I feel like it’s awful for our company culture to share everyone’s stats office-wide. Just breeds anger and bad vibes all around.

likehelpful

Do you pay your credit cards in full every month?

I ask because I’ve let my credit spending get a bit lax since moving and adopting a puppy recently, so I haven’t been paying them off in full every month like I used to (though still well above the minimum payment, and keeping utilization at 30% or under). It got me thinking about how many people adhere to this advice.

like

Team is already talking about eating hours. My utilization is down cause I was in unassigned for a month in Dec/Jan. What's worse pissing off the partner or having a low utilization? -staff 1

like

Started my first job out of college ~1month ago and am only at around 50% utilization. Before I fully ramp up, what would be some good skills or certs to work towards? I’m working for my firms management/tech practice and am also open to expanding my coding skills (currently pretty basic)

like

Just started at the firm a month and half ago and snapshots are already happening soon. How important are they? I’ve had pretty low utilization, so I’m kinda nervous as an experienced hire

like

When a consolidated unitary group acquires a TX Corp, does TX follow Sec. 382 and Sec. 383 and apply a limitation on the utilization of the acquired entity's TX R&D credits following the acquisition?

Got offer from BCG for ECT. Read numerous comments about ECT being not attractive compared to Generalist track. Also heard challenges about billability/utilization. Any views/ guidance appreciated!
I am not super keen to become a partner (selling) and main reason to join will be working with different clients, smart talented people and a good brand. End goal (at the moment atleast) is to stay for few years and return to the industry. 15 YOE

like

What are ways to deal with high latency mricroservice in a given region. Given that it's Cpu utilization is not exhausted.. So no vertical scaling ???

I am curious how other inclusion teachers are being utilized when the school is doing remote learning. I find that I am sitting in the zoom class and have very little opportunity to contribute. I am having discussions with my teachers on ways that I can better support them and the students when remote.

like

My utilization went to 50 in IBM, I think I have taken paternal leave since it went down. My manager put my as PIP improvement goal in checkpoint.
Need to know how to bring this up and is that my job is under risk? Band 7b

like

I'm 6 months old at D! Planning early promotion next year.. counselor and pm both are backing me.. I need to go to India for at least 4 weeks in Dec ... most probably would be rolling off from current project by then .. would this vacation hurt my promotion chances coz of utilization etc?

I’m struggling. I left an agency I liked last year due to growth limitations and since then I’ve worked at 2 different agencies and can’t seem to find my footing. The first one seemed like a good fit at first but then it turned out to not be the best place for me so I left. At my current agency I feel super undervalued. I’m always raising my hand and offering to help where I can and no matter what I do, I don’t feel utilized or valued or part of the team.It’s really taken a toll on my confidence

like

Any utilization review nurses working at an insurance company able to share if your company requires work on weekend/holidays? If so, what work do you do on weekend/holidays snd do you work s full day on those days?

like

How does it feel to earn less than US Consultants while also struggling for utilization

like

Here's a question I wish I never had to ask. Is it better to use the code for bereavement leave or just burn pto I'm going to lose anyway? Does it make a difference from a utilization standpoint?

like

Anyone else here have terrible utilization because their deals die and a code never opens? /can’t find another code to book hours? I’m sitting on over 200 billable hours at this point

like

If you don't log in to work hungover Monday morning, you haven't fully utilized your weekend. Change my mind.

likefunny

Hi! I’m doing some research on employee benefits (medical insurance, 401k, HSA/FSA, commuter benefits) and was hoping to connect with People specialists or HR professionals in the comp & benefits space. I’m trying to better understand any pain points or challenges you might face with utilization/enrollment. Anyone interested in connecting? Thank you!

Hadn’t noticed this sub before, and most of the threads are old so thought I’d ask a follow up - how has everyone been handling parenting with public accounting? I’ve got a toddler and my wife is an accountant (industry), and we only have a few immediate family in the country- but they have health concerns. Busy season was rough, things are looking better now as things return to normal. Still working crazy hours if you count the daycare duties on top of utilization targets.

like

I work in the IC and, as many of you know, the security related paperwork lead-time between engagements can take months sometimes. Had super low utilization due to constant rotations to....

More Posts

22- Asked to upload document in ibegin
23- Verified all documents
What next ?
Current status as show below on ibegin

Post Photo
like

What are everyone's thoughts on executive MBA vs. traditional MBA? I'm currently pursuing a traditional MBA but sometimes I wonder what could've been 😅

like

Hi Fishes I've recently started working at Accenture and company has offered me (9.1 LPA including fixed and variable) but I've got one more offer after joining Accenture from Capgemini (in Malasiya - KL) of 7000 Ringgit/ Month. Shall I leave Accenture and join Malasiya or should I stay in Accenture only? Please help me.

like
like

Can someone please suggest in what range does Barclays offer for a VP Role in the UK.

like

What is Rediscover office in KGS. Are they going to call everyone back to the office.

like

is anyone familiar with pay differentials, negotiating for a temporary raise or some other form of compensation for extra work? 3 coworkers on my team have recently resigned, and certain shifts are being expected to work at half staff until new hires can be brought on. if my workload is being doubled, i expect to be compensated, as they are paying one employee to do the work of two. any suggestions or wording on how to address this?

like

Ladies, anyone found an eye cream that actually works? Please share what that is along with your age and how long you’ve been using this product.

like

#Urgent and Active Openings

L&T Infotech is hiring Pan India for below roles: Interested people can drop their email id's and Names with respective Job Id's .

Post Photo
like

Which platform is more valuable to pursue expertise in, AWS or Azure?

like

I’m thinking about transitioning to In-House from a big law firm where I practice Employee Benefits. Will employers consider me without the typical “corporate” or “litigation” experience?

like

What do I do if my manager is ultra super micromanaging, she just called me out on an extra space in an entry in an analytical graph I created😱 not a big deal to me but she said it was unacceptable. Like idk what to do, I need the job and I’m still missing a long time to make the pivot to another company😩

likefunny

Anyone have any insight on Huge? Specifically the Google account? Gimme your good, bad, ugly or otherwise general opinion/experience/feedback!

like

When u short a stock and then they wildly miss they earnings expectations

like

I started investing in Vanguard Mutual Funds and and did some research online today and it seems like we can’t do that and it might not be halal. Does anyone have any insights here?

like

Hello,

I joined
Nagarro 1.5 months back and yet haven't received some goodies like T-shirt etc. Have anyone else faced such delay post joining? Whom to reach out to in such situations?

Nagarro

I was asked about compensation before the screening call. How much do I ask for TC for a second program manger position that’s non technical in accounting?

Is there any intel you would ask your recruiter before your loop that they may give you as help or advice?

Additional Posts in Excel Genius

How long did it take you to become good at excel? Like fast?

like

I’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

likefunny

I am trying to recreate this without the numbers at the end. Any advice?

Post Photo
likehelpful

Is there any easy way to handle FedEx/ups tracking numbers? I’d like to have some formula that would just show the status in another cell.

like

I’m verrrrrry new to excel and am going crazy because is there not a way to “clip” text in cells like you can in google sheets? I read about a “fill” option, but then noticed that cells that aren’t filled just repeat text. 😂🤯

like

I’m helping my GF with excel and need help lol. She works at a hospital and is trying to make an excel schedule for doctors to reserve rooms. She wants drop downs for days of the week (column K) and also different drop down menus in column P for the reserved time slots.

Is it possible to do this with two sets of drop downs (days of week + time slots) and not use index match here? She could make 5 tables for each day of the week, but prefers one table that can be easily navigated by doctors.

Post Photo
like

How can I copy a formula from one sheet to another?i tried the simple Ctrl+C, Ctrl-V, but the formula refers to the old sheet.

like

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

like

What are your top excel functions you use in finance / accounting - besides vlookup - Pivots - sumifs - count - index. I have an interview coming up which will have excel based technical questions. Not sure what other functions are considered important in the accounting finance world.

like

Anyone know what these badges are?

Post Photo
likefunny

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

Hey guys, I'm trying to find a formula to use instead of the Goal Seek function. Anyone know it? I thought I had seen one years ago, but can't find it now.

like

I’m calculating a bunch of totals and averages by category on one worksheet by filtering data in different categories from another worksheet. However, when I change the filters, the previously..(cont)

How do I easily find any cells that are hard coded vs formula? I have 10,000 rows of data and column F is supposed to be a formula based on columns C and D, without clicking into all 10k cells in column F how can I make sure formulas are there and not accidentally hand keyed over?

like

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

like

Anyone else have a formatting pet peeve and get annoyed when people don’t have a blank first column and row in tabs? I.e headers/data in cell A1

My first manager told me this, and I’ve followed it to a T since.

likesmart

Still don't have xlookup. #fomo

like

Vlook up isn't recognizing a couple of cells even though it's feeding off a pivot and when I check with an " if =" it comes up as being the same.
Any advice on what I need to check?
Thanks

like

Any ideas on turning string data into numerical data in excel that’s faster/easier to automate/better than using text to columns? Wish I could use alteryx, but not an option for this use case.

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal