capacity

  1. E

    Maximum possible allocation given constraints

    Hey Guys, I'm not too sure how to approach this but i think it's a VBA problem and i'm having a lot of trouble figuring it out. Apologies in advance... it's a long one lol TL;DR The problem is i'm trying to find the optimal allocations to result in the highest possible value given some...
  2. R

    How do I make a VBA SUMIFS reference the right sheet?

    Hello hello hello, I'm trying to replace a formula within a Macro to optimise my code a bit. Previously, this was written and references a workbook called Capacity that was already opened previously in the code: Range("Z3:Z" & Lastrow).FormulaR1C1 =...
  3. P

    Is it possible to bold c ertain items in a listbox?

    I have a userform with a text field. Is it possible to bold certain items in a listbox based on the value entered in the text field? For example, I have a worksheet that contains the max capacity of each room. A list of rooms available for booking will be listed in the listbox. In the...
  4. A

    Capacity Constraints and Scheduling...

    I have a list of parts that has x amount of minutes to produce. I have a limited capacity each week. I would like to create an easy way to create a "matrix" that shows how the production minutes can be distributed. I need to be able to change the capacity as necessary...
  5. R

    match multiple columns

    Hello! I need help on using the match function across multiple columns. Here is my example: <tbody> Capacities Angle Angle Angle Width 0 deg 5 deg 10 deg 32 555 444 333 18 433 420 290 12 306 285 222 </tbody> <tbody> Capacity 315 Angle 10 deg </tbody> I want a cell to return...
  6. C

    Index + Match + Min +ABS + IF

    So I started off thinking this was "easy"... I have two values and need to find the best match and return a result (3 columns) Input 1: Distance (Actual) Input 2: Capacity (Needed) Column 1: Distance (Max) - Need to solve for closest larger than (Can do separately) Column 2: Capacity...
  7. K

    month capacity alert

    Guys, I have two text boxes on my user form"start date" & "end date", and I need to compare their values with a table in the excel workbook. for example, if the start date is 4/21/2018 and the end date is 5/15/2018. I need the VBA to search in a table in sheet2 if any of these months has...
  8. L

    Capacity Planning Structure

    Hi guys Am having one of those days ! and really struggling with putting a table structure together to capture info that I require for capacity planning. Can't figure which is the best way and which to use as rows and which as columns etc.. Here's what I need. For a list of resources I need...
  9. K

    How to match the data in different table

    Hi everyone, I have a set of data as Table 1. I would like to have a formula to link the Target capacity in Table 1 to Table 2. Example, in Table 2, date 1, I need the result to return as 68.25 when the machine (G1) when it is running product 2T. Same goes to others machines. Thank you.. Table...
  10. K

    VBA - Colour code a string of text

    Hi, I am currently using the vba code below to turn the sentence "Deal capacity over 95%" to red, however, the issue I am facing is that it turns all text in that cell red, not just the statement "Deal capacity over 95%". Is there a way I can stop the whole cell text turning red and just turn...
  11. J

    Allocating Amounts into Bucket

    Hi There, Here is the problem: Say I have 5 inventory of products (liquids): Jan Feb Mar Milk 5 10 1 Water 7 8 40 Orange Juice 10 32 3 Now say I have the following containers: Container 1 - capacity 1 Container 2 -...
  12. A

    VBA to display borders and cell color from a certain validated data list selection

    Hello, How would I be able to get VBA to display borders and cell color from a selected item from my validated data list? I have some code listed here. The first part the data validation list works just fine. I am wanting to add a if statement that runs with the selection of "of Capacity". I...
  13. H

    calculate the numbers to reach a number knowing the percenage to add to the first number?

    Hi, Sorry if this is trivial, but I can't internet search this properly cause it is difficult to explain my question to a search engine :( I am working on a capacity planning spreadsheet. If can do 100 units of work, but I know that if someone assigns me 100 units of work but it may be 50%...
  14. 9

    Excel capacities - how to deal with a functionally uneditable file (block of large array formulas almost undeletable)

    Apologies if I’m in the wrong forum please redirect me. Large (~300mb) .xlsm project ridiculously slow for months (½ hour just to load). Finally tracked it down I think to somehow a complex array formula referencing several sheets mistakenly copied into 200,000+ cells. Now even trying to delete...
  15. M

    Excel model to affect Outbound Capacity Constraints

    Hi all, Happy bank holiday from the UK. I'm trying to create an Excel model which tracks my outbound capacity from a warehouse and identifies where the capacity is forecast to be exceeded, and adjusts the outbound volume to the weeks where there is spare capacity. <tbody> At the moment I...
  16. B

    Widget order and production vs. capacity simulation

    Hi All, I'd be grateful if you could have a look at the scenario below and contribute any suggestions please: Scenario We have 5,000 widgets available to order We make widgets to order and can produce 50 a day It's important we can tell customers their expected wait time for their widget...
  17. E

    Distributing a number/volume across multiple cells where the max possible value of each cell can be defined.

    I've a list of servers (rows) that I'd like to spread a total load across. Each has a max load, & a recommended % load threshold to prevent issues. Different servers have different max loads. (Note... For the non server nerds equally this could work for team members and tasks rather than...
  18. H

    Raising some variables considering their min and max amounts and the priority of respecting all mins

    Hello guys, I have found the answer of a bunch of my questions through communicating in this website and hope this time be the same. PROBLEM: take some parameters (i) each with a minimum and maximum capacity. I have an amount of entry which can be assigned to each parameter so that at least...
  19. G

    Insert more words and sentence in comment box

    How many lines or words i can insert in a comment box? I am unable to insert more than 11 lines. Need help please. Looking forward to your early help. Many thanks.
  20. A

    Dynamic Capacity and Drop Downboxes

    Hello, Building a spreadsheet (Excel 2010) for a client that wants to track different levels of capacity based on location. All of the widgets are moving and I want the total capacity of new location to be dynamic based on the drop down that is chosen on the widget page. Details: I have two...

Some videos you may like

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top