Find Jobs
Hire Freelancers

build a program to compare simple data, produce 2 calculations, 2 reports and plot graphs.

$750-1500 USD

Closed
Posted over 5 years ago

$750-1500 USD

Paid on delivery
I currently do the following manually which I want to automate as much as possible in a mini-program: I copy and paste data from one report into the first worksheet of an excel worksheet. I copy and paste data from a second report into the second worksheet of an excel worksheet. I run a macro that highlights records that exist in both worksheets. I calculate and record the number of records highlighted. I calculate and record the percentage of records highlighted against the total number of records in the spreadsheet. I delete records that contain YES in a specific column I export and save a report of all of the non-highlighted records on the first worksheet. I export and save a report of all of the non-highlighted records on the first worksheet that contain an email field. I would like a program to do all of this for me if I just upload the two files needed. The reports contain sensitive data so I would prefer it to run locally rather than cloud based. Ideally, I would also like the program to keep a record of each calculation set and ideally have it produce graphs tracking the calculations over time. Feel free to ask me questions if you need clarification on functionality.
Project ID: 17661350

About the project

58 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
58 freelancers are bidding on average $1,010 USD for this job
User Avatar
Ok can we discuss more on freelancer inbox to get detail understanding about project ? i am having some technical question on this so let me know when you get time to discuss on this and clear the doubts. I have relevant skills and experience as per your project need...i can share some demo as well once we clear the scope.
$1,028 USD in 20 days
5.0 (177 reviews)
9.3
9.3
User Avatar
I will create a program which will run locally on your system only to perform all specified features you have mentioned which you are doing via excel and macros etc at the moment
$2,777 USD in 30 days
5.0 (273 reviews)
8.8
8.8
User Avatar
Hello Sir, I am the expert freelancer here. I am on the 6th position through out the world to deliver the quality job. I have deliver here more than 390 + projects with 100% client satisfaction. I can help you with build a program to compare simple data, produce 2 calculations, 2 reports and plot graphs. I have more than 5 years of the experience in Data Processing, Excel, PHP, Software Architecture, Visual Basic Please ping me for more discussion. Thanks.
$750 USD in 10 days
4.9 (668 reviews)
8.6
8.6
User Avatar
Hello! My name's Paris and I was glad to see that you're looking for an Excel developer. You mention that you need somebody to automate a series of steps including highlighting common data and producing a graph at the end. I will deliver an Excel spreadsheet which will contain the necessary code to implement all your mentioned steps. I've delivered more than 240 projects in the last 5 years and this makes me very comfortable with your task. I can deliver the project within 7 days including all required revisions for $900. I never ask for payments in front. I will only ask you to release the agreed milestones once the task for each one of them is met and you're happy with it. Feel free to visit my personal page on this platform and get an idea of how satisfied my clients are from my work. Don't hesitate to contact me. I'm looking forward to hearing from you soon. Paris Pallas
$900 USD in 7 days
5.0 (562 reviews)
8.6
8.6
User Avatar
Respected Sir/Madam, If you can kindly share the sample input file, that will be very helpful. Will it be web based? Pankaj Garg UserName: WebInfoSolutions Profile Page: https://www.freelancer.com/u/WebInfoSolutions
$750 USD in 5 days
4.9 (250 reviews)
7.9
7.9
User Avatar
HI There, I can assist you build a program which can perform as desired. I am very passionate about quality of my work, You will be pleased working with me. Let's have a quick chat to discuss it further. You can check my sample work at: https://www.freelancer.com/u/extreamcode.html
$1,250 USD in 20 days
4.9 (106 reviews)
7.9
7.9
User Avatar
Hi, I am an Excel automation expert and have been in this field for well over 10 years. My proposal is to provide you with an Excel macro based automated solution meeting all the requirements. This will be in addition to the macro which is already existing. There will be a provision to select the two Excel input files. Shall make the solution as user friendly as possible. Let me know and kindly share sample files. Regards, Arul
$750 USD in 5 days
5.0 (290 reviews)
7.5
7.5
User Avatar
Hi, I’ve read your proposal and I can automate the process in Microsoft Excel by VBA. I am a financial expert and guru in Excel/VBA/Macro. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts. Furthermore, I have an experience in dashboards, financial reports, accounting, consolidating, forecasting, budgeting and cost acquisition based on inventory, bill of materials, collections, payments, and bank reconciliation. With these skills, I develop financial modules including depreciation schedule, long-term debt, business valuation methodology & ratios The modules incorporate complex components of business in a simplified and logical manner.
$800 USD in 5 days
4.9 (95 reviews)
7.5
7.5
User Avatar
Dear svmmjcc, Can we discuss about your project "build a program to compare simple data, produce 2 calculations, 2 reports and plot graphs.". I have done many projects that require skills Data Processing, Excel, PHP, Software Architecture, Visual Basic please check more from here https://www.freelancer.com/u/mmadi.html?page=portfolio I can do this within your budget too $750 - $1500 USD I am ready to work with you,kindly waiting for your response. Thanks & Regards, Mmadi I currently do the following manually which I want to automate as much as possible in a mini-program: I copy
$900 USD in 24 days
5.0 (49 reviews)
7.1
7.1
User Avatar
Hello, I am a software development expert and have plenty of good experience of it. I read your project description posted. However, I'd like to discuss more detail with you now. I am free to work now. Kindly send me a chat. Looking forward your quick contacting. Regards
$1,250 USD in 2 days
5.0 (78 reviews)
6.9
6.9
User Avatar
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered twenty four excel vba projects in the past one twenty days. Good to do. Willing to take up your project. Thank you, Regards.
$750 USD in 10 days
5.0 (192 reviews)
7.0
7.0
User Avatar
I read your requirements carefully and I confirm that I can do exactly what you need. I can create an Excel Macros file (with extension XLSM) which would have a button to run the VBA code I'd write. So you would simply need to copy your 2 files into this folder, open the XLSM file and press the button. It will do all the work you need then. The information it extracts (numbers are graphs) will be displayed and stored in one of the sheets of the same XLSM file. So this file will be your single-stop solution for all your needs. I'm a computer science professional with a PhD degree and extensive experience in automation of data acquisition, processing, analysis, and presentation in Excel using custom dashboards, macros (VBA scripts), pivots, filters, and other advanced tools. I've done a lot of similar work. It would be my pleasure to complete your project. Please have a look at some Excel projects I've done: https://www.freelancer.com/projects/Excel/Calculate-the-semi-deviation-each/ https://www.freelancer.com/projects/Excel/Recreate-online-calculator-using-Excel/ https://www.freelancer.com/projects/Excel/Build-Excel-reports-dashboard/
$750 USD in 5 days
4.8 (232 reviews)
7.4
7.4
User Avatar
I can write a macro in Excel VBA itself to achieve the objectives mentioned -- to process the 2 input files and produce the reports as per the requirements. I have excellent command on MS Excel. I have completed complex projects in Excel before . For instance - Built a delivery schedule for pick-up and drop of raw-material under given constraints optimizing the utilization of available resources - Get match details, odds and stats of tennis matches and place bet automatically on betfair (API), pinnacle (API) and tennisinsight (scraping) websites - Buy and sell bitcoins on Coinfloor and GDAX using respective APIs - Built a POS and inventory management system - Built a hotel price comparison that pulls data using the website's API You can see the reviews of the same in my profile Thanks, Archana
$750 USD in 10 days
4.9 (111 reviews)
6.2
6.2
User Avatar
Hi there, My suggestion is writing a C# program that can be run on Windows, The program can take control of Excel files, read cells, compare them and do more. If you send the Excel files format and reports, I will tell more about the details. Mehrzad
$800 USD in 10 days
5.0 (58 reviews)
5.9
5.9
User Avatar
HI, Do you have formula in excel or spreed sheet ? I can convert it to live web page and will plot graph . Do you need pie chart or line chart? I am ready to start right away. Thanks Sharwan
$777 USD in 20 days
4.8 (26 reviews)
5.8
5.8
User Avatar
Hi, I am a developer with more than 3 year experience. I have developed and designed many websites and softwares. I can easily develop a system for you according to your requirements. Looking forward to hear from you. For any query you can contact me anytime
$1,333 USD in 20 days
5.0 (22 reviews)
5.7
5.7
User Avatar
- This entire process could be automated with Excel, just completed a project with similar filtering and highlighting (can showcase) - Copying the 2 reports into the Worksheet (being Excel, CSV or Text) - Click of a button highlighting records which are in both - Calculate Totals of the highlighted rows Percentage of the highlighted rows to the overall - Then which ever row marked for deletion can be deleted in First and Second sheet - Save a new Sheet for the non-highlighted rows from First and Second separtely. This will be a desktop version, so security is with individual. My Skills: - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Extensively the macros/VBA to automate: - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells - Data camparision using formulas, lookups and bringing up summaries., - Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them. - With summary data plotting graphs, bringing pivot tables - Pl. review my portfolio on projects done - https://www.freelancer.com/u/satishtl Sample HighComplex Projects using Macros: (via Freelancer) - Complex Data anlaysis and graphing - Using Surface, Scatter Dynamically setting axis values, legennd colors(Excel 2013 to Excel 2016) - Heating Wire Design, Canada, - Identify the wiremodel running through multiple iterations. +...
$750 USD in 4 days
4.6 (56 reviews)
6.2
6.2
User Avatar
Hey, Greeting of the day, I am swatik. I was looking through your project requirements I have strong knowledge in { Website Design, PHP, Wordpress, Ecommerce, Magento, Opencart, HTML5, Jquery, Ajax, Javacript, Plugin/Extension development, Graphic Design, Mobile App design, Game development }.and I do believe it's something we have experience in previous development and we can complete in a reasonable amount of time and cost. I have reviewed your job and find myself experience in working with similar kind of job. What i ensure from my end. I provide the complete solution where I provide the code that is easily maintainable, clean codes and provide seamless integration of new functionality. I give attention to details and ensure that the application to be developed is User friendly. I am the right person for your project. I believe in customer satisfaction and building long term relationship with the client. If you are interested. please revert me back so we can discuss further details. Thank you Swatik
$1,234 USD in 12 days
4.3 (72 reviews)
6.5
6.5
User Avatar
Hi, I am a chemical engineer and I have over five years experience in using Excel at an advanced level (complex formulas, array formulas, pivot table and charts, macros and VBA scripts, automatic calculation sheets, automatic simulators and charts drawing) as an Industrial Engineer at Michelin Romania. I am always keen to improve my work quality and productivity and, to achieve these goals, I made complex Excel sheets to automate my tasks and eliminate errors. I will be glad to help you with your project and I am sure you will be satisfied with my professionalism and the quality of my work. Best regards, Florin Enache.
$780 USD in 10 days
5.0 (23 reviews)
5.7
5.7
User Avatar
Best knowledge on Excel sheet data automation. Building excel macro and implement. Experience on VBA Macro and Visual Basic program to build any kind of Windows Application Software. Have more than 15 years of experience on Visual Basic. 15+ years of experience on Computer Language and Digital Electronics.
$750 USD in 20 days
5.0 (26 reviews)
5.9
5.9

About the client

Flag of UNITED STATES
Phoenix, United States
5.0
32
Payment method verified
Member since Sep 30, 2013

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.