Calculates predicted exponential growth by using existing data.
| Name | Type | Description |
| arg1 | ApiRange | Array.<number> | The set of y-values from the y = b*m^x equation, an array or range of positive numbers. |
| arg2 | ApiRange | Array.<number> | An optional set of x-values from the y = b*m^x equation, an array or range of positive numbers that has the same size as the set of y-values. |
| arg3 | ApiRange | Array.<number> | New x-values for which the function will return the corresponding y-values. |
| arg4 | boolean | A logical value: the constant b is calculated normally if this parameter is set to true, and b is set equal to 1 if the parameter is false or omitted. |
builder.CreateFile("xlsx");
const oWorksheet = Api.GetActiveSheet();
// Configure function parameters
var data_array = [1289, 1590, 1652, 1107, 903];
var months_array = [1, 2, 3, 4, 5]
// Set data_array and months_array in cells
for (var i = 0; i < months_array.length; i++) {
oWorksheet.GetRange("A" + (i + 1)).SetValue(months_array[i]);
}
for (var i = 0; i < data_array.length; i++) {
oWorksheet.GetRange("B" + (i + 1)).SetValue(data_array[i]);
oWorksheet.GetRange("B" + (i + 1)).SetNumberFormat("$#,##0.00");
}
// Get the ranges for data_array and bins_array
var data_arrayRange = oWorksheet.GetRange("A1:A5");
var months_arrayRange = oWorksheet.GetRange("B1:B5");
// Get the worksheet function object
var oFunction = Api.GetWorksheetFunction();
// Ensure the ranges are properly passed to the function
var growth = oFunction.GROWTH(data_arrayRange, months_arrayRange);
// Print the growth result
oWorksheet.GetRange("D1").SetValue(growth);
builder.SaveFile("xlsx", "GROWTH.xlsx");
builder.CloseFile();