{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Accmove","يونيو","يوليو"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":3,"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":"Accmove","index":0,"n_rows":43,"n_cols":21,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COLUMN()","v":15},{"$f":"COLUMN()","v":16},{"$f":"COLUMN()","v":17},{"$f":"COLUMN()","v":18},{"$f":"COLUMN()","v":19}]
[0,"الرصيد",null,null,null,null,null,{"$f":"SUBTOTAL(9,H$4:$H89369)","v":2690},{"$f":"SUBTOTAL(9,$I$4:I89369)","v":2690},{"$f":"H2-I2","v":0},null,{"$f":"SUBTOTAL(9,L4:L5)","v":0},null,{"$f":"SUBTOTAL(9,N4:N5)","v":0}]
["م","كود االحساب","اسم الحساب","رقم امر التوريد","رقم الاذن","يدوي","تاريخ الحركة","مدين","دائن","الرصيد",null,"ض مبيعات",null,"ض ا ت ص","التصنيف","نوع الحركة","group","الاذن مسلسل","البيان","الشهر"]
[{"$f":"IF((A3)<>\"م\",(A3)+1,1)","v":1},2," مصطفى محمد سعد",null,null,null,"2022-01-01"," ",null,{"$f":"SUMIFS(H$4:H4,B$4:B4,B4)-SUMIFS(I$4:I4,B$4:B4,B4)","v":0},null,null,null,null,null,"انشاء حساب",{"$f":"CHOOSE(T4,\"يناير\",\"فبراير\",\"مارس\",\"ابريل\",\"مايو\",\"يونيو\",\"يوليو\",\"اغسطس\",\"سبتمبر\",\"اكتوبر\",\"نوفمبر\",\"ديسمبر\")","v":"يناير"},null,null,1]
[2,3," احمد عبد الستار",null,null,null,"2022-01-01"," ",null,{"$f":"SUMIFS(H$4:H5,B$4:B5,B5)-SUMIFS(I$4:I5,B$4:B5,B5)","v":0},null,null,null,null,null,"انشاء حساب",{"$f":"CHOOSE(T5,\"يناير\",\"فبراير\",\"مارس\",\"ابريل\",\"مايو\",\"يونيو\",\"يوليو\",\"اغسطس\",\"سبتمبر\",\"اكتوبر\",\"نوفمبر\",\"ديسمبر\")","v":"يناير"},null,null,1]
[3,4,"محمود انيس",null,null,null,"2022-01-01"," ",null,{"$f":"SUMIFS(H$4:H6,B$4:B6,B6)-SUMIFS(I$4:I6,B$4:B6,B6)","v":0},null,null,null,null,null,"انشاء حساب","يناير",null,null,1]
[4,5," محمود سعد",null,null,null,"2022-01-01"," ",null,{"$f":"SUMIFS(H$4:H7,B$4:B7,B7)-SUMIFS(I$4:I7,B$4:B7,B7)","v":0},null,null,null,null,null,"انشاء حساب","يناير",null,null,1]
[5,6,"شيماء يوسف",null,null,null,"2022-01-01"," ",null,{"$f":"SUMIFS(H$4:H8,B$4:B8,B8)-SUMIFS(I$4:I8,B$4:B8,B8)","v":0},null,null,null,null,null,"انشاء حساب","يناير",null,null,1]
[6,7,"سناء- عبد القادر",null,null,null,"2022-01-01"," ",null,{"$f":"SUMIFS(H$4:H9,B$4:B9,B9)-SUMIFS(I$4:I9,B$4:B9,B9)","v":0},null,null,null,null,null,"انشاء حساب","فبراير",null,null,2]
[7,8,"عبده عباس ابو السعود",null,null,null,"2022-01-01"," ",null,{"$f":"SUMIFS(H$4:H10,B$4:B10,B10)-SUMIFS(I$4:I10,B$4:B10,B10)","v":0},null,null,null,null,null,"انشاء حساب","فبراير",null,null,2]
[8,9,"فريد الحسينى الشبراوى",null,null,null,"2022-01-01"," ",null,{"$f":"SUMIFS(H$4:H11,B$4:B11,B11)-SUMIFS(I$4:I11,B$4:B11,B11)","v":0},null,null,null,null,null,"انشاء حساب","فبراير",null,null,2]
[9,10,"يحيى العجمى",null,null,null,"2022-01-01"," ",null,{"$f":"SUMIFS(H$4:H12,B$4:B12,B12)-SUMIFS(I$4:I12,B$4:B12,B12)","v":0},null,null,null,null,null,"انشاء حساب","فبراير",null,null,2]
[10,11,"ابراهيم محمد ابراهيم",null,null,null,"2022-01-01"," ",null,{"$f":"SUMIFS(H$4:H13,B$4:B13,B13)-SUMIFS(I$4:I13,B$4:B13,B13)","v":0},null,null,null,null,null,"انشاء حساب","فبراير",null,null,2]
[11,12,"عبد العزيز بشير",null,null,null,"2022-01-01"," ",null,{"$f":"SUMIFS(H$4:H14,B$4:B14,B14)-SUMIFS(I$4:I14,B$4:B14,B14)","v":0},null,null,null,null,null,"انشاء حساب","فبراير",null,null,2]
[12,13,"محمود محمد الشيخ",null,null,null,"2022-01-01"," ",null,{"$f":"SUMIFS(H$4:H15,B$4:B15,B15)-SUMIFS(I$4:I15,B$4:B15,B15)","v":0},null,null,null,null,null,"انشاء حساب","مارس",null,null,3]
[13,14," احمد محمد احمد متولى",null,null,null,"2022-01-01"," ",null,{"$f":"SUMIFS(H$4:H16,B$4:B16,B16)-SUMIFS(I$4:I16,B$4:B16,B16)","v":0},null,null,null,null,null,"انشاء حساب","مارس",null,null,3]
[14,15,"اسلام اجمد زكى",null,null,null,"2022-01-01"," ",null,{"$f":"SUMIFS(H$4:H17,B$4:B17,B17)-SUMIFS(I$4:I17,B$4:B17,B17)","v":0},null,null,null,null,null,"انشاء حساب","مارس",null,null,3]
[15,16," محمد سيد محمود",null,null,null,"2022-01-01"," ",null,{"$f":"SUMIFS(H$4:H18,B$4:B18,B18)-SUMIFS(I$4:I18,B$4:B18,B18)","v":0},null,null,null,null,null,"انشاء حساب","مارس",null,null,3]
[16,17,"يونس ابو عمار",null,null,null,"2022-01-01"," ",null,{"$f":"SUMIFS(H$4:H19,B$4:B19,B19)-SUMIFS(I$4:I19,B$4:B19,B19)","v":0},null,null,null,null,null,"انشاء حساب","مارس",null,null,3]
[17,18,"محمد طه الصنانى",null,null,null,"2022-01-01"," ",null,{"$f":"SUMIFS(H$4:H20,B$4:B20,B20)-SUMIFS(I$4:I20,B$4:B20,B20)","v":0},null,null,null,null,null,"انشاء حساب","مارس",null,null,3]
[18,19,"هانى حسين",null,null,null,"2022-01-01"," ",null,{"$f":"SUMIFS(H$4:H21,B$4:B21,B21)-SUMIFS(I$4:I21,B$4:B21,B21)","v":0},null,null,null,null,null,"انشاء حساب","ابريل",null,null,4]
[19,20," محمود رائد الاردنى",null,null,null,"2022-01-01"," ",null,{"$f":"SUMIFS(H$4:H22,B$4:B22,B22)-SUMIFS(I$4:I22,B$4:B22,B22)","v":0},null,null,null,null,null,"انشاء حساب","ابريل",null,null,4]
[20,21,"ابراهيم رمضان ابو العنبن",null,null,null,"2022-01-01"," ",null,{"$f":"SUMIFS(H$4:H23,B$4:B23,B23)-SUMIFS(I$4:I23,B$4:B23,B23)","v":0},null,null,null,null,null,"انشاء حساب","ابريل",null,null,4]
[21,22," ياسر الكفراوى",null,null,null,"2022-01-01"," ",null,{"$f":"SUMIFS(H$4:H24,B$4:B24,B24)-SUMIFS(I$4:I24,B$4:B24,B24)","v":0},null,null,null,null,null,"انشاء حساب","مايو",null,null,5]
[22,23," عبد الرحمن جمال",null,null,null,"2022-01-01"," ",null,{"$f":"SUMIFS(H$4:H25,B$4:B25,B25)-SUMIFS(I$4:I25,B$4:B25,B25)","v":0},null,null,null,null,null,"انشاء حساب","مايو",null,null,5]
[23,24,"test1",null,null,null,"2022-01-01"," ",null,{"$f":"SUMIFS(H$4:H26,B$4:B26,B26)-SUMIFS(I$4:I26,B$4:B26,B26)","v":0},null,null,null,null,null,"انشاء حساب","مايو",null,null,5]
[24,{"$f":"VLOOKUP(Accmove!C27,[1]acc!C:K,9,FALSE)","v":2}," مصطفى محمد سعد",null,1,null,"2022-06-25",1200,null,{"$f":"SUMIFS(H$4:H27,B$4:B27,B27)-SUMIFS(I$4:I27,B$4:B27,B27)","v":1200},null,null,null,null,{"$f":"VLOOKUP(B27,[1]acc!B:I,8,FALSE)","v":"cust"},"بيع اجل","يونيو",null,null,{"$f":"IF(ISBLANK(G27),0,MONTH(G27))","v":6}]
[25,1,"test1",null,1,null,"2022-06-25",null,1200,{"$f":"SUMIFS(H$4:H28,B$4:B28,B28)-SUMIFS(I$4:I28,B$4:B28,B28)","v":-1200},null,null,null,null,{"$f":"VLOOKUP(B28,[1]acc!B:I,8,FALSE)","v":"صندوق"},"بيع اجل","يونيو",null,null,6]
[26,{"$f":"VLOOKUP(Accmove!C29,[1]acc!C:K,9,FALSE)","v":2}," مصطفى محمد سعد",null,1,null,"24/6/2022",null,120,{"$f":"SUMIFS(H$4:H29,B$4:B29,B29)-SUMIFS(I$4:I29,B$4:B29,B29)","v":1080},null,null,null,null,{"$f":"VLOOKUP(B29,[1]acc!B:I,8,FALSE)","v":"cust"},"سداد دفعة","يونيو",null,null,6]
[27,{"$f":"VLOOKUP(Accmove!C30,[1]acc!C:K,9,FALSE)","v":1},"ح/صندوق الاقساط",null,1,null,"24/6/2022",120,null,{"$f":"SUMIFS(H$4:H30,B$4:B30,B30)-SUMIFS(I$4:I30,B$4:B30,B30)","v":-1080},null,null,null,null,{"$f":"VLOOKUP(B30,[1]acc!B:I,8,FALSE)","v":"صندوق"},"استلام قسط","يونيو",null,null,6]
[28,{"$f":"VLOOKUP(Accmove!C31,[1]acc!C:K,9,FALSE)","v":2}," مصطفى محمد سعد",null,1,null,"2022-07-05",null,120,{"$f":"SUMIFS(H$4:H31,B$4:B31,B31)-SUMIFS(I$4:I31,B$4:B31,B31)","v":960},null,null,null,null,{"$f":"VLOOKUP(B31,[1]acc!B:I,8,FALSE)","v":"cust"},"سداد دفعة","يوليو",null,null,7]
[29,{"$f":"VLOOKUP(Accmove!C32,[1]acc!C:K,9,FALSE)","v":1},"ح/صندوق الاقساط",null,1,null,"2022-07-05",120,null,{"$f":"SUMIFS(H$4:H32,B$4:B32,B32)-SUMIFS(I$4:I32,B$4:B32,B32)","v":-960},null,null,null,null,{"$f":"VLOOKUP(B32,[1]acc!B:I,8,FALSE)","v":"صندوق"},"استلام قسط","يوليو",null,null,7]
[30,{"$f":"VLOOKUP(Accmove!C33,[1]acc!C:K,9,FALSE)","v":2}," مصطفى محمد سعد",null,5,null,"2022-07-05",null,160,{"$f":"SUMIFS(H$4:H33,B$4:B33,B33)-SUMIFS(I$4:I33,B$4:B33,B33)","v":800},null,null,null,null,{"$f":"VLOOKUP(B33,[1]acc!B:I,8,FALSE)","v":"cust"},"سداد دفعة","يوليو",null,null,7]
[31,{"$f":"VLOOKUP(Accmove!C34,[1]acc!C:K,9,FALSE)","v":1},"ح/صندوق الاقساط",null,5,null,"2022-07-05",160,null,{"$f":"SUMIFS(H$4:H34,B$4:B34,B34)-SUMIFS(I$4:I34,B$4:B34,B34)","v":-800},null,null,null,null,{"$f":"VLOOKUP(B34,[1]acc!B:I,8,FALSE)","v":"صندوق"},"استلام قسط","يوليو",null,null,7]
[32,{"$f":"VLOOKUP(Accmove!C35,[1]acc!C:K,9,FALSE)","v":2}," مصطفى محمد سعد",null,null,null,"2022-07-05",null,170,{"$f":"SUMIFS(H$4:H35,B$4:B35,B35)-SUMIFS(I$4:I35,B$4:B35,B35)","v":630},null,null,null,null,{"$f":"VLOOKUP(B35,[1]acc!B:I,8,FALSE)","v":"cust"},"سداد دفعة","يوليو",null,null,7]
[33,{"$f":"VLOOKUP(Accmove!C36,[1]acc!C:K,9,FALSE)","v":1},"ح/صندوق الاقساط",null,null,null,"2022-07-05",170,null,{"$f":"SUMIFS(H$4:H36,B$4:B36,B36)-SUMIFS(I$4:I36,B$4:B36,B36)","v":-630},null,null,null,null,{"$f":"VLOOKUP(B36,[1]acc!B:I,8,FALSE)","v":"صندوق"},"استلام قسط","يوليو",null,null,7]
[34,{"$f":"VLOOKUP(Accmove!C37,[1]acc!C:K,9,FALSE)","v":2}," مصطفى محمد سعد",null,7,null,"2022-07-05",null,200,{"$f":"SUMIFS(H$4:H37,B$4:B37,B37)-SUMIFS(I$4:I37,B$4:B37,B37)","v":430},null,null,null,null,{"$f":"VLOOKUP(B37,[1]acc!B:I,8,FALSE)","v":"cust"},"سداد دفعة","يوليو",null,null,7]
[35,{"$f":"VLOOKUP(Accmove!C38,[1]acc!C:K,9,FALSE)","v":1},"ح/صندوق الاقساط",null,7,null,"2022-07-05",200,null,{"$f":"SUMIFS(H$4:H38,B$4:B38,B38)-SUMIFS(I$4:I38,B$4:B38,B38)","v":-430},null,null,null,null,{"$f":"VLOOKUP(B38,[1]acc!B:I,8,FALSE)","v":"صندوق"},"استلام قسط","يوليو",null,null,7]
[{"$f":"IF((A38)<>\"م\",(A38)+1,1)","v":36},{"$f":"VLOOKUP(Accmove!C39,[1]acc!C:K,9,FALSE)","v":24},"test1",null,8,null,"2022-07-05",700,null,{"$f":"SUMIFS(H$4:H39,B$4:B39,B39)-SUMIFS(I$4:I39,B$4:B39,B39)","v":700},null,null,null,null,{"$f":"VLOOKUP(B39,[1]acc!B:I,8,FALSE)","v":"fina"},"سداد للممول","يوليو",null,null,7]
[{"$f":"IF((A39)<>\"م\",(A39)+1,1)","v":37},{"$f":"VLOOKUP(Accmove!C40,[1]acc!C:K,9,FALSE)","v":1},"ح/صندوق الاقساط",null,8,null,"2022-07-05",null,700,{"$f":"SUMIFS(H$4:H40,B$4:B40,B40)-SUMIFS(I$4:I40,B$4:B40,B40)","v":-1130},null,null,null,null,{"$f":"VLOOKUP(B40,[1]acc!B:I,8,FALSE)","v":"صندوق"},"سداد للممول","يوليو",null,null,7]
[{"$f":"IF((A40)<>\"م\",(A40)+1,1)","v":38},25," test me",null,null,null,"2022-07-18"," ",null,{"$f":"SUMIFS(H$4:H41,B$4:B41,B41)-SUMIFS(I$4:I41,B$4:B41,B41)","v":0},null,null,null,null,null,"رصيد افتتاحي","يوليو",null,null,{"$f":"IF(ISBLANK(G41),0,MONTH(G41))","v":7}]
[{"$f":"IF((A41)<>\"م\",(A41)+1,1)","v":39},24," test me",null,2,null,"2022-07-18",20,null,{"$f":"SUMIFS(H$4:H42,B$4:B42,B42)-SUMIFS(I$4:I42,B$4:B42,B42)","v":720},null,null,null,null,"cust","بيع اجل","يوليو",null,null,{"$f":"IF(ISBLANK(G42),0,MONTH(G42))","v":7},"test1"]
[{"$f":"IF((A42)<>\"م\",(A42)+1,1)","v":40},2,"test1",null,2,null,"2022-07-18",null,20,{"$f":"SUMIFS(H$4:H43,B$4:B43,B43)-SUMIFS(I$4:I43,B$4:B43,B43)","v":410},null,null,null,null,"fina","بيع اجل","يوليو",null,null,{"$f":"IF(ISBLANK(G43),0,MONTH(G43))","v":7}]

{"sheet":"يونيو","index":1,"n_rows":8,"n_cols":13,"rows_kept":8,"cut":false,"hidden":false,"merged":[[2,6,3,6],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5]]}
[null,null,null,null,null,null,null,null,null,"يونيو",2022,6]
[null,null,null,null,{"$f":"IFERROR(SUBTOTAL(9,E5:E20000),0)","v":240},null,null,{"$f":"IFERROR(SUBTOTAL(9,H5:H20000),0)","v":0},0,2160,2160,2160,2160]
["م","كود العميل"," ","التاريخ","القسط","الوكيل","عميل فرعى","رصيداول المده",null,"حركة",{"$f":"J1","v":"يونيو"},"الاجمالى"]
[null,null,null,null,null,null,null,"مدين ","دائن","مدين ","دائن","مدين ","دائن"]
[{"$f":"IF((A4)<>\"م\",(A4)+1,1)","v":1},2," مصطفى محمد سعد","2022-06-25",{"$f":"IFERROR(VLOOKUP(C5,[1]credit!D:N,10,FALSE),0)","v":120},{"$f":"IFERROR(VLOOKUP(C5,[1]credit!D:N,3,FALSE),0)","v":"test1"},{"$f":"IFERROR(VLOOKUP(C5,[1]credit!D:N,2,FALSE),0)","v":" احمد محمد سعد"},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B5,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B5,Accmove!T:T,\"<\"&L$1)>0,SUMIFS(Accmove!H:H,Accmove!B:B,B5,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B5,Accmove!T:T,\"<\"&L$1),0)","v":0},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B5,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B5,Accmove!T:T,\"<\"&L$1)<0,SUMIFS(Accmove!H:H,Accmove!B:B,B5,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B5,Accmove!T:T,\"<\"&L$1),0)*-1","v":0},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B5,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B5,Accmove!Q:Q,J$1)>0,SUMIFS(Accmove!H:H,Accmove!B:B,B5,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B5,Accmove!Q:Q,J$1),0)","v":1080},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B5,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B5,Accmove!Q:Q,J$1)<0,SUMIFS(Accmove!H:H,Accmove!B:B,B5,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B5,Accmove!Q:Q,J$1),0)*-1","v":0},{"$f":"IF(H5-I5+J5-K5>0,H5-I5+J5-K5,0)","v":1080},{"$f":"IF(H5-I5+J5-K5<0,H5-I5+J5-K5,0)*-1","v":0}]
[{"$f":"IF((A5)<>\"م\",(A5)+1,1)","v":2},1,"test1","2022-06-25",{"$f":"IFERROR(VLOOKUP(C6,[1]credit!D:N,10,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(C6,[1]credit!D:N,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(C6,[1]credit!D:N,2,FALSE),0)","v":0},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B6,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B6,Accmove!T:T,\"<\"&L$1)>0,SUMIFS(Accmove!H:H,Accmove!B:B,B6,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B6,Accmove!T:T,\"<\"&L$1),0)","v":0},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B6,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B6,Accmove!T:T,\"<\"&L$1)<0,SUMIFS(Accmove!H:H,Accmove!B:B,B6,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B6,Accmove!T:T,\"<\"&L$1),0)*-1","v":0},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B6,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B6,Accmove!Q:Q,J$1)>0,SUMIFS(Accmove!H:H,Accmove!B:B,B6,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B6,Accmove!Q:Q,J$1),0)","v":0},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B6,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B6,Accmove!Q:Q,J$1)<0,SUMIFS(Accmove!H:H,Accmove!B:B,B6,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B6,Accmove!Q:Q,J$1),0)*-1","v":1080},{"$f":"IF(H6-I6+J6-K6>0,H6-I6+J6-K6,0)","v":0},{"$f":"IF(H6-I6+J6-K6<0,H6-I6+J6-K6,0)*-1","v":1080}]
[{"$f":"IF((A6)<>\"م\",(A6)+1,1)","v":3},2," مصطفى محمد سعد","24/6/2022",{"$f":"IFERROR(VLOOKUP(C7,[1]credit!D:N,10,FALSE),0)","v":120},{"$f":"IFERROR(VLOOKUP(C7,[1]credit!D:N,3,FALSE),0)","v":"test1"},{"$f":"IFERROR(VLOOKUP(C7,[1]credit!D:N,2,FALSE),0)","v":" احمد محمد سعد"},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B7,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B7,Accmove!T:T,\"<\"&L$1)>0,SUMIFS(Accmove!H:H,Accmove!B:B,B7,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B7,Accmove!T:T,\"<\"&L$1),0)","v":0},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B7,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B7,Accmove!T:T,\"<\"&L$1)<0,SUMIFS(Accmove!H:H,Accmove!B:B,B7,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B7,Accmove!T:T,\"<\"&L$1),0)*-1","v":0},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B7,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B7,Accmove!Q:Q,J$1)>0,SUMIFS(Accmove!H:H,Accmove!B:B,B7,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B7,Accmove!Q:Q,J$1),0)","v":1080},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B7,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B7,Accmove!Q:Q,J$1)<0,SUMIFS(Accmove!H:H,Accmove!B:B,B7,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B7,Accmove!Q:Q,J$1),0)*-1","v":0},{"$f":"IF(H7-I7+J7-K7>0,H7-I7+J7-K7,0)","v":1080},{"$f":"IF(H7-I7+J7-K7<0,H7-I7+J7-K7,0)*-1","v":0}]
[{"$f":"IF((A7)<>\"م\",(A7)+1,1)","v":4},1,"ح/صندوق الاقساط","24/6/2022",{"$f":"IFERROR(VLOOKUP(C8,[1]credit!D:N,10,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(C8,[1]credit!D:N,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(C8,[1]credit!D:N,2,FALSE),0)","v":0},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B8,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B8,Accmove!T:T,\"<\"&L$1)>0,SUMIFS(Accmove!H:H,Accmove!B:B,B8,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B8,Accmove!T:T,\"<\"&L$1),0)","v":0},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B8,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B8,Accmove!T:T,\"<\"&L$1)<0,SUMIFS(Accmove!H:H,Accmove!B:B,B8,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B8,Accmove!T:T,\"<\"&L$1),0)*-1","v":0},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B8,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B8,Accmove!Q:Q,J$1)>0,SUMIFS(Accmove!H:H,Accmove!B:B,B8,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B8,Accmove!Q:Q,J$1),0)","v":0},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B8,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B8,Accmove!Q:Q,J$1)<0,SUMIFS(Accmove!H:H,Accmove!B:B,B8,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B8,Accmove!Q:Q,J$1),0)*-1","v":1080},{"$f":"IF(H8-I8+J8-K8>0,H8-I8+J8-K8,0)","v":0},{"$f":"IF(H8-I8+J8-K8<0,H8-I8+J8-K8,0)*-1","v":1080}]

{"sheet":"يوليو","index":2,"n_rows":17,"n_cols":13,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,6,3,6],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5]]}
[7,null,null,null,null,null,null,null,null,"يوليو",2022,7]
[null,null,null,null,{"$f":"IFERROR(SUBTOTAL(9,E5:E20000),0)","v":484},null,null,{"$f":"IFERROR(SUBTOTAL(9,H5:H20000),0)","v":5400},5400,1440,3600,3490,5650]
["م","كود العميل"," ","التاريخ","القسط","الوكيل","عميل فرعى","رصيداول المده",null,"حركة",{"$f":"J1","v":"يوليو"},"الاجمالى"]
[null,null,null,null,null,null,null,"مدين ","دائن","مدين ","دائن","مدين ","دائن"]
[{"$f":"IF((A4)<>\"م\",(A4)+1,1)","v":1},2," مصطفى محمد سعد","2022-07-05",{"$f":"IFERROR(VLOOKUP(C5,[1]credit!D:N,10,FALSE),0)","v":120},{"$f":"IFERROR(VLOOKUP(C5,[1]credit!D:N,3,FALSE),0)","v":"test1"},{"$f":"IFERROR(VLOOKUP(C5,[1]credit!D:N,2,FALSE),0)","v":" احمد محمد سعد"},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B5,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B5,Accmove!T:T,\"<\"&L$1)>0,SUMIFS(Accmove!H:H,Accmove!B:B,B5,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B5,Accmove!T:T,\"<\"&L$1),0)","v":1080},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B5,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B5,Accmove!T:T,\"<\"&L$1)<0,SUMIFS(Accmove!H:H,Accmove!B:B,B5,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B5,Accmove!T:T,\"<\"&L$1),0)*-1","v":0},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B5,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B5,Accmove!Q:Q,J$1)>0,SUMIFS(Accmove!H:H,Accmove!B:B,B5,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B5,Accmove!Q:Q,J$1),0)","v":0},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B5,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B5,Accmove!Q:Q,J$1)<0,SUMIFS(Accmove!H:H,Accmove!B:B,B5,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B5,Accmove!Q:Q,J$1),0)*-1","v":670},{"$f":"IF(H5-I5+J5-K5>0,H5-I5+J5-K5,0)","v":410},{"$f":"IF(H5-I5+J5-K5<0,H5-I5+J5-K5,0)*-1","v":0}]
[{"$f":"IF((A5)<>\"م\",(A5)+1,1)","v":2},1,"ح/صندوق الاقساط","2022-07-05",{"$f":"IFERROR(VLOOKUP(C6,[1]credit!D:N,10,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(C6,[1]credit!D:N,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(C6,[1]credit!D:N,2,FALSE),0)","v":0},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B6,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B6,Accmove!T:T,\"<\"&L$1)>0,SUMIFS(Accmove!H:H,Accmove!B:B,B6,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B6,Accmove!T:T,\"<\"&L$1),0)","v":0},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B6,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B6,Accmove!T:T,\"<\"&L$1)<0,SUMIFS(Accmove!H:H,Accmove!B:B,B6,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B6,Accmove!T:T,\"<\"&L$1),0)*-1","v":1080},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B6,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B6,Accmove!Q:Q,J$1)>0,SUMIFS(Accmove!H:H,Accmove!B:B,B6,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B6,Accmove!Q:Q,J$1),0)","v":0},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B6,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B6,Accmove!Q:Q,J$1)<0,SUMIFS(Accmove!H:H,Accmove!B:B,B6,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B6,Accmove!Q:Q,J$1),0)*-1","v":50},{"$f":"IF(H6-I6+J6-K6>0,H6-I6+J6-K6,0)","v":0},{"$f":"IF(H6-I6+J6-K6<0,H6-I6+J6-K6,0)*-1","v":1130}]
[{"$f":"IF((A6)<>\"م\",(A6)+1,1)","v":3},2," مصطفى محمد سعد","2022-07-05",{"$f":"IFERROR(VLOOKUP(C7,[1]credit!D:N,10,FALSE),0)","v":120},{"$f":"IFERROR(VLOOKUP(C7,[1]credit!D:N,3,FALSE),0)","v":"test1"},{"$f":"IFERROR(VLOOKUP(C7,[1]credit!D:N,2,FALSE),0)","v":" احمد محمد سعد"},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B7,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B7,Accmove!T:T,\"<\"&L$1)>0,SUMIFS(Accmove!H:H,Accmove!B:B,B7,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B7,Accmove!T:T,\"<\"&L$1),0)","v":1080},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B7,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B7,Accmove!T:T,\"<\"&L$1)<0,SUMIFS(Accmove!H:H,Accmove!B:B,B7,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B7,Accmove!T:T,\"<\"&L$1),0)*-1","v":0},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B7,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B7,Accmove!Q:Q,J$1)>0,SUMIFS(Accmove!H:H,Accmove!B:B,B7,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B7,Accmove!Q:Q,J$1),0)","v":0},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B7,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B7,Accmove!Q:Q,J$1)<0,SUMIFS(Accmove!H:H,Accmove!B:B,B7,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B7,Accmove!Q:Q,J$1),0)*-1","v":670},{"$f":"IF(H7-I7+J7-K7>0,H7-I7+J7-K7,0)","v":410},{"$f":"IF(H7-I7+J7-K7<0,H7-I7+J7-K7,0)*-1","v":0}]
[{"$f":"IF((A7)<>\"م\",(A7)+1,1)","v":4},1,"ح/صندوق الاقساط","2022-07-05",{"$f":"IFERROR(VLOOKUP(C8,[1]credit!D:N,10,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(C8,[1]credit!D:N,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(C8,[1]credit!D:N,2,FALSE),0)","v":0},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B8,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B8,Accmove!T:T,\"<\"&L$1)>0,SUMIFS(Accmove!H:H,Accmove!B:B,B8,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B8,Accmove!T:T,\"<\"&L$1),0)","v":0},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B8,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B8,Accmove!T:T,\"<\"&L$1)<0,SUMIFS(Accmove!H:H,Accmove!B:B,B8,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B8,Accmove!T:T,\"<\"&L$1),0)*-1","v":1080},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B8,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B8,Accmove!Q:Q,J$1)>0,SUMIFS(Accmove!H:H,Accmove!B:B,B8,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B8,Accmove!Q:Q,J$1),0)","v":0},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B8,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B8,Accmove!Q:Q,J$1)<0,SUMIFS(Accmove!H:H,Accmove!B:B,B8,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B8,Accmove!Q:Q,J$1),0)*-1","v":50},{"$f":"IF(H8-I8+J8-K8>0,H8-I8+J8-K8,0)","v":0},{"$f":"IF(H8-I8+J8-K8<0,H8-I8+J8-K8,0)*-1","v":1130}]
[{"$f":"IF((A8)<>\"م\",(A8)+1,1)","v":5},2," مصطفى محمد سعد","2022-07-05",{"$f":"IFERROR(VLOOKUP(C9,[1]credit!D:N,10,FALSE),0)","v":120},{"$f":"IFERROR(VLOOKUP(C9,[1]credit!D:N,3,FALSE),0)","v":"test1"},{"$f":"IFERROR(VLOOKUP(C9,[1]credit!D:N,2,FALSE),0)","v":" احمد محمد سعد"},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B9,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B9,Accmove!T:T,\"<\"&L$1)>0,SUMIFS(Accmove!H:H,Accmove!B:B,B9,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B9,Accmove!T:T,\"<\"&L$1),0)","v":1080},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B9,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B9,Accmove!T:T,\"<\"&L$1)<0,SUMIFS(Accmove!H:H,Accmove!B:B,B9,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B9,Accmove!T:T,\"<\"&L$1),0)*-1","v":0},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B9,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B9,Accmove!Q:Q,J$1)>0,SUMIFS(Accmove!H:H,Accmove!B:B,B9,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B9,Accmove!Q:Q,J$1),0)","v":0},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B9,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B9,Accmove!Q:Q,J$1)<0,SUMIFS(Accmove!H:H,Accmove!B:B,B9,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B9,Accmove!Q:Q,J$1),0)*-1","v":670},{"$f":"IF(H9-I9+J9-K9>0,H9-I9+J9-K9,0)","v":410},{"$f":"IF(H9-I9+J9-K9<0,H9-I9+J9-K9,0)*-1","v":0}]
[{"$f":"IF((A9)<>\"م\",(A9)+1,1)","v":6},1,"ح/صندوق الاقساط","2022-07-05",{"$f":"IFERROR(VLOOKUP(C10,[1]credit!D:N,10,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(C10,[1]credit!D:N,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(C10,[1]credit!D:N,2,FALSE),0)","v":0},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B10,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B10,Accmove!T:T,\"<\"&L$1)>0,SUMIFS(Accmove!H:H,Accmove!B:B,B10,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B10,Accmove!T:T,\"<\"&L$1),0)","v":0},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B10,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B10,Accmove!T:T,\"<\"&L$1)<0,SUMIFS(Accmove!H:H,Accmove!B:B,B10,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B10,Accmove!T:T,\"<\"&L$1),0)*-1","v":1080},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B10,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B10,Accmove!Q:Q,J$1)>0,SUMIFS(Accmove!H:H,Accmove!B:B,B10,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B10,Accmove!Q:Q,J$1),0)","v":0},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B10,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B10,Accmove!Q:Q,J$1)<0,SUMIFS(Accmove!H:H,Accmove!B:B,B10,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B10,Accmove!Q:Q,J$1),0)*-1","v":50},{"$f":"IF(H10-I10+J10-K10>0,H10-I10+J10-K10,0)","v":0},{"$f":"IF(H10-I10+J10-K10<0,H10-I10+J10-K10,0)*-1","v":1130}]
[{"$f":"IF((A10)<>\"م\",(A10)+1,1)","v":7},2," مصطفى محمد سعد","2022-07-05",{"$f":"IFERROR(VLOOKUP(C11,[1]credit!D:N,10,FALSE),0)","v":120},{"$f":"IFERROR(VLOOKUP(C11,[1]credit!D:N,3,FALSE),0)","v":"test1"},{"$f":"IFERROR(VLOOKUP(C11,[1]credit!D:N,2,FALSE),0)","v":" احمد محمد سعد"},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B11,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B11,Accmove!T:T,\"<\"&L$1)>0,SUMIFS(Accmove!H:H,Accmove!B:B,B11,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B11,Accmove!T:T,\"<\"&L$1),0)","v":1080},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B11,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B11,Accmove!T:T,\"<\"&L$1)<0,SUMIFS(Accmove!H:H,Accmove!B:B,B11,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B11,Accmove!T:T,\"<\"&L$1),0)*-1","v":0},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B11,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B11,Accmove!Q:Q,J$1)>0,SUMIFS(Accmove!H:H,Accmove!B:B,B11,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B11,Accmove!Q:Q,J$1),0)","v":0},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B11,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B11,Accmove!Q:Q,J$1)<0,SUMIFS(Accmove!H:H,Accmove!B:B,B11,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B11,Accmove!Q:Q,J$1),0)*-1","v":670},{"$f":"IF(H11-I11+J11-K11>0,H11-I11+J11-K11,0)","v":410},{"$f":"IF(H11-I11+J11-K11<0,H11-I11+J11-K11,0)*-1","v":0}]
[{"$f":"IF((A11)<>\"م\",(A11)+1,1)","v":8},1,"ح/صندوق الاقساط","2022-07-05",{"$f":"IFERROR(VLOOKUP(C12,[1]credit!D:N,10,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(C12,[1]credit!D:N,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(C12,[1]credit!D:N,2,FALSE),0)","v":0},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B12,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B12,Accmove!T:T,\"<\"&L$1)>0,SUMIFS(Accmove!H:H,Accmove!B:B,B12,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B12,Accmove!T:T,\"<\"&L$1),0)","v":0},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B12,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B12,Accmove!T:T,\"<\"&L$1)<0,SUMIFS(Accmove!H:H,Accmove!B:B,B12,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B12,Accmove!T:T,\"<\"&L$1),0)*-1","v":1080},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B12,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B12,Accmove!Q:Q,J$1)>0,SUMIFS(Accmove!H:H,Accmove!B:B,B12,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B12,Accmove!Q:Q,J$1),0)","v":0},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B12,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B12,Accmove!Q:Q,J$1)<0,SUMIFS(Accmove!H:H,Accmove!B:B,B12,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B12,Accmove!Q:Q,J$1),0)*-1","v":50},{"$f":"IF(H12-I12+J12-K12>0,H12-I12+J12-K12,0)","v":0},{"$f":"IF(H12-I12+J12-K12<0,H12-I12+J12-K12,0)*-1","v":1130}]
[{"$f":"IF((A12)<>\"م\",(A12)+1,1)","v":9},24,"test1","2022-07-05",{"$f":"IFERROR(VLOOKUP(C13,[1]credit!D:N,10,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(C13,[1]credit!D:N,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(C13,[1]credit!D:N,2,FALSE),0)","v":0},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B13,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B13,Accmove!T:T,\"<\"&L$1)>0,SUMIFS(Accmove!H:H,Accmove!B:B,B13,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B13,Accmove!T:T,\"<\"&L$1),0)","v":0},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B13,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B13,Accmove!T:T,\"<\"&L$1)<0,SUMIFS(Accmove!H:H,Accmove!B:B,B13,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B13,Accmove!T:T,\"<\"&L$1),0)*-1","v":0},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B13,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B13,Accmove!Q:Q,J$1)>0,SUMIFS(Accmove!H:H,Accmove!B:B,B13,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B13,Accmove!Q:Q,J$1),0)","v":720},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B13,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B13,Accmove!Q:Q,J$1)<0,SUMIFS(Accmove!H:H,Accmove!B:B,B13,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B13,Accmove!Q:Q,J$1),0)*-1","v":0},{"$f":"IF(H13-I13+J13-K13>0,H13-I13+J13-K13,0)","v":720},{"$f":"IF(H13-I13+J13-K13<0,H13-I13+J13-K13,0)*-1","v":0}]
[{"$f":"IF((A13)<>\"م\",(A13)+1,1)","v":10},1,"ح/صندوق الاقساط","2022-07-05",{"$f":"IFERROR(VLOOKUP(C14,[1]credit!D:N,10,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(C14,[1]credit!D:N,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(C14,[1]credit!D:N,2,FALSE),0)","v":0},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B14,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B14,Accmove!T:T,\"<\"&L$1)>0,SUMIFS(Accmove!H:H,Accmove!B:B,B14,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B14,Accmove!T:T,\"<\"&L$1),0)","v":0},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B14,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B14,Accmove!T:T,\"<\"&L$1)<0,SUMIFS(Accmove!H:H,Accmove!B:B,B14,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B14,Accmove!T:T,\"<\"&L$1),0)*-1","v":1080},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B14,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B14,Accmove!Q:Q,J$1)>0,SUMIFS(Accmove!H:H,Accmove!B:B,B14,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B14,Accmove!Q:Q,J$1),0)","v":0},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B14,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B14,Accmove!Q:Q,J$1)<0,SUMIFS(Accmove!H:H,Accmove!B:B,B14,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B14,Accmove!Q:Q,J$1),0)*-1","v":50},{"$f":"IF(H14-I14+J14-K14>0,H14-I14+J14-K14,0)","v":0},{"$f":"IF(H14-I14+J14-K14<0,H14-I14+J14-K14,0)*-1","v":1130}]
[{"$f":"IF((A14)<>\"م\",(A14)+1,1)","v":11},25," test me","2022-07-18",{"$f":"IFERROR(VLOOKUP(C15,[1]credit!D:N,10,FALSE),0)","v":2},{"$f":"IFERROR(VLOOKUP(C15,[1]credit!D:N,3,FALSE),0)","v":"test1"},{"$f":"IFERROR(VLOOKUP(C15,[1]credit!D:N,2,FALSE),0)","v":"test me"},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B15,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B15,Accmove!T:T,\"<\"&L$1)>0,SUMIFS(Accmove!H:H,Accmove!B:B,B15,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B15,Accmove!T:T,\"<\"&L$1),0)","v":0},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B15,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B15,Accmove!T:T,\"<\"&L$1)<0,SUMIFS(Accmove!H:H,Accmove!B:B,B15,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B15,Accmove!T:T,\"<\"&L$1),0)*-1","v":0},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B15,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B15,Accmove!Q:Q,J$1)>0,SUMIFS(Accmove!H:H,Accmove!B:B,B15,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B15,Accmove!Q:Q,J$1),0)","v":0},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B15,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B15,Accmove!Q:Q,J$1)<0,SUMIFS(Accmove!H:H,Accmove!B:B,B15,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B15,Accmove!Q:Q,J$1),0)*-1","v":0},{"$f":"IF(H15-I15+J15-K15>0,H15-I15+J15-K15,0)","v":0},{"$f":"IF(H15-I15+J15-K15<0,H15-I15+J15-K15,0)*-1","v":0}]
[{"$f":"IF((A15)<>\"م\",(A15)+1,1)","v":12},24," test me","2022-07-18",{"$f":"IFERROR(VLOOKUP(C16,[1]credit!D:N,10,FALSE),0)","v":2},{"$f":"IFERROR(VLOOKUP(C16,[1]credit!D:N,3,FALSE),0)","v":"test1"},{"$f":"IFERROR(VLOOKUP(C16,[1]credit!D:N,2,FALSE),0)","v":"test me"},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B16,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B16,Accmove!T:T,\"<\"&L$1)>0,SUMIFS(Accmove!H:H,Accmove!B:B,B16,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B16,Accmove!T:T,\"<\"&L$1),0)","v":0},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B16,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B16,Accmove!T:T,\"<\"&L$1)<0,SUMIFS(Accmove!H:H,Accmove!B:B,B16,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B16,Accmove!T:T,\"<\"&L$1),0)*-1","v":0},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B16,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B16,Accmove!Q:Q,J$1)>0,SUMIFS(Accmove!H:H,Accmove!B:B,B16,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B16,Accmove!Q:Q,J$1),0)","v":720},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B16,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B16,Accmove!Q:Q,J$1)<0,SUMIFS(Accmove!H:H,Accmove!B:B,B16,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B16,Accmove!Q:Q,J$1),0)*-1","v":0},{"$f":"IF(H16-I16+J16-K16>0,H16-I16+J16-K16,0)","v":720},{"$f":"IF(H16-I16+J16-K16<0,H16-I16+J16-K16,0)*-1","v":0}]
[{"$f":"IF((A16)<>\"م\",(A16)+1,1)","v":13},2,"test1","2022-07-18",{"$f":"IFERROR(VLOOKUP(C17,[1]credit!D:N,10,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(C17,[1]credit!D:N,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(C17,[1]credit!D:N,2,FALSE),0)","v":0},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B17,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B17,Accmove!T:T,\"<\"&L$1)>0,SUMIFS(Accmove!H:H,Accmove!B:B,B17,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B17,Accmove!T:T,\"<\"&L$1),0)","v":1080},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B17,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B17,Accmove!T:T,\"<\"&L$1)<0,SUMIFS(Accmove!H:H,Accmove!B:B,B17,Accmove!T:T,\"<\"&L$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B17,Accmove!T:T,\"<\"&L$1),0)*-1","v":0},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B17,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B17,Accmove!Q:Q,J$1)>0,SUMIFS(Accmove!H:H,Accmove!B:B,B17,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B17,Accmove!Q:Q,J$1),0)","v":0},{"$f":"IF(SUMIFS(Accmove!H:H,Accmove!B:B,B17,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B17,Accmove!Q:Q,J$1)<0,SUMIFS(Accmove!H:H,Accmove!B:B,B17,Accmove!Q:Q,J$1)-SUMIFS(Accmove!I:I,Accmove!B:B,B17,Accmove!Q:Q,J$1),0)*-1","v":670},{"$f":"IF(H17-I17+J17-K17>0,H17-I17+J17-K17,0)","v":410},{"$f":"IF(H17-I17+J17-K17<0,H17-I17+J17-K17,0)*-1","v":0}]