Making recipe tree chart but having trouble formatting and automating it

Our take

Creating a dynamic recipe tree chart for your video game can be challenging, especially when formatting and automation come into play. You want a clear layout that highlights item recipes, showing how materials combine, while also adapting to more efficient production methods. Implementing an autofill feature for materials, like Red Alloy Cable, would streamline your workflow significantly.

Electronic circuits recipe broken down and put into this weird format chat gpt recommended me 😭

The way I have formatted it for actual use (note that I don't know quite how to make it look readable and nice even for myself)

Ok so basically I'm trying to make a sheet that will show an items recipe (this is a video game) and the recipe steps, the requirements I'm trying to meet are to have it be dynamic as more efficient ways of producing something (like making plates at a 1 to 1 instead of 3 to 2 for example) become available, and some sort of autofill where if I type like Red alloy cable it knows what makes up that material and will enter that down for me. I'm also wondering what format I should be using, because at the moment you can't tell (at least in the 2nd photo) which materials make up another at a glance. (I'm not sure if this follows the subs rules of not posting to learn excel, but I did check out the link associated with it for a good 30 mins and couldn't find the perfect answer I was looking for) anyway yeah any help is really REALLY appreciated I've been struggling for most of the day xD.

Making recipe tree chart but having trouble formatting and automating it

Related Articles