productivity

Hi All, Is there a way to "store" somehow formulas in excel and use them in different workbooks? I have some formulas i need to use frequenty. Some easy and some complicated ones. Is there any solution so that i do not have to rewrite them every time or do not need to open up a previous...

For my work my productivity is tracked and recorded, however the database software our company uses is garbage and I have an excel spreadsheet that I prefer to use. So what I track is: Encounter # If it is a NB (NewBorn), Y for yes, nothing if not The LOS (Length Of Stay), # Depending on...

hi i m working on a factory, we have 12 lines and they have different styles. i do their line balancings with manually. i want to see all possible balances with permutations. There are about between 17-35 workers in each lines. And each model have diffirent quantitiy of operations. i know the...

Hello - I'm totally newbie on Excel VB. i just happened that i have the tool that we use and just editing the code on it. Now, I would like to ask on how can i change the font of my txtBox, if the value of my textBox is 90% or above it will turn it to green, while if 89% below the font would...

Hi there, I am having some issues with the vba formula below and any help would be appreciated. Sub test1() Dim ws As Worksheet Dim copyRng As Range Dim LR As Long, LC As Long Set ws = Worksheets("Sheet1") With ws LR = .Cells.Find("*"...

I am not sure if this would be a place to seek assistance but I thought I would try. I am assisting a team to calculate their productivity percentage (score tied to bonus). Its a little complicated then just regular productivity. The team has 10 days to complete a task. I would like to...

Hello! I have a model of the progression of a work based on different stages, streams, etc which is quite complex. You input the productivity and it outputs the end date based on that productivity. Now I want to do the opposite, ie specify the end date and find the minimum productivity that can...

I'm trying to figure out a way to do the following, and forgive me if I'm posting something entirely too complicated. Sorry for any time wasted. But if you want to help.... Lets assume I have a potential pool of 500 employees. Each employee has a productivity score, and a salary. The total...

Hi All, Kindly help on the below I have excel sheet which update the daily productivity of the different user for different process in a same sheet. What happens is the user update the daily productivity, sometimes they add extra volume or change the productivity details which is in the past...

Hi All, Kindly help on the below I have excel sheet which update the daily productivity of the different user for different process in a same sheet. What happens is the user update the daily productivity, sometimes they add extra volume or change the productivity details which is in the past...

I am building a document that shows a productivity target for almost 200 positions. My data is trailing 12 month actual productivity for each position by week. Currently I have a formula that counts the weeks if they are greater than the current productivity target, divided by the number of...

Hi, Not sure if this is even possible... I've got a simple spreadsheet that monitors staff productivity - tasks have a specific timing and when this is compared to an individuals normal working day it gives a percentage of productivity (ie working day 444 minutes, equivalent time of completed...

I am trying to use the value in a cell, A7, as the data validation range name for another cell. I have created a range called "Category", which is populated with 3 values, "Quality", "Productivity" and "Value". I have also created ranges named "Quality", "Productivity" and "Value". Each of...

I am trying to calculate productivity across multiple therapists, each having their own sheet with their individual productivity being calculated as such: =IF(G61>0,G59/4/G61*100,0) This gives me their productivity for the day assuming their hours worked (G61) is greater than 0. This is...

Hi All, I've used this site for years to search for answers to formula problems I've had and loved it. But now I'm trying to find a formula to calculate a productivity based on 2 different volume metrics and I'm stumped! So the basic productivity calculation we use is ORDERS / HOURS = hourly...

Hi, I have created a pivot line chart which tracks employee daily productivity scores, if there is no value - ie the employee didn't work that day or was not on the rota which would produce a productivity score, then i want the lines to connect to each other rather than dropping to zero. I am...

I am trying to find the average of a data set, then subtracting by singular data point and dividing by same data point. Ideally =average (New Value - Old Value) / Old Value = Percent Change. The data is monthly tallies of orders a team has qualified. I am looking to average the past months, to...

I'm a little stuck on a project. I'm looking to create a sort of hybrid work queue and productivity tracker. I have a list of Employees and the number of evaluations and supervised hours required for each. I've written the start of the VBA for the first agent off the list to be pulled in as...

Hi! This is my first time posting here. I hope someone can help me I have a person that sees walk-in people and also answers calls for a call center. I'm creating a prod report where: person has to see 4 people in 1 hr or answering 12 calls in 1 hour. shift time is 8 hrs., and I need the weekly...

I want to calculate MTTR and Productivity for our employees. my doubt is how to calculate (actual work start date-actual end date) if employee is "Xyz". How many days he spend? Plz help me to calculate