Rank: New forum user
|
Hello IOSH community, First time I've posted to the forum, I am currently trying to understand, and more to the point create some kind of spreadsheet to identify and manage comah applicable materials, volumes rise and fall so I need first to identify and class the materials and then update on a regular basis to establish what tier if any is applicable. To date volumes have been below the thresholds. Any advice or help would be much appreciated. Struggling to understand the guidance on aggregation and applying it. Kind regards Paul M
|
|
|
|
Rank: Super forum user
|
I assume you have looked at http://www.hse.gov.uk/pubns/priced/l111.pdf including the worked examples.
Can you give an example (it need not be of your real materials, classifications or quantities) of an aggregation you are having difficulty with? Or is it more about how to write the formulas in the spreadsheet (I assume Excel)?
|
|
|
|
Rank: New forum user
|
Hi Kate thanks for your reply, quite right looked at the published HSE doc, helped quite a bit with the worked examples but my weak spot is the Excel end of it... once again thanks...
Kind regards Paul M
|
|
|
|
Rank: Super forum user
|
OK so I guess what you have to start with is a sheet showing the name of each material, which categories it falls into and how much of it you have, and you want to write formulas using those data to do the aggregations?
How have you set this up, what does it look like in terms of rows and columns?
For example if I was doing this I would probably list materials vertically and categories horizontally, colour code the cells to show which categories were applicable to each material, have a column next to the material name in which I entered the quantity, and then for each cell colour coded as applicable tell it to equal that quantity (a formula like =$B2). (That can be done either manually or by conditional formatting.)
Then you can write formulas involving each column.
Edited by user 16 April 2018 10:41:07(UTC)
| Reason: corrected Excel formula
|
|
|
|
Rank: Super forum user
|
|
|
|
|
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.