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, 4 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 - Senior Forums

All times are GMT -7. The time now is 09:23 PM.


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