I am Sneha, working for Decathlon presently. I am managing the E commerce aspect within logistics for Decathlon customers. Which requires that the orders that are placed online are sent to the customers within the fulfillment promise that has been made.
One aspect to ensure that the promise to customers is met is by making sure that all our teammates achieve their productivity for the basic activity of picking and packaging on a daily basis. My requirement is for the same.
1. To create an excel macro to calculate the productivity for each teammate.
2. Data will be in the format of an SAP extract which will have all the basic information for calculating productivity.
3. Productivity is calculated as follows:
Productivity = Quatities (Picked/Packed)/Hours spent on the activity
4. Since each activity is not continuous, the start time and end time of an activity will have to be looked at manually. This is the challenge I want to overcome by the use of a macro function.
5. A macro that can for each teammate find out the start and end time and convert that into hours.
For ex: If Teammate A has picked 100 qtys from 8:00 to 10:00, Then 200 qtys from 11:00 to 12:30 and 50 qtys from 2:00 to 2:30. I would require for the macro to tell me that A has picked 350 qtys in 4 hours. Then the productivity can be easily calculated as 350/4 = 87.5. An extract of the picked qtys is attached. The macro should be enabled to work on such files.
Hello there, I am an Excel expert and this caculation is quite basic. We can do it in 2 hours. Please contact and share me sample SAP data. I will create the file for you. Thank you.
18 freelancere byder i gennemsnit ₹7311 på dette job
I am an Excel and VBA specialist with a lot of experience in creating complex formulas and macros. You may check some of my projects here: [login to view URL]
I have experience in this field I can start from right now . Please share more details . You can initiate a talk with me to let me understand more about your project. Regards ..... Priyanka
I've vast experience (10+ yrs) in excel marcos. I can do this project for you and provide couple more value additions as well (after looking at your raw data). We can initiate the talk and take this forward.