Overview
Membership: recorded and forecast
Members at each year end. Drag across the chart to zoom, double-click to reset.
What the record shows
Drawn from this lodge's own register
Joined and left, by five-year period
Members gained above the line, members lost below
History
New members against members lost
Count of members per period, with the net change as a line. Select legend items to hide or show them.
Members at year end
Subscribing and honorary members on the register
Average age of members
Mean age in years at each year end
Decade by decade
The same figures as a table
Forecast and what-if
Pick a scenario or move the sliders. Every chart on the site updates at once. Pin a scenario to keep it on the chart while you try another.
Members at year end
The gold band is the range a lodge this size lands in four times out of five. Drag to zoom.
Expected joiners and leavers each year
Recorded years to the left, your scenario to the right. Forecast values are averages, so they are not whole numbers.
How the scenario gets there
Members added and lost across the forecast
Scenarios side by side
Members and average age at points along the forecast
Age and mortality
How old the membership is, how that changes under your scenario, and the deaths to expect when mortality rates for men in the North East of England are applied to each member's age.
Average age: recorded and forecast
Mean age of members in years
Age profile
Members in each age band. Move the slider or press play.
Deaths: recorded, and expected from North East mortality
Deaths per year. Bars to the left are deaths on the register; the line and the forecast bars are what the mortality table predicts for the members' ages.
Chance of dying within a year, by age
Men, per cent, on a regular scale
Where the mortality rates come from
Life expectancy at birth for men in the North East was 77.4 years in 2021 to 2023, against 79.1 for England (ONS).
The model uses a table of yearly death rates for men in England in 2020 to 2022, raised by 17% at every age. That uplift reproduces the 1.7-year gap. The England rates are an approximation of the ONS national life table, anchored every five years of age, so treat single-year figures as close rather than exact.
Rates fall by 1% a year by default, in line with long-run improvement. Change the table, the improvement or the lodge adjustment under Assumptions on the forecast tab.
New members
How old new members are, how long they stay, and how many the lodge needs each year to hold its numbers.
Age at initiation
Each dot is one initiate; the line is the average of the surrounding ten years
How long initiates stay
Share still in membership by years since initiation. Deaths are not counted as leaving.
Years of membership a new member brings
Expected years before resignation, cessation or death, by age at joining
The register is too small to measure whether younger joiners resign faster, so the curve reflects mortality and the lodge-wide leaving rates only.
The wider picture
National and regional trends, set against this lodge
Data and method
Load a different register, check what the model read, and see how each figure is worked out.
Load your own data
Excel or CSV with the same columns as the sample. The file is read in your browser and is not uploaded.
Drop a file here, or
Needs Ugle_Ref_No, Join_Type, JoinDate, Status_Desc and StatusDate. DOB, Lodge_or_Chapter_No and Lodge_Or_Chap_Name are used when present.