This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Solve the challenge, share your solution and summit the ranks of our Community!
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
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