MIREL CONCEPT-ALIGNED TOOL FOR ANALYSING EMPLOYEE PARTICIPATION IN PROJECTS
Bartosz Szczęśniak · Scientific Papers of Silesian University of Technology Organization and Management Series · 2023
Purpose: The main purpose of the study is to develop and present a spreadsheet-based tool aligned with the MiRel concept to support data processing process in the analysis of employee participation in project implementation by automating the generation of a required report.The process for which the tool is created is an actual process implemented in an organisation operating on the market.Design/methodology/approach: The process in which a required report is generated has been analysed with particular attention to the data structure typical of the problem in question.The entities it contains along with the associated attributes have been identified.Connections between individual entities have been illustrated using an entity relationship model.The author has proposed methods for both data entry as well as entity representation in the spreadsheetbased tool.Mechanisms employed to transfer data from a form to tables representing individual entities have been discussed.The process in which the required report is created has been divided into a number of steps.For each of them, a target effect has been defined and specific mechanisms enabling the target to be attained have been proposed.Findings: A spreadsheet provides an utterly sufficient environment to create a tool supporting the process subject to the research.Such a tool can be successfully created in line with the MiRel concept.Despite the fact that the required report in question is strictly defined in terms of its graphical form that does not match the charts and graphic elements available in MS Excel, it is possible to generate it automatically without having to use the VBA code.Its adequate graphical form can be obtained by means of conditional formatting provided that data have been correctly arranged in cells.Where the report is to be generated in a purely graphical form, the tool in question can be expanded with a relatively simple VBA procedure enabling such a report to be generated on the basis of its current form.Practical implications: The solution proposed in the paper can be successfully applied in practice to support the process analysed. Social implications:The solution proposed in the paper makes it possible to streamline the performance of the process analysed by relieving employees of the laborious and repeatable obligatory activities as well as reducing the risk of errors appearing in the report created in the process.Originality/value: The concept described in the paper is the author's original solution.