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

In the last PDM town hall, they said they were going to lower utilization targets for those that work on projects with capped hours. For those people, have you seen your utilization target lowered? I haven’t seen shit change for me.

like

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

When they say utilization doesn't count for the month of May/June what exactly does that entail? I'm assuming being on the bench for those months will still show on personal utilization reports...

like

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

like

How does your firm measure utilization? I work for a small boutique that defines it as utilization = number of billable hours/2,080 and full bonus payout occurs at 80% plus.

like

Have any respiratory therapists found jobs OTHER than being a clinical RT? I want to possibly change careers, but I am finding that a lot of jobs (clinical liason, utilization review, etc) want you to have a nursing degree, not a respiratory degree. I feel like as an RT we are limited to jobs.

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?

I wish admin utilized Tier 1 supports with teachers. Smiles, appreciations and acknowledging ones efforts would do a great deal to boost morale and climate. I just don’t understand what that is so hard to do.

like

Am I understanding utilization rate correctly? It’s chargeable time over total time? Charged 40 hours and had 10 hours non-charge so my utilization is 80%? If so, wouldn’t it benefit me to understate non-charge hours so my utilization is higher since they only really care about chargeable time anyways? Charge 40 hours still but only put 5 hours non-charge for utilization to be 89% instead of 80%? Or am I misunderstanding how utilization works?

like

What other performance factors are considered for PDM besides utilization?

like

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!

Counselor told me yesterday that the firm is considering cutting me due to low utilization. Any recommendations?

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....

I'm almost at the point of an offer, and also just started a 6 month long engagement since my utilization was taking a hit. How do you fish recommend dealing with the situation once the offer comes?

like

I’ve been on the bench with less than 10% utilization for 3wks now. I’m a first year and the past month has been slower with not many new projects coming in. I do see a few new projects come in every week but I’m not getting staffed on them. Should I be worried? Should I ask my PM if I should be worried? We’re in a pretty small group less than 20 people

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

Hired as SA1. if my utilization is low for round table but I’ve gotten good Snapshots will I go up to SA2 or SA1B, which I don’t want of course.

like

Bain fish, does anyone know how utilization in North America is trending for this year?

like

I have been tagged for this project that doesn’t start until June 10th. My utilization is going to drop significantly but at the same time the deployment team cannot present me elsewhere. Ugh!

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

More Posts

Anyone wanna rant? If so, please provide details of the craziest shit u have been through in ur career🤗

funny

Hey Fishes,

Hope you're having a great sunday eve, I am looking for a job change and would really appreciate if you guys have any leads or if you can refer me.

YOE : ~4 years
Role : Business Analyst
Domain: Fitness and Wellness

Thanks in advance !

like

I had here about Walmart company has us health care now if the news is correct so I do have a plus year of experience in same domain and currently working as a lead analyst in your health care company and looking for the change if you have any of me please consider

like

I have an annual membership to tryexponent for FAANG and tech prep. I don’t need the membership anymore and have about 6-8 months. I can share my creds for $60. The content was extremely helpful, I made it to Amazon. Let me know if anyone’s interested

Hi everyone,

I have 3 years of experience as a frontend developer(JavaScript/ ReactJs)

I just want to know what's the current salary range of a frontend developer for above mentioned experience in service based and product based companies?

like

Thoughts on Centron?

Is there a need for a pharma/HC agency to build and maintain a curated trusted publisher network and execute buys programmatically with them?

Looking for insights and chit chat on the topic —>

In ey gds when mail will come for uploading docs before joining? What's are the documents need to upload? EY

Do you see an increase in ER visits during the holidays? If so why? What is the weirdest story that you are willing to share?

Hi Everyone. I have been offered a role as Experienced Associate in PWC AC Bangalore in management consulting . But they didn’t offer any joining bonus. Should I negotiate for the same?

like

Is knowing how to communicate a compatibility issue or can it be learned?

like

Feeling low on inspiration rn, what do you like to do to get your creative juices flowing again?

like

Any digital producers out there who are savvy with DCO? Remote assignment for a Brand through EOY. DM me if that’s you!

like
like

What is the standard billing for a surgical PA? 20% of what the MD is billing? Does anyone know?

like

Anyone actually using this VR thing? Beat Sabre all day.

like

Seriously considering adding vegan stuff to my restaurant's menu, I don't have anything against meat except I can't afford it. :( Any ideas on something that doesn't taste like treebark? LOL

like

She doesn't know the real reason why I'm lukewarm about kids: I don't think she's matured enough. I'm trying to plan for retirement and a house, but all she wants is her next overseas vacation

like

Team. I have a valid visa stamp till Dec 2019 with EY. However I moved to PwC couple of months back. If I travel to India in December, do I need to go for stamping again or will my I797 suffice at the port of entry ??

Not even done drafting .. (10 team, 1st overall pick)

Post Photo
like

Additional Posts in Excel Genius

This is dumb, but. How can I pull and average the numbers in column b associated with the 4 values in column a? So, (sum of all As/total number of As) without filtering?

Post Photo
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

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.

How do I compare two sheets to make sure they are identical?

like

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

likehelpful

Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?

likehelpful

Would anyone be willing to teach me vlookup?

like

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

like

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

like

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

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

like

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?

like

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

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

like

What are some common reasons that a COUNTIF formula might not be working correctly? I'm using the correct range and value to count. I'm not seeing "ERROR" but the values aren't correct (it's not counting everything). Thx.

like

Anybody have the SQL server data mining add in on excel? Desperately need to run a really quick analysis through it but can’t configure it.

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

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

Best free data sites to tap into to build a city analysis model? Basically I want to "discover" cities with certain dimensions, like: population, elevation, climate, and proximity to other things (ski resorts, particularly)?

like

Still don't have xlookup. #fomo

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