Search results

Hello Everyone, I would appreciate your comments or directions .. a template or how to setup the following: I need to implement and maintain optimal workflow where production employees are required to 1) meet a minimum daily output e.g 200 widgets; 2) complete assembly within 2-3 days of them...

I am trying to set a rule that if range values are 0 to 24 the cells should turn yellow, if >=25 green. I have one cell with a value of 24 and another with a value of 25, these did not change but remain white, no fill. What step have I missed? Thank you.

I have a new report that is imported into Excel. It provides the week's productivity with a drill down to each user's daily activity. I hope to achieve the following, but I am unsure of approach: Create a monthly master > import weekly updates that will automatically update each user's...

I would appreciate suggestions that can produce summary numbers with out a lot of cut/pasting. I have Daily Productivity for 30 employees and need to extrapolate for each employee: 1) # of type a transaction, 2) # of type b transactions, 3) diff between start and finish. Data is exported in...

My spreadsheet involves calculating when evaluations are due; from hire date or promotion = Start/Promotion, +45 days, +90 days, +180, annual. Some of the evaluations way overdue. In some instances, I may only have the hire date, which could be 9/2/08, I don't want the result to show "False"...

Hello, I would like to create a file that will calculate when employee evaluations are due and to have an "alert" when one is due or past due. Process is from hire date or promotion date, there is a 45day, then 90day, then 180days, and annual Is there a formula in excel that help automate...