Author Archives: Skouperd

Understanding Cache, latency and bandwidth

Posted on 2013/10/10 by Skouperd
Warning: is_dir(): open_basedir restriction in effect. File(/) is not within the allowed path(s): (/storage/content/05/1004705/blog.skoups.com/:/storage/configuration/wrappers/05/1004705/blog.skoups.com/:/tmp/) in /storage/content/05/1004705/blog.skoups.com/public_html/wp-includes/functions.php on line 2104 Warning: file_exists(): open_basedir restriction in effect. File(/) is not within the allowed path(s): (/storage/content/05/1004705/blog.skoups.com/:/storage/configuration/wrappers/05/1004705/blog.skoups.com/:/tmp/) in /storage/content/05/1004705/blog.skoups.com/public_html/wp-includes/functions.php on line 2095 Warning: is_dir(): open_basedir restriction in effect. File(/) is not within the allowed path(s): (/storage/content/05/1004705/blog.skoups.com/:/storage/configuration/wrappers/05/1004705/blog.skoups.com/:/tmp/) in /storage/content/05/1004705/blog.skoups.com/public_html/wp-includes/functions.php on line 2104 Warning: is_dir(): open_basedir restriction in effect. File(/) is not within the allowed path(s): (/storage/content/05/1004705/blog.skoups.com/:/storage/configuration/wrappers/05/1004705/blog.skoups.com/:/tmp/) in /storage/content/05/1004705/blog.skoups.com/public_html/wp-includes/functions.php on line 2104 Warning: file_exists(): open_basedir restriction in effect. File(/) is not within the allowed path(s): (/storage/content/05/1004705/blog.skoups.com/:/storage/configuration/wrappers/05/1004705/blog.skoups.com/:/tmp/) in /storage/content/05/1004705/blog.skoups.com/public_html/wp-includes/functions.php on line 2095 Warning: is_dir(): open_basedir restriction in effect. File(/) is not within the allowed path(s): (/storage/content/05/1004705/blog.skoups.com/:/storage/configuration/wrappers/05/1004705/blog.skoups.com/:/tmp/) in /storage/content/05/1004705/blog.skoups.com/public_html/wp-includes/functions.php on line 2104 Warning: is_dir(): open_basedir restriction in effect. File(/) is not within the allowed path(s): (/storage/content/05/1004705/blog.skoups.com/:/storage/configuration/wrappers/05/1004705/blog.skoups.com/:/tmp/) in /storage/content/05/1004705/blog.skoups.com/public_html/wp-includes/functions.php on line 2104 Warning: file_exists(): open_basedir restriction in effect. File(/) is not within the allowed path(s): (/storage/content/05/1004705/blog.skoups.com/:/storage/configuration/wrappers/05/1004705/blog.skoups.com/:/tmp/) in /storage/content/05/1004705/blog.skoups.com/public_html/wp-includes/functions.php on line 2095 Warning: is_dir(): open_basedir restriction in effect. File(/) is not within the allowed path(s): (/storage/content/05/1004705/blog.skoups.com/:/storage/configuration/wrappers/05/1004705/blog.skoups.com/:/tmp/) in /storage/content/05/1004705/blog.skoups.com/public_html/wp-includes/functions.php on line 2104
AIDA64 Cache & Memory Benchmark

This gallery contains 1 photo.

Building a fast system I have been asked on numerous occasions from the people who buy a new computer that they just want a fast computer. Over the years, I have always struggled with the terms of what exactly makes … Continue reading →

More Galleries | Leave a comment

Windows 7 Tips and Tweaks

Posted on 2013/05/05 by Skouperd

Introduction Hi everybody, now that Windows 7 is becoming the platform of choice, and becoming a lot more mature etc. I would like to know of any cool tweaks / adjustments tricks that you do to your systems to get … Continue reading →

More Galleries | Leave a comment

MaxNErr(TheRange)

Posted on 2013/03/08 by Skouperd

MaxNErr is a function within ddGlobal and forms part of the Func_Numeric suite of macros. This macro was originally created as I tend to use controlled errors in my formulas.  As such, since I want to be able to ignore … Continue reading →

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

SumNErr(TheRange)

Posted on 2013/03/08 by Skouperd

SumNErr is a function within ddGlobal and forms part of the Func_Numeric suite of macros. This macro was originally created as I tend to use controlled errors in my formulas.  As such, since I want to be able to ignore … Continue reading →

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

ddAverage(TheRange,Optional=Exclude)

Posted on 2013/03/08 by Skouperd

ddAverage is a function within ddGlobal and forms part of the Func_Numeric suite of macros. This function allows you to exclude specific numbers from your calculation. Assume you are given 100 accounts with a score assigned to it, but you … Continue reading →

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

AvgNErr(TheRange)

Posted on 2013/03/08 by Skouperd

AvgNErr is a function within ddGlobal and forms part of the Func_Numeric suite of macros. This macro was originally created as I actually love to have controlled errors in my formulas (especially the #N/A error) as there is a hidden … Continue reading →

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

ABSSum(TheRange)

Posted on 2013/03/08 by Skouperd

ABSSum is a function within ddGlobal and forms part of the Func_Numeric suite of macros.  ABSSum, or “absolute sum” will convert any negative number into a positive number and add that.  I wrote this function over a decade ago and … Continue reading →

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

DDay(StartDay,EndDay)

Posted on 2013/03/06 by Skouperd

DDay is a function within ddGlobal and forms part of the ddDate suite of macros.  It is use to calculate the “Difference” between two dates that is in the numeric format YYYYMMDD.  It assumes there is only 360 days in … Continue reading →

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

ddInTCK(Startdate,EndDate)

Posted on 2013/03/06 by Skouperd

ddInTCK is a function within ddGlobal and forms part of the ddDate suite of macros.  It is based on the famous, or infamous (depending on your point of view), SAS function called InTCK It will basically take two dates that … Continue reading →

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

BuildCurDate()

Posted on 2013/03/06 by Skouperd

BuildCurDate is a function within ddGlobal and forms part of the ddDate suite of macros.  The macro is straight forward and will use the current date (today), using the excel formula +now() and convert it into the text format YYYY-MM. … Continue reading →

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