Excel tips

Jun

Sometimes it comes in handy to be able to note a date or time quickly in Excel. This happens often when using Excel sheets for logging purposes and registration of laboratory experiments and results. This post illustrates how to make a drop-down with todays date where the entered date will not update automatically. Data validation for drop-down menus For this purpose the ...

Jan

Chaos in Excel, Deliberately!

Yes, I deliberately put Chaos in Excel! In form of a simulation of the logistic equation which shows non-linear behaviour for certain values of the feedback constant;-) The Excel workbook is available for download and make it possible to play around with the feedback constant and hopefully get a better understanding of non-linear behaviour a.k.a. Chaos. Have fun ;-) The Logistic ...