{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["18 Dönemlik Bütçe"],"not_rendered":{"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"18 Dönemlik Bütçe","index":0,"n_rows":26,"n_cols":22,"rows_kept":26,"merged":[[0,1,1,4],[1,8,1,9],[12,1,12,20],[26,1,26,21]]}
[null,"şirket bütçesi"]
[{"$nulls":6},"BAŞLANGIÇ TARİHİ","2011-01-01","DÖNEM SÜRESi (GÜN)",null,14,"BİTİŞ TARİHİ",{"$f":"TEXT(T5,\"gg.aa.yyyy\")","v":"26.08.2012"}]
[]
[]
[null,null,{"$f":"UPPER(TEXT(H2,\"gg-aaa\"))","v":"01-OCA"},{"$f":"UPPER(TEXT(C5+GünAralığı,\"gg-aaa\"))","v":"15-OCA"},"29-OCA","12-ŞUB","26-ŞUB","11-MAR","25-MAR","08-NİS","22-NİS","06-MAY","20-MAY","03-HAZ","17-HAZ","01-TEM","15-TEM","29-TEM","12-AĞU","26-AĞU","TOPLAM","EĞİLİM"]
[null,"NET GELİR",{"$f":"GelirTablosu[[#Totals],[Hafta 1]]-HarcamalarTablosu[[#Totals],[Hafta 1]]","v":{"v":1750,"d":"1,750.00 TL"}},{"$f":"GelirTablosu[[#Totals],[Hafta 2]]-HarcamalarTablosu[[#Totals],[Hafta 2]]","v":{"v":2236,"d":"2,236.00 TL"}},{"$f":"GelirTablosu[[#Totals],[Hafta 3]]-HarcamalarTablosu[[#Totals],[Hafta 3]]","v":{"v":1442,"d":"1,442.00 TL"}},{"$f":"GelirTablosu[[#Totals],[Hafta 4]]-HarcamalarTablosu[[#Totals],[Hafta 4]]","v":{"v":2253,"d":"2,253.00 TL"}},{"$f":"GelirTablosu[[#Totals],[Hafta 5]]-HarcamalarTablosu[[#Totals],[Hafta 5]]","v":{"v":1533,"d":"1,533.00 TL"}},{"$f":"GelirTablosu[[#Totals],[Hafta 6]]-HarcamalarTablosu[[#Totals],[Hafta 6]]","v":{"v":1086,"d":"1,086.00 TL"}},{"$f":"GelirTablosu[[#Totals],[Hafta 7]]-HarcamalarTablosu[[#Totals],[Hafta 7]]","v":{"v":1594,"d":"1,594.00 TL"}},{"$f":"GelirTablosu[[#Totals],[Hafta 8]]-HarcamalarTablosu[[#Totals],[Hafta 8]]","v":0},{"$f":"GelirTablosu[[#Totals],[Hafta 9]]-HarcamalarTablosu[[#Totals],[Hafta 9]]","v":0},{"$f":"GelirTablosu[[#Totals],[Hafta 10]]-HarcamalarTablosu[[#Totals],[Hafta 10]]","v":0},{"$f":"GelirTablosu[[#Totals],[Hafta 11]]-HarcamalarTablosu[[#Totals],[Hafta 11]]","v":0},{"$f":"GelirTablosu[[#Totals],[Hafta 12]]-HarcamalarTablosu[[#Totals],[Hafta 12]]","v":0},{"$f":"GelirTablosu[[#Totals],[Hafta 13]]-HarcamalarTablosu[[#Totals],[Hafta 13]]","v":0},{"$f":"GelirTablosu[[#Totals],[Hafta 14]]-HarcamalarTablosu[[#Totals],[Hafta 14]]","v":0},{"$f":"GelirTablosu[[#Totals],[Hafta 15]]-HarcamalarTablosu[[#Totals],[Hafta 15]]","v":0},{"$f":"GelirTablosu[[#Totals],[Hafta 16]]-HarcamalarTablosu[[#Totals],[Hafta 16]]","v":0},{"$f":"GelirTablosu[[#Totals],[Hafta 17]]-HarcamalarTablosu[[#Totals],[Hafta 17]]","v":0},{"$f":"GelirTablosu[[#Totals],[Hafta 18]]-HarcamalarTablosu[[#Totals],[Hafta 18]]","v":0},{"$f":"GelirTablosu[[#Totals],[Toplam]]-HarcamalarTablosu[[#Totals],[Toplam]]","v":{"v":11894,"d":"11,894.00 TL"}}]
[]
["gelir"]
[null,"GELİR KALEMİ 1",{"v":3000,"d":"3,000.00 TL"},{"v":3500,"d":"3,500.00 TL"},{"v":2978,"d":"2,978.00 TL"},{"v":3384,"d":"3,384.00 TL"},{"v":2858,"d":"2,858.00 TL"},{"v":2809,"d":"2,809.00 TL"},{"v":3220,"d":"3,220.00 TL"},{"$nulls":11},{"$f":"SUM(GelirTablosu[[#This Row],[Hafta 1]:[Hafta 18]])","v":{"v":21749,"d":"21,749.00 TL"}}]
[null,"GELİR KALEMİ 2",{"v":1150,"d":"1150.00"},{"v":1200,"d":"1200.00"},{"v":1144,"d":"1144.00"},{"v":1400,"d":"1400.00"},{"v":1358,"d":"1358.00"},{"v":1154,"d":"1154.00"},{"v":1245,"d":"1245.00"},{"$nulls":11},{"$f":"SUM(GelirTablosu[[#This Row],[Hafta 1]:[Hafta 18]])","v":{"v":8651,"d":"8651.00"}}]
[null,"GELİR KALEMİ 3",{"v":300,"d":"300.00"},{"v":350,"d":"350.00"},{"v":392,"d":"392.00"},{"v":326,"d":"326.00"},{"v":381,"d":"381.00"},{"v":364,"d":"364.00"},{"v":315,"d":"315.00"},{"$nulls":11},{"$f":"SUM(GelirTablosu[[#This Row],[Hafta 1]:[Hafta 18]])","v":{"v":2428,"d":"2428.00"}}]
[null,"TOPLAM GELİR",{"$f":"SUBTOTAL(109,GelirTablosu[Hafta 1])","v":{"v":4450,"d":"4,450.00 TL"}},{"$f":"SUBTOTAL(109,GelirTablosu[Hafta 2])","v":{"v":5050,"d":"5,050.00 TL"}},{"$f":"SUBTOTAL(109,GelirTablosu[Hafta 3])","v":{"v":4514,"d":"4,514.00 TL"}},{"$f":"SUBTOTAL(109,GelirTablosu[Hafta 4])","v":{"v":5110,"d":"5,110.00 TL"}},{"$f":"SUBTOTAL(109,GelirTablosu[Hafta 5])","v":{"v":4597,"d":"4,597.00 TL"}},{"$f":"SUBTOTAL(109,GelirTablosu[Hafta 6])","v":{"v":4327,"d":"4,327.00 TL"}},{"$f":"SUBTOTAL(109,GelirTablosu[Hafta 7])","v":{"v":4780,"d":"4,780.00 TL"}},{"$f":"SUBTOTAL(109,GelirTablosu[Hafta 8])","v":0},{"$f":"SUBTOTAL(109,GelirTablosu[Hafta 9])","v":0},{"$f":"SUBTOTAL(109,GelirTablosu[Hafta 10])","v":0},{"$f":"SUBTOTAL(109,GelirTablosu[Hafta 11])","v":0},{"$f":"SUBTOTAL(109,GelirTablosu[Hafta 12])","v":0},{"$f":"SUBTOTAL(109,GelirTablosu[Hafta 13])","v":0},{"$f":"SUBTOTAL(109,GelirTablosu[Hafta 14])","v":0},{"$f":"SUBTOTAL(109,GelirTablosu[Hafta 15])","v":0},{"$f":"SUBTOTAL(109,GelirTablosu[Hafta 16])","v":0},{"$f":"SUBTOTAL(109,GelirTablosu[Hafta 17])","v":0},{"$f":"SUBTOTAL(109,GelirTablosu[Hafta 18])","v":0},{"$f":"SUBTOTAL(109,GelirTablosu[Toplam])","v":{"v":32828,"d":"32,828.00 TL"}}]
["gider"]
["harcamalar"]
[null,"ÜCRETLER",{"v":1500,"d":"1,500.00 TL"},{"v":1577,"d":"1,577.00 TL"},{"v":1823,"d":"1,823.00 TL"},{"v":1529,"d":"1,529.00 TL"},{"v":1759,"d":"1,759.00 TL"},{"v":1947,"d":"1,947.00 TL"},{"v":1875,"d":"1,875.00 TL"},{"$nulls":11},{"$f":"SUM(HarcamalarTablosu[[#This Row],[Hafta 1]:[Hafta 18]])","v":{"v":12010,"d":"12,010.00 TL"}}]
[null,"KİRA",{"v":1000,"d":"1000.00"},{"v":1000,"d":"1000.00"},{"v":1000,"d":"1000.00"},{"v":1000,"d":"1000.00"},{"v":1000,"d":"1000.00"},{"v":1000,"d":"1000.00"},{"v":1000,"d":"1000.00"},{"$nulls":11},{"$f":"SUM(HarcamalarTablosu[[#This Row],[Hafta 1]:[Hafta 18]])","v":{"v":7000,"d":"7000.00"}}]
[null,"ELEKTRİK",{"v":40,"d":"40.00"},{"v":43,"d":"43.00"},{"v":40,"d":"40.00"},{"v":42,"d":"42.00"},{"v":45,"d":"45.00"},{"v":40,"d":"40.00"},{"v":42,"d":"42.00"},{"$nulls":11},{"$f":"SUM(HarcamalarTablosu[[#This Row],[Hafta 1]:[Hafta 18]])","v":{"v":292,"d":"292.00"}}]
[null,"TELEFON",{"v":12,"d":"12.00"},{"v":11,"d":"11.00"},{"v":13,"d":"13.00"},{"v":14,"d":"14.00"},{"v":11,"d":"11.00"},{"v":15,"d":"15.00"},{"v":15,"d":"15.00"},{"$nulls":11},{"$f":"SUM(HarcamalarTablosu[[#This Row],[Hafta 1]:[Hafta 18]])","v":{"v":91,"d":"91.00"}}]
[null,"INTERNET",{"v":15,"d":"15.00"},{"v":15,"d":"15.00"},{"v":15,"d":"15.00"},{"v":15,"d":"15.00"},{"v":15,"d":"15.00"},{"v":15,"d":"15.00"},{"v":15,"d":"15.00"},{"$nulls":11},{"$f":"SUM(HarcamalarTablosu[[#This Row],[Hafta 1]:[Hafta 18]])","v":{"v":105,"d":"105.00"}}]
[null,"SU",{"v":11,"d":"11.00"},{"v":10,"d":"10.00"},{"v":13,"d":"13.00"},{"v":10,"d":"10.00"},{"v":13,"d":"13.00"},{"v":10,"d":"10.00"},{"v":12,"d":"12.00"},{"$nulls":11},{"$f":"SUM(HarcamalarTablosu[[#This Row],[Hafta 1]:[Hafta 18]])","v":{"v":79,"d":"79.00"}}]
[null,"YAKIT",{"v":23,"d":"23.00"},{"v":27,"d":"27.00"},{"v":26,"d":"26.00"},{"v":27,"d":"27.00"},{"v":22,"d":"22.00"},{"v":29,"d":"29.00"},{"v":21,"d":"21.00"},{"$nulls":11},{"$f":"SUM(HarcamalarTablosu[[#This Row],[Hafta 1]:[Hafta 18]])","v":{"v":175,"d":"175.00"}}]
[null,"ATIK TOPLAMA",{"v":4,"d":"4.00"},{"v":4,"d":"4.00"},{"v":4,"d":"4.00"},{"v":4,"d":"4.00"},{"v":4,"d":"4.00"},{"v":4,"d":"4.00"},{"v":4,"d":"4.00"},{"$nulls":11},{"$f":"SUM(HarcamalarTablosu[[#This Row],[Hafta 1]:[Hafta 18]])","v":{"v":28,"d":"28.00"}}]
[null,"KABLO TV",{"v":10,"d":"10.00"},{"v":10,"d":"10.00"},{"v":10,"d":"10.00"},{"v":10,"d":"10.00"},{"v":10,"d":"10.00"},{"v":10,"d":"10.00"},{"v":10,"d":"10.00"},{"$nulls":11},{"$f":"SUM(HarcamalarTablosu[[#This Row],[Hafta 1]:[Hafta 18]])","v":{"v":70,"d":"70.00"}}]
[null,"BÜRO MALZEMELERİ",{"v":25,"d":"25.00"},{"v":57,"d":"57.00"},{"v":68,"d":"68.00"},{"v":146,"d":"146.00"},{"v":125,"d":"125.00"},{"v":111,"d":"111.00"},{"v":132,"d":"132.00"},{"$nulls":11},{"$f":"SUM(HarcamalarTablosu[[#This Row],[Hafta 1]:[Hafta 18]])","v":{"v":664,"d":"664.00"}}]
[null,"SİGORTA",{"v":60,"d":"60.00"},{"v":60,"d":"60.00"},{"v":60,"d":"60.00"},{"v":60,"d":"60.00"},{"v":60,"d":"60.00"},{"v":60,"d":"60.00"},{"v":60,"d":"60.00"},{"$nulls":11},{"$f":"SUM(HarcamalarTablosu[[#This Row],[Hafta 1]:[Hafta 18]])","v":{"v":420,"d":"420.00"}}]
[null,"TOPLAM GİDERLER",{"$f":"SUBTOTAL(109,HarcamalarTablosu[Hafta 1])","v":{"v":2700,"d":"2,700.00 TL"}},{"$f":"SUBTOTAL(109,HarcamalarTablosu[Hafta 2])","v":{"v":2814,"d":"2,814.00 TL"}},{"$f":"SUBTOTAL(109,HarcamalarTablosu[Hafta 3])","v":{"v":3072,"d":"3,072.00 TL"}},{"$f":"SUBTOTAL(109,HarcamalarTablosu[Hafta 4])","v":{"v":2857,"d":"2,857.00 TL"}},{"$f":"SUBTOTAL(109,HarcamalarTablosu[Hafta 5])","v":{"v":3064,"d":"3,064.00 TL"}},{"$f":"SUBTOTAL(109,HarcamalarTablosu[Hafta 6])","v":{"v":3241,"d":"3,241.00 TL"}},{"$f":"SUBTOTAL(109,HarcamalarTablosu[Hafta 7])","v":{"v":3186,"d":"3,186.00 TL"}},{"$f":"SUBTOTAL(109,HarcamalarTablosu[Hafta 8])","v":0},{"$f":"SUBTOTAL(109,HarcamalarTablosu[Hafta 9])","v":0},{"$f":"SUBTOTAL(109,HarcamalarTablosu[Hafta 10])","v":0},{"$f":"SUBTOTAL(109,HarcamalarTablosu[Hafta 11])","v":0},{"$f":"SUBTOTAL(109,HarcamalarTablosu[Hafta 12])","v":0},{"$f":"SUBTOTAL(109,HarcamalarTablosu[Hafta 13])","v":0},{"$f":"SUBTOTAL(109,HarcamalarTablosu[Hafta 14])","v":0},{"$f":"SUBTOTAL(109,HarcamalarTablosu[Hafta 15])","v":0},{"$f":"SUBTOTAL(109,HarcamalarTablosu[Hafta 16])","v":0},{"$f":"SUBTOTAL(109,HarcamalarTablosu[Hafta 17])","v":0},{"$f":"SUBTOTAL(109,HarcamalarTablosu[Hafta 18])","v":0},{"$f":"SUBTOTAL(109,HarcamalarTablosu[Toplam])","v":{"v":20934,"d":"20,934.00 TL"}}]