Data Key – Daily Generation & Availability

One of the most complex monthly reports we have on our format is Daily Generation and availabilty Report. Moving ahead in the process of automation in Report Generation and in order to remove all confusions whilst creating this report we have created a key for the collection of data from various sources.
1-12 & A (Larji to Thirot) Source: Daily Generation Own Power Houses Report
B (Baspa-II)  Source: Summary Daily Power Supply Position
C Malana, Source: Daily Power Supply Report (Total Generation of Malana in LUs)or Generation Register at Control Room
1-37  SINGR to KHLG2, Source: Download from nrldc.in > Implemented > Form C, Text data convert TEXT TO COLUMN & convert MWH to LUs by dividing 100 to the values
E(i),E(ii),F & G: Net Schedule ISGS, Net Reg., Bilateral Int Reg. & PX Inj, Source: Download from nrldc.in ->Implemented->Form C Text data convert TEXT TO COLUMN & convert MWH to LUs by dividing 100 to the values
H, I ,J & K: RSD + Shanan, Khara & Yamuna, Source: Download from nrldc.in ->Implemented->Shared Project-HP OR > Scheduling >Open Access >Shared Project and RSD + Shanan = Punjab Power (Shanan = 17.64% annual Share), Khara= UP Power & Yamuna=UA (Uttaranchal power)
M Malana (Export) Source: Download from nrldc.in ->Implemented->All Open Access Transactions > OA > All Transactions, Punjab Power through PTC
All exports and Imports: (Column Numbers keep on varying) Eg. Indian Energy Exchange, Export GoHP power to PTC, Export GOHP Power to HPSEB, Import from BRPL under Banking, Import from BRPL under Banking, Import from PSEB Banking & Import from HPPC Banking, Source: Summary Daily Power Supply Report
Q (Percentage Losses): Oracle Database > Losses, Download from nrldc.in >Implemented->Form C
S Actual drawal as per SEM Data Source: Download from nreb.nic.in -> Commercial Activities -> UI account (Weekly data) PDF file Other then data of PDF File (Implemented) will be available in the Real Time Data recording register in fifteen miutes block at the Control Room, Drawal in MW only the Total value has to be taken into consideration.
T Demand of the State: Total Restricted Demand calculated with formula
U Power Cuts: from Summary Daily Power Supply Report
V Unrestricted Demand: Calculated with formula
W Surplus(+)/Deficit(-): calculated with formula
X TOTAL Availability: Also calculated with formula