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.
36 freelancers are bidding on average $157 for this job
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