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

December 2008 - Daily Dose of Excel

Sort by: Most Recent | Most Viewed | Most Commented

  • 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...
    Filed under:

  • 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...
    Filed under:

  • 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...
    Filed under:

  • 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...
    Filed under:

  • UDFs and Moving Add-in Files

    I don’t use user defined functions in add-ins all that often, but I happen to have a particular add-in with one UDF. And I happened to have recently moved that add-in. And all my links happen to be broken. Fortunately, Jan Karel has an exhaustive write-up on how to fix and prevent this problem. [...] 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...
    Filed under:

  • 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...
    Filed under:

  • VBA Framework II

    See VBA Framework for the first revision. For this revision, you can select which VBProject in which to add the code and you can identify a parent class. I refactored the code to use a class module to make the code more readable. Concatenating strings is always messy, so I hope this helps a little. [...] Read More...

  • Bowl Picking

    It’s college football bowl season once again. I have a spreadsheet I use to help me identify winners and losers (for entertainment purposes only). The four yardage columns are yards per game for rushing offense, rushing defense, passing offense, and passing defense, respectively. I’m trying to identify teams that have better defenses (because defense [...] Read More...

  • Create Unique List from Selected Cells

    Well, it's almost next year and you know what that means: New vendor files. I need to create a couple hundred labels for next year's vendor files. I started by exporting all of the bills from all of the vendors for this year. Next, I'm going to count and sum the bills. [...] Read More...
    Filed under:

  • VBA Framework

    In Create Classes... I had this todo list: Create the class module rather than copy and paste Name the class module based on the table name Select the database and table from a list on a userform Establish Parent Child relationships between two classes Create functions to fill the class from a recordset Create a userform to add/edit/delete records I need to [...] Read More...

  • UK Excel User Group Conference

    A meeting of the above group will take place on Wednesday 1st and Thursday 2nd April 2009 in London. This FREE event has some fantastic speakers from the Excel community. The agenda for the two days is outlined below and you can book for either or both days by emailing bookings@excelusergroup.org. Microsoft will be providing the venue [...] Read More...
    Filed under: ,
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.