Author Archives: Skouperd

ConvertDate(ActiveDate, Optional IsFromSas)

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

Posted in Articles, ddGlobal, Tips | Tagged , | Leave a comment

ConvertToDays(ActiveDate)

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

Posted in Articles, ddGlobal, Tips | Tagged , | Leave a comment

LargeDate(TheRange)

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

Posted in Articles, ddGlobal, Tips | Tagged , | Leave a comment

CleanDate(ActiveDate)

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

Posted in Articles, ddGlobal, Tips | Tagged , | Leave a comment

ddBuildDate(ActiveDate,Increment,Optional=OutFormat)

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

Posted in Articles, ddGlobal, Tips | Tagged , | Leave a comment

ddGini(TheBadRange,TheGoodRange)

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

Posted in Articles, ddGlobal, Tips | Tagged , | Leave a comment

How to make a USB drive bootable

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

More Galleries | Leave a comment

Breaking the mythical 3GB barrier using 8 OCZ Vertex 3 and a RocketRaid 2720SGL card

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

More Galleries | Leave a comment

Skoups wooden PC case build

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

More Galleries | 4 Comments

18TB SQL and File Server

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

More Galleries | Leave a comment