Overall, I am very impressed with Quantrix.
I’ve really appreciated the ‘Skip’ clause, and find it so obvious and useful that it is difficult to understand why it wasn’t available in improv.
Your support for fractions is brilliant and unique. I can imagine many potential VAR opportunities for this locally — throughout the Pacific Northwest — especially in the lumber and construction industries where decimal notation isn’t used as often as fractions.
I haven’t yet experimented with a multi-dimensional paste into Quantrix, but that capability suggests huge potential. What about a multi-dimensional link? It would be nice to get beyond stale data. Is that in the works? Placing database Queries in Quantrix formulas would be very powerful, especially with Quantrix’ on the fly filtering capability.
Returning to the VAR idea above, it would be nice to have some basic forms construction available, for dressing up the assumptions table as one example. I can think of a half dozen interactive forms that I would build if Quantrix were capable of it. I am quite interested in mentions of a scripting capability.
Features that I’ve missed in Quantrix include a window menu, or a tabbed interface to ease navigation (I’m running a Vaio Notebook with just 1024×768 resolution). I have also looked for the Quantrix equivalent of Improv’s presentation, that would allow for the collection and output with Quantrix of several formated views and charts on one or more pages.
I’m wondering if any more thought has been given to the idea of building forms with Quantrix? Essentially I’m looking for a way to implement a series of variable invoices.
I realize that the direction I will be writing about below is more in the direction of a dedicated accounting package than a general financial analysis tool, but without implementing all of the “bells and whistles” of the former, just how good a fit could quantrix be now or in future for building integrated solutions? Anyone who has ever attempted to build such a thing in a spreadsheet, knows that it [i:1ndi8278]is [/i:1ndi8278]possible, but the solution doesn’t extend or scale very well.
The reason why I’m exploring this is that it is fairly common in my local market for contractors to work with both Advances and holdbacks. I’ve got a model that tracks these fairly well, but I’m manually updating the advances and invoices.
In the scenario I have in mind: each “invoice” would have a variable number of line items (representing products and services – with corresponding tax calculations), and some standardized calculations in summary. Other matrix should be able to summarize various data accross invoices. Ideally, these invoices would track multiple projects and customers.
Would it be better to utilize data-links to spreadsheets or databases? (Better utilization of specialized applications integrated for a particular solution?)