乱数 GAS - 経済統計練習帳

var point = new Array();
var x = new Array();
var year = new Array();
var pointx = new Array();
var p1;
 
function sample() {
 
 
    for (s = 1; s < 1001;s++ ){
    point[s] = 0;
    for(sx=1;sx<11;sx++){
    if(Math.random()>0.5)point[s]=point[s]+1;    
    }    
    }
 
    for(sx=0;sx<11;sx++){
    pointx[sx]=0;    
    }   
 
      for(s=1;s<1001;s++){
          n = point[s];
          pointx[n] = pointx[n] + 1;
    }   
 
 
 
 
 
 id="1vJD6DDgAj0UsaRoUonhWf7Mj69p-r7gIUKVNcGu8Fj4"; 
 var ex1 = SpreadsheetApp.openById(id);
 var sheet = ex1.getSheetByName("data");
 
 
 sheet.getRange(1,1,100,100).setBackground('white');  
 
 
for(s=1;s<101;s++){  
sheet.setColumnWidth(s, 5)
sheet.setRowHeight(s, 5);
} 
 
    maxp=0;
   for(s=1;s<11;s++){
  if(pointx[s]>maxp)maxp=pointx[s];
  }
 
for(sx=1;sx<11;sx++){  
s2=(100*pointx[sx])/maxp;
s1=100-Math.floor(s2);
if(s1<1)s1=1;  
if(s1<100)sheet.getRange(s1,10*sx,100-s1,10).setBackground('green');  
}
 
 sheet.getRange(1,1,100,1).setBackground('black');
 sheet.getRange(100,1,1,100).setBackground('black');
 
 
 
 
 
 
 
 
}