5.2 Input data sheets
5.2.1 Invertebrate data sheet
Missing taxa added
After running the model, you may see on the bug data sheet that the invertebrate data has been modified where necessary to contain all taxa codes required by the model. These added taxa all have a value of 0.0 indicating absence of the taxa. The screen shots below show the Invertebrate data sheet before running the model, and then after running the model where missing taxa such as KG029999 have been added.
Unused taxa moved to 'Unused Bugs' sheet
After the model has run, any taxa in your bug data file that were not required by the model have now been moved to the "Unused Bugs" sheet. NOTE: these taxa no longer exist in the Invertebrate sheet.
Data ordered
After you have run a model, your invertebrate data will be ordered alphabetically by taxon names. An example below (in Section 5.2.2) shows the phys/chem data sheet before and after a model has been run.
Presence/absence highlighting
You will see on the bug data sheet that all invertebrate data are colour coded, with presences highlighted in green and absences highlighted in white. This highlighting is actually done when you enter data rather than after the model is run, but is included here for completeness.
Data ordered
After you have run a model, your phys/chem data will be ordered alphabetically by variable name. Phys/chem data are also ordered, and the examples below show the phys/chem data sheet before and after a model has been run.
Presence/absence highlighting
The phys/chem data also highlighted to indicate presence/absence. Zero values are highlighted in white, while non-zero values are shown as green.