{"id":202,"date":"2018-10-20T18:38:14","date_gmt":"2018-10-20T16:38:14","guid":{"rendered":"http:\/\/gromit.ict.pwr.wroc.pl\/~faster\/wp\/?page_id=202"},"modified":"2018-12-03T21:37:03","modified_gmt":"2018-12-03T20:37:03","slug":"laboratorium-3","status":"publish","type":"page","link":"https:\/\/gromit.ict.pwr.wroc.pl\/~faster\/wp\/?page_id=202","title":{"rendered":"Laboratorium 3 &#8211; Arkusze kalkulacyjne &#8211; podstawy"},"content":{"rendered":"\n<div class=\"wp-block-columns has-2-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<div class=\"wp-block-button is-style-squared\"><a class=\"wp-block-button__link has-text-color has-very-dark-gray-color has-background has-cyan-bluish-gray-background-color\" href=\"http:\/\/gromit.ict.pwr.wroc.pl\/~faster\/wp\/?page_id=201\">Poprzedni<\/a><\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<div class=\"wp-block-button is-style-squared\"><a class=\"wp-block-button__link has-text-color has-very-dark-gray-color has-background has-cyan-bluish-gray-background-color\" href=\"http:\/\/gromit.ict.pwr.wroc.pl\/~faster\/wp\/?page_id=203\">Nast\u0119pny<\/a><\/div>\n<\/div>\n<\/div>\n\n\n\n<h1 class=\"wp-block-heading\">Zadanie<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">Stworzy\u0107 skoroszyt kalkulacyjny sk\u0142adaj\u0105cy si\u0119 z trzech arkuszy danych i czwartego podsumowuj\u0105cego. Na ka\u017cdym arkuszu powinny by\u0107 umieszczone comiesi\u0119czne odczyty licznik\u00f3w medi\u00f3w: pr\u0105du, wody i gazu. W ka\u017cdym miesi\u0105cu powinno by\u0107 wyliczone \u015brednie dzienne zu\u017cycie oraz op\u0142ata za zu\u017cycie medium. <strong>Uwaga<\/strong>: za pr\u0105d i wod\u0119 p\u0142acimy co miesi\u0105c, a za gaz &#8211; co dwa miesi\u0105ce (powiedzmy &#8211; parzyste).<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Arkusze danych powinny zawiera\u0107 bie\u017c\u0105ce odczyty i odpowiednie wyliczenia np.: <\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>dla wody i \u015bciek\u00f3w<\/li><\/ul>\n\n\n\n<table class=\"wp-block-table is-style-regular\"><tbody><tr><th>data<\/th><th>odczyt<\/th><th>zu\u017cycie<\/th><th>zu\u017cycie \u015br.<\/th><th>abonament<\/th><th>cena<\/th><th>warto\u015b\u0107 netto<\/th><th>warto\u015b\u0107 brutto<\/th><\/tr><tr><td>2018-10-06<\/td><td>142<\/td><\/tr><tr><td>2018-11-06<\/td><td>155<\/td><td>13<\/td><td>0,42<\/td><td>&nbsp; 6,60 z\u0142\/mc<\/td><td>&nbsp;&nbsp; 10,29 z\u0142\/m^3<\/td><td>&nbsp;&nbsp; 140,37 z\u0142<\/td><td>&nbsp;&nbsp; 151,60 z\u0142<\/td><\/tr><\/tbody><\/table>\n\n\n\n<pre class=\"wp-block-preformatted\">##0,00\\ [$z\u0142\/mc]<\/pre>\n\n\n\n<figure class=\"wp-block-image is-resized\"><a href=\"http:\/\/gromit.ict.pwr.wroc.pl\/~faster\/wp\/wp-content\/uploads\/2018\/11\/IMG_1563-Kopia.jpg\" target=\"_blank\" rel=\"noreferrer noopener\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/gromit.ict.pwr.wroc.pl\/~faster\/wp\/wp-content\/uploads\/2018\/11\/IMG_1563-Kopia.jpg\" alt=\"\" class=\"wp-image-327\" width=\"1035\" height=\"396\" srcset=\"https:\/\/gromit.ict.pwr.wroc.pl\/~faster\/wp\/wp-content\/uploads\/2018\/11\/IMG_1563-Kopia.jpg 2069w, https:\/\/gromit.ict.pwr.wroc.pl\/~faster\/wp\/wp-content\/uploads\/2018\/11\/IMG_1563-Kopia-600x230.jpg 600w, https:\/\/gromit.ict.pwr.wroc.pl\/~faster\/wp\/wp-content\/uploads\/2018\/11\/IMG_1563-Kopia-768x294.jpg 768w, https:\/\/gromit.ict.pwr.wroc.pl\/~faster\/wp\/wp-content\/uploads\/2018\/11\/IMG_1563-Kopia-1024x392.jpg 1024w, https:\/\/gromit.ict.pwr.wroc.pl\/~faster\/wp\/wp-content\/uploads\/2018\/11\/IMG_1563-Kopia-624x239.jpg 624w\" sizes=\"auto, (max-width: 1035px) 100vw, 1035px\" \/><\/a><figcaption>Przyk\u0142adowe dane<\/figcaption><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Zadanie Stworzy\u0107 skoroszyt kalkulacyjny sk\u0142adaj\u0105cy si\u0119 z trzech arkuszy danych i czwartego podsumowuj\u0105cego. Na ka\u017cdym arkuszu powinny by\u0107 umieszczone comiesi\u0119czne odczyty licznik\u00f3w medi\u00f3w: pr\u0105du, wody i gazu. W ka\u017cdym miesi\u0105cu powinno by\u0107 wyliczone \u015brednie dzienne zu\u017cycie oraz op\u0142ata za zu\u017cycie medium. Uwaga: za pr\u0105d i wod\u0119 p\u0142acimy co miesi\u0105c, a za gaz &#8211; co dwa [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":43,"menu_order":3,"comment_status":"closed","ping_status":"closed","template":"","meta":{"advgb_blocks_editor_width":"","advgb_blocks_columns_visual_guide":"","footnotes":""},"class_list":["post-202","page","type-page","status-publish","hentry"],"coauthors":[],"author_meta":{"author_link":"https:\/\/gromit.ict.pwr.wroc.pl\/~faster\/wp\/?author=1","display_name":"Tomasz Babczy\u0144ski"},"relative_dates":{"created":"Opublikowano 8 lat temu","modified":"Zaktualizowano 8 lat temu"},"absolute_dates":{"created":"Opublikowano 20.10.2018","modified":"Zaktualizowano 03.12.2018"},"absolute_dates_time":{"created":"Opublikowano 20.10.2018 6:38 PM","modified":"Zaktualizowano 03.12.2018 9:37 PM"},"featured_img_caption":"","featured_img":false,"series_order":"","_links":{"self":[{"href":"https:\/\/gromit.ict.pwr.wroc.pl\/~faster\/wp\/index.php?rest_route=\/wp\/v2\/pages\/202","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gromit.ict.pwr.wroc.pl\/~faster\/wp\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/gromit.ict.pwr.wroc.pl\/~faster\/wp\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/gromit.ict.pwr.wroc.pl\/~faster\/wp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/gromit.ict.pwr.wroc.pl\/~faster\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=202"}],"version-history":[{"count":12,"href":"https:\/\/gromit.ict.pwr.wroc.pl\/~faster\/wp\/index.php?rest_route=\/wp\/v2\/pages\/202\/revisions"}],"predecessor-version":[{"id":343,"href":"https:\/\/gromit.ict.pwr.wroc.pl\/~faster\/wp\/index.php?rest_route=\/wp\/v2\/pages\/202\/revisions\/343"}],"up":[{"embeddable":true,"href":"https:\/\/gromit.ict.pwr.wroc.pl\/~faster\/wp\/index.php?rest_route=\/wp\/v2\/pages\/43"}],"wp:attachment":[{"href":"https:\/\/gromit.ict.pwr.wroc.pl\/~faster\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=202"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}