Business analysts commonly use Microsoft Excel with the SAS® System to answer difficult business questions. While you can use these applications independently of each other to obtain the information you need, you can also combine the power of those applications, using the SAS Output Delivery System (ODS) tagsets, to completely automate the process. This combination delivers a more efficient pro...

BACKGROUND Microsoft Excel automatically converts certain gene symbols, database accessions, and other alphanumeric text into dates, scientific notation, and other numerical representations. These conversions lead to subsequent, irreversible, corruption of the imported text. A recent survey of popular genomic literature estimates that one-fifth of all papers with supplementary gene lists suffer...

As computer CPU gets fast, script computing is increasingly popular. Script computing allows a computer program to be executed interpretively without tedious compilation and linking. It can be used for rapid prototyping, embedded scripting, mobile computing, teaching, and learning. Ch is an embeddedable C/C++ interpreter. It execute C/C++ programs as scripts interpretively without compilation. ...

Abstract This chapter offers examples illustrating how the ‘Solver’ feature of Excel can be used to solve simultaneous equations and unconstrained constrained optimization models. other features any or simulation models introduced in this book.

Many companies have excel, it is economy and well perform to use in material requirement planning (MRP) on excel. For several products, it, however, is complex problem to link the relationship between the tables of products because the relationship depends on bill of material (BOM). This paper presents algorithm to create MRP on excel, and links relationship between tables. The study reveals MR...

In many companies Microsoft Excel is often used as a CEMIS for managing environmental data. In collaborative scenarios this single-user application often causes problems. In this article, the multi user framework Quexolver is presented, which supports the simultaneous processing of environmental data in Excel by multiple users. The multi-user capability is provided by introducing a role and rig...