We are looking for a freelance worker to manage an existing set of spreadsheets. These files extract data from emailed or downloaded excel spreadsheets and pdf files and process that data into our own formats and database. This will require an individual well-versed in Microsoft Excel and with a functional knowledge of Microsoft Visual Basic for Applications (VBA). Each spreadsheet uses an range of formulas and scripts which will require debugging at times. Additional regular work is available for qualified applicants who perform well with this.
This work needs to be performed daily and will require ~1.5-2 hours of work each day. With practice it can be done more quickly - the current individual managing the work takes ~1 hour to complete the processing. Data files will arrive across the early afternoon AEST and the majority need to be processed by 2:30 PM AEST. A smaller portion of the files will arrive slightly later and need to be processed by 3:00 PM AEST. As such this will require a freelancer who is able to work between the hours of 1 PM AEST and 3 PM AEST.
Some initial training will be required to understand the setup. On the first attempt it will likely take significantly longer to complete. We are only looking for candidates who are willing and able to perform this on a regular basis going forward. Improvements to the current system are encouraged – we will pay on a fixed price completion basis, so any time savings will be to your own benefit.
Note: This work utilizes Able2Extract to convert data from PDFs to spreadsheets. You will need to have access to a copy of the program - check the internet for details. A Free Trial copy is available from the publisher
Note 2: This is budgeted on an estimated per-week basis ($75/week). That will generally require between 5 and 10 hours of work based on your speed.
Bu iş için 26 freelancer ortalamada $118 teklif veriyor
Hi sir, I am scraping expert, I have did too many similar projects, please check my feedback then you will know. Can you tell me more details? then I will provide demo data for you. Thanks, Kimi
Hello, I am VB, VBA, C#, WPF, Java, Delphi, PHP, ASP.NET, CAD and GIS developer, I developed many desktop applications and custom tools, macros and Add-Ins. For reference see my profile and portfolio. I am ready Daha Fazla
Hello I have read your project description and please find below relevant work experience required that I had and if you find suitable so that we can discuss and further we can communicate. 1. Spreadsheets : Acc Daha Fazla
Dear Sir, I'm very interested by your project. I am programmer with sincere and capable. I have developed many project. You can found good my projects in my work history. Particular, I have rich experien Daha Fazla
Hi! excel automation is my masterpiece in my accounting field. It is my pleasure to help your project. Feel free to message me i am willing to help you for long term project. Thank you.
Hello. Don't know VBA but may be able to create a program to automate this (Will deliver ONLY updated data, NO program). Detailed guide please.
I can do this project perfectly. I have the abilities and skills for this project. I will be waiting for your positive reply thanks.
lets start, im ready ..........................................................................................................................................
Greetings! I have more than 8 years’ experience in advanced VBA skills in excel and access (including pivot tables, variable scope user forms, and automation) in a demanding environment. I also have experience in pr Daha Fazla
I have advanced skills of excel and vba, I can wor on regular basis as you require. I will do my best to satisfy your requirements.
Have been working on huge data from the Telecom and Banking sector for analysis and reporting, in Microsoft Excel and Access for the last 15 years, Have used VBA and Excel functions extensively for reporting , Data Ana Daha Fazla
I consider the project that you will be providing will be an investment for you where through this project you can get lot of insights.
4.5 Years exp in automation vba. Exp in all ms-office aps , internet explorer, mainframe, sap, notepad, applescript
I placed a very low bid becuase I am new to freelancer.com. I use, almost on a daily basis, Visual Basic and Excel. Am willing to deliver the best results. Thanks!
Please give me a chance, I am ready to take the challenge and will complete the given task. I know VBA Excel and I am a intermediate user.
Dear Sir or Madam, As an engineer I've had extensive experience with Excel and VBA. I have developed more than 100 different projects involving Excel and also MS Word to develop a similar task to what you describe b Daha Fazla
Hello, I have 7+ years experience in managing reports, dashboards and scorecards. I am basically an IT professional with excellent skills in Oracle and related business intelligence tools. I also have very good expe Daha Fazla
Hi .. i have very good knowledge about VBA and excel and had working experience of 8 years in MNC . would be glad to work with you to build your project . can we discuss in detail i just reply back to this or cal Daha Fazla