Find Jobs
Hire Freelancers

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.
รหัสโปรเจกต์: 16470119

เกี่ยวกับโปรเจกต์

88 ข้อเสนอ
โปรเจกต์ระยะไกล
ใช้งานอยู่ 6 ปีที่ผ่านมา

กำลังมองหาการสร้างรายได้ใช่ไหม?

ประโยชน์ของการประมูลกับ Freelancer

กำหนดงบประมาณและกรอบเวลาของคุณ
รับเงินจากการงานของคุณ
อธิบายข้อเสนอของคุณในภาพรวม
ลงทะเบียนและเสนอราคาฟรี
หมอบหมายให้:
รูปอวาตาร์ของผู้ใช้
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
8.9
88 freelancers are bidding on average £356 GBP for this 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 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
8.4
รูปอวาตาร์ของผู้ใช้
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
7.9
รูปอวาตาร์ของผู้ใช้
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
7.8
รูปอวาตาร์ของผู้ใช้
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
7.8
รูปอวาตาร์ของผู้ใช้
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
7.5
รูปอวาตาร์ของผู้ใช้
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
7.2
รูปอวาตาร์ของผู้ใช้
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
7.2
รูปอวาตาร์ของผู้ใช้
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
6.9
รูปอวาตาร์ของผู้ใช้
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
6.7
รูปอวาตาร์ของผู้ใช้
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
6.7
รูปอวาตาร์ของผู้ใช้
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
6.7
รูปอวาตาร์ของผู้ใช้
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
7.0
รูปอวาตาร์ของผู้ใช้
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
7.2
รูปอวาตาร์ของผู้ใช้
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
6.1
รูปอวาตาร์ของผู้ใช้
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
6.2
รูปอวาตาร์ของผู้ใช้
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
6.0
รูปอวาตาร์ของผู้ใช้
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
6.2
รูปอวาตาร์ของผู้ใช้
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
6.1
รูปอวาตาร์ของผู้ใช้
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
5.2
รูปอวาตาร์ของผู้ใช้
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 วัน
4.9 (23 รีวิว)
5.5
5.5

เกี่ยวกับลูกค้า

ปักธงของ UNITED KINGDOM
London, United Kingdom
5.0
1
ยืนยันวิธีการชำระเงินแล้ว
เป็นสมาชิกตั้งแต่ ก.พ. 13, 2017

การยืนยันลูกค้า

ขอบคุณ! เราได้ส่งลิงก์สำหรับเครดิตฟรีให้คุณทางอีเมลแล้ว
เกิดข้อผิดพลาดขณะส่งอีเมลของคุณ กรุณาลองอีกครั้ง
โลโก้ Freelancer Thailand / ภาษาไทย ช่วยเหลือและสนับสนุน FreelancerประเภทโปรเจคการประกวดFreelancerองค์กรแพ็กเกจสมาชิกโครงการ Freelancer ชั้นแนวหน้าการจัดการโปรเจคงานในพื้นที่Photo Anywhereหน้าจัดแสดงผลงานAPI สำหรับนักพัฒนาได้รับการยืนยันDesktop App เกี่ยวกับเกี่ยวกับเราวิธีใช้งานความปลอดภัยนักลงทุนแผนผังเว็บไซต์เรื่องราวข่าวออกสื่อทีมรางวัลข่าวประชาสัมพันธ์ร่วมงานกับเรา ข้อกำหนดนโยบายความเป็นส่วนตัวข้อกำหนดและเงื่อนไขนโยบายลิขสิทธิ์ข้อพึงปฏิบัติค่าธรรมเนียมและค่าบริการหุ้นส่วนEscrow.comLoadshiftWarrior Forum แอปโลโก้ Apple App Store โลโก้ Google Play
ไม่สามารถคัดลอกไปยังคลิปบอร์ดได้ โปรดลองอีกครั้งหลังปรับเปลี่ยนการอนุญาต
คัดลอกไปยังคลิปบอร์ดแล้ว
ผู้ใช้ที่ลงทะเบียน งานที่มีการโพสต์ทั้งหมด
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
กำลังโหลดตัวอย่าง
ได้รับอนุญาตสำหรับตำแหน่งทางภูมิศาสตร์
เซสชั่นการเข้าสู่ระบบของคุณหมดอายุและคุณได้ออกจากระบบแล้ว กรุณาเข้าสู่ระบบอีกครั้ง