+ Reply to Thread
Results 1 to 3 of 3

Spreadsheet for waste pickup

  1. #1
    Forum Contributor
    Join Date
    06-28-2010
    Location
    London, England
    MS-Off Ver
    Excel 2013
    Posts
    101

    Spreadsheet for waste pickup

    Hi,

    I can't seem to come up with a solution to this and I've been working on it for a while.

    I work for a waste removal company and we are looking at changing out some of our old equipment and I am trying to design a spreadsheet that will allow me to enter the following variables:

    -size of current container
    -# of current containers
    -new container size
    -current pickups/week
    -new pickups/week
    -safety

    So what I am trying to accomplish here is to have something where I can enter in the current container sizes/numbers/pickup frequency, then enter in various different new container sizes that we are looking at as well as different pickup rates a week, then determine how many containers will be needed of the new size (ex. currently we have 3 8 cubic yard containers at a site that we empty twice a week, so if we switch those out to 6 cubic yard containers how many will we need to empty them only once a week?)

    I also seem to have problems getting the rounding correct, because if 20 cubic yards are generated in a week and i have a 25 cubic yard container obviously the container will only be 80% full at pickup yet I still need one container, not 0.8 of one. On the other side of that if I have 26 cubic yards of waste generated/week (26/25=1.04) I will need that number bumped up to 2, not rounded back down to 1.

    In terms of the safety, it would also be a nice feature to be able to add say for summer events where I know there will be a 25% increase in traffic in the area (therefore more waste) I will be able to tell right away how many more containers to add.



    I realize this is far more than just a simple question but any help would be very much appreciated. I am struggling for the most part in trying to come up with an equation that will take the garbage generated/week and tell me how many containers I will need (and round the answer correctly).


    Thank you very much.

    Dan
    Last edited by excelforum123; 12-05-2010 at 05:42 PM.

  2. #2
    Forum Contributor
    Join Date
    07-05-2006
    Location
    Canada
    MS-Off Ver
    2003, 2007
    Posts
    581

    Re: Spreadsheet for waste pickup

    Hi,

    I've attached something you might be able to work from. I've made the assumption that the garbage generated is equivalent to the current capacity at the site.

    There's a Special Event box where you can put in 100% for standard everyday levels, and lower or higher numbers if you think it would change.

    S
    Attached Files Attached Files
    ------------------------------------------------------------------------------------------
    If you need no more help on the current problem, please mark it as "Solved". It saves time
    as many of us will look at threads if they are not marked as "Solved".

    The instructions on how to do this are found in the Forum Rules thread that is at top of every forum.
    (Currently you'll have to look at point #9.)
    ------------------------------------------------------------------------------------------

  3. #3
    Forum Contributor
    Join Date
    06-28-2010
    Location
    London, England
    MS-Off Ver
    Excel 2013
    Posts
    101

    Re: Spreadsheet for waste pickup

    Thank you so much you have no idea how helpful that was.

    Appreciated!!

    Dan

+ 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