The following steps is required to make a USB drive a bootable drive and to copy a DVD / CD image on to it. This is useful if you want to create a USB drive which you can use to … Continue reading
Author Archives: Skouperd
ConvertDate is a function within ddGlobal and forms part of the ddDate suite of macros. It is used to convert various formats of dates into the text format YYYY-MM. Excel dates counts the days from January 01, 1900 up words. … Continue reading
ConvertToDays is a function within ddGlobal and forms part of the ddDate suite of macros. It is used to calculate the number of days that there is in the text value “YYYY-MM” from. This has limited use in Excel but … Continue reading
LargeDate is a function within ddGlobal and forms part of the ddDate suite of macros. It is use to obtain the largest date in a series of YYYY-MM text formatted dates. See the below example: TheRange 2013-03 2012-03 2005-01 2000-11 … Continue reading
CleanDate(ActiveDate) CleanDate and ddCleanDate are both functions within ddGlobal and forms part of the ddDate suite of macros. ddCleandate is kept just for compatibility with older spreadsheets but works the same as CleanDate. CleanDate will take various formats of numbers … Continue reading
ddBuildDate is a function within ddGlobal which forms part of the ddDate suite of macros. ddBuildDate uses the text field “YYYY-MM” or the numeric format “YYYYMM” to do date calculations on. So assume you have a number “200506” (June 2005) … Continue reading
ddGini is a function within ddGlobal and is use to calculate the Gini-coefficient, also known as the Gini-index or the Gini-Ratio. The calculation is generally use by statisticians to measure the inequality of income levels. Scorecard developers however abuse this … Continue reading
This gallery contains 17 photos.
Introduction Friday morning, phone rang. “Skoups, we have a serious problem, we need speed and we need it now! The budget is between R20,000 and R25,000 (about $2000 to $2500) and we need the PC by Sunday latest.” My first … Continue reading
This gallery contains 27 photos.
Introduction Despite recommending and reviewing several high-end cases for clients and friends, I have never really invested a lot of money or time in my own personal case. It has been several years since I even had something resembling a … Continue reading
This gallery contains 80 photos.
Introduction The following build was commissioned for running SQL as well as to act as an office’s main file server. Access to the SQL programs is via remote desktop whereas file serving is over the network. The brief for this … Continue reading