+ Reply to Thread
Results 1 to 7 of 7

Pull Down boxes and Tables

  1. #1
    Registered User
    Join Date
    11-07-2007
    Posts
    33

    Pull Down boxes and Tables

    OK, thanks to you guys I am nearly done with my project. Here goes the last part. I have a list of items in a drop down box, about 8 of them and they each have a different daily, weekly and monthly rate. Normally 3 days is the same cost as a week, and 3 weeks is the same as a month. Now thanks to you guys I have a table of about 7 cells that all I do is input the man hours, and it gives me how many months, weeks and days of rental charge there will be. How do I make it so a cell will reference the drop down box, use the correct price info for that particular equipment, the hours another cell says are needed and use the month/week/day calculater to make the right price. I have 2 cells open horizontal to each other if that helps. I was thinking maybe a different chart for each equipment using =sumproduct, but im not sure if that can be done, or if there is an easier way. Again, any help is GREATLY apreciated. Thanks in advance.

    ps ill give an example. shovel cost- $30/day $90/week $270/month
    hole digging will take 215 hours, so I need the shovel for 1 month, 1 week and 2 days. so the cost will be 270 + 90+ 60 = $420

  2. #2
    Forum Moderator Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,824
    Wow, at those prices you must work for the U.S. Government. How much do toilet seats and hammers go for?

  3. #3
    Registered User
    Join Date
    11-07-2007
    Posts
    33
    LOL, I was just throwing numbers out there to illustrate the pricing pattern.

  4. #4
    Forum Moderator Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,824
    Do you have a copy of your spreadsheet you can zip up and post? I'm assuming someone else helped you previously, so I'm not familiar with the layout you're using.

    Thanks.

  5. #5
    Registered User
    Join Date
    11-07-2007
    Posts
    33
    I had mostly gotten help with the month week day calculater. The rest is a company thing I've been trying to make better. I cant show you the main page, but Ill see about zipping the "data" page where I keep the tables and stuff.

    EDIT: Attached part of my form I use
    Attached Files Attached Files
    Last edited by Audiguy82; 12-10-2007 at 07:41 PM.

  6. #6
    Registered User
    Join Date
    11-07-2007
    Posts
    33
    Ok here is what I came up with. It seems kinda sloppy, and ill have to do a month/week/day calulater for every row (about 100) but that was the easiest way I could figure it out. Is there a way to make the calculater one cell maybe? I dont know, but any help awesome, my brain is fried. Ill check back tomorrow.BTW thanks for the help Pjaoquin, you are awesome man.

  7. #7
    Registered User
    Join Date
    11-07-2007
    Posts
    33
    Sorry I couldnt get back to the office for a couple days. So no one was able to crunch down the month/week/day calculater some how? If I could get it to just one cell instead of 11, that would be the answer to all my problems. I was thinking, maybe I would turn each column of the "calculater" to a named formula ( I thought I read something on that), and then a single cell would reference all 3 named formulas and turn that into three numbers seperated by commas, then the cost can use some sort of seperator to use the 3 numbers. I'm not sure if thats possible or if it is how to do it.
    Last edited by Audiguy82; 12-12-2007 at 02:25 PM.

+ 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