Egg Collection Calculation Sheet

Dear All,
I have a spreadsheet where I am calculating all the collections of eggs given by hen. I do it manually based on below scenario:

• When I purchase the hen it start egg after 7 days.
• Once hen started to give egg it give for 7 days, and again restart giving of egg after 20 days and give it for 7 days.

The above chain continue for long period.

I am attaching the excel file how I do it manually and in another sheet I put the desired output.

Any expert can help me on it, it'll be great.

Thanks in advance.

Best regards,
Shahid

Hi
Use in a new sheet range A2 the following formula

Formula:

Please Login or Register  to view this content.

extend the formula to A2:AE144 (or other)
In AF2 use =SUM(A2:AE2)
Note: Your output has a error from day 59...

See the file

Dear Jose,
Thanks for your help, getting the output what i want.


Best regards,
Shahid

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

got it for next time.