The master’s thesis deals with the use of fuzzy logic for evaluating the quality of suppliers of IT goods and other material for a selected company. The fuzzy model should facilitate decisions when selecting individual suppliers who should deliver goods for the implementation of IT projects. The model created in Microsoft Excel and MathWorks MATLAB should be helpful to the company's management and sales representatives.

Diplomová práce se zabývá využitím moderních metod analýz a modelování pro hodnocení dodavatelů a výběr optimální nabídky. V této práci je využito teorie fuzzy logiky. Dále je vytvořený model porovnán se současným modelem hodnocení zákazníků.

The diploma thesis employs modern analysing and simulating methods. It enables the application of fuzzy logic in supplier selection and evaluation of its potential risks to construction companies. This work is aimed at defining the problem and determining the overall and particular goals, namely theoretical description of the principle of used artificial intelligence theory, problem description and analysis, current situation as-sessment, proposed solution implementation and evaluation of proposed solution con-tribution.

Clean and safe water is important for the well being of all organisms on earth. Therefore, it is important to reduce harmful emissions from industrial processes that use water in different ways. In vehicle washing processes, water is used in high-pressure processes, as a medium for detergents, and for rinsing of vehicles. The wastewater produced by these functions passes through a water reclamation system. A water reclamation system has two main functions, to produce reusable water to be used in future washing cycles, and to separate contaminants and purify the wastewater so it can be released back into the commercial grid. The reclamation system achieves this by using a combination of different water handling processes, these include: sludge tanks, an oil-water separator, a water reclamation unit, buffer tanks, and a water purification unit. The two components that stand for the more advanced cleaning processes are the water reclamation unit and the water purification unit. In this thesis, in collaboration with the company Westmatic, the water reclamation unit consists of cyclone separators that use centrifugal forces to separate heavy particles and ozone treatment to break up organic substances and combat bad odors. The Purification unit of choice is an electrocoagulation unit that, by a direct current, creates flocculants of impurities that rises to the surface and can be mechanically removed in a water volume inside the unit. This purification process is completely chemical-free thus making the process more environmentally friendly than other purification processes used in other circumstances. This master thesis aimed to develop a dynamic design tool for a modular solution of the different parts in the water reclamation system. This design tool uses specific user input to produce construction information for each instance. As an additional sub-aim, this design tool was linked with a computer-aided design program to produce parametric 3D models with underlying blueprints. This to produce a light solution, that has a short manufacturing time and that are highly customer adjusted. The first course of action was to mathematically define the complete water reclamation system and its components. These sections were described in a flowchart that shows how the different parts interact and operate. From the wash station, wastewater runs trough a course- and fine-sludge tank. From the fine sludge tank, the wastewater is directed in two different directions. Firstly, the water is pumped to the water reclamation unit and to one or multiple buffer tanks to finally be used in the wash station as reclaimed water. Secondly, the water travels to an oil separator, pump chamber, and water purification unit. In the purification unit, 99% of the inlet mass is directed out of the system as purified water. The remaining 1% is directed to a depot that acts like the end stage of the whole system. After all equations were defined and the design was related to the user-defined input flow the design tool was structured. The program of choice to house the design tool is Microsoft Excel. In this Excel document, a user interface with navigation was constructed and the intended user is directed through a series of input pages where input data is defined. This data is used in a normally hidden page where constructional dimensions are calculated. The constructional dimensions are displayed to the user on the second last page. At this stage the Excel document can be connected to a CAD program and 3D models with blueprints can be opened that depend on the output from the Excel file. Additionally, a pipe calculator is provided on the last page of the Excel document where pipe dimensions for different cases can be found. With this solution, glass fiber tanks are molded according to the resulting blueprints that are customer specific. In this way the solution is more adaptive and easier to handle. Additionally, the provided design tool enables an easier and more well-defined methodology when deriving the different needed volume and accompanied constructional dimensions for an arbitrary water reclamation system.

No description available.

HETA utbildningar i Härnösand har ett ångkraftverk för undervisningssyfte som kyls ner med vatten från en underjordisk bassäng på cirka 329 m³. Syftet med detta examensarbete har varit att undersöka hur bassängen med spillvärmen från kraftverket kan användas som ett säsongslager i kombination med en befintlig 7,8 kW värmepump för att värma upp maskinhallen i deras laboratoriebyggnad. Ett kalkylark skapades i Microsoft Excel för att kunna genomföra beräkningarna. Då mätdata saknades skapades ett simulerat scenario baserat på temperaturstatistik och körschema för kraftverket från år 2017. Transmissionsförluster beräknades för bassängen och maskinhallen. För bassängen användes mestadels observationsdata och kännedom hos personalen, medan maskinhallens isolering i huvudsak fick uppskattas efter byggår. Resultatet blev att värmepumpen med aktuellt körschema kunde täcka cirka 45 % av maskinhallens årliga uppvärmningsbehov. Av de 276 GJ som tillfördes genom kylning av ångkraftverket under ett år beräknades endast 2,7 % kunna utnyttjas till uppvärmning av maskinhallen, på grund av för lite isolering i bassängen. De största begränsningarna för högre täckning och större nyttjande av spillvärmen bedömdes vara placeringen i tid av kraftverkets körningar, och värmepumpens effekt. Om körningarna skulle förläggas i huvudsak till november–april och värmepumpen ersättas med en på 10 kW, skulle 74 % av värmebehovet kunna täckas och över 18 % av spillvärmen utnyttjas. Andra saker som förbättrad isolering i bassängen och större vattenvolym bedömdes också kunna förbättra bassängens kapacitet som energilager. / HETA Education in Härnösand has a steam power plant for educational purposes which is cooled with water from a 329 m³ underground basin. The purpose of this thesis has been to examine how the basin with the waste heat can be used as seasonal thermal energy storage with an existing 7.8 kW heat pump in order to heat the machine room of their lab building. A spreadsheet was created in Microsoft Excel in order to carry out the calculations. As no measurement data was available, a simulated scenario was created based on temperature statistics and the operating schedule for the power plant from the year 2017. Transmission losses were calculated for the basin and the machine room. For the basin, mostly observational data and knowledge among the staff were used, while the insulation for the machine room mainly had to be estimated based on the construction year. The result was that the heat pump, with the current operating schedule, could cover around 45% of the yearly heating demand of the machine room. Of the 276 GJ that were added through cooling of the power plant during a year, according to calculations, only 2,7% could be used for heating the machine hall, due to lacking insulation in the basin. The greatest limitations for achieving a higher heating coverage and a greater usage of the waste heat were assessed to be the placement in time of the power plant runs, and the effect of the heat pump. If the runs would be placed mainly in November–April, and the heat pump replaced with a 10 kW one, around 74% of the heating demand could be covered and 18 % of the waste heat used. Other things, such as increased insulation in the basin and larger water volume were also assessed to be able to increase the capacity of the basin as heat storage.

This thesis study evaluates access to care at an internal medicine unit with solely semi-private rooms at Baystate Medical Center (BMC). Patients are divided into two types: Type I patient consumes one bed; Type II patient occupies two beds or an entire semi-private room as a private space for clinical reasons, resulting in one empty but unavailable (blocked) bed per Type II patient. Because little data is available on blocked beds and Type II patients, unit-level hospital bed planning studies that consider blocked beds have been lacking. This thesis study bridges that gap by building a single-stream and a two-stream discrete micro-simulation model in Excel VBA to describe unit-level bed queue dynamics at hourly granularity in the next 48-hour time horizon, using historical arrival rates and census-dependent discharge rates, supplemented with qualitative results on complexity of patient-level discharge prediction. Results showed that while we increase additional semiprivate beds, there was notable difference between the traditional single-stream model and the two-stream model concerning improvement in bed queue size. Possible directions for future research include patient-level discharge prediction considering both clinical and nonclinical milestones, and strategic redesign of hospital unit(s) considering overflows and internal transfers.

The master's thesis focuses on supporting the development of applications using mathematical and statistical methods. This is used in the thesis to effective management of inventory for the store and e-shop. For this purpose, an application in VBA programming language has been developed to help the company to keep track of the inventory and find the optimum insurance stock level for ordering new goods.

To develop leaders for the 21st century, schools must be able to prepare students to meet the high academic, technical and workforce challenges. Charter schools are increasingly attempting to meet these challenges by educating students through innovative means and by creating effectual educational programs that are more conducive to the needs of the student. This document provides a computer literacy curriculum, which will facilitate student learning of computer literacy skills.