Challenge #3: Running Averages

[michael_d]

Solution attached,

Decided instead of just arriving at the correct answer to attempt to build useful macros which are as user friendly as possible. No documentation, debugging or error handling but hopefully should work if used correctly. This was tricky enough to build, there's still a few features to add which would be nice, i.e. grouping field to be optional and different ways of calculating running averages.

Noticed a few things with the solution which seem odd, 3 months averages are grouped by HP Category but 6 months aren't... not sure why?

The standard macro contains the batch macro and the workflow solution contains the standard macro, takes a little setting up but handy nonetheless.

This might come in useful to someone... somewhere...

Thanks,

Michael

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[aclaxton]

Got completely stumped by this one and peeked at other people's solutions. Also I noticed that the output calculated the running average for the second month as the average of row 1, row 1, row 2. That didn't seem intentional so I corrected mine to not do that.

Spoiler

[peter_gb]

The dodgy output file caused some confusion, but despite that I think my method was sound, with the possible exception  of dealing with nulls... 

Nice challenge.

Spoiler

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[samN]

Used some logic to avoid the small errors that using "set to values of closest valid row" causes, by adding some logic based on Nulls in preceding rows

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[Waynemk]

here is mine. 

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[ggruccio]

A bit more challenging!  But really learned how to use the multi-row formula tool!

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[LandonG]

Here is my solution.

Spoiler

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[jasperlch]

Solutions attached

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[Treyson]

For this one I created a macro and plugged it in a few times.

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[andypick]

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.