2 Replies Latest reply: May 15, 2014 9:54 AM by Bradl Vogl RSS

    Accumulated Hours

    Bradl Vogl

      To All,

      I'm in need expertise...I'm stumped.

      We have a work force of "x" hours labor available per week.

      We have work orders that are date scheduled and required labor hours posted.

      We would like to display (as below) the accumulated required labor hours, but, additionally express when a work week available "x" hours has been booked against available work week hours and then accumulate from that point at "0" to the next work week total.

      The objective is to allow any potential "new" orders be scheduled within a work week that has available hours.

      I have figured out how to flag (colored cells) for a particular  day[/b] . If our total daily scheduled labor hours exceeds our available hours the cell is colored "red", if close "yellow" for caution.

      How can I have it week[/b]or month[/b] driven?

           

      [font="courier"]Date     Total Hours     CUM(Total Hours)

      2006-02-09     1     1

      2006-02-16     0.73     1.73

      2006-02-17     18.5     20.23

      2006-02-21     3     23.23

      2006-02-22     20.67     43.9

      2006-02-23     42     85.9

      2006-02-24     184.96     270.86

      2006-02-27     21.9     292.76

      2006-02-28     35.06     327.82

      2006-03-03     42.8     370.62

      2006-03-06     37.48     408.1

      2006-03-07     35     443.1

      2006-03-10     48.77     491.87

      2006-03-17     106.14     598.01

      2006-03-21     7.5     605.51

      2006-03-24     188.36     793.87

      2006-03-31     18.54     812.41

      2006-04-07     70.08     882.49

      2006-04-13     31.67     914.16

      2006-04-14     63.2     977.36

      2006-04-21     31.56     1008.92

      2006-04-28     57.82     1066.74

      2006-05-05     10.12     1076.86

      2006-05-12     20     1096.86

      2006-05-19     17.7     1114.56

      2006-05-26     0.63     1115.19

      2006-06-01     9.13     1124.32

      2006-06-02     0     1124.32

      2006-06-09     10     1134.32

      2006-06-16     5     1139.32

      2006-07-01     0     1139.32

      2006-07-01     0     1139.32[/font][/quote]Any help is greatly appreciated.

       

      Thanks,

      Brad Vogl

        • Accumulated Hours
          RalphB _

          Brad,

           

          I can't remember which version the "Week" function became available, but it is in version 8 Pro. With it you could use the week function to assign each day to a week and then in the summary window, subtotal by the week number to get a running total for each week and color code accordingly.

           

          You can do the same thing with the "Month" function.

           

          I this what you are looking for?

           

          Ralph

          • Accumulated Hours
            Bradl Vogl

            Ralph,

              That was the ticket!  Thanks for your help

             

            Brad Vogl