• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

data analysis on sample data

Hi Narayan,


Thank you once again. But I wanted to understand the chart part, how did you create chart and linked it with the data to show the improvements in the parameters. can you help me understand the steps...


Thanks

Thakur
 
Hi Narayan,


I wanted to understand the chart part, how did you create chart and linked it with the data to show the improvements in the parameters. can you help me understand the steps...


Thanks

Thakur
 
Hi Thakur ,


Sorry , but I am not able to devote the time required to explain starting from scratch ; the basics are easily accessible ; a separate sheet tab Sheet3 has the data from which the chart has been made.


The list of candidates in the drop-down in K2 , has been generated using a pivot table in Sheet4 ; in order to have the list of candidates in the proper sorted order , an additional column called Candidate Number has been added to your data table in Sheet1.


The other parameters displayed along with the chart are through formulae which are straightforward ; if you have any doubts on specific issues , please let me know. The PASS/FAIL display has conditional formatting in cell L6.


Narayan
 
Thakur


In the Forum Rules it clearly says to be patient


I for example have been traveling throughout the jungles in West Timor for the past week for work.


I am sure ill get back to this question when I return next week!
 
Hi Narayan,


I wanted to understand the linking of sheet 3 with the pie graph. Where you have created data labels and used formula's vlookup with the new data labels. I also wanted to understand Index and Match formula usage in the chart.


Please advise..


Thanks and Regards,

K.K.Singh
 
Hi Chandoo,


I have the data set which is used to track unscheduled leaves.


https://www.dropbox.com/s/phqi712yhobber4/Unsched%20data.xlsx


I wanted to track employees who are taking unscheduled leaves combined with their weekly offs.


Like for eg:


Emp 1 taking Sick leave and the next day is his weekly off..now how do I calculate the series of unscheduled leave events for all the months.


Please advise.


Thanks and Regards,

Thakur
 
Hi Thakur


You might want to read this:

http://chandoo.org/forums/topic/phd-forum-posting-rules-etiquette-pls-read-before-posting


As for the wonderful chart that Narayan uploaded you may find the following helpful

Data Labels: http://chandoo.org/wp/2010/05/05/change-data-labels-in-charts/


Formatting Data Labels: This is an abbreviated version of the CONCATENATE function.

This =A4&CHAR(10)&B4 states

Combine A4, a paragraph mark, and then B4


I've found this helpful to understand the whole vlookup, index, and match;

http://www.mrexcel.com/articles/excel-vlookup-index-match.php
 
Hi Chandoo,


I am working on the leave data set..I need help tracking the unscheduled absenteeism in the data. How can I calculate the recurrence of unscheduled absenteeism keeping holidays in mind.


https://www.dropbox.com/s/phqi712yhobber4/Unsched%20data.xlsx


For eg: In the given data I need to calculate the person going on sick which is unscheduled followed by his regular off. I want to calculate the instances of the person taking unscheduled leaves followed by his regular offs..can you please help..


Thanks and Regards,

Thakur
 
You must log in or register to reply here.
Back
Top