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
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.
Being a full time freelancer working exclusively on Excel based projects, I work on such solutions every single day.
I have 18 years experience in using Excel as part of my daily work life. Over the last 24 MONTHS , I have spent at least 250 HOURS on automation in Excel every month.
If awarded, I can get your work completed to your fullest satisfaction.
Have a Great Weekend!
Srinivasan Krishnamoorthi
$80 NZD 2 gün içinde
5,0 (156 değerlendirme)
6,6
6,6
9 freelancers are bidding on average $165 NZD for this job
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 opportunity to work on your project.
Thank you,
Peter
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 work for the project right now. I can say undoubtedly that I am the right person for whom you are looking for your project.
Let’s discuss in PM so that we can start working on your project right away. I am waiting to have your quick positive reply. Thanks.
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
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 used to track the FEMA trailers being built, placed, and maintained after hurricanes Katrina and Rita.
Please open a chat window so that we may discuss your requirements in detail.
"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 given spreadsheet.
Moving forward, I can dedicate 40 hour/week for your job, and my daily hours are negotiable. I'm very excited to offer my services for your job. Please feel free to contact me directly to discuss this position further.
I am mostly available online on Freelancer App and on skype (alighazanfar123231). We can discuss there in detail in a quick way if you are interested.
Thanks