2jikafo - 経済統計練習帳

var a=new Array();
var dic=new Array();
 var point=new Array();
 
function myFunction() {
 
id="1ySTEGyN5gkqNGam26OfwicpsVhTfi1XG1hNvl4WJT6Y";
 
var ex = SpreadsheetApp.openById(id); 
var sh = ex.getSheetByName("data");
 
number= sh.getLastRow();
 
var v=sh.getRange(1,1,number,3).getValues();  
 
 
for(s=1;s<number+1;s++){
a[s]=v[s-1][2];
}
 
   dicnumber=0;
 
   dic[0]="";
  for(s=1;s<number+1;s++){ 
    c1=""+a[s];
   sx=dic.indexOf(c1);
 
  if(sx<0)dicnumber=dicnumber+1 
  if(sx<0)dic[dicnumber]=c1;  
  } 
 
  Logger.log(dicnumber);
 
 for(s=1;s<dicnumber+1;s++){ 
 point[s]=0;  
  } 
 
 
  for(s=1;s<number+1;s++){ 
    c1=""+a[s];
   sx=dic.indexOf(c1);
  point[sx]=point[sx]+1;
  } 
 
 
 for(s=1;s<dicnumber+1;s++){ 
  if(point[s]>100)Logger.log(dic[s]+","+point[s]);
  } 
 
 id="1MITiNiVorQFowWEPYNfJA-xSGpJ-Lzp5zUTIrzTIdHs";
 
var ex = SpreadsheetApp.openById(id); 
var sh = ex.getSheetByName("data");
 
 n=0;
  for(s=1;s<dicnumber+1;s++){ 
  if(point[s]>100)n=n+1;
  if(point[s]>100)sh.getRange(n,1).setValue(dic[s]);
  } 
 
}