نتایج جستجو برای: excel solver
تعداد نتایج: 31785 فیلتر نتایج به سال:
Abstract—Linear programming has been used widely in practice with noticeable success for formulating optimum livestock diets. Diet formulated by linear programming is based on the assumption of linearity between animal yield and nutrient ingredients included in the diet. To overcome the drawback of linear approximation of objective function for diet formulation, there is a need to look for tech...
Although single exponential smoothing is a popular forecasting method for wide range of applications involving stationary time series data, consistent rules about choosing the initial value and determining constant (α) are still required, because they directly impact forecast accuracy. The purpose this study to mitigate these shortcomings. First, new setting by weighting derived, its performanc...
by Jeff Webb : Programming Excel with VBA and .NET: Solve Real-World Problems with Excel ISBN : #0596007663 | Date : 2006-05-05 Description : PDF-716bf | Why program Excel? For solving complex calculations and presenting results, Excel is amazingly complete with every imaginable feature already in place. But programming Excel isn't about adding new features as much as it's about combining exist...
This paper presents an integer programming (IP) model for production planning, which is used to maximize the profitability of battery manufacturing in a mid-size company. Battery production is a complicated multi-stage process. The formation stage, during which the batteries are filled with acid and charged with electricity, is considered to be the bottleneck of this process. The IP model maxim...
The purpose of this study was to predict the stability of octreotide in a mixed infusion containing sodium bisulfite (SBS). In aqueous solution the hydrolysis of octreotide was found to be accelerated by pH, and by increasing concentrations of SBS. Equations for the degradation rate constants (kobs) of pH and SBS were derived. The fractional rate constants were estimated by the nonlinear least-...
A new utility for multipurpose analysis, SOLVERSTAT, taking advantage of the versatility of spreadsheets is here described. By means of this tool advanced statistical tests have introduced in Microsoft Excel Solver thus allowing regression diagnostic and discrimination between different models. The utility is here applied to the determination, by UV-Vis spectroscopy, of the stability constant f...
وقتی در یک معدن روباز طراحی شده هدف از بهینه سازی عیارحد بیشینه سازی ارزش فعلی باشد، قیمت تأثیر تعیین کننده ای بر روی عیارحد بهینه کارخانه دارد. در این مقاله با فرض هدف پیش گفته، رابطه بین عیارحد بهینه و قیمت در ظرفیت های مختلف معدن کاری، فرآوری، و بازاریابی مورد بررسی قرار گرفت. برای نشان دادن چگونگی این رابطه از یک معدن فرضی استفاده گردید. برای پیدا کردن عیارحد بهینه در حالت های مختلف یک مدل ...
The Nurse scheduling problem (NSP) of this paper is to study and analyze the scheduling process in practice, and propose models and heuristics to improve both the process and the quality of the resulting schedule. Nurses should benefit from this study by having higher quality schedules while the employees in charge of scheduling should enjoy the positive benefits of an optimization tool to solv...
Chlamydia Trachomatis and Neisseria Gonorrhoeae rank as the two most commonly reported sexually transmitted diseases (STDs) in the United States. Under limited budget, publicly funded clinics are not able to screen and treat the two diseases for all patients. They have to make a decision as to which group of population shall go through the procedure for screening and treating the two diseases. ...
ABSTRACT In this paper, we report perhaps a first of its kind application of management science in the Ethiopian hotel industry. Avanti Blue Nile Hotels, a newly established five star hotel in Bahir Dar, is the company for which we developed an integer programming model that determines an optimal weekly shift schedule for the Hotel's engineering department personnel while satisfying several con...
نمودار تعداد نتایج جستجو در هر سال
با کلیک روی نمودار نتایج را به سال انتشار فیلتر کنید