1. Open Gmail nightreportdadri@gmail.com, Password: report@123
2. Open night report google sheet
3. Goto check tab, copy today's column values and paste special values only to previous column values
4. Now goto insert>>extensions>>macros>>Reset Previous>> yes. IT Will reset previous day record
5. Go to share. Share the file by allowing others as editor. Fill all entries of insert, CHP.
6. In CHP tab, old stock is to be updated from previous coal stock value
7. Now download DC, SG file from energy scheduling site of nrldc and paste entire sheets in DC, SG files
8. Now, in EMS_MY tab, make entry of colonh, HVDC
9. Copy next day monthly yearly data to present day
10. Now report is generated
11. Download excel
No comments:
Post a Comment