| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | |||||||||||||||||||
2 | XA METRICS | YEAR | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | BACKUP | ||||||
3 | Staff replication | 1.00 | TOTAL students | 20.5 | 38.3 | 57.4 | 78.2 | 100.8 | 125.4 | 152.0 | 182.4 | 216.6 | 254.9 | 1.00 | |||||
4 | Student replication % | 0.75 | Replication | 0.95 | 0.85 | 0.80 | 0.78 | 0.76 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.50 | |||||
5 | Student longevity % | 0.50 | 2.0 | yrs -> | Longevity | 2.0 | 2.0 | 2.0 | 2.0 | 2.0 | 2.0 | 2.0 | 2.0 | 2.0 | 2.0 | 0.50 | |||
6 | Initial SGL students | 1 | SGL students | 1.0 | 5.1 | 9.6 | 14.4 | 19.6 | 25.2 | 31.4 | 38.3 | 46.2 | 55.0 | 0 | |||||
7 | Initial total staff | 4 | TOTAL staff | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 5 | |||||
8 | Average SG members | 4 | SGL staff↵ | 3.9 | 3.2 | 2.4 | 1.6 | 0.8 | -0.2 | -1.2 | -2.3 | -3.6 | -5.1 | 4 | |||||
9 | Average RG members | 8 | RG staff | 0.1 | 0.6 | 1.2 | 1.8 | 2.4 | 3.2 | 3.9 | 4.8 | 5.8 | 6.9 | 8 | |||||
10 | Initial support staff | 0 | Support staff | 0.0 | 0.2 | 0.4 | 0.6 | 0.8 | 1.0 | 1.3 | 1.5 | 1.8 | 2.2 | 0 | |||||
11 | Intern % of students | 2% | Likely CMIT | 0.4 | 0.8 | 1.1 | 1.6 | 2.0 | 2.5 | 3.0 | 3.6 | 4.3 | 5.1 | 0.00 | |||||
12 | Admin support size | 100 | Internship | 100 | |||||||||||||||
13 | RGL effectiveness drop | 0% | Added staff | 0.00 | |||||||||||||||
14 | . 10 total leaders this year, 5 new student leaders produced = 50% replication, or 0.5 produced per leader | Student:staff ratio | 5.1 | 9.6 | 14.4 | 19.6 | 25.2 | 31.4 | 38.0 | 45.6 | 54.2 | 63.7 | |||||||
15 | . 10 student leaders this year, 2 continue next year = 20% longevity, or 0.2 leaders are continuing | REPLICATION: From small group leaders starting the year (staff + students), how many student leaders does each produce for next year? LONGEVITY: From small group leaders starting the year (students), how many continue next year? SG MEMBERS: How many small group members per small group leader? RG MEMBERS: How many resource group members per resource leader? ADMIN SUPPORT SIZE: For how many students is 1 staff needed in non-small group ministry? RG EFFECTIVENESS DROP: What is the % drop in replication for Resource groups led by students? INTERN % OF STUDENTS: What is the % of the student body who are interns? | SGL:staff ratio | 0.3 | 1.3 | 2.4 | 3.6 | 4.9 | 6.3 | 7.8 | 9.6 | 11.5 | 13.8 | ||||||
16 | TIPS - Set zoom and hide top menu to view full screen. - See the Notes tab for help topics & contact info. - Set up a call with Dan to gain insight on using this tool. | ||||||||||||||||||
17 | |||||||||||||||||||
18 | |||||||||||||||||||
19 | |||||||||||||||||||
20 | |||||||||||||||||||
21 | |||||||||||||||||||
22 | |||||||||||||||||||
23 | |||||||||||||||||||
24 | |||||||||||||||||||
25 | |||||||||||||||||||
26 | |||||||||||||||||||
27 | |||||||||||||||||||
28 | |||||||||||||||||||
29 | ADVANCED | ||||||||||||||||||
30 | Hide all | ||||||||||||||||||
31 | |||||||||||||||||||