Log In
Register
Home
Seed database in Excel
Kasey Morris
Member
Members
Forum Posts: 19
Member Since:
April 6, 2022
April 6, 2022
Offline1
August 13, 2023 - 9:21 pm
Hi
I have an abundance of seed packets, 50+. I'd like a database so I can easily see when to SOW, PLANT or HARVEST.
I don't know how to design it so I can filter on a month to see what can be done that month. See attached image,
SOW = Jan Feb Mar Apr
PLANT = Apr May Jun
HARVEST = Jul Aug Sep Oct
Thanks so much in advance.
See Answer
Mynda Treacy
Admin
Forum Posts: 4782
Member Since:
July 16, 2010
July 16, 2010
Offline2
August 14, 2023 - 9:10 am
Hi Kasey,
Your spreadsheet should have 3 columns:
- Plant Type (tomato, beans, corn etc.)
- Task (sow, plant, harvest)
- Month (enter proper dates e.g. 1/1/2024, 2/1/2023 assuming mm/dd/yyyy format)
Each plant will have three rows in the table, for sow, plant and harvest.
You can then use PivotTables and Slicers to plot the data in the format shown on the packaging with months across the columns and tasks down the rows. You can insert a Slicer for the Task and Dates (grouped by months) to filter the PivotTable.
I hope that points you in the right direction.
Mynda
Answers Post
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Riny van Eekelen
Guest(s) 5
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1944
SunnyKow: 1432
Anders Sehlstedt: 956
Purfleet: 415
Hans Hallebeek: 377
Frans Visser: 351
David_Ng: 318
lea cohen: 248
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Waqas Arshad
Techia Braveboy
Charles Buchanan
Tiago Braga
Rehan Baig
Fred HORVATH
Silke Schmidt
Stuart Barr
Amelia Nolte
David Wier
Forum Stats:
Groups: 3
Forums: 25
Topics: 7157
Posts: 31386
Member Stats:
Guest Posters: 50
Members: 34656
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —