Find Jobs
Hire Freelancers

Geographic Client Organization Spreadsheet

$750-1500 USD

Closed
Posted about 1 month ago

$750-1500 USD

Paid on delivery
I need an expert in data organization and geographic systems to help create a spreadsheet for our clients. We currently handle a large number of clients, and it's becoming a challenge to manage their locations efficiently. Key requirements for this project include: - Collate the city, state, and street address for each client. - Sort the listing according to proximity, with only latitude and longitude coordinates information. - Design the spreadsheet to be intuitive, easy to use, and update. The ideal freelancer for this job should have: - Proven experience in data organization - Excellent knowledge in geographic systems - At least basic understanding of latitude and longitude calculations. The end goal is to have a clear, concise, and accurate spreadsheet of all our clients organized by location. This is to help improve both internal operations, and our ability to serve our clients. We do not have the latitude and longitude coordinates in the spreadsheet. Our business requires our clients to use our service once a year in the same month as the previous year. So right now we organize by month. We have the months categorized as unscheduled and scheduled. we move the client from unscheduled to scheduled after we have them on our service calendar. Always trying to schedule so clients are somewhat nearby in a given week so it would be nice to change the spreadsheet view to a geographical one then back to the current one.
Project ID: 37954141

About the project

25 proposals
Remote project
Active 4 days 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 $928 USD for this job
User Avatar
Hello. I am a certified Excel professional. I believe for this functionality we will need to use Power BI or Google Data studio as maps won’t work on Excel. I am happy to discuss the project further. We will need to sort the data properly and have a separate column for date and notes. Moreover, we could move it a cloud solution as well and based on their time of the services we could send email reminders too. Best, Aisha
$1,500 USD in 7 days
5.0 (462 reviews)
9.2
9.2
User Avatar
Hi, I can organize the geographical client database. I can make a sample for you. I am a top-rated freelancer in Freelancer.com. Data entry job is my passion and I have 7+ years of experience in this field. I’ve worked on several similar projects including web scraping, web search, excel formulation and shopify product listing. You may see my profile here: Freelancer.com: https://www.freelancer.com/u/motiur03.html I have completed over 700 projects on freelancer.com and have extensive knowledge and experience in similar jobs, so I can handle this project accurately. Message me so we can discuss more. Best Regards Motiur
$750 USD in 4 days
4.8 (420 reviews)
8.2
8.2
User Avatar
Hello, I have read the job description and am ready to start now. Please send me a message so that we can discuss more. Many thanks, Md Jahangir Hossain
$750 USD in 7 days
4.7 (278 reviews)
6.9
6.9
User Avatar
With your project description, I understand that the accuracy and efficiency of data organization are crucial in streamlining your operations and improving your client services. Combining my extensive experience in data management with my advanced knowledge of Excel, I will create a geographically organized spreadsheet that perfectly aligns with your needs. Furthermore, having managed complex financial data, I can bring that same level of meticulousness to organizing your client information. One of the unique challenges you're facing is the lack of Latitude and Longitude coordinates. As someone who values problem-solving, I've already devised a solution. By utilizing diverse tools such as Google Maps API and open-source mapping software, I can convert addresses to coordinates and integrate them directly into the spreadsheet. This way you can switch between geographical and current views with ease. Another aspect of my profile is my alignment with upcoming trends in the field of data analytics and visualizations which enables me to fabricate not only an intuitive but also an insightful client location management system for you. My goal is to deliver work that doesn't just meet expectations but exceeds them. I look forward to bringing my expertise to your project and transforming how you handle client data.
$1,125 USD in 7 days
5.0 (20 reviews)
5.9
5.9
User Avatar
Hi there I am an experienced data organization expert with a strong background in geographic systems. I have successfully worked on similar projects, collating location data and sorting it based on proximity using latitude and longitude coordinates. I have a solid understanding of latitude and longitude calculations and can design a user-friendly spreadsheet for your clients. My goal is to create a clear and accurate layout that will enhance your internal operations and client service. I am confident that I can deliver the results you are looking for efficiently and effectively. I can provide links to similar works from my portfolio. Please go through my profile its 15 years old see the work I did over the years. ---> No Win No Fee means that your satisfaction is my utmost priority. <---- Lets discuss the job details. Moreover, I am willing to start the job and perform tasks without even being hired; it is just to show my commitment to this project. Looking forward to hear from you. Regards Shah
$975 USD in 7 days
4.9 (11 reviews)
5.5
5.5

About the client

Flag of UNITED STATES
Minneapolis, United States
0.0
0
Payment method verified
Member since Aug 3, 2023

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.