Hi I have a data file, for which I need to create Visual Basic script to write these rules for example. Sample rules posted below for reference. Final set of rules will be shared with the selected coder.
Rules based on Asset Condition:
1. If AssetCondition=Good/Fair-Food and ReviseRul=0 and RULCalculated<=10, highlight all 3 cells.
2. If AssetCondition=Good/Fair-Good and ReviseRul=1 and RULOverride<=10, highlight all 3 cells.
3. If AssetCondition=Fair/Poor-Fair/Poor and ReviseRul=0 and RULCalculated>10, highlight all 3 cells.
4. If AssetCondition=Fair/Poor-Fair/Poor and ReviseRul=1 and RULOverride>10, highlight all 3 cells.
5. If AssetCondition=Fair/Poor-Fair/Poor and PlanType!=Deferred Maintenance, highlight both cells.
6. If AssetCondition=Good/Fair-Food and PlanType=Deferred Maintenance, highlight both cells.
7. If AssetCondition=Good and ConditionRating!=0, highlight both cells.
8. If AssetCondition=Fair-Good and ConditionRating!=1, highlight both cells.
9. If AssetCondition=Fair and ConditionRating!=2, highlight both cells.
10. If AssetCondition=Poor-Fair and ConditionRating!=3, highlight both cells.
11. If AssetCondition=Poor and ConditionRating!=4, highlight both cells.
Rules based on Priority:
12. If Priority=Priority 1 and Level 5 does not include any of the following words=UPS, Emergency, Fire, Annunciation, Generator, Sprinkler, highlight both cells.
13. If Priority=Priority 2 or Priority 3 and Level 5 includes any of the following words=UPS, Emergency, Fire, Annunciation, Generator, Sprinkler, highlight both cells.
14. If Priority=Priority 2 and PlanType!=Deferred Maintenance, highlight both cells.
15. If Priority=Priority 3 and PlanType=Deferred Maintenance, highlight both cells.
Rules based on PlanType
16. If PlanType=Deferred Maintenance and ReviseRUL=0 and RULCalculated>5, highlight all 3 cells.
17. If PlanType=Deferred Maintenance and ReviseRUL=1 and RULOverride>5, highlight all 3 cells.
Age and RUL based Rules
18. If Age!=Current Year-YearinService, highlight both cells.
19. If RULCalculated!=YearinService+EUL-Current Year, highlight all 3 cells.
20. If RULOverride=blank and ReviseRUL=1, highlight both cells.
21. If ReviseRUL=1 and RULOverride=blank, highlight both cells.
22. If ReviseRUL=0 and RULOverride!blank, highlight both cells.
"""""""""""""""""""""""""EXCEL VBA EXPERT"""""""""""""""""""""""""
Sir,
I am EXCEL VBA MACRO Advanced Level Expert. This is basic work for me. I can complete this project with added quality.
About me
I am a Chartered Accountant with more than 4 years of experience from the worlds leading Accountancy and auditing firm ""PWC"". I can handle this task very efficiently and you can expect 100% accuracy from me. I am Microsoft Excel, accounting, auditing, financial statements, Form Creation in Excel through VBA and in Google Sheet, QuickBooks, and Sage expert. I have been working here from the last 1.5 year and I have 224+ 5 stars reviews here. I am not new to work. I know how to meet strict deadlines without compromising the quality of the work. I will also be available for any query after the job is done as I am building my clients. please be my client and get any type of accountancy, Excel, QuickBooks, and auditing-related work with quality, efficiency, and at reduced rates.
Note. The price is negotiable.
I will be available for any query round the clock even if the project is completed.
Regards
Arman Kakar
I AM AVAILABLE RIGHT NOW
------------------------------------------------
Greetings!
-----------------
I’m very much interested to your requirements and Job openings. I am a Professional in VBA Macro Excel with more years of experience, therefore, I can easily do this job. You can message me to discuss the detail and make sample for you.
----------------------
Mohamed A.
----------------------
Hello How are you ? I haver read your job description and I am very interested in your project . I am very familiar with excel macro and I can implement your requirement with quality of result. I Please shoot me message and let us start working right now . Looking forward to hearing from you . Anton
Hello, I read your project details and really interested in your mentioned job. I have 5+ years’ experience doing similar jobs related to these skills Visual Basic, Excel Macros, Excel, PHP and VB.NET. I think its doable job, and really confident to do that. Please start the chart so we have detail discussion about task and finalize it as per your timeline.
Regards
Umair
Hello, there? This is Eduardo from Australia.
I am happy to bid to your project.
I have good experience in VB Script, Excel VBA.
I have understood what you want to do. I can deliver good result in short time.
Looking forward to hearing from you. Thank you.
Hello,
I'm Hoang, a System Admin.
I have 5-years of experience working with IT-Helpdesk position and Office 365 service.
I can help you create a VBA script to process those rules.
Please consider and contact me, we will discuss all the requirements/problems needed to resolve.
We can remote access via TeamViewer or AnyDesk.
Thank you.
Hello respected client! Customer satisfaction is my greatest pleasure!
Thanks for posting. I am happy to send my proposal on this project. The field you need is my special.
I assure you if you work with me once you will WORK WITH ME AGAIN IN FUTURE
I can give you the best quality WORK AND 100% SATISFACTION on time and with a fair budget.
Looking forward to discuss it further via chat.
Thanks & Regards.
“I can complete your project on time and within your budget.” on similar projects to what you are looking for, and I am confident I can exceed your expectations.” 3) “I can achieve the results that you are asking for.” 4) “I have attached samples of work very similar to what you are seeking.”
Hello there,
I read your requirements . I am sufficiently certain that you will be completely fulfilled by my work as I am very much experienced about it. So if you want a quick and excellent work with minimum time limit then here i am for this. Kindly, award me this project so that we can discuss it briefly and start the work.
Thank you!
Abu
Dear Client. When it comes to your project, i am expert. I will provide you 100% satisfaction work and full service. It would be great if you hire me. Based on your feedback, I can draft my proposal accurately and from there I can get started. Hence, I look forward to hear back from you in order to proceed ahead accordingly. Let's Go Thanks a lot. ( most important first project is 50% discount and buy 2 get 1 free (like if you give more than 2 projects last project will be free of cost )
I am excdel expert I will give you best solutions
Hey Shweta Kishor D.,
Good morning!
I’ve carefully checked your requirements and really interested in this job.
I am a PHP expert with 8 years of experience. I have worked on many successful projects for 8 years.
I can complete your project on time and your will experience great satisfaction with me.
I’m well versed in PHP, html/css as well as javascript and jquery.
I have rich experienced in PHP, Excel Macros, Visual Basic, VB.NET and Excel.
For more information about me, please refer to my portfolios.
I am checking your attachment, I'll update you shortly...
I’m ready to discuss your project and start immediately.
Looking forward to hearing you back and discussing all details..
Always happy to hear from you