toshtune - 経済統計練習帳

function myFunction() {
 
  c="mv59537";
 
 
  id="1_Z8iHPW3R3_nSHdmx415_NUUM1wEQc3kE7uUWHzTzvM";
 
ex = SpreadsheetApp.openById(id);
 
sh = ex.getSheetByName("data");
 
number=sh.getLastRow()-1;
 
Logger.log(number);
  var v=sh.getRange(1,1,number+1,11).getValues();
 
  var point=new Array();
 
  sx=0;
  for(s=1;s<number+1;s++){
if(v[s][10]==c)sx=sx+1;
  if(v[s][10]==c)point[sx]=v[s][5];  
  }
 
  numberx=sx;
  if(numberx>100)numberx=100; 
 
 
 
 id2="166lKb1RmdTyFtejkV7gvC18o0Y0NQUsSQxnbUAW5HMY"; 
 var ex2 = SpreadsheetApp.openById(id2);
 var sh2 = ex2.getSheetByName("data");
 
 
 sh2.getRange(1,1,100,100).setBackground('white');  
 
 
for(s=1;s<numberx;s++){  
sh2.setColumnWidth(s, 5)
sh2.setRowHeight(s, 5);
} 
 
    maxp=0;
   for(s=1;s<numberx;s++){
  if(point[s]>maxp)maxp=point[s];
  }
 
for(sx=1;sx<numberx+1;sx++){  
s2=point[sx]/2000;
s1=100-Math.floor(s2);
if(s1<1)s1=1;  
if(s1<100)sh2.getRange(s1,sx,100-s1,1).setBackground('red');  
}
 
 sh2.getRange(1,1,100,1).setBackground('black');
 sh2.getRange(100,1,1,100).setBackground('black');
 sh2.getRange(50,1,1,100).setBackground('blue');
 
 
 
}