<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Creo que asume los 5 min (veo un INTERVAL 5 MINUTES), pero no se...<br>
<br>
Otra forma de modelarlo que se me ocurrio luego es asumir una
duracion _maxima_ para cada evento de trabajo, digamos 5 min, y
definir la funcion 'tiempo trabajado' por cada evento asi:<br>
<br>
Tt(t1, t0) = (t1-t0) if (t1-t0>5min) else 5min<br>
<br>
Es decir, si el intervalo es menor de 5 min, entonces todo es tiemp
trabajado, si es mayor, asume que 'no le puede haber llevado mas de
5 min'. Obviamente los 5 min podrian ser parametrizables para
ajustarse mejor a tu realidad.<br>
<br>
Con toda honestidad, creo que te convendria jugar un poco a sacar
los numeros de manera procedural primero (un pequeño script en
python o en perl), hacer las cuentas a mano en el script, probar que
se ajusta mejor y despues tratar de buscar el 'query magico'.<br>
<br>
s2<br>
<br>
~Carlos<br>
<br>
<div class="moz-cite-prefix">On 3/25/13 5:12 PM, Gustavo Azambuja
wrote:<br>
</div>
<blockquote
cite="mid:CABGE7dufTVThiJhX9utiF=A=2=FSajwmC_RRa4QO2iA1Fn5guA@mail.gmail.com"
type="cite">
<div dir="ltr">creo... (y nótese el "creo") que lo hace por el
intervalo entre un evento y el siguiente.</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">2013/3/25 Carlos M. Martinez <span
dir="ltr"><<a moz-do-not-send="true"
href="mailto:carlosmarcelomartinez@gmail.com"
target="_blank">carlosmarcelomartinez@gmail.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000"> La veo, es demencial
:D <br>
<br>
Y me sigue sin quedar claro como resuelve el tema
'duracion'.<br>
<br>
salutes !<span class="HOEnZb"><font color="#888888"><br>
<br>
~C.</font></span>
<div>
<div class="h5"><br>
<br>
<div>On 3/25/13 5:01 PM, Gustavo Azambuja wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">No, xq lo que necesito es saber la
cantidad de tiempo trabajado mas alla de las
acciones (si fueron 1 por minuto o 3 por
minuto)...
<div>Les cuento q en G+ me están pasando una query
enorme que tendré que probar... <a
moz-do-not-send="true"
href="https://plus.google.com/u/0/111248427612525054266/posts/6WEozoy1RZm"
target="_blank">https://plus.google.com/u/0/111248427612525054266/posts/6WEozoy1RZm</a></div>
<div><br>
</div>
<div>Gracias desde ya a toda la ayuda! :D</div>
<div><br>
</div>
<div><br>
</div>
</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">2013/3/25 Carlos M.
Martinez <span dir="ltr"><<a
moz-do-not-send="true"
href="mailto:carlosmarcelomartinez@gmail.com"
target="_blank">carlosmarcelomartinez@gmail.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0
0 0 .8ex;border-left:1px #ccc
solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000"> Y no te
sirve mas otras metrica? Estilo "cantidad de
acciones / hora / operador". Tal como
describis tu problema tiene mucho mas
sentido esto que tratar de forzar una
duración a algo que vos queres modelar como
instantáneo.
<div>
<div><br>
<br>
<br>
<div>On 3/25/13 4:54 PM, Gustavo
Azambuja wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">Si, para al final
conseguir la cantidad de minutos
trabajados durante el día de cada
operador y en definitiva, de la suma
de todos los operadores (me interesa
la relación: minutos/día totales).
<div>El tema es que como dije antes,
las acciones son instantáneas, y
muchas veces un usuario tiene 2 o
3 por minuto... (t + 30 seg...)
pero esto no me daría un resultado
real ya que algunos usuarios sería
cada 15 segundos y otros cada
50... la suma sería muy
diferente...</div>
<div><br>
</div>
<div>Por lo que veo, lo que tengo
que hacer es calcular las
diferencias entre cada intervalo y
si son menores a 5 minutos,
sumarlas.</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div class="gmail_extra"> <br>
<div class="gmail_quote">2013/3/25
Nicolás Sanguinetti <span
dir="ltr"><<a
moz-do-not-send="true"
href="mailto:contacto@nicolassanguinetti.info"
target="_blank">contacto@nicolassanguinetti.info</a>></span><br>
<blockquote class="gmail_quote"
style="margin:0 0 0
.8ex;border-left:1px #ccc
solid;padding-left:1ex">
<div dir="ltr">Si entiendo
bien, entonces, lo que
querés es la unión de todos
los intervalos [t, t + 5
minutos]. O sea, vos tenés
que el usuario hizo acciones
en:
<div> <br>
</div>
<div>t1 = 10:00</div>
<div>t2 = 10:02</div>
<div>t3 = 10:06</div>
<div>t4 = 10:15</div>
<div><br>
</div>
<div>Lo que querés es llevar
eso a que trabajó en
[10:00 .. 10:05], [10:02
.. 10:07], [10:06 ..
10:11] y [10:15 .. 10:20].
Y la unión de todos esos
intervalos es [10:00 ..
10:11], [10:15 .. 10:20].</div>
<div><br>
</div>
<div>Eso es lo que querés?</div>
</div>
<div>
<div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">2013/3/25
Chicken Urine <span
dir="ltr"><<a
moz-do-not-send="true"
href="mailto:chickenurine@gmail.com" target="_blank">chickenurine@gmail.com</a>></span><br>
<blockquote
class="gmail_quote"
style="margin:0 0 0
.8ex;border-left:1px
#ccc
solid;padding-left:1ex">
<div dir="ltr">
<div
class="gmail_default">Podés
sacar el máximo
y mínimo para un
usuario y saber
el tiempo total.
Luego a eso le
descontás el
tiempo NO
trabajado, que
serían las
tareas de más de
5 minutos o lo
que sea.</div>
<div
class="gmail_default">La
verdad que así
como está no se
me ocurre como
poder sacar un
valor aproximado
sin, como bien
dijo Carlos,
darle una
duración
promedio a las
tareas.</div>
</div>
<div>
<div>
<div
class="gmail_extra"><br
clear="all">
<div>
<div><br>
</div>
.:-:ChiCkENURiNE:-:.
<div><span>+ </span><span>El
<a
moz-do-not-send="true"
href="http://groups.google.com/group/spam-a-lot/" target="_blank">SPAM</a>
tiene su
lugar.</span></div>
</div>
<br>
<br>
<div
class="gmail_quote">2013/3/25
Gustavo
Azambuja <span
dir="ltr"><<a
moz-do-not-send="true" href="mailto:hola@gazambuja.com" target="_blank">hola@gazambuja.com</a>></span><br>
<blockquote
class="gmail_quote"
style="margin:0
0 0
.8ex;border-left:1px
#ccc
solid;padding-left:1ex">
<div dir="ltr">Si,
entiendo. El
tema es que no
puedo cambiar
la estructura
que está...
pero me diste
algo para
pensar con lo
de t0+5min...
creo que por
ahí lo
soluciono.
<div>Gracias!</div>
</div>
<div>
<div>
<div
class="gmail_extra">
<br>
<br>
<div
class="gmail_quote">2013/3/25
Carlos M.
Martinez <span
dir="ltr"><<a
moz-do-not-send="true" href="mailto:carlosmarcelomartinez@gmail.com"
target="_blank">carlosmarcelomartinez@gmail.com</a>></span><br>
<blockquote
class="gmail_quote"
style="margin:0
0 0
.8ex;border-left:1px
#ccc
solid;padding-left:1ex">
<div
bgcolor="#FFFFFF"
text="#000000">
El tema es que
medir duración
de algo es
como que
lógicamente
incompatible
con la
hipótesis de
que las
acciones son
instantáneas
(es decir de
duración 0,
por lo cual la
sumatoria
siempre seria
0)<br>
<br>
Para calcular
la cantidad de
minutos
ocupados en
eso, se me
ocurren
algunas cosas:<br>
<br>
- asumir una
duracion por
tarea, es
decir, si
aprete enter
en t0, la
tarea duro
hasta t0+5min<br>
- agregar una
columna de
'fin' de la
accion,
tratando de
medir cuando
ese fin
ocurre, creo
que esto es lo
mas razonable,
ya que en
realidad nada
es instantáneo<br>
- asumir que
la duracion de
la tarea es
entre enters
sucesivos del
mismo usuario,
asumiendo que
trabajan
siempre, lo
cual te deja
abierta la
duracion del
ultimo 'enter'
del dia<br>
<br>
- Y
finalmente,
pensar si en
el caso de que
realmente las
acciones sean
logicamente
instantaneas,
si la metrica
'minutos
trabajados'
tiene sentido,
si no hace
falta una
metrica que
sea 'cantidad
de enters por
unidad de
tiempo', o
algo parecido.<br>
<br>
Creo que como
dice Chicken,
falta algo en
el modelado de
tu realidad.<br>
<br>
s2<span><font
color="#888888"><br>
<br>
~C.</font></span>
<div>
<div><br>
<br>
<div>On
3/25/13 11:45
AM, Gustavo
Azambuja
wrote:<br>
</div>
<blockquote
type="cite">
<div dir="ltr">Carlos,
gracias por
responder...
es que no son
"tareas" mas
bien son
"acciones"...
<div>Imaginen
que tienen una
tabla donde
los
funcionarios
que tienen
cada ENTER que
apreto un
usuario/funcionario,
y en la
columna date,
lo que aparece
es la hora en
que apreto
ENTER...</div>
<div><br>
</div>
<div><br>
</div>
<div>
<pre style="white-space:pre-wrap;max-height:600px;width:auto;background-color:rgb(238,238,238);margin-bottom:10px;padding:5px;vertical-align:baseline;line-height:18px;font-size:14px;overflow:auto;font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono','Courier New',monospace,serif;margin-top:0px;border:0px">
<code style="margin:0px;padding:0px;border:0px;vertical-align:baseline;font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono','Courier New',monospace,serif"><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">id</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(0,0,139)">user</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> action</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:tr
ansparent
">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> date
</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">1</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> user1</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> a1</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)"><a moz-do-not-send="true" href="tel:2013-03-20" value="+59820130320" targe
t="_blank
">2013-03-20</a></span><span style="margin:0px;padding:0px;border:0px;vertical-align:base line;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">10</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">:</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">00</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">:</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">01</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">
</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">2</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> user2</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> a1</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)"><a moz-do-not-send="true" href="tel:2013-03-20" value="+59820130320" targe
t="_blank
">2013-03-20</a></span><span style="margin:0px;padding:0px;border:0px;vertical-align:base line;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">10</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">:</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">00</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">:</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">03</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">
</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">3</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> user2</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> a1</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)"><a moz-do-not-send="true" href="tel:2013-03-20" value="+59820130320" targe
t="_blank
">2013-03-20</a></span><span style="margin:0px;padding:0px;border:0px;vertical-align:base line;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">10</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">:</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">00</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">:</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">12</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">
</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">4</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> user3</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> a1</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)"><a moz-do-not-send="true" href="tel:2013-03-20" value="+59820130320" targe
t="_blank
">2013-03-20</a></span><span style="margin:0px;padding:0px;border:0px;vertical-align:base line;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">10</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">:</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">00</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">:</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">20</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">
</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">5</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> user2</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> a1</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)"><a moz-do-not-send="true" href="tel:2013-03-20" value="+59820130320" targe
t="_blank
">2013-03-20</a></span><span style="margin:0px;padding:0px;border:0px;vertical-align:base line;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">10</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">:</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">00</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">:</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"><font color="#800000">24
...
</font><span style="background-color:transparent;margin:0px;padding:0px;border:0px;vertical-align:baseline"><font color="#800000">10</font></span><span style="color:rgb(34,34,34);background-color:transparent;margin:0px;padding:0px;border:0px;vertical-align:baseline">,</span><span style="color:rgb(34,34,34);background-color:transparent;margin:0px;padding:0px;border:0px;vertical-align:baseline"> user3</span><span style="color:rgb(34,34,34);background-color:transparent;margin:0px;padding:0px;border:0px;vertical-align:baseline">,</span><span style="color:rgb(34,34,34);background-color:transparent;margin:0px;padding:0px;border:0px;vertical-align:baseline"> a1</span><span style="color:rgb(34,34,34);background-color:transparent;margin:0px;padding:0px;border:0px;vertical-align:baseline">,</span><span style="color:rgb(34,34,34);background-color:transparent;margin:0px;padding:0px;border:0px;vertical-align:baseline"> </span><span style="color:rgb(128,0,0);background-color:transparent;ma
rgin:0px;
padding:0px;border:0px;vertical-align:baseline"><a moz-do-not-send="true" href="tel:2013-03-20" value="+59820130320" target="_blank">2013-03-20</a></span><span style="color:rgb(34,34,34);background-color:transparent;margin:0px;padding:0px;border:0px;vertical-align:baseline"> </span><span style="color:rgb(128,0,0);background-color:transparent;margin:0px;padding:0px;border:0px;vertical-align:baseline">10</span><span style="color:rgb(34,34,34);background-color:transparent;margin:0px;padding:0px;border:0px;vertical-align:baseline">:</span><span style="color:rgb(128,0,0);background-color:transparent;margin:0px;padding:0px;border:0px;vertical-align:baseline">02</span><span style="color:rgb(34,34,34);background-color:transparent;margin:0px;padding:0px;border:0px;vertical-align:baseline">:</span><span style="color:rgb(128,0,0);background-color:transparent;margin:0px;padding:0px;border:0px;vertical-align:baseline">35
...
<span style="background-color:transparent;color:rgb(34,34,34);margin:0px;padding:0px;border:0px;vertical-align:baseline"><font color="#800000">16</font></span><span style="background-color:transparent;color:rgb(34,34,34);margin:0px;padding:0px;border:0px;vertical-align:baseline">,</span><span style="background-color:transparent;color:rgb(34,34,34);margin:0px;padding:0px;border:0px;vertical-align:baseline"> user3</span><span style="background-color:transparent;color:rgb(34,34,34);margin:0px;padding:0px;border:0px;vertical-align:baseline">,</span><span style="background-color:transparent;color:rgb(34,34,34);margin:0px;padding:0px;border:0px;vertical-align:baseline"> a1</span><span style="background-color:transparent;color:rgb(34,34,34);margin:0px;padding:0px;border:0px;vertical-align:baseline">,</span><span style="background-color:transparent;color:rgb(34,34,34);margin:0px;padding:0px;border:0px;vertical-align:baseline"> </span><span><a moz-do-not-send="true" href="tel:2013-03-
20" value
="+59820130320" target="_blank">2013-03-20</a></span><span style="background-color:transparent;color:rgb(34,34,34);margin:0px;padding:0px;border:0px;vertical-align:baseline"> </span><span style="background-color:transparent;margin:0px;padding:0px;border:0px;vertical-align:baseline">10</span><span style="background-color:transparent;color:rgb(34,34,34);margin:0px;padding:0px;border:0px;vertical-align:baseline">:</span><span style="background-color:transparent;margin:0px;padding:0px;border:0px;vertical-align:baseline">04</span><span style="background-color:transparent;color:rgb(34,34,34);margin:0px;padding:0px;border:0px;vertical-align:baseline">:</span><span style="background-color:transparent;margin:0px;padding:0px;border:0px;vertical-align:baseline">01</span>
</span><font color="#800000">
</font></span></code></pre>
</div>
<div><br>
</div>
<div>El
usuario user1:
apreto solo
una vez ENTER:
10h 00m 01s;
el user2,
:03s, :12s, y
:24s</div>
<div>Ahora,
por ejemplo el
user3, esta
"apretando
ENTER" cada
algunos
cuantos
segundos, y
luego del
id=16 no
aparece mas...
podría decir
entonces que
el user3
trabajó desde
10:00 hasta
las 10:04 (4
minutos
trabajados)</div>
<div><br>
</div>
<div>el tema
es como
consigo llegar
a esa
conclusion
usando PHP y
MySQL...</div>
<div><br>
</div>
<div>Como dije
antes, asumo
que el usuario
ya no está
trabajando si
pasan mas de 5
minutos sin
"acciones"
realizadas.</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
</div>
<div
class="gmail_extra"><br>
<br>
<div
class="gmail_quote">2013/3/25
Carlos M.
Martinez <span
dir="ltr"><<a
moz-do-not-send="true" href="mailto:carlosmarcelomartinez@gmail.com"
target="_blank">carlosmarcelomartinez@gmail.com</a>></span><br>
<blockquote
class="gmail_quote"
style="margin:0
0 0
.8ex;border-left:1px
#ccc
solid;padding-left:1ex">
<div
bgcolor="#FFFFFF"
text="#000000">
Pero como
definis la
'duracion' de
cada tarea ?
el intervalo
entre dos
entradas ? <br>
<div>
<div> <br>
<div>On
3/25/13 10:50
AM, Gustavo
Azambuja
wrote:<br>
</div>
<blockquote
type="cite">
<div dir="ltr">No,
la tarea es
"instantanea"...
digamos, para
entender, que
cada registro
es una
pulsación de
ENTER en el
teclado del
usuario...
sabiendo eso,
y que jamas
pasan 5
minutos sin
dar ENTER a
menos que no
estén
trabajando...
como consigo
saber los
"minutos
trabajados por
operador" (o
la suma de
todos los
operadores)?
<div> <br>
</div>
<div><br>
</div>
</div>
<div
class="gmail_extra"><br>
<br>
<div
class="gmail_quote">2013/3/25
Chicken Urine
<span
dir="ltr"><<a
moz-do-not-send="true" href="mailto:chickenurine@gmail.com"
target="_blank">chickenurine@gmail.com</a>></span><br>
<blockquote
class="gmail_quote"
style="margin:0
0 0
.8ex;border-left:1px
#ccc
solid;padding-left:1ex">
<div dir="ltr">
<div
class="gmail_default">Ok,
entonces el
date ese es la
hora de inicio
de la tarea,
por lo que
supongo que la
duración de
una tarea es
el tiempo
entre 2
registros?</div>
</div>
<div
class="gmail_extra">
<div><br
clear="all">
<div>
<div><br>
</div>
.:-:ChiCkENURiNE:-:.
<div><span>+ </span><span>El
<a
moz-do-not-send="true"
href="http://groups.google.com/group/spam-a-lot/" target="_blank">SPAM</a>
tiene su
lugar.</span></div>
</div>
<br>
<br>
</div>
<div>
<div>
<div
class="gmail_quote">2013/3/25
Gustavo
Azambuja <span
dir="ltr"><<a
moz-do-not-send="true" href="mailto:hola@gazambuja.com" target="_blank">hola@gazambuja.com</a>></span><br>
<blockquote
class="gmail_quote"
style="margin:0
0 0
.8ex;border-left:1px
#ccc
solid;padding-left:1ex">
<p dir="ltr">La
columna date
tiene el
datetime del
evento (q
ejecutó una
acción) </p>
<p dir="ltr">En
definitiva
tengo una
lista de
eventos de
diferentes
usuarios y
necesito
calcular los
"minutos
trabajados
totales) </p>
<p dir="ltr">Para
el cálculo
asumo que si
el usuario no
ejecuta
eventos en 5
minutos no
está
trabajando. </p>
<p dir="ltr">Uso
MySQL, y
podría
completar el
cálculo con
php. </p>
<div
class="gmail_quote">El
mar 25, 2013
8:20 a.m.,
"Chicken
Urine" <<a
moz-do-not-send="true" href="mailto:chickenurine@gmail.com"
target="_blank">chickenurine@gmail.com</a>>
escribió:
<div>
<div><br
type="attribution">
<blockquote
class="gmail_quote"
style="margin:0
0 0
.8ex;border-left:1px
#ccc
solid;padding-left:1ex">
<div dir="ltr">
<div
class="gmail_default">Gustavo,
no me queda
muy claro el
ejemplo. La
columna date
guarda un
resultado de
HH:MM:ss que
llevó un tarea
particular? O
es la hora de
comienzo/fin?</div>
<div
class="gmail_default">Que
rdbms estás
utilizando? Ya
que hay
funciones
específicas en
cada motor
para el manejo
de tipo de
datos date.</div>
</div>
<div
class="gmail_extra">
<br
clear="all">
<div>
<div><br>
</div>
.:-:ChiCkENURiNE:-:.
<div><span>+ </span><span>El
<a
moz-do-not-send="true"
href="http://groups.google.com/group/spam-a-lot/" target="_blank">SPAM</a>
tiene su
lugar.</span></div>
</div>
<br>
<br>
<div
class="gmail_quote">2013/3/24
Gustavo
Azambuja <span
dir="ltr"><<a
moz-do-not-send="true" href="mailto:hola@gazambuja.com" target="_blank">hola@gazambuja.com</a>></span><br>
<blockquote
class="gmail_quote"
style="margin:0
0 0
.8ex;border-left:1px
#ccc
solid;padding-left:1ex">
<div dir="ltr">
<div>Alguien
me puede
ayudar con
esta query?</div>
<div><br>
</div>
<div>básicamente,
necesito
conseguir en
base a una
tabla que
tiene acciones
realizadas por
mis usuarios
(funcionarios)
durante cada
minuto. Ahora,
necesito en
base a esa
tabla saber
los "minutos
trabajados"</div>
<div><br>
</div>
<a
moz-do-not-send="true"
href="http://stackoverflow.com/questions/15606675/minutes-work-by-users-how-to-make-this-query"
target="_blank">http://stackoverflow.com/questions/15606675/minutes-work-by-users-how-to-make-this-query</a><br
clear="all">
<div><br>
</div>
<div>
<pre style="max-height:600px;width:auto;background-color:rgb(238,238,238);margin-bottom:10px;padding:5px;vertical-align:baseline;line-height:18px;font-size:14px;overflow:auto;font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono','Courier New',monospace,serif;margin-top:0px;border:0px">
<code style="margin:0px;padding:0px;border:0px;vertical-align:baseline;font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono','Courier New',monospace,serif"><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">id</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(0,0,139)">user</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> action</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:tr
ansparent
">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> date
</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">1</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> user1</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> a1</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)"><a moz-do-not-send="true" href="tel:2013-03-20" value="+59820130320" targe
t="_blank
">2013-03-20</a></span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">10</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">:</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">00</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">:</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">01</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">
</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">2</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> user2</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> a1</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)"><a moz-do-not-send="true" href="tel:2013-03-20" value="+59820130320" targe
t="_blank
">2013-03-20</a></span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">10</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">:</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">00</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">:</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">03</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">
</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">3</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> user2</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> a1</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)"><a moz-do-not-send="true" href="tel:2013-03-20" value="+59820130320" targe
t="_blank
">2013-03-20</a></span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">10</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">:</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">00</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">:</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">12</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">
</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">4</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> user3</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> a1</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)"><a moz-do-not-send="true" href="tel:2013-03-20" value="+59820130320" targe
t="_blank
">2013-03-20</a></span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">10</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">:</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">00</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">:</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">20</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">
</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">5</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> user2</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> a1</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)"><a moz-do-not-send="true" href="tel:2013-03-20" value="+59820130320" targe
t="_blank
">2013-03-20</a></span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">10</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">:</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">00</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">:</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;color:rgb(128,0,0)">24</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">
</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">....</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">
</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent">...</span></code></pre>
<p> Por
ejemplo:</p>
<ol>
<li
style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;word-wrap:break-word">Si
tengo solo un
funcionario
trabajando las
24h, tendré:
24h*60m = 1440
minutos
trabajados en
el día.</li>
<li
style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;word-wrap:break-word">Si
tengo 2
funcionarios
durante todo
el día (24h)
tendré: 2880
minutos
trabajados
hoy...</li>
<li
style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:transparent;word-wrap:break-word">Si
tengo los
mismos dos
funcionarios,
pero
trabajando 12h
cada uno,
vuelvo a tener
los 1440
m/día.</li>
</ol>
<div><font
color="#000000"
face="Arial,
Liberation
Sans, DejaVu
Sans,
sans-serif"><span
style="font-size:14px;line-height:18px">Alguna idea de como podría armar
una query que
me de ésto? o
como mucho con
algo de PHP
ademas de la
query.</span></font></div>
</div>
<div><font
color="#000000"
face="Arial,
Liberation
Sans, DejaVu
Sans,
sans-serif"><span
style="font-size:14px;line-height:18px"><br>
</span></font></div>
<div><font
color="#000000"
face="Arial,
Liberation
Sans, DejaVu
Sans,
sans-serif"><span
style="font-size:14px;line-height:18px">Gracias!</span></font></div>
<span><font
color="#888888">
<div><br>
</div>
<div><br>
</div>
-- <br>
<font
face="'trebuchet
ms',
sans-serif">Gustavo
Azambuja<br>
</font><a
moz-do-not-send="true"
href="http://gazambuja.com" target="_blank"><font face="'trebuchet ms',
sans-serif">http://gazambuja.com</font></a>
<div> <br>
<font
face="'courier
new',
monospace"><span
style="font-size:x-small">Uruguay:</span></font><font face="'courier
new',
monospace"><span
style="white-space:pre-wrap"><span style="font-size:x-small"> </span></span></font><font
face="'courier
new',
monospace"><span
style="font-size:x-small"><b><a moz-do-not-send="true"
href="tel:091%20300%20333"
value="+59891300333" target="_blank">091 300 333</a></b> (Montevideo -
Mobile)</span></font><font
face="'courier
new',
monospace"><span
style="font-size:x-small"><br>
</span></font></div>
</font></span></div>
<br>
_______________________________________________<br>
Uylug-programming
mailing list<br>
<a
moz-do-not-send="true"
href="mailto:Uylug-programming@listas.uylug.org.uy" target="_blank">Uylug-programming@listas.uylug.org.uy</a><br>
<a
moz-do-not-send="true"
href="http://listas.uylug.org.uy/listinfo.cgi/uylug-programming-uylug.org.uy"
target="_blank">http://listas.uylug.org.uy/listinfo.cgi/uylug-programming-uylug.org.uy</a><br>
<br>
</blockquote>
</div>
<br>
</div>
<br>
_______________________________________________<br>
Uylug-programming
mailing list<br>
<a
moz-do-not-send="true"
href="mailto:Uylug-programming@listas.uylug.org.uy" target="_blank">Uylug-programming@listas.uylug.org.uy</a><br>
<a
moz-do-not-send="true"
href="http://listas.uylug.org.uy/listinfo.cgi/uylug-programming-uylug.org.uy"
target="_blank">http://listas.uylug.org.uy/listinfo.cgi/uylug-programming-uylug.org.uy</a><br>
<br>
</blockquote>
</div>
</div>
</div>
<br>
_______________________________________________<br>
Uylug-programming
mailing list<br>
<a
moz-do-not-send="true"
href="mailto:Uylug-programming@listas.uylug.org.uy" target="_blank">Uylug-programming@listas.uylug.org.uy</a><br>
<a
moz-do-not-send="true"
href="http://listas.uylug.org.uy/listinfo.cgi/uylug-programming-uylug.org.uy"
target="_blank">http://listas.uylug.org.uy/listinfo.cgi/uylug-programming-uylug.org.uy</a><br>
<br>
</blockquote>
</div>
<br>
</div>
</div>
</div>
<br>
_______________________________________________<br>
Uylug-programming
mailing list<br>
<a
moz-do-not-send="true"
href="mailto:Uylug-programming@listas.uylug.org.uy" target="_blank">Uylug-programming@listas.uylug.org.uy</a><br>
<a
moz-do-not-send="true"
href="http://listas.uylug.org.uy/listinfo.cgi/uylug-programming-uylug.org.uy"
target="_blank">http://listas.uylug.org.uy/listinfo.cgi/uylug-programming-uylug.org.uy</a><br>
<br>
</blockquote>
</div>
<br>
<br
clear="all">
<div><br>
</div>
-- <br>
<font
face="'trebuchet
ms',
sans-serif">Gustavo
Azambuja<br>
</font><a
moz-do-not-send="true"
href="http://gazambuja.com" target="_blank"><font face="'trebuchet ms',
sans-serif">http://gazambuja.com</font></a>
<div> <br>
<font
face="'courier
new',
monospace"><span
style="font-size:x-small">Uruguay:</span></font><font face="'courier
new',
monospace"><span
style="white-space:pre-wrap"><span style="font-size:x-small"> </span></span></font><font
face="'courier
new',
monospace"><span
style="font-size:x-small"><b><a moz-do-not-send="true"
href="tel:091%20300%20333"
value="+59891300333" target="_blank">091 300 333</a></b> (Montevideo -
Mobile)</span></font><font
face="'courier
new',
monospace"><span
style="font-size:x-small"><br>
</span></font></div>
</div>
<br>
<fieldset></fieldset>
<br>
<pre>_______________________________________________
Uylug-programming mailing list
<a moz-do-not-send="true" href="mailto:Uylug-programming@listas.uylug.org.uy" target="_blank">Uylug-programming@listas.uylug.org.uy</a>
<a moz-do-not-send="true" href="http://listas.uylug.org.uy/listinfo.cgi/uylug-programming-uylug.org.uy" target="_blank">http://listas.uylug.org.uy/listinfo.cgi/uylug-programming-uylug.org.uy</a>
</pre>
</blockquote>
<br>
</div>
</div>
</div>
</blockquote>
</div>
<br>
<br
clear="all">
<div><br>
</div>
-- <br>
<font
face="'trebuchet
ms',
sans-serif">Gustavo
Azambuja<br>
</font><a
moz-do-not-send="true"
href="http://gazambuja.com" target="_blank"><font face="'trebuchet ms',
sans-serif">http://gazambuja.com</font></a>
<div> <br>
<font
face="'courier
new',
monospace"><span
style="font-size:x-small">Uruguay:</span></font><font face="'courier
new',
monospace"><span
style="white-space:pre-wrap"><span style="font-size:x-small"> </span></span></font><font
face="'courier
new',
monospace"><span
style="font-size:x-small"><b><a moz-do-not-send="true"
href="tel:091%20300%20333"
value="+59891300333" target="_blank">091 300 333</a></b> (Montevideo -
Mobile)</span></font><font
face="'courier
new',
monospace"><span
style="font-size:x-small"><br>
</span></font></div>
</div>
</blockquote>
<br>
</div>
</div>
</div>
</blockquote>
</div>
<br>
<br
clear="all">
<div><br>
</div>
-- <br>
<font
face="'trebuchet
ms',
sans-serif">Gustavo
Azambuja<br>
</font><a
moz-do-not-send="true"
href="http://gazambuja.com" target="_blank"><font face="'trebuchet ms',
sans-serif">http://gazambuja.com</font></a>
<div> <br>
<font
face="'courier
new',
monospace"><span
style="font-size:x-small">Uruguay:</span></font><font face="'courier
new',
monospace"><span
style="white-space:pre-wrap"><span style="font-size:x-small"> </span></span></font><font
face="'courier
new',
monospace"><span
style="font-size:x-small"><b><a moz-do-not-send="true"
href="tel:091%20300%20333"
value="+59891300333" target="_blank">091 300 333</a></b> (Montevideo -
Mobile)</span></font><font
face="'courier
new',
monospace"><span
style="font-size:x-small"><br>
</span></font></div>
</div>
</div>
</div>
<br>
_______________________________________________<br>
Uylug-programming
mailing list<br>
<a
moz-do-not-send="true"
href="mailto:Uylug-programming@listas.uylug.org.uy" target="_blank">Uylug-programming@listas.uylug.org.uy</a><br>
<a
moz-do-not-send="true"
href="http://listas.uylug.org.uy/listinfo.cgi/uylug-programming-uylug.org.uy"
target="_blank">http://listas.uylug.org.uy/listinfo.cgi/uylug-programming-uylug.org.uy</a><br>
<br>
</blockquote>
</div>
<br>
</div>
</div>
</div>
<br>
_______________________________________________<br>
Uylug-programming
mailing list<br>
<a
moz-do-not-send="true"
href="mailto:Uylug-programming@listas.uylug.org.uy" target="_blank">Uylug-programming@listas.uylug.org.uy</a><br>
<a
moz-do-not-send="true"
href="http://listas.uylug.org.uy/listinfo.cgi/uylug-programming-uylug.org.uy"
target="_blank">http://listas.uylug.org.uy/listinfo.cgi/uylug-programming-uylug.org.uy</a><br>
<br>
</blockquote>
</div>
<br>
</div>
</div>
</div>
<br>
_______________________________________________<br>
Uylug-programming mailing list<br>
<a moz-do-not-send="true"
href="mailto:Uylug-programming@listas.uylug.org.uy"
target="_blank">Uylug-programming@listas.uylug.org.uy</a><br>
<a moz-do-not-send="true"
href="http://listas.uylug.org.uy/listinfo.cgi/uylug-programming-uylug.org.uy"
target="_blank">http://listas.uylug.org.uy/listinfo.cgi/uylug-programming-uylug.org.uy</a><br>
<br>
</blockquote>
</div>
<br>
<br clear="all">
<div><br>
</div>
-- <br>
<font face="'trebuchet ms',
sans-serif">Gustavo Azambuja<br>
</font><a moz-do-not-send="true"
href="http://gazambuja.com"
target="_blank"><font
face="'trebuchet ms',
sans-serif">http://gazambuja.com</font></a>
<div> <br>
<font face="'courier new',
monospace"><span
style="font-size:x-small">Uruguay:</span></font><font
face="'courier new',
monospace"><span
style="white-space:pre-wrap"><span
style="font-size:x-small">
</span></span></font><font
face="'courier new',
monospace"><span
style="font-size:x-small"><b>091
300 333</b> (Montevideo -
Mobile)</span></font><font
face="'courier new',
monospace"><span
style="font-size:x-small"><br>
</span></font></div>
</div>
</div>
<br>
<fieldset></fieldset>
<br>
<pre>_______________________________________________
Uylug-programming mailing list
<a moz-do-not-send="true" href="mailto:Uylug-programming@listas.uylug.org.uy" target="_blank">Uylug-programming@listas.uylug.org.uy</a>
<a moz-do-not-send="true" href="http://listas.uylug.org.uy/listinfo.cgi/uylug-programming-uylug.org.uy" target="_blank">http://listas.uylug.org.uy/listinfo.cgi/uylug-programming-uylug.org.uy</a>
</pre>
</blockquote>
<br>
</div>
</div>
</div>
</blockquote>
</div>
<br>
<br clear="all">
<div><br>
</div>
-- <br>
<font face="'trebuchet ms', sans-serif">Gustavo
Azambuja<br>
</font><a moz-do-not-send="true"
href="http://gazambuja.com" target="_blank"><font
face="'trebuchet ms', sans-serif">http://gazambuja.com</font></a>
<div> <br>
<font face="'courier new', monospace"><span
style="font-size:x-small">Uruguay:</span></font><font
face="'courier new', monospace"><span
style="white-space:pre-wrap"><span
style="font-size:x-small"> </span></span></font><font
face="'courier new', monospace"><span
style="font-size:x-small"><b>091 300 333</b>
(Montevideo - Mobile)</span></font><font
face="'courier new', monospace"><span
style="font-size:x-small"><br>
</span></font></div>
</div>
</blockquote>
<br>
</div>
</div>
</div>
</blockquote>
</div>
<br>
<br clear="all">
<div><br>
</div>
-- <br>
<font face="'trebuchet ms', sans-serif">Gustavo Azambuja<br>
</font><a moz-do-not-send="true" href="http://gazambuja.com"
target="_blank"><font face="'trebuchet ms', sans-serif">http://gazambuja.com</font></a>
<div>
<br>
<font face="'courier new', monospace"><span
style="font-size:x-small">Uruguay:</span></font><font
face="'courier new', monospace"><span
style="white-space:pre"><span style="font-size:x-small">
</span></span></font><font face="'courier new', monospace"><span
style="font-size:x-small"><b>091 300 333</b> (Montevideo -
Mobile)</span></font><font face="'courier new', monospace"><span
style="font-size:x-small"><br>
</span></font></div>
</div>
</blockquote>
<br>
</body>
</html>