Convertir lecturas de cada 15 minutos en una por día.

caralb

New Member
Joined
Oct 26, 2017
Messages
6
Tengo esta table de lecturas cada 15 minutos. Quiero convertirla a una por día, por ejemplo a las 09:00:00.
Qué debo hacer?

[TABLE="width: 192"]
<colgroup><col width="192" style="width: 144pt;"> <col width="64" style="width: 48pt;"> <tbody>[TR]
[TD="width: 192, bgcolor: transparent"]READINGDATE[/TD]
[TD="width: 64, bgcolor: transparent"]AVG[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 00:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.1322[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 00:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.1432[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 00:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.1235[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 00:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.1046[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 01:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.1276[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 01:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.1499[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 01:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.1407[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 01:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.1447[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 02:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.1361[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 02:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.1318[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 02:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.159[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 02:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.1746[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 03:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.1606[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 03:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.145[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 03:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.1512[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 03:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.1656[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 04:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.1748[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 04:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.2027[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 04:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.1875[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 04:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.1583[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 05:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.1706[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 05:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.2023[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 05:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.2142[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 05:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.187[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 06:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.1858[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 06:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.1862[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 06:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.1941[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 06:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.2324[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 07:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.2255[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 07:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.1902[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 07:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.2071[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 07:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.2401[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 08:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.2562[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 08:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.2178[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 08:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.2023[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 08:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.2183[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 09:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.2467[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 09:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.2579[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 09:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.2495[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 09:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.2348[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 10:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.2403[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 10:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.265[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 10:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.2674[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 10:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.2603[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 11:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.2475[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 11:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.2537[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 11:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.2685[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 11:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.2903[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 12:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.2854[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 12:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.268[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 12:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.2832[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 12:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.305[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 13:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.3136[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 13:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.3031[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 13:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.2968[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 13:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.2967[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 14:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.3072[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 14:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.3211[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 14:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.3192[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 14:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.3226[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 15:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.3244[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 15:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.3294[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 15:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.3394[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 15:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.3236[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 16:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.3239[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 16:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.3349[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 16:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.3519[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 16:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.3501[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 17:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.3506[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 17:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.3552[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 17:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.3633[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 17:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.3681[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 18:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.3605[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 18:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.3634[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 18:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.3834[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 18:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.3691[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 19:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.3759[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 19:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.3632[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 19:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.3758[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 19:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.3942[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 20:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.3962[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 20:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.3897[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 20:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.399[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 20:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.4101[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 21:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.4022[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 21:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.4007[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 21:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.4123[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 21:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.4044[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 22:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.4194[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 22:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.4293[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 22:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.4376[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 22:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.4217[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 23:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.4305[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 23:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.4445[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 23:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.4419[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-01 23:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.4388[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 00:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.4511[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 00:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.4524[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 00:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.4397[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 00:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.4591[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 01:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.4715[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 01:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.4758[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 01:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.482[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 01:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.4602[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 02:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.4667[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 02:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.4802[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 02:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.5069[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 02:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.5096[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 03:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.4975[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 03:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.493[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 03:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.4945[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 03:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.5166[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 04:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.527[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 04:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.5346[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 04:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.5241[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 04:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.5094[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 05:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.5164[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 05:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.5398[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 05:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.5619[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 05:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.5466[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 06:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.5378[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 06:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.5386[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 06:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.5583[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 06:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.5711[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 07:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.5625[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 07:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.5628[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 07:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.5552[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 07:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.5646[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 08:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.5869[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 08:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.6023[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 08:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.5922[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 08:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.576[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 09:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.5908[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 09:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.6023[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 09:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.6064[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 09:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.6081[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 10:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.6134[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 10:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.6018[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 10:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.6039[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 10:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.6196[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 11:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.642[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 11:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.6395[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 11:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.625[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 11:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.6222[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 12:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.6444[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 12:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.651[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 12:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.652[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 12:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.6549[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 13:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.657[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 13:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.6675[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 13:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.6767[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 13:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.6785[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 14:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.684[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 14:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.6789[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 14:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.6802[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 14:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.6859[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 15:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.7063[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 15:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.7094[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 15:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.6929[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 15:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.6932[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 16:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.7115[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 16:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.7325[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 16:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.7081[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 16:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.723[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 17:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.7329[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 17:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.7318[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 17:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.7484[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 17:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.7508[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 18:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.7476[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 18:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.7355[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 18:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.753[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 18:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.7728[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 19:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.7898[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 19:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.7685[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 19:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.7595[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 19:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.7991[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 20:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.7815[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 20:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.7943[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 20:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.8009[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 20:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.8235[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 21:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.8235[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 21:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.8104[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 21:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.8199[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 21:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.8252[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 22:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.8242[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 22:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.8508[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 22:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.8449[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 22:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.847[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 23:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.8419[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 23:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.8576[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 23:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.8726[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-02 23:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.8784[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 00:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.8692[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 00:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.8737[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 00:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.8761[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 00:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.8929[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 01:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.8812[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 01:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.8928[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 01:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.8887[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 01:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.8948[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 02:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.9[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 02:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.9034[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 02:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.9045[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 02:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.9067[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 03:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.9086[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 03:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.9273[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 03:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.9265[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 03:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.9245[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 04:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.94[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 04:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.9506[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 04:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.9212[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 04:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.93[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 05:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.9417[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 05:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.9498[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 05:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.9723[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 05:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.9477[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 06:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.9427[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 06:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.9681[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 06:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.9815[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 06:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.9485[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 07:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.9541[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 07:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.9751[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 07:30:00[/TD]
[TD="bgcolor: transparent, align: right"]501.9916[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 07:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.9621[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 08:00:00[/TD]
[TD="bgcolor: transparent, align: right"]501.9589[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 08:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.9709[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 08:30:00[/TD]
[TD="bgcolor: transparent, align: right"]502.0017[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 08:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.9962[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 09:00:00[/TD]
[TD="bgcolor: transparent, align: right"]502.0028[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 09:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.9843[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 09:30:00[/TD]
[TD="bgcolor: transparent, align: right"]502.0007[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 09:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.9989[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 10:00:00[/TD]
[TD="bgcolor: transparent, align: right"]502.0242[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 10:15:00[/TD]
[TD="bgcolor: transparent, align: right"]502.011[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 10:30:00[/TD]
[TD="bgcolor: transparent, align: right"]502.0099[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 10:45:00[/TD]
[TD="bgcolor: transparent, align: right"]501.9942[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 11:00:00[/TD]
[TD="bgcolor: transparent, align: right"]502.0184[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 11:15:00[/TD]
[TD="bgcolor: transparent, align: right"]501.9961[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 11:30:00[/TD]
[TD="bgcolor: transparent, align: right"]502.0255[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 11:45:00[/TD]
[TD="bgcolor: transparent, align: right"]502.0362[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 12:00:00[/TD]
[TD="bgcolor: transparent, align: right"]502.029[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 12:15:00[/TD]
[TD="bgcolor: transparent, align: right"]502.0106[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 12:30:00[/TD]
[TD="bgcolor: transparent, align: right"]502.046[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 12:45:00[/TD]
[TD="bgcolor: transparent, align: right"]502.0741[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 13:00:00[/TD]
[TD="bgcolor: transparent, align: right"]502.0272[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 13:15:00[/TD]
[TD="bgcolor: transparent, align: right"]502.0518[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 13:30:00[/TD]
[TD="bgcolor: transparent, align: right"]502.0671[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 13:45:00[/TD]
[TD="bgcolor: transparent, align: right"]502.0597[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 14:00:00[/TD]
[TD="bgcolor: transparent, align: right"]502.0709[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 14:15:00[/TD]
[TD="bgcolor: transparent, align: right"]502.049[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 14:30:00[/TD]
[TD="bgcolor: transparent, align: right"]502.0894[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 14:45:00[/TD]
[TD="bgcolor: transparent, align: right"]502.057[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 15:00:00[/TD]
[TD="bgcolor: transparent, align: right"]502.03[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 15:15:00[/TD]
[TD="bgcolor: transparent, align: right"]502.038[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 15:30:00[/TD]
[TD="bgcolor: transparent, align: right"]502.0789[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 15:45:00[/TD]
[TD="bgcolor: transparent, align: right"]502.1099[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 16:00:00[/TD]
[TD="bgcolor: transparent, align: right"]502.1208[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 16:15:00[/TD]
[TD="bgcolor: transparent, align: right"]502.109[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 16:30:00[/TD]
[TD="bgcolor: transparent, align: right"]502.0808[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 16:45:00[/TD]
[TD="bgcolor: transparent, align: right"]502.0705[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 17:00:00[/TD]
[TD="bgcolor: transparent, align: right"]502.1018[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 17:15:00[/TD]
[TD="bgcolor: transparent, align: right"]502.1115[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 17:30:00[/TD]
[TD="bgcolor: transparent, align: right"]502.1216[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 17:45:00[/TD]
[TD="bgcolor: transparent, align: right"]502.1195[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 18:00:00[/TD]
[TD="bgcolor: transparent, align: right"]502.1144[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 18:15:00[/TD]
[TD="bgcolor: transparent, align: right"]502.1211[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 18:30:00[/TD]
[TD="bgcolor: transparent, align: right"]502.1348[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 18:45:00[/TD]
[TD="bgcolor: transparent, align: right"]502.1453[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 19:00:00[/TD]
[TD="bgcolor: transparent, align: right"]502.1478[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 19:15:00[/TD]
[TD="bgcolor: transparent, align: right"]502.13[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 19:30:00[/TD]
[TD="bgcolor: transparent, align: right"]502.11[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 19:45:00[/TD]
[TD="bgcolor: transparent, align: right"]502.124[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 20:00:00[/TD]
[TD="bgcolor: transparent, align: right"]502.1618[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 20:15:00[/TD]
[TD="bgcolor: transparent, align: right"]502.1575[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 20:30:00[/TD]
[TD="bgcolor: transparent, align: right"]502.1431[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 20:45:00[/TD]
[TD="bgcolor: transparent, align: right"]502.1257[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 21:00:00[/TD]
[TD="bgcolor: transparent, align: right"]502.1497[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 21:15:00[/TD]
[TD="bgcolor: transparent, align: right"]502.1562[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 21:30:00[/TD]
[TD="bgcolor: transparent, align: right"]502.1811[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 21:45:00[/TD]
[TD="bgcolor: transparent, align: right"]502.1753[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 22:00:00[/TD]
[TD="bgcolor: transparent, align: right"]502.1712[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 22:15:00[/TD]
[TD="bgcolor: transparent, align: right"]502.1623[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 22:30:00[/TD]
[TD="bgcolor: transparent, align: right"]502.1669[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 22:45:00[/TD]
[TD="bgcolor: transparent, align: right"]502.1801[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 23:00:00[/TD]
[TD="bgcolor: transparent, align: right"]502.2028[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 23:15:00[/TD]
[TD="bgcolor: transparent, align: right"]502.1904[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 23:30:00[/TD]
[TD="bgcolor: transparent, align: right"]502.1952[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2016-01-03 23:45:00[/TD]
[TD="bgcolor: transparent, align: right"]502.1758[/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
a que te refieres con convertirla en una por dia?

Quieres promediar hasta ese punto? extraer ese valor?
 
Upvote 0
Quiero tener una columa con las lecturas de todo el mes, por cada día a las 09:00AM.

Así:

[TABLE="width: 81"]
<colgroup><col width="108" style="width: 81pt;"> <tbody>[TR]
[TD="width: 108, bgcolor: transparent, align: right"]1/1/2016[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]1/2/2016[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]1/3/2016[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]1/4/2016[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]1/5/2016[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]1/6/2016[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]1/7/2016[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]1/8/2016[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]1/9/2016[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]1/10/2016[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]1/11/2016[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]1/12/2016[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]1/13/2016[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]1/14/2016[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]1/15/2016[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]1/16/2016[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]1/17/2016[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]1/18/2016[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]1/19/2016[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]1/20/2016[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]1/21/2016[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]1/22/2016[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]1/23/2016[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]1/24/2016[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]1/25/2016[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]1/26/2016[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]1/27/2016[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]1/28/2016[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]1/29/2016[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]1/30/2016[/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
Asumiendo que tus datos se miren asi:


Excel 2012
AB
1READINGDATEAVG
21/1/2016 0:00501.1322
31/1/2016 0:15501.1432
41/1/2016 0:30501.1235
51/1/2016 0:45501.1046
61/1/2016 1:00501.1276
71/1/2016 1:15501.1499
81/1/2016 1:30501.1407
91/1/2016 1:45501.1447
101/1/2016 8:15501.2178
111/1/2016 8:30501.2023
121/1/2016 8:45501.2183
131/1/2016 9:00501.2467
141/1/2016 9:15501.2579
151/1/2016 9:30501.2495
161/1/2016 9:45501.2348
171/1/2016 10:00501.2403
181/1/2016 10:15501.265
191/1/2016 10:30501.2674
201/1/2016 10:45501.2603
Hoja1

Puedes usar esta Macro:

Code:
Sub Goku()

Application.ScreenUpdating = False


Sheets(2).Range("A2:B" & (Sheets(2).Cells.Find(What:="*", SearchOrder:=xlRows, _
    SearchDirection:=xlPrevious, LookIn:=xlValues).Row)).Delete
    
lRow = Sheets(1).Cells.Find(What:="*", SearchOrder:=xlRows, _
    SearchDirection:=xlPrevious, LookIn:=xlValues).Row
    
    For iCntr = lRow To 2 Step -1
    If Cells(iCntr, "A") Like "*9:00*" Then
    Rows(iCntr).Copy Sheets(2).Rows(Sheets(2).Cells.Find(What:="*", SearchOrder:=xlRows, _
    SearchDirection:=xlPrevious, LookIn:=xlValues).Row + 1)
    End If
    Next
    
Sheets(1).Range("A1").Select
Application.ScreenUpdating = True


End Sub

Obtendrias un resultado similar a:


Excel 2012
AB
1READINGDATEAVG
21/1/2016 9:00501.2467
Hoja2




En otra hoja
 
Last edited:
Upvote 0

Forum statistics

Threads
1,223,919
Messages
6,175,368
Members
452,638
Latest member
Oluwabukunmi

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top