• ...databases

In this example the conversion of dates between two different calendar systems is a business requirement for a synagogue. Clicking either button converts to and from each date, and confirms the Hebrew name of the month and whether the day is Shabbat, which is important information for managing member records at the synagogue. Clicking a button on a different form uses the data conversion table to find the next UK anniversary of the Hebrew data of birth and add it to the database, greatly assisting staff, who previously had to do the conversion manually.

• ...and spreadsheets

Excel spreadsheets (workbooks) developed for small businesses will typically use rules to convert data, based on your operational requirements. An example would be the conversion of a manual system for calculating insurance premiums, into a quote engine written in Excel, that calculates the final premium based on input parameters from the user, based on rules based on look up tables. Another example might be a workbook that makes extensive use of pivot tables to manipulate accounts for the provision of meaningful sales information.