Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-13-2011, 04:08 AM
UnholySmoke UnholySmoke is offline Excel Calculation Problem Windows XP Excel Calculation Problem Office 2007
Novice
Excel Calculation Problem
 
Join Date: Sep 2011
Posts: 3
UnholySmoke is on a distinguished road
Default Excel Calculation Problem

Hi,

I have a list of items in Excel, each of which has two values attached, credit and hours.

There's a requirement that a choice of items needs to be made such that their total credit is above a certain value. I then need to find out which valid combination of units has the lowest number of hours. Example:



Minimum credit from group = 10

Item 1 - 5 credits, 5 hours
Item 2 - 5 credits, 5 hours
Item 3 - 5 credits, 7 hours
Item 4 - 10 credits, 12 hours

I'd like this to return 'Minimum hours for group = 10' and ideally let me know that this is the combination of Items 1 & 2.

If Item 4 had been, say, 8 hours, then that on its own would have been the smallest 'combination' meeting the rules. I'm not convinced Excel even knows how to do this, does anyone have any thoughts? I can find the minimum hours value per units but it's the caveat of a minimum total credit that's giving me trouble.

Thanks,

Ben
Reply With Quote
  #2  
Old 09-13-2011, 04:44 AM
OTPM OTPM is offline Excel Calculation Problem Windows 7 32bit Excel Calculation Problem Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi Ben
Can you post a copy of your spreadsheet so we can see exactly what you have done so far.
Tony(OTPM)
Reply With Quote
  #3  
Old 09-14-2011, 08:15 AM
UnholySmoke UnholySmoke is offline Excel Calculation Problem Windows XP Excel Calculation Problem Office 2007
Novice
Excel Calculation Problem
 
Join Date: Sep 2011
Posts: 3
UnholySmoke is on a distinguished road
Default

Quote:
Originally Posted by OTPM View Post
Hi Ben
Can you post a copy of your spreadsheet so we can see exactly what you have done so far.
Tony(OTPM)
Attached, with a couple of notes and two basic examples of what I'm trying to do. GLH stands for Guided Learning Hours, not that that's relevant.

After a bit of research I think Optimization is what I'm trying to do. I've installed the Solver but I'm stumped by it!

Ben
Attached Files
File Type: xlsx example sheet.xlsx (10.8 KB, 10 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Calculation Problem Help with 'hours worked' calculation... Snvlsfoal Excel 1 08-11-2011 05:54 AM
NETWORKDAYS calculation for entire column Salient Excel 0 07-11-2011 03:58 PM
Excel Calculation Problem Excel 2010 formula rounds - arithmetic average calculation YooNaa Kim Excel 1 06-07-2011 08:50 PM
how to make fields calculation variable according to the filter i use duraid Project 0 09-09-2010 01:05 PM
Excel Calculation Problem Mail Merge Calculation Error Lsbutler2000 Mail Merge 1 06-22-2007 06:33 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:47 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft