Now that the structure and formatting of our userform is more or less done, we have decided to divert more of our attention towards its main content, i.e the hazards definitions, lists, as well as whether to include it or not.
Firstly, prior research to this had to be done. The material that we used also had to give us a wider perspective on what we aimed to accomplish. As such, reading material from various sources was what we did.
However, we also decided as Singapore had one of the most stringent standards when coming to risk assessment, as well as the fact that our users for this user form would be based here in singaopore, taking the singapore standard as our base shouldnt mislead us too much.
Our sources include:
mom.gov.sg
epa.gov/riskassessment
hse.gov.uk
bfr.bund.de/en/home.html
groups.engin.umd.umich.edu/CIS/course.des/cis375/projects/risktable/risks.html

****edit****
now that the current hazards list is finalized, images will be uploaded after mid point review

We have arrived at a unanimous decision that macros is much more useful than just doing the usual excel, even though it is much more complicated, most of our user forms has been based on VBA.
Seeing that we have to do a basic of 3 types of ra, for office, lab, and plant, we began to construct the simplest one; office ra and turns out, it isnt as simple as we thought.

Also, our list of hazards and its details are still being constructed but through research and expanding our list, our current hazards is as so.

Mechanical hazard: Moving parts, loose parts that can be detached

Physical hazard: Heavy objects, sharp objects, objects that can cause scrapes, cuts and bruises

Chemical hazard: Corrosive chemicals, irritants, chemicals with extreme pH, highly volatile chemicals, carcinogenic chemicals

Knocking hazard: Sharp or hard protruding parts

Fire hazard: Flammable substances, surfaces with high temperatures, objects that can cause ignition

Freezing hazard: Surfaces with extremely cold temperature, sub zero environments, substances kept at extremely low temperatures

Toxic hazard: Liquids or gases that will cause adverse effects on our health when come close to

Electrical hazard: Objects using electricity, electrical outputs, electrical conductors

Radiation hazard: Objects that radioactive

Noise hazard: Loud noises that can cause hearing impairment, sounds that will affect your ability to work

Biological hazards: Bacteria, viruses, microorganisms

Visual hazards: Bright lights (Welding)

Environmental hazards: CFCs, pollutants

Another problem has surfaced in our user form. As shown, the default user form only has one name and designation to fill in, keeping things simple. However, as this form is on excel, adding names and designations would be highly impossible if the user so required.

This was a problem that even the functions on excel were unable to solve and as such, we had to rely on our proficiency on VBA macros programming. to achieve the following.

We made it such that when the user entered the number of names, the corresponding number of boxes would appear for the user to fill in.

Thus, when the user enters 3 names, 3 boxes would appear and if he enters 5, 5 boxes would appear.

However, we had to decide on a limit of numbers the user can input.

The code for the above is as so.

Complicated eh?

Prior to our previous meeting with our supervisor, we were informed that the labeling for the forms were too vague. We were also alerted to the fact that not many people have a firm grasp on how to conduct a proper ra and thus, will not be able to fill in the form appropriately. Therefore, we have attempted to alter the labels to phrase it into questions instead of just a normal label as well as color code it into shades that even someone who is colour blind can differentiate.

Also, we have also managed to make it such that when the user selects a choice, it will correspond to the matrix we have set in the background, providing the user with an automated risk level of whether the activity is low risk, medium risk, or high risk.

This is how the corresponding matrix looks in the background with the code at the top.

This week, we believed that we have truly truly began our fyp in earnest. After a few weeks of reading up and preparation, as well as experimenting with the various excel formulas, we have after long last, managed to integrate the basic RA form into excel albeit with some minor glitches regarding the space and labeling.

with that, and following the excel formulas we learnt a few weeks back, we could integrate the drop down list as well as the ra matrices into this basic sheet.

Now that the basic form is up, we can start refining it and removing the problems that people face when performing ra.

5
During the last meeting with our supervisor, we once again presented our findings for the past two weeks. Apparently, there is a glitch in our user form and it requires us to blank out the last review date so the rest of the form can still be filled out without it.

Subsequently, we also continued working on our VBA macros which involved complicated strings of codes meant to create a more versatile and creative excel document. In short, this allowed us to create forms that a normal excel spreadsheet is not capable of.

The above image shows a very typical function we were able to add via macros. It is a button which makes the entire RA seem more interactive and user friendly as compared to a normal excel whereby people tend to roam about and not complete the task.

4
Within the past 2 weeks, we have completed our critical report as well as a portion of our research on both RA and excel.
Thee  Report criticized was: Development of Excel-based System Interface for Biology (DCHE 0816)
We found this to be an insight on the progress and end result of our fyp in the next year as well as how we think a good report should be structured.
In addition we have conducted research on our microsoft excel via books we have found.
The step by step guide in the books have assisted us in acheiving great milestones in this project.

So far, we have made a good start in excel.
From applying what we have learnt so far, the main spreadsheet for risk assessment has been completed and we have attempted in applying excel formulas such as VLOOKUP and even creating a user friendly drop down list we can use.