Handling a 'mixed field'
I have a 'table' I'd like to import from Excel. It has ~55 fields and 100 records of standards for the different 55 parameters. Most fields are just 'static' numeric. However, there are quite a few that contain formulae. I think I can handle these during Import into FM. I can use an Excel VBA macro to adjust syntax in preparation for the FM import. However, 1 problem: Some fields contain both static numbers and formulae, sometimes 2 different formulae.
It's important to keep this Excel spreadsheet as a link to the raw data, but how do I deal with these mixed fields in FM? ie. how do I deal with it while permitting an efficient import from Excel?