Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #3: Running Averages

mithily
8 - Asteroid
Spoiler
not sure i get the exact names as the output but it was interesting to transpose and not do separate multirow for each measure
Brinker
8 - Asteroid

Thanks, great excercise!

KellyWray
5 - Atom

Attached is my answer for Challenge 3.

ntakeda
11 - Bolide

I didn't know what to do.

Spoiler
ntakeda_0-1687494380533.png

 

jstewa13
7 - Meteor

This one was tricky, originally tried to do the rolling avgs before the first transpose, once i saw you had to do it after everything fell into place 

AImbody
8 - Asteroid

I can't insert my screenshot so my file is below.  I was actually very confused by the format of the given answer so what I came up with looks completely different.

danielhoge
8 - Asteroid

It doesn't look like the output file, but I think the numbers are correct. Followed the instructions instead of duplicating the provided solution.

MatteoReddavide
8 - Asteroid

My solution, it seems the same even with a different final structure

 

Spoiler
Screenshot 2023-07-14 112934.png
Krzysztof_Hyla_1986
8 - Asteroid

Solved this using 'Multi-Row Formula' twice.

Spoiler
challenge_3_solution_KH.jpg
Danielle_Lutz
7 - Meteor

Solution