7-12-2019

function myfunction() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheets()[0];
  sheet.autoResizeColumn(1);
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheets()[0];

sheet.insertColumnAfter(8);
 var ss = SpreadsheetApp.getActiveSpreadsheet();
sheet.getRange('I1').setValue('Absolute Difference');
 var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheets()[0];

var range = sheet.getRange("G2:G");
range.clearContent();
 var range = sheet.getRange("H2:H");
range.clearContent();
 var range = sheet.getRange("L2:L");
range.clearContent();

  var cell = sheet.getRange("I2:I");
cell.setFormula("=Abs(H2)");

   var cell = sheet.getRange("H2:H");
cell.setFormula("=F2-G2");

    var cell = sheet.getRange("L2:L");
cell.setFormula("=G2*J2");
}