A Microsoft Excel workbook has been developed to simplify the quantitative analysis of experimentally measured titration curves for diprotic and triprotic amino acids such as glycine, arginine, histidine, glutamate. Students perform titration, enter data into worksheet, manually adjust resulting pKa values achieve closest agreement between experimental calculated curves. At same time, students ...

The main goal of every agent is to make a good decision. The Analytic Hierarchy Process is frequently used approach for solving decision making problems. There exists wide range of software programs utilizing that approach. Main disadvantage of those software products is that they are commercial and relatively expensive and thus it prevents them to be used by small companies, students or resear...

An Excel link to Lisp functionality can provide a window by which a user familiar with a spreadsheet can access a rich symbolic computing environment. Given the attempt by Microsoft to integrate all its applications via OLE, the same kind of technique can add powerful computation capabilities to other commonly used applications such as word processing and database programs.

A Cross sectional data based study was performed on the demographics of patients labelled as rifampicin resistant using Genexpert® from the period of January 2014 to June 2015 at the Provincial TB reference Laboratory, Dow University of Health Sciences. The records of the patients diagnosed as rifampicin resistant by Genexpert® were tabulated using Microsoft Excel® with anonymization and analyz...

Commercially available scheduling tools such as Primavera and Microsoft Project fail to provide information pertaining to the spatial aspects of construction project. A methodology using geographical information systems (GIS) is developed to represent spatial aspects of the construction progress graphically by synchronizing it with construction schedule. The spatial aspects are depicted by 3D m...

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

in this project, first we introduced a general rule for the design of drying processes and then, we have applied microsoft excel for this purpose. belt dryer is one of the most common dryers in the food industry. in this study, our aim was to process carrot by this dryer. we optimized the target function (total annual cost or tac) and investigated the influence of design variables on this targe...

Spreadsheets are used to develop application software that is distributed to users. Unfortunately, the users often have the ability to change the programming statements (“source code”) of the spreadsheet application. This causes a host of problems. By critically examining the suitability of spreadsheet computer programming languages for application development, six “application development feat...

The objective of this present study was to develop a simple, easily understood methodology for solving biologically based models using a Microsoft Excel spreadsheet. The method involves the use of in-cell formulas in which Rows and Columns of new data are generated from data typed into the spreadsheet, but does not require any programming skills or use of the macro language. The approach involv...