Attention Kill A Watt Nerds

wow, that is quite a setup PK. You REALLY need your own garage for that contraption!

Interesting data. Looks to be about 8-10V of sag in your 110V lead? Are any of your connectors/wires getting warm during the charge? Is that from empty to full pack?

I still wonder how one of these PHEVs would charge off of a limited power solar array. My array would put out 11A no problem, until a cloud passes over!

Good to know there are some other data hounds out there.
thx.

 

if you do it in one row, you can then copy that formula into every other cell in colum E, e.g. if in row 4 you would enter
+b4*c4 into cell E4. (can do it via point and click as well) Then you just select sell e4, copy, select either column E (click the E letter at the top of the cell), or just drag a large region of cells in E (e.g. to match all the data you have) and paste.

 

The idea is to copy the fomula to the other cells.. by maybe you were not even using formulas (I cannot tell since you saved it as a txt file. If you click on cell E4 it should be a formula that looks like
"=+C4*B4"

To add more data you just copy a cell with the fomula (e.g. select E4, right click, select copy. Then left click and drag to select more rows (say e5 to e6333), then right click and paste.

I've made the fomulas and copied it to all of the filled in cells for you.. but I cannot seem to uplaod excel files here anymore so I put it at
http://innovation.uccs.edu/~tboult/VOLT/Excel%20of%20PIP%20Charger%20Status.xls




Might be worth noting your formula is for instantaneous watts (a measure of power), not kWh (a measure of energy)

 

in the cell for kWh enter a formula like
+SUM(E4:E6333)/1000/60/60 (I presume your data is sampling every second).


I realized that you probably want to do this on a regualr basis.. so copying the formula is not as easy.. a simpler way is to have a formula like
=+SUMPRODUCT(B:B,C:C)/1000/60/60

(more more generally

=+SUMPRODUCT('8-31-2012'!B:B,'8-31-2012'!C:C)/1000/60/60)
where '8-31-2012' is the name of the particular tab.


sumproduct is a more powerful and to some people confusing function, but it does just what you want if all you want is kWh.. it takes the elements of B and C, takes their pairwise product and sums it up. since I said B:B. it does all of B no matter how many or few, rows you add.



Best to keep your results on one page and the data on others..

I updated the sheet to look with that and reuploaded to my server.
You can than load new days of data as separate sheets then copy/edit the fomula on the "results" page to use the names of the new tabs

No problem.. the = just says it is a formula (otherwise it might be considered text) and the + is just me being me in entering fomulas. (I don't even think much when I do this anymore.. its habit to enter + if I mean the positive and - if I mean the negative of a cell).

 

I updated the link. I put two graphs.. since all of volts, amps and watts are in different units they each need their own axis.

I added some more compex formulas (using a function called indirect subsample). See if you can figure out how to make your own from what I uploaded.

I did one without subsampling.. there are some higher frequency spikes in the data so if you are looking for that you may want to plot the raw data to investigate.

 

THere is not really a formula.. but if you right click on the chart you can then choose "select data" and change the where the data is.

To create a chart you can select the data and insert chart, ut then you have to do more to make a second axis show up (select the data, then select format -> data series, axis, click second axis).

 

Not viewable?

 

Grab the lower left corner and stretch it.