Hierarchy Chart for a 1 x 2 matrix direct sell company possible in Excel?

matthewlopez1974

New Member
Joined
Jul 19, 2014
Messages
2
I am brand new to the forum and am no expert at excel. I have a MAC Excel 2011 program to work with. I have created a direct selling model that pays commissions based on percentages of sales. I also have partner companies I am working with plus the product distributor. The partner companies (2) take 15% of revenue each. The direct selling employees/contractors percentages vary depending on their selling volume. It is a complex chart I am seeking to build but I believe excel can do it, am I right? and if so, where can I find how to build it ie; tutorials, videos or chat forums such as this? Thank You.
The matrix is a 1 x 2 system that goes 20 levels deep. There are three matrixes; 1.) 25.00 2.) 50.00 3.) 100.00. I hope that helps and please ask any questions for information I may have left out for a clearer answer. thanks
matt
 

Some videos you may like

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

matthewlopez1974

New Member
Joined
Jul 19, 2014
Messages
2
Hi there, maybe posting an actual sample of your data and what you would like to achieve would trigger more replies.
You can post sample as follows:
Recommendation being to use the last one (Border Copy-paste) since you are using Excel 2011.

Excel jeanie
or
MrExcel HTML Maker (HtmlMakeryyyymmdd)
or
Borders-Copy-Paste

ok, so I do not have a sample, per say, but i can tell you that i am creating a hierarchy tree. Starting with myself in the number 1 spot, line 1. I have 2 people under me on line 2, those 2 people each have 2 people on line 3 (7 total people...1 on line 1, 2 on line 2, 4 on line 3 etc etc. Each one of those people will spend x amount of dollars per month on product sales. Each one of those people will earn a set commission percentage on product sales of the people below them (line 2 makes their commission from line 3 and line 3 from line 4). There could be a number of variable such as volume of product sales, attrition and faster growing legs vs slower. The only variable I would like to plug in would be sales volume. I call it the trickle effect; example...spot 30 on line 17 makes 7000 in sales, how does that commission change for the person directly above spot 30/line 17? I need it 20 levels deep on a 1 by 2 ,matrix formula.
I am hoping this makes sense to someone. It makes perfect sense to me, but that doesnt help unless i can build it. thanks
 

cyrilbrd

Well-known Member
Joined
Feb 2, 2012
Messages
4,071
Office Version
365
Platform
Windows, Mobile
If you know the percentages take would be applied from on level to another (not mentioned in your sample)
would the two person in level two get a commission from all members from level 3 or only from their respective subordinates in level 3?
Arranging your data in a table might be easier, level could be identified with a value (1,2,3...) and commission computed by summing the values directly one level below and factored by a specific coefficient related to whatever criteria you may have.
Does this make sense to you?
 

Watch MrExcel Video

Forum statistics

Threads
1,095,230
Messages
5,443,233
Members
405,219
Latest member
CraneS

This Week's Hot Topics

  • Copy entire row if CountA <>0 to another sheet
    [B]I want to copy entire row if CountA <>0 for column J7:AM7 (headers on J6:AM6) and so on till the last used cell is column D and paste the...
  • Select last used Row in Table
    I have created a Table in a Worksheet which is locked to prevent user errors and protect formula. Some of the cells require freetext entries which...
  • excel workbook: do not allow certain file name
    Hello all, Don't think this has ever been asked before, but how do I restrict file save [Before_Save Event] if the name of the file being saved...
  • fixing problem autofilter
    hello i need help about my code when i search by code in textbox it doesn't show anything this is my data [ATTACH type="full"...
  • “Weight”
    Hi, i’ve got a long sheet filled with weights such as kg,g,L & ml. i can build a formula to convert kg into g and liter into ml. How ever, my...
  • How to capitalize everything before a certain character?
    In column A, I have some text: Hello good day.mp3 Hello good day.flac etc. I'd like to capitalize everything before the period. I don't need the...
Top