Færdiggjort

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:

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 Flere

£300 GBP in 2 dage
(629 bedømmelser)
8.3

106 freelancere byder i gennemsnit £364 på dette 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 Flere

£350 GBP in 10 dage
(296 bedømmelser)
7.7
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 dage
(256 bedømmelser)
7.4
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 Flere

£555 GBP in 10 dage
(102 bedømmelser)
7.5
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 Flere

£250 GBP in 4 dage
(418 bedømmelser)
7.4
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 Flere

£263 GBP in 10 dage
(63 bedømmelser)
7.1
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 Flere

£250 GBP in 5 dage
(167 bedømmelser)
7.0
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 Flere

£250 GBP på 1 dag
(186 bedømmelser)
6.7
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 Flere

£250 GBP in 5 dage
(106 bedømmelser)
6.9
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 Flere

£250 GBP in 2 dage
(101 bedømmelser)
7.0
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 dage
(64 bedømmelser)
6.4
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 Flere

£250 GBP in 5 dage
(85 bedømmelser)
6.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 dage
(115 bedømmelser)
6.5
Piao217

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

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

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)
5.4
younus15

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

£250 GBP in 5 dage
(23 bedømmelser)
5.5
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 Flere

£555 GBP in 10 dage
(31 bedømmelser)
5.8
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, Flere

£335 GBP in 2 dage
(24 bedømmelser)
5.1
£250 GBP in 10 dage
(21 bedømmelser)
4.9