title: After duplicating a sheet, remove formulas and retain values/formats
body: <p>I have a sheet "SourceData" that has a lot of formulas to develop a proposal price based on variables entered on the sheet "Inputs". I need script to generateNewScope, where the "SourceData" sheet is duplicated, formulas removed from the duplicate, and it's renamed from "Copy of SourceData" to 1, then 2, then 3, etc.</p>
  
  <p>I'm close! I can duplicate and rename, and I've gotten a different script to the point where it removes the formulas, but that one removed formulas from both "SourceData" AND "1". I just need to add additional actions here that essentially copy/paste values only directly in the same spot, or just a remove formulas action.</p>
  
  <pre><code>function generateNewScope() {
      ss = SpreadsheetApp.getActiveSpreadsheet();
      ss.setActiveSheet(ss.getSheetByName("SourceData"));
      var ns = ss.duplicateActiveSheet(),
      allSheets = ss.getSheets();
      ns.setName(allSheets.length - 4);
  }
  </code></pre>