I believe I've figured out the needed change. I'll continue testing, and post an update next week.

Sounds good EP, thanks. Just curious, did JP make a change in Version 2 that messed things up for the formula? Just wondering if he was putting in an "Easter Egg" or whatever you call it for someone to discover lol

Yes, it seems that way. Previously, the zero day was 12/31/1987, so the time since that day was the basis for the sine and cosine formulas. And because of the 12-year disparity between real dates and game dates, that zero day would equate to 12/31/1999 for the in-game date.

This is now changed and the zero day appears to be 12/31/1999 (12/31/2027 in-game with the new 28-year disparity), so the sine and cosine functions are based on the elapsed time since this new date. Again, I haven't performed extensive tests yet, but I assert that this is the case. I've updated the spreadsheet, and it is attached. I've updated the file format to xlsx, and updated the chart to look a little sharper.

+EP+

Great work EP, I see you already added the 'twice' to your sig about cracking the fig and shield price formula, which I was going to suggest Thanks for the work you put in doing this again and 'finding the Easter Egg' or however one might want to put it.

Are prices really rounded only on-screen?

I bought holds, fighters and shields a couple of times, and calculated exactly how many credits I needed.

I was consistently off by a credit, +/-.

Yes, actual fractional prices are used but not visible. Use the formula or spreadsheet if you want the precision, otherwise round accordingly

+EP+