More efficient than what ?View attachment 354401
Picked this up for £83 today from Argos, claims to run at £0.17 / hr so more efficient
for warming my office. Sort of an oil filled radiator but not actually filled with oil.
Not the most stylish but seems to be ok so far if my cashback etc tracks successfully the effective price is £73.
More efficient than what ?
So you're not using the CH ?
It costs 17p per hour because it's only averaging 500 watts.
Gas watts are much cheaper.
<snip>
Since then, though, they haven’t been taking direct debits. But they have been crediting us with the government rebates. We are proving readings every month on the requested date, plus again the extra one when the cap rose. This might seem good. But I’m worried that a huge bill awaits us at some point. It could be that we overpaid up to September and are still in credit. I honestly would have no way of knowing: the “paper” trail is chaos and makes no sense. (One of my issues was I wanted paper bills because the figures in the app and on the website would actually change! But they haven’t been forthcoming).
Should I prod them or keep quiet? What would you do?
You’re a star, cupid_stunt Thabks for your help.
I have to admit I still have no idea what I’m doing.AnnaKarpik also sent me her spreadsheet. So now that I’ve a better idea what to record, from Cupid’s workings, I should be able to keep a record of gas and electricity spending.
I’m currently thinking I’ll put the money aside rather than make a complaint.
Like the test and trace people we paid 36 billion to who tried to use an ancient version to process an unreasonably large amount of data.(I also utterly hate people who use XL for stuff that isn’t sums. Like words. What the fuck is that about?)
Thank you but although the individual words carry meaning, when put together they no longer do for me.Like the test and trace people we paid 36 billion to who tried to use an ancient version to process an unreasonably large amount of data.
After retiring I had to move to Libre Office which is a bit clunkier, but yes, I will paste screengrabs of info alongside spreadsheets
To insert a new column, select a column and choose "insert whole column".
If you select a section of column you are offered the choice to just expand that part of the sheet ...
I've never been a sophisticated user - I've barely moved on from Multiplan I taught myself to use in the 80s. ... I have one for finances, and another for health - like weight, blood pressure etc ...
People who use Excel everywhere because it's the only thing they know, it never occurs to them that there are simpler, more portable and appropriate options, and tools like genuine databases and higher level data analysis languages frighten them. See also: people who refer to delimited separator format text files as 'spreadsheets'.(I also utterly hate people who use XL for stuff that isn’t sums. Like words. What the fuck is that about?)
I always cringe when I see this guy recording his data on paper.I
Plus calculating energy use. I'd like to make more use of those figures because I must have 15 years of data and the columns just stretch off into the distance and when it comes to it I can never work out exactly what I should do with them.
in 2001 i spent a week temping at a publishers just off caledonian road. they wanted details of their author contracts put into an excel spreadsheet. but their contracts were in such an awful state, some of them said the authors would be paid in three tranches and only named the amounts to be paid in two. so i had to point out a lot of this to the person in charge of the project. i also pointed out as you have that there are databases for things like this. anyway, the second week, monday morning i'm there bright and early only to be told 'didn't your agency contact you? we're doing it inhouse now'. and as any self-respecting person does when they're sacked i went off to the pub,the alma on chapel market, which in those days opened really early for the market stall holders. got chatting to someone in there and came to the realisation that i'd been dispensed with because i was trying to do a good job. since then i've realised that excel is useful for quick and dirty databases, eg lists of journal articles. but i still wouldn't put details of contracts in an excel file.People who use Excel everywhere because it's the only thing they know, it never occurs to them that there are simpler, more portable and appropriate options, and tools like genuine databases and higher level data analysis languages frighten them. See also: people who refer to delimited separator format text files as 'spreadsheets'.
I have to admit I still have no idea what I’m doing.
To explain: I don’t use XL, I’ve never understood spreadsheets, I don’t know what the columns are doing, and I thought adding a column for gas readings would be easy but it seems to get populated by figures from somewhere else entirely.
If I’ve ever been faced with an XL document in the past I’ve transferred the data into a table in word and added the figures up myself. (This doesn’t always work because I usually haven’t seen that the XL file has tabs with stuff hidden in them).
(I also utterly hate people who use XL for stuff that isn’t sums. Like words. What the fuck is that about?)
So, yeah. I thought I’d get it but I don’t.
That makes sense to me. I’ll do that. Probs in a paper notebook!Ditto mate, give me Adobe InDesign and I can produce a magazine ready for print, and I get on with the xero accountancy software for my wee business, but excel just freaks me out. Although the screen shots I sent you were from excel, I had only added figures up using the 'sum' icon in excel, the multiplications I did myself on a calculator and entered the answers in manually, which somewhat defeats the object of excel.
My advice is go with KISS*, just work it out monthly when you report meter readings and I assume their system shows you the kWh's used for both electric & gas, multiply them by the current tariffs for each, likewise with the two standing charges for the number of days in that billing period, add the four elements together + 5% for VAT, and jobs a goodun.
* KISS - keep it simple stupid.
Or, get smart meters, relax & feel smug.
Entirely appropriate for doing your personal accounts or tracking household utility metering. Not appropriate for handling millions of records of multi-dimensional data (as PHE/UKHSA embarrassingly found out), or complex data objects, text analysis, etc.I fucking love spreadsheets I wrote one years ago to calculate my accounts and it has saved me shitloads of money with accountants and shitloads of time adding up figures that don't quite balance twelve times a year and then hugely don't balance at the end of the year. I even enjoy trying to correct mistakes because that will make it easier next year.
Plus calculating energy use. I'd like to make more use of those figures because I must have 15 years of data and the columns just stretch off into the distance and when it comes to it I can never work out exactly what I should do with them.
I also love spreadsheets; I'm a bookkeeper, couldn't live without them, though I have heard of people who don't get on with themI fucking love spreadsheets I wrote one years ago to calculate my accounts and it has saved me shitloads of money with accountants and shitloads of time adding up figures that don't quite balance twelve times a year and then hugely don't balance at the end of the year. I even enjoy trying to correct mistakes because that will make it easier next year.
Plus calculating energy use. I'd like to make more use of those figures because I must have 15 years of data and the columns just stretch off into the distance and when it comes to it I can never work out exactly what I should do with them.
View attachment 354401
Picked this up for £83 today from Argos, claims to run at £0.17 / hr so more efficient
for warming my office. Sort of an oil filled radiator but not actually filled with oil.
Not the most stylish but seems to be ok so far if my cashback etc tracks successfully the effective price is £73.
Been considering doing that myselfnicked one from work, and just take room to room now
It's not nicking, It's extended field testing under a wide variety of conditions in order to fully assess the product.nicked one from work, and just take room to room now
I've ordered a small terracotta pot and gonna try this hack. its not going to make much difference, but I'm intrigued. Haven't done any such experiment since secondary school in the 90s. Before anyone mentions its dangerous etc. yes I am fully aware. Its not like I'm gonna go to bed or go outside with it left on.