createLinCombFormula: Create formulas for linear combinations
In vapniks/XLConnectXtra: Convenience Functions For Working With Excel Files

Description Usage Arguments Details Value Author(s)

View source: R/formula_helpers.R

Create formulas for linear combinations of values in columns.

1	createLinCombFormula(vars, coeffvals = NULL, coeffrefs = NULL)

`vars`	A vector of row & column indices or an excel reference string for the region whose columns contain the variables corresponding with the coefficients in coeffs
`coeffs`	vector of coefficients for linear combination or references to worksheet cells containing coefficients

A formula will be created for each row of the area indicated by the vars argument. Each formula has terms which are products the columns of the area indicated by the vars argument with either the corresponding coefficient in the coeffvals argument, or if that is not present then the value in the corresponding cell indicated by the coeffrefs argument. These terms are summed together to produce the final formula.

A character vector containing the linear equations

Ben Veal

vapniks/XLConnectXtra documentation built on May 3, 2019, 4:33 p.m.