Home » Spreadsheet Lovers
The optimal solution depends on the customer’s goals and expertise.
STEP 1 approval of requirements.
STEP 2 development
STEP 3 Delivery and warranty
STEP 4 Maintenance
Typically, MS Word produces a PDF which can then be printed on various media, mainly paper.
Naturally on the web it is possible to download a PDF document paginated with the typical rules of paper.
A table intended for the web has other principles:
How many formulas have been added in office 365?
35 formulas. Then today we reached 450.
Furthermore, the syntax, logic, and updates on the formulas active today have undergone frequent changes.
So, a local emulator used by plug-ins and proprietary developed software may not respond as expected at any moment.
This problem is experienced by all software that import Word & Excel documents. It was Microsoft’s most effective way of maintaining its best-selling position for nearly 30 years.
But an emulator solves many problems… and for this reason we propose an interface within your program that emulates Excel and makes a request to one of our servers which provides you with the same result that Excel would have calculated for you as if you had done it right with your Excel.
This interface is available as a DLL, API and as a WordPress plugin.
The price? Go to the shop /shop/
There are many ways to optimize an Excel spreadsheet. We consider these activities as essential, but others could be added considering the specificity of the application and your specific needs.
Most of the time a database window is converted to CSV and then sent to the partner to allow him to do his post-processing.
However, each time there is some manual work to convert the CSV into the desired Excel which has been equipped with graphics, field formatting etc.
This additional work is sometimes a very high cost and in some cases beyond the competence of the recipient who would be forced to ask for help from a colleague or collaborator.
Therefore, we will have to study the way to save this cost which reduces any errors occurred during post processing.
In fact, Excel is one of the most powerful tools for data presentation, data pre-processing and data post-processing. In short, an irreplaceable companion.
Precisely because it has been matured for over 30 years of continuous improvements, it is still too little known.
Therefore, the first step is to bypass the passage from CSV which makes you lose all the necessary information, and which has a high cost to restore them.
The second step consists in integrating the Excel sheet directly into the data source that feeds it whenever the final recipient-customer wishes. There are several technologies. The most common one is the ODBC technique which enables the Excel sheet to enter a particular database view.
This technique, for example, constitutes a simple and elegant solution for reprocessing the data deposited within the CRM and for which the end user has the permissions to retrieve them whenever he needs it, avoiding asking for help from an expert or ask for temporary permits every time.
This powerful feature of Excel is particularly useful in drafting a company’s budget. A modern company works constantly on the edge of the budget which must be planned, which must be implemented otherwise the sustainability of the company is at great risk. So everyone makes a budget and everyone is busy modifying it and notifying the changes and getting them approved.
So, if Excel has this function, it is an important fact but in a logic of digital innovation it is not enough.
One function must be webized and therefore the functionality of Excel must be replicated within business procedures that are typically on the web.
This type of web-Excel-Budget-What-if-simulator integration is within the competence of our company, and we are ready to study a custom solution to make this periodic and frequent business need easily usable by personnel who do not have specific technological skills.
We comply with the GDPR (General Data Protection Regulation) standards with EU customers and the recently issued ADPPA (American Data and Privacy Protection Act) standard for all other countries in the world.
In particular, we can use the digital sovereignty criteria used by the client, or the digital sovereignty criteria – prepared by us – and resident in the United States or resident in Europe or, at the client’s request, set up an environment resident in the country chosen by the client.
However, even more recently, an agreement was stipulated between the EU and the United States which states that American legislation today is equally valid for European citizens as well.
See Press release10 July 2023 Brussels:
Data Protection: European Commission adopts new adequacy decision for safe and trusted EU-US data flows
ref. ec.europa.eu
You can download here the doc wi894-Adequacy_decision_EU-US_Data_Privacy_Framework_en.pdf
Developing data solutions means coming into contact with customer data – even if only temporarily – and this raises a number of “legal” caveats and security.
We have published our NDP (Non Disclosure Policy) /ndp_non-disclosure_policy which of course could be adapted to the specific needs of each individual client.
STEP 1
we organize a briefing during which we listen to the customer’s needs and collect all the information needed to set up a moke p for the customer’s exclusive use.
STEP 2
We deliver for free a mockup made on an excel sheet that represents the layout of the data without taking too much care of the editorial open of the optimal format of the data.
Along with this mock-up we provide a min/max quote which gives you an extra budget which we guarantee will not be exceeded.
Usually the min/MAX range respects the rule that MAX < 2 * min.
STEP 3
We will produce the advance invoice and as soon as we receive confirmation of the payment we undertake STEP 4.
STEP 4
If the client discovers that our offer remains competitive and is within its available budget, then we proceed to supply a definitive layout and write draft 1 of the requirements which include a chapter dedicated to:
STEP 4
When the customer has signed all the documents produced for approval, and has made the payment envisaged by the agreements, we will start the development and respect the approved timing.
STEP 5
During the development the eventual sprints will be performed, and the various check points will be approved.
At the end of the development, we will collaborate with the customer on the final acceptance test, after which we enter the start-up and guarantee phase.
STEP 6
Once the start-up is complete and the warranty time is over, you enter the application maintenance period which includes the customer care and ticketing service until the end of the contract.
The MS Azure project management system that we use, requires that all requests, specifications, and any type of communication is managed by the devops MS Azure platform.
Every meeting, call, chat is recorded and stored in an area accessible to both the customer and the developers.
So, it is easy to dismiss any controversy and any criticism.
Honestly, there has never been a case of critical relationships with our customers.
Knowledge Base Dedicated Page
Blog Dedicated Page
© 2024 Altos Web Solutions. All Rights Reserved!