Any question answered...

Just go to apple or one of their approved places. You'll get a proper screen and maintain your warranty.

After the whole finger print recogniser thing last year I would say go direct to Apple.

Converting Easting/Northing (OS National Grid) to degrees using a formula, is this possible? All I can find is a variety of online converters but I want to do a load through Excel.

Converting Easting/Northing (OS National Grid) to degrees using a formula, is this possible?

Implementing the formulae in Excel would be a major ballache.

http://www.movable-type.co.uk/scripts/latlong-os-gridref.html

You might be able to script something to use the above website for the conversions...

Well that looks like an absolute ballache, I think I'll put this off for the moment. Cheers

My previous link was probably not entirely suitable.

Are the options for a 15mm thru axle dynamo hub SP or SON? I did once find mention of a shimano one but I can't seem now

Was it the 8mm Deore LX T708?

Bit late, but thanks!

No, I saw that though, not heard of 8mm before. I thought it was xt

https://www.ordnancesurvey.co.uk/business-and-government/help-and-support/navigation-technology/os-net/coordinate-spreadsheet.html

Then look at the VB in the sheet they provide

Function E_N_to_Lat(East, North, a, b, e0, n0, f0, PHI0, LAM0)
'Un-project Transverse Mercator eastings and northings back to latitude.
'Input: - _
 eastings (East) and northings (North) in meters; _
 ellipsoid axis dimensions (a & b) in meters; _
 eastings (e0) and northings (n0) of false origin in meters; _
 central meridian scale factor (f0) and _
 latitude (PHI0) and longitude (LAM0) of false origin in decimal degrees.

'REQUIRES THE "Marc" AND "InitialLat" FUNCTIONS

'Convert angle measures to radians
    Pi = 3.14159265358979
    RadPHI0 = PHI0 * (Pi / 180)
    RadLAM0 = LAM0 * (Pi / 180)

'Compute af0, bf0, e squared (e2), n and Et
    af0 = a * f0
    bf0 = b * f0
    e2 = ((af0 ^ 2) - (bf0 ^ 2)) / (af0 ^ 2)
    n = (af0 - bf0) / (af0 + bf0)
    Et = East - e0

'Compute initial value for latitude (PHI) in radians
    PHId = InitialLat(North, n0, af0, RadPHI0, n, bf0)
    
'Compute nu, rho and eta2 using value for PHId
    nu = af0 / (Sqr(1 - (e2 * ((Sin(PHId)) ^ 2))))
    rho = (nu * (1 - e2)) / (1 - (e2 * (Sin(PHId)) ^ 2))
    eta2 = (nu / rho) - 1
    
'Compute Latitude
    VII = (Tan(PHId)) / (2 * rho * nu)
    VIII = ((Tan(PHId)) / (24 * rho * (nu ^ 3))) * (5 + (3 * ((Tan(PHId)) ^ 2)) + eta2 - (9 * eta2 * ((Tan(PHId)) ^ 2)))
    IX = ((Tan(PHId)) / (720 * rho * (nu ^ 5))) * (61 + (90 * ((Tan(PHId)) ^ 2)) + (45 * ((Tan(PHId)) ^ 4)))
    
    E_N_to_Lat = (180 / Pi) * (PHId - ((Et ^ 2) * VII) + ((Et ^ 4) * VIII) - ((Et ^ 6) * IX))

End Function

Function E_N_to_Long(East, North, a, b, e0, n0, f0, PHI0, LAM0)
'Un-project Transverse Mercator eastings and northings back to longitude.
'Input: - _
 eastings (East) and northings (North) in meters; _
 ellipsoid axis dimensions (a & b) in meters; _
 eastings (e0) and northings (n0) of false origin in meters; _
 central meridian scale factor (f0) and _
 latitude (PHI0) and longitude (LAM0) of false origin in decimal degrees.

'REQUIRES THE "Marc" AND "InitialLat" FUNCTIONS

'Convert angle measures to radians
    Pi = 3.14159265358979
    RadPHI0 = PHI0 * (Pi / 180)
    RadLAM0 = LAM0 * (Pi / 180)

'Compute af0, bf0, e squared (e2), n and Et
    af0 = a * f0
    bf0 = b * f0
    e2 = ((af0 ^ 2) - (bf0 ^ 2)) / (af0 ^ 2)
    n = (af0 - bf0) / (af0 + bf0)
    Et = East - e0

'Compute initial value for latitude (PHI) in radians
    PHId = InitialLat(North, n0, af0, RadPHI0, n, bf0)
    
'Compute nu, rho and eta2 using value for PHId
    nu = af0 / (Sqr(1 - (e2 * ((Sin(PHId)) ^ 2))))
    rho = (nu * (1 - e2)) / (1 - (e2 * (Sin(PHId)) ^ 2))
    eta2 = (nu / rho) - 1
    
'Compute Longitude
    X = ((Cos(PHId)) ^ -1) / nu
    XI = (((Cos(PHId)) ^ -1) / (6 * (nu ^ 3))) * ((nu / rho) + (2 * ((Tan(PHId)) ^ 2)))
    XII = (((Cos(PHId)) ^ -1) / (120 * (nu ^ 5))) * (5 + (28 * ((Tan(PHId)) ^ 2)) + (24 * ((Tan(PHId)) ^ 4)))
    XIIA = (((Cos(PHId)) ^ -1) / (5040 * (nu ^ 7))) * (61 + (662 * ((Tan(PHId)) ^ 2)) + (1320 * ((Tan(PHId)) ^ 4)) + (720 * ((Tan(PHId)) ^ 6)))

    E_N_to_Long = (180 / Pi) * (RadLAM0 + (Et * X) - ((Et ^ 3) * XI) + ((Et ^ 5) * XII) - ((Et ^ 7) * XIIA))

End Function

Should get you started...

It's E-Thru. Apparently a new (to me at least) shimano standard

Is anybody here well versed in rubber (MTB tyre) marks which appear to have permeated porous varnish? We're about to move out of our place and I've been trying to get ride of the stains for a millennia. Here's a picture:

Note that the stains are pretty much ingrained in the varnish, and nothing I've tried is shifting it. Any advice guys?

Get a darker varnish and go over it again.

As in the whole floor? It's a rental and we're moving out..

Maybe sand just those bits back and revarnish?

Cheers, that looks like it will do the job. There are some functions I can lift from there to transform them using VBA.

Going rate for a gardener per day or 'someone ideally with a tiny bit of knowledge about what's a weed and what's not'?

Since the baby I've let the garden go a bit wild. There's some dandelions the size of apple trees and an explosion of bindweed. I'd like the front lawn (3x4m) dug up and gravelled. I have the gravel just never get around to digging unless it's the middle of the night and figure that's a bit weird.

I'd like the back garden weeded and generally cut back for summer. Also like a hand clearing bits of broken shed and fence etc.

Is this a gardener or more a general handyish person and either way how much are we talking?

I figure by the time our son is about 6 months old he may be slightly less demanding of our time but by then the job could be significantly bigger at the rate of growth I'm seeing.

£150-£200 a day

What are some good porter style lights?

Ones that would go on a light bracket on my front rack..

ta

Annoying question. Someone on here maybe a month ago had various bits and bobs for sale including his and his girlfriends' climbing shoes. I can't for the life of me find the thread. Someone help me find it!

Yeah make sure to move out after especially if you don't do a great job of it.

£150-£200 a day

Post an ad at your local allotments: you'll be fighting retired geezers off with a blunt rake.

How are rapha shoes for sizing?

I was assuming that they would be the same as the giro equivalent

On raphas website they list the eu48 as a UK12.5 but also say it's the same as a 50 in sidi which according to Sidi is over a UK14

I've been happy with a pair of sidi dominators 49.5 but haven't found a pair of road shoes that I get along with.

I've mainly had specialized size 49 which caused pain in the arch of my feet.

Looking for something cool and "Euro"

2 Attachments