Hey guys I've created a spreadsheet (albeit a fairly basic one) to help claculate X, Y, and Z positions and rotations for runtime placement of objects. The cool thing about it is I've set up the cell formats in such a way that the spreadsheet will generate a function for you to simply copy and paste into your script editor.

http://i.imgur.com/EN9AUA7.png

https://skydrive.live.com/redir?resid=CF56C905BF540EFB!498&authkey=!AKtEal1BV7A8zY0&ithint=file%2C.xlsx

How does it work?

The best way to know your point of reference calculations is to lay out two object in the Creation Kit, one being the object that's your reference (for example the Player), and the other being what will be spawned (at least, something in the spot you'd like an object to spawn). You can move them about until you're happy with their positioning, and then simply load the X, Y, and Z positions and rotation angles into the spreadsheet.

Why would this be helpful?

Say in your mod you want to place a floating orb in-game via a PlaceAtMe() function, and you need it to be in a relative position to another object that moves; like the player. An example would be spawning a creature similar to Link's fairy companian in the Legend of Zelda games. If you want that fairy to spawn and be placed always above the player's head by 30 units, and angled to the player's left, for example, you need to calculate those variables. That's where this spreadsheet will help.

How much are you charging for this magnificent creation?

I want only your soul for all eternity.

Will you make more complex calculation spreadsheets?

If I need one, yes, and I'll make that available also.