5g: Corkscrewλ()

Description

Corkscrewλ() Creates a corkscrew section. A "corkscrew account" is named so because the way its balance is calculated resembles the twisting motion of a corkscrew, where the ending balance of one period becomes the starting balance for the next period, creating a continuous, winding pattern in the data when visualized; essentially, the balance "rolls forward" like a corkscrew does when inserted into a bottle.

Syntax

Corkscrewλ( Opening, FLow1, [Flow2], [Flow3], [Flow4], [PositiveOnly])

Arguments:

Opening
(Required) First period's opening balance.

Flow1
(Required) First row (or array of rows) of numbers to include in period totals.

Flow2
(Required) Second row (or array of rows) of numbers to include in period totals.

Flow3
(Optional) Third row (or array of rows) of numbers to include in period totals.

Flow4
(Optional) fourth row (or array of rows) of numbers to include in period totals.

PositiveOnly
(Optional) TRUE = display flows as positive values. Default is FALSE.

NOTE! All flows are added. To subtract a flow make it negative. If it is desired that all values should be displayed as positive values set PositiveOnly to TRUE.

Example

A facility we wish to use for a once-a-week sales event says they have availability between August 29th and September 22nd. We know Friday, Saturday, and Sunday events are poorly attended. Which day of the remaining days of the week will give us the most opportunities to hold our events?

Page updated

Google Sites

Report abuse