Search results

Hui/Faseeh, can I make a pivot table to see people required per widget vs. cumulative?

Hui - Thank you very much for your help - I believe it will work. Faseeh - Thanks for the offer, and no worries on late reply. I will post followup as soon as I update the data.

Hi Faseeh, Thanks for sharing your file. Here is the basic information for my file, I made some comments within same. I hope I have explained sufficiently and that you can assist me. https://docs.google.com/open?id=0B5Vr4r9QZCxgSm9kd1loSVozVzg Thank you.

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...

Thanks Narayan, I am on my own, only one in my area with more than basic excel.

I am not familiar with macros, so I am not sure how to copy/paste into my workbook.

Hi Narayan, I am attempting to locate the two files, can you upload again? Thanks.

Asa, you were correct about the value. Thanks to all.

Hi Hui, I know this is supposed to be very simple but I am having a little difficulty with this. I have selected the range,applied your instructions,chose format in lieu of set Yellow. all that fall below 24 highlights but cell with 24 does not.

Thanks, Asa. Narayan, I was able to open but did not find the instructions in the Summary Report. The links are lost.

Narayan, I could not open summary file, error message file not found.

Thanks Narayan.

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.

Any help is greatly appreciated. Thank you.

Hi, 1. can you direct me to macro examples that will help me achieve the summary sheet? I can probably follow that. Okay for the naming convention. 2. The file imports as you see in the example, except where I have added the total and average cells. I am not sure if I can avoid the zero...

Here is test file I am working with. I know you asked for an original as imported but I do not have at the moment. I have 2 single days [I do plan to run bi-weekly],in each, I have inserted column E - "Hours" this is inserted manually. I have added columns J & K. I know you asked for an...

As data is added for the designated period, can I use =COUNTIFS(range, user name) on summary sheet to pull and total each users?

NARAYANK991, any other suggestions?

Sorry if my statement is confusing. My thought is that as the data is obtained weekly or biweekly, the update for the respective user will "flow" into the matching user cell. I will have consider if a user should is added or deleted.

That is true, the exported data does not contain hours worked and that will be a manual input.

1. I renamed the users to remove identifying info, so I did a copy/drag. I think because of the drill down it renamed all 177 rows in lieu of the top layer. I uploaded new file ABC_Svc.xls http://www.2shared.com/document/Rp1BIMqO/ABC_Svc.html

Thank you for responding 1.There are actually 30 "live" users, the user names beyond that are I believe due to the drill down to the each day's productivity. So the number that you are looking at is the week's total and if you click on the +, you will find the numbers making up those numbers...

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...

Asa, thank you this was very informative and helpful.