Displaying next value in a list and resetting it to particular value

[techiee]

Dear All,

Have a excel formula query.

Background:

I am trying to analyse go-to market study for a commercial animal farm.

Referring to Table below : So suppose I select S1 (Small animal phase) it will follow its lifecycle till L2 (Lactation) and then it will get reset to P1 (Pregnancy month 1) and depending on its age its fodder requirement will change

As an another example, if I start the project with G2 stage, it will follow the lifecycle from G3 to L2 and then be ready for breeding again (stage P1)

Query:
I am now trying create a month wise P&L, in a different worksheet, from the starting lifecycle of the animal (input)
I am not able to dynamically change the follow on values of its lifecyle in the following months AND reset it to P1 after L2
stage.

Pls help guys.

Table
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Category[/TD]
[TD]Code[/TD]
[TD]Age (months)[/TD]
[/TR]
[TR]
[TD]Starter[/TD]
[TD]S1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Grower[/TD]
[TD]G1[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Grower[/TD]
[TD]G2[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]Grower[/TD]
[TD]G3[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Grower[/TD]
[TD]G4[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Finisher[/TD]
[TD]F1[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]Finisher[/TD]
[TD]F2[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]Finisher[/TD]
[TD]F3[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]Pregnant[/TD]
[TD]P1[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]Pregnant[/TD]
[TD]P2[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]Pregnant[/TD]
[TD]P3[/TD]
[TD]11[/TD]
[/TR]
[TR]
[TD]Pregnant[/TD]
[TD]P4[/TD]
[TD]12[/TD]
[/TR]
[TR]
[TD]Lactation[/TD]
[TD]L1[/TD]
[TD]13[/TD]
[/TR]
[TR]
[TD]Lactation[/TD]
[TD]L2[/TD]
[TD]14[/TD]
[/TR]
</tbody>[/TABLE]

 

[samdthompson]

Hello, have made a possible solution. I know from my own work that its sometimes best not to revert straight from the lactation back to the pregnant stage P&L wise since you can end up hiding dry's amongst the pregnant classification. It might be worthwhile adding in the concept of dry's or are they immediately sent for processing so not a problem?

Cheers,

Sam

 

[Peter_SSs]

Hello, have made a possible solution.

Sam, I understand that you are new here, but please do not answer questions in this manner. Refer to #4 of the Forum Rules