っみい - 経済統計練習帳

var code=new Array();
var univ=new Array();
var dic_univ=new Array();
var dic_code=new Array();
 
function myFunction() {
 
ex = SpreadsheetApp.openById("1vWr5xj7bCvnIHpPSXKn3QR188q-X3ffd64PGKiwzW5o");
sh = ex.getSheetByName("data");
 
number=sh.getLastRow()-1;
var v=sh.getRange(1,1,number+1,7).getValues(); 
 
 
for(s=1;s<number+1;s++){
univ[s]=v[s][1];
code[s]=v[s][6];
}
 
 
  dicnumber=0;
  for(s=1;s<number+1;s++){
    h=0;
    for(sx=1;sx<dicnumber+1;sx++){
    if(univ[s]==dic_univ[sx])h=100;
    }
  if(h<60)dicnumber=dicnumber+1;
    if(h<60)dic_univ[dicnumber]=univ[s];
    if(h<60)dic_code[dicnumber]=code[s];
  }
 
 
  Logger.log(dicnumber);
 
  sh2 = ex.getSheetByName("dic");
 
  for(sx=1;sx<dicnumber+1;sx++){
    sh2.getRange(sx,1).setValue(dic_univ[sx]);
    sh2.getRange(sx,2).setValue(dic_code[sx]);
    }
 
 
 
 
}