# Thread: Need help shifting a graph 180*

1. ## Need help shifting a graph 180*

I'm making a spreadsheet for things engine/internal combustion related and, me being not the smartest, am running into troubles, simple stuff for a few of you I'm sure.

My basic question right now is this,

How do I shift this 180*?
Code:
=Sheet1!$B$31*(COS(RADIANS(E4))-(($B$8/$B$6)*SIN(RADIANS(E4))^2)/(SQRT(1-($B$8^2/$B$6^2)*SIN(RADIANS(E4))^2)))
B31= Dynamic Compression (this is what you measure with a compression tester)
E4= Crank Angle in degrees
B6= Rod Length

Guessing it's something rather simple and I'm just not seeing it.

Also will the answer work for shifting variations of a 720* total combustion cycle?
Say for a V8, V6, I4 ... each piston is at a different point in the cycle and thus a different point on the graph.

Hopefully this makes sense.

Thanks in advance for any assistance.
BTW, this isn't homework/school related, simply for my personal benefit.

2. Originally Posted by iminhell
I'm making a spreadsheet for things engine/internal combustion related and, me being not the smartest, am running into troubles, simple stuff for a few of you I'm sure.

My basic question right now is this,

How do I shift this 180*?
Code:
=Sheet1!$B$31*(COS(RADIANS(E4))-(($B$8/$B$6)*SIN(RADIANS(E4))^2)/(SQRT(1-($B$8^2/$B$6^2)*SIN(RADIANS(E4))^2)))
B31= Dynamic Compression (this is what you measure with a compression tester)
E4= Crank Angle in degrees
B6= Rod Length

Guessing it's something rather simple and I'm just not seeing it.

Also will the answer work for shifting variations of a 720* total combustion cycle?
Say for a V8, V6, I4 ... each piston is at a different point in the cycle and thus a different point on the graph.

Hopefully this makes sense.

Thanks in advance for any assistance.
BTW, this isn't homework/school related, simply for my personal benefit.
What os wrong with:

=Sheet1!$B$31*(COS(RADIANS(E4+180))-(($B$8/$B$6)*SIN(RADIANS(E4+180))^2)/(SQRT(1-($B$8^2/$B$6^2)*SIN(RADIANS(E4+180))^2)))

CB