Find Jobs
Hire Freelancers

Excel Data Analysis

$30-250 USD

ที่ทำเสร็จแล้ว
โพสต์ ประมาณ 6 ปีที่ผ่านมา

$30-250 USD

ชำระเงินเมื่อส่งงาน
We are an automotive data company that publishes values for used vehicles. We are currently looking to create an Excel sheet that would allow us to see how many days it has been since the value on a vehicle has changed, what the amount of that last change was, and how many total changes were made for all dates show. I have attached a file that contains a small sample of our data. We expect the actual files we will be using to contain approximately 200k-300k records for approximately 3 or 4 months of price changes. In this sample file, I have sorted by GUID(our unique ID) and date, however the raw file that we use will NOT be sorted like this, not sure if that matters. As you can see on the "Output File" worksheet, we would like to see all GUID's shown just ONCE along with the number of days/amount/total changes in columns M,N,O. The "values" I am referring to are the "Trade" and "GMR" columns(I and J) and it is worth noting that we only need to use the Trade column to monitor the change, since these two values always change together. I believe this is the entire scope of the project so if I have left any details out or you have any questions, please let me know. Thanks!
รหัสโปรเจกต์: 16585228

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

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

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

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

กำหนดงบประมาณและกรอบเวลาของคุณ
รับเงินจากการงานของคุณ
อธิบายข้อเสนอของคุณในภาพรวม
ลงทะเบียนและเสนอราคาฟรี
หมอบหมายให้:
รูปอวาตาร์ของผู้ใช้
Hi!, I'll be happy to do this proyect Felice -------------------------------------------------------------------
$144 USD ใน 3 วัน
5.0 (12 รีวิว)
5.7
5.7
58 ฟรีแลนซ์กำลังเสนอราคาโดยเฉลี่ย $145 USD สำหรับงานนี้
รูปอวาตาร์ของผู้ใช้
Hello, 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
$250 USD ใน 3 วัน
5.0 (745 รีวิว)
8.5
8.5
รูปอวาตาร์ของผู้ใช้
Hi there..... Warm Greetings We came along with your request for Excel Data Analysis 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 Data Entry, Data Mining, 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 !
$200 USD ใน 3 วัน
4.9 (355 รีวิว)
8.0
8.0
รูปอวาตาร์ของผู้ใช้
Hi, my name is Sevinc. I will write a vba script for you which will create the output through your input list, as you need... I am 5-star excel and vba coding expert here at freelancer.com. Pls check my profile and feedbacks first to have some idea about the quality of my previous businesses. I had many similar excel tasks, including automated data extraction, aggregation and reporting, all achieved with 5/5 rating. Kindly get back to me if you wish to proceed with a top-rated and reliable partner here...pls note that I only deliver best quality at a reasonable price, and I am open for longterm partnerships, if you wish too... I bid my best for you to start business, and I am ready to prepare an excel workbook template for you to check & validate, once you give me a reply...regards.
$200 USD ใน 2 วัน
4.9 (343 รีวิว)
8.0
8.0
รูปอวาตาร์ของผู้ใช้
I love excel automation, and have done several projects, to merge, clean, organize, and even summarize sheets. I have seen the attached sample, and understand how you need them merged. Just need you to send me the file with the raw data, and award me the project, I will organize it, the way you want. Hassle free service with ZERO ERROR GUARANTEED!! Please read my 300+ reviews. I am here to impress you with my work.
$150 USD ใน 3 วัน
4.9 (330 รีวิว)
7.6
7.6
รูปอวาตาร์ของผู้ใช้
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$150 USD ใน 5 วัน
4.9 (335 รีวิว)
7.3
7.3
รูปอวาตาร์ของผู้ใช้
Hi, there. My name's Paris Pallas and I'm an experienced Excel developer. You're welcome to visit my portfolio to have a view of my work quality as well as reviews given by my clients. Your brief is very detailed and summarizes what you expect from me in a very accurate manner. My suggestion is to use pivot tables to accomplish your required task and if needed I will use a small piece of code to enhance Excel spreadsheet's functionality. I'd like to hear from you. I'll be waiting for your call. Paris
$140 USD ใน 3 วัน
4.9 (236 รีวิว)
7.4
7.4
รูปอวาตาร์ของผู้ใช้
Greetings! Thanks for very clear requirements. I understand the requirements completely and can do the needful. Being a full time freelancer working exclusively on Excel based projects, I work on developing macros every single day. I have 18 years experience in using Excel as part of my daily work life. Over the last 22 MONTHS , I have spent at least 250 HOURS on automation in Excel every month. If awarded, I can get your work completed to your fullest satisfaction. Have a Great Day! Srinivasan Krishnamoorthi
$80 USD ใน 1 วัน
5.0 (197 รีวิว)
6.9
6.9
รูปอวาตาร์ของผู้ใช้
Hello, My name is Chrys. As you can see from my profile, I have 17+ years experience working with Excel/VBA and 13 years teaching them both (all levels). I can certainly do excellent work with your project. I read carefully your post and everything is clear to me. Please contact me if you want to further discuss the details. Looking forward to hear from you, Kind regards, Chrys
$140 USD ใน 3 วัน
4.9 (81 รีวิว)
6.7
6.7
รูปอวาตาร์ของผู้ใช้
Greetings, I'm ready to work on last change automotive data project. Relevant Skills Excel, VBA Milestones 123 USD - code writing 30 USD - userfriendly interface I can achieve the results that you are asking for.
$154 USD ใน 3 วัน
5.0 (120 รีวิว)
6.6
6.6
รูปอวาตาร์ของผู้ใช้
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 develop the such a sheet that will handle your described requirements 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
$60 USD ใน 3 วัน
5.0 (88 รีวิว)
5.9
5.9
รูปอวาตาร์ของผู้ใช้
- Went through the sample file. - Can track the number of days elapsed since the last value change. - On Button click the Output sheet can be generated... tracking by the trade value. - The functionality can work for the entire sheet. My Skills: - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Extensively the macros/VBA to automate: - Data camparision using formulas, lookups and summaries., - Pl. review my portfolio on recent projects. Sample HighComplex Projects using Macros:(via Freelancer) - Heating Wire Design, Canada, - Identify the wiremodel running through multiple iterations. - System log generation (users logged in time, duration, days) between time period based on the text log files. Generate report. - Employee Tax, Canada - Calculations per hours,wage,provincial deductions, Federal deductions per reference tables. - Stocks Portfolio - Showing client portfolio stocks with various indicators, Momentum indicators based on portfolio. - University, US - Scoring the answer sheets based on keyword and number of occurences.
$80 USD ใน 1 วัน
4.7 (52 รีวิว)
6.0
6.0
รูปอวาตาร์ของผู้ใช้
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.
$150 USD ใน 3 วัน
5.0 (34 รีวิว)
5.7
5.7
รูปอวาตาร์ของผู้ใช้
I have excellent command on MS Excel. 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
$200 USD ใน 3 วัน
4.8 (92 รีวิว)
6.0
6.0
รูปอวาตาร์ของผู้ใช้
HI, I have excellent experience in Microsoft technologies especially VB Scripting. I have wrtitten complex macros like extracting BoM from an ErP for a manufacturing Company I have worked in Infosys a top IT services company for more than 10 years and now i have started on my own. As part of my infosys tenure i have been working with Microsoft as customer delivering projects in MS technologies. Will be able to leverage this experience to deliver this project successfully. Thanks Regards Vaidy
$111 USD ใน 2 วัน
5.0 (15 รีวิว)
5.3
5.3
รูปอวาตาร์ของผู้ใช้
Hello, I have checked the file and with formulas in the spreadsheet, it is quite clear for me what needs to be done. I will easily handle large amounts of data, as I specialize in optimizing macro performance. I'm not sure only whether the data structure will be as in this sample example within 1 worksheet or it will be a separate data file and separate macro file. Is operating system Windows? I can finish this project on a short notice. Best Regards
$65 USD ใน 2 วัน
5.0 (64 รีวิว)
5.3
5.3
รูปอวาตาร์ของผู้ใช้
Hi - I am a excel whiz and too good in macros too. For the problem statement you have given we need to br able to consume data, transform and then report. We would need a combination of power query, formulad and macros to get this achieved. I just completed something similar but bit more feature rich to another customer of mine. If you can confirm i can get started immediately. Let me know.
$120 USD ใน 3 วัน
4.9 (26 รีวิว)
4.8
4.8
รูปอวาตาร์ของผู้ใช้
In my profile, my skills are clearly described, I am a person who learns quickly and I like transcription and writing part a lot. I have a degree in Administration, accounting and finance, I also did computer courses, advanced Excel and I really like the process automation part, I am an excellent option and I would like you to give me the opportunity to demonstrate all my skills and knowledge. I speak Spanish and Portuguese fluently. English, I can read and write very good. My available time is 3 hours daily (Monday to Friday) and 5 hours daily (Weekends). Thanks for the opportunity.
$238 USD ใน 20 วัน
5.0 (13 รีวิว)
4.7
4.7
รูปอวาตาร์ของผู้ใช้
Hi Paul, Hope you are doing great. The task you have requested can be achieved by coding a macro, which sorts the data by GUID, and a secondary sort by date. The objective of getting individual GUID's with total number of changes and last change value can be achieved by combing through each GUID, and tracking those changes. It will not matter if the user enters enters data in a sequential manner, as the macro would sort it anyways. What is more important, is that there has to be a user form (its a small excel based pop-up box) which will enable the users to put in the data in the right column i.e, users don't see the database. They just enter the data on the front end, and excel ensures all data is put in the right column, to avoid any mismatch (e.g price change put in column for miles etc) I can create this tool for you within a days time, and I am sure you will be very pleased with the results. If you can chat me with, I can create a demo for you within a couple of hours, and only if you like what you see, you can award the bid to me, no commitments!! I have over 10 years of experience in excel working for corporate companies like Dupont, Accenture, Volvo and TCS. I am new to Freelancer, and proposing a minimum bid just to get some work on my profile and ratings. I assure you that your work will be completed to your satisfaction and on time. I hope you will give me this opportunity. Have a nice day!! Regards Amin
$140 USD ใน 2 วัน
4.9 (7 รีวิว)
4.5
4.5
รูปอวาตาร์ของผู้ใช้
Data entry & Web Scraping expert here with fastest speed. PAYMENT AFTER YOU 100% SATISFIED WITH WORK. ready to start your work now and will work with your 100% satisfaction.......................
$155 USD ใน 0 วัน
5.0 (15 รีวิว)
4.2
4.2
รูปอวาตาร์ของผู้ใช้
Dear Sir I have gone through the project requirement in detail and willing to do it as per your requirements. I am an Excel professional having hands on expertise in data analysis and management via advanced excel formulas I will do your project as per your requirements in given time frame. Best regards Humayoon
$116 USD ใน 1 วัน
4.7 (12 รีวิว)
4.1
4.1

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

ปักธงของ UNITED STATES
Teterboro, United States
5.0
2
ยืนยันวิธีการชำระเงินแล้ว
เป็นสมาชิกตั้งแต่ ธ.ค. 28, 2017

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

งานอื่นๆ จากลูกค้ารายนี้

Excel Macro
$30-250 USD
ขอบคุณ! เราได้ส่งลิงก์สำหรับเครดิตฟรีให้คุณทางอีเมลแล้ว
เกิดข้อผิดพลาดขณะส่งอีเมลของคุณ กรุณาลองอีกครั้ง
โลโก้ 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)
กำลังโหลดตัวอย่าง
ได้รับอนุญาตสำหรับตำแหน่งทางภูมิศาสตร์
เซสชั่นการเข้าสู่ระบบของคุณหมดอายุและคุณได้ออกจากระบบแล้ว กรุณาเข้าสู่ระบบอีกครั้ง