Creating Growth Trend from 2 Sets of Values

acfbobcat

New Member
Joined
Aug 20, 2008
Messages
20
Hi,

I'm creating a growth trend with a group of data and I'm stuck trying to find a way to automate this with a formula without manually using trial and error to arrive at the values.

The graph representing the growth trend charts number of man-hours for a department by week from January - December 2013. The sum of man-hours for the year is 22,793.

There are 52 total weeks in the year. The first 34 weeks of the year each have the same value: 431 hours. As of week 35, This leaves 8,139 hours remaining and 18 weeks remaining.

On the 35th week of the year, hours need to begin gradually increasing to finish at the target of 22,793 hours.
Doing this manually, I arrived at the following values for weeks 35 - 52 to get to my target:

Week # & Value:
35 433
36 435
37 437
38 439
39 441
40 443
41 445
42 447
43 449
44 451
45 454
46 457
47 460
48 463
49 466
50 469
51 472
52 478


Is there an excel formula I could have used to get a similar result putting me at a grand total of 22,793 hours and starting at any value more than 431 at week 35? I have about 30 - 40 other graphs I have to apply the same methodology to and I'm hoping to avoid writing all of it manually through trial and error.

Any help would be much appreciated!
-Drew
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,255
Messages
5,769,061
Members
425,515
Latest member
baltusf

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top