{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["BAŞLANGIÇ","PLANLANAN GİDERLER","FİİLİ GİDERLER","GİDER VARYANSLARI","GİDER ANALİZİ"],"not_rendered":{"charts":2,"images":3,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"BAŞLANGIÇ","index":0,"n_rows":8,"n_cols":2,"rows_kept":8}
[null,"BU ŞABLON HAKKINDA"]
[null,"Planlanan ve Fiili Giderlerle Varyansları izlemek için bu İş Gideri Bütçesi çalışma kitabını kullanın."]
[null,"Şirket Adını girin ve Logo ekleyin."]
[null,"Planlanan Giderler ve Fiili Giderler çalışma sayfalarındaki tablolara ayrıntıları girin."]
[null,"Tablolar, Gider Varyansları çalışma sayfası ve Gider Analizi çalışma sayfasındaki grafiklerde otomatik olarak güncelleştirilir"]
[null,"Not: "]
[null,"Her çalışma sayfasının A sütununda ek yönergeler sağlanmıştır. Bu metin özellikle gizlendi. Metni kaldırmak için A sütununu ve ardından SİL seçeneğini belirleyin. Metni göstermek için A sütununu seçin ve yazı tipi rengini değiştirin."]
[null,"Tablolar hakkında daha fazla bilgi edinmek için bir tabloda SHIFT ve F10 tuşlarına basın, TABLO seçeneğini ve ardından ALTERNATİF METİN seçeneğini belirleyin"]

{"sheet":"PLANLANAN GİDERLER","index":1,"n_rows":37,"n_cols":16,"rows_kept":37,"merged":[[1,10,1,12],[2,10,2,12],[3,17,12,19]]}
[{"$nulls":15}," "]
[null,"Şirket Adı",{"$nulls":8},"Ayrıntılı Gider Tahminleri"]
[{"$nulls":10},"Gölgeli hücreler hesaplamalardır."]
[null,"PLANLANAN GİDERLER","OCA","ŞUB","MAR","NİS","MAY","HAZ","TEM","AĞU","EYL","EKİ","KAS","ARA","YIL"]
[null,"Çalışan Maliyetleri","Oca","Şub","Mar","Nis","May","Haz","Tem","Ağu","Eyl","Eki","Kas","Ara","YIL"]
[null,"Maaşlar",{"v":85000,"d":"₺85,000.00"},{"v":85000,"d":"₺85,000.00"},{"v":85000,"d":"₺85,000.00"},{"v":87500,"d":"₺87,500.00"},{"v":87500,"d":"₺87,500.00"},{"v":87500,"d":"₺87,500.00"},{"v":87500,"d":"₺87,500.00"},{"v":92400,"d":"₺92,400.00"},{"v":92400,"d":"₺92,400.00"},{"v":92400,"d":"₺92,400.00"},{"v":92400,"d":"₺92,400.00"},{"v":92400,"d":"₺92,400.00"},{"$f":"SUM(C6:N6)","v":{"v":1067000,"d":"₺1,067,000.00"}}]
[null,"Kazançlar",{"$f":"C6*0.27","v":{"v":22950,"d":"₺22,950.00"}},{"v":22950,"d":"₺22,950.00"},{"v":22950,"d":"₺22,950.00"},{"v":23625,"d":"₺23,625.00"},{"v":23625,"d":"₺23,625.00"},{"v":23625,"d":"₺23,625.00"},{"v":23625,"d":"₺23,625.00"},{"v":24948,"d":"₺24,948.00"},{"v":24948,"d":"₺24,948.00"},{"v":24948,"d":"₺24,948.00"},{"v":24948,"d":"₺24,948.00"},{"v":24948,"d":"₺24,948.00"},{"$f":"SUM(C7:N7)","v":{"v":288090,"d":"₺288,090.00"}}]
[null,"Ara toplam",{"$f":"SUBTOTAL(109,ÇalışanPlan[Oca])","v":{"v":107950,"d":"₺107,950.00"}},{"$f":"SUBTOTAL(109,ÇalışanPlan[Şub])","v":{"v":107950,"d":"₺107,950.00"}},{"$f":"SUBTOTAL(109,ÇalışanPlan[Mar])","v":{"v":107950,"d":"₺107,950.00"}},{"$f":"SUBTOTAL(109,ÇalışanPlan[Nis])","v":{"v":111125,"d":"₺111,125.00"}},{"$f":"SUBTOTAL(109,ÇalışanPlan[May])","v":{"v":111125,"d":"₺111,125.00"}},{"$f":"SUBTOTAL(109,ÇalışanPlan[Haz])","v":{"v":111125,"d":"₺111,125.00"}},{"$f":"SUBTOTAL(109,ÇalışanPlan[Tem])","v":{"v":111125,"d":"₺111,125.00"}},{"$f":"SUBTOTAL(109,ÇalışanPlan[Ağu])","v":{"v":117348,"d":"₺117,348.00"}},{"$f":"SUBTOTAL(109,ÇalışanPlan[Eyl])","v":{"v":117348,"d":"₺117,348.00"}},{"$f":"SUBTOTAL(109,ÇalışanPlan[Eki])","v":{"v":117348,"d":"₺117,348.00"}},{"$f":"SUBTOTAL(109,ÇalışanPlan[Kas])","v":{"v":117348,"d":"₺117,348.00"}},{"$f":"SUBTOTAL(109,ÇalışanPlan[Ara])","v":{"v":117348,"d":"₺117,348.00"}},{"$f":"SUBTOTAL(109,ÇalışanPlan[YIL])","v":{"v":1355090,"d":"₺1,355,090.00"}}]
[]
[null,"Ofis Maliyetleri","Oca","Şub","Mar","Nis","May","Haz","Tem","Ağu","Eyl","Eki","Kas","Ara","YIL"]
[null,"Ofis kirası",{"v":9800,"d":"₺9,800.00"},{"v":9800,"d":"₺9,800.00"},{"v":9800,"d":"₺9,800.00"},{"v":9800,"d":"₺9,800.00"},{"v":9800,"d":"₺9,800.00"},{"v":9800,"d":"₺9,800.00"},{"v":9800,"d":"₺9,800.00"},{"v":9800,"d":"₺9,800.00"},{"v":9800,"d":"₺9,800.00"},{"v":9800,"d":"₺9,800.00"},{"v":9800,"d":"₺9,800.00"},{"v":9800,"d":"₺9,800.00"},{"$f":"SUM(C11:N11)","v":{"v":117600,"d":"₺117,600.00"}}]
[null,"Doğalgaz",null,{"v":400,"d":"₺400.00"},{"v":400,"d":"₺400.00"},{"v":100,"d":"₺100.00"},{"v":100,"d":"₺100.00"},{"v":100,"d":"₺100.00"},{"v":100,"d":"₺100.00"},{"v":100,"d":"₺100.00"},{"v":100,"d":"₺100.00"},{"v":100,"d":"₺100.00"},{"v":400,"d":"₺400.00"},{"v":400,"d":"₺400.00"},{"v":2300,"d":"₺2,300.00"}]
[null,"Elektrik",{"v":300,"d":"₺300.00"},{"v":300,"d":"₺300.00"},{"v":300,"d":"₺300.00"},{"v":300,"d":"₺300.00"},{"v":300,"d":"₺300.00"},{"v":300,"d":"₺300.00"},{"v":300,"d":"₺300.00"},{"v":300,"d":"₺300.00"},{"v":300,"d":"₺300.00"},{"v":300,"d":"₺300.00"},{"v":300,"d":"₺300.00"},{"v":300,"d":"₺300.00"},{"v":3600,"d":"₺3,600.00"}]
[null,"Su",{"v":40,"d":"₺40.00"},{"v":40,"d":"₺40.00"},{"v":40,"d":"₺40.00"},{"v":40,"d":"₺40.00"},{"v":40,"d":"₺40.00"},{"v":40,"d":"₺40.00"},{"v":40,"d":"₺40.00"},{"v":40,"d":"₺40.00"},{"v":40,"d":"₺40.00"},{"v":40,"d":"₺40.00"},{"v":40,"d":"₺40.00"},{"v":40,"d":"₺40.00"},{"v":480,"d":"₺480.00"}]
[null,"Telefon",{"v":250,"d":"₺250.00"},{"v":250,"d":"₺250.00"},{"v":250,"d":"₺250.00"},{"v":250,"d":"₺250.00"},{"v":250,"d":"₺250.00"},{"v":250,"d":"₺250.00"},{"v":250,"d":"₺250.00"},{"v":250,"d":"₺250.00"},{"v":250,"d":"₺250.00"},{"v":250,"d":"₺250.00"},{"v":250,"d":"₺250.00"},{"v":250,"d":"₺250.00"},{"v":3000,"d":"₺3,000.00"}]
[null,"İnternet erişimi",{"v":180,"d":"₺180.00"},{"v":180,"d":"₺180.00"},{"v":180,"d":"₺180.00"},{"v":180,"d":"₺180.00"},{"v":180,"d":"₺180.00"},{"v":180,"d":"₺180.00"},{"v":180,"d":"₺180.00"},{"v":180,"d":"₺180.00"},{"v":180,"d":"₺180.00"},{"v":180,"d":"₺180.00"},{"v":180,"d":"₺180.00"},{"v":180,"d":"₺180.00"},{"v":2160,"d":"₺2,160.00"}]
[null,"Ofis malzemeleri",{"v":200,"d":"₺200.00"},{"v":200,"d":"₺200.00"},{"v":200,"d":"₺200.00"},{"v":200,"d":"₺200.00"},{"v":200,"d":"₺200.00"},{"v":200,"d":"₺200.00"},{"v":200,"d":"₺200.00"},{"v":200,"d":"₺200.00"},{"v":200,"d":"₺200.00"},{"v":200,"d":"₺200.00"},{"v":200,"d":"₺200.00"},{"v":200,"d":"₺200.00"},{"v":2400,"d":"₺2,400.00"}]
[null,"Güvenlik",{"v":600,"d":"₺600.00"},{"v":600,"d":"₺600.00"},{"v":600,"d":"₺600.00"},{"v":600,"d":"₺600.00"},{"v":600,"d":"₺600.00"},{"v":600,"d":"₺600.00"},{"v":600,"d":"₺600.00"},{"v":600,"d":"₺600.00"},{"v":600,"d":"₺600.00"},{"v":600,"d":"₺600.00"},{"v":600,"d":"₺600.00"},{"v":600,"d":"₺600.00"},{"v":7200,"d":"₺7,200.00"}]
[null,"Ara toplam",{"$f":"SUBTOTAL(109,OfficePlan[Oca])","v":{"v":11370,"d":"₺11,370.00"}},{"$f":"SUBTOTAL(109,OfficePlan[Şub])","v":{"v":11770,"d":"₺11,770.00"}},{"$f":"SUBTOTAL(109,OfficePlan[Mar])","v":{"v":11770,"d":"₺11,770.00"}},{"$f":"SUBTOTAL(109,OfficePlan[Nis])","v":{"v":11470,"d":"₺11,470.00"}},{"$f":"SUBTOTAL(109,OfficePlan[May])","v":{"v":11470,"d":"₺11,470.00"}},{"$f":"SUBTOTAL(109,OfficePlan[Haz])","v":{"v":11470,"d":"₺11,470.00"}},{"$f":"SUBTOTAL(109,OfficePlan[Tem])","v":{"v":11470,"d":"₺11,470.00"}},{"$f":"SUBTOTAL(109,OfficePlan[Ağu])","v":{"v":11470,"d":"₺11,470.00"}},{"$f":"SUBTOTAL(109,OfficePlan[Eyl])","v":{"v":11470,"d":"₺11,470.00"}},{"$f":"SUBTOTAL(109,OfficePlan[Eki])","v":{"v":11470,"d":"₺11,470.00"}},{"$f":"SUBTOTAL(109,OfficePlan[Kas])","v":{"v":11770,"d":"₺11,770.00"}},{"$f":"SUBTOTAL(109,OfficePlan[Ara])","v":{"v":11770,"d":"₺11,770.00"}},{"$f":"SUBTOTAL(109,OfficePlan[YIL])","v":{"v":138740,"d":"₺138,740.00"}}]
[]
[null,"Pazarlama Maliyetleri","Oca","Şub","Mar","Nis","May","Haz","Tem","Ağu","Eyl","Eki","Kas","Ara","YIL"]
[null,"Web sitesi barındırma",{"v":500,"d":"₺500.00"},{"v":500,"d":"₺500.00"},{"v":500,"d":"₺500.00"},{"v":500,"d":"₺500.00"},{"v":500,"d":"₺500.00"},{"v":500,"d":"₺500.00"},{"v":500,"d":"₺500.00"},{"v":500,"d":"₺500.00"},{"v":500,"d":"₺500.00"},{"v":500,"d":"₺500.00"},{"v":500,"d":"₺500.00"},{"v":500,"d":"₺500.00"},{"$f":"SUM(C22:N22)","v":{"v":6000,"d":"₺6,000.00"}}]
[null,"Web sitesi güncelleştirmeleri",{"v":200,"d":"₺200.00"},{"v":200,"d":"₺200.00"},{"v":200,"d":"₺200.00"},{"v":200,"d":"₺200.00"},{"v":200,"d":"₺200.00"},{"v":1000,"d":"₺1,000.00"},{"v":200,"d":"₺200.00"},{"v":200,"d":"₺200.00"},{"v":200,"d":"₺200.00"},{"v":200,"d":"₺200.00"},{"v":200,"d":"₺200.00"},{"v":1000,"d":"₺1,000.00"},{"v":4000,"d":"₺4,000.00"}]
[null,"Yardımcı malzeme hazırlığı",{"v":5000,"d":"₺5,000.00"},{"v":0,"d":"₺0.00"},{"v":0,"d":"₺0.00"},{"v":5000,"d":"₺5,000.00"},{"v":0,"d":"₺0.00"},{"v":0,"d":"₺0.00"},{"v":5000,"d":"₺5,000.00"},{"v":0,"d":"₺0.00"},{"v":0,"d":"₺0.00"},{"v":5000,"d":"₺5,000.00"},{"v":0,"d":"₺0.00"},{"v":0,"d":"₺0.00"},{"v":20000,"d":"₺20,000.00"}]
[null,"Yardımcı malzemeleri yazdırma",{"v":200,"d":"₺200.00"},{"v":200,"d":"₺200.00"},{"v":200,"d":"₺200.00"},{"v":200,"d":"₺200.00"},{"v":200,"d":"₺200.00"},{"v":200,"d":"₺200.00"},{"v":200,"d":"₺200.00"},{"v":200,"d":"₺200.00"},{"v":200,"d":"₺200.00"},{"v":200,"d":"₺200.00"},{"v":200,"d":"₺200.00"},{"v":200,"d":"₺200.00"},{"v":2400,"d":"₺2,400.00"}]
[null,"Pazarlama etkinlikleri",{"v":2000,"d":"₺2,000.00"},{"v":2000,"d":"₺2,000.00"},{"v":2000,"d":"₺2,000.00"},{"v":5000,"d":"₺5,000.00"},{"v":2000,"d":"₺2,000.00"},{"v":2000,"d":"₺2,000.00"},{"v":2000,"d":"₺2,000.00"},{"v":5000,"d":"₺5,000.00"},{"v":2000,"d":"₺2,000.00"},{"v":2000,"d":"₺2,000.00"},{"v":2000,"d":"₺2,000.00"},{"v":5000,"d":"₺5,000.00"},{"v":33000,"d":"₺33,000.00"}]
[null,"Sair giderler",{"v":200,"d":"₺200.00"},{"v":200,"d":"₺200.00"},{"v":200,"d":"₺200.00"},{"v":200,"d":"₺200.00"},{"v":200,"d":"₺200.00"},{"v":200,"d":"₺200.00"},{"v":200,"d":"₺200.00"},{"v":200,"d":"₺200.00"},{"v":200,"d":"₺200.00"},{"v":200,"d":"₺200.00"},{"v":200,"d":"₺200.00"},{"v":200,"d":"₺200.00"},{"v":2400,"d":"₺2,400.00"}]
[null,"Ara toplam",{"$f":"SUBTOTAL(109,MarketingPlan[Oca])","v":{"v":8100,"d":"₺8,100.00"}},{"$f":"SUBTOTAL(109,MarketingPlan[Şub])","v":{"v":3100,"d":"₺3,100.00"}},{"$f":"SUBTOTAL(109,MarketingPlan[Mar])","v":{"v":3100,"d":"₺3,100.00"}},{"$f":"SUBTOTAL(109,MarketingPlan[Nis])","v":{"v":11100,"d":"₺11,100.00"}},{"$f":"SUBTOTAL(109,MarketingPlan[May])","v":{"v":3100,"d":"₺3,100.00"}},{"$f":"SUBTOTAL(109,MarketingPlan[Haz])","v":{"v":3900,"d":"₺3,900.00"}},{"$f":"SUBTOTAL(109,MarketingPlan[Tem])","v":{"v":8100,"d":"₺8,100.00"}},{"$f":"SUBTOTAL(109,MarketingPlan[Ağu])","v":{"v":6100,"d":"₺6,100.00"}},{"$f":"SUBTOTAL(109,MarketingPlan[Eyl])","v":{"v":3100,"d":"₺3,100.00"}},{"$f":"SUBTOTAL(109,MarketingPlan[Eki])","v":{"v":8100,"d":"₺8,100.00"}},{"$f":"SUBTOTAL(109,MarketingPlan[Kas])","v":{"v":3100,"d":"₺3,100.00"}},{"$f":"SUBTOTAL(109,MarketingPlan[Ara])","v":{"v":6900,"d":"₺6,900.00"}},{"$f":"SUBTOTAL(109,MarketingPlan[YIL])","v":{"v":67800,"d":"₺67,800.00"}}]
[]
[null,"Eğitim/Seyahat","Oca","Şub","Mar","Nis","May","Haz","Tem","Ağu","Eyl","Eki","Kas","Ara","YIL"]
[null,"Eğitim sınıfları",{"v":2000,"d":"₺2,000.00"},{"v":2000,"d":"₺2,000.00"},{"v":2000,"d":"₺2,000.00"},{"v":2000,"d":"₺2,000.00"},{"v":2000,"d":"₺2,000.00"},{"v":2000,"d":"₺2,000.00"},{"v":2000,"d":"₺2,000.00"},{"v":2000,"d":"₺2,000.00"},{"v":2000,"d":"₺2,000.00"},{"v":2000,"d":"₺2,000.00"},{"v":2000,"d":"₺2,000.00"},{"v":2000,"d":"₺2,000.00"},{"$f":"SUM(C31:N31)","v":{"v":24000,"d":"₺24,000.00"}}]
[null,"Eğitimle ilgili seyahat maliyetleri",{"v":2000,"d":"₺2,000.00"},{"v":2000,"d":"₺2,000.00"},{"v":2000,"d":"₺2,000.00"},{"v":2000,"d":"₺2,000.00"},{"v":2000,"d":"₺2,000.00"},{"v":2000,"d":"₺2,000.00"},{"v":2000,"d":"₺2,000.00"},{"v":2000,"d":"₺2,000.00"},{"v":2000,"d":"₺2,000.00"},{"v":2000,"d":"₺2,000.00"},{"v":2000,"d":"₺2,000.00"},{"v":2000,"d":"₺2,000.00"},{"$f":"SUM(C32:N32)","v":{"v":24000,"d":"₺24,000.00"}}]
[null,"Ara toplam",{"$f":"SUBTOTAL(109,EğitimVeSeyahatPlanı[Oca])","v":{"v":4000,"d":"₺4,000.00"}},{"$f":"SUBTOTAL(109,EğitimVeSeyahatPlanı[Şub])","v":{"v":4000,"d":"₺4,000.00"}},{"$f":"SUBTOTAL(109,EğitimVeSeyahatPlanı[Mar])","v":{"v":4000,"d":"₺4,000.00"}},{"$f":"SUBTOTAL(109,EğitimVeSeyahatPlanı[Nis])","v":{"v":4000,"d":"₺4,000.00"}},{"$f":"SUBTOTAL(109,EğitimVeSeyahatPlanı[May])","v":{"v":4000,"d":"₺4,000.00"}},{"$f":"SUBTOTAL(109,EğitimVeSeyahatPlanı[Haz])","v":{"v":4000,"d":"₺4,000.00"}},{"$f":"SUBTOTAL(109,EğitimVeSeyahatPlanı[Tem])","v":{"v":4000,"d":"₺4,000.00"}},{"$f":"SUBTOTAL(109,EğitimVeSeyahatPlanı[Ağu])","v":{"v":4000,"d":"₺4,000.00"}},{"$f":"SUBTOTAL(109,EğitimVeSeyahatPlanı[Eyl])","v":{"v":4000,"d":"₺4,000.00"}},{"$f":"SUBTOTAL(109,EğitimVeSeyahatPlanı[Eki])","v":{"v":4000,"d":"₺4,000.00"}},{"$f":"SUBTOTAL(109,EğitimVeSeyahatPlanı[Kas])","v":{"v":4000,"d":"₺4,000.00"}},{"$f":"SUBTOTAL(109,EğitimVeSeyahatPlanı[Ara])","v":{"v":4000,"d":"₺4,000.00"}},{"$f":"SUBTOTAL(109,EğitimVeSeyahatPlanı[YIL])","v":{"v":48000,"d":"₺48,000.00"}}]
[]
[null,"TOPLAMLAR","Oca","Şub","Mar","Nis","May","Haz","Tem","Ağu","Eyl","Eki","Kas","Ara","Yıl"]
[null,"Aylık Planlanan Giderler",{"$f":"EğitimVeSeyahatPlanı[[#Totals],[Oca]]+MarketingPlan[[#Totals],[Oca]]+OfficePlan[[#Totals],[Oca]]+ÇalışanPlan[[#Totals],[Oca]]","v":{"v":131420,"d":"₺131,420.00"}},{"$f":"EğitimVeSeyahatPlanı[[#Totals],[Şub]]+MarketingPlan[[#Totals],[Şub]]+OfficePlan[[#Totals],[Şub]]+ÇalışanPlan[[#Totals],[Şub]]","v":{"v":126820,"d":"₺126,820.00"}},{"$f":"EğitimVeSeyahatPlanı[[#Totals],[Mar]]+MarketingPlan[[#Totals],[Mar]]+OfficePlan[[#Totals],[Mar]]+ÇalışanPlan[[#Totals],[Mar]]","v":{"v":126820,"d":"₺126,820.00"}},{"$f":"EğitimVeSeyahatPlanı[[#Totals],[Nis]]+MarketingPlan[[#Totals],[Nis]]+OfficePlan[[#Totals],[Nis]]+ÇalışanPlan[[#Totals],[Nis]]","v":{"v":137695,"d":"₺137,695.00"}},{"$f":"EğitimVeSeyahatPlanı[[#Totals],[May]]+MarketingPlan[[#Totals],[May]]+OfficePlan[[#Totals],[May]]+ÇalışanPlan[[#Totals],[May]]","v":{"v":129695,"d":"₺129,695.00"}},{"$f":"EğitimVeSeyahatPlanı[[#Totals],[Haz]]+MarketingPlan[[#Totals],[Haz]]+OfficePlan[[#Totals],[Haz]]+ÇalışanPlan[[#Totals],[Haz]]","v":{"v":130495,"d":"₺130,495.00"}},{"$f":"EğitimVeSeyahatPlanı[[#Totals],[Tem]]+MarketingPlan[[#Totals],[Tem]]+OfficePlan[[#Totals],[Tem]]+ÇalışanPlan[[#Totals],[Tem]]","v":{"v":134695,"d":"₺134,695.00"}},{"$f":"EğitimVeSeyahatPlanı[[#Totals],[Ağu]]+MarketingPlan[[#Totals],[Ağu]]+OfficePlan[[#Totals],[Ağu]]+ÇalışanPlan[[#Totals],[Ağu]]","v":{"v":138918,"d":"₺138,918.00"}},{"$f":"EğitimVeSeyahatPlanı[[#Totals],[Eyl]]+MarketingPlan[[#Totals],[Eyl]]+OfficePlan[[#Totals],[Eyl]]+ÇalışanPlan[[#Totals],[Eyl]]","v":{"v":135918,"d":"₺135,918.00"}},{"$f":"EğitimVeSeyahatPlanı[[#Totals],[Eki]]+MarketingPlan[[#Totals],[Eki]]+OfficePlan[[#Totals],[Eki]]+ÇalışanPlan[[#Totals],[Eki]]","v":{"v":140918,"d":"₺140,918.00"}},{"$f":"EğitimVeSeyahatPlanı[[#Totals],[Kas]]+MarketingPlan[[#Totals],[Kas]]+OfficePlan[[#Totals],[Kas]]+ÇalışanPlan[[#Totals],[Kas]]","v":{"v":136218,"d":"₺136,218.00"}},{"$f":"EğitimVeSeyahatPlanı[[#Totals],[Ara]]+MarketingPlan[[#Totals],[Ara]]+OfficePlan[[#Totals],[Ara]]+ÇalışanPlan[[#Totals],[Ara]]","v":{"v":140018,"d":"₺140,018.00"}},{"$f":"EğitimVeSeyahatPlanı[[#Totals],[YIL]]+MarketingPlan[[#Totals],[YIL]]+OfficePlan[[#Totals],[YIL]]+ÇalışanPlan[[#Totals],[YIL]]","v":{"v":1609630,"d":"₺1,609,630.00"}}]
[null,"TOPLAM Planlanan Giderler",{"$f":"SUM($C$36:C36)","v":{"v":131420,"d":"₺131,420.00"}},{"$f":"SUM($C$36:D36)","v":{"v":258240,"d":"₺258,240.00"}},{"$f":"SUM($C$36:E36)","v":{"v":385060,"d":"₺385,060.00"}},{"$f":"SUM($C$36:F36)","v":{"v":522755,"d":"₺522,755.00"}},{"$f":"SUM($C$36:G36)","v":{"v":652450,"d":"₺652,450.00"}},{"$f":"SUM($C$36:H36)","v":{"v":782945,"d":"₺782,945.00"}},{"$f":"SUM($C$36:I36)","v":{"v":917640,"d":"₺917,640.00"}},{"$f":"SUM($C$36:J36)","v":{"v":1056558,"d":"₺1,056,558.00"}},{"$f":"SUM($C$36:K36)","v":{"v":1192476,"d":"₺1,192,476.00"}},{"$f":"SUM($C$36:L36)","v":{"v":1333394,"d":"₺1,333,394.00"}},{"$f":"SUM($C$36:M36)","v":{"v":1469612,"d":"₺1,469,612.00"}},{"$f":"SUM($C$36:N36)","v":{"v":1609630,"d":"₺1,609,630.00"}}]

{"sheet":"FİİLİ GİDERLER","index":2,"n_rows":37,"n_cols":16,"rows_kept":37,"merged":[[1,10,1,12],[2,10,2,12]]}
[{"$nulls":15}," "]
[null,{"$f":"'PLANLANAN GİDERLER'!B2:D3","v":"Şirket Adı"},{"$nulls":8},{"$f":"worksheet_title","v":"Ayrıntılı Gider Tahminleri"}]
[{"$nulls":10},"Gölgeli hücreler hesaplamalardır."]
[null,"FİİLİ GİDERLER","OCA","ŞUB","MAR","NİS","MAY","HAZ","TEM","AĞU","EYL","EKİ","KAS","ARA","YIL"]
[null,"Çalışan Maliyetleri","Oca","Şub","Mar","Nis","May","Haz","Tem","Ağu","Eyl","Eki","Kas","Ara","YIL"]
[null,"Maaşlar",{"v":85000,"d":"₺85,000.00"},{"v":85000,"d":"₺85,000.00"},{"v":85000,"d":"₺85,000.00"},{"v":88000,"d":"₺88,000.00"},{"v":88000,"d":"₺88,000.00"},{"v":88000,"d":"₺88,000.00"},{"$nulls":6},{"$f":"SUM(C6:N6)","v":{"v":519000,"d":"₺519,000.00"}}]
[null,"Kazançlar",{"$f":"C6*0.27","v":{"v":22950,"d":"₺22,950.00"}},{"v":22950,"d":"₺22,950.00"},{"v":22950,"d":"₺22,950.00"},{"v":23760,"d":"₺23,760.00"},{"v":23760,"d":"₺23,760.00"},{"v":23760,"d":"₺23,760.00"},{"v":0,"d":"₺0.00"},{"v":0,"d":"₺0.00"},{"v":0,"d":"₺0.00"},{"v":0,"d":"₺0.00"},{"v":0,"d":"₺0.00"},{"v":0,"d":"₺0.00"},{"$f":"SUM(C7:N7)","v":{"v":140130,"d":"₺140,130.00"}}]
[null,"Ara toplam",{"$f":"SUBTOTAL(109,EmployeeActual[Oca])","v":{"v":107950,"d":"₺107,950.00"}},{"$f":"SUBTOTAL(109,EmployeeActual[Şub])","v":{"v":107950,"d":"₺107,950.00"}},{"$f":"SUBTOTAL(109,EmployeeActual[Mar])","v":{"v":107950,"d":"₺107,950.00"}},{"$f":"SUBTOTAL(109,EmployeeActual[Nis])","v":{"v":111760,"d":"₺111,760.00"}},{"$f":"SUBTOTAL(109,EmployeeActual[May])","v":{"v":111760,"d":"₺111,760.00"}},{"$f":"SUBTOTAL(109,EmployeeActual[Haz])","v":{"v":111760,"d":"₺111,760.00"}},{"$f":"SUBTOTAL(109,EmployeeActual[Tem])","v":{"v":0,"d":"₺0.00"}},{"$f":"SUBTOTAL(109,EmployeeActual[Ağu])","v":{"v":0,"d":"₺0.00"}},{"$f":"SUBTOTAL(109,EmployeeActual[Eyl])","v":{"v":0,"d":"₺0.00"}},{"$f":"SUBTOTAL(109,EmployeeActual[Eki])","v":{"v":0,"d":"₺0.00"}},{"$f":"SUBTOTAL(109,EmployeeActual[Kas])","v":{"v":0,"d":"₺0.00"}},{"$f":"SUBTOTAL(109,EmployeeActual[Ara])","v":{"v":0,"d":"₺0.00"}},{"$f":"SUBTOTAL(109,EmployeeActual[YIL])","v":{"v":659130,"d":"₺659,130.00"}}]
[]
[null,"Ofis Maliyetleri","Oca","Şub","Mar","Nis","May","Haz","Tem","Ağu","Eyl","Eki","Kas","Ara","YIL"]
[null,"Ofis kirası",{"v":9800,"d":"₺9,800.00"},{"v":9800,"d":"₺9,800.00"},{"v":9800,"d":"₺9,800.00"},{"v":9800,"d":"₺9,800.00"},{"v":9800,"d":"₺9,800.00"},{"v":9800,"d":"₺9,800.00"},{"$nulls":6},{"$f":"SUM(C11:N11)","v":{"v":58800,"d":"₺58,800.00"}}]
[null,"Doğalgaz",{"v":4,"d":"₺4.00"},{"v":430,"d":"₺430.00"},{"v":385,"d":"₺385.00"},{"v":230,"d":"₺230.00"},{"v":87,"d":"₺87.00"},{"v":88,"d":"₺88.00"},{"$nulls":6},{"v":1224,"d":"₺1,224.00"}]
[null,"Elektrik",{"v":288,"d":"₺288.00"},{"v":278,"d":"₺278.00"},{"v":268,"d":"₺268.00"},{"v":299,"d":"₺299.00"},{"v":306,"d":"₺306.00"},{"v":290,"d":"₺290.00"},{"$nulls":6},{"v":1729,"d":"₺1,729.00"}]
[null,"Su",{"v":35,"d":"₺35.00"},{"v":33,"d":"₺33.00"},{"v":34,"d":"₺34.00"},{"v":36,"d":"₺36.00"},{"v":34,"d":"₺34.00"},{"v":36,"d":"₺36.00"},{"$nulls":6},{"v":208,"d":"₺208.00"}]
[null,"Telefon",{"v":224,"d":"₺224.00"},{"v":235,"d":"₺235.00"},{"v":265,"d":"₺265.00"},{"v":245,"d":"₺245.00"},{"v":245,"d":"₺245.00"},{"v":220,"d":"₺220.00"},{"$nulls":6},{"v":1434,"d":"₺1,434.00"}]
[null,"İnternet erişimi",{"v":180,"d":"₺180.00"},{"v":180,"d":"₺180.00"},{"v":180,"d":"₺180.00"},{"v":180,"d":"₺180.00"},{"v":180,"d":"₺180.00"},{"v":180,"d":"₺180.00"},{"$nulls":6},{"v":1080,"d":"₺1,080.00"}]
[null,"Ofis malzemeleri",{"v":256,"d":"₺256.00"},{"v":142,"d":"₺142.00"},{"v":160,"d":"₺160.00"},{"v":221,"d":"₺221.00"},{"v":256,"d":"₺256.00"},{"v":240,"d":"₺240.00"},{"$nulls":6},{"v":1275,"d":"₺1,275.00"}]
[null,"Güvenlik",{"v":600,"d":"₺600.00"},{"v":600,"d":"₺600.00"},{"v":600,"d":"₺600.00"},{"v":600,"d":"₺600.00"},{"v":600,"d":"₺600.00"},{"v":600,"d":"₺600.00"},{"$nulls":6},{"v":3600,"d":"₺3,600.00"}]
[null,"Ara toplam",{"$f":"SUBTOTAL(109,OfficeActual[Oca])","v":{"v":11387,"d":"₺11,387.00"}},{"$f":"SUBTOTAL(109,OfficeActual[Şub])","v":{"v":11698,"d":"₺11,698.00"}},{"$f":"SUBTOTAL(109,OfficeActual[Mar])","v":{"v":11692,"d":"₺11,692.00"}},{"$f":"SUBTOTAL(109,OfficeActual[Nis])","v":{"v":11611,"d":"₺11,611.00"}},{"$f":"SUBTOTAL(109,OfficeActual[May])","v":{"v":11508,"d":"₺11,508.00"}},{"$f":"SUBTOTAL(109,OfficeActual[Haz])","v":{"v":11454,"d":"₺11,454.00"}},{"$f":"SUBTOTAL(109,OfficeActual[Tem])","v":{"v":0,"d":"₺0.00"}},{"$f":"SUBTOTAL(109,OfficeActual[Ağu])","v":{"v":0,"d":"₺0.00"}},{"$f":"SUBTOTAL(109,OfficeActual[Eyl])","v":{"v":0,"d":"₺0.00"}},{"$f":"SUBTOTAL(109,OfficeActual[Eki])","v":{"v":0,"d":"₺0.00"}},{"$f":"SUBTOTAL(109,OfficeActual[Kas])","v":{"v":0,"d":"₺0.00"}},{"$f":"SUBTOTAL(109,OfficeActual[Ara])","v":{"v":0,"d":"₺0.00"}},{"$f":"SUBTOTAL(109,OfficeActual[YIL])","v":{"v":69350,"d":"₺69,350.00"}}]
[]
[null,"Pazarlama Maliyetleri","Oca","Şub","Mar","Nis","May","Haz","Tem","Ağu","Eyl","Eki","Kas","Ara","YIL"]
[null,"Web sitesi barındırma",{"v":500,"d":"₺500.00"},{"v":500,"d":"₺500.00"},{"v":500,"d":"₺500.00"},{"v":500,"d":"₺500.00"},{"v":500,"d":"₺500.00"},{"v":500,"d":"₺500.00"},{"$nulls":6},{"$f":"SUM(C22:N22)","v":{"v":3000,"d":"₺3,000.00"}}]
[null,"Web sitesi güncelleştirmeleri",{"v":200,"d":"₺200.00"},{"v":200,"d":"₺200.00"},{"v":200,"d":"₺200.00"},{"v":200,"d":"₺200.00"},{"v":200,"d":"₺200.00"},{"v":1500,"d":"₺1,500.00"},{"$nulls":6},{"v":2500,"d":"₺2,500.00"}]
[null,"Yardımcı malzeme hazırlığı",{"v":4800,"d":"₺4,800.00"},{"v":0,"d":"₺0.00"},{"v":0,"d":"₺0.00"},{"v":5500,"d":"₺5,500.00"},{"v":0,"d":"₺0.00"},{"v":0,"d":"₺0.00"},{"$nulls":6},{"v":10300,"d":"₺10,300.00"}]
[null,"Yardımcı malzemeleri yazdırma",{"v":100,"d":"₺100.00"},{"v":500,"d":"₺500.00"},{"v":100,"d":"₺100.00"},{"v":100,"d":"₺100.00"},{"v":600,"d":"₺600.00"},{"v":180,"d":"₺180.00"},{"$nulls":6},{"v":1580,"d":"₺1,580.00"}]
[null,"Pazarlama etkinlikleri",{"v":1800,"d":"₺1,800.00"},{"v":2200,"d":"₺2,200.00"},{"v":2200,"d":"₺2,200.00"},{"v":4700,"d":"₺4,700.00"},{"v":1500,"d":"₺1,500.00"},{"v":2300,"d":"₺2,300.00"},{"$nulls":6},{"v":14700,"d":"₺14,700.00"}]
[null,"Sair giderler",{"v":145,"d":"₺145.00"},{"v":156,"d":"₺156.00"},{"v":123,"d":"₺123.00"},{"v":223,"d":"₺223.00"},{"v":187,"d":"₺187.00"},{"v":245,"d":"₺245.00"},{"$nulls":6},{"v":1079,"d":"₺1,079.00"}]
[null,"Ara toplam",{"$f":"SUBTOTAL(109,MarketingActual[Oca])","v":{"v":7545,"d":"₺7,545.00"}},{"$f":"SUBTOTAL(109,MarketingActual[Şub])","v":{"v":3556,"d":"₺3,556.00"}},{"$f":"SUBTOTAL(109,MarketingActual[Mar])","v":{"v":3123,"d":"₺3,123.00"}},{"$f":"SUBTOTAL(109,MarketingActual[Nis])","v":{"v":11223,"d":"₺11,223.00"}},{"$f":"SUBTOTAL(109,MarketingActual[May])","v":{"v":2987,"d":"₺2,987.00"}},{"$f":"SUBTOTAL(109,MarketingActual[Haz])","v":{"v":4725,"d":"₺4,725.00"}},{"$f":"SUBTOTAL(109,MarketingActual[Tem])","v":{"v":0,"d":"₺0.00"}},{"$f":"SUBTOTAL(109,MarketingActual[Ağu])","v":{"v":0,"d":"₺0.00"}},{"$f":"SUBTOTAL(109,MarketingActual[Eyl])","v":{"v":0,"d":"₺0.00"}},{"$f":"SUBTOTAL(109,MarketingActual[Eki])","v":{"v":0,"d":"₺0.00"}},{"$f":"SUBTOTAL(109,MarketingActual[Kas])","v":{"v":0,"d":"₺0.00"}},{"$f":"SUBTOTAL(109,MarketingActual[Ara])","v":{"v":0,"d":"₺0.00"}},{"$f":"SUBTOTAL(109,MarketingActual[YIL])","v":{"v":33159,"d":"₺33,159.00"}}]
[]
[null,"Eğitim/Seyahat","Oca","Şub","Mar","Nis","May","Haz","Tem","Ağu","Eyl","Eki","Kas","Ara","YIL"]
[null,"Eğitim sınıfları",{"v":1600,"d":"₺1,600.00"},{"v":2400,"d":"₺2,400.00"},{"v":1400,"d":"₺1,400.00"},{"v":1600,"d":"₺1,600.00"},{"v":1200,"d":"₺1,200.00"},{"v":2800,"d":"₺2,800.00"},{"$nulls":6},{"$f":"SUM(C31:N31)","v":{"v":11000,"d":"₺11,000.00"}}]
[null,"Eğitimle ilgili seyahat maliyetleri",{"v":1200,"d":"₺1,200.00"},{"v":2200,"d":"₺2,200.00"},{"v":1400,"d":"₺1,400.00"},{"v":1200,"d":"₺1,200.00"},{"v":800,"d":"₺800.00"},{"v":3500,"d":"₺3,500.00"},{"$nulls":6},{"$f":"SUM(C32:N32)","v":{"v":10300,"d":"₺10,300.00"}}]
[null,"Ara toplam",{"$f":"SUBTOTAL(109,TrainingAndTravelActual[Oca])","v":{"v":2800,"d":"₺2,800.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[Şub])","v":{"v":4600,"d":"₺4,600.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[Mar])","v":{"v":2800,"d":"₺2,800.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[Nis])","v":{"v":2800,"d":"₺2,800.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[May])","v":{"v":2000,"d":"₺2,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[Haz])","v":{"v":6300,"d":"₺6,300.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[Tem])","v":{"v":0,"d":"₺0.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[Ağu])","v":{"v":0,"d":"₺0.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[Eyl])","v":{"v":0,"d":"₺0.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[Eki])","v":{"v":0,"d":"₺0.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[Kas])","v":{"v":0,"d":"₺0.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[Ara])","v":{"v":0,"d":"₺0.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[YIL])","v":{"v":21300,"d":"₺21,300.00"}}]
[]
[null,"TOPLAM Planlanan Giderler","Oca","Şub","Mar","Nis","May","Haz","Tem","Ağu","Eyl","Eki","Kas","Ara","Yıl"]
[null,"Aylık Fiili Giderler",{"$f":"TrainingAndTravelActual[[#Totals],[Oca]]+MarketingActual[[#Totals],[Oca]]+OfficeActual[[#Totals],[Oca]]+EmployeeActual[[#Totals],[Oca]]","v":{"v":129682,"d":"₺129,682.00"}},{"$f":"TrainingAndTravelActual[[#Totals],[Şub]]+MarketingActual[[#Totals],[Şub]]+OfficeActual[[#Totals],[Şub]]+EmployeeActual[[#Totals],[Şub]]","v":{"v":127804,"d":"₺127,804.00"}},{"$f":"TrainingAndTravelActual[[#Totals],[Mar]]+MarketingActual[[#Totals],[Mar]]+OfficeActual[[#Totals],[Mar]]+EmployeeActual[[#Totals],[Mar]]","v":{"v":125565,"d":"₺125,565.00"}},{"$f":"TrainingAndTravelActual[[#Totals],[Nis]]+MarketingActual[[#Totals],[Nis]]+OfficeActual[[#Totals],[Nis]]+EmployeeActual[[#Totals],[Nis]]","v":{"v":137394,"d":"₺137,394.00"}},{"$f":"TrainingAndTravelActual[[#Totals],[May]]+MarketingActual[[#Totals],[May]]+OfficeActual[[#Totals],[May]]+EmployeeActual[[#Totals],[May]]","v":{"v":128255,"d":"₺128,255.00"}},{"$f":"TrainingAndTravelActual[[#Totals],[Haz]]+MarketingActual[[#Totals],[Haz]]+OfficeActual[[#Totals],[Haz]]+EmployeeActual[[#Totals],[Haz]]","v":{"v":134239,"d":"₺134,239.00"}},{"$f":"TrainingAndTravelActual[[#Totals],[Tem]]+MarketingActual[[#Totals],[Tem]]+OfficeActual[[#Totals],[Tem]]+EmployeeActual[[#Totals],[Tem]]","v":{"v":0,"d":"₺0.00"}},{"$f":"TrainingAndTravelActual[[#Totals],[Ağu]]+MarketingActual[[#Totals],[Ağu]]+OfficeActual[[#Totals],[Ağu]]+EmployeeActual[[#Totals],[Ağu]]","v":{"v":0,"d":"₺0.00"}},{"$f":"TrainingAndTravelActual[[#Totals],[Eyl]]+MarketingActual[[#Totals],[Eyl]]+OfficeActual[[#Totals],[Eyl]]+EmployeeActual[[#Totals],[Eyl]]","v":{"v":0,"d":"₺0.00"}},{"$f":"TrainingAndTravelActual[[#Totals],[Eki]]+MarketingActual[[#Totals],[Eki]]+OfficeActual[[#Totals],[Eki]]+EmployeeActual[[#Totals],[Eki]]","v":{"v":0,"d":"₺0.00"}},{"$f":"TrainingAndTravelActual[[#Totals],[Kas]]+MarketingActual[[#Totals],[Kas]]+OfficeActual[[#Totals],[Kas]]+EmployeeActual[[#Totals],[Kas]]","v":{"v":0,"d":"₺0.00"}},{"$f":"TrainingAndTravelActual[[#Totals],[Ara]]+MarketingActual[[#Totals],[Ara]]+OfficeActual[[#Totals],[Ara]]+EmployeeActual[[#Totals],[Ara]]","v":{"v":0,"d":"₺0.00"}},{"$f":"TrainingAndTravelActual[[#Totals],[YIL]]+MarketingActual[[#Totals],[YIL]]+OfficeActual[[#Totals],[YIL]]+EmployeeActual[[#Totals],[YIL]]","v":{"v":782939,"d":"₺782,939.00"}}]
[null,"TOPLAM Fiili Giderler",{"$f":"SUM($C$36:C36)","v":{"v":129682,"d":"₺129,682.00"}},{"$f":"SUM($C$36:D36)","v":{"v":257486,"d":"₺257,486.00"}},{"$f":"SUM($C$36:E36)","v":{"v":383051,"d":"₺383,051.00"}},{"$f":"SUM($C$36:F36)","v":{"v":520445,"d":"₺520,445.00"}},{"$f":"SUM($C$36:G36)","v":{"v":648700,"d":"₺648,700.00"}},{"$f":"SUM($C$36:H36)","v":{"v":782939,"d":"₺782,939.00"}},{"$f":"SUM($C$36:I36)","v":{"v":782939,"d":"₺782,939.00"}},{"$f":"SUM($C$36:J36)","v":{"v":782939,"d":"₺782,939.00"}},{"$f":"SUM($C$36:K36)","v":{"v":782939,"d":"₺782,939.00"}},{"$f":"SUM($C$36:L36)","v":{"v":782939,"d":"₺782,939.00"}},{"$f":"SUM($C$36:M36)","v":{"v":782939,"d":"₺782,939.00"}},{"$f":"SUM($C$36:N36)","v":{"v":782939,"d":"₺782,939.00"}}]

{"sheet":"GİDER VARYANSLARI","index":3,"n_rows":37,"n_cols":16,"rows_kept":37,"merged":[[1,10,1,12],[2,10,2,12]]}
[{"$nulls":15}," "]
[null,{"$f":"'PLANLANAN GİDERLER'!B2:D3","v":"Şirket Adı"},{"$nulls":8},{"$f":"worksheet_title","v":"Ayrıntılı Gider Tahminleri"}]
[{"$nulls":10},"Gölgeli hücreler hesaplamalardır."]
[null,"GİDER VARYANSLARI","OCA","ŞUB","MAR","NİS","MAY","HAZ","TEM","AĞU","EYL","EKİ","KAS","ARA","YIL"]
[null,"Çalışan Maliyetleri","Oca","Şub","Mar","Nis","May","Haz","Tem","Ağu","Eyl","Eki","Kas","Ara","YIL"]
[null,"Maaşlar",{"$f":"INDEX(ÇalışanPlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Oca]]),1),INDEX(ÇalışanPlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Oca]],ÇalışanPlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Oca]]),1),INDEX(ÇalışanPlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Oca]],EmployeeActual[#Headers],0))","v":{"v":0,"d":"₺0.00"}},{"$f":"INDEX(ÇalışanPlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Şub]]),1),INDEX(ÇalışanPlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Şub]],ÇalışanPlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Şub]]),1),INDEX(ÇalışanPlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Şub]],EmployeeActual[#Headers],0))","v":{"v":0,"d":"₺0.00"}},{"$f":"INDEX(ÇalışanPlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Mar]]),1),INDEX(ÇalışanPlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Mar]],ÇalışanPlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Mar]]),1),INDEX(ÇalışanPlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Mar]],EmployeeActual[#Headers],0))","v":{"v":0,"d":"₺0.00"}},{"$f":"INDEX(ÇalışanPlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Nis]]),1),INDEX(ÇalışanPlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Nis]],ÇalışanPlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Nis]]),1),INDEX(ÇalışanPlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Nis]],EmployeeActual[#Headers],0))","v":{"v":-500,"d":"-₺500.00"}},{"$f":"INDEX(ÇalışanPlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[May]]),1),INDEX(ÇalışanPlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[May]],ÇalışanPlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[May]]),1),INDEX(ÇalışanPlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[May]],EmployeeActual[#Headers],0))","v":{"v":-500,"d":"-₺500.00"}},{"$f":"INDEX(ÇalışanPlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Haz]]),1),INDEX(ÇalışanPlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Haz]],ÇalışanPlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Haz]]),1),INDEX(ÇalışanPlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Haz]],EmployeeActual[#Headers],0))","v":{"v":-500,"d":"-₺500.00"}},{"$f":"INDEX(ÇalışanPlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Tem]]),1),INDEX(ÇalışanPlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Tem]],ÇalışanPlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Tem]]),1),INDEX(ÇalışanPlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Tem]],EmployeeActual[#Headers],0))","v":{"v":87500,"d":"₺87,500.00"}},{"$f":"INDEX(ÇalışanPlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Ağu]]),1),INDEX(ÇalışanPlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Ağu]],ÇalışanPlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Ağu]]),1),INDEX(ÇalışanPlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Ağu]],EmployeeActual[#Headers],0))","v":{"v":92400,"d":"₺92,400.00"}},{"$f":"INDEX(ÇalışanPlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Eyl]]),1),INDEX(ÇalışanPlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Eyl]],ÇalışanPlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Eyl]]),1),INDEX(ÇalışanPlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Eyl]],EmployeeActual[#Headers],0))","v":{"v":92400,"d":"₺92,400.00"}},{"$f":"INDEX(ÇalışanPlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Eki]]),1),INDEX(ÇalışanPlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Eki]],ÇalışanPlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Eki]]),1),INDEX(ÇalışanPlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Eki]],EmployeeActual[#Headers],0))","v":{"v":92400,"d":"₺92,400.00"}},{"$f":"INDEX(ÇalışanPlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Kas]]),1),INDEX(ÇalışanPlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Kas]],ÇalışanPlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Kas]]),1),INDEX(ÇalışanPlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Kas]],EmployeeActual[#Headers],0))","v":{"v":92400,"d":"₺92,400.00"}},{"$f":"INDEX(ÇalışanPlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Ara]]),1),INDEX(ÇalışanPlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Ara]],ÇalışanPlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Ara]]),1),INDEX(ÇalışanPlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Ara]],EmployeeActual[#Headers],0))","v":{"v":92400,"d":"₺92,400.00"}},{"$f":"SUM(EmployeeVariances[[#This Row],[Oca]:[Ara]])","v":{"v":548000,"d":"₺548,000.00"}}]
[null,"Kazançlar",{"$f":"INDEX(ÇalışanPlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Oca]]),1),INDEX(ÇalışanPlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Oca]],ÇalışanPlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Oca]]),1),INDEX(ÇalışanPlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Oca]],EmployeeActual[#Headers],0))","v":{"v":0,"d":"₺0.00"}},{"$f":"INDEX(ÇalışanPlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Şub]]),1),INDEX(ÇalışanPlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Şub]],ÇalışanPlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Şub]]),1),INDEX(ÇalışanPlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Şub]],EmployeeActual[#Headers],0))","v":{"v":0,"d":"₺0.00"}},{"$f":"INDEX(ÇalışanPlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Mar]]),1),INDEX(ÇalışanPlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Mar]],ÇalışanPlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Mar]]),1),INDEX(ÇalışanPlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Mar]],EmployeeActual[#Headers],0))","v":{"v":0,"d":"₺0.00"}},{"$f":"INDEX(ÇalışanPlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Nis]]),1),INDEX(ÇalışanPlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Nis]],ÇalışanPlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Nis]]),1),INDEX(ÇalışanPlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Nis]],EmployeeActual[#Headers],0))","v":{"v":-135,"d":"-₺135.00"}},{"$f":"INDEX(ÇalışanPlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[May]]),1),INDEX(ÇalışanPlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[May]],ÇalışanPlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[May]]),1),INDEX(ÇalışanPlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[May]],EmployeeActual[#Headers],0))","v":{"v":-135,"d":"-₺135.00"}},{"$f":"INDEX(ÇalışanPlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Haz]]),1),INDEX(ÇalışanPlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Haz]],ÇalışanPlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Haz]]),1),INDEX(ÇalışanPlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Haz]],EmployeeActual[#Headers],0))","v":{"v":-135,"d":"-₺135.00"}},{"$f":"INDEX(ÇalışanPlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Tem]]),1),INDEX(ÇalışanPlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Tem]],ÇalışanPlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Tem]]),1),INDEX(ÇalışanPlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Tem]],EmployeeActual[#Headers],0))","v":{"v":23625,"d":"₺23,625.00"}},{"$f":"INDEX(ÇalışanPlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Ağu]]),1),INDEX(ÇalışanPlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Ağu]],ÇalışanPlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Ağu]]),1),INDEX(ÇalışanPlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Ağu]],EmployeeActual[#Headers],0))","v":{"v":24948,"d":"₺24,948.00"}},{"$f":"INDEX(ÇalışanPlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Eyl]]),1),INDEX(ÇalışanPlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Eyl]],ÇalışanPlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Eyl]]),1),INDEX(ÇalışanPlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Eyl]],EmployeeActual[#Headers],0))","v":{"v":24948,"d":"₺24,948.00"}},{"$f":"INDEX(ÇalışanPlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Eki]]),1),INDEX(ÇalışanPlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Eki]],ÇalışanPlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Eki]]),1),INDEX(ÇalışanPlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Eki]],EmployeeActual[#Headers],0))","v":{"v":24948,"d":"₺24,948.00"}},{"$f":"INDEX(ÇalışanPlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Kas]]),1),INDEX(ÇalışanPlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Kas]],ÇalışanPlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Kas]]),1),INDEX(ÇalışanPlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Kas]],EmployeeActual[#Headers],0))","v":{"v":24948,"d":"₺24,948.00"}},{"$f":"INDEX(ÇalışanPlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Ara]]),1),INDEX(ÇalışanPlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Ara]],ÇalışanPlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Ara]]),1),INDEX(ÇalışanPlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Ara]],EmployeeActual[#Headers],0))","v":{"v":24948,"d":"₺24,948.00"}},{"$f":"SUM(EmployeeVariances[[#This Row],[Oca]:[Ara]])","v":{"v":147960,"d":"₺147,960.00"}}]
[null,"Ara toplam",{"$f":"SUBTOTAL(109,EmployeeVariances[Oca])","v":{"v":0,"d":"₺0.00"}},{"$f":"SUBTOTAL(109,EmployeeVariances[Şub])","v":{"v":0,"d":"₺0.00"}},{"$f":"SUBTOTAL(109,EmployeeVariances[Mar])","v":{"v":0,"d":"₺0.00"}},{"$f":"SUBTOTAL(109,EmployeeVariances[Nis])","v":{"v":-635,"d":"-₺635.00"}},{"$f":"SUBTOTAL(109,EmployeeVariances[May])","v":{"v":-635,"d":"-₺635.00"}},{"$f":"SUBTOTAL(109,EmployeeVariances[Haz])","v":{"v":-635,"d":"-₺635.00"}},{"$f":"SUBTOTAL(109,EmployeeVariances[Tem])","v":{"v":111125,"d":"₺111,125.00"}},{"$f":"SUBTOTAL(109,EmployeeVariances[Ağu])","v":{"v":117348,"d":"₺117,348.00"}},{"$f":"SUBTOTAL(109,EmployeeVariances[Eyl])","v":{"v":117348,"d":"₺117,348.00"}},{"$f":"SUBTOTAL(109,EmployeeVariances[Eki])","v":{"v":117348,"d":"₺117,348.00"}},{"$f":"SUBTOTAL(109,EmployeeVariances[Kas])","v":{"v":117348,"d":"₺117,348.00"}},{"$f":"SUBTOTAL(109,EmployeeVariances[Ara])","v":{"v":117348,"d":"₺117,348.00"}},{"$f":"SUBTOTAL(109,EmployeeVariances[YIL])","v":{"v":695960,"d":"₺695,960.00"}}]
[]
[null,"Ofis Maliyetleri","Oca","Şub","Mar","Nis","May","Haz","Tem","Ağu","Eyl","Eki","Kas","Ara","YIL"]
[null,"Ofis kirası",{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Oca]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Oca]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Oca]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Oca]],OfficeActual[#Headers],0))","v":{"v":0,"d":"₺0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Şub]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Şub]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Şub]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Şub]],OfficeActual[#Headers],0))","v":{"v":0,"d":"₺0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Mar]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Mar]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Mar]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Mar]],OfficeActual[#Headers],0))","v":{"v":0,"d":"₺0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Nis]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Nis]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Nis]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Nis]],OfficeActual[#Headers],0))","v":{"v":0,"d":"₺0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[May]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[May]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[May]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[May]],OfficeActual[#Headers],0))","v":{"v":0,"d":"₺0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Haz]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Haz]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Haz]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Haz]],OfficeActual[#Headers],0))","v":{"v":0,"d":"₺0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Tem]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Tem]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Tem]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Tem]],OfficeActual[#Headers],0))","v":{"v":9800,"d":"₺9,800.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Ağu]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Ağu]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Ağu]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Ağu]],OfficeActual[#Headers],0))","v":{"v":9800,"d":"₺9,800.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Eyl]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Eyl]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Eyl]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Eyl]],OfficeActual[#Headers],0))","v":{"v":9800,"d":"₺9,800.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Eki]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Eki]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Eki]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Eki]],OfficeActual[#Headers],0))","v":{"v":9800,"d":"₺9,800.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Kas]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Kas]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Kas]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Kas]],OfficeActual[#Headers],0))","v":{"v":9800,"d":"₺9,800.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Ara]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Ara]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Ara]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Ara]],OfficeActual[#Headers],0))","v":{"v":9800,"d":"₺9,800.00"}},{"$f":"SUM(OfficeVariances[[#This Row],[Oca]:[Ara]])","v":{"v":58800,"d":"₺58,800.00"}}]
[null,"Doğalgaz",{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Oca]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Oca]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Oca]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Oca]],OfficeActual[#Headers],0))","v":{"v":-4,"d":"-₺4.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Şub]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Şub]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Şub]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Şub]],OfficeActual[#Headers],0))","v":{"v":-30,"d":"-₺30.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Mar]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Mar]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Mar]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Mar]],OfficeActual[#Headers],0))","v":{"v":15,"d":"₺15.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Nis]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Nis]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Nis]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Nis]],OfficeActual[#Headers],0))","v":{"v":-130,"d":"-₺130.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[May]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[May]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[May]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[May]],OfficeActual[#Headers],0))","v":{"v":13,"d":"₺13.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Haz]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Haz]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Haz]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Haz]],OfficeActual[#Headers],0))","v":{"v":12,"d":"₺12.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Tem]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Tem]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Tem]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Tem]],OfficeActual[#Headers],0))","v":{"v":100,"d":"₺100.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Ağu]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Ağu]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Ağu]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Ağu]],OfficeActual[#Headers],0))","v":{"v":100,"d":"₺100.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Eyl]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Eyl]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Eyl]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Eyl]],OfficeActual[#Headers],0))","v":{"v":100,"d":"₺100.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Eki]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Eki]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Eki]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Eki]],OfficeActual[#Headers],0))","v":{"v":100,"d":"₺100.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Kas]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Kas]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Kas]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Kas]],OfficeActual[#Headers],0))","v":{"v":400,"d":"₺400.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Ara]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Ara]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Ara]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Ara]],OfficeActual[#Headers],0))","v":{"v":400,"d":"₺400.00"}},{"$f":"SUM(OfficeVariances[[#This Row],[Oca]:[Ara]])","v":{"v":1076,"d":"₺1,076.00"}}]
[null,"Elektrik",{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Oca]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Oca]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Oca]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Oca]],OfficeActual[#Headers],0))","v":{"v":12,"d":"₺12.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Şub]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Şub]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Şub]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Şub]],OfficeActual[#Headers],0))","v":{"v":22,"d":"₺22.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Mar]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Mar]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Mar]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Mar]],OfficeActual[#Headers],0))","v":{"v":32,"d":"₺32.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Nis]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Nis]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Nis]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Nis]],OfficeActual[#Headers],0))","v":{"v":1,"d":"₺1.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[May]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[May]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[May]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[May]],OfficeActual[#Headers],0))","v":{"v":-6,"d":"-₺6.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Haz]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Haz]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Haz]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Haz]],OfficeActual[#Headers],0))","v":{"v":10,"d":"₺10.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Tem]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Tem]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Tem]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Tem]],OfficeActual[#Headers],0))","v":{"v":300,"d":"₺300.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Ağu]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Ağu]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Ağu]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Ağu]],OfficeActual[#Headers],0))","v":{"v":300,"d":"₺300.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Eyl]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Eyl]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Eyl]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Eyl]],OfficeActual[#Headers],0))","v":{"v":300,"d":"₺300.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Eki]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Eki]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Eki]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Eki]],OfficeActual[#Headers],0))","v":{"v":300,"d":"₺300.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Kas]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Kas]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Kas]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Kas]],OfficeActual[#Headers],0))","v":{"v":300,"d":"₺300.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Ara]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Ara]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Ara]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Ara]],OfficeActual[#Headers],0))","v":{"v":300,"d":"₺300.00"}},{"$f":"SUM(OfficeVariances[[#This Row],[Oca]:[Ara]])","v":{"v":1871,"d":"₺1,871.00"}}]
[null,"Su",{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Oca]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Oca]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Oca]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Oca]],OfficeActual[#Headers],0))","v":{"v":5,"d":"₺5.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Şub]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Şub]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Şub]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Şub]],OfficeActual[#Headers],0))","v":{"v":7,"d":"₺7.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Mar]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Mar]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Mar]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Mar]],OfficeActual[#Headers],0))","v":{"v":6,"d":"₺6.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Nis]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Nis]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Nis]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Nis]],OfficeActual[#Headers],0))","v":{"v":4,"d":"₺4.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[May]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[May]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[May]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[May]],OfficeActual[#Headers],0))","v":{"v":6,"d":"₺6.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Haz]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Haz]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Haz]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Haz]],OfficeActual[#Headers],0))","v":{"v":4,"d":"₺4.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Tem]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Tem]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Tem]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Tem]],OfficeActual[#Headers],0))","v":{"v":40,"d":"₺40.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Ağu]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Ağu]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Ağu]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Ağu]],OfficeActual[#Headers],0))","v":{"v":40,"d":"₺40.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Eyl]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Eyl]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Eyl]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Eyl]],OfficeActual[#Headers],0))","v":{"v":40,"d":"₺40.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Eki]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Eki]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Eki]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Eki]],OfficeActual[#Headers],0))","v":{"v":40,"d":"₺40.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Kas]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Kas]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Kas]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Kas]],OfficeActual[#Headers],0))","v":{"v":40,"d":"₺40.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Ara]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Ara]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Ara]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Ara]],OfficeActual[#Headers],0))","v":{"v":40,"d":"₺40.00"}},{"$f":"SUM(OfficeVariances[[#This Row],[Oca]:[Ara]])","v":{"v":272,"d":"₺272.00"}}]
[null,"Telefon",{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Oca]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Oca]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Oca]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Oca]],OfficeActual[#Headers],0))","v":{"v":26,"d":"₺26.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Şub]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Şub]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Şub]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Şub]],OfficeActual[#Headers],0))","v":{"v":15,"d":"₺15.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Mar]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Mar]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Mar]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Mar]],OfficeActual[#Headers],0))","v":{"v":-15,"d":"-₺15.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Nis]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Nis]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Nis]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Nis]],OfficeActual[#Headers],0))","v":{"v":5,"d":"₺5.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[May]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[May]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[May]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[May]],OfficeActual[#Headers],0))","v":{"v":5,"d":"₺5.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Haz]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Haz]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Haz]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Haz]],OfficeActual[#Headers],0))","v":{"v":30,"d":"₺30.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Tem]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Tem]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Tem]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Tem]],OfficeActual[#Headers],0))","v":{"v":250,"d":"₺250.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Ağu]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Ağu]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Ağu]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Ağu]],OfficeActual[#Headers],0))","v":{"v":250,"d":"₺250.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Eyl]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Eyl]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Eyl]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Eyl]],OfficeActual[#Headers],0))","v":{"v":250,"d":"₺250.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Eki]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Eki]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Eki]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Eki]],OfficeActual[#Headers],0))","v":{"v":250,"d":"₺250.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Kas]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Kas]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Kas]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Kas]],OfficeActual[#Headers],0))","v":{"v":250,"d":"₺250.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Ara]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Ara]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Ara]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Ara]],OfficeActual[#Headers],0))","v":{"v":250,"d":"₺250.00"}},{"$f":"SUM(OfficeVariances[[#This Row],[Oca]:[Ara]])","v":{"v":1566,"d":"₺1,566.00"}}]
[null,"İnternet erişimi",{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Oca]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Oca]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Oca]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Oca]],OfficeActual[#Headers],0))","v":{"v":0,"d":"₺0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Şub]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Şub]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Şub]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Şub]],OfficeActual[#Headers],0))","v":{"v":0,"d":"₺0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Mar]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Mar]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Mar]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Mar]],OfficeActual[#Headers],0))","v":{"v":0,"d":"₺0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Nis]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Nis]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Nis]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Nis]],OfficeActual[#Headers],0))","v":{"v":0,"d":"₺0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[May]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[May]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[May]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[May]],OfficeActual[#Headers],0))","v":{"v":0,"d":"₺0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Haz]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Haz]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Haz]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Haz]],OfficeActual[#Headers],0))","v":{"v":0,"d":"₺0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Tem]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Tem]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Tem]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Tem]],OfficeActual[#Headers],0))","v":{"v":180,"d":"₺180.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Ağu]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Ağu]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Ağu]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Ağu]],OfficeActual[#Headers],0))","v":{"v":180,"d":"₺180.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Eyl]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Eyl]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Eyl]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Eyl]],OfficeActual[#Headers],0))","v":{"v":180,"d":"₺180.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Eki]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Eki]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Eki]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Eki]],OfficeActual[#Headers],0))","v":{"v":180,"d":"₺180.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Kas]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Kas]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Kas]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Kas]],OfficeActual[#Headers],0))","v":{"v":180,"d":"₺180.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Ara]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Ara]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Ara]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Ara]],OfficeActual[#Headers],0))","v":{"v":180,"d":"₺180.00"}},{"$f":"SUM(OfficeVariances[[#This Row],[Oca]:[Ara]])","v":{"v":1080,"d":"₺1,080.00"}}]
[null,"Ofis malzemeleri",{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Oca]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Oca]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Oca]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Oca]],OfficeActual[#Headers],0))","v":{"v":-56,"d":"-₺56.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Şub]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Şub]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Şub]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Şub]],OfficeActual[#Headers],0))","v":{"v":58,"d":"₺58.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Mar]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Mar]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Mar]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Mar]],OfficeActual[#Headers],0))","v":{"v":40,"d":"₺40.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Nis]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Nis]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Nis]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Nis]],OfficeActual[#Headers],0))","v":{"v":-21,"d":"-₺21.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[May]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[May]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[May]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[May]],OfficeActual[#Headers],0))","v":{"v":-56,"d":"-₺56.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Haz]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Haz]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Haz]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Haz]],OfficeActual[#Headers],0))","v":{"v":-40,"d":"-₺40.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Tem]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Tem]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Tem]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Tem]],OfficeActual[#Headers],0))","v":{"v":200,"d":"₺200.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Ağu]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Ağu]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Ağu]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Ağu]],OfficeActual[#Headers],0))","v":{"v":200,"d":"₺200.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Eyl]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Eyl]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Eyl]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Eyl]],OfficeActual[#Headers],0))","v":{"v":200,"d":"₺200.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Eki]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Eki]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Eki]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Eki]],OfficeActual[#Headers],0))","v":{"v":200,"d":"₺200.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Kas]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Kas]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Kas]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Kas]],OfficeActual[#Headers],0))","v":{"v":200,"d":"₺200.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Ara]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Ara]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Ara]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Ara]],OfficeActual[#Headers],0))","v":{"v":200,"d":"₺200.00"}},{"$f":"SUM(OfficeVariances[[#This Row],[Oca]:[Ara]])","v":{"v":1125,"d":"₺1,125.00"}}]
[null,"Güvenlik",{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Oca]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Oca]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Oca]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Oca]],OfficeActual[#Headers],0))","v":{"v":0,"d":"₺0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Şub]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Şub]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Şub]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Şub]],OfficeActual[#Headers],0))","v":{"v":0,"d":"₺0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Mar]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Mar]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Mar]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Mar]],OfficeActual[#Headers],0))","v":{"v":0,"d":"₺0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Nis]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Nis]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Nis]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Nis]],OfficeActual[#Headers],0))","v":{"v":0,"d":"₺0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[May]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[May]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[May]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[May]],OfficeActual[#Headers],0))","v":{"v":0,"d":"₺0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Haz]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Haz]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Haz]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Haz]],OfficeActual[#Headers],0))","v":{"v":0,"d":"₺0.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Tem]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Tem]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Tem]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Tem]],OfficeActual[#Headers],0))","v":{"v":600,"d":"₺600.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Ağu]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Ağu]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Ağu]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Ağu]],OfficeActual[#Headers],0))","v":{"v":600,"d":"₺600.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Eyl]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Eyl]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Eyl]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Eyl]],OfficeActual[#Headers],0))","v":{"v":600,"d":"₺600.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Eki]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Eki]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Eki]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Eki]],OfficeActual[#Headers],0))","v":{"v":600,"d":"₺600.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Kas]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Kas]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Kas]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Kas]],OfficeActual[#Headers],0))","v":{"v":600,"d":"₺600.00"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Ara]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Ara]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Ara]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Ara]],OfficeActual[#Headers],0))","v":{"v":600,"d":"₺600.00"}},{"$f":"SUM(OfficeVariances[[#This Row],[Oca]:[Ara]])","v":{"v":3600,"d":"₺3,600.00"}}]
[null,"Ara toplam",{"$f":"SUBTOTAL(109,OfficeVariances[Oca])","v":{"v":-17,"d":"-₺17.00"}},{"$f":"SUBTOTAL(109,OfficeVariances[Şub])","v":{"v":72,"d":"₺72.00"}},{"$f":"SUBTOTAL(109,OfficeVariances[Mar])","v":{"v":78,"d":"₺78.00"}},{"$f":"SUBTOTAL(109,OfficeVariances[Nis])","v":{"v":-141,"d":"-₺141.00"}},{"$f":"SUBTOTAL(109,OfficeVariances[May])","v":{"v":-38,"d":"-₺38.00"}},{"$f":"SUBTOTAL(109,OfficeVariances[Haz])","v":{"v":16,"d":"₺16.00"}},{"$f":"SUBTOTAL(109,OfficeVariances[Tem])","v":{"v":11470,"d":"₺11,470.00"}},{"$f":"SUBTOTAL(109,OfficeVariances[Ağu])","v":{"v":11470,"d":"₺11,470.00"}},{"$f":"SUBTOTAL(109,OfficeVariances[Eyl])","v":{"v":11470,"d":"₺11,470.00"}},{"$f":"SUBTOTAL(109,OfficeVariances[Eki])","v":{"v":11470,"d":"₺11,470.00"}},{"$f":"SUBTOTAL(109,OfficeVariances[Kas])","v":{"v":11770,"d":"₺11,770.00"}},{"$f":"SUBTOTAL(109,OfficeVariances[Ara])","v":{"v":11770,"d":"₺11,770.00"}},{"$f":"SUBTOTAL(109,OfficeVariances[YIL])","v":{"v":69390,"d":"₺69,390.00"}}]
[]
[null,"Pazarlama Maliyetleri","Oca","Şub","Mar","Nis","May","Haz","Tem","Ağu","Eyl","Eki","Kas","Ara","YIL"]
[null,"Web sitesi barındırma",{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Oca]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Oca]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Oca]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Oca]],MarketingActual[#Headers],0))","v":{"v":0,"d":"₺0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Şub]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Şub]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Şub]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Şub]],MarketingActual[#Headers],0))","v":{"v":0,"d":"₺0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Mar]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Mar]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Mar]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Mar]],MarketingActual[#Headers],0))","v":{"v":0,"d":"₺0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Nis]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Nis]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Nis]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Nis]],MarketingActual[#Headers],0))","v":{"v":0,"d":"₺0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[May]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[May]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[May]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[May]],MarketingActual[#Headers],0))","v":{"v":0,"d":"₺0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Haz]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Haz]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Haz]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Haz]],MarketingActual[#Headers],0))","v":{"v":0,"d":"₺0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Tem]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Tem]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Tem]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Tem]],MarketingActual[#Headers],0))","v":{"v":500,"d":"₺500.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Ağu]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Ağu]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Ağu]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Ağu]],MarketingActual[#Headers],0))","v":{"v":500,"d":"₺500.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Eyl]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Eyl]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Eyl]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Eyl]],MarketingActual[#Headers],0))","v":{"v":500,"d":"₺500.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Eki]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Eki]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Eki]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Eki]],MarketingActual[#Headers],0))","v":{"v":500,"d":"₺500.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Kas]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Kas]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Kas]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Kas]],MarketingActual[#Headers],0))","v":{"v":500,"d":"₺500.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Ara]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Ara]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Ara]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Ara]],MarketingActual[#Headers],0))","v":{"v":500,"d":"₺500.00"}},{"$f":"SUM(MarketingVariances[[#This Row],[Oca]:[Ara]])","v":{"v":3000,"d":"₺3,000.00"}}]
[null,"Web sitesi güncelleştirmeleri",{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Oca]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Oca]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Oca]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Oca]],MarketingActual[#Headers],0))","v":{"v":0,"d":"₺0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Şub]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Şub]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Şub]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Şub]],MarketingActual[#Headers],0))","v":{"v":0,"d":"₺0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Mar]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Mar]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Mar]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Mar]],MarketingActual[#Headers],0))","v":{"v":0,"d":"₺0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Nis]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Nis]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Nis]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Nis]],MarketingActual[#Headers],0))","v":{"v":0,"d":"₺0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[May]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[May]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[May]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[May]],MarketingActual[#Headers],0))","v":{"v":0,"d":"₺0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Haz]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Haz]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Haz]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Haz]],MarketingActual[#Headers],0))","v":{"v":-500,"d":"-₺500.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Tem]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Tem]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Tem]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Tem]],MarketingActual[#Headers],0))","v":{"v":200,"d":"₺200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Ağu]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Ağu]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Ağu]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Ağu]],MarketingActual[#Headers],0))","v":{"v":200,"d":"₺200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Eyl]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Eyl]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Eyl]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Eyl]],MarketingActual[#Headers],0))","v":{"v":200,"d":"₺200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Eki]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Eki]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Eki]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Eki]],MarketingActual[#Headers],0))","v":{"v":200,"d":"₺200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Kas]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Kas]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Kas]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Kas]],MarketingActual[#Headers],0))","v":{"v":200,"d":"₺200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Ara]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Ara]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Ara]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Ara]],MarketingActual[#Headers],0))","v":{"v":1000,"d":"₺1,000.00"}},{"$f":"SUM(MarketingVariances[[#This Row],[Oca]:[Ara]])","v":{"v":1500,"d":"₺1,500.00"}}]
[null,"Yardımcı malzeme hazırlığı",{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Oca]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Oca]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Oca]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Oca]],MarketingActual[#Headers],0))","v":{"v":200,"d":"₺200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Şub]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Şub]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Şub]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Şub]],MarketingActual[#Headers],0))","v":{"v":0,"d":"₺0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Mar]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Mar]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Mar]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Mar]],MarketingActual[#Headers],0))","v":{"v":0,"d":"₺0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Nis]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Nis]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Nis]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Nis]],MarketingActual[#Headers],0))","v":{"v":-500,"d":"-₺500.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[May]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[May]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[May]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[May]],MarketingActual[#Headers],0))","v":{"v":0,"d":"₺0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Haz]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Haz]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Haz]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Haz]],MarketingActual[#Headers],0))","v":{"v":0,"d":"₺0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Tem]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Tem]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Tem]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Tem]],MarketingActual[#Headers],0))","v":{"v":5000,"d":"₺5,000.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Ağu]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Ağu]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Ağu]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Ağu]],MarketingActual[#Headers],0))","v":{"v":0,"d":"₺0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Eyl]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Eyl]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Eyl]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Eyl]],MarketingActual[#Headers],0))","v":{"v":0,"d":"₺0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Eki]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Eki]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Eki]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Eki]],MarketingActual[#Headers],0))","v":{"v":5000,"d":"₺5,000.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Kas]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Kas]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Kas]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Kas]],MarketingActual[#Headers],0))","v":{"v":0,"d":"₺0.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Ara]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Ara]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Ara]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Ara]],MarketingActual[#Headers],0))","v":{"v":0,"d":"₺0.00"}},{"$f":"SUM(MarketingVariances[[#This Row],[Oca]:[Ara]])","v":{"v":9700,"d":"₺9,700.00"}}]
[null,"Yardımcı malzemeleri yazdırma",{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Oca]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Oca]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Oca]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Oca]],MarketingActual[#Headers],0))","v":{"v":100,"d":"₺100.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Şub]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Şub]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Şub]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Şub]],MarketingActual[#Headers],0))","v":{"v":-300,"d":"-₺300.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Mar]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Mar]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Mar]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Mar]],MarketingActual[#Headers],0))","v":{"v":100,"d":"₺100.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Nis]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Nis]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Nis]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Nis]],MarketingActual[#Headers],0))","v":{"v":100,"d":"₺100.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[May]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[May]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[May]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[May]],MarketingActual[#Headers],0))","v":{"v":-400,"d":"-₺400.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Haz]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Haz]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Haz]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Haz]],MarketingActual[#Headers],0))","v":{"v":20,"d":"₺20.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Tem]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Tem]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Tem]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Tem]],MarketingActual[#Headers],0))","v":{"v":200,"d":"₺200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Ağu]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Ağu]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Ağu]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Ağu]],MarketingActual[#Headers],0))","v":{"v":200,"d":"₺200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Eyl]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Eyl]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Eyl]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Eyl]],MarketingActual[#Headers],0))","v":{"v":200,"d":"₺200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Eki]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Eki]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Eki]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Eki]],MarketingActual[#Headers],0))","v":{"v":200,"d":"₺200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Kas]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Kas]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Kas]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Kas]],MarketingActual[#Headers],0))","v":{"v":200,"d":"₺200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Ara]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Ara]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Ara]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Ara]],MarketingActual[#Headers],0))","v":{"v":200,"d":"₺200.00"}},{"$f":"SUM(MarketingVariances[[#This Row],[Oca]:[Ara]])","v":{"v":820,"d":"₺820.00"}}]
[null,"Pazarlama etkinlikleri",{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Oca]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Oca]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Oca]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Oca]],MarketingActual[#Headers],0))","v":{"v":200,"d":"₺200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Şub]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Şub]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Şub]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Şub]],MarketingActual[#Headers],0))","v":{"v":-200,"d":"-₺200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Mar]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Mar]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Mar]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Mar]],MarketingActual[#Headers],0))","v":{"v":-200,"d":"-₺200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Nis]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Nis]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Nis]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Nis]],MarketingActual[#Headers],0))","v":{"v":300,"d":"₺300.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[May]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[May]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[May]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[May]],MarketingActual[#Headers],0))","v":{"v":500,"d":"₺500.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Haz]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Haz]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Haz]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Haz]],MarketingActual[#Headers],0))","v":{"v":-300,"d":"-₺300.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Tem]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Tem]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Tem]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Tem]],MarketingActual[#Headers],0))","v":{"v":2000,"d":"₺2,000.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Ağu]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Ağu]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Ağu]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Ağu]],MarketingActual[#Headers],0))","v":{"v":5000,"d":"₺5,000.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Eyl]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Eyl]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Eyl]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Eyl]],MarketingActual[#Headers],0))","v":{"v":2000,"d":"₺2,000.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Eki]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Eki]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Eki]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Eki]],MarketingActual[#Headers],0))","v":{"v":2000,"d":"₺2,000.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Kas]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Kas]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Kas]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Kas]],MarketingActual[#Headers],0))","v":{"v":2000,"d":"₺2,000.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Ara]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Ara]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Ara]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Ara]],MarketingActual[#Headers],0))","v":{"v":5000,"d":"₺5,000.00"}},{"$f":"SUM(MarketingVariances[[#This Row],[Oca]:[Ara]])","v":{"v":18300,"d":"₺18,300.00"}}]
[null,"Sair giderler",{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Oca]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Oca]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Oca]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Oca]],MarketingActual[#Headers],0))","v":{"v":55,"d":"₺55.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Şub]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Şub]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Şub]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Şub]],MarketingActual[#Headers],0))","v":{"v":44,"d":"₺44.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Mar]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Mar]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Mar]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Mar]],MarketingActual[#Headers],0))","v":{"v":77,"d":"₺77.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Nis]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Nis]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Nis]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Nis]],MarketingActual[#Headers],0))","v":{"v":-23,"d":"-₺23.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[May]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[May]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[May]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[May]],MarketingActual[#Headers],0))","v":{"v":13,"d":"₺13.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Haz]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Haz]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Haz]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Haz]],MarketingActual[#Headers],0))","v":{"v":-45,"d":"-₺45.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Tem]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Tem]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Tem]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Tem]],MarketingActual[#Headers],0))","v":{"v":200,"d":"₺200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Ağu]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Ağu]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Ağu]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Ağu]],MarketingActual[#Headers],0))","v":{"v":200,"d":"₺200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Eyl]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Eyl]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Eyl]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Eyl]],MarketingActual[#Headers],0))","v":{"v":200,"d":"₺200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Eki]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Eki]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Eki]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Eki]],MarketingActual[#Headers],0))","v":{"v":200,"d":"₺200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Kas]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Kas]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Kas]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Kas]],MarketingActual[#Headers],0))","v":{"v":200,"d":"₺200.00"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Ara]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Ara]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Ara]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Ara]],MarketingActual[#Headers],0))","v":{"v":200,"d":"₺200.00"}},{"$f":"SUM(MarketingVariances[[#This Row],[Oca]:[Ara]])","v":{"v":1321,"d":"₺1,321.00"}}]
[null,"Ara toplam",{"$f":"SUBTOTAL(109,MarketingVariances[Oca])","v":{"v":555,"d":"₺555.00"}},{"$f":"SUBTOTAL(109,MarketingVariances[Şub])","v":{"v":-456,"d":"-₺456.00"}},{"$f":"SUBTOTAL(109,MarketingVariances[Mar])","v":{"v":-23,"d":"-₺23.00"}},{"$f":"SUBTOTAL(109,MarketingVariances[Nis])","v":{"v":-123,"d":"-₺123.00"}},{"$f":"SUBTOTAL(109,MarketingVariances[May])","v":{"v":113,"d":"₺113.00"}},{"$f":"SUBTOTAL(109,MarketingVariances[Haz])","v":{"v":-825,"d":"-₺825.00"}},{"$f":"SUBTOTAL(109,MarketingVariances[Tem])","v":{"v":8100,"d":"₺8,100.00"}},{"$f":"SUBTOTAL(109,MarketingVariances[Ağu])","v":{"v":6100,"d":"₺6,100.00"}},{"$f":"SUBTOTAL(109,MarketingVariances[Eyl])","v":{"v":3100,"d":"₺3,100.00"}},{"$f":"SUBTOTAL(109,MarketingVariances[Eki])","v":{"v":8100,"d":"₺8,100.00"}},{"$f":"SUBTOTAL(109,MarketingVariances[Kas])","v":{"v":3100,"d":"₺3,100.00"}},{"$f":"SUBTOTAL(109,MarketingVariances[Ara])","v":{"v":6900,"d":"₺6,900.00"}},{"$f":"SUBTOTAL(109,MarketingVariances[YIL])","v":{"v":34641,"d":"₺34,641.00"}}]
[]
[null,"Eğitim/Seyahat","Oca","Şub","Mar","Nis","May","Haz","Tem","Ağu","Eyl","Eki","Kas","Ara","YIL"]
[null,"Eğitim sınıfları",{"$f":"INDEX(EğitimVeSeyahatPlanı[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Oca]]),1),INDEX(EğitimVeSeyahatPlanı[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Oca]],EğitimVeSeyahatPlanı[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Oca]]),1),INDEX(EğitimVeSeyahatPlanı[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Oca]],TrainingAndTravelActual[#Headers],0))","v":{"v":400,"d":"₺400.00"}},{"$f":"INDEX(EğitimVeSeyahatPlanı[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Şub]]),1),INDEX(EğitimVeSeyahatPlanı[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Şub]],EğitimVeSeyahatPlanı[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Şub]]),1),INDEX(EğitimVeSeyahatPlanı[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Şub]],TrainingAndTravelActual[#Headers],0))","v":{"v":-400,"d":"-₺400.00"}},{"$f":"INDEX(EğitimVeSeyahatPlanı[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Mar]]),1),INDEX(EğitimVeSeyahatPlanı[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Mar]],EğitimVeSeyahatPlanı[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Mar]]),1),INDEX(EğitimVeSeyahatPlanı[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Mar]],TrainingAndTravelActual[#Headers],0))","v":{"v":600,"d":"₺600.00"}},{"$f":"INDEX(EğitimVeSeyahatPlanı[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Nis]]),1),INDEX(EğitimVeSeyahatPlanı[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Nis]],EğitimVeSeyahatPlanı[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Nis]]),1),INDEX(EğitimVeSeyahatPlanı[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Nis]],TrainingAndTravelActual[#Headers],0))","v":{"v":400,"d":"₺400.00"}},{"$f":"INDEX(EğitimVeSeyahatPlanı[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[May]]),1),INDEX(EğitimVeSeyahatPlanı[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[May]],EğitimVeSeyahatPlanı[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[May]]),1),INDEX(EğitimVeSeyahatPlanı[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[May]],TrainingAndTravelActual[#Headers],0))","v":{"v":800,"d":"₺800.00"}},{"$f":"INDEX(EğitimVeSeyahatPlanı[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Haz]]),1),INDEX(EğitimVeSeyahatPlanı[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Haz]],EğitimVeSeyahatPlanı[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Haz]]),1),INDEX(EğitimVeSeyahatPlanı[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Haz]],TrainingAndTravelActual[#Headers],0))","v":{"v":-800,"d":"-₺800.00"}},{"$f":"INDEX(EğitimVeSeyahatPlanı[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Tem]]),1),INDEX(EğitimVeSeyahatPlanı[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Tem]],EğitimVeSeyahatPlanı[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Tem]]),1),INDEX(EğitimVeSeyahatPlanı[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Tem]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"₺2,000.00"}},{"$f":"INDEX(EğitimVeSeyahatPlanı[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Ağu]]),1),INDEX(EğitimVeSeyahatPlanı[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Ağu]],EğitimVeSeyahatPlanı[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Ağu]]),1),INDEX(EğitimVeSeyahatPlanı[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Ağu]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"₺2,000.00"}},{"$f":"INDEX(EğitimVeSeyahatPlanı[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Eyl]]),1),INDEX(EğitimVeSeyahatPlanı[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Eyl]],EğitimVeSeyahatPlanı[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Eyl]]),1),INDEX(EğitimVeSeyahatPlanı[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Eyl]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"₺2,000.00"}},{"$f":"INDEX(EğitimVeSeyahatPlanı[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Eki]]),1),INDEX(EğitimVeSeyahatPlanı[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Eki]],EğitimVeSeyahatPlanı[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Eki]]),1),INDEX(EğitimVeSeyahatPlanı[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Eki]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"₺2,000.00"}},{"$f":"INDEX(EğitimVeSeyahatPlanı[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Kas]]),1),INDEX(EğitimVeSeyahatPlanı[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Kas]],EğitimVeSeyahatPlanı[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Kas]]),1),INDEX(EğitimVeSeyahatPlanı[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Kas]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"₺2,000.00"}},{"$f":"INDEX(EğitimVeSeyahatPlanı[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Ara]]),1),INDEX(EğitimVeSeyahatPlanı[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Ara]],EğitimVeSeyahatPlanı[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Ara]]),1),INDEX(EğitimVeSeyahatPlanı[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Ara]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"₺2,000.00"}},{"$f":"SUM(TrainingAndTravelVariances[[#This Row],[Oca]:[Ara]])","v":{"v":13000,"d":"₺13,000.00"}}]
[null,"Eğitimle ilgili seyahat maliyetleri",{"$f":"INDEX(EğitimVeSeyahatPlanı[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Oca]]),1),INDEX(EğitimVeSeyahatPlanı[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Oca]],EğitimVeSeyahatPlanı[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Oca]]),1),INDEX(EğitimVeSeyahatPlanı[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Oca]],TrainingAndTravelActual[#Headers],0))","v":{"v":800,"d":"₺800.00"}},{"$f":"INDEX(EğitimVeSeyahatPlanı[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Şub]]),1),INDEX(EğitimVeSeyahatPlanı[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Şub]],EğitimVeSeyahatPlanı[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Şub]]),1),INDEX(EğitimVeSeyahatPlanı[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Şub]],TrainingAndTravelActual[#Headers],0))","v":{"v":-200,"d":"-₺200.00"}},{"$f":"INDEX(EğitimVeSeyahatPlanı[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Mar]]),1),INDEX(EğitimVeSeyahatPlanı[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Mar]],EğitimVeSeyahatPlanı[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Mar]]),1),INDEX(EğitimVeSeyahatPlanı[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Mar]],TrainingAndTravelActual[#Headers],0))","v":{"v":600,"d":"₺600.00"}},{"$f":"INDEX(EğitimVeSeyahatPlanı[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Nis]]),1),INDEX(EğitimVeSeyahatPlanı[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Nis]],EğitimVeSeyahatPlanı[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Nis]]),1),INDEX(EğitimVeSeyahatPlanı[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Nis]],TrainingAndTravelActual[#Headers],0))","v":{"v":800,"d":"₺800.00"}},{"$f":"INDEX(EğitimVeSeyahatPlanı[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[May]]),1),INDEX(EğitimVeSeyahatPlanı[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[May]],EğitimVeSeyahatPlanı[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[May]]),1),INDEX(EğitimVeSeyahatPlanı[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[May]],TrainingAndTravelActual[#Headers],0))","v":{"v":1200,"d":"₺1,200.00"}},{"$f":"INDEX(EğitimVeSeyahatPlanı[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Haz]]),1),INDEX(EğitimVeSeyahatPlanı[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Haz]],EğitimVeSeyahatPlanı[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Haz]]),1),INDEX(EğitimVeSeyahatPlanı[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Haz]],TrainingAndTravelActual[#Headers],0))","v":{"v":-1500,"d":"-₺1,500.00"}},{"$f":"INDEX(EğitimVeSeyahatPlanı[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Tem]]),1),INDEX(EğitimVeSeyahatPlanı[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Tem]],EğitimVeSeyahatPlanı[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Tem]]),1),INDEX(EğitimVeSeyahatPlanı[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Tem]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"₺2,000.00"}},{"$f":"INDEX(EğitimVeSeyahatPlanı[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Ağu]]),1),INDEX(EğitimVeSeyahatPlanı[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Ağu]],EğitimVeSeyahatPlanı[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Ağu]]),1),INDEX(EğitimVeSeyahatPlanı[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Ağu]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"₺2,000.00"}},{"$f":"INDEX(EğitimVeSeyahatPlanı[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Eyl]]),1),INDEX(EğitimVeSeyahatPlanı[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Eyl]],EğitimVeSeyahatPlanı[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Eyl]]),1),INDEX(EğitimVeSeyahatPlanı[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Eyl]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"₺2,000.00"}},{"$f":"INDEX(EğitimVeSeyahatPlanı[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Eki]]),1),INDEX(EğitimVeSeyahatPlanı[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Eki]],EğitimVeSeyahatPlanı[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Eki]]),1),INDEX(EğitimVeSeyahatPlanı[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Eki]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"₺2,000.00"}},{"$f":"INDEX(EğitimVeSeyahatPlanı[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Kas]]),1),INDEX(EğitimVeSeyahatPlanı[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Kas]],EğitimVeSeyahatPlanı[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Kas]]),1),INDEX(EğitimVeSeyahatPlanı[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Kas]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"₺2,000.00"}},{"$f":"INDEX(EğitimVeSeyahatPlanı[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Ara]]),1),INDEX(EğitimVeSeyahatPlanı[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Ara]],EğitimVeSeyahatPlanı[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Ara]]),1),INDEX(EğitimVeSeyahatPlanı[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Ara]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"₺2,000.00"}},{"$f":"SUM(TrainingAndTravelVariances[[#This Row],[Oca]:[Ara]])","v":{"v":13700,"d":"₺13,700.00"}}]
[null,"Ara toplam",{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[Oca])","v":{"v":1200,"d":"₺1,200.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[Şub])","v":{"v":-600,"d":"-₺600.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[Mar])","v":{"v":1200,"d":"₺1,200.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[Nis])","v":{"v":1200,"d":"₺1,200.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[May])","v":{"v":2000,"d":"₺2,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[Haz])","v":{"v":-2300,"d":"-₺2,300.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[Tem])","v":{"v":4000,"d":"₺4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[Ağu])","v":{"v":4000,"d":"₺4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[Eyl])","v":{"v":4000,"d":"₺4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[Eki])","v":{"v":4000,"d":"₺4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[Kas])","v":{"v":4000,"d":"₺4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[Ara])","v":{"v":4000,"d":"₺4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[YIL])","v":{"v":26700,"d":"₺26,700.00"}}]
[]
[null,"TOPLAMLAR","Oca","Şub","Mar","Nis","May","Haz","Tem","Ağu","Eyl","Eki","Kas","Ara","Yıl"]
[null,"Aylık Fiili Giderler",{"$f":"TrainingAndTravelVariances[[#Totals],[Oca]]+MarketingVariances[[#Totals],[Oca]]+OfficeVariances[[#Totals],[Oca]]+EmployeeVariances[[#Totals],[Oca]]","v":{"v":1738,"d":"₺1,738.00"}},{"$f":"TrainingAndTravelVariances[[#Totals],[Şub]]+MarketingVariances[[#Totals],[Şub]]+OfficeVariances[[#Totals],[Şub]]+EmployeeVariances[[#Totals],[Şub]]","v":{"v":-984,"d":"-₺984.00"}},{"$f":"TrainingAndTravelVariances[[#Totals],[Mar]]+MarketingVariances[[#Totals],[Mar]]+OfficeVariances[[#Totals],[Mar]]+EmployeeVariances[[#Totals],[Mar]]","v":{"v":1255,"d":"₺1,255.00"}},{"$f":"TrainingAndTravelVariances[[#Totals],[Nis]]+MarketingVariances[[#Totals],[Nis]]+OfficeVariances[[#Totals],[Nis]]+EmployeeVariances[[#Totals],[Nis]]","v":{"v":301,"d":"₺301.00"}},{"$f":"TrainingAndTravelVariances[[#Totals],[May]]+MarketingVariances[[#Totals],[May]]+OfficeVariances[[#Totals],[May]]+EmployeeVariances[[#Totals],[May]]","v":{"v":1440,"d":"₺1,440.00"}},{"$f":"TrainingAndTravelVariances[[#Totals],[Haz]]+MarketingVariances[[#Totals],[Haz]]+OfficeVariances[[#Totals],[Haz]]+EmployeeVariances[[#Totals],[Haz]]","v":{"v":-3744,"d":"-₺3,744.00"}},{"$f":"TrainingAndTravelVariances[[#Totals],[Tem]]+MarketingVariances[[#Totals],[Tem]]+OfficeVariances[[#Totals],[Tem]]+EmployeeVariances[[#Totals],[Tem]]","v":{"v":134695,"d":"₺134,695.00"}},{"$f":"TrainingAndTravelVariances[[#Totals],[Ağu]]+MarketingVariances[[#Totals],[Ağu]]+OfficeVariances[[#Totals],[Ağu]]+EmployeeVariances[[#Totals],[Ağu]]","v":{"v":138918,"d":"₺138,918.00"}},{"$f":"TrainingAndTravelVariances[[#Totals],[Eyl]]+MarketingVariances[[#Totals],[Eyl]]+OfficeVariances[[#Totals],[Eyl]]+EmployeeVariances[[#Totals],[Eyl]]","v":{"v":135918,"d":"₺135,918.00"}},{"$f":"TrainingAndTravelVariances[[#Totals],[Eki]]+MarketingVariances[[#Totals],[Eki]]+OfficeVariances[[#Totals],[Eki]]+EmployeeVariances[[#Totals],[Eki]]","v":{"v":140918,"d":"₺140,918.00"}},{"$f":"TrainingAndTravelVariances[[#Totals],[Kas]]+MarketingVariances[[#Totals],[Kas]]+OfficeVariances[[#Totals],[Kas]]+EmployeeVariances[[#Totals],[Kas]]","v":{"v":136218,"d":"₺136,218.00"}},{"$f":"TrainingAndTravelVariances[[#Totals],[Ara]]+MarketingVariances[[#Totals],[Ara]]+OfficeVariances[[#Totals],[Ara]]+EmployeeVariances[[#Totals],[Ara]]","v":{"v":140018,"d":"₺140,018.00"}},{"$f":"TrainingAndTravelVariances[[#Totals],[YIL]]+MarketingVariances[[#Totals],[YIL]]+OfficeVariances[[#Totals],[YIL]]+EmployeeVariances[[#Totals],[YIL]]","v":{"v":826691,"d":"₺826,691.00"}}]
[null,"TOPLAM Fiili Giderler",{"$f":"SUM($C$36:C36)","v":{"v":1738,"d":"₺1,738.00"}},{"$f":"SUM($C$36:D36)","v":{"v":754,"d":"₺754.00"}},{"$f":"SUM($C$36:E36)","v":{"v":2009,"d":"₺2,009.00"}},{"$f":"SUM($C$36:F36)","v":{"v":2310,"d":"₺2,310.00"}},{"$f":"SUM($C$36:G36)","v":{"v":3750,"d":"₺3,750.00"}},{"$f":"SUM($C$36:H36)","v":{"v":6,"d":"₺6.00"}},{"$f":"SUM($C$36:I36)","v":{"v":134701,"d":"₺134,701.00"}},{"$f":"SUM($C$36:J36)","v":{"v":273619,"d":"₺273,619.00"}},{"$f":"SUM($C$36:K36)","v":{"v":409537,"d":"₺409,537.00"}},{"$f":"SUM($C$36:L36)","v":{"v":550455,"d":"₺550,455.00"}},{"$f":"SUM($C$36:M36)","v":{"v":686673,"d":"₺686,673.00"}},{"$f":"SUM($C$36:N36)","v":{"v":826691,"d":"₺826,691.00"}}]

{"sheet":"GİDER ANALİZİ","index":4,"n_rows":10,"n_cols":16,"rows_kept":10,"merged":[[2,4,2,6],[11,1,11,5]]}
[{"$nulls":6}," ",{"$nulls":8}," "]
[null,{"$f":"'PLANLANAN GİDERLER'!B2:D3","v":"Şirket Adı"}]
[{"$nulls":4},{"$f":"worksheet_title","v":"Ayrıntılı Gider Tahminleri"}]
[]
[null,"Gider Kategorisi","Planlanan Giderler","Fiili Giderler","Gider Varyansları","Varyans Yüzdesi"]
[null,"Çalışan Maliyetleri",{"$f":"ÇalışanPlan[[#Totals],[YIL]]","v":{"v":1355090,"d":"₺1,355,090.00"}},{"$f":"EmployeeActual[[#Totals],[YIL]]","v":{"v":659130,"d":"₺659,130.00"}},{"$f":"C6-D6","v":{"v":695960,"d":"₺695,960.00"}},{"$f":"E6/C6","v":{"v":0.5135895032802249,"d":"51%"}}]
[null,{"$f":"'PLANLANAN GİDERLER'!B10","v":"Ofis Maliyetleri"},{"$f":"OfficePlan[[#Totals],[YIL]]","v":{"v":138740,"d":"₺138,740.00"}},{"$f":"OfficeActual[[#Totals],[YIL]]","v":{"v":69350,"d":"₺69,350.00"}},{"$f":"C7-D7","v":{"v":69390,"d":"₺69,390.00"}},{"$f":"E7/C7","v":{"v":0.5001441545336601,"d":"50%"}}]
[null,{"$f":"'PLANLANAN GİDERLER'!B21","v":"Pazarlama Maliyetleri"},{"$f":"MarketingPlan[[#Totals],[YIL]]","v":{"v":67800,"d":"₺67,800.00"}},{"$f":"MarketingActual[[#Totals],[YIL]]","v":{"v":33159,"d":"₺33,159.00"}},{"$f":"C8-D8","v":{"v":34641,"d":"₺34,641.00"}},{"$f":"E8/C8","v":{"v":0.510929203539823,"d":"51%"}}]
[null,{"$f":"'PLANLANAN GİDERLER'!B30","v":"Eğitim/Seyahat"},{"$f":"EğitimVeSeyahatPlanı[[#Totals],[YIL]]","v":{"v":48000,"d":"₺48,000.00"}},{"$f":"TrainingAndTravelActual[[#Totals],[YIL]]","v":{"v":21300,"d":"₺21,300.00"}},{"$f":"C9-D9","v":{"v":26700,"d":"₺26,700.00"}},{"$f":"E9/C9","v":{"v":0.55625,"d":"56%"}}]
[null,{"$f":"'PLANLANAN GİDERLER'!B35","v":"TOPLAMLAR"},{"$f":"'PLANLANAN GİDERLER'!O36","v":{"v":1609630,"d":"₺1,609,630.00"}},{"$f":"'FİİLİ GİDERLER'!O36","v":{"v":782939,"d":"₺782,939.00"}},{"$f":"C10-D10","v":{"v":826691,"d":"₺826,691.00"}},{"$f":"E10/C10","v":{"v":0.5135907009685455,"d":"51%"}}]