Find Jobs
Hire Freelancers

Building Customer Database for to maintain quarterly maintenance schedule

$10-30 USD

Completed
Posted about 4 years ago

$10-30 USD

Paid on delivery
I own company which is specialized into security systems like indoor and outdoor cameras. After installation of security system, one year contract will be signed with the customer and we will be responsible to do 4 times maintenance visits during the year to assure functionality of the system. However we don’t have any customer database that’s why I started to collect all customers information in excel sheet where all critical information for each customer should be available like : • Customer information details ( reference number , shop name, address , phone number etc..) , • System specification ( no. of cameras, model number, brand name etc..) • Contract and maintenance dates which include date of contract signatures and dates of 4 times visits across the year. each visit will be 3 or 4 months PLEASE UNDERSTAND THE FOLLOWING : the sheet already created . i just need to enhance it with some excel features like conditional formatting , formulas and fitering option. this is what i need only . no database no php no web application nothing it is just an enhancement of exiting excell sheet. this is very simple project. Check the attached excel sheet which shows my customer database sheet. This is where we can start and build.
Project ID: 24138442

About the project

21 proposals
Remote project
Active 4 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
Hello, I have read the project description and understood it. I would suggest you go for using CRM software instead of an excel sheet. You can update all the data in the CRM software, if you don't have time, I can help you with that. You can put dates of visits for each client, and it will notify you of what to do with a particular customer. It is really very easy to track. You can that by yourself only, or I can help you set it up everything if required. Let me know if you have any questions and I will be happy to answer. I focus mainly on the quality of work. I assure the employer's satisfaction. Thus, most of my clients prefer to work with me again and I have a repeat hire rate of 58% which is highest among all the freelancers of my niche. Looking forward to working with you. Best Regards, Kuldeep Gera
$40 USD in 7 days
5.0 (22 reviews)
4.8
4.8
21 freelancers are bidding on average $181 USD for this job
User Avatar
Good Morning Abdulla J., This is Raman. We can help you with building customer database for to maintain quarterly maintenance schedule. As you can check doing Database projects is our core set of expertise. We have done more than twenty projects in past month alone. I would request you to send me a message to that we can get started. Thanks for reading and considering me. Raman
$250 USD in 7 days
4.9 (508 reviews)
8.8
8.8
User Avatar
Hello, I read your requirements and understood the things and your system. Currently you are handling your customers and their contract and maintenance services with the excel and it is kind of difficult to handle lot of things like monthly visits and report and all. I am experienced PHP developer and interested to build web system for you with backend MySQL database where you can handle your system's customers and everything with the web panel. Let me know if you are interested in my offer. Thanks.
$500 USD in 12 days
5.0 (603 reviews)
8.0
8.0
User Avatar
Hi, I can build a Customer Database for to maintain quarterly maintenance schedule in Php for you on time and according to your needs and requirements. feel free to have a look at my work portfolio: https://www.freelancer.com/u/webdroid Skills and expertise: HTML5 , CSS3, JAVASCRIPT,Jquery ,Bootstrap,ajax,PHP ,Mysql ,Laravel ,Codignator,ecommerce ,UI UX, API integration, payment module integration,Web scrapping. Let's connect in chat
$150 USD in 6 days
4.9 (38 reviews)
6.3
6.3
User Avatar
Honest and reliable Australian company delivering on-time. 1) We deliver what we promise 2) Friendly customer service 3) Skilled professionals Please note that we placed a bid to initiate the conversation but we will require specific instructions and details in order to provide you with an accurate price estimate. Database Administration, Excel, Microsoft Access, MySQL, PHP
$450 USD in 7 days
4.9 (7 reviews)
5.7
5.7
User Avatar
Hello, I have gone through your project description and I can confirm that l am deem fit to deliver it as expected. I am a senior web developer with plenty of experience and creativity. Kindly contact me so that we can discuss more on the specifics. Thank you
$28 USD in 3 days
5.0 (108 reviews)
5.8
5.8
User Avatar
Hi, I understand your current issue with Customer Management via Excel Sheets. My recommend plan: - We discuss together about the functions you want on the customer database system, like how to filter customer, how to schedule maintenance plan, etc. - I will develop the system with Import function so you can import current data from excel files and add new customer via the system dashboard or import later. - We do test and deploy the system to go live Please contact me if you interest so we can discuss more in details. Regards, Tan.
$1,200 USD in 15 days
4.9 (74 reviews)
5.8
5.8
User Avatar
Greetings boss, We will be more than happy to help you because we are professionals with more than 5YEARS experience. ✓What matters most to us are; your trust, perfect functionality of your project, time uniformity and quick delivery. ✓We work in assemblage of professional computer science graduates under Shaunlee Global Circle Limited, we have several skills and expertise. ✓We can definitely give the best of your project. Kindly HIRE US and you will never regret hiring us.
$77 USD in 3 days
5.0 (19 reviews)
4.8
4.8
User Avatar
Hi, I understand that you want to optimize the excel file you already have. Maybe you will be interested to use a user friendly (easy to use) MS Access database to serve the purpose. If you are interested please get in touch. Thanks.
$60 USD in 3 days
4.9 (9 reviews)
4.9
4.9
User Avatar
Hi, I am an expert in Ms Excel with more than 10 years of experience. I have gone through your attached sheets. I can help you design a template for keep tracks of no of visits, next due visit, and management of plan for the next months also. We can discuss further, It can be done very fast, within 2 to 3 hours. Regards
$25 USD in 1 day
5.0 (9 reviews)
3.5
3.5
User Avatar
Hello there, *******I CAN JOIN YOU FOR IMMEDIATE WORKING******* I have excellent 5+ years of experience in web development. I have quality skills in web development and design. I also have great experience in mobile application development and website development as well. My skills of web development ( frameworks of JAVA,PHP,PYTHON(Django,Flask),JS(Angular JS, Backbone JS, React JS, node JS, Express JS, Gulf JS) Also HTML 5,CSS,CSS 3 & LESS. I assure you that I will complete my work in a given time. #Assurity of satisfaction. #Quality and rapid work. Thanks & Regards
$238 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello dear, I am a professional content writer, with over 5 years of experience. My skill set comprises of web content writing, product related content, blog or article writing, SEO optimized content, app descriptions, testimonials, etc. I apply my styles and techniques that will work to suit my client’s needs. I'm a full-time ONE-MAN-TEAM Content Writer who provides a UNREASONABLE-QUALITY for a REASONABLE-PRICE. Hey! Could you please send me a message so we could discuss this project? Regards.
$20 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I see that you need some help data entry jobs in your business. I can help with that and can start right away. I’m a great fit for this role because as a finance/administration professional, my goals are to help you to execute your job accurately. I’ve worked with lots of small and large businesses and recorded data, created a spreadsheet and booked vendor invoices, issued outcoming invoices, created financial statements, provided administrative and financial assistance, I can help make your life easier by taking some of the load off of you. Do you have any questions for me? Thank you for your time. Adrienn
$20 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
hello there!! I read your project’s details and ready to work on it. I have experience in excel programme. feel free to contact me and know more details if any. you are welcome at any time.
$10 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Greetings I hold experience in administration assitance as well as some writing skills in English and French languages. You will not hesitate to count on my great motivation to respond to your needs. Relevant Skills and Experience Data entry, transaltion skills in french or English, WEB research, virtual assistant related to any admnistrative task, writing skills, etc You won't be disassapointed
$55 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi There, I can help you with the work as i have knowledge in this kind of work due to my past experience in my job. If given an opportunity i assure you the work will be delivered with precision and utmost accuracy.
$10 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
As a data entry expert i will do the job with my best. And I will also deliver it in just time. So this is just for you.
$25 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Playing with spreadsheets since 2 years and now have advanced knowledge of excel formulas and shortcuts.
$20 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am a data entry professional. I have more than 2 years of data entry and Excel work experience, also have 100% track record of delivering projects on time.
$18 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED ARAB EMIRATES
Abu Dhabi, United Arab Emirates
5.0
6
Payment method verified
Member since Aug 9, 2016

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.