Простой прогноз продаж в Excel с учетом сезонности
203,5K203,5 тысяч просмотров
Дата публикации 23 мар 201723 мар 2017
{"pages":{"search":{"query":"videoid:146425988200907877","originalQuery":"","serpid":"1754660873355442-17962862113667018032-balancer-l7leveler-kubr-yp-sas-216-BAL","reqid":"1754660873355442-17962862113667018032-balancer-l7leveler-kubr-yp-sas-216-BAL","parentReqid":"","serpItems":[{"id":"146425988200907877-0-0","type":"videoSnippet","props":{"videoId":"146425988200907877"},"curPage":0}],"filters":{},"serpFooter":{"linksGroups":[{"type":"geo","links":[{"label":"Колумбус","title":"Колумбус","url":"//yandex.kz/tune/geo/","logNode":{"name":"region"},"target":"_self","a11yLabel":"Ваш регион Колумбус","needRetpath":true}]},{"type":"searchengines","links":[{"label":"Google","url":"//google.kz/search?tbm=vid&q=videoid%3A146425988200907877","logNode":{"name":"link","attrs":{"type":"google"}},"target":"_blank"},{"label":"Bing","url":"//bing.com/videos?scope=video&q=videoid%3A146425988200907877","logNode":{"name":"link","attrs":{"type":"bing"}},"target":"_blank"}]},{"type":"help","links":[{"label":"Обратная связь","url":"https://yandex.kz/support/video/troubleshooting.html","logNode":{"name":"feedback"},"needRetpath":true},{"label":"Справка","url":"https://yandex.kz/support/video/","logNode":{"name":"help"},"needRetpath":true}]},{"type":"settings","links":[{"label":"Настройки","url":"https://yandex.kz/tune/search/","target":"_self","logNode":{"name":"settings"},"needRetpath":true}]},{"type":"company","links":[{"label":"О компании","url":"//yandex.kz/company/","logNode":{"name":"about"},"target":"_blank"},{"label":"Лицензия на использование","url":"//yandex.kz/legal/termsofuse/","logNode":{"name":"license"},"target":"_blank"},{"label":"Политика конфиденциальности","url":"//yandex.kz/legal/confidential/","logNode":{"name":"confidential"},"target":"_blank"}],"a11yHidden":true}],"hasExtralinks":true},"currentPage":0,"prevPageToLoad":-1,"nextPageToLoad":1,"isTranslationsFilterEnabled":false,"isTranslationsDistributionEnabled":true,"isTranslationsDistributionOnboardingEnabled":true,"isFeedbackModalVisible":false,"viewerData":{},"prevention":{},"hasNextPage":false,"rightSerpItems":[{"type":"direct","id":"search-list-right","props":{"advRsyaActivateParams":{"pcodeParams":{"blockId":"R-I-8843654-1","renderTo":"search-list-right-0-R-I-8843654-1","pageNumber":0,"grab":"dHZpZGVvaWQ6MTQ2NDI1OTg4MjAwOTA3ODc3Cg==","darkTheme":false,"lazyLoad":false,"extParams":{"reqid":"1754660873355442-17962862113667018032-balancer-l7leveler-kubr-yp-sas-216-BAL","ui":"desktop","yuid":"2197005751754660869"}}},"isAdult":false,"position":0,"placement":"search-list-right"},"curPage":0}],"quasarData":{"title":""},"isAdultQuery":false,"errorList":[],"layout":"list","retpath":"https%3A%2F%2Fyandex.kz%2Fvideo%2Fpreview%2F146425988200907877"},"main":{"_isInitial":true,"snippets":[],"serpFooter":{"linksGroups":[]},"isLoggedIn":false}},"internal":{"nonce":"9628621136670180327216","expFlags":{"video_depot_viewer":1,"video_instream_player_yaru_loader":1,"video_skeleton_doc_update":1,"velocity_delay_drawer":1,"video_relqueries_new_format":1,"video_instream_disable_hosts":"dzen.ru,ok.ru,vk.com,video.mail.ru","video_search_toggle_with_text":1,"video_single_vh_unmute":1,"video_update_d2d_after_clickout":1,"video_viewer_desktop_hide_tabs":1,"velocity_disable_suspense":1,"video_viewer_desktop_smart_layout":1,"dark_theme_desktop":"cookie","video_instream_player_config":{"vmapScenarioId":119,"category":2,"impId":7,"partnerId":2216089},"video_font_yandex_sans":1,"video_adv_new_show_rules":1,"video_resource_loader":1,"video_adv_config_desktop":{"before-player":{"regular":{"default":"R-I-2120168-1"}}},"video_nohost_full_filter_onboarding_enable":1,"video_skeleton_direct_under_player_update":1,"video_instream_player_config_porno":{"vmapScenarioId":119,"category":3,"impId":4,"partnerId":1988486},"video_vh_player_js":0,"video_dzc":1,"video_masthead_ratio":"180,4","video_searchdata_scheme":1,"video_single_vh_iframe":1,"velocity_delay_metrika":1,"video_viewer_desktop_visible_header":1,"video_partner_label":1,"video_direct_render_in_viewport":1,"video_skeleton_instream_update":1,"video_resource_loader_load_timeout":6000,"video_viewer_catch_sandbox_early_inits":1,"mmui_extended_escape_scheme":"searchdata.clips.0.authorname","spok":"id","video_search_grid_direct_repeat":6,"video_direct_config_desktop_search":"search-grid-row:R-I-48058-718:R-I-474674-109,search-grid-head:R-I-2120168-7","init_meta":{"ask-user-purchase-history":1,"use-src-videoquickp":1,"enable-begemot":1,"enable_masthead":1,"use-src-videop":1,"use-src-videoquickp_misspell":1,"enable_blackbox_multisession":1,"begemot-enable-cancelled-misspell-rtmr":1,"enable_video_iron_fetcher":1,"use-related-only":1,"ask-yandex-io-devices":1,"use-images-device-setup":1,"use-src-imagesp":1,"images-apphost-collections-front":1,"enable_aab_apphost":1,"graph-is-video-search":1,"use-src-imagesp_misspell":1,"use-src-imagesultrap":1,"use-video-apphost-pre-templates":1,"use-src-videop_misspell":1,"use-video-apphost-post-templates":1,"use-src-imagesquickp":1,"enable_video_carousels":"1","restrict-max-docs":"1000","use-images-region-setup":1,"use-post-auto2":1,"use-images-settings-setup":1,"use-src-ugc_favorites":1,"use-images-user-setup":1,"use-video-pre-search-data":1,"begemot-no-suggest-history":1},"video_depot_viewer_masthead_ssr_only":1,"video_skeleton_direct_organic_update":1,"video_blender":1,"video_search_grid_enable":0,"video_depot_viewer_legacy_counters":1,"video_search_grid_direct_start":3,"video_instream_players_yaru_enable":1,"video_adv_new_show_rules_docs_count":1,"beauty_header_futuris_tab":9,"video_redirect_plug":2,"video_disable_serp_dzc":1,"dark_theme_desktop_default_pref":"system","video_search_toggle_enable":1,"video_viewer_desktop_blocks":1,"velocity_split_hydration":4,"video_duration_counter_new_format":1,"video_force_grid_on_premordie":1,"video_morda_header_nav":1,"video_nohost_full_filter":1,"video_baobab_blockstat":1,"video_thumb_poster_full":1,"video_scrollpages":2,"video_serp_desktop_block_design":1,"video_nohost_youtube_filter":0,"video_direct_viewport_margin_desktop":700},"slots":["1296088,0,47;1312013,0,99;1326803,0,18;1314083,0,4;1328907,0,76;1316373,0,97;1304938,0,54;1317608,0,47;1152684,0,60;1138230,0,10;1180957,0,62;1319073,0,53;1324943,0,82;187288,0,54;50738,0,82;1330082,0,25;1327348,0,54;1317796,0,8;1319478,0,58;1188717,0,11;1304811,0,13;241534,0,95;260564,0,81;90496,0,27;1329105,0,58;461653,0,81;1314874,0,91;1145208,0,7;1326031,0,16;1194005,0,49;1330148,0,15;151171,0,88;1281084,0,95;287509,0,93;1006734,0,82;1277330,0,12"],"isYandexNet":false,"platform":"desktop","isEnLogo":false,"retpath":"https%3A%2F%2Fyandex.kz%2Fvideo%2Fpreview%2F146425988200907877","mordaUrl":"//yandex.kz/","videoSearchUrl":"https://yandex.kz/video/search?text=%D0%9F%D1%80%D0%BE%D1%81%D1%82%D0%BE%D0%B9+%D0%BF%D1%80%D0%BE%D0%B3%D0%BD%D0%BE%D0%B7+%D0%BF%D1%80%D0%BE%D0%B4%D0%B0%D0%B6+%D0%B2+Excel+%D1%81+%D1%83%D1%87%D0%B5%D1%82%D0%BE%D0%BC+%D1%81%D0%B5%D0%B7%D0%BE%D0%BD%D0%BD%D0%BE%D1%81%D1%82%D0%B8","settingsUrl":"https://yandex.kz/tune/search/","helpUrl":"https://yandex.ru/support/video/","legalUrl":"//company.yandex.ru/legal/termsofuse/","feedbackUrl":"https://yandex.kz/support/video/troubleshooting.html","basename":"/video","currentPageName":"previewShort","isYandexApp":false,"isYandexAppAndroid":false,"isYandexAppIos":false,"isAnyYaBro":false,"isAndroid":false,"isHamster":false,"serpid":"1754660873355442-17962862113667018032-balancer-l7leveler-kubr-yp-sas-216-BAL","backUrl":"//ya.ru","url":"https://yandex.kz/video/preview/146425988200907877?","isIntegrationTest":false,"isEndToEndTest":false,"shouldDropLogs":false,"seo":{"url":"https://yandex.kz/video/preview/146425988200907877","title":"Простой прогноз продаж в Excel с учетом сезонности","description":"Пошаговое видео как с помощью Excel построить прогноз продаж на будущие периоды с учетом сезонности ...","image":"http://avatars.mds.yandex.net/get-vthumb/3382852/ae7d825b469e33f995add0391695421a/800x450","imageSecureUrl":"https://avatars.mds.yandex.net/get-vthumb/3382852/ae7d825b469e33f995add0391695421a/800x450","video":"https://video-preview.s3.yandex.net/atO3mQAAAAA.mp4","videoType":"video/mp4","imageWidth":800,"imageHeight":450,"type":"video"},"isEmbedded":false,"isPumpkin":false,"quasarCsrfToken":"ybda5d1a6ecc97ffdb6fc914b17079d82","reportFeedbackBaseProps":{"initEmail":"","metaFields":{"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","userTestids":"1296088,1312013,1326803,1314083,1328907,1316373,1304938,1317608,1152684,1138230,1180957,1319073,1324943,187288,50738,1330082,1327348,1317796,1319478,1188717,1304811,241534,260564,90496,1329105,461653,1314874,1145208,1326031,1194005,1330148,151171,1281084,287509,1006734,1277330","queryText":"","reqid":"1754660873355442-17962862113667018032-balancer-l7leveler-kubr-yp-sas-216-BAL","userRegionName":"","userRegionId":"function() {\n return this._region.id;\n }","yandexuid":"2197005751754660869","uid":"0","isChildAccount":false}},"userTestids":"191768,238743,246500,253288,265553,270072,277807,274239,294077,278842,299121,313103,331010,338398,378416,359879,415420,644350,652605,645301,679708,689693,690449,696466,696473,722746,740796,776165,771230,781521,790415,801982,851450,886706,883477,900639,931367,937268,969063,935488,945314,989988,982463,991363,990185,1015567,1011895,1035320,1033956,1035241,1036046,1087297,1089355,1060131,1099741,1071879,1078818,1077703,1116602,1045814,1131637,1144233,1151726,1152703,1156933,1174275,1167408,1202006,1194718,1221235,1228280,1227266,1226860,1246754,1281110,1288208,1313283,1321224,1322475,1326469,1300570,1299604,1296088,1312013,1314083,1324943,187288,50738,241534,260564,90496,461653","regionId":20815,"isYaRu":false,"shouldUnmountSearchPageInViewer":false,"videoGlobalContext":{"platform":"desktop","isPumpkin":false,"language":"ru","user_time":{"epoch":"1754660873","tz":"America/Louisville","to_iso":"2025-08-08T09:47:53-0400","__is_plain":1},"isQuasarEnabled":false,"isHermione":false,"shouldStubImages":true,"enableVideoPreviewInHermione":false,"reqid":"1754660873355442-17962862113667018032-balancer-l7leveler-kubr-yp-sas-216-BAL","tld":"kz","isEmbedded":false,"shouldDailyClickoutDzenInSerp":false,"shouldDailyClickoutDzenInViewer":true,"shouldDisableWebp":false,"removeLinkPrefix":"/video","shouldUseHighresPreview":true,"shouldCutSnippetTitle":true,"shouldShowPlusBadge":true,"reportFeedbackBaseProps":{"initEmail":"","metaFields":{"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","userTestids":"1296088,1312013,1326803,1314083,1328907,1316373,1304938,1317608,1152684,1138230,1180957,1319073,1324943,187288,50738,1330082,1327348,1317796,1319478,1188717,1304811,241534,260564,90496,1329105,461653,1314874,1145208,1326031,1194005,1330148,151171,1281084,287509,1006734,1277330","queryText":"","reqid":"1754660873355442-17962862113667018032-balancer-l7leveler-kubr-yp-sas-216-BAL","userRegionName":"","userRegionId":"function() {\n return this._region.id;\n }","yandexuid":"2197005751754660869","uid":"0","isChildAccount":false}},"deviceDetect":{"OSFamily":"Unknown","isTV":0,"x64":0,"GoogleToolBarVersion":"","MultiTouch":0,"BrowserBase":"","YandexBarVersion":"","isTablet":0,"YandexBar":0,"hasWebOmni":0,"isTouch":0,"hasYandexCamera":0,"isMobile":0,"DeviceKeyboard":"","device":"desktop","TurboAppPlatformVersion":"","historySupport":0,"BrowserShellVersion":"","DeviceVendor":"","isBrowser":0,"hasFlash":0,"MailRuSputnikVersion":"","isSameSiteSupported":0,"BrowserBaseVersion":"","BrowserVersionRaw":"","hasWebVert":0,"DeviceId":"","error":"","MailRuAgent":0,"ScreenWidth":0,"inAppBrowser":0,"hasHTML5":0,"isEmulator":0,"J2ME":0,"MailRuAgentVersion":"","BrowserEngineVersionRaw":"537.36","isRobot":1,"__is_plain":1,"BrowserEngineVersion":"0537.0036","BrowserName":"Unknown","DeviceModel":"","BrowserEngine":"WebKit","DeviceName":"","OSVersionRaw":"","OSName":"","GoogleToolBar":0,"ScreenSize":"","isTurboApp":0,"MailRuSputnik":0,"YaBuildName":"","isWAP":0,"PreferMobile":0,"DesktopMode":0,"BrowserVersion":"","BitsPerPixel":0,"BrowserShell":"","YaGUI":"","isBeta":0,"OSVersion":"","ScreenHeight":0},"nonce":"9628621136670180327216","disableDoc2DocHostLink":true,"shouldHideChannelLink":true,"enableSlowBufferingAlert":false,"enableSlowBufferingAlertDedup":false,"userConnectionRtt":156,"visibleHeader":true,"hideTabs":true,"animated":false,"isServiceLikeViewer":false,"isDoc2DocScrollFix":false,"smartDesktopLayout":true,"isAdvDisabled":false,"shouldShowVideoPlaylistPane":false,"isVideoTranslationSupported":false,"isSummaryDisabled":false,"isSummaryOnlineEnabled":false,"isPlainHeader":false,"shouldRenderBroSummaryApiContainer":false,"shouldDropLogs":false,"shouldUseBeacon":false,"hasAdBlock":false,"isVerificationMarkDisabled":false,"shouldPlayNonStopForExternal":false,"forceSlowBufferingAlert":false,"rknWarnHosts":[""],"postInstreamScreenDuration":2000,"minVideoDurationForInstream":120,"isInstreamEnabledInTesting":false,"useSendBeacon":false},"shouldShowAdvId":false,"isAdultQuery":false,"classQueryIsPornoWebScore":0.002855769359,"showSensitive":false,"shouldReplaceHref":false},"user":{"tld":"kz","isEuDomain":false,"login":"","passportId":"","isLoggedIn":false,"locationName":"Колумбус","isFamily":false,"yandexuid":"2197005751754660869","ugcCsrfToken":"","family":1,"isChild":false},"config":{"skinMode":"system","skin":"light","version":"releases/frontend/video/v1.1645.0#921b99f6001c1ee836cffbe42b089c60da2a959a","isGridSupported":false,"advConfig":{"under-player":{"regular":{"default":"R-I-48058-725","mail":"R-A-13411721-6"},"adult":{"default":"R-I-474674-114","mail":"R-A-13426421-6"}},"under-player-lite":{"regular":{"default":"R-I-48058-728"},"adult":{"default":"R-I-474674-103"}},"under-player-old":{"regular":{"default":"R-I-48058-725","mail":"R-A-13411721-6"},"adult":{"default":"R-I-474674-114","mail":"R-A-13426421-6"}},"video-list":{"regular":{"default":"R-I-48058-708","mail":"R-A-13411721-2"},"adult":{"default":"R-I-474674-101","mail":"R-A-13426421-2"}},"search-list":{"regular":{"default":"R-I-48058-715","mail":"R-A-13411721-3"},"adult":{"default":"R-I-474674-108","mail":"R-A-13426421-3"}},"search-grid-row":{"regular":{"default":"R-I-48058-718","mail":"R-A-13411721-4"},"adult":{"default":"R-I-474674-109","mail":"R-A-13426421-4"}},"search-grid-head":{"regular":{"default":"R-I-2120168-7"}},"search-list-right":{"regular":{"default":"R-I-8843654-1"}},"before-player-old":{"regular":{"default":"R-I-2120168-1"}},"before-player":{"regular":{"default":"R-I-2120168-1"}}},"isSkinInitedOnClient":false},"counters":{"params":{"useBeacon":false,"clickHost":"yandex.kz/clck","pid":197},"dict":{"viewer":"2921","user":"538","info":"1275","sources":"1500","select":"775","close":"486","open":"842","source":"186","link":"513","click":"882","tech":"690","player":"1242","change":"719","summary":"3410","init":"1309","item":"22","button":"440","shown":"3780","copy":"1276","text":"232","load":"1724","fallback":"2010","channel":"1345","hide":"1656"}},"clips":{"items":{"146425988200907877":{"videoId":"146425988200907877","docid":"34-7-15-ZAA303B5EB08EEEB9","description":"Пошаговое видео как с помощью Excel построить прогноз продаж на будущие периоды с учетом сезонности и создать красивый график прогноза. Решение можно применить в Excel 2003 и выше. Так же...","preview":{"posterSrc":"//avatars.mds.yandex.net/get-vthumb/3382852/ae7d825b469e33f995add0391695421a/564x318_1","videoSrc":"https://video-preview.s3.yandex.net/atO3mQAAAAA.mp4","videoType":"video/mp4"},"target":"_self","position":"0","reqid":"1754660873355442-17962862113667018032-balancer-l7leveler-kubr-yp-sas-216-BAL","summary":{"fullTextUrl":"/video/result?ask_summarization=1&numdoc=1&noreask=1&nomisspell=1&parent-reqid=1754660873355442-17962862113667018032-balancer-l7leveler-kubr-yp-sas-216-BAL&text=videoid:146425988200907877","teaser":[{"list":{"type":"unordered","items":["Ввод формулы для расчета коэффициента сезонности, который учитывает только полные годы.","Деление суммы продаж за первый год на сумму продаж за весь период и умножение на 12."]},"endTime":381,"title":"Расчет коэффициента сезонности","beginTime":324},{"list":{"type":"unordered","items":["Использование функции \"Индекс\" для применения коэффициента сезонности к прогнозу.","Указание номера строки в диапазоне для получения коэффициента за определенный месяц."]},"endTime":526,"title":"Использование коэффициента сезонности для прогноза","beginTime":381},{"list":{"type":"unordered","items":["Расчет отклонения на основании прогнозируемых значений с использованием функции \"Доверительный интервал\".","Построение графика отклонения для пессимистичного и оптимистичного прогноза."]},"endTime":1125,"title":"Построение графика отклонения","beginTime":526}],"linkTemplate":"/video/preview/146425988200907877?parent-reqid=1754660873355442-17962862113667018032-balancer-l7leveler-kubr-yp-sas-216-BAL&t=%%timestamp%%&ask_summarization=1"},"isAdultDoc":false,"relatedParams":{"text":"Простой прогноз продаж в Excel с учетом сезонности","related_orig_text":"","related_porno":false,"related_short":true,"related_less_3m_off":true,"client":"d2d","no_cnt":1,"related_src":"serp","related":"{\"porno\":false,\"vfp\":1,\"orig_text\":\"\",\"url\":\"http:\\/\\/www.youtube.com\\/watch?v=r7acmsUU7ek\",\"src\":\"serp\",\"rvb\":\"EhQKEjE0NjQyNTk4ODIwMDkwNzg3NxoUChIxNDY0MjU5ODgyMDA5MDc4NzdaEjE0NjQyNTk4ODIwMDkwNzg3N2q9DBIBMBgAIkUaMQAKKmhoZmlveW5ic2R3bHh1cWNoaFVDS2JsVkM1aWN4TzRkVzdzeDZXNy1CdxICABIqEMIPDxoPPxPlCIIEJAGABCsqiwEQARp4gfH6_AcI9wAD_wYBDwb-AhYSDwf0AwIA9Aj7_v8C_wARBxT7BwEAAP4WCQwGAAAAAfD09wD9AQDcDQb6BAAAACwA_Ab7AP8A7_X4-wABAADv6gv9AwAAABEACfr_AAAAAAUE9fv_AAD_-wQLAAAAABUMAPoAAAAAIAAtBA-8OzgTQAlITlACKoQCEAAa8AF0N0r84s31AYEBOQEe47MCuAD8_xIn-ACIPwQAuf_lAaLS-gIgNfAA8Q3PAZD93gKjJbz-Bvu2ARL_Gv801ygA5sMOAVrtMgI9GqcCNTwOBNz3MPoy-gH_L9tCB0okKf1IxyT999PrArP64gAQ7y3_IzD7COPnOP_oyQAB3jDf__HdFP0t2wwJ_LvBAQogFv9JCBYFGETq_9rX9AfiDw0H_NPJCeuz_gEQJOL8AAvw-PodBf045fP_9WMCBNIL8e7tMwXyUfj4BiAc_gQHyhfwGN_-IhECFwBT9-wNoBkVAvYN-PzINvwGEyAH-BXL4vkgAC1mONk6OBNACUhhUAIqzwcQABrAByuE7b43C8U7s2y5u0S77zwN4Ti9-lKuOww3RT0Dm468XkLqvPDDgT6r-HW8rZ6IPSA1V73ntx490TqPPP7Viz4gxJ88hqkxOwlCuL27NZ89Q59ZPB5aOr0gx727iXirPHCKqD1o7p06KkAPvb5LWT6RHN07oHyLOitXw72dbF69-pQIvYzHiz0q0548j6zXvBbQNb3wxhu7towrOxQVO7sfpQ29AjeBPLgdj71e32I8Aac3vRlYF74VTRG9Lh1zPLt8a7xubpw9Sb6SPHcfNrwaEZE9HDoivGoarz3Ia5Q8EF2QPFq2Uboqz_K8nF7YvI0lEb04wZK9n7enPH7FCr5PIAy9okbfOyzlRj2GTa48Y1CeOyLKEr1kxgA7-1ksPDLMpL3Xxx69AmFpu3FwDj2VyuW8dKrGvJbFDj2BmZo9_8dPu2NgPT0PLsg9ffnuPEAlWD37VHy7RTHUPMg_87zFh6O8pc6tPCRVZT0mvp89D-lcPD4ytz25ncc8ymWnOC-v0ryg4vi8rSy0u7pOEz6WBr48PCEmuyQJZz0bJr-8l0xbukSxSz15XRy8_9YIu4vLnD2kF3q9X3hKvIqt4D2YBak9dcM-u9C0BD6w4tQ8ft0vO5m0zjwmHQU9A09Ou_xlgb2OoVI83-tavDJBKL0prJm9T4dCO-bSkzw3hgW9Dx9gO0267TxEHN45jfUqO-WE5Lwyh069Wa-7u50YbTvOoAo8b42Au2H_1b1GZ1Q9ATbZue6gaD0FnuC8piIZO5uiDT0waBw9IHe2OgVunb2ML1q9s68VOdnt87wXXBi9MtyzN5rHhj0AUya-BV1AOYCCpjxbUCm8eZWRuPTSHj0gNfe8AMJeOLE0UD1kM4E9TRQ0OQL0i71FNZC9O4YxOCIii71FSei9E8qnOBNE_T2OHh--JC2aOONMODw_FzI84v4ButrI9b0wJuI8D0vLOQkspb32UXw8hlkYOC8Ulb0rNBC9N-LTuH9ViTzsGog8PnTruYQNvz0rFt898w2it2oFXL1WvKw8xZrwtxCZrb14QF69K52zuGr0zbp8o1G97QPfOBmtQ70n4LI8Js6HOJHYKT1LBdW9UsIYOKkqWT3QFIA9fK6UOKofRb1j0A07hAgFODRH-7yysqc9HVT7N1Sicb0Ix5E9_BY8uGMzVj12UbS9P5udOK4aGj15czi7m1o4uNecaD3fETq9T2IZuDhK3j07ogc9FEp4OMW_mb1zOEk9XU7juGKCWr1bIGY9ZDW7N5hnSr1BFCc88kRMNyAAOBNACUhtUAEqcxAAGmACBwD5-BHWFSQV8gzwCzP-B-7UAPc1AP7BAAwzysoN_-0X2w8AKegp-7kAAAAQHtErqAAHXu_s_RX2FhXqntzp9n8e_zTUze_6COoNGSLioyPjExgAIhK1DSQGpfIjBQwgAC23TDM7OBNACUhvUAIwCTgBSgBSCQgPEJICGAAwAWAAaAA,\"}","related_url":"http://www.youtube.com/watch?v=r7acmsUU7ek","parent-reqid":"1754660873355442-17962862113667018032-balancer-l7leveler-kubr-yp-sas-216-BAL","related_vfp":1,"relatedVideo":"yes"},"cwidth":1280,"cheight":660,"cratio":1.93939,"dups":["146425988200907877"],"episode":0,"season":0,"isEmbedOnly":false,"greenHost":"YouTube","hasTranslation":false,"contentTypeId":null}},"dups":{"146425988200907877":{"videoId":"146425988200907877","title":"Простой прогноз продаж в Excel с учетом сезонности","cleanTitle":"Простой прогноз продаж в Excel с учетом сезонности","host":{"title":"YouTube","href":"http://www.youtube.com/v/r7acmsUU7ek","playerUri":"\u003ciframe src=\"//www.youtube.com/embed/r7acmsUU7ek?enablejsapi=1&wmode=opaque\" frameborder=\"0\" scrolling=\"no\" allowfullscreen=\"1\" allow=\"autoplay; fullscreen; accelerometer; gyroscope; picture-in-picture\" aria-label=\"Video\">\u003c/iframe>","playerId":"youtube","providerName":"youtube.com","sourceHost":"www.youtube.com","name":"youtube.com","secondPart":{"type":"CHANNEL","id":"d3d3LnlvdXR1YmUuY29tO1VDS2JsVkM1aWN4TzRkVzdzeDZXNy1Cdw==","name":"Дмитрий Щербаков","isVerified":false,"subscribersCount":0,"url":"/video/search?channelId=d3d3LnlvdXR1YmUuY29tO1VDS2JsVkM1aWN4TzRkVzdzeDZXNy1Cdw%3D%3D&how=tm&text=%D0%94%D0%BC%D0%B8%D1%82%D1%80%D0%B8%D0%B9+%D0%A9%D0%B5%D1%80%D0%B1%D0%B0%D0%BA%D0%BE%D0%B2","origUrl":"http://www.youtube.com/@excel-vba_ru","a11yText":"Дмитрий Щербаков. "},"faviconUrl":"//favicon.yandex.net/favicon/v2/http%3A%2F%2Fyoutube.com?color=255%2C255%2C255%2C0&size=32&stub=1"},"duration":{"value":1125,"text":"18:45","a11yText":"Длительность 18 минут 45 секунд"},"views":{"text":"203,5K","shouldShowInSnippet":true,"a11yText":"203,5 тысяч просмотров"},"date":"23 мар 2017","modifyTime":1490252400000,"isExternal":false,"shouldShowQuasar":false,"player":{"embedUrl":"https://www.youtube.com/embed/r7acmsUU7ek?autoplay=1&enablejsapi=1&wmode=opaque","playerId":"youtube","videoUrl":"http://www.youtube.com/watch?v=r7acmsUU7ek","reqid":"1754660873355442-17962862113667018032-balancer-l7leveler-kubr-yp-sas-216-BAL","duration":1125},"parentClipId":"146425988200907877","href":"/preview/146425988200907877?parent-reqid=1754660873355442-17962862113667018032-balancer-l7leveler-kubr-yp-sas-216-BAL","rawHref":"/video/preview/146425988200907877?parent-reqid=1754660873355442-17962862113667018032-balancer-l7leveler-kubr-yp-sas-216-BAL","isEmbedOnly":false,"shouldPlayInstreamPreroll":false}}},"viewer":{"_isInitial":false,"clips":{"items":{"146425988200907877":{"videoId":"146425988200907877","docid":"34-7-15-ZAA303B5EB08EEEB9","description":"Пошаговое видео как с помощью Excel построить прогноз продаж на будущие периоды с учетом сезонности и создать красивый график прогноза. Решение можно применить в Excel 2003 и выше. Так же...","preview":{"posterSrc":"//avatars.mds.yandex.net/get-vthumb/3382852/ae7d825b469e33f995add0391695421a/564x318_1","videoSrc":"https://video-preview.s3.yandex.net/atO3mQAAAAA.mp4","videoType":"video/mp4"},"target":"_self","position":"0","reqid":"1754660873355442-17962862113667018032-balancer-l7leveler-kubr-yp-sas-216-BAL","summary":{"fullTextUrl":"/video/result?ask_summarization=1&numdoc=1&noreask=1&nomisspell=1&parent-reqid=1754660873355442-17962862113667018032-balancer-l7leveler-kubr-yp-sas-216-BAL&text=videoid:146425988200907877","teaser":[{"list":{"type":"unordered","items":["Ввод формулы для расчета коэффициента сезонности, который учитывает только полные годы.","Деление суммы продаж за первый год на сумму продаж за весь период и умножение на 12."]},"endTime":381,"title":"Расчет коэффициента сезонности","beginTime":324},{"list":{"type":"unordered","items":["Использование функции \"Индекс\" для применения коэффициента сезонности к прогнозу.","Указание номера строки в диапазоне для получения коэффициента за определенный месяц."]},"endTime":526,"title":"Использование коэффициента сезонности для прогноза","beginTime":381},{"list":{"type":"unordered","items":["Расчет отклонения на основании прогнозируемых значений с использованием функции \"Доверительный интервал\".","Построение графика отклонения для пессимистичного и оптимистичного прогноза."]},"endTime":1125,"title":"Построение графика отклонения","beginTime":526}],"linkTemplate":"/video/preview/146425988200907877?parent-reqid=1754660873355442-17962862113667018032-balancer-l7leveler-kubr-yp-sas-216-BAL&t=%%timestamp%%&ask_summarization=1"},"isAdultDoc":false,"relatedParams":{"text":"Простой прогноз продаж в Excel с учетом сезонности","related_orig_text":"","related_porno":false,"related_short":true,"related_less_3m_off":true,"client":"d2d","no_cnt":1,"related_src":"serp","related":"{\"porno\":false,\"vfp\":1,\"orig_text\":\"\",\"url\":\"http:\\/\\/www.youtube.com\\/watch?v=r7acmsUU7ek\",\"src\":\"serp\",\"rvb\":\"EhQKEjE0NjQyNTk4ODIwMDkwNzg3NxoUChIxNDY0MjU5ODgyMDA5MDc4NzdaEjE0NjQyNTk4ODIwMDkwNzg3N2q9DBIBMBgAIkUaMQAKKmhoZmlveW5ic2R3bHh1cWNoaFVDS2JsVkM1aWN4TzRkVzdzeDZXNy1CdxICABIqEMIPDxoPPxPlCIIEJAGABCsqiwEQARp4gfH6_AcI9wAD_wYBDwb-AhYSDwf0AwIA9Aj7_v8C_wARBxT7BwEAAP4WCQwGAAAAAfD09wD9AQDcDQb6BAAAACwA_Ab7AP8A7_X4-wABAADv6gv9AwAAABEACfr_AAAAAAUE9fv_AAD_-wQLAAAAABUMAPoAAAAAIAAtBA-8OzgTQAlITlACKoQCEAAa8AF0N0r84s31AYEBOQEe47MCuAD8_xIn-ACIPwQAuf_lAaLS-gIgNfAA8Q3PAZD93gKjJbz-Bvu2ARL_Gv801ygA5sMOAVrtMgI9GqcCNTwOBNz3MPoy-gH_L9tCB0okKf1IxyT999PrArP64gAQ7y3_IzD7COPnOP_oyQAB3jDf__HdFP0t2wwJ_LvBAQogFv9JCBYFGETq_9rX9AfiDw0H_NPJCeuz_gEQJOL8AAvw-PodBf045fP_9WMCBNIL8e7tMwXyUfj4BiAc_gQHyhfwGN_-IhECFwBT9-wNoBkVAvYN-PzINvwGEyAH-BXL4vkgAC1mONk6OBNACUhhUAIqzwcQABrAByuE7b43C8U7s2y5u0S77zwN4Ti9-lKuOww3RT0Dm468XkLqvPDDgT6r-HW8rZ6IPSA1V73ntx490TqPPP7Viz4gxJ88hqkxOwlCuL27NZ89Q59ZPB5aOr0gx727iXirPHCKqD1o7p06KkAPvb5LWT6RHN07oHyLOitXw72dbF69-pQIvYzHiz0q0548j6zXvBbQNb3wxhu7towrOxQVO7sfpQ29AjeBPLgdj71e32I8Aac3vRlYF74VTRG9Lh1zPLt8a7xubpw9Sb6SPHcfNrwaEZE9HDoivGoarz3Ia5Q8EF2QPFq2Uboqz_K8nF7YvI0lEb04wZK9n7enPH7FCr5PIAy9okbfOyzlRj2GTa48Y1CeOyLKEr1kxgA7-1ksPDLMpL3Xxx69AmFpu3FwDj2VyuW8dKrGvJbFDj2BmZo9_8dPu2NgPT0PLsg9ffnuPEAlWD37VHy7RTHUPMg_87zFh6O8pc6tPCRVZT0mvp89D-lcPD4ytz25ncc8ymWnOC-v0ryg4vi8rSy0u7pOEz6WBr48PCEmuyQJZz0bJr-8l0xbukSxSz15XRy8_9YIu4vLnD2kF3q9X3hKvIqt4D2YBak9dcM-u9C0BD6w4tQ8ft0vO5m0zjwmHQU9A09Ou_xlgb2OoVI83-tavDJBKL0prJm9T4dCO-bSkzw3hgW9Dx9gO0267TxEHN45jfUqO-WE5Lwyh069Wa-7u50YbTvOoAo8b42Au2H_1b1GZ1Q9ATbZue6gaD0FnuC8piIZO5uiDT0waBw9IHe2OgVunb2ML1q9s68VOdnt87wXXBi9MtyzN5rHhj0AUya-BV1AOYCCpjxbUCm8eZWRuPTSHj0gNfe8AMJeOLE0UD1kM4E9TRQ0OQL0i71FNZC9O4YxOCIii71FSei9E8qnOBNE_T2OHh--JC2aOONMODw_FzI84v4ButrI9b0wJuI8D0vLOQkspb32UXw8hlkYOC8Ulb0rNBC9N-LTuH9ViTzsGog8PnTruYQNvz0rFt898w2it2oFXL1WvKw8xZrwtxCZrb14QF69K52zuGr0zbp8o1G97QPfOBmtQ70n4LI8Js6HOJHYKT1LBdW9UsIYOKkqWT3QFIA9fK6UOKofRb1j0A07hAgFODRH-7yysqc9HVT7N1Sicb0Ix5E9_BY8uGMzVj12UbS9P5udOK4aGj15czi7m1o4uNecaD3fETq9T2IZuDhK3j07ogc9FEp4OMW_mb1zOEk9XU7juGKCWr1bIGY9ZDW7N5hnSr1BFCc88kRMNyAAOBNACUhtUAEqcxAAGmACBwD5-BHWFSQV8gzwCzP-B-7UAPc1AP7BAAwzysoN_-0X2w8AKegp-7kAAAAQHtErqAAHXu_s_RX2FhXqntzp9n8e_zTUze_6COoNGSLioyPjExgAIhK1DSQGpfIjBQwgAC23TDM7OBNACUhvUAIwCTgBSgBSCQgPEJICGAAwAWAAaAA,\"}","related_url":"http://www.youtube.com/watch?v=r7acmsUU7ek","parent-reqid":"1754660873355442-17962862113667018032-balancer-l7leveler-kubr-yp-sas-216-BAL","related_vfp":1,"relatedVideo":"yes"},"cwidth":1280,"cheight":660,"cratio":1.93939,"dups":["146425988200907877"],"episode":0,"season":0,"isEmbedOnly":false,"greenHost":"YouTube","hasTranslation":false,"contentTypeId":null}},"dups":{"146425988200907877":{"videoId":"146425988200907877","title":"Простой прогноз продаж в Excel с учетом сезонности","cleanTitle":"Простой прогноз продаж в Excel с учетом сезонности","host":{"title":"YouTube","href":"http://www.youtube.com/v/r7acmsUU7ek","playerUri":"\u003ciframe src=\"//www.youtube.com/embed/r7acmsUU7ek?enablejsapi=1&wmode=opaque\" frameborder=\"0\" scrolling=\"no\" allowfullscreen=\"1\" allow=\"autoplay; fullscreen; accelerometer; gyroscope; picture-in-picture\" aria-label=\"Video\">\u003c/iframe>","playerId":"youtube","providerName":"youtube.com","sourceHost":"www.youtube.com","name":"youtube.com","secondPart":{"type":"CHANNEL","id":"d3d3LnlvdXR1YmUuY29tO1VDS2JsVkM1aWN4TzRkVzdzeDZXNy1Cdw==","name":"Дмитрий Щербаков","isVerified":false,"subscribersCount":0,"url":"/video/search?channelId=d3d3LnlvdXR1YmUuY29tO1VDS2JsVkM1aWN4TzRkVzdzeDZXNy1Cdw%3D%3D&how=tm&text=%D0%94%D0%BC%D0%B8%D1%82%D1%80%D0%B8%D0%B9+%D0%A9%D0%B5%D1%80%D0%B1%D0%B0%D0%BA%D0%BE%D0%B2","origUrl":"http://www.youtube.com/@excel-vba_ru","a11yText":"Дмитрий Щербаков. "},"faviconUrl":"//favicon.yandex.net/favicon/v2/http%3A%2F%2Fyoutube.com?color=255%2C255%2C255%2C0&size=32&stub=1"},"duration":{"value":1125,"text":"18:45","a11yText":"Длительность 18 минут 45 секунд"},"views":{"text":"203,5K","shouldShowInSnippet":true,"a11yText":"203,5 тысяч просмотров"},"date":"23 мар 2017","modifyTime":1490252400000,"isExternal":false,"shouldShowQuasar":false,"player":{"embedUrl":"https://www.youtube.com/embed/r7acmsUU7ek?autoplay=1&enablejsapi=1&wmode=opaque","playerId":"youtube","videoUrl":"http://www.youtube.com/watch?v=r7acmsUU7ek","reqid":"1754660873355442-17962862113667018032-balancer-l7leveler-kubr-yp-sas-216-BAL","duration":1125},"parentClipId":"146425988200907877","href":"/preview/146425988200907877?parent-reqid=1754660873355442-17962862113667018032-balancer-l7leveler-kubr-yp-sas-216-BAL","rawHref":"/video/preview/146425988200907877?parent-reqid=1754660873355442-17962862113667018032-balancer-l7leveler-kubr-yp-sas-216-BAL","isEmbedOnly":false,"shouldPlayInstreamPreroll":false}},"loadingStatus":"None"},"internal":{"videoId":"146425988200907877","sandboxEventPrefix":"sandbox:","sandboxVersion":"0xe4bf0db8254","isHermione":false,"isEmbedded":false,"from":"yavideo","service":"ya-video","hbPeriod":30,"table":"video_tech","isInstreamDisabled":true,"nonce":"9628621136670180327216","errorList":[],"isAdultAdv":false,"isImportantCommonAdv":false,"shouldShowAdvId":false,"advConfig":{"under-player":{"regular":{"default":"R-I-48058-725","mail":"R-A-13411721-6"},"adult":{"default":"R-I-474674-114","mail":"R-A-13426421-6"}},"under-player-lite":{"regular":{"default":"R-I-48058-728"},"adult":{"default":"R-I-474674-103"}},"under-player-old":{"regular":{"default":"R-I-48058-725","mail":"R-A-13411721-6"},"adult":{"default":"R-I-474674-114","mail":"R-A-13426421-6"}},"video-list":{"regular":{"default":"R-I-48058-708","mail":"R-A-13411721-2"},"adult":{"default":"R-I-474674-101","mail":"R-A-13426421-2"}},"search-list":{"regular":{"default":"R-I-48058-715","mail":"R-A-13411721-3"},"adult":{"default":"R-I-474674-108","mail":"R-A-13426421-3"}},"search-grid-row":{"regular":{"default":"R-I-48058-718","mail":"R-A-13411721-4"},"adult":{"default":"R-I-474674-109","mail":"R-A-13426421-4"}},"search-grid-head":{"regular":{"default":"R-I-2120168-7"}},"search-list-right":{"regular":{"default":"R-I-8843654-1"}},"before-player-old":{"regular":{"default":"R-I-2120168-1"}},"before-player":{"regular":{"default":"R-I-2120168-1"}}},"shouldValidateSandbox":false,"sandboxInitTimeout":15000,"isSSROnlyMastheadEnabled":true,"queryUriEscaped":"videoid%3A146425988200907877","filterMode":1,"isUserChild":false,"advInstreamConfig":{"regular":{"default":{"category":"2","impId":"7","partnerId":"2216089","vmapScenarioId":"119"}},"adult":{"default":{"category":"3","impId":"4","partnerId":"1988486","vmapScenarioId":"119"}}}},"playbackQueue":{"currentIndex":0,"items":[{"type":"VIDEO","videoId":"146425988200907877","source":"serp","selectEvent":"click"}]},"related":{"items":[],"pages":[],"loadingStatus":"None","nextPageNum":0,"ncrnd":0},"playlist":{"items":{}}}}