Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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 #84: Map Hurricane Harvey's Storm Evolution

MattBenj
9 - Comet

I was able to build a dynamic workflow without a macro. I'll have to book mark this one to go back to and practice iterative macros.

Nicholas_Bignell
8 - Asteroid
bkclaw113
9 - Comet

As many people stated I did not think including the intensity from the first measurement of the following segment was appropriate for calculating average intensity so my numbers do vary from the post results.

chutchison3
5 - Atom

Solution using multirow tool & spatial functions

 

chutchison3_1-1581895419874.png

 

mikeprice17
8 - Asteroid
 
sonyakasenkramer
8 - Asteroid
Spoiler
sonyakasenkramer_0-1582581422879.png

 

dashakir1
8 - Asteroid

Thanks JoeM.

bjkay30
8 - Asteroid

Here's my take on this.  I was able to get the average intensities to match, with some additional steps.

 

Spoiler
bjkay30_0-1582664175604.png

 

LindaLo
8 - Asteroid

This challenge took me a long time to duplicate the records and get the average...

 

AngelosPachis
16 - Nebula

Solved Challenge 84