Objetivo: Propor um algoritmo, em Solver Excel®, capaz de alocar tarefas para auditores com intuito otimizar o tempo gasto na realização delas. Método: Trata-se estudo descritivo (quanto ao objetivo), quantitativo (problema) e utiliza-se da otimização linear (análise dados) simulações usabilidade do algoritmo. Resultados: Mapearam-se atividades auditoria presentes nas NBC TA’s, resultando cinco...

BACKGROUND Secretion of heterologous proteins depends both on biomass concentration and on the specific product secretion rate, which in turn is not constant at varying specific growth rates. As fed batch processes usually do not maintain a steady state throughout the feed phase, it is not trivial to model and optimize such a process by mathematical means. RESULTS We have developed a model fo...

Many companies have excel, it is economy and well perform to use in material requirement planning (MRP) on excel. For several products, it, however, is complex problem to link the relationship between the tables of products because the relationship depends on bill of material (BOM). This paper presents algorithm to create MRP on excel, and links relationship between tables. The study reveals MR...

In many companies Microsoft Excel is often used as a CEMIS for managing environmental data. In collaborative scenarios this single-user application often causes problems. In this article, the multi user framework Quexolver is presented, which supports the simultaneous processing of environmental data in Excel by multiple users. The multi-user capability is provided by introducing a role and rig...

solving a large sparse set of linear equations is of the problems widely seen in every numerical investigation in the entire range of engineering disciplines. employing a finite element approach in solving partial derivative equations, the resulting stiffness matrices would contain many zero-valued elements. moreover, storing all these sparse matrices in a computer memory would slower the compu...

Multi-facility location problem is a type of task often solved (not only) in logistics. It consists finding the optimal required number centers for given points. One possible solutions to use principle genetic algorithm. The Solver add-in, which uses evolutionary method, available Excel office software. was used solve benchmark 4 levels difficulty (from 5 25 points 20 100 points), and one from ...

Recently, transportation engineering industry members showed concern that students lacked the skills to solve real-world problems using spreadsheet data analysis. In response circumstances shown by members, this study investigated how engage in a better way incorporating analysis during class and helping them learn course topics. Helping link theoretical knowledge can be challenge. effort, in-c...

Abstract—The Analytic Hierarchy Process is frequently used approach for solving decision making problems. There exists wide range of software programs utilizing that approach. Their main disadvantage is that they are relatively expensive and missing intermediate calculations. This work introduces a Microsoft Excel add-in called DAME – Decision Analysis Module for Excel. Comparing to other compu...

The Boston University Henry M. Goldman School of Dental Medicine (BUSDM) initiated a program in the summer of 1993 to strengthen diversity in the entering class of first-year students. The Experiential Center for Excellence in Learning (EXCEL) Program is a voluntary, one-month-long prematriculation experience that combines didactic, laboratory, study skills, and social activities to prepare par...

Combining differing solution approaches by means of solver portfolios has proven as a highly effective technique for boosting solver performance. We consider the problem of generating parallel SAT solver portfolios. Our approach is based on a recently introduced sequential SAT solver portfolio that excelled at the last SAT competition. We show how the approach can be generalized for the paralle...