Matrix Spreadsheet
I have a 9×5 forced matrix. It pays 9 across 5 levels deep. Level 1 pays $2 per person. I can have no more than 9 people on my first level. Levels 2-5 pays $1.25 per person. Each person can have no more than 9 people on their first level. The maximum earned is $83,043.00. The number of people need to completely fill my personal matrix is
66,429. I want to fill it in 24 months or less. I need an Excel or Microsoft Works spreadsheet that shows the following:
1. How long it would take to fill the matrix if I recruited 1 person every 15 days and my recruits did the same. I need this broken down, detailed. But I would need formulas so I can change the number of people recruited to 3 or 4 or whatever and also the number of days.
2. How much I would make from each person recruited at the end of each 15 day cycle on each level. I also need this broken down, detailed.
For example, at the end of 15 days, I will have recruited 1 person on my 1st level. I earned $2. At the end of 30 days, I will have recruited a total of 2 people ($4) and my level 1 person would have recruited 1 person. ($1.25. Total earned $5.25). At the end of 45 days, I will have recruited a total of 3 people ($6) and my original level 1 person would have recruited 2 people ($2.50) and their level 2, which would be my level 3 would have recruited 1? (ok, my brain pretty much shuts down after level 2). What comes next?
I hope I have explained this clearly.
Thank you.
