4 Replies Latest reply on Dec 30, 2014 11:18 PM by vamsi manohar

    Loading map...?

    vamsi manohar

      Dear Team,

       

      How to get maximum load from location based?

       

      Please find the attachment and need your suggestions

       

      in India map i need to show where maximum load is going?

       

      Regards,

      SV

        • 1. Re: Loading map...?
          Syed Khadir Ahmed

          Hi Vamshi,

           

          I hope when you say load .. You are talking about Quantity and you wanted to show how much quantity is consumed by a particular city?

           

          Just check the attached spreadsheet.. Let me know if that helps.. Thank you!!


          Regards,

          Khadir.

          • 2. Re: Loading map...?
            vamsi manohar

            Thanks Syed

            • 3. Re: Loading map...?
              Syed Khadir Ahmed

              You are most welcome Vamsi.. :-)

              • 4. Re: Loading map...?
                vamsi manohar

                Syed please help me out

                 

                Create Employee utilization report as explained below. Use visualization to differentiate the best and worst utilized employees.

                SITUATION:

                • The input table “Employee Period” has Employee Code, End Date Time.
                • The Input table “Public Holidays” has list of public holidays (without Weekends).
                • We need to find the Working hours between start date and end date by excluding public holidays and weekends.
                • Working hours are between (9am – 6pm) using which, you need to derive the actual working hours. Also, find the total working hours possible between the start and end dates to report the overall utilization of the employee (check the example below).

                NOTE:

                • An issue may span over a longer period of time, probably over a week/ Month.
                • Weekends should be excluded in the time calculation.
                • Public Holidays should be excluded in the time calculation. 
                • A public holiday may fall on a weekend; caution is required in this scenario

                eg:

                Working hours between (9am – 6pm)

                Employee Code

                STARTDATE&TIME

                ENDDATE&TIME

                Time Taken in hours

                Time taken in days

                1

                03/07/2014 3:00pm

                03/07/2014 6:00pm

                3

                1

                2

                03/07/2014 3:00pm

                04/07/2014 10:00am

                4

                2

                In The second scenario, day 1, issue work started at 3pm and ended at 6pm so that’s 3 hours, in addition the next days’ time is till 10 am, and so that’s a total of 4 hours. But the utilization for employee 1 is 3*100/9 = 33.33% versus the employee 2 for whom it is 4*100/18 = 22.22%.

                 

                Please find the attachment there in community