たんｋｋｌ - 経済統計練習帳

var comx=new Array();
var point=new Array();
var rank=new Array();
 
function myFunction() {
 
sql("1WBZT5KmWKCFQ9ieMUId_Hczs87ygdX3Nzm8OdohB",7);  
 
 ranking();
 
for(s=1;s<11;s++){
sx=rank[s];
Logger.log(comx[sx]+","+point[sx]);
}
 
 
 var id3="1Bx3MI26IL6cDmK8zMpYsnW-xGSftTcbbheEbRid7HXA";
 
 
 var ex3 = SpreadsheetApp.openById(id3);
  var sh3 = ex3.getSheetByName("data");
 
  var v3=new Array();
  for(s=0;s<11;s++){
  v3[s]=new Array();
  }
 
  v3[0][1]="code";
  for(s=1;s<11;s++){
  sx=rank[s];
  v3[s][0]=comx[sx];
  v3[s][1]=point[sx];
  }
 
 
  sh3.getRange(1,1,11,2).setValues(v3);
 
 
 
 
 
}
function sql(id,mx) {
 
 
  var sql = 'SELECT * FROM ' +id;
 
  var result = FusionTables.Query.sqlGet(sql, {hdrs: false});
 
 var r=result.rows;
 
 
  sx=0;
    for(var i in r){ 
sx=sx+1;
comx[sx]= r[i][0]; 
  point[sx]=r[i][mx]/1;
   }
 
 number=sx;
 
 
 
 
 
 
 
}
 
 function ranking(){ 
 
var r,s,sx,h; 
var ch=new Array();
 
ch[0]=0; 
for(s=1;s<number+1;s++){
ch[s]=point[s];    
}
 
    for (r = 1; r <101; r++) {
      sx = ch.indexOf(Math.max.apply(null,ch)) ;
      rank[r] = sx;
      ch[sx] = 0;
    }
 
 
}