Garden Watering Schedule Excel - Free Template

1. Open the Instructions sheet first and review the guidance on adding tasks, plant requirements, adjusted litres and seasonal checks.
2. Go to Watering Schedule and enter a unique Task ID, watering date, garden area, crop, location and area in square metres.
3. Select a crop from the Plant / Crop list. Plant Type and Water Need are populated from the Plant Reference sheet using a lookup.
4. Enter the task duration, rainfall forecast, preferred time, watering method, assigned person and completion choice. Use the Notes field for observations.
5. Check Estimated Litres and Adjusted Litres. For example, 6 litres/m² across 4 m² produces 24 estimated litres before any rainfall adjustment.
6. Review the Status column for Planned, Due today, Overdue or Completed, then open Dashboard to inspect totals and task breakdowns.
7. Amend Plant Reference values when your soil, plants or growing conditions require different working assumptions, and review the resulting calculations before watering.

A garden watering schedule suits anyone responsible for repeated watering across several beds, containers or growing areas. A home gardener may use it for a kitchen garden, while an allotment holder can record separate tasks for vegetables, fruit and flowers. A community garden coordinator can also assign work to named volunteers without relying on separate notes or messages.

Small gardens with several watering zones

Imagine a gardener managing a 4 m² front vegetable bed of tomatoes. The Plant Reference sheet supplies the example tomato requirement of 6 litres/m², so Estimated Litres becomes 24 litres. The gardener can select Early morning, Drip irrigation and Oliver, then record whether the task was completed.

A second task might cover a 6 m² allotment area of courgettes. The reference value is 5 litres/m², producing 30 estimated litres before rainfall is considered. Keeping the area and crop in the same row makes it easier to distinguish that job from a smaller container or border task.

Allotments, kitchen gardens and shared duties

An allotment holder can use Garden Area for labels such as Allotment plot or Raised beds, then use Location to record the town or site. The workbook includes sample locations such as Manchester, Birmingham and London, but these are illustrative entries to replace with your own information.

For a shared garden, Assigned To identifies who is responsible for each task. The Completed? list accepts Yes or No, while Status turns an unfinished past task into Overdue and a task dated today into Due today. This gives a practical weekly handover view without requiring a separate task list.

Reviewing the garden workload

The Dashboard summarises scheduled tasks, completed tasks, completion percentage, total estimated litres, total adjusted litres, average litres per task and overdue tasks. Its garden-area summary and plant-type count help you see whether the workload is concentrated in one bed or spread across several planting categories.

The workbook separates editable inputs from calculated outputs. You enter the crop, area and rainfall forecast on Watering Schedule; formulas then retrieve plant information and calculate the working volume. This is preferable to typing the same water requirement into every task, because changing a reference value can update linked rows consistently.

Plant lookups and area calculations

Selecting Tomatoes in E2 returns Vegetable in Plant Type and 6 in Water Need (litres/m²) through VLOOKUP from Plant Reference. With Area set to 4 m², the Estimated Litres formula multiplies 6 by 4 and returns 24 litres. If either the crop or area is blank, the relevant calculated result remains blank rather than displaying a misleading zero.

The reference list contains 10 crops, including Lettuce at 3 litres/m², Lavender at 2 litres/m² and New lawn at 5 litres/m². The reference sheet also records typical frequencies, but these are working guidance rather than automatic scheduling rules. You can amend the reference values to suit your garden conditions.

Rainfall adjustment rules

Adjusted Litres uses the Rainfall Forecast (mm) entry. With an estimated volume of 30 litres and a forecast of 3 mm, the formula returns 15 litres because forecasts from 2 mm to under 5 mm halve the estimate. A forecast of 6 mm returns zero, while a blank forecast leaves the estimated volume unchanged.

This calculation is deliberately visible and predictable: it does not fetch weather data automatically. You must enter the forecast yourself and use the Instructions sheet guidance to consider soil, temperature, wind and rainfall before acting.

Validation and status checks

Data validation restricts Area to decimals at or above zero, Rainfall Forecast to decimals at or above zero and Duration to whole numbers at or above zero. Preferred Time accepts Early morning or Evening; Method accepts Hose, Watering can, Drip irrigation or Soaker hose. The Status formula then uses Completed?, the date and TODAY() to produce Planned, Due today, Overdue or Completed.

Watering records become unreliable when one task mixes several areas, when the crop name is typed differently each time or when rainfall is noted in a message rather than beside the job. In this workbook, those errors affect lookups, litres and Dashboard totals, so the cost is a distorted plan rather than merely untidy wording.

Incorrect areas inflate the calculation

Suppose a tomato bed is actually 4 m² but is entered as 14 m². At the reference value of 6 litres/m², Estimated Litres changes from 24 litres to 84 litres: a 60-litre difference for one row. Check the unit before entering Area and avoid putting a length, plant count or hose duration into the square-metre field.

The opposite error is also possible. Entering 0.4 instead of 4 reduces the same estimate to 2.4 litres. Because the validation accepts decimals, Excel cannot decide whether 0.4 is correct; you must check the physical bed measurement.

Rainfall entries can change the working volume

For a 30-litre courgette task, entering 3 mm produces 15 adjusted litres, while entering 6 mm produces zero. If 30 is entered instead of 3, the formula follows the stated threshold logic and returns zero. Record rainfall in millimetres and review unusual values before relying on the Dashboard total.

Incomplete rows create misleading summaries

A row without a Task ID is excluded from the task count used by the Dashboard, even if other cells contain information. A crop that does not match the validated list will not provide the intended Plant Type or Water Need lookup. Use the drop-down lists rather than typing alternatives such as Tomato, tomato plants or veg.

Finally, marking Completed? as Yes changes Status to Completed regardless of whether the date is past or future. If a task was planned but not actually done, leave it as No and use Notes to explain the reason. This keeps the completion percentage and overdue count meaningful.

The workbook works best when updating it is attached to a fixed garden habit rather than treated as a one-off planning exercise. Set aside a short review at the same point each week: check upcoming dates, enter the latest rainfall forecast, assign people and confirm completed tasks. A consistent routine matters more than adding unnecessary detail.

Use a simple weekly check

• Review Watering Schedule before the first planned task and look for blank dates, areas or crop selections.
• Enter current rainfall forecasts in millimetres, then inspect Adjusted Litres rather than relying only on the original estimate.
• After watering, change Completed? to Yes and add a short observation in Notes, such as a 25-minute drip irrigation run or a review after rain.
• Open Dashboard at the end of the week and compare total scheduled tasks with completed tasks and overdue tasks.

For example, if you have 12 scheduled rows and complete 9, the Dashboard completion percentage calculates 9 divided by 12, or 75%. The outstanding figure then shows 3 tasks, giving you a clear starting point for the next review.

Keep reference values under control

Use Plant Reference as the single place for working water requirements. If you change Tomatoes from 6 to another value to reflect your own conditions, review every linked tomato row afterwards because Estimated Litres and Adjusted Litres may change. Do not overwrite calculated cells on Watering Schedule with manual litres.

Use the existing lists for Early morning and Evening, and for the four available methods. Consistent entries make filtering and handovers easier, while the Dashboard's plant-type counts remain useful.

Recognise when the file is no longer enough

This workbook is suitable for a schedule of up to 100 task rows and a reference list of 10 crops. If several people need simultaneous access, you require automatic weather imports, irrigation sensor data or a much larger asset and site structure, move to a dedicated garden-management or operational system rather than adding uncontrolled extra columns.