salary

  1. C

    What's the most efficient way to remove all the salary info from my model without ruining all the calcs?

    I work in Finance and I need to send out our budget model to one of our business partners, but she can't see all the salary info we have in there. One option is to go tab by tab (there are probably 30) and manually copy/paste values in the person-by-person salary calc, then delete the person by...
  2. S

    INDEX and MATCH Function

    I am trying to use the INDEX and MATCH function to look up a date within a range to bring back a annual salary amount. Here is the LOOKUP table which is on a sperate tab in the workbook call Pay_Scales: Annual Salary Start Date End Date 46395 2018-12-17 2019-05-02 47789...
  3. D

    Future employee salary/rasies

    I know how do do a simple salary schedule to to calculate year over year salary. I've tried googling, but came up short. Does anyone know of a formula that I can use to calculate year over year salary expense average? I'm trying to create a template to use for new-account bids to factor in...
  4. S

    Search for date in Range for each Employee VBA

    I have 850 employees and I need to calculate an estimated costs for them. I need to be able to loop through the employees, for each employee, look up their annual salary based on date ranges and Group and level. Here is an example of the pay table (simplified)...
  5. M

    Plot dots on a bar

    Hi there! Please help :) I have a graph with salary range and I want to plot my employees as dots on a bar per grades accordingly. I think I did all right, but my dots (employees) appear on a right side of the graph and not on the bars ( salary range). Both Employees and salary range are primary...
  6. S

    VBA Code for transpose for Large Data Set

    Dear All, Can you please help me to transpose data. I have three columns "Emp_ID, Compensation Plan and Amount. I want Compensation Plan to be transposed to Basic salary, HRA, Bonus and Commuting Allowance by Columns. I have 4000 employees list which has more than 18k rows. Please help...
  7. E

    Macro to create template

    Hi, Can someone please help me with this: I have a database with the fallowing information for 200 employees: Employee Name, ID, Department, Position title, Performance rating, Base salary, Performance rating,%increase, Previous year salary . I need to create a tab for each employee with...
  8. A

    Adding Values Based On Matching Cells

    Hello, I am trying to create a salary table to upload to a fantasy sports site. In order to do this quickly, I need to find a way (if it's possible) to automatically fill in values from one list to another. In the image attached, I would like to compare Column C and Column J. If a name in C...
  9. A

    VBA Copy columns with non-similar header name between two workbooks

    Hi there, how can i make a condition to copy then insert a column to another workbook, the only condition is that, if this columnd header exists in the current workbook dont copy it ! EXAMPLE: workbook1 <tbody> Name Age City Email </tbody> Workbook2 <tbody> Name Title Age...
  10. I

    Excel Data Consolidation

    I am working on a salary sheet and stuck on this situation. Sheet has a to z columns with these headings. What i need is, if employee name and employee code repeat several times, then i get sum of his duty, wages, pf, esi, pt, gross salary, advance, uniform, add money, take home, bank cheque...
  11. B

    IF Formula - nested

    Hi, I need to create an IF formula based the following information (my goal is to have a column with hourly rate per employee, whether they are hourly or salary so I can do a vacation accrual - see details below): col BC this column says either SALARY of HOURLY on each line (by employee) col...
  12. M

    Help with nested IF statement

    Employee A , aged 62 is in a pension plan, the rules of which in 2015 were: Payout = 1/2 of Salary or 15000 whichever is less, in 2019, the rules changed payout = 1/2 of Salary or Social Security limit whichever is less but if Employee A is above the age of 62, the rule has always been payout =...
  13. B

    Match value in row and the find specific value in that table

    https://screenshot.net/r4rlxf1 Hi, this should be easy but I can't seem to find the solution. See attached picture on top of the page (couldnn't add it as a picture in the post?). First I need to find the ID in column B base on values in N5-N7. The I want it to return the lastest salary...
  14. J

    Subtotal / turning rows on/off

    i have a list of names / salaries that extend multiple years (columns). i would like to add a function that i can turn on/off cells representing salary to see the total at the bottom with/without certain salaries. i want to be able to toggle name 2 on and off to see how the totals change in...
  15. K

    Automatically update Main Sheet from 3 or more other Sheets

    Hello, I need help to update Main sheets from other Sheets Example Main Sheet <tbody> Emp ID Name Gross Salary Tax Net Salay </tbody> Sheet1(Jul-19) How will automatically Emp ID & Name updated in Main Sheet <tbody> Emp ID Name Gross Salary Tax Net Salary 01...
  16. B

    Solver Question

    I cannot for the life of me find a good resource on how to effectively use solver to "solve" my problem. Column B has projected points, and column C has a corresponding salary. The goal is to maximize total projected points while not using more than 50k in salary and must use 6 players...
  17. E

    Gross salary from Net Salary

    Hi please I need urgent excel help to find the gross salary, given the Net salary in Ghana Net salary( example)....... 2,723.50 S.S.F............................5.5% P.F...............................3% NB: (S.S.F. and P.F. are deducted from the gross salary before arriving at chargeable...
  18. E

    Parsing Key Value pairs from inconsistent and incomplete data

    Hey all, I have a CSV file with the following data in rows: <tbody> {'gender': 'male', 'age': '35', 'hometown': 'Chicago', 'car': 'Civic', 'occupation': 'actor', 'salary': '80000'} {'gender': 'male', 'age': '32', 'hometown': 'New York', 'occupation': 'banker', 'salary': '130000'}...
  19. A

    How to save the data & toggle between the data...!!!

    Dear friends, I have made a salary sheet. This sheet has the months & dates which changes as per the selection of the month. I am facing a couple of problems. 1. How to calculate 1st, 3rd & 5th Saturdays for the working Saturdays. Rest of the Saturdays are holidays with all the Sundays as...
  20. M

    List of Salary Change into Pro=rated Salary from Apr 2018 to Mar 2019

    Hi, I have a table (A to D) showing salary changes for staff. Would like to convert it into salary (pro-rated if needed) for 12 months from Apr 2018 to Mar 2019 (E to G). Please help! <tbody> <colgroup><col span="2"><col><col><col span="2"><col><col><col></colgroup><tbody> A B C D E F G...

Some videos you may like

This Week's Hot Topics

Top