m77+ - 経済統計練習帳

var city=new Array();
var p=new Array();
var rank=new Array();
 
function myFunction() {
 
    id="17k_thNsZbgsnp77cEGlMEb26JY70ygN45BcThEEV";
 
var sql = 'SELECT adr,y1990 from ' +id;
 
  var result = FusionTables.Query.sqlGet(sql);
 
 var r=result.rows;
 
sx=0;
for(i in r){
sx=sx+1;
city[sx]=r[i][0];
p[sx]=r[i][1]/1;
}
 
number=sx;
 
ranking();
 
 
 var id3="1Knd_g5ZWzS646ek0L4YroSxDVlLR2aUOSryBiqzGxU8";
 
 
 var ex3 = SpreadsheetApp.openById(id3);
  var sh3 = ex3.getSheetByName("data");
 
  var v3=new Array();
  for(s=0;s<101;s++){
  v3[s]=new Array();
  }
 
  v3[0][1]="code";
  for(s=1;s<101;s++){
  sx=rank[s];
  v3[s][0]=city[sx];
  v3[s][1]=p[sx];
  }
 
 
  sh3.getRange(1,1,101,2).setValues(v3);
 
 
 
 
 
 
 
}
 
 function ranking(){ 
 
var r,s,sx,h; 
var ch=new Array();
 
ch[0]=0; 
for(s=1;s<number+1;s++){
ch[s]=p[s];    
}
 
    for (r = 1; r <101; r++) {
      sx = ch.indexOf(Math.max.apply(null,ch)) ;
      rank[r] = sx;
      ch[sx] = 0;
    }
 
 
}