p**p - 経済統計練習帳

var year=new Array();
var pref=new Array();
var point=new Array();
 
function myFunction() {
 
 
var id="1Q_6bSF57N4nS8Yu_IVJ7Kvcx5-mbw_UNUSwze7fnRqw";
 
 
 var ex1 = SpreadsheetApp.openById(id);
 var sheet = ex1.getSheetByName("data");
 
  c2="#I0520502";
 
 var sql = 'SELECT * FROM ' +"1wtLHxo4Bt3b15XTGn3GJhYNo90sn9-q1xq1re-XD";
 sql =sql +" where code='"+c2+"'"; 
 
  var result = FusionTables.Query.sqlGet(sql, {hdrs: false});
 
 var r=result.rows;
 
  sx=0;
    for(var i in r){
    sx=sx+1;
    year[sx]=r[i][0];
       pref[sx]=r[i][2];
       point[sx]=r[i][5];
  }
 
number=sx;
 
var v=new Array();  
 
for(s=0;s<number+1;s++){
  v[s]=new Array();
  }
 v[0][0]="A";
  v[0][2]="point";
  for(s=1;s<number+1;s++){
    v[s][0]=year[s];
    v[s][1]=pref[s];
    v[s][2]=point[s];
  }
 
  Logger.log(number);
 
 
    sheet.getRange(1,1,number+1,3).setValues(v);
 
 
 
}
 
 
function f(){
 
var id="1Q_6bSF57N4nS8Yu_IVJ7Kvcx5-mbw_UNUSwze7fnRqw";
 
 
 var ex2 = SpreadsheetApp.openById(id);
 var sheet = ex2.getSheetByName("rev"); 
 
var v=sheet.getRange(1,1,48,6).getValues();
 
 
 
 
 
  var r,s,sx,h; 
var ch=new Array();
var rank=new Array(); 
var point=new Array(); 
for(s=1;s<48;s++){
point[s]=0;    
}
 
  for(tr=1;tr<6;tr++){
 
for(s=1;s<48;s++){
ch[s]=0;    
}
 
  var rank=new Array();
 
    for (r = 1; r < 48; r++) {
        sx = 0;
        maxu = 0;
        for (s = 1; s < 48; s++) {
            h = 0;
            if (v[s][tr] > maxu) h = h + 1;
            if (ch[s] < 50) h = h + 1;
            if (h == 2) maxu = v[s][tr];
            if (h == 2) sx = s;
        }
        rank[r] = sx;
        ch[sx] = 100;
    }
 
  for(s=1;s<48;s++){
  sx=rank[s];
  point[sx]=point[sx]+(48-s);  
  }
 
  }
 
  for(s=1;s<48;s++){
ch[s]=0;    
}
 
 
  for (r = 1; r < 48; r++) {
        sx = 0;
        maxu = 0;
        for (s = 1; s < 48; s++) {
            h = 0;
            if (point[s] > maxu) h = h + 1;
            if (ch[s] < 50) h = h + 1;
            if (h == 2) maxu = point[s];
            if (h == 2) sx = s;
        }
        rank[r] = sx;
        ch[sx] = 100;
    }
 
 
  for(s=1;s<48;s++){
  sx=rank[s];
  Logger.log(s+","+v[sx][0]);  
  }
 
 
}