problem solving

  1. W

    What is the best way to solve and assign values to constraints with multiple weights, for the best value?

    Thank you in advance for any suggestions. I have tried looking up SOLVER, GOAL SEEK, and most recently KNAPSACK. I'm not sure what is best., or if it is possible. There are 3 types: BASIC, SMART, and DEVICE In this particular group there are 17 BASICs 48 SMARTs 22 DEVICEs Now here's the...
  2. J

    Question regarding conversion worksheet format

    Hi there, I'm new to excel and I have a problem with the conversion of my excel sheets to spss. However, the main problem is how I can convert my excel sheets in a more logical form. Here it comes: First, I have spreadsheet in which the answers of a questionnaire are ordered. (1-5 = strongly...
  3. J

    Ranking excel problem

    I need to rank these colleges by how important they are but my problem is these categories from the data like comparing the expenditure per student to academic reputations is really hard to make an equation ranking of especially if I am going to rank these colleges based from all the the...
  4. 5

    plotting in excel - ideas welcome

    Good evening. this may seem a strange request. my problem is that i need to plot containers (that carry cargo) on an area in the spreadsheet that can be removed, named and colour coded. all i have came up with so far is using the drawing tool and physically dragging the conatiner into...
    • 5pds
    • Thread
    • conditional formatting ideas plotting problem solving
    • Replies: 3
    • Forum: Excel Questions

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top