んｈｈ - 経済統計練習帳

var n=new Array();
var c=new Array();
 
function myFunction() {
 
   id="1yg4hRL0cg-TmfKGBBTtJwBJeW5zqgKjkXrTC_fAp2FM";
 
  var w1=new Array(); 
 
  w1[1]="日本";
  w1[2]="tbs";
  w1[3]="フジ";
  w1[4]="朝日";
  w1[5]="東京";
 
   var point=new Array();
 
   dicnumber=0;
 
  for(sx=1;sx<5001;sx++){
   point[sx]=0;
  }
 
 
  for(tr=1;tr<6;tr++){ 
 
 var ex1 = SpreadsheetApp.openById(id);
 var sheet = ex1.getSheetByName(w1[tr]);
 
  number=sheet.getLastRow()-1;
 
  var v=sheet.getRange(1,1,number+1,4).getValues(); 
 
 
  c[0]="";
 
  for(s=1;s<number+1;s++){
    c1=""+v[s][3];
    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][2]
  }
 
 
 
  for(s=1;s<number+1;s++){
    c1=""+v[s][3];
    for(sx=1;sx<dicnumber+1;sx++){
    if(c1==c[sx])point[sx]=point[sx]+1;
  }
  }
 
 
  }
 
 
    id="1gh_pl5DD07QzskAFU8L3G4i0M1tNixe2LVCHHYLenYQ";
 
 ex1 = SpreadsheetApp.openById(id);
 sheet = ex1.getSheetByName("data");
 
 
 
  tx=0;
 
   for(sx=1;sx<dicnumber+1;sx++){
  if(point[sx]>9)tx=tx+1;
  if(point[sx]>9)sheet.getRange(tx,1).setValue(n[sx]);
  if(point[sx]>9)sheet.getRange(tx,2).setValue(point[sx]);
  }
 
 
 
  Logger.log(dicnumber);
 
 
}