Anyone here got some serious Excel knowledge? I’ve been building a bit of a frankedsheet, and really could do with some pointers on it. Essentially it’s for recipe management, costings and batch production logging. I cannot find a specific piece of software that covers those three bases sadly. The batch logging in particular just seems to land me in large scale industrial production level software, which is way out of my league.
Things I really could do with it handling:
Recipe layouts have headers and footers of consistent information. Ideally I’d like a master template I can update that will update all the instances I’m using rather than doing it manually.
Recipes have a variable length ingredients list, and all the header / footer formula need to take that into account.
When I do batch production costings, I need to be able to have my price list reflect the current prices, and have older batch logs storing the prices as it was at the time (plus a few other bits of info possibly).
Am I on a losing battle?