{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["-- Trading Investments --"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"-- Trading Investments --","index":0,"n_rows":212,"n_cols":24,"rows_kept":212,"cut":false,"hidden":false,"merged":[[211,2,211,3],[211,5,211,6],[211,14,211,16],[210,2,210,3],[210,5,210,6],[210,14,210,16],[205,6,205,7],[205,14,205,17],[204,10,204,11],[208,2,208,3],[202,6,202,7],[202,10,202,11],[205,10,205,11],[207,14,207,17],[204,2,204,3],[205,2,205,3],[208,14,208,17],[207,2,207,3],[207,5,207,7],[208,5,208,7],[204,6,204,7],[207,20,207,21],[207,10,207,11],[208,10,208,11],[201,14,201,17],[202,14,202,17],[208,20,208,22],[201,20,201,21],[202,20,202,21],[204,20,204,21],[205,20,205,21],[204,14,204,17],[201,2,201,3],[202,2,202,3],[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],[201,6,201,7],[201,10,201,11],[1,21,2,21],[1,23,2,23]]}
[]
["م",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,80,319.17899999999997,{"$f":"IF(C5>0,ROUND(C5*D5,2),\"\")","v":25534.32},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$203>(SUM(S4,E5)-SUM(K5))/(SUM(Q4,C5)-SUM(G5)),V5>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q4,C5)-SUM(G5))*$C$203)-((SUM(Q4,C5)-SUM(G5))*(R4)),\"\"),\"\")","v":""},null,{"$f":"IF(H5>0,ROUND(H5-R4,2),\"\")","v":""},null,{"$f":"C5-G5","v":80},{"$f":"IF(Q5>0,ROUND(S5/Q5,100),0)","v":319.17899999999997},{"$f":"ROUND(SUM(E5,M5)-SUM(K5),100)","v":25534.32},null,"رصيد أول المدة","2019-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,1,319.54500000000002,{"$f":"IF(G6>0,ROUND(G6*H6,2),\"\")","v":319.55},null,{"$f":"IFERROR(IF(G6>0,ROUND(G6*R5,2),\"\"),\"\")","v":319.18},{"$f":"IFERROR(IF(G6>0,ROUND(I6-K6,2),\"\"),\"\")","v":0.37},"",null,{"$f":"IF(H6>0,ROUND(H6-R5,2),\"\")","v":0.37},null,{"$f":"Q5+C6-G6","v":79},{"$f":"IF(Q6>0,ROUND(S6/Q6,100),0)","v":319.17898734177197},{"$f":"ROUND(SUM(S5,E6,M6)-SUM(K6),100)","v":25215.14},null,{"$f":"IF(C6>0,CONCATENATE(\"شراء \",\"\",\"\",C6,\" وثيقة\"),IF(G6>0,CONCATENATE(\"إسترداد \",\"\",\"\",G6,\" وثيقة\"),IF(V6=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 1 وثيقة"},"2019-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,66,319.91899999999998,{"$f":"IF(G7>0,ROUND(G7*H7,2),\"\")","v":21114.65},null,{"$f":"IFERROR(IF(G7>0,ROUND(G7*R6,2),\"\"),\"\")","v":21065.81},{"$f":"IFERROR(IF(G7>0,ROUND(I7-K7,2),\"\"),\"\")","v":48.84},"",null,{"$f":"IF(H7>0,ROUND(H7-R6,2),\"\")","v":0.74},null,{"$f":"Q6+C7-G7","v":13},{"$f":"IF(Q7>0,ROUND(S7/Q7,100),0)","v":319.17923076923103},4149.33,null,"إسترداد 66 وثيقة","2019-01-06",null,2]
[3,null,null,null,"",null,13,320.16899999999998,4162.2,null,4149.33,12.87,"",null,0.99,null,0,0,0,null,"إسترداد 13 وثيقة","2019-01-08",null,3]
[4,null,62,320.79599999999999,19889.349999999999,null,null,null,"",null,"","","",null,"",null,62,320.79596774193499,19889.349999999999,null,"شراء 62 وثيقة","2019-01-13",null,4]
[5,null,null,null,"",null,2,321.04700000000003,{"$f":"IF(G10>0,ROUND(G10*H10,2),\"\")","v":642.09},null,641.59,0.5,"",null,0.25,null,60,320.79599999999999,19247.759999999998,null,"إسترداد 2 وثيقة","2019-01-15",null,5]
[6,null,null,null,"",null,1,321.173,321.17,null,320.8,0.37,"",null,{"$f":"IF(H11>0,ROUND(H11-R10,2),\"\")","v":0.38},null,{"$f":"Q10+C11-G11","v":59},320.79593220339001,18926.96,null,"إسترداد 1 وثيقة","2019-01-16",null,6]
[7,null,null,null,"",null,4,321.29899999999998,1285.2,null,{"$f":"IFERROR(IF(G12>0,ROUND(G12*R11,2),\"\"),\"\")","v":1283.18},2.02,"",null,{"$f":"IF(H12>0,ROUND(H12-R11,2),\"\")","v":0.5},null,{"$f":"Q11+C12-G12","v":55},{"$f":"IF(Q12>0,ROUND(S12/Q12,100),0)","v":320.79599999999999},17643.78,null,"إسترداد 4 وثيقة","2019-01-17",null,7]
[8,null,null,null,"",null,2,321.67599999999999,643.35,null,641.59,1.76,"",null,{"$f":"IF(H13>0,ROUND(H13-R12,2),\"\")","v":0.88},null,{"$f":"Q12+C13-G13","v":53},{"$f":"IF(Q13>0,ROUND(S13/Q13,100),0)","v":320.79603773584898},17002.189999999999,null,"إسترداد 2 وثيقة","2019-01-20",null,8]
[9,null,null,null,"",null,2,321.928,643.86,null,641.59,2.27,"",null,1.1299999999999999,null,51,320.79607843137302,16360.6,null,"إسترداد 2 وثيقة","2019-01-22",null,9]
[10,null,42,322.05399999999997,13526.27,null,null,null,"",null,"","","",null,"",null,93,321.36419354838699,29886.87,null,"شراء 42 وثيقة","2019-01-23",null,10]
[11,null,null,null,"",null,44,322.55700000000002,14192.51,null,14140.02,52.49,"",null,1.19,null,49,321.36428571428598,15746.85,null,"إسترداد 44 وثيقة","2019-01-27",null,11]
[12,null,64,322.935,20667.84,null,null,null,"",null,"","","",null,"",null,113,322.25389380530999,36414.69,null,"شراء 64 وثيقة","2019-01-30",null,12]
[13,null,54,323.06099999999998,17445.29,null,null,null,"",null,"","","",null,"",null,167,322.51485029940102,53859.98,null,"شراء 54 وثيقة","2019-01-31",null,13]
[14,null,null,null,"",null,11,323.44099999999997,3557.85,null,3547.66,10.19,"",null,0.93,null,156,322.51487179487202,50312.32,null,"إسترداد 11 وثيقة","2019-02-03",null,1]
[15,null,null,null,"",null,3,323.56700000000001,970.7,null,967.54,{"$f":"IFERROR(IF(G20>0,ROUND(I20-K20,2),\"\"),\"\")","v":3.16},"",null,1.05,null,153,322.51490196078402,49344.78,null,"إسترداد 3 وثيقة","2019-02-04",null,2]
[16,null,null,null,"",null,5,324.33199999999999,1621.66,null,1612.57,9.09,"",null,1.82,null,148,322.51493243243198,47732.21,null,"إسترداد 5 وثيقة","2019-02-10",null,3]
[17,null,null,null,"",null,1,324.58499999999998,324.58999999999997,null,322.51,2.08,"",null,2.0699999999999998,null,147,322.514965986395,47409.7,null,"إسترداد 1 وثيقة","2019-02-12",null,4]
[18,null,null,null,"",null,1,324.83999999999997,324.83999999999997,null,322.51,2.33,"",null,2.33,null,146,322.51499999999999,47087.19,null,"إسترداد 1 وثيقة","2019-02-14",null,5]
[19,null,null,null,"",null,11,325.22199999999998,3577.44,null,3547.67,29.77,"",null,2.71,null,135,322.51496296296301,43539.519999999997,null,"إسترداد 11 وثيقة","2019-02-17",null,6]
[20,null,null,null,"",null,1,325.34899999999999,325.35000000000002,null,322.51,2.84,"",null,2.83,null,134,322.51499999999999,43217.01,null,"إسترداد 1 وثيقة","2019-02-18",null,7]
[21,null,36,325.72899999999998,11726.24,null,null,null,"",null,"","","",null,"",null,170,323.195588235294,54943.25,null,"شراء 36 وثيقة","2019-02-21",null,8]
[22,null,null,null,"",null,43,326.11099999999999,14022.77,null,13897.41,125.36,"",null,2.92,null,127,323.195590551181,41045.839999999997,null,"إسترداد 43 وثيقة","2019-02-24",null,9]
[23,null,87,326.524,28407.59,null,null,null,"",null,"","","",null,"",null,214,324.548738317757,69453.429999999993,null,"شراء 87 وثيقة","2019-02-27",null,10]
[24,null,null,null,"",null,213,326.65899999999999,69578.37,null,69128.88,449.49,"",null,2.11,null,1,324.54999999998802,324.54999999998802,null,"إسترداد 213 وثيقة","2019-02-28",null,11]
[25,null,22,327.04000000000002,7194.88,null,null,null,"",null,"","","",null,"",null,23,326.93173913043398,7519.4299999999903,null,"شراء 22 وثيقة","2019-03-03",null,1]
[26,null,27,327.29199999999997,8836.8799999999992,null,null,null,"",null,"","","",null,"",null,50,327.12619999999998,16356.31,null,"شراء 27 وثيقة","2019-03-05",null,2]
[27,null,null,null,"",null,3,327.54500000000002,982.64,null,981.38,1.26,"",null,0.42,null,47,327.126170212766,15374.93,null,"إسترداد 3 وثيقة","2019-03-07",null,3]
[28,null,null,null,"",null,17,327.923,5574.69,null,5561.14,13.55,"",null,0.8,null,30,327.12633333333298,9813.7900000000009,null,"إسترداد 17 وثيقة","2019-03-10",null,4]
[29,null,null,null,"",null,20,328.05,6561,null,6542.53,18.47,"",null,0.92,null,10,327.12599999999998,3271.26,null,"إسترداد 20 وثيقة","2019-03-11",null,5]
[30,null,null,null,"",null,1,328.17599999999999,328.18,null,327.13,1.05,"",null,1.05,null,9,327.12555555555599,2944.13,null,"إسترداد 1 وثيقة","2019-03-12",null,6]
[31,null,null,null,"",null,3,328.42899999999997,985.29,null,981.38,3.91,"",null,1.3,null,6,327.125,1962.75,null,"إسترداد 3 وثيقة","2019-03-14",null,7]
[32,null,null,null,"",null,4,328.81,1315.24,null,1308.5,6.74,{"$f":"IFERROR(IF(AND(V38=\"\",$C$203>(SUM(S36,E37)-SUM(K37))/(SUM(Q36,C37)-SUM(G37)),V37>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q36,C37)-SUM(G37))*$C$203)-((SUM(Q36,C37)-SUM(G37))*(R36)),\"\"),\"\")","v":""},null,1.69,null,2,327.125,654.25,null,"إسترداد 4 وثيقة","2019-03-17",null,8]
[33,null,null,null,"",null,1,329.06200000000001,329.06,null,327.13,1.93,"",null,1.94,null,1,327.12,327.12,null,{"$f":"IF(C38>0,CONCATENATE(\"شراء \",\"\",\"\",C38,\" وثيقة\"),IF(G38>0,CONCATENATE(\"إسترداد \",\"\",\"\",G38,\" وثيقة\"),IF(V38=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 1 وثيقة"},"2019-03-19",null,9]
[34,null,null,null,"",null,1,329.18799999999999,329.19,null,327.12,2.0699999999999998,"",null,2.0699999999999998,null,0,0,0,null,"إسترداد 1 وثيقة","2019-03-20",null,10]
[35,null,1,329.315,329.32,null,null,null,"",null,"","","",null,"",null,1,329.32,329.32,null,"شراء 1 وثيقة","2019-03-21",null,11]
[36,null,null,null,"",null,1,329.315,329.32,null,329.32,0,"",null,0,null,0,0,0,null,"إسترداد 1 وثيقة","2019-03-21",null,12]
[37,null,63,330.20299999999997,20802.79,null,null,null,"",null,"","","",null,"",null,63,330.203015873016,20802.79,null,"شراء 63 وثيقة","2019-03-28",null,13]
[38,null,52,330.58199999999999,17190.259999999998,null,null,null,"",null,"","","",null,"",null,115,330.37434782608699,37993.050000000003,null,"شراء 52 وثيقة","2019-03-31",null,14]
[39,null,null,null,"",null,16,330.70800000000003,5291.33,null,5285.99,5.34,"",null,0.33,null,99,330.37434343434302,32707.06,null,"إسترداد 16 وثيقة","2019-04-01",null,1]
[40,null,null,null,"",null,2,330.83800000000002,661.68,null,660.75,0.93,"",null,0.46,null,97,330.374329896907,32046.31,null,"إسترداد 2 وثيقة","2019-04-02",null,2]
[41,null,null,null,"",null,1,330.96300000000002,330.96,null,{"$f":"IFERROR(IF(G46>0,ROUND(G46*R45,2),\"\"),\"\")","v":330.37},0.59,"",null,0.59,null,96,330.37437499999999,31715.94,null,"إسترداد 1 وثيقة","2019-04-03",null,3]
[42,null,null,null,"",null,{"$f":"80+2","v":82},331.08800000000002,27149.22,null,27090.7,58.52,"",null,0.71,null,14,330.37428571428597,4625.24,null,"إسترداد 82 وثيقة","2019-04-04",null,4]
[43,null,1,331.46300000000002,331.46,null,null,null,"",null,"","","",null,"",null,15,330.446666666667,4956.7,null,"شراء 1 وثيقة","2019-04-07",null,5]
[44,null,null,null,"",null,1,331.71300000000002,331.71,null,330.45,1.26,"",null,1.27,null,14,330.44642857142901,4626.25,null,"إسترداد 1 وثيقة","2019-04-09",null,6]
[45,null,33,331.83699999999999,10950.62,null,null,null,"",null,"","","",null,"",null,47,331.42276595744698,15576.87,null,"شراء 33 وثيقة","2019-04-10",null,7]
[46,null,null,null,"",null,6,331.96199999999999,1991.77,null,1988.54,3.23,"",null,0.54,null,41,331.422682926829,13588.33,null,"إسترداد 6 وثيقة","2019-04-11",null,8]
[47,null,null,null,"",null,2,332.33800000000002,664.68,null,662.85,1.83,"",null,0.92,null,39,331.42256410256402,12925.48,null,"إسترداد 2 وثيقة","2019-04-14",null,9]
[48,null,null,null,"",null,38,332.714,12643.13,null,12594.06,49.07,"",null,1.29,null,1,331.42,331.42,null,"إسترداد 38 وثيقة","2019-04-16",null,10]
[49,null,null,null,"",null,1,332.83800000000002,332.84,null,331.42,1.42,"",null,1.42,null,0,0,0,null,"إسترداد 1 وثيقة","2019-04-18",null,11]
[50,null,61,334.33,20394.13,null,null,null,{"$f":"IF(G55>0,ROUND(G55*H55,2),\"\")","v":""},null,"","","",null,"",null,61,334.33,20394.13,null,"شراء 61 وثيقة","2019-04-30",null,12]
[51,null,null,null,"",null,12,334.57900000000001,4014.95,null,4011.96,2.99,"",null,0.25,null,49,334.33,16382.17,null,"إسترداد 12 وثيقة","2019-05-02",null,1]
[52,null,17,334.95299999999997,5694.2,null,null,null,"",null,"","","",null,"",null,66,334.49045454545501,22076.37,null,"شراء 17 وثيقة","2019-05-05",null,2]
[53,null,34,335.077,11392.62,null,null,null,"",null,"","","",null,"",null,100,334.68990000000002,33468.99,null,"شراء 34 وثيقة","2019-05-06",null,3]
[54,null,null,null,"",null,2,335.83100000000002,671.66,null,669.38,2.2799999999999998,"",null,1.1399999999999999,null,98,334.68989795918401,32799.61,null,"إسترداد 2 وثيقة","2019-05-12",null,4]
[55,null,null,null,"",null,4,335.95499999999998,1343.82,null,1338.76,5.0599999999999996,"",null,1.27,null,94,334.68989361702103,31460.85,null,"إسترداد 4 وثيقة","2019-05-13",null,5]
[56,null,null,null,"",null,1,336.20299999999997,336.2,null,334.69,1.51,"",null,1.51,null,93,334.68989247311799,31126.16,null,"إسترداد 1 وثيقة","2019-05-15",null,6]
[57,null,null,null,"",null,15,336.32900000000001,5044.9399999999996,null,5020.3500000000004,24.59,"",null,1.64,null,78,334.68987179487198,26105.81,null,"إسترداد 15 وثيقة","2019-05-16",null,7]
[58,null,12,336.702,4040.42,null,null,null,"",null,"","","",null,"",null,90,334.95811111111101,30146.23,null,"شراء 12 وثيقة","2019-05-19",null,8]
[59,null,null,null,"",null,1,337.07400000000001,337.07,null,334.96,2.11,"",null,2.12,null,89,334.95808988764003,29811.27,null,"إسترداد 1 وثيقة","2019-05-22",null,9]
[60,null,null,null,"",null,19,337.20400000000001,6406.88,null,6364.2,42.68,"",null,2.25,null,70,334.958142857143,23447.07,null,"إسترداد 19 وثيقة","2019-05-23",null,10]
[61,null,null,null,"",null,12,337.57600000000002,4050.91,null,4019.5,31.41,"",null,2.62,null,58,334.95810344827601,19427.57,null,"إسترداد 12 وثيقة","2019-05-26",null,11]
[62,null,null,null,"",null,57,337.7,19248.900000000001,null,19092.61,156.29,"",null,2.74,null,1,334.95999999999901,334.95999999999901,null,"إسترداد 57 وثيقة","2019-05-27",null,12]
[63,null,9,341.42200000000003,3072.8,null,null,null,"",null,"","","",null,"",null,10,340.77600000000001,3407.76,null,"شراء 9 وثيقة","2019-06-26",null,1]
[64,null,11,341.54500000000002,3757,null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V70=\"\",$C$203>(SUM(S68,E69)-SUM(K69))/(SUM(Q68,C69)-SUM(G69)),V69>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q68,C69)-SUM(G69))*$C$203)-((SUM(Q68,C69)-SUM(G69))*(R68)),\"\"),\"\")","v":""},null,"",null,21,341.17904761904799,7164.76,null,"شراء 11 وثيقة","2019-06-27",null,2]
[65,null,38,342.15899999999999,13002.04,null,null,null,"",null,"","","",null,"",null,59,341.81016949152502,{"$f":"ROUND(SUM(S69,E70,M70)-SUM(K70),100)","v":20166.8},null,{"$f":"IF(C70>0,CONCATENATE(\"شراء \",\"\",\"\",C70,\" وثيقة\"),IF(G70>0,CONCATENATE(\"إسترداد \",\"\",\"\",G70,\" وثيقة\"),IF(V70=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"شراء 38 وثيقة"},"2019-07-02",null,{"$f":"IF($V70=\"\",\"\",IFERROR(IF(MONTH($V70)=MONTH($V69),$X69+1,1),1))","v":1}]
[{"$f":"IF(V71>0,ROW()-5,\"\")","v":66},null,null,null,"",null,36,342.40499999999997,12326.58,null,12305.17,21.41,"",null,0.59,null,23,341.81,7861.63,null,"إسترداد 36 وثيقة","2019-07-04",null,2]
[{"$f":"IF(V72>0,ROW()-5,\"\")","v":67},null,null,null,{"$f":"IF(C72>0,ROUND(C72*D72,2),\"\")","v":""},null,2,342.774,{"$f":"IF(G72>0,ROUND(G72*H72,2),\"\")","v":685.55},null,{"$f":"IFERROR(IF(G72>0,ROUND(G72*R71,2),\"\"),\"\")","v":683.62},{"$f":"IFERROR(IF(G72>0,ROUND(I72-K72,2),\"\"),\"\")","v":1.93},"",null,{"$f":"IF(H72>0,ROUND(H72-R71,2),\"\")","v":0.96},null,{"$f":"Q71+C72-G72","v":21},{"$f":"IF(Q72>0,ROUND(S72/Q72,100),0)","v":341.81},{"$f":"ROUND(SUM(S71,E72,M72)-SUM(K72),100)","v":7178.01},null,"إسترداد 2 وثيقة","2019-07-07",null,3]
[68,null,null,null,"",null,2,342.89699999999999,685.79,null,683.62,2.17,"",null,1.0900000000000001,null,19,341.81,6494.39,null,"إسترداد 2 وثيقة","2019-07-08",null,4]
[{"$f":"IF(V74>0,ROW()-5,\"\")","v":69},null,null,null,{"$f":"IF(C74>0,ROUND(C74*D74,2),\"\")","v":""},null,19,343.02,{"$f":"IF(G74>0,ROUND(G74*H74,2),\"\")","v":6517.38},null,{"$f":"IFERROR(IF(G74>0,ROUND(G74*R73,2),\"\"),\"\")","v":6494.39},{"$f":"IFERROR(IF(G74>0,ROUND(I74-K74,2),\"\"),\"\")","v":22.99},"",null,{"$f":"IF(H74>0,ROUND(H74-R73,2),\"\")","v":1.21},null,{"$f":"Q73+C74-G74","v":0},{"$f":"IF(Q74>0,ROUND(S74/Q74,100),0)","v":0},{"$f":"ROUND(SUM(S73,E74,M74)-SUM(K74),100)","v":0},null,"إسترداد 19 وثيقة","2019-07-09",null,5]
[70,null,49,345.72699999999998,16940.62,null,null,null,"",null,"","","",null,"",null,49,345.72693877551001,16940.62,null,"شراء 49 وثيقة","2019-07-31",null,6]
[71,null,null,null,"",null,7,345.85,2420.9499999999998,null,2420.09,0.86,"",null,0.12,null,42,345.72690476190502,14520.53,null,"إسترداد 7 وثيقة","2019-08-01",null,1]
[72,null,null,null,"",null,13,346.22199999999998,4500.8900000000003,null,4494.45,6.44,"",null,0.5,null,29,345.726896551724,10026.08,null,"إسترداد 13 وثيقة","2019-08-04",null,2]
[73,null,25,346.46800000000002,8661.7000000000007,null,null,null,"",null,"","","",null,"",null,54,346.07,18687.78,null,"شراء 25 وثيقة","2019-08-06",null,3]
[74,null,2,346.59199999999998,693.18,null,null,null,"",null,"","","",null,"",null,56,346.08857142857102,19380.96,null,"شراء 2 وثيقة","2019-08-07",null,4]
[75,null,6,346.71499999999997,2080.29,null,null,null,"",null,"","","",null,"",null,62,346.14919354838702,21461.25,null,"شراء 6 وثيقة","2019-08-08",null,5]
[76,null,null,null,"",null,1,347.95,347.95,null,346.15,1.8,"",null,1.8,null,61,346.14918032786898,21115.1,null,"إسترداد 1 وثيقة","2019-08-18",null,6]
[77,null,null,null,"",null,2,348.44400000000002,696.89,null,692.3,4.59,"",null,2.29,null,59,346.14915254237297,20422.8,null,"إسترداد 2 وثيقة","2019-08-22",null,7]
[78,null,19,351.65,6681.35,null,null,null,"",null,"","","",null,"",null,78,347.48910256410301,27104.15,null,"شراء 19 وثيقة","2019-09-17",null,1]
[79,null,43,351.77300000000002,15126.24,null,null,null,"",null,"","","",null,"",null,121,349.01148760330602,42230.39,null,"شراء 43 وثيقة","2019-09-18",null,2]
[80,null,null,null,"",null,9,351.89600000000002,3167.06,null,3141.1,25.96,"",null,2.88,null,112,349.01151785714302,39089.29,null,"إسترداد 9 وثيقة","2019-09-19",null,3]
[81,null,null,null,"",null,2,352.26299999999998,704.53,null,698.02,6.51,"",null,3.25,null,110,349.011545454545,38391.269999999997,null,"إسترداد 2 وثيقة","2019-09-22",null,4]
[82,null,2,352.50799999999998,705.02,null,null,null,"",null,"","","",null,"",null,112,349.07401785714302,39096.29,null,"شراء 2 وثيقة","2019-09-24",null,5]
[83,null,null,null,"",null,6,352.75299999999999,2116.52,null,2094.44,22.08,"",null,3.68,null,106,349.07405660377401,37001.85,null,"إسترداد 6 وثيقة","2019-09-26",null,6]
[84,null,59,353.12,20834.080000000002,null,null,null,"",null,"","","",null,"",null,165,350.52078787878798,57835.93,null,"شراء 59 وثيقة","2019-09-29",null,7]
[85,null,54,353.24099999999999,19075.009999999998,null,null,null,"",null,"","","",null,"",null,219,351.19150684931498,76910.94,null,"شراء 54 وثيقة","2019-09-30",null,8]
[86,null,null,null,"",null,14,353.36799999999999,4947.1499999999996,null,4916.68,30.47,"",null,2.1800000000000002,null,205,351.19151219512202,71994.259999999995,null,"إسترداد 14 وثيقة","2019-10-01",null,1]
[87,null,null,null,"",null,19,353.61900000000003,6718.76,null,6672.64,46.12,"",null,2.4300000000000002,null,186,351.19150537634403,65321.62,null,"إسترداد 19 وثيقة","2019-10-03",null,2]
[88,null,null,null,"",null,1,354.21899999999999,354.22,null,351.19,3.03,"",null,3.03,null,185,351.191513513514,64970.43,null,"إسترداد 1 وثيقة","2019-10-08",null,3]
[89,null,null,null,"",null,90,354.21899999999999,31879.71,null,31607.24,272.47000000000003,"",null,3.03,null,95,351.19147368421102,33363.19,null,"إسترداد 90 وثيقة","2019-10-08",null,4]
[90,null,null,null,"",null,1,354.34,354.34,null,351.19,3.15,"",null,3.15,null,94,351.191489361702,33012,null,"إسترداد 1 وثيقة","2019-10-09",null,5]
[91,null,null,null,"",null,3,354.46100000000001,1063.3800000000001,null,1053.57,9.81,"",null,3.27,null,91,351.19153846153802,31958.43,null,"إسترداد 3 وثيقة","2019-10-10",null,6]
[92,null,null,null,"",null,1,355.06200000000001,355.06,null,351.19,3.87,"",null,3.87,null,90,351.19155555555602,31607.24,null,"إسترداد 1 وثيقة","2019-10-15",null,7]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V102=\"\",$C$203>(SUM(S100,E101)-SUM(K101))/(SUM(Q100,C101)-SUM(G101)),V101>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q100,C101)-SUM(G101))*$C$203)-((SUM(Q100,C101)-SUM(G101))*(R100)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C102>0,CONCATENATE(\"شراء \",\"\",\"\",C102,\" وثيقة\"),IF(G102>0,CONCATENATE(\"إسترداد \",\"\",\"\",G102,\" وثيقة\"),IF(V102=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,{"$f":"IF(G121>0,ROUND(G121*H121,2),\"\")","v":""},null,{"$f":"IFERROR(IF(G121>0,ROUND(G121*R120,2),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(G121>0,ROUND(I121-K121,2),\"\"),\"\")","v":""},"",null,{"$f":"IF(H121>0,ROUND(H121-R120,2),\"\")","v":""},null,{"$f":"Q120+C121-G121","v":90},{"$f":"IF(Q121>0,ROUND(S121/Q121,100),0)","v":351.19155555555602},{"$f":"ROUND(SUM(S120,E121,M121)-SUM(K121),100)","v":31607.24},null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V134=\"\",$C$203>(SUM(S132,E133)-SUM(K133))/(SUM(Q132,C133)-SUM(G133)),V133>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q132,C133)-SUM(G133))*$C$203)-((SUM(Q132,C133)-SUM(G133))*(R132)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C134>0,CONCATENATE(\"شراء \",\"\",\"\",C134,\" وثيقة\"),IF(G134>0,CONCATENATE(\"إسترداد \",\"\",\"\",G134,\" وثيقة\"),IF(V134=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,{"$f":"IF($V134=\"\",\"\",IFERROR(IF(MONTH($V134)=MONTH($V133),$X133+1,1),1))","v":""}]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,{"$f":"IF(G152>0,ROUND(G152*H152,2),\"\")","v":""},null,{"$f":"IFERROR(IF(G152>0,ROUND(G152*R151,2),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(G152>0,ROUND(I152-K152,2),\"\"),\"\")","v":""},"",null,{"$f":"IF(H152>0,ROUND(H152-R151,2),\"\")","v":""},null,{"$f":"Q151+C152-G152","v":90},{"$f":"IF(Q152>0,ROUND(S152/Q152,100),0)","v":351.19155555555602},{"$f":"ROUND(SUM(S151,E152,M152)-SUM(K152),100)","v":31607.24},null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V166=\"\",$C$203>(SUM(S164,E165)-SUM(K165))/(SUM(Q164,C165)-SUM(G165)),V165>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q164,C165)-SUM(G165))*$C$203)-((SUM(Q164,C165)-SUM(G165))*(R164)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C166>0,CONCATENATE(\"شراء \",\"\",\"\",C166,\" وثيقة\"),IF(G166>0,CONCATENATE(\"إسترداد \",\"\",\"\",G166,\" وثيقة\"),IF(V166=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,{"$f":"IFERROR(IF(G190>0,ROUND(G190*R189,2),\"\"),\"\")","v":""},"","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,{"$f":"IF(G193>0,ROUND(G193*H193,2),\"\")","v":""},null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,90,351.19155555555602,31607.24,null,"",null,null,""]
["",null,null,null,"",null,null,null,"",null,"","","",null,"",null,{"$f":"Q197+C198-G198","v":90},{"$f":"IF(Q198>0,ROUND(S198/Q198,100),0)","v":351.19155555555602},31607.24,null,{"$f":"IF(C198>0,CONCATENATE(\"شراء \",\"\",\"\",C198,\" وثيقة\"),IF(G198>0,CONCATENATE(\"إسترداد \",\"\",\"\",G198,\" وثيقة\"),IF(V198=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,{"$f":"IF($V198=\"\",\"\",IFERROR(IF(MONTH($V198)=MONTH($V197),$X197+1,1),1))","v":""}]
[]
[{"$f":"MAX(A5:A198)","v":92},null,{"$f":"SUM(C6:C198)","v":985},null,{"$f":"SUM(E6:E198)","v":329449.49},null,{"$f":"SUM(G6:G198)","v":975},null,{"$f":"SUM(I6:I198)","v":325058.12000000011},null,{"$f":"SUM(K5:K198)","v":323376.57000000012},{"$f":"SUM(L5:L198)","v":1681.5499999999997},{"$f":"SUM(M5:M198)","v":0},null,null,null,{"$f":"C5+C200-G200","v":90},{"$f":"IF(Q200>0,S200/Q200,0)","v":351.19155555555557},{"$f":"ROUND(E5+E200-K200+M200,2)","v":31607.24},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":"2019-10-15"},null,{"$f":"MAX(X5:X198)","v":14}]
[]
[null,null,"قيمة الوثيقة",null,null,null,"التغير اليومى فى سعر الوثيقة",null,null,null,"التغير فى سعر الوثيقة",null,null,null,"متوسط الربح اليومى",null,null,null,null,null,"متوسط الربح الشهرى"]
["X",null,355.06200000000001,null,null,null,{"$f":"K203/IF(TODAY()>(DATE(YEAR($V$5),COLUMN(L1)+1,0)),DATE(YEAR($V$200),12,31)-DATE(YEAR($V$200)-1,12,31),INT(TODAY()-$V$5+1))","v":0.12459375000000013},null,null,null,{"$f":"$C$203-$R$5","v":35.883000000000038},null,null,null,{"$f":"$C$209/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":7.0482291666666654},null,null,null,null,null,{"$f":"$C$209/(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))/30.4166666)","v":214.38363668289577}]
[]
[null,null,"معدل العائد",null,null,null,"القيمة السوقية",null,null,null,"القيمة الدفترية - السوقية",null,null,null,"التغير فى سعر الوثيقة نهاية العام",null,null,null,null,null,"قيمة الوثيقة نهاية العام"]
[null,null,{"$f":"(($C$203-$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":0.14248029710601279},null,null,null,{"$f":"$Q$200*$C$203","v":31955.58},null,null,null,{"$f":"ROUND($G$206-$S$200,2)","v":348.34},null,null,null,{"$f":"$U$206-$D$5","v":45.476718750000032},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$203+C203","v":364.65571875000001}]
[]
[null,null,"إجمالى\nالربح المحقق",null,null,"ربح الرصيد القائم\nنهاية الشهر",null,null,null,null,"إجمالى الربح\nنهاية الشهر",null,null,null,"ربح الرصيد القائم\nنهاية العام",null,null,null,null,null,"إجمالى الربح\nنهاية العام"]
[null,null,{"$f":"$L$200+$M$200+$K$206","v":2029.8899999999996},null,null,{"$f":"IF($Q$200>0,($Q$200*($K$203/($V$200-$V$5)))*(EOMONTH($V$200,0)-$V$200),0)","v":180.04013937282249},null,null,null,null,{"$f":"$C$209+$F$209","v":2209.9301393728219},null,null,null,{"$f":"IF($Q$200>0,($Q$200*($K$203/($V$200-$V$5)))*(DATE(YEAR($V$5),COLUMN($L$1)+1,0)-$V$200),0)","v":866.44317073170828},null,null,null,null,null,{"$f":"$C$209+$O$209","v":2896.3331707317079}]
[]
[null,null,"Last\nDay of\nNext\nMonth",null,"Current\nMonth\n#\nOf Days","Last\nDay of\nCurrent\nMonth",null,"Last\nThursday","15th\nDay of\nCurrent\nMonth",null,null,"Year\n#\nof Days",null,null,"Days\nRemaining",null,null,"Days\nPassed","Working\nDays",null,{"$f":"IF(U212>1,\"Weeks\",\"Week\")","v":"Weeks"},"%\nof\nYear"]
[null,null,{"$f":"DATE(YEAR($V$200),MONTH($V$200)+2,0)","v":"2019-11-30"},null,{"$f":"DAY(DATE(YEAR($V$200),MONTH($V$200)+1,1)-1)","v":31},{"$f":"DATE(YEAR($V$200),MONTH($V$200)+1,0)","v":"2019-10-31"},null,{"$f":"SUM(IF(WEEKDAY(EOMONTH($V$200,0)-{0;1;2;3;4;5;6})=5,EOMONTH($V$200,0)-{0;1;2;3;4;5;6}),0)","v":"2019-10-31"},{"$f":"TODAY()-DAY(TODAY())+1+(14)","v":"2019-10-15"},null,null,{"$f":"DATE(YEAR($V$200),12,31)-DATE(YEAR($V$200)-1,12,31)","v":365},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())","v":77},null,null,{"$f":"IF(TODAY()>(DATE(YEAR($V$5),COLUMN(L1)+1,0)),DATE(YEAR($V$200),12,31)-DATE(YEAR($V$200)-1,12,31),INT(TODAY()-V5+1))","v":288},{"$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":206},null,{"$f":"IF(TODAY()<(DATE(YEAR($V$5),COLUMN(L1)+1,0)),INT(TODAY()-V5)/7,52)","v":41},{"$f":"IF(TODAY()>(DATE(YEAR($V$5),COLUMN(L1)+1,0)),DATE(YEAR($V$200),12,31)-DATE(YEAR($V$200)-1,12,31),INT(TODAY()-V5+1))/$L$212","v":0.78904109589041094}]