<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE root>
<article xmlns:mml="http://www.w3.org/1998/Math/MathML" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ali="http://www.niso.org/schemas/ali/1.0/" article-type="research-article" dtd-version="1.2" xml:lang="en"><front><journal-meta><journal-id journal-id-type="publisher-id">Vestnik of Samara State Technical University. Technical Sciences Series</journal-id><journal-title-group><journal-title xml:lang="en">Vestnik of Samara State Technical University. Technical Sciences Series</journal-title><trans-title-group xml:lang="ru"><trans-title>Вестник Самарского государственного технического университета. Серия «Технические науки»</trans-title></trans-title-group></journal-title-group><issn publication-format="print">1991-8542</issn><issn publication-format="electronic">2712-8938</issn><publisher><publisher-name xml:lang="en">Samara State Technical University</publisher-name></publisher></journal-meta><article-meta><article-id pub-id-type="publisher-id">20146</article-id><article-id pub-id-type="doi">10.14498/tech.2016.1.%u</article-id><article-categories><subj-group subj-group-type="toc-heading" xml:lang="en"><subject>Articles</subject></subj-group><subj-group subj-group-type="toc-heading" xml:lang="ru"><subject>Статьи</subject></subj-group><subj-group subj-group-type="article-type"><subject>Research Article</subject></subj-group></article-categories><title-group><article-title xml:lang="en">Neural network realization in the spreadsheet</article-title><trans-title-group xml:lang="ru"><trans-title>Реализация нейронной сети в электронной таблице</trans-title></trans-title-group></title-group><contrib-group><contrib contrib-type="author"><name-alternatives><name xml:lang="en"><surname>Hrisanov</surname><given-names>Nikolay N</given-names></name><name xml:lang="ru"><surname>Хрисанов</surname><given-names>Николай Николаевич</given-names></name></name-alternatives><bio xml:lang="en"><p>(Ph.D. (Techn.)), Associate Professor</p></bio><bio xml:lang="ru"><p>(к.т.н., доц.), доцент кафедры «Вычислительная техника»</p></bio><xref ref-type="aff" rid="aff1"/></contrib></contrib-group><aff-alternatives id="aff1"><aff><institution xml:lang="en">Samara State Technical University</institution></aff><aff><institution xml:lang="ru">Самарский государственный технический университет</institution></aff></aff-alternatives><pub-date date-type="pub" iso-8601-date="2016-03-15" publication-format="electronic"><day>15</day><month>03</month><year>2016</year></pub-date><volume>24</volume><issue>1</issue><issue-title xml:lang="en">NO1 (2016)</issue-title><issue-title xml:lang="ru">№1 (2016)</issue-title><fpage>41</fpage><lpage>47</lpage><history><date date-type="received" iso-8601-date="2020-02-10"><day>10</day><month>02</month><year>2020</year></date></history><permissions><copyright-statement xml:lang="en">Copyright ©; 2016, Hrisanov N.N.</copyright-statement><copyright-statement xml:lang="ru">Copyright ©; 2016, Хрисанов Н.Н.</copyright-statement><copyright-year>2016</copyright-year><copyright-holder xml:lang="en">Hrisanov N.N.</copyright-holder><copyright-holder xml:lang="ru">Хрисанов Н.Н.</copyright-holder><ali:free_to_read xmlns:ali="http://www.niso.org/schemas/ali/1.0/"/><license><ali:license_ref xmlns:ali="http://www.niso.org/schemas/ali/1.0/">https://creativecommons.org/licenses/by/4.0</ali:license_ref></license></permissions><self-uri xlink:href="https://journals.eco-vector.com/1991-8542/article/view/20146">https://journals.eco-vector.com/1991-8542/article/view/20146</self-uri><abstract xml:lang="en"><p>The paper deals with the realization of a neural network in OpenOffice.org package. The scheme of a neural network is given, the choice activation functions, the calculation scheme of criterion quality gradient in the course of training is justified. The software structure is discussed. The software includes the modules of experimental-data preliminary processing and normalization, interaction with the database, a neural network initialization and training, dialogue management, and a diagnostics module. The results of a neural-network application for the solution of a recognition task are given. The results enable the justification of the choice of activation functions, sample size for the neural network training, and the high level of recognition.</p></abstract><trans-abstract xml:lang="ru"><p>Рассматривается реализация нейронной сети в офисном пакете OpenOffice.org. Приведена схема нейронной сети, обоснован выбор функций активации, схемы вычисления градиента критерия качества в процессе обучения. Рассмотрена структура программного обеспечения, включающая модули предварительной обработки и нормализации экспериментальных данных, взаимодействия с базой данных, инициализации и обучения нейронной сети, управления диалогами, модуль диагностики. Приведены результаты применения нейронной сети для решения одной задачи распознавания, позволившие обосновать выбор функций активации, объем выборки для обучения нейронной сети и обеспечить высокий уровень распознавания.</p></trans-abstract><kwd-group xml:lang="en"><kwd>OpenOffice</kwd><kwd>neural network</kwd><kwd>activation function</kwd><kwd>quality criterion of training</kwd><kwd>spreadsheet</kwd><kwd>OpenOffice</kwd></kwd-group><kwd-group xml:lang="ru"><kwd>нейронная сеть</kwd><kwd>функция активации</kwd><kwd>критерий качества обучения</kwd><kwd>электронная таблица</kwd></kwd-group></article-meta></front><body></body><back><ref-list><ref id="B1"><label>1.</label><mixed-citation>Jeff Heaton to Neural Network for Java, 2nd ed. Publisher: Heaton Research, Inc. - 2008, 438 p.</mixed-citation></ref><ref id="B2"><label>2.</label><mixed-citation>Jeff Heaton. Programming Neural Network with Encog3 in Java, 2nd ed. Publisher: Heaton Research, Inc. - 2011, 210 p.</mixed-citation></ref><ref id="B3"><label>3.</label><mixed-citation>Haykin, Simon. Neural networks and learning machines / Simon Haykin. - 3rd ed. by Pearson Education, Inc., Upper Saddle River, New Jersey 07458. - 2009, 936 p.</mixed-citation></ref></ref-list></back></article>
