Find Jobs
Hire Freelancers

Data Entry and Database Creation

$40-250 AUD

Terminado
Publicado hace más de 10 años

$40-250 AUD

Pagado a la entrega
I currently download approx. 5 excel files a day containing ~ 80 rows of data and a few hundred columns. I then paste these files into a master file containing the last 3 months worth of data.   I also have a second spreadsheet containing different information, a few columns of which I add to the first spreadsheet by doing lookup formulas on the name and date field.   As you can imagine, this file is now very large, making the many formulas I use for analysis very slow to update. The project I am looking to get done involves: 1) Download the approx 5 csv files per day required for the first mentioned spreadsheet for the previous 3 years, by visiting a website that stores this information on a 1 web page per day basis. The best method I have found is a simple Google Chrome add in that downloads all csv's on a given page, once opened, but I am sure there is a faster solution; 2) Combine into one excel file. i have VBA code that can do this automatically available to you if needed; 3) Add columns and combine with the second spreadsheet mentioned above. I will provide the second spreadsheet so no downloading is required. I will make the formulas used to combine the files available to you, and I will check through the results once this step is done as I anticipate some errors due to incorrect data in the source sheet. 4) Insert 10-20 new columns filled with formulas I will provide and let excel calculate. 5) Take this final spreadsheet (or maybe a few spreadsheets due to number of row constraints in excel) and turn it into a queryable database, such as an access database, as I have this software. I am not sure if this is possible, but any Freelancer that can suggest a solution for task 5 that is queriable using excel formulas, or involves a solution that keeps the database in excel but removes much of the slow formula calculation time that exists for files of this size, will be looked at favourably. The reason for this is that I am fluent in excel but have no access database experience. Many thanks. 
ID del proyecto: 5164241

Información sobre el proyecto

15 propuestas
Proyecto remoto
Activo hace 10 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
Hi.. I have gone through your requirement in the project of consolidating data into one excel at the last. However, I will suggest for point 5, to store all database in MS Access and link excel to access database to show data in excel. In this case, calculation time which is high in excel will get reduce as calculation will be there on Access side. I can implement this idea or its variant once get details of the excel to have a clear picture. Waiting for your response to talk more on the project for clarification on both sides. Thanks. ********************UPDATE*************************** I have replied on your mail regarding step(1) development of project as per requirement. Waiting for your response to talk further and create an automated application that suit your needs. Thanks.
$188 AUD en 7 días
5,0 (8 comentarios)
3,4
3,4
15 freelancers are bidding on average $177 AUD for this job
Avatar del usuario
Hi.. Expert web scraper/Data Minor here. Interested in your project. I assure you 100% accurate and good quality work. I have too too scraping experience. let me know if you want sample before awarding. lets start. Regards
$152 AUD en 10 días
4,9 (78 comentarios)
6,1
6,1
Avatar del usuario
Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive response. Thanks.
$166 AUD en 10 días
5,0 (73 comentarios)
5,5
5,5
Avatar del usuario
I am an Excel expert. In the first step I have to download data for 3 years (around 5475 files = 5 per day x 365 days x 3 years). Will these be downloaded one-by-one?
$250 AUD en 5 días
5,0 (80 comentarios)
5,5
5,5
Avatar del usuario
Welcome to Freelancer! There are a lot of good coders out there. Freelancer asks everyone to review the people they work with after every project. This will give you some insight on what to expect from the person you are getting ready to work with For the past 15 years I have worked with Excel/MS Access and 11 years with MS SQL Server 7.0 and 2005. I have been doing my contracting work with VWorker/Freelancer for the past 3 years; during that time I have completed 70 projects ranging from Excel/Access VBA to SQL Server database constructions. In my experiences over the past 3 years I know how daunting it is to try and describe what you are wanting along with sifting through numerous bids. As you can see from my reviews I strive to make sure my customers are happy with my services. I take a lot of pride in my work and stand behind anything I create. Please feel free to ask any questions I am always willing to share my experience. Best of luck with your search. Michael
$177 AUD en 10 días
5,0 (43 comentarios)
5,4
5,4
Avatar del usuario
Hi, Very interesting project. 1. To download those csv files I have a downloader tool (an .exe file), all you need is to enter the page's url and define the target folder to store those downloaded files. 2. I can include the procedure to combined then onto 1 master .xlsx file automatically in the .exe file. 3. To add columns and combined the master file with your second spreadsheet, I will create this procedure in a macro-enabled workbook with a vba codes. The Vlookup formula will be changed into values so the workbook will not be updated all the time when it calculates. Just explain to me how you want it to be populated. 4. Inserting columns and applying formulas can also be done in the macro procedure. 5. I can convert it to .mdb automatically through the vba codes. But if you want it in excel data it would be fine anyway, because there will be no formulas in the final ouput, all will be calculated by vba codes so all cells will contain only values. For best practise, I cannot tell for sure yet until I see the whole combined data. Let me know if you like my idea and you're interested to work with me. Cheers, Daniel
$100 AUD en 2 días
5,0 (39 comentarios)
5,2
5,2
Avatar del usuario
A proposal has not yet been provided
$152 AUD en 10 días
4,9 (33 comentarios)
4,5
4,5
Avatar del usuario
Propunerea nu a fost încă furnizată
$100 AUD en 5 días
4,7 (11 comentarios)
4,4
4,4
Avatar del usuario
Hi, I'm very interested helping you creating your Access database, I have more then 7 years of experience in SQL and database administration, modeling, and manipulating, please do not hesitate to check my portfolio, there is some samples of databases modeling and database administration manual. I've checked your requirement I can do this job in the deadline without a problem, because I've done many projects like this. Please award me the project and send me all other details about your project, so we can start due to your deadline. I'm available, and can start immediately. Looking forward to working with you. Thank you for your consideration. Regards
$242 AUD en 10 días
4,8 (5 comentarios)
3,8
3,8
Avatar del usuario
Hi, To be honest I'm half understand about your goal here, let me explain and I might come up a solution for you to makes your life easier. Based on your requirement: 1. Download 5 files a day, is it a csv or xls, I assumed it;s a csv files, so it will be much easier. 2. Combine the csv into xls, i can do this 3. the second sheets, is this some kind of template (the formula always the same, or have same pattern) 4. no questions, until step 1 to 4, if what I'm thinking is correct, I can make you a program windows based (C#) that can do step 1- 4 just using one click of button. 5. this is where I'm confused, after all the spreadsheet created the big ones, what would you with it? you said you need to query it, but after you query it, what would you do with that? how would you like the data to presented, and do you need to interact(doing like what excel doing) or you just want to see it? for database there are a lot free one that capable with large data set, it's free, reliable, easy to install, like sqlite, mongoDB, so do not worry about it, you have a lot of option. Thank you,
$277 AUD en 10 días
5,0 (1 comentario)
2,4
2,4
Avatar del usuario
G'day from the motherland :) I would like to discuss this project with you further via the freelancer messaging system. Please can you send me a message. Kind regards, Daniel
$140 AUD en 5 días
5,0 (2 comentarios)
1,8
1,8
Avatar del usuario
Respectable Sir, My name is Muhammad Nawaz. I have spent 16 years of experience in IT field. But on Freelancer.com it will be my 13th project. My services are in internet campaigning, managing emails, contacts, research work, remote assistance, data entry, data backup and recovery as well as I have done online research work. I also have the experience of reliable workings in MS Windows environment, MS Office (MS word, MS Excel, MS Power Point, MS Access- I have created many databases for Some IT institutions in MS Access). I have started walking towards another milestone of Sql and DOTNET environment. On freelancer.com platform I have the honour to bid on your project. I assure you that I have the ability to complete the given task satisfactorily. My bidding is still negotiable to minimize. Let me prove myself. Please send a sample file to see and provide you with a work done or a suggestion ..................... waiting for your good reply........... regards
$277 AUD en 15 días
5,0 (1 comentario)
0,0
0,0
Avatar del usuario
A proposal has not yet been provided
$161 AUD en 10 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
A proposal has not yet been provided
$161 AUD en 10 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de AUSTRALIA
Cammeray, Australia
5,0
2
Forma de pago verificada
Miembro desde nov 25, 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.