|
Subject: Re: [xsl] grouping From: "Dave Pawson dave.pawson@xxxxxxxxx" <xsl-list-service@xxxxxxxxxxxxxxxxxxxxxx> Date: Fri, 2 Jan 2026 14:45:37 -0000 |
<period>
<pwr>0.136000</pwr>
<cost>0.95204760000</cost>
<start>
<date>12-01</date>
<time>00:30</time>
</start>
<end>00:00</end>
</period>
etc. Input was CSV
regards
On Fri, 2 Jan 2026 at 14:43, Dave Pawson <dave.pawson@xxxxxxxxx> wrote:
> My processing error David :-)
> Redundant anyway, the data is in contiguous 30 min segments!
>
> regards
>
> On Fri, 2 Jan 2026 at 14:42, David Carlisle d.p.carlisle@xxxxxxxxx <
> xsl-list-service@xxxxxxxxxxxxxxxxxxxxxx> wrote:
>
>> I don't understand your data, why is the end time the same as start time
>> in all cases?
>>
>> On Fri, 2 Jan 2026 at 14:34, Dave Pawson dave.pawson@xxxxxxxxx <
>> xsl-list-service@xxxxxxxxxxxxxxxxxxxxxx> wrote:
>>
>>>
>>>
>>> On Fri, 2 Jan 2026 at 14:25, G. Ken Holman g.ken.holman@xxxxxxxxx <
>>> xsl-list-service@xxxxxxxxxxxxxxxxxxxxxx> wrote:
>>>
>>>> At 02/01/2026 14:15 +0000, you wrote:
>>>> >Hi Ken.
>>>> >
>>>> >On Fri, 2 Jan 2026 at 14:06, G. Ken Holman <mailto:
>>>> g.ken.holman@xxxxxxxxx>g.ken.holman@xxxxxxxxx <<mailto:
>>>> xsl-list-service@xxxxxxxxxxxxxxxxxxxxxx>
>>>> xsl-list-service@xxxxxxxxxxxxxxxxxxxxxx> wrote:
>>>> >You don't provide enough data to do any testing,
>>>> >
>>>> >All there are are more of the same?
>>>>
>>>> I understand it is all more of the same ... but I can't test a proposed
>>>> solution to the problem without hand-creating a day's worth of data across
>>>> two different days in order to test what I propose.
>>>
>>>
>>> Apols to the list.
>>> Below just over two days Ken.
>>>
>>> regards
>>>
>>>
>>> <?xml version="1.0" encoding="utf-8"?>
>>> <data>
>>> <date>
>>> <yr>2025</yr>
>>> <mn>12</mn>
>>> </date>
>>> <period>
>>> <pwr>0.136000</pwr>
>>> <cost>0.95204760000</cost>
>>> <start>
>>> <date>12-01</date>
>>> <time>00:00</time>
>>> </start>
>>> <end>00:00</end>
>>> </period>
>>> <period>
>>> <pwr>0.171000</pwr>
>>> <cost>1.19705985000</cost>
>>> <start>
>>> <date>12-01</date>
>>> <time>00:30</time>
>>> </start>
>>> <end>00:30</end>
>>> </period>
>>> <period>
>>> <pwr>0.138000</pwr>
>>> <cost>0.96604830000</cost>
>>> <start>
>>> <date>12-01</date>
>>> <time>01:00</time>
>>> </start>
>>> <end>01:00</end>
>>> </period>
>>> <period>
>>> <pwr>0.172000</pwr>
>>> <cost>1.20406020000</cost>
>>> <start>
>>> <date>12-01</date>
>>> <time>01:30</time>
>>> </start>
>>> <end>01:30</end>
>>> </period>
>>> <period>
>>> <pwr>0.122000</pwr>
>>> <cost>0.85404270000</cost>
>>> <start>
>>> <date>12-01</date>
>>> <time>02:00</time>
>>> </start>
>>> <end>02:00</end>
>>> </period>
>>> <period>
>>> <pwr>0.181000</pwr>
>>> <cost>1.26706335000</cost>
>>> <start>
>>> <date>12-01</date>
>>> <time>02:30</time>
>>> </start>
>>> <end>02:30</end>
>>> </period>
>>> <period>
>>> <pwr>0.107000</pwr>
>>> <cost>0.74903745000</cost>
>>> <start>
>>> <date>12-01</date>
>>> <time>03:00</time>
>>> </start>
>>> <end>03:00</end>
>>> </period>
>>> <period>
>>> <pwr>0.167000</pwr>
>>> <cost>1.16905845000</cost>
>>> <start>
>>> <date>12-01</date>
>>> <time>03:30</time>
>>> </start>
>>> <end>03:30</end>
>>> </period>
>>> <period>
>>> <pwr>0.113000</pwr>
>>> <cost>0.79103955000</cost>
>>> <start>
>>> <date>12-01</date>
>>> <time>04:00</time>
>>> </start>
>>> <end>04:00</end>
>>> </period>
>>> <period>
>>> <pwr>0.174000</pwr>
>>> <cost>1.21806090000</cost>
>>> <start>
>>> <date>12-01</date>
>>> <time>04:30</time>
>>> </start>
>>> <end>04:30</end>
>>> </period>
>>> <period>
>>> <pwr>0.167000</pwr>
>>> <cost>1.16905845000</cost>
>>> <start>
>>> <date>12-01</date>
>>> <time>05:00</time>
>>> </start>
>>> <end>05:00</end>
>>> </period>
>>> <period>
>>> <pwr>0.215000</pwr>
>>> <cost>6.80322457500</cost>
>>> <start>
>>> <date>12-01</date>
>>> <time>05:30</time>
>>> </start>
>>> <end>05:30</end>
>>> </period>
>>> <period>
>>> <pwr>0.752000</pwr>
>>> <cost>23.79546456000</cost>
>>> <start>
>>> <date>12-01</date>
>>> <time>06:00</time>
>>> </start>
>>> <end>06:00</end>
>>> </period>
>>> <period>
>>> <pwr>0.365000</pwr>
>>> <cost>11.54966032500</cost>
>>> <start>
>>> <date>12-01</date>
>>> <time>06:30</time>
>>> </start>
>>> <end>06:30</end>
>>> </period>
>>> <period>
>>> <pwr>0.808000</pwr>
>>> <cost>25.56746724000</cost>
>>> <start>
>>> <date>12-01</date>
>>> <time>07:00</time>
>>> </start>
>>> <end>07:00</end>
>>> </period>
>>> <period>
>>> <pwr>0.818000</pwr>
>>> <cost>25.88389629000</cost>
>>> <start>
>>> <date>12-01</date>
>>> <time>07:30</time>
>>> </start>
>>> <end>07:30</end>
>>> </period>
>>> <period>
>>> <pwr>0.415000</pwr>
>>> <cost>13.13180557500</cost>
>>> <start>
>>> <date>12-01</date>
>>> <time>08:00</time>
>>> </start>
>>> <end>08:00</end>
>>> </period>
>>> <period>
>>> <pwr>0.705000</pwr>
>>> <cost>22.30824802500</cost>
>>> <start>
>>> <date>12-01</date>
>>> <time>08:30</time>
>>> </start>
>>> <end>08:30</end>
>>> </period>
>>> <period>
>>> <pwr>0.234000</pwr>
>>> <cost>7.40443977000</cost>
>>> <start>
>>> <date>12-01</date>
>>> <time>09:00</time>
>>> </start>
>>> <end>09:00</end>
>>> </period>
>>> <period>
>>> <pwr>0.293000</pwr>
>>> <cost>9.27137116500</cost>
>>> <start>
>>> <date>12-01</date>
>>> <time>09:30</time>
>>> </start>
>>> <end>09:30</end>
>>> </period>
>>> <period>
>>> <pwr>0.197000</pwr>
>>> <cost>6.23365228500</cost>
>>> <start>
>>> <date>12-01</date>
>>> <time>10:00</time>
>>> </start>
>>> <end>10:00</end>
>>> </period>
>>> <period>
>>> <pwr>0.217000</pwr>
>>> <cost>6.86651038500</cost>
>>> <start>
>>> <date>12-01</date>
>>> <time>10:30</time>
>>> </start>
>>> <end>10:30</end>
>>> </period>
>>> <period>
>>> <pwr>0.871000</pwr>
>>> <cost>27.56097025500</cost>
>>> <start>
>>> <date>12-01</date>
>>> <time>11:00</time>
>>> </start>
>>> <end>11:00</end>
>>> </period>
>>> <period>
>>> <pwr>0.287000</pwr>
>>> <cost>9.08151373500</cost>
>>> <start>
>>> <date>12-01</date>
>>> <time>11:30</time>
>>> </start>
>>> <end>11:30</end>
>>> </period>
>>> <period>
>>> <pwr>0.173000</pwr>
>>> <cost>5.47422256500</cost>
>>> <start>
>>> <date>12-01</date>
>>> <time>12:00</time>
>>> </start>
>>> <end>12:00</end>
>>> </period>
>>> <period>
>>> <pwr>0.216000</pwr>
>>> <cost>6.83486748000</cost>
>>> <start>
>>> <date>12-01</date>
>>> <time>12:30</time>
>>> </start>
>>> <end>12:30</end>
>>> </period>
>>> <period>
>>> <pwr>0.196000</pwr>
>>> <cost>6.20200938000</cost>
>>> <start>
>>> <date>12-01</date>
>>> <time>13:00</time>
>>> </start>
>>> <end>13:00</end>
>>> </period>
>>> <period>
>>> <pwr>0.497000</pwr>
>>> <cost>15.72652378500</cost>
>>> <start>
>>> <date>12-01</date>
>>> <time>13:30</time>
>>> </start>
>>> <end>13:30</end>
>>> </period>
>>> <period>
>>> <pwr>0.208000</pwr>
>>> <cost>6.58172424000</cost>
>>> <start>
>>> <date>12-01</date>
>>> <time>14:00</time>
>>> </start>
>>> <end>14:00</end>
>>> </period>
>>> <period>
>>> <pwr>0.258000</pwr>
>>> <cost>8.16386949000</cost>
>>> <start>
>>> <date>12-01</date>
>>> <time>14:30</time>
>>> </start>
>>> <end>14:30</end>
>>> </period>
>>> <period>
>>> <pwr>0.282000</pwr>
>>> <cost>8.92329921000</cost>
>>> <start>
>>> <date>12-01</date>
>>> <time>15:00</time>
>>> </start>
>>> <end>15:00</end>
>>> </period>
>>> <period>
>>> <pwr>0.184000</pwr>
>>> <cost>5.82229452000</cost>
>>> <start>
>>> <date>12-01</date>
>>> <time>15:30</time>
>>> </start>
>>> <end>15:30</end>
>>> </period>
>>> <period>
>>> <pwr>1.015000</pwr>
>>> <cost>32.11754857500</cost>
>>> <start>
>>> <date>12-01</date>
>>> <time>16:00</time>
>>> </start>
>>> <end>16:00</end>
>>> </period>
>>> <period>
>>> <pwr>1.256000</pwr>
>>> <cost>39.74348868000</cost>
>>> <start>
>>> <date>12-01</date>
>>> <time>16:30</time>
>>> </start>
>>> <end>16:30</end>
>>> </period>
>>> <period>
>>> <pwr>0.445000</pwr>
>>> <cost>14.08109272500</cost>
>>> <start>
>>> <date>12-01</date>
>>> <time>17:00</time>
>>> </start>
>>> <end>17:00</end>
>>> </period>
>>> <period>
>>> <pwr>0.398000</pwr>
>>> <cost>12.59387619000</cost>
>>> <start>
>>> <date>12-01</date>
>>> <time>17:30</time>
>>> </start>
>>> <end>17:30</end>
>>> </period>
>>> <period>
>>> <pwr>0.185000</pwr>
>>> <cost>5.85393742500</cost>
>>> <start>
>>> <date>12-01</date>
>>> <time>18:00</time>
>>> </start>
>>> <end>18:00</end>
>>> </period>
>>> <period>
>>> <pwr>0.128000</pwr>
>>> <cost>4.05029184000</cost>
>>> <start>
>>> <date>12-01</date>
>>> <time>18:30</time>
>>> </start>
>>> <end>18:30</end>
>>> </period>
>>> <period>
>>> <pwr>0.120000</pwr>
>>> <cost>3.79714860000</cost>
>>> <start>
>>> <date>12-01</date>
>>> <time>19:00</time>
>>> </start>
>>> <end>19:00</end>
>>> </period>
>>> <period>
>>> <pwr>0.120000</pwr>
>>> <cost>3.79714860000</cost>
>>> <start>
>>> <date>12-01</date>
>>> <time>19:30</time>
>>> </start>
>>> <end>19:30</end>
>>> </period>
>>> <period>
>>> <pwr>0.126000</pwr>
>>> <cost>3.98700603000</cost>
>>> <start>
>>> <date>12-01</date>
>>> <time>20:00</time>
>>> </start>
>>> <end>20:00</end>
>>> </period>
>>> <period>
>>> <pwr>0.224000</pwr>
>>> <cost>7.08801072000</cost>
>>> <start>
>>> <date>12-01</date>
>>> <time>20:30</time>
>>> </start>
>>> <end>20:30</end>
>>> </period>
>>> <period>
>>> <pwr>0.116000</pwr>
>>> <cost>3.67057698000</cost>
>>> <start>
>>> <date>12-01</date>
>>> <time>21:00</time>
>>> </start>
>>> <end>21:00</end>
>>> </period>
>>> <period>
>>> <pwr>0.311000</pwr>
>>> <cost>9.84094345500</cost>
>>> <start>
>>> <date>12-01</date>
>>> <time>21:30</time>
>>> </start>
>>> <end>21:30</end>
>>> </period>
>>> <period>
>>> <pwr>0.186000</pwr>
>>> <cost>5.88558033000</cost>
>>> <start>
>>> <date>12-01</date>
>>> <time>22:00</time>
>>> </start>
>>> <end>22:00</end>
>>> </period>
>>> <period>
>>> <pwr>0.090000</pwr>
>>> <cost>2.84786145000</cost>
>>> <start>
>>> <date>12-01</date>
>>> <time>22:30</time>
>>> </start>
>>> <end>22:30</end>
>>> </period>
>>> <period>
>>> <pwr>0.096000</pwr>
>>> <cost>3.03771888000</cost>
>>> <start>
>>> <date>12-01</date>
>>> <time>23:00</time>
>>> </start>
>>> <end>23:00</end>
>>> </period>
>>> <period>
>>> <pwr>0.098000</pwr>
>>> <cost>0.68603430000</cost>
>>> <start>
>>> <date>12-01</date>
>>> <time>23:30</time>
>>> </start>
>>> <end>23:30</end>
>>> </period>
>>> <period>
>>> <pwr>0.090000</pwr>
>>> <cost>0.63003150000</cost>
>>> <start>
>>> <date>12-02</date>
>>> <time>00:00</time>
>>> </start>
>>> <end>00:00</end>
>>> </period>
>>>
>>> --
>>> Dave Pawson
>>> XSLT XSL-FO FAQ.
>>> Docbook FAQ.
>>> XSL-List info and archive <http://www.mulberrytech.com/xsl/xsl-list>
>>> EasyUnsubscribe <http://lists.mulberrytech.com/unsub/xsl-list/2739265> (by
>>> email)
>>>
>> XSL-List info and archive <http://www.mulberrytech.com/xsl/xsl-list>
>> EasyUnsubscribe <http://lists.mulberrytech.com/unsub/xsl-list/2607481> (by
>> email <>)
>>
>
>
> --
> Dave Pawson
> XSLT XSL-FO FAQ.
> Docbook FAQ.
>
--
Dave Pawson
XSLT XSL-FO FAQ.
Docbook FAQ.
| Current Thread |
|---|
|
| <- Previous | Index | Next -> |
|---|---|---|
| Re: [xsl] grouping, Dave Pawson dave.paw | Thread | Re: [xsl] grouping, Dave Pawson dave.paw |
| Re: [xsl] grouping, Dave Pawson dave.paw | Date | Re: [xsl] grouping, Dave Pawson dave.paw |
| Month |