Calculate efficiency

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I have excel sheet with 4 columns, User Name, Manufacturing Item, Quantity and Time taken to manufacture that particular item.

I have the data for all users.

Now I wanted to calculate total time taken for each group (i.e Manufacturing items) and total quantity of each groups.

Then I wanted to calcualte the efficiency. i.e how efficient a user with another user.

Formula is: efficiency = Total time taken / particular user time taken.

Please find the path

http://www.editgrid.com/user/shaan86/Shaan

I have checked the recent post from "Rahul", for me total is not working.

Please Assist

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
I must be missing some thing here. You already have formula for summing each group. So what is the issue ?
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
so you want data to be sorted into groups via macro and add the formulas for each group?. The reason I am confused is that you already have groups made out. So when you have the group created, you add formula at the same time. as you insert or delete the rows inside a group, the formula will get adjusted on its own
but the output I mentioned in the link that I created using macro. so I wanted to add this part to that macro code. So I wanted add formulas using macro...
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Since you seem to have a macro too, could you please upload a sample EXCEL file WITH sample data, MACRO, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , etc and post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too
hi

Please check the below link

http://www.editgrid.com/user/shaan86/Sample1

Sheet 1 is input that I am getting from macro and sheet2 is the output that I am expecting.

Please assist
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
I thought you said you already have a macro to group the data. Could you post the book with the macro.