← Back to projects
Kostenlos · 14 days to submit
Hudson Trout Model
Model trout populations over time in Excel, with drop-down lists and charts.
This project is not translated into your language yet: the instructions stay in English.
The trout project walks you through the process of taking a large data file and turning it into a usable Excel model and dashboard, complete with graphs and drop-down menu selections. It models the number of trout in the waterways of New York over time.
SkillsDie Funktion WENNDrop-Down ListsDie Funktion SUMMEWENNSTastenkombinationen zum Markieren von ZellenDie Funktionen UND, ODER und XODER
▶ Watch the videoPremium project
Log in or create an account to start a project and follow your progress.
How you are graded
Each project is graded out of 100; you need 70 points to pass. Some criteria are checked automatically in your workbook, the rest are judged by the AI.
- Yearly modelAutomaticOne row per year from 2025 to 2055.10 pts
- Starting populationsAutomaticThe 2025 populations of Brown Trout and Rainbow Trout in the Hudson River come from the Data tab.10 pts
- SUMIFS for the starting valuesAutomaticThe starting populations are calculated with SUMIFS, not typed in.10 pts
- Population growth modelAutomaticBoth species grow each year, with the construction projects and the fishing rate applied.15 pts
- Collapse warningsAutomaticAn IF with OR flags a collapse below 5,000 for either species or above 50,000 in total.10 pts
- Drop-down inputsAutomaticDrop-down lists choose the fishing rate and the growth rates (0 to 10 %).10 pts
- ChartAutomaticA chart shows the populations of both species.5 pts
- Answers to the questionsAutomaticThe two fishing rates you entered are the right ones.15 pts
- Clarity of the modelAIClear labels, assumptions kept apart from the calculations, readable chart, helpful notes.15 pts