Category Archives: ddGlobal

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