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

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 Feature Article Template (Word) Journal Policies

Editoral Board

Editor-in-Chief:

Co-Editor:

Managing Editor

  • Victoria White (Tampa, Florida, USA)
show all +

Associate Editors:

Section Editors:

Ad-hoc Editors:

  • Amy Whereat (SpeaktheSpeech Consulting, Asnieres sur Seine, France)

Editor Emeritus: