1
Aug
Hi , trying just new posts 2day
23
Jul
the sport of gliding your way down snow.
If you have completed voucher entry for the last financial year and want to carry forward balances into new financial year. Just suppose you have done entries for the financial year 2007-2008 and want to star
t entries from 1-4-2009 means financial year 2009-2010. So after finishing entries
upto 31-3-2008. Tally won’t accept entries of 1-4-2009. It will say while making voucher entry “Date above current period”. To make voucher entry for 2009-2010 Gateway of Tally – Press Alt + F2 and Change Period From 1-4-2009 to 31-3-2010. Now Tally will accept voucher entry from 1-4-2009. After shifting to new financial year, you can any time go back to previous financial year by pressing alt + F2 at Gateway of Tally.
22
Jul
Photoshop is powerful & flexible photo editing tool through which we can do almost all kinds of photo editing work here I am describing that how you can create picture package in Photoshop. Picture package is one of it’s best features. It is nothing but multiple copies of an image in a single page this multiple copies of images can be of same size or different size.
Picture package let’s you customize in many ways you can choose from a different sizes & different placement options
Picture package let’s you customize in many ways you can choose from a different sizes & different placement options
This is very useful for photo studios through this they can make array of passport or stamp size photographs quickly or they may create a package of different size using same image.
Creating picture package:
Here are the steps to create a picture package
Step 1: Scan a photograph for which do you want to create a picture package with yours favorite scanner & save the file with an appropriate name.
Step 2: Start ‘Photoshop’ package.
Step 3: Click file > Automate > Picture Package option.
Step 4: Picture Package dialogue box will be appeared on your screen. Choose an image for which you are intended to create a picture package by clicking ‘Choose’ button or if you already have the source image opened on your screen then select ‘Use front most document’ check box..
Step 5: Choose Layout from the layout option, picture package dialogue box also shows preview for selected layout
Step 6: Input resolution values for the package in resolution option.
Step 7: Choose appropriate color mode & click ‘Ok’ to create picture package.
Step 6: Input resolution values for the package in resolution option.
Step 7: Choose appropriate color mode & click ‘Ok’ to create picture package.
Customizing Layout:
You can also customize layout according to your needs when you can’t find layout of your choice in layout option predefined layouts are store as a text file in
“C:\Program Files\Adobe\Photoshop 6.0\Presets\Layouts”
These type of text file can be created according to your needs. You can create new layouts or edit existing layouts by using any text editor like ‘Notepad’ or DOS’s edit command. Just suppose you want to create a new layout which has document size 8×10 inches where 8 is width and 10 is height of an image & this document will have 2 (4×6) size photographs. So let’s create this text file in ‘Notepad’ application here are the steps to do it.
“C:\Program Files\Adobe\Photoshop 6.0\Presets\Layouts”
These type of text file can be created according to your needs. You can create new layouts or edit existing layouts by using any text editor like ‘Notepad’ or DOS’s edit command. Just suppose you want to create a new layout which has document size 8×10 inches where 8 is width and 10 is height of an image & this document will have 2 (4×6) size photographs. So let’s create this text file in ‘Notepad’ application here are the steps to do it.
Step 1: Start ‘Notepad’ application
Step 2: Enter this following line on the first line of the file.
I 8 10
Here ‘I’ is measurement unit in inches & 8 , 10 is width & height respectively of the document. You can also use other unit, like centimeter & pixels use letter C or c for centimeter & P or p for pixels.
Step 3: Second line of the file has ‘Caption’ that you want to appear in picture package dialogue box. Enter following line in the second line of the file
2 ( 4 x 6 )
2 ( 4 x 6 )
Step 4: in the next lines enter the position & dimensions of image which you want to appear in the document type following lines in the file.
0.5 0.5 6 4
0.5 5 6 4
These above each line for each picture which you want to appear in the document. This lines have size & dimensions of the picture each lines have four values which is separated by a space. These values are for c1 r1 c2 r2 for the first line Where
c1=0.5
r1=0.5
c2=6
r2=4
r1=0.5
c2=6
r2=4
& for the second line
Where
c1=0.5
r1=5
c2=6
r2=4
r1=5
c2=6
r2=4
Step 5: Save this file with an appropriate name in
“C:\Program Files\Adobe\Photoshop 6.0\Presets\Layouts”
Step 6: Use this newly created layout in Photoshop by clicking file> Automate>picture package option. There you may find new layout, which you have created.
Step 7: Choose an appropriate image by clicking ‘Choose’ button & then click ‘Ok’ button to create picture package your picture package will be created. So by this way you can create as many job a file as your needs.
Step 6: Use this newly created layout in Photoshop by clicking file> Automate>picture package option. There you may find new layout, which you have created.
Step 7: Choose an appropriate image by clicking ‘Choose’ button & then click ‘Ok’ button to create picture package your picture package will be created. So by this way you can create as many job a file as your needs.
Creating multiple image picture package
By using picture package option we can create a package, of multiple copies of same image. It is also possible to create a picture package of different images in photo shop. This can be used to create catalogue of photos. This is known as contact sheet. Here are the steps to achieve this-
Step 1: Close all opened images, create a folder & copy all images into this folder, which you want in the catalogue.
Step 2: Click File>Automate>Contact Sheet II
Step 3: ‘Contact Sheet II’ dialog box will be appeared on the screen.
Step 1: Close all opened images, create a folder & copy all images into this folder, which you want in the catalogue.
Step 2: Click File>Automate>Contact Sheet II
Step 3: ‘Contact Sheet II’ dialog box will be appeared on the screen.
Step 4: Click ‘Choose’ button & specify folder name which contains images which you want to be appeared in the contact sheet.
Step 5: Under document options specify width & height of the contact sheet document & also specify appropriate resolution & unit of resolution & color mode.
Step 6: In thumbnail section you can specify layout of the document. By place option you can choose either ‘Across First’ or ‘Down First’. ‘Across First’ means images will be filled horizontally & ‘Down First’ means images will be filled vertically into the document. In thumbnails section also specify no of colums & rows that you want in contact sheet document.
If you specify 2 columns & 3 rows then total 6 images can be appeared in one contact sheet. If the folder which you have specified here has more images then according to no. of images more contact sheets will be created automatically.
Step 7: Select ‘Use filename as caption’ to give captions to images as filename & you can also choose font & font size for the caption.
Step 8: Dialogue box also shows preview for the contact sheet click ‘Ok’ button to create contact sheet.
Creating an action to automate the task:
An action is a series of commands like a batch file that you can play back. Through action we can automate any photoshop job for example you can create an action for creating Array of passport / Stamp size photos, just suppose you want to create an Array of 16 (2×3) inches images. Here are the steps to create an action for above job.
Step 1: Open an image for which you want to create an Array
Step 2: Open actions pallate by clicking window>Show actions.
Step 3: Click ‘Create new action’ button from action pallate.
Step 4: New action dialogue box will be appeared on your screen, give appropriate action name & also choose a function key for shortcut then press ‘Record’ button to start recording.
Step 5: Now we have to create a pattern for the image which we have opened so click ‘Select’ menu then choose ‘All’ from the menu.
Step 6: Go to ‘Edit menu’ & click ‘Define pattern’ option. A dialogue box will be appeared on the screen give appropriate pattern name & press ‘Ok’ button pattern of image will be created.
Step 7: This pattern can be filled in any document so create a new file by clicking File> New give appropriate value for the width, height & resolution & choose color mode & then press ‘Ok’ button. Here I am giving width as 8 inches & height as 12 inches.
Step 8: Click ‘Edit’ menu & choose ‘Fill’ option from the menu. ‘Fill’ dialogue box will be appeared on the screen under contents select use ‘Pattern’ from the drop down list & from the ‘Custom pattern’ choose pattern which you have created under ‘Blending’ choose appropriate mode & opacity & then press ‘Ok’ button & that’s all recording job is over.
Step 9: Now stop recording by clicking ‘Stop recording’ button from action pallate.
Using an action
Follow the steps to use the action –
Step 1: Open an image for which you want to create an action.
Step 2: Press the shortcut key of action which you have defined. Action will be played & array of passport size photo will be ready automatically. All jobs which
you have defined in action will be done automatically. By this way you can create as many actions as you need. Actions can be saved for future use. To save an Action first you need to create an action set by clicking ‘Create new set’ button from the action palate & then create new actions & save the actions by ‘Save Action’ options from the action pallate further this action can be loaded by choosing ‘Load Actions’ option from the action pallate. Action can be created for any job it saves our valuable time.
22
Jul
Microsoft Excel is a powerful spreadsheet software. I have a student report sheet in MS-Excel. There are three columns in this sheet.
Column A : Name of the students
Column B : Marks Obtained
Column C : Grade
Column A and Column B are the inputs by the user and Column C is grade of the students that is depend on following four criteria:
1. if obtained marks are more than or equals to 80 and less than 90 grade would be “A”
2. if obtained marks are more than or equals to 70 and less than 80 then grade would be “B”
3. if obtained marks are more than or equals to 60 and less than 70 then grade would be “C”
4. if obtained marks are less than 60 then grade would be “Failed”
For above purpose put this “IF” function in C4 column
The function is =IF(B4>=80,”A”,IF(B4>=70,”B”,IF(B4>=60,”C”,”Failed”)))
and then copy this function to all the required cells.
Now I need some conditional formatting on column C for the following criteria:
a. If marks are greater than or equals to 80 and less than 90 then background color of the cell should be green
b. If marks are greater than or equals to 70 and less than 80 then background color of the cell should be purple
c. If marks are greater than or equals to 60 and less than 70 then background color of the cell should be gray
To achieve this follow the step by step process:
Step 1: Select the cells of C column (Grade) where conditional formatting to be applied.
Step 2: then click Format Menu.
Step 3: then choose Conditional Formatting.. From the menu.
Step 4: Conditional formatting dialogue box will be appeared on the screen. Under condition 1 choose Formula Is from the drop down menu and then type this formula in the text box.
=AND(IF(B4>=80,B4<90))
Step 5: then click Format button to assign formatting.
Step 6: Format cells dialogue box will be appeared on the screen. Click Patterns tab on the window and then choose desired color. In our case we will select green color and then press Ok button.
Step 7: Now press Add button to add second conditional formatting condition.
Step 8: Repeat the Step 4 to 6 for the next 2 conditions and assign their different formula and colors.
We can assign total three conditions for conditional formatting.
Now try with different marks, when you change marks, according to the marks background color of the cell will be changed.
Changing of a password of any a/c on net is good practice for security reason. But sometimes we don’t know how to do it. Here I am going to show you step by step process to the same.
It is a very simple and easy process.
Step 1: Login to your Gmail a/c with recent Password and ID
Step 2: Click on Settings (Located at upper right corner).
Step 3: Then click Accounts and Imports tab.
Step 3: Now click Google account Settings under Change Account Settings.
Step 4: A new window appears on the screen. there click Change password option
Step 5: There type in your Current password, New password and Confirm new passoword.
Step 6: Then click Save button and you are done.
By this way you can change password of your Gmail account.
20
Jul
Welcome to WordPress. This is your first post. Edit or delete it, then start blogging!
