Excel Irrigation Time Table

Job ID: 35198886

Budget: €250 – €750 EUR

Create a time table of irrigation time slots with the following features:

Check irrigation times and confirm that there are no duplicates.

Check irrigation times and confirm which time slots in a 24 hour period is available.

Enable restricted time to irrigate during the day.

Borehole which supplies the irrigation supplies water at 15 000 l per hour and we have a 200 000l holding tank.

Check and confirm that the amount of irrigation provided will never empty the tank.

Loadshedding prevents us from using our pumps. - Create a slot where we can add times where the borehole will not work and confirm that tanks will not run empty during the irrigations when power is restored.

Fields which will be required:

Irritation programme number

Irrigation identifier

Irrigation valve number

Irrigation Start time

Irrigation duration

Amount of water per irrigation.

Loadshedding times

Restricted irrigation times