ypoi - 経済統計練習帳

var code=new Array();
var title=new Array();
var dic=new Array();
var t=new Array();
var y1=new Array();
var m1=new Array();
var y2=new Array();
var m2=new Array();
var point=new Array();
 
function myFunction() {
 
id="1VjCi0k-98P_3YmlHyHb3up0zPl9mp1tbYsJUJxmqegg";
 
var ex1 = SpreadsheetApp.openById(id); 
var sheet = ex1.getSheetByName("data"); 
 
  number=sheet.getLastRow()-1; 
 
  var v=sheet.getRange(1,1,number+1,12).getValues()
 
for(s=1;s<number+1;s++){
code[s]=v[s][9];
title[s]=v[s][7];
y1[s]=v[s][1];
m1[s]=v[s][2];
y2[s]=v[s][3];
m2[s]=v[s][4];
}
 
 dicnumber=0;
 
  for(s=1;s<number+1;s++){ 
    c1=""+code[s]; 
    sx=dic.indexOf(c1);
  if(sx<0)dicnumber=dicnumber+1 
  if(sx<0)dic[dicnumber]=c1; 
  if(sx<0)t[dicnumber]=title[s] 
  } 
 
Logger.log(dicnumber);
 
for(s=1;s<dicnumber+1;s++){ 
point[s]=0;
}
 
 for(s=1;s<number+1;s++){ 
   c1=""+code[s]; 
    sx=dic.indexOf(c1);
  point[sx]=point[sx]+12*(y2[s]-y1[s])+(m2[s]-m1[s]);
  } 
 
  for(s=1;s<dicnumber+1;s++){ 
if(point[s]>40)Logger.log(t[s]);
}
 
 
 
 
 
 
 
 
}