keithalewis

34 ms·

421.
by keithalewis 6y ago
Old school Excel add-ins. https://xlladdins.com .
422.
by keithalewis 6y ago
This reminds me of Bill Gates' comment about secretaries writing VBA. Thankfully, that didn't happen. My friend rides herd on all the python code written at BigBank. He said they now have over 1MM python scripts, "Most of the
423.
by keithalewis 6y ago
This article is remarkably well written. The first paragraph lays out why you would want to read it, or not. It then presents a well documented history of the problems it is solving to illustrate the whys and wherefores of the product. Well
424.
by keithalewis 6y ago
If you (are crazy enough to) do XLM programming then you will need this: https://github.com/xlladdins/xll/blob/master/docs/Excel4Macr...
425.
by keithalewis 6y ago
And any claim with one, doubly so. -- Abe Lincoln abe@I-chopped-the-cherry-tree.gov
426.
Compute derivatives of any order to machine precision(github.com)
3 points by keithalewis 7y ago|0 comments
427.
by keithalewis 7y ago
There is a simpler way to do this; https://github.com/keithalewis/epsilon/blob/master/README.md .
428.
by keithalewis 7y ago
If you use Microsoft's C SDK then you can write functions with limited side effects by declaring the function "uncalced". For example, you can peek at the current cell value of the function being called.
429.
by keithalewis 7y ago
Ya think? I like how Werner Heisenberg (re)invented matrix multiplication. If e_ij represents a transition from i -> j and e_ij e_kl = e_il if j == k and 0 otherwise, then A = sum_ij, a_ij e_ij represents the matrix A = [a_ij] and AB, us
430.
by keithalewis 7y ago
Another approach to AD is: https://github.com/keithalewis/epsilon .
431.
by keithalewis 7y ago
See https://github.com/keithalewis/epsilon for my approach to solving this problem.
432.
by keithalewis 7y ago
The new Excel dynamic arrays work with the good old C SDK too. Just return an array and the entire range is displayed.
433.
by keithalewis 8y ago
How about A Programming Language https://en.wikipedia.org/wiki/APL_(programming_language) ? Yeah, that's the ticket.
434.
by keithalewis 8y ago
If you know C++ and want to embed C++ objects in Excel you can use a library I wrote. Here is an example of how single inheritance works: https://github.com/keithalewis/xll12/blob/master/sample/hand.
435.
by keithalewis 8y ago
It's funny/not funny nobody can give a concrete example of how to apply this. AFAICT the last (only?) example in the paper is about copying memory. I know an easier way to do that.
436.
by keithalewis 8y ago
The author is correct that checking if two functions having infinite domains are equal is often impossible. He also has correct statements of some mathematical theorems. But people in this thread have provided counterexamples to his claim.
437.
by keithalewis 8y ago
Balderdash, as others have more graciously pointed out. How wrong do you have to be before having your nonsense deleted from HN?
438.
by keithalewis 8y ago
TL;DR IOWs, you need to understand how computers work.
439.
by keithalewis 8y ago
It will not become popular for one simple reason: you have to be smart to understand it. Want to be popular? Write a python^Wlanguage for people who shouldn't even be programming in the first place.
440.
by keithalewis 9y ago
Ex FT for not spellchecking what they paid you to write?
441.
Show HN: Probability Preliminaries(kalx.net)
2 points by keithalewis 9y ago|1 comments
442.
by keithalewis 9y ago
This. And a small Makefile to run pandoc.
443.
by keithalewis 9y ago
This. But it does give python weenies an excuse to fool themselves into believing they are "programmers."
444.
by keithalewis 10y ago
Still trying to figure out how to add a simple function to Excel. This is an old attempt at adding a function `double` that doubles it's argument. http://kalx.net/ExcelUDF.html Seems to no longer work.
445.
by keithalewis 14y ago
Because nobody will pay for it. Seriously though, as many others have pointed out, you need human beings that knows something about software engineering in the process. My clients won't spend time specing out what they want. Often they don'
446.
by keithalewis 14y ago
Like this: http://xllfunctional.codeplex.com/ . Not easy to use at all, but it is possible. Barely.