Results 1 to 145 of 145

Show working-instructions depending on GHS-hazard-pictograms

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-31-2022
    Location
    Swiss
    MS-Off Ver
    365
    Posts
    134

    Lightbulb Show working-instructions depending on GHS-hazard-pictograms

    Dear members of the forum,

    I am trying to solve a quite complicated idea (for me) and hope to find some inputs for this here:

    The idea is to make a tool, where you can choose between different GHS-hazard-pictograms for a product (max 5 per product) and then show in which rooms (they have different safety levels) the product can be handled.
    All of the GHS-hazard-pictograms, rooms and B-Terms (I will explain later) are stored in a database.
    Sometimes these products can be handled in a room but need additional safety precautions. Those are numbers from 1-11, labeled next to the room in the database. This information should be shown next to the rooms where it can be handled.

    Last part: Almost all of the GHS-hazard-pictograms have additional requirements (B-Terms), which are stored in a separate database. Depending on the chosen GHS-hazard-pictograms it should be shown which additional requirements are necessary. The B-Terms sometimes change if the product is solid or liquid, so this has to be taken into account.

    To explain it better, I made a sample workbook.

    Because its just an idea, please feel free for new arrangements in the database etc.

    Thank you in advance for your help and best regards,

    David
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Spot the hazard picture - reveal with click
    By fastcar in forum PowerPoint Formatting & General
    Replies: 0
    Last Post: 02-04-2021, 12:47 PM
  2. [SOLVED] Building a hazard table
    By jordana309 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-18-2019, 10:13 AM
  3. [SOLVED] show 0,0.5,1 depending on various condition
    By anilpatni1234 in forum Excel General
    Replies: 19
    Last Post: 10-20-2018, 08:15 AM
  4. [SOLVED] Show data depending on a yes or no.
    By TrickDave in forum Excel General
    Replies: 4
    Last Post: 10-23-2017, 07:40 AM
  5. [SOLVED] Instructions show in Cell until Data is entered
    By swvogt in forum Excel General
    Replies: 5
    Last Post: 09-22-2017, 04:31 PM
  6. Replies: 0
    Last Post: 06-15-2011, 10:36 AM
  7. [SOLVED] How can I graph using pictograms in excel?
    By madrabbit7 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-05-2005, 09:25 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1