Your Daily Random Comment

Shoot the breeze with other Olympians.
User avatar
Nydauron
Exalted Member
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

Post by Nydauron »

PM2017 wrote: March 12th, 2020, 3:42 pm (Think about what happens on Friday nights at college)
It tends to sometimes happen also on Thursday nights for us as well...

Only slightly above average in algorithms

Conant '19 => UIUC '23
Physics is the only real science
Change my mind
Nydauron's Userpage
User avatar
PM2017
Member
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

Post by PM2017 »

Nydauron wrote: March 12th, 2020, 3:51 pm
PM2017 wrote: March 12th, 2020, 3:42 pm (Think about what happens on Friday nights at college)
It tends to sometimes happen also on Thursday nights for us as well...
Yeah I kinda wish Berkeley had a bit more of a party scene ngl.
West High '19
UC Berkeley '23

Go Bears!
User avatar
Nydauron
Exalted Member
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

Post by Nydauron »

PM2017 wrote: March 12th, 2020, 3:53 pm
Nydauron wrote: March 12th, 2020, 3:51 pm
PM2017 wrote: March 12th, 2020, 3:42 pm (Think about what happens on Friday nights at college)
It tends to sometimes happen also on Thursday nights for us as well...
Yeah I kinda wish Berkeley had a bit more of a party scene ngl.
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
User avatar
JoeyC
Member
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

Post by JoeyC »

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!
User avatar
Nydauron
Exalted Member
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

Post by Nydauron »

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!
I have some experience with Excel. Used it a bit during my SciOly years. I am willing to help if you need it!

Only slightly above average in algorithms

Conant '19 => UIUC '23
Physics is the only real science
Change my mind
Nydauron's Userpage
User avatar
Blank25
Member
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

Post by Blank25 »

just got my first college rejection letter :(
These users thanked the author Blank25 for the post (total 2):
Unome (March 12th, 2020, 6:05 pm) • gz839918 (March 12th, 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
User avatar
pikachu4919
Moderator
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

Post by pikachu4919 »

Blank25 wrote: March 12th, 2020, 5:17 pm just got my first college rejection letter :(
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!
User avatar
pikachu4919
Moderator
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

Post by pikachu4919 »

*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”
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!
User avatar
SilverBreeze
Exalted Member
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

Post by SilverBreeze »

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”
Hahaha. I think there's going to be a lot less yelling at people about double posting with the new time limit on edits.
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
User avatar
SilverBreeze
Exalted Member
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

Post by SilverBreeze »

Blank25 wrote: March 12th, 2020, 5:17 pm just got my first college rejection letter :(
pikachu4919 wrote: March 12th, 2020, 5:32 pm Whoever that college is, they’re really missing out on a great potential student ;)
Don't worry about it. If they don't want you, they don't deserve you as a 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
Post Reply

Return to “General Chat”

Who is online

Users browsing this forum: No registered users and 1 guest