Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #81: Multi-Level Bill of Materials Problem

T_Willins
14 - Magnetar
14 - Magnetar

Tried to do this without a macro, but realized an iterative macro was much easier.  Originally put nulls as placeholders for both parent quantity and full quantity, but then had to do several additional steps that didn't quite work to fix.  Ended up with almost the same result as the given solution.

Spoiler
Workflow 81.JPG

 

Macro 81.JPG

 

 

hanykowska
11 - Bolide
Spoiler
Completely blanked on making a sensible iterative macro condition but made it in the end

image.pngimage.png
RoDO
8 - Asteroid

My solution

 

Spoiler
challenge_81_RODO_Solution.pngchallenge_81_RODO_Solution_Macro.png

 

 

mbogusz
9 - Comet
Spoiler
Here's the two iterations without an iterative macroHere's the two iterations without an iterative macro
nini
8 - Asteroid

My solution;

JamesCameron
8 - Asteroid

My Effort, using an iterative macro

 

Spoiler
Flow

JamesCameron_0-1577378655880.png

Macro

JamesCameron_1-1577378701249.png
rmassambane
10 - Fireball
 
ponraj
13 - Pulsar

Here is my solution. 

 

Spoiler
Capture1.PNGCapture.PNG
danicahui
8 - Asteroid
Spoiler
Challenge 81 2020-01-20.jpg
bkclaw113
9 - Comet