Celly
Board Regular
- Joined
- Jan 29, 2015
- Messages
- 84
- Office Version
- 2016
- Platform
- Windows
I understand Excel employs standard IEEE 754-1985 floating point math. I believe it uses 64-bit numbers on all platforms, but I'm not sure about that (comments?)
My question: is there any way to count the total number of floating point operations performed during the calculation of a workbook? I can exclude VBA from the equation and focus on cell formulas for now.
I have a large, complex simulation project employing iterative calculations across approximately 95.000 formula cells. It may be a useful metric for optimization, but mainly I'm just curious. I can't even ballpark the number of operations required by the simulation.
Oddly, I can't seem to find any threads on the subject.
My question: is there any way to count the total number of floating point operations performed during the calculation of a workbook? I can exclude VBA from the equation and focus on cell formulas for now.
I have a large, complex simulation project employing iterative calculations across approximately 95.000 formula cells. It may be a useful metric for optimization, but mainly I'm just curious. I can't even ballpark the number of operations required by the simulation.
Oddly, I can't seem to find any threads on the subject.