AUTOMATED DATA PROCESSING. CUSTOM SOFTWARE APPLICATION FOR GEOECOLOGY (MS EXCEL BUILT-IN PROGRAMS)

Abstract. The built-in MSExcell program herein presented allows for automating repeated tasks; editing and customizing recorded macros to suit our needs; editing recorded macros, viewing and modifying them, reading code, editing and adding comments to it, finding, replacing, moving and copying code; providing useful personalized complex programs; managing the way the user interacts with the application, to exchange information between application and its users, through Dialog Boxes, (DB), created by the user himself; inserting a new type of sheet, the dialog sheet, in a workbook, and placing objects such as buttons, edit boxes, list boxes within it to create a custom dialog box that acts like the built-in DB supported by MSExcel, (MSE) ; enhancing the Application with predefined DB; placing Controls on a Worksheet or Dialog Sheet; Using the Menu Editor, Button Image Editor; creating automatic procedures and add-in applications, using EVENTS etc. The main results of our personalized built-in program are the following: a very easy access to all, very numerous necessary parameters of a complete granulometric analysis; the complex graphic representations for each individual sample or for sample groups in every chosen number from 1 to 65,000 simultaneously, in probability paper diagrams (probability plots) or in linear scales, frequencies histograms and polygons, every MSExcel standard diagram type data presentation; input and output data table and main graphical results for flow and channel profile determination; simple and complex ternary diagrams from all fields, geology and especially sedimentology; Dozens of analytic and synthetic indices for a thorough ecological description of an ecosystem (constancy, abundance, density of population, ecological significance index, dominance, rank for each species as well as Simpson’s indices of diversity and evenness for every site, similarity matrix, dendrograms etc); bathymetry and GPS data formatting, synchronization, processing etc - all those as the main purpose of all directly MSExcel built-in programs, in order to allow entire work as if everything would have been programmed by Microsoft itself, beginning from raw data input, intermediate and final processing, until the results presentation, everything in only one workbook, by a mere click on the customized buttons of a standard or personalized toolbar, but absolutely similar to the original Excel toolbars