Relational copy-paste
No$, the interSyntax tool, implements a proprietary technique – relational copy-paste – allowing the duplication in reasoned sequence of Excel spreadsheet fields, without resorting to the “$” usually used in formula references and without manual correction.
Its implementation takes advantage of the observation that most spreadsheet simulations are trained by the repetition of a small number of basic modules. For example, an industrial company includes several factories with a similar structure, each of which can be modeled according to an identical scheme of juxtaposition of workshops, each comprising a certain number of machines entrusted to several teams.
Thus, the creation of a model is reduced to the design of the basic ranges and that of the automated sequence of their duplication. The benefits depend on model size :
- Reactivity and costs: the tedious activity of writing formulas, which weighs up to 90% of the time of creating a model, is reduced by a factor of more than 5. On the other hand, the maintenance of a model is limited to the correction of base bricks or that of the duplication sequence since the automated regeneration by No$ the tool of interSyntax update the model instantly.
- Supervision: the manager making the decisions with the model only cares about validating the basic building ranges and the duplication sequence since the automation guarantees the relevance of the model thus generated, in particular that of the formula references.
- Sharing: when duplication sequences reflect standard decision, managers can illustrate their strategies easily after a few clicks on the interface, without it being necessary for them to have modeling skills. The model can then be shared between decision-makers with an illustration of the consequences of their strategic intentions.
Offers
No$, the interSyntax tool, provides access to user interfaces revisiting and completing the “cut-copy-paste-delete” of classic office automation and allowing programming any sequence of duplication of Excel ranges without using any $.
It is available as Excel addins:
- Web, from the Office store
- VSTO on USB key for offline operation (not yet available)
Each of the formats exists in a free version for initiation and a paid professional version.
The building of a model begins with the design of a minimal scenario containing the basic building ranges in a classical way. These ranges are then copied relationally with No$, (made duplicable and combined by chaining and nesting) by simple selection and clicks on the tool interface. Using the No$ relational paste function finally generates the desired model.
Thus, the modeling work is divided between designers of a minimal scenario including the design of basic ranges and users who deploy them in its completed form. In this organization of modeling work, the designers have the strategic understanding of the economics, and the users know the operational reality.
This modeling process, as it is in all industries, drastically reduces works load in terms of speed, reliability, and quality assurance over the entire cycle. Its implementation improves the performance of decision-making cycle in the broadest sense: faster, more relevant decisions that better consensus generated.
Decision-makers gain weight through credible assertions of which they master all the rationality and, also, benefit from more spared time useful for responsiveness in the exercise of their relational and human responsibilities. Overall, at corporate level, it results better strategic quality through a greater number of opportunities seized more efficiently and with more determination.
Road map
No$, the interSyntax tool, is compatible with other Excel addins and aims to complement them. However, it is planned to integrate the functionalities that take on more value when combined with it. For example :
- constrained optimization,
- risk analysis,
- data processing routines,
- data visualization
- …
Finally, interSyntax will continue to increase the value supplied to model developers and users by improving the interfaces of its tool and by offering new functionalities for:
- decision implementation follow-up,
- model portfolio management,
- access right management,
- interface to VBA,
- model generation speed,
- modeling work organization at corporate level
- …