This content has been marked as final.
Show 2 replies

1. Re: What if Scenario...what is the optimal size of firstthird year courses to support fourth year courses with 20 students?
Joe Mako Jan 25, 2012 9:53 PM (in response to Melissa Schuurman)How about the attached?
Using the formula:
PREVIOUS_VALUE(SUM([Number of Courses])*[Target Class Size])*(1ZN(SUM([Attrition Rate])))
with an Advanced Compute using to sort the Years in reverse.

enrolment_what_if.twbx 72.9 KB


2. Re: What if Scenario...what is the optimal size of firstthird year courses to support fourth year courses with 20 students?
Melissa Schuurman Jan 26, 2012 1:41 PM (in response to Melissa Schuurman)Thank you for your help.
After much trial and error, we were able to come up with a similar formula that seems to be working, as well as set parameters for attrition rates so in the future, our departments can change the percentages if needed.
Again, thank you!