Online forms and spreadsheet as means to support the ABCD method

• Autorzy: Szczęśniak Bartosz

Identyfikatory

DOI

10.29119/1641-3466.2023.169.40

• Języki publikacji: EN

Abstrakty

EN

Purpose: The main purpose of the study was to develop and demonstrate a concept enabling application of popular and commonly available online forms combined with a spreadsheet to support data collection and processing under the ABCD (Suzuki) method. Design/methodology/approach: The factors which determine the various ways in which the method in question is applied were first identified, and then it was established which of them affected the manner in which the form to be filled by experts is designed. Different variants of the method were identified on such a basis. For individual variants, the possibility of using different types of questions was discussed by considering the features available in the most popular and free-of-charge solutions enabling online forms to be developed. Diverse data layouts were also identified to establish the frameworks in which data are represented in spreadsheet files. Solutions which make it possible to automatically produce the consolidated reports required for purposes of the ABCD method were identified for each of the data layouts originally defined. Findings: When combined with a spreadsheet, popular online forms enable highly efficient data collection and processing with the ABCD method in use. Where the said method is applied according to the variant in which every cause is rated, an adequate data collection form can be created using both the online form solutions subject to analysis. If the method is applied according to the variant in which every rating must be used precisely once, developing a useful tool becomes significantly more complicated. Where this is the case, one can create a suitable form to validate the input data only by using the solution delivered by Google. Additionally, the layout of such a form must be reversed compared to the traditional form functioning under the ABCD method. Considering the diverse variants of the ABCD method linked with various kinds of questions used to build the form, 3 different layouts of the data collected by means of a spreadsheet were identified. With respect to each of them, one can devise a solution to ensure automated generation of the consolidated reports typical of the method in question. Practical implications: The solution proposed in the paper can be applied in practice while using the ABCD (Suzuki) method. Originality/value: The concept described in the paper is the author’s signature solution.

Słowa kluczowe

EN

spreadsheet; quality management; data processing

PL

arkusz; zarządzanie jakością; przetwarzanie danych

• Wydawca: Wydawnictwo Politechniki Śląskiej
• Czasopismo: Zeszyty Naukowe. Organizacja i Zarządzanie / Politechnika Śląska
• Rocznik: 2023
• Tom: z. 169
• Strony: 679--690
• Opis fizyczny: Bibliogr. 16 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. Cholewa-Wójcik, A. (2014). Usefulness verification of the ABCD-Suzuki method in order to analyse the consumer’s needs and requirements concerning cosmetics product packaging. In: J.J. Lewandowski, A. Walaszczyk, I. Jałmużna (Eds.), Product and Packaging. Contemporary Challenges. Łódź: Wydawnictwo Politechniki Łódzkiej, pp. 35-48.
• 2. Knight, G. (2006). Analyzing Business Data with Excel. Sebastopol: O'Reilly Media.
• 3. Kusztelak, P. (2020). Microsoft Excel w pracy finansisty. Analiza i modelowanie danych finansowych. Warszawa: PWE.
• 4. Łańcucki, J. (2003). Podstawy kompleksowego zarządzania jakością TQM. Poznań: Wydawnictwo Akademii Ekonomicznej.
• 5. Łuczak, J. (2007). Metody i techniki zarządzania jakością. Kompendium wiedzy. Poznań: Quality Progress.
• 6. Miller, P. (2011). Systemowe zarządzanie jakością. Koncepcja system, ocean system, wspomaganie decyzji. Warszawa: Difin.
• 7. Próchnicki, W. (2012). Zastosowanie Excela w pracy analityka finansowego, specjalisty ds. controllingu i analityka sprzedaży. Gliwice: Helion.
• 8. Szczęśniak, B. (2012). Concept of supportive spreadsheet application in the survey of production departments’ satisfaction with services of maintenance departments. Scientific Journals Maritime University of Szczecin, vol. 32(104), pp. 91-96.
• 9. Szczęśniak, B. (2017), Koncepcja Mikronarzędzi Bazujących na Relacyjnym Modelu Danych we wspomaganiu procesu analizy niezgodności wyrobów walcowanych. Systemy Wspomagania w Inżynierii Produkcji - Sposoby i środki doskonalenia produktów i usług na wybranych przykładach, vol. 6(8), pp. 59-72.
• 10. Szczęśniak, B. (2020). A spreadsheet to support the Suzuki ABCD method. Scientific Papers Of Silesian University Of Technology, Organization And Management Series, vol. 142, pp. 205-216.
• 11. 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.
• 12. 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.
• 13. Szczęśniak, B. (2010a). Arkusz kalkulacyjny w doskonaleniu procesu układania planu zajęć w szkole specjalnej. In: R. Knosala (Ed.), Komputerowo zintegrowane zarządzanie, vol II (pp. 525-537). Opole: Oficyna Wydawnicza Polskiego Towarzystwa Zarządzania Produkcją,. Retrieved from: http://www.ptzp.org.pl/files/konferencje/kzz/artyk_pdf_2010/ 141_Szczesniak_B.pdf, 15.06.2019.
• 14. Szczęśniak, B. (2010b). Zastosowanie arkusza kalkulacyjnego do wspomagania metody ABC. Zeszyty Naukowe Politechniki Śląskiej. Organizacja i Zarządzanie, vol. 50, pp. 23-33.
• 15. Winston, W.L. (2019). Analiza marketingowa. Praktyczne techniki z wykorzystaniem analizy danych i narzędzi Excela. Gliwice: Helion.
• 16. Zasadzien, M., Szczesniak, B., Skotnicka-Zasadzien, B. (2017). Implementation of maintenance employees' work time scheduling. In: Piman Limpaphayom, Gordon Huang (Eds), Proceedings of the Second International Conference on Economic and Business Management (Febm 2017) (pp. 226-231). Shanghai: Atlantis Press.

Uwagi

Opracowanie rekordu ze środków MNiSW, umowa nr SONP/SP/546092/2022 w ramach programu "Społeczna odpowiedzialność nauki" - moduł: Popularyzacja nauki i promocja sportu (2024).