Anyone running compensation model in excel for couple hundred employees and expect 100% accuracy?

Hello Fishes,
One query, I have received an offer letter from Wipro (Career Group: C1) with package of 28 LPA, out of which INR 420000 is allocated as 'Variable Pay' which will be paid on quarterly basis'. Need to know how much % would generally be paid out? Is it 100% or less as per the individual/organization performance.

Please help chose between PwC India and Deloitte USI. Both almost offering similar CTC but PwC location is Kolkata whereas Deloitte location is Bangalore.

Hi Fishes,

I have 1.6 years of experience in Java, Spring Boot, Angular, Microservices.

If I'm planning to switch how much CTC can I ask for?

Current CTC - 5.8LPA

I’ve been a licensed general lines (2-20) insurance agent for year and a half and have sold around 2M in premium, of which most of it is personal lines (homeowners, DP), and some commercial lines business. Even though I’m licensed to write my own business, the sole producer in the company is my boss. I currently make 35k + 15k in commissions (approximately). Is this a normal salary? Or how much should I be making? Appreciate your help

I am in final rounds with a company. They asked for my comp. expectations last week. I dodged this and got their range instead, which is lower than expected. They now want to chat about next (cont’d)

I am working in Wipro i completed 8 month the people leads gl manager are friendly but they are liar as why bcoz they was providing very very less package and adha se jada paise khud kha leta i am very disappointed from 3 month i did not get shift bonus i request you befor joining the company plzz ask all the details properly in money matters they are very very kanjus.Wipro

How much onroute pays to General manager

How much exp do i need to be apply for bi senior 2 in ey gds? What can be the expected best offer?

Hi People,

Please suggest which organisation to join.

PWC or Fractal. Both are giving almost same CTC.

YOE: 4.5
Tech: Data Analyst

Am I being paid competitively? I have been the Onboarding Sup for my HR dept for over a year now and I’m being paid the state min for salary, which for CA is 62,400. I have not gotten a merit raise since the last 2 January’s, the state raises the threshold for salary folks. My company says that was my raise. Is this right? I bring a background from the clinical operations of my company, scheduling, field work, and what the average employee faces. I want to look else where but I’m not sure.

I received a verbal offer for a VP position at CCB line of business at JPMC in NYC two weeks ago. The recruiter asked for salary expectations but there was no number set. It’s been two weeks since and complete radio silence. I sent an email to a hiring manager a week ago but received no reply. It’s August so people could be on vacation but this is really strange. Has anyone had similar experience?

Hi fiserv,
How is bench policy in mphasis. I have heard that if you are more than one month on bench, you will not get salary till you are not assigned with any project. Is it true.

What is a reasonable pay increase + bonus? This will be my first pay increase. I make 70k and I will be starting my second year at big law (immigration). I had 2 years of prior experience before joining the firm. My manager rated me highest in all areas and mentioned she recommended me for promotion but it may not happen until next cycle since there are limited number of promotions to give. I will get a pay increase regardless so I want to negotiate in case I don’t get a “good” increase.

Considering a move to industry. Have worked 5 years in consulting. Interviewing currently at the Director /VP level at banks and wondering what the base + salary + age range is.

Is it worth doing MBA for breadth of knowledge and brand network if you already have 30LPA Ctc

I'm resistant because avg iim package is 25lpa. Please suggest (opportunity cost is also high -ie 2 years plus fees investment)

(1) What are your experiences with Regeneron? Burn and churn culture or reasonable people you would work with long term? (2) what BC/TC would you target for AD within global development?

Does PWC accepts counter offer easily when produced other offer letter with more CTC?

Hi Fishes, I am looking for a role in data analyst/Business analyst/product analyst with Hyderabad as location or WFH.
Experience: 2yrs as Senior Analyst at eClerx
Current CTC: 11LPA
expecting CTC: 14LPA+
If you have any vacancy in your company please let me know
Thanks

What days does your firm close for the holidays? Are you all working on January 2nd?

(I don't want to be a task master, but as an associate, I was expected to work a half day on the 24th, and a half day on the 31st. I'm closing the office 23rd and 26th this year, but currently listed as open on Jan. 2nd).

How feasible is it to transition out of compliance into legal practice?

This question is for the project manager/resource manager. Project allocation will be done based on band or based on package in TCS

Hello fishes,
I have an offer from a startup with fixed 22 LPA.
Around what will be the in hand?
No epf is getting deducted, existing employees of the start up said so.

Has anyone refinanced their student loans on h1b visa? Is common bond the only option?

Long shot but wondering what the going salary is for Senior Producers in Toronto?

I’m a producer with six (will be 7 when my current contract is done) years experience in agency production looking to make the transition to Senior Producer and wondering what to settle for/negotiate.

Citiustech is not going to give my salary. HR said you didn't serve notice. hence you will not going to get your FNF.

Left organization in a month after joining.
Any thoughts sharks. What to do now?

Hi can anyone please refer me for the job role at Gartner? I will share the details of role.

DM me or reply in the comments, if anyone's looking for a referral in KPMG.

How are appraisals at Wissen Technology ? Wissen Technology Wissen InfoBeans

Sunday 9/4 Check In 🙌🙌 What’s everyone up to today?

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.

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

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

Does anyone from PwC have a list of the favorite groups shortcuts for excel? Please provide. Much appreciated .

Excel Rookie looking for a super simple formula to bring all information linked to a certain date in tab 1 to be organized under said date in tab 2.

Still don't have xlookup. #fomo

Need help building an electric schedule for a production schedule with a Gantt chart style view (sort of)

Currently have an excel list with resource (production line), start date and time, and then also the name of the item being produced.

Any ideas how to tackle this??

I’m thinking a stacked bar chart with the vertical categories to be my resources and horizontal the date/time and then each individual bar to be the name of the item being produced.

Thank you for the help Excel Gods 🙏

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.

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?

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)

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

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?

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.

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

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.