Excel data count project

£250-750 GBP

완료함

게시됨

약 6년 전

£250-750 GBP

제출할때 지불됩니다

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.

프로젝트 ID: 16470119

프로젝트 정보

88 제안서

원격근무 프로젝트

활동 중 6년 전

돈을 좀 벌 생각이십니까?

이메일 주소

프리랜서 입찰의 이점

예산 및 기간 설정

작업 결과에 대한 급여 수급

제안의 개요를 자세히 쓰세요

무료로 프로젝트에 신청하고 입찰할 수 있습니다

프로젝트를 수여된 사용자:

@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-freelancer-success-story). About Me - I am an Engineering Graduate with an MBA degree. If you see I have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required in advance, please pay me once the job is 100% complete. Thanks, Jay

£300 GBP 2일에

5.0

(843 건의 리뷰)

8.9

88 이 프로젝트에 프리랜서들의 평균 입찰은 £356 GBP입니다.

@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 professionals working here with 100% results and more creative and renovative ideas for our clients ! We have worked on several similar projects before! We are offering our services for more than 5 years in the field of C++ Programming, Data Entry, Data Processing, Excel, Visual Basic We have worked on 300+ Projects. Please check the profile reviews Feel free to message us to discuss briefly about your project !

£350 GBP 10일에

4.9

(492 건의 리뷰)

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 2일에

4.9

(333 건의 리뷰)

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 complete task within time with 100% accuracy. I am very responsible towards our clients. I know my client needs and importance. Skills : Excel, Macros,VBA, PHP,Python,Web scraping, Data entry, Copy typing With Regards, Bhaskar.

£250 GBP 4일에

4.9

(528 건의 리뷰)

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 agreed deadline. Check out my profile, portfolio, and former clients feedback - that'll let you know everything about me. There is a lot of experience behind me, so it will be a huge satisfaction for me to do this job. Please feel free to contact me so we can discuss further details. Thank you for taking the time to read my proposal.I am looking forward to hearing from you. Kind regards

£250 GBP 2일에

4.9

(183 건의 리뷰)

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 Interface And Clear Algorithm Will Encourage Your Project. I want a long term relationship with you. Thank you and best regards!

£555 GBP 10일에

4.9

(102 건의 리뷰)

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 4일에

4.9

(133 건의 리뷰)

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 provided by the user of the script. The script needs to take the input X and count the number of customers for whom there are consecutive X failed entries. Please confirm if my understanding is aligned with your requirements. I would suggest a Python program which will take the input in Excel format and also deliver the output in Excel format. The program will be able to handle large amounts of data as Python has modern libraries for this purpose. Regarding my experience, I have more than 5 years of experience in automating tasks through Python and have completed more than 100 projects. Please connect with me to discuss your requirements in more detail.

£250 GBP 5일에

4.9

(182 건의 리뷰)

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 time frame. Please visit my profile once. Thanks with regards, Amit

£250 GBP 5일에

4.9

(106 건의 리뷰)

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 10일에

4.9

(77 건의 리뷰)

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 reliability, and if all good with you, we can discuss the task. I look forward to hearing from you Best regards Priyal

£250 GBP 1일에

5.0

(194 건의 리뷰)

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, Power BI & Microstrategy Dashboards, MS & Google Office Suites, WordPress, Social Media Marketing and Touch Typing 60wpm Skills.

£335 GBP 2일에

5.0

(37 건의 리뷰)

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 environment. I used c++ to make many great projects, for example, I made the tools which can convert java files into c++ scripts, of course garbage collection included, this job is very similar to a compiler, and is very complex. I also made our own mobile game using c++, I can show you the demo of client, if you like. I am very proficient in java also. I have a very good review on Freelancer.com, I never miss a project once I accept the job, you can check my review. Trust me, please let expert help you.

£250 GBP 5일에

4.9

(144 건의 리뷰)

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 serious. Regards, Fabrice

£263 GBP 10일에

4.7

(66 건의 리뷰)

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 10일에

4.9

(78 건의 리뷰)

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 attributes. It can be done in Excel, or R, or RapidMiner, or any appropriate framework.

£250 GBP 2일에

5.0

(83 건의 리뷰)

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 the best excel counting job in the least time starting right now. I will do all and extra to ensure that you won't regret giving me this project. Please, message me and let us discuss more about your project. Thanks

£250 GBP 10일에

5.0

(89 건의 리뷰)

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 - Get match details, odds and stats of tennis matches and place bet automatically on betfair, pinnacle and tennisinsight websites - Built a POS and inventory management system - Built a hotel price comparison that pulls data using the website's API - Built a complex shift allowance calendar and calculator You can see the reviews of the same in my profile

£250 GBP 3일에

4.9

(95 건의 리뷰)

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 macro enabled project very professionally and on time. Here is my introduction: I’m a ms Access/Excel/VB programmer, a mathematician and a full time developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Access, Ms Excel, VBA, ADO, SQL , including projects for start-up companies and small businesses. For over the last 20 years I’ve worked in a variety of industries. I have a deep passion for coding and guarantee that all of developing is 100% original. I highly value professionalism and hold myself strictly accountable to represent my client’s brand. I aim to form a long-term working relationship. Please, let me know what is needed to secure this bid! Thank you for your consideration. Zura

£555 GBP 10일에

4.8

(39 건의 리뷰)

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 2일에

5.0

(12 건의 리뷰)

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, visualization, reporting and analysis using excel, VBA, macros and other technologies like Power BI. Please check our portfolio for works completed in past. I have understood your requirement and can surely assist you with this development. Let's connect to discuss in detail. Regards, Pranshu Agarwal

£250 GBP 5일에