Mirel concept-aligned tool for analysing employee participation in projects – data validity in the tool

• Autorzy: Szczęśniak Bartosz

Identyfikatory

DOI

10.29119/1641-3466.2024.197.30

• Języki publikacji: EN

Abstrakty

EN

Purpose: The main research purpose underlying this paper has been to develop and present solutions intended to support validation of the data entered in a tool created in line with the MiRel concept to help in analysing employee participation in the implementation of projects. Design/methodology/approach: The study comprises analysing the manner in which the tool in question can be used and identifying the successive steps taken in order to generate a report of an intended format. Potential problems pertaining to the validity of the data entered in the tool, which may be encountered while individual steps are performed, have been defined. A supporting solution has been developed with reference to each of the problems identified as a means to ensure data validity. Furthermore, collective information panels have been proposed to inform the user about the potential occurrence of any of the problems previously defined. Findings: Data validation supporting solutions can narrow down the range of values admissible to be entered by users or explicitly inform them that the values being entered are invalid. The range of admissible values can also be limited by means of the Data Validation mechanism combined with the Name Manager. The solutions intended to provide information about existing errors can make use of the Conditional Formatting mechanism, coupled with formulas based on standard built-in spreadsheet functions. Practical implications: The solutions proposed in this paper support data validation in the tool in question. There are analogous solutions which can be applied in similar tools aimed at supporting data processing in a different scope within organisations. Social implications: Once successfully applied, the solutions proposed in this paper make the tool in question more reliable and user-friendly. They make the tool easier to use to support data processing in organisations and less prone to problems. Originality/value: The concept described in the paper is the author’s original solution.

Słowa kluczowe

EN

spreadsheet; database; data processing; Microsoft Excel; project management

PL

arkusz kalkulacyjny; baza danych; przetwarzanie danych; Microsoft Excel; zarządzanie projektami

• Wydawca: Wydawnictwo Politechniki Śląskiej
• Czasopismo: Zeszyty Naukowe. Organizacja i Zarządzanie / Politechnika Śląska
• Rocznik: 2024
• Tom: z. 197
• Strony: 557--570
• Opis fizyczny: Bibliogr. 24 poz.

Twórcy

autor

Szczęśniak Bartosz

• Silesian University of Technology, Faculty of Organisation and Management, Institute of Economics and Informatics

• https://orcid.org/0000-0002-9683-4629

Bibliografia

• 1. Barreto, H. (2023). Using Excel to Teach Principles of Microeconomics. In: M. Maier, P. Ruder (Ed.), Teaching Principles of Microeconomics (pp. 257-269). Edward Elgar Publishing.
• 2. Barreto, H. (2015). Why excel? The Journal of Economic Education, 46(3), pp. 300-309.
• 3. Cocking, S. (2017). Seven Reasons why Excel is still used by half a billion people worldwide. Irish Tech News, https://irishtechnews.ie/seven-reasons-why-excel-is-still-used-by-half-a-billion-people-worldwide/, 16.05.2024.
• 4. Jackson, M., Staunton, M. (2004). Zaawansowane modele finansowe z wykorzystaniem Excela i VBA. Gliwice: Helion.
• 5. Knight, G. (2006). Analyzing Business Data with Excel. Sebastopol: O'Reilly Media.
• 6. Krivokapić, J., Todorović, I., Komazec, S., Marič, M., Miloš, J. (2014). Using Spreadsheet as a Tool in Organizational Analysis. 33rd International Conference on Organizational Science Development FOCUS 2020 March 19th– 21st2014, Portorož, Slovenia.
• 7. Kusztelak, P. (2020). Microsoft Excel w pracy finansisty. Analiza i modelowanie danych finansowych. Warszawa: PWE.
• 8. Mangiero, G.A., Manley, J., Mollica, J.T. (2010). Improving pedagogy through the use of dynamic Excel presentations in financial management courses. American Journal of Business Education (AJBE), 3(1), pp. 91-106.
• 9. Najihah, J., Hanyza, A. (2019). Usage of Microsoft Excel Spreadsheet as Accounting Tools in SME Company. INWASCON Technology Magazine, Vol I, pp. 23-25, doi:10.26480/itechmag.01.2019.23.25.
• 10. Oleński, J. (2001). Ekonomika informacji. Podstawy. Warszawa: PWE.
• 11. Oleński, J. (2002). Ekonomika informacji. Metody. Warszawa: PWE.
• 12. Próchnicki, W. (2012). Zastosowanie Excela w pracy analityka finansowego, specjalisty ds. controllingu i analityka sprzedaży. Gliwice: Helion.
• 13. Sroka, J., Panasiuk, A., Stencel, K., Tyszkiewicz, J. (2015). Translating Relational Queries into Spreadsheets. IEEE Transactions On Knowledge and Data Engineering, 27(8), pp. 2291-2303.
• 14. Szczęśniak, B. (2017). Microtools Based on the Relational Data Model - representation of entities in a spreadsheet. 17th International Multidisciplinary Scientific GeoConference SGEM 2017, 17(21), ISBN: 978-619-7408-01-0, 29 June - 5 July, Albena, Bulgaria, pp. 447-454.
• 15. Szczęśniak, B. (2018a). Microtools Based On The Relational Data Model - transition from type II to type I of entity representation. 18th International Multidisciplinary Scientific GeoConference SGEM 2018, 18(2.1), ISBN: 978-619-7408-39-3, 02-08 July, Albena, Bulgaria, pp. 553-560.
• 16. Szczęśniak, B. (2018b). Microtools based on the relational data model - conformity between foreign and primary keys. XV International Conference Multidisciplinary Aspects of Production Engineering (MAPE), 1(1), ISBN: 978-83-65265-25-8, 5-8 September, Zawiercie, Poland, pp. 491-497.
• 17. Szczęśniak, B. (2020a). Microtools based on the relational data model for improvement of information processes - multiplicity of relationships, and mandatory nature of relationships and attributes. In: K.S. Soliman (Ed.), Education Excellence and Innovation Management: a 2025 Vision to Sustain Economic Development during Global Challenges (pp. 10537-10544). Proceedings of the 35th International Business Information Management Association Conference (IBIMA), 1-2 April 2020 Seville, Spain.
• 18. Szczęśniak, B. (2021). MiRel concept-conforming tool for supporting service quality measurement by the SERVQUAL method. In: K.S. Soliman (Ed.), Innovation management and information technology impact on global economy in the era of pandemic. Proceedings of the 37th International Business Information Management Association Conference (IBIMA), 30-31 May 2021, Cordoba, Spain, pp. 12207-12218.
• 19. Szczęśniak, B., Molenda, M. (2013). Spreadsheet application supporting the x-r control chart. Conference Proceedings of the 22th Conference Modern Mathematical Methods in Engineering (3mi), ISBN: 978-80-248-3234-0, June 3-5, Horni Lomna, Czech Republic, pp. 128-134.
• 20. Szczęśniak, B. (2023). MiRel concept-aligned tool for analysing employee participation in projects. Scientific Papers of Silesian University of Technology. Organization and Management Series, vol. 185, pp. 455-470. https://doi.org/10.29119/1641-3466.2023.185.25
• 21. Tyszkiewicz, J. (2010). Spreadsheet As a Relational Database Engine. Proceedings of the 2010 ACM SIGMOD International Conference on Management of data, ISBN: 978-1-4503-0032-2, June 2010, Indianapolis, USA, pp. 195-206.
• 22. Van der Aalst, W. (2016). Process Mining - Data Science in Action. Springer.
• 23. Winston, W.L. (2019). Analiza marketingowa. Praktyczne techniki z wykorzystaniem analizy danych i narzędzi Excela. Gliwice: Helion.
• 24. Zasadzien, M., Szczesniak, B., Skotnicka-Zasadzien, B. (2017). Implementation of maintenance employees' work time scheduling. Piman Limpaphayom, Gordon Huang (Eds.). Proceedings of the Second International Conference on Economic and Business Management (Febm 2017), Shanghai, October 21-23, 2017. Atlantis Press, pp. 226-231.