It tends to sometimes happen also on Thursday nights for us as well...
Your Daily Random Comment
- Nydauron
- Exalted Member
- Posts: 65
- Joined: March 20th, 2018, 8:10 pm
- Division: Grad
- State: IL
- Pronouns: He/Him/His
- Has thanked: 157 times
- Been thanked: 90 times
Re: Your Daily Random Comment
Only slightly above average in algorithms
Conant '19 => UIUC '23
Physics is the only real science
Change my mind
Nydauron's Userpage
- PM2017
- Member
- Posts: 524
- Joined: January 20th, 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
- Exalted Member
- Posts: 65
- Joined: March 20th, 2018, 8:10 pm
- Division: Grad
- State: IL
- Pronouns: He/Him/His
- Has thanked: 157 times
- Been thanked: 90 times
Re: Your Daily Random Comment
lol come visit Champaign sometime
Bar age is 19
Only slightly above average in algorithms
Conant '19 => UIUC '23
Physics is the only real science
Change my mind
Nydauron's Userpage
- JoeyC
- Member
- Posts: 307
- Joined: November 7th, 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
- Exalted Member
- Posts: 65
- Joined: March 20th, 2018, 8:10 pm
- Division: Grad
- State: IL
- Pronouns: He/Him/His
- Has thanked: 157 times
- Been thanked: 90 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: ↑March 12th, 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!
Only slightly above average in algorithms
Conant '19 => UIUC '23
Physics is the only real science
Change my mind
Nydauron's Userpage
- Blank25
- Member
- Posts: 73
- Joined: February 3rd, 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
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: December 7th, 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 (March 12th, 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: December 7th, 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: November 28th, 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: ↑March 12th, 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: November 28th, 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: ↑March 12th, 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
Who is online
Users browsing this forum: No registered users and 1 guest