Microsoft Excel Visual Basic
$30-250 AUD
Paid on delivery
I am using an old Excel Spreadsheet that has been modified with many Macros to automate a "Risk Management Tool". At the click of a button, I can choose the severity and likelihood factors for risk ranking work tasks on a construction site. There is an "Add-Ins" tab that allows the user to insert rows, delete rows, rank risks from highest to lowest, number the tasks, sort order and many other things. The problem I have is that I want to upgrade the risk tool so it uses a larger RISK MATRIX. Where there were 25 possibilities to rank risks from Low to Extreme, I need to expand to 42 possible risk rankings.
I have attached 3 spreadsheets:
• ORIGINAL WRAC [login to view URL]
• ORIGINAL WRAC TEMPLATE (Populated).xlsm
• NEW WRAC TEMPLATE .xlsm
I have already done a lot of work on the NEW WRAC TEMPLATE. It has the Risk Matrix I want to use with 42 boxes and the new ranking system. I would like someone to make this new template to work exactly like the ORIGINAL WRAC TEMPLATE does.
I have Populated the ORIGINAL WRAC TEMPLATE (Populated) with some items so you can see how the spreadsheets macros work. In the "Add Ins" tab are all the Macros. The "Update Tables" button ranks all of the items into the Risk Map (Before Treatment and After Treatment) and lists them in the "Risk Summary" from the highest to the lowest risk.
This gig requires you to create a new Workbook out of the NEW WRAC TEMPLATE format that works the same as the Original Template does when you "Update Tables". The successful bidder will know how to write Visual Basic and re-write the code so that the new risk matrix is functional.
Project ID: #18182542
About the project
31 freelancers are bidding on average $171 for this job
Hello, We can do this with 100% Quality with On-time delivery. Please allow us to take this opportunity. Thanks.
Hi there My name is Carlos and I'm an expert in .Net and sql server. I have been working in software developement for the last 20 years. I have many experience in desktop and web development. Regards
"Hello, I am happy to inform you that I have read your current project description and understood all of your required requirement. I'd like to help you with confidence and satisfying results. I have professional wor More
"Greetings! According to your stated project description you need an Google sheet and excel expert. I read your job description and understood. Yes, my experienced service will help you all about MS program. Just se More
I m an expert in microsoft excle. With a experience of 3 years Relevant Skills and Experience I am a professional data entry worker for a chartered accountant firm
Sir, I have excellent knowledge of excel with more than 3 year provided high speed. I will not disappoint you also, delivered work in time with high accuracy. Relevant Skills and Experience I have excellent knowledge More
Sir can u please hand over to me this job. I will work for the best to complete this work. I request u sir
i have excellent skills i have excellent skills i have excellent skills i have excellent skills i have excellent skills i have excellent skills i have excellent skills i have excellent skills
Hello Good day, I'm Gerald Jay Cabigon. I'm interested of your Job posting. If got a chance I will be your asset and not a liability in your company. You can contact me this number +639675789434 Relevant Skills and Ex More