Excel data count project

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.

Evner: C++ Programmering, Dataindførsel, Databehandling, Excel, Visual Basic

Se mere: excel data mining project, excel inventory count project plan, excel data entry count, how to calculate percent complete for a project in excel, calculate percent complete in excel, percentage complete formula in excel, calculate percentage of task completion in excel, how do you figure out completion percentage?, excel percentage complete based on dates, excel percentage complete bar, excel countif, java, data processing, sql, excel, visual basic, c++ programming, statistics, statistical analysis, visual basic for apps

Om arbejdsgiveren:
( 1 bedømmelse ) London, United Kingdom

Projekt ID: #16470119

Tildelt til:


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 Flere

£300 GBP in 2 dage
(636 bedømmelser)

105 freelancere byder i gennemsnit £364 på dette job


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 Flere

£350 GBP in 10 dage
(299 bedømmelser)

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 dage
(263 bedømmelser)

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 Flere

£555 GBP in 10 dage
(102 bedømmelser)

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 Flere

£250 GBP in 4 dage
(424 bedømmelser)

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 Flere

£250 GBP in 5 dage
(167 bedømmelser)

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 Flere

£250 GBP in 5 dage
(106 bedømmelser)

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 Flere

£250 GBP in 2 dage
(103 bedømmelser)

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 Flere

£250 GBP på 1 dag
(187 bedømmelser)

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 Flere

£263 GBP in 10 dage
(63 bedømmelser)

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 dage
(115 bedømmelser)

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 dage
(66 bedømmelser)

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 Flere

£250 GBP in 5 dage
(85 bedømmelser)

Hi, I am a boss of a very skilled developers' team. I read ur post with interest and we can handle it. My team has developed many Windows desktop applications in various fields including Office Automation. Especial Flere

£250 GBP in 10 dage
(48 bedømmelser)

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

£250 GBP in 3 dage
(76 bedømmelser)

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 Flere

£250 GBP in 5 dage
(23 bedømmelser)

Hello. I checked your Excel file and read your [login to view URL] need a perfect dashboard for track your results by data in columns A, B and C, I can do your project in less than 3 days according to your description w Flere

£400 GBP in 3 dage
(90 bedømmelser)

hello,how are you. i read your bid carefully. i am c/c++, vba expert and have full experience for 10 years. c/c++, vba language is my top skill. i can provide most quality and high speed. if you want to success, pl Flere

£800 GBP in 10 dage
(4 bedømmelser)

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 Flere

£555 GBP in 10 dage
(31 bedømmelser)

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 Flere

£250 GBP in 10 dage
(71 bedømmelser)

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 dage
(41 bedømmelser)