Greetings,
I'm a rabbit farmer and want to move from a paper based record system to a excel based one. I have created a excel form which helps capture a newly born litters information.
Litter ID
# of Kits
Cage #
Buck
Doe
Bred date
Born date
What I would like, if possible is to have excel auto create entries for each kit based on the # of Kits entered here. This is to later on enable me to add unique information for each kit like its sex and weekly weighing's.
I'm not exactly sure what the best course of action here is. Wither to have a worksheet that contains all litters and then give each litter there own worksheet and then give each kits there own worksheet to capture weekly weighing's.
Any advice/ideas would be highly appreciated. Thank you.
Hi Gerrit,
Welcome to our forum. The first rule of Excel is to store your data in a tabular layout. When you store it in a tabular layout, the reporting and summarising of the data is easy with PivotTables and formulas.
That would mean having columns for the kit information. For example, your table might have the following column headers:
- Litter ID
- Kit ID
- Cage #
- Buck
- Doe
- Bred Date
- Born Date
- Sex
From the data above you can summarise it to get the number of kits and any other stats you're interested in.
You might then have another table for the weight data:
- Litter ID
- Kit ID
- Date
- Weight
You can then use Power Pivot to summarise the data across the two tables with PivotTables.
I hope that points you in the right direction.
Mynda
