The application of Microsoft Excel Solver routines to analyze data from a thermal probe placed in a number of samples is described. The successful application of the Solver routine to the thermal probe temperature time data requires the selection of an appropriate time interval. The various critical times are discussed and a method is proposed for selecting the appropriate Solver routine and th...

Estimation and Optimization of Potentiometric Sensor Response Parameters from Surfactant Titration Data Using Microsoft Excel Solver and Mathematica Milan Sak-Bosnar1 ∗, Dubravka Madunić-Čačić2, Nikola Sakač1, Mirela Samardžić1, and Želimir Kurtanjek3 1Department of Chemistry, Josip Juraj Strossmayer University of Osijek, F. Kuhaèa 20, HR-31000 Osijek, Croatia 2Saponia, Chemical, Pharmaceutical...

Practicing engineers resort to modular simulators or to algebraic tools such as GAMS or AMPL for performing complex process optimizations. These tools, however, have a signi®cant learning curve unless they have been introduced at the undergraduate level beforehand. In this work we show how the Solver feature of the Excel spreadsheet can be used for the optimization of a fairly complex system, i...

critical path method (cpm) is one of the most popular techniques used by construction practitioners for construction project scheduling since the 1950s. despite its popularity, cpm has a major shortcoming, as it is schedule based on two impractical acceptance that the project deadline is not bounded and that resources are unlimited. the analytical competency and computing capability of cpm thus...

S analysis is a widely used technique, and business students should be proficient in running scenarios through a spreadsheet model. We propose 10 desirable properties for a scenario analysis technique, and show that the Microsoft Excel Scenario Manager tool satisfies only one of them. We provide a tutorial for a better technique that can be programmed into an existing spreadsheet in a matter of...

Pose estimation is one of the vital issues in mobile robot navigation. Odometry data can be fused with absolute position measurements to provide better and more reliable pose estimation. This paper deals with the determination of better relative localization of a two wheeled differential drive robot by means of odometry by considering the influence of parameters namely weight, velocity, wheel p...

In the insurance industry, spreadsheets have emerged as an invaluable tool to for product pricing, because it is relatively straightforward to create and maintain complex pricing models using Excel®. In fact, Excel is often preferred to “hard-code” whenever there are frequent changes to the calculations and business logic which under-pin the pricing of an insurance product. However, problems ar...