Spreadsheet as a Means to Support Working Time Scheduling - Data Integrity in a Spreadsheet Tool

• Autorzy: Bartosz Szczęśniak
• Języki publikacji: EN

Abstrakty

EN

Spreadsheets are commonly used in nearly every organization. The tools created by their means may be used to support a multitude of diversified information processes handled in businesses. Such tools can be built in accordance with the concept of 'Microtools Based on the Relational Data'. One of the problems that must be addressed while such a tool is being created is to ensure the integrity of the data stored in the tool. The article addresses a selection of solutions proposed and applied in this respect in a tool supporting a process in which the working time of maintenance department employees is scheduled.(original abstract)

Słowa kluczowe

EN

Spreadsheets; Organization of business processes; Relation databases; Information process; Working time

PL

Arkusze kalkulacyjne; Organizacja procesów biznesowych; Relacyjne bazy danych; Proces informacyjny; Czas pracy

• Czasopismo: Zeszyty Naukowe. Organizacja i Zarządzanie / Politechnika Śląska
• Rocznik: 2019
• Numer: z. 135 Contemporary Management
• Strony: 169--179

Twórcy

autor

Bartosz Szczęśniak

• Silesian University of Technology, Poland

Bibliografia

• 1. Carlberg, C. (2009). Microsoft Excel 2007 PL. Analizy biznesowe. Rozwiązania w biznesie. Gliwice: Helion.
• 2. Cunha, J., Saraiva, J., and Visser, J. (2009). From spreadsheets to relational databases and back. PEPM '09: Proceedings of the 2009 ACM SIGPLAN Workshop on Partial Evaluation and Program Manipulation. New York: ACM, 179-188. doi:10.1145/ 1480945.1480972.
• 3. Jackson, M., and Staunton, M. (2004). Zaawansowane modele finansowe z wykorzystaniem Excela i VBA. Gliwice: Helion.
• 4. Knight, G. (2006). Excel. Analiza danych biznesowych. Gliwice: Helion.
• 5. Sroka, J., Panasiuk, A., Stencel, K., and Tyszkiewicz, J. (2015). Translating Relational Queries into Spreadsheets. IEEE Transactions On Knowledge and Data Engineering, 27(8), 2291-2303. doi:10.1109/TKDE.2015.2397440.
• 6. Szczęśniak, B. (2010). Zastosowanie arkusza kalkulacyjnego do wspomagania metody ABC. Zeszyty Naukowe Politechniki Śląskiej, seria Organizacja i Zarządzanie, 50, 23-33.
• 7. Szczęśniak, B. (2016). Mikronarzędzia bazujące na relacyjnym modelu danych a rozwój specjalizacji inteligentnych. Systemy Wspomagania w Inżynierii Produkcji - Metody i Narzędzia Inżynierii Produkcji dla Rozwoju Inteligentnych Specjalizacji, 4(16), 121-131.
• 8. Szczęśniak, B. (2017). Microtools Based on the Relational Data Model - representation of entities in a spreadsheet. 17th International Multidisciplinary Scientific GeoConference SGEM 2017, Conference Proceedings, Informatics, geoinformatics and remote sensing, 17, 21. Sofia: STEF92 Technology Ltd., 447-454. doi:10.5593/SGEM2017/21/S07.057.
• 9. Szczęśniak, B. (2018). Microtools Based On The Relational Data Model - transition from type II to type I of entity representation. 18th International Multidisciplinary Scientific GeoConference SGEM 2018, Conference Proceedings, Informatics, Geoinformatics and Remote Sensing, 18, 2.1. Sofia: STEF92 Technology Ltd., 553-560. doi:10.5593/ sgem2018/2.1/S07.070.
• 10. Szczęśniak, B. (2018). Microtools based on the relational data model - conformity between foreign and primary keys. Conference proceedings MAPE 2018. XV International Conference Multidisciplinary Aspects of Production Engineering, 1, 1. Wydawnictwo PANOVA, 491-497. doi: 10.2478/mape-2018-0062.
• 11. Tyszkiewicz, J. (2010). Spreadsheet As a Relational Database Engine. SIGMOD '10 Proceedings of the 2010 ACM SIGMOD International Conference on Management of data. New York: ACM, 195-206. doi:10.1145/1807167.1807191.
• 12. Wilczewski, S., and Wrzód, M. (2008). Excel 2007 w firmie. Controlling, finanse i nie tylko. Gliwice: Helion.
• 13. Winston, L.W. (2011). Microsoft Excel 2010. Data Analysis and Business Modeling. Washington: Microsoft Press.
• 14. Witkowski, A., Bellamkonda, S., Bozkaya, T., Folkert, N., Gupta, A., Sheng, L. and Subramanian, S. (2003). Business modeling using SQL spreadsheets. Proceedings of the 29th international conference on Very large data bases. VLDB Endowment, 1117-1120.
• 15. Witkowski, A., Bellamkonda, S., Bozkaya, T., Naimat, A., Sheng, L., Subramanian, S. and Waingold, A. (2005). Query by Excel. VLDB '05 Proceedings of the 31st international conference on Very large data bases. Trondheim: VLDB Endowment, 1204-1215.
• 16. Zasadzień, M., Szczęśniak, B., and Skotnicka-Zasadzień, B. (2017). Implementation of maintenance employees' work time scheduling. Proceedings of the Second International Conference on Economic and Business Management. FEBM 2017. Atlantis Press, 226-231. doi:10.2991/febm-17.2017.29.

Identyfikatory

DOI

10.29119/1641-3466.2019.135.14