Perl: the Markov chain saw | |
PerlMonks |
Strategy for simple data managementby bojinlund (Monsignor) |
on Jan 10, 2014 at 15:13 UTC ( [id://1070128]=perlquestion: print w/replies, xml ) | Need Help?? |
bojinlund has asked for the wisdom of the Perl Monks concerning the following question: BackgroundI am working in a small research project with limited resource, where a lot of data (measured and calculated values) need to be handled. Data comes from scientific experiments and are usually first stored in Excel spreadsheets. One spreadsheet contains data from a few experiments. For each experiment there is typically some basic information (50 data items) and a number of time series of measured values (10 series, 100 points in time and 30 measured values for each time). There exists about 100 old spreadsheets and some hundred new will be created. The old spreadsheets are similar but not standardised. Representation of a quantityA quantity is a property that is measured. Example: mass, length, time. A unit is a standard quantity against which a quantity is measured. Example: gram, metre, second; which are units of the above quantities. This can also be described by: A is the symbol for the quantity, {A} symbolizes the numerical value of A, and [A] represents the corresponding unit. (e.g., A = 300 * m = 0.3 * km). {A} is often called the measured value. Example of thing need for a quantity are:
Representation of unitThe Unit must be represented in a consistent way. For Units from The International System of Units (SI) can the exponents of the base units be used. SI has 6 base units (meter [m], kilogram [kg], second [s], … ). The derived units can be expressed using exponents of the base units (area [m2], speed [ms-1]). Goals and restrictionsPrimary goals are:
MS Window systems are used. Design ideas
Questions
Back to
Seekers of Perl Wisdom
|
|