Monthly Archives: September 2015

Writing Efficient VBA UDFs (Part13): MaxMinFair Resource Allocation – an array UDF example

Last year we got to spend a great day at Microsoft Research in Cambridge (UK). one presentation was about storage strategies and featured (amongst other stuff) an interesting algorithm called MaxMinFair. The MaxMinFair algorithm You can read about it here … Continue reading

Advertisement

Posted in arrays, Calculation, UDF, VBA | Tagged , , | Leave a comment

Excel Circular References: Calculation, Detection, Control and Removal

Circular references in Excel are generally bad news: They are slow to calculate They can be hard to detect An intentional circular reference can mask an unintended circular reference, They do not always converge The Status Bar always shows calculate … Continue reading

Posted in Calculation | Tagged , , , | Leave a comment