ma@p99 - 経済統計練習帳

<script>
 
 
function sample(){
 
 google.script.run
       .withSuccessHandler(function(v) {
 
var x=new Array();
var y=new Array();
 
number=22140;
 
for(s=1;s<number+1;s++){
y[s]=v[s][3];
x[s]=v[s][4];
     }
 
 
     maxx=0;
     maxy=0;
     for(s=1;s<number+1;s++){
     if(x[s]>maxx)maxx=x[s];
     if(y[s]>maxy)maxy=y[s];
     }
     minx=maxx;
     miny=maxy;
     for(s=1;s<number+1;s++){
     if(x[s]<minx)minx=x[s];
     if(y[s]<miny)miny=y[s];
     }
 
 
     var canv = document.getElementById('memo');
 
  var ctx = canv.getContext('2d');
  ctx.fillStyle = "blue";
  for(s=1;s<number+1;s++){
  ctx.beginPath();
  x1=500*(x[s]-minx)/(maxx-minx);
  y1=500*(y[s]-miny)/(maxy-miny);
  ctx.arc(x1, 500-y1, 1, 0, Math.PI*2, false);
  ctx.fill();
     }
 
     })
       .withFailureHandler(function(msg) {})
       .play();
 
}
 
</script>
 
 
function doGet(e) {
  var template = HtmlService.createTemplateFromFile('index');
 
 
  return template.evaluate()
      .setTitle('練習')
      .setSandboxMode(HtmlService.SandboxMode.IFRAME);
}
 
function play(){
 
   var id="1hFOj2gtkhrmAF8VVHBBP_83-PTNQizberxjZoqZWPl4"; 
 ex1 = SpreadsheetApp.openById(id);
 var sheet = ex1.getSheetByName("data");  
 
 
  var v=sheet.getRange(1,1,22141,5).getValues();  
 
return v;  
 
 
}