Forum Discussion

Mr_Raj_C's avatar
Mr_Raj_C
Brass Contributor
Jan 25, 2025

Help with building a modelling tool

Dear Excel Community,

 

Hope you are all keeping well ?

 

I'm currently seeking some help in finishing off a modelling tool want to build in Excel (see attached).

 

Essentially, the tool is to help inform material values based on 3 variables,

Total Tonnage - manual entry

Composition - From a selection

Commodities - From a selection

So in the attached workbook, the user will input the tonnage value on sheet "Model" in cell B2.

They then select the Commodity values to use. This will be a choice of "low", "Average" or "High". Based on the choice made, i would like Excel to populate cells D10:D27 with the corresponding values from sheet "Commodities".

The user then selects the Composition value in cell B6. As above, depending on the selection, i would like Excel to populate cells B10:B27 with the corresponding values in sheet "Composition".

I would be really grateful if someone could give me some ideas or a solution on the easiest way to make this work.


As always, thanking you in advance.

 

Kind regards


Raj

  • Mr_Raj_C's avatar
    Mr_Raj_C
    Jan 26, 2025

    SergeiBaklanThank you so much. This is exactly what i was looking for.

    Just one question though, the formula's in Column C don't seem to be working in the current state but if i reverse the formula, it works. Would appreciate your thoughts as to why that could be ?

     

    Thanks


    Raj

    • Mr_Raj_C's avatar
      Mr_Raj_C
      Brass Contributor

      SergeiBaklanThank you so much. This is exactly what i was looking for.

      Just one question though, the formula's in Column C don't seem to be working in the current state but if i reverse the formula, it works. Would appreciate your thoughts as to why that could be ?

       

      Thanks


      Raj

      • Mr_Raj_C , I didn't touch formula in column C. Perhaps you meant

        =$B$2*(1-B10)

        Not sure what is the business logic behind.

Resources