Under the supervision of Pofessor Robert Hammond, I handled the programming and record-keeping needs of a project at the Arizona Public Service Solar Test and Research Center (STAR). In the course of the first year that I worked there, I became aware that STAR's Data Management System (DMS) was in need of an overhaul due to an increasingly volatile date set that was quickly growing in size. STAR management was looking for a software system that would retrieve and store data automatically, that would contain a friendly user-interface, that minimized space usage on a crowded hard drive, that provided quick access to charts, and that generated statistical analysis of solar plant operation. STAR's current DMS consists of four top-level procedures. The latest version of STAR's DMS began operation two and a half years ago. The goal of the following chapters is to document and critique the software development process that I used to bring the Visual Basic for Excel version of the current software components into existence. In addition, the conclusion will include a look into the future of STAR's DMS as management introduces an Access database version for the implementation of the DMS.
- Medium-scale Automation System Design and Implementation