Yogi Anand, D.Eng, P.E. Google Spreadsheet www.energyefficientbuild.com
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
No comments:
Post a Comment