Search This Blog

Search Engine

Custom Search

20090125

Dentist at Bhosari, Pune

Sable Dental Clinic,
Dr. D.M. Sabale,
B.D.S.M.D.S (Mumbai)
Reg. No. 5732

Address -

Janai Heights,
1st Floor,
P.M.T. Chowk,
Pune-Nasik Road,
Bhosari, Pune-39
Landline - 27110433

Timings -
From Monday to Saturday
10 AM TO 1 PM & 5 PM TO 8.30PM


Doctor at Dhavdevasti,Bhosari

Anand Clinic

Dr. Dattatrey Ghavte
Reg. No.-I-27175
B.A.M.S., C.C.H.C.G.O
Mobile - 98220 91914

Time -
Morning - 9 AM to 3PM
Evening - 5PM to 11PM

Address :-
At Dhavdewasti,
Shivganesh Nagar,
Dhavde Vasti,
Pune- Nasik Road,
Bhosari ,
Pune - 39

20090124

How to convert excel and word into Acrobat?

How to convert the Excel file directly into PDF?


METHOD - 1 (NEW METHOD)

Open Excel File.
Click on File
Click on SAVE AS
In Save AS option - Select PDF
File will be saved as PDF File.




METHOD - 2 (OLD METHOD)

Go to http://www.primopdf.com/

Download primo pdf from this site.
Download the free version - 10.8 MB Install as per instructions and step given

After Installation is complete Open excel file or the Word File
Go to - File - Print
In Select Printer instead of selecting regular HP Laser Printer or HP Deskjet Printer
Select New printer- Primo PDF
By installation of Primo PDF this new printer becomes visible in Printer Options of any word or excel file
Then click Command Print means Give Print
So the excel or Word file will be converted into PDF.

WHAT IS THE FORMULA FOR STATING DAY FOR ANY GIVEN DATE IN EXCEL?

FORMULA FOR STATING DAY FOR ANY GIVEN DATE











27/11/2008 = Thu

Use Formula as given below

.=TEXT(A7,"ddd")


And for getting

27/11/2008 = Thursday

Use Formula as given below

.=TEXT(A7,"dddd")

Place the same against your birth date & year & you will be getting on which day you were born

Means write your birth date say 26-6-1977 & use formula = text (A7,"ddd) where A7 = Birth date with year & one gets birth week day for his birth date

20090109

HDFC Home loan branch at Chinchwad,Pune

Home > Contact HDFC > Branches in Pune (Red one of HDFCs means Loan givers)



Within PUNE )
1) PUNE(CAMP)
2) PUNE(CHINCHWAD)
3) PUNE(KOTHRUD) PUNE
4) (MAGARPATTA CITY - HADAPSAR)
5) PUNE(NAGAR ROAD) PUNE(UNIVERSITY ROAD)

ADDRESS AT
PUNE(CHINCHWAD)
HDFC COMPLEX, PLOT NO. RC-1, SURVEY NO. 100, MIDC G BLOCK , TELCO RD., CHINCHWAD, PUNE - 411019
INDIA
TEL: +91 (20) 27481736 FAX: +91 (20) 27450190
WORKING DAYS: MONDAY TO FRIDAY
WORKING HOURS: 9:30 AM TO 5:15 PM
CONTACT PERSON: MR HARSHAD TAWADE

For finding branches all over India web-link is given below : -
http://www.hdfc.com/others/hdfc_branch_locator.asp

All HDFC branches are located here

20090107

Contact No. for Laptop repairers in Pune


Contact No. for Laptop repairers in Pune


AKON - 4106 4444

Tally Shortcut keys


Function Key Combination



Windows
Functionality
Availability
F1
To select a company
At all masters menu screen
F1
To select the Accounts Button
At the Accounting Voucher creation and alteration screen
F1 (ALT+F1)
To select the Inventory Button
At the Inventory/Payroll Voucher creation and alteration screen
F1 (CTRL + F1)
To select Payroll Vouchers to alter
At the Accounting/Inventory voucher creation or alteration screen.
F2
To change the current date
To select company inventory features
At almost all screens in TALLY
At the F11: Features screen
F3
To select the company
To select Company Statutory & Taxation features
At almost all screens in TALLY
At F11: Features screen
F4
To select the Contra voucher
At Accounting / Inventory Voucher creation and alteration screen
F5
To select the Payment voucher
At Accounting / Inventory Voucher creation and alteration screen
F6
To select the Receipt voucher
At Accounting / Inventory Voucher creation and alteration screen
F7
To select the Journal voucher
At Accounting / Inventory Voucher creation and alteration screen
F8
To select the Sales voucher
At Accounting / Inventory Voucher creation and alteration screen
F8 (CTRL+F8)
To select the Credit Note voucher
At Accounting / Inventory Voucher creation and alteration screen
F9
To select the Purchase voucher
At Accounting / Inventory Voucher creation and alteration screen
F9 (CTRL+F9)
To select the Debit Note voucher
At Accounting / Inventory Voucher creation and alteration screen
F10
To select the Reversing Journal voucher
At Accounting / Inventory Voucher creation and alteration screen
F10 (Ctrl + F10)
To select the Memorandum voucher
At Accounting / Inventory Voucher creation and alteration screen
F11
To select the Functions and Features screen
At almost all screens in TALLY
F12
To select the Configure screen
At almost all screens in TALLY

Special Key Combination


Windows
Functionality
Availability
ALT + 2
To Duplicate a voucher
At List of Vouchers – creates a voucher similar to the one where you positioned the cursor and used this key combination
ALT + A
To Add a voucher
To Alter the column in columnar report
At List of Vouchers – adds a voucher after the one where you positioned the cursor and used this key combination.
Alters the column in all the reports which can be viewed in columnar format
ALT + C
To create a master at a voucher screen (if it has not been already assigned a different function, as in reports like Balance Sheet, where it adds a new column to the report)
To access Auto Value Calculator in the amount field during voucher entry
At voucher entry and alteration screens, at a field where you have to select a master from a list. If the necessary account has not been created already, use this key combination to create the master without quitting from the voucher screen.
At all voucher entry screens in the Amount field
ALT + D
To delete a voucher
To delete a master
To delete a column in any columnar report
(if it has not been already assigned a different function, as explained above)
At Voucher and Master (Single) alteration screens. Masters can be deleted subject to conditions, as explained in the manual.
All the reports screen which can be viewed in columnar format
ALT + E
To export the report in ASCII, HTML OR XML format
At all reports screens in TALLY
ALT + I
To insert a voucher
To toggle between Item and Accounting invoice
At List of Vouchers – inserts a voucher before the one where you positioned the cursor and used this key combination.
At creation of sales and purchase invoice
ALT + L
To select the Language Configuration
At almost all screens in TALLY.
ALT + K
To select the Keyboard Configuration
At almost all screens in TALLY.
ALT + O
To upload the report at your website
At all reports screens in TALLY
ALT + L
To select language for Tally Interface
At almost all screens of TALLY
ALT + M
To Email the report
At all reports screens in TALLY
ALT + N
To view the report in automatic columns
At all the reports where columns can be added
ALT + P
To print the report
At all reports screens in TALLY
ALT + R
To remove a line in a report
At all reports screens in TALLY
ALT + S
To bring back a line you removed using ALT + R
At all reports screens in TALLY
ALT + U
To retrieve the last line which is deleted using Alt + R
At all reports screens in Tally
ALT+ V
From Invoice screen to bring Stock Journal screen
At Invoice screen à Quantity Field à Press Alt + V to select the Stock Journal.
ALT + W
To view the Tally Web browser.
At all reports screens in TALLY
ALT + X
To cancel a voucher in Day Book/List of Vouchers
At all voucher screens in TALLY
ALT + R
To Register Tally
At almost all screens in TALLY.
CTRL + A
To accept a form – wherever you use this key combination, that screen or report gets accepted as it is.
At almost all screens in TALLY, except where a specific detail has to be given before accepting.
CTRL + B
To select the Budget
At Groups/Ledgers/Cost Centres/ Budgets/Scenarios/Voucher Types/ Currencies (Accounts Info) creation and alteration screen
CTRL + ALT + B
To check the Company Statutory details
At all the menu screens
CTRL + C
To select the Cost Centre
To select the Cost Category
At Groups/Ledgers/Cost Centres/ Budgets/Scenarios/Voucher Types/ Currencies (Accounts Info) creation and alteration screen
At Stock Groups/ Stock Categories/ Stock Items/ Reorder Levels/ Godowns/ Voucher Types / Units of Measure ( Inventory Info) creation/alteration screen
CTRL+ E
To select the Currencies
At Groups/Ledgers/Cost Centres/ Budgets/Scenarios/Voucher Types/ Currencies (Accounts Info) creation and alteration screen
CTRL + G
To select the Group
At Groups/Ledgers/Cost Centres/ Budgets/Scenarios/Voucher Types/ Currencies (Accounts Info) creation and alteration screen
CTRL + I
To select the Stock Items
At Stock Group/ Stock Categories/ Stock Items/ Reorder Levels/ Godowns/ Voucher Types / Units of Measure ( Inventory Info) creation/alteration screen
Ctrl + Alt + I
To import statutory masters
At all menu screens
CTRL + L
To select the Ledger
To mark a Voucher as Optional
At Groups/Ledgers/Cost Centres/ Budgets/Scenarios/Voucher Types/ Currencies (Accounts Info) creation and alteration screen
At the creation and alteration of Vouchers
CTRL + O
To select the Godowns
At Stock Group/ Stock Categories/ Stock Items/ Reorder Levels/ Godowns/ Voucher Types / Units of Measure ( Inventory Info) creation/alteration screen
CTRL + Q
To abandon a form – wherever you use this key combination, it quits that screen without making any changes to it.
At almost all screens in TALLY.
CTRL + R
To repeat narration in the same voucher type
At creation/alteration of voucher screen
CTRL + Alt + R
Rewrite data for a Company
From Gateway of Tally screen
CTRL + S
Allows you to alter Stock Item master
At Stock Voucher Report and Godown Voucher Report
CTRL + U
To select the Units
At Stock Groups/ Stock Categories/ Stock Items/ Reorder Levels/ Godowns/ Voucher Types / Units of Measure ( Inventory Info) creation/alteration screen
CTRL + V
To select the Voucher Types
To toggle between Invoice and Voucher
At Groups/Ledgers/Cost Centres/ Budgets/Scenarios/Voucher Types/ Currencies (Accounts Info) creation and alteration screen
At creation of Sales/Purchase Voucher screen



Special Function Key Combination



Windows
Functionality
Availability
ALT + F1
To close a company
To view detailed report
To explode a line into its details
To select Inventory vouchers to alter
At all menu screens
At almost all report screens
At almost all screens in TALLY
At the Inventory/ Payroll voucher creation or alteration screen.
ALT + F2
To change the period
At almost all screens in TALLY
ALT + F3
To select the company info menu
To create/alter/shut a Company
At Gateway of Tally screen
ALT + F4
To select the Purchase Order Voucher Type
At Accounting / Inventory Voucher creation and alteration screens
ALT + F5
To select the Sales Order Voucher Type
To view monthly and quarterly report
At Accounting / Inventory Voucher creation and alteration screens
At almost all report screens in TALLY
ALT + F6
To select the Rejection Out Voucher Type
To change the Sales Order Voucher Type
At Accounting / Inventory Voucher creation and alteration screens
ALT + F7
To select the Stock Journal Voucher Type
To accept all the Audit lists
At Accounting / Inventory Voucher creation and alteration screens
At TallyAudit Listing screen
ALT + F8
To select the Delivery Note Voucher Type
To view the Columnar report
At Accounting / Inventory Voucher creation and alteration screens
At Ledger Voucher screen
ALT + F9
To select the Receipt Note Voucher Type
At Accounting / Inventory Voucher creation and alteration screens
ALT + F10
To select the Physical Stock Voucher Type
At Accounting / Inventory Voucher creation and alteration screens
ALT + F12
To filter the information based on monetary value
At almost all report screens
Ctrl + F1
To select payroll vouchers for alteration
At the Accounting/Inventory Voucher creation or alteration screen
CTRL + ALT + F12
Advanced Config
At Gateway of Tally

Key Combination used for navigation



Windows
Functionality
Availability
PgUp
Display previous voucher during voucher entry/alter
At voucher entry and alteration screens
PgDn
Display next voucher during voucher entry/alter
At voucher entry and alteration screens
ENTER
To accept anything you type into a field.
To accept a voucher or master
To get a report with further details of an item in a report.
You have to use this key at most areas in TALLY
At the receivables report – press Enter at a pending bill to get transactions relating to this bill (e.g., original sale bill, receipts and payments against this bill, etc)
ESC
To remove what you typed into a field
To come out of a screen
To indicate you do not want to accept a voucher or master.
At almost all screens in TALLY.
SHIFT + ENTER
Collapse next level details
At Voucher Register screen and Trial Balance report
SHIFT + ENTER
To explode a line into its details
In almost all Reports:
At a Group/Stock Group/Cost Category/Godown/Stock Category – displays Sub Groups and Ledgers/Stock Items/Cost Centres/Secondary Godowns/Secondary Stock Categories
At a Voucher – displays its entries and narration
At a Stock Item- displays its godowns and batch details
At Voucher Register screen – displays the next level details
At Trial Balance report - displays the next level details
CTRL + ENTER
To alter a master while making an entry or viewing a report
At voucher entry and alteration screens
At all reports

Access Formulas utilised in queries

FORMULA-1
Inv no : Reclist_mast.inv_type & Reclist_mast.inv_no
This combines Abbreivation of one column with number of other column in Microsoft access data table.
In other words it combines contents of two different cells located in 2 differenct columns and gives result in one single cell in query.

FORMULA-2
Rec dt : Format([ord_dt],"dd-mm-yyyy")
This gives date from [ord_dt] column but in OUR REQUIRED FORMAT

FORMULA-3
Rec Time : Format([ord_dt],"Shorttime")
This gives TIME from [ord_dt] column means it can churn out time from date column of Microsoft access in our required query.

FORMULA-4
Not moved for Days : Date( ) - Max ([Inv_date])
Used for Ageing report - Date ( ) means today's date (in access) - [Inv_date] means any date column of data table.

FORMULA-5
Days Past : Date( ) - [Date]
Used for Ageing report where [Date] is the date column of access table.

Hanuman Chalisa with Meaning

Hanuman Statue, near Arbuda Devi Temple, Mount Abu, Rajasthan

Photo Source -By https://www.flickr.com/photos/chromatic_aberration/ [CC BY-SA 2.0], via Wikimedia Commons




JAI HANUMAN GYAN GUN SAGAR JAI KAPISH TUHI LOK UJAGAR"








Shree Guru Charan Saroj Raj, Nij Man Mukar Sudhari,

Barnau Raghuvar Bimal Jasu, Jo dayaku Phal Chari 

With the dust of Guru's Lotus feet, I clean the mirror of my mind and then
narrate the sacred glory of Sri Ram Chandra, The Supereme among the Raghu
dynasty. The giver of the four attainments of life. 

Budhi heen Tanu Janike, Sumirow, Pavan Kumar,
Bal Buddhi Vidya Dehu Mohi, Harahu Kalesh Bikaar 

Knowing myself to be ignorent, I urge you, O Hanuman, The son of Pavan! O
Lord! kindly Bestow on me strength, wisdom and knowledge, removing all my
miseries and blemishes. 

Jai Hanuman Gyan Guna Sagar
Jai Kipis Tihun Lok Ujgaar 

Victory of Thee, O Hanuman, Ocean of wisdom and virtue, victory to the Lord of
monkeys who is well known in all the three worlds 

Ramdoot Atulit Bal Dhamaa,
Anjani Putra Pavansut naamaa. 

You, the Divine messager of Ram and repository of immeasurable strength, are also
known as Anjaniputra and known as the son of the wind - Pavanputra. 

Mahebeer Bikram Bajrangi,
Kumati Nivaar Sumati Ke Sangi. 

Oh Hanumanji! You are valiant and brave, with a body like lightening. You are the
dispeller of darkness of evil thoughts and companion of good sense and wisdom. 

Kanchan Baran Biraaj Subesaa,
Kanan kundal kunchit kesa. 

Shri Hanumanji's physique is golden coloured. His dress is pretty, wearing
'Kundals' ear-rings and his hairs are long and curly. 

Hath Bajra Aur Dhvaja Birjai,
Kandhe Moonj Janeu saage. 

Shri Hanumanji is holding in one hand a lighting bolt and in the other a banner
with sacred thread across his shoulder. 

Shankar Suvna Kesari Nandan,
Tej Pratap Maha Jag Vandan. 

Oh Hanumanji! You are the emanation of 'SHIVA' and you delight Shri Keshri.
Being ever effulgent, you and hold vast sway over the universe. The entire
world proptiates. You are adorable of all. 

Vidyavaan Guni Ati Chatur,
Ram Kaj Karibe Ko Atur 

Oh! Shri Hanumanji! You are the repository learning, virtuous, very wise and
highly keen to do the work of Shri Ram, 

Prabhu Charittra Sunibe Ko Rasiya,
Ram Lakhan Sita man basyia. 

You are intensely greedy for listening to the naration of Lord Ram's lifestory and
revel on its enjoyment. You ever dwell in the hearts of Shri Ram-Sita and Shri
Lakshman. 

Sukshma roop Dhari Siyahi Dikhwana,
Bikat roop Dhari Lank Jarawa 

You appeared beofre Sita in a diminutive form and spoke to her, while you
assumed an awesome form and struck terror by setting Lanka on fire. 

Bhim roop Dhari Asur Sanhare,
Ramchandra Ke kaaj Savare. 

He, with his terrible form, killed demons in Lanka and performed all acts of Shri
Ram. 

Laye Sajivan Lakhan Jiyaye,
Shri Raghubir harashi ur laye. 

When Hanumanji made Lakshman alive after bringing 'Sanjivni herb' Shri Ram
took him in his deep embrace, his heart full of joy. 

Raghupati Kinhi Bahut Badaai,
Tum Mama Priya Bharat Sam Bahi. 

Shri Ram lustily extolled Hanumanji's excellence and remarked, "you are as dear
to me as my own brother Bharat" 

Sahastra Badan Tumharo Jas Gaave,
Asa kahi Shripati Kanth Laagave. 

Shri Ram embraced Hanumanji saying:
"Let the thousand - tongued sheshnaag sing your glories" 

Sankadik Brahmadi Muneesa,
Narad Sarad Sahit Aheesa 

Sanak and the sages, saints. Lord Brahma, the great hermits Narad and
Goddess Saraswati along with Sheshnag the cosmic serpent, fail to sing the
glories of Hanumanji exactly 

Jam Kuber Digpal Jahan Te,
Kabi Kabid Kahin Sake Kahan Te 

What to talk of denizens of the earth like poets and scholars ones etc even Gods
like Yamraj, Kuber, and Digpal fail to narrate Hanman's greatness in toto. 

Tum Upkar Sugrivahi Keenha,
Ram Miali Rajpad Deenha 

Hanumanji! You rendered a great service for Sugriva, It were you who united
him with SHRI RAM and installed him on the Royal Throne. 

Tumharo Mantro Bibhishan Maana,
Lankeshwar Bhaye Sab Jag Jaana. 

By heeding your advice. Vibhushan became Lord of Lanka, which is known all
over the universe. 

Juug Sahastra Jojan Par Bhaanu,
Leelyo Taahi Madhur Phal Jaanu 

Hanumanji gulped, the SUN at distance of sixteen thousand miles considering
it to be a sweet fruit. 

Prabhu Mudrika Meli Mukha Maaheen,
Jaladhi Langhi Gaye Acharaj Naheen. 

Carrying the Lord's ring in his mouth, he went across the ocean. There is no
wonder in that. 

Durgam Kaaj Jagat Ke Jeete,
Sugam Anugrah Tumhre Te Te. 

Oh Hanumanji! all the difficult tasks in the world are rendered easiest by your
grace. 

Ram Duware Tum Rakhavare,
Hot Na Aagya Bin Paisare. 

Oh Hanumanji! You are the sentinel at the door of Ram's mercy mansion or His
divine abode. No one may enter without your permission. 

Sab Sukh Lahen Tumhari Sarna,
Tum Rakshak Kaahu Ko Darnaa. 

By your grace one can enjoy all happiness and one need not have any fear under
your protection. 

Aapan Tej Samharo Aapei,
Tanau Lok Hank Te Kanpei 

When you roar all the three worlds tremble and only you can control your might. 

Bhoot Pisaach Nikat Nahi Avei,
Mahabir Jab Naam Sunavei. 

Great Brave on. Hanumanji's name keeps all the Ghosts, Demons & evils spirits
away from his devotees. 

Nasei Rog Hare Sab Peera,
Japat Niranter Hanumant Beera 

On reciting Hanumanji's holy name regularly all the maladies perish the entire
pain disappears. 

Sankat Te Hanuman Chhudavei,
Man Kram Bachan Dhyan Jo Lavei. 

Those who rembember Hanumanji in thought, word and deed are well guarded
against their odds in life. 

Sub Par Ram Tapasvee Raaja,
Tinke Kaaj Sakal Tum Saaja 

Oh Hanumanji! You are the caretaker of even Lord Rama, who has been hailed as
the Supreme Lord and the Monarch of all those devoted in penances. 

Aur Manorath Jo Koi Lave,
Soi Amit Jivan Phal Pave. 

Oh Hanumanji! You fulfill the desires of those who come to you and bestow
the eternal nectar the highest fruit of life. 

Charo Juung Partap Tumhara,
Hai Parsiddha Jagat Ujiyara. 

Oh Hanumanji! You magnificent glory is acclaimed far and wide all through the
four ages and your fame is radianlty noted all over the cosmos. 

Sadho Sant Ke Tum Rakhvare,
Asur Nikandan Ram Dulare. 

Oh Hanumanji! You are the saviour and the guardian angel of saints and sages
and destroy all the Demons, you are the seraphic darling of Shri Ram. 

Ashta Siddhi Nau Nidhi Ke Data,
Asa Bar Din Janki Mata. 

Hanumanji has been blessed with mother Janki to grant to any one any YOGIC
power of eight Sidhis and Nava Nidhis as per choice. 

Ram Rasayan Tumhare Pasa,
Sadaa Raho Raghupati Ke Dasa. 

Oh Hanumanji! You hold the essence of devotion to RAM, always remaining His
Servant. 

Tumhare Bhajan Ramko Pavei.
Janam Janam Ke Dukh Bisravei. 

Oh Hanumanji! through devotion to you, one comes to RAM and becames free
from suffering of several lives. 

Anta Kaal Raghubar Pur Jai,
Jahan Janma Hari Bhakta Kahai. 

After death he enters the eternal abode of Sri Ram and remains a devotee of
him, whenever, taking new birth on earth. 

Aur Devata Chitt Na Dharai,
Hanumant Sei Sarva Sukh Karai 

You need not hold any other demigod in mind. Hanumanji alone will give all
happiness. 

Sankat Kate Mitey Sab Peera,
Jo Sumirei Hanumant Balbeera 

Oh Powerful Hanumanji! You end the sufferings and remove all the pain from
those who remember you. 

Jai Jai Jai Hanuman Gosai
Kripa Karahu Gurudev Ki Naiee 

Hail-Hail-Hail-Lord Hanumanji! I beseech you Honour to bless me in the
capacity of my supreme 'GURU' (teacher). 

Jo Sat Baar Paath Kar Koi,
Chhutahi Bandi Maha Sukh Hoi. 

One who recites this Hanuman Chalisa one hundred times daily for one hundred
days becames free from the bondage of life and death and ejoys the highest
bliss at last. 

Jo Yah Padhe Hanuman Chalisa,
Hoy Siddhi Sakhi Gaurisa 

As Lord Shankar witnesses, all those who recite Hanuman Chalisa regularly are
sure to be benedicted 

Tulsidas Sada Hari Chera,
Keeje Nath Hriday Mah Dera. 

Tulsidas always the servant of Lord prays. "Oh my Lord! You enshrine within my
heart.! 



Chopai 

Pavan Tanay Sankat Haran , Mangal Murti Roop.
Ram Lakhan Sita Sahit, Hriday Basahu Sur Bhoop. 

O Shri Hanuman, The Son of Pavan, Saviour The Embodiment of
blessings, reside in my heart together with Shri Ram, Laxman and Sita