cajunlaroux
New Member
- Joined
- Jun 16, 2020
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
I need assistance with creating a continuous exponential growth curve across two phases in Excel. Here are the specifics:
• Total Duration: 157 days
• Phases:
• Phase 1: January, February, March
• Phase 2: April, May, June
• Overall Goal: 1.6 million units
• Goals by Phase:
• Phase 1: 35% of the overall goal
• Phase 2: 65% of the overall goal
Current Approach:
1. Overall Growth Rate Calculation:
• Cell C1: =1,600,000/SUM(GROWTH(SEQUENCE(157)))
2. Exponential Growth Curve:
• Column A: =SEQUENCE(157)
• Column B: =GROWTH(A1#,,,TRUE)*$C$1
This approach generates a smooth exponential growth curve from day 1 to day 157. However, I need to ensure the curve is continuous between the phases without a dip when transitioning from Phase 1 to Phase 2.
Desired Outcome:
• The goal on the last day of Phase 1 should smoothly transition into the first day of Phase 2.
• Example: If the goal on March 31 (end of Phase 1) is 7,500, the goal on April 1 (start of Phase 2) should logically continue, say 8,500 or 9,000, without dropping.
Challenge:
I need a variable growth rate for each month that respects the overall phase goals:
• Column D in the spreadsheet indicates the percentage of the total goal for each month.
• Column K should sum up to the goals in Column C for each month.
Attached is the Excel file with the initial data and calculations. Any guidance on how to structure this continuous growth curve effectively in Excel would be greatly appreciated.
Thank you
• Total Duration: 157 days
• Phases:
• Phase 1: January, February, March
• Phase 2: April, May, June
• Overall Goal: 1.6 million units
• Goals by Phase:
• Phase 1: 35% of the overall goal
• Phase 2: 65% of the overall goal
Current Approach:
1. Overall Growth Rate Calculation:
• Cell C1: =1,600,000/SUM(GROWTH(SEQUENCE(157)))
2. Exponential Growth Curve:
• Column A: =SEQUENCE(157)
• Column B: =GROWTH(A1#,,,TRUE)*$C$1
This approach generates a smooth exponential growth curve from day 1 to day 157. However, I need to ensure the curve is continuous between the phases without a dip when transitioning from Phase 1 to Phase 2.
Desired Outcome:
• The goal on the last day of Phase 1 should smoothly transition into the first day of Phase 2.
• Example: If the goal on March 31 (end of Phase 1) is 7,500, the goal on April 1 (start of Phase 2) should logically continue, say 8,500 or 9,000, without dropping.
Challenge:
I need a variable growth rate for each month that respects the overall phase goals:
• Column D in the spreadsheet indicates the percentage of the total goal for each month.
• Column K should sum up to the goals in Column C for each month.
Attached is the Excel file with the initial data and calculations. Any guidance on how to structure this continuous growth curve effectively in Excel would be greatly appreciated.
Thank you
