Find Jobs
Hire Freelancers

Combining excel sheets

$250-750 USD

Terminado
Publicado hace más de 8 años

$250-750 USD

Pagado a la entrega
I need to combine a bunch of excel files into one master excel file. Your job would be to use any statistical program (ideally either just excel or stata or spss) to combine the data in the excel file sheets into one master combined excel file. I am attaching a sample file called Combined... This file is a sample of the original excel file. I am attaching the master file, with the subheadings, and two rows example. Sub =Subject Slideshow is SS1 named on the file. All of the processes will have to be automated. Your job would be to write an algorithm to do this. We only have 5 files so far, but anticipate 20 files total over the next year. Therefore, would like an automated process rather than someone manually doing it.
ID del proyecto: 8533962

Información sobre el proyecto

48 propuestas
Proyecto remoto
Activo hace 9 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
Adjudicado a:
Avatar del usuario
Hello Sir Im excel VBA macro and formula Expert :) i can do anything in excel via VBA macro, include make combine sheet like you want Sir :) please give me a chance for doing your job and im able to start doing your job right now :) Thank You Sincerely Prameswara :)
$250 USD en 3 días
4,9 (426 comentarios)
7,6
7,6
Avatar del usuario
Hi there, I have a vast experience in Excel and VBA and would be happy to help you on the project. Best regards, Eugene
$250 USD en 3 días
5,0 (258 comentarios)
6,6
6,6
48 freelancers están ofertando un promedio de $407 USD por este trabajo
Avatar del usuario
Hello Sir, I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among niche bidders who have zero failed projects and very high 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. Pay me only when your job is 100% done. Also I will provide you with a working version of file before you consider awarding me the project. Thanks, Jay
$250 USD en 2 días
5,0 (886 comentarios)
9,3
9,3
Avatar del usuario
Dear Sir/Ma'am, Price and duration will vary depending on actual project. I am a Web research and Data Entry expert. I checked and understood your requirements. I can handle this job very well to your appreciation. I can find and extract the information from different websites into an Excel sheet. I am ready to hear the details of the project more in detail now. I have always created a long-term collaboration with my clients through hard work and quality output for a reasonable price. If you have questions or doubts about anything, please feel free to ask me. Sincerely, Mir
$250 USD en 10 días
4,9 (384 comentarios)
8,0
8,0
Avatar del usuario
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. PS: What you need it can be achieved. But such details should be spoken personally. Best regards
$500 USD en 3 días
5,0 (334 comentarios)
7,5
7,5
Avatar del usuario
i can do it for you quickly and exactly by vba
$277 USD en 5 días
4,9 (123 comentarios)
7,1
7,1
Avatar del usuario
Dear, we are Team of French + US. 11 years experience on Access/Excel/VBA automations. 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
$250 USD en 3 días
4,7 (60 comentarios)
7,1
7,1
Avatar del usuario
Hi I have carefully checked attached spreadsheets, and read and understood the details. I can create a custom PHP script (preferred) or a Windows application to automate this task. You will be able to upload the excel files (xls or xlsx), and it will process the files and output the Combined file in xls or xlsx format, which will be similar to your example. You can choose to run the said script on a local PC using WAMP or on a good PHP host that is live. We we can discuss the functionality in detail. I will provide support/fixes if any issues arise. I am extremely detail oriented and I strive for quality in my work. I have excellent previous record of completing projects with great client feedback. Looking forward to seeing your reply. Thanks. Regards Ahsan
$250 USD en 5 días
4,9 (76 comentarios)
6,7
6,7
Avatar del usuario
expert in excel. I can combine multiple spreadsheet to a single spreadsheet .good in vlookup concepts macros pivot tables charts and all excel functions
$277 USD en 3 días
4,8 (102 comentarios)
6,5
6,5
Avatar del usuario
A proposal has not yet been provided
$421 USD en 10 días
5,0 (40 comentarios)
6,3
6,3
Avatar del usuario
Hello I understand your complete requirement. I can guarantee to get you a automated processing of files ( even in future ) via an excel macro. I am sure I can complete the task in the next 24 to 48 hours. Let me know if you are interested. Hello, I went through your updated description. As said, if the macro is developed to support one sheet, then it is pretty simple to make it generalize across all sheets. I think the macro is what it matters. Give me a ping, so that I can share you my idea on this. Thanks
$250 USD en 2 días
5,0 (117 comentarios)
6,1
6,1
Avatar del usuario
I am a STATISTICS tutor for last 5 years. I have expertise in Statistical Analysis. I can show you some of my previous analysis. I have excellent concepts of Random variables, Probability Distribution, Sampling and different tests. The tool I uses are SPSS, EXCEL, minitab, Weka and R for programming. Thank you for considering my proposal 
$300 USD en 4 días
4,9 (31 comentarios)
5,4
5,4
Avatar del usuario
I can automate it 90-95% through using STATA I have a strong and proven track record of doing data analysis, Statistical Analysis, Survey Analysis and forecasting future outcomes in financial markets. I have worked entire data analysis life cycle from requirements through listing, questionnaire design, field strategy, data gathering, cleaning, analysis and reporting. Moreover, I assisted economists and public policy experts based at HARVARD UNIVERSITY, PRINCETON UNIVERSITY, LONDON SCHOOL OF ECONOMICS AND LAHORE UNIVERSITY OF MANAGEMENT SCIENCES. I have the experience, confidence, demeanor and desire to be in position where I can manage development solutions. I speak well in public and have strong technical writing skills. In addition, I am willing and able to take on leadership roles. I have a thorough understanding of econometrics, statistics and finance how the Regression and economic analysis could be used to interoperate the data meaningfully. Able to work on own initiative and as part of a team. First-class analytical, design and problem solving skills. Well-versed in current and new finance methodologies. 1. Strong knowledge and experience of complete data analysis life cycle. 2. Highly skilled in statistical software’s like Stata, Excel and SPSS 3. Proven ability to determine priorities, schedule work and meet critical deadlines. 4. Proven ability to manage a team and use of scarce resources efficiently.
$900 USD en 10 días
5,0 (26 comentarios)
5,5
5,5
Avatar del usuario
Hello, obviously you need a generalized macro excel useful for this task and for the future ones i 'm able to provide it to you
$277 USD en 3 días
4,7 (67 comentarios)
5,7
5,7
Avatar del usuario
HI, please see my profile, contact me if you find me suitable for work. With regards, Tomislav____________________________________________________
$500 USD en 7 días
4,9 (34 comentarios)
5,3
5,3
Avatar del usuario
I have the expertise in Excel and can create a script to automate the process - either dynamically where it gives you the option of file selection or automatically, if you are sure about the naming convention and number of files. Ready to start work immediately
$277 USD en 4 días
4,6 (67 comentarios)
5,4
5,4
Avatar del usuario
Hi, We would do it in $200. We are experts in quantitative analytics, data processing and automation. The file merging task can be done using excel VBA macro. We can do that. However this would take higher run time to process 25 files one by one. Generally in these kind of cases we use SAS to read the data and then merge. SAS gives flexibility in manipulation as well. I have looked into your datasets. What we would like to know is if all the data sets have similar format or not? If not that should not be a problem. Kindly let us know if you want to discuss this further with us. We can give you the best quality output with assured after sales service if required. Also you would get the lowest price. Kindly let us know. Regards, Pal
$250 USD en 3 días
4,8 (36 comentarios)
5,3
5,3
Avatar del usuario
we do in less then 250$
$277 USD en 2 días
4,6 (25 comentarios)
4,7
4,7
Avatar del usuario
Hi, I have strong background in Research, Reporting, Statistics, quantitative and qualitative analysis and experience in SPSS. Let me help you. Daily writes scientific papers, and I'm used to technical language. I am ready to start.
$555 USD en 3 días
4,7 (14 comentarios)
4,3
4,3
Avatar del usuario
Hi.. I interested to your project & place bid for your consideration. I am available right now. if you award the project to me, i will start to do it immediately. looking forward to hearing from you. Proposal : -. Macro to compile source data to master data -. Macro to load source file directly from pre-selected folder, all file selected in-sequence will load automatically, no human dependent to select file & load one by one. Thanks & Regards, gsanggara
$300 USD en 10 días
4,9 (27 comentarios)
4,3
4,3
Avatar del usuario
Hi, it should be easy for me. But I need more explanation on the example file Thanks................................................................................................................................................................
$250 USD en 5 días
4,6 (12 comentarios)
4,0
4,0
Avatar del usuario
A proposal has not yet been provided
$777 USD en 10 días
5,0 (6 comentarios)
3,5
3,5

Sobre este cliente

Bandera de UNITED STATES
Hanover, United States
5,0
5
Forma de pago verificada
Miembro desde jul 12, 2015

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.