Pmegp DPR User Manual - v1.1
Pmegp DPR User Manual - v1.1
Pmegp DPR User Manual - v1.1
Directorate of PMEGP/REGP
Machineries
Microsoft Excel 2000 and above with all add-in tools
Printer
INSTALLATION: CD contains one excel file named "PMEGP-DPR." You can copy this file in your System as master file in any specific /separate folder.
Operation: After opening the file you will view following screen
-1-
This Excel file is having 3 sheets i.e. Application Form, Project Report, Data sheet and DPR Front
COLOUR CODES :
The following colour codes are used for better understanding of user in the Data Input Sheet: 1. Pista
: User should feed data in this cells.
2. Light Blue : This Cells id protected. User will not allow inserting data in this cell. 3. Orange : This Cell is defined as Heading of the Column. Users are requested not to change the heading of columns. ( Otherwise entire page setup may change resulting complication)
-2-
SELECT LIST : Select appropriate option from the list. After selecting the value from list , appropriate value will automatically be placed in the desired cell.
Users have to fill this application form according the data received from the beneficiary. Help comments are provided for better understanding while doing data entry. However certain fields are linked up with DPR. As such the required data will be taken by the respective cells automatically and the User need not enter the data again.
Project Report:
Developed & Designed by:DIT, KVIC, MUMBAI
-3-
2. DATA SHEET :
Developed & Designed by:DIT, KVIC, MUMBAI
-4-
This is mainsheet for preparation & calculation for project report. Users have to feed proper data wherever required i.e. in Pista colour cell only. Others are auto-calculated field.
PRINTING PROCEDURE
Developed & Designed by:DIT, KVIC, MUMBAI
-5-
(Before taking print, the table should be Selected) 1. Click DPR print. Make the print preview check. And get the printout.
DRR Front (Cover Page): In this sheet a cover page will be automatically generated. Simply you have to take the print on good quality thick paper.
-6-