buuuui - 経済統計練習帳

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="1Eqnq5B-DZ9grbQ4nSXdgoW4AniCdmudKRHjMdGQY";
 
 sql(id,3);
 
y1=1982; 
m1=4;
for(s=1;s<number+1;s++){
m1=m1+1;
if(m1>4)y1=y1+1;
if(m1>4)m1=1;
date[s]=y1+"年"+m1+"期";
  }
 
number=sx;
 
 
 var id3="1wj9_57TK1IdUy4ZqSd_M3jeuNtc7johrybsfGgBe5dY";
 
 
 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]=point[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;
 
 
}