I have a list of car parts that each have a specific condition (Good, poor, fair etc.) Each part belongs to a particular car, and I want to evaluate the condition of each part and show the overall condition of the car as the condition of the worst part i.e. if the engine and driveshaft for car 1 is in a critical condition, then the overall condition for car 1 will also be critical. I need to show what part/s from each car have the lowest condition as well, so in this case the overall car 1 condition will read "Critical: See Engine Car 1 and Driveshaft Car 1".
The formula needs to remain functional after sorting/filtering, which is what I have been having trouble with. I have attached a file which shows what I want the "Overall car condition" column to look like once the formula has been created.
Please only respond if you fully understand what I am after and have experience in creating VBA scripts within Excel.
Expert Excel Programmer on freelancer.com and have been featured by the freelancer community https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-story)
I am an Engineering Graduate with an MBA degree. If you see I have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you.
Please pay me once job is 100% done.
Greetings!
I have reviewed your requirements and understand what needs to be done. It would be easier to deal with this requirement using Macros. Being a full time freelancer working exclusively on Excel based projects, I work on developing such Excel based automation every single day.
I have 18 years experience in using Excel as part of my daily work life. In the process I have implemented lot of automation similar to what you are expecting as well as dashboards for Management Reporting. In fact, over the last 19 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. Looking forward to hearing a positive response from you.
Have a Great Day!
Srinivasan Krishnamoorthi
Hi,
I am expert in Excel and vba with experience of completing over 100 Excel VBA related here.
I am available to work on the project right now and assure you a complete macro script within 2 hours.
Lets start now and get it done quickly.
Thanks
I can do exactly what you need. I'm a computer science professional with extensive experience in automation of data acquisition, processing, analysis, and presentation in Excel using formulas and macros (VBA scripts). I've done a lot of similar work.
Please have a look at some Excel projects I've done:
https://www.freelancer.com/projects/Excel/Calculate-the-semi-deviation-each/
https://www.freelancer.com/projects/Excel/Recreate-online-calculator-using-Excel/
https://www.freelancer.com/projects/Excel/Build-Excel-reports-dashboard/
With respect to this project I would like to present myself as a candidate for your consideration. I have more than 8 years of IT experience. I have successfully completed few projects which involved Programming, scripting, web scraping.
Key features of my work are as follows:
1) Always within schedule
2) Always within scope
3) Best tools and techniques used for the completion of tasks
Looking forward to hear from you.
Regards
Hello there, after reading your project description and with a drive for excellence, with a keen attention to details and with more than 10 years experience working with Microsoft office, i can develop the necessary vba for your job in the least time. I will do all and extra to ensure that you won't regret giving me this project. Thanks
Hi there, thanks for the excel file. I got an understanding of your concern and VBA required to resolve this. Please reply, we can discuss further and get it started soon. Thank you!
I have had a look at your sheet and would love to help you out with your custom function!
I would like to make the following layout changes to your sheet though to ensure a more stable solution:
1. Would you open to be converting your filtered list to a proper data table? That way the forumlae will all automatically autofill down when you enter a new row (data tables will still have filters attached as per your sheet)
2. It would be a lot more robust solution if the part name and car columns were split, as I am assuming in practice your cars won't all be named 'Car 1', 'Car 2' etc. and it would be a bit more challenging to determine the car matches from a programmatic standpoint
3. Add a mapping table which orders the car condition (so New is best and Critical is the worst)
From there I would add two customer functions - one which returns the minimum overall condition for the car which is added to the 'Condition' column, and one which returns the parts which are in that condition.
About me: I am a technical business analyst with 15 years professional experience with Excel and VBA. I am detail orientated and have an eye for spotting patterns, a creative problem solving approach, and an excellent work ethic. I am passionate about Excel and small businesses - I love using tools which most people are familiar with to build solutions to save busy people time
Hi Sir,
What I understand from description and sheet that you want to evaluate over all condition of car on the basis of the condition of its parts.
I can work out on it.
I’ve strong excel and vba programming skills.
Kindly text me for further details.
Regards
Awais Jehangir
Hi
I'm an expert in .Net technologies and SQL Server.
I have been working in software development for the last 20 years
I'm a specialist in web solutions and desktop applications
I'm also available 24 x 7
Regards
Carlos
I have written many macros in Excel. I have studied your project. On the last column the macro will provide the component(s)_ which is(are) in the worst condition and gives the condition of the car accordingly
Done similar with Project risk analysis - if any of (7) risk factors = red , overall condition =red. Would need to see raw data and may have some simple solution vs VB, but happy to take a deeper look at requirements.
Hi
What you are asking for cannot be done in 3 days, it can be done in 1. Possibly without any vb scripts needed so it can run with no issues with formulas in your existing spreadsheet. Just seems like a combination of If and concatenate formulas. Please PM me so we can discuss what you have already tried and how to solve this for good.
Kind regards
John
I will be happy to help you in doing this project. I will give you 2 formulas. one to show you the conditionbl of the car and the other will guide you to the parts you need to see. I can combine the formulas into one column if you need.
Looking forward to hear from you :)
hello,sir. I'm a professional programmer with 6 years of experience. I've already done this kind of project before. If you award me, I'll implement all of your requirements in a short time.
ProjectName:Write a VBA script in Excel to organise data
Relevant Skills: Excel, Visual Basic,
