manaoo - 経済統計練習帳

function myFunction() {
 
 
  id="1mc3qmJNyOkL-2xL83jzm8bAv4YVRO3EKczKRsdUO6kM";
 
ex = SpreadsheetApp.openById(id);
 
sh = ex.getSheetByName("data");
 
   number=sh.getLastRow()-1;
 
  Logger.log(number);
 
   var v=sh.getRange(1,1,number+1,8).getValues();
 
  var code=new Array();
  var year=new Array();
  var month=new Array();
  var day=new Array();
 
  sx=0;
  for(s=1;s<number+1;s++){
  if(v[s][6]==655)sx=sx+1;
  if(v[s][6]==655)month[sx]=v[s][1];
  if(v[s][6]==655)day[sx]=v[s][2];
   if(v[s][6]==655)code[sx]=v[s][7];
   }
 
 
  subnumber=sx;
 
   Logger.log(subnumber);
 
id2="1W9Bws7thV4Rr58OawYWF64HkKc2jl7Dji6uR8Wqi4mQ";
ex2 = SpreadsheetApp.openById(id2);
sh2 = ex2.getSheetByName("data");
 
  var vs=new Array();
 
  for(s=0;s<subnumber+1;s++){
  vs[s]=new Array();
  }
  vs[0][2]="code";  
 
 
  for(s=1;s<subnumber+1;s++){
  vs[s][0]=month[s];
  vs[s][1]=day[s];
  vs[s][2]=code[s];
  }
 
  sh2.getRange(1,1,subnumber+1,3).setValues(vs); 
 
 
 
}