Excel'de Kredi Hesaplama | Hazır Şablon | Excel'de Kredi Ödeme Planı Hazırlama
4,9bin4,9 bin izleme
Yayın tarihi 31 eki 202331 eki 2023
{"pages":{"search":{"query":"Someka+TR","originalQuery":"Someka+TR","serpid":"1751639983830114-8182343843131429173-balancer-l7leveler-kubr-yp-klg-124-BAL","reqid":"1751639983830114-8182343843131429173-balancer-l7leveler-kubr-yp-klg-124-BAL","parentReqid":"","serpItems":[{"id":"13248576360603150829-0-0","type":"videoSnippet","props":{"videoId":"13248576360603150829"},"curPage":0}],"filters":{},"serpFooter":{"linksGroups":[{"type":"geo","links":[{"label":"Columbus","title":"Columbus","url":"//yandex.com.tr/tune/geo/","logNode":{"name":"region"},"target":"_self","a11yLabel":"Bölgeniz Columbus","needRetpath":true}]},{"type":"help","links":[{"label":"Bize ulaşın","url":"https://yandex.com.tr/support/video/troubleshooting.html","logNode":{"name":"feedback"},"needRetpath":true},{"label":"Yardım","url":"https://yandex.com.tr/support/video/","logNode":{"name":"help"},"needRetpath":true}]},{"type":"settings","links":[{"label":"Ayarlar","url":"https://yandex.com.tr/tune/search/","target":"_self","logNode":{"name":"settings"},"needRetpath":true}]},{"type":"company","links":[{"label":"Şirket hakkında","url":"//yandex.com.tr/company/","logNode":{"name":"about"},"target":"_blank"},{"label":"Kullanım lisansı","url":"//yandex.com.tr/legal/termsofuse/","logNode":{"name":"license"},"target":"_blank"},{"label":"Gizlilik Politikası","url":"//yandex.com.tr/legal/confidential/","logNode":{"name":"confidential"},"target":"_blank"}],"a11yHidden":true}],"hasExtralinks":true},"currentPage":0,"prevPageToLoad":-1,"nextPageToLoad":1,"isTranslationsFilterEnabled":false,"isTranslationsDistributionEnabled":false,"isTranslationsDistributionOnboardingEnabled":false,"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":"dFNvbWVrYStUUgo=","darkTheme":false,"lazyLoad":false,"extParams":{"reqid":"1751639983830114-8182343843131429173-balancer-l7leveler-kubr-yp-klg-124-BAL","ui":"desktop","yuid":"7833950571751639983"}}},"isAdult":false,"position":0,"placement":"search-list-right"},"curPage":0}],"quasarData":{"title":""},"isAdultQuery":false,"errorList":[],"layout":"list","retpath":"https%3A%2F%2Fgs.yandex.com.tr%2Fvideo%2Fpreview%2F13248576360603150829%3Fhow%3Dtm%26text%3DSomeka%252BTR"},"main":{"_isInitial":true,"snippets":[],"serpFooter":{"linksGroups":[]},"isLoggedIn":false}},"internal":{"nonce":"1823438431314291737124","expFlags":{"video_depot_viewer":1,"video_instream_player_yaru_loader":1,"video_skeleton_doc_update":1,"velocity_delay_drawer":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_adv_serp_right_fixed_screens":3,"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,"int_tr":1,"video_viewer_catch_sandbox_early_inits":1,"int_newstr_header_tab":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,"video_vitrina_disable":"0","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,"video_direct_pos_id":"R-I-48058-73","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_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_pos":5,"video_direct_viewport_margin_desktop":700},"slots":["1262686,0,12;1303452,0,46;1307133,0,78;66181,0,50;1296367,0,60;1305892,0,77;1298357,0,39;1299634,0,91;1304781,0,17;1288801,0,82;1306126,0,3;1304119,0,93;1305217,0,67;9346,0,43;132355,0,94;1285874,0,74;1307497,0,57;1307462,0,9;1294040,0,74;1299272,0,35;1308362,0,38;1305713,0,72;1309721,0,7;1298995,0,79;1146114,0,84;1289139,0,80;1284125,0,72;1307296,0,82;1308557,0,19;1300531,0,83;332148,0,43;1304604,0,24;1060666,0,79;151171,0,95;128380,0,56;126284,0,14;126353,0,40;1230682,0,98;1281084,0,92;287509,0,90;1299576,0,63;1299588,0,30;1288010,0,37;1297646,0,78"],"isYandexNet":false,"platform":"desktop","isEnLogo":true,"retpath":"https%3A%2F%2Fgs.yandex.com.tr%2Fvideo%2Fpreview%2F13248576360603150829%3Fhow%3Dtm%26text%3DSomeka%252BTR","mordaUrl":"//yandex.com.tr/","videoSearchUrl":"https://gs.yandex.com.tr/video/search?how=tm&text=Someka%2BTR","settingsUrl":"https://yandex.com.tr/tune/search/","helpUrl":"https://yandex.com.tr/support/video/","legalUrl":"//legal.yandex.com.tr/termsofuse/","feedbackUrl":"https://yandex.com.tr/support/video/troubleshooting.html","basename":"/video","currentPageName":"previewShort","isYandexApp":false,"isYandexAppAndroid":false,"isYandexAppIos":false,"isAnyYaBro":false,"isAndroid":false,"isHamster":false,"serpid":"1751639983830114-8182343843131429173-balancer-l7leveler-kubr-yp-klg-124-BAL","backUrl":"//ya.ru","url":"https://gs.yandex.com.tr/video/preview/13248576360603150829?how=tm&text=Someka%2BTR","isIntegrationTest":false,"isEndToEndTest":false,"shouldDropLogs":false,"seo":{"url":"https://gs.yandex.com.tr/video/preview/13248576360603150829?how=tm&text=Someka%2BTR","title":"Excel'de Kredi Hesaplama | Hazır Şablon | Excel'de Kredi Ödeme Planı Hazırlama","description":"Hemen İndir: https://www.someka.net/tr/urunler/kre... Excel'de Kredi Hesaplama Şablonu. Kredi koşu...","image":"http://avatars.mds.yandex.net/get-vthumb/402982/9fea92bcfd192f565104d486d7c1cbd4/800x450","imageSecureUrl":"https://avatars.mds.yandex.net/get-vthumb/402982/9fea92bcfd192f565104d486d7c1cbd4/800x450","video":"https://video-preview.s3.yandex.net/jnHsQwIAAAA.mp4","videoType":"video/mp4","imageWidth":800,"imageHeight":450,"type":"video"},"isEmbedded":false,"isPumpkin":false,"quasarCsrfToken":"ybf22705c7cc36adf0a8d64c7249d48c3","reportFeedbackBaseProps":{"initEmail":"","metaFields":{"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","userTestids":"1262686,1303452,1307133,66181,1296367,1305892,1298357,1299634,1304781,1288801,1306126,1304119,1305217,9346,132355,1285874,1307497,1307462,1294040,1299272,1308362,1305713,1309721,1298995,1146114,1289139,1284125,1307296,1308557,1300531,332148,1304604,1060666,151171,128380,126284,126353,1230682,1281084,287509,1299576,1299588,1288010,1297646","queryText":"Someka+TR","reqid":"1751639983830114-8182343843131429173-balancer-l7leveler-kubr-yp-klg-124-BAL","userRegionName":"","userRegionId":"function() {\n return this._region.id;\n }","yandexuid":"7833950571751639983","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,1173000,1167408,1202006,1194718,1221235,1228280,1233754,1239596,1227266,1226860,1279793,1279825,1246754,1277457,1281110,1276447,1289213,1288208,1307480,1299604,1262686,1303452,66181,1298357,1304119,1305217,9346,132355,1308557","regionId":20815,"isYaRu":false,"shouldUnmountSearchPageInViewer":false,"videoGlobalContext":{"platform":"desktop","isPumpkin":false,"language":"tr","user_time":{"epoch":"1751639983","tz":"America/Louisville","to_iso":"2025-07-04T10:39:43-0400","__is_plain":1},"isQuasarEnabled":false,"isHermione":false,"shouldStubImages":true,"enableVideoPreviewInHermione":false,"reqid":"1751639983830114-8182343843131429173-balancer-l7leveler-kubr-yp-klg-124-BAL","tld":"com.tr","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":"1262686,1303452,1307133,66181,1296367,1305892,1298357,1299634,1304781,1288801,1306126,1304119,1305217,9346,132355,1285874,1307497,1307462,1294040,1299272,1308362,1305713,1309721,1298995,1146114,1289139,1284125,1307296,1308557,1300531,332148,1304604,1060666,151171,128380,126284,126353,1230682,1281084,287509,1299576,1299588,1288010,1297646","queryText":"Someka+TR","reqid":"1751639983830114-8182343843131429173-balancer-l7leveler-kubr-yp-klg-124-BAL","userRegionName":"","userRegionId":"function() {\n return this._region.id;\n }","yandexuid":"7833950571751639983","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":"1823438431314291737124","disableDoc2DocHostLink":true,"shouldHideChannelLink":true,"enableSlowBufferingAlert":false,"enableSlowBufferingAlertDedup":false,"userConnectionRtt":148,"visibleHeader":true,"hideTabs":true,"animated":false,"isServiceLikeViewer":false,"smartDesktopLayout":true,"isAdvDisabled":false,"shouldShowVideoPlaylistPane":false,"isVideoTranslationSupported":false,"isSummaryDisabled":false,"isPlainHeader":false,"shouldRenderBroSummaryApiContainer":false,"shouldDropLogs":false,"shouldUseBeacon":false,"hasAdBlock":false,"isVerificationMarkDisabled":false,"shouldPlayNonStopForExternal":false,"forceSlowBufferingAlert":false},"shouldShowAdvId":false,"isAdultQuery":false,"classQueryIsPornoWebScore":0.0008613072569,"showSensitive":false,"shouldReplaceHref":false},"user":{"tld":"com.tr","isEuDomain":false,"login":"","passportId":"","isLoggedIn":false,"locationName":"Columbus","isFamily":false,"yandexuid":"7833950571751639983","ugcCsrfToken":"","family":1,"isChild":false},"config":{"skinMode":"system","skin":"light","version":"releases/frontend/video/v1.1622.0#52e8d2b01ed48c280efeeac21795e77ccc6a569d","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":"gs.yandex.com.tr/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":{"13248576360603150829":{"videoId":"13248576360603150829","docid":"34-7-7-Z7AF72EB9A3259D4B","description":"Hemen İndir: https://www.someka.net/tr/urunler/kre... Excel'de Kredi Hesaplama Şablonu. Kredi koşullarınızı girin, toplam faiz ve ana para ödemelerini anında hesaplayın.","preview":{"posterSrc":"//avatars.mds.yandex.net/get-vthumb/402982/9fea92bcfd192f565104d486d7c1cbd4/564x318_1","videoSrc":"https://video-preview.s3.yandex.net/jnHsQwIAAAA.mp4","videoType":"video/mp4"},"target":"_self","position":"0","reqid":"1751639983830114-8182343843131429173-balancer-l7leveler-kubr-yp-klg-124-BAL","summary":{"isFull":true,"fullTextUrl":"/video/result?ask_summarization=1&numdoc=1&noreask=1&nomisspell=1&parent-reqid=1751639983830114-8182343843131429173-balancer-l7leveler-kubr-yp-klg-124-BAL&text=videoid:13248576360603150829","teaser":[{"list":{"type":"unordered","items":["Bu video, Excel'de kredi hesaplama için hazırlanmış bir şablonun tanıtımını yapan bir eğitim içeriğidir.","Video, tek sayfalık kredi hesaplama şablonunun üç ana bölümünü (varsayımlar, çıktılar ve ödeme planı) detaylı olarak göstermektedir. Varsayımlar bölümünde kredi tutarı, faiz oranı, ödeme sıklığı, vade ve balon ödeme gibi değişkenler girilirken, çıktılar bölümünde taksit tutarı, ödenen toplam faiz ve toplam ödemeler gösterilmektedir. Ödeme planı bölümünde ise dönemsel bazda son ödeme tarihleri, anapara ve faiz tutarları, taksit tutarları ve kredi bakiyeleri takip edilebilir. Şablon dinamik olarak çalışmakta ve Ctrl+P tuşuyla kolayca çıktı alınabilir."]},"endTime":158,"title":"Someka Kredi Hesaplama Şablonu Tanıtım Videosu","beginTime":0}],"fullResult":[{"index":0,"title":"Someka Kredi Hesaplama Şablonu Tanıtımı","list":{"type":"unordered","items":["Excel'de kredi hesaplamak için karmaşık formüllerle uğraşmak yerine, hazır şablonla değişkenlerinizi girmeniz yeterli olacak.","Tek sayfalık şablon üç ana bölümden oluşuyor: varsayımlar, çıktılar ve ödeme planı."]},"beginTime":4,"endTime":28,"href":"/video/preview/13248576360603150829?how=tm&parent-reqid=1751639983830114-8182343843131429173-balancer-l7leveler-kubr-yp-klg-124-BAL&text=Someka%2BTR&t=4&ask_summarization=1"},{"index":1,"title":"Varsayımlar Bölümü","list":{"type":"unordered","items":["Varsayımlar bölümünde kredi tutarı, yıllık faiz oranı ve ilk ödeme tarihi girilebilir.","Kredi ödeme sıklığı açılır kapanır menüden seçilebilir, kredi vadesi ay cinsinden girilmelidir.","Tek seferlik balon ödeme varsa bu alan girilebilir, yoksa boş bırakılabilir."]},"beginTime":28,"endTime":59,"href":"/video/preview/13248576360603150829?how=tm&parent-reqid=1751639983830114-8182343843131429173-balancer-l7leveler-kubr-yp-klg-124-BAL&text=Someka%2BTR&t=28&ask_summarization=1"},{"index":2,"title":"Çıktılar ve Ödeme Planı","list":{"type":"unordered","items":["Değişkenler girildiğinde çıktılar bölümü ve ödeme planı kendiliğinden güncellenir.","Çıktılar bölümünde taksit tutarı, ödenen toplam faiz ve toplam ödemeler görüntülenebilir.","Ödeme planında dönemsel bazda son ödeme tarihleri, anapara ve faiz tutarları, taksit tutarı ve kredi bakiyeleri takip edilebilir."]},"beginTime":59,"endTime":108,"href":"/video/preview/13248576360603150829?how=tm&parent-reqid=1751639983830114-8182343843131429173-balancer-l7leveler-kubr-yp-klg-124-BAL&text=Someka%2BTR&t=59&ask_summarization=1"},{"index":3,"title":"Kullanım Kolaylığı","list":{"type":"unordered","items":["Varsayımlar kısmında farklı kredi senaryoları denenebilir.","Ödeme planı yazdırmak için herhangi bir düzenleme yapmaya gerek yok, çıktı alanları dinamiktir.","Ctrl+P tuşlarına basarak kolaylıkla çıktı alınabilir, ödeme sıklığı değiştirildiğinde de dinamik olarak çıktı alınabilir."]},"beginTime":108,"endTime":149,"href":"/video/preview/13248576360603150829?how=tm&parent-reqid=1751639983830114-8182343843131429173-balancer-l7leveler-kubr-yp-klg-124-BAL&text=Someka%2BTR&t=108&ask_summarization=1"}],"linkTemplate":"/video/preview/13248576360603150829?how=tm&parent-reqid=1751639983830114-8182343843131429173-balancer-l7leveler-kubr-yp-klg-124-BAL&text=Someka%2BTR&t=%%timestamp%%&ask_summarization=1"},"isAdultDoc":false,"relatedParams":{"text":"Excel'de Kredi Hesaplama | Hazır Şablon | Excel'de Kredi Ödeme Planı Hazırlama","related_orig_text":"Someka+TR","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\":\"Someka+TR\",\"url\":\"http:\\/\\/www.youtube.com\\/watch?v=MPkyGZt-7Qo\",\"src\":\"serp\",\"rvb\":\"EhYKFDEzMjQ4NTc2MzYwNjAzMTUwODI5GhYKFDEzMjQ4NTc2MzYwNjAzMTUwODI5WhQxMzI0ODU3NjM2MDYwMzE1MDgyOWqxDBIBMBgAIkQaMAAKKWhoY2d0aG1xenltcW9wZWhoVUMza1ZTU1A2RXRObG5WUmE3RVBRdTd3EgIAESoQwg8PGg8_E54BggQkAYAEKyqLARABGniBCAb5DAAAAPj-_QH5BP8BGwABCvUCAgD99wEC_wb9AP8CBvn_AQAA_gsHAgAAAAAI7gMM_f0BABHs-_wCAAAAFvkADfgAAAD4CvwECAAAAAAF-u4CAAAADA0O9wAAAAD1AQP7-AD_AQUHAxQAAAAA--z-_wAAAAAgAC2ZQNU7OBNACUhOUAIqhAIQABrwAVn4_wDS-vb_BwENABDx1wGB8Pv_ISEJAOMQDgDUJuUA3wUIANf-DAHVC_wA3BgOAP_o5QAmCwUB-vwb_wsaEAAv5w4AL_YaAQAP9QD7DPcAHvYZ_yQACwEC7y7-Axnl_zzs9_3vCuEB3hLv___mFALt-AACDgMEBQwL-wMH6QMB6eoS_TEACgPs6ej-BfwCAB_q9f0FDfgB_QLpAf34AvsY7_MCC_r7BRsIBQoV9QP66wkJBiUF_vsGDeb8FxYC-A_29wEZH_7-BAsABhLH-_wO6vX89foE9iAw-wf_8Ab3_RT59-Mc_gPtEwP6BP_7BSAALZD6Tjs4E0AJSGFQAirPBxAAGsAHT6zbvmNLKr1iMH-8ZyaNvRM32bpWogU8ztwIvVVlhDpfDha9GxARPtJUT7z0hRU9mYCnvmX70Dyf-hE9iq1APgyNLD1cYEU8GXSivQyiHz2KQbu751Z4vgJaxLx4UhG6EFwFPpuTVbvtrCu7199yPgdfGL38aSg9YP1kvXm5bbp4fLm7foRmvbwNBb1vwAI9Gk_kPTr5Pj3rrxI9uyYEPq2Hn71Ad_i8ojDDvQJB5zv3EEO88ijAva-txDyFcxE7vs0RPZSBhzuZ5FY9SMsXPewHhjx383m84JwBPnaKNT1VYug7bfqIvZhyGT2gxpg8KrsKvRXZ2LyhMW68P28qvVFOdD0RSDK7c8H0PHzJkDxkDQ88Ka5KvZUgrTwvdni6L4OmvVKUED1pN_q7dA2uPR56Ib3Kyoa7x_eQvZUfYj1VH587BKzVPDOimTz080s8Vg3CPGjFPD0eibg7yD_zvMWHo7ylzq08JFVlPSa-nz0P6Vw8D7bYPVyjb72w7Yg8urw5PS9fCbzgVrA8dlu4PcKvBzxt51Y8XDI4PRdbLbxmIKu4S3hCPSDmNzzfWOk71RaovdvxcDw0R3s72qHrPLT--zwy_gG8WU_tPfIgYrwnYja8uQAvPdnP4j3Hd7U6tcWxOxRYJbwuOdG7IGZqvSh8WzwZrBU8QJ5CPaIlj7yCNZQ7Ef8wPd5rTT1Hyek7zJ9rOyrxSrw6joK7oJkSvJUmqr2WJ2-7JT8iPfYqDbw62j-6g6mDO29DsTzqojE6k2KRPaaBP72Dk6y5seIvvPgytLpRp3o7RlCbPQmG2DyeeEA40CNrvLisMr5Ohls5TPzRPbQ9F7wA4dY5GU10u1RrhjxQyLy5JbYWPeqzrr1Zh-q46fatvCU79r25vMw4mmgmva8mn73-60i5Vre6PWUuOr2oQjA54pViOxgttr38g1m5WHIVvcKSIb0R6Kw5vvHaPECWjz0C3QU5sH5CvSq8FT0deUK4-R_PvMC3ZL1xGUI4owtFvHZPkz32LUc46J5aPcMRJLwVIHy2B2eWvXbP8LyGPsu39Oi8PEOjJT2MF9u3PPyAPQHmgL3azB05-uZIPUHYCb76uKs4s0_2PPIBZj32YEe30i-2PbXfGr0qgDm4AOGovEB3ODySGsk1PrSqPMoPkT1KusI4q2IivMetk7xM5n63lgoKPjgpET2oGRc4mglGvSDkZj31Ty44-WTlPcjZmj21QNY2ZtkTvYQYnjx2U3a4TrdsPMYmY71F2gw35LUXvR8TaT23YXI4IAA4E0AJSG1QASpzEAAaYAz-ADgE_5LWEBT34v82HfQKwxDqwUf_KvX_3zCmvRcSusjCGgAqEA71mwAAAO7c0RIaACZ_4AvGGe0iIobi-CLSUh0QI5UY6-sS1SkL0-nA8AFDBQD33rHibR_JHkga1iAALdUvETs4E0AJSG9QAjAJOAFKAGAAaAA,\"}","related_url":"http://www.youtube.com/watch?v=MPkyGZt-7Qo","parent-reqid":"1751639983830114-8182343843131429173-balancer-l7leveler-kubr-yp-klg-124-BAL","related_vfp":1,"relatedVideo":"yes"},"cwidth":1920,"cheight":1080,"cratio":1.77777,"dups":["13248576360603150829"],"episode":0,"season":0,"isEmbedOnly":false,"greenHost":"YouTube","hasTranslation":true,"contentTypeId":null}},"dups":{"13248576360603150829":{"videoId":"13248576360603150829","title":"Excel'de Kredi Hesaplama | Hazır Şablon | Excel'de Kredi Ödeme Planı Hazırlama","cleanTitle":"Excel'de Kredi Hesaplama | Hazır Şablon | Excel'de Kredi Ödeme Planı Hazırlama","host":{"title":"YouTube","href":"http://www.youtube.com/watch?v=MPkyGZt-7Qo","playerUri":"\u003ciframe src=\"//www.youtube.com/embed/MPkyGZt-7Qo?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":"d3d3LnlvdXR1YmUuY29tO1VDM2tWU1NQNkV0TmxuVlJhN0VQUXU3dw==","name":"Someka TR","isVerified":false,"subscribersCount":0,"url":"/video/search?channelId=d3d3LnlvdXR1YmUuY29tO1VDM2tWU1NQNkV0TmxuVlJhN0VQUXU3dw%3D%3D&how=tm&text=Someka+TR","origUrl":"http://www.youtube.com/@somekaTR","a11yText":"Someka TR. "},"faviconUrl":"//favicon.yandex.net/favicon/v2/http%3A%2F%2Fyoutube.com?color=255%2C255%2C255%2C0&size=32&stub=1"},"duration":{"value":158,"text":"2:38","a11yText":"Süre 2 dakika 38 saniye"},"views":{"text":"4,9bin","shouldShowInSnippet":true,"a11yText":"4,9 bin izleme"},"date":"31 eki 2023","modifyTime":1698710400000,"isExternal":false,"shouldShowQuasar":false,"player":{"embedUrl":"https://www.youtube.com/embed/MPkyGZt-7Qo?autoplay=1&enablejsapi=1&wmode=opaque","playerId":"youtube","videoUrl":"http://www.youtube.com/watch?v=MPkyGZt-7Qo","reqid":"1751639983830114-8182343843131429173-balancer-l7leveler-kubr-yp-klg-124-BAL","duration":158},"parentClipId":"13248576360603150829","href":"/preview/13248576360603150829?how=tm&parent-reqid=1751639983830114-8182343843131429173-balancer-l7leveler-kubr-yp-klg-124-BAL&text=Someka%2BTR","rawHref":"/video/preview/13248576360603150829?how=tm&parent-reqid=1751639983830114-8182343843131429173-balancer-l7leveler-kubr-yp-klg-124-BAL&text=Someka%2BTR","isEmbedOnly":false}}},"viewer":{"_isInitial":false,"clips":{"items":{"13248576360603150829":{"videoId":"13248576360603150829","docid":"34-7-7-Z7AF72EB9A3259D4B","description":"Hemen İndir: https://www.someka.net/tr/urunler/kre... Excel'de Kredi Hesaplama Şablonu. Kredi koşullarınızı girin, toplam faiz ve ana para ödemelerini anında hesaplayın.","preview":{"posterSrc":"//avatars.mds.yandex.net/get-vthumb/402982/9fea92bcfd192f565104d486d7c1cbd4/564x318_1","videoSrc":"https://video-preview.s3.yandex.net/jnHsQwIAAAA.mp4","videoType":"video/mp4"},"target":"_self","position":"0","reqid":"1751639983830114-8182343843131429173-balancer-l7leveler-kubr-yp-klg-124-BAL","summary":{"isFull":true,"fullTextUrl":"/video/result?ask_summarization=1&numdoc=1&noreask=1&nomisspell=1&parent-reqid=1751639983830114-8182343843131429173-balancer-l7leveler-kubr-yp-klg-124-BAL&text=videoid:13248576360603150829","teaser":[{"list":{"type":"unordered","items":["Bu video, Excel'de kredi hesaplama için hazırlanmış bir şablonun tanıtımını yapan bir eğitim içeriğidir.","Video, tek sayfalık kredi hesaplama şablonunun üç ana bölümünü (varsayımlar, çıktılar ve ödeme planı) detaylı olarak göstermektedir. Varsayımlar bölümünde kredi tutarı, faiz oranı, ödeme sıklığı, vade ve balon ödeme gibi değişkenler girilirken, çıktılar bölümünde taksit tutarı, ödenen toplam faiz ve toplam ödemeler gösterilmektedir. Ödeme planı bölümünde ise dönemsel bazda son ödeme tarihleri, anapara ve faiz tutarları, taksit tutarları ve kredi bakiyeleri takip edilebilir. Şablon dinamik olarak çalışmakta ve Ctrl+P tuşuyla kolayca çıktı alınabilir."]},"endTime":158,"title":"Someka Kredi Hesaplama Şablonu Tanıtım Videosu","beginTime":0}],"fullResult":[{"index":0,"title":"Someka Kredi Hesaplama Şablonu Tanıtımı","list":{"type":"unordered","items":["Excel'de kredi hesaplamak için karmaşık formüllerle uğraşmak yerine, hazır şablonla değişkenlerinizi girmeniz yeterli olacak.","Tek sayfalık şablon üç ana bölümden oluşuyor: varsayımlar, çıktılar ve ödeme planı."]},"beginTime":4,"endTime":28,"href":"/video/preview/13248576360603150829?how=tm&parent-reqid=1751639983830114-8182343843131429173-balancer-l7leveler-kubr-yp-klg-124-BAL&text=Someka%2BTR&t=4&ask_summarization=1"},{"index":1,"title":"Varsayımlar Bölümü","list":{"type":"unordered","items":["Varsayımlar bölümünde kredi tutarı, yıllık faiz oranı ve ilk ödeme tarihi girilebilir.","Kredi ödeme sıklığı açılır kapanır menüden seçilebilir, kredi vadesi ay cinsinden girilmelidir.","Tek seferlik balon ödeme varsa bu alan girilebilir, yoksa boş bırakılabilir."]},"beginTime":28,"endTime":59,"href":"/video/preview/13248576360603150829?how=tm&parent-reqid=1751639983830114-8182343843131429173-balancer-l7leveler-kubr-yp-klg-124-BAL&text=Someka%2BTR&t=28&ask_summarization=1"},{"index":2,"title":"Çıktılar ve Ödeme Planı","list":{"type":"unordered","items":["Değişkenler girildiğinde çıktılar bölümü ve ödeme planı kendiliğinden güncellenir.","Çıktılar bölümünde taksit tutarı, ödenen toplam faiz ve toplam ödemeler görüntülenebilir.","Ödeme planında dönemsel bazda son ödeme tarihleri, anapara ve faiz tutarları, taksit tutarı ve kredi bakiyeleri takip edilebilir."]},"beginTime":59,"endTime":108,"href":"/video/preview/13248576360603150829?how=tm&parent-reqid=1751639983830114-8182343843131429173-balancer-l7leveler-kubr-yp-klg-124-BAL&text=Someka%2BTR&t=59&ask_summarization=1"},{"index":3,"title":"Kullanım Kolaylığı","list":{"type":"unordered","items":["Varsayımlar kısmında farklı kredi senaryoları denenebilir.","Ödeme planı yazdırmak için herhangi bir düzenleme yapmaya gerek yok, çıktı alanları dinamiktir.","Ctrl+P tuşlarına basarak kolaylıkla çıktı alınabilir, ödeme sıklığı değiştirildiğinde de dinamik olarak çıktı alınabilir."]},"beginTime":108,"endTime":149,"href":"/video/preview/13248576360603150829?how=tm&parent-reqid=1751639983830114-8182343843131429173-balancer-l7leveler-kubr-yp-klg-124-BAL&text=Someka%2BTR&t=108&ask_summarization=1"}],"linkTemplate":"/video/preview/13248576360603150829?how=tm&parent-reqid=1751639983830114-8182343843131429173-balancer-l7leveler-kubr-yp-klg-124-BAL&text=Someka%2BTR&t=%%timestamp%%&ask_summarization=1"},"isAdultDoc":false,"relatedParams":{"text":"Excel'de Kredi Hesaplama | Hazır Şablon | Excel'de Kredi Ödeme Planı Hazırlama","related_orig_text":"Someka+TR","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\":\"Someka+TR\",\"url\":\"http:\\/\\/www.youtube.com\\/watch?v=MPkyGZt-7Qo\",\"src\":\"serp\",\"rvb\":\"EhYKFDEzMjQ4NTc2MzYwNjAzMTUwODI5GhYKFDEzMjQ4NTc2MzYwNjAzMTUwODI5WhQxMzI0ODU3NjM2MDYwMzE1MDgyOWqxDBIBMBgAIkQaMAAKKWhoY2d0aG1xenltcW9wZWhoVUMza1ZTU1A2RXRObG5WUmE3RVBRdTd3EgIAESoQwg8PGg8_E54BggQkAYAEKyqLARABGniBCAb5DAAAAPj-_QH5BP8BGwABCvUCAgD99wEC_wb9AP8CBvn_AQAA_gsHAgAAAAAI7gMM_f0BABHs-_wCAAAAFvkADfgAAAD4CvwECAAAAAAF-u4CAAAADA0O9wAAAAD1AQP7-AD_AQUHAxQAAAAA--z-_wAAAAAgAC2ZQNU7OBNACUhOUAIqhAIQABrwAVn4_wDS-vb_BwENABDx1wGB8Pv_ISEJAOMQDgDUJuUA3wUIANf-DAHVC_wA3BgOAP_o5QAmCwUB-vwb_wsaEAAv5w4AL_YaAQAP9QD7DPcAHvYZ_yQACwEC7y7-Axnl_zzs9_3vCuEB3hLv___mFALt-AACDgMEBQwL-wMH6QMB6eoS_TEACgPs6ej-BfwCAB_q9f0FDfgB_QLpAf34AvsY7_MCC_r7BRsIBQoV9QP66wkJBiUF_vsGDeb8FxYC-A_29wEZH_7-BAsABhLH-_wO6vX89foE9iAw-wf_8Ab3_RT59-Mc_gPtEwP6BP_7BSAALZD6Tjs4E0AJSGFQAirPBxAAGsAHT6zbvmNLKr1iMH-8ZyaNvRM32bpWogU8ztwIvVVlhDpfDha9GxARPtJUT7z0hRU9mYCnvmX70Dyf-hE9iq1APgyNLD1cYEU8GXSivQyiHz2KQbu751Z4vgJaxLx4UhG6EFwFPpuTVbvtrCu7199yPgdfGL38aSg9YP1kvXm5bbp4fLm7foRmvbwNBb1vwAI9Gk_kPTr5Pj3rrxI9uyYEPq2Hn71Ad_i8ojDDvQJB5zv3EEO88ijAva-txDyFcxE7vs0RPZSBhzuZ5FY9SMsXPewHhjx383m84JwBPnaKNT1VYug7bfqIvZhyGT2gxpg8KrsKvRXZ2LyhMW68P28qvVFOdD0RSDK7c8H0PHzJkDxkDQ88Ka5KvZUgrTwvdni6L4OmvVKUED1pN_q7dA2uPR56Ib3Kyoa7x_eQvZUfYj1VH587BKzVPDOimTz080s8Vg3CPGjFPD0eibg7yD_zvMWHo7ylzq08JFVlPSa-nz0P6Vw8D7bYPVyjb72w7Yg8urw5PS9fCbzgVrA8dlu4PcKvBzxt51Y8XDI4PRdbLbxmIKu4S3hCPSDmNzzfWOk71RaovdvxcDw0R3s72qHrPLT--zwy_gG8WU_tPfIgYrwnYja8uQAvPdnP4j3Hd7U6tcWxOxRYJbwuOdG7IGZqvSh8WzwZrBU8QJ5CPaIlj7yCNZQ7Ef8wPd5rTT1Hyek7zJ9rOyrxSrw6joK7oJkSvJUmqr2WJ2-7JT8iPfYqDbw62j-6g6mDO29DsTzqojE6k2KRPaaBP72Dk6y5seIvvPgytLpRp3o7RlCbPQmG2DyeeEA40CNrvLisMr5Ohls5TPzRPbQ9F7wA4dY5GU10u1RrhjxQyLy5JbYWPeqzrr1Zh-q46fatvCU79r25vMw4mmgmva8mn73-60i5Vre6PWUuOr2oQjA54pViOxgttr38g1m5WHIVvcKSIb0R6Kw5vvHaPECWjz0C3QU5sH5CvSq8FT0deUK4-R_PvMC3ZL1xGUI4owtFvHZPkz32LUc46J5aPcMRJLwVIHy2B2eWvXbP8LyGPsu39Oi8PEOjJT2MF9u3PPyAPQHmgL3azB05-uZIPUHYCb76uKs4s0_2PPIBZj32YEe30i-2PbXfGr0qgDm4AOGovEB3ODySGsk1PrSqPMoPkT1KusI4q2IivMetk7xM5n63lgoKPjgpET2oGRc4mglGvSDkZj31Ty44-WTlPcjZmj21QNY2ZtkTvYQYnjx2U3a4TrdsPMYmY71F2gw35LUXvR8TaT23YXI4IAA4E0AJSG1QASpzEAAaYAz-ADgE_5LWEBT34v82HfQKwxDqwUf_KvX_3zCmvRcSusjCGgAqEA71mwAAAO7c0RIaACZ_4AvGGe0iIobi-CLSUh0QI5UY6-sS1SkL0-nA8AFDBQD33rHibR_JHkga1iAALdUvETs4E0AJSG9QAjAJOAFKAGAAaAA,\"}","related_url":"http://www.youtube.com/watch?v=MPkyGZt-7Qo","parent-reqid":"1751639983830114-8182343843131429173-balancer-l7leveler-kubr-yp-klg-124-BAL","related_vfp":1,"relatedVideo":"yes"},"cwidth":1920,"cheight":1080,"cratio":1.77777,"dups":["13248576360603150829"],"episode":0,"season":0,"isEmbedOnly":false,"greenHost":"YouTube","hasTranslation":true,"contentTypeId":null}},"dups":{"13248576360603150829":{"videoId":"13248576360603150829","title":"Excel'de Kredi Hesaplama | Hazır Şablon | Excel'de Kredi Ödeme Planı Hazırlama","cleanTitle":"Excel'de Kredi Hesaplama | Hazır Şablon | Excel'de Kredi Ödeme Planı Hazırlama","host":{"title":"YouTube","href":"http://www.youtube.com/watch?v=MPkyGZt-7Qo","playerUri":"\u003ciframe src=\"//www.youtube.com/embed/MPkyGZt-7Qo?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":"d3d3LnlvdXR1YmUuY29tO1VDM2tWU1NQNkV0TmxuVlJhN0VQUXU3dw==","name":"Someka TR","isVerified":false,"subscribersCount":0,"url":"/video/search?channelId=d3d3LnlvdXR1YmUuY29tO1VDM2tWU1NQNkV0TmxuVlJhN0VQUXU3dw%3D%3D&how=tm&text=Someka+TR","origUrl":"http://www.youtube.com/@somekaTR","a11yText":"Someka TR. "},"faviconUrl":"//favicon.yandex.net/favicon/v2/http%3A%2F%2Fyoutube.com?color=255%2C255%2C255%2C0&size=32&stub=1"},"duration":{"value":158,"text":"2:38","a11yText":"Süre 2 dakika 38 saniye"},"views":{"text":"4,9bin","shouldShowInSnippet":true,"a11yText":"4,9 bin izleme"},"date":"31 eki 2023","modifyTime":1698710400000,"isExternal":false,"shouldShowQuasar":false,"player":{"embedUrl":"https://www.youtube.com/embed/MPkyGZt-7Qo?autoplay=1&enablejsapi=1&wmode=opaque","playerId":"youtube","videoUrl":"http://www.youtube.com/watch?v=MPkyGZt-7Qo","reqid":"1751639983830114-8182343843131429173-balancer-l7leveler-kubr-yp-klg-124-BAL","duration":158},"parentClipId":"13248576360603150829","href":"/preview/13248576360603150829?how=tm&parent-reqid=1751639983830114-8182343843131429173-balancer-l7leveler-kubr-yp-klg-124-BAL&text=Someka%2BTR","rawHref":"/video/preview/13248576360603150829?how=tm&parent-reqid=1751639983830114-8182343843131429173-balancer-l7leveler-kubr-yp-klg-124-BAL&text=Someka%2BTR","isEmbedOnly":false}},"loadingStatus":"None"},"internal":{"videoId":"13248576360603150829","sandboxEventPrefix":"sandbox:","sandboxVersion":"0x37b97f62901","isHermione":false,"isEmbedded":false,"from":"yavideo","service":"ya-video","hbPeriod":30,"rknWarnHosts":[""],"table":"video_tech","nonce":"1823438431314291737124","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,"isSSROnlyMastheadEnabled":true,"query":"Someka+TR","queryUriEscaped":"Someka%2BTR","filterMode":1,"isUserChild":false},"playbackQueue":{"currentIndex":0,"items":[{"type":"VIDEO","videoId":"13248576360603150829","source":"serp","selectEvent":"click"}]},"related":{"items":[],"pages":[],"loadingStatus":"None","nextPageNum":0,"ncrnd":0},"playlist":{"items":{}}}}