{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["hisse","Depo","Ürün Adları Dahil FIFO"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"hisse","index":0,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["İşlem","TARİH","ADET","FİYAT","TUTAR","Birim Maliyet","Toplam Maliyet","Birim Kar/Zarar","Toplam Kar/Zarar"]
["A","2020-03-06",81448,4.7457000000000003,{"$f":"+C2*D2","v":386527.77360000001}]
["S","2020-03-17",20385,4.7525000000000004,{"$f":"+C3*D3","v":96879.712500000009},{"$f":"birim_maliyet($A$2:A2,$D$2:D2,$C$2:C2,C3)","v":4.7457000000000003},{"$f":"+F3*C3","v":96741.094500000007},{"$f":"(D3-F3)","v":6.8000000000001393E-3},{"$f":"+H3*C3","v":138.61800000000284}]
["A","2020-03-31",710760,4.7614000000000001,{"$f":"+C4*D4","v":3384212.6639999999}]
["S","2020-04-02",61448,4.7626999999999997,{"$f":"+C5*D5","v":292658.38959999999},{"$f":"birim_maliyet($A$2:A4,$D$2:D4,$C$2:C4,C5)","v":4.7457983677255573},{"$f":"+F5*C5","v":291619.81810000003},{"$f":"(D5-F5)","v":1.6901632274442413E-2},{"$f":"+H5*C5","v":1038.5714999999375}]
["S","2020-04-02",214323,4.7626999999999997,{"$f":"+C6*D6","v":1020756.1520999999},{"$f":"birim_maliyet($A$2:A5,$D$2:D5,$C$2:C5,C6)","v":4.7614000000000001},{"$f":"+F6*C6","v":1020477.5322},{"$f":"(D6-F6)","v":1.2999999999996348E-3},{"$f":"+H6*C6","v":278.6198999999217}]
["S","2020-04-03",335385,4.7633999999999999,{"$f":"+C7*D7","v":1597572.909},{"$f":"birim_maliyet($A$2:A6,$D$2:D6,$C$2:C6,C7)","v":4.7614000000000001},{"$f":"+F7*C7","v":1596902.139},{"$f":"(D7-F7)","v":1.9999999999997797E-3},{"$f":"+H7*C7","v":670.76999999992609}]
["A","2020-04-07",19385,4.7662000000000004,{"$f":"+C8*D8","v":92392.787000000011}]
["S","2020-04-15",15385,4.7717000000000001,{"$f":"+C9*D9","v":73412.604500000001},{"$f":"birim_maliyet($A$2:A8,$D$2:D8,$C$2:C8,C9)","v":4.7614000000000001},{"$f":"+F9*C9","v":73254.138999999996},{"$f":"(D9-F9)","v":1.0299999999999976E-2},{"$f":"+H9*C9","v":158.46549999999962}]
["A","2020-04-30",584035,4.7819000000000003,{"$f":"+C10*D10","v":2792796.9665000001}]
["S","2020-05-01",146823,4.7826000000000004,{"$f":"+C11*D11","v":702195.67980000004},{"$f":"birim_maliyet($A$2:A10,$D$2:D10,$C$2:C10,C11)","v":4.7614503790278091},{"$f":"+F11*C11","v":699090.429},{"$f":"(D11-F11)","v":2.1149620972191308E-2},{"$f":"+H11*C11","v":3105.2508000000444}]
["S","2020-05-01",19385,4.7826000000000004,{"$f":"+C12*D12","v":92710.701000000001},{"$f":"birim_maliyet($A$2:A11,$D$2:D11,$C$2:C11,C12)","v":4.7674480629352596},{"$f":"+F12*C12","v":92416.9807},{"$f":"(D12-F12)","v":1.5151937064740828E-2},{"$f":"+H12*C12","v":293.72030000000098}]
["S","2020-05-01",165948,4.7826000000000004,{"$f":"+C13*D13","v":793662.90480000002},{"$f":"birim_maliyet($A$2:A12,$D$2:D12,$C$2:C12,C13)","v":4.7819000000000003},{"$f":"+F13*C13","v":793546.74120000005},{"$f":"(D13-F13)","v":7.0000000000014495E-4},{"$f":"+H13*C13","v":116.16360000002405}]
["S","2020-05-02",154385,4.7834000000000003,{"$f":"+C14*D14","v":738485.20900000003},{"$f":"birim_maliyet($A$2:A13,$D$2:D13,$C$2:C13,C14)","v":4.7819000000000003},{"$f":"+F14*C14","v":738253.63150000002},{"$f":"(D14-F14)","v":1.5000000000000568E-3},{"$f":"+H14*C14","v":231.57750000000877}]
["A","2020-05-27",694540,4.8015999999999996,{"$f":"+C15*D15","v":3334903.264}]
["S","2020-05-29",264473,4.8029999999999999,{"$f":"+C16*D16","v":1270263.8189999999},{"$f":"birim_maliyet($A$2:A15,$D$2:D15,$C$2:C15,C16)","v":4.7820722156893147},{"$f":"+F16*C16","v":1264728.9851000002},{"$f":"(D16-F16)","v":2.0927784310685205E-2},{"$f":"+H16*C16","v":5534.8338999998477}]
["S","2020-05-29",52924,4.8029999999999999,{"$f":"+C17*D17","v":254193.97200000001},{"$f":"birim_maliyet($A$2:A16,$D$2:D16,$C$2:C16,C17)","v":4.8015999999999996},{"$f":"+F17*C17","v":254119.87839999999},{"$f":"(D17-F17)","v":1.4000000000002899E-3},{"$f":"+H17*C17","v":74.093600000015343}]
["S","2020-05-30",178555,4.8037999999999998,{"$f":"+C18*D18","v":857742.50899999996},{"$f":"birim_maliyet($A$2:A17,$D$2:D17,$C$2:C17,C18)","v":4.8015999999999996},{"$f":"+F18*C18","v":857349.68799999997},{"$f":"(D18-F18)","v":2.2000000000002018E-3},{"$f":"+H18*C18","v":392.82100000003601}]

{"sheet":"Depo","index":1,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Hareket","Adet","Birim Maliyet","Toplam Tutar",null,"Birim Maliyet","Toplam Maliyet"]
["A",60,3,{"$f":"IF(A2=\"A\",-B2*C2,B2*C2)","v":-180}]
["S",43,{"$f":"birim_maliyet($A$2:A2,$C$2:C2,$B$2:B2,B3)","v":3},{"$f":"IF(A3=\"A\",-B3*C3,B3*C3)","v":129},null,{"$f":"birim_maliyet($A$2:A2,$C$2:C2,$B$2:B2,B3)","v":3},{"$f":"+B3*F3","v":129}]
["A",20,3.05,{"$f":"IF(A4=\"A\",-B4*C4,B4*C4)","v":-61}]
["S",13,{"$f":"birim_maliyet($A$2:A4,$C$2:C4,$B$2:B4,B5)","v":3},{"$f":"IF(A5=\"A\",-B5*C5,B5*C5)","v":39},null,{"$f":"birim_maliyet($A$2:A4,$C$2:C4,$B$2:B4,B5)","v":3},{"$f":"+B5*F5","v":39}]
["A",50,3.15,{"$f":"IF(A6=\"A\",-B6*C6,B6*C6)","v":-157.5}]
["S",42,{"$f":"birim_maliyet($A$2:A6,$C$2:C6,$B$2:B6,B7)","v":3.0880952380952378},{"$f":"IF(A7=\"A\",-B7*C7,B7*C7)","v":129.69999999999999},null,{"$f":"birim_maliyet($A$2:A6,$C$2:C6,$B$2:B6,B7)","v":3.0880952380952378},{"$f":"+B7*F7","v":129.69999999999999}]
["A",100,3.25,{"$f":"IF(A8=\"A\",-B8*C8,B8*C8)","v":-325}]
["S",31,{"$f":"birim_maliyet($A$2:A8,$C$2:C8,$B$2:B8,B9)","v":3.15},{"$f":"IF(A9=\"A\",-B9*C9,B9*C9)","v":97.649999999999991},null,{"$f":"birim_maliyet($A$2:A8,$C$2:C8,$B$2:B8,B9)","v":3.15},{"$f":"+B9*F9","v":97.649999999999991}]
["A",200,3.35,{"$f":"IF(A10=\"A\",-B10*C10,B10*C10)","v":-670}]
["S",145,{"$f":"birim_maliyet($A$2:A10,$C$2:C10,$B$2:B10,B11)","v":3.279655172413793},{"$f":"IF(A11=\"A\",-B11*C11,B11*C11)","v":475.55},null,{"$f":"birim_maliyet($A$2:A10,$C$2:C10,$B$2:B10,B11)","v":3.279655172413793},{"$f":"+B11*F11","v":475.55}]
["A",70,3.45,{"$f":"IF(A12=\"A\",-B12*C12,B12*C12)","v":-241.5}]
["S",55,{"$f":"birim_maliyet($A$2:A12,$C$2:C12,$B$2:B12,B13)","v":3.35},{"$f":"IF(A13=\"A\",-B13*C13,B13*C13)","v":184.25},null,{"$f":"birim_maliyet($A$2:A12,$C$2:C12,$B$2:B12,B13)","v":3.35},{"$f":"+B13*F13","v":184.25}]
["A",90,3.55,{"$f":"IF(A14=\"A\",-B14*C14,B14*C14)","v":-319.5}]
["S",59,{"$f":"birim_maliyet($A$2:A14,$C$2:C14,$B$2:B14,B15)","v":3.35},{"$f":"IF(A15=\"A\",-B15*C15,B15*C15)","v":197.65},null,{"$f":"birim_maliyet($A$2:A14,$C$2:C14,$B$2:B14,B15)","v":3.35},{"$f":"+B15*F15","v":197.65}]
["A",110,3.65,{"$f":"IF(A16=\"A\",-B16*C16,B16*C16)","v":-401.5}]
["S",24,{"$f":"birim_maliyet($A$2:A16,$C$2:C16,$B$2:B16,B17)","v":3.35},{"$f":"IF(A17=\"A\",-B17*C17,B17*C17)","v":80.400000000000006},null,{"$f":"birim_maliyet($A$2:A16,$C$2:C16,$B$2:B16,B17)","v":3.35},{"$f":"+B17*F17","v":80.400000000000006}]
["A",130,3.75,{"$f":"IF(A18=\"A\",-B18*C18,B18*C18)","v":-487.5}]
["S",43,{"$f":"birim_maliyet($A$2:A18,$C$2:C18,$B$2:B18,B19)","v":3.4081395348837211},{"$f":"IF(A19=\"A\",-B19*C19,B19*C19)","v":146.55000000000001},null,{"$f":"birim_maliyet($A$2:A18,$C$2:C18,$B$2:B18,B19)","v":3.4081395348837211},{"$f":"+B19*F19","v":146.55000000000001}]
["A",150,3,{"$f":"IF(A20=\"A\",-B20*C20,B20*C20)","v":-450}]
["S",38,{"$f":"birim_maliyet($A$2:A20,$C$2:C20,$B$2:B20,B21)","v":3.4499999999999997},{"$f":"IF(A21=\"A\",-B21*C21,B21*C21)","v":131.1},null,{"$f":"birim_maliyet($A$2:A20,$C$2:C20,$B$2:B20,B21)","v":3.4499999999999997},{"$f":"+B21*F21","v":131.1}]

{"sheet":"Ürün Adları Dahil FIFO","index":2,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Ürün Adı","Hareket","Adet","Birim Maliyet","Toplam Tutar"]
["Patates","A",60,100,{"$f":"IF(B2=\"A\",C2*D2,C2*D2)","v":6000}]
["Patates","A",60,120,{"$f":"IF(B3=\"A\",C3*D3,C3*D3)","v":7200}]
["Soğan","A",100,3,{"$f":"IF(B4=\"A\",C4*D4,C4*D4)","v":300}]
["Patates","S",120,{"$f":"birim_maliyet_urun_grup($B$2:B4,$D$2:D4,$C$2:C4,C5,$A$2:A4,A5)","v":110},{"$f":"IF(B5=\"A\",C5*D5,C5*D5)","v":13200}]
["Soğan","A",100,2,{"$f":"IF(B6=\"A\",C6*D6,C6*D6)","v":200}]
["Soğan","S",200,{"$f":"birim_maliyet_urun_grup($B$2:B6,$D$2:D6,$C$2:C6,C7,$A$2:A6,A7)","v":2.5},{"$f":"IF(B7=\"A\",C7*D7,C7*D7)","v":500}]
["Armut","A",100,50,{"$f":"IF(B8=\"A\",C8*D8,C8*D8)","v":5000}]
["Soğan","A",300,3.2,{"$f":"IF(B9=\"A\",C9*D9,C9*D9)","v":960}]
["Armut","A",10,45,{"$f":"IF(B10=\"A\",C10*D10,C10*D10)","v":450}]
["Armut","S",105,{"$f":"birim_maliyet_urun_grup($B$2:B10,$D$2:D10,$C$2:C10,C11,$A$2:A10,A11)","v":49.761904761904759},{"$f":"IF(B11=\"A\",C11*D11,C11*D11)","v":5225}]
["Soğan","A",70,3.45,{"$f":"IF(B12=\"A\",C12*D12,C12*D12)","v":241.5}]
["Soğan","S",350,{"$f":"birim_maliyet_urun_grup($B$2:B12,$D$2:D12,$C$2:C12,C13,$A$2:A12,A13)","v":3.2357142857142858},{"$f":"IF(B13=\"A\",C13*D13,C13*D13)","v":1132.5}]
["Sarımsak","A",50,1.7,{"$f":"IF(B14=\"A\",C14*D14,C14*D14)","v":85}]
["Sarımsak","S",45,{"$f":"birim_maliyet_urun_grup($B$2:B14,$D$2:D14,$C$2:C14,C15,$A$2:A14,A15)","v":1.7},{"$f":"IF(B15=\"A\",C15*D15,C15*D15)","v":76.5}]
["Sarımsak","A",110,1.75,{"$f":"IF(B16=\"A\",C16*D16,C16*D16)","v":192.5}]
["Sarımsak","S",24,{"$f":"birim_maliyet_urun_grup($B$2:B16,$D$2:D16,$C$2:C16,C17,$A$2:A16,A17)","v":1.7395833333333333},{"$f":"IF(B17=\"A\",C17*D17,C17*D17)","v":41.75}]
["Soğan","A",130,3.75,{"$f":"IF(B18=\"A\",C18*D18,C18*D18)","v":487.5}]
["Armut","S",5,{"$f":"birim_maliyet_urun_grup($B$2:B18,$D$2:D18,$C$2:C18,C19,$A$2:A18,A19)","v":45},{"$f":"IF(B19=\"A\",C19*D19,C19*D19)","v":225}]
["Soğan","A",150,3,{"$f":"IF(B20=\"A\",C20*D20,C20*D20)","v":450}]
["Soğan","S",21,{"$f":"birim_maliyet_urun_grup($B$2:B20,$D$2:D20,$C$2:C20,C21,$A$2:A20,A21)","v":3.4642857142857144},{"$f":"IF(B21=\"A\",C21*D21,C21*D21)","v":72.75}]