From MeasureJ2X
Jump to: navigation, search
(Created page with "The MeasureJ2X program reads and writes data in the format that is known as the 'decadal' or 'Tucson' format as documented in [http://www.voortech.com/projectj2x/docs/userGuid...")
 
mNo edit summary
 
(8 intermediate revisions by the same user not shown)
Line 1: Line 1:
The MeasureJ2X program reads and writes data in the format that is known as the 'decadal' or 'Tucson' format as documented in [http://www.voortech.com/projectj2x/docs/userGuide.htm#Appendix%201. Appendix A. of the User Guide].
==Data Formats==


This is a format read by many analysis programs that are frequently used to analyze the measured data.
===Default formats===


===Excel format===
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.


One of the most common things that users want to do with the data is to view and analyze it using Excel.  
The default format is known as the 'decadal' or 'Tucson' format as documented in [http://www.voortech.com/projectj2x/docs/userGuide.htm#Appendix%201. 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.


To convert a file created by MeasureJ2X in the 'decadal' or 'Tucson' format to Excel, the 'YUX' program from the Dendrochronology Program Library (DPL) can be used.  The DPL is available for download from the [http://www.ltrr.arizona.edu/software.html Software] page of the University of Arizona's Tree Ring Lab's website).
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  [http://www.voortech.com/projectj2x/docs/V50/userGuide.htm#Appendix%202. 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 [http://www.ltrr.arizona.edu/software.html Software] page.


A 'decadal' file written by MeasureJ2X that looks like this:
A 'decadal' file written by MeasureJ2X that looks like this:
Line 33: Line 39:
2010 0.33 0.11 0.22
2010 0.33 0.11 0.22
</pre>
</pre>
__HIDDENCAT__
[[Category: Index]]
----
=== User Contributed Comments ===
<comments />

Latest revision as of 10:50, 10 April 2020

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

User Contributed Comments

Loading comments...