I can't edit, or I would add the following so I'll add it as a reply.
My spreadsheet has the following colums. Column names with a * have more than one possible entry from a survey of 60 Dwarves. Notes follow:
Civ Rank (Highest Skill Attained)
Civ Prof (What that Highest Skill is)
Mil Rank (Highest Military Skill Attained)
Civ Prof (What that military skill is)
Profession (Cust Profession, specific skill target)
** List of individual skills here **
Stone Preference (All Dwarves like some one sort of stone)
Metal Pref (Half like some one metal)
Gem Pref (Half like some one gem, a RARE dwarf will like diamonds as if it were a material)
Wood (A few may like mangrove)
*Materials (Many mention one or more material preferences)
Color (Many prefer one color)
Craft (Most prefer like making one or more craft objects)
Animals (Many prefer one animal, a few like two, a rare one liked a specific plant, "Pig tails for their twisting stalks" in the same pattern as animals are used
Food (Many prefered at least one type of food, a few as many as three)
Drink (Some preferred one drink, occasionally two)
Hate (A few detest one creature)
If the data pattern can be discovered and directly 'sucked' out of the data into columns with multiple entries where appropriate, the data can be used to target specific dwarves with tasks they appear to enjoy. Those that don't like much of anything can be tasked among two groups: The Standing Army and The Reserved Haulers. And of course the two groups are swapped as needed so you always have a good military that's also hauling & cleaning. I also know the military guys need some craft when relieved so the job of hauling stuff is not so onerous, and 'tabled access' to their preferences is key to figuring out what to task them with so they are happy on leave.
Anyway, that's what I'm doing with my spreadsheet, and I'll cheerfully share my sample data with anyone interested. A 'tab file' format will strip away any potential macro issues, and the only fancy stuff in my table is the switch for coloring names by gender.
I also have a 'TOE', Table of Organization and Equipment, a Skill Levels table, Professions, Metal-->Ore table and non-ore/metal lists. I needed to make sure that an unusual preference material fit the catagory I *thought* it did. *I* think of Coral, Jade, Pearl and such as 'gems', but they are materials. Aventurine is a gem and not an ore, and so on.
I'll try to keep an eye here, or I can be emailed at asmith@mik-maq.com for a private request of a copy of my table.
Then if it's possible to have Dwarven Taskmaster extract all that info *for* me, that would be "th3 W1n!" Thank you for the software as it is, and your time and thought into it.
--Romaq
--Romaq