klara chemical inventory 2013 ulrika olsson. how do i find klara – alternative 1 –...
TRANSCRIPT
KLARA chemical inventory 2013
Ulrika Olsson
Ulrika Olsson Karolinska Institutet 2013 2
How do I find KLARA – alternative 1
www.ki.se – internwebben – Choose system/tool – Chemical index Klara
Ulrika Olsson Karolinska Institutet 2013 3
How do I find KLARA - alternative 2
www.ki.se – internwebben – At work– Laboratory safety
Ulrika Olsson Karolinska Institutet 2013 4
KLARA – different kind of users
Local administrator (usually 1-2 at each department) Manager for chemical inventory Manager for risk assessment Rights to read
Anyone at KI (with correct IP number) can search the chemical database.
Ulrika Olsson Karolinska Institutet 2013 5
KLARA – start page
Select language
Search for products/chemicals
Ulrika Olsson Karolinska Institutet 2013 6
Logged in
• My department• Year• Information• Change password• Search in chemical database• Chemicals
Ulrika Olsson Karolinska Institutet 2013 7
Logged in
• Change password• Important with a
valid e-mail!
Ulrika Olsson Karolinska Institutet 2013 8
KLARA – chemical database
Ulrika Olsson Karolinska Institutet 2013 9
KLARA – chemical database
Search:• Name• CAS number• Structure
Search result:Reviewed products
Ulrika Olsson Karolinska Institutet 2013 10
KLARA - chemical database
Search with structure:• Substructure• Exact structure
Ulrika Olsson Karolinska Institutet 2013 11
KLARA - chemical database
Search with CAS
Ulrika Olsson Karolinska Institutet 2013 12
KLARA - chemical database
Search result:• Product (bold)
at different concentrations and dilutions
• Synonyms (normal)
Concentrations are given in intervals.
Ulrika Olsson Karolinska Institutet 2013 13
KLARA - chemical database
Product name:If complicated name or nomenclature, search with part of the name
Ulrika Olsson Karolinska Institutet 2013 14
KLARA - chemical database
Ulrika Olsson Karolinska Institutet 2013 15
KLARA - chemical database
Previous SDS
• Different suppliers
• Swedish and English
Ulrika Olsson Karolinska Institutet 2013 16
KLARA - chemical database
The local administrator can find out where the product is located.
Ulrika Olsson Karolinska Institutet 2013 17
KLARA - chemical database
Dimensions
12 labels on each sheet
Ulrika Olsson Karolinska Institutet 2013 18
KLARA - chemical database
Sometime there is not space enough for the note because of P-statements/Safety advice phrases.
Ulrika Olsson Karolinska Institutet 2013 19
KLARA - chemical database
Ulrika Olsson Karolinska Institutet 2013 20
KLARA - chemical database
Now there is space for the note!
Ulrika Olsson Karolinska Institutet 2013 21
KLARA - chemical database
If you choose to print 12 labels
Ulrika Olsson Karolinska Institutet 2013 22
KLARA - chemical database
Ulrika Olsson Karolinska Institutet 2013 23
KLARA – chemical inventory
Ulrika Olsson Karolinska Institutet 2013 24
KLARA - chemical inventoryKLARA-nyheter!
Ulrika Olsson Karolinska Institutet 2013 25
KLARA - chemical inventory
Serch and make lists in your own register!
ReportsInstruction!
My chemical register
Ulrika Olsson Karolinska Institutet 2013 26
KLARA - chemical inventory
Start the inventory by clicking on your group.
Ulrika Olsson Karolinska Institutet 2013 27
KLARA - chemical inventory
Copy products with amounts from last years inventory.
Products that have been registered during the year will also be copied, but not with amounts.
Ulrika Olsson Karolinska Institutet 2013 28
KLARA - chemical inventory
Search for products
Discarded products will be placed here.
Discard products from your register, which can be done any time during the year.
Chemicals in the actual room
Premises in different buildings
Inventory status
Ulrika Olsson Karolinska Institutet 2013 29
KLARA - chemical inventory
Click on a product : • Amount and unit• Supplier• Note• Inventory, annual use,
purchase, max storage
Ulrika Olsson Karolinska Institutet 2013 30
KLARA - chemical inventory
Reports and licienses
Fire safety and licienses
• Purchase and Annual use : registered during the year alternatively at the inventory (go back to previous year)
• Max storage: an estimated maximal amount that you might have the whole, or part of, the year.
Ulrika Olsson Karolinska Institutet 2013 31
KLARA - chemical inventory
Choose from existing suppliers (or choose “other”).
Ulrika Olsson Karolinska Institutet 2013 32
KLARA - chemical inventory
A product can be registered as both volume or mass but is then considered to be two different products in KLARA.
Ulrika Olsson Karolinska Institutet 2013 33
KLARA - chemical inventory
Structure!
Ulrika Olsson Karolinska Institutet 2013 34
KLARA - chemical inventory
Ulrika Olsson Karolinska Institutet 2013 35
KLARA - chemical inventory
I can choose to show sums
Ulrika Olsson Karolinska Institutet 2013 36
KLARA - chemical inventory
It is possible to transfer products between the different premises (within the group).
Ulrika Olsson Karolinska Institutet 2013 37
KLARA - chemical inventory
Choose the product(s) you want to move. Click ”Next”.
Ulrika Olsson Karolinska Institutet 2013 38
KLARA - chemical inventory
Choose what premises you want to move your chemical to. Click ”Next”.
Ulrika Olsson Karolinska Institutet 2013 39
KLARA - chemical inventory
Check if the transfer data is correct before you click ”Transfer”.
Ulrika Olsson Karolinska Institutet 2013 40
KLARA - chemical inventory
Done!
Ulrika Olsson Karolinska Institutet 2013 41
KLARA - chemical inventory
Choose campus
Before you start to make a chemical register you have to create premises (if you don’t have it already) or, perhaps, for some reason, you need to make an additional one…
Ulrika Olsson Karolinska Institutet 2013 42
KLARA - chemical inventory
Choose building
Ulrika Olsson Karolinska Institutet 2013 43
KLARA - chemical inventory
Choose among existing floors and rooms or create new ones.
Ulrika Olsson Karolinska Institutet 2013 44
KLARA - chemical inventory
To create a room on a new floor, you first have to create (save) a floor.
If you don't see the ”Save” button, just broaden the margin
Ulrika Olsson Karolinska Institutet 2013 45
KLARA - chemical inventory
Floor 11 is created and now it is possible to create rooms on that floor (by clicking “Add” again).
Ulrika Olsson Karolinska Institutet 2013 46
KLARA - chemical inventory
Name the room (with correct room number, which is given at the physical door/entrance). ”Save”
Ulrika Olsson Karolinska Institutet 2013 47
KLARA - chemical inventory
Here is the new premise!
Ulrika Olsson Karolinska Institutet 2013 48
KLARA - chemical inventory
Now the new room can be found among the other premises!
The symbol to the right of the room means that the room is empty and can be deleted. If you want to delete a room that holds products, all chemicals need to be discarded before you can delete the room.
Ulrika Olsson Karolinska Institutet 2013 49
KLARA - chemical inventory
Now I can start to put chemicals in my premises, or I can choose to create Storage (fridge, cabinet, shelf).
Ulrika Olsson Karolinska Institutet 2013 50
KLARA - chemical inventory
Fridge 1 is created, click ”Close”.
Ulrika Olsson Karolinska Institutet 2013 51
KLARA - chemical inventory
Now I am ready to add chemicals!
Ulrika Olsson Karolinska Institutet 2013 52
KLARA - chemical inventory
Here it is shown what premise you are located in, where the chemicals will be stored.
Perform a search for products in KLARA using:• Name• CAS number• Ordering number• KLARA number
Ulrika Olsson Karolinska Institutet 2013 53
KLARA - chemical inventory
A search with name results in products, synonyms, different concentrations, dilutions and analogs.
Ulrika Olsson Karolinska Institutet 2013 54
KLARA - chemical inventory
A search with CAS results in products of different dilutions as well as synonyms.
Ulrika Olsson Karolinska Institutet 2013 55
KLARA - chemical inventory
If your product can´t be found in KLARA, click on ”product not on the list” in order to add it to the database.
Ulrika Olsson Karolinska Institutet 2013 56
KLARA - chemical inventory
Add CAS number. Click ”Next”.
Ulrika Olsson Karolinska Institutet 2013 57
KLARA - chemical inventory
Here you can choose from suppliers that´s already registered i KLARA. Find your supplier (or ”Other”) and click ”Next”.
Ulrika Olsson Karolinska Institutet 2013 58
KLARA - chemical inventory
This is where you add information about your supplier is if you couldn't find your supplier in the list (i.e. ”Other”).
Ulrika Olsson Karolinska Institutet 2013 59
KLARA - chemical inventory
After supplier information it is time to classify you product. The new pictograms (CLP) are found below the old ones.
Ulrika Olsson Karolinska Institutet 2013 60
KLARA - chemical inventory
Finally, you can add a note, for example ordering number!
Products that are added to the database have to be reviewed before they become approved (“green”). Therefore, all information you can supply is information that support and simplify this process!!
Ulrika Olsson Karolinska Institutet 2013 61
KLARA - chemical inventory
After you have saved the product you should add a SDS!
Ulrika Olsson Karolinska Institutet 2013 62
KLARA - chemical inventory
For detailed information about products in your search result, click ”i”.
Ulrika Olsson Karolinska Institutet 2013 63
KLARA - chemical inventory
This is the same information as in the chemical database.
Ulrika Olsson Karolinska Institutet 2013 64
KLARA - chemical inventory
Under ”classification” you find a lot of information, and also links to different databases and homepages, where you can search for further information if desired!
Ulrika Olsson Karolinska Institutet 2013 65
KLARA - chemical inventory
”Save”
Choose your product and then:• Inventory, purchase, annual use
or max storage. • Supplier• Amount and unit • Storage• Note, buyer etc.
Ulrika Olsson Karolinska Institutet 2013 66
KLARA - chemical inventory
It is possible to make modify the transactions, just click on it and make the changes you whish (with the exception from ”inventory”, which can only be changed during the inventory period).
The product is now registered as inventory. Perhaps this is a product that also have to be registered with ”max storage”?!
Ulrika Olsson Karolinska Institutet 2013 67
KLARA - chemical inventory
All modifications are registered with date and initials.
When you are finished with this specific product , click ”Cancel” (= close)
Ulrika Olsson Karolinska Institutet 2013 68
KLARA - chemical inventory
Here is the added product!
Ulrika Olsson Karolinska Institutet 2013 69
KLARA - chemical inventory
If you click ”show sums”.
Ulrika Olsson Karolinska Institutet 2013 70
KLARA - chemical inventory
• Red products in the register are ”KI phase-out products”.
• Gray products in the register are ”Archived products”.
Ulrika Olsson Karolinska Institutet 2013 71
KLARA – lists and reports
Here you can make lists from your own register, for example to post on your chemical storage or use as a inventory tool.
Ulrika Olsson Karolinska Institutet 2013 72
KLARA – lists and reports
Make your choises and then click ”Show report” (or Excel).
Ulrika Olsson Karolinska Institutet 2013 73
KLARA - lists and reports
Ulrika Olsson Karolinska Institutet 2013 74
KLARA - lists and reports
Search for products in your own register by choosing from different criteria.
Ulrika Olsson Karolinska Institutet 2013 75
KLARA - lists and reports
You can also search by structure (did not fit in this window)
Ulrika Olsson Karolinska Institutet 2013 76
KLARA – lists and reports
Reports and results!
Ulrika Olsson Karolinska Institutet 2013 77
KLARA – lists and reports
Lists for different classes and groups of products in the own register.
Ulrika Olsson Karolinska Institutet 2013 78
KLARA – lists and reports
Ulrika Olsson Karolinska Institutet 2013 79
KLARA – lists and reports
Choose a criteria
Ulrika Olsson Karolinska Institutet 2013 80
KLARA – lists and reports
Ulrika Olsson Karolinska Institutet 2013 81
KLARA – lists and reports
Choose a list and then “Show result” (or Excel).
Ulrika Olsson Karolinska Institutet 2013 82
KLARA – lists and reports
Ulrika Olsson Karolinska Institutet 2013 83
KLARA – lists and reports
Excel-file! Here you can continue working with your list and add more information, for example names of persons, exposure levels etc.
Be aware that you actively have to save as an Excel-file when you save it to your computer!
Ulrika Olsson Karolinska Institutet 2013 84
KLARA – lists and reports
Reports with specific choices, for example lists of different components (in mixtures/kits).
Ulrika Olsson Karolinska Institutet 2013 85
KLARA – lists and reports
Make your choices 1-3 and then “Report” (4).
Ulrika Olsson Karolinska Institutet 2013 86
KLARA – lists and reports
Calculation result!