93
edits
Changes
Jump to navigation
Jump to search
Line 5:
Line 5: − + Line 15:
Line 15: − + + + + + + + + + + + + + + + + + + + + + + + + − If you wish to just check the major tools of all areas or if you need to change the status of a tool you can visit [https://sites.google.com/view/machine-tool-status/home Tool & Machine Master List]
no edit summary
This is a way for members to see if a tool is functioning without reading through Slack or Discourse along with being able to see if a tool is functional before traveling to PS1.
This is a way for members to see if a tool is functioning without reading through Slack or Discourse along with being able to see if a tool is functional before traveling to PS1.
If you wish to just check the major tools of all areas or if you need to change the status of a tool you can visit [https://sites.google.com/view/machine-tool-status/home Tool & Machine Master List]
'''More details?'''
'''Editing & Changing the list'''
For Area Hosts and volunteers adding tools do not go below the black line on a areas tab in the master list. Copy over the formatting to a new series of columns and continue adding.
You will then need to do to the specific area link if you have added new columns and edit the import command of the first cell to change the range of imported cells. DO NOT MAKE ANY OTHER CHANGES.
Example: =IMPORTRANGE("htps://docs.google.com/spreadsheets/d/1Ga57b0Qg0sdayNVl1ef221UgdQDkC620cXkKHe2-5iU/edit#gid=0","Woodshop!A1:F50") in the !A1:F50 section you would need to change the F to a M or whatever your new last column was.
'''Links to Sheets'''
[https://docs.google.com/spreadsheets/d/1Ga57b0Qg0sdayNVl1ef221UgdQDkC620cXkKHe2-5iU/edit#gid=573296344 Master List] This is for all primary Status Changes
Edit these only if number of columns increase.
[https://docs.google.com/spreadsheets/d/10_xehY5MpY4_nLT1B5blkm7tcCNFjMkGgqeMlahD4Kc/edit#gid=0 Woodshop]
[https://docs.google.com/spreadsheets/d/1NmRC4Ets_w2GD2pJ0rS9JRVVL6ou3Aigeul9sFtkT54/edit#gid=1975417554 Hot Metals]
[https://docs.google.com/spreadsheets/d/1QYZZA47EiLoXipQZ93EPiw-GJWWwueJC-t4Y1oiar-8/edit#gid=0 Cold Metals]
[https://docs.google.com/spreadsheets/d/1A6Mp6jEbaBBoRbc7Ylhd5D1gol4FSM3R4ZJd77osYRU/edit#gid=0 Lasers/3dPrinters]
Thank you to Ron and the team.
Thank you to Ron and the team.
PS we’re already looking at expansions involving the RFID control on tools and linking a user status to show what tools are in active use.
PS we’re already looking at expansions involving the RFID control on tools and linking a user status to show what tools are in active use.