We are in preparation for the mid-point review here. As mentioned a few posts back, while we have decided to cease activity on the excel spreadsheet and focus more on the userform instead, some things still had to be touched up so that it can be presented as our initial work for the mid point review.

Now, our excel spreadsheet, albeit having its limitations, is in presentable shape. As such, we can now focus much more of our time on the userform here.

As the mid-point review is just around the corner, we have to rush to finish the steps for at least one activity to be presented to the panel, and adjust a few bugs and error messages we got along the way and also check for any typos.

here are some screenshots of where our userform stands now.

This is the start page

As you can see, we have an extremely limited amount of hazards for now, as time is short and we dont have enough of it to complete the list before the mid point review.

 So is the activity. As of now, only one activity (tester) can be completed. We will add in more. This is once again, for demonstration purposes.

The user info page

Wish us all the best for our mid-point review!
More updates after

An update on our excel spreadsheet. This is the final layout we will be using during our presentation for the midpoint review.

Here are a few images of the data entry page

This is the layout of the activity and hazard identification part of our risk assessment activity

There is a new function that we have added allowing the user to choose the number of hazards associated with a particularly activity. When a number is entered into the box as shown below, a corresponding number of blank rows will appear to allow the user to input their different hazards.

Finally the review page is properly linked with our data entry.

E.g. 2 hazards are chosen in the data entry page for an activity. The green arrow shows that it is still the same activity and that 2 hazards are under it. The red arrow shows that a note will be given at the side of the page to show the number of hazards associated with the given activity. When printing of the review page, the note is not included. That is because the dotted lines show the boundaries for one printed page.