I am hoping to create an excel formula (well not me as it way beyond my capabilities but hoping someone can do it for me :) ) to be able to work out the distance between two shaft's with different sized pulleys (which could change) on each shaft along with a known belt length which could change. i.e. pulley 330mm pulley 120mm belt length 1499mm = 380mm centres between shafts

Currently i have found a formula that if i know both pulley sizes and the centres between shafts it will give me the belt length as below:

lb = (dm ?

king1,
Sep 5, 10:18pm

literally, stick each of these values into a seperate cell - df, dm, ?

ross1970,
Sep 5, 10:32pm

For a start, simplify your notation: L = length of belt D = diameter of large pulley d = diameter of small pulley c = centers

ross1970,
Sep 5, 10:53pm

L = (pi/2)(D+d) + 2c + ( 2(D-d) / (4c) )

. is to me, more "readable".

emmerson1,
Sep 6, 12:01am

Did you know that if you select a cell range (even a single cell), you can give it a meaningful name?

Select your cell, and put the name 'D' for instance, in the drop-down box just above column 'A'. Now you can type your nice formula.

dino7,
Sep 6, 10:07pm

Thanks everyone, I'm going to have a go at the weekend by following your help - I'm barely intermediate on excel infact i'm bordering on beginner ;)

ross1970,
Sep 6, 10:59pm

Would be a simple function in javascript you could run in your browser console if you wanted to flag using excel.

dino7,
Sep 7, 6:50am

thats not simple for me Ross - yes it would be handy to have it on my phone in either excel or on a browser

ross1970,
Sep 7, 9:14am

There's any number of webpages that calculate v-belt length for you. Bookmark one you like.

wotz_it_2_ya,
Sep 7, 5:04pm

But now change it to solve for c, which is the question. Too hard for Friday afternoon

ross1970,
Sep 7, 7:04pm

C = [??? { (L - R ?

ross1970,
Sep 7, 7:53pm

Not really. Visualize 2 triangles, top and bottom ( bottom inverted ), where the hypotenuse of each, is the belt running between the pulleys, and the bases of the triangles are parallel to C, and obviously equal to C. Subtract from L, the belt that curls around the outside of the pulleys . ( L - R ?

dino7,
Sep 7, 10:58pm

Although as above i would prefer the centres knowing both pulley/flywheel diameters and the belt size - not found a site that does that.

ross1970,
Sep 9, 7:05pm

Yip well there's the eq in #11. Go for it .

Regarding using the v-belt length calculators online. Altho they are calculating belt length, you can still simply put in the 2 pulley sizes, put in a random center length to generate a starting belt length, then you just adjust the centers value up or down until the belt length shown matches the belt length you have. And you there u have the center value you wanted.

Since the public registrations are closed, you must have an invite from a current member to be able to register and post in this thread.
Have an account? Login here.