Excel data count project

Completed Posted 6 years ago Paid on delivery
Completed Paid on delivery

We would like to understand how many delivered and failed entries occurred after a specific point on a per customer basis.

The data consists of three columns. Column A is the customer who has several rows associated with them. Column B indicates if the entry is delivered or failed. Column C indicates the date and time of each entry which is sorted by oldest to newest.

For each customer we would like to determine after 10 failed entries in succession how many delivered entries occurred and how many failed entries occurred. We would like this repeated for 20 failed entries and 30 failed entries in succession.

For example Customer A has 12 rows of failed entries, then 18 rows of delivered entries, then 4 rows of failed entries, then 3 rows of delivered entries. The result would be Customer A has 21 delivered entries and 4 failed entries. If applying the 20 failed message search Customer A would not be counted.

In summary we would like to know the total number of customers, total number of failed entries, and total number of successful entries for the 3 searches (10 failed entries, 20 failed entries, and 30 failed entries.

An example of the data is attached. There are 6 spreadsheets sharing approx. 3m entries.

C++ Programming Data Entry Data Processing Excel Visual Basic

Project ID: #16470119

About the project

88 proposals Remote project Active 5 years ago

Awarded to:

jaylancer43

Hello Sir, My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community (https://www.freelancer.com/community/articles/jay-patkar-freelance More

£300 GBP in 2 days
(843 Reviews)
8.9

88 freelancers are bidding on average £356 for this job

schoudhary1553

Hi there..... Warm Greetings We came along with your request for Excel data count project and we reviewed your project description. We'd like to help you with confidence and satisfying results... We have profe More

£350 GBP in 10 days
(492 Reviews)
8.4
bouslimi1979

Hi, I ll code an Excel VBA macro where you will select the input file to be treated and the macro will load the data and make the calculations you mentionned and generate a report. Ready to start. Thanks

£250 GBP in 2 days
(333 Reviews)
7.9
SBITServices

Hello , I have read your project description, checked the file and understood your requirement clearly. I am an excel Expert VBA Expert. I can count the data automatically by developing a program in Visual basic.I can More

£250 GBP in 4 days
(528 Reviews)
7.8
zekovicm

Hi there,I am Miljan,Excel expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within the ag More

£250 GBP in 2 days
(183 Reviews)
7.8
super2lao

Hi, Dear Employer! How are you? I am really interested in your project. I have enough experience on python, C/C++, C#, java programming. I am 100% sure i can satisfy your requirements perfectly. User-Friendly Int More

£555 GBP in 10 days
(102 Reviews)
7.5
zebracaro

I can do it for you quickly and exactly . I have finished great than 90 VBA project in this site. Please contact me for saving your time

£300 GBP in 4 days
(133 Reviews)
7.2
aarifakhtar

Hi: I have reviewed the project details and understand that you a script that can count the number of times an event occurs. The event will be X failed entries in succession. The value of X will be variable and will be More

£250 GBP in 5 days
(182 Reviews)
7.2
samitXI

Hi Sir, I am ready to work for you.I have experience in C/C++, python , java, PHP and, MySQL. please see some of my works also check my reviews you will get better idea about my skill.I deliver quality work within tim More

£250 GBP in 5 days
(106 Reviews)
6.9
octopus823

How are you? I have much experiences in handling excel with C++. I am interested in your project. Let's contact and discuss with each other. Thanks.

£500 GBP in 10 days
(77 Reviews)
6.7
priyal1997

Dear Sir/Madam, I red your project description and went though the sample file, and would like to say that I can do this task perfectly for you. You may refer my profile to see more details about me and my reliabilit More

£250 GBP in 1 day
(194 Reviews)
6.7
khudammunir

Hi I would like to bid for this project. I posses Data Analytics, Research, Accountancy, Administration, Banking, Financial/Business Analysis & Reporting and Content Writing experience with Advance MS Excel Dashboards, More

£335 GBP in 2 days
(37 Reviews)
6.7
hbxfnzwpf

I am very proficient in c and c++. I have 16 years c++ developing experience now, and have worked for more than 6 years. My work is online game developing, and mainly focus on client side, using c++ under windows envir More

£250 GBP in 5 days
(144 Reviews)
7.0
fabest

Dear, we are Team of French + US. I checked your project description, and I confirm I can develop your program. I will focus on user friendly interface. As you can see I have very good rate, you can be sure I am ser More

£263 GBP in 10 days
(66 Reviews)
7.2
pm9887

Hi There, I am good in excel related task. I can do this let's chat more and discuss about the project. Best REgards, Prakash

£250 GBP in 10 days
(78 Reviews)
6.1
vladishat

I'm experienced in Data Mining and analysis, and I can do your task in minimal time and price. To answer the question you asked the data must be grouped by customers, failed and delivered values of the data set attrib More

£250 GBP in 2 days
(83 Reviews)
6.2
supper5guy

Hello there, after reading your project description and with a drive for excellence, with a keen attention to details and with more than 10 years experience working with Microsoft office especially excel vba, i can do More

£250 GBP in 10 days
(89 Reviews)
6.0
archanaoswal

I have excellent command on MS Excel. I have understood your requirement and achieve the result for the customers and failed entries as mentioned. I have completed complex projects in Excel before . For instance - More

£250 GBP in 3 days
(95 Reviews)
6.2
zu02

Hi, there I hope all's well with you. I see you'r looking for a developer proficient in Ms Excel/VB. Really all my projects here I've developed for Ms Access/Excel/VB projects. I'll do your current Ms Excel More

£555 GBP in 10 days
(39 Reviews)
6.1
luiswilliam

hello, I read your project description, and I understand it. I can complete your Excel project perfectly. Let's chat with me now. Best Regards

£298 GBP in 2 days
(12 Reviews)
5.2
ReflexiveData

Hi, Thanks for posting your requirement. I think I am the best person to do this job. Checked attached file and I think I can handle it pretty easily. I have an extensive knowledge of data processing, visual More

£250 GBP in 5 days
(23 Reviews)
5.5