Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEASlightly different results for intensity averages...
Great Challenge! I don't think the solution is calculating the Average Intensity correctly. It also included the first item of the next segment for the flow of the line, however, I don't think including that is a true representation of the average per segment. Great practice of multi-row formula tool as well as poly-build. I knew right away I need to use poly-build but the segmenting was a bit more tricky and I had to look at the solution to move forward, but a great learning experience overall.
I'm currently studying for the Advanced Certification and need all the practice. My numbers from the summarize tool do come out a bit different as other people have said. Here is my solution.
i had to look at the solution, but learned a lot. Macros really useful to combine it all.