NETCUSTADD function

Number of new customers (excl renewals)      Required.    Array.    Number of new customers added; customer renewals, if applicable, are calculated and added automatically. Note: By default, this function will return a row of values for the same number of columns that you select for this input. Please make sure that adjacent cells do not have any other content. Add the month_numner input in this function if you need this value for a specific month (and not for all months).

Contract_term_#months      Required.    Number.    Contract term (in months); default value=1 (which is month to month); enter 12 for annual subscription, or any other value if term is different; enter 0 if non recurring; must be integer >=0

PrePmt_term_#months      Required.    Number.    # months for which customer prepays; default value=1 (which is month to month); enter 12 for annual subscription, or any other value if term is different; enter 0 if non recurring; must be integer >=0

Churn_percent      Required.    Number/Array.    Churn % (applied at renewal); default value=0%; must be>=0

Installed base (number of customers)      Required.    Number.    Number of existing (installed base) customers renewing subscription

Installed base renewal options      REQUIRED.    Refer table.     Select if you'll specify number of renewals or split equally for renewal duration

Number of existing customers renewing (by month)      Optional(based on Ins base renewal option).    Array.    Specify renewals by month if you selected that option. (If Installed base renewal options="Enter number of installed base renewals by month" then input for Number of existing customers renewing (by month) is required (otherwise it is not required, and won't be used);)

Are_terms_same_for_renewals      Optional.    TRUE/FALSE (1/0).    Are contract and prepayment terms same for renewals? TRUE=Yes., FALSE=No; default=TRUE

Contract_term_#months_renewal      Optional.    Number.    Contract term (in months); default value=1 (which is month to month); enter 12 for annual subscription, or any other value if term is different; enter 0 if non recurring; must be integer >=0

PrePmt_term_#months_renewal      Optional.    Number.    # months for which customer prepays for renewals, if different from term at signing; default value=1 (which is month to month); enter 12 for annual subscription, or any other value if term is different; enter 0 if non recurring; must be integer >=0

Month_number      Optional.    Number.    Month for which this value is required. Leave this blank (no input) if you need values for the same number of months as the input array. Input value must be integer >=1. For example, enter 6 if you'd like this value for month 6. Note: value will be returned for specified month only if you enter a value.