777667 - 経済統計練習帳

var namex=new Array();
var codex=new Array();
 
var date=new Array();
var dic_code=new Array();
var dic_key=new Array();
 
var name_or=new Array();
var code_or=new Array();
var key_or=new Array();
 
var delta=new Array();
var point=new Array();
 
var number;
var dicnumber;
 
function sample(){
 
 var id="1-JQNJAA9hwmo47QqHJUrSbBvz5-JKy6Y1UncAWLV";
 
 sql(id,5);
 
y1=1972; 
m1=6;
sx=0;
for(s=1;s<number+1;s++){
m1=m1+1;
if(m1>12)y1=y1+1;
if(m1>12)m1=1;
if(m1==2)sx=sx+1;
if(m1==5)sx=sx+1;
if(m1==8)sx=sx+1;
if(m1==11)sx=sx+1;
if(m1==2)date[sx]=y1+"年"+1+"期";
if(m1==5)date[sx]=y1+"年"+2+"期";
if(m1==8)date[sx]=y1+"年"+3+"期";
if(m1==11)date[sx]=y1+"年"+4+"期";
if(m1==2)delta[sx]=point[s];
if(m1==5)delta[sx]=point[s];
if(m1==8)delta[sx]=point[s];
if(m1==11)delta[sx]=point[s];
  }
 
number=sx;
 
 
 var id3="15TkI8L8Bb85HQprsa5UPVsAyoAcy-XP4TR73f2fBX9o";
 
 
 var ex3 = SpreadsheetApp.openById(id3);
  var sh3 = ex3.getSheetByName("data");
 
  var v3=new Array();
  for(s=0;s<number+1;s++){
  v3[s]=new Array();
  }
  v3[0][1]="code";
  for(s=1;s<number+1;s++){
  v3[s][0]=date[s];
  v3[s][1]=delta[s];
  }
 
 
  sh3.getRange(1,1,number+1,2).setValues(v3);
 
 
 
 
 
 
}
 
 
function sql(idx,n) {
 
  var sql = 'SELECT * FROM ' +idx;
 
  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][n];
    }
 
  number=sx;
 
 
}