Oriel Hafsa May 1, 2021 Spreadsheet
Instead of listing the items on a paper list the items can be just as easily listed on a spreadsheet which will add up the items as required without the requirement to double check the adding up is accurate. Such a list has a history in accounting term as a sales day book and a purchase day book. To achieve the required analysis of sales and purchases all that is required is to write into the top of each of the spreadsheet columns the titles of the analysis headings required. Then repeat the value of each transaction in the total column into the analysis columns. Use the spreadsheet technology to add up each column and you have an effective bookkeeping spreadsheet.
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.
”Spreadsheets for Actors” comprises a wide variety of programmed spreadsheets especially created for professionals in the entertainment industry. Whether you are an actor, producer, editor or director, you will greatly benefit from the ”Spreadsheets for Actors” package. The ”Spreadsheets for Actors” package facilitates a series of processes, ranging from creating and managing budgets to keeping track of unpredictable income and expenses. The mentioned package includes valuable programmed spreadsheets such as the ”Income and Residual Tracker” – provides professionals in the entertainment branch with detailed information regular and residual income; ”The Biorhythm Plotter” – helps users in planning various events and actions based on Primary and Secondary Biorhythms (the spreadsheet solution allows users to choose the right timing for their actions according to personal intellectual, psychological and physiological factors); ”Basic Actor Package” – designed to facilitate the process of calculating expenses.
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.
Many large companies have outsourced the management and support of their IT systems to third parties. Very strict management processes and procedures for the acquisition and implementation of new systems have been introduced. A side-effect of this policy is a tendency for employees to make extensive use of spreadsheets and macro programming languages for information storage, analysis, and manipulation (Scanlan et al, 2006). These applications establish themselves as a legitimate part of the business processes of the organization despite the essentially uncontrolled nature of their development. This is a worrying trend as these applications are frequently undocumented, rarely fully tested or validated, and are produced by people who often have little or no formal training in good systems development practice. An alternative approach of User Driven Modelling is required, because large spreadsheets are unmaintainable in the long run.
Once you are in the Compare Side by Side option, you can choose to activate another feature which is the Synchronous Scrolling. Just find the icon in the menu so that you can start scrolling the mouse pointer on the first document while doing the same thing on the other. If you do not want this feature to be enabled, you can click on the icon again and then the synchronous scrolling will be deactivated instantly.