Designing a Spreadsheet for a Company

Designing company spreadsheets [IMAGE] I was asked to create a working spreadsheet for electronic ticketing systems, but I will design a spreadsheet for the company called Grand Theater. Grand Theater is a music theater on Montgomery Park in Belfast. The company exhibits two works each month and each piece lasts two weeks. Two pieces are "Port of Portstewart" and "Roberto of Roberto". Due to the rapid change in the theater market, I run a computerized ticketing system for all monthly production and sales.

Users need a user interface in the spreadsheet design that requires companies to access the following content and briefly explain how to use the spreadsheet to employees. Provide time and money for training. They will have to train some staff, but not that much. The following table is in the spreadsheet. * A spreadsheet that combines three different types of Memory Stick (32MB, 64MB, 128MB) and each side cost into the same spreadsheet is also necessary. The cost of each MP3 player is not a memory stick. Thus, the staff can choose which type of Memory Stick MP3 player and spreadsheet the company or customer would like to be able to calculate the cost of a MP3 player with a Memory Stick.

Prior to finding Airtable, Lane used spreadsheets to manage all of the company's (literally) moving parts. This is not an ideal solution. "This is not the design goal of the spreadsheet, if you share the spreadsheet with someone in the company, there are two versions and you can not adjust it." Colleagues are added as collaborators who can view and change in real time. Currently, Lane uses Airtable to track issues and exchange inventory for bicycle parts. "As long as the failed component is in the field, we will record the information here," says Lane. In order to quickly enter the necessary information, he used a form automatically generated from an existing form.

In the second stage, the company began creating business spreadsheets. Since spreadsheets can be easily created, it is a temporary convenient option to support information management of important business processes, not only all calculations applied to data, but also static data and changing data included. A common application for operating a spreadsheet is to manage a list of services such as inventory and customer confidential information. The third phase began in 2005, and advanced network technologies such as Ajax appeared. A new generation of online spreadsheets appeared. Online tools such as G - Sheets, Smartsheets, and ZOHO have many functions of desktop applications, and users can collaborate online in real time. This is where we are today. What's next?