Excel Tutorial

1
20
19
24
21
Total Hourse
Worked
190
200
231
210
Local Calls
Total Local
Charges
Total Mobile
Duration
12/12/2012
12/13/2012
12/14/2012
12/15/2012
67
400
320
113
134.67
804
643.2
227.13
22
45
67
81
Name
Worker Type
Emp #
A
B
C
B
121
122
123
124
user Id
Pay Date
1
2
3
4
Roll No
Empl Name
Days Worked
Sara
Sukena
Samun
Afaq Umair
1
2
3
4
Aftab
Aziz
Anjum
Mumtaz
P
P
P
P
P
P
P
P
A
P
P
A
4
Loans Amount
Years
Intrest Rate
100000
250000
500000
80000
5
6
8
2
7%
7%
7%
7%
Accumulated
Amount
140255
375183
859093
91592
5
Amount
Year
10000
10000
10000
11000
3
5
10
2
Intrest Rate Annual Profit

0.03
0.04
0.05
0.03
300 Question Says Add Interest Rate and Amount

400
500
330
6
Name
Noor
Aziz
Naseem
Mumtaz
9200
7800
12000
8400
Medical
Allownce
736
624
960
672
Labour Cost
Capital Cost
500
1200
1500
1600
10500
140000
450000
150000
Miscellaneous
Cost
1000
2000
4000
3000
Math
Physics
English
87
77
60
46
33
44
55
66
50
55
52
51
Basic Pay
House Rent
Gross Pay
3680
3120
4800
3360
13616
11544
17760
12432
7
Item
Motor Bike
Car
Luxury Car
High Roof
Gross Amount
12000
143200
455500
154600
8
Name
Anjum
Aziz
Naseem
Noor
Computer
Scince
60
76
68
80
9
Department
Engineering
Marketing
Computer
Sales
Purchases
Production
G.Total
Minimum
Maximum
Average
1st Quarter
25676
67567
64219
35651
12323
98981
304417
12323
98981
50736
2nd Quarter
45451
42434
56564
21312
15432
87861
269054
15432
87861
44842
3rd Qtr
54533
66554
45438
21222
23122
76765
287634
21222
76765
47939
4th Qtr
65651
54545
76543
32121
32121
88323
349304
32121
88323
58217
10
Meter
Number
1
2
3
4
5
11
Previous Unit
Current Unit
Units Consumed
Gas Charges
7382
88829
454512
13900
92348
7392
88840
454902
14000
92583
10
11
390
100
235
0
12.5
13.75
702
125
423
0
Department 1st Quarter

Education
3.5
Health
8.77
Law & Order
1.02
Welfare
39.15
2nd Quarter
5
7.98
3.39
40.5
3rd Qtr
4th Qtr
4.5
8.11
2.25
36.3
6.1
77.6
3.01
28.75
90
80
70
60
Education
50
Health
40
Law & Order
30
Welfare
20
10
0
1st Quarter
2nd Quarter
3rd Qtr
4th Qtr
12
Province
Sindh
Panjab
Balochistan
NWFP
1st Quarter
542.5
887
244.81
391.5
2nd Quarter
421.5
835.8
261.5
424.5
3rd Qtr
443.4
730.5
301.7
377.6
4th Qtr
496.2
736.5
299.3
300.5
Province
Sindh
Panjab
Balochistan
KPK
Total
1st Quarter
542.5
887
244.81
391.5
2065.81
2nd Quarter
421.5
835.8
261.5
424.5
1943.3
3rd Qtr
443.4
730.5
301.7
377.6
1853.2
4th Qtr
496.2
736.5
299.3
300.5
1832.5
Marks Obt
599
488
Total Marks
900
900
Full Fee
80000
80000
13
14
Roll No
Name
1 Noor
2 Aziz
3 Naseem
4 Mumtaz
5 Ilyas
No of Student gained Scholership
787
667
782
900
900
900
80000
80000
80000
16
Meter
Number
Previous Unit
1
2
3
4
5
69236
14011
76321
38476
4853
Current Unit
69229
14638
76428
38890
4996
Units Consumed Electricity Charges

-7
627
107
414
143
17
Item Name
Bangle
Earrings
Bracelet
Locket Set
One Man Show
Tiger
Poison
Price
Sale % age
500
200
400
300
500
5000
2500
30
20
40
50
30
50
45
Price after Sale

350
160
240
150
350
2500
1375
-14.42
1291.62
220.42
852.84
294.58
Over Time
Over Time Charges Basic Pay
Net Pay
30
48
39
42
3000
2400
1560
2100
8000
5700
4800
6300
11000
8100
6360
8400
Mobile Charges
Line Rent
CLI
Total Call
Charges
Tax
Total Dues
61.6
126
187.6
226.8
174
174
174
174
0
30
0
30
370.27
1134
1004.8
657.93
55.54
170.10
150.72
98.69
425.81
1304.10
1155.52
756.62
P
P
P
P
A
P
P
A
P
P
P
P
P
P
P
P
P
P
P
P
P
P
P
A
Done
10
P
P
A
A
Total
Attandence
8
10
9
6
Monthly
Installments
2338
5211
8949
3816
n Says Add Interest Rate and Amount which is wrong as per logic. I have Multiplied, if you want to add, simply put + sign instead *
Tax
Net Pay
3%
3%
4%
3%
13208
11198
17227
12059
Net Amount
Sale Price
Profit
11640
138904
441835
149962
15132
180575
574386
194951
3492
41671
132551
44989
Urdu
Total
Grade
76
65
43
52
306
317
278
295
61
63
56
59
B
B
C
C
Total
191311
231100
242764
110306
82998
351930
1210409
82998
351930
201735
Grade
Grade-2
Grade-2 Done
Grade-1
Grade-2
Done
Sales Tax
Amount Payable
1.25
1.375
70.2
12.5
42.3
0
13.75
15.125
772.2
137.5
465.3
0
Done
Remarks
Pass
Pass
Pass
Pass
Done
Education
Law & Order
Balochistan,
1107.31
NWFP, 1494.1
Sindh
Sindh , 1903.6
Panjab
Panjab, 3189.8
Balochistan
NWFP
Year
1903.6
3189.8
1107.31
1494.1
Total Expenditures
Year
9000
8000
7000
In. Rs. Million
1903.6
3189.8
1107.31
1494.1
7694.81
6000
5000
4000
3000
2000
1000
0
1
Scholarship
Payable Fee
30%
56000
No Scholership
80000
Done
60%
40%
60%
32000
48000
32000
Surcharges
Amount Payable
-2.163
193.743
33.063
127.926
44.187
-16.583 The First Value is Wrong as per paper data

1485.363
253.483
980.766
338.767
% age
80%
100%
90%
60%
ply put + sign instead *
Eligibility for
Exams
Eligible
Eligible
Eligible
Allowed
Done

Excel Tutorial

Uploaded by

Copyright:

Available Formats

Excel Tutorial

Uploaded by

Document Information

Original Description:

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Excel Tutorial

Uploaded by

Copyright:

Available Formats

1

Intrest Rate Annual Profit

300 Question Says Add Interest Rate and Amount

Department 1st Quarter

Law & Order

Units Consumed Electricity Charges

Price after Sale

Over Time Charges Basic Pay

Law & Order

-16.583 The First Value is Wrong as per paper data

ply put + sign instead *

You might also like