Safety Data Sheets: Difference between revisions

From sandbox
Jump to navigation Jump to search
Mharrit1 (talk | contribs)
No edit summary
Mharrit1 (talk | contribs)
No edit summary
Line 9: Line 9:
             https://drive.google.com/open?id=1PxEME2nnUvaZ1qj2ZEh5xxFyDBi94-hlRNhZdkDiVG0  
             https://drive.google.com/open?id=1PxEME2nnUvaZ1qj2ZEh5xxFyDBi94-hlRNhZdkDiVG0  
             (must have permission to edit)  
             (must have permission to edit)  
https://docs.google.com/spreadsheets/d/e/2PACX-1vQaivE1SSnZM2WJLGCX5Xx3w_8ZcJdGt6XI6JB-bVtugrvbqvKpN8TkqJDFfJh4EhDS-YAF3Plh-1Rf/pub?gid=0&single=true&output=csv
 
-->
-->
<!-- Electronics Studio -->
<!-- Electronics Studio -->
{{#get_web_data:
{{#get_web_data:
  url=https://docs.google.com/spreadsheets/u/2/d/1PxEME2nnUvaZ1qj2ZEh5xxFyDBi94-hlRNhZdkDiVG0/gviz/tq?tqx=out:html&gid=0&tq=select%20A%2CB%2CC%2CD%2CE%2CF%20where%20A%3D%22IRB1246%22
  url=https://docs.google.com/spreadsheets/u/2/d/1PxEME2nnUvaZ1qj2ZEh5xxFyDBi94-hlRNhZdkDiVG0/gviz/tq?tqx=out:csv&gid=0&tq=select%20A%2CB%2CC%2CD%2CE%2CF%20where%20A%3D%22IRB1246%22%20or%20A%3D%22Room%22
  |format=CSV with header
  |format=CSV with header
|filters=Room=IRB1246
  |data=StudioName=Studio, ToolName=Tool, SDSName=SDSName, SDS Link=SDSLink, SDS Doc=SDSGoogleDoc, Room=Room
  |data=StudioName=Studio, ToolName=Tool, SDSName=SDSName, SDS Link=SDSLink, SDS Doc=SDSGoogleDoc, Room=Room
}}
}}
Line 35: Line 34:
<!-- Crafts and Sewing -->
<!-- Crafts and Sewing -->
{{#get_web_data:
{{#get_web_data:
  url=https://docs.google.com/spreadsheets/d/e/2PACX-1vQaivE1SSnZM2WJLGCX5Xx3w_8ZcJdGt6XI6JB-bVtugrvbqvKpN8TkqJDFfJh4EhDS-YAF3Plh-1Rf/pub?gid=0&single=true&output=csv
  url=https://docs.google.com/spreadsheets/u/2/d/1PxEME2nnUvaZ1qj2ZEh5xxFyDBi94-hlRNhZdkDiVG0/gviz/tq?tqx=out:csv&gid=0&tq=select%20A%2CB%2CC%2CD%2CE%2CF%20where%20A%3D%22IRB1242%22%20or%20A%3D%22Room%22
  |format=CSV with header
  |format=CSV with header
|filters=Room=IRB1242
  |data=StudioName=Studio, ToolName=Tool, SDSName=SDSName, SDS Link=SDSLink, SDS Doc=SDSGoogleDoc, Room=Room
  |data=StudioName=Studio, ToolName=Tool, SDSName=SDSName, SDS Link=SDSLink, SDS Doc=SDSGoogleDoc, Room=Room
}}
}}
Line 56: Line 54:
<!-- Digital Media Studio (IRB1238)-->
<!-- Digital Media Studio (IRB1238)-->
{{#get_web_data:
{{#get_web_data:
  url=https://docs.google.com/spreadsheets/d/e/2PACX-1vQaivE1SSnZM2WJLGCX5Xx3w_8ZcJdGt6XI6JB-bVtugrvbqvKpN8TkqJDFfJh4EhDS-YAF3Plh-1Rf/pub?gid=0&single=true&output=csv
  url=https://docs.google.com/spreadsheets/u/2/d/1PxEME2nnUvaZ1qj2ZEh5xxFyDBi94-hlRNhZdkDiVG0/gviz/tq?tqx=out:csv&gid=0&tq=select%20A%2CB%2CC%2CD%2CE%2CF%20where%20A%3D%22IRB1238%22%20or%20A%3D%22Room%22
  |format=CSV with header
  |format=CSV with header
|filters=Room=IRB1238
  |data=StudioName=Studio, ToolName=Tool, SDSName=SDSName, SDS Link=SDSLink, SDS Doc=SDSGoogleDoc, Room=Room
  |data=StudioName=Studio, ToolName=Tool, SDSName=SDSName, SDS Link=SDSLink, SDS Doc=SDSGoogleDoc, Room=Room
}}
}}
Line 77: Line 74:
<!-- Prototyping Studio -->
<!-- Prototyping Studio -->
{{#get_web_data:
{{#get_web_data:
  url=https://docs.google.com/spreadsheets/d/e/2PACX-1vQaivE1SSnZM2WJLGCX5Xx3w_8ZcJdGt6XI6JB-bVtugrvbqvKpN8TkqJDFfJh4EhDS-YAF3Plh-1Rf/pub?gid=0&single=true&output=csv
  url=https://docs.google.com/spreadsheets/u/2/d/1PxEME2nnUvaZ1qj2ZEh5xxFyDBi94-hlRNhZdkDiVG0/gviz/tq?tqx=out:csv&gid=0&tq=select%20A%2CB%2CC%2CD%2CE%2CF%20where%20A%3D%22IRB1223%22%20or%20A%3D%22Room%22
  |format=CSV with header
  |format=CSV with header
|filters=Room=IRB1223
  |data=StudioName=Studio, ToolName=Tool, SDSName=SDSName, SDS Link=SDSLink, SDS Doc=SDSGoogleDoc, Room=Room
  |data=StudioName=Studio, ToolName=Tool, SDSName=SDSName, SDS Link=SDSLink, SDS Doc=SDSGoogleDoc, Room=Room
}}
}}
Line 98: Line 94:
<!-- Woodworking Studio (IRB1224)-->
<!-- Woodworking Studio (IRB1224)-->
{{#get_web_data:
{{#get_web_data:
  url=https://docs.google.com/spreadsheets/d/e/2PACX-1vQaivE1SSnZM2WJLGCX5Xx3w_8ZcJdGt6XI6JB-bVtugrvbqvKpN8TkqJDFfJh4EhDS-YAF3Plh-1Rf/pub?gid=0&single=true&output=csv
  url=https://docs.google.com/spreadsheets/u/2/d/1PxEME2nnUvaZ1qj2ZEh5xxFyDBi94-hlRNhZdkDiVG0/gviz/tq?tqx=out:csv&gid=0&tq=select%20A%2CB%2CC%2CD%2CE%2CF%20where%20A%3D%22IRB1224%22%20or%20A%3D%22Room%22
  |format=CSV with header
  |format=CSV with header
|filters=Room=IRB1224
  |data=StudioName=Studio, ToolName=Tool, SDSName=SDSName, SDS Link=SDSLink, SDS Doc=SDSGoogleDoc, Room=Room
  |data=StudioName=Studio, ToolName=Tool, SDSName=SDSName, SDS Link=SDSLink, SDS Doc=SDSGoogleDoc, Room=Room
}}
}}
Line 119: Line 114:
<!-- CNC Studio (IRB1222)-->
<!-- CNC Studio (IRB1222)-->
{{#get_web_data:
{{#get_web_data:
  url=https://docs.google.com/spreadsheets/d/e/2PACX-1vQaivE1SSnZM2WJLGCX5Xx3w_8ZcJdGt6XI6JB-bVtugrvbqvKpN8TkqJDFfJh4EhDS-YAF3Plh-1Rf/pub?gid=0&single=true&output=csv
  url=https://docs.google.com/spreadsheets/u/2/d/1PxEME2nnUvaZ1qj2ZEh5xxFyDBi94-hlRNhZdkDiVG0/gviz/tq?tqx=out:csv&gid=0&tq=select%20A%2CB%2CC%2CD%2CE%2CF%20where%20A%3D%22IRB1222%22%20or%20A%3D%22Room%22
  |format=CSV with header
  |format=CSV with header
|filters=Room=IRB1222
  |data=StudioName=Studio, ToolName=Tool, SDSName=SDSName, SDS Link=SDSLink, SDS Doc=SDSGoogleDoc, Room=Room
  |data=StudioName=Studio, ToolName=Tool, SDSName=SDSName, SDS Link=SDSLink, SDS Doc=SDSGoogleDoc, Room=Room
}}
}}
Line 140: Line 134:
<!-- Project Studio (IRB1220)-->
<!-- Project Studio (IRB1220)-->
{{#get_web_data:
{{#get_web_data:
  url=https://docs.google.com/spreadsheets/d/e/2PACX-1vQaivE1SSnZM2WJLGCX5Xx3w_8ZcJdGt6XI6JB-bVtugrvbqvKpN8TkqJDFfJh4EhDS-YAF3Plh-1Rf/pub?gid=0&single=true&output=csv
  url=https://docs.google.com/spreadsheets/u/2/d/1PxEME2nnUvaZ1qj2ZEh5xxFyDBi94-hlRNhZdkDiVG0/gviz/tq?tqx=out:csv&gid=0&tq=select%20A%2CB%2CC%2CD%2CE%2CF%20where%20A%3D%22IRB1220%22%20or%20A%3D%22Room%22
  |format=CSV with header
  |format=CSV with header
|filters=Room=IRB1220
  |data=StudioName=Studio, ToolName=Tool, SDSName=SDSName, SDS Link=SDSLink, SDS Doc=SDSGoogleDoc, Room=Room
  |data=StudioName=Studio, ToolName=Tool, SDSName=SDSName, SDS Link=SDSLink, SDS Doc=SDSGoogleDoc, Room=Room
}}
}}
Line 162: Line 155:
<!-- All SDS records in sheet -->
<!-- All SDS records in sheet -->
{{#get_web_data:
{{#get_web_data:
  url=https://docs.google.com/spreadsheets/d/e/2PACX-1vQaivE1SSnZM2WJLGCX5Xx3w_8ZcJdGt6XI6JB-bVtugrvbqvKpN8TkqJDFfJh4EhDS-YAF3Plh-1Rf/pub?gid=0&single=true&output=csv
  url=https://docs.google.com/spreadsheets/u/2/d/1PxEME2nnUvaZ1qj2ZEh5xxFyDBi94-hlRNhZdkDiVG0/gviz/tq?tqx=out:csv&gid=0
  |format=CSV with header
  |format=CSV with header
  |data=StudioName=Studio, ToolName=Tool, SDSName=SDSName, SDS Link=SDSLink, SDS Doc=SDSGoogleDoc, Room=Room
  |data=StudioName=Studio, ToolName=Tool, SDSName=SDSName, SDS Link=SDSLink, SDS Doc=SDSGoogleDoc, Room=Room

Revision as of 20:35, 10 October 2020

{{#get_web_data:

url=https://docs.google.com/spreadsheets/u/2/d/1PxEME2nnUvaZ1qj2ZEh5xxFyDBi94-hlRNhZdkDiVG0/gviz/tq?tqx=out:csv&gid=0&tq=select%20A%2CB%2CC%2CD%2CE%2CF%20where%20A%3D%22IRB1246%22%20or%20A%3D%22Room%22
|format=CSV with header
|data=StudioName=Studio, ToolName=Tool, SDSName=SDSName, SDS Link=SDSLink, SDS Doc=SDSGoogleDoc, Room=Room

}}

{{#external_value:StudioName}}

{{#external_value:Room}}

Material SDS Doc SDS Link Tool {{#for_external_table:
{{{SDSName}}} [{{{SDS Doc}}} (view local copy) ] [{{{SDS Link}}} (weblink to SDS)] {{{ToolName}}}

}}

{{#get_web_data:

url=https://docs.google.com/spreadsheets/u/2/d/1PxEME2nnUvaZ1qj2ZEh5xxFyDBi94-hlRNhZdkDiVG0/gviz/tq?tqx=out:csv&gid=0&tq=select%20A%2CB%2CC%2CD%2CE%2CF%20where%20A%3D%22IRB1242%22%20or%20A%3D%22Room%22
|format=CSV with header
|data=StudioName=Studio, ToolName=Tool, SDSName=SDSName, SDS Link=SDSLink, SDS Doc=SDSGoogleDoc, Room=Room

}}

{{#external_value:StudioName}}

{{#external_value:Room}}

Material SDS Doc SDS Link Tool {{#for_external_table:
{{{SDSName}}} [{{{SDS Doc}}} (view local copy) ] [{{{SDS Link}}} (weblink to SDS)] {{{ToolName}}}

}}

{{#get_web_data:

url=https://docs.google.com/spreadsheets/u/2/d/1PxEME2nnUvaZ1qj2ZEh5xxFyDBi94-hlRNhZdkDiVG0/gviz/tq?tqx=out:csv&gid=0&tq=select%20A%2CB%2CC%2CD%2CE%2CF%20where%20A%3D%22IRB1238%22%20or%20A%3D%22Room%22
|format=CSV with header
|data=StudioName=Studio, ToolName=Tool, SDSName=SDSName, SDS Link=SDSLink, SDS Doc=SDSGoogleDoc, Room=Room

}}

{{#external_value:StudioName}}

{{#external_value:Room}}

Material SDS Doc SDS Link Tool {{#for_external_table:
{{{SDSName}}} [{{{SDS Doc}}} (view local copy) ] [{{{SDS Link}}} (weblink to SDS)] {{{ToolName}}}

}}

{{#get_web_data:

url=https://docs.google.com/spreadsheets/u/2/d/1PxEME2nnUvaZ1qj2ZEh5xxFyDBi94-hlRNhZdkDiVG0/gviz/tq?tqx=out:csv&gid=0&tq=select%20A%2CB%2CC%2CD%2CE%2CF%20where%20A%3D%22IRB1223%22%20or%20A%3D%22Room%22
|format=CSV with header
|data=StudioName=Studio, ToolName=Tool, SDSName=SDSName, SDS Link=SDSLink, SDS Doc=SDSGoogleDoc, Room=Room

}}

{{#external_value:StudioName}}

{{#external_value:Room}}

Material SDS Doc SDS Link Tool {{#for_external_table:
{{{SDSName}}} [{{{SDS Doc}}} (view local copy) ] [{{{SDS Link}}} (weblink to SDS)] {{{ToolName}}}

}}

{{#get_web_data:

url=https://docs.google.com/spreadsheets/u/2/d/1PxEME2nnUvaZ1qj2ZEh5xxFyDBi94-hlRNhZdkDiVG0/gviz/tq?tqx=out:csv&gid=0&tq=select%20A%2CB%2CC%2CD%2CE%2CF%20where%20A%3D%22IRB1224%22%20or%20A%3D%22Room%22
|format=CSV with header
|data=StudioName=Studio, ToolName=Tool, SDSName=SDSName, SDS Link=SDSLink, SDS Doc=SDSGoogleDoc, Room=Room

}}

{{#external_value:StudioName}}

{{#external_value:Room}}

Material SDS Doc SDS Link Tool {{#for_external_table:
{{{SDSName}}} [{{{SDS Doc}}} (view local copy) ] [{{{SDS Link}}} (weblink to SDS)] {{{ToolName}}}

}}

{{#get_web_data:

url=https://docs.google.com/spreadsheets/u/2/d/1PxEME2nnUvaZ1qj2ZEh5xxFyDBi94-hlRNhZdkDiVG0/gviz/tq?tqx=out:csv&gid=0&tq=select%20A%2CB%2CC%2CD%2CE%2CF%20where%20A%3D%22IRB1222%22%20or%20A%3D%22Room%22
|format=CSV with header
|data=StudioName=Studio, ToolName=Tool, SDSName=SDSName, SDS Link=SDSLink, SDS Doc=SDSGoogleDoc, Room=Room

}}

{{#external_value:StudioName}}

{{#external_value:Room}}

Material SDS Doc SDS Link Tool {{#for_external_table:
{{{SDSName}}} [{{{SDS Doc}}} (view local copy) ] [{{{SDS Link}}} (weblink to SDS)] {{{ToolName}}}

}}

{{#get_web_data:

url=https://docs.google.com/spreadsheets/u/2/d/1PxEME2nnUvaZ1qj2ZEh5xxFyDBi94-hlRNhZdkDiVG0/gviz/tq?tqx=out:csv&gid=0&tq=select%20A%2CB%2CC%2CD%2CE%2CF%20where%20A%3D%22IRB1220%22%20or%20A%3D%22Room%22
|format=CSV with header
|data=StudioName=Studio, ToolName=Tool, SDSName=SDSName, SDS Link=SDSLink, SDS Doc=SDSGoogleDoc, Room=Room

}}

{{#external_value:StudioName}}

{{#external_value:Room}}

Material SDS Doc SDS Link Tool {{#for_external_table:
{{{SDSName}}} [{{{SDS Doc}}} (view local copy) ] [{{{SDS Link}}} (weblink to SDS)] {{{ToolName}}}

}}

{{#get_web_data:

url=https://docs.google.com/spreadsheets/u/2/d/1PxEME2nnUvaZ1qj2ZEh5xxFyDBi94-hlRNhZdkDiVG0/gviz/tq?tqx=out:csv&gid=0
|format=CSV with header
|data=StudioName=Studio, ToolName=Tool, SDSName=SDSName, SDS Link=SDSLink, SDS Doc=SDSGoogleDoc, Room=Room

}}

All Safety Data Sheets

Room Studio Name Tool Material SDS Doc SDS Link {{#for_external_table:
{{{Room}}} {{{StudioName}}} {{{ToolName}}} {{{SDSName}}} [{{{SDS Doc}}} Sandbox local PDF copy ] [{{{SDS Link}}} Safety Data Sheet]

}}