| 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.0 | 45.7 | 74.0 | 101.3 | 126.5 | 149.8 | 171.4 | 191.7 | 210.4 | 228.2 | 1.00 | |||||
4 | Student replication % | 0.60 | Replication | 1.00 | 0.80 | 0.73 | 0.68 | 0.65 | 0.63 | 0.62 | 0.61 | 0.60 | 0.60 | 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 | 0 | SGL students | 0.0 | 5.0 | 10.7 | 16.9 | 22.8 | 28.2 | 33.2 | 37.9 | 42.2 | 46.3 | 0 | |||||
7 | Initial total staff | 5 | TOTAL staff | 5 | 6 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 5 | |||||
8 | Average SG members | 4 | SGL staff↵ | 5.0 | 5.2 | 5.2 | 4.2 | 3.2 | 2.2 | 1.3 | 0.6 | -0.2 | -0.9 | 4 | |||||
9 | Average RG members | 8 | RG staff | 0.0 | 0.6 | 1.3 | 2.1 | 2.8 | 3.5 | 4.2 | 4.7 | 5.3 | 5.8 | 8 | |||||
10 | Initial support staff | 0 | Support staff | 0.0 | 0.2 | 0.5 | 0.7 | 1.0 | 1.3 | 1.5 | 1.7 | 1.9 | 2.1 | 0 | |||||
11 | Intern % of students | 2% | Likely CMIT | 0.4 | 0.9 | 1.5 | 2.0 | 2.5 | 3.0 | 3.4 | 3.8 | 4.2 | 4.6 | 0.00 | |||||
12 | Admin support size | 100 | Internship | 100 | |||||||||||||||
13 | RGL effectiveness drop | 0% | Added staff | 1 | 1 | 0.00 | |||||||||||||
14 | . 10 total leaders this year, 5 new student leaders produced = 50% replication, or 0.5 produced per leader | Student:staff ratio | 4.0 | 7.6 | 10.6 | 14.5 | 18.1 | 21.4 | 24.5 | 27.4 | 30.1 | 32.6 | |||||||
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.0 | 0.8 | 1.5 | 2.4 | 3.3 | 4.0 | 4.7 | 5.4 | 6.0 | 6.6 | ||||||
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 | |||||||||||||||||||