mataz - 経済統計練習帳

<script src="//ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>
 
<script>
 
var koma=new Array();
 
function sample(){
 
var pr=new Array();
 
  for(s=1;s<48;s++){
pr[s]="#JP-"+s;    
if(s<10)pr[s]="#JP-0"+s;  
}
 
 
 
 
  for(s=1;s<48;s++){
 $(pr[s]).css("fill","blue"); 
    }
 
 
 google.script.run
       .withSuccessHandler(function(z) {
 
 for(s=1;s<48;s++){
  if(z[s][1]>100000)$(pr[s]).css("fill","green"); 
 if(z[s][1]>300000)$(pr[s]).css("fill","pink");
 if(z[s][1]>500000)$(pr[s]).css("fill","red"); 
    }
 
 })          
       .withFailureHandler(function(msg) {})
       .doc();
 
}
 
 
</script>
 
 
function doGet(e) {
  var template = HtmlService.createTemplateFromFile('index');
 
 
  return template.evaluate()
      .setTitle('MAP')
      .setSandboxMode(HtmlService.SandboxMode.IFRAME);
}
 
function doc(){
 
 
 var id="1yP84n-f_mk4-2uErWT57EnZBuMATQRJsbPArLrXjqrU"; 
 ex1 = SpreadsheetApp.openById(id);
 var sheet = ex1.getSheetByName("data"); 
 
  z=sheet.getRange(1,1,48,2).getValues();  
 
 
  return z;
}