Challenge #178: Chuck Like a Woodchuck

[MattBenj]

Lots of different ways and times to take averages and sums.

[CamodCPA]

Pat, Wonderful WF. I love how you maintain the technicality of the measurement names! Alter Everything!

[dombaikamilla]

Spoiler

[LiD]

Spoiler

[SueDonim]

Turns out if you skip a soil type, it's really hard to find the right answer.  Debugging took forever....

Spoiler

Process:
- Text to Columns on Soil Composition (4(!) columns, not 3)
- Extract string to the left of the "-" in each of the 4 soil composition fields
- Extract % of composition of each of the 4 soil composition fields
- Calculate cubic feet of each room
- Apply % of soil composition to cubic feet of each room to determine cubic feet of soil of each tupe
- Transpose each of the 4 soil types
- Union of each of the 4 transpositions
- Find and Replace to add weight of cubic foot of each soil type
- Calculate soil weight for each soil type
- Summarise soil weight for each burrow
- Calculate average weight of soil in each room
- Calculate average weight of cubic foot of wood for the types of wood
- Append average weight of soil with average weight of cubic foot of wood
- Calculate average cubic feet of wood * average weight

[tiffany_chen]

For me, it's a hard one. Because I could not understand feet,clb, etc.

Spoiler

[danicahui]

Spoiler

[sonyakasenkramer]

This was a good reminder to think through data types. I had some fields set to integer, and it was giving me crazy erroneous results. 

Spoiler