chandoo.org
SQL Queries from Excel: How to generate SQL Insert / Update queries from CSV / XLS data using formulas? | Chandoo.org - Learn Microsoft Excel Online
http://chandoo.org/wp/2008/09/22/sql-insert-update-statements-from-csv-files
Laquo; Back to blog. SQL Queries from Excel. Posted on September 22nd, 2008 in Learn Excel. Often when you are working on 2 incompatible systems and try to import data from one to another, excel can be a handy tool. I have used excel plenty of times to generate SQL insert / update statements which I could later execute on the database console. Here is a tutorial if you ever have to use excel to generate SQL statements. 1 Have your data ready. For our purpose the data is arranged like this:. Here is a sma...
successfulsoftware.net
Lessons learned from 13 failed software products | Successful Software
https://successfulsoftware.net/2010/05/27/learning-lessons-from-13-failed-software-products
8230;requires more than just good programming. Lessons learned from 13 failed software products. 8220;No physician is really good before he has killed one or two patients.” – Proverb. Software entrepreneur culture is full of stories of the products that succeeded. But what about the products that failed? We rarely hear much about them. This can lead to a very skewed perspective on what works and what doesn’t ( survivor bias. Why it was judged a commercial failure. The person taking the time to record the...
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?