{"id":430,"date":"2025-05-17T13:55:35","date_gmt":"2025-05-17T13:55:35","guid":{"rendered":"https:\/\/spectracons.com\/?p=430"},"modified":"2025-05-23T07:29:43","modified_gmt":"2025-05-23T07:29:43","slug":"94-ms-excel","status":"publish","type":"post","link":"https:\/\/spectracons.com\/?p=430","title":{"rendered":"94-MS EXCEL"},"content":{"rendered":"\n<p><strong><em>Genel<\/em><\/strong><\/p>\n\n\n\n<p>Her m\u00fchendisin olmazsa olmazlar\u0131n\u0131n en ba\u015f\u0131nda Excel gelmektedir. Yeterli bir \u00e7ok kaynak kolayl\u0131kla eri\u015filebilir oldu\u011fu i\u00e7in bu b\u00f6l\u00fcmde standart form\u00fcllerin d\u0131\u015f\u0131nda kalan konular ile ilgili bilgiler verilecektir.<\/p>\n\n\n\n<p><strong><em>Yaz\u0131\/Metin Tipik Fonksiyonlar<\/em><\/strong><\/p>\n\n\n\n<p><em>TRIM<\/em>:Herhangi bir yaz\u0131n\u0131n ba\u015f\u0131nda ve sonunda bulunan bo\u015fluklar\u0131n silinmesini sa\u011flar.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXeZShOfdA9rhAcn69-naP1svyePrE9STJlO34yanlvc-jxcEK3_bDtYXxNpJQF94kfUkTBjwa_NV7UdPim4OPLKY_2yfb47i1lyoI_tn1FhakocP32L-rhciTk4SqwDZmId0k-wtI_5rNs0CD0QXOtelWva?key=sxwrqVhbNIBiG1jdAiJdzw\" alt=\"\"\/><\/figure>\n\n\n\n<p><em>MID<\/em>:Herhangi bir yaz\u0131 dizisinden, ba\u015flang\u0131\u00e7 karakter s\u0131ras\u0131 ile toplam gidilmesi istenen karakter say\u0131s\u0131 bilgisi ile, istenilen par\u00e7an\u0131n \u00e7\u0131kar\u0131lmas\u0131 sa\u011flan\u0131r.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXepeoQ5Wu6O1OjcyCOalMNb_A4Nw9Kp_JGdIcVg6DJjJedNn1wE-0StIWX_zn8Ym5n5zcFeI3D_0kJssJunfR7EupSDL2Yzcowzp3-rLy0LAmboFeAyHPJrILzHTKx9h7i2wkWEd7WRFOToBqKF3-LvjkAE?key=sxwrqVhbNIBiG1jdAiJdzw\" alt=\"\"\/><\/figure>\n\n\n\n<p><em>SUBSTITUTE<\/em>: Herhangi bit metnin i\u00e7erisinden karakter veya karakter grubunu ba\u015fka bir karakter ya da karakter grubu ile de\u011fi\u015ftirmek i\u00e7in kullan\u0131l\u0131r.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXc7R-f-47Viglzljq0GMGi1-Zltm1_XgbasVc1tJr6fv7Cs2qhuYTdC-7y5I5CqtUAJIB6jAZX8uRY34Rr7-iK7dmCrC7-QbzhVayyyn8DbprEzijA-IBnfnHRnr9Da1iSmz-yMEIQLHFYjOR0VueYnC70?key=sxwrqVhbNIBiG1jdAiJdzw\" alt=\"\"\/><\/figure>\n\n\n\n<p><em>CHAR(10<\/em>):\u00d6zel bir karakter olup herhangi bir h\u00fccre i\u00e7erisinde Alt+Enter ile h\u00fccre i\u00e7inde bir alt sat\u0131ra ge\u00e7ilmesidir. Her Alt+Enter komutunun yaz\u0131ld\u0131\u011f\u0131 yerde bir tane CHAR(10) karakteri mevcuttur.,<\/p>\n\n\n\n<p><em>RPT<\/em>:Herhangi bir yaz\u0131 nesnesinin istenildi\u011fi kadar tekrarlanmas\u0131n\u0131 sa\u011flar.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXcMvsZoqcByJ7LThUCOJnagEcppbw51TXYiCoB8D_fIgugdejG1HCxJ2436QOWZ6UEW_2x4rVoMg7OXi4VwnULpTLaN8PO67zR6yMdpn2yrS2TwvDF3wPIiWUlr1ecxZgVdXnAZxPNAhfsCvEhkkPpCjJfJ?key=sxwrqVhbNIBiG1jdAiJdzw\" alt=\"\"\/><\/figure>\n\n\n\n<p><em>LEN<\/em>:Herhangi bir yaz\u0131 nesnesinin ya da herhangi bir h\u00fccredeki yaz\u0131 karakterlerinin toplam say\u0131s\u0131n\u0131 verir.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXdDTFMg04vYOEPIC3rIAgfh1X2zyh2-0Sx2atiztIDp596IeeAzhpxsOAeLVAA0c-19jBzQ8M67JsVGhjZPoY-MSN5Wva-wxjpFX0YA9twvKZWIDPlFWrA0S8K-nWsdgY9_SPVDHnTnTUyVH7esZtM2nXvx?key=sxwrqVhbNIBiG1jdAiJdzw\" alt=\"\"\/><\/figure>\n\n\n\n<p><strong><em>\u201cLEN\u201d Fonksiyonu \u00d6rnek<\/em><\/strong><\/p>\n\n\n\n<p>Herhangi bir h\u00fccre i\u00e7erisindeki metinde, herhangi bri karakterin ka\u00e7 kere tekrarland\u0131\u011f\u0131n\u0131 bulabilmek i\u00e7in a\u015fa\u011f\u0131daki form\u00fclizasyon uygulanabilir.<\/p>\n\n\n\n<p>LEN(xx)-LEN(SUBSTITUTE(xx;yy;\u201d\u201d))<\/p>\n\n\n\n<p>xx metninin toplam karakter say\u0131s\u0131 \u2013 xx metni i\u00e7inde adedi aranan yy karakterin bo\u015fluk karakteri ile de\u011fi\u015ftirilmi\u015f durumdaki toplam karakter say\u0131s\u0131=metin i\u00e7erisindeki toplam yy karakterinin say\u0131s\u0131<\/p>\n\n\n\n<p><strong><em>Yaz\u0131\/Metin \u00d6rnek<\/em><\/strong><\/p>\n\n\n\n<p>Excel de genel tan\u0131mlama herhangi bir h\u00fccrede tek de\u011fer olmas\u0131 y\u00f6n\u00fcndedir ve ilave datalar\u0131 ba\u015fka h\u00fccrelere yazmak kullan\u0131m a\u00e7\u0131s\u0131ndan \u00e7ok daha kolayd\u0131r. Fakat herhangi bir h\u00fccrenin i\u00e7erisine girilen paragraflardan istenilen herhangi birisinin (ara ge\u00e7iler Alt+enter ile) ba\u015fka bir h\u00fccreye form\u00fcl ile otomatik ge\u00e7i\u015fi de sa\u011flanabilir.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXfhBjPbKTtSOkpzlte2qbbpE3SymR8mwJlBeP-M9uAA_G6rriDkTPZ4IAEZw0CX3OEiUa2Hb5Dt4AqLsC4nijk3HGS9bycdwlP1pPYAHBOfIWoacTG-Yzc3OCPPsu4D74lVkXA5d1qUJD06MKDKjNGWlWWw?key=sxwrqVhbNIBiG1jdAiJdzw\" alt=\"\"\/><\/figure>\n\n\n\n<p>C2 h\u00fccresinin form\u00fclizasyonu a\u015fa\u011f\u0131ya \u00e7\u0131kart\u0131lm\u0131\u015ft\u0131r.<\/p>\n\n\n\n<p>\u201c=TRIM(MID(SUBSTITUTE(B2;CHAR(10);REPT(\u201d \u201c;LEN(B2)));((LEN(B2)-LEN(SUBSTITUTE(B2;CHAR(10);\u201d\u201d))))*LEN(B2)+1;LEN(B2)))\u201d<\/p>\n\n\n\n<p>Herhangi bir s\u0131radaki de\u011ferin istenmesi durumunda \u00e7ok k\u00fc\u00e7\u00fck bir de\u011fi\u015fiklikle benzer bir form\u00fcl uygulanabilir. A\u015fa\u011f\u0131da konu hakk\u0131nda detayl\u0131 bir video bulunmaktad\u0131r.<\/p>\n\n\n\n<p><a href=\"https:\/\/www.youtube.com\/watch?v=xZXjpu2mSig\">How to Extract lines from Multi Line Text in a Cell \u2013 Office 365 \u2013 YouTube<\/a><\/p>\n\n\n\n<p><strong><em>Index-Match<\/em><\/strong><\/p>\n\n\n\n<p>Bu iki fonksiyon beraber kullan\u0131ld\u0131\u011f\u0131nda, yatay ve d\u00fc\u015fey ara fonksiyonlar\u0131n\u0131n hem yerine ge\u00e7mekte hem de \u00e7ok daha ileriye g\u00f6t\u00fcrebilmektedir. \u00d6ncelikle ayr\u0131 ayr\u0131 her iki fonksiyonunun kullan\u0131m\u0131na bakal\u0131m.<\/p>\n\n\n\n<p>A\u015fa\u011f\u0131daki kullan\u0131mda \u201cIndex\u201d fonksiyonu tan\u0131ml\u0131 bir aral\u0131kta (Range A2:B3, matris olarak d\u00fc\u015f\u00fcn\u00fclebilir) belirtilen sat\u0131r ve s\u00fctundaki de\u011feri getirir.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXfGfos0Q2pNCOgy2NM1XF_wT1VdnflN2F4QQqxegTdQI9JzAdJ1VR2xbkXr0fNVKJtoyj892UrMEzTVXBf628M2NXCoqFuCqrE-Zzq5DJQP3RM_uAissP6cwCp1K9pO0qFSjaOw_j5epODHI5brL7-SNSG5?key=sxwrqVhbNIBiG1jdAiJdzw\" alt=\"\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXeJ4LnC_Tog8q_hhIpMwRmCqgigmOJFlqtVQ5a9dmlgG7wzQe6JEKU6ul94BcY3n7yxwM0890fmtPfVvi2R8ob_g1D8hO2QTVVz0WwDekySVuujdIOInXnuFYwnhQ2PFIYCm4LvJ6c9wyKUXOxo14ZgTzJo?key=sxwrqVhbNIBiG1jdAiJdzw\" alt=\"\"\/><\/figure>\n\n\n\n<p>Match komutu ise yatay ya da d\u00fc\u015fey (sat\u0131r ya da kolon) bir dizide aranan de\u011ferin s\u0131ra numaras\u0131n\u0131 getirir.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXdgHAvhEA73mS6VW2UMf20IsGuOUN6FQmwpizIo_LSG06Qgm6NGt_hINQLnq6rV54XRDhyDVxywCyMexXjuve_IUyrMjBYQfDJsYFZJEVGRQJuridV9tmbTqEJEFQNiVFfhYql4_MARfL15yvqrV3SsTtys?key=sxwrqVhbNIBiG1jdAiJdzw\" alt=\"\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXfUR_XOk__P6A1cgxzwf_qM_AbMdm7BRhpGWmUmy4mFW9dkCjBoNcOB81tfnn05e6a53rshrHdHqJ8vwCtmKBNkOqVpWvTZpNTWd4TAqGMRpW1uaNyjvJpZeFydOjFclzwdlXwigOXbcFc81pUehJqvVhsQ?key=sxwrqVhbNIBiG1jdAiJdzw\" alt=\"\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXed4RXfaUhsRrCQL8gyWC5VYEZlDxL5XVX6O9Jbz0V0ArB9-OGNMx-qCfyR7CGtCucWxNlTD3QVlBCRIQjPU92FT6tBU0YPNC8oPCmcKVBDdkUeLHbwSYrjuE88PbPc44jy5xqBzZLyW67nIa4EplJzvwlF?key=sxwrqVhbNIBiG1jdAiJdzw\" alt=\"\"\/><\/figure>\n\n\n\n<p>Match komutu da anla\u015f\u0131ld\u0131ktan sonra yap\u0131lmas\u0131 gereken i\u015flem, Index fonsiyonunun i\u00e7erisinde istenilen s\u0131ra ya da s\u00fctun numaras\u0131 veya her ikisi i\u00e7in de match fonksiyonlar\u0131n\u0131n yaz\u0131lmas\u0131d\u0131r.<\/p>\n\n\n\n<p>Detayl\u0131 bir al\u0131\u015ft\u0131rma i\u00e7in a\u015fa\u011f\u0131 adres ziyaret edilebilir.<\/p>\n\n\n\n<p><a href=\"https:\/\/exceljet.net\/articles\/index-and-match\">https:\/\/exceljet.net\/articles\/index-and-match<\/a><\/p>\n\n\n\n<p><strong><em>Textjoin<\/em><\/strong><\/p>\n\n\n\n<p>Office 365 ile kullan\u0131lmaya ba\u015flayan \u00f6nemli komutlardan birisidir. Metin birle\u015ftirme fonksiyonlar\u0131 ile benzer olmas\u0131na ra\u011fmen baz\u0131 durumlarda \u00e7ok daha pratiktir.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXf2YvkxEBaJK7f2109ubzInZf6TJdIiK3VCGZFzcGvZsDt3BeAli5cL0tY8P4rPzA3Makm6lK1z6vbxi5drNz40ImrRZ1jJhT-F-4CQNuFLEvQCJewAB-h4q5-g1fr234OxF0D6PHXPBkT8cbr6RB6P2C4?key=sxwrqVhbNIBiG1jdAiJdzw\" alt=\"\"\/><\/figure>\n\n\n\n<p>A\u015fa\u011f\u0131daki \u00f6rnekte ise birden fazla kez kendini tekrar eden s\u00fctun bilgileri bu komutla kullan\u0131larak tekrarl\u0131 veriler al\u0131nabilir.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXfcdkR_mb6c0uNSCXTD8rEKBgXtbwuC4bUyUYE7uc1WFZQi33n4gvVaXJ-YYaUR0UQDaUgKqqR-Ixj2rQi6Hkl2EqpEPszU-t34ylcaoXeysoDShjaZsXk52sg6DPdy_nLeMt-nTcO0g0Ymca-hh-kKV9yu?key=sxwrqVhbNIBiG1jdAiJdzw\" alt=\"\"\/><\/figure>\n\n\n\n<p>A\u015fa\u011f\u0131daki \u00f6rnekte, takvimdeki ilgili tarih ile i\u015f program\u0131ndaki termin tarihlerinin e\u015fle\u015fti\u011fi t\u00fcm kalemler ilgili g\u00fcn i\u00e7erisine i\u015flenmektedir.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXdFYNdxlkyYf-bHgLMC_ZPmWiAlVS3cfCPE70ZONEeuer1fdwu2fS-HidVbh5KE22fwGNsF-_bWm9lB0o3Ul0gwHi3VChslMYCBT7nSPyXLUwPR4-L_c75m8zN7Em9goif00vySB7OyMh6yBNcOVPUOlE1s?key=sxwrqVhbNIBiG1jdAiJdzw\" alt=\"\"\/><\/figure>\n\n\n\n<p><strong><em>Xlookup<\/em><\/strong><\/p>\n\n\n\n<p>Ayn\u0131 anda hem yatay hem de d\u00fc\u015fey ara fonksiyonlar\u0131n\u0131n beraber kullan\u0131labildi\u011fi olduk\u00e7a kullan\u0131\u015fl\u0131 bir fonksiyondur.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXdlYpwQQwWb-eebcjmmWZzSYiZkWgqd0dUT5UCRUcX4YXlShFfbFDfuQQlSQRcN2uDvjPff7ZRerDBBu9I0UgFKKd1GC9gB8jG2bLxYbJnFAegKMwCZlfb2nNDvbRKe3MykTMdCfZ8_t4zvHqGwe0EOUOL5?key=sxwrqVhbNIBiG1jdAiJdzw\" alt=\"\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXcRr1a0QsQaDN3GbbrfoOAprsdhlme2ilAeUvZsshfH0IFK-lEamSfQ3ANcICMQY_cD4kPIWrN-X7BZUIZ5AzGTUaZv-e0tQY725A1VM4YRxfbCf7sdH7sXHCo0vpZyrEhIorYe7EMMxOmWRrpk-hdILU-c?key=sxwrqVhbNIBiG1jdAiJdzw\" alt=\"\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXchYPMki7lUNwFQAvz94DfKUw0fUCHuRSCSuID85zu0mCd8265Eja4A7PgdNJzsHSSHWBDxc1aS3An0R3daULwlce2Tt-ojKA1wleiHm1pRezjL1kbYfh3otOjeiu_YhVKTDBIOzhKXhB8zjx6tB11fgF7e?key=sxwrqVhbNIBiG1jdAiJdzw\" alt=\"\"\/><\/figure>\n\n\n\n<p>Di\u011fer \u00f6rnekler i\u00e7in a\u015fa\u011f\u0131 linkten faydalan\u0131labilir.<\/p>\n\n\n\n<p><a href=\"https:\/\/www.youtube.com\/watch?v=4c0CLUER6nw\">https:\/\/www.youtube.com\/watch?v=4c0CLUER6nw<\/a><\/p>\n\n\n\n<p>Deprem spektrumu tan\u0131mlar\u0131nda zemin s\u0131n\u0131f\u0131na ve ivmelere ba\u011fl\u0131 olarak hesaplanan F1 ve Fs de\u011ferleri i\u00e7i\u00e7e \u201cxlookup\u201d fonsiyonlar\u0131 kullan\u0131larak, aranan ivme de\u011ferinin bir \u00fcst ve bir alt yakla\u015f\u0131m metodu ile kolayca elde edilebilir.<\/p>\n\n\n\n<p>(XLOOKUP(C11;B4:B8;XLOOKUP(C13;C3:H3;C4:H8;;-1))<\/p>\n\n\n\n<p>A\u015fa\u011f\u0131daki dosya \u00e7al\u0131\u015fma ama\u00e7l\u0131 olarak kullan\u0131labilir, ivmeler aras\u0131 enterpolasyon da ayn\u0131 h\u00fccre i\u00e7erisinde yap\u0131lm\u0131\u015ft\u0131r.<\/p>\n\n\n\n<p><a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1g0L64iGhXVT2slGdgDyY_GgzllRDCdhF\/edit?usp=drive_link&amp;ouid=115655291716434034144&amp;rtpof=true&amp;sd=true\">Spektrum TDY<\/a><\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Genel Her m\u00fchendisin olmazsa olmazlar\u0131n\u0131n en ba\u015f\u0131nda Excel gelmektedir. Yeterli bir \u00e7ok kaynak kolayl\u0131kla eri\u015filebilir oldu\u011fu i\u00e7in bu b\u00f6l\u00fcmde standart [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ub_ctt_via":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"disabled","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[1],"tags":[],"class_list":["post-430","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"featured_image_src":null,"author_info":{"display_name":"coskunfatih","author_link":"https:\/\/spectracons.com\/?author=1"},"_links":{"self":[{"href":"https:\/\/spectracons.com\/index.php?rest_route=\/wp\/v2\/posts\/430","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/spectracons.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/spectracons.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/spectracons.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/spectracons.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=430"}],"version-history":[{"count":3,"href":"https:\/\/spectracons.com\/index.php?rest_route=\/wp\/v2\/posts\/430\/revisions"}],"predecessor-version":[{"id":689,"href":"https:\/\/spectracons.com\/index.php?rest_route=\/wp\/v2\/posts\/430\/revisions\/689"}],"wp:attachment":[{"href":"https:\/\/spectracons.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=430"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/spectracons.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=430"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/spectracons.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=430"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}