Excel Formulas

Here you can find a list of all the available Excel formulas, descriptions of their inputs, outputs and examples of how to use them.

Each page below follows the same structure: the Formula, worked Examples, the available Inputs (parameters), and a description of the Outputs (returned columns).

Mappings

• Mappings — broker, class group, MGA and controlling body mappings.

Live Analytics

• TFPP Analytics — live, daily-updated policy analytics.
• Pipeline Data — upcoming deals and conversion tracking.
• Bound Data — current-year bound policies.
• Performance vs Plan — actuals against plan.

Reserving

• Reserving Master
• Reserving Events

Triangles

• Triangles — premium, event name and reserving development triangles.

Pinewalk

• Pinewalk — latest month-end Pinewalk data.

Approved Analytics

• TFPP Analytics — month-end, signed-off analytics for external reporting.

Finance

• Latest Plan — plan data owned by the FP&A team.