{"id":31148,"date":"2019-10-15T13:23:36","date_gmt":"2019-10-15T11:23:36","guid":{"rendered":"https:\/\/fotc.com\/goal-seek-dodatek\/"},"modified":"2022-05-25T13:27:11","modified_gmt":"2022-05-25T11:27:11","slug":"goal-seek-dodatek","status":"publish","type":"post","link":"https:\/\/fotc.com\/pl\/blog\/goal-seek-dodatek\/","title":{"rendered":"Goal Seek \u2013 nowy dodatek do Arkuszy Google"},"content":{"rendered":"\n<div class=\"wp-block-yoast-seo-table-of-contents yoast-table-of-contents collapsed\"><h2> Spis tre\u015bci <\/h2><ul><li><a href=\"#h-do-czego-s-u-y-dodatek-goal-seek\" data-level=\"2\">Do czego s\u0142u\u017cy dodatek Goal Seek?<\/a><\/li><li><a href=\"#h-instrukcja-korzystania-z-dodatku-goal-seek\" data-level=\"2\">Instrukcja korzystania z dodatku Goal Seek<\/a><\/li><\/ul><\/div>\n\n\n\n<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\n\n\n<!--more-->\n\n\n\n<h2 id=\"h-do-czego-s-u-y-dodatek-goal-seek\"><strong>Do czego s\u0142u\u017cy dodatek Goal Seek?<\/strong><\/h2>\n\n\n\n<p>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.&nbsp;<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img src=\"https:\/\/fotc.com\/app\/uploads\/2021\/07\/Goal_Seek_GIF_1.gif\" alt=\"szukaj wyniku arkusze google gif\" class=\"wp-image-22506\"\/><\/figure><\/div>\n\n\n\n<p>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.&nbsp;<\/p>\n\n\n\n<p>Aby z niej skorzysta\u0107, musimy zna\u0107:<\/p>\n\n\n\n<ul><li>&nbsp;kom\u00f3rk\u0119, w kt\u00f3rej jest formu\u0142a,&nbsp;<\/li><li>&nbsp;warto\u015b\u0107, jak\u0105 formu\u0142a ma wyliczy\u0107 (czyli nasz kwartalny target),<\/li><li>&nbsp;kom\u00f3rk\u0119, dla kt\u00f3rej dodatek obliczy warto\u015b\u0107, aby osi\u0105gn\u0105\u0107 zamierzony rezultat.<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img src=\"https:\/\/fotc.com\/app\/uploads\/2021\/07\/Goal_Seek_GIF_3.gif\" alt=\"goal seek szukaj wyniku google arkusze dodatek\" class=\"wp-image-22508\"\/><\/figure><\/div>\n\n\n\n<h2 id=\"h-instrukcja-korzystania-z-dodatku-goal-seek\"><strong>Instrukcja korzystania z dodatku Goal Seek<\/strong><\/h2>\n\n\n\n<p>Gdy mamy niezb\u0119dne dane, to wystarczy kilka krok\u00f3w, by przeprowadzi\u0107 \u017c\u0105dan\u0105 operacj\u0119.<\/p>\n\n\n\n<ol><li>Pobierz i zainstaluj dodatek <a href=\"https:\/\/gsuite.google.com\/marketplace\/app\/goal_seek\/583737146763\" rel=\"nofollow\">Goal Seek z Google Workspace Marketplace<\/a>.<\/li><li>Kliknij <b>Dodatki<\/b> na pasku zak\u0142adek i otw\u00f3rz dodatek Goal Seek.<\/li><li>Wype\u0142nij arkusz zmiennymi, kt\u00f3re znasz.<\/li><li>Zaznacz kom\u00f3rk\u0119 zawieraj\u0105c\u0105 formu\u0142\u0119.<\/li><li>Kliknij <b>Capture selected cell<\/b> tu\u017c obok pola <b>Set cell<\/b>.&nbsp;<\/li><li>W polu <b>To value<\/b> wstaw wynik, kt\u00f3ry chcesz osi\u0105gn\u0105\u0107.<\/li><li>Zaznacz kom\u00f3rk\u0119, w kt\u00f3rej ma si\u0119 pojawi\u0107 szukana zmienna.<\/li><li>Kliknij <b>Capture selected cell<\/b> obok <b>By changing cell<\/b>.<\/li><li>Kliknij <b>Solve<\/b>, by rozpocz\u0105\u0107 obliczanie.&nbsp;<\/li><\/ol>\n\n\n\n<p>Dodatek jest ju\u017c dost\u0119pny dla wszystkich wariant\u00f3w <a href=\"https:\/\/fotc.com\/pl\/google-workspace\/\">Google Workspace<\/a>.<\/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":1,"_editorskit_typography_data":[],"_editorskit_blocks_typography":"","_editorskit_is_block_options_detached":false,"_editorskit_block_options_position":"{}"},"categories":[563],"tags":[111,141],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v16.7 (Yoast SEO v19.6) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Goal Seek - przydatna wtyczka do Arkuszy Google | FOTC<\/title>\n<meta name=\"description\" content=\"Funkcja Goal Seek pomo\u017ce znale\u017a\u0107 zmienne, kt\u00f3re umo\u017cliwiaj\u0105 osi\u0105gni\u0119cie konkretnego wyniku poprzez dowoln\u0105 formu\u0142\u0119 w Arkuszach Google.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/fotc.com\/pl\/blog\/goal-seek-dodatek\/\" \/>\n<meta property=\"og:locale\" content=\"pl_PL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Goal Seek - przydatna wtyczka do Arkuszy Google | FOTC\" \/>\n<meta property=\"og:description\" content=\"Funkcja Goal Seek pomo\u017ce znale\u017a\u0107 zmienne, kt\u00f3re umo\u017cliwiaj\u0105 osi\u0105gni\u0119cie konkretnego wyniku poprzez dowoln\u0105 formu\u0142\u0119 w Arkuszach Google.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/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=\"2022-05-25T11:27:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/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:title\" content=\"Goal Seek - przydatna wtyczka do Arkuszy Google | FOTC\" \/>\n<meta name=\"twitter:description\" content=\"Funkcja Goal Seek pomo\u017ce znale\u017a\u0107 zmienne, kt\u00f3re umo\u017cliwiaj\u0105 osi\u0105gni\u0119cie konkretnego wyniku poprzez dowoln\u0105 formu\u0142\u0119 w Arkuszach Google.\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/fotc.com\/pl\/blog\/goal-seek-dodatek\/\",\"url\":\"https:\/\/fotc.com\/pl\/blog\/goal-seek-dodatek\/\",\"name\":\"Goal Seek - przydatna wtyczka do Arkuszy Google | FOTC\",\"isPartOf\":{\"@id\":\"https:\/\/fotc.com\/#website\"},\"datePublished\":\"2019-10-15T11:23:36+00:00\",\"dateModified\":\"2022-05-25T11:27:11+00:00\",\"author\":{\"@id\":\"https:\/\/fotc.com\/#\/schema\/person\/03dfc51e82408d6ffb682d5c4facf95a\"},\"description\":\"Funkcja Goal Seek pomo\u017ce znale\u017a\u0107 zmienne, kt\u00f3re umo\u017cliwiaj\u0105 osi\u0105gni\u0119cie konkretnego wyniku poprzez dowoln\u0105 formu\u0142\u0119 w Arkuszach Google.\",\"breadcrumb\":{\"@id\":\"https:\/\/fotc.com\/pl\/blog\/goal-seek-dodatek\/#breadcrumb\"},\"inLanguage\":\"pl-PL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/fotc.com\/pl\/blog\/goal-seek-dodatek\/\"]}],\"accessibilityFeature\":[\"tableOfContents\"]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/fotc.com\/pl\/blog\/goal-seek-dodatek\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"PL\",\"item\":\"https:\/\/fotc.com\/pl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google Workspace\",\"item\":\"https:\/\/fotc.com\/pl\/blog\/category\/google-workspace-pl\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Goal Seek \u2013 nowy dodatek do Arkuszy Google\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/fotc.com\/#website\",\"url\":\"https:\/\/fotc.com\/\",\"name\":\"FOTC\",\"description\":\"Partner Google Cloud\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/fotc.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"pl-PL\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/fotc.com\/#\/schema\/person\/03dfc51e82408d6ffb682d5c4facf95a\",\"name\":\"Agata Koptewicz\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pl-PL\",\"@id\":\"https:\/\/fotc.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/59437c23b14a31cf4f472ba347613a64?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/59437c23b14a31cf4f472ba347613a64?s=96&d=mm&r=g\",\"caption\":\"Agata Koptewicz\"},\"description\":\"Content manager at FOTC since 2019. For the past 7 years, she has been involved in copywriting, creative writing, and content development for gaming, technology, and eCommerce companies. She is passionate about designing strategies for effective communication.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/agata-koptewicz-c0pywriter\/\"],\"knowsLanguage\":[\"Polish\",\"English\"],\"jobTitle\":\"Content Manager\",\"worksFor\":\"FOTC\",\"url\":\"https:\/\/fotc.com\/pl\/blog\/author\/agata-koptewicz\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Goal Seek - przydatna wtyczka do Arkuszy Google | FOTC","description":"Funkcja Goal Seek pomo\u017ce znale\u017a\u0107 zmienne, kt\u00f3re umo\u017cliwiaj\u0105 osi\u0105gni\u0119cie konkretnego wyniku poprzez dowoln\u0105 formu\u0142\u0119 w Arkuszach Google.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/fotc.com\/pl\/blog\/goal-seek-dodatek\/","og_locale":"pl_PL","og_type":"article","og_title":"Goal Seek - przydatna wtyczka do Arkuszy Google | FOTC","og_description":"Funkcja Goal Seek pomo\u017ce znale\u017a\u0107 zmienne, kt\u00f3re umo\u017cliwiaj\u0105 osi\u0105gni\u0119cie konkretnego wyniku poprzez dowoln\u0105 formu\u0142\u0119 w Arkuszach Google.","og_url":"https:\/\/fotc.com\/pl\/blog\/goal-seek-dodatek\/","og_site_name":"FOTC","article_published_time":"2019-10-15T11:23:36+00:00","article_modified_time":"2022-05-25T11:27:11+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/fotc.com\/app\/uploads\/2021\/07\/Goal-Seek_1200x628-1.jpg","type":"image\/jpeg"}],"author":"Agata Koptewicz","twitter_card":"summary_large_image","twitter_title":"Goal Seek - przydatna wtyczka do Arkuszy Google | FOTC","twitter_description":"Funkcja Goal Seek pomo\u017ce znale\u017a\u0107 zmienne, kt\u00f3re umo\u017cliwiaj\u0105 osi\u0105gni\u0119cie konkretnego wyniku poprzez dowoln\u0105 formu\u0142\u0119 w Arkuszach Google.","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/fotc.com\/pl\/blog\/goal-seek-dodatek\/","url":"https:\/\/fotc.com\/pl\/blog\/goal-seek-dodatek\/","name":"Goal Seek - przydatna wtyczka do Arkuszy Google | FOTC","isPartOf":{"@id":"https:\/\/fotc.com\/#website"},"datePublished":"2019-10-15T11:23:36+00:00","dateModified":"2022-05-25T11:27:11+00:00","author":{"@id":"https:\/\/fotc.com\/#\/schema\/person\/03dfc51e82408d6ffb682d5c4facf95a"},"description":"Funkcja Goal Seek pomo\u017ce znale\u017a\u0107 zmienne, kt\u00f3re umo\u017cliwiaj\u0105 osi\u0105gni\u0119cie konkretnego wyniku poprzez dowoln\u0105 formu\u0142\u0119 w Arkuszach Google.","breadcrumb":{"@id":"https:\/\/fotc.com\/pl\/blog\/goal-seek-dodatek\/#breadcrumb"},"inLanguage":"pl-PL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/fotc.com\/pl\/blog\/goal-seek-dodatek\/"]}],"accessibilityFeature":["tableOfContents"]},{"@type":"BreadcrumbList","@id":"https:\/\/fotc.com\/pl\/blog\/goal-seek-dodatek\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"PL","item":"https:\/\/fotc.com\/pl\/"},{"@type":"ListItem","position":2,"name":"Google Workspace","item":"https:\/\/fotc.com\/pl\/blog\/category\/google-workspace-pl\/"},{"@type":"ListItem","position":3,"name":"Goal Seek \u2013 nowy dodatek do Arkuszy Google"}]},{"@type":"WebSite","@id":"https:\/\/fotc.com\/#website","url":"https:\/\/fotc.com\/","name":"FOTC","description":"Partner Google Cloud","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/fotc.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"pl-PL"},{"@type":"Person","@id":"https:\/\/fotc.com\/#\/schema\/person\/03dfc51e82408d6ffb682d5c4facf95a","name":"Agata Koptewicz","image":{"@type":"ImageObject","inLanguage":"pl-PL","@id":"https:\/\/fotc.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/59437c23b14a31cf4f472ba347613a64?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/59437c23b14a31cf4f472ba347613a64?s=96&d=mm&r=g","caption":"Agata Koptewicz"},"description":"Content manager at FOTC since 2019. For the past 7 years, she has been involved in copywriting, creative writing, and content development for gaming, technology, and eCommerce companies. She is passionate about designing strategies for effective communication.","sameAs":["https:\/\/www.linkedin.com\/in\/agata-koptewicz-c0pywriter\/"],"knowsLanguage":["Polish","English"],"jobTitle":"Content Manager","worksFor":"FOTC","url":"https:\/\/fotc.com\/pl\/blog\/author\/agata-koptewicz\/"}]}},"_links":{"self":[{"href":"https:\/\/fotc.com\/pl\/wp-json\/wp\/v2\/posts\/31148"}],"collection":[{"href":"https:\/\/fotc.com\/pl\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fotc.com\/pl\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fotc.com\/pl\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/fotc.com\/pl\/wp-json\/wp\/v2\/comments?post=31148"}],"version-history":[{"count":0,"href":"https:\/\/fotc.com\/pl\/wp-json\/wp\/v2\/posts\/31148\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/fotc.com\/pl\/wp-json\/wp\/v2\/media\/4640"}],"wp:attachment":[{"href":"https:\/\/fotc.com\/pl\/wp-json\/wp\/v2\/media?parent=31148"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fotc.com\/pl\/wp-json\/wp\/v2\/categories?post=31148"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fotc.com\/pl\/wp-json\/wp\/v2\/tags?post=31148"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}