a viral growth model (part 2)

Attached is an excel document made up of 2 pages.

The first page is fully coded and works as required, on the second page is what i need doing.

what were doing on the second page is taking the first page one one step further by allowing for new injections of customers at different times throughout the cycle each one therefore starting its own cycle which contributes to the total.

Basically the top part of the second sheet (shown in blue) is the same as that shown on the first sheet, it works using the same formulas and the same input fields as that shown on the first sheet (all shown on the first sheet in deep red so when the formulas change on sheet one they effect the fields on sheet 2, if required it can all appear on one sheet).

The second sheet needs to allow us to add further customers at different stages of the sequence (weve called these customer injections) and they then have their own viral build up which contributes to the total at the bottom in green .

On the second sheet where it says advertising injections, the calculations that are done are again based on the same input fields as that shown on the first sheet in red so when they change the figures here change as well, all except the 'cust' field which needs to be added manually in the red rows for each of the seperate customer injections. There should only be one entry on each of the red rows.

on the first 2 advertising injections shown i have manually done the math for the first few calcualtions and the total at the bottom in green however all of this needs to be automated.

We need to be able to add new 'advertising injections' section by clicking the black button (or something similar) which will work the same as those currently shown.

you can read about how the viral growth model works here:

[url removed, login to view]

Finally we need a new field adding to the first page, this will be called 'cust churn rate' , this will effect each of the column totals.

Kemahiran: Excel

Lihat lagi: viral growth excel, excel viral growth, viral model excel, red red black, math rate, in the red black, build it green, viral growth model part, viral growth model, viral marketing is, viral marketing, new model, math excel, excel model, marketing growth, build excel model, clicking advertising, deep green, model page, page marketing sheet, customer churn, churn, model based excel, excel input required, excel input sheet

Tentang Majikan:
( 115 ulasan ) London, United Kingdom

ID Projek: #1578005

Dianugerahkan kepada:


I have studied your spreadsheet and I am confident I can add the formulas to perform the necessary calculations for injections. I will also write a macro to add additional rows for new injections. I have an excellent b Lagi

$90 USD dalam sehari
(4 Ulasan)

4 pekerja bebas membida secara purata $97 untuk pekerjaan ini


I am an experienced Statistician and data analyst with savvy excel VBA skills

$99 USD dalam 3 hari
(1 Ulasan)

Hi, I am a software engineer by profession and has worked a lot in excel & VBA. There is no excel attached. Please provide the same. Also i went thru the website provided. I feel i can take this project.

$100 USD dalam 5 hari
(0 Ulasan)

I am an expert in Data Entry, MS Power Point, MS Word, MS Excel, MS Access, Web Research, Facebook, Article-Submission, SEO, Link-Building, Forum-Posting, HTML, Adobe-Photoshop, SEM, English, Google-Adsense, Keyword R Lagi

$100 USD dalam 5 hari
(0 Ulasan)