Charlotte Evy April 19, 2021 Spreadsheet
Spreadsheet: A table of rows and columns, free for the entry of data, or formulae for calculating actions on those data. Each row or column is said to contain many ‘cells‘ and these cells serve as ‘homes‘ for every shred of information. Many spreadsheet applications nowadays have functionality above and beyond the traditional, offering a variety of charts, look-up tables, databases and more functionality than can be mentioned here.
A consideration which influences my research into End-User Programming and Modelling is that organizations should not use proprietary or closed standards for their information. Systems should be designed with the assumption that information, which represents the primary system asset, may eventually need to be migrated to another software tool or environment. Open use of information was the priority for the DATUM project. This project is explained in ‘DATUM Project: Cost Estimating Environment for Support of Aerospace Design Decision Making‘ (Scanlan et al, 2006). Therefore a requirement of this research is that open standard semantic languages are used to represent information, to be used both as input and output of the models. These languages are based on eXtensible Markup Language (XML). These same open standard languages can be used for developing the program code of models.
From businesses to non-profit organizations, spreadsheets are used in different sectors, ranging from Entertainment to Culture to Education and to Health to name but a few. With the emergence of home-based businesses and an increase in the number of entrepreneurs in the marketplace, such software is now highly sought-after among home users as well.
By requesting the services of such specialist spreadsheet-solution-providing companies, business owners can rest assured that their needs will be met with precision, dedication and professionalism. Such companies are empowered by experienced teams of Mathematicians and Microsoft Excel Spreadsheet Designer/Programmers whose goal is to surpass the requirements and desires of their clients.
Small businesses can also benefit from professionally produced bookkeeping spreadsheets that have been specifically arranged not just to produce a list of income and expenses but also in a way that analyze that information in the way the small business requires it. There are two main requirements of the way the financial records are analyzed being to produce a financial profit and loss account for the business on a periodic basis but also to provide the totals of the categories required for taxation purposes.
It is proposed that software and information represented by the software, be separated but represented in the same open standard searchable way. Software and the information it manipulates are just information that has different uses, there is no reason why software must be represented differently from other information. So XML can be used both as the information input and output by the application, and for the definition of the model itself. The model can read or write information it represents, and the information can read from or write to the model. This recursion makes ‘meta-programming‘ possible.