Productivity Calculator (Excel Macro)


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.

Evner: Excel, Databehandling, Forretnings Analyse, Visual Basic, Dataindførsel

Se mere: excel macro fill empty cells, excel macro data cell, excel macro export xml, data net web application excel macro, btu calculator excel, excel macro expert india, excel macro load web site, install analysis toolpak automatically excel macro, excel macro convert weight, excel macro format phone numbers, excel macro copying cell content, compare tables using excel macro, excel macro open files, excel macro move data existing cell, excel macro copy data column

Om arbejdsgiveren:
( 0 bedømmelser ) Bengaluru, India

Projekt ID: #20292274

Tildelt til:


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.

₹3333 INR på 1 dag
(102 bedømmelser)

18 freelancere byder i gennemsnit ₹7311 på dette job


Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel macro to calculate the performance of your employees. I plan to use a co Flere

₹8000 INR in 5 dage
(212 bedømmelser)

Hi, I am an expert and guru in Financial, Math and Excel/VBA/Macro. especially with importing databases to a structured database in Excel and vice versa (+ automation with VBA). I have extensive knowledge and expertise Flere

₹12500 INR in 7 dage
(87 bedømmelser)

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]

₹10000 INR in 2 dage
(110 bedømmelser)

Hi, I am an excel VBA wiz and can pretty much do anything. I went through your project description and the SAP file attached. What you want is a straightforward job and can be executed successfully. Hope to chat with Flere

₹7500 INR in 2 dage
(53 bedømmelser)

Hello. I can do your project perfectly. I have got 8 years of rich experience in VBA. I can do VBA programming as fast as you want. I am Data Processing, Excel VBA Expert who knows the value of time, very hard workin Flere

₹10000 INR in 7 dage
(10 bedømmelser)

Hi . I am a VBA developer with over 10 years experience of building complex macro and/or formulas. Your project can be accomplished as simple as using the subtotal command plus a little bit macros for the data preparat Flere

₹3000 INR på 1 dag
(1 bedømmelse)

INR 1500 ONLY !!!!! [EXCEL VBA EXPERT] Sir, Please contact me before closing the project, I can send you DRAFT project file to ensure my expertise. If you are 100% satisfied first, then award me the project. I have e Flere

₹1500 INR på 1 dag
(6 bedømmelser)

Hi, I hvae more than 3 years experience in developing Macros, if you given this opportunity will finish as soon as possible.

₹8500 INR in 3 dage
(0 bedømmelser)

I was very much eager to do this work and I will do it upto your satisfactory level

₹8888 INR in 3 dage
(0 bedømmelser)
₹7777 INR in 3 dage
(0 bedømmelser)

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

₹12222 INR in 10 dage
(0 bedømmelser)

I worked with macros since college and I have 2 years of experience using it with different clients mostly banks.

₹7000 INR in 7 dage
(0 bedømmelser)

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.

₹3333 INR in 2 dage
(0 bedømmelser)
₹7777 INR in 3 dage
(0 bedømmelser)

i will do it for you in just few hours . if i talk wbout my company then we are a full stack development solution team. My Team, having capability to deal with almost every technologies like Android,IOS,angular,nod Flere

₹8888 INR på 1 dag
(0 bedømmelser)

I can provide a preview of the working macros (in a video) in 3 hours. An you can decide at that time. The job will be done by 8hrs from now.

₹9888 INR på 1 dag
(0 bedømmelser)

I'm the best person in our company to help do work formulas in excel and google spreadsheet to lessen the works and to finished the needs of our customer and employer. And I believe that I can also help you with this p Flere

₹1500 INR in 7 dage
(0 bedømmelser)