Forum Discussion

rForster's avatar
rForster
New Member
8 years ago
Solved

Supply and Demand graph

I have a bunch of data

 

Supply of hours avaialbe to be burned

 

Demand coming from different companies with different hours

 

With calculations of extra resources needed to meet the demand

 

Scoping out over the next 6-12 months

 

Have all this data but dont know a good way to display it in a graph.  Any ideas ?

 

Thanks

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    rForster,


    Please help to share sample data of your table and post expected result here.

    Regards,
    Lydia

    • rForster's avatar
      rForster
      New Member
      8 years ago
       JulyAugustSeptemberOctoberNovemberDecember
      Supply (hrs)460460460460460460
             
      Demand (hrs)      
      company 1200200200200200200
      company 2200200200200200200
             
      company 310200000
      company 41800000
      company 52016040   
      company 62016020000
             
             
             
      Total demand468740460400400400
             
      Hours-8-2800606060
             
      Engineers over/under-0.05-1.7500.3750.3750.375

       

       

      Need someone of showing this information in a graph format is there any way ?

  • AppleUSN's avatar
    AppleUSN
    Frequent Visitor
    4 years ago

    I found an issue with this answer.  If the supply value is not the same from month to month then this process does not work.  The value of the supply stays constant because the date being used is from the Company table where the demand is at.  The matrix doesnt know that the values changed for the same date on the supply table.  I am trying to figure this out myself for my own data and having a heck of a time.