Find Jobs
Hire Freelancers

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

$750-1500 USD

Cerrado
Publicado hace más de 5 años

$750-1500 USD

Pagado a la entrega
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 del proyecto: 17661350

Información sobre el proyecto

58 propuestas
Proyecto remoto
Activo hace 6 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
58 freelancers están ofertando un promedio de $1.010 USD por este trabajo
Avatar del usuario
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 en 20 días
5,0 (177 comentarios)
9,3
9,3
Avatar del usuario
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 en 30 días
5,0 (273 comentarios)
8,8
8,8
Avatar del usuario
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 en 10 días
4,9 (668 comentarios)
8,6
8,6
Avatar del usuario
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 en 7 días
5,0 (562 comentarios)
8,6
8,6
Avatar del usuario
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 en 5 días
4,9 (250 comentarios)
7,9
7,9
Avatar del usuario
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 en 20 días
4,9 (106 comentarios)
7,9
7,9
Avatar del usuario
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 en 5 días
5,0 (290 comentarios)
7,5
7,5
Avatar del usuario
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 en 5 días
4,9 (95 comentarios)
7,5
7,5
Avatar del usuario
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 en 24 días
5,0 (49 comentarios)
7,1
7,1
Avatar del usuario
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 en 2 días
5,0 (78 comentarios)
6,9
6,9
Avatar del usuario
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 en 10 días
5,0 (192 comentarios)
7,0
7,0
Avatar del usuario
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 en 5 días
4,8 (232 comentarios)
7,4
7,4
Avatar del usuario
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 en 10 días
4,9 (111 comentarios)
6,2
6,2
Avatar del usuario
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 en 10 días
5,0 (58 comentarios)
5,9
5,9
Avatar del usuario
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 en 20 días
4,8 (26 comentarios)
5,8
5,8
Avatar del usuario
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 en 20 días
5,0 (22 comentarios)
5,7
5,7
Avatar del usuario
- 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 en 4 días
4,6 (56 comentarios)
6,2
6,2
Avatar del usuario
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 en 12 días
4,3 (72 comentarios)
6,5
6,5
Avatar del usuario
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 en 10 días
5,0 (23 comentarios)
5,7
5,7
Avatar del usuario
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 en 20 días
5,0 (26 comentarios)
5,9
5,9

Sobre este cliente

Bandera de UNITED STATES
Phoenix, United States
5,0
32
Forma de pago verificada
Miembro desde sept 30, 2013

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.