Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

Browse by Tags

  • Euler Problem 102

    Euler Problem 102 asks: 'Three distinct points are plotted at random on a Cartesian plane, for which '-1000 LTE x, y LTE 1000, such that a triangle is formed. ' 'Consider the following two triangles: ' 'A(-340,495), B(-153,-910), C(835,-947) ' 'X(-175,41), Y(-421,-714), Z(574,-645) ' 'It can be verified that triangle ABC contains the origin, whereas 'triangle XYZ does not. ' 'Using triangles.txt (right click and 'Save [...] Read More...
  • Recursion as a performance boost!

    A common misconception some (many?) have about recursive solutions is that they are not fast. There are many reasons to use recursion, both in code and in data, mainly that solutions based on recursion are easy to implement, understand, and maintain. For an introduction see Recursion (http://www.tushar-mehta.com/publish_train/book_vba/07_recursion.htm). What is interesting is that recursive solutions [...] Read More...
  • Euler Problem 22

    Euler Problem 22 asks: 'Using names.txt (right click and 'Save Link/Target As...'), a 46K text file containing over 'five-thousand first names, begin by sorting it into alphabetical order. Then working out the 'alphabetical value for each name, multiply this value by its alphabetical position in the list 'to obtain a name score.   'For example, when the list is sorted into [...] Read More...
  • Bubble Sorts

    Two problems so far, Eulers 22 and 29, have required sorts, at least for my implementations. Euler 22 sorts over 5000 name strings, and Euler 29 sorts nearly 10,000 numerics. In both cases I used a bubble sort. Bubble sorts get their name from the image of the greater-valued item "bubbling up" [...] Read More...
  • I Resolve

    For 2009, I resolve to stop keeping detailed track of my time at work. It started as a small experiment to see where I was spending my time. There weren’t any real surprises in the data. I guess one surprise was how easy it was to use the tool I built to [...] Read More...
  • Euler Problem 19

    Euler Problem 19 asks: 'You are given the following information, but you may prefer to do some 'research for yourself. ' '    * 1 Jan 1900 was a Monday. '    * Thirty days has September, '      April, June and November. '      All the rest have thirty-one, '      Saving February alone, '      Which has [...] Read More...
  • Euler Problem 55

    Problem 55 asks: 'If we take 47, reverse and add, 47 + 74 = 121, which is palindromic. ' 'Not all numbers produce palindromes so quickly. For example, ' '349 + 943 = 1292, '1292 + 2921 = 4213 '4213 + 3124 = 7337 ' 'That is, 349 took three iterations to arrive at a palindrome. ' 'Although no one has proved it yet, it is [...] Read More...
  • Euler Problem 31

    Euler Problem 31 states: 'In England the currency is made up of pound, £, and pence, p, and there are 'eight coins in general circulation: ' '    1p, 2p, 5p, 10p, 20p, 50p, £1 (100p) and £2 (200p). ' 'It is possible to make £2 in the following way: ' '    1×£1 + 1×50p + 2×20p + 1×5p + 1×2p [...] Read More...
  • Euler Problem 16

    Hello All - While Dick and company do the heavy lifting around here writing about VBA Frameworks, I asked if I could contribute about lighter fare, specifically the Project Euler Challenges. I am a systems engineer by trade, and use Excel as a tool to manage requirements. I confessed to Dick I have probably [...] Read More...
  • New Contributor

    Long time reader Michael Tollefson has been messing around with Project Euler. He has graciously offered to post some of his exploits here. Expect some posts from Michael soon. Read More...
  • AutoFiltering on Months

    I need a quick way to create a filter by month on an autofiltered range. Right now I'm manually entering this: That's tedious. One option is to create another column with just the month and year in it and filter on that, but I don't like my data cluttered. So I wrote this [...] Read More...
  • XML and Excel

    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 [...] Read More...
  • Table Tools in Excel 2007

    Hi all This week I create a small Add-in to add a few options to the contextual Table Tools tab. This is a start and love to have feedback what you miss or like to see in a add-in like this. This are now the options in the Add-in 1) Turn AutoFilter On or Off 2) Clear Filter of the [...] Read More...
  • Disable Excel 2003 Menu Accelerators keys in Excel 2007

    Hi all If you create a dictator application in Excel 2007 you maybe want to disable the shortcuts to the old Excel 2003 menu items in Excel 2007. I create this page with example code to do this. Note: There is no test on this moment to see if a tag is already used. http://www.rondebruin.nl/acceleratorskeys.htm If you want to have a [...] Read More...
  • Free Financial Advice

    At some point in the future, we’re going to look back at the stock market during this financial crisis. If we take a broad enough view, we’ll see something like this: If you move your long-term common stock investments into money market accounts (basically cash) now, you’ll probably be doing it at the worst time [...] Read More...
1 2 3 4 Next >
Copyright Excel User Group and the relevant contributors, 2008. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.