Employer E-Sewa PF India Annexure ii upload tool

This is an unofficial tool to help ease the process of uploading Annexure ii to the e-sewa portal.
The official instructions i.e the format for upload is specified here http://www.epfindia.com/ECR/AnnexureII_ErrorCodesList_10042013.pdf

Its a lot complicated for non tech people. So to simplify things I have created an excel sheet where you need to enter the employee details and then just click on a button which will generate the file to be uploaded in the specified format by EPF India.

You should be able to do it in 5 simple steps,  let me take you step by step

Step 1: Download the excel sheet Click Here

Step 2:
These are the columns you ll need to enter into the excel sheet

Open the excel sheet you will find the same columns 

So start filling your employees details, I shall fill the employee Anil Singh on my sheet

Step 3: 
Click on the generate file button.

Step 4:

Enter the path for the file to be stored along with the filename with the extension .txt

ex: d:\FileToBeUploaded.txt and click on Ok

Step 5:

Go to the destination folder/ drive whatever you gave in the above step and open it

Check if all the records are there and then just upload it in the portal.

Important: Every time you plan on using this sheet, use a fresh one, don't use previously entered sheets.

                Before uploading the text file you need to make sure there are no extra lines in the file.

If any doubts or clarifications mention them in the comments, I shall respond. If any errors in upload, epf provides the error codes etc,  post them too in the comments.

Later I shall cover the code of the Macro.

Shutting down computer after utorrent downloads or at a particular time

This may come in handy when you wanna shut down your computer after some time like an hour or so. Also for connections like BSNL which have free download only from 2am-8am. Here are two methods without the use of any additional software.

Option 1: utorrent has an option for this utorrent->in menubar options-> Auto shutdown-> select shutdown after downloads complete or hibernate after downloads complete

Option 2: Sometimes your download doesn't complete in time coz of less apeed or seeds etc. So now
start > run > type cmd and hit enter
cmd opens

type shutdown /s /t and the amount of time you in which you want your system to shutdown/turnoff in seconds

your command should look like this

shutdown /s /t 60

this will shut down the computer in 60 secs

Here:
/s means shut down
/t means time
60 means 60 secs

After you type in this command and hit enter a small pop up at the corner of the screen will tell you how many seconds is left for the computer to turn off.


Suppose you wanna cancel the command type
shutdown /a


If you feel calculation of time in secs is hard then use this website
http://www.onlineconversion.com/days_between_advanced.htm

calc the exact seconds and use it.

Sergwia - Anti viral Tool kit (Remove restrictions caused by viri!)

It helps in removing restrictions which are also caused due to virus infections:

1 - Disable Folder Options >> so the user can't set the option to show hidden files!

2 - Disable Registry Tools >> so the user can't see what is going on during system startup!

3 - Disable Ctrl+Alt+Del >> so the user can't see the virus and the other applications running!

4 - Disable Show hidden files & folders >> so the user can't see the malware bodies which always come with hidden attribute set to true!

5 - Disable Run Command >> so the user can't use it to run some tools to track the virus activites of remove it.

6 - Disable Windows Firewall (SharedAccess) >> so the virus can send & receive any data through the network without the attention of the user!

7 - Disable Windows Firewall (Wscsvc) >> so the virus can send & receive any data through the network without the attention of the user!

8 - Disable Windows Firewall (Wuauserv) >> so the virus can send & receive any data through the network without the attention of the user!

9 – Restrict Internet Explorer Home Page Changing >> so the user can't change the malicious web page set by the malware!

10 – Restrict Internet Explorer Closing >> so the user can't close the pops up windows that appear when visiting the malicious web page or any other website!

11 – Hide Internet Options >> so the user can't change any setting set by the malware!

12 – Hide Internet Explorer Address Bar >> so the user can't see what web page being visited and what scripts being executed!

13 - Restrict Internet Explorer Right Click >> so the user can't view the source of the page being visited and other useful things.

14 – Hide Internet Explorer Navigation Buttons >> so the user will be forced to user the keyboard shortcuts to navigate through the web sites!

15 - Hide Internet Explorer Context Menu >> so the user can't access this menu which make him able to select some useful settings.

16 - Hide Internet Explorer Toolbar >> so the user can't use it to remove some unwanted toolbars made by the malware.

17 - Disable Command Prompt (cmd.exe) >> so the user cannot run any console programs like command prompt removal tools...

18 - Disable Control Panel >> so the user cannot use the control panel applets.

19 - Hide system files/folders >> so the user can't see the malware bodies which usually come with system attribute set to true!

20 - Change Show Hidden files option button >> So even if you select "Show hidden files and folders from folder options these files & folder will not be shown!

21 - Disable Show System files check box >> So even if you unchecked "Hide protected operating system files" these files & folder will not be shown!

22 - Disable Show all files/folders check >> So changing this from folder options will be ignored!

23 - Hide Desktop items >> to prevent the user from accessing My Computer and other desktop shortcuts!

24 – Hide files extensions. This is commonly used by malware to trick the user. By hiding file extension, a user doesn't know whether a file with folder icon is an exe file or just an ordinary folder.

25 – Disable File Extensions Check >> So changing this from folder options will be ignored!

26 – Restrict Windows Update >> So the user cannot download security patches from Microsoft.

27 – Disable Shut Down CommandD >> So the user cannot shut down the system normally.

28 – Restrict Settings Folders >> Just imagine when you all items under Start menu>Settings wont run!

29 – Disable Taskbar context menu >> You right click your taskbar.. Oops; nothing happens!

30 – Disable Logoff Command >> So the user cannot logoff and use another profile.

31 – Hide Start Menu Logoff >> So the user cannot use this shortcut to logoff!

32 – Restrict Add/Remove Programs >> So the user cannot see what applications and windows components are installed or uninstall/reinstall any application.

33 – File Extension Default >> So the user cannot select "Hide extensions for known file types".

34 – No Windows Update >> So the user cannot download security updates and other fixes for windows.

35 – R-Media Malware >> This item is indicating that a malicious object is trying to invade your computer through removable media, please see the details below.

36 – Hidden Drives >> So the user cannot see any of the storage drives but they still can use RUN to access and explore them.

37 – Restricted Drives >> So the user can see the drives but cannot access them even when using RUN command.

38 – No Search >> So the user cannot search the file system using the start menu item for any file.

39 – No Display >> So the user cannot access the Display control Panel to change the display settings.

40 - Corrupted Safe Mode >> So the user be forced start the computer in normal mode where the virus always active.

41 - Execution Debugger >> So the user cannot run many security tools and antivirus software to get rid of the virus.

42 - Windows Security Center >> So the user cannot access many security settings.

DOWNLOAD

Switch Off - Turn off/Hibernate/Restart your PC

Switch Off is a tiny easy-to-use utility that can automatically perform various operations like shutdown,hibernate or restart your computer, disconnect your current dialup connection, lock workstation, etc. It also provides fast access to this operations through system tray icon. Utility has fully customizeable Web interface, that allows you to initiate operations mentioned above remotely from any computer with web browser installed. Web interface includes WAP support, so you can control your computer from mobile phone. This utility is intended to be used by either novice or professional user, because of its intuitive interface and professional features. Small file size http://www.airytec.com/en/switch-off/

New Folder.exe Virus Removal Tool

Virus also known as- IT University Sohanad W32.HLLW.Ssdx newfolder.exe

If this virus infected in you computer, It will Disable the following …

Disabling Task Manager
Disabling Registry Editor
Creates a startup entry to start upon system start and
Creates its own exe files in Shared Documents folder which appear like ordinary folders.
Disables Folder Options
Uses your 50% or more processor

Download following tools to remove new folder.exe virus

DOWNLOAD

RunAsDate

RunAsDate is a small utility that allows you to run a program in the date and time that you specify. This utility doesn't change the current system date and time of your computer, but it only injects the date/time that you specify into the desired application. You can run multiple applications simultaneously, each application works with different date and time, while the real date/time of your system continues to run normally. This application can be used to increase your trial period of any software your using. DOWNLOAD