Load shedding speadsheet calculator

[DrewChan]

As an idea, does anyone with the maths know-how want to do a quick excel sheet where you input watts and it kicks out how long a 102ah battery is likely to last based on usage.

Would stop a lot of questions in here

 

[TehStranger]

Too lazy to save and upload an Excel, just recreate it:



Think that's about right?

 

[DrewChan]

Too lazy to save and upload an Excel, just recreate it:

View attachment 213798

Think that's about right?

Nicely done TehStranger.

 

[akescpt]

Wow. Nice one.

 

[BigEars]

Too lazy to save and upload an Excel, just recreate it:

View attachment 213798

Think that's about right?

Brilliant

 

[KatMak]

Nice one

 

[KOPITE]

Too lazy to save and upload an Excel, just recreate it:

View attachment 213798

Think that's about right?

Is that 1 battery or 2 as you have 24v rated.

 

[maumau]

Impressive

 

[greg_SA]

The calculation assumes a battery with 24V and 100Ah capacity... So that is 2 x 12V 100Ah batteries in series.

A quick way to check this is to calculate the number of kWh that you need (just kW x hours) compared to the kWh of your battery.

So if you need 500W for 3 hours, you need 1.5 kWh.

A 12V 100Ah battery gives you 1.2kWh. But if you limit to 50% depth of discharge you only get half that - 600Wh.

 

[BigEars]

Bump. People need to see this.

 

[TehStranger]

The calculation assumes a battery with 24V and 100Ah capacity... So that is 2 x 12V 100Ah batteries in series.

A quick way to check this is to calculate the number of kWh that you need (just kW x hours) compared to the kWh of your battery.

So if you need 500W for 3 hours, you need 1.5 kWh.

A 12V 100Ah battery gives you 1.2kWh. But if you limit to 50% depth of discharge you only get half that - 600Wh.

I just put in some dummy data as an example, you can update the various variables and the time will auto update.

 

[BigEars]

I just put in some dummy data as an example, you can update the various variables and the time will auto update.

That Formula you use @100 DOD is accurate. I like Excel too. But yeah, you made it nice and simple....people that can actually use Excel will understand...those that don't are not worth the trouble anyway...

Not Eish etc...you know who and what I am on about....classic post from you. Clever and give the info..but just enough.

Intelligent people will understand. Others will be lost.

You are a frigging genius. I have to remember your approach

 

[Dimpie (COMPUTEK)]

Is the formula for block F2 always ½ of that of block E2 ? ... and also, is that half(50%) the Ah usage ??

 

[Dan C]

Is the formula for block F2 always ½ of that of block E2 ? ... and also, is that half(50%) the Ah usage ??

Just a rough estimate I would imagine. Guess it depends on the batteries you use.

 

[koeksGHT]

Here is one I made a while ago

https://docs.google.com/spreadsheets/d/1WMrs-YfbRdgBDOhcjZoZpvO0CWfX3MQV_oBB9o5Ed08/edit?usp=sharing

 

[Saman]

Sorry wrong thread lol!

 

[dunkyd]

KISS. Just switch it on and use your multimeter every hour....jees!

 

[Saman]

Sorry wrong thread