bunseki pro - 経済統計練習帳

var namex=new Array();
var namey=new Array();
var pointx=new Array();
var pointy=new Array();
var team=new Array();
var v=new Array();
var vs=new Array();
var k=new Array();
var ks=new Array();
 
 
function myFunction() {
 
 
team[1]="ヤクルト";
team[2]="巨人";
team[3]="中日";
team[4]="阪神";
team[5]="ＤｅＮＡ";
team[6]="広島";
 
 
   var sql = 'SELECT * FROM ' +"13T5_beQcu7z2eUfxHAU6cckdlfZ1BJIB-dTUtPra";
 
  var result = FusionTables.Query.sqlGet(sql, {hdrs: false});
 
 var r=result.rows;
 
  sx=0;
    for(var i in r){
   n=r[i][0]/1;
   p=r[i][1];
   if(p.indexOf("h")>-1)namex[n]=r[i][2];
   if(p.indexOf("v")>-1)namey[n]=r[i][2];
   if(p.indexOf("h")>-1)pointx[n]=r[i][17]/1;
   if(p.indexOf("v")>-1)pointy[n]=r[i][17]/1;
  }
 
  for(s=1;s<7;s++){
  v[s]=0;
  vs[s]=0;
  k[s]=0;
  ks[s]=0;  
  }
 
 
 number=n;
 
  for(s=1;s<number+1;s++){
 
    s1=0;
    for(sx=1;sx<7;sx++){
    if(namex[s]==team[sx])s1=sx;
    }
    s2=0;
    for(sx=1;sx<7;sx++){
    if(namey[s]==team[sx])s2=sx;
    }
   v[s1]=v[s1]+pointx[s];
   v[s2]=v[s2]+pointy[s];
   vs[s1]=vs[s1]+pointy[s];
   vs[s2]=vs[s2]+pointx[s];
  }
 
 
   for(s=1;s<number+1;s++){
 
    s1=0;
    for(sx=1;sx<7;sx++){
    if(namex[s]==team[sx])s1=sx;
    }
    s2=0;
    for(sx=1;sx<7;sx++){
    if(namey[s]==team[sx])s2=sx;
    }
     s3=0;
     s4=0;
  if(pointx[s]>pointy[s])s3=s1;
    if(pointx[s]>pointy[s])s4=s2;  
      if(pointy[s]>pointx[s])s3=s2;
    if(pointy[s]>pointx[s])s4=s1;  
 
     k[s3]=k[s3]+1;
     ks[s4]=ks[s4]+1;
 
  }
 
 
 
 
  for(s=1;s<7;s++){
  Logger.log(team[s]+","+v[s]+","+vs[s]+","+k[s]+","+ks[s]);
  }
 
 
 
 
}