Find Jobs
Hire Freelancers

Develop a data transformation application on Excel

$250-750 SGD

Completed
Posted almost 7 years ago

$250-750 SGD

Paid on delivery
Build a consistent data transformation application on MS Excel, that is able to map disparate data fields from 2-3 flat file queries into one master data table intended for data visualization and analysis. The application is intended for HR applications. Data will be fed typically on 2-3 flat files; one for active employees, one for inactive employees and one which provides additional descriptors for employees. But the data fields may not be consistent or consistently named across tables. The application should allow for the user to map requisite data fields across tables leading to the assembly of the master data table. The application should be easy to use and reliable (based on user defined mapping, of course). Am not bent on MS Excel per se; am keeping an open mind to alternative widely accessible platforms
Project ID: 14771438

About the project

35 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Excel is critical to my work. Am proficient and can code. I understand the scope to be essentially data selection and merging of data from tables with structure are consistent. Will be able to be of assistance. Looking forward to hearing from you.
$490 SGD in 3 days
5.0 (9 reviews)
4.7
4.7
35 freelancers are bidding on average $523 SGD for this job
User Avatar
-----------------Hello----------------- ***Let's built successful project together*** https://www.freelancer.com/u/HugeWave.html This is my freelancer.com profile and please check my profile .. As you see , I have good experience in this field.. I have developed lots of mobile apps and website , game etc.. So I think we can discuss about your project in detial .. Please contact me and let's discuss about your project together.. I will provide wonderful project and qualitative code , also after complete I will provide full service and do my best for you. If you contact with me and working together , then you will be see talented programmer .. :) Let's built Business relationship together. Regards Lee
$555 SGD in 10 days
5.0 (53 reviews)
8.1
8.1
User Avatar
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. i can do this Task as per your requirement. Relevant Skills and Experience I have the 5 years of experience with excellent knowledge. please give me a chance to work on your project Proposed Milestones $500 SGD - payment once project delivered
$500 SGD in 4 days
4.9 (216 reviews)
7.2
7.2
User Avatar
I can develop an Excel based solution for SGD 400. Relevant Skills and Experience 18 years experience in using Excel as part of daily work life. In the process, implemented lot of automation. Over the last 12 MONTHS , spent at least 225 HOURS on automation in Excel every month. Proposed Milestones $200 SGD - Initial Delivery $200 SGD - Final Delivery
$400 SGD in 7 days
4.9 (132 reviews)
6.4
6.4
User Avatar
I am an excel expert. Read the project specs. Looks like this project is feasible. Just want to understand and make sure some of the requirements ..so kindly open PM to discuss work and budget..I can talk over phone to understand the requirements and will provide support though out the project till you are satisfied with the work.. Regards,
$555 SGD in 10 days
4.9 (69 reviews)
6.0
6.0
User Avatar
Hi, I did a similar project regarding HR Succession Planning. I have experience in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, Relevant Skills and Experience screen layout's (user-forms), drop-down boxes, generator reports, and charts. For more info please review my profile. Proposed Milestones $555 SGD - At the completion of the project
$555 SGD in 10 days
4.9 (41 reviews)
6.0
6.0
User Avatar
Hello, I have been working as freelancer since last ~ 5 years,prior to this was working with a MNC as an Sr. Software Professional. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applications -- Expert on C# using .NET framework using Visual Studio 2012 and 2013 -- Expert in ASP.NET,MVC -- Expert in VB.NET using VS2012/VS2013 -- WPF and Windows Forms Application I have experience in all the above areas and during my project work I have completed all of the above tasks. As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. Delivering best & Customer satisfaction is the key for any individual and I always worked keeping these things during project execution. Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Abhinov
$555 SGD in 10 days
4.8 (47 reviews)
5.4
5.4
User Avatar
I advice to make it via Ms Access GUI(with Excel automation -i need) Relevant Skills and Experience vba, access Proposed Milestones $555 SGD - default
$555 SGD in 10 days
4.7 (27 reviews)
5.7
5.7
User Avatar
With respect to this project I would like to present myself as a candidate for your consideration. I have more than 8 years of IT experience. I have successfully completed few projects for US clients Relevant Skills and Experience 1) Programming/Scripting 2) Application/Web development 3) Web Scraping 4)MS-Excel(Advanced) Proposed Milestones $388 SGD - This task will be completed within schedule
$388 SGD in 7 days
4.9 (34 reviews)
4.9
4.9
User Avatar
Hi, If you are looking for a professional and reliable Excel expert with proficiency in data analysis, I'm your ideal candidate. I'm highly experienced in producing mathematical solutions with Excel and I have a strong background in using VBA and data analysis tools. You can be confident that your Excel work will be completed in a professional manner. I’m primarily interested in exceeding your expectations than the pay. This is why I'm willing to offer you a trial service, if you want. I can start by completing a part of your work as a sample. No commitments required! For over 10 years I’ve been building and administering advanced spreadsheet solutions and so I am accustomed to doing this sort of job on a regular basis. I have a deep passion for producing splendid results and guarantee that all your finished work will appear 100% complete. I highly value professionalism and hold myself strictly accountable to represent my client’s brand. I aim to form a long-term working relationship. I also offer negotiable rates. Please, let me know what is needed to secure this bid! Thank you for your consideration. Smith
$300 SGD in 10 days
4.8 (14 reviews)
4.4
4.4
User Avatar
Dear, I have many years working experience using VBA on MS Excel. Therefore , I could help you to make this request done in short time. Regards, Relevant Skills and Experience VBA/ MS Excel/ Coding Proposed Milestones $250 SGD - Finish
$250 SGD in 4 days
5.0 (12 reviews)
3.7
3.7
User Avatar
I would a VBA project using my existing projects to 1. Read text files 2. Code form for matching the headers from text files 3. Code VBA to create and populate a new master file Relevant Skills and Experience I have been coding in basic & VBA since 2000. I would re-use several of my existing VBA projects and write new code for form and to create new master file Proposed Milestones $200 SGD - Provide VBA project to read and parse the 2-3 text files containing the results of flat file queries $300 SGD - Provide updated VBA project with form for matching the headers from text files $333 SGD - Provide final updated VBA project to create new master file with data from the 2-3 text files Are the "2-3 flat file queries" in a .txt format or a .csv format?
$833 SGD in 10 days
5.0 (1 review)
3.4
3.4
User Avatar
I have checked your attachment "Sample Input Tables" and "Sample Output table". I am expert in file management in Excel. I will be able to write excel macro and complete your job successfully Relevant Skills and Experience I am expert in Excel, Excel VBA Macro, Flat File Management which is required for this job. Proposed Milestones $555 SGD - The price is negotiable if you have limited budget. Additional Services Offered $100 SGD - Apart from writing Macro I will be able to help you in Improving your HR application in many ways Your job is very easy for me, I will be able to do it in approx 2 days. I will satisfy you.
$555 SGD in 10 days
5.0 (1 review)
1.7
1.7
User Avatar
A proposal has not yet been provided
$555 SGD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have excellent knowledge of ms Excel macros with excellent typing speed. I can assist you with any kind of data entry work, Excel Data analysis. I assure you 100% Quality of work delivered. Relevant Skills and Experience I have three years of experience in working with ms office tools excel, power-point world etc. Proposed Milestones $300 SGD - complete work
$300 SGD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
a Relevant Skills and Experience case Proposed Milestones $477 SGD - Milestone addad
$477 SGD in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I worked 11 years for a firm that makes accounting software so I have experience transforming data on Excel.
$605 SGD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Can Deal with excel data processing very well. Relevant Skills and Experience having development experience in visual basic + excel processing. Proposed Milestones $100 SGD - starting of job $200 SGD - on 50% completion $100 SGD - on 75% completion $155 SGD - final submission please provide more details
$555 SGD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have completed numerous projects like this before and MS Access or Excel is certainly sufficient to meet your needs. I would be happy to complete this work for you. Please contact me and we can quickly get going.
$555 SGD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
see my profile Relevant Skills and Experience see my profile Proposed Milestones $555 SGD - see my profile
$555 SGD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$300 SGD in 6 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of SINGAPORE
Singapore, Singapore
0.0
0
Payment method verified
Member since Jul 27, 2017

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.