Tetris is one of the OGs. A solid game that could keep me captivated for hours. I never had it on the Gameboy, but it was one of the first games I could play on the PC.
I appreciate your education throughout your responses. I just looked up Amstrad CPU 464. Even though I never owned one, I am having serious nostalgia (I don't know why).
I love it! My cousin had an original Nintendo and I was lucky enough to experience that game - super cool. He also had Ninja Turtles which was awesome. As always, thank you for your kind words and support, David!
loving these videos! Almost at the end and I have gained so much knowledge! Pokémon Gold on Gameboy Colour 👍 also remeber playing Coolboarders 3 on the Playstation 1
Thank you!! I can't tell you how much I appreciate your kind words. I never played Coolboarders 3, but looks cool! I think my first snowboard-like video game exposure was SSX Tricky
29:43 that big turtle-looking fella is a Blastoise! The first games for me were on the Nintendo DS with Pokemon Mystery Dungeon and Super Mario Bros. :) Regarding calculating team/position/player averages in today's video, is there a way to filter for "Training Camp" or "In-season" within the AVERAGEIFS formula? For example, if the "Training Camp" testing date falls within the selected date range but the box is unchecked on the dashboard, those data values (from the Training Camp) are still included in the calculation of team/position/player averages. Tried to figure it out myself but no luck, not a huge issue either but thought I'd ask. I hope the question makes sense.
You're the man! Super Mario Bros was legit! I never had a DS but my brothers did and they loved it - I only had Gameboy color. You're a legend for bringing this up. It's an important concept that everyone can benefit from. I'm on the run right now but I'll post the solution ASAP.
Hi David. I looked into the formulas, and in the current video, the AVERAGEIFS calculation does consider all events, regardless of text box selection. So, even if you have "Training Camp" unchecked, the data for Training Camps within the selected date range will be included in the average. If you wanted to ONLY calculate the average for the events that were selected, you could use a combination of AVERAGE and FILTER rather than AVERAGEIFS. I think it's important that people know how to do this, so I'll show how to do so, below: This formula will calculate the average for the team across all dates in the date range: =IF($AG6="","", AVERAGEIFS(INDEX(TestingData,,MATCH($AH$5,TestingHeaders,0)),TestingData!$E:$E,$AE$10,TestingData!$B:$B,">="&$AE$13,TestingData!$B:$B,"
Tetris on the gameboy is the one, that music still gets me going now and makes me want to dance like a Russian cossack
Tetris is one of the OGs. A solid game that could keep me captivated for hours. I never had it on the Gameboy, but it was one of the first games I could play on the PC.
I had a Amstrad CPU 464, and the game i played was Harrier Attack. Until these systems got better etc.
I appreciate your education throughout your responses. I just looked up Amstrad CPU 464. Even though I never owned one, I am having serious nostalgia (I don't know why).
My first gaming experience was Donkey Kong Game & Watch from Nintendo and Game & Watch: Octopus ;)
Again a great video thanks Adam :)
I love it! My cousin had an original Nintendo and I was lucky enough to experience that game - super cool. He also had Ninja Turtles which was awesome. As always, thank you for your kind words and support, David!
loving these videos! Almost at the end and I have gained so much knowledge! Pokémon Gold on Gameboy Colour 👍 also remeber playing Coolboarders 3 on the Playstation 1
Thank you!! I can't tell you how much I appreciate your kind words. I never played Coolboarders 3, but looks cool! I think my first snowboard-like video game exposure was SSX Tricky
29:43 that big turtle-looking fella is a Blastoise! The first games for me were on the Nintendo DS with Pokemon Mystery Dungeon and Super Mario Bros. :)
Regarding calculating team/position/player averages in today's video, is there a way to filter for "Training Camp" or "In-season" within the AVERAGEIFS formula? For example, if the "Training Camp" testing date falls within the selected date range but the box is unchecked on the dashboard, those data values (from the Training Camp) are still included in the calculation of team/position/player averages. Tried to figure it out myself but no luck, not a huge issue either but thought I'd ask. I hope the question makes sense.
You're the man! Super Mario Bros was legit! I never had a DS but my brothers did and they loved it - I only had Gameboy color.
You're a legend for bringing this up. It's an important concept that everyone can benefit from.
I'm on the run right now but I'll post the solution ASAP.
Hi David. I looked into the formulas, and in the current video, the AVERAGEIFS calculation does consider all events, regardless of text box selection. So, even if you have "Training Camp" unchecked, the data for Training Camps within the selected date range will be included in the average. If you wanted to ONLY calculate the average for the events that were selected, you could use a combination of AVERAGE and FILTER rather than AVERAGEIFS. I think it's important that people know how to do this, so I'll show how to do so, below:
This formula will calculate the average for the team across all dates in the date range:
=IF($AG6="","", AVERAGEIFS(INDEX(TestingData,,MATCH($AH$5,TestingHeaders,0)),TestingData!$E:$E,$AE$10,TestingData!$B:$B,">="&$AE$13,TestingData!$B:$B,"
@@AdamVirgile34 you're the best! Thanks so much for taking the time to write all that out and explain it. Added it in and works perfectly!
@@DavidCanales Perfect!!