Need to export date data in Julian calendar instead of Gregorian calendar
23 Jul 2014
To export date data in Julian Calendar instead of Gregorian calendar,
- Collect the date data as normal.
- Export the file.
- Open the CSV file in Excel.
- Add a column next to the Date Trait column.
- Copy this formula into first cell of new column: =TEXT(C2,"")&TEXT((C2-DATEVALUE("1/1/"&TEXT(C2,"yy"))+1),"000")
In this example, the column with the date in it is C2.
- Once the C2 value has been modified for your file, copy the formula to all the cells to be converted. This gives you a Julian date in the new column.
|
Range |
Row |
flower |
Julian Flower |
|---|---|---|---|
|
1 |
1 |
6/9/2014 |
160 |
|
5 |
1 |
6/10/2014 |
161 |
|
5 |
2 |
6/11/2014 |
162 |
|
6 |
1 |
6/11/2014 |
162 |
- Now select the columns that you want to save in a new Excel sheet. You can hide the columns you don't need.
- Copy the columns to a new Excel sheet.
- Save the Excel sheet as a CSV file.
|
Range |
Row |
Julian Flower |
|---|---|---|
|
1 |
1 |
160 |
|
5 |
1 |
161 |
|
5 |
2 |
162 |
|
6 |
1 |
162 |
This new CSV file contains Julian dates for the collected date traits.
If you have questions or need further assistance, contact the HarvestMaster Field Service Engineers. For contact information, see Contact a HarvestMaster Field Service Engineer.
- Phone Number: 435-753-1881
- Email: hmtechsupport@junipersys.com
- Address: 1132 W 1700 N, Logan, UT 84321
