- #1
tinkeringone
- 15
- 0
Not sure, but apparently somebody threw some LOGS in my pendulum. HELP!
Trying to create a spreadsheet for calculating the friction coefficients in the pendulums I've been making. Here's the problem I just can't figure out.
μβ = ln (1+Z) − ln (1−Z)
where
Z = Δθ(L/d)
Δθ = 0.50 degrees
L = 1 meter
d = 18 mm, i.e. .018 meters
Z = 27.7777
I'm thinking that I already know that μβ = .34, but I can't figure out how to get Excel to calculate that right side of the formula, i.e. "ln (1−Z)", because 1-Z creates a negative value. So it's like you have to create some kind of imaginary number or something like Euler's?
Can anybody tell me how I can get Excel to calculate this, so I can enter my other pendulums into it?
Thanks,
Tinkeringone
Trying to create a spreadsheet for calculating the friction coefficients in the pendulums I've been making. Here's the problem I just can't figure out.
μβ = ln (1+Z) − ln (1−Z)
where
Z = Δθ(L/d)
Δθ = 0.50 degrees
L = 1 meter
d = 18 mm, i.e. .018 meters
Z = 27.7777
I'm thinking that I already know that μβ = .34, but I can't figure out how to get Excel to calculate that right side of the formula, i.e. "ln (1−Z)", because 1-Z creates a negative value. So it's like you have to create some kind of imaginary number or something like Euler's?
Can anybody tell me how I can get Excel to calculate this, so I can enter my other pendulums into it?
Thanks,
Tinkeringone