| Pages:
1
2 |
ninhydric1
Hazard to Others
Posts: 345
Registered: 21-4-2017
Location: Western US
Member Is Offline
Mood: Bleached
|
|
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.
|
|
|
fusso
International Hazard
Posts: 1922
Registered: 23-6-2017
Location: 4 ∥ universes ahead of you
Member Is Offline
|
|
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]
|
|
|
Abromination
Hazard to Others
Posts: 432
Registered: 10-7-2018
Location: Alaska
Member Is Offline
Mood: 1,4 tar
|
|
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
-------------- |
|
|
ninhydric1
Hazard to Others
Posts: 345
Registered: 21-4-2017
Location: Western US
Member Is Offline
Mood: Bleached
|
|
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.
|
|
|
TheMrbunGee
Hazard to Others
Posts: 364
Registered: 13-7-2016
Location: EU
Member Is Offline
Mood: Phosphorising
|
|
Looks good, good thing that the sorting could be done after all!  I'm not a
google sheets expert. 
| Quote: |
Oi! Since when has there been a remake?!
|
Since yesterday!
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]
|
|
|
ninhydric1
Hazard to Others
Posts: 345
Registered: 21-4-2017
Location: Western US
Member Is Offline
Mood: Bleached
|
|
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.
|
|
|
Abromination
Hazard to Others
Posts: 432
Registered: 10-7-2018
Location: Alaska
Member Is Offline
Mood: 1,4 tar
|
|
| Quote: Originally posted by TheMrbunGee | Looks good, good thing that the sorting could be done after all! I'm not a
google sheets expert.
| Quote: |
Oi! Since when has there been a remake?!
|
Since yesterday!
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
-------------- |
|
|
Abromination
Hazard to Others
Posts: 432
Registered: 10-7-2018
Location: Alaska
Member Is Offline
Mood: 1,4 tar
|
|
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
-------------- |
|
|
fusso
International Hazard
Posts: 1922
Registered: 23-6-2017
Location: 4 ∥ universes ahead of you
Member Is Offline
|
|
@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]
|
|
|
Abromination
Hazard to Others
Posts: 432
Registered: 10-7-2018
Location: Alaska
Member Is Offline
Mood: 1,4 tar
|
|
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
-------------- |
|
|
VSEPR_VOID
National Hazard
Posts: 719
Registered: 1-9-2017
Member Is Offline
Mood: Fullerenes
|
|
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
|
|
|
| Pages:
1
2 |
![[*]](images/xpblue/default_icon.gif){kind=icon}
