daily
program: program daily
program: dim dtable
program: dim label
program: output=""
program: url="http://www.yama-lab.org/adk-wiki-1/pir-1-"
program: for i=0 to 23
program: hour=0
program: page=ex("connector" , "getpage "+url+hour)
program: parsecsv2(page,dtable,label)
program: y0=sumif("c",dtable,label("device"),"==","a0",label("sdv"))
program: c0=countif("c",dtable,label("device"),"==","a0")
program: ave0=y0/c0
program: y1=sumif("c",dtable,label("device"),"==","a1",label2index("v"))
program: c1=countif("c",dtable,label("device"),"==","a1")
program: ave1=y1/c1
program: y2=sumif("c",dtable,label("device"),"==","a2",label2index("v"))
program: c2=countif("c",dtable,label("device"),"==","a2")
program: ave2=y2/c2
program: output=output+"Date="+dtable(0,label("Date"))+
program: ",ave-a0="+ave0+",ave-a1="+ave1+",ave-a2="+ave2+".\n"
program: next i
program: print output
command: run daily
command:
result:
device=a-0, Date=2012/12/24/ 0, sdv=10.434068380627922.
device=a-1, Data=2012/12/24/ 0, v=100.
, max=631, min=556, f1=2, f2=0, f3=0, n=600, dt=100.
device=a-2, Date=2012/12/24/ 17:46:54, v=174.
device=d, Date=2012/12/24/ 17:46:54, v=0x0c0.
device=a-1, Date=2012/12/24/ 17:47:17, ave=15, sdv=33.053828152810915, max=88, min=0, f1=2, f2=0, f3=0, n=10, dt=10000.