On the request of many HMs and my Friends, Posting,
School Bonafide (bona fide) Certificate Preparation Tool- with Monthly Returns & Strength Abstract
prepared in excel
This School Bonafide Certificate Preparation Tool- Can be used in any school in Telangana or Andhra Pradesh or any state if the format is applicable.
Play Video
UPDATED FILE WITH U-DISE TABLES ADDED

HOW TO USE ?
After Downloading the file from the links given in the bottom of this post,
Copy the File in to your system folder, then Open the file by Double clicking
if you have downloaded the .zip format you have to extract the file by
Right Clicking the File and Extract... menu
then Open the file,
after opening the file you will be presented with this (Primary Information )screen

STEP 1
The First Thing to Do...
-Check Academic Year (Change if needed )
-Type School Name
- Type Mandal & District
-Type State and Pin.
This data will be used in the Bonafide Certificate

STEP 2 :
Change LOGO ( If you have one ) or Delete the Logo
First Delete the Old Logo if you want to Change the Logo or if you don't want the logo to be printed on the Bonafide Certificate
Insert your School Logo in this White Box and move to the Center of the BOX

STEP 3 :
MAIN PART OF THE SOFTWARE - STUDENT DATA ENTRY
Click Enter Student Data in the Primary Information (Home) Page
You will be taken to the instructions page

Important things for Data Entry
-Click on the Class Sheet
-Click Edit/Update Button on the TOP
-Delete Dummy Data
-Enter Student Details
-you need not to type Roll No.
- Type Admission Number, Name, Father Name, Caste,Date of Birth, Date of Admission, Sex(Gender) & Muslim
-Caste should be Two letters only in CAPS (SC/ST/BC/OC) don't type sub caste or group
-Date of birth & Date of Admission is in the format of DD-MM-YY ( ex: 15-12-08)
- Sex (Gender) should be B or G
-if Muslim(minority) type Y this is for monthly return calculations
IMPORTANT !
if you want to delete any class -
DON'T Delete the Sheet just delete the data from the sheet and hide the sheet
