Thursday 19 March 2009

PWD DATA MAKER

PWD DATA MAKER ver.1

Now we are introducing a simple and powerful software in Microsoft Excel format for preparing the Data of public works with existing schedule of rates 2008 . For downloading the software click here. After down loading the file you should unzip the folder using Winzip.

While opening the folder PWD DATA MAKER you can see two files namely

1. Guidelines 2 PWD data maker

1.Guidelines :

This file contains the general instructions for using this software

2 PWD Data maker

While opening this file you can see four sheets namely Rates, Conveyance statement, Data and Abstract. The first sheet contains the rates of materials as per the existing schedule of rates. You can change the values at the time of revision of rates.The second sheet contains Taluk average conveyance of materials. These values are also changeable. The third sheet is Data and fourth one is abstract. All the items in the data book are not included in this sheetAlthough the most commonly used items for Panchayat works are included. You cannot change the values of the third and fourth sheets because it contains several formulas and so it is locked for security.
Maximum care has been taken for the accuracy of calculations of data. Any how the user should satisfy himself for the accuracy of calculation .If any discrepancy is noticed mail immediately and so we can correct the same in the next version.
If all are OK print the pages .It is better to take the print using a laser jet printer.

If you are experiencing any problem mail your doubts to

pradeepenthulika@gmail.com

Created by Pradeepen Thulika

Office 0474 2593254




Saturday 14 March 2009

SALARY GENERATOR

SALARY GENERATOR Ver.2
(New version with additional features)

Another useful software for preparing the Salary details of Panchayats . The existing software for the preparation of Salary bill by IKM is not in the prescribed proforma TR 51. Now we are announcing the salary bill preparation in the approved proforma. You just enter the basic data like basic pay, salary deductions, etc. as descibed in the proforma in Basic data sheet. The columns in the basic data sheet are self explanatory. In the second sheet you can see the inner of Salary bill. The consecutive sheets are self explanatory.
For downloading the software click here. After down loading the file you should unzip the folder using Winzip.

While opening the folder SALARY GENERATOR you can see two files namely

1. Guidelines 2 Salary Generator

1.Guidelines :

This file contains the general instructions for using this software

2 Salary Generator

While opening this file you can see five sheets namely Basic data, Inner, Outer, Pension contribution, SLIC, GIS, KPEPF. The columns basic data sheets are self explanatory and enter the figures and other details with care. The Salary bill and other details in the prescribed Performa will be generated.
3 Honararium calculator

This is designed for calculating the honorarium and sitting fee of President and Members of the Panchayat. The coloumns are self explanatory

If all are OK print the pages .It is better to take the print using a laser jet printer.

If you are experiencing any problems mail your doubts to
pradeepenthulika@gmail.com

Created by
Pradeepen Thulika

Office Phone 0474 2593254



Wednesday 11 March 2009

PROPERTY TAX GENERATOR Ver.2

PROPERTY TAX GENERATOR Ver.2
(New Version with additional features)
This is a very user friendly software for preparing the Annual Budget of Panchayats . You just enter the corresponding amounts in the concerned cells. Don’t add or subtract any figures. It will be automatically displayed. You can see the percentage of Closing balance while entering the figures and so you can adjust the same by adjusting the Receipts and Expenditure side .Care should be taken for not changing or enter any figure in the cells of yellow colour. If you do so the formulas given in the cells are malfunction and as a result the abstract of Budget figures will be wrong. For downloading the softwar click here. After down loading the file you should unzip the folder using Winzip.
While opening the folder PROPERTY TAX GENERATOR you can see two files namely

1. Guidelines 2 Property tax Generator

1.Guidelines :
This file contains the general instructions for using this software

2 Property tax Generator
While opening this file you can see three sheets namely Basic data, Assesment details and Property tax Register. The columns basic data sheets are self explanatory and enter the figures and other details with care. The property tax register in the prescribed Performa is generated.
3 Property tax Calculator
While opening this file you can see a single sheet.This is mainly aimed to determine the property tax of an individual case. Care should be taken to not enter anything in the yellow area. Enter the basic data in the blue coloured area at the top right corner of the sheet. Enter the figures and other details with care. The property tax in the prescribed Performa is generated

If all are OK print the pages .It is better to take the print using a laser jet printer.

If you are experiencing any problem mail your doubts to pradeepenthulika@gmail.com

Created by Pradeepen Thulika

Office 0474 2593254



BUDGET MADE EASY

BUDGET MADE EASY Ver.2
(New Version with additional features)

This is a very user friendly software for preparing the Annual Budget of Panchayats . You just enter the corresponding amounts in the concerned cells. Don’t add or subtract any figures. It will be automatically displayed. You can see the percentage of Closing balance while entering the figures and so you can adjust the same by adjusting the Receipts and Expenditure side .Care should be taken for not changing or enter any figure in the cells of yellow colour. If you do so the formulas given in the cells are malfunction and as a result the abstract of Budget figures will be wrong. For downloading the software click here. After down loading the file you should unzip the folder using Winzip.


While opening the folder BUDGET MADE EASY you can see four files namely

1. Guidelines 2.Facing sheet 3.Malayalam Fonts 4.Master budget

1.Guidelines :
This file contains the general instructions for using this software

2.Facing sheet :
This is the facing sheet of Budget proforma.You can change the name of Panchayat

3.Malayalam Fonts :
While opening the Master budget file sometimes you may not read Malayalam in your computer. This indicates that Malayalam fonts are not installed in your computer. If so you just open this file and select all the contents by pressing ctrl+A. The contents are highlighted.Copy the contents by pressing ctrl+C.Close the window and open My Computer icon. From there open control panel and then open Fonts.Then paste the copied contents by pressing ctrl+V.The Malayalam fonts are installed in your computer. Once again open the Master Budget.See the budget Performa in Malayalam.

4.Master budget
While opening this file you can see two sheets namely Receipts and Expenditure. Click the Receipts Sheet. The columns are self explanatory and enter the figures with care. Special attention should be taken for not changing or enter any figure in the cells of yellow colour. After completing Receipts sheet proceeds to the Expenditure Sheet.Enter the figures.After completing checks the % of CB at the right side of Abstract. If it is below 5% adjust the figures in Receipts and Expenditure.

If all are OK print the pages .It is better to take the print using a laser jet printer.

See the Budget in an elegant look with correct figures

If you are experiencing any problem mail your doubt to pradeepenthulika@gmail.com

Created by Pradeepen Thulika

Office Phone 0474 2593254