Could I petition some help with excel/google sheets? I have a table of data with guest numbers going back to 2015. Like, Column A: 1/1/2015 - 2/5/2020 and Column B # of guests.
What I would like to do is get the average number of guests over 5 years. The part I am getting hung up is that weekend/holidays/etc are a big influence so it is more important that I am comparing MLK day (3rd Monday of January) each year instead of Jan 20th of each year. I know there must be a better way to do it than manually selecting each specific date. So for the MLK example, my current input looks like this
=AVERAGE(B20, B384, B748, B1112, B1483)
Which then I drag that equation down until I have filled out the rest of the year.
Could I petition some help with excel/google sheets? I have a table of data with guest numbers going back to 2015. Like, Column A: 1/1/2015 - 2/5/2020 and Column B # of guests.
What I would like to do is get the average number of guests over 5 years. The part I am getting hung up is that weekend/holidays/etc are a big influence so it is more important that I am comparing MLK day (3rd Monday of January) each year instead of Jan 20th of each year. I know there must be a better way to do it than manually selecting each specific date. So for the MLK example, my current input looks like this
=AVERAGE(B20, B384, B748, B1112, B1483)
Which then I drag that equation down until I have filled out the rest of the year.
I couldn't find anything built in to sheets that lets you see if a specific date is a given holiday, but I did see a StackOverflow post https://stackoverflow.com/questions/43671564/check-if-date-is-a-holiday-in-google-sheets
where it looks like they used JavaScript to connect to the calendar app, where they then pass it a calendar type (Japanese here) to get events on that day.
So you might be able to create another column using that to tag a date with an event, then use an if statement to only average it against dates with the same event tag. Doing formulas in spreadsheets gets kind gross with the syntax, so it might be easier to split all the years apart into their own columns, and do a regular date vs date average, then a holiday vs holiday in a different one so you don't get a giant mess of a formula.
Could I petition some help with excel/google sheets? I have a table of data with guest numbers going back to 2015. Like, Column A: 1/1/2015 - 2/5/2020 and Column B # of guests.
What I would like to do is get the average number of guests over 5 years. The part I am getting hung up is that weekend/holidays/etc are a big influence so it is more important that I am comparing MLK day (3rd Monday of January) each year instead of Jan 20th of each year. I know there must be a better way to do it than manually selecting each specific date. So for the MLK example, my current input looks like this
=AVERAGE(B20, B384, B748, B1112, B1483)
Which then I drag that equation down until I have filled out the rest of the year.
Get a table of historical MLK Day dates and look up to that, like add a boolean column c: is_mlk_day and then you can just do AVERAGEIF(b:b,c:c).
Do not, I repeat, do not under any circumstances attempt to write a formula to identify whether a given date is the third Monday in January.
Could I petition some help with excel/google sheets? I have a table of data with guest numbers going back to 2015. Like, Column A: 1/1/2015 - 2/5/2020 and Column B # of guests.
What I would like to do is get the average number of guests over 5 years. The part I am getting hung up is that weekend/holidays/etc are a big influence so it is more important that I am comparing MLK day (3rd Monday of January) each year instead of Jan 20th of each year. I know there must be a better way to do it than manually selecting each specific date. So for the MLK example, my current input looks like this
=AVERAGE(B20, B384, B748, B1112, B1483)
Which then I drag that equation down until I have filled out the rest of the year.
Get a table of historical MLK Day dates and look up to that, like add a boolean column c: is_mlk_day and then you can just do AVERAGEIF(b:b,c:c).
Do not, I repeat, do not under any circumstances attempt to write a formula to identify whether a given date is the third Monday in January.
This was the rabbit hole I was beginning to go down...
Coworker: My phone is broken, when I call the client it says they are unavailable
Me: Perhaps... perhaps the client just didn't pick up?
Coworker: It can't be, we have an appointment and it's about an important issue
Me: Well, I'll test with my phone [same system] if you'd like
Coworker: Even if it works for you, it doesn't mean that it's working for me
*five minutes later*
Coworker: I wrote down the time of the appointment wrong
Could I petition some help with excel/google sheets? I have a table of data with guest numbers going back to 2015. Like, Column A: 1/1/2015 - 2/5/2020 and Column B # of guests.
What I would like to do is get the average number of guests over 5 years. The part I am getting hung up is that weekend/holidays/etc are a big influence so it is more important that I am comparing MLK day (3rd Monday of January) each year instead of Jan 20th of each year. I know there must be a better way to do it than manually selecting each specific date. So for the MLK example, my current input looks like this
=AVERAGE(B20, B384, B748, B1112, B1483)
Which then I drag that equation down until I have filled out the rest of the year.
Get a table of historical MLK Day dates and look up to that, like add a boolean column c: is_mlk_day and then you can just do AVERAGEIF(b:b,c:c).
Do not, I repeat, do not under any circumstances attempt to write a formula to identify whether a given date is the third Monday in January.
Yeah, for these purposes, if you have to know that information it would far easier to generate a repeating Sunday through Saturday sequence in one column (once the pattern is established selecting the block and extending should respect it) then have the dates for each year in their own column where you manually just paste in Jan 1 on the correct day of the week so it offsets correctly, then directly compare cells in the same row , ignoring blanks.
My right arm has smallish veins so it's always fun when the nurses go to that arm first and I just roll up my left arm that has this huge fucking blue line down it and they look at it and go "oh okay yeah i'll go over there"
+7
Options
David_TA fashion yes-man is no good to me.Copenhagen, DenmarkRegistered Userregular
Joys of working with fairly big European airport, you get to know a lot of different airlines. Today I had to enlighten some people in the office on why "Freebird Airlines" might not be the best name for one.
I hate needles, but the backs of my hands are easy inserts, so I let fellow students practice on me when there was time. Usually didn't tell them I hate needles until after.
I have forearms with pretty intense veins, and a nurse I went on a date with recently complimented me on them, which was unusual to say the least
This checks out, looking at people's hands and arms and evaluating them for stabbability is a thing we do. Though I usually keep my assessment dialogue internal, 'cause it can be creepy as fuck.
When I had bloodwork done for the military, they gave me a trainee to do the blood drawing. Now usually these things go over smoothly, as I have a fat vein at the elbow readily available on both arms. But after sticking me up 4 times and failing, the supervisor finally saw my discomfort and intervened.
I have forearms with pretty intense veins, and a nurse I went on a date with recently complimented me on them, which was unusual to say the least
It's all that hypertension because you're stressed out from Brexit.
It's actually probably because I'm using bouldering as a de-stresser after work and therefore absolutely ruining my body, but that doesn't help, no
0
Options
ani_game_bumOptimistic, Rule-Breaking Nice GuyThe Final World/DestinationRegistered Userregular
Mrs. Bum, who works as one of out of a handful of 12-hour laboratory techs at a new smaller acute ER hospital and therefore is the de facto phlebotomist when she is working, will on occasion push on the veins on the back of my hands as if she is testing where to poke and teases me saying I got great veins and I'm so hydrated and so on.
I acquiesce, partly because of love and partly realizing she deals with patients that are not as fortunate due to being sick and dehydration and it really is a hard enough job for her to do effectively.
Zonugal(He/Him) The Holiday ArmadilloI'm Santa's representative for all the southern states. And Mexico!Registered Userregular
So I have gone back to subbing this week and a few of my US History students (from when I was student teaching) have informed me that they really miss my lectures/presentations.
Which makes me very happy!
But also makes me think on the consistent advice from every education professor that teachers are to refrain from lecturing.
But also makes me think on the consistent advice from every education professor that teachers are to refrain from lecturing.
Huh.
I'm gonna guess it takes a different sort of talent that not everybody has or chooses to develop. Still feels like a weird thing to just write off though.
But also makes me think on the consistent advice from every education professor that teachers are to refrain from lecturing.
Huh.
I'm gonna guess it takes a different sort of talent that not everybody has or chooses to develop. Still feels like a weird thing to just write off though.
Its tied to the idea that it generally has a very low level of engagement for students.
Which is fair because its true.
My lectures are accompanied with guided notes and include moments of activity/participation (partner share, small group discussions, ect..)
But the signature reason my students liked them was they were informative and concise, providing them with a lot of information in a manner they could retain & utilize later on in the unit.
Zonugal on
+21
Options
JedocIn the scupperswith the staggers and jagsRegistered Userregular
Man, if I ever go to any sort of forum meetup it better include 45 minutes of Zonugal teaching us all about history. That sounds rad.
+15
Options
Zonugal(He/Him) The Holiday ArmadilloI'm Santa's representative for all the southern states. And Mexico!Registered Userregular
But also makes me think on the consistent advice from every education professor that teachers are to refrain from lecturing.
Huh.
I'm gonna guess it takes a different sort of talent that not everybody has or chooses to develop. Still feels like a weird thing to just write off though.
Its tied to the idea that it generally has a very low level of engagement for students.
Which is fair because its true.
My lectures are accompanied with guided notes and include moments of activity/participation (partner share, small group discussions, ect..)
But the signature reason my students liked them was they were informative and concise, providing with a lot of information in a manner they could retain & utilize later on in the unit.
What you are doing isn't lecturing though. What they mean by lecturing in 45 minutes with no break of straight teacher talking and all notes. You are doing the correct thing of breaking up instruction with different sub activities and differentiation.
When I had bloodwork done for the military, they gave me a trainee to do the blood drawing. Now usually these things go over smoothly, as I have a fat vein at the elbow readily available on both arms. But after sticking me up 4 times and failing, the supervisor finally saw my discomfort and intervened.
Bah, got a rejection email from a place I'd applied to last month. It was a stretch so I'm not surprised they said no, but I in the middle of a store looking something up when the email came in. Didn't even get a chance to think about whether or not I wanted to open it right then. That sucked
0
Options
WeaverWho are you?What do you want?Registered Userregular
I've been here since 4:30am doing my regular job as well as running around fixing various pieces of equipment, and just now I received an inter-office supply order and somebody in the mailroom drew a smiley face on my shipment. I kinda needed that. That was nice.
+23
Options
mightyjongyoSour CrrmEast Bay, CaliforniaRegistered Userregular
Got a call about an opportunity up in Washington. It's a 6 month contract-to-hire with no relocation assistance until you get full time so I'm more than a little sketch on it but if they pay enough it might be worth renting a room for a bit. I've been wanting a major change in pace which is really the only reason I'm even considering it.
+20
Options
JedocIn the scupperswith the staggers and jagsRegistered Userregular
Posts
What I would like to do is get the average number of guests over 5 years. The part I am getting hung up is that weekend/holidays/etc are a big influence so it is more important that I am comparing MLK day (3rd Monday of January) each year instead of Jan 20th of each year. I know there must be a better way to do it than manually selecting each specific date. So for the MLK example, my current input looks like this
=AVERAGE(B20, B384, B748, B1112, B1483)
Which then I drag that equation down until I have filled out the rest of the year.
Humblebrag
I couldn't find anything built in to sheets that lets you see if a specific date is a given holiday, but I did see a StackOverflow post
https://stackoverflow.com/questions/43671564/check-if-date-is-a-holiday-in-google-sheets
where it looks like they used JavaScript to connect to the calendar app, where they then pass it a calendar type (Japanese here) to get events on that day.
So you might be able to create another column using that to tag a date with an event, then use an if statement to only average it against dates with the same event tag. Doing formulas in spreadsheets gets kind gross with the syntax, so it might be easier to split all the years apart into their own columns, and do a regular date vs date average, then a holiday vs holiday in a different one so you don't get a giant mess of a formula.
Not every day you get to poke a blueblood.
3DS: 0473-8507-2652
Switch: SW-5185-4991-5118
PSN: AbEntropy
Get a table of historical MLK Day dates and look up to that, like add a boolean column c: is_mlk_day and then you can just do AVERAGEIF(b:b,c:c).
Do not, I repeat, do not under any circumstances attempt to write a formula to identify whether a given date is the third Monday in January.
not humble at all
ladies
we faint away like a napkin in the wind afterwards
This was the rabbit hole I was beginning to go down...
Me: Perhaps... perhaps the client just didn't pick up?
Coworker: It can't be, we have an appointment and it's about an important issue
Me: Well, I'll test with my phone [same system] if you'd like
Coworker: Even if it works for you, it doesn't mean that it's working for me
*five minutes later*
Coworker: I wrote down the time of the appointment wrong
Switch: SW-7603-3284-4227
My ACNH Wishlists | My ACNH Catalog
Yeah, for these purposes, if you have to know that information it would far easier to generate a repeating Sunday through Saturday sequence in one column (once the pattern is established selecting the block and extending should respect it) then have the dates for each year in their own column where you manually just paste in Jan 1 on the correct day of the week so it offsets correctly, then directly compare cells in the same row , ignoring blanks.
It's all that hypertension because you're stressed out from Brexit.
This checks out, looking at people's hands and arms and evaluating them for stabbability is a thing we do. Though I usually keep my assessment dialogue internal, 'cause it can be creepy as fuck.
It's actually probably because I'm using bouldering as a de-stresser after work and therefore absolutely ruining my body, but that doesn't help, no
I acquiesce, partly because of love and partly realizing she deals with patients that are not as fortunate due to being sick and dehydration and it really is a hard enough job for her to do effectively.
Which makes me very happy!
But also makes me think on the consistent advice from every education professor that teachers are to refrain from lecturing.
Huh.
I'm gonna guess it takes a different sort of talent that not everybody has or chooses to develop. Still feels like a weird thing to just write off though.
Its tied to the idea that it generally has a very low level of engagement for students.
Which is fair because its true.
My lectures are accompanied with guided notes and include moments of activity/participation (partner share, small group discussions, ect..)
But the signature reason my students liked them was they were informative and concise, providing them with a lot of information in a manner they could retain & utilize later on in the unit.
@Cello can maybe attest but I am constantly in teacher mode when we're out during the day in a locale.
If a history lesson is what you want I heartily recommend a 4-hour train trip with @Platy
To be fair, I did ask for the philosophy 101 lesson at 4:30 AM in line at a Whataburger
3DS Friend Code: 0216-0898-6512
Switch Friend Code: SW-7437-1538-7786
What you are doing isn't lecturing though. What they mean by lecturing in 45 minutes with no break of straight teacher talking and all notes. You are doing the correct thing of breaking up instruction with different sub activities and differentiation.
You know what they say about guys with big veiny arms.
No, please tell me.
Easy to draw blood from.
They have d**** the size of my face!
Which I was happy to give after exploring the back alleys of San Antonio!
Heh.
Hah, just kidding. I trudged twenty minutes through the snow to have a completely rad burger and a beer. Bracing! And delicious!