Making recipe tree chart but having trouble formatting and automating it
Electronic circuits recipe broken down and put into this weird format chat gpt recommended me 😭
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.
If any more info is needed I can totally supply that as well (:
[link] [comments]
Want to read more?
Check out the full article on the original site