Excel spreadsheet improvements and automation

Completed Posted 5 years ago Paid on delivery
Completed Paid on delivery

Wondering if you can help me format/automate the attached spreadsheet that we’re intending to use for the tracking of our fleet maintenance and renewals.

I’d like your assistance with the following, by tab:

“Fleet listing”

• REG. EXPIRY Set in day/month/year format, cell to go red when entered date is prior to current date, orange when within 30-days of current date, and green when beyond 30-days of current date (in the future)

• COF EXPIRY Set in day/month/year format, cell to go red when entered date is prior to current date, orange when within 30-days of current date, and green when beyond 30-days of current date (in the future)

• COF IMMINENT Set in day/month/year format, cell to go orange when current date within 30-days of entered date

• LAST SERVICE Set in day/month/year format, cell to go red when current date greater than 30-days in the past

• SERVCE DUE Set in day/month/year format, cell to go orange when current date within 21-days of entered date

• CHAIN CERT Set in day/month/year format, cell to go orange when current date within 30-days of entered date

• CURTAIN CERT Set in day/month/year format, cell to go orange when current date within 30-days of entered date

• CURRENT ISSUES Drawing through each individual issue from “Issues – current” tab (as per the below)

• RESOLVED Tick-box next to each issue. Once ticked, the issue (and fleet number) will then move to the “Issues – completed” tab

“Issues – current”

This tab is to be used for new ‘issues’ to be entered and assigned to individual vehicles in the fleet. Note that these will be often be entered as multiple issues in one go, but I’d like each to be entered a new row. The issues will then pull through to the “Fleet listing” tab against each corresponding fleet number. Ideally the format is as follows:

• Fleet number A drop-down selection that allows the corresponding fleet number to be selected

• Current issue Free-text area to type description of issue in

• Some mechanism to allow them to be re-sorted by fleet number each time new issues are added, to enable ease of viewing of all issues for a given fleet number together

Data Entry Data Processing Excel

Project ID: #17134595

About the project

9 proposals Remote project Active 5 years ago

Awarded to:

ksriniravi

Greetings! I understand the requirements clearly. However the attached file "Truck [login to view URL]" does not have the tabs (Fleet listing, "Issues Current) that you are referring - please share the pertinent file. Be More

$80 NZD in 2 days
(156 Reviews)
6.6

9 freelancers are bidding on average $165 for this job

TechnoGuruu

Hi, I have 10+ years industrial experience in Excel, formals, functions, macros etc. I have checked your project post in details and I can build this fully automated spreadsheet for you. Please give me this opportun More

$166 NZD in 3 days
(50 Reviews)
5.3
pilotarif

I can perfectly do your project work and able to complete full work in a shortest possible of time with 100% accuracy, perfection and according to your given instruction. I am ready to show you cost-free sample wo More

$155 NZD in 3 days
(36 Reviews)
4.7
c4cuteconain

With excel I have a decade of experience and can help you in any way you want. Send me a message and we can start working

$150 NZD in 3 days
(35 Reviews)
4.9
haleem0786

I can do this. please review my profile and inbox me. I have good command over MS Excel especially povit table, chart, advance formulas, formatting, etc. thanks

$150 NZD in 3 days
(15 Reviews)
3.6
dracopaladine

I know you asked for an Excel spread sheet to be used, but what you are asking to be built would be better suited if you were to use a web application. I created the fleet reporting software and reporting system FEMA More

$388 NZD in 14 days
(1 Review)
3.7
AlieGhazanfar

"Greetings! My name is Ali Ghazanfar and I am an expert in Data Entry. I would love to have the opportunity to discuss your project with you. I am ready to do work with you and understand that what you need in your More

$111 NZD in 2 days
(11 Reviews)
2.9
kreativeapostle

kindly consider my application for the task

$36 NZD in 1 day
(2 Reviews)
0.9
Mariahighness

I have handled excel files before. Please let me know i can work on it.

$250 NZD in 3 days
(0 Reviews)
0.0