Having difficulty understanding your excel document.
Could you please let me know what are the input fields you require and the values they should accept
Secondly could you please list the calculation that need to be done on the input fields to give the required answer.
and an example of how you would like the answer displayed.
This should be pretty straightforward so as soon as you can help me with the above answers I can get this sorted out for you
Quick question before i go ahead and take a look at this?
Are the packages variable or fixed (i.e. can new ones come online and old ones go on a relatively regular basis?)
Hi Khalid, thanks once again.
The inputs fields are those highlighted in red. I want inputs for quota as well as input for subscriber count
The quota field can be derived from the table and is fixed per plan. If I filter by plan and the quota on that plan is say 250gig I want to see how their overage and other metrics change if the quota was to go up to 400 gig.
* subscribers = countD(mac ids
Avg Overage Fee = Total overage fee/ Total subs impacted
Monthly Initial ARPU Impact = Total overage fee/ Total actual subs
% Subs Impacted = Total subs impacted/Total actual subs
*Total subs = user input for anticipated number of subscribers
Total $$ Impact:( anticipated number of subs/ actual subs) * total overage fee
$$ Overage Fee per Usage Increment >Quota: $ 10.00 Usage Increment per Overage Fee (GB): 50
*The overage fee per usage increment is fixed at $10 and usage increment per GB is set at 50G
Thank you. I appreciate the help
Hi Chris, I hope the information i added above answers your questions. I appreciate the help
Can you please create all required input fields as parameters in your workbook and re attach. and I can help you get the calculations as you require.
Unfortunately I don't have a lot of time today as I have a few deadlines so a little assistance from you would be appreciated