Hello,

Is it common to set complex commission calculations for couple hundreds of employees in excel?

Thanks for any feedback!

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

Work in territories and quotas for a large tech firm…it can be done but we prefer to stay simple and not go complex when possible

like

Instead of making it simple, they made it even more complex, opening up more opportunities for errors! :(

Not uncommon but when it's that many staff I'd do it using PQ.

The more cells, rows and columns you have, the more chance of something breaking or going wrong somewhere.

It can still break with PQ but it's also a lot easier to run assurance checks.

like

Compensation consultant here; not all that uncommon depending on the size of the firm

How many employees are needed to update and sustain a model with monthly changes being a manual process causing a possibility % of errors?

Related Posts

I'm seeing a meme float around on facebook today regarding VA payments for anthrax shot related issues if it came from the squalene laced lots the FDA identified. Any truth to it? I'm skeptical.

Would you recommend the CVS test? I dont think I want to get it done due to the risks.

Did Slalom ever have a covid vaccination policy in place, like a condition of employment? Thank you.

How much CTC and in-hand is offered to Cloud Solution Engineer in Google India, Bangalore to a Fresher Graduate?

4th year Trust & Estate attorney at boutique firm in LA serving ultra high net worth clients. Trying to determine whether my compensation is fair. Any others in similar positions willing to share their salary/bonus information? Thanks!

Looking for suggestions what the are the critical recruiting metrics Amazonians use or asked during the interview process? Are they anything different from reqs load, screening, interviews, offer hire, time to hire, DEI etc…looking for some great examples.

like

Don't you think it's high time ppl start calculating in hand salary and how much % hike to ask n all?? I feel that's immatured behaviour when few of them ask these questions 😐
Itna padliya, coding bhi ati h, exp bhi h... Phr kyu??

likefunny
like
like

How is the Project Manager position at NTT ( Location : Mumbai) ?
Job security?
Pay scale to be asked for as minimum as where does this role stand in internal hierarchy in the company?
( Considering the high cost of living in Mumbai)

like

I am currently a medical biller and coder that just graduated. I am currently in an entry level position because I am still studying to get certified. I will have a year's work of exp in July and will sign a contract for another year because my boss is training me in more I don't know.

I'm wondering what the pay is for someone in my position without certification. I live with family and want to afford to move out but I am single and only make $18/hr. Is that standard or am I being underpaid?

like

Hi all,
How much time will they take for background verification in Barclays.
Can anyone tell.

like

Ladies, what heels / brands do you recommend for work? Looking for shoes I can walk around in (mostly) comfortably

like

NYC 🐠 Anyone try the dating app MOTTO? Any good?

like

Why do deals move at a breakneck pace all the time? I don’t understand the urgency put on this work for every single deal. Is it deliberate to avoid lengthy diligence / lots of questions? All these deadlines are arbitrary

like

I’m trying to get a rotation in FDD but my partner is worried about temporarily losing resources in our advisory practice. So, what are some things I could learn in FDD that I could bring back to the advisory practice that might convince the partner to let me go on rotation?

like

Worst part about being unemployed is the pity face everyone makes when you tell them. If I hear one more "don't worry you'll find something soon" I'm going to scream. Trying to be helpful is one thing but pitying me helps no one and makes me uncomfortable.

like

I DONT TALK ON FLIGHTS, PRAISE ME😤

Post Photo

What’s the Office culture like at PwC international tax team in Houston office? I’m in mid market CPA firm and trying to get into that office.

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

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

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

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

Post Photo
likehelpful

Hi Group, seems like it should be basic format, but I just can not get it to work. a list of data and want to alternate shade (blue,white,blue,etc) each line but if I have multiple lines I want to group together and they all shade the same. I want to group by the same data in column A, and the number of rows that are the same could vary. So let’s say row 1& 2 same entry in column A(blue) row 3 different (white) row 4,5,6 same as each other different to other rows (blue) etc… help 🙏

like

Would anyone be willing to teach me vlookup?

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

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

like

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

Best websites to get more of a handle on Excel as a beginner-intermediate?

like

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

like

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

likehelpful

What’s the best way to summarize multiple amortization schedule. I have each schedule on a separate tab. On a master sheet can I do something where I can input a specific month and show my ST/LT ...

like

Struggling with this:
Suppose I want to shortlist companies that serve the priority industry vertical of a country. So I have the industries served by company (one column for each industry) and (cont)

Hi All,
Looking to automate a manual process for the client and thinking of creating macros for with VBA. Has anyone done anything similar?

In the process of learning but wanted to reach out for any tips, tricks and advice anyone may have.

Thanks I’m advance.

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

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)

Anyone know what these badges are?

Post Photo
likefunny

Timesaver: If you’re working on a file saved on the cloud (teams, share point, etc.) and need the URL to communicate out, tap FILE -> INFO -> COPY PATH and the url will be on your clipboard. Pre-established sharing privileges of orig folder will apply. Hopefully this saves you time reshuffling open windows! Bonus: Same on standard MS suite files.

likesmart

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

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