Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAFormula = 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
I'm sure this will be a poplar challenge 😆
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