Hey multiham - if the youtube method doesn't work, a simple rearrangement to your formula might.
In the below, RY1 means Rep Year 1 market share, NY1 means National Year 1 market share. Year 1 is last year, year 2 is current year. Use decimal, so 82% = 0.82
Basically your opportunity-weighted growth times relative market share:
(RY2/RY1)/(1-RY1)) / ( (NY2/NY1)/(1-NY1)) ) * (RY2/NY2)
Using your example, you will get your factor of 2.2. In the negative case, say if the rep went down from 20% to 18%, the growth factor is 0.92 the final factor is 1.65.
Hope this helps -
__________________
Main - Roon on Synology/Sonos Port/SoTM Neo endpoints; Chord Qutest, Bryston BP-17 cubed with phono option; EAT C-sharp with Ortofon Bronze MM, Bryston cubed Amplifier; Revel F126Be on custom Atocha stands; interconnects by WireWorld, furniture by Atocha Design 'Phones Audeze LCD-3, Bryston BHA-1; Office: Sonos/Roon; OPPO HA-1, Naim NAP100 and PSB Mini-C. Media Room:, Samsung QLED QN90 series, Sonos, OPPO 205, ATI N-core driving KEF LS-50's with REL subs; furniture by Glassisimo; Kids - U-turn for vinyl, Sonos Play5; Summer Shack - Sonos, vintage Pioneer, Dynaudio Special 40's.
Last edited by clpetersen; 09-25-2019 at 06:09 AM.
|