website calculator I need on desktop

***Massblack*** · 09-02-2018, 10:17 AM

Hi all can anyone get this calculator off this site in any usable offline format (ex. excel)?

Site:

Magic Button :

Much thanks
MassBlack

***feefiefohfum*** · 09-03-2018, 01:07 AM

After some copy paste, search and replace, here is the next best thing (if you are okay to do the calculations manually):

Have the following inputs:

Code:

SubscriptionCost, NumberOfSubscribers, CampaignsPerMonth, AverageReadRate, EstimatedResponseRate, AverageSpend

Use the following formulae to get the results:

Code:

NumberOfSMSTextReaders = (NumberOfSubscribers * CampaignsPerMonth * (AverageReadRate / 100))

CostPerSMSReaders = SubscriptionCost / (NumberOfSubscribers * CampaignsPerMonth * (AverageReadRate / 100))

NumberOfSMSTextResponders = (NumberOfSubscribers * CampaignsPerMonth * (AverageReadRate / 100) * (EstimatedResponseRate / 100))

CostPerSMSTextResponders =  SubscriptionCost / (NumberOfSubscribers * CampaignsPerMonth * (AverageReadRate / 100) * (EstimatedResponseRate / 100))

EstimatedTotalRevenue = (NumberOfSubscribers * CampaignsPerMonth * (AverageReadRate / 100) * (EstimatedResponseRate / 100)* AverageSpend)

CostPerSMSText =  SubscriptionCost / (NumberOfSubscribers * CampaignsPerMonth)

EstimatedTotalProfit = (NumberOfSubscribers * CampaignsPerMonth * (AverageReadRate / 100) * (EstimatedResponseRate / 100) * AverageSpend) - SubscriptionCost

ReturnOnInvestment = ((EstimatedTotalProfit - SubscriptionCost)/SubscriptionCost) * 100

Cheers,
FFFF

***Massblack*** · 09-04-2018, 07:58 AM

Thank you Mate,
I will have my girl put this in a excel sheet ..
MaxReps
MassBlack

(09-03-2018 01:07 AM)feefiefohfum Wrote: After some copy paste, search and replace, here is the next best thing (if you are okay to do the calculations manually):

Have the following inputs:

Code:

SubscriptionCost, NumberOfSubscribers, CampaignsPerMonth, AverageReadRate, EstimatedResponseRate, AverageSpend

Use the following formulae to get the results:

Code:

NumberOfSMSTextReaders = (NumberOfSubscribers * CampaignsPerMonth * (AverageReadRate / 100)) CostPerSMSReaders = SubscriptionCost / (NumberOfSubscribers * CampaignsPerMonth * (AverageReadRate / 100)) NumberOfSMSTextResponders = (NumberOfSubscribers * CampaignsPerMonth * (AverageReadRate / 100) * (EstimatedResponseRate / 100)) CostPerSMSTextResponders = SubscriptionCost / (NumberOfSubscribers * CampaignsPerMonth * (AverageReadRate / 100) * (EstimatedResponseRate / 100)) EstimatedTotalRevenue = (NumberOfSubscribers * CampaignsPerMonth * (AverageReadRate / 100) * (EstimatedResponseRate / 100)* AverageSpend) CostPerSMSText = SubscriptionCost / (NumberOfSubscribers * CampaignsPerMonth) EstimatedTotalProfit = (NumberOfSubscribers * CampaignsPerMonth * (AverageReadRate / 100) * (EstimatedResponseRate / 100) * AverageSpend) - SubscriptionCost ReturnOnInvestment = ((EstimatedTotalProfit - SubscriptionCost)/SubscriptionCost) * 100

Cheers,
FFFF

***feefiefohfum*** · 09-04-2018, 06:08 PM

You are welcome, Massblack!

Cheers,
FFFF