I looked at your file- I take it you want the first sheet completed, using sheet 2 as a guide?
And since you already have some portions completed, are those adequate ?
And you really "just" need the applicable cells in C47:I67 populated with formulas to calculate your subscription counts for each year, tier and projection level (low/base/high)?
There are some other areas I don't quite follow, perhaps they aren't relevant (yet) ... row 10? row 21-29 ?
Are you also looking for a priceType option as used in the sample sheet?
Your deposit is 100% refundable if you decide to withdraw the question. And even after I've provided an answer it is still up to you to decide if it meets your needs. It's a bit of a good faith and honor system based approach.
I'll take anothere look at your new file in the morning to see if I can add any value to the situation.
My apologies,I am out of ideas on this one at the moment.
I am opting out and opening the question up to other professionals here who may be able to help.