For those interested, I've added an early (unfinished) version of the unit-checker. It handles formulas with basic arithmetic where the units of the formula cell and referenced cells are specified in the cell to the right of each value cell. It doesn't yet take into account the CONVERT function...
Fred...
Thank-you (and all the other kind members) for your feedback. As I mentioned at the start, an early preview (beta) version is available for testing purposes. It's fairly rough around the edges, but good enough for kicking the tyres.
As I mentioned, it will be a commercial product...
Doug - it wouldn't be Javascript - it's just that existing implementations are easier to start from.
Yes, we certainly had a few discussions about related topics. What's changed is that I've forked the original add-in into multiple more well-defined add-ins, and the one I'm referring to here is...
Doug, don't worry about the 'how', but would any of your wishes be covered by having access to these functions inside Excel:
https://mathjs.org/docs/reference/functions.html
Kind regards,
Gareth.
Hi Fred
Thank-you for your insights.
As no moderator has chimed in yet (I will defer to whatever they decide), I'll talk about the product because what you've touched on is very much related to the product road-map, and it's easier talking in specifics. The product is working and downloadable...
Hi John
Thanks for the suggestion. Isn't there already a product for this? http://www.roarksformulas.com
I'll await a moderator's reply to my initial question before sharing any details about my product and if/how UDF's fit into the current vision.
Many thanks,
Gareth.
Hi All
Background
I'm nearing the end of development of an Excel add-in (commercial) which adds new engineering and math features to Excel. I'd like to have a discussion with engineers that use Excel on a daily basis to ensure that the product adds true value and meets their needs and desires...