Equation Formula Review/Proof For Garden Watering

new11

New Member
Hello all,
I hope everyone's healthily and happy and enjoying the sun. (if in the Southern Hemisphere)

I don't actuality have an issue or application question as such but more of a quick check over so I know if I'm applying the correct methodology.
Apologies if I've post in the wrong forum, I wasn't really too sure where to put it.

The Question;
I've decried to put all our garden sprinkler settings into excel to help calculate usage, costs while trying to optimise watering settings.
The general formula I am using is;
Cost =(R/1000)*L
L =(Flow*T)*Nodes​
T =Min*D​
D =ROUNDDOWN((End-Start+1)/Interval,0)​

Cost per 1Kilolitres= 2.99
Flow = 1.6 (Flow Rate Per/Min of 1x 90° Sprinkler Head)
Nodes = Amount of Sprinkler Heads
Min = Watering Run Time in Minutes
Start = Watering Start Date
End = Watering End Date
Interval = Watering Interval Day
R = Cost Per 1KL
L = Total Litres Used
T = Total Run Time

Thats the method of calculating the costs. I'd love to hear anyone's thoughts and please do let me know if I've missed anything.
Any feedback would be greatly appreciated and many thanks in advance.
P.S; if anyone knows how to calculate the usage and costs for running drip line irrigation, I'd love to hear it. (The Drip line is about 153 meters in length with hole spacing every 300mm apart. It's 2.2 l/hr Flow. I haven't been able to think of how to calculate this)

For example;

Book1a.xlsm
ABCDEFGHIJKLMNOP
10
11Cost
12Amount of 90° Sprinkler HeadsWater Flow Rate for 1x 90° Sprinkler HeadCost Per KLStart DateEnd Date
13
1471.6\$2.991-Dec-2128-Feb-22
15
16
17
18Season Programed Interval Watering Run Time Total Days for PeriodTotal Amount of Minutes for PeriodTotal Litres For PeriodTotal Cost for Period
19
20Summer220Mins45days900min10,080L\$30.14
21
22
23
24
Sheet6
Cell Formulas
RangeFormula
H20H20=ROUNDDOWN((N14-K14+1)/D20,0)
J20J20=F20*H20
L20L20=(E14*J20)*B14
N20N20=(L20/1000)*H14

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK
Repost at;

1,207,011
Messages
6,076,141
Members
446,187
Latest member
LMill

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back