Informacja

Drogi użytkowniku, aplikacja do prawidłowego działania wymaga obsługi JavaScript. Proszę włącz obsługę JavaScript w Twojej przeglądarce.

English (EN)·Polski (PL)·Yкраїнський (UK)
Przejdź do strony domowej biblioteki Centralna Biblioteka Wojskowa Link otwiera się w nowym oknie Logo biblioteki Prolib Integro - strona głównaCentralna Biblioteka Wojskowa

Wyszukujesz frazę "spreadsheet" wg kryterium: Temat

  Lista filtrów
Wyrównaj
    Wyświetlanie 1-7 z 7
    Tytuł:
    Concept of supportive spreadsheet application in the survey of production departments’ satisfaction with services of maintenance departments
    Autorzy:
    Szczęśniak, B.
    Powiązania:
    https://bibliotekanauki.pl/articles/359087.pdf
    Data publikacji:
    2012
    Wydawca:
    Akademia Morska w Szczecinie. Wydawnictwo AMSz
    Tematy:
    spreadsheet
    internal customer
    maintenance
    Opis:
    In order to be able to use the method of surveying satisfaction of production departments with the services provided by maintenance departments, one must first acquire and analyse considerable amounts of data. Such an attempt may only be successful if an appropriate information tool is used. This article provides a discussion on the concept of an MS Excel spreadsheet application for the sake of creating such a tool. The author has proposed a specific data structure enabling storage of the data acquired in the course of research. The entities occurring in it have been identified and discussed, and so have the attributes assigned to individual entities. The author has also elaborated on the spreadsheet mechanisms which allow for data processing in accordance with the premises of the aforementioned method.
    Źródło:
    Zeszyty Naukowe Akademii Morskiej w Szczecinie; 2012, 32 (104) z. 1; 91-96
    1733-8670
    2392-0378
    Pojawia się w:
    Zeszyty Naukowe Akademii Morskiej w Szczecinie
    Dostawca treści:
    Biblioteka Nauki
    Artykuł
    Tytuł:
    Microtools Based on the Relational Data Model – Conformity between Foreign and Primary Keys
    Autorzy:
    Szczęśniak, B.
    Powiązania:
    https://bibliotekanauki.pl/articles/2064919.pdf
    Data publikacji:
    2018
    Wydawca:
    STE GROUP
    Tematy:
    spreadsheet
    database
    business process improvement
    information process
    Opis:
    Tools which support and automate the execution of information processes may be created in a spreadsheet by following the author’s signature concept of “Microtools Based on the Relational Data Model”. While developing them, one must apply adequate solutions enabling representation of identified entities and ensuring data integrity as well as acquisition of the reports and collations assumed to be generated. This article addresses the problem of conformity between values of foreign keys in child entities and values of primary keys in parent entities. Four cases of relationships between a parent entity and a child entity have been discussed. One of the criteria that differentiates between these cases is the occurrence of a simple key or a composite key. Another applicable criterion is the sequence in which data are entered using the tool. With regard to all the identified cases, solutions that support data integrity have been presented and discussed. In accordance with the concept in question, the solutions proposed in the paper make use of standard spreadsheet features and components, without involving any additional code created in any programming language.
    Źródło:
    Multidisciplinary Aspects of Production Engineering; 2018, 1, 1; 491--497
    2545-2827
    Pojawia się w:
    Multidisciplinary Aspects of Production Engineering
    Dostawca treści:
    Biblioteka Nauki
    Artykuł
    Tytuł:
    Online forms and spreadsheet as means to support the ABCD method
    Autorzy:
    Szczęśniak, Bartosz
    Powiązania:
    https://bibliotekanauki.pl/articles/27313420.pdf
    Data publikacji:
    2023
    Wydawca:
    Politechnika Śląska. Wydawnictwo Politechniki Śląskiej
    Tematy:
    spreadsheet
    quality management
    data processing
    arkusz
    zarządzanie jakością
    przetwarzanie danych
    Opis:
    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.
    Źródło:
    Zeszyty Naukowe. Organizacja i Zarządzanie / Politechnika Śląska; 2023, 169; 679--690
    1641-3466
    Pojawia się w:
    Zeszyty Naukowe. Organizacja i Zarządzanie / Politechnika Śląska
    Dostawca treści:
    Biblioteka Nauki
    Artykuł
    Tytuł:
    Riešenie úloh nelineárnej regresie pomocou tabuľkového kalkulátora
    Solution of nonlinear regression tasks using spredsheet application
    Autorzy:
    GUBO, Štefan
    Powiązania:
    https://bibliotekanauki.pl/articles/456762.pdf
    Data publikacji:
    2016
    Wydawca:
    Uniwersytet Rzeszowski
    Tematy:
    nelineárna regresia
    tabuľkový kalkulátor
    MS Excel.
    non-linear regression
    spreadsheet application
    Opis:
    Nelineárna regresia je druh regresnej analýzy, kde skúmané údaje sú modelované funkciou, ktorá je nelineárnou kombináciou parametrov modelu a je závislá od jeden alebo viacero nezávislých premenných. V príspevku uvádzame riešenie úloh nelineárnej regresie v tabuľkovom kalkulátore MS Excel 2013.
    Nonlinear regression is a form of regression analysis in which observational data are modeled by a function which is a nonlinear combination of the model parameters and depends on one or more independent variables. In this paper we illustrate how to use the MS Excel 2013 spreadsheet application in solving non-linear regression tasks.
    Źródło:
    Edukacja-Technika-Informatyka; 2016, 7, 1; 194-201
    2080-9069
    Pojawia się w:
    Edukacja-Technika-Informatyka
    Dostawca treści:
    Biblioteka Nauki
    Artykuł
    Tytuł:
    Online forms and spreadsheet as means to support quality measurement by the SERVQUAL method
    Autorzy:
    Szczęśniak, Bartosz
    Powiązania:
    https://bibliotekanauki.pl/articles/27313527.pdf
    Data publikacji:
    2022
    Wydawca:
    Politechnika Śląska. Wydawnictwo Politechniki Śląskiej
    Tematy:
    spreadsheet
    database
    MiRel
    data processing
    quality management
    arkusz
    baza danych
    przetwarzanie danych
    zarządzanie jakością
    Opis:
    Purpose: The main purpose of the research is to devise and present a concept for a solution enabling integration of popular off-the-shelf online forms with a tool aligned with the MiRel concept used for quality measurement by application of the SERQUAL method. Design/methodology/approach: The analysis performed by the author comprised various possibilities of using standard features of popular online forms to store data for purposes of the SERVQUAL method. This involved identification of several potential layouts of the master table where the answers previously received are kept. The analysis concerned the data structure applied in the tool designed, as proposed in the literature, in accordance with the MiRel concept, to support the method in question. The elements identified in this structure were the attributes whose values should be entered directly and manually in tables as well as those whose values should be added automatically on the basis of the answers previously received. Solutions were developed to enable automatic data migration from the master table to the tool’s respective tables. Findings: The data required for purposes of the SERVQUAL analysis, supported by a tool created in a spreadsheet according to the MiRel concept, can be successfully stored by means of commonly available online forms. What proves to be problematic is the impossibility of verifying the correctness of the answers in terms of the relevance of individual dimensions, yet in this respect both the verification and potential adjustment of the answers received can be inherent in the mechanism responsible for data migration from the master table to the tool’s tables. A fully functional solution enabling data to be retrieved from the master table and moved to the tool’s tables can be developed using built-in spreadsheet features only, without the need for any code created in any programming language. Practical implications The solution proposed in the paper can be used in practice when measuring quality using the SERVQUAL method. Originality/value: The concept described in the paper is the author’s original solution.
    Źródło:
    Zeszyty Naukowe. Organizacja i Zarządzanie / Politechnika Śląska; 2022, 161; 273--281
    1641-3466
    Pojawia się w:
    Zeszyty Naukowe. Organizacja i Zarządzanie / Politechnika Śląska
    Dostawca treści:
    Biblioteka Nauki
    Artykuł
    Tytuł:
    Computer aided assembly planning using MS Excel software – a case study
    Autorzy:
    Brzozowska, Jolanta
    Gola, Arkadiusz
    Powiązania:
    https://bibliotekanauki.pl/articles/1837783.pdf
    Data publikacji:
    2021
    Wydawca:
    Polskie Towarzystwo Promocji Wiedzy
    Tematy:
    assembly
    production planning
    support
    spreadsheet
    MS Excel
    montaż
    planowanie produkcji
    wsparcie
    arkusz kalkulacyjny
    Opis:
    The issue of planning assembly operations remains crucial decision-making area for many of manufacturing companies. It becomes particularly significant in case of small and medium enterprises that perform unit or small-scale production, where the option of applying specialized software is often very limited – both due to high purchase price, but also due to its applicability to single unit manufacturing, that is executed based on individual customer orders. The present article describes the possibility of applying the MS Excel spreadsheet in the planning of machine assembly processes. It emphasises, in particular, the method for using the spreadsheet in subsequent stages of the process, and the identification of possible causes that have impact on problems with the planning process. We performed our analysis on the basis of actual data from one of the machine industry enterprises that manufactures in central Poland.
    Źródło:
    Applied Computer Science; 2021, 17, 2; 70-89
    1895-3735
    Pojawia się w:
    Applied Computer Science
    Dostawca treści:
    Biblioteka Nauki
    Artykuł
    Tytuł:
    A spreadsheet to support the Suzuki ABCD method
    Autorzy:
    Szczęśniak, Bartosz
    Powiązania:
    https://bibliotekanauki.pl/articles/1931567.pdf
    Data publikacji:
    2020
    Wydawca:
    Politechnika Śląska. Wydawnictwo Politechniki Śląskiej
    Tematy:
    assessment of significance of causes
    improvement of information processes
    quality management
    spreadsheet
    ocena istotności przyczyn
    usprawnienie procesów informacyjnych
    zarządzanie jakością
    arkusz kalkulacyjny
    Opis:
    Purpose: Main aims of research is to create and present the concept of using a spreadsheet to create a tool supporting the assessment of significance of causes in accordance with the principles of the Suzuki ABCD method. Design/methodology/approach: The ABCD method itself was discussed first. Based on the literature research, several different variants have been identified. One chosen option has been described in more detail. A support tool has been proposed for this option. Its structure was discussed. The two main elements of the tool are presented in detail, including the workbook, in which the assessment is performed, and the aggregate workbook. Solutions used to support individual significance assessments and solutions for the automatic generation of required summaries were presented and discussed. Findings: The presented solution shows that the spreadsheet can be treated as a sufficient environment to create a tool supporting the Suzuki ABCD analysis. The assumed functionality of the tool can be obtained without the need to register macros or create code in any programming language. Practical implications: The presented solution can be used when applying the Suzuki ABCD method in practice. Originality/value: The described concept is an original solution created by the author.
    Źródło:
    Zeszyty Naukowe. Organizacja i Zarządzanie / Politechnika Śląska; 2020, 142; 205-216
    1641-3466
    Pojawia się w:
    Zeszyty Naukowe. Organizacja i Zarządzanie / Politechnika Śląska
    Dostawca treści:
    Biblioteka Nauki
    Artykuł
      Wyświetlanie 1-7 z 7

      Ta witryna wykorzystuje pliki cookies do przechowywania informacji na Twoim komputerze. Pliki cookies stosujemy w celu świadczenia usług na najwyższym poziomie, w tym w sposób dostosowany do indywidualnych potrzeb. Korzystanie z witryny bez zmiany ustawień dotyczących cookies oznacza, że będą one zamieszczane w Twoim komputerze. W każdym momencie możesz dokonać zmiany ustawień dotyczących cookies