Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
Daily Dose of Excel » All Tags » Miscellany (RSS)

Browse by Tags

  • Reasonable Contract Terms

    Several years ago, a potential client contacted me to work on a charting add-in. In the contract the client wanted me to sign was a clause that I would not create any chart that I created for this company and that I would never use any code that I used in creating its add-in. Given [...] Read More...
    Filed under: ,

  • How I Do

    From Walkenbach and Doctorow. Desktop: HP HPE-150f, i7 860@2.80, 8G RAM, Win7 64bit, Dual 22″ Acer monitors. I used to be strictly a laptop guy, but when the D810 died, I decided to go for a desktop. I’m happy I did. It’s quite a bit faster for the money. Laptop: ASUS R1F Convertible tablet, [...] Read More...
    Filed under:

  • Searching multiple web resources

    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 [...] Read More...
    Filed under:

  • Excel multi-threading calculations on 8 processors

    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 Read More...
    Filed under: , ,

  • My own Euler problem

    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 [...] Read More...
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.