Medical Writing Software for Medical Writers Consolidated data analysis and presentation using an open-source add-in for the Microsoft Excel® spreadsheet software

Volume 23, Issue 1 - Software for Medical Writers

Consolidated data analysis and presentation using an open-source add-in for the Microsoft Excel® spreadsheet software

Abstract

A free and open-source software tool is presented that facilitates the analysis and the visualisation of data in basic life science. Daniel's XL Toolbox is an add-in for the Microsoft Excel® spreadsheet software. It enables scientists to store their data in one place and obviates the need to use separate tools for the analysis and presentation of the data. The Toolbox offers analysis of variance with post hoc multiple comparison testing and linear correlation and regression analyses. It can apply error bars to the graphs automatically, and style the graphs in a way suitable for publication. The graphs can be exported in high resolution to TIFF, PNG, as well as to EMF file types. Finally, the Toolbox offers several work flow and productivity features such as automatic time-stamped backups, transposition assistant, worksheet management, and much more. The Toolbox is available at http://xltoolbox.sourceforge.net.

Download the full article

References

  1. Endo A, Nagatani F, Hamada C, Yoshimura I. Minimization method for balancing continuous prognostic variables between treatment and control groups using Kullback-Leibler divergence. Contemp Clin Trials 2006;27(5):420–31.
  2. Glantz SA, Slinker BK. Primer of applied regression & analysis of variance. 2nd ed. New York: McGraw-Hill; 2000.

Search

Articles

In this issue of Medical Writing
Message from the President
EMWA social media team
News from the EMA
Taming Microsoft Word®
The secrets of Microsoft Word®. Part I – ‘Find and Replace’ and en-dashes
Organising the review process in Microsoft Word®
Document templates for medical writers
Getting more out of PowerPoint®
Consolidated data analysis and presentation using an open-source add-in for the Microsoft Excel® spreadsheet software
Datavision™ – What do medical writers need to know?
Software for translators
Graphing software for medical writers
A medical writer's must-have software
Zotero: A free and open-source reference manager
Origin and development of English for Medical Purposes. Part I: Research on written medical discourse
Profile: An interview with Karina Ruth Tabacinic on some fundamental concerns of medical translation
A first-timer's perspective on the 2013 EMWA conference in Barcelona
English Grammar and Style
Regulatory Writing
The Webscout
Medical Communications
In the Bookstores
Manuscript Writing
Out On Our Own

Member Login

Links

The Write Stuff Archive Contact Instructions for Authors Article Template (Word) Journal Policies

Editoral Board

Editor-in-Chief

Raquel Billiones

Co-Editors

Evguenia Alechine

Jonathan Pitt

Managing Editor

Victoria White

Deputy Managing Editor

Alicia Waltman

Associate Editors

Anuradha Alahari

Jennifer Bell

Clare Chang

Barbara Grossman

Joselita T. Salita

Amy Whereat

Section Editors

Nicole Bezuidenhout 

Digital Communication

Somsuvro Basu

EMWA News       

Aurélie Gobet / Paolo Rega

Gained in Translation

Raquel Billiones

Getting Your Foot in the Door

Wendy Kingdom / Amy Whereat

Good Writing Practice

Alison McIntosh / Stephen Gilliver

In the Bookstores

Maria Kołtowska-Häggström

Lingua Franca and Beyond

Phil Leventhal

Manuscript Writing

Lisa Chamberlain-James

Medical Communications/Writing for Patients

Namrata Upadhyay

Medical Devices

Evguenia Alechine

My First Medical Writing

Anuradha Alahari

News from the EMA

Laura Kehoe

Out on Our Own

Jennifer Clemens

Regulatory Matters

Sam Hamilton

Regulatory Public Disclosure

Claire Gudex

Teaching Medical Writing

Kimi Uegaki

The Crofter: Sustainable Communications

Karim Montasser

Veterinary Writing

Editors Emeritus

Elise Langdon-Neuner

Phil Leventhal

Lay out Designer

Chris Monk