Please enable JavaScript to view this site.

Vensim Help

Navigation: Reference Guide > Functions > Lookups

LOOKUP AREA(lookup,start,end) AREA under a LOOKUP table

Scroll Prev Top Next More

Returns the area under a Lookup table between start and end.  This is useful for normalizing lookups in problems such as determining the intensity of effort in a project given the fraction of work that has been completed.

Units: LOOKUP AREA(units1,units2,units2) --> units1 * units2

Start and end must have the same units and the units of the Lookup times the units of the input are returned.

Example

LOOK((0,1),(1,1),(2,2))

LOOKUP AREA(LOOK,0,1) is equal to 1.0

LOOKUP AREA(LOOK,2,4) is equal to 4.0

LOOKUP AREA(LOOK,.5,2.5) is equal to 3.0

Availability: Not PLE or PLE Plus.

See also: LOOKUP SLOPE, VECTOR LOOKUP, Lookups

Sample model: LOOKUP functions.mdl in FunctionExamples