Challenge #178: Chuck Like a Woodchuck

[Greg_Murray]

Solution attached

[Pollution]

My Solve

[kirk_yates]

Spoiler

Spoiler

Formula = Cubic Feet

TextToColumns = Split soil to rows

Regex = Separated % from Soil Type

Cleansing = Removed Whitespace

Join = Wood To Borrow

Formula = Lbs of Dirt

Summarize = lbs of Dirt by burrow, then Create Average

Summarize = Average Tree Weight

Append Fields = to add combine Ave Tree Weight and Average Dirt Burrowed

Formula = +Answer

Select = Final Answer

[hbraunius]

My solution attached.

[hbraunius]

My solution attached.

[pasccout]

Got to work on my english I guess :(...  Was really close but could not figure out the division of what by what at the end... avg of sum of .... once I got a hint of what to sum... my workflow came to expected sum...

[garthn555]

Spoiler

[alex]

I'm sure this will be a poplar challenge 😆

Spoiler

remember to convert from cubic inches to cubic feet

[Reesetrain2]

All,

My submission is attached.

-I think that the way this is derived is interesting, as I should have read the instructions closer the first time.

-Cheers!

Matt

Spoiler