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?)
Hello – Thanks for your post and Welcome to Quantrix:
You have raised some very interesting points. I like the forms idea… We have started a ‘template’ section on the web site that is the beginnings of this idea. I could see commonly used ‘forms’ being prepared as templates that could be made readily available to customers and users.
Direct links into databases is high on the list. The next release will have API Plug-in capabilities which will allow users to extend the application. We are currently investigating creating a database plug-in for Quantrix. Look for more news on this in the coming weeks.
The ability to group matrices into a presentation has been raised by other customers. We expect an upcoming release to focus on the presentation functionality of Quantrix.
Thanks for the post!