Find Jobs
Hire Freelancers

An Excel Workbook Capable of Tracking worker qualifications

$250-750 USD

Completed
Posted about 10 years ago

$250-750 USD

Paid on delivery
The spreadsheet is a Qualification Tracker. Some qualifications have a predetermined time frame in which they need to be completed or else will be marked as Delinquent. The spreadsheet must be able to give a quick visual of who in the company is qualified, who is in work and who is delinquent. It should also flag when the qualification falls dink. It should be able to give a graphic representation per qualification category in a separate Summary Sheet. The qualifications to be tracked can be categorized as: Damage Control, 3M, NEC, Licenses, Classes, GMT, NAVOSH, Medicals, CPR, Basic Requirements. I will provide the list of every single qualification that needs to be tracked. The ability to add names for new workers, delete names, or even add extra qualifications should be offered. if you think you can make this project a reality please contact me at
Project ID: 5477236

About the project

21 proposals
Remote project
Active 10 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
Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementaiton.
$250 USD in 0 day
4.9 (324 reviews)
7.6
7.6
21 freelancers are bidding on average $412 USD for this job
User Avatar
Hi, your 5-star excel & vba coding expert is ready to help your project. pls check my profile and feedbacks first to have some idea about the quality of my work... I had many similar excel tasks, all achieved with 5/5 rating...I read your project descriptions carefully, I exactly got what you need and ready to go ahead if you wish to proceed with a top-rated and reliable partner here...I bid a very competitive amount for you. kindly note that I only deliver best quality at a reasonable price...awaiting your (+) reply to start...regards,
$526 USD in 15 days
4.9 (227 reviews)
7.3
7.3
User Avatar
Hi, My name is Jon and I will be happy to help you with this project. Need to see the file though. Please feel free to message me prior to accepting my bid
$250 USD in 2 days
4.9 (253 reviews)
7.6
7.6
User Avatar
Hi Robert. The qualification tracker sheet can be developed in 3 to 4 days just as you desire. It shall have the ability to both Add/Delete names and Add/Delete qualifications I have done very similar projects in Excel before and I can manage this one for you too. Kindly share a sample sheet and discuss so we may begin. Regards. Usman.
$340 USD in 4 days
5.0 (72 reviews)
6.8
6.8
User Avatar
Hello, I have a degree in Business and use excel every day as part of my job. I understand that this is a spreadsheet for some kind of control. But not well described. If I could interpret well what you need there, would bid appropriately.
$250 USD in 5 days
5.0 (171 reviews)
6.7
6.7
User Avatar
Dear Sir/Madam I'm an expert in advanced excel features and I can perform this task perfectly. I have already developed such kind of qualification and objective tracking excel models which are linked to performance evaluation. If you need I can send you samples too You can visit my profile to see my reliability (5/5 rating with the best completion rate) and if you are comfortable, I am ready to start this task I assure you that I will go beyond your expectations I look forward to hearing from you Best regards Priyal
$250 USD in 4 days
5.0 (162 reviews)
6.6
6.6
User Avatar
Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive response. Thanks.
$250 USD in 10 days
4.9 (123 reviews)
6.2
6.2
User Avatar
Hi, I am interested in this project. I am an experienced IT professional with 13 years of experience. I can do this for you. I have extensive experience of EXCEL and vba. if interested in hiring me then please let me know so that we can discuss the scope, timelines and budget accordingly. Thanks. Regards, Jawad
$250 USD in 10 days
5.0 (74 reviews)
5.7
5.7
User Avatar
Hello ruizrobert37, I am IT engineer with European diploma since 2005 Certified as Technical specialist in Microsoft SQL Server databases, i have more than 7 years in IT projects with 5 years working around Microsoft database (Access ,Sql Server) development and administration on several projects . My last job was database consultant within Accenture ,for more than 3 years .I worked for several projects relating with SQL Server and access databases on behalf of European Customers (Carrefour, LOREAL,Eurovia ..). I'm used to working with Access with MS Access environment to develop all types of requirements related (Forms ,Queries ,Reports ,Database conception and enhancements) ,and given my experience, I think I have all the skills to give High quality of work delivery withing budget and time Best regards,
$250 USD in 5 days
5.0 (12 reviews)
5.1
5.1
User Avatar
Hi, I understood the requirements, but I have a different way out to give you a better and ultimate solution. I would like to give you a web application for this work where you can use any device PC/mobile to get your job done easily. The spreadsheet method is not a long run solution. If interested please invite me on this project. Looking forward for your reply, regards, Nittile
$721 USD in 10 days
5.0 (1 review)
4.6
4.6
User Avatar
Hi, I build robust, strategic business solutions. Period. I've built an epmloyee time tracker before and this will have many of the same elements. PEDIGREE / PREVIOUS WORK My pedigree includes these (my own sites and my own developed software): My Excel and Access development site (I also TEACH development): vbafasttrack.com. I recently completed a project to build a Bitcoin trading application, a binomial and trinomial employee stock options model for a mid-tier US investment bank and have an Insto finance and trading background myself. I am also the developer of the following software freelancesniper. Be advised I have my own company doing this stuff and have an institutional IT background. Cheers. SteveP.
$650 USD in 10 days
5.0 (5 reviews)
4.8
4.8
User Avatar
Hello! I work for Microsoft and I do reports like this every week! I can create a dynamic pivot table for you that will be able to tally everyone up instantly. You'll be able to click a button and see the table change. For example, if you just want to see the Damage Control qualification, you can click on that and the whole table will be filtered to show you only the people who are qualified for that (or the reverse, all of the people who are NOT qualified). With conditional formatting, a second tab will show you a table of everyone along with the categories and a green check if they're qualified, a yellow exclamation if their qualification is about to expire (optional), or a red x if they're unqualified. And the best part is, that setting up the source tab as a special Excel table means that you can add as many people and/or categories as you'd like. All the pivot table does is summarize data, that means there's no fancy VBA code that will break down if you need to change things. If there's a new category you want to add, you just type it in and you'll see it in the table! It's all automatic and anyone can enter new data (ie: it doesn't have to be someone extremely proficient in Excel). I would suggest using some Data Validation (drop down menus to choose categories instead of typing them in - they're easy to set up and reduce data errors dramatically). That means adding NEW categories would take an extra step, but I could teach you how to do that very easily!
$250 USD in 2 days
5.0 (4 reviews)
3.5
3.5
User Avatar
Hello, I can do this work in no time. I have created this type of reports for my day work. I am a supervisor and I always need to track and provide charts and feedback's about the entire plant to my superiors. Check out my reviews and profile. Send me a private message to start working you will love what I can create for you! Regards
$260 USD in 2 days
5.0 (5 reviews)
3.0
3.0
User Avatar
Hi, I'm very interested helping you creating and designing your database, I have more then 7 years of experience in SQL and database administration, modeling, optimizing and manipulating. I've checked your requirement I can do this job in the deadline without a problem, because I've done many projects like this. Please send me all other details if you have about your project, so we can start asap. I'm available, and can start immediately. Looking forward to working with you. Thank you for your consideration. Regards
$630 USD in 7 days
4.7 (4 reviews)
2.2
2.2
User Avatar
Hi sir i am able to complete this project i am highly experience by MS Office and know about your project so please give me this project. Thank you. Regard : saad
$555 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$600 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I will bring over 19 years experience developing full-featured applications with Microsoft Excel to bear on this role. I am available and ready to begin immediately.
$555 USD in 10 days
0.0 (0 reviews)
2.6
2.6
User Avatar
Dear sir Greetings ! As I understand your requirements, I would like to post few details: - I would be able to provide you all the criteria based check on Excel. - Have Summary in graphical representation - Give options to add and delete rows which you not required in future - Add extra qualifications and parameters to track results. - I'll provide service even after project completion so that you can reach me for any additional help regarding this project at no extra cost. Hoping to hear from you. Regards Amit
$555 USD in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
suffolk, United States
5.0
1
Payment method verified
Member since Feb 23, 2014

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.