function myFunction() {
  var SpreadSheet = SpreadsheetApp.getActiveSpreadsheet();
  var name = "統計表";
  var sheet = SpreadSheet.getSheetByName(name);
  var Avals = sheet.getRange("A1:A").getValues();
  var Alast = Avals.filter(String).length;
  Logger.log(Alast);
  
  /*抓取TDEE建議工作表裡面的資料*/
  var name_tdee = "TDEE建議";
  var sheet_tdee = SpreadSheet.getSheetByName(name_tdee);
  
  
  /*將資料格式從[[]]轉換成數值*/
  var val_carbs_range = sheet_tdee.getRange(11,7,1,1);
  var val_carbs = val_carbs_range.getValues();
  for (var row in val_carbs){
    for (var col in val_carbs[row]){
      val_carbs = val_carbs[row][col];
    }};
  
  var val_protein_range = sheet_tdee.getRange(9,7,1,1);
  var val_protein = val_protein_range.getValues();
  for (var row in val_protein){
    for (var col in val_protein[row]){
      val_protein = val_protein[row][col];
    }};
  
  var val_fats_range = sheet_tdee.getRange(10,7,1,1);
  var val_fats = val_fats_range.getValues();
  for (var row in val_fats){
    for (var col in val_fats[row]){
      val_fats = val_fats[row][col];
    }};
  
  var val_calories_range = sheet_tdee.getRange(7,11,1,1);
  var val_calories = val_calories_range.getValues();
  for (var row in val_calories){
    for (var col in val_calories[row]){
      val_calories = val_calories[row][col];
    }};
  
  
  
  
  
  /*在樞紐分析表當中進行運算*/
  /*抓取統計表當中的營養素資料*/
  var range = sheet.getRange(Alast,2,1,1);
  var carbs = range.getValues();
  for (var row in carbs){
    for (var col in carbs[row]){
      carbs = carbs[row][col];
    }};
  
  var range_2 = sheet.getRange(Alast,3,1,1);
  var protein = range_2.getValues();
  for (var row in protein){
    for (var col in protein[row]){
      protein = protein[row][col];
    }};
   
  var range_3 = sheet.getRange(Alast,4,1,1);
  var fats = range_3.getValues();
  for (var row in fats){
    for (var col in fats[row]){
      fats = fats[row][col];
    }};
 
  var range_4 = sheet.getRange(Alast,5,1,1);
  var calories = range_4.getValues();
  for (var row in calories){
    for (var col in calories[row]){
      calories = calories[row][col];
    }};
  
  /*進行營養素完成率的計算*/
  var carbs_completion = [[carbs/val_carbs]];
  var carbs_completion_range = sheet.getRange(Alast,6,1,1);
  carbs_completion_range.setValues(carbs_completion);  
  
  
  var protein_completion = [[protein/val_protein]];
  var protein_completion_range = sheet.getRange(Alast,7,1,1);
  protein_completion_range.setValues(protein_completion);
  
  var fats_completion = [[fats/val_fats]];
  var fats_completion_range = sheet.getRange(Alast,8,1,1);
  fats_completion_range.setValues(fats_completion);  
  
  
  var calories_completion = [[calories/val_calories]];
  var calories_completion_range = sheet.getRange(Alast,9,1,1);
  calories_completion_range.setValues(calories_completion);
  
}