Element Power Calculator

[Yummyrum]

I figured this might be helpful to some members .
You enter the Rating of your element into the Setup boxes .

Then you can enter the reading off your Ammeter and it will calculate the Power your element is Drawing .
Likewise , if you have a Voltmeter ACROSS your element ,then it will calculate power based on that .
It will not work if you have your voltmeter on the input side of your SSRV

It may also be useful if say you are contemplating getting a certain size element to see if your outlet will be big enough to handle the Current draw .

It will also calulate the Power at 1Amp increments and you can select that an display as a graph .You could print out a paper copy to look up that suits your element .
Values highlighted in Red exceed the rating of the element .

Element power Calculator +.xlsx

(30.54 KiB) Downloaded 32 times

Note : if you enter a number into any box other than the Coloured ones , you'll screw the formula and have to download the File again .
Sorry my Excell Foo is weak . Happy for anyone to improve on it .

Also Note:
If you have two identical elements connected to the controller ,then the Current will be shared between them .But you must first enter the combined power of both elements in the setup.

For example ,Fierycreations has two 4500w elements connected to his controller .
He would enter 9000w into the setup boxes .(not 4500watts)

Then , if his ammeter shows 20Amps , his combined power will be 2560watts

So fierys chart will be like this .
1 Amps 6 Watts
2 Amps 26 Watts
3 Amps 58 Watts
4 Amps 102 Watts
5 Amps 160 Watts
6 Amps 230 Watts
7 Amps 314 Watts
8 Amps 410 Watts
9 Amps 518 Watts
10 Amps 640 Watts
11 Amps 774 Watts
12 Amps 922 Watts
13 Amps 1082 Watts
14 Amps 1254 Watts
15 Amps 1440 Watts
16 Amps 1638 Watts
17 Amps 1850 Watts
18 Amps 2074 Watts
19 Amps 2310 Watts
20 Amps 2560 Watts
21 Amps 2822 Watts
22 Amps 3098 Watts
23 Amps 3386 Watts
24 Amps 3686 Watts
25 Amps 4000 Watts
26 Amps 4326 Watts
27 Amps 4666 Watts
28 Amps 5018 Watts
29 Amps 5382 Watts
30 Amps 5760 Watts
31 Amps 6150 Watts
32 Amps 6554 Watts
33 Amps 6970 Watts
34 Amps 7398 Watts
35 Amps 7840 Watts
36 Amps 8294 Watts
37 Amps 8762 Watts
38 Amps 9242 Watts

[fiery creations]

This is great. Thank you!!!

[MooseMan]

Very useful Yummy.

To easily preserve the formulae you could lock all of the cells that you don't want as an entry field, then protect the tab.
This way your are only able to type into the cells with no formula, I do this all the time

[quadra]

Nice one Yummy! ..and that is a great tip Mooseman. Thank you both!

[Yummyrum]

Thanks fiery and quadra.

Great idea Moose, didn't know about that . will look into it .

Alas I didn't realise that if you download this to an iphone , it's look only . So would need to down loaded to a PC with windows Excel to use .

Also caveat . This is only as accurate as the readings your ammeter gives . As discussed in other topics , only true RMS meters will give an accurate reading from an SSVR or SCR style controller .
viewtopic.php?p=7683511&sid=4eab2ceb6d6 ... 7#p7683511