Fill in your profile, inlcuding an e-mail address, and you can have mine.
It can work out price per litre, total cost or amount of litres, MPG to date, MPG overall, total and weighted average fuel cost.
It does need some tweaking as it doesn't automatically update averages and totals for inserting a new row. If anyone knows how to do that, I'd be interested. Also, because it assumes you know nothing about at least one of the figures, there are circular forumlae which you have to press cancel to leave in upon opening.
Anyone who wants a copy or has suggestions to improve it is welcome to contact me via the forum. For now I'll be leaving my address off profile so that others will fill in their profiles but I'll add it in a few days if this thread runs.
|
Thanks David,
In the interests of protecting my main email address, please email me at trashaccount @ ntlworld dot com.
|
|
|
To save yourself retyping formulae in a row or column, highlight the cells starting with the one where the original formula was entered and ending at the one where you want to add your latest information. Go to the Edit menu, then Fill, and a sub-menu will appear from which you can choose Fill Down, Fill Right, etc as appropriate. This will replicate your formula throughout the area highlighted. So if cell C1 contains the formula (=A1*B1), and you fill down the column, cell C2 will calculate A2*B2, C3 will calculate A3*B3, and so on. You can use this function horizontally or vertically. Obviously there must be figures in columns A and B for C to be calculated, or it will just show zero.
This is all far easier to do than to explain!
andymc
|
I can do the fill down and right with no problems. What I can't do (I don't know if it can be done automatically) is, say,
a3 contains = average(a1:a2) then I want a4 to contain average(a1:a3) and so on.
|
I don't know if this is what you want to do, but using the $ symbol locks part of a cell descriptor when you are copying cells.
For example, $A$1 would result in the reference staying as A1 on all copies. $A1 would result in the A part staying the same and the 1 part being updated based on where you copy it. A$1 would alter the A and keep the 1.
So, I suspect you need to put =average($a$1:a2) in cell a3 then copy this in to cell a4 and on.
Also, as a note to Hairy Hat Man, is your actual NTLWorld account name trashaccount? If not, then this mail will just disappear in to the ether - NTLWorld don't do redirects.
|
Steve, yes one of my many account names at ntl is TrashAccount. I set up random account names and drop them when they start getting spammed.
And NTL do do redirects:
selfcare.ntlworld.com/cgi-bin/frontend
|
Ah, so you are why no-one can get the username they want on NTL, and why the mailservers are overloading! :)
That's not the type of redirecting I mean. I mean where you can set up a selection of usernames at a domain and get them redirected to one address. With NTL you have to have an actual mailbox to use that username.
|
AS with any isp, it's first come first served as far as usernames are concerned. That's why the likes of freeserve give you the option of different domain extensions.
NTL mailservers are overloading because they haven't got the hardware to cope and there is no facility to indicate that an account can be deleted. I actually don't use many different usernames, but am keen to protect my 'main' one. I'm suffering just like everyone else who's been with ntl for some time. Last week I received a message that had been 'received' by ntl 12 days beforehand!
They've allegedly been working on the current problem for nearly 3 weeks!
|
David,
This may help you.
I have spreadsheet where I input each fill up (to brim) on a seperate row. I have columns to input date (B) odo (C), litres (E) and cost (G). All other columns work out automatically as long as you drag the formulas down far enough. The other column formulas are:
Trip miles (D) = Odo at that fill up - the previous odo reading ie C2-C1 if you are entering on row 2.
Gals (F) = Litres/4.5 ie E2/4.5
MPG (H) is then = D2/F2
To work out the average mpg I do the following (again in each row).
Total Miles (I) (= Odo reading now - odo reading when car purchased ie C2-\'20000\' if car purchased at 20k
Total Gals (J) = The total number of gallons bought, this is the calculated by adding the gals bought at current fill up (F2) previous total above ie (J1).
Ave MPG is then I2/J2. You then always read the most current average.
All formulaes can then be dragged down. Shouldn\'t need to get circilar references or do anything to clever when updating it
My spreadsheet also calculates the pence per mile for all costs ie insurance, tax, repairs, depr, fuel across the years I\'ve owned car.
And I also have something which works out a cost my sister owes me for use of the car apportioned on the number of miles we each do.
Oh and also a little formula that\'s calculating the estimated miles I\'ve got left in each tyre. I really must get out more!!
Mike.
|
A more accurate calculation for gallons in David's spreadsheet would be Gals (F) = Litres/4.546.
Though I prefer to calculate it as (Total cost in pounds) / (pence per litre) * 22, which is accurate to the same number of decimal places.
Ian
|
|
I know we're wandering off topic here, but if you use NTL webmail you'll have chronic difficulty at the moment uless you also do a redirect to another webmail account (yahoo, for example) or into Outlook.
The problem isn't overloading, but their attempts to get round it via a series of new servers, which under-performed spectacularly when they were switched on a couple of weeks ago. NTL has been trying a fix ever since, but informed me it would take 'some time'.
As for Excel...I have enough of that at work, thank you!
|
|
As this thread is wandering off topic, it will get moved to "I have a question" thread later today.
|
Sorry DD if it's too late for it. If anyone wants super-accurate conversions the following may help (as used on my Excel spreadsheet):
1 kilometre = 0.621371192 miles
1 litre = 0.219969152 gallons
Oz (as was)
|
The phone company installed my DSL which works very nicely. At the same time it fires up it launches IE6. When it does so it also launches the phone company's website home page: www.pldtdsl.com
Having read all the stuff on there I now have no use for it and want my homepage to be Hotmail. So set the home page to Hotmail. Fine. However, every time I start up, up comes the PLDT company homepage. If I then click on "Home" I get the Hotmail sign-on page, but I still get the other one first.
Try as I do I can't get rid of it. Mostly I use Opera anyway but
why does my IE6 Browser get commandeered by PLDT and why can't I get rid of that site? I thought at one point using Search & Destroy, which has a feature allowing you to edit what your Browser does at start-up, that I'd gotten rid of the offending site, but only to have it reincarnate itself.
The irritation of this per se is minor, the main bit being the frustration at being beaten. All ideas gratefully received.
|
Growler, I reckon there must be an entry in the registry somewhere. Start up regedit and do a search for your telco's web page cuting and pasting it exactly as it appears in your browser. You could also try Lavasoft Ad-Aware to hunt it down.
GH
|
Yup I went this route. I use RegCleaner, it's free, doesn't produce gooble de gook and presents everything in plain English. Not scary like Regedit either and it makes auto backups - well recommended. Combed through that. couldn't find anything that shouldn't be there.
Search and Destroy shows you what your browser activates when you fire it up. i.e. the home page and the search parameters currently selected. If your browser is putting stuff there which it shouldn't be, you have the option to deselect that. I zapped everything so the IE6 would come with a blank page but still this pesky website keeps loading. I can only conclude it's integrated into the phone company software and simply regenerates.
If I can find an hour to spare listening to Britney Spears and being told how important my call is (but not important enough not to keep me hanging on - good job local calls here are free...) while I wait for anyone at their call center tomorrow with half a brain maybe I can get an answer!
|
Growler, another thing you can try is Spyware blaster at
www.javacoolsoftware.com/spywareblaster.html
I found some Ad-ware on my PC which I traced to my ISP. The only
way I got rid of it was spyware blaster. Funny thing is it disappeared when I moved to ADSL. I don't know whether ADSL had anything to do with it or the ISP had removed it due to a large number of complaints!
|
Stop-press just found this which seems to fit your problem:
www.wilderssecurity.net/bhblaster.html
GH
|
Thanks all. I am now convince my IE browser has been hijacked. I have also tried Hijack Blaster and a number of similar tools, to no effect. They came up with nothing. This suggests the rogue website is reinstalling itself every time it cranks up. My take is the phone company is using this for marketing purposes and I can't be sure what they are doing with the info they are getting off my system. This wouldn't surprise me in a country where a 14 year old wrote the Love Bug. Remember that? I'm going to post my findings in the local media anyway and see what happens.
Although I use IE6 infrequently because of its generally inferior performance, it has now been summarily fired!
I shall maintain Opera as my primary browser, but because you can't post to the BR off it, I'll keep Mozilla as well. They are just so much faster and with things like anti pop-ups so no need for extra software too.
Maraming salamat everyone!
|
I will be very interested to hear what you find out.
GH
|
GH - I will certainly post anything I learn. The privacy laws and conventions have yet to catch up with the internet (if they ever will) so any of this could be happening to anyone.
Time to consider Linux?
|
|
Change of topic here but can someone explain what the law is about under 18s in pubs? Reason I ask is that my wife ( a teacher) went to a local pub on Friday for meal with some colleagues and at about 10.30 went from the restaurant part to the public bar to have a quick smoke to find a 13 year old pupil (with parents) shouting " I didn't know you smoked miss" across the bar. Doesn't seem right really that you can't go into your local without meeting your (worst)pupils. No doubt he will be a prat about it tomorrow also.
|
It depends on the licence in place for the original pub. Generally you have to be over 14 to be allowed entry, but can't order or sit at the bar, let alone drink alcohol.
Some pubs have licences that allow under 14s in, either to the whole pub, or designated areas. I think these licences generally only apply until 9.30 p.m. although it might be possible for there to be exceptions.
Probably the pub was in breach of its licensing conditions by allowing him to remain there, but in practice, it's a minor breach that wouldn't be looked at too harshly compared to serving alcohol to a sixteen year old or serving until (gasp!) 11.30.
It's also the reason why a lot of teachers choose to do a long commute into school - less chance of meeting their pupils out of work. Of course, when you're going out for a work event there's not much other option than to choose a convenient central point, i.e., nearby.
|
|
Thanks David - lazy on my part I know not to look it up elsewhere but Honest John site always has someone who can (and is willing to!) answer questions on anything!
|
Hi,
I have today received a new desktop charger for my mobile phone. The trouble is, it doesn't seem to be working. It has a small light on it, which doesn't come on when I plug it in - does this mean it's not receiving any power, or does the light only come on when the battery is charged? (it's been switched on a couple of hours now and there's no sign of any charging going on.)
This is really frustrating, and I'd be grateful if anyone could tell me what's going on.
HF
|
HF
I think no light means not working!
|
Hmm - dammit. I think you're right.
Thanks anyway Your Worship.
|
|
HF, what make and model is the phone? Are you sure the desktop charger is compatable for your phone?
|
Hi D,
My phone is a Motorola T191e. And the charger is definitely for this phone. It says it on the label, and the connections fit perfectly.
Just when I plug the charger in, there's no sign of any activity at all - either there's something wrong with my mains adaptor (and I don't think there is), or the charger is faulty.
I was wondering if there was any way, without electrocuting myself, of making sure that my adaptor is indeed adapting in the way it is intended to?
This charger was my very first ever experience of buying on Ebay! Hopefully something will happen to ensure that it is not my last!
HF
|
|
HF, either you'll need to find someone who's competant with a multimeter to measure the voltage output from the charger, or pop along to your nearest phone shop and let them have a butchers at it.
|
|
OK D, thanks - guess it's the phone shop's lucky day ;)
|
If you've got a small car bulb and a couple of bits of wire, you can use this to test if *something* is coming out of the mains adaptor or the charger. There certainly should be something from the mains adaptor, but the charger may not output a voltage until it detects the battery. You can't damage anything doing this, but the bulb may only light dimly as the voltage is likely to be about half what it would be on a car.
As DD points out though, a multimeter would be a better diagnostic tool.
|
Steve - I'm not sure how to do that without electrocution. But I took the charger into a mobile phone shop yesterday. They checked it for me with their own adaptor, and it is indeed a dud. I'm pretty sure my own adaptor must be sound, because the shop guy said it is a common fault with this phone for the adaptor connection to become dodgy.
Typical - of all the thousands of people who use ebay successfully every day, I have to be the one that buys dodgy goods!
|
Typical - of all the thousands of people who use ebay successfully every day, I have to be the one that buys dodgy goods!
I've never used E-Bay, but surely there must be some way of contacting the seller. Also I believe, isn't there a ratings system whereby you credit the seller with a good or bad opinion of them?
|
E-mail the seller. Most people are paranoid about maintaining good feedback and so will happily give you your money back.
Explain to them that the charger appears to be a dud - there's every chance that it's been lying around since they got rid of the phone and thought they'd get a few quid for it, rather than them trying to rip you off.
If not, wait for them to leave positive feedback for you and then leave something negative for them.
|
Hi D and David -
I've already emailed the seller twice since finding it was a dud. And, whilst she was extremely friendly and quick at replying BEFORE i received the charger, my last 2 mails have been ignored.
This particular seller seems to make thousands of trades, and has generally very good feedback, so I don't actually think it was a deliberate con. Also I think the charger is brand new, the seller I think must do this almost on a full time basis.
It's only a matter of a few quid, so not that important, but I'm annoyed that she won't respond to my latest mails.
If I don't hear anything today, I will leave honest feedback, explaining the above. And then wait for her to badmouth me even though I have been extremely polite and courteous throughout!
It's just so damned annoying because I am desperate to get my phone up and running again!
|
>>It's just so damned annoying because I am desperate to get my phone up and running again
Go down the nearest market and/or cheapie shop and buy a car charger for it. Last time I noticed they were 5 quid at a market near me.
They're not particularly good quality, and they won't take much abuse, but they wrork well enough.
M.
|
|
Cheers M - the trouble is, the connector hole in the actual phone has become loose, I didn't explain that properly above. So a normal pin thing doesn't work in it. That's why the idea was to get a battery charger rather than a phone charger, hence the desktop idea.
|
Growler,
After reading many of your posts extolling the virtues of Opera as a browser I finally bit the bullet and downloaded it. It is indeed faster than IE6 (cannot thnk why though). Do you have any idea why you cannot log into this site using it? I can log onto other forum sites with no trouble. I have Opera set up with "identify as MSIE6" selected.
Cheers
Robin
|
I can think of two or there reasons why Opera appear faster
1) It is more efficiently written
2) You wanted it to be faster
3) Your cache location is different and your old IE cache was bunged up with years of old rubbish.
On balance 1) gets my vote but 3) can cause immense problems with IE so the moral is use the Delete Files option in Internet Options to clear down your cache.
|
I can log on to Back Room with Opera, but I cannot post.
There is no question it is faster than IE6, even with IE6 Favorites imported and configured to behave like same. The way it handles multiple windows via tabs and the "rewind" function (Opera 7) give it my vote. Plus it has the download manager et al.
|
I'm using Opera 7.10 and it works a treat on this site under MSIE6.0 ID mode. Have you tweaked your cookie settings at all?
|
Kuang: I have Opera 7.11 and am running it as it installed itself. So far, I am v. impressed with how fast it is but, unlike Growler, I cannot even login to this site never mind post to it. Any ideas as to what the Cookies should be set to?
Cheers
Robin
|
Hmm.. the standard install should work just fine - its a fairly run-of-the-mill setup with nothing too unusual. It's often best to set cookies settings for both normal and third party to 'accept all', just for troubleshooting purposes. How exactly does the site fail when you try to post? Does it let you log in at all?
I'm wondering if there might be problems with the magic wand. This is similar to APple's KeyChain feature, in that it will remember all of your password and allow you to control them using one master one. This is great, until it gets a password wrong. It might be worth turning that off for the time being, again just for troubleshooting purposes.
The final thing to try is the popup control setting. Popups use javascript, but so do perfectly valid pages - its all down to how it's written. If you tell it not to allow any popups you might find that nothing happens when you click the button because it isn't allowing the code to run. It's best to set the control to 'open requested popups only' as this will allow sites to function that use legitimate popups and javascript redirection, but will still ban unsolicited ones.
GOod luck :)
|
|
Oh well, tried all this but with no joy. I guess I'll have to use bad old IE6 for HJing. Pain. Thanks anyway.
|
Not the Magic Wand, not the cookies, not the pop-ups, has to be something beyong my limited IT grasp. I remember talking with Martyn once before about this and he mentioned IIRC that he was looking into compatibility with Opera. Never mind.
I am also on 3 other fora with my hi-jacked browser problem with expert minds from California, locally, Australia, Finland and germany on the case, so far none with the answer! They all say call your telco. Oh, yeah, so I dial 171like I have all day to listen to Barbie Doll teeny electronic pop in between telling me how much they value my call, but somehow not enough to answer it!
Among the many curses of this age: the Call Center!
|
|
|
|
|
|
