zokutyou - 経済統計練習帳

var artist=new Array();
var code=new Array();
var dic=new Array();
var dic_code=new Array();
var dicnumber;
var point=new Array();
var idx=new Array();
var sig=new Array();
 
function myFunction() {
 
  for(s=1;s<12;s++){
  point[s]=new Array();
  }
 
 
  dicnumber=0;
 
  idx[1]="15e2glUZfCfJz7GsgkWUUoZTlpJ9jqYLn7B8VtER9O5c";
  idx[2]="1GHPc7O1wRT_C_SoVCSfz-ywqQKa2xN7VpIWo9UpLYag";
  idx[3]="1rB9AUWmzyR4SNYolym3zdAR87-VjQb_UzfDgEXb35YQ";
  idx[4]="1boo-Jx9OvwsxUa0QMqKagO1EbZALzhyyliqw6i-bQIY";
  idx[5]="1FvJcEb3qSEiqF10lGOzaYnyKHV7m_AoI2BO2TtXj-wY";
  idx[6]="1lb77CAterCipS6iNi5nc-eMPKwRPurvnnksHu_i3mYo";
  idx[7]="1oQrmmM7SXubMfoNHckYe07z8owzJTKFTBqvH-2nKjYg";
  idx[8]="1aRIOh2LQeBWnFEjQOyN8Ul-XrEWUA8-sHL_Ki6jiauY";
  idx[9]="1Q3q_zDNdhWm-34w97oxAI7sFRKcwn2s4B2_ihPOH0gw";
  idx[10]="1sCRdWE6qQYi3S-oARf6UjIFlbvtk2yjj0C6I2Qih74E";
  idx[11]="1suN0PnE8ajEQdWqaUQeFzzKxsxIzDdjC03JcTz7CklY";
 
 
 
  for(tr=1;tr<12;tr++){
id=idx[tr];
 
ex = SpreadsheetApp.openById(id);
 
sh = ex.getSheetByName("data");
 
 
  number=sh.getLastRow()-1;
 
    Logger.log(tr+","+number)
 
 var v=sh.getRange(1,1,number+1,7).getValues(); 
 
  var s1=0;
  var s2=0;
  for(s=0;s<7;s++){
  str=""+v[0][s];
 if(str.indexOf("artist")>-1)s1=s; 
  if(str.indexOf("code")>-1)s2=s;    
}
 
 
 
  for(s=1;s<number+1;s++){
  artist[s]=v[s][s1];
  code[s]=v[s][s2];  
  }
 
for(s=1;s<number+1;s++){
n=code[s];
sx=0;
if(n>0)sx=dic_code.indexOf(n);
if(sx<0)dicnumber=dicnumber+1;    
if(sx<0)dic_code[dicnumber]=code[s];
if(sx<0)dic[dicnumber]=artist[s];
  }
 
 
   for(s=1;s<9000;s++){
   point[tr][s]=0;
   }
 
 
   for(s=1;s<number+1;s++){
n=code[s];
sx=dic_code.indexOf(n);    
if(sx>0)point[tr][sx]=point[tr][sx]+1;
  }
 
 
 
  }
 
 
  id="1x-dkoBdgnPkypks-D-VNrV6Y4VRBfsbOtA0WDCY_aNs";
  ex = SpreadsheetApp.openById(id);
 
sh = ex.getSheetByName("data");
 
  sx=0;
  for(s=1;s<9000;s++){  
  h=0;
  if(point[1][s]>0)h=h+1;
  if(point[2][s]>0)h=h+1;
  if(point[3][s]>0)h=h+1;
  if(point[4][s]>0)h=h+1;
  if(point[5][s]>0)h=h+1;
  if(point[6][s]>0)h=h+1;  
  if(point[7][s]>0)h=h+1;
  if(point[8][s]>0)h=h+1;
  if(point[9][s]>0)h=h+1;
  if(point[10][s]>0)h=h+1;
  if(point[11][s]>0)h=h+1;
  if(h>4)sx=sx+1;
  if(h>4)sig[sx]=s;  
 
}
 
  numberx=sx;
 
  Logger.log(numberx);
 
  for(s=1;s<numberx+1;s++){ 
   sx=sig[s]; 
   sh.getRange(s,1).setValue(dic[sx]);
  sh.getRange(s,2).setValue(dic_code[sx]);
    for(m=1;m<12;m++){
   sh.getRange(s,m+2).setValue(point[m][sx]);
  }
  }
 
 
 
}