ｖ４４＋＋ｐ - 経済統計練習帳

var city=new Array();
var code_city=new Array();
var credit=new Array();
var code_credit=new Array();
var point=new Array();
var year=new Array();
 
function myFunction() {
 
  tx=0;
  var id=new Array();
  var namex=new Array();
 
  id[1]="12ROY59lIbqgNlPkHc9_OMOlD7OuK6sLMNoA6ycFyX8Q";
 id[2]="1QkhP0N_kw3aklQD1HXqFoyP1DB3D9suqkofaFPw0tDM";
  id[3]="1uA4g2q0N043Fw6q9cKi37rAC_8H8OIXL360wtX2GPiA";
  id[4]="17mBt3fshCYAALpYvALL44z1e733cDDfq6TOAMMZApis";
  id[5]="1fZhTNODVeIqer48zwSJAwFOqSS1fTGvb9qOB_o6jWgQ";
  id[6]="1uPXtxGZgw41tnDna8DvLwjj0q9IcjPZcqbBRIe5UfKI";
  id[7]="1pJRaKRE-ZVGj16ZZo6dI1wr242nRguhGy3wtuyPRg_A";
  id[8]="1UccaykRyH5k_IAELCBgV7ZfagiFfsAhPfhol8_sWLaA";
  id[9]="1zyTufNfBtNbE4VPXBeYHBG_B7vRX_bCBQ6dLxSYxGo8";
  id[10]="1xo5AnfxtcyTUFBwLwL53R8HCrUgZjfARvRKJxh-orvc";
 
  namex[1]="a";
  namex[2]="b";
  namex[3]="c";
  namex[4]="d";
  namex[5]="e";
  namex[6]="f";
  namex[7]="g";
  namex[8]="h";
  namex[9]="i";
  namex[10]="j";
 
  tr=1;
 
  for(tr=1;tr<11;tr++){
ex = SpreadsheetApp.openById(id[tr]);
 
sh = ex.getSheetByName(namex[tr]);
 
    number=sh.getLastRow()-1;
 
  Logger.log(number);
 
 
 var v=sh.getRange(1,1,number+1,30).getValues();
 
  var fastline=0;
  for(s=1;s<11;s++){
    if(v[s][1].indexOf("北海道")>-1)fastline=s;
 
  }
 
  lastline=0;
  for(s=fastline+1;s<number+1;s++){
  if(v[s][1].indexOf("与那国町")>-1)lastline=s;
  }
 
   Logger.log(lastline);
 
  creditline=0;
   for(s=1;s<fastline;s++){
  if(v[s][0].indexOf("区")>-1)creditline=s;
 
  }
 
  Logger.log(creditline);
 
 
  creditx=2;
 
  credity=0;
  for(sx=2;sx<30;sx++){
  if(v[creditline][sx].indexOf("ｺｰﾄﾞ")>-1)credity=sx-1;  
  }
 
  Logger.log(credity);
 
 
  for(s=fastline;s<lastline+1;s++){
  for(sx=creditx;sx<credity+1;sx++){
  tx=tx+1;
  code_city[tx]=v[s][0];
  city[tx]=v[s][1];
  year[tx]=v[fastline-1][sx]  
  point[tx]=v[s][sx];
  code_credit[tx]=v[fastline-3][sx]  
  credit[tx]=v[2][sx]  
  }}  
 
 
 
  Logger.log(tx);
 
  }
 
 
  var delta=new Array();
  for(s=0;s<tx;s++){
  delta[s]=new Array();
  }
  for(s=0;s<tx;s++){
  delta[s][0]=year[s+1];
  delta[s][1]=city[s+1];
  delta[s][2]=code_city[s+1];
 delta[s][3]=credit[s+1];
 delta[s][4]=code_credit[s+1];
 delta[s][5]=point[s+1];  
  }
 
 
  ex = SpreadsheetApp.openById("1WZ5wvfC75GryQTfxT81OUuCEzfW7rTdGlY4dron9g6A");
 
sh = ex.getSheetByName("data");
 
 
 
 
 sh.getRange(1,1,tx,6).setValues(delta);
 
 
 
 
 
 
 
 
 
 
}