Using Excel to reduce a Square Matrix

Kód výsledku v IS VaVaI

<a href="https://www.isvavai.cz/riv?ss=detail&h=RIV%2F62156489%3A43110%2F12%3A00194328" target="_blank" >RIV/62156489:43110/12:00194328 - isvavai.cz</a>

Výsledek na webu

—

DOI - Digital Object Identifier

—

Jazyk výsledku

angličtina

Název v původním jazyce

Using Excel to reduce a Square Matrix

Popis výsledku v původním jazyce

When solving operations research problems, one can use either specialised computer programs such as Lingo, Lindo, Storm or more universal programs such Excel, Matlab, and R. To obtain the input data, one can use either a program editor or other programscommonly available such as Excel. While the problem-solving methods, being part of various programs, are the subjects of numerous publications, the way the input data are obtained, recorded, and processed receives far less attention although this part ofproblem-solving requires considerable effort and, if the method for data recording is inadequate, may cause subsequent difficulties in their further processing. This paper is concerned with some Excel tools that can be used to obtain and subsequently modify such a square matrix. In her degree project, Kourková, 2009 was looking for an efficient method of reducing an Excel matrix. She had found no relevant papers on this subject concluding that the authors of the commercial program had n

Název v anglickém jazyce

Using Excel to reduce a Square Matrix

Popis výsledku anglicky

When solving operations research problems, one can use either specialised computer programs such as Lingo, Lindo, Storm or more universal programs such Excel, Matlab, and R. To obtain the input data, one can use either a program editor or other programscommonly available such as Excel. While the problem-solving methods, being part of various programs, are the subjects of numerous publications, the way the input data are obtained, recorded, and processed receives far less attention although this part ofproblem-solving requires considerable effort and, if the method for data recording is inadequate, may cause subsequent difficulties in their further processing. This paper is concerned with some Excel tools that can be used to obtain and subsequently modify such a square matrix. In her degree project, Kourková, 2009 was looking for an efficient method of reducing an Excel matrix. She had found no relevant papers on this subject concluding that the authors of the commercial program had n

Druh

J_x - Nezařazeno - Článek v odborném periodiku (Jimp, Jsc a Jost)

CEP obor

BB - Aplikovaná statistika, operační výzkum

OECD FORD obor

—

Projekt

—

Návaznosti

S - Specificky vyzkum na vysokych skolach

Rok uplatnění

2012

Kód důvěrnosti údajů

S - Úplné a pravdivé údaje o projektu nepodléhají ochraně podle zvláštních právních předpisů

Název periodika

Acta Universitatis Agriculturae et Silviculturae Mendelianae Brunensis

ISSN

1211-8516

e-ISSN

—

Svazek periodika

60

Číslo periodika v rámci svazku

4

Stát vydavatele periodika

CZ - Česká republika

Počet stran výsledku

6

Strana od-do

109-114

Kód UT WoS článku

—

EID výsledku v databázi Scopus

—