LIVIVO - The Search Portal for Life Sciences

zur deutschen Oberfläche wechseln
Advanced search

Search results

Result 1 - 10 of total 15

Search options

  1. Book ; Online: A Use Case-Engineering Resources Taxonomy for Analytical Spreadsheet Models

    Grossman, Thomas A. / Mehrotra, Vijay

    2023  

    Abstract: This paper presents a taxonomy for analytical spreadsheet models. It considers both the use case that a spreadsheet is meant to serve, and the engineering resources devoted to its development. We extend a previous three-type taxonomy, to identify nine ... ...

    Abstract This paper presents a taxonomy for analytical spreadsheet models. It considers both the use case that a spreadsheet is meant to serve, and the engineering resources devoted to its development. We extend a previous three-type taxonomy, to identify nine types of spreadsheet models, that encompass the many analytical spreadsheet models seen in the literature. We connect disparate research literature to distinguish between an "analytical solution" and an "industrial-quality analytical spreadsheet model". We explore the nature of each of the nine types, propose definitions for some, relate them to the literature, and hypothesize on how they might arise. The taxonomy aids in identifying where various spreadsheet development guidelines are most useful, provides a lens for viewing spreadsheet errors and risk, and offers a structure for understanding how spreadsheets change over time. This taxonomy opens the door to many interesting research questions, including refinements to itself.

    Comment: 13 Pages, 7 Figures, 2 Tables
    Keywords Computer Science - Software Engineering
    Subject code 303
    Publishing date 2023-08-31
    Publishing country us
    Document type Book ; Online
    Database BASE - Bielefeld Academic Search Engine (life sciences selection)

    Full text online

    More links

    Kategorien

    Inter-library loan at ZB MED

    Your chosen title can be delivered directly to ZB MED Cologne location if you are registered as a user at ZB MED Cologne.

  2. Book ; Online: Source Code Protection for Applications Written in Microsoft Excel and Google Spreadsheet

    Grossman, Thomas A.

    2008  

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

    Abstract 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 features" are identified, with source code protection being the most important. We investigate the status of these features and discuss how they might be implemented in the dominant Microsoft Excel spreadsheet and in the new Google Spreadsheet. Although Google Spreadsheet currently provides no source code control, its web-centric delivery model offers technical advantages for future provision of a rich set of features. Excel has a number of tools that can be combined to provide "pretty good protection" of source code, but weak passwords reduce its robustness. User access to Excel source code must be considered a programmer choice rather than an attribute of the spreadsheet.

    Comment: 11 pages
    Keywords Computer Science - Software Engineering ; D.1.7 ; D.2.1 ; D.2.11 ; D.3.2 ; D.3.3 ; H.4.1 ; K.6.4 ; K.8.1
    Subject code 303
    Publishing date 2008-01-30
    Publishing country us
    Document type Book ; Online
    Database BASE - Bielefeld Academic Search Engine (life sciences selection)

    Full text online

    More links

    Kategorien

    Inter-library loan at ZB MED

    Your chosen title can be delivered directly to ZB MED Cologne location if you are registered as a user at ZB MED Cologne.

  3. Book ; Online: A Primer on Spreadsheet Analytics

    Grossman, Thomas A.

    2008  

    Abstract: This paper provides guidance to an analyst who wants to extract insight from a spreadsheet model. It discusses the terminology of spreadsheet analytics, how to prepare a spreadsheet model for analysis, and a hierarchy of analytical techniques. These ... ...

    Abstract This paper provides guidance to an analyst who wants to extract insight from a spreadsheet model. It discusses the terminology of spreadsheet analytics, how to prepare a spreadsheet model for analysis, and a hierarchy of analytical techniques. These techniques include sensitivity analysis, tornado charts,and backsolving (or goal-seeking). This paper presents native-Excel approaches for automating these techniques, and discusses add-ins that are even more efficient. Spreadsheet optimization and spreadsheet Monte Carlo simulation are briefly discussed. The paper concludes by calling for empirical research, and describing desired features spreadsheet sensitivity analysis and spreadsheet optimization add-ins.

    Comment: 12 Pages, 8 Colour Figures
    Keywords Computer Science - Software Engineering ; Computer Science - Human-Computer Interaction
    Publishing date 2008-09-21
    Publishing country us
    Document type Book ; Online
    Database BASE - Bielefeld Academic Search Engine (life sciences selection)

    Full text online

    More links

    Kategorien

    Inter-library loan at ZB MED

    Your chosen title can be delivered directly to ZB MED Cologne location if you are registered as a user at ZB MED Cologne.

  4. Book ; Online: Accuracy in Spreadsheet Modelling Systems

    Grossman, Thomas A.

    2008  

    Abstract: Accuracy in spreadsheet modelling systems can be reduced due to difficulties with the inputs, the model itself, or the spreadsheet implementation of the model. When the "true" outputs from the system are unknowable, accuracy is evaluated subjectively. ... ...

    Abstract Accuracy in spreadsheet modelling systems can be reduced due to difficulties with the inputs, the model itself, or the spreadsheet implementation of the model. When the "true" outputs from the system are unknowable, accuracy is evaluated subjectively. Less than perfect accuracy can be acceptable depending on the purpose of the model, problems with inputs, or resource constraints. Users build modelling systems iteratively, and choose to allocate limited resources to the inputs, the model, the spreadsheet implementation, and to employing the system for business analysis. When making these choices, users can suffer from expectation bias and diagnosis bias. Existing research results tend to focus on errors in the spreadsheet implementation. Because industry has tolerance for system inaccuracy, errors in spreadsheet implementations may not be a serious concern. Spreadsheet productivity may be of more interest.

    Comment: 12 pages, 5 figures
    Keywords Computer Science - Human-Computer Interaction ; Computer Science - Software Engineering
    Subject code 303
    Publishing date 2008-07-20
    Publishing country us
    Document type Book ; Online
    Database BASE - Bielefeld Academic Search Engine (life sciences selection)

    Full text online

    More links

    Kategorien

    Inter-library loan at ZB MED

    Your chosen title can be delivered directly to ZB MED Cologne location if you are registered as a user at ZB MED Cologne.

  5. Book ; Online: Spreadsheet Engineering

    Grossman, Thomas A.

    A Research Framework

    2007  

    Abstract: Spreadsheet engineering adapts the lessons of software engineering to spreadsheets, providing eight principles as a framework for organizing spreadsheet programming recommendations. Spreadsheets raise issues inadequately addressed by software engineering. ...

    Abstract Spreadsheet engineering adapts the lessons of software engineering to spreadsheets, providing eight principles as a framework for organizing spreadsheet programming recommendations. Spreadsheets raise issues inadequately addressed by software engineering. Spreadsheets are a powerful modeling language, allowing strategic rapid model change, and enabling exploratory modeling. Spreadsheets users learn slowly with experience because they focus on the problem domain not programming. The heterogeneity of spreadsheet users requires a taxonomy to guide recommendations. Deployment of best practices is difficult and merits research.

    Comment: 12 Pages
    Keywords Computer Science - Software Engineering ; D.1.7 ; D.2.1 ; D.2.11 ; D.3.2 ; H.4.1 ; K.6.4 ; K.8.1
    Publishing date 2007-11-04
    Publishing country us
    Document type Book ; Online
    Database BASE - Bielefeld Academic Search Engine (life sciences selection)

    Full text online

    More links

    Kategorien

    Inter-library loan at ZB MED

    Your chosen title can be delivered directly to ZB MED Cologne location if you are registered as a user at ZB MED Cologne.

  6. Article: OR process skills transform an out-of-control call center into strategic asset

    Mehrotra, Vijay / Grossman, Thomas A

    Interfaces Vol. 39, No. 4 , p. 346-352

    2009  Volume 39, Issue 4, Page(s) 346–352

    Author's details Vijay Mehrotra; Thomas A. Grossman
    Keywords Operations Research ; Einführung ; Qualitätsmanagement
    Language English
    Publisher INFORMS
    Publishing place Linthicum, Md.
    Document type Article
    ZDB-ID 120785-4 ; 2020777-3
    ISSN 1526-551X ; 0092-2102
    ISSN (online) 1526-551X
    ISSN 0092-2102
    Database ECONomics Information System

    More links

    Kategorien

    Order via subito

    This service is chargeable due to the Delivery terms set by subito. Orders including an article and supplementary material will be classified as separate orders. In these cases, fees will be demanded for each order.

  7. Article ; Online: Genetic Characterization of Pediatric Sarcomas by Targeted RNA Sequencing.

    Avenarius, Matthew R / Miller, Cecelia R / Arnold, Michael A / Koo, Selene / Roberts, Ryan / Hobby, Martin / Grossman, Thomas / Moyer, Yvonne / Wilson, Richard K / Mardis, Elaine R / Gastier-Foster, Julie M / Pfau, Ruthann B

    The Journal of molecular diagnostics : JMD

    2020  Volume 22, Issue 10, Page(s) 1238–1245

    Abstract: Somatic variants, primarily fusion genes and single-nucleotide variants (SNVs) or insertions/deletions (indels), are prevalent among sarcomas. In many cases, accurate diagnosis of these tumors incorporates genetic findings that may also carry prognostic ... ...

    Abstract Somatic variants, primarily fusion genes and single-nucleotide variants (SNVs) or insertions/deletions (indels), are prevalent among sarcomas. In many cases, accurate diagnosis of these tumors incorporates genetic findings that may also carry prognostic or therapeutic significance. Using the anchored multiplex PCR-based FusionPlex system, a custom RNA sequencing panel was developed that simultaneously detects fusion genes, SNVs, and indels in 112 genes found to be recurrently mutated in solid tumors. Using this assay, a retrospective analysis was conducted to identify somatic variants that may have assisted with classifying a cohort of 90 previously uncharacterized primarily pediatric sarcoma specimens. In total, somatic variants were identified in 45.5% (41/90) of the samples tested, including 22 cases with fusion genes and 19 cases with SNVs or indels. In addition, two of these findings represent novel alterations: a WHSC1L1/NCOA2 fusion and a novel in-frame deletion in the NRAS gene (NM_002524: c.174_176delAGC p.Ala59del). These sequencing results, taken in context with the available clinical data, indicate a potential change in the initial diagnosis, prognosis, or management in 27 of the 90 cases. This study presents a custom RNA sequencing assay that detects fusion genes and SNVs in tandem and has the ability to identify novel fusion partners. These features highlight the advantages associated with utilizing anchored multiplex PCR technology for the rapid and highly sensitive detection of somatic variants.
    MeSH term(s) Child ; Child, Preschool ; Female ; Humans ; Infant ; Infant, Newborn ; Male ; Sarcoma/genetics ; Sequence Analysis, RNA
    Language English
    Publishing date 2020-08-01
    Publishing country United States
    Document type Journal Article ; Research Support, N.I.H., Extramural ; Research Support, Non-U.S. Gov't
    ZDB-ID 2000060-1
    ISSN 1943-7811 ; 1525-1578
    ISSN (online) 1943-7811
    ISSN 1525-1578
    DOI 10.1016/j.jmoldx.2020.07.004
    Database MEDical Literature Analysis and Retrieval System OnLINE

    More links

    Kategorien

    In stock of ZB MED Cologne/Königswinter

    Zs.A 5146: Show issues Location:
    Je nach Verfügbarkeit (siehe Angabe bei Bestand)
    bis Jg. 1994: Bestellungen von Artikeln über das Online-Bestellformular
    Jg. 1995 - 2021: Lesesall (2.OG)
    ab Jg. 2022: Lesesaal (EG)

    Order via subito

    This service is chargeable due to the Delivery terms set by subito. Orders including an article and supplementary material will be classified as separate orders. In these cases, fees will be demanded for each order.

  8. Book ; Online: Spreadsheets Grow Up

    Grossman, Thomas A. / Ozluk, Ozgur

    Three Spreadsheet Engineering Methodologies for Large Financial Planning Models

    2010  

    Abstract: Many large financial planning models are written in a spreadsheet programming language (usually Microsoft Excel) and deployed as a spreadsheet application. Three groups, FAST Alliance, Operis Group, and BPM Analytics (under the name "Spreadsheet ... ...

    Abstract Many large financial planning models are written in a spreadsheet programming language (usually Microsoft Excel) and deployed as a spreadsheet application. Three groups, FAST Alliance, Operis Group, and BPM Analytics (under the name "Spreadsheet Standards Review Board") have independently promulgated standardized processes for efficiently building such models. These spreadsheet engineering methodologies provide detailed guidance on design, construction process, and quality control. We summarize and compare these methodologies. They share many design practices, and standardized, mechanistic procedures to construct spreadsheets. We learned that a written book or standards document is by itself insufficient to understand a methodology. These methodologies represent a professionalization of spreadsheet programming, and can provide a means to debug a spreadsheet that contains errors. We find credible the assertion that these spreadsheet engineering methodologies provide enhanced productivity, accuracy and maintainability for large financial planning models

    Comment: 14 pages
    Keywords Computer Science - Software Engineering
    Subject code 690 ; 303
    Publishing date 2010-08-24
    Publishing country us
    Document type Book ; Online
    Database BASE - Bielefeld Academic Search Engine (life sciences selection)

    Full text online

    More links

    Kategorien

    Inter-library loan at ZB MED

    Your chosen title can be delivered directly to ZB MED Cologne location if you are registered as a user at ZB MED Cologne.

  9. Article: Introduction: The use of spreadsheet software in the application of management science and operations research

    LeBlanc, Larry J / Grossman, Thomas A

    Interfaces : an international journal of the Institute for Operations Research and the Management Sciences Vol. 38, No. 4 , p. 225-227

    2008  Volume 38, Issue 4, Page(s) 225–227

    Author's details Larry J. LeBlanc; Thomas A. Grossman
    Keywords Wirtschaftsmathematik ; Software ; Simulation ; Operations Research
    Language English
    Publisher INFORMS
    Publishing place Linthicum, Md.
    Document type Article
    ZDB-ID 120785-4
    Database ECONomics Information System

    More links

    Kategorien

    Order via subito

    This service is chargeable due to the Delivery terms set by subito. Orders including an article and supplementary material will be classified as separate orders. In these cases, fees will be demanded for each order.

    Inter-library loan at ZB MED

    Your chosen title can be delivered directly to ZB MED Cologne location if you are registered as a user at ZB MED Cologne.

  10. Book ; Online: Research Strategy and Scoping Survey on Spreadsheet Practices

    Grossman, Thomas A. / Ozluk, Ozgur

    2008  

    Abstract: We propose a research strategy for creating and deploying prescriptive recommendations for spreadsheet practice. Empirical data on usage can be used to create a taxonomy of spreadsheet classes. Within each class, existing practices and ideal practices ... ...

    Abstract We propose a research strategy for creating and deploying prescriptive recommendations for spreadsheet practice. Empirical data on usage can be used to create a taxonomy of spreadsheet classes. Within each class, existing practices and ideal practices can he combined into proposed best practices for deployment. As a first step we propose a scoping survey to gather non-anecdotal data on spreadsheet usage. The scoping survey will interview people who develop spreadsheets. We will investigate the determinants of spreadsheet importance, identify current industry practices, and document existing standards for creation and use of spreadsheets. The survey will provide insight into user attributes, spreadsheet importance, and current practices. Results will be valuable in themselves, and will guide future empirical research.

    Comment: 10 pages, 2 figures
    Keywords Computer Science - Human-Computer Interaction
    Publishing date 2008-07-20
    Publishing country us
    Document type Book ; Online
    Database BASE - Bielefeld Academic Search Engine (life sciences selection)

    Full text online

    More links

    Kategorien

    Inter-library loan at ZB MED

    Your chosen title can be delivered directly to ZB MED Cologne location if you are registered as a user at ZB MED Cologne.

To top