Sciencemadness Discussion Board
Not logged in [Login ]
Go To Bottom

Printable Version  
 Pages:  1  2
Author: Subject: List of Chemicals and Materials Made by Sciencemadness.org Users
ninhydric1
National Hazard
****




Posts: 345
Registered: 21-4-2017
Location: Western US
Member Is Offline

Mood: Bleached

[*] posted on 7-1-2019 at 13:09


There is a way to sort alphabetically. Just tell me what you want to base the sorting off of and I can do it when I get home.



The philosophy of one century is the common sense of the next.
View user's profile View All Posts By User
fusso
International Hazard
*****




Posts: 1880
Registered: 23-6-2017
Location: 4 ∥ universes ahead of you
Member Is Offline


[*] posted on 7-1-2019 at 13:27


Quote: Originally posted by ninhydric1  
There is a way to sort alphabetically. Just tell me what you want to base the sorting off of and I can do it when I get home.
First chemical name, if there are more than 1 members for the same chemical then continue with username.
@TheMrbunGee is that good enough?
@ninhydric please also provide the method after doing the sorting. Thanks a lot.

[Edited on 190107 by fusso]




View user's profile View All Posts By User
Abromination
National Hazard
****




Posts: 431
Registered: 10-7-2018
Location: Alaska
Member Is Offline

Mood: 1,4 tar

[*] posted on 7-1-2019 at 16:15


Oi! Since when has there been a remake?!



List of materials made by ScienceMadness.org users:
https://docs.google.com/spreadsheets/d/1nmJ8uq-h4IkXPxD5svnT...
--------------------------------
Elements Collected: H, Li, B, C, N, O, Mg, Al, Si, P, S, Fe, Ni, Cu, Zn, Ag, I, Au, Pb, Bi, Am
Last Acquired: B
Next: Na
--------------
View user's profile View All Posts By User
ninhydric1
National Hazard
****




Posts: 345
Registered: 21-4-2017
Location: Western US
Member Is Offline

Mood: Bleached

[*] posted on 7-1-2019 at 16:21


I made some improvements to the document:

1. I froze the top 4 rows so the important info is present regardless of how far you scroll.

2. I alphabetized the spreadsheet based on the name of the compound. You can do so in the "Data" settings.




The philosophy of one century is the common sense of the next.
View user's profile View All Posts By User
TheMrbunGee
National Hazard
****




Posts: 342
Registered: 13-7-2016
Location: EU
Member Is Offline

Mood: Phosphorising

[*] posted on 7-1-2019 at 21:14


Looks good, good thing that the sorting could be done after all! :) I'm not a google sheets expert. :D



Quote:

Oi! Since when has there been a remake?!


Since yesterday! :D


EDIT: could the sorting be done to empty cells also, so it would sort new entries automatically? It doesn't now..

[Edited on 8-1-2019 by TheMrbunGee]




View user's profile Visit user's homepage View All Posts By User
ninhydric1
National Hazard
****




Posts: 345
Registered: 21-4-2017
Location: Western US
Member Is Offline

Mood: Bleached

[*] posted on 7-1-2019 at 21:41


If you add new entries, you have to re-sort in every time, unfortunately.



The philosophy of one century is the common sense of the next.
View user's profile View All Posts By User
Abromination
National Hazard
****




Posts: 431
Registered: 10-7-2018
Location: Alaska
Member Is Offline

Mood: 1,4 tar

[*] posted on 8-1-2019 at 00:02


Quote: Originally posted by TheMrbunGee  
Looks good, good thing that the sorting could be done after all! :) I'm not a google sheets expert. :D



Quote:

Oi! Since when has there been a remake?!


Since yesterday! :D


EDIT: could the sorting be done to empty cells also, so it would sort new entries automatically? It doesn't now..


[Edited on 8-1-2019 by TheMrbunGee]

I do see... I suppose I must update my signature and perhaps write another entry or two... I suppose I have neglected it a tad bit...




List of materials made by ScienceMadness.org users:
https://docs.google.com/spreadsheets/d/1nmJ8uq-h4IkXPxD5svnT...
--------------------------------
Elements Collected: H, Li, B, C, N, O, Mg, Al, Si, P, S, Fe, Ni, Cu, Zn, Ag, I, Au, Pb, Bi, Am
Last Acquired: B
Next: Na
--------------
View user's profile View All Posts By User
Abromination
National Hazard
****




Posts: 431
Registered: 10-7-2018
Location: Alaska
Member Is Offline

Mood: 1,4 tar

[*] posted on 8-1-2019 at 21:48


Are you going to periodically re-alphabetize the document? I added a simple synthesis and it did not automatically alphabetize as I thought it would. I honestly have little experience with google sheets.



List of materials made by ScienceMadness.org users:
https://docs.google.com/spreadsheets/d/1nmJ8uq-h4IkXPxD5svnT...
--------------------------------
Elements Collected: H, Li, B, C, N, O, Mg, Al, Si, P, S, Fe, Ni, Cu, Zn, Ag, I, Au, Pb, Bi, Am
Last Acquired: B
Next: Na
--------------
View user's profile View All Posts By User
fusso
International Hazard
*****




Posts: 1880
Registered: 23-6-2017
Location: 4 ∥ universes ahead of you
Member Is Offline


[*] posted on 9-1-2019 at 03:30


@ninhydric how did you alphabetize them?
If we have the method then we can put it in the doc and have everyone sort them after entering their data.
(edit: added point)

[Edited on 190109 by fusso]




View user's profile View All Posts By User
Abromination
National Hazard
****




Posts: 431
Registered: 10-7-2018
Location: Alaska
Member Is Offline

Mood: 1,4 tar

[*] posted on 26-7-2019 at 17:26


Sorry to bring this back, but I am having some problems with the spreadsheet. I cant get the procedure for iodine to conform with the format of the other procedure spaces. It will not create a new line like it has in the past once it ran out of space, it is for some reason continuous. Not sure why, didn't do that in the past. I am also having trouble getting it to alphabetize automatically, I thought we had fixed that. Seems a few others have to.

To fusso: I saw in another thread you made someone had made a space for chloroform and didn't write anything else. I went ahead and fixed that, it wasn't contributing to the document and was taking up space in the form.

Another thing that I wanted to bring up is the possibility of adding this to the wiki and just use the document as a submission page. Having a quick and easy list of various synthesis would be great, bring more people to the wiki and having a list of chemicals made by sciencemadness members is kind of neat. Some people have mentioned adding it to the wiki throughout this thread and the more I think of it the better it sounds. I have time on my hands and could do it as well as keep it up to date, but I don't have editing access on the wiki and also VSEPR_VOID should have dibs since he made the document in the first place. The members in charge of the wiki could do it if they wanted as well.
If you guys don't think it should be added, that is alright, but I am interested to see what y'all think.




List of materials made by ScienceMadness.org users:
https://docs.google.com/spreadsheets/d/1nmJ8uq-h4IkXPxD5svnT...
--------------------------------
Elements Collected: H, Li, B, C, N, O, Mg, Al, Si, P, S, Fe, Ni, Cu, Zn, Ag, I, Au, Pb, Bi, Am
Last Acquired: B
Next: Na
--------------
View user's profile View All Posts By User
VSEPR_VOID
International Hazard
*****




Posts: 719
Registered: 1-9-2017
Member Is Offline

Mood: Fullerenes

[*] posted on 14-8-2019 at 18:29


I like the new formatting. Someone with an official Science Madness gmail address should make a copy of the document and add it to the wiki and maybe give it a sticky. It could be a very useful tool.



Within cells interlinked
Within cells interlinked
Within cells interlinked
View user's profile View All Posts By User
 Pages:  1  2

  Go To Top