Extra-applicational extraction of Excel form
October 29, 2013 1:56 AM Subscribe
I have an MS Excel spreadsheet which uses drop-down menus which affect the content in multiple fields. It's used for buying inventory, so you'd change the "category" menu to "paperware," upon which the fields "account number" "responsible admin" etc. would all populate depending on what I've chosen in "paperware."
Now we're redoing the form and I'm tasked with mapping all available functions and how they are related
posted by monocultured to computers & internet (5 answers total) 1 user marked this as a favorite
Surely there must be a smart way of getting a flowchart / decision tree / dependency map / linked variables out from the Excel sheet, but I've not found one, and since I'm not well versed in the lingo my search for plugins and solutions has failed me.
What I'd like to end up with is a (probably large) list or graphic representation of which fields effect which other fields, all string variables in those fields, and "n" or somesuch where there's a integer/float. Please let me know if I've underestimated the complexity of this, or if I'm missing an obvious solution.