Results 1 to 6 of 6

Anyone use Excel/Access

| General - Let's talk business
  1. #1
    Abshere started this thread.
    Abshere's Avatar
    SMF Badges of Honor



    Member since
    Nov 2013
    Location
    WI
    Posts
    100
    Thanks
    22
    Thanked 96 Times in 35 Posts

    Anyone use Excel/Access

    I have been keeping track of what I take in by weight and amount of cash received using the ol' paper and pen style. Recently I loaded it all into Excel and messed around making reports in Access that automatically look at my Excel sheet as I update it.

    Looking to see if anyone else is using Excel or Access and see what you have for a template.



  2. #2
    Mechanic688's Avatar
    SMF Badges of Honor



    Member since
    Mar 2011
    Location
    Warsaw , Ind. In the heart of the lakes, and down the street from the hotel where Al Capone stayed.
    Posts
    9,577
    Thanks
    11,247
    Thanked 10,725 Times in 4,727 Posts
    P & M Recycling - Specializing in E-Waste Recycling.
    If you enjoy your freedom, thank a vet.

  3. The Following 4 Users say Thank You for This Post by Mechanic688:


  4. #3
    Abshere started this thread.
    Abshere's Avatar
    SMF Badges of Honor



    Member since
    Nov 2013
    Location
    WI
    Posts
    100
    Thanks
    22
    Thanked 96 Times in 35 Posts
    Apologize for creating a new post for something that was on here already. When I searched earlier, I hadn't found quite what I was looking that was why I posted. Thanks Mec.

  5. The Following User Says Thank You to Abshere for This Post:


  6. #4
    Abshere started this thread.
    Abshere's Avatar
    SMF Badges of Honor



    Member since
    Nov 2013
    Location
    WI
    Posts
    100
    Thanks
    22
    Thanked 96 Times in 35 Posts
    Just thought I would share what I came up with for my spreadsheet. I do not have access to the private forums yet. Any ideas or questions, let me know. This is actually my data, but I have been kind of hoarding stuff. I also have a blank version of this. My Sheet with explains what the 01,02,03 etc...is taped to the side of my monitor, but If you look at the TOT page that numbered sheets are in order going down the TOT page. Just changed all the sheet names so that I didn't have to scroll back and forth every time.

    https://drive.google.com/folderview?...00&usp=sharing

  7. The Following User Says Thank You to Abshere for This Post:


  8. #5
    auminer's Avatar
    SMF Badges of Honor



    Member since
    Nov 2012
    Location
    Allen, TX
    Posts
    1,244
    Thanks
    577
    Thanked 2,304 Times in 859 Posts
    OK...
    Here's a snippet of mine. I took October's & November's results, added some & subtracted some & changed some, so noone will scoff at how little money I'm making...

    https://app.box.com/s/h8qq66ag44hyb0636zm6

    Columns A, B, C, & D you have to enter when you get home from the yard. The functions in the other fields will populate the rest of the spreadsheet, with just a couple of exceptions.

    To populate column K, right click cell I38, then highlight every necessary cell in column K, then right click->paste special->Values.

    Column M same method from cell H38.

    Finally, Column S type in the date matching column A and columns T & U will populate.

    I'm sure there's a way to make excel do those things for you, but I haven't figured it out yet. I totally taught myself what little I know about excel by looking at other people's spreadsheets & seeing what functions, scripts, etc they used.

    You can inspect my functions (geez that sounded bad ... ) by highlighting any cell & looking at the Fx field up at the top.
    Out of clutter, find simplicity. --Albert Einstein

  9. The Following User Says Thank You to auminer for This Post:


  10. #6
    Sirscrapalot's Avatar
    SMF Badges of Honor


    Member since
    Mar 2012
    Location
    A sandbar off the atlantic..OBX,NC
    Posts
    6,124
    Thanks
    11,875
    Thanked 8,779 Times in 3,855 Posts
    My head hurts now, an the image I could do without of you having you functions inspected.

    Nice sheet, an thanks for sharing!

    Sirscrapalot - Any man or institution that tries to rob me of my dignity will lose. - Nelson Mandela 1918 - 2013


  11. Similar threads on the Scrap Metal Forum

    1. Public beach access
      By carolinajunkman in forum Scrap Metal Spots
      Replies: 12
      Last Post: 07-24-2012, 11:55 AM
    2. Looking for Excel template
      By Julie in forum General - Let's talk business
      Replies: 2
      Last Post: 06-25-2012, 02:44 AM
    3. Direct TV Access Cards
      By rca987 in forum General Electronics Recycling
      Replies: 14
      Last Post: 06-30-2011, 11:31 AM

Thread Information

Users Browsing this Thread

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

 
Browse the Most Recent Threads
On SMF In THIS CATEGORY.





OR

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
  •  

The Scrap Metal Forum

    The Scrap Metal Forum is the #1 scrap metal recycling community in the world. Here we talk about the scrap metal business, making money, where we connect with other scrappers, scrap yards and more.

SMF on Facebook and Twitter

Twitter Facebook