Skip to content

Instantly share code, notes, and snippets.

@eruffaldi

eruffaldi/Excel Lambda

Created January 9, 2024 08:11
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save eruffaldi/dd2d2e79d3d6249f11fef2fa80298546 to your computer and use it in GitHub Desktop.
Save eruffaldi/dd2d2e79d3d6249f11fef2fa80298546 to your computer and use it in GitHub Desktop.
Download ZIP
Calculate solid angle of Rotation Roll-Pitch-Yaw in Excel
Raw
Excel Lambda
=LAMBDA(r,p,y,ARCCOS((COS(p)*COS(r)+COS(p)*COS(y)+COS(y)*COS(r)+SEN(p)*SEN(r)*SEN(y)-1)/2))(A3,B3,C3)
@eruffaldi
Copy link
Author

The above is an example of invocation of the Lambda using RPY from A3,B3,C3

Input in Radians and output in Radians. The degree version can be easily implemented.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment