okukani - 経済統計練習帳

var n=new Array();
var c=new Array();
 
function myFunction() {
 
   id="1QsLed849avh5TUu9hmImsyJT6_jyOLqPZG3Ix37vhqM";
 
 
 
   var point=new Array();
 
   dicnumber=0;
 
  for(sx=1;sx<5001;sx++){
   point[sx]=0;
  }
 
 
 
 var ex1 = SpreadsheetApp.openById(id);
 var sheet = ex1.getSheetByName("data");
 
  number=sheet.getLastRow()-1;
 
  var v=sheet.getRange(1,1,number+1,7).getValues(); 
 
 
  c[0]="";
 
  for(s=1;s<number+1;s++){
    c1=""+v[s][5];
    h=0;
    for(sx=0;sx<dicnumber+1;sx++){
    if(c1==c[sx])h=100;
  }
  if(h<50)dicnumber=dicnumber+1
  if(h<50)c[dicnumber]=c1;
  if(h<50)n[dicnumber]=v[s][4]
  }
 
 
 
  for(s=1;s<number+1;s++){
    c1=""+v[s][5];
    for(sx=1;sx<dicnumber+1;sx++){
    if(c1==c[sx])point[sx]=point[sx]+1;
  }
  }
 
 
 
 
 
    id="11XUbuWkk-iBQgNiG4wdrP58Aeuv5vuQA5nRwYc3AEvI";
 
 ex1 = SpreadsheetApp.openById(id);
 sheet = ex1.getSheetByName("data");
 
 
 
  tx=0;
 
   for(sx=1;sx<dicnumber+1;sx++){
  if(point[sx]>29)tx=tx+1;
  if(point[sx]>29)sheet.getRange(tx,1).setValue(n[sx]);
  if(point[sx]>29)sheet.getRange(tx,2).setValue(point[sx]);
  }
 
 
 
  Logger.log(dicnumber);
 
 
}