VBA Macro Research Articles

Developing utility tools to enhance Voyager access, search and workflow automation

PurposeThis paper aims to describe three utility tools developed at Texas A&M University Libraries, which were designed for quick access and search of the Voyager OPAC and the Voyager clients.Design/methodology/approachThe Voyager Canned Search Generator provides content creators with an automatic way to generate persistent links to catalog searches. Quick‐Cat is an OPAC shortcut search tool. It allows users to highlight bibliographic data, including authors, titles, ISBN numbers, or ISSN numbers on any web site and immediately search their own library catalog, with just one click. Designed to assist in the EBSCONET serials renewal, an Excel VBA Macro provides an easy gateway from the renewal list to the Voyager Acquisitions and Cataloging clients, the EBSCONET web site, and the library's SFX system.FindingsThe three tools fulfilled their design goals. Users were satisfied with them and they improved productivity. With innovative ideas, some technical know‐how, and a good understanding of the issues librarians can turn themselves into developers of useful tools. They could come up with small, yet effective solutions by leveraging the existing system infrastructure, and combining or mixing available components. The paper discusses development issues, benefits, drawbacks and user feedback.Originality/valueThe paper provides useful information on developing utility tools for quick access and search of Voyager OPAC and the Voyager clients.

Development of a VBA Macro that Draws Figures in Profile with Power Point

Development of a VBA Macro that Draws Figures in Profile with Power Point

Implementation of the analytical hierarchy process with VBA in ArcGIS

Decisions on landuse have become progressively more difficult in the last decades. The main reasons for this development lie in the increasing population combined with an increasing demand for new land and resources and in the growing consciousness for sustainable land and resource use. The steady reduction of valuable land leads to an increase of conflicts in land use decision-making processes since more interests are being affected and therefore more stakeholders with different land use interests and different valuation criteria are being involved in the decision-making process. In the course of such a decision process all identified criteria are weighted according to their relative importance. But assigning weights to the relevant criteria quickly becomes a difficult task when a greater number of criteria are being considered, especially with regard to land use decisions where decision makers expect some kind of mapped result it is therefore useful to use procedures that not only help to derive criteria weights but also accelerate the visualisation and mapping of land use assessment results. Both aspects can easily be facilitated in a GIS. This paper focuses the development of an ArcGIS VBA macro which enables the user to derive criteria weights with the analytical hierarchy process and which allows a mapping of the land use assessment results by a weighted summation of GIS raster data sets. A dynamic link library for the calculation of the eigenvalues and eigenvectors of a square matrix is provided.

Optimization of construction time-cost trade-off analysis using genetic algorithms

In the management of a construction project, the project duration can often be compressed by accelerating some of its activities at an additional expense. This is the so-called time-cost trade-off (TCT) problem, which has been studied extensively in the project management literature. TCT decisions, however, are complex and require planners to select appropriate resources for each project task, including crew size, equipment, methods, and technology. As combinatorial optimization problems, finding optimal decisions is difficult and time consuming considering the number of possible permutations involved. In this paper, a practical model for TCT optimization is developed using the principle of genetic algorithms (GAs). With its robust optimization search, the GAs model minimizes the total project cost as an objective function and accounts for project-specific constraints on time and cost. To maximize its benefits, the model has been implemented as a VBA macro program. This automates TCT analysis and combines it with standard resource-management procedures. Details of the proposed TCT model are described and several experiments conducted to demonstrate its benefits. The developments made in this paper provide guidelines for designing and implementing practical GA applications in the civil engineering domain.Key words: computer application, time-cost trade-off, construction management, genetic algorithms, and optimization.