exponenital growth of referred users

excel_mutt

New Member
Joined
Nov 9, 2008
Messages
1
Hi everyone,

I am building a financial model that relies on referrals from current users to drive traffic to the site. In other words, when we sign up a new client, over the course of the next 10 days they will refer 5 other people. Of those 5 people, a % sign up and over the course of the next 10 days, each refers another 5 people and so on.

1. It is a 5 year model
2. I need to be able to see the total number of users on any given day and measure the total users for each reporting period (monthly and yearly).
3. I have an assumption page, so the formulas would need to reference back to it. It is here that I will change the number of days (10 in the above example) and number of referrals per user (5 in the above example) and the percentage of conversion from the traffic to an actual user.

What I did so far was to create a 5 year log and start the multiplication process.... This was far off! what happens is without the time variable, I'm just multiplying the number of users times the number of referrals each day and it's growth is unrealistic.

So my question is; is it possible to measure this growth rate with variable inputs like time and referrals? If so, how?

Thanks
 

Beezkneez

Board Regular
Joined
Oct 23, 2008
Messages
123
This looks like a mighty big project for you. I can conceptually see how you could get it working, depending on your assumptions.
Assume that everyone sends out their referral invites on day 5. If you try and project that a % will send them on day 1, another % on day 2 etc - my brain explodes.

Set a For Next loop to iterate through the number of days you want to cover. Setting a start date as a parameter also wouldnt hurt.

During the loop, store 7 variables.
varBrandNewUser
varNewUserday1
varNewUserday2
varNewUserday3
varNewUserday4
varnewUserday5
varOldUsers

Each loop (representing one day), however many users are parked in varnewUserday5 have the take up % applied to them (rounded) and that number becomes BrandNewUser.

Sum all the variables for the total # of users on that day and output it along with the date being the Startdate + loop variable.

Add varnewUserday5 to varOldUsers. These guys no longer give referrals.
Add varNewUserday4 to varNewUserday5,
Add varnewUserday3 to varnewUserday4.... etc
Add varBrandNewUser to VarNewUserDay1

Next Loop

Hope that gets you started.
 

Forum statistics

Threads
1,081,929
Messages
5,362,182
Members
400,671
Latest member
Tommy00836

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top