{"id":31148,"date":"2019-10-15T13:23:36","date_gmt":"2019-10-15T11:23:36","guid":{"rendered":"https:\/\/fotc.com\/goal-seek-dodatek\/"},"modified":"2021-09-29T13:34:09","modified_gmt":"2021-09-29T11:34:09","slug":"goal-seek-dodatek","status":"publish","type":"post","link":"https:\/\/dev.fotc.com\/pl\/blog\/goal-seek-dodatek\/","title":{"rendered":"Goal Seek \u2013 nowy dodatek do Arkuszy Google"},"content":{"rendered":"<p><span >Funkcjonalno\u015bci Arkuszy Google s\u0105 rozwijane na dwa sposoby \u2013 niekt\u00f3re znajdziemy bezpo\u015brednio w aplikacji, natomiast inne s\u0105 opcjonalne i udost\u0119pnione jako osobne dodatki. Dzi\u0119ki dw\u00f3m metodom poszerzenia zestawu funkcji interfejs nadal pozostaje prosty, bo nie pojawia si\u0119 w nim nic zb\u0119dnego, a ka\u017cdy mo\u017ce zbudowa\u0107 w\u0142asn\u0105 kolekcj\u0119 specjalistycznych narz\u0119dzi. <\/span><!--more--><\/p>\n<h2><strong>Do czego s\u0142u\u017cy dodatek Goal Seek?<\/strong><\/h2>\n<p><span >Funkcja Goal Seek (znana po polsku jako Szukaj Wyniku, cho\u0107 p\u00f3ki co dodatek jest dost\u0119pny tylko w j\u0119zyku angielskim) pomo\u017ce nam znale\u017a\u0107 zmienne, kt\u00f3re umo\u017cliwiaj\u0105 osi\u0105gni\u0119cie konkretnego wyniku poprzez dowoln\u0105 formu\u0142\u0119.\u00a0<\/span><\/p>\n<p><img decoding=\"async\" class=\"size-full wp-image-22506 aligncenter\" src=\"https:\/\/fotc.com\/app\/uploads\/2021\/07\/Goal_Seek_GIF_1.gif\" alt=\"szukaj wyniku arkusze google gif\" width=\"1600\" height=\"862\" \/><\/p>\n<p><span >Przydaje si\u0119 przyk\u0142adowo, gdy znamy dok\u0142adn\u0105 warto\u015b\u0107 targetu sprzeda\u017cy, kt\u00f3ry chcemy zrealizowa\u0107 na koniec kolejnego kwarta\u0142u, ale wolimy podzieli\u0107 go na mniejsze, bardziej motywuj\u0105ce cele. Goal Seek samodzielnie dopasuje do formu\u0142y w konkretnej kom\u00f3rce arkusza warto\u015b\u0107, dzi\u0119ki kt\u00f3rej wynikiem oblicze\u0144 b\u0119dzie nasz target.\u00a0<\/span><\/p>\n<p><span >Aby z niej skorzysta\u0107, musimy zna\u0107:<\/span><\/p>\n<ul>\n<li><span >\u00a0kom\u00f3rk\u0119, w kt\u00f3rej jest formu\u0142a,\u00a0<\/span><\/li>\n<li><span >\u00a0warto\u015b\u0107, jak\u0105 formu\u0142a ma wyliczy\u0107 (czyli nasz kwartalny target),<\/span><\/li>\n<li><span >\u00a0kom\u00f3rk\u0119, dla kt\u00f3rej dodatek obliczy warto\u015b\u0107, aby osi\u0105gn\u0105\u0107 zamierzony rezultat.<\/span><\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"size-full wp-image-22508 aligncenter\" src=\"https:\/\/fotc.com\/app\/uploads\/2021\/07\/Goal_Seek_GIF_3.gif\" alt=\"goal seek szukaj wyniku google arkusze dodatek\" width=\"1600\" height=\"862\" \/><\/p>\n<h2><strong>Instrukcja korzystania z dodatku Goal Seek<\/strong><\/h2>\n<p><span >Gdy mamy niezb\u0119dne dane, to wystarczy kilka krok\u00f3w, by przeprowadzi\u0107 \u017c\u0105dan\u0105 operacj\u0119.<\/span><\/p>\n<ol>\n<li ><span >Pobierz i zainstaluj dodatek <\/span><a href=\"https:\/\/gsuite.google.com\/marketplace\/app\/goal_seek\/583737146763\"><span >Goal Seek z Google Workspace Marketplace<\/span><\/a><span >.<\/span><\/li>\n<li ><span >Kliknij <\/span><b>Dodatki<\/b><span > na pasku zak\u0142adek i otw\u00f3rz dodatek Goal Seek.<\/span><\/li>\n<li ><span >Wype\u0142nij arkusz zmiennymi, kt\u00f3re znasz.<\/span><\/li>\n<li ><span >Zaznacz kom\u00f3rk\u0119 zawieraj\u0105c\u0105 formu\u0142\u0119.<\/span><\/li>\n<li ><span >Kliknij <\/span><b>Capture selected cell<\/b><span > tu\u017c obok pola <\/span><b>Set cell<\/b><span >.\u00a0<\/span><\/li>\n<li ><span >W polu <\/span><b>To value<\/b><span > wstaw wynik, kt\u00f3ry chcesz osi\u0105gn\u0105\u0107.<\/span><\/li>\n<li ><span >Zaznacz kom\u00f3rk\u0119, w kt\u00f3rej ma si\u0119 pojawi\u0107 szukana zmienna.<\/span><\/li>\n<li ><span >Kliknij <\/span><b>Capture selected cell<\/b><span > obok <\/span><b>By changing cell<\/b><span >.<\/span><\/li>\n<li ><span >Kliknij <\/span><b>Solve<\/b><span >, by rozpocz\u0105\u0107 obliczanie.\u00a0<\/span><\/li>\n<\/ol>\n<p><span >Dodatek jest ju\u017c dost\u0119pny dla wszystkich wariant\u00f3w <a href=\"https:\/\/fotc.com\/pl\/google-workspace\/\">Google Workspace<\/a>.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Funkcjonalno\u015bci Arkuszy Google s\u0105 rozwijane na dwa sposoby \u2013 niekt\u00f3re znajdziemy bezpo\u015brednio w aplikacji, natomiast inne s\u0105 opcjonalne i udost\u0119pnione jako osobne dodatki. Dzi\u0119ki dw\u00f3m metodom poszerzenia zestawu funkcji interfejs nadal pozostaje prosty, bo nie pojawia si\u0119 w nim nic zb\u0119dnego, a ka\u017cdy mo\u017ce zbudowa\u0107 w\u0142asn\u0105 kolekcj\u0119 specjalistycznych narz\u0119dzi.<\/p>\n","protected":false},"author":10,"featured_media":4640,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_editorskit_title_hidden":false,"_editorskit_reading_time":0,"_editorskit_is_block_options_detached":false,"_editorskit_block_options_position":"{}","footnotes":""},"categories":[563],"tags":[111,141],"class_list":["post-31148","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-workspace-pl","tag-arkusze-google","tag-dodatki"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v23.8 (Yoast SEO v25.0) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Goal Seek \u2013 nowy dodatek do Arkuszy Google - FOTC<\/title>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"pl_PL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Goal Seek \u2013 nowy dodatek do Arkuszy Google\" \/>\n<meta property=\"og:description\" content=\"Funkcjonalno\u015bci Arkuszy Google s\u0105 rozwijane na dwa sposoby \u2013 niekt\u00f3re znajdziemy bezpo\u015brednio w aplikacji, natomiast inne s\u0105 opcjonalne i udost\u0119pnione jako osobne dodatki. Dzi\u0119ki dw\u00f3m metodom poszerzenia zestawu funkcji interfejs nadal pozostaje prosty, bo nie pojawia si\u0119 w nim nic zb\u0119dnego, a ka\u017cdy mo\u017ce zbudowa\u0107 w\u0142asn\u0105 kolekcj\u0119 specjalistycznych narz\u0119dzi.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dev.fotc.com\/pl\/blog\/goal-seek-dodatek\/\" \/>\n<meta property=\"og:site_name\" content=\"FOTC\" \/>\n<meta property=\"article:published_time\" content=\"2019-10-15T11:23:36+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-09-29T11:34:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dev.fotc.com\/app\/uploads\/2021\/07\/Goal-Seek_1200x628-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Agata Koptewicz\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Agata Koptewicz\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minuty\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dev.fotc.com\/pl\/blog\/goal-seek-dodatek\/\",\"url\":\"https:\/\/dev.fotc.com\/pl\/blog\/goal-seek-dodatek\/\",\"name\":\"Goal Seek \u2013 nowy dodatek do Arkuszy Google - FOTC\",\"isPartOf\":{\"@id\":\"https:\/\/dev.fotc.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dev.fotc.com\/pl\/blog\/goal-seek-dodatek\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dev.fotc.com\/pl\/blog\/goal-seek-dodatek\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dev.fotc.com\/app\/uploads\/2021\/07\/Goal-Seek_1200x628-1.jpg\",\"datePublished\":\"2019-10-15T11:23:36+00:00\",\"dateModified\":\"2021-09-29T11:34:09+00:00\",\"author\":{\"@id\":\"https:\/\/dev.fotc.com\/#\/schema\/person\/03dfc51e82408d6ffb682d5c4facf95a\"},\"breadcrumb\":{\"@id\":\"https:\/\/dev.fotc.com\/pl\/blog\/goal-seek-dodatek\/#breadcrumb\"},\"inLanguage\":\"pl-PL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dev.fotc.com\/pl\/blog\/goal-seek-dodatek\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pl-PL\",\"@id\":\"https:\/\/dev.fotc.com\/pl\/blog\/goal-seek-dodatek\/#primaryimage\",\"url\":\"https:\/\/dev.fotc.com\/app\/uploads\/2021\/07\/Goal-Seek_1200x628-1.jpg\",\"contentUrl\":\"https:\/\/dev.fotc.com\/app\/uploads\/2021\/07\/Goal-Seek_1200x628-1.jpg\",\"width\":1200,\"height\":628},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dev.fotc.com\/pl\/blog\/goal-seek-dodatek\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"PL\",\"item\":\"https:\/\/dev.fotc.com\/pl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Goal Seek \u2013 nowy dodatek do Arkuszy Google\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dev.fotc.com\/#website\",\"url\":\"https:\/\/dev.fotc.com\/\",\"name\":\"FOTC\",\"description\":\"Partner Google Cloud\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dev.fotc.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pl-PL\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/dev.fotc.com\/#\/schema\/person\/03dfc51e82408d6ffb682d5c4facf95a\",\"name\":\"Agata Koptewicz\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pl-PL\",\"@id\":\"https:\/\/dev.fotc.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/9e8bcc5b9c885316642ef864a39c37cb51fc8581c4c25d3cf1c78646a1919f4e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/9e8bcc5b9c885316642ef864a39c37cb51fc8581c4c25d3cf1c78646a1919f4e?s=96&d=mm&r=g\",\"caption\":\"Agata Koptewicz\"},\"description\":\"Content Manager at Fly On The Cloud. During business hours, Agata creates articles that teach, entertain, and sell, but in free time she performs linguistic acrobatics on the verge of good taste. Privately she leads a pack of Dobermans and closely follows technological news.\",\"url\":\"https:\/\/dev.fotc.com\/pl\/blog\/author\/agata-koptewicz\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Goal Seek \u2013 nowy dodatek do Arkuszy Google - FOTC","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"pl_PL","og_type":"article","og_title":"Goal Seek \u2013 nowy dodatek do Arkuszy Google","og_description":"Funkcjonalno\u015bci Arkuszy Google s\u0105 rozwijane na dwa sposoby \u2013 niekt\u00f3re znajdziemy bezpo\u015brednio w aplikacji, natomiast inne s\u0105 opcjonalne i udost\u0119pnione jako osobne dodatki. Dzi\u0119ki dw\u00f3m metodom poszerzenia zestawu funkcji interfejs nadal pozostaje prosty, bo nie pojawia si\u0119 w nim nic zb\u0119dnego, a ka\u017cdy mo\u017ce zbudowa\u0107 w\u0142asn\u0105 kolekcj\u0119 specjalistycznych narz\u0119dzi.","og_url":"https:\/\/dev.fotc.com\/pl\/blog\/goal-seek-dodatek\/","og_site_name":"FOTC","article_published_time":"2019-10-15T11:23:36+00:00","article_modified_time":"2021-09-29T11:34:09+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/dev.fotc.com\/app\/uploads\/2021\/07\/Goal-Seek_1200x628-1.jpg","type":"image\/jpeg"}],"author":"Agata Koptewicz","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Agata Koptewicz","Est. reading time":"2 minuty"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/dev.fotc.com\/pl\/blog\/goal-seek-dodatek\/","url":"https:\/\/dev.fotc.com\/pl\/blog\/goal-seek-dodatek\/","name":"Goal Seek \u2013 nowy dodatek do Arkuszy Google - FOTC","isPartOf":{"@id":"https:\/\/dev.fotc.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dev.fotc.com\/pl\/blog\/goal-seek-dodatek\/#primaryimage"},"image":{"@id":"https:\/\/dev.fotc.com\/pl\/blog\/goal-seek-dodatek\/#primaryimage"},"thumbnailUrl":"https:\/\/dev.fotc.com\/app\/uploads\/2021\/07\/Goal-Seek_1200x628-1.jpg","datePublished":"2019-10-15T11:23:36+00:00","dateModified":"2021-09-29T11:34:09+00:00","author":{"@id":"https:\/\/dev.fotc.com\/#\/schema\/person\/03dfc51e82408d6ffb682d5c4facf95a"},"breadcrumb":{"@id":"https:\/\/dev.fotc.com\/pl\/blog\/goal-seek-dodatek\/#breadcrumb"},"inLanguage":"pl-PL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dev.fotc.com\/pl\/blog\/goal-seek-dodatek\/"]}]},{"@type":"ImageObject","inLanguage":"pl-PL","@id":"https:\/\/dev.fotc.com\/pl\/blog\/goal-seek-dodatek\/#primaryimage","url":"https:\/\/dev.fotc.com\/app\/uploads\/2021\/07\/Goal-Seek_1200x628-1.jpg","contentUrl":"https:\/\/dev.fotc.com\/app\/uploads\/2021\/07\/Goal-Seek_1200x628-1.jpg","width":1200,"height":628},{"@type":"BreadcrumbList","@id":"https:\/\/dev.fotc.com\/pl\/blog\/goal-seek-dodatek\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"PL","item":"https:\/\/dev.fotc.com\/pl\/"},{"@type":"ListItem","position":2,"name":"Goal Seek \u2013 nowy dodatek do Arkuszy Google"}]},{"@type":"WebSite","@id":"https:\/\/dev.fotc.com\/#website","url":"https:\/\/dev.fotc.com\/","name":"FOTC","description":"Partner Google Cloud","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dev.fotc.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pl-PL"},{"@type":"Person","@id":"https:\/\/dev.fotc.com\/#\/schema\/person\/03dfc51e82408d6ffb682d5c4facf95a","name":"Agata Koptewicz","image":{"@type":"ImageObject","inLanguage":"pl-PL","@id":"https:\/\/dev.fotc.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/9e8bcc5b9c885316642ef864a39c37cb51fc8581c4c25d3cf1c78646a1919f4e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/9e8bcc5b9c885316642ef864a39c37cb51fc8581c4c25d3cf1c78646a1919f4e?s=96&d=mm&r=g","caption":"Agata Koptewicz"},"description":"Content Manager at Fly On The Cloud. During business hours, Agata creates articles that teach, entertain, and sell, but in free time she performs linguistic acrobatics on the verge of good taste. Privately she leads a pack of Dobermans and closely follows technological news.","url":"https:\/\/dev.fotc.com\/pl\/blog\/author\/agata-koptewicz\/"}]}},"_links":{"self":[{"href":"https:\/\/dev.fotc.com\/pl\/wp-json\/wp\/v2\/posts\/31148","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dev.fotc.com\/pl\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dev.fotc.com\/pl\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dev.fotc.com\/pl\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/dev.fotc.com\/pl\/wp-json\/wp\/v2\/comments?post=31148"}],"version-history":[{"count":0,"href":"https:\/\/dev.fotc.com\/pl\/wp-json\/wp\/v2\/posts\/31148\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dev.fotc.com\/pl\/wp-json\/wp\/v2\/media\/4640"}],"wp:attachment":[{"href":"https:\/\/dev.fotc.com\/pl\/wp-json\/wp\/v2\/media?parent=31148"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dev.fotc.com\/pl\/wp-json\/wp\/v2\/categories?post=31148"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dev.fotc.com\/pl\/wp-json\/wp\/v2\/tags?post=31148"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}