Find Jobs
Hire Freelancers

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

$750-1500 USD

Închis
Data postării: peste 5 ani în urmă

$750-1500 USD

Plata la predare
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.
ID-ul proiectului: 17661350

Despre proiect

58 propuneri
Proiect la distanță
Activ: 5 ani în urmă

Vrei să câștigi bani?

Avantajele de a licita pe platforma Freelancer

Stabilește bugetul și intervalul temporal
Îți primești plata pentru serviciile prestate
Evidențiază-ți propunerea
Te înregistrezi și licitezi gratuit pentru proiecte
58 freelanceri plasează o ofertă medie de $1.010 USD pentru proiect
Avatarul utilizatorului
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 în 20 zile
5,0 (177 recenzii)
9,3
9,3
Avatarul utilizatorului
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 în 30 zile
5,0 (273 recenzii)
8,8
8,8
Avatarul utilizatorului
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 în 10 zile
4,9 (668 recenzii)
8,6
8,6
Avatarul utilizatorului
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 în 7 zile
5,0 (562 recenzii)
8,6
8,6
Avatarul utilizatorului
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 în 5 zile
4,9 (250 recenzii)
7,9
7,9
Avatarul utilizatorului
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 în 20 zile
4,9 (106 recenzii)
7,9
7,9
Avatarul utilizatorului
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 în 5 zile
5,0 (290 recenzii)
7,5
7,5
Avatarul utilizatorului
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 în 5 zile
4,9 (95 recenzii)
7,5
7,5
Avatarul utilizatorului
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 în 24 zile
5,0 (49 recenzii)
7,1
7,1
Avatarul utilizatorului
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 în 2 zile
5,0 (78 recenzii)
6,9
6,9
Avatarul utilizatorului
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 în 10 zile
5,0 (192 recenzii)
7,0
7,0
Avatarul utilizatorului
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 în 5 zile
4,8 (232 recenzii)
7,4
7,4
Avatarul utilizatorului
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 în 10 zile
4,9 (111 recenzii)
6,2
6,2
Avatarul utilizatorului
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 în 10 zile
5,0 (58 recenzii)
5,9
5,9
Avatarul utilizatorului
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 în 20 zile
4,8 (26 recenzii)
5,8
5,8
Avatarul utilizatorului
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 în 20 zile
5,0 (22 recenzii)
5,7
5,7
Avatarul utilizatorului
- 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 în 4 zile
4,6 (56 recenzii)
6,2
6,2
Avatarul utilizatorului
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 în 12 zile
4,3 (72 recenzii)
6,5
6,5
Avatarul utilizatorului
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 în 10 zile
5,0 (23 recenzii)
5,7
5,7
Avatarul utilizatorului
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 în 20 zile
5,0 (26 recenzii)
5,9
5,9

Despre client

Steagul UNITED STATES
Phoenix, United States
5,0
32
Metoda de plată a fost confirmată
Membru din sept. 30, 2013

Verificarea clientului

Mulțumim! Ți-am trimis prin e-mail linkul pe care trebuie să-l accesezi pentru a revendica creditul gratuit.
A apărut o eroare la trimiterea e-mailului. Încearcă din nou.
Utilizatori înregistrați Totalul proiectelor postate
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Se încarcă previzualizarea
S-a oferit permisiunea de depistare a locației.
Ți-a expirat sesiunea pentru conectare sau te-ai deconectat. Conectează-te din nou.