Hello AT Community! Today I am bringing you my biggest challenge yet! I have been banging my head over this for two days and I cannot make heads nor tails of it lol - I'm hoping you guys can give me some possible solutions to make this work! Here's the situation:
An organization has staff members and volunteers. They want to be able to record and project their staff and volunteer growth. They track these metrics:
- # Staff
- Staff Longevity
- Staff Replication Rate
- # Volunteers
- Volunteer Longevity
- Volunteer Replication Rate
Let's just focus on volunteers for simplicity! In Year 1, they start with 0 volunteers. Staff recruit volunteers and by Year 2, they have 5 volunteers. Those volunteers will serve an average of 2 years before moving on. In one year, roughly half of their volunteers will recruit a new volunteer. So in Year 2, our 5 volunteers will recruit 2.5 more volunteers. Year 3 starts with 7.5 volunteers and adds 3.75 more. Year 4 starts with 11.3 volunteers, they add 5.6 new volunteers... but the 5 volunteers who started in Year 2 have served their 2 years, so they're leaving. So they will start year 5 with 11.9. Here's a visual chart to help make this clear:
So, the question is... can this be done in AT when we can't reference "the record above," etc???
I'm excited to see what you guys come up with! TIA!
