{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["ايرادات نقديه","Sheet4"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"ايرادات نقديه","index":0,"n_rows":18,"n_cols":13,"rows_kept":18,"cut":false,"hidden":false,"merged":[[17,1,17,4],[10,11,10,12],[10,2,10,7],[16,2,16,4],[13,5,13,6],[14,5,14,6],[15,5,15,6],[16,5,16,6],[17,5,17,7],[12,5,12,6],[12,2,12,4],[12,7,16,8],[13,2,13,4],[14,2,14,4],[15,2,15,4]]}
[{"$f":"H13&\"  \"&C14&\" & \"&C15&\"  & \"&C16&\" & \"&C17&\" جنيه\"","v":"0   &   &  &  جنيه"},null,"الفئه",1,2,3,4,5,"المجموع",null,"الفئه","عدد الاوراق","الاجمالي"]
[null,{"$f":"D2+E2+F2+G2+H2","v":0},500,null,null,null,null,null,{"$f":"D2*C2+E2*C2+C2*F2+G2*C2+H2*C2","v":0},null,200,{"$f":"TRUNC($F18/$K2)","v":0},{"$f":"K2*L2","v":0}]
[null,0,200,null,null,null,null,null,0,null,100,{"$f":"TRUNC(($F18-SUMPRODUCT($K$2:$K2,L$2:L2))/$K3)","v":0},0]
[null,0,100,null,null,null,null,null,0,null,50,{"$f":"TRUNC(($F$18-SUMPRODUCT($K$2:$K3,$L$2:L3))/K4)","v":0},0]
[null,0,50,null,null,null,null,null,{"$f":"D5*C5+E5*C5+C5*F5+G5*C5+H5*C5","v":0},null,20,{"$f":"TRUNC(($F$18-SUMPRODUCT($K$2:$K4,$L$2:L4))/K5)","v":0},0]
[null,0,20,null,null,null,null,null,0,null,10,{"$f":"TRUNC(($F$18-SUMPRODUCT($K$2:$K5,$L$2:L5))/K6)","v":0},0]
[null,0,10,null,null,null,null,null,0,null,5,{"$f":"TRUNC(($F$18-SUMPRODUCT($K$2:$K6,$L$2:L6))/K7)","v":0},0]
[null,0,5,null,null,null,null,null,0,null,1,{"$f":"TRUNC(($F$18-SUMPRODUCT($K$2:$K7,$L$2:L7))/K8)","v":0},0]
[null,0,1,null,null,null,null,null,0,null,0.5,{"$f":"TRUNC(($F$18-SUMPRODUCT($K$2:$K8,$L$2:L8))/K9)","v":0},0]
[]
[null,null,"الاجمالي",null,null,null,null,null,{"$f":"SUM(I2:I9)","v":0},null,"الباقي",{"$f":"SUMPRODUCT($K$2:$K$9,L2:L9)","v":0}]
[]
[null,"الايصال","الاسم",null,null,"المطلوب",null,{"$f":"SUM(F14:F17)","v":0}]
[]
[]
[]
[]
[null,{"$f":"IF(0<>\"\",IF(F18>0,\"لديه باقي\",\"مطلوب منه\"),\"\")","v":"مطلوب منه"},null,null,null,{"$f":"I11-H13","v":0}]

{"sheet":"Sheet4","index":1,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":false,"merged":[[17,1,17,3],[17,7,17,11],[17,12,17,14],[7,10,7,12],[8,10,8,12],[11,1,11,6],[13,1,16,3],[13,5,16,5],[13,7,13,14],[6,10,6,12],[1,9,1,12],[2,9,2,11],[2,12,2,13],[3,9,3,11],[3,12,3,13]]}
[]
[null,"الفئه",1,2,3,4,5,"المجموع",null,"عدد الاوراق",null,null,null,{"$f":"M4/M3","v":30}]
[{"$f":"C3+D3+E3+F3+G3","v":0},1,null,null,null,null,null,{"$f":"C3*B3+D3*B3+B3*E3+F3*B3+G3*B3","v":0},null,"الفئة",null,null,50]
[0,2,null,null,null,null,null,0,null,"اجمالي المبلغ",null,null,1500]
[1,5,null,null,null,1,null,5]
[0,10,null,null,null,null,null,{"$f":"C6*B6+D6*B6+B6*E6+F6*B6+G6*B6","v":0}]
[1,20,null,null,null,1,null,20,null,"الاوراق",66]
[102,50,null,null,100,2,null,5100,null,"النقصان",8]
[null,100,null,null,null,null,null,0,null,"الاجمالي",{"$f":"K7-K8","v":58}]
[null,200,null,null,null,null,null,0]
[]
[null,"الاجمالي",null,null,null,null,null,{"$f":"SUM(H3:H10)","v":5125}]
[]
[null,"المطلوب",null,null,1867,{"$f":"SUM(E14:E17)","v":1867},null,"الفـــــــــــــــــــــــــــــــــــــــــــــئات"]
[null,null,null,null,null,null,null,200,100,50,20,10,5,1,0.5]
[null,null,null,null,null,null,null,{"$f":"TRUNC($E18/H$15)","v":-16},{"$f":"TRUNC(($E18-SUMPRODUCT($H$15:H$15,$H16:H16))/I$15)","v":0},{"$f":"TRUNC(($E$18-SUMPRODUCT($H$15:I$15,$H$16:I16))/J15)","v":-1},{"$f":"TRUNC(($E$18-SUMPRODUCT($H$15:J$15,$H$16:J16))/K15)","v":0},{"$f":"TRUNC(($E$18-SUMPRODUCT($H$15:K$15,$H$16:K16))/L15)","v":0},{"$f":"TRUNC(($E$18-SUMPRODUCT($H$15:L$15,$H$16:L16))/M15)","v":-1},{"$f":"TRUNC(($E$18-SUMPRODUCT($H$15:M$15,$H$16:M16))/N15)","v":-3},{"$f":"TRUNC(($E$18-SUMPRODUCT($H$15:N$15,$H$16:N16))/O15)","v":0}]
[null,null,null,null,null,null,null,{"$f":"H15*H16","v":-3200},{"$f":"I15*I16","v":0},-50,0,0,-5,-3,0]
[null,"الفرق",null,null,{"$f":"F14-H12","v":-3258},{"$f":"IF(F14=H12,\"OK\",F14-H12)","v":-3258},null,"اجمالي الباقي",null,null,null,null,{"$f":"SUMPRODUCT($H$15:$O$15,H16:O16)","v":-3258}]