Scribd
Upload
19 views16 pages

Ruvarashe 112348

The document contains patient information, including names and whether they are inpatients or outpatients, along with doctor attendance dates. It also includes student marks and salary details for employees, along with deductions, gross pay, tax, and net pay calculations. Additionally, it provides data on arrivals for each day of the week, detailing both morning and afternoon arrivals.

Uploaded by

muturumaruva
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
19 views16 pages

Ruvarashe 112348

The document contains patient information, including names and whether they are inpatients or outpatients, along with doctor attendance dates. It also includes student marks and salary details for employees, along with deductions, gross pay, tax, and net pay calculations. Additionally, it provides data on arrivals for each day of the week, detailing both morning and afternoon arrivals.

Uploaded by

muturumaruva
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 16

patient

patient No patient name in patient or out patient

1 princes in
2 jamie out
3 jain out
4 gamu in
5 lorance in
Doctor attended Date

DR manyere 4/6/2024
DR manyere 4/12/2024
DR manyere 4/20/2024
DR Tendai 5/6/2024
DR Tendai 5/15/2024
Sunday Monday Tuesday Wednesday

9:00
9:30
10:00
10:30
11:00
11:30
12:00
12:30
13:00
13:30
14:00
14:30
15:00
15:30
16:00
16:30
17:00
Thursday Friday suturday
S No Name Mark1 Mark2 Mark3

1 tadiwa 64 34 87
2 monalisa 30 43 54
3 temba 40 54 98
4 john 70 56 76
5 wonder 78 78 67
6 ruva 80 89 56
7 james 65 87 65
8 jacob 78 65 54
9 enerst 64 53 76
10 prime 56 78 87
11 ronney 55 56 76

maximum 80 89 98

minimum 30 34 54
Mark4 Mark5 Total

32 87 304
45 65 237
54 64 310
54 94 350
65 84 372
45 73 343
32 82 331
65 83 345
76 53 322
65 72 358
87 95 369

87 372

32 237
Name Basic HRA TA Deductions

john 30000 15000 3000 300


bob 35000 17500 3500 500
jane 35000 17500 3500 600
alice 28000 14000 2800 700
mike 32000 16000 3200 200

avarage

salaries
300000

250000

200000

150000

100000

50000

0
Basic HRA TA Deductio

Row 2 john bob jane alice mike Row 8

salaries

20% 19%

18% 22

22%
20% 19%

18% 22

22%
Deductions Gross pay Tax Net pay

48000 14400 33600


56000 16800 39200
56000 16800 39200
44800 13440 31360
51200 15360 35840

35840

salaries

A Deductions Gross pay Tax Net pay

jane alice mike Row 8 Row 9 Row 10 avarage

salaries

1
20% 19%
2
3
4
22% 5
6
22% 7
1
20% 19%
2
3
4
22% 5
6
22% 7
8
t pay
Arrivals

Day Am arrivals Pm arrivals

Monday 80 40
Tuesday 65 45
wednsday 50 75
Thursday 58 60
Friday 150 80
Saturday 40 68
Sunday 30 100

Am Arrivals
6%
17%
8%
Monday
Tuesday
wednsday
Thursday
14% Friday
Saturday
32% Sunday

11%

12%

Am and Pm Arrivals
250

200

150

100

50

0
Monday Tuesday wednsday Thursday Friday Saturda

Column C Column D Column E Am arrivals


Column G Column H Pm arrivals
0
Monday Tuesday wednsday Thursday Friday Saturda

Column C Column D Column E Am arrivals


Column G Column H Pm arrivals
Arrivals
160
140
120
100
80
60
40
20
0
1 2 3 4 5 6 7 8 9

Day Column C Column D Column E


Am arrivals Column G Column H Pm arrivals
Pm arrivals

9%
21% Monday
10% Tuesday
wednsday
Thursday
Friday
16% Saturday
15% Sunday

13%
17%

Pm Arrivals

sday Thursday Friday Saturday Sunday

D Column E Am arrivals
H Pm arrivals
sday Thursday Friday Saturday Sunday

D Column E Am arrivals
H Pm arrivals
9

You might also like