Compilation of medical data in the MS Excel program using the procedure of multifactorial «intermediate outcomes»

Abstract

Aim. To optimize the compilation of statistical data on oncology patients according to survival and mortality. Methods. Compilation of statistical data by using the multifactorial «intermediate outcomes». Results. A program code has been used from 1990 to the present time to compile statistical data on survival and mortality of patients with gastric cancer operated on at the Kazan City Oncology Dispensary. This code makes it possible to evaluate the sensitivity of selected statistical indicators to the factors specified by the researcher, which makes it possible to regard it as a universal method for analysis of the databases in cases where the number of combinations of factors is large. The method has a high processing speed and reduces the total amount of operator commands. The universality of the program intends the use of its functions to compile the results of iterative calculations. The procedure of multifactor intermediate outcomes was implemented on the basis of MS Excel by means of Visual Basic for Applications. The proposed program of three-factor «intermediate outcomes» serves as a convenient and fast tool for finding relevant factors. Reliability of the analysis of the effectiveness of the treatment strategy for oncology patients increases significantly during application of the proposed program. Conclusion. Testing of the algorithm for analysis of the database of results in medicine and summarizing the results of iterative calculations (for example, a recursive method and the moving window method) and the equations with different combinations of time series in econometrics may indicate the viability of the algorithm as an extremely powerful tool of analysis and generalization of databases.

Keywords

subtotal / Excel / intermediate outcomes / multifactorial / subtotal / Excel / gastric cancer / survival / prognosis / analysis of statistical data

References

[1] Ахметзянов Ф.Ш., Китаев М.Р., Ядыков О.А., Ахметзянова Ф.Ф. Лимфогенное метастазирование рака дистального отдела желудка // Рос. онкол. ж. - 2011. - №1. - С. 30-33.

[2] Григорьев Р.А. О двух методах сжатия численного хаоса // Извест. вузов. Проблемы энергетики. - 2005. - №9-10. - С. 106-110.

[3] Михайлов А.А., Полевой Д.В. Проблемы анализа таблично структурированной информации // Труды института системного анализа РАН. - 2007. - №29. - С. 88-96.

[4] Aitken P.G. Excel pivot tables and charts - Indianapolis, Indiana. - Wiley Publishing, Inc., 2005. - 276 p.

[5] Dalgleish D. Excel pivot tables recipe book: a problem-solution approach. - Berkeley, California: APRESS, 2006. - 307 p.

RIGHTS & PERMISSIONS

Grigor’ev R.A., Akhmetzyanov F.S.