けんきゅう０－０ｐ - 経済統計練習帳

var point=new Array();
var y=new Array();
var m=new Array();
 
function myFunction() {
 
 
  y1=-1;
  m1=10;
 
  for(s=1;s<100;s++){
  m1=m1+3;
  if(m1>12)y1=y1+1;
  if(m1>12)m1=1;
  y[s]=y1;
  m[s]=m1;
  point[s]=0;
  }
 
 
id="1H2z6cHPZNygS6DA0rAhdMF4lUmhJjUX1r8rRLP-3";
 
var sql = 'SELECT * FROM ' +id;
 
 
  var result = FusionTables.Query.sqlGet(sql);
 
 var r=result.rows;
 
  for(i in r){
  y1=r[i][2];
  m1=r[i][0];
 
    sxs=0;
    for(sx=1;sx<101;sx++){
    h=0;
    if(y[sx]==y1)h=h+1;
    if(m[sx]==m1)h=h+1;
    if(h==2)sxs=sx;
    }
    point[sxs]=r[i][3];
  }
 
   id="1lSJSM7YEerOWhcSFrMIz8bK0TcFCl4-_h-zuNrfpPto";
 
ex = SpreadsheetApp.openById(id);
 
sh = ex.getSheetByName("data");
 
  number=68;
 
 var v3=new Array();
  for(s=0;s<number+1;s++){
  v3[s]=new Array();
  }
 
  v3[0][1]="code";
  for(s=1;s<number+1;s++){
    v3[s][0]=y[s]+"ねん"+m[s]+"つき";
    v3[s][1]=point[s];
  }
 
  sh.getRange(1,1,number+1,2).setValues(v3);
 
 
 
 
 
}