kumizen - 経済統計練習帳

var subx=new Array();
var credit=new Array();
 
function myFunction() {
 
  var id="1nRQbCo6b0wgIlwcQMwJK_6r07XUrZzbqRq-gAupXFbA"; 
 ex1 = SpreadsheetApp.openById(id);
 var sheet = ex1.getSheetByName("data"); 
 
var range=sheet.getRange(1,1,367,130);  
 
var v=range.getValues();
 
  for(s=1;s<130;s++){
  subx[s]=v[6][s];
  credit[s]=v[2][s]+v[3][s];
if(credit[s]=="")credit[s]=credit[s-1]; 
  }
 
 
  var shx = ex1.getSheetByName("rev"); 
 
  var a=new Array();
  sx=0;
  for(s=1;s<130;s++){
  if(subx[s]=="(千円)")sx=sx+1;
  if(subx[s]=="(千円)")a[sx]=s;  
  }
 
number=sx;
 
  var pp=new Array();
  for(s=0;s<100;s++){
  pp[s]=new Array(); 
  for(sx=0;sx<100;sx++){
  pp[s][sx]="abc"+s+">"+sx;
  }
  }
 
 
  shx.getRange(2,2,100,100).setValues(pp);    
 
 
 
 
 
 
}