The article discusses the construction of a visual solution of boundary value problems for a linear differential equation of the second order by the tridiagonal sweep method in VBA in Excel. Creating macros in VBA allows you to visualize solutions to such boundary value problems.

A new approach related to the extraction of terms of relative geological age from the metadata of scientific geological publications is described. Based on the developed and adapted approaches and technological solutions, a set of macros is implemented that implements the functions of searching, extracting and adding new metadata to scientific publications.