Daily posts of Excel tips…and other stuff
Archive for the ‘Miscellany’ Category.
Not quite Excel related but something I thought might be useful to others…
Some time back I wrote a JavaScript based webpage that let me search multiple web resources from a single page. Recently, I enhanced the page to support the addition of new search resources “on the fly.”
So, from this one page (http://www.tushar-mehta.com/search/web.htm) I [...]
Ever wondered what it means to have Excel multi-thread its calculations? On a 64bit I7 computer, crunching 500,000 rows of calculations for the Euler 36 problem resulted in the below. The display was from the 64bit version of the Process Explorer program (www.sysinternals.com though now a part of Microsoft at http://technet.microsoft.com/en-us/sysinternals/default.aspx).
HTML clipboard
Hi everyone,
With all these Euler posts I thought, why not post my own?
Suppose the following:
I have a products table set up like this:
Code ProdName Price
0001 Product1 556.68
0002 Product2 977.41
0003 Product3 350.62
0004 Product4 509.16
0005 Product5 748.4
0006 Product6 802.96
(list goes on to as much as 5000 products)
And I want to show this table in a userform and give the user some filtering possibilities (lets say on the first two [...]
Hi everyone,
I have had a Dutch article on XML and Excel on my site for quite some time now, but never got round to translating the thing into English.
Well, yesterday I found a bit of time during a long train-ride, so here it is:
XML And Excel
From the intro:
Microsoft Office 2003 Professional was the first Office [...]
Hi everyone,
Already 5 years have passed since I founded my company. And I must say those years passed in the blink of an eye.
I’ve never enjoyed my work as much as in these past years. Even if at times things were hectic and I worked crazy hours. I’ll never start working for a boss [...]
I signed up for Twitter a couple of months ago, made a few posts, and pretty much abandoned it. If you’re not familiar with it, Twitter is a micro-blog. You make posts of 140 characters or less. I don’t follow many people and I’m not sure what value this whole idea has. [...]
Hi All,
As many of you know I give away a number of tools for Excel through my site www.jkp-ads.com. Today I have updated the two most popular downloads:
Name Manager (which I created together with Charles Williams, www.decisionmodels.com):
Most important change: the unused names filter now includes objects in its search, as well as VBA code. It [...]
Hi all,
Let me start this post with a shameless plug: Charles Williams and I developed Name Manager. From my website alone this tool is good for about 60 downloads a day.
Just a couple of weeks ago, all of a sudden Charles and I started receiving complaints about compile errors, which neither of us could reproduce. [...]
