Monday, 8 July 2013

How to password protect or encrypt Excel spreadsheets

How to set spreadsheet security in Excel 2002/2003
There is not something like an "encryption button" in Excel. On the other hand, encrypting Excel spreadsheets is just a few clicks away.
route 1: Tools | Options | Tab Security
route 2: File | Save As | Tools | General Options | Tab Security
File encryption options in Excel via the 'Save As' Menu
Security settings in Excel 2002/2003
The Security tab shows different security settings:
Open password
This password is used for spreadsheet encryption. This security feature is discussed in the next paragraph.
Modify password
This password is used for convenience when sharing spreadsheets. This password does *not* encrypt the spreadsheet and therefore does not add security. This modify password opens the Excel spreadsheet in an editable modus but prevents the original file from being overwritten. The modify password is stored within the Excel spreadsheet. There are tools available that can extract and remove this modify password.
Read-only recommended
This is a recommendation to the person opening the spreadsheet. On opening, Excel asks the user to choose read-only unless the user thinks that changes to the spreadsheet are necessary. It's just a recommendation, no security.

Monday, 1 July 2013

"Operating System Not Found" or "Missing operating system" error message when you start your Windows XP-based computer

  • The basic input/output system (BIOS) does not detect the hard disk.
  • The hard disk is damaged.
  • Sector 0 of the physical hard disk drive has an incorrect or malformed master boot record (MBR).

Tuesday, 4 June 2013

How to enable USB Debugging mode in Android Jelly Beans

  1. Go to the  Settings on the Android Phone
  2. Go to About phone under settings
  3. Find Build number and tap (click) 7 times
  4. Congratulations! You have just enabled Developer options
  5. Now, go to Settings > Developer options > check USB Debugging

Monday, 3 June 2013

OpenFiler as NAS(CIFS, NFS) & SAN(iSCSI, FC)

Link: http://www.openfiler.com/learn/how-to/graphical-installation/
Creating a partition and volume.
[root@open ~]# parted /dev/sda
GNU Parted 1.8.8
Using /dev/sda
Welcome to GNU Parted! Type 'help' to view a list of commands.
(parted) unit cyl
(parted) mkpart
Partition type? primary/extended? primary
File system type? [ext2]? ext3
Start? 1214
End? 8924
(parted) print
Model: IBM-ESXS ST373207LW FN (scsi)
Disk /dev/sda: 8924cyl
Sector size (logical/physical): 512B/512B
BIOS cylinder,head,sector geometry: 8924,255,63. Each cylinder is 8225kB.
Partition Table: msdos
Number Start End Size Type File system Flags
1 0cyl 37cyl 37cyl primary ext3 boot
2 38cyl 1081cyl 1044cyl primary ext3
3 1082cyl 1212cyl 131cyl primary linux-swap
4 1214cyl 8923cyl 7710cyl primary
(parted) set 4 LVM
New state? [on]/off?
(parted) q
[root@open ~]#pvcreate /dev/sda4
Physical volume "/dev/sda4" successfully created

Monday, 6 May 2013

Create a TimeStamp Folder in windows - Batch script Backup

You can write a script to create a folder in Windows
Open the Command Prompt and type echo %date% to get todays date.
If we wanted to get the current year we can start 4 from the end, and 4 in length.
echo %date:~-4,4%
For the month we start with 7
echo %date:~-7,2%
For the day we start with 10
echo %date:~-10,2%
To create a backup using the batch script use this:
set TIMESTAMP=%DATE:~-10,2%-%DATE:~-7,2%-%DATE:~-4,4%

@echo TIMESTAMP=%TIMESTAMP%
xcopy C:\BACKUPS\*.* D:\BackupFolder\%TIMESTAMP%\ /e /i /y
This will copy everything on the folder Backups from C Drive to BackupFolder on D Drive with a time stamp folder.