Jump to content

Excel help

TheRedViper
By TheRedViper
in Off Topic
 Share
Go to solution Solved by TheRedViper,
11 minutes ago, straight_stewie said:

What SIN function are you looking for?

Nevermind, thx for helping though. Got it to work 

 

=3*SIN(4*PI()*B39+PI()/2)

Posted

I have some timestamps that I want in a grid and apply those to a parameter of an electrical sinus function that would be the second column. However the SIN function that excel offers is not the one im looking for (SIN(insert rad/180)).

 

Capture sinus.PNG

 

The timestamps will basically replace the t in the equation 

When i tried this it gave me a value error: 3*SIN(4*3.1416*B38(which is the first time cell)+3.1416/2)

CPU: Intel Core i9-10900K  MOBO: ROG MAXIMUS XII FORMULA GPU: 2080ti Hall of Fame 10th anniversary limited edition  PSU: Asus ROG THOR 1200W  COOLER: Optimus foundation black acetal RADS: 3x EKWB CoolStream PE 360  LOOP: EKWB torque HDC fittings / EKWB ZMT 15,9/9,5mm / EKWB CryoFuel Clear MONITOR: Acer predator X34

Link to comment
https://linustechtips.com/topic/772119-excel-help/
Share on other sites
Link to post
Share on other sites
Posted
  • Author
3 minutes ago, straight_stewie said:

What SIN function are you looking for?

The one from the first picture. Its a sinus with angular speed and phase vector

CPU: Intel Core i9-10900K  MOBO: ROG MAXIMUS XII FORMULA GPU: 2080ti Hall of Fame 10th anniversary limited edition  PSU: Asus ROG THOR 1200W  COOLER: Optimus foundation black acetal RADS: 3x EKWB CoolStream PE 360  LOOP: EKWB torque HDC fittings / EKWB ZMT 15,9/9,5mm / EKWB CryoFuel Clear MONITOR: Acer predator X34

Link to comment
https://linustechtips.com/topic/772119-excel-help/#findComment-9744042
Share on other sites
Link to post
Share on other sites
Posted
  • Author
  • Solution
11 minutes ago, straight_stewie said:

What SIN function are you looking for?

Nevermind, thx for helping though. Got it to work 

 

=3*SIN(4*PI()*B39+PI()/2)

CPU: Intel Core i9-10900K  MOBO: ROG MAXIMUS XII FORMULA GPU: 2080ti Hall of Fame 10th anniversary limited edition  PSU: Asus ROG THOR 1200W  COOLER: Optimus foundation black acetal RADS: 3x EKWB CoolStream PE 360  LOOP: EKWB torque HDC fittings / EKWB ZMT 15,9/9,5mm / EKWB CryoFuel Clear MONITOR: Acer predator X34

Link to comment
https://linustechtips.com/topic/772119-excel-help/#findComment-9744064
Share on other sites
Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing Off Topic

×