Seismic hazard analyses, either in a deterministic (DSHA) or probabilistic (PSHA) framework, are both commonly adopted for evaluating earthquake risk. Although different in methodology, both approaches involving tedious calculation are certainly a computer-aided analysis. For Taiwan, a few PSHA studies have been conducted, but not a single comprehensive DSHA study is yet available for this regi...

This work shows how Excel can be leveraged to tackle configuration problems. We demonstrate this by presenting the full development cycle of a PC-configurator prototype. We articulate our demonstration by exemplifying several important points. First, that Excel can be used to import raw products and services data. Second, that these data can be used by a Constraints configuration modelling to c...

This paper shows the capability of current spreadsheets to define, analyse and optimise models of systems and processes. Specifically, the Microsoft spreadsheet, Excel®, is used with its built-in solver, to analyse and to optimise systems and processes of medium complexity whose mathematical models are expressed by means of non-linear systems of equations. Two hydraulic and thermal engineering-...

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...

The Excel format is derived from the Carcinogenic Potency Database (CPDB) of Gold et al. that has been published in several earlier papers. This Excel format includes the same information as the plot version, and therefore the methods and guide to the plot provide details on what is summarized here. The CPDB is a single standardized resource of the results of 45 years of chronic, long-term carc...

Monte Carlo (MC) simulation includes a wide range of stochastic techniques used to quantitatively evaluate the behavior of complex systems or processes. Microsoft Excel spreadsheets with Visual Basic for Applications (VBA) software is, arguably, the most commonly employed general purpose tool for MC simulation. Despite the popularity of the Excel in many industries and educational institutions,...

Microsoft SQL Server PowerPivot for Excel, or PowerPivot for short, is an in-memory business intelligence (BI) engine that enables Excel users to interactively create pivot tables over large data sets imported from sources such as relational databases, text files and web data feeds. Unlike traditional pivot tables in Excel that are defined on a single table, PowerPivot allows analysis over mult...