uuyy - 経済統計練習帳

var x=new Array();
 
function doGet(e) {
  var template = HtmlService.createTemplateFromFile('map');
 
 
  return template.evaluate()
      .setTitle('日本地図')
      .setSandboxMode(HtmlService.SandboxMode.IFRAME);
}
var year=new Array();
var pref=new Array();
var x=new Array();
 
function exl() {
 
ex = SpreadsheetApp.openById("1LLq7NpZ0erFn63Z9TwsTsTpVHf7l3GJSr6lcXsdCxwY");
sh = ex.getSheetByName("65歳以上人口");
 
number=sh.getLastRow();
var v=sh.getRange(1,1,number,60).getValues(); 
 
 
 
  fastline=0;
  for(s=1;s<5;s++){
  if(v[s][0]=="北海道")fastline=s;
  }
 
  credity=0;
 
  Logger.log(fastline);
 
  for(s=1;s<60;s++){
  abc="de"+v[fastline-1][s];
  if(abc.length>3)credity=s;
  }
 
  creditx=1;
 
  for(sx=creditx;sx<credity+1;sx++){
  year[sx]=v[fastline-1][sx];
 
  }
 
  for(s=1;s<48;s++){
  pref[s]=v[s+fastline-1][0];
  }
 
ex2 = SpreadsheetApp.openById("1JPDu9KnRGUFyzRt0hZDQLCzop0JKdRRAo8o55YvH6bQ");
sh2 = ex2.getSheetByName("data");
 
  s1=0;
  for(sx=creditx;sx<credity+1;sx++){
  if(year[sx]==1980)s1=sx;
  }
 
 
  s2=0;
  for(sx=creditx;sx<credity+1;sx++){
  if(year[sx]==2013)s2=sx;
  }
 
  for(s=1;s<48;s++){
  x[s]=(v[s+fastline-1][s2]-v[s+fastline-1][s1])/v[s+fastline-1][s1];
  }
 
 
return x;
 
}