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

Category	Code	Age (months)
Starter	S1	1
Grower	G1	2
Grower	G2	3
Grower	G3	4
Grower	G4	5
Finisher	F1	6
Finisher	F2	7
Finisher	F3	8
Pregnant	P1	9
Pregnant	P2	10
Pregnant	P3	11
Pregnant	P4	12
Lactation	L1	13
Lactation	L2	14

<tbody>
</tbody>

 

[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