On an application of Microsoft Excel's evolutionary solver to the resource-constrained project scheduling problem RCPSP

Trautmann, Ν.; Gnägi, Mario

doi:10.1109/ieem.2015.7385727

Cited by 7 publications

(2 citation statements)

References 10 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…The software Excel Solver is illustrate for solution of nonlinear equations or nonlinear programming problems, problems with multiple criteria and complex features that person can't calculate or hard to decision by yourself. However, it gives optimization answers and fast to calculation [10][11][12][13][14][15][16][17][18][19][20][21][22].…”

Section: Introductionmentioning

confidence: 99%

A Determination of Optimal Work-piece Feed Rate on Double Spray Booths to an Oven

Yampien¹,

Prombangpong²,

Tuengsook³

2017

IJMERR

View full text Add to dashboard Cite

One of the important processes in cookware manufacturing is a coating process where coating material is sprayed to cover an interior and/or exterior surfaces of a product. Then, the wet coated product must be baked in the oven at a certain temperature profile to dry the wet coated surface. Normally, the spray and baking processes are continuously connected and loading should be balanced. Due to the fact that coating process is faster than that of baking process. Thus, double spray booths are designed to feed the oven. However, if the feeding rate is not optimized, the oven capacity tends not to be fully utilized. This is due to the fact that cookware product is designed in different sizes and shape. The mixed work-pieces are simultaneously coated and baked. Therefore, a feeding pattern and optimal feed rate must be determined to match with oven capacity in order to maximize its capacity. Thus, the objective of this paper is to reveal detailed calculation and its result to achieve this goal and it can be an example for other similar applications. 

show abstract

Section: Introductionmentioning

confidence: 99%

A Determination of Optimal Work-piece Feed Rate on Double Spray Booths to an Oven

Yampien¹,

Prombangpong²,

Tuengsook³

2017

IJMERR

View full text Add to dashboard Cite

show abstract

“…The latter one has proved to be a powerful spreadsheet tool with robust programming capabilities known as Visual Basic for Applications (VBA). Application of Solver in the field of project scheduling was suggested by researchers like Silva Filho et al (2010), Trautmann and Gnägi (2015), and others.…”

Section: Introductionmentioning

confidence: 99%

An integration of spreadsheet and project management software for cost optimal time scheduling in construction

Valenko

Klanšek

2017

Organization, Technology and Management in Construction: An International Journal

View full text Add to dashboard Cite

Successful performance and completion of construction projects highly depend on an adequate time scheduling of the project activities. On implementation of time scheduling, the execution modes of activities are most often required to be set in a manner that enables in achieving the minimum total project cost. This paper presents an approach to cost optimal time scheduling, which integrates a spreadsheet application and data transfer to project management software (PMS). At this point, the optimization problem of project time scheduling is modelled employing Microsoft Excel and solved to optimality using Solver while organization of data is dealt by macros. Thereupon, Microsoft Project software is utilized for further managing and presentation of optimized time scheduling solution. In this way, the data flow between programs is automated and possibilities of error occurrence during scheduling process are reduced to a minimum. Moreover, integration of spreadsheet and PMS for cost optimal time scheduling in construction is performed within well-known program environment that increases the possibilities of its wider use in practice. An application example is shown in this paper to demonstrate the advantages of proposed approach.

show abstract

Brand-Aware Dropped-Call Rate Optimization for Voice over LTE

Mampaka

Tokombe

Sumbwanyambe

2020

2020 International Conference on Artificial Intelligence, Big Data, Computing and Data Communication Systems (icABCD)

View full text Add to dashboard Cite

On an application of Microsoft Excel's evolutionary solver to the resource-constrained project scheduling problem RCPSP

Cited by 7 publications

References 10 publications

A Determination of Optimal Work-piece Feed Rate on Double Spray Booths to an Oven

A Determination of Optimal Work-piece Feed Rate on Double Spray Booths to an Oven

An integration of spreadsheet and project management software for cost optimal time scheduling in construction

Brand-Aware Dropped-Call Rate Optimization for Voice over LTE

Contact Info

Product

Resources

About