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
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;
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 | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | |||
| 10 | ||||||||||||||||||
| 11 | Cost | |||||||||||||||||
| 12 | Amount of 90° Sprinkler Heads | Water Flow Rate for 1x 90° Sprinkler Head | Cost Per KL | Start Date | End Date | |||||||||||||
| 13 | ||||||||||||||||||
| 14 | 7 | 1.6 | $2.99 | 1-Dec-21 | 28-Feb-22 | |||||||||||||
| 15 | ||||||||||||||||||
| 16 | ||||||||||||||||||
| 17 | ||||||||||||||||||
| 18 | Season | Programed Interval | Watering Run Time | Total Days for Period | Total Amount of Minutes for Period | Total Litres For Period | Total Cost for Period | |||||||||||
| 19 | ||||||||||||||||||
| 20 | Summer | 2 | 20Mins | 45days | 900min | 10,080L | $30.14 | |||||||||||
| 21 | ||||||||||||||||||
| 22 | ||||||||||||||||||
| 23 | ||||||||||||||||||
| 24 | ||||||||||||||||||
Sheet6 | ||||||||||||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| H20 | H20 | =ROUNDDOWN((N14-K14+1)/D20,0) |
| J20 | J20 | =F20*H20 |
| L20 | L20 | =(E14*J20)*B14 |
| N20 | N20 | =(L20/1000)*H14 |
