Unregistered
Guest
U
Hi I`m creating a gas sampling programme using a
HORNER NX251C OCS.
Using a Cscape version 7 application.
The ocs writes to a compact flash card inserted in the unit. The ocs displays a trend for 4 gas samples (historical).Comms are o.k. The data logging is the problem.
As the logging requires the following data written to a compact flash card and displayed in excel.
date/time. sample1. sample2 etc>>>>>>>
" " value value value
" " value value value
" etc value value v> etc
The ladder logic is broken down in to 4 functions.These produce real values for the sec, hours, minutes date, by using INTEGER TO REAL FUNCTIONS. The 4 REAL values are then used in a Math Express -Real Function.
Unfortunately, Excel reads and calculates dates as from the year 1900.It produces a value e.g. 1900-2005 = 38,325.NOT a date?????????
So it writes a large number for the date instead of an Actual (date figure) as you would expect. Does anybody know of an Algorythmn to produce a date. Sorry if the description is a little vague.
Many many thanks.Hi I`m creating a gas sampling programme using a
HORNER NX251C OCS.
Using a Cscape version 7 application.
The ocs writes to a compact flash card inserted in the unit. The ocs displays a trend for 4 gas samples (historical).Comms are o.k. The data logging is the problem.
As the logging requires the following data written to a compact flash card and displayed in excel.
date/time. sample1. sample2 etc>>>>>>>
" " value value value
" " value value value
" etc value value v> etc
The ladder logic is broken down in to 4 functions.These produce real values for the sec, hours, minutes date, by using INTEGER TO REAL FUNCTIONS. The 4 REAL values are then used in a Math Express -Real Function.
Unfortunately, Excel reads and calculates dates as from the year 1900.It produces a value e.g. 1900-2005 = 38,325.NOT a date?????????
So it writes a large number for the date instead of an Actual (date figure) as you would expect. Does anybody know of an Algorythmn to produce a date. Sorry if the description is a little vague.
Many many thanks.
HORNER NX251C OCS.
Using a Cscape version 7 application.
The ocs writes to a compact flash card inserted in the unit. The ocs displays a trend for 4 gas samples (historical).Comms are o.k. The data logging is the problem.
As the logging requires the following data written to a compact flash card and displayed in excel.
date/time. sample1. sample2 etc>>>>>>>
" " value value value
" " value value value
" etc value value v> etc
The ladder logic is broken down in to 4 functions.These produce real values for the sec, hours, minutes date, by using INTEGER TO REAL FUNCTIONS. The 4 REAL values are then used in a Math Express -Real Function.
Unfortunately, Excel reads and calculates dates as from the year 1900.It produces a value e.g. 1900-2005 = 38,325.NOT a date?????????
So it writes a large number for the date instead of an Actual (date figure) as you would expect. Does anybody know of an Algorythmn to produce a date. Sorry if the description is a little vague.
Many many thanks.Hi I`m creating a gas sampling programme using a
HORNER NX251C OCS.
Using a Cscape version 7 application.
The ocs writes to a compact flash card inserted in the unit. The ocs displays a trend for 4 gas samples (historical).Comms are o.k. The data logging is the problem.
As the logging requires the following data written to a compact flash card and displayed in excel.
date/time. sample1. sample2 etc>>>>>>>
" " value value value
" " value value value
" etc value value v> etc
The ladder logic is broken down in to 4 functions.These produce real values for the sec, hours, minutes date, by using INTEGER TO REAL FUNCTIONS. The 4 REAL values are then used in a Math Express -Real Function.
Unfortunately, Excel reads and calculates dates as from the year 1900.It produces a value e.g. 1900-2005 = 38,325.NOT a date?????????
So it writes a large number for the date instead of an Actual (date figure) as you would expect. Does anybody know of an Algorythmn to produce a date. Sorry if the description is a little vague.
Many many thanks.