{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["-- QNB - Current Account --","-- Trading Investments --"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":7,"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":"-- QNB - Current Account --","index":0,"n_rows":1300,"n_cols":5,"rows_kept":1300,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["الأهلى سوسيتية جنرال - جارى جنية مصرى\nحساب رقم / 62-10023370129"]
["مدين","دائن","رصيد","البيـــــــــــان","التاريخ"]
[{"$f":"3995.02","v":3995.02},null,{"$f":"ROUND(A3-B3,2)","v":3995.02},"رصيد أول المدة","2021-01-01"]
[null,20,{"$f":"ROUND(C3+A4-B4,2)","v":3975.02},null,"2021-01-01"]
[null,26,{"$f":"ROUND(C4+A5-B5,2)","v":3949.02},null,"2021-01-01"]
[null,{"$f":"ROUND((2*15)+(2*6),2)","v":42},3907.02,null,"2021-01-02"]
[null,1400,2507.02,null,"2021-01-02"]
[{"$f":"ROUND(12*404.095,2)","v":4849.1400000000003},null,7356.16,null,"2021-01-03"]
[null,{"$f":"ROUND(1*180,2)","v":180},7176.16,null,"2021-01-03"]
[null,{"$f":"ROUND((1*1544.74)+(1*1544.74*14%),2)","v":1761},5415.16,null,"2021-01-03"]
[null,{"$f":"ROUND((1*222.3)+(1*222.3*0%),2)","v":222.3},5192.8599999999997,null,"2021-01-03"]
[null,{"$f":"ROUND((1*210)+(1*210*14%),2)","v":239.4},4953.46,null,"2021-01-03"]
[null,{"$f":"ROUND(1*2.3,2)","v":2.2999999999999998},4951.16,null,"2021-01-03"]
[null,{"$f":"ROUND((2*97.89)+(2*2.11),2)","v":200},4751.16,null,"2021-01-03"]
[null,20,4731.16,null,"2021-01-04"]
[null,{"$f":"ROUND(6*30,2)","v":180},4551.16,null,"2021-01-04"]
[null,1440,3111.16,null,"2021-01-04"]
[null,{"$f":"ROUND((1*200)+(1*100),2)","v":300},2811.16,null,"2021-01-04"]
[null,{"$f":"ROUND(1*1000,2)","v":1000},1811.16,null,"2021-01-04"]
[null,{"$f":"ROUND(2*80,2)","v":160},1651.16,null,"2021-01-04"]
[null,{"$f":"ROUND((1*1000)-(1*300),2)","v":700},951.16,null,"2021-01-04"]
[null,{"$f":"ROUND((1*300)-(1*100),2)","v":200},751.16,null,"2021-01-04"]
[null,{"$f":"ROUND(1*700,2)","v":700},51.16,null,"2021-01-04"]
[null,10,41.16,null,"2021-01-05"]
[{"$f":"6-((2))","v":4},null,45.16,null,"2021-01-05"]
[null,74.400000000000006,-29.24,null,"2021-01-05"]
[{"$f":"ROUND(8*404.411,2)","v":3235.29},null,3206.05,null,"2021-01-06"]
[null,{"$f":"ROUND(1*800,2)","v":800},2406.0500000000002,null,"2021-01-06"]
[null,{"$f":"ROUND(1*80,2)","v":80},2326.0500000000002,null,"2021-01-06"]
[null,70,2256.0500000000002,null,"2021-01-06"]
[null,{"$f":"ROUND(15*30,2)","v":450},1806.05,null,"2021-01-06"]
[null,300,1506.05,null,"2021-01-06"]
[null,{"$f":"ROUND(4*41,2)","v":164},1342.05,null,"2021-01-06"]
[null,{"$f":"82.45-13.46","v":68.990000000000009},1273.06,null,"2021-01-06"]
[null,235.8,1037.26,null,"2021-01-07"]
[null,{"$f":"ROUND(81.5*2,2)","v":163},874.26,null,"2021-01-07"]
[null,50,824.26,null,"2021-01-07"]
[null,400,424.26,null,"2021-01-07"]
[null,{"$f":"101.04","v":101.04},323.22000000000003,null,"2021-01-09"]
[null,{"$f":"ROUND((2*15)+(2*5),2)","v":40},283.22000000000003,null,"2021-01-09"]
[null,90,193.22,null,"2021-01-12"]
[null,{"$f":"ROUND(2*55,2)","v":110},83.22,null,"2021-01-12"]
[{"$f":"ROUND(56383.83*75%,2)","v":42287.87},null,42371.09,null,"2021-01-12"]
[null,{"$f":"ROUND(29900-(24000),2)","v":5900},36471.089999999997,null,"2021-01-12"]
[null,50,36421.089999999997,null,"2021-01-13"]
[null,{"$f":"ROUND(15*30,2)","v":450},35971.089999999997,null,"2021-01-13"]
[null,41.95,35929.14,null,"2021-01-13"]
[null,{"$f":"ROUND((1*60)+(1*60),2)","v":120},35809.14,null,"2021-01-14"]
[null,{"$f":"ROUND(1599*50%,2)","v":799.5},35009.64,null,"2021-01-14"]
[null,{"$f":"ROUND(856.64*50%,2)","v":428.32},34581.32,null,"2021-01-16"]
[null,{"$f":"ROUND(1*120,2)","v":120},34461.32,null,"2021-01-17"]
[null,1000,33461.32,null,"2021-01-17"]
[null,428.5,33032.82,null,"2021-01-17"]
[null,134.9,32897.919999999998,null,"2021-01-17"]
[null,{"$f":"2700","v":2700},30197.919999999998,null,"2021-01-18"]
[null,20,30177.919999999998,null,"2021-01-19"]
[null,{"$f":"ROUND(10*850,2)","v":8500},21677.919999999998,null,"2021-01-19"]
[null,65,21612.92,null,"2021-01-19"]
[null,{"$f":"ROUND(52*405.892,2)","v":21106.38},506.54,null,"2021-01-20"]
[null,55,451.54,null,"2021-01-20"]
[null,{"$f":"ROUND(6*30,2)","v":180},271.54000000000002,null,"2021-01-20"]
[null,25.95,245.59,null,"2021-01-20"]
[null,30.5,215.09,null,"2021-01-20"]
[{"$f":"ROUND(4*405.997,2)","v":1623.99},null,1839.08,null,"2021-01-21"]
[null,50,1789.08,null,"2021-01-21"]
[null,{"$f":"ROUND(5*30,2)","v":150},1639.08,null,"2021-01-21"]
[null,{"$f":"ROUND(1*65,2)","v":65},1574.08,null,"2021-01-21"]
[null,716.98,857.1,null,"2021-01-21"]
[null,83.4,{"$f":"ROUND(C68+A69-B69,2)","v":773.7},null,"2021-01-22"]
[null,138,635.70000000000005,null,"2021-01-22"]
[null,{"$f":"ROUND(1*3.6,2)","v":3.6},632.1,null,"2021-01-24"]
[null,20,612.1,null,"2021-01-24"]
[null,{"$f":"ROUND(6*30,2)","v":180},432.1,null,"2021-01-24"]
[958000,null,958432.1,null,"2021-01-25"]
[{"$f":"ROUND(1000000-SUM($A$74),2)","v":42000},null,1000432.1,null,"2021-01-25"]
[10000,null,1010432.1,null,"2021-01-25"]
[null,4000,1006432.1,null,"2021-01-25"]
[null,3000,1003432.1,null,"2021-01-25"]
[null,3000,1000432.1,null,"2021-01-25"]
[null,{"$f":"ROUND(1*72.75,2)","v":72.75},1000359.35,null,"2021-01-25"]
[null,{"$f":"ROUND((0.5*64)+(0.5*68),2)","v":66},1000293.35,null,"2021-01-25"]
[null,{"$f":"293+((2))","v":295},999998.35,null,"2021-01-25"]
[null,2,999996.35,null,"2021-01-25"]
[null,{"$f":"ROUND(102*406.523,2)","v":41465.35},958531,null,"2021-01-26"]
[null,{"$f":"ROUND(100+(100*14%),2)","v":114},958417,null,"2021-01-26"]
[{"$f":"ROUND(SUM($B$55),2)","v":2700},null,961117,null,"2021-01-26"]
[null,200,960917,null,"2021-01-26"]
[null,150,960767,null,"2021-01-26"]
[null,200,960567,null,"2021-01-26"]
[null,{"$f":"ROUND(1*380,2)","v":380},960187,null,"2021-01-26"]
[null,270,959917,null,"2021-01-26"]
[null,100,959817,null,"2021-01-26"]
[null,19,959798,null,"2021-01-26"]
[null,148.85,959649.15,null,"2021-01-26"]
[{"$f":"ROUND(4*406.629,2)","v":1626.52},null,961275.67,null,"2021-01-27"]
[50,null,961325.67,null,"2021-01-27"]
[null,{"$f":"ROUND(15*30,2)","v":450},960875.67,null,"2021-01-27"]
[null,304.60000000000002,960571.07,null,"2021-01-27"]
[null,87,960484.07,null,"2021-01-27"]
[null,111,960373.07,null,"2021-01-27"]
[null,13.5,960359.57,null,"2021-01-27"]
[null,10.5,960349.07,null,"2021-01-27"]
[null,518,959831.07,null,"2021-01-28"]
[null,799,959032.07,null,"2021-01-28"]
[null,{"$f":"ROUND((1500*1/5)+(1500*1/5)+(10)+(20)+(20)+(4.22),2)","v":654.22},958377.85,null,"2021-01-27"]
[null,15,958362.85,null,"2021-01-31"]
[{"$f":"CEILING(18970+(18970*15%),10)","v":21820},null,980182.85,null,"2021-01-31"]
[{"$f":"ROUNDUP(22042+(22042*15%),0)","v":25349},null,1005531.85,null,"2021-01-31"]
[null,{"$f":"625.5+(0.5)","v":626},1004905.85,null,"2021-01-31"]
[null,198.15,1004707.7,null,"2021-01-31"]
[null,{"$f":"47.46+((1))","v":48.46},1004659.24,null,"2021-02-01"]
[null,100,1004559.24,null,"2021-02-01"]
[2000,null,1006559.24,null,"2021-02-01"]
[20,null,1006579.24,null,"2021-02-02"]
[{"$f":"ROUND(23*407.26,2)","v":9366.98},null,1015946.22,null,"2021-02-02"]
[null,{"$f":"ROUND(2467*407.26,2)","v":1004710.42},11235.8,null,"2021-02-02"]
[null,{"$f":"20+20","v":40},11195.8,null,"2021-02-02"]
[null,{"$f":"ROUND(1*110,2)","v":110},11085.8,null,"2021-02-02"]
[null,{"$f":"ROUND(1*305,2)","v":305},10780.8,null,"2021-02-02"]
[null,{"$f":"ROUND(1*420,2)","v":420},10360.799999999999,null,"2021-02-02"]
[null,{"$f":"ROUND(1*190,2)","v":190},10170.799999999999,null,"2021-02-02"]
[null,{"$f":"ROUND(1*322,2)","v":322},9848.7999999999993,null,"2021-02-02"]
[null,{"$f":"ROUND(1*2937.4,2)","v":2937.4},6911.4,null,"2021-02-02"]
[null,{"$f":"ROUND(1*240,2)","v":240},6671.4,null,"2021-02-02"]
[null,{"$f":"ROUND(1*2,2)+((1))","v":3},6668.4,null,"2021-02-02"]
[null,{"$f":"ROUND((1*5)+(1*20),2)","v":25},6643.4,null,"2021-02-02"]
[null,{"$f":"ROUND(1*5000,2)","v":5000},1643.4,null,"2021-02-02"]
[null,{"$f":"38","v":38},1605.4,null,"2021-02-02"]
[null,35,1570.4,null,"2021-02-03"]
[{"$f":"ROUND(25*407.471,2)","v":10186.780000000001},null,11757.18,null,"2021-02-04"]
[null,{"$f":"1500-((500))","v":1000},10757.18,null,"2021-02-04"]
[null,{"$f":"2000-((500))","v":1500},9257.18,null,"2021-02-04"]
[null,{"$f":"ROUND(1*1000,2)","v":1000},{"$f":"ROUND(C132+A133-B133,2)","v":8257.18},null,"2021-02-04"]
[null,{"$f":"ROUND((1*200)+(1*50),2)","v":250},8007.18,null,"2021-02-04"]
[null,{"$f":"ROUND(2*80,2)","v":160},7847.18,null,"2021-02-04"]
[null,{"$f":"ROUND(1*700,2)","v":700},7147.18,null,"2021-02-04"]
[null,{"$f":"ROUND((1*100)+(1*50),2)","v":150},6997.18,null,"2021-02-04"]
[null,600,6397.18,null,"2021-02-04"]
[null,{"$f":"ROUND(1*300,2)","v":300},6097.18,null,"2021-02-04"]
[null,{"$f":"ROUND(1*800,2)","v":800},5297.18,null,"2021-02-04"]
[null,{"$f":"ROUND(1*80,2)","v":80},5217.18,null,"2021-02-04"]
[null,{"$f":"15+40+2","v":57},5160.18,null,"2021-02-04"]
[null,{"$f":"ROUND(12*30,2)","v":360},4800.18,null,"2021-02-04"]
[null,10,4790.18,null,"2021-02-04"]
[null,104,4686.18,null,"2021-02-04"]
[null,159.69999999999999,4526.4799999999996,null,"2021-02-04"]
[null,2837.07,1689.41,null,"2021-02-05"]
[null,527.08000000000004,1162.33,null,"2021-02-05"]
[null,26,1136.33,null,"2021-02-05"]
[null,{"$f":"ROUND(4*31,2)","v":124},1012.33,null,"2021-02-05"]
[null,{"$f":"ROUND(1*367,2)+((3))","v":370},642.33000000000004,null,"2021-02-06"]
[null,130,512.33000000000004,null,"2021-02-07"]
[{"$f":"ROUND(1*407.893,2)","v":407.89},null,920.22,null,"2021-02-08"]
[null,{"$f":"99+((1))","v":100},820.22,null,"2021-02-08"]
[null,{"$f":"ROUND(1*500,2)","v":500},320.22000000000003,null,"2021-02-08"]
[{"$f":"ROUND(SUM($B$104),2)","v":799},null,1119.22,null,"2021-02-07"]
[null,311,808.22,null,"2021-02-08"]
[{"$f":"40","v":40},{"$f":"ROUND((1*210)+(1*210*14%),2)+((0.6))","v":240},608.22,null,"2021-02-09"]
[{"$f":"ROUND(53*407.999,2)","v":21623.95},null,22232.17,null,"2021-02-09"]
[null,20,22212.17,null,"2021-02-09"]
[null,{"$f":"ROUND((8*5)+(2*10)-(1*5),2)","v":55},22157.17,null,"2021-02-09"]
[null,{"$f":"ROUND((4*5)+(1*10)-(1*5),2)","v":25},22132.17,null,"2021-02-09"]
[null,{"$f":"ROUND((1*40)+(1*17)+(2*1.5),2)","v":60},22072.17,null,"2021-02-09"]
[null,{"$f":"ROUND(3*33,2)","v":99},21973.17,null,"2021-02-09"]
[null,61,21912.17,null,"2021-02-09"]
[null,{"$f":"66.23","v":66.23},21845.94,null,"2021-02-09"]
[null,{"$f":"ROUND(862400*2.5%,2)","v":21560},285.94,null,"2021-02-10"]
[{"$f":"ROUND((862400*2.5%)-(600000*2.5%),2)","v":6560},null,6845.94,null,"2021-02-10"]
[null,100,6745.94,null,"2021-02-10"]
[null,60,6685.94,null,"2021-02-10"]
[null,{"$f":"ROUND(5*30,2)","v":150},6535.94,null,"2021-02-10"]
[{"$f":"ROUND(19*408.211,2)","v":7756.01},null,14291.95,null,"2021-02-11"]
[null,1450,12841.95,null,"2021-02-11"]
[null,{"$f":"ROUND(10*30,2)","v":300},12541.95,null,"2021-02-11"]
[null,300,12241.95,null,"2021-02-11"]
[null,200.3,12041.65,null,"2021-02-12"]
[null,{"$f":"ROUND((1824.21*2)+(1824.21*2)+((1824.21*2)+(1824.21*2))*28.96%,2)","v":9410},2631.65,null,"2021-02-13"]
[null,{"$f":"ROUND(1*35,2)","v":35},2596.65,null,"2021-02-15"]
[null,{"$f":"51.17","v":51.17},2545.48,null,"2021-02-15"]
[null,{"$f":"ROUND(1*120,2)","v":120},2425.48,null,"2021-02-17"]
[null,600,1825.48,null,"2021-02-17"]
[null,{"$f":"ROUND(12*25,2)","v":300},1525.48,null,"2021-02-17"]
[null,150,1375.48,null,"2021-02-17"]
[null,{"$f":"ROUND(15*30,2)","v":450},925.48,null,"2021-02-17"]
[null,100,825.48,null,"2021-02-17"]
[null,60.65,764.83,null,"2021-02-17"]
[null,{"$f":"(200)+(200)+(200)","v":600},164.83,null,"2021-02-21"]
[null,100,64.83,null,"2021-02-21"]
[null,200,-135.16999999999999,null,"2021-02-21"]
[null,{"$f":"(20)+(10)","v":30},-165.17,null,"2021-02-21"]
[{"$f":"ROUND(SUM($B$190),2)","v":30},null,-135.16999999999999,null,"2021-02-21"]
[{"$f":"ROUND(31*409.378,2)","v":12690.72},null,12555.55,null,"2021-02-22"]
[null,{"$f":"ROUND(10*1180,2)","v":11800},755.55,null,"2021-02-22"]
[null,200,555.54999999999995,null,"2021-02-22"]
[null,{"$f":"ROUND(1*3.6,2)","v":3.6},551.95000000000005,null,"2021-02-22"]
[null,120.5,431.45,null,"2021-02-22"]
[null,89.65,{"$f":"ROUND(C196+A197-B197,2)","v":341.8},null,"2021-02-22"]
[null,89.65,252.15,null,"2021-02-22"]
[{"$f":"ROUND(3*409.485,2)","v":1228.46},null,1480.61,null,"2021-02-23"]
[null,600,880.61,null,"2021-02-23"]
[null,{"$f":"ROUND(2*200,2)","v":400},480.61,null,"2021-02-23"]
[null,{"$f":"ROUND(10*30,2)","v":300},180.61,null,"2021-02-23"]
[null,2,178.61,null,"2021-02-24"]
[{"$f":"CEILING(18970+(18970*15%),10)","v":21820},null,21998.61,null,"2021-02-24"]
[null,200,21798.61,null,"2021-02-24"]
[null,76,21722.61,null,"2021-02-25"]
[null,{"$f":"ROUND(4*31,2)","v":124},21598.61,null,"2021-02-25"]
[null,{"$f":"ROUND(4*41,2)","v":164},21434.61,null,"2021-02-25"]
[null,144,21290.61,null,"2021-02-25"]
[null,143.75,21146.86,null,"2021-02-25"]
[null,93.75,21053.11,null,"2021-02-25"]
[null,425,20628.11,null,"2021-02-25"]
[null,12,20616.11,null,"2021-02-25"]
[null,{"$f":"93.39","v":93.39},20522.72,null,"2021-02-25"]
[null,64.400000000000006,20458.32,null,"2021-02-25"]
[null,7.65,20450.669999999998,null,"2021-02-25"]
[{"$f":"ROUNDUP(22042+(22042*15%),0)","v":25349},null,45799.67,null,"2021-02-28"]
[null,{"$f":"625.5+(0.5)","v":626},45173.67,null,"2021-02-28"]
[{"$f":"ROUND(482*410.025,2)","v":197632.05},null,242805.72,null,"2021-02-25"]
[null,242000,805.72,null,"2021-02-28"]
[null,300,505.72,null,"2021-02-28"]
[null,300,205.72,null,"2021-02-28"]
[null,200,5.72,null,"2021-02-28"]
[null,0.86,4.8600000000000003,null,"2021-02-28"]
[null,0.52,4.34,null,"2021-02-28"]
[null,20,-15.66,null,"2021-03-01"]
[{"$f":"ROUND(5*410.132,2)","v":2050.66},null,2035,null,"2021-03-01"]
[null,58,1977,null,"2021-03-01"]
[null,{"$f":"39.15","v":39.15},1937.85,null,"2021-03-01"]
[null,{"$f":"ROUND(4*30,2)","v":120},1817.85,null,"2021-03-01"]
[{"$f":"ROUND(17*410.239,2)","v":6974.06},null,8791.91,null,"2021-03-02"]
[null,1500,7291.91,null,"2021-03-02"]
[null,3000,4291.91,null,"2021-03-02"]
[null,{"$f":"ROUND(1*1000,2)","v":1000},3291.91,null,"2021-03-02"]
[null,{"$f":"ROUND((1*200)+(1*50),2)+((50))","v":300},2991.91,null,"2021-03-02"]
[null,{"$f":"ROUND(2*80,2)","v":160},2831.91,null,"2021-03-02"]
[null,{"$f":"ROUND(1*700,2)","v":700},2131.91,null,"2021-03-02"]
[null,{"$f":"340-((50))","v":290},1841.91,null,"2021-03-02"]
[null,{"$f":"ROUND(2*410.344,2)","v":820.69},1021.22,null,"2021-03-03"]
[null,35.69,985.53,null,"2021-03-03"]
[null,{"$f":"ROUND(1*800,2)","v":800},185.53,null,"2021-03-03"]
[null,{"$f":"ROUND(1*80,2)","v":80},105.53,null,"2021-03-03"]
[{"$f":"ROUND(SUM($B$187),2)","v":600},null,705.53,null,"2021-03-04"]
[{"$f":"ROUND(2*410.449,2)","v":820.9},null,1526.43,null,"2021-03-04"]
[null,45.52,1480.91,null,"2021-03-04"]
[null,{"$f":"ROUND((6+3)*30,2)","v":270},1210.9100000000001,null,"2021-03-04"]
[null,14.6,1196.31,null,"2021-03-06"]
[null,41.16,1155.1500000000001,null,"2021-03-06"]
[null,96.3,1058.8499999999999,null,"2021-03-06"]
[null,373.08,685.77,null,"2021-03-06"]
[{"$f":"ROUND(3*410.765,2)","v":1232.3},null,1918.07,null,"2021-03-07"]
[null,1173,745.07,null,"2021-03-07"]
[null,300,445.07,null,"2021-03-07"]
[{"$f":"ROUND(SUM($B$197),2)","v":89.65},null,534.72,null,"2021-03-08"]
[{"$f":"ROUND(74*410.87,2)","v":30404.38},null,30939.1,null,"2021-03-08"]
[{"$f":"ROUND(2*410.87,2)","v":821.74},null,31760.84,null,"2021-03-08"]
[null,{"$f":"ROUND(1*29425,2)","v":29425},2335.84,null,"2021-03-08"]
[null,{"$f":"ROUND(2*29425*2%,2)","v":1177},1158.8399999999999,null,"2021-03-08"]
[null,18,1140.8399999999999,null,"2021-03-08"]
[7.25,{"$f":"A260","v":7.25},1140.8399999999999,null,"2021-03-08"]
[null,623,{"$f":"ROUND(C260+A261-B261,2)","v":517.84},null,"2021-03-08"]
[{"$f":"5.4","v":5.4},{"$f":"ROUND(60+(60*14%),2)","v":68.400000000000006},454.84,null,"2021-03-08"]
[null,{"$f":"92.57","v":92.57},362.27,null,"2021-03-10"]
[{"$f":"ROUND(3*411.188,2)","v":1233.56},null,1595.83,null,"2021-03-11"]
[null,239,1356.83,null,"2021-03-11"]
[null,500,856.83,null,"2021-03-11"]
[null,200,656.83,null,"2021-03-11"]
[null,{"$f":"ROUND(10*30,2)","v":300},356.83,null,"2021-03-11"]
[null,308.8,48.03,null,"2021-03-13"]
[65,null,113.03,null,"2021-03-13"]
[null,{"$f":"SUM($A$270)+18.64","v":83.64},29.39,null,"2021-03-13"]
[null,50.48,-21.09,null,"2021-03-13"]
[{"$f":"ROUND(3*411.508,2)","v":1234.52},null,1213.43,null,"2021-03-14"]
[null,50,1163.43,null,"2021-03-14"]
[null,{"$f":"ROUND(5*30,2)","v":150},1013.43,null,"2021-03-14"]
[null,18,995.43,null,"2021-03-14"]
[null,378.68,616.75,null,"2021-03-14"]
[null,324.35000000000002,292.39999999999998,null,"2021-03-14"]
[900,null,1192.4000000000001,null,"2021-03-15"]
[null,{"$f":"ROUND(1*500,2)","v":500},692.4,null,"2021-03-15"]
[null,250,442.4,null,"2021-03-15"]
[null,{"$f":"ROUND((1*100)+(1*50),2)","v":150},292.39999999999998,null,"2021-03-15"]
[null,10,282.39999999999998,null,"2021-03-15"]
[null,{"$f":"ROUND(3*30,2)","v":90},192.4,null,"2021-03-15"]
[{"$f":"ROUND(2*411.721,2)","v":823.44},null,1015.84,null,"2021-03-16"]
[null,69.67,946.17,null,"2021-03-16"]
[{"$f":"SUM($B$263)-(78.56)","v":14.009999999999991},null,960.18,null,"2021-03-16"]
[{"$f":"ROUND(2*411.934,2)","v":823.87},null,1784.05,null,"2021-03-18"]
[null,90,1694.05,null,"2021-03-18"]
[null,{"$f":"ROUND(7*30,2)","v":210},1484.05,null,"2021-03-18"]
[null,120,1364.05,null,"2021-03-18"]
[null,80,1284.05,null,"2021-03-18"]
[null,65.44,1218.6099999999999,null,"2021-03-18"]
[null,234.9,983.71,null,"2021-03-19"]
[null,189.9,793.81,null,"2021-03-19"]
[null,{"$f":"ROUND(20*2,2)","v":40},753.81,null,"2021-03-19"]
[{"$f":"ROUND(2*412.254,2)","v":824.51},null,1578.32,null,"2021-03-21"]
[null,{"$f":"100","v":100},1478.32,null,"2021-03-21"]
[null,{"$f":"ROUND(10*30,2)","v":300},1178.32,null,"2021-03-21"]
[null,{"$f":"SUM($A$279)","v":900},278.32,null,"2021-03-21"]
[60,null,338.32,null,"2021-03-22"]
[null,{"$f":"51.9","v":51.9},286.42,null,"2021-03-22"]
[null,5,281.42,null,"2021-03-22"]
[null,{"$f":"36.84","v":36.840000000000003},244.58,null,"2021-03-22"]
[null,141,103.58,null,"2021-03-22"]
[null,30,73.58,null,"2021-03-22"]
[null,54,19.579999999999998,null,"2021-03-22"]
[null,{"$f":"ROUND(1*500,2)","v":500},-480.42,null,"2021-03-22"]
[null,165,-645.41999999999996,null,"2021-03-23"]
[900,null,254.58,null,"2021-03-23"]
[null,110,144.58000000000001,null,"2021-03-23"]
[null,{"$f":"ROUND(1*125,2)","v":125},19.579999999999998,null,"2021-03-24"]
[{"$f":"ROUND(3*412.573,2)","v":1237.72},null,1257.3,null,"2021-03-24"]
[null,2,1255.3,null,"2021-03-24"]
[{"$f":"ROUND(1*412.679,2)","v":412.68},null,1667.98,null,"2021-03-25"]
[null,10,1657.98,null,"2021-03-25"]
[null,762.46,895.52,null,"2021-03-25"]
[null,35,860.52,null,"2021-03-25"]
[null,{"$f":"ROUND(3*30,2)","v":90},770.52,null,"2021-03-25"]
[null,75,695.52,null,"2021-03-25"]
[null,474.56,220.96,null,"2021-03-25"]
[null,120,100.96,null,"2021-03-26"]
[{"$f":"B323","v":70},{"$f":"ROUND(1*70,2)","v":70},100.96,null,"2021-03-27"]
[null,{"$f":"ROUND((1*350)-(1*200),2)","v":150},-49.04,null,"2021-03-28"]
[null,40,{"$f":"ROUND(C324+A325-B325,2)","v":-89.04},null,"2021-03-29"]
[null,{"$f":"ROUND(2*30,2)","v":60},-149.04,null,"2021-03-29"]
[null,350,-499.04,null,"2021-03-29"]
[{"$f":"CEILING(18970+(18970*15%),10)","v":21820},null,21320.959999999999,null,"2021-03-30"]
[{"$f":"ROUNDUP(22042+(22042*15%),0)+((1))","v":25350},null,46670.96,null,"2021-03-30"]
[null,{"$f":"625.5+(0.5)+((1))-((15))","v":612},46058.96,null,"2021-03-30"]
[null,{"$f":"ROUND(58*413.211,2)","v":23966.240000000002},22092.720000000001,null,"2021-03-30"]
[null,60,22032.720000000001,null,"2021-03-30"]
[null,{"$f":"ROUND(7*30,2)","v":210},21822.720000000001,null,"2021-03-30"]
[null,{"$f":"ROUND(51*413.317,2)","v":21079.17},743.55,null,"2021-03-31"]
[null,{"$f":"ROUND((10*25)+(10*14),2)+((10))","v":400},343.55,null,"2021-03-31"]
[null,48.38,295.17,null,"2021-03-31"]
[null,0.02,295.14999999999998,null,"2021-03-31"]
[null,0.04,295.11,null,"2021-03-31"]
[{"$f":"ROUND(15*413.423,2)","v":6201.35},null,6496.46,null,"2021-04-01"]
[null,20,6476.46,null,"2021-04-01"]
[null,{"$f":"ROUND(1*30,2)","v":30},6446.46,null,"2021-04-01"]
[null,{"$f":"ROUND(1*350,2)","v":350},6096.46,null,"2021-04-01"]
[null,10,6086.46,null,"2021-04-01"]
[null,2062.7800000000002,4023.68,null,"2021-04-01"]
[null,1114.5999999999999,2909.08,null,"2021-04-01"]
[null,760.65,2148.4299999999998,null,"2021-04-01"]
[null,{"$f":"(20)+(30)","v":50},2098.4299999999998,null,"2021-04-01"]
[null,{"$f":"ROUND(34*1,2)","v":34},2064.4299999999998,null,"2021-04-02"]
[null,90.55,1973.88,null,"2021-04-02"]
[null,{"$f":"ROUND(2*100,2)","v":200},1773.88,null,"2021-04-03"]
[null,{"$f":"ROUND((4*10)+(1*10),2)","v":50},1723.88,null,"2021-04-03"]
[{"$f":"ROUND(20*413.74,2)","v":8274.7999999999993},null,9998.68,null,"2021-04-04"]
[null,1500,8498.68,null,"2021-04-04"]
[null,1500,6998.68,null,"2021-04-04"]
[null,{"$f":"ROUND(1*700,2)","v":700},6298.68,null,"2021-04-04"]
[null,{"$f":"ROUND((1*100)+(1*50),2)","v":150},6148.68,null,"2021-04-04"]
[null,{"$f":"ROUND(1*1000,2)","v":1000},5148.68,null,"2021-04-04"]
[null,{"$f":"ROUND(2*80,2)","v":160},4988.68,null,"2021-04-04"]
[null,{"$f":"ROUND(1*800,2)","v":800},4188.68,null,"2021-04-04"]
[null,{"$f":"ROUND(1*80,2)","v":80},4108.68,null,"2021-04-04"]
[null,60,4048.68,null,"2021-04-04"]
[null,{"$f":"ROUND(10*30,2)","v":300},3748.68,null,"2021-04-04"]
[null,{"$f":"50.64","v":50.64},3698.04,null,"2021-04-04"]
[null,1500,2198.04,null,"2021-04-04"]
[null,27,2171.04,null,"2021-04-04"]
[{"$f":"ROUND(54*413.846,2)","v":22347.68},null,24518.720000000001,null,"2021-04-05"]
[null,{"$f":"ROUND(1*21000,2)-B364","v":19500},5018.72,null,"2021-04-05"]
[null,3877.45,1141.27,null,"2021-04-05"]
[null,{"$f":"ROUND((5*25)+(4*65),2)+((15))","v":400},741.27,null,"2021-04-05"]
[null,{"$f":"ROUND((400)-(400*10%),2)","v":360},381.27,null,"2021-04-05"]
[{"$f":"ROUND(28*413.951,2)","v":11590.63},null,11971.9,null,"2021-04-06"]
[null,{"$f":"ROUND(10*950,2)","v":9500},2471.9,null,"2021-04-06"]
[null,{"$f":"ROUND((400)-(400*10%),2)","v":360},2111.9,null,"2021-04-06"]
[null,{"$f":"ROUND((1*799)+(1*799),2)","v":1598},513.9,null,"2021-04-06"]
[50,null,563.9,null,"2021-04-06"]
[null,50,513.9,null,"2021-04-06"]
[null,{"$f":"393.54+((1.46))","v":395},118.9,null,"2021-04-06"]
[{"$f":"ROUND(3*414.058,2)","v":1242.17},null,1361.07,null,"2021-04-07"]
[null,50,1311.07,null,"2021-04-07"]
[null,70,1241.07,null,"2021-04-07"]
[null,{"$f":"ROUND(1*50,2)","v":50},1191.07,null,"2021-04-07"]
[null,{"$f":"ROUND(11*30,2)","v":330},861.07,null,"2021-04-07"]
[null,{"$f":"81.67+((1))","v":82.67},778.4,null,"2021-04-07"]
[{"$f":"ROUND(8*414.164,2)","v":3313.31},null,4091.71,null,"2021-04-08"]
[null,{"$f":"ROUND(60+(60*14%),2)+((0.6))","v":69},4022.71,null,"2021-04-08"]
[null,{"$f":"ROUND((2*25)+(15*45),2)","v":725},3297.71,null,"2021-04-08"]
[null,{"$f":"ROUND((1*55)+(1*20),2)","v":75},3222.71,null,"2021-04-08"]
[null,100,3122.71,null,"2021-04-08"]
[null,{"$f":"ROUND((2*750)-(2*150),2)","v":1200},{"$f":"ROUND(C388+A389-B389,2)","v":1922.71},null,"2021-04-08"]
[null,239,1683.71,null,"2021-04-10"]
[null,{"$f":"ROUND(4*41,2)","v":164},1519.71,null,"2021-04-10"]
[null,36.75,1482.96,null,"2021-04-10"]
[null,50.19,1432.77,null,"2021-04-10"]
[null,{"$f":"SUM(A310)","v":900},532.77,null,"2021-04-11"]
[450,null,982.77,null,"2021-04-11"]
[null,{"$f":"ROUND((1*100)+(1*350),2)","v":450},532.77,null,"2021-04-11"]
[null,{"$f":"SUM($A$395)","v":450},82.77,null,"2021-04-12"]
[null,{"$f":"ROUND((1*25)+(1*25),2)","v":50},32.770000000000003,null,"2021-04-12"]
[{"$f":"ROUND(CEILING(18970+(18970*15%),10)*30%,2)","v":6546},null,6578.77,null,"2021-04-12"]
[{"$f":"ROUNDUP(ROUNDUP(22042+(22042*15%),0)*30%,0)","v":7605},null,14183.77,null,"2021-04-12"]
[300,null,14483.77,null,"2021-04-12"]
[null,{"$f":"ROUND(2*350,2)-SUM($B$412)","v":300},14183.77,null,"2021-04-12"]
[null,218.61,13965.16,null,"2021-04-12"]
[null,44.71,13920.45,null,"2021-04-14"]
[null,1000,12920.45,null,"2021-04-14"]
[null,{"$f":"SUM($A$401)","v":300},12620.45,null,"2021-04-14"]
[null,{"$f":"ROUND(18*30,2)","v":540},12080.45,null,"2021-04-14"]
[null,60,12020.45,null,"2021-04-14"]
[null,100,11920.45,null,"2021-04-15"]
[null,20,11900.45,null,"2021-04-16"]
[400,null,12300.45,null,"2021-04-17"]
[null,400,11900.45,null,"2021-04-17"]
[null,300,11600.45,null,"2021-04-17"]
[null,{"$f":"55.41","v":55.41},11545.04,null,"2021-04-18"]
[null,{"$f":"SUM($A$411)","v":400},11145.04,null,"2021-04-18"]
[null,270,10875.04,null,"2021-04-18"]
[null,{"$f":"328+((2))","v":330},10545.04,null,"2021-04-18"]
[100,null,10645.04,null,"2021-04-18"]
[null,695.86,9949.18,null,"2021-04-19"]
[350,null,10299.18,null,"2021-04-20"]
[null,{"$f":"ROUND(1*350,2)","v":350},9949.18,null,"2021-04-20"]
[null,{"$f":"ROUND((2*750)-(2*150),2)","v":1200},8749.18,null,"2021-04-22"]
[null,{"$f":"SUM($A$420)","v":350},8399.18,null,"2021-04-22"]
[null,45.5,8353.68,null,"2021-04-22"]
[null,54.5,8299.18,null,"2021-04-22"]
[null,{"$f":"ROUND(5*30,2)","v":150},8149.18,null,"2021-04-22"]
[null,137,8012.18,null,"2021-04-22"]
[null,57.47,7954.71,null,"2021-04-22"]
[null,{"$f":"210","v":210},7744.71,null,"2021-04-23"]
[10,null,7754.71,null,"2021-04-23"]
[null,50.64,7704.07,null,"2021-04-24"]
[null,217.38,7486.69,null,"2021-04-24"]
[null,{"$f":"ROUND(10*30,2)","v":300},7186.69,null,"2021-04-25"]
[null,{"$f":"ROUND((2*50%*120)+(1*50%*110),2)","v":175},7011.69,null,"2021-04-25"]
[null,{"$f":"ROUND((1*799),2)+((1))","v":800},6211.69,null,"2021-04-25"]
[null,74.28,6137.41,null,"2021-04-26"]
[null,55.45,6081.96,null,"2021-04-26"]
[null,{"$f":"ROUND(1*250,2)","v":250},5831.96,null,"2021-04-26"]
[null,250,5581.96,null,"2021-04-26"]
[null,{"$f":"ROUND(1*150,2)","v":150},5431.96,null,"2021-04-26"]
[null,{"$f":"ROUND((1*200)+(1*50)+(1*100),2)","v":350},5081.96,null,"2021-04-27"]
[null,500,4581.96,null,"2021-04-27"]
[null,{"$f":"ROUND((1*849),2)","v":849},3732.96,null,"2021-04-27"]
[null,{"$f":"ROUND((1*495),2)","v":495},3237.96,null,"2021-04-27"]
[null,400,2837.96,null,"2021-04-27"]
[{"$f":"CEILING(18970+(18970*15%),10)","v":21820},null,24657.96,null,"2021-04-27"]
[{"$f":"ROUNDUP(22042+(22042*15%),0)","v":25349},null,50006.96,null,"2021-04-28"]
[null,700,49306.96,null,"2021-04-28"]
[null,56.05,49250.91,null,"2021-04-28"]
[null,null,49250.91]
[null,null,49250.91]
[null,null,49250.91]
[null,null,{"$f":"ROUND(C452+A453-B453,2)","v":49250.91}]
[null,{"$f":"ROUND(57*416.306,2)","v":23729.439999999999},25521.47,null,"2021-05-04"]
[null,{"$f":"ROUND(57*416.306,2)","v":23729.439999999999},1792.03,null,"2021-05-04"]
[null,{"$f":"ROUND(1*500,2)","v":500},1292.03,null,"2021-05-04"]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,{"$f":"ROUND(C516+A517-B517,2)","v":1292.03}]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,{"$f":"ROUND(C580+A581-B581,2)","v":1292.03}]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,{"$f":"ROUND(C644+A645-B645,2)","v":1292.03}]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,{"$f":"ROUND(C708+A709-B709,2)","v":1292.03}]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,{"$f":"ROUND(C772+A773-B773,2)","v":1292.03}]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,{"$f":"ROUND(C836+A837-B837,2)","v":1292.03}]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,{"$f":"ROUND(C900+A901-B901,2)","v":1292.03}]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,{"$f":"ROUND(C964+A965-B965,2)","v":1292.03}]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,{"$f":"ROUND(C1028+A1029-B1029,2)","v":1292.03}]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,{"$f":"ROUND(C1092+A1093-B1093,2)","v":1292.03}]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,{"$f":"ROUND(C1156+A1157-B1157,2)","v":1292.03}]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,{"$f":"ROUND(C1220+A1221-B1221,2)","v":1292.03}]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,{"$f":"ROUND(C1284+A1285-B1285,2)","v":1292.03}]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,1292.03]
[null,null,{"$f":"ROUND(C1298+A1299-B1299,2)","v":1292.03}]
[{"$f":"SUM(A4:$A$1299)","v":1645782.2399999995},{"$f":"SUM(B4:$B$1299)","v":1648485.2299999986},{"$f":"ROUND($A$3+$A$1300-$B$1300,2)","v":1292.03},{"$f":"NumtoTxt(C1300,\"جنيهاً\",\"قرشاً\")&\" فقط لاغير\"","v":"فقط  ألف ومائتان وإثنان وتسعون جنيهاً وثلاثة قرشاً فقط لاغير"},{"$f":"IF(TODAY()>(DATE(YEAR($E$3),COLUMN(M1)+1,0)),(DATE(YEAR($E$3),COLUMN(M1)+1,0)),TODAY())","v":"2021-04-30"}]

{"sheet":"-- Trading Investments --","index":1,"n_rows":154,"n_cols":24,"rows_kept":154,"cut":false,"hidden":false,"merged":[[128,2,128,3],[129,2,129,3],[128,6,128,7],[125,2,125,3],[126,2,126,3],[125,6,125,7],[126,6,126,7],[0,0,0,23],[1,0,2,0],[1,2,1,4],[1,6,1,8],[1,10,2,10],[1,11,2,11],[1,12,2,12],[1,14,2,14],[1,16,1,18],[1,20,2,20],[1,21,2,21],[1,23,2,23],[131,20,131,21],[131,10,131,11],[132,10,132,11],[125,14,125,17],[126,14,126,17],[125,20,125,21],[126,20,126,21],[128,20,128,21],[129,20,129,21],[128,14,128,17],[128,10,128,11],[132,20,132,21],[126,10,126,11],[129,10,129,11],[125,10,125,11],[153,14,153,16],[152,2,152,3],[152,5,152,6],[152,14,152,16],[129,6,129,7],[129,14,129,17],[131,14,131,17],[132,14,132,17],[132,2,132,3],[131,2,131,3],[153,2,153,3],[153,5,153,6],[152,10,152,11],[131,6,131,7],[132,6,132,7]]}
[]
["م",null,"شراء",null,null,null,"إسترداد",null,null,null,"التكلفة\nالدفترية","أرباح\nإسترداد","التغير فى\nالقيمة العادلة",null,"ربحية\nالوثيقة",null,"رصيد",null,null,null,"البيـــــــان","التاريخ",null,"م"]
[null,null,"عدد\nالوثائق","سعر\nالوثيقة","قيمة",null,"عدد\nالوثائق","سعر\nالوثيقة","قيمة",null,null,null,null,null,null,null,"عدد\nالوثائق","متوسط\nالسعر","قيمة"]
[]
[{"$f":"IF(V5>0,ROW()-5,\"\")","v":0},null,82,403.779,{"$f":"IF(C5>0,ROUND(C5*D5,2),\"\")","v":33109.879999999997},null,null,null,{"$f":"IF(G5>0,ROUND(G5*H5,2),\"\")","v":""},null,{"$f":"IFERROR(IF(G5>0,ROUND(G5*R4,2),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(G5>0,ROUND(I5-K5,2),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(V6=\"\",$C$127>(SUM(S4,E5)-SUM(K5))/(SUM(Q4,C5)-SUM(G5)),V5>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q4,C5)-SUM(G5))*$C$127)-((SUM(Q4,C5)-SUM(G5))*(R4)),\"\"),\"\")","v":""},null,{"$f":"IF(H5>0,ROUND(H5-R4,2),\"\")","v":""},null,{"$f":"C5-G5","v":82},{"$f":"IF(Q5>0,ROUND(S5/Q5,100),0)","v":403.77902439024399},{"$f":"ROUND(SUM(E5,M5)-SUM(K5),100)","v":33109.879999999997},null,"رصيد أول المدة",{"$f":"SUM('-- QNB - Current Account --'!E3)","v":"2021-01-01"},null,{"$f":"IF($V5=\"\",\"\",IFERROR(IF(MONTH($V6)=MONTH($V5),$X4+0,1),1))","v":0}]
[{"$f":"IF(V6>0,ROW()-5,\"\")","v":1},null,null,null,{"$f":"IF(C6>0,ROUND(C6*D6,2),\"\")","v":""},null,12,404.09500000000003,{"$f":"IF(G6>0,ROUND(G6*H6,2),\"\")","v":4849.1400000000003},null,{"$f":"IFERROR(IF(G6>0,ROUND(G6*R5,2),\"\"),\"\")","v":4845.3500000000004},{"$f":"IFERROR(IF(G6>0,ROUND(I6-K6,2),\"\"),\"\")","v":3.79},{"$f":"IFERROR(IF(AND(V7=\"\",$C$127>(SUM(S5,E6)-SUM(K6))/(SUM(Q5,C6)-SUM(G6)),V6>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q5,C6)-SUM(G6))*$C$127)-((SUM(Q5,C6)-SUM(G6))*(R5)),\"\"),\"\")","v":""},null,{"$f":"IF(H6>0,ROUND(H6-R5,2),\"\")","v":0.32},null,{"$f":"Q5+C6-G6","v":70},{"$f":"IF(Q6>0,ROUND(S6/Q6,100),0)","v":403.779},{"$f":"ROUND(SUM(S5,E6,M6)-SUM(K6),100)","v":28264.53},null,{"$f":"IF(C6>0,CONCATENATE(\"شراء \",\"\",\"\",C6,\" وثيقة\"),IF(G6>0,CONCATENATE(\"إسترداد \",\"\",\"\",G6,\" وثيقة\"),IF(V6=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 12 وثيقة"},"2021-01-03",null,{"$f":"IF($V6=\"\",\"\",IFERROR(IF(MONTH($V6)=MONTH($V5),$X5+1,1),1))","v":1}]
[{"$f":"IF(V7>0,ROW()-5,\"\")","v":2},null,null,null,{"$f":"IF(C7>0,ROUND(C7*D7,2),\"\")","v":""},null,8,404.411,{"$f":"IF(G7>0,ROUND(G7*H7,2),\"\")","v":3235.29},null,{"$f":"IFERROR(IF(G7>0,ROUND(G7*R6,2),\"\"),\"\")","v":3230.23},{"$f":"IFERROR(IF(G7>0,ROUND(I7-K7,2),\"\"),\"\")","v":5.0599999999999996},{"$f":"IFERROR(IF(AND(V8=\"\",$C$127>(SUM(S6,E7)-SUM(K7))/(SUM(Q6,C7)-SUM(G7)),V7>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q6,C7)-SUM(G7))*$C$127)-((SUM(Q6,C7)-SUM(G7))*(R6)),\"\"),\"\")","v":""},null,{"$f":"IF(H7>0,ROUND(H7-R6,2),\"\")","v":0.63},null,{"$f":"Q6+C7-G7","v":62},{"$f":"IF(Q7>0,ROUND(S7/Q7,100),0)","v":403.77903225806398},25034.3,null,{"$f":"IF(C7>0,CONCATENATE(\"شراء \",\"\",\"\",C7,\" وثيقة\"),IF(G7>0,CONCATENATE(\"إسترداد \",\"\",\"\",G7,\" وثيقة\"),IF(V7=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 8 وثيقة"},"2021-01-06",null,2]
[3,null,52,405.892,21106.38,null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V9=\"\",$C$127>(SUM(S7,E8)-SUM(K8))/(SUM(Q7,C8)-SUM(G8)),V8>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q7,C8)-SUM(G8))*$C$127)-((SUM(Q7,C8)-SUM(G8))*(R7)),\"\"),\"\")","v":""},null,"",null,114,404.74280701754401,46140.68,null,{"$f":"IF(C8>0,CONCATENATE(\"شراء \",\"\",\"\",C8,\" وثيقة\"),IF(G8>0,CONCATENATE(\"إسترداد \",\"\",\"\",G8,\" وثيقة\"),IF(V8=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"شراء 52 وثيقة"},"2021-01-20",null,3]
[4,null,null,null,"",null,4,405.99700000000001,1623.99,null,1618.97,5.0199999999999996,{"$f":"IFERROR(IF(AND(V10=\"\",$C$127>(SUM(S8,E9)-SUM(K9))/(SUM(Q8,C9)-SUM(G9)),V9>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q8,C9)-SUM(G9))*$C$127)-((SUM(Q8,C9)-SUM(G9))*(R8)),\"\"),\"\")","v":""},null,1.25,null,110,404.742818181818,44521.71,null,{"$f":"IF(C9>0,CONCATENATE(\"شراء \",\"\",\"\",C9,\" وثيقة\"),IF(G9>0,CONCATENATE(\"إسترداد \",\"\",\"\",G9,\" وثيقة\"),IF(V9=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 4 وثيقة"},"2021-01-21",null,4]
[5,null,102,406.52300000000002,41465.35,null,null,null,{"$f":"IF(G10>0,ROUND(G10*H10,2),\"\")","v":""},null,"","",{"$f":"IFERROR(IF(AND(V11=\"\",$C$127>(SUM(S9,E10)-SUM(K10))/(SUM(Q9,C10)-SUM(G10)),V10>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q9,C10)-SUM(G10))*$C$127)-((SUM(Q9,C10)-SUM(G10))*(R9)),\"\"),\"\")","v":""},null,"",null,212,405.59933962264103,85987.06,null,{"$f":"IF(C10>0,CONCATENATE(\"شراء \",\"\",\"\",C10,\" وثيقة\"),IF(G10>0,CONCATENATE(\"إسترداد \",\"\",\"\",G10,\" وثيقة\"),IF(V10=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"شراء 102 وثيقة"},"2021-01-26",null,5]
[6,null,null,null,"",null,4,406.62799999999999,1626.51,null,1622.4,4.1100000000000003,{"$f":"IFERROR(IF(AND(V12=\"\",$C$127>(SUM(S10,E11)-SUM(K11))/(SUM(Q10,C11)-SUM(G11)),V11>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q10,C11)-SUM(G11))*$C$127)-((SUM(Q10,C11)-SUM(G11))*(R10)),\"\"),\"\")","v":""},null,{"$f":"IF(H11>0,ROUND(H11-R10,2),\"\")","v":1.03},null,{"$f":"Q10+C11-G11","v":208},405.599326923077,84364.66,null,{"$f":"IF(C11>0,CONCATENATE(\"شراء \",\"\",\"\",C11,\" وثيقة\"),IF(G11>0,CONCATENATE(\"إسترداد \",\"\",\"\",G11,\" وثيقة\"),IF(V11=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 4 وثيقة"},"2021-01-27",null,6]
[7,null,null,null,"",null,23,407.26,9366.98,null,{"$f":"IFERROR(IF(G12>0,ROUND(G12*R11,2),\"\"),\"\")","v":9328.7800000000007},38.200000000000003,{"$f":"IFERROR(IF(AND(V13=\"\",$C$127>(SUM(S11,E12)-SUM(K12))/(SUM(Q11,C12)-SUM(G12)),V12>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q11,C12)-SUM(G12))*$C$127)-((SUM(Q11,C12)-SUM(G12))*(R11)),\"\"),\"\")","v":""},null,{"$f":"IF(H12>0,ROUND(H12-R11,2),\"\")","v":1.66},null,{"$f":"Q11+C12-G12","v":185},{"$f":"IF(Q12>0,ROUND(S12/Q12,100),0)","v":405.599351351351},75035.88,null,{"$f":"IF(C12>0,CONCATENATE(\"شراء \",\"\",\"\",C12,\" وثيقة\"),IF(G12>0,CONCATENATE(\"إسترداد \",\"\",\"\",G12,\" وثيقة\"),IF(V12=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 23 وثيقة"},"2021-02-02",null,1]
[8,null,2467,407.26,1004710.42,null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V14=\"\",$C$127>(SUM(S12,E13)-SUM(K13))/(SUM(Q12,C13)-SUM(G13)),V13>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q12,C13)-SUM(G13))*$C$127)-((SUM(Q12,C13)-SUM(G13))*(R12)),\"\"),\"\")","v":""},null,{"$f":"IF(H13>0,ROUND(H13-R12,2),\"\")","v":""},null,{"$f":"Q12+C13-G13","v":2652},{"$f":"IF(Q13>0,ROUND(S13/Q13,100),0)","v":407.14415535444903},1079746.3,null,{"$f":"IF(C13>0,CONCATENATE(\"شراء \",\"\",\"\",C13,\" وثيقة\"),IF(G13>0,CONCATENATE(\"إسترداد \",\"\",\"\",G13,\" وثيقة\"),IF(V13=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"شراء 2467 وثيقة"},"2021-02-02",null,2]
[9,null,null,null,"",null,25,407.471,10186.780000000001,null,10178.6,8.18,{"$f":"IFERROR(IF(AND(V15=\"\",$C$127>(SUM(S13,E14)-SUM(K14))/(SUM(Q13,C14)-SUM(G14)),V14>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q13,C14)-SUM(G14))*$C$127)-((SUM(Q13,C14)-SUM(G14))*(R13)),\"\"),\"\")","v":""},null,0.33,null,2627,407.144156832889,1069567.7,null,{"$f":"IF(C14>0,CONCATENATE(\"شراء \",\"\",\"\",C14,\" وثيقة\"),IF(G14>0,CONCATENATE(\"إسترداد \",\"\",\"\",G14,\" وثيقة\"),IF(V14=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 25 وثيقة"},"2021-02-04",null,3]
[10,null,null,null,"",null,1,407.89299999999997,407.89,null,407.14,0.75,{"$f":"IFERROR(IF(AND(V16=\"\",$C$127>(SUM(S14,E15)-SUM(K15))/(SUM(Q14,C15)-SUM(G15)),V15>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q14,C15)-SUM(G15))*$C$127)-((SUM(Q14,C15)-SUM(G15))*(R14)),\"\"),\"\")","v":""},null,0.75,null,2626,407.14415841584201,1069160.56,null,{"$f":"IF(C15>0,CONCATENATE(\"شراء \",\"\",\"\",C15,\" وثيقة\"),IF(G15>0,CONCATENATE(\"إسترداد \",\"\",\"\",G15,\" وثيقة\"),IF(V15=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 1 وثيقة"},"2021-02-08",null,4]
[11,null,null,null,"",null,53,407.99900000000002,21623.95,null,21578.639999999999,45.31,{"$f":"IFERROR(IF(AND(V17=\"\",$C$127>(SUM(S15,E16)-SUM(K16))/(SUM(Q15,C16)-SUM(G16)),V16>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q15,C16)-SUM(G16))*$C$127)-((SUM(Q15,C16)-SUM(G16))*(R15)),\"\"),\"\")","v":""},null,0.85,null,2573,407.14415856976302,1047581.92,null,{"$f":"IF(C16>0,CONCATENATE(\"شراء \",\"\",\"\",C16,\" وثيقة\"),IF(G16>0,CONCATENATE(\"إسترداد \",\"\",\"\",G16,\" وثيقة\"),IF(V16=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 53 وثيقة"},"2021-02-09",null,5]
[12,null,null,null,"",null,19,408.21100000000001,7756.01,null,7735.74,20.27,{"$f":"IFERROR(IF(AND(V18=\"\",$C$127>(SUM(S16,E17)-SUM(K17))/(SUM(Q16,C17)-SUM(G17)),V17>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q16,C17)-SUM(G17))*$C$127)-((SUM(Q16,C17)-SUM(G17))*(R16)),\"\"),\"\")","v":""},null,1.07,null,2554,407.14415818324198,1039846.18,null,{"$f":"IF(C17>0,CONCATENATE(\"شراء \",\"\",\"\",C17,\" وثيقة\"),IF(G17>0,CONCATENATE(\"إسترداد \",\"\",\"\",G17,\" وثيقة\"),IF(V17=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 19 وثيقة"},"2021-02-11",null,6]
[13,null,null,null,"",null,31,409.37799999999999,12690.72,null,12621.47,69.25,{"$f":"IFERROR(IF(AND(V19=\"\",$C$127>(SUM(S17,E18)-SUM(K18))/(SUM(Q17,C18)-SUM(G18)),V18>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q17,C18)-SUM(G18))*$C$127)-((SUM(Q17,C18)-SUM(G18))*(R17)),\"\"),\"\")","v":""},null,2.23,null,2523,407.14415774871202,1027224.71,null,{"$f":"IF(C18>0,CONCATENATE(\"شراء \",\"\",\"\",C18,\" وثيقة\"),IF(G18>0,CONCATENATE(\"إسترداد \",\"\",\"\",G18,\" وثيقة\"),IF(V18=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 31 وثيقة"},"2021-02-22",null,7]
[14,null,null,null,"",null,3,409.48500000000001,1228.46,null,1221.43,7.03,{"$f":"IFERROR(IF(AND(V20=\"\",$C$127>(SUM(S18,E19)-SUM(K19))/(SUM(Q18,C19)-SUM(G19)),V19>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q18,C19)-SUM(G19))*$C$127)-((SUM(Q18,C19)-SUM(G19))*(R18)),\"\"),\"\")","v":""},null,2.34,null,2520,407.14415873015901,1026003.28,null,{"$f":"IF(C19>0,CONCATENATE(\"شراء \",\"\",\"\",C19,\" وثيقة\"),IF(G19>0,CONCATENATE(\"إسترداد \",\"\",\"\",G19,\" وثيقة\"),IF(V19=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 3 وثيقة"},"2021-02-23",null,8]
[15,null,null,null,"",null,482,410.02499999999998,197632.05,null,196243.48,{"$f":"IFERROR(IF(G20>0,ROUND(I20-K20,2),\"\"),\"\")","v":1388.57},{"$f":"IFERROR(IF(AND(V21=\"\",$C$127>(SUM(S19,E20)-SUM(K20))/(SUM(Q19,C20)-SUM(G20)),V20>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q19,C20)-SUM(G20))*$C$127)-((SUM(Q19,C20)-SUM(G20))*(R19)),\"\"),\"\")","v":""},null,2.88,null,2038,407.14416094209997,829759.8,null,{"$f":"IF(C20>0,CONCATENATE(\"شراء \",\"\",\"\",C20,\" وثيقة\"),IF(G20>0,CONCATENATE(\"إسترداد \",\"\",\"\",G20,\" وثيقة\"),IF(V20=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 482 وثيقة"},"2021-02-28",null,9]
[16,null,null,null,"",null,5,410.13200000000001,2050.66,null,2035.72,14.94,{"$f":"IFERROR(IF(AND(V22=\"\",$C$127>(SUM(S20,E21)-SUM(K21))/(SUM(Q20,C21)-SUM(G21)),V21>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q20,C21)-SUM(G21))*$C$127)-((SUM(Q20,C21)-SUM(G21))*(R20)),\"\"),\"\")","v":""},null,2.99,null,2033,407.144161337924,827724.08,null,{"$f":"IF(C21>0,CONCATENATE(\"شراء \",\"\",\"\",C21,\" وثيقة\"),IF(G21>0,CONCATENATE(\"إسترداد \",\"\",\"\",G21,\" وثيقة\"),IF(V21=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 5 وثيقة"},"2021-03-01",null,1]
[17,null,null,null,"",null,17,410.23899999999998,6974.06,null,6921.45,52.61,{"$f":"IFERROR(IF(AND(V23=\"\",$C$127>(SUM(S21,E22)-SUM(K22))/(SUM(Q21,C22)-SUM(G22)),V22>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q21,C22)-SUM(G22))*$C$127)-((SUM(Q21,C22)-SUM(G22))*(R21)),\"\"),\"\")","v":""},null,3.09,null,2016,407.144161706349,820802.63,null,{"$f":"IF(C22>0,CONCATENATE(\"شراء \",\"\",\"\",C22,\" وثيقة\"),IF(G22>0,CONCATENATE(\"إسترداد \",\"\",\"\",G22,\" وثيقة\"),IF(V22=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 17 وثيقة"},"2021-03-02",null,2]
[18,null,2,410.34399999999999,820.69,null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V24=\"\",$C$127>(SUM(S22,E23)-SUM(K23))/(SUM(Q22,C23)-SUM(G23)),V23>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q22,C23)-SUM(G23))*$C$127)-((SUM(Q22,C23)-SUM(G23))*(R22)),\"\"),\"\")","v":""},null,"",null,2018,407.14733399405299,821623.32,null,{"$f":"IF(C23>0,CONCATENATE(\"شراء \",\"\",\"\",C23,\" وثيقة\"),IF(G23>0,CONCATENATE(\"إسترداد \",\"\",\"\",G23,\" وثيقة\"),IF(V23=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"شراء 2 وثيقة"},"2021-03-03",null,3]
[19,null,null,null,"",null,2,410.44900000000001,820.9,null,814.29,6.61,{"$f":"IFERROR(IF(AND(V25=\"\",$C$127>(SUM(S23,E24)-SUM(K24))/(SUM(Q23,C24)-SUM(G24)),V24>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q23,C24)-SUM(G24))*$C$127)-((SUM(Q23,C24)-SUM(G24))*(R23)),\"\"),\"\")","v":""},null,3.3,null,2016,407.14733630952401,820809.03,null,{"$f":"IF(C24>0,CONCATENATE(\"شراء \",\"\",\"\",C24,\" وثيقة\"),IF(G24>0,CONCATENATE(\"إسترداد \",\"\",\"\",G24,\" وثيقة\"),IF(V24=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 2 وثيقة"},"2021-03-04",null,4]
[20,null,null,null,"",null,3,410.76499999999999,1232.3,null,1221.44,10.86,{"$f":"IFERROR(IF(AND(V26=\"\",$C$127>(SUM(S24,E25)-SUM(K25))/(SUM(Q24,C25)-SUM(G25)),V25>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q24,C25)-SUM(G25))*$C$127)-((SUM(Q24,C25)-SUM(G25))*(R24)),\"\"),\"\")","v":""},null,3.62,null,2013,407.147337307501,819587.59,null,{"$f":"IF(C25>0,CONCATENATE(\"شراء \",\"\",\"\",C25,\" وثيقة\"),IF(G25>0,CONCATENATE(\"إسترداد \",\"\",\"\",G25,\" وثيقة\"),IF(V25=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 3 وثيقة"},"2021-03-07",null,5]
[21,null,null,null,"",null,74,410.87,30404.38,null,30128.9,275.48,{"$f":"IFERROR(IF(AND(V27=\"\",$C$127>(SUM(S25,E26)-SUM(K26))/(SUM(Q25,C26)-SUM(G26)),V26>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q25,C26)-SUM(G26))*$C$127)-((SUM(Q25,C26)-SUM(G26))*(R25)),\"\"),\"\")","v":""},null,3.72,null,1939,407.14733883445098,789458.69,null,{"$f":"IF(C26>0,CONCATENATE(\"شراء \",\"\",\"\",C26,\" وثيقة\"),IF(G26>0,CONCATENATE(\"إسترداد \",\"\",\"\",G26,\" وثيقة\"),IF(V26=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 74 وثيقة"},"2021-03-08",null,6]
[22,null,null,null,"",null,2,410.87,821.74,null,814.29,7.45,{"$f":"IFERROR(IF(AND(V28=\"\",$C$127>(SUM(S26,E27)-SUM(K27))/(SUM(Q26,C27)-SUM(G27)),V27>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q26,C27)-SUM(G27))*$C$127)-((SUM(Q26,C27)-SUM(G27))*(R26)),\"\"),\"\")","v":""},null,3.72,null,1937,407.14734124935501,788644.4,null,{"$f":"IF(C27>0,CONCATENATE(\"شراء \",\"\",\"\",C27,\" وثيقة\"),IF(G27>0,CONCATENATE(\"إسترداد \",\"\",\"\",G27,\" وثيقة\"),IF(V27=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 2 وثيقة"},"2021-03-08",null,7]
[23,null,null,null,"",null,3,411.18799999999999,1233.56,null,1221.44,12.12,{"$f":"IFERROR(IF(AND(V29=\"\",$C$127>(SUM(S27,E28)-SUM(K28))/(SUM(Q27,C28)-SUM(G28)),V28>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q27,C28)-SUM(G28))*$C$127)-((SUM(Q27,C28)-SUM(G28))*(R27)),\"\"),\"\")","v":""},null,4.04,null,1934,407.14734229575998,787422.96,null,{"$f":"IF(C28>0,CONCATENATE(\"شراء \",\"\",\"\",C28,\" وثيقة\"),IF(G28>0,CONCATENATE(\"إسترداد \",\"\",\"\",G28,\" وثيقة\"),IF(V28=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 3 وثيقة"},"2021-03-11",null,8]
[24,null,null,null,"",null,3,411.50799999999998,1234.52,null,1221.44,13.08,{"$f":"IFERROR(IF(AND(V30=\"\",$C$127>(SUM(S28,E29)-SUM(K29))/(SUM(Q28,C29)-SUM(G29)),V29>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q28,C29)-SUM(G29))*$C$127)-((SUM(Q28,C29)-SUM(G29))*(R28)),\"\"),\"\")","v":""},null,4.3600000000000003,null,1931,407.14734334541703,786201.52,null,{"$f":"IF(C29>0,CONCATENATE(\"شراء \",\"\",\"\",C29,\" وثيقة\"),IF(G29>0,CONCATENATE(\"إسترداد \",\"\",\"\",G29,\" وثيقة\"),IF(V29=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 3 وثيقة"},"2021-03-14",null,9]
[25,null,null,null,"",null,2,411.721,823.44,null,814.29,9.15,{"$f":"IFERROR(IF(AND(V31=\"\",$C$127>(SUM(S29,E30)-SUM(K30))/(SUM(Q29,C30)-SUM(G30)),V30>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q29,C30)-SUM(G30))*$C$127)-((SUM(Q29,C30)-SUM(G30))*(R29)),\"\"),\"\")","v":""},null,4.57,null,1929,407.14734577501298,785387.23,null,{"$f":"IF(C30>0,CONCATENATE(\"شراء \",\"\",\"\",C30,\" وثيقة\"),IF(G30>0,CONCATENATE(\"إسترداد \",\"\",\"\",G30,\" وثيقة\"),IF(V30=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 2 وثيقة"},"2021-03-16",null,10]
[26,null,null,null,"",null,2,411.93400000000003,823.87,null,814.29,9.58,{"$f":"IFERROR(IF(AND(V32=\"\",$C$127>(SUM(S30,E31)-SUM(K31))/(SUM(Q30,C31)-SUM(G31)),V31>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q30,C31)-SUM(G31))*$C$127)-((SUM(Q30,C31)-SUM(G31))*(R30)),\"\"),\"\")","v":""},null,4.79,null,1927,407.14734820965202,784572.94,null,{"$f":"IF(C31>0,CONCATENATE(\"شراء \",\"\",\"\",C31,\" وثيقة\"),IF(G31>0,CONCATENATE(\"إسترداد \",\"\",\"\",G31,\" وثيقة\"),IF(V31=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 2 وثيقة"},"2021-03-18",null,11]
[27,null,null,null,"",null,2,412.25400000000002,824.51,null,814.29,10.220000000000001,{"$f":"IFERROR(IF(AND(V33=\"\",$C$127>(SUM(S31,E32)-SUM(K32))/(SUM(Q31,C32)-SUM(G32)),V32>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q31,C32)-SUM(G32))*$C$127)-((SUM(Q31,C32)-SUM(G32))*(R31)),\"\"),\"\")","v":""},null,5.1100000000000003,null,1925,407.14735064935098,783758.65,null,{"$f":"IF(C32>0,CONCATENATE(\"شراء \",\"\",\"\",C32,\" وثيقة\"),IF(G32>0,CONCATENATE(\"إسترداد \",\"\",\"\",G32,\" وثيقة\"),IF(V32=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 2 وثيقة"},"2021-03-21",null,12]
[28,null,null,null,"",null,3,412.57299999999998,1237.72,null,1221.44,16.28,{"$f":"IFERROR(IF(AND(V34=\"\",$C$127>(SUM(S32,E33)-SUM(K33))/(SUM(Q32,C33)-SUM(G33)),V33>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q32,C33)-SUM(G33))*$C$127)-((SUM(Q32,C33)-SUM(G33))*(R32)),\"\"),\"\")","v":""},null,5.43,null,1922,407.147351716961,782537.21,null,{"$f":"IF(C33>0,CONCATENATE(\"شراء \",\"\",\"\",C33,\" وثيقة\"),IF(G33>0,CONCATENATE(\"إسترداد \",\"\",\"\",G33,\" وثيقة\"),IF(V33=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 3 وثيقة"},"2021-03-24",null,13]
[29,null,null,null,"",null,1,412.67899999999997,412.68,null,407.15,5.53,{"$f":"IFERROR(IF(AND(V35=\"\",$C$127>(SUM(S33,E34)-SUM(K34))/(SUM(Q33,C34)-SUM(G34)),V34>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q33,C34)-SUM(G34))*$C$127)-((SUM(Q33,C34)-SUM(G34))*(R33)),\"\"),\"\")","v":""},null,5.53,null,1921,407.14735033836502,782130.06,null,{"$f":"IF(C34>0,CONCATENATE(\"شراء \",\"\",\"\",C34,\" وثيقة\"),IF(G34>0,CONCATENATE(\"إسترداد \",\"\",\"\",G34,\" وثيقة\"),IF(V34=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 1 وثيقة"},"2021-03-25",null,14]
[30,null,58,413.21100000000001,23966.240000000002,null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V36=\"\",$C$127>(SUM(S34,E35)-SUM(K35))/(SUM(Q34,C35)-SUM(G35)),V35>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q34,C35)-SUM(G35))*$C$127)-((SUM(Q34,C35)-SUM(G35))*(R34)),\"\"),\"\")","v":""},null,"",null,1979,407.325063163214,806096.3,null,{"$f":"IF(C35>0,CONCATENATE(\"شراء \",\"\",\"\",C35,\" وثيقة\"),IF(G35>0,CONCATENATE(\"إسترداد \",\"\",\"\",G35,\" وثيقة\"),IF(V35=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"شراء 58 وثيقة"},"2021-03-30",null,15]
[31,null,51,413.31700000000001,21079.17,null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V37=\"\",$C$127>(SUM(S35,E36)-SUM(K36))/(SUM(Q35,C36)-SUM(G36)),V36>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q35,C36)-SUM(G36))*$C$127)-((SUM(Q35,C36)-SUM(G36))*(R35)),\"\"),\"\")","v":""},null,"",null,2030,407.475600985222,827175.47,null,{"$f":"IF(C36>0,CONCATENATE(\"شراء \",\"\",\"\",C36,\" وثيقة\"),IF(G36>0,CONCATENATE(\"إسترداد \",\"\",\"\",G36,\" وثيقة\"),IF(V36=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"شراء 51 وثيقة"},"2021-03-31",null,16]
[32,null,null,null,"",null,15,413.423,6201.35,null,6112.13,89.22,{"$f":"IFERROR(IF(AND(V38=\"\",$C$127>(SUM(S36,E37)-SUM(K37))/(SUM(Q36,C37)-SUM(G37)),V37>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q36,C37)-SUM(G37))*$C$127)-((SUM(Q36,C37)-SUM(G37))*(R36)),\"\"),\"\")","v":""},null,5.95,null,2015,407.47560297766699,821063.34,null,{"$f":"IF(C37>0,CONCATENATE(\"شراء \",\"\",\"\",C37,\" وثيقة\"),IF(G37>0,CONCATENATE(\"إسترداد \",\"\",\"\",G37,\" وثيقة\"),IF(V37=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 15 وثيقة"},"2021-04-01",null,1]
[33,null,null,null,"",null,20,413.74,8274.7999999999993,null,8149.51,125.29,{"$f":"IFERROR(IF(AND(V39=\"\",$C$127>(SUM(S37,E38)-SUM(K38))/(SUM(Q37,C38)-SUM(G38)),V38>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q37,C38)-SUM(G38))*$C$127)-((SUM(Q37,C38)-SUM(G38))*(R37)),\"\"),\"\")","v":""},null,6.26,null,1995,407.47560401002499,812913.83,null,{"$f":"IF(C38>0,CONCATENATE(\"شراء \",\"\",\"\",C38,\" وثيقة\"),IF(G38>0,CONCATENATE(\"إسترداد \",\"\",\"\",G38,\" وثيقة\"),IF(V38=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 20 وثيقة"},"2021-04-04",null,2]
[34,null,null,null,"",null,54,413.846,22347.68,null,22003.68,344,{"$f":"IFERROR(IF(AND(V40=\"\",$C$127>(SUM(S38,E39)-SUM(K39))/(SUM(Q38,C39)-SUM(G39)),V39>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q38,C39)-SUM(G39))*$C$127)-((SUM(Q38,C39)-SUM(G39))*(R38)),\"\"),\"\")","v":""},null,6.37,null,1941,407.47560535806298,790910.15,null,{"$f":"IF(C39>0,CONCATENATE(\"شراء \",\"\",\"\",C39,\" وثيقة\"),IF(G39>0,CONCATENATE(\"إسترداد \",\"\",\"\",G39,\" وثيقة\"),IF(V39=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 54 وثيقة"},"2021-04-05",null,3]
[35,null,null,null,"",null,28,413.95100000000002,11590.63,null,11409.32,181.31,{"$f":"IFERROR(IF(AND(V41=\"\",$C$127>(SUM(S39,E40)-SUM(K40))/(SUM(Q39,C40)-SUM(G40)),V40>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q39,C40)-SUM(G40))*$C$127)-((SUM(Q39,C40)-SUM(G40))*(R39)),\"\"),\"\")","v":""},null,6.48,null,1913,407.47560376372201,779500.83,null,{"$f":"IF(C40>0,CONCATENATE(\"شراء \",\"\",\"\",C40,\" وثيقة\"),IF(G40>0,CONCATENATE(\"إسترداد \",\"\",\"\",G40,\" وثيقة\"),IF(V40=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 28 وثيقة"},"2021-04-06",null,4]
[36,null,null,null,"",null,3,414.05799999999999,1242.17,null,1222.43,19.739999999999998,{"$f":"IFERROR(IF(AND(V42=\"\",$C$127>(SUM(S40,E41)-SUM(K41))/(SUM(Q40,C41)-SUM(G41)),V41>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q40,C41)-SUM(G41))*$C$127)-((SUM(Q40,C41)-SUM(G41))*(R40)),\"\"),\"\")","v":""},null,6.58,null,1910,407.47560209424103,778278.40000000002,null,{"$f":"IF(C41>0,CONCATENATE(\"شراء \",\"\",\"\",C41,\" وثيقة\"),IF(G41>0,CONCATENATE(\"إسترداد \",\"\",\"\",G41,\" وثيقة\"),IF(V41=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 3 وثيقة"},"2021-04-07",null,5]
[37,null,null,null,"",null,8,414.16399999999999,3313.31,null,3259.8,53.51,{"$f":"IFERROR(IF(AND(V43=\"\",$C$127>(SUM(S41,E42)-SUM(K42))/(SUM(Q41,C42)-SUM(G42)),V42>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q41,C42)-SUM(G42))*$C$127)-((SUM(Q41,C42)-SUM(G42))*(R41)),\"\"),\"\")","v":""},null,6.69,null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C42>0,CONCATENATE(\"شراء \",\"\",\"\",C42,\" وثيقة\"),IF(G42>0,CONCATENATE(\"إسترداد \",\"\",\"\",G42,\" وثيقة\"),IF(V42=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 8 وثيقة"},"2021-04-08",null,6]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V44=\"\",$C$127>(SUM(S42,E43)-SUM(K43))/(SUM(Q42,C43)-SUM(G43)),V43>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q42,C43)-SUM(G43))*$C$127)-((SUM(Q42,C43)-SUM(G43))*(R42)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C43>0,CONCATENATE(\"شراء \",\"\",\"\",C43,\" وثيقة\"),IF(G43>0,CONCATENATE(\"إسترداد \",\"\",\"\",G43,\" وثيقة\"),IF(V43=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V45=\"\",$C$127>(SUM(S43,E44)-SUM(K44))/(SUM(Q43,C44)-SUM(G44)),V44>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q43,C44)-SUM(G44))*$C$127)-((SUM(Q43,C44)-SUM(G44))*(R43)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C44>0,CONCATENATE(\"شراء \",\"\",\"\",C44,\" وثيقة\"),IF(G44>0,CONCATENATE(\"إسترداد \",\"\",\"\",G44,\" وثيقة\"),IF(V44=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V46=\"\",$C$127>(SUM(S44,E45)-SUM(K45))/(SUM(Q44,C45)-SUM(G45)),V45>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q44,C45)-SUM(G45))*$C$127)-((SUM(Q44,C45)-SUM(G45))*(R44)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C45>0,CONCATENATE(\"شراء \",\"\",\"\",C45,\" وثيقة\"),IF(G45>0,CONCATENATE(\"إسترداد \",\"\",\"\",G45,\" وثيقة\"),IF(V45=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,{"$f":"IFERROR(IF(G46>0,ROUND(G46*R45,2),\"\"),\"\")","v":""},"",{"$f":"IFERROR(IF(AND(V47=\"\",$C$127>(SUM(S45,E46)-SUM(K46))/(SUM(Q45,C46)-SUM(G46)),V46>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q45,C46)-SUM(G46))*$C$127)-((SUM(Q45,C46)-SUM(G46))*(R45)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C46>0,CONCATENATE(\"شراء \",\"\",\"\",C46,\" وثيقة\"),IF(G46>0,CONCATENATE(\"إسترداد \",\"\",\"\",G46,\" وثيقة\"),IF(V46=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V48=\"\",$C$127>(SUM(S46,E47)-SUM(K47))/(SUM(Q46,C47)-SUM(G47)),V47>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q46,C47)-SUM(G47))*$C$127)-((SUM(Q46,C47)-SUM(G47))*(R46)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C47>0,CONCATENATE(\"شراء \",\"\",\"\",C47,\" وثيقة\"),IF(G47>0,CONCATENATE(\"إسترداد \",\"\",\"\",G47,\" وثيقة\"),IF(V47=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V49=\"\",$C$127>(SUM(S47,E48)-SUM(K48))/(SUM(Q47,C48)-SUM(G48)),V48>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q47,C48)-SUM(G48))*$C$127)-((SUM(Q47,C48)-SUM(G48))*(R47)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C48>0,CONCATENATE(\"شراء \",\"\",\"\",C48,\" وثيقة\"),IF(G48>0,CONCATENATE(\"إسترداد \",\"\",\"\",G48,\" وثيقة\"),IF(V48=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V50=\"\",$C$127>(SUM(S48,E49)-SUM(K49))/(SUM(Q48,C49)-SUM(G49)),V49>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q48,C49)-SUM(G49))*$C$127)-((SUM(Q48,C49)-SUM(G49))*(R48)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C49>0,CONCATENATE(\"شراء \",\"\",\"\",C49,\" وثيقة\"),IF(G49>0,CONCATENATE(\"إسترداد \",\"\",\"\",G49,\" وثيقة\"),IF(V49=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V51=\"\",$C$127>(SUM(S49,E50)-SUM(K50))/(SUM(Q49,C50)-SUM(G50)),V50>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q49,C50)-SUM(G50))*$C$127)-((SUM(Q49,C50)-SUM(G50))*(R49)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C50>0,CONCATENATE(\"شراء \",\"\",\"\",C50,\" وثيقة\"),IF(G50>0,CONCATENATE(\"إسترداد \",\"\",\"\",G50,\" وثيقة\"),IF(V50=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V52=\"\",$C$127>(SUM(S50,E51)-SUM(K51))/(SUM(Q50,C51)-SUM(G51)),V51>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q50,C51)-SUM(G51))*$C$127)-((SUM(Q50,C51)-SUM(G51))*(R50)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C51>0,CONCATENATE(\"شراء \",\"\",\"\",C51,\" وثيقة\"),IF(G51>0,CONCATENATE(\"إسترداد \",\"\",\"\",G51,\" وثيقة\"),IF(V51=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V53=\"\",$C$127>(SUM(S51,E52)-SUM(K52))/(SUM(Q51,C52)-SUM(G52)),V52>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q51,C52)-SUM(G52))*$C$127)-((SUM(Q51,C52)-SUM(G52))*(R51)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C52>0,CONCATENATE(\"شراء \",\"\",\"\",C52,\" وثيقة\"),IF(G52>0,CONCATENATE(\"إسترداد \",\"\",\"\",G52,\" وثيقة\"),IF(V52=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V54=\"\",$C$127>(SUM(S52,E53)-SUM(K53))/(SUM(Q52,C53)-SUM(G53)),V53>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q52,C53)-SUM(G53))*$C$127)-((SUM(Q52,C53)-SUM(G53))*(R52)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C53>0,CONCATENATE(\"شراء \",\"\",\"\",C53,\" وثيقة\"),IF(G53>0,CONCATENATE(\"إسترداد \",\"\",\"\",G53,\" وثيقة\"),IF(V53=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V55=\"\",$C$127>(SUM(S53,E54)-SUM(K54))/(SUM(Q53,C54)-SUM(G54)),V54>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q53,C54)-SUM(G54))*$C$127)-((SUM(Q53,C54)-SUM(G54))*(R53)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C54>0,CONCATENATE(\"شراء \",\"\",\"\",C54,\" وثيقة\"),IF(G54>0,CONCATENATE(\"إسترداد \",\"\",\"\",G54,\" وثيقة\"),IF(V54=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,{"$f":"IF(G55>0,ROUND(G55*H55,2),\"\")","v":""},null,"","",{"$f":"IFERROR(IF(AND(V56=\"\",$C$127>(SUM(S54,E55)-SUM(K55))/(SUM(Q54,C55)-SUM(G55)),V55>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q54,C55)-SUM(G55))*$C$127)-((SUM(Q54,C55)-SUM(G55))*(R54)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C55>0,CONCATENATE(\"شراء \",\"\",\"\",C55,\" وثيقة\"),IF(G55>0,CONCATENATE(\"إسترداد \",\"\",\"\",G55,\" وثيقة\"),IF(V55=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V57=\"\",$C$127>(SUM(S55,E56)-SUM(K56))/(SUM(Q55,C56)-SUM(G56)),V56>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q55,C56)-SUM(G56))*$C$127)-((SUM(Q55,C56)-SUM(G56))*(R55)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C56>0,CONCATENATE(\"شراء \",\"\",\"\",C56,\" وثيقة\"),IF(G56>0,CONCATENATE(\"إسترداد \",\"\",\"\",G56,\" وثيقة\"),IF(V56=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V58=\"\",$C$127>(SUM(S56,E57)-SUM(K57))/(SUM(Q56,C57)-SUM(G57)),V57>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q56,C57)-SUM(G57))*$C$127)-((SUM(Q56,C57)-SUM(G57))*(R56)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C57>0,CONCATENATE(\"شراء \",\"\",\"\",C57,\" وثيقة\"),IF(G57>0,CONCATENATE(\"إسترداد \",\"\",\"\",G57,\" وثيقة\"),IF(V57=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V59=\"\",$C$127>(SUM(S57,E58)-SUM(K58))/(SUM(Q57,C58)-SUM(G58)),V58>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q57,C58)-SUM(G58))*$C$127)-((SUM(Q57,C58)-SUM(G58))*(R57)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C58>0,CONCATENATE(\"شراء \",\"\",\"\",C58,\" وثيقة\"),IF(G58>0,CONCATENATE(\"إسترداد \",\"\",\"\",G58,\" وثيقة\"),IF(V58=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V60=\"\",$C$127>(SUM(S58,E59)-SUM(K59))/(SUM(Q58,C59)-SUM(G59)),V59>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q58,C59)-SUM(G59))*$C$127)-((SUM(Q58,C59)-SUM(G59))*(R58)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C59>0,CONCATENATE(\"شراء \",\"\",\"\",C59,\" وثيقة\"),IF(G59>0,CONCATENATE(\"إسترداد \",\"\",\"\",G59,\" وثيقة\"),IF(V59=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V61=\"\",$C$127>(SUM(S59,E60)-SUM(K60))/(SUM(Q59,C60)-SUM(G60)),V60>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q59,C60)-SUM(G60))*$C$127)-((SUM(Q59,C60)-SUM(G60))*(R59)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C60>0,CONCATENATE(\"شراء \",\"\",\"\",C60,\" وثيقة\"),IF(G60>0,CONCATENATE(\"إسترداد \",\"\",\"\",G60,\" وثيقة\"),IF(V60=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V62=\"\",$C$127>(SUM(S60,E61)-SUM(K61))/(SUM(Q60,C61)-SUM(G61)),V61>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q60,C61)-SUM(G61))*$C$127)-((SUM(Q60,C61)-SUM(G61))*(R60)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C61>0,CONCATENATE(\"شراء \",\"\",\"\",C61,\" وثيقة\"),IF(G61>0,CONCATENATE(\"إسترداد \",\"\",\"\",G61,\" وثيقة\"),IF(V61=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V63=\"\",$C$127>(SUM(S61,E62)-SUM(K62))/(SUM(Q61,C62)-SUM(G62)),V62>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q61,C62)-SUM(G62))*$C$127)-((SUM(Q61,C62)-SUM(G62))*(R61)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C62>0,CONCATENATE(\"شراء \",\"\",\"\",C62,\" وثيقة\"),IF(G62>0,CONCATENATE(\"إسترداد \",\"\",\"\",G62,\" وثيقة\"),IF(V62=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V64=\"\",$C$127>(SUM(S62,E63)-SUM(K63))/(SUM(Q62,C63)-SUM(G63)),V63>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q62,C63)-SUM(G63))*$C$127)-((SUM(Q62,C63)-SUM(G63))*(R62)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C63>0,CONCATENATE(\"شراء \",\"\",\"\",C63,\" وثيقة\"),IF(G63>0,CONCATENATE(\"إسترداد \",\"\",\"\",G63,\" وثيقة\"),IF(V63=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V65=\"\",$C$127>(SUM(S63,E64)-SUM(K64))/(SUM(Q63,C64)-SUM(G64)),V64>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q63,C64)-SUM(G64))*$C$127)-((SUM(Q63,C64)-SUM(G64))*(R63)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C64>0,CONCATENATE(\"شراء \",\"\",\"\",C64,\" وثيقة\"),IF(G64>0,CONCATENATE(\"إسترداد \",\"\",\"\",G64,\" وثيقة\"),IF(V64=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V66=\"\",$C$127>(SUM(S64,E65)-SUM(K65))/(SUM(Q64,C65)-SUM(G65)),V65>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q64,C65)-SUM(G65))*$C$127)-((SUM(Q64,C65)-SUM(G65))*(R64)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C65>0,CONCATENATE(\"شراء \",\"\",\"\",C65,\" وثيقة\"),IF(G65>0,CONCATENATE(\"إسترداد \",\"\",\"\",G65,\" وثيقة\"),IF(V65=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V67=\"\",$C$127>(SUM(S65,E66)-SUM(K66))/(SUM(Q65,C66)-SUM(G66)),V66>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q65,C66)-SUM(G66))*$C$127)-((SUM(Q65,C66)-SUM(G66))*(R65)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C66>0,CONCATENATE(\"شراء \",\"\",\"\",C66,\" وثيقة\"),IF(G66>0,CONCATENATE(\"إسترداد \",\"\",\"\",G66,\" وثيقة\"),IF(V66=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V68=\"\",$C$127>(SUM(S66,E67)-SUM(K67))/(SUM(Q66,C67)-SUM(G67)),V67>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q66,C67)-SUM(G67))*$C$127)-((SUM(Q66,C67)-SUM(G67))*(R66)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C67>0,CONCATENATE(\"شراء \",\"\",\"\",C67,\" وثيقة\"),IF(G67>0,CONCATENATE(\"إسترداد \",\"\",\"\",G67,\" وثيقة\"),IF(V67=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,{"$f":"IFERROR(IF(G68>0,ROUND(G68*R67,2),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(G68>0,ROUND(I68-K68,2),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(V69=\"\",$C$127>(SUM(S67,E68)-SUM(K68))/(SUM(Q67,C68)-SUM(G68)),V68>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q67,C68)-SUM(G68))*$C$127)-((SUM(Q67,C68)-SUM(G68))*(R67)),\"\"),\"\")","v":""},null,{"$f":"IF(H68>0,ROUND(H68-R67,2),\"\")","v":""},null,{"$f":"Q67+C68-G68","v":1902},{"$f":"IF(Q68>0,ROUND(S68/Q68,100),0)","v":407.47560462670901},{"$f":"ROUND(SUM(S67,E68,M68)-SUM(K68),100)","v":775018.6},null,{"$f":"IF(C68>0,CONCATENATE(\"شراء \",\"\",\"\",C68,\" وثيقة\"),IF(G68>0,CONCATENATE(\"إسترداد \",\"\",\"\",G68,\" وثيقة\"),IF(V68=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
[{"$f":"IF(V69>0,ROW()-5,\"\")","v":""},null,null,null,{"$f":"IF(C69>0,ROUND(C69*D69,2),\"\")","v":""},null,null,null,{"$f":"IF(G69>0,ROUND(G69*H69,2),\"\")","v":""},null,"","",{"$f":"IFERROR(IF(AND(V70=\"\",$C$127>(SUM(S68,E69)-SUM(K69))/(SUM(Q68,C69)-SUM(G69)),V69>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q68,C69)-SUM(G69))*$C$127)-((SUM(Q68,C69)-SUM(G69))*(R68)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C69>0,CONCATENATE(\"شراء \",\"\",\"\",C69,\" وثيقة\"),IF(G69>0,CONCATENATE(\"إسترداد \",\"\",\"\",G69,\" وثيقة\"),IF(V69=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V71=\"\",$C$127>(SUM(S69,E70)-SUM(K70))/(SUM(Q69,C70)-SUM(G70)),V70>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q69,C70)-SUM(G70))*$C$127)-((SUM(Q69,C70)-SUM(G70))*(R69)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C70>0,CONCATENATE(\"شراء \",\"\",\"\",C70,\" وثيقة\"),IF(G70>0,CONCATENATE(\"إسترداد \",\"\",\"\",G70,\" وثيقة\"),IF(V70=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,{"$f":"IF($V70=\"\",\"\",IFERROR(IF(MONTH($V70)=MONTH($V69),$X69+1,1),1))","v":""}]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V72=\"\",$C$127>(SUM(S70,E71)-SUM(K71))/(SUM(Q70,C71)-SUM(G71)),V71>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q70,C71)-SUM(G71))*$C$127)-((SUM(Q70,C71)-SUM(G71))*(R70)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C71>0,CONCATENATE(\"شراء \",\"\",\"\",C71,\" وثيقة\"),IF(G71>0,CONCATENATE(\"إسترداد \",\"\",\"\",G71,\" وثيقة\"),IF(V71=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V73=\"\",$C$127>(SUM(S71,E72)-SUM(K72))/(SUM(Q71,C72)-SUM(G72)),V72>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q71,C72)-SUM(G72))*$C$127)-((SUM(Q71,C72)-SUM(G72))*(R71)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C72>0,CONCATENATE(\"شراء \",\"\",\"\",C72,\" وثيقة\"),IF(G72>0,CONCATENATE(\"إسترداد \",\"\",\"\",G72,\" وثيقة\"),IF(V72=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V74=\"\",$C$127>(SUM(S72,E73)-SUM(K73))/(SUM(Q72,C73)-SUM(G73)),V73>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q72,C73)-SUM(G73))*$C$127)-((SUM(Q72,C73)-SUM(G73))*(R72)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C73>0,CONCATENATE(\"شراء \",\"\",\"\",C73,\" وثيقة\"),IF(G73>0,CONCATENATE(\"إسترداد \",\"\",\"\",G73,\" وثيقة\"),IF(V73=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V75=\"\",$C$127>(SUM(S73,E74)-SUM(K74))/(SUM(Q73,C74)-SUM(G74)),V74>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q73,C74)-SUM(G74))*$C$127)-((SUM(Q73,C74)-SUM(G74))*(R73)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C74>0,CONCATENATE(\"شراء \",\"\",\"\",C74,\" وثيقة\"),IF(G74>0,CONCATENATE(\"إسترداد \",\"\",\"\",G74,\" وثيقة\"),IF(V74=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,{"$f":"IF($V74=\"\",\"\",IFERROR(IF(MONTH($V74)=MONTH($V73),$X73+1,1),1))","v":""}]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V76=\"\",$C$127>(SUM(S74,E75)-SUM(K75))/(SUM(Q74,C75)-SUM(G75)),V75>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q74,C75)-SUM(G75))*$C$127)-((SUM(Q74,C75)-SUM(G75))*(R74)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C75>0,CONCATENATE(\"شراء \",\"\",\"\",C75,\" وثيقة\"),IF(G75>0,CONCATENATE(\"إسترداد \",\"\",\"\",G75,\" وثيقة\"),IF(V75=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V77=\"\",$C$127>(SUM(S75,E76)-SUM(K76))/(SUM(Q75,C76)-SUM(G76)),V76>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q75,C76)-SUM(G76))*$C$127)-((SUM(Q75,C76)-SUM(G76))*(R75)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C76>0,CONCATENATE(\"شراء \",\"\",\"\",C76,\" وثيقة\"),IF(G76>0,CONCATENATE(\"إسترداد \",\"\",\"\",G76,\" وثيقة\"),IF(V76=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,{"$f":"IF(G77>0,ROUND(G77*H77,2),\"\")","v":""},null,"","",{"$f":"IFERROR(IF(AND(V78=\"\",$C$127>(SUM(S76,E77)-SUM(K77))/(SUM(Q76,C77)-SUM(G77)),V77>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q76,C77)-SUM(G77))*$C$127)-((SUM(Q76,C77)-SUM(G77))*(R76)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C77>0,CONCATENATE(\"شراء \",\"\",\"\",C77,\" وثيقة\"),IF(G77>0,CONCATENATE(\"إسترداد \",\"\",\"\",G77,\" وثيقة\"),IF(V77=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V79=\"\",$C$127>(SUM(S77,E78)-SUM(K78))/(SUM(Q77,C78)-SUM(G78)),V78>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q77,C78)-SUM(G78))*$C$127)-((SUM(Q77,C78)-SUM(G78))*(R77)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C78>0,CONCATENATE(\"شراء \",\"\",\"\",C78,\" وثيقة\"),IF(G78>0,CONCATENATE(\"إسترداد \",\"\",\"\",G78,\" وثيقة\"),IF(V78=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,{"$f":"IFERROR(IF(G79>0,ROUND(G79*R78,2),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(G79>0,ROUND(I79-K79,2),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(V80=\"\",$C$127>(SUM(S78,E79)-SUM(K79))/(SUM(Q78,C79)-SUM(G79)),V79>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q78,C79)-SUM(G79))*$C$127)-((SUM(Q78,C79)-SUM(G79))*(R78)),\"\"),\"\")","v":""},null,{"$f":"IF(H79>0,ROUND(H79-R78,2),\"\")","v":""},null,{"$f":"Q78+C79-G79","v":1902},{"$f":"IF(Q79>0,ROUND(S79/Q79,100),0)","v":407.47560462670901},{"$f":"ROUND(SUM(S78,E79,M79)-SUM(K79),100)","v":775018.6},null,{"$f":"IF(C79>0,CONCATENATE(\"شراء \",\"\",\"\",C79,\" وثيقة\"),IF(G79>0,CONCATENATE(\"إسترداد \",\"\",\"\",G79,\" وثيقة\"),IF(V79=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V81=\"\",$C$127>(SUM(S79,E80)-SUM(K80))/(SUM(Q79,C80)-SUM(G80)),V80>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q79,C80)-SUM(G80))*$C$127)-((SUM(Q79,C80)-SUM(G80))*(R79)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C80>0,CONCATENATE(\"شراء \",\"\",\"\",C80,\" وثيقة\"),IF(G80>0,CONCATENATE(\"إسترداد \",\"\",\"\",G80,\" وثيقة\"),IF(V80=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V82=\"\",$C$127>(SUM(S80,E81)-SUM(K81))/(SUM(Q80,C81)-SUM(G81)),V81>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q80,C81)-SUM(G81))*$C$127)-((SUM(Q80,C81)-SUM(G81))*(R80)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C81>0,CONCATENATE(\"شراء \",\"\",\"\",C81,\" وثيقة\"),IF(G81>0,CONCATENATE(\"إسترداد \",\"\",\"\",G81,\" وثيقة\"),IF(V81=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V83=\"\",$C$127>(SUM(S81,E82)-SUM(K82))/(SUM(Q81,C82)-SUM(G82)),V82>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q81,C82)-SUM(G82))*$C$127)-((SUM(Q81,C82)-SUM(G82))*(R81)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C82>0,CONCATENATE(\"شراء \",\"\",\"\",C82,\" وثيقة\"),IF(G82>0,CONCATENATE(\"إسترداد \",\"\",\"\",G82,\" وثيقة\"),IF(V82=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V84=\"\",$C$127>(SUM(S82,E83)-SUM(K83))/(SUM(Q82,C83)-SUM(G83)),V83>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q82,C83)-SUM(G83))*$C$127)-((SUM(Q82,C83)-SUM(G83))*(R82)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C83>0,CONCATENATE(\"شراء \",\"\",\"\",C83,\" وثيقة\"),IF(G83>0,CONCATENATE(\"إسترداد \",\"\",\"\",G83,\" وثيقة\"),IF(V83=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V85=\"\",$C$127>(SUM(S83,E84)-SUM(K84))/(SUM(Q83,C84)-SUM(G84)),V84>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q83,C84)-SUM(G84))*$C$127)-((SUM(Q83,C84)-SUM(G84))*(R83)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C84>0,CONCATENATE(\"شراء \",\"\",\"\",C84,\" وثيقة\"),IF(G84>0,CONCATENATE(\"إسترداد \",\"\",\"\",G84,\" وثيقة\"),IF(V84=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V86=\"\",$C$127>(SUM(S84,E85)-SUM(K85))/(SUM(Q84,C85)-SUM(G85)),V85>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q84,C85)-SUM(G85))*$C$127)-((SUM(Q84,C85)-SUM(G85))*(R84)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C85>0,CONCATENATE(\"شراء \",\"\",\"\",C85,\" وثيقة\"),IF(G85>0,CONCATENATE(\"إسترداد \",\"\",\"\",G85,\" وثيقة\"),IF(V85=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V87=\"\",$C$127>(SUM(S85,E86)-SUM(K86))/(SUM(Q85,C86)-SUM(G86)),V86>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q85,C86)-SUM(G86))*$C$127)-((SUM(Q85,C86)-SUM(G86))*(R85)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C86>0,CONCATENATE(\"شراء \",\"\",\"\",C86,\" وثيقة\"),IF(G86>0,CONCATENATE(\"إسترداد \",\"\",\"\",G86,\" وثيقة\"),IF(V86=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V88=\"\",$C$127>(SUM(S86,E87)-SUM(K87))/(SUM(Q86,C87)-SUM(G87)),V87>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q86,C87)-SUM(G87))*$C$127)-((SUM(Q86,C87)-SUM(G87))*(R86)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C87>0,CONCATENATE(\"شراء \",\"\",\"\",C87,\" وثيقة\"),IF(G87>0,CONCATENATE(\"إسترداد \",\"\",\"\",G87,\" وثيقة\"),IF(V87=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V89=\"\",$C$127>(SUM(S87,E88)-SUM(K88))/(SUM(Q87,C88)-SUM(G88)),V88>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q87,C88)-SUM(G88))*$C$127)-((SUM(Q87,C88)-SUM(G88))*(R87)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C88>0,CONCATENATE(\"شراء \",\"\",\"\",C88,\" وثيقة\"),IF(G88>0,CONCATENATE(\"إسترداد \",\"\",\"\",G88,\" وثيقة\"),IF(V88=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V90=\"\",$C$127>(SUM(S88,E89)-SUM(K89))/(SUM(Q88,C89)-SUM(G89)),V89>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q88,C89)-SUM(G89))*$C$127)-((SUM(Q88,C89)-SUM(G89))*(R88)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C89>0,CONCATENATE(\"شراء \",\"\",\"\",C89,\" وثيقة\"),IF(G89>0,CONCATENATE(\"إسترداد \",\"\",\"\",G89,\" وثيقة\"),IF(V89=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V91=\"\",$C$127>(SUM(S89,E90)-SUM(K90))/(SUM(Q89,C90)-SUM(G90)),V90>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q89,C90)-SUM(G90))*$C$127)-((SUM(Q89,C90)-SUM(G90))*(R89)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C90>0,CONCATENATE(\"شراء \",\"\",\"\",C90,\" وثيقة\"),IF(G90>0,CONCATENATE(\"إسترداد \",\"\",\"\",G90,\" وثيقة\"),IF(V90=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V92=\"\",$C$127>(SUM(S90,E91)-SUM(K91))/(SUM(Q90,C91)-SUM(G91)),V91>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q90,C91)-SUM(G91))*$C$127)-((SUM(Q90,C91)-SUM(G91))*(R90)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C91>0,CONCATENATE(\"شراء \",\"\",\"\",C91,\" وثيقة\"),IF(G91>0,CONCATENATE(\"إسترداد \",\"\",\"\",G91,\" وثيقة\"),IF(V91=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V93=\"\",$C$127>(SUM(S91,E92)-SUM(K92))/(SUM(Q91,C92)-SUM(G92)),V92>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q91,C92)-SUM(G92))*$C$127)-((SUM(Q91,C92)-SUM(G92))*(R91)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C92>0,CONCATENATE(\"شراء \",\"\",\"\",C92,\" وثيقة\"),IF(G92>0,CONCATENATE(\"إسترداد \",\"\",\"\",G92,\" وثيقة\"),IF(V92=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V94=\"\",$C$127>(SUM(S92,E93)-SUM(K93))/(SUM(Q92,C93)-SUM(G93)),V93>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q92,C93)-SUM(G93))*$C$127)-((SUM(Q92,C93)-SUM(G93))*(R92)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C93>0,CONCATENATE(\"شراء \",\"\",\"\",C93,\" وثيقة\"),IF(G93>0,CONCATENATE(\"إسترداد \",\"\",\"\",G93,\" وثيقة\"),IF(V93=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V95=\"\",$C$127>(SUM(S93,E94)-SUM(K94))/(SUM(Q93,C94)-SUM(G94)),V94>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q93,C94)-SUM(G94))*$C$127)-((SUM(Q93,C94)-SUM(G94))*(R93)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C94>0,CONCATENATE(\"شراء \",\"\",\"\",C94,\" وثيقة\"),IF(G94>0,CONCATENATE(\"إسترداد \",\"\",\"\",G94,\" وثيقة\"),IF(V94=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V96=\"\",$C$127>(SUM(S94,E95)-SUM(K95))/(SUM(Q94,C95)-SUM(G95)),V95>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q94,C95)-SUM(G95))*$C$127)-((SUM(Q94,C95)-SUM(G95))*(R94)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C95>0,CONCATENATE(\"شراء \",\"\",\"\",C95,\" وثيقة\"),IF(G95>0,CONCATENATE(\"إسترداد \",\"\",\"\",G95,\" وثيقة\"),IF(V95=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V97=\"\",$C$127>(SUM(S95,E96)-SUM(K96))/(SUM(Q95,C96)-SUM(G96)),V96>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q95,C96)-SUM(G96))*$C$127)-((SUM(Q95,C96)-SUM(G96))*(R95)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C96>0,CONCATENATE(\"شراء \",\"\",\"\",C96,\" وثيقة\"),IF(G96>0,CONCATENATE(\"إسترداد \",\"\",\"\",G96,\" وثيقة\"),IF(V96=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V98=\"\",$C$127>(SUM(S96,E97)-SUM(K97))/(SUM(Q96,C97)-SUM(G97)),V97>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q96,C97)-SUM(G97))*$C$127)-((SUM(Q96,C97)-SUM(G97))*(R96)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C97>0,CONCATENATE(\"شراء \",\"\",\"\",C97,\" وثيقة\"),IF(G97>0,CONCATENATE(\"إسترداد \",\"\",\"\",G97,\" وثيقة\"),IF(V97=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V99=\"\",$C$127>(SUM(S97,E98)-SUM(K98))/(SUM(Q97,C98)-SUM(G98)),V98>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q97,C98)-SUM(G98))*$C$127)-((SUM(Q97,C98)-SUM(G98))*(R97)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C98>0,CONCATENATE(\"شراء \",\"\",\"\",C98,\" وثيقة\"),IF(G98>0,CONCATENATE(\"إسترداد \",\"\",\"\",G98,\" وثيقة\"),IF(V98=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V100=\"\",$C$127>(SUM(S98,E99)-SUM(K99))/(SUM(Q98,C99)-SUM(G99)),V99>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q98,C99)-SUM(G99))*$C$127)-((SUM(Q98,C99)-SUM(G99))*(R98)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C99>0,CONCATENATE(\"شراء \",\"\",\"\",C99,\" وثيقة\"),IF(G99>0,CONCATENATE(\"إسترداد \",\"\",\"\",G99,\" وثيقة\"),IF(V99=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V101=\"\",$C$127>(SUM(S99,E100)-SUM(K100))/(SUM(Q99,C100)-SUM(G100)),V100>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q99,C100)-SUM(G100))*$C$127)-((SUM(Q99,C100)-SUM(G100))*(R99)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C100>0,CONCATENATE(\"شراء \",\"\",\"\",C100,\" وثيقة\"),IF(G100>0,CONCATENATE(\"إسترداد \",\"\",\"\",G100,\" وثيقة\"),IF(V100=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V102=\"\",$C$127>(SUM(S100,E101)-SUM(K101))/(SUM(Q100,C101)-SUM(G101)),V101>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q100,C101)-SUM(G101))*$C$127)-((SUM(Q100,C101)-SUM(G101))*(R100)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C101>0,CONCATENATE(\"شراء \",\"\",\"\",C101,\" وثيقة\"),IF(G101>0,CONCATENATE(\"إسترداد \",\"\",\"\",G101,\" وثيقة\"),IF(V101=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V103=\"\",$C$127>(SUM(S101,E102)-SUM(K102))/(SUM(Q101,C102)-SUM(G102)),V102>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q101,C102)-SUM(G102))*$C$127)-((SUM(Q101,C102)-SUM(G102))*(R101)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C102>0,CONCATENATE(\"شراء \",\"\",\"\",C102,\" وثيقة\"),IF(G102>0,CONCATENATE(\"إسترداد \",\"\",\"\",G102,\" وثيقة\"),IF(V102=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V104=\"\",$C$127>(SUM(S102,E103)-SUM(K103))/(SUM(Q102,C103)-SUM(G103)),V103>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q102,C103)-SUM(G103))*$C$127)-((SUM(Q102,C103)-SUM(G103))*(R102)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C103>0,CONCATENATE(\"شراء \",\"\",\"\",C103,\" وثيقة\"),IF(G103>0,CONCATENATE(\"إسترداد \",\"\",\"\",G103,\" وثيقة\"),IF(V103=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V105=\"\",$C$127>(SUM(S103,E104)-SUM(K104))/(SUM(Q103,C104)-SUM(G104)),V104>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q103,C104)-SUM(G104))*$C$127)-((SUM(Q103,C104)-SUM(G104))*(R103)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C104>0,CONCATENATE(\"شراء \",\"\",\"\",C104,\" وثيقة\"),IF(G104>0,CONCATENATE(\"إسترداد \",\"\",\"\",G104,\" وثيقة\"),IF(V104=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V106=\"\",$C$127>(SUM(S104,E105)-SUM(K105))/(SUM(Q104,C105)-SUM(G105)),V105>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q104,C105)-SUM(G105))*$C$127)-((SUM(Q104,C105)-SUM(G105))*(R104)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C105>0,CONCATENATE(\"شراء \",\"\",\"\",C105,\" وثيقة\"),IF(G105>0,CONCATENATE(\"إسترداد \",\"\",\"\",G105,\" وثيقة\"),IF(V105=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V107=\"\",$C$127>(SUM(S105,E106)-SUM(K106))/(SUM(Q105,C106)-SUM(G106)),V106>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q105,C106)-SUM(G106))*$C$127)-((SUM(Q105,C106)-SUM(G106))*(R105)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C106>0,CONCATENATE(\"شراء \",\"\",\"\",C106,\" وثيقة\"),IF(G106>0,CONCATENATE(\"إسترداد \",\"\",\"\",G106,\" وثيقة\"),IF(V106=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V108=\"\",$C$127>(SUM(S106,E107)-SUM(K107))/(SUM(Q106,C107)-SUM(G107)),V107>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q106,C107)-SUM(G107))*$C$127)-((SUM(Q106,C107)-SUM(G107))*(R106)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,{"$f":"ROUND(SUM(S106,E107,M107)-SUM(K107),2)","v":775018.6},null,{"$f":"IF(C107>0,CONCATENATE(\"شراء \",\"\",\"\",C107,\" وثيقة\"),IF(G107>0,CONCATENATE(\"إسترداد \",\"\",\"\",G107,\" وثيقة\"),IF(V107=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V109=\"\",$C$127>(SUM(S107,E108)-SUM(K108))/(SUM(Q107,C108)-SUM(G108)),V108>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q107,C108)-SUM(G108))*$C$127)-((SUM(Q107,C108)-SUM(G108))*(R107)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C108>0,CONCATENATE(\"شراء \",\"\",\"\",C108,\" وثيقة\"),IF(G108>0,CONCATENATE(\"إسترداد \",\"\",\"\",G108,\" وثيقة\"),IF(V108=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V110=\"\",$C$127>(SUM(S108,E109)-SUM(K109))/(SUM(Q108,C109)-SUM(G109)),V109>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q108,C109)-SUM(G109))*$C$127)-((SUM(Q108,C109)-SUM(G109))*(R108)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C109>0,CONCATENATE(\"شراء \",\"\",\"\",C109,\" وثيقة\"),IF(G109>0,CONCATENATE(\"إسترداد \",\"\",\"\",G109,\" وثيقة\"),IF(V109=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V111=\"\",$C$127>(SUM(S109,E110)-SUM(K110))/(SUM(Q109,C110)-SUM(G110)),V110>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q109,C110)-SUM(G110))*$C$127)-((SUM(Q109,C110)-SUM(G110))*(R109)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C110>0,CONCATENATE(\"شراء \",\"\",\"\",C110,\" وثيقة\"),IF(G110>0,CONCATENATE(\"إسترداد \",\"\",\"\",G110,\" وثيقة\"),IF(V110=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V112=\"\",$C$127>(SUM(S110,E111)-SUM(K111))/(SUM(Q110,C111)-SUM(G111)),V111>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q110,C111)-SUM(G111))*$C$127)-((SUM(Q110,C111)-SUM(G111))*(R110)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C111>0,CONCATENATE(\"شراء \",\"\",\"\",C111,\" وثيقة\"),IF(G111>0,CONCATENATE(\"إسترداد \",\"\",\"\",G111,\" وثيقة\"),IF(V111=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V113=\"\",$C$127>(SUM(S111,E112)-SUM(K112))/(SUM(Q111,C112)-SUM(G112)),V112>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q111,C112)-SUM(G112))*$C$127)-((SUM(Q111,C112)-SUM(G112))*(R111)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C112>0,CONCATENATE(\"شراء \",\"\",\"\",C112,\" وثيقة\"),IF(G112>0,CONCATENATE(\"إسترداد \",\"\",\"\",G112,\" وثيقة\"),IF(V112=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V114=\"\",$C$127>(SUM(S112,E113)-SUM(K113))/(SUM(Q112,C113)-SUM(G113)),V113>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q112,C113)-SUM(G113))*$C$127)-((SUM(Q112,C113)-SUM(G113))*(R112)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C113>0,CONCATENATE(\"شراء \",\"\",\"\",C113,\" وثيقة\"),IF(G113>0,CONCATENATE(\"إسترداد \",\"\",\"\",G113,\" وثيقة\"),IF(V113=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V115=\"\",$C$127>(SUM(S113,E114)-SUM(K114))/(SUM(Q113,C114)-SUM(G114)),V114>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q113,C114)-SUM(G114))*$C$127)-((SUM(Q113,C114)-SUM(G114))*(R113)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C114>0,CONCATENATE(\"شراء \",\"\",\"\",C114,\" وثيقة\"),IF(G114>0,CONCATENATE(\"إسترداد \",\"\",\"\",G114,\" وثيقة\"),IF(V114=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,{"$f":"IFERROR(IF(G115>0,ROUND(G115*R114,2),\"\"),\"\")","v":""},"",{"$f":"IFERROR(IF(AND(V116=\"\",$C$127>(SUM(S114,E115)-SUM(K115))/(SUM(Q114,C115)-SUM(G115)),V115>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q114,C115)-SUM(G115))*$C$127)-((SUM(Q114,C115)-SUM(G115))*(R114)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C115>0,CONCATENATE(\"شراء \",\"\",\"\",C115,\" وثيقة\"),IF(G115>0,CONCATENATE(\"إسترداد \",\"\",\"\",G115,\" وثيقة\"),IF(V115=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V117=\"\",$C$127>(SUM(S115,E116)-SUM(K116))/(SUM(Q115,C116)-SUM(G116)),V116>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q115,C116)-SUM(G116))*$C$127)-((SUM(Q115,C116)-SUM(G116))*(R115)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C116>0,CONCATENATE(\"شراء \",\"\",\"\",C116,\" وثيقة\"),IF(G116>0,CONCATENATE(\"إسترداد \",\"\",\"\",G116,\" وثيقة\"),IF(V116=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V118=\"\",$C$127>(SUM(S116,E117)-SUM(K117))/(SUM(Q116,C117)-SUM(G117)),V117>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q116,C117)-SUM(G117))*$C$127)-((SUM(Q116,C117)-SUM(G117))*(R116)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C117>0,CONCATENATE(\"شراء \",\"\",\"\",C117,\" وثيقة\"),IF(G117>0,CONCATENATE(\"إسترداد \",\"\",\"\",G117,\" وثيقة\"),IF(V117=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,{"$f":"IF(G118>0,ROUND(G118*H118,2),\"\")","v":""},null,"","",{"$f":"IFERROR(IF(AND(V119=\"\",$C$127>(SUM(S117,E118)-SUM(K118))/(SUM(Q117,C118)-SUM(G118)),V118>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q117,C118)-SUM(G118))*$C$127)-((SUM(Q117,C118)-SUM(G118))*(R117)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C118>0,CONCATENATE(\"شراء \",\"\",\"\",C118,\" وثيقة\"),IF(G118>0,CONCATENATE(\"إسترداد \",\"\",\"\",G118,\" وثيقة\"),IF(V118=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V120=\"\",$C$127>(SUM(S118,E119)-SUM(K119))/(SUM(Q118,C119)-SUM(G119)),V119>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q118,C119)-SUM(G119))*$C$127)-((SUM(Q118,C119)-SUM(G119))*(R118)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C119>0,CONCATENATE(\"شراء \",\"\",\"\",C119,\" وثيقة\"),IF(G119>0,CONCATENATE(\"إسترداد \",\"\",\"\",G119,\" وثيقة\"),IF(V119=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V121=\"\",$C$127>(SUM(S119,E120)-SUM(K120))/(SUM(Q119,C120)-SUM(G120)),V120>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q119,C120)-SUM(G120))*$C$127)-((SUM(Q119,C120)-SUM(G120))*(R119)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C120>0,CONCATENATE(\"شراء \",\"\",\"\",C120,\" وثيقة\"),IF(G120>0,CONCATENATE(\"إسترداد \",\"\",\"\",G120,\" وثيقة\"),IF(V120=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V122=\"\",$C$127>(SUM(S120,E121)-SUM(K121))/(SUM(Q120,C121)-SUM(G121)),V121>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q120,C121)-SUM(G121))*$C$127)-((SUM(Q120,C121)-SUM(G121))*(R120)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C121>0,CONCATENATE(\"شراء \",\"\",\"\",C121,\" وثيقة\"),IF(G121>0,CONCATENATE(\"إسترداد \",\"\",\"\",G121,\" وثيقة\"),IF(V121=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V123=\"\",$C$127>(SUM(S121,E122)-SUM(K122))/(SUM(Q121,C122)-SUM(G122)),V122>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q121,C122)-SUM(G122))*$C$127)-((SUM(Q121,C122)-SUM(G122))*(R121)),\"\"),\"\")","v":""},null,"",null,1902,407.47560462670901,775018.6,null,{"$f":"IF(C122>0,CONCATENATE(\"شراء \",\"\",\"\",C122,\" وثيقة\"),IF(G122>0,CONCATENATE(\"إسترداد \",\"\",\"\",G122,\" وثيقة\"),IF(V122=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
[{"$f":"IF(V123>0,ROW()-5,\"\")","v":""},null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V124=\"\",$C$127>(SUM(S122,E123)-SUM(K123))/(SUM(Q122,C123)-SUM(G123)),V123>=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0)),((SUM(Q122,C123)-SUM(G123))*$C$127)-((SUM(Q122,C123)-SUM(G123))*(R122)),\"\"),\"\")","v":""},null,"",null,{"$f":"Q122+C123-G123","v":1902},{"$f":"IF(Q123>0,ROUND(S123/Q123,100),0)","v":407.47560462670901},{"$f":"ROUND(SUM(S122,E123,M123)-SUM(K123),100)","v":775018.6},null,{"$f":"IF(C123>0,CONCATENATE(\"شراء \",\"\",\"\",C123,\" وثيقة\"),IF(G123>0,CONCATENATE(\"إسترداد \",\"\",\"\",G123,\" وثيقة\"),IF(V123=DATE(YEAR('-- QNB - Current Account --'!$E$3),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,{"$f":"IF($V123=\"\",\"\",IFERROR(IF(MONTH($V123)=MONTH($V122),$X122+1,1),1))","v":""}]
[]
[{"$f":"MAX(A5:A123)","v":37},null,{"$f":"SUM(C6:C123)","v":2732},null,{"$f":"ROUND(SUM(E6:E123),2)","v":1113148.25},null,{"$f":"SUM(G6:G123)","v":912},null,{"$f":"ROUND(SUM(I6:I123),2)","v":374092.05},null,{"$f":"ROUND(SUM(K5:K123),2)","v":371239.53},{"$f":"ROUND(SUM(L5:L123),2)","v":2852.52},{"$f":"SUM(M5:M123)","v":0},null,null,null,{"$f":"C5+C125-G125","v":1902},{"$f":"IF(Q125>0,S125/Q125,0)","v":407.47560462670873},{"$f":"ROUND(E5+E125-K125+M125,2)","v":775018.6},null,"رصيد آخر المدة",{"$f":"IF(TODAY()-V5+1>DATE(YEAR(V5),12,31)-DATE(YEAR(V5)-1,12,31),V5-1+DATE(YEAR(V5),12,31)-DATE(YEAR(V5)-1,12,31),TODAY())","v":"2021-04-30"},null,{"$f":"MAX(X5:X123)","v":16}]
[null,null,"قيمة الوثيقة",null,null,null,"التغير اليومى فى سعر الوثيقة",null,null,null,"التغير فى سعر الوثيقة",null,null,null,"متوسط الربح اليومى",null,null,null,null,null,"متوسط الربح الشهرى"]
["X",null,416.52300000000002,null,null,null,{"$f":"K127/IF(TODAY()>(DATE(YEAR($V$5),COLUMN(L1)+1,0)),DATE(YEAR($V$125),12,31)-DATE(YEAR($V$125)-1,12,31),INT(TODAY()-$V$5+1))","v":0.10619979674796695},null,null,null,{"$f":"$C$127-$R$5","v":12.743975609756035},null,null,null,{"$f":"$C$133/IF(TODAY()-$V$5+1<DATE(YEAR($V$5),12,31)-DATE(YEAR($V$5)-1,12,31),TODAY()-$V$5+1,DATE(YEAR($V$5),12,31)-DATE(YEAR($V$5)-1,12,31))","v":167.17225000000002},null,null,null,null,null,{"$f":"$C$133/(IF(TODAY()-$V$5+1<DATE(YEAR($V$5),12,31)-DATE(YEAR($V$5)-1,12,31),TODAY()-$V$5+1,DATE(YEAR($V$5),12,31)-DATE(YEAR($V$5)-1,12,31))/(365/12))","v":5084.8226041666676}]
[]
[null,null,"معدل العائد",null,null,null,"القيمة السوقية",null,null,null,"القيمة الدفترية - السوقية",null,null,null,"التغير فى سعر الوثيقة نهاية العام",null,null,null,null,null,"قيمة الوثيقة نهاية العام"]
[null,null,{"$f":"(($C$127-$R$5)/$R$5)*((DATE(YEAR($V$5),12,31)-DATE(YEAR($V$5)-1,12,31))/IF(TODAY()-$V$5+1<DATE(YEAR($V$5),12,31)-DATE(YEAR($V$5)-1,12,31),TODAY()-$V$5+1,DATE(YEAR($V$5),12,31)-DATE(YEAR($V$5)-1,12,31)))","v":9.6000345415527044E-2},null,null,null,{"$f":"$Q$125*$C$127","v":792226.74600000004},null,null,null,{"$f":"ROUND($G$130-$S$125,2)","v":17208.150000000001},null,null,null,{"$f":"$U$130-$D$5","v":38.762950203251933},null,null,null,null,null,{"$f":"IF(TODAY()>(DATE(YEAR($V$5),COLUMN(L1)+1,0)),DATE(YEAR(V5),12,31)-(DATE(YEAR($V$5),COLUMN(L1)+1,0)),DATE(YEAR(V5),12,31)-TODAY())*$G$127+C127","v":442.54195020325193}]
[]
[null,null,"إجمالى\nالربح المحقق",null,null,null,"ربح الرصيد القائم\nنهاية الشهر",null,null,null,"إجمالى الربح\nنهاية الشهر",null,null,null,"ربح الرصيد القائم\nنهاية العام",null,null,null,null,null,"إجمالى الربح\nنهاية العام"]
[null,null,{"$f":"$L$125+$M$125+$K$130","v":20060.670000000002},null,null,null,{"$f":"IF($Q$125>0,($Q$125*($K$127/($V$125-$V$5+1)))*(EOMONTH($V$125,0)-$V$125),0)","v":0},null,null,null,{"$f":"$C$133+$G$133","v":20060.670000000002},null,null,null,{"$f":"IF($Q$125>0,($Q$125*($K$127/($V$125-$V$5)))*(DATE(YEAR($V$5),COLUMN($L$1)+1,0)-$V$125),0)","v":49903.909196556422},null,null,null,null,null,{"$f":"$C$133+$O$133","v":69964.579196556428}]
[]
[null,null,null,null,{"$f":"IF(DATE(YEAR($V$5),MONTH($V$5)+1,0)>=TODAY(),TODAY(),IF(DATE(YEAR($V$5),MONTH($V$5)+1,0)<=TODAY(),DATE(YEAR($V$5),MONTH($V$5)+1,0),\"\"))","v":"2021-01-31"},null,null,{"$f":"IF(DATE(YEAR($V$5),MONTH($V$5)+2,0)<=TODAY(),DATE(YEAR($V$5),MONTH($V$5)+2,0),IF(TODAY()>DATE(YEAR($V$5),MONTH($V$5)+1,0),TODAY(),\"\"))","v":"2021-02-28"},null,null,{"$f":"IF(DATE(YEAR($V$5),MONTH($V$5)+3,0)<=TODAY(),DATE(YEAR($V$5),MONTH($V$5)+3,0),IF(TODAY()>DATE(YEAR($V$5),MONTH($V$5)+2,0),TODAY(),\"\"))","v":"2021-03-31"},null,{"$f":"IF(DATE(YEAR($V$5),MONTH($V$5)+4,0)<=TODAY(),DATE(YEAR($V$5),MONTH($V$5)+4,0),IF(TODAY()>DATE(YEAR($V$5),MONTH($V$5)+3,0),TODAY(),\"\"))","v":"2021-04-30"},null,null,null,null,{"$f":"IF(DATE(YEAR($V$5),MONTH($V$5)+5,0)<=TODAY(),DATE(YEAR($V$5),MONTH($V$5)+5,0),IF(TODAY()>DATE(YEAR($V$5),MONTH($V$5)+4,0),TODAY(),\"\"))","v":""},null,null,{"$f":"IF(DATE(YEAR($V$5),MONTH($V$5)+6,0)<=TODAY(),DATE(YEAR($V$5),MONTH($V$5)+6,0),IF(TODAY()>DATE(YEAR($V$5),MONTH($V$5)+5,0),TODAY(),\"\"))","v":""},"Total"]
[null,null,"قيمة الوثيقة",null,407.05,null,null,410.02499999999998,null,null,413.31700000000001,null,{"$f":"IF(M$135<>\"\",SUM($C$127),\"\")","v":416.52300000000002},null,null,null,null,{"$f":"IF(R$135<>\"\",SUM($C$127),\"\")","v":""},null,null,{"$f":"IF(U$135<>\"\",SUM($C$127),\"\")","v":""},{"$f":"LOOKUP(2,1/(E136:U136<>\"\"),E136:U136)","v":416.52300000000002}]
[null,null,"عدد الوثائق",null,{"$f":"(SUMPRODUCT(--($V$5:$V$123<=E135),$C$5:$C$123-$G$5:$G$123))","v":208},null,null,{"$f":"(SUMPRODUCT(--($V$5:$V$123<=H135),$C$5:$C$123-$G$5:$G$123))","v":2038},null,null,{"$f":"(SUMPRODUCT(--($V$5:$V$123<=K135),$C$5:$C$123-$G$5:$G$123))","v":2030},null,{"$f":"IF(M$135<>\"\",(SUMPRODUCT(--($V$5:$V$123<=M135),$C$5:$C$123-$G$5:$G$123)),\"\")","v":1902},null,null,null,null,{"$f":"IF(R$135<>\"\",(SUMPRODUCT(--($V$5:$V$123<=R135),$C$5:$C$123-$G$5:$G$123)),\"\")","v":""},null,null,{"$f":"IF(U$135<>\"\",(SUMPRODUCT(--($V$5:$V$123<=U135),$C$5:$C$123-$G$5:$G$123)),\"\")","v":""},{"$f":"LOOKUP(2,1/(E137:U137<>\"\"),E137:U137)","v":1902}]
[null,null,"القيمة الدفترية",null,{"$f":"LOOKUP(2,1/($V$5:$V$123<=E135)/($V$5:$V$123>=$V$5),$S$5:$S$123)","v":84364.66},null,null,{"$f":"SUMIFS($E$5:$E$123,$V$5:$V$123,\"<=\"&H135)-SUMIFS($K$5:$K$123,$V$5:$V$123,\"<=\"&H135)","v":829759.8},null,null,{"$f":"SUMIFS($E$5:$E$123,$V$5:$V$123,\"<=\"&K135)-SUMIFS($K$5:$K$123,$V$5:$V$123,\"<=\"&K135)","v":827175.47},null,{"$f":"IF(M$135<>\"\",SUMIFS($E$5:$E$123,$V$5:$V$123,\"<=\"&M135)-SUMIFS($K$5:$K$123,$V$5:$V$123,\"<=\"&M135),\"\")","v":775018.6},null,null,null,null,{"$f":"IF(R$135<>\"\",SUMIFS($E$5:$E$123,$V$5:$V$123,\"<=\"&R135)-SUMIFS($K$5:$K$123,$V$5:$V$123,\"<=\"&R135),\"\")","v":""},null,null,{"$f":"IF(U$135<>\"\",SUMIFS($E$5:$E$123,$V$5:$V$123,\"<=\"&U135)-SUMIFS($K$5:$K$123,$V$5:$V$123,\"<=\"&U135),\"\")","v":""},{"$f":"LOOKUP(2,1/(E138:U138<>\"\"),E138:U138)","v":775018.6}]
[null,null,"أرباح إسترداد",null,{"$f":"(SUMPRODUCT(--($V$5:$V$123<=E135),$L$5:$L$123))","v":17.98},null,null,{"$f":"(SUMPRODUCT(--($V$5:$V$123<=H135),$L$5:$L$123))-SUM(E139)","v":1577.56},null,null,{"$f":"(SUMPRODUCT(--($V$5:$V$123<=K135),$L$5:$L$123))-SUM(E139,H139)","v":443.90999999999963},null,{"$f":"IF(M$135<>\"\",(SUMPRODUCT(--($V$5:$V$123<=M135),$L$5:$L$123))-SUM(E139,H139,K139),\"\")","v":813.06999999999994},null,null,null,null,{"$f":"IF(R$135<>\"\",(SUMPRODUCT(--($V$5:$V$123<=R135),$L$5:$L$123))-SUM(E139,H139,K139,M139),\"\")","v":""},null,null,{"$f":"IF(U$135<>\"\",(SUMPRODUCT(--($V$5:$V$123<=U135),$L$5:$L$123))-SUM(E139,H139,K139,M139,R139),\"\")","v":""},{"$f":"ROUND(SUM(D139:U139),2)","v":2852.52}]
[null,null,"التغير فى القيمة العادلة",null,{"$f":"SUM(E137)*SUM(E136)-SUM(E138)","v":301.74000000000524},null,null,{"$f":"SUM(H137)*SUM(H136)-SUM(H138)-SUM(E140)","v":5569.4099999999016},null,null,{"$f":"SUM(K137)*SUM(K136)-SUM(K138)-SUM(E140,H140)","v":5986.8900000001304},null,{"$f":"IF(M$135<>\"\",SUM(M137)*SUM(M136)-SUM(M138)-SUM(E140,H140,K140),\"\")","v":5350.1060000000289},null,null,null,null,{"$f":"IF(R$135<>\"\",SUM(R137)*SUM(R136)-SUM(R138)-SUM(E140,H140,K140,M140),\"\")","v":""},null,null,{"$f":"IF(U$135<>\"\",SUM(U137)*SUM(U136)-SUM(U138)-SUM(E140,H140,K140,M140,R140),\"\")","v":""},{"$f":"ROUND(SUM(D140:U140),2)","v":17208.150000000001}]
[null,null,"إجمالى الأرباح",null,{"$f":"SUM(E139:E140)","v":319.72000000000526},null,null,{"$f":"SUM(H139:H140)","v":7146.9699999999011},null,null,{"$f":"SUM(K139:K140)","v":6430.8000000001302},null,{"$f":"IF(M$135<>\"\",SUM(M139:M140),\"\")","v":6163.1760000000286},null,null,null,null,{"$f":"IF(R$135<>\"\",SUM(R139:R140),\"\")","v":""},null,null,{"$f":"IF(U$135<>\"\",SUM(U139:U140),\"\")","v":""},{"$f":"ROUND(SUM(D141:U141),2)","v":20060.669999999998}]
[null,null,"متوسط الربح اليومى",null,{"$f":"IF(E135=\"\",\"\",ROUND(SUM(E141)/(DATEDIF(V5,E135,\"D\")+(1)),2))","v":10.31},null,null,{"$f":"IF(H135=\"\",\"\",ROUND(SUM(H141)/IF(DATE(YEAR($V$5),MONTH($V$5)+2,0)<=TODAY(),DAY(EOMONTH(H135,0)),DATEDIF(E135,H135,\"D\")),2))","v":255.25},null,null,{"$f":"IF(K135=\"\",\"\",ROUND(SUM(K141)/IF(DATE(YEAR($V$5),MONTH($V$5)+3,0)<=TODAY(),DAY(EOMONTH(K135,0)),DATEDIF(H135,K135,\"D\")),2))","v":207.45},null,{"$f":"IF(M135<>\"\",ROUND(SUM(M141)/IF(DATE(YEAR($V$5),MONTH($V$5)+4,0)<=TODAY(),DAY(EOMONTH(M135,0)),DATEDIF(K135,M135,\"D\")),2),\"\")","v":205.44},null,null,null,null,{"$f":"IF(R$135<>\"\",ROUND(SUM(R141)/IF(DATE(YEAR($V$5),MONTH($V$5)+5,0)<=TODAY(),DAY(EOMONTH(R135,0)),DATEDIF(M135,R135,\"D\")),2),\"\")","v":""},null,null,{"$f":"IF(U$135<>\"\",ROUND(SUM(U141)/IF(DATE(YEAR($V$5),MONTH($V$5)+6,0)<=TODAY(),DAY(EOMONTH(U135,0)),DATEDIF(R135,U135,\"D\")),2),\"\")","v":""},{"$f":"IF(V135=\"\",\"\",ROUND(SUM(V141)/(DATEDIF(V5,TODAY(),\"D\")+(1)),2))","v":167.17}]
[]
[null,null,null,null,{"$f":"IF(DATE(YEAR($V$5),MONTH($V$5)+7,0)<=TODAY(),DATE(YEAR($V$5),MONTH($V$5)+7,0),IF(TODAY()>DATE(YEAR($V$5),MONTH($V$5)+6,0),TODAY(),\"\"))","v":""},null,null,{"$f":"IF(DATE(YEAR($V$5),MONTH($V$5)+8,0)<=TODAY(),DATE(YEAR($V$5),MONTH($V$5)+8,0),IF(TODAY()>DATE(YEAR($V$5),MONTH($V$5)+7,0),TODAY(),\"\"))","v":""},null,null,{"$f":"IF(DATE(YEAR($V$5),MONTH($V$5)+9,0)<=TODAY(),DATE(YEAR($V$5),MONTH($V$5)+9,0),IF(TODAY()>DATE(YEAR($V$5),MONTH($V$5)+8,0),TODAY(),\"\"))","v":""},null,{"$f":"IF(DATE(YEAR($V$5),MONTH($V$5)+10,0)<=TODAY(),DATE(YEAR($V$5),MONTH($V$5)+10,0),IF(TODAY()>DATE(YEAR($V$5),MONTH($V$5)+9,0),TODAY(),\"\"))","v":""},null,null,null,null,{"$f":"IF(DATE(YEAR($V$5),MONTH($V$5)+11,0)<=TODAY(),DATE(YEAR($V$5),MONTH($V$5)+11,0),IF(TODAY()>DATE(YEAR($V$5),MONTH($V$5)+10,0),TODAY(),\"\"))","v":""},null,null,{"$f":"IF(DATE(YEAR($V$5),MONTH($V$5)+12,0)<=TODAY(),DATE(YEAR($V$5),MONTH($V$5)+12,0),IF(TODAY()>DATE(YEAR($V$5),MONTH($V$5)+11,0),TODAY(),\"\"))","v":""},{"$f":"IF(E$144<>\"\",Total,\"\")","v":""}]
[null,null,{"$f":"IF(E$144<>\"\",قيمة الوثيقة,\"\")","v":""},null,{"$f":"IF(E$144<>\"\",SUM($C$127),\"\")","v":""},null,null,{"$f":"IF(H$144<>\"\",SUM($C$127),\"\")","v":""},null,null,{"$f":"IF(K$144<>\"\",SUM($C$127),\"\")","v":""},null,{"$f":"IF(M$144<>\"\",SUM($C$127),\"\")","v":""},null,null,null,null,{"$f":"IF(R$144<>\"\",SUM($C$127),\"\")","v":""},null,null,{"$f":"IF(U144>TODAY(),\"\",SUM($C$127))","v":""},{"$f":"IFERROR(IF(U144>TODAY(),LOOKUP(2,1/(E145:U145<>\"\"),E145:U145),\"\"),\"\")","v":""}]
[null,null,{"$f":"IF(E$144<>\"\",عدد الوثائق,\"\")","v":""},null,{"$f":"IF(E$144<>\"\",(SUMPRODUCT(--($V$5:$V$123<=E144),$C$5:$C$123-$G$5:$G$123)),\"\")","v":""},null,null,{"$f":"IF(H$144<>\"\",(SUMPRODUCT(--($V$5:$V$123<=H144),$C$5:$C$123-$G$5:$G$123)),\"\")","v":""},null,null,{"$f":"IF(K$144<>\"\",(SUMPRODUCT(--($V$5:$V$123<=K144),$C$5:$C$123-$G$5:$G$123)),\"\")","v":""},null,{"$f":"IF(M$144<>\"\",(SUMPRODUCT(--($V$5:$V$123<=M144),$C$5:$C$123-$G$5:$G$123)),\"\")","v":""},null,null,null,null,{"$f":"IF(R144>TODAY(),\"\",(SUMPRODUCT(--($V$5:$V$123<=R144),$C$5:$C$123-$G$5:$G$123)))","v":""},null,null,{"$f":"IF(R144>TODAY(),\"\",(SUMPRODUCT(--($V$5:$V$123<=U144),$C$5:$C$123-$G$5:$G$123)))","v":""},{"$f":"IFERROR(IF(U144>TODAY(),LOOKUP(2,1/(E146:U146<>\"\"),E146:U146),\"\"),\"\")","v":""}]
[null,null,{"$f":"IF(E$144<>\"\",القيمة الدفترية,\"\")","v":""},null,{"$f":"IF(E$144<>\"\",SUMIFS($E$5:$E$123,$V$5:$V$123,\"<=\"&E144)-SUMIFS($K$5:$K$123,$V$5:$V$123,\"<=\"&E144),\"\")","v":""},null,null,{"$f":"IF(H$144<>\"\",SUMIFS($E$5:$E$123,$V$5:$V$123,\"<=\"&H144)-SUMIFS($K$5:$K$123,$V$5:$V$123,\"<=\"&H144),\"\")","v":""},null,null,{"$f":"IF(K$144<>\"\",SUMIFS($E$5:$E$123,$V$5:$V$123,\"<=\"&K144)-SUMIFS($K$5:$K$123,$V$5:$V$123,\"<=\"&K144),\"\")","v":""},null,{"$f":"IF(M$144<>\"\",SUMIFS($E$5:$E$123,$V$5:$V$123,\"<=\"&M144)-SUMIFS($K$5:$K$123,$V$5:$V$123,\"<=\"&M144),\"\")","v":""},null,null,null,null,{"$f":"IF(R144>TODAY(),\"\",SUMIFS($E$5:$E$123,$V$5:$V$123,\"<=\"&R144)-SUMIFS($K$5:$K$123,$V$5:$V$123,\"<=\"&R144))","v":""},null,null,{"$f":"IF(R144>TODAY(),\"\",SUMIFS($E$5:$E$123,$V$5:$V$123,\"<=\"&U144)-SUMIFS($K$5:$K$123,$V$5:$V$123,\"<=\"&U144))","v":""},{"$f":"IFERROR(IF(U144>TODAY(),LOOKUP(2,1/(E147:U147<>\"\"),E147:U147),\"\"),\"\")","v":""}]
[null,null,{"$f":"IF(E$144<>\"\",أرباح إسترداد,\"\")","v":""},null,{"$f":"IF(E$144<>\"\",(SUMPRODUCT(--($V$5:$V$123<=E144),$L$5:$L$123))-SUM(E139,H139,K139,M139,R139,U139),\"\")","v":""},null,null,{"$f":"IF(H$144<>\"\",(SUMPRODUCT(--($V$5:$V$123<=H144),$L$5:$L$123))-SUM(E139,H139,K139,M139,R139,U139,E148),\"\")","v":""},null,null,{"$f":"IF(K$144<>\"\",(SUMPRODUCT(--($V$5:$V$123<=K144),$L$5:$L$123))-SUM(E139,H139,K139,M139,R139,U139,E148,H148),\"\")","v":""},null,{"$f":"IF(M$144<>\"\",(SUMPRODUCT(--($V$5:$V$123<=M144),$L$5:$L$123))-SUM(E139,H139,K139,M139,R139,U139,E148,H148,K148),\"\")","v":""},null,null,null,null,{"$f":"IF(R144>TODAY(),\"\",(SUMPRODUCT(--($V$5:$V$123<=R144),$L$5:$L$123))-SUM(E139,H139,K139,M139,R139,U139,E148,H148,K148,M148))","v":""},null,null,{"$f":"IF(R144>TODAY(),\"\",(SUMPRODUCT(--($V$5:$V$123<=U144),$L$5:$L$123))-SUM(E139,H139,K139,M139,R139,U139,E148,H148,K148,M148,R148))","v":""},{"$f":"IFERROR(IF(U144>TODAY(),\"\",ROUND(SUM(V139,D148:U148),2)),\"\")","v":""}]
[null,null,{"$f":"IF(E$144<>\"\",التغير فى القيمة العادلة,\"\")","v":""},null,{"$f":"IF(E$144<>\"\",SUM(E146)*SUM(E145)-SUM(E147)-SUM(E140,H140,K140,M140,R140,U140),\"\")","v":""},null,null,{"$f":"IF(H$144<>\"\",SUM(H146)*SUM(H145)-SUM(H147)-SUM(E140,H140,K140,M140,R140,U140,E149),\"\")","v":""},null,null,{"$f":"IF(K$144<>\"\",SUM(K146)*SUM(K145)-SUM(K147)-SUM(E140,H140,K140,M140,R140,U140,E149,H149),\"\")","v":""},null,{"$f":"IF(M$144<>\"\",SUM(M146)*SUM(M145)-SUM(M147)-SUM(E140,H140,K140,M140,R140,U140,E149,H149,K149),\"\")","v":""},null,null,null,null,{"$f":"IF(R144>TODAY(),\"\",SUM(R146)*SUM(R145)-SUM(R147)-SUM(E140,H140,K140,M140,R140,U140,E149,H149,K149,M149))","v":""},null,null,{"$f":"IF(R144>TODAY(),\"\",SUM(U146)*SUM(U145)-SUM(U147)-SUM(E140,H140,K140,M140,R140,U140,E149,H149,K149,M149,R149))","v":""},{"$f":"IFERROR(IF(U144>TODAY(),\"\",ROUND(SUM(V140,D149:U149),2)),\"\")","v":""}]
[null,null,{"$f":"IF(E$144<>\"\",إجمالى الأرباح,\"\")","v":""},null,{"$f":"IF(E$144<>\"\",SUM(E148:E149),\"\")","v":""},null,null,{"$f":"IF(H$144<>\"\",SUM(H148:H149),\"\")","v":""},null,null,{"$f":"IF(K$144<>\"\",SUM(K148:L149),\"\")","v":""},null,{"$f":"IF(M$144<>\"\",SUM(M148:M149),\"\")","v":""},null,null,null,null,{"$f":"IF(R144>TODAY(),\"\",SUM(R148:R149))","v":""},null,null,{"$f":"IF(R144>TODAY(),\"\",SUM(U148:U149))","v":""},{"$f":"IFERROR(IF(U144>TODAY(),\"\",ROUND(SUM(V141,D150:U150),2)),\"\")","v":""}]
[null,null,{"$f":"IF(E$144<>\"\",متوسط الربح اليومى,\"\")","v":""},null,{"$f":"IF(E$144<>\"\",ROUND(SUM(E150)/IF(DATE(YEAR($V$5),MONTH($V$5)+7,0)<=TODAY(),DAY(EOMONTH(E144,0)),DATEDIF(U135,E144,\"D\")),2),\"\")","v":""},null,null,{"$f":"IF(H$144<>\"\",ROUND(SUM(H150)/IF(DATE(YEAR($V$5),MONTH($V$5)+8,0)<=TODAY(),DAY(EOMONTH(H144,0)),DATEDIF(E144,H144,\"D\")),2),\"\")","v":""},null,null,{"$f":"IF(K$144<>\"\",ROUND(SUM(K150)/IF(DATE(YEAR($V$5),MONTH($V$5)+9,0)<=TODAY(),DAY(EOMONTH(K144,0)),DATEDIF(H144,K144,\"D\")),2),\"\")","v":""},null,{"$f":"IF(M$144<>\"\",ROUND(SUM(M150)/IF(DATE(YEAR($V$5),MONTH($V$5)+10,0)<=TODAY(),DAY(EOMONTH(M144,0)),DATEDIF(K144,M144,\"D\")),2),\"\")","v":""},null,null,null,null,{"$f":"IF(R$144<>\"\",ROUND(SUM(R150)/IF(DATE(YEAR($V$5),MONTH($V$5)+11,0)<=TODAY(),DAY(EOMONTH(R144,0)),DATEDIF(M144,R144,\"D\")),2),\"\")","v":""},null,null,{"$f":"IF(U$144<>\"\",ROUND(SUM(U150)/IF(DATE(YEAR($V$5),MONTH($V$5)+12,0)<=TODAY(),DAY(EOMONTH(U144,0)),DATEDIF(R144,U144,\"D\")),2),\"\")","v":""},{"$f":"IFERROR(IF(U144>TODAY(),\"\",ROUND(SUM(V150)/(DATEDIF(V5,TODAY(),\"D\")+(1)),2)),\"\")","v":""}]
[]
[null,null,"Last\nDay of\nNext Month",null,"Current\nMonth\n# of Days","Last\nDay of\nCurrent\nMonth",null,"Last\nThursday","15th\nDay of\nCurrent Month",null,"TODAY",null,"Year\n#\nof Days",null,"Year\nDays\nRemaining",null,null,"Year\nDays\nPassed","Working\nDays",null,{"$f":"IF(U154>1,\"Weeks\",\"Week\")","v":"Weeks"},"%\nof\nYear"]
[null,null,{"$f":"DATE(YEAR($V$125),MONTH($V$125)+2,0)","v":"2021-05-31"},null,{"$f":"DAY(DATE(YEAR($V$125),MONTH($V$125)+1,1)-1)","v":30},{"$f":"DATE(YEAR($V$125),MONTH($V$125)+1,0)","v":"2021-04-30"},null,{"$f":"SUM(IF(WEEKDAY(EOMONTH($V$125,0)-{0;1;2;3;4;5;6})=5,EOMONTH($V$125,0)-{0;1;2;3;4;5;6}),0)","v":"2021-04-29"},{"$f":"TODAY()-DAY(TODAY())+1+(14)","v":"2021-04-15"},null,{"$f":"IF(TODAY()>(DATE(YEAR('-- QNB - Current Account --'!E3),COLUMN(L1)+1,0)),(DATE(YEAR('-- QNB - Current Account --'!E3),COLUMN(L1)+1,0)),TODAY())","v":"2021-04-30"},{"$f":"IF(TODAY()>(DATE(YEAR('-- QNB - Current Account --'!E3),COLUMN(L1)+1,0)),(DATE(YEAR('-- QNB - Current Account --'!E3),COLUMN(L1)+1,0)),TODAY())","v":"2021-04-30"},{"$f":"DATE(YEAR($V$125),12,31)-DATE(YEAR($V$125)-1,12,31)","v":365},null,{"$f":"IF(TODAY()>(DATE(YEAR($V$5),COLUMN(L1)+1,0)),DATE(YEAR(V5),12,31)-(DATE(YEAR($V$5),COLUMN(L1)+1,0)),DATE(YEAR(V5),12,31)-TODAY())","v":245},null,null,{"$f":"IF(TODAY()>(DATE(YEAR($V$5),COLUMN(L1)+1,0)),DATE(YEAR($V$125),12,31)-DATE(YEAR($V$125)-1,12,31),INT(TODAY()-V5+1))","v":120},{"$f":"IF(TODAY()>(DATE(YEAR($V$5),COLUMN(L1)+1,0)),NETWORKDAYS(V5,DATE(YEAR($V$5),COLUMN(L1)+1,0)),NETWORKDAYS(V5,TODAY()))","v":86},null,{"$f":"IF(TODAY()<(DATE(YEAR($V$5),COLUMN(L1)+1,0)),INT(TODAY()-V5)/7,52)","v":17},{"$f":"IF(TODAY()>(DATE(YEAR($V$5),COLUMN(L1)+1,0)),DATE(YEAR($V$125),12,31)-DATE(YEAR($V$125)-1,12,31),INT(TODAY()-V5+1))/$M$154","v":0.32876712328767121}]