[geoffers]

Originally Posted by meldrewreborn

@geoffers
.... I think I’d prepare a lookup table with the relevant dates & times (only 2 a year after all) and then test for that, ...

I've already written a function which calculates the two change dates (spring or autumn) for all years, so my macros are self adjusting 🤓

[meldrewreborn]

@geoffers

You would think that Bright would help customers by providing a tool that would allow customers to interpret the data they provide more easily rather than us all reinventing the wheel.

[retrotecchie]

@meldrewreborn

Yes, but different folk have different requirements and it's a bit of an ask to provide a 'one size fits all' solution, especially when folk use half a dozen different platforms or ecosystems.

Nothing I want to do can be done easily on Android (and the screen is to small to show the data I need) or iOS and nobody seems to want to produce apps for Wndoze PC which Is why I always write my own software.

If you are going to the trouble to write VBA macros for Excel, you might as well just write your own standalone software in VB.

Sometimes users like me have very specific requirements and app developers are not going to bother putting in all the bells and whistles just fir one or two edge cases.

F'rexample....I have a dumb meter. I also have a tiny video camera in my meter cupboard that can see the meter. When I open a capture window on the PC in the office, I can read the meter remotely. Easy enough to do that once a month to enter my readings on the account, but a bit more of a workup when I need to take readings every 10 minutes. But simple enough to use OCR on the camera to extract numerical data...which can then be automatically injected into my dataset and/or uploaded to E.On Next. But my other meters have open contact pulse outputs, so these are interfaced to the PC via dataloggers which again, can automatically update my datasets on a five second sample frequency. I also have data capture from a couple of external websites which I also import into my datasets....but not many people need to know variance of grid frequency on a minute by minute basis.

The only way I could integrate that little lot, along with real time data from my solar generator was to write my own software.

So Bright's job is simply to make data available. What you do with that data or how you interpret it is a matter of personal choice, or ability.

[geoffers]

Originally Posted by retrotecchie

@meldrewreborn....If you are going to the trouble to write VBA macros for Excel, you might as well just write your own standalone software in VB...

Ahhh - but the beauty of writing VBA macros in excel is you just record the actions you're making in the spreadsheet, and let the macro recorder write the code.

You then just fill in the gaps between with loops; conditional statements etc 🤓

[meldrewreborn]

My IHD converts M3 to kWh approximating to a multiple of 11.2 (+/- .01). My billing though converts at almost exactly 11.1, so the meter/ihd conversion is not as far out as i imagined earlier. The calorific value of gas in the network is constantly changing so I expect the billing ratio to drift a little bit, while the value in the meter used to convert to kWh is likely to stay the same.

I'm interested to know how varied the multiple is in different parts of the country.

Its quite easy to work out , take your billed gas kWh, and divide by the volume consumed. If your meter is measuring in cu ft then divide the previous result by a further 2.85. So what actual figures do you get and approximately where in the country are you?

[meldrewreborn]

@Andy65

Thank you for that. I was having trouble initially with the OK and right arrow but all seems fine now. Multiple from m3 to kWh is now about 11.2. As the IHD shows kWh with no decimal places, but volume to 3 decimal places, the multiple is different every time i work it out , but as the kWh figure gets bigger the variance is getting smaller by the day..

My engineer set me up with a non rechargeable battery in the IHD (perhaps just so he could show it working) but that didn't last more than a day or so. I've got the IHD into my computer set up so that its powered only when the computer is on.

I've put a rechargeable battery in the IHD which does seem to recharge a bit, but never gets anywhere near a full charge before i switch off, so its always telling me to replace the battery!

good luck for Christmas and New Year.