c44+99 - 経済統計練習帳

var point=new Array();
var dic=new Array();
 
function myFunction() {
 
 
 
 
   var sql = 'SELECT * FROM ' +"1ws4euTaMQ6st1tkUqTyffEpUwuZ-3yWtdncSCoZR";
 
  var result = FusionTables.Query.sqlGet(sql, {hdrs: false});
 
 var r=result.rows;
 
  sx=0;
    for(var i in r){
   sx=sx+1;
   point[sx]=r[i][5];
  }
 
  number=sx;
 
  dicnumber=0;
 
  dic[0]="A";
 
  for(s=1;s<number+1;s++){
   h=0; 
  for(sx=1;sx<dicnumber+1;sx++){
  if(point[s]==dic[sx])h=100;
  }
  if(h<50)dicnumber=dicnumber+1;
  if(h<50)dic[dicnumber]=point[s];
  }
 
  var id="1KWBIg-35bSfy2Bqxbb-E_HV6Sj47tsRfkhu6c5Trxuc";
 
 
var ex1 = SpreadsheetApp.openById(id);
var sheet = ex1.getSheetByName("data");
for(s=1;s<dicnumber+1;s++){
sheet.getRange(s,1).setValue(dic[s]);
}  
 
}