+ Reply to Thread
Results 1 to 11 of 11

Collection of Excel Projects - Post yours here

  1. #1
    Forum Contributor
    Join Date
    12-30-2009
    Location
    US
    MS-Off Ver
    Excel 2010 & 2016
    Posts
    104

    Collection of Excel Projects - Post yours here

    I would love to start a thread and have people post a variety of their excel projects that may be useful to others. Even if the specifics of what it does do not apply, the spreadsheet may do something that I could use/implement in the future. I'll start by posting this one. This is a project I built to go out to a website and fetch various interest rates. It's nice because it's in one spot and it makes for easy instruction to someone else. It could also be used to fetch other information. I'll dig around my old files and see if I have other cool projects to post, but I would love to see others.

    I'm a banker, so spreadsheets with numbers, calculations, etc... always come in handy.
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2016 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    30,365

    Re: Collection of Excel Projects - Post yours here

    Nice idea, but in the wrong place, Iím afraid, as the main forum sections are for problem-solving. Iíve moved this to The Water Cooler.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  3. #3
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,643

    Re: Collection of Excel Projects - Post yours here

    Why 122 connections in 1 file ?



  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    15,665

    Re: Collection of Excel Projects - Post yours here

    Here is a template for US taxpayers to determine their cash flows in retirement. Have you saved enough to retire?
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    04-26-2015
    Location
    Toronto, Canada
    MS-Off Ver
    2010
    Posts
    379

    Re: Collection of Excel Projects - Post yours here

    This worksheet is a perpetual Public Holiday Schedule for Canada,(Ontario) UK,(England), South Africa and the USA (DC Area). Using the current dates provided, adjustments are made for dates that fall on Saturday & Sunday, and it also contains the Easter Dates. Dates can vary for the UK, the States and Provinces so these do need to be checked where necessary, however I find it useful for Conditional Formatting Employee Shift Schedules of which I seem to do a lot of. ($$)

    Updates and revised workbook now includes South Africa.
    Attached Files Attached Files
    Last edited by BlindAlley; 08-02-2019 at 03:11 PM.
    Uploading an attachment will assist Forum Members in finding the correct Solution for you. Create a dummy worksheet if necessary, add your start data and show where / what your expected results should be. TO ADD A FILE:

    Go to 'Advanced. click on 'Manage Attachments. Select 'Browse & Choose your file, Select 'Upload and then close the Attachment window.

  6. #6
    Forum Contributor
    Join Date
    12-30-2009
    Location
    US
    MS-Off Ver
    Excel 2010 & 2016
    Posts
    104

    Re: Collection of Excel Projects - Post yours here

    Quote Originally Posted by snb View Post
    Why 122 connections in 1 file ?
    Sorry, I'm not sure what you mean.

  7. #7
    Forum Contributor
    Join Date
    12-30-2009
    Location
    US
    MS-Off Ver
    Excel 2010 & 2016
    Posts
    104

    Re: Collection of Excel Projects - Post yours here

    Quote Originally Posted by alansidman View Post
    Here is a template for US taxpayers to determine their cash flows in retirement. Have you saved enough to retire?
    I tried to open this, but it looks like it is corrupt.

  8. #8
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    15,665

    Re: Collection of Excel Projects - Post yours here

    Rick

    Opens ok for me. Not sure what your issue is. It is a Macro driven file that opens to Splash Page that provides instructions. It was originally written in 2003 .xls format which I have not updated nor felt a need as it works in all Excel upgrades that I have used including my current 2019 version.

  9. #9
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,418

    Re: Collection of Excel Projects - Post yours here

    for xls files, save the workbook, then open it, rather than trying to open directly from the link.
    Entia non sunt multiplicanda sine necessitate

  10. #10
    Forum Guru Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    5,637

    Re: Collection of Excel Projects - Post yours here

    Quote Originally Posted by Rick-O-Shay View Post
    Sorry, I'm not sure what you mean.
    The workbook you shared has lots of data connections in it - actually 124 of them:

    Please Login or Register  to view this content.
    Capture.PNG
    Last edited by Olly; 07-22-2019 at 06:54 AM.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  11. #11
    Forum Contributor
    Join Date
    12-30-2009
    Location
    US
    MS-Off Ver
    Excel 2010 & 2016
    Posts
    104

    Re: Collection of Excel Projects - Post yours here

    Sorry, I guess I just don't know enough to understand. I put together the VBA code to import the data from the websites. My knowledge is limited in this area so I just don't know. Is there a way to accomplish what I have done in a cleaner manner?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1