Find Jobs
Hire Freelancers

Database extractions - 30/11/2023 21:46 EST

$30-250 AUD

Completed
Posted 6 months ago

$30-250 AUD

Paid on delivery
Need a new spreadsheet created based on combining two different spreadsheets (with matching data). The new spreadsheet needs to still have 3 sheets (Cat 1, Cat 2, Cat 3) any data that does not match these values can go into a 4th sheet called "other". One Spreadsheet (3G FIS 021123) has all the jobs set out into categories (namely Cat 1, Cat 2 and Cat 3) however it does not include all the additional information we need with the jobs such as the contact details, meter location etc. The second spreadsheet (Copy of Formway Issued 3G works) has all the additional information we require but is not set out in the different sheets (Cat 1, Cat 2 and Cat 3). We will need to combine these two to ensure that we have the full range of data available. If there are some values or data that does match please do not delete, please retain and put into a 4th sheet called "other".
Project ID: 37495501

About the project

9 proposals
Remote project
Active 6 mos 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
$0 AUD in 1 day
5.0 (223 reviews)
8.0
8.0
9 freelancers are bidding on average $111 AUD for this job
User Avatar
Hello there! My name is Akriti and I'm a Google Sheets expert, Excel VBA expert and web development wizard. I understand that you need to combine two different spreadsheets (with matching data) to create a new spreadsheet with still having 3 sheets (Cat 1, Cat 2, Cat 3). If there are any values or data that do not match in the two spreadsheets, please don't delete them - instead put them into a 4th sheet called 'other'. I've worked with a variety of clients across a wide range of industries and have demonstrated my ability to deliver complex projects on time and within budget. I also place great emphasis on client satisfaction - ensuring that every aspect of your project is addressed with care and attention to detail. If you're interested in my services for this project please feel free to contact me so we can start discussing how we can work together. Thank you for considering me for this opportunity!
$200 AUD in 1 day
5.0 (322 reviews)
7.3
7.3
User Avatar
Hi Hope you are doing good, I can perfectly help you with that in quick turnaround. I am a professional Excel expert holding 7 years of experience in utilizing advance level tools, creating dynamic dashboards and Excel (including VBA and Macro) to perform Data Analysis, Data Visualization, Automation and complex calculations. I will be happy to discuss in detail how I am highly suitable for this project. Kind Regards Arun
$100 AUD in 1 day
5.0 (28 reviews)
5.4
5.4
User Avatar
Hello, I am an experienced spreadsheet specialist ready to seamlessly merge and organize your data from the two different spreadsheets. I will create a new spreadsheet with three distinct sheets (Cat 1, Cat 2, Cat 3) to align with your categorization requirements. The integration will be meticulous, ensuring that all relevant job details, including contact information and meter locations, are incorporated from the second spreadsheet while maintaining the categorical structure of the first. To handle non-matching data, I will establish a dedicated "other" sheet, preserving any values or information that doesn't fit the specified categories. My proficiency in spreadsheet management guarantees a streamlined and comprehensive solution, providing you with a single, organized document that combines the strengths of both original spreadsheets. I look forward to efficiently delivering the consolidated data set tailored to your specific needs. Regards, Zafar
$100 AUD in 2 days
5.0 (37 reviews)
4.4
4.4
User Avatar
Hello, Statistics, Web Scraping and Excel expert here. I can perfectly assist you with this and can start on an immediate basis. I am an experienced professional with years of experience in all the data analysis tools including Visual Basic, Automation, Data Analysis, Complex Formulas, Calculations, Analysis, Scrapy, PowerBi, Tableau Financial Modeling etc. To make your hiring decision easier, I can share the limited version quickly before you hire and then you can decide if this fulfills your needs or not. Lets discuss more in detail about my previous similar experience and how I am highly suitable for this project.
$80 AUD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I saw your description about this task. I gonna use Ms Excel. You need each sheet named cat..So contact me for more xtra information and delivery early
$200 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, how are you? Dear Hiring Manager, I am writing to express my interest in the spreadsheet creation project. I have a strong background in data management and Excel, and I understand the need to combine and organize data from different sources. My attention to detail ensures accurate categorization into sheets, and I will create a dedicated "other" sheet for unmatched data. I am confident in delivering a comprehensive and well-organized spreadsheet. Best Regards, Marco
$140 AUD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
SOUTHPORT, Australia
5.0
3
Payment method verified
Member since Sep 2, 2022

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.