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.
21 pekerja bebas membida secara purata $299 untuk pekerjaan ini
Hi, I am an Excel macro expert and would be happy to take on your project. I have studies the files and can deliver the requirements within 3 days. Kindly confirm. Thanks, Arul
I can do this. please review my profile and inbox me. I have good command over MS Excel especially povit table, charts, advance formulas, formatting, macro, VBA etc. thanks