myrtle man page

myrtle — A simple programmable spreadsheet designed for learning statistics.

Description

Myrtle Spreadsheet™ is a simple programmable spreadsheet and statistical analysis software specifically designed for learning statistics. It provides the standard spreadsheet functionality one would expect like multiple tabbed sheets, relative and absolute row and column referencing in formulas, and a large catalog of built-in functions. Functions specific to logic and computer science, mathematics, probability, and statistics are available. Students can easily create, customize, and update plots and graphical summaries of their analyses.

Myrtle offers a unique bookmarking facility which allows students to create and reuse named references to their favorite cell ranges. This can help students focus attention on the important relationships among particular rows or columns of data. Bookmarking also prevents much of the frustration students feel when building cell formulas when the data set is large or when multiple sheet tabs must be involved.

Students can develop their own spreadsheet functions to facilitate analyses. A seamlessly integrated scripting facility allows for more advanced analyses and graphics generation. Students easily build personal libraries containing their favorite functions and scripts allowing them to be reused again and again in future projects. Advanced students satisfying a course with an honors option or project component can structure their project around scripting a novel data analysis or implementing a challenging statistical method as a new cell function.

Environment

MYRTLECONFIG

This environment variable overrides the user's default ~/.myrtlerepos file. Its value should represent a path to a suitably formatted (see example below) .myrtlerepos file.

MYRTLEPREFS
This environment variable overrides the user's default ~/.myrtleprefs file. Its value should represent a path to a suitably formatted (see example below) .myrtleprefs file.
RESERVEDFUNCTIONCONFIG
This environment variable overrides the user's default ~/.myreservedfunctionrepos file. Its value should represent a path to a suitably formatted .myreservedfunctionrepos file.

Files

Each user can customize the behavior and appearance of Myrtle via the file ~/.mymyrtleprefs. In what follows, replace janedoe with the actual user name.

Example ~/.mymyrtleprefs file

[crumbach]

activecelltime=1500

lastrepository=default

domainname=com.yourdomain

iconmapfile=/home/janedoe/.myDomainIconMappings

createdon=2013-07-18

createdby=janedoe

myrtlecommenttemplates=/home/janedoe/.myrtlecommenttemplates

myrtlecommentview=nedit ${FILENAME}

myrtleoutputdirectory=/home/janedoe/Dropbox/MyrtleSandbox

legendfont=SansSerif-plain-18

legendfontcolor=0

legenddomainnamefilter=None

strictparsing=true

axesxlabelfont=Dialog-bold-36

axesylabelfont=Dialog-bold-36

axeszlabelfont=Dialog-bold-36

axesfont=SansSerif-bold-16

axestitlefont=SansSerif-bold-16

axeslinethickness=2

axeson=true

axesgridon=true

axesboxon=true

figurebackgroundcolor=-1

axesbackgroundcolor=-1

axestitlecolor=0

axescolor=0

axesxlabelcolor=-16777216

axesylabelcolor=-16777216

axeszlabelcolor=-16777216

linethickness=4

linemarkersize=12

cellfont=Monospaced-bold-14

editcellfont=Monospaced-bold-16

cellbackgroundcolor=-1

editcellbackgroundcolor=-16777216

editcellforegroundcolor=-1

cellforegroundcolor=-16776961

alternaterowcolor=-3355444

selectionbackgroundcolor=-13312

Example ~/.mymyrtleprepos file

[default]

host=

user=

password=

database=/home/janedoe/MyrtleDB

timeout=300000

enabled=yes

editor=

protocol=com.mockturtlesolutions.snifflib.spreadsheets.database.MyrtleXMLConnection

Help

Online Help.

·
Myrtle Features and Extras: <http://www.mockturtlesolutions.com>
·
Browse Myrtle's Blog: <http://myrtlespreadsheet.blogspot.com>
·
Browse Myrtle's Wiki: <http://sourceforge.net/p/myrtle/wiki/Ho…>
·
Search known solutions, submit new bug reports, new feature requests: <http://sourceforge.net/p/myrtle/tickets>

Notes

The textbook Introduction to Statistics with Myrtle by Daniel P. Dougherty (2013) uses Myrtle and provides complete coverage for a course in introductory statistics. Features of this text include: i) A pre-assessment quiz for new students, ii) comprehensive index and glossary, iii) boxed class challenges and how-to's, iv) fully worked-out annotated examples, v) engaging chapter review problems, and vi) a practice final course concept exam.

Bugs

If you find a bug, please report it at <http://sourceforge.net/p/myrtle/tickets>.

Authors

Myrtle was written in the Java language by Daniel P. Dougherty <daniel.dougherty at mtsoln.com>.

This manual page was written by Daniel P. Dougherty <daniel.dougherty at mtsoln.com>, on July 21, 2013.

Third Party Code

Additional copyright notices and license terms applicable to portions of the Software are included. All trademarks and registered trademarks mentioned herein are the property of their respective owners.

Info

July 21, 2013 Version 1.8.11 Myrtle Documentation