あこんｊ - 経済統計練習帳

var city=new Array();
var dic=new Array();
var code_com=new Array();
var code_line=new Array();
var line=new Array();
var number_line=new Array();
 var point=new Array();
var dicnumber=new Array();
 
function play() {
 
 id3="1jwSJxpgati0tVFBzFFpwAWdR-1zs_p9TSR3WZmn7F5E"; 
 var ex3 = SpreadsheetApp.openById(id3);
 var sh3 = ex3.getSheetByName("line");
 
  var sh4 = ex3.getSheetByName("data");
 
  de=sh4.getRange(1,1).getValue(); 
 
for(s=1;s<11;s++){  
 line[s]=sh3.getRange(s+1,4).getValue(); 
} 
 
  id="1LGujSBf6C8C-DPzUwnahhk5IMMzT8ZmFQVhE0YMJ2F0"; 
 var ex = SpreadsheetApp.openById(id);
 var sh = ex.getSheetByName("data");
 
 var v=sh.getRange(1,1,10221,8).getValues(); 
 
  for(s=1;s<11;s++){
  city[s]=new Array();
  dic[s]=new Array();
point[s]=new Array();
  }
 
  for(tr=1;tr<11;tr++){
  sx=0;
  for(s=1;s<10221;s++){
  if(v[s][7]==line[tr])sx=sx+1;
 if(v[s][7]==line[tr])city[tr][sx]=v[s][5];
  }
 number_line[tr]=sx; 
 
  }
 
 
 
  for(tr=1;tr<11;tr++){
  dicnumber[tr]=0;
 
  for(s=1;s<number_line[tr]+1;s++){
    h=0;
  for(sx=1;sx<dicnumber[tr]+1;sx++){
  if(city[tr][s]==dic[tr][sx])h=100;
  }
  if(h<60)dicnumber[tr]=dicnumber[tr]+1;
  m=dicnumber[tr];
  if(h<60)dic[tr][m]=city[tr][s];
  }
  }
 
 id="1WZ5wvfC75GryQTfxT81OUuCEzfW7rTdGlY4dron9g6A"; 
 ex = SpreadsheetApp.openById(id);
 sh = ex.getSheetByName("data");
 
 number= sh.getLastRow()-1;
 
 var v2=sh.getRange(1,1,number+1,6).getValues();  
 
  var p=new Array();
  var c=new Array();
 
 
  sx=0;
  for(s=1;s<number+1;s++){
  if(v2[s][4]==de)sx=sx+1;
  if(v2[s][4]==de)c[sx]=v2[s][2];
  if(v2[s][4]==de)p[sx]=v2[s][5];
  }
 
  subnumber=sx;
 
 Logger.log(subnumber);
 
  for(tr=1;tr<11;tr++){
  p1=0;
  for(s=1;s<dicnumber[tr]+1;s++){
  sx=c.indexOf(dic[tr][s]);
  if(sx>0)p1=p1+p[sx];  
  }
  point[tr]=p1;
  sh4.getRange(tr+1,3).setValue(p1);   
  }
 
 
 
}