Hi -
I need somebody to help me create a XSLT script to process an XML file, and produce a summary output XML file.
The input xml file is essentially several time series of entries in a linear format. For example:
<Series name="Series1" frequency = "Monthly">
<Observations>
<Observation Time =t1 Value = y1>
<Observation Time =t2 Value = y2>
<Observation Time =t3 Value = y3>
</Observations>
</Series>
<Series name="Series2" frequency = "Monthly">>
<Observations>
<Observation Time =t1 Value = z1>
<Observation Time =t2 Value = z2>
<Observation Time =t3 Value = z3>
</Observations>
</Series>
The output is essentially the same time series converted into a matrix format with some additional summary states. (an example is in the deliverable section)
A matrix xml element would need to be created for each frequency appearing in the input xml file: Daily, Monthly, Quarterly.
(see deliverables for additional aspects)
## Deliverables
There are a few additional aspects:
1 - The output matrix must be sorted in time series order. ie for quarterly data, the Q1 row is first, followed by Q2, followed by Q3.
2 - The input file will contain a mix of Monthly, Daily, and Quarterly series.
3 - The script needs to handle the fact that some data points will be missing. ie: not all series will contain the 06/2004 data point.
4 - There can no assumptions made about the order of the input observation points.
5 - The XSLT must be commented sufficently so that a novice has some hope of understanding what is going on, and therefore make minor modifications.
Additional information:
1 - The Time field has 3 different formats. For daily it is mm/dd/yyyy. For Monthly it is mm/yyyy/ For Quarterly it is QX/yyyy, where X is from 1 to 4.
This XSLT script will be used by a .NET application to preprocess some input XML files. Therefore it must work with a .NET application.
I have uploaded a sample input file - please include your output file generated from this sample file in the deliverable.
---------------
Matrix output example:
<Matrix frequency="Monthly">
<SummaryStats>
<Summary Series=Series NumObservations=3 FirstTime=t1 LastTime=t3>
<Summary Series=Series NumObservations=3 FirstTime=t1 LastTime=t3>
<Summary Series=Series NumObservations=3 FirstTime=t1 LastTime=t3>
</SummaryStats>
<Observations>
<Observation Time = t1>
<Series name = Series1 Value = y1 >
<Series name = Series2 Value = z1>
</Observation>
<Observation Time = t2>
<Series name = Series1 Value = y2 >
<Series name = Series2 Value = z2>
</Observation>
<Observation Time = t3>
<Series name = Series1 Value = y3 >
<Series name = Series2 Value = z3>
</Observation>
</Observations>
</Matrix>
---------------
1) Complete and fully-functional working program(s) in script form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
Windows XP, .NET v1.1 2003