{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Proje Bilgileri","S1","S2","S3","S4","S2b","S2c","S2d","S3b","S3c","S3d"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":74,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Proje Bilgileri","index":0,"n_rows":166,"n_cols":81,"rows_kept":166,"cut":false,"hidden":false,"merged":[[97,4,97,7],[97,8,97,17],[105,4,105,7],[105,8,105,27],[38,4,38,7],[38,8,38,27],[119,44,119,48],[119,40,119,43],[119,32,119,35],[119,28,119,31],[119,36,119,39],[99,8,99,17],[88,8,88,17],[112,9,118,13],[42,29,42,33],[44,29,44,33],[112,44,118,48],[44,4,44,7],[44,8,44,17],[90,8,90,17],[42,4,42,7],[112,4,118,8],[90,4,90,7],[95,4,95,7],[27,27,27,40],[29,27,29,30],[29,31,29,40],[33,8,33,17],[33,27,33,30],[33,4,33,7],[29,4,29,7],[29,8,29,17],[18,7,18,25],[31,8,31,17],[31,4,31,7],[2,3,2,42],[18,4,18,6],[16,4,16,6],[11,28,11,36],[6,3,6,14],[31,31,31,40],[27,4,27,17],[11,37,11,40],[31,27,31,30],[119,9,119,13],[119,19,119,27],[120,19,120,27],[121,2,121,3],[33,31,33,40],[42,8,42,17],[53,10,53,16],[55,10,55,13],[122,2,122,3],[11,22,11,25],[125,4,125,8],[126,2,126,3],[119,2,119,3],[120,2,120,3],[40,4,40,7],[40,8,40,27],[43,4,43,7],[16,7,16,25],[122,19,122,27],[121,4,121,8],[119,4,119,8],[120,4,120,8],[120,9,120,13],[121,19,121,27],[122,4,122,8],[123,28,123,31],[124,2,124,3],[123,4,123,8],[124,4,124,8],[125,2,125,3],[123,9,123,13],[125,28,125,31],[123,14,123,18],[123,2,123,3],[127,2,127,3],[128,2,128,3],[126,4,126,8],[127,4,127,8],[128,4,128,8],[112,28,118,31],[121,28,121,31],[121,14,121,18],[126,9,126,13],[127,9,127,13],[121,44,121,48],[53,4,53,9],[42,34,42,40],[112,40,118,43],[112,32,118,35],[112,36,118,39],[60,4,60,40],[51,10,51,16],[86,4,86,7],[88,4,88,7],[86,8,86,17],[44,34,44,40],[120,28,120,31],[120,32,120,35],[120,40,120,43],[77,42,81,48],[120,44,120,48],[120,36,120,39],[95,8,95,17],[121,36,121,39],[121,40,121,43],[51,4,51,9],[55,4,55,9],[121,9,121,13],[112,14,118,18],[112,19,118,27],[119,14,119,18],[120,14,120,18],[55,14,55,16],[99,4,99,7],[123,19,123,27],[122,9,122,13],[125,9,125,13],[122,14,122,18],[123,32,123,35],[122,32,122,35],[125,32,125,35],[121,32,121,35],[122,28,122,31],[123,36,123,39],[122,36,122,39],[123,44,123,48],[122,40,122,43],[122,44,122,48],[123,40,123,43],[124,44,124,48],[124,14,124,18],[124,19,124,27],[124,9,124,13],[124,28,124,31],[124,32,124,35],[124,36,124,39],[124,40,124,43],[125,36,125,39],[125,44,125,48],[125,14,125,18],[125,19,125,27],[125,40,125,43],[126,40,126,43],[126,44,126,48],[126,14,126,18],[126,19,126,27],[126,28,126,31],[127,40,127,43],[127,44,127,48],[127,14,127,18],[127,19,127,27],[127,28,127,31],[127,32,127,35],[127,36,127,39],[128,19,128,27],[128,9,128,13],[128,28,128,31],[128,32,128,35],[128,36,128,39],[126,32,126,35],[126,36,126,39],[165,25,165,26],[165,10,165,11],[164,21,165,21],[164,16,164,17],[140,31,140,37],[137,24,137,30],[137,31,137,37],[138,24,138,30],[139,24,139,30],[139,31,139,37],[165,31,165,32],[164,30,165,30],[165,22,165,23],[165,28,165,29],[164,24,165,24],[164,4,164,5],[164,28,164,29],[164,15,165,15],[165,4,165,5],[165,7,165,8],[164,31,164,32],[143,31,143,37],[144,24,144,30],[149,31,149,37],[149,24,149,30],[164,19,164,20],[145,24,145,30],[144,31,144,37],[151,31,151,37],[164,25,164,26],[164,34,164,35],[145,31,145,37],[152,31,152,37],[164,22,164,23],[147,31,147,37],[142,31,142,37],[150,31,150,37],[143,24,143,30],[142,5,142,23],[152,24,152,30],[165,13,165,14],[164,10,164,11],[145,5,145,23],[164,12,165,12],[152,5,152,23],[153,5,153,23],[165,19,165,20],[164,7,164,8],[164,13,164,14],[159,4,159,10],[164,18,165,18],[77,4,81,40],[70,4,72,40],[140,24,140,30],[148,24,148,30],[147,24,147,30],[164,27,165,27],[164,6,165,6],[164,9,165,9],[165,16,165,17],[138,31,138,37],[143,5,143,23],[144,5,144,23],[4,46,4,48],[70,42,72,48],[21,12,21,19],[141,31,141,37],[142,24,142,30],[128,40,128,43],[128,44,128,48],[147,5,147,23],[148,5,148,23],[151,5,151,23],[146,24,146,30],[146,31,146,37],[141,24,141,30],[46,8,46,17],[65,4,65,10],[146,5,146,23],[138,5,138,23],[139,5,139,23],[135,4,135,13],[135,14,135,16],[140,5,140,23],[141,5,141,23],[128,14,128,18],[153,31,153,37],[153,24,153,30],[154,24,154,30],[154,31,154,37],[154,5,154,23],[148,31,148,37],[151,24,151,30],[150,24,150,30],[149,5,149,23],[150,5,150,23]]}
[]
[]
[null,null,null,"PROJE TAKİP FORMU"]
[]
[null,null,null,"Bu form ODTÜ Döner Sermaye İşletmesi Müdürlüğü (DÖSİM) üzerinden yapılan projeler için gereklidir.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sözleşmeli personel için işveren hissesi:  ",0.20499999999999999,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Biyoloji Bölümü","Endüstri Ürünleri Tasarımı Bölümü","Bilgisayar Mühendisliği Bölümü",null,"İktisat Bölümü","Beden Eğitimi ve Spor Bölümü","Deniz Bilimleri Enstitüsü","Fen Edebiyat Fakültesi",{"$f":"MATCH(H17,L_Fakulte,0)","v":{"$error":"#N/A"}},null,null,null,null,"Prof. Dr.",null,null,"TL",null,{"$f":"W12=CA9","v":false}]
[null,null,null,"Formu doldururken yaşadığınız sorunları aşağıdaki adrese bildirebilirsiniz.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Felsefe Bölümü","Mimarlık Bölümü","Çevre Mühendisliği Bölümü",null,"İşletme Bölümü","Bilgisayar ve Öğretim Teknolojileri Eğitimi Bölümü","Enformatik Enstitüsü","Mimarlık Fakültesi",null,null,null,null,null,"Doç. Dr.",null,null,"USD",null,{"$f":"IF(Q_PB_Diger,IF(AL12=\"\",\"\",AL12),W12)","v":"TL"}]
[null,null,null,"abal@metu.edu.tr",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fizik Bölümü","Şehir ve Bölge Planlama Bölümü","Elektrik ve Elektronik Mühendisliği Bölümü",null,"Siyaset Bilimi ve Kamu Yönetimi Bölümü","Eğitim Bilimleri Bölümü","Fen Bilimleri Enstitüsü","Mühendislik Fakültesi",null,null,null,null,null,"Yrd. Doç. Dr.",null,null,"£"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"İstatistik Bölümü",null,"Endüstri Mühendisliği Bölümü",null,"Uluslararası İlişkiler Bölümü","Temel Eğitim Bölümü","Sosyal Bilimler Enstitüsü","İktisadi ve İdari Bilimler Fakültesi",null,null,null,null,null,"Öğr. Gör.",null,null,"Euro"]
[null,null,null,"Formu doldurmak için gerekli adımlar aşağıda sıralanmıştır. Bilgi girebileceğiniz renklendirilmiş alanlar arasında Tab ve Shift-Tab tuşları ile hareket edebilirsiniz.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kimya Bölümü",null,"Gıda Mühendisliği Bölümü",null,null,"Matematik ve Fen Bilimleri Eğitimi Bölümü","Uygulamalı Matematik Enstitüsü","Eğitim Fakültesi",null,null,null,null,null,"Okutman",null,null,"Diğer"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Moleküler Biyoloji ve Genetik Bölümü",null,"Havacılık ve Uzay Mühendisliği Bölümü",null,null,"Yabancı Diller Eğitimi Bölümü","Meslek Yüksekokulu","Diğer (Yüksek Okul, Enstitü, Araştırma Merkezi, vs.)",null,null,null,null,null,"Araş. Gör."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Matematik Bölümü",null,"İnşaat Mühendisliği Bölümü",null,null,null,"Yabancı Diller Yüksek Okulu",null,null,null,null,null,null,"Öğr. Elemanı"]
[null,null,null,"1.","Proje Takip Formunda kullanılacak para birimini seçiniz:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TL",null,null,null,null,null,{"$f":"IF(Q_PB_Diger,\"Diğer para birimini giriniz:\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Psikoloji Bölümü",null,"Jeoloji Mühendisliği Bölümü",null,null,null,"Sürekli Eğitim Merkezi"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sosyoloji Bölümü",null,"Kimya Mühendisliği Bölümü",null,null,null,"Rektörlük",null,null,null,null,null,null,null,null,null,"Ar-Ge"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tarih Bölümü",null,"Maden Mühendisliği Bölümü",null,null,null,"Müzik ve Güzel Sanatlar Bölümü",null,null,null,null,null,null,null,null,null,"Ar-Ge Değil"]
[null,null,null,"2.","Projenin yapılacağı birimi seçiniz:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Makine Mühendisliği Bölümü",null,null,null,"Türk Dili Bölümü"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Metalurji ve Malzeme Mühendisliği Bölümü",null,null,null,"Bilgi İşlem Daire Başkanlığı",null,null,null,null,null,null,null,null,null,"Kamu"]
[null,null,null,null,"Fakülte:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mühendislik Bilimleri Bölümü",null,null,null,"Sağlık, Kültür ve Spor Daire Başkanlığı",null,null,null,null,null,null,null,null,null,"Özel Sektör"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Petrol ve Doğalgaz Mühendisliği Bölümü",null,null,null,"Afet Yönetimi Uygulama ve Araştırma Merkezi (AFET)",null,null,null,null,null,null,null,null,null,"STK (Sivil Toplum Kuruluşu)"]
[null,null,null,null,"Bölüm:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ODTÜ BİLTİR Merkezi",null,null,null,null,null,null,null,null,null,"Şahıs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Biyomalzeme ve Doku Mühendisliği Uygulama ve Araştırma Merkezi (BIOMATEN)",null,null,null,null,null,null,null,null,null,"Diğer"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bilim ve Teknoloji Politikaları Araştırma Merkezi (TEKPOL)"]
[null,null,null,"3.","Proje kodunu giriniz:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Deniz Bilimleri Enstitüsü","Enstitü Müdürü",null,null,null,null,"Bilim, Teknoloji, Mühendislik ve Matematik Eğitimi Uygulama ve Araştırma Merkezi(BİLTEMM)",null,null,null,null,null,null,null,null,"Akademik",null,0.18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enformatik Enstitüsü","Enstitü Müdürü",null,null,null,null,"E-Devlet Araştırma ve Uygulama Merkezi (EDMER)",null,null,null,null,null,null,null,null,"Sözleşmeli",null,0.08]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fen Bilimleri Enstitüsü","Enstitü Müdürü",null,null,null,null,"Girişimcilik Araştırma ve Uygulama Merkezi (GİMER)",null,null,null,null,null,null,null,null,null,null,"Muaf"]
[null,null,null,"4.","Proje yöneticisi bilgilerini giriniz:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sosyal Bilimler Enstitüsü","Enstitü Müdürü",null,null,null,null,"Görsel-İşitsel Sistemler Araştırma ve Üretim Merkezi (GİSAM)",null,null,null,null,null,null,null,null,"Yönetici"]
[null,null,null,null,"(Projelerin genellikle tek yöneticisi bulunur, ancak özel durumlarda iki yönetici bulunabilir.)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uygulamalı Matematik Enstitüsü","Enstitü Müdürü",null,null,null,null,"Görüntü Analizi Uygulama ve Araştırma Merkezi (OGAM)",null,null,null,null,null,null,null,null,"Araştırmacı"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Meslek Yüksekokulu","Meslek Yüksekokulu Müdürü",null,null,null,null,"Güneş Enerjisi Uygulama ve Araştırma Merkezi (GÜNAM)",null,null,null,null,null,null,null,null,"Koordinatör"]
[null,null,null,null,"Proje Yöneticisi 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Proje Yöneticisi 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yabancı Diller Yüksek Okulu","Yabancı Diller Yüksek Okulu Müdürü",null,null,null,null,"İnsan Hakları ve Güvenliği Uluslararası Araştırma ve Uygulama Merkezi"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sürekli Eğitim Merkezi","Sürekli Eğitim Merkezi Müdürü",null,null,null,null,"İnşaat Sektörü Eğitim Araştırma Merkezi (ISEM)",null,null,null,null,null,null,null,null,"Saat"]
[null,null,null,null,"Ünvanı:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ünvanı:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rektörlük","Rektör",null,null,null,null,"Karadeniz ve Orta Asya Ülkeleri Araştırma Merkezi (KORA)",null,null,null,null,null,null,null,null,"Gün"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Müzik ve Güzel Sanatlar Bölümü","Bölüm Başkanı",null,null,null,null,"Kaynak Teknolojisi ve Tahribatsiz Muayene Araştırma Merkezi (KAYNAK)",null,null,null,null,null,null,null,null,"Ay"]
[null,null,null,null,"Adı:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adı:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Türk Dili Bölümü","Bölüm Başkanı",null,null,null,null,"Konfüçyus Uygulama ve Araştırma Merkezi",null,null,null,null,null,null,null,null,"Yıl"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bilgi İşlem Daire Başkanlığı","Daire Başkanı",null,null,null,null,"Merkez Laboratuvarı"]
[null,null,null,null,"Soyadı:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Soyadı:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sağlık, Kültür ve Spor Daire Başkanlığı","Daire Başkanı",null,null,null,null,"AR-GE Eğitim ve Ölçme Merkezi"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Afet Yönetimi Uygulama ve Araştırma Merkezi (AFET)","Merkez Başkanı",null,null,null,null,"Moleküler Biyoloji ve Biyoteknoloji AR-GE Merkezi"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ODTÜ BİLTİR Merkezi","Merkez Başkanı",null,null,null,null,"ODTÜ GAP Araştırma Merkezi (GAP)"]
[null,null,null,"5.","Projeyi destekleyen kuruluşla ilgili bilgileri giriniz:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Biyomalzeme ve Doku Mühendisliği Uygulama ve Araştırma Merkezi (BIOMATEN)","Merkez Başkanı",null,null,null,null,"Mikro-Elektro-Mekanik Sistemler Araştırma ve Uygulama Merkezi (ODTÜ-MEMS)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bilim ve Teknoloji Politikaları Araştırma Merkezi (TEKPOL)","Merkez Başkanı",null,null,null,null,"ODTÜ - PIGM Petrol Araştırma Merkezi (PAL)"]
[null,null,null,null,"Kuruluş adı:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E-Devlet Araştırma ve Uygulama Merkezi (EDMER)","Merkez Başkanı",null,null,null,null,"ODTÜ - TSK Modelleme ve Simülasyon Merkezi (MODSIM)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Girişimcilik Araştırma ve Uygulama Merkezi (GİMER)","Merkez Başkanı",null,null,null,null,"Rüzgar Enerjisi Teknolojileri Uygulama ve Araştırma Merkezi (RÜZGEM)"]
[null,null,null,null,"Adresi:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Görsel-İşitsel Sistemler Araştırma ve Üretim Merkezi (GİSAM)","Merkez Başkanı",null,null,null,null,"Tarihsel Çevre Değerlerini Araştırma ve Uygulama Merkezi (TAÇDAM)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Görüntü Analizi Uygulama ve Araştırma Merkezi (OGAM)","Merkez Başkanı",null,null,null,null,"Toplum Bilim Uygulama ve Araştırma Merkezi (TBM)"]
[null,null,null,null,"Telefon 1:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vergi Dairesi:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Güneş Enerjisi Uygulama ve Araştırma Merkezi (GÜNAM)","Merkez Başkanı",null,null,null,null,"Uygulamalı Etik Araştırma Merkezi (UEAM)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"İnsan Hakları ve Güvenliği Uluslararası Araştırma ve Uygulama Merkezi","Merkez Başkanı",null,null,null,null,"Yapılı Çevre ve Tasarım Uygulama ve Araştırma Merkezi (YTM-MATPUM)"]
[null,null,null,null,"Telefon 2:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vergi Numarası:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"İnşaat Sektörü Eğitim Araştırma Merkezi (ISEM)","Merkez Başkanı"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Karadeniz ve Orta Asya Ülkeleri Araştırma Merkezi (KORA)","Merkez Başkanı"]
[null,null,null,null,"Kuruluş tipi:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kaynak Teknolojisi ve Tahribatsiz Muayene Araştırma Merkezi (KAYNAK)","Merkez Başkanı"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Konfüçyus Uygulama ve Araştırma Merkezi","Merkez Başkanı"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Merkez Laboratuvarı","Merkez Laboratuvar Müdürü"]
[null,null,null,"6.","Projenin başlangıç ve bitiş tarihleri ile süresini giriniz:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AR-GE Eğitim ve Ölçme Merkezi","Merkez Başkanı"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Moleküler Biyoloji ve Biyoteknoloji AR-GE Merkezi","Merkez Başkanı"]
[null,null,null,null,"Başlangıç Tarihi:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ODTÜ GAP Araştırma Merkezi (GAP)","Merkez Başkanı"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mikro-Elektro-Mekanik Sistemler Araştırma ve Uygulama Merkezi (ODTÜ-MEMS)","Merkez Başkanı"]
[null,null,null,null,"Bitiş Tarihi:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ODTÜ - PIGM Petrol Araştırma Merkezi (PAL)","Merkez Başkanı"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ODTÜ - TSK Modelleme ve Simülasyon Merkezi (MODSIM)","Merkez Başkanı"]
[null,null,null,null,"Süresi:",null,null,null,null,null,null,null,null,null,"Ay",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rüzgar Enerjisi Teknolojileri Uygulama ve Araştırma Merkezi (RÜZGEM)","Merkez Başkanı"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tarihsel Çevre Değerlerini Araştırma ve Uygulama Merkezi (TAÇDAM)","Merkez Başkanı"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Toplum Bilim Uygulama ve Araştırma Merkezi (TBM)","Merkez Başkanı"]
[null,null,null,"7.","Projenin başlığını yazınız:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uygulamalı Etik Araştırma Merkezi (UEAM)","Merkez Başkanı"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yapılı Çevre ve Tasarım Uygulama ve Araştırma Merkezi (YTM-MATPUM)","Merkez Başkanı"]
[]
[]
[]
[null,null,null,"8.","Projenin Ar-Ge içeriği olup olmadığını belirtiniz:"]
[]
[]
[]
[]
[null,null,null,"9.","Projenin özetini yazınız:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(LEN(ProjeOzeti)>390,\"Lütfen proje özetini forma sığabilmesi için kısaltınız.\",\"\")","v":""}]
[]
[]
[]
[]
[null,null,null,"10.","Sözleşme konusunu ve kapsamını (özet olarak) yazınız:"]
[null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(LEN(Konusu)>600,\"Lütfen sözleşme konusunu forma sığabilmesi için kısaltınız.\",\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[null,null,null,"11.",{"$f":"IF(ISERROR(IF(BS5<6,\"Projeyi onaylayacak fakülte dekanının\",VLOOKUP(H19,BK22:BL60,2,0))&\" (veya yerine vekalet eden kişinin) bilgilerini giriniz:\"),\"Lütfen 2. maddeyi kontrol ediniz, fakülte ve bölüm uyuşmuyor.\",IF(BS5<6,\"Projeyi onaylayacak fakülte dekanının\",VLOOKUP(H19,BK22:BL60,2,0))&\" (veya yerine vekalet eden kişinin) bilgilerini giriniz:\")","v":"Lütfen 2. maddeyi kontrol ediniz, fakülte ve bölüm uyuşmuyor."}]
[]
[null,null,null,null,"Ünvanı:"]
[]
[null,null,null,null,"Adı:"]
[]
[null,null,null,null,"Soyadı:"]
[]
[]
[null,null,null,"12.",{"$f":"IF(BS5<6,\"Projeyi onaylayacak bölüm başkanının (veya dengi birim yöneticisinin) bilgilerini giriniz:\",\"Bu adımı atlayınız.\")","v":{"$error":"#N/A"}}]
[]
[null,null,null,null,{"$f":"IF(E94=\"Bu adımı atlayınız.\",\"\",\"Ünvanı:\")","v":{"$error":"#N/A"}}]
[]
[null,null,null,null,{"$f":"IF(E94=\"Bu adımı atlayınız.\",\"\",\"Adı:\")","v":{"$error":"#N/A"}}]
[]
[null,null,null,null,{"$f":"IF(E94=\"Bu adımı atlayınız.\",\"\",\"Soyadı:\")","v":{"$error":"#N/A"}}]
[]
[]
[null,null,null,"13.","Proje raporlarının teslim edileceği kurumu belirtiniz:"]
[null,null,null,null,"(Raporlar genellikle projeyi destekleyen kuruluşa gönderilir.)"]
[]
[null,null,null,null,"Kuruluş adı:",null,null,null,{"$f":"TedAdi","v":0}]
[]
[]
[null,null,null,"14.","Projede görev alacak akademik, idari ve sözleşmeli personel bilgilerini giriniz:"]
[null,null,null,null,"(Bu formu kullanarak projeye en fazla 100 akademik ve 60 sözleşmeli personel ekleyebilirsiniz. Bu sayı yetersizse lütfen DÖSİM'e bildiriniz.)"]
[]
[]
[null,null,null,null,"Projedeki Görevi",null,null,null,null,{"$f":"\"Personel\"&CHAR(10)&\"Tipi\"","v":"Personel\nTipi"},null,null,null,null,"Ünvanı",null,null,null,null,"Adı Soyadı",null,null,null,null,null,null,null,null,{"$f":"\"Alacağı\"&CHAR(10)&\"Brüt Ücret\"&CHAR(10)&\"(\"&ParaBirimi&\"/Ay)\"","v":"Alacağı\nBrüt Ücret\n(TL/Ay)"},null,null,null,{"$f":"\"İşveren Hisseleri\"&CHAR(10)&\"(Sözleşmeli)\"&CHAR(10)&\"(\"&ParaBirimi&\"/Ay)\"","v":"İşveren Hisseleri\n(Sözleşmeli)\n(TL/Ay)"},null,null,null,{"$f":"\"Proje Hesabına Masraf Kaydedile-cek Tutar\"&CHAR(10)&\"(Sözleşmeli)\"&CHAR(10)&\"(\"&ParaBirimi&\"/Ay)\"","v":"Proje Hesabına Masraf Kaydedile-cek Tutar\n(Sözleşmeli)\n(TL/Ay)"},null,null,null,{"$f":"\"Projedeki Görev Süresi\"&CHAR(10)&\"(Ay)\"","v":"Projedeki Görev Süresi\n(Ay)"},null,null,null,{"$f":"\"Proje Maliyetine Girecek Tutar\"&CHAR(10)&\"(\"&ParaBirimi&\")\"","v":"Proje Maliyetine Girecek Tutar\n(TL)"}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"k","t",null,"t","s","k",1,2,3]
[null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AC120=\"\",\"\",AC120*IsverenHissesi)","v":""},null,null,null,{"$f":"IF(BA120,SUM(AC120:AG120),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(BA120,AK120*AO120,AC120*AO120)","v":0},null,null,null,null,null,null,null,{"$f":"J120=\"Sözleşmeli\"","v":false},{"$f":"IF(J120=\"\",0,IF(BA120,3,IF(J120=\"Akademik\",1,2)))","v":0},{"$f":"AS120","v":0},"Aka",{"$f":"DSUM(VT_Personel,\"t\",BG119:BG120)","v":0},{"$f":"COUNTIF(J120:N129,\"Akademik\")","v":0},1,{"$f":"IF($BB120=1,1,0)","v":0},{"$f":"IF($BB120=2,1,0)","v":0},{"$f":"IF($BB120=3,1,0)","v":0}]
[null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,false,0,0,"İda",{"$f":"DSUM(VT_Personel,\"t\",BG119:BG121)-BE120","v":0},{"$f":"COUNTIF(J120:N129,\"İdari\")","v":0},2,{"$f":"IF($BB121=1,BH120+1,0)","v":0},{"$f":"IF($BB121=2,BI120+1,0)","v":0},{"$f":"IF($BB121=3,BJ120+1,0)","v":0}]
[null,null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,false,0,0,"Söz",{"$f":"DSUM(VT_Personel,\"t\",BG119:BG122)-BE121-BE120","v":0},{"$f":"COUNTIF(J120:N129,\"Sözleşmeli\")","v":0},3,{"$f":"IF($BB122=1,MAX(BH$120:BH121)+1,0)","v":0},{"$f":"IF($BB122=2,MAX(BI$120:BI121)+1,0)","v":0},{"$f":"IF($BB122=3,MAX(BJ$120:BJ121)+1,0)","v":0}]
[null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,false,0,0,null,null,null,null,{"$f":"IF($BB123=1,MAX(BH$120:BH122)+1,0)","v":0},{"$f":"IF($BB123=2,MAX(BI$120:BI122)+1,0)","v":0},{"$f":"IF($BB123=3,MAX(BJ$120:BJ122)+1,0)","v":0}]
[null,null,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,false,0,0,null,null,null,null,{"$f":"IF($BB124=1,MAX(BH$120:BH123)+1,0)","v":0},{"$f":"IF($BB124=2,MAX(BI$120:BI123)+1,0)","v":0},{"$f":"IF($BB124=3,MAX(BJ$120:BJ123)+1,0)","v":0}]
[null,null,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,false,0,0,null,null,null,null,{"$f":"IF($BB125=1,MAX(BH$120:BH124)+1,0)","v":0},{"$f":"IF($BB125=2,MAX(BI$120:BI124)+1,0)","v":0},{"$f":"IF($BB125=3,MAX(BJ$120:BJ124)+1,0)","v":0}]
[null,null,7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,false,0,0,null,null,null,null,{"$f":"IF($BB126=1,MAX(BH$120:BH125)+1,0)","v":0},{"$f":"IF($BB126=2,MAX(BI$120:BI125)+1,0)","v":0},{"$f":"IF($BB126=3,MAX(BJ$120:BJ125)+1,0)","v":0}]
[null,null,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,false,0,0,null,null,null,null,{"$f":"IF($BB127=1,MAX(BH$120:BH126)+1,0)","v":0},{"$f":"IF($BB127=2,MAX(BI$120:BI126)+1,0)","v":0},{"$f":"IF($BB127=3,MAX(BJ$120:BJ126)+1,0)","v":0}]
[null,null,9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,false,0,0,null,null,null,null,{"$f":"IF($BB128=1,MAX(BH$120:BH127)+1,0)","v":0},{"$f":"IF($BB128=2,MAX(BI$120:BI127)+1,0)","v":0},{"$f":"IF($BB128=3,MAX(BJ$120:BJ127)+1,0)","v":0}]
[null,null,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,false,0,0,null,null,null,null,{"$f":"IF($BB129=1,MAX(BH$120:BH128)+1,0)","v":0},{"$f":"IF($BB129=2,MAX(BI$120:BI128)+1,0)","v":0},{"$f":"IF($BB129=3,MAX(BJ$120:BJ128)+1,0)","v":0}]
[]
[]
[null,null,null,"15.","Proje maliyet tablosunu doldurunuz:"]
[null,null,null,null,"(3. ve 4. meddelerdeki personel ücretleri 14. maddeden otomatik olarak aktarılacaktır.)"]
[null,null,null,null,"(Maliyet tablosunu doldurmak için 3521 numaralı telefonu arayarak Avni Bal'dan yardım alabilirsiniz.)"]
[]
[null,null,null,null,"Proje için K.D.V. oranını giriniz:",null,null,null,null,null,null,null,null,null,0.18]
[]
[null,null,null,null,"GİDERLER",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ParaBirimi","v":"TL"},null,null,null,null,null,null,"YÜZDE"]
[null,null,null,null,"1.","Demirbaş alımları",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($Y$153=\"\",$Y$153=0),\"\",IF(Y139/$Y$153=0,\"\",Y139/$Y$153))","v":""}]
[null,null,null,null,"2.","Dış kurumlardan satın alınan hizmetler",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"3.","Akademik personel ödemeleri",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Aka_Toplam","v":0},null,null,null,null,null,null,""]
[null,null,null,null,"4.","Sözleşmeli personel ödemeleri",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Soz_Toplam","v":0},null,null,null,null,null,null,""]
[null,null,null,null,"5.","Yurtiçi ve yurtdışı seyahat masrafları",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,"6.","Sarf malzemesi alımları",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,"ARA TOPLAM = (1) + (2) + (3) + (4) + (5) + (6)      ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Y139:Y144)","v":0},null,null,null,null,null,null,""]
[null,null,null,null,null,"A = TOPLAM PROJE MALİYETİ (K.D.V. HARİÇ) - (1) / 0,94      ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y153-Y139/0.94","v":0}]
[null,null,null,null,"7.","Üniversite genel masraf payı = A x (%19,5) + [ (1) / 0,94 - (1) ]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y146*0.195+Y139*0.06/0.94","v":0},null,null,null,null,null,null,{"$f":"IF(OR($Y$153=\"\",$Y$153=0),\"\",IF(Y147/$Y$153=0,\"\",Y147/$Y$153))","v":""}]
[null,null,null,null,"8.","Fakülte payı = A x (%4,25)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Fakulte=\"Diğer (Yüksek Okul, Enstitü, Araştırma Merkezi, vs.)\",0,0.0425*Y146)","v":0},null,null,null,null,null,null,""]
[null,null,null,null,"9.","Bölüm payı = A x (%4,25)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Fakulte=\"Diğer (Yüksek Okul, Enstitü, Araştırma Merkezi, vs.)\",0,0.0425*Y146)","v":0},null,null,null,null,null,null,""]
[null,null,null,null,"10.","İlgi SEM veya YDYO payı = A x (%8,5)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Fakulte=\"Diğer (Yüksek Okul, Enstitü, Araştırma Merkezi, vs.)\",OR(Bolum=\"Yabancı Diller Yüksek Okulu\",Bolum=\"Sürekli Eğitim Merkezi\")),0.085*Y146,0)","v":0},null,null,null,null,null,null,""]
[null,null,null,null,"11.","Araştırma merkezi veya enstitü payı = A x (%8,5)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Fakulte=\"Diğer (Yüksek Okul, Enstitü, Araştırma Merkezi, vs.)\",NOT(Bolum=\"Rektörlük\"),NOT(Bolum=\"Yabancı Diller Yüksek Okulu\"),NOT(Bolum=\"Sürekli Eğitim Merkezi\")),Y146*0.085,0)","v":0},null,null,null,null,null,null,""]
[null,null,null,null,"12.","Öğretim üyesi payı = A x (%8)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y146*0.08","v":0},null,null,null,null,null,null,""]
[null,null,null,null,null,"TOPLAM PROJE MALİYETİ (K.D.V. HARİÇ)      ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Y140:AE144)/0.64+Y139/0.94","v":0}]
[null,null,null,null,null,"K.D.V. (genellikle SEM ve YDYO için %8, diğerleri için %18)      ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(KDV=\"Muaf\",\"Muaf\",Y153*KDV)","v":0}]
[null,null,null,null,null,"TOPLAM PROJE MALİYETİ (K.D.V. DAHİL)      ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(KDV=\"Muaf\",Y153,Y153+Y154)","v":0}]
[]
[]
[null,null,null,"16.","Sözleşme tanzim tarihini yazınız:"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S2","S3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Aka_Sayi<=25,1,IF(Aka_Sayi<=50,2,IF(Aka_Sayi<=75,3,4)))","v":1},{"$f":"IF(Soz_Sayi<=15,1,IF(Soz_Sayi<=30,2,IF(Soz_Sayi<=45,3,4)))","v":1}]
[null,null,null,"►","Bilgilerini girdiğiniz projenin Takip Formunu almak için sırası ile işaretlenmiş sayfaları yazdırınız:"]
[]
[null,null,null,null,"S1",null,null,"S2",null,null,"S2b",null,null,"S2c",null,null,"S2d",null,null,"S3",null,null,"S3b",null,null,"S3c",null,null,"S3d",null,null,"S4"]
[null,null,null,null,"ü",null,null,"ü",null,null,{"$f":"IF(BB162>=2,\"ü\",\"\")","v":""},null,null,{"$f":"IF(BB162>=3,\"ü\",\"\")","v":""},null,null,{"$f":"IF(BB162>=4,\"ü\",\"\")","v":""},null,null,"ü",null,null,{"$f":"IF(BC162>=2,\"ü\",\"\")","v":""},null,null,{"$f":"IF(BC162>=3,\"ü\",\"\")","v":""},null,null,{"$f":"IF(BC162>=4,\"ü\",\"\")","v":""},null,null,"ü"]

{"sheet":"S1","index":1,"n_rows":42,"n_cols":32,"rows_kept":42,"cut":false,"hidden":false,"merged":[[41,2,43,13],[41,14,43,22],[41,27,41,31],[37,27,37,31],[39,27,39,31],[27,2,31,31],[32,12,32,19],[33,12,33,19],[34,12,34,19],[14,2,16,31],[4,6,6,29],[8,1,8,32],[10,2,10,20],[10,26,10,31]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sayfa 1"]
[]
[]
[null,null,null,null,null,null,"T.C. ORTA DOĞU TEKNİK ÜNİVERSİTESİ\nDÖNER SERMAYE İŞLETMESİ"]
[]
[]
[]
[null,"TAKİP FORMU"]
[]
[null,null,{"$f":"\"Proje Kodu: \"&IF(ProjeKodu=\"\",\"\",ProjeKodu)","v":"Proje Kodu: "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tarih:",{"$f":"TODAY()","v":"2018-09-19"}]
[]
[null,null,"Rektörlük (Döner Sermaye İşletmesi Müdürlüğü)"]
[]
[null,null,"Fakültemiz öğretim üyelerince hazırlanan aşağıda kayıtlı araştırma proje sözleşmesi, ek sözleşme ve proje özeti ilişikte sunulmuştur. İlgili bölüm ve fakültemiz tarafından uygun görülen projeyi gereği için incelemenize saygı ile arz ederim."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Proje Bilgileri'!BS5<6,\"Fakülte Dekanı\",VLOOKUP('Proje Bilgileri'!H19,'Proje Bilgileri'!BK22:BL60,2,0))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(O1_Unvan=\"\",O1_Ad=\"\"),\"\",O1_Unvan)&\" \"&IF(O1_Ad=\"\",\"\",PROPER(O1_Ad))&\" \"&IF(O1_Soyad=\"\",\"\",UPPER(O1_Soyad))","v":"  "}]
[]
[]
[null,null,"Ek: Proje Sözleşmesi ve Ek Sözleşme"]
[]
[null,null,{"$f":"\"Proje Başlığı: \"&IF(ProjeAdi=\"\",\"\",ProjeAdi)","v":"Proje Başlığı: "}]
[null,null,{"$f":"\"Projeyi Destekleyen Kuruluş: \"&IF(TedAdi=\"\",\"\",TedAdi)","v":"Projeyi Destekleyen Kuruluş: "}]
[null,null,{"$f":"IF(KurulusTipi=\"Kamu\",\"þ\",\"o\")","v":"o"}," Kamu",null,null,null,{"$f":"IF(KurulusTipi=\"Özel Sektör\",\"þ\",\"o\")","v":"o"}," Özel Sektör",null,null,null,null,null,{"$f":"IF(KurulusTipi=\"STK (Sivil Toplum Kuruluşu)\",\"þ\",\"o\")","v":"o"}," STK",null,null,null,{"$f":"IF(KurulusTipi=\"Şahıs\",\"þ\",\"o\")","v":"o"}," Şahıs",null,null,null,{"$f":"IF(KurulusTipi=\"Diğer\",\"þ\",\"o\")","v":"o"}," Diğer"]
[null,null,{"$f":"IF(ArGe=\"Ar-Ge\",\"þ\",\"o\")","v":"o"}," Ar-Ge",null,null,null,{"$f":"IF(ArGe=\"Ar-Ge Değil\",\"þ\",\"o\")","v":"o"}," Ar-Ge Değil"]
[null,null,{"$f":"\"Proje Özeti: \"&IF(ProjeOzeti=\"\",\"\",ProjeOzeti)","v":"Proje Özeti: "},{"$f":"\"Proje Başlığı: \"&IF(ProjeAdi=\"\",\"\",ProjeAdi)","v":"Proje Başlığı: "},"Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ",{"$f":"\"Proje Başlığı: \"&IF(ProjeAdi=\"\",\"\",ProjeAdi)","v":"Proje Başlığı: "},"Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ",{"$f":"\"Proje Başlığı: \"&IF(ProjeAdi=\"\",\"\",ProjeAdi)","v":"Proje Başlığı: "},"Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: "]
[null,null,{"$f":"\"Proje Başlığı: \"&IF(ProjeAdi=\"\",\"\",ProjeAdi)","v":"Proje Başlığı: "},"Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: "]
[null,null,{"$f":"\"Proje Başlığı: \"&IF(ProjeAdi=\"\",\"\",ProjeAdi)","v":"Proje Başlığı: "},"Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: "]
[null,null,{"$f":"\"Proje Başlığı: \"&IF(ProjeAdi=\"\",\"\",ProjeAdi)","v":"Proje Başlığı: "},"Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: "]
[null,null,{"$f":"\"Proje Başlığı: \"&IF(ProjeAdi=\"\",\"\",ProjeAdi)","v":"Proje Başlığı: "},"Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: ","Proje Başlığı: "]
[null,null,"Araştırma Başlangıç Tarihi:",null,null,null,null,null,null,null,null,null,{"$f":"IF(Baslangic=\"\",\"\",Baslangic)","v":""}]
[null,null,"Araştırma Bitiş Tarihi:",null,null,null,null,null,null,null,null,null,{"$f":"IF(Bitis=\"\",\"\",Bitis)","v":""}]
[null,null,"Araştırma Süresi:",null,null,null,null,null,null,null,null,null,{"$f":"IF(Sure1=\"\",\"\",Sure1)&\" \"&IF(Sure2=\"\",\"\",Sure2)","v":" Ay"}]
[]
[null,null,"Proje Yöneticisi",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"İmza",null,null,null,"Tarih"]
[null,null,{"$f":"IF(PY1_Unvan=\"\",\"\",PY1_Unvan)&\" \"&IF(PY1_Ad=\"\",\"\",PROPER(PY1_Ad))&\" \"&IF(PY1_Soyad=\"\",\"\",UPPER(PY1_Soyad))","v":"  "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2018-09-19"}]
[]
[null,null,{"$f":"IF(OR(PY2_Unvan=\"\",PY2_Ad=\"\"),\"\",PY2_Unvan)&\" \"&IF(PY2_Ad=\"\",\"\",PROPER(PY2_Ad))&\" \"&IF(PY2_Soyad=\"\",\"\",UPPER(PY2_Soyad))","v":"  "}]
[null,null,"Bölüm",null,null,null,null,null,null,null,null,null,null,null,"Başkan",null,null,null,null,null,null,null,null,"İmza",null,null,null,"Tarih"]
[null,null,{"$f":"IF(Fakulte=\"Diğer (Yüksek Okul, Enstitü, Araştırma Merkezi, vs.)\",IF(Bolum=\"\",\"\",Bolum),IF(Fakulte=\"\",\"\",Fakulte))&CHAR(10)&IF(Fakulte=\"Diğer (Yüksek Okul, Enstitü, Araştırma Merkezi, vs.)\",\"\",IF(Bolum=\"\",\"\",Bolum))","v":"\n"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Fakulte=\"Diğer (Yüksek Okul, Enstitü, Araştırma Merkezi, vs.)\",AF19,IF(OR(O2_Unvan=\"\",O2_Ad=\"\"),\"\",O2_Unvan)&\" \"&IF(O2_Ad=\"\",\"\",PROPER(O2_Ad))&\" \"&IF(O2_Soyad=\"\",\"\",UPPER(O2_Soyad)))","v":"  "},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2018-09-19"}]

{"sheet":"S2","index":2,"n_rows":43,"n_cols":32,"rows_kept":43,"cut":false,"hidden":false,"merged":[[19,1,19,16],[19,17,19,22],[19,23,19,26],[19,27,19,32],[18,1,18,16],[18,17,18,22],[18,23,18,26],[18,27,18,32],[17,1,17,16],[17,17,17,22],[17,23,17,26],[17,27,17,32],[16,1,16,16],[16,17,16,22],[16,27,16,32],[16,23,16,26],[3,2,10,31],[42,1,48,32],[11,1,11,32],[12,1,15,16],[12,27,12,32],[12,23,12,26],[12,17,12,22],[13,27,15,32],[13,23,15,26],[13,17,15,22],[21,1,21,16],[21,17,21,22],[21,23,21,26],[21,27,21,32],[20,1,20,16],[20,17,20,22],[20,23,20,26],[20,27,20,32],[23,1,23,16],[23,17,23,22],[23,23,23,26],[23,27,23,32],[22,1,22,16],[22,17,22,22],[22,23,22,26],[22,27,22,32],[25,1,25,16],[25,17,25,22],[25,23,25,26],[25,27,25,32],[24,1,24,16],[24,17,24,22],[24,23,24,26],[24,27,24,32],[27,1,27,16],[27,17,27,22],[27,23,27,26],[27,27,27,32],[26,1,26,16],[26,17,26,22],[26,23,26,26],[26,27,26,32],[32,23,32,26],[32,27,32,32],[31,1,31,16],[31,17,31,22],[31,23,31,26],[31,27,31,32],[34,23,34,26],[34,27,34,32],[33,1,33,16],[33,17,33,22],[33,23,33,26],[33,27,33,32],[35,23,35,26],[35,27,35,32],[36,1,36,16],[36,17,36,22],[36,23,36,26],[36,27,36,32],[37,23,37,26],[37,27,37,32],[40,1,40,16],[40,17,40,22],[40,23,40,26],[40,27,40,32],[38,23,38,26],[38,27,38,32],[30,1,30,16],[30,17,30,22],[37,1,37,16],[37,17,37,22],[35,1,35,16],[35,17,35,22],[34,1,34,16],[34,17,34,22],[32,1,32,16],[32,17,32,22],[28,23,28,26],[28,27,28,32],[29,1,29,16],[29,17,29,22],[29,23,29,26],[29,27,29,32],[28,1,28,16],[28,17,28,22],[30,23,30,26],[30,27,30,32],[41,1,41,26],[41,27,41,32],[39,1,39,16],[39,17,39,22],[39,23,39,26],[39,27,39,32],[38,1,38,16],[38,17,38,22]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Sayfa 2\"&IF(Aka_Sayi>25,\"-a\",\"\")","v":"Sayfa 2"}]
[null,null,"Sözleşme Konusu ve Kapsamı (Özet Olarak):"]
[null,null,{"$f":"IF(Konusu=\"\",\"\",Konusu)","v":""}]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"\"TABLO 1\"&IF(Aka_Sayi>25,\"-a\",\"\")&\": PROJEDE GÖREV ALAN ÜNİVERSİTE AKADEMİK PERSONELİ VE İLGİLİ ÖDEMELER\"","v":"TABLO 1: PROJEDE GÖREV ALAN ÜNİVERSİTE AKADEMİK PERSONELİ VE İLGİLİ ÖDEMELER"}]
[null,"Ünvanı\nAdı Soyadı\nProjedeki Görevi",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,2,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Alacağı Brüt Ücret*\"&CHAR(10)&\"(\"&ParaBirimi&\"/Ay)\"","v":"Alacağı Brüt Ücret*\n(TL/Ay)"},null,null,null,null,null,"Projedeki\nGörev Süresi\n(Ay)",null,null,null,{"$f":"\"Proje Maliyetine\"&CHAR(10)&\"Girecek Tutar\"&CHAR(10)&\"(\"&ParaBirimi&\")\"","v":"Proje Maliyetine\nGirecek Tutar\n(TL)"}]
[]
[]
[1,{"$f":"IF(Aka_Sayi>=A17,IF(INDEX(VTL_Unvan,MATCH(A17,L_1,0),1)=\"\",\"\",INDEX(VTL_Unvan,MATCH(A17,L_1,0),1))&\" \"&IF(INDEX(VTL_AdSoyad,MATCH(A17,L_1,0),1)=\"\",\"\",PROPER(INDEX(VTL_AdSoyad,MATCH(A17,L_1,0),1)))&\", \"&IF(INDEX(VTL_Gorev,MATCH(A17,L_1,0),1)=\"\",\"\",INDEX(VTL_Gorev,MATCH(A17,L_1,0),1)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Aka_Sayi>=A17,IF(INDEX(VTL_T1,MATCH(A17,L_1,0),1)=\"\",\"\",INDEX(VTL_T1,MATCH(A17,L_1,0),1)),\"\")","v":""},null,null,null,null,null,{"$f":"IF(Aka_Sayi>=A17,IF(INDEX(VTL_T4,MATCH(A17,L_1,0),1)=\"\",\"\",INDEX(VTL_T4,MATCH(A17,L_1,0),1)),\"\")","v":""},null,null,null,{"$f":"IF(Aka_Sayi>=A17,IF(INDEX(VTL_T5,MATCH(A17,L_1,0),1)=\"\",\"\",INDEX(VTL_T5,MATCH(A17,L_1,0),1)),\"\")","v":""}]
[2,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[3,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[4,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[5,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[6,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[7,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[8,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[9,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[10,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[11,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[12,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[13,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[14,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[15,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[16,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[17,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[18,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[19,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[20,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[21,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[22,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[23,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[24,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[25,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[null,"PROJE MALİYETİNE GİRECEK TOPLAM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AB17:AG41)","v":0}]
[null,"* (1) Gelir getiren görevlerde çalışan öğretim üyeleri ve görevlileri için ek ödeme matrahının yüzde 800'ünü, araştırma görevlileri için yüzde 500'ünü; bu görevlerde çalışmakla birlikte gelire katkısı olmayan öğretim üyeleri ve görevlileri için yüzde 600'ünü, araştırma görevlileri için yüzde 300'ünü geçemez. Ek ödeme matrahı, aylık (ek gösterge dahil), yan ödeme, ödenek (geliştirme ödeneği hariç) ve her türlü tazminat (makam, temsil ve görev, dil tazminatları hariç) toplamından oluşur. (2) 657 sayılı Devlet Memurları Kanununa tabi personel ile aynı Kanunun 4'üncü maddesinin (B) bendine göre sözleşmeli olarak çalışan personel için ek ödeme matrahının yüzde 150'sini geçemez. Sözleşmeli personel ek ödeme matrahı, sözleşmeli personelin çalıştığı birim ve bulunduğu pozisyon ünvanı itibarıyla aynı veya benzer ünvanlı memur kadrosunda çalışan, hizmet yılı ve öğrenim durumu aynı olan emsali personel dikkate alınarak belirlenir. Emsali bulunmayan sözleşmeli personelin ek ödeme matrahı ise brüt sözleşme ücretinin yüzde 25'ini geçemez. (3) Mesai saatleri dışında gelir getirici çalışmalarından doğan katkılarına karşılık olarak, (1)'de belirtilen personel için yüzde 50'sini, (2)'de belirtilen personel için yüzde 20'sini geçmeyecek şekilde ayrıca aylık ek ödeme yapılabilir."]

{"sheet":"S3","index":3,"n_rows":27,"n_cols":32,"rows_kept":27,"cut":false,"hidden":false,"merged":[[3,1,3,32],[5,10,9,14],[4,10,4,14],[4,15,4,19],[5,15,9,19],[4,20,4,24],[5,20,9,24],[4,28,4,32],[5,28,9,32],[4,25,4,27],[5,25,9,27],[4,1,9,9],[10,1,10,9],[11,1,11,9],[12,1,12,9],[13,1,13,9],[12,15,12,19],[11,15,11,19],[11,20,11,24],[11,25,11,27],[22,1,22,9],[17,1,17,9],[23,1,23,9],[20,1,20,9],[21,1,21,9],[12,10,12,14],[18,1,18,9],[19,1,19,9],[14,1,14,9],[15,1,15,9],[16,1,16,9],[14,25,14,27],[14,28,14,32],[24,1,24,9],[10,28,10,32],[10,25,10,27],[10,20,10,24],[10,15,10,19],[10,10,10,14],[11,10,11,14],[11,28,11,32],[12,28,12,32],[12,20,12,24],[12,25,12,27],[16,25,16,27],[16,28,16,32],[13,10,13,14],[13,15,13,19],[13,20,13,24],[13,25,13,27],[13,28,13,32],[14,10,14,14],[14,15,14,19],[14,20,14,24],[18,25,18,27],[18,28,18,32],[15,10,15,14],[15,15,15,19],[15,20,15,24],[15,25,15,27],[15,28,15,32],[16,10,16,14],[16,15,16,19],[16,20,16,24],[20,25,20,27],[20,28,20,32],[17,10,17,14],[17,15,17,19],[17,20,17,24],[17,25,17,27],[17,28,17,32],[18,10,18,14],[18,15,18,19],[18,20,18,24],[22,25,22,27],[22,28,22,32],[19,10,19,14],[19,15,19,19],[19,20,19,24],[19,25,19,27],[19,28,19,32],[20,10,20,14],[20,15,20,19],[20,20,20,24],[24,25,24,27],[24,28,24,32],[21,10,21,14],[21,15,21,19],[21,20,21,24],[21,25,21,27],[21,28,21,32],[22,10,22,14],[22,15,22,19],[22,20,22,24],[25,1,25,27],[25,28,25,32],[23,10,23,14],[23,15,23,19],[23,20,23,24],[23,25,23,27],[23,28,23,32],[24,10,24,14],[24,15,24,19],[24,20,24,24]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Sayfa 3\"&IF(Soz_Sayi>15,\"-a\",\"\")","v":"Sayfa 3"}]
[]
[null,{"$f":"\"TABLO 2\"&IF(Soz_Sayi>25,\"-a\",\"\")&\": PROJEDE GÖREV ALAN SÖZLEŞMELİ PERSONEL VE İLGİLİ ÖDEMELER\"","v":"TABLO 2: PROJEDE GÖREV ALAN SÖZLEŞMELİ PERSONEL VE İLGİLİ ÖDEMELER"}]
[null,"Adı Soyadı",null,null,null,null,null,null,null,null,1,null,null,null,null,2,null,null,null,null,"3 = (1 + 2)",null,null,null,null,4,null,null,"5 = (3 x 4)"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"\"Alacağı Brüt Ücret\"&CHAR(10)&\"(\"&ParaBirimi&\"/Ay)\"","v":"Alacağı Brüt Ücret\n(TL/Ay)"},null,null,null,null,{"$f":"\"İşveren\"&CHAR(10)&\"Hisseleri*\"&CHAR(10)&\"(\"&ParaBirimi&\"/Ay)\"","v":"İşveren\nHisseleri*\n(TL/Ay)"},null,null,null,null,{"$f":"\"Proje\"&CHAR(10)&\"Hesabına\"&CHAR(10)&\"Masraf\"&CHAR(10)&\"Kaydedilecek\"&CHAR(10)&\"Tutar\"&CHAR(10)&\"(\"&ParaBirimi&\"/Ay)\"","v":"Proje\nHesabına\nMasraf\nKaydedilecek\nTutar\n(TL/Ay)"},null,null,null,null,"Görev\nSüresi\n(Ay)",null,null,{"$f":"\"Proje Maliyetine\"&CHAR(10)&\"Girecek Tutar\"&CHAR(10)&\"(\"&ParaBirimi&\")\"","v":"Proje Maliyetine\nGirecek Tutar\n(TL)"}]
[]
[]
[]
[]
[1,{"$f":"IF(Soz_Sayi>=A11,IF(INDEX(VTL_AdSoyad,MATCH(A11,L_3,0),1)=\"\",\"\",PROPER(INDEX(VTL_AdSoyad,MATCH(A11,L_3,0),1))),\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(Soz_Sayi>=A11,IF(INDEX(VTL_T1,MATCH(A11,L_3,0),1)=\"\",\"\",INDEX(VTL_T1,MATCH(A11,L_3,0),1)),\"\")","v":""},null,null,null,null,{"$f":"IF(Soz_Sayi>=A11,IF(INDEX(VTL_T2,MATCH(A11,L_3,0),1)=\"\",\"\",INDEX(VTL_T2,MATCH(A11,L_3,0),1)),\"\")","v":""},null,null,null,null,{"$f":"IF(Soz_Sayi>=A11,IF(INDEX(VTL_T3,MATCH(A11,L_3,0),1)=\"\",\"\",INDEX(VTL_T3,MATCH(A11,L_3,0),1)),\"\")","v":""},null,null,null,null,{"$f":"IF(Soz_Sayi>=A11,IF(INDEX(VTL_T4,MATCH(A11,L_3,0),1)=\"\",\"\",INDEX(VTL_T4,MATCH(A11,L_3,0),1)),\"\")","v":""},null,null,{"$f":"IF(Soz_Sayi>=A11,IF(INDEX(VTL_T5,MATCH(A11,L_3,0),1)=\"\",\"\",INDEX(VTL_T5,MATCH(A11,L_3,0),1)),\"\")","v":""}]
[2,"",null,null,null,null,null,null,null,null,{"$f":"IF(Soz_Sayi>=A12,IF(INDEX(VTL_T1,MATCH(A12,L_3,0),1)=\"\",\"\",INDEX(VTL_T1,MATCH(A12,L_3,0),1)),\"\")","v":""},null,null,null,null,{"$f":"IF(Soz_Sayi>=A12,IF(INDEX(VTL_T2,MATCH(A12,L_3,0),1)=\"\",\"\",INDEX(VTL_T2,MATCH(A12,L_3,0),1)),\"\")","v":""},null,null,null,null,"",null,null,null,null,"",null,null,""]
[3,"",null,null,null,null,null,null,null,null,{"$f":"IF(Soz_Sayi>=A13,IF(INDEX(VTL_T1,MATCH(A13,L_3,0),1)=\"\",\"\",INDEX(VTL_T1,MATCH(A13,L_3,0),1)),\"\")","v":""},null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,""]
[4,"",null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,""]
[5,"",null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,""]
[6,"",null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,""]
[7,"",null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,""]
[8,"",null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,""]
[9,"",null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,""]
[10,"",null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,""]
[11,"",null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,""]
[12,"",null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,""]
[13,"",null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,""]
[14,"",null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,""]
[15,"",null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,""]
[null,"PROJE MALİYETİNE GİRECEK TOPLAM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AC11:AG25)","v":0}]
[null,"*SSK İşveren hissesi, iş göremezlik işveren hissesi"]

{"sheet":"S4","index":4,"n_rows":46,"n_cols":32,"rows_kept":46,"cut":false,"hidden":false,"merged":[[19,2,19,20],[18,2,18,21],[15,28,15,31],[15,22,15,27],[16,22,16,27],[17,22,17,27],[16,28,16,31],[15,2,15,21],[16,2,16,21],[19,28,19,31],[40,2,40,31],[23,2,25,31],[35,2,38,31],[18,28,18,31],[28,2,32,31],[20,2,20,21],[20,22,20,27],[20,28,20,31],[18,22,18,27],[19,22,19,27],[9,22,9,27],[10,28,10,31],[13,28,13,31],[12,28,12,31],[10,22,10,27],[11,22,11,27],[12,22,12,27],[13,22,13,27],[5,28,5,31],[11,28,11,31],[6,28,6,31],[5,22,5,27],[6,22,6,27],[7,22,7,27],[7,28,7,31],[8,28,8,31],[9,28,9,31],[8,22,8,27],[3,28,3,31],[4,28,4,31],[3,22,3,27],[4,22,4,27],[3,2,3,21],[4,2,4,21],[5,2,5,21],[6,2,6,21],[7,2,7,21],[8,2,8,21],[9,2,9,21],[10,2,10,21],[17,2,17,21],[17,28,17,31],[14,28,14,31],[14,22,14,27],[11,2,11,21],[12,2,12,21],[13,2,13,21],[14,2,14,21]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sayfa 4"]
[null,null,"TABLO 3: PROJE MALİYETİ"]
[null,null,"GİDERLER",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ParaBirimi=\"\",\"\",ParaBirimi)","v":"TL"},null,null,null,null,null,"YÜZDE"]
[null,null,"1. Demirbaş alımları",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Proje Bilgileri'!Y139=\"\",\"\",'Proje Bilgileri'!Y139)","v":""},null,null,null,null,null,{"$f":"IF('Proje Bilgileri'!AF139=\"\",\"\",'Proje Bilgileri'!AF139)","v":""}]
[null,null,"2. Dış kurumlardan satın alınan hizmetler",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Proje Bilgileri'!Y140=\"\",\"\",'Proje Bilgileri'!Y140)","v":""},null,null,null,null,null,{"$f":"IF('Proje Bilgileri'!AF140=\"\",\"\",'Proje Bilgileri'!AF140)","v":""}]
[null,null,"3. Akademik personel ödemeleri (Tablo 1'den nakil)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Proje Bilgileri'!Y141=\"\",\"\",'Proje Bilgileri'!Y141)","v":0},null,null,null,null,null,{"$f":"IF('Proje Bilgileri'!AF141=\"\",\"\",'Proje Bilgileri'!AF141)","v":""}]
[null,null,"4. Sözleşmeli personel ödemeleri (Tablo 2'den nakil)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Proje Bilgileri'!Y142=\"\",\"\",'Proje Bilgileri'!Y142)","v":0},null,null,null,null,null,{"$f":"IF('Proje Bilgileri'!AF142=\"\",\"\",'Proje Bilgileri'!AF142)","v":""}]
[null,null,"5. Yurtiçi ve yurtdışı seyahat masrafları",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Proje Bilgileri'!Y143=\"\",\"\",'Proje Bilgileri'!Y143)","v":""},null,null,null,null,null,{"$f":"IF('Proje Bilgileri'!AF143=\"\",\"\",'Proje Bilgileri'!AF143)","v":""}]
[null,null,"6. Sarf malzemesi alımları",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Proje Bilgileri'!Y144=\"\",\"\",'Proje Bilgileri'!Y144)","v":""},null,null,null,null,null,{"$f":"IF('Proje Bilgileri'!AF144=\"\",\"\",'Proje Bilgileri'!AF144)","v":""}]
[null,null,"ARA TOPLAM = (1) + (2) + (3) + (4) + (5) + (6)  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Proje Bilgileri'!Y145=\"\",\"\",'Proje Bilgileri'!Y145)","v":0},null,null,null,null,null,{"$f":"IF('Proje Bilgileri'!AF145=\"\",\"\",'Proje Bilgileri'!AF145)","v":""}]
[null,null,"A = TOPLAM PROJE MALİYETİ (K.D.V. HARİÇ) - (1) / 0,94  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Proje Bilgileri'!Y146=\"\",\"\",'Proje Bilgileri'!Y146)","v":0},null,null,null,null,null,{"$f":"IF('Proje Bilgileri'!AF146=\"\",\"\",'Proje Bilgileri'!AF146)","v":""}]
[null,null,"7. Üniversite genel masraf payı = A x (%19,5) + [ (1) / 0,94 - (1) ]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Proje Bilgileri'!Y147=\"\",\"\",'Proje Bilgileri'!Y147)","v":0},null,null,null,null,null,{"$f":"IF('Proje Bilgileri'!AF147=\"\",\"\",'Proje Bilgileri'!AF147)","v":""}]
[null,null,"8. Fakülte payı = A x (%4,25)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Proje Bilgileri'!Y148=\"\",\"\",'Proje Bilgileri'!Y148)","v":0},null,null,null,null,null,{"$f":"IF('Proje Bilgileri'!AF148=\"\",\"\",'Proje Bilgileri'!AF148)","v":""}]
[null,null,"9. Bölüm demirbaş payı = A x (%4,25)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Proje Bilgileri'!Y149=\"\",\"\",'Proje Bilgileri'!Y149)","v":0},null,null,null,null,null,{"$f":"IF('Proje Bilgileri'!AF149=\"\",\"\",'Proje Bilgileri'!AF149)","v":""}]
[null,null,"10. İlgi SEM veya YDYO payı = A x (%8,5)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Proje Bilgileri'!Y150=\"\",\"\",'Proje Bilgileri'!Y150)","v":0},null,null,null,null,null,{"$f":"IF('Proje Bilgileri'!AF150=\"\",\"\",'Proje Bilgileri'!AF150)","v":""}]
[null,null,"11. Araştırma merkezi veya enstitü payı = A x (%8,5)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Proje Bilgileri'!Y151=\"\",\"\",'Proje Bilgileri'!Y151)","v":0},null,null,null,null,null,{"$f":"IF('Proje Bilgileri'!AF151=\"\",\"\",'Proje Bilgileri'!AF151)","v":""}]
[null,null,"12. Öğretim üyesi payı = A x (%8)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Proje Bilgileri'!Y152=\"\",\"\",'Proje Bilgileri'!Y152)","v":0},null,null,null,null,null,{"$f":"IF('Proje Bilgileri'!AF152=\"\",\"\",'Proje Bilgileri'!AF152)","v":""}]
[null,null,"TOPLAM PROJE MALİYETİ (K.D.V. HARİÇ)  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Proje Bilgileri'!Y153=\"\",\"\",'Proje Bilgileri'!Y153)","v":0},null,null,null,null,null,{"$f":"IF('Proje Bilgileri'!AF153=\"\",\"\",'Proje Bilgileri'!AF153)","v":""}]
[null,null,{"$f":"\"K.D.V. (\"&IF(KDV=\"Muaf\",\"Muaf)\",IF(KDV=8%,\"%8)\",\"%18)\"))","v":"K.D.V. (%18)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(KDV=\"Muaf\",0,'Proje Bilgileri'!Y154)","v":0}]
[null,null,"TOPLAM PROJE MALİYETİ (K.D.V. DAHİL)  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Proje Bilgileri'!Y155=\"\",\"\",'Proje Bilgileri'!Y155)","v":0}]
[]
[null,null,"PROJE UYGULAMASI"]
[null,null,"Projenin uygulanmasında izlenecek esaslar Döner Sermaye Yönetmeliği çerçevesinde olacaktır. Proje yöneticisi ve proje grubu Orta Doğu Teknik Üniversitesi ile ilişkisini kesse bile, projeyi bitirmeyi veya yerine bir yetkiliyi atamayı taahhüt eder."]
[]
[]
[]
[null,null,"MASRAFLAR ARASINDAKİ NAKİL"]
[null,null,"Mali hükümler bölümünde belirtilmiş olan gider kalemlerinden herhangi birinin aşılması halinde veya bir gider kaleminde öngörülen harcama tutarı sözleşmenin uygulanması esnasında yeterli gelmediği takdirde, Üniversite masraf payından bir azalma yapılmayacak, fakat diğer gider kalemleri arasında aktarma yapılacaktır. Ancak personel giderleri için Rektörlük onayı alınacaktır."]
[]
[]
[]
[]
[]
[null,null,"RAPORLAR"]
[null,null,{"$f":"\"Bu araştırma ile ilgili olarak tarihi, türü ve adedi aşağıda belirtilmiş olan raporlar Proje Yöneticisinin sorumluluğu altında Proje Grubu tarafından hazırlanır ve \"&IF(RaporKurum=\"\",\"..................................................................\",RaporKurum)&\"'a teslim edilmek üzere Araştırma Geliştirme ve Uygulama Döner Sermaye İşletmesi Müdürlüğüne gönderilir.\"","v":"Bu araştırma ile ilgili olarak tarihi, türü ve adedi aşağıda belirtilmiş olan raporlar Proje Yöneticisinin sorumluluğu altında Proje Grubu tarafından hazırlanır ve 0'a teslim edilmek üzere Araştırma Geliştirme ve Uygulama Döner Sermaye İşletmesi Müdürlüğüne gönderilir."}]
[]
[]
[]
[]
[null,null,{"$f":"\"Bu sözleşme \"&IF(TanzimTarihi=\"\",\"……………\",TEXT(TanzimTarihi,\"GG.AA.YYYY\"))&\" tarihinde iki nüsha olarak taraflarca tanzim ve imza edilmiştir.\"","v":"Bu sözleşme …………… tarihinde iki nüsha olarak taraflarca tanzim ve imza edilmiştir."}]
[]
[null,null,"Proje Yöneticisi",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rektör Yardımcısı"]
[null,null,{"$f":"IF(PY1_Unvan=\"\",\"\",PY1_Unvan)&\" \"&IF(PY1_Ad=\"\",\"\",PROPER(PY1_Ad))&\" \"&IF(PY1_Soyad=\"\",\"\",UPPER(PY1_Soyad))","v":"  "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Prof. Dr. Mehmet T. ZEYREK"]
[]
[null,null,{"$f":"IF(OR(PY2_Unvan=\"\",PY2_Ad=\"\"),\"\",PY2_Unvan)&\" \"&IF(PY2_Ad=\"\",\"\",PROPER(PY2_Ad))&\" \"&IF(PY2_Soyad=\"\",\"\",UPPER(PY2_Soyad))","v":"  "}]

{"sheet":"S2b","index":5,"n_rows":43,"n_cols":32,"rows_kept":43,"cut":false,"hidden":true,"merged":[[3,2,10,31],[11,1,11,32],[12,1,15,16],[12,17,12,22],[12,23,12,26],[12,27,12,32],[13,17,15,22],[13,23,15,26],[13,27,15,32],[17,1,17,16],[17,17,17,22],[17,23,17,26],[17,27,17,32],[16,1,16,16],[16,17,16,22],[16,23,16,26],[16,27,16,32],[19,1,19,16],[19,17,19,22],[19,23,19,26],[19,27,19,32],[18,1,18,16],[18,17,18,22],[18,23,18,26],[18,27,18,32],[21,1,21,16],[21,17,21,22],[21,23,21,26],[21,27,21,32],[20,1,20,16],[20,17,20,22],[20,23,20,26],[20,27,20,32],[23,1,23,16],[23,17,23,22],[23,23,23,26],[23,27,23,32],[22,1,22,16],[22,17,22,22],[22,23,22,26],[22,27,22,32],[25,1,25,16],[25,17,25,22],[25,23,25,26],[25,27,25,32],[24,1,24,16],[24,17,24,22],[24,23,24,26],[24,27,24,32],[27,1,27,16],[27,17,27,22],[27,23,27,26],[27,27,27,32],[26,1,26,16],[26,17,26,22],[26,23,26,26],[26,27,26,32],[29,1,29,16],[29,17,29,22],[29,23,29,26],[29,27,29,32],[28,1,28,16],[28,17,28,22],[28,23,28,26],[28,27,28,32],[31,1,31,16],[31,17,31,22],[31,23,31,26],[31,27,31,32],[30,1,30,16],[30,17,30,22],[30,23,30,26],[30,27,30,32],[33,1,33,16],[33,17,33,22],[33,23,33,26],[33,27,33,32],[32,1,32,16],[32,17,32,22],[32,23,32,26],[32,27,32,32],[35,1,35,16],[35,17,35,22],[35,23,35,26],[35,27,35,32],[34,1,34,16],[34,17,34,22],[34,23,34,26],[34,27,34,32],[37,1,37,16],[37,17,37,22],[37,23,37,26],[37,27,37,32],[36,1,36,16],[36,17,36,22],[36,23,36,26],[36,27,36,32],[39,1,39,16],[39,17,39,22],[39,23,39,26],[39,27,39,32],[38,1,38,16],[38,17,38,22],[38,23,38,26],[38,27,38,32],[42,1,48,32],[40,1,40,16],[40,17,40,22],[40,23,40,26],[40,27,40,32],[41,1,41,26],[41,27,41,32]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sayfa 2-b"]
[null,null,"Sözleşme Konusu ve Kapsamı (Özet Olarak):"]
[null,null,{"$f":"IF(Konusu=\"\",\"\",Konusu)","v":""}]
[]
[]
[]
[]
[]
[]
[]
[null,"TABLO 1-b: PROJEDE GÖREV ALAN ÜNİVERSİTE AKADEMİK PERSONELİ VE İLGİLİ ÖDEMELER"]
[null,"Ünvanı\nAdı Soyadı\nProjedeki Görevi",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,2,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Alacağı Brüt Ücret*\"&CHAR(10)&\"(\"&ParaBirimi&\"/Ay)\"","v":"Alacağı Brüt Ücret*\n(TL/Ay)"},null,null,null,null,null,"Projedeki\nGörev Süresi\n(Ay)",null,null,null,{"$f":"\"Proje Maliyetine\"&CHAR(10)&\"Girecek Tutar\"&CHAR(10)&\"(\"&ParaBirimi&\")\"","v":"Proje Maliyetine\nGirecek Tutar\n(TL)"}]
[]
[]
[26,{"$f":"IF(Aka_Sayi>=A17,IF(INDEX(VTL_Unvan,MATCH(A17,L_1,0),1)=\"\",\"\",INDEX(VTL_Unvan,MATCH(A17,L_1,0),1))&\" \"&IF(INDEX(VTL_AdSoyad,MATCH(A17,L_1,0),1)=\"\",\"\",PROPER(INDEX(VTL_AdSoyad,MATCH(A17,L_1,0),1)))&\", \"&IF(INDEX(VTL_Gorev,MATCH(A17,L_1,0),1)=\"\",\"\",INDEX(VTL_Gorev,MATCH(A17,L_1,0),1)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Aka_Sayi>=A17,IF(INDEX(VTL_T1,MATCH(A17,L_1,0),1)=\"\",\"\",INDEX(VTL_T1,MATCH(A17,L_1,0),1)),\"\")","v":""},null,null,null,null,null,{"$f":"IF(Aka_Sayi>=A17,IF(INDEX(VTL_T4,MATCH(A17,L_1,0),1)=\"\",\"\",INDEX(VTL_T4,MATCH(A17,L_1,0),1)),\"\")","v":""},null,null,null,{"$f":"IF(Aka_Sayi>=A17,IF(INDEX(VTL_T5,MATCH(A17,L_1,0),1)=\"\",\"\",INDEX(VTL_T5,MATCH(A17,L_1,0),1)),\"\")","v":""}]
[27,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[28,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[29,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[30,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[31,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[32,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[33,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[34,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[35,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[36,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[37,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[38,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[39,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[40,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[41,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[42,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[43,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[44,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[45,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[46,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[47,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[48,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[49,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[50,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[null,"PROJE MALİYETİNE GİRECEK TOPLAM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AB17:AG41)+SUM('S2'!AB42)","v":0}]
[null,"* (1) Gelir getiren görevlerde çalışan öğretim üyeleri ve görevlileri için ek ödeme matrahının yüzde 800'ünü, araştırma görevlileri için yüzde 500'ünü; bu görevlerde çalışmakla birlikte gelire katkısı olmayan öğretim üyeleri ve görevlileri için yüzde 600'ünü, araştırma görevlileri için yüzde 300'ünü geçemez. Ek ödeme matrahı, aylık (ek gösterge dahil), yan ödeme, ödenek (geliştirme ödeneği hariç) ve her türlü tazminat (makam, temsil ve görev, dil tazminatları hariç) toplamından oluşur. (2) 657 sayılı Devlet Memurları Kanununa tabi personel ile aynı Kanunun 4'üncü maddesinin (B) bendine göre sözleşmeli olarak çalışan personel için ek ödeme matrahının yüzde 150'sini geçemez. Sözleşmeli personel ek ödeme matrahı, sözleşmeli personelin çalıştığı birim ve bulunduğu pozisyon ünvanı itibarıyla aynı veya benzer ünvanlı memur kadrosunda çalışan, hizmet yılı ve öğrenim durumu aynı olan emsali personel dikkate alınarak belirlenir. Emsali bulunmayan sözleşmeli personelin ek ödeme matrahı ise brüt sözleşme ücretinin yüzde 25'ini geçemez. (3) Mesai saatleri dışında gelir getirici çalışmalarından doğan katkılarına karşılık olarak, (1)'de belirtilen personel için yüzde 50'sini, (2)'de belirtilen personel için yüzde 20'sini geçmeyecek şekilde ayrıca aylık ek ödeme yapılabilir."]

{"sheet":"S2c","index":6,"n_rows":43,"n_cols":32,"rows_kept":43,"cut":false,"hidden":true,"merged":[[3,2,10,31],[11,1,11,32],[12,1,15,16],[12,17,12,22],[12,23,12,26],[12,27,12,32],[13,17,15,22],[13,23,15,26],[13,27,15,32],[17,1,17,16],[17,17,17,22],[17,23,17,26],[17,27,17,32],[16,1,16,16],[16,17,16,22],[16,23,16,26],[16,27,16,32],[19,1,19,16],[19,17,19,22],[19,23,19,26],[19,27,19,32],[18,1,18,16],[18,17,18,22],[18,23,18,26],[18,27,18,32],[21,1,21,16],[21,17,21,22],[21,23,21,26],[21,27,21,32],[20,1,20,16],[20,17,20,22],[20,23,20,26],[20,27,20,32],[23,1,23,16],[23,17,23,22],[23,23,23,26],[23,27,23,32],[22,1,22,16],[22,17,22,22],[22,23,22,26],[22,27,22,32],[25,1,25,16],[25,17,25,22],[25,23,25,26],[25,27,25,32],[24,1,24,16],[24,17,24,22],[24,23,24,26],[24,27,24,32],[27,1,27,16],[27,17,27,22],[27,23,27,26],[27,27,27,32],[26,1,26,16],[26,17,26,22],[26,23,26,26],[26,27,26,32],[29,1,29,16],[29,17,29,22],[29,23,29,26],[29,27,29,32],[28,1,28,16],[28,17,28,22],[28,23,28,26],[28,27,28,32],[31,1,31,16],[31,17,31,22],[31,23,31,26],[31,27,31,32],[30,1,30,16],[30,17,30,22],[30,23,30,26],[30,27,30,32],[33,1,33,16],[33,17,33,22],[33,23,33,26],[33,27,33,32],[32,1,32,16],[32,17,32,22],[32,23,32,26],[32,27,32,32],[35,1,35,16],[35,17,35,22],[35,23,35,26],[35,27,35,32],[34,1,34,16],[34,17,34,22],[34,23,34,26],[34,27,34,32],[37,1,37,16],[37,17,37,22],[37,23,37,26],[37,27,37,32],[36,1,36,16],[36,17,36,22],[36,23,36,26],[36,27,36,32],[39,1,39,16],[39,17,39,22],[39,23,39,26],[39,27,39,32],[38,1,38,16],[38,17,38,22],[38,23,38,26],[38,27,38,32],[42,1,48,32],[40,1,40,16],[40,17,40,22],[40,23,40,26],[40,27,40,32],[41,1,41,26],[41,27,41,32]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sayfa 2-c"]
[null,null,"Sözleşme Konusu ve Kapsamı (Özet Olarak):"]
[null,null,{"$f":"IF(Konusu=\"\",\"\",Konusu)","v":""}]
[]
[]
[]
[]
[]
[]
[]
[null,"TABLO 1-c: PROJEDE GÖREV ALAN ÜNİVERSİTE AKADEMİK PERSONELİ VE İLGİLİ ÖDEMELER"]
[null,"Ünvanı\nAdı Soyadı\nProjedeki Görevi",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,2,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Alacağı Brüt Ücret*\"&CHAR(10)&\"(\"&ParaBirimi&\"/Ay)\"","v":"Alacağı Brüt Ücret*\n(TL/Ay)"},null,null,null,null,null,"Projedeki\nGörev Süresi\n(Ay)",null,null,null,{"$f":"\"Proje Maliyetine\"&CHAR(10)&\"Girecek Tutar\"&CHAR(10)&\"(\"&ParaBirimi&\")\"","v":"Proje Maliyetine\nGirecek Tutar\n(TL)"}]
[]
[]
[51,{"$f":"IF(Aka_Sayi>=A17,IF(INDEX(VTL_Unvan,MATCH(A17,L_1,0),1)=\"\",\"\",INDEX(VTL_Unvan,MATCH(A17,L_1,0),1))&\" \"&IF(INDEX(VTL_AdSoyad,MATCH(A17,L_1,0),1)=\"\",\"\",PROPER(INDEX(VTL_AdSoyad,MATCH(A17,L_1,0),1)))&\", \"&IF(INDEX(VTL_Gorev,MATCH(A17,L_1,0),1)=\"\",\"\",INDEX(VTL_Gorev,MATCH(A17,L_1,0),1)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Aka_Sayi>=A17,IF(INDEX(VTL_T1,MATCH(A17,L_1,0),1)=\"\",\"\",INDEX(VTL_T1,MATCH(A17,L_1,0),1)),\"\")","v":""},null,null,null,null,null,{"$f":"IF(Aka_Sayi>=A17,IF(INDEX(VTL_T4,MATCH(A17,L_1,0),1)=\"\",\"\",INDEX(VTL_T4,MATCH(A17,L_1,0),1)),\"\")","v":""},null,null,null,{"$f":"IF(Aka_Sayi>=A17,IF(INDEX(VTL_T5,MATCH(A17,L_1,0),1)=\"\",\"\",INDEX(VTL_T5,MATCH(A17,L_1,0),1)),\"\")","v":""}]
[52,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[53,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[54,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[55,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[56,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[57,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[58,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[59,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[60,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[61,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[62,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[63,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[64,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[65,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[66,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[67,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[68,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[69,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[70,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[71,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[72,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[73,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[74,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[75,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[null,"PROJE MALİYETİNE GİRECEK TOPLAM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AB17:AG41)+SUM(S2b!AB42)","v":0}]
[null,"* (1) Gelir getiren görevlerde çalışan öğretim üyeleri ve görevlileri için ek ödeme matrahının yüzde 800'ünü, araştırma görevlileri için yüzde 500'ünü; bu görevlerde çalışmakla birlikte gelire katkısı olmayan öğretim üyeleri ve görevlileri için yüzde 600'ünü, araştırma görevlileri için yüzde 300'ünü geçemez. Ek ödeme matrahı, aylık (ek gösterge dahil), yan ödeme, ödenek (geliştirme ödeneği hariç) ve her türlü tazminat (makam, temsil ve görev, dil tazminatları hariç) toplamından oluşur. (2) 657 sayılı Devlet Memurları Kanununa tabi personel ile aynı Kanunun 4'üncü maddesinin (B) bendine göre sözleşmeli olarak çalışan personel için ek ödeme matrahının yüzde 150'sini geçemez. Sözleşmeli personel ek ödeme matrahı, sözleşmeli personelin çalıştığı birim ve bulunduğu pozisyon ünvanı itibarıyla aynı veya benzer ünvanlı memur kadrosunda çalışan, hizmet yılı ve öğrenim durumu aynı olan emsali personel dikkate alınarak belirlenir. Emsali bulunmayan sözleşmeli personelin ek ödeme matrahı ise brüt sözleşme ücretinin yüzde 25'ini geçemez. (3) Mesai saatleri dışında gelir getirici çalışmalarından doğan katkılarına karşılık olarak, (1)'de belirtilen personel için yüzde 50'sini, (2)'de belirtilen personel için yüzde 20'sini geçmeyecek şekilde ayrıca aylık ek ödeme yapılabilir."]

{"sheet":"S2d","index":7,"n_rows":43,"n_cols":32,"rows_kept":43,"cut":false,"hidden":true,"merged":[[3,2,10,31],[11,1,11,32],[12,1,15,16],[12,17,12,22],[12,23,12,26],[12,27,12,32],[13,17,15,22],[13,23,15,26],[13,27,15,32],[17,1,17,16],[17,17,17,22],[17,23,17,26],[17,27,17,32],[16,1,16,16],[16,17,16,22],[16,23,16,26],[16,27,16,32],[19,1,19,16],[19,17,19,22],[19,23,19,26],[19,27,19,32],[18,1,18,16],[18,17,18,22],[18,23,18,26],[18,27,18,32],[21,1,21,16],[21,17,21,22],[21,23,21,26],[21,27,21,32],[20,1,20,16],[20,17,20,22],[20,23,20,26],[20,27,20,32],[23,1,23,16],[23,17,23,22],[23,23,23,26],[23,27,23,32],[22,1,22,16],[22,17,22,22],[22,23,22,26],[22,27,22,32],[25,1,25,16],[25,17,25,22],[25,23,25,26],[25,27,25,32],[24,1,24,16],[24,17,24,22],[24,23,24,26],[24,27,24,32],[27,1,27,16],[27,17,27,22],[27,23,27,26],[27,27,27,32],[26,1,26,16],[26,17,26,22],[26,23,26,26],[26,27,26,32],[29,1,29,16],[29,17,29,22],[29,23,29,26],[29,27,29,32],[28,1,28,16],[28,17,28,22],[28,23,28,26],[28,27,28,32],[31,1,31,16],[31,17,31,22],[31,23,31,26],[31,27,31,32],[30,1,30,16],[30,17,30,22],[30,23,30,26],[30,27,30,32],[33,1,33,16],[33,17,33,22],[33,23,33,26],[33,27,33,32],[32,1,32,16],[32,17,32,22],[32,23,32,26],[32,27,32,32],[35,1,35,16],[35,17,35,22],[35,23,35,26],[35,27,35,32],[34,1,34,16],[34,17,34,22],[34,23,34,26],[34,27,34,32],[37,1,37,16],[37,17,37,22],[37,23,37,26],[37,27,37,32],[36,1,36,16],[36,17,36,22],[36,23,36,26],[36,27,36,32],[39,1,39,16],[39,17,39,22],[39,23,39,26],[39,27,39,32],[38,1,38,16],[38,17,38,22],[38,23,38,26],[38,27,38,32],[42,1,48,32],[40,1,40,16],[40,17,40,22],[40,23,40,26],[40,27,40,32],[41,1,41,26],[41,27,41,32]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sayfa 2-d"]
[null,null,"Sözleşme Konusu ve Kapsamı (Özet Olarak):"]
[null,null,{"$f":"IF(Konusu=\"\",\"\",Konusu)","v":""}]
[]
[]
[]
[]
[]
[]
[]
[null,"TABLO 1-d: PROJEDE GÖREV ALAN ÜNİVERSİTE AKADEMİK PERSONELİ VE İLGİLİ ÖDEMELER"]
[null,"Ünvanı\nAdı Soyadı\nProjedeki Görevi",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,2,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Alacağı Brüt Ücret*\"&CHAR(10)&\"(\"&ParaBirimi&\"/Ay)\"","v":"Alacağı Brüt Ücret*\n(TL/Ay)"},null,null,null,null,null,"Projedeki\nGörev Süresi\n(Ay)",null,null,null,{"$f":"\"Proje Maliyetine\"&CHAR(10)&\"Girecek Tutar\"&CHAR(10)&\"(\"&ParaBirimi&\")\"","v":"Proje Maliyetine\nGirecek Tutar\n(TL)"}]
[]
[]
[76,{"$f":"IF(Aka_Sayi>=A17,IF(INDEX(VTL_Unvan,MATCH(A17,L_1,0),1)=\"\",\"\",INDEX(VTL_Unvan,MATCH(A17,L_1,0),1))&\" \"&IF(INDEX(VTL_AdSoyad,MATCH(A17,L_1,0),1)=\"\",\"\",PROPER(INDEX(VTL_AdSoyad,MATCH(A17,L_1,0),1)))&\", \"&IF(INDEX(VTL_Gorev,MATCH(A17,L_1,0),1)=\"\",\"\",INDEX(VTL_Gorev,MATCH(A17,L_1,0),1)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Aka_Sayi>=A17,IF(INDEX(VTL_T1,MATCH(A17,L_1,0),1)=\"\",\"\",INDEX(VTL_T1,MATCH(A17,L_1,0),1)),\"\")","v":""},null,null,null,null,null,{"$f":"IF(Aka_Sayi>=A17,IF(INDEX(VTL_T4,MATCH(A17,L_1,0),1)=\"\",\"\",INDEX(VTL_T4,MATCH(A17,L_1,0),1)),\"\")","v":""},null,null,null,{"$f":"IF(Aka_Sayi>=A17,IF(INDEX(VTL_T5,MATCH(A17,L_1,0),1)=\"\",\"\",INDEX(VTL_T5,MATCH(A17,L_1,0),1)),\"\")","v":""}]
[77,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[78,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[79,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[80,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[81,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[82,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[83,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[84,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[85,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[86,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[87,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[88,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[89,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[90,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[91,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[92,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[93,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[94,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[95,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[96,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[97,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[98,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[99,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[100,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,""]
[null,"PROJE MALİYETİNE GİRECEK TOPLAM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AB17:AG41)+SUM(S2c!AB42)","v":0}]
[null,"* (1) Gelir getiren görevlerde çalışan öğretim üyeleri ve görevlileri için ek ödeme matrahının yüzde 800'ünü, araştırma görevlileri için yüzde 500'ünü; bu görevlerde çalışmakla birlikte gelire katkısı olmayan öğretim üyeleri ve görevlileri için yüzde 600'ünü, araştırma görevlileri için yüzde 300'ünü geçemez. Ek ödeme matrahı, aylık (ek gösterge dahil), yan ödeme, ödenek (geliştirme ödeneği hariç) ve her türlü tazminat (makam, temsil ve görev, dil tazminatları hariç) toplamından oluşur. (2) 657 sayılı Devlet Memurları Kanununa tabi personel ile aynı Kanunun 4'üncü maddesinin (B) bendine göre sözleşmeli olarak çalışan personel için ek ödeme matrahının yüzde 150'sini geçemez. Sözleşmeli personel ek ödeme matrahı, sözleşmeli personelin çalıştığı birim ve bulunduğu pozisyon ünvanı itibarıyla aynı veya benzer ünvanlı memur kadrosunda çalışan, hizmet yılı ve öğrenim durumu aynı olan emsali personel dikkate alınarak belirlenir. Emsali bulunmayan sözleşmeli personelin ek ödeme matrahı ise brüt sözleşme ücretinin yüzde 25'ini geçemez. (3) Mesai saatleri dışında gelir getirici çalışmalarından doğan katkılarına karşılık olarak, (1)'de belirtilen personel için yüzde 50'sini, (2)'de belirtilen personel için yüzde 20'sini geçmeyecek şekilde ayrıca aylık ek ödeme yapılabilir."]

{"sheet":"S3b","index":8,"n_rows":27,"n_cols":32,"rows_kept":27,"cut":false,"hidden":true,"merged":[[4,25,4,27],[5,28,9,32],[10,10,10,14],[10,15,10,19],[10,20,10,24],[5,25,9,27],[10,25,10,27],[3,1,3,32],[4,1,9,9],[4,10,4,14],[4,15,4,19],[4,20,4,24],[10,28,10,32],[4,28,4,32],[5,10,9,14],[5,15,9,19],[5,20,9,24],[11,1,11,9],[11,10,11,14],[11,15,11,19],[11,20,11,24],[10,1,10,9],[12,25,12,27],[12,28,12,32],[11,25,11,27],[11,28,11,32],[13,1,13,9],[13,10,13,14],[12,1,12,9],[12,10,12,14],[12,15,12,19],[12,20,12,24],[13,15,13,19],[13,20,13,24],[15,25,15,27],[15,28,15,32],[14,25,14,27],[14,28,14,32],[13,25,13,27],[13,28,13,32],[14,1,14,9],[14,10,14,14],[14,15,14,19],[14,20,14,24],[15,1,15,9],[15,10,15,14],[15,15,15,19],[15,20,15,24],[16,25,16,27],[16,28,16,32],[17,1,17,9],[17,10,17,14],[16,1,16,9],[16,10,16,14],[16,15,16,19],[16,20,16,24],[17,15,17,19],[17,20,17,24],[19,25,19,27],[19,28,19,32],[18,25,18,27],[18,28,18,32],[17,25,17,27],[17,28,17,32],[18,1,18,9],[18,10,18,14],[18,15,18,19],[18,20,18,24],[19,1,19,9],[19,10,19,14],[19,15,19,19],[19,20,19,24],[20,25,20,27],[20,28,20,32],[21,1,21,9],[21,10,21,14],[20,1,20,9],[20,10,20,14],[20,15,20,19],[20,20,20,24],[21,15,21,19],[21,20,21,24],[23,25,23,27],[23,28,23,32],[22,25,22,27],[22,28,22,32],[21,25,21,27],[21,28,21,32],[22,1,22,9],[22,10,22,14],[22,15,22,19],[22,20,22,24],[23,1,23,9],[23,10,23,14],[23,15,23,19],[23,20,23,24],[25,1,25,27],[25,28,25,32],[24,1,24,9],[24,10,24,14],[24,15,24,19],[24,20,24,24],[24,25,24,27],[24,28,24,32]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sayfa 3-b"]
[]
[null,{"$f":"\"TABLO 2\"&\"-b\"&\": PROJEDE GÖREV ALAN SÖZLEŞMELİ PERSONEL VE İLGİLİ ÖDEMELER\"","v":"TABLO 2-b: PROJEDE GÖREV ALAN SÖZLEŞMELİ PERSONEL VE İLGİLİ ÖDEMELER"}]
[null,"Adı Soyadı",null,null,null,null,null,null,null,null,1,null,null,null,null,2,null,null,null,null,"3 = (1 + 2)",null,null,null,null,4,null,null,"5 = (3 x 4)"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"\"Alacağı Brüt Ücret\"&CHAR(10)&\"(\"&ParaBirimi&\"/Ay)\"","v":"Alacağı Brüt Ücret\n(TL/Ay)"},null,null,null,null,{"$f":"\"İşveren\"&CHAR(10)&\"Hisseleri*\"&CHAR(10)&\"(\"&ParaBirimi&\"/Ay)\"","v":"İşveren\nHisseleri*\n(TL/Ay)"},null,null,null,null,{"$f":"\"Proje\"&CHAR(10)&\"Hesabına\"&CHAR(10)&\"Masraf\"&CHAR(10)&\"Kaydedilecek\"&CHAR(10)&\"Tutar\"&CHAR(10)&\"(\"&ParaBirimi&\"/Ay)\"","v":"Proje\nHesabına\nMasraf\nKaydedilecek\nTutar\n(TL/Ay)"},null,null,null,null,"Görev\nSüresi\n(Ay)",null,null,{"$f":"\"Proje Maliyetine\"&CHAR(10)&\"Girecek Tutar\"&CHAR(10)&\"(\"&ParaBirimi&\")\"","v":"Proje Maliyetine\nGirecek Tutar\n(TL)"}]
[]
[]
[]
[]
[16,{"$f":"IF(Soz_Sayi>=A11,IF(INDEX(VTL_AdSoyad,MATCH(A11,L_3,0),1)=\"\",\"\",PROPER(INDEX(VTL_AdSoyad,MATCH(A11,L_3,0),1))),\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(Soz_Sayi>=A11,IF(INDEX(VTL_T1,MATCH(A11,L_3,0),1)=\"\",\"\",INDEX(VTL_T1,MATCH(A11,L_3,0),1)),\"\")","v":""},null,null,null,null,{"$f":"IF(Soz_Sayi>=A11,IF(INDEX(VTL_T2,MATCH(A11,L_3,0),1)=\"\",\"\",INDEX(VTL_T2,MATCH(A11,L_3,0),1)),\"\")","v":""},null,null,null,null,{"$f":"IF(Soz_Sayi>=A11,IF(INDEX(VTL_T3,MATCH(A11,L_3,0),1)=\"\",\"\",INDEX(VTL_T3,MATCH(A11,L_3,0),1)),\"\")","v":""},null,null,null,null,{"$f":"IF(Soz_Sayi>=A11,IF(INDEX(VTL_T4,MATCH(A11,L_3,0),1)=\"\",\"\",INDEX(VTL_T4,MATCH(A11,L_3,0),1)),\"\")","v":""},null,null,{"$f":"IF(Soz_Sayi>=A11,IF(INDEX(VTL_T5,MATCH(A11,L_3,0),1)=\"\",\"\",INDEX(VTL_T5,MATCH(A11,L_3,0),1)),\"\")","v":""}]
[17,"",null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,""]
[18,"",null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,""]
[19,"",null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,""]
[20,"",null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,""]
[21,"",null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,""]
[22,"",null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,""]
[23,"",null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,""]
[24,"",null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,""]
[25,"",null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,""]
[26,"",null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,""]
[27,"",null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,""]
[28,"",null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,""]
[29,"",null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,""]
[30,"",null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,""]
[null,"PROJE MALİYETİNE GİRECEK TOPLAM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AC11:AG25)+SUM('S3'!AC26)","v":0}]
[null,"*SSK İşveren hissesi, iş göremezlik işveren hissesi"]

{"sheet":"S3c","index":9,"n_rows":27,"n_cols":32,"rows_kept":27,"cut":false,"hidden":true,"merged":[[4,25,4,27],[5,28,9,32],[10,10,10,14],[10,15,10,19],[10,20,10,24],[5,25,9,27],[10,25,10,27],[3,1,3,32],[4,1,9,9],[4,10,4,14],[4,15,4,19],[4,20,4,24],[10,28,10,32],[4,28,4,32],[5,10,9,14],[5,15,9,19],[5,20,9,24],[11,1,11,9],[11,10,11,14],[11,15,11,19],[11,20,11,24],[10,1,10,9],[12,25,12,27],[12,28,12,32],[11,25,11,27],[11,28,11,32],[13,1,13,9],[13,10,13,14],[12,1,12,9],[12,10,12,14],[12,15,12,19],[12,20,12,24],[13,15,13,19],[13,20,13,24],[15,25,15,27],[15,28,15,32],[14,25,14,27],[14,28,14,32],[13,25,13,27],[13,28,13,32],[14,1,14,9],[14,10,14,14],[14,15,14,19],[14,20,14,24],[15,1,15,9],[15,10,15,14],[15,15,15,19],[15,20,15,24],[16,25,16,27],[16,28,16,32],[17,1,17,9],[17,10,17,14],[16,1,16,9],[16,10,16,14],[16,15,16,19],[16,20,16,24],[17,15,17,19],[17,20,17,24],[19,25,19,27],[19,28,19,32],[18,25,18,27],[18,28,18,32],[17,25,17,27],[17,28,17,32],[18,1,18,9],[18,10,18,14],[18,15,18,19],[18,20,18,24],[19,1,19,9],[19,10,19,14],[19,15,19,19],[19,20,19,24],[20,25,20,27],[20,28,20,32],[21,1,21,9],[21,10,21,14],[20,1,20,9],[20,10,20,14],[20,15,20,19],[20,20,20,24],[21,15,21,19],[21,20,21,24],[23,25,23,27],[23,28,23,32],[22,25,22,27],[22,28,22,32],[21,25,21,27],[21,28,21,32],[22,1,22,9],[22,10,22,14],[22,15,22,19],[22,20,22,24],[23,1,23,9],[23,10,23,14],[23,15,23,19],[23,20,23,24],[25,1,25,27],[25,28,25,32],[24,1,24,9],[24,10,24,14],[24,15,24,19],[24,20,24,24],[24,25,24,27],[24,28,24,32]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sayfa 3-c"]
[]
[null,{"$f":"\"TABLO 2\"&\"-c\"&\": PROJEDE GÖREV ALAN SÖZLEŞMELİ PERSONEL VE İLGİLİ ÖDEMELER\"","v":"TABLO 2-c: PROJEDE GÖREV ALAN SÖZLEŞMELİ PERSONEL VE İLGİLİ ÖDEMELER"}]
[null,"Adı Soyadı",null,null,null,null,null,null,null,null,1,null,null,null,null,2,null,null,null,null,"3 = (1 + 2)",null,null,null,null,4,null,null,"5 = (3 x 4)"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"\"Alacağı Brüt Ücret\"&CHAR(10)&\"(\"&ParaBirimi&\"/Ay)\"","v":"Alacağı Brüt Ücret\n(TL/Ay)"},null,null,null,null,{"$f":"\"İşveren\"&CHAR(10)&\"Hisseleri*\"&CHAR(10)&\"(\"&ParaBirimi&\"/Ay)\"","v":"İşveren\nHisseleri*\n(TL/Ay)"},null,null,null,null,{"$f":"\"Proje\"&CHAR(10)&\"Hesabına\"&CHAR(10)&\"Masraf\"&CHAR(10)&\"Kaydedilecek\"&CHAR(10)&\"Tutar\"&CHAR(10)&\"(\"&ParaBirimi&\"/Ay)\"","v":"Proje\nHesabına\nMasraf\nKaydedilecek\nTutar\n(TL/Ay)"},null,null,null,null,"Görev\nSüresi\n(Ay)",null,null,{"$f":"\"Proje Maliyetine\"&CHAR(10)&\"Girecek Tutar\"&CHAR(10)&\"(\"&ParaBirimi&\")\"","v":"Proje Maliyetine\nGirecek Tutar\n(TL)"}]
[]
[]
[]
[]
[31,{"$f":"IF(Soz_Sayi>=A11,IF(INDEX(VTL_AdSoyad,MATCH(A11,L_3,0),1)=\"\",\"\",PROPER(INDEX(VTL_AdSoyad,MATCH(A11,L_3,0),1))),\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(Soz_Sayi>=A11,IF(INDEX(VTL_T1,MATCH(A11,L_3,0),1)=\"\",\"\",INDEX(VTL_T1,MATCH(A11,L_3,0),1)),\"\")","v":""},null,null,null,null,{"$f":"IF(Soz_Sayi>=A11,IF(INDEX(VTL_T2,MATCH(A11,L_3,0),1)=\"\",\"\",INDEX(VTL_T2,MATCH(A11,L_3,0),1)),\"\")","v":""},null,null,null,null,{"$f":"IF(Soz_Sayi>=A11,IF(INDEX(VTL_T3,MATCH(A11,L_3,0),1)=\"\",\"\",INDEX(VTL_T3,MATCH(A11,L_3,0),1)),\"\")","v":""},null,null,null,null,{"$f":"IF(Soz_Sayi>=A11,IF(INDEX(VTL_T4,MATCH(A11,L_3,0),1)=\"\",\"\",INDEX(VTL_T4,MATCH(A11,L_3,0),1)),\"\")","v":""},null,null,{"$f":"IF(Soz_Sayi>=A11,IF(INDEX(VTL_T5,MATCH(A11,L_3,0),1)=\"\",\"\",INDEX(VTL_T5,MATCH(A11,L_3,0),1)),\"\")","v":""}]
[32,"",null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,""]
[33,"",null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,""]
[34,"",null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,""]
[35,"",null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,""]
[36,"",null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,""]
[37,"",null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,""]
[38,"",null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,""]
[39,"",null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,""]
[40,"",null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,""]
[41,"",null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,""]
[42,"",null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,""]
[43,"",null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,""]
[44,"",null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,""]
[45,"",null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,""]
[null,"PROJE MALİYETİNE GİRECEK TOPLAM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AC11:AG25)+SUM(S3b!AC26)","v":0}]
[null,"*SSK İşveren hissesi, iş göremezlik işveren hissesi"]

{"sheet":"S3d","index":10,"n_rows":27,"n_cols":32,"rows_kept":27,"cut":false,"hidden":true,"merged":[[4,25,4,27],[5,28,9,32],[10,10,10,14],[10,15,10,19],[10,20,10,24],[5,25,9,27],[10,25,10,27],[3,1,3,32],[4,1,9,9],[4,10,4,14],[4,15,4,19],[4,20,4,24],[10,28,10,32],[4,28,4,32],[5,10,9,14],[5,15,9,19],[5,20,9,24],[11,1,11,9],[11,10,11,14],[11,15,11,19],[11,20,11,24],[10,1,10,9],[12,25,12,27],[12,28,12,32],[11,25,11,27],[11,28,11,32],[13,1,13,9],[13,10,13,14],[12,1,12,9],[12,10,12,14],[12,15,12,19],[12,20,12,24],[13,15,13,19],[13,20,13,24],[15,25,15,27],[15,28,15,32],[14,25,14,27],[14,28,14,32],[13,25,13,27],[13,28,13,32],[14,1,14,9],[14,10,14,14],[14,15,14,19],[14,20,14,24],[15,1,15,9],[15,10,15,14],[15,15,15,19],[15,20,15,24],[16,25,16,27],[16,28,16,32],[17,1,17,9],[17,10,17,14],[16,1,16,9],[16,10,16,14],[16,15,16,19],[16,20,16,24],[17,15,17,19],[17,20,17,24],[19,25,19,27],[19,28,19,32],[18,25,18,27],[18,28,18,32],[17,25,17,27],[17,28,17,32],[18,1,18,9],[18,10,18,14],[18,15,18,19],[18,20,18,24],[19,1,19,9],[19,10,19,14],[19,15,19,19],[19,20,19,24],[20,25,20,27],[20,28,20,32],[21,1,21,9],[21,10,21,14],[20,1,20,9],[20,10,20,14],[20,15,20,19],[20,20,20,24],[21,15,21,19],[21,20,21,24],[23,25,23,27],[23,28,23,32],[22,25,22,27],[22,28,22,32],[21,25,21,27],[21,28,21,32],[22,1,22,9],[22,10,22,14],[22,15,22,19],[22,20,22,24],[23,1,23,9],[23,10,23,14],[23,15,23,19],[23,20,23,24],[25,1,25,27],[25,28,25,32],[24,1,24,9],[24,10,24,14],[24,15,24,19],[24,20,24,24],[24,25,24,27],[24,28,24,32]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sayfa 3-d"]
[]
[null,{"$f":"\"TABLO 2\"&\"-d\"&\": PROJEDE GÖREV ALAN SÖZLEŞMELİ PERSONEL VE İLGİLİ ÖDEMELER\"","v":"TABLO 2-d: PROJEDE GÖREV ALAN SÖZLEŞMELİ PERSONEL VE İLGİLİ ÖDEMELER"}]
[null,"Adı Soyadı",null,null,null,null,null,null,null,null,1,null,null,null,null,2,null,null,null,null,"3 = (1 + 2)",null,null,null,null,4,null,null,"5 = (3 x 4)"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"\"Alacağı Brüt Ücret\"&CHAR(10)&\"(\"&ParaBirimi&\"/Ay)\"","v":"Alacağı Brüt Ücret\n(TL/Ay)"},null,null,null,null,{"$f":"\"İşveren\"&CHAR(10)&\"Hisseleri*\"&CHAR(10)&\"(\"&ParaBirimi&\"/Ay)\"","v":"İşveren\nHisseleri*\n(TL/Ay)"},null,null,null,null,{"$f":"\"Proje\"&CHAR(10)&\"Hesabına\"&CHAR(10)&\"Masraf\"&CHAR(10)&\"Kaydedilecek\"&CHAR(10)&\"Tutar\"&CHAR(10)&\"(\"&ParaBirimi&\"/Ay)\"","v":"Proje\nHesabına\nMasraf\nKaydedilecek\nTutar\n(TL/Ay)"},null,null,null,null,"Görev\nSüresi\n(Ay)",null,null,{"$f":"\"Proje Maliyetine\"&CHAR(10)&\"Girecek Tutar\"&CHAR(10)&\"(\"&ParaBirimi&\")\"","v":"Proje Maliyetine\nGirecek Tutar\n(TL)"}]
[]
[]
[]
[]
[46,{"$f":"IF(Soz_Sayi>=A11,IF(INDEX(VTL_AdSoyad,MATCH(A11,L_3,0),1)=\"\",\"\",PROPER(INDEX(VTL_AdSoyad,MATCH(A11,L_3,0),1))),\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(Soz_Sayi>=A11,IF(INDEX(VTL_T1,MATCH(A11,L_3,0),1)=\"\",\"\",INDEX(VTL_T1,MATCH(A11,L_3,0),1)),\"\")","v":""},null,null,null,null,{"$f":"IF(Soz_Sayi>=A11,IF(INDEX(VTL_T2,MATCH(A11,L_3,0),1)=\"\",\"\",INDEX(VTL_T2,MATCH(A11,L_3,0),1)),\"\")","v":""},null,null,null,null,{"$f":"IF(Soz_Sayi>=A11,IF(INDEX(VTL_T3,MATCH(A11,L_3,0),1)=\"\",\"\",INDEX(VTL_T3,MATCH(A11,L_3,0),1)),\"\")","v":""},null,null,null,null,{"$f":"IF(Soz_Sayi>=A11,IF(INDEX(VTL_T4,MATCH(A11,L_3,0),1)=\"\",\"\",INDEX(VTL_T4,MATCH(A11,L_3,0),1)),\"\")","v":""},null,null,{"$f":"IF(Soz_Sayi>=A11,IF(INDEX(VTL_T5,MATCH(A11,L_3,0),1)=\"\",\"\",INDEX(VTL_T5,MATCH(A11,L_3,0),1)),\"\")","v":""}]
[47,"",null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,""]
[48,"",null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,""]
[49,"",null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,""]
[50,"",null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,""]
[51,"",null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,""]
[52,"",null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,""]
[53,"",null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,""]
[54,"",null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,""]
[55,"",null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,""]
[56,"",null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,""]
[57,"",null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,""]
[58,"",null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,""]
[59,"",null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,""]
[60,"",null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,null,null,"",null,null,""]
[null,"PROJE MALİYETİNE GİRECEK TOPLAM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AC11:AG25)+SUM(S3c!AC26)","v":0}]
[null,"*SSK İşveren hissesi, iş göremezlik işveren hissesi"]