Celkový příjem Odpracovaných hodin Měsíc Jiří Petr Lenka Václav Marie Jiří Petr Lenka Václav Marie 1. 160 142 131 165 135 2. 128 157 136 158 133 3. 144 133 128 161 132 4. 168 131 157 153 146 5. 125 129 133 145 131 6. 150 172 150 156 164 7. 149 165 165 162 128 8. 149 144 141 146 152 9. 143 129 139 145 134 10. 156 162 162 162 142 11. 151 140 161 135 160 12. 127 152 143 147 145 Celkem Hodinová mzda v Kč Měsíční bonus Jiří Petr Lenka Václav Marie 2500 180 240 195 210 195 Doplňte tabulku ##### Sheet/List 2 ##### Alfa Bravo Charlie Delta Echo Foxtrot Modří 3363 3574 3210 3307 3894 3496 Zelení 26 65 30 32 47 37 Vytvořte graf podobný tomu na obrázku ##### Sheet/List 3 ##### Kód výrobku Výrobce Počet prodaných kusů Nákupní cena Prodejní cena Výdělek "Doplňte tabulku tak, aby načítala údaje o ceně z listu Ceník" XES-377 AAW Group 2 Spodní část pak data z tohoto listu QZP-293 AAW Group 4 EBJ-346 EAC International 3 HHG-429 EAC International 4 OFK-062 AAW Group 1 NKC-532 GTeS Limited 5 LIT-125 Gencom 4 LZZ-111 EAC International 4 KPJ-728 Gencom 4 FNA-285 Softcorp 3 RGO-773 Bettadee 5 JEY-988 Softcorp 2 NYI-862 AAW Group 3 ZDJ-565 EAC International 2 WRE-773 Softcorp 4 XYY-223 PivotMedia 1 QYT-793 Gencom 5 VFV-636 EAC International 2 EXP-955 Gencom 2 EYG-818 Sunlight Inc. 4 VES-687 GTeS Limited 1 UYQ-923 GTeS Limited 3 YAN-883 Softcorp 2 XNI-659 EAC International 4 ANH-166 GTeS Limited 3 JNA-207 Softcorp 5 QOI-777 Softcorp 3 HEU-007 GTeS Limited 2 QOT-880 Softcorp 5 CCY-312 EAC International 4 RFO-625 AAW Group 5 TYX-440 EAC International 5 BEF-427 Sunlight Inc. 1 RDJ-251 Gencom 1 RXU-399 Bettadee 2 TBW-156 Bettadee 2 QGE-328 EAC International 2 NYQ-486 Softcorp 3 NKV-439 AAW Group 1 QNQ-003 Softcorp 4 TCC-299 Softcorp 2 ZBN-164 PivotMedia 3 GTI-898 Softcorp 5 XJH-490 Softcorp 2 OYU-511 Sunlight Inc. 2 GBK-859 PivotMedia 4 VJZ-380 Softcorp 3 PAF-361 Softcorp 5 BQA-763 EAC International 3 JHU-595 GTeS Limited 1 DBL-327 AAW Group 3 OEO-125 AAW Group 5 NYQ-354 PivotMedia 1 XGB-748 Sunlight Inc. 5 ADI-724 PivotMedia 4 AUT-444 EAC International 5 KIO-663 Bettadee 1 WII-975 EAC International 2 PZN-511 GTeS Limited 4 CRL-226 PivotMedia 1 DXJ-376 Gencom 1 HND-485 Sunlight Inc. 2 AWW-204 GTeS Limited 5 SIU-393 GTeS Limited 3 ZBT-439 Softcorp 3 YVD-498 Sunlight Inc. 4 SQK-501 GTeS Limited 2 ZED-488 Bettadee 2 DGB-520 Gencom 4 HFH-910 Softcorp 3 AAP-636 Bettadee 3 YUF-493 AAW Group 5 BOQ-526 GTeS Limited 5 BVL-273 Softcorp 2 GHF-841 Sunlight Inc. 4 ZQS-546 PivotMedia 4 KWT-610 Gencom 4 WGL-759 Softcorp 2 DGU-939 Bettadee 2 CGP-378 EAC International 2 DZE-250 Bettadee 2 XAB-876 Gencom 4 HDX-747 PivotMedia 5 FXO-551 Bettadee 4 LYR-932 Softcorp 5 GZT-799 EAC International 3 IXL-242 GTeS Limited 5 QRL-485 EAC International 1 VNU-123 EAC International 1 SIS-026 EAC International 4 KZP-334 Sunlight Inc. 2 WNP-065 Gencom 1 DPO-739 EAC International 3 CRL-348 GTeS Limited 4 ZDQ-277 PivotMedia 4 ABB-587 GTeS Limited 4 IHN-107 PivotMedia 1 YVA-195 GTeS Limited 5 PTX-093 Sunlight Inc. 5 XVL-080 Softcorp 3 Softcorp vyrobků: Celkem: Gencom kusů: ##### Sheet/List 4 ##### Kód výrobku Výrobce Nákupní cena Prodejní cena EBJ-346 EAC International 3346 4319 HRL-487 EAC International 2394 2659 ZWY-463 AAW Group 3798 4149 IXL-242 GTeS Limited 2185 2259 BLD-470 Softcorp 772 1559 LSE-386 EAC International 2997 3929 FXO-551 Bettadee 663 729 UTN-935 Gencom 2155 2279 YVD-498 Sunlight Inc. 3940 4699 HZJ-449 Bettadee 2964 3129 EAW-475 Sunlight Inc. 1310 1359 XIJ-026 Sunlight Inc. 2885 3289 WII-975 EAC International 2422 2539 ZBT-439 Softcorp 1827 2139 CRD-687 Softcorp 952 1239 YZI-343 Sunlight Inc. 2353 2909 IRP-406 PivotMedia 3375 4219 PSQ-674 Gencom 1513 2339 VTW-987 PivotMedia 560 629 UVU-617 Softcorp 2511 2989 DSX-196 PivotMedia 3503 4449 KZE-543 GTeS Limited 3288 3339 QZP-293 AAW Group 3819 4559 SIZ-541 Softcorp 3950 4909 ZDJ-565 EAC International 3316 4249 FFP-043 AAW Group 2192 3059 PFF-485 Gencom 2474 2499 ADI-724 PivotMedia 2064 2889 DEN-545 GTeS Limited 724 1089 ABB-587 GTeS Limited 2830 3389 KZP-334 Sunlight Inc. 2106 2629 SUG-076 Sunlight Inc. 1225 1549 YNN-146 Bettadee 1975 2789 FOP-306 PivotMedia 2619 2959 SIU-393 GTeS Limited 2051 3039 UWJ-652 Sunlight Inc. 3248 4019 QLI-405 PivotMedia 366 889 WQQ-808 AAW Group 1130 1639 RRD-222 Sunlight Inc. 14 319 WRP-183 Softcorp 1579 2299 YPN-651 EAC International 52 419 EYG-818 Sunlight Inc. 2203 2539 KIO-663 Bettadee 799 1409 RWV-124 Softcorp 3758 3999 HUA-522 AAW Group 3888 4479 YKE-156 Softcorp 2176 3029 XWP-905 GTeS Limited 3831 4819 GBK-859 PivotMedia 704 809 FSI-673 AAW Group 3076 3509 QGE-328 EAC International 3919 4659 JQH-745 PivotMedia 744 919 YPR-441 PivotMedia 2760 2909 YEX-992 PivotMedia 986 1389 SFR-876 PivotMedia 3353 3449 GHF-841 Sunlight Inc. 3676 4559 JER-432 Sunlight Inc. 319 1299 YIO-948 PivotMedia 2057 2669 AWA-974 Gencom 3446 3969 QDB-484 AAW Group 2475 3109 AGB-314 GTeS Limited 706 1609 OZX-971 AAW Group 2368 2909 EUR-046 Gencom 2832 2859 OEO-125 AAW Group 236 899 IHN-107 PivotMedia 959 1239 CRL-348 GTeS Limited 3360 4239 COH-276 Bettadee 1601 2089 NYQ-354 PivotMedia 1533 2319 VYX-339 PivotMedia 303 879 LXH-494 Bettadee 1012 1259 JHU-595 GTeS Limited 50 239 RAA-956 Softcorp 1215 1279 TUU-977 AAW Group 363 459 YPN-060 Softcorp 839 909 ZIP-176 PivotMedia 958 1099 WGL-759 Softcorp 2268 3089 AUQ-056 Softcorp 1720 2519 DXJ-376 Gencom 2275 3259 JWE-386 Bettadee 1672 1739 AQR-898 AAW Group 788 1279 SCZ-389 Sunlight Inc. 3433 4149 XJE-892 Sunlight Inc. 3532 3819 FLH-727 GTeS Limited 3913 4039 LET-730 Gencom 93 939 OFK-062 AAW Group 1245 1969 ZGP-415 PivotMedia 105 729 ULW-010 PivotMedia 3117 3699 RGO-773 Bettadee 511 859 QQH-736 Softcorp 138 139 OEH-832 AAW Group 2315 2939 PZN-511 GTeS Limited 1831 2669 EBE-124 AAW Group 3560 3909 TBW-156 Bettadee 1893 2179 XJH-490 Softcorp 845 1779 FPS-289 GTeS Limited 3011 3699 TRY-222 PivotMedia 2247 2479 PNB-299 EAC International 822 1449 RYO-138 Sunlight Inc. 1696 2059 JJK-474 AAW Group 3703 4289 ZRW-964 GTeS Limited 118 169 DVX-829 Softcorp 1781 1899 VWQ-064 Sunlight Inc. 2772 3659 ZDJ-128 Softcorp 406 989 QDQ-491 PivotMedia 2399 3309 KWL-732 EAC International 823 1619 QRL-485 EAC International 344 459 WKG-346 Sunlight Inc. 1466 1669 CHY-369 GTeS Limited 1242 1839 XRO-431 EAC International 2049 2109 SQK-501 GTeS Limited 3178 4049 RKC-576 PivotMedia 2989 3169 IBR-484 Softcorp 287 359 WNO-777 PivotMedia 2634 3559 VNU-123 EAC International 3878 4669 LON-558 Gencom 2006 2409 AZO-066 GTeS Limited 3884 4779 QVU-458 Sunlight Inc. 2805 3169 QGA-971 PivotMedia 2219 2469 OGJ-203 EAC International 2857 2969 SIS-026 EAC International 3807 4719 DYP-936 EAC International 2954 3209 VHW-536 EAC International 3040 3619 ZBN-164 PivotMedia 1822 1969 ZZO-713 AAW Group 582 1539 WNP-065 Gencom 1308 1469 WRI-967 Sunlight Inc. 2863 3339 QCC-662 AAW Group 1748 1989 TRS-504 Sunlight Inc. 1168 1989 UPG-828 EAC International 68 789 PCY-861 PivotMedia 1712 2479 AVK-140 Sunlight Inc. 3537 3579 LCT-147 PivotMedia 3099 3719 IWI-651 Gencom 1406 1969 NKC-532 GTeS Limited 607 1249 JNA-207 Softcorp 1334 1379 KJQ-948 PivotMedia 777 1489 LCI-622 EAC International 3533 3779 TYX-440 EAC International 2319 2369 QJK-612 GTeS Limited 3093 3189 FFV-774 EAC International 3285 4249 JXW-130 Sunlight Inc. 2145 2169 DPO-739 EAC International 2063 2299 LSO-007 PivotMedia 3510 4069 EYD-442 AAW Group 2080 2169 RDJ-251 Gencom 3344 4039 ITN-244 Softcorp 1184 1759 TIX-399 AAW Group 1072 2029 XAB-876 Gencom 3 119 QZT-245 Softcorp 3909 4489 VES-687 GTeS Limited 2841 3599 RHP-390 Sunlight Inc. 2293 2869 JEY-988 Softcorp 3950 4149 NYQ-486 Softcorp 949 1509 HVV-928 Sunlight Inc. 2130 2729 NYI-862 AAW Group 3888 4009 PQI-897 PivotMedia 1697 2449 GSV-495 GTeS Limited 2650 3369 QBI-490 GTeS Limited 3211 3299 FNA-634 PivotMedia 2457 2459 UYQ-923 GTeS Limited 3155 3189 RFO-625 AAW Group 2331 2859 XOJ-142 Bettadee 1917 2479 FXT-692 Sunlight Inc. 638 1109 QYT-793 Gencom 1326 1869 OCR-465 GTeS Limited 2028 2179 PNP-380 Softcorp 2565 3149 LIT-125 Gencom 3919 4309 IWS-467 Bettadee 1608 2609 DBL-327 AAW Group 718 1079 CRL-226 PivotMedia 764 1469 TCC-299 Softcorp 209 709 XXE-360 Gencom 2930 2979 NCF-519 Softcorp 13 539 JIJ-697 GTeS Limited 3372 4369 RUN-638 Sunlight Inc. 1019 1319 LZZ-111 EAC International 2268 2769 HYH-766 Gencom 1230 1929 RDD-479 AAW Group 2467 2689 WGI-412 Gencom 760 1409 CJV-336 Softcorp 1321 1809 VET-966 GTeS Limited 3343 4269 RVX-685 AAW Group 3561 3669 RNW-340 EAC International 3520 4459 ICB-384 PivotMedia 2820 3379 VJZ-380 Softcorp 1570 1779 HFH-910 Softcorp 3004 3289 AWW-204 GTeS Limited 1730 2559 FGO-269 GTeS Limited 2922 3109 CRP-121 GTeS Limited 1377 1529 LYR-932 Softcorp 3085 3899 DGU-939 Bettadee 2414 3339 YVA-195 GTeS Limited 3667 4099 GBR-379 Gencom 1424 1669 XNI-659 EAC International 2921 3719 OLS-950 Sunlight Inc. 1934 2659 SEW-226 Bettadee 528 949 FRF-641 Softcorp 348 989 ANH-166 GTeS Limited 3518 3849 QYD-413 EAC International 742 1509 OYU-511 Sunlight Inc. 33 739 EUL-127 Softcorp 3680 4509 BEF-427 Sunlight Inc. 3914 4019 AAP-636 Bettadee 125 1009 VFV-636 EAC International 2524 3519 RLA-973 Gencom 3782 4279 GZT-799 EAC International 3328 3749 OXD-643 Sunlight Inc. 1777 1879 LXY-131 Sunlight Inc. 3631 4199 HOX-787 PivotMedia 2034 2789 FRI-561 PivotMedia 3703 4209 NRG-460 GTeS Limited 386 799 WDV-288 Bettadee 2444 3379 FNB-736 Bettadee 2840 3179 KVR-559 Bettadee 2675 2969 QOI-777 Softcorp 777 939 XKR-226 PivotMedia 2553 3289 XFX-891 AAW Group 645 749 WRE-773 Softcorp 1581 2519 ASF-796 PivotMedia 3207 4179 BVL-273 Softcorp 1921 2569 YRA-418 Sunlight Inc. 2005 2169 RYZ-352 Softcorp 1441 2409 DIH-208 Sunlight Inc. 3912 4729 NTL-404 EAC International 2191 3129 NKV-439 AAW Group 1854 2849 WVO-157 Softcorp 3516 3759 LDE-747 GTeS Limited 3504 4289 NDD-764 GTeS Limited 2038 2919 ZEW-575 Bettadee 257 679 ZZU-156 AAW Group 2996 3649 ZED-488 Bettadee 2468 3199 OYH-867 AAW Group 2749 3659 UPB-054 AAW Group 2673 3149 QHQ-121 Sunlight Inc. 2876 3319 TJQ-825 Bettadee 3392 3769 CGP-378 EAC International 3978 4229 ORH-182 Bettadee 668 859 CNC-315 GTeS Limited 27 489 RXU-399 Bettadee 1968 2599 FOK-497 Gencom 121 769 RIP-543 Gencom 3096 3909 VDI-116 Softcorp 2493 2989 RXC-179 Sunlight Inc. 3684 3889 IOL-551 Softcorp 3663 4029 KYF-592 PivotMedia 259 609 DJX-667 Softcorp 2536 2759 CUP-036 GTeS Limited 3134 3359 CNK-563 EAC International 3250 4069 IQX-031 Softcorp 1216 1759 PFW-154 Bettadee 2608 3439 CAR-958 Sunlight Inc. 2009 2459 XES-377 AAW Group 341 459 ZDQ-277 PivotMedia 3420 4169 FNA-285 Softcorp 3212 3789 XYY-223 PivotMedia 2311 2869 QOT-880 Softcorp 176 529 ANN-020 GTeS Limited 2220 2679 HIQ-518 Softcorp 1281 1369 QXI-917 Bettadee 2471 3139 VYH-887 AAW Group 3622 3689 HEU-007 GTeS Limited 2704 3639 AUT-444 EAC International 3220 4139 COY-308 Softcorp 446 1349 XVL-080 Softcorp 3801 4789 CRN-529 Sunlight Inc. 3838 4259 XGB-748 Sunlight Inc. 2458 2589 HND-485 Sunlight Inc. 3830 4669 DIU-698 Gencom 1418 2089 WZT-201 Gencom 1697 2369 ZQS-546 PivotMedia 1122 1669 KPJ-728 Gencom 393 989 NSP-910 Sunlight Inc. 3471 4409 TOY-242 EAC International 2758 2799 OJQ-464 AAW Group 3107 3489 UCC-998 EAC International 2360 2469 TNG-790 PivotMedia 55 649 VDI-201 AAW Group 984 1459 OCR-867 Gencom 1487 2379 NNR-456 Sunlight Inc. 3667 4459 PST-356 Gencom 1544 1589 KNA-684 Sunlight Inc. 3789 4009 RXA-007 AAW Group 2424 3379 QNF-839 GTeS Limited 1381 1919 GPY-942 Sunlight Inc. 1997 2409 HYE-619 Gencom 3597 4149 ALA-468 Bettadee 2479 2589 JRY-574 Bettadee 3779 4689 HHG-429 EAC International 1421 2119 HDX-747 PivotMedia 2529 2539 GQG-430 Gencom 3816 4069 XUR-796 AAW Group 548 769 FAJ-913 AAW Group 1387 2259 CCY-312 EAC International 2852 3239 XUI-451 Bettadee 2628 3279 IFO-179 AAW Group 2 549 BQA-763 EAC International 303 699 VZD-039 Softcorp 1300 1659 BHU-435 Softcorp 3854 4859 DZE-250 Bettadee 3067 4009 XRE-310 Sunlight Inc. 2956 2999 WTF-570 AAW Group 2123 2239 HJL-498 EAC International 708 1379 KWT-610 Gencom 497 529 DDP-004 Softcorp 2249 2899 TCY-772 Softcorp 3263 3849 DSX-404 Sunlight Inc. 2924 3549 IDP-845 PivotMedia 1094 1559 PAF-361 Softcorp 2448 3159 HKO-664 AAW Group 3270 3559 QZV-493 PivotMedia 3269 3919 SLL-529 PivotMedia 684 1019 DGB-520 Gencom 2709 3289 GPT-311 Softcorp 1692 2079 JGE-512 EAC International 1336 1529 AKL-882 Sunlight Inc. 3382 3539 YAN-883 Softcorp 3786 3889 YAT-177 Bettadee 1748 2129 PRV-825 Softcorp 1179 1559 ZZF-459 PivotMedia 497 1159 JIQ-199 EAC International 2052 2309 JIX-881 AAW Group 852 1789 JWK-287 Softcorp 1203 2019 DIR-854 Softcorp 3441 4049 PTX-093 Sunlight Inc. 706 1299 FFO-867 Bettadee 938 1549 NBS-541 Softcorp 1596 2059 HPW-427 GTeS Limited 1036 1189 GTI-898 Softcorp 3571 4369 SEK-741 EAC International 2410 2649 XAS-847 PivotMedia 3277 3529 NFS-330 Softcorp 3141 3579 BOQ-526 GTeS Limited 3199 3649 EXP-955 Gencom 1327 2019 WNL-913 Softcorp 3441 3459 SRD-632 Gencom 922 979 EBX-599 PivotMedia 1859 2349 CIY-204 Bettadee 712 749 TCC-423 GTeS Limited 616 1249 ZOI-841 Softcorp 3769 4039 GAK-359 GTeS Limited 1611 1679 DVF-793 PivotMedia 2320 2909 KSU-404 PivotMedia 3613 3699 HWS-807 EAC International 1765 2349 USF-998 EAC International 1829 2499 YVX-136 Bettadee 2294 2729 KYR-738 PivotMedia 2936 3859 YUF-493 AAW Group 2664 3069 DDJ-162 Bettadee 2545 2999 QNQ-003 Softcorp 354 409