Can someone give me the Excel formula to calculate the tension of a string knowing it’s frequency, diameter, length, density? (And the appropriate units to use?)

Thanks.

Can someone give me the Excel formula to calculate the tension of a string knowing it’s frequency, diameter, length, density? (And the appropriate units to use?)

Thanks.

rho density g/cm^3

f frequency Hz

L length mm

d diameter mm

T = 10^-9*rho*f^2*L^2*pi*d^2 is tension in N

T/9.81 tension in kg

in excel you get pi by “pi()”

what he said, I was going to say, drag out the old Physics text, or look online, LOL!

In its infinite wisdom the message display decided to omit most of the asterisks I typed in the formula. For an excel formula those will obviously be required for multiplications.

Le 30/12/2020 17:14, Stephen Birkett via The Jackrail écrit :

rho density g/cm^3

f frequency Hz

L length mm

d diameter mmT = 10^-9

rhof^2L^2pi*d^2 is tension in N

T/9.81 tension in kgin excel you get pi by “pi()”

Many thanks, Stephen!

Le 30/12/2020 17:23, Anne Acker via The Jackrail écrit :

what he said, I was going to say, drag out the old Physics text, or look online, LOL!

I did look on line, but forgot to convert the N to kg, so that’s what

went wrong and why I asked.

Jackrail strikes again!

Dale

Stephen, asterisks are used in this forum for formatting text in italic and bold!

Why not use x for multiply and ^ for exponent?

David

Le 30/12/2020 18:46, David Pickett via The Jackrail écrit :

Stephen, asterisks are used in this forum for formatting text in italic and bold!

Why not use x for multiply and ^ for exponent?

Everything came out fine here. I needed it in Excelese, which means with

asterisks, etc.

Discourse uses Markdown for formatting, so you have to escape Markdown metacharacters. (Read the Site Usage category posts).

Asterisk in Markdown is a metacharacter.

This should not come as a suprise as Markdown has vast takeup for HTML formatting on the web. Here’s a guide:

You can learn the essentials adequate for posts in under five minutes.