Calculate Rig / Truck And Perdiem For Employees

Sep 25, 2013

I am a part of an construction company, I am looking to calculate Rig Pay, Truck pay and Perdiem for each employee based on an Excel Spreadsheet pulled from the Time Card Lines out of our accounting software. I am struggling terribly, and need assistance. The Calculations are as follows

Every Employee has multiple lines in the Time Cards sheet.
Rig Pay, Truck Pay, and Perdiem come from the Employee file in our system

If employee id is the same, job number is the same, cost code is the same, calc rig pay * hrs
If employee id is the same, job number is the same, cost code is the same, calc truck pay * hrs
If employee id is the same, job number is the same,Data, and cost code is the same, calc Perdiem /day

The final result i should see how much each employee charges rig pay, truck pay, and perdiem per job, and cost code.

View 9 Replies


ADVERTISEMENT

If Statement - Calculate Bonus For Old Employees

Mar 6, 2012

I am trying to write an IF statement. The IF statement should calculate BONUS for an employee GREATER THAN 50 YEARS OLD.

View 4 Replies View Related

Calculate Employees Shifts On Weekends

May 3, 2013

In a sheet, like the example, I have monthly shift schedules for employees. What I want is to count the total shifts for Saturday and Sunday, separately Night (N) and Morning (M)/Afternoon (A) shifts, as in columns with red.

ABCDEMNOPQRAGAHAIAJ1JUNE 20132DATE1234121314151617....
HOW MANY "N" HOW MANY "M" AND "A"3SATSUNMONTUEWEDTHUFRISATSUNMON....
AT SAT-SUNAT SAT-SUN4Employee1NNNNNMM--A205Employee2MMMM-NNNNN246
Employee3AAAAM--MMM067Employee4--MM-AANNM408............................................9EXAMPLE

View 6 Replies View Related

Calculate Employees Work Hours For Overtime?

Apr 15, 2014

I have to calculate employees work hours for overtime.

in the timesheets:

A B C D E
1 ID Date Code Hours PayMethod
2 A123 4/14/14 TRN 20:00 Regular
3 A123 4/14/14 TTT 15:00 Regular
4 A123 4/14/14 TRN 13:00 <----- total for cell D2,D3, and D4 is more than 40

A B C D E
1 ID Date Code Hours PayMethod
2 A123 4/14/14 TRN 20:00 Regular
3 A123 4/14/14 TTT 15:00 Regular
4 A123 4/14/14 TRN 5:00 Regular <----- to make 40
5 A123 4/14/14 TRT 8:00 Overtime <----- 13-5=8, so i have to write down 8 here for overtime

How can I do this?

I want to make a command button for macro to perform this.

View 2 Replies View Related

Nested IF Formula: Calculate The Commission For My Employees

Feb 22, 2007

I am trying to write a command to calculate the commission for my employees. There commission is based on the spread between sale price and cost. For example:

If Profit is between $1.00 and $2.00 - commission = 15%
If Profit is between $2.01 and $4.00 - commission = 20%
If Profit is between $4.01 and $6.00 - commission = 25%
If Profit is > than $6.00 then - commission = 30%

I am able to calculate the first level ex: =IF((C3-B3)<=2,"15%") It Displays the 15% in the formatted cell. (C3-B3 is the profit spread). How can I include the other 3 commission levels in the formula to display the correct commission % based on profit spread?

View 5 Replies View Related

Calculate Employees Incentives Based On Target Achievement In Different Scales

Feb 16, 2014

I need to calculate the employees incentives based on target achievement in different scales. In attachment sheet i filled the output manually but i need the actual formula .

View 11 Replies View Related

Excel 2010 :: Calculate Min Number Of Employees For Jobs With Min Days To Complete

Feb 13, 2013

Im having a hard time creating the formula to calculate the min number of employees to complete a number of jobs that come in each day and need to be finished in 18 days or less.

Data that I have:

Forecast of the number of jobs for 251 days ( jobs range from 10 -80 per day) Each job needs to be finished in 18 days or less we need to staff a fixed number of employees for the whole year each employee can complete 4 jobs per day no weekends

i have excel 2010 and crystal ball

View 1 Replies View Related

Sumproduct And Sum Array Formula (calculate The Salary Payments To Temporary Employees In A Particular Work Unit)

Jul 16, 2009

I have a spreadsheet representing a month where I am trying to figure out different scenarios for employees. One scenario is that an employee could have to move to a temporary position. In that case, I need to calculate the salary payments to temporary employees in a particular work unit. I've tried several different approaches to this problem, but am still getting the error.

One method has been using this sumproduct formula:

View 2 Replies View Related

How To Distribute 200 Items Into 14 Employees

May 19, 2014

I been working on excel sheet that will distribute 200 items between the employees that are available to work. I've attached a copy of the workbook. First I need to look at the quantity of employees I have working that day. Second Distribute the items to each one of the employees. Third give the first employee the first piece. Fourth give the next available piece to the last person with a zero piece in their list.

book8.zip‎

View 12 Replies View Related

Protect Workbook From Ex-employees

Sep 19, 2008

How can I protect by workbook from ex-employees and the competition from using (I am aware of the weak security measures Excel offers, but something is better than nothing)? Each worksheet is password protected to slow down novice Excel users. However, ex-employees know the password. I was thinking if there was a way to have a changing password (which only a couple people would know) or have the worksheet look for a hidden file on our network, that one of these methods (or another) might work.

View 6 Replies View Related

Employees Time Sheet

Apr 17, 2009

I am creating a employee time sheet.

I am doing calculation.

I used total hours formula is =(I5-B5+(I5<B5))*24
and also worked hours formula is =((I5-B5-(I5<B5))-(D5-C5+(D5<C5))-(F5-E5+(F5<E5))-(H5-G5+(H5<G5)))*24

Problem is don't show the correct time of total hrs & worked hrs

Here i am attaching my timesheet format.

View 14 Replies View Related

Count Of Employees At Any Given Time

Jan 11, 2013

I am trying to get a count of supervisors and employees at any given time during a few day span. I think maybe a pivot chart might work but I'm stuck.

In my example I have a number of supervisors and employees in separate groups. I would like to type in two dates and two times for an in between time and get the total amount of employees working during a certain time.

Count of Employees at any given time.xlsx

View 6 Replies View Related

M-F Rotating Schedule With 7 Employees

Dec 9, 2013

After much searching today I've been unable to find a way to do this. All my searches resulted in some generic looking site looking to sell me some scheduling software.

I have a team of 7 people and I need one person to work a late shift each day of the business week. M-F

I would like a way to have the schedule automatically advance to the next person.

View 1 Replies View Related

VBA - Show Employees Details In Userform

Dec 1, 2012

I have aworkbook with Employee details data sheet. And, I have built two userforms to search and view the employee’s full details. I don’t know how to link the rowsource for combobox and textbox.

I have attached the excel file of what I'm trying to accomplish.

Book2.xlsm

View 9 Replies View Related

Formulate IF Function That Will Check Name Of Employees?

Apr 22, 2014

I have a list of employees and the dates they worked. I'm trying to formulate an IF function that will check the name of employees in the list against the to the contents of a particular cell and also check the date the employees worked against another cell that contains a specific date, and if both these conditions are met, mark that cell with an X, if not leave it empty.

The formula I have right now is =IF(AND(A2:A27=G4, D2:D27,H3),"X",""). A2:A27 is the range that contains employee names, G4 is the first employee's name who I want to check if he is on the list, D2:D27 is the list of days they worked on and H3 is the date I want to know if this particular employee worked in. Using this formula returns either an empty cell of a #NAME? error. Is this a cell formatting issue?

View 14 Replies View Related

Weekend Work Schedule For Employees

Nov 28, 2013

I am attempting to create a rotating weekend work schedule in Excel to make life easier. There are 30 people who rotate Saturday's and Sunday's every month. Technically, they are only supposed to work 2 weekends a month, and am attempting a way to create this in Excel to make it more fair to the group instead of just picking and choosing which weekend these employees work, I would like an Excel program to do this for me.

View 1 Replies View Related

Calculating Employees Hours In Macros?

May 31, 2014

Im doing a spreed sheet to calculate employees hours. I have the employees names in column R and their hours in column S. example R5 = Mike S5 = 8. I need to search column R for all the mike's and total his hours, then move to the next employee and so on... I have already sorted the employees names so that all the names and hours correspond and starting in column R5 and S5 until the proceeding row is blank and then paste the results in column B5 (employee name) and D5(total hours)

View 4 Replies View Related

Ranking Employees By Start Date

Feb 11, 2009

I am trying to rank employees by seniority date. Some employees share the same seniority date. They should have the same rank. I took a formula from another thread =RANK(C2,C$2:C$8) and applied it to my worksheet and it worked out great except that the ranking skips the next number (in this case 4)...........

View 2 Replies View Related

Calculating Overtime/Exempting Some Employees

Jun 26, 2009

=IF(C5>40,((C5-40)*D5*1.5)+40*D5,IF(C5

View 9 Replies View Related

Divide A Budget Of 100k For Each Of My Employees

Oct 23, 2009

how I would be able to divide a budget of 100k for each of my employees.

If I have employees making anywhere from 20,446.40 - 69,659.20 How can I give each employee a portion on these funds?

For example if:
Lisa makes 20,446.40
Tom - 24,448.20
Liz - 34,854.60
Mike - 44,564.80
Jan - 62,061.48
Dan - 54,324.20

What would be the precentage that I could give each employee?

View 9 Replies View Related

Show Latest Information For Employees

Mar 27, 2008

I have an excel file with 2 tabs. tab 1: Active and Tab2: tenure. Tabe 1 has the following column headers
Manager
Employee Name
Dept
Assignment
Original Start Date
End Date
Bill Rate

The Employee names may be repeating in this tab becasue whenever the employee is extended for a new assignment he has a new start date and new end date and new assignemtn and rates....This helps track the historical information about the employees. TAB2: (tenure) also has the following column headers...................

View 4 Replies View Related

Delete Expired Dates From A List Of Employees

Aug 3, 2009

Basically I have a list of employees. This list is simple in that it shows their off time "From:", "Till:". in columns to the left of there name. So in Cell A:A would list all of there names.. In the example sheet I have just a few listed. To the left of their name if "From:" (column B) and then "Till:" (Column C). And this From, Till repeats itself for several columns so that multiple off-times may be made for each employee.

Basically what I want to do is delete any sets of dates that are expired (based on the "Till:" date) and shift the remaining dates over. So in other words, if Sam has a date in there of 8/1/09 to 8/1/09 meaning he is going to be off for just that day, and today's date is 8/2/09, then that "from" and "till" date of 8/1/09 to 8/1/09 would get deleted from his list and the remaining dates (if any) would get shifted to the left.

Hopefully I have provided a good enough explanation of what I am trying to do here.. Please let me know if you have any questions! I have provided an example the reflects my setup (and the setup can be changed if it makes anything easier)

View 9 Replies View Related

Using COUNTIF To Determine # Of Employees Working Each Hour

Oct 1, 2009

I'm using Excel to schedule employees shifts at my restaurant. Column A is their name, Column B is their start time, Column C is their end time. I'd like to be able to count the number of employees working during any given hour of the day to assure I've got enough staffing each hour. I'm thinking it will require a COUNTIF function but I can't figure out how to make it work. I've attached a sample sheet.

View 4 Replies View Related

Converting Hours Worked To Number Of Employees?

Mar 30, 2012

I need to create a formula that assumes 40 hours = 1 FTE (full time employee). As an example if I have a total of 100 hrs I need to know how many employees to hire. So in this case it would be 2.5.

View 1 Replies View Related

Manual Time Clock For My Employees To Punch In And Out

Sep 6, 2005

I currently use a manual time clock for my employees to punch in and out. I then use Excel to tally their times. This is very tedious and error prone.

Is it possible to use Excel as the timeclock itself? I know that the employee can enter the time in a spreadsheet manually. But this also opens the door for error and potential dishonesty.

What I am looking for is, if the employee can punch in and out by doing a keystroke and Excel uses the computer's clock to timestamp.

View 9 Replies View Related

Ranking Error :: Formula To Rank Employees

Feb 12, 2009

I had tried ranking formula to rank employees on some cirteria it was working, but if there is any tie between two employees then the next rank is not displaying for example in Ach Rank : rank 5 is missing because there is tie is between two employees is rank 4. Request your suggestion and help on this for overcoming the issue.

Formula used for ranking : =IF(B2>=75%,RANK(B2,$B$2:$B$41,1)-COUNTIF($B$2:$B$41,"

View 9 Replies View Related

Record Employees Sick Days & Holidays

Oct 6, 2007

I have a calender with days in the columns and months in the rows. However I have 3 rows for each month. I'm using text and values combinations in the cells to record data

Example First Sheet

Feb Rows, 11,12&13
Columns C,G Dates 1st to 5th

Therefore 1st of Feb has 3 cells to enter data, ie Basic Hours, Sickness, Holiday

Currently I'm defining a name range for each month, ie DFeb. Currently I'm recording each of the rows into columns in another sheet and the date in the row, by using a Hlookup on the date and a vlookup on the month

ie Second Sheet...............

View 5 Replies View Related

Count Of Employees That Worked Within Time-frame

Mar 4, 2008

I am trying to do a timesheet spreadsheets that lists employees clockin and clockout times

Name Start End num hours worked
Cory 02:00 04:00 2
Jack 23:00 05:00 6
Fred 10:00 17:00 7

and then go through the list and and count the number of employees in a certain range.

time range number of employees working
05:00-06:00 1
06:00-07:00 2
07:00-08:00 6
08:00-09:00 5
09:00-10:00
10:00-11:00
11:00-12:00
12:00-13:00..............

View 4 Replies View Related

Macro To Update Sum Of Working Hours For List Of Employees From

Jan 30, 2013

Need VBA macro to read and sum data from multiple worksheets

The “summary” worksheet contains list of all employees. I need to update the total number of hours for each employee by scanning all worksheets in the workbook as follows:

Once I click on a "update" button, I need to scan all worksheets (I have one worksheet for each week) which contains the total number of hours for employees by week. I need to calculate and add the total number of working hours for each employee then move to the next worksheet and so on ..

Once all worksheets are all scanned, the final total of working hours get posted in front of the employee name in the assigned field.. I need to do this for all employees. I also need a macro to create a new worksheet.. I attached an example with little description inside .. Labor Detail Job to Date-2.xlsx

View 5 Replies View Related

Salary Bracket Returns Employees Corresponding Contribution For Health

Jun 17, 2013

I have this table which has employees names with basic pay and contribution.

I was tasked to create a excel sheet where in if the employees basic pay is input, the corresponding contribution for the employee will show depending on which salary bracket he/she is on.

I am not allowed to know what my workmates salaries are since im just an associate, so i just have to leave em blank and wait for my manager to input their salary.

See attached file for the workbook : PHEALTHWORKBOOK.xlsx‎

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved