Ravi Sir's Cards › Excel
Poultry Farm Management System in Excel (card 2 of 2)
Revision card 2 for Poultry Farm Management System in Excel: Mortality %: =C5/B5 gives 1.5%; Birds in shed: =B5-C5-E5 gives 105; Feed per flock: =SUMIFS('Daily log'!$E$5:$E$3000,'Daily log'!$B$5:$B$3000,A5) gives 19,698.
Read card text
What this card says
2 for Poultry Farm Management System in Excel: Mortality %: =C5/B5 gives 1.5%
Birds in shed: =B5-C5-E5 gives 105
Feed per flock: =SUMIFS('Daily log'!$E$5:$E$3000,'Daily log'!$B$5:$B$3000,A5) gives 19,698.
Learn this in the lesson: Poultry Farm Management System in Excel: Flocks, Daily Deaths and Feed, Bird Sales, Mortality %, FCR and Profit