Lantern Energy Monitoring

In late 2007 I came across a device which allows you to determine how much power your appliances are using, and I thought that it might also be useful to determine the 'real' power of lanterns, so I bought one. (Mine came from Maplin - available to purchase from here.) 

The device measures the supply voltage, current being drawn by the appliance, wattage, apparent power, supply frequency, power factor and also the kilowatt hour.

I am in the process of measuring these variables on all lanterns and have made up a spreadsheet to display my results. The spreadsheet can be downloaded by clicking here. All values are what I actually obtained - I've not changed any to alter the spreadsheet's appearance!

Some of the columns in the spreadsheet are hidden in order to reduce the amount of information on display. Clicking either the small '2' or the '+' buttons above the columns will reveal this information. To hide it again, click the small '1' or '-' buttons.

The values in the 'V*A', 'Real Wattage' and 'Acceptable PF?' columns are determined by formulas and so these columns should not be altered.