番組８８ - 経済統計練習帳

var y1=new Array();
var m1=new Array();
var y=new Array();
var m=new Array();
var y2=new Array();
var m2=new Array();
var namex=new Array();
 
function myFunction() {
 
 
  id_or="1LDB7Okv-STu-pePsxQAtE_O6ZtTu8DUN745dI_K0";
 
  var sql = 'SELECT * FROM ' +id_or;
 sql=sql+"　where week='火'"
 
  var result = FusionTables.Query.sqlGet(sql, {hdrs: false});
 
 var r=result.rows;
 
 
  sx=0;
    for(var i in r){   
 de=r[i][6];
 dex=e101(de);     
 if(dex>60)     sx=sx+1;
  if(dex>60)    y1[sx]=r[i][1]/1;
 if(dex>60)     m1[sx]=r[i][2]/1;
 if(dex>60)     y2[sx]=r[i][3]/1;
  if(dex>60)    m2[sx]=r[i][4]/1;
  if(dex>60)    namex[sx]=r[i][7];   
    }
 
 
  number=sx;
 
 
    id="101tK9Che7l-qTQOEAYIZyTanvm4Jqn0O0yftKD3xxVc";
 
 var ex1 = SpreadsheetApp.openById(id);
 var sheet = ex1.getSheetByName("data");
 
 
 yy=1979;
mm=12;
 
for(s=1;s<480;s++){  
mm=mm+1;
if(mm>12)yy=yy+1;
if(mm>12)mm=1;
y[s]=yy;  
m[s]=mm;  
} 
 
 
 
 
 
 
   sheet.getRange(1,1,21,400).clearContent();  
 
 
 
 
 
for(s=1;s<480;s++){  
str=""+y[s]+"年";  
if(m[s]==1)sheet.getRange(1,s).setValue(str); 
}
 
 
  col="red";
 
  for(s=1;s<number+1;s++){
  s1=12*(y1[s]-1980)+m1[s];
  s2=12*(y2[s]-1980)+m2[s];
 if(s1<1)s1=1;
    colx="";  
  if(col=="red")colx="blue";
  if(col=="blue")colx="green";
 if(col=="green")colx="red";
 col=colx;
 sheet.getRange(s+1,s1,1,s2-s1+1).setBackground(col);  
  var cell=sheet.getRange(s+1,s1).setFontSize(20);
   cell.setValue(namex[s]); 
  }
 
 
  for(s=1;s<10;s++){  
sheet.setColumnWidth(s, 50);
}  
 
 
 
}
 
function e8(ee){
  z=0;
   if(ee==728)z=100;
  if(ee==8)z=100;
  if(ee==89)z=100;
 if(ee==78)z=100;
  if(ee==789)z=100;
  return z;
 
}
 
 
 
function e9(ee){
  z=0;
  if(ee==9)z=100;
  if(ee==89)z=100;
 if(ee==910)z=100;
  if(ee==9101)z=100;
   if(ee==789)z=100;
  return z;
 
}
 
function e10(ee){
  z=0;
 
  if(ee==10)z=100;
 if(ee==910)z=100;
  if(ee==103)z=100;
   if(ee==10111)z=100;
  if(ee==1011)z=100;
  return z;
 
}
 
function e101(ee){
  z=0;
   if(ee==101)z=100;
  if(ee==10)z=100;
 if(ee==910)z=100;
   if(ee==9101)z=100; 
  if(ee==1011)z=100;
  return z;
 
}
 
function e102(ee){
  z=0;
  if(ee==10)z=100;
 if(ee==910)z=100;
  if(ee==102)z=100;
  if(ee==10211)z=100;
   if(ee==1011)z=100;
  return z;
 
}
 
 
function e72(ee){
  z=0;
 if(ee==72)z=100;
 if(ee==7)z=100;
  if(ee==627)z=100;
  if(ee==67)z=100;
   if(ee==728)z=100;
   if(ee==78)z=100;
  return z;
 
}
 
 
function e71(ee){
  z=0;
 if(ee==671)z=100;
 if(ee==67)z=100;
 if(ee==627)z=100;
 if(ee==6271)z=100;
 if(ee==71)z=100;
 if(ee==7)z=100;
   if(ee==78)z=100;
 return z;
 
}