excelicious.wordpress.com
Python – Number Cruncher
https://excelicious.wordpress.com/code-samples/python
While I primarily write code in VBA and SAS for my work, I have been fooling around with Python for quite a while. I have to say I vastly prefer the syntax to VB – in my opinion it’s a lot cleaner and simpler, meaning a lot more done with a lot less work. For that reason, I chose to attack the Project Euler. If you like, you can download all the functions in a single file here. Leave a Reply Cancel reply. Enter your comment here. Fill in your details below or click an icon to log in:. On Type or Class?
excelicious.wordpress.com
A couple of PowerShell scripts – Number Cruncher
https://excelicious.wordpress.com/2015/03/23/a-couple-of-powershell-scripts
A couple of PowerShell scripts. March 23, 2015. March 24, 2015. I’ve been making a little more use of PowerShell recently. It’s a very handy addition to the Windows environment, certainly it’s a lot easier to use than the traditional command line, and it’s a lot easier to find your way around. I figured I’d share a couple of the scripts I’ve used for some specific tasks to do with file management, in case someone found this handy. Etls w s = s) (etls recnt[,=]) )-1 # Extract lines from SAS ETL source cod...
excelicious.wordpress.com
VBA – Number Cruncher
https://excelicious.wordpress.com/code-samples/vba
Some samples of my VBA code…a lot of these you will find in a blog post someplace, but I figured it’d be ideal to group them somewhere central. Leave a Reply Cancel reply. Enter your comment here. Fill in your details below or click an icon to log in:. Address never made public). You are commenting using your WordPress.com account. ( Log Out. You are commenting using your Twitter account. ( Log Out. You are commenting using your Facebook account. ( Log Out. Notify me of new comments via email. Wellington...
excelicious.wordpress.com
Math functions – Number Cruncher
https://excelicious.wordpress.com/code-samples/python/math-functions
A few functions that aren’t contained in the math module – I’ll continue to add to these as time permits. A recursive implementation of Euclid’s algorithm to find the greatest common divisor of two numbers:. Def gcd(a,b): pre: a, b ve integers calcalates gcd by Euclid c = max(a, b) d = min(a, b) if c%d = 0: return d else: return gcd(d, c%d). Using the gcd function to return the least common multiple:. Def lcm(a, b): pre: a, b ve integers returns least common multiple of a and b return a*b/gcd(a, b).
excelicious.wordpress.com
Downloads – Number Cruncher
https://excelicious.wordpress.com/downloads
Regular Expressions Excel Add-in. 8211; latest and greatest version, compatible with 2007/10 only. Features a fancy new form to evaluate regular expressions against a test string, as well as all the old worksheet functions. 8211; to go with the above version. 8211; the original version for those still using Excel without a Ribbon. Nothing fancy here, just the worksheet functions. One thought on “ Downloads. Pingback: Regular Expressions – new version « Number Cruncher. Leave a Reply Cancel reply. A Byte ...
excelicious.wordpress.com
Lags and Unintended Consequences – Number Cruncher
https://excelicious.wordpress.com/2012/06/27/lags-and-unintended-consequences
Lags and Unintended Consequences. June 27, 2012. Analytic functions like LAG, LEAD, FIRST VALUE and LAST VALUE are a very useful addition to Oracle SQL, enabling retrieval of aggregate results without the need for self-joins. LAG, for instance, will allow you to get the value of a column from the previous row in a group of rows. The report returns for a given office any transfers in or out of a specified office over a period bounded by STDATE and ENDDATE. So what can we do about this? Well, some people w...
excelicious.wordpress.com
Code Samples – Number Cruncher
https://excelicious.wordpress.com/code-samples
Here I’ll be placing some samples of code I’ve written. Feel free to use or improve anything that’s in here, or comment if you have suggestions or anything else to add. Leave a Reply Cancel reply. Enter your comment here. Fill in your details below or click an icon to log in:. Address never made public). You are commenting using your WordPress.com account. ( Log Out. You are commenting using your Twitter account. ( Log Out. You are commenting using your Facebook account. ( Log Out. Summing a random sample.
excelicious.wordpress.com
Random Sampling in VBA – Number Cruncher
https://excelicious.wordpress.com/2009/02/07/random-sampling-in-vba
Random Sampling in VBA. February 7, 2009. February 8, 2009. Occasionally we get asked to provide random samples from our database, and it’s the sort of thing that can be done very easily in SAS. For example, here’s a SAS routine I have often used to extract a sample. Of size 100 without replacement from a large dataset. I can’t remember where this code originally came from but I definitely can’t take credit for it):. Data sampleset (drop=remainder size);. Do while (size 0);. LOb = lOb 1. On Type or Class?
excelicious.wordpress.com
FP Library – Number Cruncher
https://excelicious.wordpress.com/code-samples/python/fp-library
Some code from a recent session learning about functional programming…. Leave a Reply Cancel reply. Enter your comment here. Fill in your details below or click an icon to log in:. Address never made public). You are commenting using your WordPress.com account. ( Log Out. You are commenting using your Twitter account. ( Log Out. You are commenting using your Facebook account. ( Log Out. You are commenting using your Google account. ( Log Out. Notify me of new comments via email. How do you SQL in Excel?
excelicious.wordpress.com
Utility functions – Number Cruncher
https://excelicious.wordpress.com/code-samples/vba/utility-functions
Functions which can be re-used across projects. RefreshAdvancedFilter is a convenience function which, well, refreshes an advanced filter. This lets you take advantage of the Excel advanced filter to extract entries from a range based on specified criteria. Using the database rngSource, manipulate the parameters to an SQL-like query in rngCriteria to produce the extract in rngExtract. Sample Array takes a random sample without replacement from an array:. Leave a Reply Cancel reply. Enter your comment here.
SOCIAL ENGAGEMENT