Data Formats
Default formats
The MeasureJ2X program can read and write data in two formats that are commonly useful: the 'decadal' or 'Tucson' format and the 'csv' or 'spreadsheet' format.
The default format is known as the 'decadal' or 'Tucson' format as documented in Appendix A. of the User Guide. This is a format that is read by many analysis programs that are used after measuring to analyze the measured data.
MeasureJ2X V5.0 and later can also read and write data in a format appropriate for direct import into spreadsheet programs such as Excel. This format is called the 'csv' format (comma separated values) and is commonly used to view and plot the date in the spreadsheet program. The 'csv' format as implemented by MeasureJ2X V5.0 is described in Appendix B. of the User Guide.
Excel ('csv) format for MeasureJ2X V4.2 and earlier
MeasureJ2X V4.2 and earlier can only read and write files in the 'decadal' or 'Tucson' format. In this case, the the 'YUX' program from the Dendrochronology Program Library (DPL) can be used to convert a file created by MeasureJ2X in the 'decadal' or 'Tucson' format to Excel. The DPL is available for download from the University of Arizona's Tree Ring Lab's website Software page.
A 'decadal' file written by MeasureJ2X that looks like this:
test 2003 5100 4700 4300 2090 1650 1210 770 test 2010 330 -9999 test2 2003 2500 2300 2100 990 770 550 330 test2 2010 110 -9999 test3 2003 2600 2400 2200 1100 880 660 440 test3 2010 220 -9999
will look like this after processing with the YUX program:
Year test test2 test3 2003 5.1 2.5 2.6 2004 4.7 2.3 2.4 2005 4.3 2.1 2.2 2006 2.09 0.99 1.1 2007 1.65 0.77 0.88 2008 1.21 0.55 0.66 2009 0.77 0.33 0.44 2010 0.33 0.11 0.22
