search

gbrann / EVEProductionSuite

Eve Online - Production Suite is a set of Google and ESI tools to quickly and easily manage production, budget and basic corporate management with installing servers or adding any RL costs to your game play.
GNU General Public License v3.0
3 stars 0 forks source link

FEATURE: Configuration Setup #3

Closed gbrann closed 6 years ago

gbrann commented 6 years ago

In order to allow an easier setup, I am trying to create a Configuration sheet with all the values needed. In order to pull a cell value into the app script, we can use the following:

// This code uses the Sheets Advanced Service, but for most use cases
// the built-in method SpreadsheetApp.getActiveSpreadsheet()
//     .getRange(range).getValues(values) is more appropriate.
var result = Sheets.Spreadsheets.Values.get(spreadsheetId, range);
var numRows = result.values ? result.values.length : 0;
gbrann commented 6 years ago

Job Cost formula =

=MAX(0,'Corporate Stock'!B33*Configuration!$B$8-Configuration!$D$8+Configuration!$E$8)

Whereas 'Corporate Stock'!B33 is the Corporate Stock location for Est. Value of the item your pulling information on.

gbrann commented 6 years ago

Configuration Page setup for input.