Re: Automated Pay Fixation Module ( for W. B. Govt. Employee
While trying this for a hypothetical case of CAS, I found that #VALUE is showing at the left side just below the office address.
In pay fixation calculation there are two paragraphs, i) initial pay fixation and ii) final pay fixation. In my trial run the initial pay fixation paragraph shows no data (X), so should not it be hidden?
Overall, other things are working fine.
Re: Automated Pay Fixation Module ( for W. B. Govt. Employee
@ nemo.
Thanks for your feedback. I checked it. It’s ok in my PC. I wonder what the problem is.
About hiding of the rows meant for initial fixation in case of MCAS, there is a problem and I could not overcome it. I could not find any formula to conditionally hide some rows or columns. It could be done through vba codes, but I avoided it as users have to enable Macros before running the utility and system generally suggest not to do that for security reasons. I am searching for any formula that can do that but I am afraid there is none of it’s kind.
Re: Automated Pay Fixation Module ( for W. B. Govt. Employee
Hi Mr. Ray ! In this new utility unreadable contents are present. It doesn’t work properly. # value is showing in too many cells. Cell comments are not present.
Re: Automated Pay Fixation Module ( for W. B. Govt. Employee
@pkk: You need to fill up all data of the form.
I checked the new version and it is working fine in my case.
Re: Automated Pay Fixation Module ( for W. B. Govt. Employee
Friends , I am in some trouble with this utility only. I am using Windows 7 & MS 7. After downloading this utility when I am trying to open it a Dialog Box ‘Microsoft Office Excel’ is coming. Where it is seen that “Excel found unreadable content in ‘Auto Pay Fixation – Single.xlsx’. Do you want to recover the contents of this workbook, click Yes.” But clicking ‘Yes’ this utility is not working as it is. What I have to do ?
Re: Automated Pay Fixation Module ( for W. B. Govt. Employee
@pkk: The said error is shown when an incomplete download occurs. Try re-download the utility and check.
The only warning shows after opening the utility is that, “Protected View: Be Careful-files from internet can contain viruses. Unless ……”;
You should click “Enable Editing”.
This feature is for MS 2007 onwards.
A.O.A sir i am junior manager in semi govt organization and our pay scales have also been revised plus 10 % adhoc as well. So, i have checked ur pay fixation calculator. I also want to make this type of excel sheet for pay fixation of our employee. kindly send help me and tell that which formula u have used for the purpose.
Thanking u in anticipation.
