employees

I think I've over stretched myself with this one: I've created training matrix for a maintenance company with 300+ employees. I've figured out a formula to return In date, upcoming (90 days), and expired courses for al employees...

Hi Guys I am creating a master spreadsheet and need some formula help. I am trying to pull through names of employees based on if they have a value against a project For example A,B,C are three projects on three seperate tabs. Person D,E,F are employees. Person D and F have logged time...

Good evening friends, I am looking to build a digital version of the ancient manual logbooks currently used to track personnel entering/exiting our facility. I currently have badges with barcodes and scanners that capture personal information (Name, employee ID number, department), and use a...

Hello, I am new to Pivot Tables, so my question could be very stupid... I have a set of data which shows employees labor forecasts for the upcoming year. The data is divided as such: Employee Name; Project Code; [12 Monthly forecast columns (apr-mar)] Each Employee can be assigned to multiple...

I asked something similar to this a couple of months ago but I have a better idea of what I need. I have sheet that documents our companies new employees that receive a monthly draw (normally 5,000 USD for 3 months). My heard row includes a date column with the end of each month for a year...

I have racked my brain with a solution for this problem and can never seem to crack it. I have to calculate Cost Per Head (CPH) for several different slices of a data set consisting of >500k rows. This is simplified, but suppose my data has a column for Month, Team, State, Account, Account Type...

assuming there is a team of 3 employees named a, b and c who have to be assigned a task as shown below. They have to be assigned task in the same sequence as it comes. i.e. First task to a, second to b and third to c (the last person), when the fourth file comes it has to be assigned again to...

:confused: Hello, I'm not familiar with writing VBA code and I want to know if anyone can assist me with writing a code that will automatically add "Yes" to a cell if an employee's name is listed on another worksheet within the same workbook. I have a worksheet (Sheet 1) that lists all...

Hello. I'm looking for suggestions on how I would go about modernizing this. In short, I have a table that lists employees and splits their allocations across multiple programs. It is in its own workbook, and I currently link several workbooks to it. Picture this table with many more...

I have a quandry. I am trying to create a drop down list or similar to show me All employees and the single task they "HAVE NOT" been trained on yet. I have 52 employees and 20 tasks they need to be trained on. I know I can create a table and add a filter to show ALL employees that have not yet...

I am creating a spreadsheet to track a monthly absent rate between 5 different teams. Employee numbers range from 35-17 and average monthly work days range from 14-19 per team. I take the number of employees and multiply it by the number of days that the team is scheduled to work. I take the...

I currently have an excel workbook and sheet that allows me to use simple functions like (If(ISNA(VLOOKUP)) where I only have to enter an employees' badge # and the rest of their information populates to the right of their badge # (to include the time of the inputted badge #, meaning the time...

Hoping someone can help me with calculating the number of employees working during 15 minute time periods over 24 hours for a 7 day period. Currently I can calculate the number of employees working using the following formula: =COUNTIFS('Perm Sched Format'!I:I,"<="&A4,'Perm Sched...

Afternoon, I am struggling with finding a formula that enables me to ascertain the number of employees present on any given date. The employees sign in and out multiple times a day so I need the formula that ignores the multiple signing in and out process and just returns the sum of...

I'm trying to automate the proces of making weekly work schedules for my employees. What I would like to achive is: input the names and number of hours each employee has to work in a week Set up rules, so that I have one person meeting at 6:30 where we open, one at 7 o'clock. Have one...

Hi Guys, I have the following times of duty for our employees. What I would like to do is count the maximum number of employees that will be on site during the day. Can someone please help me? There are different employee number for different days. Data below shows 4 of the days. The actual...

Hi everyone, Here i am trying to create a pivot table from where i have a table named "Live Employees" and from that table i am trying to create a pivot table where i would not be knowing the range of that sheet.I have tried this code but its throwing me some error , can anyone help me out with...

Is there a way to automatically turn a table into a connection based upon the value of a cell? Let me explain. Let's say I have a table called "Employees", i would want to be able to type "employees" into cell A1, run this code, and it would recognize that based upon what I typed into cell A1...

Afternoon! I've been working on a visual calendar recently and have ran into a roadblock. Basically I've got a spreadsheet where column B has names of employees and columns C/AG are in a table format showing a calendar. I'm using a formula in conditional formatting to display days that employee...

I created a Pivot Table. Table serves two purposes: 1. To list employees (by pay grade) who have completed X, Y, and Z training courses 2. To list employees (by pay grade) who have not completed X, Y, and Z training courses To do this, I merged two Excel worksheets. Worksheet 1 contains a list...