Monday, April 18, 2011

yogi_Compute Decreasing Return And Cumulative Sum

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                  

andie856603 said:
o.k row b is the amount of points you received for the very first animal so if i breed 1 african elephant i received 2601 points i enter 1 (animal bred) in row c....d,e,f then calculates how many points i will receive for 2nd 3rd 4th bred.
As i breed more i update c each time d,e,f will change to show points to be gained for next 3 animals bred 
what i would like h to show is the total points i have gained from the total number already bred 
eg if C was 4 (i had bred 4 animals) H would show 7112
hope that clarifies for you 

For the diminishing return with a factor of 0.75 for breeding #2 and subsequent breedings, I used the INDIRECT function to compute the value for successive breedings uto the total number of breedings specified in column C, and the cumulative sum of the value of the breedings in column H