Консолидация в Excel. Как собрать сводные данные со всех листов. Урок для начинающих бесплатно — Видео от Biba.pro - Аналитика для бизнеса
{"pages":{"search":{"query":"videoid:785085971065350118","originalQuery":"","serpid":"1782268054370172-11784945217864102418-balancer-l7leveler-kubr-yp-sas-159-BAL","reqid":"1782268054370172-11784945217864102418-balancer-l7leveler-kubr-yp-sas-159-BAL","parentReqid":"","serpItems":[{"id":"785085971065350118-0-0","type":"videoSnippet","props":{"videoId":"785085971065350118"},"curPage":0},{"id":"R-I-249064-1-0-1","type":"direct","props":{"advRsyaActivateParams":{"pcodeParams":{"blockId":"","renderTo":"","pageNumber":1,"grab":"dHZpZGVvaWQ6Nzg1MDg1OTcxMDY1MzUwMTE4Cg==","statId":1,"lazyLoad":false,"extParams":{"reqid":"1782268054370172-11784945217864102418-balancer-l7leveler-kubr-yp-sas-159-BAL","ui":"desktop","yuid":"1280201961782268042"}}},"isAdult":false,"position":1,"placement":"empty"},"curPage":0},{"id":"R-I-249064-1-0-2","type":"direct","props":{"advRsyaActivateParams":{"pcodeParams":{"blockId":"","renderTo":"","pageNumber":2,"grab":"dHZpZGVvaWQ6Nzg1MDg1OTcxMDY1MzUwMTE4Cg==","statId":2,"lazyLoad":false,"extParams":{"reqid":"1782268054370172-11784945217864102418-balancer-l7leveler-kubr-yp-sas-159-BAL","ui":"desktop","yuid":"1280201961782268042"}}},"isAdult":false,"position":2,"placement":"empty"},"curPage":0},{"id":"R-I-249064-1-0-3","type":"direct","props":{"advRsyaActivateParams":{"pcodeParams":{"blockId":"","renderTo":"","pageNumber":3,"grab":"dHZpZGVvaWQ6Nzg1MDg1OTcxMDY1MzUwMTE4Cg==","statId":3,"lazyLoad":false,"extParams":{"reqid":"1782268054370172-11784945217864102418-balancer-l7leveler-kubr-yp-sas-159-BAL","ui":"desktop","yuid":"1280201961782268042"}}},"isAdult":false,"position":3,"placement":"empty"},"curPage":0}],"searchAds":[],"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%3A785085971065350118","logNode":{"name":"link","attrs":{"type":"google"}},"target":"_blank"},{"label":"Bing","url":"//bing.com/videos?scope=video&q=videoid%3A785085971065350118","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,"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":"dHZpZGVvaWQ6Nzg1MDg1OTcxMDY1MzUwMTE4Cg==","lazyLoad":false,"extParams":{"reqid":"1782268054370172-11784945217864102418-balancer-l7leveler-kubr-yp-sas-159-BAL","ui":"desktop","yuid":"1280201961782268042"}}},"isAdult":false,"position":0,"placement":"search-list-right"},"curPage":0}],"isAdultQuery":false,"errorList":[],"layout":"list","retpath":"https%3A%2F%2Fyandex.kz%2Fvideo%2Fpreview%2F785085971065350118","pages":[{"reqid":"1782268054370172-11784945217864102418-balancer-l7leveler-kubr-yp-sas-159-BAL","start":0,"end":4,"pageNumber":0,"isCounterSent":false}]},"main":{"_isInitial":true,"snippets":[],"serpFooter":{"linksGroups":[]},"isLoggedIn":false,"tags":[]},"favs":{"_isInitial":true,"items":[],"cacheHash":"","showMoreUrl":"","initialViewportWidth":0}},"internal":{"nonce":"7849452178641024187159","expFlags":{"video_settings_toolbar_redesign":1,"velocity_delay_drawer":1,"video_feedback_in_d2d":1,"video_search_toggle_with_text":1,"video_viewer_show_placeholder":1,"video_adv_search_right_enable_adult":1,"velocity_disable_suspense":1,"video_viewer_desktop_smart_layout":1,"dark_theme_desktop":"cookie","video_viewer_check_sandbox_origin":1,"video_font_yandex_sans":1,"video_adv_new_show_rules":1,"video_adv_config_desktop":{"search-list-right":{"adult":{"default":"R-I-19214552-1"},"regular":{"default":"R-I-8843654-1"}},"search-list":{"adult":{"default":"R-I-474674-135","mail":"R-A-13426421-23"},"regular":{"default":"R-I-48058-751","mail":"R-A-13411721-23"}},"before-player":{"adult":{"default":"R-I-19178478-1"},"regular":{"default":"R-I-2120168-1"}}},"video_search_page_no_islands":1,"video_vh_player_js":0,"video_masthead_ratio":"180,4","video_viewer_related_fail_error_screen":1,"video_viewer_channel_link_mode":2,"mmui_extended_escape_scheme":"searchdata.clips.0.authorname","video_viewer_restore_mute_state":1,"spok":"id","video_suggest_use_serp":1,"video_search_grid_direct_repeat":6,"init_meta":{"enable-yabs-distr":1,"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,"disable_rtmr_fresh":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,"bg-bert-video":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_viewer_comments_auth_popup":1,"video_comments_timestamps":1,"video_depot_viewer_masthead_ssr_only":1,"video_kebab_advanced_actions":1,"video_search_grid_enable":0,"video_viewer_desktop_fix_d2d_scroll":1,"video_depot_viewer_legacy_counters":1,"video_search_grid_direct_start":3,"video_adv_new_show_rules_docs_count":1,"video_redirect_plug":2,"dark_theme_desktop_default_pref":"system","video_search_toggle_enable":1,"velocity_split_hydration":4,"video_duration_counter_new_format":1,"video_force_grid_on_premordie":1,"video_enable_adult_masthead":0,"video_morda_header_nav":1,"video_nohost_full_filter":0,"video_baobab_blockstat":1,"video_nohost_youtube_filter":0,"video_viewer_host_link_mode":1,"video_comments_smart_nonstop":1},"slots":["1595591,0,6;151171,0,47;126309,0,29;1602402,0,88;1281084,0,98;1588328,0,93;1579951,0,32;1602027,0,8;287509,0,71;1231501,0,82;1605614,0,15;1583199,0,97;1607438,0,22;912281,0,99"],"isYandexNet":false,"platform":"desktop","isEnLogo":false,"retpath":"https%3A%2F%2Fyandex.kz%2Fvideo%2Fpreview%2F785085971065350118","mordaUrl":"//yandex.kz/","videoSearchUrl":"https://yandex.kz/video/search?text=%D0%9A%D0%BE%D0%BD%D1%81%D0%BE%D0%BB%D0%B8%D0%B4%D0%B0%D1%86%D0%B8%D1%8F+%D0%B2+Excel.++%D0%9A%D0%B0%D0%BA+%D1%81%D0%BE%D0%B1%D1%80%D0%B0%D1%82%D1%8C+%D1%81%D0%B2%D0%BE%D0%B4%D0%BD%D1%8B%D0%B5+%D0%B4%D0%B0%D0%BD%D0%BD%D1%8B%D0%B5+%D1%81%D0%BE+%D0%B2%D1%81%D0%B5%D1%85+%D0%BB%D0%B8%D1%81%D1%82%D0%BE%D0%B2.++%D0%A3%D1%80%D0%BE%D0%BA+%D0%B4%D0%BB%D1%8F+%D0%BD%D0%B0%D1%87%D0%B8%D0%BD%D0%B0%D1%8E%D1%89%D0%B8%D1%85+%D0%B1%D0%B5%D1%81%D0%BF%D0%BB%D0%B0%D1%82%D0%BD%D0%BE+%E2%80%94+%D0%92%D0%B8%D0%B4%D0%B5%D0%BE+%D0%BE%D1%82+Biba.pro+-+%D0%90%D0%BD%D0%B0%D0%BB%D0%B8%D1%82%D0%B8%D0%BA%D0%B0+%D0%B4%D0%BB%D1%8F+%D0%B1%D0%B8%D0%B7%D0%BD%D0%B5%D1%81%D0%B0","querySource":"title","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":"1782268054370172-11784945217864102418-balancer-l7leveler-kubr-yp-sas-159-BAL","backUrl":"//ya.ru","url":"https://yandex.kz/video/preview/785085971065350118?","isIntegrationTest":false,"isEndToEndTest":false,"shouldDropLogs":false,"seo":{"title":"Консолидация в Excel. Как собрать сводные данные со всех листов. Урок для начинающих бесплатно — Видео от Biba.pro - Аналитика для бизнеса - Смотреть онлайн в поиске Яндекса по Видео","description":"","keywords":"","shareTitle":""},"isEmbedded":false,"isPumpkin":false,"sessionCsrfToken":"y34c88b4d4ba387b46a7b68735d9fa6d1","reportFeedbackBaseProps":{"initEmail":"","metaFields":{"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","userTestids":"1595591,151171,126309,1602402,1281084,1588328,1579951,1602027,287509,1231501,1605614,1583199,1607438,912281","queryText":"","reqid":"1782268054370172-11784945217864102418-balancer-l7leveler-kubr-yp-sas-159-BAL","userRegionName":"","userRegionId":"id() {\n var _a;\n return (_a = this._region.id) !== null && _a !== void 0 ? _a : 213;\n }","yandexuid":"1280201961782268042","uid":"0","isChildAccount":false}},"userTestids":"191768,238743,246500,253288,265553,270072,277807,274239,294077,278842,331010,338398,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,1060131,1071879,1078818,1077703,1116602,1045814,1131637,1144233,1151726,1156933,1174275,1167408,1202006,1194718,1221235,1228280,1226860,1246754,1313283,1321224,1300570,1320679,1352408,1342688,1341968,1345362,1367583,1348424,1382036,1391511,1384451,1402882,1417605,1424780,1429092,1438908,1444206,1449283,1452713,1457995,1459585,1461130,1492788,1495633,1511916,1514845,1535081,1540074,1545808,1582671,1592017,1601754,1594749,1595431,1605379,1608549,1609735,1299604","regionId":20815,"isYaRu":false,"shouldUnmountSearchPageInViewer":false,"videoGlobalContext":{"platform":"desktop","isPumpkin":false,"language":"ru","user_time":{"epoch":"1782268054","tz":"America/Louisville","to_iso":"2026-06-23T22:27:34-0400","__is_plain":1},"isHermione":false,"shouldStubImages":true,"enableVideoPreviewInHermione":false,"reqid":"1782268054370172-11784945217864102418-balancer-l7leveler-kubr-yp-sas-159-BAL","isEmbedded":false,"shouldShowMainPageButtonInViewer":false,"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":"1595591,151171,126309,1602402,1281084,1588328,1579951,1602027,287509,1231501,1605614,1583199,1607438,912281","queryText":"","reqid":"1782268054370172-11784945217864102418-balancer-l7leveler-kubr-yp-sas-159-BAL","userRegionName":"","userRegionId":"id() {\n var _a;\n return (_a = this._region.id) !== null && _a !== void 0 ? _a : 213;\n }","yandexuid":"1280201961782268042","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":"7849452178641024187159","disableDoc2DocHostLink":false,"shouldHideChannelLink":false,"disableChannelLink":false,"userConnectionRtt":155,"animated":false,"isDoc2DocScrollFix":true,"smartDesktopLayout":true,"smartFitComments":false,"enableVIImprovements":false,"enableLazyPoster":false,"isAdvDisabled":false,"isVideoTranslationSupported":false,"isSummaryOnlineEnabled":false,"shouldRenderBroSummaryApiContainer":false,"summaryBroApiDisabledSnippetSurfaces":[],"summaryBroApiSquareSurfaces":[],"shouldDropLogs":false,"shouldUseBeacon":false,"hasAdBlock":false,"rknWarnHosts":[""],"postInstreamScreenDuration":2000,"minVideoDurationForInstream":120,"isInstreamEnabledInTesting":false,"wildcard":false,"disableEarlyEventsUnsubscribe":false,"showDebugRelatedURL":false,"shouldUseBetaErrorLogging":false,"shouldShowMetaUnderPlayer":false,"isVideoViewerMetaTitleHidden":false,"headerNoFavicon":false,"headerBranded":false,"shouldCensorSensitiveContent":false,"shouldCensorShockContent":false,"isAdvUnderPlayerTransparent":false,"isDoc2DocGridLayoutEnabled":false,"isWatchingProgressEnabled":false,"detailsRedesignV3Enabled":false,"isD2DEmptyLoadFixDisabled":false,"isRoundedPlayerEnabled":false,"isSettingsToolbarRedesign":true,"isDoc2DocEmptyRetryEnabled":false,"isDoc2DocErrorScreenEnabled":true,"isDoc2DocFeedbackKebabEnabled":true,"isCommentsEnabled":false,"isCommentsTimestampsEnabled":true,"isCommentsCountOnSnippetsEnabled":false,"isCommentsSmartNonStopEnabled":true,"isCommentsOnboardingEnabledInTesting":false,"commentsOnboardingTextVariant":null,"isVideoMainButtonInitiallyCollapsed":false,"isAdvUnderPlayerWithInnerPadding":false,"isKebabAdvancedActionsEnabled":true,"isKebabOnTouchVideoSearchEnabled":false,"isAdvVideoListLikeUnderPlayer":false,"isSummaryInMetaButtons":false,"isSummaryInMetaButtonsDesktop":false,"isMetaCommentsButtonEnabled":false,"isMetaFavoritesButtonEnabled":false,"isCommentsAuthPopup":true,"preventAdvHideOnEmpty":false,"isSmallTitle":false,"shouldRestoreMuteState":true,"isAdvUnderPlayerWithSlider":false,"isAdvUnderPlayerCommentsAligned":false,"isSerialNavigatorDisabled":false,"isEarlyAdvRenderEnabled":false,"isViewerErrorFallbackEnabled":false,"isPlayerErrorCloseButtonEnabled":false,"videoChangedRedirectPlayerIds":[]},"shouldShowAdvId":false,"isAdultQuery":false,"isSensitivePage":false,"showSensitive":false,"showShock":false,"shouldReplaceHref":false},"user":{"tld":"kz","isEuDomain":false,"login":"","passportId":"","isLoggedIn":false,"locationName":"Колумбус","isFamily":false,"yandexuid":"1280201961782268042","ugcCsrfToken":"","family":1,"isChild":false},"config":{"skinMode":"system","skin":"light","version":"releases-frontend-video-v1.1851.0__39fae0d9da134f16b944e084c7e63095d5677388","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":{"adult":{"default":"R-I-474674-135","mail":"R-A-13426421-23"},"regular":{"default":"R-I-48058-751","mail":"R-A-13411721-23"}},"search-grid-inplace":{"regular":{"default":"R-I-48058-742","mail":"R-A-13411721-16"},"adult":{"default":"R-I-474674-126","mail":"R-A-13426421-16"}},"search-grid-head":{"regular":{"default":"R-I-2120168-7"}},"search-list-right":{"adult":{"default":"R-I-19214552-1"},"regular":{"default":"R-I-8843654-1"}},"before-player-old":{"regular":{"default":"R-I-2120168-1"}},"before-player":{"adult":{"default":"R-I-19178478-1"},"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","request_entry_completed":"2021","serp":"471","page":"143","loaded":"1007"}},"clips":{"items":{"785085971065350118":{"videoId":"785085971065350118","docid":"34-11-16-ZFF675AC565CB42CD","description":"","preview":{"posterSrc":"//avatars.mds.yandex.net/get-vthumb/1344990/7eeb91b91a8273e900a13e8963116b32/564x318_1","videoSrc":"https://video-preview.s3.yandex.net/GGxzXwIAAAA.mp4","videoType":"video/mp4"},"target":"_self","position":"0","reqid":"1782268054370172-11784945217864102418-balancer-l7leveler-kubr-yp-sas-159-BAL","summary":{"isFull":true,"fullTextUrl":"/video/result?ask_summarization=1&numdoc=1&noreask=1&nomisspell=1&parent-reqid=1782268054370172-11784945217864102418-balancer-l7leveler-kubr-yp-sas-159-BAL&text=videoid:785085971065350118","teaser":[{"list":{"type":"unordered","items":["В видео рассказывается о том, как в Excel можно консолидировать данные из разных вкладок и объектов в один отчет.","Приводится пример с данными по продажам товара в трех городах, которые хранятся на разных вкладках."]},"endTime":98,"title":"Консолидация данных в Excel","beginTime":0},{"list":{"type":"unordered","items":["Выделяется ячейка для консолидированного отчета и выбирается кнопка \"Консолидация\" на вкладке \"Данные\".","Выбирается операция суммирования или определения среднего значения для консолидации данных.","Затем выбираются диапазоны данных, которые нужно консолидировать, и ставятся галочки для подписи верхней строки и значения левого столбца."]},"endTime":209,"title":"Создание консолидированного отчета","beginTime":98},{"list":{"type":"unordered","items":["В консолидированном отчете данные не обновляются автоматически, но их можно обновить вручную, щелкнув на ячейку и выбрав \"Консолидация\".","Если данные в консолидированном отчете были изменены, то их можно обновить, нажав \"ОК\".","В целом, консолидация данных в Excel удобна и экономит время, но данные в консолидированном отчете не обновляются автоматически."]},"endTime":283,"title":"Обновление данных в консолидированном отчете","beginTime":209}],"linkTemplate":"/video/preview/785085971065350118?parent-reqid=1782268054370172-11784945217864102418-balancer-l7leveler-kubr-yp-sas-159-BAL&t=%%timestamp%%&ask_summarization=1"},"isAdultDoc":false,"relatedParams":{"text":"Консолидация в Excel. Как собрать сводные данные со всех листов. Урок для начинающих бесплатно — Видео от Biba.pro - Аналитика для бизнеса","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:\\/\\/vk.com\\/video-198294588_456239187\",\"src\":\"serp\",\"rvb\":\"EhQKEjc4NTA4NTk3MTA2NTM1MDExOBoUChI3ODUwODU5NzEwNjUzNTAxMThaEjc4NTA4NTk3MTA2NTM1MDExOGqHFxIBMBgAIkQaKAAKIWhodGFya3l3eXJzaHF3aGNoaHB1YmxpYzE5ODI5NDU4OBICABIqGMIPDxoPPxObAowEIAAKP-tIggQkAYAEKyqLARABGniBBPwD7BXl__rz_vb8AwABPwsFB_AJCQH9Awvs-wf9ABYDAvsSAQAA9wXsDAoAAAD89eH-_vwAAN7y-fADAAAANgD7CPkA_wDnD_gD_wEAAOXsBvACAAAAARAM9v8AAAAHA-3uAAD_ASPxBAEBAAAAGg__-QAAAAAgAC0ebpY7OBNACUhOUAIqhAIQABrwAXgcZP723rEEhh_6AOau1wGB9A8AOBj-AawyEwG5_-UBmb0UAvci1ADR_sIAgf31Adf72P769OIBPAYaAEmzDwH3yfcAdvX1ACAt2gEiE_4ABiIf_TXCGwAsxiICOBAA-yzXKf_-5fwAq_e7ART9VAL2MvcD-hkdAP_EDAelSRgCAfzn_fXZFAMG0-UJEhsEEBn-FgopQSAA-_n4CgAX7w7MEd7-_ND59EoM7fkqF_4N_uwNCiby3fXQHBIT5jnyC-4_9wBBKwoHIBz-BPGuBPMeE_4LNh3-8i0E3QjTOgn-AwUSB7AJDuwu6RT66d8F8yAALfj-2jo4E0AJSGFQAirPBxAAGsAH6rDqvtrSPLv4lxM9_RwZPCu6mrw7M2I7wsqXPHF2RjwrDSa9JH9QPmNG-Lz-Q5o9eV3_vQVuXbynSQA83SefPhnrdj2UDZA8Ghu1vazOxT394_e7TQsDvdyVwry3e_k8I2XwPMzU_zwrvVu8k28GPm-wIT2ckA68VWd1vddEsL0_LVA8jMeLPSrTnjyPrNe8G8lUvJ_xM7y5cB48-ERoPb3Dbbze2747KBkvvaxgCr2F5p-8l1JXvp-jwDq2v848u3xrvG5unD1JvpI8FbOYOyxnaj3GljS9O5ORPULrH7tmY0o8aOauPL9mNL0OMgS9l1PCvKl2vLzN3848IowPvnU5ar1xRoO8LOVGPYZNrjxjUJ47u33WvZ-HJL35HXk8u7EFva4scb2Pt4W6VuupPGhxazww5wK86O6EvMclcz3pri06Y2A9PQ8uyD19-e48KcEsPBtMQznNJ4I71QykvVIXvrhUSa48ids3PVF3VD2bjww8aVfMPaYTJD1tKws81OICPVuNtryYkAe8uk4TPpYGvjw8ISa7JEYPPao7gL1NdA67D_CUPeAwUbzyw9I7wIXrPKUEo7290kc7jszjPZWC7j1dve26FvjqPe9fjzwz2uw6QzSfvAoDAD0JFSC7_GWBvY6hUjzf61q8WCRhvWdBbb3WSL87TgJlvPCsiL349cc64r8qvY1tyDwg8OG6FhjSvVrfdrwB1x66aft8vIPGp7z7uOy6LPHgvS5w_bsgJxg6pFRCPelmWjwt3gO6JrJFPaPOnDwuJUM5ROySvZmvHL1kz8q4XvhcvY2CuzymwVo3ZGyyPFwD273gpBS5sqs_va_IVL1zrj639iOFvNpIKL0nuY45ylOWPJOHqjwSrwA6Ux6SvUobyL3hc5s3-yRSvN7BWb0NcjY3Fwd8PUJ2Hr6jYIw3JYgkPRZdjTzYNeU409wKvuf6oz2ufMk5sa6VvcAzKz1IgL43RGuVvWnjqL2C5EE3STR8Pcb8PL2C5IM4MzR-PU-Wej21das3BfN8vbtxfzsQW8y38Ugsvvf_xr2JXA24PkxxvfUpbLwZ4iM4oK5pPXP3OTy-3jq4davHPYkvrr1QCDI5xmwpPdVyDD2bmYk3QYNJu6EOMD2924Q4WshNvandDz0WWIK4tDhIvTtwLj2rfWA3ZhK1PF6hz72AurI33DRRPXmxsDxQnqo3x6ADPmCNeL0XyFo4hGKLPTI4yjwga4M4AEg3u3dVNj0-ld24-zcUvYnONz2vDY-30RCUvegYS71GaAa4IAA4E0AJSG1QASpzEAAaYPv-ADb--bIDGCrhKc5HHujytuL4rGT_09wAHDsJvBr42gTm4ADv6BEtowAAACVE-yvZAC91BA4O_uMtNeK4zAMTfxgQQaSvrv7V6jYkLNuGIe7_GgAD9sHxQRex0BgJBCAALeDkDzs4E0AJSG9QAiqvBhAMGqAGAABgQQAAkMEAANhBAAC6QgAAGMIAAMBBAADoQQAAYMEAAAjCAADgwAAA1kIAAADBAAAUQgAAEEEAANBBAAAAwAAAYEEAAKjBAADgQAAAgEEAAI5CAAAQQQAACMIAAMhBAAAMwgAALEIAABjCAAAQwgAAPEIAAHDBAACAPwAAsEEAAGzCAAAQQgAAwEAAABBCAACawgAAqkIAAChCAACAQQAAusIAAJBCAAB8QgAA-MEAAJrCAADAQQAAQMEAAODAAADwwQAAGEIAAIA_AABUwgAAoMEAAKBBAAAkQgAAWEIAAADCAAAowgAAwkIAADRCAAAQwQAAqEEAAIjBAAAEwgAA4EAAAIjBAAAUQgAAMMIAAJbCAADAQAAAhEIAAEBCAAC4wQAAYEEAALDBAAAowgAAyMEAAJBBAADAwAAAAEAAANjBAAAwQgAATMIAACBCAABAwgAAKEIAAATCAAAAQgAAGMIAAOBAAAAgwgAAqMEAAJDCAAAowgAAgL8AAOzCAACQwQAAYEIAADhCAAAQwQAAgEEAALhBAACAwAAAKEIAAETCAAAYQgAAMEEAAKJCAAA8QgAAkkIAAChCAADwwQAA4MEAAEBCAAAUQgAAQMEAAFBBAAAswgAAFEIAAGzCAABwQQAA4MAAACBBAAAowgAAuEEAAJjBAACUQgAAKMIAAIjCAACAvwAAQEAAANDBAAAMwgAAsMEAANjBAAAYQgAAQEIAACDBAACkwgAAWMIAAAhCAAAMwgAA4EAAAEBAAABgQQAA8EEAAPjBAAB4QgAADEIAAABBAAAAQAAA4MAAAIBBAACAwgAA4MEAAIjBAACGwgAAwMEAALhBAADEQgAAMMEAACxCAACgQAAAqMEAAADAAACwQQAAgEAAALhBAABgQQAAQMEAAGTCAAAwQQAAMEIAAKDBAAA8wgAA4EEAAAjCAAA4wgAALEIAAGBCAADQwQAAlkIAAJjBAACAQAAAJMIAADjCAACYwQAAoMAAAJhBAAAgQQAAuEEAAAxCAADAwQAAUEEAABBBAACwQQAAcMEAACxCAADgQAAAwEAgADgTQAlIdVABKo8CEAAagAIAAJa-AABsvgAA2D0AAN4-AADIvQAABL4AAK4-AADyvgAADD4AALK-AAC6vgAAdL4AAOA8AADqvgAAvj4AADA9AACYvQAALD4AAIg9AABRPwAAKz8AAK4-AACWvgAABz8AAKK-AAAQvQAApj4AAEC8AAD4vQAAhr4AAFw-AAAcvgAAXD4AADS-AAD4vQAACz8AAEA8AAA8vgAAbL4AAFw-AADyvgAAmL0AAAu_AAAkvgAAoLwAAFy-AACWPgAAXL4AADy-AACuvgAA-L0AAKi9AACgPAAAXD4AAKI-AACAOwAAfz8AACw-AADovQAA6D0AAIi9AAAQvQAAuL0AADk_IAA4E0AJSHxQASqPAhABGoACAAA0PgAAcL0AAKi9AAAdvwAAsr4AAGQ-AAA0PgAAcL0AAIi9AACmPgAAyr4AAOA8AABsvgAAoLwAAIi9AABQPQAAgDsAAAM_AAAQvQAAKT8AAIi9AACoPQAA4r4AAFC9AACovQAAXL4AAFw-AABAvAAAXL4AAGQ-AABAPAAAEL0AABw-AACSvgAAEL0AAI4-AABAPAAAUD0AACy-AACIPQAAuD0AAFw-AAAEvgAAUD0AABS-AABEvgAAf78AAIA7AABEPgAAgDsAAEC8AAAQPQAAjr4AAOA8AACiPgAADD4AAIi9AADIPQAAqL0AAMg9AADgvAAAwj4AAGQ-AABQvSAAOBNACUh8UAEwCTgBSgBgAGgA\"}","related_url":"http://vk.com/video-198294588_456239187","parent-reqid":"1782268054370172-11784945217864102418-balancer-l7leveler-kubr-yp-sas-159-BAL","related_vfp":1,"relatedVideo":"yes"},"cwidth":1920,"cheight":1080,"cratio":1.77777,"dups":["785085971065350118"],"episode":0,"season":0,"isEmbedOnly":false,"greenHost":"VK Video","hasTranslation":false,"contentTypeId":null,"censored":false,"censoredShock":false,"isShockDoc":false,"videoContentId":"77100259","isLiked":0}},"dups":{"785085971065350118":{"videoId":"785085971065350118","title":"Консолидация в Excel. Как собрать сводные данные со всех листов. Урок для начинающих бесплатно — В...","cleanTitle":"Консолидация в Excel. Как собрать сводные данные со всех листов. Урок для начинающих бесплатно — Видео от Biba.pro - Аналитика для бизнеса","host":{"title":"VK Video","href":"http://vk.com/video-198294588_456239187","playerUri":"\u003ciframe src=\"//vk.com/video_ext.php?hash=85184ddd9cddeb3c&id=456239187&loop=0&oid=-198294588\" frameborder=\"0\" scrolling=\"no\" allowfullscreen=\"1\" allow=\"autoplay; fullscreen; accelerometer; gyroscope; picture-in-picture\" aria-label=\"Video\">\u003c/iframe>","playerId":"vk","providerName":"vk.com","sourceHost":"vk.com","name":"vk.com","secondPart":{"type":"CHANNEL","id":"dmsuY29tO3B1YmxpYzE5ODI5NDU4OA==","name":"Biba.pro - Аналитика для бизнеса","isVerified":false,"subscribersCount":0,"url":"/video/search?text=Biba.pro+-+%D0%90%D0%BD%D0%B0%D0%BB%D0%B8%D1%82%D0%B8%D0%BA%D0%B0+%D0%B4%D0%BB%D1%8F+%D0%B1%D0%B8%D0%B7%D0%BD%D0%B5%D1%81%D0%B0&q_source=channel","a11yText":"Biba.pro - Аналитика для бизнеса. "},"faviconUrl":"//favicon.yandex.net/favicon/v2/https%3A%2F%2Fvk.com%2Fvideo?color=255%2C255%2C255%2C0&size=32&stub=1"},"duration":{"value":283,"text":"4:43","a11yText":"Длительность 4 минуты 43 секунды","shortText":"4 мин"},"views":{"text":"9,9K","a11yText":"9,9 тысяч просмотров"},"date":"17 дек 2024","modifyTime":1734423490000,"isExternal":false,"player":{"embedUrl":"https://vk.com/video_ext.php?autoplay=1&hash=85184ddd9cddeb3c&id=456239187&loop=0&oid=-198294588","playerId":"vk","videoUrl":"http://vk.com/video-198294588_456239187","reqid":"1782268054370172-11784945217864102418-balancer-l7leveler-kubr-yp-sas-159-BAL","duration":283},"parentClipId":"785085971065350118","href":"/preview/785085971065350118?parent-reqid=1782268054370172-11784945217864102418-balancer-l7leveler-kubr-yp-sas-159-BAL","rawHref":"/video/preview/785085971065350118?parent-reqid=1782268054370172-11784945217864102418-balancer-l7leveler-kubr-yp-sas-159-BAL","isEmbedOnly":false,"shouldPlayInstreamPreroll":false,"commentsDisabled":false,"reactionsDisabled":false}}},"viewer":{"_isInitial":false,"clips":{"items":{"785085971065350118":{"videoId":"785085971065350118","docid":"34-11-16-ZFF675AC565CB42CD","description":"","preview":{"posterSrc":"//avatars.mds.yandex.net/get-vthumb/1344990/7eeb91b91a8273e900a13e8963116b32/564x318_1","videoSrc":"https://video-preview.s3.yandex.net/GGxzXwIAAAA.mp4","videoType":"video/mp4"},"target":"_self","position":"0","reqid":"1782268054370172-11784945217864102418-balancer-l7leveler-kubr-yp-sas-159-BAL","summary":{"isFull":true,"fullTextUrl":"/video/result?ask_summarization=1&numdoc=1&noreask=1&nomisspell=1&parent-reqid=1782268054370172-11784945217864102418-balancer-l7leveler-kubr-yp-sas-159-BAL&text=videoid:785085971065350118","teaser":[{"list":{"type":"unordered","items":["В видео рассказывается о том, как в Excel можно консолидировать данные из разных вкладок и объектов в один отчет.","Приводится пример с данными по продажам товара в трех городах, которые хранятся на разных вкладках."]},"endTime":98,"title":"Консолидация данных в Excel","beginTime":0},{"list":{"type":"unordered","items":["Выделяется ячейка для консолидированного отчета и выбирается кнопка \"Консолидация\" на вкладке \"Данные\".","Выбирается операция суммирования или определения среднего значения для консолидации данных.","Затем выбираются диапазоны данных, которые нужно консолидировать, и ставятся галочки для подписи верхней строки и значения левого столбца."]},"endTime":209,"title":"Создание консолидированного отчета","beginTime":98},{"list":{"type":"unordered","items":["В консолидированном отчете данные не обновляются автоматически, но их можно обновить вручную, щелкнув на ячейку и выбрав \"Консолидация\".","Если данные в консолидированном отчете были изменены, то их можно обновить, нажав \"ОК\".","В целом, консолидация данных в Excel удобна и экономит время, но данные в консолидированном отчете не обновляются автоматически."]},"endTime":283,"title":"Обновление данных в консолидированном отчете","beginTime":209}],"linkTemplate":"/video/preview/785085971065350118?parent-reqid=1782268054370172-11784945217864102418-balancer-l7leveler-kubr-yp-sas-159-BAL&t=%%timestamp%%&ask_summarization=1"},"isAdultDoc":false,"relatedParams":{"text":"Консолидация в Excel. Как собрать сводные данные со всех листов. Урок для начинающих бесплатно — Видео от Biba.pro - Аналитика для бизнеса","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:\\/\\/vk.com\\/video-198294588_456239187\",\"src\":\"serp\",\"rvb\":\"EhQKEjc4NTA4NTk3MTA2NTM1MDExOBoUChI3ODUwODU5NzEwNjUzNTAxMThaEjc4NTA4NTk3MTA2NTM1MDExOGqHFxIBMBgAIkQaKAAKIWhodGFya3l3eXJzaHF3aGNoaHB1YmxpYzE5ODI5NDU4OBICABIqGMIPDxoPPxObAowEIAAKP-tIggQkAYAEKyqLARABGniBBPwD7BXl__rz_vb8AwABPwsFB_AJCQH9Awvs-wf9ABYDAvsSAQAA9wXsDAoAAAD89eH-_vwAAN7y-fADAAAANgD7CPkA_wDnD_gD_wEAAOXsBvACAAAAARAM9v8AAAAHA-3uAAD_ASPxBAEBAAAAGg__-QAAAAAgAC0ebpY7OBNACUhOUAIqhAIQABrwAXgcZP723rEEhh_6AOau1wGB9A8AOBj-AawyEwG5_-UBmb0UAvci1ADR_sIAgf31Adf72P769OIBPAYaAEmzDwH3yfcAdvX1ACAt2gEiE_4ABiIf_TXCGwAsxiICOBAA-yzXKf_-5fwAq_e7ART9VAL2MvcD-hkdAP_EDAelSRgCAfzn_fXZFAMG0-UJEhsEEBn-FgopQSAA-_n4CgAX7w7MEd7-_ND59EoM7fkqF_4N_uwNCiby3fXQHBIT5jnyC-4_9wBBKwoHIBz-BPGuBPMeE_4LNh3-8i0E3QjTOgn-AwUSB7AJDuwu6RT66d8F8yAALfj-2jo4E0AJSGFQAirPBxAAGsAH6rDqvtrSPLv4lxM9_RwZPCu6mrw7M2I7wsqXPHF2RjwrDSa9JH9QPmNG-Lz-Q5o9eV3_vQVuXbynSQA83SefPhnrdj2UDZA8Ghu1vazOxT394_e7TQsDvdyVwry3e_k8I2XwPMzU_zwrvVu8k28GPm-wIT2ckA68VWd1vddEsL0_LVA8jMeLPSrTnjyPrNe8G8lUvJ_xM7y5cB48-ERoPb3Dbbze2747KBkvvaxgCr2F5p-8l1JXvp-jwDq2v848u3xrvG5unD1JvpI8FbOYOyxnaj3GljS9O5ORPULrH7tmY0o8aOauPL9mNL0OMgS9l1PCvKl2vLzN3848IowPvnU5ar1xRoO8LOVGPYZNrjxjUJ47u33WvZ-HJL35HXk8u7EFva4scb2Pt4W6VuupPGhxazww5wK86O6EvMclcz3pri06Y2A9PQ8uyD19-e48KcEsPBtMQznNJ4I71QykvVIXvrhUSa48ids3PVF3VD2bjww8aVfMPaYTJD1tKws81OICPVuNtryYkAe8uk4TPpYGvjw8ISa7JEYPPao7gL1NdA67D_CUPeAwUbzyw9I7wIXrPKUEo7290kc7jszjPZWC7j1dve26FvjqPe9fjzwz2uw6QzSfvAoDAD0JFSC7_GWBvY6hUjzf61q8WCRhvWdBbb3WSL87TgJlvPCsiL349cc64r8qvY1tyDwg8OG6FhjSvVrfdrwB1x66aft8vIPGp7z7uOy6LPHgvS5w_bsgJxg6pFRCPelmWjwt3gO6JrJFPaPOnDwuJUM5ROySvZmvHL1kz8q4XvhcvY2CuzymwVo3ZGyyPFwD273gpBS5sqs_va_IVL1zrj639iOFvNpIKL0nuY45ylOWPJOHqjwSrwA6Ux6SvUobyL3hc5s3-yRSvN7BWb0NcjY3Fwd8PUJ2Hr6jYIw3JYgkPRZdjTzYNeU409wKvuf6oz2ufMk5sa6VvcAzKz1IgL43RGuVvWnjqL2C5EE3STR8Pcb8PL2C5IM4MzR-PU-Wej21das3BfN8vbtxfzsQW8y38Ugsvvf_xr2JXA24PkxxvfUpbLwZ4iM4oK5pPXP3OTy-3jq4davHPYkvrr1QCDI5xmwpPdVyDD2bmYk3QYNJu6EOMD2924Q4WshNvandDz0WWIK4tDhIvTtwLj2rfWA3ZhK1PF6hz72AurI33DRRPXmxsDxQnqo3x6ADPmCNeL0XyFo4hGKLPTI4yjwga4M4AEg3u3dVNj0-ld24-zcUvYnONz2vDY-30RCUvegYS71GaAa4IAA4E0AJSG1QASpzEAAaYPv-ADb--bIDGCrhKc5HHujytuL4rGT_09wAHDsJvBr42gTm4ADv6BEtowAAACVE-yvZAC91BA4O_uMtNeK4zAMTfxgQQaSvrv7V6jYkLNuGIe7_GgAD9sHxQRex0BgJBCAALeDkDzs4E0AJSG9QAiqvBhAMGqAGAABgQQAAkMEAANhBAAC6QgAAGMIAAMBBAADoQQAAYMEAAAjCAADgwAAA1kIAAADBAAAUQgAAEEEAANBBAAAAwAAAYEEAAKjBAADgQAAAgEEAAI5CAAAQQQAACMIAAMhBAAAMwgAALEIAABjCAAAQwgAAPEIAAHDBAACAPwAAsEEAAGzCAAAQQgAAwEAAABBCAACawgAAqkIAAChCAACAQQAAusIAAJBCAAB8QgAA-MEAAJrCAADAQQAAQMEAAODAAADwwQAAGEIAAIA_AABUwgAAoMEAAKBBAAAkQgAAWEIAAADCAAAowgAAwkIAADRCAAAQwQAAqEEAAIjBAAAEwgAA4EAAAIjBAAAUQgAAMMIAAJbCAADAQAAAhEIAAEBCAAC4wQAAYEEAALDBAAAowgAAyMEAAJBBAADAwAAAAEAAANjBAAAwQgAATMIAACBCAABAwgAAKEIAAATCAAAAQgAAGMIAAOBAAAAgwgAAqMEAAJDCAAAowgAAgL8AAOzCAACQwQAAYEIAADhCAAAQwQAAgEEAALhBAACAwAAAKEIAAETCAAAYQgAAMEEAAKJCAAA8QgAAkkIAAChCAADwwQAA4MEAAEBCAAAUQgAAQMEAAFBBAAAswgAAFEIAAGzCAABwQQAA4MAAACBBAAAowgAAuEEAAJjBAACUQgAAKMIAAIjCAACAvwAAQEAAANDBAAAMwgAAsMEAANjBAAAYQgAAQEIAACDBAACkwgAAWMIAAAhCAAAMwgAA4EAAAEBAAABgQQAA8EEAAPjBAAB4QgAADEIAAABBAAAAQAAA4MAAAIBBAACAwgAA4MEAAIjBAACGwgAAwMEAALhBAADEQgAAMMEAACxCAACgQAAAqMEAAADAAACwQQAAgEAAALhBAABgQQAAQMEAAGTCAAAwQQAAMEIAAKDBAAA8wgAA4EEAAAjCAAA4wgAALEIAAGBCAADQwQAAlkIAAJjBAACAQAAAJMIAADjCAACYwQAAoMAAAJhBAAAgQQAAuEEAAAxCAADAwQAAUEEAABBBAACwQQAAcMEAACxCAADgQAAAwEAgADgTQAlIdVABKo8CEAAagAIAAJa-AABsvgAA2D0AAN4-AADIvQAABL4AAK4-AADyvgAADD4AALK-AAC6vgAAdL4AAOA8AADqvgAAvj4AADA9AACYvQAALD4AAIg9AABRPwAAKz8AAK4-AACWvgAABz8AAKK-AAAQvQAApj4AAEC8AAD4vQAAhr4AAFw-AAAcvgAAXD4AADS-AAD4vQAACz8AAEA8AAA8vgAAbL4AAFw-AADyvgAAmL0AAAu_AAAkvgAAoLwAAFy-AACWPgAAXL4AADy-AACuvgAA-L0AAKi9AACgPAAAXD4AAKI-AACAOwAAfz8AACw-AADovQAA6D0AAIi9AAAQvQAAuL0AADk_IAA4E0AJSHxQASqPAhABGoACAAA0PgAAcL0AAKi9AAAdvwAAsr4AAGQ-AAA0PgAAcL0AAIi9AACmPgAAyr4AAOA8AABsvgAAoLwAAIi9AABQPQAAgDsAAAM_AAAQvQAAKT8AAIi9AACoPQAA4r4AAFC9AACovQAAXL4AAFw-AABAvAAAXL4AAGQ-AABAPAAAEL0AABw-AACSvgAAEL0AAI4-AABAPAAAUD0AACy-AACIPQAAuD0AAFw-AAAEvgAAUD0AABS-AABEvgAAf78AAIA7AABEPgAAgDsAAEC8AAAQPQAAjr4AAOA8AACiPgAADD4AAIi9AADIPQAAqL0AAMg9AADgvAAAwj4AAGQ-AABQvSAAOBNACUh8UAEwCTgBSgBgAGgA\"}","related_url":"http://vk.com/video-198294588_456239187","parent-reqid":"1782268054370172-11784945217864102418-balancer-l7leveler-kubr-yp-sas-159-BAL","related_vfp":1,"relatedVideo":"yes"},"cwidth":1920,"cheight":1080,"cratio":1.77777,"dups":["785085971065350118"],"episode":0,"season":0,"isEmbedOnly":false,"greenHost":"VK Video","hasTranslation":false,"contentTypeId":null,"censored":false,"censoredShock":false,"isShockDoc":false,"videoContentId":"77100259","isLiked":0},"undefined":{"docid":"","description":"","preview":{"posterSrc":"undefined/564x318_1"},"target":"_blank","position":"3","reqid":"1782268054370172-11784945217864102418-balancer-l7leveler-kubr-yp-sas-159-BAL","isAdultDoc":false,"cwidth":null,"cheight":null,"cratio":null,"dups":[],"episode":null,"season":null,"isEmbedOnly":false,"hasTranslation":false,"contentTypeId":null,"censored":false,"censoredShock":false,"isShockDoc":false}},"dups":{"785085971065350118":{"videoId":"785085971065350118","title":"Консолидация в Excel. Как собрать сводные данные со всех листов. Урок для начинающих бесплатно — В...","cleanTitle":"Консолидация в Excel. Как собрать сводные данные со всех листов. Урок для начинающих бесплатно — Видео от Biba.pro - Аналитика для бизнеса","host":{"title":"VK Video","href":"http://vk.com/video-198294588_456239187","playerUri":"\u003ciframe src=\"//vk.com/video_ext.php?hash=85184ddd9cddeb3c&id=456239187&loop=0&oid=-198294588\" frameborder=\"0\" scrolling=\"no\" allowfullscreen=\"1\" allow=\"autoplay; fullscreen; accelerometer; gyroscope; picture-in-picture\" aria-label=\"Video\">\u003c/iframe>","playerId":"vk","providerName":"vk.com","sourceHost":"vk.com","name":"vk.com","secondPart":{"type":"CHANNEL","id":"dmsuY29tO3B1YmxpYzE5ODI5NDU4OA==","name":"Biba.pro - Аналитика для бизнеса","isVerified":false,"subscribersCount":0,"url":"/video/search?text=Biba.pro+-+%D0%90%D0%BD%D0%B0%D0%BB%D0%B8%D1%82%D0%B8%D0%BA%D0%B0+%D0%B4%D0%BB%D1%8F+%D0%B1%D0%B8%D0%B7%D0%BD%D0%B5%D1%81%D0%B0&q_source=channel","a11yText":"Biba.pro - Аналитика для бизнеса. "},"faviconUrl":"//favicon.yandex.net/favicon/v2/https%3A%2F%2Fvk.com%2Fvideo?color=255%2C255%2C255%2C0&size=32&stub=1"},"duration":{"value":283,"text":"4:43","a11yText":"Длительность 4 минуты 43 секунды","shortText":"4 мин"},"views":{"text":"9,9K","a11yText":"9,9 тысяч просмотров"},"date":"17 дек 2024","modifyTime":1734423490000,"isExternal":false,"player":{"embedUrl":"https://vk.com/video_ext.php?autoplay=1&hash=85184ddd9cddeb3c&id=456239187&loop=0&oid=-198294588","playerId":"vk","videoUrl":"http://vk.com/video-198294588_456239187","reqid":"1782268054370172-11784945217864102418-balancer-l7leveler-kubr-yp-sas-159-BAL","duration":283},"parentClipId":"785085971065350118","href":"/preview/785085971065350118?parent-reqid=1782268054370172-11784945217864102418-balancer-l7leveler-kubr-yp-sas-159-BAL","rawHref":"/video/preview/785085971065350118?parent-reqid=1782268054370172-11784945217864102418-balancer-l7leveler-kubr-yp-sas-159-BAL","isEmbedOnly":false,"shouldPlayInstreamPreroll":false,"commentsDisabled":false,"reactionsDisabled":false}},"loadingStatus":"None"},"internal":{"videoId":"785085971065350118","sandboxEventPrefix":"sandbox:","sandboxVersion":"0xa58d53e1b19","isEmbedded":false,"from":"yavideo","service":"ya-video","hbPeriod":30,"table":"video_tech","isInstreamDisabled":true,"nonce":"7849452178641024187159","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":{"adult":{"default":"R-I-474674-135","mail":"R-A-13426421-23"},"regular":{"default":"R-I-48058-751","mail":"R-A-13411721-23"}},"search-grid-inplace":{"regular":{"default":"R-I-48058-742","mail":"R-A-13411721-16"},"adult":{"default":"R-I-474674-126","mail":"R-A-13426421-16"}},"search-grid-head":{"regular":{"default":"R-I-2120168-7"}},"search-list-right":{"adult":{"default":"R-I-19214552-1"},"regular":{"default":"R-I-8843654-1"}},"before-player-old":{"regular":{"default":"R-I-2120168-1"}},"before-player":{"adult":{"default":"R-I-19178478-1"},"regular":{"default":"R-I-2120168-1"}}},"shouldValidateSandbox":false,"sandboxInitTimeout":15000,"isSSROnlyMastheadEnabled":true,"queryUriEscaped":"videoid%3A785085971065350118","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"}}},"querySource":"title"},"playbackQueue":{"currentIndex":0,"items":[{"type":"VIDEO","videoId":"785085971065350118","source":"serp","selectEvent":"click"}]},"related":{"items":[],"pages":[],"loadingStatus":"None","nextPageNum":0,"ncrnd":0},"playlist":{"items":{}},"delayedViews":{"ids":[],"loadingStatus":"None"}}}