{"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},{"$f":"IFERROR(IF(AND(V7=\"\",$C$203>(SUM(S5,E6)-SUM(K6))/(SUM(Q5,C6)-SUM(G6)),V6>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q5,C6)-SUM(G6))*$C$203)-((SUM(Q5,C6)-SUM(G6))*(R5)),\"\"),\"\")","v":""},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},{"$f":"IFERROR(IF(AND(V8=\"\",$C$203>(SUM(S6,E7)-SUM(K7))/(SUM(Q6,C7)-SUM(G7)),V7>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q6,C7)-SUM(G7))*$C$203)-((SUM(Q6,C7)-SUM(G7))*(R6)),\"\"),\"\")","v":""},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,{"$f":"IF(C7>0,CONCATENATE(\"شراء \",\"\",\"\",C7,\" وثيقة\"),IF(G7>0,CONCATENATE(\"إسترداد \",\"\",\"\",G7,\" وثيقة\"),IF(V7=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 66 وثيقة"},"2019-01-06",null,2]
[3,null,null,null,"",null,13,320.16899999999998,4162.2,null,4149.33,12.87,{"$f":"IFERROR(IF(AND(V9=\"\",$C$203>(SUM(S7,E8)-SUM(K8))/(SUM(Q7,C8)-SUM(G8)),V8>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q7,C8)-SUM(G8))*$C$203)-((SUM(Q7,C8)-SUM(G8))*(R7)),\"\"),\"\")","v":""},null,0.99,null,0,0,0,null,{"$f":"IF(C8>0,CONCATENATE(\"شراء \",\"\",\"\",C8,\" وثيقة\"),IF(G8>0,CONCATENATE(\"إسترداد \",\"\",\"\",G8,\" وثيقة\"),IF(V8=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 13 وثيقة"},"2019-01-08",null,3]
[4,null,62,320.79599999999999,19889.349999999999,null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V10=\"\",$C$203>(SUM(S8,E9)-SUM(K9))/(SUM(Q8,C9)-SUM(G9)),V9>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q8,C9)-SUM(G9))*$C$203)-((SUM(Q8,C9)-SUM(G9))*(R8)),\"\"),\"\")","v":""},null,"",null,62,320.79596774193499,19889.349999999999,null,{"$f":"IF(C9>0,CONCATENATE(\"شراء \",\"\",\"\",C9,\" وثيقة\"),IF(G9>0,CONCATENATE(\"إسترداد \",\"\",\"\",G9,\" وثيقة\"),IF(V9=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"شراء 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,{"$f":"IFERROR(IF(AND(V11=\"\",$C$203>(SUM(S9,E10)-SUM(K10))/(SUM(Q9,C10)-SUM(G10)),V10>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q9,C10)-SUM(G10))*$C$203)-((SUM(Q9,C10)-SUM(G10))*(R9)),\"\"),\"\")","v":""},null,0.25,null,60,320.79599999999999,19247.759999999998,null,{"$f":"IF(C10>0,CONCATENATE(\"شراء \",\"\",\"\",C10,\" وثيقة\"),IF(G10>0,CONCATENATE(\"إسترداد \",\"\",\"\",G10,\" وثيقة\"),IF(V10=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 2 وثيقة"},"2019-01-15",null,5]
[6,null,null,null,"",null,1,321.173,321.17,null,320.8,0.37,{"$f":"IFERROR(IF(AND(V12=\"\",$C$203>(SUM(S10,E11)-SUM(K11))/(SUM(Q10,C11)-SUM(G11)),V11>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q10,C11)-SUM(G11))*$C$203)-((SUM(Q10,C11)-SUM(G11))*(R10)),\"\"),\"\")","v":""},null,{"$f":"IF(H11>0,ROUND(H11-R10,2),\"\")","v":0.38},null,{"$f":"Q10+C11-G11","v":59},320.79593220339001,18926.96,null,{"$f":"IF(C11>0,CONCATENATE(\"شراء \",\"\",\"\",C11,\" وثيقة\"),IF(G11>0,CONCATENATE(\"إسترداد \",\"\",\"\",G11,\" وثيقة\"),IF(V11=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 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,{"$f":"IFERROR(IF(AND(V13=\"\",$C$203>(SUM(S11,E12)-SUM(K12))/(SUM(Q11,C12)-SUM(G12)),V12>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q11,C12)-SUM(G12))*$C$203)-((SUM(Q11,C12)-SUM(G12))*(R11)),\"\"),\"\")","v":""},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,{"$f":"IF(C12>0,CONCATENATE(\"شراء \",\"\",\"\",C12,\" وثيقة\"),IF(G12>0,CONCATENATE(\"إسترداد \",\"\",\"\",G12,\" وثيقة\"),IF(V12=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 4 وثيقة"},"2019-01-17",null,7]
[8,null,null,null,"",null,2,321.67599999999999,643.35,null,641.59,1.76,{"$f":"IFERROR(IF(AND(V14=\"\",$C$203>(SUM(S12,E13)-SUM(K13))/(SUM(Q12,C13)-SUM(G13)),V13>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q12,C13)-SUM(G13))*$C$203)-((SUM(Q12,C13)-SUM(G13))*(R12)),\"\"),\"\")","v":""},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,{"$f":"IF(C13>0,CONCATENATE(\"شراء \",\"\",\"\",C13,\" وثيقة\"),IF(G13>0,CONCATENATE(\"إسترداد \",\"\",\"\",G13,\" وثيقة\"),IF(V13=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 2 وثيقة"},"2019-01-20",null,8]
[9,null,null,null,"",null,2,321.928,643.86,null,641.59,2.27,{"$f":"IFERROR(IF(AND(V15=\"\",$C$203>(SUM(S13,E14)-SUM(K14))/(SUM(Q13,C14)-SUM(G14)),V14>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q13,C14)-SUM(G14))*$C$203)-((SUM(Q13,C14)-SUM(G14))*(R13)),\"\"),\"\")","v":""},null,1.1299999999999999,null,51,320.79607843137302,16360.6,null,{"$f":"IF(C14>0,CONCATENATE(\"شراء \",\"\",\"\",C14,\" وثيقة\"),IF(G14>0,CONCATENATE(\"إسترداد \",\"\",\"\",G14,\" وثيقة\"),IF(V14=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 2 وثيقة"},"2019-01-22",null,9]
[10,null,42,322.05399999999997,13526.27,null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V16=\"\",$C$203>(SUM(S14,E15)-SUM(K15))/(SUM(Q14,C15)-SUM(G15)),V15>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q14,C15)-SUM(G15))*$C$203)-((SUM(Q14,C15)-SUM(G15))*(R14)),\"\"),\"\")","v":""},null,"",null,93,321.36419354838699,29886.87,null,{"$f":"IF(C15>0,CONCATENATE(\"شراء \",\"\",\"\",C15,\" وثيقة\"),IF(G15>0,CONCATENATE(\"إسترداد \",\"\",\"\",G15,\" وثيقة\"),IF(V15=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"شراء 42 وثيقة"},"2019-01-23",null,10]
[11,null,null,null,"",null,44,322.55700000000002,14192.51,null,14140.02,52.49,{"$f":"IFERROR(IF(AND(V17=\"\",$C$203>(SUM(S15,E16)-SUM(K16))/(SUM(Q15,C16)-SUM(G16)),V16>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q15,C16)-SUM(G16))*$C$203)-((SUM(Q15,C16)-SUM(G16))*(R15)),\"\"),\"\")","v":""},null,1.19,null,49,321.36428571428598,15746.85,null,{"$f":"IF(C16>0,CONCATENATE(\"شراء \",\"\",\"\",C16,\" وثيقة\"),IF(G16>0,CONCATENATE(\"إسترداد \",\"\",\"\",G16,\" وثيقة\"),IF(V16=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 44 وثيقة"},"2019-01-27",null,11]
[12,null,64,322.935,20667.84,null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V18=\"\",$C$203>(SUM(S16,E17)-SUM(K17))/(SUM(Q16,C17)-SUM(G17)),V17>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q16,C17)-SUM(G17))*$C$203)-((SUM(Q16,C17)-SUM(G17))*(R16)),\"\"),\"\")","v":""},null,"",null,113,322.25389380530999,36414.69,null,{"$f":"IF(C17>0,CONCATENATE(\"شراء \",\"\",\"\",C17,\" وثيقة\"),IF(G17>0,CONCATENATE(\"إسترداد \",\"\",\"\",G17,\" وثيقة\"),IF(V17=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"شراء 64 وثيقة"},"2019-01-30",null,12]
[13,null,54,323.06099999999998,17445.29,null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V19=\"\",$C$203>(SUM(S17,E18)-SUM(K18))/(SUM(Q17,C18)-SUM(G18)),V18>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q17,C18)-SUM(G18))*$C$203)-((SUM(Q17,C18)-SUM(G18))*(R17)),\"\"),\"\")","v":""},null,"",null,167,322.51485029940102,53859.98,null,{"$f":"IF(C18>0,CONCATENATE(\"شراء \",\"\",\"\",C18,\" وثيقة\"),IF(G18>0,CONCATENATE(\"إسترداد \",\"\",\"\",G18,\" وثيقة\"),IF(V18=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"شراء 54 وثيقة"},"2019-01-31",null,13]
[14,null,null,null,"",null,11,323.44099999999997,3557.85,null,3547.66,10.19,{"$f":"IFERROR(IF(AND(V20=\"\",$C$203>(SUM(S18,E19)-SUM(K19))/(SUM(Q18,C19)-SUM(G19)),V19>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q18,C19)-SUM(G19))*$C$203)-((SUM(Q18,C19)-SUM(G19))*(R18)),\"\"),\"\")","v":""},null,0.93,null,156,322.51487179487202,50312.32,null,{"$f":"IF(C19>0,CONCATENATE(\"شراء \",\"\",\"\",C19,\" وثيقة\"),IF(G19>0,CONCATENATE(\"إسترداد \",\"\",\"\",G19,\" وثيقة\"),IF(V19=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 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},{"$f":"IFERROR(IF(AND(V21=\"\",$C$203>(SUM(S19,E20)-SUM(K20))/(SUM(Q19,C20)-SUM(G20)),V20>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q19,C20)-SUM(G20))*$C$203)-((SUM(Q19,C20)-SUM(G20))*(R19)),\"\"),\"\")","v":""},null,1.05,null,153,322.51490196078402,49344.78,null,{"$f":"IF(C20>0,CONCATENATE(\"شراء \",\"\",\"\",C20,\" وثيقة\"),IF(G20>0,CONCATENATE(\"إسترداد \",\"\",\"\",G20,\" وثيقة\"),IF(V20=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 3 وثيقة"},"2019-02-04",null,2]
[16,null,null,null,"",null,5,324.33199999999999,1621.66,null,1612.57,9.09,{"$f":"IFERROR(IF(AND(V22=\"\",$C$203>(SUM(S20,E21)-SUM(K21))/(SUM(Q20,C21)-SUM(G21)),V21>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q20,C21)-SUM(G21))*$C$203)-((SUM(Q20,C21)-SUM(G21))*(R20)),\"\"),\"\")","v":""},null,1.82,null,148,322.51493243243198,47732.21,null,{"$f":"IF(C21>0,CONCATENATE(\"شراء \",\"\",\"\",C21,\" وثيقة\"),IF(G21>0,CONCATENATE(\"إسترداد \",\"\",\"\",G21,\" وثيقة\"),IF(V21=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 5 وثيقة"},"2019-02-10",null,3]
[17,null,null,null,"",null,1,324.58499999999998,324.58999999999997,null,322.51,2.08,{"$f":"IFERROR(IF(AND(V23=\"\",$C$203>(SUM(S21,E22)-SUM(K22))/(SUM(Q21,C22)-SUM(G22)),V22>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q21,C22)-SUM(G22))*$C$203)-((SUM(Q21,C22)-SUM(G22))*(R21)),\"\"),\"\")","v":""},null,2.0699999999999998,null,147,322.514965986395,47409.7,null,{"$f":"IF(C22>0,CONCATENATE(\"شراء \",\"\",\"\",C22,\" وثيقة\"),IF(G22>0,CONCATENATE(\"إسترداد \",\"\",\"\",G22,\" وثيقة\"),IF(V22=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 1 وثيقة"},"2019-02-12",null,4]
[18,null,null,null,"",null,1,324.83999999999997,324.83999999999997,null,322.51,2.33,{"$f":"IFERROR(IF(AND(V24=\"\",$C$203>(SUM(S22,E23)-SUM(K23))/(SUM(Q22,C23)-SUM(G23)),V23>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q22,C23)-SUM(G23))*$C$203)-((SUM(Q22,C23)-SUM(G23))*(R22)),\"\"),\"\")","v":""},null,2.33,null,146,322.51499999999999,47087.19,null,{"$f":"IF(C23>0,CONCATENATE(\"شراء \",\"\",\"\",C23,\" وثيقة\"),IF(G23>0,CONCATENATE(\"إسترداد \",\"\",\"\",G23,\" وثيقة\"),IF(V23=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 1 وثيقة"},"2019-02-14",null,5]
[19,null,null,null,"",null,11,325.22199999999998,3577.44,null,3547.67,29.77,{"$f":"IFERROR(IF(AND(V25=\"\",$C$203>(SUM(S23,E24)-SUM(K24))/(SUM(Q23,C24)-SUM(G24)),V24>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q23,C24)-SUM(G24))*$C$203)-((SUM(Q23,C24)-SUM(G24))*(R23)),\"\"),\"\")","v":""},null,2.71,null,135,322.51496296296301,43539.519999999997,null,{"$f":"IF(C24>0,CONCATENATE(\"شراء \",\"\",\"\",C24,\" وثيقة\"),IF(G24>0,CONCATENATE(\"إسترداد \",\"\",\"\",G24,\" وثيقة\"),IF(V24=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 11 وثيقة"},"2019-02-17",null,6]
[20,null,null,null,"",null,1,325.34899999999999,325.35000000000002,null,322.51,2.84,{"$f":"IFERROR(IF(AND(V26=\"\",$C$203>(SUM(S24,E25)-SUM(K25))/(SUM(Q24,C25)-SUM(G25)),V25>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q24,C25)-SUM(G25))*$C$203)-((SUM(Q24,C25)-SUM(G25))*(R24)),\"\"),\"\")","v":""},null,2.83,null,134,322.51499999999999,43217.01,null,{"$f":"IF(C25>0,CONCATENATE(\"شراء \",\"\",\"\",C25,\" وثيقة\"),IF(G25>0,CONCATENATE(\"إسترداد \",\"\",\"\",G25,\" وثيقة\"),IF(V25=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 1 وثيقة"},"2019-02-18",null,7]
[21,null,36,325.72899999999998,11726.24,null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V27=\"\",$C$203>(SUM(S25,E26)-SUM(K26))/(SUM(Q25,C26)-SUM(G26)),V26>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q25,C26)-SUM(G26))*$C$203)-((SUM(Q25,C26)-SUM(G26))*(R25)),\"\"),\"\")","v":""},null,"",null,170,323.195588235294,54943.25,null,{"$f":"IF(C26>0,CONCATENATE(\"شراء \",\"\",\"\",C26,\" وثيقة\"),IF(G26>0,CONCATENATE(\"إسترداد \",\"\",\"\",G26,\" وثيقة\"),IF(V26=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"شراء 36 وثيقة"},"2019-02-21",null,8]
[22,null,null,null,"",null,43,326.11099999999999,14022.77,null,13897.41,125.36,{"$f":"IFERROR(IF(AND(V28=\"\",$C$203>(SUM(S26,E27)-SUM(K27))/(SUM(Q26,C27)-SUM(G27)),V27>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q26,C27)-SUM(G27))*$C$203)-((SUM(Q26,C27)-SUM(G27))*(R26)),\"\"),\"\")","v":""},null,2.92,null,127,323.195590551181,41045.839999999997,null,{"$f":"IF(C27>0,CONCATENATE(\"شراء \",\"\",\"\",C27,\" وثيقة\"),IF(G27>0,CONCATENATE(\"إسترداد \",\"\",\"\",G27,\" وثيقة\"),IF(V27=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 43 وثيقة"},"2019-02-24",null,9]
[23,null,87,326.524,28407.59,null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V29=\"\",$C$203>(SUM(S27,E28)-SUM(K28))/(SUM(Q27,C28)-SUM(G28)),V28>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q27,C28)-SUM(G28))*$C$203)-((SUM(Q27,C28)-SUM(G28))*(R27)),\"\"),\"\")","v":""},null,"",null,214,324.548738317757,69453.429999999993,null,{"$f":"IF(C28>0,CONCATENATE(\"شراء \",\"\",\"\",C28,\" وثيقة\"),IF(G28>0,CONCATENATE(\"إسترداد \",\"\",\"\",G28,\" وثيقة\"),IF(V28=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"شراء 87 وثيقة"},"2019-02-27",null,10]
[24,null,null,null,"",null,213,326.65899999999999,69578.37,null,69128.88,449.49,{"$f":"IFERROR(IF(AND(V30=\"\",$C$203>(SUM(S28,E29)-SUM(K29))/(SUM(Q28,C29)-SUM(G29)),V29>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q28,C29)-SUM(G29))*$C$203)-((SUM(Q28,C29)-SUM(G29))*(R28)),\"\"),\"\")","v":""},null,2.11,null,1,324.54999999998802,324.54999999998802,null,{"$f":"IF(C29>0,CONCATENATE(\"شراء \",\"\",\"\",C29,\" وثيقة\"),IF(G29>0,CONCATENATE(\"إسترداد \",\"\",\"\",G29,\" وثيقة\"),IF(V29=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 213 وثيقة"},"2019-02-28",null,11]
[25,null,22,327.04000000000002,7194.88,null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V31=\"\",$C$203>(SUM(S29,E30)-SUM(K30))/(SUM(Q29,C30)-SUM(G30)),V30>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q29,C30)-SUM(G30))*$C$203)-((SUM(Q29,C30)-SUM(G30))*(R29)),\"\"),\"\")","v":""},null,"",null,23,326.93173913043398,7519.4299999999903,null,{"$f":"IF(C30>0,CONCATENATE(\"شراء \",\"\",\"\",C30,\" وثيقة\"),IF(G30>0,CONCATENATE(\"إسترداد \",\"\",\"\",G30,\" وثيقة\"),IF(V30=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"شراء 22 وثيقة"},"2019-03-03",null,1]
[26,null,27,327.29199999999997,8836.8799999999992,null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V32=\"\",$C$203>(SUM(S30,E31)-SUM(K31))/(SUM(Q30,C31)-SUM(G31)),V31>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q30,C31)-SUM(G31))*$C$203)-((SUM(Q30,C31)-SUM(G31))*(R30)),\"\"),\"\")","v":""},null,"",null,50,327.12619999999998,16356.31,null,{"$f":"IF(C31>0,CONCATENATE(\"شراء \",\"\",\"\",C31,\" وثيقة\"),IF(G31>0,CONCATENATE(\"إسترداد \",\"\",\"\",G31,\" وثيقة\"),IF(V31=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"شراء 27 وثيقة"},"2019-03-05",null,2]
[27,null,null,null,"",null,3,327.54500000000002,982.64,null,981.38,1.26,{"$f":"IFERROR(IF(AND(V33=\"\",$C$203>(SUM(S31,E32)-SUM(K32))/(SUM(Q31,C32)-SUM(G32)),V32>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q31,C32)-SUM(G32))*$C$203)-((SUM(Q31,C32)-SUM(G32))*(R31)),\"\"),\"\")","v":""},null,0.42,null,47,327.126170212766,15374.93,null,{"$f":"IF(C32>0,CONCATENATE(\"شراء \",\"\",\"\",C32,\" وثيقة\"),IF(G32>0,CONCATENATE(\"إسترداد \",\"\",\"\",G32,\" وثيقة\"),IF(V32=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 3 وثيقة"},"2019-03-07",null,3]
[28,null,null,null,"",null,17,327.923,5574.69,null,5561.14,13.55,{"$f":"IFERROR(IF(AND(V34=\"\",$C$203>(SUM(S32,E33)-SUM(K33))/(SUM(Q32,C33)-SUM(G33)),V33>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q32,C33)-SUM(G33))*$C$203)-((SUM(Q32,C33)-SUM(G33))*(R32)),\"\"),\"\")","v":""},null,0.8,null,30,327.12633333333298,9813.7900000000009,null,{"$f":"IF(C33>0,CONCATENATE(\"شراء \",\"\",\"\",C33,\" وثيقة\"),IF(G33>0,CONCATENATE(\"إسترداد \",\"\",\"\",G33,\" وثيقة\"),IF(V33=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 17 وثيقة"},"2019-03-10",null,4]
[29,null,null,null,"",null,20,328.05,6561,null,6542.53,18.47,{"$f":"IFERROR(IF(AND(V35=\"\",$C$203>(SUM(S33,E34)-SUM(K34))/(SUM(Q33,C34)-SUM(G34)),V34>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q33,C34)-SUM(G34))*$C$203)-((SUM(Q33,C34)-SUM(G34))*(R33)),\"\"),\"\")","v":""},null,0.92,null,10,327.12599999999998,3271.26,null,{"$f":"IF(C34>0,CONCATENATE(\"شراء \",\"\",\"\",C34,\" وثيقة\"),IF(G34>0,CONCATENATE(\"إسترداد \",\"\",\"\",G34,\" وثيقة\"),IF(V34=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 20 وثيقة"},"2019-03-11",null,5]
[30,null,null,null,"",null,1,328.17599999999999,328.18,null,327.13,1.05,{"$f":"IFERROR(IF(AND(V36=\"\",$C$203>(SUM(S34,E35)-SUM(K35))/(SUM(Q34,C35)-SUM(G35)),V35>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q34,C35)-SUM(G35))*$C$203)-((SUM(Q34,C35)-SUM(G35))*(R34)),\"\"),\"\")","v":""},null,1.05,null,9,327.12555555555599,2944.13,null,{"$f":"IF(C35>0,CONCATENATE(\"شراء \",\"\",\"\",C35,\" وثيقة\"),IF(G35>0,CONCATENATE(\"إسترداد \",\"\",\"\",G35,\" وثيقة\"),IF(V35=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 1 وثيقة"},"2019-03-12",null,6]
[31,null,null,null,"",null,3,328.42899999999997,985.29,null,981.38,3.91,{"$f":"IFERROR(IF(AND(V37=\"\",$C$203>(SUM(S35,E36)-SUM(K36))/(SUM(Q35,C36)-SUM(G36)),V36>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q35,C36)-SUM(G36))*$C$203)-((SUM(Q35,C36)-SUM(G36))*(R35)),\"\"),\"\")","v":""},null,1.3,null,6,327.125,1962.75,null,{"$f":"IF(C36>0,CONCATENATE(\"شراء \",\"\",\"\",C36,\" وثيقة\"),IF(G36>0,CONCATENATE(\"إسترداد \",\"\",\"\",G36,\" وثيقة\"),IF(V36=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 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,{"$f":"IF(C37>0,CONCATENATE(\"شراء \",\"\",\"\",C37,\" وثيقة\"),IF(G37>0,CONCATENATE(\"إسترداد \",\"\",\"\",G37,\" وثيقة\"),IF(V37=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 4 وثيقة"},"2019-03-17",null,8]
[33,null,null,null,"",null,1,329.06200000000001,329.06,null,327.13,1.93,{"$f":"IFERROR(IF(AND(V39=\"\",$C$203>(SUM(S37,E38)-SUM(K38))/(SUM(Q37,C38)-SUM(G38)),V38>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q37,C38)-SUM(G38))*$C$203)-((SUM(Q37,C38)-SUM(G38))*(R37)),\"\"),\"\")","v":""},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,{"$f":"IFERROR(IF(AND(V40=\"\",$C$203>(SUM(S38,E39)-SUM(K39))/(SUM(Q38,C39)-SUM(G39)),V39>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q38,C39)-SUM(G39))*$C$203)-((SUM(Q38,C39)-SUM(G39))*(R38)),\"\"),\"\")","v":""},null,2.0699999999999998,null,0,0,0,null,{"$f":"IF(C39>0,CONCATENATE(\"شراء \",\"\",\"\",C39,\" وثيقة\"),IF(G39>0,CONCATENATE(\"إسترداد \",\"\",\"\",G39,\" وثيقة\"),IF(V39=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 1 وثيقة"},"2019-03-20",null,10]
[35,null,1,329.315,329.32,null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V41=\"\",$C$203>(SUM(S39,E40)-SUM(K40))/(SUM(Q39,C40)-SUM(G40)),V40>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q39,C40)-SUM(G40))*$C$203)-((SUM(Q39,C40)-SUM(G40))*(R39)),\"\"),\"\")","v":""},null,"",null,1,329.32,329.32,null,{"$f":"IF(C40>0,CONCATENATE(\"شراء \",\"\",\"\",C40,\" وثيقة\"),IF(G40>0,CONCATENATE(\"إسترداد \",\"\",\"\",G40,\" وثيقة\"),IF(V40=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"شراء 1 وثيقة"},"2019-03-21",null,11]
[36,null,null,null,"",null,1,329.315,329.32,null,329.32,0,{"$f":"IFERROR(IF(AND(V42=\"\",$C$203>(SUM(S40,E41)-SUM(K41))/(SUM(Q40,C41)-SUM(G41)),V41>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q40,C41)-SUM(G41))*$C$203)-((SUM(Q40,C41)-SUM(G41))*(R40)),\"\"),\"\")","v":""},null,0,null,0,0,0,null,{"$f":"IF(C41>0,CONCATENATE(\"شراء \",\"\",\"\",C41,\" وثيقة\"),IF(G41>0,CONCATENATE(\"إسترداد \",\"\",\"\",G41,\" وثيقة\"),IF(V41=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 1 وثيقة"},"2019-03-21",null,12]
[37,null,63,330.20299999999997,20802.79,null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V43=\"\",$C$203>(SUM(S41,E42)-SUM(K42))/(SUM(Q41,C42)-SUM(G42)),V42>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q41,C42)-SUM(G42))*$C$203)-((SUM(Q41,C42)-SUM(G42))*(R41)),\"\"),\"\")","v":""},null,"",null,63,330.203015873016,20802.79,null,{"$f":"IF(C42>0,CONCATENATE(\"شراء \",\"\",\"\",C42,\" وثيقة\"),IF(G42>0,CONCATENATE(\"إسترداد \",\"\",\"\",G42,\" وثيقة\"),IF(V42=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"شراء 63 وثيقة"},"2019-03-28",null,13]
[38,null,52,330.58199999999999,17190.259999999998,null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V44=\"\",$C$203>(SUM(S42,E43)-SUM(K43))/(SUM(Q42,C43)-SUM(G43)),V43>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q42,C43)-SUM(G43))*$C$203)-((SUM(Q42,C43)-SUM(G43))*(R42)),\"\"),\"\")","v":""},null,"",null,115,330.37434782608699,37993.050000000003,null,{"$f":"IF(C43>0,CONCATENATE(\"شراء \",\"\",\"\",C43,\" وثيقة\"),IF(G43>0,CONCATENATE(\"إسترداد \",\"\",\"\",G43,\" وثيقة\"),IF(V43=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"شراء 52 وثيقة"},"2019-03-31",null,14]
[39,null,null,null,"",null,16,330.70800000000003,5291.33,null,5285.99,5.34,{"$f":"IFERROR(IF(AND(V45=\"\",$C$203>(SUM(S43,E44)-SUM(K44))/(SUM(Q43,C44)-SUM(G44)),V44>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q43,C44)-SUM(G44))*$C$203)-((SUM(Q43,C44)-SUM(G44))*(R43)),\"\"),\"\")","v":""},null,0.33,null,99,330.37434343434302,32707.06,null,{"$f":"IF(C44>0,CONCATENATE(\"شراء \",\"\",\"\",C44,\" وثيقة\"),IF(G44>0,CONCATENATE(\"إسترداد \",\"\",\"\",G44,\" وثيقة\"),IF(V44=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 16 وثيقة"},"2019-04-01",null,1]
[40,null,null,null,"",null,2,330.83800000000002,661.68,null,660.75,0.93,{"$f":"IFERROR(IF(AND(V46=\"\",$C$203>(SUM(S44,E45)-SUM(K45))/(SUM(Q44,C45)-SUM(G45)),V45>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q44,C45)-SUM(G45))*$C$203)-((SUM(Q44,C45)-SUM(G45))*(R44)),\"\"),\"\")","v":""},null,0.46,null,97,330.374329896907,32046.31,null,{"$f":"IF(C45>0,CONCATENATE(\"شراء \",\"\",\"\",C45,\" وثيقة\"),IF(G45>0,CONCATENATE(\"إسترداد \",\"\",\"\",G45,\" وثيقة\"),IF(V45=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 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,{"$f":"IFERROR(IF(AND(V47=\"\",$C$203>(SUM(S45,E46)-SUM(K46))/(SUM(Q45,C46)-SUM(G46)),V46>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q45,C46)-SUM(G46))*$C$203)-((SUM(Q45,C46)-SUM(G46))*(R45)),\"\"),\"\")","v":""},null,0.59,null,96,330.37437499999999,31715.94,null,{"$f":"IF(C46>0,CONCATENATE(\"شراء \",\"\",\"\",C46,\" وثيقة\"),IF(G46>0,CONCATENATE(\"إسترداد \",\"\",\"\",G46,\" وثيقة\"),IF(V46=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 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,{"$f":"IFERROR(IF(AND(V48=\"\",$C$203>(SUM(S46,E47)-SUM(K47))/(SUM(Q46,C47)-SUM(G47)),V47>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q46,C47)-SUM(G47))*$C$203)-((SUM(Q46,C47)-SUM(G47))*(R46)),\"\"),\"\")","v":""},null,0.71,null,14,330.37428571428597,4625.24,null,{"$f":"IF(C47>0,CONCATENATE(\"شراء \",\"\",\"\",C47,\" وثيقة\"),IF(G47>0,CONCATENATE(\"إسترداد \",\"\",\"\",G47,\" وثيقة\"),IF(V47=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 82 وثيقة"},"2019-04-04",null,4]
[43,null,1,331.46300000000002,331.46,null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V49=\"\",$C$203>(SUM(S47,E48)-SUM(K48))/(SUM(Q47,C48)-SUM(G48)),V48>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q47,C48)-SUM(G48))*$C$203)-((SUM(Q47,C48)-SUM(G48))*(R47)),\"\"),\"\")","v":""},null,"",null,15,330.446666666667,4956.7,null,{"$f":"IF(C48>0,CONCATENATE(\"شراء \",\"\",\"\",C48,\" وثيقة\"),IF(G48>0,CONCATENATE(\"إسترداد \",\"\",\"\",G48,\" وثيقة\"),IF(V48=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"شراء 1 وثيقة"},"2019-04-07",null,5]
[44,null,null,null,"",null,1,331.71300000000002,331.71,null,330.45,1.26,{"$f":"IFERROR(IF(AND(V50=\"\",$C$203>(SUM(S48,E49)-SUM(K49))/(SUM(Q48,C49)-SUM(G49)),V49>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q48,C49)-SUM(G49))*$C$203)-((SUM(Q48,C49)-SUM(G49))*(R48)),\"\"),\"\")","v":""},null,1.27,null,14,330.44642857142901,4626.25,null,{"$f":"IF(C49>0,CONCATENATE(\"شراء \",\"\",\"\",C49,\" وثيقة\"),IF(G49>0,CONCATENATE(\"إسترداد \",\"\",\"\",G49,\" وثيقة\"),IF(V49=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 1 وثيقة"},"2019-04-09",null,6]
[45,null,33,331.83699999999999,10950.62,null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V51=\"\",$C$203>(SUM(S49,E50)-SUM(K50))/(SUM(Q49,C50)-SUM(G50)),V50>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q49,C50)-SUM(G50))*$C$203)-((SUM(Q49,C50)-SUM(G50))*(R49)),\"\"),\"\")","v":""},null,"",null,47,331.42276595744698,15576.87,null,{"$f":"IF(C50>0,CONCATENATE(\"شراء \",\"\",\"\",C50,\" وثيقة\"),IF(G50>0,CONCATENATE(\"إسترداد \",\"\",\"\",G50,\" وثيقة\"),IF(V50=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"شراء 33 وثيقة"},"2019-04-10",null,7]
[46,null,null,null,"",null,6,331.96199999999999,1991.77,null,1988.54,3.23,{"$f":"IFERROR(IF(AND(V52=\"\",$C$203>(SUM(S50,E51)-SUM(K51))/(SUM(Q50,C51)-SUM(G51)),V51>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q50,C51)-SUM(G51))*$C$203)-((SUM(Q50,C51)-SUM(G51))*(R50)),\"\"),\"\")","v":""},null,0.54,null,41,331.422682926829,13588.33,null,{"$f":"IF(C51>0,CONCATENATE(\"شراء \",\"\",\"\",C51,\" وثيقة\"),IF(G51>0,CONCATENATE(\"إسترداد \",\"\",\"\",G51,\" وثيقة\"),IF(V51=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 6 وثيقة"},"2019-04-11",null,8]
[47,null,null,null,"",null,2,332.33800000000002,664.68,null,662.85,1.83,{"$f":"IFERROR(IF(AND(V53=\"\",$C$203>(SUM(S51,E52)-SUM(K52))/(SUM(Q51,C52)-SUM(G52)),V52>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q51,C52)-SUM(G52))*$C$203)-((SUM(Q51,C52)-SUM(G52))*(R51)),\"\"),\"\")","v":""},null,0.92,null,39,331.42256410256402,12925.48,null,{"$f":"IF(C52>0,CONCATENATE(\"شراء \",\"\",\"\",C52,\" وثيقة\"),IF(G52>0,CONCATENATE(\"إسترداد \",\"\",\"\",G52,\" وثيقة\"),IF(V52=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 2 وثيقة"},"2019-04-14",null,9]
[48,null,null,null,"",null,38,332.714,12643.13,null,12594.06,49.07,{"$f":"IFERROR(IF(AND(V54=\"\",$C$203>(SUM(S52,E53)-SUM(K53))/(SUM(Q52,C53)-SUM(G53)),V53>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q52,C53)-SUM(G53))*$C$203)-((SUM(Q52,C53)-SUM(G53))*(R52)),\"\"),\"\")","v":""},null,1.29,null,1,331.42,331.42,null,{"$f":"IF(C53>0,CONCATENATE(\"شراء \",\"\",\"\",C53,\" وثيقة\"),IF(G53>0,CONCATENATE(\"إسترداد \",\"\",\"\",G53,\" وثيقة\"),IF(V53=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 38 وثيقة"},"2019-04-16",null,10]
[49,null,null,null,"",null,1,332.83800000000002,332.84,null,331.42,1.42,{"$f":"IFERROR(IF(AND(V55=\"\",$C$203>(SUM(S53,E54)-SUM(K54))/(SUM(Q53,C54)-SUM(G54)),V54>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q53,C54)-SUM(G54))*$C$203)-((SUM(Q53,C54)-SUM(G54))*(R53)),\"\"),\"\")","v":""},null,1.42,null,0,0,0,null,{"$f":"IF(C54>0,CONCATENATE(\"شراء \",\"\",\"\",C54,\" وثيقة\"),IF(G54>0,CONCATENATE(\"إسترداد \",\"\",\"\",G54,\" وثيقة\"),IF(V54=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 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,"","",{"$f":"IFERROR(IF(AND(V56=\"\",$C$203>(SUM(S54,E55)-SUM(K55))/(SUM(Q54,C55)-SUM(G55)),V55>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q54,C55)-SUM(G55))*$C$203)-((SUM(Q54,C55)-SUM(G55))*(R54)),\"\"),\"\")","v":""},null,"",null,61,334.33,20394.13,null,{"$f":"IF(C55>0,CONCATENATE(\"شراء \",\"\",\"\",C55,\" وثيقة\"),IF(G55>0,CONCATENATE(\"إسترداد \",\"\",\"\",G55,\" وثيقة\"),IF(V55=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"شراء 61 وثيقة"},"2019-04-30",null,12]
[51,null,null,null,"",null,12,334.57900000000001,4014.95,null,4011.96,2.99,{"$f":"IFERROR(IF(AND(V57=\"\",$C$203>(SUM(S55,E56)-SUM(K56))/(SUM(Q55,C56)-SUM(G56)),V56>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q55,C56)-SUM(G56))*$C$203)-((SUM(Q55,C56)-SUM(G56))*(R55)),\"\"),\"\")","v":""},null,0.25,null,49,334.33,16382.17,null,{"$f":"IF(C56>0,CONCATENATE(\"شراء \",\"\",\"\",C56,\" وثيقة\"),IF(G56>0,CONCATENATE(\"إسترداد \",\"\",\"\",G56,\" وثيقة\"),IF(V56=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 12 وثيقة"},"2019-05-02",null,1]
[52,null,17,334.95299999999997,5694.2,null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V58=\"\",$C$203>(SUM(S56,E57)-SUM(K57))/(SUM(Q56,C57)-SUM(G57)),V57>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q56,C57)-SUM(G57))*$C$203)-((SUM(Q56,C57)-SUM(G57))*(R56)),\"\"),\"\")","v":""},null,"",null,66,334.49045454545501,22076.37,null,{"$f":"IF(C57>0,CONCATENATE(\"شراء \",\"\",\"\",C57,\" وثيقة\"),IF(G57>0,CONCATENATE(\"إسترداد \",\"\",\"\",G57,\" وثيقة\"),IF(V57=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"شراء 17 وثيقة"},"2019-05-05",null,2]
[53,null,34,335.077,11392.62,null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V59=\"\",$C$203>(SUM(S57,E58)-SUM(K58))/(SUM(Q57,C58)-SUM(G58)),V58>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q57,C58)-SUM(G58))*$C$203)-((SUM(Q57,C58)-SUM(G58))*(R57)),\"\"),\"\")","v":""},null,"",null,100,334.68990000000002,33468.99,null,{"$f":"IF(C58>0,CONCATENATE(\"شراء \",\"\",\"\",C58,\" وثيقة\"),IF(G58>0,CONCATENATE(\"إسترداد \",\"\",\"\",G58,\" وثيقة\"),IF(V58=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"شراء 34 وثيقة"},"2019-05-06",null,3]
[54,null,null,null,"",null,2,335.83100000000002,671.66,null,669.38,2.2799999999999998,{"$f":"IFERROR(IF(AND(V60=\"\",$C$203>(SUM(S58,E59)-SUM(K59))/(SUM(Q58,C59)-SUM(G59)),V59>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q58,C59)-SUM(G59))*$C$203)-((SUM(Q58,C59)-SUM(G59))*(R58)),\"\"),\"\")","v":""},null,1.1399999999999999,null,98,334.68989795918401,32799.61,null,{"$f":"IF(C59>0,CONCATENATE(\"شراء \",\"\",\"\",C59,\" وثيقة\"),IF(G59>0,CONCATENATE(\"إسترداد \",\"\",\"\",G59,\" وثيقة\"),IF(V59=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 2 وثيقة"},"2019-05-12",null,4]
[55,null,null,null,"",null,4,335.95499999999998,1343.82,null,1338.76,5.0599999999999996,{"$f":"IFERROR(IF(AND(V61=\"\",$C$203>(SUM(S59,E60)-SUM(K60))/(SUM(Q59,C60)-SUM(G60)),V60>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q59,C60)-SUM(G60))*$C$203)-((SUM(Q59,C60)-SUM(G60))*(R59)),\"\"),\"\")","v":""},null,1.27,null,94,334.68989361702103,31460.85,null,{"$f":"IF(C60>0,CONCATENATE(\"شراء \",\"\",\"\",C60,\" وثيقة\"),IF(G60>0,CONCATENATE(\"إسترداد \",\"\",\"\",G60,\" وثيقة\"),IF(V60=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 4 وثيقة"},"2019-05-13",null,5]
[56,null,null,null,"",null,1,336.20299999999997,336.2,null,334.69,1.51,{"$f":"IFERROR(IF(AND(V62=\"\",$C$203>(SUM(S60,E61)-SUM(K61))/(SUM(Q60,C61)-SUM(G61)),V61>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q60,C61)-SUM(G61))*$C$203)-((SUM(Q60,C61)-SUM(G61))*(R60)),\"\"),\"\")","v":""},null,1.51,null,93,334.68989247311799,31126.16,null,{"$f":"IF(C61>0,CONCATENATE(\"شراء \",\"\",\"\",C61,\" وثيقة\"),IF(G61>0,CONCATENATE(\"إسترداد \",\"\",\"\",G61,\" وثيقة\"),IF(V61=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 1 وثيقة"},"2019-05-15",null,6]
[57,null,null,null,"",null,15,336.32900000000001,5044.9399999999996,null,5020.3500000000004,24.59,{"$f":"IFERROR(IF(AND(V63=\"\",$C$203>(SUM(S61,E62)-SUM(K62))/(SUM(Q61,C62)-SUM(G62)),V62>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q61,C62)-SUM(G62))*$C$203)-((SUM(Q61,C62)-SUM(G62))*(R61)),\"\"),\"\")","v":""},null,1.64,null,78,334.68987179487198,26105.81,null,{"$f":"IF(C62>0,CONCATENATE(\"شراء \",\"\",\"\",C62,\" وثيقة\"),IF(G62>0,CONCATENATE(\"إسترداد \",\"\",\"\",G62,\" وثيقة\"),IF(V62=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 15 وثيقة"},"2019-05-16",null,7]
[58,null,12,336.702,4040.42,null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V64=\"\",$C$203>(SUM(S62,E63)-SUM(K63))/(SUM(Q62,C63)-SUM(G63)),V63>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q62,C63)-SUM(G63))*$C$203)-((SUM(Q62,C63)-SUM(G63))*(R62)),\"\"),\"\")","v":""},null,"",null,90,334.95811111111101,30146.23,null,{"$f":"IF(C63>0,CONCATENATE(\"شراء \",\"\",\"\",C63,\" وثيقة\"),IF(G63>0,CONCATENATE(\"إسترداد \",\"\",\"\",G63,\" وثيقة\"),IF(V63=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"شراء 12 وثيقة"},"2019-05-19",null,8]
[59,null,null,null,"",null,1,337.07400000000001,337.07,null,334.96,2.11,{"$f":"IFERROR(IF(AND(V65=\"\",$C$203>(SUM(S63,E64)-SUM(K64))/(SUM(Q63,C64)-SUM(G64)),V64>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q63,C64)-SUM(G64))*$C$203)-((SUM(Q63,C64)-SUM(G64))*(R63)),\"\"),\"\")","v":""},null,2.12,null,89,334.95808988764003,29811.27,null,{"$f":"IF(C64>0,CONCATENATE(\"شراء \",\"\",\"\",C64,\" وثيقة\"),IF(G64>0,CONCATENATE(\"إسترداد \",\"\",\"\",G64,\" وثيقة\"),IF(V64=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 1 وثيقة"},"2019-05-22",null,9]
[60,null,null,null,"",null,19,337.20400000000001,6406.88,null,6364.2,42.68,{"$f":"IFERROR(IF(AND(V66=\"\",$C$203>(SUM(S64,E65)-SUM(K65))/(SUM(Q64,C65)-SUM(G65)),V65>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q64,C65)-SUM(G65))*$C$203)-((SUM(Q64,C65)-SUM(G65))*(R64)),\"\"),\"\")","v":""},null,2.25,null,70,334.958142857143,23447.07,null,{"$f":"IF(C65>0,CONCATENATE(\"شراء \",\"\",\"\",C65,\" وثيقة\"),IF(G65>0,CONCATENATE(\"إسترداد \",\"\",\"\",G65,\" وثيقة\"),IF(V65=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 19 وثيقة"},"2019-05-23",null,10]
[61,null,null,null,"",null,12,337.57600000000002,4050.91,null,4019.5,31.41,{"$f":"IFERROR(IF(AND(V67=\"\",$C$203>(SUM(S65,E66)-SUM(K66))/(SUM(Q65,C66)-SUM(G66)),V66>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q65,C66)-SUM(G66))*$C$203)-((SUM(Q65,C66)-SUM(G66))*(R65)),\"\"),\"\")","v":""},null,2.62,null,58,334.95810344827601,19427.57,null,{"$f":"IF(C66>0,CONCATENATE(\"شراء \",\"\",\"\",C66,\" وثيقة\"),IF(G66>0,CONCATENATE(\"إسترداد \",\"\",\"\",G66,\" وثيقة\"),IF(V66=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 12 وثيقة"},"2019-05-26",null,11]
[62,null,null,null,"",null,57,337.7,19248.900000000001,null,19092.61,156.29,{"$f":"IFERROR(IF(AND(V68=\"\",$C$203>(SUM(S66,E67)-SUM(K67))/(SUM(Q66,C67)-SUM(G67)),V67>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q66,C67)-SUM(G67))*$C$203)-((SUM(Q66,C67)-SUM(G67))*(R66)),\"\"),\"\")","v":""},null,2.74,null,1,334.95999999999901,334.95999999999901,null,{"$f":"IF(C67>0,CONCATENATE(\"شراء \",\"\",\"\",C67,\" وثيقة\"),IF(G67>0,CONCATENATE(\"إسترداد \",\"\",\"\",G67,\" وثيقة\"),IF(V67=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 57 وثيقة"},"2019-05-27",null,12]
[63,null,9,341.42200000000003,3072.8,null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V69=\"\",$C$203>(SUM(S67,E68)-SUM(K68))/(SUM(Q67,C68)-SUM(G68)),V68>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q67,C68)-SUM(G68))*$C$203)-((SUM(Q67,C68)-SUM(G68))*(R67)),\"\"),\"\")","v":""},null,"",null,10,340.77600000000001,3407.76,null,{"$f":"IF(C68>0,CONCATENATE(\"شراء \",\"\",\"\",C68,\" وثيقة\"),IF(G68>0,CONCATENATE(\"إسترداد \",\"\",\"\",G68,\" وثيقة\"),IF(V68=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"شراء 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,{"$f":"IF(C69>0,CONCATENATE(\"شراء \",\"\",\"\",C69,\" وثيقة\"),IF(G69>0,CONCATENATE(\"إسترداد \",\"\",\"\",G69,\" وثيقة\"),IF(V69=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"شراء 11 وثيقة"},"2019-06-27",null,2]
[65,null,38,342.15899999999999,13002.04,null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V71=\"\",$C$203>(SUM(S69,E70)-SUM(K70))/(SUM(Q69,C70)-SUM(G70)),V70>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q69,C70)-SUM(G70))*$C$203)-((SUM(Q69,C70)-SUM(G70))*(R69)),\"\"),\"\")","v":""},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,{"$f":"IFERROR(IF(AND(V72=\"\",$C$203>(SUM(S70,E71)-SUM(K71))/(SUM(Q70,C71)-SUM(G71)),V71>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q70,C71)-SUM(G71))*$C$203)-((SUM(Q70,C71)-SUM(G71))*(R70)),\"\"),\"\")","v":""},null,0.59,null,23,341.81,7861.63,null,{"$f":"IF(C71>0,CONCATENATE(\"شراء \",\"\",\"\",C71,\" وثيقة\"),IF(G71>0,CONCATENATE(\"إسترداد \",\"\",\"\",G71,\" وثيقة\"),IF(V71=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 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},{"$f":"IFERROR(IF(AND(V73=\"\",$C$203>(SUM(S71,E72)-SUM(K72))/(SUM(Q71,C72)-SUM(G72)),V72>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q71,C72)-SUM(G72))*$C$203)-((SUM(Q71,C72)-SUM(G72))*(R71)),\"\"),\"\")","v":""},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,{"$f":"IF(C72>0,CONCATENATE(\"شراء \",\"\",\"\",C72,\" وثيقة\"),IF(G72>0,CONCATENATE(\"إسترداد \",\"\",\"\",G72,\" وثيقة\"),IF(V72=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 2 وثيقة"},"2019-07-07",null,3]
[68,null,null,null,"",null,2,342.89699999999999,685.79,null,683.62,2.17,{"$f":"IFERROR(IF(AND(V74=\"\",$C$203>(SUM(S72,E73)-SUM(K73))/(SUM(Q72,C73)-SUM(G73)),V73>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q72,C73)-SUM(G73))*$C$203)-((SUM(Q72,C73)-SUM(G73))*(R72)),\"\"),\"\")","v":""},null,1.0900000000000001,null,19,341.81,6494.39,null,{"$f":"IF(C73>0,CONCATENATE(\"شراء \",\"\",\"\",C73,\" وثيقة\"),IF(G73>0,CONCATENATE(\"إسترداد \",\"\",\"\",G73,\" وثيقة\"),IF(V73=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 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},{"$f":"IFERROR(IF(AND(V75=\"\",$C$203>(SUM(S73,E74)-SUM(K74))/(SUM(Q73,C74)-SUM(G74)),V74>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q73,C74)-SUM(G74))*$C$203)-((SUM(Q73,C74)-SUM(G74))*(R73)),\"\"),\"\")","v":""},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,{"$f":"IF(C74>0,CONCATENATE(\"شراء \",\"\",\"\",C74,\" وثيقة\"),IF(G74>0,CONCATENATE(\"إسترداد \",\"\",\"\",G74,\" وثيقة\"),IF(V74=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 19 وثيقة"},"2019-07-09",null,5]
[70,null,49,345.72699999999998,16940.62,null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V76=\"\",$C$203>(SUM(S74,E75)-SUM(K75))/(SUM(Q74,C75)-SUM(G75)),V75>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q74,C75)-SUM(G75))*$C$203)-((SUM(Q74,C75)-SUM(G75))*(R74)),\"\"),\"\")","v":""},null,"",null,49,345.72693877551001,16940.62,null,{"$f":"IF(C75>0,CONCATENATE(\"شراء \",\"\",\"\",C75,\" وثيقة\"),IF(G75>0,CONCATENATE(\"إسترداد \",\"\",\"\",G75,\" وثيقة\"),IF(V75=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"شراء 49 وثيقة"},"2019-07-31",null,6]
[71,null,null,null,"",null,7,345.85,2420.9499999999998,null,2420.09,0.86,{"$f":"IFERROR(IF(AND(V77=\"\",$C$203>(SUM(S75,E76)-SUM(K76))/(SUM(Q75,C76)-SUM(G76)),V76>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q75,C76)-SUM(G76))*$C$203)-((SUM(Q75,C76)-SUM(G76))*(R75)),\"\"),\"\")","v":""},null,0.12,null,42,345.72690476190502,14520.53,null,{"$f":"IF(C76>0,CONCATENATE(\"شراء \",\"\",\"\",C76,\" وثيقة\"),IF(G76>0,CONCATENATE(\"إسترداد \",\"\",\"\",G76,\" وثيقة\"),IF(V76=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 7 وثيقة"},"2019-08-01",null,1]
[72,null,null,null,"",null,13,346.22199999999998,4500.8900000000003,null,4494.45,6.44,{"$f":"IFERROR(IF(AND(V78=\"\",$C$203>(SUM(S76,E77)-SUM(K77))/(SUM(Q76,C77)-SUM(G77)),V77>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q76,C77)-SUM(G77))*$C$203)-((SUM(Q76,C77)-SUM(G77))*(R76)),\"\"),\"\")","v":""},null,0.5,null,29,345.726896551724,10026.08,null,{"$f":"IF(C77>0,CONCATENATE(\"شراء \",\"\",\"\",C77,\" وثيقة\"),IF(G77>0,CONCATENATE(\"إسترداد \",\"\",\"\",G77,\" وثيقة\"),IF(V77=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 13 وثيقة"},"2019-08-04",null,2]
[73,null,25,346.46800000000002,8661.7000000000007,null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V79=\"\",$C$203>(SUM(S77,E78)-SUM(K78))/(SUM(Q77,C78)-SUM(G78)),V78>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q77,C78)-SUM(G78))*$C$203)-((SUM(Q77,C78)-SUM(G78))*(R77)),\"\"),\"\")","v":""},null,"",null,54,346.07,18687.78,null,{"$f":"IF(C78>0,CONCATENATE(\"شراء \",\"\",\"\",C78,\" وثيقة\"),IF(G78>0,CONCATENATE(\"إسترداد \",\"\",\"\",G78,\" وثيقة\"),IF(V78=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"شراء 25 وثيقة"},"2019-08-06",null,3]
[74,null,2,346.59199999999998,693.18,null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V80=\"\",$C$203>(SUM(S78,E79)-SUM(K79))/(SUM(Q78,C79)-SUM(G79)),V79>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q78,C79)-SUM(G79))*$C$203)-((SUM(Q78,C79)-SUM(G79))*(R78)),\"\"),\"\")","v":""},null,"",null,56,346.08857142857102,19380.96,null,{"$f":"IF(C79>0,CONCATENATE(\"شراء \",\"\",\"\",C79,\" وثيقة\"),IF(G79>0,CONCATENATE(\"إسترداد \",\"\",\"\",G79,\" وثيقة\"),IF(V79=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"شراء 2 وثيقة"},"2019-08-07",null,4]
[75,null,6,346.71499999999997,2080.29,null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V81=\"\",$C$203>(SUM(S79,E80)-SUM(K80))/(SUM(Q79,C80)-SUM(G80)),V80>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q79,C80)-SUM(G80))*$C$203)-((SUM(Q79,C80)-SUM(G80))*(R79)),\"\"),\"\")","v":""},null,"",null,62,346.14919354838702,21461.25,null,{"$f":"IF(C80>0,CONCATENATE(\"شراء \",\"\",\"\",C80,\" وثيقة\"),IF(G80>0,CONCATENATE(\"إسترداد \",\"\",\"\",G80,\" وثيقة\"),IF(V80=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"شراء 6 وثيقة"},"2019-08-08",null,5]
[76,null,null,null,"",null,1,347.95,347.95,null,346.15,1.8,{"$f":"IFERROR(IF(AND(V82=\"\",$C$203>(SUM(S80,E81)-SUM(K81))/(SUM(Q80,C81)-SUM(G81)),V81>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q80,C81)-SUM(G81))*$C$203)-((SUM(Q80,C81)-SUM(G81))*(R80)),\"\"),\"\")","v":""},null,1.8,null,61,346.14918032786898,21115.1,null,{"$f":"IF(C81>0,CONCATENATE(\"شراء \",\"\",\"\",C81,\" وثيقة\"),IF(G81>0,CONCATENATE(\"إسترداد \",\"\",\"\",G81,\" وثيقة\"),IF(V81=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 1 وثيقة"},"2019-08-18",null,6]
[77,null,null,null,"",null,2,348.44400000000002,696.89,null,692.3,4.59,{"$f":"IFERROR(IF(AND(V83=\"\",$C$203>(SUM(S81,E82)-SUM(K82))/(SUM(Q81,C82)-SUM(G82)),V82>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q81,C82)-SUM(G82))*$C$203)-((SUM(Q81,C82)-SUM(G82))*(R81)),\"\"),\"\")","v":""},null,2.29,null,59,346.14915254237297,20422.8,null,{"$f":"IF(C82>0,CONCATENATE(\"شراء \",\"\",\"\",C82,\" وثيقة\"),IF(G82>0,CONCATENATE(\"إسترداد \",\"\",\"\",G82,\" وثيقة\"),IF(V82=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 2 وثيقة"},"2019-08-22",null,7]
[78,null,19,351.65,6681.35,null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V84=\"\",$C$203>(SUM(S82,E83)-SUM(K83))/(SUM(Q82,C83)-SUM(G83)),V83>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q82,C83)-SUM(G83))*$C$203)-((SUM(Q82,C83)-SUM(G83))*(R82)),\"\"),\"\")","v":""},null,"",null,78,347.48910256410301,27104.15,null,{"$f":"IF(C83>0,CONCATENATE(\"شراء \",\"\",\"\",C83,\" وثيقة\"),IF(G83>0,CONCATENATE(\"إسترداد \",\"\",\"\",G83,\" وثيقة\"),IF(V83=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"شراء 19 وثيقة"},"2019-09-17",null,1]
[79,null,43,351.77300000000002,15126.24,null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V85=\"\",$C$203>(SUM(S83,E84)-SUM(K84))/(SUM(Q83,C84)-SUM(G84)),V84>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q83,C84)-SUM(G84))*$C$203)-((SUM(Q83,C84)-SUM(G84))*(R83)),\"\"),\"\")","v":""},null,"",null,121,349.01148760330602,42230.39,null,{"$f":"IF(C84>0,CONCATENATE(\"شراء \",\"\",\"\",C84,\" وثيقة\"),IF(G84>0,CONCATENATE(\"إسترداد \",\"\",\"\",G84,\" وثيقة\"),IF(V84=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"شراء 43 وثيقة"},"2019-09-18",null,2]
[80,null,null,null,"",null,9,351.89600000000002,3167.06,null,3141.1,25.96,{"$f":"IFERROR(IF(AND(V86=\"\",$C$203>(SUM(S84,E85)-SUM(K85))/(SUM(Q84,C85)-SUM(G85)),V85>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q84,C85)-SUM(G85))*$C$203)-((SUM(Q84,C85)-SUM(G85))*(R84)),\"\"),\"\")","v":""},null,2.88,null,112,349.01151785714302,39089.29,null,{"$f":"IF(C85>0,CONCATENATE(\"شراء \",\"\",\"\",C85,\" وثيقة\"),IF(G85>0,CONCATENATE(\"إسترداد \",\"\",\"\",G85,\" وثيقة\"),IF(V85=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 9 وثيقة"},"2019-09-19",null,3]
[81,null,null,null,"",null,2,352.26299999999998,704.53,null,698.02,6.51,{"$f":"IFERROR(IF(AND(V87=\"\",$C$203>(SUM(S85,E86)-SUM(K86))/(SUM(Q85,C86)-SUM(G86)),V86>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q85,C86)-SUM(G86))*$C$203)-((SUM(Q85,C86)-SUM(G86))*(R85)),\"\"),\"\")","v":""},null,3.25,null,110,349.011545454545,38391.269999999997,null,{"$f":"IF(C86>0,CONCATENATE(\"شراء \",\"\",\"\",C86,\" وثيقة\"),IF(G86>0,CONCATENATE(\"إسترداد \",\"\",\"\",G86,\" وثيقة\"),IF(V86=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 2 وثيقة"},"2019-09-22",null,4]
[82,null,2,352.50799999999998,705.02,null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V88=\"\",$C$203>(SUM(S86,E87)-SUM(K87))/(SUM(Q86,C87)-SUM(G87)),V87>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q86,C87)-SUM(G87))*$C$203)-((SUM(Q86,C87)-SUM(G87))*(R86)),\"\"),\"\")","v":""},null,"",null,112,349.07401785714302,39096.29,null,{"$f":"IF(C87>0,CONCATENATE(\"شراء \",\"\",\"\",C87,\" وثيقة\"),IF(G87>0,CONCATENATE(\"إسترداد \",\"\",\"\",G87,\" وثيقة\"),IF(V87=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"شراء 2 وثيقة"},"2019-09-24",null,5]
[83,null,null,null,"",null,6,352.75299999999999,2116.52,null,2094.44,22.08,{"$f":"IFERROR(IF(AND(V89=\"\",$C$203>(SUM(S87,E88)-SUM(K88))/(SUM(Q87,C88)-SUM(G88)),V88>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q87,C88)-SUM(G88))*$C$203)-((SUM(Q87,C88)-SUM(G88))*(R87)),\"\"),\"\")","v":""},null,3.68,null,106,349.07405660377401,37001.85,null,{"$f":"IF(C88>0,CONCATENATE(\"شراء \",\"\",\"\",C88,\" وثيقة\"),IF(G88>0,CONCATENATE(\"إسترداد \",\"\",\"\",G88,\" وثيقة\"),IF(V88=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 6 وثيقة"},"2019-09-26",null,6]
[84,null,59,353.12,20834.080000000002,null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V90=\"\",$C$203>(SUM(S88,E89)-SUM(K89))/(SUM(Q88,C89)-SUM(G89)),V89>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q88,C89)-SUM(G89))*$C$203)-((SUM(Q88,C89)-SUM(G89))*(R88)),\"\"),\"\")","v":""},null,"",null,165,350.52078787878798,57835.93,null,{"$f":"IF(C89>0,CONCATENATE(\"شراء \",\"\",\"\",C89,\" وثيقة\"),IF(G89>0,CONCATENATE(\"إسترداد \",\"\",\"\",G89,\" وثيقة\"),IF(V89=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"شراء 59 وثيقة"},"2019-09-29",null,7]
[85,null,54,353.24099999999999,19075.009999999998,null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V91=\"\",$C$203>(SUM(S89,E90)-SUM(K90))/(SUM(Q89,C90)-SUM(G90)),V90>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q89,C90)-SUM(G90))*$C$203)-((SUM(Q89,C90)-SUM(G90))*(R89)),\"\"),\"\")","v":""},null,"",null,219,351.19150684931498,76910.94,null,{"$f":"IF(C90>0,CONCATENATE(\"شراء \",\"\",\"\",C90,\" وثيقة\"),IF(G90>0,CONCATENATE(\"إسترداد \",\"\",\"\",G90,\" وثيقة\"),IF(V90=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"شراء 54 وثيقة"},"2019-09-30",null,8]
[86,null,null,null,"",null,14,353.36799999999999,4947.1499999999996,null,4916.68,30.47,{"$f":"IFERROR(IF(AND(V92=\"\",$C$203>(SUM(S90,E91)-SUM(K91))/(SUM(Q90,C91)-SUM(G91)),V91>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q90,C91)-SUM(G91))*$C$203)-((SUM(Q90,C91)-SUM(G91))*(R90)),\"\"),\"\")","v":""},null,2.1800000000000002,null,205,351.19151219512202,71994.259999999995,null,{"$f":"IF(C91>0,CONCATENATE(\"شراء \",\"\",\"\",C91,\" وثيقة\"),IF(G91>0,CONCATENATE(\"إسترداد \",\"\",\"\",G91,\" وثيقة\"),IF(V91=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 14 وثيقة"},"2019-10-01",null,1]
[87,null,null,null,"",null,19,353.61900000000003,6718.76,null,6672.64,46.12,{"$f":"IFERROR(IF(AND(V93=\"\",$C$203>(SUM(S91,E92)-SUM(K92))/(SUM(Q91,C92)-SUM(G92)),V92>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q91,C92)-SUM(G92))*$C$203)-((SUM(Q91,C92)-SUM(G92))*(R91)),\"\"),\"\")","v":""},null,2.4300000000000002,null,186,351.19150537634403,65321.62,null,{"$f":"IF(C92>0,CONCATENATE(\"شراء \",\"\",\"\",C92,\" وثيقة\"),IF(G92>0,CONCATENATE(\"إسترداد \",\"\",\"\",G92,\" وثيقة\"),IF(V92=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 19 وثيقة"},"2019-10-03",null,2]
[88,null,null,null,"",null,1,354.21899999999999,354.22,null,351.19,3.03,{"$f":"IFERROR(IF(AND(V94=\"\",$C$203>(SUM(S92,E93)-SUM(K93))/(SUM(Q92,C93)-SUM(G93)),V93>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q92,C93)-SUM(G93))*$C$203)-((SUM(Q92,C93)-SUM(G93))*(R92)),\"\"),\"\")","v":""},null,3.03,null,185,351.191513513514,64970.43,null,{"$f":"IF(C93>0,CONCATENATE(\"شراء \",\"\",\"\",C93,\" وثيقة\"),IF(G93>0,CONCATENATE(\"إسترداد \",\"\",\"\",G93,\" وثيقة\"),IF(V93=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 1 وثيقة"},"2019-10-08",null,3]
[89,null,null,null,"",null,90,354.21899999999999,31879.71,null,31607.24,272.47000000000003,{"$f":"IFERROR(IF(AND(V95=\"\",$C$203>(SUM(S93,E94)-SUM(K94))/(SUM(Q93,C94)-SUM(G94)),V94>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q93,C94)-SUM(G94))*$C$203)-((SUM(Q93,C94)-SUM(G94))*(R93)),\"\"),\"\")","v":""},null,3.03,null,95,351.19147368421102,33363.19,null,{"$f":"IF(C94>0,CONCATENATE(\"شراء \",\"\",\"\",C94,\" وثيقة\"),IF(G94>0,CONCATENATE(\"إسترداد \",\"\",\"\",G94,\" وثيقة\"),IF(V94=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 90 وثيقة"},"2019-10-08",null,4]
[90,null,null,null,"",null,1,354.34,354.34,null,351.19,3.15,{"$f":"IFERROR(IF(AND(V96=\"\",$C$203>(SUM(S94,E95)-SUM(K95))/(SUM(Q94,C95)-SUM(G95)),V95>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q94,C95)-SUM(G95))*$C$203)-((SUM(Q94,C95)-SUM(G95))*(R94)),\"\"),\"\")","v":""},null,3.15,null,94,351.191489361702,33012,null,{"$f":"IF(C95>0,CONCATENATE(\"شراء \",\"\",\"\",C95,\" وثيقة\"),IF(G95>0,CONCATENATE(\"إسترداد \",\"\",\"\",G95,\" وثيقة\"),IF(V95=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 1 وثيقة"},"2019-10-09",null,5]
[91,null,null,null,"",null,3,354.46100000000001,1063.3800000000001,null,1053.57,9.81,{"$f":"IFERROR(IF(AND(V97=\"\",$C$203>(SUM(S95,E96)-SUM(K96))/(SUM(Q95,C96)-SUM(G96)),V96>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q95,C96)-SUM(G96))*$C$203)-((SUM(Q95,C96)-SUM(G96))*(R95)),\"\"),\"\")","v":""},null,3.27,null,91,351.19153846153802,31958.43,null,{"$f":"IF(C96>0,CONCATENATE(\"شراء \",\"\",\"\",C96,\" وثيقة\"),IF(G96>0,CONCATENATE(\"إسترداد \",\"\",\"\",G96,\" وثيقة\"),IF(V96=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 3 وثيقة"},"2019-10-10",null,6]
[92,null,null,null,"",null,1,355.06200000000001,355.06,null,351.19,3.87,{"$f":"IFERROR(IF(AND(V98=\"\",$C$203>(SUM(S96,E97)-SUM(K97))/(SUM(Q96,C97)-SUM(G97)),V97>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q96,C97)-SUM(G97))*$C$203)-((SUM(Q96,C97)-SUM(G97))*(R96)),\"\"),\"\")","v":""},null,3.87,null,90,351.19155555555602,31607.24,null,{"$f":"IF(C97>0,CONCATENATE(\"شراء \",\"\",\"\",C97,\" وثيقة\"),IF(G97>0,CONCATENATE(\"إسترداد \",\"\",\"\",G97,\" وثيقة\"),IF(V97=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":"إسترداد 1 وثيقة"},"2019-10-15",null,7]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V99=\"\",$C$203>(SUM(S97,E98)-SUM(K98))/(SUM(Q97,C98)-SUM(G98)),V98>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q97,C98)-SUM(G98))*$C$203)-((SUM(Q97,C98)-SUM(G98))*(R97)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C98>0,CONCATENATE(\"شراء \",\"\",\"\",C98,\" وثيقة\"),IF(G98>0,CONCATENATE(\"إسترداد \",\"\",\"\",G98,\" وثيقة\"),IF(V98=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V100=\"\",$C$203>(SUM(S98,E99)-SUM(K99))/(SUM(Q98,C99)-SUM(G99)),V99>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q98,C99)-SUM(G99))*$C$203)-((SUM(Q98,C99)-SUM(G99))*(R98)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C99>0,CONCATENATE(\"شراء \",\"\",\"\",C99,\" وثيقة\"),IF(G99>0,CONCATENATE(\"إسترداد \",\"\",\"\",G99,\" وثيقة\"),IF(V99=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V101=\"\",$C$203>(SUM(S99,E100)-SUM(K100))/(SUM(Q99,C100)-SUM(G100)),V100>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q99,C100)-SUM(G100))*$C$203)-((SUM(Q99,C100)-SUM(G100))*(R99)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C100>0,CONCATENATE(\"شراء \",\"\",\"\",C100,\" وثيقة\"),IF(G100>0,CONCATENATE(\"إسترداد \",\"\",\"\",G100,\" وثيقة\"),IF(V100=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},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,{"$f":"IF(C101>0,CONCATENATE(\"شراء \",\"\",\"\",C101,\" وثيقة\"),IF(G101>0,CONCATENATE(\"إسترداد \",\"\",\"\",G101,\" وثيقة\"),IF(V101=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V103=\"\",$C$203>(SUM(S101,E102)-SUM(K102))/(SUM(Q101,C102)-SUM(G102)),V102>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q101,C102)-SUM(G102))*$C$203)-((SUM(Q101,C102)-SUM(G102))*(R101)),\"\"),\"\")","v":""},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,"","",{"$f":"IFERROR(IF(AND(V104=\"\",$C$203>(SUM(S102,E103)-SUM(K103))/(SUM(Q102,C103)-SUM(G103)),V103>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q102,C103)-SUM(G103))*$C$203)-((SUM(Q102,C103)-SUM(G103))*(R102)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C103>0,CONCATENATE(\"شراء \",\"\",\"\",C103,\" وثيقة\"),IF(G103>0,CONCATENATE(\"إسترداد \",\"\",\"\",G103,\" وثيقة\"),IF(V103=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V105=\"\",$C$203>(SUM(S103,E104)-SUM(K104))/(SUM(Q103,C104)-SUM(G104)),V104>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q103,C104)-SUM(G104))*$C$203)-((SUM(Q103,C104)-SUM(G104))*(R103)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C104>0,CONCATENATE(\"شراء \",\"\",\"\",C104,\" وثيقة\"),IF(G104>0,CONCATENATE(\"إسترداد \",\"\",\"\",G104,\" وثيقة\"),IF(V104=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V106=\"\",$C$203>(SUM(S104,E105)-SUM(K105))/(SUM(Q104,C105)-SUM(G105)),V105>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q104,C105)-SUM(G105))*$C$203)-((SUM(Q104,C105)-SUM(G105))*(R104)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C105>0,CONCATENATE(\"شراء \",\"\",\"\",C105,\" وثيقة\"),IF(G105>0,CONCATENATE(\"إسترداد \",\"\",\"\",G105,\" وثيقة\"),IF(V105=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V107=\"\",$C$203>(SUM(S105,E106)-SUM(K106))/(SUM(Q105,C106)-SUM(G106)),V106>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q105,C106)-SUM(G106))*$C$203)-((SUM(Q105,C106)-SUM(G106))*(R105)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C106>0,CONCATENATE(\"شراء \",\"\",\"\",C106,\" وثيقة\"),IF(G106>0,CONCATENATE(\"إسترداد \",\"\",\"\",G106,\" وثيقة\"),IF(V106=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V108=\"\",$C$203>(SUM(S106,E107)-SUM(K107))/(SUM(Q106,C107)-SUM(G107)),V107>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q106,C107)-SUM(G107))*$C$203)-((SUM(Q106,C107)-SUM(G107))*(R106)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C107>0,CONCATENATE(\"شراء \",\"\",\"\",C107,\" وثيقة\"),IF(G107>0,CONCATENATE(\"إسترداد \",\"\",\"\",G107,\" وثيقة\"),IF(V107=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V109=\"\",$C$203>(SUM(S107,E108)-SUM(K108))/(SUM(Q107,C108)-SUM(G108)),V108>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q107,C108)-SUM(G108))*$C$203)-((SUM(Q107,C108)-SUM(G108))*(R107)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C108>0,CONCATENATE(\"شراء \",\"\",\"\",C108,\" وثيقة\"),IF(G108>0,CONCATENATE(\"إسترداد \",\"\",\"\",G108,\" وثيقة\"),IF(V108=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V110=\"\",$C$203>(SUM(S108,E109)-SUM(K109))/(SUM(Q108,C109)-SUM(G109)),V109>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q108,C109)-SUM(G109))*$C$203)-((SUM(Q108,C109)-SUM(G109))*(R108)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C109>0,CONCATENATE(\"شراء \",\"\",\"\",C109,\" وثيقة\"),IF(G109>0,CONCATENATE(\"إسترداد \",\"\",\"\",G109,\" وثيقة\"),IF(V109=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V111=\"\",$C$203>(SUM(S109,E110)-SUM(K110))/(SUM(Q109,C110)-SUM(G110)),V110>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q109,C110)-SUM(G110))*$C$203)-((SUM(Q109,C110)-SUM(G110))*(R109)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C110>0,CONCATENATE(\"شراء \",\"\",\"\",C110,\" وثيقة\"),IF(G110>0,CONCATENATE(\"إسترداد \",\"\",\"\",G110,\" وثيقة\"),IF(V110=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V112=\"\",$C$203>(SUM(S110,E111)-SUM(K111))/(SUM(Q110,C111)-SUM(G111)),V111>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q110,C111)-SUM(G111))*$C$203)-((SUM(Q110,C111)-SUM(G111))*(R110)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C111>0,CONCATENATE(\"شراء \",\"\",\"\",C111,\" وثيقة\"),IF(G111>0,CONCATENATE(\"إسترداد \",\"\",\"\",G111,\" وثيقة\"),IF(V111=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V113=\"\",$C$203>(SUM(S111,E112)-SUM(K112))/(SUM(Q111,C112)-SUM(G112)),V112>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q111,C112)-SUM(G112))*$C$203)-((SUM(Q111,C112)-SUM(G112))*(R111)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C112>0,CONCATENATE(\"شراء \",\"\",\"\",C112,\" وثيقة\"),IF(G112>0,CONCATENATE(\"إسترداد \",\"\",\"\",G112,\" وثيقة\"),IF(V112=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V114=\"\",$C$203>(SUM(S112,E113)-SUM(K113))/(SUM(Q112,C113)-SUM(G113)),V113>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q112,C113)-SUM(G113))*$C$203)-((SUM(Q112,C113)-SUM(G113))*(R112)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C113>0,CONCATENATE(\"شراء \",\"\",\"\",C113,\" وثيقة\"),IF(G113>0,CONCATENATE(\"إسترداد \",\"\",\"\",G113,\" وثيقة\"),IF(V113=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V115=\"\",$C$203>(SUM(S113,E114)-SUM(K114))/(SUM(Q113,C114)-SUM(G114)),V114>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q113,C114)-SUM(G114))*$C$203)-((SUM(Q113,C114)-SUM(G114))*(R113)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C114>0,CONCATENATE(\"شراء \",\"\",\"\",C114,\" وثيقة\"),IF(G114>0,CONCATENATE(\"إسترداد \",\"\",\"\",G114,\" وثيقة\"),IF(V114=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V116=\"\",$C$203>(SUM(S114,E115)-SUM(K115))/(SUM(Q114,C115)-SUM(G115)),V115>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q114,C115)-SUM(G115))*$C$203)-((SUM(Q114,C115)-SUM(G115))*(R114)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C115>0,CONCATENATE(\"شراء \",\"\",\"\",C115,\" وثيقة\"),IF(G115>0,CONCATENATE(\"إسترداد \",\"\",\"\",G115,\" وثيقة\"),IF(V115=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V117=\"\",$C$203>(SUM(S115,E116)-SUM(K116))/(SUM(Q115,C116)-SUM(G116)),V116>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q115,C116)-SUM(G116))*$C$203)-((SUM(Q115,C116)-SUM(G116))*(R115)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C116>0,CONCATENATE(\"شراء \",\"\",\"\",C116,\" وثيقة\"),IF(G116>0,CONCATENATE(\"إسترداد \",\"\",\"\",G116,\" وثيقة\"),IF(V116=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V118=\"\",$C$203>(SUM(S116,E117)-SUM(K117))/(SUM(Q116,C117)-SUM(G117)),V117>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q116,C117)-SUM(G117))*$C$203)-((SUM(Q116,C117)-SUM(G117))*(R116)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C117>0,CONCATENATE(\"شراء \",\"\",\"\",C117,\" وثيقة\"),IF(G117>0,CONCATENATE(\"إسترداد \",\"\",\"\",G117,\" وثيقة\"),IF(V117=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V119=\"\",$C$203>(SUM(S117,E118)-SUM(K118))/(SUM(Q117,C118)-SUM(G118)),V118>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q117,C118)-SUM(G118))*$C$203)-((SUM(Q117,C118)-SUM(G118))*(R117)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C118>0,CONCATENATE(\"شراء \",\"\",\"\",C118,\" وثيقة\"),IF(G118>0,CONCATENATE(\"إسترداد \",\"\",\"\",G118,\" وثيقة\"),IF(V118=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V120=\"\",$C$203>(SUM(S118,E119)-SUM(K119))/(SUM(Q118,C119)-SUM(G119)),V119>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q118,C119)-SUM(G119))*$C$203)-((SUM(Q118,C119)-SUM(G119))*(R118)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C119>0,CONCATENATE(\"شراء \",\"\",\"\",C119,\" وثيقة\"),IF(G119>0,CONCATENATE(\"إسترداد \",\"\",\"\",G119,\" وثيقة\"),IF(V119=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V121=\"\",$C$203>(SUM(S119,E120)-SUM(K120))/(SUM(Q119,C120)-SUM(G120)),V120>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q119,C120)-SUM(G120))*$C$203)-((SUM(Q119,C120)-SUM(G120))*(R119)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C120>0,CONCATENATE(\"شراء \",\"\",\"\",C120,\" وثيقة\"),IF(G120>0,CONCATENATE(\"إسترداد \",\"\",\"\",G120,\" وثيقة\"),IF(V120=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},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":""},{"$f":"IFERROR(IF(AND(V122=\"\",$C$203>(SUM(S120,E121)-SUM(K121))/(SUM(Q120,C121)-SUM(G121)),V121>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q120,C121)-SUM(G121))*$C$203)-((SUM(Q120,C121)-SUM(G121))*(R120)),\"\"),\"\")","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,{"$f":"IF(C121>0,CONCATENATE(\"شراء \",\"\",\"\",C121,\" وثيقة\"),IF(G121>0,CONCATENATE(\"إسترداد \",\"\",\"\",G121,\" وثيقة\"),IF(V121=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V123=\"\",$C$203>(SUM(S121,E122)-SUM(K122))/(SUM(Q121,C122)-SUM(G122)),V122>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q121,C122)-SUM(G122))*$C$203)-((SUM(Q121,C122)-SUM(G122))*(R121)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C122>0,CONCATENATE(\"شراء \",\"\",\"\",C122,\" وثيقة\"),IF(G122>0,CONCATENATE(\"إسترداد \",\"\",\"\",G122,\" وثيقة\"),IF(V122=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V124=\"\",$C$203>(SUM(S122,E123)-SUM(K123))/(SUM(Q122,C123)-SUM(G123)),V123>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q122,C123)-SUM(G123))*$C$203)-((SUM(Q122,C123)-SUM(G123))*(R122)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C123>0,CONCATENATE(\"شراء \",\"\",\"\",C123,\" وثيقة\"),IF(G123>0,CONCATENATE(\"إسترداد \",\"\",\"\",G123,\" وثيقة\"),IF(V123=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V125=\"\",$C$203>(SUM(S123,E124)-SUM(K124))/(SUM(Q123,C124)-SUM(G124)),V124>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q123,C124)-SUM(G124))*$C$203)-((SUM(Q123,C124)-SUM(G124))*(R123)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C124>0,CONCATENATE(\"شراء \",\"\",\"\",C124,\" وثيقة\"),IF(G124>0,CONCATENATE(\"إسترداد \",\"\",\"\",G124,\" وثيقة\"),IF(V124=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V126=\"\",$C$203>(SUM(S124,E125)-SUM(K125))/(SUM(Q124,C125)-SUM(G125)),V125>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q124,C125)-SUM(G125))*$C$203)-((SUM(Q124,C125)-SUM(G125))*(R124)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C125>0,CONCATENATE(\"شراء \",\"\",\"\",C125,\" وثيقة\"),IF(G125>0,CONCATENATE(\"إسترداد \",\"\",\"\",G125,\" وثيقة\"),IF(V125=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V127=\"\",$C$203>(SUM(S125,E126)-SUM(K126))/(SUM(Q125,C126)-SUM(G126)),V126>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q125,C126)-SUM(G126))*$C$203)-((SUM(Q125,C126)-SUM(G126))*(R125)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C126>0,CONCATENATE(\"شراء \",\"\",\"\",C126,\" وثيقة\"),IF(G126>0,CONCATENATE(\"إسترداد \",\"\",\"\",G126,\" وثيقة\"),IF(V126=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V128=\"\",$C$203>(SUM(S126,E127)-SUM(K127))/(SUM(Q126,C127)-SUM(G127)),V127>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q126,C127)-SUM(G127))*$C$203)-((SUM(Q126,C127)-SUM(G127))*(R126)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C127>0,CONCATENATE(\"شراء \",\"\",\"\",C127,\" وثيقة\"),IF(G127>0,CONCATENATE(\"إسترداد \",\"\",\"\",G127,\" وثيقة\"),IF(V127=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V129=\"\",$C$203>(SUM(S127,E128)-SUM(K128))/(SUM(Q127,C128)-SUM(G128)),V128>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q127,C128)-SUM(G128))*$C$203)-((SUM(Q127,C128)-SUM(G128))*(R127)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C128>0,CONCATENATE(\"شراء \",\"\",\"\",C128,\" وثيقة\"),IF(G128>0,CONCATENATE(\"إسترداد \",\"\",\"\",G128,\" وثيقة\"),IF(V128=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V130=\"\",$C$203>(SUM(S128,E129)-SUM(K129))/(SUM(Q128,C129)-SUM(G129)),V129>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q128,C129)-SUM(G129))*$C$203)-((SUM(Q128,C129)-SUM(G129))*(R128)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C129>0,CONCATENATE(\"شراء \",\"\",\"\",C129,\" وثيقة\"),IF(G129>0,CONCATENATE(\"إسترداد \",\"\",\"\",G129,\" وثيقة\"),IF(V129=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V131=\"\",$C$203>(SUM(S129,E130)-SUM(K130))/(SUM(Q129,C130)-SUM(G130)),V130>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q129,C130)-SUM(G130))*$C$203)-((SUM(Q129,C130)-SUM(G130))*(R129)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C130>0,CONCATENATE(\"شراء \",\"\",\"\",C130,\" وثيقة\"),IF(G130>0,CONCATENATE(\"إسترداد \",\"\",\"\",G130,\" وثيقة\"),IF(V130=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V132=\"\",$C$203>(SUM(S130,E131)-SUM(K131))/(SUM(Q130,C131)-SUM(G131)),V131>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q130,C131)-SUM(G131))*$C$203)-((SUM(Q130,C131)-SUM(G131))*(R130)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C131>0,CONCATENATE(\"شراء \",\"\",\"\",C131,\" وثيقة\"),IF(G131>0,CONCATENATE(\"إسترداد \",\"\",\"\",G131,\" وثيقة\"),IF(V131=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V133=\"\",$C$203>(SUM(S131,E132)-SUM(K132))/(SUM(Q131,C132)-SUM(G132)),V132>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q131,C132)-SUM(G132))*$C$203)-((SUM(Q131,C132)-SUM(G132))*(R131)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C132>0,CONCATENATE(\"شراء \",\"\",\"\",C132,\" وثيقة\"),IF(G132>0,CONCATENATE(\"إسترداد \",\"\",\"\",G132,\" وثيقة\"),IF(V132=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},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,{"$f":"IF(C133>0,CONCATENATE(\"شراء \",\"\",\"\",C133,\" وثيقة\"),IF(G133>0,CONCATENATE(\"إسترداد \",\"\",\"\",G133,\" وثيقة\"),IF(V133=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V135=\"\",$C$203>(SUM(S133,E134)-SUM(K134))/(SUM(Q133,C134)-SUM(G134)),V134>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q133,C134)-SUM(G134))*$C$203)-((SUM(Q133,C134)-SUM(G134))*(R133)),\"\"),\"\")","v":""},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,"","",{"$f":"IFERROR(IF(AND(V136=\"\",$C$203>(SUM(S134,E135)-SUM(K135))/(SUM(Q134,C135)-SUM(G135)),V135>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q134,C135)-SUM(G135))*$C$203)-((SUM(Q134,C135)-SUM(G135))*(R134)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C135>0,CONCATENATE(\"شراء \",\"\",\"\",C135,\" وثيقة\"),IF(G135>0,CONCATENATE(\"إسترداد \",\"\",\"\",G135,\" وثيقة\"),IF(V135=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V137=\"\",$C$203>(SUM(S135,E136)-SUM(K136))/(SUM(Q135,C136)-SUM(G136)),V136>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q135,C136)-SUM(G136))*$C$203)-((SUM(Q135,C136)-SUM(G136))*(R135)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C136>0,CONCATENATE(\"شراء \",\"\",\"\",C136,\" وثيقة\"),IF(G136>0,CONCATENATE(\"إسترداد \",\"\",\"\",G136,\" وثيقة\"),IF(V136=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V138=\"\",$C$203>(SUM(S136,E137)-SUM(K137))/(SUM(Q136,C137)-SUM(G137)),V137>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q136,C137)-SUM(G137))*$C$203)-((SUM(Q136,C137)-SUM(G137))*(R136)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C137>0,CONCATENATE(\"شراء \",\"\",\"\",C137,\" وثيقة\"),IF(G137>0,CONCATENATE(\"إسترداد \",\"\",\"\",G137,\" وثيقة\"),IF(V137=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V139=\"\",$C$203>(SUM(S137,E138)-SUM(K138))/(SUM(Q137,C138)-SUM(G138)),V138>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q137,C138)-SUM(G138))*$C$203)-((SUM(Q137,C138)-SUM(G138))*(R137)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C138>0,CONCATENATE(\"شراء \",\"\",\"\",C138,\" وثيقة\"),IF(G138>0,CONCATENATE(\"إسترداد \",\"\",\"\",G138,\" وثيقة\"),IF(V138=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V140=\"\",$C$203>(SUM(S138,E139)-SUM(K139))/(SUM(Q138,C139)-SUM(G139)),V139>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q138,C139)-SUM(G139))*$C$203)-((SUM(Q138,C139)-SUM(G139))*(R138)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C139>0,CONCATENATE(\"شراء \",\"\",\"\",C139,\" وثيقة\"),IF(G139>0,CONCATENATE(\"إسترداد \",\"\",\"\",G139,\" وثيقة\"),IF(V139=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V141=\"\",$C$203>(SUM(S139,E140)-SUM(K140))/(SUM(Q139,C140)-SUM(G140)),V140>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q139,C140)-SUM(G140))*$C$203)-((SUM(Q139,C140)-SUM(G140))*(R139)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C140>0,CONCATENATE(\"شراء \",\"\",\"\",C140,\" وثيقة\"),IF(G140>0,CONCATENATE(\"إسترداد \",\"\",\"\",G140,\" وثيقة\"),IF(V140=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V142=\"\",$C$203>(SUM(S140,E141)-SUM(K141))/(SUM(Q140,C141)-SUM(G141)),V141>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q140,C141)-SUM(G141))*$C$203)-((SUM(Q140,C141)-SUM(G141))*(R140)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C141>0,CONCATENATE(\"شراء \",\"\",\"\",C141,\" وثيقة\"),IF(G141>0,CONCATENATE(\"إسترداد \",\"\",\"\",G141,\" وثيقة\"),IF(V141=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V143=\"\",$C$203>(SUM(S141,E142)-SUM(K142))/(SUM(Q141,C142)-SUM(G142)),V142>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q141,C142)-SUM(G142))*$C$203)-((SUM(Q141,C142)-SUM(G142))*(R141)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C142>0,CONCATENATE(\"شراء \",\"\",\"\",C142,\" وثيقة\"),IF(G142>0,CONCATENATE(\"إسترداد \",\"\",\"\",G142,\" وثيقة\"),IF(V142=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V144=\"\",$C$203>(SUM(S142,E143)-SUM(K143))/(SUM(Q142,C143)-SUM(G143)),V143>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q142,C143)-SUM(G143))*$C$203)-((SUM(Q142,C143)-SUM(G143))*(R142)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C143>0,CONCATENATE(\"شراء \",\"\",\"\",C143,\" وثيقة\"),IF(G143>0,CONCATENATE(\"إسترداد \",\"\",\"\",G143,\" وثيقة\"),IF(V143=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V145=\"\",$C$203>(SUM(S143,E144)-SUM(K144))/(SUM(Q143,C144)-SUM(G144)),V144>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q143,C144)-SUM(G144))*$C$203)-((SUM(Q143,C144)-SUM(G144))*(R143)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C144>0,CONCATENATE(\"شراء \",\"\",\"\",C144,\" وثيقة\"),IF(G144>0,CONCATENATE(\"إسترداد \",\"\",\"\",G144,\" وثيقة\"),IF(V144=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V146=\"\",$C$203>(SUM(S144,E145)-SUM(K145))/(SUM(Q144,C145)-SUM(G145)),V145>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q144,C145)-SUM(G145))*$C$203)-((SUM(Q144,C145)-SUM(G145))*(R144)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C145>0,CONCATENATE(\"شراء \",\"\",\"\",C145,\" وثيقة\"),IF(G145>0,CONCATENATE(\"إسترداد \",\"\",\"\",G145,\" وثيقة\"),IF(V145=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V147=\"\",$C$203>(SUM(S145,E146)-SUM(K146))/(SUM(Q145,C146)-SUM(G146)),V146>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q145,C146)-SUM(G146))*$C$203)-((SUM(Q145,C146)-SUM(G146))*(R145)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C146>0,CONCATENATE(\"شراء \",\"\",\"\",C146,\" وثيقة\"),IF(G146>0,CONCATENATE(\"إسترداد \",\"\",\"\",G146,\" وثيقة\"),IF(V146=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V148=\"\",$C$203>(SUM(S146,E147)-SUM(K147))/(SUM(Q146,C147)-SUM(G147)),V147>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q146,C147)-SUM(G147))*$C$203)-((SUM(Q146,C147)-SUM(G147))*(R146)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C147>0,CONCATENATE(\"شراء \",\"\",\"\",C147,\" وثيقة\"),IF(G147>0,CONCATENATE(\"إسترداد \",\"\",\"\",G147,\" وثيقة\"),IF(V147=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V149=\"\",$C$203>(SUM(S147,E148)-SUM(K148))/(SUM(Q147,C148)-SUM(G148)),V148>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q147,C148)-SUM(G148))*$C$203)-((SUM(Q147,C148)-SUM(G148))*(R147)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C148>0,CONCATENATE(\"شراء \",\"\",\"\",C148,\" وثيقة\"),IF(G148>0,CONCATENATE(\"إسترداد \",\"\",\"\",G148,\" وثيقة\"),IF(V148=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V150=\"\",$C$203>(SUM(S148,E149)-SUM(K149))/(SUM(Q148,C149)-SUM(G149)),V149>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q148,C149)-SUM(G149))*$C$203)-((SUM(Q148,C149)-SUM(G149))*(R148)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C149>0,CONCATENATE(\"شراء \",\"\",\"\",C149,\" وثيقة\"),IF(G149>0,CONCATENATE(\"إسترداد \",\"\",\"\",G149,\" وثيقة\"),IF(V149=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V151=\"\",$C$203>(SUM(S149,E150)-SUM(K150))/(SUM(Q149,C150)-SUM(G150)),V150>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q149,C150)-SUM(G150))*$C$203)-((SUM(Q149,C150)-SUM(G150))*(R149)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C150>0,CONCATENATE(\"شراء \",\"\",\"\",C150,\" وثيقة\"),IF(G150>0,CONCATENATE(\"إسترداد \",\"\",\"\",G150,\" وثيقة\"),IF(V150=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V152=\"\",$C$203>(SUM(S150,E151)-SUM(K151))/(SUM(Q150,C151)-SUM(G151)),V151>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q150,C151)-SUM(G151))*$C$203)-((SUM(Q150,C151)-SUM(G151))*(R150)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C151>0,CONCATENATE(\"شراء \",\"\",\"\",C151,\" وثيقة\"),IF(G151>0,CONCATENATE(\"إسترداد \",\"\",\"\",G151,\" وثيقة\"),IF(V151=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},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":""},{"$f":"IFERROR(IF(AND(V153=\"\",$C$203>(SUM(S151,E152)-SUM(K152))/(SUM(Q151,C152)-SUM(G152)),V152>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q151,C152)-SUM(G152))*$C$203)-((SUM(Q151,C152)-SUM(G152))*(R151)),\"\"),\"\")","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,{"$f":"IF(C152>0,CONCATENATE(\"شراء \",\"\",\"\",C152,\" وثيقة\"),IF(G152>0,CONCATENATE(\"إسترداد \",\"\",\"\",G152,\" وثيقة\"),IF(V152=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V154=\"\",$C$203>(SUM(S152,E153)-SUM(K153))/(SUM(Q152,C153)-SUM(G153)),V153>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q152,C153)-SUM(G153))*$C$203)-((SUM(Q152,C153)-SUM(G153))*(R152)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C153>0,CONCATENATE(\"شراء \",\"\",\"\",C153,\" وثيقة\"),IF(G153>0,CONCATENATE(\"إسترداد \",\"\",\"\",G153,\" وثيقة\"),IF(V153=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V155=\"\",$C$203>(SUM(S153,E154)-SUM(K154))/(SUM(Q153,C154)-SUM(G154)),V154>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q153,C154)-SUM(G154))*$C$203)-((SUM(Q153,C154)-SUM(G154))*(R153)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C154>0,CONCATENATE(\"شراء \",\"\",\"\",C154,\" وثيقة\"),IF(G154>0,CONCATENATE(\"إسترداد \",\"\",\"\",G154,\" وثيقة\"),IF(V154=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V156=\"\",$C$203>(SUM(S154,E155)-SUM(K155))/(SUM(Q154,C155)-SUM(G155)),V155>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q154,C155)-SUM(G155))*$C$203)-((SUM(Q154,C155)-SUM(G155))*(R154)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C155>0,CONCATENATE(\"شراء \",\"\",\"\",C155,\" وثيقة\"),IF(G155>0,CONCATENATE(\"إسترداد \",\"\",\"\",G155,\" وثيقة\"),IF(V155=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V157=\"\",$C$203>(SUM(S155,E156)-SUM(K156))/(SUM(Q155,C156)-SUM(G156)),V156>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q155,C156)-SUM(G156))*$C$203)-((SUM(Q155,C156)-SUM(G156))*(R155)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C156>0,CONCATENATE(\"شراء \",\"\",\"\",C156,\" وثيقة\"),IF(G156>0,CONCATENATE(\"إسترداد \",\"\",\"\",G156,\" وثيقة\"),IF(V156=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V158=\"\",$C$203>(SUM(S156,E157)-SUM(K157))/(SUM(Q156,C157)-SUM(G157)),V157>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q156,C157)-SUM(G157))*$C$203)-((SUM(Q156,C157)-SUM(G157))*(R156)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C157>0,CONCATENATE(\"شراء \",\"\",\"\",C157,\" وثيقة\"),IF(G157>0,CONCATENATE(\"إسترداد \",\"\",\"\",G157,\" وثيقة\"),IF(V157=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V159=\"\",$C$203>(SUM(S157,E158)-SUM(K158))/(SUM(Q157,C158)-SUM(G158)),V158>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q157,C158)-SUM(G158))*$C$203)-((SUM(Q157,C158)-SUM(G158))*(R157)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C158>0,CONCATENATE(\"شراء \",\"\",\"\",C158,\" وثيقة\"),IF(G158>0,CONCATENATE(\"إسترداد \",\"\",\"\",G158,\" وثيقة\"),IF(V158=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V160=\"\",$C$203>(SUM(S158,E159)-SUM(K159))/(SUM(Q158,C159)-SUM(G159)),V159>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q158,C159)-SUM(G159))*$C$203)-((SUM(Q158,C159)-SUM(G159))*(R158)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C159>0,CONCATENATE(\"شراء \",\"\",\"\",C159,\" وثيقة\"),IF(G159>0,CONCATENATE(\"إسترداد \",\"\",\"\",G159,\" وثيقة\"),IF(V159=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V161=\"\",$C$203>(SUM(S159,E160)-SUM(K160))/(SUM(Q159,C160)-SUM(G160)),V160>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q159,C160)-SUM(G160))*$C$203)-((SUM(Q159,C160)-SUM(G160))*(R159)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C160>0,CONCATENATE(\"شراء \",\"\",\"\",C160,\" وثيقة\"),IF(G160>0,CONCATENATE(\"إسترداد \",\"\",\"\",G160,\" وثيقة\"),IF(V160=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V162=\"\",$C$203>(SUM(S160,E161)-SUM(K161))/(SUM(Q160,C161)-SUM(G161)),V161>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q160,C161)-SUM(G161))*$C$203)-((SUM(Q160,C161)-SUM(G161))*(R160)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C161>0,CONCATENATE(\"شراء \",\"\",\"\",C161,\" وثيقة\"),IF(G161>0,CONCATENATE(\"إسترداد \",\"\",\"\",G161,\" وثيقة\"),IF(V161=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V163=\"\",$C$203>(SUM(S161,E162)-SUM(K162))/(SUM(Q161,C162)-SUM(G162)),V162>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q161,C162)-SUM(G162))*$C$203)-((SUM(Q161,C162)-SUM(G162))*(R161)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C162>0,CONCATENATE(\"شراء \",\"\",\"\",C162,\" وثيقة\"),IF(G162>0,CONCATENATE(\"إسترداد \",\"\",\"\",G162,\" وثيقة\"),IF(V162=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V164=\"\",$C$203>(SUM(S162,E163)-SUM(K163))/(SUM(Q162,C163)-SUM(G163)),V163>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q162,C163)-SUM(G163))*$C$203)-((SUM(Q162,C163)-SUM(G163))*(R162)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C163>0,CONCATENATE(\"شراء \",\"\",\"\",C163,\" وثيقة\"),IF(G163>0,CONCATENATE(\"إسترداد \",\"\",\"\",G163,\" وثيقة\"),IF(V163=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V165=\"\",$C$203>(SUM(S163,E164)-SUM(K164))/(SUM(Q163,C164)-SUM(G164)),V164>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q163,C164)-SUM(G164))*$C$203)-((SUM(Q163,C164)-SUM(G164))*(R163)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C164>0,CONCATENATE(\"شراء \",\"\",\"\",C164,\" وثيقة\"),IF(G164>0,CONCATENATE(\"إسترداد \",\"\",\"\",G164,\" وثيقة\"),IF(V164=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},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,{"$f":"IF(C165>0,CONCATENATE(\"شراء \",\"\",\"\",C165,\" وثيقة\"),IF(G165>0,CONCATENATE(\"إسترداد \",\"\",\"\",G165,\" وثيقة\"),IF(V165=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V167=\"\",$C$203>(SUM(S165,E166)-SUM(K166))/(SUM(Q165,C166)-SUM(G166)),V166>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q165,C166)-SUM(G166))*$C$203)-((SUM(Q165,C166)-SUM(G166))*(R165)),\"\"),\"\")","v":""},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,"","",{"$f":"IFERROR(IF(AND(V168=\"\",$C$203>(SUM(S166,E167)-SUM(K167))/(SUM(Q166,C167)-SUM(G167)),V167>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q166,C167)-SUM(G167))*$C$203)-((SUM(Q166,C167)-SUM(G167))*(R166)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C167>0,CONCATENATE(\"شراء \",\"\",\"\",C167,\" وثيقة\"),IF(G167>0,CONCATENATE(\"إسترداد \",\"\",\"\",G167,\" وثيقة\"),IF(V167=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V169=\"\",$C$203>(SUM(S167,E168)-SUM(K168))/(SUM(Q167,C168)-SUM(G168)),V168>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q167,C168)-SUM(G168))*$C$203)-((SUM(Q167,C168)-SUM(G168))*(R167)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C168>0,CONCATENATE(\"شراء \",\"\",\"\",C168,\" وثيقة\"),IF(G168>0,CONCATENATE(\"إسترداد \",\"\",\"\",G168,\" وثيقة\"),IF(V168=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V170=\"\",$C$203>(SUM(S168,E169)-SUM(K169))/(SUM(Q168,C169)-SUM(G169)),V169>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q168,C169)-SUM(G169))*$C$203)-((SUM(Q168,C169)-SUM(G169))*(R168)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C169>0,CONCATENATE(\"شراء \",\"\",\"\",C169,\" وثيقة\"),IF(G169>0,CONCATENATE(\"إسترداد \",\"\",\"\",G169,\" وثيقة\"),IF(V169=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V171=\"\",$C$203>(SUM(S169,E170)-SUM(K170))/(SUM(Q169,C170)-SUM(G170)),V170>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q169,C170)-SUM(G170))*$C$203)-((SUM(Q169,C170)-SUM(G170))*(R169)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C170>0,CONCATENATE(\"شراء \",\"\",\"\",C170,\" وثيقة\"),IF(G170>0,CONCATENATE(\"إسترداد \",\"\",\"\",G170,\" وثيقة\"),IF(V170=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V172=\"\",$C$203>(SUM(S170,E171)-SUM(K171))/(SUM(Q170,C171)-SUM(G171)),V171>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q170,C171)-SUM(G171))*$C$203)-((SUM(Q170,C171)-SUM(G171))*(R170)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C171>0,CONCATENATE(\"شراء \",\"\",\"\",C171,\" وثيقة\"),IF(G171>0,CONCATENATE(\"إسترداد \",\"\",\"\",G171,\" وثيقة\"),IF(V171=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V173=\"\",$C$203>(SUM(S171,E172)-SUM(K172))/(SUM(Q171,C172)-SUM(G172)),V172>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q171,C172)-SUM(G172))*$C$203)-((SUM(Q171,C172)-SUM(G172))*(R171)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C172>0,CONCATENATE(\"شراء \",\"\",\"\",C172,\" وثيقة\"),IF(G172>0,CONCATENATE(\"إسترداد \",\"\",\"\",G172,\" وثيقة\"),IF(V172=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V174=\"\",$C$203>(SUM(S172,E173)-SUM(K173))/(SUM(Q172,C173)-SUM(G173)),V173>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q172,C173)-SUM(G173))*$C$203)-((SUM(Q172,C173)-SUM(G173))*(R172)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C173>0,CONCATENATE(\"شراء \",\"\",\"\",C173,\" وثيقة\"),IF(G173>0,CONCATENATE(\"إسترداد \",\"\",\"\",G173,\" وثيقة\"),IF(V173=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V175=\"\",$C$203>(SUM(S173,E174)-SUM(K174))/(SUM(Q173,C174)-SUM(G174)),V174>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q173,C174)-SUM(G174))*$C$203)-((SUM(Q173,C174)-SUM(G174))*(R173)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C174>0,CONCATENATE(\"شراء \",\"\",\"\",C174,\" وثيقة\"),IF(G174>0,CONCATENATE(\"إسترداد \",\"\",\"\",G174,\" وثيقة\"),IF(V174=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V176=\"\",$C$203>(SUM(S174,E175)-SUM(K175))/(SUM(Q174,C175)-SUM(G175)),V175>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q174,C175)-SUM(G175))*$C$203)-((SUM(Q174,C175)-SUM(G175))*(R174)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C175>0,CONCATENATE(\"شراء \",\"\",\"\",C175,\" وثيقة\"),IF(G175>0,CONCATENATE(\"إسترداد \",\"\",\"\",G175,\" وثيقة\"),IF(V175=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V177=\"\",$C$203>(SUM(S175,E176)-SUM(K176))/(SUM(Q175,C176)-SUM(G176)),V176>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q175,C176)-SUM(G176))*$C$203)-((SUM(Q175,C176)-SUM(G176))*(R175)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C176>0,CONCATENATE(\"شراء \",\"\",\"\",C176,\" وثيقة\"),IF(G176>0,CONCATENATE(\"إسترداد \",\"\",\"\",G176,\" وثيقة\"),IF(V176=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V178=\"\",$C$203>(SUM(S176,E177)-SUM(K177))/(SUM(Q176,C177)-SUM(G177)),V177>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q176,C177)-SUM(G177))*$C$203)-((SUM(Q176,C177)-SUM(G177))*(R176)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C177>0,CONCATENATE(\"شراء \",\"\",\"\",C177,\" وثيقة\"),IF(G177>0,CONCATENATE(\"إسترداد \",\"\",\"\",G177,\" وثيقة\"),IF(V177=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V179=\"\",$C$203>(SUM(S177,E178)-SUM(K178))/(SUM(Q177,C178)-SUM(G178)),V178>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q177,C178)-SUM(G178))*$C$203)-((SUM(Q177,C178)-SUM(G178))*(R177)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C178>0,CONCATENATE(\"شراء \",\"\",\"\",C178,\" وثيقة\"),IF(G178>0,CONCATENATE(\"إسترداد \",\"\",\"\",G178,\" وثيقة\"),IF(V178=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V180=\"\",$C$203>(SUM(S178,E179)-SUM(K179))/(SUM(Q178,C179)-SUM(G179)),V179>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q178,C179)-SUM(G179))*$C$203)-((SUM(Q178,C179)-SUM(G179))*(R178)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C179>0,CONCATENATE(\"شراء \",\"\",\"\",C179,\" وثيقة\"),IF(G179>0,CONCATENATE(\"إسترداد \",\"\",\"\",G179,\" وثيقة\"),IF(V179=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V181=\"\",$C$203>(SUM(S179,E180)-SUM(K180))/(SUM(Q179,C180)-SUM(G180)),V180>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q179,C180)-SUM(G180))*$C$203)-((SUM(Q179,C180)-SUM(G180))*(R179)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C180>0,CONCATENATE(\"شراء \",\"\",\"\",C180,\" وثيقة\"),IF(G180>0,CONCATENATE(\"إسترداد \",\"\",\"\",G180,\" وثيقة\"),IF(V180=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V182=\"\",$C$203>(SUM(S180,E181)-SUM(K181))/(SUM(Q180,C181)-SUM(G181)),V181>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q180,C181)-SUM(G181))*$C$203)-((SUM(Q180,C181)-SUM(G181))*(R180)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C181>0,CONCATENATE(\"شراء \",\"\",\"\",C181,\" وثيقة\"),IF(G181>0,CONCATENATE(\"إسترداد \",\"\",\"\",G181,\" وثيقة\"),IF(V181=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V183=\"\",$C$203>(SUM(S181,E182)-SUM(K182))/(SUM(Q181,C182)-SUM(G182)),V182>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q181,C182)-SUM(G182))*$C$203)-((SUM(Q181,C182)-SUM(G182))*(R181)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C182>0,CONCATENATE(\"شراء \",\"\",\"\",C182,\" وثيقة\"),IF(G182>0,CONCATENATE(\"إسترداد \",\"\",\"\",G182,\" وثيقة\"),IF(V182=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V184=\"\",$C$203>(SUM(S182,E183)-SUM(K183))/(SUM(Q182,C183)-SUM(G183)),V183>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q182,C183)-SUM(G183))*$C$203)-((SUM(Q182,C183)-SUM(G183))*(R182)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C183>0,CONCATENATE(\"شراء \",\"\",\"\",C183,\" وثيقة\"),IF(G183>0,CONCATENATE(\"إسترداد \",\"\",\"\",G183,\" وثيقة\"),IF(V183=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V185=\"\",$C$203>(SUM(S183,E184)-SUM(K184))/(SUM(Q183,C184)-SUM(G184)),V184>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q183,C184)-SUM(G184))*$C$203)-((SUM(Q183,C184)-SUM(G184))*(R183)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C184>0,CONCATENATE(\"شراء \",\"\",\"\",C184,\" وثيقة\"),IF(G184>0,CONCATENATE(\"إسترداد \",\"\",\"\",G184,\" وثيقة\"),IF(V184=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V186=\"\",$C$203>(SUM(S184,E185)-SUM(K185))/(SUM(Q184,C185)-SUM(G185)),V185>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q184,C185)-SUM(G185))*$C$203)-((SUM(Q184,C185)-SUM(G185))*(R184)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C185>0,CONCATENATE(\"شراء \",\"\",\"\",C185,\" وثيقة\"),IF(G185>0,CONCATENATE(\"إسترداد \",\"\",\"\",G185,\" وثيقة\"),IF(V185=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V187=\"\",$C$203>(SUM(S185,E186)-SUM(K186))/(SUM(Q185,C186)-SUM(G186)),V186>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q185,C186)-SUM(G186))*$C$203)-((SUM(Q185,C186)-SUM(G186))*(R185)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C186>0,CONCATENATE(\"شراء \",\"\",\"\",C186,\" وثيقة\"),IF(G186>0,CONCATENATE(\"إسترداد \",\"\",\"\",G186,\" وثيقة\"),IF(V186=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V188=\"\",$C$203>(SUM(S186,E187)-SUM(K187))/(SUM(Q186,C187)-SUM(G187)),V187>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q186,C187)-SUM(G187))*$C$203)-((SUM(Q186,C187)-SUM(G187))*(R186)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C187>0,CONCATENATE(\"شراء \",\"\",\"\",C187,\" وثيقة\"),IF(G187>0,CONCATENATE(\"إسترداد \",\"\",\"\",G187,\" وثيقة\"),IF(V187=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V189=\"\",$C$203>(SUM(S187,E188)-SUM(K188))/(SUM(Q187,C188)-SUM(G188)),V188>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q187,C188)-SUM(G188))*$C$203)-((SUM(Q187,C188)-SUM(G188))*(R187)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C188>0,CONCATENATE(\"شراء \",\"\",\"\",C188,\" وثيقة\"),IF(G188>0,CONCATENATE(\"إسترداد \",\"\",\"\",G188,\" وثيقة\"),IF(V188=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V190=\"\",$C$203>(SUM(S188,E189)-SUM(K189))/(SUM(Q188,C189)-SUM(G189)),V189>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q188,C189)-SUM(G189))*$C$203)-((SUM(Q188,C189)-SUM(G189))*(R188)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C189>0,CONCATENATE(\"شراء \",\"\",\"\",C189,\" وثيقة\"),IF(G189>0,CONCATENATE(\"إسترداد \",\"\",\"\",G189,\" وثيقة\"),IF(V189=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,{"$f":"IFERROR(IF(G190>0,ROUND(G190*R189,2),\"\"),\"\")","v":""},"",{"$f":"IFERROR(IF(AND(V191=\"\",$C$203>(SUM(S189,E190)-SUM(K190))/(SUM(Q189,C190)-SUM(G190)),V190>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q189,C190)-SUM(G190))*$C$203)-((SUM(Q189,C190)-SUM(G190))*(R189)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C190>0,CONCATENATE(\"شراء \",\"\",\"\",C190,\" وثيقة\"),IF(G190>0,CONCATENATE(\"إسترداد \",\"\",\"\",G190,\" وثيقة\"),IF(V190=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V192=\"\",$C$203>(SUM(S190,E191)-SUM(K191))/(SUM(Q190,C191)-SUM(G191)),V191>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q190,C191)-SUM(G191))*$C$203)-((SUM(Q190,C191)-SUM(G191))*(R190)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C191>0,CONCATENATE(\"شراء \",\"\",\"\",C191,\" وثيقة\"),IF(G191>0,CONCATENATE(\"إسترداد \",\"\",\"\",G191,\" وثيقة\"),IF(V191=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V193=\"\",$C$203>(SUM(S191,E192)-SUM(K192))/(SUM(Q191,C192)-SUM(G192)),V192>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q191,C192)-SUM(G192))*$C$203)-((SUM(Q191,C192)-SUM(G192))*(R191)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C192>0,CONCATENATE(\"شراء \",\"\",\"\",C192,\" وثيقة\"),IF(G192>0,CONCATENATE(\"إسترداد \",\"\",\"\",G192,\" وثيقة\"),IF(V192=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,{"$f":"IF(G193>0,ROUND(G193*H193,2),\"\")","v":""},null,"","",{"$f":"IFERROR(IF(AND(V194=\"\",$C$203>(SUM(S192,E193)-SUM(K193))/(SUM(Q192,C193)-SUM(G193)),V193>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q192,C193)-SUM(G193))*$C$203)-((SUM(Q192,C193)-SUM(G193))*(R192)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C193>0,CONCATENATE(\"شراء \",\"\",\"\",C193,\" وثيقة\"),IF(G193>0,CONCATENATE(\"إسترداد \",\"\",\"\",G193,\" وثيقة\"),IF(V193=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V195=\"\",$C$203>(SUM(S193,E194)-SUM(K194))/(SUM(Q193,C194)-SUM(G194)),V194>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q193,C194)-SUM(G194))*$C$203)-((SUM(Q193,C194)-SUM(G194))*(R193)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C194>0,CONCATENATE(\"شراء \",\"\",\"\",C194,\" وثيقة\"),IF(G194>0,CONCATENATE(\"إسترداد \",\"\",\"\",G194,\" وثيقة\"),IF(V194=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V196=\"\",$C$203>(SUM(S194,E195)-SUM(K195))/(SUM(Q194,C195)-SUM(G195)),V195>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q194,C195)-SUM(G195))*$C$203)-((SUM(Q194,C195)-SUM(G195))*(R194)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C195>0,CONCATENATE(\"شراء \",\"\",\"\",C195,\" وثيقة\"),IF(G195>0,CONCATENATE(\"إسترداد \",\"\",\"\",G195,\" وثيقة\"),IF(V195=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V197=\"\",$C$203>(SUM(S195,E196)-SUM(K196))/(SUM(Q195,C196)-SUM(G196)),V196>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q195,C196)-SUM(G196))*$C$203)-((SUM(Q195,C196)-SUM(G196))*(R195)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C196>0,CONCATENATE(\"شراء \",\"\",\"\",C196,\" وثيقة\"),IF(G196>0,CONCATENATE(\"إسترداد \",\"\",\"\",G196,\" وثيقة\"),IF(V196=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V198=\"\",$C$203>(SUM(S196,E197)-SUM(K197))/(SUM(Q196,C197)-SUM(G197)),V197>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q196,C197)-SUM(G197))*$C$203)-((SUM(Q196,C197)-SUM(G197))*(R196)),\"\"),\"\")","v":""},null,"",null,90,351.19155555555602,31607.24,null,{"$f":"IF(C197>0,CONCATENATE(\"شراء \",\"\",\"\",C197,\" وثيقة\"),IF(G197>0,CONCATENATE(\"إسترداد \",\"\",\"\",G197,\" وثيقة\"),IF(V197=DATE(YEAR($V$5),COLUMN($L$1)+1,0),CONCATENATE(\"إعادة تقييم رصيد الوثائق بسعر \",\"\",\"\",$U$37,\" جنية مصرى\"),\"\")))","v":""},null,null,""]
["",null,null,null,"",null,null,null,"",null,"","",{"$f":"IFERROR(IF(AND(V199=\"\",$C$203>(SUM(S197,E198)-SUM(K198))/(SUM(Q197,C198)-SUM(G198)),V198>=DATE(YEAR($V$5),COLUMN($L$1)+1,0)),((SUM(Q197,C198)-SUM(G198))*$C$203)-((SUM(Q197,C198)-SUM(G198))*(R197)),\"\"),\"\")","v":""},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}]