Matching Items (2,111)
Filtering by

Clear all filters

134899-Thumbnail Image.png
Description
A public North American university needed a tool to automate their Vendor of Record rotation program. The goal was to give each vendor in the program fair opportunities and to be open and honest with how vendors were selected. This tool was created in Microsoft Excel with VBA to code

A public North American university needed a tool to automate their Vendor of Record rotation program. The goal was to give each vendor in the program fair opportunities and to be open and honest with how vendors were selected. This tool was created in Microsoft Excel with VBA to code macros. The three major Excel sheets are the Masters, the FM Interface, and the Executive Interface. The Masters act as a database and house data for each project. It is a plain Excel worksheet populated with tables. The FM Interface is a macro-enabled Excel workbook. It is distributed to every Facilities Manager in the program. The FM Interface communicates with the Masters in the background. The FMs use the various inputs and buttons to go through every step of procuring a project. They start by initializing a project, and are given a generated list of vendors who are qualified. This list is automatically rotated for every project. Then they fill in an RFQ and it is automatically emailed to the required vendors. When the Facilities Manager receives every quote, they input them into the program and they are saved to the database. When the project is complete, the manager must fill out a satisfaction survey to measure safety, cost, schedule, and quality of work. This is the main method of tracking vendor performance. The last sheet, the Executive Interface, is given only to the administrator of the program. It generates various reports, such as vendor performance, FM performance, and insurance status. It also has many administrative functions including insurance updating, vendor input, and delete project/vendor. The automated tool has been used without error on over 50 projects by 11 different Facilities Managers. The university's Facilities Management team is pleased with the automated process.
ContributorsSchneider, Steven Andrew (Author) / Sullivan, Kenneth (Thesis director) / Savicky, John (Committee member) / Mechanical and Aerospace Engineering Program (Contributor) / Barrett, The Honors College (Contributor)
Created2016-12
173937-Thumbnail Image.png
Description

Leonard Hayflick studied the processes by which cells age during the twentieth and twenty-first centuries in the United States. In 1961 at the Wistar Institute in the US, Hayflick researched a phenomenon later called the Hayflick Limit, or the claim that normal human cells can only divide forty to sixty

Leonard Hayflick studied the processes by which cells age during the twentieth and twenty-first centuries in the United States. In 1961 at the Wistar Institute in the US, Hayflick researched a phenomenon later called the Hayflick Limit, or the claim that normal human cells can only divide forty to sixty times before they cannot divide any further. Researchers later found that the cause of the Hayflick Limit is the shortening of telomeres, or portions of DNA at the ends of chromosomes that slowly degrade as cells replicate. Hayflick used his research on normal embryonic cells to develop a vaccine for polio, and from HayflickÕs published directions, scientists developed vaccines for rubella, rabies, adenovirus, measles, chickenpox and shingles.

Created2014-07-20
173939-Thumbnail Image.png
Description

Although best known for his work with the fruit fly, for which he earned a Nobel Prize and the title "The Father of Genetics," Thomas Hunt Morgan's contributions to biology reach far beyond genetics. His research explored questions in embryology, regeneration, evolution, and heredity, using a variety of approaches.

Created2007-09-25
173947-Thumbnail Image.jpg
Created1935