Permasalahan yang sering dijumpai dalam optimasi pengiriman sebuah produk adalah Travelling Salesman Problem (TSP). TSP merupakan masalah pencarian rute terpendek dari sejumlah node, di satu kali perjalanan. Perusahaan Es Batu melakukan menginginkan terpendek, untuk mengurangi keterlambatan pengiriman. Dampak terhadap kualitas es batu dapat menurunkan kepuasan pelanggan. Rute tidak diatur akan ...

This study describes a method to obtain parameter confidence intervals from the fitting of non-linear functions to experimental data, using the SOLVER and Analysis ToolPaK Add-In of the Microsoft Excel spreadsheet. Previously we have shown that Excel can fit complex multiple functions to biological data, obtaining values equivalent to those returned by more specialized statistical or mathematic...

Reuse has long been a major goal of the Knowledge Engineering community. The focus of this paper is the reuse of domain knowledge acquired for an initial problem solver, with a further problem solver. For our analysis we chose a knowledge base system written in CLIPS based on the propose-andrevise (PnR) problem solver, and which had a lift/elevator knowledge base (KB). Given the nature of the p...

This paper describes advanced interval methods for finding a verified global optimum and finding all solutions of a system of nonlinear equations, as implemented in the Premium Solver Platform, an extension of the Solver bundled with Microsoft Excel. It also describes the underlying tools that allow Excel spreadsheets to be evaluated over reals and intervals, with fast computation of real gradi...

the first step in the design of plate girder is to estimate the self-weight of it. although empirical formulae for the same are available, the level of their accuracy (underestimate or overestimate) with respect to actual self-weight is not known. in this paper, optimized sections are obtained for different spans subjected to different live load carrying capacities and self-weights are estimate...

Linear programming (LP) is one of the most widely applied O.R. techniques and owes its popularity principally to George Danzig's simplex method (Danzig 1963) and the revolution in computing. It is a very powerful technique for solving allocation problems and has become a standard tool for many businesses and organisations. Although Danzig's simplex method allows solutions to be generated by han...

Here I present an Excel based program for the analysis of intracellular Ca transients recorded using fluorescent indicators. The program can perform all the necessary steps which convert recorded raw voltage changes into meaningful physiological information. The program performs two fundamental processes. (1) It can prepare the raw signal by several methods. (2) It can then be used to analyze t...