tiiLL - 経済統計練習帳

var point=new Array();
var rank=new Array();
 
var year=new Array();
var date=new Array();
var sta=new Array();
var west=new Array();
var east=new Array();
var t=new Array();
 
function myFunction() {
 
  n=0;
 
 
  id="1FVx44qMYmNkGq17-TSTPNzyQ0qqNYVDNuZxonnBgSms";
 
 
  for(tr=1;tr<53;tr++){  
 
    pp="a"+(53-tr);
 
    Logger.log(pp+","+n);
 
ex = SpreadsheetApp.openById(id);
 sh = ex.getSheetByName(pp);
 
   number=sh.getLastRow()-1
 
var v=sh.getRange(1,1,number+1,6).getValues();
 
  for(s=1;s<number+1;s++){
  str=""+v[s][1];
  p1=str.indexOf("月");
  p2=str.indexOf("日");
  m1=str.substring(0,p1);
  d1=str.substring(p1+1,p2);  
  point[s]=10000*m1+100*d1-v[s][4]*1;   
  Logger.log(str);
  }
 
  ranking();
 
    for(s=1;s<number+1;s++){
  sx=rank[number+1-s];
  n=n+1;
  year[n]=v[sx][0];
  date[n]=v[sx][1];
  t[n]=v[sx][2];
  sta[n]=v[sx][3];
  west[n]=v[sx][4];
  east[n]=v[sx][5];
  }
 
 
  }
 
 
  id="1bK3T02d_PRqYhbqAFNR_AqxxckwsXmwq9KwfSnRhlfA";
 
  ex1 = SpreadsheetApp.openById(id);
sh1 = ex1.getSheetByName("data");
 
 
  var vs=new Array();
 
   for(s=0;s<n+1;s++){
  vs[s]=new Array();
  }
 
 
  vs[0][5]="east";
 
  for(s=1;s<n+1;s++){
  vs[s][0]=year[s];
  vs[s][1]=date[s];
  vs[s][2]=t[s];
  vs[s][3]=sta[s];
  vs[s][4]=west[s];
  vs[s][5]=east[s]; 
  }
 
 
  sh1.getRange(1,1,n+1,6).setValues(vs);
 
}
  function ranking(){ 
 
var r,s,sx,h; 
var ch=new Array();
 
for(s=1;s<number+1;s++){
ch[s]=0;    
}
 
    for (r = 1; r < number+1; r++) {
        sx = 0;
        maxu = -999;
        for (s = 1; s <number+1; s++) {
            h = 0;
            if (point[s] > maxu) h = h + 1;
            if (ch[s] < 50) h = h + 1;
            if (h == 2) maxu = point[s];
            if (h == 2) sx = s;
        }
        rank[r] = sx;
        ch[sx] = 100;
    }
 
 
}