It tends to sometimes happen also on Thursday nights for us as well...
Your Daily Random Comment
-
Nydauron
- Administrator

- Posts: 105
- Joined: Tue Mar 20, 2018 8:10 pm
- Division: Grad
- State: IL
- Pronouns: He/Him/His
- Has thanked: 185 times
- Been thanked: 129 times
Re: Your Daily Random Comment
Conant '19 → UIUC '23
Physics is the only real science
Change my mind
Nydauron's Userpage
Contribute to WikiProject Dark Mode!
A proper dark mode for the forums SoonTM
Opinions expressed on this site are not official; the only place for official rules changes and FAQs is soinc.org.
Physics is the only real science
Change my mind
Nydauron's Userpage
Contribute to WikiProject Dark Mode!
A proper dark mode for the forums SoonTM
Opinions expressed on this site are not official; the only place for official rules changes and FAQs is soinc.org.
-
PM2017
- Member

- Posts: 524
- Joined: Fri Jan 20, 2017 5:02 pm
- Division: Grad
- State: CA
- Has thanked: 23 times
- Been thanked: 13 times
Re: Your Daily Random Comment
Yeah I kinda wish Berkeley had a bit more of a party scene ngl.
West High '19
UC Berkeley '23
Go Bears!
UC Berkeley '23
Go Bears!
-
Nydauron
- Administrator

- Posts: 105
- Joined: Tue Mar 20, 2018 8:10 pm
- Division: Grad
- State: IL
- Pronouns: He/Him/His
- Has thanked: 185 times
- Been thanked: 129 times
Re: Your Daily Random Comment
lol come visit Champaign sometime
Bar age is 19
Conant '19 → UIUC '23
Physics is the only real science
Change my mind
Nydauron's Userpage
Contribute to WikiProject Dark Mode!
A proper dark mode for the forums SoonTM
Opinions expressed on this site are not official; the only place for official rules changes and FAQs is soinc.org.
Physics is the only real science
Change my mind
Nydauron's Userpage
Contribute to WikiProject Dark Mode!
A proper dark mode for the forums SoonTM
Opinions expressed on this site are not official; the only place for official rules changes and FAQs is soinc.org.
-
JoeyC
- Member

- Posts: 307
- Joined: Tue Nov 07, 2017 1:43 pm
- Division: Grad
- State: TX
- Has thanked: 503 times
- Been thanked: 73 times
Re: Your Daily Random Comment
Does anyone know how to use Google Sheets formulas so I can do stuff like I would in coding?
This is for the sheet for the unnofficial forum tourney we've been discussing in the below forum (if you want to be a test writer for an event or staff, just type your name into the event slot! Make sure you have adequate qualifications for whatever you sign up for if you do)
viewtopic.php?f=335&t=17332
The sheet is here:
https://docs.google.com/spreadsheets/d/ ... sp=sharing
I want to try to do something on the second sheet which more or less scans the first sheet for usernames, then counts the number of events they have and records that data. I know how I would do it with for loops, if statements, etc. but I don't know how to do this with Sheets (especially since Sheets is less functional than Excel). If anyone knows how, this would be greatly appreciated.
Thanks!
This is for the sheet for the unnofficial forum tourney we've been discussing in the below forum (if you want to be a test writer for an event or staff, just type your name into the event slot! Make sure you have adequate qualifications for whatever you sign up for if you do)
viewtopic.php?f=335&t=17332
The sheet is here:
https://docs.google.com/spreadsheets/d/ ... sp=sharing
I want to try to do something on the second sheet which more or less scans the first sheet for usernames, then counts the number of events they have and records that data. I know how I would do it with for loops, if statements, etc. but I don't know how to do this with Sheets (especially since Sheets is less functional than Excel). If anyone knows how, this would be greatly appreciated.
Thanks!
-
Nydauron
- Administrator

- Posts: 105
- Joined: Tue Mar 20, 2018 8:10 pm
- Division: Grad
- State: IL
- Pronouns: He/Him/His
- Has thanked: 185 times
- Been thanked: 129 times
Re: Your Daily Random Comment
I have some experience with Excel. Used it a bit during my SciOly years. I am willing to help if you need it!JoeyC wrote: ↑Thu Mar 12, 2020 4:56 pm Does anyone know how to use Google Sheets formulas so I can do stuff like I would in coding?
This is for the sheet for the unnofficial forum tourney we've been discussing in the below forum (if you want to be a test writer for an event or staff, just type your name into the event slot! Make sure you have adequate qualifications for whatever you sign up for if you do)
viewtopic.php?f=335&t=17332
The sheet is here:
https://docs.google.com/spreadsheets/d/ ... sp=sharing
I want to try to do something on the second sheet which more or less scans the first sheet for usernames, then counts the number of events they have and records that data. I know how I would do it with for loops, if statements, etc. but I don't know how to do this with Sheets (especially since Sheets is less functional than Excel). If anyone knows how, this would be greatly appreciated.
Thanks!
Conant '19 → UIUC '23
Physics is the only real science
Change my mind
Nydauron's Userpage
Contribute to WikiProject Dark Mode!
A proper dark mode for the forums SoonTM
Opinions expressed on this site are not official; the only place for official rules changes and FAQs is soinc.org.
Physics is the only real science
Change my mind
Nydauron's Userpage
Contribute to WikiProject Dark Mode!
A proper dark mode for the forums SoonTM
Opinions expressed on this site are not official; the only place for official rules changes and FAQs is soinc.org.
-
Blank25
- Member

- Posts: 73
- Joined: Sun Feb 03, 2019 7:34 pm
- Division: Grad
- State: NY
- Has thanked: 0
- Been thanked: 2 times
Re: Your Daily Random Comment
just got my first college rejection letter 
- These users thanked the author Blank25 for the post (total 2):
- Unome (Thu Mar 12, 2020 6:05 pm) • gz839918 (Thu Mar 12, 2020 7:14 pm)
2020 Events: Astronomy, Ornithology, Water Quality, Protein Modeling
2019 Events: Fermi, Protein Modeling, Mission Possible
2018 Events: Dynamic Planet, Herpetology, Towers, Disease Detectives, Forensics, Parasitology
2017 Events: Ecology, Invasives, Hovercraft, Towers, Astronomy
2019 Events: Fermi, Protein Modeling, Mission Possible
2018 Events: Dynamic Planet, Herpetology, Towers, Disease Detectives, Forensics, Parasitology
2017 Events: Ecology, Invasives, Hovercraft, Towers, Astronomy
-
pikachu4919
- Moderator

- Posts: 716
- Joined: Fri Dec 07, 2012 2:30 pm
- Division: Grad
- State: IN
- Pronouns: She/Her/Hers
- Has thanked: 89 times
- Been thanked: 167 times
Re: Your Daily Random Comment
Whoever that college is, they’re really missing out on a great potential student
- These users thanked the author pikachu4919 for the post:
- gz839918 (Thu Mar 12, 2020 7:14 pm)
Carmel HS (IN) '16
Purdue BioE '21? reevaluating my life choices
Nationals 2016 ~ 4th place Forensics
"It is important to draw wisdom from different places. If you take it from only one place, it becomes rigid and stale." -Uncle Iroh
About me || Rate my tests!
Opinions expressed on this site are not official; the only place for official rules changes and FAQs is soinc.org.
MY CABBAGES!
Purdue BioE '21? reevaluating my life choices
Nationals 2016 ~ 4th place Forensics
"It is important to draw wisdom from different places. If you take it from only one place, it becomes rigid and stale." -Uncle Iroh
About me || Rate my tests!
Opinions expressed on this site are not official; the only place for official rules changes and FAQs is soinc.org.
MY CABBAGES!
-
pikachu4919
- Moderator

- Posts: 716
- Joined: Fri Dec 07, 2012 2:30 pm
- Division: Grad
- State: IN
- Pronouns: She/Her/Hers
- Has thanked: 89 times
- Been thanked: 167 times
Re: Your Daily Random Comment
*double post but whatev*
Boyfriend *while buzzed*: “how much do you know about cosmology?”
Me: *raises eyebrow bc I’m a chem/bio kid through and through*
Boyfriend: “which would happen first, the death of our sun or andromeda crashing into us?”
Me: “...uhhh, the death of our sun? I have astronomy friends that know way better than me on that”
Boyfriend *while buzzed*: “how much do you know about cosmology?”
Me: *raises eyebrow bc I’m a chem/bio kid through and through*
Boyfriend: “which would happen first, the death of our sun or andromeda crashing into us?”
Me: “...uhhh, the death of our sun? I have astronomy friends that know way better than me on that”
Carmel HS (IN) '16
Purdue BioE '21? reevaluating my life choices
Nationals 2016 ~ 4th place Forensics
"It is important to draw wisdom from different places. If you take it from only one place, it becomes rigid and stale." -Uncle Iroh
About me || Rate my tests!
Opinions expressed on this site are not official; the only place for official rules changes and FAQs is soinc.org.
MY CABBAGES!
Purdue BioE '21? reevaluating my life choices
Nationals 2016 ~ 4th place Forensics
"It is important to draw wisdom from different places. If you take it from only one place, it becomes rigid and stale." -Uncle Iroh
About me || Rate my tests!
Opinions expressed on this site are not official; the only place for official rules changes and FAQs is soinc.org.
MY CABBAGES!
-
SilverBreeze
- Exalted Member

- Posts: 306
- Joined: Thu Nov 28, 2019 3:42 pm
- Division: C
- State: CA
- Has thanked: 156 times
- Been thanked: 289 times
Re: Your Daily Random Comment
Hahaha. I think there's going to be a lot less yelling at people about double posting with the new time limit on edits.pikachu4919 wrote: ↑Thu Mar 12, 2020 7:29 pm *double post but whatev*
Boyfriend *while buzzed*: “how much do you know about cosmology?”
Me: *raises eyebrow bc I’m a chem/bio kid through and through*
Boyfriend: “which would happen first, the death of our sun or andromeda crashing into us?”
Me: “...uhhh, the death of our sun? I have astronomy friends that know way better than me on that”
Troy SciOly 2019 - 2023
Captain 2021-2023
Former Events: Ecology, Water Quality, Green Gen, Ornithology, Forestry, Disease Detectives, Forensics, Chem Lab, Env Chem, Sounds, Dynamic Planet, Crime Busters, Potions & Poisons, Exp Design, Towers, Mystery Arch, Reach for the Stars, Mission Possible
Captain 2021-2023
Former Events: Ecology, Water Quality, Green Gen, Ornithology, Forestry, Disease Detectives, Forensics, Chem Lab, Env Chem, Sounds, Dynamic Planet, Crime Busters, Potions & Poisons, Exp Design, Towers, Mystery Arch, Reach for the Stars, Mission Possible
-
SilverBreeze
- Exalted Member

- Posts: 306
- Joined: Thu Nov 28, 2019 3:42 pm
- Division: C
- State: CA
- Has thanked: 156 times
- Been thanked: 289 times
Re: Your Daily Random Comment
Don't worry about it. If they don't want you, they don't deserve you as a student.pikachu4919 wrote: ↑Thu Mar 12, 2020 5:32 pm Whoever that college is, they’re really missing out on a great potential student![]()
Troy SciOly 2019 - 2023
Captain 2021-2023
Former Events: Ecology, Water Quality, Green Gen, Ornithology, Forestry, Disease Detectives, Forensics, Chem Lab, Env Chem, Sounds, Dynamic Planet, Crime Busters, Potions & Poisons, Exp Design, Towers, Mystery Arch, Reach for the Stars, Mission Possible
Captain 2021-2023
Former Events: Ecology, Water Quality, Green Gen, Ornithology, Forestry, Disease Detectives, Forensics, Chem Lab, Env Chem, Sounds, Dynamic Planet, Crime Busters, Potions & Poisons, Exp Design, Towers, Mystery Arch, Reach for the Stars, Mission Possible