うぇえｋｓｘ - 経済統計練習帳

   google.charts.load('current', {'packages': ['corechart']});
      google.charts.setOnLoadCallback(sample);
 
      function sample() {
 
        var query = new google.visualization.Query(
            'https://docs.google.com/spreadsheets/d/1VjCi0k-98P_3YmlHyHb3up0zPl9mp1tbYsJUJxmqegg/edit#gid=0');
        query.send(draw);
      }
      function draw(r) {
 
 
        if (r.isError()) {
          alert('Error in query');
        }
 
        var tc = r.getDataTable();
 
number=tc.getNumberOfRows()
 
var sta=new Array(); 
var y1=new Array(); 
var m1=new Array(); 
var y2=new Array(); 
var m2=new Array(); 
var week=new Array(); 
var code_time=new Array(); 
var title=new Array(); 
 
 
for(s=1;s<number+1;s++){
sta[s]=tc.getValue(s-1, 0);
y1[s]=tc.getValue(s-1, 1);
m1[s]=tc.getValue(s-1, 2);
y2[s]=tc.getValue(s-1, 3);
m2[s]=tc.getValue(s-1, 4);
week[s]=""+tc.getValue(s-1, 5);
code_time[s]=tc.getValue(s-1, 6);
title[s]=tc.getValue(s-1, 7);
}
 
var subx=new Array();
var suby=new Array();
 
sx=0;
for(s=1;s<number+1;s++){
h=0;
if(code_time[s]==9)h=h+1;
if(sta[s]=="tbs")h=h+1;
if(week[s]=="木")h=h+1;
if(h==3)sx=sx+1;
if(h==3)subx[sx]=title[s];
if(h==3)suby[sx]=week[s];
}
 
 
  str="<table>";
 for(s=1;s<sx+1;s++){
    str=str+"<tr>";
    str=str+"<td>";
      str=str+suby[s];
    str=str+"</td>"
 str=str+"<td>";
      str=str+subx[s];
    str=str+"</td></tr>"
}
str=str+"</table>";
 
 
$("#memo").html(str);
 
 
      }