Search results

Hi, I would like to extract data for me to integrate with the ERP System. Please find below the sample worksheet (link is mentioned below) https://dl.dropboxusercontent.com/u/67680061/Data%20Sheet.xlsx Data Sheet : Typical data we used in excell sheet. Data Extract : The data to be...

Would like to compare the values of 2 different data (s) 3 variables are ; 1. Salary of an employee 2. Grade Salary median 3. Department salary median Based on the below crieteria, we would like to correct the employees salary. a) Wherever employee salary is lower than above...

Hi, I have few excel files which is used for calculation and data analysis. The data in each file has been consolidated to one file i.e. in the consolidated sheet, I have referred the data to other excel file(s). My question is :- If I move those worksheet (selective) to a file where the...

Dear all, At the outset, i woould like to thank all the forum members for their contribution to clarify so many excell queries. Really amazing ..!! With this in my mind, i thought you may help me to provide a solutions to my query. I have few sales guys who are eligible for incentives as...

I have the data (dd-mmm-yyyy) wherein i need to calculate no. of months served as upto 31st March 2012 from their joining date. a) If anybody serve less than a year then calculate actual months b) If any employee who is more than 18 months, the value restricted to 18 months. c) In all other...

Dear all, I need to present a chart tomorrow to my team about the performance of various business units with respect to Manpower utilisation, sales vs productivity, sqft utilisation with different business units, etc. The chart should be showing clearly on how they performed in last 1 year...

I would like to send a monthly dashboard on Human Resources & Administration. The dashboard will have information on ; (current month & YTD) 1. Head Count 2 monthly addition (No. of employees joined) 3. Attrition for the month & YTD 4. Exit Analysis (reason specific / period of service...

Anybody can share HR Dashboard. I have seen few dashboards here are more into Sales, Projects, etc. Thanks Raghunathan S

Hi, Greetings. Need a help to convert the currency (INR) to word (i.e. Rs.100/- to Rupees one hundred only). I beleive this would have asked by somebody else earlier in the forum. But i find it difficult to search that post. Can somebody help me to provide solutions. Thanks...

Team, Need some clarifications on Date Format. I have the Date format in "dd-mmm-yyyy" and I would like to use certain datas for mail merge option. When I pull the above date format in the Word document, it shows me the numerical value of the date (i.e. some 33397, etc). I want the text in...