vv888 - 経済統計練習帳

var n=new Array();
var c=new Array();
var p=new Array();
 
function myFunction() {
 
 
  id_or="1yDdaRyjVYUE2ayYAltWX7i1aIZ12vGrD3bNl8scr";
 
  var sql = 'SELECT * FROM ' +id_or;
 
  var result = FusionTables.Query.sqlGet(sql, {hdrs: false});
 
 var r=result.rows;
 
 
  sx=0;
    for(var i in r){   
 sx=sx+1;    
n[sx]=r[i][7];
c[sx]=r[i][8];      
p1= 12*r[i][1]/1+r[i][2]/1;
p2= 12*r[i][3]/1+r[i][4]/1;  
p[sx]=p2-p1+1;
   }
 
  number=sx;
 
  dicnumber=0;
 
  var dic=new Array();
  var namex=new Array();
   var point=new Array();
 
  dic[0]="";
 
 
  for(s=1;s<number+1;s++){
   h=0;
  for(sx=0;sx<dicnumber+1;sx++){
    if(dic[sx]==c[s])h=100;
  }
 if(h<50)dicnumber=dicnumber+1;
  if(h<50)dic[dicnumber]=c[s];
   if(h<50)namex[dicnumber]=n[s];
  }
 
 
  for(sx=1;sx<dicnumber+1;sx++){
 point[sx]=0;
  }
 
   for(s=1;s<number+1;s++){
  for(sx=1;sx<dicnumber+1;sx++){
   if(dic[sx]==c[s])point[sx]=point[sx]+p[s];
  }
 }   
 
 
   for(s=1;s<dicnumber+1;s++){
   if(point[s]>36)Logger.log(namex[s]);
   }
 
 
  id="1GNmFmIOoWyyDNeK5WZbA8pDmlqlZVpXl8nynVQh8F6I";
 
ex = SpreadsheetApp.openById(id);
 
sh = ex.getSheetByName("data");
 
  tx=0;
for(s=1;s<dicnumber+1;s++){
if(point[s]>60)tx=tx+1;
if(point[s]>60)sh.getRange(tx,1).setValue(namex[s]);
if(point[s]>60)sh.getRange(tx,2).setValue(dic[s]);
if(point[s]>60)sh.getRange(tx,3).setValue(point[s]); 
}  
 
 
 
}