HR MANAGEMENT SYSTEM SCHOOL EDUCATION DEPARTMENT SOHBATPUR

Retirement Sheet

Manual records: 0 DB: checking... Imported employee records: 0

Personal No

Date of Retirement (DOR)

Date of DEA

Case Type

Name

Father Name

Designation

Place of Posting

CNIC / NIC Number

Date of Birth (DOB)

Date of Appointment

Letter Generator

Letter Category

Personal Number

Search retirement sheet + imported employee data dono me hoti hai.

Name

Father Name

Designation

Place of Posting

NIC Number

Letter Date

Date of Birth (DOB)

Date of Appointment

Date of Retirement (DOR)

Date of DEA

In-Service Death Leave Days

Reference / No. (Auto)

Dated Place

To

Subject (Auto by Category — optional edit)

Remarks

Signature Title

Office / District

Case Number

Reference Formula: DEA / Category Code / (Tracking Count×5+1) - (Tracking Count×5+5) / DEO SPUR

Tracking Sheet me same Personal Number + same Category duplicate allow nahi hogi. Add to Tracking ke baad form blank ho jayega.

GPF Advance

Personal Number

Designation

Name

Father Name

DDO Code

Place of Posting

NIC Number

Letter / Order Date

Date of Birth

Date of DEA

Age on DEA

Sanction %

Date of Appointment

GPF Account No

GPF Slip Amount

Nature of Advance

Amount Sanction

Reference / No. (Auto)

Case Number

Dated Place

To (Forwarding only)

Subject (Forwarding only)

Remarks

Specified designations = Forwarding Letter. Remaining designations = Sanction Order.

Excel Import (Search Only)

Load Employee Data (Excel .xlsx / .xls)

Excel reader: ready No file loaded Rows: 0

Excel data server database me save rahega aur next time bhi available rahega. Backup workbook me bhi ye data save hoga aur restore se wapas aa jayega.

Backup / Restore

Full backup workbook me 4 sheets hongi: RetirementSheet, EmployeeMaster, TrackingSheet, Meta. Restore inhi sheets se hota hai.

Restore Full Backup Workbook / JSON

Restore se current data replace ho jayega. Pehle current backup nikaal lena behtar hai. Agar restore ke bad server pe save fail hua ho, to "🔄 Re-save to Server" dabaye.

Windows se pehle yeh 2 cheezein USB me rakhain:

Is HTML final file ka backup
Export Full Backup Workbook

Note Portion (All Tracking Sheet Cases — Death/Retirement, Pension, GPF Advance, Final GP Fund, etc.)

DEA Meeting Date (for note wording)

Assistant / Computer Operator

Focal Person

Signature Title

Office / District

Reference / No. (Optional)

Extra Remarks (Optional, shown before the case table)

Case list ab Tracking Sheet ke TAMAM categories se banti hai — Retirement, Death Notification, Pension, GPF Advance, Final GP Fund, Financial Assistance, Benevolent Fund, Group Insurance waghera.

Case-number-wise selection: "Case No. From" aur "Case No. To" bhar kar us number range ke cases select ho jayenge. "Letter Print Date" filter us tareekh par based hai jab case ki letter/order print hoke Tracking Sheet mein add hui thi — ye hamesha bhari hoti hai, isliye agar Case Number khali ho to ye filter zyada reliable hai. Sab khali chorne par sab cases dikhenge. "DEA Meeting Date" sirf note ke matn (wording) me likhi jane wali meeting date ke liye hai — is se koi filter/selection nahi hoti.

Filter by Category

Case No. From (optional)

Case No. To (optional)

Letter Print Date From (optional)

Letter Print Date To (optional)

0 cases selected

Retirement Sheet

Letter Generator

GPF Advance

Excel Import (Search Only)

Backup / Restore

Note Portion (All Tracking Sheet Cases — Death/Retirement, Pension, GPF Advance, Final GP Fund, etc.)

📄 Same Design Preview