Hello friends, I am publishing the first edition of Updated Activity Codes MGNREGA. Many activities may be unavailable. Please keep an eye on this page for update. Also if you want me to add any activity in this place mail me at [email protected]. MGNREGA ACTIVITY CODES (UPDATED) CODE DESC UNIT ACT009 TEMPORARY TOILET NO. ACT01941 […]
UTILITY
Microsoft Excel Keyboard Shortcuts
Due to the huge amount of work spent in the Office background, working with Microsoft Excel keyboard shortcuts can significantly improve productivity. Have you ever observed experienced PC users? They are not mouse glued! They combine mouse actions with keyboard commands for higher access time and earlier results. Complex tasks require advanced interaction with the […]
Extract Scheme Code
Extracting scheme code from the mixed content as presented in the MGNREGA portal is a complex job. But is required for many situations like preparing reports for audit and so. So, here I am presenting am MS Excel formula that will do this job. What is being done here is as follows : Copying the […]
SWASTHYA SATHI HOSPITAL LIST WEST BENGAL
SWASTHYA SATHI HOSPITAL LIST WEST BENGAL Here is swasthya sathi hospital list West Bengal. I am putting this hospital list here because the official site of Swasthyasathi scheme (www.swasthyasathi.com) is not working properly for a long time. The smart card holders are finding it tough to get the hospital details. I will update this swasthyasathi hospital […]
Excel Example 1
Here I am presenting my Excel Example 1. Its shows how to separate Scheme Name and Scheme Code if they are in combination. Excel function used in Step 1 : =IFERROR(RIGHT(F2, LEN(F2)- SEARCH(“(“,F2) – LEN(“(“) + 1),””) Excel Function used in Step 2 : =IFERROR(LEFT(G2,SEARCH(“)”,G2)-1),””)
PHOTO RESIZING SOFTWARE MGNREGA
The blocks have provided a .asp package as photo resizing software for resizing photos of the applicants/families for uploading them into the MGNREGA Soft (Online/offline). But in some circumstances it is useless. First of all it is a stolen one, which is expired. So, without hacking the .dll files it is impossible to use it or […]