
Economics Economics Forum  Financial Mathematics, Econometrics, Operations Research, Mathematical Finance, Computational Finance 
 LinkBack  Thread Tools  Display Modes 
May 25th, 2011, 09:22 AM  #1 
Newbie Joined: May 2011 Posts: 4 Thanks: 0  State "adjustment" optimization
Hi I have a list of all states with an "initial adjustment" on each state. I need to group the states together into a variable number of groups, and apply one "leftover adjustment" to each group to try and minimze the sum of the "initial adjustment" and the "leftover adjustment". I only have access to MS Excel. I've grouped the states into five groups for the posted example, but the spreadsheet is set up to change the number of groups in cell J1. The number of states in each group does NOT have to be the same, i.e. Group 1 can have 3 states while group 2 has 10 states. Any pointers would be appreciated, I am fully competent in using Excel. Thanks dag 
July 18th, 2011, 06:58 AM  #2 
Newbie Joined: May 2011 Posts: 4 Thanks: 0  Re: State "adjustment" optimization
Ok, what would I need to change to make this problem solvable?


Tags 
adjustment, optimization, state 
Thread Tools  
Display Modes  

Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
Can anyone help me finding this book "Evariste Galois "Toti"  johnmath  Math Books  6  January 27th, 2013 03:13 PM 
A "simple" application of dirac delta "shift theorem"...help  SedaKhold  Calculus  0  February 13th, 2012 11:45 AM 
"separate and integrate" or "Orangutang method"  The Chaz  Calculus  1  August 5th, 2011 09:03 PM 
sample exerimentneed help finding "statistic" and "result"  katie0127  Advanced Statistics  0  December 3rd, 2008 01:54 PM 
terms "nonincreasing" or "nondecreasing"  Ujjwal  Number Theory  2  September 29th, 2008 07:06 AM 