Naushad Qamar

NICOP Procedure Online -Overseas ( Dubai ) resident guide

2016-03-09T10:19:00.002+05:00

NADRA Provide us a very good facility to get NICOP at your door step. Here I am sharing my experience how I obtained NICOP in only 15 days at my door step in Sharjah. Below is the procedure :

1)Goto to Nadra website Click here .
2) Now Register By Clicking on Register An Account

3)Now fill the form and continue

4)Now after login you will see terms and condition page and the below page will visible. Click on Go to identity M

5) Now Click on New Application

6) Now follow the steps

7)Fill all the information name , address etc.

8) Upload documents photo with white background , passport scan copy, NIC scan Copy , Marriage certificate (if married of course :)) and birth certificate as I have modify my birth place destrict .

9) You need 2 reference of any friend so you need their Id card number

10) For you finger prints you have to fill finger print form that form have tracking Id where

Sample finger print form can be downloaded from Nadra's Download page or click here

11)Now Print out finger print form and using black stamp pad put all the finger prints on mentioned boxes in the form.

12)Now Scan this finger print form , while scanning you must select 600 DPI and grey scale option that is available in scanners option. If you not chose these options your form will not be accepted.

I have paid 6400 rupees by credit card 5400 is the fees and 1000 is delivery fees for Sharjah/ Dubai and received my NICOP in 15 days.

Summary of the Process :

Click on the green Get Started button at the top to launch the Pak-Identity Application System

Create an application in the appropriate category

Provide details for the following:

Personal

Spouse / Parents

Relatives

Scan and upload your photograph Must be white background

Scan and upload the supporting documents like passport, birth certificate etc

Download and print the fingerprint form on A4/Letter page size.

Capture your fingerprints on this form with the help of the Fingerprint guide available in nadra page.

Scan and upload the fingerprint form.

Scan quality must be a minimum of 600 dpi in Grayscale.

Review the information you provided and sign the declaration.

Provide your address for card delivery.

Pay application fee online with your Credit Card/Debit Card.

Now wait in 15 days you will get the Nicop in your door step :)

Procedure To Renew Pakistani passport in Dubai UAE ( 7 March 2016 ) Latest

2016-03-06T22:43:00.001+05:00

You can renew your pakistani passport from pakistani consulate located in Bur-Dubai Khaleed bin waleed road near Burjuman Shopping Mall :

Here is the Google Maps location

Try to reach as early as possible around 7:00 am is better sometimes they stop providing token after 11 . If you have family you will complete the procedure very soon because there is a separate lines for ladies.

Documents Required For Pakistani Passport Renewal in Pakistani consulate Dubai :

Original Passport.

Original CNIC or NICOP.

Copies of passport, Visa and CNIC.

Passport Renewal Fees / charges :

5 year expiry
151 AED for normal process ( It will take around 25 days)
251 AED for urgent process ( It will take around 10 days )

10 year expiry :

272 AED for normal process ( It will take around 25 days)
452 AED for urgent process ( It will take around 10 days )

Procedure :

From main gate there is a token machine get Token number and wait
Bank Counter: Fee payment at Bank counter
Token Counter: Photo capturing and issuance of computerized token
Bio Matric Counter: Thumb Impression
Data Entry Counter: Data acquisition by DEO
Decision Counter: Form Submission at Passport Decision counter.

Passport collection :

You can collect your passport from Pakistan consulate on the date written on slip and don't forget to bring your old passport when your are going to collect your new passport.

You can go to TCS counter and counter 10 where they will take your old passport and slip and their charger around 10 to 15 AED and deliver your passport at your door step .

Parking :
In the morning you will find paid parking their but not too much and after 10:00 am there will be very difficult to find parking .
Parking zone Number is 134A near Pakistan consulate you can send SMS to 7275 along with your plate number and hours like this plate_no 134A 1 and send it to 7275

Highlight Active Cell in MS Excel 2007

2010-07-07T23:47:00.006+05:00

It is a very common problem that during presentation of any MS excel File we want to highlight active cell. There is some modules available but they might affect the format of your sheet.By adding this module to your sheet you can minimize this problem for example if you want to highlight the cell where you are working as shown in figure1.

for adding this feature to your excel sheet follow the steps Given below.

Step 1: Press ALT + F11 you will get the following screen

Step 2:Now Double Click on this Workbook and add following Module :

' Author Naushad Qamar
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Excel.Range)
On Error Resume Next
Static OldRange As Range
Static OldIndex As Integer
Const movingColor = 6
If OldRange.Interior.ColorIndex = movingColor Then
OldRange.Interior.ColorIndex = OldIndex
End If
OldIndex = Target.Interior.ColorIndex
Set OldRange = Target
Target.Interior.ColorIndex = movingColor

End Sub

Step3:Now open your worksheet you will find active cell highlighted..

Step4: Now save File as Macro enabled as shown in figure :

Working sample Download
Please Do Comment and give suggestions, moreover if you have any query, feel free to ask.

Firm valuation (Monte Carlos Application)

2010-06-04T13:19:00.002+05:00

For Firm valuation I used Monte Carlos Application.

For Monte Carlos Application I generated Random Values By using following macro
Sub montecarlos()
'This macro performed montecarlo simulations'
For rownum = 2 To 301

Range("b9").Value = Cells(rownum, 10).Value
Range("B11").Value = Cells(rownum, 11).Value
Cells(rownum, 13).Value = Range("c85").Value

Next rownum
End Sub
this Method will help to identify the riskiness of the project.
here is the link of complete template :
Monte Carlos Application Download link

GPA Calculator

2010-01-08T13:17:00.010+05:00

After Cliking on the given link you will see your iGoogle page like this:

for 1st semester.

Now You can Calculate your GPA:

-----------------

If you have any repeat Course then replace "No" with yoour Old GPA,for "F" insert "0" (zero)

Embeded or Add on your Blog or website just Copy paste the Code given below:

STRONG APPLICATION OF INDEX & MATCH, A PRACTICAL TOUCH.

2009-12-09T20:35:00.002+05:00

Hi,

Attached herewith a good template, with using of Match index. I applied these tools on media industry, but sure that can be used in any industry.

Download

Regards,

Valuation by DDM Method

2009-11-12T17:23:00.001+05:00

Dear All,

You may find herewith a good template Valuation by DDM (dividend discount model), I got this article and example from aswath damadron.
Aswath is a professor of Stern School of Business, New York University. Template is based on actual data.

In template, please take blue font as a variable.

To download template, please click here;

Download

Complicated Nested IF Loop (MS EXCEL).

2009-10-25T13:55:00.001+06:00

My Friend asked me a Question and for him I have made this template. In this template I have try to describe using of Nested loop.
The scenario is that we have different shops in our company and we want to see in which month sale has changed so our result will be that month like june on row 2
The Wokring formula is in column Q.
Download Template:

Financial Feasibility study of business plan

2009-10-17T17:53:00.003+06:00

A good template has been developed, in this template please take blue font as a variable. This is good template for new business and can be applied for existing one.

I worked on the longterm financial projection of 4 years and after that supposing the business is in stable phase. Due to this reason applied terminal growth from fifth year.

Please review and add your comments so that could furth improve it.
I did not focus on cost of equity, took it simple.

Download

ACCOUNT ANALYSIS (APPLICATION OF SUM ARRAY) :Extracting Data from Ledger:

2009-09-22T13:35:00.004+06:00

I am presenting herewith another method of extracting data from ledger, with using of strong tool of sum array. To run sum array you will have to enter "Ctrl SHIFT ENTER" then array will work.

This is a practical approach, please apply and enjoy the template. Through these method "Sum Array function" you can become more productive.

For download click HERE

Jamal Qamar

Business Plan Template

2009-09-19T11:25:00.009+06:00

Hi,

Please download herewith a good business plan template.
You can apply this business plan template in your practical life.
This is also very good for university student. Go through meticulously and try to become an entrepreneur rather than to go for job, not try to become servant.

I got also this template from intrnet, and applied this template in my practical life.

For download the template, go to the link given below.

Download

Jamal

Mobile Computing begginers

2009-09-19T02:45:00.004+06:00

Well I just start working on Mobile Computing here i want to share some of my experience, hopefully it will helpful for beginners.

I am comfortable with .NET platform.So,I have a question which mobile is best for me for development Is:
IPhone,BlackBerry,HTC etc.

Answers:

*As I prefer to write code using the .NET Compact Framework, I go for the HTC Phone.
However,if you just want to try your hand at mobile phone programming, you can choose whichever phone you want as all of them include J2ME Emulators and you can write your programs in Java Micro Edition.

*Languages:
iPhone - Object C
Blackberry - C#
HTC - Java

*Development Tools/Resources:
iPhone - http://developer.apple.com/iphone/ (Includes documentation, guides, tutorials etc).
Blackberry - http://www.blackberry.com/developers/devel...abs/legal.shtml (Includes tutorials, tools and resources).
Note:With the iPhone dev kit you need an actual Mac.

Important thing is that IPhone being apple you will have the hardest time to promote software due to copyright of applications, yet the most money is in iphone aps. htc is the most open to aps. If you are just starting you are looking for a phone with open aps like G1 with android software. It is open software and anyone can make and upload aps. Please note that every phone have different capabilities so the app is limited by the device. Note that blackberry run throw a host server. and other phones go straight out to the internet.

Sales Analysis

2009-09-08T19:40:00.007+06:00

You may find herewith a very strong template for sales analysis. You can analyze sales by product wise, Employee wise, customer wise and product category wise on just one click. This is helpful for marketing analyst, financial analyst and other executives. The same template can be used for other activities like purchase. This will be just a support for you.
In this template you can compare current performance vs. last corresponding period and can identify variance % so that corrective action could be taken in mean time.
In this template you will have to just collect data from system with different field like product, category, employee and customers. If you have more field can use, in this situation definitely it will be more dynamic and more result oriented.
There is only one thing in which you have to be very careful, you will have to use unique head excel can easily do this work. I use choose function for this template and conditional formatting to hide when heads are not available.
Please send your comments so that in future it could be improved more.

Jamal Qamar

Donwload Template

ACCOUNT ANALYSIS (APPLICATION OF DSUM)

2009-09-04T15:51:00.016+06:00

This is a good template for those who work particularly on account analysis. I considered here expense account for this purpose.

DSum function is very good for grouping data from ledger; someone uses Sumifs (only available in Office 2007), Sumif and Sum array function for achieving this objective.

You can also use DCount, DAverage, DCount, DGet and DProduct in place of DSUm, but should be careful in working.

Only thing which you have to learn in DSum is its criteria option, put focus on criteria go to internet and learn more. The function will make your routine work very simple.

The function of Database (DSum, DCount, DAverage, DCount, DGet and DProduct) will be suitable also for marketing professionals because they can analyze data on product wise, region wise, sales personnel wise and etc.

For more useful Template Click on Link shown Top of the page.

Download Dsum Template Link1

Download Dsum Template Link2

For more Useful Excel Templates & Analysis Tips, visit links Given Below.university national admission UK

Cash Receipt Template(MS Excel)

2009-08-31T01:51:00.016+06:00

This is a good template for those who work on monthly feasibility study for a longer time of period. I used three methods, used any one as per your convenience.
In this template you have to select receivable days, the model will adjust receivable amount, GST, Bad debts, write off and cash receipt automatically. Please consider blue font as a variable.
To achieve this objective, I used Hlook up function extensively. Through this model, I made my financial model more and more automated. Earlier, I have to manage receipts, bad debts and write off manually for direct cash flows.
Same tips one can apply as per his/ her requirement. This will be helpful particularly for Account, Finance and other Business professionals. It has been designed in more sophisticated way so that everyone could get advantage of it.

Please go through the template meticulously.

Note:
Through this template:
· You may learn Data Validation.
· You can apply H lookup function.
· You may use Nested If function and IsError.
· You may apply Index and Match function.

Download Template Link 1

Download Template Link2

Snapshot is given below for your interest.

Variance Analysis (MS Excel)

2009-08-30T15:46:00.022+06:00

This template is very strong.
This will be helpful particularly for Account, Finance and other Business professionals. Through this template, you can manage your periodic reporting in more effective and efficient way and definitely you will be more and more productive.
It has been designed in more sophisticated way so that everyone could get advantage of it. In data sheet, you will have to take care of sensitive area any deletion or insertion may create problem.
Please go through the template meticulously.
Note:
Through this template:
· You may learn Vlookup
· You may use Choose function.
· You may apply Offset function.
· You may use Text function with date

Click here to Download Link1

Click here to Download :Link2

Snapshot is given below for your interest.

Final Year Project

2009-08-29T01:46:00.003+06:00

Final Year Project (FYP) the time when you have to register your FYP the basic problem is Project "Idea". Something new,Somthing unique, never implemented before...blah blah :) a hell alot of constrains.

Well I research to find some new Idea,i found some links which i want to share, i hope it will helpful for Final Year students of Computer Science.

http://www.dreamincode.net/forums/showtopic78802.htm

University of Limerick

Queen Mary UNIVERSTY Of LONDON

IIUM, Gombak, Malaysia

University of Hertfordshire School of Computer Science

University of Mauritius

http://computerprojectideas.projectguidance.com/

Well I chose Project on Computer vision.Here is a video which will give you an idea about computer vision projects.

I found an (open source, C#) framework for image processing AForge.Net.

In AForge.Net you can find samples and very helpful documentation just check AForge.NET website .