v4p099 - 経済統計練習帳

function myFunction() {
 
 
var id="1TH71Q-01iqEWty_72lwV6LYFkfXG6VEFoAQBd5r-Di0";
 
 var ex1 = SpreadsheetApp.openById(id);
 var sheet = ex1.getSheetByName("data");
 
 
  var city="";
 
  for(s=4;s<500;s++){  
 
var adr=sheet.getRange(s,3).getValue();
 
if(adr.indexOf("計")>-1)city=adr;
z=0;    
if(adr.indexOf("計")>-1)z=100; 
adr1="東京都";
if(z<50)adr1=city+adr;    
if(z>50)adr1=adr;    
 
adr1=adr1.replace("計","");    
     try {
var geocode = Maps.newGeocoder().geocode(adr1);
var q = geocode.results[0].geometry.location.lat;
var q2 = geocode.results[0].geometry.location.lng
 
}catch(e){q=0;q2=0}
 
 
sheet.getRange(s, 9).setValue(q);
sheet.getRange(s, 10).setValue(q2);
sheet.getRange(s, 11).setValue(adr1);
 
  }
 
}