O’QUVCHILARNING TO’PLAGAN BALLARI VA NATIJALAR

|
O’QUVCHILARNING TO’PLAGAN BALLARI VA NATIJALAR
|
bet | 21/29 | Sana | 18.07.2024 | Hajmi | 10,08 Mb. | | #267893 |
Bog'liq KOMPYUTER SAVODXONLIGI BARCHA QO\'LLAMALARO’QUVCHILARNING TO’PLAGAN BALLARI VA NATIJALAR
№
|
Maxsulot nomi
|
jami soni
|
1 dona narxi
|
jami summasi
|
ustama foizi 48%
|
1dona tayyor summasi
|
1
|
Xolodilnik
|
18
|
2500000
|
45000000
|
1200000
|
3700000
|
2
|
Plisos
|
25
|
350000
|
8750000
|
168000
|
518000
|
3
|
Dazmol
|
33
|
85000
|
2805000
|
40800
|
125800
|
4
|
Mikro to’lqinli pech
|
16
|
458000
|
7328000
|
219840
|
677840
|
5
|
Choynak
|
25
|
25000
|
625000
|
12000
|
37000
|
6
|
Kompyuter
|
10
|
1850000
|
18500000
|
888000
|
2738000
|
7
|
Blindr
|
8
|
850000
|
6800000
|
408000
|
1258000
|
8
|
Kir yuvish mashinasi
|
12
|
2650000
|
31800000
|
1272000
|
3922000
|
9
|
Kondisioner
|
15
|
1950000
|
29250000
|
936000
|
2886000
|
10
|
Gaz plitasi
|
15
|
1450000
|
21750000
|
696000
|
2146000
|
11
|
Lampochka
|
32
|
32000
|
1024000
|
15360
|
47360
|
12
|
Printer
|
23
|
430000
|
9890000
|
206400
|
636400
|
13
|
Notebok
|
13
|
240000
|
3120000
|
115200
|
355200
|
14
|
Elektor isitgich
|
31
|
54000
|
1674000
|
25920
|
79920
|
15
|
Fotokamera
|
21
|
62000
|
1302000
|
29760
|
91760
|
16
|
Telefon
|
24
|
410000
|
9840000
|
196800
|
606800
|
17
|
Planshet
|
28
|
210000
|
5880000
|
100800
|
310800
|
18
|
Multimediya
|
37
|
28000
|
1036000
|
13440
|
41440
|
19
|
Lamitor
|
29
|
98000
|
2842000
|
47040
|
145040
|
20
|
Perplot
|
34
|
429000
|
14586000
|
205920
|
634920
|
Formula = YESLI( B4>50;”O’tdi”;”O’tmadi”)
SAVDO SOTIQ
MAHSULOTLARNI FILTIRLASH
Oldin jadvalni tayyorlab olamiz va belgilab Ctrl+t tugamisini bosamiz. Jadvalda nomlar yozilgan qatorni belgilab yuqoridagi menyular satrida qo’shimcha ochilgan Konstruktor menyusiga o’tamiz va ushbu bo’limdan Vistavit srez ga kiramiz va Oylar Do’konlar ni belglemiz
( galichka qo’yamz ).
Yuqoridagi 2ta jadvallarni shu tarzda hosil qilamiz.
Bu jadvallar bizga qaysi oyni yoki do’konni tanlasak faqad o’sh do’konni va o’sha oyni ko’rsatib turadi bu usul bizga katta jadvallarga foydalanishmiz mumkun .
OYLIK ISH HAQI CHIQARISH
|
|
|
|
|
|
|
|
|
|
|
|
|
|
№
|
Familiyasi ismi
|
Yanvar
|
Fevral
|
Jami summasi
|
Svetga 5%
|
Suvga 4%
|
Gazga 3%
|
Pensiya 1%
|
Daromad solig’i 11%
|
Qo’lga tegadigan summasi
|
Naq 65%
|
Plastik 35%
|
1
|
Xusanova Laylo
|
4500000
|
4350000
|
8850000
|
442500
|
354000
|
265500
|
88500
|
973500
|
6726000
|
4371900
|
2354100
|
2
|
Inatullayev Kamron
|
5500000
|
5400000
|
10900000
|
545000
|
436000
|
327000
|
109000
|
1199000
|
8284000
|
5384600
|
2899400
|
3
|
Nizamov Shavkat
|
5450000
|
5350000
|
10800000
|
540000
|
432000
|
324000
|
108000
|
1188000
|
8208000
|
5335200
|
2872800
|
4
|
Meliboyev Bexruz
|
5980000
|
5780000
|
11760000
|
588000
|
470400
|
352800
|
117600
|
1293600
|
8937600
|
5809440
|
3128160
|
5
|
Urishboyev Jahon
|
4000000
|
1850000
|
5850000
|
292500
|
234000
|
175500
|
58500
|
643500
|
4446000
|
2889900
|
1556100
|
6
|
Rahmonqulov Suxrob
|
3200000
|
3100000
|
6300000
|
315000
|
252000
|
189000
|
63000
|
693000
|
4788000
|
3112200
|
1675800
|
7
|
Toxirov Tolib
|
4100000
|
4000000
|
8100000
|
405000
|
324000
|
243000
|
81000
|
891000
|
6156000
|
4001400
|
2154600
|
8
|
Berkinov Ulug’bek
|
4000000
|
3800000
|
7800000
|
390000
|
312000
|
234000
|
78000
|
858000
|
5928000
|
3853200
|
2074800
|
9
|
Fayziyev Fayoz
|
3500000
|
3300000
|
6800000
|
340000
|
272000
|
204000
|
68000
|
748000
|
5168000
|
3359200
|
1808800
|
10
|
Allamurodov Azizbek
|
3600000
|
3400000
|
7000000
|
350000
|
280000
|
210000
|
70000
|
770000
|
5320000
|
3458000
|
1862000
|
11
|
Otamurodov Sirojiddin
|
5000000
|
4800000
|
9800000
|
490000
|
392000
|
294000
|
98000
|
1078000
|
7448000
|
4841200
|
2606800
|
12
|
Musayev Zafar
|
2540000
|
2600000
|
5140000
|
257000
|
205600
|
154200
|
51400
|
565400
|
3906400
|
2539160
|
1367240
|
13
|
Nasriddinov Murod
|
3124000
|
3000000
|
6124000
|
306200
|
244960
|
183720
|
61240
|
673640
|
4654240
|
3025256
|
1628984
|
14
|
Abduraimov Javohir
|
4650000
|
4400000
|
9050000
|
452500
|
362000
|
271500
|
90500
|
995500
|
6878000
|
4470700
|
2407300
|
15
|
Nurmanov Husan
|
5500000
|
1300000
|
6800000
|
340000
|
272000
|
204000
|
68000
|
748000
|
5168000
|
3359200
|
1808800
|
16
|
Bahodirova Yodgora
|
2500000
|
10000000
|
12500000
|
625000
|
500000
|
375000
|
125000
|
1375000
|
9500000
|
6175000
|
3325000
|
17
|
Husanov Sarvar
|
4120000
|
500000
|
4620000
|
231000
|
184800
|
138600
|
46200
|
508200
|
3511200
|
2282280
|
1228920
|
18
|
Akramov Azizbek
|
3510000
|
2000000
|
5510000
|
275500
|
220400
|
165300
|
55100
|
606100
|
4187600
|
2721940
|
1465660
|
19
|
Tursunov Behruz
|
1520000
|
3000000
|
4520000
|
226000
|
180800
|
135600
|
45200
|
497200
|
3435200
|
2232880
|
1202320
|
11 – DARS Murakkab xisoblash amallari
MAGAZIN XISOB KITOB
T/r
|
Mahsulot nomi
|
kelish narxi
|
sotish narxi
|
1
|
non
|
1500
|
2000
|
2
|
choy kg
|
1000
|
1500
|
3
|
kartoshka kg
|
4000
|
5000
|
4
|
banan kg
|
1500
|
18000
|
5
|
karam kg
|
3500
|
4000
|
6
|
sabzi kg
|
2500
|
3000
|
7
|
bergaz 1 L
|
1500
|
2000
|
8
|
piyoz kg
|
2500
|
3000
|
9
|
gurunch lazr kg
|
14000
|
18000
|
10
|
mosh kg
|
5500
|
9000
|
|
| |