Find Jobs
Hire Freelancers

Search the Web for Something

$20000-50000 USD

Closed
Posted over 8 years ago

$20000-50000 USD

Paid on delivery
Manipulate Provided Data from many spreadsheets onto one spreadsheet with a standard header. In short getting all the data relating to a unique identifier for a brand onto one sheet. Many steps are involved in filling out all columns but my team can train and give video documentation on the steps necessary for each step. Please see examples attached for an idea of the nature of the project... The before files are what is provided The after files is what is given and must be filled out The completed files are what they will look like Their is a lot of work but 100% accuracy must be maintained when migrating data pertaining to a unique identifier from one spreadsheet to another and must always be done utilizing the V-Lookup function in Excel at all times. For those that want their application for the project to be reviewed... I would like an answer as to why it is so important to only use the V-Lookup function rather than other means such as copying and pasting when moving data regarding a unique identifier? Please familiarize yourself with the variables in the header as you will need to fill them for all products. Each one requires a different process, step, or search to complete. Thank You, All Are Welcome. Including Newbies
Project ID: 8311283

About the project

25 proposals
Remote project
Active 9 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
25 freelancers are bidding on average $33,223 USD for this job
User Avatar
A proposal has not yet been provided
$36,082 USD in 3 days
4.9 (31 reviews)
5.5
5.5
User Avatar
Hello, I have been working with a MNC bases company since last ~ 4 years, as an IT BI DWH Professional. The project is a BI DWH project which covers 3 layers of BI (ETL, Data warehouse & Reporting) and helped me in nourishing my talent in all the technologies around these 3 layers. Below are some key areas of my skills: • Expert on SQL Server, Oracle and MS Access Databases • Expert in BO XI, Cognos and SQL Server Reporting Service (SSRS) • Expert in & designing & Implementation of end to end ETL Process using Informatica & SSIS Tools • Expert in Designing Qlikview Dashboard BI Solution • Expert in ER & Dimension Data modeling • Complete Command on PL/SQL concept e.g. Procedures, Functions, packages and complex queries. • Basic knowledge of Unix Shell scripting 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 work keeping these things in mind during project execution. Apart from above also successfully completed Database & Informatica Training for a US based Training Organization. Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Ashish Seth
$34,444 USD in 3 days
4.8 (32 reviews)
5.0
5.0
User Avatar
A proposal has not yet been provided
$20,000 USD in 3 days
5.0 (5 reviews)
2.8
2.8
User Avatar
You referenced example attachments but there weren't any attachments on this project. Having access to the examples will be critical in order for me (or anyone else) to provide you with the an accurate bid estimate in terms of both time and money. You should not trust any bidder if they are not asking these types of questions: How many total source Excel files are there? What are the min, max and average number of rows in each source file? Do source files contain multiple worksheets? How many columns are there in the target file? How many columns that need to be filled out will come from web search results versus pulled from other spreadsheets via vlookup? Are the web searches against a specific set of known web sites? Does any of the data need to be manipulated in any way, e.g., splitting a single name field into first name and last name, removing duplicates, trimming spaces, etc? I am very experienced in manipulating data within Excel. Vlookup() is needed to ensure data integrity since copy/pasting is very error prone. A unique identifier is critical for this function. Sometimes the identifier needs to be a composite of values from more than one field and will need to be constructed using concatenation. Depending on the level of consistency in the source files, there are alternate approaches to vlookup() that could help semi-automate this process involving Macros and/or Database tools, both of which I have the skills to execute. Please call me: Rob 1.917.907.2328
$33,333 USD in 10 days
5.0 (1 review)
2.0
2.0
User Avatar
I would like to see these files that need to be compiled before anything is finalized. I believe why you are wanting the v-lookup is because it is not a static formula and it doesn't matter where data is moved to (as long as the v-lookup formula is setup correctly). That being said VBA code is more exact and 100% accurate, would you be apposed to that being done? I can combine the two if needed. Thanks
$22,222 USD in 7 days
5.0 (3 reviews)
1.8
1.8
User Avatar
A proposal has not yet been provided
$38,888 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I would like to complete this work in time, if allotted. I have work experience in data entry / data processing/ and data punching work for market research companies. My priorities are Accuracy and timely delivery.
$44,444 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Thank you for considering my proposal. I have in excess of 20 years experience in office administration and management work, and many of these years have been spent doing data entry, data processing and copy typing, I am proficient in the use of Excel and am adept at data mining, data warehousing, HTML and web search. Possessing exceptional computer skills, I would bring to your project, experience, attention to detail. accuracy, a great work ethic, punctuality, reliability, excellent english spelling and grammar skills, pride in my work and a can do attitude. I can start on your project immediately, 10% deposit is requested on engagement of my servcies and I do offer a 100% money back guarantee should my work not be up to standard for my employers peace of mind. Sincerely, Cathy
$42,105 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello Employer, thanks for viewing my proposal !! My name is Darshan Singh and I am expert in data entry and google stuff. I understand your requirement and ready to work. Please send me the demo data to check out my ability and reliability. If there will be needed I could send you the details and references of my previous work. I have 4 years of experience in Customer service and 2 year of experience in data entry. Sharing the list of my skills below:- >>Customer Support Phone/ Chat/ Email >>Data Entry Online/ Offline >>Google-docs >>MS Excel >>MS-Word >>Google Analytics >>SEO >>SMO >>PHP As per your asked question:- The VLOOKUP function performs a vertical lookup by searching for a value in the left-most column of the table and returning the value in the same row in the index_number position. It helps in many ways, it prevent us from repeating same exercise again and again. I believe communication is a key to any successful project, and I'd like to start thing off on the right foot but suggesting we schedule a Skype or Mail to discuss the project further. Thanks & Regards, Darshan Singh
$22,222 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I Promise to deliver the work in time. My experience in doing the work completion will help to do this work. I promise to surprise my employer for my accuracy and honesty for the work completion.
$38,888 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$36,842 USD in 20 days
0.0 (0 reviews)
5.4
5.4
User Avatar
your project is ambiguous, the task is not clear, the volume of work too. you can test me with a sample.
$35,555 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
i have working experience in field of demand by a clients . i f i get a project then i have ability to complete work wtih good accuracy
$22,222 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Предложение еще не подано
$20,000 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have more than 10 years exerperience in ETL processing, merging datas from different files, etc. So i am right person to do this succesfully. I worked in one top US company with United Health group. Please let me know if you are ok with this. I need more details about, any specific tools using for this. I can be available to India mobile 91-9840421450
$38,888 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Good afternoon, Is important to use the v-lookup function because the unique identifier is a piece of information that all of your data sources share or if we speak about multiple U.I., they are somehow linked across sheets. So, in order to correctly gather all the information regarding a specific U.I., it's necessary to use this formula and not the copy/paste option because otherwise the information can be mixed. Thank you
$27,777 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
i have experience in excel typing work from image of pdf. also can do the work of data manipulation within excel sheets.
$38,888 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, Good Day...! I am from dsoftronics, India. We have team of 18 persons. We all are excel expert. We would like to do this project. Please PM me for more discussion. Thanks, Hiren Sinojiya
$32,222 USD in 20 days
0.0 (0 reviews)
0.7
0.7
User Avatar
We will provide perfect solution as expected. we have very god experience in Delivery perspective. We are more user friendly and will give production support for 3 months after delivery of solution
$38,888 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$38,888 USD in 5 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of INDIA
India
0.0
0
Member since Aug 21, 2015

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.