4houx - 経済統計練習帳

var credit=new Array();
var code=new Array();
var year=new Array();
var week=new Array();
 
function myFunction() {
 
  id="1m7yZMv6gAQL7wj57lNyriwgy22LTiGf2E1E5wrMGLNM";
  ex = SpreadsheetApp.openById(id);
 
  var sheet = ex.getSheetByName("1");
 
var v=sheet.getRange(1, 1,81,60).getValues();
 
 
 
  fastline=9;
  lastline=79;
 
  for(s=1;s<81;s++){
  credit[s]=""+v[s][1]+v[s][2];
  code[s]=v[s][4];  
  }  
 
  creditx=5;
  credity=36;
 
 
  for(s=1;s<60;s++){
  year[s]=""+v[6][s];
  }  
 
 
 
  for(s=creditx;s<credity+1;s++){
  week[s]=""+v[4][s];
  if(week[s].length<1)week[s]=week[s-1];
  }  
 
  var point=new Array();
 
  delta=credity-creditx+2;
 
  number=lastline-fastline+3;
 
  for(s=0;s<number;s++){
  point[s]=new Array();  
  }
 
 
 
  for(s=fastline;s<lastline+1;s++){
  for(sx=creditx;sx<credity+1;sx++){
  s1=s-fastline+2;
  s2=sx-creditx+1; 
  point[s1][s2]=v[s][sx];  
  }}
 
  for(s=fastline;s<lastline+1;s++){
  s1=s-fastline+2; 
  point[s1][0]=credit[s];  
  }
 
 
  for(s=creditx;s<credity+1;s++){
  s1=s-creditx+1; 
  point[0][s1]=week[s];  
  point[1][s1]=year[s];  
  }
 
  var shx = ex.getSheetByName("a1");
 
  shx.getRange(1,1,number,delta).setValues(point);
 
 
 
 
 
 
 
 
 
 
 
 
}
 
function f2() {
 
  id="1m7yZMv6gAQL7wj57lNyriwgy22LTiGf2E1E5wrMGLNM";
  ex = SpreadsheetApp.openById(id);
 
  var sheet = ex.getSheetByName("2");
 
var v=sheet.getRange(1, 1,81,60).getValues();
 
 
 
  fastline=9;
  lastline=79;
 
  for(s=1;s<81;s++){
  credit[s]=""+v[s][1]+v[s][2];
  code[s]=v[s][4];  
  }  
 
  creditx=5;
  credity=36;
 
 
  for(s=1;s<60;s++){
  year[s]=""+v[6][s];
  }  
 
 
 
  for(s=creditx;s<credity+1;s++){
  week[s]=""+v[4][s];
  if(week[s].length<1)week[s]=week[s-1];
  }  
 
  var point=new Array();
 
  delta=credity-creditx+2;
 
  number=lastline-fastline+3;
 
  for(s=0;s<number;s++){
  point[s]=new Array();  
  }
 
 
 
  for(s=fastline;s<lastline+1;s++){
  for(sx=creditx;sx<credity+1;sx++){
  s1=s-fastline+2;
  s2=sx-creditx+1; 
  point[s1][s2]=v[s][sx];  
  }}
 
  for(s=fastline;s<lastline+1;s++){
  s1=s-fastline+2; 
  point[s1][0]=credit[s];  
  }
 
 
  for(s=creditx;s<credity+1;s++){
  s1=s-creditx+1; 
  point[0][s1]=week[s];  
  point[1][s1]=year[s];  
  }
 
  var shx = ex.getSheetByName("a2");
 
  shx.getRange(1,1,number,delta).setValues(point);
 
 
 
 
 
 
 
 
 
 
 
 
}