હિમાંશુ પરભુભાઇ મિસ્ત્રી | Himanshu Mistry

જુલાઇ 5, 2012

Step by Step Guide for Aircel GPRS settings on PC

Filed under: GPRS settings,how to,Internet,Useful Links,web-technology — Himanshubhai Mistry @ 12:27 પી એમ(pm)

Step by Step Guide for Aircel GPRS settings on PC

I recently tried AIRCEL GPRS on my PC.

didn’t get any information from the Customer Care. But Google is the best friend ….

I got extensive information form below website:

 http://guideocom.blogspot.in/2011/08/how-to-connect-aircel-gprs-to-pc.html

followed the steps given in it.

How to connect Aircel GPRS to PC (Windows 7) via Bluetooth modem or mobile phone

Get connection:

Step 01: Send a request through an SMS (Send <GPRS>to 121) or call the customer care (121).

Get the settings:

Step 02: After the request they will send u the settings within 24 hours.

Activation:

Step 03: Now e-recharge with Rs 14(three days) or Rs: 98(30 days) .If you have balance, you can activate this service by sending SMS<P14> or <P98> to 57788 .This is a toll free number.

Connecting to Pc :

Step 04: Switch on Bluetooth in your phone and PC.

Step 05: In PC select Phone and Modem in Control Panel and select modems tab.

Step 06: Select Standard Modem over Bluetooth link and click Properties.

Step 07: In Generals tab click Change Settings

Step 08: Click Diagnostics tab and then Query Modem to check whether the modem is working properly.

Step 09: In Advanced tab type the following as Extra initialization command:
If yours is prepaid: AT+CGDCONT=1,”IP”,”aircelgprs.pr”
above did’t work so I changed
from
“aircelgprs.pr”  to “aircelgprs”
For post paid: AT+CGDCONT=1,”IP”,”aircelgprs.po”
And then press OK.

Step 10: Open Network and Sharing Center
Click Set up a new connection or network

Step 11: Select Set up a dial up connection and then press Next.

Step 12: Select Standard Modem over Bluetooth link

Step 13: If Aircel GPRS is the default profile type *99# in the Dial-up phone number box  and then press Connect.
If it doesn’t work try the following one after the other:

*99***1#

*99***2#

*99***3#

*99***4# and so on

1,2,3,4 is nothing but the order of Aircel
GPRS profile in your phone’s GPRS account.

 

 

Advertisements

મે 5, 2011

Change the Look-and-Feel (Design) of Lotus Notes 8.5

Filed under: how to,learning,Useful Links — Himanshubhai Mistry @ 2:53 પી એમ(pm)

I upgraded Lotus Notes from 7.5 to 8.5 using ISSI.

Even after upgrading to 8.5, the look-n-feel was quite similar to 7.5.. the advanced option didn’t get applied. especially the menu and online/offline status of Sametime contacts in the “To and CC” lists..

I had been searching on web for “change look and feel of lotus 8.5″… later on I got the correct keywords — that is “change design of lotus 8.5” and got some help in below given link.

http://publib.boulder.ibm.com/infocenter/domhelp/v8r0/index.jsp?topic=/com.ibm.notes85.help.doc/app_replace_design_t.html

Let’s try with the help give above and see.. else the ITHelpDesk is always there.

સપ્ટેમ્બર 26, 2010

matrutva ni kedie .. for pregnant ladies (in Gujarati)

Filed under: Useful Links — Himanshubhai Mistry @ 10:08 એ એમ (am)

I visited a wonderful blog gives detailed knowledge needed to women who are expecting a child..

This blog is in Gujarati 

Visit it here : http://matrutvanikediae.blogspot.com/

આખેઆખો બ્લોગ ગુજરાતીમાં .. વળી ટેકનોલોજીકલ માહિતી સાથે ….

ફેબ્રુવારી 23, 2009

“RFIND is not active” in the SDSF

Filed under: learning,mainframe,Useful Links — Himanshubhai Mistry @ 8:26 પી એમ(pm)

RFind PF5/PF6 is not working in my SDSF

In SDSF  the Repeat find command is not available as the application ID is different and do not share the same keys listing as ISPF….

We have to change the keys list for SDSF (one time setting –of course in one shop)

  1. Go to SDSF;ST
  2. Select all of any JOB
  3. Type ‘keys’ and hit return key
  4. On PF5 (or PF6) type IFIND in stead of RFIND
  5. Hit PF3 

VOILA… WE are done…!!!

Now WE can repeat find using the same PF5 (or PF6) as we do in ISPF……..

+++++++++++++++++++++++++++++++++++++++++++++++++

Courtesy: 

+++++++++++++++++++++++++++++++++++++++++++++++++

I got the information from following websites:

http://www.davar.net/MF/REFER/FAQ.HTM

http://www.mvshelp.net/vbforums/showthread.php?p=206522

Steve,
SDSF runs under a unique Application ID so the PFkey definitions are separate from ISPF. Enter KEYS when in SDSF to verify the value for PF5.
__________________
Regards,
Bill Dennis
+++++++++++++++++++++++++++++++++++++++++++++++++
also read this 
+++++++++++++++++++++++++++++++++++++++++++++++++
Hi I found the following statement in the appendix of the sdsf manual … maybe it helps       

If you use the Repeat-Find PF keys under ISPF and they don’t invoke the 
Repeat Find function, the problem may be that the SDSF table library was 
not concatenated correctly with the ISPF table libraries. You may also see 
the ISPF message RFIND NOT ACTIVE to indicate this. The SDSF Repeat-Find key should be defined as IFIND.

+++++++++++++++++++++++++++++++++++++++++++++++++

જુલાઇ 30, 2008

How to lock a column/row/cell in MS Excel

Filed under: how to,Useful Links — Himanshubhai Mistry @ 9:31 પી એમ(pm)

How to Lock a column MS Excel

some time we need to lock a column from the end user protecting from accidental changes.

scenario:

   A           B 
1 data1      =fun(A1)
2 data2      =fun(A2)
3 data3      =fun(A3)

We want the user to allow key in data in column ‘A’
Function given in column ‘B’ will produce result and user will be able to view the result.
we don’t want the user to select/edit the cells of column ‘B’

steps how to achieve this:
[1] Select the columns (or rows/cells) the user should be able to to TYPE data into.
[2] Format menu / Cells / protection tab
[3] Remove the tick-mark from ‘locked’
[4] Tools menu / protection / protect sheet and apply protection

You will find that you can only type data in the cells that you selected and then removed the ‘locked’ tick-mark from.

This is applicable for cells, columns or rows..

Date Functions in MS Excel

Filed under: Useful Links — Himanshubhai Mistry @ 9:11 પી એમ(pm)

I found good information about Date related functions available in Microsoft Excel, from www.officearticles.com  website

Here it goes:

Today’s date and time:
=NOW()
Today’s date only:
=TODAY()

Day of the month for a specific date:
=DAY(TODAY())

Day of the week for a specific date (set the cell format to custom format “dddd”):
=WEEKDAY(TODAY())
=TEXT(WEEKDAY(TODAY()),”dddd”)

Month of the year for a specific date:
=MONTH(TODAY())

Year for a specific date:
=YEAR(TODAY())

Date for a specific year, month and day (Example returns 6/12/2005):
=DATE(2005,6,12)

Add days to a date (one week from today):
=TODAY()+7

Subtract days from a date (one week ago today):
=TODAY()-7

Last day of the this month:
=DATE(YEAR(TODAY()),MONTH(TODAY())+1,1)-1
or
=EOMONTH(TODAY(),0)

Last workday of the current month:
=IF(WEEKDAY(EOMONTH(TODAY(),0))=6,EOMONTH(TODAY(),0)-1,IF(WEEKDAY(EOMONTH(TODAY(),0))=1,EOMONTH(TODAY(),0)-2,EOMONTH(TODAY(),0)))
or
=WORKDAY(DATE(YEAR(TODAY()),MONTH(TODAY())+1,1),-1,Holidays)

First workday of the following month:
=WORKDAY(DATE(YEAR(TODAY()),MONTH(TODAY())+1,1)-1,1,Holidays)

Number of workdays in the current month:
=NETWORKDAYS(DATE(YEAR(TODAY()),MONTH(TODAY()),1),EOMONTH(TODAY(),0),Holidays)

Last workday in range of days (A1 is start date, B1 is number of days in the period):
=WORKDAYS(A1,B1,Holidays)

DATEDIF() Syntax & Examples
The DATEDIF() function uses the following syntax:

=DATEDIF(start_date,end_date,”code”)

The start date must be less than the end date, or the function returns an error.

The following are the codes for the DATEDIF() function:

“y” Years
“m” Months
“d” Days
“md” Difference between days in a period; no month and years
“ym” Difference between the months in a period, no days and years
“yd” Difference between the days in a period, no years
Examples
To calculate the number of years between two dates:
=DATEDIF(A1,TODAY(),”y”) & ” Years”

To calculate the number of years and months between two dates:
=DATEDIF(A1,TODAY(),”y”) & ” Years, ” & DATEDIF(A1,TODAY(),”ym”) & ” Months”

To calculate the number of years, months, and days between two dates:
=DATEDIF(A1,TODAY(),”y”) & ” Years, ” & DATEDIF(A1,TODAY(),”ym”) & ” Months, ” & DATEDIF(A1,TODAY(),”md”) & ” Days”

Using the TEXT() function to calculate dates.
You can use the TEXT() to get the number of days or weeks between two dates:

Examples
Number of days:
=VALUE(TEXT((NOW()-$A$1)/24,”[h]”))

Number of weeks:
=VALUE(TEXT((NOW()-$A$1)/168,”[h]”))

source : http://www.officearticles.com/excel/date_formulas_and_functions_in_microsoft_excel.htm

ઓક્ટોબર 27, 2007

Desk top Utility – Calender – TD-DO – EVENTS

Filed under: Useful Links — Himanshubhai Mistry @ 11:04 એ એમ (am)

Desk top Utility – Calender.

http://www.rainlendar.net/cms/index.php

ઓક્ટોબર 15, 2007

PC Desktop Utility CLOCK, Magnifier and MouseZoom

Filed under: Useful Links — Himanshubhai Mistry @ 9:09 પી એમ(pm)
Tags: , , ,

Desktop Utility CLOCK

http://www.clocx.net
http://www.clocx.net/whatsnew.php

Screen Magnifier : FREE
magnifies a part of screen

http://freestone-group.com/magg.htm
This program replaces the cursor with a magnifier. The big set hot keys, a dynamic zoom, brightness and size, an opportunity to make screenshots in clipboard. In settings it is possible to replace the cursor with a magnifier. There are no additional windows. Does not hinder work by the mouse, it is good for editing pixel in the graphic editors, and it is simple for examining small-sized details. When Magical Glass is running you will see a Magical Glass icon in the system tray (located at the end of the task-bar.)

MouseZoom
another screen zooming utility FREE
Gets captured  in print screen too.
http://www.neuber.com/free/mousezoom/index.html

Gujarati Garba download

Filed under: Useful Links — Himanshubhai Mistry @ 12:07 પી એમ(pm)
Tags:

This morning my friend/sister (Darshita Shah)  sent me this website link:

http://www.humsurfer.com/view/download-free-gujarati-garba-raas-dandiya-mp3-music-indian

Gujaraties residing outside of Gujarat can download and enjoy Navaratri playing this garba from iternet.

Blog at WordPress.com.