Calculate the number of equipment rented by a given company.Calculate the income for a given location period.More serious problems will arise when it comes to analyzing the accumulated data, for example: Problem 3 You can not manage to keep records with several people.ģ For example, your accountant has to manage invoices and payments, and your company's employees want to keep records of orders and meetings with customers, but for example, accounting would not want rental employees to have access to payment information. Such an error could not have happened if we had chosen a company from a list.
Afterwards, it will be difficult to know if it is a new client or if a typo was made. Problem 2 We can make a typo in the company name and accidentally write KJ Service instead of KH Service. If we do not, our data will be inconsistent, after which we will not be able to determine which of the phone numbers is up to date. To keep the table up to date, you need to make changes on three lines (and if there are already 500?). Problem 1 First, what will happen if a company changes its phone number? Let's say that the company "KH Services" has as new telephone number 565-55-56. Suppose you are an entrepreneur who offers the rental of construction equipment to other companies and keeps the records on a simple board, as shown in Fig.
Unfortunately, this approach has a number of problems that we will now analyze. This would seem sufficient for complete accounting. Suppose you keep saving something in a classic Excel spreadsheet, as shown in Fig 1.įigure 1.